Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 15
• Events
• Routing
• Cache
• Translation 4
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT o0_.id AS id_0, o0_.label AS label_1, o0_.slug AS slug_2, o0_.start_date AS start_date_3, o0_.end_date AS end_date_4, o0_.codepromo AS codepromo_5, o0_.display_menu AS display_menu_6, o0_.display_home AS display_home_7, o0_.display_product_menu AS display_product_menu_8, o0_.restrictionCategorie AS restrictionCategorie_9, o0_.view_by AS view_by_10, o0_.home_emplacament AS home_emplacament_11, o0_.restrictionGroupe AS restrictionGroupe_12, o0_.restrictionMarche AS restrictionMarche_13, o0_.external_link AS external_link_14, o0_.home_order AS home_order_15, o0_.is_active AS is_active_16, o0_.image_path AS image_path_17, o0_.operation_parent_id AS operation_parent_id_18, o0_.operation_type_id AS operation_type_id_19 FROM operations o0_ WHERE o0_.start_date < ? AND o0_.end_date > ? AND o0_.is_active = 1 AND o0_.view_by = ? ORDER BY o0_.home_order DESC, o0_.start_date ASC, o0_.end_date DESC

[
  "2024-12-15 03:05:20"
  "2024-12-15 03:05:20"
  2
]

SELECT
  o0_.id AS id_0,
  o0_.label AS label_1,
  o0_.slug AS slug_2,
  o0_.start_date AS start_date_3,
  o0_.end_date AS end_date_4,
  o0_.codepromo AS codepromo_5,
  o0_.display_menu AS display_menu_6,
  o0_.display_home AS display_home_7,
  o0_.display_product_menu AS display_product_menu_8,
  o0_.restrictionCategorie AS restrictionCategorie_9,
  o0_.view_by AS view_by_10,
  o0_.home_emplacament AS home_emplacament_11,
  o0_.restrictionGroupe AS restrictionGroupe_12,
  o0_.restrictionMarche AS restrictionMarche_13,
  o0_.external_link AS external_link_14,
  o0_.home_order AS home_order_15,
  o0_.is_active AS is_active_16,
  o0_.image_path AS image_path_17,
  o0_.operation_parent_id AS operation_parent_id_18,
  o0_.operation_type_id AS operation_type_id_19
FROM
  operations o0_
WHERE
  o0_.start_date < ?
  AND o0_.end_date > ?
  AND o0_.is_active = 1
  AND o0_.view_by = ?
ORDER BY
  o0_.home_order DESC,
  o0_.start_date ASC,
  o0_.end_date DESC

SELECT o0_.id AS id_0, o0_.label AS label_1, o0_.slug AS slug_2, o0_.start_date AS start_date_3, o0_.end_date AS end_date_4, o0_.codepromo AS codepromo_5, o0_.display_menu AS display_menu_6, o0_.display_home AS display_home_7, o0_.display_product_menu AS display_product_menu_8, o0_.restrictionCategorie AS restrictionCategorie_9, o0_.view_by AS view_by_10, o0_.home_emplacament AS home_emplacament_11, o0_.restrictionGroupe AS restrictionGroupe_12, o0_.restrictionMarche AS restrictionMarche_13, o0_.external_link AS external_link_14, o0_.home_order AS home_order_15, o0_.is_active AS is_active_16, o0_.image_path AS image_path_17, o0_.operation_parent_id AS operation_parent_id_18, o0_.operation_type_id AS operation_type_id_19 FROM operations o0_ WHERE o0_.start_date < '2024-12-15 03:05:20' AND o0_.end_date > '2024-12-15 03:05:20' AND o0_.is_active = 1 AND o0_.view_by = 2 ORDER BY o0_.home_order DESC, o0_.start_date ASC, o0_.end_date DESC;

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.displayed_order AS displayed_order_2, c0_.is_in_footer AS is_in_footer_3, c0_.slug AS slug_4, c1_.id AS id_5, c1_.name AS name_6, c1_.displayed_order AS displayed_order_7, c1_.is_in_footer AS is_in_footer_8, c1_.slug AS slug_9, c2_.id AS id_10, c2_.name AS name_11, c2_.displayed_order AS displayed_order_12, c2_.is_in_footer AS is_in_footer_13, c2_.slug AS slug_14, c0_.category_parent_id AS category_parent_id_15, c1_.category_parent_id AS category_parent_id_16, c2_.category_parent_id AS category_parent_id_17 FROM category c0_ LEFT JOIN category c1_ ON c0_.id = c1_.category_parent_id LEFT JOIN category c2_ ON c1_.id = c2_.category_parent_id WHERE c0_.category_parent_id IS NULL

[]

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.displayed_order AS displayed_order_2,
  c0_.is_in_footer AS is_in_footer_3,
  c0_.slug AS slug_4,
  c1_.id AS id_5,
  c1_.name AS name_6,
  c1_.displayed_order AS displayed_order_7,
  c1_.is_in_footer AS is_in_footer_8,
  c1_.slug AS slug_9,
  c2_.id AS id_10,
  c2_.name AS name_11,
  c2_.displayed_order AS displayed_order_12,
  c2_.is_in_footer AS is_in_footer_13,
  c2_.slug AS slug_14,
  c0_.category_parent_id AS category_parent_id_15,
  c1_.category_parent_id AS category_parent_id_16,
  c2_.category_parent_id AS category_parent_id_17
FROM
  category c0_
  LEFT JOIN category c1_ ON c0_.id = c1_.category_parent_id
  LEFT JOIN category c2_ ON c1_.id = c2_.category_parent_id
WHERE
  c0_.category_parent_id IS NULL

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.displayed_order AS displayed_order_2, c0_.is_in_footer AS is_in_footer_3, c0_.slug AS slug_4, c1_.id AS id_5, c1_.name AS name_6, c1_.displayed_order AS displayed_order_7, c1_.is_in_footer AS is_in_footer_8, c1_.slug AS slug_9, c2_.id AS id_10, c2_.name AS name_11, c2_.displayed_order AS displayed_order_12, c2_.is_in_footer AS is_in_footer_13, c2_.slug AS slug_14, c0_.category_parent_id AS category_parent_id_15, c1_.category_parent_id AS category_parent_id_16, c2_.category_parent_id AS category_parent_id_17 FROM category c0_ LEFT JOIN category c1_ ON c0_.id = c1_.category_parent_id LEFT JOIN category c2_ ON c1_.id = c2_.category_parent_id WHERE c0_.category_parent_id IS NULL;

SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.is_in_footer = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.displayed_order AS displayed_order_3,
  t0.is_in_footer AS is_in_footer_4,
  t0.slug AS slug_5,
  t0.category_parent_id AS category_parent_id_6
FROM
  category t0
WHERE
  t0.is_in_footer = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.is_in_footer = 1;