Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Doctrine 3
• Debug
• Emails
• Serializer
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.batch_number AS batch_number_2, t0.quantity AS quantity_3, t0.expiration_date AS expiration_date_4, t0.received_at AS received_at_5, t0.supplier AS supplier_6, t0.purchase_price AS purchase_price_7, t0.status AS status_8, t0.notes AS notes_9, t0.product_id AS product_id_10, t0.received_by_id AS received_by_id_11 FROM stock_batch t0 WHERE t0.status = ? ORDER BY t0.expiration_date ASC

[
  "active"
]

SELECT
  t0.id AS id_1,
  t0.batch_number AS batch_number_2,
  t0.quantity AS quantity_3,
  t0.expiration_date AS expiration_date_4,
  t0.received_at AS received_at_5,
  t0.supplier AS supplier_6,
  t0.purchase_price AS purchase_price_7,
  t0.status AS status_8,
  t0.notes AS notes_9,
  t0.product_id AS product_id_10,
  t0.received_by_id AS received_by_id_11
FROM
  stock_batch t0
WHERE
  t0.status = ?
ORDER BY
  t0.expiration_date ASC

SELECT t0.id AS id_1, t0.batch_number AS batch_number_2, t0.quantity AS quantity_3, t0.expiration_date AS expiration_date_4, t0.received_at AS received_at_5, t0.supplier AS supplier_6, t0.purchase_price AS purchase_price_7, t0.status AS status_8, t0.notes AS notes_9, t0.product_id AS product_id_10, t0.received_by_id AS received_by_id_11 FROM stock_batch t0 WHERE t0.status = 'active' ORDER BY t0.expiration_date ASC;

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.email AS email_3, t0.phone AS phone_4, t0.password AS password_5, t0.roles AS roles_6, t0.position AS position_7, t0.salary AS salary_8, t0.hire_date AS hire_date_9, t0.address AS address_10, t0.is_active AS is_active_11, t0.created_at AS created_at_12 FROM employees t0 WHERE t0.id = ?

[
  5
]

SELECT
  t0.id AS id_1,
  t0.full_name AS full_name_2,
  t0.email AS email_3,
  t0.phone AS phone_4,
  t0.password AS password_5,
  t0.roles AS roles_6,
  t0.position AS position_7,
  t0.salary AS salary_8,
  t0.hire_date AS hire_date_9,
  t0.address AS address_10,
  t0.is_active AS is_active_11,
  t0.created_at AS created_at_12
FROM
  employees t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.email AS email_3, t0.phone AS phone_4, t0.password AS password_5, t0.roles AS roles_6, t0.position AS position_7, t0.salary AS salary_8, t0.hire_date AS hire_date_9, t0.address AS address_10, t0.is_active AS is_active_11, t0.created_at AS created_at_12 FROM employees t0 WHERE t0.id = 5;

SELECT s0_.id AS id_0, s0_.batch_number AS batch_number_1, s0_.quantity AS quantity_2, s0_.expiration_date AS expiration_date_3, s0_.received_at AS received_at_4, s0_.supplier AS supplier_5, s0_.purchase_price AS purchase_price_6, s0_.status AS status_7, s0_.notes AS notes_8, s0_.product_id AS product_id_9, s0_.received_by_id AS received_by_id_10 FROM stock_batch s0_ LEFT JOIN products p1_ ON s0_.product_id = p1_.id WHERE (s0_.expiration_date BETWEEN ? AND ?) AND s0_.status = ? AND s0_.quantity > 0 ORDER BY s0_.expiration_date ASC

[
  "2026-01-19 22:09:37"
  "2026-02-18 22:09:37"
  "active"
]

SELECT
  s0_.id AS id_0,
  s0_.batch_number AS batch_number_1,
  s0_.quantity AS quantity_2,
  s0_.expiration_date AS expiration_date_3,
  s0_.received_at AS received_at_4,
  s0_.supplier AS supplier_5,
  s0_.purchase_price AS purchase_price_6,
  s0_.status AS status_7,
  s0_.notes AS notes_8,
  s0_.product_id AS product_id_9,
  s0_.received_by_id AS received_by_id_10
FROM
  stock_batch s0_
  LEFT JOIN products p1_ ON s0_.product_id = p1_.id
WHERE
  (
    s0_.expiration_date BETWEEN ?
    AND ?
  )
  AND s0_.status = ?
  AND s0_.quantity > 0
ORDER BY
  s0_.expiration_date ASC

SELECT s0_.id AS id_0, s0_.batch_number AS batch_number_1, s0_.quantity AS quantity_2, s0_.expiration_date AS expiration_date_3, s0_.received_at AS received_at_4, s0_.supplier AS supplier_5, s0_.purchase_price AS purchase_price_6, s0_.status AS status_7, s0_.notes AS notes_8, s0_.product_id AS product_id_9, s0_.received_by_id AS received_by_id_10 FROM stock_batch s0_ LEFT JOIN products p1_ ON s0_.product_id = p1_.id WHERE (s0_.expiration_date BETWEEN '2026-01-19 22:09:37' AND '2026-02-18 22:09:37') AND s0_.status = 'active' AND s0_.quantity > 0 ORDER BY s0_.expiration_date ASC;

SELECT COUNT(s0_.id) AS sclr_0 FROM stock_batch s0_ WHERE s0_.quantity > 0

[]

SELECT
  COUNT(s0_.id) AS sclr_0
FROM
  stock_batch s0_
WHERE
  s0_.quantity > 0

SELECT COUNT(s0_.id) AS sclr_0 FROM stock_batch s0_ WHERE s0_.quantity > 0;

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.barcode AS barcode_4, t0.purchase_price AS purchase_price_5, t0.selling_price AS selling_price_6, t0.stock_quantity AS stock_quantity_7, t0.min_stock_alert AS min_stock_alert_8, t0.unit AS unit_9, t0.image AS image_10, t0.is_active AS is_active_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.category_id AS category_id_14, t0.supplier_id AS supplier_id_15 FROM products t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.barcode AS barcode_4,
  t0.purchase_price AS purchase_price_5,
  t0.selling_price AS selling_price_6,
  t0.stock_quantity AS stock_quantity_7,
  t0.min_stock_alert AS min_stock_alert_8,
  t0.unit AS unit_9,
  t0.image AS image_10,
  t0.is_active AS is_active_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.category_id AS category_id_14,
  t0.supplier_id AS supplier_id_15
FROM
  products t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.barcode AS barcode_4, t0.purchase_price AS purchase_price_5, t0.selling_price AS selling_price_6, t0.stock_quantity AS stock_quantity_7, t0.min_stock_alert AS min_stock_alert_8, t0.unit AS unit_9, t0.image AS image_10, t0.is_active AS is_active_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.category_id AS category_id_14, t0.supplier_id AS supplier_id_15 FROM products t0 WHERE t0.id = 1;

SELECT COUNT(s0_.id) AS sclr_0 FROM stock_batch s0_ WHERE s0_.expiration_date < ? AND s0_.status = ? AND s0_.quantity > 0

[
  "2026-01-19 22:09:37"
  "active"
]

SELECT
  COUNT(s0_.id) AS sclr_0
FROM
  stock_batch s0_
WHERE
  s0_.expiration_date < ?
  AND s0_.status = ?
  AND s0_.quantity > 0

SELECT COUNT(s0_.id) AS sclr_0 FROM stock_batch s0_ WHERE s0_.expiration_date < '2026-01-19 22:09:37' AND s0_.status = 'active' AND s0_.quantity > 0;