[ 'sqlFinalizer' => [ $o[1], ], 'resultSetMapping' => [ $o[2], ], 'parameterMappings' => [ [ 'category_param' => [ 0, ], 'slug' => [ 1, ], ], ], ], 'Doctrine\\ORM\\Query\\Exec\\SingleSelectSqlFinalizer' => [ 'sql' => [ 1 => 'SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.slug AS slug_2, c0_.description AS description_3, p1_.id AS id_4, p1_.title AS title_5, p1_.price AS price_6, p1_.color AS color_7, p1_.config AS config_8, p1_.stock AS stock_9, p1_.create_at AS create_at_10, p1_.update_at AS update_at_11, p1_.main_image AS main_image_12, p1_.sound AS sound_13, p1_.slug AS slug_14, p1_.short_description AS short_description_15, p1_.long_description AS long_description_16, p1_.alt AS alt_17, p1_.active AS active_18, p1_.is_visible AS is_visible_19, p1_.meta_title AS meta_title_20, p1_.meta_description AS meta_description_21, c0_.parent_id AS parent_id_22, p1_.category_id AS category_id_23, p1_.combination_id AS combination_id_24 FROM category c0_ LEFT JOIN category_product c2_ ON c0_.id = c2_.category_id LEFT JOIN product p1_ ON p1_.id = c2_.product_id AND ((p1_.category_id = c0_.id OR EXISTS (SELECT 1 FROM category_product c3_ WHERE c3_.product_id = p1_.id AND c3_.category_id IN (?))) AND p1_.active = 1) WHERE c0_.slug = ?', ], ], 'stdClass' => [ 'aliasMap' => [ 2 => [ 'c' => 'App\\Entity\\Category', 'p' => 'App\\Entity\\Product', ], ], 'relationMap' => [ 2 => [ 'p' => 'products', ], ], 'parentAliasMap' => [ 2 => [ 'p' => 'c', ], ], 'fieldMappings' => [ 2 => [ 'id_0' => 'id', 'title_1' => 'title', 'slug_2' => 'slug', 'description_3' => 'description', 'id_4' => 'id', 'title_5' => 'title', 'price_6' => 'price', 'color_7' => 'color', 'config_8' => 'config', 'stock_9' => 'stock', 'create_at_10' => 'createAt', 'update_at_11' => 'updateAt', 'main_image_12' => 'mainImage', 'sound_13' => 'sound', 'slug_14' => 'slug', 'short_description_15' => 'shortDescription', 'long_description_16' => 'longDescription', 'alt_17' => 'alt', 'active_18' => 'active', 'is_visible_19' => 'isVisible', 'meta_title_20' => 'metaTitle', 'meta_description_21' => 'metaDescription', ], ], 'columnAliasMappings' => [ 2 => [ 'App\\Entity\\Category' => [ 'c' => [ 'id' => 'id_0', 'title' => 'title_1', 'slug' => 'slug_2', 'description' => 'description_3', ], ], 'App\\Entity\\Product' => [ 'p' => [ 'id' => 'id_4', 'title' => 'title_5', 'price' => 'price_6', 'color' => 'color_7', 'config' => 'config_8', 'stock' => 'stock_9', 'createAt' => 'create_at_10', 'updateAt' => 'update_at_11', 'mainImage' => 'main_image_12', 'sound' => 'sound_13', 'slug' => 'slug_14', 'shortDescription' => 'short_description_15', 'longDescription' => 'long_description_16', 'alt' => 'alt_17', 'active' => 'active_18', 'isVisible' => 'is_visible_19', 'metaTitle' => 'meta_title_20', 'metaDescription' => 'meta_description_21', ], ], ], ], 'typeMappings' => [ 2 => [ 'parent_id_22' => 'integer', 'category_id_23' => 'integer', 'combination_id_24' => 'integer', ], ], 'entityMappings' => [ 2 => [ 'c' => null, ], ], 'metaMappings' => [ 2 => [ 'parent_id_22' => 'parent_id', 'category_id_23' => 'category_id', 'combination_id_24' => 'combination_id', ], ], 'columnOwnerMap' => [ 2 => [ 'id_0' => 'c', 'title_1' => 'c', 'slug_2' => 'c', 'description_3' => 'c', 'id_4' => 'p', 'title_5' => 'p', 'price_6' => 'p', 'color_7' => 'p', 'config_8' => 'p', 'stock_9' => 'p', 'create_at_10' => 'p', 'update_at_11' => 'p', 'main_image_12' => 'p', 'sound_13' => 'p', 'slug_14' => 'p', 'short_description_15' => 'p', 'long_description_16' => 'p', 'alt_17' => 'p', 'active_18' => 'p', 'is_visible_19' => 'p', 'meta_title_20' => 'p', 'meta_description_21' => 'p', 'parent_id_22' => 'c', 'category_id_23' => 'p', 'combination_id_24' => 'p', ], ], 'declaringClasses' => [ 2 => [ 'id_0' => 'App\\Entity\\Category', 'title_1' => 'App\\Entity\\Category', 'slug_2' => 'App\\Entity\\Category', 'description_3' => 'App\\Entity\\Category', 'id_4' => 'App\\Entity\\Product', 'title_5' => 'App\\Entity\\Product', 'price_6' => 'App\\Entity\\Product', 'color_7' => 'App\\Entity\\Product', 'config_8' => 'App\\Entity\\Product', 'stock_9' => 'App\\Entity\\Product', 'create_at_10' => 'App\\Entity\\Product', 'update_at_11' => 'App\\Entity\\Product', 'main_image_12' => 'App\\Entity\\Product', 'sound_13' => 'App\\Entity\\Product', 'slug_14' => 'App\\Entity\\Product', 'short_description_15' => 'App\\Entity\\Product', 'long_description_16' => 'App\\Entity\\Product', 'alt_17' => 'App\\Entity\\Product', 'active_18' => 'App\\Entity\\Product', 'is_visible_19' => 'App\\Entity\\Product', 'meta_title_20' => 'App\\Entity\\Product', 'meta_description_21' => 'App\\Entity\\Product', ], ], ], ], $o[0], [] ); } }];