Symfony Profiler

Query Metrics

44 Database Queries

6 Different statements

16.01 ms Query time

3 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

6.61 ms
(41.29%)

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:

[
  624
]

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

#	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.05 ms
(31.57%)

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:

[
  624
]

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

#	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.82 ms
(17.60%)

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.66 ms
(4.12%)

SELECT t0.id AS id_1, t0.login AS login_2, t0.roles AS roles_3, t0.password AS password_4, t0.prenom AS prenom_5, t0.nom AS nom_6, t0.datedenaissance AS datedenaissance_7, t0.lieudenaissance AS lieudenaissance_8, t0.adresse AS adresse_9, t0.contact AS contact_10, t0.rib AS rib_11, t0.siret AS siret_12, t0.securitesociale AS securitesociale_13, t0.email AS email_14, t0.contacturgence AS contacturgence_15, t0.contacturgencetel AS contacturgencetel_16, t0.photo AS photo_17, t0.permis AS permis_18, t0.autres AS autres_19, t20.id AS id_21, t20.nom_structure AS nom_structure_22, t20.type_structure AS type_structure_23, t20.types_projet AS types_projet_24, t20.volume_vehicule AS volume_vehicule_25, t20.manutention AS manutention_26, t20.adresse AS adresse_27, t20.nom_contact AS nom_contact_28, t20.email_contact AS email_contact_29, t20.telephone_contact AS telephone_contact_30, t20.site_web AS site_web_31, t20.linkedin AS linkedin_32, t20.ressources AS ressources_33, t20.details AS details_34, t20.validation AS validation_35, t20.user_id AS user_id_36, t37.id AS id_38, t37.quantites AS quantites_39, t37.proprietaire_id AS proprietaire_id_40 FROM `user` t0 LEFT JOIN filiere t20 ON t20.user_id = t0.id LEFT JOIN panier t37 ON t37.proprietaire_id = t0.id WHERE t0.id = ?

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.login AS login_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.prenom AS prenom_5,
  t0.nom AS nom_6,
  t0.datedenaissance AS datedenaissance_7,
  t0.lieudenaissance AS lieudenaissance_8,
  t0.adresse AS adresse_9,
  t0.contact AS contact_10,
  t0.rib AS rib_11,
  t0.siret AS siret_12,
  t0.securitesociale AS securitesociale_13,
  t0.email AS email_14,
  t0.contacturgence AS contacturgence_15,
  t0.contacturgencetel AS contacturgencetel_16,
  t0.photo AS photo_17,
  t0.permis AS permis_18,
  t0.autres AS autres_19,
  t20.id AS id_21,
  t20.nom_structure AS nom_structure_22,
  t20.type_structure AS type_structure_23,
  t20.types_projet AS types_projet_24,
  t20.volume_vehicule AS volume_vehicule_25,
  t20.manutention AS manutention_26,
  t20.adresse AS adresse_27,
  t20.nom_contact AS nom_contact_28,
  t20.email_contact AS email_contact_29,
  t20.telephone_contact AS telephone_contact_30,
  t20.site_web AS site_web_31,
  t20.linkedin AS linkedin_32,
  t20.ressources AS ressources_33,
  t20.details AS details_34,
  t20.validation AS validation_35,
  t20.user_id AS user_id_36,
  t37.id AS id_38,
  t37.quantites AS quantites_39,
  t37.proprietaire_id AS proprietaire_id_40
FROM
  `user` t0
  LEFT JOIN filiere t20 ON t20.user_id = t0.id
  LEFT JOIN panier t37 ON t37.proprietaire_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.login AS login_2, t0.roles AS roles_3, t0.password AS password_4, t0.prenom AS prenom_5, t0.nom AS nom_6, t0.datedenaissance AS datedenaissance_7, t0.lieudenaissance AS lieudenaissance_8, t0.adresse AS adresse_9, t0.contact AS contact_10, t0.rib AS rib_11, t0.siret AS siret_12, t0.securitesociale AS securitesociale_13, t0.email AS email_14, t0.contacturgence AS contacturgence_15, t0.contacturgencetel AS contacturgencetel_16, t0.photo AS photo_17, t0.permis AS permis_18, t0.autres AS autres_19, t20.id AS id_21, t20.nom_structure AS nom_structure_22, t20.type_structure AS type_structure_23, t20.types_projet AS types_projet_24, t20.volume_vehicule AS volume_vehicule_25, t20.manutention AS manutention_26, t20.adresse AS adresse_27, t20.nom_contact AS nom_contact_28, t20.email_contact AS email_contact_29, t20.telephone_contact AS telephone_contact_30, t20.site_web AS site_web_31, t20.linkedin AS linkedin_32, t20.ressources AS ressources_33, t20.details AS details_34, t20.validation AS validation_35, t20.user_id AS user_id_36, t37.id AS id_38, t37.quantites AS quantites_39, t37.proprietaire_id AS proprietaire_id_40 FROM `user` t0 LEFT JOIN filiere t20 ON t20.user_id = t0.id LEFT JOIN panier t37 ON t37.proprietaire_id = t0.id WHERE t0.id = 7;

#	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 357)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 60)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 92)
7	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 207)
8	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 127)
9	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 73)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->Symfony\Bundle\SecurityBundle\Security\{closure} (line 34)
12	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage->getToken (line 44)
13	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 35)
14	Symfony\Component\Security\Core\Authorization\AuthorizationChecker->isGranted (line 32)
15	EasyCorp\Bundle\EasyAdminBundle\Security\AuthorizationChecker->isGranted (line 125)
16	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->doCreate (line 70)
17	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->create (line 243)
18	EasyCorp\Bundle\EasyAdminBundle\Factory\AdminContextFactory->getEntityDto (line 62)
19	EasyCorp\Bundle\EasyAdminBundle\Factory\AdminContextFactory->create (line 78)
20	EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber->onKernelRequest (line 116)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 154)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.53 ms
(3.32%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

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

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

0.34 ms
(2.10%)

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 (624, 625, 626, 627, 634, 635, 636, 637, 638, 639, 1590, 1591, 1592, 1593, 1594, 1595, 1596, 1597, 1598, 1599);

#	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\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.
App\Entity\Filiere	No errors.
App\Entity\Panier	No errors.
App\Entity\Suivi	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\Commentaire	No errors.
App\Entity\Suivicentredetri	No errors.
App\Entity\Evenement	No errors.
App\Entity\Hall	No errors.
App\Entity\Client	No errors.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping