Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

2.03 ms Query time

1 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲	Time	Info
1	1.25 ms	SELECT COUNT() AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.address AS address_2, r0_.lat AS lat_3, r0_.lng AS lng_4, r0_.locality AS locality_5, r0_.postalCode AS postalCode_6, r0_.phone AS phone_7, r0_.whatsapp_phone AS whatsapp_phone_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, r0_.service_hours AS service_hours_15, r0_.opening_hours AS opening_hours_16, (6371 ACOS(COS(RADIANS(?)) * COS(RADIANS(r0_.lat)) * COS(RADIANS(r0_.lng) - RADIANS(?)) + SIN(RADIANS(?)) * SIN(RADIANS(r0_.lat)))) AS sclr_17, r0_.id_user AS id_user_18 FROM restaurant r0_ HAVING sclr_17 <= ? ORDER BY sclr_17 ASC, r0_.id ASC) dctrn_result) dctrn_table Parameters: [`0.0 0.0 0.0 50.0`] View formatted query View runnable query Explain query SELECT COUNT() AS dctrn_count FROM ( SELECT DISTINCT id_0 FROM ( SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.address AS address_2, r0_.lat AS lat_3, r0_.lng AS lng_4, r0_.locality AS locality_5, r0_.postalCode AS postalCode_6, r0_.phone AS phone_7, r0_.whatsapp_phone AS whatsapp_phone_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, r0_.service_hours AS service_hours_15, r0_.opening_hours AS opening_hours_16, ( 6371 ACOS( COS( RADIANS(?) ) * COS( RADIANS(r0_.lat) ) * COS( RADIANS(r0_.lng) - RADIANS(?) ) + SIN( RADIANS(?) ) * SIN( RADIANS(r0_.lat) ) ) ) AS sclr_17, r0_.id_user AS id_user_18 FROM restaurant r0_ HAVING sclr_17 <= ? ORDER BY sclr_17 ASC, r0_.id ASC ) dctrn_result ) dctrn_table SELECT COUNT() AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.address AS address_2, r0_.lat AS lat_3, r0_.lng AS lng_4, r0_.locality AS locality_5, r0_.postalCode AS postalCode_6, r0_.phone AS phone_7, r0_.whatsapp_phone AS whatsapp_phone_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, r0_.service_hours AS service_hours_15, r0_.opening_hours AS opening_hours_16, (6371 ACOS(COS(RADIANS(0)) * COS(RADIANS(r0_.lat)) * COS(RADIANS(r0_.lng) - RADIANS(0)) + SIN(RADIANS(0)) * SIN(RADIANS(r0_.lat)))) AS sclr_17, r0_.id_user AS id_user_18 FROM restaurant r0_ HAVING sclr_17 <= 50 ORDER BY sclr_17 ASC, r0_.id ASC) dctrn_result) dctrn_table;
2	0.78 ms	SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, sclr_17 FROM (SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.address AS address_2, r0_.lat AS lat_3, r0_.lng AS lng_4, r0_.locality AS locality_5, r0_.postalCode AS postalCode_6, r0_.phone AS phone_7, r0_.whatsapp_phone AS whatsapp_phone_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, r0_.service_hours AS service_hours_15, r0_.opening_hours AS opening_hours_16, (6371 * ACOS(COS(RADIANS(?)) * COS(RADIANS(r0_.lat)) * COS(RADIANS(r0_.lng) - RADIANS(?)) + SIN(RADIANS(?)) * SIN(RADIANS(r0_.lat)))) AS sclr_17, r0_.id_user AS id_user_18 FROM restaurant r0_ HAVING sclr_17 <= ?) dctrn_result_inner ORDER BY sclr_17 ASC, id_0 ASC) dctrn_result LIMIT 50 Parameters: [`0.0 0.0 0.0 50.0`] View formatted query View runnable query Explain query SELECT DISTINCT id_0 FROM ( SELECT DISTINCT id_0, sclr_17 FROM ( SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.address AS address_2, r0_.lat AS lat_3, r0_.lng AS lng_4, r0_.locality AS locality_5, r0_.postalCode AS postalCode_6, r0_.phone AS phone_7, r0_.whatsapp_phone AS whatsapp_phone_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, r0_.service_hours AS service_hours_15, r0_.opening_hours AS opening_hours_16, ( 6371 * ACOS( COS( RADIANS(?) ) * COS( RADIANS(r0_.lat) ) * COS( RADIANS(r0_.lng) - RADIANS(?) ) + SIN( RADIANS(?) ) * SIN( RADIANS(r0_.lat) ) ) ) AS sclr_17, r0_.id_user AS id_user_18 FROM restaurant r0_ HAVING sclr_17 <= ? ) dctrn_result_inner ORDER BY sclr_17 ASC, id_0 ASC ) dctrn_result LIMIT 50 SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, sclr_17 FROM (SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.address AS address_2, r0_.lat AS lat_3, r0_.lng AS lng_4, r0_.locality AS locality_5, r0_.postalCode AS postalCode_6, r0_.phone AS phone_7, r0_.whatsapp_phone AS whatsapp_phone_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, r0_.service_hours AS service_hours_15, r0_.opening_hours AS opening_hours_16, (6371 * ACOS(COS(RADIANS(0)) * COS(RADIANS(r0_.lat)) * COS(RADIANS(r0_.lng) - RADIANS(0)) + SIN(RADIANS(0)) * SIN(RADIANS(r0_.lat)))) AS sclr_17, r0_.id_user AS id_user_18 FROM restaurant r0_ HAVING sclr_17 <= 50) dctrn_result_inner ORDER BY sclr_17 ASC, id_0 ASC) dctrn_result LIMIT 50;

#▲

Time

Info

1.25 ms

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.address AS address_2, r0_.lat AS lat_3, r0_.lng AS lng_4, r0_.locality AS locality_5, r0_.postalCode AS postalCode_6, r0_.phone AS phone_7, r0_.whatsapp_phone AS whatsapp_phone_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, r0_.service_hours AS service_hours_15, r0_.opening_hours AS opening_hours_16, (6371 * ACOS(COS(RADIANS(?)) * COS(RADIANS(r0_.lat)) * COS(RADIANS(r0_.lng) - RADIANS(?)) + SIN(RADIANS(?)) * SIN(RADIANS(r0_.lat)))) AS sclr_17, r0_.id_user AS id_user_18 FROM restaurant r0_ HAVING sclr_17 <= ? ORDER BY sclr_17 ASC, r0_.id ASC) dctrn_result) dctrn_table

Parameters:

[
  0.0
  0.0
  0.0
  50.0
]

View formatted query View runnable query Explain query

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          r0_.id AS id_0,
          r0_.name AS name_1,
          r0_.address AS address_2,
          r0_.lat AS lat_3,
          r0_.lng AS lng_4,
          r0_.locality AS locality_5,
          r0_.postalCode AS postalCode_6,
          r0_.phone AS phone_7,
          r0_.whatsapp_phone AS whatsapp_phone_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,
          r0_.service_hours AS service_hours_15,
          r0_.opening_hours AS opening_hours_16,
          (
            6371 * ACOS(
              COS(
                RADIANS(?)
              ) * COS(
                RADIANS(r0_.lat)
              ) * COS(
                RADIANS(r0_.lng) - RADIANS(?)
              ) + SIN(
                RADIANS(?)
              ) * SIN(
                RADIANS(r0_.lat)
              )
            )
          ) AS sclr_17,
          r0_.id_user AS id_user_18
        FROM
          restaurant r0_
        HAVING
          sclr_17 <= ?
        ORDER BY
          sclr_17 ASC,
          r0_.id ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.address AS address_2, r0_.lat AS lat_3, r0_.lng AS lng_4, r0_.locality AS locality_5, r0_.postalCode AS postalCode_6, r0_.phone AS phone_7, r0_.whatsapp_phone AS whatsapp_phone_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, r0_.service_hours AS service_hours_15, r0_.opening_hours AS opening_hours_16, (6371 * ACOS(COS(RADIANS(0)) * COS(RADIANS(r0_.lat)) * COS(RADIANS(r0_.lng) - RADIANS(0)) + SIN(RADIANS(0)) * SIN(RADIANS(r0_.lat)))) AS sclr_17, r0_.id_user AS id_user_18 FROM restaurant r0_ HAVING sclr_17 <= 50 ORDER BY sclr_17 ASC, r0_.id ASC) dctrn_result) dctrn_table;

0.78 ms

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, sclr_17 FROM (SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.address AS address_2, r0_.lat AS lat_3, r0_.lng AS lng_4, r0_.locality AS locality_5, r0_.postalCode AS postalCode_6, r0_.phone AS phone_7, r0_.whatsapp_phone AS whatsapp_phone_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, r0_.service_hours AS service_hours_15, r0_.opening_hours AS opening_hours_16, (6371 * ACOS(COS(RADIANS(?)) * COS(RADIANS(r0_.lat)) * COS(RADIANS(r0_.lng) - RADIANS(?)) + SIN(RADIANS(?)) * SIN(RADIANS(r0_.lat)))) AS sclr_17, r0_.id_user AS id_user_18 FROM restaurant r0_ HAVING sclr_17 <= ?) dctrn_result_inner ORDER BY sclr_17 ASC, id_0 ASC) dctrn_result LIMIT 50

Parameters:

[
  0.0
  0.0
  0.0
  50.0
]

View formatted query View runnable query Explain query

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      sclr_17
    FROM
      (
        SELECT
          r0_.id AS id_0,
          r0_.name AS name_1,
          r0_.address AS address_2,
          r0_.lat AS lat_3,
          r0_.lng AS lng_4,
          r0_.locality AS locality_5,
          r0_.postalCode AS postalCode_6,
          r0_.phone AS phone_7,
          r0_.whatsapp_phone AS whatsapp_phone_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,
          r0_.service_hours AS service_hours_15,
          r0_.opening_hours AS opening_hours_16,
          (
            6371 * ACOS(
              COS(
                RADIANS(?)
              ) * COS(
                RADIANS(r0_.lat)
              ) * COS(
                RADIANS(r0_.lng) - RADIANS(?)
              ) + SIN(
                RADIANS(?)
              ) * SIN(
                RADIANS(r0_.lat)
              )
            )
          ) AS sclr_17,
          r0_.id_user AS id_user_18
        FROM
          restaurant r0_
        HAVING
          sclr_17 <= ?
      ) dctrn_result_inner
    ORDER BY
      sclr_17 ASC,
      id_0 ASC
  ) dctrn_result
LIMIT
  50

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, sclr_17 FROM (SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.address AS address_2, r0_.lat AS lat_3, r0_.lng AS lng_4, r0_.locality AS locality_5, r0_.postalCode AS postalCode_6, r0_.phone AS phone_7, r0_.whatsapp_phone AS whatsapp_phone_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, r0_.service_hours AS service_hours_15, r0_.opening_hours AS opening_hours_16, (6371 * ACOS(COS(RADIANS(0)) * COS(RADIANS(r0_.lat)) * COS(RADIANS(r0_.lng) - RADIANS(0)) + SIN(RADIANS(0)) * SIN(RADIANS(r0_.lat)))) AS sclr_17, r0_.id_user AS id_user_18 FROM restaurant r0_ HAVING sclr_17 <= 50) dctrn_result_inner ORDER BY sclr_17 ASC, id_0 ASC) dctrn_result LIMIT 50;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects

Entities Mapping

Class	Mapping errors
App\Entity\Restaurant	The field 'App\Entity\Restaurant#lat' has the property type 'float' that differs from the metadata field type 'string' returned by the 'string' DBAL type. The field 'App\Entity\Restaurant#lng' has the property type 'float' that differs from the metadata field type 'string' returned by the 'string' DBAL type.
App\Entity\User	No errors.

Symfony Profiler

GET https://menusdeldia.com/restaurantes

Configuration Settings

Theme

Page Width