Symfony Profiler

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 = ?

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 = '233';

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 = ?

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 = '127';

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,
  u1_.id AS id_50,
  u1_.email AS email_51,
  u1_.roles AS roles_52,
  u1_.password AS password_53,
  u1_.first_name AS first_name_54,
  u1_.last_name AS last_name_55,
  u1_.phone_number AS phone_number_56,
  u1_.phone_verified_at AS phone_verified_at_57,
  u1_.email_verified_at AS email_verified_at_58,
  u1_.is_verified AS is_verified_59,
  u1_.avatar AS avatar_60,
  u1_.locale AS locale_61,
  u1_.timezone AS timezone_62,
  u1_.status AS status_63,
  u1_.last_login_at AS last_login_at_64,
  u1_.login_count AS login_count_65,
  u1_.reset_token AS reset_token_66,
  u1_.reset_token_expires_at AS reset_token_expires_at_67,
  u1_.created_at AS created_at_68,
  u1_.updated_at AS updated_at_69,
  u1_.deleted_at AS deleted_at_70,
  u1_.notify_on_quote_request_received AS notify_on_quote_request_received_71,
  u1_.notify_on_message_received AS notify_on_message_received_72,
  u1_.notify_on_quote_request_accepted AS notify_on_quote_request_accepted_73,
  u1_.notify_on_review_received AS notify_on_review_received_74,
  p0_.user_id AS user_id_75
FROM
  prestataire_profile p0_
  LEFT JOIN "user" u1_ ON p0_.user_id = u1_.id
WHERE
  p0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

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, u1_.id AS id_50, u1_.email AS email_51, u1_.roles AS roles_52, u1_.password AS password_53, u1_.first_name AS first_name_54, u1_.last_name AS last_name_55, u1_.phone_number AS phone_number_56, u1_.phone_verified_at AS phone_verified_at_57, u1_.email_verified_at AS email_verified_at_58, u1_.is_verified AS is_verified_59, u1_.avatar AS avatar_60, u1_.locale AS locale_61, u1_.timezone AS timezone_62, u1_.status AS status_63, u1_.last_login_at AS last_login_at_64, u1_.login_count AS login_count_65, u1_.reset_token AS reset_token_66, u1_.reset_token_expires_at AS reset_token_expires_at_67, u1_.created_at AS created_at_68, u1_.updated_at AS updated_at_69, u1_.deleted_at AS deleted_at_70, u1_.notify_on_quote_request_received AS notify_on_quote_request_received_71, u1_.notify_on_message_received AS notify_on_message_received_72, u1_.notify_on_quote_request_accepted AS notify_on_quote_request_accepted_73, u1_.notify_on_review_received AS notify_on_review_received_74, p0_.user_id AS user_id_75 FROM prestataire_profile p0_ LEFT JOIN "user" u1_ ON p0_.user_id = u1_.id WHERE p0_.id IN (115, 117, 118, 116, 114, 123, 119, 121, 120, 125, 122, 124, 126, 127, 131, 130);

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,
  s0_.parent_id AS parent_id_13
FROM
  service_category s0_
WHERE
  s0_.parent_id IS NULL
  AND s0_.is_active = ?
ORDER BY
  s0_.position ASC,
  s0_.name ASC

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, s0_.parent_id AS parent_id_13 FROM service_category s0_ WHERE s0_.parent_id IS NULL AND s0_.is_active = 1 ORDER BY s0_.position ASC, s0_.name ASC;

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

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 = 1 AND (s1_.id IS NULL OR s1_.is_active = 1) ORDER BY s0_.position ASC, s1_.position ASC;