http://35.240.203.237/

Query Metrics

74 Database Queries
9 Different statements
21.97 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.59 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1727515809
  [
    "site_domain_ae1b066afb59cf3581f80a1ae42e3633"
  ]
]
2 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:
[
  1727515809
  [
    "system_route_redirect"
  ]
]
3 0.36 ms
SELECT id FROM documents WHERE path = :path AND `key` = :key
Parameters:
[
  "key" => ""
  "path" => "/"
]
4 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:
[
  1727515809
  [
    "document_1"
  ]
]
5 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:
[
  1727515809
  [
    "document_properties_1"
  ]
]
6 0.47 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1727515809
  [
    "document_3"
  ]
]
7 0.43 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1727515809
  [
    "nav_4a57aec04fcb333d8e81bd07bd1831ad"
  ]
]
8 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:
[
  1727515809
  [
    "translation_data_messages_en_PH"
  ]
]
9 0.35 ms
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  1
]
10 0.42 ms
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  1
  1
  1
]
11 0.27 ms
SELECT id FROM documents WHERE path = :path AND `key` = :key
Parameters:
[
  "key" => "en_PH"
  "path" => "/"
]
12 0.26 ms
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/en_PH"
]
13 0.40 ms
SELECT * FROM documents_elements WHERE documentId = ?
Parameters:
[
  1
]
14 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:
[
  1727515809
  [
    "object_58"
  ]
]
15 0.25 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "CAR"
]
16 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:
[
  1727515809
  [
    "object_114"
  ]
]
17 0.27 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1727515809
  [
    "object_30"
  ]
]
18 0.26 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1727515809
  [
    "object_110"
  ]
]
19 0.26 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1727515809
  [
    "document_33"
  ]
]
20 0.25 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1727515809
  [
    "document_35"
  ]
]
21 0.28 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1727515809
  [
    "asset_337"
  ]
]
22 0.28 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1727515809
  [
    "document_45"
  ]
]
23 0.26 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1727515809
  [
    "asset_3"
  ]
]
24 0.33 ms
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
Parameters:
[
  3
]
25 0.26 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1727515809
  [
    "document_46"
  ]
]
26 0.25 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1727515809
  [
    "asset_319"
  ]
]
27 0.27 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1727515809
  [
    "document_47"
  ]
]
28 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:
[
  1727515809
  [
    "document_properties_33"
  ]
]
29 0.36 ms
SELECT * FROM documents_elements WHERE documentId = ?
Parameters:
[
  33
]
30 0.27 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1727515809
  [
    "asset_317"
  ]
]
31 0.27 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1727515809
  [
    "document_74"
  ]
]
32 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:
[
  1727515809
  [
    "asset_361"
  ]
]
33 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:
[
  1727515809
  [
    "document_65"
  ]
]
34 0.28 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1727515809
  [
    "document_properties_35"
  ]
]
35 0.32 ms
SELECT * FROM documents_elements WHERE documentId = ?
Parameters:
[
  35
]
36 0.26 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1727515809
  [
    "asset_339"
  ]
]
37 0.27 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1727515809
  [
    "document_54"
  ]
]
38 0.28 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1727515809
  [
    "document_55"
  ]
]
39 0.27 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1727515809
  [
    "asset_320"
  ]
]
40 0.27 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1727515809
  [
    "document_57"
  ]
]
41 0.27 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1727515809
  [
    "asset_318"
  ]
]
42 0.26 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1727515809
  [
    "document_56"
  ]
]
43 0.26 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1727515809
  [
    "asset_321"
  ]
]
44 0.47 ms
SELECT * FROM object_relations_CAR WHERE src_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[
  58
  "manufacturer"
]
45 0.27 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1727515809
  [
    "object_55"
  ]
]
46 0.33 ms
SELECT * FROM object_relations_CAR WHERE src_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[
  55
  "manufacturer"
]
47 0.26 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1727515809
  [
    "object_46"
  ]
]
48 0.26 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1727515809
  [
    "object_2"
  ]
]
49 0.25 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1727515809
  [
    "object_744"
  ]
]
50 0.25 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1727515809
  [
    "object_1"
  ]
]
51 0.37 ms
SELECT * FROM object_relations_CAR WHERE src_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[
  58
  "categories"
]
52 0.30 ms
SELECT * FROM object_relations_CAR WHERE src_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[
  55
  "categories"
]
53 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:
[
  1727515809
  [
    "document_12"
  ]
]
54 0.28 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1727515809
  [
    "document_properties_12"
  ]
]
55 0.39 ms
SELECT * FROM documents_elements WHERE documentId = ?
Parameters:
[
  12
]
56 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:
[
  1727515809
  [
    "document_97"
  ]
]
57 0.27 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1727515809
  [
    "document_99"
  ]
]
58 0.26 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1727515809
  [
    "document_100"
  ]
]
59 0.25 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1727515809
  [
    "document_101"
  ]
]
60 0.26 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1727515809
  [
    "document_102"
  ]
]
61 0.26 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1727515809
  [
    "document_103"
  ]
]
62 0.26 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1727515809
  [
    "document_104"
  ]
]
63 0.26 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1727515809
  [
    "document_48"
  ]
]
64 0.26 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1727515809
  [
    "document_52"
  ]
]
65 0.26 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1727515809
  [
    "document_112"
  ]
]
66 0.26 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1727515809
  [
    "document_49"
  ]
]
67 0.27 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1727515809
  [
    "document_113"
  ]
]
68 0.26 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1727515809
  [
    "document_39"
  ]
]
69 0.27 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1727515809
  [
    "document_50"
  ]
]
70 0.26 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1727515809
  [
    "document_38"
  ]
]
71 0.26 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1727515809
  [
    "document_51"
  ]
]
72 0.26 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1727515809
  [
    "document_95"
  ]
]
73 0.25 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1727515809
  [
    "document_110"
  ]
]
74 0.26 ms
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
Parameters:
[
  1727515809
  [
    "document_88"
  ]
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

No loaded entities.