| 1 |
1.36 ms
|
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4, c1_.id AS id_5, c1_.position AS position_6, c1_.type AS type_7, c1_.label AS label_8, c1_.url AS url_9, c1_.open_in_new_window AS open_in_new_window_10, c2_.id AS id_11, c2_.position AS position_12, c2_.type AS type_13, c2_.label AS label_14, c2_.url AS url_15, c2_.open_in_new_window AS open_in_new_window_16, c3_.id AS id_17, c3_.name AS name_18, c3_.created_at AS created_at_19, c3_.updated_at AS updated_at_20, c3_.type AS type_21, c3_.slug AS slug_22, c3_.published_at AS published_at_23, c3_.public AS public_24, c3_.template AS template_25, c3_.exclude_from_sitemap AS exclude_from_sitemap_26, c3_.content_updated_at AS content_updated_at_27, p4_.headline AS headline_28, p4_.intro_text AS intro_text_29, p4_.invalid_text AS invalid_text_30, c1_.menu_id AS menu_id_31, c1_.parent_id AS parent_id_32, c1_.page_id AS page_id_33, c2_.menu_id AS menu_id_34, c2_.parent_id AS parent_id_35, c2_.page_id AS page_id_36, c3_.discriminator AS discriminator_37, c3_.author_id AS author_id_38, c3_.parent_page_id AS parent_page_id_39, p4_.player_media_id AS player_media_id_40 FROM core_menu c0_ LEFT JOIN core_menu_item c1_ ON c0_.id = c1_.menu_id LEFT JOIN core_menu_item c2_ ON c1_.id = c2_.parent_id LEFT JOIN core_abstract_page c3_ ON c1_.page_id = c3_.id LEFT JOIN player_seite p4_ ON c3_.id = p4_.id LEFT JOIN core_page c5_ ON c3_.id = c5_.id WHERE c0_.id = ? ORDER BY c1_.position ASC, c2_.position ASC
SELECT
c0_.id AS id_0,
c0_.name AS name_1,
c0_.slug AS slug_2,
c0_.created_at AS created_at_3,
c0_.updated_at AS updated_at_4,
c1_.id AS id_5,
c1_.position AS position_6,
c1_.type AS type_7,
c1_.label AS label_8,
c1_.url AS url_9,
c1_.open_in_new_window AS open_in_new_window_10,
c2_.id AS id_11,
c2_.position AS position_12,
c2_.type AS type_13,
c2_.label AS label_14,
c2_.url AS url_15,
c2_.open_in_new_window AS open_in_new_window_16,
c3_.id AS id_17,
c3_.name AS name_18,
c3_.created_at AS created_at_19,
c3_.updated_at AS updated_at_20,
c3_.type AS type_21,
c3_.slug AS slug_22,
c3_.published_at AS published_at_23,
c3_.public AS public_24,
c3_.template AS template_25,
c3_.exclude_from_sitemap AS exclude_from_sitemap_26,
c3_.content_updated_at AS content_updated_at_27,
p4_.headline AS headline_28,
p4_.intro_text AS intro_text_29,
p4_.invalid_text AS invalid_text_30,
c1_.menu_id AS menu_id_31,
c1_.parent_id AS parent_id_32,
c1_.page_id AS page_id_33,
c2_.menu_id AS menu_id_34,
c2_.parent_id AS parent_id_35,
c2_.page_id AS page_id_36,
c3_.discriminator AS discriminator_37,
c3_.author_id AS author_id_38,
c3_.parent_page_id AS parent_page_id_39,
p4_.player_media_id AS player_media_id_40
FROM
core_menu c0_
LEFT JOIN core_menu_item c1_ ON c0_.id = c1_.menu_id
LEFT JOIN core_menu_item c2_ ON c1_.id = c2_.parent_id
LEFT JOIN core_abstract_page c3_ ON c1_.page_id = c3_.id
LEFT JOIN player_seite p4_ ON c3_.id = p4_.id
LEFT JOIN core_page c5_ ON c3_.id = c5_.id
WHERE
c0_.id = ?
ORDER BY
c1_.position ASC,
c2_.position ASC
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4, c1_.id AS id_5, c1_.position AS position_6, c1_.type AS type_7, c1_.label AS label_8, c1_.url AS url_9, c1_.open_in_new_window AS open_in_new_window_10, c2_.id AS id_11, c2_.position AS position_12, c2_.type AS type_13, c2_.label AS label_14, c2_.url AS url_15, c2_.open_in_new_window AS open_in_new_window_16, c3_.id AS id_17, c3_.name AS name_18, c3_.created_at AS created_at_19, c3_.updated_at AS updated_at_20, c3_.type AS type_21, c3_.slug AS slug_22, c3_.published_at AS published_at_23, c3_.public AS public_24, c3_.template AS template_25, c3_.exclude_from_sitemap AS exclude_from_sitemap_26, c3_.content_updated_at AS content_updated_at_27, p4_.headline AS headline_28, p4_.intro_text AS intro_text_29, p4_.invalid_text AS invalid_text_30, c1_.menu_id AS menu_id_31, c1_.parent_id AS parent_id_32, c1_.page_id AS page_id_33, c2_.menu_id AS menu_id_34, c2_.parent_id AS parent_id_35, c2_.page_id AS page_id_36, c3_.discriminator AS discriminator_37, c3_.author_id AS author_id_38, c3_.parent_page_id AS parent_page_id_39, p4_.player_media_id AS player_media_id_40 FROM core_menu c0_ LEFT JOIN core_menu_item c1_ ON c0_.id = c1_.menu_id LEFT JOIN core_menu_item c2_ ON c1_.id = c2_.parent_id LEFT JOIN core_abstract_page c3_ ON c1_.page_id = c3_.id LEFT JOIN player_seite p4_ ON c3_.id = p4_.id LEFT JOIN core_page c5_ ON c3_.id = c5_.id WHERE c0_.id = 1 ORDER BY c1_.position ASC, c2_.position ASC;
|