Query Metrics
24
Database Queries
8
Different statements
7.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
3.69 ms (52.12%) |
12 |
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:
[ 1789122427 [ "\x00tags\x00asset_86941" "asset_86941" ] ] |
|
0.73 ms (10.36%) |
2 |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 45 ] |
|
0.63 ms (8.85%) |
2 |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
45
]
|
|
0.56 ms (7.93%) |
2 |
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
"pimcore_perspectives"
]
|
|
0.45 ms (6.29%) |
2 |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
45
]
|
|
0.41 ms (5.80%) |
2 |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
45
]
|
|
0.37 ms (5.16%) |
1 |
SELECT `view` FROM users_workspaces_asset WHERE cid IN (1,17880,17878,17877,3,1,86941) AND userId IN (18,45) ORDER BY LENGTH(cpath) DESC, FIELD(userId, 45) DESC, `view` DESC LIMIT 1
Parameters:
[] |
|
0.25 ms (3.49%) |
1 |
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[ "id" => "web_to_print" "scope" => "pimcore_web_to_print" ] |
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.