| 2 |
1.49 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":"874f3150aed64f279dba382eef07ebfe"}}}},{"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": 0,
"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": 245,
"rating": {
"value": 0.0
}
},
"price": {
"count": 245,
"min": 8.0,
"max": 8297.05,
"avg": 602.319918367347,
"sum": 147568.38
},
"options": {
"doc_count": 0,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": []
}
},
"properties": {
"doc_count": 3864,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "00f4b1252e1540b7975b0d2dc01493cb",
"doc_count": 245
},
{
"key": "fb2c731579284c588fa1fe56c130231a",
"doc_count": 245
},
{
"key": "45018ee86cc84c47b8d18583215e11fb",
"doc_count": 241
},
{
"key": "75b3bac4e87041dfb2b7707e34c37775",
"doc_count": 217
},
{
"key": "ff8c432754f74be18895c359206d2f9e",
"doc_count": 214
},
{
"key": "80e3982c09e14668b61b2435788dd74e",
"doc_count": 192
},
{
"key": "5d7cdee62433436cb5ff14b769ad2b3e",
"doc_count": 136
},
{
"key": "c00d09ec51844aefa2781fcc00839644",
"doc_count": 133
},
{
"key": "d0c07ddcae6a4425b96e363887660b9f",
"doc_count": 108
},
{
"key": "004c9f1122be4d3db1dadecc53a44cdf",
"doc_count": 82
},
{
"key": "cbff47bf274b4fffa49f971854bb1183",
"doc_count": 81
},
{
"key": "256aa072d598469cbe2a99d63859b36e",
"doc_count": 79
},
{
"key": "f3addfa0aa8f492b93ef4d41f76ff1fd",
"doc_count": 74
},
{
"key": "d9fa2505750f417e81edbcbf558f6959",
"doc_count": 73
},
{
"key": "779289f266824026bf15910128d6576d",
"doc_count": 71
},
{
"key": "e577924c14df48179d45585b28aacca1",
"doc_count": 61
},
{
"key": "a565d8093d284c968759c313c53119ac",
"doc_count": 60
},
{
"key": "8e656547de8e417881fedf8cccbf2956",
"doc_count": 58
},
{
"key": "a9705b0538cb42a3be5018cf5701955d",
"doc_count": 57
},
{
"key": "0aabada48aa64df995d6e54d86f3779b",
"doc_count": 55
},
{
"key": "b57d1d0eb833459bbda07a3adca6714c",
"doc_count": 54
},
{
"key": "4602e0e1a1114df2a23b080c9d23b553",
"doc_count": 53
},
{
"key": "276cdd68b28844569066cf000ab6cb31",
"doc_count": 52
},
{
"key": "255fbc8387fc471ebebc7f1729675fc6",
"doc_count": 51
},
{
"key": "50bede51bbaa4f4aba7003a45cf998b3",
"doc_count": 51
},
{
"key": "7e5d1d27efeb44d297d9915f523cd9df",
"doc_count": 51
},
{
"key": "b81318b1758e42bc8be1559a7f6df0bc",
"doc_count": 51
},
{
"key": "b8dd631079d34d42b559a3eb42f6cfa6",
"doc_count": 51
},
{
"key": "e1049540bfbf49efb4d64f472afca55f",
"doc_count": 51
},
{
"key": "4261829747ec48b884a9e118599ebdbf",
"doc_count": 50
},
{
"key": "888121d5ed9e49cc900f418548387fff",
"doc_count": 49
},
{
"key": "e28447ac3684491a9166aa805f6aa2ce",
"doc_count": 49
},
{
"key": "4e693742fa224cf2bdfc573886463dee",
"doc_count": 48
},
{
"key": "c057aaf844b84af9a250efc7be0def2c",
"doc_count": 48
},
{
"key": "34680579f19740cfac012f53c2d14579",
"doc_count": 46
},
{
"key": "466b5ec1a65e45cfaabe2fd9c30a4048",
"doc_count": 29
},
{
"key": "d6bf0226fcb541c9a5e8db4084b017a7",
"doc_count": 29
},
{
"key": "df1d883cf15a46f8ba34654e6a4e393a",
"doc_count": 29
},
{
"key": "99544516e0e04f7f9cd839b4d9bc2b91",
"doc_count": 28
},
{
"key": "0986c02af16349f0a5b879b360a5135a",
"doc_count": 26
},
{
"key": "a3850a3db5d741dd81f04c538ab46461",
"doc_count": 26
},
{
"key": "de804f4b6d234ec1a06222b7b4614852",
"doc_count": 25
},
{
"key": "8a6ac1662b934451b6e3bc6e665c3bea",
"doc_count": 14
},
{
"key": "be7a046a01af4ef683a2d61d0d49feeb",
"doc_count": 14
},
{
"key": "9777f181ffe843dea6d2c8ea503871f9",
"doc_count": 12
},
{
"key": "0ad2db72f8c446a29c956ed6e9f78fb4",
"doc_count": 10
},
{
"key": "5ab38019ed7843e7b3b2218c5a19e933",
"doc_count": 10
},
{
"key": "018af03e1d7c7c8dabe65059358dbeba",
"doc_count": 9
},
{
"key": "998c9b372d1a4245a79724d3c6f0289e",
"doc_count": 9
},
{
"key": "9f63f7a9675e490aa0c2ce7eb91381df",
"doc_count": 9
},
{
"key": "adfd37fa8d88405d8be97bde6b963aef",
"doc_count": 9
},
{
"key": "01928a7829d67d639ecf3241a302231e",
"doc_count": 8
},
{
"key": "b17e0030883f443eb86e83ea0e398602",
"doc_count": 8
},
{
"key": "ca0798b913784ff9880ac954d5b61825",
"doc_count": 8
},
{
"key": "9a60f14fa86443ff98d00b82e1578dd0",
"doc_count": 7
},
{
"key": "ce208163f6d54098b8f5f01f1966852e",
"doc_count": 7
},
{
"key": "d87edd2454464161b85302e13bb3d42d",
"doc_count": 7
},
{
"key": "fcebc86ac3954b8092f471d6315e7c61",
"doc_count": 7
},
{
"key": "7b0b4005d21e44b096ed3d4b26b4f971",
"doc_count": 6
},
{
"key": "c7cc8a656cf841ca898ab1f1ad507138",
"doc_count": 6
},
{
"key": "2cfa71698f8846af805a68264beefa3c",
"doc_count": 5
},
{
"key": "54ce87786b834c69b24ae0297c9f0351",
"doc_count": 5
},
{
"key": "60f3a33fb6e74ec0b6c83ace74194df5",
"doc_count": 5
},
{
"key": "7d2eec3d86434a909f4efeaa6c7bd8ad",
"doc_count": 5
},
{
"key": "8dedb3f255ff420ba88ac7fb25b2d50c",
"doc_count": 5
},
{
"key": "ae21e9df3c704e44964baa3298dfb679",
"doc_count": 5
},
{
"key": "b0fd24cfb9784ab4a1236ab5ece09415",
"doc_count": 5
},
{
"key": "b65337a6536144ca813ea6a37bd75f35",
"doc_count": 5
},
{
"key": "eff689d23e264c44b773885f2a4a39e9",
"doc_count": 5
},
{
"key": "03f2666ab17f4596b9e6d4dcea88a2dc",
"doc_count": 4
},
{
"key": "052ae7b2516a4928a8f59b948bdd6604",
"doc_count": 4
},
{
"key": "06e4d27eb94d4cc1aca5541219423d71",
"doc_count": 4
},
{
"key": "19ff354e70aa45dba8fe4f7c2f81db8a",
"doc_count": 4
},
{
"key": "31436e1f2add44468bf2734baf79dbb0",
"doc_count": 4
},
{
"key": "5d6f6e6d29aa404f8d54b3c4ab0af26d",
"doc_count": 4
},
{
"key": "80e833585b2c4aca950cebfb2aaabd1a",
"doc_count": 4
},
{
"key": "84fc9ece27334fcfa64b2186bd31627f",
"doc_count": 4
},
{
"key": "9270bfdb608f44aba87a8540c8d22a10",
"doc_count": 4
},
{
"key": "93dcea5ec8474de58987a8a26d862a8d",
"doc_count": 4
},
{
"key": "9861fdd7cd7f48188c9ab82dd0c9556a",
"doc_count": 4
},
{
"key": "9f63919f237d4a99826fb4355de59356",
"doc_count": 4
},
{
"key": "a22ffb31eeef4dec9f2742125159dc7d",
"doc_count": 4
},
{
"key": "adac28fc0ee643c1b43adea098dca42c",
"doc_count": 4
},
{
"key": "b6384ba7bcb74086b88386d26347569d",
"doc_count": 4
},
{
"key": "bcfd8dff179149088e720a4ff4527e56",
"doc_count": 4
},
{
"key": "bf2d854da22c41e0a79a72de4697db5b",
"doc_count": 4
},
{
"key": "c1d70719badf4382b9dabd1bb5a380bf",
"doc_count": 4
},
{
"key": "c6c41d85dee047eb85a5a6e772cf38e2",
"doc_count": 4
},
{
"key": "cc5ba8979f7a4fa1bf4bac8182181d79",
"doc_count": 4
},
{
"key": "ce44d69a3e4e46ce9aa84b8515364889",
"doc_count": 4
},
{
"key": "d203639f7b4541deab3c1d6440258dd4",
"doc_count": 4
},
{
"key": "da388262b87f4c54894feeceb9dd421b",
"doc_count": 4
},
{
"key": "ecc54a94b855422d82a109293bb2a7bf",
"doc_count": 4
},
{
"key": "1baebe6a6ef6423f95778600eb89c7f8",
"doc_count": 3
},
{
"key": "27afa12e8fd1402e8ce3638e19a98d9a",
"doc_count": 3
},
{
"key": "3ff0577e93a846918b5a4820a2420959",
"doc_count": 3
},
{
"key": "4f146b4ced904c95b0ff8ceaf78bfe3a",
"doc_count": 3
},
{
"key": "53a9a7a312b94cc69f7d8aba992d287c",
"doc_count": 3
},
{
"key": "5abe5490998f44e89091f30e98759fe5",
"doc_count": 3
},
{
"key": "6d9393d5212f408991b5e01da2463513",
"doc_count": 3
},
{
"key": "c8d8544a8eca4b748c94ab36076cf43f",
"doc_count": 3
},
{
"key": "cc61a08034264c0db3ba4fd0c3cac5e0",
"doc_count": 3
},
{
"key": "cca45554e2274564aa8fdc6adc80a860",
"doc_count": 3
},
{
"key": "e3f90acf9c6143178382c04d72fa0391",
"doc_count": 3
},
{
"key": "01fae2acf5614760ab3f6d4232366793",
"doc_count": 2
},
{
"key": "14fd0605339a47ad8436471564c5813d",
"doc_count": 2
},
{
"key": "27e5bf7420c14d1e82c251f92742efbd",
"doc_count": 2
},
{
"key": "350b22d39ebe4502a4a774871bce235a",
"doc_count": 2
},
{
"key": "4a0e2b76a24e45f58aeef67f35c0bf14",
"doc_count": 2
},
{
"key": "51bed0da96f94ea094216e94132b3f37",
"doc_count": 2
},
{
"key": "572f23c4632b492aa130b10b39b5fd77",
"doc_count": 2
},
{
"key": "5b2854b6c9da458e8bf92359a79545e8",
"doc_count": 2
},
{
"key": "5d37ddbc6c4e43b484ae23e227fd1637",
"doc_count": 2
},
{
"key": "7d98a41c504648b59fc8a9046d4545ca",
"doc_count": 2
},
{
"key": "7eb34e462b3a4063855e031fe190a4cc",
"doc_count": 2
},
{
"key": "ad0f710872604c0fba3d4cc8627219f9",
"doc_count": 2
},
{
"key": "ad799a5d08034eb29cc48599b830b580",
"doc_count": 2
},
{
"key": "b8dca207ceb6469c9d0c5e7938a0774c",
"doc_count": 2
},
{
"key": "cce1e9f6f74d4013b63a51eac20d12dc",
"doc_count": 2
},
{
"key": "cf387c70e3fa4517b5dc2e6ed19660c6",
"doc_count": 2
},
{
"key": "ffed2104bd3f438d9dc20c03bb094355",
"doc_count": 2
},
{
"key": "018a8e8b64bb79c79318bf4a2a8e9358",
"doc_count": 1
},
{
"key": "0424a155f56240578877c239bc77e4e2",
"doc_count": 1
},
{
"key": "07ad6b9180bb4c5aa0239ff221c4e864",
"doc_count": 1
},
{
"key": "0fbe76176eee4f278b8f5a808b833039",
"doc_count": 1
},
{
"key": "115c2d38f0bb4fc2b8417e5c01e9df5f",
"doc_count": 1
},
{
"key": "17fe7d47a81b4c8691b0e4c7bc80e286",
"doc_count": 1
},
{
"key": "1a5142b193d74f1892e158a74f9cf1cf",
"doc_count": 1
},
{
"key": "1b89adf8d1bc4632b1a58bba5bbcc4aa",
"doc_count": 1
},
{
"key": "1ddc1e26f22149cfb512c7f91acbfe95",
"doc_count": 1
},
{
"key": "2a88c00594cb4845aeff91c163475552",
"doc_count": 1
},
{
"key": "2c3e712abb254016bb27376c648cebda",
"doc_count": 1
},
{
"key": "2c767fe8395a4293aa859aa1f5e5b63a",
"doc_count": 1
},
{
"key": "2fb665e3510243a7af6cb43bbee6b3b0",
"doc_count": 1
},
{
"key": "3c038b44e46442589661994ae6e4eb42",
"doc_count": 1
},
{
"key": "3f7f2498f6b44d8e95ebe1c8728c7cf8",
"doc_count": 1
},
{
"key": "412fad5d763d48ee911d9bfb941f6035",
"doc_count": 1
},
{
"key": "41b57254c93647a7a2b23cc1291e43d2",
"doc_count": 1
},
{
"key": "4aa02d7b98b44097aa54e5bde871d9d0",
"doc_count": 1
},
{
"key": "4d7ec880913245de877f905be2ade522",
"doc_count": 1
},
{
"key": "4db8ef8d5e6e44d883c390b96adc76ce",
"doc_count": 1
},
{
"key": "500862fb9a8c42a68b2e433c9014ab58",
"doc_count": 1
},
{
"key": "507c9764751d4011a5d1b23ecd5bc255",
"doc_count": 1
},
{
"key": "5b7d5bc060ca471aae5a3571983a0849",
"doc_count": 1
},
{
"key": "5b8f5b04a97b47e2b04efe565e99a70a",
"doc_count": 1
},
{
"key": "5e34b0d8aa1645cfbe7c472c9295bb37",
"doc_count": 1
},
{
"key": "5e3d4a01ca0f444989abc6b09ed8afda",
"doc_count": 1
},
{
"key": "5e97b768c52c4889b4cee98ee7262ab5",
"doc_count": 1
},
{
"key": "6919ff944a474dfea158b750c26f5ad4",
"doc_count": 1
},
{
"key": "6bdfc04591ed4e8eaadb176740095b4b",
"doc_count": 1
},
{
"key": "7130ee43a90c47f08073045ecf21445d",
"doc_count": 1
},
{
"key": "7222dfd2008d437aa17e6df93b287203",
"doc_count": 1
},
{
"key": "77c5e2e504e74f2aaa2d1d59eabe1130",
"doc_count": 1
},
{
"key": "79a5930ee0eb4cfbac3f6c63d6caeb36",
"doc_count": 1
},
{
"key": "7aa0ac667fd1476b8151f47f5744ab11",
"doc_count": 1
},
{
"key": "7de336e85bd14d9b8c9ef2f7b37eb7f7",
"doc_count": 1
},
{
"key": "8046c2026757422e8de8c94728320b90",
"doc_count": 1
},
{
"key": "8483761088294ffa80403e23c4ad284f",
"doc_count": 1
},
{
"key": "88295eb972eb4b098ab9daf31d96b107",
"doc_count": 1
},
{
"key": "892e105e75684d0db23249e535077a5b",
"doc_count": 1
},
{
"key": "8f5a76b6f5be42f3ad9174e3c2eaacc8",
"doc_count": 1
},
{
"key": "950074db1e3749c6a39dbce3b25beda3",
"doc_count": 1
},
{
"key": "974b1768dd8d43c08f9a5fc10b1e83f6",
"doc_count": 1
},
{
"key": "97e91b44c63045459a74bf3a7637a658",
"doc_count": 1
},
{
"key": "988a420b6ac5475bb6b53725a4eede31",
"doc_count": 1
},
{
"key": "a0ad0c7e2c5d41d0b574d2de76adc9ac",
"doc_count": 1
},
{
"key": "a6450340188a4fa5b90c2c983bc9ad03",
"doc_count": 1
},
{
"key": "a93f886ca5f94c0990148b9d359de73c",
"doc_count": 1
},
{
"key": "ac0d839e2a0d4b32a175f626cc3bd379",
"doc_count": 1
},
{
"key": "aec02b3ec4a34abf96988ed52b463e09",
"doc_count": 1
},
{
"key": "b1d7e9977d464db4811be7e654617476",
"doc_count": 1
},
{
"key": "b2d276254ffc414ea365ff46b6bfd1dc",
"doc_count": 1
},
{
"key": "b895d1ef4db34818bd3bd3f45fa5063a",
"doc_count": 1
},
{
"key": "b984287e3db147ceb624506b60b5294b",
"doc_count": 1
},
{
"key": "bf11c7caeab94fb8a1c508ba6d222fed",
"doc_count": 1
},
{
"key": "c1322578f3c444289c889fdb94382674",
"doc_count": 1
},
{
"key": "c271463d95e84a04a14a2021d29c2fb6",
"doc_count": 1
},
{
"key": "c7411d5c8d224f0faf7037ac29617757",
"doc_count": 1
},
{
"key": "cbcf4de279734c658d003d6d3bfb8e1c",
"doc_count": 1
},
{
"key": "cca2f47e73f14b649bed50769ef0d660",
"doc_count": 1
},
{
"key": "d128dbdc75fd42ca87d089ba643cbc14",
"doc_count": 1
},
{
"key": "d219c7bad9a242cc93908a560258656e",
"doc_count": 1
},
{
"key": "dc23ede679aa40b695dc0b9e708cf946",
"doc_count": 1
},
{
"key": "e2635cdac9f44e46b25539ecb2f85382",
"doc_count": 1
},
{
"key": "e8800fea53ee4087a0afd683a283ac96",
"doc_count": 1
},
{
"key": "e8a5fb189c7c4b8bab1617c8506ef2e3",
"doc_count": 1
},
{
"key": "ec5947ddf9ce4791922d8340f4593db9",
"doc_count": 1
},
{
"key": "feb0faf99f0b45988591005ea0defd67",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "aab03f73cdd447e6b65315b83ddfeb79",
"doc_count": 245
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|