Query Metrics

35 Database Queries
17 Different statements
9.09 ms Query time
0 Invalid entities
0 Managed entities

Queries

Group similar statements

# 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.