Query Metrics
5
Database Queries
5
Different statements
2.28 ms
Query time
0
Invalid entities
16
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.62 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.created AS created_5 FROM user t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 2 | 0.44 ms |
SELECT t0.id AS id_1, t0.alias AS alias_2, t0.name AS name_3, t0.value AS value_4, t0.cat AS cat_5 FROM setting t0
Parameters:
[] |
| 3 | 0.61 ms |
SELECT count(DISTINCT f0_.id) AS sclr_0 FROM food f0_ INNER JOIN restaurant r1_ ON f0_.restaurant_id = r1_.id WHERE f0_.id IS NOT NULL AND f0_.date >= ?
Parameters:
[
"2026-05-27"
]
|
| 4 | 0.31 ms |
SELECT DISTINCT f0_.id AS id_0, f0_.date AS date_1, f0_.id AS id_2 FROM food f0_ INNER JOIN restaurant r1_ ON f0_.restaurant_id = r1_.id WHERE f0_.id IS NOT NULL AND f0_.date >= ? ORDER BY f0_.date ASC, f0_.id ASC LIMIT 25
Parameters:
[
"2026-05-27"
]
|
| 5 | 0.29 ms |
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.description AS description_2, f0_.price AS price_3, f0_.price_pack AS price_pack_4, f0_.pos_id AS pos_id_5, f0_.date AS date_6, f0_.active AS active_7, f0_.pandora_id AS pandora_id_8, f0_.u_id AS u_id_9, f0_.import AS import_10, r1_.id AS id_11, r1_.name AS name_12, r1_.vendor_code AS vendor_code_13, r1_.vendor_id AS vendor_id_14, r1_.vendor_name AS vendor_name_15, r1_.menu_id AS menu_id_16, r1_.menu_category_id AS menu_category_id_17, r1_.active AS active_18, f0_.restaurant_id AS restaurant_id_19 FROM food f0_ INNER JOIN restaurant r1_ ON f0_.restaurant_id = r1_.id WHERE f0_.id IS NOT NULL AND f0_.date >= ? AND f0_.id IN (?) ORDER BY f0_.date ASC, f0_.id ASC
Parameters:
[ "2026-05-27" 2 ] |
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 |
|---|---|
| App\Entity\Setting | 13 |
| App\Entity\User | 1 |
| App\Entity\Food | 1 |
| App\Entity\Restaurant | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Restaurant | No errors. |
| App\Entity\Log | No errors. |
| App\Entity\Setting | No errors. |
| App\Entity\Food | No errors. |