Symfony Profiler

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

Query Metrics

SELECT o0_.slot AS slot_0, p1_.id AS id_1, SUM(o2_.qty) AS sclr_2 FROM order_line o2_ INNER JOIN `order` o0_ ON o2_.order_ref_id = o0_.id LEFT JOIN `order` o3_ ON (o3_.cancel_origin_id = o0_.id AND o3_.status = ?) LEFT JOIN product p4_ ON (p4_.id = o2_.product_id) LEFT JOIN product_category p1_ ON p4_.category_id = p1_.id WHERE o0_.service_date = ? AND o0_.service = ? AND o0_.status <> ? AND o3_.id IS NULL GROUP BY o0_.slot, p1_.id

[
  "cancelled"
  "2026-03-11 00:00:00"
  "soir"
  "cancelled"
]

SELECT
  o0_.slot AS slot_0,
  p1_.id AS id_1,
  SUM(o2_.qty) AS sclr_2
FROM
  order_line o2_
  INNER JOIN `order` o0_ ON o2_.order_ref_id = o0_.id
  LEFT JOIN `order` o3_ ON (
    o3_.cancel_origin_id = o0_.id
    AND o3_.status = ?
  )
  LEFT JOIN product p4_ ON (p4_.id = o2_.product_id)
  LEFT JOIN product_category p1_ ON p4_.category_id = p1_.id
WHERE
  o0_.service_date = ?
  AND o0_.service = ?
  AND o0_.status <> ?
  AND o3_.id IS NULL
GROUP BY
  o0_.slot,
  p1_.id

SELECT o0_.slot AS slot_0, p1_.id AS id_1, SUM(o2_.qty) AS sclr_2 FROM order_line o2_ INNER JOIN `order` o0_ ON o2_.order_ref_id = o0_.id LEFT JOIN `order` o3_ ON (o3_.cancel_origin_id = o0_.id AND o3_.status = 'cancelled') LEFT JOIN product p4_ ON (p4_.id = o2_.product_id) LEFT JOIN product_category p1_ ON p4_.category_id = p1_.id WHERE o0_.service_date = '2026-03-11 00:00:00' AND o0_.service = 'soir' AND o0_.status <> 'cancelled' AND o3_.id IS NULL GROUP BY o0_.slot, p1_.id;

SELECT o0_.slot AS slot_0, o1_.product_id AS product_id_1, SUM(o1_.qty) AS sclr_2 FROM order_line o1_ INNER JOIN `order` o0_ ON o1_.order_ref_id = o0_.id LEFT JOIN `order` o2_ ON (o2_.cancel_origin_id = o0_.id AND o2_.status = ?) WHERE o0_.service_date = ? AND o0_.service = ? AND o0_.status <> ? AND o2_.id IS NULL GROUP BY o0_.slot, o1_.product_id

[
  "cancelled"
  "2026-03-11 00:00:00"
  "soir"
  "cancelled"
]

SELECT
  o0_.slot AS slot_0,
  o1_.product_id AS product_id_1,
  SUM(o1_.qty) AS sclr_2
FROM
  order_line o1_
  INNER JOIN `order` o0_ ON o1_.order_ref_id = o0_.id
  LEFT JOIN `order` o2_ ON (
    o2_.cancel_origin_id = o0_.id
    AND o2_.status = ?
  )
WHERE
  o0_.service_date = ?
  AND o0_.service = ?
  AND o0_.status <> ?
  AND o2_.id IS NULL
GROUP BY
  o0_.slot,
  o1_.product_id

SELECT o0_.slot AS slot_0, o1_.product_id AS product_id_1, SUM(o1_.qty) AS sclr_2 FROM order_line o1_ INNER JOIN `order` o0_ ON o1_.order_ref_id = o0_.id LEFT JOIN `order` o2_ ON (o2_.cancel_origin_id = o0_.id AND o2_.status = 'cancelled') WHERE o0_.service_date = '2026-03-11 00:00:00' AND o0_.service = 'soir' AND o0_.status <> 'cancelled' AND o2_.id IS NULL GROUP BY o0_.slot, o1_.product_id;

SELECT
  o.slot                      AS slot_raw,
  pi.ingredient_id            AS ingredient_id,
  SUM(l.qty * pi.qty)         AS qty_used
FROM order_line l
JOIN `order` o              ON o.id = l.order_ref_id
LEFT JOIN `order` c         ON c.cancel_origin_id = o.id AND c.status = 'cancelled'
JOIN product p              ON p.id = l.product_id
JOIN product_ingredient pi  ON pi.product_id = p.id
WHERE o.service_date = ?
  AND o.service = ?
  AND o.status <> 'cancelled'
  AND c.id IS NULL
