Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.is_active AS is_active_1,
  p0_.title AS title_2,
  p0_.short_description AS short_description_3,
  p0_.description AS description_4,
  p0_.pricing_type AS pricing_type_5,
  p0_.price_from AS price_from_6,
  p0_.price_to AS price_to_7,
  p0_.price_unit AS price_unit_8,
  p0_.additional_info AS additional_info_9,
  p0_.position AS position_10,
  p0_.prix_catalogue AS prix_catalogue_11,
  p0_.taux_reduction AS taux_reduction_12,
  p0_.promotion_created_at AS promotion_created_at_13,
  p0_.created_at AS created_at_14,
  p0_.updated_at AS updated_at_15,
  p0_.slug AS slug_16,
  p1_.id AS id_17,
  p1_.company_name AS company_name_18,
  p1_.slug AS slug_19,
  p1_.legal_name AS legal_name_20,
  p1_.structure_type AS structure_type_21,
  p1_.siren AS siren_22,
  p1_.siret AS siret_23,
  p1_.naf_code AS naf_code_24,
  p1_.vat_number AS vat_number_25,
  p1_.address AS address_26,
  p1_.address_complement AS address_complement_27,
  p1_.postal_code AS postal_code_28,
  p1_.city AS city_29,
  p1_.country AS country_30,
  p1_.latitude AS latitude_31,
  p1_.longitude AS longitude_32,
  p1_.geohash AS geohash_33,
  p1_.phone_public AS phone_public_34,
  p1_.phone_private AS phone_private_35,
  p1_.website AS website_36,
  p1_.facebook_url AS facebook_url_37,
  p1_.instagram_url AS instagram_url_38,
  p1_.linkedin_url AS linkedin_url_39,
  p1_.short_description AS short_description_40,
  p1_.long_description AS long_description_41,
  p1_.logo AS logo_42,
  p1_.cover_image AS cover_image_43,
  p1_.signature_image AS signature_image_44,
  p1_.profile_status AS profile_status_45,
  p1_.verification_status AS verification_status_46,
  p1_.completion_score AS completion_score_47,
  p1_.average_rating AS average_rating_48,
  p1_.reviews_count AS reviews_count_49,
  p1_.response_time_minutes AS response_time_minutes_50,
  p1_.is_featured AS is_featured_51,
  p1_.featured_until AS featured_until_52,
  p1_.search_visibility AS search_visibility_53,
  p1_.verified_at AS verified_at_54,
  p1_.created_at AS created_at_55,
  p1_.updated_at AS updated_at_56,
  p1_.deleted_at AS deleted_at_57,
  p1_.description AS description_58,
  p1_.metier AS metier_59,
  p1_.experience AS experience_60,
  p1_.document_verification_status AS document_verification_status_61,
  p1_.company_last_verification_at AS company_last_verification_at_62,
  p1_.company_verification_source AS company_verification_source_63,
  p1_.company_verification_note AS company_verification_note_64,
  p1_.is_on_vacation AS is_on_vacation_65,
  p1_.vacation_return_date AS vacation_return_date_66,
  s2_.id AS id_67,
  s2_.name AS name_68,
  s2_.slug AS slug_69,
  s2_.description AS description_70,
  s2_.icon AS icon_71,
  s2_.image AS image_72,
  s2_.average_price_min AS average_price_min_73,
  s2_.average_price_max AS average_price_max_74,
  s2_.position AS position_75,
  s2_.is_active AS is_active_76,
  s2_.created_at AS created_at_77,
  s2_.updated_at AS updated_at_78,
  u3_.id AS id_79,
  u3_.email AS email_80,
  u3_.roles AS roles_81,
  u3_.password AS password_82,
  u3_.first_name AS first_name_83,
  u3_.last_name AS last_name_84,
  u3_.phone_number AS phone_number_85,
  u3_.phone_verified_at AS phone_verified_at_86,
  u3_.email_verified_at AS email_verified_at_87,
  u3_.is_verified AS is_verified_88,
  u3_.avatar AS avatar_89,
  u3_.locale AS locale_90,
  u3_.timezone AS timezone_91,
  u3_.status AS status_92,
  u3_.last_login_at AS last_login_at_93,
  u3_.login_count AS login_count_94,
  u3_.reset_token AS reset_token_95,
  u3_.reset_token_expires_at AS reset_token_expires_at_96,
  u3_.created_at AS created_at_97,
  u3_.updated_at AS updated_at_98,
  u3_.deleted_at AS deleted_at_99,
  u3_.notify_on_quote_request_received AS notify_on_quote_request_received_100,
  u3_.notify_on_message_received AS notify_on_message_received_101,
  u3_.notify_on_quote_request_accepted AS notify_on_quote_request_accepted_102,
  u3_.notify_on_review_received AS notify_on_review_received_103,
  s4_.id AS id_104,
  s4_.name AS name_105,
  s4_.slug AS slug_106,
  s4_.description AS description_107,
  s4_.icon AS icon_108,
  s4_.image AS image_109,
  s4_.position AS position_110,
  s4_.color AS color_111,
  s4_.seo_title AS seo_title_112,
  s4_.seo_description AS seo_description_113,
  s4_.created_at AS created_at_114,
  s4_.updated_at AS updated_at_115,
  s4_.is_active AS is_active_116,
  s5_.id AS id_117,
  s5_.name AS name_118,
  s5_.slug AS slug_119,
  s5_.description AS description_120,
  s5_.icon AS icon_121,
  s5_.image AS image_122,
  s5_.position AS position_123,
  s5_.color AS color_124,
  s5_.seo_title AS seo_title_125,
  s5_.seo_description AS seo_description_126,
  s5_.created_at AS created_at_127,
  s5_.updated_at AS updated_at_128,
  s5_.is_active AS is_active_129,
  p0_.prestataire_profile_id AS prestataire_profile_id_130,
  p0_.service_id AS service_id_131,
  p1_.user_id AS user_id_132,
  s2_.category_id AS category_id_133,
  s4_.parent_id AS parent_id_134,
  s5_.parent_id AS parent_id_135
FROM
  prestataire_profile_service p0_
  INNER JOIN prestataire_profile p1_ ON p0_.prestataire_profile_id = p1_.id
  INNER JOIN service s2_ ON p0_.service_id = s2_.id
  LEFT JOIN "user" u3_ ON p1_.user_id = u3_.id
  LEFT JOIN service_category s4_ ON s2_.category_id = s4_.id
  LEFT JOIN service_category s5_ ON s4_.parent_id = s5_.id
WHERE
  p1_.profile_status = ?
  AND p0_.is_active = ?
  AND p0_.taux_reduction IS NOT NULL
  AND p0_.taux_reduction > 0
ORDER BY
  p0_.id DESC
LIMIT
  4

SELECT p0_.id AS id_0, p0_.is_active AS is_active_1, p0_.title AS title_2, p0_.short_description AS short_description_3, p0_.description AS description_4, p0_.pricing_type AS pricing_type_5, p0_.price_from AS price_from_6, p0_.price_to AS price_to_7, p0_.price_unit AS price_unit_8, p0_.additional_info AS additional_info_9, p0_.position AS position_10, p0_.prix_catalogue AS prix_catalogue_11, p0_.taux_reduction AS taux_reduction_12, p0_.promotion_created_at AS promotion_created_at_13, p0_.created_at AS created_at_14, p0_.updated_at AS updated_at_15, p0_.slug AS slug_16, p1_.id AS id_17, p1_.company_name AS company_name_18, p1_.slug AS slug_19, p1_.legal_name AS legal_name_20, p1_.structure_type AS structure_type_21, p1_.siren AS siren_22, p1_.siret AS siret_23, p1_.naf_code AS naf_code_24, p1_.vat_number AS vat_number_25, p1_.address AS address_26, p1_.address_complement AS address_complement_27, p1_.postal_code AS postal_code_28, p1_.city AS city_29, p1_.country AS country_30, p1_.latitude AS latitude_31, p1_.longitude AS longitude_32, p1_.geohash AS geohash_33, p1_.phone_public AS phone_public_34, p1_.phone_private AS phone_private_35, p1_.website AS website_36, p1_.facebook_url AS facebook_url_37, p1_.instagram_url AS instagram_url_38, p1_.linkedin_url AS linkedin_url_39, p1_.short_description AS short_description_40, p1_.long_description AS long_description_41, p1_.logo AS logo_42, p1_.cover_image AS cover_image_43, p1_.signature_image AS signature_image_44, p1_.profile_status AS profile_status_45, p1_.verification_status AS verification_status_46, p1_.completion_score AS completion_score_47, p1_.average_rating AS average_rating_48, p1_.reviews_count AS reviews_count_49, p1_.response_time_minutes AS response_time_minutes_50, p1_.is_featured AS is_featured_51, p1_.featured_until AS featured_until_52, p1_.search_visibility AS search_visibility_53, p1_.verified_at AS verified_at_54, p1_.created_at AS created_at_55, p1_.updated_at AS updated_at_56, p1_.deleted_at AS deleted_at_57, p1_.description AS description_58, p1_.metier AS metier_59, p1_.experience AS experience_60, p1_.document_verification_status AS document_verification_status_61, p1_.company_last_verification_at AS company_last_verification_at_62, p1_.company_verification_source AS company_verification_source_63, p1_.company_verification_note AS company_verification_note_64, p1_.is_on_vacation AS is_on_vacation_65, p1_.vacation_return_date AS vacation_return_date_66, s2_.id AS id_67, s2_.name AS name_68, s2_.slug AS slug_69, s2_.description AS description_70, s2_.icon AS icon_71, s2_.image AS image_72, s2_.average_price_min AS average_price_min_73, s2_.average_price_max AS average_price_max_74, s2_.position AS position_75, s2_.is_active AS is_active_76, s2_.created_at AS created_at_77, s2_.updated_at AS updated_at_78, u3_.id AS id_79, u3_.email AS email_80, u3_.roles AS roles_81, u3_.password AS password_82, u3_.first_name AS first_name_83, u3_.last_name AS last_name_84, u3_.phone_number AS phone_number_85, u3_.phone_verified_at AS phone_verified_at_86, u3_.email_verified_at AS email_verified_at_87, u3_.is_verified AS is_verified_88, u3_.avatar AS avatar_89, u3_.locale AS locale_90, u3_.timezone AS timezone_91, u3_.status AS status_92, u3_.last_login_at AS last_login_at_93, u3_.login_count AS login_count_94, u3_.reset_token AS reset_token_95, u3_.reset_token_expires_at AS reset_token_expires_at_96, u3_.created_at AS created_at_97, u3_.updated_at AS updated_at_98, u3_.deleted_at AS deleted_at_99, u3_.notify_on_quote_request_received AS notify_on_quote_request_received_100, u3_.notify_on_message_received AS notify_on_message_received_101, u3_.notify_on_quote_request_accepted AS notify_on_quote_request_accepted_102, u3_.notify_on_review_received AS notify_on_review_received_103, s4_.id AS id_104, s4_.name AS name_105, s4_.slug AS slug_106, s4_.description AS description_107, s4_.icon AS icon_108, s4_.image AS image_109, s4_.position AS position_110, s4_.color AS color_111, s4_.seo_title AS seo_title_112, s4_.seo_description AS seo_description_113, s4_.created_at AS created_at_114, s4_.updated_at AS updated_at_115, s4_.is_active AS is_active_116, s5_.id AS id_117, s5_.name AS name_118, s5_.slug AS slug_119, s5_.description AS description_120, s5_.icon AS icon_121, s5_.image AS image_122, s5_.position AS position_123, s5_.color AS color_124, s5_.seo_title AS seo_title_125, s5_.seo_description AS seo_description_126, s5_.created_at AS created_at_127, s5_.updated_at AS updated_at_128, s5_.is_active AS is_active_129, p0_.prestataire_profile_id AS prestataire_profile_id_130, p0_.service_id AS service_id_131, p1_.user_id AS user_id_132, s2_.category_id AS category_id_133, s4_.parent_id AS parent_id_134, s5_.parent_id AS parent_id_135 FROM prestataire_profile_service p0_ INNER JOIN prestataire_profile p1_ ON p0_.prestataire_profile_id = p1_.id INNER JOIN service s2_ ON p0_.service_id = s2_.id LEFT JOIN "user" u3_ ON p1_.user_id = u3_.id LEFT JOIN service_category s4_ ON s2_.category_id = s4_.id LEFT JOIN service_category s5_ ON s4_.parent_id = s5_.id WHERE p1_.profile_status = 'ACTIVE' AND p0_.is_active = 1 AND p0_.taux_reduction IS NOT NULL AND p0_.taux_reduction > 0 ORDER BY p0_.id DESC LIMIT 4;

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_.parent_id = s1_.id
WHERE
  s0_.is_active = ?
  AND s0_.parent_id IS NOT NULL
ORDER BY
  s1_.position ASC,
  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_.parent_id = s1_.id WHERE s0_.is_active = 1 AND s0_.parent_id IS NOT NULL ORDER BY s1_.position ASC, s0_.position ASC, s0_.name ASC;

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
  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;