| 2 |
4.24 ms |
Request:
{"index":"sw_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":"250c23c94a704f8ba1b4819c38901688"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"0191ff9ba2be7bc2a26a101d549f4df0"}}}},{"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_rule64bf19224e314563aba24460dda765f8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule89d3fe06bd7c478194fe9179a9602df5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruled980a6dfc7774cd192e0b1a183764274_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01961afbc995737796b164a7b5355b5d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01961afbca2673cf9fb2d67da0cd8a62_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule6235b68395cd475f90278d41d7b1b36c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruleac5af03b5965434681e7c4cb42720d2b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulecc1de6f5416545d3a68a00f78e8f20f3_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":{"nested":{"path":"properties"},"aggregations":{"properties":{"terms":{"field":"properties.id","size":10000}}}},"options":{"nested":{"path":"options"},"aggregations":{"options":{"terms":{"field":"options.id","size":10000}}}}},"size":0,"timeout":"5s"},"search_type":"query_then_fetch"}
{
"took": 2,
"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
}
},
"rating-exists": {
"doc_count": 67,
"rating": {
"value": 0.0
}
},
"price": {
"count": 67,
"min": 8.0,
"max": 3900.67,
"avg": 407.5271641791045,
"sum": 27304.32
},
"options": {
"doc_count": 0,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": []
}
},
"properties": {
"doc_count": 1013,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "45018ee86cc84c47b8d18583215e11fb",
"doc_count": 64
},
{
"key": "1b390b2547f84681a5aaf6b93875c1ef",
"doc_count": 60
},
{
"key": "d6071c2d7c6a4af885ab399ff929d1dd",
"doc_count": 41
},
{
"key": "c00d09ec51844aefa2781fcc00839644",
"doc_count": 36
},
{
"key": "b1db92116aaf46d5a308b7ad5f134d9d",
"doc_count": 35
},
{
"key": "70d623b6cfc0418c841d5717feb365d3",
"doc_count": 34
},
{
"key": "50bede51bbaa4f4aba7003a45cf998b3",
"doc_count": 32
},
{
"key": "75b3bac4e87041dfb2b7707e34c37775",
"doc_count": 29
},
{
"key": "d0c07ddcae6a4425b96e363887660b9f",
"doc_count": 29
},
{
"key": "092332e114d54d29a4386bb41f6fe3f7",
"doc_count": 24
},
{
"key": "256aa072d598469cbe2a99d63859b36e",
"doc_count": 24
},
{
"key": "f3addfa0aa8f492b93ef4d41f76ff1fd",
"doc_count": 24
},
{
"key": "4c19642233cf41b58047a7de6b497f20",
"doc_count": 22
},
{
"key": "626bef91253640c0af904237318a1030",
"doc_count": 20
},
{
"key": "1af89084374c423fb6d1a5300204fa25",
"doc_count": 19
},
{
"key": "004c9f1122be4d3db1dadecc53a44cdf",
"doc_count": 18
},
{
"key": "b81318b1758e42bc8be1559a7f6df0bc",
"doc_count": 18
},
{
"key": "dae3b094bd8849d7ae468555e7324134",
"doc_count": 17
},
{
"key": "dd6b0ceb29d545cd8aa320d921d0308c",
"doc_count": 16
},
{
"key": "5d7cdee62433436cb5ff14b769ad2b3e",
"doc_count": 15
},
{
"key": "975484cdbc7c495e9a09a3f4f25f6847",
"doc_count": 15
},
{
"key": "2fa142e259134152ad5ce4d44127447d",
"doc_count": 13
},
{
"key": "69fe8056639d4444882ef24c2b912ba8",
"doc_count": 13
},
{
"key": "9073f3f456884f9a9e9e9f7776914b26",
"doc_count": 13
},
{
"key": "9aa21028e127409a91ba8b95e2101588",
"doc_count": 13
},
{
"key": "0aabada48aa64df995d6e54d86f3779b",
"doc_count": 12
},
{
"key": "a05ed99133fe46249951487cff3c35d5",
"doc_count": 12
},
{
"key": "ca0798b913784ff9880ac954d5b61825",
"doc_count": 12
},
{
"key": "372d02c549734d60a702b36df31c2e31",
"doc_count": 11
},
{
"key": "998c9b372d1a4245a79724d3c6f0289e",
"doc_count": 11
},
{
"key": "745d9946202e4310a3288c5a80070301",
"doc_count": 10
},
{
"key": "bec8dcfaa73e480aaa2cd411b642b01d",
"doc_count": 9
},
{
"key": "c7cc8a656cf841ca898ab1f1ad507138",
"doc_count": 9
},
{
"key": "df13e9141f8b40da9270119bf7b10a9e",
"doc_count": 9
},
{
"key": "f38c00d66e7340cf9c07fd64a8c1204b",
"doc_count": 9
},
{
"key": "161db953e8354eb6b257ca742bdf5d3b",
"doc_count": 8
},
{
"key": "8a6ac1662b934451b6e3bc6e665c3bea",
"doc_count": 8
},
{
"key": "adfd37fa8d88405d8be97bde6b963aef",
"doc_count": 8
},
{
"key": "0cc3d637f93040edbe470fd261cac50d",
"doc_count": 7
},
{
"key": "f57aeb0c8b07404c964b518cc25e4c1f",
"doc_count": 7
},
{
"key": "04b698c1e1be4769977c1f97032b5196",
"doc_count": 6
},
{
"key": "5460bda916614171ab9591588032fdfd",
"doc_count": 6
},
{
"key": "5ab38019ed7843e7b3b2218c5a19e933",
"doc_count": 6
},
{
"key": "c77637c4a9e34023bdfb76b8e6190eb6",
"doc_count": 6
},
{
"key": "cc65fd20067b4e2cbfcba21bada894c0",
"doc_count": 6
},
{
"key": "66e454d5a7614be3a6b3333b8669766f",
"doc_count": 5
},
{
"key": "706489f51b6d4d5984f51a62cc889b2e",
"doc_count": 5
},
{
"key": "3f6b586417f74a648d2e799dc53ee715",
"doc_count": 4
},
{
"key": "492357f803a44223b4770bd52dfc4c64",
"doc_count": 4
},
{
"key": "5d50f55406ce4bd2a319ab54f9746938",
"doc_count": 4
},
{
"key": "75dd5eab70da446f80d8bf94622759e3",
"doc_count": 4
},
{
"key": "782a4d20d8c344939705867e9a052ad2",
"doc_count": 4
},
{
"key": "80e833585b2c4aca950cebfb2aaabd1a",
"doc_count": 4
},
{
"key": "9f63f7a9675e490aa0c2ce7eb91381df",
"doc_count": 4
},
{
"key": "c9ed705862894e94bae59b2043f0e5b0",
"doc_count": 4
},
{
"key": "348683b5f7ce433799a28249c9e26ab6",
"doc_count": 3
},
{
"key": "5d1ea8f71d7d41069cfa37176819e634",
"doc_count": 3
},
{
"key": "6e8b2e81036642ff93b15ff1520bdc03",
"doc_count": 3
},
{
"key": "79952e12133746d8b1502c3765adb6c7",
"doc_count": 3
},
{
"key": "94dd585006d04491a0204de65ff0b85e",
"doc_count": 3
},
{
"key": "9d5e3afde90a4530a30cac67a27cd054",
"doc_count": 3
},
{
"key": "a0ad0c7e2c5d41d0b574d2de76adc9ac",
"doc_count": 3
},
{
"key": "ab4e7ba6f6894f59bfd319923eed4215",
"doc_count": 3
},
{
"key": "b17e0030883f443eb86e83ea0e398602",
"doc_count": 3
},
{
"key": "b52b6f16a76a4aaca05e9d987fb1721b",
"doc_count": 3
},
{
"key": "e577924c14df48179d45585b28aacca1",
"doc_count": 3
},
{
"key": "01928a7829d67d639ecf3241a302231e",
"doc_count": 2
},
{
"key": "172ee189fdbb4d31be14a9303f27e6a4",
"doc_count": 2
},
{
"key": "18e9e666d2f04e2a8249d61008880c6a",
"doc_count": 2
},
{
"key": "1a4beacb4d834c32b10c3f82b77301c5",
"doc_count": 2
},
{
"key": "1af482d544b54aecac5af66a28566895",
"doc_count": 2
},
{
"key": "1fe06ffb090d444f80cdda25ca218931",
"doc_count": 2
},
{
"key": "201c9a027ddc41b7843209158bf70476",
"doc_count": 2
},
{
"key": "29b2681390764d58af69d363aa0221bd",
"doc_count": 2
},
{
"key": "3c30fab6ef1b4595a48930be577c00c6",
"doc_count": 2
},
{
"key": "458f436726e54283a627c2bb9cfdf7de",
"doc_count": 2
},
{
"key": "497dd7bbc4ac49039fae7fc06b2baeea",
"doc_count": 2
},
{
"key": "5affebe282fa4815b16b8cbf1ffe586a",
"doc_count": 2
},
{
"key": "6f92af8d0f0a4ae99239c1bd9f68d3d3",
"doc_count": 2
},
{
"key": "719d6b854ce24a19b8d6e400d71142b6",
"doc_count": 2
},
{
"key": "7a003b470df74513898d140b8035c1d9",
"doc_count": 2
},
{
"key": "7d615d84a2174e38a5c19dfa8deca137",
"doc_count": 2
},
{
"key": "810d89d977184acca8fa2b1d8cbec2ef",
"doc_count": 2
},
{
"key": "89d4ce64fe194e71b3078905aff97aa4",
"doc_count": 2
},
{
"key": "8c82174af87e490d840286177b6af78b",
"doc_count": 2
},
{
"key": "8e5aa5529b1940819fb51450a09ddc4c",
"doc_count": 2
},
{
"key": "8efcc019ed214ed9a7a0ccb1a5f70f9a",
"doc_count": 2
},
{
"key": "937316f260814e689113aa8cbe236948",
"doc_count": 2
},
{
"key": "9a1418c7b00d44f49f49ad91a158b7fd",
"doc_count": 2
},
{
"key": "b8dca207ceb6469c9d0c5e7938a0774c",
"doc_count": 2
},
{
"key": "c1d70719badf4382b9dabd1bb5a380bf",
"doc_count": 2
},
{
"key": "d1ffe31ac2db4177b9d2179f91f16173",
"doc_count": 2
},
{
"key": "da388262b87f4c54894feeceb9dd421b",
"doc_count": 2
},
{
"key": "efdf642333864f51973546267f9cd2fa",
"doc_count": 2
},
{
"key": "fcebc86ac3954b8092f471d6315e7c61",
"doc_count": 2
},
{
"key": "000624158fc34c11b243e5a1fce505e4",
"doc_count": 1
},
{
"key": "06ec3d58b5904184ae94b80b8d6a9631",
"doc_count": 1
},
{
"key": "07689035bfd44efab9a7133d1c4cbd55",
"doc_count": 1
},
{
"key": "0ad2db72f8c446a29c956ed6e9f78fb4",
"doc_count": 1
},
{
"key": "0e5e326eded9482a8fbdb921f72ad64f",
"doc_count": 1
},
{
"key": "0e6f6477a8a54b0e9406d075177724cf",
"doc_count": 1
},
{
"key": "13230fbd89994e96b4aea1770a8ce826",
"doc_count": 1
},
{
"key": "14fd0605339a47ad8436471564c5813d",
"doc_count": 1
},
{
"key": "197440dc87e84f28ac717b08ac21d619",
"doc_count": 1
},
{
"key": "19ff354e70aa45dba8fe4f7c2f81db8a",
"doc_count": 1
},
{
"key": "1ce9c320c73d46a2819ea6d5bbe48c4d",
"doc_count": 1
},
{
"key": "20307aa6ea24472fbcbae9213a330f80",
"doc_count": 1
},
{
"key": "22a8860b9903479c925747bb7932c8ab",
"doc_count": 1
},
{
"key": "276cdd68b28844569066cf000ab6cb31",
"doc_count": 1
},
{
"key": "2b1b485aacda40f2a9d5fc7839a39da8",
"doc_count": 1
},
{
"key": "2cb077092f7b4277890d93b280daf655",
"doc_count": 1
},
{
"key": "2dc6ab04d60a405192ae6825814546a4",
"doc_count": 1
},
{
"key": "360c7565914041fd9931997e7d5ea95d",
"doc_count": 1
},
{
"key": "3f060f2cbf7f42c08da52fb9aadb10f8",
"doc_count": 1
},
{
"key": "427ef081c91b4a499bce30afde9d3a55",
"doc_count": 1
},
{
"key": "42c85c183aa14a91be90cdccf37a3d64",
"doc_count": 1
},
{
"key": "4fa9f6ad775b4123884b32300569beda",
"doc_count": 1
},
{
"key": "51ebe59299ac4057b371590d933448f3",
"doc_count": 1
},
{
"key": "527719b1bd5741e689597f45756f9f3e",
"doc_count": 1
},
{
"key": "57f4852d7da14ed996014019ceb8077a",
"doc_count": 1
},
{
"key": "5c8b169be6c445cebdbb2c3cf98abaf6",
"doc_count": 1
},
{
"key": "6514dc9fa06a48fda26a49d09dc1910a",
"doc_count": 1
},
{
"key": "70ad2fadba0640808588090da7b3c0e1",
"doc_count": 1
},
{
"key": "7cb780b565744dfa97173b02768d1d3c",
"doc_count": 1
},
{
"key": "911fe9913410494cbf49e3f809401140",
"doc_count": 1
},
{
"key": "9777f181ffe843dea6d2c8ea503871f9",
"doc_count": 1
},
{
"key": "9a60f14fa86443ff98d00b82e1578dd0",
"doc_count": 1
},
{
"key": "9a7a1448813a4ffaa106891cec570f2c",
"doc_count": 1
},
{
"key": "a0a988b73ae8448d9ec81873343049e4",
"doc_count": 1
},
{
"key": "a52057de82ee4c6bb899db77adfd19d9",
"doc_count": 1
},
{
"key": "a5a39c1dca6a4a65883598e0376d4478",
"doc_count": 1
},
{
"key": "b24ee16021be483d93181b79c989c05d",
"doc_count": 1
},
{
"key": "b8041b594c8642ada7ddc022143ef62a",
"doc_count": 1
},
{
"key": "ba46e340b3f4456da541d4b423048aea",
"doc_count": 1
},
{
"key": "bcfd8dff179149088e720a4ff4527e56",
"doc_count": 1
},
{
"key": "bda73c0465594fafb2b9a25b192bc870",
"doc_count": 1
},
{
"key": "c057aaf844b84af9a250efc7be0def2c",
"doc_count": 1
},
{
"key": "cc7306a9a5f942dabb4e4dee0c2ca220",
"doc_count": 1
},
{
"key": "d38781cda9424242bcd9fdf4844b8475",
"doc_count": 1
},
{
"key": "d3cfb18b53ee4a4486a2f4d64f53934f",
"doc_count": 1
},
{
"key": "d4a351b83deb42719a00ef284e34b4ce",
"doc_count": 1
},
{
"key": "d5a5144d153f4755a8ee22bd046c174e",
"doc_count": 1
},
{
"key": "d87edd2454464161b85302e13bb3d42d",
"doc_count": 1
},
{
"key": "da68f90458a344ffbb6faed316ff435e",
"doc_count": 1
},
{
"key": "da73ead1b1964a929f9369fb17e21c3b",
"doc_count": 1
},
{
"key": "dad9cdbe390e40ca9bcdba4aa2c571c2",
"doc_count": 1
},
{
"key": "dced61bdbc994ec1a612e53163b59209",
"doc_count": 1
},
{
"key": "de88ad12fea44d74b9c2a1f1edf7ecdf",
"doc_count": 1
},
{
"key": "e05d47668364443ca7894c96f1cb8bb6",
"doc_count": 1
},
{
"key": "e283b2ba2e934fa09a7dc9c74bc41fd7",
"doc_count": 1
},
{
"key": "e8800fea53ee4087a0afd683a283ac96",
"doc_count": 1
},
{
"key": "f24e7670408e4a1ab2cba15c6d6b5c16",
"doc_count": 1
},
{
"key": "f3ae6d221bde45e19f1debc37d00bc83",
"doc_count": 1
},
{
"key": "f7490e55b57a44cbb254597bcd039a59",
"doc_count": 1
},
{
"key": "f7a4b0faa3a14ee0a0dc393e36145cfe",
"doc_count": 1
},
{
"key": "f91152db5fe94d3a846ec058866d47cf",
"doc_count": 1
},
{
"key": "fb1b877df4e04c9d8d92590a08d673d1",
"doc_count": 1
},
{
"key": "ff451efa78a94c7bad7e23b683d47550",
"doc_count": 1
},
{
"key": "ff9d7128d2614500b7537d11b67e4f21",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "ff11ff1ee9364e74ac0058d300b888d1",
"doc_count": 53
},
{
"key": "7badc6a1701144169378c0cf085270fa",
"doc_count": 7
},
{
"key": "62c6c9fe64c64ade84cac314d374d37e",
"doc_count": 2
},
{
"key": "d8b346bb1b3748be8dd00175221de71a",
"doc_count": 2
},
{
"key": "0c6346a583ce4d0c93a8911b89371b9a",
"doc_count": 1
},
{
"key": "e1032ffae8b640c3812d5e96c1a1db37",
"doc_count": 1
},
{
"key": "f32ad5b6af944339ba4b06355caa88da",
"doc_count": 1
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|