Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

1.56 ms Query time

2 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.76 ms

SELECT t0.id AS id_1, t0.login AS login_2, t0.roles AS roles_3, t0.password AS password_4, t0.prenom AS prenom_5, t0.nom AS nom_6, t0.datedenaissance AS datedenaissance_7, t0.lieudenaissance AS lieudenaissance_8, t0.adresse AS adresse_9, t0.contact AS contact_10, t0.rib AS rib_11, t0.siret AS siret_12, t0.securitesociale AS securitesociale_13, t0.email AS email_14, t0.contacturgence AS contacturgence_15, t0.contacturgencetel AS contacturgencetel_16, t0.photo AS photo_17, t0.permis AS permis_18, t0.autres AS autres_19, t20.id AS id_21, t20.nom_structure AS nom_structure_22, t20.type_structure AS type_structure_23, t20.types_projet AS types_projet_24, t20.volume_vehicule AS volume_vehicule_25, t20.manutention AS manutention_26, t20.adresse AS adresse_27, t20.nom_contact AS nom_contact_28, t20.email_contact AS email_contact_29, t20.telephone_contact AS telephone_contact_30, t20.site_web AS site_web_31, t20.linkedin AS linkedin_32, t20.ressources AS ressources_33, t20.details AS details_34, t20.validation AS validation_35, t20.user_id AS user_id_36, t37.id AS id_38, t37.quantites AS quantites_39, t37.proprietaire_id AS proprietaire_id_40 FROM `user` t0 LEFT JOIN filiere t20 ON t20.user_id = t0.id LEFT JOIN panier t37 ON t37.proprietaire_id = t0.id WHERE t0.id = ?

Parameters:

[
  12
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.login AS login_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.prenom AS prenom_5,
  t0.nom AS nom_6,
  t0.datedenaissance AS datedenaissance_7,
  t0.lieudenaissance AS lieudenaissance_8,
  t0.adresse AS adresse_9,
  t0.contact AS contact_10,
  t0.rib AS rib_11,
  t0.siret AS siret_12,
  t0.securitesociale AS securitesociale_13,
  t0.email AS email_14,
  t0.contacturgence AS contacturgence_15,
  t0.contacturgencetel AS contacturgencetel_16,
  t0.photo AS photo_17,
  t0.permis AS permis_18,
  t0.autres AS autres_19,
  t20.id AS id_21,
  t20.nom_structure AS nom_structure_22,
  t20.type_structure AS type_structure_23,
  t20.types_projet AS types_projet_24,
  t20.volume_vehicule AS volume_vehicule_25,
  t20.manutention AS manutention_26,
  t20.adresse AS adresse_27,
  t20.nom_contact AS nom_contact_28,
  t20.email_contact AS email_contact_29,
  t20.telephone_contact AS telephone_contact_30,
  t20.site_web AS site_web_31,
  t20.linkedin AS linkedin_32,
  t20.ressources AS ressources_33,
  t20.details AS details_34,
  t20.validation AS validation_35,
  t20.user_id AS user_id_36,
  t37.id AS id_38,
  t37.quantites AS quantites_39,
  t37.proprietaire_id AS proprietaire_id_40
FROM
  `user` t0
  LEFT JOIN filiere t20 ON t20.user_id = t0.id
  LEFT JOIN panier t37 ON t37.proprietaire_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.login AS login_2, t0.roles AS roles_3, t0.password AS password_4, t0.prenom AS prenom_5, t0.nom AS nom_6, t0.datedenaissance AS datedenaissance_7, t0.lieudenaissance AS lieudenaissance_8, t0.adresse AS adresse_9, t0.contact AS contact_10, t0.rib AS rib_11, t0.siret AS siret_12, t0.securitesociale AS securitesociale_13, t0.email AS email_14, t0.contacturgence AS contacturgence_15, t0.contacturgencetel AS contacturgencetel_16, t0.photo AS photo_17, t0.permis AS permis_18, t0.autres AS autres_19, t20.id AS id_21, t20.nom_structure AS nom_structure_22, t20.type_structure AS type_structure_23, t20.types_projet AS types_projet_24, t20.volume_vehicule AS volume_vehicule_25, t20.manutention AS manutention_26, t20.adresse AS adresse_27, t20.nom_contact AS nom_contact_28, t20.email_contact AS email_contact_29, t20.telephone_contact AS telephone_contact_30, t20.site_web AS site_web_31, t20.linkedin AS linkedin_32, t20.ressources AS ressources_33, t20.details AS details_34, t20.validation AS validation_35, t20.user_id AS user_id_36, t37.id AS id_38, t37.quantites AS quantites_39, t37.proprietaire_id AS proprietaire_id_40 FROM `user` t0 LEFT JOIN filiere t20 ON t20.user_id = t0.id LEFT JOIN panier t37 ON t37.proprietaire_id = t0.id WHERE t0.id = 12;

#	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 92)
7	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 207)
8	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 127)
9	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 73)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->Symfony\Bundle\SecurityBundle\Security\{closure} (line 34)
12	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage->getToken (line 44)
13	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 228)
14	EasyCorp\Bundle\EasyAdminBundle\Factory\AdminContextFactory->getUser (line 66)
15	EasyCorp\Bundle\EasyAdminBundle\Factory\AdminContextFactory->create (line 78)
16	EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber->onKernelRequest (line 116)
17	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
18	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
19	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
20	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 154)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 5)

0.43 ms

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM site t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2
FROM
  site t0

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM site t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 306)
6	App\Controller\AccueilController->inventaire (line 178)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.37 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

Parameters:

[]

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

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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 307)
6	App\Controller\AccueilController->inventaire (line 178)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	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\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\Filiere	No errors.
App\Entity\Panier	No errors.
App\Entity\Suivi	No errors.
App\Entity\Inventaire	No errors.
App\Entity\Site	No errors.
App\Entity\Hall	No errors.
App\Entity\Client	No errors.
App\Entity\Evenement	No errors.
App\Entity\Centredetri	No errors.
App\Entity\Suivijournalierstand	No errors.
App\Entity\Photosarchives	No errors.
App\Entity\Commentaire	No errors.
App\Entity\Donation	No errors.
App\Entity\Documents	No errors.
App\Entity\InfosStand	No 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\InventaireCatalogue	No errors.
App\Entity\FicheDeco	No errors.

Symfony Profiler

GET https://bereup.online/admin?routeName=app_show_inventaire

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping