Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 9
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine
• Debug
• Emails
• Serializer
• VichUploader
• EasyAdmin
• Elastica
• Configuration

Query Metrics

SELECT COUNT(1) as Q FROM distribution_boxes WHERE fiscal_week = :fiscalWeek AND store = :store AND route LIKE :route

[
  "fiscalWeek" => 202606
  "store" => 7400
  "route" => "%"
]

SELECT
  COUNT(1) as Q
FROM
  distribution_boxes
WHERE
  fiscal_week = :fiscalWeek
  AND store = :store
  AND route LIKE :route

SELECT COUNT(1) as Q FROM distribution_boxes WHERE fiscal_week = 202606 AND store = 7400 AND route LIKE '%';

SELECT d.id, d.route, d.sku_description AS sku_description, d.scheduled_delivery_date AS scheduled_delivery_date, RIGHT(d.upc, 5) AS `description`, IF(d.qty_initial = 0, '', d.qty_initial) AS `qty_initial`, d.qty_placed, IF(d.qty_discarded = 0, '', d.qty_discarded) AS `qty_discarded`, IF(d.qty_final = 0, '', d.qty_final) AS `qty_final` FROM  `distribution` `d` LEFT JOIN  `sku` ON `d`.`upc` = `sku`.`upc` WHERE  d.fiscal_week = :fiscalWeek AND d.store = :store AND d.route LIKE :route ORDER BY d.route, IF(d.qty_placed = 0, 0, 1) DESC, d.upc ASC

[
  "fiscalWeek" => 202606
  "store" => 7400
  "route" => "%"
]

SELECT
  d.id,
  d.route,
  d.sku_description AS sku_description,
  d.scheduled_delivery_date AS scheduled_delivery_date,
  RIGHT(d.upc, 5) AS `description`,
  IF(
    d.qty_initial = 0, '', d.qty_initial
  ) AS `qty_initial`,
  d.qty_placed,
  IF(
    d.qty_discarded = 0, '', d.qty_discarded
  ) AS `qty_discarded`,
  IF(d.qty_final = 0, '', d.qty_final) AS `qty_final`
FROM
  `distribution` `d`
  LEFT JOIN `sku` ON `d`.`upc` = `sku`.`upc`
WHERE
  d.fiscal_week = :fiscalWeek
  AND d.store = :store
  AND d.route LIKE :route
ORDER BY
  d.route,
  IF(d.qty_placed = 0, 0, 1) DESC,
  d.upc ASC

SELECT d.id, d.route, d.sku_description AS sku_description, d.scheduled_delivery_date AS scheduled_delivery_date, RIGHT(d.upc, 5) AS `description`, IF(d.qty_initial = 0, '', d.qty_initial) AS `qty_initial`, d.qty_placed, IF(d.qty_discarded = 0, '', d.qty_discarded) AS `qty_discarded`, IF(d.qty_final = 0, '', d.qty_final) AS `qty_final` FROM  `distribution` `d` LEFT JOIN  `sku` ON `d`.`upc` = `sku`.`upc` WHERE  d.fiscal_week = 202606 AND d.store = 7400 AND d.route LIKE '%' ORDER BY d.route, IF(d.qty_placed = 0, 0, 1) DESC, d.upc ASC;

SELECT d.id, d.route, d.sku_description AS sku_description, d.scheduled_delivery_date AS scheduled_delivery_date, RIGHT(d.upc, 5) AS `description`, IF(d.qty_initial = 0, '', d.qty_initial) AS `qty_initial`, d.qty_placed, IF(d.qty_discarded = 0, '', d.qty_discarded) AS `qty_discarded`, IF(d.qty_final = 0, '', d.qty_final) AS `qty_final` FROM  `distribution` `d` LEFT JOIN  `sku` ON `d`.`upc` = `sku`.`upc` WHERE  d.fiscal_week = :fiscalWeek AND d.store = :store ORDER BY d.route, IF(d.qty_placed = 0, 0, 1) DESC, d.upc ASC

[
  "fiscalWeek" => 202606
  "store" => 7400
]

SELECT
  d.id,
  d.route,
  d.sku_description AS sku_description,
  d.scheduled_delivery_date AS scheduled_delivery_date,
  RIGHT(d.upc, 5) AS `description`,
  IF(
    d.qty_initial = 0, '', d.qty_initial
  ) AS `qty_initial`,
  d.qty_placed,
  IF(
    d.qty_discarded = 0, '', d.qty_discarded
  ) AS `qty_discarded`,
  IF(d.qty_final = 0, '', d.qty_final) AS `qty_final`
FROM
  `distribution` `d`
  LEFT JOIN `sku` ON `d`.`upc` = `sku`.`upc`
WHERE
  d.fiscal_week = :fiscalWeek
  AND d.store = :store
ORDER BY
  d.route,
  IF(d.qty_placed = 0, 0, 1) DESC,
  d.upc ASC

SELECT d.id, d.route, d.sku_description AS sku_description, d.scheduled_delivery_date AS scheduled_delivery_date, RIGHT(d.upc, 5) AS `description`, IF(d.qty_initial = 0, '', d.qty_initial) AS `qty_initial`, d.qty_placed, IF(d.qty_discarded = 0, '', d.qty_discarded) AS `qty_discarded`, IF(d.qty_final = 0, '', d.qty_final) AS `qty_final` FROM  `distribution` `d` LEFT JOIN  `sku` ON `d`.`upc` = `sku`.`upc` WHERE  d.fiscal_week = 202606 AND d.store = 7400 ORDER BY d.route, IF(d.qty_placed = 0, 0, 1) DESC, d.upc ASC;

SELECT d0_.id AS id_0, d0_.message AS message_1, d0_.created_at AS created_at_2, d0_.expires_after_days AS expires_after_days_3, d0_.store AS store_4, d0_.scheduled_delivery_date AS scheduled_delivery_date_5 FROM distribution_message d0_ WHERE d0_.store = ? AND d0_.scheduled_delivery_date IS NOT NULL AND (((d0_.scheduled_delivery_date IS NULL AND (d0_.expires_after_days IS NULL OR d0_.expires_after_days = 0)) OR (d0_.expires_after_days IS NULL AND d0_.scheduled_delivery_date IS NOT NULL AND DATE_ADD(d0_.scheduled_delivery_date, INTERVAL 1 DAY) > ?) OR (d0_.expires_after_days = 0) OR (d0_.expires_after_days > 0 AND d0_.scheduled_delivery_date IS NOT NULL AND DATE_ADD(d0_.scheduled_delivery_date, INTERVAL CASE WHEN d0_.expires_after_days < 100 THEN d0_.expires_after_days ELSE 100 END DAY) > ?)))

[
  "7400"
  "2026-02-05 12:25:44"
  "2026-02-05 12:25:44"
]

SELECT
  d0_.id AS id_0,
  d0_.message AS message_1,
  d0_.created_at AS created_at_2,
  d0_.expires_after_days AS expires_after_days_3,
  d0_.store AS store_4,
  d0_.scheduled_delivery_date AS scheduled_delivery_date_5
FROM
  distribution_message d0_
WHERE
  d0_.store = ?
  AND d0_.scheduled_delivery_date IS NOT NULL
  AND (
    (
      (
        d0_.scheduled_delivery_date IS NULL
        AND (
          d0_.expires_after_days IS NULL
          OR d0_.expires_after_days = 0
        )
      )
      OR (
        d0_.expires_after_days IS NULL
        AND d0_.scheduled_delivery_date IS NOT NULL
        AND DATE_ADD(
          d0_.scheduled_delivery_date, INTERVAL 1 DAY
        ) > ?
      )
      OR (d0_.expires_after_days = 0)
      OR (
        d0_.expires_after_days > 0
        AND d0_.scheduled_delivery_date IS NOT NULL
        AND DATE_ADD(
          d0_.scheduled_delivery_date, INTERVAL CASE WHEN d0_.expires_after_days < 100 THEN
            d0_.expires_after_days
          ELSE
            100
          END DAY
        ) > ?
      )
    )
  )

SELECT d0_.id AS id_0, d0_.message AS message_1, d0_.created_at AS created_at_2, d0_.expires_after_days AS expires_after_days_3, d0_.store AS store_4, d0_.scheduled_delivery_date AS scheduled_delivery_date_5 FROM distribution_message d0_ WHERE d0_.store = '7400' AND d0_.scheduled_delivery_date IS NOT NULL AND (((d0_.scheduled_delivery_date IS NULL AND (d0_.expires_after_days IS NULL OR d0_.expires_after_days = 0)) OR (d0_.expires_after_days IS NULL AND d0_.scheduled_delivery_date IS NOT NULL AND DATE_ADD(d0_.scheduled_delivery_date, INTERVAL 1 DAY) > '2026-02-05 12:25:44') OR (d0_.expires_after_days = 0) OR (d0_.expires_after_days > 0 AND d0_.scheduled_delivery_date IS NOT NULL AND DATE_ADD(d0_.scheduled_delivery_date, INTERVAL CASE WHEN d0_.expires_after_days < 100 THEN d0_.expires_after_days ELSE 100 END DAY) > '2026-02-05 12:25:44')));