Query Metrics

32 Database Queries
28 Different statements
3.46 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
0.32 ms
(9.26%)
4
SELECT * FROM versions WHERE id = ?
Parameters:
[
  285515
]
0.31 ms
(9.06%)
2
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:
[
  1791364281
  [
    "\x00tags\x00object_3244"
    "object_3244"
  ]
]
0.23 ms
(6.54%)
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.21 ms
(6.14%)
1
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[
  "user"
  16
]
0.21 ms
(6.05%)
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 => 1791364281
  1 => "object_3244\x00tags\x00"
  2 => b"\x00\x00\x00\x02 oij¨ÿ/\x7F2"
]
0.20 ms
(5.81%)
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.13 ms
(3.76%)
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
(3.47%)
1
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
  16
]
0.12 ms
(3.44%)
1
SELECT * FROM object_classificationstore_groups_35 WHERE o_id = '3244' AND fieldname = 'categoryParameters'
Parameters:
[]
0.11 ms
(3.24%)
1
SELECT id FROM schedule_tasks WHERE `cid` = ? AND `ctype` = ?
Parameters:
[
  3244
  "object"
]
0.11 ms
(3.21%)
1
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "35"
]
0.11 ms
(3.18%)
1
SELECT * FROM object_store_35 WHERE oo_id = ?
Parameters:
[
  3244
]
0.11 ms
(3.18%)
1
SELECT * FROM object_relations_35 WHERE src_id = ?
Parameters:
[
  3244
]
0.11 ms
(3.04%)
1
SELECT * FROM object_classificationstore_data_35 WHERE o_id = '3244' AND fieldname = 'categoryParameters'
Parameters:
[]
0.10 ms
(2.90%)
1
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
  3244
]
0.09 ms
(2.72%)
1
select `highlights` from object_localized_data_35 where language = 'da' and  ooo_id  = 3244
Parameters:
[]
0.09 ms
(2.72%)
1
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
  16
]
0.09 ms
(2.52%)
1
SELECT * FROM object_classificationstore_groups_35 WHERE o_id = '3244' AND fieldname = 'categoryProperties'
Parameters:
[]
0.09 ms
(2.51%)
1
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
  16
]
0.08 ms
(2.43%)
1
SELECT * FROM object_classificationstore_data_35 WHERE o_id = '3244' AND fieldname = 'categoryProperties'
Parameters:
[]
0.07 ms
(2.08%)
1
select `highlights` from object_localized_data_35 where language = 'de' and  ooo_id  = 3244
Parameters:
[]
0.07 ms
(1.91%)
1
select `highlights` from object_localized_data_35 where language = 'en' and  ooo_id  = 3244
Parameters:
[]
0.07 ms
(1.91%)
1
select `highlights` from object_localized_data_35 where language = 'nl' and  ooo_id  = 3244
Parameters:
[]
0.06 ms
(1.79%)
1
select `highlights` from object_localized_data_35 where language = 'fr' and  ooo_id  = 3244
Parameters:
[]
0.06 ms
(1.79%)
1
select `highlights` from object_localized_data_35 where language = 'ro' and  ooo_id  = 3244
Parameters:
[]
0.06 ms
(1.79%)
1
select `highlights` from object_localized_data_35 where language = 'ru' and  ooo_id  = 3244
Parameters:
[]
0.06 ms
(1.77%)
1
select `highlights` from object_localized_data_35 where language = 'it' and  ooo_id  = 3244
Parameters:
[]
0.06 ms
(1.77%)
1
select `highlights` from object_localized_data_35 where language = 'uk' 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.