Symfony Profiler

Query Metrics

9.00 ms Query Time

1 Node(s)

35 Indices

Queries

#▲ Execution Time Info

4.91 ms

#▲	Execution Time	Info
1	4.91 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":"018d017368a372d09a2a66fe63c3ff54"}}}},{"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: 21 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": "018d017368a372d09a2a66fe63c3ff54" } } } }, { "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": 21, "relation": "eq" }, "max_score": null, "hits": [ { "_index": "sw-staging_product_1755509385", "_id": "01993df3ff0172ccb467aa349bf2e415", "_score": 0.0, "_source": { "autoIncrement": 24349.0, "id": "01993df3ff0172ccb467aa349bf2e415" }, "fields": { "displayGroup": [ "f2ccec13e3c86af21aee205bd14bc56a" ] }, "sort": [ 0.0, 0.0, 0, 24349, "01993df3ff0172ccb467aa349bf2e415" ] }, { "_index": "sw-staging_product_1755509385", "_id": "01983c44e84873d6835bacbec41207f4", "_score": 0.0, "_source": { "autoIncrement": 24005.0, "id": "01983c44e84873d6835bacbec41207f4" }, "fields": { "displayGroup": [ "3885f7a37dceeea953f7b485462e64f5" ] }, "sort": [ 0.0, 0.0, 0, 24005, "01983c44e84873d6835bacbec41207f4" ] }, { "_index": "sw-staging_product_1755509385", "_id": "0197cb86a6d872a7aac980f5c91e20ff", "_score": 0.0, "_source": { "autoIncrement": 23970.0, "id": "0197cb86a6d872a7aac980f5c91e20ff" }, "fields": { "displayGroup": [ "fa3ee43142a3a38a6ad389738ee5ba9c" ] }, "sort": [ 0.0, 0.0, 0, 23970, "0197cb86a6d872a7aac980f5c91e20ff" ] }, { "_index": "sw-staging_product_1755509385", "_id": "01967c99296072fea0f71bcca16d8408", "_score": 0.0, "_source": { "autoIncrement": 23620.0, "id": "01967c99296072fea0f71bcca16d8408" }, "fields": { "displayGroup": [ "1a505065504c04cb6d2e788041214b4e" ] }, "sort": [ 0.0, 0.0, 0, 23620, "01967c99296072fea0f71bcca16d8408" ] }, { "_index": "sw-staging_product_1755509385", "_id": "01967c991eab7089bf11711cf930360a", "_score": 0.0, "_source": { "autoIncrement": 23568.0, "id": "01967c991eab7089bf11711cf930360a" }, "fields": { "displayGroup": [ "80a6053ec8206719d7b3fe19824f432e" ] }, "sort": [ 0.0, 0.0, 0, 23568, "01967c991eab7089bf11711cf930360a" ] }, { "_index": "sw-staging_product_1755509385", "_id": "01967c991e5d718aab3dd335cb7fea99", "_score": 0.0, "_source": { "autoIncrement": 23550.0, "id": "01967c991e5d718aab3dd335cb7fea99" }, "fields": { "displayGroup": [ "f4eab959bc54134427f6d1779b403d19" ] }, "sort": [ 0.0, 0.0, 0, 23550, "01967c991e5d718aab3dd335cb7fea99" ] }, { "_index": "sw-staging_product_1755509385", "_id": "01967c991e5273f69f9d3d5d99753cf2", "_score": 0.0, "_source": { "autoIncrement": 23546.0, "id": "01967c991e5273f69f9d3d5d99753cf2" }, "fields": { "displayGroup": [ "a4d3d1bf4dff263d9e2a646235da5298" ] }, "sort": [ 0.0, 0.0, 0, 23546, "01967c991e5273f69f9d3d5d99753cf2" ] }, { "_index": "sw-staging_product_1755509385", "_id": "01967c991e507028a0d7817c9dbf2c42", "_score": 0.0, "_source": { "autoIncrement": 23545.0, "id": "01967c991e507028a0d7817c9dbf2c42" }, "fields": { "displayGroup": [ "c18f42bab163c67a72ddbb8c5fd7d140" ] }, "sort": [ 0.0, 0.0, 0, 23545, "01967c991e507028a0d7817c9dbf2c42" ] }, { "_index": "sw-staging_product_1755509385", "_id": "01967c991e4c7079a499f36b0b1dd306", "_score": 0.0, "_source": { "autoIncrement": 23544.0, "id": "01967c991e4c7079a499f36b0b1dd306" }, "fields": { "displayGroup": [ "5d6aee050d4b55c15023129ab67981d7" ] }, "sort": [ 0.0, 0.0, 0, 23544, "01967c991e4c7079a499f36b0b1dd306" ] }, { "_index": "sw-staging_product_1755509385", "_id": "01943fcdc0227186874fc3d1bd3d994a", "_score": 0.0, "_source": { "autoIncrement": 20098.0, "id": "01943fcdc0227186874fc3d1bd3d994a" }, "fields": { "displayGroup": [ "9a651b5b52f60c3bb66ac4ff67bee7b7" ] }, "sort": [ 0.0, 0.0, 0, 20098, "01943fcdc0227186874fc3d1bd3d994a" ] }, { "_index": "sw-staging_product_1755509385", "_id": "01943fcd9e5e7034a45d2ae9dcc208b5", "_score": 0.0, "_source": { "autoIncrement": 20050.0, "id": "01943fcd9e5e7034a45d2ae9dcc208b5" }, "fields": { "displayGroup": [ "38245785138d49617c857962055127b5" ] }, "sort": [ 0.0, 0.0, 0, 20050, "01943fcd9e5e7034a45d2ae9dcc208b5" ] }, { "_index": "sw-staging_product_1755509385", "_id": "01943fcd60dc71f8babe856b9b52114b", "_score": 0.0, "_source": { "autoIncrement": 19861.0, "id": "01943fcd60dc71f8babe856b9b52114b" }, "fields": { "displayGroup": [ "11014790fb994fa7fdb59222450a0ccc" ] }, "sort": [ 0.0, 0.0, 0, 19861, "01943fcd60dc71f8babe856b9b52114b" ] }, { "_index": "sw-staging_product_1755509385", "_id": "01943fcd54bd7205855668619a2d8bbb", "_score": 0.0, "_source": { "autoIncrement": 19832.0, "id": "01943fcd54bd7205855668619a2d8bbb" }, "fields": { "displayGroup": [ "466139a543da3f0abd1f55c037b6e5bc" ] }, "sort": [ 0.0, 0.0, 0, 19832, "01943fcd54bd7205855668619a2d8bbb" ] }, { "_index": "sw-staging_product_1755509385", "_id": "0190fde266f4734a958a6fef554ec24e", "_score": 0.0, "_source": { "autoIncrement": 19627.0, "id": "0190fde266f4734a958a6fef554ec24e" }, "fields": { "displayGroup": [ "b019fa4e866f5e44c4a1035cfe165b91" ] }, "sort": [ 0.0, 0.0, 0, 19627, "0190fde266f4734a958a6fef554ec24e" ] }, { "_index": "sw-staging_product_1755509385", "_id": "018d0229c7a771bb9e04e6fd271aec06", "_score": 0.0, "_source": { "autoIncrement": 1790.0, "id": "018d0229c7a771bb9e04e6fd271aec06" }, "fields": { "displayGroup": [ "c0df54945637850cdc26cc7bc5cf495e" ] }, "sort": [ 0.0, 0.0, 0, 1790, "018d0229c7a771bb9e04e6fd271aec06" ] }, { "_index": "sw-staging_product_1755509385", "_id": "018d022986007169a0d19c068df85cc2", "_score": 0.0, "_source": { "autoIncrement": 1495.0, "id": "018d022986007169a0d19c068df85cc2" }, "fields": { "displayGroup": [ "472e4afad1539419bd63bfe75a7c7ca5" ] }, "sort": [ 0.0, 0.0, 0, 1495, "018d022986007169a0d19c068df85cc2" ] }, { "_index": "sw-staging_product_1755509385", "_id": "018d02296d16738582c11ab382d7e0b0", "_score": 0.0, "_source": { "autoIncrement": 1374.0, "id": "018d02296d16738582c11ab382d7e0b0" }, "fields": { "displayGroup": [ "889d94f3ef33a55c655b0f9af6f074cd" ] }, "sort": [ 0.0, 0.0, 0, 1374, "018d02296d16738582c11ab382d7e0b0" ] }, { "_index": "sw-staging_product_1755509385", "_id": "018d0229550c7220b293e527e689f16f", "_score": 0.0, "_source": { "autoIncrement": 1253.0, "id": "018d0229550c7220b293e527e689f16f" }, "fields": { "displayGroup": [ "3f184a8d7636b6897f066fbd2aed2a37" ] }, "sort": [ 0.0, 0.0, 0, 1253, "018d0229550c7220b293e527e689f16f" ] }, { "_index": "sw-staging_product_1755509385", "_id": "018d0228ee0a73e79dd31ca29c0f59c3", "_score": 0.0, "_source": { "autoIncrement": 782.0, "id": "018d0228ee0a73e79dd31ca29c0f59c3" }, "fields": { "displayGroup": [ "8a8c30b0e701c5b3be66ea1cd98f7a08" ] }, "sort": [ 0.0, 0.0, 0, 782, "018d0228ee0a73e79dd31ca29c0f59c3" ] }, { "_index": "sw-staging_product_1755509385", "_id": "018d0228ac4072178ae4bd74f98a3104", "_score": 0.0, "_source": { "autoIncrement": 484.0, "id": "018d0228ac4072178ae4bd74f98a3104" }, "fields": { "displayGroup": [ "1a2b4dc040af22f2cd006e905ae24605" ] }, "sort": [ 0.0, 0.0, 0, 484, "018d0228ac4072178ae4bd74f98a3104" ] }, { "_index": "sw-staging_product_1755509385", "_id": "018d0228ac2b7175be7fe73cb5066fd6", "_score": 0.0, "_source": { "autoIncrement": 483.0, "id": "018d0228ac2b7175be7fe73cb5066fd6" }, "fields": { "displayGroup": [ "c0da33de063ad9ccd168e3afbc43cd23" ] }, "sort": [ 0.0, 0.0, 0, 483, "018d0228ac2b7175be7fe73cb5066fd6" ] } ] }, "aggregations": { "total-count": { "value": 21 } } } `Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search`
2	4.32 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":"018d017368a372d09a2a66fe63c3ff54"}}}},{"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": "018d017368a372d09a2a66fe63c3ff54" } } } }, { "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": 553, "properties-filter": { "doc_count": 126, "properties": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [ { "key": "018d022bdd1a726998f01f4894d753a4", "doc_count": 21 }, { "key": "018d022bddd473e983cd961ff442364d", "doc_count": 21 }, { "key": "018d022c243f7379b6fcf898e3e363d3", "doc_count": 21 }, { "key": "018d022c3a6271f290d7ef6e169a0730", "doc_count": 14 }, { "key": "018d022bf1ec71829e91c8f34d7ce340", "doc_count": 12 }, { "key": "018d022bf4ab72aeb2b9b722af9951f1", "doc_count": 7 }, { "key": "018d022c3a407182b69327f39ec7082b", "doc_count": 7 }, { "key": "018d022bdf617298bc439b09b0466245", "doc_count": 6 }, { "key": "018d022bdf54736784570bc2af13104e", "doc_count": 5 }, { "key": "018d022bdf5b711b9339414fc0920beb", "doc_count": 5 }, { "key": "018d022bdf41726ea0bca4c57f5e0e37", "doc_count": 2 }, { "key": "0190fde2de7f71dca43ee37e91d664a2", "doc_count": 2 }, { "key": "01943fcfc01372dbb0d41dc3f9ee3c7d", "doc_count": 2 }, { "key": "018d022bdf2c735d8ef11eed6f1aeb5a", "doc_count": 1 } ] } } }, "rating-exists": { "doc_count": 21, "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": 21, "min": 16.9, "max": 379.9, "avg": 75.37619047619049, "sum": 1582.9 }, "manufacturer": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [ { "key": "018d0228ac2e721083242bb0609388d5", "doc_count": 20 }, { "key": "018d0228bed471b4bbab585e44ca405a", "doc_count": 1 } ] } } } `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":"018d017368a372d09a2a66fe63c3ff54"}}}},{"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: 21
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": "018d017368a372d09a2a66fe63c3ff54"
                                        }
                                    }
                                }
                            },
                            {
                                "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": 21,
            "relation": "eq"
        },
        "max_score": null,
        "hits": [
            {
                "_index": "sw-staging_product_1755509385",
                "_id": "01993df3ff0172ccb467aa349bf2e415",
                "_score": 0.0,
                "_source": {
                    "autoIncrement": 24349.0,
                    "id": "01993df3ff0172ccb467aa349bf2e415"
                },
                "fields": {
                    "displayGroup": [
                        "f2ccec13e3c86af21aee205bd14bc56a"
                    ]
                },
                "sort": [
                    0.0,
                    0.0,
                    0,
                    24349,
                    "01993df3ff0172ccb467aa349bf2e415"
                ]
            },
            {
                "_index": "sw-staging_product_1755509385",
                "_id": "01983c44e84873d6835bacbec41207f4",
                "_score": 0.0,
                "_source": {
                    "autoIncrement": 24005.0,
                    "id": "01983c44e84873d6835bacbec41207f4"
                },
                "fields": {
                    "displayGroup": [
                        "3885f7a37dceeea953f7b485462e64f5"
                    ]
                },
                "sort": [
                    0.0,
                    0.0,
                    0,
                    24005,
                    "01983c44e84873d6835bacbec41207f4"
                ]
            },
            {
                "_index": "sw-staging_product_1755509385",
                "_id": "0197cb86a6d872a7aac980f5c91e20ff",
                "_score": 0.0,
                "_source": {
                    "autoIncrement": 23970.0,
                    "id": "0197cb86a6d872a7aac980f5c91e20ff"
                },
                "fields": {
                    "displayGroup": [
                        "fa3ee43142a3a38a6ad389738ee5ba9c"
                    ]
                },
                "sort": [
                    0.0,
                    0.0,
                    0,
                    23970,
                    "0197cb86a6d872a7aac980f5c91e20ff"
                ]
            },
            {
                "_index": "sw-staging_product_1755509385",
                "_id": "01967c99296072fea0f71bcca16d8408",
                "_score": 0.0,
                "_source": {
                    "autoIncrement": 23620.0,
                    "id": "01967c99296072fea0f71bcca16d8408"
                },
                "fields": {
                    "displayGroup": [
                        "1a505065504c04cb6d2e788041214b4e"
                    ]
                },
                "sort": [
                    0.0,
                    0.0,
                    0,
                    23620,
                    "01967c99296072fea0f71bcca16d8408"
                ]
            },
            {
                "_index": "sw-staging_product_1755509385",
                "_id": "01967c991eab7089bf11711cf930360a",
                "_score": 0.0,
                "_source": {
                    "autoIncrement": 23568.0,
                    "id": "01967c991eab7089bf11711cf930360a"
                },
                "fields": {
                    "displayGroup": [
                        "80a6053ec8206719d7b3fe19824f432e"
                    ]
                },
                "sort": [
                    0.0,
                    0.0,
                    0,
                    23568,
                    "01967c991eab7089bf11711cf930360a"
                ]
            },
            {
                "_index": "sw-staging_product_1755509385",
                "_id": "01967c991e5d718aab3dd335cb7fea99",
                "_score": 0.0,
                "_source": {
                    "autoIncrement": 23550.0,
                    "id": "01967c991e5d718aab3dd335cb7fea99"
                },
                "fields": {
                    "displayGroup": [
                        "f4eab959bc54134427f6d1779b403d19"
                    ]
                },
                "sort": [
                    0.0,
                    0.0,
                    0,
                    23550,
                    "01967c991e5d718aab3dd335cb7fea99"
                ]
            },
            {
                "_index": "sw-staging_product_1755509385",
                "_id": "01967c991e5273f69f9d3d5d99753cf2",
                "_score": 0.0,
                "_source": {
                    "autoIncrement": 23546.0,
                    "id": "01967c991e5273f69f9d3d5d99753cf2"
                },
                "fields": {
                    "displayGroup": [
                        "a4d3d1bf4dff263d9e2a646235da5298"
                    ]
                },
                "sort": [
                    0.0,
                    0.0,
                    0,
                    23546,
                    "01967c991e5273f69f9d3d5d99753cf2"
                ]
            },
            {
                "_index": "sw-staging_product_1755509385",
                "_id": "01967c991e507028a0d7817c9dbf2c42",
                "_score": 0.0,
                "_source": {
                    "autoIncrement": 23545.0,
                    "id": "01967c991e507028a0d7817c9dbf2c42"
                },
                "fields": {
                    "displayGroup": [
                        "c18f42bab163c67a72ddbb8c5fd7d140"
                    ]
                },
                "sort": [
                    0.0,
                    0.0,
                    0,
                    23545,
                    "01967c991e507028a0d7817c9dbf2c42"
                ]
            },
            {
                "_index": "sw-staging_product_1755509385",
                "_id": "01967c991e4c7079a499f36b0b1dd306",
                "_score": 0.0,
                "_source": {
                    "autoIncrement": 23544.0,
                    "id": "01967c991e4c7079a499f36b0b1dd306"
                },
                "fields": {
                    "displayGroup": [
                        "5d6aee050d4b55c15023129ab67981d7"
                    ]
                },
                "sort": [
                    0.0,
                    0.0,
                    0,
                    23544,
                    "01967c991e4c7079a499f36b0b1dd306"
                ]
            },
            {
                "_index": "sw-staging_product_1755509385",
                "_id": "01943fcdc0227186874fc3d1bd3d994a",
                "_score": 0.0,
                "_source": {
                    "autoIncrement": 20098.0,
                    "id": "01943fcdc0227186874fc3d1bd3d994a"
                },
                "fields": {
                    "displayGroup": [
                        "9a651b5b52f60c3bb66ac4ff67bee7b7"
                    ]
                },
                "sort": [
                    0.0,
                    0.0,
                    0,
                    20098,
                    "01943fcdc0227186874fc3d1bd3d994a"
                ]
            },
            {
                "_index": "sw-staging_product_1755509385",
                "_id": "01943fcd9e5e7034a45d2ae9dcc208b5",
                "_score": 0.0,
                "_source": {
                    "autoIncrement": 20050.0,
                    "id": "01943fcd9e5e7034a45d2ae9dcc208b5"
                },
                "fields": {
                    "displayGroup": [
                        "38245785138d49617c857962055127b5"
                    ]
                },
                "sort": [
                    0.0,
                    0.0,
                    0,
                    20050,
                    "01943fcd9e5e7034a45d2ae9dcc208b5"
                ]
            },
            {
                "_index": "sw-staging_product_1755509385",
                "_id": "01943fcd60dc71f8babe856b9b52114b",
                "_score": 0.0,
                "_source": {
                    "autoIncrement": 19861.0,
                    "id": "01943fcd60dc71f8babe856b9b52114b"
                },
                "fields": {
                    "displayGroup": [
                        "11014790fb994fa7fdb59222450a0ccc"
                    ]
                },
                "sort": [
                    0.0,
                    0.0,
                    0,
                    19861,
                    "01943fcd60dc71f8babe856b9b52114b"
                ]
            },
            {
                "_index": "sw-staging_product_1755509385",
                "_id": "01943fcd54bd7205855668619a2d8bbb",
                "_score": 0.0,
                "_source": {
                    "autoIncrement": 19832.0,
                    "id": "01943fcd54bd7205855668619a2d8bbb"
                },
                "fields": {
                    "displayGroup": [
                        "466139a543da3f0abd1f55c037b6e5bc"
                    ]
                },
                "sort": [
                    0.0,
                    0.0,
                    0,
                    19832,
                    "01943fcd54bd7205855668619a2d8bbb"
                ]
            },
            {
                "_index": "sw-staging_product_1755509385",
                "_id": "0190fde266f4734a958a6fef554ec24e",
                "_score": 0.0,
                "_source": {
                    "autoIncrement": 19627.0,
                    "id": "0190fde266f4734a958a6fef554ec24e"
                },
                "fields": {
                    "displayGroup": [
                        "b019fa4e866f5e44c4a1035cfe165b91"
                    ]
                },
                "sort": [
                    0.0,
                    0.0,
                    0,
                    19627,
                    "0190fde266f4734a958a6fef554ec24e"
                ]
            },
            {
                "_index": "sw-staging_product_1755509385",
                "_id": "018d0229c7a771bb9e04e6fd271aec06",
                "_score": 0.0,
                "_source": {
                    "autoIncrement": 1790.0,
                    "id": "018d0229c7a771bb9e04e6fd271aec06"
                },
                "fields": {
                    "displayGroup": [
                        "c0df54945637850cdc26cc7bc5cf495e"
                    ]
                },
                "sort": [
                    0.0,
                    0.0,
                    0,
                    1790,
                    "018d0229c7a771bb9e04e6fd271aec06"
                ]
            },
            {
                "_index": "sw-staging_product_1755509385",
                "_id": "018d022986007169a0d19c068df85cc2",
                "_score": 0.0,
                "_source": {
                    "autoIncrement": 1495.0,
                    "id": "018d022986007169a0d19c068df85cc2"
                },
                "fields": {
                    "displayGroup": [
                        "472e4afad1539419bd63bfe75a7c7ca5"
                    ]
                },
                "sort": [
                    0.0,
                    0.0,
                    0,
                    1495,
                    "018d022986007169a0d19c068df85cc2"
                ]
            },
            {
                "_index": "sw-staging_product_1755509385",
                "_id": "018d02296d16738582c11ab382d7e0b0",
                "_score": 0.0,
                "_source": {
                    "autoIncrement": 1374.0,
                    "id": "018d02296d16738582c11ab382d7e0b0"
                },
                "fields": {
                    "displayGroup": [
                        "889d94f3ef33a55c655b0f9af6f074cd"
                    ]
                },
                "sort": [
                    0.0,
                    0.0,
                    0,
                    1374,
                    "018d02296d16738582c11ab382d7e0b0"
                ]
            },
            {
                "_index": "sw-staging_product_1755509385",
                "_id": "018d0229550c7220b293e527e689f16f",
                "_score": 0.0,
                "_source": {
                    "autoIncrement": 1253.0,
                    "id": "018d0229550c7220b293e527e689f16f"
                },
                "fields": {
                    "displayGroup": [
                        "3f184a8d7636b6897f066fbd2aed2a37"
                    ]
                },
                "sort": [
                    0.0,
                    0.0,
                    0,
                    1253,
                    "018d0229550c7220b293e527e689f16f"
                ]
            },
            {
                "_index": "sw-staging_product_1755509385",
                "_id": "018d0228ee0a73e79dd31ca29c0f59c3",
                "_score": 0.0,
                "_source": {
                    "autoIncrement": 782.0,
                    "id": "018d0228ee0a73e79dd31ca29c0f59c3"
                },
                "fields": {
                    "displayGroup": [
                        "8a8c30b0e701c5b3be66ea1cd98f7a08"
                    ]
                },
                "sort": [
                    0.0,
                    0.0,
                    0,
                    782,
                    "018d0228ee0a73e79dd31ca29c0f59c3"
                ]
            },
            {
                "_index": "sw-staging_product_1755509385",
                "_id": "018d0228ac4072178ae4bd74f98a3104",
                "_score": 0.0,
                "_source": {
                    "autoIncrement": 484.0,
                    "id": "018d0228ac4072178ae4bd74f98a3104"
                },
                "fields": {
                    "displayGroup": [
                        "1a2b4dc040af22f2cd006e905ae24605"
                    ]
                },
                "sort": [
                    0.0,
                    0.0,
                    0,
                    484,
                    "018d0228ac4072178ae4bd74f98a3104"
                ]
            },
            {
                "_index": "sw-staging_product_1755509385",
                "_id": "018d0228ac2b7175be7fe73cb5066fd6",
                "_score": 0.0,
                "_source": {
                    "autoIncrement": 483.0,
                    "id": "018d0228ac2b7175be7fe73cb5066fd6"
                },
                "fields": {
                    "displayGroup": [
                        "c0da33de063ad9ccd168e3afbc43cd23"
                    ]
                },
                "sort": [
                    0.0,
                    0.0,
                    0,
                    483,
                    "018d0228ac2b7175be7fe73cb5066fd6"
                ]
            }
        ]
    },
    "aggregations": {
        "total-count": {
            "value": 21
        }
    }
}

Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search

