Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Logs 34
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Configuration

Query Metrics

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

[]

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

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;

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

[]

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

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;

SELECT t0.id_univers AS id_univers_1, t0.nom AS nom_2, t0.image AS image_3, t0.description AS description_4 FROM m_univers t0 WHERE t0.nom = ? LIMIT 1

[
  "ATELIER-MÉTIERS"
]

SELECT
  t0.id_univers AS id_univers_1,
  t0.nom AS nom_2,
  t0.image AS image_3,
  t0.description AS description_4
FROM
  m_univers t0
WHERE
  t0.nom = ?
LIMIT
  1

SELECT t0.id_univers AS id_univers_1, t0.nom AS nom_2, t0.image AS image_3, t0.description AS description_4 FROM m_univers t0 WHERE t0.nom = 'ATELIER-MÉTIERS' LIMIT 1;