Symfony Profiler

• Request / Response
• Performance
• Exception
• Logs 1
• Events
• Routing
• Cache
• Twig
• HTTP Client
• Doctrine
• Configuration

Query Metrics

SELECT o0_.id AS id_0, o0_.company_id AS company_id_1, o0_.platform_id AS platform_id_2, o0_.order_id AS order_id_3, o0_.product_id AS product_id_4, o0_.product_price_id AS product_price_id_5, o0_.product_recipe_id AS product_recipe_id_6, o0_.quantity AS quantity_7, o0_.unit_final_price AS unit_final_price_8, o0_.is_active AS is_active_9, p1_.product_id AS product_id_10, p1_.vat_id AS vat_id_11, p1_.currency_id AS currency_id_12, p2_.category_id AS category_id_13, p2_.name AS name_14, p2_.weight AS weight_15, p2_.weight_unit_id AS weight_unit_id_16, p2_.product_unit_id AS product_unit_id_17, p2_.shuttle AS shuttle_18, p3_.name AS name_19, u4_.label AS label_20, u5_.label AS label_21, p6_.label AS label_22 FROM order_product o0_ LEFT JOIN product_price p1_ ON (o0_.product_price_id = p1_.id) LEFT JOIN product p2_ ON (o0_.product_id = p2_.id) LEFT JOIN product_category p3_ ON (p2_.category_id = p3_.id) LEFT JOIN unit u4_ ON (p2_.weight_unit_id = u4_.id) LEFT JOIN unit u5_ ON (p2_.product_unit_id = u5_.id) LEFT JOIN product_recipe p6_ ON (o0_.product_recipe_id = p6_.id) WHERE o0_.order_id = ? AND o0_.company_id = ? AND o0_.is_active = ?

[
  13174
  1
  1
]

SELECT
  o0_.id AS id_0,
  o0_.company_id AS company_id_1,
  o0_.platform_id AS platform_id_2,
  o0_.order_id AS order_id_3,
  o0_.product_id AS product_id_4,
  o0_.product_price_id AS product_price_id_5,
  o0_.product_recipe_id AS product_recipe_id_6,
  o0_.quantity AS quantity_7,
  o0_.unit_final_price AS unit_final_price_8,
  o0_.is_active AS is_active_9,
  p1_.product_id AS product_id_10,
  p1_.vat_id AS vat_id_11,
  p1_.currency_id AS currency_id_12,
  p2_.category_id AS category_id_13,
  p2_.name AS name_14,
  p2_.weight AS weight_15,
  p2_.weight_unit_id AS weight_unit_id_16,
  p2_.product_unit_id AS product_unit_id_17,
  p2_.shuttle AS shuttle_18,
  p3_.name AS name_19,
  u4_.label AS label_20,
  u5_.label AS label_21,
  p6_.label AS label_22
FROM
  order_product o0_
  LEFT JOIN product_price p1_ ON (o0_.product_price_id = p1_.id)
  LEFT JOIN product p2_ ON (o0_.product_id = p2_.id)
  LEFT JOIN product_category p3_ ON (p2_.category_id = p3_.id)
  LEFT JOIN unit u4_ ON (p2_.weight_unit_id = u4_.id)
  LEFT JOIN unit u5_ ON (p2_.product_unit_id = u5_.id)
  LEFT JOIN product_recipe p6_ ON (o0_.product_recipe_id = p6_.id)
WHERE
  o0_.order_id = ?
  AND o0_.company_id = ?
  AND o0_.is_active = ?

SELECT o0_.id AS id_0, o0_.company_id AS company_id_1, o0_.platform_id AS platform_id_2, o0_.order_id AS order_id_3, o0_.product_id AS product_id_4, o0_.product_price_id AS product_price_id_5, o0_.product_recipe_id AS product_recipe_id_6, o0_.quantity AS quantity_7, o0_.unit_final_price AS unit_final_price_8, o0_.is_active AS is_active_9, p1_.product_id AS product_id_10, p1_.vat_id AS vat_id_11, p1_.currency_id AS currency_id_12, p2_.category_id AS category_id_13, p2_.name AS name_14, p2_.weight AS weight_15, p2_.weight_unit_id AS weight_unit_id_16, p2_.product_unit_id AS product_unit_id_17, p2_.shuttle AS shuttle_18, p3_.name AS name_19, u4_.label AS label_20, u5_.label AS label_21, p6_.label AS label_22 FROM order_product o0_ LEFT JOIN product_price p1_ ON (o0_.product_price_id = p1_.id) LEFT JOIN product p2_ ON (o0_.product_id = p2_.id) LEFT JOIN product_category p3_ ON (p2_.category_id = p3_.id) LEFT JOIN unit u4_ ON (p2_.weight_unit_id = u4_.id) LEFT JOIN unit u5_ ON (p2_.product_unit_id = u5_.id) LEFT JOIN product_recipe p6_ ON (o0_.product_recipe_id = p6_.id) WHERE o0_.order_id = 13174 AND o0_.company_id = 1 AND o0_.is_active = 1;

SELECT o0_.id AS id_0, o0_.production_day_id AS production_day_id_1 FROM `order` o0_ WHERE o0_.company_id = ? AND o0_.is_active = ? AND o0_.production_day_id = ? AND o0_.status_id >= ? ORDER BY o0_.id DESC

[
  1
  1
  0
  3
]

SELECT
  o0_.id AS id_0,
  o0_.production_day_id AS production_day_id_1
FROM
  `order` o0_
WHERE
  o0_.company_id = ?
  AND o0_.is_active = ?
  AND o0_.production_day_id = ?
  AND o0_.status_id >= ?
ORDER BY
  o0_.id DESC

SELECT o0_.id AS id_0, o0_.production_day_id AS production_day_id_1 FROM `order` o0_ WHERE o0_.company_id = 1 AND o0_.is_active = 1 AND o0_.production_day_id = 0 AND o0_.status_id >= 3 ORDER BY o0_.id DESC;

SELECT p0_.id AS id_0, p0_.platform_id AS platform_id_1, p0_.product_id AS product_id_2, p0_.quantity AS quantity_3, p0_.history_id AS history_id_4 FROM product_current_stock p0_ WHERE p0_.product_id = ? AND p0_.platform_id = ? LIMIT 1

[
  15
  1
]

SELECT
  p0_.id AS id_0,
  p0_.platform_id AS platform_id_1,
  p0_.product_id AS product_id_2,
  p0_.quantity AS quantity_3,
  p0_.history_id AS history_id_4
FROM
  product_current_stock p0_
WHERE
  p0_.product_id = ?
  AND p0_.platform_id = ?
LIMIT
  1

SELECT p0_.id AS id_0, p0_.platform_id AS platform_id_1, p0_.product_id AS product_id_2, p0_.quantity AS quantity_3, p0_.history_id AS history_id_4 FROM product_current_stock p0_ WHERE p0_.product_id = 15 AND p0_.platform_id = 1 LIMIT 1;

SELECT p0_.id AS id_0, p0_.is_active AS is_active_1 FROM production_day p0_ WHERE p0_.company_id = ? AND p0_.date = ? AND p0_.is_active = ? LIMIT 1

[
  1
  "2026-03-12 00:00:00"
  1
]

SELECT
  p0_.id AS id_0,
  p0_.is_active AS is_active_1
FROM
  production_day p0_
WHERE
  p0_.company_id = ?
  AND p0_.date = ?
  AND p0_.is_active = ?
LIMIT
  1

SELECT p0_.id AS id_0, p0_.is_active AS is_active_1 FROM production_day p0_ WHERE p0_.company_id = 1 AND p0_.date = '2026-03-12 00:00:00' AND p0_.is_active = 1 LIMIT 1;