Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

1.38 ms Query time

2 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.54 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.id = ?

Parameters:

[
  "1299"
]

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.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.id = '1299';

#	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.53 ms

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:

[
  31
]

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 = 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\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 217)
13	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->edit (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)

0.32 ms

SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.taille AS taille_2, c0_.barrierages AS barrierages_3, c0_.marquageausol AS marquageausol_4, c0_.tonnelle AS tonnelle_5, c0_.signaletiques AS signaletiques_6, c0_.supportsachs AS supportsachs_7, c0_.balances AS balances_8, c0_.compacteur AS compacteur_9, c0_.tabledetri AS tabledetri_10, c0_.vidoirliquide AS vidoirliquide_11, c0_.troussedesecours AS troussedesecours_12, c0_.epi AS epi_13, c0_.materielsdenettoyage AS materielsdenettoyage_14, c0_.phase AS phase_15, c0_.bacdr660 AS bacdr660_16, c0_.bacdr240 AS bacdr240_17, c0_.bacrecycle240 AS bacrecycle240_18, c0_.bacrecycle660 AS bacrecycle660_19, c0_.bacbiodechet120 AS bacbiodechet120_20, c0_.bennebois AS bennebois_21, c0_.bennecarton AS bennecarton_22, c0_.benneplastiques AS benneplastiques_23, c0_.bachenoires AS bachenoires_24, c0_.site_id AS site_id_25 FROM centredetri c0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.nom AS nom_1,
  c0_.taille AS taille_2,
  c0_.barrierages AS barrierages_3,
  c0_.marquageausol AS marquageausol_4,
  c0_.tonnelle AS tonnelle_5,
  c0_.signaletiques AS signaletiques_6,
  c0_.supportsachs AS supportsachs_7,
  c0_.balances AS balances_8,
  c0_.compacteur AS compacteur_9,
  c0_.tabledetri AS tabledetri_10,
  c0_.vidoirliquide AS vidoirliquide_11,
  c0_.troussedesecours AS troussedesecours_12,
  c0_.epi AS epi_13,
  c0_.materielsdenettoyage AS materielsdenettoyage_14,
  c0_.phase AS phase_15,
  c0_.bacdr660 AS bacdr660_16,
  c0_.bacdr240 AS bacdr240_17,
  c0_.bacrecycle240 AS bacrecycle240_18,
  c0_.bacrecycle660 AS bacrecycle660_19,
  c0_.bacbiodechet120 AS bacbiodechet120_20,
  c0_.bennebois AS bennebois_21,
  c0_.bennecarton AS bennecarton_22,
  c0_.benneplastiques AS benneplastiques_23,
  c0_.bachenoires AS bachenoires_24,
  c0_.site_id AS site_id_25
FROM
  centredetri c0_

SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.taille AS taille_2, c0_.barrierages AS barrierages_3, c0_.marquageausol AS marquageausol_4, c0_.tonnelle AS tonnelle_5, c0_.signaletiques AS signaletiques_6, c0_.supportsachs AS supportsachs_7, c0_.balances AS balances_8, c0_.compacteur AS compacteur_9, c0_.tabledetri AS tabledetri_10, c0_.vidoirliquide AS vidoirliquide_11, c0_.troussedesecours AS troussedesecours_12, c0_.epi AS epi_13, c0_.materielsdenettoyage AS materielsdenettoyage_14, c0_.phase AS phase_15, c0_.bacdr660 AS bacdr660_16, c0_.bacdr240 AS bacdr240_17, c0_.bacrecycle240 AS bacrecycle240_18, c0_.bacrecycle660 AS bacrecycle660_19, c0_.bacbiodechet120 AS bacbiodechet120_20, c0_.bennebois AS bennebois_21, c0_.bennecarton AS bennecarton_22, c0_.benneplastiques AS benneplastiques_23, c0_.bachenoires AS bachenoires_24, c0_.site_id AS site_id_25 FROM centredetri c0_;

#	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 35)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 53)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 29)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 56)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 204)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 453)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 232)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 110)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 81)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 108)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 81)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 896)
19	Symfony\Component\Form\Form->createView (line 899)
20	Symfony\Component\Form\Form->createView (line 47)
21	EasyCorp\Bundle\EasyAdminBundle\EventListener\CrudResponseListener->onKernelView (line 116)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	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.

Symfony Profiler

GET https://bereup.online/admin?crudAction=edit&crudControllerFqcn=App%5CController%5CAdmin%5CPhotosarchivesCrudController&entityId=1299&page=115&sort%5Bsuivis%5D=D…

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping