Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

1.08 ms Query time

0 Invalid entities

7 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.50 ms

SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.date_debut_disponibilite AS date_debut_disponibilite_3, t0.date_fin_disponibilite AS date_fin_disponibilite_4, t0.lieu_garage AS lieu_garage_5, t0.prix AS prix_6, t0.disponibilite AS disponibilite_7, t0.description AS description_8, t0.photos AS photos_9, t0.suspended_until AS suspended_until_10, t0.commission AS commission_11, t0.voiture_id AS voiture_id_12, t0.proprietaire_id AS proprietaire_id_13, t14.id AS id_15, t14.tarifs AS tarifs_16, t14.disponibilite AS disponibilite_17, t14.offre_id AS offre_id_18 FROM offre t0 LEFT JOIN livraison t14 ON t14.offre_id = t0.id WHERE t0.id = ?

Parameters:

[
  "10"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.date_creation AS date_creation_2,
  t0.date_debut_disponibilite AS date_debut_disponibilite_3,
  t0.date_fin_disponibilite AS date_fin_disponibilite_4,
  t0.lieu_garage AS lieu_garage_5,
  t0.prix AS prix_6,
  t0.disponibilite AS disponibilite_7,
  t0.description AS description_8,
  t0.photos AS photos_9,
  t0.suspended_until AS suspended_until_10,
  t0.commission AS commission_11,
  t0.voiture_id AS voiture_id_12,
  t0.proprietaire_id AS proprietaire_id_13,
  t14.id AS id_15,
  t14.tarifs AS tarifs_16,
  t14.disponibilite AS disponibilite_17,
  t14.offre_id AS offre_id_18
FROM
  offre t0
  LEFT JOIN livraison t14 ON t14.offre_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.date_debut_disponibilite AS date_debut_disponibilite_3, t0.date_fin_disponibilite AS date_fin_disponibilite_4, t0.lieu_garage AS lieu_garage_5, t0.prix AS prix_6, t0.disponibilite AS disponibilite_7, t0.description AS description_8, t0.photos AS photos_9, t0.suspended_until AS suspended_until_10, t0.commission AS commission_11, t0.voiture_id AS voiture_id_12, t0.proprietaire_id AS proprietaire_id_13, t14.id AS id_15, t14.tarifs AS tarifs_16, t14.disponibilite AS disponibilite_17, t14.offre_id AS offre_id_18 FROM offre t0 LEFT JOIN livraison t14 ON t14.offre_id = t0.id WHERE t0.id = '10';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 119)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
8	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 60)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
10	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
11	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 173)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

0.22 ms

SELECT t0.id AS id_1, t0.revenu_total AS revenu_total_2, t0.utilisateur_id AS utilisateur_id_3 FROM proprietaire t0 WHERE t0.id = ?

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.revenu_total AS revenu_total_2,
  t0.utilisateur_id AS utilisateur_id_3
FROM
  proprietaire t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.revenu_total AS revenu_total_2, t0.utilisateur_id AS utilisateur_id_3 FROM proprietaire t0 WHERE t0.id = 5;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Proprietaire::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\Proprietaire->__get (line 63)
8	App\Entity\Proprietaire->getUtilisateur (line 31)
9	App\Controller\ReservationController->reserver (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.20 ms

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.date_debut AS date_debut_3, t0.date_fin AS date_fin_4, t0.statut AS statut_5, t0.offre_id AS offre_id_6, t0.emprunteur_id AS emprunteur_id_7 FROM location t0 WHERE t0.offre_id = ?

Parameters:

[
  10
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.date_debut AS date_debut_3,
  t0.date_fin AS date_fin_4,
  t0.statut AS statut_5,
  t0.offre_id AS offre_id_6,
  t0.emprunteur_id AS emprunteur_id_7
FROM
  location t0
WHERE
  t0.offre_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.date_debut AS date_debut_3, t0.date_fin AS date_fin_4, t0.statut AS statut_5, t0.offre_id AS offre_id_6, t0.emprunteur_id AS emprunteur_id_7 FROM location t0 WHERE t0.offre_id = 10;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 36)
5	App\Controller\ReservationController->reserver (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.15 ms

SELECT t0.id AS id_1, t0.marque AS marque_2, t0.modele AS modele_3, t0.immatriculation AS immatriculation_4, t0.annee AS annee_5, t0.nombre_places AS nombre_places_6, t0.volume_coffre AS volume_coffre_7, t0.type_essence AS type_essence_8 FROM voiture t0 WHERE t0.id = ?

Parameters:

[
  10
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.marque AS marque_2,
  t0.modele AS modele_3,
  t0.immatriculation AS immatriculation_4,
  t0.annee AS annee_5,
  t0.nombre_places AS nombre_places_6,
  t0.volume_coffre AS volume_coffre_7,
  t0.type_essence AS type_essence_8
FROM
  voiture t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.marque AS marque_2, t0.modele AS modele_3, t0.immatriculation AS immatriculation_4, t0.annee AS annee_5, t0.nombre_places AS nombre_places_6, t0.volume_coffre AS volume_coffre_7, t0.type_essence AS type_essence_8 FROM voiture t0 WHERE t0.id = 10;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Voiture::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\Voiture->__get (line 49)
8	App\Entity\Voiture->getMarque (line 1882)
9	Twig\Extension\CoreExtension::getAttribute (line 240)
10	__TwigTemplate_a0b57b65cb5849a02b3fc767dcd5faf4->block_body (line 432)
11	Twig\Template->yieldBlock (line 55)
12	__TwigTemplate_a0b57b65cb5849a02b3fc767dcd5faf4->doDisplay (line 388)
13	Twig\Template->yield (line 344)
14	Twig\Template->display (line 359)
15	Twig\Template->render (line 51)
16	Twig\TemplateWrapper->render (line 334)
17	Twig\Environment->render (line 448)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 46)
21	App\Controller\ReservationController->reserver (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	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\Offre	1
App\Entity\Voiture	1
App\Entity\Proprietaire	1
App\Entity\Livraison	1
App\Entity\Utilisateur	1
App\Entity\Location	1
App\Entity\Emprunteur	1

Entities Mapping

Class	Mapping errors
App\Entity\Offre	No errors.
App\Entity\Voiture	No errors.
App\Entity\Proprietaire	No errors.
App\Entity\Livraison	No errors.
App\Entity\Avis	No errors.
App\Entity\Utilisateur	No errors.
App\Entity\Location	No errors.
App\Entity\Emprunteur	No errors.

Symfony Profiler

GET https://www.lespilotesconnectes.com/reservation/reserver/10

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping