Symfony Profiler

SELECT
  s0_.title AS title_0,
  s0_.slug AS slug_1,
  s0_.description AS description_2,
  s0_.booking_type AS booking_type_3,
  s0_.status AS status_4,
  s0_.currency AS currency_5,
  s0_.short_description AS short_description_6,
  s0_.duration_minutes AS duration_minutes_7,
  s0_.place_label AS place_label_8,
  s0_.duration_label AS duration_label_9,
  s0_.badge AS badge_10,
  s0_.search_text AS search_text_11,
  s0_.search_place AS search_place_12,
  s0_.position AS position_13,
  s0_.rating_average AS rating_average_14,
  s0_.reviews_count AS reviews_count_15,
  s0_.views_count AS views_count_16,
  s0_.capacity AS capacity_17,
  s0_.level AS level_18,
  s0_.languages AS languages_19,
  s0_.included AS included_20,
  s0_.subtitle AS subtitle_21,
  s0_.activity_type AS activity_type_22,
  s0_.minimum_age AS minimum_age_23,
  s0_.programme AS programme_24,
  s0_.meeting_point AS meeting_point_25,
  s0_.opening_period AS opening_period_26,
  s0_.audience AS audience_27,
  s0_.cancellation_policy AS cancellation_policy_28,
  s0_.address AS address_29,
  s0_.city AS city_30,
  s0_.postal_code AS postal_code_31,
  s0_.country AS country_32,
  s0_.latitude AS latitude_33,
  s0_.longitude AS longitude_34,
  s0_.id AS id_35,
  s0_.created_at AS created_at_36,
  s0_.updated_at AS updated_at_37,
  s0_.deleted_at AS deleted_at_38,
  s1_.name AS name_39,
  s1_.description AS description_40,
  s1_.price AS price_41,
  s1_.currency AS currency_42,
  s1_.pricing_unit AS pricing_unit_43,
  s1_.delivery_days AS delivery_days_44,
  s1_.id AS id_45,
  s1_.created_at AS created_at_46,
  s1_.updated_at AS updated_at_47,
  m2_.path AS path_48,
  m2_.type AS type_49,
  m2_.position AS position_50,
  m2_.id AS id_51,
  m2_.created_at AS created_at_52,
  m2_.updated_at AS updated_at_53,
  s3_.breadcrumb AS breadcrumb_54,
  s3_.organizer AS organizer_55,
  s3_.presentation_subtitle AS presentation_subtitle_56,
  s3_.presentation_text AS presentation_text_57,
  s3_.highlights_title AS highlights_title_58,
  s3_.highlights AS highlights_59,
  s3_.included AS included_60,
  s3_.excluded AS excluded_61,
  s3_.cannot_participate AS cannot_participate_62,
  s3_.to_bring AS to_bring_63,
  s3_.key_facts AS key_facts_64,
  s3_.map_image AS map_image_65,
  s3_.meeting_points AS meeting_points_66,
  s3_.guarantees AS guarantees_67,
  s3_.price AS price_68,
  s3_.reviews_score AS reviews_score_69,
  s3_.reviews_out_of AS reviews_out_of_70,
  s3_.reviews_total AS reviews_total_71,
  s3_.modal_title AS modal_title_72,
  s3_.id AS id_73,
  s3_.created_at AS created_at_74,
  s3_.updated_at AS updated_at_75,
  c4_.name AS name_76,
  c4_.slug AS slug_77,
  c4_.position AS position_78,
  c4_.id AS id_79,
  c4_.created_at AS created_at_80,
  c4_.updated_at AS updated_at_81,
  s0_.provider_id AS provider_id_82,
  s0_.category_id AS category_id_83,
  s0_.category_suggestion_id AS category_suggestion_id_84,
  s0_.destination_id AS destination_id_85,
  s1_.service_id AS service_id_86,
  m2_.service_id AS service_id_87,
  s3_.service_id AS service_id_88,
  c4_.parent_id AS parent_id_89
FROM
  service s0_
  LEFT JOIN service_package s1_ ON s0_.id = s1_.service_id
  LEFT JOIN media m2_ ON s0_.id = m2_.service_id
  LEFT JOIN service_detail s3_ ON s0_.id = s3_.service_id
  LEFT JOIN category c4_ ON s0_.category_id = c4_.id
