Symfony Profiler

[
  "route" => "app_activity_show"
  "route_parameters" => [
    "_route" => "app_activity_show"
    "_controller" => "App\Catalog\Controller\ActivityController::show"
    "_locale" => "fr"
    "slug" => "massage-relaxant-bord-de-mer"
  ]
  "request_uri" => "https://trouvemoi.eu/activites/massage-relaxant-bord-de-mer"
  "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" => "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_.capacity AS capacity_16, s0_.level AS level_17, s0_.languages AS languages_18, s0_.included AS included_19, s0_.subtitle AS subtitle_20, s0_.activity_type AS activity_type_21, s0_.minimum_age AS minimum_age_22, s0_.programme AS programme_23, s0_.meeting_point AS meeting_point_24, s0_.opening_period AS opening_period_25, s0_.audience AS audience_26, s0_.cancellation_policy AS cancellation_policy_27, s0_.address AS address_28, s0_.city AS city_29, s0_.postal_code AS postal_code_30, s0_.country AS country_31, s0_.latitude AS latitude_32, s0_.longitude AS longitude_33, s0_.id AS id_34, s0_.created_at AS created_at_35, s0_.updated_at AS updated_at_36, s0_.deleted_at AS deleted_at_37, s1_.name AS name_38, s1_.description AS description_39, s1_.price AS price_40, s1_.currency AS currency_41, s1_.pricing_unit AS pricing_unit_42, s1_.delivery_days AS delivery_days_43, s1_.id AS id_44, s1_.created_at AS created_at_45, s1_.updated_at AS updated_at_46, m2_.path AS path_47, m2_.type AS type_48, m2_.position AS position_49, m2_.id AS id_50, m2_.created_at AS created_at_51, m2_.updated_at AS updated_at_52, c3_.name AS name_53, c3_.slug AS slug_54, c3_.position AS position_55, c3_.id AS id_56, c3_.created_at AS created_at_57, c3_.updated_at AS updated_at_58, s0_.provider_id AS provider_id_59, s0_.category_id AS category_id_60, s0_.destination_id AS destination_id_61, s1_.service_id AS service_id_62, m2_.service_id AS service_id_63, c3_.parent_id AS parent_id_64 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 category c3_ ON s0_.category_id = c3_.id WHERE s0_.slug = ? AND s0_.status = ? AND s0_.deleted_at IS NULL"
  "params" => [
    1 => "massage-relaxant-bord-de-mer"
    2 => "published"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1123
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1123}
  ]
]

