| 1 |
43.58 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":"019295e8890b711eb4cb6da7cdc383a6"}}}},{"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": 140,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_all4team_product_1716336301",
"_id": "0192de621edb72b1b88a767549ba31d5",
"_score": null,
"_source": {
"autoIncrement": 1854100.0,
"id": "0192de621edb72b1b88a767549ba31d5"
},
"fields": {
"displayGroup": [
"a1771a7057a922626ee3834cdff0020f"
]
},
"sort": [
0,
"0192de621edb72b1b88a767549ba31d5"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0192de623aae7222ac70105c71f80743",
"_score": null,
"_source": {
"autoIncrement": 1854104.0,
"id": "0192de623aae7222ac70105c71f80743"
},
"fields": {
"displayGroup": [
"aad14c77e259ffbf5b414a7efac575bd"
]
},
"sort": [
0,
"0192de623aae7222ac70105c71f80743"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0192de6257cf722c8b04468125ccc4cf",
"_score": null,
"_source": {
"autoIncrement": 1854117.0,
"id": "0192de6257cf722c8b04468125ccc4cf"
},
"fields": {
"displayGroup": [
"e5c55e6330dc914ac24e5a2c05866af1"
]
},
"sort": [
0,
"0192de6257cf722c8b04468125ccc4cf"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0192de6272b97203a756f3a0b965197f",
"_score": null,
"_source": {
"autoIncrement": 1854130.0,
"id": "0192de6272b97203a756f3a0b965197f"
},
"fields": {
"displayGroup": [
"e128929737f679e9d7d13d01be58fb66"
]
},
"sort": [
0,
"0192de6272b97203a756f3a0b965197f"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0192de628f9971608325bd5e393565a8",
"_score": null,
"_source": {
"autoIncrement": 1854139.0,
"id": "0192de628f9971608325bd5e393565a8"
},
"fields": {
"displayGroup": [
"3b6aa43f79a704d263f95fee9c7158a8"
]
},
"sort": [
0,
"0192de628f9971608325bd5e393565a8"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0192de62aaa070af8ccd53477d2f0e99",
"_score": null,
"_source": {
"autoIncrement": 1854150.0,
"id": "0192de62aaa070af8ccd53477d2f0e99"
},
"fields": {
"displayGroup": [
"50e5ce505fc36eff8979112971f10d32"
]
},
"sort": [
0,
"0192de62aaa070af8ccd53477d2f0e99"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0192de62c127721fa1c371832e4c3226",
"_score": null,
"_source": {
"autoIncrement": 1854160.0,
"id": "0192de62c127721fa1c371832e4c3226"
},
"fields": {
"displayGroup": [
"8bdf6e232b94606c1cbb04626b55688f"
]
},
"sort": [
0,
"0192de62c127721fa1c371832e4c3226"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0192de62dce8724aa9d8987060c1aa0e",
"_score": null,
"_source": {
"autoIncrement": 1854165.0,
"id": "0192de62dce8724aa9d8987060c1aa0e"
},
"fields": {
"displayGroup": [
"12f9ee40e642eda8b682909f99dc53a7"
]
},
"sort": [
0,
"0192de62dce8724aa9d8987060c1aa0e"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0192de62f89770e695acc89dbc940d29",
"_score": null,
"_source": {
"autoIncrement": 1854174.0,
"id": "0192de62f89770e695acc89dbc940d29"
},
"fields": {
"displayGroup": [
"2f06887ebccf9351e44fbd4c228ec1dc"
]
},
"sort": [
0,
"0192de62f89770e695acc89dbc940d29"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0192de630d82725f891dbb99e4863cd0",
"_score": null,
"_source": {
"autoIncrement": 1854183.0,
"id": "0192de630d82725f891dbb99e4863cd0"
},
"fields": {
"displayGroup": [
"81e07683f248e9c8b7ddeffbe8ec7ba0"
]
},
"sort": [
0,
"0192de630d82725f891dbb99e4863cd0"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0192de63297d7315b63be6f3475c9686",
"_score": null,
"_source": {
"autoIncrement": 1854192.0,
"id": "0192de63297d7315b63be6f3475c9686"
},
"fields": {
"displayGroup": [
"93525e8e5ddc2fc3d9c9ef7d8a80f550"
]
},
"sort": [
0,
"0192de63297d7315b63be6f3475c9686"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0192e209111c725da96b003606327613",
"_score": null,
"_source": {
"autoIncrement": 1855030.0,
"id": "0192e209111c725da96b003606327613"
},
"fields": {
"displayGroup": [
"77fafd749a7716babeaaac7fa2077104"
]
},
"sort": [
0,
"0192e209111c725da96b003606327613"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0192e2093d7f719894b5865b1856345f",
"_score": null,
"_source": {
"autoIncrement": 1855051.0,
"id": "0192e2093d7f719894b5865b1856345f"
},
"fields": {
"displayGroup": [
"fe9334bd60d8280b226982cd9ff06d9d"
]
},
"sort": [
0,
"0192e2093d7f719894b5865b1856345f"
]
}
]
},
"aggregations": {
"total-count": {
"value": 13
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
18.52 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":"019295e8890b711eb4cb6da7cdc383a6"}}}},{"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": 7,
"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": 140,
"rating": {
"value": 0.0
}
},
"price": {
"count": 140,
"min": 10.5,
"max": 44.0,
"avg": 23.839285714285715,
"sum": 3337.5
},
"options": {
"doc_count": 280,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "20db184c1fdb49508a4ccd08b882a19f",
"doc_count": 31
},
{
"key": "507f2e527d524e359c477d74d4605b1f",
"doc_count": 31
},
{
"key": "60de90a916684ef696e8ba9bd8060cbc",
"doc_count": 31
},
{
"key": "5e2f46d53cb046f9a5f9736c372966f8",
"doc_count": 30
},
{
"key": "f58faace294945af9f1442838b3a6e8d",
"doc_count": 29
},
{
"key": "018b6a961d13735598e653491d91b708",
"doc_count": 14
},
{
"key": "37347e78acc44de0a2b07896ba5339c0",
"doc_count": 14
},
{
"key": "018c1b6a745171d5beed8a36387477e7",
"doc_count": 12
},
{
"key": "018b6a9f6c9873379da9231c4e2ac056",
"doc_count": 10
},
{
"key": "84570bc6edaf45799fee515c1bab6509",
"doc_count": 10
},
{
"key": "85444052b5404c19af8cb2978781bc5b",
"doc_count": 10
},
{
"key": "018b804b6a9371bbbfa3efdc5fb53d21",
"doc_count": 9
},
{
"key": "18b47e8a1e234e81a83f9544a04e32ef",
"doc_count": 8
},
{
"key": "8b7442faf2fa4077bb2161946af82300",
"doc_count": 8
},
{
"key": "f4ae98e61a6e405cb0b5a221ef13dbfe",
"doc_count": 8
},
{
"key": "018b804b6e8470268bc931f30dc11df5",
"doc_count": 4
},
{
"key": "018b804feb84734792b65107c49a7591",
"doc_count": 4
},
{
"key": "018c1b6a7cff71ff87385b775b0b9e46",
"doc_count": 4
},
{
"key": "88e37ca9c31b4575a7e4c105a1139281",
"doc_count": 4
},
{
"key": "4c021052c64a4daca41cc36e9d697031",
"doc_count": 3
},
{
"key": "99e0a1d01c2140979597380ec8880523",
"doc_count": 3
},
{
"key": "15640b6b5ae049adb2959de4695a5511",
"doc_count": 1
},
{
"key": "510ffa3d1fbd423ca3bf5fe21925a569",
"doc_count": 1
},
{
"key": "8e451b41e214412a9126e586c6d3a680",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 465,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "018963e5f32b703288aad57690802852",
"doc_count": 140
},
{
"key": "01896411e3af718192fb7f9ee45ad6fb",
"doc_count": 85
},
{
"key": "01896411e25971f98272a565102c3faf",
"doc_count": 40
},
{
"key": "018963ea220370f6b3962a1108942bae",
"doc_count": 25
},
{
"key": "01896412b6a87264b8acd4e76056d216",
"doc_count": 20
},
{
"key": "01896412f65d71c2a96142c4aae4b7ab",
"doc_count": 20
},
{
"key": "018bbe14740a71fd876c07cbfdd9fd4f",
"doc_count": 20
},
{
"key": "018bbe14791071689082984f07aee87b",
"doc_count": 20
},
{
"key": "018bbe14735f7284ba6d5630b0de21d1",
"doc_count": 19
},
{
"key": "018bbe147614712bb735c9a8d2d50799",
"doc_count": 15
},
{
"key": "018963ea3964707fbbfb35b2b8e8084b",
"doc_count": 10
},
{
"key": "018963ea415c7217b4dc8cb62572ed16",
"doc_count": 10
},
{
"key": "01896411e78a73399a29ed714246da0d",
"doc_count": 10
},
{
"key": "018e197a6c5272c1a2bb025af66bd101",
"doc_count": 10
},
{
"key": "018f05bda7ca735faaff8f84c963cd06",
"doc_count": 8
},
{
"key": "01896411e3007292bbf291a9837a8cc8",
"doc_count": 5
},
{
"key": "01896412c4d372afb007071030df2b40",
"doc_count": 5
},
{
"key": "018bbe14756472c494ac6c20dfc7fb46",
"doc_count": 3
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "1cadc079599b4e0386adc59541691ef7",
"doc_count": 140
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|