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;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  merchant
SET
  visit_count = ?
WHERE
  id = ?

UPDATE merchant SET visit_count = 11 WHERE id = 41;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.expired_at AS expired_at_4,
  t0.code AS code_5,
  t0.description AS description_6,
  t0.gift AS gift_7,
  t0.shipping_free AS shipping_free_8,
  t0.discount_amount AS discount_amount_9,
  t0.discount_unit AS discount_unit_10,
  t0.click_count AS click_count_11,
  t0.merchant_id AS merchant_id_12
FROM
  coupon t0
WHERE
  t0.merchant_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.expired_at AS expired_at_4, t0.code AS code_5, t0.description AS description_6, t0.gift AS gift_7, t0.shipping_free AS shipping_free_8, t0.discount_amount AS discount_amount_9, t0.discount_unit AS discount_unit_10, t0.click_count AS click_count_11, t0.merchant_id AS merchant_id_12 FROM coupon t0 WHERE t0.merchant_id = 41;

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-04-23 12:47:53' 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-16 12:47:53' 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 = 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
  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
  )
  AND c0_.merchant_id = ?
ORDER BY
  c0_.id DESC

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-16 12:47:53' OR c0_.expired_at IS NULL) AND c0_.merchant_id = 41 ORDER BY c0_.id DESC;

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_
  INNER JOIN merchant m1_ ON c0_.merchant_id = m1_.id
WHERE
  (
    c0_.expired_at > ?
    OR c0_.expired_at IS NULL
  )
  AND m1_.category_id = ?
  AND c0_.merchant_id NOT IN (?)
ORDER BY
  c0_.id DESC

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_ INNER JOIN merchant m1_ ON c0_.merchant_id = m1_.id WHERE (c0_.expired_at > '2026-04-16 12:47:53' OR c0_.expired_at IS NULL) AND m1_.category_id = 61 AND c0_.merchant_id NOT IN (41) ORDER BY c0_.id DESC;

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
  4

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-04-23 12:47:53' 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-16 12:47:53' ORDER BY sclr_11 DESC, discount_amount_12 DESC, sclr_13 DESC, c0_.id DESC LIMIT 4;

SELECT
  n0_.id AS id_0,
  n0_.title AS title_1,
  n0_.content AS content_2,
  n0_.created_at AS created_at_3,
  n0_.image AS image_4,
  n0_.enabled AS enabled_5,
  n0_.category_id AS category_id_6,
  n0_.merchant_id AS merchant_id_7
FROM
  news n0_
WHERE
  n0_.enabled = ?
  AND n0_.merchant_id = ?
ORDER BY
  n0_.id DESC

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.content AS content_2, n0_.created_at AS created_at_3, n0_.image AS image_4, n0_.enabled AS enabled_5, n0_.category_id AS category_id_6, n0_.merchant_id AS merchant_id_7 FROM news n0_ WHERE n0_.enabled = 1 AND n0_.merchant_id = 41 ORDER BY n0_.id DESC;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.expired_at AS expired_at_4,
  t0.code AS code_5,
  t0.description AS description_6,
  t0.gift AS gift_7,
  t0.shipping_free AS shipping_free_8,
  t0.discount_amount AS discount_amount_9,
  t0.discount_unit AS discount_unit_10,
  t0.click_count AS click_count_11,
  t0.merchant_id AS merchant_id_12
FROM
  coupon t0
WHERE
  t0.merchant_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.expired_at AS expired_at_4, t0.code AS code_5, t0.description AS description_6, t0.gift AS gift_7, t0.shipping_free AS shipping_free_8, t0.discount_amount AS discount_amount_9, t0.discount_unit AS discount_unit_10, t0.click_count AS click_count_11, t0.merchant_id AS merchant_id_12 FROM coupon t0 WHERE t0.merchant_id = 45;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.expired_at AS expired_at_4,
  t0.code AS code_5,
  t0.description AS description_6,
  t0.gift AS gift_7,
  t0.shipping_free AS shipping_free_8,
  t0.discount_amount AS discount_amount_9,
  t0.discount_unit AS discount_unit_10,
  t0.click_count AS click_count_11,
  t0.merchant_id AS merchant_id_12
FROM
  coupon t0
WHERE
  t0.merchant_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.expired_at AS expired_at_4, t0.code AS code_5, t0.description AS description_6, t0.gift AS gift_7, t0.shipping_free AS shipping_free_8, t0.discount_amount AS discount_amount_9, t0.discount_unit AS discount_unit_10, t0.click_count AS click_count_11, t0.merchant_id AS merchant_id_12 FROM coupon t0 WHERE t0.merchant_id = 46;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.expired_at AS expired_at_4,
  t0.code AS code_5,
  t0.description AS description_6,
  t0.gift AS gift_7,
  t0.shipping_free AS shipping_free_8,
  t0.discount_amount AS discount_amount_9,
  t0.discount_unit AS discount_unit_10,
  t0.click_count AS click_count_11,
  t0.merchant_id AS merchant_id_12
FROM
  coupon t0
WHERE
  t0.merchant_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.expired_at AS expired_at_4, t0.code AS code_5, t0.description AS description_6, t0.gift AS gift_7, t0.shipping_free AS shipping_free_8, t0.discount_amount AS discount_amount_9, t0.discount_unit AS discount_unit_10, t0.click_count AS click_count_11, t0.merchant_id AS merchant_id_12 FROM coupon t0 WHERE t0.merchant_id = 53;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.expired_at AS expired_at_4,
  t0.code AS code_5,
  t0.description AS description_6,
  t0.gift AS gift_7,
  t0.shipping_free AS shipping_free_8,
  t0.discount_amount AS discount_amount_9,
  t0.discount_unit AS discount_unit_10,
  t0.click_count AS click_count_11,
  t0.merchant_id AS merchant_id_12
FROM
  coupon t0
WHERE
  t0.merchant_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.expired_at AS expired_at_4, t0.code AS code_5, t0.description AS description_6, t0.gift AS gift_7, t0.shipping_free AS shipping_free_8, t0.discount_amount AS discount_amount_9, t0.discount_unit AS discount_unit_10, t0.click_count AS click_count_11, t0.merchant_id AS merchant_id_12 FROM coupon t0 WHERE t0.merchant_id = 51;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.expired_at AS expired_at_4,
  t0.code AS code_5,
  t0.description AS description_6,
  t0.gift AS gift_7,
  t0.shipping_free AS shipping_free_8,
  t0.discount_amount AS discount_amount_9,
  t0.discount_unit AS discount_unit_10,
  t0.click_count AS click_count_11,
  t0.merchant_id AS merchant_id_12
FROM
  coupon t0
WHERE
  t0.merchant_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.expired_at AS expired_at_4, t0.code AS code_5, t0.description AS description_6, t0.gift AS gift_7, t0.shipping_free AS shipping_free_8, t0.discount_amount AS discount_amount_9, t0.discount_unit AS discount_unit_10, t0.click_count AS click_count_11, t0.merchant_id AS merchant_id_12 FROM coupon t0 WHERE t0.merchant_id = 60;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.expired_at AS expired_at_4,
  t0.code AS code_5,
  t0.description AS description_6,
  t0.gift AS gift_7,
  t0.shipping_free AS shipping_free_8,
  t0.discount_amount AS discount_amount_9,
  t0.discount_unit AS discount_unit_10,
  t0.click_count AS click_count_11,
  t0.merchant_id AS merchant_id_12
FROM
  coupon t0
WHERE
  t0.merchant_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.expired_at AS expired_at_4, t0.code AS code_5, t0.description AS description_6, t0.gift AS gift_7, t0.shipping_free AS shipping_free_8, t0.discount_amount AS discount_amount_9, t0.discount_unit AS discount_unit_10, t0.click_count AS click_count_11, t0.merchant_id AS merchant_id_12 FROM coupon t0 WHERE t0.merchant_id = 59;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.expired_at AS expired_at_4,
  t0.code AS code_5,
  t0.description AS description_6,
  t0.gift AS gift_7,
  t0.shipping_free AS shipping_free_8,
  t0.discount_amount AS discount_amount_9,
  t0.discount_unit AS discount_unit_10,
  t0.click_count AS click_count_11,
  t0.merchant_id AS merchant_id_12
FROM
  coupon t0
WHERE
  t0.merchant_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.expired_at AS expired_at_4, t0.code AS code_5, t0.description AS description_6, t0.gift AS gift_7, t0.shipping_free AS shipping_free_8, t0.discount_amount AS discount_amount_9, t0.discount_unit AS discount_unit_10, t0.click_count AS click_count_11, t0.merchant_id AS merchant_id_12 FROM coupon t0 WHERE t0.merchant_id = 58;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.expired_at AS expired_at_4,
  t0.code AS code_5,
  t0.description AS description_6,
  t0.gift AS gift_7,
  t0.shipping_free AS shipping_free_8,
  t0.discount_amount AS discount_amount_9,
  t0.discount_unit AS discount_unit_10,
  t0.click_count AS click_count_11,
  t0.merchant_id AS merchant_id_12
FROM
  coupon t0
WHERE
  t0.merchant_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.expired_at AS expired_at_4, t0.code AS code_5, t0.description AS description_6, t0.gift AS gift_7, t0.shipping_free AS shipping_free_8, t0.discount_amount AS discount_amount_9, t0.discount_unit AS discount_unit_10, t0.click_count AS click_count_11, t0.merchant_id AS merchant_id_12 FROM coupon t0 WHERE t0.merchant_id = 57;