https://cessda.openconcept.no/admin/folder/get-data-by-id?_dc=1738818838350&id=169

Query Metrics

24 Database Queries
12 Different statements
3.15 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.32 ms
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[
  "user"
  2
]
2 0.15 ms
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
  2
]
3 0.10 ms
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
  2
]
4 0.16 ms
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
  2
]
5 0.22 ms
SELECT tree_locks.id FROM tree_locks
            INNER JOIN documents ON tree_locks.id = documents.id
                WHERE documents.path LIKE ? AND tree_locks.type = 'document' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1
Parameters:
[
  "/Subsites/%"
]
6 0.14 ms
SELECT id FROM tree_locks WHERE id IN (1) AND type='document' AND locked = 'propagate' LIMIT 1
Parameters:
[]
7 0.10 ms
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  169
]
8 0.16 ms
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  169
  169
  169
]
9 0.09 ms
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  169
]
10 0.15 ms
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  169
  169
  169
]
11 0.18 ms
SELECT * FROM properties WHERE ((cid IN (1) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  169
]
12 0.12 ms
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_predefined_properties"
]
13 0.15 ms
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_predefined_properties"
]
14 0.10 ms
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_predefined_properties"
]
15 0.09 ms
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_predefined_properties"
]
16 0.09 ms
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_predefined_properties"
]
17 0.09 ms
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_predefined_properties"
]
18 0.10 ms
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_predefined_properties"
]
19 0.10 ms
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_predefined_properties"
]
20 0.10 ms
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_predefined_properties"
]
21 0.09 ms
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_predefined_properties"
]
22 0.13 ms
SELECT documents.*, tree_locks.locked FROM documents
            LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document'
                WHERE documents.id = ?
Parameters:
[
  169
]
23 0.11 ms
SELECT documents.*, tree_locks.locked FROM documents
            LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document'
                WHERE documents.id = ?
Parameters:
[
  169
]
24 0.11 ms
SELECT id FROM documents d WHERE parentId = ?  LIMIT 1
Parameters:
[
  169
]

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.