GET https://menu.dh.stage.biceps.digital/sync/export

Query Metrics

79 Database Queries
10 Different statements
97.41 ms Query time
0 Invalid entities
40 Managed entities

Grouped Statements

Show all queries

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.