Query Metrics
9
Database Queries
6
Different statements
3.49 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.52 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters: [
0 => 1720062853,
1 => [
0 => site_domain_28cef033364ee98573e3e496f0cf4b8a
]
]
|
2 | 0.61 ms |
SELECT * FROM sites WHERE mainDomain = ? OR domains LIKE ?
Parameters: [0 => 176.197.82.110, 1 => %"176.197.82.110"%]
|
3 | 0.23 ms |
SELECT id,domains FROM sites
Parameters: []
|
4 | 0.36 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters: [
0 => 1720062853,
1 => [
0 => system_route_redirect
]
]
|
5 | 0.37 ms |
SELECT id FROM redirects WHERE active = 1 ORDER BY `priority` DESC
Parameters: []
|
6 | 0.36 ms |
SELECT id FROM documents WHERE path = :path AND `key` = :key
Parameters: [path => /, key => ]
|
7 | 0.37 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters: [
0 => 1720062853,
1 => [
0 => document_1
]
]
|
8 | 0.36 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters: [
0 => 1720062853,
1 => [
0 => document_properties_1
]
]
|
9 | 0.32 ms |
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters: []
|
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.