Symfony Profiler

[
  "route" => "app_offers"
  "route_parameters" => [
    "_route" => "app_offers"
    "_controller" => "App\Catalog\Controller\OfferController::index"
    "_locale" => "en"
  ]
  "request_uri" => "https://trouvemoi.eu/en/deals?dispo%5B0%5D=derniere-minute&tri=fin"
  "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 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, s1_.title AS title_13, s1_.slug AS slug_14, s1_.description AS description_15, s1_.booking_type AS booking_type_16, s1_.status AS status_17, s1_.currency AS currency_18, s1_.short_description AS short_description_19, s1_.duration_minutes AS duration_minutes_20, s1_.place_label AS place_label_21, s1_.duration_label AS duration_label_22, s1_.badge AS badge_23, s1_.search_text AS search_text_24, s1_.search_place AS search_place_25, s1_.position AS position_26, s1_.rating_average AS rating_average_27, s1_.reviews_count AS reviews_count_28, s1_.views_count AS views_count_29, s1_.capacity AS capacity_30, s1_.level AS level_31, s1_.languages AS languages_32, s1_.included AS included_33, s1_.subtitle AS subtitle_34, s1_.activity_type AS activity_type_35, s1_.minimum_age AS minimum_age_36, s1_.programme AS programme_37, s1_.meeting_point AS meeting_point_38, s1_.opening_period AS opening_period_39, s1_.audience AS audience_40, s1_.cancellation_policy AS cancellation_policy_41, s1_.address AS address_42, s1_.city AS city_43, s1_.postal_code AS postal_code_44, s1_.country AS country_45, s1_.latitude AS latitude_46, s1_.longitude AS longitude_47, s1_.id AS id_48, s1_.created_at AS created_at_49, s1_.updated_at AS updated_at_50, s1_.deleted_at AS deleted_at_51, p2_.display_name AS display_name_52, p2_.slug AS slug_53, p2_.bio AS bio_54, p2_.company_name AS company_name_55, p2_.city AS city_56, p2_.status AS status_57, p2_.facebook_url AS facebook_url_58, p2_.instagram_url AS instagram_url_59, p2_.linkedin_url AS linkedin_url_60, p2_.website_url AS website_url_61, p2_.address AS address_62, p2_.cover_path AS cover_path_63, p2_.intervention_zone AS intervention_zone_64, p2_.youtube_url AS youtube_url_65, p2_.timezone AS timezone_66, p2_.availability_label AS availability_label_67, p2_.payment_link_url AS payment_link_url_68, p2_.payment_paypal AS payment_paypal_69, p2_.payment_iban AS payment_iban_70, p2_.payment_iban_holder AS payment_iban_holder_71, p2_.payment_on_site AS payment_on_site_72, p2_.payment_instructions AS payment_instructions_73, p2_.online_payment_enabled AS online_payment_enabled_74, p2_.accepts_stripe AS accepts_stripe_75, p2_.accepts_paypal AS accepts_paypal_76, p2_.accepts_cash AS accepts_cash_77, p2_.stripe_account_id AS stripe_account_id_78, p2_.stripe_charges_enabled AS stripe_charges_enabled_79, p2_.paypal_merchant_id AS paypal_merchant_id_80, p2_.paypal_tracking_id AS paypal_tracking_id_81, p2_.paypal_payments_enabled AS paypal_payments_enabled_82, p2_.id AS id_83, p2_.created_at AS created_at_84, p2_.updated_at AS updated_at_85, p2_.deleted_at AS deleted_at_86, p0_.provider_id AS provider_id_87, p0_.service_id AS service_id_88, s1_.provider_id AS provider_id_89, s1_.category_id AS category_id_90, s1_.category_suggestion_id AS category_suggestion_id_91, s1_.destination_id AS destination_id_92, p2_.user_id AS user_id_93, p2_.main_category_id AS main_category_id_94 FROM promotion p0_ LEFT JOIN service s1_ ON p0_.service_id = s1_.id INNER JOIN provider_profile p2_ ON p0_.provider_id = p2_.id WHERE p0_.deleted_at IS NULL AND p0_.paused = false AND (p0_.starts_at <= ? AND p0_.ends_at >= ?) AND (s1_.id IS NULL OR (s1_.status = ? AND s1_.deleted_at IS NULL)) ORDER BY p0_.ends_at ASC"
  "params" => [
    1 => "2026-11-06 17:14:49"
    2 => "2026-11-06 17:14:49"
    3 => "published"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1148
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1148}
    3 => Doctrine\DBAL\ParameterType {#1148}
  ]
]

[
  "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 {#1148
      +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-9bf4-a186-c882-ab89c781c3de"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1148
      +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 {#1148
      +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 {#1148
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.description AS description_2, t0.price AS price_3, t0.currency AS currency_4, t0.pricing_unit AS pricing_unit_5, t0.delivery_days AS delivery_days_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.service_id AS service_id_10 FROM service_package t0 WHERE t0.service_id = ?"
  "params" => [
    1 => "01a1679a-9a2b-1f06-ef0a-1b6b19516601"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1148
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.path AS path_1, t0.type AS type_2, t0.position AS position_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.service_id AS service_id_7 FROM media t0 WHERE t0.service_id = ?"
  "params" => [
    1 => "01a1679a-9a2b-1f06-ef0a-1b6b19516601"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1148
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.parent_id AS parent_id_7 FROM category t0 WHERE t0.id = ?"
  "params" => [
    1 => "01a1679a-9a26-e705-f90b-e668fabbc853"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1148
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.description AS description_2, t0.price AS price_3, t0.currency AS currency_4, t0.pricing_unit AS pricing_unit_5, t0.delivery_days AS delivery_days_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.service_id AS service_id_10 FROM service_package t0 WHERE t0.service_id = ?"
  "params" => [
    1 => "01a1679a-9bf4-a186-c882-ab89c781c3de"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1148
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.path AS path_1, t0.type AS type_2, t0.position AS position_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.service_id AS service_id_7 FROM media t0 WHERE t0.service_id = ?"
  "params" => [
    1 => "01a1679a-9bf4-a186-c882-ab89c781c3de"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1148
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.parent_id AS parent_id_7 FROM category t0 WHERE t0.id = ?"
  "params" => [
    1 => "01a1679a-9a26-e705-f90b-e668fabbc859"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1148
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.description AS description_2, t0.price AS price_3, t0.currency AS currency_4, t0.pricing_unit AS pricing_unit_5, t0.delivery_days AS delivery_days_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.service_id AS service_id_10 FROM service_package t0 WHERE t0.service_id = ?"
  "params" => [
    1 => "01a1679a-9a2c-bb8f-f4ab-91fec93ac2a4"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1148
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.path AS path_1, t0.type AS type_2, t0.position AS position_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.service_id AS service_id_7 FROM media t0 WHERE t0.service_id = ?"
  "params" => [
    1 => "01a1679a-9a2c-bb8f-f4ab-91fec93ac2a4"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1148
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.parent_id AS parent_id_7 FROM category t0 WHERE t0.id = ?"
  "params" => [
    1 => "01a1679a-9a26-e705-f90b-e668fabbc854"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1148
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.description AS description_2, t0.price AS price_3, t0.currency AS currency_4, t0.pricing_unit AS pricing_unit_5, t0.delivery_days AS delivery_days_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.service_id AS service_id_10 FROM service_package t0 WHERE t0.service_id = ?"
  "params" => [
    1 => "01a1679a-9a2d-9300-6a93-e585b628d8f5"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1148
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.path AS path_1, t0.type AS type_2, t0.position AS position_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.service_id AS service_id_7 FROM media t0 WHERE t0.service_id = ?"
  "params" => [
    1 => "01a1679a-9a2d-9300-6a93-e585b628d8f5"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1148
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.parent_id AS parent_id_7 FROM category t0 WHERE t0.parent_id IS NULL ORDER BY t0.position ASC"
]