Query Metrics
18
Database Queries
11
Different statements
32.48 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.90 ms |
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.api_key AS api_key_2, e0_.shoptet_id AS shoptet_id_3, e0_.locale AS locale_4, e0_.currency AS currency_5, e0_.url AS url_6, e0_.logo AS logo_7, e0_.last_order_change AS last_order_change_8, e0_.last_product_change AS last_product_change_9, e0_.storno_status AS storno_status_10, e0_.export_status AS export_status_11, e0_.pack_status AS pack_status_12, e0_.last_stock_movement AS last_stock_movement_13, e0_.stock AS stock_14, e0_.discard_order_before_date AS discard_order_before_date_15, e0_.locked AS locked_16, e0_.createts AS createts_17, e0_.editts AS editts_18, e0_.create_user_id AS create_user_id_19, e0_.edit_user_id AS edit_user_id_20 FROM eshop e0_ ORDER BY e0_.last_order_change ASC LIMIT 1
Parameters:
[] |
| 2 | 2.02 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.api_key AS api_key_3, t0.shoptet_id AS shoptet_id_4, t0.locale AS locale_5, t0.currency AS currency_6, t0.url AS url_7, t0.logo AS logo_8, t0.last_order_change AS last_order_change_9, t0.last_product_change AS last_product_change_10, t0.storno_status AS storno_status_11, t0.export_status AS export_status_12, t0.pack_status AS pack_status_13, t0.last_stock_movement AS last_stock_movement_14, t0.stock AS stock_15, t0.discard_order_before_date AS discard_order_before_date_16, t0.locked AS locked_17, t0.createts AS createts_18, t0.editts AS editts_19, t0.create_user_id AS create_user_id_20, t0.edit_user_id AS edit_user_id_21 FROM eshop t0 WHERE t0.shoptet_id = ? LIMIT 1
Parameters:
[
312604
]
|
| 3 | 0.68 ms |
"START TRANSACTION"
Parameters:
[] |
| 4 | 5.51 ms |
INSERT INTO webhook (createts, event, event_instance, processed, eshop_id) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2026-05-08 10:42:10" "order:create" "1202603019" 0 1 ] |
| 5 | 0.53 ms |
"COMMIT"
Parameters:
[] |
| 6 | 8.94 ms |
SELECT v0_.code AS code_0, v0_.weight AS weight_1 FROM `variant` v0_ WHERE v0_.name <> ?
Parameters:
[
"sklad"
]
|
| 7 | 2.27 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.email AS email_3, t0.eshop_id AS eshop_id_4, t0.createts AS createts_5, t0.items AS items_6, t0.status AS status_7, t0.deleted AS deleted_8, t0.we_care AS we_care_9, t0.origin AS origin_10 FROM `order` t0 WHERE t0.code = ? AND t0.eshop_id = ? LIMIT 1
Parameters:
[ "1202603019" 312604 ] |
| 8 | 0.42 ms |
"START TRANSACTION"
Parameters:
[] |
| 9 | 1.90 ms |
INSERT INTO `order` (code, email, eshop_id, createts, items, status, deleted, we_care, origin) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "1202603019" "sabinalancova@seznam.cz" 312604 "2026-05-08 10:42:10" "{"768974":{"code":"1026\/10","amount":1.0,"unit":"Obsah: 10 ml","itemId":768974,"isPacked":null,"packedUser":null,"packedTS":null},"768968":{"code":"3242","amount":1.0,"unit":null,"itemId":768968,"isPacked":null,"packedUser":null,"packedTS":null},"768971":{"code":"KR00008","amount":1.0,"unit":null,"itemId":768971,"isPacked":null,"packedUser":null,"packedTS":null},"768977":{"code":"ACC-501","amount":1.0,"unit":null,"itemId":768977,"isPacked":null,"packedUser":null,"packedTS":null}}" -1 null 0 "webhook" ] |
| 10 | 0.46 ms |
"COMMIT"
Parameters:
[] |
| 11 | 0.56 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.email AS email_3, t0.eshop_id AS eshop_id_4, t0.createts AS createts_5, t0.items AS items_6, t0.status AS status_7, t0.deleted AS deleted_8, t0.we_care AS we_care_9, t0.origin AS origin_10 FROM `order` t0 WHERE t0.id = ?
Parameters:
[
45139
]
|
| 12 | 1.58 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.weight AS weight_4, t0.stock AS stock_5, t0.buy_price AS buy_price_6, t0.createts AS createts_7, t0.editts AS editts_8, t0.product_id AS product_id_9, t0.create_user_id AS create_user_id_10, t0.edit_user_id AS edit_user_id_11 FROM `variant` t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"1026/10"
]
|
| 13 | 1.45 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.weight AS weight_4, t0.stock AS stock_5, t0.buy_price AS buy_price_6, t0.createts AS createts_7, t0.editts AS editts_8, t0.product_id AS product_id_9, t0.create_user_id AS create_user_id_10, t0.edit_user_id AS edit_user_id_11 FROM `variant` t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"3242"
]
|
| 14 | 1.31 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.weight AS weight_4, t0.stock AS stock_5, t0.buy_price AS buy_price_6, t0.createts AS createts_7, t0.editts AS editts_8, t0.product_id AS product_id_9, t0.create_user_id AS create_user_id_10, t0.edit_user_id AS edit_user_id_11 FROM `variant` t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"KR00008"
]
|
| 15 | 1.29 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.weight AS weight_4, t0.stock AS stock_5, t0.buy_price AS buy_price_6, t0.createts AS createts_7, t0.editts AS editts_8, t0.product_id AS product_id_9, t0.create_user_id AS create_user_id_10, t0.edit_user_id AS edit_user_id_11 FROM `variant` t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"ACC-501"
]
|
| 16 | 0.47 ms |
"START TRANSACTION"
Parameters:
[] |
| 17 | 0.70 ms |
UPDATE webhook SET processed = ? WHERE id = ?
Parameters:
[ 1 415567 ] |
| 18 | 0.47 ms |
"COMMIT"
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Eshop | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Webhook | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\Variant | No errors. |
| App\Entity\Order | No errors. |