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_collection.* FROM `m_collection` LEFT JOIN m_produit ON m_collection.nom = m_produit.famille WHERE m_produit.actif = 1 GROUP BY m_collection.nom;

[]

SELECT
  m_collection.*
FROM
  `m_collection`
  LEFT JOIN m_produit ON m_collection.nom = m_produit.famille
WHERE
  m_produit.actif = 1
GROUP BY
  m_collection.nom;

SELECT m_collection.* FROM `m_collection` LEFT JOIN m_produit ON m_collection.nom = m_produit.famille WHERE m_produit.actif = 1 GROUP BY m_collection.nom;;

SELECT m0_.reference AS reference_0, m0_.id_collection AS id_collection_1, m0_.nom AS nom_2, m0_.description AS description_3, m0_.couleur AS couleur_4, m0_.caracteristiques AS caracteristiques_5, m0_.image_principale AS image_principale_6, m0_.images_secondaires AS images_secondaires_7, m0_.schema_produit AS schema_produit_8, m0_.fiche_technique AS fiche_technique_9, m0_.notice_montage AS notice_montage_10, m0_.video AS video_11, m0_.normes AS normes_12, m0_.famille AS famille_13, m0_.poids AS poids_14, m0_.taille AS taille_15, m0_.duree AS duree_16, m0_.prix AS prix_17, m0_.statut AS statut_18, m0_.actif AS actif_19, m0_.materiaux AS materiaux_20, m0_.kit AS kit_21, m0_.etat AS etat_22, m1_.nom AS nom_23 FROM m_produit m0_ LEFT JOIN m_collection m1_ ON (m0_.id_collection = m1_.id) WHERE m0_.statut = ? AND m0_.actif = ? ORDER BY m0_.nom ASC

[
  "fin de série"
  1
]

SELECT
  m0_.reference AS reference_0,
  m0_.id_collection AS id_collection_1,
  m0_.nom AS nom_2,
  m0_.description AS description_3,
  m0_.couleur AS couleur_4,
  m0_.caracteristiques AS caracteristiques_5,
  m0_.image_principale AS image_principale_6,
  m0_.images_secondaires AS images_secondaires_7,
  m0_.schema_produit AS schema_produit_8,
  m0_.fiche_technique AS fiche_technique_9,
  m0_.notice_montage AS notice_montage_10,
  m0_.video AS video_11,
  m0_.normes AS normes_12,
  m0_.famille AS famille_13,
  m0_.poids AS poids_14,
  m0_.taille AS taille_15,
  m0_.duree AS duree_16,
  m0_.prix AS prix_17,
  m0_.statut AS statut_18,
  m0_.actif AS actif_19,
  m0_.materiaux AS materiaux_20,
  m0_.kit AS kit_21,
  m0_.etat AS etat_22,
  m1_.nom AS nom_23
FROM
  m_produit m0_
  LEFT JOIN m_collection m1_ ON (m0_.id_collection = m1_.id)
WHERE
  m0_.statut = ?
  AND m0_.actif = ?
ORDER BY
  m0_.nom ASC

SELECT m0_.reference AS reference_0, m0_.id_collection AS id_collection_1, m0_.nom AS nom_2, m0_.description AS description_3, m0_.couleur AS couleur_4, m0_.caracteristiques AS caracteristiques_5, m0_.image_principale AS image_principale_6, m0_.images_secondaires AS images_secondaires_7, m0_.schema_produit AS schema_produit_8, m0_.fiche_technique AS fiche_technique_9, m0_.notice_montage AS notice_montage_10, m0_.video AS video_11, m0_.normes AS normes_12, m0_.famille AS famille_13, m0_.poids AS poids_14, m0_.taille AS taille_15, m0_.duree AS duree_16, m0_.prix AS prix_17, m0_.statut AS statut_18, m0_.actif AS actif_19, m0_.materiaux AS materiaux_20, m0_.kit AS kit_21, m0_.etat AS etat_22, m1_.nom AS nom_23 FROM m_produit m0_ LEFT JOIN m_collection m1_ ON (m0_.id_collection = m1_.id) WHERE m0_.statut = 'fin de série' AND m0_.actif = 1 ORDER BY m0_.nom ASC;

