Symfony Profiler

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

Query Metrics

SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.description AS description_2, m0_.image AS image_3, m0_.enabled AS enabled_4, m0_.score AS score_5, m0_.visit_count AS visit_count_6, m0_.url_tracking AS url_tracking_7, m0_.manual_boost AS manual_boost_8, m0_.category_id AS category_id_9 FROM merchant m0_ WHERE m0_.enabled = ? ORDER BY m0_.visit_count + m0_.manual_boost DESC LIMIT 6

[
  1
]

SELECT
  m0_.id AS id_0,
  m0_.title AS title_1,
  m0_.description AS description_2,
  m0_.image AS image_3,
  m0_.enabled AS enabled_4,
  m0_.score AS score_5,
  m0_.visit_count AS visit_count_6,
  m0_.url_tracking AS url_tracking_7,
  m0_.manual_boost AS manual_boost_8,
  m0_.category_id AS category_id_9
FROM
  merchant m0_
WHERE
  m0_.enabled = ?
ORDER BY
  m0_.visit_count + m0_.manual_boost DESC
LIMIT
  6

SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.description AS description_2, m0_.image AS image_3, m0_.enabled AS enabled_4, m0_.score AS score_5, m0_.visit_count AS visit_count_6, m0_.url_tracking AS url_tracking_7, m0_.manual_boost AS manual_boost_8, m0_.category_id AS category_id_9 FROM merchant m0_ WHERE m0_.enabled = 1 ORDER BY m0_.visit_count + m0_.manual_boost DESC LIMIT 6;

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.enabled AS enabled_4, t0.parent_id AS parent_id_5 FROM category t0 WHERE t0.enabled = ? ORDER BY t0.title ASC

[
  1
]

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.enabled AS enabled_4,
  t0.parent_id AS parent_id_5
FROM
  category t0
WHERE
  t0.enabled = ?
ORDER BY
  t0.title ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.enabled AS enabled_4, t0.parent_id AS parent_id_5 FROM category t0 WHERE t0.enabled = 1 ORDER BY t0.title ASC;

SELECT count(DISTINCT c0_.id) AS sclr_0 FROM category c0_ LEFT JOIN merchant m1_ ON c0_.id = m1_.category_id LEFT JOIN coupon c2_ ON m1_.id = c2_.merchant_id AND (c2_.expired_at > ? OR c2_.expired_at IS NULL) GROUP BY c0_.id

[
  "2026-06-17 12:59:51"
]

SELECT
  count(DISTINCT c0_.id) AS sclr_0
FROM
  category c0_
  LEFT JOIN merchant m1_ ON c0_.id = m1_.category_id
  LEFT JOIN coupon c2_ ON m1_.id = c2_.merchant_id
  AND (
    c2_.expired_at > ?
    OR c2_.expired_at IS NULL
  )
GROUP BY
  c0_.id

SELECT count(DISTINCT c0_.id) AS sclr_0 FROM category c0_ LEFT JOIN merchant m1_ ON c0_.id = m1_.category_id LEFT JOIN coupon c2_ ON m1_.id = c2_.merchant_id AND (c2_.expired_at > '2026-06-17 12:59:51' OR c2_.expired_at IS NULL) GROUP BY c0_.id;

SELECT DISTINCT c0_.id AS id_0, c0_.title AS title_1 FROM category c0_ LEFT JOIN merchant m1_ ON c0_.id = m1_.category_id LEFT JOIN coupon c2_ ON m1_.id = c2_.merchant_id AND (c2_.expired_at > ? OR c2_.expired_at IS NULL) GROUP BY c0_.id ORDER BY c0_.title ASC LIMIT 36

[
  "2026-06-17 12:59:51"
]

SELECT
  DISTINCT c0_.id AS id_0,
  c0_.title AS title_1
FROM
  category c0_
  LEFT JOIN merchant m1_ ON c0_.id = m1_.category_id
  LEFT JOIN coupon c2_ ON m1_.id = c2_.merchant_id
  AND (
    c2_.expired_at > ?
    OR c2_.expired_at IS NULL
  )
GROUP BY
  c0_.id
ORDER BY
  c0_.title ASC
LIMIT
  36

SELECT DISTINCT c0_.id AS id_0, c0_.title AS title_1 FROM category c0_ LEFT JOIN merchant m1_ ON c0_.id = m1_.category_id LEFT JOIN coupon c2_ ON m1_.id = c2_.merchant_id AND (c2_.expired_at > '2026-06-17 12:59:51' OR c2_.expired_at IS NULL) GROUP BY c0_.id ORDER BY c0_.title ASC LIMIT 36;

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.description AS description_2, c0_.enabled AS enabled_3, COUNT(c1_.id) AS sclr_4, c0_.parent_id AS parent_id_5 FROM category c0_ LEFT JOIN merchant m2_ ON c0_.id = m2_.category_id LEFT JOIN coupon c1_ ON m2_.id = c1_.merchant_id AND (c1_.expired_at > ? OR c1_.expired_at IS NULL) WHERE c0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY c0_.id ORDER BY c0_.title ASC

[
  "2026-06-17 12:59:51"
  67
  68
  71
  75
  79
  74
  61
  77
  80
  63
  73
  66
  76
  78
  72
  64
  65
  62
  70
  69
]

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.description AS description_2,
  c0_.enabled AS enabled_3,
  COUNT(c1_.id) AS sclr_4,
  c0_.parent_id AS parent_id_5
FROM
  category c0_
  LEFT JOIN merchant m2_ ON c0_.id = m2_.category_id
  LEFT JOIN coupon c1_ ON m2_.id = c1_.merchant_id
  AND (
    c1_.expired_at > ?
    OR c1_.expired_at IS NULL
  )
WHERE
  c0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
GROUP BY
  c0_.id
ORDER BY
  c0_.title ASC

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.description AS description_2, c0_.enabled AS enabled_3, COUNT(c1_.id) AS sclr_4, c0_.parent_id AS parent_id_5 FROM category c0_ LEFT JOIN merchant m2_ ON c0_.id = m2_.category_id LEFT JOIN coupon c1_ ON m2_.id = c1_.merchant_id AND (c1_.expired_at > '2026-06-17 12:59:51' OR c1_.expired_at IS NULL) WHERE c0_.id IN (67, 68, 71, 75, 79, 74, 61, 77, 80, 63, 73, 66, 76, 78, 72, 64, 65, 62, 70, 69) GROUP BY c0_.id ORDER BY c0_.title ASC;

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.description AS description_2, c0_.enabled AS enabled_3, c0_.parent_id AS parent_id_4 FROM category c0_ INNER JOIN merchant m1_ ON c0_.id = m1_.category_id WHERE c0_.enabled = ? GROUP BY c0_.title, c0_.id ORDER BY m1_.score DESC LIMIT 16

[
  1
]

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.description AS description_2,
  c0_.enabled AS enabled_3,
  c0_.parent_id AS parent_id_4
FROM
  category c0_
  INNER JOIN merchant m1_ ON c0_.id = m1_.category_id
WHERE
  c0_.enabled = ?
GROUP BY
  c0_.title,
  c0_.id
ORDER BY
  m1_.score DESC
LIMIT
  16

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.description AS description_2, c0_.enabled AS enabled_3, c0_.parent_id AS parent_id_4 FROM category c0_ INNER JOIN merchant m1_ ON c0_.id = m1_.category_id WHERE c0_.enabled = 1 GROUP BY c0_.title, c0_.id ORDER BY m1_.score DESC LIMIT 16;