Query Metrics
47
Database Queries
28
Different statements
5.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.68 ms (32.56%) |
14 |
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:
[ 1791364643 [ "\x00tags\x00object_3244" "object_3244" ] ] |
|
0.54 ms (10.48%) |
7 |
SELECT * FROM versions WHERE id = ?
Parameters:
[
285515
]
|
|
0.24 ms (4.59%) |
1 |
SELECT id FROM versions WHERE cid = ? AND ctype = ? AND (autoSave=0 OR (autoSave=1 AND userId = ?)) ORDER BY `date` ASC
Parameters:
[ 3244 "object" 16 ] |
|
0.23 ms (4.49%) |
1 |
SELECT * FROM object_localized_data_35 WHERE ooo_id = ? AND language IN ('en','de','fr','it','da','ro','nl','uk','ru')
Parameters:
[
3244
]
|
|
0.22 ms (4.32%) |
1 |
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:
[ 3 => null 4 => 1791364643 1 => "object_3244\x00tags\x00" 2 => b"\x00\x00\x00\x02!^\x7F˜"ïÌu/" ] |
|
0.21 ms (4.07%) |
1 |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 16 ] |
|
0.14 ms (2.73%) |
1 |
SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ?
Parameters:
[
3244
]
|
|
0.12 ms (2.42%) |
1 |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
16
]
|
|
0.12 ms (2.24%) |
1 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"35"
]
|
|
0.11 ms (2.23%) |
1 |
SELECT * FROM object_classificationstore_groups_35 WHERE o_id = '3244' AND fieldname = 'categoryParameters'
Parameters:
[] |
|
0.11 ms (2.13%) |
1 |
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
3244
]
|
|
0.11 ms (2.11%) |
1 |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
16
]
|
|
0.11 ms (2.11%) |
1 |
SELECT * FROM object_store_35 WHERE oo_id = ?
Parameters:
[
3244
]
|
|
0.11 ms (2.11%) |
1 |
SELECT * FROM object_relations_35 WHERE src_id = ?
Parameters:
[
3244
]
|
|
0.11 ms (2.05%) |
1 |
SELECT id FROM schedule_tasks WHERE `cid` = ? AND `ctype` = ?
Parameters:
[ 3244 "object" ] |
|
0.10 ms (1.97%) |
1 |
SELECT * FROM object_classificationstore_data_35 WHERE o_id = '3244' AND fieldname = 'categoryParameters'
Parameters:
[] |
|
0.10 ms (1.86%) |
1 |
select `highlights` from object_localized_data_35 where language = 'da' and ooo_id = 3244
Parameters:
[] |
|
0.09 ms (1.84%) |
1 |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
16
]
|
|
0.09 ms (1.67%) |
1 |
SELECT * FROM object_classificationstore_groups_35 WHERE o_id = '3244' AND fieldname = 'categoryProperties'
Parameters:
[] |
|
0.08 ms (1.64%) |
1 |
SELECT * FROM object_classificationstore_data_35 WHERE o_id = '3244' AND fieldname = 'categoryProperties'
Parameters:
[] |
|
0.07 ms (1.45%) |
1 |
select `highlights` from object_localized_data_35 where language = 'de' and ooo_id = 3244
Parameters:
[] |
|
0.07 ms (1.41%) |
1 |
select `highlights` from object_localized_data_35 where language = 'en' and ooo_id = 3244
Parameters:
[] |
|
0.07 ms (1.32%) |
1 |
select `highlights` from object_localized_data_35 where language = 'fr' and ooo_id = 3244
Parameters:
[] |
|
0.07 ms (1.26%) |
1 |
select `highlights` from object_localized_data_35 where language = 'uk' and ooo_id = 3244
Parameters:
[] |
|
0.06 ms (1.26%) |
1 |
select `highlights` from object_localized_data_35 where language = 'nl' and ooo_id = 3244
Parameters:
[] |
|
0.06 ms (1.24%) |
1 |
select `highlights` from object_localized_data_35 where language = 'it' and ooo_id = 3244
Parameters:
[] |
|
0.06 ms (1.22%) |
1 |
select `highlights` from object_localized_data_35 where language = 'ro' and ooo_id = 3244
Parameters:
[] |
|
0.06 ms (1.22%) |
1 |
select `highlights` from object_localized_data_35 where language = 'ru' and ooo_id = 3244
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
No loaded entities.