Query Metrics
120
Database Queries
31
Different statements
15.99 ms
Query time
0
Invalid entities
0
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 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:
[ 1794165183 "site_domain_f6906d48763f6739bcdbd37022958afb" ] |
| 2 | 0.12 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:
[ 1794165183 "system\x01tags\x01" "site\x01tags\x01" ] |
| 3 | 0.10 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] |
| 4 | 0.44 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 = 3 AND priority = 99 ORDER BY `priority` DESC
Parameters:
[ "/en/products/gfcj" "path" "auto_create" "/en/products/gfcj" "path_query" "https://alexanderweckmer.de/en/products/gfcj" "entire_uri" ] |
| 5 | 0.11 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:
[ 1794165183 "system_route_redirect" ] |
| 6 | 0.12 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:
[ 1794165183 "system\x01tags\x01" "redirect\x01tags\x01" "route\x01tags\x01" ] |
| 7 | 0.10 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
| 8 | 0.14 ms |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/BION Technologies/en/products/" "gfcj" ] |
| 9 | 0.11 ms |
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
"/BION Technologies/en/products/gfcj"
]
|
| 10 | 0.13 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:
[ "/BION Technologies/%" "/en/products/gfcj" ] |
| 11 | 0.11 ms |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/BION Technologies/en/" "products" ] |
| 12 | 0.11 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:
[ 1794165183 "document_51" ] |
| 13 | 0.11 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:
[ 1794165183 "document_51\x01tags\x01" ] |
| 14 | 0.12 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:
[ 1794165183 "document_properties_51" ] |
| 15 | 0.12 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:
[ 1794165183 "document_properties\x01tags\x01" "document_51\x01tags\x01" ] |
| 16 | 0.10 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:
[ 1794165183 "document_49" ] |
| 17 | 0.13 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:
[ 1794165183 "document_49\x01tags\x01" ] |
| 18 | 0.11 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:
[ 1794165183 "document_35" ] |
| 19 | 0.15 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:
[ 1794165183 "document_35\x01tags\x01" "asset_2910\x01tags\x01" "asset_2923\x01tags\x01" "asset_2922\x01tags\x01" ] |
| 20 | 0.10 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:
[ 1794165183 "document_1" ] |
| 21 | 0.10 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:
[ 1794165183 "document_1\x01tags\x01" ] |
| 22 | 0.22 ms |
SELECT * FROM properties WHERE ( (cid IN (1,49,35) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
51
]
|
| 23 | 0.15 ms |
SELECT * FROM object_url_slugs WHERE slug = '/gfcj' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[] |
| 24 | 0.12 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:
[ 1794165183 "object_1443" ] |
| 25 | 0.12 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"COP"
]
|
| 26 | 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:
[ 1794165183 "object_1443\x01tags\x01" "class_COP\x01tags\x01" "asset_2099\x01tags\x01" "asset_2097\x01tags\x01" ] |
| 27 | 0.11 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:
[ 1794165183 "object_324" ] |
| 28 | 0.09 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:
[ 1794165183 "object_324\x01tags\x01" ] |
| 29 | 0.09 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:
[ 1794165183 "object_1" ] |
| 30 | 0.10 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:
[ 1794165183 "object_1\x01tags\x01" ] |
| 31 | 0.14 ms |
SELECT * FROM object_relations_COP WHERE src_id = ?
Parameters:
[
1443
]
|
| 32 | 0.09 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:
[ 1794165183 "object_1445" ] |
| 33 | 0.11 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:
[ 1794165183 "object_1445\x01tags\x01" "class_COG\x01tags\x01" ] |
| 34 | 0.09 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:
[ 1794165183 "object_1449" ] |
| 35 | 0.16 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:
[ 1794165183 "object_1449\x01tags\x01" "class_COG\x01tags\x01" ] |
| 36 | 0.12 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:
[ 1794165183 "object_1446" ] |
| 37 | 0.09 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"OPT"
]
|
| 38 | 0.11 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:
[ 1794165183 "object_1446\x01tags\x01" "class_OPT\x01tags\x01" ] |
| 39 | 0.17 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:
[ "SystemSettingsObject" null null ] |
| 40 | 0.11 ms |
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
7
]
|
| 41 | 0.10 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:
[ 1794165183 "object_4" ] |
| 42 | 0.10 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"SYS"
]
|
| 43 | 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:
[ 1794165183 "object_4\x01tags\x01" "class_SYS\x01tags\x01" "asset_127\x01tags\x01" "asset_268\x01tags\x01" "asset_265\x01tags\x01" "asset_2599\x01tags\x01" "asset_2600\x01tags\x01" "asset_2601\x01tags\x01" ] |
| 44 | 0.13 ms |
SELECT * FROM object_relations_SYS WHERE src_id = ?
Parameters:
[
4
]
|
| 45 | 0.12 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:
[ 1794165183 "object_326" ] |
| 46 | 0.12 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:
[ 1794165183 "object_326\x01tags\x01" "class_COCS\x01tags\x01" ] |
| 47 | 0.10 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"COCS"
]
|
| 48 | 0.16 ms |
select `ConfigurationBlock` from object_brick_store_LightingAccessory_COP where id = 1443 and fieldname = 'CustomProductSettings'
Parameters:
[] |
| 49 | 0.13 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:
[ 1794165183 "object_1448" ] |
| 50 | 0.10 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"COI"
]
|
| 51 | 0.14 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:
[ 1794165183 "object_1448\x01tags\x01" "class_COI\x01tags\x01" ] |
| 52 | 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:
[ 1794165183 "quantityvalue_units_table" ] |
| 53 | 0.09 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:
[ 1794165183 "object_1447" ] |
| 54 | 0.13 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:
[ 1794165183 "object_1447\x01tags\x01" "class_COI\x01tags\x01" ] |
| 55 | 0.10 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:
[ 1794165183 "object_1450" ] |
| 56 | 0.13 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:
[ 1794165183 "object_1450\x01tags\x01" "class_COI\x01tags\x01" ] |
| 57 | 0.12 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:
[ 1794165183 "object_1451" ] |
| 58 | 0.12 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:
[ 1794165183 "object_1451\x01tags\x01" "class_COI\x01tags\x01" ] |
| 59 | 0.13 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:
[ 1794165183 "object_433" ] |
| 60 | 0.15 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:
[ 1794165183 "object_433\x01tags\x01" "class_OPT\x01tags\x01" ] |
| 61 | 0.14 ms |
select `MechanicsBlock` from object_brick_store_LightingAccessory_COP where id = 1443 and fieldname = 'CustomProductSettings'
Parameters:
[] |
| 62 | 0.12 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:
[ 1794165183 "object_259" ] |
| 63 | 0.14 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:
[ 1794165183 "object_259\x01tags\x01" "class_OPT\x01tags\x01" ] |
| 64 | 0.12 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:
[ 1794165183 "object_260" ] |
| 65 | 0.12 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:
[ 1794165183 "object_260\x01tags\x01" "class_OPT\x01tags\x01" ] |
| 66 | 0.11 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:
[ 1794165183 "object_148" ] |
| 67 | 0.10 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"POT"
]
|
| 68 | 0.13 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:
[ 1794165183 "object_148\x01tags\x01" "class_POT\x01tags\x01" ] |
| 69 | 0.10 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:
[ 1794165183 "object_267" ] |
| 70 | 0.12 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:
[ 1794165183 "object_267\x01tags\x01" "class_OPT\x01tags\x01" ] |
| 71 | 0.10 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:
[ 1794165183 "object_152" ] |
| 72 | 0.11 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:
[ 1794165183 "object_152\x01tags\x01" "class_POT\x01tags\x01" ] |
| 73 | 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:
[ 1794165183 "document_50" ] |
| 74 | 0.12 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:
[ 1794165183 "document_50\x01tags\x01" ] |
| 75 | 0.14 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:
[ 1794165183 "sites_path_mapping" ] |
| 76 | 0.13 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:
[ 1794165183 "system\x01tags\x01" "resource\x01tags\x01" ] |
| 77 | 0.11 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:
[ 1794165183 "site_id_3" ] |
| 78 | 0.11 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:
[ 1794165183 "nav_4f4cde6845cd1bea9b3af8faef7c3022" ] |
| 79 | 0.14 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:
[ 1794165183 "output\x01tags\x01" "navigation\x01tags\x01" "document_51\x01tags\x01" "document_52\x01tags\x01" "document_53\x01tags\x01" "document_64\x01tags\x01" ] |
| 80 | 0.16 ms |
SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1
Parameters:
[
49
]
|
| 81 | 0.13 ms |
SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC
Parameters:
[
49
]
|
| 82 | 0.10 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:
[ 1794165183 "document_52" ] |
| 83 | 0.14 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:
[ 1794165183 "document_53" ] |
| 84 | 0.11 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:
[ 1794165183 "document_64" ] |
| 85 | 0.11 ms |
SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1
Parameters:
[
51
]
|
| 86 | 0.11 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:
[ 1794165183 "document_properties_52" ] |
| 87 | 0.10 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:
[ 1794165183 "document_properties\x01tags\x01" "document_52\x01tags\x01" ] |
| 88 | 0.17 ms |
SELECT * FROM properties WHERE ( (cid IN (1,49,35) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
52
]
|
| 89 | 0.09 ms |
SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1
Parameters:
[
52
]
|
| 90 | 0.11 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:
[ 1794165183 "document_properties_53" ] |
| 91 | 0.12 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:
[ 1794165183 "document_properties\x01tags\x01" "document_53\x01tags\x01" ] |
| 92 | 0.18 ms |
SELECT * FROM properties WHERE ( (cid IN (1,49,35) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
53
]
|
| 93 | 0.11 ms |
SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1
Parameters:
[
53
]
|
| 94 | 0.10 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:
[ 1794165183 "document_properties_64" ] |
| 95 | 0.11 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:
[ 1794165183 "document_properties\x01tags\x01" "document_64\x01tags\x01" ] |
| 96 | 0.16 ms |
SELECT * FROM properties WHERE ( (cid IN (1,49,35) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
64
]
|
| 97 | 0.10 ms |
SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1
Parameters:
[
64
]
|
| 98 | 0.12 ms |
SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC
Parameters:
[
64
]
|
| 99 | 0.11 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:
[ 1794165183 "document_67" ] |
| 100 | 0.12 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:
[ 1794165183 "document_67\x01tags\x01" "asset_2759\x01tags\x01" ] |
| 101 | 0.10 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:
[ 1794165183 "nav_4f4cde6845cd1bea9b3af8faef7c3022" ] |
| 102 | 0.15 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:
[ 1794165183 "output\x01tags\x01" "navigation\x01tags\x01" "document_51\x01tags\x01" "document_52\x01tags\x01" "document_53\x01tags\x01" "document_64\x01tags\x01" ] |
| 103 | 0.14 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:
[ 1794165183 "output\x01tags\x01" "navigation\x01tags\x01" "document_51\x01tags\x01" "document_52\x01tags\x01" "document_53\x01tags\x01" "document_64\x01tags\x01" ] |
| 104 | 0.42 ms |
INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time)
Parameters:
[ 2 => null 3 => 1794165183 0 => "output\x01tags\x01" 1 => b"s:6:"\³\x1C€\x08e";" ] |
| 105 | 0.42 ms |
INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time)
Parameters:
[ 2 => 31536000 3 => 1794165183 0 => "nav_4f4cde6845cd1bea9b3af8faef7c3022" 1 => b"O:1:"©":7:{s:6:"ÿÿÿ\x7FÀ\x1E";O:28:"Pimcore\Navigation\Container":3:{s:9:"\x00*\x00_pages";a:4:{i:5108;O:32:"Pimcore\Navigation\Page\Document":25:{s:9:"\x00*\x00_pages";a:0:{}s:9:"\x00*\x00_index";a:0:{}s:14:"\x00*\x00_dirtyIndex";b:0;s:9:"\x00*\x00_label";s:8:"Products";s:12:"\x00*\x00_fragment";N;s:6:"\x00*\x00_id";s:2:"51";s:9:"\x00*\x00_class";s:5:" main";s:9:"\x00*\x00_title";s:8:"Products";s:10:"\x00*\x00_target";N;s:13:"\x00*\x00_accesskey";s:0:"";s:7:"\x00*\x00_rel";a:0:{}s:7:"\x00*\x00_rev";a:0:{}s:9:"\x00*\x00_order";N;s:10:"\x00*\x00_active";b:0;s:11:"\x00*\x00_visible";b:1;s:10:"\x00*\x00_parent";r:2;s:14:"\x00*\x00_properties";a:0:{}s:21:"\x00*\x00_customHtmlAttribs";a:0:{}s:7:"\x00*\x00_uri";s:12:"/en/products";s:12:"\x00*\x00_tabindex";s:0:"";s:12:"\x00*\x00_relation";s:0:"";s:14:"\x00*\x00_documentId";i:51;s:15:"\x00*\x00documentType";s:4:"page";s:15:"\x00*\x00realFullPath";s:30:"/BION Technologies/en/products";s:17:"\x00*\x00customSettings";a:0:{}}i:4860;O:32:"Pimcore\Navigation\Page\Document":25:{s:9:"\x00*\x00_pages";a:0:{}s:9:"\x00*\x00_index";a:0:{}s:14:"\x00*\x00_dirtyIndex";b:0;s:9:"\x00*\x00_label";s:8:"Projects";s:12:"\x00*\x00_fragment";N;s:6:"\x00*\x00_id";s:2:"52";s:9:"\x00*\x00_class";s:5:" main";s:9:"\x00*\x00_title";s:8:"Projects";s:10:"\x00*\x00_target";N;s:13:"\x00*\x00_accesskey";s:0:"";s:7:"\x00*\x00_rel";a:0:{}s:7:"\x00*\x00_rev";a:0:{}s:9:"\x00*\x00_order";N;s:10:"\x00*\x00_active";b:0;s:11:"\x00*\x00_visible";b:1;s:10:"\x00*\x00_parent";r:2;s:14:"\x00*\x00_properties";a:0:{}s:21:"\x00*\x00_customHtmlAttribs";a:0:{}s:7:"\x00*\x00_uri";s:12:"/en/projects";s:12:"\x00*\x00_tabindex";s:0:"";s:12:"\x00*\x00_relation";s:0:"";s:14:"\x00*\x00_documentId";i:52;s:15:"\x00*\x00documentType";s:4:"page";s:15:"\x00*\x00realFullPath";s:30:"/BION Technologies/en/projects";s:17:"\x00*\x00customSettings";a:0:{}}i:4828;O:32:"Pimcore\Navigation\Page\Document":25:{s:9:"\x00*\x00_pages";a:0:{}s:9:"\x00*\x00_index";a:0:{}s:14:"\x00*\x00_dirtyIndex";b:0;s:9:"\x00*\x00_label";s:12:"Where to buy";s:12:"\x00*\x00_fragment";N;s:6:"\x00*\x00_id";s:2:"53";s:9:"\x00*\x00_class";s:5:" main";s:9:"\x00*\x00_title";s:12:"Where to buy";s:10:"\x00*\x00_target";N;s:13:"\x00*\x00_accesskey";s:0:"";s:7:"\x00*\x00_rel";a:0:{}s:7:"\x00*\x00_rev";a:0:{}s:9:"\x00*\x00_order";N;s:10:"\x00*\x00_active";b:0;s:11:"\x00*\x00_visible";b:1;s:10:"\x00*\x00_parent";r:2;s:14:"\x00*\x00_properties";a:0:{}s:21:"\x00*\x00_customHtmlAttribs";a:0:{}s:7:"\x00*\x00_uri";s:20:"/en/Where%20to%20buy";s:12:"\x00*\x00_tabindex";s:0:"";s:12:"\x00*\x00_relation";s:0:"";s:14:"\x00*\x00_documentId";i:53;s:15:"\x00*\x00documentType";s:4:"page";s:15:"\x00*\x00realFullPath";s:34:"/BION Technologies/en/Where to buy";s:17:"\x00*\x00customSettings";a:0:{}}i:4790;O:32:"Pimcore\Navigation\Page\Document":25:{s:9:"\x00*\x00_pages";a:0:{}s:9:"\x00*\x00_index";a:0:{}s:14:"\x00*\x00_dirtyIndex";b:0;s:9:"\x00*\x00_label";N;s:12:"\x00*\x00_fragment";N;s:6:"\x00*\x00_id";s:2:"64";s:9:"\x00*\x00_class";s:5:" main";s:9:"\x00*\x00_title";N;s:10:"\x00*\x00_target";N;s:13:"\x00*\x00_accesskey";N;s:7:"\x00*\x00_rel";a:0:{}s:7:"\x00*\x00_rev";a:0:{}s:9:"\x00*\x00_order";N;s:10:"\x00*\x00_active";b:0;s:11:"\x00*\x00_visible";b:0;s:10:"\x00*\x00_parent";r:2;s:14:"\x00*\x00_properties";a:0:{}s:21:"\x00*\x00_customHtmlAttribs";a:0:{}s:7:"\x00*\x00_uri";N;s:12:"\x00*\x00_tabindex";N;s:12:"\x00*\x00_relation";N;s:14:"\x00*\x00_documentId";i:64;s:15:"\x00*\x00documentType";s:6:"folder";s:15:"\x00*\x00realFullPath";s:32:"/BION Technologies/en/newsletter";s:17:"\x00*\x00customSettings";a:0:{}}}s:9:"\x00*\x00_index";a:4:{i:5108;N;i:4860;N;i:4828;N;i:4790;N;}s:14:"\x00*\x00_dirtyIndex";b:1;}s:6:"output";s:6:"\³\x1C€\x08e";s:10:"navigation";s:6:"kS|\x19yÇ";s:11:"document_51";s:6:"Ilzv\n$";s:11:"document_52";s:6:"·eÌ̱™";s:11:"document_53";s:6:"·eÌ̱™";s:11:"document_64";s:6:"(/ç\x0F\x10â";}" ] |
| 106 | 0.12 ms |
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[] |
| 107 | 0.14 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:
[ 1794165183 "translation_data_01e5f00fbf5874160f42c8fe5f4fa4ea" ] |
| 108 | 0.13 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:
[ 1794165183 "translator\x01tags\x01" "translator_website\x01tags\x01" "translate\x01tags\x01" ] |
| 109 | 0.16 ms |
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
2099
]
|
| 110 | 0.16 ms |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
2099
]
|
| 111 | 0.13 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:
[ 1794165183 "imagick_format_webp" ] |
| 112 | 0.13 ms |
SELECT * FROM object_url_slugs WHERE fieldname = 'UrlSlug' AND ownertype = 'object' AND objectId = '1443'
Parameters:
[] |
| 113 | 0.10 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:
[ 1794165183 "document_properties_50" ] |
| 114 | 0.13 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:
[ 1794165183 "document_properties\x01tags\x01" "document_50\x01tags\x01" ] |
| 115 | 0.09 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:
[ 1794165183 "document_39" ] |
| 116 | 0.08 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:
[ 1794165183 "document_39\x01tags\x01" ] |
| 117 | 0.17 ms |
SELECT * FROM properties WHERE ( (cid IN (1,39,35) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
50
]
|
| 118 | 0.11 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] |
| 119 | 0.24 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=en&_format=html&_controller=Lexisoft%5CContentBundle%5CController%5CSnippetController%3A%3AfooterAction" "path_query" "https://alexanderweckmer.de/_fragment?_path=_locale=en&_format=html&_controller=Lexisoft%5CContentBundle%5CController%5CSnippetController%3A%3AfooterAction" "entire_uri" ] |
| 120 | 0.11 ms |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
50
]
|
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.
Managed Entities
No managed entities.
Entities Mapping
No mapped entities.