| 1 |
1078.04 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":"019058f7b3c5702386ad2bf426fa289f"}}}},{"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": 1074,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 159,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_all4team_product_1716336301",
"_id": "01905e81292e71a7abafd45035182230",
"_score": null,
"_source": {
"autoIncrement": 1806283.0,
"id": "01905e81292e71a7abafd45035182230"
},
"fields": {
"displayGroup": [
"60169df4a26b6cc96ee8fb80d851faca"
]
},
"sort": [
6,
"01905e81292e71a7abafd45035182230"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01905eb8410970d29a1ee110bcd545c6",
"_score": null,
"_source": {
"autoIncrement": 1806367.0,
"id": "01905eb8410970d29a1ee110bcd545c6"
},
"fields": {
"displayGroup": [
"62df431b8227bd314610b70349cd8a17"
]
},
"sort": [
6,
"01905eb8410970d29a1ee110bcd545c6"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01905eb8ba48702daeabaeec3d17a376",
"_score": null,
"_source": {
"autoIncrement": 1806384.0,
"id": "01905eb8ba48702daeabaeec3d17a376"
},
"fields": {
"displayGroup": [
"f8907fc155939a0898965a28ccdfaee9"
]
},
"sort": [
4,
"01905eb8ba48702daeabaeec3d17a376"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01905eb95f4a7223b44bb3a51eccf05a",
"_score": null,
"_source": {
"autoIncrement": 1806411.0,
"id": "01905eb95f4a7223b44bb3a51eccf05a"
},
"fields": {
"displayGroup": [
"0f0f15460cfa9b2e7f438432500009c1"
]
},
"sort": [
4,
"01905eb95f4a7223b44bb3a51eccf05a"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01905e818984726fbb7da27649b4a202",
"_score": null,
"_source": {
"autoIncrement": 1806298.0,
"id": "01905e818984726fbb7da27649b4a202"
},
"fields": {
"displayGroup": [
"3dda126cf54694e6010abdea4ea10a19"
]
},
"sort": [
3,
"01905e818984726fbb7da27649b4a202"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01905e809a1c7064a12d2916d9146287",
"_score": null,
"_source": {
"autoIncrement": 1806255.0,
"id": "01905e809a1c7064a12d2916d9146287"
},
"fields": {
"displayGroup": [
"4bc62adbea41098c932203123d003267"
]
},
"sort": [
0,
"01905e809a1c7064a12d2916d9146287"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01905e80c89173858104dfa52c39e5d3",
"_score": null,
"_source": {
"autoIncrement": 1806264.0,
"id": "01905e80c89173858104dfa52c39e5d3"
},
"fields": {
"displayGroup": [
"7330012bc720ab3c43d737e5f76cc023"
]
},
"sort": [
0,
"01905e80c89173858104dfa52c39e5d3"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01905e80f8ee7131a0a11e2aaae1374e",
"_score": null,
"_source": {
"autoIncrement": 1806273.0,
"id": "01905e80f8ee7131a0a11e2aaae1374e"
},
"fields": {
"displayGroup": [
"f03305cd0a09f4bd337d2baab9255e5f"
]
},
"sort": [
0,
"01905e80f8ee7131a0a11e2aaae1374e"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01905e8159cc7378bd0d3ced8b94c083",
"_score": null,
"_source": {
"autoIncrement": 1806288.0,
"id": "01905e8159cc7378bd0d3ced8b94c083"
},
"fields": {
"displayGroup": [
"e106507b100237a0a369d6fcebd2c749"
]
},
"sort": [
0,
"01905e8159cc7378bd0d3ced8b94c083"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01905e81b85c70c89af6d7759b5fe568",
"_score": null,
"_source": {
"autoIncrement": 1806306.0,
"id": "01905e81b85c70c89af6d7759b5fe568"
},
"fields": {
"displayGroup": [
"acdb8d6cb4aefab23cc3e1c90651de7a"
]
},
"sort": [
0,
"01905e81b85c70c89af6d7759b5fe568"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01905eb78c5a724aa5f765d838ee39e3",
"_score": null,
"_source": {
"autoIncrement": 1806333.0,
"id": "01905eb78c5a724aa5f765d838ee39e3"
},
"fields": {
"displayGroup": [
"79d03234bde9aa45bd9ffa6f2099a22f"
]
},
"sort": [
0,
"01905eb78c5a724aa5f765d838ee39e3"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01905eb7bae9737e8411e5876555f86e",
"_score": null,
"_source": {
"autoIncrement": 1806342.0,
"id": "01905eb7bae9737e8411e5876555f86e"
},
"fields": {
"displayGroup": [
"ca1903df70b1ede35feeea39628d705e"
]
},
"sort": [
0,
"01905eb7bae9737e8411e5876555f86e"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01905eb7e90f72639529b96225801392",
"_score": null,
"_source": {
"autoIncrement": 1806351.0,
"id": "01905eb7e90f72639529b96225801392"
},
"fields": {
"displayGroup": [
"f940ff38b89b4506d87e9aab7b7d8b37"
]
},
"sort": [
0,
"01905eb7e90f72639529b96225801392"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01905eb8157572ada36d14378359affd",
"_score": null,
"_source": {
"autoIncrement": 1806357.0,
"id": "01905eb8157572ada36d14378359affd"
},
"fields": {
"displayGroup": [
"300da77f8dcf5ed2696a4cb1d76ce321"
]
},
"sort": [
0,
"01905eb8157572ada36d14378359affd"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01905eb86f93712796fdd5e4eb8038ca",
"_score": null,
"_source": {
"autoIncrement": 1806375.0,
"id": "01905eb86f93712796fdd5e4eb8038ca"
},
"fields": {
"displayGroup": [
"008dab1c04d2ba5ed0633ab338709a3e"
]
},
"sort": [
0,
"01905eb86f93712796fdd5e4eb8038ca"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01905eb8f4f571dfa305f7c6a01b148f",
"_score": null,
"_source": {
"autoIncrement": 1806393.0,
"id": "01905eb8f4f571dfa305f7c6a01b148f"
},
"fields": {
"displayGroup": [
"88ff3885f0ecc1df7da957a0bf9bc500"
]
},
"sort": [
0,
"01905eb8f4f571dfa305f7c6a01b148f"
]
}
]
},
"aggregations": {
"total-count": {
"value": 21
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
13.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":"019058f7b3c5702386ad2bf426fa289f"}}}},{"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": 11,
"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": 159,
"rating": {
"value": 0.0
}
},
"price": {
"count": 159,
"min": 10.5,
"max": 49.99,
"avg": 21.757610062893082,
"sum": 3459.46
},
"options": {
"doc_count": 318,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "018b6aa3d18f7200abf662eedbcbb87a",
"doc_count": 159
},
{
"key": "103c221ef5c547a6919548726a45adb7",
"doc_count": 12
},
{
"key": "3d0b11d1db0f48f7acb284976d0b45e0",
"doc_count": 12
},
{
"key": "63a3e4e3a8d0461ca937227647cbc474",
"doc_count": 12
},
{
"key": "6818490b3d264af396bf32b5c741cb18",
"doc_count": 12
},
{
"key": "bace55c509624d8ab8a0c4653bced477",
"doc_count": 12
},
{
"key": "df41139ab42a4f0dbe2167afb103b833",
"doc_count": 12
},
{
"key": "e1d2d15171a64618a31876cd60bae00c",
"doc_count": 12
},
{
"key": "f1c0d70c9b714c4cb27beb8f22273242",
"doc_count": 12
},
{
"key": "09df4c6efd80429ca293244b63560c6a",
"doc_count": 6
},
{
"key": "5affb90217af40c58011013f87e6b516",
"doc_count": 6
},
{
"key": "6b8d9eb2113441598f83a6d7110d18d1",
"doc_count": 6
},
{
"key": "73e7ba66d965447b9ad7e2a05142cd85",
"doc_count": 6
},
{
"key": "a8b13ecee7f74d28af6ed8a74a20757f",
"doc_count": 6
},
{
"key": "adf66c9b2a824a02bc9b1cc28c4d5dcb",
"doc_count": 6
},
{
"key": "b8ddb9b53e2740e58c6385b22bb05e29",
"doc_count": 6
},
{
"key": "e79e0f0ea71a47c88535f185ed5e7866",
"doc_count": 6
},
{
"key": "20db184c1fdb49508a4ccd08b882a19f",
"doc_count": 3
},
{
"key": "37347e78acc44de0a2b07896ba5339c0",
"doc_count": 3
},
{
"key": "507f2e527d524e359c477d74d4605b1f",
"doc_count": 3
},
{
"key": "5e2f46d53cb046f9a5f9736c372966f8",
"doc_count": 3
},
{
"key": "60de90a916684ef696e8ba9bd8060cbc",
"doc_count": 3
}
]
}
},
"properties": {
"doc_count": 636,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "018963ea1812737fb7f416641565cd24",
"doc_count": 159
},
{
"key": "01896411e25971f98272a565102c3faf",
"doc_count": 159
},
{
"key": "018963e5f53b7292b003bf6803f624b7",
"doc_count": 96
},
{
"key": "018963e5f06f716dadb0fe95b3c53d22",
"doc_count": 48
},
{
"key": "01896412f51373c886fa6e0be85015e0",
"doc_count": 48
},
{
"key": "01896412f5b57107a5f77996ea62470b",
"doc_count": 48
},
{
"key": "01896412b5fc7191b412ee67da021b6b",
"doc_count": 24
},
{
"key": "01896412bfa4716da93b6941ae840e04",
"doc_count": 24
},
{
"key": "018963e5f32b703288aad57690802852",
"doc_count": 15
},
{
"key": "01896412f65d71c2a96142c4aae4b7ab",
"doc_count": 15
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "1cadc079599b4e0386adc59541691ef7",
"doc_count": 159
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|