Query Metrics

43 Database Queries
19 Different statements
23.97 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.19 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "maintenance_mode"
]
2 0.73 ms
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[
  "user"
  4
]
3 0.42 ms
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
  4
]
4 0.42 ms
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
  4
]
5 0.53 ms
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
  4
]
6 3.82 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:
[
  1753879551
  "object_98334"
]
7 0.70 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "product"
]
8 10.03 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:
[
  1753879551
  "object_98334\x01tags\x01"
  "class_product\x01tags\x01"
  "asset_173515\x01tags\x01"
  "asset_173516\x01tags\x01"
  "asset_173517\x01tags\x01"
  "asset_173518\x01tags\x01"
  "asset_173519\x01tags\x01"
  "asset_173520\x01tags\x01"
]
9 0.30 ms
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
Parameters:
[
  98334
]
10 0.20 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:
[
  98334
]
11 0.18 ms
SELECT * FROM object_store_product WHERE oo_id = ?
Parameters:
[
  98334
]
12 0.25 ms
SELECT * FROM object_localized_data_product WHERE ooo_id = ? AND language IN ('en','ru','uz','pl','sr','az')
Parameters:
[
  98334
]
13 0.13 ms
select `folder_360_block` from object_store_product where oo_id  = 98334
Parameters:
[]
14 0.18 ms
SELECT * FROM object_classificationstore_groups_product WHERE id = 98334 AND fieldname = 'catalog_properties_translatable'
Parameters:
[]
15 0.21 ms
SELECT * FROM object_classificationstore_data_product WHERE id = 98334 AND fieldname = 'catalog_properties_translatable'
Parameters:
[]
16 0.18 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:
[
  1753879551
  "cs_keyconfig_144"
]
17 0.17 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:
[
  1753879551
  "cs_keyconfig_145"
]
18 0.12 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:
[
  1753879551
  "cs_keyconfig_146"
]
19 0.11 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:
[
  1753879551
  "cs_keyconfig_147"
]
20 0.11 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:
[
  1753879551
  "cs_keyconfig_148"
]
21 0.12 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:
[
  1753879551
  "cs_keyconfig_149"
]
22 0.11 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:
[
  1753879551
  "cs_keyconfig_150"
]
23 0.10 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:
[
  1753879551
  "cs_keyconfig_152"
]
24 0.10 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:
[
  1753879551
  "cs_keyconfig_154"
]
25 0.10 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:
[
  1753879551
  "cs_keyconfig_155"
]
26 0.10 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:
[
  1753879551
  "cs_keyconfig_156"
]
27 0.10 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:
[
  1753879551
  "cs_keyconfig_157"
]
28 0.10 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:
[
  1753879551
  "cs_keyconfig_159"
]
29 0.11 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:
[
  1753879551
  "cs_keyconfig_160"
]
30 0.10 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:
[
  1753879551
  "cs_keyconfig_167"
]
31 0.11 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:
[
  1753879551
  "asset_173515"
]
32 0.15 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:
[
  1753879551
  "asset_173516"
]
33 0.11 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:
[
  1753879551
  "asset_173517"
]
34 0.12 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:
[
  1753879551
  "asset_173518"
]
35 0.11 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:
[
  1753879551
  "asset_173519"
]
36 0.10 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:
[
  1753879551
  "asset_173520"
]
37 0.18 ms
SELECT * FROM object_relations_product WHERE src_id = ?
Parameters:
[
  98334
]
38 2.05 ms
SELECT id FROM schedule_tasks WHERE `cid` = ? AND `ctype` = ?
Parameters:
[
  98334
  "object"
]
39 0.40 ms
SELECT id FROM versions WHERE cid = ? AND ctype = ? AND (autoSave=0 OR (autoSave=1 AND userId = ?))   ORDER BY `date` ASC
Parameters:
[
  98334
  "object"
  4
]
40 0.19 ms
SELECT * FROM versions WHERE id = ?
Parameters:
[
  899313
]
41 0.13 ms
SELECT * FROM versions WHERE id = ?
Parameters:
[
  899316
]
42 0.14 ms
SELECT * FROM versions WHERE id = ?
Parameters:
[
  899324
]
43 0.16 ms
SELECT * FROM versions WHERE id = ?
Parameters:
[
  899325
]

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.

Entities Mapping

No mapped entities.