GROUP BY slot_raw, ingredient_id

[
  "2026-03-11"
  "soir"
]

SELECT
  o.slot AS slot_raw,
  pi.ingredient_id AS ingredient_id,
  SUM(l.qty * pi.qty) AS qty_used
FROM
  order_line l
  JOIN `order` o ON o.id = l.order_ref_id
  LEFT JOIN `order` c ON c.cancel_origin_id = o.id
  AND c.status = 'cancelled'
  JOIN product p ON p.id = l.product_id
  JOIN product_ingredient pi ON pi.product_id = p.id
WHERE
  o.service_date = ?
  AND o.service = ?
  AND o.status <> 'cancelled'
  AND c.id IS NULL
GROUP BY
  slot_raw,
  ingredient_id

SELECT
  o.slot                      AS slot_raw,
  pi.ingredient_id            AS ingredient_id,
  SUM(l.qty * pi.qty)         AS qty_used
FROM order_line l
JOIN `order` o              ON o.id = l.order_ref_id
LEFT JOIN `order` c         ON c.cancel_origin_id = o.id AND c.status = 'cancelled'
JOIN product p              ON p.id = l.product_id
JOIN product_ingredient pi  ON pi.product_id = p.id
WHERE o.service_date = '2026-03-11'
  AND o.service = 'soir'
  AND o.status <> 'cancelled'
  AND c.id IS NULL
GROUP BY slot_raw, ingredient_id;

SELECT o0_.slot AS slot_0, COUNT(o0_.id) AS sclr_1, SUM(CASE WHEN o1_.packing_done = 1 THEN 1 ELSE 0 END) AS sclr_2 FROM `order` o0_ LEFT JOIN order_flow_state o1_ ON (o1_.order_ref_id = o0_.id) LEFT JOIN `order` o2_ ON (o2_.cancel_origin_id = o0_.id AND o2_.status = ?) WHERE o0_.service_date = ? AND o0_.service = ? AND o0_.status <> ? AND o2_.id IS NULL AND o0_.slot IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY o0_.slot

[
  "cancelled"
  "2026-03-11 00:00:00"
  "soir"
  "cancelled"
  "18:30"
  "19:00"
  "19:10"
  "19:20"
  "19:30"
  "19:40"
  "19:50"
  "20:00"
  "18:50"
  "20:10"
  "20:20"
  "20:30"
  "20:40"
  "20:50"
  "21:00"
  "21:10"
]

SELECT
  o0_.slot AS slot_0,
  COUNT(o0_.id) AS sclr_1,
  SUM(
    CASE WHEN o1_.packing_done = 1 THEN
      1
    ELSE
      0
    END
  ) AS sclr_2
FROM
  `order` o0_
  LEFT JOIN order_flow_state o1_ ON (o1_.order_ref_id = o0_.id)
  LEFT JOIN `order` o2_ ON (
    o2_.cancel_origin_id = o0_.id
    AND o2_.status = ?
  )
WHERE
  o0_.service_date = ?
  AND o0_.service = ?
  AND o0_.status <> ?
  AND o2_.id IS NULL
  AND o0_.slot IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
GROUP BY
  o0_.slot

SELECT o0_.slot AS slot_0, COUNT(o0_.id) AS sclr_1, SUM(CASE WHEN o1_.packing_done = 1 THEN 1 ELSE 0 END) AS sclr_2 FROM `order` o0_ LEFT JOIN order_flow_state o1_ ON (o1_.order_ref_id = o0_.id) LEFT JOIN `order` o2_ ON (o2_.cancel_origin_id = o0_.id AND o2_.status = 'cancelled') WHERE o0_.service_date = '2026-03-11 00:00:00' AND o0_.service = 'soir' AND o0_.status <> 'cancelled' AND o2_.id IS NULL AND o0_.slot IN ('18:30', '19:00', '19:10', '19:20', '19:30', '19:40', '19:50', '20:00', '18:50', '20:10', '20:20', '20:30', '20:40', '20:50', '21:00', '21:10') GROUP BY o0_.slot;

SELECT t0.id AS id_1, t0.day AS day_2, t0.service AS service_3, t0.slots AS slots_4, t0.enabled AS enabled_5, t0.uber_enabled AS uber_enabled_6 FROM opening_day t0 WHERE t0.day = ? AND t0.service = ? AND t0.enabled = ? LIMIT 1

[
  "mercredi"
  "soir"
  1
]

SELECT
  t0.id AS id_1,
  t0.day AS day_2,
  t0.service AS service_3,
  t0.slots AS slots_4,
  t0.enabled AS enabled_5,
  t0.uber_enabled AS uber_enabled_6
FROM
  opening_day t0
WHERE
  t0.day = ?
  AND t0.service = ?
  AND t0.enabled = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.day AS day_2, t0.service AS service_3, t0.slots AS slots_4, t0.enabled AS enabled_5, t0.uber_enabled AS uber_enabled_6 FROM opening_day t0 WHERE t0.day = 'mercredi' AND t0.service = 'soir' AND t0.enabled = 1 LIMIT 1;

SELECT o0_.id AS id_0, o0_.qty AS qty_1, o0_.options AS options_2, o1_.slot AS slot_3 FROM order_line o0_ INNER JOIN `order` o1_ ON o0_.order_ref_id = o1_.id LEFT JOIN `order` o2_ ON (o2_.cancel_origin_id = o1_.id AND o2_.status = ?) WHERE o1_.service_date = ? AND o1_.service = ? AND o1_.status <> ? AND o2_.id IS NULL

[
  "cancelled"
  "2026-03-11 00:00:00"
  "soir"
  "cancelled"
]

SELECT
  o0_.id AS id_0,
  o0_.qty AS qty_1,
  o0_.options AS options_2,
  o1_.slot AS slot_3
FROM
  order_line o0_
  INNER JOIN `order` o1_ ON o0_.order_ref_id = o1_.id
  LEFT JOIN `order` o2_ ON (
    o2_.cancel_origin_id = o1_.id
    AND o2_.status = ?
  )
WHERE
  o1_.service_date = ?
  AND o1_.service = ?
  AND o1_.status <> ?
  AND o2_.id IS NULL

SELECT o0_.id AS id_0, o0_.qty AS qty_1, o0_.options AS options_2, o1_.slot AS slot_3 FROM order_line o0_ INNER JOIN `order` o1_ ON o0_.order_ref_id = o1_.id LEFT JOIN `order` o2_ ON (o2_.cancel_origin_id = o1_.id AND o2_.status = 'cancelled') WHERE o1_.service_date = '2026-03-11 00:00:00' AND o1_.service = 'soir' AND o1_.status <> 'cancelled' AND o2_.id IS NULL;

SELECT o0_.slot AS slot_0, COUNT(o0_.id) AS sclr_1 FROM `order` o0_ WHERE o0_.service_date = ? AND o0_.service = ? AND o0_.status <> ? GROUP BY o0_.slot

[
  "2026-03-11"
  "soir"
  "cancelled"
]

SELECT
  o0_.slot AS slot_0,
  COUNT(o0_.id) AS sclr_1
FROM
  `order` o0_
WHERE
  o0_.service_date = ?
  AND o0_.service = ?
  AND o0_.status <> ?
GROUP BY
  o0_.slot

SELECT o0_.slot AS slot_0, COUNT(o0_.id) AS sclr_1 FROM `order` o0_ WHERE o0_.service_date = '2026-03-11' AND o0_.service = 'soir' AND o0_.status <> 'cancelled' GROUP BY o0_.slot;

SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.roles AS roles_4, t0.password AS password_5 FROM user t0 WHERE t0.id = ?

[
  14
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.username AS username_3,
  t0.roles AS roles_4,
  t0.password AS password_5
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.roles AS roles_4, t0.password AS password_5 FROM user t0 WHERE t0.id = 14;

SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3, t0.type AS type_4, t0.max_midi AS max_midi_5, t0.max_soir AS max_soir_6, t0.product_id AS product_id_7, t0.product_category_id AS product_category_id_8 FROM slot_limit_rule t0 WHERE t0.enabled = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.enabled AS enabled_3,
  t0.type AS type_4,
  t0.max_midi AS max_midi_5,
  t0.max_soir AS max_soir_6,
  t0.product_id AS product_id_7,
  t0.product_category_id AS product_category_id_8
FROM
  slot_limit_rule t0
WHERE
  t0.enabled = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3, t0.type AS type_4, t0.max_midi AS max_midi_5, t0.max_soir AS max_soir_6, t0.product_id AS product_id_7, t0.product_category_id AS product_category_id_8 FROM slot_limit_rule t0 WHERE t0.enabled = 1;