Symfony Profiler

Query Metrics

7.00 ms Query Time

1 Node(s)

190 Indices

Queries

#▲ Execution Time Info

7.08 ms

#▲	Execution Time	Info
1	7.08 ms	Request: {"index":"sw_dev_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":"0189b5bd293f71c6a5e92e9980f13639"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"377cea45f8a5497883a037ce18a89a53"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}},{"bool":{"must_not":[{"bool":{"must":[{"term":{"isCloseout":true}},{"term":{"available":false}}]}}]}}]}}]}},"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_rule471f2ca5e74440568ba57912bb0f3d50_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0195f6d45aa0724c87d5074001f1a2d1_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0195f6d45c737359b28ecfb92c53d069_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rulebc145323ade940ba94e1431217d21eb6_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc757970f38af8d735ac2bef24_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc757d738cb8f62b8ca13162fd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc781372e48ae25e3fc49e6c75_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5c9ab9f7213be6b9f7eb5a0be77_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5c9aba570cdb1eb3cecd2cd9c14_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5c9abd170d5a439e74a4020e81c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule018c7cebb95d7085930868a24624ed56_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0194f9d3715f7f529a3ef1fb3551b54e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc758c718ca89324f9e3bbcdfd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule01954bf358787bddabd639e08f98cde7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule01954bf6ea96775e82e896fe56d60a5c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule01954bf8accc7149bfe1807e67aa05ab_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5c9ab9b73b8b6ca8da792e44880_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cebb7d71a3937f90ce846b78ad_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cebb8870c3a0d7916756166232_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cebb987107b20becc38a90e410_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cebb9b731b9ef2ca9a3c0e2e19_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cebb9e7245a64ccd2ca462bba7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cebba27154ba4b3557620fbed5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec73f71a8ba659d9cb213157a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec743726f9e900fe942743ec9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec74670539b2bed35e48007ed_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec79573ce87a699e82c77ca99_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec79e72c0a0cc7f7518e1c7a0_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec7a17342a94f499b908eb3c3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec7a67189aed96e522a050f7f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec7ad732ba4fca7f80c74c02c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec7b17013af6e99af52d09228_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec7d670be81a63be615cff357_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec7fa715eb3c904adfa6d2214_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec81c709aa4a0eb7f072bffef_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec83e73ceb6955e47bc5234ab_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec860709abfd7eac6765915c9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec88370108c594aac8328aab9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec8ab704bb164800ad4f9d598_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec8d270769eae865bca59328f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec930710b8cdfad050e36f664_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec95373fea9fe590044a03214_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","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":{"nested":{"path":"properties"},"aggregations":{"properties":{"terms":{"field":"properties.id","size":10000}}}},"options":{"nested":{"path":"options"},"aggregations":{"options":{"terms":{"field":"options.id","size":10000}}}},"manufacturer_count":{"terms":{"field":"manufacturerId","size":10000}},"propertiesCount":{"terms":{"field":"propertyIds","size":10000}},"immediately-available-filter":{"max":{"field":"availableStock"}}},"size":0,"timeout":"5s"},"search_type":"query_then_fetch"} Item count: View formatted request View formatted response View query backtrace POST http://10.20.0.3:9200/sw_dev_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": "0189b5bd293f71c6a5e92e9980f13639" } } ] } } } }, { "term": { "active": true } } ] } }, { "nested": { "path": "categoriesRo", "query": { "term": { "categoriesRo.id": "377cea45f8a5497883a037ce18a89a53" } } } }, { "bool": { "must_not": [ { "bool": { "must_not": [ { "exists": { "field": "displayGroup" } } ] } } ] } }, { "bool": { "must_not": [ { "bool": { "must": [ { "term": { "isCloseout": true } }, { "term": { "available": false } } ] } } ] } } ] } } ] } }, "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_rule471f2ca5e74440568ba57912bb0f3d50_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0195f6d45aa0724c87d5074001f1a2d1_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0195f6d45c737359b28ecfb92c53d069_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rulebc145323ade940ba94e1431217d21eb6_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0189b5bc757970f38af8d735ac2bef24_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0189b5bc757d738cb8f62b8ca13162fd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0189b5bc781372e48ae25e3fc49e6c75_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0189b5c9ab9f7213be6b9f7eb5a0be77_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0189b5c9aba570cdb1eb3cecd2cd9c14_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0189b5c9abd170d5a439e74a4020e81c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule018c7cebb95d7085930868a24624ed56_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0194f9d3715f7f529a3ef1fb3551b54e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0189b5bc758c718ca89324f9e3bbcdfd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule01954bf358787bddabd639e08f98cde7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule01954bf6ea96775e82e896fe56d60a5c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule01954bf8accc7149bfe1807e67aa05ab_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0189b5c9ab9b73b8b6ca8da792e44880_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0189b5cebb7d71a3937f90ce846b78ad_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0189b5cebb8870c3a0d7916756166232_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0189b5cebb987107b20becc38a90e410_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0189b5cebb9b731b9ef2ca9a3c0e2e19_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0189b5cebb9e7245a64ccd2ca462bba7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0189b5cebba27154ba4b3557620fbed5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0189b5cec73f71a8ba659d9cb213157a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0189b5cec743726f9e900fe942743ec9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0189b5cec74670539b2bed35e48007ed_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0189b5cec79573ce87a699e82c77ca99_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0189b5cec79e72c0a0cc7f7518e1c7a0_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0189b5cec7a17342a94f499b908eb3c3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0189b5cec7a67189aed96e522a050f7f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0189b5cec7ad732ba4fca7f80c74c02c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0189b5cec7b17013af6e99af52d09228_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0189b5cec7d670be81a63be615cff357_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0189b5cec7fa715eb3c904adfa6d2214_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0189b5cec81c709aa4a0eb7f072bffef_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0189b5cec83e73ceb6955e47bc5234ab_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0189b5cec860709abfd7eac6765915c9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0189b5cec88370108c594aac8328aab9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0189b5cec8ab704bb164800ad4f9d598_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0189b5cec8d270769eae865bca59328f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0189b5cec930710b8cdfad050e36f664_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0189b5cec95373fea9fe590044a03214_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "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": { "nested": { "path": "properties" }, "aggregations": { "properties": { "terms": { "field": "properties.id", "size": 10000 } } } }, "options": { "nested": { "path": "options" }, "aggregations": { "options": { "terms": { "field": "options.id", "size": 10000 } } } }, "manufacturer_count": { "terms": { "field": "manufacturerId", "size": 10000 } }, "propertiesCount": { "terms": { "field": "propertyIds", "size": 10000 } }, "immediately-available-filter": { "max": { "field": "availableStock" } } }, "size": 0, "timeout": "5s" } { "took": 1, "timed_out": false, "_shards": { "total": 3, "successful": 3, "skipped": 0, "failed": 0 }, "hits": { "max_score": null, "hits": [] }, "aggregations": { "manufacturer_count": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [ { "key": "0189b5ced58e706890ac8b39799f9c9a", "doc_count": 14 }, { "key": "0189b5ced5897359a1b2b50cde8fb80d", "doc_count": 1 } ] }, "shipping-free-filter": { "doc_count": 0, "shipping-free": { "value": null } }, "propertiesCount": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [ { "key": "0189b5cf6261731aa3b57e889fb380be", "doc_count": 9 }, { "key": "0189b5cf61f3730798350d9bdea78bf7", "doc_count": 8 }, { "key": "0189b5cf625f7102b41b104a1ead8781", "doc_count": 7 }, { "key": "0189b5cf683a714c951a2c6108ee7ea7", "doc_count": 7 }, { "key": "0189b5cf6a4070c28592f0ec9d77c54a", "doc_count": 7 }, { "key": "0189b5cf558a700593a710abd74f83a9", "doc_count": 5 }, { "key": "0189b5cf627c722b8933a2615bb050e3", "doc_count": 5 }, { "key": "0189b5cf6283715f815f3676940d87ae", "doc_count": 5 }, { "key": "0189b5cf58587246aa97949b494a452a", "doc_count": 4 }, { "key": "0189b5cf5903737d815ab6ffd65eb192", "doc_count": 4 }, { "key": "0189b5cf59627097bcc4c633ada73c5d", "doc_count": 4 }, { "key": "0189b5cf615d7034a4a5e9bf4d63918e", "doc_count": 4 }, { "key": "0189b5cf615e70839d374fd5b1d8496f", "doc_count": 4 }, { "key": "0189b5cf62637211a4fffad27b01ad11", "doc_count": 4 }, { "key": "0189b5cf626a723ca261222ea304d942", "doc_count": 4 }, { "key": "0189b5cf6276730792cc1e7fa906e21f", "doc_count": 4 }, { "key": "0189b5cf627f7301b7834b8aea5c8e6d", "doc_count": 4 }, { "key": "0189b5cf699070828fe07ba1617dba58", "doc_count": 4 }, { "key": "0189b5cf585b712f9c42c40d15253204", "doc_count": 3 }, { "key": "0189b5cf590570078d5d9b3a400c325d", "doc_count": 3 }, { "key": "0189b5cf59667155a1ae46c357828943", "doc_count": 3 }, { "key": "0189b5cf618773879e1877e219b5961f", "doc_count": 3 }, { "key": "0189b5cf62687139a55d721a1eedcd5b", "doc_count": 3 }, { "key": "0189b5cf628570778819e92d7cdc155d", "doc_count": 3 }, { "key": "0189b5cf686c706bb178ecddbd291f6b", "doc_count": 3 }, { "key": "0189b5cf686e701ab45785ef32774ee1", "doc_count": 3 }, { "key": "0189b5cf6993734f81b0c6da014227ec", "doc_count": 3 }, { "key": "0189b5cf69fe724f85a901dc0706fc90", "doc_count": 3 }, { "key": "0189b5cf558e70e99ea6566e02462eb9", "doc_count": 2 }, { "key": "0189b5cf61f572898a83b9143059aaf3", "doc_count": 2 }, { "key": "0189b5cf626571b7b44e0df5fe5f07b5", "doc_count": 2 }, { "key": "0189b5cf627a72caa13a417faddbaa0f", "doc_count": 2 }, { "key": "0189b5cf627c722b8933a2614d1aa050", "doc_count": 2 }, { "key": "0189b5cf627d71e2a9e72d4fe55e7fe1", "doc_count": 2 }, { "key": "0189b5cf6280717bb1d9fcc6e4282d0f", "doc_count": 2 }, { "key": "0189b5cf628173e7af6b5c8c632902f1", "doc_count": 2 }, { "key": "0189b5cf628271c0a119d02a181997e9", "doc_count": 2 }, { "key": "0189b5cf6284728db44ef634e153c3dc", "doc_count": 2 }, { "key": "0189b5cf62ad71c9bdda03d9b77c0e8c", "doc_count": 2 }, { "key": "0189b5cf6a027022bcd26ce322832729", "doc_count": 2 }, { "key": "0189b5cf626271ab8a706e918f73e0f6", "doc_count": 1 }, { "key": "0189b5cf62677385b616f33507d34ca0", "doc_count": 1 }, { "key": "0189b5cf627872059afb72f79166f1a8", "doc_count": 1 }, { "key": "0189b5cf6279712d9cafe7efb1c4da8e", "doc_count": 1 }, { "key": "0189b5cf628570778819e92d70a05dd1", "doc_count": 1 }, { "key": "0189b5cf62ae7072bbe7b6312e0a6ea4", "doc_count": 1 }, { "key": "0189b5cf62af7151bd3451bd3742e1de", "doc_count": 1 }, { "key": "0189b5cf68737046b22e4684250f2c9a", "doc_count": 1 }, { "key": "0189b5cf6a0070e08910adba8db7e6f0", "doc_count": 1 }, { "key": "0189b5cf6a0173a9ab7088b682e9ce51", "doc_count": 1 }, { "key": "0189b5cf6aad710089915d94f19f640d", "doc_count": 1 }, { "key": "0189b5cf6aae73129fe43da50d43f0a2", "doc_count": 1 }, { "key": "0189b5cf6aaf73f09601d49d132afd12", "doc_count": 1 }, { "key": "9ca9a210df8444938c7e80fa08dde355", "doc_count": 1 } ] }, "rating-exists": { "doc_count": 15, "rating": { "value": 5.0 } }, "price": { "count": 15, "min": 3.0, "max": 2500.0, "avg": 403.2, "sum": 6048.0 }, "immediately-available-filter": { "value": 1482.0 }, "options": { "doc_count": 0, "options": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [] } }, "properties": { "doc_count": 161, "properties": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [ { "key": "0189b5cf6261731aa3b57e889fb380be", "doc_count": 9 }, { "key": "0189b5cf61f3730798350d9bdea78bf7", "doc_count": 8 }, { "key": "0189b5cf625f7102b41b104a1ead8781", "doc_count": 7 }, { "key": "0189b5cf683a714c951a2c6108ee7ea7", "doc_count": 7 }, { "key": "0189b5cf6a4070c28592f0ec9d77c54a", "doc_count": 7 }, { "key": "0189b5cf558a700593a710abd74f83a9", "doc_count": 5 }, { "key": "0189b5cf627c722b8933a2615bb050e3", "doc_count": 5 }, { "key": "0189b5cf6283715f815f3676940d87ae", "doc_count": 5 }, { "key": "0189b5cf58587246aa97949b494a452a", "doc_count": 4 }, { "key": "0189b5cf5903737d815ab6ffd65eb192", "doc_count": 4 }, { "key": "0189b5cf59627097bcc4c633ada73c5d", "doc_count": 4 }, { "key": "0189b5cf615d7034a4a5e9bf4d63918e", "doc_count": 4 }, { "key": "0189b5cf615e70839d374fd5b1d8496f", "doc_count": 4 }, { "key": "0189b5cf62637211a4fffad27b01ad11", "doc_count": 4 }, { "key": "0189b5cf626a723ca261222ea304d942", "doc_count": 4 }, { "key": "0189b5cf6276730792cc1e7fa906e21f", "doc_count": 4 }, { "key": "0189b5cf627f7301b7834b8aea5c8e6d", "doc_count": 4 }, { "key": "0189b5cf699070828fe07ba1617dba58", "doc_count": 4 }, { "key": "0189b5cf585b712f9c42c40d15253204", "doc_count": 3 }, { "key": "0189b5cf590570078d5d9b3a400c325d", "doc_count": 3 }, { "key": "0189b5cf59667155a1ae46c357828943", "doc_count": 3 }, { "key": "0189b5cf618773879e1877e219b5961f", "doc_count": 3 }, { "key": "0189b5cf62687139a55d721a1eedcd5b", "doc_count": 3 }, { "key": "0189b5cf628570778819e92d7cdc155d", "doc_count": 3 }, { "key": "0189b5cf686c706bb178ecddbd291f6b", "doc_count": 3 }, { "key": "0189b5cf686e701ab45785ef32774ee1", "doc_count": 3 }, { "key": "0189b5cf6993734f81b0c6da014227ec", "doc_count": 3 }, { "key": "0189b5cf69fe724f85a901dc0706fc90", "doc_count": 3 }, { "key": "0189b5cf558e70e99ea6566e02462eb9", "doc_count": 2 }, { "key": "0189b5cf61f572898a83b9143059aaf3", "doc_count": 2 }, { "key": "0189b5cf626571b7b44e0df5fe5f07b5", "doc_count": 2 }, { "key": "0189b5cf627a72caa13a417faddbaa0f", "doc_count": 2 }, { "key": "0189b5cf627c722b8933a2614d1aa050", "doc_count": 2 }, { "key": "0189b5cf627d71e2a9e72d4fe55e7fe1", "doc_count": 2 }, { "key": "0189b5cf6280717bb1d9fcc6e4282d0f", "doc_count": 2 }, { "key": "0189b5cf628173e7af6b5c8c632902f1", "doc_count": 2 }, { "key": "0189b5cf628271c0a119d02a181997e9", "doc_count": 2 }, { "key": "0189b5cf6284728db44ef634e153c3dc", "doc_count": 2 }, { "key": "0189b5cf62ad71c9bdda03d9b77c0e8c", "doc_count": 2 }, { "key": "0189b5cf6a027022bcd26ce322832729", "doc_count": 2 }, { "key": "0189b5cf626271ab8a706e918f73e0f6", "doc_count": 1 }, { "key": "0189b5cf62677385b616f33507d34ca0", "doc_count": 1 }, { "key": "0189b5cf627872059afb72f79166f1a8", "doc_count": 1 }, { "key": "0189b5cf6279712d9cafe7efb1c4da8e", "doc_count": 1 }, { "key": "0189b5cf628570778819e92d70a05dd1", "doc_count": 1 }, { "key": "0189b5cf62ae7072bbe7b6312e0a6ea4", "doc_count": 1 }, { "key": "0189b5cf62af7151bd3451bd3742e1de", "doc_count": 1 }, { "key": "0189b5cf68737046b22e4684250f2c9a", "doc_count": 1 }, { "key": "0189b5cf6a0070e08910adba8db7e6f0", "doc_count": 1 }, { "key": "0189b5cf6a0173a9ab7088b682e9ce51", "doc_count": 1 }, { "key": "0189b5cf6aad710089915d94f19f640d", "doc_count": 1 }, { "key": "0189b5cf6aae73129fe43da50d43f0a2", "doc_count": 1 }, { "key": "0189b5cf6aaf73f09601d49d132afd12", "doc_count": 1 }, { "key": "9ca9a210df8444938c7e80fa08dde355", "doc_count": 1 } ] } }, "manufacturer": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [ { "key": "0189b5ced58e706890ac8b39799f9c9a", "doc_count": 14 }, { "key": "0189b5ced5897359a1b2b50cde8fb80d", "doc_count": 1 } ] } } } `Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate`

