Query Metrics
2
Database Queries
2
Different statements
6.65 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 4.78 ms |
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
Parameters:
[ 0.0 0.0 0.0 50.0 ] |
2 | 1.87 ms |
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
Parameters:
[ 0.0 0.0 0.0 50.0 ] |
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.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\User | No errors. |
App\Entity\Restaurante | No errors. |