| 1 |
16.58 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":"352574cb3a7aed119d24005056be7e8d"}}}},{"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 |
2.85 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":"352574cb3a7aed119d24005056be7e8d"}}}},{"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": 15,
"relation": "eq"
},
"max_score": null,
"hits": []
},
"aggregations": {
"shipping-free-filter": {
"doc_count": 0,
"shipping-free": {
"value": null
}
},
"rating-exists": {
"doc_count": 15,
"rating": {
"value": 0.0
}
},
"price": {
"count": 15,
"min": 4.69,
"max": 14.95,
"avg": 8.418666666666667,
"sum": 126.28
},
"options": {
"doc_count": 202,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "174b9c5e067aed119d24005056be7e8d",
"doc_count": 5
},
{
"key": "2b9d080ed777ed119d24005056be7e8d",
"doc_count": 5
},
{
"key": "749d080ed777ed119d24005056be7e8d",
"doc_count": 5
},
{
"key": "b9646e4afe79ed119d24005056be7e8d",
"doc_count": 5
},
{
"key": "02a4db460927ee119d28005056be7e8d",
"doc_count": 3
},
{
"key": "0599080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "0d644f8a01f1ee119d28005056be7e8d",
"doc_count": 3
},
{
"key": "0e4b9c5e067aed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "248f1fedfff0ee119d28005056be7e8d",
"doc_count": 3
},
{
"key": "2b95080ed777ed119d24005056be7e8d",
"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": "629d080ed777ed119d24005056be7e8d",
"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": "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": "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": "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": "0c3c0214d777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "289d080ed777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "2d6d94a138e5ee119d28005056be7e8d",
"doc_count": 2
},
{
"key": "40686e4afe79ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "59d5b91d5bb1ee119d28005056be7e8d",
"doc_count": 2
},
{
"key": "82b2233238e5ee119d28005056be7e8d",
"doc_count": 2
},
{
"key": "873a0214d777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "8f3b0214d777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "939c080ed777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "a390080ed777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "b890080ed777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "c3654f62fe79ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "f19c080ed777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "fc9d080ed777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "075e6298380def119d28005056be7e8d",
"doc_count": 1
},
{
"key": "10908f9ad1f3ed119d27005056be7e8d",
"doc_count": 1
},
{
"key": "5b90080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "6390080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "8f760965d3f3ed119d27005056be7e8d",
"doc_count": 1
},
{
"key": "9590080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "a290080ed777ed119d24005056be7e8d",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 347,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "b9646e4afe79ed119d24005056be7e8d",
"doc_count": 8
},
{
"key": "289d080ed777ed119d24005056be7e8d",
"doc_count": 7
},
{
"key": "2b9d080ed777ed119d24005056be7e8d",
"doc_count": 7
},
{
"key": "749d080ed777ed119d24005056be7e8d",
"doc_count": 7
},
{
"key": "f19c080ed777ed119d24005056be7e8d",
"doc_count": 7
},
{
"key": "fc9d080ed777ed119d24005056be7e8d",
"doc_count": 7
},
{
"key": "0599080ed777ed119d24005056be7e8d",
"doc_count": 6
},
{
"key": "369d080ed777ed119d24005056be7e8d",
"doc_count": 6
},
{
"key": "629d080ed777ed119d24005056be7e8d",
"doc_count": 6
},
{
"key": "6997080ed777ed119d24005056be7e8d",
"doc_count": 6
},
{
"key": "6a9d080ed777ed119d24005056be7e8d",
"doc_count": 6
},
{
"key": "6d9d080ed777ed119d24005056be7e8d",
"doc_count": 6
},
{
"key": "799d080ed777ed119d24005056be7e8d",
"doc_count": 6
},
{
"key": "7b9d080ed777ed119d24005056be7e8d",
"doc_count": 6
},
{
"key": "809d080ed777ed119d24005056be7e8d",
"doc_count": 6
},
{
"key": "839d080ed777ed119d24005056be7e8d",
"doc_count": 6
},
{
"key": "b421a358067aed119d24005056be7e8d",
"doc_count": 6
},
{
"key": "b79d080ed777ed119d24005056be7e8d",
"doc_count": 6
},
{
"key": "d69d080ed777ed119d24005056be7e8d",
"doc_count": 6
},
{
"key": "ea9d080ed777ed119d24005056be7e8d",
"doc_count": 6
},
{
"key": "039e080ed777ed119d24005056be7e8d",
"doc_count": 5
},
{
"key": "399d080ed777ed119d24005056be7e8d",
"doc_count": 5
},
{
"key": "3f21a358067aed119d24005056be7e8d",
"doc_count": 5
},
{
"key": "439d080ed777ed119d24005056be7e8d",
"doc_count": 5
},
{
"key": "659d080ed777ed119d24005056be7e8d",
"doc_count": 5
},
{
"key": "679d080ed777ed119d24005056be7e8d",
"doc_count": 5
},
{
"key": "6d97080ed777ed119d24005056be7e8d",
"doc_count": 5
},
{
"key": "709d080ed777ed119d24005056be7e8d",
"doc_count": 5
},
{
"key": "7497080ed777ed119d24005056be7e8d",
"doc_count": 5
},
{
"key": "779d080ed777ed119d24005056be7e8d",
"doc_count": 5
},
{
"key": "889d080ed777ed119d24005056be7e8d",
"doc_count": 5
},
{
"key": "8a9d080ed777ed119d24005056be7e8d",
"doc_count": 5
},
{
"key": "9d656e4afe79ed119d24005056be7e8d",
"doc_count": 5
},
{
"key": "9d9d080ed777ed119d24005056be7e8d",
"doc_count": 5
},
{
"key": "9f96080ed777ed119d24005056be7e8d",
"doc_count": 5
},
{
"key": "9f9d080ed777ed119d24005056be7e8d",
"doc_count": 5
},
{
"key": "c90bbbaacbf3ed119d27005056be7e8d",
"doc_count": 5
},
{
"key": "11c3c57fccf3ed119d27005056be7e8d",
"doc_count": 4
},
{
"key": "3697080ed777ed119d24005056be7e8d",
"doc_count": 4
},
{
"key": "5e16f878ccf3ed119d27005056be7e8d",
"doc_count": 4
},
{
"key": "6697080ed777ed119d24005056be7e8d",
"doc_count": 4
},
{
"key": "7697080ed777ed119d24005056be7e8d",
"doc_count": 4
},
{
"key": "776e1d7ecbf3ed119d27005056be7e8d",
"doc_count": 4
},
{
"key": "8b97080ed777ed119d24005056be7e8d",
"doc_count": 4
},
{
"key": "8d9c080ed777ed119d24005056be7e8d",
"doc_count": 4
},
{
"key": "9797080ed777ed119d24005056be7e8d",
"doc_count": 4
},
{
"key": "979c080ed777ed119d24005056be7e8d",
"doc_count": 4
},
{
"key": "9c9c080ed777ed119d24005056be7e8d",
"doc_count": 4
},
{
"key": "a0e0260986abed119d24005056be7e8d",
"doc_count": 4
},
{
"key": "a5d10706ccf3ed119d27005056be7e8d",
"doc_count": 4
},
{
"key": "a89d080ed777ed119d24005056be7e8d",
"doc_count": 4
},
{
"key": "d090080ed777ed119d24005056be7e8d",
"doc_count": 4
},
{
"key": "d79c080ed777ed119d24005056be7e8d",
"doc_count": 4
},
{
"key": "b890080ed777ed119d24005056be7e8d",
"doc_count": 3
},
{
"key": "0c3c0214d777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "174b9c5e067aed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "2d6d94a138e5ee119d28005056be7e8d",
"doc_count": 2
},
{
"key": "40686e4afe79ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "46cca0ae50aced119d24005056be7e8d",
"doc_count": 2
},
{
"key": "59d5b91d5bb1ee119d28005056be7e8d",
"doc_count": 2
},
{
"key": "5b90080ed777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "82b2233238e5ee119d28005056be7e8d",
"doc_count": 2
},
{
"key": "873a0214d777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "8f3b0214d777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "939c080ed777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "a390080ed777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "c3654f62fe79ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "cf97080ed777ed119d24005056be7e8d",
"doc_count": 2
},
{
"key": "01c693f689abed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "039d080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "059d080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "075e6298380def119d28005056be7e8d",
"doc_count": 1
},
{
"key": "10908f9ad1f3ed119d27005056be7e8d",
"doc_count": 1
},
{
"key": "1499080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "239b080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "248f1fedfff0ee119d28005056be7e8d",
"doc_count": 1
},
{
"key": "29a66450fe79ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "2bd8f1c593dfee119d28005056be7e8d",
"doc_count": 1
},
{
"key": "2e83c466ba0aee119d28005056be7e8d",
"doc_count": 1
},
{
"key": "3685ce9e42f8ee119d28005056be7e8d",
"doc_count": 1
},
{
"key": "5bb1efbbfe79ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "6090080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "6390080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "6397080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "6924a358067aed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "7196136d2cb4ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "7797080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "7e9d080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "859d080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "879c080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "8f760965d3f3ed119d27005056be7e8d",
"doc_count": 1
},
{
"key": "9590080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "969c080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "a290080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "a29c080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "a396080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "a490080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "a59d080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "b99c080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "bea0080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "d895080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "d976578bacf1ee119d28005056be7e8d",
"doc_count": 1
},
{
"key": "e39c080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "eb21a358067aed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "ee9c080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "f6565d56fe79ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "f79d080ed777ed119d24005056be7e8d",
"doc_count": 1
},
{
"key": "fe9d080ed777ed119d24005056be7e8d",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "a8c4b72dde24ec119d1a005056be7e8d",
"doc_count": 4
},
{
"key": "acc3b72dde24ec119d1a005056be7e8d",
"doc_count": 4
},
{
"key": "d9c3b72dde24ec119d1a005056be7e8d",
"doc_count": 4
},
{
"key": "cac4b72dde24ec119d1a005056be7e8d",
"doc_count": 3
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|