SELECT m0_.reference AS reference_0, m0_.id_collection AS id_collection_1, m0_.nom AS nom_2, m0_.description AS description_3, m0_.couleur AS couleur_4, m0_.caracteristiques AS caracteristiques_5, m0_.image_principale AS image_principale_6, m0_.images_secondaires AS images_secondaires_7, m0_.schema_produit AS schema_produit_8, m0_.fiche_technique AS fiche_technique_9, m0_.notice_montage AS notice_montage_10, m0_.video AS video_11, m0_.normes AS normes_12, m0_.famille AS famille_13, m0_.poids AS poids_14, m0_.taille AS taille_15, m0_.duree AS duree_16, m0_.prix AS prix_17, m0_.statut AS statut_18, m0_.actif AS actif_19, m0_.materiaux AS materiaux_20, m0_.kit AS kit_21, m0_.etat AS etat_22, m1_.nom AS nom_23 FROM m_produit m0_ LEFT JOIN m_collection m1_ ON (m0_.id_collection = m1_.id) WHERE m0_.statut = ? AND m0_.actif = ? ORDER BY m0_.nom ASC

[
  "reconditionné"
  1
]

SELECT
  m0_.reference AS reference_0,
  m0_.id_collection AS id_collection_1,
  m0_.nom AS nom_2,
  m0_.description AS description_3,
  m0_.couleur AS couleur_4,
  m0_.caracteristiques AS caracteristiques_5,
  m0_.image_principale AS image_principale_6,
  m0_.images_secondaires AS images_secondaires_7,
  m0_.schema_produit AS schema_produit_8,
  m0_.fiche_technique AS fiche_technique_9,
  m0_.notice_montage AS notice_montage_10,
  m0_.video AS video_11,
  m0_.normes AS normes_12,
  m0_.famille AS famille_13,
  m0_.poids AS poids_14,
  m0_.taille AS taille_15,
  m0_.duree AS duree_16,
  m0_.prix AS prix_17,
  m0_.statut AS statut_18,
  m0_.actif AS actif_19,
  m0_.materiaux AS materiaux_20,
  m0_.kit AS kit_21,
  m0_.etat AS etat_22,
  m1_.nom AS nom_23
FROM
  m_produit m0_
  LEFT JOIN m_collection m1_ ON (m0_.id_collection = m1_.id)
WHERE
  m0_.statut = ?
  AND m0_.actif = ?
ORDER BY
  m0_.nom ASC

SELECT m0_.reference AS reference_0, m0_.id_collection AS id_collection_1, m0_.nom AS nom_2, m0_.description AS description_3, m0_.couleur AS couleur_4, m0_.caracteristiques AS caracteristiques_5, m0_.image_principale AS image_principale_6, m0_.images_secondaires AS images_secondaires_7, m0_.schema_produit AS schema_produit_8, m0_.fiche_technique AS fiche_technique_9, m0_.notice_montage AS notice_montage_10, m0_.video AS video_11, m0_.normes AS normes_12, m0_.famille AS famille_13, m0_.poids AS poids_14, m0_.taille AS taille_15, m0_.duree AS duree_16, m0_.prix AS prix_17, m0_.statut AS statut_18, m0_.actif AS actif_19, m0_.materiaux AS materiaux_20, m0_.kit AS kit_21, m0_.etat AS etat_22, m1_.nom AS nom_23 FROM m_produit m0_ LEFT JOIN m_collection m1_ ON (m0_.id_collection = m1_.id) WHERE m0_.statut = 'reconditionné' AND m0_.actif = 1 ORDER BY m0_.nom ASC;