Query Metrics
462
Database Queries
11
Different statements
36.21 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
17.77 ms (49.06%) |
224 |
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:
[ 1726699484 "object_385\x01tags\x01" "class_1\x01tags\x01" ] |
16.20 ms (44.74%) |
224 |
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:
[ 1726699484 "object_385" ] |
0.73 ms (2.03%) |
2 |
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:
[
1419
]
|
0.41 ms (1.12%) |
5 |
SELECT * FROM retail_data WHERE store_id = ? and article_id = ?
Parameters:
[ 385 42583 ] |
0.38 ms (1.04%) |
1 |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
0.17 ms (0.46%) |
1 |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 3 ] |
0.14 ms (0.40%) |
1 |
SELECT * FROM object_relations_1 WHERE src_id = ?
Parameters:
[
385
]
|
0.14 ms (0.39%) |
1 |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
3
]
|
0.12 ms (0.34%) |
1 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"1"
]
|
0.08 ms (0.21%) |
1 |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
3
]
|
0.07 ms (0.20%) |
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.