Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.name AS name_5,
  t0.first_name AS first_name_6,
  t0.title AS title_7,
  t0.job AS job_8,
  t0.shop AS shop_9,
  t0.email AS email_10,
  t0.tier_code AS tier_code_11,
  t0.creator AS creator_12,
  t0.last_update_user AS last_update_user_13,
  t0.creation_date AS creation_date_14,
  t0.last_update_date AS last_update_date_15,
  t0.last_login_date AS last_login_date_16,
  t0.is_test AS is_test_17,
  t0.test_profile_id AS test_profile_id_18
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.first_name AS first_name_6, t0.title AS title_7, t0.job AS job_8, t0.shop AS shop_9, t0.email AS email_10, t0.tier_code AS tier_code_11, t0.creator AS creator_12, t0.last_update_user AS last_update_user_13, t0.creation_date AS creation_date_14, t0.last_update_date AS last_update_date_15, t0.last_login_date AS last_login_date_16, t0.is_test AS is_test_17, t0.test_profile_id AS test_profile_id_18 FROM user t0 WHERE t0.id = 24;

SELECT
  c0_.icon AS icon_0,
  c0_.name AS name_1,
  m1_.id AS id_2,
  m1_.new AS new_3,
  m1_.display AS display_4,
  m1_.creator AS creator_5,
  m1_.last_update_user AS last_update_user_6,
  m1_.creation_date AS creation_date_7,
  m1_.last_update_date AS last_update_date_8,
  m2_.id AS id_9,
  m2_.title AS title_10,
  m2_.type AS type_11,
  m2_.description AS description_12,
  m2_.content AS content_13,
  m2_.in_homepage AS in_homepage_14,
  m2_.active AS active_15,
  m2_.start_date AS start_date_16,
  m2_.end_date AS end_date_17,
  m2_.limit_response_date AS limit_response_date_18,
  m2_.event_date AS event_date_19,
  m2_.creator AS creator_20,
  m2_.last_update_user AS last_update_user_21,
  m2_.creation_date AS creation_date_22,
  m2_.last_update_date AS last_update_date_23,
  m2_.slug AS slug_24,
  m1_.message_id AS message_id_25,
  m1_.user_id AS user_id_26,
  m2_.category_id AS category_id_27
FROM
  message_for_user m1_
  LEFT JOIN message m2_ ON m1_.message_id = m2_.id
  LEFT JOIN category c0_ ON m2_.category_id = c0_.id
WHERE
  m1_.user_id = ?
  AND (m2_.active <> ?)
  AND m1_.display = 1
  AND m2_.type = ?
  AND m2_.in_homepage <> ?
  AND (
    (
      m2_.start_date < ?
      AND m2_.end_date > ?
    )
    OR (
      m2_.start_date < ?
      AND m2_.end_date IS NULL
    )
    OR (
      m2_.start_date IS NULL
      AND m2_.end_date > ?
    )
    OR (
      m2_.start_date IS NULL
      AND m2_.end_date IS NULL
    )
  )
ORDER BY
  m2_.start_date DESC
LIMIT
  4

SELECT c0_.icon AS icon_0, c0_.name AS name_1, m1_.id AS id_2, m1_.new AS new_3, m1_.display AS display_4, m1_.creator AS creator_5, m1_.last_update_user AS last_update_user_6, m1_.creation_date AS creation_date_7, m1_.last_update_date AS last_update_date_8, m2_.id AS id_9, m2_.title AS title_10, m2_.type AS type_11, m2_.description AS description_12, m2_.content AS content_13, m2_.in_homepage AS in_homepage_14, m2_.active AS active_15, m2_.start_date AS start_date_16, m2_.end_date AS end_date_17, m2_.limit_response_date AS limit_response_date_18, m2_.event_date AS event_date_19, m2_.creator AS creator_20, m2_.last_update_user AS last_update_user_21, m2_.creation_date AS creation_date_22, m2_.last_update_date AS last_update_date_23, m2_.slug AS slug_24, m1_.message_id AS message_id_25, m1_.user_id AS user_id_26, m2_.category_id AS category_id_27 FROM message_for_user m1_ LEFT JOIN message m2_ ON m1_.message_id = m2_.id LEFT JOIN category c0_ ON m2_.category_id = c0_.id WHERE m1_.user_id = 24 AND (m2_.active <> 0) AND m1_.display = 1 AND m2_.type = 'Mes messages' AND m2_.in_homepage <> 0 AND ((m2_.start_date < '2026-03-12 15:31:50' AND m2_.end_date > '2026-03-12 15:31:50') OR (m2_.start_date < '2026-03-12 15:31:50' AND m2_.end_date IS NULL) OR (m2_.start_date IS NULL AND m2_.end_date > '2026-03-12 15:31:50') OR (m2_.start_date IS NULL AND m2_.end_date IS NULL)) ORDER BY m2_.start_date DESC LIMIT 4;

