Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

0.71 ms Query time

3 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.37 ms
(52.39%)

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.suivi_photo_id = ?

Parameters:

[
  24
]

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.suivi_photo_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.suivi_photo_id = 24;

#	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 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 181)
8	__TwigTemplate_cec15c69a233eec03c7d5d1ecc265567->block_main (line 430)
9	Twig\Template->yieldBlock (line 1644)
10	__TwigTemplate_ed29b9f9269c7cc28ca1a5168c6e783d->block_content (line 430)
11	Twig\Template->yieldBlock (line 979)
12	__TwigTemplate_ed29b9f9269c7cc28ca1a5168c6e783d->block_wrapper (line 430)
13	Twig\Template->yieldBlock (line 795)
14	__TwigTemplate_ed29b9f9269c7cc28ca1a5168c6e783d->block_wrapper_wrapper (line 430)
15	Twig\Template->yieldBlock (line 460)
16	__TwigTemplate_ed29b9f9269c7cc28ca1a5168c6e783d->block_body (line 430)
17	Twig\Template->yieldBlock (line 160)
18	__TwigTemplate_ed29b9f9269c7cc28ca1a5168c6e783d->doDisplay (line 360)
19	Twig\Template->yield (line 55)
20	__TwigTemplate_caf72acbe75451d58d313d06c4031aca->doDisplay (line 360)
21	Twig\Template->yield (line 50)
22	__TwigTemplate_cec15c69a233eec03c7d5d1ecc265567->doDisplay (line 360)
23	Twig\Template->yield (line 335)
24	Twig\Template->render (line 38)
25	Twig\TemplateWrapper->render (line 307)
26	Twig\Environment->render (line 431)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 114)
30	App\Controller\Admin\SuiviPhotoCrudController->modifierSuivi (line 178)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
33	Symfony\Component\HttpKernel\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	require_once (line 5)

0.34 ms
(47.61%)

SELECT t0.id AS id_1, t0.type_localisation AS type_localisation_2, t0.localisation AS localisation_3, t0.commentaire AS commentaire_4, t0.date_creation AS date_creation_5, t0.evenement_id AS evenement_id_6, t0.created_by_id AS created_by_id_7 FROM suivi_photo t0 WHERE t0.id = ?

Parameters:

[
  "24"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.type_localisation AS type_localisation_2,
  t0.localisation AS localisation_3,
  t0.commentaire AS commentaire_4,
  t0.date_creation AS date_creation_5,
  t0.evenement_id AS evenement_id_6,
  t0.created_by_id AS created_by_id_7
FROM
  suivi_photo t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type_localisation AS type_localisation_2, t0.localisation AS localisation_3, t0.commentaire AS commentaire_4, t0.date_creation AS date_creation_5, t0.evenement_id AS evenement_id_6, t0.created_by_id AS created_by_id_7 FROM suivi_photo t0 WHERE t0.id = '24';

#	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\SuiviPhoto	The association App\Entity\SuiviPhoto#createdBy refers to the inverse side field App\Entity\User#suiviPhotos which does not exist.
App\Entity\Evenement	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\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\Suivi	No errors.
App\Entity\Commentaire	No errors.
App\Entity\Suivicentredetri	No errors.

Symfony Profiler

GET https://bereup.online/admin?crudAction=modifierSuivi&crudControllerFqcn=App%5CController%5CAdmin%5CSuiviPhotoCrudController&entityId=24

Configuration Settings

Theme