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 t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.active AS active_4, t0.sorrend AS sorrend_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.icon_alt AS icon_alt_8, t0.icon_title AS icon_title_9, t0.icon AS icon_10, t0.image AS image_11, t0.image_alt AS image_alt_12, t0.image_title AS image_title_13, t0.article_image AS article_image_14, t0.article_image_alt AS article_image_alt_15, t0.article_image_title AS article_image_title_16, t0.description AS description_17, t0.short_description AS short_description_18, t0.featured AS featured_19, t0.seo_title AS seo_title_20, t0.meta_desc AS meta_desc_21, t0.beepites AS beepites_22, t0.parent_id AS parent_id_23 FROM product_category t0 WHERE t0.alias = ? LIMIT 1

[
  "kiegeszitok"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.alias AS alias_3,
  t0.active AS active_4,
  t0.sorrend AS sorrend_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.icon_alt AS icon_alt_8,
  t0.icon_title AS icon_title_9,
  t0.icon AS icon_10,
  t0.image AS image_11,
  t0.image_alt AS image_alt_12,
  t0.image_title AS image_title_13,
  t0.article_image AS article_image_14,
  t0.article_image_alt AS article_image_alt_15,
  t0.article_image_title AS article_image_title_16,
  t0.description AS description_17,
  t0.short_description AS short_description_18,
  t0.featured AS featured_19,
  t0.seo_title AS seo_title_20,
  t0.meta_desc AS meta_desc_21,
  t0.beepites AS beepites_22,
  t0.parent_id AS parent_id_23
FROM
  product_category t0
WHERE
  t0.alias = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.active AS active_4, t0.sorrend AS sorrend_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.icon_alt AS icon_alt_8, t0.icon_title AS icon_title_9, t0.icon AS icon_10, t0.image AS image_11, t0.image_alt AS image_alt_12, t0.image_title AS image_title_13, t0.article_image AS article_image_14, t0.article_image_alt AS article_image_alt_15, t0.article_image_title AS article_image_title_16, t0.description AS description_17, t0.short_description AS short_description_18, t0.featured AS featured_19, t0.seo_title AS seo_title_20, t0.meta_desc AS meta_desc_21, t0.beepites AS beepites_22, t0.parent_id AS parent_id_23 FROM product_category t0 WHERE t0.alias = 'kiegeszitok' LIMIT 1;

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

[
  "5195944853d01002f2630bef5dab6532"
]

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 = '5195944853d01002f2630bef5dab6532';

SELECT p0_.id AS id_0 FROM product_category p0_ WHERE p0_.parent_id IN (?)

[
  58
]

SELECT
  p0_.id AS id_0
FROM
  product_category p0_
WHERE
  p0_.parent_id IN (?)

SELECT p0_.id AS id_0 FROM product_category p0_ WHERE p0_.parent_id IN (58);

SELECT p0_.id AS id_0 FROM product_category p0_ WHERE p0_.parent_id IN (?, ?, ?, ?, ?)

[
  59
  60
  61
  62
  63
]

SELECT
  p0_.id AS id_0
FROM
  product_category p0_
WHERE
  p0_.parent_id IN (?, ?, ?, ?, ?)

SELECT p0_.id AS id_0 FROM product_category p0_ WHERE p0_.parent_id IN (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 999999 ELSE MIN(a1_.sorrend) END ASC, 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
    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 (58, 59, 60, 61, 62, 63) GROUP BY p0_.id ORDER BY CASE WHEN MIN(a1_.sorrend) IS NULL THEN 999999 ELSE MIN(a1_.sorrend) END ASC, p0_.id ASC;