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 = 'cnce.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 = 'news_list';

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      sclr_18
    FROM
      (
        SELECT
          n0_.id AS id_0,
          n0_.title AS title_1,
          n0_.slug AS slug_2,
          n0_.excerpt AS excerpt_3,
          n0_.content AS content_4,
          n0_.picture AS picture_5,
          n0_.picture_og AS picture_og_6,
          n0_.picture1 AS picture1_7,
          n0_.picture2 AS picture2_8,
          n0_.picture3 AS picture3_9,
          n0_.picture4 AS picture4_10,
          n0_.published AS published_11,
          n0_.published_at AS published_at_12,
          n0_.notified_at AS notified_at_13,
          n0_.last_update AS last_update_14,
          n0_.reserved AS reserved_15,
          n0_.created_at AS created_at_16,
          n0_.updated_at AS updated_at_17,
          CASE WHEN n0_.last_update IS NULL THEN
            n0_.published_at
          ELSE
            n0_.last_update
          END AS sclr_18
        FROM
          news n0_
        WHERE
          n0_.published = ?
          AND n0_.published_at < ?
          AND n0_.box_id IS NULL
      ) dctrn_result_inner
    ORDER BY
      sclr_18 DESC
  ) dctrn_result
LIMIT
  15

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, sclr_18 FROM (SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.excerpt AS excerpt_3, n0_.content AS content_4, n0_.picture AS picture_5, n0_.picture_og AS picture_og_6, n0_.picture1 AS picture1_7, n0_.picture2 AS picture2_8, n0_.picture3 AS picture3_9, n0_.picture4 AS picture4_10, n0_.published AS published_11, n0_.published_at AS published_at_12, n0_.notified_at AS notified_at_13, n0_.last_update AS last_update_14, n0_.reserved AS reserved_15, n0_.created_at AS created_at_16, n0_.updated_at AS updated_at_17, CASE WHEN n0_.last_update IS NULL THEN n0_.published_at ELSE n0_.last_update END AS sclr_18 FROM news n0_ WHERE n0_.published = 1 AND n0_.published_at < '2024-11-21 07:47:02' AND n0_.box_id IS NULL) dctrn_result_inner ORDER BY sclr_18 DESC) dctrn_result LIMIT 15;

SELECT
  n0_.id AS id_0,
  n0_.title AS title_1,
  n0_.slug AS slug_2,
  n0_.excerpt AS excerpt_3,
  n0_.content AS content_4,
  n0_.picture AS picture_5,
  n0_.picture_og AS picture_og_6,
  n0_.picture1 AS picture1_7,
  n0_.picture2 AS picture2_8,
  n0_.picture3 AS picture3_9,
  n0_.picture4 AS picture4_10,
  n0_.published AS published_11,
  n0_.published_at AS published_at_12,
  n0_.notified_at AS notified_at_13,
  n0_.last_update AS last_update_14,
  n0_.reserved AS reserved_15,
  n0_.created_at AS created_at_16,
  n0_.updated_at AS updated_at_17,
  CASE WHEN n0_.last_update IS NULL THEN
    n0_.published_at
  ELSE
    n0_.last_update
  END AS sclr_18,
  n0_.box_id AS box_id_19
FROM
  news n0_
WHERE
  n0_.published = ?
  AND n0_.published_at < ?
  AND n0_.box_id IS NULL
  AND n0_.id IN (?, ?, ?, ?, ?)
ORDER BY
  sclr_18 DESC

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.excerpt AS excerpt_3, n0_.content AS content_4, n0_.picture AS picture_5, n0_.picture_og AS picture_og_6, n0_.picture1 AS picture1_7, n0_.picture2 AS picture2_8, n0_.picture3 AS picture3_9, n0_.picture4 AS picture4_10, n0_.published AS published_11, n0_.published_at AS published_at_12, n0_.notified_at AS notified_at_13, n0_.last_update AS last_update_14, n0_.reserved AS reserved_15, n0_.created_at AS created_at_16, n0_.updated_at AS updated_at_17, CASE WHEN n0_.last_update IS NULL THEN n0_.published_at ELSE n0_.last_update END AS sclr_18, n0_.box_id AS box_id_19 FROM news n0_ WHERE n0_.published = 1 AND n0_.published_at < '2024-11-21 07:47:02' AND n0_.box_id IS NULL AND n0_.id IN (9, 14, 28, 12, 79) ORDER BY sclr_18 DESC;

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

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