Query Metrics
158
Database Queries
10
Different statements
53.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
20.16 ms (37.67%) |
60 |
SELECT tree_locks.id FROM tree_locks INNER JOIN objects ON tree_locks.id = objects.o_id WHERE objects.o_path LIKE ? AND tree_locks.type = 'object' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1
Parameters:
[
"/VehiclePrices/1CCESYUKA1Y0FK50/%"
]
|
|
16.89 ms (31.56%) |
60 |
SELECT id FROM tree_locks WHERE id IN (1,28) AND type='object' AND locked = 'propagate' LIMIT 1
Parameters:
[] |
|
13.13 ms (24.54%) |
31 |
SELECT 1 FROM objects WHERE o_parentId = ? AND o_type IN ('object','folder') LIMIT 1
Parameters:
[
28
]
|
|
0.82 ms (1.53%) |
1 |
SELECT COUNT(*) AS `totalCount` FROM `objects` WHERE (objects.o_parentId = '28' AND objects.o_type IN ('object','folder'))
Parameters:
[] |
|
0.75 ms (1.40%) |
1 |
SELECT objects.o_id as o_id, `objects`.`o_type` FROM `objects` WHERE (objects.o_parentId = '28' AND objects.o_type IN ('object','folder')) ORDER BY CAST(objects.o_key AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci ASC LIMIT 30
Parameters:
[] |
|
0.45 ms (0.84%) |
1 |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 2 ] |
|
0.40 ms (0.75%) |
1 |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
2
]
|
|
0.33 ms (0.61%) |
1 |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
2
]
|
|
0.29 ms (0.55%) |
1 |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
2
]
|
|
0.29 ms (0.54%) |
1 |
SELECT COUNT(*) AS count FROM objects o WHERE o_parentId = ?
Parameters:
[
28
]
|
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.