Symfony Profiler

SELECT
  DISTINCT c0_.id AS id_0,
  c0_.end_at AS end_at_1
FROM
  coupon c0_
  LEFT JOIN image i1_ ON c0_.image_id = i1_.id
  LEFT JOIN coupon_category c2_ ON c0_.id = c2_.coupon_id
  LEFT JOIN coupon_type c3_ ON c0_.type_id = c3_.id
  LEFT JOIN coupon_type c4_ ON c0_.id = c4_.coupon_id
  LEFT JOIN coupon_country c5_ ON c0_.id = c5_.coupon_id
  LEFT JOIN merchant m6_ ON c0_.merchant_id = m6_.id
WHERE
  c0_.end_at >= ?
ORDER BY
  c0_.end_at DESC
LIMIT
  10 OFFSET 20

SELECT DISTINCT c0_.id AS id_0, c0_.end_at AS end_at_1 FROM coupon c0_ LEFT JOIN image i1_ ON c0_.image_id = i1_.id LEFT JOIN coupon_category c2_ ON c0_.id = c2_.coupon_id LEFT JOIN coupon_type c3_ ON c0_.type_id = c3_.id LEFT JOIN coupon_type c4_ ON c0_.id = c4_.coupon_id LEFT JOIN coupon_country c5_ ON c0_.id = c5_.coupon_id LEFT JOIN merchant m6_ ON c0_.merchant_id = m6_.id WHERE c0_.end_at >= '2024-09-28 00:00:00' ORDER BY c0_.end_at DESC LIMIT 10 OFFSET 20;

SELECT
  c0_.id AS id_0,
  c0_.create_at AS create_at_1,
  c0_.update_at AS update_at_2,
  c0_.start_at AS start_at_3,
  c0_.end_at AS end_at_4,
  c0_.is_active AS is_active_5,
  c0_.identifiant AS identifiant_6,
  c0_.is_exclusive AS is_exclusive_7,
  c0_.is_promocode AS is_promocode_8,
  c0_.name AS name_9,
  c0_.slug AS slug_10,
  c0_.description AS description_11,
  c0_.logo AS logo_12,
  c0_.code AS code_13,
  c0_.url AS url_14,
  c0_.promolink AS promolink_15,
  c0_.rating AS rating_16,
  c0_.discount AS discount_17,
  i1_.id AS id_18,
  i1_.create_at AS create_at_19,
  i1_.update_at AS update_at_20,
  i1_.path AS path_21,
  i1_.name AS name_22,
  i1_.mime AS mime_23,
  i1_.width AS width_24,
  i1_.height AS height_25,
  i1_.description AS description_26,
  i1_.original AS original_27,
  c2_.id AS id_28,
  c2_.create_at AS create_at_29,
  c2_.update_at AS update_at_30,
  c2_.is_active AS is_active_31,
  c3_.id AS id_32,
  c3_.create_at AS create_at_33,
  c3_.update_at AS update_at_34,
  c3_.is_active AS is_active_35,
  c4_.id AS id_36,
  c4_.create_at AS create_at_37,
  c4_.update_at AS update_at_38,
  c4_.is_active AS is_active_39,
  c5_.id AS id_40,
  c5_.create_at AS create_at_41,
  c5_.update_at AS update_at_42,
  c5_.is_active AS is_active_43,
  c5_.name AS name_44,
  c5_.description AS description_45,
  m6_.id AS id_46,
  m6_.create_at AS create_at_47,
  m6_.update_at AS update_at_48,
  m6_.identifiant AS identifiant_49,
  m6_.name AS name_50,
  m6_.slug AS slug_51,
  m6_.display_name AS display_name_52,
  m6_.domain AS domain_53,
  m6_.url AS url_54,
  m6_.description AS description_55,
  m6_.logo AS logo_56,
  m6_.is_active AS is_active_57,
  c0_.image_id AS image_id_58,
  c0_.type_id AS type_id_59,
  c0_.merchant_id AS merchant_id_60,
  c0_.currency_id AS currency_id_61,
  c2_.coupon_id AS coupon_id_62,
  c2_.category_id AS category_id_63,
  c3_.coupon_id AS coupon_id_64,
  c3_.type_id AS type_id_65,
  c4_.coupon_id AS coupon_id_66,
  c4_.type_id AS type_id_67,
  c5_.coupon_id AS coupon_id_68,
  c5_.country_id AS country_id_69
