Query Metrics
251
Database Queries
12
Different statements
34.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
28.38 ms (83.02%) |
227 |
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:
[ 1787151850 [ "\x00tags\x00object_2" "object_2" ] ] |
|
1.94 ms (5.68%) |
1 |
SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE objects.o_parentId = '2' AND CAST(objects.o_key AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE 'FTA920%' AND objects.o_type IN ('object','folder') ORDER BY CAST(objects.o_key AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci ASC LIMIT 100
Parameters:
[] |
|
0.93 ms (2.73%) |
1 |
SELECT COUNT(*) FROM objects WHERE objects.o_parentId = '2' AND CAST(objects.o_key AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE 'FTA920%' AND objects.o_type IN ('object','folder')
Parameters:
[] |
|
0.78 ms (2.29%) |
6 |
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:
[
"/products/FTA92000 Hit Single-lever tall basin mixer/%"
]
|
|
0.59 ms (1.72%) |
4 |
SELECT 1 FROM objects WHERE o_parentId = ? AND o_type IN ('object','folder') LIMIT 1
Parameters:
[
2
]
|
|
0.56 ms (1.65%) |
6 |
SELECT id FROM tree_locks WHERE id IN (1,2) AND type='object' AND locked = 'propagate' LIMIT 1
Parameters:
[] |
|
0.30 ms (0.86%) |
1 |
SELECT COUNT(*) AS count FROM objects o WHERE o_parentId = ?
Parameters:
[
2
]
|
|
0.29 ms (0.85%) |
1 |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 16 ] |
|
0.13 ms (0.39%) |
1 |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
16
]
|
|
0.10 ms (0.28%) |
1 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"35"
]
|
|
0.09 ms (0.27%) |
1 |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
16
]
|
|
0.09 ms (0.26%) |
1 |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
16
]
|
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.