Query Metrics
165
Database Queries
43
Different statements
51.21 ms
Query time
0
Invalid entities
0
Managed entities
Queries
| #▲ | 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 |
|---|
Entities Mapping
| Class | Mapping errors |
|---|---|
| SeoBundle\Model\ElementMetaData | No errors. |
| FormBuilderBundle\Model\OutputWorkflow | No errors. |
| FormBuilderBundle\Model\DoubleOptInSession | No errors. |
| FormBuilderBundle\Model\FormDefinition | No errors. |
| FormBuilderBundle\Model\OutputWorkflowChannel | No errors. |