| 1 |
16.49 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":"04e3f819fb6eed119d20005056be7e8d"}}}},{"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": 35,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "222910fb5f88ee119d28005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 80242.0,
"id": "222910fb5f88ee119d28005056be7e8d"
},
"fields": {
"displayGroup": [
"e960d763495c29cc1a2072af6165377d"
]
},
"sort": [
0,
"222910fb5f88ee119d28005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "2e140d09e017ed119d1b005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 79511.0,
"id": "2e140d09e017ed119d1b005056be7e8d"
},
"fields": {
"displayGroup": [
"d19ff7dd6a8eb2c4ff47c68f9eae07a6"
]
},
"sort": [
0,
"2e140d09e017ed119d1b005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "50865e14b069ed119d20005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 80175.0,
"id": "50865e14b069ed119d20005056be7e8d"
},
"fields": {
"displayGroup": [
"932f3004250e66612f20cd20c96f3f0c"
]
},
"sort": [
0,
"50865e14b069ed119d20005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "6d2c75ca39f6ee119d28005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 79589.0,
"id": "6d2c75ca39f6ee119d28005056be7e8d"
},
"fields": {
"displayGroup": [
"3aec7c778aaf525f4815d3db3692ad18"
]
},
"sort": [
0,
"6d2c75ca39f6ee119d28005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "7ecb01ecb169ed119d20005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 79409.0,
"id": "7ecb01ecb169ed119d20005056be7e8d"
},
"fields": {
"displayGroup": [
"78939c5ca936e3f0d7d0b25d330efd87"
]
},
"sort": [
0,
"7ecb01ecb169ed119d20005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "90289bdd7deaee119d28005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 79946.0,
"id": "90289bdd7deaee119d28005056be7e8d"
},
"fields": {
"displayGroup": [
"cd9af2aa8cc4edc344518ba57624cc4f"
]
},
"sort": [
0,
"90289bdd7deaee119d28005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "b4cb01ecb169ed119d20005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 79412.0,
"id": "b4cb01ecb169ed119d20005056be7e8d"
},
"fields": {
"displayGroup": [
"8a688f7d2e228a3cf75ab370fc6d80a3"
]
},
"sort": [
0,
"b4cb01ecb169ed119d20005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "c1949bafb069ed119d20005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 80126.0,
"id": "c1949bafb069ed119d20005056be7e8d"
},
"fields": {
"displayGroup": [
"9ad573cca70dc6e7d36bfc894a8a3354"
]
},
"sort": [
0,
"c1949bafb069ed119d20005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "c1e467928cdaed119d27005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 79509.0,
"id": "c1e467928cdaed119d27005056be7e8d"
},
"fields": {
"displayGroup": [
"5c7248001821bf74c6d82dc71f369753"
]
},
"sort": [
0,
"c1e467928cdaed119d27005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "d3949bafb069ed119d20005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 80127.0,
"id": "d3949bafb069ed119d20005056be7e8d"
},
"fields": {
"displayGroup": [
"99f31ea4d72ab33e443d26f2113f2368"
]
},
"sort": [
0,
"d3949bafb069ed119d20005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "d4f4af4039aded119d24005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 79508.0,
"id": "d4f4af4039aded119d24005056be7e8d"
},
"fields": {
"displayGroup": [
"bc1d951184f601c37eaa531e21ebec3c"
]
},
"sort": [
0,
"d4f4af4039aded119d24005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "f1fcd936251cef119d29005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 80205.0,
"id": "f1fcd936251cef119d29005056be7e8d"
},
"fields": {
"displayGroup": [
"f1a9a13e849a0bce20acc31110d6a844"
]
},
"sort": [
0,
"f1fcd936251cef119d29005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "f6949bafb069ed119d20005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 80128.0,
"id": "f6949bafb069ed119d20005056be7e8d"
},
"fields": {
"displayGroup": [
"a05964308c7fdaf4b7c47bf38f2c3fd1"
]
},
"sort": [
0,
"f6949bafb069ed119d20005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "ff60c051de24ec119d1a005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 79476.0,
"id": "ff60c051de24ec119d1a005056be7e8d"
},
"fields": {
"displayGroup": [
"d774dc8a9b757f7d640d6904db22f4fd"
]
},
"sort": [
0,
"ff60c051de24ec119d1a005056be7e8d"
]
}
]
},
"aggregations": {
"total-count": {
"value": 14
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
3.42 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":"04e3f819fb6eed119d20005056be7e8d"}}}},{"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": 2,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 35,
"relation": "eq"
},
"max_score": null,
"hits": []
},
"aggregations": {
"shipping-free-filter": {
"doc_count": 0,
"shipping-free": {
"value": null
}
},
"rating-exists": {
"doc_count": 35,
"rating": {
"value": 0.0
}
},
"price": {
"count": 35,
"min": 3.95,
"max": 792.0,
"avg": 379.134,
"sum": 13269.69
},
"options": {
"doc_count": 67,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "7f15b450244bee119d28005056be7e8d",
"doc_count": 8
},
{
"key": "c79b080ed777ed119d24005056be7e8d",
"doc_count": 7
},
{
"key": "e3c94ca02589ee119d28005056be7e8d",
"doc_count": 7
},
{
"key": "44973a922589ee119d28005056be7e8d",
"doc_count": 5
},
{
"key": "624a3ba095f5ee119d28005056be7e8d",
"doc_count": 4
},
{
"key": "64aae8c1fe79ed119d24005056be7e8d",
"doc_count": 4
},
{
"key": "9d90080ed777ed119d24005056be7e8d",
"doc_count": 4
},
{
"key": "a21e7971144bee119d28005056be7e8d",
"doc_count": 4
},
{
"key": "a31e7971144bee119d28005056be7e8d",
"doc_count": 4
},
{
"key": "235e9a3a2589ee119d28005056be7e8d",
"doc_count": 3
},
{
"key": "279c080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "53abf254128dee119d28005056be7e8d",
"doc_count": 3
},
{
"key": "15a66ebc35f7ee119d28005056be7e8d",
"doc_count": 2
},
{
"key": "15e1edae118dee119d28005056be7e8d",
"doc_count": 2
},
{
"key": "589a2195128dee119d28005056be7e8d",
"doc_count": 2
},
{
"key": "a0abefa7ff4bee119d28005056be7e8d",
"doc_count": 2
},
{
"key": "f798a79dff4bee119d28005056be7e8d",
"doc_count": 2
},
{
"key": "ee017c3efe79ed119d24005056be7e8d",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 373,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "2591080ed777ed119d24005056be7e8d",
"doc_count": 14
},
{
"key": "279c080ed777ed119d24005056be7e8d",
"doc_count": 12
},
{
"key": "079c080ed777ed119d24005056be7e8d",
"doc_count": 10
},
{
"key": "091c8aff2589ee119d28005056be7e8d",
"doc_count": 9
},
{
"key": "5b330b2a2889ee119d28005056be7e8d",
"doc_count": 9
},
{
"key": "649b66002589ee119d28005056be7e8d",
"doc_count": 9
},
{
"key": "6f91080ed777ed119d24005056be7e8d",
"doc_count": 9
},
{
"key": "757835172789ee119d28005056be7e8d",
"doc_count": 9
},
{
"key": "7f219c632889ee119d28005056be7e8d",
"doc_count": 9
},
{
"key": "9bfd479d2789ee119d28005056be7e8d",
"doc_count": 9
},
{
"key": "ac9e3ade2489ee119d28005056be7e8d",
"doc_count": 9
},
{
"key": "aea258512789ee119d28005056be7e8d",
"doc_count": 9
},
{
"key": "ba740b132689ee119d28005056be7e8d",
"doc_count": 9
},
{
"key": "bafd103c2889ee119d28005056be7e8d",
"doc_count": 9
},
{
"key": "bec4ed4a2589ee119d28005056be7e8d",
"doc_count": 9
},
{
"key": "cf9b080ed777ed119d24005056be7e8d",
"doc_count": 9
},
{
"key": "e59b080ed777ed119d24005056be7e8d",
"doc_count": 9
},
{
"key": "eaa7c2442689ee119d28005056be7e8d",
"doc_count": 9
},
{
"key": "ecacf4c72489ee119d28005056be7e8d",
"doc_count": 9
},
{
"key": "ed6d37752589ee119d28005056be7e8d",
"doc_count": 9
},
{
"key": "f4dbd86c2789ee119d28005056be7e8d",
"doc_count": 9
},
{
"key": "2ccf8c032889ee119d28005056be7e8d",
"doc_count": 8
},
{
"key": "7f15b450244bee119d28005056be7e8d",
"doc_count": 8
},
{
"key": "8a79ef9f2689ee119d28005056be7e8d",
"doc_count": 8
},
{
"key": "c79b080ed777ed119d24005056be7e8d",
"doc_count": 7
},
{
"key": "e3c94ca02589ee119d28005056be7e8d",
"doc_count": 7
},
{
"key": "44973a922589ee119d28005056be7e8d",
"doc_count": 5
},
{
"key": "64aae8c1fe79ed119d24005056be7e8d",
"doc_count": 5
},
{
"key": "2891080ed777ed119d24005056be7e8d",
"doc_count": 4
},
{
"key": "624a3ba095f5ee119d28005056be7e8d",
"doc_count": 4
},
{
"key": "9d90080ed777ed119d24005056be7e8d",
"doc_count": 4
},
{
"key": "a21e7971144bee119d28005056be7e8d",
"doc_count": 4
},
{
"key": "a31e7971144bee119d28005056be7e8d",
"doc_count": 4
},
{
"key": "ee017c3efe79ed119d24005056be7e8d",
"doc_count": 4
},
{
"key": "05a6080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "09a6080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "0ca6080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "11a6080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "19a6080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "1da6080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "235e9a3a2589ee119d28005056be7e8d",
"doc_count": 3
},
{
"key": "41a6080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "53abf254128dee119d28005056be7e8d",
"doc_count": 3
},
{
"key": "589a2195128dee119d28005056be7e8d",
"doc_count": 3
},
{
"key": "9ea5080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "aba5080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "b6a5080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "d041fe9e154bee119d28005056be7e8d",
"doc_count": 3
},
{
"key": "f3636e4afe79ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "15a66ebc35f7ee119d28005056be7e8d",
"doc_count": 2
},
{
"key": "15e1edae118dee119d28005056be7e8d",
"doc_count": 2
},
{
"key": "6671d220f0f0ee119d28005056be7e8d",
"doc_count": 2
},
{
"key": "8f8f4768fe79ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "95528a6c264bee119d28005056be7e8d",
"doc_count": 2
},
{
"key": "a0307503f0f0ee119d28005056be7e8d",
"doc_count": 2
},
{
"key": "a0abefa7ff4bee119d28005056be7e8d",
"doc_count": 2
},
{
"key": "f798a79dff4bee119d28005056be7e8d",
"doc_count": 2
},
{
"key": "0092080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "011e759d148dee119d28005056be7e8d",
"doc_count": 1
},
{
"key": "1ba2080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "1f0cf59fa0eaee119d28005056be7e8d",
"doc_count": 1
},
{
"key": "2725bd85154bee119d28005056be7e8d",
"doc_count": 1
},
{
"key": "2860f4fd144bee119d28005056be7e8d",
"doc_count": 1
},
{
"key": "3dfc14f5828fee119d28005056be7e8d",
"doc_count": 1
},
{
"key": "3e6669f2244bee119d28005056be7e8d",
"doc_count": 1
},
{
"key": "43335c649eeaee119d28005056be7e8d",
"doc_count": 1
},
{
"key": "4c460082184bee119d28005056be7e8d",
"doc_count": 1
},
{
"key": "5597cc4a174bee119d28005056be7e8d",
"doc_count": 1
},
{
"key": "5c1e77fea1eaee119d28005056be7e8d",
"doc_count": 1
},
{
"key": "5eb82eb2154bee119d28005056be7e8d",
"doc_count": 1
},
{
"key": "629ff8bd9eeaee119d28005056be7e8d",
"doc_count": 1
},
{
"key": "705062ad011cef119d29005056be7e8d",
"doc_count": 1
},
{
"key": "7091080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "70f7a1e45bbcee119d28005056be7e8d",
"doc_count": 1
},
{
"key": "7d29362aa0eaee119d28005056be7e8d",
"doc_count": 1
},
{
"key": "8441d4fa148dee119d28005056be7e8d",
"doc_count": 1
},
{
"key": "84f413c0011cef119d29005056be7e8d",
"doc_count": 1
},
{
"key": "86e1d47ca0eaee119d28005056be7e8d",
"doc_count": 1
},
{
"key": "97d4dbbaa0eaee119d28005056be7e8d",
"doc_count": 1
},
{
"key": "9cf7962d9eeaee119d28005056be7e8d",
"doc_count": 1
},
{
"key": "9ef81717a1eaee119d28005056be7e8d",
"doc_count": 1
},
{
"key": "a390080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "a890080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "aa90080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "bd9b080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "be6e97d0011cef119d29005056be7e8d",
"doc_count": 1
},
{
"key": "c8c14356a0eaee119d28005056be7e8d",
"doc_count": 1
},
{
"key": "ccc1a93fa0eaee119d28005056be7e8d",
"doc_count": 1
},
{
"key": "d3a5080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "d8a5080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "d9150920195dee119d28005056be7e8d",
"doc_count": 1
},
{
"key": "d91789fe174bee119d28005056be7e8d",
"doc_count": 1
},
{
"key": "d99b080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "dce9f947a0eaee119d28005056be7e8d",
"doc_count": 1
},
{
"key": "dd9a4f74154bee119d28005056be7e8d",
"doc_count": 1
},
{
"key": "e39b080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "e3a5080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "f79b080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "ff32bdd5154bee119d28005056be7e8d",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "9ac4b72dde24ec119d1a005056be7e8d",
"doc_count": 14
},
{
"key": "7dc3b72dde24ec119d1a005056be7e8d",
"doc_count": 10
},
{
"key": "b9c4b72dde24ec119d1a005056be7e8d",
"doc_count": 4
},
{
"key": "e5c3b72dde24ec119d1a005056be7e8d",
"doc_count": 3
},
{
"key": "78c3b72dde24ec119d1a005056be7e8d",
"doc_count": 1
},
{
"key": "8e1579d7001cef119d29005056be7e8d",
"doc_count": 1
},
{
"key": "c2c3b72dde24ec119d1a005056be7e8d",
"doc_count": 1
},
{
"key": "c7c4b72dde24ec119d1a005056be7e8d",
"doc_count": 1
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|