WHERE
  s0_.slug = ?
  AND s0_.status = ?
  AND s0_.deleted_at IS NULL

SELECT s0_.title AS title_0, s0_.slug AS slug_1, s0_.description AS description_2, s0_.booking_type AS booking_type_3, s0_.status AS status_4, s0_.currency AS currency_5, s0_.short_description AS short_description_6, s0_.duration_minutes AS duration_minutes_7, s0_.place_label AS place_label_8, s0_.duration_label AS duration_label_9, s0_.badge AS badge_10, s0_.search_text AS search_text_11, s0_.search_place AS search_place_12, s0_.position AS position_13, s0_.rating_average AS rating_average_14, s0_.reviews_count AS reviews_count_15, s0_.views_count AS views_count_16, s0_.capacity AS capacity_17, s0_.level AS level_18, s0_.languages AS languages_19, s0_.included AS included_20, s0_.subtitle AS subtitle_21, s0_.activity_type AS activity_type_22, s0_.minimum_age AS minimum_age_23, s0_.programme AS programme_24, s0_.meeting_point AS meeting_point_25, s0_.opening_period AS opening_period_26, s0_.audience AS audience_27, s0_.cancellation_policy AS cancellation_policy_28, s0_.address AS address_29, s0_.city AS city_30, s0_.postal_code AS postal_code_31, s0_.country AS country_32, s0_.latitude AS latitude_33, s0_.longitude AS longitude_34, s0_.id AS id_35, s0_.created_at AS created_at_36, s0_.updated_at AS updated_at_37, s0_.deleted_at AS deleted_at_38, s1_.name AS name_39, s1_.description AS description_40, s1_.price AS price_41, s1_.currency AS currency_42, s1_.pricing_unit AS pricing_unit_43, s1_.delivery_days AS delivery_days_44, s1_.id AS id_45, s1_.created_at AS created_at_46, s1_.updated_at AS updated_at_47, m2_.path AS path_48, m2_.type AS type_49, m2_.position AS position_50, m2_.id AS id_51, m2_.created_at AS created_at_52, m2_.updated_at AS updated_at_53, s3_.breadcrumb AS breadcrumb_54, s3_.organizer AS organizer_55, s3_.presentation_subtitle AS presentation_subtitle_56, s3_.presentation_text AS presentation_text_57, s3_.highlights_title AS highlights_title_58, s3_.highlights AS highlights_59, s3_.included AS included_60, s3_.excluded AS excluded_61, s3_.cannot_participate AS cannot_participate_62, s3_.to_bring AS to_bring_63, s3_.key_facts AS key_facts_64, s3_.map_image AS map_image_65, s3_.meeting_points AS meeting_points_66, s3_.guarantees AS guarantees_67, s3_.price AS price_68, s3_.reviews_score AS reviews_score_69, s3_.reviews_out_of AS reviews_out_of_70, s3_.reviews_total AS reviews_total_71, s3_.modal_title AS modal_title_72, s3_.id AS id_73, s3_.created_at AS created_at_74, s3_.updated_at AS updated_at_75, c4_.name AS name_76, c4_.slug AS slug_77, c4_.position AS position_78, c4_.id AS id_79, c4_.created_at AS created_at_80, c4_.updated_at AS updated_at_81, s0_.provider_id AS provider_id_82, s0_.category_id AS category_id_83, s0_.category_suggestion_id AS category_suggestion_id_84, s0_.destination_id AS destination_id_85, s1_.service_id AS service_id_86, m2_.service_id AS service_id_87, s3_.service_id AS service_id_88, c4_.parent_id AS parent_id_89 FROM service s0_ LEFT JOIN service_package s1_ ON s0_.id = s1_.service_id LEFT JOIN media m2_ ON s0_.id = m2_.service_id LEFT JOIN service_detail s3_ ON s0_.id = s3_.service_id LEFT JOIN category c4_ ON s0_.category_id = c4_.id WHERE s0_.slug = 'escape-game-en-famille' AND s0_.status = 'published' AND s0_.deleted_at IS NULL;

SELECT
  CASE WHEN c0_.id = ? THEN
    0
  ELSE
    1
  END AS sclr_0,
  s1_.title AS title_1,
  s1_.slug AS slug_2,
  s1_.description AS description_3,
  s1_.booking_type AS booking_type_4,
  s1_.status AS status_5,
  s1_.currency AS currency_6,
  s1_.short_description AS short_description_7,
  s1_.duration_minutes AS duration_minutes_8,
  s1_.place_label AS place_label_9,
  s1_.duration_label AS duration_label_10,
  s1_.badge AS badge_11,
  s1_.search_text AS search_text_12,
  s1_.search_place AS search_place_13,
  s1_.position AS position_14,
  s1_.rating_average AS rating_average_15,
  s1_.reviews_count AS reviews_count_16,
  s1_.views_count AS views_count_17,
  s1_.capacity AS capacity_18,
  s1_.level AS level_19,
  s1_.languages AS languages_20,
  s1_.included AS included_21,
  s1_.subtitle AS subtitle_22,
  s1_.activity_type AS activity_type_23,
  s1_.minimum_age AS minimum_age_24,
  s1_.programme AS programme_25,
  s1_.meeting_point AS meeting_point_26,
  s1_.opening_period AS opening_period_27,
  s1_.audience AS audience_28,
  s1_.cancellation_policy AS cancellation_policy_29,
  s1_.address AS address_30,
  s1_.city AS city_31,
  s1_.postal_code AS postal_code_32,
  s1_.country AS country_33,
  s1_.latitude AS latitude_34,
  s1_.longitude AS longitude_35,
  s1_.id AS id_36,
  s1_.created_at AS created_at_37,
  s1_.updated_at AS updated_at_38,
  s1_.deleted_at AS deleted_at_39,
  s2_.name AS name_40,
  s2_.description AS description_41,
  s2_.price AS price_42,
  s2_.currency AS currency_43,
  s2_.pricing_unit AS pricing_unit_44,
  s2_.delivery_days AS delivery_days_45,
  s2_.id AS id_46,
  s2_.created_at AS created_at_47,
  s2_.updated_at AS updated_at_48,
  m3_.path AS path_49,
  m3_.type AS type_50,
  m3_.position AS position_51,
  m3_.id AS id_52,
  m3_.created_at AS created_at_53,
  m3_.updated_at AS updated_at_54,
  s4_.breadcrumb AS breadcrumb_55,
  s4_.organizer AS organizer_56,
  s4_.presentation_subtitle AS presentation_subtitle_57,
  s4_.presentation_text AS presentation_text_58,
  s4_.highlights_title AS highlights_title_59,
  s4_.highlights AS highlights_60,
  s4_.included AS included_61,
  s4_.excluded AS excluded_62,
  s4_.cannot_participate AS cannot_participate_63,
  s4_.to_bring AS to_bring_64,
  s4_.key_facts AS key_facts_65,
  s4_.map_image AS map_image_66,
  s4_.meeting_points AS meeting_points_67,
  s4_.guarantees AS guarantees_68,
  s4_.price AS price_69,
  s4_.reviews_score AS reviews_score_70,
  s4_.reviews_out_of AS reviews_out_of_71,
  s4_.reviews_total AS reviews_total_72,
  s4_.modal_title AS modal_title_73,
  s4_.id AS id_74,
  s4_.created_at AS created_at_75,
  s4_.updated_at AS updated_at_76,
  c0_.name AS name_77,
  c0_.slug AS slug_78,
  c0_.position AS position_79,
  c0_.id AS id_80,
  c0_.created_at AS created_at_81,
  c0_.updated_at AS updated_at_82,
  s1_.provider_id AS provider_id_83,
  s1_.category_id AS category_id_84,
  s1_.category_suggestion_id AS category_suggestion_id_85,
  s1_.destination_id AS destination_id_86,
  s2_.service_id AS service_id_87,
  m3_.service_id AS service_id_88,
  s4_.service_id AS service_id_89,
  c0_.parent_id AS parent_id_90
FROM
  service s1_
  LEFT JOIN service_package s2_ ON s1_.id = s2_.service_id
  LEFT JOIN media m3_ ON s1_.id = m3_.service_id
  LEFT JOIN service_detail s4_ ON s1_.id = s4_.service_id
  LEFT JOIN category c0_ ON s1_.category_id = c0_.id
WHERE
  s1_.status = ?
  AND s1_.deleted_at IS NULL
  AND s1_.id <> ?
  AND s1_.id IN (?, ?, ?, ?)
ORDER BY
  sclr_0 ASC,
  s1_.position ASC