FROM
  coupon c0_
  LEFT JOIN image i1_ ON c0_.image_id = i1_.id
  LEFT JOIN coupon_category c2_ ON c0_.id = c2_.coupon_id
  LEFT JOIN coupon_type c3_ ON c0_.type_id = c3_.id
  LEFT JOIN coupon_type c4_ ON c0_.id = c4_.coupon_id
  LEFT JOIN coupon_country c5_ ON c0_.id = c5_.coupon_id
  LEFT JOIN merchant m6_ ON c0_.merchant_id = m6_.id
WHERE
  c0_.end_at >= ?
  AND c0_.id IN (?)
ORDER BY
  c0_.end_at DESC

SELECT c0_.id AS id_0, c0_.create_at AS create_at_1, c0_.update_at AS update_at_2, c0_.start_at AS start_at_3, c0_.end_at AS end_at_4, c0_.is_active AS is_active_5, c0_.identifiant AS identifiant_6, c0_.is_exclusive AS is_exclusive_7, c0_.is_promocode AS is_promocode_8, c0_.name AS name_9, c0_.slug AS slug_10, c0_.description AS description_11, c0_.logo AS logo_12, c0_.code AS code_13, c0_.url AS url_14, c0_.promolink AS promolink_15, c0_.rating AS rating_16, c0_.discount AS discount_17, i1_.id AS id_18, i1_.create_at AS create_at_19, i1_.update_at AS update_at_20, i1_.path AS path_21, i1_.name AS name_22, i1_.mime AS mime_23, i1_.width AS width_24, i1_.height AS height_25, i1_.description AS description_26, i1_.original AS original_27, c2_.id AS id_28, c2_.create_at AS create_at_29, c2_.update_at AS update_at_30, c2_.is_active AS is_active_31, c3_.id AS id_32, c3_.create_at AS create_at_33, c3_.update_at AS update_at_34, c3_.is_active AS is_active_35, c4_.id AS id_36, c4_.create_at AS create_at_37, c4_.update_at AS update_at_38, c4_.is_active AS is_active_39, c5_.id AS id_40, c5_.create_at AS create_at_41, c5_.update_at AS update_at_42, c5_.is_active AS is_active_43, c5_.name AS name_44, c5_.description AS description_45, m6_.id AS id_46, m6_.create_at AS create_at_47, m6_.update_at AS update_at_48, m6_.identifiant AS identifiant_49, m6_.name AS name_50, m6_.slug AS slug_51, m6_.display_name AS display_name_52, m6_.domain AS domain_53, m6_.url AS url_54, m6_.description AS description_55, m6_.logo AS logo_56, m6_.is_active AS is_active_57, c0_.image_id AS image_id_58, c0_.type_id AS type_id_59, c0_.merchant_id AS merchant_id_60, c0_.currency_id AS currency_id_61, c2_.coupon_id AS coupon_id_62, c2_.category_id AS category_id_63, c3_.coupon_id AS coupon_id_64, c3_.type_id AS type_id_65, c4_.coupon_id AS coupon_id_66, c4_.type_id AS type_id_67, c5_.coupon_id AS coupon_id_68, c5_.country_id AS country_id_69 FROM coupon c0_ LEFT JOIN image i1_ ON c0_.image_id = i1_.id LEFT JOIN coupon_category c2_ ON c0_.id = c2_.coupon_id LEFT JOIN coupon_type c3_ ON c0_.type_id = c3_.id LEFT JOIN coupon_type c4_ ON c0_.id = c4_.coupon_id LEFT JOIN coupon_country c5_ ON c0_.id = c5_.coupon_id LEFT JOIN merchant m6_ ON c0_.merchant_id = m6_.id WHERE c0_.end_at >= '2024-09-28 00:00:00' AND c0_.id IN (25760, 25761, 25764, 25766, 25823, 25737, 25747, 25731, 25812, 25791) ORDER BY c0_.end_at DESC;