Query Metrics
25
Database Queries
18
Different statements
37.21 ms
Query time
0
Invalid entities
0
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.53 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
| 2 | 0.69 ms |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 1 ] |
| 3 | 2.26 ms |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
1
]
|
| 4 | 0.42 ms |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
1
]
|
| 5 | 0.30 ms |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
1
]
|
| 6 | 0.53 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1789641177 "asset_1366" ] |
| 7 | 0.38 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1789641177 "asset_1366\x01tags\x01" ] |
| 8 | 0.39 ms |
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
1366
]
|
| 9 | 4.29 ms |
INSERT INTO lock_keys (key_id, key_token, key_expiration) VALUES (?, ?, UNIX_TIMESTAMP(NOW(6)) + 300)
Parameters:
[ "1cfd20975762f1999571323d317b0b972b9c96df9b5b609424d91f778abafc9f" "fYqNMy9XIh0TVl0VtnuWXzWs7KK5l9dlOt/1bp/dZoE=" ] |
| 10 | 0.56 ms |
UPDATE lock_keys SET key_expiration = UNIX_TIMESTAMP(NOW(6)) + ?, key_token = ? WHERE key_id = ? AND (key_token = ? OR key_expiration <= UNIX_TIMESTAMP(NOW(6)))
Parameters:
[ 300.0 "fYqNMy9XIh0TVl0VtnuWXzWs7KK5l9dlOt/1bp/dZoE=" "1cfd20975762f1999571323d317b0b972b9c96df9b5b609424d91f778abafc9f" "fYqNMy9XIh0TVl0VtnuWXzWs7KK5l9dlOt/1bp/dZoE=" ] |
| 11 | 0.44 ms |
SELECT 1 FROM lock_keys WHERE key_id = ? AND key_token = ? AND key_expiration > UNIX_TIMESTAMP(NOW(6))
Parameters:
[ "1cfd20975762f1999571323d317b0b972b9c96df9b5b609424d91f778abafc9f" "fYqNMy9XIh0TVl0VtnuWXzWs7KK5l9dlOt/1bp/dZoE=" ] |
| 12 | 4.38 ms |
UPDATE assets SET customSettings = ? WHERE id = ?
Parameters:
[ "a:4:{s:8:"checksum";s:32:"611c39cdb2ea8c90201c88376212f5b8";s:25:"imageDimensionsCalculated";b:1;s:10:"imageWidth";i:1500;s:11:"imageHeight";i:1500;}" 1366 ] |
| 13 | 0.46 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1789641177 "system_cache_write_lock" ] |
| 14 | 0.32 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1789641177 "\x00tags\x00system_cache_write_lock" ] |
| 15 | 0.22 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1789641177 "system_cache_write_lock" ] |
| 16 | 0.23 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1789641177 "\x00tags\x00system_cache_write_lock" ] |
| 17 | 4.93 ms |
INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time)
Parameters:
[ 2 => 30 3 => 1789641177 0 => "system_cache_write_lock" 1 => b"\x00\x00\x00\x02\x17\x01©\x14\x01\x11\x06q\x1En\x08À\x1E\nj«ÁÙ" ] |
| 18 | 4.42 ms |
DELETE FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[ "asset_1366\x01tags\x01" "asset_properties\x01tags\x01" ] |
| 19 | 0.49 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1789641178 "system_resource_columns_assets_image_thumbnail_cache" ] |
| 20 | 0.36 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[ 1789641178 "system\x01tags\x01" "resource\x01tags\x01" ] |
| 21 | 4.67 ms |
INSERT INTO assets_image_thumbnail_cache (`cid`, `name`, `filename`, `modificationDate`, `filesize`, `width`, `height`) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1366 "_auto_3894bfcb49d65df5523a6df9c6b35fbd" "CHPL179519_05.d946c4e1.png" 1789641178 82496 240 240 ] |
| 22 | 0.42 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "_auto_3894bfcb49d65df5523a6df9c6b35fbd" "pimcore_image_thumbnails" ] |
| 23 | 0.28 ms |
DELETE FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_1366__1af98a7e8514bf6aabfb1312df8da9ff"
]
|
| 24 | 4.85 ms |
DELETE FROM lock_keys WHERE key_id = ? AND key_token = ?
Parameters:
[ "1cfd20975762f1999571323d317b0b972b9c96df9b5b609424d91f778abafc9f" "fYqNMy9XIh0TVl0VtnuWXzWs7KK5l9dlOt/1bp/dZoE=" ] |
| 25 | 0.40 ms |
SELECT 1 FROM lock_keys WHERE key_id = ? AND key_token = ? AND key_expiration > UNIX_TIMESTAMP(NOW(6))
Parameters:
[ "1cfd20975762f1999571323d317b0b972b9c96df9b5b609424d91f778abafc9f" "fYqNMy9XIh0TVl0VtnuWXzWs7KK5l9dlOt/1bp/dZoE=" ] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
There are no configured entity managers.
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
No managed entities.
Entities Mapping
No mapped entities.