Symfony Profiler

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          r0_.id AS id_0,
          r0_.nombre AS nombre_1,
          r0_.direccion AS direccion_2,
          r0_.lat AS lat_3,
          r0_.lng AS lng_4,
          r0_.locality AS locality_5,
          r0_.postalCode AS postalCode_6,
          r0_.telefono AS telefono_7,
          r0_.tel_whatsapp AS tel_whatsapp_8,
          r0_.email AS email_9,
          r0_.placeDetails AS placeDetails_10,
          r0_.googlePlaceId AS googlePlaceId_11,
          r0_.rating AS rating_12,
          r0_.created AS created_13,
          r0_.updated AS updated_14,
          (
            3959 * ACOS(
              COS(
                RADIANS(?)
              ) * COS(
                RADIANS(r0_.lat)
              ) * COS(
                RADIANS(r0_.lng) - RADIANS(?)
              ) + SIN(
                RADIANS(?)
              ) * SIN(
                RADIANS(r0_.lat)
              )
            )
          ) AS sclr_15,
          r0_.id_user AS id_user_16
        FROM
          restaurante r0_
        HAVING
          sclr_15 <= ?
        ORDER BY
          sclr_15 ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT r0_.id AS id_0, r0_.nombre AS nombre_1, r0_.direccion AS direccion_2, r0_.lat AS lat_3, r0_.lng AS lng_4, r0_.locality AS locality_5, r0_.postalCode AS postalCode_6, r0_.telefono AS telefono_7, r0_.tel_whatsapp AS tel_whatsapp_8, r0_.email AS email_9, r0_.placeDetails AS placeDetails_10, r0_.googlePlaceId AS googlePlaceId_11, r0_.rating AS rating_12, r0_.created AS created_13, r0_.updated AS updated_14, (3959 * ACOS(COS(RADIANS(0)) * COS(RADIANS(r0_.lat)) * COS(RADIANS(r0_.lng) - RADIANS(0)) + SIN(RADIANS(0)) * SIN(RADIANS(r0_.lat)))) AS sclr_15, r0_.id_user AS id_user_16 FROM restaurante r0_ HAVING sclr_15 <= 50 ORDER BY sclr_15 ASC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      sclr_15
    FROM
      (
        SELECT
          r0_.id AS id_0,
          r0_.nombre AS nombre_1,
          r0_.direccion AS direccion_2,
          r0_.lat AS lat_3,
          r0_.lng AS lng_4,
          r0_.locality AS locality_5,
          r0_.postalCode AS postalCode_6,
          r0_.telefono AS telefono_7,
          r0_.tel_whatsapp AS tel_whatsapp_8,
          r0_.email AS email_9,
          r0_.placeDetails AS placeDetails_10,
          r0_.googlePlaceId AS googlePlaceId_11,
          r0_.rating AS rating_12,
          r0_.created AS created_13,
          r0_.updated AS updated_14,
          (
            3959 * ACOS(
              COS(
                RADIANS(?)
              ) * COS(
                RADIANS(r0_.lat)
              ) * COS(
                RADIANS(r0_.lng) - RADIANS(?)
              ) + SIN(
                RADIANS(?)
              ) * SIN(
                RADIANS(r0_.lat)
              )
            )
          ) AS sclr_15,
          r0_.id_user AS id_user_16
        FROM
          restaurante r0_
        HAVING
          sclr_15 <= ?
      ) dctrn_result_inner
    ORDER BY
      sclr_15 ASC
  ) dctrn_result
LIMIT
  50

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, sclr_15 FROM (SELECT r0_.id AS id_0, r0_.nombre AS nombre_1, r0_.direccion AS direccion_2, r0_.lat AS lat_3, r0_.lng AS lng_4, r0_.locality AS locality_5, r0_.postalCode AS postalCode_6, r0_.telefono AS telefono_7, r0_.tel_whatsapp AS tel_whatsapp_8, r0_.email AS email_9, r0_.placeDetails AS placeDetails_10, r0_.googlePlaceId AS googlePlaceId_11, r0_.rating AS rating_12, r0_.created AS created_13, r0_.updated AS updated_14, (3959 * ACOS(COS(RADIANS(0)) * COS(RADIANS(r0_.lat)) * COS(RADIANS(r0_.lng) - RADIANS(0)) + SIN(RADIANS(0)) * SIN(RADIANS(r0_.lat)))) AS sclr_15, r0_.id_user AS id_user_16 FROM restaurante r0_ HAVING sclr_15 <= 50) dctrn_result_inner ORDER BY sclr_15 ASC) dctrn_result LIMIT 50;