Symfony Profiler

SELECT
  t0.name AS name_1,
  t0.label AS label_2,
  t0.section AS section_3,
  t0.advanced AS advanced_4,
  t0.active AS active_5,
  t0.only_shop AS only_shop_6,
  t0.only_cash_register AS only_cash_register_7,
  t0.to_initialize AS to_initialize_8,
  t0.id AS id_9,
  t0.creator AS creator_10,
  t0.creation_date AS creation_date_11,
  t0.last_update_user AS last_update_user_12,
  t0.update_date AS update_date_13,
  t0.visible_if_contract AS visible_if_contract_14,
  t0.visible_if_type AS visible_if_type_15,
  t0.page_id AS page_id_16
FROM
  direct_access t0
WHERE
  t0.page_id = ?

SELECT t0.name AS name_1, t0.label AS label_2, t0.section AS section_3, t0.advanced AS advanced_4, t0.active AS active_5, t0.only_shop AS only_shop_6, t0.only_cash_register AS only_cash_register_7, t0.to_initialize AS to_initialize_8, t0.id AS id_9, t0.creator AS creator_10, t0.creation_date AS creation_date_11, t0.last_update_user AS last_update_user_12, t0.update_date AS update_date_13, t0.visible_if_contract AS visible_if_contract_14, t0.visible_if_type AS visible_if_type_15, t0.page_id AS page_id_16 FROM direct_access t0 WHERE t0.page_id = 26;

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 '%\"MDP\"%' OR p1_.visible_if_type LIKE '%[]%') AND ((p1_.start_date < '2026-03-13 10:43:03' AND p1_.end_date > '2026-03-13 10:43:03') OR (p1_.start_date < '2026-03-13 10:43:03' AND p1_.end_date IS NULL) OR (p1_.start_date IS NULL AND p1_.end_date > '2026-03-13 10:43:03') 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
  t0.id AS id_1,
  t0.creator AS creator_2,
  t0.last_update_user AS last_update_user_3,
  t0.creation_date AS creation_date_4,
  t0.last_update_date AS last_update_date_5,
  t0.page_parent_id AS page_parent_id_6,
  t0.page_child_id AS page_child_id_7
FROM
  page_in_page t0
WHERE
  t0.page_child_id = ?

SELECT t0.id AS id_1, t0.creator AS creator_2, t0.last_update_user AS last_update_user_3, t0.creation_date AS creation_date_4, t0.last_update_date AS last_update_date_5, t0.page_parent_id AS page_parent_id_6, t0.page_child_id AS page_child_id_7 FROM page_in_page t0 WHERE t0.page_child_id = 26;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.label AS label_2,
  p0_.route AS route_3,
  p0_.linked_autoco_service AS linked_autoco_service_4,
  p0_.linked_service AS linked_service_5,
  p0_.linked_contact AS linked_contact_6,
  p0_.type AS type_7,
  p0_.real_page AS real_page_8,
  p0_.active AS active_9,
  p0_.start_date AS start_date_10,
  p0_.end_date AS end_date_11,
  p0_.creator AS creator_12,
  p0_.last_update_user AS last_update_user_13,
  p0_.creation_date AS creation_date_14,
  p0_.last_update_date AS last_update_date_15,
  p0_.menu_position AS menu_position_16,
  p0_.main_page AS main_page_17,
  p0_.admin_page AS admin_page_18,
  p0_.external_link AS external_link_19,
  p0_.slug AS slug_20,
  p0_.visible_if_contract AS visible_if_contract_21,
  p0_.visible_if_type AS visible_if_type_22,
  p0_.is_showcase AS is_showcase_23,
  p0_.image AS image_24,
  p0_.meta_title AS meta_title_25,
  p0_.meta_description AS meta_description_26,
  p0_.not_in_cash_register AS not_in_cash_register_27,
  p0_.category_id AS category_id_28,
  p0_.image_gallery_id AS image_gallery_id_29
FROM
  page p0_
WHERE
  p0_.slug = ?
  AND p0_.active <> ?
  AND (
    (
      p0_.start_date < ?
      AND p0_.end_date > ?
    )
    OR (
      p0_.start_date < ?
      AND p0_.end_date IS NULL
    )
    OR (
      p0_.start_date IS NULL
      AND p0_.end_date > ?
    )
    OR (
      p0_.start_date IS NULL
      AND p0_.end_date IS NULL
    )
  )

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.label AS label_2, p0_.route AS route_3, p0_.linked_autoco_service AS linked_autoco_service_4, p0_.linked_service AS linked_service_5, p0_.linked_contact AS linked_contact_6, p0_.type AS type_7, p0_.real_page AS real_page_8, p0_.active AS active_9, p0_.start_date AS start_date_10, p0_.end_date AS end_date_11, p0_.creator AS creator_12, p0_.last_update_user AS last_update_user_13, p0_.creation_date AS creation_date_14, p0_.last_update_date AS last_update_date_15, p0_.menu_position AS menu_position_16, p0_.main_page AS main_page_17, p0_.admin_page AS admin_page_18, p0_.external_link AS external_link_19, p0_.slug AS slug_20, p0_.visible_if_contract AS visible_if_contract_21, p0_.visible_if_type AS visible_if_type_22, p0_.is_showcase AS is_showcase_23, p0_.image AS image_24, p0_.meta_title AS meta_title_25, p0_.meta_description AS meta_description_26, p0_.not_in_cash_register AS not_in_cash_register_27, p0_.category_id AS category_id_28, p0_.image_gallery_id AS image_gallery_id_29 FROM page p0_ WHERE p0_.slug = 'mes-factures' AND p0_.active <> 0 AND ((p0_.start_date < '2026-03-13 10:43:03' AND p0_.end_date > '2026-03-13 10:43:03') OR (p0_.start_date < '2026-03-13 10:43:03' AND p0_.end_date IS NULL) OR (p0_.start_date IS NULL AND p0_.end_date > '2026-03-13 10:43:03') OR (p0_.start_date IS NULL AND p0_.end_date IS NULL));

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