Symfony Profiler

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

Query Metrics

SELECT COUNT(c0_.id) AS sclr_0, COALESCE(SUM(c0_.total), 0) AS sclr_1 FROM cart c0_ WHERE c0_.session_id = ?

[
  "d2407e16a590aa715f6cf8205f168cc4"
]

SELECT
  COUNT(c0_.id) AS sclr_0,
  COALESCE(
    SUM(c0_.total),
    0
  ) AS sclr_1
FROM
  cart c0_
WHERE
  c0_.session_id = ?

SELECT COUNT(c0_.id) AS sclr_0, COALESCE(SUM(c0_.total), 0) AS sclr_1 FROM cart c0_ WHERE c0_.session_id = 'd2407e16a590aa715f6cf8205f168cc4';

SELECT DISTINCT p0_.id AS id_0 FROM product p0_ LEFT JOIN product_alapszin p2_ ON p0_.id = p2_.product_id LEFT JOIN alapszin a1_ ON a1_.id = p2_.alapszin_id AND (a1_.active = 1) WHERE p0_.active = ? AND p0_.meret = ? AND p0_.category_id IN (?) GROUP BY p0_.id ORDER BY CASE WHEN MIN(a1_.sorrend) IS NULL THEN 999999 ELSE MIN(a1_.sorrend) END ASC, p0_.id ASC

[
  1
  0
  38
]

SELECT
  DISTINCT p0_.id AS id_0
FROM
  product p0_
  LEFT JOIN product_alapszin p2_ ON p0_.id = p2_.product_id
  LEFT JOIN alapszin a1_ ON a1_.id = p2_.alapszin_id
  AND (a1_.active = 1)
WHERE
  p0_.active = ?
  AND p0_.meret = ?
  AND p0_.category_id IN (?)
GROUP BY
  p0_.id
ORDER BY
  CASE WHEN MIN(a1_.sorrend) IS NULL THEN
    999999
  ELSE
    MIN(a1_.sorrend)
  END ASC,
  p0_.id ASC

SELECT DISTINCT p0_.id AS id_0 FROM product p0_ LEFT JOIN product_alapszin p2_ ON p0_.id = p2_.product_id LEFT JOIN alapszin a1_ ON a1_.id = p2_.alapszin_id AND (a1_.active = 1) WHERE p0_.active = 1 AND p0_.meret = 0 AND p0_.category_id IN (38) GROUP BY p0_.id ORDER BY CASE WHEN MIN(a1_.sorrend) IS NULL THEN 999999 ELSE MIN(a1_.sorrend) END ASC, p0_.id ASC;