Symfony Profiler

SET
  TIME ZONE 'Europe/Paris'

SET TIME ZONE 'Europe/Paris';

SELECT
  COUNT(DISTINCT s0_.id) AS sclr_0
FROM
  service s0_
  LEFT JOIN category c1_ ON s0_.category_id = c1_.id
WHERE
  s0_.status = ?
  AND s0_.deleted_at IS NULL

SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM service s0_ LEFT JOIN category c1_ ON s0_.category_id = c1_.id WHERE s0_.status = 'published' AND s0_.deleted_at IS NULL;

SELECT
  s0_.id AS id_0
FROM
  service s0_
  LEFT JOIN category c1_ ON s0_.category_id = c1_.id
WHERE
  s0_.status = ?
  AND s0_.deleted_at IS NULL
GROUP BY
  s0_.id
ORDER BY
  s0_.position ASC,
  s0_.rating_average DESC,
  s0_.reviews_count DESC,
  s0_.id ASC
LIMIT
  8

SELECT s0_.id AS id_0 FROM service s0_ LEFT JOIN category c1_ ON s0_.category_id = c1_.id WHERE s0_.status = 'published' AND s0_.deleted_at IS NULL GROUP BY s0_.id ORDER BY s0_.position ASC, s0_.rating_average DESC, s0_.reviews_count DESC, s0_.id ASC LIMIT 8;

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_.id IN (?, ?, ?, ?, ?, ?, ?, ?)

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_.id IN ('01a1679a-9bf7-86ad-4fcf-4cb42ea9dc35', '01a1679a-9a2b-1f06-ef0a-1b6b19516601', '01a1679a-9bd6-acb5-364c-8beaee8fccc5', '01a1679a-9c01-0a19-6cfb-e2309e29f1a2', '01a1679a-9beb-e8cb-eca1-ed43dfe7a576', '01a1679a-9bf4-a186-c882-ab89c781c3de', '01a1679a-9bde-36f1-8f49-853551a12281', '01a1679a-9bd8-6189-cc37-7c86f9872919');

SELECT
  p0_.title AS title_0,
  p0_.description AS description_1,
  p0_.scheduled_at AS scheduled_at_2,
  p0_.city AS city_3,
  p0_.location AS location_4,
  p0_.show_exact_address AS show_exact_address_5,
  p0_.ends_at AS ends_at_6,
  p0_.postal_code AS postal_code_7,
  p0_.latitude AS latitude_8,
  p0_.longitude AS longitude_9,
  p0_.meeting_point AS meeting_point_10,
  p0_.to_bring AS to_bring_11,
  p0_.cover_image AS cover_image_12,
  p0_.visibility AS visibility_13,
  p0_.participation_mode AS participation_mode_14,
  p0_.status AS status_15,
  p0_.level AS level_16,
  p0_.min_participants AS min_participants_17,
  p0_.max_participants AS max_participants_18,
  p0_.views_count AS views_count_19,
  p0_.id AS id_20,
  p0_.created_at AS created_at_21,
  p0_.updated_at AS updated_at_22,
  c1_.name AS name_23,
  c1_.slug AS slug_24,
  c1_.position AS position_25,
  c1_.id AS id_26,
  c1_.created_at AS created_at_27,
  c1_.updated_at AS updated_at_28,
  p0_.organizer_id AS organizer_id_29,
  p0_.category_id AS category_id_30,
  p0_.category_suggestion_id AS category_suggestion_id_31,
  p0_.service_id AS service_id_32,
  c1_.parent_id AS parent_id_33
FROM
  private_activity p0_
  LEFT JOIN category c1_ ON p0_.category_id = c1_.id
WHERE
  p0_.visibility IN (?)
  AND p0_.status NOT IN (?, ?, ?)
  AND (
    p0_.scheduled_at IS NULL
    OR p0_.scheduled_at >= ?
  )
ORDER BY
  p0_.scheduled_at ASC
LIMIT
  8

SELECT p0_.title AS title_0, p0_.description AS description_1, p0_.scheduled_at AS scheduled_at_2, p0_.city AS city_3, p0_.location AS location_4, p0_.show_exact_address AS show_exact_address_5, p0_.ends_at AS ends_at_6, p0_.postal_code AS postal_code_7, p0_.latitude AS latitude_8, p0_.longitude AS longitude_9, p0_.meeting_point AS meeting_point_10, p0_.to_bring AS to_bring_11, p0_.cover_image AS cover_image_12, p0_.visibility AS visibility_13, p0_.participation_mode AS participation_mode_14, p0_.status AS status_15, p0_.level AS level_16, p0_.min_participants AS min_participants_17, p0_.max_participants AS max_participants_18, p0_.views_count AS views_count_19, p0_.id AS id_20, p0_.created_at AS created_at_21, p0_.updated_at AS updated_at_22, c1_.name AS name_23, c1_.slug AS slug_24, c1_.position AS position_25, c1_.id AS id_26, c1_.created_at AS created_at_27, c1_.updated_at AS updated_at_28, p0_.organizer_id AS organizer_id_29, p0_.category_id AS category_id_30, p0_.category_suggestion_id AS category_suggestion_id_31, p0_.service_id AS service_id_32, c1_.parent_id AS parent_id_33 FROM private_activity p0_ LEFT JOIN category c1_ ON p0_.category_id = c1_.id WHERE p0_.visibility IN ('public') AND p0_.status NOT IN ('cancelled', 'draft', 'pending_category') AND (p0_.scheduled_at IS NULL OR p0_.scheduled_at >= '2026-11-07 00:36:59') ORDER BY p0_.scheduled_at ASC LIMIT 8;

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  event e0_
  LEFT JOIN event_category e1_ ON e0_.category_id = e1_.id
WHERE
  e0_.deleted_at IS NULL
  AND e0_.private = false
  AND (
    (
      e0_.status = 'published'
      OR (
        e0_.status = 'scheduled'
        AND e0_.publish_at <= ?
      )
    )
  )
  AND COALESCE(e0_.ends_at, e0_.starts_at) >= ?
  AND e0_.visibility = 'public'

SELECT COUNT(e0_.id) AS sclr_0 FROM event e0_ LEFT JOIN event_category e1_ ON e0_.category_id = e1_.id WHERE e0_.deleted_at IS NULL AND e0_.private = false AND ((e0_.status = 'published' OR (e0_.status = 'scheduled' AND e0_.publish_at <= '2026-11-07 00:36:59'))) AND COALESCE(e0_.ends_at, e0_.starts_at) >= '2026-11-07 00:00:00' AND e0_.visibility = 'public';

SELECT
  e0_.title AS title_0,
  e0_.slug AS slug_1,
  e0_.image_path AS image_path_2,
  e0_.location AS location_3,
  e0_.description AS description_4,
  e0_.starts_at AS starts_at_5,
  e0_.ends_at AS ends_at_6,
  e0_.participants_count AS participants_count_7,
  e0_.private AS private_8,
  e0_.position AS position_9,
  e0_.status AS status_10,
  e0_.publish_at AS publish_at_11,
  e0_.event_type AS event_type_12,
  e0_.visibility AS visibility_13,
  e0_.short_description AS short_description_14,
  e0_.date_mode AS date_mode_15,
  e0_.recurrence AS recurrence_16,
  e0_.all_day AS all_day_17,
  e0_.timezone AS timezone_18,
  e0_.reminder AS reminder_19,
  e0_.show_in_calendar AS show_in_calendar_20,
  e0_.arrival_time AS arrival_time_21,
  e0_.location_type AS location_type_22,
  e0_.address AS address_23,
  e0_.city AS city_24,
  e0_.postal_code AS postal_code_25,
  e0_.latitude AS latitude_26,
  e0_.longitude AS longitude_27,
  e0_.online_url AS online_url_28,
  e0_.access_instructions AS access_instructions_29,
  e0_.meeting_point AS meeting_point_30,
  e0_.gallery AS gallery_31,
  e0_.registration_required AS registration_required_32,
  e0_.capacity AS capacity_33,
  e0_.waitlist AS waitlist_34,
  e0_.show_participants AS show_participants_35,
  e0_.allow_guest_invites AS allow_guest_invites_36,
  e0_.comments_enabled AS comments_enabled_37,
  e0_.email_updates AS email_updates_38,
  e0_.id AS id_39,
  e0_.created_at AS created_at_40,
  e0_.updated_at AS updated_at_41,
  e0_.deleted_at AS deleted_at_42,
  e1_.name AS name_43,
  e1_.slug AS slug_44,
  e1_.color AS color_45,
  e1_.position AS position_46,
  e1_.id AS id_47,
  e1_.created_at AS created_at_48,
  e1_.updated_at AS updated_at_49,
  e0_.category_id AS category_id_50,
  e0_.organizer_id AS organizer_id_51
FROM
  event e0_
  LEFT JOIN event_category e1_ ON e0_.category_id = e1_.id
WHERE
  e0_.deleted_at IS NULL
  AND e0_.private = false
  AND (
    (
      e0_.status = 'published'
      OR (
        e0_.status = 'scheduled'
        AND e0_.publish_at <= ?
      )
    )
  )
  AND COALESCE(e0_.ends_at, e0_.starts_at) >= ?
  AND e0_.visibility = 'public'
ORDER BY
  e0_.starts_at ASC
LIMIT
  4

SELECT e0_.title AS title_0, e0_.slug AS slug_1, e0_.image_path AS image_path_2, e0_.location AS location_3, e0_.description AS description_4, e0_.starts_at AS starts_at_5, e0_.ends_at AS ends_at_6, e0_.participants_count AS participants_count_7, e0_.private AS private_8, e0_.position AS position_9, e0_.status AS status_10, e0_.publish_at AS publish_at_11, e0_.event_type AS event_type_12, e0_.visibility AS visibility_13, e0_.short_description AS short_description_14, e0_.date_mode AS date_mode_15, e0_.recurrence AS recurrence_16, e0_.all_day AS all_day_17, e0_.timezone AS timezone_18, e0_.reminder AS reminder_19, e0_.show_in_calendar AS show_in_calendar_20, e0_.arrival_time AS arrival_time_21, e0_.location_type AS location_type_22, e0_.address AS address_23, e0_.city AS city_24, e0_.postal_code AS postal_code_25, e0_.latitude AS latitude_26, e0_.longitude AS longitude_27, e0_.online_url AS online_url_28, e0_.access_instructions AS access_instructions_29, e0_.meeting_point AS meeting_point_30, e0_.gallery AS gallery_31, e0_.registration_required AS registration_required_32, e0_.capacity AS capacity_33, e0_.waitlist AS waitlist_34, e0_.show_participants AS show_participants_35, e0_.allow_guest_invites AS allow_guest_invites_36, e0_.comments_enabled AS comments_enabled_37, e0_.email_updates AS email_updates_38, e0_.id AS id_39, e0_.created_at AS created_at_40, e0_.updated_at AS updated_at_41, e0_.deleted_at AS deleted_at_42, e1_.name AS name_43, e1_.slug AS slug_44, e1_.color AS color_45, e1_.position AS position_46, e1_.id AS id_47, e1_.created_at AS created_at_48, e1_.updated_at AS updated_at_49, e0_.category_id AS category_id_50, e0_.organizer_id AS organizer_id_51 FROM event e0_ LEFT JOIN event_category e1_ ON e0_.category_id = e1_.id WHERE e0_.deleted_at IS NULL AND e0_.private = false AND ((e0_.status = 'published' OR (e0_.status = 'scheduled' AND e0_.publish_at <= '2026-11-07 00:36:59'))) AND COALESCE(e0_.ends_at, e0_.starts_at) >= '2026-11-07 00:00:00' AND e0_.visibility = 'public' ORDER BY e0_.starts_at ASC LIMIT 4;

SELECT
  d0_.name AS name_0,
  d0_.slug AS slug_1,
  d0_.country AS country_2,
  d0_.region AS region_3,
  d0_.description AS description_4,
  d0_.hero_image AS hero_image_5,
  d0_.tagline AS tagline_6,
  d0_.rating_average AS rating_average_7,
  d0_.reviews_count AS reviews_count_8,
  d0_.activities_count AS activities_count_9,
  d0_.price_from AS price_from_10,
  d0_.badge AS badge_11,
  d0_.search_text AS search_text_12,
  d0_.position AS position_13,
  d0_.id AS id_14,
  d0_.created_at AS created_at_15,
  d0_.updated_at AS updated_at_16
FROM
  destination d0_
ORDER BY
  d0_.position ASC,
  d0_.created_at ASC
LIMIT
  10

SELECT d0_.name AS name_0, d0_.slug AS slug_1, d0_.country AS country_2, d0_.region AS region_3, d0_.description AS description_4, d0_.hero_image AS hero_image_5, d0_.tagline AS tagline_6, d0_.rating_average AS rating_average_7, d0_.reviews_count AS reviews_count_8, d0_.activities_count AS activities_count_9, d0_.price_from AS price_from_10, d0_.badge AS badge_11, d0_.search_text AS search_text_12, d0_.position AS position_13, d0_.id AS id_14, d0_.created_at AS created_at_15, d0_.updated_at AS updated_at_16 FROM destination d0_ ORDER BY d0_.position ASC, d0_.created_at ASC LIMIT 10;

SELECT
  DISTINCT s0_.place_label AS place_label_0
FROM
  service s0_
WHERE
  s0_.status = ?
  AND s0_.deleted_at IS NULL
  AND s0_.place_label IS NOT NULL
ORDER BY
  s0_.place_label ASC
LIMIT
  9

SELECT DISTINCT s0_.place_label AS place_label_0 FROM service s0_ WHERE s0_.status = 'published' AND s0_.deleted_at IS NULL AND s0_.place_label IS NOT NULL ORDER BY s0_.place_label ASC LIMIT 9;

SELECT
  s0_.title AS title_0
FROM
  service s0_
WHERE
  s0_.status = ?
  AND s0_.deleted_at IS NULL
ORDER BY
  s0_.position ASC
LIMIT
  9

SELECT s0_.title AS title_0 FROM service s0_ WHERE s0_.status = 'published' AND s0_.deleted_at IS NULL ORDER BY s0_.position ASC LIMIT 9;