Query Metrics
79
Database Queries
10
Different statements
97.41 ms
Query time
0
Invalid entities
40
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
66.93 ms (68.71%) |
24 |
"COMMIT"
Parameters:
[] |
|
16.26 ms (16.69%) |
23 |
INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "api_export" "Export 05-27-2026_06:24:47 START" "2026-05-27 06:24:47" null "05-27-2026_06:24:47" null "api" "success" null 1 ] |
|
8.74 ms (8.98%) |
24 |
"START TRANSACTION"
Parameters:
[] |
|
1.67 ms (1.72%) |
2 |
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, f0_.restaurant_id AS restaurant_id_11 FROM food f0_ WHERE f0_.restaurant_id = ? AND f0_.date = ? ORDER BY f0_.id ASC
Parameters:
[ 29 "2026-05-27" ] |
|
0.74 ms (0.76%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.vendor_code AS vendor_code_3, t0.vendor_id AS vendor_id_4, t0.vendor_name AS vendor_name_5, t0.menu_id AS menu_id_6, t0.menu_category_id AS menu_category_id_7, t0.active AS active_8 FROM restaurant t0 INNER JOIN user_restaurant ON t0.id = user_restaurant.restaurant_id WHERE user_restaurant.user_id = ?
Parameters:
[
1
]
|
|
0.67 ms (0.69%) |
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.67 ms (0.69%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.price_pack AS price_pack_5, t0.pos_id AS pos_id_6, t0.date AS date_7, t0.active AS active_8, t0.pandora_id AS pandora_id_9, t0.u_id AS u_id_10, t0.import AS import_11, t0.restaurant_id AS restaurant_id_12 FROM food t0 WHERE t0.name = ?
Parameters:
[
"Chleba s máslem"
]
|
|
0.58 ms (0.60%) |
1 |
UPDATE food SET pandora_id = ? WHERE id = ?
Parameters:
[ "1357429" 2 ] |
|
0.58 ms (0.59%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.price_pack AS price_pack_5, t0.pos_id AS pos_id_6, t0.date AS date_7, t0.active AS active_8, t0.pandora_id AS pandora_id_9, t0.u_id AS u_id_10, t0.import AS import_11, t0.restaurant_id AS restaurant_id_12 FROM food t0 WHERE t0.id = ?
Parameters:
[
2
]
|
|
0.57 ms (0.58%) |
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:
[] |
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\Log | 23 |
| App\Entity\Setting | 13 |
| App\Entity\Restaurant | 2 |
| App\Entity\User | 1 |
| App\Entity\Food | 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. |