Query Metrics
237
Database Queries
39
Different statements
157.31 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
66.01 ms (41.96%) |
100 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1727532946 "site_domain_e9db6b779bbf6547aaec98e3a9cb2a0f" ] |
25.81 ms (16.41%) |
26 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[ 1727532946 "system\x01tags\x01" "site\x01tags\x01" ] |
14.66 ms (9.32%) |
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 => 1727532946 0 => "nav_f2fcd049e74170a46afd8203f2136185" 1 => b"O:1:"©":10:{s:6:"ÿÿÿ\x7FÀ\x1E";O:28:"Pimcore\Navigation\Container":3:{s:9:"\x00*\x00_pages";a:7:{i:5335;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:9:"Lifestyle";s:12:"\x00*\x00_fragment";N;s:6:"\x00*\x00_id";s:3:"151";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:21:"/de/Magazin/Lifestyle";s:12:"\x00*\x00_tabindex";N;s:12:"\x00*\x00_relation";N;s:14:"\x00*\x00_documentId";i:151;s:15:"\x00*\x00documentType";s:4:"page";s:15:"\x00*\x00realFullPath";s:21:"/de/Magazin/Lifestyle";s:17:"\x00*\x00customSettings";a:0:{}}i:5998;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:6:"Kultur";s:12:"\x00*\x00_fragment";N;s:6:"\x00*\x00_id";s:3:"152";s:9:"\x00*\x00_class";s:5:" main";s:9:"\x00*\x00_title";s:0:"";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:18:"/de/Magazin/Kultur";s:12:"\x00*\x00_tabindex";s:0:"";s:12:"\x00*\x00_relation";s:0:"";s:14:"\x00*\x00_documentId";i:152;s:15:"\x00*\x00documentType";s:4:"page";s:15:"\x00*\x00realFullPath";s:18:"/de/Magazin/Kultur";s:17:"\x00*\x00customSettings";a:0:{}}i:6001;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:6:"Trends";s:12:"\x00*\x00_fragment";N;s:6:"\x00*\x00_id";s:3:"153";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:18:"/de/Magazin/Trends";s:12:"\x00*\x00_tabindex";N;s:12:"\x00*\x00_relation";N;s:14:"\x00*\x00_documentId";i:153;s:15:"\x00*\x00documentType";s:4:"page";s:15:"\x00*\x00realFullPath";s:18:"/de/Magazin/Trends";s:17:"\x00*\x00customSettings";a:0:{}}i:6030;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:9:"Auktionen";s:12:"\x00*\x00_fragment";N;s:6:"\x00*\x00_id";s:3:"154";s:9:"\x00*\x00_class";s:5:" main";s:9:"\x00*\x00_title";s:0:"";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:21:"/de/Magazin/Auktionen";s:12:"\x00*\x00_tabindex";s:0:"";s:12:"\x00*\x00_relation";s:0:"";s:14:"\x00*\x00_documentId";i:154;s:15:"\x00*\x00documentType";s:4:"page";s:15:"\x00*\x00realFullPath";s:21:"/de/Magazin/Auktionen";s:17:"\x00*\x00customSettings";a:0:{}}i:6050;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:"Auto Galerie";s:12:"\x00*\x00_fragment";N;s:6:"\x00*\x00_id";s:3:"155";s:9:"\x00*\x00_class";s:5:" main";s:9:"\x00*\x00_title";s:0:"";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:24:"/de/Magazin/Auto-Galerie";s:12:"\x00*\x00_tabindex";s:0:"";s:12:"\x00*\x00_relation";s:0:"";s:14:"\x00*\x00_documentId";i:155;s:15:"\x00*\x00documentType";s:4:"page";s:15:"\x00*\x00realFullPath";s:24:"/de/Magazin/Auto-Galerie";s:17:"\x00*\x00customSettings";a:0:{}}i:6079;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:14:"Auto des Tages";s:12:"\x00*\x00_fragment";N;s:6:"\x00*\x00_id";s:3:"156";s:9:"\x00*\x00_class";s:5:" main";s:9:"\x00*\x00_title";s:0:"";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:30:"/de/Magazin/Auto%20des%20Tages";s:12:"\x00*\x00_tabindex";s:0:"";s:12:"\x00*\x00_relation";s:0:"";s:14:"\x00*\x00_documentId";i:156;s:15:"\x00*\x00documentType";s:4:"page";s:15:"\x00*\x00realFullPath";s:26:"/de/Magazin/Auto des Tages";s:17:"\x00*\x00customSettings";a:0:{}}i:6110;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:15:"Auto einstellen";s:12:"\x00*\x00_fragment";N;s:6:"\x00*\x00_id";s:3:"157";s:9:"\x00*\x00_class";s:5:" main";s:9:"\x00*\x00_title";s:0:"";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:27:"/de/Magazin/Auto-einstellen";s:12:"\x00*\x00_tabindex";s:0:"";s:12:"\x00*\x00_relation";s:0:"";s:14:"\x00*\x00_documentId";i:157;s:15:"\x00*\x00documentType";s:4:"page";s:15:"\x00*\x00realFullPath";s:27:"/de/Magazin/Auto-einstellen";s:17:"\x00*\x00customSettings";a:0:{}}}s:9:"\x00*\x00_index";a:7:{i:5335;N;i:5998;N;i:6001;N;i:6030;N;i:6050;N;i:6079;N;i:6110;N;}s:14:"\x00*\x00_dirtyIndex";b:1;}s:6:"output";s:6:"O©\x18í1A";s:10:"navigation";s:6:"e'´ë#¶";s:12:"document_151";s:6:"ü3Z?öø";s:12:"document_152";s:6:"þÍÆpC\r";s:12:"document_153";s:6:"þÍÆpC\r";s:12:"document_154";s:6:"þÍÆpC\r";s:12:"document_155";s:6:"þÍÆpC\r";s:12:"document_156";s:6:"þÍÆpC\r";s:12:"document_157";s:6:"þÍÆpC\r";}" ] |
7.33 ms (4.66%) |
6 |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
337
]
|
7.11 ms (4.52%) |
8 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?)
Parameters:
[ 1727532946 "system\x01tags\x01" "redirect\x01tags\x01" "route\x01tags\x01" ] |
6.27 ms (3.99%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '259'
Parameters:
[] |
4.25 ms (2.70%) |
7 |
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:
[ "/de/Magazin/Auto des Tages" "path" "auto_create" "/de/Magazin/Auto des Tages" "path_query" "https://magento.xerbdev.online/de/Magazin/Auto des Tages" "entire_uri" ] |
4.08 ms (2.59%) |
28 |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
4.04 ms (2.57%) |
7 |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
156
]
|
2.36 ms (1.50%) |
7 |
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
337
]
|
1.73 ms (1.10%) |
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:
[ 1727532946 "object_69\x01tags\x01" "class_CAR\x01tags\x01" "asset_55\x01tags\x01" "asset_56\x01tags\x01" ] |
1.68 ms (1.07%) |
1 |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='6'
Parameters:
[] |
1.49 ms (0.95%) |
1 |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='10'
Parameters:
[] |
1.47 ms (0.93%) |
1 |
SELECT * FROM object_url_slugs WHERE slug = '/de/Magazin/Auto des Tages' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[] |
1.01 ms (0.64%) |
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:
[ 1727532946 "output\x01tags\x01" "navigation\x01tags\x01" "document_164\x01tags\x01" "document_165\x01tags\x01" "document_138\x01tags\x01" "document_151\x01tags\x01" "document_152\x01tags\x01" "document_153\x01tags\x01" "document_154\x01tags\x01" "document_155\x01tags\x01" "document_156\x01tags\x01" "document_157\x01tags\x01" "document_139\x01tags\x01" "document_142\x01tags\x01" "document_171\x01tags\x01" "document_172\x01tags\x01" "document_173\x01tags\x01" "document_174\x01tags\x01" "document_158\x01tags\x01" "document_161\x01tags\x01" "document_160\x01tags\x01" "document_140\x01tags\x01" "document_170\x01tags\x01" "document_148\x01tags\x01" "document_149\x01tags\x01" "document_137\x01tags\x01" "document_141\x01tags\x01" ] |
0.98 ms (0.62%) |
5 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"CAR"
]
|
0.91 ms (0.58%) |
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:
[ 1727532946 "document_136\x01tags\x01" "asset_337\x01tags\x01" "asset_3\x01tags\x01" "asset_319\x01tags\x01" "asset_361\x01tags\x01" "asset_320\x01tags\x01" "asset_318\x01tags\x01" "asset_321\x01tags\x01" "asset_224\x01tags\x01" "asset_35\x01tags\x01" "asset_211\x01tags\x01" "asset_90\x01tags\x01" "asset_58\x01tags\x01" "asset_180\x01tags\x01" "asset_124\x01tags\x01" "asset_164\x01tags\x01" "asset_81\x01tags\x01" ] |
0.85 ms (0.54%) |
4 |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/de/Magazin/" "Auto des Tages" ] |
0.82 ms (0.52%) |
1 |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='9'
Parameters:
[] |
0.75 ms (0.47%) |
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:
[ 1727532946 "document_3\x01tags\x01" "document_1\x01tags\x01" "asset_337\x01tags\x01" "asset_3\x01tags\x01" "asset_319\x01tags\x01" "asset_361\x01tags\x01" "asset_320\x01tags\x01" "asset_318\x01tags\x01" "asset_321\x01tags\x01" "asset_224\x01tags\x01" "asset_35\x01tags\x01" "asset_211\x01tags\x01" "asset_90\x01tags\x01" "asset_58\x01tags\x01" "asset_180\x01tags\x01" "asset_124\x01tags\x01" "asset_164\x01tags\x01" "asset_81\x01tags\x01" ] |
0.64 ms (0.41%) |
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:
[ 1727532946 "output\x01tags\x01" "navigation\x01tags\x01" "document_151\x01tags\x01" "document_152\x01tags\x01" "document_153\x01tags\x01" "document_154\x01tags\x01" "document_155\x01tags\x01" "document_156\x01tags\x01" "document_157\x01tags\x01" ] |
0.46 ms (0.29%) |
8 |
SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1
Parameters:
[
139
]
|
0.38 ms (0.24%) |
2 |
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId AS id,"source" FROM documents_translations WHERE id = ?
Parameters:
[ 156 156 ] |
0.38 ms (0.24%) |
1 |
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId AS id,"source" FROM documents_translations WHERE id = ?
Parameters:
[ 104 156 156 ] |
0.37 ms (0.24%) |
1 |
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
156
]
|
0.20 ms (0.12%) |
1 |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/Product Data/Accessories/lights/head lights/" "citroen-2cv-head lights" ] |
0.18 ms (0.12%) |
1 |
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[] |
0.16 ms (0.10%) |
1 |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='7'
Parameters:
[] |
0.15 ms (0.10%) |
1 |
SELECT id FROM ecommerceframework_pricing_rule WHERE active = 1 ORDER BY `prio` ASC
Parameters:
[] |
0.11 ms (0.07%) |
1 |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='8'
Parameters:
[] |
0.10 ms (0.07%) |
1 |
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:
[ "defaultTaxClass" null null ] |
0.09 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '69'
Parameters:
[] |
0.08 ms (0.05%) |
1 |
SELECT id FROM sites ORDER BY (SELECT LENGTH(`path`) FROM documents WHERE documents.id = sites.rootId) DESC
Parameters:
[] |
0.08 ms (0.05%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '257'
Parameters:
[] |
0.07 ms (0.05%) |
1 |
SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC
Parameters:
[
139
]
|
0.07 ms (0.04%) |
1 |
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
2
]
|
0.07 ms (0.04%) |
1 |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
0.06 ms (0.04%) |
1 |
SELECT * FROM translations_admin LIMIT 1;
Parameters:
[] |
0.04 ms (0.02%) |
1 |
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
"/fr"
]
|
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.
Entities Mapping
No mapped entities.