Query Metrics
24
Database Queries
12
Different statements
3.15 ms
Query time
0
Invalid entities
Queries
#▲ | 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.