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 = ?

[
  "cd02f03f5c3c1ab0981d35033a6b010d"
]

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 = 'cd02f03f5c3c1ab0981d35033a6b010d';

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 -1 ELSE MIN(a1_.sorrend) END DESC, p0_.id ASC

[
  1
  0
  58
  59
  60
  61
  62
  63
]

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
    -1
  ELSE
    MIN(a1_.sorrend)
  END DESC,
  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 (58, 59, 60, 61, 62, 63) GROUP BY p0_.id ORDER BY CASE WHEN MIN(a1_.sorrend) IS NULL THEN -1 ELSE MIN(a1_.sorrend) END DESC, p0_.id ASC;