Symfony Profiler

Query Metrics

42 Database Queries

6 Different statements

14.85 ms Query time

3 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

5.52 ms
(37.19%)

SELECT t0.id AS id_1, t0.flux AS flux_2, t0.typecontenant AS typecontenant_3, t0.volumecontenant AS volumecontenant_4, t0.poids AS poids_5, t0.tauxderemplissage AS tauxderemplissage_6, t0.collecte AS collecte_7, t0.cumulflux AS cumulflux_8, t0.qualitedetribennes AS qualitedetribennes_9, t0.estimatifbennes AS estimatifbennes_10, t0.collectebennes AS collectebennes_11, t0.cumulbennes AS cumulbennes_12, t0.datedesoumission AS datedesoumission_13, t0.commentaire AS commentaire_14, t0.heure AS heure_15, t0.exutoire AS exutoire_16, t0.numerobordereau AS numerobordereau_17, t0.hall_id AS hall_id_18, t0.leclient_id AS leclient_id_19, t0.evenement_id AS evenement_id_20, t0.centredetris_id AS centredetris_id_21, t0.auteur_id AS auteur_id_22 FROM suivi t0 INNER JOIN photosarchives_suivi ON t0.id = photosarchives_suivi.suivi_id WHERE photosarchives_suivi.photosarchives_id = ?

Parameters:

[
  1764
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.flux AS flux_2,
  t0.typecontenant AS typecontenant_3,
  t0.volumecontenant AS volumecontenant_4,
  t0.poids AS poids_5,
  t0.tauxderemplissage AS tauxderemplissage_6,
  t0.collecte AS collecte_7,
  t0.cumulflux AS cumulflux_8,
  t0.qualitedetribennes AS qualitedetribennes_9,
  t0.estimatifbennes AS estimatifbennes_10,
  t0.collectebennes AS collectebennes_11,
  t0.cumulbennes AS cumulbennes_12,
  t0.datedesoumission AS datedesoumission_13,
  t0.commentaire AS commentaire_14,
  t0.heure AS heure_15,
  t0.exutoire AS exutoire_16,
  t0.numerobordereau AS numerobordereau_17,
  t0.hall_id AS hall_id_18,
  t0.leclient_id AS leclient_id_19,
  t0.evenement_id AS evenement_id_20,
  t0.centredetris_id AS centredetris_id_21,
  t0.auteur_id AS auteur_id_22
FROM
  suivi t0
  INNER JOIN photosarchives_suivi ON t0.id = photosarchives_suivi.suivi_id
WHERE
  photosarchives_suivi.photosarchives_id = ?

SELECT t0.id AS id_1, t0.flux AS flux_2, t0.typecontenant AS typecontenant_3, t0.volumecontenant AS volumecontenant_4, t0.poids AS poids_5, t0.tauxderemplissage AS tauxderemplissage_6, t0.collecte AS collecte_7, t0.cumulflux AS cumulflux_8, t0.qualitedetribennes AS qualitedetribennes_9, t0.estimatifbennes AS estimatifbennes_10, t0.collectebennes AS collectebennes_11, t0.cumulbennes AS cumulbennes_12, t0.datedesoumission AS datedesoumission_13, t0.commentaire AS commentaire_14, t0.heure AS heure_15, t0.exutoire AS exutoire_16, t0.numerobordereau AS numerobordereau_17, t0.hall_id AS hall_id_18, t0.leclient_id AS leclient_id_19, t0.evenement_id AS evenement_id_20, t0.centredetris_id AS centredetris_id_21, t0.auteur_id AS auteur_id_22 FROM suivi t0 INNER JOIN photosarchives_suivi ON t0.id = photosarchives_suivi.suivi_id WHERE photosarchives_suivi.photosarchives_id = 1764;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1051)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 980)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2712)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 252)
9	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->countNumElements (line 207)
10	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->configureToManyAssociation (line 135)
11	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->configure (line 107)
12	EasyCorp\Bundle\EasyAdminBundle\Factory\FieldFactory->processFields (line 43)
13	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->processFields (line 49)
14	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->processFieldsForAll (line 144)
15	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 178)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

