Query Metrics
499
Database Queries
17
Different statements
39.78 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
9.90 ms (24.87%) |
141 |
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:
[ 1726699464 "object_385" ] |
5.83 ms (14.66%) |
69 |
SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ?
Parameters:
[
6415
]
|
4.26 ms (10.72%) |
69 |
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
Parameters:
[
6415
]
|
3.79 ms (9.54%) |
25 |
SELECT objects.id as id, objects.type as `type` FROM objects WHERE parentId = ? AND objects.type IN ('object','variant','folder') ORDER BY `key` ASC
Parameters:
[
829
]
|
3.57 ms (8.96%) |
24 |
SELECT * FROM object_store_4 WHERE oo_id = ?
Parameters:
[
6415
]
|
3.21 ms (8.08%) |
45 |
SELECT * FROM object_relations_7 WHERE src_id = ?
Parameters:
[
30952
]
|
3.20 ms (8.03%) |
45 |
SELECT * FROM retail_data WHERE store_id = ? and article_id = ?
Parameters:
[ 385 30952 ] |
2.97 ms (7.47%) |
45 |
SELECT * FROM object_store_7 WHERE oo_id = ?
Parameters:
[
30952
]
|
1.70 ms (4.27%) |
24 |
SELECT * FROM object_relations_4 WHERE src_id = ?
Parameters:
[
6415
]
|
0.39 ms (0.98%) |
1 |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
0.28 ms (0.70%) |
3 |
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:
[ 1726699464 "object_385\x01tags\x01" "class_1\x01tags\x01" ] |
0.19 ms (0.48%) |
3 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"1"
]
|
0.14 ms (0.36%) |
1 |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 3 ] |
0.11 ms (0.28%) |
1 |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
3
]
|
0.09 ms (0.23%) |
1 |
SELECT * FROM object_relations_1 WHERE src_id = ?
Parameters:
[
385
]
|
0.07 ms (0.18%) |
1 |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
3
]
|
0.07 ms (0.17%) |
1 |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
3
]
|
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.
Entities Mapping
No mapped entities.