Symfony Profiler

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          m0_.id AS id_0,
          m0_.titulo AS titulo_1,
          m0_.texto AS texto_2,
          m0_.precio AS precio_3,
          m0_.visible AS visible_4,
          m0_.from_date AS from_date_5,
          m0_.due_date AS due_date_6,
          m0_.created AS created_7,
          m0_.updated AS updated_8,
          (
            3959 * ACOS(
              COS(
                RADIANS(?)
              ) * COS(
                RADIANS(r1_.lat)
              ) * COS(
                RADIANS(r1_.lng) - RADIANS(?)
              ) + SIN(
                RADIANS(?)
              ) * SIN(
                RADIANS(r1_.lat)
              )
            )
          ) AS sclr_9,
          m0_.id_restaurante AS id_restaurante_10
        FROM
          menu m0_
          INNER JOIN restaurante r1_ ON m0_.id_restaurante = r1_.id
        WHERE
          (
            m0_.from_date IS NULL
            OR m0_.from_date <= CURRENT_TIME
          )
          AND (
            m0_.due_date IS NULL
            OR m0_.due_date >= CURRENT_TIME
          )
          AND m0_.precio <= ?
        HAVING
          sclr_9 <= ?
        ORDER BY
          sclr_9 ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT m0_.id AS id_0, m0_.titulo AS titulo_1, m0_.texto AS texto_2, m0_.precio AS precio_3, m0_.visible AS visible_4, m0_.from_date AS from_date_5, m0_.due_date AS due_date_6, m0_.created AS created_7, m0_.updated AS updated_8, (3959 * ACOS(COS(RADIANS(0)) * COS(RADIANS(r1_.lat)) * COS(RADIANS(r1_.lng) - RADIANS(0)) + SIN(RADIANS(0)) * SIN(RADIANS(r1_.lat)))) AS sclr_9, m0_.id_restaurante AS id_restaurante_10 FROM menu m0_ INNER JOIN restaurante r1_ ON m0_.id_restaurante = r1_.id WHERE (m0_.from_date IS NULL OR m0_.from_date <= CURRENT_TIME) AND (m0_.due_date IS NULL OR m0_.due_date >= CURRENT_TIME) AND m0_.precio <= 50 HAVING sclr_9 <= 50 ORDER BY sclr_9 ASC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      sclr_9
    FROM
      (
        SELECT
          m0_.id AS id_0,
          m0_.titulo AS titulo_1,
          m0_.texto AS texto_2,
          m0_.precio AS precio_3,
          m0_.visible AS visible_4,
          m0_.from_date AS from_date_5,
          m0_.due_date AS due_date_6,
          m0_.created AS created_7,
          m0_.updated AS updated_8,
          (
            3959 * ACOS(
              COS(
                RADIANS(?)
              ) * COS(
                RADIANS(r1_.lat)
              ) * COS(
                RADIANS(r1_.lng) - RADIANS(?)
              ) + SIN(
                RADIANS(?)
              ) * SIN(
                RADIANS(r1_.lat)
              )
            )
          ) AS sclr_9,
          r1_.lat AS lat_10,
          r1_.lng AS lng_11,
          m0_.id_restaurante AS id_restaurante_12,
          r1_.id_user AS id_user_13
        FROM
          menu m0_
          INNER JOIN restaurante r1_ ON m0_.id_restaurante = r1_.id
        WHERE
          (
            m0_.from_date IS NULL
            OR m0_.from_date <= CURRENT_TIME
          )
          AND (
            m0_.due_date IS NULL
            OR m0_.due_date >= CURRENT_TIME
          )
          AND m0_.precio <= ?
        HAVING
          sclr_9 <= ?
      ) dctrn_result_inner
    ORDER BY
      sclr_9 ASC
  ) dctrn_result
LIMIT
  50

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, sclr_9 FROM (SELECT m0_.id AS id_0, m0_.titulo AS titulo_1, m0_.texto AS texto_2, m0_.precio AS precio_3, m0_.visible AS visible_4, m0_.from_date AS from_date_5, m0_.due_date AS due_date_6, m0_.created AS created_7, m0_.updated AS updated_8, (3959 * ACOS(COS(RADIANS(0)) * COS(RADIANS(r1_.lat)) * COS(RADIANS(r1_.lng) - RADIANS(0)) + SIN(RADIANS(0)) * SIN(RADIANS(r1_.lat)))) AS sclr_9, r1_.lat AS lat_10, r1_.lng AS lng_11, m0_.id_restaurante AS id_restaurante_12, r1_.id_user AS id_user_13 FROM menu m0_ INNER JOIN restaurante r1_ ON m0_.id_restaurante = r1_.id WHERE (m0_.from_date IS NULL OR m0_.from_date <= CURRENT_TIME) AND (m0_.due_date IS NULL OR m0_.due_date >= CURRENT_TIME) AND m0_.precio <= 50 HAVING sclr_9 <= 50) dctrn_result_inner ORDER BY sclr_9 ASC) dctrn_result LIMIT 50;