Symfony Profiler

Query Metrics

10.00 ms Query Time

1 Node(s)

35 Indices

Queries

#▲ Execution Time Info

6.14 ms

#▲	Execution Time	Info
1	6.14 ms	Request: {"index":"sw-staging_product","search_type":"query_then_fetch","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"018d01736b31710085073ce4a19b2b37"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"018d017368a17035beb6b2218da8acb3"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"sort":[{"_script":{"type":"number","script":{"source":"def languages = params['languages'];\ndef suffix = params.containsKey('suffix') ? '.' + params['suffix'] : '';\n\nfor (int i = 0; i < languages.length; i++) {\n def field_name = params['field'] + '.' + languages[i] + suffix;\n\n if (doc[field_name].size() > 0 && doc[field_name].value != null && doc[field_name].value.toString().length() > 0) {\n def fieldValue = doc[field_name].value;\n\n return fieldValue;\n }\n}\n\nif (params['order'] == 'asc') {\n return Double.MAX_VALUE;\n}\n\nreturn Double.MIN_VALUE;\n","lang":"painless","params":{"field":"customFields","languages":["2fbb5fe2e29a4d70aa5854ce7ce3e20b"],"suffix":"acris_search_sorting_relevance","order":"desc"}},"order":"DESC"}},{"_score":{"order":"DESC"}},{"markAsTopseller":{"order":"DESC"}},{"autoIncrement":{"order":"DESC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"}} Item count: 8 View formatted request View formatted response View query backtrace POST http://localhost:9500/sw-staging_product/_search?search_type=query_then_fetch&track_total_hits=1 Accept: application/json Content-Type: application/json { "query": { "bool": { "filter": [ { "bool": { "must": [ { "bool": { "must": [ { "nested": { "path": "visibilities", "query": { "bool": { "must": [ { "range": { "visibilities.visibility": { "gte": 30 } } }, { "term": { "visibilities.salesChannelId": "018d01736b31710085073ce4a19b2b37" } } ] } } } }, { "term": { "active": true } } ] } }, { "nested": { "path": "categoriesRo", "query": { "term": { "categoriesRo.id": "018d017368a17035beb6b2218da8acb3" } } } }, { "bool": { "must_not": [ { "bool": { "must_not": [ { "exists": { "field": "displayGroup" } } ] } } ] } } ] } } ] } }, "sort": [ { "_script": { "type": "number", "script": { "source": "def languages = params['languages'];\ndef suffix = params.containsKey('suffix') ? '.' + params['suffix'] : '';\n\nfor (int i = 0; i < languages.length; i++) {\n def field_name = params['field'] + '.' + languages[i] + suffix;\n\n if (doc[field_name].size() > 0 && doc[field_name].value != null && doc[field_name].value.toString().length() > 0) {\n def fieldValue = doc[field_name].value;\n\n return fieldValue;\n }\n}\n\nif (params['order'] == 'asc') {\n return Double.MAX_VALUE;\n}\n\nreturn Double.MIN_VALUE;\n", "lang": "painless", "params": { "field": "customFields", "languages": [ "2fbb5fe2e29a4d70aa5854ce7ce3e20b" ], "suffix": "acris_search_sorting_relevance", "order": "desc" } }, "order": "DESC" } }, { "_score": { "order": "DESC" } }, { "markAsTopseller": { "order": "DESC" } }, { "autoIncrement": { "order": "DESC" } }, { "id": { "order": "ASC" } } ], "aggregations": { "total-count": { "cardinality": { "field": "displayGroup" } } }, "from": 0, "size": 24, "collapse": { "field": "displayGroup" }, "timeout": "5s" } { "took": 3, "timed_out": false, "_shards": { "total": 3, "successful": 3, "skipped": 0, "failed": 0 }, "hits": { "total": { "value": 8, "relation": "eq" }, "max_score": null, "hits": [ { "_index": "sw-staging_product_1755509385", "_id": "019851339f7173d7a581ec6f047bbad5", "_score": 0.0, "_source": { "autoIncrement": 24077.0, "id": "019851339f7173d7a581ec6f047bbad5" }, "fields": { "displayGroup": [ "7aab57447aa2ab21f983dade5d613df8" ] }, "sort": [ 0.0, 0.0, 0, 24077, "019851339f7173d7a581ec6f047bbad5" ] }, { "_index": "sw-staging_product_1755509385", "_id": "018d0229c6f3715d90f59551c86e6e9d", "_score": 0.0, "_source": { "autoIncrement": 1783.0, "id": "018d0229c6f3715d90f59551c86e6e9d" }, "fields": { "displayGroup": [ "2cf8ddcf662544cbabe8c22ab06a5c65" ] }, "sort": [ 0.0, 0.0, 0, 1783, "018d0229c6f3715d90f59551c86e6e9d" ] }, { "_index": "sw-staging_product_1755509385", "_id": "018d02297e2073279323df04bc4cd816", "_score": 0.0, "_source": { "autoIncrement": 1430.0, "id": "018d02297e2073279323df04bc4cd816" }, "fields": { "displayGroup": [ "cf5e01310f09e6e88d3c2336e3bf03b3" ] }, "sort": [ 0.0, 0.0, 0, 1430, "018d02297e2073279323df04bc4cd816" ] }, { "_index": "sw-staging_product_1755509385", "_id": "018d0229132771ae99de4af40e4720c2", "_score": 0.0, "_source": { "autoIncrement": 942.0, "id": "018d0229132771ae99de4af40e4720c2" }, "fields": { "displayGroup": [ "cc7278cb371dd78e0bd86687cc44cdd2" ] }, "sort": [ 0.0, 0.0, 0, 942, "018d0229132771ae99de4af40e4720c2" ] }, { "_index": "sw-staging_product_1755509385", "_id": "018d0228ea2b71d4af825f5bcdc76de2", "_score": 0.0, "_source": { "autoIncrement": 747.0, "id": "018d0228ea2b71d4af825f5bcdc76de2" }, "fields": { "displayGroup": [ "35ba524754e07bdc7a1d06a9bd36ed19" ] }, "sort": [ 0.0, 0.0, 0, 747, "018d0228ea2b71d4af825f5bcdc76de2" ] }, { "_index": "sw-staging_product_1755509385", "_id": "018d022892ee73e1be98828863b1d352", "_score": 0.0, "_source": { "autoIncrement": 340.0, "id": "018d022892ee73e1be98828863b1d352" }, "fields": { "displayGroup": [ "7954ffd29ca4aca58eabb209279f1dac" ] }, "sort": [ 0.0, 0.0, 0, 340, "018d022892ee73e1be98828863b1d352" ] }, { "_index": "sw-staging_product_1755509385", "_id": "018d022892d8714ea991bbab6675c1dc", "_score": 0.0, "_source": { "autoIncrement": 339.0, "id": "018d022892d8714ea991bbab6675c1dc" }, "fields": { "displayGroup": [ "2059b36a7a9e4157f12707a5f0c61527" ] }, "sort": [ 0.0, 0.0, 0, 339, "018d022892d8714ea991bbab6675c1dc" ] }, { "_index": "sw-staging_product_1755509385", "_id": "018d022892bb7009a66be955e16cbabe", "_score": 0.0, "_source": { "autoIncrement": 338.0, "id": "018d022892bb7009a66be955e16cbabe" }, "fields": { "displayGroup": [ "3cba487f3fa4f074fd847ee0330016e9" ] }, "sort": [ 0.0, 0.0, 0, 338, "018d022892bb7009a66be955e16cbabe" ] } ] }, "aggregations": { "total-count": { "value": 8 } } } `Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search`
2	4.60 ms	Request: {"index":"sw-staging_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"018d01736b31710085073ce4a19b2b37"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"018d017368a17035beb6b2218da8acb3"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"aggregations":{"manufacturer":{"terms":{"field":"manufacturerId","size":10000}},"price":{"stats":{"script":{"source":"double getPrice(def accessors, def doc, def decimals, def round, def multiplier) {\n for (accessor in accessors) {\n def key = accessor['key'];\n\n if (!doc.containsKey(key) \|\| doc[key].empty) {\n continue;\n }\n\n def factor = accessor['factor'];\n def value = doc[key].value * factor;\n\n value = Math.round(value * decimals);\n value = (double) value \/ decimals;\n\n if (!round) {\n return (double) value;\n }\n\n value = Math.round(value * multiplier);\n\n value = (double) value \/ multiplier;\n\n return (double) value;\n }\n\n return 0;\n}\n\nreturn getPrice(params['accessors'], doc, params['decimals'], params['round'], params['multiplier']);\n","lang":"painless","params":{"accessors":[{"key":"cheapest_price_rule019928709f487259bbc34c29afc4be6d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018d0163d2ce72fe8b0728a642b4042f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018d0163d35c71528f3f85ab4edbfce9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018d0164030b7131bbf732b6cdd045f8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018d017d87c971e284588c2bab64fc6c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018df3dca4dc70dc9d8955300dfa54b3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018f52ec7ad97053adbba87acd431267_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018f52ec7aec70afa4294f02dbeb6cff_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01987f3e2d7a7382a91854b9f17706e6_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01987f4aff9672c68c35e38c34822856_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule0198e1ef5bfe7d0c8c7e3a144d5ed318_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019889ada060713fb1cab5134c90045e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule0196d39e8fa07f518ea67268325e9d73_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule0196d879404475a88dc0ac502e0b7ada_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01987f294a4e73e8999e21f34612201b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018d017d889d70c6a53a7c9aa1c04cc9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018d02284fa87229858f8decad12dd24_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019440472dad70ea836ab0b8dbb2c63b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019440472e9b7194bfdf7e02f0d0b7d8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019440472fc0710ebe371fb24996b058_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019440472fea71a2aa90640bd545b58e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019440473012718f84cc75c44ace5494_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01944047301a73eabdec8bb977e6e6f1_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01944047303e700e9ad384c92dd1f000_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01944047305872f3a49d7e56eb3f9aa6_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01944047305e7354a561cd03a0cf3217_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01944047319670d19ba00ffb56496ca0_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01944047323971679b378ec7a290c458_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01944047323e70ac9c0eb9dedc877a48_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01944047324471e49ad453603c99a659_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01944047327270d4898a4f601343774c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01944047328970b39b22abefa86d94e7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule0194404732d6721fa645849e801e1606_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule0194404732df730bb2e0ff2234bce95f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1}],"decimals":100,"round":true,"multiplier":100.0}}}},"rating-exists":{"filter":{"range":{"ratingAverage":{"gte":0.0}}},"aggregations":{"rating":{"max":{"field":"ratingAverage"}}}},"shipping-free-filter":{"filter":{"term":{"shippingFree":true}},"aggregations":{"shipping-free":{"max":{"field":"shippingFree"}}}},"properties-filter":{"nested":{"path":"properties"},"aggregations":{"properties-filter":{"filter":{"terms":{"properties.groupId":["018d022bdd70702a9c7a8db29b279d91","018d022c3a0272c1a5f5e901b4ca7fdb","018d022bedaa7013a962905d996cb5a8","018d022bd93d7095a6f4dfd4fc66f79b","018d022c2085711085e1e54a3637eb3a","018d022bde5572ba8905ee4e16635ba2"]}},"aggregations":{"properties":{"terms":{"field":"properties.id","size":10000}}}}}},"options-filter":{"nested":{"path":"options"},"aggregations":{"options-filter":{"filter":{"terms":{"options.groupId":["018d022bdd70702a9c7a8db29b279d91","018d022c3a0272c1a5f5e901b4ca7fdb","018d022bedaa7013a962905d996cb5a8","018d022bd93d7095a6f4dfd4fc66f79b","018d022c2085711085e1e54a3637eb3a","018d022bde5572ba8905ee4e16635ba2"]}},"aggregations":{"options":{"terms":{"field":"options.id","size":10000}}}}}}},"size":0,"timeout":"5s"},"search_type":"query_then_fetch"} Item count: View formatted request View formatted response View query backtrace POST http://localhost:9500/sw-staging_product/_search?track_total_hits=0&search_type=query_then_fetch Accept: application/json Content-Type: application/json { "query": { "bool": { "filter": [ { "bool": { "must": [ { "bool": { "must": [ { "nested": { "path": "visibilities", "query": { "bool": { "must": [ { "range": { "visibilities.visibility": { "gte": 30 } } }, { "term": { "visibilities.salesChannelId": "018d01736b31710085073ce4a19b2b37" } } ] } } } }, { "term": { "active": true } } ] } }, { "nested": { "path": "categoriesRo", "query": { "term": { "categoriesRo.id": "018d017368a17035beb6b2218da8acb3" } } } }, { "bool": { "must_not": [ { "bool": { "must_not": [ { "exists": { "field": "displayGroup" } } ] } } ] } } ] } } ] } }, "aggregations": { "manufacturer": { "terms": { "field": "manufacturerId", "size": 10000 } }, "price": { "stats": { "script": { "source": "double getPrice(def accessors, def doc, def decimals, def round, def multiplier) {\n for (accessor in accessors) {\n def key = accessor['key'];\n\n if (!doc.containsKey(key) \|\| doc[key].empty) {\n continue;\n }\n\n def factor = accessor['factor'];\n def value = doc[key].value * factor;\n\n value = Math.round(value * decimals);\n value = (double) value \/ decimals;\n\n if (!round) {\n return (double) value;\n }\n\n value = Math.round(value * multiplier);\n\n value = (double) value \/ multiplier;\n\n return (double) value;\n }\n\n return 0;\n}\n\nreturn getPrice(params['accessors'], doc, params['decimals'], params['round'], params['multiplier']);\n", "lang": "painless", "params": { "accessors": [ { "key": "cheapest_price_rule019928709f487259bbc34c29afc4be6d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule018d0163d2ce72fe8b0728a642b4042f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule018d0163d35c71528f3f85ab4edbfce9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule018d0164030b7131bbf732b6cdd045f8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule018d017d87c971e284588c2bab64fc6c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule018df3dca4dc70dc9d8955300dfa54b3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule018f52ec7ad97053adbba87acd431267_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule018f52ec7aec70afa4294f02dbeb6cff_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule01987f3e2d7a7382a91854b9f17706e6_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule01987f4aff9672c68c35e38c34822856_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule0198e1ef5bfe7d0c8c7e3a144d5ed318_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule019889ada060713fb1cab5134c90045e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule0196d39e8fa07f518ea67268325e9d73_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule0196d879404475a88dc0ac502e0b7ada_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule01987f294a4e73e8999e21f34612201b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule018d017d889d70c6a53a7c9aa1c04cc9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule018d02284fa87229858f8decad12dd24_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule019440472dad70ea836ab0b8dbb2c63b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule019440472e9b7194bfdf7e02f0d0b7d8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule019440472fc0710ebe371fb24996b058_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule019440472fea71a2aa90640bd545b58e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule019440473012718f84cc75c44ace5494_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule01944047301a73eabdec8bb977e6e6f1_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule01944047303e700e9ad384c92dd1f000_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule01944047305872f3a49d7e56eb3f9aa6_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule01944047305e7354a561cd03a0cf3217_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule01944047319670d19ba00ffb56496ca0_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule01944047323971679b378ec7a290c458_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule01944047323e70ac9c0eb9dedc877a48_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule01944047324471e49ad453603c99a659_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule01944047327270d4898a4f601343774c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule01944047328970b39b22abefa86d94e7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule0194404732d6721fa645849e801e1606_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule0194404732df730bb2e0ff2234bce95f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 } ], "decimals": 100, "round": true, "multiplier": 100.0 } } } }, "rating-exists": { "filter": { "range": { "ratingAverage": { "gte": 0.0 } } }, "aggregations": { "rating": { "max": { "field": "ratingAverage" } } } }, "shipping-free-filter": { "filter": { "term": { "shippingFree": true } }, "aggregations": { "shipping-free": { "max": { "field": "shippingFree" } } } }, "properties-filter": { "nested": { "path": "properties" }, "aggregations": { "properties-filter": { "filter": { "terms": { "properties.groupId": [ "018d022bdd70702a9c7a8db29b279d91", "018d022c3a0272c1a5f5e901b4ca7fdb", "018d022bedaa7013a962905d996cb5a8", "018d022bd93d7095a6f4dfd4fc66f79b", "018d022c2085711085e1e54a3637eb3a", "018d022bde5572ba8905ee4e16635ba2" ] } }, "aggregations": { "properties": { "terms": { "field": "properties.id", "size": 10000 } } } } } }, "options-filter": { "nested": { "path": "options" }, "aggregations": { "options-filter": { "filter": { "terms": { "options.groupId": [ "018d022bdd70702a9c7a8db29b279d91", "018d022c3a0272c1a5f5e901b4ca7fdb", "018d022bedaa7013a962905d996cb5a8", "018d022bd93d7095a6f4dfd4fc66f79b", "018d022c2085711085e1e54a3637eb3a", "018d022bde5572ba8905ee4e16635ba2" ] } }, "aggregations": { "options": { "terms": { "field": "options.id", "size": 10000 } } } } } } }, "size": 0, "timeout": "5s" } { "took": 3, "timed_out": false, "_shards": { "total": 3, "successful": 3, "skipped": 0, "failed": 0 }, "hits": { "max_score": null, "hits": [] }, "aggregations": { "shipping-free-filter": { "doc_count": 0, "shipping-free": { "value": null } }, "properties-filter": { "doc_count": 198, "properties-filter": { "doc_count": 57, "properties": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [ { "key": "018d022bdd1a726998f01f4894d753a4", "doc_count": 8 }, { "key": "018d022bf1ec71829e91c8f34d7ce340", "doc_count": 8 }, { "key": "018d022c244772dba72bdacf33ea08de", "doc_count": 8 }, { "key": "018d022c3a15721789e76cb145bb823d", "doc_count": 8 }, { "key": "018d022bddd473e983cd961ff442364d", "doc_count": 7 }, { "key": "018d022bf4a3728c96b56b4f45e04dfe", "doc_count": 7 }, { "key": "018d022bdef6723ab049023a583cf2ac", "doc_count": 2 }, { "key": "018d022bf49971e789d1e5f473a16be5", "doc_count": 2 }, { "key": "018d022bdde27299ab4e9793f5b76f5b", "doc_count": 1 }, { "key": "018d022bde7b7243bb0d6c7dd32f7dfd", "doc_count": 1 }, { "key": "018d022bde8470aeb0ebf289ffac30ea", "doc_count": 1 }, { "key": "018d022bdefe73cba1d62a4924850080", "doc_count": 1 }, { "key": "018d022bdf0570f4b4968ec9846d1af5", "doc_count": 1 }, { "key": "018d022bdf0c71df88ac56485702a36b", "doc_count": 1 }, { "key": "018d022bf4ab72aeb2b9b722af9951f1", "doc_count": 1 } ] } } }, "rating-exists": { "doc_count": 8, "rating": { "value": 0.0 } }, "options-filter": { "doc_count": 0, "options-filter": { "doc_count": 0, "options": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [] } } }, "price": { "count": 8, "min": 63.9, "max": 1500.0, "avg": 574.3, "sum": 4594.4 }, "manufacturer": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [ { "key": "018d022892bf70a7891e2f84ceed3e04", "doc_count": 8 } ] } } } `Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate`

Request:

{"index":"sw-staging_product","search_type":"query_then_fetch","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"018d01736b31710085073ce4a19b2b37"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"018d017368a17035beb6b2218da8acb3"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"sort":[{"_script":{"type":"number","script":{"source":"def languages = params['languages'];\ndef suffix = params.containsKey('suffix') ? '.' + params['suffix'] : '';\n\nfor (int i = 0; i < languages.length; i++) {\n    def field_name = params['field'] + '.' + languages[i] + suffix;\n\n    if (doc[field_name].size() > 0 && doc[field_name].value != null && doc[field_name].value.toString().length() > 0) {\n        def fieldValue = doc[field_name].value;\n\n        return fieldValue;\n    }\n}\n\nif (params['order'] == 'asc') {\n    return Double.MAX_VALUE;\n}\n\nreturn Double.MIN_VALUE;\n","lang":"painless","params":{"field":"customFields","languages":["2fbb5fe2e29a4d70aa5854ce7ce3e20b"],"suffix":"acris_search_sorting_relevance","order":"desc"}},"order":"DESC"}},{"_score":{"order":"DESC"}},{"markAsTopseller":{"order":"DESC"}},{"autoIncrement":{"order":"DESC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"}}

Item count: 8
View formatted request View formatted response View query backtrace


                                    POST http://localhost:9500/sw-staging_product/_search?search_type=query_then_fetch&track_total_hits=1
    Accept: application/json
    Content-Type: application/json

        {
    "query": {
        "bool": {
            "filter": [
                {
                    "bool": {
                        "must": [
                            {
                                "bool": {
                                    "must": [
                                        {
                                            "nested": {
                                                "path": "visibilities",
                                                "query": {
                                                    "bool": {
                                                        "must": [
                                                            {
                                                                "range": {
                                                                    "visibilities.visibility": {
                                                                        "gte": 30
                                                                    }
                                                                }
                                                            },
                                                            {
                                                                "term": {
                                                                    "visibilities.salesChannelId": "018d01736b31710085073ce4a19b2b37"
                                                                }
                                                            }
                                                        ]
                                                    }
                                                }
                                            }
                                        },
                                        {
                                            "term": {
                                                "active": true
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "nested": {
                                    "path": "categoriesRo",
                                    "query": {
                                        "term": {
                                            "categoriesRo.id": "018d017368a17035beb6b2218da8acb3"
                                        }
                                    }
                                }
                            },
                            {
                                "bool": {
                                    "must_not": [
                                        {
                                            "bool": {
                                                "must_not": [
                                                    {
                                                        "exists": {
                                                            "field": "displayGroup"
                                                        }
                                                    }
                                                ]
                                            }
                                        }
                                    ]
                                }
                            }
                        ]
                    }
                }
            ]
        }
    },
    "sort": [
        {
            "_script": {
                "type": "number",
                "script": {
                    "source": "def languages = params['languages'];\ndef suffix = params.containsKey('suffix') ? '.' + params['suffix'] : '';\n\nfor (int i = 0; i < languages.length; i++) {\n    def field_name = params['field'] + '.' + languages[i] + suffix;\n\n    if (doc[field_name].size() > 0 && doc[field_name].value != null && doc[field_name].value.toString().length() > 0) {\n        def fieldValue = doc[field_name].value;\n\n        return fieldValue;\n    }\n}\n\nif (params['order'] == 'asc') {\n    return Double.MAX_VALUE;\n}\n\nreturn Double.MIN_VALUE;\n",
                    "lang": "painless",
                    "params": {
                        "field": "customFields",
                        "languages": [
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b"
                        ],
                        "suffix": "acris_search_sorting_relevance",
                        "order": "desc"
                    }
                },
                "order": "DESC"
            }
        },
        {
            "_score": {
                "order": "DESC"
            }
        },
        {
            "markAsTopseller": {
                "order": "DESC"
            }
        },
        {
            "autoIncrement": {
                "order": "DESC"
            }
        },
        {
            "id": {
                "order": "ASC"
            }
        }
    ],
    "aggregations": {
        "total-count": {
            "cardinality": {
                "field": "displayGroup"
            }
        }
    },
    "from": 0,
    "size": 24,
    "collapse": {
        "field": "displayGroup"
    },
    "timeout": "5s"
}


                                    {
    "took": 3,
    "timed_out": false,
    "_shards": {
        "total": 3,
        "successful": 3,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": {
            "value": 8,
            "relation": "eq"
        },
        "max_score": null,
        "hits": [
            {
                "_index": "sw-staging_product_1755509385",
                "_id": "019851339f7173d7a581ec6f047bbad5",
                "_score": 0.0,
                "_source": {
                    "autoIncrement": 24077.0,
                    "id": "019851339f7173d7a581ec6f047bbad5"
                },
                "fields": {
                    "displayGroup": [
                        "7aab57447aa2ab21f983dade5d613df8"
                    ]
                },
                "sort": [
                    0.0,
                    0.0,
                    0,
                    24077,
                    "019851339f7173d7a581ec6f047bbad5"
                ]
            },
            {
                "_index": "sw-staging_product_1755509385",
                "_id": "018d0229c6f3715d90f59551c86e6e9d",
                "_score": 0.0,
                "_source": {
                    "autoIncrement": 1783.0,
                    "id": "018d0229c6f3715d90f59551c86e6e9d"
                },
                "fields": {
                    "displayGroup": [
                        "2cf8ddcf662544cbabe8c22ab06a5c65"
                    ]
                },
                "sort": [
                    0.0,
                    0.0,
                    0,
                    1783,
                    "018d0229c6f3715d90f59551c86e6e9d"
                ]
            },
            {
                "_index": "sw-staging_product_1755509385",
                "_id": "018d02297e2073279323df04bc4cd816",
                "_score": 0.0,
                "_source": {
                    "autoIncrement": 1430.0,
                    "id": "018d02297e2073279323df04bc4cd816"
                },
                "fields": {
                    "displayGroup": [
                        "cf5e01310f09e6e88d3c2336e3bf03b3"
                    ]
                },
                "sort": [
                    0.0,
                    0.0,
                    0,
                    1430,
                    "018d02297e2073279323df04bc4cd816"
                ]
            },
            {
                "_index": "sw-staging_product_1755509385",
                "_id": "018d0229132771ae99de4af40e4720c2",
                "_score": 0.0,
                "_source": {
                    "autoIncrement": 942.0,
                    "id": "018d0229132771ae99de4af40e4720c2"
                },
                "fields": {
                    "displayGroup": [
                        "cc7278cb371dd78e0bd86687cc44cdd2"
                    ]
                },
                "sort": [
                    0.0,
                    0.0,
                    0,
                    942,
                    "018d0229132771ae99de4af40e4720c2"
                ]
            },
            {
                "_index": "sw-staging_product_1755509385",
                "_id": "018d0228ea2b71d4af825f5bcdc76de2",
                "_score": 0.0,
                "_source": {
                    "autoIncrement": 747.0,
                    "id": "018d0228ea2b71d4af825f5bcdc76de2"
                },
                "fields": {
                    "displayGroup": [
                        "35ba524754e07bdc7a1d06a9bd36ed19"
                    ]
                },
                "sort": [
                    0.0,
                    0.0,
                    0,
                    747,
                    "018d0228ea2b71d4af825f5bcdc76de2"
                ]
            },
            {
                "_index": "sw-staging_product_1755509385",
                "_id": "018d022892ee73e1be98828863b1d352",
                "_score": 0.0,
                "_source": {
                    "autoIncrement": 340.0,
                    "id": "018d022892ee73e1be98828863b1d352"
                },
                "fields": {
                    "displayGroup": [
                        "7954ffd29ca4aca58eabb209279f1dac"
                    ]
                },
                "sort": [
                    0.0,
                    0.0,
                    0,
                    340,
                    "018d022892ee73e1be98828863b1d352"
                ]
            },
            {
                "_index": "sw-staging_product_1755509385",
                "_id": "018d022892d8714ea991bbab6675c1dc",
                "_score": 0.0,
                "_source": {
                    "autoIncrement": 339.0,
                    "id": "018d022892d8714ea991bbab6675c1dc"
                },
                "fields": {
                    "displayGroup": [
                        "2059b36a7a9e4157f12707a5f0c61527"
                    ]
                },
                "sort": [
                    0.0,
                    0.0,
                    0,
                    339,
                    "018d022892d8714ea991bbab6675c1dc"
                ]
            },
            {
                "_index": "sw-staging_product_1755509385",
                "_id": "018d022892bb7009a66be955e16cbabe",
                "_score": 0.0,
                "_source": {
                    "autoIncrement": 338.0,
                    "id": "018d022892bb7009a66be955e16cbabe"
                },
                "fields": {
                    "displayGroup": [
                        "3cba487f3fa4f074fd847ee0330016e9"
                    ]
                },
                "sort": [
                    0.0,
                    0.0,
                    0,
                    338,
                    "018d022892bb7009a66be955e16cbabe"
                ]
            }
        ]
    },
    "aggregations": {
        "total-count": {
            "value": 8
        }
    }
}

Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search

4.60 ms

Request:

{"index":"sw-staging_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"018d01736b31710085073ce4a19b2b37"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"018d017368a17035beb6b2218da8acb3"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"aggregations":{"manufacturer":{"terms":{"field":"manufacturerId","size":10000}},"price":{"stats":{"script":{"source":"double getPrice(def accessors, def doc, def decimals, def round, def multiplier) {\n    for (accessor in accessors) {\n        def key = accessor['key'];\n\n        if (!doc.containsKey(key) || doc[key].empty) {\n            continue;\n        }\n\n        def factor = accessor['factor'];\n        def value = doc[key].value * factor;\n\n        value = Math.round(value * decimals);\n        value = (double) value \/ decimals;\n\n        if (!round) {\n            return (double) value;\n        }\n\n        value = Math.round(value * multiplier);\n\n        value = (double) value \/ multiplier;\n\n        return (double) value;\n    }\n\n    return 0;\n}\n\nreturn getPrice(params['accessors'], doc, params['decimals'], params['round'], params['multiplier']);\n","lang":"painless","params":{"accessors":[{"key":"cheapest_price_rule019928709f487259bbc34c29afc4be6d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018d0163d2ce72fe8b0728a642b4042f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018d0163d35c71528f3f85ab4edbfce9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018d0164030b7131bbf732b6cdd045f8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018d017d87c971e284588c2bab64fc6c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018df3dca4dc70dc9d8955300dfa54b3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018f52ec7ad97053adbba87acd431267_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018f52ec7aec70afa4294f02dbeb6cff_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01987f3e2d7a7382a91854b9f17706e6_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01987f4aff9672c68c35e38c34822856_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule0198e1ef5bfe7d0c8c7e3a144d5ed318_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019889ada060713fb1cab5134c90045e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule0196d39e8fa07f518ea67268325e9d73_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule0196d879404475a88dc0ac502e0b7ada_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01987f294a4e73e8999e21f34612201b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018d017d889d70c6a53a7c9aa1c04cc9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018d02284fa87229858f8decad12dd24_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019440472dad70ea836ab0b8dbb2c63b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019440472e9b7194bfdf7e02f0d0b7d8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019440472fc0710ebe371fb24996b058_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019440472fea71a2aa90640bd545b58e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019440473012718f84cc75c44ace5494_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01944047301a73eabdec8bb977e6e6f1_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01944047303e700e9ad384c92dd1f000_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01944047305872f3a49d7e56eb3f9aa6_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01944047305e7354a561cd03a0cf3217_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01944047319670d19ba00ffb56496ca0_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01944047323971679b378ec7a290c458_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01944047323e70ac9c0eb9dedc877a48_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01944047324471e49ad453603c99a659_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01944047327270d4898a4f601343774c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01944047328970b39b22abefa86d94e7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule0194404732d6721fa645849e801e1606_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule0194404732df730bb2e0ff2234bce95f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1}],"decimals":100,"round":true,"multiplier":100.0}}}},"rating-exists":{"filter":{"range":{"ratingAverage":{"gte":0.0}}},"aggregations":{"rating":{"max":{"field":"ratingAverage"}}}},"shipping-free-filter":{"filter":{"term":{"shippingFree":true}},"aggregations":{"shipping-free":{"max":{"field":"shippingFree"}}}},"properties-filter":{"nested":{"path":"properties"},"aggregations":{"properties-filter":{"filter":{"terms":{"properties.groupId":["018d022bdd70702a9c7a8db29b279d91","018d022c3a0272c1a5f5e901b4ca7fdb","018d022bedaa7013a962905d996cb5a8","018d022bd93d7095a6f4dfd4fc66f79b","018d022c2085711085e1e54a3637eb3a","018d022bde5572ba8905ee4e16635ba2"]}},"aggregations":{"properties":{"terms":{"field":"properties.id","size":10000}}}}}},"options-filter":{"nested":{"path":"options"},"aggregations":{"options-filter":{"filter":{"terms":{"options.groupId":["018d022bdd70702a9c7a8db29b279d91","018d022c3a0272c1a5f5e901b4ca7fdb","018d022bedaa7013a962905d996cb5a8","018d022bd93d7095a6f4dfd4fc66f79b","018d022c2085711085e1e54a3637eb3a","018d022bde5572ba8905ee4e16635ba2"]}},"aggregations":{"options":{"terms":{"field":"options.id","size":10000}}}}}}},"size":0,"timeout":"5s"},"search_type":"query_then_fetch"}

