[ 'sql' => [ 1 => 'SELECT c0_.id AS id_0, c0_.updated_at AS updated_at_1, c0_.created_at AS created_at_2, c0_.title AS title_3, c0_.sort_order AS sort_order_4, c0_.vimeo_id AS vimeo_id_5, c0_.video_duration AS video_duration_6, t1_.id AS id_7, t1_.title AS title_8, t1_.updated_at AS updated_at_9, t1_.created_at AS created_at_10, t1_.sort_order AS sort_order_11, t1_.intro AS intro_12, q2_.id AS id_13, q2_.updated_at AS updated_at_14, q2_.created_at AS created_at_15, q2_.title AS title_16, q2_.sort_order AS sort_order_17, q2_.type AS type_18, q2_.time_marker AS time_marker_19, q2_.metric AS metric_20, q2_.question_element AS question_element_21, q2_.image AS image_22, q2_.image_layout AS image_layout_23, q2_.description AS description_24, q2_.button_text AS button_text_25, c0_.topic_id AS topic_id_26, t1_.training_id AS training_id_27, q2_.chapter_id AS chapter_id_28 FROM chapter c0_ INNER JOIN topic t1_ ON c0_.topic_id = t1_.id LEFT JOIN question q2_ ON c0_.id = q2_.chapter_id WHERE c0_.id = ? ORDER BY q2_.sort_order ASC', ], ], 'stdClass' => [ 'aliasMap' => [ 2 => [ 'o' => 'App\\Entity\\Chapter', 'topic_a1' => 'App\\Entity\\Topic', 'questions_a2' => 'App\\Entity\\Question', ], ], 'relationMap' => [ 2 => [ 'topic_a1' => 'topic', 'questions_a2' => 'questions', ], ], 'parentAliasMap' => [ 2 => [ 'topic_a1' => 'o', 'questions_a2' => 'o', ], ], 'fieldMappings' => [ 2 => [ 'id_0' => 'id', 'updated_at_1' => 'updatedAt', 'created_at_2' => 'createdAt', 'title_3' => 'title', 'sort_order_4' => 'sortOrder', 'vimeo_id_5' => 'vimeoId', 'video_duration_6' => 'videoDuration', 'id_7' => 'id', 'title_8' => 'title', 'updated_at_9' => 'updatedAt', 'created_at_10' => 'createdAt', 'sort_order_11' => 'sortOrder', 'intro_12' => 'intro', 'id_13' => 'id', 'updated_at_14' => 'updatedAt', 'created_at_15' => 'createdAt', 'title_16' => 'title', 'sort_order_17' => 'sortOrder', 'type_18' => 'type', 'time_marker_19' => 'timeMarker', 'metric_20' => 'metric', 'question_element_21' => 'questionElement', 'image_22' => 'image', 'image_layout_23' => 'imageLayout', 'description_24' => 'description', 'button_text_25' => 'buttonText', ], ], 'columnAliasMappings' => [ 2 => [ 'App\\Entity\\Chapter' => [ 'o' => [ 'id' => 'id_0', 'updatedAt' => 'updated_at_1', 'createdAt' => 'created_at_2', 'title' => 'title_3', 'sortOrder' => 'sort_order_4', 'vimeoId' => 'vimeo_id_5', 'videoDuration' => 'video_duration_6', ], ], 'App\\Entity\\Topic' => [ 'topic_a1' => [ 'id' => 'id_7', 'title' => 'title_8', 'updatedAt' => 'updated_at_9', 'createdAt' => 'created_at_10', 'sortOrder' => 'sort_order_11', 'intro' => 'intro_12', ], ], 'App\\Entity\\Question' => [ 'questions_a2' => [ 'id' => 'id_13', 'updatedAt' => 'updated_at_14', 'createdAt' => 'created_at_15', 'title' => 'title_16', 'sortOrder' => 'sort_order_17', 'type' => 'type_18', 'timeMarker' => 'time_marker_19', 'metric' => 'metric_20', 'questionElement' => 'question_element_21', 'image' => 'image_22', 'imageLayout' => 'image_layout_23', 'description' => 'description_24', 'buttonText' => 'button_text_25', ], ], ], ], 'enumMappings' => [ 2 => [ 'type_18' => 'App\\Enum\\QuestionType', 'image_layout_23' => 'App\\Enum\\ImageLayout', ], ], 'typeMappings' => [ 2 => [ 'topic_id_26' => 'guid', 'training_id_27' => 'guid', 'chapter_id_28' => 'guid', ], ], 'entityMappings' => [ 2 => [ 'o' => null, ], ], 'metaMappings' => [ 2 => [ 'topic_id_26' => 'topic_id', 'training_id_27' => 'training_id', 'chapter_id_28' => 'chapter_id', ], ], 'columnOwnerMap' => [ 2 => [ 'id_0' => 'o', 'updated_at_1' => 'o', 'created_at_2' => 'o', 'title_3' => 'o', 'sort_order_4' => 'o', 'vimeo_id_5' => 'o', 'video_duration_6' => 'o', 'id_7' => 'topic_a1', 'title_8' => 'topic_a1', 'updated_at_9' => 'topic_a1', 'created_at_10' => 'topic_a1', 'sort_order_11' => 'topic_a1', 'intro_12' => 'topic_a1', 'id_13' => 'questions_a2', 'updated_at_14' => 'questions_a2', 'created_at_15' => 'questions_a2', 'title_16' => 'questions_a2', 'sort_order_17' => 'questions_a2', 'type_18' => 'questions_a2', 'time_marker_19' => 'questions_a2', 'metric_20' => 'questions_a2', 'question_element_21' => 'questions_a2', 'image_22' => 'questions_a2', 'image_layout_23' => 'questions_a2', 'description_24' => 'questions_a2', 'button_text_25' => 'questions_a2', 'topic_id_26' => 'o', 'training_id_27' => 'topic_a1', 'chapter_id_28' => 'questions_a2', ], ], 'declaringClasses' => [ 2 => [ 'id_0' => 'App\\Entity\\Chapter', 'updated_at_1' => 'App\\Entity\\Chapter', 'created_at_2' => 'App\\Entity\\Chapter', 'title_3' => 'App\\Entity\\Chapter', 'sort_order_4' => 'App\\Entity\\Chapter', 'vimeo_id_5' => 'App\\Entity\\Chapter', 'video_duration_6' => 'App\\Entity\\Chapter', 'id_7' => 'App\\Entity\\Topic', 'title_8' => 'App\\Entity\\Topic', 'updated_at_9' => 'App\\Entity\\Topic', 'created_at_10' => 'App\\Entity\\Topic', 'sort_order_11' => 'App\\Entity\\Topic', 'intro_12' => 'App\\Entity\\Topic', 'id_13' => 'App\\Entity\\Question', 'updated_at_14' => 'App\\Entity\\Question', 'created_at_15' => 'App\\Entity\\Question', 'title_16' => 'App\\Entity\\Question', 'sort_order_17' => 'App\\Entity\\Question', 'type_18' => 'App\\Entity\\Question', 'time_marker_19' => 'App\\Entity\\Question', 'metric_20' => 'App\\Entity\\Question', 'question_element_21' => 'App\\Entity\\Question', 'image_22' => 'App\\Entity\\Question', 'image_layout_23' => 'App\\Entity\\Question', 'description_24' => 'App\\Entity\\Question', 'button_text_25' => 'App\\Entity\\Question', ], ], ], ], $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, ], ], ], ] ); } }];