Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 4
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• 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

[
  "2026-04-10 11:06:07"
]

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 > '2026-04-10 11:06:07' GROUP BY p0_.id ORDER BY sclr_4 DESC LIMIT 20;

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.telephone AS telephone_7, t0.classe AS classe_8, t0.fidelite AS fidelite_9, t0.photo_url AS photo_url_10, t0.fcm_token AS fcm_token_11, t0.display_name AS display_name_12, t0.is_leaderboard_opt_in AS is_leaderboard_opt_in_13, t0.pref_newsletter AS pref_newsletter_14, t0.pref_promo_notifications AS pref_promo_notifications_15, t0.pref_order_alerts AS pref_order_alerts_16, t0.reset_token AS reset_token_17, t0.reset_token_expiry AS reset_token_expiry_18 FROM user t0 WHERE t0.id = ?

[
  43
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.nom AS nom_5,
  t0.prenom AS prenom_6,
  t0.telephone AS telephone_7,
  t0.classe AS classe_8,
  t0.fidelite AS fidelite_9,
  t0.photo_url AS photo_url_10,
  t0.fcm_token AS fcm_token_11,
  t0.display_name AS display_name_12,
  t0.is_leaderboard_opt_in AS is_leaderboard_opt_in_13,
  t0.pref_newsletter AS pref_newsletter_14,
  t0.pref_promo_notifications AS pref_promo_notifications_15,
  t0.pref_order_alerts AS pref_order_alerts_16,
  t0.reset_token AS reset_token_17,
  t0.reset_token_expiry AS reset_token_expiry_18
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.telephone AS telephone_7, t0.classe AS classe_8, t0.fidelite AS fidelite_9, t0.photo_url AS photo_url_10, t0.fcm_token AS fcm_token_11, t0.display_name AS display_name_12, t0.is_leaderboard_opt_in AS is_leaderboard_opt_in_13, t0.pref_newsletter AS pref_newsletter_14, t0.pref_promo_notifications AS pref_promo_notifications_15, t0.pref_order_alerts AS pref_order_alerts_16, t0.reset_token AS reset_token_17, t0.reset_token_expiry AS reset_token_expiry_18 FROM user t0 WHERE t0.id = 43;