Query Metrics
597
Database Queries
77
Different statements
82.79 ms
Query time
0
Invalid entities
0
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
25.09 ms (30.30%) |
208 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1776517565 "site_domain_3fa2b37c1b0c31e347ffd81cfed59914" ] |
|
10.55 ms (12.74%) |
90 |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
|
5.77 ms (6.97%) |
42 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[ 1776517565 "system\x01tags\x01" "site\x01tags\x01" ] |
|
4.86 ms (5.87%) |
37 |
SELECT * FROM object_relations_CAR WHERE src_id = ?
Parameters:
[
12
]
|
|
4.23 ms (5.11%) |
22 |
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
3
]
|
|
3.84 ms (4.63%) |
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:
[ 1776517565 "system\x01tags\x01" "redirect\x01tags\x01" "route\x01tags\x01" ] |
|
3.00 ms (3.63%) |
26 |
SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1
Parameters:
[
136
]
|
|
2.26 ms (2.73%) |
22 |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
3
]
|
|
1.64 ms (1.98%) |
10 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?)
Parameters:
[ 1776517565 "object_12\x01tags\x01" "class_CAR\x01tags\x01" "asset_3\x01tags\x01" "asset_10\x01tags\x01" ] |
|
1.19 ms (1.43%) |
9 |
SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC
Parameters:
[
136
]
|
|
1.17 ms (1.41%) |
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 => 1776517566 0 => "nav_4cbf1c38e41d958d69772bb2eb9b625e" 1 => b"O:1:"©":28:{s:6:"ÿÿÿ\x7FÀ\x1E";O:28:"Pimcore\Navigation\Container":3:{s:9:"\x00*\x00_pages";a:6:{i:5715;O:32:"Pimcore\Navigation\Page\Document":25:{s:9:"\x00*\x00_pages";a:2:{i:5790;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:"Beliebte Marken";s:12:"\x00*\x00_fragment";N;s:6:"\x00*\x00_id";s:3:"164";s:9:"\x00*\x00_class";s:0:"";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:4;s:14:"\x00*\x00_properties";a:0:{}s:21:"\x00*\x00_customHtmlAttribs";a:0:{}s:7:"\x00*\x00_uri";s:37:"/de/Finden-und-Kaufen/Beliebte-Marken";s:12:"\x00*\x00_tabindex";s:0:"";s:12:"\x00*\x00_relation";s:0:"";s:14:"\x00*\x00_documentId";i:164;s:15:"\x00*\x00documentType";s:4:"page";s:15:"\x00*\x00realFullPath";s:37:"/de/Finden-und-Kaufen/Beliebte-Marken";s:17:"\x00*\x00customSettings";a:0:{}}i:5810;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:10:"Im Angebot";s:12:"\x00*\x00_fragment";N;s:6:"\x00*\x00_id";s:3:"165";s:9:"\x00*\x00_class";s:0:"";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:4;s:14:"\x00*\x00_properties";a:0:{}s:21:"\x00*\x00_customHtmlAttribs";a:0:{}s:7:"\x00*\x00_uri";s:32:"/de/Finden-und-Kaufen/Im-Angebot";s:12:"\x00*\x00_tabindex";s:0:"";s:12:"\x00*\x00_relation";s:0:"";s:14:"\x00*\x00_documentId";i:165;s:15:"\x00*\x00documentType";s:4:"page";s:15:"\x00*\x00realFullPath";s:32:"/de/Finden-und-Kaufen/Im-Angebot";s:17:"\x00*\x00customSettings";a:0:{}}}s:9:"\x00*\x00_index";a:2:{i:5790;N;i:5810;N;}s:14:"\x00*\x00_dirtyIndex";b:1;s:9:"\x00*\x00_label";s:15:"Finden & Kaufen";s:12:"\x00*\x00_fragment";N;s:6:"\x00*\x00_id";s:3:"138";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:22:"/de/shop/Products~c564";s:12:"\x00*\x00_tabindex";s:0:"";s:12:"\x00*\x00_relation";s:0:"";s:14:"\x00*\x00_documentId";i:138;s:15:"\x00*\x00documentType";s:4:"link";s:15:"\x00*\x00realFullPath";s:21:"/de/Finden-und-Kaufen";s:17:"\x00*\x00customSettings";a:0:{}}i:5741;O:32:"Pimcore\Navigation\Page\Document":25:{s:9:"\x00*\x00_pages";a:7:{i:5705;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:0:"";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:84;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:5896;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:0:"";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:84;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:5942;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:0:"";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:84;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:5971;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:0:"";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:84;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:5991;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:0:"";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:84;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:6020;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:0:"";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:84;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:6049;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:0:"";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:84;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:5705;N;i:5896;N;i:5942;N;i:5971;N;i:5991;N;i:6020;N;i:6049;N;}s:14:"\x00*\x00_dirtyIndex";b:1;s:9:"\x00*\x00_label";s:7:"Magazin";s:12:"\x00*\x00_fragment";N;s:6:"\x00*\x00_id";s:3:"139";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:11:"/de/Magazin";s:12:"\x00*\x00_tabindex";s:0:"";s:12:"\x00*\x00_relation";s:0:"";s:14:"\x00*\x00_documentId";i:139;s:15:"\x00*\x00documentType";s:4:"page";s:15:"\x00*\x00realFullPath";s:11:"/de/Magazin";s:17:"\x00*\x00customSettings";a:0:{}}i:6078;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:"News";s:12:"\x00*\x00_fragment";N;s:6:"\x00*\x00_id";s:3:"142";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:8:"/de/News";s:12:"\x00*\x00_tabindex";s:0:"";s:12:"\x00*\x00_relation";s:0:"";s:14:"\x00*\x00_documentId";i:142;s:15:"\x00*\x00documentType";s:4:"page";s:15:"\x00*\x00realFullPath";s:8:"/de/News";s:17:"\x00*\x00customSettings";a:0:{}}i:6107;O:32:"Pimcore\Navigation\Page\Document":25:{s:9:"\x00*\x00_pages";a:3:{i:6197;O:32:"Pimcore\Navigation\Page\Document":25:{s:9:"\x00*\x00_pages";a:4:{i:6196;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:"Chevrolet";s:12:"\x00*\x00_fragment";N;s:6:"\x00*\x00_id";s:3:"171";s:9:"\x00*\x00_class";s:0:"";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:327;s:14:"\x00*\x00_properties";a:0:{}s:21:"\x00*\x00_customHtmlAttribs";a:0:{}s:7:"\x00*\x00_uri";s:35:"/de/Weiteres/Landingpages/Chevrolet";s:12:"\x00*\x00_tabindex";N;s:12:"\x00*\x00_relation";N;s:14:"\x00*\x00_documentId";i:171;s:15:"\x00*\x00documentType";s:4:"page";s:15:"\x00*\x00realFullPath";s:35:"/de/Weiteres/Landingpages/Chevrolet";s:17:"\x00*\x00customSettings";a:0:{}}i:6244;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:"Ford Musclecars";s:12:"\x00*\x00_fragment";N;s:6:"\x00*\x00_id";s:3:"172";s:9:"\x00*\x00_class";s:0:"";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:327;s:14:"\x00*\x00_properties";a:0:{}s:21:"\x00*\x00_customHtmlAttribs";a:0:{}s:7:"\x00*\x00_uri";s:41:"/de/Weiteres/Landingpages/Ford-Musclecars";s:12:"\x00*\x00_tabindex";N;s:12:"\x00*\x00_relation";N;s:14:"\x00*\x00_documentId";i:172;s:15:"\x00*\x00documentType";s:4:"page";s:15:"\x00*\x00realFullPath";s:41:"/de/Weiteres/Landingpages/Ford-Musclecars";s:17:"\x00*\x00customSettings";a:0:{}}i:6268;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:"Vans";s:12:"\x00*\x00_fragment";N;s:6:"\x00*\x00_id";s:3:"173";s:9:"\x00*\x00_class";s:0:"";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:327;s:14:"\x00*\x00_properties";a:0:{}s:21:"\x00*\x00_customHtmlAttribs";a:0:{}s:7:"\x00*\x00_uri";s:30:"/de/Weiteres/Landingpages/Vans";s:12:"\x00*\x00_tabindex";N;s:12:"\x00*\x00_relation";N;s:14:"\x00*\x00_documentId";i:173;s:15:"\x00*\x00documentType";s:4:"page";s:15:"\x00*\x00realFullPath";s:30:"/de/Weiteres/Landingpages/Vans";s:17:"\x00*\x00customSettings";a:0:{}}i:6287;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:10:"Volkswagen";s:12:"\x00*\x00_fragment";N;s:6:"\x00*\x00_id";s:3:"174";s:9:"\x00*\x00_class";s:0:"";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:327;s:14:"\x00*\x00_properties";a:0:{}s:21:"\x00*\x00_customHtmlAttribs";a:0:{}s:7:"\x00*\x00_uri";s:36:"/de/Weiteres/Landingpages/Volkswagen";s:12:"\x00*\x00_tabindex";N;s:12:"\x00*\x00_relation";N;s:14:"\x00*\x00_documentId";i:174;s:15:"\x00*\x00documentType";s:4:"page";s:15:"\x00*\x00realFullPath";s:36:"/de/Weiteres/Landingpages/Volkswagen";s:17:"\x00*\x00customSettings";a:0:{}}}s:9:"\x00*\x00_index";a:4:{i:6196;N;i:6244;N;i:6268;N;i:6287;N;}s:14:"\x00*\x00_dirtyIndex";b:1;s:9:"\x00*\x00_label";s:13:"Landing Pages";s:12:"\x00*\x00_fragment";N;s:6:"\x00*\x00_id";s:3:"158";s:9:"\x00*\x00_class";s:0:"";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:325;s:14:"\x00*\x00_properties";a:0:{}s:21:"\x00*\x00_customHtmlAttribs";a:0:{}s:7:"\x00*\x00_uri";s:37:"/en/More-Stuff/Landingpages/Chevrolet";s:12:"\x00*\x00_tabindex";s:0:"";s:12:"\x00*\x00_relation";s:0:"";s:14:"\x00*\x00_documentId";i:158;s:15:"\x00*\x00documentType";s:4:"link";s:15:"\x00*\x00realFullPath";s:25:"/de/Weiteres/Landingpages";s:17:"\x00*\x00customSettings";a:0:{}}i:6332;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:18:"Demo Features [EN]";s:12:"\x00*\x00_fragment";N;s:6:"\x00*\x00_id";s:3:"161";s:9:"\x00*\x00_class";s:0:"";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:325;s:14:"\x00*\x00_properties";a:0:{}s:21:"\x00*\x00_customHtmlAttribs";a:0:{}s:7:"\x00*\x00_uri";s:28:"/en/More-Stuff/Demo-Features";s:12:"\x00*\x00_tabindex";s:0:"";s:12:"\x00*\x00_relation";s:0:"";s:14:"\x00*\x00_documentId";i:161;s:15:"\x00*\x00documentType";s:4:"link";s:15:"\x00*\x00realFullPath";s:26:"/de/Weiteres/Demo-Features";s:17:"\x00*\x00customSettings";a:0:{}}i:6366;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:25:"Terms and Conditions [EN]";s:12:"\x00*\x00_fragment";N;s:6:"\x00*\x00_id";s:3:"160";s:9:"\x00*\x00_class";s:0:"";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:325;s:14:"\x00*\x00_properties";a:0:{}s:21:"\x00*\x00_customHtmlAttribs";a:0:{}s:7:"\x00*\x00_uri";s:35:"/en/More-Stuff/Terms-and-Conditions";s:12:"\x00*\x00_tabindex";s:0:"";s:12:"\x00*\x00_relation";s:0:"";s:14:"\x00*\x00_documentId";i:160;s:15:"\x00*\x00documentType";s:4:"link";s:15:"\x00*\x00realFullPath";s:33:"/de/Weiteres/Terms-and-Conditions";s:17:"\x00*\x00customSettings";a:0:{}}}s:9:"\x00*\x00_index";a:3:{i:6197;N;i:6332;N;i:6366;N;}s:14:"\x00*\x00_dirtyIndex";b:1;s:9:"\x00*\x00_label";s:8:"Weiteres";s:12:"\x00*\x00_fragment";N;s:6:"\x00*\x00_id";s:3:"140";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:12:"/de/Weiteres";s:12:"\x00*\x00_tabindex";s:0:"";s:12:"\x00*\x00_relation";s:0:"";s:14:"\x00*\x00_documentId";i:140;s:15:"\x00*\x00documentType";s:4:"page";s:15:"\x00*\x00realFullPath";s:12:"/de/Weiteres";s:17:"\x00*\x00customSettings";a:0:{}}i:6363;O:32:"Pimcore\Navigation\Page\Document":25:{s:9:"\x00*\x00_pages";a:2:{i:6436;O:32:"Pimcore\Navigation\Page\Document":25:{s:9:"\x00*\x00_pages";a:1:{i:6413;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:"footer";s:12:"\x00*\x00_fragment";N;s:6:"\x00*\x00_id";s:3:"170";s:9:"\x00*\x00_class";s:0:"";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:542;s:14:"\x00*\x00_properties";a:0:{}s:21:"\x00*\x00_customHtmlAttribs";a:0:{}s:7:"\x00*\x00_uri";s:26:"/de/shared/includes/footer";s:12:"\x00*\x00_tabindex";N;s:12:"\x00*\x00_relation";N;s:14:"\x00*\x00_documentId";i:170;s:15:"\x00*\x00documentType";s:4:"page";s:15:"\x00*\x00realFullPath";s:26:"/de/shared/includes/footer";s:17:"\x00*\x00customSettings";a:0:{}}}s:9:"\x00*\x00_index";a:1:{i:6413;N;}s:14:"\x00*\x00_dirtyIndex";b:1;s:9:"\x00*\x00_label";N;s:12:"\x00*\x00_fragment";N;s:6:"\x00*\x00_id";s:3:"148";s:9:"\x00*\x00_class";s:0:"";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:540;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:148;s:15:"\x00*\x00documentType";s:6:"folder";s:15:"\x00*\x00realFullPath";s:19:"/de/shared/includes";s:17:"\x00*\x00customSettings";a:0:{}}i:6543;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:3:"149";s:9:"\x00*\x00_class";s:0:"";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:540;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:149;s:15:"\x00*\x00documentType";s:6:"folder";s:15:"\x00*\x00realFullPath";s:18:"/de/shared/teasers";s:17:"\x00*\x00customSettings";a:0:{}}}s:9:"\x00*\x00_index";a:2:{i:6436;N;i:6543;N;}s:14:"\x00*\x00_dirtyIndex";b:1;s:9:"\x00*\x00_label";N;s:12:"\x00*\x00_fragment";N;s:6:"\x00*\x00_id";s:3:"137";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:137;s:15:"\x00*\x00documentType";s:6:"folder";s:15:"\x00*\x00realFullPath";s:10:"/de/shared";s:17:"\x00*\x00customSettings";a:0:{}}i:6535;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:3:"141";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:141;s:15:"\x00*\x00documentType";s:6:"folder";s:15:"\x00*\x00realFullPath";s:9:"/de/mails";s:17:"\x00*\x00customSettings";a:0:{}}}s:9:"\x00*\x00_index";a:6:{i:5715;N;i:5741;N;i:6078;N;i:6107;N;i:6363;N;i:6535;N;}s:14:"\x00*\x00_dirtyIndex";b:1;}s:6:"output";s:6:"(è‘AÑÉ";s:10:"navigation";s:6:"î¢ôX*Ê";s:12:"document_164";s:6:"Hl´\x1A8";s:12:"document_165";s:6:"Hl´\x1A8";s:12:"document_138";s:6:"Hl´\x1A8";s:12:"document_151";s:6:"å±ñÃA\n";s:12:"document_152";s:6:"öân{ë¥";s:12:"document_153";s:6:"Hl´\x1A8";s:12:"document_154";s:6:"Hl´\x1A8";s:12:"document_155";s:6:"Hl´\x1A8";s:12:"document_156";s:6:"Hl´\x1A8";s:12:"document_157";s:6:"\x05\x1Aw?8";s:12:"document_139";s:6:"Hl´\x1A8";s:12:"document_142";s:6:"qÈž\x04Ã";s:12:"document_171";s:6:"~´ÍÞ\x04l";s:12:"document_172";s:6:"1Æk^+";s:12:"document_173";s:6:"º·-š·ù";s:12:"document_174";s:6:"Hl´\x1A8";s:12:"document_158";s:6:"Hl´\x1A8";s:12:"document_161";s:6:"ª¿4\x1Fê-";s:12:"document_160";s:6:"‘F^Ç~í";s:12:"document_140";s:6:"Hl´\x1A8";s:12:"document_170";s:6:"Hl´\x1A8";s:12:"document_148";s:6:"Hl´\x1A8";s:12:"document_149";s:6:"Hl´\x1A8";s:12:"document_137";s:6:"Hl´\x1A8";s:12:"document_141";s:6:"Hl´\x1A8";}" ] |
|
0.97 ms (1.17%) |
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:
[ 1776517566 "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.96 ms (1.16%) |
1 |
SELECT PLUGIN_CMF_COLLECT_OBJECT_SEGMENT_ASSIGNMENTS(?)
Parameters:
[
"559"
]
|
|
0.84 ms (1.01%) |
7 |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/de/shop/Fahrzeuge/Sport--Leistung/" "Sportwagen~c559" ] |
|
0.83 ms (1.00%) |
6 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"CA"
]
|
|
0.80 ms (0.97%) |
9 |
SELECT * FROM targeting_rules WHERE id = ?
Parameters:
[
1
]
|
|
0.77 ms (0.94%) |
6 |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/Customer Management/segments/calculated/Interest-Target-Groups/" "Sports-Cars-Fan" ] |
|
0.76 ms (0.92%) |
1 |
SELECT dest as `value`, count(*) as `count` FROM shop_productindex_relations a WHERE fieldname = 'manufacturer' AND src IN (SELECT a.id FROM shop_productindex a WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND `type` = 'variant' AND (parentCategoryIds LIKE '%,559,%')) GROUP BY dest
Parameters:
[] |
|
0.72 ms (0.87%) |
1 |
SELECT TRIM(`parentCategoryIds`) as `value`, count(*) as `count` FROM shop_productindex a WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND `type` = 'variant' GROUP BY TRIM(`parentCategoryIds`)
Parameters:
[] |
|
0.57 ms (0.69%) |
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:
[ "/de/shop/Fahrzeuge/Sport--Leistung/Sportwagen~c559" "path" "auto_create" "/de/shop/Fahrzeuge/Sport--Leistung/Sportwagen~c559?page=1" "path_query" "https://pimcore-dev.widdim.com/de/shop/Fahrzeuge/Sport--Leistung/Sportwagen~c559?page=1" "entire_uri" ] |
|
0.54 ms (0.65%) |
1 |
SELECT TRIM(`power`) as `value`, count(*) as `count` FROM shop_productindex a WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND `type` = 'variant' AND (parentCategoryIds LIKE '%,559,%') GROUP BY TRIM(`power`)
Parameters:
[] |
|
0.51 ms (0.62%) |
5 |
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
"/de/shop/Fahrzeuge/Sport--Leistung/Sportwagen~c559"
]
|
|
0.47 ms (0.57%) |
1 |
SELECT SQL_CALC_FOUND_ROWS a.id, priceSystemName FROM shop_productindex a WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND `type` = 'variant' AND (parentCategoryIds LIKE '%,559,%') LIMIT 22
Parameters:
[] |
|
0.46 ms (0.55%) |
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:
[ 1776517565 "object_26\x01tags\x01" "class_CAR\x01tags\x01" "asset_22\x01tags\x01" "asset_23\x01tags\x01" "asset_24\x01tags\x01" ] |
|
0.44 ms (0.53%) |
1 |
SELECT TRIM(`color`) as `value`, count(*) as `count` FROM shop_productindex a WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND `type` = 'variant' AND (parentCategoryIds LIKE '%,559,%') GROUP BY TRIM(`color`)
Parameters:
[] |
|
0.42 ms (0.50%) |
2 |
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[ 136 136 ] |
|
0.40 ms (0.48%) |
1 |
SELECT TRIM(`length`) as `value`, count(*) as `count` FROM shop_productindex a WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND `type` = 'variant' AND (parentCategoryIds LIKE '%,559,%') GROUP BY TRIM(`length`)
Parameters:
[] |
|
0.36 ms (0.44%) |
2 |
SELECT * FROM object_relations_CA WHERE src_id = ?
Parameters:
[
559
]
|
|
0.34 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:
[ 1776517566 "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.33 ms (0.40%) |
2 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?)
Parameters:
[ 1776517565 "object_97\x01tags\x01" "class_CAR\x01tags\x01" "asset_79\x01tags\x01" "asset_80\x01tags\x01" "asset_81\x01tags\x01" "asset_83\x01tags\x01" ] |
|
0.32 ms (0.39%) |
1 |
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[ 3 136 136 ] |
|
0.30 ms (0.36%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '12'
Parameters:
[] |
|
0.29 ms (0.35%) |
1 |
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[] |
|
0.29 ms (0.35%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '13'
Parameters:
[] |
|
0.28 ms (0.34%) |
2 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1776517566 "document_161\x01tags\x01" "document_94\x01tags\x01" "asset_337\x01tags\x01" "asset_340\x01tags\x01" "asset_341\x01tags\x01" "asset_361\x01tags\x01" "asset_362\x01tags\x01" ] |
|
0.27 ms (0.33%) |
1 |
SELECT id FROM sites ORDER BY (SELECT LENGTH(CONCAT(`path`, `key`)) FROM documents WHERE documents.id = sites.rootId) DESC
Parameters:
[] |
|
0.27 ms (0.33%) |
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.23 ms (0.28%) |
1 |
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[] |
|
0.21 ms (0.26%) |
1 |
SELECT objects.id as id, objects.type as `type` FROM objects WHERE (parentId = ? AND objects.type IN ('object','variant','folder')) AND objects.published = 1 ORDER BY `key` ASC
Parameters:
[
559
]
|
|
0.21 ms (0.25%) |
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:
[ 1776517565 "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.19 ms (0.23%) |
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:
[ 1776517566 "document_48\x01tags\x01" "asset_62\x01tags\x01" "asset_63\x01tags\x01" "asset_321\x01tags\x01" "asset_319\x01tags\x01" "asset_362\x01tags\x01" "asset_340\x01tags\x01" "asset_317\x01tags\x01" ] |
|
0.19 ms (0.23%) |
1 |
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
136
]
|
|
0.17 ms (0.20%) |
1 |
SELECT id FROM ecommerceframework_pricing_rule WHERE active = 1 ORDER BY `prio` ASC
Parameters:
[] |
|
0.16 ms (0.19%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '25'
Parameters:
[] |
|
0.15 ms (0.19%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '138'
Parameters:
[] |
|
0.15 ms (0.19%) |
1 |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='6'
Parameters:
[] |
|
0.15 ms (0.19%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '14'
Parameters:
[] |
|
0.15 ms (0.18%) |
1 |
SELECT id FROM targeting_rules WHERE active = 1 ORDER BY `prio` ASC
Parameters:
[] |
|
0.14 ms (0.18%) |
1 |
SELECT * FROM object_relations_EF_FD WHERE src_id = ?
Parameters:
[
762
]
|
|
0.14 ms (0.18%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '98'
Parameters:
[] |
|
0.14 ms (0.18%) |
1 |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
170
]
|
|
0.14 ms (0.17%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '15'
Parameters:
[] |
|
0.14 ms (0.17%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '143'
Parameters:
[] |
|
0.14 ms (0.17%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '126'
Parameters:
[] |
|
0.14 ms (0.17%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '16'
Parameters:
[] |
|
0.14 ms (0.17%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '69'
Parameters:
[] |
|
0.14 ms (0.17%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '70'
Parameters:
[] |
|
0.14 ms (0.16%) |
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:
[ 1776517566 "document_49\x01tags\x01" "asset_252\x01tags\x01" "asset_250\x01tags\x01" "asset_249\x01tags\x01" "asset_251\x01tags\x01" "asset_115\x01tags\x01" "asset_117\x01tags\x01" "asset_114\x01tags\x01" "asset_35\x01tags\x01" "asset_36\x01tags\x01" "asset_41\x01tags\x01" ] |
|
0.13 ms (0.16%) |
1 |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='10'
Parameters:
[] |
|
0.13 ms (0.16%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '33'
Parameters:
[] |
|
0.13 ms (0.16%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '38'
Parameters:
[] |
|
0.13 ms (0.16%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '34'
Parameters:
[] |
|
0.13 ms (0.16%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '124'
Parameters:
[] |
|
0.13 ms (0.16%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '139'
Parameters:
[] |
|
0.13 ms (0.16%) |
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:
[ 1776517566 "document_110\x01tags\x01" "document_104\x01tags\x01" "document_54\x01tags\x01" "document_55\x01tags\x01" "document_56\x01tags\x01" "document_57\x01tags\x01" "object_548\x01tags\x01" "object_561\x01tags\x01" "object_551\x01tags\x01" "object_550\x01tags\x01" "asset_390\x01tags\x01" "asset_391\x01tags\x01" "asset_392\x01tags\x01" "asset_389\x01tags\x01" ] |
|
0.13 ms (0.16%) |
1 |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='7'
Parameters:
[] |
|
0.13 ms (0.16%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '82'
Parameters:
[] |
|
0.13 ms (0.16%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '125'
Parameters:
[] |
|
0.13 ms (0.15%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '24'
Parameters:
[] |
|
0.13 ms (0.15%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '26'
Parameters:
[] |
|
0.12 ms (0.15%) |
1 |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='8'
Parameters:
[] |
|
0.12 ms (0.15%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '97'
Parameters:
[] |
|
0.12 ms (0.14%) |
1 |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
|
0.11 ms (0.13%) |
1 |
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
2
]
|
|
0.10 ms (0.13%) |
1 |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='9'
Parameters:
[] |
|
0.10 ms (0.12%) |
1 |
SELECT * FROM translations_admin LIMIT 1;
Parameters:
[] |
|
0.08 ms (0.09%) |
1 |
SELECT FOUND_ROWS()
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| pimcore | doctrine.orm.pimcore_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
pimcore entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
No loaded entities.