Query Metrics
18
Database Queries
8
Different statements
236.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
140.79 ms (59.47%) |
4 |
INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time)
Parameters:
[ 1 => null 2 => null 3 => 300 4 => 1765017006 ] |
|
29.09 ms (12.29%) |
2 |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
2
]
|
|
25.48 ms (10.76%) |
2 |
DELETE FROM cache_items WHERE item_id IN (?)
Parameters:
[
[
"appe58a9a4b536589bcbedd88e929a415e7c51f33a0"
"\x00tags\x00appe58a9a4b536589bcbedd88e929a415e7c51f33a0"
]
]
|
|
16.10 ms (6.80%) |
4 |
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:
[ 1765017006 [ "\x00tags\x00appe58a9a4b536589bcbedd88e929a415e7c51f33a0" "appe58a9a4b536589bcbedd88e929a415e7c51f33a0" ] ] |
|
8.84 ms (3.73%) |
2 |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
2
]
|
|
6.56 ms (2.77%) |
1 |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 2 ] |
|
5.27 ms (2.23%) |
1 |
SELECT * FROM users WHERE `type` = ? AND `name` = ?
Parameters:
[ "user" "admin" ] |
|
4.62 ms (1.95%) |
2 |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
2
]
|
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.