| 1 |
42.86 ms |
Request:
{"index":"sw_all4team_product","search_type":"query_then_fetch","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"a4d331012b00410ab817a4dd8c7bc7f0"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"018997b8674b712188b6cb7d22ac3300"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"sort":[{"sales":{"order":"DESC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":16,"collapse":{"field":"displayGroup"},"timeout":"5s"}}
{
"took": 7,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 87,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d0fb35928729b8fd2c0c84a185016",
"_score": null,
"_source": {
"autoIncrement": 1239855.0,
"id": "018d0fb35928729b8fd2c0c84a185016"
},
"fields": {
"displayGroup": [
"8e0d5c28736c4c1fe11e657845cd3e00"
]
},
"sort": [
0,
"018d0fb35928729b8fd2c0c84a185016"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d0fb3c83271f3840bbdcb6d8d3e87",
"_score": null,
"_source": {
"autoIncrement": 1239859.0,
"id": "018d0fb3c83271f3840bbdcb6d8d3e87"
},
"fields": {
"displayGroup": [
"c8671c3a65399763de339333d56d17b7"
]
},
"sort": [
0,
"018d0fb3c83271f3840bbdcb6d8d3e87"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d120170e3737a9ca7cfd82bb0762f",
"_score": null,
"_source": {
"autoIncrement": 1247258.0,
"id": "018d120170e3737a9ca7cfd82bb0762f"
},
"fields": {
"displayGroup": [
"71eb2a6a430ec4f7227a74005a50ef40"
]
},
"sort": [
0,
"018d120170e3737a9ca7cfd82bb0762f"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d1322a84972d8bdbd81c0bf7000c1",
"_score": null,
"_source": {
"autoIncrement": 1249782.0,
"id": "018d1322a84972d8bdbd81c0bf7000c1"
},
"fields": {
"displayGroup": [
"9f24aae5eff027e5c38d6c37b2a8dc5e"
]
},
"sort": [
0,
"018d1322a84972d8bdbd81c0bf7000c1"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018f77a43b3a700195c24b9341db219f",
"_score": null,
"_source": {
"autoIncrement": 1783428.0,
"id": "018f77a43b3a700195c24b9341db219f"
},
"fields": {
"displayGroup": [
"ae855607246f483dcdc9e62171f2ba72"
]
},
"sort": [
0,
"018f77a43b3a700195c24b9341db219f"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018f7b70e02e70dc8f166d2b3b21814b",
"_score": null,
"_source": {
"autoIncrement": 1784898.0,
"id": "018f7b70e02e70dc8f166d2b3b21814b"
},
"fields": {
"displayGroup": [
"45bfb814600f9dd7bda740495d0c08ec"
]
},
"sort": [
0,
"018f7b70e02e70dc8f166d2b3b21814b"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018f7b74e83370ae8961646498255d5c",
"_score": null,
"_source": {
"autoIncrement": 1785217.0,
"id": "018f7b74e83370ae8961646498255d5c"
},
"fields": {
"displayGroup": [
"eaa16681054de9b12095760e16fa2bd3"
]
},
"sort": [
0,
"018f7b74e83370ae8961646498255d5c"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0195b8937cd772538f8a68a81c116514",
"_score": null,
"_source": {
"autoIncrement": 1924345.0,
"id": "0195b8937cd772538f8a68a81c116514"
},
"fields": {
"displayGroup": [
"777bfada341bfdf515ce8391ab552764"
]
},
"sort": [
0,
"0195b8937cd772538f8a68a81c116514"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0195b893943771549dc897ae72775e3e",
"_score": null,
"_source": {
"autoIncrement": 1924351.0,
"id": "0195b893943771549dc897ae72775e3e"
},
"fields": {
"displayGroup": [
"904992f4ffd62a122d8cf6928c2b9aa6"
]
},
"sort": [
0,
"0195b893943771549dc897ae72775e3e"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0195b8944aac7263bedc09743983a68e",
"_score": null,
"_source": {
"autoIncrement": 1924357.0,
"id": "0195b8944aac7263bedc09743983a68e"
},
"fields": {
"displayGroup": [
"489b5ed14671f5cbda84fa0acf73f681"
]
},
"sort": [
0,
"0195b8944aac7263bedc09743983a68e"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0197a1da7adc71bea63f93d4786babea",
"_score": null,
"_source": {
"autoIncrement": 1928222.0,
"id": "0197a1da7adc71bea63f93d4786babea"
},
"fields": {
"displayGroup": [
"74faaf1a4ef631de56a1123747ce17a5"
]
},
"sort": [
0,
"0197a1da7adc71bea63f93d4786babea"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0197a1da9a39706297aa795b0dd32a00",
"_score": null,
"_source": {
"autoIncrement": 1928228.0,
"id": "0197a1da9a39706297aa795b0dd32a00"
},
"fields": {
"displayGroup": [
"8d62b43937ee4556b53433cc707e4e63"
]
},
"sort": [
0,
"0197a1da9a39706297aa795b0dd32a00"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01980cbb77a27013b9c3c5cc6c09dc36",
"_score": null,
"_source": {
"autoIncrement": 1929191.0,
"id": "01980cbb77a27013b9c3c5cc6c09dc36"
},
"fields": {
"displayGroup": [
"a7292d93558a7c91b2697658a59504a7"
]
},
"sort": [
0,
"01980cbb77a27013b9c3c5cc6c09dc36"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0235804599f74d73a65e9f7e3a514bce",
"_score": null,
"_source": {
"autoIncrement": 1036487.0,
"id": "0235804599f74d73a65e9f7e3a514bce"
},
"fields": {
"displayGroup": [
"7db4ff45095a977bb4fc9ac44b1672b1"
]
},
"sort": [
0,
"0235804599f74d73a65e9f7e3a514bce"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "21d99d8159054078b753a2bdd6902803",
"_score": null,
"_source": {
"autoIncrement": 1036583.0,
"id": "21d99d8159054078b753a2bdd6902803"
},
"fields": {
"displayGroup": [
"b9e02d0e348f57bf436834feb3a2504d"
]
},
"sort": [
0,
"21d99d8159054078b753a2bdd6902803"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "364c628c90eb4968940dd8a59e3e702c",
"_score": null,
"_source": {
"autoIncrement": 1036535.0,
"id": "364c628c90eb4968940dd8a59e3e702c"
},
"fields": {
"displayGroup": [
"be2004fbf5dbfeb8d5c307cd22215260"
]
},
"sort": [
0,
"364c628c90eb4968940dd8a59e3e702c"
]
}
]
},
"aggregations": {
"total-count": {
"value": 24
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
15.87 ms |
Request:
{"index":"sw_all4team_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":"a4d331012b00410ab817a4dd8c7bc7f0"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"018997b8674b712188b6cb7d22ac3300"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"aggregations":{"manufacturer":{"terms":{"field":"manufacturerId","size":10000}},"price":{"stats":{"script":{"id":"cheapest_price","params":{"accessors":[{"key":"cheapest_price_rule1eac567d7d314563bfa3305e2e8446bb_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule9628985660b5415c9ee8f65bade111bf_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruleeb63558ebb734bde8518103eff3442cf_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule8444b9bcc809444aa5a3fe1f3260a9cc_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulef56aa66553b04105839b38b9288ce3ed_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule43a89e1a4b454d078913ef45f83aafdf_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule6e3190c99cf44a80a3b9407e5e813c45_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": 6,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"max_score": null,
"hits": []
},
"aggregations": {
"shipping-free-filter": {
"doc_count": 26,
"shipping-free": {
"value": 1.0,
"value_as_string": "true"
}
},
"rating-exists": {
"doc_count": 87,
"rating": {
"value": 0.0
}
},
"price": {
"count": 87,
"min": 5.59,
"max": 999.0,
"avg": 183.15712643678162,
"sum": 15934.67
},
"options": {
"doc_count": 172,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "019eafa0448f4c3fa5bcec61d113adb3",
"doc_count": 12
},
{
"key": "0195197bf03e703591ecb2b5b15f6f39",
"doc_count": 10
},
{
"key": "0195197bf5c373058498eaf0d3e0e1e4",
"doc_count": 10
},
{
"key": "1e92aef1f53246c0900d612091414458",
"doc_count": 10
},
{
"key": "938fc5d9b85e43b8ae09c9826bef72a3",
"doc_count": 10
},
{
"key": "bb3d11c017af48fa95187db3724fd524",
"doc_count": 10
},
{
"key": "32b7f689c19f425d9de20e215684cb85",
"doc_count": 9
},
{
"key": "f295c2e9927744ec9739d5707bdb43ad",
"doc_count": 9
},
{
"key": "3cf8067de75947bcb53e4cd1de94d52a",
"doc_count": 6
},
{
"key": "0195197c023a72059385464715ae3542",
"doc_count": 5
},
{
"key": "2e87f8ea386f49e7aa62605fc9e6ace7",
"doc_count": 5
},
{
"key": "6cb852f376b84b21ba68a0a20aa09673",
"doc_count": 5
},
{
"key": "78ee3b2bcf014e0cb449a4f956d975f4",
"doc_count": 5
},
{
"key": "ac4c4664801845278f388172110e29ec",
"doc_count": 5
},
{
"key": "f956ddc06a5e4ba3b365218ba1c557a3",
"doc_count": 5
},
{
"key": "ff25f72e5aa443e2a67ad341f89c9628",
"doc_count": 5
},
{
"key": "61bf0754013d46c392f76d5028b9ddf4",
"doc_count": 4
},
{
"key": "a6b7739ba2cd4bec86509bc8dd89b192",
"doc_count": 4
},
{
"key": "e96f2d8a93d0415db093767c7698b89b",
"doc_count": 4
},
{
"key": "018c5df3973270158a2fd515cec532f0",
"doc_count": 3
},
{
"key": "018d12c9609570dbb3446530c85af007",
"doc_count": 3
},
{
"key": "c8beb34a31734eeaba6a51d3d1f649f7",
"doc_count": 3
},
{
"key": "129b8c63aba24fc587a7d7b9724e15f8",
"doc_count": 2
},
{
"key": "1c23aae651524363801a44213f31f325",
"doc_count": 2
},
{
"key": "1e4281246d724a0486f5c05a26c0707e",
"doc_count": 2
},
{
"key": "369d5b306d07408b80cf0182cb6c92db",
"doc_count": 2
},
{
"key": "3decd6da7e69465fbeba5d1bca9a196e",
"doc_count": 2
},
{
"key": "3e1d6847ecf045eea79ed51df51a329c",
"doc_count": 2
},
{
"key": "462ea31e631049acaa0062cad459d209",
"doc_count": 2
},
{
"key": "4bbf71f6639e4c1eb040ce1de5b7ba9b",
"doc_count": 2
},
{
"key": "4c6f27cbc8a343d5b8f446e2f97dafe9",
"doc_count": 2
},
{
"key": "86bdb1b150dc41429d05122ba525479e",
"doc_count": 2
},
{
"key": "9db172bf63f340f39db35a7bce86c47f",
"doc_count": 2
},
{
"key": "018d8d99155e7336a9357a529a6954fc",
"doc_count": 1
},
{
"key": "018d8d991f807060b4e3eab8b0cf2389",
"doc_count": 1
},
{
"key": "103c221ef5c547a6919548726a45adb7",
"doc_count": 1
},
{
"key": "3ebeab725a3e46729c85a7f65161440f",
"doc_count": 1
},
{
"key": "47851eaaf6624676a3a061c23631b0fb",
"doc_count": 1
},
{
"key": "6818490b3d264af396bf32b5c741cb18",
"doc_count": 1
},
{
"key": "684b0baf4a4b4084a60ef3a41bb894ec",
"doc_count": 1
},
{
"key": "bace55c509624d8ab8a0c4653bced477",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 287,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "018963e5f32b703288aad57690802852",
"doc_count": 52
},
{
"key": "018963e5f5e173a4afde33792d6fe12f",
"doc_count": 35
},
{
"key": "01896411e59f727b8b482ff954d67fa9",
"doc_count": 33
},
{
"key": "01896411e25971f98272a565102c3faf",
"doc_count": 28
},
{
"key": "01896412df08702b9375303df819d335",
"doc_count": 26
},
{
"key": "01896411e3007292bbf291a9837a8cc8",
"doc_count": 21
},
{
"key": "01896412ef1f71e9ae4a34ef83e2a1e9",
"doc_count": 20
},
{
"key": "018bbe13bff4727baa40d87b9df82a76",
"doc_count": 11
},
{
"key": "018963ea38bc73dfb904152df1cb0c75",
"doc_count": 9
},
{
"key": "018963ea3aba7042895b047285c1402e",
"doc_count": 6
},
{
"key": "018bbe13b8237164810b74768f091ae7",
"doc_count": 6
},
{
"key": "018bbe14784470c69d83e088c5e66fb5",
"doc_count": 6
},
{
"key": "01896411e3af718192fb7f9ee45ad6fb",
"doc_count": 3
},
{
"key": "018bbe13c1f071a095ab51339e1d02ad",
"doc_count": 3
},
{
"key": "018963ea1cb372228d923d381e57ce55",
"doc_count": 2
},
{
"key": "018963ea20b670278236dc7103bcceb8",
"doc_count": 2
},
{
"key": "018963ea220370f6b3962a1108942bae",
"doc_count": 2
},
{
"key": "018963ea240d70bda7a637be93c20c89",
"doc_count": 2
},
{
"key": "018963ea2f4872f5b65ae53cf081df0e",
"doc_count": 2
},
{
"key": "018963ea313d732aab9f9437134e1b76",
"doc_count": 2
},
{
"key": "018963ea3964707fbbfb35b2b8e8084b",
"doc_count": 2
},
{
"key": "018963ea3d5d73cfb8d2ad717ae4bcdc",
"doc_count": 2
},
{
"key": "018963ea3e0572c6960c0eadf8b16c7f",
"doc_count": 2
},
{
"key": "018963ea415c7217b4dc8cb62572ed16",
"doc_count": 2
},
{
"key": "018bbe13b97a72e79ffb27e38f96bbb2",
"doc_count": 2
},
{
"key": "018bbe13bf4971378f6c9737de6890aa",
"doc_count": 2
},
{
"key": "018dcc3373f47133833772ee8dfc3fe4",
"doc_count": 2
},
{
"key": "018963ea1812737fb7f416641565cd24",
"doc_count": 1
},
{
"key": "018c8bd0b61f7261a8fd0a2049ab50de",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "69126f5efcab45738b242009148aca51",
"doc_count": 45
},
{
"key": "1a0ffc50b3584a1abd28c2d06d6c6465",
"doc_count": 38
},
{
"key": "57f85a1341f34ad284dc91714711a009",
"doc_count": 3
},
{
"key": "0eb8635d02c643c2b1d22ea1631c0c90",
"doc_count": 1
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|