| 1 |
17.12 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":"98b6b465186fed119d20005056be7e8d"}}}},{"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": 23,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "064bbd57de24ec119d1a005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 80211.0,
"id": "064bbd57de24ec119d1a005056be7e8d"
},
"fields": {
"displayGroup": [
"043228bf182e219a822c2a8c7d9a53d8"
]
},
"sort": [
0,
"064bbd57de24ec119d1a005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "0761c051de24ec119d1a005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 80052.0,
"id": "0761c051de24ec119d1a005056be7e8d"
},
"fields": {
"displayGroup": [
"2365788c2c988fc8ca035ce90780e9a4"
]
},
"sort": [
0,
"0761c051de24ec119d1a005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "0961c051de24ec119d1a005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 80056.0,
"id": "0961c051de24ec119d1a005056be7e8d"
},
"fields": {
"displayGroup": [
"92d0e7b8f67b107e2b14dbebc9404930"
]
},
"sort": [
0,
"0961c051de24ec119d1a005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "0d61c051de24ec119d1a005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 80060.0,
"id": "0d61c051de24ec119d1a005056be7e8d"
},
"fields": {
"displayGroup": [
"a414c3538a6171b4fcb5e105125c2aee"
]
},
"sort": [
0,
"0d61c051de24ec119d1a005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "11153538b069ed119d20005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 80077.0,
"id": "11153538b069ed119d20005056be7e8d"
},
"fields": {
"displayGroup": [
"38d492bd76030df7332741066ea974e4"
]
},
"sort": [
0,
"11153538b069ed119d20005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "144bbd57de24ec119d1a005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 79361.0,
"id": "144bbd57de24ec119d1a005056be7e8d"
},
"fields": {
"displayGroup": [
"e11f4fef3b99e7ea436ad6bead34d31a"
]
},
"sort": [
0,
"144bbd57de24ec119d1a005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "1b7b2c3eb069ed119d20005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 80071.0,
"id": "1b7b2c3eb069ed119d20005056be7e8d"
},
"fields": {
"displayGroup": [
"6208c59e292843a0e72db38cc38e959b"
]
},
"sort": [
0,
"1b7b2c3eb069ed119d20005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "237d2c3eb069ed119d20005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 80069.0,
"id": "237d2c3eb069ed119d20005056be7e8d"
},
"fields": {
"displayGroup": [
"5300eeb2f03c1d35285aebc0a15afa1a"
]
},
"sort": [
0,
"237d2c3eb069ed119d20005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "27193538b069ed119d20005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 80116.0,
"id": "27193538b069ed119d20005056be7e8d"
},
"fields": {
"displayGroup": [
"c3404e91aa8b783325f90f047ea08e0b"
]
},
"sort": [
0,
"27193538b069ed119d20005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "2c43b00ddac0ee119d28005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 79406.0,
"id": "2c43b00ddac0ee119d28005056be7e8d"
},
"fields": {
"displayGroup": [
"250513fa14cb5417a553b33fc9a4f990"
]
},
"sort": [
0,
"2c43b00ddac0ee119d28005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "35e6f2f7b169ed119d20005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 80103.0,
"id": "35e6f2f7b169ed119d20005056be7e8d"
},
"fields": {
"displayGroup": [
"a7e2a3cf32c0894dbe50bb3a9d471040"
]
},
"sort": [
0,
"35e6f2f7b169ed119d20005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "400cda73fd17ed119d1b005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 79892.0,
"id": "400cda73fd17ed119d1b005056be7e8d"
},
"fields": {
"displayGroup": [
"37f4046a3336021ad83f209bf1e561ca"
]
},
"sort": [
0,
"400cda73fd17ed119d1b005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "5e7d6b7a4001ef119d28005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 80186.0,
"id": "5e7d6b7a4001ef119d28005056be7e8d"
},
"fields": {
"displayGroup": [
"4eadc8dcb3c669c52c3cc8e3f7672698"
]
},
"sort": [
0,
"5e7d6b7a4001ef119d28005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "6d4d5ab02250ef119d29005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 80246.0,
"id": "6d4d5ab02250ef119d29005056be7e8d"
},
"fields": {
"displayGroup": [
"4789d7fc065a8f33e34f7d2bb5476497"
]
},
"sort": [
0,
"6d4d5ab02250ef119d29005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "994c32c8b169ed119d20005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 80163.0,
"id": "994c32c8b169ed119d20005056be7e8d"
},
"fields": {
"displayGroup": [
"7a7ace2a2bc2fa6a74a33c16db2b754a"
]
},
"sort": [
0,
"994c32c8b169ed119d20005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "ab4c32c8b169ed119d20005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 80161.0,
"id": "ab4c32c8b169ed119d20005056be7e8d"
},
"fields": {
"displayGroup": [
"ca884723ba8f1a4768851e1dfce9d38a"
]
},
"sort": [
0,
"ab4c32c8b169ed119d20005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "bf6fb463de24ec119d1a005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 80104.0,
"id": "bf6fb463de24ec119d1a005056be7e8d"
},
"fields": {
"displayGroup": [
"d307d7c5e08478327b6d30224738964d"
]
},
"sort": [
0,
"bf6fb463de24ec119d1a005056be7e8d"
]
},
{
"_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": "d3949bafb069ed119d20005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 80127.0,
"id": "d3949bafb069ed119d20005056be7e8d"
},
"fields": {
"displayGroup": [
"99f31ea4d72ab33e443d26f2113f2368"
]
},
"sort": [
0,
"d3949bafb069ed119d20005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "e1183538b069ed119d20005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 80114.0,
"id": "e1183538b069ed119d20005056be7e8d"
},
"fields": {
"displayGroup": [
"c1bfa5933cd0e0fbc9cc3da94d352afb"
]
},
"sort": [
0,
"e1183538b069ed119d20005056be7e8d"
]
},
{
"_index": "sw_dynatech_stage_product_1756372576",
"_id": "f3183538b069ed119d20005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 80115.0,
"id": "f3183538b069ed119d20005056be7e8d"
},
"fields": {
"displayGroup": [
"2c382128dc6ed6435c87caee36e70a51"
]
},
"sort": [
0,
"f3183538b069ed119d20005056be7e8d"
]
},
{
"_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": "fb60c051de24ec119d1a005056be7e8d",
"_score": null,
"_source": {
"autoIncrement": 80076.0,
"id": "fb60c051de24ec119d1a005056be7e8d"
},
"fields": {
"displayGroup": [
"8b9a1116d534d76a387f5c2e6750b502"
]
},
"sort": [
0,
"fb60c051de24ec119d1a005056be7e8d"
]
}
]
},
"aggregations": {
"total-count": {
"value": 23
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
2.76 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":"98b6b465186fed119d20005056be7e8d"}}}},{"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": 23,
"relation": "eq"
},
"max_score": null,
"hits": []
},
"aggregations": {
"shipping-free-filter": {
"doc_count": 0,
"shipping-free": {
"value": null
}
},
"rating-exists": {
"doc_count": 23,
"rating": {
"value": 0.0
}
},
"price": {
"count": 23,
"min": 0.0,
"max": 29.95,
"avg": 10.69086956521739,
"sum": 245.89
},
"options": {
"doc_count": 0,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": []
}
},
"properties": {
"doc_count": 105,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "09a6080ed777ed119d24005056be7e8d",
"doc_count": 9
},
{
"key": "05a6080ed777ed119d24005056be7e8d",
"doc_count": 8
},
{
"key": "0ca6080ed777ed119d24005056be7e8d",
"doc_count": 7
},
{
"key": "60a6080ed777ed119d24005056be7e8d",
"doc_count": 6
},
{
"key": "11a6080ed777ed119d24005056be7e8d",
"doc_count": 5
},
{
"key": "b6a5080ed777ed119d24005056be7e8d",
"doc_count": 5
},
{
"key": "aba5080ed777ed119d24005056be7e8d",
"doc_count": 4
},
{
"key": "f3636e4afe79ed119d24005056be7e8d",
"doc_count": 4
},
{
"key": "19a6080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "1da6080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "41a6080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "5f664f62fe79ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "9ea5080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "a4a5080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "d790080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "db636e4afe79ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "df636e4afe79ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "8f8f4768fe79ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "9ba5080ed777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "aaa5080ed777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "05fee937df32ef119d29005056be7e8d",
"doc_count": 1
},
{
"key": "09664f62fe79ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "0ea6080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "27a6080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "35684f62fe79ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "4ca6080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "4da6080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "4e664f62fe79ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "a5a5080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "aea5080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "afa5080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "b4a5080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "b5a5080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "b7a5080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "caa5080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "d3a5080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "d8a5080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "e2a5080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "e3a5080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "ef0688c7da4fef119d29005056be7e8d",
"doc_count": 1
},
{
"key": "f1a5080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "f3a5080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "f7a5080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "fea5080ed777ed119d24005056be7e8d",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "e2c3b72dde24ec119d1a005056be7e8d",
"doc_count": 9
},
{
"key": "cac4b72dde24ec119d1a005056be7e8d",
"doc_count": 8
},
{
"key": "e5c3b72dde24ec119d1a005056be7e8d",
"doc_count": 3
},
{
"key": "88c3b72dde24ec119d1a005056be7e8d",
"doc_count": 2
},
{
"key": "acc3b72dde24ec119d1a005056be7e8d",
"doc_count": 1
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|