Symfony Profiler

Query Metrics

24 Database Queries

5 Different statements

5.49 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.17 ms
(75.98%)

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:

[
  112
]

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

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

0.44 ms
(7.99%)

SELECT i0_.id AS id_0, i0_.longueur AS longueur_1, i0_.largeur AS largeur_2, i0_.hauteur AS hauteur_3, i0_.diametre AS diametre_4, i0_.unite_diametre AS unite_diametre_5, i0_.materiaux AS materiaux_6, i0_.color1 AS color1_7, i0_.marque AS marque_8, i0_.etat AS etat_9, i0_.description AS description_10, i0_.conditionnement AS conditionnement_11, i0_.risques_precautions AS risques_precautions_12, i0_.etape AS etape_13, i0_.quantite AS quantite_14, i0_.unite_quantite AS unite_quantite_15, i0_.actions AS actions_16, i0_.localisation AS localisation_17, i0_.visuel AS visuel_18, i0_.lesvisuels AS lesvisuels_19, i0_.poids AS poids_20, i0_.quantite_reservee AS quantite_reservee_21, i0_.date_debut_reservation AS date_debut_reservation_22, i0_.date_fin_reservation AS date_fin_reservation_23, i0_.designation AS designation_24, i0_.categorie AS categorie_25, i0_.site_id AS site_id_26, i0_.provenance_id AS provenance_id_27 FROM inventaire i0_ WHERE i0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  i0_.id AS id_0,
  i0_.longueur AS longueur_1,
  i0_.largeur AS largeur_2,
  i0_.hauteur AS hauteur_3,
  i0_.diametre AS diametre_4,
  i0_.unite_diametre AS unite_diametre_5,
  i0_.materiaux AS materiaux_6,
  i0_.color1 AS color1_7,
  i0_.marque AS marque_8,
  i0_.etat AS etat_9,
  i0_.description AS description_10,
  i0_.conditionnement AS conditionnement_11,
  i0_.risques_precautions AS risques_precautions_12,
  i0_.etape AS etape_13,
  i0_.quantite AS quantite_14,
  i0_.unite_quantite AS unite_quantite_15,
  i0_.actions AS actions_16,
  i0_.localisation AS localisation_17,
  i0_.visuel AS visuel_18,
  i0_.lesvisuels AS lesvisuels_19,
  i0_.poids AS poids_20,
  i0_.quantite_reservee AS quantite_reservee_21,
  i0_.date_debut_reservation AS date_debut_reservation_22,
  i0_.date_fin_reservation AS date_fin_reservation_23,
  i0_.designation AS designation_24,
  i0_.categorie AS categorie_25,
  i0_.site_id AS site_id_26,
  i0_.provenance_id AS provenance_id_27
FROM
  inventaire i0_
WHERE
  i0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )

SELECT i0_.id AS id_0, i0_.longueur AS longueur_1, i0_.largeur AS largeur_2, i0_.hauteur AS hauteur_3, i0_.diametre AS diametre_4, i0_.unite_diametre AS unite_diametre_5, i0_.materiaux AS materiaux_6, i0_.color1 AS color1_7, i0_.marque AS marque_8, i0_.etat AS etat_9, i0_.description AS description_10, i0_.conditionnement AS conditionnement_11, i0_.risques_precautions AS risques_precautions_12, i0_.etape AS etape_13, i0_.quantite AS quantite_14, i0_.unite_quantite AS unite_quantite_15, i0_.actions AS actions_16, i0_.localisation AS localisation_17, i0_.visuel AS visuel_18, i0_.lesvisuels AS lesvisuels_19, i0_.poids AS poids_20, i0_.quantite_reservee AS quantite_reservee_21, i0_.date_debut_reservation AS date_debut_reservation_22, i0_.date_fin_reservation AS date_fin_reservation_23, i0_.designation AS designation_24, i0_.categorie AS categorie_25, i0_.site_id AS site_id_26, i0_.provenance_id AS provenance_id_27 FROM inventaire i0_ WHERE i0_.id IN (112, 113, 114, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133);

#	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.38 ms
(6.89%)

SELECT DISTINCT i0_.id AS id_0 FROM inventaire i0_ LIMIT 20 OFFSET 120

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT i0_.id AS id_0
FROM
  inventaire i0_
LIMIT
  20 OFFSET 120

SELECT DISTINCT i0_.id AS id_0 FROM inventaire i0_ LIMIT 20 OFFSET 120;

#	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.30 ms
(5.44%)

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:

[
  25
]

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

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

0.20 ms
(3.69%)

SELECT COUNT(i0_.id) AS sclr_0 FROM inventaire i0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(i0_.id) AS sclr_0
FROM
  inventaire i0_

SELECT COUNT(i0_.id) AS sclr_0 FROM inventaire i0_;

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

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=index&crudControllerFqcn=App%5CController%5CAdmin%5CInventaireCrudController&page=7

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping