Query Metrics
77
Database Queries
19
Different statements
12.12 ms
Query time
0
Invalid entities
0
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
3.75 ms (30.94%) |
33 |
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:
[ 1794165046 "site_domain_d799ddc8fe50df2e580ed3e93436b372" ] |
|
2.36 ms (19.45%) |
1 |
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 => 1794165046 0 => "nav_3afa32eaa5b924e4d85075ca59499a4c" 1 => b"O:1:"®":8:{s:6:" \x7F└\x1E";O:28:"Pimcore\Navigation\Container":3:{s:9:"\x00*\x00_pages";a:5:{i:2621;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:4:"Home";s:12:"\x00*\x00_fragment";N;s:6:"\x00*\x00_id";s:2:"41";s:9:"\x00*\x00_class";s:5:" main";s:9:"\x00*\x00_title";s:17:"BION Technologies";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: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";s:1:"/";s:12:"\x00*\x00_tabindex";s:0:"";s:12:"\x00*\x00_relation";s:0:"";s:14:"\x00*\x00_documentId";i:41;s:15:"\x00*\x00documentType";s:4:"link";s:15:"\x00*\x00realFullPath";s:26:"/BION Technologies/de/home";s:17:"\x00*\x00customSettings";a:0:{}}i:2660;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:"Produkte";s:12:"\x00*\x00_fragment";N;s:6:"\x00*\x00_id";s:2:"37";s:9:"\x00*\x00_class";s:5:" main";s:9:"\x00*\x00_title";s:8:"Produkte";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:"/de/products";s:12:"\x00*\x00_tabindex";s:0:"";s:12:"\x00*\x00_relation";s:0:"";s:14:"\x00*\x00_documentId";i:37;s:15:"\x00*\x00documentType";s:4:"page";s:15:"\x00*\x00realFullPath";s:30:"/BION Technologies/de/products";s:17:"\x00*\x00customSettings";a:0:{}}i:2699;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:"Projekte";s:12:"\x00*\x00_fragment";N;s:6:"\x00*\x00_id";s:2:"43";s:9:"\x00*\x00_class";s:5:" main";s:9:"\x00*\x00_title";s:8:"Projekte";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:"/de/projects";s:12:"\x00*\x00_tabindex";s:0:"";s:12:"\x00*\x00_relation";s:0:"";s:14:"\x00*\x00_documentId";i:43;s:15:"\x00*\x00documentType";s:4:"page";s:15:"\x00*\x00realFullPath";s:30:"/BION Technologies/de/projects";s:17:"\x00*\x00customSettings";a:0:{}}i:2725;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:16:"Vertriebspartner";s:12:"\x00*\x00_fragment";N;s:6:"\x00*\x00_id";s:2:"44";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: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:"/de/Vertriebspartner";s:12:"\x00*\x00_tabindex";N;s:12:"\x00*\x00_relation";N;s:14:"\x00*\x00_documentId";i:44;s:15:"\x00*\x00documentType";s:4:"page";s:15:"\x00*\x00realFullPath";s:38:"/BION Technologies/de/Vertriebspartner";s:17:"\x00*\x00customSettings";a:0:{}}i:2751;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:"45";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:45;s:15:"\x00*\x00documentType";s:6:"folder";s:15:"\x00*\x00realFullPath";s:28:"/BION Technologies/de/emails";s:17:"\x00*\x00customSettings";a:0:{}}}s:9:"\x00*\x00_index";a:5:{i:2621;N;i:2660;N;i:2699;N;i:2725;N;i:2751;N;}s:14:"\x00*\x00_dirtyIndex";b:1;}s:6:"output";s:6:"▀üÄ\x0E¨y";s:10:"navigation";s:6:"kS|\x19yÃ";s:11:"document_41";s:6:"kS|\x19yÃ";s:11:"document_37";s:6:"kS|\x19yÃ";s:11:"document_43";s:6:"kS|\x19yÃ";s:11:"document_44";s:6:"kS|\x19yÃ";s:11:"document_45";s:6:"kS|\x19yÃ";}" ] |
|
0.76 ms (6.23%) |
3 |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] |
|
0.68 ms (5.60%) |
6 |
SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1
Parameters:
[
36
]
|
|
0.59 ms (4.91%) |
2 |
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=Lexisoft%5CContentBundle%5CController%5CSnippetController%3A%3AfrontendSliderAction" "path_query" "https://www.alexanderweckmer.de/_fragment?_path=_locale=de&_format=html&_controller=Lexisoft%5CContentBundle%5CController%5CSnippetController%3A%3AfrontendSliderAction" "entire_uri" ] |
|
0.54 ms (4.44%) |
5 |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
822
]
|
|
0.48 ms (3.95%) |
5 |
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
822
]
|
|
0.47 ms (3.91%) |
3 |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
35
]
|
|
0.47 ms (3.87%) |
4 |
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:
[ 1794165046 "system\x01tags\x01" "site\x01tags\x01" ] |
|
0.37 ms (3.06%) |
3 |
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:
[ 1794165046 "system\x01tags\x01" "redirect\x01tags\x01" "route\x01tags\x01" ] |
|
0.35 ms (2.86%) |
3 |
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:
[ 1794165046 "output\x01tags\x01" "navigation\x01tags\x01" "document_41\x01tags\x01" "document_37\x01tags\x01" "document_43\x01tags\x01" "document_44\x01tags\x01" "document_45\x01tags\x01" ] |
|
0.28 ms (2.34%) |
2 |
SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC
Parameters:
[
36
]
|
|
0.19 ms (1.59%) |
1 |
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[] |
|
0.19 ms (1.53%) |
1 |
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:
[ "/" "path" "auto_create" "/" "path_query" "https://www.alexanderweckmer.de/" "entire_uri" ] |
|
0.15 ms (1.26%) |
1 |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/" "BION Technologies" ] |
|
0.14 ms (1.20%) |
1 |
SELECT * FROM object_url_slugs WHERE slug = '/' AND (siteId = 3 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
Parameters:
[] |
|
0.14 ms (1.18%) |
1 |
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:
[ 1794165046 "document_35\x01tags\x01" "asset_2910\x01tags\x01" "asset_2923\x01tags\x01" "asset_2922\x01tags\x01" ] |
|
0.14 ms (1.12%) |
1 |
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:
[ 1794165046 "document_36\x01tags\x01" "document_35\x01tags\x01" "asset_2910\x01tags\x01" "asset_2923\x01tags\x01" "asset_2922\x01tags\x01" ] |
|
0.07 ms (0.58%) |
1 |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
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.