Query Metrics

165 Database Queries
43 Different statements
51.21 ms Query time
0 Invalid entities
0 Managed entities

Queries

Group similar statements

# Time Info
1 0.33 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "site_domain_03230cc19a82f9a2bebb1b9cdf68bad3"
]
2 0.27 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[
  1784654700
  "system\x01tags\x01"
  "site\x01tags\x01"
]
3 0.27 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
4 0.50 ms
SELECT * FROM redirects WHERE
            (
                (source = ? AND (`type` = ? OR `type` = ?)) OR
                (source = ? AND `type` = ?) OR
                (source = ? AND `type` = ?)
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = 2 AND priority = 99 ORDER BY `priority` DESC
Parameters:
[
  "/personen/detail/sunwook-kim"
  "path"
  "auto_create"
  "/personen/detail/sunwook-kim"
  "path_query"
  "https://www.meisterkammerkonzerte.at/personen/detail/sunwook-kim"
  "entire_uri"
]
5 0.27 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "system_route_redirect"
]
6 0.27 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?)
Parameters:
[
  1784654700
  "system\x01tags\x01"
  "redirect\x01tags\x01"
  "route\x01tags\x01"
]
7 0.25 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "maintenance_mode"
]
8 0.32 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/meisterkammerkonzerte/personen/detail/"
  "sunwook-kim"
]
9 0.23 ms
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
  "/meisterkammerkonzerte/personen/detail/sunwook-kim"
]
10 0.30 ms
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
Parameters:
[
  "/meisterkammerkonzerte/%"
  "/personen/detail/sunwook-kim"
]
11 0.26 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/meisterkammerkonzerte/personen/"
  "detail"
]
12 0.24 ms
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
  "/meisterkammerkonzerte/personen/detail"
]
13 0.27 ms
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
Parameters:
[
  "/meisterkammerkonzerte/%"
  "/personen/detail"
]
14 0.19 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/meisterkammerkonzerte/"
  "personen"
]
15 0.20 ms
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
  "/meisterkammerkonzerte/personen"
]
16 0.27 ms
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
Parameters:
[
  "/meisterkammerkonzerte/%"
  "/personen"
]
17 0.20 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/"
  "meisterkammerkonzerte"
]
18 0.21 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "document_3"
]
19 0.36 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1784654700
  "document_3\x01tags\x01"
  "asset_719\x01tags\x01"
  "asset_762\x01tags\x01"
  "asset_718\x01tags\x01"
  "asset_760\x01tags\x01"
  "asset_745\x01tags\x01"
  "asset_746\x01tags\x01"
  "asset_763\x01tags\x01"
  "asset_720\x01tags\x01"
]
20 0.27 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "document_properties_3"
]
21 0.26 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[
  1784654700
  "document_properties\x01tags\x01"
  "document_3\x01tags\x01"
]
22 0.23 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "8"
]
23 0.72 ms
SELECT object_8.id as id, object_8.type as `type` FROM object_8 WHERE `pathSegment` = 'sunwook-kim'  AND  object_8.type IN ('variant','object') LIMIT 1
Parameters:
[]
24 0.23 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "object_28211"
]
25 0.18 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "\x00tags\x00object_28211"
]
26 0.17 ms
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
Parameters:
[
  28211
]
27 0.26 ms
SELECT objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = ?
Parameters:
[
  28211
]
28 0.22 ms
SELECT * FROM object_store_8 WHERE oo_id = ? FOR UPDATE
Parameters:
[
  28211
]
29 0.22 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "asset_672"
]
30 0.18 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "\x00tags\x00asset_672"
]
31 0.24 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:
[
  672
]
32 0.25 ms
SELECT * FROM assets_metadata WHERE cid = ?
Parameters:
[
  672
]
33 0.31 ms
SELECT * FROM object_relations_8 WHERE src_id = ?
Parameters:
[
  28211
]
34 0.20 ms
SELECT id FROM classes WHERE name = ?
Parameters:
[
  "Cast"
]
35 0.18 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "11"
]
36 0.27 ms
SELECT * FROM object_relations_11 WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[
  28211
  "persons"
]
37 0.24 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "object_28213"
]
38 0.18 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "\x00tags\x00object_28213"
]
39 0.16 ms
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
Parameters:
[
  28213
]
40 0.24 ms
SELECT objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = ?
Parameters:
[
  28213
]
41 0.19 ms
SELECT * FROM object_store_11 WHERE oo_id = ? FOR UPDATE
Parameters:
[
  28213
]
42 0.22 ms
SELECT * FROM object_relations_11 WHERE src_id = ?
Parameters:
[
  28213
]
43 0.32 ms
SELECT * FROM object_relations_11 WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[
  28211
  "persons"
]
44 0.20 ms
SELECT id FROM classes WHERE name = ?
Parameters:
[
  "Activity"
]
45 0.15 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "3"
]
46 0.36 ms
SELECT * FROM object_relations_3 WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[
  28213
  "casts"
]
47 0.23 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "object_19889"
]
48 0.29 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[
  1784654700
  "object_19889\x01tags\x01"
  "class_3\x01tags\x01"
]
49 0.20 ms
SELECT id FROM classes WHERE name = ?
Parameters:
[
  "Production"
]
50 0.16 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "1"
]
51 0.35 ms
SELECT * FROM object_relations_1 WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[
  28213
  "casts"
]
52 0.31 ms
SELECT * FROM object_relations_3 WHERE src_id = ?
Parameters:
[
  19889
]
53 0.31 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "object_19879"
]
54 0.34 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?)
Parameters:
[
  1784654700
  "object_19879\x01tags\x01"
  "class_1\x01tags\x01"
  "asset_611\x01tags\x01"
]
55 0.32 ms
SELECT * FROM object_relations_1 WHERE src_id = ?
Parameters:
[
  19879
]
56 0.33 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "object_19759"
]
57 0.28 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[
  1784654700
  "object_19759\x01tags\x01"
  "class_2\x01tags\x01"
]
58 0.50 ms
SELECT *
            FROM website_settings
            WHERE name = ?
                AND (
                    siteId IS NULL
                    OR siteId = 0
                    OR siteId = ?
                )
                AND (
                    language IS NULL
                    OR language = ''
                    OR language = ?
                )
            ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC
Parameters:
[
  "peopleDetailPage_meisterkammerkonzerte_de"
  null
  null
]
59 0.41 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  672
]
60 0.29 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "imagick_format_webp"
]
61 0.34 ms
SELECT * FROM object_relations_11 WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[
  28211
  "persons"
]
62 0.34 ms
SELECT * FROM object_relations_3 WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[
  28213
  "casts"
]
63 0.30 ms
SELECT * FROM object_relations_1 WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[
  28213
  "casts"
]
64 0.28 ms
SELECT * FROM object_store_8 WHERE oo_id = ? FOR UPDATE
Parameters:
[
  28211
]
65 0.42 ms
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
66 0.36 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "translation_data_1d19e47125946f5a6366d64de93b5d4f"
]
67 0.36 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?)
Parameters:
[
  1784654700
  "translator\x01tags\x01"
  "translator_website\x01tags\x01"
  "translate\x01tags\x01"
]
68 0.41 ms
SELECT t0.id AS id_1, t0.element_type AS element_type_2, t0.element_id AS element_id_3, t0.integrator AS integrator_4, t0.data AS data_5, t0.release_type AS release_type_6 FROM seo_element_meta_data t0 WHERE t0.element_type = ? AND t0.element_id = ? AND t0.release_type = ?
Parameters:
[
  "object"
  28211
  "public"
]
69 0.27 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "27"
]
70 0.95 ms
SELECT object_localized_27_de.id as id, object_localized_27_de.type as `type` FROM object_localized_27_de WHERE `pathSegment` = 'sunwook-kim'  AND  object_localized_27_de.type IN ('variant','object') LIMIT 1
Parameters:
[]
71 0.24 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "28"
]
72 0.83 ms
SELECT object_localized_28_de.id as id, object_localized_28_de.type as `type` FROM object_localized_28_de WHERE `pathSegment` = 'sunwook-kim'  AND  object_localized_28_de.type IN ('variant','object') LIMIT 1
Parameters:
[]
73 0.24 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "43"
]
74 0.63 ms
SELECT object_localized_43_de.id as id, object_localized_43_de.type as `type` FROM object_localized_43_de WHERE `pathSegment` = 'sunwook-kim'  AND  object_localized_43_de.type IN ('variant','object') LIMIT 1
Parameters:
[]
75 0.22 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "44"
]
76 0.59 ms
SELECT object_localized_44_de.id as id, object_localized_44_de.type as `type` FROM object_localized_44_de WHERE `pathSegment` = 'sunwook-kim'  AND  object_localized_44_de.type IN ('variant','object') LIMIT 1
Parameters:
[]
77 0.20 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "22"
]
78 0.66 ms
SELECT object_localized_22_de.id as id, object_localized_22_de.type as `type` FROM object_localized_22_de WHERE `pathSegment` = 'sunwook-kim'  AND  object_localized_22_de.type IN ('variant','object') LIMIT 1
Parameters:
[]
79 0.27 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "25"
]
80 0.59 ms
SELECT object_localized_25_de.id as id, object_localized_25_de.type as `type` FROM object_localized_25_de WHERE `pathSegment` = 'sunwook-kim'  AND  object_localized_25_de.type IN ('variant','object') LIMIT 1
Parameters:
[]
81 1.05 ms
SELECT object_localized_1_de.id as id, object_localized_1_de.type as `type` FROM object_localized_1_de WHERE `pathSegment` = 'sunwook-kim'  AND  object_localized_1_de.type IN ('variant','object') LIMIT 1
Parameters:
[]
82 0.64 ms
SELECT object_8.id as id, object_8.type as `type` FROM object_8 WHERE `pathSegment` = 'sunwook-kim'  AND  object_8.type IN ('variant','object') LIMIT 1
Parameters:
[]
83 0.60 ms
SELECT object_localized_27_de.id as id, object_localized_27_de.type as `type` FROM object_localized_27_de WHERE `pathSegment` = 'sunwook-kim'  AND  object_localized_27_de.type IN ('variant','object') LIMIT 1
Parameters:
[]
84 0.55 ms
SELECT object_localized_28_de.id as id, object_localized_28_de.type as `type` FROM object_localized_28_de WHERE `pathSegment` = 'sunwook-kim'  AND  object_localized_28_de.type IN ('variant','object') LIMIT 1
Parameters:
[]
85 0.52 ms
SELECT object_localized_43_de.id as id, object_localized_43_de.type as `type` FROM object_localized_43_de WHERE `pathSegment` = 'sunwook-kim'  AND  object_localized_43_de.type IN ('variant','object') LIMIT 1
Parameters:
[]
86 0.54 ms
SELECT object_localized_44_de.id as id, object_localized_44_de.type as `type` FROM object_localized_44_de WHERE `pathSegment` = 'sunwook-kim'  AND  object_localized_44_de.type IN ('variant','object') LIMIT 1
Parameters:
[]
87 0.58 ms
SELECT object_localized_22_de.id as id, object_localized_22_de.type as `type` FROM object_localized_22_de WHERE `pathSegment` = 'sunwook-kim'  AND  object_localized_22_de.type IN ('variant','object') LIMIT 1
Parameters:
[]
88 0.57 ms
SELECT object_localized_25_de.id as id, object_localized_25_de.type as `type` FROM object_localized_25_de WHERE `pathSegment` = 'sunwook-kim'  AND  object_localized_25_de.type IN ('variant','object') LIMIT 1
Parameters:
[]
89 1.07 ms
SELECT object_localized_1_de.id as id, object_localized_1_de.type as `type` FROM object_localized_1_de WHERE `pathSegment` = 'sunwook-kim'  AND  object_localized_1_de.type IN ('variant','object') LIMIT 1
Parameters:
[]
90 0.84 ms
SELECT object_8.id as id, object_8.type as `type` FROM object_8 WHERE `pathSegment` = 'sunwook-kim'  AND  object_8.type IN ('variant','object') LIMIT 1
Parameters:
[]
91 0.35 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "nav_d5a16b3701b9538e96438ac1ed2883c2"
]
92 0.58 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1784654700
  "output\x01tags\x01"
  "navigation\x01tags\x01"
  "document_258\x01tags\x01"
  "document_208\x01tags\x01"
  "document_103\x01tags\x01"
  "document_207\x01tags\x01"
  "document_215\x01tags\x01"
  "document_216\x01tags\x01"
  "document_218\x01tags\x01"
  "document_214\x01tags\x01"
  "document_220\x01tags\x01"
  "document_227\x01tags\x01"
  "document_226\x01tags\x01"
  "document_221\x01tags\x01"
  "document_222\x01tags\x01"
  "document_223\x01tags\x01"
  "document_225\x01tags\x01"
  "document_219\x01tags\x01"
  "document_32\x01tags\x01"
  "document_106\x01tags\x01"
  "document_105\x01tags\x01"
  "document_104\x01tags\x01"
  "document_237\x01tags\x01"
  "document_10\x01tags\x01"
  "document_13\x01tags\x01"
  "document_231\x01tags\x01"
  "document_232\x01tags\x01"
  "document_233\x01tags\x01"
  "document_234\x01tags\x01"
  "document_21\x01tags\x01"
  "document_46\x01tags\x01"
  "document_96\x01tags\x01"
  "document_45\x01tags\x01"
  "document_6\x01tags\x01"
  "document_74\x01tags\x01"
]
93 0.28 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "document_96"
]
94 0.27 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "sites_path_mapping"
]
95 0.27 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[
  1784654700
  "system\x01tags\x01"
  "resource\x01tags\x01"
]
96 0.33 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "site_id_2"
]
97 0.35 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "document_207"
]
98 0.23 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "document_properties_207"
]
99 0.20 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "document_258"
]
100 0.31 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1784654700
  "document_258\x01tags\x01"
  "asset_716\x01tags\x01"
  "asset_765\x01tags\x01"
  "asset_711\x01tags\x01"
  "asset_764\x01tags\x01"
  "asset_750\x01tags\x01"
  "asset_721\x01tags\x01"
  "asset_708\x01tags\x01"
  "asset_766\x01tags\x01"
]
101 0.21 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "document_properties_258"
]
102 0.19 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "document_208"
]
103 0.20 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "document_properties_208"
]
104 0.19 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "document_103"
]
105 0.22 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "document_properties_103"
]
106 0.22 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "document_214"
]
107 0.19 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "document_properties_214"
]
108 0.19 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "document_215"
]
109 0.31 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "document_properties_215"
]
110 0.28 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "document_216"
]
111 0.23 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "document_properties_216"
]
112 0.20 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "document_218"
]
113 0.24 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "document_properties_218"
]
114 0.23 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "document_219"
]
115 0.19 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "document_properties_219"
]
116 0.24 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "document_220"
]
117 0.25 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?)
Parameters:
[
  1784654700
  "document_220\x01tags\x01"
  "asset_548\x01tags\x01"
  "asset_544\x01tags\x01"
]
118 0.27 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "document_properties_220"
]
119 0.21 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "document_227"
]
120 0.25 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?)
Parameters:
[
  1784654700
  "document_227\x01tags\x01"
  "asset_519\x01tags\x01"
  "asset_520\x01tags\x01"
]
121 0.24 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "document_properties_227"
]
122 0.19 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "document_226"
]
123 0.24 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?)
Parameters:
[
  1784654700
  "document_226\x01tags\x01"
  "asset_289\x01tags\x01"
  "asset_546\x01tags\x01"
  "asset_310\x01tags\x01"
]
124 0.20 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "document_properties_226"
]
125 0.19 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "document_221"
]
126 0.21 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[
  1784654700
  "document_221\x01tags\x01"
  "asset_543\x01tags\x01"
]
127 0.22 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "document_properties_221"
]
128 0.20 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "document_222"
]
129 0.23 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?)
Parameters:
[
  1784654700
  "document_222\x01tags\x01"
  "asset_521\x01tags\x01"
  "asset_523\x01tags\x01"
]
130 0.19 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "document_properties_222"
]
131 0.21 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "document_223"
]
132 0.21 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[
  1784654700
  "document_223\x01tags\x01"
  "asset_539\x01tags\x01"
]
133 0.19 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "document_properties_223"
]
134 0.19 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "document_225"
]
135 0.18 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "document_properties_225"
]
136 0.21 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "document_46"
]
137 0.26 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "document_1"
]
138 0.32 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "document_1\x01tags\x01"
]
139 0.25 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "document_31"
]
140 0.32 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?)
Parameters:
[
  1784654700
  "document_31\x01tags\x01"
  "asset_29\x01tags\x01"
  "asset_30\x01tags\x01"
]
141 0.27 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "document_properties_31"
]
142 0.32 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
143 0.62 ms
SELECT * FROM redirects WHERE
            (
                (source = ? AND (`type` = ? OR `type` = ?)) OR
                (source = ? AND `type` = ?) OR
                (source = ? AND `type` = ?)
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC
Parameters:
[
  "/_fragment"
  "path"
  "auto_create"
  "/_fragment?_path=_locale=de&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction"
  "path_query"
  "https://www.meisterkammerkonzerte.at/_fragment?_path=_locale=de&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction"
  "entire_uri"
]
144 0.31 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/"
  "_fragment"
]
145 0.27 ms
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
  "/_fragment"
]
146 0.34 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  31
]
147 0.30 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "document_21"
]
148 0.45 ms
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1
Parameters:
[
  21
]
149 0.25 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "document_231"
]
150 0.20 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "document_232"
]
151 0.24 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "document_233"
]
152 0.17 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "document_234"
]
153 0.32 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "document_32"
]
154 0.26 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "document_104"
]
155 0.31 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?)
Parameters:
[
  1784654700
  "document_104\x01tags\x01"
  "asset_54\x01tags\x01"
  "asset_26\x01tags\x01"
  "asset_24\x01tags\x01"
]
156 0.28 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "asset_29"
]
157 0.31 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  29
]
158 0.30 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  29
]
159 0.32 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "asset_30"
]
160 0.21 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  30
]
161 0.25 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  30
]
162 0.29 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "document_properties_231"
]
163 0.22 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "document_properties_232"
]
164 0.23 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "document_properties_233"
]
165 0.37 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1784654700
  "document_properties_234"
]

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.

Managed Entities

default entity manager

Class Amount of managed objects