Query Metrics

1021 Database Queries
7 Different statements
92.00 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

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.

Entities Mapping