Query Metrics
35
Database Queries
17
Different statements
9.09 ms
Query time
0
Invalid entities
0
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.33 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
| 2 | 0.45 ms |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 1 ] |
| 3 | 0.29 ms |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
1
]
|
| 4 | 0.24 ms |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
1
]
|
| 5 | 0.24 ms |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
1
]
|
| 6 | 0.39 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:
[ 1789641174 "object_906" ] |
| 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:
[ 1789641174 "object_906\x01tags\x01" "class_6\x01tags\x01" "asset_297\x01tags\x01" "asset_298\x01tags\x01" "asset_299\x01tags\x01" "asset_300\x01tags\x01" "asset_301\x01tags\x01" "asset_302\x01tags\x01" "asset_303\x01tags\x01" ] |
| 8 | 0.21 ms |
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
Parameters:
[
906
]
|
| 9 | 0.33 ms |
SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ?
Parameters:
[
906
]
|
| 10 | 0.48 ms |
SELECT * FROM object_store_6 WHERE oo_id = ? FOR UPDATE
Parameters:
[
906
]
|
| 11 | 0.19 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"6"
]
|
| 12 | 0.29 ms |
select `image_gallery` from object_store_6 where oo_id = 906
Parameters:
[] |
| 13 | 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:
[ 1789641174 "asset_303" ] |
| 14 | 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:
[ 1789641174 "asset_297" ] |
| 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:
[ 1789641174 "asset_298" ] |
| 16 | 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:
[ 1789641174 "asset_299" ] |
| 17 | 0.19 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:
[ 1789641174 "asset_300" ] |
| 18 | 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:
[ 1789641174 "asset_301" ] |
| 19 | 0.19 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:
[ 1789641174 "asset_302" ] |
| 20 | 0.21 ms |
select `video_gallery` from object_store_6 where oo_id = 906
Parameters:
[] |
| 21 | 0.32 ms |
SELECT * FROM object_relations_6 WHERE src_id = ?
Parameters:
[
906
]
|
| 22 | 0.25 ms |
SELECT id FROM schedule_tasks WHERE `cid` = ? AND `ctype` = ?
Parameters:
[ 906 "object" ] |
| 23 | 0.41 ms |
SELECT id FROM versions WHERE cid = ? AND ctype = ? AND (autoSave=0 OR (autoSave=1 AND userId = ?)) ORDER BY `date` ASC
Parameters:
[ 906 "object" 1 ] |
| 24 | 0.23 ms |
SELECT * FROM versions WHERE id = ?
Parameters:
[
1735
]
|
| 25 | 0.21 ms |
SELECT * FROM versions WHERE id = ?
Parameters:
[
1736
]
|
| 26 | 0.19 ms |
SELECT * FROM versions WHERE id = ?
Parameters:
[
2598
]
|
| 27 | 0.25 ms |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 0 ] |
| 28 | 0.22 ms |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
0
]
|
| 29 | 0.20 ms |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
0
]
|
| 30 | 0.22 ms |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
0
]
|
| 31 | 0.26 ms |
SELECT * FROM versions WHERE id = ?
Parameters:
[
4207
]
|
| 32 | 0.21 ms |
SELECT * FROM versions WHERE id = ?
Parameters:
[
7342
]
|
| 33 | 0.21 ms |
SELECT * FROM versions WHERE id = ?
Parameters:
[
7605
]
|
| 34 | 0.21 ms |
SELECT * FROM versions WHERE id = ?
Parameters:
[
7770
]
|
| 35 | 0.19 ms |
SELECT * FROM versions WHERE id = ?
Parameters:
[
8286
]
|
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.