Query Metrics
225
Database Queries
29
Different statements
66.78 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
43.34 ms (64.91%) |
114 |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1727612687 [ "site_domain_8771fb7f0c12dcaa7573183039da1f66" ] ] |
8.28 ms (12.40%) |
54 |
SELECT * FROM object_relations_AP WHERE src_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[ 487 "manufacturer" ] |
1.58 ms (2.37%) |
6 |
SELECT id FROM documents WHERE path = :path AND `key` = :key
Parameters:
[ "key" => "Lights~c393" "path" => "/en/shop/Products/Spare-Parts/" ] |
1.36 ms (2.04%) |
9 |
SELECT * FROM targeting_rules WHERE id = ?
Parameters:
[
1
]
|
1.31 ms (1.96%) |
6 |
SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key
Parameters:
[ "key" => "Sports-Cars-Fan" "path" => "/Customer Management/segments/calculated/Interest-Target-Groups/" ] |
1.26 ms (1.89%) |
1 |
SELECT dest as `value`, count(*) as `count` FROM shop_productindex_relations a WHERE fieldname = 'manufacturer' AND src IN (SELECT a.o_id FROM shop_productindex a WHERE active = 1 AND o_virtualProductActive = 1 AND inProductList = 1 AND o_type = 'variant' AND (parentCategoryIds LIKE '%,393,%')) GROUP BY dest
Parameters:
[] |
1.20 ms (1.79%) |
5 |
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[ "prettyUrl" => "/en/shop/Products/Spare-Parts/Lights~c393" ] |
0.97 ms (1.45%) |
1 |
SELECT TRIM(`milage`) as `value`, count(*) as `count` FROM shop_productindex a WHERE active = 1 AND o_virtualProductActive = 1 AND inProductList = 1 AND o_type = 'variant' AND (parentCategoryIds LIKE '%,393,%') GROUP BY TRIM(`milage`)
Parameters:
[] |
0.84 ms (1.26%) |
1 |
SELECT count(*) FROM shop_productindex a WHERE active = 1 AND o_virtualProductActive = 1 AND inProductList = 1 AND o_type = 'variant' AND (parentCategoryIds LIKE '%,393,%')
Parameters:
[] |
0.80 ms (1.20%) |
1 |
SELECT PLUGIN_CMF_COLLECT_DOCUMENT_SEGMENT_ASSIGNMENTS(:elementId)
Parameters:
[ "elementId" => 3 ] |
0.76 ms (1.14%) |
5 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"CA"
]
|
0.75 ms (1.12%) |
1 |
SELECT SQL_CALC_FOUND_ROWS a.o_id, priceSystemName FROM shop_productindex a WHERE active = 1 AND o_virtualProductActive = 1 AND inProductList = 1 AND o_type = 'variant' AND (parentCategoryIds LIKE '%,393,%') LIMIT 54, 18
Parameters:
[] |
0.71 ms (1.06%) |
1 |
SELECT PLUGIN_CMF_COLLECT_OBJECT_SEGMENT_ASSIGNMENTS(:elementId)
Parameters:
[ "elementId" => 393 ] |
0.69 ms (1.04%) |
1 |
SELECT `objects`.* FROM `objects` WHERE ((o_parentId = ? AND objects.o_type IN ('object','folder')) AND objects.o_published = 1) ORDER BY `o_key` ASC
Parameters:
[
393
]
|
0.47 ms (0.70%) |
3 |
SELECT * FROM object_relations_EF_FD WHERE src_id = ? AND fieldname = ? AND ownertype = 'fieldcollection' AND ownername = ? AND position = ?
Parameters:
[ 760 "availableCategories" "filters" 0 ] |
0.34 ms (0.50%) |
2 |
SELECT * FROM object_relations_CA WHERE src_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[ 393 "filterDefinition" ] |
0.30 ms (0.45%) |
2 |
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[] |
0.19 ms (0.29%) |
1 |
SELECT * FROM documents_elements WHERE documentId = ?
Parameters:
[
12
]
|
0.17 ms (0.26%) |
1 |
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
1
]
|
0.16 ms (0.25%) |
1 |
SELECT id FROM targeting_rules WHERE active = 1 ORDER BY `prio` ASC
Parameters:
[] |
0.16 ms (0.23%) |
1 |
SELECT FOUND_ROWS()
Parameters:
[] |
0.15 ms (0.23%) |
1 |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='8'
Parameters:
[] |
0.15 ms (0.22%) |
1 |
SELECT TRIM(`parentCategoryIds`) as `value`, count(*) as `count` FROM shop_productindex a WHERE active = 1 AND o_virtualProductActive = 1 AND inProductList = 1 AND o_type = 'variant' GROUP BY TRIM(`parentCategoryIds`)
Parameters:
[] |
0.14 ms (0.21%) |
1 |
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[ 1 1 1 ] |
0.14 ms (0.21%) |
1 |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='7'
Parameters:
[] |
0.14 ms (0.21%) |
1 |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='9'
Parameters:
[] |
0.14 ms (0.21%) |
1 |
SELECT id FROM ecommerceframework_pricing_rule WHERE active = 1 ORDER BY `prio` ASC
Parameters:
[] |
0.14 ms (0.21%) |
1 |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='10'
Parameters:
[] |
0.14 ms (0.21%) |
1 |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='6'
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.