Query Metrics
1679
Database Queries
11
Different statements
133.43 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
44.87 ms (33.63%) |
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:
[ 1726699477 "object_385\x01tags\x01" "class_1\x01tags\x01" ] |
41.78 ms (31.31%) |
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:
[ 1726699477 "object_385" ] |
25.88 ms (19.40%) |
376 |
SELECT * FROM retail_data WHERE store_id = ? and article_id = ?
Parameters:
[ 385 30254 ] |
19.83 ms (14.86%) |
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.26 ms (0.19%) |
1 |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
0.20 ms (0.15%) |
1 |
SELECT * FROM object_relations_1 WHERE src_id = ?
Parameters:
[
385
]
|
0.17 ms (0.13%) |
1 |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 3 ] |
0.12 ms (0.09%) |
1 |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
3
]
|
0.12 ms (0.09%) |
1 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"1"
]
|
0.11 ms (0.08%) |
1 |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
3
]
|
0.08 ms (0.06%) |
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.