Query Metrics
47
Database Queries
15
Different statements
419.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
189.76 ms (45.21%) |
16 |
UPDATE `variant` SET stock = ?, editts = ? WHERE id = ?
Parameters:
[ 55.0 "2026-07-07 13:42:05" 1147 ] |
|
106.84 ms (25.45%) |
7 |
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:
[
"HASIS-NATURAL-10"
]
|
|
60.08 ms (14.31%) |
1 |
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:
[
47825
]
|
|
14.51 ms (3.46%) |
2 |
INSERT INTO product_log (code, `before`, `current`, `change`, `type`, eshop_id, type_id, createts, editts, product_id, create_user_id, edit_user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "HASIS-NATURAL-10" 560.0 550.0 -10.0 3 312604 "1202604367" "2026-07-07 13:42:04" null 115 null null ] |
|
14.41 ms (3.43%) |
1 |
SELECT v0_.code AS code_0, v0_.weight AS weight_1 FROM `variant` v0_ WHERE v0_.name <> ?
Parameters:
[
"sklad"
]
|
|
6.01 ms (1.43%) |
5 |
"COMMIT"
Parameters:
[] |
|
5.26 ms (1.25%) |
1 |
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:
[] |
|
3.68 ms (0.88%) |
2 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.guid AS guid_3, t0.name AS name_4, t0.url AS url_5, t0.category_name AS category_name_6, t0.variants_checked AS variants_checked_7, t0.createts AS createts_8, t0.editts AS editts_9, t0.eshop_id AS eshop_id_10, t0.create_user_id AS create_user_id_11, t0.edit_user_id AS edit_user_id_12 FROM product t0 WHERE t0.id = ?
Parameters:
[
115
]
|
|
3.66 ms (0.87%) |
5 |
"START TRANSACTION"
Parameters:
[] |
|
3.50 ms (0.83%) |
2 |
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.product_id = ? ORDER BY t0.weight ASC
Parameters:
[
115
]
|
|
3.09 ms (0.74%) |
1 |
UPDATE webhook SET processed = ? WHERE id = ?
Parameters:
[ 1 440523 ] |
|
2.78 ms (0.66%) |
1 |
INSERT INTO webhook (createts, event, event_instance, processed, eshop_id) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2026-07-07 13:42:04" "order:create" "1202604367" 0 1 ] |
|
2.56 ms (0.61%) |
1 |
INSERT INTO `order` (code, email, eshop_id, createts, items, status, deleted, we_care, origin) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "1202604367" "savs.hrdlicka@seznam.cz" 312604 "2026-07-07 13:42:04" "{"790868":{"code":"HASIS-NATURAL-10","amount":1.0,"unit":"10 g","itemId":790868,"isPacked":null,"packedUser":null,"packedTS":null},"790865":{"code":"CBD-ORANGE-BUD-25","amount":1.0,"unit":"25 g","itemId":790865,"isPacked":null,"packedUser":null,"packedTS":null},"790877":{"code":"M9067","amount":1.0,"unit":null,"itemId":790877,"isPacked":null,"packedUser":null,"packedTS":null},"790874":{"code":"30102101","amount":1.0,"unit":null,"itemId":790874,"isPacked":null,"packedUser":null,"packedTS":null},"790871":{"code":"222031","amount":1.0,"unit":null,"itemId":790871,"isPacked":null,"packedUser":null,"packedTS":null},"790886":{"code":"884","amount":1.0,"unit":null,"itemId":790886,"isPacked":null,"packedUser":null,"packedTS":null},"790883":{"code":"114","amount":1.0,"unit":null,"itemId":790883,"isPacked":null,"packedUser":null,"packedTS":null}}" -1 null 1 "webhook" ] |
|
2.08 ms (0.49%) |
1 |
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:
[ "1202604367" 312604 ] |
|
1.55 ms (0.37%) |
1 |
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
]
|
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. |
| App\Entity\ProductLog | No errors. |