Symfony Profiler

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

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,
  c0_.merchant_id AS merchant_id_11
FROM
  coupon c0_
WHERE
  c0_.expired_at > ?
  OR c0_.expired_at IS NULL
ORDER BY
  c0_.id DESC
LIMIT
  10

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, c0_.merchant_id AS merchant_id_11 FROM coupon c0_ WHERE c0_.expired_at > '2026-04-25 13:22:22' OR c0_.expired_at IS NULL ORDER BY c0_.id DESC LIMIT 10;

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-05-02 13:22:22' 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-04-25 13:22:22' ORDER BY sclr_11 DESC, discount_amount_12 DESC, sclr_13 DESC, c0_.id DESC LIMIT 8;

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_
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_ ORDER BY c0_.title ASC;

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_.score DESC
LIMIT
  12

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_.score DESC LIMIT 12;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.content AS content_3,
  t0.created_at AS created_at_4,
  t0.image AS image_5,
  t0.enabled AS enabled_6,
  t0.category_id AS category_id_7,
  t0.merchant_id AS merchant_id_8
FROM
  news t0
ORDER BY
  t0.created_at DESC
LIMIT
  2

SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.created_at AS created_at_4, t0.image AS image_5, t0.enabled AS enabled_6, t0.category_id AS category_id_7, t0.merchant_id AS merchant_id_8 FROM news t0 ORDER BY t0.created_at DESC LIMIT 2;

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

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

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-05-02 13:22:22' 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-04-25 13:22:22' ORDER BY sclr_11 DESC, discount_amount_12 DESC, sclr_13 DESC, c0_.id DESC LIMIT 8;

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

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;