SELECT CASE WHEN c0_.id = '01a1679a-9a26-e705-f90b-e668fabbc859' THEN 0 ELSE 1 END AS sclr_0, s1_.title AS title_1, s1_.slug AS slug_2, s1_.description AS description_3, s1_.booking_type AS booking_type_4, s1_.status AS status_5, s1_.currency AS currency_6, s1_.short_description AS short_description_7, s1_.duration_minutes AS duration_minutes_8, s1_.place_label AS place_label_9, s1_.duration_label AS duration_label_10, s1_.badge AS badge_11, s1_.search_text AS search_text_12, s1_.search_place AS search_place_13, s1_.position AS position_14, s1_.rating_average AS rating_average_15, s1_.reviews_count AS reviews_count_16, s1_.views_count AS views_count_17, s1_.capacity AS capacity_18, s1_.level AS level_19, s1_.languages AS languages_20, s1_.included AS included_21, s1_.subtitle AS subtitle_22, s1_.activity_type AS activity_type_23, s1_.minimum_age AS minimum_age_24, s1_.programme AS programme_25, s1_.meeting_point AS meeting_point_26, s1_.opening_period AS opening_period_27, s1_.audience AS audience_28, s1_.cancellation_policy AS cancellation_policy_29, s1_.address AS address_30, s1_.city AS city_31, s1_.postal_code AS postal_code_32, s1_.country AS country_33, s1_.latitude AS latitude_34, s1_.longitude AS longitude_35, s1_.id AS id_36, s1_.created_at AS created_at_37, s1_.updated_at AS updated_at_38, s1_.deleted_at AS deleted_at_39, s2_.name AS name_40, s2_.description AS description_41, s2_.price AS price_42, s2_.currency AS currency_43, s2_.pricing_unit AS pricing_unit_44, s2_.delivery_days AS delivery_days_45, s2_.id AS id_46, s2_.created_at AS created_at_47, s2_.updated_at AS updated_at_48, m3_.path AS path_49, m3_.type AS type_50, m3_.position AS position_51, m3_.id AS id_52, m3_.created_at AS created_at_53, m3_.updated_at AS updated_at_54, s4_.breadcrumb AS breadcrumb_55, s4_.organizer AS organizer_56, s4_.presentation_subtitle AS presentation_subtitle_57, s4_.presentation_text AS presentation_text_58, s4_.highlights_title AS highlights_title_59, s4_.highlights AS highlights_60, s4_.included AS included_61, s4_.excluded AS excluded_62, s4_.cannot_participate AS cannot_participate_63, s4_.to_bring AS to_bring_64, s4_.key_facts AS key_facts_65, s4_.map_image AS map_image_66, s4_.meeting_points AS meeting_points_67, s4_.guarantees AS guarantees_68, s4_.price AS price_69, s4_.reviews_score AS reviews_score_70, s4_.reviews_out_of AS reviews_out_of_71, s4_.reviews_total AS reviews_total_72, s4_.modal_title AS modal_title_73, s4_.id AS id_74, s4_.created_at AS created_at_75, s4_.updated_at AS updated_at_76, c0_.name AS name_77, c0_.slug AS slug_78, c0_.position AS position_79, c0_.id AS id_80, c0_.created_at AS created_at_81, c0_.updated_at AS updated_at_82, s1_.provider_id AS provider_id_83, s1_.category_id AS category_id_84, s1_.category_suggestion_id AS category_suggestion_id_85, s1_.destination_id AS destination_id_86, s2_.service_id AS service_id_87, m3_.service_id AS service_id_88, s4_.service_id AS service_id_89, c0_.parent_id AS parent_id_90 FROM service s1_ LEFT JOIN service_package s2_ ON s1_.id = s2_.service_id LEFT JOIN media m3_ ON s1_.id = m3_.service_id LEFT JOIN service_detail s4_ ON s1_.id = s4_.service_id LEFT JOIN category c0_ ON s1_.category_id = c0_.id WHERE s1_.status = 'published' AND s1_.deleted_at IS NULL AND s1_.id <> '01a1679a-9beb-e8cb-eca1-ed43dfe7a576' AND s1_.id IN ('01a1679a-9bf7-86ad-4fcf-4cb42ea9dc35', '01a1679a-9bf4-a186-c882-ab89c781c3de', '01a1679a-9bd6-acb5-364c-8beaee8fccc5', '01a1679a-9a2b-1f06-ef0a-1b6b19516601') ORDER BY sclr_0 ASC, s1_.position ASC;

SELECT
  DISTINCT id_36,
  MIN(sclr_83) AS dctrn_minrownum
FROM
  (
    SELECT
      CASE WHEN c0_.id = ? THEN
        0
      ELSE
        1
      END AS sclr_0,
      s1_.title AS title_1,
      s1_.slug AS slug_2,
      s1_.description AS description_3,
      s1_.booking_type AS booking_type_4,
      s1_.status AS status_5,
      s1_.currency AS currency_6,
      s1_.short_description AS short_description_7,
      s1_.duration_minutes AS duration_minutes_8,
      s1_.place_label AS place_label_9,
      s1_.duration_label AS duration_label_10,
      s1_.badge AS badge_11,
      s1_.search_text AS search_text_12,
      s1_.search_place AS search_place_13,
      s1_.position AS position_14,
      s1_.rating_average AS rating_average_15,
      s1_.reviews_count AS reviews_count_16,
      s1_.views_count AS views_count_17,
      s1_.capacity AS capacity_18,
      s1_.level AS level_19,
      s1_.languages AS languages_20,
      s1_.included AS included_21,
      s1_.subtitle AS subtitle_22,
      s1_.activity_type AS activity_type_23,
      s1_.minimum_age AS minimum_age_24,
      s1_.programme AS programme_25,
      s1_.meeting_point AS meeting_point_26,
      s1_.opening_period AS opening_period_27,
      s1_.audience AS audience_28,
      s1_.cancellation_policy AS cancellation_policy_29,
      s1_.address AS address_30,
      s1_.city AS city_31,
      s1_.postal_code AS postal_code_32,
      s1_.country AS country_33,
      s1_.latitude AS latitude_34,
      s1_.longitude AS longitude_35,
      s1_.id AS id_36,
      s1_.created_at AS created_at_37,
      s1_.updated_at AS updated_at_38,
      s1_.deleted_at AS deleted_at_39,
      s2_.name AS name_40,
      s2_.description AS description_41,
      s2_.price AS price_42,
      s2_.currency AS currency_43,
      s2_.pricing_unit AS pricing_unit_44,
      s2_.delivery_days AS delivery_days_45,
      s2_.id AS id_46,
      s2_.created_at AS created_at_47,
      s2_.updated_at AS updated_at_48,
      m3_.path AS path_49,
      m3_.type AS type_50,
      m3_.position AS position_51,
      m3_.id AS id_52,
      m3_.created_at AS created_at_53,
      m3_.updated_at AS updated_at_54,
      s4_.breadcrumb AS breadcrumb_55,
      s4_.organizer AS organizer_56,
      s4_.presentation_subtitle AS presentation_subtitle_57,
      s4_.presentation_text AS presentation_text_58,
      s4_.highlights_title AS highlights_title_59,
      s4_.highlights AS highlights_60,
      s4_.included AS included_61,
      s4_.excluded AS excluded_62,
      s4_.cannot_participate AS cannot_participate_63,
      s4_.to_bring AS to_bring_64,
      s4_.key_facts AS key_facts_65,
      s4_.map_image AS map_image_66,
      s4_.meeting_points AS meeting_points_67,
      s4_.guarantees AS guarantees_68,
      s4_.price AS price_69,
      s4_.reviews_score AS reviews_score_70,
      s4_.reviews_out_of AS reviews_out_of_71,
      s4_.reviews_total AS reviews_total_72,
      s4_.modal_title AS modal_title_73,
      s4_.id AS id_74,
      s4_.created_at AS created_at_75,
      s4_.updated_at AS updated_at_76,
      c0_.name AS name_77,
      c0_.slug AS slug_78,
      c0_.position AS position_79,
      c0_.id AS id_80,
      c0_.created_at AS created_at_81,
      c0_.updated_at AS updated_at_82,
      ROW_NUMBER() OVER(
        ORDER BY
          CASE WHEN c0_.id = ? THEN
            0
          ELSE
            1
          END ASC,
          s1_.position ASC
      ) AS sclr_83
    FROM
      service s1_
      LEFT JOIN service_package s2_ ON s1_.id = s2_.service_id
      LEFT JOIN media m3_ ON s1_.id = m3_.service_id
      LEFT JOIN service_detail s4_ ON s1_.id = s4_.service_id
      LEFT JOIN category c0_ ON s1_.category_id = c0_.id
    WHERE
      s1_.status = ?
      AND s1_.deleted_at IS NULL
      AND s1_.id <> ?
  ) dctrn_result
GROUP BY
  id_36
ORDER BY
  dctrn_minrownum ASC
LIMIT
  4

SELECT DISTINCT id_36, MIN(sclr_83) AS dctrn_minrownum FROM (SELECT CASE WHEN c0_.id = '01a1679a-9a26-e705-f90b-e668fabbc859' THEN 0 ELSE 1 END AS sclr_0, s1_.title AS title_1, s1_.slug AS slug_2, s1_.description AS description_3, s1_.booking_type AS booking_type_4, s1_.status AS status_5, s1_.currency AS currency_6, s1_.short_description AS short_description_7, s1_.duration_minutes AS duration_minutes_8, s1_.place_label AS place_label_9, s1_.duration_label AS duration_label_10, s1_.badge AS badge_11, s1_.search_text AS search_text_12, s1_.search_place AS search_place_13, s1_.position AS position_14, s1_.rating_average AS rating_average_15, s1_.reviews_count AS reviews_count_16, s1_.views_count AS views_count_17, s1_.capacity AS capacity_18, s1_.level AS level_19, s1_.languages AS languages_20, s1_.included AS included_21, s1_.subtitle AS subtitle_22, s1_.activity_type AS activity_type_23, s1_.minimum_age AS minimum_age_24, s1_.programme AS programme_25, s1_.meeting_point AS meeting_point_26, s1_.opening_period AS opening_period_27, s1_.audience AS audience_28, s1_.cancellation_policy AS cancellation_policy_29, s1_.address AS address_30, s1_.city AS city_31, s1_.postal_code AS postal_code_32, s1_.country AS country_33, s1_.latitude AS latitude_34, s1_.longitude AS longitude_35, s1_.id AS id_36, s1_.created_at AS created_at_37, s1_.updated_at AS updated_at_38, s1_.deleted_at AS deleted_at_39, s2_.name AS name_40, s2_.description AS description_41, s2_.price AS price_42, s2_.currency AS currency_43, s2_.pricing_unit AS pricing_unit_44, s2_.delivery_days AS delivery_days_45, s2_.id AS id_46, s2_.created_at AS created_at_47, s2_.updated_at AS updated_at_48, m3_.path AS path_49, m3_.type AS type_50, m3_.position AS position_51, m3_.id AS id_52, m3_.created_at AS created_at_53, m3_.updated_at AS updated_at_54, s4_.breadcrumb AS breadcrumb_55, s4_.organizer AS organizer_56, s4_.presentation_subtitle AS presentation_subtitle_57, s4_.presentation_text AS presentation_text_58, s4_.highlights_title AS highlights_title_59, s4_.highlights AS highlights_60, s4_.included AS included_61, s4_.excluded AS excluded_62, s4_.cannot_participate AS cannot_participate_63, s4_.to_bring AS to_bring_64, s4_.key_facts AS key_facts_65, s4_.map_image AS map_image_66, s4_.meeting_points AS meeting_points_67, s4_.guarantees AS guarantees_68, s4_.price AS price_69, s4_.reviews_score AS reviews_score_70, s4_.reviews_out_of AS reviews_out_of_71, s4_.reviews_total AS reviews_total_72, s4_.modal_title AS modal_title_73, s4_.id AS id_74, s4_.created_at AS created_at_75, s4_.updated_at AS updated_at_76, c0_.name AS name_77, c0_.slug AS slug_78, c0_.position AS position_79, c0_.id AS id_80, c0_.created_at AS created_at_81, c0_.updated_at AS updated_at_82, ROW_NUMBER() OVER(ORDER BY CASE WHEN c0_.id = '01a1679a-9a26-e705-f90b-e668fabbc859' THEN 0 ELSE 1 END ASC, s1_.position ASC) AS sclr_83 FROM service s1_ LEFT JOIN service_package s2_ ON s1_.id = s2_.service_id LEFT JOIN media m3_ ON s1_.id = m3_.service_id LEFT JOIN service_detail s4_ ON s1_.id = s4_.service_id LEFT JOIN category c0_ ON s1_.category_id = c0_.id WHERE s1_.status = 'published' AND s1_.deleted_at IS NULL AND s1_.id <> '01a1679a-9beb-e8cb-eca1-ed43dfe7a576') dctrn_result GROUP BY id_36 ORDER BY dctrn_minrownum ASC LIMIT 4;

SELECT
  s0_.title AS title_0,
  s0_.slug AS slug_1,
  s0_.description AS description_2,
  s0_.booking_type AS booking_type_3,
  s0_.status AS status_4,
  s0_.currency AS currency_5,
  s0_.short_description AS short_description_6,
  s0_.duration_minutes AS duration_minutes_7,
  s0_.place_label AS place_label_8,
  s0_.duration_label AS duration_label_9,
  s0_.badge AS badge_10,
  s0_.search_text AS search_text_11,
  s0_.search_place AS search_place_12,
  s0_.position AS position_13,
  s0_.rating_average AS rating_average_14,
  s0_.reviews_count AS reviews_count_15,
  s0_.views_count AS views_count_16,
  s0_.capacity AS capacity_17,
  s0_.level AS level_18,
  s0_.languages AS languages_19,
  s0_.included AS included_20,
  s0_.subtitle AS subtitle_21,
  s0_.activity_type AS activity_type_22,
  s0_.minimum_age AS minimum_age_23,
  s0_.programme AS programme_24,
  s0_.meeting_point AS meeting_point_25,
  s0_.opening_period AS opening_period_26,
  s0_.audience AS audience_27,
  s0_.cancellation_policy AS cancellation_policy_28,
  s0_.address AS address_29,
  s0_.city AS city_30,
  s0_.postal_code AS postal_code_31,
  s0_.country AS country_32,
  s0_.latitude AS latitude_33,
  s0_.longitude AS longitude_34,
  s0_.id AS id_35,
  s0_.created_at AS created_at_36,
  s0_.updated_at AS updated_at_37,
  s0_.deleted_at AS deleted_at_38,
  c1_.name AS name_39,
  c1_.slug AS slug_40,
  c1_.position AS position_41,
  c1_.id AS id_42,
  c1_.created_at AS created_at_43,
  c1_.updated_at AS updated_at_44,
  m2_.path AS path_45,
  m2_.type AS type_46,
  m2_.position AS position_47,
  m2_.id AS id_48,
  m2_.created_at AS created_at_49,
  m2_.updated_at AS updated_at_50,
  s3_.name AS name_51,
  s3_.description AS description_52,
  s3_.price AS price_53,
  s3_.currency AS currency_54,
  s3_.pricing_unit AS pricing_unit_55,
  s3_.delivery_days AS delivery_days_56,
  s3_.id AS id_57,
  s3_.created_at AS created_at_58,
  s3_.updated_at AS updated_at_59,
  s0_.provider_id AS provider_id_60,
  s0_.category_id AS category_id_61,
  s0_.category_suggestion_id AS category_suggestion_id_62,
  s0_.destination_id AS destination_id_63,
  c1_.parent_id AS parent_id_64,
  m2_.service_id AS service_id_65,
  s3_.service_id AS service_id_66
FROM
  service s0_
  LEFT JOIN category c1_ ON s0_.category_id = c1_.id
  LEFT JOIN media m2_ ON s0_.id = m2_.service_id
  LEFT JOIN service_package s3_ ON s0_.id = s3_.service_id
WHERE
  s0_.provider_id = ?
  AND s0_.deleted_at IS NULL
ORDER BY
  s0_.created_at DESC

SELECT s0_.title AS title_0, s0_.slug AS slug_1, s0_.description AS description_2, s0_.booking_type AS booking_type_3, s0_.status AS status_4, s0_.currency AS currency_5, s0_.short_description AS short_description_6, s0_.duration_minutes AS duration_minutes_7, s0_.place_label AS place_label_8, s0_.duration_label AS duration_label_9, s0_.badge AS badge_10, s0_.search_text AS search_text_11, s0_.search_place AS search_place_12, s0_.position AS position_13, s0_.rating_average AS rating_average_14, s0_.reviews_count AS reviews_count_15, s0_.views_count AS views_count_16, s0_.capacity AS capacity_17, s0_.level AS level_18, s0_.languages AS languages_19, s0_.included AS included_20, s0_.subtitle AS subtitle_21, s0_.activity_type AS activity_type_22, s0_.minimum_age AS minimum_age_23, s0_.programme AS programme_24, s0_.meeting_point AS meeting_point_25, s0_.opening_period AS opening_period_26, s0_.audience AS audience_27, s0_.cancellation_policy AS cancellation_policy_28, s0_.address AS address_29, s0_.city AS city_30, s0_.postal_code AS postal_code_31, s0_.country AS country_32, s0_.latitude AS latitude_33, s0_.longitude AS longitude_34, s0_.id AS id_35, s0_.created_at AS created_at_36, s0_.updated_at AS updated_at_37, s0_.deleted_at AS deleted_at_38, c1_.name AS name_39, c1_.slug AS slug_40, c1_.position AS position_41, c1_.id AS id_42, c1_.created_at AS created_at_43, c1_.updated_at AS updated_at_44, m2_.path AS path_45, m2_.type AS type_46, m2_.position AS position_47, m2_.id AS id_48, m2_.created_at AS created_at_49, m2_.updated_at AS updated_at_50, s3_.name AS name_51, s3_.description AS description_52, s3_.price AS price_53, s3_.currency AS currency_54, s3_.pricing_unit AS pricing_unit_55, s3_.delivery_days AS delivery_days_56, s3_.id AS id_57, s3_.created_at AS created_at_58, s3_.updated_at AS updated_at_59, s0_.provider_id AS provider_id_60, s0_.category_id AS category_id_61, s0_.category_suggestion_id AS category_suggestion_id_62, s0_.destination_id AS destination_id_63, c1_.parent_id AS parent_id_64, m2_.service_id AS service_id_65, s3_.service_id AS service_id_66 FROM service s0_ LEFT JOIN category c1_ ON s0_.category_id = c1_.id LEFT JOIN media m2_ ON s0_.id = m2_.service_id LEFT JOIN service_package s3_ ON s0_.id = s3_.service_id WHERE s0_.provider_id = '01a1679a-9be5-7c27-c95d-7709d0b72580' AND s0_.deleted_at IS NULL ORDER BY s0_.created_at DESC;

SELECT
  p0_.title AS title_0,
  p0_.subtitle AS subtitle_1,
  p0_.kind AS kind_2,
  p0_.discount_percent AS discount_percent_3,
  p0_.starts_at AS starts_at_4,
  p0_.ends_at AS ends_at_5,
  p0_.paused AS paused_6,
  p0_.views_count AS views_count_7,
  p0_.clicks_count AS clicks_count_8,
  p0_.id AS id_9,
  p0_.created_at AS created_at_10,
  p0_.updated_at AS updated_at_11,
  p0_.deleted_at AS deleted_at_12,
  COALESCE(p0_.discount_percent, 0) AS sclr_13,
  p0_.provider_id AS provider_id_14,
  p0_.service_id AS service_id_15
FROM
  promotion p0_
WHERE
  p0_.provider_id = ?
  AND (
    p0_.service_id = ?
    OR p0_.service_id IS NULL
  )
  AND p0_.deleted_at IS NULL
  AND p0_.paused = false
  AND (
    p0_.starts_at <= ?
    AND p0_.ends_at >= ?
  )
ORDER BY
  sclr_13 DESC
LIMIT
  1

SELECT p0_.title AS title_0, p0_.subtitle AS subtitle_1, p0_.kind AS kind_2, p0_.discount_percent AS discount_percent_3, p0_.starts_at AS starts_at_4, p0_.ends_at AS ends_at_5, p0_.paused AS paused_6, p0_.views_count AS views_count_7, p0_.clicks_count AS clicks_count_8, p0_.id AS id_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p0_.deleted_at AS deleted_at_12, COALESCE(p0_.discount_percent, 0) AS sclr_13, p0_.provider_id AS provider_id_14, p0_.service_id AS service_id_15 FROM promotion p0_ WHERE p0_.provider_id = '01a1679a-9be5-7c27-c95d-7709d0b72580' AND (p0_.service_id = '01a1679a-9beb-e8cb-eca1-ed43dfe7a576' OR p0_.service_id IS NULL) AND p0_.deleted_at IS NULL AND p0_.paused = false AND (p0_.starts_at <= '2026-11-06 17:13:47' AND p0_.ends_at >= '2026-11-06 17:13:47') ORDER BY sclr_13 DESC LIMIT 1;