Symfony Profiler

Query Metrics

501 Database Queries

6 Different statements

121.70 ms Query time

1 Invalid entities

317 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

48.12 ms
(39.54%)

204

SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.amount AS amount_4, t0.expense_date AS expense_date_5, t0.category AS category_6, t0.provider AS provider_7, t0.invoice_number AS invoice_number_8, t0.payment_method AS payment_method_9, t0.receipt_number AS receipt_number_10, t0.notes AS notes_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.validated_at AS validated_at_14, t0.status AS status_15, t0.project_step_id AS project_step_id_16, t0.project_id AS project_id_17, t0.created_by_id AS created_by_id_18, t0.validated_by_id AS validated_by_id_19 FROM expense t0 WHERE t0.project_id = ?

Parameters:

[
  160
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.description AS description_3,
  t0.amount AS amount_4,
  t0.expense_date AS expense_date_5,
  t0.category AS category_6,
  t0.provider AS provider_7,
  t0.invoice_number AS invoice_number_8,
  t0.payment_method AS payment_method_9,
  t0.receipt_number AS receipt_number_10,
  t0.notes AS notes_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.validated_at AS validated_at_14,
  t0.status AS status_15,
  t0.project_step_id AS project_step_id_16,
  t0.project_id AS project_id_17,
  t0.created_by_id AS created_by_id_18,
  t0.validated_by_id AS validated_by_id_19
FROM
  expense t0
WHERE
  t0.project_id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.amount AS amount_4, t0.expense_date AS expense_date_5, t0.category AS category_6, t0.provider AS provider_7, t0.invoice_number AS invoice_number_8, t0.payment_method AS payment_method_9, t0.receipt_number AS receipt_number_10, t0.notes AS notes_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.validated_at AS validated_at_14, t0.status AS status_15, t0.project_step_id AS project_step_id_16, t0.project_id AS project_id_17, t0.created_by_id AS created_by_id_18, t0.validated_by_id AS validated_by_id_19 FROM expense t0 WHERE t0.project_id = 160;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	App\Entity\Project->getTotalExpenses (line 445)
8	App\Entity\Project->updateExecutedBudget (line 491)
9	App\Entity\Project->getRealizedBudget (line 218)
10	App\Service\ProjectStatisticsService->getProjectsForObjective (line 297)
11	App\Service\ProjectStatisticsService->getProjectsByObjectiveHierarchy (line 201)
12	App\Controller\MasterController->projectsHierarchy (line 90)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 182)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
17	require_once (line 29)
18	require_once (line 5)

46.86 ms
(38.50%)

204

SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.planned_budget AS planned_budget_4, t0.executed_budget AS executed_budget_5, t0.planned_start_date AS planned_start_date_6, t0.planned_end_date AS planned_end_date_7, t0.actual_start_date AS actual_start_date_8, t0.actual_end_date AS actual_end_date_9, t0.position AS position_10, t0.status AS status_11, t0.progress_percentage AS progress_percentage_12, t0.notes AS notes_13, t0.is_deleted AS is_deleted_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.project_id AS project_id_17 FROM project_steps t0 WHERE t0.project_id = ?

Parameters:

[
  160
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.description AS description_3,
  t0.planned_budget AS planned_budget_4,
  t0.executed_budget AS executed_budget_5,
  t0.planned_start_date AS planned_start_date_6,
  t0.planned_end_date AS planned_end_date_7,
  t0.actual_start_date AS actual_start_date_8,
  t0.actual_end_date AS actual_end_date_9,
  t0.position AS position_10,
  t0.status AS status_11,
  t0.progress_percentage AS progress_percentage_12,
  t0.notes AS notes_13,
  t0.is_deleted AS is_deleted_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.project_id AS project_id_17
FROM
  project_steps t0
WHERE
  t0.project_id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.planned_budget AS planned_budget_4, t0.executed_budget AS executed_budget_5, t0.planned_start_date AS planned_start_date_6, t0.planned_end_date AS planned_end_date_7, t0.actual_start_date AS actual_start_date_8, t0.actual_end_date AS actual_end_date_9, t0.position AS position_10, t0.status AS status_11, t0.progress_percentage AS progress_percentage_12, t0.notes AS notes_13, t0.is_deleted AS is_deleted_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.project_id AS project_id_17 FROM project_steps t0 WHERE t0.project_id = 160;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 39)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	App\Entity\Project->getProjectExecutionRate (line 129)
9	App\Service\ProjectStatisticsService->getProjectsForObjective (line 299)
10	App\Service\ProjectStatisticsService->getProjectsByObjectiveHierarchy (line 201)
11	App\Controller\MasterController->projectsHierarchy (line 90)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 182)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 29)
17	require_once (line 5)

17.88 ms
(14.69%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.type AS type_3, t0.is_investment_project AS is_investment_project_4, t0.planned_budget AS planned_budget_5, t0.realized_budget AS realized_budget_6, t0.status AS status_7, t0.planned_start_date AS planned_start_date_8, t0.planned_end_date AS planned_end_date_9, t0.actual_start_date AS actual_start_date_10, t0.actual_end_date AS actual_end_date_11, t0.created_at AS created_at_12, t0.market_type AS market_type_13, t0.is_deleted AS is_deleted_14, t0.title AS title_15, t0.phase AS phase_16, t0.description AS description_17, t0.is_sub_project AS is_sub_project_18, t0.currency_id AS currency_id_19, t0.site_id AS site_id_20, t0.objective_id AS objective_id_21, t0.administrative_unit_id AS administrative_unit_id_22, t0.budget_item_id AS budget_item_id_23, t0.main_project_id AS main_project_id_24 FROM project t0 WHERE t0.objective_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.type AS type_3,
  t0.is_investment_project AS is_investment_project_4,
  t0.planned_budget AS planned_budget_5,
  t0.realized_budget AS realized_budget_6,
  t0.status AS status_7,
  t0.planned_start_date AS planned_start_date_8,
  t0.planned_end_date AS planned_end_date_9,
  t0.actual_start_date AS actual_start_date_10,
  t0.actual_end_date AS actual_end_date_11,
  t0.created_at AS created_at_12,
  t0.market_type AS market_type_13,
  t0.is_deleted AS is_deleted_14,
  t0.title AS title_15,
  t0.phase AS phase_16,
  t0.description AS description_17,
  t0.is_sub_project AS is_sub_project_18,
  t0.currency_id AS currency_id_19,
  t0.site_id AS site_id_20,
  t0.objective_id AS objective_id_21,
  t0.administrative_unit_id AS administrative_unit_id_22,
  t0.budget_item_id AS budget_item_id_23,
  t0.main_project_id AS main_project_id_24
FROM
  project t0
WHERE
  t0.objective_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.type AS type_3, t0.is_investment_project AS is_investment_project_4, t0.planned_budget AS planned_budget_5, t0.realized_budget AS realized_budget_6, t0.status AS status_7, t0.planned_start_date AS planned_start_date_8, t0.planned_end_date AS planned_end_date_9, t0.actual_start_date AS actual_start_date_10, t0.actual_end_date AS actual_end_date_11, t0.created_at AS created_at_12, t0.market_type AS market_type_13, t0.is_deleted AS is_deleted_14, t0.title AS title_15, t0.phase AS phase_16, t0.description AS description_17, t0.is_sub_project AS is_sub_project_18, t0.currency_id AS currency_id_19, t0.site_id AS site_id_20, t0.objective_id AS objective_id_21, t0.administrative_unit_id AS administrative_unit_id_22, t0.budget_item_id AS budget_item_id_23, t0.main_project_id AS main_project_id_24 FROM project t0 WHERE t0.objective_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	App\Service\ProjectStatisticsService->getProjectsForObjective (line 291)
8	App\Service\ProjectStatisticsService->getProjectsByObjectiveHierarchy (line 179)
9	App\Controller\MasterController->projectsHierarchy (line 90)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 182)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

4.49 ms
(3.69%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.position AS position_3, t0.label AS label_4, t0.description AS description_5, t0.type AS type_6, t0.start_date AS start_date_7, t0.deadline AS deadline_8, t0.status AS status_9, t0.is_deleted AS is_deleted_10, t0.created_at AS created_at_11, t0.higher_objective_id AS higher_objective_id_12, t0.administrative_unit_id AS administrative_unit_id_13 FROM objective t0 WHERE t0.higher_objective_id = ? AND t0.type = ?

Parameters:

[
  1
  "intermédiaire"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.position AS position_3,
  t0.label AS label_4,
  t0.description AS description_5,
  t0.type AS type_6,
  t0.start_date AS start_date_7,
  t0.deadline AS deadline_8,
  t0.status AS status_9,
  t0.is_deleted AS is_deleted_10,
  t0.created_at AS created_at_11,
  t0.higher_objective_id AS higher_objective_id_12,
  t0.administrative_unit_id AS administrative_unit_id_13
FROM
  objective t0
WHERE
  t0.higher_objective_id = ?
  AND t0.type = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.position AS position_3, t0.label AS label_4, t0.description AS description_5, t0.type AS type_6, t0.start_date AS start_date_7, t0.deadline AS deadline_8, t0.status AS status_9, t0.is_deleted AS is_deleted_10, t0.created_at AS created_at_11, t0.higher_objective_id AS higher_objective_id_12, t0.administrative_unit_id AS administrative_unit_id_13 FROM objective t0 WHERE t0.higher_objective_id = 1 AND t0.type = 'intermédiaire';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Service\ProjectStatisticsService->getProjectsByObjectiveHierarchy (line 184)
5	App\Controller\MasterController->projectsHierarchy (line 90)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 182)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	require_once (line 5)

3.09 ms
(2.54%)

SELECT t0.id AS id_1, t0.label AS label_2, t0.accronym AS accronym_3, t0.type AS type_4, t0.is_deleted AS is_deleted_5 FROM administrative_unit t0 WHERE t0.id = ?

Parameters:

[
  9
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.accronym AS accronym_3,
  t0.type AS type_4,
  t0.is_deleted AS is_deleted_5
FROM
  administrative_unit t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.accronym AS accronym_3, t0.type AS type_4, t0.is_deleted AS is_deleted_5 FROM administrative_unit t0 WHERE t0.id = 9;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 289)
4	Proxies\__CG__\App\Entity\AdministrativeUnit::Doctrine\ORM\Proxy\{closure} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\AdministrativeUnit->__get (line 153)
7	App\Entity\AdministrativeUnit->getLabel (line 54)
8	App\Service\ProjectStatisticsService->getProjectsByObjectiveHierarchy (line 209)
9	App\Controller\MasterController->projectsHierarchy (line 90)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 182)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

1.27 ms
(1.04%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.position AS position_3, t0.label AS label_4, t0.description AS description_5, t0.type AS type_6, t0.start_date AS start_date_7, t0.deadline AS deadline_8, t0.status AS status_9, t0.is_deleted AS is_deleted_10, t0.created_at AS created_at_11, t0.higher_objective_id AS higher_objective_id_12, t0.administrative_unit_id AS administrative_unit_id_13 FROM objective t0 WHERE t0.type = ? AND t0.higher_objective_id IS NULL

Parameters:

[
  "stratégique"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.position AS position_3,
  t0.label AS label_4,
  t0.description AS description_5,
  t0.type AS type_6,
  t0.start_date AS start_date_7,
  t0.deadline AS deadline_8,
  t0.status AS status_9,
  t0.is_deleted AS is_deleted_10,
  t0.created_at AS created_at_11,
  t0.higher_objective_id AS higher_objective_id_12,
  t0.administrative_unit_id AS administrative_unit_id_13
FROM
  objective t0
WHERE
  t0.type = ?
  AND t0.higher_objective_id IS NULL

SELECT t0.id AS id_1, t0.code AS code_2, t0.position AS position_3, t0.label AS label_4, t0.description AS description_5, t0.type AS type_6, t0.start_date AS start_date_7, t0.deadline AS deadline_8, t0.status AS status_9, t0.is_deleted AS is_deleted_10, t0.created_at AS created_at_11, t0.higher_objective_id AS higher_objective_id_12, t0.administrative_unit_id AS administrative_unit_id_13 FROM objective t0 WHERE t0.type = 'stratégique' AND t0.higher_objective_id IS NULL;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Service\ProjectStatisticsService->getProjectsByObjectiveHierarchy (line 168)
5	App\Controller\MasterController->projectsHierarchy (line 90)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 182)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	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
App\Entity\Project	204
App\Entity\Objective	62
App\Entity\Expense	23
App\Entity\AdministrativeUnit	15
App\Entity\BudgetItem	12
App\Entity\Currency	1

Entities Mapping

Class	Mapping errors
App\Entity\Objective	No errors.
App\Entity\AdministrativeUnit	No errors.
App\Entity\Project	No errors.
App\Entity\Currency	The association App\Entity\Currency#deviseCible refers to the owning side field App\Entity\ConversionDevise#devise_source which does not exist.
App\Entity\Site	No errors.
App\Entity\BudgetItem	No errors.
App\Entity\ProjectSteps	No errors.
App\Entity\Expense	No errors.
App\Entity\User	No errors.

Symfony Profiler

GET https://bcc-project-tracker.com/projects/hierarchy

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping