| 1 |
13.17 ms |
Request:
{"index":"sw_dynatech_stage_product","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":"e44e3135bad64cfdbb2692c44137b1f8"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"4479e664066fed119d20005056be7e8d"}}}},{"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":24,"collapse":{"field":"displayGroup"},"timeout":"5s"}}
{
"took": 2,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 30,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "15272544b069ed119d20005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 79961.0,
"id": "15272544b069ed119d20005056be7e8d"
},
"fields": {
"displayGroup": [
"258e260d05b66421dceabc238ccb9f79"
]
},
"sort": [
0,
"15272544b069ed119d20005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "3c5f5a10bda7ed119d24005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 79952.0,
"id": "3c5f5a10bda7ed119d24005056be7e8d"
},
"fields": {
"displayGroup": [
"1a4e2ee2f66e889b964b3f8188cfe598"
]
},
"sort": [
0,
"3c5f5a10bda7ed119d24005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "4a272544b069ed119d20005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 79963.0,
"id": "4a272544b069ed119d20005056be7e8d"
},
"fields": {
"displayGroup": [
"a7e660ba05237aaa2942d1d305c52463"
]
},
"sort": [
0,
"4a272544b069ed119d20005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "4f232544b069ed119d20005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 79942.0,
"id": "4f232544b069ed119d20005056be7e8d"
},
"fields": {
"displayGroup": [
"79063b2a3d984fb67fe47fc1dfdb86f9"
]
},
"sort": [
0,
"4f232544b069ed119d20005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "52222544b069ed119d20005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 79970.0,
"id": "52222544b069ed119d20005056be7e8d"
},
"fields": {
"displayGroup": [
"5ab0557f29fa754c2a3b406c17cc7244"
]
},
"sort": [
0,
"52222544b069ed119d20005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "53262544b069ed119d20005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 79959.0,
"id": "53262544b069ed119d20005056be7e8d"
},
"fields": {
"displayGroup": [
"efee511f65bf689a502af7b42d959758"
]
},
"sort": [
0,
"53262544b069ed119d20005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "62212544b069ed119d20005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 79953.0,
"id": "62212544b069ed119d20005056be7e8d"
},
"fields": {
"displayGroup": [
"fffb17300c0bc74188d98ffcc11d5842"
]
},
"sort": [
0,
"62212544b069ed119d20005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "63687329e117ed119d1b005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 79987.0,
"id": "63687329e117ed119d1b005056be7e8d"
},
"fields": {
"displayGroup": [
"9a22329bef8be2dc67af4da8528630c2"
]
},
"sort": [
0,
"63687329e117ed119d1b005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "66687329e117ed119d1b005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 79986.0,
"id": "66687329e117ed119d1b005056be7e8d"
},
"fields": {
"displayGroup": [
"9f61af5c4e3d339af88b57e15b6dc592"
]
},
"sort": [
0,
"66687329e117ed119d1b005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "69687329e117ed119d1b005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 79989.0,
"id": "69687329e117ed119d1b005056be7e8d"
},
"fields": {
"displayGroup": [
"df12037427992636ed93505ca3644275"
]
},
"sort": [
0,
"69687329e117ed119d1b005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "710e076ce117ed119d1b005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 79964.0,
"id": "710e076ce117ed119d1b005056be7e8d"
},
"fields": {
"displayGroup": [
"6c381f4217bce1a963a4d97b2bc14fc7"
]
},
"sort": [
0,
"710e076ce117ed119d1b005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "740e076ce117ed119d1b005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 79966.0,
"id": "740e076ce117ed119d1b005056be7e8d"
},
"fields": {
"displayGroup": [
"cbb2438774736fad733b7ed0b84849d7"
]
},
"sort": [
0,
"740e076ce117ed119d1b005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "76687329e117ed119d1b005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 79969.0,
"id": "76687329e117ed119d1b005056be7e8d"
},
"fields": {
"displayGroup": [
"0bdc187c452e121985e184dc575000f8"
]
},
"sort": [
0,
"76687329e117ed119d1b005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "791f2544b069ed119d20005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 79988.0,
"id": "791f2544b069ed119d20005056be7e8d"
},
"fields": {
"displayGroup": [
"af72a28a5f72126d6a165f0b858e6054"
]
},
"sort": [
0,
"791f2544b069ed119d20005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "7c687329e117ed119d1b005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 79965.0,
"id": "7c687329e117ed119d1b005056be7e8d"
},
"fields": {
"displayGroup": [
"2598cd0e0ea6e877e3ea5b1f19ec56b5"
]
},
"sort": [
0,
"7c687329e117ed119d1b005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "7f687329e117ed119d1b005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 79951.0,
"id": "7f687329e117ed119d1b005056be7e8d"
},
"fields": {
"displayGroup": [
"601b6766317546d6ed506cfe6870825d"
]
},
"sort": [
0,
"7f687329e117ed119d1b005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "89282544b069ed119d20005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 79971.0,
"id": "89282544b069ed119d20005056be7e8d"
},
"fields": {
"displayGroup": [
"df1f6c2b5bb29a61fc0f1894c37eef6c"
]
},
"sort": [
0,
"89282544b069ed119d20005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "8f1f2544b069ed119d20005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 79990.0,
"id": "8f1f2544b069ed119d20005056be7e8d"
},
"fields": {
"displayGroup": [
"d62e62c73a05bcb6378aa5cd2b09495d"
]
},
"sort": [
0,
"8f1f2544b069ed119d20005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "98384fb6cf82ed119d24005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 80230.0,
"id": "98384fb6cf82ed119d24005056be7e8d"
},
"fields": {
"displayGroup": [
"1daa95ae3d43f45542b672e3f733ffd0"
]
},
"sort": [
0,
"98384fb6cf82ed119d24005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "a9262544b069ed119d20005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 79955.0,
"id": "a9262544b069ed119d20005056be7e8d"
},
"fields": {
"displayGroup": [
"ab94653297bec163427a14a8ab56a787"
]
},
"sort": [
0,
"a9262544b069ed119d20005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "ab282544b069ed119d20005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 79972.0,
"id": "ab282544b069ed119d20005056be7e8d"
},
"fields": {
"displayGroup": [
"c39c1754f32de39a5ade86782e8dc7cd"
]
},
"sort": [
0,
"ab282544b069ed119d20005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "b9232544b069ed119d20005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 79967.0,
"id": "b9232544b069ed119d20005056be7e8d"
},
"fields": {
"displayGroup": [
"aa64a5dc4fd039a7c5df3fbb925cc8d9"
]
},
"sort": [
0,
"b9232544b069ed119d20005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "be212544b069ed119d20005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 79954.0,
"id": "be212544b069ed119d20005056be7e8d"
},
"fields": {
"displayGroup": [
"99abeadc8ccac975fbd7b80e35f801f2"
]
},
"sort": [
0,
"be212544b069ed119d20005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "cc262544b069ed119d20005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 79958.0,
"id": "cc262544b069ed119d20005056be7e8d"
},
"fields": {
"displayGroup": [
"c7945e7830c2776692824a2f9f42a1fd"
]
},
"sort": [
0,
"cc262544b069ed119d20005056be7e8d"
]
}
]
},
"aggregations": {
"total-count": {
"value": 25
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
3.01 ms |
Request:
{"index":"sw_dynatech_stage_product","body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"e44e3135bad64cfdbb2692c44137b1f8"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"4479e664066fed119d20005056be7e8d"}}}},{"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_rule5c32fac6673c4039bea532a4fca661bc_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule1613c223e713444fb2988facaa205ac8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule27be522dd6d4460fa6b791aa5465f7f6_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule940de70791ec42058cf818a76f1886cc_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulee1378db7808a478f919e0d740d5d6c1a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule9c50af116cde47e382f76cd42936aa7a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulede8790e0706642629ad3666a11236b4f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulef5d643666ba54df8b46053010648ec3b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule3cf541369e6d4a2fa70aa8687a65fc2d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulef2bf4b7598914040bfec0097b338f904_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule0197c6484fd772d8aafe175706f6ee20_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule075b9083116346b8ba2bbd2b50521c3b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule1bc496fd2c2143f8b1fa6bf188c20fbb_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule9fd19d91b9d34cbc90a7b56b338efd9e_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"}}
{
"took": 1,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 30,
"relation": "eq"
},
"max_score": null,
"hits": []
},
"aggregations": {
"shipping-free-filter": {
"doc_count": 0,
"shipping-free": {
"value": null
}
},
"rating-exists": {
"doc_count": 30,
"rating": {
"value": 0.0
}
},
"price": {
"count": 30,
"min": 2.95,
"max": 184.45,
"avg": 31.279,
"sum": 938.37
},
"options": {
"doc_count": 7,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "5b90080ed777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "9390080ed777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "9590080ed777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "6390080ed777ed119d24005056be7e8d",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 86,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "6090080ed777ed119d24005056be7e8d",
"doc_count": 6
},
{
"key": "9890080ed777ed119d24005056be7e8d",
"doc_count": 6
},
{
"key": "383b0214d777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "423b0214d777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "453b0214d777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "5b90080ed777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "5d3b0214d777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "7b3b0214d777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "873a0214d777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "8c9c080ed777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "8f3b0214d777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "9390080ed777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "953b0214d777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "9590080ed777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "b421a358067aed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "b495080ed777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "b790080ed777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "b9646e4afe79ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "da3b0214d777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "e73b0214d777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "033c0214d777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "15666e4afe79ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "37460aa803b9ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "3a3b0214d777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "4c3b0214d777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "4f686e4afe79ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "543b0214d777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "593b0214d777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "6390080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "6594080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "693b0214d777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "6b2744042b02ef119d28005056be7e8d",
"doc_count": 1
},
{
"key": "75fdf6228babed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "853b0214d777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "8ab667742b02ef119d28005056be7e8d",
"doc_count": 1
},
{
"key": "8c3b0214d777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "8d3b0214d777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "923b0214d777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "983b0214d777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "993b0214d777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "9b3b0214d777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "9d3b0214d777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "9d90080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "a43b0214d777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "b021a358067aed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "c395080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "d54e08a147aced119d24005056be7e8d",
"doc_count": 1
},
{
"key": "d695080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "d793080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "d895080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "dd3b0214d777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "e6646e4afe79ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "ed646e4afe79ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "f0646e4afe79ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "f5646e4afe79ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "f83a0214d777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "fd3b0214d777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "fea99bb347aced119d24005056be7e8d",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "9bc3b72dde24ec119d1a005056be7e8d",
"doc_count": 30
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|