| 1 |
19.59 ms |
Request:
{"index":"dev_product","search_type":"query_then_fetch","track_total_hits":true,"body":{"post_filter":{"bool":{"filter":[{"terms":{"manufacturerId":["01912bf68c417208afbf6067addf7d78"]}}]}},"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"term":{"active":true}},{"range":{"visibility_08d2beb617754d2e9b8813e67fbd3a10":{"gte":20}}}]}},{"exists":{"field":"displayGroup"}},{"bool":{"must_not":[{"bool":{"must":[{"term":{"isCloseout":true}},{"term":{"available":false}}]}}]}}]}}],"must":[{"dis_max":{"queries":[{"bool":{"must":[{"bool":{"should":[{"dis_max":{"queries":[{"match":{"metaDescription.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"best","boost":500.0,"fuzziness":"auto","operator":"and"}}},{"match_phrase_prefix":{"metaDescription.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"best","boost":300.0,"slop":3,"max_expansions":10}}},{"match":{"metaDescription.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram":{"query":"best","boost":200.0}}}]}},{"dis_max":{"queries":[{"match":{"productNumber.search":{"query":"best","boost":500.0,"fuzziness":1,"operator":"and"}}},{"match_phrase_prefix":{"productNumber.search":{"query":"best","boost":300.0,"slop":3,"max_expansions":10}}}]}},{"dis_max":{"queries":[{"match":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"best","boost":700.0,"fuzziness":"auto","operator":"and"}}},{"match_phrase_prefix":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"best","boost":420.0,"slop":3,"max_expansions":10}}},{"match":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram":{"query":"best","boost":280.0}}}]}},{"nested":{"path":"tags","query":{"dis_max":{"queries":[{"match":{"tags.name.search":{"query":"best","boost":800.0,"fuzziness":1,"operator":"and"}}},{"match_phrase_prefix":{"tags.name.search":{"query":"best","boost":480.0,"slop":3,"max_expansions":10}}}]}}}},{"dis_max":{"queries":[{"match":{"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"best","boost":800.0,"fuzziness":1,"operator":"and"}}},{"match_phrase_prefix":{"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"best","boost":480.0,"slop":3,"max_expansions":10}}}]}},{"dis_max":{"queries":[{"match":{"description.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"best","boost":250.0,"fuzziness":"auto","operator":"and"}}},{"match_phrase_prefix":{"description.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"best","boost":150.0,"slop":3,"max_expansions":10}}},{"match":{"description.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram":{"query":"best","boost":100.0}}}]}},{"nested":{"path":"categories","query":{"dis_max":{"queries":[{"match":{"categories.name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"best","boost":200.0,"fuzziness":"auto","operator":"and"}}},{"match_phrase_prefix":{"categories.name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"best","boost":120.0,"slop":3,"max_expansions":10}}},{"match":{"categories.name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram":{"query":"best","boost":80.0}}}]}}}}]}},{"bool":{"should":[{"dis_max":{"queries":[{"match":{"metaDescription.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"grip","boost":500.0,"fuzziness":"auto","operator":"and"}}},{"match_phrase_prefix":{"metaDescription.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"grip","boost":300.0,"slop":3,"max_expansions":10}}},{"match":{"metaDescription.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram":{"query":"grip","boost":200.0}}}]}},{"dis_max":{"queries":[{"match":{"productNumber.search":{"query":"grip","boost":500.0,"fuzziness":1,"operator":"and"}}},{"match_phrase_prefix":{"productNumber.search":{"query":"grip","boost":300.0,"slop":3,"max_expansions":10}}}]}},{"dis_max":{"queries":[{"match":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"grip","boost":700.0,"fuzziness":"auto","operator":"and"}}},{"match_phrase_prefix":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"grip","boost":420.0,"slop":3,"max_expansions":10}}},{"match":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram":{"query":"grip","boost":280.0}}}]}},{"nested":{"path":"tags","query":{"dis_max":{"queries":[{"match":{"tags.name.search":{"query":"grip","boost":800.0,"fuzziness":1,"operator":"and"}}},{"match_phrase_prefix":{"tags.name.search":{"query":"grip","boost":480.0,"slop":3,"max_expansions":10}}}]}}}},{"dis_max":{"queries":[{"match":{"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"grip","boost":800.0,"fuzziness":1,"operator":"and"}}},{"match_phrase_prefix":{"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"grip","boost":480.0,"slop":3,"max_expansions":10}}}]}},{"dis_max":{"queries":[{"match":{"description.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"grip","boost":250.0,"fuzziness":"auto","operator":"and"}}},{"match_phrase_prefix":{"description.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"grip","boost":150.0,"slop":3,"max_expansions":10}}},{"match":{"description.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram":{"query":"grip","boost":100.0}}}]}},{"nested":{"path":"categories","query":{"dis_max":{"queries":[{"match":{"categories.name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"grip","boost":200.0,"fuzziness":"auto","operator":"and"}}},{"match_phrase_prefix":{"categories.name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"grip","boost":120.0,"slop":3,"max_expansions":10}}},{"match":{"categories.name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram":{"query":"grip","boost":80.0}}}]}}}}]}}]}},{"bool":{"should":[{"dis_max":{"queries":[{"match":{"metaDescription.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"best grip","boost":500.0,"fuzziness":"auto","operator":"and"}}},{"match_phrase_prefix":{"metaDescription.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"best grip","boost":300.0,"slop":3,"max_expansions":10}}}]}},{"dis_max":{"queries":[{"match":{"productNumber.search":{"query":"best grip","boost":500.0,"fuzziness":1,"operator":"and"}}},{"match_phrase_prefix":{"productNumber.search":{"query":"best grip","boost":300.0,"slop":3,"max_expansions":10}}}]}},{"dis_max":{"queries":[{"match":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"best grip","boost":700.0,"fuzziness":"auto","operator":"and"}}},{"match_phrase_prefix":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"best grip","boost":420.0,"slop":3,"max_expansions":10}}}]}},{"nested":{"path":"tags","query":{"dis_max":{"queries":[{"match":{"tags.name.search":{"query":"best grip","boost":800.0,"fuzziness":1,"operator":"and"}}},{"match_phrase_prefix":{"tags.name.search":{"query":"best grip","boost":480.0,"slop":3,"max_expansions":10}}}]}}}},{"dis_max":{"queries":[{"match":{"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"best grip","boost":800.0,"fuzziness":1,"operator":"and"}}},{"match_phrase_prefix":{"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"best grip","boost":480.0,"slop":3,"max_expansions":10}}}]}},{"dis_max":{"queries":[{"match":{"description.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"best grip","boost":250.0,"fuzziness":"auto","operator":"and"}}},{"match_phrase_prefix":{"description.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"best grip","boost":150.0,"slop":3,"max_expansions":10}}}]}},{"nested":{"path":"categories","query":{"dis_max":{"queries":[{"match":{"categories.name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"best grip","boost":200.0,"fuzziness":"auto","operator":"and"}}},{"match_phrase_prefix":{"categories.name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"best grip","boost":120.0,"slop":3,"max_expansions":10}}}]}}}}]}}]}}]}},"sort":[{"_score":{"order":"DESC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-filtered-count":{"filter":{"terms":{"manufacturerId":["01912bf68c417208afbf6067addf7d78"]}},"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}}}},"from":0,"size":32,"collapse":{"field":"displayGroup"},"timeout":"5s"}}
POST http://localhost:9200/dev_product/_search?search_type=query_then_fetch&track_total_hits=1
Accept: application/json
Content-Type: application/json
{
"post_filter": {
"bool": {
"filter": [
{
"terms": {
"manufacturerId": [
"01912bf68c417208afbf6067addf7d78"
]
}
}
]
}
},
"query": {
"bool": {
"filter": [
{
"bool": {
"must": [
{
"bool": {
"must": [
{
"term": {
"active": true
}
},
{
"range": {
"visibility_08d2beb617754d2e9b8813e67fbd3a10": {
"gte": 20
}
}
}
]
}
},
{
"exists": {
"field": "displayGroup"
}
},
{
"bool": {
"must_not": [
{
"bool": {
"must": [
{
"term": {
"isCloseout": true
}
},
{
"term": {
"available": false
}
}
]
}
}
]
}
}
]
}
}
],
"must": [
{
"dis_max": {
"queries": [
{
"bool": {
"must": [
{
"bool": {
"should": [
{
"dis_max": {
"queries": [
{
"match": {
"metaDescription.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "best",
"boost": 500.0,
"fuzziness": "auto",
"operator": "and"
}
}
},
{
"match_phrase_prefix": {
"metaDescription.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "best",
"boost": 300.0,
"slop": 3,
"max_expansions": 10
}
}
},
{
"match": {
"metaDescription.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram": {
"query": "best",
"boost": 200.0
}
}
}
]
}
},
{
"dis_max": {
"queries": [
{
"match": {
"productNumber.search": {
"query": "best",
"boost": 500.0,
"fuzziness": 1,
"operator": "and"
}
}
},
{
"match_phrase_prefix": {
"productNumber.search": {
"query": "best",
"boost": 300.0,
"slop": 3,
"max_expansions": 10
}
}
}
]
}
},
{
"dis_max": {
"queries": [
{
"match": {
"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "best",
"boost": 700.0,
"fuzziness": "auto",
"operator": "and"
}
}
},
{
"match_phrase_prefix": {
"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "best",
"boost": 420.0,
"slop": 3,
"max_expansions": 10
}
}
},
{
"match": {
"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram": {
"query": "best",
"boost": 280.0
}
}
}
]
}
},
{
"nested": {
"path": "tags",
"query": {
"dis_max": {
"queries": [
{
"match": {
"tags.name.search": {
"query": "best",
"boost": 800.0,
"fuzziness": 1,
"operator": "and"
}
}
},
{
"match_phrase_prefix": {
"tags.name.search": {
"query": "best",
"boost": 480.0,
"slop": 3,
"max_expansions": 10
}
}
}
]
}
}
}
},
{
"dis_max": {
"queries": [
{
"match": {
"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "best",
"boost": 800.0,
"fuzziness": 1,
"operator": "and"
}
}
},
{
"match_phrase_prefix": {
"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "best",
"boost": 480.0,
"slop": 3,
"max_expansions": 10
}
}
}
]
}
},
{
"dis_max": {
"queries": [
{
"match": {
"description.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "best",
"boost": 250.0,
"fuzziness": "auto",
"operator": "and"
}
}
},
{
"match_phrase_prefix": {
"description.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "best",
"boost": 150.0,
"slop": 3,
"max_expansions": 10
}
}
},
{
"match": {
"description.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram": {
"query": "best",
"boost": 100.0
}
}
}
]
}
},
{
"nested": {
"path": "categories",
"query": {
"dis_max": {
"queries": [
{
"match": {
"categories.name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "best",
"boost": 200.0,
"fuzziness": "auto",
"operator": "and"
}
}
},
{
"match_phrase_prefix": {
"categories.name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "best",
"boost": 120.0,
"slop": 3,
"max_expansions": 10
}
}
},
{
"match": {
"categories.name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram": {
"query": "best",
"boost": 80.0
}
}
}
]
}
}
}
}
]
}
},
{
"bool": {
"should": [
{
"dis_max": {
"queries": [
{
"match": {
"metaDescription.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "grip",
"boost": 500.0,
"fuzziness": "auto",
"operator": "and"
}
}
},
{
"match_phrase_prefix": {
"metaDescription.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "grip",
"boost": 300.0,
"slop": 3,
"max_expansions": 10
}
}
},
{
"match": {
"metaDescription.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram": {
"query": "grip",
"boost": 200.0
}
}
}
]
}
},
{
"dis_max": {
"queries": [
{
"match": {
"productNumber.search": {
"query": "grip",
"boost": 500.0,
"fuzziness": 1,
"operator": "and"
}
}
},
{
"match_phrase_prefix": {
"productNumber.search": {
"query": "grip",
"boost": 300.0,
"slop": 3,
"max_expansions": 10
}
}
}
]
}
},
{
"dis_max": {
"queries": [
{
"match": {
"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "grip",
"boost": 700.0,
"fuzziness": "auto",
"operator": "and"
}
}
},
{
"match_phrase_prefix": {
"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "grip",
"boost": 420.0,
"slop": 3,
"max_expansions": 10
}
}
},
{
"match": {
"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram": {
"query": "grip",
"boost": 280.0
}
}
}
]
}
},
{
"nested": {
"path": "tags",
"query": {
"dis_max": {
"queries": [
{
"match": {
"tags.name.search": {
"query": "grip",
"boost": 800.0,
"fuzziness": 1,
"operator": "and"
}
}
},
{
"match_phrase_prefix": {
"tags.name.search": {
"query": "grip",
"boost": 480.0,
"slop": 3,
"max_expansions": 10
}
}
}
]
}
}
}
},
{
"dis_max": {
"queries": [
{
"match": {
"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "grip",
"boost": 800.0,
"fuzziness": 1,
"operator": "and"
}
}
},
{
"match_phrase_prefix": {
"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "grip",
"boost": 480.0,
"slop": 3,
"max_expansions": 10
}
}
}
]
}
},
{
"dis_max": {
"queries": [
{
"match": {
"description.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "grip",
"boost": 250.0,
"fuzziness": "auto",
"operator": "and"
}
}
},
{
"match_phrase_prefix": {
"description.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "grip",
"boost": 150.0,
"slop": 3,
"max_expansions": 10
}
}
},
{
"match": {
"description.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram": {
"query": "grip",
"boost": 100.0
}
}
}
]
}
},
{
"nested": {
"path": "categories",
"query": {
"dis_max": {
"queries": [
{
"match": {
"categories.name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "grip",
"boost": 200.0,
"fuzziness": "auto",
"operator": "and"
}
}
},
{
"match_phrase_prefix": {
"categories.name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "grip",
"boost": 120.0,
"slop": 3,
"max_expansions": 10
}
}
},
{
"match": {
"categories.name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram": {
"query": "grip",
"boost": 80.0
}
}
}
]
}
}
}
}
]
}
}
]
}
},
{
"bool": {
"should": [
{
"dis_max": {
"queries": [
{
"match": {
"metaDescription.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "best grip",
"boost": 500.0,
"fuzziness": "auto",
"operator": "and"
}
}
},
{
"match_phrase_prefix": {
"metaDescription.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "best grip",
"boost": 300.0,
"slop": 3,
"max_expansions": 10
}
}
}
]
}
},
{
"dis_max": {
"queries": [
{
"match": {
"productNumber.search": {
"query": "best grip",
"boost": 500.0,
"fuzziness": 1,
"operator": "and"
}
}
},
{
"match_phrase_prefix": {
"productNumber.search": {
"query": "best grip",
"boost": 300.0,
"slop": 3,
"max_expansions": 10
}
}
}
]
}
},
{
"dis_max": {
"queries": [
{
"match": {
"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "best grip",
"boost": 700.0,
"fuzziness": "auto",
"operator": "and"
}
}
},
{
"match_phrase_prefix": {
"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "best grip",
"boost": 420.0,
"slop": 3,
"max_expansions": 10
}
}
}
]
}
},
{
"nested": {
"path": "tags",
"query": {
"dis_max": {
"queries": [
{
"match": {
"tags.name.search": {
"query": "best grip",
"boost": 800.0,
"fuzziness": 1,
"operator": "and"
}
}
},
{
"match_phrase_prefix": {
"tags.name.search": {
"query": "best grip",
"boost": 480.0,
"slop": 3,
"max_expansions": 10
}
}
}
]
}
}
}
},
{
"dis_max": {
"queries": [
{
"match": {
"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "best grip",
"boost": 800.0,
"fuzziness": 1,
"operator": "and"
}
}
},
{
"match_phrase_prefix": {
"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "best grip",
"boost": 480.0,
"slop": 3,
"max_expansions": 10
}
}
}
]
}
},
{
"dis_max": {
"queries": [
{
"match": {
"description.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "best grip",
"boost": 250.0,
"fuzziness": "auto",
"operator": "and"
}
}
},
{
"match_phrase_prefix": {
"description.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "best grip",
"boost": 150.0,
"slop": 3,
"max_expansions": 10
}
}
}
]
}
},
{
"nested": {
"path": "categories",
"query": {
"dis_max": {
"queries": [
{
"match": {
"categories.name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "best grip",
"boost": 200.0,
"fuzziness": "auto",
"operator": "and"
}
}
},
{
"match_phrase_prefix": {
"categories.name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "best grip",
"boost": 120.0,
"slop": 3,
"max_expansions": 10
}
}
}
]
}
}
}
}
]
}
}
]
}
}
]
}
},
"sort": [
{
"_score": {
"order": "DESC"
}
},
{
"id": {
"order": "ASC"
}
}
],
"aggregations": {
"total-filtered-count": {
"filter": {
"terms": {
"manufacturerId": [
"01912bf68c417208afbf6067addf7d78"
]
}
},
"aggregations": {
"total-count": {
"cardinality": {
"field": "displayGroup"
}
}
}
}
},
"from": 0,
"size": 32,
"collapse": {
"field": "displayGroup"
},
"timeout": "5s"
}
{
"took": 13,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 1,
"relation": "eq"
},
"max_score": 4376.4404,
"hits": [
{
"_index": "dev_product_1762781623",
"_id": "dd5c547063e24ceb86d9195aa14de789",
"_score": 4376.4404,
"_source": {
"purchasePrices": [
{
"currencyId": "b7d2554b0ce847cd82f3ac9bd1c0dfca",
"gross": 0.0,
"net": 0.0,
"linked": true
}
],
"referenceUnit": null,
"purchaseUnit": null,
"unit": {
"id": null,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5059dc45b5104c368cc2a7f890b80123": null
},
"shortCode": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5059dc45b5104c368cc2a7f890b80123": null
},
"_count": 1
},
"crossSellings": [
{
"id": "a6290be189e94c42b66b6853744bc89f",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "\u00c4hnliche Artikel",
"5059dc45b5104c368cc2a7f890b80123": "Similar article"
}
},
{
"id": "73c1b6264ab14842adb08372a9270995",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Das k\u00f6nnte Sie auch interessieren",
"5059dc45b5104c368cc2a7f890b80123": "This might also interest you"
}
}
],
"keywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Montage, Werkzeug, Bit, Schraubendreherklinge, Winter, Reifen, Winterreifen, Best, Grip, Spikes montieren, Spikes Akkuschrauber, Spikes Werkzeug,",
"5059dc45b5104c368cc2a7f890b80123": "Mounting, tool, bit, screwdriver blade, winter, tyres, winter tyres, best, grip, mount studs, studs cordless screwdriver, studs tool,"
},
"packUnit": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "St\u00fcck",
"5059dc45b5104c368cc2a7f890b80123": "Piece"
},
"packUnitPlural": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5059dc45b5104c368cc2a7f890b80123": null
},
"id": "dd5c547063e24ceb86d9195aa14de789",
"autoIncrement": 3439.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "08d2beb617754d2e9b8813e67fbd3a10"
}
],
"availableStock": 9,
"productNumber": "BES4500",
"ean": null,
"displayGroup": "9cae8dc830d2a9f05299dacc0cec1b50",
"sales": 2,
"stock": 9,
"weight": 0.1,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "01912bf68c417208afbf6067addf7d78",
"manufacturerNumber": null,
"deliveryTimeId": "aa4ebf35a1294ea7933bda0a921be17b",
"releaseDate": null,
"createdAt": "2016-11-08T00:00:00+00:00",
"categoryTree": [
"e95720b66e054265932a3d4f1d75ea24",
"018b5c698aca709e974fe3f7db35cead",
"783dd49eb257410481619fd360189486",
"5aa5729c95404d31837be01faa113843",
"126bea7ed87c44c8a97b32b72a089ab6",
"af39c257ae084b90a93f97795f9d277e",
"35415b05295e444da155c150970a75b7",
"92dcaf9b2ae04e7981c80ab446ea526e",
"b5fc7ad46da94523bbb7ecea3ca095fb",
"cd9cff5b0007456495cfaaa59e9c7b49"
],
"categoriesRo": [
{
"id": "e95720b66e054265932a3d4f1d75ea24",
"_count": 1
},
{
"id": "018b5c698aca709e974fe3f7db35cead",
"_count": 1
},
{
"id": "783dd49eb257410481619fd360189486",
"_count": 1
},
{
"id": "5aa5729c95404d31837be01faa113843",
"_count": 1
},
{
"id": "126bea7ed87c44c8a97b32b72a089ab6",
"_count": 1
},
{
"id": "af39c257ae084b90a93f97795f9d277e",
"_count": 1
},
{
"id": "35415b05295e444da155c150970a75b7",
"_count": 1
},
{
"id": "92dcaf9b2ae04e7981c80ab446ea526e",
"_count": 1
},
{
"id": "b5fc7ad46da94523bbb7ecea3ca095fb",
"_count": 1
},
{
"id": "cd9cff5b0007456495cfaaa59e9c7b49",
"_count": 1
}
],
"taxId": "d97cf5cff5d945aa8624948165e25887",
"tags": [
{
"id": "01917f485cef7a409544dca6df2593fc",
"name": "Verkaufsartikel",
"_count": 1
}
],
"parentId": null,
"coverId": "f70cfdfc7f324129a7679af3792e42b1",
"childCount": 0,
"categories": [
{
"id": "35415b05295e444da155c150970a75b7",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sonstige"
}
},
{
"id": "92dcaf9b2ae04e7981c80ab446ea526e",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Werkzeug",
"5059dc45b5104c368cc2a7f890b80123": "Tools"
}
},
{
"id": "b5fc7ad46da94523bbb7ecea3ca095fb",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r",
"5059dc45b5104c368cc2a7f890b80123": "Accessories"
}
},
{
"id": "cd9cff5b0007456495cfaaa59e9c7b49",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sonstige"
}
}
],
"manufacturer": {
"id": "01912bf68c417208afbf6067addf7d78",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Best Grip",
"5059dc45b5104c368cc2a7f890b80123": null
},
"_count": 1
},
"deliveryTime": {
"id": "aa4ebf35a1294ea7933bda0a921be17b",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "5-10 Werktage",
"5059dc45b5104c368cc2a7f890b80123": "5-10 working days"
},
"_count": 1
},
"properties": [
{
"id": "018b201bcc6d70bda9ce09b9944a4aeb",
"_count": 1,
"groupId": "018b201a27567e829cf6980419de7cd1",
"group": {
"id": "018b201a27567e829cf6980419de7cd1",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r",
"5059dc45b5104c368cc2a7f890b80123": "Accessories"
}
}
],
"options": [],
"categoryIds": [
"35415b05295e444da155c150970a75b7",
"92dcaf9b2ae04e7981c80ab446ea526e",
"b5fc7ad46da94523bbb7ecea3ca095fb",
"cd9cff5b0007456495cfaaa59e9c7b49"
],
"optionIds": [],
"propertyIds": [
"018b201bcc6d70bda9ce09b9944a4aeb"
],
"tagIds": [
"01917f485cef7a409544dca6df2593fc"
],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"migration_MigrationSW501092023V_product_attr6": false,
"migration_MigrationSW501092023V_product_attr7": true,
"migration_MigrationSW501092023V_product_attr8": false,
"migration_MigrationSW501092023V_product_attr14": false,
"migration_MigrationSW501092023V_product_attr15": false,
"migration_MigrationSW501092023V_product_attr16": true,
"migration_MigrationSW501092023V_product_attr19": false,
"migration_MigrationSW501092023V_product_icue_pseudoprice": 0.0,
"migration_MigrationSW501092023V_product_icue_min_order_exception": false,
"migration_MigrationSW501092023V_product_pixel_is_configurator": false,
"migration_MigrationSW501092023V_product_pixel_is_confianfrage": false,
"migration_MigrationSW501092023V_product_deposit": 0.0,
"migration_MigrationSW501092023V_product_kilb_article_hider_is_hidden": false,
"migration_MigrationSW501092023V_product_kilb_article_hider_is_hidden_seo": false,
"icueproducts_allowlinks": true
},
"5059dc45b5104c368cc2a7f890b80123": {
"migration_MigrationSW501092023V_product_attr16": true
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Montagewerkzeug f\u00fcr Spikes mit \u00d8 9mm",
"5059dc45b5104c368cc2a7f890b80123": "Mounting tool for spikes with \u00d8 9mm"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Montagewerkzeug für Spikes mit Ø 9mm\nBit (Werkzeug) zum Montieren von Spikes mit einem Durchmesser von 9 mm an Winterrrädern. Durch das Sechskantprofil des Schraubenkopfs einfach mit einem Akkuschrauber kompatibel.\nHinweis: Reifenspikes sind in Deutschland verboten\nMontageschritte:1. Kopf der dazugehörigen Spikes mit dem Montagewerkzeug positionieren2. Gewinde des Spikes auf der Reifenoberfläche ansetzen3. Nach unten drücken & mit einem Akkuschraubers unter langsamem Drehen einschrauben4. Spikes nur soweit eindrehen, bis der Kopf die Reifenoberfläche berührt5. Falls der Spike unabsichtlich zu weit eingedreht wurde, lassen sie ihn so wie er ist – drehen sie ihn nicht wieder heraus um ihn in die richtige position bekommen zu wollen6. Kontrollieren Sie die Spikes alle 1000km & korrigieren Sie diese, wenn nötig7. Mithilfe des Montagewerkzeugs und eines Akkuschraubers lassen sich die Spikes fassen & entfernen",
"5059dc45b5104c368cc2a7f890b80123": "Mounting tool for studs with Ø 9mm\nBit (tool) for mounting spikes with a diameter of 9 mm on winter wheels.Easily compatible with a cordless screwdriver due to the hexagonal profile of the screw head.Note: Tyre studs are prohibited in GermanyAssembly steps:1. position the head of the corresponding studs with the mounting tool2. place the thread of the stud on the tyre surface3. press down & screw in with a cordless screwdriver while turning slowly4. screw in the spike only until the head touches the tyre surface5. if the spike is unintentionally screwed in too far, leave it as it is - do not unscrew it to try to get it into the correct position6. check the spikes every 1000km & correct if necessary7. with the aid of the fitting tool and a cordless screwdriver, the studs can be gripped & removed"
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "\u25b7 Montagewerkzeug f\u00fcr Spikes mit \u00d8 9mm - hier erh\u00e4ltlich!",
"5059dc45b5104c368cc2a7f890b80123": "\u25b7 Mounting tool for spikes with \u00d8 9mm - available here!"
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "\u21aa\ufe0f Simple Montage von Spikes an Winterreifen mithilfe dieser Schraubendreherklinge \u2714\ufe0f beste Qualit\u00e4t \u2714\ufe0f schneller Versand",
"5059dc45b5104c368cc2a7f890b80123": "\u21aa\ufe0f \ufe0fSimple mounting of studs on winter tyres with the help of this screwdriver blade \u2714\ufe0f Best quality \u2714\ufe0f Fast shipping"
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": [
"Montage",
"Werkzeug",
"Bit",
"Schraubendreherklinge",
"Winter",
"Reifen",
"Winterreifen",
"Best",
"Grip",
"Spikes montieren",
"Spikes Akkuschrauber",
"Spikes Werkzeug"
],
"5059dc45b5104c368cc2a7f890b80123": [
"Mounting",
"tool",
"bit",
"screwdriver blade",
"winter",
"tyres",
"winter tyres",
"best",
"grip",
"mount studs",
"studs cordless screwdriver",
"studs tool"
]
},
"cheapest_price_rule892bba83aadf4e539a3c6a1446af67c3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 18.0,
"cheapest_price_rule892bba83aadf4e539a3c6a1446af67c3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 15.1261,
"cheapest_price_rule1601200eea0d4bee8c49cc14788ea44b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 14.4,
"cheapest_price_rule1601200eea0d4bee8c49cc14788ea44b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 12.1008,
"cheapest_price_rule061ab606cc7f44b4857e9b27b6a71420_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 18.0,
"cheapest_price_rule061ab606cc7f44b4857e9b27b6a71420_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 15.1261,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 18.0,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 15.1261,
"visibility_08d2beb617754d2e9b8813e67fbd3a10": 30,
"warehouseGroupStockField": {
"warehouse_group_stock": null,
"parent_warehouse_group_stock": null
},
"warehouseGroups": [
{
"id": null,
"_count": 0
}
],
"completion": [
{
"key": "all",
"value": "bes4500"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "montagewerkzeug"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "f\u00fcr"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "spikes"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "mit"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "9mm"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "hier"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "erh\u00e4ltlich!"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "montagewerkzeug f\u00fcr spikes mit \u00f8 9mm"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "\u25b7 montagewerkzeug f\u00fcr spikes mit \u00f8 9mm - hier erh\u00e4ltlich!"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "mounting"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "tool"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "for"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "spikes"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "with"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "9mm"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "available"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "here!"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "mounting tool for spikes with \u00f8 9mm"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "\u25b7 mounting tool for spikes with \u00f8 9mm - available here!"
}
]
},
"fields": {
"displayGroup": [
"9cae8dc830d2a9f05299dacc0cec1b50"
]
},
"sort": [
4376.4404,
"dd5c547063e24ceb86d9195aa14de789"
]
}
]
},
"aggregations": {
"total-filtered-count": {
"doc_count": 1,
"total-count": {
"value": 1
}
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
14.59 ms |
Request:
{"index":"dev_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"term":{"active":true}},{"range":{"visibility_08d2beb617754d2e9b8813e67fbd3a10":{"gte":20}}}]}},{"exists":{"field":"displayGroup"}},{"bool":{"must_not":[{"bool":{"must":[{"term":{"isCloseout":true}},{"term":{"available":false}}]}}]}}]}}],"must":[{"dis_max":{"queries":[{"bool":{"must":[{"bool":{"should":[{"dis_max":{"queries":[{"match":{"metaDescription.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"best","boost":500.0,"fuzziness":"auto","operator":"and"}}},{"match_phrase_prefix":{"metaDescription.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"best","boost":300.0,"slop":3,"max_expansions":10}}},{"match":{"metaDescription.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram":{"query":"best","boost":200.0}}}]}},{"dis_max":{"queries":[{"match":{"productNumber.search":{"query":"best","boost":500.0,"fuzziness":1,"operator":"and"}}},{"match_phrase_prefix":{"productNumber.search":{"query":"best","boost":300.0,"slop":3,"max_expansions":10}}}]}},{"dis_max":{"queries":[{"match":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"best","boost":700.0,"fuzziness":"auto","operator":"and"}}},{"match_phrase_prefix":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"best","boost":420.0,"slop":3,"max_expansions":10}}},{"match":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram":{"query":"best","boost":280.0}}}]}},{"nested":{"path":"tags","query":{"dis_max":{"queries":[{"match":{"tags.name.search":{"query":"best","boost":800.0,"fuzziness":1,"operator":"and"}}},{"match_phrase_prefix":{"tags.name.search":{"query":"best","boost":480.0,"slop":3,"max_expansions":10}}}]}}}},{"dis_max":{"queries":[{"match":{"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"best","boost":800.0,"fuzziness":1,"operator":"and"}}},{"match_phrase_prefix":{"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"best","boost":480.0,"slop":3,"max_expansions":10}}}]}},{"dis_max":{"queries":[{"match":{"description.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"best","boost":250.0,"fuzziness":"auto","operator":"and"}}},{"match_phrase_prefix":{"description.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"best","boost":150.0,"slop":3,"max_expansions":10}}},{"match":{"description.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram":{"query":"best","boost":100.0}}}]}},{"nested":{"path":"categories","query":{"dis_max":{"queries":[{"match":{"categories.name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"best","boost":200.0,"fuzziness":"auto","operator":"and"}}},{"match_phrase_prefix":{"categories.name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"best","boost":120.0,"slop":3,"max_expansions":10}}},{"match":{"categories.name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram":{"query":"best","boost":80.0}}}]}}}}]}},{"bool":{"should":[{"dis_max":{"queries":[{"match":{"metaDescription.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"grip","boost":500.0,"fuzziness":"auto","operator":"and"}}},{"match_phrase_prefix":{"metaDescription.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"grip","boost":300.0,"slop":3,"max_expansions":10}}},{"match":{"metaDescription.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram":{"query":"grip","boost":200.0}}}]}},{"dis_max":{"queries":[{"match":{"productNumber.search":{"query":"grip","boost":500.0,"fuzziness":1,"operator":"and"}}},{"match_phrase_prefix":{"productNumber.search":{"query":"grip","boost":300.0,"slop":3,"max_expansions":10}}}]}},{"dis_max":{"queries":[{"match":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"grip","boost":700.0,"fuzziness":"auto","operator":"and"}}},{"match_phrase_prefix":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"grip","boost":420.0,"slop":3,"max_expansions":10}}},{"match":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram":{"query":"grip","boost":280.0}}}]}},{"nested":{"path":"tags","query":{"dis_max":{"queries":[{"match":{"tags.name.search":{"query":"grip","boost":800.0,"fuzziness":1,"operator":"and"}}},{"match_phrase_prefix":{"tags.name.search":{"query":"grip","boost":480.0,"slop":3,"max_expansions":10}}}]}}}},{"dis_max":{"queries":[{"match":{"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"grip","boost":800.0,"fuzziness":1,"operator":"and"}}},{"match_phrase_prefix":{"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"grip","boost":480.0,"slop":3,"max_expansions":10}}}]}},{"dis_max":{"queries":[{"match":{"description.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"grip","boost":250.0,"fuzziness":"auto","operator":"and"}}},{"match_phrase_prefix":{"description.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"grip","boost":150.0,"slop":3,"max_expansions":10}}},{"match":{"description.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram":{"query":"grip","boost":100.0}}}]}},{"nested":{"path":"categories","query":{"dis_max":{"queries":[{"match":{"categories.name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"grip","boost":200.0,"fuzziness":"auto","operator":"and"}}},{"match_phrase_prefix":{"categories.name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"grip","boost":120.0,"slop":3,"max_expansions":10}}},{"match":{"categories.name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram":{"query":"grip","boost":80.0}}}]}}}}]}}]}},{"bool":{"should":[{"dis_max":{"queries":[{"match":{"metaDescription.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"best grip","boost":500.0,"fuzziness":"auto","operator":"and"}}},{"match_phrase_prefix":{"metaDescription.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"best grip","boost":300.0,"slop":3,"max_expansions":10}}}]}},{"dis_max":{"queries":[{"match":{"productNumber.search":{"query":"best grip","boost":500.0,"fuzziness":1,"operator":"and"}}},{"match_phrase_prefix":{"productNumber.search":{"query":"best grip","boost":300.0,"slop":3,"max_expansions":10}}}]}},{"dis_max":{"queries":[{"match":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"best grip","boost":700.0,"fuzziness":"auto","operator":"and"}}},{"match_phrase_prefix":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"best grip","boost":420.0,"slop":3,"max_expansions":10}}}]}},{"nested":{"path":"tags","query":{"dis_max":{"queries":[{"match":{"tags.name.search":{"query":"best grip","boost":800.0,"fuzziness":1,"operator":"and"}}},{"match_phrase_prefix":{"tags.name.search":{"query":"best grip","boost":480.0,"slop":3,"max_expansions":10}}}]}}}},{"dis_max":{"queries":[{"match":{"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"best grip","boost":800.0,"fuzziness":1,"operator":"and"}}},{"match_phrase_prefix":{"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"best grip","boost":480.0,"slop":3,"max_expansions":10}}}]}},{"dis_max":{"queries":[{"match":{"description.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"best grip","boost":250.0,"fuzziness":"auto","operator":"and"}}},{"match_phrase_prefix":{"description.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"best grip","boost":150.0,"slop":3,"max_expansions":10}}}]}},{"nested":{"path":"categories","query":{"dis_max":{"queries":[{"match":{"categories.name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"best grip","boost":200.0,"fuzziness":"auto","operator":"and"}}},{"match_phrase_prefix":{"categories.name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"best grip","boost":120.0,"slop":3,"max_expansions":10}}}]}}}}]}}]}}]}},"aggregations":{"manufacturer":{"terms":{"field":"manufacturerId","size":10000}},"price":{"stats":{"script":{"source":"double getPrice(def accessors, def doc, def decimals, def round, def multiplier) {\n for (accessor in accessors) {\n def key = accessor['key'];\n\n if (!doc.containsKey(key) || doc[key].empty) {\n continue;\n }\n\n def factor = accessor['factor'];\n def value = doc[key].value * factor;\n\n value = Math.round(value * decimals);\n value = (double) value \/ decimals;\n\n if (!round) {\n return (double) value;\n }\n\n value = Math.round(value * multiplier);\n\n value = (double) value \/ multiplier;\n\n return (double) value;\n }\n\n return 0;\n}\n\nreturn getPrice(params['accessors'], doc, params['decimals'], params['round'], params['multiplier']);\n","lang":"painless","params":{"accessors":[{"key":"cheapest_price_rule76a1b37a7dbf4165b46c7ab2ff1a4841_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule56b8897938be44a48f5d23076fee8aa4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179b5053d723cbcc2ffca7e2f1d37_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179b50593737ca9f4a6695a28df19_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179b505a971d6b33bc2b7f77ff188_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179b50779728dbd34b221819dbf1f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179b5077e722793b82b3113582988_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019266bd95457bad916f0e7402a76e90_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule89396462b19442de853b499f33b78cef_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule8a3d72aab5a5468fa089505163f644f9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulef9da93f84ada4ccd8efd95692a615991_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule06c3e6c40cde40fb88ada175db3b7938_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed59dd72ecb5248c3701a4a9a7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5a33735dadfaae7d48ee3774_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5a7373caa742a3ca2b474faa_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5abc7260ba0d7f86a5f49012_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5ae473cc8acbdbd09e697f1a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5afd73938316ce5d62b21885_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5b3472fb8689bff52c36d24e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5b47710cbb88d4cabe575530_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5b657021952452aa52c2f262_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5b887386bf07cbfb0c6dc4d9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5bb77063b42436de2bb2654d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5be971dfb78ef0b9ab954636_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5c0f732b83a6fa611b17c9b0_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5c1c72e1bd5dd45fa91ae988_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5c48709db0bb1d772acb893a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5c61739288a8f19f5fee5c9f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5c83710a9f725ed88fa40977_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5cb47127996aaac8a7f6bdbe_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5ce97102b94464fe862ca787_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5d78715b957280e0dd517331_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5e047192aaa473cfc729c45f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5e987014b27850d1f01683cb_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5eb972a9811e6559447a6fdc_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5f01707fbf3a6adca420f5b1_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5f4a728eb343c4ceca55df24_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5fc1716ab9e26008508a989e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed601171ca8bcbf7c4e4b15d12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed604073a8a7cc7283597bc561_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed6086727a8ed87d86b79ab028_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed60bb7173b3c5caa2b21a03e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed611b719b8c493426397e071b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed616973d6ae87df29ca6fab45_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed617970548b9ab2028aaccee3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed61d27021a6d3f256f1fe6301_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed6233707282cee72b0a78165c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed629f739f81ef49fbfd3175b8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed630d72bfb80b0b616e56f094_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed632870c88f4d50e0091bdc8d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed6337724eaaf100fe723a9c73_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed63797281ae1e4a20fee27b7e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed63a670b0b0b52d88b864e4db_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed63dc70b69dd94cbfea630307_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed63ff71859ac60b2064da4af9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule892bba83aadf4e539a3c6a1446af67c3_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"},"search_type":"query_then_fetch"}
POST http://localhost:9200/dev_product/_search?track_total_hits=0&search_type=query_then_fetch
Accept: application/json
Content-Type: application/json
{
"query": {
"bool": {
"filter": [
{
"bool": {
"must": [
{
"bool": {
"must": [
{
"term": {
"active": true
}
},
{
"range": {
"visibility_08d2beb617754d2e9b8813e67fbd3a10": {
"gte": 20
}
}
}
]
}
},
{
"exists": {
"field": "displayGroup"
}
},
{
"bool": {
"must_not": [
{
"bool": {
"must": [
{
"term": {
"isCloseout": true
}
},
{
"term": {
"available": false
}
}
]
}
}
]
}
}
]
}
}
],
"must": [
{
"dis_max": {
"queries": [
{
"bool": {
"must": [
{
"bool": {
"should": [
{
"dis_max": {
"queries": [
{
"match": {
"metaDescription.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "best",
"boost": 500.0,
"fuzziness": "auto",
"operator": "and"
}
}
},
{
"match_phrase_prefix": {
"metaDescription.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "best",
"boost": 300.0,
"slop": 3,
"max_expansions": 10
}
}
},
{
"match": {
"metaDescription.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram": {
"query": "best",
"boost": 200.0
}
}
}
]
}
},
{
"dis_max": {
"queries": [
{
"match": {
"productNumber.search": {
"query": "best",
"boost": 500.0,
"fuzziness": 1,
"operator": "and"
}
}
},
{
"match_phrase_prefix": {
"productNumber.search": {
"query": "best",
"boost": 300.0,
"slop": 3,
"max_expansions": 10
}
}
}
]
}
},
{
"dis_max": {
"queries": [
{
"match": {
"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "best",
"boost": 700.0,
"fuzziness": "auto",
"operator": "and"
}
}
},
{
"match_phrase_prefix": {
"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "best",
"boost": 420.0,
"slop": 3,
"max_expansions": 10
}
}
},
{
"match": {
"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram": {
"query": "best",
"boost": 280.0
}
}
}
]
}
},
{
"nested": {
"path": "tags",
"query": {
"dis_max": {
"queries": [
{
"match": {
"tags.name.search": {
"query": "best",
"boost": 800.0,
"fuzziness": 1,
"operator": "and"
}
}
},
{
"match_phrase_prefix": {
"tags.name.search": {
"query": "best",
"boost": 480.0,
"slop": 3,
"max_expansions": 10
}
}
}
]
}
}
}
},
{
"dis_max": {
"queries": [
{
"match": {
"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "best",
"boost": 800.0,
"fuzziness": 1,
"operator": "and"
}
}
},
{
"match_phrase_prefix": {
"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "best",
"boost": 480.0,
"slop": 3,
"max_expansions": 10
}
}
}
]
}
},
{
"dis_max": {
"queries": [
{
"match": {
"description.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "best",
"boost": 250.0,
"fuzziness": "auto",
"operator": "and"
}
}
},
{
"match_phrase_prefix": {
"description.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "best",
"boost": 150.0,
"slop": 3,
"max_expansions": 10
}
}
},
{
"match": {
"description.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram": {
"query": "best",
"boost": 100.0
}
}
}
]
}
},
{
"nested": {
"path": "categories",
"query": {
"dis_max": {
"queries": [
{
"match": {
"categories.name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "best",
"boost": 200.0,
"fuzziness": "auto",
"operator": "and"
}
}
},
{
"match_phrase_prefix": {
"categories.name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "best",
"boost": 120.0,
"slop": 3,
"max_expansions": 10
}
}
},
{
"match": {
"categories.name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram": {
"query": "best",
"boost": 80.0
}
}
}
]
}
}
}
}
]
}
},
{
"bool": {
"should": [
{
"dis_max": {
"queries": [
{
"match": {
"metaDescription.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "grip",
"boost": 500.0,
"fuzziness": "auto",
"operator": "and"
}
}
},
{
"match_phrase_prefix": {
"metaDescription.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "grip",
"boost": 300.0,
"slop": 3,
"max_expansions": 10
}
}
},
{
"match": {
"metaDescription.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram": {
"query": "grip",
"boost": 200.0
}
}
}
]
}
},
{
"dis_max": {
"queries": [
{
"match": {
"productNumber.search": {
"query": "grip",
"boost": 500.0,
"fuzziness": 1,
"operator": "and"
}
}
},
{
"match_phrase_prefix": {
"productNumber.search": {
"query": "grip",
"boost": 300.0,
"slop": 3,
"max_expansions": 10
}
}
}
]
}
},
{
"dis_max": {
"queries": [
{
"match": {
"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "grip",
"boost": 700.0,
"fuzziness": "auto",
"operator": "and"
}
}
},
{
"match_phrase_prefix": {
"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "grip",
"boost": 420.0,
"slop": 3,
"max_expansions": 10
}
}
},
{
"match": {
"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram": {
"query": "grip",
"boost": 280.0
}
}
}
]
}
},
{
"nested": {
"path": "tags",
"query": {
"dis_max": {
"queries": [
{
"match": {
"tags.name.search": {
"query": "grip",
"boost": 800.0,
"fuzziness": 1,
"operator": "and"
}
}
},
{
"match_phrase_prefix": {
"tags.name.search": {
"query": "grip",
"boost": 480.0,
"slop": 3,
"max_expansions": 10
}
}
}
]
}
}
}
},
{
"dis_max": {
"queries": [
{
"match": {
"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "grip",
"boost": 800.0,
"fuzziness": 1,
"operator": "and"
}
}
},
{
"match_phrase_prefix": {
"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "grip",
"boost": 480.0,
"slop": 3,
"max_expansions": 10
}
}
}
]
}
},
{
"dis_max": {
"queries": [
{
"match": {
"description.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "grip",
"boost": 250.0,
"fuzziness": "auto",
"operator": "and"
}
}
},
{
"match_phrase_prefix": {
"description.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "grip",
"boost": 150.0,
"slop": 3,
"max_expansions": 10
}
}
},
{
"match": {
"description.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram": {
"query": "grip",
"boost": 100.0
}
}
}
]
}
},
{
"nested": {
"path": "categories",
"query": {
"dis_max": {
"queries": [
{
"match": {
"categories.name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "grip",
"boost": 200.0,
"fuzziness": "auto",
"operator": "and"
}
}
},
{
"match_phrase_prefix": {
"categories.name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "grip",
"boost": 120.0,
"slop": 3,
"max_expansions": 10
}
}
},
{
"match": {
"categories.name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram": {
"query": "grip",
"boost": 80.0
}
}
}
]
}
}
}
}
]
}
}
]
}
},
{
"bool": {
"should": [
{
"dis_max": {
"queries": [
{
"match": {
"metaDescription.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "best grip",
"boost": 500.0,
"fuzziness": "auto",
"operator": "and"
}
}
},
{
"match_phrase_prefix": {
"metaDescription.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "best grip",
"boost": 300.0,
"slop": 3,
"max_expansions": 10
}
}
}
]
}
},
{
"dis_max": {
"queries": [
{
"match": {
"productNumber.search": {
"query": "best grip",
"boost": 500.0,
"fuzziness": 1,
"operator": "and"
}
}
},
{
"match_phrase_prefix": {
"productNumber.search": {
"query": "best grip",
"boost": 300.0,
"slop": 3,
"max_expansions": 10
}
}
}
]
}
},
{
"dis_max": {
"queries": [
{
"match": {
"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "best grip",
"boost": 700.0,
"fuzziness": "auto",
"operator": "and"
}
}
},
{
"match_phrase_prefix": {
"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "best grip",
"boost": 420.0,
"slop": 3,
"max_expansions": 10
}
}
}
]
}
},
{
"nested": {
"path": "tags",
"query": {
"dis_max": {
"queries": [
{
"match": {
"tags.name.search": {
"query": "best grip",
"boost": 800.0,
"fuzziness": 1,
"operator": "and"
}
}
},
{
"match_phrase_prefix": {
"tags.name.search": {
"query": "best grip",
"boost": 480.0,
"slop": 3,
"max_expansions": 10
}
}
}
]
}
}
}
},
{
"dis_max": {
"queries": [
{
"match": {
"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "best grip",
"boost": 800.0,
"fuzziness": 1,
"operator": "and"
}
}
},
{
"match_phrase_prefix": {
"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "best grip",
"boost": 480.0,
"slop": 3,
"max_expansions": 10
}
}
}
]
}
},
{
"dis_max": {
"queries": [
{
"match": {
"description.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "best grip",
"boost": 250.0,
"fuzziness": "auto",
"operator": "and"
}
}
},
{
"match_phrase_prefix": {
"description.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "best grip",
"boost": 150.0,
"slop": 3,
"max_expansions": 10
}
}
}
]
}
},
{
"nested": {
"path": "categories",
"query": {
"dis_max": {
"queries": [
{
"match": {
"categories.name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "best grip",
"boost": 200.0,
"fuzziness": "auto",
"operator": "and"
}
}
},
{
"match_phrase_prefix": {
"categories.name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "best grip",
"boost": 120.0,
"slop": 3,
"max_expansions": 10
}
}
}
]
}
}
}
}
]
}
}
]
}
}
]
}
},
"aggregations": {
"manufacturer": {
"terms": {
"field": "manufacturerId",
"size": 10000
}
},
"price": {
"stats": {
"script": {
"source": "double getPrice(def accessors, def doc, def decimals, def round, def multiplier) {\n for (accessor in accessors) {\n def key = accessor['key'];\n\n if (!doc.containsKey(key) || doc[key].empty) {\n continue;\n }\n\n def factor = accessor['factor'];\n def value = doc[key].value * factor;\n\n value = Math.round(value * decimals);\n value = (double) value \/ decimals;\n\n if (!round) {\n return (double) value;\n }\n\n value = Math.round(value * multiplier);\n\n value = (double) value \/ multiplier;\n\n return (double) value;\n }\n\n return 0;\n}\n\nreturn getPrice(params['accessors'], doc, params['decimals'], params['round'], params['multiplier']);\n",
"lang": "painless",
"params": {
"accessors": [
{
"key": "cheapest_price_rule76a1b37a7dbf4165b46c7ab2ff1a4841_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule56b8897938be44a48f5d23076fee8aa4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179b5053d723cbcc2ffca7e2f1d37_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179b50593737ca9f4a6695a28df19_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179b505a971d6b33bc2b7f77ff188_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179b50779728dbd34b221819dbf1f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179b5077e722793b82b3113582988_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019266bd95457bad916f0e7402a76e90_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule89396462b19442de853b499f33b78cef_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule8a3d72aab5a5468fa089505163f644f9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rulef9da93f84ada4ccd8efd95692a615991_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule06c3e6c40cde40fb88ada175db3b7938_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed59dd72ecb5248c3701a4a9a7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5a33735dadfaae7d48ee3774_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5a7373caa742a3ca2b474faa_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5abc7260ba0d7f86a5f49012_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5ae473cc8acbdbd09e697f1a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5afd73938316ce5d62b21885_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5b3472fb8689bff52c36d24e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5b47710cbb88d4cabe575530_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5b657021952452aa52c2f262_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5b887386bf07cbfb0c6dc4d9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5bb77063b42436de2bb2654d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5be971dfb78ef0b9ab954636_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5c0f732b83a6fa611b17c9b0_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5c1c72e1bd5dd45fa91ae988_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5c48709db0bb1d772acb893a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5c61739288a8f19f5fee5c9f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5c83710a9f725ed88fa40977_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5cb47127996aaac8a7f6bdbe_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5ce97102b94464fe862ca787_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5d78715b957280e0dd517331_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5e047192aaa473cfc729c45f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5e987014b27850d1f01683cb_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5eb972a9811e6559447a6fdc_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5f01707fbf3a6adca420f5b1_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5f4a728eb343c4ceca55df24_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5fc1716ab9e26008508a989e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed601171ca8bcbf7c4e4b15d12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed604073a8a7cc7283597bc561_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed6086727a8ed87d86b79ab028_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed60bb7173b3c5caa2b21a03e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed611b719b8c493426397e071b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed616973d6ae87df29ca6fab45_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed617970548b9ab2028aaccee3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed61d27021a6d3f256f1fe6301_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed6233707282cee72b0a78165c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed629f739f81ef49fbfd3175b8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed630d72bfb80b0b616e56f094_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed632870c88f4d50e0091bdc8d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed6337724eaaf100fe723a9c73_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed63797281ae1e4a20fee27b7e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed63a670b0b0b52d88b864e4db_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed63dc70b69dd94cbfea630307_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed63ff71859ac60b2064da4af9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule892bba83aadf4e539a3c6a1446af67c3_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": 10,
"timed_out": false,
"terminated_early": true,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"max_score": null,
"hits": []
},
"aggregations": {
"shipping-free-filter": {
"doc_count": 0,
"shipping-free": {
"value": null
}
},
"rating-exists": {
"doc_count": 93,
"rating": {
"value": 0.0
}
},
"price": {
"count": 93,
"min": 6.0,
"max": 3587.5,
"avg": 1661.6344086021506,
"sum": 154532.0
},
"options": {
"doc_count": 142,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "73faafd9d2d04d3a95d6c8c8dd0e0cfe",
"doc_count": 13
},
{
"key": "cbe6fff377034cd1affb3b6732f4688a",
"doc_count": 13
},
{
"key": "ca8afcbfac0c4f9884a8e96d9a3cfd64",
"doc_count": 8
},
{
"key": "de03fd9e389f48e9b917c4a56f4f68a4",
"doc_count": 8
},
{
"key": "018e79df44e47150bfcf1a6ab2019711",
"doc_count": 6
},
{
"key": "018e79dfe55073e9b867dc8674816684",
"doc_count": 6
},
{
"key": "0fe89b90020044f0a36cc299239182b7",
"doc_count": 6
},
{
"key": "d12dea57cba443dfa6c2342399c622e3",
"doc_count": 6
},
{
"key": "5934b669c5dd46b096e9efdeb36a377d",
"doc_count": 4
},
{
"key": "601ec43b01a14a4c861ccea0f7c58eab",
"doc_count": 4
},
{
"key": "6ae943f86f0e4073ad7a49ddac8620eb",
"doc_count": 4
},
{
"key": "8ddb32697962456fb45cfa08eb7d1c05",
"doc_count": 4
},
{
"key": "e6e03acfd212445f99f32bcb33eb9257",
"doc_count": 4
},
{
"key": "0d784a285c334109ac26e4b9931aa9fb",
"doc_count": 3
},
{
"key": "6161c3ac1b684e7ca53b26e1dd93c8a3",
"doc_count": 3
},
{
"key": "78910b5e204149bba85d3461c7036911",
"doc_count": 3
},
{
"key": "ff8421c502b34c2f99ce02d2c36fe070",
"doc_count": 3
},
{
"key": "0194daeab4b97641b0e57a7321e751ee",
"doc_count": 2
},
{
"key": "2ce12c3ad66b40f5908909296de597a1",
"doc_count": 2
},
{
"key": "d8a3f0b3bb3e44abb65f07ef3bf338ee",
"doc_count": 2
},
{
"key": "ea8b798855ce41a295a0527206a91665",
"doc_count": 2
},
{
"key": "021cdf72ee9f4f858326d58cb62bf3cb",
"doc_count": 1
},
{
"key": "02b58f8ec7ae43179b5eee7a8d18cb5f",
"doc_count": 1
},
{
"key": "02c4701a32b94fa39a949aa8a736ff6e",
"doc_count": 1
},
{
"key": "1b419dccb36f4dbbb1458ce368286c91",
"doc_count": 1
},
{
"key": "1c7c8a5a35a24de3a6c333f7306f711f",
"doc_count": 1
},
{
"key": "2571eb58eabe401aa149ee974e083e9c",
"doc_count": 1
},
{
"key": "2900a04a863e42d8a034014c66e4c316",
"doc_count": 1
},
{
"key": "2c63eef15d9344ad8215c6150477a7af",
"doc_count": 1
},
{
"key": "2db99c3e84a64067add381136d262ac0",
"doc_count": 1
},
{
"key": "512c172f048344e2a64de87698296843",
"doc_count": 1
},
{
"key": "5464edbd5ec3414497d31b50cf2a2c91",
"doc_count": 1
},
{
"key": "642f0b2cec9d4da4af9eb9dd321c8294",
"doc_count": 1
},
{
"key": "6669baf334934fe383a2f5531967f0a0",
"doc_count": 1
},
{
"key": "6a20204b2c734b4199e0411b22ed36df",
"doc_count": 1
},
{
"key": "70d1562ea5034cadb1c2703956c32c62",
"doc_count": 1
},
{
"key": "79193a9d433c42be8fe834700acdbcc8",
"doc_count": 1
},
{
"key": "7ed489ee71834a96a8e571b80196cd7f",
"doc_count": 1
},
{
"key": "841e5969416e4f10a349f5371cf65fc1",
"doc_count": 1
},
{
"key": "8520392939334d1392f1fb5d24044baa",
"doc_count": 1
},
{
"key": "8a8cfe65fb174a4385629cd45871b392",
"doc_count": 1
},
{
"key": "8fec61c54671499899faf6f3a0fbc1a8",
"doc_count": 1
},
{
"key": "96e7d9bbd19041cfb7edde1861ffb835",
"doc_count": 1
},
{
"key": "99e56925faed4a9892593f375617a656",
"doc_count": 1
},
{
"key": "a2a7335580a64d9b90723c9fa7cff278",
"doc_count": 1
},
{
"key": "a2e7e1f1007844a781cfdfbccf29dc26",
"doc_count": 1
},
{
"key": "c082efcaf941492885ccc3fb684912b9",
"doc_count": 1
},
{
"key": "c79a4db2cc98475d825925e0b9df700e",
"doc_count": 1
},
{
"key": "cf30054570074661ba9db8ce242bf8f8",
"doc_count": 1
},
{
"key": "d46e42d3e07b4ce68d3cb17e78ff2a90",
"doc_count": 1
},
{
"key": "d8a4fa28091b42be8e46178251f6c6f4",
"doc_count": 1
},
{
"key": "d8bc5b591a1c4adab6907df653325fda",
"doc_count": 1
},
{
"key": "dae3a22a7ad04ad1ad41d3b4988da285",
"doc_count": 1
},
{
"key": "dc0a770d6bb54757a3195a257ac915d1",
"doc_count": 1
},
{
"key": "dc537654319e4764a2911830f02b6ebf",
"doc_count": 1
},
{
"key": "ed32b68b041e4a3488a4c6131b8c2de2",
"doc_count": 1
},
{
"key": "f422317bc7794349952a94550798d0a7",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 252,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "018b201bedb1789a815914eff0d5789c",
"doc_count": 44
},
{
"key": "0193930d73c379f9a7e59eb45ed93987",
"doc_count": 36
},
{
"key": "018b201c845070fbabb2a21248ef5e26",
"doc_count": 32
},
{
"key": "018b201d97c8785b9d79c70cf46e7e08",
"doc_count": 28
},
{
"key": "018b201b9485714b8b44998b55acda08",
"doc_count": 26
},
{
"key": "018b00438f8c7dffbc38f1aa32164fc0",
"doc_count": 19
},
{
"key": "018b292de71d7e4b802fcc2610d4d6b3",
"doc_count": 16
},
{
"key": "01939302c7937281857793de25f3536f",
"doc_count": 12
},
{
"key": "018b5c9eba8f72798f1bfee38337f3de",
"doc_count": 6
},
{
"key": "018b004428e6712597365e504b16d2d9",
"doc_count": 5
},
{
"key": "018b1038f12c7e7895e607e84da8e899",
"doc_count": 4
},
{
"key": "018b291f168771219bdc4badd6e23aa2",
"doc_count": 4
},
{
"key": "018b058defc57c7d9c9e63993c39d2a3",
"doc_count": 3
},
{
"key": "018b0fc8aaaa70608eb38d9f73d22de9",
"doc_count": 3
},
{
"key": "018b2963612b745e84a7442d0ea5e05e",
"doc_count": 3
},
{
"key": "018b2a0ea819738bad8e5a7a559ab3ee",
"doc_count": 3
},
{
"key": "018b5caa8a76725ab7b3bcf1e1169093",
"doc_count": 3
},
{
"key": "018b0fc84d757717a04c905e5b77b7a3",
"doc_count": 1
},
{
"key": "018b201bcc6d70bda9ce09b9944a4aeb",
"doc_count": 1
},
{
"key": "018b201ca9367ecd8b4001a514a913d2",
"doc_count": 1
},
{
"key": "018b2908bd94782e8b52a12e6147d304",
"doc_count": 1
},
{
"key": "018b5cb0d21f7094b2f518701699bf00",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "01912bf61d8571c9ad4f7776307ae6ca",
"doc_count": 45
},
{
"key": "1843652dadb745df81d87fa1d5b929a7",
"doc_count": 42
},
{
"key": "01912bf68c9e70cdae5c68a40bf9286d",
"doc_count": 2
},
{
"key": "01912bf67658704992423148ee48827d",
"doc_count": 1
},
{
"key": "01912bf6799572d4b7f9de36c0cd4cd8",
"doc_count": 1
},
{
"key": "01912bf68abc72a0a397e5716c9b6fee",
"doc_count": 1
},
{
"key": "01912bf68c417208afbf6067addf7d78",
"doc_count": 1
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|