Symfony Profiler

[
  "route" => "app_activity_show"
  "route_parameters" => [
    "_route" => "app_activity_show"
    "_controller" => "App\Catalog\Controller\ActivityController::show"
    "_locale" => "fr"
    "slug" => "location-vtt-electrique"
  ]
  "request_uri" => "https://trouvemoi.eu/activites/location-vtt-electrique"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "authenticators" => 2
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "params" => [
    "driver" => "pdo_pgsql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 5432
    "user" => "loisir"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "admin_plaisir"
    "serverVersion" => "16"
    "charset" => "utf8"
  ]
]

[
  "sql" => "SET TIME ZONE 'Europe/Paris'"
]

[
  "sql" => "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"
  "params" => [
    1 => "location-vtt-electrique"
    2 => "published"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1285
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1285}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "01a1679a-9a26-e705-f90b-e668fabbc852"
    2 => "01a1679a-9a2b-1f06-ef0a-1b6b19516644"
    3 => "2026-11-06 17:15:24"
    4 => "2026-11-06 17:15:24"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1285
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1285}
    3 => Doctrine\DBAL\ParameterType {#1285}
    4 => Doctrine\DBAL\ParameterType {#1285}
  ]
]

[
  "sql" => "SELECT t0.display_name AS display_name_1, t0.slug AS slug_2, t0.bio AS bio_3, t0.company_name AS company_name_4, t0.city AS city_5, t0.status AS status_6, t0.facebook_url AS facebook_url_7, t0.instagram_url AS instagram_url_8, t0.linkedin_url AS linkedin_url_9, t0.website_url AS website_url_10, t0.address AS address_11, t0.cover_path AS cover_path_12, t0.intervention_zone AS intervention_zone_13, t0.youtube_url AS youtube_url_14, t0.timezone AS timezone_15, t0.availability_label AS availability_label_16, t0.payment_link_url AS payment_link_url_17, t0.payment_paypal AS payment_paypal_18, t0.payment_iban AS payment_iban_19, t0.payment_iban_holder AS payment_iban_holder_20, t0.payment_on_site AS payment_on_site_21, t0.payment_instructions AS payment_instructions_22, t0.online_payment_enabled AS online_payment_enabled_23, t0.accepts_stripe AS accepts_stripe_24, t0.accepts_paypal AS accepts_paypal_25, t0.accepts_cash AS accepts_cash_26, t0.stripe_account_id AS stripe_account_id_27, t0.stripe_charges_enabled AS stripe_charges_enabled_28, t0.paypal_merchant_id AS paypal_merchant_id_29, t0.paypal_tracking_id AS paypal_tracking_id_30, t0.paypal_payments_enabled AS paypal_payments_enabled_31, t0.id AS id_32, t0.created_at AS created_at_33, t0.updated_at AS updated_at_34, t0.deleted_at AS deleted_at_35, t0.user_id AS user_id_36, t0.main_category_id AS main_category_id_37 FROM provider_profile t0 WHERE t0.id = ?"
  "params" => [
    1 => "01a1679a-9a26-e705-f90b-e668fabbc852"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1285
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "01a1679a-9a26-e705-f90b-e668fabbc852"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1285
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.breadcrumb AS breadcrumb_1, t0.organizer AS organizer_2, t0.presentation_subtitle AS presentation_subtitle_3, t0.presentation_text AS presentation_text_4, t0.highlights_title AS highlights_title_5, t0.highlights AS highlights_6, t0.included AS included_7, t0.excluded AS excluded_8, t0.cannot_participate AS cannot_participate_9, t0.to_bring AS to_bring_10, t0.key_facts AS key_facts_11, t0.map_image AS map_image_12, t0.meeting_points AS meeting_points_13, t0.guarantees AS guarantees_14, t0.price AS price_15, t0.reviews_score AS reviews_score_16, t0.reviews_out_of AS reviews_out_of_17, t0.reviews_total AS reviews_total_18, t0.modal_title AS modal_title_19, t0.id AS id_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.service_id AS service_id_23 FROM service_detail t0 WHERE t0.service_id = ?"
  "params" => [
    1 => "01a1679a-9a2b-1f06-ef0a-1b6b19516601"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1285
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.breadcrumb AS breadcrumb_1, t0.organizer AS organizer_2, t0.presentation_subtitle AS presentation_subtitle_3, t0.presentation_text AS presentation_text_4, t0.highlights_title AS highlights_title_5, t0.highlights AS highlights_6, t0.included AS included_7, t0.excluded AS excluded_8, t0.cannot_participate AS cannot_participate_9, t0.to_bring AS to_bring_10, t0.key_facts AS key_facts_11, t0.map_image AS map_image_12, t0.meeting_points AS meeting_points_13, t0.guarantees AS guarantees_14, t0.price AS price_15, t0.reviews_score AS reviews_score_16, t0.reviews_out_of AS reviews_out_of_17, t0.reviews_total AS reviews_total_18, t0.modal_title AS modal_title_19, t0.id AS id_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.service_id AS service_id_23 FROM service_detail t0 WHERE t0.service_id = ?"
  "params" => [
    1 => "01a1679a-9a2c-bb8f-f4ab-91fec93ac2a4"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1285
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.breadcrumb AS breadcrumb_1, t0.organizer AS organizer_2, t0.presentation_subtitle AS presentation_subtitle_3, t0.presentation_text AS presentation_text_4, t0.highlights_title AS highlights_title_5, t0.highlights AS highlights_6, t0.included AS included_7, t0.excluded AS excluded_8, t0.cannot_participate AS cannot_participate_9, t0.to_bring AS to_bring_10, t0.key_facts AS key_facts_11, t0.map_image AS map_image_12, t0.meeting_points AS meeting_points_13, t0.guarantees AS guarantees_14, t0.price AS price_15, t0.reviews_score AS reviews_score_16, t0.reviews_out_of AS reviews_out_of_17, t0.reviews_total AS reviews_total_18, t0.modal_title AS modal_title_19, t0.id AS id_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.service_id AS service_id_23 FROM service_detail t0 WHERE t0.service_id = ?"
  "params" => [
    1 => "01a1679a-9a2d-9300-6a93-e585b628d8f5"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1285
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.breadcrumb AS breadcrumb_1, t0.organizer AS organizer_2, t0.presentation_subtitle AS presentation_subtitle_3, t0.presentation_text AS presentation_text_4, t0.highlights_title AS highlights_title_5, t0.highlights AS highlights_6, t0.included AS included_7, t0.excluded AS excluded_8, t0.cannot_participate AS cannot_participate_9, t0.to_bring AS to_bring_10, t0.key_facts AS key_facts_11, t0.map_image AS map_image_12, t0.meeting_points AS meeting_points_13, t0.guarantees AS guarantees_14, t0.price AS price_15, t0.reviews_score AS reviews_score_16, t0.reviews_out_of AS reviews_out_of_17, t0.reviews_total AS reviews_total_18, t0.modal_title AS modal_title_19, t0.id AS id_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.service_id AS service_id_23 FROM service_detail t0 WHERE t0.service_id = ?"
  "params" => [
    1 => "01a1679a-9a2d-9300-6a93-e585b628d938"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1285
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.breadcrumb AS breadcrumb_1, t0.organizer AS organizer_2, t0.presentation_subtitle AS presentation_subtitle_3, t0.presentation_text AS presentation_text_4, t0.highlights_title AS highlights_title_5, t0.highlights AS highlights_6, t0.included AS included_7, t0.excluded AS excluded_8, t0.cannot_participate AS cannot_participate_9, t0.to_bring AS to_bring_10, t0.key_facts AS key_facts_11, t0.map_image AS map_image_12, t0.meeting_points AS meeting_points_13, t0.guarantees AS guarantees_14, t0.price AS price_15, t0.reviews_score AS reviews_score_16, t0.reviews_out_of AS reviews_out_of_17, t0.reviews_total AS reviews_total_18, t0.modal_title AS modal_title_19, t0.id AS id_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.service_id AS service_id_23 FROM service_detail t0 WHERE t0.service_id = ?"
  "params" => [
    1 => "01a1679a-9a2e-17d0-bf0b-a0f7ed6d2ce3"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1285
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.breadcrumb AS breadcrumb_1, t0.organizer AS organizer_2, t0.presentation_subtitle AS presentation_subtitle_3, t0.presentation_text AS presentation_text_4, t0.highlights_title AS highlights_title_5, t0.highlights AS highlights_6, t0.included AS included_7, t0.excluded AS excluded_8, t0.cannot_participate AS cannot_participate_9, t0.to_bring AS to_bring_10, t0.key_facts AS key_facts_11, t0.map_image AS map_image_12, t0.meeting_points AS meeting_points_13, t0.guarantees AS guarantees_14, t0.price AS price_15, t0.reviews_score AS reviews_score_16, t0.reviews_out_of AS reviews_out_of_17, t0.reviews_total AS reviews_total_18, t0.modal_title AS modal_title_19, t0.id AS id_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.service_id AS service_id_23 FROM service_detail t0 WHERE t0.service_id = ?"
  "params" => [
    1 => "01a1679a-9a2f-df5c-6dd1-5babdbc09b14"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1285
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.breadcrumb AS breadcrumb_1, t0.organizer AS organizer_2, t0.presentation_subtitle AS presentation_subtitle_3, t0.presentation_text AS presentation_text_4, t0.highlights_title AS highlights_title_5, t0.highlights AS highlights_6, t0.included AS included_7, t0.excluded AS excluded_8, t0.cannot_participate AS cannot_participate_9, t0.to_bring AS to_bring_10, t0.key_facts AS key_facts_11, t0.map_image AS map_image_12, t0.meeting_points AS meeting_points_13, t0.guarantees AS guarantees_14, t0.price AS price_15, t0.reviews_score AS reviews_score_16, t0.reviews_out_of AS reviews_out_of_17, t0.reviews_total AS reviews_total_18, t0.modal_title AS modal_title_19, t0.id AS id_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.service_id AS service_id_23 FROM service_detail t0 WHERE t0.service_id = ?"
  "params" => [
    1 => "01a1679a-9a30-1a6e-8860-e3106fc3a339"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1285
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "01a1679a-9a1d-cd13-0150-fbd86d4c350c"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1285
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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.provider_id = ? ORDER BY t0.created_at DESC"
  "params" => [
    1 => "01a1679a-9a26-e705-f90b-e668fabbc852"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1285
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.title AS title_1, t0.description AS description_2, t0.scheduled_at AS scheduled_at_3, t0.city AS city_4, t0.location AS location_5, t0.show_exact_address AS show_exact_address_6, t0.ends_at AS ends_at_7, t0.postal_code AS postal_code_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.meeting_point AS meeting_point_11, t0.to_bring AS to_bring_12, t0.cover_image AS cover_image_13, t0.visibility AS visibility_14, t0.participation_mode AS participation_mode_15, t0.status AS status_16, t0.level AS level_17, t0.min_participants AS min_participants_18, t0.max_participants AS max_participants_19, t0.views_count AS views_count_20, t0.id AS id_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.organizer_id AS organizer_id_24, t0.category_id AS category_id_25, t0.category_suggestion_id AS category_suggestion_id_26, t0.service_id AS service_id_27 FROM private_activity t0 WHERE t0.organizer_id = ? ORDER BY t0.created_at DESC"
  "params" => [
    1 => "01a1679a-9a1d-cd13-0150-fbd86d4c350c"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1285
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.status AS status_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.private_activity_id AS private_activity_id_5, t0.participant_id AS participant_id_6 FROM participation t0 WHERE t0.participant_id = ? ORDER BY t0.created_at DESC"
  "params" => [
    1 => "01a1679a-9a1d-cd13-0150-fbd86d4c350c"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1285
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT m0_.rating AS rating_0, m0_.conviviality AS conviviality_1, m0_.organisation AS organisation_2, m0_.punctuality AS punctuality_3, m0_.communication AS communication_4, m0_.comment AS comment_5, m0_.id AS id_6, m0_.created_at AS created_at_7, m0_.updated_at AS updated_at_8, m0_.private_activity_id AS private_activity_id_9, m0_.author_id AS author_id_10, m0_.organizer_id AS organizer_id_11 FROM member_review m0_ WHERE m0_.organizer_id = ? ORDER BY m0_.created_at DESC"
  "params" => [
    1 => "01a1679a-9a1d-cd13-0150-fbd86d4c350c"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1285
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT c0_.archived_by_provider AS archived_by_provider_0, c0_.id AS id_1, c0_.created_at AS created_at_2, c0_.updated_at AS updated_at_3, p1_.display_name AS display_name_4, p1_.slug AS slug_5, p1_.bio AS bio_6, p1_.company_name AS company_name_7, p1_.city AS city_8, p1_.status AS status_9, p1_.facebook_url AS facebook_url_10, p1_.instagram_url AS instagram_url_11, p1_.linkedin_url AS linkedin_url_12, p1_.website_url AS website_url_13, p1_.address AS address_14, p1_.cover_path AS cover_path_15, p1_.intervention_zone AS intervention_zone_16, p1_.youtube_url AS youtube_url_17, p1_.timezone AS timezone_18, p1_.availability_label AS availability_label_19, p1_.payment_link_url AS payment_link_url_20, p1_.payment_paypal AS payment_paypal_21, p1_.payment_iban AS payment_iban_22, p1_.payment_iban_holder AS payment_iban_holder_23, p1_.payment_on_site AS payment_on_site_24, p1_.payment_instructions AS payment_instructions_25, p1_.online_payment_enabled AS online_payment_enabled_26, p1_.accepts_stripe AS accepts_stripe_27, p1_.accepts_paypal AS accepts_paypal_28, p1_.accepts_cash AS accepts_cash_29, p1_.stripe_account_id AS stripe_account_id_30, p1_.stripe_charges_enabled AS stripe_charges_enabled_31, p1_.paypal_merchant_id AS paypal_merchant_id_32, p1_.paypal_tracking_id AS paypal_tracking_id_33, p1_.paypal_payments_enabled AS paypal_payments_enabled_34, p1_.id AS id_35, p1_.created_at AS created_at_36, p1_.updated_at AS updated_at_37, p1_.deleted_at AS deleted_at_38, c0_.client_id AS client_id_39, c0_.provider_id AS provider_id_40, c0_.member_id AS member_id_41, c0_.service_id AS service_id_42, p1_.user_id AS user_id_43, p1_.main_category_id AS main_category_id_44 FROM conversation c0_ LEFT JOIN provider_profile p1_ ON c0_.provider_id = p1_.id WHERE c0_.client_id = ? OR p1_.user_id = ? OR c0_.member_id = ?"
  "params" => [
    1 => "01a1679a-9a1d-cd13-0150-fbd86d4c350c"
    2 => "01a1679a-9a1d-cd13-0150-fbd86d4c350c"
    3 => "01a1679a-9a1d-cd13-0150-fbd86d4c350c"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1285
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1285}
    3 => Doctrine\DBAL\ParameterType {#1285}
  ]
]

[
  "sql" => "SELECT t0.body AS body_1, t0.read_at AS read_at_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.conversation_id AS conversation_id_6, t0.author_id AS author_id_7 FROM message t0 WHERE t0.conversation_id = ? ORDER BY t0.created_at ASC"
  "params" => [
    1 => "01a1679a-9aae-ddf2-1c27-63bbf08b78ba"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1285
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.body AS body_1, t0.read_at AS read_at_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.conversation_id AS conversation_id_6, t0.author_id AS author_id_7 FROM message t0 WHERE t0.conversation_id = ? ORDER BY t0.created_at ASC"
  "params" => [
    1 => "01a1679a-9aaf-6828-2e3d-9b1c4def940b"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1285
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.body AS body_1, t0.read_at AS read_at_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.conversation_id AS conversation_id_6, t0.author_id AS author_id_7 FROM message t0 WHERE t0.conversation_id = ? ORDER BY t0.created_at ASC"
  "params" => [
    1 => "01a1679a-9aaf-6828-2e3d-9b1c4def940d"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1285
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.body AS body_1, t0.read_at AS read_at_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.conversation_id AS conversation_id_6, t0.author_id AS author_id_7 FROM message t0 WHERE t0.conversation_id = ? ORDER BY t0.created_at ASC"
  "params" => [
    1 => "01a1679a-9aaf-6828-2e3d-9b1c4def9410"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1285
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.body AS body_1, t0.read_at AS read_at_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.conversation_id AS conversation_id_6, t0.author_id AS author_id_7 FROM message t0 WHERE t0.conversation_id = ? ORDER BY t0.created_at ASC"
  "params" => [
    1 => "01a1679a-9aaf-6828-2e3d-9b1c4def9412"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1285
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.body AS body_1, t0.read_at AS read_at_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.conversation_id AS conversation_id_6, t0.author_id AS author_id_7 FROM message t0 WHERE t0.conversation_id = ? ORDER BY t0.created_at ASC"
  "params" => [
    1 => "01a1679a-9aaf-6828-2e3d-9b1c4def9414"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1285
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT a0_.starts_at AS starts_at_0, a0_.ends_at AS ends_at_1, a0_.capacity AS capacity_2, a0_.booked AS booked_3, a0_.id AS id_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.service_id AS service_id_7 FROM availability a0_ WHERE a0_.service_id = ? AND a0_.starts_at >= ? ORDER BY a0_.starts_at ASC"
  "params" => [
    1 => "01a1679a-9a2b-1f06-ef0a-1b6b19516644"
    2 => "2026-11-06 18:15:24"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1285
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1285}
  ]
]

[
  "sql" => "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.service_id = ? AND t0.status = ? ORDER BY t0.created_at DESC"
  "params" => [
    1 => "01a1679a-9a2b-1f06-ef0a-1b6b19516644"
    2 => "published"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1285
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1285}
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "01a1679a-9aa8-12d8-0383-37c2c3febfb0"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1285
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "01a1679a-9aa8-12d8-0383-37c2c3febfb0"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1285
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "01a1679a-9aa8-12d8-0383-37c2c3febfaf"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1285
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "01a1679a-9aa8-12d8-0383-37c2c3febfaf"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1285
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "01a1679a-9aaa-8a8a-33e5-1c3b1f5f9b62"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1285
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "01a1679a-9aaa-8a8a-33e5-1c3b1f5f9b62"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1285
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "01a1679a-9aac-91ee-ac66-5bdc7c490407"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1285
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "01a1679a-9aac-91ee-ac66-5bdc7c490407"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1285
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "01a1679a-9aa9-8856-339d-20b133ef9c7c"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1285
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "01a1679a-9aa9-8856-339d-20b133ef9c7c"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1285
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "01a1679a-9a26-e705-f90b-e668fabbc853"
    2 => "01a1679a-9a26-e705-f90b-e668fabbc853"
    3 => "published"
    4 => "01a1679a-9a2b-1f06-ef0a-1b6b19516644"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1285
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1285}
    3 => Doctrine\DBAL\ParameterType {#1285}
    4 => Doctrine\DBAL\ParameterType {#1285}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "01a1679a-9a26-e705-f90b-e668fabbc853"
    2 => "published"
    3 => "01a1679a-9a2b-1f06-ef0a-1b6b19516644"
    4 => "01a1679a-9a2b-1f06-ef0a-1b6b19516601"
    5 => "01a1679a-9bd8-6189-cc37-7c86f9872919"
    6 => "01a1679a-9bde-36f1-8f49-853551a12281"
    7 => "01a1679a-9a2e-17d0-bf0b-a0f7ed6d2ce3"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1285
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1285}
    3 => Doctrine\DBAL\ParameterType {#1285}
    4 => Doctrine\DBAL\ParameterType {#1285}
    5 => Doctrine\DBAL\ParameterType {#1285}
    6 => Doctrine\DBAL\ParameterType {#1285}
    7 => Doctrine\DBAL\ParameterType {#1285}
  ]
]