Symfony Profiler

[
  "route" => "app_prestataire_show"
  "route_parameters" => [
    "_route" => "app_prestataire_show"
    "_controller" => "App\Prestataire\Controller\ShowPrestataireController"
    "slug" => "formule-proprete-14"
  ]
  "request_uri" => "https://trouvemoi.pro/prestataire/formule-proprete-14"
  "method" => "GET"
]

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

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

[
  "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" => "app_prestataire"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "admin_prestataire"
    "serverVersion" => "16"
    "charset" => "utf8"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.slug AS slug_3, t0.legal_name AS legal_name_4, t0.structure_type AS structure_type_5, t0.siren AS siren_6, t0.siret AS siret_7, t0.naf_code AS naf_code_8, t0.vat_number AS vat_number_9, t0.address AS address_10, t0.address_complement AS address_complement_11, t0.postal_code AS postal_code_12, t0.city AS city_13, t0.country AS country_14, t0.latitude AS latitude_15, t0.longitude AS longitude_16, t0.geohash AS geohash_17, t0.phone_public AS phone_public_18, t0.phone_private AS phone_private_19, t0.website AS website_20, t0.facebook_url AS facebook_url_21, t0.instagram_url AS instagram_url_22, t0.linkedin_url AS linkedin_url_23, t0.short_description AS short_description_24, t0.long_description AS long_description_25, t0.logo AS logo_26, t0.cover_image AS cover_image_27, t0.signature_image AS signature_image_28, t0.profile_status AS profile_status_29, t0.verification_status AS verification_status_30, t0.completion_score AS completion_score_31, t0.average_rating AS average_rating_32, t0.reviews_count AS reviews_count_33, t0.response_time_minutes AS response_time_minutes_34, t0.is_featured AS is_featured_35, t0.featured_until AS featured_until_36, t0.search_visibility AS search_visibility_37, t0.verified_at AS verified_at_38, t0.created_at AS created_at_39, t0.updated_at AS updated_at_40, t0.deleted_at AS deleted_at_41, t0.description AS description_42, t0.metier AS metier_43, t0.experience AS experience_44, t0.document_verification_status AS document_verification_status_45, t0.company_last_verification_at AS company_last_verification_at_46, t0.company_verification_source AS company_verification_source_47, t0.company_verification_note AS company_verification_note_48, t0.is_on_vacation AS is_on_vacation_49, t0.vacation_return_date AS vacation_return_date_50, t0.user_id AS user_id_51, t52.id AS id_53, t52.stripe_customer_id AS stripe_customer_id_54, t52.stripe_default_payment_method_id AS stripe_default_payment_method_id_55, t52.default_payment_method_type AS default_payment_method_type_56, t52.billing_email AS billing_email_57, t52.created_at AS created_at_58, t52.updated_at AS updated_at_59, t52.prestataire_profile_id AS prestataire_profile_id_60 FROM prestataire_profile t0 LEFT JOIN subscription_customer t52 ON t52.prestataire_profile_id = t0.id WHERE t0.slug = ? LIMIT 1"
  "params" => [
    1 => "formule-proprete-14"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1150
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT m0_.id AS id_0, m0_.type AS type_1, m0_.content AS content_2, m0_.created_at AS created_at_3, m0_.read_at AS read_at_4, c1_.id AS id_5, c1_.created_at AS created_at_6, c1_.updated_at AS updated_at_7, c1_.last_message_at AS last_message_at_8, c1_.is_closed AS is_closed_9, u2_.id AS id_10, u2_.email AS email_11, u2_.roles AS roles_12, u2_.password AS password_13, u2_.first_name AS first_name_14, u2_.last_name AS last_name_15, u2_.phone_number AS phone_number_16, u2_.phone_verified_at AS phone_verified_at_17, u2_.email_verified_at AS email_verified_at_18, u2_.is_verified AS is_verified_19, u2_.avatar AS avatar_20, u2_.locale AS locale_21, u2_.timezone AS timezone_22, u2_.status AS status_23, u2_.last_login_at AS last_login_at_24, u2_.login_count AS login_count_25, u2_.reset_token AS reset_token_26, u2_.reset_token_expires_at AS reset_token_expires_at_27, u2_.created_at AS created_at_28, u2_.updated_at AS updated_at_29, u2_.deleted_at AS deleted_at_30, u2_.notify_on_quote_request_received AS notify_on_quote_request_received_31, u2_.notify_on_message_received AS notify_on_message_received_32, u2_.notify_on_quote_request_accepted AS notify_on_quote_request_accepted_33, u2_.notify_on_review_received AS notify_on_review_received_34, p3_.id AS id_35, p3_.company_name AS company_name_36, p3_.slug AS slug_37, p3_.legal_name AS legal_name_38, p3_.structure_type AS structure_type_39, p3_.siren AS siren_40, p3_.siret AS siret_41, p3_.naf_code AS naf_code_42, p3_.vat_number AS vat_number_43, p3_.address AS address_44, p3_.address_complement AS address_complement_45, p3_.postal_code AS postal_code_46, p3_.city AS city_47, p3_.country AS country_48, p3_.latitude AS latitude_49, p3_.longitude AS longitude_50, p3_.geohash AS geohash_51, p3_.phone_public AS phone_public_52, p3_.phone_private AS phone_private_53, p3_.website AS website_54, p3_.facebook_url AS facebook_url_55, p3_.instagram_url AS instagram_url_56, p3_.linkedin_url AS linkedin_url_57, p3_.short_description AS short_description_58, p3_.long_description AS long_description_59, p3_.logo AS logo_60, p3_.cover_image AS cover_image_61, p3_.signature_image AS signature_image_62, p3_.profile_status AS profile_status_63, p3_.verification_status AS verification_status_64, p3_.completion_score AS completion_score_65, p3_.average_rating AS average_rating_66, p3_.reviews_count AS reviews_count_67, p3_.response_time_minutes AS response_time_minutes_68, p3_.is_featured AS is_featured_69, p3_.featured_until AS featured_until_70, p3_.search_visibility AS search_visibility_71, p3_.verified_at AS verified_at_72, p3_.created_at AS created_at_73, p3_.updated_at AS updated_at_74, p3_.deleted_at AS deleted_at_75, p3_.description AS description_76, p3_.metier AS metier_77, p3_.experience AS experience_78, p3_.document_verification_status AS document_verification_status_79, p3_.company_last_verification_at AS company_last_verification_at_80, p3_.company_verification_source AS company_verification_source_81, p3_.company_verification_note AS company_verification_note_82, p3_.is_on_vacation AS is_on_vacation_83, p3_.vacation_return_date AS vacation_return_date_84, c4_.id AS id_85, c4_.type AS type_86, c4_.company_name AS company_name_87, c4_.siret AS siret_88, c4_.billing_address AS billing_address_89, c4_.billing_postal_code AS billing_postal_code_90, c4_.billing_city AS billing_city_91, c4_.billing_country AS billing_country_92, c4_.default_address AS default_address_93, c4_.default_postal_code AS default_postal_code_94, c4_.default_city AS default_city_95, c4_.latitude AS latitude_96, c4_.longitude AS longitude_97, c4_.created_at AS created_at_98, c4_.updated_at AS updated_at_99, m0_.conversation_id AS conversation_id_100, m0_.author_id AS author_id_101, c1_.quote_request_id AS quote_request_id_102, c1_.client_id AS client_id_103, c1_.prestataire_id AS prestataire_id_104, p3_.user_id AS user_id_105, c4_.user_id AS user_id_106 FROM message m0_ LEFT JOIN conversation c1_ ON m0_.conversation_id = c1_.id LEFT JOIN "user" u2_ ON m0_.author_id = u2_.id LEFT JOIN prestataire_profile p3_ ON u2_.id = p3_.user_id LEFT JOIN client_profile c4_ ON u2_.id = c4_.user_id WHERE c1_.prestataire_id = ? AND m0_.type = ? AND m0_.author_id IS NOT NULL ORDER BY c1_.id ASC, m0_.created_at ASC, m0_.id ASC"
  "params" => [
    1 => 127
    2 => "user"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1148
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1150
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.city AS city_2, t0.postal_code AS postal_code_3, t0.department AS department_4, t0.region AS region_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.radius_km AS radius_km_8, t0.is_main_zone AS is_main_zone_9, t0.is_active AS is_active_10, t0.prestataire_profile_id AS prestataire_profile_id_11 FROM prestataire_intervention_zone t0 WHERE t0.prestataire_profile_id = ?"
  "params" => [
    1 => "127"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1150
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT CASE WHEN p0_.current_period_end IS NULL THEN 1 ELSE 0 END AS sclr_0, p0_.id AS id_1, p0_.billing_period AS billing_period_2, p0_.status AS status_3, p0_.stripe_subscription_id AS stripe_subscription_id_4, p0_.stripe_price_id AS stripe_price_id_5, p0_.stripe_subscription_item_id AS stripe_subscription_item_id_6, p0_.stripe_schedule_id AS stripe_schedule_id_7, p0_.started_at AS started_at_8, p0_.current_period_start AS current_period_start_9, p0_.current_period_end AS current_period_end_10, p0_.trial_starts_at AS trial_starts_at_11, p0_.trial_ends_at AS trial_ends_at_12, p0_.cancel_at_period_end AS cancel_at_period_end_13, p0_.cancellation_requested_at AS cancellation_requested_at_14, p0_.canceled_at AS canceled_at_15, p0_.ended_at AS ended_at_16, p0_.credits_granted_current_period AS credits_granted_current_period_17, p0_.credits_consumed_current_period AS credits_consumed_current_period_18, p0_.created_at AS created_at_19, p0_.updated_at AS updated_at_20, s1_.id AS id_21, s1_.code AS code_22, s1_.name AS name_23, s1_.description AS description_24, s1_.monthly_amount AS monthly_amount_25, s1_.annual_amount AS annual_amount_26, s1_.monthly_stripe_price_id AS monthly_stripe_price_id_27, s1_.annual_stripe_price_id AS annual_stripe_price_id_28, s1_.stripe_product_id AS stripe_product_id_29, s1_.monthly_credits AS monthly_credits_30, s1_.annual_credits AS annual_credits_31, s1_.welcome_credits AS welcome_credits_32, s1_.quote_responses_enabled AS quote_responses_enabled_33, s1_.instant_messaging_enabled AS instant_messaging_enabled_34, s1_.sort_order AS sort_order_35, s1_.status AS status_36, s1_.created_at AS created_at_37, s1_.updated_at AS updated_at_38, s2_.id AS id_39, s2_.billing_period AS billing_period_40, s2_.label AS label_41, s2_.amount AS amount_42, s2_.stripe_price_id AS stripe_price_id_43, s2_.is_active AS is_active_44, s2_.is_promotional AS is_promotional_45, s2_.valid_from AS valid_from_46, s2_.valid_until AS valid_until_47, s2_.created_at AS created_at_48, s2_.updated_at AS updated_at_49, p0_.prestataire_profile_id AS prestataire_profile_id_50, p0_.customer_id AS customer_id_51, p0_.plan_id AS plan_id_52, p0_.plan_price_id AS plan_price_id_53, s2_.plan_id AS plan_id_54 FROM prestataire_subscription p0_ LEFT JOIN subscription_plan s1_ ON p0_.plan_id = s1_.id LEFT JOIN subscription_plan_price s2_ ON p0_.plan_price_id = s2_.id WHERE p0_.prestataire_profile_id = ? AND p0_.status IN (?, ?) AND (p0_.ended_at IS NULL OR p0_.ended_at > ?) AND (p0_.current_period_end IS NULL OR p0_.current_period_end >= ?) ORDER BY sclr_0 ASC, p0_.current_period_end DESC, p0_.created_at DESC LIMIT 1"
  "params" => [
    1 => 127
    2 => "trialing"
    3 => "active"
    4 => "2026-10-29 05:08:15"
    5 => "2026-10-29 05:08:15"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1148
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1150
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#1150}
    4 => Doctrine\DBAL\ParameterType {#1150}
    5 => Doctrine\DBAL\ParameterType {#1150}
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.description AS description_3, s0_.icon AS icon_4, s0_.image AS image_5, s0_.position AS position_6, s0_.color AS color_7, s0_.seo_title AS seo_title_8, s0_.seo_description AS seo_description_9, s0_.created_at AS created_at_10, s0_.updated_at AS updated_at_11, s0_.is_active AS is_active_12, s1_.id AS id_13, s1_.name AS name_14, s1_.slug AS slug_15, s1_.description AS description_16, s1_.icon AS icon_17, s1_.image AS image_18, s1_.position AS position_19, s1_.color AS color_20, s1_.seo_title AS seo_title_21, s1_.seo_description AS seo_description_22, s1_.created_at AS created_at_23, s1_.updated_at AS updated_at_24, s1_.is_active AS is_active_25, s0_.parent_id AS parent_id_26, s1_.parent_id AS parent_id_27 FROM service_category s0_ LEFT JOIN service_category s1_ ON s0_.id = s1_.parent_id WHERE s0_.parent_id IS NULL AND s0_.is_active = ? AND (s1_.id IS NULL OR s1_.is_active = ?) ORDER BY s0_.position ASC, s1_.position ASC"
  "params" => [
    1 => 1
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2335
      +name: "BOOLEAN"
    }
    2 => Doctrine\DBAL\ParameterType {#2335}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.title AS title_3, t0.short_description AS short_description_4, t0.description AS description_5, t0.pricing_type AS pricing_type_6, t0.price_from AS price_from_7, t0.price_to AS price_to_8, t0.price_unit AS price_unit_9, t0.additional_info AS additional_info_10, t0.position AS position_11, t0.prix_catalogue AS prix_catalogue_12, t0.taux_reduction AS taux_reduction_13, t0.promotion_created_at AS promotion_created_at_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.slug AS slug_17, t0.prestataire_profile_id AS prestataire_profile_id_18, t0.service_id AS service_id_19 FROM prestataire_profile_service t0 WHERE t0.prestataire_profile_id = ?"
  "params" => [
    1 => "127"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1150
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.icon AS icon_5, t0.image AS image_6, t0.average_price_min AS average_price_min_7, t0.average_price_max AS average_price_max_8, t0.position AS position_9, t0.is_active AS is_active_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.category_id AS category_id_13 FROM service t0 WHERE t0.id = ?"
  "params" => [
    1 => 267
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1150
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.icon AS icon_5, t0.image AS image_6, t0.average_price_min AS average_price_min_7, t0.average_price_max AS average_price_max_8, t0.position AS position_9, t0.is_active AS is_active_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.category_id AS category_id_13 FROM service t0 WHERE t0.id = ?"
  "params" => [
    1 => 268
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1150
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.icon AS icon_5, t0.image AS image_6, t0.average_price_min AS average_price_min_7, t0.average_price_max AS average_price_max_8, t0.position AS position_9, t0.is_active AS is_active_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.category_id AS category_id_13 FROM service t0 WHERE t0.id = ?"
  "params" => [
    1 => 269
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1150
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.day_of_week AS day_of_week_2, t0.morning_enabled AS morning_enabled_3, t0.morning_start AS morning_start_4, t0.morning_end AS morning_end_5, t0.afternoon_enabled AS afternoon_enabled_6, t0.afternoon_start AS afternoon_start_7, t0.afternoon_end AS afternoon_end_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.prestataire_profile_id AS prestataire_profile_id_11 FROM prestataire_availability t0 WHERE t0.prestataire_profile_id = ? ORDER BY t0.day_of_week ASC"
  "params" => [
    1 => "127"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1150
      +name: "STRING"
    }
  ]
]