Query Metrics
1330
Database Queries
94
Different statements
278.11 ms
Query time
0
Invalid entities
0
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
96.28 ms (34.62%) |
555 |
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:
[ 1795068769 "system\x01tags\x01" "site\x01tags\x01" ] |
|
78.39 ms (28.19%) |
580 |
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:
[ 1795068769 "site_domain_4f930081e51b1292b273d5c8aa2ea076" ] |
|
48.42 ms (17.41%) |
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:
[
1086
]
|
|
10.45 ms (3.76%) |
8 |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] |
|
9.04 ms (3.25%) |
1 |
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
136
]
|
|
7.86 ms (2.83%) |
60 |
SELECT * FROM object_relations_CAR WHERE src_id = ?
Parameters:
[
63133
]
|
|
3.86 ms (1.39%) |
2 |
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[] |
|
3.07 ms (1.10%) |
9 |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/page/de/shop/Produkte/" "Jaguar-XK15055283~p63133" ] |
|
1.20 ms (0.43%) |
8 |
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
"/page/de/shop/Produkte/Jaguar-XK15055283~p63133"
]
|
|
1.10 ms (0.40%) |
2 |
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[ 136 136 ] |
|
0.97 ms (0.35%) |
9 |
SELECT * FROM targeting_rules WHERE id = ?
Parameters:
[
1
]
|
|
0.79 ms (0.28%) |
6 |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/Customer Management/segments/calculated/Interest-Target-Groups/" "Sports-Cars-Fan" ] |
|
0.64 ms (0.23%) |
1 |
SELECT COUNT(*) FROM object_1 WHERE reference = ? and (calculated = 1) AND object_1.type IN ('object','variant','folder')
Parameters:
[
"Interest Car Class"
]
|
|
0.56 ms (0.20%) |
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:
[ 1795068769 "system\x01tags\x01" "redirect\x01tags\x01" "route\x01tags\x01" ] |
|
0.54 ms (0.19%) |
4 |
SELECT `id`, `name` FROM classes WHERE id = ?
Parameters:
[
"CAR"
]
|
|
0.53 ms (0.19%) |
3 |
SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
Parameters:
[ "/page/%" "/de/shop/Produkte/Jaguar-XK15055283~p63133" ] |
|
0.47 ms (0.17%) |
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.42 ms (0.15%) |
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 IS NULL OR sourceSite = 5) AND priority = 99 ORDER BY `priority` DESC
Parameters:
[ "/de/shop/Produkte/Jaguar-XK15055283~p63133" "path" "auto_create" "/de/shop/Produkte/Jaguar-XK15055283~p63133" "path_query" "https://siga.go4d.ch/de/shop/Produkte/Jaguar-XK15055283~p63133" "entire_uri" ] |
|
0.37 ms (0.13%) |
1 |
SELECT COUNT(*) FROM object_2 WHERE (reference = ?) AND (group__id = ?) AND object_2.type IN ('object','variant','folder')
Parameters:
[ "sports car" 962 ] |
|
0.35 ms (0.13%) |
1 |
SELECT object_1.id as id, object_1.type as `type` FROM object_1 WHERE reference = ? and (calculated = 1) AND object_1.type IN ('object','variant','folder')
Parameters:
[
"Interest Car Class"
]
|
|
0.33 ms (0.12%) |
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 IS NULL OR sourceSite = 0) AND priority = 99 ORDER BY `priority` DESC
Parameters:
[ "/de/shop/Produkte/Jaguar-XK15055283~p63133" "path" "auto_create" "/de/shop/Produkte/Jaguar-XK15055283~p63133" "path_query" "https://siga.go4d.ch/de/shop/Produkte/Jaguar-XK15055283~p63133" "entire_uri" ] |
|
0.32 ms (0.12%) |
1 |
SELECT object_2.id as id, object_2.type as `type` FROM object_2 WHERE (reference = ?) AND (group__id = ?) AND object_2.type IN ('object','variant','folder')
Parameters:
[ "sports car" 962 ] |
|
0.29 ms (0.10%) |
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:
[ 1795068770 "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" "document_223\x01tags\x01" "document_222\x01tags\x01" ] |
|
0.28 ms (0.10%) |
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.24 ms (0.09%) |
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:
[ 1795068770 "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.23 ms (0.08%) |
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:
[ 1795068769 "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.21 ms (0.08%) |
1 |
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[] |
|
0.20 ms (0.07%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '105669'
Parameters:
[] |
|
0.20 ms (0.07%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '94002'
Parameters:
[] |
|
0.19 ms (0.07%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '63133'
Parameters:
[] |
|
0.19 ms (0.07%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '107652'
Parameters:
[] |
|
0.18 ms (0.07%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '183679'
Parameters:
[] |
|
0.18 ms (0.06%) |
1 |
SELECT id FROM ecommerceframework_pricing_rule WHERE active = 1 ORDER BY `prio` ASC
Parameters:
[] |
|
0.18 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '125828'
Parameters:
[] |
|
0.17 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '129224'
Parameters:
[] |
|
0.17 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '102049'
Parameters:
[] |
|
0.17 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '128658'
Parameters:
[] |
|
0.17 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '41734'
Parameters:
[] |
|
0.17 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '110169'
Parameters:
[] |
|
0.17 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '62387'
Parameters:
[] |
|
0.17 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '156406'
Parameters:
[] |
|
0.17 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '118602'
Parameters:
[] |
|
0.17 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '138376'
Parameters:
[] |
|
0.17 ms (0.06%) |
1 |
SELECT id FROM targeting_rules WHERE active = 1 ORDER BY `prio` ASC
Parameters:
[] |
|
0.17 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '108698'
Parameters:
[] |
|
0.17 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '113001'
Parameters:
[] |
|
0.17 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '74709'
Parameters:
[] |
|
0.17 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '150552'
Parameters:
[] |
|
0.17 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '158388'
Parameters:
[] |
|
0.17 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '90490'
Parameters:
[] |
|
0.16 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '48399'
Parameters:
[] |
|
0.16 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '137810'
Parameters:
[] |
|
0.16 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '166410'
Parameters:
[] |
|
0.16 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '91056'
Parameters:
[] |
|
0.16 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '118036'
Parameters:
[] |
|
0.16 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '120536'
Parameters:
[] |
|
0.16 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '183396'
Parameters:
[] |
|
0.16 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '103687'
Parameters:
[] |
|
0.16 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '46418'
Parameters:
[] |
|
0.16 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '138093'
Parameters:
[] |
|
0.16 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '153100'
Parameters:
[] |
|
0.16 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '138942'
Parameters:
[] |
|
0.16 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '154516'
Parameters:
[] |
|
0.16 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '109603'
Parameters:
[] |
|
0.16 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '113284'
Parameters:
[] |
|
0.16 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '119365'
Parameters:
[] |
|
0.16 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '37419'
Parameters:
[] |
|
0.16 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '40815'
Parameters:
[] |
|
0.16 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '50401'
Parameters:
[] |
|
0.16 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '28552'
Parameters:
[] |
|
0.16 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '161692'
Parameters:
[] |
|
0.16 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '146963'
Parameters:
[] |
|
0.16 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '63699'
Parameters:
[] |
|
0.16 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '87660'
Parameters:
[] |
|
0.16 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '95700'
Parameters:
[] |
|
0.16 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '121951'
Parameters:
[] |
|
0.16 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '184528'
Parameters:
[] |
|
0.16 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '84712'
Parameters:
[] |
|
0.16 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '128941'
Parameters:
[] |
|
0.16 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '49835'
Parameters:
[] |
|
0.16 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '173958'
Parameters:
[] |
|
0.16 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '54286'
Parameters:
[] |
|
0.16 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '124977'
Parameters:
[] |
|
0.16 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '45852'
Parameters:
[] |
|
0.16 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '63982'
Parameters:
[] |
|
0.16 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '46984'
Parameters:
[] |
|
0.15 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '140830'
Parameters:
[] |
|
0.15 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '61255'
Parameters:
[] |
|
0.15 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '105103'
Parameters:
[] |
|
0.13 ms (0.05%) |
1 |
SELECT * FROM ecommerceframework_pricing_rule WHERE id=8
Parameters:
[] |
|
0.13 ms (0.05%) |
1 |
SELECT * FROM ecommerceframework_pricing_rule WHERE id=10
Parameters:
[] |
|
0.12 ms (0.04%) |
1 |
SELECT * FROM ecommerceframework_pricing_rule WHERE id=7
Parameters:
[] |
|
0.12 ms (0.04%) |
1 |
SELECT * FROM ecommerceframework_pricing_rule WHERE id=6
Parameters:
[] |
|
0.11 ms (0.04%) |
1 |
SELECT * FROM ecommerceframework_pricing_rule WHERE id=9
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
No loaded entities.