| 1 |
16.70 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":"0198789c8613704f9894c88b8336896f"}}}},{"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": 12,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 39,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_all4team_product_1716336301",
"_id": "01987e6501ad72538479cf6362db28ed",
"_score": null,
"_source": {
"autoIncrement": 1929743.0,
"id": "01987e6501ad72538479cf6362db28ed"
},
"fields": {
"displayGroup": [
"4b280b16593773b4fb33fd6f67753d1d"
]
},
"sort": [
0,
"01987e6501ad72538479cf6362db28ed"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "019884b34cd37041bd72b4c673e5a010",
"_score": null,
"_source": {
"autoIncrement": 1929952.0,
"id": "019884b34cd37041bd72b4c673e5a010"
},
"fields": {
"displayGroup": [
"56e90460cc9357777be3905ae1015119"
]
},
"sort": [
0,
"019884b34cd37041bd72b4c673e5a010"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "019884b3951071739278abb03c20eb68",
"_score": null,
"_source": {
"autoIncrement": 1929956.0,
"id": "019884b3951071739278abb03c20eb68"
},
"fields": {
"displayGroup": [
"a9325b9b29ecdb14fc9eece71e46c402"
]
},
"sort": [
0,
"019884b3951071739278abb03c20eb68"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "019884b3ca507315ae054eb89bb45cae",
"_score": null,
"_source": {
"autoIncrement": 1929960.0,
"id": "019884b3ca507315ae054eb89bb45cae"
},
"fields": {
"displayGroup": [
"c97a551817bc762ae11d9e7708527ef4"
]
},
"sort": [
0,
"019884b3ca507315ae054eb89bb45cae"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "019884b5574f7380b8b5d859d5b5ba2b",
"_score": null,
"_source": {
"autoIncrement": 1929994.0,
"id": "019884b5574f7380b8b5d859d5b5ba2b"
},
"fields": {
"displayGroup": [
"6ede12248f378ecb721393525d261727"
]
},
"sort": [
0,
"019884b5574f7380b8b5d859d5b5ba2b"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "019884b58b0173939c8055e2b73ceb0c",
"_score": null,
"_source": {
"autoIncrement": 1929998.0,
"id": "019884b58b0173939c8055e2b73ceb0c"
},
"fields": {
"displayGroup": [
"3e2a888fda5dfda0feb4e04811580946"
]
},
"sort": [
0,
"019884b58b0173939c8055e2b73ceb0c"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "019884b5cb9a73aea71b42a80c1dcd50",
"_score": null,
"_source": {
"autoIncrement": 1930002.0,
"id": "019884b5cb9a73aea71b42a80c1dcd50"
},
"fields": {
"displayGroup": [
"5672a722cd12eba9e829416eaaf446d5"
]
},
"sort": [
0,
"019884b5cb9a73aea71b42a80c1dcd50"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "019884b7d57073e5a005d82d16393e90",
"_score": null,
"_source": {
"autoIncrement": 1930048.0,
"id": "019884b7d57073e5a005d82d16393e90"
},
"fields": {
"displayGroup": [
"d7886903bcf10889211b338800fa6183"
]
},
"sort": [
0,
"019884b7d57073e5a005d82d16393e90"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "019884b81ea170c982ccce5cd8d917e4",
"_score": null,
"_source": {
"autoIncrement": 1930052.0,
"id": "019884b81ea170c982ccce5cd8d917e4"
},
"fields": {
"displayGroup": [
"857bd2225e99eb138285416d0d011bfa"
]
},
"sort": [
0,
"019884b81ea170c982ccce5cd8d917e4"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "019884b84ed8712fbfc38403b41d6865",
"_score": null,
"_source": {
"autoIncrement": 1930056.0,
"id": "019884b84ed8712fbfc38403b41d6865"
},
"fields": {
"displayGroup": [
"f4b496d7647c60b7f319f157660259e0"
]
},
"sort": [
0,
"019884b84ed8712fbfc38403b41d6865"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "019884b9951a7396af072e25adb17154",
"_score": null,
"_source": {
"autoIncrement": 1930090.0,
"id": "019884b9951a7396af072e25adb17154"
},
"fields": {
"displayGroup": [
"78f9f2e5867a91cf721c615381bcea26"
]
},
"sort": [
0,
"019884b9951a7396af072e25adb17154"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "019884b9e45572f682077f51284fda54",
"_score": null,
"_source": {
"autoIncrement": 1930094.0,
"id": "019884b9e45572f682077f51284fda54"
},
"fields": {
"displayGroup": [
"b1bc1efdc269467506c902129c27e915"
]
},
"sort": [
0,
"019884b9e45572f682077f51284fda54"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "019884ba1b5f71f7b5175a1f30942d42",
"_score": null,
"_source": {
"autoIncrement": 1930098.0,
"id": "019884ba1b5f71f7b5175a1f30942d42"
},
"fields": {
"displayGroup": [
"b60f57d92ac06b2f20a6f32dc5365e4a"
]
},
"sort": [
0,
"019884ba1b5f71f7b5175a1f30942d42"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "019884bc59bf73b59c239067c2fe391f",
"_score": null,
"_source": {
"autoIncrement": 1930144.0,
"id": "019884bc59bf73b59c239067c2fe391f"
},
"fields": {
"displayGroup": [
"52621598c81b497084a2cc3b96daf1bd"
]
},
"sort": [
0,
"019884bc59bf73b59c239067c2fe391f"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "019884bc9e5a7181be3f7f3ca19159fa",
"_score": null,
"_source": {
"autoIncrement": 1930148.0,
"id": "019884bc9e5a7181be3f7f3ca19159fa"
},
"fields": {
"displayGroup": [
"ea1cc05b44aba8921dcb79e0e7f73f3f"
]
},
"sort": [
0,
"019884bc9e5a7181be3f7f3ca19159fa"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "019884bcfe0f702ba458f5049daaac06",
"_score": null,
"_source": {
"autoIncrement": 1930152.0,
"id": "019884bcfe0f702ba458f5049daaac06"
},
"fields": {
"displayGroup": [
"d710534e673d08f44bcf9f964c128e88"
]
},
"sort": [
0,
"019884bcfe0f702ba458f5049daaac06"
]
}
]
},
"aggregations": {
"total-count": {
"value": 23
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
8.53 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":"0198789c8613704f9894c88b8336896f"}}}},{"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": 6,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"max_score": null,
"hits": []
},
"aggregations": {
"shipping-free-filter": {
"doc_count": 39,
"shipping-free": {
"value": 1.0,
"value_as_string": "true"
}
},
"rating-exists": {
"doc_count": 39,
"rating": {
"value": 0.0
}
},
"price": {
"count": 39,
"min": 16.95,
"max": 64.95,
"avg": 38.33461538461539,
"sum": 1495.0500000000002
},
"options": {
"doc_count": 78,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "019884b0e71373478ad485f412407f0d",
"doc_count": 11
},
{
"key": "019884b0f67e7322aa058e21c6ea68d1",
"doc_count": 11
},
{
"key": "019884b0fcb5719eaa77b33e86ddb9ec",
"doc_count": 11
},
{
"key": "507f2e527d524e359c477d74d4605b1f",
"doc_count": 10
},
{
"key": "b26bb94349e2469ea3e048b8bd50a91d",
"doc_count": 9
},
{
"key": "019884b0ec6e704a8799be8e73cd09d1",
"doc_count": 5
},
{
"key": "20db184c1fdb49508a4ccd08b882a19f",
"doc_count": 4
},
{
"key": "37347e78acc44de0a2b07896ba5339c0",
"doc_count": 4
},
{
"key": "5e2f46d53cb046f9a5f9736c372966f8",
"doc_count": 4
},
{
"key": "60de90a916684ef696e8ba9bd8060cbc",
"doc_count": 4
},
{
"key": "103c221ef5c547a6919548726a45adb7",
"doc_count": 3
},
{
"key": "018d8d99155e7336a9357a529a6954fc",
"doc_count": 1
},
{
"key": "1e92aef1f53246c0900d612091414458",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 144,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "01896411e05c71f4af78a5552a40b626",
"doc_count": 38
},
{
"key": "018963e5f5e173a4afde33792d6fe12f",
"doc_count": 20
},
{
"key": "018963ea1812737fb7f416641565cd24",
"doc_count": 15
},
{
"key": "01896412f46a7164bc08cd3d2a5052cc",
"doc_count": 10
},
{
"key": "018963ea415c7217b4dc8cb62572ed16",
"doc_count": 9
},
{
"key": "018963e5f32b703288aad57690802852",
"doc_count": 7
},
{
"key": "018bbe1479bd7172a96f8a7ec65759d6",
"doc_count": 7
},
{
"key": "018963e5f06f716dadb0fe95b3c53d22",
"doc_count": 6
},
{
"key": "018963e5f13871739bde1b0eb26bb21b",
"doc_count": 6
},
{
"key": "01896412db2e715281560944e033a329",
"doc_count": 5
},
{
"key": "018bbe14740a71fd876c07cbfdd9fd4f",
"doc_count": 4
},
{
"key": "018963ea24c172519a11176e570bcae4",
"doc_count": 3
},
{
"key": "01896412f51373c886fa6e0be85015e0",
"doc_count": 3
},
{
"key": "01896412f5b57107a5f77996ea62470b",
"doc_count": 3
},
{
"key": "01896412f65d71c2a96142c4aae4b7ab",
"doc_count": 3
},
{
"key": "018964129997706eb79198e148c59e0b",
"doc_count": 2
},
{
"key": "01896411e25971f98272a565102c3faf",
"doc_count": 1
},
{
"key": "01896412f3be73e9b9f7c1618b09e578",
"doc_count": 1
},
{
"key": "018bbe14784470c69d83e088c5e66fb5",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "1a0ffc50b3584a1abd28c2d06d6c6465",
"doc_count": 39
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|