Query Metrics
233
Database Queries
29
Different statements
174.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
47.18 ms (27.11%) |
87 |
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:
[ 1765889227 "site_domain_942b1d6ede7c64e4fd7ff5191847fc72" ] |
|
34.25 ms (19.68%) |
56 |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
|
19.04 ms (10.94%) |
28 |
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:
[ 1765889227 "system\x01tags\x01" "redirect\x01tags\x01" "route\x01tags\x01" ] |
|
12.93 ms (7.43%) |
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 => 1765889228 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:4037;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:3543;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:4078;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:4107;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:4127;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:4156;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:4185;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:4037;N;i:3543;N;i:4078;N;i:4107;N;i:4127;N;i:4156;N;i:4185;N;}s:14:"\x00*\x00_dirtyIndex";b:1;}s:6:"output";s:6:"곟¦É\x11";s:10:"navigation";s:6:"µhØí";s:12:"document_151";s:6:"úy¹`<x";s:12:"document_152";s:6:"àUšªÇÎ";s:12:"document_153";s:6:"àUšªÇÎ";s:12:"document_154";s:6:"àUšªÇÎ";s:12:"document_155";s:6:"àUšªÇÎ";s:12:"document_156";s:6:"àUšªÇÎ";s:12:"document_157";s:6:"àUšªÇÎ";}" ] |
|
12.31 ms (7.07%) |
21 |
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:
[ 1765889227 "system\x01tags\x01" "site\x01tags\x01" ] |
|
11.83 ms (6.80%) |
1 |
SELECT object_localized_BS_de.id AS id, object_localized_BS_de.type AS `type` FROM object_localized_BS_de WHERE ( object_localized_BS_de.type IN ('object','variant','folder')) AND object_localized_BS_de.published = 1
Parameters:
[] |
|
5.40 ms (3.10%) |
1 |
DELETE FROM cache_items WHERE item_lifetime + item_time <= ? AND item_id IN (?)
Parameters:
[ 1765889228 "nav_f2fcd049e74170a46afd8203f2136185" ] |
|
5.19 ms (2.98%) |
8 |
SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1
Parameters:
[
139
]
|
|
3.96 ms (2.28%) |
4 |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
157
]
|
|
3.79 ms (2.18%) |
3 |
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-einstellen" "path" "auto_create" "/de/Magazin/Auto-einstellen" "path_query" "http://cdp.samparkme.com/de/Magazin/Auto-einstellen?q=/de/Magazin/Auto-einstellen" "entire_uri" ] |
|
2.87 ms (1.65%) |
1 |
SELECT object_MA.id AS id, object_MA.type AS `type` FROM object_MA WHERE ( object_MA.type IN ('object','variant','folder')) AND object_MA.published = 1
Parameters:
[] |
|
2.27 ms (1.30%) |
4 |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/de/Magazin/" "Auto-einstellen" ] |
|
1.45 ms (0.84%) |
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:
[ 1765889228 "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" ] |
|
1.13 ms (0.65%) |
1 |
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
317
]
|
|
1.05 ms (0.60%) |
2 |
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId AS id,"source" FROM documents_translations WHERE id = ?
Parameters:
[ 157 157 ] |
|
1.02 ms (0.58%) |
1 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"BS"
]
|
|
1.01 ms (0.58%) |
1 |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
317
]
|
|
0.88 ms (0.51%) |
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:
[ 1765889228 "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.70 ms (0.40%) |
1 |
SELECT * FROM object_url_slugs WHERE slug = '/de/Magazin/Auto-einstellen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[] |
|
0.69 ms (0.40%) |
1 |
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId AS id,"source" FROM documents_translations WHERE id = ?
Parameters:
[ 123 157 157 ] |
|
0.65 ms (0.37%) |
1 |
SELECT id FROM sites ORDER BY (SELECT LENGTH(`path`) FROM documents WHERE documents.id = sites.rootId) DESC
Parameters:
[] |
|
0.64 ms (0.37%) |
1 |
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[] |
|
0.63 ms (0.36%) |
1 |
SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC
Parameters:
[
139
]
|
|
0.62 ms (0.36%) |
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:
[ 1765889228 "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.61 ms (0.35%) |
1 |
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
"/fr"
]
|
|
0.59 ms (0.34%) |
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:
[ 1765889228 "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.50 ms (0.29%) |
1 |
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
157
]
|
|
0.43 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:
[ 1765889228 "document_152\x01tags\x01" "document_57\x01tags\x01" "document_54\x01tags\x01" "document_55\x01tags\x01" ] |
|
0.41 ms (0.23%) |
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.
Entities Mapping
No mapped entities.