Query Metrics
18
Database Queries
8
Different statements
6.14 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.34 ms (21.77%) |
1 |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 2 ] |
|
1.12 ms (18.31%) |
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 => 1765011481 ] |
|
0.94 ms (15.29%) |
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:
[ 1765011481 [ "\x00tags\x00appe58a9a4b536589bcbedd88e929a415e7c51f33a0" "appe58a9a4b536589bcbedd88e929a415e7c51f33a0" ] ] |
|
0.67 ms (10.94%) |
2 |
DELETE FROM cache_items WHERE item_id IN (?)
Parameters:
[
[
"appe58a9a4b536589bcbedd88e929a415e7c51f33a0"
"\x00tags\x00appe58a9a4b536589bcbedd88e929a415e7c51f33a0"
]
]
|
|
0.59 ms (9.67%) |
2 |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
2
]
|
|
0.51 ms (8.26%) |
2 |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
2
]
|
|
0.50 ms (8.11%) |
1 |
SELECT * FROM users WHERE `type` = ? AND `name` = ?
Parameters:
[ "user" "admin" ] |
|
0.47 ms (7.65%) |
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.