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 t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.meta_description AS meta_description_4, t0.is_enable AS is_enable_5, t0.created_at AS created_at_6, t0.page_uri AS page_uri_7 FROM cms t0 WHERE t0.page_uri = ? LIMIT 1

[
  "a-propos"
]

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.content AS content_3,
  t0.meta_description AS meta_description_4,
  t0.is_enable AS is_enable_5,
  t0.created_at AS created_at_6,
  t0.page_uri AS page_uri_7
FROM
  cms t0
WHERE
  t0.page_uri = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.meta_description AS meta_description_4, t0.is_enable AS is_enable_5, t0.created_at AS created_at_6, t0.page_uri AS page_uri_7 FROM cms t0 WHERE t0.page_uri = 'a-propos' LIMIT 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

[
  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 c0_.id AS id_0, c0_.created_at AS created_at_1, c0_.updated_at AS updated_at_2, c0_.expired_at AS expired_at_3, c0_.code AS code_4, c0_.description AS description_5, c0_.gift AS gift_6, c0_.shipping_free AS shipping_free_7, c0_.discount_amount AS discount_amount_8, c0_.discount_unit AS discount_unit_9, c0_.click_count AS click_count_10, (CASE WHEN c0_.expired_at IS NOT NULL AND c0_.expired_at <= ? THEN 1 ELSE 0 END) AS sclr_11, c0_.discount_amount AS discount_amount_12, (CASE WHEN c0_.gift = 1 OR c0_.shipping_free = 1 THEN 1 ELSE 0 END) AS sclr_13, c0_.merchant_id AS merchant_id_14 FROM coupon c0_ WHERE c0_.expired_at IS NULL OR c0_.expired_at > ? ORDER BY sclr_11 DESC, discount_amount_12 DESC, sclr_13 DESC, c0_.id DESC LIMIT 8

[
  "2026-06-24 12:48:44"
  "2026-06-17 12:48:44"
]

SELECT
  c0_.id AS id_0,
  c0_.created_at AS created_at_1,
  c0_.updated_at AS updated_at_2,
  c0_.expired_at AS expired_at_3,
  c0_.code AS code_4,
  c0_.description AS description_5,
  c0_.gift AS gift_6,
  c0_.shipping_free AS shipping_free_7,
  c0_.discount_amount AS discount_amount_8,
  c0_.discount_unit AS discount_unit_9,
  c0_.click_count AS click_count_10,
  (
    CASE WHEN c0_.expired_at IS NOT NULL
    AND c0_.expired_at <= ? THEN
      1
    ELSE
      0
    END
  ) AS sclr_11,
  c0_.discount_amount AS discount_amount_12,
  (
    CASE WHEN c0_.gift = 1
    OR c0_.shipping_free = 1 THEN
      1
    ELSE
      0
    END
  ) AS sclr_13,
  c0_.merchant_id AS merchant_id_14
FROM
  coupon c0_
WHERE
  c0_.expired_at IS NULL
  OR c0_.expired_at > ?
ORDER BY
  sclr_11 DESC,
  discount_amount_12 DESC,
  sclr_13 DESC,
  c0_.id DESC
LIMIT
  8

SELECT c0_.id AS id_0, c0_.created_at AS created_at_1, c0_.updated_at AS updated_at_2, c0_.expired_at AS expired_at_3, c0_.code AS code_4, c0_.description AS description_5, c0_.gift AS gift_6, c0_.shipping_free AS shipping_free_7, c0_.discount_amount AS discount_amount_8, c0_.discount_unit AS discount_unit_9, c0_.click_count AS click_count_10, (CASE WHEN c0_.expired_at IS NOT NULL AND c0_.expired_at <= '2026-06-24 12:48:44' THEN 1 ELSE 0 END) AS sclr_11, c0_.discount_amount AS discount_amount_12, (CASE WHEN c0_.gift = 1 OR c0_.shipping_free = 1 THEN 1 ELSE 0 END) AS sclr_13, c0_.merchant_id AS merchant_id_14 FROM coupon c0_ WHERE c0_.expired_at IS NULL OR c0_.expired_at > '2026-06-17 12:48:44' ORDER BY sclr_11 DESC, discount_amount_12 DESC, sclr_13 DESC, c0_.id DESC LIMIT 8;

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.enabled AS enabled_5, t0.score AS score_6, t0.visit_count AS visit_count_7, t0.url_tracking AS url_tracking_8, t0.manual_boost AS manual_boost_9, t0.category_id AS category_id_10 FROM merchant t0 WHERE t0.id = ?

[
  53
]

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.image AS image_4,
  t0.enabled AS enabled_5,
  t0.score AS score_6,
  t0.visit_count AS visit_count_7,
  t0.url_tracking AS url_tracking_8,
  t0.manual_boost AS manual_boost_9,
  t0.category_id AS category_id_10
FROM
  merchant t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.enabled AS enabled_5, t0.score AS score_6, t0.visit_count AS visit_count_7, t0.url_tracking AS url_tracking_8, t0.manual_boost AS manual_boost_9, t0.category_id AS category_id_10 FROM merchant t0 WHERE t0.id = 53;

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.enabled AS enabled_5, t0.score AS score_6, t0.visit_count AS visit_count_7, t0.url_tracking AS url_tracking_8, t0.manual_boost AS manual_boost_9, t0.category_id AS category_id_10 FROM merchant t0 WHERE t0.id = ?

[
  46
]

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.image AS image_4,
  t0.enabled AS enabled_5,
  t0.score AS score_6,
  t0.visit_count AS visit_count_7,
  t0.url_tracking AS url_tracking_8,
  t0.manual_boost AS manual_boost_9,
  t0.category_id AS category_id_10
FROM
  merchant t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.enabled AS enabled_5, t0.score AS score_6, t0.visit_count AS visit_count_7, t0.url_tracking AS url_tracking_8, t0.manual_boost AS manual_boost_9, t0.category_id AS category_id_10 FROM merchant t0 WHERE t0.id = 46;

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.enabled AS enabled_5, t0.score AS score_6, t0.visit_count AS visit_count_7, t0.url_tracking AS url_tracking_8, t0.manual_boost AS manual_boost_9, t0.category_id AS category_id_10 FROM merchant t0 WHERE t0.id = ?

[
  45
]

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.image AS image_4,
  t0.enabled AS enabled_5,
  t0.score AS score_6,
  t0.visit_count AS visit_count_7,
  t0.url_tracking AS url_tracking_8,
  t0.manual_boost AS manual_boost_9,
  t0.category_id AS category_id_10
FROM
  merchant t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.enabled AS enabled_5, t0.score AS score_6, t0.visit_count AS visit_count_7, t0.url_tracking AS url_tracking_8, t0.manual_boost AS manual_boost_9, t0.category_id AS category_id_10 FROM merchant t0 WHERE t0.id = 45;