GET https://vincent-gg.fr/Annonces_VO

Query Metrics

22 Database Queries
4 Different statements
28.91 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 5.03 ms
SELECT t0.id AS id_1, t0.km AS km_2, t0.garantie AS garantie_3, t0.prix AS prix_4, t0.fiscale AS fiscale_5, t0.description AS description_6, t0.etat AS etat_7, t0.premiereimmatriculation AS premiereimmatriculation_8, t0.bv AS bv_9, t0.ordre AS ordre_10, t0.modele_id AS modele_id_11 FROM annonces t0 ORDER BY t0.ordre ASC
Parameters:
[]
2 3.82 ms
SELECT t0.id AS id_1, t0.nomimg AS nomimg_2, t0.ordre AS ordre_3, t0.annonces_id AS annonces_id_4 FROM photos t0 WHERE t0.annonces_id = ? ORDER BY t0.ordre ASC LIMIT 1
Parameters:
[
  8
]
3 0.81 ms
SELECT t0.id AS id_1, t0.nomimg AS nomimg_2, t0.ordre AS ordre_3, t0.annonces_id AS annonces_id_4 FROM photos t0 WHERE t0.annonces_id = ? ORDER BY t0.ordre ASC LIMIT 1
Parameters:
[
  9
]
4 0.68 ms
SELECT t0.id AS id_1, t0.nomimg AS nomimg_2, t0.ordre AS ordre_3, t0.annonces_id AS annonces_id_4 FROM photos t0 WHERE t0.annonces_id = ? ORDER BY t0.ordre ASC LIMIT 1
Parameters:
[
  10
]
5 0.66 ms
SELECT t0.id AS id_1, t0.nomimg AS nomimg_2, t0.ordre AS ordre_3, t0.annonces_id AS annonces_id_4 FROM photos t0 WHERE t0.annonces_id = ? ORDER BY t0.ordre ASC LIMIT 1
Parameters:
[
  12
]
6 0.65 ms
SELECT t0.id AS id_1, t0.nomimg AS nomimg_2, t0.ordre AS ordre_3, t0.annonces_id AS annonces_id_4 FROM photos t0 WHERE t0.annonces_id = ? ORDER BY t0.ordre ASC LIMIT 1
Parameters:
[
  13
]
7 0.51 ms
SELECT t0.id AS id_1, t0.nomimg AS nomimg_2, t0.ordre AS ordre_3, t0.annonces_id AS annonces_id_4 FROM photos t0 WHERE t0.annonces_id = ? ORDER BY t0.ordre ASC LIMIT 1
Parameters:
[
  11
]
8 0.50 ms
SELECT t0.id AS id_1, t0.nomimg AS nomimg_2, t0.ordre AS ordre_3, t0.annonces_id AS annonces_id_4 FROM photos t0 WHERE t0.annonces_id = ? ORDER BY t0.ordre ASC LIMIT 1
Parameters:
[
  17
]
9 3.30 ms
SELECT t0.id AS id_1, t0.modele AS modele_2, t0.moteur AS moteur_3, t0.puissance AS puissance_4, t0.carburant AS carburant_5, t0.marque_id AS marque_id_6 FROM modele t0 WHERE t0.id = ?
Parameters:
[
  7
]
10 2.94 ms
SELECT t0.id AS id_1, t0.marque AS marque_2 FROM marque t0 WHERE t0.id = ?
Parameters:
[
  7
]
11 1.33 ms
SELECT t0.id AS id_1, t0.modele AS modele_2, t0.moteur AS moteur_3, t0.puissance AS puissance_4, t0.carburant AS carburant_5, t0.marque_id AS marque_id_6 FROM modele t0 WHERE t0.id = ?
Parameters:
[
  8
]
12 0.79 ms
SELECT t0.id AS id_1, t0.marque AS marque_2 FROM marque t0 WHERE t0.id = ?
Parameters:
[
  1
]
13 0.80 ms
SELECT t0.id AS id_1, t0.modele AS modele_2, t0.moteur AS moteur_3, t0.puissance AS puissance_4, t0.carburant AS carburant_5, t0.marque_id AS marque_id_6 FROM modele t0 WHERE t0.id = ?
Parameters:
[
  9
]
14 0.72 ms
SELECT t0.id AS id_1, t0.marque AS marque_2 FROM marque t0 WHERE t0.id = ?
Parameters:
[
  3
]
15 0.83 ms
SELECT t0.id AS id_1, t0.modele AS modele_2, t0.moteur AS moteur_3, t0.puissance AS puissance_4, t0.carburant AS carburant_5, t0.marque_id AS marque_id_6 FROM modele t0 WHERE t0.id = ?
Parameters:
[
  11
]
16 0.78 ms
SELECT t0.id AS id_1, t0.marque AS marque_2 FROM marque t0 WHERE t0.id = ?
Parameters:
[
  29
]
17 0.76 ms
SELECT t0.id AS id_1, t0.modele AS modele_2, t0.moteur AS moteur_3, t0.puissance AS puissance_4, t0.carburant AS carburant_5, t0.marque_id AS marque_id_6 FROM modele t0 WHERE t0.id = ?
Parameters:
[
  12
]
18 0.65 ms
SELECT t0.id AS id_1, t0.marque AS marque_2 FROM marque t0 WHERE t0.id = ?
Parameters:
[
  30
]
19 0.73 ms
SELECT t0.id AS id_1, t0.modele AS modele_2, t0.moteur AS moteur_3, t0.puissance AS puissance_4, t0.carburant AS carburant_5, t0.marque_id AS marque_id_6 FROM modele t0 WHERE t0.id = ?
Parameters:
[
  10
]
20 0.74 ms
SELECT t0.id AS id_1, t0.marque AS marque_2 FROM marque t0 WHERE t0.id = ?
Parameters:
[
  27
]
21 0.91 ms
SELECT t0.id AS id_1, t0.modele AS modele_2, t0.moteur AS moteur_3, t0.puissance AS puissance_4, t0.carburant AS carburant_5, t0.marque_id AS marque_id_6 FROM modele t0 WHERE t0.id = ?
Parameters:
[
  13
]
22 0.96 ms
SELECT t0.id AS id_1, t0.marque AS marque_2 FROM marque t0 WHERE t0.id = ?
Parameters:
[
  28
]

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.

Entities Mapping

Class Mapping errors
App\Entity\Annonces No errors.
App\Entity\Modele No errors.
App\Entity\Photos No errors.
App\Entity\Messages No errors.
App\Entity\Marque No errors.