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

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 = 56;

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 = 47;

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
  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 = 55;

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 = 50;

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 = 48;

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 = 44;

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 = 42;

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;

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 = 43;