[
"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_.naf_code AS naf_code_7, p0_.vat_number AS vat_number_8, p0_.address AS address_9, p0_.address_complement AS address_complement_10, p0_.postal_code AS postal_code_11, p0_.city AS city_12, p0_.country AS country_13, p0_.latitude AS latitude_14, p0_.longitude AS longitude_15, p0_.geohash AS geohash_16, p0_.phone_public AS phone_public_17, p0_.phone_private AS phone_private_18, p0_.website AS website_19, p0_.facebook_url AS facebook_url_20, p0_.instagram_url AS instagram_url_21, p0_.linkedin_url AS linkedin_url_22, p0_.short_description AS short_description_23, p0_.long_description AS long_description_24, p0_.logo AS logo_25, p0_.cover_image AS cover_image_26, p0_.signature_image AS signature_image_27, p0_.profile_status AS profile_status_28, p0_.verification_status AS verification_status_29, p0_.completion_score AS completion_score_30, p0_.average_rating AS average_rating_31, p0_.reviews_count AS reviews_count_32, p0_.response_time_minutes AS response_time_minutes_33, p0_.is_featured AS is_featured_34, p0_.featured_until AS featured_until_35, p0_.search_visibility AS search_visibility_36, p0_.verified_at AS verified_at_37, p0_.created_at AS created_at_38, p0_.updated_at AS updated_at_39, p0_.deleted_at AS deleted_at_40, p0_.description AS description_41, p0_.metier AS metier_42, p0_.experience AS experience_43, p0_.document_verification_status AS document_verification_status_44, p0_.company_last_verification_at AS company_last_verification_at_45, p0_.company_verification_source AS company_verification_source_46, p0_.company_verification_note AS company_verification_note_47, p0_.is_on_vacation AS is_on_vacation_48, p0_.vacation_return_date AS vacation_return_date_49, p0_.user_id AS user_id_50 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 => 242
]
"types" => [
1 => Doctrine\DBAL\ParameterType {#987
+name: "STRING"
}
2 => Doctrine\DBAL\ParameterType {#1283
+name: "BOOLEAN"
}
3 => Doctrine\DBAL\ParameterType {#989
+name: "INTEGER"
}
]
]