| 1 |
11.66 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":"01899823ec7f715ba03742f7e3054eec"}}}},{"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": 8,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 143,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_all4team_product_1716336301",
"_id": "014d648eebca4dd492b9bf46c4218675",
"_score": null,
"_source": {
"autoIncrement": 1116977.0,
"id": "014d648eebca4dd492b9bf46c4218675"
},
"fields": {
"displayGroup": [
"10c7dea47a5888d4b0e72e0df6a64a73"
]
},
"sort": [
0,
"014d648eebca4dd492b9bf46c4218675"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018df10b88cf73f79d24125d094c9cfc",
"_score": null,
"_source": {
"autoIncrement": 1751196.0,
"id": "018df10b88cf73f79d24125d094c9cfc"
},
"fields": {
"displayGroup": [
"f7c94d2e7905d80c711fbd60aba23608"
]
},
"sort": [
0,
"018df10b88cf73f79d24125d094c9cfc"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018df10bc1a472c5821270ae130f4db5",
"_score": null,
"_source": {
"autoIncrement": 1751212.0,
"id": "018df10bc1a472c5821270ae130f4db5"
},
"fields": {
"displayGroup": [
"0d63269d8a9fb0bb7721a14858b11a12"
]
},
"sort": [
0,
"018df10bc1a472c5821270ae130f4db5"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018df10bfc11735ab395b0e24ba4f530",
"_score": null,
"_source": {
"autoIncrement": 1751228.0,
"id": "018df10bfc11735ab395b0e24ba4f530"
},
"fields": {
"displayGroup": [
"e09650037b3cca4bfb9d31726a0e620a"
]
},
"sort": [
0,
"018df10bfc11735ab395b0e24ba4f530"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018df10c2fb271208b99c04b71c1bcf4",
"_score": null,
"_source": {
"autoIncrement": 1751244.0,
"id": "018df10c2fb271208b99c04b71c1bcf4"
},
"fields": {
"displayGroup": [
"c01ec40542a7777d7b7c330de76bb27a"
]
},
"sort": [
0,
"018df10c2fb271208b99c04b71c1bcf4"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018df10c760a704ea03376fb7db6d053",
"_score": null,
"_source": {
"autoIncrement": 1751260.0,
"id": "018df10c760a704ea03376fb7db6d053"
},
"fields": {
"displayGroup": [
"20f028327bcbe0e5532e7a501565da5d"
]
},
"sort": [
0,
"018df10c760a704ea03376fb7db6d053"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018df10d5f237339b24d5022fe24085d",
"_score": null,
"_source": {
"autoIncrement": 1751320.0,
"id": "018df10d5f237339b24d5022fe24085d"
},
"fields": {
"displayGroup": [
"853eba698c6ee5fe80e626c78404a780"
]
},
"sort": [
0,
"018df10d5f237339b24d5022fe24085d"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018df10e2d5d713c8fe264ddec1c6377",
"_score": null,
"_source": {
"autoIncrement": 1751364.0,
"id": "018df10e2d5d713c8fe264ddec1c6377"
},
"fields": {
"displayGroup": [
"e34f2b3f436fe1e2b1339e6e34116ec0"
]
},
"sort": [
0,
"018df10e2d5d713c8fe264ddec1c6377"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018df10e6b957095abc7505a523d6443",
"_score": null,
"_source": {
"autoIncrement": 1751380.0,
"id": "018df10e6b957095abc7505a523d6443"
},
"fields": {
"displayGroup": [
"567864e191482caa4372b6e7838f6f13"
]
},
"sort": [
0,
"018df10e6b957095abc7505a523d6443"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018df11059a573adbfa75bc7b16597ba",
"_score": null,
"_source": {
"autoIncrement": 1751494.0,
"id": "018df11059a573adbfa75bc7b16597ba"
},
"fields": {
"displayGroup": [
"c143578c4eb97d91ffe378ad7c3ab198"
]
},
"sort": [
0,
"018df11059a573adbfa75bc7b16597ba"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018df1108b9f71d086afbef974f950ff",
"_score": null,
"_source": {
"autoIncrement": 1751510.0,
"id": "018df1108b9f71d086afbef974f950ff"
},
"fields": {
"displayGroup": [
"08ea24fcf3183c9d7e31c9e34612caf3"
]
},
"sort": [
0,
"018df1108b9f71d086afbef974f950ff"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018df110bd847360b9d09f41b120fa80",
"_score": null,
"_source": {
"autoIncrement": 1751526.0,
"id": "018df110bd847360b9d09f41b120fa80"
},
"fields": {
"displayGroup": [
"821774300e535632cf3ddecd8c2c8333"
]
},
"sort": [
0,
"018df110bd847360b9d09f41b120fa80"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018df110e86971b89266a87f605aa21d",
"_score": null,
"_source": {
"autoIncrement": 1751542.0,
"id": "018df110e86971b89266a87f605aa21d"
},
"fields": {
"displayGroup": [
"43df6c3001491ada6d162a2f486aa181"
]
},
"sort": [
0,
"018df110e86971b89266a87f605aa21d"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018df11159487157802f97ed8ee0097e",
"_score": null,
"_source": {
"autoIncrement": 1751572.0,
"id": "018df11159487157802f97ed8ee0097e"
},
"fields": {
"displayGroup": [
"d0a93b5a84e2e3b46fd10e8035a77f1d"
]
},
"sort": [
0,
"018df11159487157802f97ed8ee0097e"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018df111cb4273b5ab6833fb63c86773",
"_score": null,
"_source": {
"autoIncrement": 1751602.0,
"id": "018df111cb4273b5ab6833fb63c86773"
},
"fields": {
"displayGroup": [
"b3c69dabd5f7a6bb118dd00cedb559f0"
]
},
"sort": [
0,
"018df111cb4273b5ab6833fb63c86773"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018df111f8f8733fab4e63fc1a1a6f9f",
"_score": null,
"_source": {
"autoIncrement": 1751618.0,
"id": "018df111f8f8733fab4e63fc1a1a6f9f"
},
"fields": {
"displayGroup": [
"1e3e6aa7a14d290c8518ccddde2d16cc"
]
},
"sort": [
0,
"018df111f8f8733fab4e63fc1a1a6f9f"
]
}
]
},
"aggregations": {
"total-count": {
"value": 18
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
6.73 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":"01899823ec7f715ba03742f7e3054eec"}}}},{"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": 4,
"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": 143,
"rating": {
"value": 0.0
}
},
"price": {
"count": 143,
"min": 25.19,
"max": 76.46,
"avg": 29.674335664335665,
"sum": 4243.43
},
"options": {
"doc_count": 286,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "018adf8a6c537146ad816479372d3164",
"doc_count": 28
},
{
"key": "63a3e4e3a8d0461ca937227647cbc474",
"doc_count": 22
},
{
"key": "bace55c509624d8ab8a0c4653bced477",
"doc_count": 22
},
{
"key": "018adf8a711a70afad0a81bf8c7b3b98",
"doc_count": 21
},
{
"key": "103c221ef5c547a6919548726a45adb7",
"doc_count": 21
},
{
"key": "df41139ab42a4f0dbe2167afb103b833",
"doc_count": 21
},
{
"key": "f1c0d70c9b714c4cb27beb8f22273242",
"doc_count": 21
},
{
"key": "6818490b3d264af396bf32b5c741cb18",
"doc_count": 20
},
{
"key": "b26bb94349e2469ea3e048b8bd50a91d",
"doc_count": 16
},
{
"key": "018dcc33db8a71a49f04cf3813b8fd54",
"doc_count": 14
},
{
"key": "018dd236779673bcaa7b30326b13b9e2",
"doc_count": 14
},
{
"key": "018dd2362ce27343ae8d79dca3db842f",
"doc_count": 7
},
{
"key": "018dd23645fe720f843fc8b131d50bf4",
"doc_count": 7
},
{
"key": "018dd2365aee71469f3b7698e6d2896d",
"doc_count": 7
},
{
"key": "018dd23679e273e597303d45c8913a1e",
"doc_count": 7
},
{
"key": "018dd2367f3c7116a54bb7b46914ad4c",
"doc_count": 7
},
{
"key": "01f53106a64a48b9a0a0a92ab2aa0143",
"doc_count": 6
},
{
"key": "84b645877b964a1fb33eac80d05c2e41",
"doc_count": 6
},
{
"key": "a9fc45f2f64f490b940b21c917a15c64",
"doc_count": 6
},
{
"key": "e50791a4a10e4d658d16d16a49d6de98",
"doc_count": 6
},
{
"key": "489ab7a68fb7402f81f190225fcd412a",
"doc_count": 5
},
{
"key": "01909baa68987118bb81e3d410bc42fc",
"doc_count": 2
}
]
}
},
"properties": {
"doc_count": 713,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "018963e5f13871739bde1b0eb26bb21b",
"doc_count": 143
},
{
"key": "0189641265e57151afa0c1afb0501c4c",
"doc_count": 141
},
{
"key": "01896411e11071498f66a862f5383700",
"doc_count": 112
},
{
"key": "018dcc3373f47133833772ee8dfc3fe4",
"doc_count": 112
},
{
"key": "018963ea1812737fb7f416641565cd24",
"doc_count": 34
},
{
"key": "01896411e3007292bbf291a9837a8cc8",
"doc_count": 31
},
{
"key": "018963ea3aba7042895b047285c1402e",
"doc_count": 30
},
{
"key": "018963ea415c7217b4dc8cb62572ed16",
"doc_count": 27
},
{
"key": "018963ea3964707fbbfb35b2b8e8084b",
"doc_count": 19
},
{
"key": "018963ea220370f6b3962a1108942bae",
"doc_count": 14
},
{
"key": "018963ea336b7003ba1d74549036192d",
"doc_count": 7
},
{
"key": "018963ea20b670278236dc7103bcceb8",
"doc_count": 6
},
{
"key": "018963ea24c172519a11176e570bcae4",
"doc_count": 6
},
{
"key": "018bbe13b8237164810b74768f091ae7",
"doc_count": 6
},
{
"key": "018bbe13b97a72e79ffb27e38f96bbb2",
"doc_count": 6
},
{
"key": "018bbe13bba571c9a39ca3fe33a172cd",
"doc_count": 6
},
{
"key": "018bbe13c1f071a095ab51339e1d02ad",
"doc_count": 6
},
{
"key": "018bbe13bf4971378f6c9737de6890aa",
"doc_count": 5
},
{
"key": "018964126330733c9657f71ed206f60f",
"doc_count": 2
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "57f85a1341f34ad284dc91714711a009",
"doc_count": 112
},
{
"key": "d8ac016c293145ff9d20f96184a4ad02",
"doc_count": 31
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|