Query Metrics
15
Database Queries
7
Different statements
20.39 ms
Query time
0
Invalid entities
11
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
12.62 ms (61.89%) |
1 |
SELECT m_produit.*, m_collection.nom AS nom_collection FROM api_produit LEFT JOIN m_produit ON api_produit.reference = m_produit.reference LEFT JOIN m_collection ON m_produit.id_collection = m_collection.id WHERE (JSON_EXTRACT (infos_libres, '$.UNIVERS1') = 'ATELIER-MÉTIERS' OR JSON_EXTRACT (infos_libres, '$.UNIVERS2') = 'ATELIER-MÉTIERS' OR JSON_EXTRACT (infos_libres, '$.UNIVERS3') = 'ATELIER-MÉTIERS') AND actif = 1 GROUP BY m_produit.famille
Parameters:
[] |
|
4.01 ms (19.68%) |
1 |
SELECT t0.reference AS reference_1, t0.id_collection AS id_collection_2, t0.nom AS nom_3, t0.description AS description_4, t0.couleur AS couleur_5, t0.caracteristiques AS caracteristiques_6, t0.image_principale AS image_principale_7, t0.images_secondaires AS images_secondaires_8, t0.schema_produit AS schema_produit_9, t0.fiche_technique AS fiche_technique_10, t0.notice_montage AS notice_montage_11, t0.video AS video_12, t0.normes AS normes_13, t0.famille AS famille_14, t0.poids AS poids_15, t0.taille AS taille_16, t0.duree AS duree_17, t0.prix AS prix_18, t0.statut AS statut_19, t0.actif AS actif_20, t0.materiaux AS materiaux_21, t0.kit AS kit_22, t0.etat AS etat_23 FROM m_produit t0 WHERE t0.id_collection = ? AND t0.actif = ?
Parameters:
[ 1661 1 ] |
|
2.14 ms (10.51%) |
9 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.image AS image_3, t0.description AS description_4, t0.dominant AS dominant_5, t0.nuancier AS nuancier_6 FROM m_collection t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1661
]
|
|
0.60 ms (2.95%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.image AS image_3, t0.description AS description_4, t0.dominant AS dominant_5, t0.nuancier AS nuancier_6 FROM m_collection t0 WHERE t0.nom = ? LIMIT 1
Parameters:
[
"BUDGET"
]
|
|
0.35 ms (1.74%) |
1 |
SELECT t0.reference AS reference_1, t0.id_collection AS id_collection_2, t0.nom AS nom_3, t0.description AS description_4, t0.couleur AS couleur_5, t0.caracteristiques AS caracteristiques_6, t0.image_principale AS image_principale_7, t0.images_secondaires AS images_secondaires_8, t0.schema_produit AS schema_produit_9, t0.fiche_technique AS fiche_technique_10, t0.notice_montage AS notice_montage_11, t0.video AS video_12, t0.normes AS normes_13, t0.famille AS famille_14, t0.poids AS poids_15, t0.taille AS taille_16, t0.duree AS duree_17, t0.prix AS prix_18, t0.statut AS statut_19, t0.actif AS actif_20, t0.materiaux AS materiaux_21, t0.kit AS kit_22, t0.etat AS etat_23 FROM m_produit t0 WHERE t0.reference = ? AND t0.actif = ?
Parameters:
[ "SDSL02NR" 1 ] |
|
0.34 ms (1.68%) |
1 |
SELECT JSON_EXTRACT (infos_libres, '$.UNIVERS1') AS univers1 FROM api_produit WHERE reference = 'SDSL02NR'
Parameters:
[] |
|
0.32 ms (1.56%) |
1 |
SELECT t0.reference AS reference_1, t0.quantity AS quantity_2 FROM stocks t0 WHERE t0.reference IN (?)
Parameters:
[
"SDSL02NR"
]
|
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\MCollection | 9 |
| App\Entity\MProduit | 1 |
| App\Entity\Stocks | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\MCollection | No errors. |
| App\Entity\MProduit | No errors. |
| App\Entity\Stocks | No errors. |
| App\Entity\ApiProduit | No errors. |