SELECT
  c0_.icon AS icon_0,
  c0_.name AS name_1,
  m1_.id AS id_2,
  m1_.new AS new_3,
  m1_.display AS display_4,
  m1_.creator AS creator_5,
  m1_.last_update_user AS last_update_user_6,
  m1_.creation_date AS creation_date_7,
  m1_.last_update_date AS last_update_date_8,
  m2_.id AS id_9,
  m2_.title AS title_10,
  m2_.type AS type_11,
  m2_.description AS description_12,
  m2_.content AS content_13,
  m2_.in_homepage AS in_homepage_14,
  m2_.active AS active_15,
  m2_.start_date AS start_date_16,
  m2_.end_date AS end_date_17,
  m2_.limit_response_date AS limit_response_date_18,
  m2_.event_date AS event_date_19,
  m2_.creator AS creator_20,
  m2_.last_update_user AS last_update_user_21,
  m2_.creation_date AS creation_date_22,
  m2_.last_update_date AS last_update_date_23,
  m2_.slug AS slug_24,
  m1_.message_id AS message_id_25,
  m1_.user_id AS user_id_26,
  m2_.category_id AS category_id_27
FROM
  message_for_user m1_
  LEFT JOIN message m2_ ON m1_.message_id = m2_.id
  LEFT JOIN category c0_ ON m2_.category_id = c0_.id
WHERE
  m1_.user_id = ?
  AND (m2_.active <> ?)
  AND m1_.display = 1
  AND m2_.type = ?
  AND m2_.in_homepage <> ?
  AND (
    (
      m2_.start_date < ?
      AND m2_.end_date > ?
    )
    OR (
      m2_.start_date < ?
      AND m2_.end_date IS NULL
    )
    OR (
      m2_.start_date IS NULL
      AND m2_.end_date > ?
    )
    OR (
      m2_.start_date IS NULL
      AND m2_.end_date IS NULL
    )
  )
ORDER BY
  m2_.event_date ASC,
  m2_.start_date DESC
LIMIT
  4

SELECT c0_.icon AS icon_0, c0_.name AS name_1, m1_.id AS id_2, m1_.new AS new_3, m1_.display AS display_4, m1_.creator AS creator_5, m1_.last_update_user AS last_update_user_6, m1_.creation_date AS creation_date_7, m1_.last_update_date AS last_update_date_8, m2_.id AS id_9, m2_.title AS title_10, m2_.type AS type_11, m2_.description AS description_12, m2_.content AS content_13, m2_.in_homepage AS in_homepage_14, m2_.active AS active_15, m2_.start_date AS start_date_16, m2_.end_date AS end_date_17, m2_.limit_response_date AS limit_response_date_18, m2_.event_date AS event_date_19, m2_.creator AS creator_20, m2_.last_update_user AS last_update_user_21, m2_.creation_date AS creation_date_22, m2_.last_update_date AS last_update_date_23, m2_.slug AS slug_24, m1_.message_id AS message_id_25, m1_.user_id AS user_id_26, m2_.category_id AS category_id_27 FROM message_for_user m1_ LEFT JOIN message m2_ ON m1_.message_id = m2_.id LEFT JOIN category c0_ ON m2_.category_id = c0_.id WHERE m1_.user_id = 24 AND (m2_.active <> 0) AND m1_.display = 1 AND m2_.type = 'Mes tâches' AND m2_.in_homepage <> 0 AND ((m2_.start_date < '2026-03-12 15:31:50' AND m2_.end_date > '2026-03-12 15:31:50') OR (m2_.start_date < '2026-03-12 15:31:50' AND m2_.end_date IS NULL) OR (m2_.start_date IS NULL AND m2_.end_date > '2026-03-12 15:31:50') OR (m2_.start_date IS NULL AND m2_.end_date IS NULL)) ORDER BY m2_.event_date ASC, m2_.start_date DESC LIMIT 4;

SELECT
  c0_.icon AS icon_0,
  c0_.name AS name_1,
  m1_.id AS id_2,
  m1_.new AS new_3,
  m1_.display AS display_4,
  m1_.creator AS creator_5,
  m1_.last_update_user AS last_update_user_6,
  m1_.creation_date AS creation_date_7,
  m1_.last_update_date AS last_update_date_8,
  m2_.id AS id_9,
  m2_.title AS title_10,
  m2_.type AS type_11,
  m2_.description AS description_12,
  m2_.content AS content_13,
  m2_.in_homepage AS in_homepage_14,
  m2_.active AS active_15,
  m2_.start_date AS start_date_16,
  m2_.end_date AS end_date_17,
  m2_.limit_response_date AS limit_response_date_18,
  m2_.event_date AS event_date_19,
  m2_.creator AS creator_20,
  m2_.last_update_user AS last_update_user_21,
  m2_.creation_date AS creation_date_22,
  m2_.last_update_date AS last_update_date_23,
  m2_.slug AS slug_24,
  m1_.message_id AS message_id_25,
  m1_.user_id AS user_id_26,
  m2_.category_id AS category_id_27
FROM
  message_for_user m1_
  LEFT JOIN message m2_ ON m1_.message_id = m2_.id
  LEFT JOIN category c0_ ON m2_.category_id = c0_.id
WHERE
  m1_.user_id = ?
  AND (m2_.active <> ?)
  AND m1_.display = 1
  AND m2_.type = ?
  AND m2_.in_homepage <> ?
  AND (
    (
      m2_.start_date < ?
      AND m2_.end_date > ?
    )
    OR (
      m2_.start_date < ?
      AND m2_.end_date IS NULL
    )
    OR (
      m2_.start_date IS NULL
      AND m2_.end_date > ?
    )
    OR (
      m2_.start_date IS NULL
      AND m2_.end_date IS NULL
    )
  )
ORDER BY
  m2_.event_date ASC,
  m2_.start_date DESC
LIMIT
  4

SELECT c0_.icon AS icon_0, c0_.name AS name_1, m1_.id AS id_2, m1_.new AS new_3, m1_.display AS display_4, m1_.creator AS creator_5, m1_.last_update_user AS last_update_user_6, m1_.creation_date AS creation_date_7, m1_.last_update_date AS last_update_date_8, m2_.id AS id_9, m2_.title AS title_10, m2_.type AS type_11, m2_.description AS description_12, m2_.content AS content_13, m2_.in_homepage AS in_homepage_14, m2_.active AS active_15, m2_.start_date AS start_date_16, m2_.end_date AS end_date_17, m2_.limit_response_date AS limit_response_date_18, m2_.event_date AS event_date_19, m2_.creator AS creator_20, m2_.last_update_user AS last_update_user_21, m2_.creation_date AS creation_date_22, m2_.last_update_date AS last_update_date_23, m2_.slug AS slug_24, m1_.message_id AS message_id_25, m1_.user_id AS user_id_26, m2_.category_id AS category_id_27 FROM message_for_user m1_ LEFT JOIN message m2_ ON m1_.message_id = m2_.id LEFT JOIN category c0_ ON m2_.category_id = c0_.id WHERE m1_.user_id = 24 AND (m2_.active <> 0) AND m1_.display = 1 AND m2_.type = 'Mon agenda' AND m2_.in_homepage <> 0 AND ((m2_.start_date < '2026-03-12 15:31:50' AND m2_.end_date > '2026-03-12 15:31:50') OR (m2_.start_date < '2026-03-12 15:31:50' AND m2_.end_date IS NULL) OR (m2_.start_date IS NULL AND m2_.end_date > '2026-03-12 15:31:50') OR (m2_.start_date IS NULL AND m2_.end_date IS NULL)) ORDER BY m2_.event_date ASC, m2_.start_date DESC LIMIT 4;

SELECT
  c0_.icon AS icon_0,
  c0_.name AS name_1,
  m1_.id AS id_2,
  m1_.new AS new_3,
  m1_.display AS display_4,
  m1_.creator AS creator_5,
  m1_.last_update_user AS last_update_user_6,
  m1_.creation_date AS creation_date_7,
  m1_.last_update_date AS last_update_date_8,
  m2_.id AS id_9,
  m2_.title AS title_10,
  m2_.type AS type_11,
  m2_.description AS description_12,
  m2_.content AS content_13,
  m2_.in_homepage AS in_homepage_14,
  m2_.active AS active_15,
  m2_.start_date AS start_date_16,
  m2_.end_date AS end_date_17,
  m2_.limit_response_date AS limit_response_date_18,
  m2_.event_date AS event_date_19,
  m2_.creator AS creator_20,
  m2_.last_update_user AS last_update_user_21,
  m2_.creation_date AS creation_date_22,
  m2_.last_update_date AS last_update_date_23,
  m2_.slug AS slug_24,
  m1_.message_id AS message_id_25,
  m1_.user_id AS user_id_26,
  m2_.category_id AS category_id_27
FROM
  message_for_user m1_
  LEFT JOIN message m2_ ON m1_.message_id = m2_.id
  LEFT JOIN category c0_ ON m2_.category_id = c0_.id
WHERE
  m1_.user_id = ?
  AND (m2_.active <> ?)
  AND m1_.display = 1
  AND m2_.type = ?
  AND m2_.in_homepage <> ?
  AND (
    (
      m2_.start_date < ?
      AND m2_.end_date > ?
    )
    OR (
      m2_.start_date < ?
      AND m2_.end_date IS NULL
    )
    OR (
      m2_.start_date IS NULL
      AND m2_.end_date > ?
    )
    OR (
      m2_.start_date IS NULL
      AND m2_.end_date IS NULL
    )
  )
ORDER BY
  m2_.start_date DESC
LIMIT
  4

SELECT c0_.icon AS icon_0, c0_.name AS name_1, m1_.id AS id_2, m1_.new AS new_3, m1_.display AS display_4, m1_.creator AS creator_5, m1_.last_update_user AS last_update_user_6, m1_.creation_date AS creation_date_7, m1_.last_update_date AS last_update_date_8, m2_.id AS id_9, m2_.title AS title_10, m2_.type AS type_11, m2_.description AS description_12, m2_.content AS content_13, m2_.in_homepage AS in_homepage_14, m2_.active AS active_15, m2_.start_date AS start_date_16, m2_.end_date AS end_date_17, m2_.limit_response_date AS limit_response_date_18, m2_.event_date AS event_date_19, m2_.creator AS creator_20, m2_.last_update_user AS last_update_user_21, m2_.creation_date AS creation_date_22, m2_.last_update_date AS last_update_date_23, m2_.slug AS slug_24, m1_.message_id AS message_id_25, m1_.user_id AS user_id_26, m2_.category_id AS category_id_27 FROM message_for_user m1_ LEFT JOIN message m2_ ON m1_.message_id = m2_.id LEFT JOIN category c0_ ON m2_.category_id = c0_.id WHERE m1_.user_id = 24 AND (m2_.active <> 0) AND m1_.display = 1 AND m2_.type = 'Mes actualités' AND m2_.in_homepage <> 0 AND ((m2_.start_date < '2026-03-12 15:31:50' AND m2_.end_date > '2026-03-12 15:31:50') OR (m2_.start_date < '2026-03-12 15:31:50' AND m2_.end_date IS NULL) OR (m2_.start_date IS NULL AND m2_.end_date > '2026-03-12 15:31:50') OR (m2_.start_date IS NULL AND m2_.end_date IS NULL)) ORDER BY m2_.start_date DESC LIMIT 4;

SELECT
  u0_.id AS id_0,
  u0_.order_number AS order_number_1,
  u0_.creator AS creator_2,
  u0_.last_update_user AS last_update_user_3,
  u0_.creation_date AS creation_date_4,
  u0_.last_update_date AS last_update_date_5,
  p1_.route AS route_6,
  p1_.name AS name_7,
  p1_.type AS type_8,
  p1_.id AS id_9,
  p1_.slug AS slug_10,
  p1_.external_link AS external_link_11,
  p1_.label AS label_12,
  u0_.page_id AS page_id_13,
  u0_.user_id AS user_id_14
FROM
  user_page_access u0_
  INNER JOIN page p1_ ON u0_.page_id = p1_.id
  INNER JOIN direct_access d2_ ON p1_.id = d2_.page_id
WHERE
  (
    u0_.user_id = ?
    AND (p1_.active <> ?)
    AND (
      (
        p1_.start_date < ?
        AND p1_.end_date > ?
      )
      OR (
        p1_.start_date < ?
        AND p1_.end_date IS NULL
      )
      OR (
        p1_.start_date IS NULL
        AND p1_.end_date > ?
      )
      OR (
        p1_.start_date IS NULL
        AND p1_.end_date IS NULL
      )
    )
  )
  AND d2_.active = ?
  AND (
    d2_.only_cash_register <> ?
    OR d2_.only_cash_register IS NULL
  )
  AND (
    d2_.visible_if_type IS NULL
    OR d2_.visible_if_type LIKE '[]'
    OR d2_.visible_if_type LIKE ?
  )
  AND (
    d2_.visible_if_contract IS NULL
    OR d2_.visible_if_contract LIKE '[]'
  )
ORDER BY
  u0_.order_number ASC
LIMIT
  12

SELECT u0_.id AS id_0, u0_.order_number AS order_number_1, u0_.creator AS creator_2, u0_.last_update_user AS last_update_user_3, u0_.creation_date AS creation_date_4, u0_.last_update_date AS last_update_date_5, p1_.route AS route_6, p1_.name AS name_7, p1_.type AS type_8, p1_.id AS id_9, p1_.slug AS slug_10, p1_.external_link AS external_link_11, p1_.label AS label_12, u0_.page_id AS page_id_13, u0_.user_id AS user_id_14 FROM user_page_access u0_ INNER JOIN page p1_ ON u0_.page_id = p1_.id INNER JOIN direct_access d2_ ON p1_.id = d2_.page_id WHERE (u0_.user_id = 24 AND (p1_.active <> 0) AND ((p1_.start_date < '2026-03-12 15:31:50' AND p1_.end_date > '2026-03-12 15:31:50') OR (p1_.start_date < '2026-03-12 15:31:50' AND p1_.end_date IS NULL) OR (p1_.start_date IS NULL AND p1_.end_date > '2026-03-12 15:31:50') OR (p1_.start_date IS NULL AND p1_.end_date IS NULL))) AND d2_.active = 1 AND (d2_.only_cash_register <> 1 OR d2_.only_cash_register IS NULL) AND (d2_.visible_if_type IS NULL OR d2_.visible_if_type LIKE '[]' OR d2_.visible_if_type LIKE '%trad%') AND (d2_.visible_if_contract IS NULL OR d2_.visible_if_contract LIKE '[]') ORDER BY u0_.order_number ASC LIMIT 12;

SELECT
  count(m0_.new) AS sclr_0
FROM
  message_for_user m0_
  LEFT JOIN message m1_ ON m0_.message_id = m1_.id
WHERE
  m0_.user_id = ?
  AND (m1_.active <> ?)
  AND m0_.display = 1
  AND m1_.type = ?
  AND m0_.new = ?
  AND (
    (
      m1_.start_date < ?
      AND m1_.end_date > ?
    )
    OR (
      m1_.start_date < ?
      AND m1_.end_date IS NULL
    )
    OR (
      m1_.start_date IS NULL
      AND m1_.end_date > ?
    )
    OR (
      m1_.start_date IS NULL
      AND m1_.end_date IS NULL
    )
  )

SELECT count(m0_.new) AS sclr_0 FROM message_for_user m0_ LEFT JOIN message m1_ ON m0_.message_id = m1_.id WHERE m0_.user_id = 24 AND (m1_.active <> 0) AND m0_.display = 1 AND m1_.type = 'Mes messages' AND m0_.new = 1 AND ((m1_.start_date < '2026-03-12 15:31:50' AND m1_.end_date > '2026-03-12 15:31:50') OR (m1_.start_date < '2026-03-12 15:31:50' AND m1_.end_date IS NULL) OR (m1_.start_date IS NULL AND m1_.end_date > '2026-03-12 15:31:50') OR (m1_.start_date IS NULL AND m1_.end_date IS NULL));

SELECT
  count(m0_.new) AS sclr_0
FROM
  message_for_user m0_
  LEFT JOIN message m1_ ON m0_.message_id = m1_.id
WHERE
  m0_.user_id = ?
  AND (m1_.active <> ?)
  AND m0_.display = 1
  AND m1_.type = ?
  AND m0_.new = ?
  AND (
    (
      m1_.start_date < ?
      AND m1_.end_date > ?
    )
    OR (
      m1_.start_date < ?
      AND m1_.end_date IS NULL
    )
    OR (
      m1_.start_date IS NULL
      AND m1_.end_date > ?
    )
    OR (
      m1_.start_date IS NULL
      AND m1_.end_date IS NULL
    )
  )

SELECT count(m0_.new) AS sclr_0 FROM message_for_user m0_ LEFT JOIN message m1_ ON m0_.message_id = m1_.id WHERE m0_.user_id = 24 AND (m1_.active <> 0) AND m0_.display = 1 AND m1_.type = 'Mes tâches' AND m0_.new = 1 AND ((m1_.start_date < '2026-03-12 15:31:50' AND m1_.end_date > '2026-03-12 15:31:50') OR (m1_.start_date < '2026-03-12 15:31:50' AND m1_.end_date IS NULL) OR (m1_.start_date IS NULL AND m1_.end_date > '2026-03-12 15:31:50') OR (m1_.start_date IS NULL AND m1_.end_date IS NULL));

SELECT
  e0_.date_of_event AS date_of_event_0,
  e0_.description AS description_1,
  e0_.show_in_board AS show_in_board_2,
  e0_.zip_file AS zip_file_3,
  e0_.id AS id_4,
  e0_.creator AS creator_5,
  e0_.creation_date AS creation_date_6,
  e0_.last_update_user AS last_update_user_7,
  e0_.update_date AS update_date_8,
  e0_.title AS title_9,
  e0_.begin_date AS begin_date_10,
  e0_.end_date AS end_date_11,
  e0_.to_publish AS to_publish_12,
  e0_.visible_if_contract AS visible_if_contract_13,
  e0_.visible_if_type AS visible_if_type_14
FROM
  event e0_
WHERE
  e0_.to_publish = 1
  AND e0_.show_in_board = 1
  AND (
    e0_.begin_date <= ?
    OR e0_.begin_date IS NULL
  )
  AND (
    e0_.end_date >= ?
    OR e0_.end_date IS NULL
  )
ORDER BY
  e0_.begin_date DESC
LIMIT
  4

SELECT e0_.date_of_event AS date_of_event_0, e0_.description AS description_1, e0_.show_in_board AS show_in_board_2, e0_.zip_file AS zip_file_3, e0_.id AS id_4, e0_.creator AS creator_5, e0_.creation_date AS creation_date_6, e0_.last_update_user AS last_update_user_7, e0_.update_date AS update_date_8, e0_.title AS title_9, e0_.begin_date AS begin_date_10, e0_.end_date AS end_date_11, e0_.to_publish AS to_publish_12, e0_.visible_if_contract AS visible_if_contract_13, e0_.visible_if_type AS visible_if_type_14 FROM event e0_ WHERE e0_.to_publish = 1 AND e0_.show_in_board = 1 AND (e0_.begin_date <= '2026-03-12 15:31:50' OR e0_.begin_date IS NULL) AND (e0_.end_date >= '2026-03-12 15:31:50' OR e0_.end_date IS NULL) ORDER BY e0_.begin_date DESC LIMIT 4;

SELECT
  c0_.icon AS icon_0,
  p1_.id AS id_1,
  p1_.name AS name_2,
  p1_.label AS label_3,
  p1_.route AS route_4,
  p1_.linked_autoco_service AS linked_autoco_service_5,
  p1_.linked_service AS linked_service_6,
  p1_.linked_contact AS linked_contact_7,
  p1_.type AS type_8,
  p1_.real_page AS real_page_9,
  p1_.active AS active_10,
  p1_.start_date AS start_date_11,
  p1_.end_date AS end_date_12,
  p1_.creator AS creator_13,
  p1_.last_update_user AS last_update_user_14,
  p1_.creation_date AS creation_date_15,
  p1_.last_update_date AS last_update_date_16,
  p1_.menu_position AS menu_position_17,
  p1_.main_page AS main_page_18,
  p1_.admin_page AS admin_page_19,
  p1_.external_link AS external_link_20,
  p1_.slug AS slug_21,
  p1_.visible_if_contract AS visible_if_contract_22,
  p1_.visible_if_type AS visible_if_type_23,
  p1_.is_showcase AS is_showcase_24,
  p1_.image AS image_25,
  p1_.meta_title AS meta_title_26,
  p1_.meta_description AS meta_description_27,
  p1_.not_in_cash_register AS not_in_cash_register_28,
  p2_.id AS id_29,
  p2_.creator AS creator_30,
  p2_.last_update_user AS last_update_user_31,
  p2_.creation_date AS creation_date_32,
  p2_.last_update_date AS last_update_date_33,
  p3_.id AS id_34,
  p3_.name AS name_35,
  p3_.label AS label_36,
  p3_.route AS route_37,
  p3_.linked_autoco_service AS linked_autoco_service_38,
  p3_.linked_service AS linked_service_39,
  p3_.linked_contact AS linked_contact_40,
  p3_.type AS type_41,
  p3_.real_page AS real_page_42,
  p3_.active AS active_43,
  p3_.start_date AS start_date_44,
  p3_.end_date AS end_date_45,
  p3_.creator AS creator_46,
  p3_.last_update_user AS last_update_user_47,
  p3_.creation_date AS creation_date_48,
  p3_.last_update_date AS last_update_date_49,
  p3_.menu_position AS menu_position_50,
  p3_.main_page AS main_page_51,
  p3_.admin_page AS admin_page_52,
  p3_.external_link AS external_link_53,
  p3_.slug AS slug_54,
  p3_.visible_if_contract AS visible_if_contract_55,
  p3_.visible_if_type AS visible_if_type_56,
  p3_.is_showcase AS is_showcase_57,
  p3_.image AS image_58,
  p3_.meta_title AS meta_title_59,
  p3_.meta_description AS meta_description_60,
  p3_.not_in_cash_register AS not_in_cash_register_61,
  p4_.id AS id_62,
  p4_.creator AS creator_63,
  p4_.last_update_user AS last_update_user_64,
  p4_.creation_date AS creation_date_65,
  p4_.last_update_date AS last_update_date_66,
  p5_.id AS id_67,
  p5_.name AS name_68,
  p5_.label AS label_69,
  p5_.route AS route_70,
  p5_.linked_autoco_service AS linked_autoco_service_71,
  p5_.linked_service AS linked_service_72,
  p5_.linked_contact AS linked_contact_73,
  p5_.type AS type_74,
  p5_.real_page AS real_page_75,
  p5_.active AS active_76,
  p5_.start_date AS start_date_77,
  p5_.end_date AS end_date_78,
  p5_.creator AS creator_79,
  p5_.last_update_user AS last_update_user_80,
  p5_.creation_date AS creation_date_81,
  p5_.last_update_date AS last_update_date_82,
  p5_.menu_position AS menu_position_83,
  p5_.main_page AS main_page_84,
  p5_.admin_page AS admin_page_85,
  p5_.external_link AS external_link_86,
  p5_.slug AS slug_87,
  p5_.visible_if_contract AS visible_if_contract_88,
  p5_.visible_if_type AS visible_if_type_89,
  p5_.is_showcase AS is_showcase_90,
  p5_.image AS image_91,
  p5_.meta_title AS meta_title_92,
  p5_.meta_description AS meta_description_93,
  p5_.not_in_cash_register AS not_in_cash_register_94,
  p1_.category_id AS category_id_95,
  p1_.image_gallery_id AS image_gallery_id_96,
  p2_.page_parent_id AS page_parent_id_97,
  p2_.page_child_id AS page_child_id_98,
  p3_.category_id AS category_id_99,
  p3_.image_gallery_id AS image_gallery_id_100,
  p4_.page_parent_id AS page_parent_id_101,
  p4_.page_child_id AS page_child_id_102,
  p5_.category_id AS category_id_103,
  p5_.image_gallery_id AS image_gallery_id_104
FROM
  page p1_
  LEFT JOIN category c0_ ON p1_.category_id = c0_.id
  LEFT JOIN page_in_page p2_ ON p1_.id = p2_.page_parent_id
  LEFT JOIN page p3_ ON p2_.page_child_id = p3_.id
  LEFT JOIN page_in_page p4_ ON p3_.id = p4_.page_parent_id
  LEFT JOIN page p5_ ON p4_.page_child_id = p5_.id
WHERE
  p1_.active <> ?
  AND p1_.main_page = ?
  AND (
    p1_.visible_if_type IS NULL
    OR p1_.visible_if_type = '[]'
    OR p1_.visible_if_type LIKE ?
    OR p1_.visible_if_type LIKE '%[]%'
  )
  AND (
    (
      p1_.start_date < ?
      AND p1_.end_date > ?
    )
    OR (
      p1_.start_date < ?
      AND p1_.end_date IS NULL
    )
    OR (
      p1_.start_date IS NULL
      AND p1_.end_date > ?
    )
    OR (
      p1_.start_date IS NULL
      AND p1_.end_date IS NULL
    )
  )
  AND p1_.is_showcase = 0
ORDER BY
  p1_.menu_position ASC,
  p3_.menu_position ASC,
  p5_.menu_position ASC

SELECT c0_.icon AS icon_0, p1_.id AS id_1, p1_.name AS name_2, p1_.label AS label_3, p1_.route AS route_4, p1_.linked_autoco_service AS linked_autoco_service_5, p1_.linked_service AS linked_service_6, p1_.linked_contact AS linked_contact_7, p1_.type AS type_8, p1_.real_page AS real_page_9, p1_.active AS active_10, p1_.start_date AS start_date_11, p1_.end_date AS end_date_12, p1_.creator AS creator_13, p1_.last_update_user AS last_update_user_14, p1_.creation_date AS creation_date_15, p1_.last_update_date AS last_update_date_16, p1_.menu_position AS menu_position_17, p1_.main_page AS main_page_18, p1_.admin_page AS admin_page_19, p1_.external_link AS external_link_20, p1_.slug AS slug_21, p1_.visible_if_contract AS visible_if_contract_22, p1_.visible_if_type AS visible_if_type_23, p1_.is_showcase AS is_showcase_24, p1_.image AS image_25, p1_.meta_title AS meta_title_26, p1_.meta_description AS meta_description_27, p1_.not_in_cash_register AS not_in_cash_register_28, p2_.id AS id_29, p2_.creator AS creator_30, p2_.last_update_user AS last_update_user_31, p2_.creation_date AS creation_date_32, p2_.last_update_date AS last_update_date_33, p3_.id AS id_34, p3_.name AS name_35, p3_.label AS label_36, p3_.route AS route_37, p3_.linked_autoco_service AS linked_autoco_service_38, p3_.linked_service AS linked_service_39, p3_.linked_contact AS linked_contact_40, p3_.type AS type_41, p3_.real_page AS real_page_42, p3_.active AS active_43, p3_.start_date AS start_date_44, p3_.end_date AS end_date_45, p3_.creator AS creator_46, p3_.last_update_user AS last_update_user_47, p3_.creation_date AS creation_date_48, p3_.last_update_date AS last_update_date_49, p3_.menu_position AS menu_position_50, p3_.main_page AS main_page_51, p3_.admin_page AS admin_page_52, p3_.external_link AS external_link_53, p3_.slug AS slug_54, p3_.visible_if_contract AS visible_if_contract_55, p3_.visible_if_type AS visible_if_type_56, p3_.is_showcase AS is_showcase_57, p3_.image AS image_58, p3_.meta_title AS meta_title_59, p3_.meta_description AS meta_description_60, p3_.not_in_cash_register AS not_in_cash_register_61, p4_.id AS id_62, p4_.creator AS creator_63, p4_.last_update_user AS last_update_user_64, p4_.creation_date AS creation_date_65, p4_.last_update_date AS last_update_date_66, p5_.id AS id_67, p5_.name AS name_68, p5_.label AS label_69, p5_.route AS route_70, p5_.linked_autoco_service AS linked_autoco_service_71, p5_.linked_service AS linked_service_72, p5_.linked_contact AS linked_contact_73, p5_.type AS type_74, p5_.real_page AS real_page_75, p5_.active AS active_76, p5_.start_date AS start_date_77, p5_.end_date AS end_date_78, p5_.creator AS creator_79, p5_.last_update_user AS last_update_user_80, p5_.creation_date AS creation_date_81, p5_.last_update_date AS last_update_date_82, p5_.menu_position AS menu_position_83, p5_.main_page AS main_page_84, p5_.admin_page AS admin_page_85, p5_.external_link AS external_link_86, p5_.slug AS slug_87, p5_.visible_if_contract AS visible_if_contract_88, p5_.visible_if_type AS visible_if_type_89, p5_.is_showcase AS is_showcase_90, p5_.image AS image_91, p5_.meta_title AS meta_title_92, p5_.meta_description AS meta_description_93, p5_.not_in_cash_register AS not_in_cash_register_94, p1_.category_id AS category_id_95, p1_.image_gallery_id AS image_gallery_id_96, p2_.page_parent_id AS page_parent_id_97, p2_.page_child_id AS page_child_id_98, p3_.category_id AS category_id_99, p3_.image_gallery_id AS image_gallery_id_100, p4_.page_parent_id AS page_parent_id_101, p4_.page_child_id AS page_child_id_102, p5_.category_id AS category_id_103, p5_.image_gallery_id AS image_gallery_id_104 FROM page p1_ LEFT JOIN category c0_ ON p1_.category_id = c0_.id LEFT JOIN page_in_page p2_ ON p1_.id = p2_.page_parent_id LEFT JOIN page p3_ ON p2_.page_child_id = p3_.id LEFT JOIN page_in_page p4_ ON p3_.id = p4_.page_parent_id LEFT JOIN page p5_ ON p4_.page_child_id = p5_.id WHERE p1_.active <> 0 AND p1_.main_page = 1 AND (p1_.visible_if_type IS NULL OR p1_.visible_if_type = '[]' OR p1_.visible_if_type LIKE '%\"trad\"%' OR p1_.visible_if_type LIKE '%[]%') AND ((p1_.start_date < '2026-03-12 15:31:50' AND p1_.end_date > '2026-03-12 15:31:50') OR (p1_.start_date < '2026-03-12 15:31:50' AND p1_.end_date IS NULL) OR (p1_.start_date IS NULL AND p1_.end_date > '2026-03-12 15:31:50') OR (p1_.start_date IS NULL AND p1_.end_date IS NULL)) AND p1_.is_showcase = 0 ORDER BY p1_.menu_position ASC, p3_.menu_position ASC, p5_.menu_position ASC;