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.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.parent_id IS NULL
  AND t0.is_active = ?
ORDER BY
  t0.position ASC

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.parent_id IS NULL AND t0.is_active = 1 ORDER BY t0.position ASC;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        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_.vat_number AS vat_number_24,
          p1_.address AS address_25,
          p1_.address_complement AS address_complement_26,
          p1_.postal_code AS postal_code_27,
          p1_.city AS city_28,
          p1_.country AS country_29,
          p1_.latitude AS latitude_30,
          p1_.longitude AS longitude_31,
          p1_.geohash AS geohash_32,
          p1_.phone_public AS phone_public_33,
          p1_.phone_private AS phone_private_34,
          p1_.website AS website_35,
          p1_.facebook_url AS facebook_url_36,
          p1_.instagram_url AS instagram_url_37,
          p1_.linkedin_url AS linkedin_url_38,
          p1_.short_description AS short_description_39,
          p1_.long_description AS long_description_40,
          p1_.logo AS logo_41,
          p1_.cover_image AS cover_image_42,
          p1_.signature_image AS signature_image_43,
          p1_.profile_status AS profile_status_44,
          p1_.verification_status AS verification_status_45,
          p1_.completion_score AS completion_score_46,
          p1_.average_rating AS average_rating_47,
          p1_.reviews_count AS reviews_count_48,
          p1_.response_time_minutes AS response_time_minutes_49,
          p1_.is_featured AS is_featured_50,
          p1_.featured_until AS featured_until_51,
          p1_.search_visibility AS search_visibility_52,
          p1_.verified_at AS verified_at_53,
          p1_.created_at AS created_at_54,
          p1_.updated_at AS updated_at_55,
          p1_.deleted_at AS deleted_at_56,
          p1_.description AS description_57,
          p1_.metier AS metier_58,
          p1_.experience AS experience_59,
          p1_.document_verification_status AS document_verification_status_60,
          p1_.company_last_verification_at AS company_last_verification_at_61,
          p1_.company_verification_source AS company_verification_source_62,
          p1_.company_verification_note AS company_verification_note_63,
          p1_.is_on_vacation AS is_on_vacation_64,
          p1_.vacation_return_date AS vacation_return_date_65,
          s2_.id AS id_66,
          s2_.name AS name_67,
          s2_.slug AS slug_68,
          s2_.description AS description_69,
          s2_.icon AS icon_70,
          s2_.average_price_min AS average_price_min_71,
          s2_.average_price_max AS average_price_max_72,
          s2_.position AS position_73,
          s2_.is_active AS is_active_74,
          s2_.created_at AS created_at_75,
          s2_.updated_at AS updated_at_76,
          u3_.id AS id_77,
          u3_.email AS email_78,
          u3_.roles AS roles_79,
          u3_.password AS password_80,
          u3_.first_name AS first_name_81,
          u3_.last_name AS last_name_82,
          u3_.phone_number AS phone_number_83,
          u3_.phone_verified_at AS phone_verified_at_84,
          u3_.email_verified_at AS email_verified_at_85,
          u3_.is_verified AS is_verified_86,
          u3_.avatar AS avatar_87,
          u3_.locale AS locale_88,
          u3_.timezone AS timezone_89,
          u3_.status AS status_90,
          u3_.last_login_at AS last_login_at_91,
          u3_.login_count AS login_count_92,
          u3_.reset_token AS reset_token_93,
          u3_.reset_token_expires_at AS reset_token_expires_at_94,
          u3_.created_at AS created_at_95,
          u3_.updated_at AS updated_at_96,
          u3_.deleted_at AS deleted_at_97,
          u3_.notify_on_quote_request_received AS notify_on_quote_request_received_98,
          u3_.notify_on_message_received AS notify_on_message_received_99,
          u3_.notify_on_quote_request_accepted AS notify_on_quote_request_accepted_100,
          u3_.notify_on_review_received AS notify_on_review_received_101,
          s4_.id AS id_102,
          s4_.name AS name_103,
          s4_.slug AS slug_104,
          s4_.description AS description_105,
          s4_.icon AS icon_106,
          s4_.image AS image_107,
          s4_.position AS position_108,
          s4_.color AS color_109,
          s4_.seo_title AS seo_title_110,
          s4_.seo_description AS seo_description_111,
          s4_.created_at AS created_at_112,
          s4_.updated_at AS updated_at_113,
          s4_.is_active AS is_active_114,
          s5_.id AS id_115,
          s5_.name AS name_116,
          s5_.slug AS slug_117,
          s5_.description AS description_118,
          s5_.icon AS icon_119,
          s5_.image AS image_120,
          s5_.position AS position_121,
          s5_.color AS color_122,
          s5_.seo_title AS seo_title_123,
          s5_.seo_description AS seo_description_124,
          s5_.created_at AS created_at_125,
          s5_.updated_at AS updated_at_126,
          s5_.is_active AS is_active_127
        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_.taux_reduction DESC,
          p0_.id DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (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_.vat_number AS vat_number_24, p1_.address AS address_25, p1_.address_complement AS address_complement_26, p1_.postal_code AS postal_code_27, p1_.city AS city_28, p1_.country AS country_29, p1_.latitude AS latitude_30, p1_.longitude AS longitude_31, p1_.geohash AS geohash_32, p1_.phone_public AS phone_public_33, p1_.phone_private AS phone_private_34, p1_.website AS website_35, p1_.facebook_url AS facebook_url_36, p1_.instagram_url AS instagram_url_37, p1_.linkedin_url AS linkedin_url_38, p1_.short_description AS short_description_39, p1_.long_description AS long_description_40, p1_.logo AS logo_41, p1_.cover_image AS cover_image_42, p1_.signature_image AS signature_image_43, p1_.profile_status AS profile_status_44, p1_.verification_status AS verification_status_45, p1_.completion_score AS completion_score_46, p1_.average_rating AS average_rating_47, p1_.reviews_count AS reviews_count_48, p1_.response_time_minutes AS response_time_minutes_49, p1_.is_featured AS is_featured_50, p1_.featured_until AS featured_until_51, p1_.search_visibility AS search_visibility_52, p1_.verified_at AS verified_at_53, p1_.created_at AS created_at_54, p1_.updated_at AS updated_at_55, p1_.deleted_at AS deleted_at_56, p1_.description AS description_57, p1_.metier AS metier_58, p1_.experience AS experience_59, p1_.document_verification_status AS document_verification_status_60, p1_.company_last_verification_at AS company_last_verification_at_61, p1_.company_verification_source AS company_verification_source_62, p1_.company_verification_note AS company_verification_note_63, p1_.is_on_vacation AS is_on_vacation_64, p1_.vacation_return_date AS vacation_return_date_65, s2_.id AS id_66, s2_.name AS name_67, s2_.slug AS slug_68, s2_.description AS description_69, s2_.icon AS icon_70, s2_.average_price_min AS average_price_min_71, s2_.average_price_max AS average_price_max_72, s2_.position AS position_73, s2_.is_active AS is_active_74, s2_.created_at AS created_at_75, s2_.updated_at AS updated_at_76, u3_.id AS id_77, u3_.email AS email_78, u3_.roles AS roles_79, u3_.password AS password_80, u3_.first_name AS first_name_81, u3_.last_name AS last_name_82, u3_.phone_number AS phone_number_83, u3_.phone_verified_at AS phone_verified_at_84, u3_.email_verified_at AS email_verified_at_85, u3_.is_verified AS is_verified_86, u3_.avatar AS avatar_87, u3_.locale AS locale_88, u3_.timezone AS timezone_89, u3_.status AS status_90, u3_.last_login_at AS last_login_at_91, u3_.login_count AS login_count_92, u3_.reset_token AS reset_token_93, u3_.reset_token_expires_at AS reset_token_expires_at_94, u3_.created_at AS created_at_95, u3_.updated_at AS updated_at_96, u3_.deleted_at AS deleted_at_97, u3_.notify_on_quote_request_received AS notify_on_quote_request_received_98, u3_.notify_on_message_received AS notify_on_message_received_99, u3_.notify_on_quote_request_accepted AS notify_on_quote_request_accepted_100, u3_.notify_on_review_received AS notify_on_review_received_101, s4_.id AS id_102, s4_.name AS name_103, s4_.slug AS slug_104, s4_.description AS description_105, s4_.icon AS icon_106, s4_.image AS image_107, s4_.position AS position_108, s4_.color AS color_109, s4_.seo_title AS seo_title_110, s4_.seo_description AS seo_description_111, s4_.created_at AS created_at_112, s4_.updated_at AS updated_at_113, s4_.is_active AS is_active_114, s5_.id AS id_115, s5_.name AS name_116, s5_.slug AS slug_117, s5_.description AS description_118, s5_.icon AS icon_119, s5_.image AS image_120, s5_.position AS position_121, s5_.color AS color_122, s5_.seo_title AS seo_title_123, s5_.seo_description AS seo_description_124, s5_.created_at AS created_at_125, s5_.updated_at AS updated_at_126, s5_.is_active AS is_active_127 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_.taux_reduction DESC, p0_.id DESC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0,
  MIN(sclr_128) AS dctrn_minrownum
FROM
  (
    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_.vat_number AS vat_number_24,
      p1_.address AS address_25,
      p1_.address_complement AS address_complement_26,
      p1_.postal_code AS postal_code_27,
      p1_.city AS city_28,
      p1_.country AS country_29,
      p1_.latitude AS latitude_30,
      p1_.longitude AS longitude_31,
      p1_.geohash AS geohash_32,
      p1_.phone_public AS phone_public_33,
      p1_.phone_private AS phone_private_34,
      p1_.website AS website_35,
      p1_.facebook_url AS facebook_url_36,
      p1_.instagram_url AS instagram_url_37,
      p1_.linkedin_url AS linkedin_url_38,
      p1_.short_description AS short_description_39,
      p1_.long_description AS long_description_40,
      p1_.logo AS logo_41,
      p1_.cover_image AS cover_image_42,
      p1_.signature_image AS signature_image_43,
      p1_.profile_status AS profile_status_44,
      p1_.verification_status AS verification_status_45,
      p1_.completion_score AS completion_score_46,
      p1_.average_rating AS average_rating_47,
      p1_.reviews_count AS reviews_count_48,
      p1_.response_time_minutes AS response_time_minutes_49,
      p1_.is_featured AS is_featured_50,
      p1_.featured_until AS featured_until_51,
      p1_.search_visibility AS search_visibility_52,
      p1_.verified_at AS verified_at_53,
      p1_.created_at AS created_at_54,
      p1_.updated_at AS updated_at_55,
      p1_.deleted_at AS deleted_at_56,
      p1_.description AS description_57,
      p1_.metier AS metier_58,
      p1_.experience AS experience_59,
      p1_.document_verification_status AS document_verification_status_60,
      p1_.company_last_verification_at AS company_last_verification_at_61,
      p1_.company_verification_source AS company_verification_source_62,
      p1_.company_verification_note AS company_verification_note_63,
      p1_.is_on_vacation AS is_on_vacation_64,
      p1_.vacation_return_date AS vacation_return_date_65,
      s2_.id AS id_66,
      s2_.name AS name_67,
      s2_.slug AS slug_68,
      s2_.description AS description_69,
      s2_.icon AS icon_70,
      s2_.average_price_min AS average_price_min_71,
      s2_.average_price_max AS average_price_max_72,
      s2_.position AS position_73,
      s2_.is_active AS is_active_74,
      s2_.created_at AS created_at_75,
      s2_.updated_at AS updated_at_76,
      u3_.id AS id_77,
      u3_.email AS email_78,
      u3_.roles AS roles_79,
      u3_.password AS password_80,
      u3_.first_name AS first_name_81,
      u3_.last_name AS last_name_82,
      u3_.phone_number AS phone_number_83,
      u3_.phone_verified_at AS phone_verified_at_84,
      u3_.email_verified_at AS email_verified_at_85,
      u3_.is_verified AS is_verified_86,
      u3_.avatar AS avatar_87,
      u3_.locale AS locale_88,
      u3_.timezone AS timezone_89,
      u3_.status AS status_90,
      u3_.last_login_at AS last_login_at_91,
      u3_.login_count AS login_count_92,
      u3_.reset_token AS reset_token_93,
      u3_.reset_token_expires_at AS reset_token_expires_at_94,
      u3_.created_at AS created_at_95,
      u3_.updated_at AS updated_at_96,
      u3_.deleted_at AS deleted_at_97,
      u3_.notify_on_quote_request_received AS notify_on_quote_request_received_98,
      u3_.notify_on_message_received AS notify_on_message_received_99,
      u3_.notify_on_quote_request_accepted AS notify_on_quote_request_accepted_100,
      u3_.notify_on_review_received AS notify_on_review_received_101,
      s4_.id AS id_102,
      s4_.name AS name_103,
      s4_.slug AS slug_104,
      s4_.description AS description_105,
      s4_.icon AS icon_106,
      s4_.image AS image_107,
      s4_.position AS position_108,
      s4_.color AS color_109,
      s4_.seo_title AS seo_title_110,
      s4_.seo_description AS seo_description_111,
      s4_.created_at AS created_at_112,
      s4_.updated_at AS updated_at_113,
      s4_.is_active AS is_active_114,
      s5_.id AS id_115,
      s5_.name AS name_116,
      s5_.slug AS slug_117,
      s5_.description AS description_118,
      s5_.icon AS icon_119,
      s5_.image AS image_120,
      s5_.position AS position_121,
      s5_.color AS color_122,
      s5_.seo_title AS seo_title_123,
      s5_.seo_description AS seo_description_124,
      s5_.created_at AS created_at_125,
      s5_.updated_at AS updated_at_126,
      s5_.is_active AS is_active_127,
      ROW_NUMBER() OVER(
        ORDER BY
          p0_.taux_reduction DESC,
          p0_.id DESC
      ) AS sclr_128
    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
  ) dctrn_result
GROUP BY
  id_0
ORDER BY
  dctrn_minrownum ASC
LIMIT
  9

SELECT DISTINCT id_0, MIN(sclr_128) AS dctrn_minrownum FROM (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_.vat_number AS vat_number_24, p1_.address AS address_25, p1_.address_complement AS address_complement_26, p1_.postal_code AS postal_code_27, p1_.city AS city_28, p1_.country AS country_29, p1_.latitude AS latitude_30, p1_.longitude AS longitude_31, p1_.geohash AS geohash_32, p1_.phone_public AS phone_public_33, p1_.phone_private AS phone_private_34, p1_.website AS website_35, p1_.facebook_url AS facebook_url_36, p1_.instagram_url AS instagram_url_37, p1_.linkedin_url AS linkedin_url_38, p1_.short_description AS short_description_39, p1_.long_description AS long_description_40, p1_.logo AS logo_41, p1_.cover_image AS cover_image_42, p1_.signature_image AS signature_image_43, p1_.profile_status AS profile_status_44, p1_.verification_status AS verification_status_45, p1_.completion_score AS completion_score_46, p1_.average_rating AS average_rating_47, p1_.reviews_count AS reviews_count_48, p1_.response_time_minutes AS response_time_minutes_49, p1_.is_featured AS is_featured_50, p1_.featured_until AS featured_until_51, p1_.search_visibility AS search_visibility_52, p1_.verified_at AS verified_at_53, p1_.created_at AS created_at_54, p1_.updated_at AS updated_at_55, p1_.deleted_at AS deleted_at_56, p1_.description AS description_57, p1_.metier AS metier_58, p1_.experience AS experience_59, p1_.document_verification_status AS document_verification_status_60, p1_.company_last_verification_at AS company_last_verification_at_61, p1_.company_verification_source AS company_verification_source_62, p1_.company_verification_note AS company_verification_note_63, p1_.is_on_vacation AS is_on_vacation_64, p1_.vacation_return_date AS vacation_return_date_65, s2_.id AS id_66, s2_.name AS name_67, s2_.slug AS slug_68, s2_.description AS description_69, s2_.icon AS icon_70, s2_.average_price_min AS average_price_min_71, s2_.average_price_max AS average_price_max_72, s2_.position AS position_73, s2_.is_active AS is_active_74, s2_.created_at AS created_at_75, s2_.updated_at AS updated_at_76, u3_.id AS id_77, u3_.email AS email_78, u3_.roles AS roles_79, u3_.password AS password_80, u3_.first_name AS first_name_81, u3_.last_name AS last_name_82, u3_.phone_number AS phone_number_83, u3_.phone_verified_at AS phone_verified_at_84, u3_.email_verified_at AS email_verified_at_85, u3_.is_verified AS is_verified_86, u3_.avatar AS avatar_87, u3_.locale AS locale_88, u3_.timezone AS timezone_89, u3_.status AS status_90, u3_.last_login_at AS last_login_at_91, u3_.login_count AS login_count_92, u3_.reset_token AS reset_token_93, u3_.reset_token_expires_at AS reset_token_expires_at_94, u3_.created_at AS created_at_95, u3_.updated_at AS updated_at_96, u3_.deleted_at AS deleted_at_97, u3_.notify_on_quote_request_received AS notify_on_quote_request_received_98, u3_.notify_on_message_received AS notify_on_message_received_99, u3_.notify_on_quote_request_accepted AS notify_on_quote_request_accepted_100, u3_.notify_on_review_received AS notify_on_review_received_101, s4_.id AS id_102, s4_.name AS name_103, s4_.slug AS slug_104, s4_.description AS description_105, s4_.icon AS icon_106, s4_.image AS image_107, s4_.position AS position_108, s4_.color AS color_109, s4_.seo_title AS seo_title_110, s4_.seo_description AS seo_description_111, s4_.created_at AS created_at_112, s4_.updated_at AS updated_at_113, s4_.is_active AS is_active_114, s5_.id AS id_115, s5_.name AS name_116, s5_.slug AS slug_117, s5_.description AS description_118, s5_.icon AS icon_119, s5_.image AS image_120, s5_.position AS position_121, s5_.color AS color_122, s5_.seo_title AS seo_title_123, s5_.seo_description AS seo_description_124, s5_.created_at AS created_at_125, s5_.updated_at AS updated_at_126, s5_.is_active AS is_active_127, ROW_NUMBER() OVER(ORDER BY p0_.taux_reduction DESC, p0_.id DESC) AS sclr_128 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) dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 9;

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_.vat_number AS vat_number_24,
  p1_.address AS address_25,
  p1_.address_complement AS address_complement_26,
  p1_.postal_code AS postal_code_27,
  p1_.city AS city_28,
  p1_.country AS country_29,
  p1_.latitude AS latitude_30,
  p1_.longitude AS longitude_31,
  p1_.geohash AS geohash_32,
  p1_.phone_public AS phone_public_33,
  p1_.phone_private AS phone_private_34,
  p1_.website AS website_35,
  p1_.facebook_url AS facebook_url_36,
  p1_.instagram_url AS instagram_url_37,
  p1_.linkedin_url AS linkedin_url_38,
  p1_.short_description AS short_description_39,
  p1_.long_description AS long_description_40,
  p1_.logo AS logo_41,
  p1_.cover_image AS cover_image_42,
  p1_.signature_image AS signature_image_43,
  p1_.profile_status AS profile_status_44,
  p1_.verification_status AS verification_status_45,
  p1_.completion_score AS completion_score_46,
  p1_.average_rating AS average_rating_47,
  p1_.reviews_count AS reviews_count_48,
  p1_.response_time_minutes AS response_time_minutes_49,
  p1_.is_featured AS is_featured_50,
  p1_.featured_until AS featured_until_51,
  p1_.search_visibility AS search_visibility_52,
  p1_.verified_at AS verified_at_53,
  p1_.created_at AS created_at_54,
  p1_.updated_at AS updated_at_55,
  p1_.deleted_at AS deleted_at_56,
  p1_.description AS description_57,
  p1_.metier AS metier_58,
  p1_.experience AS experience_59,
  p1_.document_verification_status AS document_verification_status_60,
  p1_.company_last_verification_at AS company_last_verification_at_61,
  p1_.company_verification_source AS company_verification_source_62,
  p1_.company_verification_note AS company_verification_note_63,
  p1_.is_on_vacation AS is_on_vacation_64,
  p1_.vacation_return_date AS vacation_return_date_65,
  s2_.id AS id_66,
  s2_.name AS name_67,
  s2_.slug AS slug_68,
  s2_.description AS description_69,
  s2_.icon AS icon_70,
  s2_.average_price_min AS average_price_min_71,
  s2_.average_price_max AS average_price_max_72,
  s2_.position AS position_73,
  s2_.is_active AS is_active_74,
  s2_.created_at AS created_at_75,
  s2_.updated_at AS updated_at_76,
  u3_.id AS id_77,
  u3_.email AS email_78,
  u3_.roles AS roles_79,
  u3_.password AS password_80,
  u3_.first_name AS first_name_81,
  u3_.last_name AS last_name_82,
  u3_.phone_number AS phone_number_83,
  u3_.phone_verified_at AS phone_verified_at_84,
  u3_.email_verified_at AS email_verified_at_85,
  u3_.is_verified AS is_verified_86,
  u3_.avatar AS avatar_87,
  u3_.locale AS locale_88,
  u3_.timezone AS timezone_89,
  u3_.status AS status_90,
  u3_.last_login_at AS last_login_at_91,
  u3_.login_count AS login_count_92,
  u3_.reset_token AS reset_token_93,
  u3_.reset_token_expires_at AS reset_token_expires_at_94,
  u3_.created_at AS created_at_95,
  u3_.updated_at AS updated_at_96,
  u3_.deleted_at AS deleted_at_97,
  u3_.notify_on_quote_request_received AS notify_on_quote_request_received_98,
  u3_.notify_on_message_received AS notify_on_message_received_99,
  u3_.notify_on_quote_request_accepted AS notify_on_quote_request_accepted_100,
  u3_.notify_on_review_received AS notify_on_review_received_101,
  s4_.id AS id_102,
  s4_.name AS name_103,
  s4_.slug AS slug_104,
  s4_.description AS description_105,
  s4_.icon AS icon_106,
  s4_.image AS image_107,
  s4_.position AS position_108,
  s4_.color AS color_109,
  s4_.seo_title AS seo_title_110,
  s4_.seo_description AS seo_description_111,
  s4_.created_at AS created_at_112,
  s4_.updated_at AS updated_at_113,
  s4_.is_active AS is_active_114,
  s5_.id AS id_115,
  s5_.name AS name_116,
  s5_.slug AS slug_117,
  s5_.description AS description_118,
  s5_.icon AS icon_119,
  s5_.image AS image_120,
  s5_.position AS position_121,
  s5_.color AS color_122,
  s5_.seo_title AS seo_title_123,
  s5_.seo_description AS seo_description_124,
  s5_.created_at AS created_at_125,
  s5_.updated_at AS updated_at_126,
  s5_.is_active AS is_active_127,
  p0_.prestataire_profile_id AS prestataire_profile_id_128,
  p0_.service_id AS service_id_129,
  p1_.user_id AS user_id_130,
  s2_.category_id AS category_id_131,
  s4_.parent_id AS parent_id_132,
  s5_.parent_id AS parent_id_133
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
  AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  p0_.taux_reduction DESC,
  p0_.id DESC