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 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 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;

SELECT
                    bi.id as budget_item_id,
                    bi.code as budget_item_code,
                    bi.label as budget_item_label,
                    bi.amount as budget_item_amount,
                    bi.description as budget_item_description,
                    au.id as unit_id,
                    au.label as unit_label,
                    au.accronym as unit_accronym,
                    p.id as project_id,
                    p.code as project_code,
                    p.title as project_title,
                    p.type as project_type,
                    p.planned_budget as project_planned_budget,
                    p.realized_budget as project_realized_budget,
                    p.status as project_status
                FROM budget_item bi
                LEFT JOIN project p ON bi.id = p.budget_item_id AND (p.is_deleted IS NULL OR p.is_deleted = 0)
                LEFT JOIN administrative_unit au ON p.administrative_unit_id = au.id AND (au.is_deleted IS NULL OR au.is_deleted = 0)
                WHERE bi.year = ?
                AND bi.is_deleted = 0
                ORDER BY bi.code, au.label, p.code

[
  2025
]

SELECT
  bi.id as budget_item_id,
  bi.code as budget_item_code,
  bi.label as budget_item_label,
  bi.amount as budget_item_amount,
  bi.description as budget_item_description,
  au.id as unit_id,
  au.label as unit_label,
  au.accronym as unit_accronym,
  p.id as project_id,
  p.code as project_code,
  p.title as project_title,
  p.type as project_type,
  p.planned_budget as project_planned_budget,
  p.realized_budget as project_realized_budget,
  p.status as project_status
FROM
  budget_item bi
  LEFT JOIN project p ON bi.id = p.budget_item_id
  AND (
    p.is_deleted IS NULL
    OR p.is_deleted = 0
  )
  LEFT JOIN administrative_unit au ON p.administrative_unit_id = au.id
  AND (
    au.is_deleted IS NULL
    OR au.is_deleted = 0
  )
WHERE
  bi.year = ?
  AND bi.is_deleted = 0
ORDER BY
  bi.code,
  au.label,
  p.code

SELECT
                    bi.id as budget_item_id,
                    bi.code as budget_item_code,
                    bi.label as budget_item_label,
                    bi.amount as budget_item_amount,
                    bi.description as budget_item_description,
                    au.id as unit_id,
                    au.label as unit_label,
                    au.accronym as unit_accronym,
                    p.id as project_id,
                    p.code as project_code,
                    p.title as project_title,
                    p.type as project_type,
                    p.planned_budget as project_planned_budget,
                    p.realized_budget as project_realized_budget,
                    p.status as project_status
                FROM budget_item bi
                LEFT JOIN project p ON bi.id = p.budget_item_id AND (p.is_deleted IS NULL OR p.is_deleted = 0)
                LEFT JOIN administrative_unit au ON p.administrative_unit_id = au.id AND (au.is_deleted IS NULL OR au.is_deleted = 0)
                WHERE bi.year = 2025
                AND bi.is_deleted = 0
                ORDER BY bi.code, au.label, p.code
            ;