Symfony Profiler

[
  "route" => "app_gifts"
  "route_parameters" => [
    "_route" => "app_gifts"
    "_controller" => "App\Catalog\Controller\GiftController::index"
    "_locale" => "fr"
  ]
  "request_uri" => "https://trouvemoi.eu/cadeaux?page=2"
  "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 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"
  "params" => [
    1 => "published"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1287
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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 10"
  "params" => [
    1 => "published"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1287
      +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, 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => "01a1679a-9bf7-86ad-4fcf-4cb42ea9dc35"
    2 => "01a1679a-9a2b-1f06-ef0a-1b6b19516601"
    3 => "01a1679a-9bd6-acb5-364c-8beaee8fccc5"
    4 => "01a1679a-9c01-0a19-6cfb-e2309e29f1a2"
    5 => "01a1679a-9beb-e8cb-eca1-ed43dfe7a576"
    6 => "01a1679a-9bf4-a186-c882-ab89c781c3de"
    7 => "01a1679a-9bde-36f1-8f49-853551a12281"
    8 => "01a1679a-9bd8-6189-cc37-7c86f9872919"
    9 => "01a1679a-9be8-26bf-5bf7-0d3d278f601c"
    10 => "01a1679a-9be1-c9cc-8a80-fc1d9e1890af"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1287
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1287}
    3 => Doctrine\DBAL\ParameterType {#1287}
    4 => Doctrine\DBAL\ParameterType {#1287}
    5 => Doctrine\DBAL\ParameterType {#1287}
    6 => Doctrine\DBAL\ParameterType {#1287}
    7 => Doctrine\DBAL\ParameterType {#1287}
    8 => Doctrine\DBAL\ParameterType {#1287}
    9 => Doctrine\DBAL\ParameterType {#1287}
    10 => Doctrine\DBAL\ParameterType {#1287}
  ]
]

[
  "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"
]

[
  "sql" => "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 AND c1_.slug IN (?)"
  "params" => [
    1 => "published"
    2 => "sports-aventures"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1287
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1287}
  ]
]

[
  "sql" => "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 AND c1_.slug IN (?) GROUP BY s0_.id ORDER BY s0_.views_count DESC, s0_.position ASC, s0_.reviews_count DESC, s0_.id ASC LIMIT 1"
  "params" => [
    1 => "published"
    2 => "sports-aventures"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1287
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1287}
  ]
]

[
  "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_.id IN (?)"
  "params" => [
    1 => "01a1679a-9a2b-1f06-ef0a-1b6b19516601"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1287
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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 AND c1_.slug IN (?)"
  "params" => [
    1 => "published"
    2 => "cultures-decouvertes"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1287
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1287}
  ]
]

[
  "sql" => "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 AND c1_.slug IN (?) GROUP BY s0_.id ORDER BY s0_.views_count DESC, s0_.position ASC, s0_.reviews_count DESC, s0_.id ASC LIMIT 1"
  "params" => [
    1 => "published"
    2 => "cultures-decouvertes"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1287
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1287}
  ]
]

[
  "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_.id IN (?)"
  "params" => [
    1 => "01a1679a-9a2c-bb8f-f4ab-91fec93ac2a4"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1287
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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 AND c1_.slug IN (?)"
  "params" => [
    1 => "published"
    2 => "ateliers-creations"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1287
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1287}
  ]
]

[
  "sql" => "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 AND c1_.slug IN (?) GROUP BY s0_.id ORDER BY s0_.views_count DESC, s0_.position ASC, s0_.reviews_count DESC, s0_.id ASC LIMIT 1"
  "params" => [
    1 => "published"
    2 => "ateliers-creations"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1287
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1287}
  ]
]

[
  "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_.id IN (?)"
  "params" => [
    1 => "01a1679a-9a2d-9300-6a93-e585b628d938"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1287
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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 AND c1_.slug IN (?)"
  "params" => [
    1 => "published"
    2 => "bien-etre"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1287
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1287}
  ]
]

[
  "sql" => "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 AND c1_.slug IN (?) GROUP BY s0_.id ORDER BY s0_.views_count DESC, s0_.position ASC, s0_.reviews_count DESC, s0_.id ASC LIMIT 1"
  "params" => [
    1 => "published"
    2 => "bien-etre"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1287
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1287}
  ]
]

[
  "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_.id IN (?)"
  "params" => [
    1 => "01a1679a-9a2f-df5c-6dd1-5babdbc09b14"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1287
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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 AND c1_.slug IN (?)"
  "params" => [
    1 => "published"
    2 => "natures-plein-air"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1287
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1287}
  ]
]

[
  "sql" => "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 AND c1_.slug IN (?) GROUP BY s0_.id ORDER BY s0_.views_count DESC, s0_.position ASC, s0_.reviews_count DESC, s0_.id ASC LIMIT 1"
  "params" => [
    1 => "published"
    2 => "natures-plein-air"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1287
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1287}
  ]
]

[
  "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_.id IN (?)"
  "params" => [
    1 => "01a1679a-9bd6-acb5-364c-8beaee8fccc5"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1287
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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 AND c1_.slug IN (?)"
  "params" => [
    1 => "published"
    2 => "soirees-evenements"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1287
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1287}
  ]
]

[
  "sql" => "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 AND c1_.slug IN (?) GROUP BY s0_.id ORDER BY s0_.views_count DESC, s0_.position ASC, s0_.reviews_count DESC, s0_.id ASC LIMIT 1"
  "params" => [
    1 => "published"
    2 => "soirees-evenements"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1287
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1287}
  ]
]

[
  "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_.id IN (?)"
  "params" => [
    1 => "01a1679a-9be1-c9cc-8a80-fc1d9e1890af"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1287
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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 AND c1_.slug IN (?)"
  "params" => [
    1 => "published"
    2 => "en-famille"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1287
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1287}
  ]
]

[
  "sql" => "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 AND c1_.slug IN (?) GROUP BY s0_.id ORDER BY s0_.views_count DESC, s0_.position ASC, s0_.reviews_count DESC, s0_.id ASC LIMIT 1"
  "params" => [
    1 => "published"
    2 => "en-famille"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1287
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1287}
  ]
]

[
  "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_.id IN (?)"
  "params" => [
    1 => "01a1679a-9bf7-86ad-4fcf-4cb42ea9dc35"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1287
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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 AND c1_.slug IN (?)"
  "params" => [
    1 => "published"
    2 => "gastronomies"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1287
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1287}
  ]
]

[
  "sql" => "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 AND c1_.slug IN (?) GROUP BY s0_.id ORDER BY s0_.views_count DESC, s0_.position ASC, s0_.reviews_count DESC, s0_.id ASC LIMIT 1"
  "params" => [
    1 => "published"
    2 => "gastronomies"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1287
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1287}
  ]
]

[
  "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_.id IN (?)"
  "params" => [
    1 => "01a1679a-9c01-0a19-6cfb-e2309e29f1a2"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1287
      +name: "STRING"
    }
  ]
]