Query Metrics
523
Database Queries
96
Different statements
126.17 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
33.81 ms (26.79%) |
149 |
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:
[ 1792177925 "site_domain_08c9285288c95f34da193e1771efe8f1" ] |
|
15.47 ms (12.26%) |
70 |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
|
13.58 ms (10.76%) |
55 |
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:
[ 1792177925 "system\x01tags\x01" "site\x01tags\x01" ] |
|
5.44 ms (4.32%) |
22 |
SELECT * FROM object_relations_AP WHERE src_id = ?
Parameters:
[
415
]
|
|
5.29 ms (4.19%) |
20 |
SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ?
Parameters:
[
415
]
|
|
4.34 ms (3.44%) |
16 |
SELECT * FROM object_localized_data_AP WHERE ooo_id = ? AND language IN ('de','en','fr','es','it')
Parameters:
[
415
]
|
|
3.95 ms (3.13%) |
20 |
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
Parameters:
[
415
]
|
|
3.94 ms (3.12%) |
16 |
SELECT * FROM object_store_AP WHERE oo_id = ?
Parameters:
[
415
]
|
|
3.73 ms (2.96%) |
16 |
SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ?
Parameters:
[
250
]
|
|
3.48 ms (2.76%) |
16 |
SELECT * FROM object_brick_store_SaleInformation_AP WHERE id = ? AND fieldname = ?
Parameters:
[ 415 "saleInformation" ] |
|
1.21 ms (0.96%) |
5 |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/en/shop/Products/Spare-Parts/" "Rims~c397" ] |
|
1.20 ms (0.95%) |
5 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"CA"
]
|
|
1.13 ms (0.90%) |
4 |
SELECT * FROM object_localized_data_CAR WHERE ooo_id = ? AND language IN ('de','en','fr','es','it')
Parameters:
[
73
]
|
|
1.06 ms (0.84%) |
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.95 ms (0.75%) |
4 |
SELECT * FROM object_relations_CAR WHERE src_id = ?
Parameters:
[
73
]
|
|
0.94 ms (0.74%) |
4 |
SELECT * FROM object_brick_store_Dimensions_CAR WHERE id = ? AND fieldname = ?
Parameters:
[ 73 "attributes" ] |
|
0.92 ms (0.73%) |
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 '%,397,%')) GROUP BY dest
Parameters:
[] |
|
0.89 ms (0.71%) |
4 |
SELECT * FROM object_brick_store_Engine_CAR WHERE id = ? AND fieldname = ?
Parameters:
[ 73 "attributes" ] |
|
0.88 ms (0.70%) |
4 |
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
"/en/shop/Products/Spare-Parts/Rims~c397"
]
|
|
0.85 ms (0.68%) |
4 |
SELECT * FROM object_brick_store_Bodywork_CAR WHERE id = ? AND fieldname = ?
Parameters:
[ 73 "attributes" ] |
|
0.84 ms (0.67%) |
4 |
SELECT * FROM object_brick_store_Transmission_CAR WHERE id = ? AND fieldname = ?
Parameters:
[ 73 "attributes" ] |
|
0.84 ms (0.67%) |
4 |
SELECT * FROM object_brick_store_SaleInformation_CAR WHERE id = ? AND fieldname = ?
Parameters:
[ 73 "saleInformation" ] |
|
0.84 ms (0.66%) |
4 |
SELECT * FROM object_store_CAR WHERE oo_id = ?
Parameters:
[
73
]
|
|
0.68 ms (0.54%) |
1 |
SELECT TRIM(`milage`) as `value`, count(*) as `count` FROM shop_productindex a WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND `type` = 'variant' AND (parentCategoryIds LIKE '%,397,%') GROUP BY TRIM(`milage`)
Parameters:
[] |
|
0.66 ms (0.53%) |
1 |
SELECT * FROM object_classificationstore_data_AP WHERE id = 455 AND fieldname = 'technicalAttributes'
Parameters:
[] |
|
0.62 ms (0.49%) |
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 '%,397,%') LIMIT 22
Parameters:
[] |
|
0.58 ms (0.46%) |
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:
[ 1792177925 "system\x01tags\x01" "redirect\x01tags\x01" "route\x01tags\x01" ] |
|
0.51 ms (0.40%) |
2 |
SELECT * FROM object_relations_CA WHERE src_id = ?
Parameters:
[
397
]
|
|
0.46 ms (0.36%) |
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 AND priority = 99 ORDER BY `priority` DESC
Parameters:
[ "/en/shop/Products/Spare-Parts/Rims~c397" "path" "auto_create" "/en/shop/Products/Spare-Parts/Rims~c397" "path_query" "https://apimga.mysportapp.ch/en/shop/Products/Spare-Parts/Rims~c397" "entire_uri" ] |
|
0.43 ms (0.34%) |
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.37 ms (0.30%) |
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:
[
397
]
|
|
0.31 ms (0.24%) |
1 |
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[] |
|
0.29 ms (0.23%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '377'
Parameters:
[] |
|
0.29 ms (0.23%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '403'
Parameters:
[] |
|
0.28 ms (0.22%) |
1 |
SELECT * FROM object_classificationstore_data_AP WHERE id = 415 AND fieldname = 'technicalAttributes'
Parameters:
[] |
|
0.28 ms (0.22%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '477'
Parameters:
[] |
|
0.27 ms (0.22%) |
1 |
SELECT * FROM object_classificationstore_data_AP WHERE id = 469 AND fieldname = 'technicalAttributes'
Parameters:
[] |
|
0.27 ms (0.22%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '386'
Parameters:
[] |
|
0.27 ms (0.22%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '410'
Parameters:
[] |
|
0.27 ms (0.21%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '415'
Parameters:
[] |
|
0.27 ms (0.21%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '448'
Parameters:
[] |
|
0.27 ms (0.21%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '470'
Parameters:
[] |
|
0.27 ms (0.21%) |
1 |
SELECT * FROM object_classificationstore_groups_AP WHERE id = 415 AND fieldname = 'technicalAttributes'
Parameters:
[] |
|
0.27 ms (0.21%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '378'
Parameters:
[] |
|
0.26 ms (0.21%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '455'
Parameters:
[] |
|
0.26 ms (0.21%) |
1 |
SELECT * FROM object_classificationstore_data_AP WHERE id = 445 AND fieldname = 'technicalAttributes'
Parameters:
[] |
|
0.26 ms (0.21%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '434'
Parameters:
[] |
|
0.26 ms (0.21%) |
1 |
SELECT * FROM object_classificationstore_data_AP WHERE id = 470 AND fieldname = 'technicalAttributes'
Parameters:
[] |
|
0.26 ms (0.21%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '423'
Parameters:
[] |
|
0.26 ms (0.21%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '444'
Parameters:
[] |
|
0.26 ms (0.21%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '431'
Parameters:
[] |
|
0.26 ms (0.21%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '469'
Parameters:
[] |
|
0.26 ms (0.21%) |
1 |
SELECT * FROM object_classificationstore_data_AP WHERE id = 477 AND fieldname = 'technicalAttributes'
Parameters:
[] |
|
0.26 ms (0.21%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '435'
Parameters:
[] |
|
0.26 ms (0.21%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '457'
Parameters:
[] |
|
0.26 ms (0.20%) |
1 |
SELECT id FROM ecommerceframework_pricing_rule WHERE active = 1 ORDER BY `prio` ASC
Parameters:
[] |
|
0.26 ms (0.20%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '425'
Parameters:
[] |
|
0.26 ms (0.20%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '426'
Parameters:
[] |
|
0.26 ms (0.20%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '437'
Parameters:
[] |
|
0.26 ms (0.20%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '445'
Parameters:
[] |
|
0.26 ms (0.20%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '449'
Parameters:
[] |
|
0.26 ms (0.20%) |
1 |
SELECT * FROM object_classificationstore_data_AP WHERE id = 457 AND fieldname = 'technicalAttributes'
Parameters:
[] |
|
0.26 ms (0.20%) |
1 |
SELECT * FROM object_classificationstore_data_AP WHERE id = 423 AND fieldname = 'technicalAttributes'
Parameters:
[] |
|
0.26 ms (0.20%) |
1 |
SELECT * FROM object_relations_EF_FD WHERE src_id = ?
Parameters:
[
760
]
|
|
0.25 ms (0.20%) |
1 |
SELECT * FROM object_classificationstore_data_AP WHERE id = 431 AND fieldname = 'technicalAttributes'
Parameters:
[] |
|
0.25 ms (0.20%) |
1 |
SELECT * FROM object_classificationstore_groups_AP WHERE id = 423 AND fieldname = 'technicalAttributes'
Parameters:
[] |
|
0.25 ms (0.20%) |
1 |
SELECT * FROM object_classificationstore_data_AP WHERE id = 426 AND fieldname = 'technicalAttributes'
Parameters:
[] |
|
0.25 ms (0.20%) |
1 |
SELECT * FROM object_classificationstore_data_AP WHERE id = 425 AND fieldname = 'technicalAttributes'
Parameters:
[] |
|
0.25 ms (0.20%) |
1 |
SELECT * FROM object_classificationstore_groups_AP WHERE id = 426 AND fieldname = 'technicalAttributes'
Parameters:
[] |
|
0.25 ms (0.20%) |
1 |
SELECT * FROM object_classificationstore_groups_AP WHERE id = 434 AND fieldname = 'technicalAttributes'
Parameters:
[] |
|
0.25 ms (0.20%) |
1 |
SELECT * FROM object_classificationstore_data_AP WHERE id = 437 AND fieldname = 'technicalAttributes'
Parameters:
[] |
|
0.25 ms (0.20%) |
1 |
SELECT * FROM object_classificationstore_groups_AP WHERE id = 425 AND fieldname = 'technicalAttributes'
Parameters:
[] |
|
0.25 ms (0.20%) |
1 |
SELECT * FROM object_classificationstore_groups_AP WHERE id = 431 AND fieldname = 'technicalAttributes'
Parameters:
[] |
|
0.25 ms (0.20%) |
1 |
SELECT * FROM object_classificationstore_data_AP WHERE id = 434 AND fieldname = 'technicalAttributes'
Parameters:
[] |
|
0.25 ms (0.20%) |
1 |
SELECT * FROM object_classificationstore_data_AP WHERE id = 435 AND fieldname = 'technicalAttributes'
Parameters:
[] |
|
0.25 ms (0.20%) |
1 |
SELECT * FROM object_classificationstore_data_AP WHERE id = 444 AND fieldname = 'technicalAttributes'
Parameters:
[] |
|
0.25 ms (0.20%) |
1 |
SELECT * FROM object_classificationstore_data_AP WHERE id = 448 AND fieldname = 'technicalAttributes'
Parameters:
[] |
|
0.24 ms (0.19%) |
1 |
SELECT * FROM object_classificationstore_groups_AP WHERE id = 435 AND fieldname = 'technicalAttributes'
Parameters:
[] |
|
0.24 ms (0.19%) |
1 |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/Product Data/Accessories/lights/head lights/" "citroen-2cv-head lights" ] |
|
0.24 ms (0.19%) |
1 |
SELECT * FROM object_classificationstore_groups_AP WHERE id = 444 AND fieldname = 'technicalAttributes'
Parameters:
[] |
|
0.24 ms (0.19%) |
1 |
SELECT * FROM object_classificationstore_groups_AP WHERE id = 455 AND fieldname = 'technicalAttributes'
Parameters:
[] |
|
0.23 ms (0.19%) |
1 |
SELECT * FROM object_classificationstore_groups_AP WHERE id = 448 AND fieldname = 'technicalAttributes'
Parameters:
[] |
|
0.23 ms (0.18%) |
1 |
SELECT * FROM object_classificationstore_groups_AP WHERE id = 445 AND fieldname = 'technicalAttributes'
Parameters:
[] |
|
0.23 ms (0.18%) |
1 |
SELECT * FROM object_classificationstore_groups_AP WHERE id = 469 AND fieldname = 'technicalAttributes'
Parameters:
[] |
|
0.23 ms (0.18%) |
1 |
SELECT * FROM object_classificationstore_groups_AP WHERE id = 470 AND fieldname = 'technicalAttributes'
Parameters:
[] |
|
0.23 ms (0.18%) |
1 |
SELECT * FROM object_classificationstore_groups_AP WHERE id = 477 AND fieldname = 'technicalAttributes'
Parameters:
[] |
|
0.23 ms (0.18%) |
1 |
SELECT * FROM object_classificationstore_groups_AP WHERE id = 437 AND fieldname = 'technicalAttributes'
Parameters:
[] |
|
0.23 ms (0.18%) |
1 |
SELECT * FROM object_classificationstore_groups_AP WHERE id = 457 AND fieldname = 'technicalAttributes'
Parameters:
[] |
|
0.23 ms (0.18%) |
1 |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='10'
Parameters:
[] |
|
0.22 ms (0.17%) |
1 |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='6'
Parameters:
[] |
|
0.22 ms (0.17%) |
1 |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='9'
Parameters:
[] |
|
0.21 ms (0.17%) |
1 |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
|
0.21 ms (0.17%) |
1 |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='8'
Parameters:
[] |
|
0.21 ms (0.17%) |
1 |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='7'
Parameters:
[] |
|
0.21 ms (0.17%) |
1 |
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
2
]
|
|
0.16 ms (0.12%) |
1 |
SELECT FOUND_ROWS()
Parameters:
[] |
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.