Query Metrics
7
Database Queries
7
Different statements
6.52 ms
Query time
2
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
2.55 ms (0.00%) |
1 |
SELECT p.id, p.nom, p.slug, p.description, p.prix_unitaire, p.prix_kg_l, p.poids, c.nom as nom_categorie FROM produit p JOIN categorie c ON c.id = p.categorie_id WHERE p.display = true AND c.id = :categorie AND p.id != :id ORDER BY RAND() LIMIT 6
Parameters:
[ "categorie" => 1 "id" => 37 ] |
1.27 ms (0.00%) |
1 |
SELECT t0.date_creation AS date_creation_1, t0.date_maj AS date_maj_2, t0.id AS id_3, t0.nom AS nom_4, t0.slug AS slug_5, t0.description AS description_6, t0.prix_unitaire AS prix_unitaire_7, t0.prix_kg_l AS prix_kg_l_8, t0.poids AS poids_9, t0.display AS display_10, t0.is_poids AS is_poids_11, t0.photo AS photo_12, t0.unite_mesure AS unite_mesure_13, t0.nb_personne AS nb_personne_14, t0.categorie_id AS categorie_id_15, t0.type_id AS type_id_16, t0.origine_id AS origine_id_17, t0.lait_id AS lait_id_18, t0.lait_traitement_id AS lait_traitement_id_19, t0.theme_id AS theme_id_20 FROM produit t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"cancoillotte-a-lail-rose"
]
|
0.81 ms (0.00%) |
1 |
SELECT t0.date_creation AS date_creation_1, t0.date_maj AS date_maj_2, t0.id AS id_3, t0.nom AS nom_4, t0.slug AS slug_5, t0.description AS description_6, t0.prix_unitaire AS prix_unitaire_7, t0.prix_kg_l AS prix_kg_l_8, t0.poids AS poids_9, t0.display AS display_10, t0.is_poids AS is_poids_11, t0.photo AS photo_12, t0.unite_mesure AS unite_mesure_13, t0.nb_personne AS nb_personne_14, t0.categorie_id AS categorie_id_15, t0.type_id AS type_id_16, t0.origine_id AS origine_id_17, t0.lait_id AS lait_id_18, t0.lait_traitement_id AS lait_traitement_id_19, t0.theme_id AS theme_id_20 FROM produit t0
Parameters:
[] |
0.56 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.display AS display_3 FROM lait t0 WHERE t0.id = ?
Parameters:
[
2
]
|
0.49 ms (0.00%) |
1 |
SELECT t0.date_creation AS date_creation_1, t0.date_maj AS date_maj_2, t0.id AS id_3, t0.nom AS nom_4, t0.slug AS slug_5, t0.description AS description_6, t0.prix_unitaire AS prix_unitaire_7, t0.prix_kg_l AS prix_kg_l_8, t0.poids AS poids_9, t0.display AS display_10, t0.is_poids AS is_poids_11, t0.photo AS photo_12, t0.unite_mesure AS unite_mesure_13, t0.nb_personne AS nb_personne_14, t0.categorie_id AS categorie_id_15, t0.type_id AS type_id_16, t0.origine_id AS origine_id_17, t0.lait_id AS lait_id_18, t0.lait_traitement_id AS lait_traitement_id_19, t0.theme_id AS theme_id_20 FROM produit t0 WHERE t0.id IN (?)
Parameters:
[ [ "19" "107" "102" "133" "49" "108" ] ] |
0.49 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.active AS active_2, t0.content AS content_3 FROM drive t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
0.34 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.display AS display_3 FROM lait_traitement t0 WHERE t0.id = ?
Parameters:
[
3
]
|
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\Historisation | No errors. |
App\Entity\Produit |
|
App\Entity\Categorie | No errors. |
App\Entity\Type |
|
App\Entity\Origine | No errors. |
App\Entity\Lait | No errors. |
App\Entity\LaitTraitement | No errors. |
App\Entity\ThemePlateau | No errors. |
App\Entity\PanierProduits | No errors. |
App\Entity\Drive | No errors. |