Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Logs 62
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine 2
• Migrations
• Debug
• Httplug 0/0
• Emails
• Notifications
• EasyAdmin
• VichUploader
• Configuration

Query Metrics

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.coffee AS coffee_2, m0_.tags AS tags_3, m0_.price AS price_4, m0_.visible AS visible_5, m0_.from_date AS from_date_6, m0_.due_date AS due_date_7, m0_.created AS created_8, m0_.updated AS updated_9, (6371 * ACOS(COS(RADIANS(?)) * COS(RADIANS(r1_.lat)) * COS(RADIANS(r1_.lng) - RADIANS(?)) + SIN(RADIANS(?)) * SIN(RADIANS(r1_.lat)))) AS sclr_10, m0_.restaurant_id AS restaurant_id_11 FROM menu m0_ INNER JOIN restaurant r1_ ON m0_.restaurant_id = 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_.price <= ? HAVING sclr_10 <= ? ORDER BY sclr_10 ASC, m0_.id ASC) dctrn_result) dctrn_table

[
  0.0
  0.0
  0.0
  50.0
  50.0
]

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          m0_.id AS id_0,
          m0_.name AS name_1,
          m0_.coffee AS coffee_2,
          m0_.tags AS tags_3,
          m0_.price AS price_4,
          m0_.visible AS visible_5,
          m0_.from_date AS from_date_6,
          m0_.due_date AS due_date_7,
          m0_.created AS created_8,
          m0_.updated AS updated_9,
          (
            6371 * ACOS(
              COS(
                RADIANS(?)
              ) * COS(
                RADIANS(r1_.lat)
              ) * COS(
                RADIANS(r1_.lng) - RADIANS(?)
              ) + SIN(
                RADIANS(?)
              ) * SIN(
                RADIANS(r1_.lat)
              )
            )
          ) AS sclr_10,
          m0_.restaurant_id AS restaurant_id_11
        FROM
          menu m0_
          INNER JOIN restaurant r1_ ON m0_.restaurant_id = 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_.price <= ?
        HAVING
          sclr_10 <= ?
        ORDER BY
          sclr_10 ASC,
          m0_.id ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.coffee AS coffee_2, m0_.tags AS tags_3, m0_.price AS price_4, m0_.visible AS visible_5, m0_.from_date AS from_date_6, m0_.due_date AS due_date_7, m0_.created AS created_8, m0_.updated AS updated_9, (6371 * ACOS(COS(RADIANS(0)) * COS(RADIANS(r1_.lat)) * COS(RADIANS(r1_.lng) - RADIANS(0)) + SIN(RADIANS(0)) * SIN(RADIANS(r1_.lat)))) AS sclr_10, m0_.restaurant_id AS restaurant_id_11 FROM menu m0_ INNER JOIN restaurant r1_ ON m0_.restaurant_id = 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_.price <= 50 HAVING sclr_10 <= 50 ORDER BY sclr_10 ASC, m0_.id ASC) dctrn_result) dctrn_table;

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, sclr_10 FROM (SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.coffee AS coffee_2, m0_.tags AS tags_3, m0_.price AS price_4, m0_.visible AS visible_5, m0_.from_date AS from_date_6, m0_.due_date AS due_date_7, m0_.created AS created_8, m0_.updated AS updated_9, (6371 * ACOS(COS(RADIANS(?)) * COS(RADIANS(r1_.lat)) * COS(RADIANS(r1_.lng) - RADIANS(?)) + SIN(RADIANS(?)) * SIN(RADIANS(r1_.lat)))) AS sclr_10, r1_.id AS id_11, r1_.name AS name_12, r1_.address AS address_13, r1_.lat AS lat_14, r1_.lng AS lng_15, r1_.locality AS locality_16, r1_.postalCode AS postalCode_17, r1_.phone AS phone_18, r1_.whatsapp_phone AS whatsapp_phone_19, r1_.email AS email_20, r1_.placeDetails AS placeDetails_21, r1_.googlePlaceId AS googlePlaceId_22, r1_.rating AS rating_23, r1_.created AS created_24, r1_.updated AS updated_25, r1_.service_hours AS service_hours_26, r1_.opening_hours AS opening_hours_27, m0_.restaurant_id AS restaurant_id_28, r1_.id_user AS id_user_29 FROM menu m0_ INNER JOIN restaurant r1_ ON m0_.restaurant_id = 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_.price <= ? HAVING sclr_10 <= ?) dctrn_result_inner ORDER BY sclr_10 ASC, id_0 ASC) dctrn_result LIMIT 50

[
  0.0
  0.0
  0.0
  50.0
  50.0
]

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      sclr_10
    FROM
      (
        SELECT
          m0_.id AS id_0,
          m0_.name AS name_1,
          m0_.coffee AS coffee_2,
          m0_.tags AS tags_3,
          m0_.price AS price_4,
          m0_.visible AS visible_5,
          m0_.from_date AS from_date_6,
          m0_.due_date AS due_date_7,
          m0_.created AS created_8,
          m0_.updated AS updated_9,
          (
            6371 * ACOS(
              COS(
                RADIANS(?)
              ) * COS(
                RADIANS(r1_.lat)
              ) * COS(
                RADIANS(r1_.lng) - RADIANS(?)
              ) + SIN(
                RADIANS(?)
              ) * SIN(
                RADIANS(r1_.lat)
              )
            )
          ) AS sclr_10,
          r1_.id AS id_11,
          r1_.name AS name_12,
          r1_.address AS address_13,
          r1_.lat AS lat_14,
          r1_.lng AS lng_15,
          r1_.locality AS locality_16,
          r1_.postalCode AS postalCode_17,
          r1_.phone AS phone_18,
          r1_.whatsapp_phone AS whatsapp_phone_19,
          r1_.email AS email_20,
          r1_.placeDetails AS placeDetails_21,
          r1_.googlePlaceId AS googlePlaceId_22,
          r1_.rating AS rating_23,
          r1_.created AS created_24,
          r1_.updated AS updated_25,
          r1_.service_hours AS service_hours_26,
          r1_.opening_hours AS opening_hours_27,
          m0_.restaurant_id AS restaurant_id_28,
          r1_.id_user AS id_user_29
        FROM
          menu m0_
          INNER JOIN restaurant r1_ ON m0_.restaurant_id = 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_.price <= ?
        HAVING
          sclr_10 <= ?
      ) dctrn_result_inner
    ORDER BY
      sclr_10 ASC,
      id_0 ASC
  ) dctrn_result
LIMIT
  50

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, sclr_10 FROM (SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.coffee AS coffee_2, m0_.tags AS tags_3, m0_.price AS price_4, m0_.visible AS visible_5, m0_.from_date AS from_date_6, m0_.due_date AS due_date_7, m0_.created AS created_8, m0_.updated AS updated_9, (6371 * ACOS(COS(RADIANS(0)) * COS(RADIANS(r1_.lat)) * COS(RADIANS(r1_.lng) - RADIANS(0)) + SIN(RADIANS(0)) * SIN(RADIANS(r1_.lat)))) AS sclr_10, r1_.id AS id_11, r1_.name AS name_12, r1_.address AS address_13, r1_.lat AS lat_14, r1_.lng AS lng_15, r1_.locality AS locality_16, r1_.postalCode AS postalCode_17, r1_.phone AS phone_18, r1_.whatsapp_phone AS whatsapp_phone_19, r1_.email AS email_20, r1_.placeDetails AS placeDetails_21, r1_.googlePlaceId AS googlePlaceId_22, r1_.rating AS rating_23, r1_.created AS created_24, r1_.updated AS updated_25, r1_.service_hours AS service_hours_26, r1_.opening_hours AS opening_hours_27, m0_.restaurant_id AS restaurant_id_28, r1_.id_user AS id_user_29 FROM menu m0_ INNER JOIN restaurant r1_ ON m0_.restaurant_id = 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_.price <= 50 HAVING sclr_10 <= 50) dctrn_result_inner ORDER BY sclr_10 ASC, id_0 ASC) dctrn_result LIMIT 50;