Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

2.03 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.45 ms
(71.36%)

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)

0.58 ms
(28.64%)

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:

[
  "5332"
]

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 = '5332';

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

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=5332&page=8&sort%5Bdateupload%5D…

Configuration Settings

Theme