Symfony Profiler

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

Query Metrics

SELECT a0_.id AS id_0, a0_.label AS label_1, a0_.accronym AS accronym_2, COUNT(DISTINCT b1_.id) AS sclr_3, COUNT(DISTINCT p2_.id) AS sclr_4, COALESCE(SUM(p2_.planned_budget), 0) AS sclr_5, COALESCE(SUM(e3_.amount), 0) AS sclr_6 FROM budget_item b1_ LEFT JOIN project p2_ ON b1_.id = p2_.budget_item_id LEFT JOIN administrative_unit a0_ ON p2_.administrative_unit_id = a0_.id LEFT JOIN expense e3_ ON p2_.id = e3_.project_id WHERE b1_.year = ? AND b1_.is_deleted = ? AND (p2_.is_deleted = ? OR p2_.is_deleted IS NULL) AND (a0_.is_deleted = ? OR a0_.is_deleted IS NULL) GROUP BY a0_.id, a0_.label, a0_.accronym ORDER BY a0_.label ASC

[
  2025
  0
  0
  0
]

SELECT
  a0_.id AS id_0,
  a0_.label AS label_1,
  a0_.accronym AS accronym_2,
  COUNT(DISTINCT b1_.id) AS sclr_3,
  COUNT(DISTINCT p2_.id) AS sclr_4,
  COALESCE(
    SUM(p2_.planned_budget),
    0
  ) AS sclr_5,
  COALESCE(
    SUM(e3_.amount),
    0
  ) AS sclr_6
FROM
  budget_item b1_
  LEFT JOIN project p2_ ON b1_.id = p2_.budget_item_id
  LEFT JOIN administrative_unit a0_ ON p2_.administrative_unit_id = a0_.id
  LEFT JOIN expense e3_ ON p2_.id = e3_.project_id
WHERE
  b1_.year = ?
  AND b1_.is_deleted = ?
  AND (
    p2_.is_deleted = ?
    OR p2_.is_deleted IS NULL
  )
  AND (
    a0_.is_deleted = ?
    OR a0_.is_deleted IS NULL
  )
GROUP BY
  a0_.id,
  a0_.label,
  a0_.accronym
ORDER BY
  a0_.label ASC

SELECT a0_.id AS id_0, a0_.label AS label_1, a0_.accronym AS accronym_2, COUNT(DISTINCT b1_.id) AS sclr_3, COUNT(DISTINCT p2_.id) AS sclr_4, COALESCE(SUM(p2_.planned_budget), 0) AS sclr_5, COALESCE(SUM(e3_.amount), 0) AS sclr_6 FROM budget_item b1_ LEFT JOIN project p2_ ON b1_.id = p2_.budget_item_id LEFT JOIN administrative_unit a0_ ON p2_.administrative_unit_id = a0_.id LEFT JOIN expense e3_ ON p2_.id = e3_.project_id WHERE b1_.year = 2025 AND b1_.is_deleted = 0 AND (p2_.is_deleted = 0 OR p2_.is_deleted IS NULL) AND (a0_.is_deleted = 0 OR a0_.is_deleted IS NULL) GROUP BY a0_.id, a0_.label, a0_.accronym ORDER BY a0_.label ASC;

SELECT b0_.id AS id_0, b0_.code AS code_1, b0_.label AS label_2, b0_.amount AS amount_3, b0_.year AS year_4, b0_.description AS description_5, COUNT(p1_.id) AS sclr_6, COALESCE(SUM(p1_.planned_budget), 0) AS sclr_7, COALESCE(SUM(e2_.amount), 0) AS sclr_8 FROM budget_item b0_ LEFT JOIN project p1_ ON b0_.id = p1_.budget_item_id LEFT JOIN expense e2_ ON p1_.id = e2_.project_id WHERE b0_.is_deleted = ? AND b0_.year = ? GROUP BY b0_.id, b0_.code, b0_.label, b0_.amount, b0_.year, b0_.description ORDER BY b0_.label ASC

[
  0
  2025
]

SELECT
  b0_.id AS id_0,
  b0_.code AS code_1,
  b0_.label AS label_2,
  b0_.amount AS amount_3,
  b0_.year AS year_4,
  b0_.description AS description_5,
  COUNT(p1_.id) AS sclr_6,
  COALESCE(
    SUM(p1_.planned_budget),
    0
  ) AS sclr_7,
  COALESCE(
    SUM(e2_.amount),
    0
  ) AS sclr_8
FROM
  budget_item b0_
  LEFT JOIN project p1_ ON b0_.id = p1_.budget_item_id
  LEFT JOIN expense e2_ ON p1_.id = e2_.project_id
WHERE
  b0_.is_deleted = ?
  AND b0_.year = ?
GROUP BY
  b0_.id,
  b0_.code,
  b0_.label,
  b0_.amount,
  b0_.year,
  b0_.description
ORDER BY
  b0_.label ASC

SELECT b0_.id AS id_0, b0_.code AS code_1, b0_.label AS label_2, b0_.amount AS amount_3, b0_.year AS year_4, b0_.description AS description_5, COUNT(p1_.id) AS sclr_6, COALESCE(SUM(p1_.planned_budget), 0) AS sclr_7, COALESCE(SUM(e2_.amount), 0) AS sclr_8 FROM budget_item b0_ LEFT JOIN project p1_ ON b0_.id = p1_.budget_item_id LEFT JOIN expense e2_ ON p1_.id = e2_.project_id WHERE b0_.is_deleted = 0 AND b0_.year = 2025 GROUP BY b0_.id, b0_.code, b0_.label, b0_.amount, b0_.year, b0_.description ORDER BY b0_.label ASC;

SELECT DISTINCT year FROM budget_item WHERE is_deleted = :isDeleted ORDER BY year DESC

[]

SELECT
  DISTINCT year
FROM
  budget_item
WHERE
  is_deleted = :isDeleted
ORDER BY
  year DESC

SELECT DISTINCT year FROM budget_item WHERE is_deleted = :isDeleted ORDER BY year DESC;