| 1 |
13.51 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":"d769fc70066fed119d20005056be7e8d"}}}},{"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"}}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
3.66 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":"d769fc70066fed119d20005056be7e8d"}}}},{"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": 20,
"relation": "eq"
},
"max_score": null,
"hits": []
},
"aggregations": {
"shipping-free-filter": {
"doc_count": 0,
"shipping-free": {
"value": null
}
},
"rating-exists": {
"doc_count": 20,
"rating": {
"value": 0.0
}
},
"price": {
"count": 20,
"min": 0.0,
"max": 22.95,
"avg": 12.876,
"sum": 257.52
},
"options": {
"doc_count": 175,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "02a4db460927ee119d28005056be7e8d",
"doc_count": 3
},
{
"key": "0599080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "0d644f8a01f1ee119d28005056be7e8d",
"doc_count": 3
},
{
"key": "0e4b9c5e067aed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "174b9c5e067aed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "248f1fedfff0ee119d28005056be7e8d",
"doc_count": 3
},
{
"key": "2b95080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "2b9d080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "2c91080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "2e95080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "369d080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "3a9d080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "439d080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "4a63760647f3ee119d28005056be7e8d",
"doc_count": 3
},
{
"key": "6090080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "629d080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "6390080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "6497080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "659d080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "6797080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "6997080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "6a9d080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "6d9d080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "709d080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "7196136d2cb4ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "7498080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "749d080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "7798080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "799d080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "7b9d080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "7e9d080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "839d080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "8898080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "889d080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "8d9c080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "9397080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "9d9d080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "9f9d080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "a097080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "a390080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "a39d080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "a79c080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "b39d080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "b79d080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "b89e080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "b9646e4afe79ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "bc9d080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "ca9d080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "cf97080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "d54e08a147aced119d24005056be7e8d",
"doc_count": 3
},
{
"key": "d895080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "e156337800f1ee119d28005056be7e8d",
"doc_count": 3
},
{
"key": "ea9d080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "ef9c080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "efd6fa41aaf1ee119d28005056be7e8d",
"doc_count": 3
},
{
"key": "f69d080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "a290080ed777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "5b90080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "9590080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "9790080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "9890080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "9d90080ed777ed119d24005056be7e8d",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 295,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "2c91080ed777ed119d24005056be7e8d",
"doc_count": 7
},
{
"key": "0599080ed777ed119d24005056be7e8d",
"doc_count": 6
},
{
"key": "5bb1efbbfe79ed119d24005056be7e8d",
"doc_count": 6
},
{
"key": "629d080ed777ed119d24005056be7e8d",
"doc_count": 6
},
{
"key": "6997080ed777ed119d24005056be7e8d",
"doc_count": 6
},
{
"key": "6a9d080ed777ed119d24005056be7e8d",
"doc_count": 6
},
{
"key": "799d080ed777ed119d24005056be7e8d",
"doc_count": 6
},
{
"key": "7b9d080ed777ed119d24005056be7e8d",
"doc_count": 6
},
{
"key": "839d080ed777ed119d24005056be7e8d",
"doc_count": 6
},
{
"key": "879c080ed777ed119d24005056be7e8d",
"doc_count": 6
},
{
"key": "b79d080ed777ed119d24005056be7e8d",
"doc_count": 6
},
{
"key": "cf97080ed777ed119d24005056be7e8d",
"doc_count": 6
},
{
"key": "ee9c080ed777ed119d24005056be7e8d",
"doc_count": 6
},
{
"key": "0d9d080ed777ed119d24005056be7e8d",
"doc_count": 5
},
{
"key": "104b9c5e067aed119d24005056be7e8d",
"doc_count": 5
},
{
"key": "144b9c5e067aed119d24005056be7e8d",
"doc_count": 5
},
{
"key": "26499c5e067aed119d24005056be7e8d",
"doc_count": 5
},
{
"key": "399d080ed777ed119d24005056be7e8d",
"doc_count": 5
},
{
"key": "469b080ed777ed119d24005056be7e8d",
"doc_count": 5
},
{
"key": "5296080ed777ed119d24005056be7e8d",
"doc_count": 5
},
{
"key": "749d080ed777ed119d24005056be7e8d",
"doc_count": 5
},
{
"key": "889d080ed777ed119d24005056be7e8d",
"doc_count": 5
},
{
"key": "8a9d080ed777ed119d24005056be7e8d",
"doc_count": 5
},
{
"key": "8c9d080ed777ed119d24005056be7e8d",
"doc_count": 5
},
{
"key": "9f9d080ed777ed119d24005056be7e8d",
"doc_count": 5
},
{
"key": "ad9d080ed777ed119d24005056be7e8d",
"doc_count": 5
},
{
"key": "b09d080ed777ed119d24005056be7e8d",
"doc_count": 5
},
{
"key": "e79d080ed777ed119d24005056be7e8d",
"doc_count": 5
},
{
"key": "b9646e4afe79ed119d24005056be7e8d",
"doc_count": 4
},
{
"key": "d895080ed777ed119d24005056be7e8d",
"doc_count": 4
},
{
"key": "383b0214d777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "5d3b0214d777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "6090080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "6390080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "873a0214d777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "8f3b0214d777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "a390080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "e73b0214d777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "0f3c0214d777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "423b0214d777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "46cca0ae50aced119d24005056be7e8d",
"doc_count": 2
},
{
"key": "523b0214d777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "543b0214d777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "5b666e4afe79ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "7b3b0214d777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "803b0214d777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "853b0214d777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "8c3b0214d777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "953b0214d777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "993b0214d777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "a290080ed777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "a53b0214d777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "b421a358067aed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "da3b0214d777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "fb3b0214d777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "013c0214d777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "01c693f689abed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "023c0214d777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "059d080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "0e3c0214d777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "133c0214d777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "1499080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "15666e4afe79ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "163c0214d777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "1b39e3cdfe79ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "248f1fedfff0ee119d28005056be7e8d",
"doc_count": 1
},
{
"key": "2e83c466ba0aee119d28005056be7e8d",
"doc_count": 1
},
{
"key": "369d080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "3b3b0214d777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "3c3b0214d777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "3f21a358067aed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "3f3b0214d777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "4a3b0214d777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "4c3b0214d777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "4e3b0214d777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "593b0214d777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "5b3b0214d777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "5b90080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "6397080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "6594080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "6694080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "689b080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "6924a358067aed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "6b3b0214d777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "6c023cb103edee119d28005056be7e8d",
"doc_count": 1
},
{
"key": "6c03ec7492e5ed119d27005056be7e8d",
"doc_count": 1
},
{
"key": "6d9d080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "6f3b0214d777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "7196136d2cb4ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "75fdf6228babed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "809d080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "833b0214d777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "8c9c080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "8d3b0214d777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "918830df03b9ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "923b0214d777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "933b0214d777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "939c080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "9590080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "963b0214d777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "9790080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "9890080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "9a83555cfe79ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "9d656e4afe79ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "9d90080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "a23b0214d777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "a5f6aacc03edee119d28005056be7e8d",
"doc_count": 1
},
{
"key": "af3b0214d777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "b23b0214d777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "b495080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "b8469ebd03b9ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "b9a06450fe79ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "bb3b0214d777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "bea0080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "c039e3cdfe79ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "cc3a0214d777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "ce9f080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "d03b0214d777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "d53b0214d777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "d69d080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "d976578bacf1ee119d28005056be7e8d",
"doc_count": 1
},
{
"key": "db3b0214d777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "e53b0214d777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "ea9d080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "ef83555cfe79ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "f3a76450fe79ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "f5646e4afe79ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "fd3b0214d777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "fe9d080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "ff3b0214d777ed119d24005056be7e8d",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "a8c4b72dde24ec119d1a005056be7e8d",
"doc_count": 20
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|