Symfony Profiler

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 = 'ccelyon.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
  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
        FROM
          public_enquiry__public_enquiry p0_
          LEFT JOIN public_enquiry__type p1_ ON p0_.type_id = p1_.id
          LEFT JOIN public_enquiry__public_enquiry_has_department p3_ ON p0_.id = p3_.public_enquiry_id
          LEFT JOIN department d2_ ON d2_.id = p3_.department_id
        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 FROM public_enquiry__public_enquiry p0_ LEFT JOIN public_enquiry__type p1_ ON p0_.type_id = p1_.id LEFT JOIN public_enquiry__public_enquiry_has_department p3_ ON p0_.id = p3_.public_enquiry_id LEFT JOIN department d2_ ON d2_.id = p3_.department_id WHERE p0_.is_published = 1 ORDER BY p0_.created_at DESC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      created_at_24
    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
        FROM
          public_enquiry__public_enquiry p0_
          LEFT JOIN public_enquiry__type p1_ ON p0_.type_id = p1_.id
          LEFT JOIN public_enquiry__public_enquiry_has_department p3_ ON p0_.id = p3_.public_enquiry_id
          LEFT JOIN department d2_ ON d2_.id = p3_.department_id
        WHERE
          p0_.is_published = ?
      ) dctrn_result_inner
    ORDER BY
      created_at_24 DESC
  ) dctrn_result
LIMIT
  16 OFFSET 64

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, created_at_24 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 FROM public_enquiry__public_enquiry p0_ LEFT JOIN public_enquiry__type p1_ ON p0_.type_id = p1_.id LEFT JOIN public_enquiry__public_enquiry_has_department p3_ ON p0_.id = p3_.public_enquiry_id LEFT JOIN department d2_ ON d2_.id = p3_.department_id WHERE p0_.is_published = 1) dctrn_result_inner ORDER BY created_at_24 DESC) dctrn_result LIMIT 16 OFFSET 64;

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_.type_id AS type_id_28,
  p0_.provider_id AS provider_id_29,
  p0_.user_id AS user_id_30
FROM
  public_enquiry__public_enquiry p0_
  LEFT JOIN public_enquiry__type p1_ ON p0_.type_id = p1_.id
  LEFT JOIN public_enquiry__public_enquiry_has_department p3_ ON p0_.id = p3_.public_enquiry_id
  LEFT JOIN department d2_ ON d2_.id = p3_.department_id
WHERE
  p0_.is_published = ?
  AND p0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  p0_.created_at DESC

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_.type_id AS type_id_28, p0_.provider_id AS provider_id_29, p0_.user_id AS user_id_30 FROM public_enquiry__public_enquiry p0_ LEFT JOIN public_enquiry__type p1_ ON p0_.type_id = p1_.id LEFT JOIN public_enquiry__public_enquiry_has_department p3_ ON p0_.id = p3_.public_enquiry_id LEFT JOIN department d2_ ON d2_.id = p3_.department_id WHERE p0_.is_published = 1 AND p0_.id IN (39, 38, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 27, 26, 25, 14) ORDER BY p0_.created_at DESC;

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
  p0_.id AS id_0,
  p0_.title AS title_1
FROM
  public_enquiry__type p0_
ORDER BY
  p0_.title ASC

SELECT p0_.id AS id_0, p0_.title AS title_1 FROM public_enquiry__type p0_ ORDER BY p0_.title ASC;

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  public_enquiry__public_enquiry p0_
WHERE
  p0_.is_published = ?

SELECT COUNT(p0_.id) AS sclr_0 FROM public_enquiry__public_enquiry p0_ WHERE p0_.is_published = 1;

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  public_enquiry__public_enquiry p0_
WHERE
  p0_.is_published = ?
  AND p0_.begin_date <= ?
  AND COALESCE(
    p0_.extension_date, p0_.end_date
  ) > ?

SELECT COUNT(p0_.id) AS sclr_0 FROM public_enquiry__public_enquiry p0_ WHERE p0_.is_published = 1 AND p0_.begin_date <= '2024-09-19 03:52:19' AND COALESCE(p0_.extension_date, p0_.end_date) > '2024-09-19 03:52:19';

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  public_enquiry__public_enquiry p0_
WHERE
  p0_.is_published = ?
  AND COALESCE(
    p0_.extension_date, p0_.end_date
  ) <= ?

SELECT COUNT(p0_.id) AS sclr_0 FROM public_enquiry__public_enquiry p0_ WHERE p0_.is_published = 1 AND COALESCE(p0_.extension_date, p0_.end_date) <= '2024-09-19 03:52:19';

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  public_enquiry__public_enquiry p0_
WHERE
  p0_.is_published = ?
  AND p0_.begin_date > ?

SELECT COUNT(p0_.id) AS sclr_0 FROM public_enquiry__public_enquiry p0_ WHERE p0_.is_published = 1 AND p0_.begin_date > '2024-09-19 03:52:19';

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;

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
  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