4.32 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":"018d017368a372d09a2a66fe63c3ff54"}}}},{"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": "018d017368a372d09a2a66fe63c3ff54"
                                        }
                                    }
                                }
                            },
                            {
                                "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": 553,
            "properties-filter": {
                "doc_count": 126,
                "properties": {
                    "doc_count_error_upper_bound": 0,
                    "sum_other_doc_count": 0,
                    "buckets": [
                        {
                            "key": "018d022bdd1a726998f01f4894d753a4",
                            "doc_count": 21
                        },
                        {
                            "key": "018d022bddd473e983cd961ff442364d",
                            "doc_count": 21
                        },
                        {
                            "key": "018d022c243f7379b6fcf898e3e363d3",
                            "doc_count": 21
                        },
                        {
                            "key": "018d022c3a6271f290d7ef6e169a0730",
                            "doc_count": 14
                        },
                        {
                            "key": "018d022bf1ec71829e91c8f34d7ce340",
                            "doc_count": 12
                        },
                        {
                            "key": "018d022bf4ab72aeb2b9b722af9951f1",
                            "doc_count": 7
                        },
                        {
                            "key": "018d022c3a407182b69327f39ec7082b",
                            "doc_count": 7
                        },
                        {
                            "key": "018d022bdf617298bc439b09b0466245",
                            "doc_count": 6
                        },
                        {
                            "key": "018d022bdf54736784570bc2af13104e",
                            "doc_count": 5
                        },
                        {
                            "key": "018d022bdf5b711b9339414fc0920beb",
                            "doc_count": 5
                        },
                        {
                            "key": "018d022bdf41726ea0bca4c57f5e0e37",
                            "doc_count": 2
                        },
                        {
                            "key": "0190fde2de7f71dca43ee37e91d664a2",
                            "doc_count": 2
                        },
                        {
                            "key": "01943fcfc01372dbb0d41dc3f9ee3c7d",
                            "doc_count": 2
                        },
                        {
                            "key": "018d022bdf2c735d8ef11eed6f1aeb5a",
                            "doc_count": 1
                        }
                    ]
                }
            }
        },
        "rating-exists": {
            "doc_count": 21,
            "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": 21,
            "min": 16.9,
            "max": 379.9,
            "avg": 75.37619047619049,
            "sum": 1582.9
        },
        "manufacturer": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
                {
                    "key": "018d0228ac2e721083242bb0609388d5",
                    "doc_count": 20
                },
                {
                    "key": "018d0228bed471b4bbab585e44ca405a",
                    "doc_count": 1
                }
            ]
        }
    }
}

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	89
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/018d017368a372d09a2a66fe63c3ff54

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Cluster Status

Indices