Query Metrics
1021
Database Queries
7
Different statements
92.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
87.51 ms (95.13%) |
1011 |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters: [
0 => 1789219592,
1 => [
0 => object_28791
]
]
|
|
3.04 ms (3.31%) |
1 |
SELECT `objects`.* FROM `objects` WHERE (o_className = 'produkt' AND o_path LIKE '/kategorie/ajs-agd.pl/%' AND objects.o_type IN ('folder','object','variant'))
Parameters: []
|
|
0.37 ms (0.40%) |
1 |
SELECT id,type FROM users WHERE apiKey = ? AND type = ? AND active = 1 AND id > 0 AND `type` IN ('user','userfolder')
Parameters: [
0 => 567092043826218fb7627b6ac337b585d6ff26a46439375a55417d1e99b09b78,
1 => user
]
|
|
0.32 ms (0.34%) |
2 |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters: [0 => user, 1 => 17]
|
|
0.31 ms (0.34%) |
2 |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters: [0 => 17]
|
|
0.25 ms (0.27%) |
2 |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters: [0 => 17]
|
|
0.20 ms (0.21%) |
2 |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters: [0 => 17]
|
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.