Symfony Profiler

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.average_price_min AS average_price_min_6,
  t0.average_price_max AS average_price_max_7,
  t0.position AS position_8,
  t0.is_active AS is_active_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.category_id AS category_id_12
FROM
  service t0
WHERE
  t0.slug = ?
LIMIT
  1

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.average_price_min AS average_price_min_6, t0.average_price_max AS average_price_max_7, t0.position AS position_8, t0.is_active AS is_active_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.category_id AS category_id_12 FROM service t0 WHERE t0.slug = 'depannage-de-fuite-d-eau' LIMIT 1;

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

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.id = 2;

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

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 = 'ACTIVE' AND p1_.is_active = 1 AND s2_.id = 1 ORDER BY p0_.created_at DESC;

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

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;