Item count:
View formatted request View formatted response View query backtrace


                                    POST http://localhost:9500/sw-staging_product/_search?track_total_hits=0&search_type=query_then_fetch
    Accept: application/json
    Content-Type: application/json

        {
    "query": {
        "bool": {
            "filter": [
                {
                    "bool": {
                        "must": [
                            {
                                "bool": {
                                    "must": [
                                        {
                                            "nested": {
                                                "path": "visibilities",
                                                "query": {
                                                    "bool": {
                                                        "must": [
                                                            {
                                                                "range": {
                                                                    "visibilities.visibility": {
                                                                        "gte": 30
                                                                    }
                                                                }
                                                            },
                                                            {
                                                                "term": {
                                                                    "visibilities.salesChannelId": "018d01736b31710085073ce4a19b2b37"
                                                                }
                                                            }
                                                        ]
                                                    }
                                                }
                                            }
                                        },
                                        {
                                            "term": {
                                                "active": true
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "nested": {
                                    "path": "categoriesRo",
                                    "query": {
                                        "term": {
                                            "categoriesRo.id": "018d017368a17035beb6b2218da8acb3"
                                        }
                                    }
                                }
                            },
                            {
                                "bool": {
                                    "must_not": [
                                        {
                                            "bool": {
                                                "must_not": [
                                                    {
                                                        "exists": {
                                                            "field": "displayGroup"
                                                        }
                                                    }
                                                ]
                                            }
                                        }
                                    ]
                                }
                            }
                        ]
                    }
                }
            ]
        }
    },
    "aggregations": {
        "manufacturer": {
            "terms": {
                "field": "manufacturerId",
                "size": 10000
            }
        },
        "price": {
            "stats": {
                "script": {
                    "source": "double getPrice(def accessors, def doc, def decimals, def round, def multiplier) {\n    for (accessor in accessors) {\n        def key = accessor['key'];\n\n        if (!doc.containsKey(key) || doc[key].empty) {\n            continue;\n        }\n\n        def factor = accessor['factor'];\n        def value = doc[key].value * factor;\n\n        value = Math.round(value * decimals);\n        value = (double) value \/ decimals;\n\n        if (!round) {\n            return (double) value;\n        }\n\n        value = Math.round(value * multiplier);\n\n        value = (double) value \/ multiplier;\n\n        return (double) value;\n    }\n\n    return 0;\n}\n\nreturn getPrice(params['accessors'], doc, params['decimals'], params['round'], params['multiplier']);\n",
                    "lang": "painless",
                    "params": {
                        "accessors": [
                            {
                                "key": "cheapest_price_rule019928709f487259bbc34c29afc4be6d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule018d0163d2ce72fe8b0728a642b4042f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule018d0163d35c71528f3f85ab4edbfce9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule018d0164030b7131bbf732b6cdd045f8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule018d017d87c971e284588c2bab64fc6c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule018df3dca4dc70dc9d8955300dfa54b3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule018f52ec7ad97053adbba87acd431267_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule018f52ec7aec70afa4294f02dbeb6cff_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule01987f3e2d7a7382a91854b9f17706e6_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule01987f4aff9672c68c35e38c34822856_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0198e1ef5bfe7d0c8c7e3a144d5ed318_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule019889ada060713fb1cab5134c90045e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0196d39e8fa07f518ea67268325e9d73_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0196d879404475a88dc0ac502e0b7ada_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule01987f294a4e73e8999e21f34612201b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule018d017d889d70c6a53a7c9aa1c04cc9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule018d02284fa87229858f8decad12dd24_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule019440472dad70ea836ab0b8dbb2c63b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule019440472e9b7194bfdf7e02f0d0b7d8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule019440472fc0710ebe371fb24996b058_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule019440472fea71a2aa90640bd545b58e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule019440473012718f84cc75c44ace5494_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule01944047301a73eabdec8bb977e6e6f1_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule01944047303e700e9ad384c92dd1f000_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule01944047305872f3a49d7e56eb3f9aa6_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule01944047305e7354a561cd03a0cf3217_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule01944047319670d19ba00ffb56496ca0_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule01944047323971679b378ec7a290c458_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule01944047323e70ac9c0eb9dedc877a48_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule01944047324471e49ad453603c99a659_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule01944047327270d4898a4f601343774c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule01944047328970b39b22abefa86d94e7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0194404732d6721fa645849e801e1606_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0194404732df730bb2e0ff2234bce95f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            }
                        ],
                        "decimals": 100,
                        "round": true,
                        "multiplier": 100.0
                    }
                }
            }
        },
        "rating-exists": {
            "filter": {
                "range": {
                    "ratingAverage": {
                        "gte": 0.0
                    }
                }
            },
            "aggregations": {
                "rating": {
                    "max": {
                        "field": "ratingAverage"
                    }
                }
            }
        },
        "shipping-free-filter": {
            "filter": {
                "term": {
                    "shippingFree": true
                }
            },
            "aggregations": {
                "shipping-free": {
                    "max": {
                        "field": "shippingFree"
                    }
                }
            }
        },
        "properties-filter": {
            "nested": {
                "path": "properties"
            },
            "aggregations": {
                "properties-filter": {
                    "filter": {
                        "terms": {
                            "properties.groupId": [
                                "018d022bdd70702a9c7a8db29b279d91",
                                "018d022c3a0272c1a5f5e901b4ca7fdb",
                                "018d022bedaa7013a962905d996cb5a8",
                                "018d022bd93d7095a6f4dfd4fc66f79b",
                                "018d022c2085711085e1e54a3637eb3a",
                                "018d022bde5572ba8905ee4e16635ba2"
                            ]
                        }
                    },
                    "aggregations": {
                        "properties": {
                            "terms": {
                                "field": "properties.id",
                                "size": 10000
                            }
                        }
                    }
                }
            }
        },
        "options-filter": {
            "nested": {
                "path": "options"
            },
            "aggregations": {
                "options-filter": {
                    "filter": {
                        "terms": {
                            "options.groupId": [
                                "018d022bdd70702a9c7a8db29b279d91",
                                "018d022c3a0272c1a5f5e901b4ca7fdb",
                                "018d022bedaa7013a962905d996cb5a8",
                                "018d022bd93d7095a6f4dfd4fc66f79b",
                                "018d022c2085711085e1e54a3637eb3a",
                                "018d022bde5572ba8905ee4e16635ba2"
                            ]
                        }
                    },
                    "aggregations": {
                        "options": {
                            "terms": {
                                "field": "options.id",
                                "size": 10000
                            }
                        }
                    }
                }
            }
        }
    },
    "size": 0,
    "timeout": "5s"
}


                                    {
    "took": 3,
    "timed_out": false,
    "_shards": {
        "total": 3,
        "successful": 3,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "max_score": null,
        "hits": []
    },
    "aggregations": {
        "shipping-free-filter": {
            "doc_count": 0,
            "shipping-free": {
                "value": null
            }
        },
        "properties-filter": {
            "doc_count": 198,
            "properties-filter": {
                "doc_count": 57,
                "properties": {
                    "doc_count_error_upper_bound": 0,
                    "sum_other_doc_count": 0,
                    "buckets": [
                        {
                            "key": "018d022bdd1a726998f01f4894d753a4",
                            "doc_count": 8
                        },
                        {
                            "key": "018d022bf1ec71829e91c8f34d7ce340",
                            "doc_count": 8
                        },
                        {
                            "key": "018d022c244772dba72bdacf33ea08de",
                            "doc_count": 8
                        },
                        {
                            "key": "018d022c3a15721789e76cb145bb823d",
                            "doc_count": 8
                        },
                        {
                            "key": "018d022bddd473e983cd961ff442364d",
                            "doc_count": 7
                        },
                        {
                            "key": "018d022bf4a3728c96b56b4f45e04dfe",
                            "doc_count": 7
                        },
                        {
                            "key": "018d022bdef6723ab049023a583cf2ac",
                            "doc_count": 2
                        },
                        {
                            "key": "018d022bf49971e789d1e5f473a16be5",
                            "doc_count": 2
                        },
                        {
                            "key": "018d022bdde27299ab4e9793f5b76f5b",
                            "doc_count": 1
                        },
                        {
                            "key": "018d022bde7b7243bb0d6c7dd32f7dfd",
                            "doc_count": 1
                        },
                        {
                            "key": "018d022bde8470aeb0ebf289ffac30ea",
                            "doc_count": 1
                        },
                        {
                            "key": "018d022bdefe73cba1d62a4924850080",
                            "doc_count": 1
                        },
                        {
                            "key": "018d022bdf0570f4b4968ec9846d1af5",
                            "doc_count": 1
                        },
                        {
                            "key": "018d022bdf0c71df88ac56485702a36b",
                            "doc_count": 1
                        },
                        {
                            "key": "018d022bf4ab72aeb2b9b722af9951f1",
                            "doc_count": 1
                        }
                    ]
                }
            }
        },
        "rating-exists": {
            "doc_count": 8,
            "rating": {
                "value": 0.0
            }
        },
        "options-filter": {
            "doc_count": 0,
            "options-filter": {
                "doc_count": 0,
                "options": {
                    "doc_count_error_upper_bound": 0,
                    "sum_other_doc_count": 0,
                    "buckets": []
                }
            }
        },
        "price": {
            "count": 8,
            "min": 63.9,
            "max": 1500.0,
            "avg": 574.3,
            "sum": 4594.4
        },
        "manufacturer": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
                {
                    "key": "018d022892bf70a7891e2f84ceed3e04",
                    "doc_count": 8
                }
            ]
        }
    }
}

Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate

Cluster Status

{
    "cluster_name": "opensearch_9500",
    "status": "yellow",
    "timed_out": false,
    "number_of_nodes": 1,
    "number_of_data_nodes": 1,
    "discovered_master": true,
    "discovered_cluster_manager": true,
    "active_primary_shards": 86,
    "active_shards": 86,
    "relocating_shards": 0,
    "initializing_shards": 0,
    "unassigned_shards": 233,
    "delayed_unassigned_shards": 0,
    "number_of_pending_tasks": 0,
    "number_of_in_flight_fetch": 0,
    "task_max_waiting_in_queue_millis": 0,
    "active_shards_percent_as_number": 26.959247648902824
}

Indices

Name▲	Status	Replication (pri, rep)	Doc Count
sw-staging_product_1755509385	open	3, 3	183568
sw-admin-customer-listing_1757723402	open	3, 3	31812
top_queries-2025.09.06-00382	open	1, 1	65
sw-admin-pickware-erp-supplier-order-listing_1757723405	open	3, 3	32
top_queries-2025.09.08-00384	open	1, 1	1038
sw-admin-sales-channel-listing_1757723404	open	3, 3	11
sw-admin-cms-page-listing_1757723402	open	3, 3	117
sw-admin-pickware-erp-supplier-listing_1757723405	open	3, 3	129
sw-admin-pickware-erp-return-order-listing_1757723405	open	3, 3	13
sw-admin-payment-method-listing_1757723403	open	3, 3	39
.opensearch-observability	open	1, 0	0
sw-admin-pickware-wms-picking-profile-listing_1757723405	open	3, 3	10
top_queries-2025.09.11-00408	open	1, 1	110
sw-admin-pickware-erp-goods-receipt-listing_1757723405	open	3, 3	11
sw-admin-product-stream-listing_1757723405	open	3, 3	94
sw-admin-newsletter-recipient-listing_1757723404	open	3, 3	6049
sw-admin-customer-group-listing_1757723402	open	3, 3	5
sw-admin-pickware-erp-warehouse-listing_1757723405	open	3, 3	1
top_queries-2025.09.07-00383	open	1, 1	13
sw-admin-product-listing_1757723403	open	3, 3	2560
sw-admin-shipping-method-listing_1757723404	open	3, 3	15
top_queries-2025.09.13-00410	open	1, 1	292
top_queries-2025.09.09-00385	open	1, 1	458
sw-admin-landing-page-listing_1757723403	open	3, 3	1
top_queries-2025.09.12-00409	open	1, 1	616
top_queries-2025.09.10-00407	open	1, 1	493
sw-admin-category-listing_1757723404	open	3, 3	493
.plugins-ml-config	open	1, 0	1
sw-admin-pickware-wms-picking-process-listing_1757723405	open	3, 3	14
sw-admin-pickware-erp-batch-listing_1757723405	open	3, 3	0
sw-admin-order-listing_1757723403	open	3, 3	566
sw-admin-media-listing_1757723403	open	3, 3	12048
sw-admin-manufacturer-listing_1757723403	open	3, 3	314
sw-admin-promotion-listing_1757723404	open	3, 3	40
sw-admin-property-group-listing_1757723404	open	3, 3	44

Symfony Profiler

GET https://staging.sentivini.de/navigation/018d017368a17035beb6b2218da8acb3

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Cluster Status

Indices