Query Metrics
42
Database Queries
8
Different statements
11.47 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.53 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1731600319 [ "site_domain_4053839bf2d7a262051791adefb93936" ] ] |
2 | 0.32 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1731600319 [ "system_route_redirect" ] ] |
3 | 0.10 ms |
SELECT id FROM redirects WHERE active = 1 ORDER BY `priority` DESC
Parameters:
[] |
4 | 0.19 ms |
SELECT id FROM documents WHERE path = :path AND `key` = :key
Parameters:
[ "key" => "" "path" => "/" ] |
5 | 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:
[ 1731600319 [ "document_1" ] ] |
6 | 0.31 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1731600319 [ "document_properties_1" ] ] |
7 | 0.11 ms |
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[] |
8 | 0.11 ms |
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[] |
9 | 0.12 ms |
SELECT id FROM targeting_rules WHERE active = 1 ORDER BY `prio` ASC
Parameters:
[] |
10 | 0.13 ms |
SELECT * FROM targeting_rules WHERE id = ?
Parameters:
[
1
]
|
11 | 0.33 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1731600319 [ "document_target_groups_1" ] ] |
12 | 0.17 ms |
SELECT * FROM documents_elements WHERE documentId = ?
Parameters:
[
1
]
|
13 | 0.33 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1731600319 [ "document_15" ] ] |
14 | 0.39 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1731600319 [ "document_16" ] ] |
15 | 0.30 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1731600319 [ "document_17" ] ] |
16 | 0.32 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1731600319 [ "asset_4" ] ] |
17 | 0.12 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_4__e27ff8f714a1233717eb7ee1c21f1d7c"
]
|
18 | 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:
[ 1731600319 [ "document_3" ] ] |
19 | 0.33 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1731600319 [ "asset_5" ] ] |
20 | 0.12 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_5__cb2f938467a0e1094ca8108b3d0071f5"
]
|
21 | 0.33 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1731600319 [ "document_5" ] ] |
22 | 0.30 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1731600319 [ "asset_6" ] ] |
23 | 0.13 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_6__2f88815d62d8bd7a6d83a7441745fbaa"
]
|
24 | 0.40 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1731600319 [ "document_6" ] ] |
25 | 0.34 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1731600319 [ "document_20" ] ] |
26 | 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:
[ 1731600319 [ "document_19" ] ] |
27 | 0.34 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1731600319 [ "asset_55" ] ] |
28 | 0.16 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_55__2bfe5899e64cf7df754642238b2112f9"
]
|
29 | 0.29 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1731600319 [ "asset_27" ] ] |
30 | 0.42 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1731600319 [ "asset_19" ] ] |
31 | 0.13 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_19__548f6ab03f03970f7cde8bd796e9d246"
]
|
32 | 0.14 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_5__cb2f938467a0e1094ca8108b3d0071f5"
]
|
33 | 0.33 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1731600319 [ "document_target_groups_15" ] ] |
34 | 0.12 ms |
SELECT * FROM documents_elements WHERE documentId = ?
Parameters:
[
15
]
|
35 | 0.31 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1731600319 [ "document_properties_15" ] ] |
36 | 0.30 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1731600319 [ "asset_21" ] ] |
37 | 0.12 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_21__8f270ac64a4f196de7044f947d198756"
]
|
38 | 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:
[ 1731600319 [ "document_target_groups_16" ] ] |
39 | 0.13 ms |
SELECT * FROM documents_elements WHERE documentId = ?
Parameters:
[
16
]
|
40 | 0.88 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1731600319 [ "document_properties_16" ] ] |
41 | 0.38 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1731600319 [ "asset_20" ] ] |
42 | 0.13 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_20__d77828398cacc0dfb5988e911f3da784"
]
|
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.