| 1 |
8.84 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":"01899818c11871d59a6841ea343f58b0"}}}},{"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": 5,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 302,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_all4team_product_1716336301",
"_id": "018af467daac711fae8778945a606369",
"_score": null,
"_source": {
"autoIncrement": 1131798.0,
"id": "018af467daac711fae8778945a606369"
},
"fields": {
"displayGroup": [
"a9a5486d427d07755919e1f344c248d8"
]
},
"sort": [
0,
"018af467daac711fae8778945a606369"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018af476181271ce9a10a3063fd853eb",
"_score": null,
"_source": {
"autoIncrement": 1132812.0,
"id": "018af476181271ce9a10a3063fd853eb"
},
"fields": {
"displayGroup": [
"12d6c0bbc25c9f2065cf56fa7879e9a5"
]
},
"sort": [
0,
"018af476181271ce9a10a3063fd853eb"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bd605658673418d6008c893dbe2fd",
"_score": null,
"_source": {
"autoIncrement": 1139328.0,
"id": "018bd605658673418d6008c893dbe2fd"
},
"fields": {
"displayGroup": [
"b47266c24286e7fece2c49b299137b2f"
]
},
"sort": [
0,
"018bd605658673418d6008c893dbe2fd"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bf0782ac370ae8f0465cc0992c7d5",
"_score": null,
"_source": {
"autoIncrement": 1141207.0,
"id": "018bf0782ac370ae8f0465cc0992c7d5"
},
"fields": {
"displayGroup": [
"b4b7fd56bf0ea40e01c475b5a5df7e73"
]
},
"sort": [
0,
"018bf0782ac370ae8f0465cc0992c7d5"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bf078564d7032b2e5d8a4cc29f89e",
"_score": null,
"_source": {
"autoIncrement": 1141212.0,
"id": "018bf078564d7032b2e5d8a4cc29f89e"
},
"fields": {
"displayGroup": [
"b7e486d4a8a40cfe903f6f7d99c3e421"
]
},
"sort": [
0,
"018bf078564d7032b2e5d8a4cc29f89e"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bf84c2d1e73b9b71057d93a92011c",
"_score": null,
"_source": {
"autoIncrement": 1145586.0,
"id": "018bf84c2d1e73b9b71057d93a92011c"
},
"fields": {
"displayGroup": [
"e7d40e72da94308a999e7b85c2b1f78c"
]
},
"sort": [
0,
"018bf84c2d1e73b9b71057d93a92011c"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7e80002e71f48206a81ec492b8b4",
"_score": null,
"_source": {
"autoIncrement": 1150029.0,
"id": "018c7e80002e71f48206a81ec492b8b4"
},
"fields": {
"displayGroup": [
"66eadc5d416c065077d8aba4711aeae4"
]
},
"sort": [
0,
"018c7e80002e71f48206a81ec492b8b4"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018cda99ccc7705db250c181cdf8e114",
"_score": null,
"_source": {
"autoIncrement": 1227732.0,
"id": "018cda99ccc7705db250c181cdf8e114"
},
"fields": {
"displayGroup": [
"a4bc42f235fd86c41fb19b7b24efaf9e"
]
},
"sort": [
0,
"018cda99ccc7705db250c181cdf8e114"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018ce5e8386971fea5b1132c21e41526",
"_score": null,
"_source": {
"autoIncrement": 1237632.0,
"id": "018ce5e8386971fea5b1132c21e41526"
},
"fields": {
"displayGroup": [
"eced25e5e894adb9ab71dce0bb46c706"
]
},
"sort": [
0,
"018ce5e8386971fea5b1132c21e41526"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d1d4afede70ba9b60c04e867a59f7",
"_score": null,
"_source": {
"autoIncrement": 1256823.0,
"id": "018d1d4afede70ba9b60c04e867a59f7"
},
"fields": {
"displayGroup": [
"5d83699ff7459a1430d075958b9b0172"
]
},
"sort": [
0,
"018d1d4afede70ba9b60c04e867a59f7"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d1d51bb4b7090ad2a5bd61b4ad3e3",
"_score": null,
"_source": {
"autoIncrement": 1256903.0,
"id": "018d1d51bb4b7090ad2a5bd61b4ad3e3"
},
"fields": {
"displayGroup": [
"e99adcd51717a6246e80c64cfd4261f5"
]
},
"sort": [
0,
"018d1d51bb4b7090ad2a5bd61b4ad3e3"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d1e2c361b72228c42d9c64c5ce0ef",
"_score": null,
"_source": {
"autoIncrement": 1258128.0,
"id": "018d1e2c361b72228c42d9c64c5ce0ef"
},
"fields": {
"displayGroup": [
"b79da7c1c97cd2d6c52ebdc1de453698"
]
},
"sort": [
0,
"018d1e2c361b72228c42d9c64c5ce0ef"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d826b5bf972b9b62963b5d29d02f6",
"_score": null,
"_source": {
"autoIncrement": 1276863.0,
"id": "018d826b5bf972b9b62963b5d29d02f6"
},
"fields": {
"displayGroup": [
"318f9c995dc2b6e8a2f2c8e4880a93b0"
]
},
"sort": [
0,
"018d826b5bf972b9b62963b5d29d02f6"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d82746f1e709faef63eff5e65b380",
"_score": null,
"_source": {
"autoIncrement": 1276944.0,
"id": "018d82746f1e709faef63eff5e65b380"
},
"fields": {
"displayGroup": [
"7875e5b040b5ea632b64c7d86134f4d3"
]
},
"sort": [
0,
"018d82746f1e709faef63eff5e65b380"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018ddf24f311723b948e784eff6330e3",
"_score": null,
"_source": {
"autoIncrement": 1579596.0,
"id": "018ddf24f311723b948e784eff6330e3"
},
"fields": {
"displayGroup": [
"76b87deb0b2e3030dc19c88957f7f342"
]
},
"sort": [
0,
"018ddf24f311723b948e784eff6330e3"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018df04224bf72418643188083d68ef7",
"_score": null,
"_source": {
"autoIncrement": 1741768.0,
"id": "018df04224bf72418643188083d68ef7"
},
"fields": {
"displayGroup": [
"51e5b0b0ab33c0b2f8757a5a3fb884aa"
]
},
"sort": [
0,
"018df04224bf72418643188083d68ef7"
]
}
]
},
"aggregations": {
"total-count": {
"value": 21
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
7.26 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":"01899818c11871d59a6841ea343f58b0"}}}},{"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_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": 5,
"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": 302,
"rating": {
"value": 0.0
}
},
"price": {
"count": 302,
"min": 17.96,
"max": 62.96,
"avg": 26.615629139072848,
"sum": 8037.92
},
"options": {
"doc_count": 615,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "6818490b3d264af396bf32b5c741cb18",
"doc_count": 38
},
{
"key": "b26bb94349e2469ea3e048b8bd50a91d",
"doc_count": 35
},
{
"key": "103c221ef5c547a6919548726a45adb7",
"doc_count": 33
},
{
"key": "df41139ab42a4f0dbe2167afb103b833",
"doc_count": 32
},
{
"key": "63a3e4e3a8d0461ca937227647cbc474",
"doc_count": 28
},
{
"key": "bace55c509624d8ab8a0c4653bced477",
"doc_count": 18
},
{
"key": "1c23aae651524363801a44213f31f325",
"doc_count": 17
},
{
"key": "018991241a7b70f6b2cc256794e99657",
"doc_count": 12
},
{
"key": "018c1b6a769770b6ae92785b381a8e9f",
"doc_count": 12
},
{
"key": "018c6903551970d8a468a8198cb25bdc",
"doc_count": 12
},
{
"key": "50b00542efdb4c3dafc5c8219f89439c",
"doc_count": 12
},
{
"key": "5466f9a9a8bd405486a8213b3ae9f1f0",
"doc_count": 12
},
{
"key": "ac4dbcaf8dff4e7d93712090c05bc8e4",
"doc_count": 12
},
{
"key": "c3e5158073204dcc81f39ea5ac00f976",
"doc_count": 12
},
{
"key": "da90288a8a0442cf89d838c0a578c691",
"doc_count": 12
},
{
"key": "e1dde66905114503a9f1b55937fb7792",
"doc_count": 12
},
{
"key": "f87a19ab23ab4b9a87ff14f85cd740b5",
"doc_count": 12
},
{
"key": "2d698a78a97547d29aad7b1607d32dec",
"doc_count": 11
},
{
"key": "09df4c6efd80429ca293244b63560c6a",
"doc_count": 10
},
{
"key": "20db184c1fdb49508a4ccd08b882a19f",
"doc_count": 10
},
{
"key": "5affb90217af40c58011013f87e6b516",
"doc_count": 10
},
{
"key": "60de90a916684ef696e8ba9bd8060cbc",
"doc_count": 10
},
{
"key": "6b8d9eb2113441598f83a6d7110d18d1",
"doc_count": 10
},
{
"key": "73e7ba66d965447b9ad7e2a05142cd85",
"doc_count": 10
},
{
"key": "a8b13ecee7f74d28af6ed8a74a20757f",
"doc_count": 10
},
{
"key": "adf66c9b2a824a02bc9b1cc28c4d5dcb",
"doc_count": 10
},
{
"key": "b8ddb9b53e2740e58c6385b22bb05e29",
"doc_count": 10
},
{
"key": "e79e0f0ea71a47c88535f185ed5e7866",
"doc_count": 10
},
{
"key": "f4ae98e61a6e405cb0b5a221ef13dbfe",
"doc_count": 10
},
{
"key": "018c69035d5773ef858fd56c6a81ec61",
"doc_count": 9
},
{
"key": "507f2e527d524e359c477d74d4605b1f",
"doc_count": 9
},
{
"key": "5e2f46d53cb046f9a5f9736c372966f8",
"doc_count": 9
},
{
"key": "173130b9d0a74bffb54773f34ab59969",
"doc_count": 6
},
{
"key": "2c85f1acf4e648d5830165598cae79ac",
"doc_count": 6
},
{
"key": "477fe5dbfb004891a8d84da3949c3772",
"doc_count": 6
},
{
"key": "a8c0afa33a3b4c3395bb83146362f91f",
"doc_count": 6
},
{
"key": "d2a9e8cbfb064eb18451b1a8a6c78e61",
"doc_count": 6
},
{
"key": "d61bd953a6414d08a7d85797a94f42d8",
"doc_count": 6
},
{
"key": "018c7c805e4472b4a53eb9182145b865",
"doc_count": 5
},
{
"key": "737bcf022dd24d7db63ed64daaba3ff4",
"doc_count": 5
},
{
"key": "a1cde88b13bf49bfaa909b72ddb284a9",
"doc_count": 5
},
{
"key": "018c6905086671bb9ce489bbb36cbab0",
"doc_count": 4
},
{
"key": "018c7c7fe472715fb014d27ccb7dd780",
"doc_count": 4
},
{
"key": "1893e0d032a345bbb19b4546335821fc",
"doc_count": 4
},
{
"key": "4314baa116af4d10a8202db74494ef1a",
"doc_count": 4
},
{
"key": "87f8775f55bb4437948b3f388907f627",
"doc_count": 4
},
{
"key": "a1199dfd7ec94e14a788e62f5325bce5",
"doc_count": 4
},
{
"key": "ae8c5964722a44389fe3920989f4fa2d",
"doc_count": 4
},
{
"key": "c3c81adde6f244559eae42c559ce26c3",
"doc_count": 4
},
{
"key": "f734962c905f427ab5f1e9c38b211c76",
"doc_count": 4
},
{
"key": "f847fda88876448f9afde1bbf7a21107",
"doc_count": 4
},
{
"key": "01750e6f68614c338d32827e5acf1be9",
"doc_count": 3
},
{
"key": "018d97d41e6d72a6962b34b9a290cd71",
"doc_count": 3
},
{
"key": "018dc10b61b870919f7c4531db31da9c",
"doc_count": 3
},
{
"key": "01909bab32bd714d881f580e27202617",
"doc_count": 3
},
{
"key": "01909bab3cf873f6a9fd8291e2788043",
"doc_count": 3
},
{
"key": "3044dde327364ed7a106a839ae1719dc",
"doc_count": 3
},
{
"key": "4076e5a7d31a47a2b55e4a0052792016",
"doc_count": 3
},
{
"key": "c424012a277c41a5a4fa88e2ae34e5f5",
"doc_count": 3
},
{
"key": "f59b68c9a83d443b856234afb37cf26a",
"doc_count": 3
},
{
"key": "018c7c802d9d73c3863f7e078033c33c",
"doc_count": 2
},
{
"key": "018c7c8060c872a892523511abdae1af",
"doc_count": 2
},
{
"key": "018d97d41f547075a65c972bb53bd7a8",
"doc_count": 2
},
{
"key": "018dc10b79857277bd10739a59fc8933",
"doc_count": 2
},
{
"key": "574a70072f5d4b94ac35a5932130663e",
"doc_count": 2
},
{
"key": "5d99685a591644fd88699c47591c2efe",
"doc_count": 2
},
{
"key": "801210efba6a480f8d2079a80f88f2f3",
"doc_count": 2
},
{
"key": "926da90b6d2344788a3a256a5b28b50a",
"doc_count": 2
},
{
"key": "c67489a1b58f451ca9c66a78de423110",
"doc_count": 2
},
{
"key": "c8c8bf87773f42a98a3191fa86438f7f",
"doc_count": 2
},
{
"key": "fcacf82b492643cca5561342ddaf9eee",
"doc_count": 2
},
{
"key": "018c7c803c637037a6fbd630218afb12",
"doc_count": 1
},
{
"key": "018c7c805f23714793f84bf28f297ae1",
"doc_count": 1
},
{
"key": "40fed3f805694634974d360639023835",
"doc_count": 1
},
{
"key": "476d3085cf474460bc2575974a9e29c1",
"doc_count": 1
},
{
"key": "4d0a060d75cc46b288893aa39a69bc6c",
"doc_count": 1
},
{
"key": "cb13282edb624b76b8d753052f211d1c",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 1234,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "018963e5f06f716dadb0fe95b3c53d22",
"doc_count": 264
},
{
"key": "01896411e82d73ef973f22bb35c69d07",
"doc_count": 148
},
{
"key": "01896412f703702f8629f58ca6f495fb",
"doc_count": 126
},
{
"key": "01896411e05c71f4af78a5552a40b626",
"doc_count": 98
},
{
"key": "01896412f313720d9b807c3f82f171ad",
"doc_count": 80
},
{
"key": "018963ea1812737fb7f416641565cd24",
"doc_count": 56
},
{
"key": "018bbe1476c47169b239563d60e54f70",
"doc_count": 56
},
{
"key": "018dcc3373f47133833772ee8dfc3fe4",
"doc_count": 43
},
{
"key": "018963e5f32b703288aad57690802852",
"doc_count": 38
},
{
"key": "01896412f46a7164bc08cd3d2a5052cc",
"doc_count": 38
},
{
"key": "018963ea3964707fbbfb35b2b8e8084b",
"doc_count": 37
},
{
"key": "018963ea3aba7042895b047285c1402e",
"doc_count": 37
},
{
"key": "018963ea336b7003ba1d74549036192d",
"doc_count": 30
},
{
"key": "018963ea24c172519a11176e570bcae4",
"doc_count": 29
},
{
"key": "018963ea20b670278236dc7103bcceb8",
"doc_count": 24
},
{
"key": "018963ea220370f6b3962a1108942bae",
"doc_count": 24
},
{
"key": "018963ea415c7217b4dc8cb62572ed16",
"doc_count": 23
},
{
"key": "018963ea3609712896e2d21c3a2d91ab",
"doc_count": 20
},
{
"key": "018e521dcd9d73a2ae6c2864c11790df",
"doc_count": 19
},
{
"key": "01896411e6eb71ccbac66ed4a361c281",
"doc_count": 12
},
{
"key": "018c1b62b9947095a00aac5109e05961",
"doc_count": 12
},
{
"key": "018963ea26b971f09527dfc7f4930323",
"doc_count": 5
},
{
"key": "018e521dce71734facb10c03003a08ee",
"doc_count": 5
},
{
"key": "018dd235f075722daf1b7ecd97e0eee4",
"doc_count": 3
},
{
"key": "018e521dcccd73f99af19d59c64fe353",
"doc_count": 3
},
{
"key": "018bbe13c09d7328ba65279e42d55280",
"doc_count": 2
},
{
"key": "01896411ea347043b0788892761b1dff",
"doc_count": 1
},
{
"key": "018bbe13bff4727baa40d87b9df82a76",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "2a606633b77f4e1bab45f45f3483a835",
"doc_count": 136
},
{
"key": "1cadc079599b4e0386adc59541691ef7",
"doc_count": 118
},
{
"key": "1a0ffc50b3584a1abd28c2d06d6c6465",
"doc_count": 32
},
{
"key": "38433195e9d345108b1593626fcdaba0",
"doc_count": 9
},
{
"key": "d8ac016c293145ff9d20f96184a4ad02",
"doc_count": 7
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|