GET https://lespilotesconnectes.com/

Query Metrics

7 Database Queries
3 Different statements
1.73 ms Query time
0 Invalid entities
17 Managed entities

Queries

Group similar statements

# Time Info
1 0.51 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
Parameters:
[]
2 0.43 ms
SELECT DISTINCT v0_.marque AS marque_0, v0_.modele AS modele_1 FROM offre o1_ LEFT JOIN voiture v0_ ON o1_.voiture_id = v0_.id
Parameters:
[]
3 0.24 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
]
4 0.16 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:
[
  11
]
5 0.12 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:
[
  12
]
6 0.14 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:
[
  13
]
7 0.12 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
]

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 5
App\Entity\Voiture 5
App\Entity\Livraison 5
App\Entity\Proprietaire 2

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.