5.20 ms
(34.98%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.datesoumission AS datesoumission_3, t0.evenement_id AS evenement_id_4 FROM commentaire t0 INNER JOIN commentaire_photosarchives ON t0.id = commentaire_photosarchives.commentaire_id WHERE commentaire_photosarchives.photosarchives_id = ?

Parameters:

[
  1764
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.datesoumission AS datesoumission_3,
  t0.evenement_id AS evenement_id_4
FROM
  commentaire t0
  INNER JOIN commentaire_photosarchives ON t0.id = commentaire_photosarchives.commentaire_id
WHERE
  commentaire_photosarchives.photosarchives_id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.datesoumission AS datesoumission_3, t0.evenement_id AS evenement_id_4 FROM commentaire t0 INNER JOIN commentaire_photosarchives ON t0.id = commentaire_photosarchives.commentaire_id WHERE commentaire_photosarchives.photosarchives_id = 1764;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1051)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 980)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2712)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 252)
9	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->countNumElements (line 207)
10	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->configureToManyAssociation (line 135)
11	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->configure (line 107)
12	EasyCorp\Bundle\EasyAdminBundle\Factory\FieldFactory->processFields (line 43)
13	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->processFields (line 49)
14	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->processFieldsForAll (line 144)
15	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 178)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

2.40 ms
(16.16%)

SELECT DISTINCT p0_.id AS id_0 FROM photosarchives p0_ LIMIT 20 OFFSET 9920

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT p0_.id AS id_0
FROM
  photosarchives p0_
LIMIT
  20 OFFSET 9920

SELECT DISTINCT p0_.id AS id_0 FROM photosarchives p0_ LIMIT 20 OFFSET 9920;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 127)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 67)
8	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 29)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 133)
10	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 178)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

1.01 ms
(6.82%)

SELECT COUNT(p0_.id) AS sclr_0 FROM photosarchives p0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  photosarchives p0_

SELECT COUNT(p0_.id) AS sclr_0 FROM photosarchives p0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 96)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 68)
8	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 29)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 133)
10	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 178)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.42 ms
(2.81%)

SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.dateupload AS dateupload_2, p0_.commentaire AS commentaire_3, p0_.titre AS titre_4, p0_.centredetri_id AS centredetri_id_5, p0_.inventaire_id AS inventaire_id_6, p0_.formulairemillenium_id AS formulairemillenium_id_7, p0_.suivi_photo_id AS suivi_photo_id_8 FROM photosarchives p0_ WHERE p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.nom AS nom_1,
  p0_.dateupload AS dateupload_2,
  p0_.commentaire AS commentaire_3,
  p0_.titre AS titre_4,
  p0_.centredetri_id AS centredetri_id_5,
  p0_.inventaire_id AS inventaire_id_6,
  p0_.formulairemillenium_id AS formulairemillenium_id_7,
  p0_.suivi_photo_id AS suivi_photo_id_8
FROM
  photosarchives p0_
WHERE
  p0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?
  )

SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.dateupload AS dateupload_2, p0_.commentaire AS commentaire_3, p0_.titre AS titre_4, p0_.centredetri_id AS centredetri_id_5, p0_.inventaire_id AS inventaire_id_6, p0_.formulairemillenium_id AS formulairemillenium_id_7, p0_.suivi_photo_id AS suivi_photo_id_8 FROM photosarchives p0_ WHERE p0_.id IN (1764, 1765, 1766, 1773, 1774, 1775, 1776, 1777, 1778, 1779, 1786, 1787, 1788, 1789, 1790, 1791, 1792, 1799, 1801);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 145)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 67)
8	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 29)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 133)
10	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 178)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.30 ms
(2.04%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.taille AS taille_3, t0.barrierages AS barrierages_4, t0.marquageausol AS marquageausol_5, t0.tonnelle AS tonnelle_6, t0.signaletiques AS signaletiques_7, t0.supportsachs AS supportsachs_8, t0.balances AS balances_9, t0.compacteur AS compacteur_10, t0.tabledetri AS tabledetri_11, t0.vidoirliquide AS vidoirliquide_12, t0.troussedesecours AS troussedesecours_13, t0.epi AS epi_14, t0.materielsdenettoyage AS materielsdenettoyage_15, t0.phase AS phase_16, t0.bacdr660 AS bacdr660_17, t0.bacdr240 AS bacdr240_18, t0.bacrecycle240 AS bacrecycle240_19, t0.bacrecycle660 AS bacrecycle660_20, t0.bacbiodechet120 AS bacbiodechet120_21, t0.bennebois AS bennebois_22, t0.bennecarton AS bennecarton_23, t0.benneplastiques AS benneplastiques_24, t0.bachenoires AS bachenoires_25, t0.site_id AS site_id_26 FROM centredetri t0 WHERE t0.id = ?

Parameters:

[
  41
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.taille AS taille_3,
  t0.barrierages AS barrierages_4,
  t0.marquageausol AS marquageausol_5,
  t0.tonnelle AS tonnelle_6,
  t0.signaletiques AS signaletiques_7,
  t0.supportsachs AS supportsachs_8,
  t0.balances AS balances_9,
  t0.compacteur AS compacteur_10,
  t0.tabledetri AS tabledetri_11,
  t0.vidoirliquide AS vidoirliquide_12,
  t0.troussedesecours AS troussedesecours_13,
  t0.epi AS epi_14,
  t0.materielsdenettoyage AS materielsdenettoyage_15,
  t0.phase AS phase_16,
  t0.bacdr660 AS bacdr660_17,
  t0.bacdr240 AS bacdr240_18,
  t0.bacrecycle240 AS bacrecycle240_19,
  t0.bacrecycle660 AS bacrecycle660_20,
  t0.bacbiodechet120 AS bacbiodechet120_21,
  t0.bennebois AS bennebois_22,
  t0.bennecarton AS bennecarton_23,
  t0.benneplastiques AS benneplastiques_24,
  t0.bachenoires AS bachenoires_25,
  t0.site_id AS site_id_26
FROM
  centredetri t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.taille AS taille_3, t0.barrierages AS barrierages_4, t0.marquageausol AS marquageausol_5, t0.tonnelle AS tonnelle_6, t0.signaletiques AS signaletiques_7, t0.supportsachs AS supportsachs_8, t0.balances AS balances_9, t0.compacteur AS compacteur_10, t0.tabledetri AS tabledetri_11, t0.vidoirliquide AS vidoirliquide_12, t0.troussedesecours AS troussedesecours_13, t0.epi AS epi_14, t0.materielsdenettoyage AS materielsdenettoyage_15, t0.phase AS phase_16, t0.bacdr660 AS bacdr660_17, t0.bacdr240 AS bacdr240_18, t0.bacrecycle240 AS bacrecycle240_19, t0.bacrecycle660 AS bacrecycle660_20, t0.bacbiodechet120 AS bacbiodechet120_21, t0.bennebois AS bennebois_22, t0.bennecarton AS bennecarton_23, t0.benneplastiques AS benneplastiques_24, t0.bachenoires AS bachenoires_25, t0.site_id AS site_id_26 FROM centredetri t0 WHERE t0.id = 41;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 221)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 61)
5	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 79)
6	Proxies\__CG__\App\Entity\Centredetri->__load (line 116)
7	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->doCreate (line 75)
8	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->createForEntityInstance (line 186)
9	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->configureToOneAssociation (line 131)
10	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->configure (line 107)
11	EasyCorp\Bundle\EasyAdminBundle\Factory\FieldFactory->processFields (line 43)
12	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->processFields (line 49)
13	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->processFieldsForAll (line 144)
14	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 178)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	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.

Entities Mapping

Class	Mapping errors
App\Entity\Photosarchives	No errors.
App\Entity\Centredetri	No errors.
App\Entity\Inventaire	No errors.
App\Entity\Formulairemillenium	The association App\Entity\Formulairemillenium#auteur refers to the inverse side field App\Entity\User#formulaireMillenium which does not exist.
App\Entity\SuiviPhoto	The association App\Entity\SuiviPhoto#createdBy refers to the inverse side field App\Entity\User#suiviPhotos which does not exist.
App\Entity\Suivi	No errors.
App\Entity\Commentaire	No errors.
App\Entity\Suivicentredetri	No errors.
App\Entity\Site	No errors.
App\Entity\Hall	No errors.
App\Entity\Evenement	No errors.
App\Entity\Client	No errors.
App\Entity\User	The field App\Entity\User#panier is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Panier#proprietaire does not contain the required 'inversedBy="panier"' attribute.

Symfony Profiler

GET https://bereup.online/admin?crudAction=index&crudControllerFqcn=App%5CController%5CAdmin%5CPhotosarchivesCrudController&page=497

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping