GET https://menu.dh.stage.biceps.digital/food/

Query Metrics

5 Database Queries
5 Different statements
2.28 ms Query time
0 Invalid entities
16 Managed entities

Grouped Statements

Show all queries

Time Count Info
0.62 ms
(27.09%)
1
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
]
0.61 ms
(26.78%)
1
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"
]
0.44 ms
(19.49%)
1
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:
[]
0.31 ms
(13.83%)
1
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"
]
0.29 ms
(12.82%)
1
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.