Symfony Profiler

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

Query Metrics

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
  44
]

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 (44) 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 COUNT(c0_.id) AS sclr_0, COALESCE(SUM(c0_.total), 0) AS sclr_1 FROM cart c0_ WHERE c0_.session_id = ?

[
  "a62a1522b40ccf80285577104b8bebf1"
]

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

SELECT
    ARAK.AR AS ar,
    ARAK.BRUTTO_AR AS brutto_ar,
    COALESCE(KESZLETEK.KESZLET, 0) - COALESCE(KESZLETEK.FOGLALT, 0) AS keszlet
FROM ANYAGOK
LEFT JOIN ARAK
    ON ANYAGOK.ID = ARAK.ANYAG
AND ARAK.ARLISTA = ?
LEFT JOIN KESZLETEK
    ON ANYAGOK.ID = KESZLETEK.ID
WHERE ANYAGOK.ID = ?

[
  "0"
  240526758514147
]

SELECT
  ARAK.AR AS ar,
  ARAK.BRUTTO_AR AS brutto_ar,
  COALESCE(KESZLETEK.KESZLET, 0) - COALESCE(KESZLETEK.FOGLALT, 0) AS keszlet
FROM
  ANYAGOK
  LEFT JOIN ARAK ON ANYAGOK.ID = ARAK.ANYAG
  AND ARAK.ARLISTA = ?
  LEFT JOIN KESZLETEK ON ANYAGOK.ID = KESZLETEK.ID
WHERE
  ANYAGOK.ID = ?

SELECT
    ARAK.AR AS ar,
    ARAK.BRUTTO_AR AS brutto_ar,
    COALESCE(KESZLETEK.KESZLET, 0) - COALESCE(KESZLETEK.FOGLALT, 0) AS keszlet
FROM ANYAGOK
LEFT JOIN ARAK
    ON ANYAGOK.ID = ARAK.ANYAG
AND ARAK.ARLISTA = '0'
LEFT JOIN KESZLETEK
    ON ANYAGOK.ID = KESZLETEK.ID
WHERE ANYAGOK.ID = 240526758514147;