Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

3.26 ms Query time

0 Invalid entities

3 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.77 ms

SELECT t0.id AS id_1, t0.identifiant_vn AS identifiant_vn_2, t0.numero_chassis AS numero_chassis_3, t0.modele AS modele_4, t0.titre AS titre_5, t0.prix_neuf AS prix_neuf_6, t0.prix_remise AS prix_remise_7, t0.kilometrage AS kilometrage_8, t0.motorisation AS motorisation_9, t0.cylindree AS cylindree_10, t0.date_immat AS date_immat_11, t0.immatriculation AS immatriculation_12, t0.boite_vitesse AS boite_vitesse_13, t0.garantie AS garantie_14, t0.carrosserie AS carrosserie_15, t0.poids_avide AS poids_avide_16, t0.transmission AS transmission_17, t0.emissions_co2 AS emissions_co2_18, t0.crit_air AS crit_air_19, t0.puissance_din AS puissance_din_20, t0.puissance_fiscale AS puissance_fiscale_21, t0.nb_places AS nb_places_22, t0.nb_portes AS nb_portes_23, t0.couleur_exterieure AS couleur_exterieure_24, t0.sellerie AS sellerie_25, t0.nb_jours_en_stock AS nb_jours_en_stock_26, t0.options_et_equipements AS options_et_equipements_27, t0.visuels AS visuels_28, t0.commentaire AS commentaire_29, t0.is_published AS is_published_30, t0.modifier_backend AS modifier_backend_31, t0.flux AS flux_32, t0.is_supprimed AS is_supprimed_33, t0.create_at AS create_at_34, t0.update_at AS update_at_35, t0.marque_id AS marque_id_36, t0.concession_id AS concession_id_37 FROM vehicule_neuf t0 WHERE t0.id = ?

Parameters:

[
  10521
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.identifiant_vn AS identifiant_vn_2,
  t0.numero_chassis AS numero_chassis_3,
  t0.modele AS modele_4,
  t0.titre AS titre_5,
  t0.prix_neuf AS prix_neuf_6,
  t0.prix_remise AS prix_remise_7,
  t0.kilometrage AS kilometrage_8,
  t0.motorisation AS motorisation_9,
  t0.cylindree AS cylindree_10,
  t0.date_immat AS date_immat_11,
  t0.immatriculation AS immatriculation_12,
  t0.boite_vitesse AS boite_vitesse_13,
  t0.garantie AS garantie_14,
  t0.carrosserie AS carrosserie_15,
  t0.poids_avide AS poids_avide_16,
  t0.transmission AS transmission_17,
  t0.emissions_co2 AS emissions_co2_18,
  t0.crit_air AS crit_air_19,
  t0.puissance_din AS puissance_din_20,
  t0.puissance_fiscale AS puissance_fiscale_21,
  t0.nb_places AS nb_places_22,
  t0.nb_portes AS nb_portes_23,
  t0.couleur_exterieure AS couleur_exterieure_24,
  t0.sellerie AS sellerie_25,
  t0.nb_jours_en_stock AS nb_jours_en_stock_26,
  t0.options_et_equipements AS options_et_equipements_27,
  t0.visuels AS visuels_28,
  t0.commentaire AS commentaire_29,
  t0.is_published AS is_published_30,
  t0.modifier_backend AS modifier_backend_31,
  t0.flux AS flux_32,
  t0.is_supprimed AS is_supprimed_33,
  t0.create_at AS create_at_34,
  t0.update_at AS update_at_35,
  t0.marque_id AS marque_id_36,
  t0.concession_id AS concession_id_37
FROM
  vehicule_neuf t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.identifiant_vn AS identifiant_vn_2, t0.numero_chassis AS numero_chassis_3, t0.modele AS modele_4, t0.titre AS titre_5, t0.prix_neuf AS prix_neuf_6, t0.prix_remise AS prix_remise_7, t0.kilometrage AS kilometrage_8, t0.motorisation AS motorisation_9, t0.cylindree AS cylindree_10, t0.date_immat AS date_immat_11, t0.immatriculation AS immatriculation_12, t0.boite_vitesse AS boite_vitesse_13, t0.garantie AS garantie_14, t0.carrosserie AS carrosserie_15, t0.poids_avide AS poids_avide_16, t0.transmission AS transmission_17, t0.emissions_co2 AS emissions_co2_18, t0.crit_air AS crit_air_19, t0.puissance_din AS puissance_din_20, t0.puissance_fiscale AS puissance_fiscale_21, t0.nb_places AS nb_places_22, t0.nb_portes AS nb_portes_23, t0.couleur_exterieure AS couleur_exterieure_24, t0.sellerie AS sellerie_25, t0.nb_jours_en_stock AS nb_jours_en_stock_26, t0.options_et_equipements AS options_et_equipements_27, t0.visuels AS visuels_28, t0.commentaire AS commentaire_29, t0.is_published AS is_published_30, t0.modifier_backend AS modifier_backend_31, t0.flux AS flux_32, t0.is_supprimed AS is_supprimed_33, t0.create_at AS create_at_34, t0.update_at AS update_at_35, t0.marque_id AS marque_id_36, t0.concession_id AS concession_id_37 FROM vehicule_neuf t0 WHERE t0.id = 10521;

#	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 24)
7	App\Controller\FO\VehiculeController->details (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

1.76 ms

SELECT COUNT(v0_.id) AS sclr_0 FROM vehicule_neuf v0_ WHERE v0_.is_published = ? AND v0_.concession_id = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(v0_.id) AS sclr_0
FROM
  vehicule_neuf v0_
WHERE
  v0_.is_published = ?
  AND v0_.concession_id = ?

SELECT COUNT(v0_.id) AS sclr_0 FROM vehicule_neuf v0_ WHERE v0_.is_published = 1 AND v0_.concession_id = 10;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 802)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 272)
8	App\Repository\VehiculeNeufRepository->countPublishedByConcession (line 103)
9	App\Controller\FO\VehiculeController->details (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.73 ms

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.adresse AS adresse_3, t0.telephone AS telephone_4 FROM concession t0 WHERE t0.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.adresse AS adresse_3,
  t0.telephone AS telephone_4
FROM
  concession t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.adresse AS adresse_3, t0.telephone AS telephone_4 FROM concession 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\Concession::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\Concession->__get (line 46)
8	App\Entity\Concession->getNom (line 106)
9	App\Controller\FO\VehiculeController->details (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)

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\VehiculeNeuf	1
App\Entity\Marque	1
App\Entity\Concession	1

Entities Mapping

Class	Mapping errors
App\Entity\VehiculeNeuf	No errors.
App\Entity\Marque	No errors.
App\Entity\Concession	No errors.
App\Entity\Utilisateur	No errors.

Symfony Profiler

GET http://vehicules-neufs.neubauer.fr/transit-2t-350-l2h2-trend-b-2-0td130-bva/10521

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping