Symfony Profiler

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        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_.profile_status AS profile_status_26,
          p0_.verification_status AS verification_status_27,
          p0_.completion_score AS completion_score_28,
          p0_.average_rating AS average_rating_29,
          p0_.reviews_count AS reviews_count_30,
          p0_.response_time_minutes AS response_time_minutes_31,
          p0_.is_featured AS is_featured_32,
          p0_.featured_until AS featured_until_33,
          p0_.search_visibility AS search_visibility_34,
          p0_.verified_at AS verified_at_35,
          p0_.created_at AS created_at_36,
          p0_.updated_at AS updated_at_37,
          p0_.deleted_at AS deleted_at_38,
          p0_.description AS description_39,
          p0_.metier AS metier_40,
          p0_.experience AS experience_41,
          u1_.id AS id_42,
          u1_.email AS email_43,
          u1_.roles AS roles_44,
          u1_.password AS password_45,
          u1_.first_name AS first_name_46,
          u1_.last_name AS last_name_47,
          u1_.phone_number AS phone_number_48,
          u1_.phone_verified_at AS phone_verified_at_49,
          u1_.email_verified_at AS email_verified_at_50,
          u1_.is_verified AS is_verified_51,
          u1_.avatar AS avatar_52,
          u1_.locale AS locale_53,
          u1_.timezone AS timezone_54,
          u1_.status AS status_55,
          u1_.last_login_at AS last_login_at_56,
          u1_.login_count AS login_count_57,
          u1_.reset_token AS reset_token_58,
          u1_.reset_token_expires_at AS reset_token_expires_at_59,
          u1_.created_at AS created_at_60,
          u1_.updated_at AS updated_at_61,
          u1_.deleted_at AS deleted_at_62
        FROM
          prestataire_profile p0_
          INNER JOIN "user" u1_ ON p0_.user_id = u1_.id
        WHERE
          p0_.profile_status = ?
        ORDER BY
          p0_.created_at DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (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_.profile_status AS profile_status_26, p0_.verification_status AS verification_status_27, p0_.completion_score AS completion_score_28, p0_.average_rating AS average_rating_29, p0_.reviews_count AS reviews_count_30, p0_.response_time_minutes AS response_time_minutes_31, p0_.is_featured AS is_featured_32, p0_.featured_until AS featured_until_33, p0_.search_visibility AS search_visibility_34, p0_.verified_at AS verified_at_35, p0_.created_at AS created_at_36, p0_.updated_at AS updated_at_37, p0_.deleted_at AS deleted_at_38, p0_.description AS description_39, p0_.metier AS metier_40, p0_.experience AS experience_41, u1_.id AS id_42, u1_.email AS email_43, u1_.roles AS roles_44, u1_.password AS password_45, u1_.first_name AS first_name_46, u1_.last_name AS last_name_47, u1_.phone_number AS phone_number_48, u1_.phone_verified_at AS phone_verified_at_49, u1_.email_verified_at AS email_verified_at_50, u1_.is_verified AS is_verified_51, u1_.avatar AS avatar_52, u1_.locale AS locale_53, u1_.timezone AS timezone_54, u1_.status AS status_55, u1_.last_login_at AS last_login_at_56, u1_.login_count AS login_count_57, u1_.reset_token AS reset_token_58, u1_.reset_token_expires_at AS reset_token_expires_at_59, u1_.created_at AS created_at_60, u1_.updated_at AS updated_at_61, u1_.deleted_at AS deleted_at_62 FROM prestataire_profile p0_ INNER JOIN "user" u1_ ON p0_.user_id = u1_.id WHERE p0_.profile_status = 'ACTIVE' ORDER BY p0_.created_at DESC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0,
  MIN(sclr_63) AS dctrn_minrownum
FROM
  (
    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_.profile_status AS profile_status_26,
      p0_.verification_status AS verification_status_27,
      p0_.completion_score AS completion_score_28,
      p0_.average_rating AS average_rating_29,
      p0_.reviews_count AS reviews_count_30,
      p0_.response_time_minutes AS response_time_minutes_31,
      p0_.is_featured AS is_featured_32,
      p0_.featured_until AS featured_until_33,
      p0_.search_visibility AS search_visibility_34,
      p0_.verified_at AS verified_at_35,
      p0_.created_at AS created_at_36,
      p0_.updated_at AS updated_at_37,
      p0_.deleted_at AS deleted_at_38,
      p0_.description AS description_39,
      p0_.metier AS metier_40,
      p0_.experience AS experience_41,
      u1_.id AS id_42,
      u1_.email AS email_43,
      u1_.roles AS roles_44,
      u1_.password AS password_45,
      u1_.first_name AS first_name_46,
      u1_.last_name AS last_name_47,
      u1_.phone_number AS phone_number_48,
      u1_.phone_verified_at AS phone_verified_at_49,
      u1_.email_verified_at AS email_verified_at_50,
      u1_.is_verified AS is_verified_51,
      u1_.avatar AS avatar_52,
      u1_.locale AS locale_53,
      u1_.timezone AS timezone_54,
      u1_.status AS status_55,
      u1_.last_login_at AS last_login_at_56,
      u1_.login_count AS login_count_57,
      u1_.reset_token AS reset_token_58,
      u1_.reset_token_expires_at AS reset_token_expires_at_59,
      u1_.created_at AS created_at_60,
      u1_.updated_at AS updated_at_61,
      u1_.deleted_at AS deleted_at_62,
      ROW_NUMBER() OVER(
        ORDER BY
          p0_.created_at DESC
      ) AS sclr_63
    FROM
      prestataire_profile p0_
      INNER JOIN "user" u1_ ON p0_.user_id = u1_.id
    WHERE
      p0_.profile_status = ?
  ) dctrn_result
GROUP BY
  id_0
ORDER BY
  dctrn_minrownum ASC
LIMIT
  9

SELECT DISTINCT id_0, MIN(sclr_63) AS dctrn_minrownum FROM (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_.profile_status AS profile_status_26, p0_.verification_status AS verification_status_27, p0_.completion_score AS completion_score_28, p0_.average_rating AS average_rating_29, p0_.reviews_count AS reviews_count_30, p0_.response_time_minutes AS response_time_minutes_31, p0_.is_featured AS is_featured_32, p0_.featured_until AS featured_until_33, p0_.search_visibility AS search_visibility_34, p0_.verified_at AS verified_at_35, p0_.created_at AS created_at_36, p0_.updated_at AS updated_at_37, p0_.deleted_at AS deleted_at_38, p0_.description AS description_39, p0_.metier AS metier_40, p0_.experience AS experience_41, u1_.id AS id_42, u1_.email AS email_43, u1_.roles AS roles_44, u1_.password AS password_45, u1_.first_name AS first_name_46, u1_.last_name AS last_name_47, u1_.phone_number AS phone_number_48, u1_.phone_verified_at AS phone_verified_at_49, u1_.email_verified_at AS email_verified_at_50, u1_.is_verified AS is_verified_51, u1_.avatar AS avatar_52, u1_.locale AS locale_53, u1_.timezone AS timezone_54, u1_.status AS status_55, u1_.last_login_at AS last_login_at_56, u1_.login_count AS login_count_57, u1_.reset_token AS reset_token_58, u1_.reset_token_expires_at AS reset_token_expires_at_59, u1_.created_at AS created_at_60, u1_.updated_at AS updated_at_61, u1_.deleted_at AS deleted_at_62, ROW_NUMBER() OVER(ORDER BY p0_.created_at DESC) AS sclr_63 FROM prestataire_profile p0_ INNER JOIN "user" u1_ ON p0_.user_id = u1_.id WHERE p0_.profile_status = 'ACTIVE') dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 9;

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;