Symfony Profiler

Query Metrics

5 Database Queries

4 Different statements

15.56 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

5.28 ms
(33.92%)

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

Parameters:

View formatted query View runnable query Explain query View query backtrace

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;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\BudgetItemRepository->getBudgetItemsWithStatistics (line 80)
7	App\Service\ProjectStatisticsService->getBudgetItemsWithStatistics (line 464)
8	App\Controller\BudgetItemController->statistics (line 78)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

4.93 ms
(31.71%)

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

Parameters:

[
  2025
]

View formatted query View runnable query Explain query View query backtrace

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
            ;

#	File/Call
1	App\Service\ProjectStatisticsService->getHierarchicalBudgetData (line 627)
2	App\Controller\BudgetItemController->statistics (line 82)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
5	Symfony\Component\HttpKernel\Kernel->handle (line 182)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
7	require_once (line 29)
8	require_once (line 5)

4.77 ms
(30.68%)

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

Parameters:

View formatted query View runnable query Explain query View query backtrace

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;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\BudgetItemRepository->getBudgetByAdministrativeUnit (line 188)
7	App\Service\ProjectStatisticsService->getBudgetByAdministrativeUnit (line 516)
8	App\Controller\BudgetItemController->statistics (line 79)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

0.57 ms
(3.69%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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;

#	File/Call
1	App\Service\ProjectStatisticsService->getAvailableBudgetYears (line 709)
2	App\Controller\BudgetItemController->statistics (line 81)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
5	Symfony\Component\HttpKernel\Kernel->handle (line 182)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
7	require_once (line 29)
8	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects

Entities Mapping

Class	Mapping errors
App\Entity\BudgetItem	No errors.
App\Entity\Project	No errors.
App\Entity\Expense	No errors.
App\Entity\AdministrativeUnit	No errors.

Symfony Profiler

GET http://84.247.183.216/index.php/budget-items/statistics

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping