Symfony Profiler

Query Metrics

194 Database Queries

3 Different statements

378.62 ms Query time

0 Invalid entities

305 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

310.23 ms
(81.94%)

112

SELECT t0.id AS id_1, t0.is_ombre AS is_ombre_2, t0.is_voiture AS is_voiture_3, t0.secteur AS secteur_4, t0.num AS num_5, t0.lat AS lat_6, t0.lng AS lng_7, t8.id AS id_9, t8.emplacement_id AS emplacement_id_10, t8.resa_id AS resa_id_11 FROM emplacement t0 LEFT JOIN lien_empl_resa t8 ON t8.emplacement_id = t0.id WHERE t0.id = ?

Parameters:

[
  128
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.is_ombre AS is_ombre_2,
  t0.is_voiture AS is_voiture_3,
  t0.secteur AS secteur_4,
  t0.num AS num_5,
  t0.lat AS lat_6,
  t0.lng AS lng_7,
  t8.id AS id_9,
  t8.emplacement_id AS emplacement_id_10,
  t8.resa_id AS resa_id_11
FROM
  emplacement t0
  LEFT JOIN lien_empl_resa t8 ON t8.emplacement_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.is_ombre AS is_ombre_2, t0.is_voiture AS is_voiture_3, t0.secteur AS secteur_4, t0.num AS num_5, t0.lat AS lat_6, t0.lng AS lng_7, t8.id AS id_9, t8.emplacement_id AS emplacement_id_10, t8.resa_id AS resa_id_11 FROM emplacement t0 LEFT JOIN lien_empl_resa t8 ON t8.emplacement_id = t0.id WHERE t0.id = 128;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\Emplacement::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Emplacement->__get (line 153)
7	App\Entity\Emplacement->getSecteur (line 68)
8	Twig\Extension\CoreExtension->getAttribute (line 1918)
9	__TwigTemplate_768cbe6130fe59ad3f9c4788ae6fb435::block_body (line 189)
10	Twig\Template->yieldBlock (line 456)
11	__TwigTemplate_6fb4da178eb818d146b83984f0f994be->doDisplay (line 133)
12	Twig\Template->yield (line 411)
13	__TwigTemplate_768cbe6130fe59ad3f9c4788ae6fb435->doDisplay (line 54)
14	Twig\Template->yield (line 411)
15	Twig\Template->display (line 366)
16	Twig\Template->render (line 381)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
22	App\Controller\PagesController->entree (line 449)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	require_once (line 5)

66.32 ms
(17.52%)

SELECT t0.id AS id_1, t0.emplacement_id AS emplacement_id_2, t0.resa_id AS resa_id_3 FROM lien_empl_resa t0 WHERE t0.resa_id = ?

Parameters:

[
  29
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.emplacement_id AS emplacement_id_2,
  t0.resa_id AS resa_id_3
FROM
  lien_empl_resa t0
WHERE
  t0.resa_id = ?

SELECT t0.id AS id_1, t0.emplacement_id AS emplacement_id_2, t0.resa_id AS resa_id_3 FROM lien_empl_resa t0 WHERE t0.resa_id = 29;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	__TwigTemplate_768cbe6130fe59ad3f9c4788ae6fb435->block_body (line 186)
8	Twig\Template->yieldBlock (line 456)
9	__TwigTemplate_6fb4da178eb818d146b83984f0f994be->doDisplay (line 133)
10	Twig\Template->yield (line 411)
11	__TwigTemplate_768cbe6130fe59ad3f9c4788ae6fb435->doDisplay (line 54)
12	Twig\Template->yield (line 411)
13	Twig\Template->display (line 366)
14	Twig\Template->render (line 381)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
20	App\Controller\PagesController->entree (line 449)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 193)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 32)
26	require_once (line 5)

2.08 ms
(0.55%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.pprenom AS pprenom_3, t0.resp_resa AS resp_resa_4, t0.date_resa AS date_resa_5, t0.tel AS tel_6, t0.email AS email_7, t0.nb_empl AS nb_empl_8, t0.tarif AS tarif_9, t0.rglt AS rglt_10, t0.mode_rglt AS mode_rglt_11, t0.notes AS notes_12, t0.date_naissance AS date_naissance_13, t0.lieu_naissance AS lieu_naissance_14, t0.adresse AS adresse_15, t0.cp AS cp_16, t0.ville AS ville_17, t0.num_cni AS num_cni_18, t0.date_cni AS date_cni_19, t0.deliv_cni AS deliv_cni_20, t0.is_pro AS is_pro_21, t0.siret AS siret_22, t0.photo_idtt_recto AS photo_idtt_recto_23, t0.photo_idtt_verso AS photo_idtt_verso_24, t0.is_ombre AS is_ombre_25, t0.is_voiture AS is_voiture_26, t0.is_fixe_emplacement AS is_fixe_emplacement_27, t0.nat_cni AS nat_cni_28, t0.etat_arrivee AS etat_arrivee_29 FROM reservations t0 ORDER BY t0.nom ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.pprenom AS pprenom_3,
  t0.resp_resa AS resp_resa_4,
  t0.date_resa AS date_resa_5,
  t0.tel AS tel_6,
  t0.email AS email_7,
  t0.nb_empl AS nb_empl_8,
  t0.tarif AS tarif_9,
  t0.rglt AS rglt_10,
  t0.mode_rglt AS mode_rglt_11,
  t0.notes AS notes_12,
  t0.date_naissance AS date_naissance_13,
  t0.lieu_naissance AS lieu_naissance_14,
  t0.adresse AS adresse_15,
  t0.cp AS cp_16,
  t0.ville AS ville_17,
  t0.num_cni AS num_cni_18,
  t0.date_cni AS date_cni_19,
  t0.deliv_cni AS deliv_cni_20,
  t0.is_pro AS is_pro_21,
  t0.siret AS siret_22,
  t0.photo_idtt_recto AS photo_idtt_recto_23,
  t0.photo_idtt_verso AS photo_idtt_verso_24,
  t0.is_ombre AS is_ombre_25,
  t0.is_voiture AS is_voiture_26,
  t0.is_fixe_emplacement AS is_fixe_emplacement_27,
  t0.nat_cni AS nat_cni_28,
  t0.etat_arrivee AS etat_arrivee_29
FROM
  reservations t0
ORDER BY
  t0.nom ASC

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.pprenom AS pprenom_3, t0.resp_resa AS resp_resa_4, t0.date_resa AS date_resa_5, t0.tel AS tel_6, t0.email AS email_7, t0.nb_empl AS nb_empl_8, t0.tarif AS tarif_9, t0.rglt AS rglt_10, t0.mode_rglt AS mode_rglt_11, t0.notes AS notes_12, t0.date_naissance AS date_naissance_13, t0.lieu_naissance AS lieu_naissance_14, t0.adresse AS adresse_15, t0.cp AS cp_16, t0.ville AS ville_17, t0.num_cni AS num_cni_18, t0.date_cni AS date_cni_19, t0.deliv_cni AS deliv_cni_20, t0.is_pro AS is_pro_21, t0.siret AS siret_22, t0.photo_idtt_recto AS photo_idtt_recto_23, t0.photo_idtt_verso AS photo_idtt_verso_24, t0.is_ombre AS is_ombre_25, t0.is_voiture AS is_voiture_26, t0.is_fixe_emplacement AS is_fixe_emplacement_27, t0.nat_cni AS nat_cni_28, t0.etat_arrivee AS etat_arrivee_29 FROM reservations t0 ORDER BY t0.nom ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Controller\PagesController->entree (line 394)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\LienEmplResa	112
App\Entity\Emplacement	112
App\Entity\Reservations	81

Entities Mapping

Class	Mapping errors
App\Entity\Reservations	No errors.
App\Entity\LienEmplResa	No errors.
App\Entity\Emplacement	No errors.

Symfony Profiler

GET https://projet-matthew.fr/entree

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping