| 1 |
13.09 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":"01899801bc2b71f3ba61c1d827454ee4"}}}},{"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": 10,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 89,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_all4team_product_1716336301",
"_id": "018df52adca172cf8c55981982c1145a",
"_score": null,
"_source": {
"autoIncrement": 1758175.0,
"id": "018df52adca172cf8c55981982c1145a"
},
"fields": {
"displayGroup": [
"d7ccbd8ae964c8a71e23e2e00478ab29"
]
},
"sort": [
8,
"018df52adca172cf8c55981982c1145a"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018df52c22a8708d9ae792b3ce798e69",
"_score": null,
"_source": {
"autoIncrement": 1758245.0,
"id": "018df52c22a8708d9ae792b3ce798e69"
},
"fields": {
"displayGroup": [
"e4fbc833b0156de3c56b3c0818bcc5bc"
]
},
"sort": [
1,
"018df52c22a8708d9ae792b3ce798e69"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0197e00a19d0721ab09cdf1979f66762",
"_score": null,
"_source": {
"autoIncrement": 1928603.0,
"id": "0197e00a19d0721ab09cdf1979f66762"
},
"fields": {
"displayGroup": [
"d021b5c96673d2911175e48bb8ed8b31"
]
},
"sort": [
1,
"0197e00a19d0721ab09cdf1979f66762"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018df52b2bcc73ad9099f343b63db3db",
"_score": null,
"_source": {
"autoIncrement": 1758187.0,
"id": "018df52b2bcc73ad9099f343b63db3db"
},
"fields": {
"displayGroup": [
"6662c8b6c95cb4fbdf97bf20beb160c1"
]
},
"sort": [
0,
"018df52b2bcc73ad9099f343b63db3db"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018df52c7c95729892688c0badc106fc",
"_score": null,
"_source": {
"autoIncrement": 1758255.0,
"id": "018df52c7c95729892688c0badc106fc"
},
"fields": {
"displayGroup": [
"484b692a8f33f3e0e65fee475ee45e46"
]
},
"sort": [
0,
"018df52c7c95729892688c0badc106fc"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018df52d6def720fbcfff465fce94182",
"_score": null,
"_source": {
"autoIncrement": 1758311.0,
"id": "018df52d6def720fbcfff465fce94182"
},
"fields": {
"displayGroup": [
"f778c1784192f5ba8fe5363fce5a3d9d"
]
},
"sort": [
0,
"018df52d6def720fbcfff465fce94182"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018df52dbaaa72c0ac7cf9af279be03e",
"_score": null,
"_source": {
"autoIncrement": 1758323.0,
"id": "018df52dbaaa72c0ac7cf9af279be03e"
},
"fields": {
"displayGroup": [
"222a2991833f9011b74e927a4a79c37f"
]
},
"sort": [
0,
"018df52dbaaa72c0ac7cf9af279be03e"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018e07329a2d7278bcc30cfc8cddca78",
"_score": null,
"_source": {
"autoIncrement": 1771531.0,
"id": "018e07329a2d7278bcc30cfc8cddca78"
},
"fields": {
"displayGroup": [
"962d482ea89c461ff09c75add253de12"
]
},
"sort": [
0,
"018e07329a2d7278bcc30cfc8cddca78"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018e07682655707ca70c6e883d10a14e",
"_score": null,
"_source": {
"autoIncrement": 1771622.0,
"id": "018e07682655707ca70c6e883d10a14e"
},
"fields": {
"displayGroup": [
"bee19a8a9d79c20b6b1fcea9f6554b1b"
]
},
"sort": [
0,
"018e07682655707ca70c6e883d10a14e"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018e07687f3671f8848db2b659e736c4",
"_score": null,
"_source": {
"autoIncrement": 1771647.0,
"id": "018e07687f3671f8848db2b659e736c4"
},
"fields": {
"displayGroup": [
"4a70ed1324605eb23072b6113408d943"
]
},
"sort": [
0,
"018e07687f3671f8848db2b659e736c4"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018e0769051e72968ca4a31c952870cc",
"_score": null,
"_source": {
"autoIncrement": 1771666.0,
"id": "018e0769051e72968ca4a31c952870cc"
},
"fields": {
"displayGroup": [
"6e4b8b7acae19c5c2ac8335575087f2e"
]
},
"sort": [
0,
"018e0769051e72968ca4a31c952870cc"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018e0769654a72af9fd0542101c6c2c4",
"_score": null,
"_source": {
"autoIncrement": 1771680.0,
"id": "018e0769654a72af9fd0542101c6c2c4"
},
"fields": {
"displayGroup": [
"80f14e3b3e75b73ca7336a7bf7074d07"
]
},
"sort": [
0,
"018e0769654a72af9fd0542101c6c2c4"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018e0e4555d172ac87d1218fb0e291a3",
"_score": null,
"_source": {
"autoIncrement": 1772858.0,
"id": "018e0e4555d172ac87d1218fb0e291a3"
},
"fields": {
"displayGroup": [
"210d2d752a465f4cc5e8e70c41f98832"
]
},
"sort": [
0,
"018e0e4555d172ac87d1218fb0e291a3"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0197dae3890a713e89a157c57009e464",
"_score": null,
"_source": {
"autoIncrement": 1928578.0,
"id": "0197dae3890a713e89a157c57009e464"
},
"fields": {
"displayGroup": [
"26fd77fbfddc353b477d0c4d1bacbef9"
]
},
"sort": [
0,
"0197dae3890a713e89a157c57009e464"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0197dae39ff8721896a2691d8aa180a1",
"_score": null,
"_source": {
"autoIncrement": 1928581.0,
"id": "0197dae39ff8721896a2691d8aa180a1"
},
"fields": {
"displayGroup": [
"1c05bac3973ddfd94a2bf84ec22f1e2a"
]
},
"sort": [
0,
"0197dae39ff8721896a2691d8aa180a1"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0197e009e9b97337b2a635c27cefd406",
"_score": null,
"_source": {
"autoIncrement": 1928587.0,
"id": "0197e009e9b97337b2a635c27cefd406"
},
"fields": {
"displayGroup": [
"6c25c4a67bd994b91e2c7eb74cfa19d8"
]
},
"sort": [
0,
"0197e009e9b97337b2a635c27cefd406"
]
}
]
},
"aggregations": {
"total-count": {
"value": 24
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
11.54 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":"01899801bc2b71f3ba61c1d827454ee4"}}}},{"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": 41,
"shipping-free": {
"value": 1.0,
"value_as_string": "true"
}
},
"rating-exists": {
"doc_count": 89,
"rating": {
"value": 0.0
}
},
"price": {
"count": 89,
"min": 9.99,
"max": 109.99,
"avg": 49.81370786516854,
"sum": 4433.42
},
"options": {
"doc_count": 174,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "88e37ca9c31b4575a7e4c105a1139281",
"doc_count": 21
},
{
"key": "018b804ff0b271d2b93aa6420d15ee34",
"doc_count": 17
},
{
"key": "018adf8a711a70afad0a81bf8c7b3b98",
"doc_count": 15
},
{
"key": "df41139ab42a4f0dbe2167afb103b833",
"doc_count": 15
},
{
"key": "63a3e4e3a8d0461ca937227647cbc474",
"doc_count": 14
},
{
"key": "018adf8a723571d9839924ed17dc4e6b",
"doc_count": 13
},
{
"key": "103c221ef5c547a6919548726a45adb7",
"doc_count": 10
},
{
"key": "6818490b3d264af396bf32b5c741cb18",
"doc_count": 9
},
{
"key": "bace55c509624d8ab8a0c4653bced477",
"doc_count": 9
},
{
"key": "018dd236a0e470439790fd435913b7e3",
"doc_count": 6
},
{
"key": "018faad1151073e889a05a67a45bd76b",
"doc_count": 6
},
{
"key": "f1c0d70c9b714c4cb27beb8f22273242",
"doc_count": 6
},
{
"key": "b26bb94349e2469ea3e048b8bd50a91d",
"doc_count": 5
},
{
"key": "018faad111e271a9be48ebf162f81ab3",
"doc_count": 4
},
{
"key": "01909197498b73ac985e7f60974daac7",
"doc_count": 4
},
{
"key": "3d0b11d1db0f48f7acb284976d0b45e0",
"doc_count": 4
},
{
"key": "018d12c962be72dbbb302d38c698c5c9",
"doc_count": 3
},
{
"key": "018d12c9639372bfbf20c93e53b8660c",
"doc_count": 3
},
{
"key": "018d12c9675b708582972579c7319d3a",
"doc_count": 3
},
{
"key": "20db184c1fdb49508a4ccd08b882a19f",
"doc_count": 3
},
{
"key": "5e2f46d53cb046f9a5f9736c372966f8",
"doc_count": 3
},
{
"key": "019091974a4a71abaab9a8af736c280e",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 342,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "018dcc3373f47133833772ee8dfc3fe4",
"doc_count": 45
},
{
"key": "018963e5f13871739bde1b0eb26bb21b",
"doc_count": 44
},
{
"key": "01896411e3af718192fb7f9ee45ad6fb",
"doc_count": 44
},
{
"key": "018963e5f53b7292b003bf6803f624b7",
"doc_count": 30
},
{
"key": "01896411e3007292bbf291a9837a8cc8",
"doc_count": 30
},
{
"key": "018963ea3aba7042895b047285c1402e",
"doc_count": 21
},
{
"key": "0189641292b27351b91fb77f36a06de0",
"doc_count": 21
},
{
"key": "018963ea42b173b9b3cd3a41bd427d81",
"doc_count": 15
},
{
"key": "01896411e11071498f66a862f5383700",
"doc_count": 15
},
{
"key": "018d1482fb0e73daaf4889ca1eae731c",
"doc_count": 15
},
{
"key": "018bbe14784470c69d83e088c5e66fb5",
"doc_count": 10
},
{
"key": "018bbe147d4870d1a3ef7b9a0e8f4342",
"doc_count": 10
},
{
"key": "018963ea3964707fbbfb35b2b8e8084b",
"doc_count": 9
},
{
"key": "01896412cac6713bae81910e60d1fa90",
"doc_count": 9
},
{
"key": "018f05be84b471aeace2286db6b10a9c",
"doc_count": 6
},
{
"key": "018e197a6c5272c1a2bb025af66bd101",
"doc_count": 5
},
{
"key": "018bbe14777c70d4969157204edbd72b",
"doc_count": 4
},
{
"key": "018bbe147b277057bf2b3330ba4243f4",
"doc_count": 4
},
{
"key": "018c1b62afa8710c908ab4134bbf7c6b",
"doc_count": 3
},
{
"key": "018bbe14735f7284ba6d5630b0de21d1",
"doc_count": 1
},
{
"key": "018e197a6ab571608035e143ba5b0408",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "57f85a1341f34ad284dc91714711a009",
"doc_count": 51
},
{
"key": "1cadc079599b4e0386adc59541691ef7",
"doc_count": 38
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|