Query Metrics
1642
Database Queries
11
Different statements
135.94 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
47.93 ms (35.26%) |
558 |
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:
[ 1726699498 "object_385\x01tags\x01" "class_1\x01tags\x01" ] |
43.90 ms (32.29%) |
558 |
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:
[ 1726699498 "object_385" ] |
23.54 ms (17.32%) |
339 |
SELECT * FROM retail_data WHERE store_id = ? and article_id = ?
Parameters:
[ 385 30254 ] |
19.63 ms (14.44%) |
180 |
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.27 ms (0.20%) |
1 |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
0.20 ms (0.15%) |
1 |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 3 ] |
0.12 ms (0.09%) |
1 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"1"
]
|
0.10 ms (0.07%) |
1 |
SELECT * FROM object_relations_1 WHERE src_id = ?
Parameters:
[
385
]
|
0.09 ms (0.07%) |
1 |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
3
]
|
0.09 ms (0.07%) |
1 |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
3
]
|
0.07 ms (0.05%) |
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.