Request:

{"index":"sw_dev_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":"0189b5bd293f71c6a5e92e9980f13639"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"377cea45f8a5497883a037ce18a89a53"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}},{"bool":{"must_not":[{"bool":{"must":[{"term":{"isCloseout":true}},{"term":{"available":false}}]}}]}}]}}]}},"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_rule471f2ca5e74440568ba57912bb0f3d50_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0195f6d45aa0724c87d5074001f1a2d1_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0195f6d45c737359b28ecfb92c53d069_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rulebc145323ade940ba94e1431217d21eb6_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc757970f38af8d735ac2bef24_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc757d738cb8f62b8ca13162fd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc781372e48ae25e3fc49e6c75_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5c9ab9f7213be6b9f7eb5a0be77_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5c9aba570cdb1eb3cecd2cd9c14_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5c9abd170d5a439e74a4020e81c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule018c7cebb95d7085930868a24624ed56_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0194f9d3715f7f529a3ef1fb3551b54e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc758c718ca89324f9e3bbcdfd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule01954bf358787bddabd639e08f98cde7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule01954bf6ea96775e82e896fe56d60a5c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule01954bf8accc7149bfe1807e67aa05ab_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5c9ab9b73b8b6ca8da792e44880_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cebb7d71a3937f90ce846b78ad_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cebb8870c3a0d7916756166232_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cebb987107b20becc38a90e410_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cebb9b731b9ef2ca9a3c0e2e19_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cebb9e7245a64ccd2ca462bba7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cebba27154ba4b3557620fbed5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec73f71a8ba659d9cb213157a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec743726f9e900fe942743ec9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec74670539b2bed35e48007ed_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec79573ce87a699e82c77ca99_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec79e72c0a0cc7f7518e1c7a0_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec7a17342a94f499b908eb3c3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec7a67189aed96e522a050f7f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec7ad732ba4fca7f80c74c02c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec7b17013af6e99af52d09228_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec7d670be81a63be615cff357_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec7fa715eb3c904adfa6d2214_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec81c709aa4a0eb7f072bffef_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec83e73ceb6955e47bc5234ab_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec860709abfd7eac6765915c9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec88370108c594aac8328aab9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec8ab704bb164800ad4f9d598_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec8d270769eae865bca59328f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec930710b8cdfad050e36f664_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec95373fea9fe590044a03214_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","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":{"nested":{"path":"properties"},"aggregations":{"properties":{"terms":{"field":"properties.id","size":10000}}}},"options":{"nested":{"path":"options"},"aggregations":{"options":{"terms":{"field":"options.id","size":10000}}}},"manufacturer_count":{"terms":{"field":"manufacturerId","size":10000}},"propertiesCount":{"terms":{"field":"propertyIds","size":10000}},"immediately-available-filter":{"max":{"field":"availableStock"}}},"size":0,"timeout":"5s"},"search_type":"query_then_fetch"}

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


                                    POST http://10.20.0.3:9200/sw_dev_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": "0189b5bd293f71c6a5e92e9980f13639"
                                                                }
                                                            }
                                                        ]
                                                    }
                                                }
                                            }
                                        },
                                        {
                                            "term": {
                                                "active": true
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "nested": {
                                    "path": "categoriesRo",
                                    "query": {
                                        "term": {
                                            "categoriesRo.id": "377cea45f8a5497883a037ce18a89a53"
                                        }
                                    }
                                }
                            },
                            {
                                "bool": {
                                    "must_not": [
                                        {
                                            "bool": {
                                                "must_not": [
                                                    {
                                                        "exists": {
                                                            "field": "displayGroup"
                                                        }
                                                    }
                                                ]
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "bool": {
                                    "must_not": [
                                        {
                                            "bool": {
                                                "must": [
                                                    {
                                                        "term": {
                                                            "isCloseout": true
                                                        }
                                                    },
                                                    {
                                                        "term": {
                                                            "available": false
                                                        }
                                                    }
                                                ]
                                            }
                                        }
                                    ]
                                }
                            }
                        ]
                    }
                }
            ]
        }
    },
    "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_rule471f2ca5e74440568ba57912bb0f3d50_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0195f6d45aa0724c87d5074001f1a2d1_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0195f6d45c737359b28ecfb92c53d069_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rulebc145323ade940ba94e1431217d21eb6_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0189b5bc757970f38af8d735ac2bef24_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0189b5bc757d738cb8f62b8ca13162fd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0189b5bc781372e48ae25e3fc49e6c75_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0189b5c9ab9f7213be6b9f7eb5a0be77_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0189b5c9aba570cdb1eb3cecd2cd9c14_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0189b5c9abd170d5a439e74a4020e81c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule018c7cebb95d7085930868a24624ed56_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0194f9d3715f7f529a3ef1fb3551b54e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0189b5bc758c718ca89324f9e3bbcdfd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule01954bf358787bddabd639e08f98cde7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule01954bf6ea96775e82e896fe56d60a5c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule01954bf8accc7149bfe1807e67aa05ab_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0189b5c9ab9b73b8b6ca8da792e44880_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0189b5cebb7d71a3937f90ce846b78ad_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0189b5cebb8870c3a0d7916756166232_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0189b5cebb987107b20becc38a90e410_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0189b5cebb9b731b9ef2ca9a3c0e2e19_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0189b5cebb9e7245a64ccd2ca462bba7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0189b5cebba27154ba4b3557620fbed5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0189b5cec73f71a8ba659d9cb213157a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0189b5cec743726f9e900fe942743ec9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0189b5cec74670539b2bed35e48007ed_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0189b5cec79573ce87a699e82c77ca99_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0189b5cec79e72c0a0cc7f7518e1c7a0_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0189b5cec7a17342a94f499b908eb3c3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0189b5cec7a67189aed96e522a050f7f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0189b5cec7ad732ba4fca7f80c74c02c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0189b5cec7b17013af6e99af52d09228_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0189b5cec7d670be81a63be615cff357_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0189b5cec7fa715eb3c904adfa6d2214_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0189b5cec81c709aa4a0eb7f072bffef_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0189b5cec83e73ceb6955e47bc5234ab_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0189b5cec860709abfd7eac6765915c9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0189b5cec88370108c594aac8328aab9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0189b5cec8ab704bb164800ad4f9d598_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0189b5cec8d270769eae865bca59328f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0189b5cec930710b8cdfad050e36f664_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0189b5cec95373fea9fe590044a03214_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "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": {
            "nested": {
                "path": "properties"
            },
            "aggregations": {
                "properties": {
                    "terms": {
                        "field": "properties.id",
                        "size": 10000
                    }
                }
            }
        },
        "options": {
            "nested": {
                "path": "options"
            },
            "aggregations": {
                "options": {
                    "terms": {
                        "field": "options.id",
                        "size": 10000
                    }
                }
            }
        },
        "manufacturer_count": {
            "terms": {
                "field": "manufacturerId",
                "size": 10000
            }
        },
        "propertiesCount": {
            "terms": {
                "field": "propertyIds",
                "size": 10000
            }
        },
        "immediately-available-filter": {
            "max": {
                "field": "availableStock"
            }
        }
    },
    "size": 0,
    "timeout": "5s"
}


                                    {
    "took": 1,
    "timed_out": false,
    "_shards": {
        "total": 3,
        "successful": 3,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "max_score": null,
        "hits": []
    },
    "aggregations": {
        "manufacturer_count": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
                {
                    "key": "0189b5ced58e706890ac8b39799f9c9a",
                    "doc_count": 14
                },
                {
                    "key": "0189b5ced5897359a1b2b50cde8fb80d",
                    "doc_count": 1
                }
            ]
        },
        "shipping-free-filter": {
            "doc_count": 0,
            "shipping-free": {
                "value": null
            }
        },
        "propertiesCount": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
                {
                    "key": "0189b5cf6261731aa3b57e889fb380be",
                    "doc_count": 9
                },
                {
                    "key": "0189b5cf61f3730798350d9bdea78bf7",
                    "doc_count": 8
                },
                {
                    "key": "0189b5cf625f7102b41b104a1ead8781",
                    "doc_count": 7
                },
                {
                    "key": "0189b5cf683a714c951a2c6108ee7ea7",
                    "doc_count": 7
                },
                {
                    "key": "0189b5cf6a4070c28592f0ec9d77c54a",
                    "doc_count": 7
                },
                {
                    "key": "0189b5cf558a700593a710abd74f83a9",
                    "doc_count": 5
                },
                {
                    "key": "0189b5cf627c722b8933a2615bb050e3",
                    "doc_count": 5
                },
                {
                    "key": "0189b5cf6283715f815f3676940d87ae",
                    "doc_count": 5
                },
                {
                    "key": "0189b5cf58587246aa97949b494a452a",
                    "doc_count": 4
                },
                {
                    "key": "0189b5cf5903737d815ab6ffd65eb192",
                    "doc_count": 4
                },
                {
                    "key": "0189b5cf59627097bcc4c633ada73c5d",
                    "doc_count": 4
                },
                {
                    "key": "0189b5cf615d7034a4a5e9bf4d63918e",
                    "doc_count": 4
                },
                {
                    "key": "0189b5cf615e70839d374fd5b1d8496f",
                    "doc_count": 4
                },
                {
                    "key": "0189b5cf62637211a4fffad27b01ad11",
                    "doc_count": 4
                },
                {
                    "key": "0189b5cf626a723ca261222ea304d942",
                    "doc_count": 4
                },
                {
                    "key": "0189b5cf6276730792cc1e7fa906e21f",
                    "doc_count": 4
                },
                {
                    "key": "0189b5cf627f7301b7834b8aea5c8e6d",
                    "doc_count": 4
                },
                {
                    "key": "0189b5cf699070828fe07ba1617dba58",
                    "doc_count": 4
                },
                {
                    "key": "0189b5cf585b712f9c42c40d15253204",
                    "doc_count": 3
                },
                {
                    "key": "0189b5cf590570078d5d9b3a400c325d",
                    "doc_count": 3
                },
                {
                    "key": "0189b5cf59667155a1ae46c357828943",
                    "doc_count": 3
                },
                {
                    "key": "0189b5cf618773879e1877e219b5961f",
                    "doc_count": 3
                },
                {
                    "key": "0189b5cf62687139a55d721a1eedcd5b",
                    "doc_count": 3
                },
                {
                    "key": "0189b5cf628570778819e92d7cdc155d",
                    "doc_count": 3
                },
                {
                    "key": "0189b5cf686c706bb178ecddbd291f6b",
                    "doc_count": 3
                },
                {
                    "key": "0189b5cf686e701ab45785ef32774ee1",
                    "doc_count": 3
                },
                {
                    "key": "0189b5cf6993734f81b0c6da014227ec",
                    "doc_count": 3
                },
                {
                    "key": "0189b5cf69fe724f85a901dc0706fc90",
                    "doc_count": 3
                },
                {
                    "key": "0189b5cf558e70e99ea6566e02462eb9",
                    "doc_count": 2
                },
                {
                    "key": "0189b5cf61f572898a83b9143059aaf3",
                    "doc_count": 2
                },
                {
                    "key": "0189b5cf626571b7b44e0df5fe5f07b5",
                    "doc_count": 2
                },
                {
                    "key": "0189b5cf627a72caa13a417faddbaa0f",
                    "doc_count": 2
                },
                {
                    "key": "0189b5cf627c722b8933a2614d1aa050",
                    "doc_count": 2
                },
                {
                    "key": "0189b5cf627d71e2a9e72d4fe55e7fe1",
                    "doc_count": 2
                },
                {
                    "key": "0189b5cf6280717bb1d9fcc6e4282d0f",
                    "doc_count": 2
                },
                {
                    "key": "0189b5cf628173e7af6b5c8c632902f1",
                    "doc_count": 2
                },
                {
                    "key": "0189b5cf628271c0a119d02a181997e9",
                    "doc_count": 2
                },
                {
                    "key": "0189b5cf6284728db44ef634e153c3dc",
                    "doc_count": 2
                },
                {
                    "key": "0189b5cf62ad71c9bdda03d9b77c0e8c",
                    "doc_count": 2
                },
                {
                    "key": "0189b5cf6a027022bcd26ce322832729",
                    "doc_count": 2
                },
                {
                    "key": "0189b5cf626271ab8a706e918f73e0f6",
                    "doc_count": 1
                },
                {
                    "key": "0189b5cf62677385b616f33507d34ca0",
                    "doc_count": 1
                },
                {
                    "key": "0189b5cf627872059afb72f79166f1a8",
                    "doc_count": 1
                },
                {
                    "key": "0189b5cf6279712d9cafe7efb1c4da8e",
                    "doc_count": 1
                },
                {
                    "key": "0189b5cf628570778819e92d70a05dd1",
                    "doc_count": 1
                },
                {
                    "key": "0189b5cf62ae7072bbe7b6312e0a6ea4",
                    "doc_count": 1
                },
                {
                    "key": "0189b5cf62af7151bd3451bd3742e1de",
                    "doc_count": 1
                },
                {
                    "key": "0189b5cf68737046b22e4684250f2c9a",
                    "doc_count": 1
                },
                {
                    "key": "0189b5cf6a0070e08910adba8db7e6f0",
                    "doc_count": 1
                },
                {
                    "key": "0189b5cf6a0173a9ab7088b682e9ce51",
                    "doc_count": 1
                },
                {
                    "key": "0189b5cf6aad710089915d94f19f640d",
                    "doc_count": 1
                },
                {
                    "key": "0189b5cf6aae73129fe43da50d43f0a2",
                    "doc_count": 1
                },
                {
                    "key": "0189b5cf6aaf73f09601d49d132afd12",
                    "doc_count": 1
                },
                {
                    "key": "9ca9a210df8444938c7e80fa08dde355",
                    "doc_count": 1
                }
            ]
        },
        "rating-exists": {
            "doc_count": 15,
            "rating": {
                "value": 5.0
            }
        },
        "price": {
            "count": 15,
            "min": 3.0,
            "max": 2500.0,
            "avg": 403.2,
            "sum": 6048.0
        },
        "immediately-available-filter": {
            "value": 1482.0
        },
        "options": {
            "doc_count": 0,
            "options": {
                "doc_count_error_upper_bound": 0,
                "sum_other_doc_count": 0,
                "buckets": []
            }
        },
        "properties": {
            "doc_count": 161,
            "properties": {
                "doc_count_error_upper_bound": 0,
                "sum_other_doc_count": 0,
                "buckets": [
                    {
                        "key": "0189b5cf6261731aa3b57e889fb380be",
                        "doc_count": 9
                    },
                    {
                        "key": "0189b5cf61f3730798350d9bdea78bf7",
                        "doc_count": 8
                    },
                    {
                        "key": "0189b5cf625f7102b41b104a1ead8781",
                        "doc_count": 7
                    },
                    {
                        "key": "0189b5cf683a714c951a2c6108ee7ea7",
                        "doc_count": 7
                    },
                    {
                        "key": "0189b5cf6a4070c28592f0ec9d77c54a",
                        "doc_count": 7
                    },
                    {
                        "key": "0189b5cf558a700593a710abd74f83a9",
                        "doc_count": 5
                    },
                    {
                        "key": "0189b5cf627c722b8933a2615bb050e3",
                        "doc_count": 5
                    },
                    {
                        "key": "0189b5cf6283715f815f3676940d87ae",
                        "doc_count": 5
                    },
                    {
                        "key": "0189b5cf58587246aa97949b494a452a",
                        "doc_count": 4
                    },
                    {
                        "key": "0189b5cf5903737d815ab6ffd65eb192",
                        "doc_count": 4
                    },
                    {
                        "key": "0189b5cf59627097bcc4c633ada73c5d",
                        "doc_count": 4
                    },
                    {
                        "key": "0189b5cf615d7034a4a5e9bf4d63918e",
                        "doc_count": 4
                    },
                    {
                        "key": "0189b5cf615e70839d374fd5b1d8496f",
                        "doc_count": 4
                    },
                    {
                        "key": "0189b5cf62637211a4fffad27b01ad11",
                        "doc_count": 4
                    },
                    {
                        "key": "0189b5cf626a723ca261222ea304d942",
                        "doc_count": 4
                    },
                    {
                        "key": "0189b5cf6276730792cc1e7fa906e21f",
                        "doc_count": 4
                    },
                    {
                        "key": "0189b5cf627f7301b7834b8aea5c8e6d",
                        "doc_count": 4
                    },
                    {
                        "key": "0189b5cf699070828fe07ba1617dba58",
                        "doc_count": 4
                    },
                    {
                        "key": "0189b5cf585b712f9c42c40d15253204",
                        "doc_count": 3
                    },
                    {
                        "key": "0189b5cf590570078d5d9b3a400c325d",
                        "doc_count": 3
                    },
                    {
                        "key": "0189b5cf59667155a1ae46c357828943",
                        "doc_count": 3
                    },
                    {
                        "key": "0189b5cf618773879e1877e219b5961f",
                        "doc_count": 3
                    },
                    {
                        "key": "0189b5cf62687139a55d721a1eedcd5b",
                        "doc_count": 3
                    },
                    {
                        "key": "0189b5cf628570778819e92d7cdc155d",
                        "doc_count": 3
                    },
                    {
                        "key": "0189b5cf686c706bb178ecddbd291f6b",
                        "doc_count": 3
                    },
                    {
                        "key": "0189b5cf686e701ab45785ef32774ee1",
                        "doc_count": 3
                    },
                    {
                        "key": "0189b5cf6993734f81b0c6da014227ec",
                        "doc_count": 3
                    },
                    {
                        "key": "0189b5cf69fe724f85a901dc0706fc90",
                        "doc_count": 3
                    },
                    {
                        "key": "0189b5cf558e70e99ea6566e02462eb9",
                        "doc_count": 2
                    },
                    {
                        "key": "0189b5cf61f572898a83b9143059aaf3",
                        "doc_count": 2
                    },
                    {
                        "key": "0189b5cf626571b7b44e0df5fe5f07b5",
                        "doc_count": 2
                    },
                    {
                        "key": "0189b5cf627a72caa13a417faddbaa0f",
                        "doc_count": 2
                    },
                    {
                        "key": "0189b5cf627c722b8933a2614d1aa050",
                        "doc_count": 2
                    },
                    {
                        "key": "0189b5cf627d71e2a9e72d4fe55e7fe1",
                        "doc_count": 2
                    },
                    {
                        "key": "0189b5cf6280717bb1d9fcc6e4282d0f",
                        "doc_count": 2
                    },
                    {
                        "key": "0189b5cf628173e7af6b5c8c632902f1",
                        "doc_count": 2
                    },
                    {
                        "key": "0189b5cf628271c0a119d02a181997e9",
                        "doc_count": 2
                    },
                    {
                        "key": "0189b5cf6284728db44ef634e153c3dc",
                        "doc_count": 2
                    },
                    {
                        "key": "0189b5cf62ad71c9bdda03d9b77c0e8c",
                        "doc_count": 2
                    },
                    {
                        "key": "0189b5cf6a027022bcd26ce322832729",
                        "doc_count": 2
                    },
                    {
                        "key": "0189b5cf626271ab8a706e918f73e0f6",
                        "doc_count": 1
                    },
                    {
                        "key": "0189b5cf62677385b616f33507d34ca0",
                        "doc_count": 1
                    },
                    {
                        "key": "0189b5cf627872059afb72f79166f1a8",
                        "doc_count": 1
                    },
                    {
                        "key": "0189b5cf6279712d9cafe7efb1c4da8e",
                        "doc_count": 1
                    },
                    {
                        "key": "0189b5cf628570778819e92d70a05dd1",
                        "doc_count": 1
                    },
                    {
                        "key": "0189b5cf62ae7072bbe7b6312e0a6ea4",
                        "doc_count": 1
                    },
                    {
                        "key": "0189b5cf62af7151bd3451bd3742e1de",
                        "doc_count": 1
                    },
                    {
                        "key": "0189b5cf68737046b22e4684250f2c9a",
                        "doc_count": 1
                    },
                    {
                        "key": "0189b5cf6a0070e08910adba8db7e6f0",
                        "doc_count": 1
                    },
                    {
                        "key": "0189b5cf6a0173a9ab7088b682e9ce51",
                        "doc_count": 1
                    },
                    {
                        "key": "0189b5cf6aad710089915d94f19f640d",
                        "doc_count": 1
                    },
                    {
                        "key": "0189b5cf6aae73129fe43da50d43f0a2",
                        "doc_count": 1
                    },
                    {
                        "key": "0189b5cf6aaf73f09601d49d132afd12",
                        "doc_count": 1
                    },
                    {
                        "key": "9ca9a210df8444938c7e80fa08dde355",
                        "doc_count": 1
                    }
                ]
            }
        },
        "manufacturer": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
                {
                    "key": "0189b5ced58e706890ac8b39799f9c9a",
                    "doc_count": 14
                },
                {
                    "key": "0189b5ced5897359a1b2b50cde8fb80d",
                    "doc_count": 1
                }
            ]
        }
    }
}

Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate

Cluster Status

{
    "cluster_name": "shopware",
    "status": "yellow",
    "timed_out": false,
    "number_of_nodes": 1,
    "number_of_data_nodes": 1,
    "discovered_master": true,
    "discovered_cluster_manager": true,
    "active_primary_shards": 203,
    "active_shards": 203,
    "relocating_shards": 0,
    "initializing_shards": 0,
    "unassigned_shards": 224,
    "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": 47.540983606557376
}

Indices

Name▲	Status	Replication (pri, rep)	Doc Count
top_queries-2025.06.29-11074	open	1, 0	4256
security-auditlog-2025.05.22	open	1, 1	16119
security-auditlog-2025.05.21	open	1, 1	23872
security-auditlog-2025.05.20	open	1, 1	25113
security-auditlog-2025.03.01	open	1, 1	158
.ql-datasources	open	1, 0	0
security-auditlog-2025.05.26	open	1, 1	19344
security-auditlog-2025.05.25	open	1, 1	2213
security-auditlog-2025.03.02	open	1, 1	234
security-auditlog-2025.05.24	open	1, 1	1947
security-auditlog-2025.05.23	open	1, 1	18686
security-auditlog-2025.03.05	open	1, 1	259
security-auditlog-2025.05.29	open	1, 1	2650
security-auditlog-2025.03.06	open	1, 1	914
security-auditlog-2025.03.03	open	1, 1	287
security-auditlog-2025.05.28	open	1, 1	17796
security-auditlog-2025.03.04	open	1, 1	446
security-auditlog-2025.05.27	open	1, 1	18740
security-auditlog-2025.03.09	open	1, 1	235
.opendistro_security	open	1, 0	10
security-auditlog-2025.03.07	open	1, 1	215
security-auditlog-2025.03.08	open	1, 1	100
sw_dev_product_1747138014	open	3, 3	75980
security-auditlog-2025.06.01	open	1, 1	2573
top_queries-2025.07.02-40796	open	1, 0	1434
security-auditlog-2025.05.31	open	1, 1	2178
security-auditlog-2025.05.30	open	1, 1	14770
security-auditlog-2025.03.12	open	1, 1	393
security-auditlog-2025.06.05	open	1, 1	12787
security-auditlog-2025.03.13	open	1, 1	233
security-auditlog-2025.06.04	open	1, 1	13799
security-auditlog-2025.06.03	open	1, 1	23795
security-auditlog-2025.03.10	open	1, 1	471
.kibana_92668751_admin_1	open	1, 0	1
security-auditlog-2025.03.11	open	1, 1	163
security-auditlog-2025.06.02	open	1, 1	17889
security-auditlog-2025.06.09	open	1, 1	2721
security-auditlog-2025.03.16	open	1, 1	243
security-auditlog-2025.03.17	open	1, 1	378
security-auditlog-2025.06.08	open	1, 1	1585
security-auditlog-2025.06.07	open	1, 1	1670
security-auditlog-2025.03.14	open	1, 1	214
security-auditlog-2025.06.06	open	1, 1	15003
security-auditlog-2025.03.15	open	1, 1	487
top_queries-2025.06.26-11071	open	1, 0	1956
security-auditlog-2025.03.18	open	1, 1	243
security-auditlog-2025.03.19	open	1, 1	183
top_queries-2025.06.30-11096	open	1, 0	4417
sw6_fr_product_manufacturer_1746284168	open	3, 3	11
security-auditlog-2025.04.30	open	1, 1	23090
security-auditlog-2025.02.10	open	1, 1	213
security-auditlog-2025.05.04	open	1, 1	1791
security-auditlog-2025.05.03	open	1, 1	1987
security-auditlog-2025.05.02	open	1, 1	13264
security-auditlog-2025.02.12	open	1, 1	158
security-auditlog-2025.02.11	open	1, 1	193
security-auditlog-2025.05.01	open	1, 1	2574
security-auditlog-2025.02.14	open	1, 1	231
security-auditlog-2025.05.08	open	1, 1	18383
security-auditlog-2025.02.13	open	1, 1	135
security-auditlog-2025.05.07	open	1, 1	14573
security-auditlog-2025.02.16	open	1, 1	78
security-auditlog-2025.05.06	open	1, 1	17560
security-auditlog-2025.05.05	open	1, 1	24810
security-auditlog-2025.02.15	open	1, 1	57
security-auditlog-2025.02.18	open	1, 1	74
security-auditlog-2025.02.17	open	1, 1	205
security-auditlog-2025.05.09	open	1, 1	14447
security-auditlog-2025.02.19	open	1, 1	186
security-auditlog-2025.05.11	open	1, 1	2293
security-auditlog-2025.05.10	open	1, 1	1592
security-auditlog-2025.02.21	open	1, 1	208
security-auditlog-2025.05.15	open	1, 1	17077
security-auditlog-2025.02.20	open	1, 1	251
security-auditlog-2025.05.14	open	1, 1	17558
security-auditlog-2025.02.23	open	1, 1	96
security-auditlog-2025.05.13	open	1, 1	17154
security-auditlog-2025.02.22	open	1, 1	611
security-auditlog-2025.05.12	open	1, 1	24123
security-auditlog-2025.05.19	open	1, 1	30099
security-auditlog-2025.02.25	open	1, 1	125
security-auditlog-2025.02.24	open	1, 1	267
security-auditlog-2025.05.18	open	1, 1	2720
security-auditlog-2025.02.27	open	1, 1	205
security-auditlog-2025.05.17	open	1, 1	2330
security-auditlog-2025.05.16	open	1, 1	16003
security-auditlog-2025.02.26	open	1, 1	295
security-auditlog-2025.02.28	open	1, 1	321
top_queries-2025.06.25-11070	open	1, 0	3580
security-auditlog-2025.04.10	open	1, 1	44590
security-auditlog-2025.04.13	open	1, 1	1642
top_queries-2025.07.01-40795	open	1, 0	2478
security-auditlog-2025.01.20	open	1, 1	125
security-auditlog-2025.04.14	open	1, 1	16957
security-auditlog-2025.01.22	open	1, 1	300
security-auditlog-2025.04.11	open	1, 1	17577
security-auditlog-2025.07.01	open	1, 1	23678
security-auditlog-2025.01.21	open	1, 1	396
security-auditlog-2025.07.02	open	1, 1	11250
security-auditlog-2025.04.12	open	1, 1	789
security-auditlog-2025.04.17	open	1, 1	14210
security-auditlog-2025.01.24	open	1, 1	235
security-auditlog-2025.04.18	open	1, 1	1819
security-auditlog-2025.01.23	open	1, 1	1641
security-auditlog-2025.04.15	open	1, 1	21714
security-auditlog-2025.01.26	open	1, 1	91
security-auditlog-2025.01.25	open	1, 1	83
security-auditlog-2025.04.16	open	1, 1	14966
security-auditlog-2025.01.28	open	1, 1	98
security-auditlog-2025.01.27	open	1, 1	164
security-auditlog-2025.04.19	open	1, 1	1309
security-auditlog-2025.01.29	open	1, 1	98
.opensearch-observability	open	1, 0	0
security-auditlog-2025.06.30	open	1, 1	12780
security-auditlog-2025.04.20	open	1, 1	800
security-auditlog-2025.04.21	open	1, 1	2399
security-auditlog-2025.04.24	open	1, 1	19635
security-auditlog-2025.01.31	open	1, 1	209
security-auditlog-2025.01.30	open	1, 1	118
security-auditlog-2025.04.25	open	1, 1	14507
sw_dev_category_1747138014	open	3, 3	0
security-auditlog-2025.04.22	open	1, 1	23345
security-auditlog-2025.02.01	open	1, 1	697
security-auditlog-2025.04.23	open	1, 1	41795
security-auditlog-2025.02.03	open	1, 1	489
sw_dev_product_manufacturer_1747138014	open	3, 3	0
security-auditlog-2025.04.28	open	1, 1	14984
security-auditlog-2025.04.29	open	1, 1	18696
security-auditlog-2025.02.02	open	1, 1	326
security-auditlog-2025.04.26	open	1, 1	1524
security-auditlog-2025.02.05	open	1, 1	200
security-auditlog-2025.02.04	open	1, 1	69
security-auditlog-2025.04.27	open	1, 1	1757
security-auditlog-2025.02.07	open	1, 1	95
security-auditlog-2025.02.06	open	1, 1	113
security-auditlog-2025.02.09	open	1, 1	91
security-auditlog-2025.02.08	open	1, 1	142
security-auditlog-2025.06.12	open	1, 1	17250
sw6_fr_product_1746284168	open	3, 3	79298
security-auditlog-2025.06.11	open	1, 1	15252
security-auditlog-2025.03.20	open	1, 1	477
security-auditlog-2025.06.10	open	1, 1	17823
security-auditlog-2025.03.23	open	1, 1	388
security-auditlog-2025.06.16	open	1, 1	15829
security-auditlog-2025.06.15	open	1, 1	1544
security-auditlog-2025.03.24	open	1, 1	556
security-auditlog-2025.03.21	open	1, 1	203
security-auditlog-2025.06.14	open	1, 1	1817
security-auditlog-2025.06.13	open	1, 1	13260
security-auditlog-2025.03.22	open	1, 1	370
security-auditlog-2025.03.27	open	1, 1	598
security-auditlog-2025.03.28	open	1, 1	244
top_queries-2025.06.27-11072	open	1, 0	2303
security-auditlog-2025.06.19	open	1, 1	3554
security-auditlog-2025.06.18	open	1, 1	11007
security-auditlog-2025.03.25	open	1, 1	574
security-auditlog-2025.06.17	open	1, 1	46144
security-auditlog-2025.03.26	open	1, 1	527
sw6_fr_category_1746284168	open	3, 3	121
security-auditlog-2025.03.29	open	1, 1	360
security-auditlog-2025.03.30	open	1, 1	622
security-auditlog-2025.06.23	open	1, 1	20465
security-auditlog-2025.06.22	open	1, 1	1547
security-auditlog-2025.03.31	open	1, 1	505
security-auditlog-2025.06.21	open	1, 1	1586
security-auditlog-2025.06.20	open	1, 1	23776
security-auditlog-2025.04.02	open	1, 1	388
security-auditlog-2025.06.27	open	1, 1	13471
security-auditlog-2025.04.03	open	1, 1	523
security-auditlog-2025.06.26	open	1, 1	18283
security-auditlog-2025.06.25	open	1, 1	16643
security-auditlog-2025.04.01	open	1, 1	447
security-auditlog-2025.06.24	open	1, 1	11274
security-auditlog-2025.04.06	open	1, 1	1393
security-auditlog-2025.04.07	open	1, 1	16875
security-auditlog-2025.06.29	open	1, 1	1520
security-auditlog-2025.01.15	open	1, 1	187
security-auditlog-2025.04.04	open	1, 1	3437
security-auditlog-2025.04.05	open	1, 1	1658
security-auditlog-2025.01.14	open	1, 1	122
security-auditlog-2025.06.28	open	1, 1	1374
security-auditlog-2025.01.17	open	1, 1	77
security-auditlog-2025.01.16	open	1, 1	356
.kibana_1	open	1, 0	0
security-auditlog-2025.04.08	open	1, 1	23447
security-auditlog-2025.01.19	open	1, 1	49
security-auditlog-2025.01.18	open	1, 1	248
security-auditlog-2025.04.09	open	1, 1	18794
.plugins-ml-config	open	1, 0	1
top_queries-2025.06.28-11073	open	1, 0	2315

Symfony Profiler

GET https://shopware6.eps-dev.com/widgets/cms/navigation/377cea45f8a5497883a037ce18a89a53/filter?only-aggregations=1&reduce-aggregations=1&slots=0190787879d371339a6…

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Cluster Status

Indices