Symfony Profiler

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
WHERE
  t0.slug = ?
LIMIT
  1

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 WHERE t0.slug = 'plombeo-services-12' LIMIT 1;

SELECT
  r0_.id AS id_0,
  r0_.rating AS rating_1,
  r0_.comment AS comment_2,
  r0_.created_at AS created_at_3,
  r0_.updated_at AS updated_at_4,
  c1_.id AS id_5,
  c1_.type AS type_6,
  c1_.company_name AS company_name_7,
  c1_.siret AS siret_8,
  c1_.billing_address AS billing_address_9,
  c1_.billing_postal_code AS billing_postal_code_10,
  c1_.billing_city AS billing_city_11,
  c1_.billing_country AS billing_country_12,
  c1_.default_address AS default_address_13,
  c1_.default_postal_code AS default_postal_code_14,
  c1_.default_city AS default_city_15,
  c1_.latitude AS latitude_16,
  c1_.longitude AS longitude_17,
  c1_.created_at AS created_at_18,
  c1_.updated_at AS updated_at_19,
  u2_.id AS id_20,
  u2_.email AS email_21,
  u2_.roles AS roles_22,
  u2_.password AS password_23,
  u2_.first_name AS first_name_24,
  u2_.last_name AS last_name_25,
  u2_.phone_number AS phone_number_26,
  u2_.phone_verified_at AS phone_verified_at_27,
  u2_.email_verified_at AS email_verified_at_28,
  u2_.is_verified AS is_verified_29,
  u2_.avatar AS avatar_30,
  u2_.locale AS locale_31,
  u2_.timezone AS timezone_32,
  u2_.status AS status_33,
  u2_.last_login_at AS last_login_at_34,
  u2_.login_count AS login_count_35,
  u2_.reset_token AS reset_token_36,
  u2_.reset_token_expires_at AS reset_token_expires_at_37,
  u2_.created_at AS created_at_38,
  u2_.updated_at AS updated_at_39,
  u2_.deleted_at AS deleted_at_40,
  u2_.notify_on_quote_request_received AS notify_on_quote_request_received_41,
  u2_.notify_on_message_received AS notify_on_message_received_42,
  u2_.notify_on_quote_request_accepted AS notify_on_quote_request_accepted_43,
  u2_.notify_on_review_received AS notify_on_review_received_44,
  q3_.id AS id_45,
  q3_.title AS title_46,
  q3_.slug AS slug_47,
  q3_.description AS description_48,
  q3_.budget_amount AS budget_amount_49,
  q3_.desired_date AS desired_date_50,
  q3_.status AS status_51,
  q3_.created_at AS created_at_52,
  q3_.updated_at AS updated_at_53,
  q3_.deleted_at AS deleted_at_54,
  q3_.archived_by_client_at AS archived_by_client_at_55,
  q3_.archived_by_prestataire_at AS archived_by_prestataire_at_56,
  p4_.id AS id_57,
  p4_.is_active AS is_active_58,
  p4_.title AS title_59,
  p4_.short_description AS short_description_60,
  p4_.description AS description_61,
  p4_.pricing_type AS pricing_type_62,
  p4_.price_from AS price_from_63,
  p4_.price_to AS price_to_64,
  p4_.price_unit AS price_unit_65,
  p4_.additional_info AS additional_info_66,
  p4_.position AS position_67,
  p4_.prix_catalogue AS prix_catalogue_68,
  p4_.taux_reduction AS taux_reduction_69,
  p4_.promotion_created_at AS promotion_created_at_70,
  p4_.created_at AS created_at_71,
  p4_.updated_at AS updated_at_72,
  p4_.slug AS slug_73,
  s5_.id AS id_74,
  s5_.name AS name_75,
  s5_.slug AS slug_76,
  s5_.description AS description_77,
  s5_.icon AS icon_78,
  s5_.average_price_min AS average_price_min_79,
  s5_.average_price_max AS average_price_max_80,
  s5_.position AS position_81,
  s5_.is_active AS is_active_82,
  s5_.created_at AS created_at_83,
  s5_.updated_at AS updated_at_84,
  r0_.client_profile_id AS client_profile_id_85,
  r0_.prestataire_profile_id AS prestataire_profile_id_86,
  r0_.quote_request_id AS quote_request_id_87,
  c1_.user_id AS user_id_88,
  q3_.client_id AS client_id_89,
  q3_.prestataire_id AS prestataire_id_90,
  q3_.prestation_id AS prestation_id_91,
  p4_.prestataire_profile_id AS prestataire_profile_id_92,
  p4_.service_id AS service_id_93,
  s5_.category_id AS category_id_94
FROM
  review r0_
  LEFT JOIN client_profile c1_ ON r0_.client_profile_id = c1_.id
  LEFT JOIN "user" u2_ ON c1_.user_id = u2_.id
  LEFT JOIN quote_request q3_ ON r0_.quote_request_id = q3_.id
  LEFT JOIN prestataire_profile_service p4_ ON q3_.prestation_id = p4_.id
  LEFT JOIN service s5_ ON p4_.service_id = s5_.id
WHERE
  r0_.prestataire_profile_id = ?
ORDER BY
  r0_.created_at DESC,
  r0_.id DESC

SELECT r0_.id AS id_0, r0_.rating AS rating_1, r0_.comment AS comment_2, r0_.created_at AS created_at_3, r0_.updated_at AS updated_at_4, c1_.id AS id_5, c1_.type AS type_6, c1_.company_name AS company_name_7, c1_.siret AS siret_8, c1_.billing_address AS billing_address_9, c1_.billing_postal_code AS billing_postal_code_10, c1_.billing_city AS billing_city_11, c1_.billing_country AS billing_country_12, c1_.default_address AS default_address_13, c1_.default_postal_code AS default_postal_code_14, c1_.default_city AS default_city_15, c1_.latitude AS latitude_16, c1_.longitude AS longitude_17, c1_.created_at AS created_at_18, c1_.updated_at AS updated_at_19, u2_.id AS id_20, u2_.email AS email_21, u2_.roles AS roles_22, u2_.password AS password_23, u2_.first_name AS first_name_24, u2_.last_name AS last_name_25, u2_.phone_number AS phone_number_26, u2_.phone_verified_at AS phone_verified_at_27, u2_.email_verified_at AS email_verified_at_28, u2_.is_verified AS is_verified_29, u2_.avatar AS avatar_30, u2_.locale AS locale_31, u2_.timezone AS timezone_32, u2_.status AS status_33, u2_.last_login_at AS last_login_at_34, u2_.login_count AS login_count_35, u2_.reset_token AS reset_token_36, u2_.reset_token_expires_at AS reset_token_expires_at_37, u2_.created_at AS created_at_38, u2_.updated_at AS updated_at_39, u2_.deleted_at AS deleted_at_40, u2_.notify_on_quote_request_received AS notify_on_quote_request_received_41, u2_.notify_on_message_received AS notify_on_message_received_42, u2_.notify_on_quote_request_accepted AS notify_on_quote_request_accepted_43, u2_.notify_on_review_received AS notify_on_review_received_44, q3_.id AS id_45, q3_.title AS title_46, q3_.slug AS slug_47, q3_.description AS description_48, q3_.budget_amount AS budget_amount_49, q3_.desired_date AS desired_date_50, q3_.status AS status_51, q3_.created_at AS created_at_52, q3_.updated_at AS updated_at_53, q3_.deleted_at AS deleted_at_54, q3_.archived_by_client_at AS archived_by_client_at_55, q3_.archived_by_prestataire_at AS archived_by_prestataire_at_56, p4_.id AS id_57, p4_.is_active AS is_active_58, p4_.title AS title_59, p4_.short_description AS short_description_60, p4_.description AS description_61, p4_.pricing_type AS pricing_type_62, p4_.price_from AS price_from_63, p4_.price_to AS price_to_64, p4_.price_unit AS price_unit_65, p4_.additional_info AS additional_info_66, p4_.position AS position_67, p4_.prix_catalogue AS prix_catalogue_68, p4_.taux_reduction AS taux_reduction_69, p4_.promotion_created_at AS promotion_created_at_70, p4_.created_at AS created_at_71, p4_.updated_at AS updated_at_72, p4_.slug AS slug_73, s5_.id AS id_74, s5_.name AS name_75, s5_.slug AS slug_76, s5_.description AS description_77, s5_.icon AS icon_78, s5_.average_price_min AS average_price_min_79, s5_.average_price_max AS average_price_max_80, s5_.position AS position_81, s5_.is_active AS is_active_82, s5_.created_at AS created_at_83, s5_.updated_at AS updated_at_84, r0_.client_profile_id AS client_profile_id_85, r0_.prestataire_profile_id AS prestataire_profile_id_86, r0_.quote_request_id AS quote_request_id_87, c1_.user_id AS user_id_88, q3_.client_id AS client_id_89, q3_.prestataire_id AS prestataire_id_90, q3_.prestation_id AS prestation_id_91, p4_.prestataire_profile_id AS prestataire_profile_id_92, p4_.service_id AS service_id_93, s5_.category_id AS category_id_94 FROM review r0_ LEFT JOIN client_profile c1_ ON r0_.client_profile_id = c1_.id LEFT JOIN "user" u2_ ON c1_.user_id = u2_.id LEFT JOIN quote_request q3_ ON r0_.quote_request_id = q3_.id LEFT JOIN prestataire_profile_service p4_ ON q3_.prestation_id = p4_.id LEFT JOIN service s5_ ON p4_.service_id = s5_.id WHERE r0_.prestataire_profile_id = 12 ORDER BY r0_.created_at DESC, r0_.id DESC;

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;