Query Metrics

25 Database Queries
18 Different statements
44.75 ms Query time
0 Invalid entities
0 Managed entities

Queries

Group similar statements

# Time Info
1 0.35 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "maintenance_mode"
]
2 0.74 ms
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[
  "user"
  1
]
3 1.41 ms
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
  1
]
4 0.48 ms
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
  1
]
5 0.33 ms
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
  1
]
6 0.58 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_1365"
]
7 0.34 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_1365\x01tags\x01"
]
8 0.37 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  1365
]
9 4.63 ms
INSERT INTO lock_keys (key_id, key_token, key_expiration) VALUES (?, ?, UNIX_TIMESTAMP(NOW(6)) + 300)
Parameters:
[
  "ac95457e46ed21d770e2effa1d55c20c18e0d5b16f10b6e6040e49c2e9deb494"
  "kH2tb3bff/rBs5ezRc66LTR6nvS9ba5FvSZiyNSod0Q="
]
10 0.59 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
  "kH2tb3bff/rBs5ezRc66LTR6nvS9ba5FvSZiyNSod0Q="
  "ac95457e46ed21d770e2effa1d55c20c18e0d5b16f10b6e6040e49c2e9deb494"
  "kH2tb3bff/rBs5ezRc66LTR6nvS9ba5FvSZiyNSod0Q="
]
11 0.39 ms
SELECT 1 FROM lock_keys WHERE key_id = ? AND key_token = ? AND key_expiration > UNIX_TIMESTAMP(NOW(6))
Parameters:
[
  "ac95457e46ed21d770e2effa1d55c20c18e0d5b16f10b6e6040e49c2e9deb494"
  "kH2tb3bff/rBs5ezRc66LTR6nvS9ba5FvSZiyNSod0Q="
]
12 5.10 ms
UPDATE assets SET customSettings = ? WHERE id = ?
Parameters:
[
  "a:4:{s:8:"checksum";s:32:"3bd15dd3fd008caf341f1621f5342a6f";s:25:"imageDimensionsCalculated";b:1;s:10:"imageWidth";i:1500;s:11:"imageHeight";i:1500;}"
  1365
]
13 0.48 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.28 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.21 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.27 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.63 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\x06p\x1En\x08À\x1E\nj«ÁÙ"
]
18 5.43 ms
DELETE FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[
  "asset_1365\x01tags\x01"
  "asset_properties\x01tags\x01"
]
19 0.67 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_resource_columns_assets_image_thumbnail_cache"
]
20 0.40 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\x01tags\x01"
  "resource\x01tags\x01"
]
21 4.95 ms
INSERT INTO assets_image_thumbnail_cache (`cid`, `name`, `filename`, `modificationDate`, `filesize`, `width`, `height`) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1365
  "_auto_3894bfcb49d65df5523a6df9c6b35fbd"
  "CHPL179519_04.274e01ad.png"
  1789641177
  15124
  240
  240
]
22 0.49 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "_auto_3894bfcb49d65df5523a6df9c6b35fbd"
  "pimcore_image_thumbnails"
]
23 0.64 ms
DELETE FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_1365__fecfcbdb5563e9ffbca4d0062ce1c3f9"
]
24 10.12 ms
DELETE FROM lock_keys WHERE key_id = ? AND key_token = ?
Parameters:
[
  "ac95457e46ed21d770e2effa1d55c20c18e0d5b16f10b6e6040e49c2e9deb494"
  "kH2tb3bff/rBs5ezRc66LTR6nvS9ba5FvSZiyNSod0Q="
]
25 0.88 ms
SELECT 1 FROM lock_keys WHERE key_id = ? AND key_token = ? AND key_expiration > UNIX_TIMESTAMP(NOW(6))
Parameters:
[
  "ac95457e46ed21d770e2effa1d55c20c18e0d5b16f10b6e6040e49c2e9deb494"
  "kH2tb3bff/rBs5ezRc66LTR6nvS9ba5FvSZiyNSod0Q="
]

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.