[
"sql" => "SELECT p0_.id AS id_0, p0_.company_name AS company_name_1, p0_.slug AS slug_2, p0_.legal_name AS legal_name_3, p0_.structure_type AS structure_type_4, p0_.siren AS siren_5, p0_.siret AS siret_6, p0_.vat_number AS vat_number_7, p0_.address AS address_8, p0_.address_complement AS address_complement_9, p0_.postal_code AS postal_code_10, p0_.city AS city_11, p0_.country AS country_12, p0_.latitude AS latitude_13, p0_.longitude AS longitude_14, p0_.geohash AS geohash_15, p0_.phone_public AS phone_public_16, p0_.phone_private AS phone_private_17, p0_.website AS website_18, p0_.facebook_url AS facebook_url_19, p0_.instagram_url AS instagram_url_20, p0_.linkedin_url AS linkedin_url_21, p0_.short_description AS short_description_22, p0_.long_description AS long_description_23, p0_.logo AS logo_24, p0_.cover_image AS cover_image_25, p0_.signature_image AS signature_image_26, p0_.profile_status AS profile_status_27, p0_.verification_status AS verification_status_28, p0_.completion_score AS completion_score_29, p0_.average_rating AS average_rating_30, p0_.reviews_count AS reviews_count_31, p0_.response_time_minutes AS response_time_minutes_32, p0_.is_featured AS is_featured_33, p0_.featured_until AS featured_until_34, p0_.search_visibility AS search_visibility_35, p0_.verified_at AS verified_at_36, p0_.created_at AS created_at_37, p0_.updated_at AS updated_at_38, p0_.deleted_at AS deleted_at_39, p0_.description AS description_40, p0_.metier AS metier_41, p0_.experience AS experience_42, p0_.document_verification_status AS document_verification_status_43, p0_.company_last_verification_at AS company_last_verification_at_44, p0_.company_verification_source AS company_verification_source_45, p0_.company_verification_note AS company_verification_note_46, p0_.is_on_vacation AS is_on_vacation_47, p0_.vacation_return_date AS vacation_return_date_48, p0_.user_id AS user_id_49 FROM prestataire_profile p0_ INNER JOIN prestataire_profile_service p1_ ON p0_.id = p1_.prestataire_profile_id INNER JOIN service s2_ ON p1_.service_id = s2_.id LEFT JOIN "user" u3_ ON p0_.user_id = u3_.id WHERE p0_.profile_status = ? AND p1_.is_active = ? AND s2_.id = ? ORDER BY p0_.created_at DESC"
"params" => [
1 => "ACTIVE"
2 => 1
3 => 11
]
"types" => [
1 => Doctrine\DBAL\ParameterType {#997
+name: "STRING"
}
2 => Doctrine\DBAL\ParameterType {#1286
+name: "BOOLEAN"
}
3 => Doctrine\DBAL\ParameterType {#999
+name: "INTEGER"
}
]
]