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 COUNT(p0_.id) AS sclr_0 FROM produits p0_ LEFT JOIN promo p1_ ON p0_.id = p1_.le_produit_id AND (p1_.date_debut <= CURRENT_TIMESTAMP AND p1_.date_fin >= CURRENT_TIMESTAMP OR p1_.id IS NULL) LEFT JOIN categorie_promo c2_ ON p1_.la_categorie_promo_id = c2_.id WHERE c2_.nom = ?

[
  "Mercredi"
]

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  produits p0_
  LEFT JOIN promo p1_ ON p0_.id = p1_.le_produit_id
  AND (
    p1_.date_debut <= CURRENT_TIMESTAMP
    AND p1_.date_fin >= CURRENT_TIMESTAMP
    OR p1_.id IS NULL
  )
  LEFT JOIN categorie_promo c2_ ON p1_.la_categorie_promo_id = c2_.id
WHERE
  c2_.nom = ?

SELECT COUNT(p0_.id) AS sclr_0 FROM produits p0_ LEFT JOIN promo p1_ ON p0_.id = p1_.le_produit_id AND (p1_.date_debut <= CURRENT_TIMESTAMP AND p1_.date_fin >= CURRENT_TIMESTAMP OR p1_.id IS NULL) LEFT JOIN categorie_promo c2_ ON p1_.la_categorie_promo_id = c2_.id WHERE c2_.nom = 'Mercredi';

SELECT p0_.id AS id_0, p0_.nom_produit AS nom_produit_1, p1_.prix AS prix_2, p1_.date_fin AS date_fin_3, c2_.nom AS nom_4, MIN(i3_.url) AS sclr_5 FROM produits p0_ LEFT JOIN promo p1_ ON p0_.id = p1_.le_produit_id AND (p1_.date_debut <= CURRENT_TIMESTAMP AND p1_.date_fin >= CURRENT_TIMESTAMP OR p1_.id IS NULL) LEFT JOIN categorie_promo c2_ ON p1_.la_categorie_promo_id = c2_.id LEFT JOIN produits_images p4_ ON p0_.id = p4_.produits_id LEFT JOIN images i3_ ON i3_.id = p4_.images_id WHERE c2_.nom = ? GROUP BY p0_.id, p0_.nom_produit ORDER BY p0_.id ASC LIMIT 1

[
  "Mercredi"
]

SELECT
  p0_.id AS id_0,
  p0_.nom_produit AS nom_produit_1,
  p1_.prix AS prix_2,
  p1_.date_fin AS date_fin_3,
  c2_.nom AS nom_4,
  MIN(i3_.url) AS sclr_5
FROM
  produits p0_
  LEFT JOIN promo p1_ ON p0_.id = p1_.le_produit_id
  AND (
    p1_.date_debut <= CURRENT_TIMESTAMP
    AND p1_.date_fin >= CURRENT_TIMESTAMP
    OR p1_.id IS NULL
  )
  LEFT JOIN categorie_promo c2_ ON p1_.la_categorie_promo_id = c2_.id
  LEFT JOIN produits_images p4_ ON p0_.id = p4_.produits_id
  LEFT JOIN images i3_ ON i3_.id = p4_.images_id
WHERE
  c2_.nom = ?
GROUP BY
  p0_.id,
  p0_.nom_produit
ORDER BY
  p0_.id ASC
LIMIT
  1

SELECT p0_.id AS id_0, p0_.nom_produit AS nom_produit_1, p1_.prix AS prix_2, p1_.date_fin AS date_fin_3, c2_.nom AS nom_4, MIN(i3_.url) AS sclr_5 FROM produits p0_ LEFT JOIN promo p1_ ON p0_.id = p1_.le_produit_id AND (p1_.date_debut <= CURRENT_TIMESTAMP AND p1_.date_fin >= CURRENT_TIMESTAMP OR p1_.id IS NULL) LEFT JOIN categorie_promo c2_ ON p1_.la_categorie_promo_id = c2_.id LEFT JOIN produits_images p4_ ON p0_.id = p4_.produits_id LEFT JOIN images i3_ ON i3_.id = p4_.images_id WHERE c2_.nom = 'Mercredi' GROUP BY p0_.id, p0_.nom_produit ORDER BY p0_.id ASC LIMIT 1;