Symfony Profiler

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;

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 = 103;

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 = 29 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 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;

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;

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 = 'cce38.webetdesign.com' 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 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 = 'list_enquiries';

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;

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;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.title AS title_1,
          p0_.description AS description_2,
          p0_.picture AS picture_3,
          p0_.link AS link_4,
          p0_.begin_date AS begin_date_5,
          p0_.end_date AS end_date_6,
          p0_.extension_date AS extension_date_7,
          p0_.document_order_public_enquiry AS document_order_public_enquiry_8,
          p0_.document_notice_public_enquiry AS document_notice_public_enquiry_9,
          p0_.document_report_public_enquiry AS document_report_public_enquiry_10,
          p0_.document_decision AS document_decision_11,
          p0_.link_order_public_enquiry AS link_order_public_enquiry_12,
          p0_.link_notice_public_enquiry AS link_notice_public_enquiry_13,
          p0_.link_report_public_enquiry AS link_report_public_enquiry_14,
          p0_.link_decision AS link_decision_15,
          p0_.publication_status AS publication_status_16,
          p0_.is_published AS is_published_17,
          p0_.nb_persons_received AS nb_persons_received_18,
          p0_.nb_observations_filed AS nb_observations_filed_19,
          p0_.nb_observations_numeric AS nb_observations_numeric_20,
          p0_.nb_observations_paper AS nb_observations_paper_21,
          p0_.nb_observations_oral AS nb_observations_oral_22,
          p0_.nb_public_meeting_done AS nb_public_meeting_done_23,
          p0_.created_at AS created_at_24,
          p0_.updated_at AS updated_at_25,
          p0_.reportUpdatedAt AS reportUpdatedAt_26,
          p0_.alert_sent_at AS alert_sent_at_27,
          p0_.designation AS designation_28,
          p0_.place AS place_29,
          p0_.actors AS actors_30,
          p0_.project_owner_type AS project_owner_type_31
        FROM
          public_enquiry__public_enquiry p0_
        WHERE
          p0_.is_published = ?
        ORDER BY
          p0_.created_at DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.description AS description_2, p0_.picture AS picture_3, p0_.link AS link_4, p0_.begin_date AS begin_date_5, p0_.end_date AS end_date_6, p0_.extension_date AS extension_date_7, p0_.document_order_public_enquiry AS document_order_public_enquiry_8, p0_.document_notice_public_enquiry AS document_notice_public_enquiry_9, p0_.document_report_public_enquiry AS document_report_public_enquiry_10, p0_.document_decision AS document_decision_11, p0_.link_order_public_enquiry AS link_order_public_enquiry_12, p0_.link_notice_public_enquiry AS link_notice_public_enquiry_13, p0_.link_report_public_enquiry AS link_report_public_enquiry_14, p0_.link_decision AS link_decision_15, p0_.publication_status AS publication_status_16, p0_.is_published AS is_published_17, p0_.nb_persons_received AS nb_persons_received_18, p0_.nb_observations_filed AS nb_observations_filed_19, p0_.nb_observations_numeric AS nb_observations_numeric_20, p0_.nb_observations_paper AS nb_observations_paper_21, p0_.nb_observations_oral AS nb_observations_oral_22, p0_.nb_public_meeting_done AS nb_public_meeting_done_23, p0_.created_at AS created_at_24, p0_.updated_at AS updated_at_25, p0_.reportUpdatedAt AS reportUpdatedAt_26, p0_.alert_sent_at AS alert_sent_at_27, p0_.designation AS designation_28, p0_.place AS place_29, p0_.actors AS actors_30, p0_.project_owner_type AS project_owner_type_31 FROM public_enquiry__public_enquiry p0_ WHERE p0_.is_published = 1 ORDER BY p0_.created_at DESC) dctrn_result) dctrn_table;