Query Metrics
57
Database Queries
12
Different statements
8.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2.51 ms (31.35%) |
18 |
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:
[ 1791369346 [ "\x00tags\x00object_11" "object_11" ] ] |
|
1.68 ms (21.05%) |
12 |
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:
[
"/productTypes/mixers/basinMixers/%"
]
|
|
1.17 ms (14.65%) |
7 |
SELECT 1 FROM objects WHERE o_parentId = ? AND o_type IN ('object','folder') LIMIT 1
Parameters:
[
11
]
|
|
1.15 ms (14.43%) |
12 |
SELECT id FROM tree_locks WHERE id IN (1,11,10) AND type='object' AND locked = 'propagate' LIMIT 1
Parameters:
[] |
|
0.34 ms (4.22%) |
1 |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 15 ] |
|
0.26 ms (3.30%) |
1 |
SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE objects.o_parentId = '11' AND objects.o_type IN ('object','folder') ORDER BY CAST(objects.o_key AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci ASC LIMIT 50
Parameters:
[] |
|
0.25 ms (3.10%) |
1 |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
15
]
|
|
0.22 ms (2.70%) |
1 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"PROD_TYPE"
]
|
|
0.12 ms (1.54%) |
1 |
SELECT COUNT(*) FROM objects WHERE objects.o_parentId = '11' AND objects.o_type IN ('object','folder')
Parameters:
[] |
|
0.10 ms (1.30%) |
1 |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
15
]
|
|
0.10 ms (1.20%) |
1 |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
15
]
|
|
0.09 ms (1.16%) |
1 |
SELECT COUNT(*) AS count FROM objects o WHERE o_parentId = ?
Parameters:
[
11
]
|
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.