Query Metrics
11
Database Queries
9
Different statements
22.65 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.71 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 | 1.31 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.60 ms |
"START TRANSACTION"
Parameters:
[] |
| 4 | 3.97 ms |
INSERT INTO webhook (createts, event, event_instance, processed, eshop_id) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2026-01-10 09:42:19" "order:update" "1202600208" 0 1 ] |
| 5 | 0.66 ms |
"COMMIT"
Parameters:
[] |
| 6 | 8.89 ms |
SELECT v0_.code AS code_0, v0_.weight AS weight_1 FROM `variant` v0_ WHERE v0_.name <> ?
Parameters:
[
"sklad"
]
|
| 7 | 2.84 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:
[ "1202600208" 312604 ] |
| 8 | 0.80 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:
[
39561
]
|
| 9 | 0.55 ms |
"START TRANSACTION"
Parameters:
[] |
| 10 | 0.70 ms |
UPDATE webhook SET processed = ? WHERE id = ?
Parameters:
[ 1 362991 ] |
| 11 | 0.60 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. |