Query Metrics
163
Database Queries
27
Different statements
47.33 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
30.59 ms (64.63%) |
79 |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1727605667 [ "site_domain_8771fb7f0c12dcaa7573183039da1f66" ] ] |
1.87 ms (3.94%) |
12 |
SELECT * FROM object_relations_AP WHERE src_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[ 484 "manufacturer" ] |
1.73 ms (3.65%) |
7 |
SELECT id FROM documents WHERE path = :path AND `key` = :key
Parameters:
[ "key" => "Mercedes-Benz-W110~p346" "path" => "/en/shop/Products/Cars/Luxury-Cars/" ] |
1.64 ms (3.47%) |
10 |
SELECT * FROM object_relations_CAR WHERE src_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[ 346 "categories" ] |
1.41 ms (2.97%) |
9 |
SELECT * FROM targeting_rules WHERE id = ?
Parameters:
[
1
]
|
1.37 ms (2.89%) |
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.36 ms (2.87%) |
6 |
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[ "prettyUrl" => "/en/shop/Products/Cars/Luxury-Cars/Mercedes-Benz-W110~p346" ] |
1.03 ms (2.17%) |
2 |
SELECT COUNT(*) AS `totalCount` FROM `object_localized_AP_en` WHERE ((compatibleTo LIKE "%,346,%" OR compatibleTo LIKE "%,345,%" AND object_localized_AP_en.o_type IN ('object','folder')) AND object_localized_AP_en.o_published = 1)
Parameters:
[] |
0.81 ms (1.71%) |
5 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"CAR"
]
|
0.71 ms (1.50%) |
1 |
SELECT object_localized_AP_en.o_id as o_id, `object_localized_AP_en`.`o_type` FROM `object_localized_AP_en` WHERE ((compatibleTo LIKE "%,346,%" OR compatibleTo LIKE "%,345,%" AND object_localized_AP_en.o_type IN ('object','folder')) AND object_localized_AP_en.o_published = 1)
Parameters:
[] |
0.71 ms (1.50%) |
1 |
SELECT PLUGIN_CMF_COLLECT_DOCUMENT_SEGMENT_ASSIGNMENTS(:elementId)
Parameters:
[ "elementId" => 3 ] |
0.57 ms (1.20%) |
3 |
SELECT COUNT(*) AS `totalCount` FROM `object_2` WHERE ((reference = ?) AND (group__id = ?) AND object_2.o_type IN ('object','folder'))
Parameters:
[ "Mercedes" 960 ] |
0.53 ms (1.12%) |
3 |
SELECT object_2.o_id as o_id, `object_2`.`o_type` FROM `object_2` WHERE ((reference = ?) AND (group__id = ?) AND object_2.o_type IN ('object','folder'))
Parameters:
[ "Mercedes" 960 ] |
0.52 ms (1.09%) |
3 |
SELECT COUNT(*) AS `totalCount` FROM `object_1` WHERE (reference = ? and (calculated = 1) AND object_1.o_type IN ('object','folder'))
Parameters:
[
"Interest Manufacturer"
]
|
0.51 ms (1.09%) |
3 |
SELECT object_1.o_id as o_id, `object_1`.`o_type` FROM `object_1` WHERE (reference = ? and (calculated = 1) AND object_1.o_type IN ('object','folder'))
Parameters:
[
"Interest Manufacturer"
]
|
0.28 ms (0.59%) |
2 |
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[] |
0.21 ms (0.44%) |
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:
[
345
]
|
0.18 ms (0.39%) |
1 |
SELECT * FROM documents_elements WHERE documentId = ?
Parameters:
[
12
]
|
0.15 ms (0.32%) |
1 |
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
1
]
|
0.15 ms (0.32%) |
1 |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='7'
Parameters:
[] |
0.15 ms (0.31%) |
1 |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='9'
Parameters:
[] |
0.15 ms (0.31%) |
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.30%) |
1 |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='8'
Parameters:
[] |
0.14 ms (0.30%) |
1 |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='6'
Parameters:
[] |
0.14 ms (0.30%) |
1 |
SELECT id FROM targeting_rules WHERE active = 1 ORDER BY `prio` ASC
Parameters:
[] |
0.14 ms (0.30%) |
1 |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='10'
Parameters:
[] |
0.14 ms (0.29%) |
1 |
SELECT id FROM ecommerceframework_pricing_rule WHERE active = 1 ORDER BY `prio` ASC
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.