[
  "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 => "019f9f89-3813-1a16-1a80-f22f1ca530ee"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1123
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.display_name AS display_name_1, t0.bio AS bio_2, t0.company_name AS company_name_3, t0.status AS status_4, t0.facebook_url AS facebook_url_5, t0.instagram_url AS instagram_url_6, t0.linkedin_url AS linkedin_url_7, t0.website_url AS website_url_8, t0.id AS id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12, t0.user_id AS user_id_13, t0.main_category_id AS main_category_id_14 FROM provider_profile t0 WHERE t0.id = ?"
  "params" => [
    1 => "019f9f89-3813-1a16-1a80-f22f1ca530e9"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1123
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT DISTINCT id_35, MIN(sclr_60) 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_.capacity AS capacity_17, s1_.level AS level_18, s1_.languages AS languages_19, s1_.included AS included_20, s1_.subtitle AS subtitle_21, s1_.activity_type AS activity_type_22, s1_.minimum_age AS minimum_age_23, s1_.programme AS programme_24, s1_.meeting_point AS meeting_point_25, s1_.opening_period AS opening_period_26, s1_.audience AS audience_27, s1_.cancellation_policy AS cancellation_policy_28, s1_.address AS address_29, s1_.city AS city_30, s1_.postal_code AS postal_code_31, s1_.country AS country_32, s1_.latitude AS latitude_33, s1_.longitude AS longitude_34, s1_.id AS id_35, s1_.created_at AS created_at_36, s1_.updated_at AS updated_at_37, s1_.deleted_at AS deleted_at_38, s2_.name AS name_39, s2_.description AS description_40, s2_.price AS price_41, s2_.currency AS currency_42, s2_.pricing_unit AS pricing_unit_43, s2_.delivery_days AS delivery_days_44, s2_.id AS id_45, s2_.created_at AS created_at_46, s2_.updated_at AS updated_at_47, m3_.path AS path_48, m3_.type AS type_49, m3_.position AS position_50, m3_.id AS id_51, m3_.created_at AS created_at_52, m3_.updated_at AS updated_at_53, c0_.name AS name_54, c0_.slug AS slug_55, c0_.position AS position_56, c0_.id AS id_57, c0_.created_at AS created_at_58, c0_.updated_at AS updated_at_59, ROW_NUMBER() OVER(ORDER BY CASE WHEN c0_.id = ? THEN 0 ELSE 1 END ASC, s1_.position ASC) AS sclr_60 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 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_35 ORDER BY dctrn_minrownum ASC LIMIT 4"
  "params" => [
    1 => "019f9f89-3813-1a16-1a80-f22f1ca530eb"
    2 => "019f9f89-3813-1a16-1a80-f22f1ca530eb"
    3 => "published"
    4 => "019f9f89-3813-1a16-1a80-f22f1ca530ee"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1123
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1123}
    3 => Doctrine\DBAL\ParameterType {#1123}
    4 => Doctrine\DBAL\ParameterType {#1123}
  ]
]

[
  "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_.capacity AS capacity_17, s1_.level AS level_18, s1_.languages AS languages_19, s1_.included AS included_20, s1_.subtitle AS subtitle_21, s1_.activity_type AS activity_type_22, s1_.minimum_age AS minimum_age_23, s1_.programme AS programme_24, s1_.meeting_point AS meeting_point_25, s1_.opening_period AS opening_period_26, s1_.audience AS audience_27, s1_.cancellation_policy AS cancellation_policy_28, s1_.address AS address_29, s1_.city AS city_30, s1_.postal_code AS postal_code_31, s1_.country AS country_32, s1_.latitude AS latitude_33, s1_.longitude AS longitude_34, s1_.id AS id_35, s1_.created_at AS created_at_36, s1_.updated_at AS updated_at_37, s1_.deleted_at AS deleted_at_38, s2_.name AS name_39, s2_.description AS description_40, s2_.price AS price_41, s2_.currency AS currency_42, s2_.pricing_unit AS pricing_unit_43, s2_.delivery_days AS delivery_days_44, s2_.id AS id_45, s2_.created_at AS created_at_46, s2_.updated_at AS updated_at_47, m3_.path AS path_48, m3_.type AS type_49, m3_.position AS position_50, m3_.id AS id_51, m3_.created_at AS created_at_52, m3_.updated_at AS updated_at_53, c0_.name AS name_54, c0_.slug AS slug_55, c0_.position AS position_56, c0_.id AS id_57, c0_.created_at AS created_at_58, c0_.updated_at AS updated_at_59, s1_.provider_id AS provider_id_60, s1_.category_id AS category_id_61, s1_.destination_id AS destination_id_62, s2_.service_id AS service_id_63, m3_.service_id AS service_id_64, c0_.parent_id AS parent_id_65 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 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 => "019f9f89-3813-1a16-1a80-f22f1ca530eb"
    2 => "published"
    3 => "019f9f89-3813-1a16-1a80-f22f1ca530ee"
    4 => "019f9f89-3813-1a16-1a80-f22f1ca530f1"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1123
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1123}
    3 => Doctrine\DBAL\ParameterType {#1123}
    4 => Doctrine\DBAL\ParameterType {#1123}
  ]
]

[
  "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 => "019f9f89-3813-1a16-1a80-f22f1ca530f1"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1123
      +name: "STRING"
    }
  ]
]