Symfony Profiler

Query Metrics

43 Database Queries

5 Different statements

31.93 ms Query time

3 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

11.39 ms
(35.69%)

SELECT DISTINCT p0_.id AS id_0, p0_.nom AS nom_1 FROM photosarchives p0_ ORDER BY p0_.nom ASC LIMIT 20 OFFSET 3140

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.nom AS nom_1
FROM
  photosarchives p0_
ORDER BY
  p0_.nom ASC
LIMIT
  20 OFFSET 3140

SELECT DISTINCT p0_.id AS id_0, p0_.nom AS nom_1 FROM photosarchives p0_ ORDER BY p0_.nom ASC LIMIT 20 OFFSET 3140;

#	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)

8.91 ms
(27.91%)

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:

[
  4732
]

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

#	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)

7.37 ms
(23.09%)

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:

[
  4732
]

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

#	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.26 ms
(7.08%)

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)

1.99 ms
(6.23%)

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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.nom ASC

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  p0_.nom ASC

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 (4732, 4733, 4734, 4735, 4736, 4737, 4738, 4739, 4740, 4741, 4742, 4743, 4744, 4745, 4746, 4747, 4748, 4749, 4750, 4751) ORDER BY p0_.nom ASC;

#	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)

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\Evenement	No errors.
App\Entity\Hall	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=158&sort%5Bnom%5D=ASC

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping