Symfony Profiler

SET
  TIME ZONE 'Europe/Paris'

SET TIME ZONE 'Europe/Paris';

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

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;

SELECT
  AVG(r0_.rating) AS sclr_0
FROM
  review r0_
WHERE
  r0_.status = ?

SELECT AVG(r0_.rating) AS sclr_0 FROM review r0_ WHERE r0_.status = 'published';

SELECT
  COUNT(s0_.id) AS sclr_0
FROM
  service s0_
WHERE
  s0_.status = ?
  AND s0_.deleted_at IS NULL

SELECT COUNT(s0_.id) AS sclr_0 FROM service s0_ WHERE s0_.status = 'published' AND s0_.deleted_at IS NULL;

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  private_activity p0_
WHERE
  p0_.status IN (?, ?)
  AND p0_.scheduled_at >= ?

SELECT COUNT(p0_.id) AS sclr_0 FROM private_activity p0_ WHERE p0_.status IN ('open', 'full') AND p0_.scheduled_at >= '2026-11-06 16:25:33';

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  provider_profile p0_
WHERE
  p0_.status = ?

SELECT COUNT(p0_.id) AS sclr_0 FROM provider_profile p0_ WHERE p0_.status = 'verified';

SELECT
  COUNT(u0_.id) AS sclr_0
FROM
  "user" u0_

SELECT COUNT(u0_.id) AS sclr_0 FROM "user" u0_;

SELECT
  COUNT(d0_.id) AS sclr_0
FROM
  destination d0_

SELECT COUNT(d0_.id) AS sclr_0 FROM destination d0_;

SELECT
  COUNT(r0_.id) AS sclr_0
FROM
  review r0_
WHERE
  r0_.status = ?

SELECT COUNT(r0_.id) AS sclr_0 FROM review r0_ WHERE r0_.status = 'published';

SELECT
  t0.rating AS rating_1,
  t0.comment AS comment_2,
  t0.status AS status_3,
  t0.provider_reply AS provider_reply_4,
  t0.replied_at AS replied_at_5,
  t0.id AS id_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.author_id AS author_id_9,
  t0.provider_id AS provider_id_10,
  t0.quote_id AS quote_id_11,
  t0.booking_id AS booking_id_12,
  t0.service_id AS service_id_13
FROM
  review t0
WHERE
  t0.status = ?
ORDER BY
  t0.created_at DESC
LIMIT
  6

SELECT t0.rating AS rating_1, t0.comment AS comment_2, t0.status AS status_3, t0.provider_reply AS provider_reply_4, t0.replied_at AS replied_at_5, t0.id AS id_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.author_id AS author_id_9, t0.provider_id AS provider_id_10, t0.quote_id AS quote_id_11, t0.booking_id AS booking_id_12, t0.service_id AS service_id_13 FROM review t0 WHERE t0.status = 'published' ORDER BY t0.created_at DESC LIMIT 6;

SELECT
  t0.title AS title_1,
  t0.slug AS slug_2,
  t0.description AS description_3,
  t0.booking_type AS booking_type_4,
  t0.status AS status_5,
  t0.currency AS currency_6,
  t0.short_description AS short_description_7,
  t0.duration_minutes AS duration_minutes_8,
  t0.place_label AS place_label_9,
  t0.duration_label AS duration_label_10,
  t0.badge AS badge_11,
  t0.search_text AS search_text_12,
  t0.search_place AS search_place_13,
  t0.position AS position_14,
  t0.rating_average AS rating_average_15,
  t0.reviews_count AS reviews_count_16,
  t0.views_count AS views_count_17,
  t0.capacity AS capacity_18,
  t0.level AS level_19,
  t0.languages AS languages_20,
  t0.included AS included_21,
  t0.subtitle AS subtitle_22,
  t0.activity_type AS activity_type_23,
  t0.minimum_age AS minimum_age_24,
  t0.programme AS programme_25,
  t0.meeting_point AS meeting_point_26,
  t0.opening_period AS opening_period_27,
  t0.audience AS audience_28,
  t0.cancellation_policy AS cancellation_policy_29,
  t0.address AS address_30,
  t0.city AS city_31,
  t0.postal_code AS postal_code_32,
  t0.country AS country_33,
  t0.latitude AS latitude_34,
  t0.longitude AS longitude_35,
  t0.id AS id_36,
  t0.created_at AS created_at_37,
  t0.updated_at AS updated_at_38,
  t0.deleted_at AS deleted_at_39,
  t0.provider_id AS provider_id_40,
  t0.category_id AS category_id_41,
  t0.category_suggestion_id AS category_suggestion_id_42,
  t43.breadcrumb AS breadcrumb_44,
  t43.organizer AS organizer_45,
  t43.presentation_subtitle AS presentation_subtitle_46,
  t43.presentation_text AS presentation_text_47,
  t43.highlights_title AS highlights_title_48,
  t43.highlights AS highlights_49,
  t43.included AS included_50,
  t43.excluded AS excluded_51,
  t43.cannot_participate AS cannot_participate_52,
  t43.to_bring AS to_bring_53,
  t43.key_facts AS key_facts_54,
  t43.map_image AS map_image_55,
  t43.meeting_points AS meeting_points_56,
  t43.guarantees AS guarantees_57,
  t43.price AS price_58,
  t43.reviews_score AS reviews_score_59,
  t43.reviews_out_of AS reviews_out_of_60,
  t43.reviews_total AS reviews_total_61,
  t43.modal_title AS modal_title_62,
  t43.id AS id_63,
  t43.created_at AS created_at_64,
  t43.updated_at AS updated_at_65,
  t43.service_id AS service_id_66,
  t0.destination_id AS destination_id_67
FROM
  service t0
  LEFT JOIN service_detail t43 ON t43.service_id = t0.id
WHERE
  t0.id = ?

SELECT t0.title AS title_1, t0.slug AS slug_2, t0.description AS description_3, t0.booking_type AS booking_type_4, t0.status AS status_5, t0.currency AS currency_6, t0.short_description AS short_description_7, t0.duration_minutes AS duration_minutes_8, t0.place_label AS place_label_9, t0.duration_label AS duration_label_10, t0.badge AS badge_11, t0.search_text AS search_text_12, t0.search_place AS search_place_13, t0.position AS position_14, t0.rating_average AS rating_average_15, t0.reviews_count AS reviews_count_16, t0.views_count AS views_count_17, t0.capacity AS capacity_18, t0.level AS level_19, t0.languages AS languages_20, t0.included AS included_21, t0.subtitle AS subtitle_22, t0.activity_type AS activity_type_23, t0.minimum_age AS minimum_age_24, t0.programme AS programme_25, t0.meeting_point AS meeting_point_26, t0.opening_period AS opening_period_27, t0.audience AS audience_28, t0.cancellation_policy AS cancellation_policy_29, t0.address AS address_30, t0.city AS city_31, t0.postal_code AS postal_code_32, t0.country AS country_33, t0.latitude AS latitude_34, t0.longitude AS longitude_35, t0.id AS id_36, t0.created_at AS created_at_37, t0.updated_at AS updated_at_38, t0.deleted_at AS deleted_at_39, t0.provider_id AS provider_id_40, t0.category_id AS category_id_41, t0.category_suggestion_id AS category_suggestion_id_42, t43.breadcrumb AS breadcrumb_44, t43.organizer AS organizer_45, t43.presentation_subtitle AS presentation_subtitle_46, t43.presentation_text AS presentation_text_47, t43.highlights_title AS highlights_title_48, t43.highlights AS highlights_49, t43.included AS included_50, t43.excluded AS excluded_51, t43.cannot_participate AS cannot_participate_52, t43.to_bring AS to_bring_53, t43.key_facts AS key_facts_54, t43.map_image AS map_image_55, t43.meeting_points AS meeting_points_56, t43.guarantees AS guarantees_57, t43.price AS price_58, t43.reviews_score AS reviews_score_59, t43.reviews_out_of AS reviews_out_of_60, t43.reviews_total AS reviews_total_61, t43.modal_title AS modal_title_62, t43.id AS id_63, t43.created_at AS created_at_64, t43.updated_at AS updated_at_65, t43.service_id AS service_id_66, t0.destination_id AS destination_id_67 FROM service t0 LEFT JOIN service_detail t43 ON t43.service_id = t0.id WHERE t0.id = '01a1679a-9a2c-bb8f-f4ab-91fec93ac2a4';

SELECT
  t0.email AS email_1,
  t0.roles AS roles_2,
  t0.password AS password_3,
  t0.first_name AS first_name_4,
  t0.last_name AS last_name_5,
  t0.phone AS phone_6,
  t0.status AS status_7,
  t0.reset_code_hash AS reset_code_hash_8,
  t0.reset_code_expires_at AS reset_code_expires_at_9,
  t0.reset_code_attempts AS reset_code_attempts_10,
  t0.email_verification_code_hash AS email_verification_code_hash_11,
  t0.email_verification_expires_at AS email_verification_expires_at_12,
  t0.email_verification_attempts AS email_verification_attempts_13,
  t0.avatar_path AS avatar_path_14,
  t0.birth_date AS birth_date_15,
  t0.gender AS gender_16,
  t0.preferred_locale AS preferred_locale_17,
  t0.country AS country_18,
  t0.bio AS bio_19,
  t0.city AS city_20,
  t0.interests AS interests_21,
  t0.id AS id_22,
  t0.created_at AS created_at_23,
  t0.updated_at AS updated_at_24,
  t0.deleted_at AS deleted_at_25
FROM
  "user" t0
WHERE
  t0.id = ?

SELECT t0.email AS email_1, t0.roles AS roles_2, t0.password AS password_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.phone AS phone_6, t0.status AS status_7, t0.reset_code_hash AS reset_code_hash_8, t0.reset_code_expires_at AS reset_code_expires_at_9, t0.reset_code_attempts AS reset_code_attempts_10, t0.email_verification_code_hash AS email_verification_code_hash_11, t0.email_verification_expires_at AS email_verification_expires_at_12, t0.email_verification_attempts AS email_verification_attempts_13, t0.avatar_path AS avatar_path_14, t0.birth_date AS birth_date_15, t0.gender AS gender_16, t0.preferred_locale AS preferred_locale_17, t0.country AS country_18, t0.bio AS bio_19, t0.city AS city_20, t0.interests AS interests_21, t0.id AS id_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.deleted_at AS deleted_at_25 FROM "user" t0 WHERE t0.id = '01a1679a-9aaa-8a8a-33e5-1c3b1f5f9b63';

SELECT
  t0.label AS label_1,
  t0.line1 AS line1_2,
  t0.line2 AS line2_3,
  t0.city AS city_4,
  t0.postal_code AS postal_code_5,
  t0.country AS country_6,
  t0.id AS id_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.user_id AS user_id_10
FROM
  address t0
WHERE
  t0.user_id = ?

SELECT t0.label AS label_1, t0.line1 AS line1_2, t0.line2 AS line2_3, t0.city AS city_4, t0.postal_code AS postal_code_5, t0.country AS country_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.user_id AS user_id_10 FROM address t0 WHERE t0.user_id = '01a1679a-9aaa-8a8a-33e5-1c3b1f5f9b63';

SELECT
  t0.email AS email_1,
  t0.roles AS roles_2,
  t0.password AS password_3,
  t0.first_name AS first_name_4,
  t0.last_name AS last_name_5,
  t0.phone AS phone_6,
  t0.status AS status_7,
  t0.reset_code_hash AS reset_code_hash_8,
  t0.reset_code_expires_at AS reset_code_expires_at_9,
  t0.reset_code_attempts AS reset_code_attempts_10,
  t0.email_verification_code_hash AS email_verification_code_hash_11,
  t0.email_verification_expires_at AS email_verification_expires_at_12,
  t0.email_verification_attempts AS email_verification_attempts_13,
  t0.avatar_path AS avatar_path_14,
  t0.birth_date AS birth_date_15,
  t0.gender AS gender_16,
  t0.preferred_locale AS preferred_locale_17,
  t0.country AS country_18,
  t0.bio AS bio_19,
  t0.city AS city_20,
  t0.interests AS interests_21,
  t0.id AS id_22,
  t0.created_at AS created_at_23,
  t0.updated_at AS updated_at_24,
  t0.deleted_at AS deleted_at_25
FROM
  "user" t0
WHERE
  t0.id = ?

SELECT t0.email AS email_1, t0.roles AS roles_2, t0.password AS password_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.phone AS phone_6, t0.status AS status_7, t0.reset_code_hash AS reset_code_hash_8, t0.reset_code_expires_at AS reset_code_expires_at_9, t0.reset_code_attempts AS reset_code_attempts_10, t0.email_verification_code_hash AS email_verification_code_hash_11, t0.email_verification_expires_at AS email_verification_expires_at_12, t0.email_verification_attempts AS email_verification_attempts_13, t0.avatar_path AS avatar_path_14, t0.birth_date AS birth_date_15, t0.gender AS gender_16, t0.preferred_locale AS preferred_locale_17, t0.country AS country_18, t0.bio AS bio_19, t0.city AS city_20, t0.interests AS interests_21, t0.id AS id_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.deleted_at AS deleted_at_25 FROM "user" t0 WHERE t0.id = '01a1679a-9aa9-8856-339d-20b133ef9c7c';

SELECT
  t0.label AS label_1,
  t0.line1 AS line1_2,
  t0.line2 AS line2_3,
  t0.city AS city_4,
  t0.postal_code AS postal_code_5,
  t0.country AS country_6,
  t0.id AS id_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.user_id AS user_id_10
FROM
  address t0
WHERE
  t0.user_id = ?

SELECT t0.label AS label_1, t0.line1 AS line1_2, t0.line2 AS line2_3, t0.city AS city_4, t0.postal_code AS postal_code_5, t0.country AS country_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.user_id AS user_id_10 FROM address t0 WHERE t0.user_id = '01a1679a-9aa9-8856-339d-20b133ef9c7c';