Query Metrics
510
Database Queries
11
Different statements
41.09 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
19.75 ms (48.06%) |
240 |
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:
[ 1726699507 "object_385\x01tags\x01" "class_1\x01tags\x01" ] |
17.90 ms (43.58%) |
240 |
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:
[ 1726699507 "object_385" ] |
1.57 ms (3.82%) |
21 |
SELECT * FROM retail_data WHERE store_id = ? and article_id = ?
Parameters:
[ 385 38859 ] |
0.90 ms (2.18%) |
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.24 ms (0.58%) |
1 |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
0.19 ms (0.47%) |
1 |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 3 ] |
0.12 ms (0.28%) |
1 |
SELECT * FROM object_relations_1 WHERE src_id = ?
Parameters:
[
385
]
|
0.11 ms (0.28%) |
1 |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
3
]
|
0.11 ms (0.26%) |
1 |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
3
]
|
0.11 ms (0.26%) |
1 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"1"
]
|
0.10 ms (0.23%) |
1 |
SELECT * FROM users_workspaces_asset 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.