Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

1.54 ms Query time

2 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.68 ms

SELECT t0.id AS id_1, t0.longueur AS longueur_2, t0.largeur AS largeur_3, t0.hauteur AS hauteur_4, t0.diametre AS diametre_5, t0.unite_diametre AS unite_diametre_6, t0.materiaux AS materiaux_7, t0.color1 AS color1_8, t0.marque AS marque_9, t0.etat AS etat_10, t0.description AS description_11, t0.conditionnement AS conditionnement_12, t0.risques_precautions AS risques_precautions_13, t0.etape AS etape_14, t0.quantite AS quantite_15, t0.unite_quantite AS unite_quantite_16, t0.actions AS actions_17, t0.localisation AS localisation_18, t0.visuel AS visuel_19, t0.lesvisuels AS lesvisuels_20, t0.poids AS poids_21, t0.quantite_reservee AS quantite_reservee_22, t0.date_debut_reservation AS date_debut_reservation_23, t0.date_fin_reservation AS date_fin_reservation_24, t0.designation AS designation_25, t0.site_id AS site_id_26, t0.provenance_id AS provenance_id_27 FROM inventaire t0 WHERE t0.id = ?

Parameters:

[
  "196"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.longueur AS longueur_2,
  t0.largeur AS largeur_3,
  t0.hauteur AS hauteur_4,
  t0.diametre AS diametre_5,
  t0.unite_diametre AS unite_diametre_6,
  t0.materiaux AS materiaux_7,
  t0.color1 AS color1_8,
  t0.marque AS marque_9,
  t0.etat AS etat_10,
  t0.description AS description_11,
  t0.conditionnement AS conditionnement_12,
  t0.risques_precautions AS risques_precautions_13,
  t0.etape AS etape_14,
  t0.quantite AS quantite_15,
  t0.unite_quantite AS unite_quantite_16,
  t0.actions AS actions_17,
  t0.localisation AS localisation_18,
  t0.visuel AS visuel_19,
  t0.lesvisuels AS lesvisuels_20,
  t0.poids AS poids_21,
  t0.quantite_reservee AS quantite_reservee_22,
  t0.date_debut_reservation AS date_debut_reservation_23,
  t0.date_fin_reservation AS date_fin_reservation_24,
  t0.designation AS designation_25,
  t0.site_id AS site_id_26,
  t0.provenance_id AS provenance_id_27
FROM
  inventaire t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.longueur AS longueur_2, t0.largeur AS largeur_3, t0.hauteur AS hauteur_4, t0.diametre AS diametre_5, t0.unite_diametre AS unite_diametre_6, t0.materiaux AS materiaux_7, t0.color1 AS color1_8, t0.marque AS marque_9, t0.etat AS etat_10, t0.description AS description_11, t0.conditionnement AS conditionnement_12, t0.risques_precautions AS risques_precautions_13, t0.etape AS etape_14, t0.quantite AS quantite_15, t0.unite_quantite AS unite_quantite_16, t0.actions AS actions_17, t0.localisation AS localisation_18, t0.visuel AS visuel_19, t0.lesvisuels AS lesvisuels_20, t0.poids AS poids_21, t0.quantite_reservee AS quantite_reservee_22, t0.date_debut_reservation AS date_debut_reservation_23, t0.date_fin_reservation AS date_fin_reservation_24, t0.designation AS designation_25, t0.site_id AS site_id_26, t0.provenance_id AS provenance_id_27 FROM inventaire t0 WHERE t0.id = '196';

#	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 146)
7	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->getEntityInstance (line 111)
8	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->doCreate (line 70)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->create (line 243)
10	EasyCorp\Bundle\EasyAdminBundle\Factory\AdminContextFactory->getEntityDto (line 62)
11	EasyCorp\Bundle\EasyAdminBundle\Factory\AdminContextFactory->create (line 78)
12	EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber->onKernelRequest (line 116)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 154)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.50 ms

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.dateupload AS dateupload_3, t0.commentaire AS commentaire_4, t0.titre AS titre_5, t0.centredetri_id AS centredetri_id_6, t0.inventaire_id AS inventaire_id_7, t0.formulairemillenium_id AS formulairemillenium_id_8, t0.suivi_photo_id AS suivi_photo_id_9 FROM photosarchives t0 WHERE t0.inventaire_id = ?

Parameters:

[
  196
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.dateupload AS dateupload_3,
  t0.commentaire AS commentaire_4,
  t0.titre AS titre_5,
  t0.centredetri_id AS centredetri_id_6,
  t0.inventaire_id AS inventaire_id_7,
  t0.formulairemillenium_id AS formulairemillenium_id_8,
  t0.suivi_photo_id AS suivi_photo_id_9
FROM
  photosarchives t0
WHERE
  t0.inventaire_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.dateupload AS dateupload_3, t0.commentaire AS commentaire_4, t0.titre AS titre_5, t0.centredetri_id AS centredetri_id_6, t0.inventaire_id AS inventaire_id_7, t0.formulairemillenium_id AS formulairemillenium_id_8, t0.suivi_photo_id AS suivi_photo_id_9 FROM photosarchives t0 WHERE t0.inventaire_id = 196;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1803)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1748)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2708)
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 182)
14	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->detail (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)

0.36 ms

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.datedebut AS datedebut_3, t0.datefin AS datefin_4, t0.montage_debut AS montage_debut_5, t0.montage_fin AS montage_fin_6, t0.exploitation_debut AS exploitation_debut_7, t0.exploitation_fin AS exploitation_fin_8, t0.demontage_debut AS demontage_debut_9, t0.demontage_fin AS demontage_fin_10, t0.lien AS lien_11, t0.reemploi AS reemploi_12, t0.suivi_biodechet AS suivi_biodechet_13, t0.inventaire_ctalogue AS inventaire_ctalogue_14, t0.leclient_id AS leclient_id_15, t0.logo_id AS logo_id_16 FROM evenement t0 WHERE t0.id = ?

Parameters:

[
  31
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.datedebut AS datedebut_3,
  t0.datefin AS datefin_4,
  t0.montage_debut AS montage_debut_5,
  t0.montage_fin AS montage_fin_6,
  t0.exploitation_debut AS exploitation_debut_7,
  t0.exploitation_fin AS exploitation_fin_8,
  t0.demontage_debut AS demontage_debut_9,
  t0.demontage_fin AS demontage_fin_10,
  t0.lien AS lien_11,
  t0.reemploi AS reemploi_12,
  t0.suivi_biodechet AS suivi_biodechet_13,
  t0.inventaire_ctalogue AS inventaire_ctalogue_14,
  t0.leclient_id AS leclient_id_15,
  t0.logo_id AS logo_id_16
FROM
  evenement t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.datedebut AS datedebut_3, t0.datefin AS datefin_4, t0.montage_debut AS montage_debut_5, t0.montage_fin AS montage_fin_6, t0.exploitation_debut AS exploitation_debut_7, t0.exploitation_fin AS exploitation_fin_8, t0.demontage_debut AS demontage_debut_9, t0.demontage_fin AS demontage_fin_10, t0.lien AS lien_11, t0.reemploi AS reemploi_12, t0.suivi_biodechet AS suivi_biodechet_13, t0.inventaire_ctalogue AS inventaire_ctalogue_14, t0.leclient_id AS leclient_id_15, t0.logo_id AS logo_id_16 FROM evenement t0 WHERE t0.id = 31;

#	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\Evenement->__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 182)
13	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->detail (line 178)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	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\Inventaire	No errors.
App\Entity\Site	No errors.
App\Entity\Evenement	No errors.
App\Entity\Photosarchives	No errors.
App\Entity\Reservation	No errors.
App\Entity\Panier	No errors.
App\Entity\Centredetri	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\Client	No errors.
App\Entity\Hall	No errors.
App\Entity\Donation	No errors.
App\Entity\Documents	No errors.
App\Entity\InfosStand	No errors.
App\Entity\Suivijournalierstand	No errors.
App\Entity\InventaireCatalogue	No errors.
App\Entity\FicheDeco	No errors.

Symfony Profiler

GET https://bereup.online/admin?crudAction=detail&crudControllerFqcn=App%5CController%5CAdmin%5CInventaireCrudController&entityId=196&page=8&sort%5BProvenance%5D=DE…

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping