Symfony Profiler

Query Metrics

22 Database Queries

12 Different statements

22.43 ms Query time

0 Invalid entities

Queries


SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.logo AS logo_4, t0.domain AS domain_5, t0.matomo_id AS matomo_id_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t9.id AS id_10, t9.title_edito AS title_edito_11, t9.subtitle_edito AS subtitle_edito_12, t9.picture_edito AS picture_edito_13, t9.content_edito AS content_edito_14, t9.button_edito AS button_edito_15, t9.link_button_edito AS link_button_edito_16, t9.title_highlight AS title_highlight_17, t9.subtitle_highlight AS subtitle_highlight_18, t9.picture_highlight AS picture_highlight_19, t9.content_highlight AS content_highlight_20, t9.button_highlight AS button_highlight_21, t9.link_button_highlight AS link_button_highlight_22, t9.created_at AS created_at_23, t9.updated_at AS updated_at_24, t9.box_id AS box_id_25, t26.id AS id_27, t26.title_menu AS title_menu_28, t26.slug AS slug_29, t26.title AS title_30, t26.subtitle AS subtitle_31, t26.picture_introduction AS picture_introduction_32, t26.introduction AS introduction_33, t26.content AS content_34, t26.created_at AS created_at_35, t26.updated_at AS updated_at_36, t26.box_id AS box_id_37, t38.id AS id_39, t38.title_menu AS title_menu_40, t38.slug AS slug_41, t38.title AS title_42, t38.subtitle AS subtitle_43, t38.picture_introduction AS picture_introduction_44, t38.introduction AS introduction_45, t38.content AS content_46, t38.created_at AS created_at_47, t38.updated_at AS updated_at_48, t38.box_id AS box_id_49, t50.id AS id_51, t50.title_menu AS title_menu_52, t50.title AS title_53, t50.subtitle AS subtitle_54, t50.picture_introduction AS picture_introduction_55, t50.introduction AS introduction_56, t50.content AS content_57, t50.created_at AS created_at_58, t50.updated_at AS updated_at_59, t50.box_id AS box_id_60, t61.id AS id_62, t61.title_menu AS title_menu_63, t61.title AS title_64, t61.subtitle AS subtitle_65, t61.picture_introduction AS picture_introduction_66, t61.introduction AS introduction_67, t61.content AS content_68, t61.created_at AS created_at_69, t61.updated_at AS updated_at_70, t61.box_id AS box_id_71, t72.id AS id_73, t72.title_menu AS title_menu_74, t72.title AS title_75, t72.subtitle AS subtitle_76, t72.picture_introduction AS picture_introduction_77, t72.introduction AS introduction_78, t72.content AS content_79, t72.created_at AS created_at_80, t72.updated_at AS updated_at_81, t72.box_id AS box_id_82 FROM box__box t0 LEFT JOIN box__home t9 ON t9.box_id = t0.id LEFT JOIN box__custom t26 ON t26.box_id = t0.id LEFT JOIN box__custom_2 t38 ON t38.box_id = t0.id LEFT JOIN box__team t50 ON t50.box_id = t0.id LEFT JOIN box__who_are_we t61 ON t61.box_id = t0.id LEFT JOIN box__why_join t72 ON t72.box_id = t0.id WHERE t0.domain = ? LIMIT 1
SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.template AS template_2, c0_.slug AS slug_3, c0_.breadcrumb AS breadcrumb_4, c0_.active AS active_5, c0_.roles AS roles_6, c0_.lft AS lft_7, c0_.lvl AS lvl_8, c0_.rgt AS rgt_9, c0_.seo_title AS seo_title_10, c0_.seo_description AS seo_description_11, c0_.seo_keywords AS seo_keywords_12, c0_.og_title AS og_title_13, c0_.og_type AS og_type_14, c0_.og_description AS og_description_15, c0_.og_site_name AS og_site_name_16, c0_.twitter_card AS twitter_card_17, c0_.twitter_site AS twitter_site_18, c0_.twitter_title AS twitter_title_19, c0_.twitter_description AS twitter_description_20, c0_.twitter_creator AS twitter_creator_21, c0_.created_at AS created_at_22, c0_.updated_at AS updated_at_23, c1_.id AS id_24, c1_.name AS name_25, c1_.methods AS methods_26, c1_.path AS path_27, c1_.controller AS controller_28, c1_.defaults AS defaults_29, c1_.requirements AS requirements_30, c2_.id AS id_31, c2_.slug AS slug_32, c2_.label AS label_33, c2_.locale AS locale_34, c2_.host AS host_35, c2_.localhost AS localhost_36, c2_.host_multilingual AS host_multilingual_37, c2_.`default` AS default_38, c2_.flag_icon AS flag_icon_39, c2_.visible AS visible_40, c2_.template_filter AS template_filter_41, c3_.id AS id_42, c3_.title AS title_43, c3_.technic_name AS technic_name_44, c3_.locale AS locale_45, c3_.active AS active_46, c3_.params AS params_47, c3_.seo_title AS seo_title_48, c3_.seo_description AS seo_description_49, c3_.seo_keywords AS seo_keywords_50, c3_.og_title AS og_title_51, c3_.og_type AS og_type_52, c3_.og_description AS og_description_53, c3_.og_site_name AS og_site_name_54, c3_.twitter_card AS twitter_card_55, c3_.twitter_site AS twitter_site_56, c3_.twitter_title AS twitter_title_57, c3_.twitter_description AS twitter_description_58, c3_.twitter_creator AS twitter_creator_59, c0_.route_id AS route_id_60, c0_.site_id AS site_id_61, c0_.tree_root AS tree_root_62, c0_.parent_id AS parent_id_63, c0_.og_image_id AS og_image_id_64, c0_.twitter_image_id AS twitter_image_id_65, c1_.discr AS discr_66, c3_.page_id AS page_id_67, c3_.og_image_id AS og_image_id_68, c3_.twitter_image_id AS twitter_image_id_69 FROM cms__page c0_ LEFT JOIN cms__route c1_ ON c0_.route_id = c1_.id AND c1_.discr IN ('base') LEFT JOIN cms__site c2_ ON c0_.site_id = c2_.id LEFT JOIN cms__page_declination c3_ ON c0_.id = c3_.page_id WHERE c1_.name = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.picture AS picture_4, t0.link AS link_5, t0.begin_date AS begin_date_6, t0.end_date AS end_date_7, t0.extension_date AS extension_date_8, t0.document_order_public_enquiry AS document_order_public_enquiry_9, t0.document_notice_public_enquiry AS document_notice_public_enquiry_10, t0.document_report_public_enquiry AS document_report_public_enquiry_11, t0.document_decision AS document_decision_12, t0.link_order_public_enquiry AS link_order_public_enquiry_13, t0.link_notice_public_enquiry AS link_notice_public_enquiry_14, t0.link_report_public_enquiry AS link_report_public_enquiry_15, t0.link_decision AS link_decision_16, t0.publication_status AS publication_status_17, t0.is_published AS is_published_18, t0.nb_persons_received AS nb_persons_received_19, t0.nb_observations_filed AS nb_observations_filed_20, t0.nb_observations_numeric AS nb_observations_numeric_21, t0.nb_observations_paper AS nb_observations_paper_22, t0.nb_observations_oral AS nb_observations_oral_23, t0.nb_public_meeting_done AS nb_public_meeting_done_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26, t0.reportUpdatedAt AS reportUpdatedAt_27, t0.alert_sent_at AS alert_sent_at_28, t0.designation AS designation_29, t0.place AS place_30, t0.actors AS actors_31, t0.project_owner_type AS project_owner_type_32, t0.type_id AS type_id_33, t0.provider_id AS provider_id_34, t0.user_id AS user_id_35 FROM public_enquiry__public_enquiry t0 WHERE t0.id = ?
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.match_name AS match_name_2, d0_.code AS code_3, d0_.region_id AS region_id_4 FROM department d0_ ORDER BY d0_.name ASC
SELECT t0.id AS id_1, t0.title AS title_2, t0.template AS template_3, t0.slug AS slug_4, t0.breadcrumb AS breadcrumb_5, t0.active AS active_6, t0.roles AS roles_7, t0.lft AS lft_8, t0.lvl AS lvl_9, t0.rgt AS rgt_10, t0.seo_title AS seo_title_11, t0.seo_description AS seo_description_12, t0.seo_keywords AS seo_keywords_13, t0.og_title AS og_title_14, t0.og_type AS og_type_15, t0.og_description AS og_description_16, t0.og_site_name AS og_site_name_17, t0.twitter_card AS twitter_card_18, t0.twitter_site AS twitter_site_19, t0.twitter_title AS twitter_title_20, t0.twitter_description AS twitter_description_21, t0.twitter_creator AS twitter_creator_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.route_id AS route_id_25, t0.site_id AS site_id_26, t0.tree_root AS tree_root_27, t0.parent_id AS parent_id_28, t0.og_image_id AS og_image_id_29, t0.twitter_image_id AS twitter_image_id_30 FROM cms__page t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.template AS template_3, t0.slug AS slug_4, t0.breadcrumb AS breadcrumb_5, t0.active AS active_6, t0.roles AS roles_7, t0.lft AS lft_8, t0.lvl AS lvl_9, t0.rgt AS rgt_10, t0.seo_title AS seo_title_11, t0.seo_description AS seo_description_12, t0.seo_keywords AS seo_keywords_13, t0.og_title AS og_title_14, t0.og_type AS og_type_15, t0.og_description AS og_description_16, t0.og_site_name AS og_site_name_17, t0.twitter_card AS twitter_card_18, t0.twitter_site AS twitter_site_19, t0.twitter_title AS twitter_title_20, t0.twitter_description AS twitter_description_21, t0.twitter_creator AS twitter_creator_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.route_id AS route_id_25, t0.site_id AS site_id_26, t0.tree_root AS tree_root_27, t0.parent_id AS parent_id_28, t0.og_image_id AS og_image_id_29, t0.twitter_image_id AS twitter_image_id_30 FROM cms__page t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.type AS type_4, t0.site_id AS site_id_5 FROM cms__menu t0 WHERE t0.code = ? AND t0.site_id = ? LIMIT 1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.information AS information_2, c0_.link_type AS link_type_3, c0_.link_value AS link_value_4, c0_.is_visible AS is_visible_5, c0_.lvl AS lvl_6, c0_.lft AS lft_7, c0_.rgt AS rgt_8, c0_.li_class AS li_class_9, c0_.ul_class AS ul_class_10, c0_.link_class AS link_class_11, c0_.icon_class AS icon_class_12, c0_.connected AS connected_13, c0_.role AS role_14, c0_.params AS params_15, c0_.blank AS blank_16, c0_.anchor AS anchor_17, c1_.id AS id_18, c1_.title AS title_19, c1_.template AS template_20, c1_.slug AS slug_21, c1_.breadcrumb AS breadcrumb_22, c1_.active AS active_23, c1_.roles AS roles_24, c1_.lft AS lft_25, c1_.lvl AS lvl_26, c1_.rgt AS rgt_27, c1_.seo_title AS seo_title_28, c1_.seo_description AS seo_description_29, c1_.seo_keywords AS seo_keywords_30, c1_.og_title AS og_title_31, c1_.og_type AS og_type_32, c1_.og_description AS og_description_33, c1_.og_site_name AS og_site_name_34, c1_.twitter_card AS twitter_card_35, c1_.twitter_site AS twitter_site_36, c1_.twitter_title AS twitter_title_37, c1_.twitter_description AS twitter_description_38, c1_.twitter_creator AS twitter_creator_39, c1_.created_at AS created_at_40, c1_.updated_at AS updated_at_41, c2_.id AS id_42, c2_.name AS name_43, c2_.methods AS methods_44, c2_.path AS path_45, c2_.controller AS controller_46, c2_.defaults AS defaults_47, c2_.requirements AS requirements_48, c3_.id AS id_49, c3_.name AS name_50, c3_.information AS information_51, c3_.link_type AS link_type_52, c3_.link_value AS link_value_53, c3_.is_visible AS is_visible_54, c3_.lvl AS lvl_55, c3_.lft AS lft_56, c3_.rgt AS rgt_57, c3_.li_class AS li_class_58, c3_.ul_class AS ul_class_59, c3_.link_class AS link_class_60, c3_.icon_class AS icon_class_61, c3_.connected AS connected_62, c3_.role AS role_63, c3_.params AS params_64, c3_.blank AS blank_65, c3_.anchor AS anchor_66, c4_.id AS id_67, c4_.slug AS slug_68, c4_.label AS label_69, c4_.locale AS locale_70, c4_.host AS host_71, c4_.localhost AS localhost_72, c4_.host_multilingual AS host_multilingual_73, c4_.`default` AS default_74, c4_.flag_icon AS flag_icon_75, c4_.visible AS visible_76, c4_.template_filter AS template_filter_77, c5_.id AS id_78, c5_.code AS code_79, c5_.label AS label_80, c5_.type AS type_81, c5_.value AS value_82, c5_.position AS position_83, c5_.parent_heritance AS parent_heritance_84, c5_.active AS active_85, c0_.page_id AS page_id_86, c0_.tree_root AS tree_root_87, c0_.parent_id AS parent_id_88, c0_.menu_id AS menu_id_89, c1_.route_id AS route_id_90, c1_.site_id AS site_id_91, c1_.tree_root AS tree_root_92, c1_.parent_id AS parent_id_93, c1_.og_image_id AS og_image_id_94, c1_.twitter_image_id AS twitter_image_id_95, c2_.discr AS discr_96, c3_.page_id AS page_id_97, c3_.tree_root AS tree_root_98, c3_.parent_id AS parent_id_99, c3_.menu_id AS menu_id_100, c5_.page_id AS page_id_101, c5_.shared_block_parent_id AS shared_block_parent_id_102, c5_.declination_id AS declination_id_103 FROM cms__menu_item c0_ LEFT JOIN cms__page c1_ ON c0_.page_id = c1_.id LEFT JOIN cms__route c2_ ON c1_.route_id = c2_.id AND c2_.discr IN ('base') LEFT JOIN cms__menu_item c3_ ON c0_.id = c3_.parent_id LEFT JOIN cms__site c4_ ON c1_.site_id = c4_.id LEFT JOIN cms__content c5_ ON c1_.id = c5_.page_id WHERE c0_.menu_id = ? ORDER BY c0_.lft ASC, c3_.lft ASC, c5_.position ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.information AS information_3, t0.link_type AS link_type_4, t0.link_value AS link_value_5, t0.is_visible AS is_visible_6, t0.lvl AS lvl_7, t0.lft AS lft_8, t0.rgt AS rgt_9, t0.li_class AS li_class_10, t0.ul_class AS ul_class_11, t0.link_class AS link_class_12, t0.icon_class AS icon_class_13, t0.connected AS connected_14, t0.role AS role_15, t0.params AS params_16, t0.blank AS blank_17, t0.anchor AS anchor_18, t0.page_id AS page_id_19, t0.tree_root AS tree_root_20, t0.parent_id AS parent_id_21, t0.menu_id AS menu_id_22 FROM cms__menu_item t0 WHERE t0.menu_id = ?
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.locale AS locale_4, t0.host AS host_5, t0.localhost AS localhost_6, t0.host_multilingual AS host_multilingual_7, t0.`default` AS default_8, t0.flag_icon AS flag_icon_9, t0.visible AS visible_10, t0.template_filter AS template_filter_11 FROM cms__site t0 WHERE t0.`default` = ? LIMIT 1
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.label AS label_2, c0_.type AS type_3, c0_.value AS value_4, c0_.position AS position_5, c0_.parent_heritance AS parent_heritance_6, c0_.active AS active_7, c0_.page_id AS page_id_8, c0_.shared_block_parent_id AS shared_block_parent_id_9, c0_.declination_id AS declination_id_10 FROM cms__content c0_ WHERE c0_.code = ? AND c0_.page_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.locale AS locale_4, t0.host AS host_5, t0.localhost AS localhost_6, t0.host_multilingual AS host_multilingual_7, t0.`default` AS default_8, t0.flag_icon AS flag_icon_9, t0.visible AS visible_10, t0.template_filter AS template_filter_11 FROM cms__site t0 WHERE t0.`default` = ? LIMIT 1
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.label AS label_2, c0_.type AS type_3, c0_.value AS value_4, c0_.position AS position_5, c0_.parent_heritance AS parent_heritance_6, c0_.active AS active_7, c0_.page_id AS page_id_8, c0_.shared_block_parent_id AS shared_block_parent_id_9, c0_.declination_id AS declination_id_10 FROM cms__content c0_ WHERE c0_.code = ? AND c0_.page_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.match_name AS match_name_3, t0.code AS code_4, t0.region_id AS region_id_5 FROM department t0 INNER JOIN public_enquiry__public_enquiry_has_department ON t0.id = public_enquiry__public_enquiry_has_department.department_id WHERE public_enquiry__public_enquiry_has_department.public_enquiry_id = ?
SELECT t0.id AS id_1, t0.title AS title_2 FROM public_enquiry__type t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.locale AS locale_4, t0.host AS host_5, t0.localhost AS localhost_6, t0.host_multilingual AS host_multilingual_7, t0.`default` AS default_8, t0.flag_icon AS flag_icon_9, t0.visible AS visible_10, t0.template_filter AS template_filter_11 FROM cms__site t0 WHERE t0.`default` = ? LIMIT 1
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.label AS label_2, c0_.type AS type_3, c0_.value AS value_4, c0_.position AS position_5, c0_.parent_heritance AS parent_heritance_6, c0_.active AS active_7, c0_.page_id AS page_id_8, c0_.shared_block_parent_id AS shared_block_parent_id_9, c0_.declination_id AS declination_id_10 FROM cms__content c0_ WHERE c0_.code = ? AND c0_.page_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.locale AS locale_4, t0.host AS host_5, t0.localhost AS localhost_6, t0.host_multilingual AS host_multilingual_7, t0.`default` AS default_8, t0.flag_icon AS flag_icon_9, t0.visible AS visible_10, t0.template_filter AS template_filter_11 FROM cms__site t0 WHERE t0.`default` = ? LIMIT 1
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.label AS label_2, c0_.type AS type_3, c0_.value AS value_4, c0_.position AS position_5, c0_.parent_heritance AS parent_heritance_6, c0_.active AS active_7, c0_.page_id AS page_id_8, c0_.shared_block_parent_id AS shared_block_parent_id_9, c0_.declination_id AS declination_id_10 FROM cms__content c0_ WHERE c0_.code = ? AND c0_.page_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.type AS type_4, t0.site_id AS site_id_5 FROM cms__menu t0 WHERE t0.code = ? AND t0.site_id = ? LIMIT 1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.information AS information_2, c0_.link_type AS link_type_3, c0_.link_value AS link_value_4, c0_.is_visible AS is_visible_5, c0_.lvl AS lvl_6, c0_.lft AS lft_7, c0_.rgt AS rgt_8, c0_.li_class AS li_class_9, c0_.ul_class AS ul_class_10, c0_.link_class AS link_class_11, c0_.icon_class AS icon_class_12, c0_.connected AS connected_13, c0_.role AS role_14, c0_.params AS params_15, c0_.blank AS blank_16, c0_.anchor AS anchor_17, c1_.id AS id_18, c1_.title AS title_19, c1_.template AS template_20, c1_.slug AS slug_21, c1_.breadcrumb AS breadcrumb_22, c1_.active AS active_23, c1_.roles AS roles_24, c1_.lft AS lft_25, c1_.lvl AS lvl_26, c1_.rgt AS rgt_27, c1_.seo_title AS seo_title_28, c1_.seo_description AS seo_description_29, c1_.seo_keywords AS seo_keywords_30, c1_.og_title AS og_title_31, c1_.og_type AS og_type_32, c1_.og_description AS og_description_33, c1_.og_site_name AS og_site_name_34, c1_.twitter_card AS twitter_card_35, c1_.twitter_site AS twitter_site_36, c1_.twitter_title AS twitter_title_37, c1_.twitter_description AS twitter_description_38, c1_.twitter_creator AS twitter_creator_39, c1_.created_at AS created_at_40, c1_.updated_at AS updated_at_41, c2_.id AS id_42, c2_.name AS name_43, c2_.methods AS methods_44, c2_.path AS path_45, c2_.controller AS controller_46, c2_.defaults AS defaults_47, c2_.requirements AS requirements_48, c3_.id AS id_49, c3_.name AS name_50, c3_.information AS information_51, c3_.link_type AS link_type_52, c3_.link_value AS link_value_53, c3_.is_visible AS is_visible_54, c3_.lvl AS lvl_55, c3_.lft AS lft_56, c3_.rgt AS rgt_57, c3_.li_class AS li_class_58, c3_.ul_class AS ul_class_59, c3_.link_class AS link_class_60, c3_.icon_class AS icon_class_61, c3_.connected AS connected_62, c3_.role AS role_63, c3_.params AS params_64, c3_.blank AS blank_65, c3_.anchor AS anchor_66, c4_.id AS id_67, c4_.slug AS slug_68, c4_.label AS label_69, c4_.locale AS locale_70, c4_.host AS host_71, c4_.localhost AS localhost_72, c4_.host_multilingual AS host_multilingual_73, c4_.`default` AS default_74, c4_.flag_icon AS flag_icon_75, c4_.visible AS visible_76, c4_.template_filter AS template_filter_77, c5_.id AS id_78, c5_.code AS code_79, c5_.label AS label_80, c5_.type AS type_81, c5_.value AS value_82, c5_.position AS position_83, c5_.parent_heritance AS parent_heritance_84, c5_.active AS active_85, c0_.page_id AS page_id_86, c0_.tree_root AS tree_root_87, c0_.parent_id AS parent_id_88, c0_.menu_id AS menu_id_89, c1_.route_id AS route_id_90, c1_.site_id AS site_id_91, c1_.tree_root AS tree_root_92, c1_.parent_id AS parent_id_93, c1_.og_image_id AS og_image_id_94, c1_.twitter_image_id AS twitter_image_id_95, c2_.discr AS discr_96, c3_.page_id AS page_id_97, c3_.tree_root AS tree_root_98, c3_.parent_id AS parent_id_99, c3_.menu_id AS menu_id_100, c5_.page_id AS page_id_101, c5_.shared_block_parent_id AS shared_block_parent_id_102, c5_.declination_id AS declination_id_103 FROM cms__menu_item c0_ LEFT JOIN cms__page c1_ ON c0_.page_id = c1_.id LEFT JOIN cms__route c2_ ON c1_.route_id = c2_.id AND c2_.discr IN ('base') LEFT JOIN cms__menu_item c3_ ON c0_.id = c3_.parent_id LEFT JOIN cms__site c4_ ON c1_.site_id = c4_.id LEFT JOIN cms__content c5_ ON c1_.id = c5_.page_id WHERE c0_.menu_id = ? ORDER BY c0_.lft ASC, c3_.lft ASC, c5_.position ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.information AS information_3, t0.link_type AS link_type_4, t0.link_value AS link_value_5, t0.is_visible AS is_visible_6, t0.lvl AS lvl_7, t0.lft AS lft_8, t0.rgt AS rgt_9, t0.li_class AS li_class_10, t0.ul_class AS ul_class_11, t0.link_class AS link_class_12, t0.icon_class AS icon_class_13, t0.connected AS connected_14, t0.role AS role_15, t0.params AS params_16, t0.blank AS blank_17, t0.anchor AS anchor_18, t0.page_id AS page_id_19, t0.tree_root AS tree_root_20, t0.parent_id AS parent_id_21, t0.menu_id AS menu_id_22 FROM cms__menu_item t0 WHERE t0.menu_id = ?

#▲	Time	Info
1	1.22 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.logo AS logo_4, t0.domain AS domain_5, t0.matomo_id AS matomo_id_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t9.id AS id_10, t9.title_edito AS title_edito_11, t9.subtitle_edito AS subtitle_edito_12, t9.picture_edito AS picture_edito_13, t9.content_edito AS content_edito_14, t9.button_edito AS button_edito_15, t9.link_button_edito AS link_button_edito_16, t9.title_highlight AS title_highlight_17, t9.subtitle_highlight AS subtitle_highlight_18, t9.picture_highlight AS picture_highlight_19, t9.content_highlight AS content_highlight_20, t9.button_highlight AS button_highlight_21, t9.link_button_highlight AS link_button_highlight_22, t9.created_at AS created_at_23, t9.updated_at AS updated_at_24, t9.box_id AS box_id_25, t26.id AS id_27, t26.title_menu AS title_menu_28, t26.slug AS slug_29, t26.title AS title_30, t26.subtitle AS subtitle_31, t26.picture_introduction AS picture_introduction_32, t26.introduction AS introduction_33, t26.content AS content_34, t26.created_at AS created_at_35, t26.updated_at AS updated_at_36, t26.box_id AS box_id_37, t38.id AS id_39, t38.title_menu AS title_menu_40, t38.slug AS slug_41, t38.title AS title_42, t38.subtitle AS subtitle_43, t38.picture_introduction AS picture_introduction_44, t38.introduction AS introduction_45, t38.content AS content_46, t38.created_at AS created_at_47, t38.updated_at AS updated_at_48, t38.box_id AS box_id_49, t50.id AS id_51, t50.title_menu AS title_menu_52, t50.title AS title_53, t50.subtitle AS subtitle_54, t50.picture_introduction AS picture_introduction_55, t50.introduction AS introduction_56, t50.content AS content_57, t50.created_at AS created_at_58, t50.updated_at AS updated_at_59, t50.box_id AS box_id_60, t61.id AS id_62, t61.title_menu AS title_menu_63, t61.title AS title_64, t61.subtitle AS subtitle_65, t61.picture_introduction AS picture_introduction_66, t61.introduction AS introduction_67, t61.content AS content_68, t61.created_at AS created_at_69, t61.updated_at AS updated_at_70, t61.box_id AS box_id_71, t72.id AS id_73, t72.title_menu AS title_menu_74, t72.title AS title_75, t72.subtitle AS subtitle_76, t72.picture_introduction AS picture_introduction_77, t72.introduction AS introduction_78, t72.content AS content_79, t72.created_at AS created_at_80, t72.updated_at AS updated_at_81, t72.box_id AS box_id_82 FROM box__box t0 LEFT JOIN box__home t9 ON t9.box_id = t0.id LEFT JOIN box__custom t26 ON t26.box_id = t0.id LEFT JOIN box__custom_2 t38 ON t38.box_id = t0.id LEFT JOIN box__team t50 ON t50.box_id = t0.id LEFT JOIN box__who_are_we t61 ON t61.box_id = t0.id LEFT JOIN box__why_join t72 ON t72.box_id = t0.id WHERE t0.domain = ? LIMIT 1 Parameters: [`"cce26.webetdesign.com"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.logo AS logo_4, t0.domain AS domain_5, t0.matomo_id AS matomo_id_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t9.id AS id_10, t9.title_edito AS title_edito_11, t9.subtitle_edito AS subtitle_edito_12, t9.picture_edito AS picture_edito_13, t9.content_edito AS content_edito_14, t9.button_edito AS button_edito_15, t9.link_button_edito AS link_button_edito_16, t9.title_highlight AS title_highlight_17, t9.subtitle_highlight AS subtitle_highlight_18, t9.picture_highlight AS picture_highlight_19, t9.content_highlight AS content_highlight_20, t9.button_highlight AS button_highlight_21, t9.link_button_highlight AS link_button_highlight_22, t9.created_at AS created_at_23, t9.updated_at AS updated_at_24, t9.box_id AS box_id_25, t26.id AS id_27, t26.title_menu AS title_menu_28, t26.slug AS slug_29, t26.title AS title_30, t26.subtitle AS subtitle_31, t26.picture_introduction AS picture_introduction_32, t26.introduction AS introduction_33, t26.content AS content_34, t26.created_at AS created_at_35, t26.updated_at AS updated_at_36, t26.box_id AS box_id_37, t38.id AS id_39, t38.title_menu AS title_menu_40, t38.slug AS slug_41, t38.title AS title_42, t38.subtitle AS subtitle_43, t38.picture_introduction AS picture_introduction_44, t38.introduction AS introduction_45, t38.content AS content_46, t38.created_at AS created_at_47, t38.updated_at AS updated_at_48, t38.box_id AS box_id_49, t50.id AS id_51, t50.title_menu AS title_menu_52, t50.title AS title_53, t50.subtitle AS subtitle_54, t50.picture_introduction AS picture_introduction_55, t50.introduction AS introduction_56, t50.content AS content_57, t50.created_at AS created_at_58, t50.updated_at AS updated_at_59, t50.box_id AS box_id_60, t61.id AS id_62, t61.title_menu AS title_menu_63, t61.title AS title_64, t61.subtitle AS subtitle_65, t61.picture_introduction AS picture_introduction_66, t61.introduction AS introduction_67, t61.content AS content_68, t61.created_at AS created_at_69, t61.updated_at AS updated_at_70, t61.box_id AS box_id_71, t72.id AS id_73, t72.title_menu AS title_menu_74, t72.title AS title_75, t72.subtitle AS subtitle_76, t72.picture_introduction AS picture_introduction_77, t72.introduction AS introduction_78, t72.content AS content_79, t72.created_at AS created_at_80, t72.updated_at AS updated_at_81, t72.box_id AS box_id_82 FROM box__box t0 LEFT JOIN box__home t9 ON t9.box_id = t0.id LEFT JOIN box__custom t26 ON t26.box_id = t0.id LEFT JOIN box__custom_2 t38 ON t38.box_id = t0.id LEFT JOIN box__team t50 ON t50.box_id = t0.id LEFT JOIN box__who_are_we t61 ON t61.box_id = t0.id LEFT JOIN box__why_join t72 ON t72.box_id = t0.id WHERE t0.domain = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.logo AS logo_4, t0.domain AS domain_5, t0.matomo_id AS matomo_id_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t9.id AS id_10, t9.title_edito AS title_edito_11, t9.subtitle_edito AS subtitle_edito_12, t9.picture_edito AS picture_edito_13, t9.content_edito AS content_edito_14, t9.button_edito AS button_edito_15, t9.link_button_edito AS link_button_edito_16, t9.title_highlight AS title_highlight_17, t9.subtitle_highlight AS subtitle_highlight_18, t9.picture_highlight AS picture_highlight_19, t9.content_highlight AS content_highlight_20, t9.button_highlight AS button_highlight_21, t9.link_button_highlight AS link_button_highlight_22, t9.created_at AS created_at_23, t9.updated_at AS updated_at_24, t9.box_id AS box_id_25, t26.id AS id_27, t26.title_menu AS title_menu_28, t26.slug AS slug_29, t26.title AS title_30, t26.subtitle AS subtitle_31, t26.picture_introduction AS picture_introduction_32, t26.introduction AS introduction_33, t26.content AS content_34, t26.created_at AS created_at_35, t26.updated_at AS updated_at_36, t26.box_id AS box_id_37, t38.id AS id_39, t38.title_menu AS title_menu_40, t38.slug AS slug_41, t38.title AS title_42, t38.subtitle AS subtitle_43, t38.picture_introduction AS picture_introduction_44, t38.introduction AS introduction_45, t38.content AS content_46, t38.created_at AS created_at_47, t38.updated_at AS updated_at_48, t38.box_id AS box_id_49, t50.id AS id_51, t50.title_menu AS title_menu_52, t50.title AS title_53, t50.subtitle AS subtitle_54, t50.picture_introduction AS picture_introduction_55, t50.introduction AS introduction_56, t50.content AS content_57, t50.created_at AS created_at_58, t50.updated_at AS updated_at_59, t50.box_id AS box_id_60, t61.id AS id_62, t61.title_menu AS title_menu_63, t61.title AS title_64, t61.subtitle AS subtitle_65, t61.picture_introduction AS picture_introduction_66, t61.introduction AS introduction_67, t61.content AS content_68, t61.created_at AS created_at_69, t61.updated_at AS updated_at_70, t61.box_id AS box_id_71, t72.id AS id_73, t72.title_menu AS title_menu_74, t72.title AS title_75, t72.subtitle AS subtitle_76, t72.picture_introduction AS picture_introduction_77, t72.introduction AS introduction_78, t72.content AS content_79, t72.created_at AS created_at_80, t72.updated_at AS updated_at_81, t72.box_id AS box_id_82 FROM box__box t0 LEFT JOIN box__home t9 ON t9.box_id = t0.id LEFT JOIN box__custom t26 ON t26.box_id = t0.id LEFT JOIN box__custom_2 t38 ON t38.box_id = t0.id LEFT JOIN box__team t50 ON t50.box_id = t0.id LEFT JOIN box__who_are_we t61 ON t61.box_id = t0.id LEFT JOIN box__why_join t72 ON t72.box_id = t0.id WHERE t0.domain = 'cce26.webetdesign.com' LIMIT 1;
2	1.28 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.template AS template_2, c0_.slug AS slug_3, c0_.breadcrumb AS breadcrumb_4, c0_.active AS active_5, c0_.roles AS roles_6, c0_.lft AS lft_7, c0_.lvl AS lvl_8, c0_.rgt AS rgt_9, c0_.seo_title AS seo_title_10, c0_.seo_description AS seo_description_11, c0_.seo_keywords AS seo_keywords_12, c0_.og_title AS og_title_13, c0_.og_type AS og_type_14, c0_.og_description AS og_description_15, c0_.og_site_name AS og_site_name_16, c0_.twitter_card AS twitter_card_17, c0_.twitter_site AS twitter_site_18, c0_.twitter_title AS twitter_title_19, c0_.twitter_description AS twitter_description_20, c0_.twitter_creator AS twitter_creator_21, c0_.created_at AS created_at_22, c0_.updated_at AS updated_at_23, c1_.id AS id_24, c1_.name AS name_25, c1_.methods AS methods_26, c1_.path AS path_27, c1_.controller AS controller_28, c1_.defaults AS defaults_29, c1_.requirements AS requirements_30, c2_.id AS id_31, c2_.slug AS slug_32, c2_.label AS label_33, c2_.locale AS locale_34, c2_.host AS host_35, c2_.localhost AS localhost_36, c2_.host_multilingual AS host_multilingual_37, c2_.`default` AS default_38, c2_.flag_icon AS flag_icon_39, c2_.visible AS visible_40, c2_.template_filter AS template_filter_41, c3_.id AS id_42, c3_.title AS title_43, c3_.technic_name AS technic_name_44, c3_.locale AS locale_45, c3_.active AS active_46, c3_.params AS params_47, c3_.seo_title AS seo_title_48, c3_.seo_description AS seo_description_49, c3_.seo_keywords AS seo_keywords_50, c3_.og_title AS og_title_51, c3_.og_type AS og_type_52, c3_.og_description AS og_description_53, c3_.og_site_name AS og_site_name_54, c3_.twitter_card AS twitter_card_55, c3_.twitter_site AS twitter_site_56, c3_.twitter_title AS twitter_title_57, c3_.twitter_description AS twitter_description_58, c3_.twitter_creator AS twitter_creator_59, c0_.route_id AS route_id_60, c0_.site_id AS site_id_61, c0_.tree_root AS tree_root_62, c0_.parent_id AS parent_id_63, c0_.og_image_id AS og_image_id_64, c0_.twitter_image_id AS twitter_image_id_65, c1_.discr AS discr_66, c3_.page_id AS page_id_67, c3_.og_image_id AS og_image_id_68, c3_.twitter_image_id AS twitter_image_id_69 FROM cms__page c0_ LEFT JOIN cms__route c1_ ON c0_.route_id = c1_.id AND c1_.discr IN ('base') LEFT JOIN cms__site c2_ ON c0_.site_id = c2_.id LEFT JOIN cms__page_declination c3_ ON c0_.id = c3_.page_id WHERE c1_.name = ? Parameters: [`"show_enquiry"`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.template AS template_2, c0_.slug AS slug_3, c0_.breadcrumb AS breadcrumb_4, c0_.active AS active_5, c0_.roles AS roles_6, c0_.lft AS lft_7, c0_.lvl AS lvl_8, c0_.rgt AS rgt_9, c0_.seo_title AS seo_title_10, c0_.seo_description AS seo_description_11, c0_.seo_keywords AS seo_keywords_12, c0_.og_title AS og_title_13, c0_.og_type AS og_type_14, c0_.og_description AS og_description_15, c0_.og_site_name AS og_site_name_16, c0_.twitter_card AS twitter_card_17, c0_.twitter_site AS twitter_site_18, c0_.twitter_title AS twitter_title_19, c0_.twitter_description AS twitter_description_20, c0_.twitter_creator AS twitter_creator_21, c0_.created_at AS created_at_22, c0_.updated_at AS updated_at_23, c1_.id AS id_24, c1_.name AS name_25, c1_.methods AS methods_26, c1_.path AS path_27, c1_.controller AS controller_28, c1_.defaults AS defaults_29, c1_.requirements AS requirements_30, c2_.id AS id_31, c2_.slug AS slug_32, c2_.label AS label_33, c2_.locale AS locale_34, c2_.host AS host_35, c2_.localhost AS localhost_36, c2_.host_multilingual AS host_multilingual_37, c2_.`default` AS default_38, c2_.flag_icon AS flag_icon_39, c2_.visible AS visible_40, c2_.template_filter AS template_filter_41, c3_.id AS id_42, c3_.title AS title_43, c3_.technic_name AS technic_name_44, c3_.locale AS locale_45, c3_.active AS active_46, c3_.params AS params_47, c3_.seo_title AS seo_title_48, c3_.seo_description AS seo_description_49, c3_.seo_keywords AS seo_keywords_50, c3_.og_title AS og_title_51, c3_.og_type AS og_type_52, c3_.og_description AS og_description_53, c3_.og_site_name AS og_site_name_54, c3_.twitter_card AS twitter_card_55, c3_.twitter_site AS twitter_site_56, c3_.twitter_title AS twitter_title_57, c3_.twitter_description AS twitter_description_58, c3_.twitter_creator AS twitter_creator_59, c0_.route_id AS route_id_60, c0_.site_id AS site_id_61, c0_.tree_root AS tree_root_62, c0_.parent_id AS parent_id_63, c0_.og_image_id AS og_image_id_64, c0_.twitter_image_id AS twitter_image_id_65, c1_.discr AS discr_66, c3_.page_id AS page_id_67, c3_.og_image_id AS og_image_id_68, c3_.twitter_image_id AS twitter_image_id_69 FROM cms__page c0_ LEFT JOIN cms__route c1_ ON c0_.route_id = c1_.id AND c1_.discr IN ('base') LEFT JOIN cms__site c2_ ON c0_.site_id = c2_.id LEFT JOIN cms__page_declination c3_ ON c0_.id = c3_.page_id WHERE c1_.name = ? SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.template AS template_2, c0_.slug AS slug_3, c0_.breadcrumb AS breadcrumb_4, c0_.active AS active_5, c0_.roles AS roles_6, c0_.lft AS lft_7, c0_.lvl AS lvl_8, c0_.rgt AS rgt_9, c0_.seo_title AS seo_title_10, c0_.seo_description AS seo_description_11, c0_.seo_keywords AS seo_keywords_12, c0_.og_title AS og_title_13, c0_.og_type AS og_type_14, c0_.og_description AS og_description_15, c0_.og_site_name AS og_site_name_16, c0_.twitter_card AS twitter_card_17, c0_.twitter_site AS twitter_site_18, c0_.twitter_title AS twitter_title_19, c0_.twitter_description AS twitter_description_20, c0_.twitter_creator AS twitter_creator_21, c0_.created_at AS created_at_22, c0_.updated_at AS updated_at_23, c1_.id AS id_24, c1_.name AS name_25, c1_.methods AS methods_26, c1_.path AS path_27, c1_.controller AS controller_28, c1_.defaults AS defaults_29, c1_.requirements AS requirements_30, c2_.id AS id_31, c2_.slug AS slug_32, c2_.label AS label_33, c2_.locale AS locale_34, c2_.host AS host_35, c2_.localhost AS localhost_36, c2_.host_multilingual AS host_multilingual_37, c2_.`default` AS default_38, c2_.flag_icon AS flag_icon_39, c2_.visible AS visible_40, c2_.template_filter AS template_filter_41, c3_.id AS id_42, c3_.title AS title_43, c3_.technic_name AS technic_name_44, c3_.locale AS locale_45, c3_.active AS active_46, c3_.params AS params_47, c3_.seo_title AS seo_title_48, c3_.seo_description AS seo_description_49, c3_.seo_keywords AS seo_keywords_50, c3_.og_title AS og_title_51, c3_.og_type AS og_type_52, c3_.og_description AS og_description_53, c3_.og_site_name AS og_site_name_54, c3_.twitter_card AS twitter_card_55, c3_.twitter_site AS twitter_site_56, c3_.twitter_title AS twitter_title_57, c3_.twitter_description AS twitter_description_58, c3_.twitter_creator AS twitter_creator_59, c0_.route_id AS route_id_60, c0_.site_id AS site_id_61, c0_.tree_root AS tree_root_62, c0_.parent_id AS parent_id_63, c0_.og_image_id AS og_image_id_64, c0_.twitter_image_id AS twitter_image_id_65, c1_.discr AS discr_66, c3_.page_id AS page_id_67, c3_.og_image_id AS og_image_id_68, c3_.twitter_image_id AS twitter_image_id_69 FROM cms__page c0_ LEFT JOIN cms__route c1_ ON c0_.route_id = c1_.id AND c1_.discr IN ('base') LEFT JOIN cms__site c2_ ON c0_.site_id = c2_.id LEFT JOIN cms__page_declination c3_ ON c0_.id = c3_.page_id WHERE c1_.name = 'show_enquiry';
3	0.73 ms	SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.picture AS picture_4, t0.link AS link_5, t0.begin_date AS begin_date_6, t0.end_date AS end_date_7, t0.extension_date AS extension_date_8, t0.document_order_public_enquiry AS document_order_public_enquiry_9, t0.document_notice_public_enquiry AS document_notice_public_enquiry_10, t0.document_report_public_enquiry AS document_report_public_enquiry_11, t0.document_decision AS document_decision_12, t0.link_order_public_enquiry AS link_order_public_enquiry_13, t0.link_notice_public_enquiry AS link_notice_public_enquiry_14, t0.link_report_public_enquiry AS link_report_public_enquiry_15, t0.link_decision AS link_decision_16, t0.publication_status AS publication_status_17, t0.is_published AS is_published_18, t0.nb_persons_received AS nb_persons_received_19, t0.nb_observations_filed AS nb_observations_filed_20, t0.nb_observations_numeric AS nb_observations_numeric_21, t0.nb_observations_paper AS nb_observations_paper_22, t0.nb_observations_oral AS nb_observations_oral_23, t0.nb_public_meeting_done AS nb_public_meeting_done_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26, t0.reportUpdatedAt AS reportUpdatedAt_27, t0.alert_sent_at AS alert_sent_at_28, t0.designation AS designation_29, t0.place AS place_30, t0.actors AS actors_31, t0.project_owner_type AS project_owner_type_32, t0.type_id AS type_id_33, t0.provider_id AS provider_id_34, t0.user_id AS user_id_35 FROM public_enquiry__public_enquiry t0 WHERE t0.id = ? Parameters: [`"38"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.picture AS picture_4, t0.link AS link_5, t0.begin_date AS begin_date_6, t0.end_date AS end_date_7, t0.extension_date AS extension_date_8, t0.document_order_public_enquiry AS document_order_public_enquiry_9, t0.document_notice_public_enquiry AS document_notice_public_enquiry_10, t0.document_report_public_enquiry AS document_report_public_enquiry_11, t0.document_decision AS document_decision_12, t0.link_order_public_enquiry AS link_order_public_enquiry_13, t0.link_notice_public_enquiry AS link_notice_public_enquiry_14, t0.link_report_public_enquiry AS link_report_public_enquiry_15, t0.link_decision AS link_decision_16, t0.publication_status AS publication_status_17, t0.is_published AS is_published_18, t0.nb_persons_received AS nb_persons_received_19, t0.nb_observations_filed AS nb_observations_filed_20, t0.nb_observations_numeric AS nb_observations_numeric_21, t0.nb_observations_paper AS nb_observations_paper_22, t0.nb_observations_oral AS nb_observations_oral_23, t0.nb_public_meeting_done AS nb_public_meeting_done_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26, t0.reportUpdatedAt AS reportUpdatedAt_27, t0.alert_sent_at AS alert_sent_at_28, t0.designation AS designation_29, t0.place AS place_30, t0.actors AS actors_31, t0.project_owner_type AS project_owner_type_32, t0.type_id AS type_id_33, t0.provider_id AS provider_id_34, t0.user_id AS user_id_35 FROM public_enquiry__public_enquiry t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.picture AS picture_4, t0.link AS link_5, t0.begin_date AS begin_date_6, t0.end_date AS end_date_7, t0.extension_date AS extension_date_8, t0.document_order_public_enquiry AS document_order_public_enquiry_9, t0.document_notice_public_enquiry AS document_notice_public_enquiry_10, t0.document_report_public_enquiry AS document_report_public_enquiry_11, t0.document_decision AS document_decision_12, t0.link_order_public_enquiry AS link_order_public_enquiry_13, t0.link_notice_public_enquiry AS link_notice_public_enquiry_14, t0.link_report_public_enquiry AS link_report_public_enquiry_15, t0.link_decision AS link_decision_16, t0.publication_status AS publication_status_17, t0.is_published AS is_published_18, t0.nb_persons_received AS nb_persons_received_19, t0.nb_observations_filed AS nb_observations_filed_20, t0.nb_observations_numeric AS nb_observations_numeric_21, t0.nb_observations_paper AS nb_observations_paper_22, t0.nb_observations_oral AS nb_observations_oral_23, t0.nb_public_meeting_done AS nb_public_meeting_done_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26, t0.reportUpdatedAt AS reportUpdatedAt_27, t0.alert_sent_at AS alert_sent_at_28, t0.designation AS designation_29, t0.place AS place_30, t0.actors AS actors_31, t0.project_owner_type AS project_owner_type_32, t0.type_id AS type_id_33, t0.provider_id AS provider_id_34, t0.user_id AS user_id_35 FROM public_enquiry__public_enquiry t0 WHERE t0.id = '38';
4	0.97 ms	SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.match_name AS match_name_2, d0_.code AS code_3, d0_.region_id AS region_id_4 FROM department d0_ ORDER BY d0_.name ASC Parameters: [] View formatted query View runnable query Explain query SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.match_name AS match_name_2, d0_.code AS code_3, d0_.region_id AS region_id_4 FROM department d0_ ORDER BY d0_.name ASC SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.match_name AS match_name_2, d0_.code AS code_3, d0_.region_id AS region_id_4 FROM department d0_ ORDER BY d0_.name ASC;
5	0.65 ms	SELECT t0.id AS id_1, t0.title AS title_2, t0.template AS template_3, t0.slug AS slug_4, t0.breadcrumb AS breadcrumb_5, t0.active AS active_6, t0.roles AS roles_7, t0.lft AS lft_8, t0.lvl AS lvl_9, t0.rgt AS rgt_10, t0.seo_title AS seo_title_11, t0.seo_description AS seo_description_12, t0.seo_keywords AS seo_keywords_13, t0.og_title AS og_title_14, t0.og_type AS og_type_15, t0.og_description AS og_description_16, t0.og_site_name AS og_site_name_17, t0.twitter_card AS twitter_card_18, t0.twitter_site AS twitter_site_19, t0.twitter_title AS twitter_title_20, t0.twitter_description AS twitter_description_21, t0.twitter_creator AS twitter_creator_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.route_id AS route_id_25, t0.site_id AS site_id_26, t0.tree_root AS tree_root_27, t0.parent_id AS parent_id_28, t0.og_image_id AS og_image_id_29, t0.twitter_image_id AS twitter_image_id_30 FROM cms__page t0 WHERE t0.id = ? Parameters: [`29`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.template AS template_3, t0.slug AS slug_4, t0.breadcrumb AS breadcrumb_5, t0.active AS active_6, t0.roles AS roles_7, t0.lft AS lft_8, t0.lvl AS lvl_9, t0.rgt AS rgt_10, t0.seo_title AS seo_title_11, t0.seo_description AS seo_description_12, t0.seo_keywords AS seo_keywords_13, t0.og_title AS og_title_14, t0.og_type AS og_type_15, t0.og_description AS og_description_16, t0.og_site_name AS og_site_name_17, t0.twitter_card AS twitter_card_18, t0.twitter_site AS twitter_site_19, t0.twitter_title AS twitter_title_20, t0.twitter_description AS twitter_description_21, t0.twitter_creator AS twitter_creator_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.route_id AS route_id_25, t0.site_id AS site_id_26, t0.tree_root AS tree_root_27, t0.parent_id AS parent_id_28, t0.og_image_id AS og_image_id_29, t0.twitter_image_id AS twitter_image_id_30 FROM cms__page t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.title AS title_2, t0.template AS template_3, t0.slug AS slug_4, t0.breadcrumb AS breadcrumb_5, t0.active AS active_6, t0.roles AS roles_7, t0.lft AS lft_8, t0.lvl AS lvl_9, t0.rgt AS rgt_10, t0.seo_title AS seo_title_11, t0.seo_description AS seo_description_12, t0.seo_keywords AS seo_keywords_13, t0.og_title AS og_title_14, t0.og_type AS og_type_15, t0.og_description AS og_description_16, t0.og_site_name AS og_site_name_17, t0.twitter_card AS twitter_card_18, t0.twitter_site AS twitter_site_19, t0.twitter_title AS twitter_title_20, t0.twitter_description AS twitter_description_21, t0.twitter_creator AS twitter_creator_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.route_id AS route_id_25, t0.site_id AS site_id_26, t0.tree_root AS tree_root_27, t0.parent_id AS parent_id_28, t0.og_image_id AS og_image_id_29, t0.twitter_image_id AS twitter_image_id_30 FROM cms__page t0 WHERE t0.id = 29;
6	0.58 ms	SELECT t0.id AS id_1, t0.title AS title_2, t0.template AS template_3, t0.slug AS slug_4, t0.breadcrumb AS breadcrumb_5, t0.active AS active_6, t0.roles AS roles_7, t0.lft AS lft_8, t0.lvl AS lvl_9, t0.rgt AS rgt_10, t0.seo_title AS seo_title_11, t0.seo_description AS seo_description_12, t0.seo_keywords AS seo_keywords_13, t0.og_title AS og_title_14, t0.og_type AS og_type_15, t0.og_description AS og_description_16, t0.og_site_name AS og_site_name_17, t0.twitter_card AS twitter_card_18, t0.twitter_site AS twitter_site_19, t0.twitter_title AS twitter_title_20, t0.twitter_description AS twitter_description_21, t0.twitter_creator AS twitter_creator_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.route_id AS route_id_25, t0.site_id AS site_id_26, t0.tree_root AS tree_root_27, t0.parent_id AS parent_id_28, t0.og_image_id AS og_image_id_29, t0.twitter_image_id AS twitter_image_id_30 FROM cms__page t0 WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.template AS template_3, t0.slug AS slug_4, t0.breadcrumb AS breadcrumb_5, t0.active AS active_6, t0.roles AS roles_7, t0.lft AS lft_8, t0.lvl AS lvl_9, t0.rgt AS rgt_10, t0.seo_title AS seo_title_11, t0.seo_description AS seo_description_12, t0.seo_keywords AS seo_keywords_13, t0.og_title AS og_title_14, t0.og_type AS og_type_15, t0.og_description AS og_description_16, t0.og_site_name AS og_site_name_17, t0.twitter_card AS twitter_card_18, t0.twitter_site AS twitter_site_19, t0.twitter_title AS twitter_title_20, t0.twitter_description AS twitter_description_21, t0.twitter_creator AS twitter_creator_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.route_id AS route_id_25, t0.site_id AS site_id_26, t0.tree_root AS tree_root_27, t0.parent_id AS parent_id_28, t0.og_image_id AS og_image_id_29, t0.twitter_image_id AS twitter_image_id_30 FROM cms__page t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.title AS title_2, t0.template AS template_3, t0.slug AS slug_4, t0.breadcrumb AS breadcrumb_5, t0.active AS active_6, t0.roles AS roles_7, t0.lft AS lft_8, t0.lvl AS lvl_9, t0.rgt AS rgt_10, t0.seo_title AS seo_title_11, t0.seo_description AS seo_description_12, t0.seo_keywords AS seo_keywords_13, t0.og_title AS og_title_14, t0.og_type AS og_type_15, t0.og_description AS og_description_16, t0.og_site_name AS og_site_name_17, t0.twitter_card AS twitter_card_18, t0.twitter_site AS twitter_site_19, t0.twitter_title AS twitter_title_20, t0.twitter_description AS twitter_description_21, t0.twitter_creator AS twitter_creator_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.route_id AS route_id_25, t0.site_id AS site_id_26, t0.tree_root AS tree_root_27, t0.parent_id AS parent_id_28, t0.og_image_id AS og_image_id_29, t0.twitter_image_id AS twitter_image_id_30 FROM cms__page t0 WHERE t0.id = 1;
7	0.40 ms	SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.type AS type_4, t0.site_id AS site_id_5 FROM cms__menu t0 WHERE t0.code = ? AND t0.site_id = ? LIMIT 1 Parameters: [`"main_menu" 1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.type AS type_4, t0.site_id AS site_id_5 FROM cms__menu t0 WHERE t0.code = ? AND t0.site_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.type AS type_4, t0.site_id AS site_id_5 FROM cms__menu t0 WHERE t0.code = 'main_menu' AND t0.site_id = 1 LIMIT 1;
8	7.60 ms	SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.information AS information_2, c0_.link_type AS link_type_3, c0_.link_value AS link_value_4, c0_.is_visible AS is_visible_5, c0_.lvl AS lvl_6, c0_.lft AS lft_7, c0_.rgt AS rgt_8, c0_.li_class AS li_class_9, c0_.ul_class AS ul_class_10, c0_.link_class AS link_class_11, c0_.icon_class AS icon_class_12, c0_.connected AS connected_13, c0_.role AS role_14, c0_.params AS params_15, c0_.blank AS blank_16, c0_.anchor AS anchor_17, c1_.id AS id_18, c1_.title AS title_19, c1_.template AS template_20, c1_.slug AS slug_21, c1_.breadcrumb AS breadcrumb_22, c1_.active AS active_23, c1_.roles AS roles_24, c1_.lft AS lft_25, c1_.lvl AS lvl_26, c1_.rgt AS rgt_27, c1_.seo_title AS seo_title_28, c1_.seo_description AS seo_description_29, c1_.seo_keywords AS seo_keywords_30, c1_.og_title AS og_title_31, c1_.og_type AS og_type_32, c1_.og_description AS og_description_33, c1_.og_site_name AS og_site_name_34, c1_.twitter_card AS twitter_card_35, c1_.twitter_site AS twitter_site_36, c1_.twitter_title AS twitter_title_37, c1_.twitter_description AS twitter_description_38, c1_.twitter_creator AS twitter_creator_39, c1_.created_at AS created_at_40, c1_.updated_at AS updated_at_41, c2_.id AS id_42, c2_.name AS name_43, c2_.methods AS methods_44, c2_.path AS path_45, c2_.controller AS controller_46, c2_.defaults AS defaults_47, c2_.requirements AS requirements_48, c3_.id AS id_49, c3_.name AS name_50, c3_.information AS information_51, c3_.link_type AS link_type_52, c3_.link_value AS link_value_53, c3_.is_visible AS is_visible_54, c3_.lvl AS lvl_55, c3_.lft AS lft_56, c3_.rgt AS rgt_57, c3_.li_class AS li_class_58, c3_.ul_class AS ul_class_59, c3_.link_class AS link_class_60, c3_.icon_class AS icon_class_61, c3_.connected AS connected_62, c3_.role AS role_63, c3_.params AS params_64, c3_.blank AS blank_65, c3_.anchor AS anchor_66, c4_.id AS id_67, c4_.slug AS slug_68, c4_.label AS label_69, c4_.locale AS locale_70, c4_.host AS host_71, c4_.localhost AS localhost_72, c4_.host_multilingual AS host_multilingual_73, c4_.`default` AS default_74, c4_.flag_icon AS flag_icon_75, c4_.visible AS visible_76, c4_.template_filter AS template_filter_77, c5_.id AS id_78, c5_.code AS code_79, c5_.label AS label_80, c5_.type AS type_81, c5_.value AS value_82, c5_.position AS position_83, c5_.parent_heritance AS parent_heritance_84, c5_.active AS active_85, c0_.page_id AS page_id_86, c0_.tree_root AS tree_root_87, c0_.parent_id AS parent_id_88, c0_.menu_id AS menu_id_89, c1_.route_id AS route_id_90, c1_.site_id AS site_id_91, c1_.tree_root AS tree_root_92, c1_.parent_id AS parent_id_93, c1_.og_image_id AS og_image_id_94, c1_.twitter_image_id AS twitter_image_id_95, c2_.discr AS discr_96, c3_.page_id AS page_id_97, c3_.tree_root AS tree_root_98, c3_.parent_id AS parent_id_99, c3_.menu_id AS menu_id_100, c5_.page_id AS page_id_101, c5_.shared_block_parent_id AS shared_block_parent_id_102, c5_.declination_id AS declination_id_103 FROM cms__menu_item c0_ LEFT JOIN cms__page c1_ ON c0_.page_id = c1_.id LEFT JOIN cms__route c2_ ON c1_.route_id = c2_.id AND c2_.discr IN ('base') LEFT JOIN cms__menu_item c3_ ON c0_.id = c3_.parent_id LEFT JOIN cms__site c4_ ON c1_.site_id = c4_.id LEFT JOIN cms__content c5_ ON c1_.id = c5_.page_id WHERE c0_.menu_id = ? ORDER BY c0_.lft ASC, c3_.lft ASC, c5_.position ASC Parameters: [`1`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.information AS information_2, c0_.link_type AS link_type_3, c0_.link_value AS link_value_4, c0_.is_visible AS is_visible_5, c0_.lvl AS lvl_6, c0_.lft AS lft_7, c0_.rgt AS rgt_8, c0_.li_class AS li_class_9, c0_.ul_class AS ul_class_10, c0_.link_class AS link_class_11, c0_.icon_class AS icon_class_12, c0_.connected AS connected_13, c0_.role AS role_14, c0_.params AS params_15, c0_.blank AS blank_16, c0_.anchor AS anchor_17, c1_.id AS id_18, c1_.title AS title_19, c1_.template AS template_20, c1_.slug AS slug_21, c1_.breadcrumb AS breadcrumb_22, c1_.active AS active_23, c1_.roles AS roles_24, c1_.lft AS lft_25, c1_.lvl AS lvl_26, c1_.rgt AS rgt_27, c1_.seo_title AS seo_title_28, c1_.seo_description AS seo_description_29, c1_.seo_keywords AS seo_keywords_30, c1_.og_title AS og_title_31, c1_.og_type AS og_type_32, c1_.og_description AS og_description_33, c1_.og_site_name AS og_site_name_34, c1_.twitter_card AS twitter_card_35, c1_.twitter_site AS twitter_site_36, c1_.twitter_title AS twitter_title_37, c1_.twitter_description AS twitter_description_38, c1_.twitter_creator AS twitter_creator_39, c1_.created_at AS created_at_40, c1_.updated_at AS updated_at_41, c2_.id AS id_42, c2_.name AS name_43, c2_.methods AS methods_44, c2_.path AS path_45, c2_.controller AS controller_46, c2_.defaults AS defaults_47, c2_.requirements AS requirements_48, c3_.id AS id_49, c3_.name AS name_50, c3_.information AS information_51, c3_.link_type AS link_type_52, c3_.link_value AS link_value_53, c3_.is_visible AS is_visible_54, c3_.lvl AS lvl_55, c3_.lft AS lft_56, c3_.rgt AS rgt_57, c3_.li_class AS li_class_58, c3_.ul_class AS ul_class_59, c3_.link_class AS link_class_60, c3_.icon_class AS icon_class_61, c3_.connected AS connected_62, c3_.role AS role_63, c3_.params AS params_64, c3_.blank AS blank_65, c3_.anchor AS anchor_66, c4_.id AS id_67, c4_.slug AS slug_68, c4_.label AS label_69, c4_.locale AS locale_70, c4_.host AS host_71, c4_.localhost AS localhost_72, c4_.host_multilingual AS host_multilingual_73, c4_.`default` AS default_74, c4_.flag_icon AS flag_icon_75, c4_.visible AS visible_76, c4_.template_filter AS template_filter_77, c5_.id AS id_78, c5_.code AS code_79, c5_.label AS label_80, c5_.type AS type_81, c5_.value AS value_82, c5_.position AS position_83, c5_.parent_heritance AS parent_heritance_84, c5_.active AS active_85, c0_.page_id AS page_id_86, c0_.tree_root AS tree_root_87, c0_.parent_id AS parent_id_88, c0_.menu_id AS menu_id_89, c1_.route_id AS route_id_90, c1_.site_id AS site_id_91, c1_.tree_root AS tree_root_92, c1_.parent_id AS parent_id_93, c1_.og_image_id AS og_image_id_94, c1_.twitter_image_id AS twitter_image_id_95, c2_.discr AS discr_96, c3_.page_id AS page_id_97, c3_.tree_root AS tree_root_98, c3_.parent_id AS parent_id_99, c3_.menu_id AS menu_id_100, c5_.page_id AS page_id_101, c5_.shared_block_parent_id AS shared_block_parent_id_102, c5_.declination_id AS declination_id_103 FROM cms__menu_item c0_ LEFT JOIN cms__page c1_ ON c0_.page_id = c1_.id LEFT JOIN cms__route c2_ ON c1_.route_id = c2_.id AND c2_.discr IN ('base') LEFT JOIN cms__menu_item c3_ ON c0_.id = c3_.parent_id LEFT JOIN cms__site c4_ ON c1_.site_id = c4_.id LEFT JOIN cms__content c5_ ON c1_.id = c5_.page_id WHERE c0_.menu_id = ? ORDER BY c0_.lft ASC, c3_.lft ASC, c5_.position ASC SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.information AS information_2, c0_.link_type AS link_type_3, c0_.link_value AS link_value_4, c0_.is_visible AS is_visible_5, c0_.lvl AS lvl_6, c0_.lft AS lft_7, c0_.rgt AS rgt_8, c0_.li_class AS li_class_9, c0_.ul_class AS ul_class_10, c0_.link_class AS link_class_11, c0_.icon_class AS icon_class_12, c0_.connected AS connected_13, c0_.role AS role_14, c0_.params AS params_15, c0_.blank AS blank_16, c0_.anchor AS anchor_17, c1_.id AS id_18, c1_.title AS title_19, c1_.template AS template_20, c1_.slug AS slug_21, c1_.breadcrumb AS breadcrumb_22, c1_.active AS active_23, c1_.roles AS roles_24, c1_.lft AS lft_25, c1_.lvl AS lvl_26, c1_.rgt AS rgt_27, c1_.seo_title AS seo_title_28, c1_.seo_description AS seo_description_29, c1_.seo_keywords AS seo_keywords_30, c1_.og_title AS og_title_31, c1_.og_type AS og_type_32, c1_.og_description AS og_description_33, c1_.og_site_name AS og_site_name_34, c1_.twitter_card AS twitter_card_35, c1_.twitter_site AS twitter_site_36, c1_.twitter_title AS twitter_title_37, c1_.twitter_description AS twitter_description_38, c1_.twitter_creator AS twitter_creator_39, c1_.created_at AS created_at_40, c1_.updated_at AS updated_at_41, c2_.id AS id_42, c2_.name AS name_43, c2_.methods AS methods_44, c2_.path AS path_45, c2_.controller AS controller_46, c2_.defaults AS defaults_47, c2_.requirements AS requirements_48, c3_.id AS id_49, c3_.name AS name_50, c3_.information AS information_51, c3_.link_type AS link_type_52, c3_.link_value AS link_value_53, c3_.is_visible AS is_visible_54, c3_.lvl AS lvl_55, c3_.lft AS lft_56, c3_.rgt AS rgt_57, c3_.li_class AS li_class_58, c3_.ul_class AS ul_class_59, c3_.link_class AS link_class_60, c3_.icon_class AS icon_class_61, c3_.connected AS connected_62, c3_.role AS role_63, c3_.params AS params_64, c3_.blank AS blank_65, c3_.anchor AS anchor_66, c4_.id AS id_67, c4_.slug AS slug_68, c4_.label AS label_69, c4_.locale AS locale_70, c4_.host AS host_71, c4_.localhost AS localhost_72, c4_.host_multilingual AS host_multilingual_73, c4_.`default` AS default_74, c4_.flag_icon AS flag_icon_75, c4_.visible AS visible_76, c4_.template_filter AS template_filter_77, c5_.id AS id_78, c5_.code AS code_79, c5_.label AS label_80, c5_.type AS type_81, c5_.value AS value_82, c5_.position AS position_83, c5_.parent_heritance AS parent_heritance_84, c5_.active AS active_85, c0_.page_id AS page_id_86, c0_.tree_root AS tree_root_87, c0_.parent_id AS parent_id_88, c0_.menu_id AS menu_id_89, c1_.route_id AS route_id_90, c1_.site_id AS site_id_91, c1_.tree_root AS tree_root_92, c1_.parent_id AS parent_id_93, c1_.og_image_id AS og_image_id_94, c1_.twitter_image_id AS twitter_image_id_95, c2_.discr AS discr_96, c3_.page_id AS page_id_97, c3_.tree_root AS tree_root_98, c3_.parent_id AS parent_id_99, c3_.menu_id AS menu_id_100, c5_.page_id AS page_id_101, c5_.shared_block_parent_id AS shared_block_parent_id_102, c5_.declination_id AS declination_id_103 FROM cms__menu_item c0_ LEFT JOIN cms__page c1_ ON c0_.page_id = c1_.id LEFT JOIN cms__route c2_ ON c1_.route_id = c2_.id AND c2_.discr IN ('base') LEFT JOIN cms__menu_item c3_ ON c0_.id = c3_.parent_id LEFT JOIN cms__site c4_ ON c1_.site_id = c4_.id LEFT JOIN cms__content c5_ ON c1_.id = c5_.page_id WHERE c0_.menu_id = 1 ORDER BY c0_.lft ASC, c3_.lft ASC, c5_.position ASC;
9	0.54 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.information AS information_3, t0.link_type AS link_type_4, t0.link_value AS link_value_5, t0.is_visible AS is_visible_6, t0.lvl AS lvl_7, t0.lft AS lft_8, t0.rgt AS rgt_9, t0.li_class AS li_class_10, t0.ul_class AS ul_class_11, t0.link_class AS link_class_12, t0.icon_class AS icon_class_13, t0.connected AS connected_14, t0.role AS role_15, t0.params AS params_16, t0.blank AS blank_17, t0.anchor AS anchor_18, t0.page_id AS page_id_19, t0.tree_root AS tree_root_20, t0.parent_id AS parent_id_21, t0.menu_id AS menu_id_22 FROM cms__menu_item t0 WHERE t0.menu_id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.information AS information_3, t0.link_type AS link_type_4, t0.link_value AS link_value_5, t0.is_visible AS is_visible_6, t0.lvl AS lvl_7, t0.lft AS lft_8, t0.rgt AS rgt_9, t0.li_class AS li_class_10, t0.ul_class AS ul_class_11, t0.link_class AS link_class_12, t0.icon_class AS icon_class_13, t0.connected AS connected_14, t0.role AS role_15, t0.params AS params_16, t0.blank AS blank_17, t0.anchor AS anchor_18, t0.page_id AS page_id_19, t0.tree_root AS tree_root_20, t0.parent_id AS parent_id_21, t0.menu_id AS menu_id_22 FROM cms__menu_item t0 WHERE t0.menu_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.information AS information_3, t0.link_type AS link_type_4, t0.link_value AS link_value_5, t0.is_visible AS is_visible_6, t0.lvl AS lvl_7, t0.lft AS lft_8, t0.rgt AS rgt_9, t0.li_class AS li_class_10, t0.ul_class AS ul_class_11, t0.link_class AS link_class_12, t0.icon_class AS icon_class_13, t0.connected AS connected_14, t0.role AS role_15, t0.params AS params_16, t0.blank AS blank_17, t0.anchor AS anchor_18, t0.page_id AS page_id_19, t0.tree_root AS tree_root_20, t0.parent_id AS parent_id_21, t0.menu_id AS menu_id_22 FROM cms__menu_item t0 WHERE t0.menu_id = 1;
10	0.30 ms	SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.locale AS locale_4, t0.host AS host_5, t0.localhost AS localhost_6, t0.host_multilingual AS host_multilingual_7, t0.`default` AS default_8, t0.flag_icon AS flag_icon_9, t0.visible AS visible_10, t0.template_filter AS template_filter_11 FROM cms__site t0 WHERE t0.`default` = ? LIMIT 1 Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.locale AS locale_4, t0.host AS host_5, t0.localhost AS localhost_6, t0.host_multilingual AS host_multilingual_7, t0.`default` AS default_8, t0.flag_icon AS flag_icon_9, t0.visible AS visible_10, t0.template_filter AS template_filter_11 FROM cms__site t0 WHERE t0.`default` = ? LIMIT 1 SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.locale AS locale_4, t0.host AS host_5, t0.localhost AS localhost_6, t0.host_multilingual AS host_multilingual_7, t0.`default` AS default_8, t0.flag_icon AS flag_icon_9, t0.visible AS visible_10, t0.template_filter AS template_filter_11 FROM cms__site t0 WHERE t0.`default` = 1 LIMIT 1;
11	0.43 ms	SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.label AS label_2, c0_.type AS type_3, c0_.value AS value_4, c0_.position AS position_5, c0_.parent_heritance AS parent_heritance_6, c0_.active AS active_7, c0_.page_id AS page_id_8, c0_.shared_block_parent_id AS shared_block_parent_id_9, c0_.declination_id AS declination_id_10 FROM cms__content c0_ WHERE c0_.code = ? AND c0_.page_id = ? LIMIT 1 Parameters: [`"header_picture" 30`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.label AS label_2, c0_.type AS type_3, c0_.value AS value_4, c0_.position AS position_5, c0_.parent_heritance AS parent_heritance_6, c0_.active AS active_7, c0_.page_id AS page_id_8, c0_.shared_block_parent_id AS shared_block_parent_id_9, c0_.declination_id AS declination_id_10 FROM cms__content c0_ WHERE c0_.code = ? AND c0_.page_id = ? LIMIT 1 SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.label AS label_2, c0_.type AS type_3, c0_.value AS value_4, c0_.position AS position_5, c0_.parent_heritance AS parent_heritance_6, c0_.active AS active_7, c0_.page_id AS page_id_8, c0_.shared_block_parent_id AS shared_block_parent_id_9, c0_.declination_id AS declination_id_10 FROM cms__content c0_ WHERE c0_.code = 'header_picture' AND c0_.page_id = 30 LIMIT 1;
12	0.33 ms	SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.locale AS locale_4, t0.host AS host_5, t0.localhost AS localhost_6, t0.host_multilingual AS host_multilingual_7, t0.`default` AS default_8, t0.flag_icon AS flag_icon_9, t0.visible AS visible_10, t0.template_filter AS template_filter_11 FROM cms__site t0 WHERE t0.`default` = ? LIMIT 1 Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.locale AS locale_4, t0.host AS host_5, t0.localhost AS localhost_6, t0.host_multilingual AS host_multilingual_7, t0.`default` AS default_8, t0.flag_icon AS flag_icon_9, t0.visible AS visible_10, t0.template_filter AS template_filter_11 FROM cms__site t0 WHERE t0.`default` = ? LIMIT 1 SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.locale AS locale_4, t0.host AS host_5, t0.localhost AS localhost_6, t0.host_multilingual AS host_multilingual_7, t0.`default` AS default_8, t0.flag_icon AS flag_icon_9, t0.visible AS visible_10, t0.template_filter AS template_filter_11 FROM cms__site t0 WHERE t0.`default` = 1 LIMIT 1;
13	0.32 ms	SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.label AS label_2, c0_.type AS type_3, c0_.value AS value_4, c0_.position AS position_5, c0_.parent_heritance AS parent_heritance_6, c0_.active AS active_7, c0_.page_id AS page_id_8, c0_.shared_block_parent_id AS shared_block_parent_id_9, c0_.declination_id AS declination_id_10 FROM cms__content c0_ WHERE c0_.code = ? AND c0_.page_id = ? LIMIT 1 Parameters: [`"back_button" 30`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.label AS label_2, c0_.type AS type_3, c0_.value AS value_4, c0_.position AS position_5, c0_.parent_heritance AS parent_heritance_6, c0_.active AS active_7, c0_.page_id AS page_id_8, c0_.shared_block_parent_id AS shared_block_parent_id_9, c0_.declination_id AS declination_id_10 FROM cms__content c0_ WHERE c0_.code = ? AND c0_.page_id = ? LIMIT 1 SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.label AS label_2, c0_.type AS type_3, c0_.value AS value_4, c0_.position AS position_5, c0_.parent_heritance AS parent_heritance_6, c0_.active AS active_7, c0_.page_id AS page_id_8, c0_.shared_block_parent_id AS shared_block_parent_id_9, c0_.declination_id AS declination_id_10 FROM cms__content c0_ WHERE c0_.code = 'back_button' AND c0_.page_id = 30 LIMIT 1;
14	0.42 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.match_name AS match_name_3, t0.code AS code_4, t0.region_id AS region_id_5 FROM department t0 INNER JOIN public_enquiry__public_enquiry_has_department ON t0.id = public_enquiry__public_enquiry_has_department.department_id WHERE public_enquiry__public_enquiry_has_department.public_enquiry_id = ? Parameters: [`38`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.match_name AS match_name_3, t0.code AS code_4, t0.region_id AS region_id_5 FROM department t0 INNER JOIN public_enquiry__public_enquiry_has_department ON t0.id = public_enquiry__public_enquiry_has_department.department_id WHERE public_enquiry__public_enquiry_has_department.public_enquiry_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.match_name AS match_name_3, t0.code AS code_4, t0.region_id AS region_id_5 FROM department t0 INNER JOIN public_enquiry__public_enquiry_has_department ON t0.id = public_enquiry__public_enquiry_has_department.department_id WHERE public_enquiry__public_enquiry_has_department.public_enquiry_id = 38;
15	0.22 ms	SELECT t0.id AS id_1, t0.title AS title_2 FROM public_enquiry__type t0 WHERE t0.id = ? Parameters: [`6`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2 FROM public_enquiry__type t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.title AS title_2 FROM public_enquiry__type t0 WHERE t0.id = 6;
16	0.27 ms	SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.locale AS locale_4, t0.host AS host_5, t0.localhost AS localhost_6, t0.host_multilingual AS host_multilingual_7, t0.`default` AS default_8, t0.flag_icon AS flag_icon_9, t0.visible AS visible_10, t0.template_filter AS template_filter_11 FROM cms__site t0 WHERE t0.`default` = ? LIMIT 1 Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.locale AS locale_4, t0.host AS host_5, t0.localhost AS localhost_6, t0.host_multilingual AS host_multilingual_7, t0.`default` AS default_8, t0.flag_icon AS flag_icon_9, t0.visible AS visible_10, t0.template_filter AS template_filter_11 FROM cms__site t0 WHERE t0.`default` = ? LIMIT 1 SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.locale AS locale_4, t0.host AS host_5, t0.localhost AS localhost_6, t0.host_multilingual AS host_multilingual_7, t0.`default` AS default_8, t0.flag_icon AS flag_icon_9, t0.visible AS visible_10, t0.template_filter AS template_filter_11 FROM cms__site t0 WHERE t0.`default` = 1 LIMIT 1;
17	0.36 ms	SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.label AS label_2, c0_.type AS type_3, c0_.value AS value_4, c0_.position AS position_5, c0_.parent_heritance AS parent_heritance_6, c0_.active AS active_7, c0_.page_id AS page_id_8, c0_.shared_block_parent_id AS shared_block_parent_id_9, c0_.declination_id AS declination_id_10 FROM cms__content c0_ WHERE c0_.code = ? AND c0_.page_id = ? LIMIT 1 Parameters: [`"document" 30`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.label AS label_2, c0_.type AS type_3, c0_.value AS value_4, c0_.position AS position_5, c0_.parent_heritance AS parent_heritance_6, c0_.active AS active_7, c0_.page_id AS page_id_8, c0_.shared_block_parent_id AS shared_block_parent_id_9, c0_.declination_id AS declination_id_10 FROM cms__content c0_ WHERE c0_.code = ? AND c0_.page_id = ? LIMIT 1 SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.label AS label_2, c0_.type AS type_3, c0_.value AS value_4, c0_.position AS position_5, c0_.parent_heritance AS parent_heritance_6, c0_.active AS active_7, c0_.page_id AS page_id_8, c0_.shared_block_parent_id AS shared_block_parent_id_9, c0_.declination_id AS declination_id_10 FROM cms__content c0_ WHERE c0_.code = 'document' AND c0_.page_id = 30 LIMIT 1;
18	0.37 ms	SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.locale AS locale_4, t0.host AS host_5, t0.localhost AS localhost_6, t0.host_multilingual AS host_multilingual_7, t0.`default` AS default_8, t0.flag_icon AS flag_icon_9, t0.visible AS visible_10, t0.template_filter AS template_filter_11 FROM cms__site t0 WHERE t0.`default` = ? LIMIT 1 Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.locale AS locale_4, t0.host AS host_5, t0.localhost AS localhost_6, t0.host_multilingual AS host_multilingual_7, t0.`default` AS default_8, t0.flag_icon AS flag_icon_9, t0.visible AS visible_10, t0.template_filter AS template_filter_11 FROM cms__site t0 WHERE t0.`default` = ? LIMIT 1 SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.locale AS locale_4, t0.host AS host_5, t0.localhost AS localhost_6, t0.host_multilingual AS host_multilingual_7, t0.`default` AS default_8, t0.flag_icon AS flag_icon_9, t0.visible AS visible_10, t0.template_filter AS template_filter_11 FROM cms__site t0 WHERE t0.`default` = 1 LIMIT 1;
19	0.44 ms	SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.label AS label_2, c0_.type AS type_3, c0_.value AS value_4, c0_.position AS position_5, c0_.parent_heritance AS parent_heritance_6, c0_.active AS active_7, c0_.page_id AS page_id_8, c0_.shared_block_parent_id AS shared_block_parent_id_9, c0_.declination_id AS declination_id_10 FROM cms__content c0_ WHERE c0_.code = ? AND c0_.page_id = ? LIMIT 1 Parameters: [`"info" 30`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.label AS label_2, c0_.type AS type_3, c0_.value AS value_4, c0_.position AS position_5, c0_.parent_heritance AS parent_heritance_6, c0_.active AS active_7, c0_.page_id AS page_id_8, c0_.shared_block_parent_id AS shared_block_parent_id_9, c0_.declination_id AS declination_id_10 FROM cms__content c0_ WHERE c0_.code = ? AND c0_.page_id = ? LIMIT 1 SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.label AS label_2, c0_.type AS type_3, c0_.value AS value_4, c0_.position AS position_5, c0_.parent_heritance AS parent_heritance_6, c0_.active AS active_7, c0_.page_id AS page_id_8, c0_.shared_block_parent_id AS shared_block_parent_id_9, c0_.declination_id AS declination_id_10 FROM cms__content c0_ WHERE c0_.code = 'info' AND c0_.page_id = 30 LIMIT 1;
20	0.36 ms	SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.type AS type_4, t0.site_id AS site_id_5 FROM cms__menu t0 WHERE t0.code = ? AND t0.site_id = ? LIMIT 1 Parameters: [`"footer_menu" 1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.type AS type_4, t0.site_id AS site_id_5 FROM cms__menu t0 WHERE t0.code = ? AND t0.site_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.type AS type_4, t0.site_id AS site_id_5 FROM cms__menu t0 WHERE t0.code = 'footer_menu' AND t0.site_id = 1 LIMIT 1;
21	4.12 ms	SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.information AS information_2, c0_.link_type AS link_type_3, c0_.link_value AS link_value_4, c0_.is_visible AS is_visible_5, c0_.lvl AS lvl_6, c0_.lft AS lft_7, c0_.rgt AS rgt_8, c0_.li_class AS li_class_9, c0_.ul_class AS ul_class_10, c0_.link_class AS link_class_11, c0_.icon_class AS icon_class_12, c0_.connected AS connected_13, c0_.role AS role_14, c0_.params AS params_15, c0_.blank AS blank_16, c0_.anchor AS anchor_17, c1_.id AS id_18, c1_.title AS title_19, c1_.template AS template_20, c1_.slug AS slug_21, c1_.breadcrumb AS breadcrumb_22, c1_.active AS active_23, c1_.roles AS roles_24, c1_.lft AS lft_25, c1_.lvl AS lvl_26, c1_.rgt AS rgt_27, c1_.seo_title AS seo_title_28, c1_.seo_description AS seo_description_29, c1_.seo_keywords AS seo_keywords_30, c1_.og_title AS og_title_31, c1_.og_type AS og_type_32, c1_.og_description AS og_description_33, c1_.og_site_name AS og_site_name_34, c1_.twitter_card AS twitter_card_35, c1_.twitter_site AS twitter_site_36, c1_.twitter_title AS twitter_title_37, c1_.twitter_description AS twitter_description_38, c1_.twitter_creator AS twitter_creator_39, c1_.created_at AS created_at_40, c1_.updated_at AS updated_at_41, c2_.id AS id_42, c2_.name AS name_43, c2_.methods AS methods_44, c2_.path AS path_45, c2_.controller AS controller_46, c2_.defaults AS defaults_47, c2_.requirements AS requirements_48, c3_.id AS id_49, c3_.name AS name_50, c3_.information AS information_51, c3_.link_type AS link_type_52, c3_.link_value AS link_value_53, c3_.is_visible AS is_visible_54, c3_.lvl AS lvl_55, c3_.lft AS lft_56, c3_.rgt AS rgt_57, c3_.li_class AS li_class_58, c3_.ul_class AS ul_class_59, c3_.link_class AS link_class_60, c3_.icon_class AS icon_class_61, c3_.connected AS connected_62, c3_.role AS role_63, c3_.params AS params_64, c3_.blank AS blank_65, c3_.anchor AS anchor_66, c4_.id AS id_67, c4_.slug AS slug_68, c4_.label AS label_69, c4_.locale AS locale_70, c4_.host AS host_71, c4_.localhost AS localhost_72, c4_.host_multilingual AS host_multilingual_73, c4_.`default` AS default_74, c4_.flag_icon AS flag_icon_75, c4_.visible AS visible_76, c4_.template_filter AS template_filter_77, c5_.id AS id_78, c5_.code AS code_79, c5_.label AS label_80, c5_.type AS type_81, c5_.value AS value_82, c5_.position AS position_83, c5_.parent_heritance AS parent_heritance_84, c5_.active AS active_85, c0_.page_id AS page_id_86, c0_.tree_root AS tree_root_87, c0_.parent_id AS parent_id_88, c0_.menu_id AS menu_id_89, c1_.route_id AS route_id_90, c1_.site_id AS site_id_91, c1_.tree_root AS tree_root_92, c1_.parent_id AS parent_id_93, c1_.og_image_id AS og_image_id_94, c1_.twitter_image_id AS twitter_image_id_95, c2_.discr AS discr_96, c3_.page_id AS page_id_97, c3_.tree_root AS tree_root_98, c3_.parent_id AS parent_id_99, c3_.menu_id AS menu_id_100, c5_.page_id AS page_id_101, c5_.shared_block_parent_id AS shared_block_parent_id_102, c5_.declination_id AS declination_id_103 FROM cms__menu_item c0_ LEFT JOIN cms__page c1_ ON c0_.page_id = c1_.id LEFT JOIN cms__route c2_ ON c1_.route_id = c2_.id AND c2_.discr IN ('base') LEFT JOIN cms__menu_item c3_ ON c0_.id = c3_.parent_id LEFT JOIN cms__site c4_ ON c1_.site_id = c4_.id LEFT JOIN cms__content c5_ ON c1_.id = c5_.page_id WHERE c0_.menu_id = ? ORDER BY c0_.lft ASC, c3_.lft ASC, c5_.position ASC Parameters: [`2`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.information AS information_2, c0_.link_type AS link_type_3, c0_.link_value AS link_value_4, c0_.is_visible AS is_visible_5, c0_.lvl AS lvl_6, c0_.lft AS lft_7, c0_.rgt AS rgt_8, c0_.li_class AS li_class_9, c0_.ul_class AS ul_class_10, c0_.link_class AS link_class_11, c0_.icon_class AS icon_class_12, c0_.connected AS connected_13, c0_.role AS role_14, c0_.params AS params_15, c0_.blank AS blank_16, c0_.anchor AS anchor_17, c1_.id AS id_18, c1_.title AS title_19, c1_.template AS template_20, c1_.slug AS slug_21, c1_.breadcrumb AS breadcrumb_22, c1_.active AS active_23, c1_.roles AS roles_24, c1_.lft AS lft_25, c1_.lvl AS lvl_26, c1_.rgt AS rgt_27, c1_.seo_title AS seo_title_28, c1_.seo_description AS seo_description_29, c1_.seo_keywords AS seo_keywords_30, c1_.og_title AS og_title_31, c1_.og_type AS og_type_32, c1_.og_description AS og_description_33, c1_.og_site_name AS og_site_name_34, c1_.twitter_card AS twitter_card_35, c1_.twitter_site AS twitter_site_36, c1_.twitter_title AS twitter_title_37, c1_.twitter_description AS twitter_description_38, c1_.twitter_creator AS twitter_creator_39, c1_.created_at AS created_at_40, c1_.updated_at AS updated_at_41, c2_.id AS id_42, c2_.name AS name_43, c2_.methods AS methods_44, c2_.path AS path_45, c2_.controller AS controller_46, c2_.defaults AS defaults_47, c2_.requirements AS requirements_48, c3_.id AS id_49, c3_.name AS name_50, c3_.information AS information_51, c3_.link_type AS link_type_52, c3_.link_value AS link_value_53, c3_.is_visible AS is_visible_54, c3_.lvl AS lvl_55, c3_.lft AS lft_56, c3_.rgt AS rgt_57, c3_.li_class AS li_class_58, c3_.ul_class AS ul_class_59, c3_.link_class AS link_class_60, c3_.icon_class AS icon_class_61, c3_.connected AS connected_62, c3_.role AS role_63, c3_.params AS params_64, c3_.blank AS blank_65, c3_.anchor AS anchor_66, c4_.id AS id_67, c4_.slug AS slug_68, c4_.label AS label_69, c4_.locale AS locale_70, c4_.host AS host_71, c4_.localhost AS localhost_72, c4_.host_multilingual AS host_multilingual_73, c4_.`default` AS default_74, c4_.flag_icon AS flag_icon_75, c4_.visible AS visible_76, c4_.template_filter AS template_filter_77, c5_.id AS id_78, c5_.code AS code_79, c5_.label AS label_80, c5_.type AS type_81, c5_.value AS value_82, c5_.position AS position_83, c5_.parent_heritance AS parent_heritance_84, c5_.active AS active_85, c0_.page_id AS page_id_86, c0_.tree_root AS tree_root_87, c0_.parent_id AS parent_id_88, c0_.menu_id AS menu_id_89, c1_.route_id AS route_id_90, c1_.site_id AS site_id_91, c1_.tree_root AS tree_root_92, c1_.parent_id AS parent_id_93, c1_.og_image_id AS og_image_id_94, c1_.twitter_image_id AS twitter_image_id_95, c2_.discr AS discr_96, c3_.page_id AS page_id_97, c3_.tree_root AS tree_root_98, c3_.parent_id AS parent_id_99, c3_.menu_id AS menu_id_100, c5_.page_id AS page_id_101, c5_.shared_block_parent_id AS shared_block_parent_id_102, c5_.declination_id AS declination_id_103 FROM cms__menu_item c0_ LEFT JOIN cms__page c1_ ON c0_.page_id = c1_.id LEFT JOIN cms__route c2_ ON c1_.route_id = c2_.id AND c2_.discr IN ('base') LEFT JOIN cms__menu_item c3_ ON c0_.id = c3_.parent_id LEFT JOIN cms__site c4_ ON c1_.site_id = c4_.id LEFT JOIN cms__content c5_ ON c1_.id = c5_.page_id WHERE c0_.menu_id = ? ORDER BY c0_.lft ASC, c3_.lft ASC, c5_.position ASC SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.information AS information_2, c0_.link_type AS link_type_3, c0_.link_value AS link_value_4, c0_.is_visible AS is_visible_5, c0_.lvl AS lvl_6, c0_.lft AS lft_7, c0_.rgt AS rgt_8, c0_.li_class AS li_class_9, c0_.ul_class AS ul_class_10, c0_.link_class AS link_class_11, c0_.icon_class AS icon_class_12, c0_.connected AS connected_13, c0_.role AS role_14, c0_.params AS params_15, c0_.blank AS blank_16, c0_.anchor AS anchor_17, c1_.id AS id_18, c1_.title AS title_19, c1_.template AS template_20, c1_.slug AS slug_21, c1_.breadcrumb AS breadcrumb_22, c1_.active AS active_23, c1_.roles AS roles_24, c1_.lft AS lft_25, c1_.lvl AS lvl_26, c1_.rgt AS rgt_27, c1_.seo_title AS seo_title_28, c1_.seo_description AS seo_description_29, c1_.seo_keywords AS seo_keywords_30, c1_.og_title AS og_title_31, c1_.og_type AS og_type_32, c1_.og_description AS og_description_33, c1_.og_site_name AS og_site_name_34, c1_.twitter_card AS twitter_card_35, c1_.twitter_site AS twitter_site_36, c1_.twitter_title AS twitter_title_37, c1_.twitter_description AS twitter_description_38, c1_.twitter_creator AS twitter_creator_39, c1_.created_at AS created_at_40, c1_.updated_at AS updated_at_41, c2_.id AS id_42, c2_.name AS name_43, c2_.methods AS methods_44, c2_.path AS path_45, c2_.controller AS controller_46, c2_.defaults AS defaults_47, c2_.requirements AS requirements_48, c3_.id AS id_49, c3_.name AS name_50, c3_.information AS information_51, c3_.link_type AS link_type_52, c3_.link_value AS link_value_53, c3_.is_visible AS is_visible_54, c3_.lvl AS lvl_55, c3_.lft AS lft_56, c3_.rgt AS rgt_57, c3_.li_class AS li_class_58, c3_.ul_class AS ul_class_59, c3_.link_class AS link_class_60, c3_.icon_class AS icon_class_61, c3_.connected AS connected_62, c3_.role AS role_63, c3_.params AS params_64, c3_.blank AS blank_65, c3_.anchor AS anchor_66, c4_.id AS id_67, c4_.slug AS slug_68, c4_.label AS label_69, c4_.locale AS locale_70, c4_.host AS host_71, c4_.localhost AS localhost_72, c4_.host_multilingual AS host_multilingual_73, c4_.`default` AS default_74, c4_.flag_icon AS flag_icon_75, c4_.visible AS visible_76, c4_.template_filter AS template_filter_77, c5_.id AS id_78, c5_.code AS code_79, c5_.label AS label_80, c5_.type AS type_81, c5_.value AS value_82, c5_.position AS position_83, c5_.parent_heritance AS parent_heritance_84, c5_.active AS active_85, c0_.page_id AS page_id_86, c0_.tree_root AS tree_root_87, c0_.parent_id AS parent_id_88, c0_.menu_id AS menu_id_89, c1_.route_id AS route_id_90, c1_.site_id AS site_id_91, c1_.tree_root AS tree_root_92, c1_.parent_id AS parent_id_93, c1_.og_image_id AS og_image_id_94, c1_.twitter_image_id AS twitter_image_id_95, c2_.discr AS discr_96, c3_.page_id AS page_id_97, c3_.tree_root AS tree_root_98, c3_.parent_id AS parent_id_99, c3_.menu_id AS menu_id_100, c5_.page_id AS page_id_101, c5_.shared_block_parent_id AS shared_block_parent_id_102, c5_.declination_id AS declination_id_103 FROM cms__menu_item c0_ LEFT JOIN cms__page c1_ ON c0_.page_id = c1_.id LEFT JOIN cms__route c2_ ON c1_.route_id = c2_.id AND c2_.discr IN ('base') LEFT JOIN cms__menu_item c3_ ON c0_.id = c3_.parent_id LEFT JOIN cms__site c4_ ON c1_.site_id = c4_.id LEFT JOIN cms__content c5_ ON c1_.id = c5_.page_id WHERE c0_.menu_id = 2 ORDER BY c0_.lft ASC, c3_.lft ASC, c5_.position ASC;
22	0.51 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.information AS information_3, t0.link_type AS link_type_4, t0.link_value AS link_value_5, t0.is_visible AS is_visible_6, t0.lvl AS lvl_7, t0.lft AS lft_8, t0.rgt AS rgt_9, t0.li_class AS li_class_10, t0.ul_class AS ul_class_11, t0.link_class AS link_class_12, t0.icon_class AS icon_class_13, t0.connected AS connected_14, t0.role AS role_15, t0.params AS params_16, t0.blank AS blank_17, t0.anchor AS anchor_18, t0.page_id AS page_id_19, t0.tree_root AS tree_root_20, t0.parent_id AS parent_id_21, t0.menu_id AS menu_id_22 FROM cms__menu_item t0 WHERE t0.menu_id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.information AS information_3, t0.link_type AS link_type_4, t0.link_value AS link_value_5, t0.is_visible AS is_visible_6, t0.lvl AS lvl_7, t0.lft AS lft_8, t0.rgt AS rgt_9, t0.li_class AS li_class_10, t0.ul_class AS ul_class_11, t0.link_class AS link_class_12, t0.icon_class AS icon_class_13, t0.connected AS connected_14, t0.role AS role_15, t0.params AS params_16, t0.blank AS blank_17, t0.anchor AS anchor_18, t0.page_id AS page_id_19, t0.tree_root AS tree_root_20, t0.parent_id AS parent_id_21, t0.menu_id AS menu_id_22 FROM cms__menu_item t0 WHERE t0.menu_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.information AS information_3, t0.link_type AS link_type_4, t0.link_value AS link_value_5, t0.is_visible AS is_visible_6, t0.lvl AS lvl_7, t0.lft AS lft_8, t0.rgt AS rgt_9, t0.li_class AS li_class_10, t0.ul_class AS ul_class_11, t0.link_class AS link_class_12, t0.icon_class AS icon_class_13, t0.connected AS connected_14, t0.role AS role_15, t0.params AS params_16, t0.blank AS blank_17, t0.anchor AS anchor_18, t0.page_id AS page_id_19, t0.tree_root AS tree_root_20, t0.parent_id AS parent_id_21, t0.menu_id AS menu_id_22 FROM cms__menu_item t0 WHERE t0.menu_id = 2;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\Box\Box	No errors.
App\Entity\Box\BoxHome	No errors.
App\Entity\Box\BoxCustom	No errors.
App\Entity\Box\BoxCustom2	No errors.
App\Entity\Box\BoxTeam	No errors.
App\Entity\Box\BoxWhoAreWe	No errors.
App\Entity\Box\BoxWhyJoin	No errors.
WebEtDesign\CmsBundle\Entity\CmsPage	No errors.
WebEtDesign\CmsBundle\Entity\AbstractCmsRoute	No errors.
WebEtDesign\CmsBundle\Entity\CmsRoute	No errors.
WebEtDesign\CmsBundle\Entity\CmsSite	No errors.
WebEtDesign\CmsBundle\Entity\CmsPageDeclination	No errors.
WebEtDesign\MediaBundle\Entity\Media	No errors.
WebEtDesign\CmsBundle\Entity\CmsContent	No errors.
WebEtDesign\CmsBundle\Entity\CmsMenuItem	No errors.
WebEtDesign\CmsBundle\Entity\CmsMenu	No errors.
WebEtDesign\CmsBundle\Entity\CmsSharedBlock	No errors.
App\Entity\PublicEnquiry\PublicEnquiry	No errors.
App\Entity\PublicEnquiry\PublicEnquiryType	No errors.
App\Entity\User\Provider	No errors.
WebEtDesign\UserBundle\Entity\WDUser	No errors.
App\Entity\User\User	No errors.
App\Entity\Department	No errors.
App\Entity\Region	No errors.
App\Entity\PublicEnquiry\PublicEnquiryAlert	No errors.
App\Entity\Firm	No errors.

Symfony Profiler

GET https://cce26.webetdesign.com/procedure/38

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping