Query Metrics
15
Database Queries
11
Different statements
23.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
8.45 ms (36.62%) |
1 |
SELECT v0_.code AS code_0, v0_.weight AS weight_1 FROM `variant` v0_ WHERE v0_.name <> ?
Parameters:
[
"sklad"
]
|
|
2.45 ms (10.63%) |
3 |
"COMMIT"
Parameters:
[] |
|
2.03 ms (8.82%) |
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:
[ "1202601666" 312604 ] |
|
2.02 ms (8.76%) |
1 |
INSERT INTO `order` (code, email, eshop_id, createts, items, status, deleted, we_care, origin) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "1202601666" "vvelensky@seznam.cz" 312604 "2026-03-10 18:15:59" "{"748819":{"code":"2740","amount":1.0,"unit":null,"itemId":748819,"isPacked":null,"packedUser":null,"packedTS":null}}" -1 null 0 "webhook" ] |
|
2.00 ms (8.66%) |
3 |
"START TRANSACTION"
Parameters:
[] |
|
1.93 ms (8.35%) |
1 |
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:
[
"2740"
]
|
|
0.96 ms (4.17%) |
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
]
|
|
0.92 ms (3.99%) |
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:
[] |
|
0.85 ms (3.69%) |
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:
[
42449
]
|
|
0.73 ms (3.16%) |
1 |
INSERT INTO webhook (createts, event, event_instance, processed, eshop_id) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2026-03-10 18:15:58" "order:create" "1202601666" 0 1 ] |
|
0.73 ms (3.15%) |
1 |
UPDATE webhook SET processed = ? WHERE id = ?
Parameters:
[ 1 390285 ] |
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. |