Query Metrics
68
Database Queries
15
Different statements
38.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
11.67 ms (30.11%) |
4 |
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:
[ 1 => null 2 => null 3 => 300 4 => 1780342472 ] |
|
6.84 ms (17.65%) |
19 |
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:
[ 1780342472 [ "\x00tags\x00appb5003cab61b59631c83b2e65817e0bebe98e50d6" "appb5003cab61b59631c83b2e65817e0bebe98e50d6" ] ] |
|
5.62 ms (14.50%) |
2 |
DELETE FROM cache_items WHERE item_id IN (?)
Parameters:
[
[
"appb5003cab61b59631c83b2e65817e0bebe98e50d6"
"\x00tags\x00appb5003cab61b59631c83b2e65817e0bebe98e50d6"
]
]
|
|
3.68 ms (9.50%) |
10 |
SELECT tree_locks.id FROM tree_locks INNER JOIN assets ON tree_locks.id = assets.id WHERE assets.path LIKE ? AND tree_locks.type = 'asset' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1
Parameters:
[
"/custompuzzles/cp-products/kundenfotos/File\_000.jpeg/%"
]
|
|
2.84 ms (7.33%) |
10 |
SELECT id FROM tree_locks WHERE id IN (1,1679,1480,696) AND type='asset' AND locked = 'propagate' LIMIT 1
Parameters:
[] |
|
2.04 ms (5.26%) |
6 |
SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ?
Parameters:
[
1684
]
|
|
1.67 ms (4.31%) |
6 |
SELECT `a`.`id` FROM `assets` a WHERE parentId = ? LIMIT 1;
Parameters:
[
1679
]
|
|
0.83 ms (2.15%) |
2 |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
2
]
|
|
0.78 ms (2.00%) |
2 |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
2
]
|
|
0.66 ms (1.69%) |
1 |
SELECT assets.id, assets.type FROM assets WHERE (parentId = ?) ORDER BY FIELD(assets.type, 'folder') DESC, CAST(assets.filename AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci ASC LIMIT 100
Parameters:
[
1679
]
|
|
0.64 ms (1.64%) |
2 |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
2
]
|
|
0.53 ms (1.37%) |
1 |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 2 ] |
|
0.43 ms (1.11%) |
1 |
SELECT * FROM users WHERE `type` = ? AND `name` = ?
Parameters:
[ "user" "custompuzzles" ] |
|
0.29 ms (0.76%) |
1 |
SELECT COUNT(*) FROM assets WHERE (parentId = ?)
Parameters:
[
1679
]
|
|
0.24 ms (0.62%) |
1 |
SELECT COUNT(*) AS count FROM assets WHERE parentId = ?
Parameters:
[
1679
]
|
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.