[ 'sql' => [ 1 => 'SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.updated_at AS updated_at_2, t0_.created_at AS created_at_3, t0_.sort_order AS sort_order_4, t0_.intro AS intro_5, t1_.id AS id_6, t1_.updated_at AS updated_at_7, t1_.created_at AS created_at_8, t1_.title AS title_9, t1_.language AS language_10, t1_.country AS country_11, t1_.category AS category_12, t1_.version AS version_13, t1_.published_at AS published_at_14, t1_.published AS published_15, c2_.id AS id_16, c2_.updated_at AS updated_at_17, c2_.created_at AS created_at_18, c2_.title AS title_19, c2_.sort_order AS sort_order_20, c2_.vimeo_id AS vimeo_id_21, c2_.video_duration AS video_duration_22, t0_.training_id AS training_id_23, t1_.previous_version_id AS previous_version_id_24, c2_.topic_id AS topic_id_25 FROM topic t0_ INNER JOIN training t1_ ON t0_.training_id = t1_.id LEFT JOIN chapter c2_ ON t0_.id = c2_.topic_id WHERE t0_.id = ? ORDER BY c2_.sort_order ASC', ], ], 'stdClass' => [ 'aliasMap' => [ 2 => [ 'o' => 'App\\Entity\\Topic', 'training_a1' => 'App\\Entity\\Training', 'chapters_a2' => 'App\\Entity\\Chapter', ], ], 'relationMap' => [ 2 => [ 'training_a1' => 'training', 'chapters_a2' => 'chapters', ], ], 'parentAliasMap' => [ 2 => [ 'training_a1' => 'o', 'chapters_a2' => 'o', ], ], 'fieldMappings' => [ 2 => [ 'id_0' => 'id', 'title_1' => 'title', 'updated_at_2' => 'updatedAt', 'created_at_3' => 'createdAt', 'sort_order_4' => 'sortOrder', 'intro_5' => 'intro', 'id_6' => 'id', 'updated_at_7' => 'updatedAt', 'created_at_8' => 'createdAt', 'title_9' => 'title', 'language_10' => 'language', 'country_11' => 'country', 'category_12' => 'category', 'version_13' => 'version', 'published_at_14' => 'publishedAt', 'published_15' => 'published', 'id_16' => 'id', 'updated_at_17' => 'updatedAt', 'created_at_18' => 'createdAt', 'title_19' => 'title', 'sort_order_20' => 'sortOrder', 'vimeo_id_21' => 'vimeoId', 'video_duration_22' => 'videoDuration', ], ], 'columnAliasMappings' => [ 2 => [ 'App\\Entity\\Topic' => [ 'o' => [ 'id' => 'id_0', 'title' => 'title_1', 'updatedAt' => 'updated_at_2', 'createdAt' => 'created_at_3', 'sortOrder' => 'sort_order_4', 'intro' => 'intro_5', ], ], 'App\\Entity\\Training' => [ 'training_a1' => [ 'id' => 'id_6', 'updatedAt' => 'updated_at_7', 'createdAt' => 'created_at_8', 'title' => 'title_9', 'language' => 'language_10', 'country' => 'country_11', 'category' => 'category_12', 'version' => 'version_13', 'publishedAt' => 'published_at_14', 'published' => 'published_15', ], ], 'App\\Entity\\Chapter' => [ 'chapters_a2' => [ 'id' => 'id_16', 'updatedAt' => 'updated_at_17', 'createdAt' => 'created_at_18', 'title' => 'title_19', 'sortOrder' => 'sort_order_20', 'vimeoId' => 'vimeo_id_21', 'videoDuration' => 'video_duration_22', ], ], ], ], 'enumMappings' => [ 2 => [ 'category_12' => 'App\\Enum\\Category', ], ], 'typeMappings' => [ 2 => [ 'training_id_23' => 'guid', 'previous_version_id_24' => 'guid', 'topic_id_25' => 'guid', ], ], 'entityMappings' => [ 2 => [ 'o' => null, ], ], 'metaMappings' => [ 2 => [ 'training_id_23' => 'training_id', 'previous_version_id_24' => 'previous_version_id', 'topic_id_25' => 'topic_id', ], ], 'columnOwnerMap' => [ 2 => [ 'id_0' => 'o', 'title_1' => 'o', 'updated_at_2' => 'o', 'created_at_3' => 'o', 'sort_order_4' => 'o', 'intro_5' => 'o', 'id_6' => 'training_a1', 'updated_at_7' => 'training_a1', 'created_at_8' => 'training_a1', 'title_9' => 'training_a1', 'language_10' => 'training_a1', 'country_11' => 'training_a1', 'category_12' => 'training_a1', 'version_13' => 'training_a1', 'published_at_14' => 'training_a1', 'published_15' => 'training_a1', 'id_16' => 'chapters_a2', 'updated_at_17' => 'chapters_a2', 'created_at_18' => 'chapters_a2', 'title_19' => 'chapters_a2', 'sort_order_20' => 'chapters_a2', 'vimeo_id_21' => 'chapters_a2', 'video_duration_22' => 'chapters_a2', 'training_id_23' => 'o', 'previous_version_id_24' => 'training_a1', 'topic_id_25' => 'chapters_a2', ], ], 'declaringClasses' => [ 2 => [ 'id_0' => 'App\\Entity\\Topic', 'title_1' => 'App\\Entity\\Topic', 'updated_at_2' => 'App\\Entity\\Topic', 'created_at_3' => 'App\\Entity\\Topic', 'sort_order_4' => 'App\\Entity\\Topic', 'intro_5' => 'App\\Entity\\Topic', 'id_6' => 'App\\Entity\\Training', 'updated_at_7' => 'App\\Entity\\Training', 'created_at_8' => 'App\\Entity\\Training', 'title_9' => 'App\\Entity\\Training', 'language_10' => 'App\\Entity\\Training', 'country_11' => 'App\\Entity\\Training', 'category_12' => 'App\\Entity\\Training', 'version_13' => 'App\\Entity\\Training', 'published_at_14' => 'App\\Entity\\Training', 'published_15' => 'App\\Entity\\Training', 'id_16' => 'App\\Entity\\Chapter', 'updated_at_17' => 'App\\Entity\\Chapter', 'created_at_18' => 'App\\Entity\\Chapter', 'title_19' => 'App\\Entity\\Chapter', 'sort_order_20' => 'App\\Entity\\Chapter', 'vimeo_id_21' => 'App\\Entity\\Chapter', 'video_duration_22' => 'App\\Entity\\Chapter', ], ], ], ], $o[0], [ [ "\0".'Doctrine\\ORM\\Query\\ParserResult'."\0".'sqlExecutor' => null, "\0".'Doctrine\\ORM\\Query\\ParserResult'."\0".'sqlFinalizer' => $o[1], "\0".'Doctrine\\ORM\\Query\\ParserResult'."\0".'resultSetMapping' => $o[2], "\0".'Doctrine\\ORM\\Query\\ParserResult'."\0".'parameterMappings' => [ 'id_p1' => [ 0, ], ], ], ] ); } }];