Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

1.16 ms Query time

0 Invalid entities

6 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.40 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:

[
  "14"
]

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

#	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.23 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:

[
  14
]

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 = 14;

#	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 55)
10	__TwigTemplate_7b70e4cd3a6799190499c72e4e8b0062->doDisplay (line 388)
11	Twig\Template->yield (line 344)
12	Twig\Template->display (line 359)
13	Twig\Template->render (line 51)
14	Twig\TemplateWrapper->render (line 334)
15	Twig\Environment->render (line 448)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 25)
19	App\Controller\OffreController->detail (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.17 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:

[
  6
]

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 = 6;

#	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 1882)
9	Twig\Extension\CoreExtension::getAttribute (line 345)
10	__TwigTemplate_7b70e4cd3a6799190499c72e4e8b0062->doDisplay (line 388)
11	Twig\Template->yield (line 344)
12	Twig\Template->display (line 359)
13	Twig\Template->render (line 51)
14	Twig\TemplateWrapper->render (line 334)
15	Twig\Environment->render (line 448)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 25)
19	App\Controller\OffreController->detail (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.36 ms

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.telephone AS telephone_5, t0.adresse AS adresse_6, t0.password AS password_7, t0.roles AS roles_8, t0.is_verified AS is_verified_9, t0.confirmation_token AS confirmation_token_10, t0.profile_image AS profile_image_11, t0.suspended_until AS suspended_until_12, t13.id AS id_14, t13.revenu_total AS revenu_total_15, t13.utilisateur_id AS utilisateur_id_16, t17.id AS id_18, t17.nom AS nom_19, t17.numero_permis AS numero_permis_20, t17.date_expiration AS date_expiration_21, t17.utilisateur_id AS utilisateur_id_22, t23.id AS id_24, t23.password AS password_25, t23.nom AS nom_26, t23.prenom AS prenom_27, t23.email AS email_28, t23.role AS role_29, t23.commission_totale AS commission_totale_30, t23.utilisateur_id AS utilisateur_id_31 FROM utilisateur t0 LEFT JOIN proprietaire t13 ON t13.utilisateur_id = t0.id LEFT JOIN emprunteur t17 ON t17.utilisateur_id = t0.id LEFT JOIN administrateur t23 ON t23.utilisateur_id = t0.id WHERE t0.id = ?

Parameters:

[
  22
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenom AS prenom_3,
  t0.email AS email_4,
  t0.telephone AS telephone_5,
  t0.adresse AS adresse_6,
  t0.password AS password_7,
  t0.roles AS roles_8,
  t0.is_verified AS is_verified_9,
  t0.confirmation_token AS confirmation_token_10,
  t0.profile_image AS profile_image_11,
  t0.suspended_until AS suspended_until_12,
  t13.id AS id_14,
  t13.revenu_total AS revenu_total_15,
  t13.utilisateur_id AS utilisateur_id_16,
  t17.id AS id_18,
  t17.nom AS nom_19,
  t17.numero_permis AS numero_permis_20,
  t17.date_expiration AS date_expiration_21,
  t17.utilisateur_id AS utilisateur_id_22,
  t23.id AS id_24,
  t23.password AS password_25,
  t23.nom AS nom_26,
  t23.prenom AS prenom_27,
  t23.email AS email_28,
  t23.role AS role_29,
  t23.commission_totale AS commission_totale_30,
  t23.utilisateur_id AS utilisateur_id_31
FROM
  utilisateur t0
  LEFT JOIN proprietaire t13 ON t13.utilisateur_id = t0.id
  LEFT JOIN emprunteur t17 ON t17.utilisateur_id = t0.id
  LEFT JOIN administrateur t23 ON t23.utilisateur_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.telephone AS telephone_5, t0.adresse AS adresse_6, t0.password AS password_7, t0.roles AS roles_8, t0.is_verified AS is_verified_9, t0.confirmation_token AS confirmation_token_10, t0.profile_image AS profile_image_11, t0.suspended_until AS suspended_until_12, t13.id AS id_14, t13.revenu_total AS revenu_total_15, t13.utilisateur_id AS utilisateur_id_16, t17.id AS id_18, t17.nom AS nom_19, t17.numero_permis AS numero_permis_20, t17.date_expiration AS date_expiration_21, t17.utilisateur_id AS utilisateur_id_22, t23.id AS id_24, t23.password AS password_25, t23.nom AS nom_26, t23.prenom AS prenom_27, t23.email AS email_28, t23.role AS role_29, t23.commission_totale AS commission_totale_30, t23.utilisateur_id AS utilisateur_id_31 FROM utilisateur t0 LEFT JOIN proprietaire t13 ON t13.utilisateur_id = t0.id LEFT JOIN emprunteur t17 ON t17.utilisateur_id = t0.id LEFT JOIN administrateur t23 ON t23.utilisateur_id = t0.id WHERE t0.id = 22;

#	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\Utilisateur::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\Utilisateur->__get (line 136)
8	App\Entity\Utilisateur->getProfileImage (line 1882)
9	Twig\Extension\CoreExtension::getAttribute (line 345)
10	__TwigTemplate_7b70e4cd3a6799190499c72e4e8b0062->doDisplay (line 388)
11	Twig\Template->yield (line 344)
12	Twig\Template->display (line 359)
13	Twig\Template->render (line 51)
14	Twig\TemplateWrapper->render (line 334)
15	Twig\Environment->render (line 448)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 25)
19	App\Controller\OffreController->detail (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	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\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\Emprunteur	No errors.
App\Entity\Administrateur	No errors.

Symfony Profiler

GET https://lespilotesconnectes.com/offre/14/details

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping