Symfony Profiler

Query Metrics

27 Database Queries

9 Different statements

31.56 ms Query time

3 Invalid entities

29 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

13.21 ms
(41.87%)

SELECT SUM(v0_.tonnes) AS sclr_0 FROM valorisation v0_ WHERE v0_.id_tc_structure = ? AND v0_.annee = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  SUM(v0_.tonnes) AS sclr_0
FROM
  valorisation v0_
WHERE
  v0_.id_tc_structure = ?
  AND v0_.annee = ?

SELECT SUM(v0_.tonnes) AS sclr_0 FROM valorisation v0_ WHERE v0_.id_tc_structure = 102 AND v0_.annee = 2021;

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Repository\ValorisationRepository->getTauxPerYear (line 84)
8	App\Controller\DechetsController->getChartTaux (line 278)
9	App\Controller\DechetsController->index (line 33)
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)

6.72 ms
(21.30%)

SELECT g0_.id_gpso_flux_ou_prestation AS id_gpso_flux_ou_prestation_0, g0_.code AS code_1, g0_.libelle AS libelle_2, g0_.fa_icon AS fa_icon_3, g0_.color AS color_4, g0_.is_active AS is_active_5, g0_.structure AS structure_6 FROM gpso_flux_ou_prestation g0_ WHERE g0_.structure = ? AND g0_.code = ?

Parameters:

[
  102
  "OMR"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  g0_.id_gpso_flux_ou_prestation AS id_gpso_flux_ou_prestation_0,
  g0_.code AS code_1,
  g0_.libelle AS libelle_2,
  g0_.fa_icon AS fa_icon_3,
  g0_.color AS color_4,
  g0_.is_active AS is_active_5,
  g0_.structure AS structure_6
FROM
  gpso_flux_ou_prestation g0_
WHERE
  g0_.structure = ?
  AND g0_.code = ?

SELECT g0_.id_gpso_flux_ou_prestation AS id_gpso_flux_ou_prestation_0, g0_.code AS code_1, g0_.libelle AS libelle_2, g0_.fa_icon AS fa_icon_3, g0_.color AS color_4, g0_.is_active AS is_active_5, g0_.structure AS structure_6 FROM gpso_flux_ou_prestation g0_ WHERE g0_.structure = 102 AND g0_.code = 'OMR';

#	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->getOneOrNullResult (line 737)
6	App\Repository\FluxRepository->findOneByCode (line 41)
7	App\Controller\DechetsController->getChartEvolution (line 126)
8	App\Controller\DechetsController->index (line 18)
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)

2.73 ms
(8.66%)

SELECT SUM(v0_.tonnes) AS sclr_0 FROM valorisation v0_ WHERE v0_.id_tc_structure = ? AND v0_.annee = ? AND v0_.is_valorisation = 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  SUM(v0_.tonnes) AS sclr_0
FROM
  valorisation v0_
WHERE
  v0_.id_tc_structure = ?
  AND v0_.annee = ?
  AND v0_.is_valorisation = 1

SELECT SUM(v0_.tonnes) AS sclr_0 FROM valorisation v0_ WHERE v0_.id_tc_structure = 102 AND v0_.annee = 2021 AND v0_.is_valorisation = 1;

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Repository\ValorisationRepository->getTauxPerYear (line 74)
8	App\Controller\DechetsController->getChartTaux (line 278)
9	App\Controller\DechetsController->index (line 33)
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)

2.04 ms
(6.46%)

SELECT t0.id_decheterie AS id_decheterie_1, t0.nom AS nom_2, t0.adresse AS adresse_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.telephone AS telephone_6, t0.open_lun_matin AS open_lun_matin_7, t0.open_lun_aprem AS open_lun_aprem_8, t0.open_mar_matin AS open_mar_matin_9, t0.open_mar_aprem AS open_mar_aprem_10, t0.open_mer_matin AS open_mer_matin_11, t0.open_mer_aprem AS open_mer_aprem_12, t0.open_jeu_matin AS open_jeu_matin_13, t0.open_jeu_aprem AS open_jeu_aprem_14, t0.open_ven_matin AS open_ven_matin_15, t0.open_ven_aprem AS open_ven_aprem_16, t0.open_sam_matin AS open_sam_matin_17, t0.open_sam_aprem AS open_sam_aprem_18, t0.open_dim_matin AS open_dim_matin_19, t0.open_dim_aprem AS open_dim_aprem_20, t0.icon AS icon_21, t0.conditions_acces AS conditions_acces_22, t0.informations AS informations_23, t0.photo_1 AS photo_1_24, t0.photo_2 AS photo_2_25, t0.photo_3 AS photo_3_26, t0.visible AS visible_27, t0.id_tc_flux AS id_tc_flux_28, t0.id_tc_ville AS id_tc_ville_29 FROM decheterie t0 WHERE t0.id_tc_flux = ?

Parameters:

[
  443
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id_decheterie AS id_decheterie_1,
  t0.nom AS nom_2,
  t0.adresse AS adresse_3,
  t0.latitude AS latitude_4,
  t0.longitude AS longitude_5,
  t0.telephone AS telephone_6,
  t0.open_lun_matin AS open_lun_matin_7,
  t0.open_lun_aprem AS open_lun_aprem_8,
  t0.open_mar_matin AS open_mar_matin_9,
  t0.open_mar_aprem AS open_mar_aprem_10,
  t0.open_mer_matin AS open_mer_matin_11,
  t0.open_mer_aprem AS open_mer_aprem_12,
  t0.open_jeu_matin AS open_jeu_matin_13,
  t0.open_jeu_aprem AS open_jeu_aprem_14,
  t0.open_ven_matin AS open_ven_matin_15,
  t0.open_ven_aprem AS open_ven_aprem_16,
  t0.open_sam_matin AS open_sam_matin_17,
  t0.open_sam_aprem AS open_sam_aprem_18,
  t0.open_dim_matin AS open_dim_matin_19,
  t0.open_dim_aprem AS open_dim_aprem_20,
  t0.icon AS icon_21,
  t0.conditions_acces AS conditions_acces_22,
  t0.informations AS informations_23,
  t0.photo_1 AS photo_1_24,
  t0.photo_2 AS photo_2_25,
  t0.photo_3 AS photo_3_26,
  t0.visible AS visible_27,
  t0.id_tc_flux AS id_tc_flux_28,
  t0.id_tc_ville AS id_tc_ville_29
FROM
  decheterie t0
WHERE
  t0.id_tc_flux = ?

SELECT t0.id_decheterie AS id_decheterie_1, t0.nom AS nom_2, t0.adresse AS adresse_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.telephone AS telephone_6, t0.open_lun_matin AS open_lun_matin_7, t0.open_lun_aprem AS open_lun_aprem_8, t0.open_mar_matin AS open_mar_matin_9, t0.open_mar_aprem AS open_mar_aprem_10, t0.open_mer_matin AS open_mer_matin_11, t0.open_mer_aprem AS open_mer_aprem_12, t0.open_jeu_matin AS open_jeu_matin_13, t0.open_jeu_aprem AS open_jeu_aprem_14, t0.open_ven_matin AS open_ven_matin_15, t0.open_ven_aprem AS open_ven_aprem_16, t0.open_sam_matin AS open_sam_matin_17, t0.open_sam_aprem AS open_sam_aprem_18, t0.open_dim_matin AS open_dim_matin_19, t0.open_dim_aprem AS open_dim_aprem_20, t0.icon AS icon_21, t0.conditions_acces AS conditions_acces_22, t0.informations AS informations_23, t0.photo_1 AS photo_1_24, t0.photo_2 AS photo_2_25, t0.photo_3 AS photo_3_26, t0.visible AS visible_27, t0.id_tc_flux AS id_tc_flux_28, t0.id_tc_ville AS id_tc_ville_29 FROM decheterie t0 WHERE t0.id_tc_flux = 443;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 837)
3	Doctrine\ORM\UnitOfWork->createEntity (line 2458)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 268)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 495)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 147)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 175)
8	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
9	Doctrine\ORM\AbstractQuery->execute (line 886)
10	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
11	App\Repository\FluxRepository->findOneByCode (line 41)
12	App\Controller\DechetsController->getChartEvolution (line 126)
13	App\Controller\DechetsController->index (line 18)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 182)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
18	require_once (line 29)
19	require_once (line 5)

1.86 ms
(5.91%)

SELECT v0_.annee AS annee_0 FROM valorisation v0_ WHERE v0_.id_tc_structure = ? GROUP BY v0_.annee ORDER BY v0_.annee ASC

Parameters:

[
  102
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  v0_.annee AS annee_0
FROM
  valorisation v0_
WHERE
  v0_.id_tc_structure = ?
GROUP BY
  v0_.annee
ORDER BY
  v0_.annee ASC

SELECT v0_.annee AS annee_0 FROM valorisation v0_ WHERE v0_.id_tc_structure = 102 GROUP BY v0_.annee ORDER BY v0_.annee 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\ValorisationRepository->getYears (line 43)
7	App\Controller\DechetsController->getChartTaux (line 276)
8	App\Controller\DechetsController->index (line 33)
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)

1.80 ms
(5.72%)

SELECT t0.id_objectif AS id_objectif_1, t0.id_tonnage AS id_tonnage_2, t0.annee AS annee_3, t0.tonnes AS tonnes_4, t0.habitants AS habitants_5, t0.id_tc_flux AS id_tc_flux_6, t0.id_tc_structure AS id_tc_structure_7 FROM objectif t0 WHERE t0.id_tc_flux = ?

Parameters:

[
  443
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id_objectif AS id_objectif_1,
  t0.id_tonnage AS id_tonnage_2,
  t0.annee AS annee_3,
  t0.tonnes AS tonnes_4,
  t0.habitants AS habitants_5,
  t0.id_tc_flux AS id_tc_flux_6,
  t0.id_tc_structure AS id_tc_structure_7
FROM
  objectif t0
WHERE
  t0.id_tc_flux = ?

SELECT t0.id_objectif AS id_objectif_1, t0.id_tonnage AS id_tonnage_2, t0.annee AS annee_3, t0.tonnes AS tonnes_4, t0.habitants AS habitants_5, t0.id_tc_flux AS id_tc_flux_6, t0.id_tc_structure AS id_tc_structure_7 FROM objectif t0 WHERE t0.id_tc_flux = 443;

#	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 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->filter (line 237)
7	App\Controller\DechetsController->getChartEvolution (line 132)
8	App\Controller\DechetsController->index (line 18)
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)

1.35 ms
(4.28%)

SELECT t0.id_tonnage AS id_tonnage_1, t0.annee AS annee_2, t0.tonnes AS tonnes_3, t0.habitants AS habitants_4, t0.id_tc_flux AS id_tc_flux_5, t0.id_tc_structure AS id_tc_structure_6 FROM tonnage t0 WHERE t0.id_tc_flux = ?

Parameters:

[
  443
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id_tonnage AS id_tonnage_1,
  t0.annee AS annee_2,
  t0.tonnes AS tonnes_3,
  t0.habitants AS habitants_4,
  t0.id_tc_flux AS id_tc_flux_5,
  t0.id_tc_structure AS id_tc_structure_6
FROM
  tonnage t0
WHERE
  t0.id_tc_flux = ?

SELECT t0.id_tonnage AS id_tonnage_1, t0.annee AS annee_2, t0.tonnes AS tonnes_3, t0.habitants AS habitants_4, t0.id_tc_flux AS id_tc_flux_5, t0.id_tc_structure AS id_tc_structure_6 FROM tonnage t0 WHERE t0.id_tc_flux = 443;

#	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 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	App\Controller\DechetsController->getChartEvolution (line 129)
8	App\Controller\DechetsController->index (line 18)
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)

1.29 ms
(4.09%)

SELECT t0.id_cout AS id_cout_1, t0.annee AS annee_2, t0.depense AS depense_3, t0.id_tc_structure AS id_tc_structure_4, t0.id_tc_flux AS id_tc_flux_5 FROM cout t0 WHERE t0.id_tc_flux = ?

Parameters:

[
  443
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id_cout AS id_cout_1,
  t0.annee AS annee_2,
  t0.depense AS depense_3,
  t0.id_tc_structure AS id_tc_structure_4,
  t0.id_tc_flux AS id_tc_flux_5
FROM
  cout t0
WHERE
  t0.id_tc_flux = ?

SELECT t0.id_cout AS id_cout_1, t0.annee AS annee_2, t0.depense AS depense_3, t0.id_tc_structure AS id_tc_structure_4, t0.id_tc_flux AS id_tc_flux_5 FROM cout t0 WHERE t0.id_tc_flux = 443;

#	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 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	App\Controller\DechetsController->getChartCout (line 197)
8	App\Controller\DechetsController->index (line 20)
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.54 ms
(1.72%)

SELECT v0_.id_valorisation AS id_valorisation_0, v0_.annee AS annee_1, v0_.tonnes AS tonnes_2, v0_.filiere AS filiere_3, v0_.is_valorisation AS is_valorisation_4, v0_.id_tc_structure AS id_tc_structure_5 FROM valorisation v0_ WHERE v0_.id_tc_structure = ? AND v0_.annee = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  v0_.id_valorisation AS id_valorisation_0,
  v0_.annee AS annee_1,
  v0_.tonnes AS tonnes_2,
  v0_.filiere AS filiere_3,
  v0_.is_valorisation AS is_valorisation_4,
  v0_.id_tc_structure AS id_tc_structure_5
FROM
  valorisation v0_
WHERE
  v0_.id_tc_structure = ?
  AND v0_.annee = ?

SELECT v0_.id_valorisation AS id_valorisation_0, v0_.annee AS annee_1, v0_.tonnes AS tonnes_2, v0_.filiere AS filiere_3, v0_.is_valorisation AS is_valorisation_4, v0_.id_tc_structure AS id_tc_structure_5 FROM valorisation v0_ WHERE v0_.id_tc_structure = 102 AND v0_.annee = 2025;

#	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\ValorisationRepository->findByYear (line 30)
7	App\Controller\DechetsController->getChartValorisation (line 228)
8	App\Controller\DechetsController->index (line 31)
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)

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\Tonnage	10
App\Entity\Objectif	8
App\Entity\Cout	8
App\Entity\Flux	2
App\Entity\Tc_structure	1

Entities Mapping

Class	Mapping errors
App\Entity\Flux	The association App\Entity\Flux#valorisations refers to the owning side field App\Entity\Valorisation#flux which does not exist.
App\Entity\Tc_structure	The mappings App\Entity\Tc_structure#TcSignalementFile and App\Entity\TcSignalementsFiles#tcStructure are inconsistent with each other.
App\Entity\Decheterie	No errors.
App\Entity\TcVille	No errors.
App\Entity\Objectif	No errors.
App\Entity\Pav	No errors.
App\Entity\Tonnage	No errors.
App\Entity\Valorisation	No errors.
App\Entity\Actualite	The association App\Entity\Actualite#villesRattachees refers to the inverse side field App\Entity\TcVille#actualitesRattachees which does not exist.
App\Entity\Cout	No errors.

Symfony Profiler

GET http://demo-app.wastreet.app/dechets

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping