[ 'sqlFinalizer' => [ $o[1], ], 'resultSetMapping' => [ $o[2], ], 'parameterMappings' => [ [ 'slug' => [ 0, ], ], ], ], 'Doctrine\\ORM\\Query\\Exec\\SingleSelectSqlFinalizer' => [ 'sql' => [ 1 => 'SELECT p0_.id AS id_0, COALESCE(t1_.content, p0_.title) AS title_1, COALESCE(t2_.content, p0_.slug) AS slug_2, COALESCE(t3_.content, p0_.content) AS content_3, p0_.is_home AS is_home_4, p0_.is_legal AS is_legal_5, p0_.created_at AS created_at_6, p0_.updated_at AS updated_at_7, p0_.deleted_at AS deleted_at_8, p0_.is_active AS is_active_9, p0_.published_at AS published_at_10, p0_.is_in_sitemap AS is_in_sitemap_11, p0_.priority AS priority_12, p4_.id AS id_13, p4_.type AS type_14, COALESCE(t5_.content, p4_.data) AS data_15, p4_.position AS position_16, p6_.id AS id_17, p6_.type AS type_18, COALESCE(t7_.content, p6_.data) AS data_19, p6_.position AS position_20, p4_.page_id AS page_id_21, p4_.parent_id AS parent_id_22, p6_.page_id AS page_id_23, p6_.parent_id AS parent_id_24 FROM page p0_ LEFT JOIN `page_block` p4_ ON p0_.id = p4_.page_id LEFT JOIN `page_block` p6_ ON p4_.id = p6_.parent_id LEFT JOIN ext_translations t1_ ON t1_.locale = \'fr\' AND t1_.field = \'title\' AND t1_.object_class = \'App\\\\CMSBundle\\\\Entity\\\\Page\' AND t1_.foreign_key = p0_.id LEFT JOIN ext_translations t2_ ON t2_.locale = \'fr\' AND t2_.field = \'slug\' AND t2_.object_class = \'App\\\\CMSBundle\\\\Entity\\\\Page\' AND t2_.foreign_key = p0_.id LEFT JOIN ext_translations t3_ ON t3_.locale = \'fr\' AND t3_.field = \'content\' AND t3_.object_class = \'App\\\\CMSBundle\\\\Entity\\\\Page\' AND t3_.foreign_key = p0_.id LEFT JOIN ext_translations t5_ ON t5_.locale = \'fr\' AND t5_.field = \'data\' AND t5_.object_class = \'App\\\\CMSBundle\\\\Entity\\\\Block\' AND t5_.foreign_key = p4_.id LEFT JOIN ext_translations t7_ ON t7_.locale = \'fr\' AND t7_.field = \'data\' AND t7_.object_class = \'App\\\\CMSBundle\\\\Entity\\\\Block\' AND t7_.foreign_key = p6_.id WHERE COALESCE(t2_.content, p0_.slug) = ? AND p4_.parent_id IS NULL ORDER BY p4_.position ASC, p6_.position ASC', ], ], 'stdClass' => [ 'aliasMap' => [ 2 => [ 'p' => 'App\\CMSBundle\\Entity\\Page', 'b' => 'App\\CMSBundle\\Entity\\Block', 'bchildren' => 'App\\CMSBundle\\Entity\\Block', ], ], 'relationMap' => [ 2 => [ 'b' => 'blocks', 'bchildren' => 'children', ], ], 'parentAliasMap' => [ 2 => [ 'b' => 'p', 'bchildren' => 'b', ], ], 'fieldMappings' => [ 2 => [ 'id_0' => 'id', 'title_1' => 'title', 'slug_2' => 'slug', 'content_3' => 'content', 'is_home_4' => 'isHome', 'is_legal_5' => 'isLegal', 'created_at_6' => 'createdAt', 'updated_at_7' => 'updatedAt', 'deleted_at_8' => 'deletedAt', 'is_active_9' => 'isActive', 'published_at_10' => 'publishedAt', 'is_in_sitemap_11' => 'isInSitemap', 'priority_12' => 'priority', 'id_13' => 'id', 'type_14' => 'type', 'data_15' => 'data', 'position_16' => 'position', 'id_17' => 'id', 'type_18' => 'type', 'data_19' => 'data', 'position_20' => 'position', ], ], 'columnAliasMappings' => [ 2 => [ 'App\\CMSBundle\\Entity\\Page' => [ 'p' => [ 'id' => 'id_0', 'title' => 'title_1', 'slug' => 'slug_2', 'content' => 'content_3', 'isHome' => 'is_home_4', 'isLegal' => 'is_legal_5', 'createdAt' => 'created_at_6', 'updatedAt' => 'updated_at_7', 'deletedAt' => 'deleted_at_8', 'isActive' => 'is_active_9', 'publishedAt' => 'published_at_10', 'isInSitemap' => 'is_in_sitemap_11', 'priority' => 'priority_12', ], ], 'App\\CMSBundle\\Entity\\Block' => [ 'b' => [ 'id' => 'id_13', 'type' => 'type_14', 'data' => 'data_15', 'position' => 'position_16', ], 'bchildren' => [ 'id' => 'id_17', 'type' => 'type_18', 'data' => 'data_19', 'position' => 'position_20', ], ], ], ], 'enumMappings' => [ 2 => [ 'type_14' => 'App\\CMSBundle\\Enum\\BlockTypeEnum', 'type_18' => 'App\\CMSBundle\\Enum\\BlockTypeEnum', ], ], 'typeMappings' => [ 2 => [ 'page_id_21' => 'integer', 'parent_id_22' => 'integer', 'page_id_23' => 'integer', 'parent_id_24' => 'integer', ], ], 'entityMappings' => [ 2 => [ 'p' => null, ], ], 'metaMappings' => [ 2 => [ 'page_id_21' => 'page_id', 'parent_id_22' => 'parent_id', 'page_id_23' => 'page_id', 'parent_id_24' => 'parent_id', ], ], 'columnOwnerMap' => [ 2 => [ 'id_0' => 'p', 'title_1' => 'p', 'slug_2' => 'p', 'content_3' => 'p', 'is_home_4' => 'p', 'is_legal_5' => 'p', 'created_at_6' => 'p', 'updated_at_7' => 'p', 'deleted_at_8' => 'p', 'is_active_9' => 'p', 'published_at_10' => 'p', 'is_in_sitemap_11' => 'p', 'priority_12' => 'p', 'id_13' => 'b', 'type_14' => 'b', 'data_15' => 'b', 'position_16' => 'b', 'id_17' => 'bchildren', 'type_18' => 'bchildren', 'data_19' => 'bchildren', 'position_20' => 'bchildren', 'page_id_21' => 'b', 'parent_id_22' => 'b', 'page_id_23' => 'bchildren', 'parent_id_24' => 'bchildren', ], ], 'declaringClasses' => [ 2 => [ 'id_0' => 'App\\CMSBundle\\Entity\\Page', 'title_1' => 'App\\CMSBundle\\Entity\\Page', 'slug_2' => 'App\\CMSBundle\\Entity\\Page', 'content_3' => 'App\\CMSBundle\\Entity\\Page', 'is_home_4' => 'App\\CMSBundle\\Entity\\Page', 'is_legal_5' => 'App\\CMSBundle\\Entity\\Page', 'created_at_6' => 'App\\CMSBundle\\Entity\\Page', 'updated_at_7' => 'App\\CMSBundle\\Entity\\Page', 'deleted_at_8' => 'App\\CMSBundle\\Entity\\Page', 'is_active_9' => 'App\\CMSBundle\\Entity\\Page', 'published_at_10' => 'App\\CMSBundle\\Entity\\Page', 'is_in_sitemap_11' => 'App\\CMSBundle\\Entity\\Page', 'priority_12' => 'App\\CMSBundle\\Entity\\Page', 'id_13' => 'App\\CMSBundle\\Entity\\Block', 'type_14' => 'App\\CMSBundle\\Entity\\Block', 'data_15' => 'App\\CMSBundle\\Entity\\Block', 'position_16' => 'App\\CMSBundle\\Entity\\Block', 'id_17' => 'App\\CMSBundle\\Entity\\Block', 'type_18' => 'App\\CMSBundle\\Entity\\Block', 'data_19' => 'App\\CMSBundle\\Entity\\Block', 'position_20' => 'App\\CMSBundle\\Entity\\Block', ], ], ], ], $o[0], [] ); } }];