Symfony Profiler

[
  "route" => "app_home"
  "route_parameters" => [
    "_route" => "app_home"
    "_controller" => "App\Controller\HomeController::index"
  ]
  "request_uri" => "https://prestataire.trouvemoi.pro/"
  "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.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.position AS position_7, t0.color AS color_8, t0.seo_title AS seo_title_9, t0.seo_description AS seo_description_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_active AS is_active_13, t0.parent_id AS parent_id_14 FROM service_category t0 WHERE t0.is_active = ? AND t0.parent_id IS NULL ORDER BY t0.position ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1279
      +name: "BOOLEAN"
    }
  ]
]

[
  "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_.parent_id = s1_.id WHERE s0_.is_active = ? AND s0_.parent_id IS NOT NULL ORDER BY s1_.position ASC, s0_.position ASC, s0_.name ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1279
      +name: "BOOLEAN"
    }
  ]
]

[
  "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.vat_number AS vat_number_8, t0.address AS address_9, t0.address_complement AS address_complement_10, t0.postal_code AS postal_code_11, t0.city AS city_12, t0.country AS country_13, t0.latitude AS latitude_14, t0.longitude AS longitude_15, t0.geohash AS geohash_16, t0.phone_public AS phone_public_17, t0.phone_private AS phone_private_18, t0.website AS website_19, t0.facebook_url AS facebook_url_20, t0.instagram_url AS instagram_url_21, t0.linkedin_url AS linkedin_url_22, t0.short_description AS short_description_23, t0.long_description AS long_description_24, t0.logo AS logo_25, t0.cover_image AS cover_image_26, t0.signature_image AS signature_image_27, t0.profile_status AS profile_status_28, t0.verification_status AS verification_status_29, t0.completion_score AS completion_score_30, t0.average_rating AS average_rating_31, t0.reviews_count AS reviews_count_32, t0.response_time_minutes AS response_time_minutes_33, t0.is_featured AS is_featured_34, t0.featured_until AS featured_until_35, t0.search_visibility AS search_visibility_36, t0.verified_at AS verified_at_37, t0.created_at AS created_at_38, t0.updated_at AS updated_at_39, t0.deleted_at AS deleted_at_40, t0.description AS description_41, t0.metier AS metier_42, t0.experience AS experience_43, t0.document_verification_status AS document_verification_status_44, t0.company_last_verification_at AS company_last_verification_at_45, t0.company_verification_source AS company_verification_source_46, t0.company_verification_note AS company_verification_note_47, t0.is_on_vacation AS is_on_vacation_48, t0.vacation_return_date AS vacation_return_date_49, t0.user_id AS user_id_50, t51.id AS id_52, t51.stripe_customer_id AS stripe_customer_id_53, t51.stripe_default_payment_method_id AS stripe_default_payment_method_id_54, t51.default_payment_method_type AS default_payment_method_type_55, t51.billing_email AS billing_email_56, t51.created_at AS created_at_57, t51.updated_at AS updated_at_58, t51.prestataire_profile_id AS prestataire_profile_id_59 FROM prestataire_profile t0 LEFT JOIN subscription_customer t51 ON t51.prestataire_profile_id = t0.id ORDER BY t0.average_rating DESC LIMIT 4"
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.is_active AS is_active_1, p0_.title AS title_2, p0_.short_description AS short_description_3, p0_.description AS description_4, p0_.pricing_type AS pricing_type_5, p0_.price_from AS price_from_6, p0_.price_to AS price_to_7, p0_.price_unit AS price_unit_8, p0_.additional_info AS additional_info_9, p0_.position AS position_10, p0_.prix_catalogue AS prix_catalogue_11, p0_.taux_reduction AS taux_reduction_12, p0_.promotion_created_at AS promotion_created_at_13, p0_.created_at AS created_at_14, p0_.updated_at AS updated_at_15, p0_.slug AS slug_16, p1_.id AS id_17, p1_.company_name AS company_name_18, p1_.slug AS slug_19, p1_.legal_name AS legal_name_20, p1_.structure_type AS structure_type_21, p1_.siren AS siren_22, p1_.siret AS siret_23, p1_.vat_number AS vat_number_24, p1_.address AS address_25, p1_.address_complement AS address_complement_26, p1_.postal_code AS postal_code_27, p1_.city AS city_28, p1_.country AS country_29, p1_.latitude AS latitude_30, p1_.longitude AS longitude_31, p1_.geohash AS geohash_32, p1_.phone_public AS phone_public_33, p1_.phone_private AS phone_private_34, p1_.website AS website_35, p1_.facebook_url AS facebook_url_36, p1_.instagram_url AS instagram_url_37, p1_.linkedin_url AS linkedin_url_38, p1_.short_description AS short_description_39, p1_.long_description AS long_description_40, p1_.logo AS logo_41, p1_.cover_image AS cover_image_42, p1_.signature_image AS signature_image_43, p1_.profile_status AS profile_status_44, p1_.verification_status AS verification_status_45, p1_.completion_score AS completion_score_46, p1_.average_rating AS average_rating_47, p1_.reviews_count AS reviews_count_48, p1_.response_time_minutes AS response_time_minutes_49, p1_.is_featured AS is_featured_50, p1_.featured_until AS featured_until_51, p1_.search_visibility AS search_visibility_52, p1_.verified_at AS verified_at_53, p1_.created_at AS created_at_54, p1_.updated_at AS updated_at_55, p1_.deleted_at AS deleted_at_56, p1_.description AS description_57, p1_.metier AS metier_58, p1_.experience AS experience_59, p1_.document_verification_status AS document_verification_status_60, p1_.company_last_verification_at AS company_last_verification_at_61, p1_.company_verification_source AS company_verification_source_62, p1_.company_verification_note AS company_verification_note_63, p1_.is_on_vacation AS is_on_vacation_64, p1_.vacation_return_date AS vacation_return_date_65, s2_.id AS id_66, s2_.name AS name_67, s2_.slug AS slug_68, s2_.description AS description_69, s2_.icon AS icon_70, s2_.average_price_min AS average_price_min_71, s2_.average_price_max AS average_price_max_72, s2_.position AS position_73, s2_.is_active AS is_active_74, s2_.created_at AS created_at_75, s2_.updated_at AS updated_at_76, u3_.id AS id_77, u3_.email AS email_78, u3_.roles AS roles_79, u3_.password AS password_80, u3_.first_name AS first_name_81, u3_.last_name AS last_name_82, u3_.phone_number AS phone_number_83, u3_.phone_verified_at AS phone_verified_at_84, u3_.email_verified_at AS email_verified_at_85, u3_.is_verified AS is_verified_86, u3_.avatar AS avatar_87, u3_.locale AS locale_88, u3_.timezone AS timezone_89, u3_.status AS status_90, u3_.last_login_at AS last_login_at_91, u3_.login_count AS login_count_92, u3_.reset_token AS reset_token_93, u3_.reset_token_expires_at AS reset_token_expires_at_94, u3_.created_at AS created_at_95, u3_.updated_at AS updated_at_96, u3_.deleted_at AS deleted_at_97, u3_.notify_on_quote_request_received AS notify_on_quote_request_received_98, u3_.notify_on_message_received AS notify_on_message_received_99, u3_.notify_on_quote_request_accepted AS notify_on_quote_request_accepted_100, u3_.notify_on_review_received AS notify_on_review_received_101, s4_.id AS id_102, s4_.name AS name_103, s4_.slug AS slug_104, s4_.description AS description_105, s4_.icon AS icon_106, s4_.image AS image_107, s4_.position AS position_108, s4_.color AS color_109, s4_.seo_title AS seo_title_110, s4_.seo_description AS seo_description_111, s4_.created_at AS created_at_112, s4_.updated_at AS updated_at_113, s4_.is_active AS is_active_114, s5_.id AS id_115, s5_.name AS name_116, s5_.slug AS slug_117, s5_.description AS description_118, s5_.icon AS icon_119, s5_.image AS image_120, s5_.position AS position_121, s5_.color AS color_122, s5_.seo_title AS seo_title_123, s5_.seo_description AS seo_description_124, s5_.created_at AS created_at_125, s5_.updated_at AS updated_at_126, s5_.is_active AS is_active_127, p0_.prestataire_profile_id AS prestataire_profile_id_128, p0_.service_id AS service_id_129, p1_.user_id AS user_id_130, s2_.category_id AS category_id_131, s4_.parent_id AS parent_id_132, s5_.parent_id AS parent_id_133 FROM prestataire_profile_service p0_ INNER JOIN prestataire_profile p1_ ON p0_.prestataire_profile_id = p1_.id INNER JOIN service s2_ ON p0_.service_id = s2_.id LEFT JOIN "user" u3_ ON p1_.user_id = u3_.id LEFT JOIN service_category s4_ ON s2_.category_id = s4_.id LEFT JOIN service_category s5_ ON s4_.parent_id = s5_.id WHERE p1_.profile_status = ? AND p0_.is_active = ? AND p0_.taux_reduction IS NOT NULL AND p0_.taux_reduction > 0 ORDER BY p0_.id DESC LIMIT 4"
  "params" => [
    1 => "ACTIVE"
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1285
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1279
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.stripe_customer_id AS stripe_customer_id_2, t0.stripe_default_payment_method_id AS stripe_default_payment_method_id_3, t0.default_payment_method_type AS default_payment_method_type_4, t0.billing_email AS billing_email_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.prestataire_profile_id AS prestataire_profile_id_8 FROM subscription_customer t0 WHERE t0.prestataire_profile_id = ?"
  "params" => [
    1 => "14"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1285
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.type AS type_2, t0.company_name AS company_name_3, t0.siret AS siret_4, t0.billing_address AS billing_address_5, t0.billing_postal_code AS billing_postal_code_6, t0.billing_city AS billing_city_7, t0.billing_country AS billing_country_8, t0.default_address AS default_address_9, t0.default_postal_code AS default_postal_code_10, t0.default_city AS default_city_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.user_id AS user_id_16 FROM client_profile t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "25"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1285
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.stripe_customer_id AS stripe_customer_id_2, t0.stripe_default_payment_method_id AS stripe_default_payment_method_id_3, t0.default_payment_method_type AS default_payment_method_type_4, t0.billing_email AS billing_email_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.prestataire_profile_id AS prestataire_profile_id_8 FROM subscription_customer t0 WHERE t0.prestataire_profile_id = ?"
  "params" => [
    1 => "13"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1285
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.type AS type_2, t0.company_name AS company_name_3, t0.siret AS siret_4, t0.billing_address AS billing_address_5, t0.billing_postal_code AS billing_postal_code_6, t0.billing_city AS billing_city_7, t0.billing_country AS billing_country_8, t0.default_address AS default_address_9, t0.default_postal_code AS default_postal_code_10, t0.default_city AS default_city_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.user_id AS user_id_16 FROM client_profile t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "24"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1285
      +name: "STRING"
    }
  ]
]

[
  "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 {#1279
      +name: "BOOLEAN"
    }
    2 => Doctrine\DBAL\ParameterType {#1279}
  ]
]