| 1 |
28.34 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":"0189983826b873b0a345d573667c2537"}}}},{"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": 14,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 448,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_all4team_product_1716336301",
"_id": "00404e3d22cd499f9a9f5bf7a67f62ca",
"_score": null,
"_source": {
"autoIncrement": 1040708.0,
"id": "00404e3d22cd499f9a9f5bf7a67f62ca"
},
"fields": {
"displayGroup": [
"dbaa9aa1dcf58cc3010951a6bc14d028"
]
},
"sort": [
0,
"00404e3d22cd499f9a9f5bf7a67f62ca"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7e94f3ce704c910f3126374894cc",
"_score": null,
"_source": {
"autoIncrement": 1151046.0,
"id": "018c7e94f3ce704c910f3126374894cc"
},
"fields": {
"displayGroup": [
"43a3db07b9e4df2264ea73e1db03c407"
]
},
"sort": [
0,
"018c7e94f3ce704c910f3126374894cc"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7e95452a713297f4928cb0b22374",
"_score": null,
"_source": {
"autoIncrement": 1151070.0,
"id": "018c7e95452a713297f4928cb0b22374"
},
"fields": {
"displayGroup": [
"ad5a56b5755900f45cc509397ec301ee"
]
},
"sort": [
0,
"018c7e95452a713297f4928cb0b22374"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7e959804734b8bda8d6641f23353",
"_score": null,
"_source": {
"autoIncrement": 1151151.0,
"id": "018c7e959804734b8bda8d6641f23353"
},
"fields": {
"displayGroup": [
"71f7a6970df2e59e0e7a1da17e4f8b52"
]
},
"sort": [
0,
"018c7e959804734b8bda8d6641f23353"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7e97eda673488c959e62a03f7b92",
"_score": null,
"_source": {
"autoIncrement": 1151251.0,
"id": "018c7e97eda673488c959e62a03f7b92"
},
"fields": {
"displayGroup": [
"8876553cdee0a941725590871b4588d3"
]
},
"sort": [
0,
"018c7e97eda673488c959e62a03f7b92"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7ef748df70198a976375a7f8166e",
"_score": null,
"_source": {
"autoIncrement": 1159412.0,
"id": "018c7ef748df70198a976375a7f8166e"
},
"fields": {
"displayGroup": [
"79c196c394fb1aa0f057802b78c2e888"
]
},
"sort": [
0,
"018c7ef748df70198a976375a7f8166e"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c889f3fae71c184914cdd22adf5e0",
"_score": null,
"_source": {
"autoIncrement": 1170921.0,
"id": "018c889f3fae71c184914cdd22adf5e0"
},
"fields": {
"displayGroup": [
"602f589fb5d4d4780b4e38caaccecc27"
]
},
"sort": [
0,
"018c889f3fae71c184914cdd22adf5e0"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018ce24251277176a14f1a360f4409bf",
"_score": null,
"_source": {
"autoIncrement": 1233721.0,
"id": "018ce24251277176a14f1a360f4409bf"
},
"fields": {
"displayGroup": [
"b9535f1fa50a9e228a612e00691ed656"
]
},
"sort": [
0,
"018ce24251277176a14f1a360f4409bf"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018ce493552c707c939228aae5e94fd3",
"_score": null,
"_source": {
"autoIncrement": 1236398.0,
"id": "018ce493552c707c939228aae5e94fd3"
},
"fields": {
"displayGroup": [
"1c14bb94641bfbdbf5260150af54c640"
]
},
"sort": [
0,
"018ce493552c707c939228aae5e94fd3"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d133c4ae87098852bb8b0f789a8ce",
"_score": null,
"_source": {
"autoIncrement": 1250025.0,
"id": "018d133c4ae87098852bb8b0f789a8ce"
},
"fields": {
"displayGroup": [
"e5250798ce1fc552a235df0b25d7849d"
]
},
"sort": [
0,
"018d133c4ae87098852bb8b0f789a8ce"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d1345572272f4ad3001fb048ecd5f",
"_score": null,
"_source": {
"autoIncrement": 1250108.0,
"id": "018d1345572272f4ad3001fb048ecd5f"
},
"fields": {
"displayGroup": [
"10aa94e7d58f9562cff4125ee3610da2"
]
},
"sort": [
0,
"018d1345572272f4ad3001fb048ecd5f"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d135b25ee7215a8a396214f5f22c1",
"_score": null,
"_source": {
"autoIncrement": 1250289.0,
"id": "018d135b25ee7215a8a396214f5f22c1"
},
"fields": {
"displayGroup": [
"def476396f974adf2eb3dbc0d3aa9f4c"
]
},
"sort": [
0,
"018d135b25ee7215a8a396214f5f22c1"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d1f26be1270938be6c1ea7361a4b1",
"_score": null,
"_source": {
"autoIncrement": 1258818.0,
"id": "018d1f26be1270938be6c1ea7361a4b1"
},
"fields": {
"displayGroup": [
"0a2ca8aedaac999631b7c62603676560"
]
},
"sort": [
0,
"018d1f26be1270938be6c1ea7361a4b1"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d1f28b33173229b6e1bcbeb95f53e",
"_score": null,
"_source": {
"autoIncrement": 1258838.0,
"id": "018d1f28b33173229b6e1bcbeb95f53e"
},
"fields": {
"displayGroup": [
"928855fcb0cde9c49eccb8b93ab594b6"
]
},
"sort": [
0,
"018d1f28b33173229b6e1bcbeb95f53e"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d1f2ba61b737386fcbb5827f5a22f",
"_score": null,
"_source": {
"autoIncrement": 1258872.0,
"id": "018d1f2ba61b737386fcbb5827f5a22f"
},
"fields": {
"displayGroup": [
"54cd6404436c158897d86e0f876e81ad"
]
},
"sort": [
0,
"018d1f2ba61b737386fcbb5827f5a22f"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d55a78f6a7323a5d1a3e264bcb686",
"_score": null,
"_source": {
"autoIncrement": 1262474.0,
"id": "018d55a78f6a7323a5d1a3e264bcb686"
},
"fields": {
"displayGroup": [
"e9c4ef3a3faa4305fe487ee4ed864d89"
]
},
"sort": [
0,
"018d55a78f6a7323a5d1a3e264bcb686"
]
}
]
},
"aggregations": {
"total-count": {
"value": 20
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
12.63 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":"0189983826b873b0a345d573667c2537"}}}},{"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": 10,
"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": 448,
"rating": {
"value": 0.0
}
},
"price": {
"count": 448,
"min": 35.99,
"max": 107.96,
"avg": 62.095133928571435,
"sum": 27818.620000000003
},
"options": {
"doc_count": 894,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "63d84acf788c49e59731e1cb511d7474",
"doc_count": 36
},
{
"key": "93fee3ed40e24fa69a3584d7c66bc340",
"doc_count": 26
},
{
"key": "018b804b6afc7278a5393bb6c70c3667",
"doc_count": 25
},
{
"key": "018b804b6a9371bbbfa3efdc5fb53d21",
"doc_count": 23
},
{
"key": "29b5ae909a2044589870afe7895f5e2b",
"doc_count": 23
},
{
"key": "cf7179d03f394a93ada8b8f065cab004",
"doc_count": 23
},
{
"key": "018b804b84d471e48708d4bd67ff5ae7",
"doc_count": 21
},
{
"key": "018bbe1c4fcc712190d98918ff715e74",
"doc_count": 21
},
{
"key": "34cbea0035d84600904d39e5238023c9",
"doc_count": 21
},
{
"key": "cb52eda8a65947e3b6eda99736ee4834",
"doc_count": 21
},
{
"key": "349230794a4c47459c132dd470cef634",
"doc_count": 18
},
{
"key": "d21ed8e1e3fa4716a0656a8be2150db6",
"doc_count": 18
},
{
"key": "f6238f13680a479b8e6dee5111a73833",
"doc_count": 18
},
{
"key": "018c6903ca51708e94d707eeb2c62673",
"doc_count": 17
},
{
"key": "018d7968c1637275b2584b9927abdcb2",
"doc_count": 17
},
{
"key": "1c4813b5bfb3498eb9b77a52de18b2f9",
"doc_count": 17
},
{
"key": "2a3ebd3532fb4e8188df262ee3c6f054",
"doc_count": 15
},
{
"key": "b87aff86e10043b983f80541ed58a3f5",
"doc_count": 15
},
{
"key": "f5e54b3b6ec44472b09d0f8e263bedda",
"doc_count": 15
},
{
"key": "018c690388de73e18e0cb2237f150b3e",
"doc_count": 14
},
{
"key": "018c6903fdfb7254a18654b8b9500be2",
"doc_count": 14
},
{
"key": "1e787749081e41c0988899cdfdd52cc7",
"doc_count": 14
},
{
"key": "07d6768ec4e84afe9d28697d9cb0ede5",
"doc_count": 13
},
{
"key": "61bf0754013d46c392f76d5028b9ddf4",
"doc_count": 13
},
{
"key": "90a28041ada04a26a2cdfb7070a0a122",
"doc_count": 13
},
{
"key": "aa600a271b01423da7270bdac5b9e052",
"doc_count": 13
},
{
"key": "affaf560314e4c4f853adaeb8bd54beb",
"doc_count": 13
},
{
"key": "018c6903e6ce72a996460e23f5a0abb9",
"doc_count": 12
},
{
"key": "26c7bf58aed444a8aff5647239206358",
"doc_count": 12
},
{
"key": "2ef77dd834ab4ad8bf116883a3624328",
"doc_count": 12
},
{
"key": "684b0baf4a4b4084a60ef3a41bb894ec",
"doc_count": 12
},
{
"key": "97610a9e8a0f4970a7be7eec0bac0378",
"doc_count": 12
},
{
"key": "a5d7196c2514479f857621c32bb84608",
"doc_count": 12
},
{
"key": "c0088ccb433c49aaadfc61d1966f804c",
"doc_count": 12
},
{
"key": "e1b2548665464da9b4f051e46c78427f",
"doc_count": 12
},
{
"key": "e6f0f138ceb749deb3299c675145c94b",
"doc_count": 12
},
{
"key": "018b804fed3c7029b0c0c66ddbc3d8ef",
"doc_count": 11
},
{
"key": "7fe1040b735a45e9821be57bffa8aea8",
"doc_count": 11
},
{
"key": "c36af3803d914e8bb422246a1b400a68",
"doc_count": 11
},
{
"key": "d32f5d7c6ff24f32ac2cef76583b3ff3",
"doc_count": 11
},
{
"key": "f166e204f18a46cd947eb253dc245521",
"doc_count": 11
},
{
"key": "fb2bcb1d04544f8e91cab9caadccd0e2",
"doc_count": 11
},
{
"key": "24825ae0f7ff41bdbddc49e34931df58",
"doc_count": 10
},
{
"key": "64a44b3d85144a88b890b250e7030d5f",
"doc_count": 10
},
{
"key": "6f242ff7ed204f40be74447de407e8b9",
"doc_count": 10
},
{
"key": "7189e238f66c4db8831ad403f65df75e",
"doc_count": 10
},
{
"key": "98d6bcd6d5da4c45a80c847b8f441853",
"doc_count": 10
},
{
"key": "a58a7c5153e244f6beff748e6f958e27",
"doc_count": 10
},
{
"key": "c4ca7c83d7b9434dba35d808f3cb587b",
"doc_count": 10
},
{
"key": "018b804b836671049041138759a38581",
"doc_count": 9
},
{
"key": "018c6903a0c070849ea447f198f8196c",
"doc_count": 9
},
{
"key": "3ed3305b87114ce0879ea10a0c4a7e32",
"doc_count": 9
},
{
"key": "528d738a30b847248434b14e905cd91c",
"doc_count": 9
},
{
"key": "799eeec01566421399f0186a0c1929ae",
"doc_count": 9
},
{
"key": "b5a3d8c7138344dda67987a4eff4cb1c",
"doc_count": 9
},
{
"key": "cc38705796084a7e955c69cc24f7f231",
"doc_count": 9
},
{
"key": "018b804b825f72e0b27005e20727004d",
"doc_count": 8
},
{
"key": "f0fd0a0b99ec4d9cb683fc70c9c1f6c2",
"doc_count": 8
},
{
"key": "4113131b7ca54d478171d58ccee82fea",
"doc_count": 7
},
{
"key": "23d4376c5b7f4cc58a584059d690a349",
"doc_count": 6
},
{
"key": "90d76fb8a9704627be9d09487f1597f3",
"doc_count": 6
},
{
"key": "f0dec2e1db1b4427b14566f6dee67ba3",
"doc_count": 6
},
{
"key": "13aa12d0ba23429a91307cd1c7ab8897",
"doc_count": 4
},
{
"key": "1c23aae651524363801a44213f31f325",
"doc_count": 4
},
{
"key": "27c8631adebe4dbaa488d434a60fede1",
"doc_count": 4
},
{
"key": "493cae969e0b4e75a2e4272d2a6fa240",
"doc_count": 4
},
{
"key": "7d02ec05b3f54d9aa4afe8e13731ce4c",
"doc_count": 4
},
{
"key": "a053c882e22f4d3e96fe143b7f870cc4",
"doc_count": 4
},
{
"key": "a9cad9e916b7460b887df2bcef6f7cae",
"doc_count": 4
},
{
"key": "b333e4fbe005414bb4cb752913be4b46",
"doc_count": 4
},
{
"key": "d39074020fe54e79ab8a2c3c1db6c411",
"doc_count": 4
},
{
"key": "1032cce732234c2da6d124956f00ed50",
"doc_count": 3
},
{
"key": "549603b6c17f42a595c6cd3e44675888",
"doc_count": 3
},
{
"key": "018c6904a60a71d58e25430d71ee064a",
"doc_count": 2
},
{
"key": "01909bab3206720d9d2a216d31824cc5",
"doc_count": 1
},
{
"key": "a3f4ecc2e87443d79c203405cf6b2cbe",
"doc_count": 1
},
{
"key": "b9098912ba704078bf6482acae250e23",
"doc_count": 1
},
{
"key": "bace55c509624d8ab8a0c4653bced477",
"doc_count": 1
},
{
"key": "f1c0d70c9b714c4cb27beb8f22273242",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 1658,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "018963e5f53b7292b003bf6803f624b7",
"doc_count": 444
},
{
"key": "01896412a63c7149969609b5ac16c21f",
"doc_count": 295
},
{
"key": "018963ea415c7217b4dc8cb62572ed16",
"doc_count": 224
},
{
"key": "01896411e25971f98272a565102c3faf",
"doc_count": 196
},
{
"key": "01896411e1b67172ac7120fc2f0fa574",
"doc_count": 133
},
{
"key": "018963ea3aba7042895b047285c1402e",
"doc_count": 79
},
{
"key": "01896412a45673efbbd92d9df3190956",
"doc_count": 70
},
{
"key": "01896412a6e770daa46aa383bb185431",
"doc_count": 50
},
{
"key": "018bbe13c1f071a095ab51339e1d02ad",
"doc_count": 50
},
{
"key": "018bbe13bff4727baa40d87b9df82a76",
"doc_count": 34
},
{
"key": "018bbe13b8237164810b74768f091ae7",
"doc_count": 24
},
{
"key": "018963ea1812737fb7f416641565cd24",
"doc_count": 17
},
{
"key": "018963ea220370f6b3962a1108942bae",
"doc_count": 11
},
{
"key": "018963ea26b971f09527dfc7f4930323",
"doc_count": 10
},
{
"key": "018bbe13baeb7369bc549fcbcdce4c6d",
"doc_count": 6
},
{
"key": "018963e5f13871739bde1b0eb26bb21b",
"doc_count": 4
},
{
"key": "018963ea1a0071e3b903843432a2818e",
"doc_count": 3
},
{
"key": "018bbe13b8cd710c9456aa52d02306b1",
"doc_count": 3
},
{
"key": "018963ea3964707fbbfb35b2b8e8084b",
"doc_count": 2
},
{
"key": "018dcc3373f47133833772ee8dfc3fe4",
"doc_count": 2
},
{
"key": "018963ea24c172519a11176e570bcae4",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "d8ac016c293145ff9d20f96184a4ad02",
"doc_count": 191
},
{
"key": "1a0ffc50b3584a1abd28c2d06d6c6465",
"doc_count": 137
},
{
"key": "1cadc079599b4e0386adc59541691ef7",
"doc_count": 118
},
{
"key": "018c7c9a622870078a62e47c70408932",
"doc_count": 2
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|