http://www.andreas-lechner.de/

Query Metrics

7 Database Queries
4 Different statements
1.45 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.35 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters: [ 0 => 1735063655, 1 => [ 0 => site_domain_fdffc7609ad26d129ee38b965c559d92 ] ]
2 0.17 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters: [ 0 => 1735063655, 1 => [ 0 => system_route_redirect ] ]
3 0.20 ms
SELECT id FROM redirects WHERE active = 1  ORDER BY `priority` DESC
Parameters: []
4 0.21 ms
SELECT id FROM documents WHERE path = :path AND `key` = :key
Parameters: [path => /, key => ]
5 0.17 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters: [ 0 => 1735063655, 1 => [ 0 => document_1 ] ]
6 0.17 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters: [ 0 => 1735063655, 1 => [ 0 => document_properties_1 ] ]
7 0.19 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.

Entities Mapping