| 1 |
33.99 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":"018df4309ad8717a92f5a71975fbacbb"}}}},{"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": 31,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 134,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_all4team_product_1716336301",
"_id": "0194e2db6cca7121b18c55a6cf4b86bc",
"_score": null,
"_source": {
"autoIncrement": 1920720.0,
"id": "0194e2db6cca7121b18c55a6cf4b86bc"
},
"fields": {
"displayGroup": [
"5e3de01bab15401029cd1e4376a946dc"
]
},
"sort": [
11,
"0194e2db6cca7121b18c55a6cf4b86bc"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0194e2dbde067239b9bc940dcdcdc4f1",
"_score": null,
"_source": {
"autoIncrement": 1920742.0,
"id": "0194e2dbde067239b9bc940dcdcdc4f1"
},
"fields": {
"displayGroup": [
"53d9c8618b75dc9b8a6069d3e65b5c6d"
]
},
"sort": [
6,
"0194e2dbde067239b9bc940dcdcdc4f1"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0194e2dc24bb719db968b0d192119c12",
"_score": null,
"_source": {
"autoIncrement": 1920756.0,
"id": "0194e2dc24bb719db968b0d192119c12"
},
"fields": {
"displayGroup": [
"d1d4b6648fd83e0b31631bd7e86a19aa"
]
},
"sort": [
5,
"0194e2dc24bb719db968b0d192119c12"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0194e2dc85707062a1821a7cb896bcb1",
"_score": null,
"_source": {
"autoIncrement": 1920779.0,
"id": "0194e2dc85707062a1821a7cb896bcb1"
},
"fields": {
"displayGroup": [
"3adf70a6c29d8ecb3533e324be0a62fa"
]
},
"sort": [
4,
"0194e2dc85707062a1821a7cb896bcb1"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01950553c8de70c7b5ad9a6c84e62a83",
"_score": null,
"_source": {
"autoIncrement": 1921992.0,
"id": "01950553c8de70c7b5ad9a6c84e62a83"
},
"fields": {
"displayGroup": [
"f4328f1c814f322c5e97511c40bd3588"
]
},
"sort": [
4,
"01950553c8de70c7b5ad9a6c84e62a83"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0194e2db3653712abeff91387687649e",
"_score": null,
"_source": {
"autoIncrement": 1920712.0,
"id": "0194e2db3653712abeff91387687649e"
},
"fields": {
"displayGroup": [
"4968a257c40aae22b615913b82418e0f"
]
},
"sort": [
3,
"0194e2db3653712abeff91387687649e"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0194e2db933571b7bc9328bb8418ddd3",
"_score": null,
"_source": {
"autoIncrement": 1920730.0,
"id": "0194e2db933571b7bc9328bb8418ddd3"
},
"fields": {
"displayGroup": [
"6735a0de76da6a23d53877a60c03d08e"
]
},
"sort": [
3,
"0194e2db933571b7bc9328bb8418ddd3"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0194e2dc4269729e81c2d989994ad81c",
"_score": null,
"_source": {
"autoIncrement": 1920763.0,
"id": "0194e2dc4269729e81c2d989994ad81c"
},
"fields": {
"displayGroup": [
"9adaa9c774fcc9c4e503c383fd5996b7"
]
},
"sort": [
3,
"0194e2dc4269729e81c2d989994ad81c"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0194e2dc65c0731e9d1794e572a22e1a",
"_score": null,
"_source": {
"autoIncrement": 1920771.0,
"id": "0194e2dc65c0731e9d1794e572a22e1a"
},
"fields": {
"displayGroup": [
"ad2ef36d44dffc78b31da0f5b4b9944f"
]
},
"sort": [
3,
"0194e2dc65c0731e9d1794e572a22e1a"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0194e2dca59972c6883c02c0996777d3",
"_score": null,
"_source": {
"autoIncrement": 1920783.0,
"id": "0194e2dca59972c6883c02c0996777d3"
},
"fields": {
"displayGroup": [
"04414dc6754c8219b4156d23849fa0bf"
]
},
"sort": [
3,
"0194e2dca59972c6883c02c0996777d3"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0194f24e474a7057b7853ae9a55b8a7f",
"_score": null,
"_source": {
"autoIncrement": 1921946.0,
"id": "0194f24e474a7057b7853ae9a55b8a7f"
},
"fields": {
"displayGroup": [
"10744d0c24de15aeeb755fbfd48172f0"
]
},
"sort": [
3,
"0194f24e474a7057b7853ae9a55b8a7f"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "019504c2696670e79a3f5561904e54cc",
"_score": null,
"_source": {
"autoIncrement": 1921961.0,
"id": "019504c2696670e79a3f5561904e54cc"
},
"fields": {
"displayGroup": [
"58484d6931463b82e52ce3a7213de2ce"
]
},
"sort": [
3,
"019504c2696670e79a3f5561904e54cc"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0194e2db506672afac473bf1ea1d1dfc",
"_score": null,
"_source": {
"autoIncrement": 1920715.0,
"id": "0194e2db506672afac473bf1ea1d1dfc"
},
"fields": {
"displayGroup": [
"ec1a6bb915edc5488b9bc0f41a407de7"
]
},
"sort": [
2,
"0194e2db506672afac473bf1ea1d1dfc"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0194e2dbba117328b4a7c5f4d157932a",
"_score": null,
"_source": {
"autoIncrement": 1920736.0,
"id": "0194e2dbba117328b4a7c5f4d157932a"
},
"fields": {
"displayGroup": [
"7bd955b36bd48108d237b7e06281a6de"
]
},
"sort": [
2,
"0194e2dbba117328b4a7c5f4d157932a"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0195055383667305a19eac44478be2c5",
"_score": null,
"_source": {
"autoIncrement": 1921969.0,
"id": "0195055383667305a19eac44478be2c5"
},
"fields": {
"displayGroup": [
"71adca2fa043e24ccf6f309af9700ccd"
]
},
"sort": [
2,
"0195055383667305a19eac44478be2c5"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01950553f3ff7251bf6ec0f0281a87e8",
"_score": null,
"_source": {
"autoIncrement": 1921999.0,
"id": "01950553f3ff7251bf6ec0f0281a87e8"
},
"fields": {
"displayGroup": [
"1aa7ab7c793e0c383fbf9e6cffd6067a"
]
},
"sort": [
2,
"01950553f3ff7251bf6ec0f0281a87e8"
]
}
]
},
"aggregations": {
"total-count": {
"value": 28
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
9.95 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":"018df4309ad8717a92f5a71975fbacbb"}}}},{"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": 8,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"max_score": null,
"hits": []
},
"aggregations": {
"shipping-free-filter": {
"doc_count": 3,
"shipping-free": {
"value": 1.0,
"value_as_string": "true"
}
},
"rating-exists": {
"doc_count": 134,
"rating": {
"value": 0.0
}
},
"price": {
"count": 134,
"min": 12.5,
"max": 89.0,
"avg": 30.21641791044776,
"sum": 4049.0
},
"options": {
"doc_count": 262,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "018b6a9f64927202a16add724f0cd0c7",
"doc_count": 72
},
{
"key": "018b6a9f6a7b7345bcf7865560e3a2f6",
"doc_count": 33
},
{
"key": "018b6aa3d18f7200abf662eedbcbb87a",
"doc_count": 21
},
{
"key": "103c221ef5c547a6919548726a45adb7",
"doc_count": 11
},
{
"key": "63a3e4e3a8d0461ca937227647cbc474",
"doc_count": 11
},
{
"key": "6818490b3d264af396bf32b5c741cb18",
"doc_count": 11
},
{
"key": "bace55c509624d8ab8a0c4653bced477",
"doc_count": 11
},
{
"key": "df41139ab42a4f0dbe2167afb103b833",
"doc_count": 11
},
{
"key": "f1c0d70c9b714c4cb27beb8f22273242",
"doc_count": 9
},
{
"key": "20db184c1fdb49508a4ccd08b882a19f",
"doc_count": 8
},
{
"key": "507f2e527d524e359c477d74d4605b1f",
"doc_count": 8
},
{
"key": "60de90a916684ef696e8ba9bd8060cbc",
"doc_count": 7
},
{
"key": "3d0b11d1db0f48f7acb284976d0b45e0",
"doc_count": 6
},
{
"key": "5e2f46d53cb046f9a5f9736c372966f8",
"doc_count": 6
},
{
"key": "f4ae98e61a6e405cb0b5a221ef13dbfe",
"doc_count": 5
},
{
"key": "09df4c6efd80429ca293244b63560c6a",
"doc_count": 4
},
{
"key": "37347e78acc44de0a2b07896ba5339c0",
"doc_count": 4
},
{
"key": "5affb90217af40c58011013f87e6b516",
"doc_count": 4
},
{
"key": "6b8d9eb2113441598f83a6d7110d18d1",
"doc_count": 4
},
{
"key": "73e7ba66d965447b9ad7e2a05142cd85",
"doc_count": 4
},
{
"key": "a8b13ecee7f74d28af6ed8a74a20757f",
"doc_count": 4
},
{
"key": "b8ddb9b53e2740e58c6385b22bb05e29",
"doc_count": 4
},
{
"key": "28f55137f4e84d948607241ae098907a",
"doc_count": 1
},
{
"key": "72920208d2c44b4faeabefa145ae7021",
"doc_count": 1
},
{
"key": "9e073aa7b0df437882afb1fedb499df6",
"doc_count": 1
},
{
"key": "eb72ee1138594bdd96373a5ec3f2b7fc",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 522,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "01896411e3007292bbf291a9837a8cc8",
"doc_count": 116
},
{
"key": "018963ea1812737fb7f416641565cd24",
"doc_count": 96
},
{
"key": "018963e5f53b7292b003bf6803f624b7",
"doc_count": 76
},
{
"key": "018963ea3aba7042895b047285c1402e",
"doc_count": 38
},
{
"key": "018963e5f32b703288aad57690802852",
"doc_count": 34
},
{
"key": "018963e5f06f716dadb0fe95b3c53d22",
"doc_count": 24
},
{
"key": "0189641292b27351b91fb77f36a06de0",
"doc_count": 12
},
{
"key": "01896411e78a73399a29ed714246da0d",
"doc_count": 11
},
{
"key": "0189641298e47022ad38f8c819e86f43",
"doc_count": 7
},
{
"key": "01896412b5fc7191b412ee67da021b6b",
"doc_count": 7
},
{
"key": "01896412da8870c4b5b482ee9ce696ae",
"doc_count": 7
},
{
"key": "01896412f5b57107a5f77996ea62470b",
"doc_count": 7
},
{
"key": "018964130af672cab053852b5beb313e",
"doc_count": 7
},
{
"key": "01896412983571afb224c9d7e18dd5a5",
"doc_count": 6
},
{
"key": "01896412c43372e588debf827804f9a2",
"doc_count": 6
},
{
"key": "01896412d9e67359bbc174e3a4deb34a",
"doc_count": 6
},
{
"key": "01896412f51373c886fa6e0be85015e0",
"doc_count": 6
},
{
"key": "018964130067707cb05d3c60abe4521c",
"doc_count": 6
},
{
"key": "018964130db7712eb238a0a2670f1be9",
"doc_count": 6
},
{
"key": "01896412f3be73e9b9f7c1618b09e578",
"doc_count": 5
},
{
"key": "01896412f46a7164bc08cd3d2a5052cc",
"doc_count": 5
},
{
"key": "01896412f65d71c2a96142c4aae4b7ab",
"doc_count": 5
},
{
"key": "018964129394713eb8125185729c3a1e",
"doc_count": 4
},
{
"key": "018964129997706eb79198e148c59e0b",
"doc_count": 4
},
{
"key": "01896412c4d372afb007071030df2b40",
"doc_count": 4
},
{
"key": "01896412db2e715281560944e033a329",
"doc_count": 4
},
{
"key": "01896412ea7d708ba7bbb270597fc106",
"doc_count": 4
},
{
"key": "018964130e6870e08a10c6e6fe5c9a9d",
"doc_count": 4
},
{
"key": "018964130b9c738897298322953942b4",
"doc_count": 3
},
{
"key": "01896412ad8f72868d8b1364270023b5",
"doc_count": 2
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "1cadc079599b4e0386adc59541691ef7",
"doc_count": 134
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|