Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 4
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• EasyAdmin
• VichUploader
• Configuration

Query Metrics

SELECT p0_.id AS id_0, p0_.nom_produit AS nom_produit_1, p0_.descriptioncourte AS descriptioncourte_2, p0_.prix AS prix_3, SUM(c1_.quantite) AS sclr_4, MIN(i2_.url) AS sclr_5, p3_.prix AS prix_6, c4_.nom AS nom_7 FROM produits p0_ INNER JOIN commander c1_ ON (p0_.id = c1_.le_produit_id) INNER JOIN commandes c5_ ON (c1_.la_commande_id = c5_.id) LEFT JOIN produits_images p6_ ON p0_.id = p6_.produits_id LEFT JOIN images i2_ ON i2_.id = p6_.images_id LEFT JOIN promo p3_ ON p0_.id = p3_.le_produit_id AND (p3_.date_debut <= CURRENT_DATE AND p3_.date_fin >= CURRENT_DATE OR p3_.id IS NULL) LEFT JOIN categorie_promo c4_ ON p3_.la_categorie_promo_id = c4_.id WHERE c5_.date_commande > ? GROUP BY p0_.id ORDER BY sclr_4 DESC LIMIT 20

[
  "2025-10-01 07:44:58"
]

SELECT
  p0_.id AS id_0,
  p0_.nom_produit AS nom_produit_1,
  p0_.descriptioncourte AS descriptioncourte_2,
  p0_.prix AS prix_3,
  SUM(c1_.quantite) AS sclr_4,
  MIN(i2_.url) AS sclr_5,
  p3_.prix AS prix_6,
  c4_.nom AS nom_7
FROM
  produits p0_
  INNER JOIN commander c1_ ON (p0_.id = c1_.le_produit_id)
  INNER JOIN commandes c5_ ON (c1_.la_commande_id = c5_.id)
  LEFT JOIN produits_images p6_ ON p0_.id = p6_.produits_id
  LEFT JOIN images i2_ ON i2_.id = p6_.images_id
  LEFT JOIN promo p3_ ON p0_.id = p3_.le_produit_id
  AND (
    p3_.date_debut <= CURRENT_DATE
    AND p3_.date_fin >= CURRENT_DATE
    OR p3_.id IS NULL
  )
  LEFT JOIN categorie_promo c4_ ON p3_.la_categorie_promo_id = c4_.id
WHERE
  c5_.date_commande > ?
GROUP BY
  p0_.id
ORDER BY
  sclr_4 DESC
LIMIT
  20

SELECT p0_.id AS id_0, p0_.nom_produit AS nom_produit_1, p0_.descriptioncourte AS descriptioncourte_2, p0_.prix AS prix_3, SUM(c1_.quantite) AS sclr_4, MIN(i2_.url) AS sclr_5, p3_.prix AS prix_6, c4_.nom AS nom_7 FROM produits p0_ INNER JOIN commander c1_ ON (p0_.id = c1_.le_produit_id) INNER JOIN commandes c5_ ON (c1_.la_commande_id = c5_.id) LEFT JOIN produits_images p6_ ON p0_.id = p6_.produits_id LEFT JOIN images i2_ ON i2_.id = p6_.images_id LEFT JOIN promo p3_ ON p0_.id = p3_.le_produit_id AND (p3_.date_debut <= CURRENT_DATE AND p3_.date_fin >= CURRENT_DATE OR p3_.id IS NULL) LEFT JOIN categorie_promo c4_ ON p3_.la_categorie_promo_id = c4_.id WHERE c5_.date_commande > '2025-10-01 07:44:58' GROUP BY p0_.id ORDER BY sclr_4 DESC LIMIT 20;

SELECT c0_.id AS id_0, c0_.commentaire AS commentaire_1, c0_.note AS note_2, c0_.date_commentaire AS date_commentaire_3, c0_.le_user_id AS le_user_id_4, c0_.le_produit_id AS le_produit_id_5 FROM commentaires c0_ ORDER BY c0_.date_commentaire DESC LIMIT 3

[]

SELECT
  c0_.id AS id_0,
  c0_.commentaire AS commentaire_1,
  c0_.note AS note_2,
  c0_.date_commentaire AS date_commentaire_3,
  c0_.le_user_id AS le_user_id_4,
  c0_.le_produit_id AS le_produit_id_5
FROM
  commentaires c0_
ORDER BY
  c0_.date_commentaire DESC
LIMIT
  3

SELECT c0_.id AS id_0, c0_.commentaire AS commentaire_1, c0_.note AS note_2, c0_.date_commentaire AS date_commentaire_3, c0_.le_user_id AS le_user_id_4, c0_.le_produit_id AS le_produit_id_5 FROM commentaires c0_ ORDER BY c0_.date_commentaire DESC LIMIT 3;