Symfony Profiler

Query Metrics

79 Database Queries

10 Different statements

97.41 ms Query time

0 Invalid entities

40 Managed entities

Queries


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 = ?
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
"START TRANSACTION"
INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
"COMMIT"
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 = ?
"START TRANSACTION"
INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
"COMMIT"
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
"START TRANSACTION"
INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
"COMMIT"
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
"START TRANSACTION"
INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
"COMMIT"
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 = ?
"START TRANSACTION"
UPDATE food SET pandora_id = ? WHERE id = ?
"COMMIT"
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 = ?
"START TRANSACTION"
INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
"COMMIT"

#▲	Time	Info
1	0.67 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`] View formatted query View runnable query Explain query 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 = ? 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 = 1;
2	0.57 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: [] View formatted query View runnable query Explain query 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 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;
3	0.36 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
4	0.76 ms	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`] View formatted query View runnable query Explain query INSERT INTO log ( event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES ('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);
5	3.13 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
6	0.74 ms	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`] View formatted query View runnable query Explain query 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 = ? 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 = 1;
7	0.31 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
8	0.58 ms	INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`"api_01_get_catalog_products" """ getFoods\n \n GET https://cz-st.fd-api.com/api/v1/catalog/products\r\n REQUEST: {\n "vendor_id": "20720",\n "menu_category_id": "68820"\n }\r\n RESPONSE: [] """ "2026-05-27 06:24:47" 29 "05-27-2026_06:24:47" "t0gy" "api" "info" """ GET https://cz-st.fd-api.com/api/v1/catalog/products\r\n REQUEST: {\n "vendor_id": "20720",\n "menu_category_id": "68820"\n }\r\n RESPONSE: [] """ 1`] View formatted query View runnable query Explain query INSERT INTO log ( event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES ('api_01_get_catalog_products', 'getFoods GET https://cz-st.fd-api.com/api/v1/catalog/products REQUEST: { \"vendor_id\": \"20720\", \"menu_category_id\": \"68820\" } RESPONSE: []', '2026-05-27 06:24:47', 29, '05-27-2026_06:24:47', 't0gy', 'api', 'info', 'GET https://cz-st.fd-api.com/api/v1/catalog/products REQUEST: { \"vendor_id\": \"20720\", \"menu_category_id\": \"68820\" } RESPONSE: []', 1);
9	2.63 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
10	0.33 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
11	0.47 ms	INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`"api_01_get_catalog_products" "Počet jídel: 0" "2026-05-27 06:24:47" 29 "05-27-2026_06:24:47" "t0gy" "api" "success" null 1`] View formatted query View runnable query Explain query INSERT INTO log ( event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES ('api_01_get_catalog_products', 'Počet jídel: 0', '2026-05-27 06:24:47', 29, '05-27-2026_06:24:47', 't0gy', 'api', 'success', NULL, 1);
12	2.58 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
13	0.26 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
14	0.44 ms	INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`"api_02_delete_catalog_products_bulk" "Api nevrátilo žádné jídlo, proto nebylo možné je smazat" "2026-05-27 06:24:47" 29 "05-27-2026_06:24:47" "t0gy" "api" "success" null 1`] View formatted query View runnable query Explain query INSERT INTO log ( event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES ('api_02_delete_catalog_products_bulk', 'Api nevrátilo žádné jídlo, proto nebylo možné je smazat', '2026-05-27 06:24:47', 29, '05-27-2026_06:24:47', 't0gy', 'api', 'success', NULL, 1);
15	1.96 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
16	0.83 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, 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"`] View formatted query View runnable query Explain query 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 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 = 29 AND f0_.date = '2026-05-27' ORDER BY f0_.id ASC;
17	0.44 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
18	0.73 ms	INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: ["api_03_create_catalog_products_bulk" """ bulkFoods\n \n POST https://cz-st.fd-api.com/api/v1/catalog/products-bulk\r\n REQUEST: {\n "vendor_id": "20720",\n "products": []\n }\r\n RESPONSE: {"status":"FAIL","successRate":{"receivedCount":0,"processedCount":0,"failedCount":0,"failedIndexes":[]},"affectedProducts":[]} """ "2026-05-27 06:24:48" 29 "05-27-2026_06:24:47" "t0gy" "api" "info" """ POST https://cz-st.fd-api.com/api/v1/catalog/products-bulk\r\n REQUEST: {\n "vendor_id": "20720",\n "products": []\n }\r\n RESPONSE: {"status":"FAIL","successRate":{"receivedCount":0,"processedCount":0,"failedCount":0,"failedIndexes":[]},"affectedProducts":[]} """ 1] View formatted query View runnable query Explain query INSERT INTO log ( event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES ('api_03_create_catalog_products_bulk', 'bulkFoods POST https://cz-st.fd-api.com/api/v1/catalog/products-bulk REQUEST: { \"vendor_id\": \"20720\", \"products\": [] } RESPONSE: {\"status\":\"FAIL\",\"successRate\":{\"receivedCount\":0,\"processedCount\":0,\"failedCount\":0,\"failedIndexes\":[]},\"affectedProducts\":[]}', '2026-05-27 06:24:48', 29, '05-27-2026_06:24:47', 't0gy', 'api', 'info', 'POST https://cz-st.fd-api.com/api/v1/catalog/products-bulk REQUEST: { \"vendor_id\": \"20720\", \"products\": [] } RESPONSE: {\"status\":\"FAIL\",\"successRate\":{\"receivedCount\":0,\"processedCount\":0,\"failedCount\":0,\"failedIndexes\":[]},\"affectedProducts\":[]}', 1);
19	3.17 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
20	0.31 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
21	0.61 ms	INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`"api_03_create_catalog_products_bulk" "{"status":"FAIL","successRate":{"receivedCount":0,"processedCount":0,"failedCount":0,"failedIndexes":[]},"affectedProducts":[]}" "2026-05-27 06:24:48" 29 "05-27-2026_06:24:47" "t0gy" "api" "success" null 1`] View formatted query View runnable query Explain query INSERT INTO log ( event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES ('api_03_create_catalog_products_bulk', '{\"status\":\"FAIL\",\"successRate\":{\"receivedCount\":0,\"processedCount\":0,\"failedCount\":0,\"failedIndexes\":[]},\"affectedProducts\":[]}', '2026-05-27 06:24:48', 29, '05-27-2026_06:24:47', 't0gy', 'api', 'success', NULL, 1);
22	2.16 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
23	0.41 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
24	0.63 ms	INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`"api_04_get_catalog_products" """ getFoods\n \n GET https://cz-st.fd-api.com/api/v1/catalog/products\r\n REQUEST: {\n "vendor_id": "20720",\n "menu_category_id": "68820"\n }\r\n RESPONSE: [] """ "2026-05-27 06:24:48" 29 "05-27-2026_06:24:47" "t0gy" "api" "info" """ GET https://cz-st.fd-api.com/api/v1/catalog/products\r\n REQUEST: {\n "vendor_id": "20720",\n "menu_category_id": "68820"\n }\r\n RESPONSE: [] """ 1`] View formatted query View runnable query Explain query INSERT INTO log ( event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES ('api_04_get_catalog_products', 'getFoods GET https://cz-st.fd-api.com/api/v1/catalog/products REQUEST: { \"vendor_id\": \"20720\", \"menu_category_id\": \"68820\" } RESPONSE: []', '2026-05-27 06:24:48', 29, '05-27-2026_06:24:47', 't0gy', 'api', 'info', 'GET https://cz-st.fd-api.com/api/v1/catalog/products REQUEST: { \"vendor_id\": \"20720\", \"menu_category_id\": \"68820\" } RESPONSE: []', 1);
25	2.58 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
26	0.33 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
27	0.52 ms	INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`"api_04_get_catalog_products" "Počet jídel: 0" "2026-05-27 06:24:48" 29 "05-27-2026_06:24:47" "t0gy" "api" "success" null 1`] View formatted query View runnable query Explain query INSERT INTO log ( event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES ('api_04_get_catalog_products', 'Počet jídel: 0', '2026-05-27 06:24:48', 29, '05-27-2026_06:24:47', 't0gy', 'api', 'success', NULL, 1);
28	2.47 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
29	0.37 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
30	0.72 ms	INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: ["api_05_get_catalog_menus_items" """ getMenuItems\n \n GET https://cz-st.fd-api.com/api/v1/catalog/menus/1464/items\r\n REQUEST: \r\n RESPONSE: {"error":"Menu 1464 does not exist","code":5,"message":"Menu 1464 does not exist","details":[]} """ "2026-05-27 06:24:48" 29 "05-27-2026_06:24:47" "t0gy" "api" "info" """ GET https://cz-st.fd-api.com/api/v1/catalog/menus/1464/items\r\n REQUEST: \r\n RESPONSE: {"error":"Menu 1464 does not exist","code":5,"message":"Menu 1464 does not exist","details":[]} """ 1] View formatted query View runnable query Explain query INSERT INTO log ( event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES ('api_05_get_catalog_menus_items', 'getMenuItems GET https://cz-st.fd-api.com/api/v1/catalog/menus/1464/items REQUEST: RESPONSE: {\"error\":\"Menu 1464 does not exist\",\"code\":5,\"message\":\"Menu 1464 does not exist\",\"details\":[]}', '2026-05-27 06:24:48', 29, '05-27-2026_06:24:47', 't0gy', 'api', 'info', 'GET https://cz-st.fd-api.com/api/v1/catalog/menus/1464/items REQUEST: RESPONSE: {\"error\":\"Menu 1464 does not exist\",\"code\":5,\"message\":\"Menu 1464 does not exist\",\"details\":[]}', 1);
31	2.89 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
32	0.29 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
33	0.51 ms	INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`"api_05_get_catalog_menus_items" """ (CODE:404) Chyba při getMenuItems\n \n GET https://cz-st.fd-api.com/api/v1/catalog/menus/1464/items\r\n {"error":"Menu 1464 does not exist","code":5,"message":"Menu 1464 does not exist","details":[]} """ "2026-05-27 06:24:48" 29 "05-27-2026_06:24:47" "t0gy" "api" "error" """ GET https://cz-st.fd-api.com/api/v1/catalog/menus/1464/items\r\n {"error":"Menu 1464 does not exist","code":5,"message":"Menu 1464 does not exist","details":[]} """ 1`] View formatted query View runnable query Explain query INSERT INTO log ( event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES ('api_05_get_catalog_menus_items', '(CODE:404) Chyba při getMenuItems GET https://cz-st.fd-api.com/api/v1/catalog/menus/1464/items {\"error\":\"Menu 1464 does not exist\",\"code\":5,\"message\":\"Menu 1464 does not exist\",\"details\":[]}', '2026-05-27 06:24:48', 29, '05-27-2026_06:24:47', 't0gy', 'api', 'error', 'GET https://cz-st.fd-api.com/api/v1/catalog/menus/1464/items {\"error\":\"Menu 1464 does not exist\",\"code\":5,\"message\":\"Menu 1464 does not exist\",\"details\":[]}', 1);
34	2.48 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
35	0.40 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
36	0.65 ms	INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`"api_01_get_catalog_products" """ getFoods\n \n GET https://cz-st.fd-api.com/api/v1/catalog/products\r\n REQUEST: {\n "vendor_id": "20720",\n "menu_category_id": "87781"\n }\r\n RESPONSE: [] """ "2026-05-27 06:24:48" 3038 "05-27-2026_06:24:47" "t0gy" "api" "info" """ GET https://cz-st.fd-api.com/api/v1/catalog/products\r\n REQUEST: {\n "vendor_id": "20720",\n "menu_category_id": "87781"\n }\r\n RESPONSE: [] """ 1`] View formatted query View runnable query Explain query INSERT INTO log ( event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES ('api_01_get_catalog_products', 'getFoods GET https://cz-st.fd-api.com/api/v1/catalog/products REQUEST: { \"vendor_id\": \"20720\", \"menu_category_id\": \"87781\" } RESPONSE: []', '2026-05-27 06:24:48', 3038, '05-27-2026_06:24:47', 't0gy', 'api', 'info', 'GET https://cz-st.fd-api.com/api/v1/catalog/products REQUEST: { \"vendor_id\": \"20720\", \"menu_category_id\": \"87781\" } RESPONSE: []', 1);
37	3.00 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
38	0.31 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
39	0.55 ms	INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`"api_01_get_catalog_products" "Počet jídel: 0" "2026-05-27 06:24:48" 3038 "05-27-2026_06:24:47" "t0gy" "api" "success" null 1`] View formatted query View runnable query Explain query INSERT INTO log ( event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES ('api_01_get_catalog_products', 'Počet jídel: 0', '2026-05-27 06:24:48', 3038, '05-27-2026_06:24:47', 't0gy', 'api', 'success', NULL, 1);
40	2.58 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
41	0.38 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
42	0.49 ms	INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`"api_02_delete_catalog_products_bulk" "Api nevrátilo žádné jídlo, proto nebylo možné je smazat" "2026-05-27 06:24:48" 3038 "05-27-2026_06:24:47" "t0gy" "api" "success" null 1`] View formatted query View runnable query Explain query INSERT INTO log ( event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES ('api_02_delete_catalog_products_bulk', 'Api nevrátilo žádné jídlo, proto nebylo možné je smazat', '2026-05-27 06:24:48', 3038, '05-27-2026_06:24:47', 't0gy', 'api', 'success', NULL, 1);
43	2.44 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
44	0.84 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, f0_.restaurant_id AS restaurant_id_11 FROM food f0_ WHERE f0_.restaurant_id = ? AND f0_.date = ? ORDER BY f0_.id ASC Parameters: [`3038 "2026-05-27"`] View formatted query View runnable query Explain query 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 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 = 3038 AND f0_.date = '2026-05-27' ORDER BY f0_.id ASC;
45	0.59 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
46	0.98 ms	INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: ["api_03_create_catalog_products_bulk" """ bulkFoods\n \n POST https://cz-st.fd-api.com/api/v1/catalog/products-bulk\r\n REQUEST: {\n "vendor_id": "20720",\n "products": [\n {\n "id": "",\n "code": "2",\n "default_title": "Chleba s m\u00e1slem",\n "title": {\n "cs": "Chleba s m\u00e1slem",\n "sk": "Chleba s m\u00e1slem",\n "en": "Chleba s m\u00e1slem",\n "de": "Chleba s m\u00e1slem"\n },\n "default_description": "chleba",\n "description": {\n "cs": "chleba",\n "sk": "chleba",\n "en": "chleba",\n "de": "chleba"\n },\n "menu_category_id": "87781",\n "active": true,\n "images": {\n "list": [\n "\/image\/foodpanda\/cz\/4000x2925.png"\n ]\n },\n "variations": [\n {\n "remote_code": "",\n "default_title": "DM",\n "title": {\n "cs": "DM",\n "sk": "DM",\n "en": "DM",\n "de": "DM"\n },\n "unit_price": 15,\n "container_price": 0\n }\n ]\n }\n ]\n }\r\n RESPONSE: {"status":"SUCCESS","successRate":{"receivedCount":1,"processedCount":1,"failedCount":0,"failedIndexes":[]},"affectedProducts":[{"productId":"1357429","variationIds":["1912216"]}]} """ "2026-05-27 06:24:48" 3038 "05-27-2026_06:24:47" "t0gy" "api" "info" """ POST https://cz-st.fd-api.com/api/v1/catalog/products-bulk\r\n REQUEST: {\n "vendor_id": "20720",\n "products": [\n {\n "id": "",\n "code": "2",\n "default_title": "Chleba s m\u00e1slem",\n "title": {\n "cs": "Chleba s m\u00e1slem",\n "sk": "Chleba s m\u00e1slem",\n "en": "Chleba s m\u00e1slem",\n "de": "Chleba s m\u00e1slem"\n },\n "default_description": "chleba",\n "description": {\n "cs": "chleba",\n "sk": "chleba",\n "en": "chleba",\n "de": "chleba"\n },\n "menu_category_id": "87781",\n "active": true,\n "images": {\n "list": [\n "\/image\/foodpanda\/cz\/4000x2925.png"\n ]\n },\n "variations": [\n {\n "remote_code": "",\n "default_title": "DM",\n "title": {\n "cs": "DM",\n "sk": "DM",\n "en": "DM",\n "de": "DM"\n },\n "unit_price": 15,\n "container_price": 0\n }\n ]\n }\n ]\n }\r\n RESPONSE: {"status":"SUCCESS","successRate":{"receivedCount":1,"processedCount":1,"failedCount":0,"failedIndexes":[]},"affectedProducts":[{"productId":"1357429","variationIds":["1912216"]}]} """ 1] View formatted query View runnable query Explain query INSERT INTO log ( event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES ('api_03_create_catalog_products_bulk', 'bulkFoods POST https://cz-st.fd-api.com/api/v1/catalog/products-bulk REQUEST: { \"vendor_id\": \"20720\", \"products\": [ { \"id\": \"\", \"code\": \"2\", \"default_title\": \"Chleba s m\\u00e1slem\", \"title\": { \"cs\": \"Chleba s m\\u00e1slem\", \"sk\": \"Chleba s m\\u00e1slem\", \"en\": \"Chleba s m\\u00e1slem\", \"de\": \"Chleba s m\\u00e1slem\" }, \"default_description\": \"chleba\", \"description\": { \"cs\": \"chleba\", \"sk\": \"chleba\", \"en\": \"chleba\", \"de\": \"chleba\" }, \"menu_category_id\": \"87781\", \"active\": true, \"images\": { \"list\": [ \"\\/image\\/foodpanda\\/cz\\/4000x2925.png\" ] }, \"variations\": [ { \"remote_code\": \"\", \"default_title\": \"DM\", \"title\": { \"cs\": \"DM\", \"sk\": \"DM\", \"en\": \"DM\", \"de\": \"DM\" }, \"unit_price\": 15, \"container_price\": 0 } ] } ] } RESPONSE: {\"status\":\"SUCCESS\",\"successRate\":{\"receivedCount\":1,\"processedCount\":1,\"failedCount\":0,\"failedIndexes\":[]},\"affectedProducts\":[{\"productId\":\"1357429\",\"variationIds\":[\"1912216\"]}]}', '2026-05-27 06:24:48', 3038, '05-27-2026_06:24:47', 't0gy', 'api', 'info', 'POST https://cz-st.fd-api.com/api/v1/catalog/products-bulk REQUEST: { \"vendor_id\": \"20720\", \"products\": [ { \"id\": \"\", \"code\": \"2\", \"default_title\": \"Chleba s m\\u00e1slem\", \"title\": { \"cs\": \"Chleba s m\\u00e1slem\", \"sk\": \"Chleba s m\\u00e1slem\", \"en\": \"Chleba s m\\u00e1slem\", \"de\": \"Chleba s m\\u00e1slem\" }, \"default_description\": \"chleba\", \"description\": { \"cs\": \"chleba\", \"sk\": \"chleba\", \"en\": \"chleba\", \"de\": \"chleba\" }, \"menu_category_id\": \"87781\", \"active\": true, \"images\": { \"list\": [ \"\\/image\\/foodpanda\\/cz\\/4000x2925.png\" ] }, \"variations\": [ { \"remote_code\": \"\", \"default_title\": \"DM\", \"title\": { \"cs\": \"DM\", \"sk\": \"DM\", \"en\": \"DM\", \"de\": \"DM\" }, \"unit_price\": 15, \"container_price\": 0 } ] } ] } RESPONSE: {\"status\":\"SUCCESS\",\"successRate\":{\"receivedCount\":1,\"processedCount\":1,\"failedCount\":0,\"failedIndexes\":[]},\"affectedProducts\":[{\"productId\":\"1357429\",\"variationIds\":[\"1912216\"]}]}', 1);
47	4.01 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
48	0.35 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
49	0.69 ms	INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`"api_03_create_catalog_products_bulk" "(0-50 z 1) Api přijalo: 1 položek. Zprocesovalo: 1 položek. Neúspěšně: 0 položek. " "2026-05-27 06:24:48" 3038 "05-27-2026_06:24:47" "t0gy" "api" "success" null 1`] View formatted query View runnable query Explain query INSERT INTO log ( event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES ('api_03_create_catalog_products_bulk', '(0-50 z 1) Api přijalo: 1 položek. Zprocesovalo: 1 položek. Neúspěšně: 0 položek. ', '2026-05-27 06:24:48', 3038, '05-27-2026_06:24:47', 't0gy', 'api', 'success', NULL, 1);
50	3.57 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
51	0.36 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
52	2.78 ms	INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: ["api_04_get_catalog_products" """ getFoods\n \n GET https://cz-st.fd-api.com/api/v1/catalog/products\r\n REQUEST: {\n "vendor_id": "20720",\n "menu_category_id": "87781"\n }\r\n RESPONSE: [{"id":"1357429","code":"1721b8e5-3dbe-4b03-857a-01c4514b2941","defaultTitle":"Chleba s máslem","title":{"cs_CZ":"Chleba s máslem","en_CZ":"Chleba s máslem"},"defaultDescription":"chleba","description":{"cs_CZ":"chleba","en_CZ":"chleba"},"descriptionType":"VENDOR","category":{"id":"87781","code":"e3689937-f987-4b2f-86a8-239e3aaeed0f","defaultTitle":"Denní menu","title":{"cs_CZ":"Denní menu","en_CZ":"Denní menu"},"defaultDescription":"Denní menu (pro sync)","description":{"cs_CZ":"Denní menu (pro sync)"},"masterCategory":{"id":"19","title":"Big Mains"},"vendorCode":"t0gy","vat":null,"serviceTax":null,"containerPrice":10,"vendorId":"20720","position":"1","image":"","partnerId":null,"createdAt":null,"updatedAt":null},"variants":[{"id":"1912216","code":"8eb8b193-5c26-464e-9e7d-f1a8abe366b4","defaultTitle":"","title":{},"unitPrice":15,"containerPrice":0,"remoteCode":"","toppings":[],"choiceGroupIds":[],"deleted":false,"createdAt":"2026-05-27T06:24:48Z","product":null,"choiceGroups":[],"updatedAt":"2026-05-27T06:24:48Z","position":0,"isAvailable":null,"vendorId":null}],"active":true,"deleted":false,"imageUrls":["https://images.deliveryhero.io/image/foodpanda/cz/4000x2925.png"],"isPrepacked":false,"isExpress":true,"excludeInformation":false,"vat":null,"serviceTax":null,"vatProductLevel":null,"images":[],"sku":"","barcodes":[],"weightKg":null,"createdAt":"2026-05-27T06:24:48Z","updatedAt":"2026-05-27T06:24:48Z","isBundle":false,"partnerId":null,"tags":[],"configurationErrors":[{"type":"ERROR","description":"The product is not in any menu","entity":{"id":"1357429","type":"PRODUCT","title":"Chleba s máslem","additionalErrors":[]}}],"commissionProfileId":null,"dietaryAttributes":null,"unavailableUntil":null,"foodprintAttributes":null,"positionInCategory":1}] """ "2026-05-27 06:24:48" 3038 "05-27-2026_06:24:47" "t0gy" "api" "info" """ GET https://cz-st.fd-api.com/api/v1/catalog/products\r\n REQUEST: {\n "vendor_id": "20720",\n "menu_category_id": "87781"\n }\r\n RESPONSE: [{"id":"1357429","code":"1721b8e5-3dbe-4b03-857a-01c4514b2941","defaultTitle":"Chleba s máslem","title":{"cs_CZ":"Chleba s máslem","en_CZ":"Chleba s máslem"},"defaultDescription":"chleba","description":{"cs_CZ":"chleba","en_CZ":"chleba"},"descriptionType":"VENDOR","category":{"id":"87781","code":"e3689937-f987-4b2f-86a8-239e3aaeed0f","defaultTitle":"Denní menu","title":{"cs_CZ":"Denní menu","en_CZ":"Denní menu"},"defaultDescription":"Denní menu (pro sync)","description":{"cs_CZ":"Denní menu (pro sync)"},"masterCategory":{"id":"19","title":"Big Mains"},"vendorCode":"t0gy","vat":null,"serviceTax":null,"containerPrice":10,"vendorId":"20720","position":"1","image":"","partnerId":null,"createdAt":null,"updatedAt":null},"variants":[{"id":"1912216","code":"8eb8b193-5c26-464e-9e7d-f1a8abe366b4","defaultTitle":"","title":{},"unitPrice":15,"containerPrice":0,"remoteCode":"","toppings":[],"choiceGroupIds":[],"deleted":false,"createdAt":"2026-05-27T06:24:48Z","product":null,"choiceGroups":[],"updatedAt":"2026-05-27T06:24:48Z","position":0,"isAvailable":null,"vendorId":null}],"active":true,"deleted":false,"imageUrls":["https://images.deliveryhero.io/image/foodpanda/cz/4000x2925.png"],"isPrepacked":false,"isExpress":true,"excludeInformation":false,"vat":null,"serviceTax":null,"vatProductLevel":null,"images":[],"sku":"","barcodes":[],"weightKg":null,"createdAt":"2026-05-27T06:24:48Z","updatedAt":"2026-05-27T06:24:48Z","isBundle":false,"partnerId":null,"tags":[],"configurationErrors":[{"type":"ERROR","description":"The product is not in any menu","entity":{"id":"1357429","type":"PRODUCT","title":"Chleba s máslem","additionalErrors":[]}}],"commissionProfileId":null,"dietaryAttributes":null,"unavailableUntil":null,"foodprintAttributes":null,"positionInCategory":1}] """ 1] View formatted query View runnable query Explain query INSERT INTO log ( event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES ('api_04_get_catalog_products', 'getFoods GET https://cz-st.fd-api.com/api/v1/catalog/products REQUEST: { \"vendor_id\": \"20720\", \"menu_category_id\": \"87781\" } RESPONSE: [{\"id\":\"1357429\",\"code\":\"1721b8e5-3dbe-4b03-857a-01c4514b2941\",\"defaultTitle\":\"Chleba s máslem\",\"title\":{\"cs_CZ\":\"Chleba s máslem\",\"en_CZ\":\"Chleba s máslem\"},\"defaultDescription\":\"chleba\",\"description\":{\"cs_CZ\":\"chleba\",\"en_CZ\":\"chleba\"},\"descriptionType\":\"VENDOR\",\"category\":{\"id\":\"87781\",\"code\":\"e3689937-f987-4b2f-86a8-239e3aaeed0f\",\"defaultTitle\":\"Denní menu\",\"title\":{\"cs_CZ\":\"Denní menu\",\"en_CZ\":\"Denní menu\"},\"defaultDescription\":\"Denní menu (pro sync)\",\"description\":{\"cs_CZ\":\"Denní menu (pro sync)\"},\"masterCategory\":{\"id\":\"19\",\"title\":\"Big Mains\"},\"vendorCode\":\"t0gy\",\"vat\":null,\"serviceTax\":null,\"containerPrice\":10,\"vendorId\":\"20720\",\"position\":\"1\",\"image\":\"\",\"partnerId\":null,\"createdAt\":null,\"updatedAt\":null},\"variants\":[{\"id\":\"1912216\",\"code\":\"8eb8b193-5c26-464e-9e7d-f1a8abe366b4\",\"defaultTitle\":\"\",\"title\":{},\"unitPrice\":15,\"containerPrice\":0,\"remoteCode\":\"\",\"toppings\":[],\"choiceGroupIds\":[],\"deleted\":false,\"createdAt\":\"2026-05-27T06:24:48Z\",\"product\":null,\"choiceGroups\":[],\"updatedAt\":\"2026-05-27T06:24:48Z\",\"position\":0,\"isAvailable\":null,\"vendorId\":null}],\"active\":true,\"deleted\":false,\"imageUrls\":[\"https://images.deliveryhero.io/image/foodpanda/cz/4000x2925.png\"],\"isPrepacked\":false,\"isExpress\":true,\"excludeInformation\":false,\"vat\":null,\"serviceTax\":null,\"vatProductLevel\":null,\"images\":[],\"sku\":\"\",\"barcodes\":[],\"weightKg\":null,\"createdAt\":\"2026-05-27T06:24:48Z\",\"updatedAt\":\"2026-05-27T06:24:48Z\",\"isBundle\":false,\"partnerId\":null,\"tags\":[],\"configurationErrors\":[{\"type\":\"ERROR\",\"description\":\"The product is not in any menu\",\"entity\":{\"id\":\"1357429\",\"type\":\"PRODUCT\",\"title\":\"Chleba s máslem\",\"additionalErrors\":[]}}],\"commissionProfileId\":null,\"dietaryAttributes\":null,\"unavailableUntil\":null,\"foodprintAttributes\":null,\"positionInCategory\":1}]', '2026-05-27 06:24:48', 3038, '05-27-2026_06:24:47', 't0gy', 'api', 'info', 'GET https://cz-st.fd-api.com/api/v1/catalog/products REQUEST: { \"vendor_id\": \"20720\", \"menu_category_id\": \"87781\" } RESPONSE: [{\"id\":\"1357429\",\"code\":\"1721b8e5-3dbe-4b03-857a-01c4514b2941\",\"defaultTitle\":\"Chleba s máslem\",\"title\":{\"cs_CZ\":\"Chleba s máslem\",\"en_CZ\":\"Chleba s máslem\"},\"defaultDescription\":\"chleba\",\"description\":{\"cs_CZ\":\"chleba\",\"en_CZ\":\"chleba\"},\"descriptionType\":\"VENDOR\",\"category\":{\"id\":\"87781\",\"code\":\"e3689937-f987-4b2f-86a8-239e3aaeed0f\",\"defaultTitle\":\"Denní menu\",\"title\":{\"cs_CZ\":\"Denní menu\",\"en_CZ\":\"Denní menu\"},\"defaultDescription\":\"Denní menu (pro sync)\",\"description\":{\"cs_CZ\":\"Denní menu (pro sync)\"},\"masterCategory\":{\"id\":\"19\",\"title\":\"Big Mains\"},\"vendorCode\":\"t0gy\",\"vat\":null,\"serviceTax\":null,\"containerPrice\":10,\"vendorId\":\"20720\",\"position\":\"1\",\"image\":\"\",\"partnerId\":null,\"createdAt\":null,\"updatedAt\":null},\"variants\":[{\"id\":\"1912216\",\"code\":\"8eb8b193-5c26-464e-9e7d-f1a8abe366b4\",\"defaultTitle\":\"\",\"title\":{},\"unitPrice\":15,\"containerPrice\":0,\"remoteCode\":\"\",\"toppings\":[],\"choiceGroupIds\":[],\"deleted\":false,\"createdAt\":\"2026-05-27T06:24:48Z\",\"product\":null,\"choiceGroups\":[],\"updatedAt\":\"2026-05-27T06:24:48Z\",\"position\":0,\"isAvailable\":null,\"vendorId\":null}],\"active\":true,\"deleted\":false,\"imageUrls\":[\"https://images.deliveryhero.io/image/foodpanda/cz/4000x2925.png\"],\"isPrepacked\":false,\"isExpress\":true,\"excludeInformation\":false,\"vat\":null,\"serviceTax\":null,\"vatProductLevel\":null,\"images\":[],\"sku\":\"\",\"barcodes\":[],\"weightKg\":null,\"createdAt\":\"2026-05-27T06:24:48Z\",\"updatedAt\":\"2026-05-27T06:24:48Z\",\"isBundle\":false,\"partnerId\":null,\"tags\":[],\"configurationErrors\":[{\"type\":\"ERROR\",\"description\":\"The product is not in any menu\",\"entity\":{\"id\":\"1357429\",\"type\":\"PRODUCT\",\"title\":\"Chleba s máslem\",\"additionalErrors\":[]}}],\"commissionProfileId\":null,\"dietaryAttributes\":null,\"unavailableUntil\":null,\"foodprintAttributes\":null,\"positionInCategory\":1}]', 1);
53	2.77 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
54	0.37 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
55	0.61 ms	INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`"api_04_get_catalog_products" "Počet jídel: 1" "2026-05-27 06:24:48" 3038 "05-27-2026_06:24:47" "t0gy" "api" "success" null 1`] View formatted query View runnable query Explain query INSERT INTO log ( event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES ('api_04_get_catalog_products', 'Počet jídel: 1', '2026-05-27 06:24:48', 3038, '05-27-2026_06:24:47', 't0gy', 'api', 'success', NULL, 1);
56	2.66 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
57	0.40 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
58	0.71 ms	INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: ["api_05_get_catalog_menus_items" """ getMenuItems\n \n GET https://cz-st.fd-api.com/api/v1/catalog/menus/13630/items\r\n REQUEST: \r\n RESPONSE: [{"menuId":"13630","productId":"739196","position":"1","deleted":false},{"menuId":"13630","productId":"739197","position":"2","deleted":false},{"menuId":"13630","productId":"739198","position":"3","deleted":false},{"menuId":"13630","productId":"739190","position":"4","deleted":false},{"menuId":"13630","productId":"739192","position":"5","deleted":false},{"menuId":"13630","productId":"739193","position":"6","deleted":false},{"menuId":"13630","productId":"739195","position":"7","deleted":false}] """ "2026-05-27 06:24:48" 3038 "05-27-2026_06:24:47" "t0gy" "api" "info" """ GET https://cz-st.fd-api.com/api/v1/catalog/menus/13630/items\r\n REQUEST: \r\n RESPONSE: [{"menuId":"13630","productId":"739196","position":"1","deleted":false},{"menuId":"13630","productId":"739197","position":"2","deleted":false},{"menuId":"13630","productId":"739198","position":"3","deleted":false},{"menuId":"13630","productId":"739190","position":"4","deleted":false},{"menuId":"13630","productId":"739192","position":"5","deleted":false},{"menuId":"13630","productId":"739193","position":"6","deleted":false},{"menuId":"13630","productId":"739195","position":"7","deleted":false}] """ 1] View formatted query View runnable query Explain query INSERT INTO log ( event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES ('api_05_get_catalog_menus_items', 'getMenuItems GET https://cz-st.fd-api.com/api/v1/catalog/menus/13630/items REQUEST: RESPONSE: [{\"menuId\":\"13630\",\"productId\":\"739196\",\"position\":\"1\",\"deleted\":false},{\"menuId\":\"13630\",\"productId\":\"739197\",\"position\":\"2\",\"deleted\":false},{\"menuId\":\"13630\",\"productId\":\"739198\",\"position\":\"3\",\"deleted\":false},{\"menuId\":\"13630\",\"productId\":\"739190\",\"position\":\"4\",\"deleted\":false},{\"menuId\":\"13630\",\"productId\":\"739192\",\"position\":\"5\",\"deleted\":false},{\"menuId\":\"13630\",\"productId\":\"739193\",\"position\":\"6\",\"deleted\":false},{\"menuId\":\"13630\",\"productId\":\"739195\",\"position\":\"7\",\"deleted\":false}]', '2026-05-27 06:24:48', 3038, '05-27-2026_06:24:47', 't0gy', 'api', 'info', 'GET https://cz-st.fd-api.com/api/v1/catalog/menus/13630/items REQUEST: RESPONSE: [{\"menuId\":\"13630\",\"productId\":\"739196\",\"position\":\"1\",\"deleted\":false},{\"menuId\":\"13630\",\"productId\":\"739197\",\"position\":\"2\",\"deleted\":false},{\"menuId\":\"13630\",\"productId\":\"739198\",\"position\":\"3\",\"deleted\":false},{\"menuId\":\"13630\",\"productId\":\"739190\",\"position\":\"4\",\"deleted\":false},{\"menuId\":\"13630\",\"productId\":\"739192\",\"position\":\"5\",\"deleted\":false},{\"menuId\":\"13630\",\"productId\":\"739193\",\"position\":\"6\",\"deleted\":false},{\"menuId\":\"13630\",\"productId\":\"739195\",\"position\":\"7\",\"deleted\":false}]', 1);
59	2.72 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
60	0.29 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
61	0.52 ms	INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`"api_05_get_catalog_menus_items" "Api přijalo: 7 položek. z menuId: 13630" "2026-05-27 06:24:48" null "05-27-2026_06:24:47" "t0gy" "api" "success" null 1`] View formatted query View runnable query Explain query INSERT INTO log ( event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES ('api_05_get_catalog_menus_items', 'Api přijalo: 7 položek. z menuId: 13630', '2026-05-27 06:24:48', NULL, '05-27-2026_06:24:47', 't0gy', 'api', 'success', NULL, 1);
62	2.70 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
63	0.67 ms	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"`] View formatted query View runnable query Explain query 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 = ? 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 = 'Chleba s máslem';
64	0.28 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
65	0.58 ms	UPDATE food SET pandora_id = ? WHERE id = ? Parameters: [`"1357429" 2`] View formatted query View runnable query Explain query UPDATE food SET pandora_id = ? WHERE id = ? UPDATE food SET pandora_id = '1357429' WHERE id = 2;
66	2.49 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
67	0.58 ms	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`] View formatted query View runnable query Explain query 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 = ? 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 = 2;
68	0.41 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
69	0.59 ms	INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: ["api_06_patch_catalog_menus_assign" """ menuId: 13630\n \n PATCH https://cz-st.fd-api.com/api/v1/catalog/menus/13630/assign-products\r\n REQUEST: {\n "products_ids": [\n "739196",\n "739197",\n "739198",\n "739190",\n "739192",\n "739193",\n "739195",\n "1357429"\n ]\n }\r\n RESPONSE: """ "2026-05-27 06:24:48" 3038 "05-27-2026_06:24:47" "t0gy" "api" "info" """ PATCH https://cz-st.fd-api.com/api/v1/catalog/menus/13630/assign-products\r\n REQUEST: {\n "products_ids": [\n "739196",\n "739197",\n "739198",\n "739190",\n "739192",\n "739193",\n "739195",\n "1357429"\n ]\n }\r\n RESPONSE: """ 1] View formatted query View runnable query Explain query INSERT INTO log ( event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES ('api_06_patch_catalog_menus_assign', 'menuId: 13630 PATCH https://cz-st.fd-api.com/api/v1/catalog/menus/13630/assign-products REQUEST: { \"products_ids\": [ \"739196\", \"739197\", \"739198\", \"739190\", \"739192\", \"739193\", \"739195\", \"1357429\" ] } RESPONSE: ', '2026-05-27 06:24:48', 3038, '05-27-2026_06:24:47', 't0gy', 'api', 'info', 'PATCH https://cz-st.fd-api.com/api/v1/catalog/menus/13630/assign-products REQUEST: { \"products_ids\": [ \"739196\", \"739197\", \"739198\", \"739190\", \"739192\", \"739193\", \"739195\", \"1357429\" ] } RESPONSE: ', 1);
70	4.08 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
71	0.40 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
72	0.62 ms	INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`"api_06_patch_catalog_menus_assign" """ menuId: 13630\n \n {\n "products_ids": [\n "739196",\n "739197",\n "739198",\n "739190",\n "739192",\n "739193",\n "739195",\n "1357429"\n ]\n } """ "2026-05-27 06:24:48" 3038 "05-27-2026_06:24:47" "t0gy" "api" "success" """ {\n "products_ids": [\n "739196",\n "739197",\n "739198",\n "739190",\n "739192",\n "739193",\n "739195",\n "1357429"\n ]\n } """ 1`] View formatted query View runnable query Explain query INSERT INTO log ( event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES ('api_06_patch_catalog_menus_assign', 'menuId: 13630 { \"products_ids\": [ \"739196\", \"739197\", \"739198\", \"739190\", \"739192\", \"739193\", \"739195\", \"1357429\" ] }', '2026-05-27 06:24:48', 3038, '05-27-2026_06:24:47', 't0gy', 'api', 'success', '{ \"products_ids\": [ \"739196\", \"739197\", \"739198\", \"739190\", \"739192\", \"739193\", \"739195\", \"1357429\" ] }', 1);
73	2.74 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
74	0.39 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
75	0.56 ms	INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`"api_06_patch_catalog_menus_assign" "8 jídel bylo přidáno do menu" "2026-05-27 06:24:48" 3038 "05-27-2026_06:24:47" "t0gy" "api" "success" null 1`] View formatted query View runnable query Explain query INSERT INTO log ( event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES ('api_06_patch_catalog_menus_assign', '8 jídel bylo přidáno do menu', '2026-05-27 06:24:48', 3038, '05-27-2026_06:24:47', 't0gy', 'api', 'success', NULL, 1);
76	2.35 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
77	0.37 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
78	0.55 ms	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 END, items: 2" "2026-05-27 06:24:48" null "05-27-2026_06:24:47" null "api" "success" null 1`] View formatted query View runnable query Explain query INSERT INTO log ( event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO log (event, description, created, entity_id, group_call, vendor_code, type, state, data, user_id) VALUES ('api_export', 'Export 05-27-2026_06:24:47 END, items: 2', '2026-05-27 06:24:48', NULL, '05-27-2026_06:24:47', NULL, 'api', 'success', NULL, 1);
79	2.78 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";

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.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping