Query Metrics
7
Database Queries
7
Different statements
3.98 ms
Query time
2
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.46 ms |
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:
[
"beurre-1-2-sel-fermier-a-la-coupe"
]
|
2 | 1.32 ms |
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" => 2 "id" => 1 ] |
3 | 0.43 ms |
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:
[ [ "137" "139" "144" "14" "142" "4" ] ] |
4 | 0.89 ms |
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:
[] |
5 | 0.33 ms |
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
]
|
6 | 0.35 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.display AS display_3 FROM lait t0 WHERE t0.id = ?
Parameters:
[
2
]
|
7 | 0.20 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.display AS display_3 FROM lait_traitement t0 WHERE t0.id = ?
Parameters:
[
2
]
|
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. |