https://lebiodelo.com/catalogue

Query Metrics

49 Database Queries
2 Different statements
28.35 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.94 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ref AS ref_3, t0.matiere AS matiere_4, t0.couleur AS couleur_5, t0.taille AS taille_6, t0.motif AS motif_7, t0.prix_pub_ttc AS prix_pub_ttc_8, t0.prix_rev_ht AS prix_rev_ht_9, t0.description AS description_10, t0.showcase AS showcase_11, t0.entretien AS entretien_12, t0.position AS position_13, t0.categorie_id AS categorie_id_14 FROM produit t0 ORDER BY t0.position ASC
Parameters:
[]
2 0.98 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.nom AS nom_3, t0.produit_id AS produit_id_4 FROM photo_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  163
]
3 0.63 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.nom AS nom_3, t0.produit_id AS produit_id_4 FROM photo_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  164
]
4 0.51 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.nom AS nom_3, t0.produit_id AS produit_id_4 FROM photo_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  166
]
5 0.47 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.nom AS nom_3, t0.produit_id AS produit_id_4 FROM photo_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  165
]
6 0.53 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.nom AS nom_3, t0.produit_id AS produit_id_4 FROM photo_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  168
]
7 0.57 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.nom AS nom_3, t0.produit_id AS produit_id_4 FROM photo_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  171
]
8 0.53 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.nom AS nom_3, t0.produit_id AS produit_id_4 FROM photo_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  169
]
9 0.54 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.nom AS nom_3, t0.produit_id AS produit_id_4 FROM photo_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  172
]
10 0.49 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.nom AS nom_3, t0.produit_id AS produit_id_4 FROM photo_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  173
]
11 0.54 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.nom AS nom_3, t0.produit_id AS produit_id_4 FROM photo_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  149
]
12 0.55 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.nom AS nom_3, t0.produit_id AS produit_id_4 FROM photo_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  150
]
13 0.48 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.nom AS nom_3, t0.produit_id AS produit_id_4 FROM photo_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  151
]
14 0.73 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.nom AS nom_3, t0.produit_id AS produit_id_4 FROM photo_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  152
]
15 0.61 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.nom AS nom_3, t0.produit_id AS produit_id_4 FROM photo_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  153
]
16 0.54 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.nom AS nom_3, t0.produit_id AS produit_id_4 FROM photo_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  154
]
17 0.56 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.nom AS nom_3, t0.produit_id AS produit_id_4 FROM photo_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  155
]
18 0.58 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.nom AS nom_3, t0.produit_id AS produit_id_4 FROM photo_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  156
]
19 0.58 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.nom AS nom_3, t0.produit_id AS produit_id_4 FROM photo_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  157
]
20 0.60 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.nom AS nom_3, t0.produit_id AS produit_id_4 FROM photo_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  158
]
21 0.54 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.nom AS nom_3, t0.produit_id AS produit_id_4 FROM photo_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  159
]
22 0.53 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.nom AS nom_3, t0.produit_id AS produit_id_4 FROM photo_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  160
]
23 0.49 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.nom AS nom_3, t0.produit_id AS produit_id_4 FROM photo_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  161
]
24 0.48 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.nom AS nom_3, t0.produit_id AS produit_id_4 FROM photo_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  162
]
25 0.51 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.nom AS nom_3, t0.produit_id AS produit_id_4 FROM photo_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  118
]
26 0.70 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.nom AS nom_3, t0.produit_id AS produit_id_4 FROM photo_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  119
]
27 0.55 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.nom AS nom_3, t0.produit_id AS produit_id_4 FROM photo_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  120
]
28 0.55 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.nom AS nom_3, t0.produit_id AS produit_id_4 FROM photo_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  121
]
29 0.53 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.nom AS nom_3, t0.produit_id AS produit_id_4 FROM photo_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  124
]
30 0.51 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.nom AS nom_3, t0.produit_id AS produit_id_4 FROM photo_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  129
]
31 0.58 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.nom AS nom_3, t0.produit_id AS produit_id_4 FROM photo_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  130
]
32 0.57 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.nom AS nom_3, t0.produit_id AS produit_id_4 FROM photo_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  131
]
33 0.64 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.nom AS nom_3, t0.produit_id AS produit_id_4 FROM photo_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  132
]
34 0.58 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.nom AS nom_3, t0.produit_id AS produit_id_4 FROM photo_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  133
]
35 0.58 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.nom AS nom_3, t0.produit_id AS produit_id_4 FROM photo_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  134
]
36 0.47 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.nom AS nom_3, t0.produit_id AS produit_id_4 FROM photo_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  135
]
37 0.50 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.nom AS nom_3, t0.produit_id AS produit_id_4 FROM photo_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  136
]
38 0.48 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.nom AS nom_3, t0.produit_id AS produit_id_4 FROM photo_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  137
]
39 0.54 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.nom AS nom_3, t0.produit_id AS produit_id_4 FROM photo_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  138
]
40 0.52 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.nom AS nom_3, t0.produit_id AS produit_id_4 FROM photo_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  139
]
41 0.47 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.nom AS nom_3, t0.produit_id AS produit_id_4 FROM photo_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  140
]
42 0.54 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.nom AS nom_3, t0.produit_id AS produit_id_4 FROM photo_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  141
]
43 0.44 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.nom AS nom_3, t0.produit_id AS produit_id_4 FROM photo_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  142
]
44 0.48 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.nom AS nom_3, t0.produit_id AS produit_id_4 FROM photo_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  143
]
45 0.48 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.nom AS nom_3, t0.produit_id AS produit_id_4 FROM photo_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  144
]
46 0.44 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.nom AS nom_3, t0.produit_id AS produit_id_4 FROM photo_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  145
]
47 0.54 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.nom AS nom_3, t0.produit_id AS produit_id_4 FROM photo_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  146
]
48 0.56 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.nom AS nom_3, t0.produit_id AS produit_id_4 FROM photo_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  147
]
49 0.61 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.nom AS nom_3, t0.produit_id AS produit_id_4 FROM photo_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  148
]

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\Produit No errors.
App\Entity\Categorie No errors.
App\Entity\PhotoProduit No errors.
App\Entity\LigneCommande No errors.