Query Metrics
14
Database Queries
8
Different statements
18.65 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.82 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.50 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.64 ms |
"START TRANSACTION"
Parameters:
[] |
| 4 | 6.07 ms |
INSERT INTO webhook (createts, event, event_instance, processed, eshop_id) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2026-03-10 00:00:05" "stock:movement" "1" 0 1 ] |
| 5 | 1.25 ms |
"COMMIT"
Parameters:
[] |
| 6 | 0.82 ms |
"START TRANSACTION"
Parameters:
[] |
| 7 | 1.26 ms |
UPDATE eshop SET locked = ?, editts = ? WHERE id = ?
Parameters:
[ 1 "2026-03-10 00:00:06" 1 ] |
| 8 | 0.89 ms |
"COMMIT"
Parameters:
[] |
| 9 | 0.75 ms |
"START TRANSACTION"
Parameters:
[] |
| 10 | 0.89 ms |
UPDATE eshop SET last_stock_movement = ?, locked = ?, editts = ? WHERE id = ?
Parameters:
[ 1025668 0 "2026-03-10 00:00:06" 1 ] |
| 11 | 0.58 ms |
"COMMIT"
Parameters:
[] |
| 12 | 0.55 ms |
"START TRANSACTION"
Parameters:
[] |
| 13 | 0.80 ms |
UPDATE webhook SET processed = ? WHERE id = ?
Parameters:
[ 1 389817 ] |
| 14 | 0.82 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. |