Query Metrics
165
Database Queries
39
Different statements
1541.39 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.57 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065561 [ "site_domain_0a5975ce453a1f3fa3ebe3fb7285128b" ] ] |
| 2 | 24.81 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065561 [ "system_route_redirect" ] ] |
| 3 | 0.24 ms |
SELECT id FROM documents WHERE path = :path AND `key` = :key
Parameters:
[ "key" => "Beleuchtung~c393" "path" => "/de/shop/Produkte/Ersatzteile/" ] |
| 4 | 10.94 ms |
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[ "prettyUrl" => "/de/shop/Produkte/Ersatzteile/Beleuchtung~c393" ] |
| 5 | 0.16 ms |
SELECT id FROM documents WHERE path = :path AND `key` = :key
Parameters:
[ "key" => "Ersatzteile" "path" => "/de/shop/Produkte/" ] |
| 6 | 0.13 ms |
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[ "prettyUrl" => "/de/shop/Produkte/Ersatzteile" ] |
| 7 | 10.86 ms |
SELECT id FROM documents WHERE path = :path AND `key` = :key
Parameters:
[ "key" => "Produkte" "path" => "/de/shop/" ] |
| 8 | 23.07 ms |
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[ "prettyUrl" => "/de/shop/Produkte" ] |
| 9 | 0.17 ms |
SELECT id FROM documents WHERE path = :path AND `key` = :key
Parameters:
[ "key" => "shop" "path" => "/de/" ] |
| 10 | 0.09 ms |
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[ "prettyUrl" => "/de/shop" ] |
| 11 | 2.92 ms |
SELECT id FROM documents WHERE path = :path AND `key` = :key
Parameters:
[ "key" => "de" "path" => "/" ] |
| 12 | 7.13 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065562 [ "document_136" ] ] |
| 13 | 23.10 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065562 [ "document_properties_136" ] ] |
| 14 | 0.09 ms |
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[] |
| 15 | 12.53 ms |
SELECT PLUGIN_CMF_COLLECT_DOCUMENT_SEGMENT_ASSIGNMENTS(:elementId)
Parameters:
[ "elementId" => 136 ] |
| 16 | 0.41 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065562 [ "object_835" ] ] |
| 17 | 27.67 ms |
SELECT id FROM targeting_rules WHERE active = 1 ORDER BY `prio` ASC
Parameters:
[] |
| 18 | 0.09 ms |
SELECT * FROM targeting_rules WHERE id = ?
Parameters:
[
1
]
|
| 19 | 0.28 ms |
SELECT * FROM targeting_rules WHERE id = ?
Parameters:
[
2
]
|
| 20 | 0.06 ms |
SELECT * FROM targeting_rules WHERE id = ?
Parameters:
[
3
]
|
| 21 | 8.62 ms |
SELECT * FROM targeting_rules WHERE id = ?
Parameters:
[
4
]
|
| 22 | 0.11 ms |
SELECT * FROM targeting_rules WHERE id = ?
Parameters:
[
6
]
|
| 23 | 0.06 ms |
SELECT * FROM targeting_rules WHERE id = ?
Parameters:
[
7
]
|
| 24 | 0.06 ms |
SELECT * FROM targeting_rules WHERE id = ?
Parameters:
[
8
]
|
| 25 | 10.21 ms |
SELECT * FROM targeting_rules WHERE id = ?
Parameters:
[
9
]
|
| 26 | 0.27 ms |
SELECT * FROM targeting_rules WHERE id = ?
Parameters:
[
10
]
|
| 27 | 34.34 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065562 [ "url_1%20and%20timeonsite_2%2F%2Ftimeonsite_2%7Curl_1" ] ] |
| 28 | 2.55 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065562 [ "url_1%20and%20timeonsite_2%2F%2Ftimeonsite_2%7Curl_1" ] ] |
| 29 | 3.46 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065562 [ "url_1%20and%20timeonsite_2%2F%2Ftimeonsite_2%7Curl_1" ] ] |
| 30 | 0.18 ms |
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/" ] |
| 31 | 14.41 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065562 [ "object_875" ] ] |
| 32 | 18.56 ms |
SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key
Parameters:
[ "key" => "at least once" "path" => "/Customer Management/segments/calculated/VisitingCount/" ] |
| 33 | 6.89 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065562 [ "object_860" ] ] |
| 34 | 14.63 ms |
SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key
Parameters:
[ "key" => "at least once" "path" => "/Customer Management/segments/calculated/VisitingCount/" ] |
| 35 | 11.42 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065562 [ "cmf_has_segment_1%20and%20cmf_customer_is_loggedin_2%2F%2Fcmf_customer_is_loggedin_2%7Ccmf_has_segment_1" ] ] |
| 36 | 7.12 ms |
SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key
Parameters:
[ "key" => "at least once" "path" => "/Customer Management/segments/calculated/VisitingCount/" ] |
| 37 | 7.44 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065562 [ "cmf_has_segment_1%20and%20cmf_customer_is_loggedin_2%2F%2Fcmf_customer_is_loggedin_2%7Ccmf_has_segment_1" ] ] |
| 38 | 0.15 ms |
SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key
Parameters:
[ "key" => "at least once" "path" => "/Customer Management/segments/calculated/VisitingCount/" ] |
| 39 | 10.85 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065562 [ "cmf_has_segment_1%20and%20cmf_customer_is_loggedin_2%2F%2Fcmf_customer_is_loggedin_2%7Ccmf_has_segment_1" ] ] |
| 40 | 10.75 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065562 [ "document_target_groups_136" ] ] |
| 41 | 32.63 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065562 [ "object_393" ] ] |
| 42 | 0.13 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"CA"
]
|
| 43 | 0.83 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065562 [ "object_392" ] ] |
| 44 | 2.23 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065562 [ "object_564" ] ] |
| 45 | 7.24 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065562 [ "object_389" ] ] |
| 46 | 33.58 ms |
SELECT * FROM object_relations_CA WHERE src_id = 393 AND fieldname = 'filterDefinition' AND ownertype = 'object'
Parameters:
[] |
| 47 | 0.10 ms |
SELECT * FROM object_relations_CA WHERE src_id = 392 AND fieldname = 'filterDefinition' AND ownertype = 'object'
Parameters:
[] |
| 48 | 0.47 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065562 [ "object_760" ] ] |
| 49 | 17.32 ms |
SELECT PLUGIN_CMF_COLLECT_OBJECT_SEGMENT_ASSIGNMENTS(:elementId)
Parameters:
[ "elementId" => 393 ] |
| 50 | 2.92 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"EF_FD"
]
|
| 51 | 1.28 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065562 [ "object_758" ] ] |
| 52 | 17.44 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065562 [ "object_695" ] ] |
| 53 | 1.48 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065562 [ "object_562" ] ] |
| 54 | 20.60 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065562 [ "object_1" ] ] |
| 55 | 25.44 ms |
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:
[] |
| 56 | 2.80 ms |
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 90, 18
Parameters:
[] |
| 57 | 0.14 ms |
SELECT FOUND_ROWS()
Parameters:
[] |
| 58 | 3.24 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065562 [ "object_543" ] ] |
| 59 | 10.80 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"AP"
]
|
| 60 | 6.60 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065562 [ "object_544" ] ] |
| 61 | 34.11 ms |
SELECT * FROM object_relations_AP WHERE src_id = 543 AND fieldname = 'manufacturer' AND ownertype = 'object'
Parameters:
[] |
| 62 | 0.40 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065563 [ "object_206" ] ] |
| 63 | 0.08 ms |
SELECT * FROM object_relations_AP WHERE src_id = 543 AND fieldname = 'series' AND ownertype = 'object'
Parameters:
[] |
| 64 | 0.34 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065563 [ "object_210" ] ] |
| 65 | 8.80 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"CAR"
]
|
| 66 | 0.44 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065563 [ "object_208" ] ] |
| 67 | 6.77 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065563 [ "object_207" ] ] |
| 68 | 7.17 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065563 [ "object_2" ] ] |
| 69 | 11.71 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065563 [ "object_744" ] ] |
| 70 | 0.09 ms |
SELECT * FROM object_relations_AP WHERE src_id = 543 AND fieldname = 'mainCategory' AND ownertype = 'object'
Parameters:
[] |
| 71 | 0.25 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065563 [ "object_396" ] ] |
| 72 | 2.05 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065563 [ "object_693" ] ] |
| 73 | 19.66 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"EF_OSTC"
]
|
| 74 | 24.74 ms |
SELECT id FROM ecommerceframework_pricing_rule WHERE active = 1 ORDER BY `prio` ASC
Parameters:
[] |
| 75 | 18.55 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065563 [ "system_resource_columns_ecommerceframework_pricing_rule" ] ] |
| 76 | 0.10 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='9'
Parameters:
[] |
| 77 | 2.77 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065563 [ "object_559" ] ] |
| 78 | 7.34 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='10'
Parameters:
[] |
| 79 | 7.81 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065563 [ "object_556" ] ] |
| 80 | 0.09 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='8'
Parameters:
[] |
| 81 | 6.85 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065563 [ "object_75" ] ] |
| 82 | 3.24 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065563 [ "object_74" ] ] |
| 83 | 27.43 ms |
SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key
Parameters:
[ "key" => "citroen-2cv-head lights" "path" => "/Product Data/Accessories/lights/head lights/" ] |
| 84 | 1.73 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065563 [ "object_438" ] ] |
| 85 | 1.11 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='6'
Parameters:
[] |
| 86 | 22.88 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='7'
Parameters:
[] |
| 87 | 0.50 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065563 [ "object_399" ] ] |
| 88 | 10.08 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065563 [ "object_873" ] ] |
| 89 | 19.37 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065563 [ "object_365" ] ] |
| 90 | 0.13 ms |
SELECT * FROM object_relations_AP WHERE src_id = 544 AND fieldname = 'manufacturer' AND ownertype = 'object'
Parameters:
[] |
| 91 | 0.06 ms |
SELECT * FROM object_relations_AP WHERE src_id = 544 AND fieldname = 'series' AND ownertype = 'object'
Parameters:
[] |
| 92 | 13.07 ms |
SELECT * FROM object_relations_AP WHERE src_id = 544 AND fieldname = 'mainCategory' AND ownertype = 'object'
Parameters:
[] |
| 93 | 0.50 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065563 [ "nav_ed9dc8022e7afa3acab08cd29e0830a0" ] ] |
| 94 | 9.45 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065563 [ "translation_data_messages_de" ] ] |
| 95 | 14.39 ms |
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
136
]
|
| 96 | 4.13 ms |
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[ "3" 136 136 ] |
| 97 | 0.09 ms |
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[ "136" "136" ] |
| 98 | 0.06 ms |
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[ "3" "3" ] |
| 99 | 11.35 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065563 [ "document_3" ] ] |
| 100 | 2.98 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065563 [ "document_properties_3" ] ] |
| 101 | 0.16 ms |
SELECT id FROM documents WHERE path = :path AND `key` = :key
Parameters:
[ "key" => "en" "path" => "/" ] |
| 102 | 18.17 ms |
SELECT id FROM documents WHERE path = :path AND `key` = :key
Parameters:
[ "key" => "fr" "path" => "/" ] |
| 103 | 7.76 ms |
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[ "prettyUrl" => "/fr" ] |
| 104 | 10.81 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065563 [ "nav_f3e9f14d1fa72fd1bf8879d5371f86ba" ] ] |
| 105 | 0.14 ms |
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:
[] |
| 106 | 30.01 ms |
SELECT * FROM object_relations_EF_FD WHERE src_id = 760 AND fieldname = 'availableCategories' AND ownertype = 'fieldcollection' AND ownername = 'filters' AND position = '0'
Parameters:
[] |
| 107 | 0.11 ms |
SELECT * FROM object_relations_EF_FD WHERE src_id = 760 AND fieldname = 'rootCategory' AND ownertype = 'fieldcollection' AND ownername = 'filters' AND position = '0'
Parameters:
[] |
| 108 | 13.59 ms |
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
]
|
| 109 | 11.69 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065563 [ "object_394" ] ] |
| 110 | 1.79 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065563 [ "object_395" ] ] |
| 111 | 0.14 ms |
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:
[] |
| 112 | 0.09 ms |
SELECT * FROM object_relations_EF_FD WHERE src_id = 760 AND fieldname = 'availableRelations' AND ownertype = 'fieldcollection' AND ownername = 'filters' AND position = '1'
Parameters:
[] |
| 113 | 33.85 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065564 [ "object_4" ] ] |
| 114 | 0.42 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065564 [ "object_28" ] ] |
| 115 | 6.50 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065564 [ "object_35" ] ] |
| 116 | 0.29 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065564 [ "object_39" ] ] |
| 117 | 6.50 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065564 [ "object_45" ] ] |
| 118 | 3.86 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065564 [ "object_59" ] ] |
| 119 | 7.20 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065564 [ "object_71" ] ] |
| 120 | 18.84 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065564 [ "object_80" ] ] |
| 121 | 3.49 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065564 [ "object_83" ] ] |
| 122 | 7.53 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065564 [ "object_93" ] ] |
| 123 | 3.51 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065564 [ "object_100" ] ] |
| 124 | 7.55 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065564 [ "object_106" ] ] |
| 125 | 0.65 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065564 [ "object_134" ] ] |
| 126 | 6.42 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065564 [ "object_145" ] ] |
| 127 | 23.55 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065564 [ "object_153" ] ] |
| 128 | 18.45 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065564 [ "object_158" ] ] |
| 129 | 0.38 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065564 [ "object_167" ] ] |
| 130 | 0.23 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065564 [ "object_176" ] ] |
| 131 | 17.68 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065564 [ "object_185" ] ] |
| 132 | 2.83 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065564 [ "object_240" ] ] |
| 133 | 7.56 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065564 [ "object_300" ] ] |
| 134 | 41.31 ms |
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:
[] |
| 135 | 36.87 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065564 [ "imagick_format_webp" ] ] |
| 136 | 0.53 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_180__4c4117d8cf423c1fbfe2b6654537f434"
]
|
| 137 | 0.09 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_180__4c4117d8cf423c1fbfe2b6654537f434"
]
|
| 138 | 24.99 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_180__cf7a3d858098e9a0d234a6b97d55273f"
]
|
| 139 | 0.72 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_174__92691e607f71dfd34efc8db7eeb804bb"
]
|
| 140 | 20.95 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_174__92691e607f71dfd34efc8db7eeb804bb"
]
|
| 141 | 0.28 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_174__5562f8fe16e0bce7e22ba5083e523c84"
]
|
| 142 | 32.13 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065564 [ "document_170" ] ] |
| 143 | 7.28 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065564 [ "document_target_groups_170" ] ] |
| 144 | 3.35 ms |
SELECT * FROM documents_elements WHERE documentId = ?
Parameters:
[
170
]
|
| 145 | 26.42 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065564 [ "document_properties_170" ] ] |
| 146 | 6.97 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065564 [ "document_164" ] ] |
| 147 | 2.47 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065564 [ "document_165" ] ] |
| 148 | 45.04 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065564 [ "document_151" ] ] |
| 149 | 2.58 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065564 [ "document_152" ] ] |
| 150 | 10.68 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065564 [ "document_153" ] ] |
| 151 | 27.10 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065564 [ "document_154" ] ] |
| 152 | 0.85 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065564 [ "document_155" ] ] |
| 153 | 20.87 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065564 [ "document_156" ] ] |
| 154 | 33.85 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065564 [ "document_48" ] ] |
| 155 | 0.68 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065564 [ "document_52" ] ] |
| 156 | 8.22 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065564 [ "document_112" ] ] |
| 157 | 15.00 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065564 [ "document_49" ] ] |
| 158 | 22.79 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065564 [ "document_113" ] ] |
| 159 | 2.95 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065564 [ "document_39" ] ] |
| 160 | 22.21 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065564 [ "document_50" ] ] |
| 161 | 7.27 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065564 [ "document_38" ] ] |
| 162 | 10.63 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065564 [ "document_51" ] ] |
| 163 | 22.73 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065564 [ "document_95" ] ] |
| 164 | 3.03 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065564 [ "document_110" ] ] |
| 165 | 10.51 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1795065564 [ "document_88" ] ] |
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.