| 1 |
10.51 ms |
Request:
{"index":"sw_dev_product","search_type":"query_then_fetch","track_total_hits":true,"body":{"post_filter":{"bool":{"filter":[{"bool":{"must":[{"script":{"script":{"inline":"double getPrice(def accessors, def doc, def decimals, def round, def multiplier) {\n for (accessor in accessors) {\n def key = accessor['key'];\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\ndef price = getPrice(params['accessors'], doc, params['decimals'], params['round'], params['multiplier']);\n\ndef match = true;\nif (params.containsKey('gte')) {\n match = match && price >= params['gte'];\n}\nif (params.containsKey('gt')) {\n match = match && price > params['gt'];\n}\nif (params.containsKey('lte')) {\n match = match && price <= params['lte'];\n}\nif (params.containsKey('lt')) {\n match = match && price < params['lt'];\n}\n\nreturn match;\n","params":{"gte":10.0,"lte":500.0,"accessors":[{"key":"cheapest_price_rule471f2ca5e74440568ba57912bb0f3d50_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc757970f38af8d735ac2bef24_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc757d738cb8f62b8ca13162fd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc781372e48ae25e3fc49e6c75_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5c9aba570cdb1eb3cecd2cd9c14_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5c9abd170d5a439e74a4020e81c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule018c7cebb95d7085930868a24624ed56_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc758c718ca89324f9e2d1b64e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc758c718ca89324f9e3bbcdfd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5c9ab9b73b8b6ca8da792e44880_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1}],"decimals":100,"round":true,"multiplier":100.0}}}},{"range":{"ratingAverage":{"gte":5.0}}},{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["89ee44dcf85c46718ba0744360e5fcc1"]}}}}]}}]}},{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["3adaca5df47943339a045e91f212ee90","b2e857ff4b84401caef408741cc18d83","2e9dc36608504cd0bd340d135922df23","87c89b5844a0436db7e7bebadfa24d5f","1339fc04d1b14eedae5c6cb1269b34af","b78d026c06064f24b92e69b8e1feadb0","eb1bb24fb4a64c9295a69f327f7a5899","b69d2b1c914342ecb0a0ba8cc0980393","4e33f457de524946ab593df85fba15ed"]}}}}]}}]}},{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["a2e3ce1f6e7241a783db0a98b0003a84"]}}}}]}}]}}]}}]}},"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":20}}},{"term":{"visibilities.salesChannelId":"0189b5bd293f71c6a5e92e9980f13639"}}]}}}},{"term":{"active":true}}]}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}},{"bool":{"must_not":[{"bool":{"must":[{"term":{"isCloseout":true}},{"term":{"available":false}}]}}]}}]}}],"must":[{"function_score":{"query":{"bool":{"should":[{"wildcard":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b":{"value":"no*","boost":800}}},{"wildcard":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b":{"value":"*no*","boost":400}}},{"match_phrase_prefix":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"no","boost":240,"slop":1}}},{"match":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram":{"query":"no","boost":100,"fuzziness":"auto"}}},{"match":{"productNumber.ngram":{"query":"no","boost":150,"fuzziness":"auto"}}},{"match":{"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"no","boost":40,"fuzziness":"auto"}}},{"match_phrase_prefix":{"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram":{"query":"no","boost":40,"slop":1}}},{"match":{"ean.search":{"query":"no","boost":100,"fuzziness":0}}},{"match":{"manufacturerNumber.ngram":{"query":"no","boost":100,"fuzziness":0}}}],"minimum_should_match":"1"}},"functions":[{"field_value_factor":{"field":"sales","factor":0.0001,"modifier":"sqrt"}}]}},{"bool":{"should":[{"wildcard":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b":{"value":"no*","boost":800}}},{"wildcard":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b":{"value":"*no*","boost":400}}},{"match_phrase_prefix":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"no","boost":240,"slop":1}}},{"match":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram":{"query":"no","boost":100,"fuzziness":"auto"}}},{"match":{"productNumber.ngram":{"query":"no","boost":150,"fuzziness":"auto"}}},{"match":{"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"no","boost":40,"fuzziness":"auto"}}},{"match_phrase_prefix":{"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram":{"query":"no","boost":40,"slop":1}}},{"match":{"ean.search":{"query":"no","boost":100,"fuzziness":0}}},{"match":{"manufacturerNumber.ngram":{"query":"no","boost":100,"fuzziness":0}}}],"minimum_should_match":"1"}}]}},"sort":[{"jtlorder":{"order":"ASC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-filtered-count":{"filter":{"bool":{"must":[{"script":{"script":{"inline":"double getPrice(def accessors, def doc, def decimals, def round, def multiplier) {\n for (accessor in accessors) {\n def key = accessor['key'];\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\ndef price = getPrice(params['accessors'], doc, params['decimals'], params['round'], params['multiplier']);\n\ndef match = true;\nif (params.containsKey('gte')) {\n match = match && price >= params['gte'];\n}\nif (params.containsKey('gt')) {\n match = match && price > params['gt'];\n}\nif (params.containsKey('lte')) {\n match = match && price <= params['lte'];\n}\nif (params.containsKey('lt')) {\n match = match && price < params['lt'];\n}\n\nreturn match;\n","params":{"gte":10.0,"lte":500.0,"accessors":[{"key":"cheapest_price_rule471f2ca5e74440568ba57912bb0f3d50_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc757970f38af8d735ac2bef24_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc757d738cb8f62b8ca13162fd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc781372e48ae25e3fc49e6c75_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5c9aba570cdb1eb3cecd2cd9c14_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5c9abd170d5a439e74a4020e81c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule018c7cebb95d7085930868a24624ed56_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc758c718ca89324f9e2d1b64e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc758c718ca89324f9e3bbcdfd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5c9ab9b73b8b6ca8da792e44880_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1}],"decimals":100,"round":true,"multiplier":100.0}}}},{"range":{"ratingAverage":{"gte":5.0}}},{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["89ee44dcf85c46718ba0744360e5fcc1"]}}}}]}}]}},{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["3adaca5df47943339a045e91f212ee90","b2e857ff4b84401caef408741cc18d83","2e9dc36608504cd0bd340d135922df23","87c89b5844a0436db7e7bebadfa24d5f","1339fc04d1b14eedae5c6cb1269b34af","b78d026c06064f24b92e69b8e1feadb0","eb1bb24fb4a64c9295a69f327f7a5899","b69d2b1c914342ecb0a0ba8cc0980393","4e33f457de524946ab593df85fba15ed"]}}}}]}}]}},{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["a2e3ce1f6e7241a783db0a98b0003a84"]}}}}]}}]}}]}},"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}}}},"from":0,"size":1,"collapse":{"field":"displayGroup"},"timeout":"5s"}}
POST http://10.20.0.3:9200/sw_dev_product/_search?search_type=query_then_fetch&track_total_hits=1
Accept: application/json
Content-Type: application/json
{
"post_filter": {
"bool": {
"filter": [
{
"bool": {
"must": [
{
"script": {
"script": {
"inline": "double getPrice(def accessors, def doc, def decimals, def round, def multiplier) {\n for (accessor in accessors) {\n def key = accessor['key'];\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\ndef price = getPrice(params['accessors'], doc, params['decimals'], params['round'], params['multiplier']);\n\ndef match = true;\nif (params.containsKey('gte')) {\n match = match && price >= params['gte'];\n}\nif (params.containsKey('gt')) {\n match = match && price > params['gt'];\n}\nif (params.containsKey('lte')) {\n match = match && price <= params['lte'];\n}\nif (params.containsKey('lt')) {\n match = match && price < params['lt'];\n}\n\nreturn match;\n",
"params": {
"gte": 10.0,
"lte": 500.0,
"accessors": [
{
"key": "cheapest_price_rule471f2ca5e74440568ba57912bb0f3d50_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5bc757970f38af8d735ac2bef24_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5bc757d738cb8f62b8ca13162fd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5bc781372e48ae25e3fc49e6c75_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5c9aba570cdb1eb3cecd2cd9c14_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5c9abd170d5a439e74a4020e81c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule018c7cebb95d7085930868a24624ed56_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5bc758c718ca89324f9e2d1b64e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5bc758c718ca89324f9e3bbcdfd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5c9ab9b73b8b6ca8da792e44880_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
}
],
"decimals": 100,
"round": true,
"multiplier": 100.0
}
}
}
},
{
"range": {
"ratingAverage": {
"gte": 5.0
}
}
},
{
"bool": {
"should": [
{
"bool": {
"must_not": [
{
"nested": {
"path": "categories",
"query": {
"terms": {
"categories.id": [
"89ee44dcf85c46718ba0744360e5fcc1"
]
}
}
}
}
]
}
}
]
}
},
{
"bool": {
"should": [
{
"bool": {
"must_not": [
{
"nested": {
"path": "categories",
"query": {
"terms": {
"categories.id": [
"3adaca5df47943339a045e91f212ee90",
"b2e857ff4b84401caef408741cc18d83",
"2e9dc36608504cd0bd340d135922df23",
"87c89b5844a0436db7e7bebadfa24d5f",
"1339fc04d1b14eedae5c6cb1269b34af",
"b78d026c06064f24b92e69b8e1feadb0",
"eb1bb24fb4a64c9295a69f327f7a5899",
"b69d2b1c914342ecb0a0ba8cc0980393",
"4e33f457de524946ab593df85fba15ed"
]
}
}
}
}
]
}
}
]
}
},
{
"bool": {
"should": [
{
"bool": {
"must_not": [
{
"nested": {
"path": "categories",
"query": {
"terms": {
"categories.id": [
"a2e3ce1f6e7241a783db0a98b0003a84"
]
}
}
}
}
]
}
}
]
}
}
]
}
}
]
}
},
"query": {
"bool": {
"filter": [
{
"bool": {
"must": [
{
"bool": {
"must": [
{
"nested": {
"path": "visibilities",
"query": {
"bool": {
"must": [
{
"range": {
"visibilities.visibility": {
"gte": 20
}
}
},
{
"term": {
"visibilities.salesChannelId": "0189b5bd293f71c6a5e92e9980f13639"
}
}
]
}
}
}
},
{
"term": {
"active": true
}
}
]
}
},
{
"bool": {
"must_not": [
{
"bool": {
"must_not": [
{
"exists": {
"field": "displayGroup"
}
}
]
}
}
]
}
},
{
"bool": {
"must_not": [
{
"bool": {
"must": [
{
"term": {
"isCloseout": true
}
},
{
"term": {
"available": false
}
}
]
}
}
]
}
}
]
}
}
],
"must": [
{
"function_score": {
"query": {
"bool": {
"should": [
{
"wildcard": {
"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"value": "no*",
"boost": 800
}
}
},
{
"wildcard": {
"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"value": "*no*",
"boost": 400
}
}
},
{
"match_phrase_prefix": {
"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "no",
"boost": 240,
"slop": 1
}
}
},
{
"match": {
"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram": {
"query": "no",
"boost": 100,
"fuzziness": "auto"
}
}
},
{
"match": {
"productNumber.ngram": {
"query": "no",
"boost": 150,
"fuzziness": "auto"
}
}
},
{
"match": {
"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "no",
"boost": 40,
"fuzziness": "auto"
}
}
},
{
"match_phrase_prefix": {
"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram": {
"query": "no",
"boost": 40,
"slop": 1
}
}
},
{
"match": {
"ean.search": {
"query": "no",
"boost": 100,
"fuzziness": 0
}
}
},
{
"match": {
"manufacturerNumber.ngram": {
"query": "no",
"boost": 100,
"fuzziness": 0
}
}
}
],
"minimum_should_match": "1"
}
},
"functions": [
{
"field_value_factor": {
"field": "sales",
"factor": 0.0001,
"modifier": "sqrt"
}
}
]
}
},
{
"bool": {
"should": [
{
"wildcard": {
"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"value": "no*",
"boost": 800
}
}
},
{
"wildcard": {
"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"value": "*no*",
"boost": 400
}
}
},
{
"match_phrase_prefix": {
"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "no",
"boost": 240,
"slop": 1
}
}
},
{
"match": {
"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram": {
"query": "no",
"boost": 100,
"fuzziness": "auto"
}
}
},
{
"match": {
"productNumber.ngram": {
"query": "no",
"boost": 150,
"fuzziness": "auto"
}
}
},
{
"match": {
"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "no",
"boost": 40,
"fuzziness": "auto"
}
}
},
{
"match_phrase_prefix": {
"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram": {
"query": "no",
"boost": 40,
"slop": 1
}
}
},
{
"match": {
"ean.search": {
"query": "no",
"boost": 100,
"fuzziness": 0
}
}
},
{
"match": {
"manufacturerNumber.ngram": {
"query": "no",
"boost": 100,
"fuzziness": 0
}
}
}
],
"minimum_should_match": "1"
}
}
]
}
},
"sort": [
{
"jtlorder": {
"order": "ASC"
}
},
{
"id": {
"order": "ASC"
}
}
],
"aggregations": {
"total-filtered-count": {
"filter": {
"bool": {
"must": [
{
"script": {
"script": {
"inline": "double getPrice(def accessors, def doc, def decimals, def round, def multiplier) {\n for (accessor in accessors) {\n def key = accessor['key'];\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\ndef price = getPrice(params['accessors'], doc, params['decimals'], params['round'], params['multiplier']);\n\ndef match = true;\nif (params.containsKey('gte')) {\n match = match && price >= params['gte'];\n}\nif (params.containsKey('gt')) {\n match = match && price > params['gt'];\n}\nif (params.containsKey('lte')) {\n match = match && price <= params['lte'];\n}\nif (params.containsKey('lt')) {\n match = match && price < params['lt'];\n}\n\nreturn match;\n",
"params": {
"gte": 10.0,
"lte": 500.0,
"accessors": [
{
"key": "cheapest_price_rule471f2ca5e74440568ba57912bb0f3d50_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5bc757970f38af8d735ac2bef24_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5bc757d738cb8f62b8ca13162fd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5bc781372e48ae25e3fc49e6c75_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5c9aba570cdb1eb3cecd2cd9c14_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5c9abd170d5a439e74a4020e81c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule018c7cebb95d7085930868a24624ed56_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5bc758c718ca89324f9e2d1b64e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5bc758c718ca89324f9e3bbcdfd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5c9ab9b73b8b6ca8da792e44880_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
}
],
"decimals": 100,
"round": true,
"multiplier": 100.0
}
}
}
},
{
"range": {
"ratingAverage": {
"gte": 5.0
}
}
},
{
"bool": {
"should": [
{
"bool": {
"must_not": [
{
"nested": {
"path": "categories",
"query": {
"terms": {
"categories.id": [
"89ee44dcf85c46718ba0744360e5fcc1"
]
}
}
}
}
]
}
}
]
}
},
{
"bool": {
"should": [
{
"bool": {
"must_not": [
{
"nested": {
"path": "categories",
"query": {
"terms": {
"categories.id": [
"3adaca5df47943339a045e91f212ee90",
"b2e857ff4b84401caef408741cc18d83",
"2e9dc36608504cd0bd340d135922df23",
"87c89b5844a0436db7e7bebadfa24d5f",
"1339fc04d1b14eedae5c6cb1269b34af",
"b78d026c06064f24b92e69b8e1feadb0",
"eb1bb24fb4a64c9295a69f327f7a5899",
"b69d2b1c914342ecb0a0ba8cc0980393",
"4e33f457de524946ab593df85fba15ed"
]
}
}
}
}
]
}
}
]
}
},
{
"bool": {
"should": [
{
"bool": {
"must_not": [
{
"nested": {
"path": "categories",
"query": {
"terms": {
"categories.id": [
"a2e3ce1f6e7241a783db0a98b0003a84"
]
}
}
}
}
]
}
}
]
}
}
]
}
},
"aggregations": {
"total-count": {
"cardinality": {
"field": "displayGroup"
}
}
}
}
},
"from": 0,
"size": 1,
"collapse": {
"field": "displayGroup"
},
"timeout": "5s"
}
{
"took": 4,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 5,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_dev_product_1737186629",
"_id": "0189b5cf1ccb7234a4866fd8781cac8e",
"_score": null,
"_source": {
"purchasePrices": [
{
"currencyId": "b7d2554b0ce847cd82f3ac9bd1c0dfca",
"net": 0.05,
"gross": 0.0595,
"linked": true,
"listPrice": null
}
],
"referenceUnit": "0.000",
"purchaseUnit": "1.0000",
"unit": {
"id": "0189b5cf096972eba234380aea82e89d",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "St\u00fcck",
"0189b5bd28fd735a9afc1ef90696fc66": null
},
"shortCode": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Stck.",
"0189b5bd28fd735a9afc1ef90696fc66": null
},
"_count": 1
},
"crossSellings": [
{
"id": "2ec01d46cc81430592572df14a698d7f",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shopware-CrossSelling"
}
}
],
"keywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Diagnosesoftware, Rauchmelder, FireAngel ST-622, TTL-Treiber-Software, Diagnostik-Kabel, USB-Anschluss, PC, Laptop, St\u00f6rungsanalyse",
"0189b5bd28fd735a9afc1ef90696fc66": null
},
"packUnit": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "St\u00fcck",
"0189b5bd28fd735a9afc1ef90696fc66": null
},
"packUnitPlural": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"0189b5bd28fd735a9afc1ef90696fc66": null
},
"id": "0189b5cf1ccb7234a4866fd8781cac8e",
"autoIncrement": 2168.0,
"ratingAverage": 5.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "0189b5bd293f71c6a5e92e9980f13639"
}
],
"availableStock": 400,
"productNumber": "st-622-diagnostik-kabel",
"ean": null,
"displayGroup": "009e58575e4e17999f060e0827b8272f",
"sales": 44,
"stock": 400,
"weight": 0.05,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "0189b5ced52270e1b9c399e55e18cddb",
"manufacturerNumber": "F Fireangel ST-622 Diagnose Kabel",
"releaseDate": null,
"createdAt": "2019-05-02T00:00:00+00:00",
"categoryTree": [
"ed73937c1fc54757a390ffc31536aa0d",
"d7b7b163000841a1876dbff5548c039f",
"007e76a8f7bd4c19b44bbbf38602c288",
"4a453f9c54f44e98a179107ea4d9afb1",
"84b92b7a69f94e26a86a6af4b5506407",
"96137c8486db47b28e4c53cd50be51de"
],
"categoriesRo": [
{
"id": "ed73937c1fc54757a390ffc31536aa0d",
"_count": 1
},
{
"id": "d7b7b163000841a1876dbff5548c039f",
"_count": 1
},
{
"id": "007e76a8f7bd4c19b44bbbf38602c288",
"_count": 1
},
{
"id": "4a453f9c54f44e98a179107ea4d9afb1",
"_count": 1
},
{
"id": "84b92b7a69f94e26a86a6af4b5506407",
"_count": 1
},
{
"id": "96137c8486db47b28e4c53cd50be51de",
"_count": 1
}
],
"taxId": "0189b5bc757f71079ecf17a5e531d81e",
"tags": [],
"parentId": null,
"coverId": "554dffecd3d54086983f185e98ea623e",
"childCount": 0,
"categories": [
{
"id": "4a453f9c54f44e98a179107ea4d9afb1",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "8071 - Fire Angel"
}
},
{
"id": "84b92b7a69f94e26a86a6af4b5506407",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sale"
}
},
{
"id": "96137c8486db47b28e4c53cd50be51de",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Rauchwarnmelder"
}
}
],
"manufacturer": {
"id": "0189b5ced52270e1b9c399e55e18cddb",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "FireAngel",
"0189b5bd28fd735a9afc1ef90696fc66": null
},
"_count": 1
},
"properties": [],
"options": [],
"categoryIds": [
"4a453f9c54f44e98a179107ea4d9afb1",
"84b92b7a69f94e26a86a6af4b5506407",
"96137c8486db47b28e4c53cd50be51de"
],
"optionIds": [],
"propertyIds": [],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"attr3": "{\"academy_product\":{\"id\":\"1\",\"name\":\"academy_product\",\"label\":\"Akademie Artikel\",\"description\":\"1 = Ja \\\/ 0 = Nein\",\"type\":\"text\",\"date_create\":\"2019-06-27 10:52:26\",\"date_edit\":\"2019-06-27 10:52:26\",\"active\":\"1\",\"value\":\"\"}}",
"attr5": "[]",
"attr6": "121.2000000000",
"attr9": "{\"shipping\":null,\"quantity\":0,\"cuttedCount\":0,\"available\":400,\"deliveries\":[],\"warehouses\":[]}",
"jtlorder": "1200",
"releasedate": "21.12.2022",
"tarcode": "85444993"
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "ST-622 Diagnostik Kabel",
"0189b5bd28fd735a9afc1ef90696fc66": null
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Diagnosesoftware f\u00fcr den geschulten und qualifizierten Dienstleister und Fachh\u00e4ndler\nMit dieser Software ist eine objektive Melder- und St\u00f6rungsanalyse m\u00f6glich. Ermittlung von nutzer- und\/oder umbebungsbedingten St\u00f6rungen. Auswertung verschiedener relevanter Messwerte aus dem Ereignisspeicher des Rauchwarnmelders, Batteriespannung, Stromaufnahme, Verschmutzungsgrad, Kalibrierungseinstellungen usw. Auslesung des Ereignisspeiches mit Listung der letzten Alarme, Testalarme usw. Lokales Speichern und Ausdrucken der Ergebnisse auf PC \/ Laptop m\u00f6glich. \nLieferumfang:\n\nSoftware f\u00fcr den Rauchmelder FireAngel ST-622, TTL-Treiber-Software \nDiagnostik-Kabel mit USB-Anschluss f\u00fcr PC oder Laptop \nausf\u00fchrliche Bedienungsanleitung \nobjektive Melder- und St\u00f6ranalyse \nErmittlung von nutzer- und\/oder umgebungsbedingten St\u00f6rungen \nAuswertung verschiedener realer Messwerte aus dem Ereignisspeicherdes Rauchmelders, wie Batteriespannung, Stromaufnahme, \nVerschmutzungsgrad, Kalibrierungseinstellungen \nListung der letzten Alarme (max. 10) \ngrafische Darstellung der Ergebnisse am Bildschirm \nlokales Speichern der Ergebnisse auf dem PC \/ Laptop m\u00f6glich ",
"0189b5bd28fd735a9afc1ef90696fc66": null
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "ST-622 Diagnostik Kabel - Professionelle Melderanalyse | EPS",
"0189b5bd28fd735a9afc1ef90696fc66": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Erleben Sie die ST-622 Diagnostik Kabel, eine professionelle Diagnosesoftware f\u00fcr den geschulten und qualifizierten Dienstleister und Fachh\u00e4ndler.",
"0189b5bd28fd735a9afc1ef90696fc66": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": [
"ST-622",
"Diagnostik",
"Kabel",
"Rauchmelder",
"FireAngel",
"Software",
"USB-Anschluss",
"PC",
"Laptop",
"St\u00f6rungsanalyse",
"EPS"
],
"0189b5bd28fd735a9afc1ef90696fc66": null
},
"cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 75.7197,
"cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 63.63,
"cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 35.73,
"cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 35.73,
"cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 72.114,
"cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 60.6,
"cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 38.79,
"cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 38.79,
"cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 72.114,
"cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 60.6,
"cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 38.79,
"cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 38.79,
"cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 72.114,
"cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 60.6,
"cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 38.79,
"cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 38.79,
"cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 72.114,
"cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 60.6,
"cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 38.79,
"cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 38.79,
"cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 72.114,
"cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 60.6,
"cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 38.79,
"cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 38.79,
"cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 144.228,
"cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 121.2,
"cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": -22.42,
"cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": -22.42,
"cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 72.114,
"cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 60.6,
"cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 38.79,
"cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 38.79,
"cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 144.228,
"cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 121.2,
"cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": -22.42,
"cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": -22.42,
"cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 72.114,
"cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 60.6,
"cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 38.79,
"cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 38.79,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 144.228,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 121.2,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": -22.42,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": -22.42,
"warehouseGroups": [
{
"id": null,
"_count": 0
}
],
"completion": [
"st-622",
"diagnostik",
"kabel",
"st-622 diagnostik kabel"
]
},
"fields": {
"displayGroup": [
"009e58575e4e17999f060e0827b8272f"
]
},
"sort": [
9223372036854775807,
"0189b5cf1ccb7234a4866fd8781cac8e"
]
}
]
},
"aggregations": {
"total-filtered-count": {
"doc_count": 5,
"total-count": {
"value": 5
}
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
5.54 ms |
Request:
{"index":"sw_dev_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":20}}},{"term":{"visibilities.salesChannelId":"0189b5bd293f71c6a5e92e9980f13639"}}]}}}},{"term":{"active":true}}]}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}},{"bool":{"must_not":[{"bool":{"must":[{"term":{"isCloseout":true}},{"term":{"available":false}}]}}]}}]}}],"must":[{"function_score":{"query":{"bool":{"should":[{"wildcard":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b":{"value":"no*","boost":800}}},{"wildcard":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b":{"value":"*no*","boost":400}}},{"match_phrase_prefix":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"no","boost":240,"slop":1}}},{"match":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram":{"query":"no","boost":100,"fuzziness":"auto"}}},{"match":{"productNumber.ngram":{"query":"no","boost":150,"fuzziness":"auto"}}},{"match":{"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"no","boost":40,"fuzziness":"auto"}}},{"match_phrase_prefix":{"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram":{"query":"no","boost":40,"slop":1}}},{"match":{"ean.search":{"query":"no","boost":100,"fuzziness":0}}},{"match":{"manufacturerNumber.ngram":{"query":"no","boost":100,"fuzziness":0}}}],"minimum_should_match":"1"}},"functions":[{"field_value_factor":{"field":"sales","factor":0.0001,"modifier":"sqrt"}}]}},{"bool":{"should":[{"wildcard":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b":{"value":"no*","boost":800}}},{"wildcard":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b":{"value":"*no*","boost":400}}},{"match_phrase_prefix":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"no","boost":240,"slop":1}}},{"match":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram":{"query":"no","boost":100,"fuzziness":"auto"}}},{"match":{"productNumber.ngram":{"query":"no","boost":150,"fuzziness":"auto"}}},{"match":{"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"no","boost":40,"fuzziness":"auto"}}},{"match_phrase_prefix":{"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram":{"query":"no","boost":40,"slop":1}}},{"match":{"ean.search":{"query":"no","boost":100,"fuzziness":0}}},{"match":{"manufacturerNumber.ngram":{"query":"no","boost":100,"fuzziness":0}}}],"minimum_should_match":"1"}}]}},"aggregations":{"manufacturer":{"terms":{"field":"manufacturerId","size":10000}},"price":{"stats":{"script":{"id":"cheapest_price","params":{"accessors":[{"key":"cheapest_price_rule471f2ca5e74440568ba57912bb0f3d50_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc757970f38af8d735ac2bef24_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc757d738cb8f62b8ca13162fd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc781372e48ae25e3fc49e6c75_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5c9aba570cdb1eb3cecd2cd9c14_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5c9abd170d5a439e74a4020e81c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule018c7cebb95d7085930868a24624ed56_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc758c718ca89324f9e2d1b64e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc758c718ca89324f9e3bbcdfd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5c9ab9b73b8b6ca8da792e44880_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","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":{"filter":{"script":{"script":{"inline":"double getPrice(def accessors, def doc, def decimals, def round, def multiplier) {\n for (accessor in accessors) {\n def key = accessor['key'];\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\ndef price = getPrice(params['accessors'], doc, params['decimals'], params['round'], params['multiplier']);\n\ndef match = true;\nif (params.containsKey('gte')) {\n match = match && price >= params['gte'];\n}\nif (params.containsKey('gt')) {\n match = match && price > params['gt'];\n}\nif (params.containsKey('lte')) {\n match = match && price <= params['lte'];\n}\nif (params.containsKey('lt')) {\n match = match && price < params['lt'];\n}\n\nreturn match;\n","params":{"gte":10.0,"lte":500.0,"accessors":[{"key":"cheapest_price_rule471f2ca5e74440568ba57912bb0f3d50_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc757970f38af8d735ac2bef24_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc757d738cb8f62b8ca13162fd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc781372e48ae25e3fc49e6c75_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5c9aba570cdb1eb3cecd2cd9c14_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5c9abd170d5a439e74a4020e81c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule018c7cebb95d7085930868a24624ed56_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc758c718ca89324f9e2d1b64e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc758c718ca89324f9e3bbcdfd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5c9ab9b73b8b6ca8da792e44880_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1}],"decimals":100,"round":true,"multiplier":100.0}}}},"aggregations":{"properties":{"filter":{"range":{"ratingAverage":{"gte":5.0}}},"aggregations":{"properties":{"filter":{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["89ee44dcf85c46718ba0744360e5fcc1"]}}}}]}}]}},"aggregations":{"properties":{"filter":{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["3adaca5df47943339a045e91f212ee90","b2e857ff4b84401caef408741cc18d83","2e9dc36608504cd0bd340d135922df23","87c89b5844a0436db7e7bebadfa24d5f","1339fc04d1b14eedae5c6cb1269b34af","b78d026c06064f24b92e69b8e1feadb0","eb1bb24fb4a64c9295a69f327f7a5899","b69d2b1c914342ecb0a0ba8cc0980393","4e33f457de524946ab593df85fba15ed"]}}}}]}}]}},"aggregations":{"properties":{"filter":{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["a2e3ce1f6e7241a783db0a98b0003a84"]}}}}]}}]}},"aggregations":{"properties":{"nested":{"path":"properties"},"aggregations":{"properties":{"terms":{"field":"properties.id","size":10000}}}}}}}}}}}}}},"options":{"nested":{"path":"options"},"aggregations":{"options":{"terms":{"field":"options.id","size":10000}}}},"propertiesCount":{"filter":{"script":{"script":{"inline":"double getPrice(def accessors, def doc, def decimals, def round, def multiplier) {\n for (accessor in accessors) {\n def key = accessor['key'];\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\ndef price = getPrice(params['accessors'], doc, params['decimals'], params['round'], params['multiplier']);\n\ndef match = true;\nif (params.containsKey('gte')) {\n match = match && price >= params['gte'];\n}\nif (params.containsKey('gt')) {\n match = match && price > params['gt'];\n}\nif (params.containsKey('lte')) {\n match = match && price <= params['lte'];\n}\nif (params.containsKey('lt')) {\n match = match && price < params['lt'];\n}\n\nreturn match;\n","params":{"gte":10.0,"lte":500.0,"accessors":[{"key":"cheapest_price_rule471f2ca5e74440568ba57912bb0f3d50_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc757970f38af8d735ac2bef24_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc757d738cb8f62b8ca13162fd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc781372e48ae25e3fc49e6c75_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5c9aba570cdb1eb3cecd2cd9c14_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5c9abd170d5a439e74a4020e81c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule018c7cebb95d7085930868a24624ed56_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc758c718ca89324f9e2d1b64e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc758c718ca89324f9e3bbcdfd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5c9ab9b73b8b6ca8da792e44880_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1}],"decimals":100,"round":true,"multiplier":100.0}}}},"aggregations":{"propertiesCount":{"filter":{"range":{"ratingAverage":{"gte":5.0}}},"aggregations":{"propertiesCount":{"filter":{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["89ee44dcf85c46718ba0744360e5fcc1"]}}}}]}}]}},"aggregations":{"propertiesCount":{"filter":{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["3adaca5df47943339a045e91f212ee90","b2e857ff4b84401caef408741cc18d83","2e9dc36608504cd0bd340d135922df23","87c89b5844a0436db7e7bebadfa24d5f","1339fc04d1b14eedae5c6cb1269b34af","b78d026c06064f24b92e69b8e1feadb0","eb1bb24fb4a64c9295a69f327f7a5899","b69d2b1c914342ecb0a0ba8cc0980393","4e33f457de524946ab593df85fba15ed"]}}}}]}}]}},"aggregations":{"propertiesCount":{"filter":{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["a2e3ce1f6e7241a783db0a98b0003a84"]}}}}]}}]}},"aggregations":{"propertiesCount":{"terms":{"field":"propertyIds","size":10000}}}}}}}}}}}},"brands":{"filter":{"script":{"script":{"inline":"double getPrice(def accessors, def doc, def decimals, def round, def multiplier) {\n for (accessor in accessors) {\n def key = accessor['key'];\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\ndef price = getPrice(params['accessors'], doc, params['decimals'], params['round'], params['multiplier']);\n\ndef match = true;\nif (params.containsKey('gte')) {\n match = match && price >= params['gte'];\n}\nif (params.containsKey('gt')) {\n match = match && price > params['gt'];\n}\nif (params.containsKey('lte')) {\n match = match && price <= params['lte'];\n}\nif (params.containsKey('lt')) {\n match = match && price < params['lt'];\n}\n\nreturn match;\n","params":{"gte":10.0,"lte":500.0,"accessors":[{"key":"cheapest_price_rule471f2ca5e74440568ba57912bb0f3d50_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc757970f38af8d735ac2bef24_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc757d738cb8f62b8ca13162fd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc781372e48ae25e3fc49e6c75_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5c9aba570cdb1eb3cecd2cd9c14_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5c9abd170d5a439e74a4020e81c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule018c7cebb95d7085930868a24624ed56_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc758c718ca89324f9e2d1b64e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc758c718ca89324f9e3bbcdfd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5c9ab9b73b8b6ca8da792e44880_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1}],"decimals":100,"round":true,"multiplier":100.0}}}},"aggregations":{"brands":{"filter":{"range":{"ratingAverage":{"gte":5.0}}},"aggregations":{"brands":{"filter":{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["89ee44dcf85c46718ba0744360e5fcc1"]}}}}]}}]}},"aggregations":{"brands":{"filter":{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["3adaca5df47943339a045e91f212ee90","b2e857ff4b84401caef408741cc18d83","2e9dc36608504cd0bd340d135922df23","87c89b5844a0436db7e7bebadfa24d5f","1339fc04d1b14eedae5c6cb1269b34af","b78d026c06064f24b92e69b8e1feadb0","eb1bb24fb4a64c9295a69f327f7a5899","b69d2b1c914342ecb0a0ba8cc0980393","4e33f457de524946ab593df85fba15ed"]}}}}]}}]}},"aggregations":{"brands":{"filter":{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["a2e3ce1f6e7241a783db0a98b0003a84"]}}}}]}}]}},"aggregations":{"brands":{"terms":{"field":"manufacturerId","size":10000}}}}}}}}}}}}},"size":0,"timeout":"5s"},"search_type":"query_then_fetch"}
POST http://10.20.0.3:9200/sw_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": [
{
"nested": {
"path": "visibilities",
"query": {
"bool": {
"must": [
{
"range": {
"visibilities.visibility": {
"gte": 20
}
}
},
{
"term": {
"visibilities.salesChannelId": "0189b5bd293f71c6a5e92e9980f13639"
}
}
]
}
}
}
},
{
"term": {
"active": true
}
}
]
}
},
{
"bool": {
"must_not": [
{
"bool": {
"must_not": [
{
"exists": {
"field": "displayGroup"
}
}
]
}
}
]
}
},
{
"bool": {
"must_not": [
{
"bool": {
"must": [
{
"term": {
"isCloseout": true
}
},
{
"term": {
"available": false
}
}
]
}
}
]
}
}
]
}
}
],
"must": [
{
"function_score": {
"query": {
"bool": {
"should": [
{
"wildcard": {
"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"value": "no*",
"boost": 800
}
}
},
{
"wildcard": {
"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"value": "*no*",
"boost": 400
}
}
},
{
"match_phrase_prefix": {
"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "no",
"boost": 240,
"slop": 1
}
}
},
{
"match": {
"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram": {
"query": "no",
"boost": 100,
"fuzziness": "auto"
}
}
},
{
"match": {
"productNumber.ngram": {
"query": "no",
"boost": 150,
"fuzziness": "auto"
}
}
},
{
"match": {
"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "no",
"boost": 40,
"fuzziness": "auto"
}
}
},
{
"match_phrase_prefix": {
"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram": {
"query": "no",
"boost": 40,
"slop": 1
}
}
},
{
"match": {
"ean.search": {
"query": "no",
"boost": 100,
"fuzziness": 0
}
}
},
{
"match": {
"manufacturerNumber.ngram": {
"query": "no",
"boost": 100,
"fuzziness": 0
}
}
}
],
"minimum_should_match": "1"
}
},
"functions": [
{
"field_value_factor": {
"field": "sales",
"factor": 0.0001,
"modifier": "sqrt"
}
}
]
}
},
{
"bool": {
"should": [
{
"wildcard": {
"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"value": "no*",
"boost": 800
}
}
},
{
"wildcard": {
"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"value": "*no*",
"boost": 400
}
}
},
{
"match_phrase_prefix": {
"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "no",
"boost": 240,
"slop": 1
}
}
},
{
"match": {
"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram": {
"query": "no",
"boost": 100,
"fuzziness": "auto"
}
}
},
{
"match": {
"productNumber.ngram": {
"query": "no",
"boost": 150,
"fuzziness": "auto"
}
}
},
{
"match": {
"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": {
"query": "no",
"boost": 40,
"fuzziness": "auto"
}
}
},
{
"match_phrase_prefix": {
"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram": {
"query": "no",
"boost": 40,
"slop": 1
}
}
},
{
"match": {
"ean.search": {
"query": "no",
"boost": 100,
"fuzziness": 0
}
}
},
{
"match": {
"manufacturerNumber.ngram": {
"query": "no",
"boost": 100,
"fuzziness": 0
}
}
}
],
"minimum_should_match": "1"
}
}
]
}
},
"aggregations": {
"manufacturer": {
"terms": {
"field": "manufacturerId",
"size": 10000
}
},
"price": {
"stats": {
"script": {
"id": "cheapest_price",
"params": {
"accessors": [
{
"key": "cheapest_price_rule471f2ca5e74440568ba57912bb0f3d50_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5bc757970f38af8d735ac2bef24_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5bc757d738cb8f62b8ca13162fd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5bc781372e48ae25e3fc49e6c75_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5c9aba570cdb1eb3cecd2cd9c14_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5c9abd170d5a439e74a4020e81c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule018c7cebb95d7085930868a24624ed56_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5bc758c718ca89324f9e2d1b64e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5bc758c718ca89324f9e3bbcdfd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5c9ab9b73b8b6ca8da792e44880_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"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": {
"filter": {
"script": {
"script": {
"inline": "double getPrice(def accessors, def doc, def decimals, def round, def multiplier) {\n for (accessor in accessors) {\n def key = accessor['key'];\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\ndef price = getPrice(params['accessors'], doc, params['decimals'], params['round'], params['multiplier']);\n\ndef match = true;\nif (params.containsKey('gte')) {\n match = match && price >= params['gte'];\n}\nif (params.containsKey('gt')) {\n match = match && price > params['gt'];\n}\nif (params.containsKey('lte')) {\n match = match && price <= params['lte'];\n}\nif (params.containsKey('lt')) {\n match = match && price < params['lt'];\n}\n\nreturn match;\n",
"params": {
"gte": 10.0,
"lte": 500.0,
"accessors": [
{
"key": "cheapest_price_rule471f2ca5e74440568ba57912bb0f3d50_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5bc757970f38af8d735ac2bef24_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5bc757d738cb8f62b8ca13162fd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5bc781372e48ae25e3fc49e6c75_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5c9aba570cdb1eb3cecd2cd9c14_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5c9abd170d5a439e74a4020e81c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule018c7cebb95d7085930868a24624ed56_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5bc758c718ca89324f9e2d1b64e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5bc758c718ca89324f9e3bbcdfd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5c9ab9b73b8b6ca8da792e44880_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
}
],
"decimals": 100,
"round": true,
"multiplier": 100.0
}
}
}
},
"aggregations": {
"properties": {
"filter": {
"range": {
"ratingAverage": {
"gte": 5.0
}
}
},
"aggregations": {
"properties": {
"filter": {
"bool": {
"should": [
{
"bool": {
"must_not": [
{
"nested": {
"path": "categories",
"query": {
"terms": {
"categories.id": [
"89ee44dcf85c46718ba0744360e5fcc1"
]
}
}
}
}
]
}
}
]
}
},
"aggregations": {
"properties": {
"filter": {
"bool": {
"should": [
{
"bool": {
"must_not": [
{
"nested": {
"path": "categories",
"query": {
"terms": {
"categories.id": [
"3adaca5df47943339a045e91f212ee90",
"b2e857ff4b84401caef408741cc18d83",
"2e9dc36608504cd0bd340d135922df23",
"87c89b5844a0436db7e7bebadfa24d5f",
"1339fc04d1b14eedae5c6cb1269b34af",
"b78d026c06064f24b92e69b8e1feadb0",
"eb1bb24fb4a64c9295a69f327f7a5899",
"b69d2b1c914342ecb0a0ba8cc0980393",
"4e33f457de524946ab593df85fba15ed"
]
}
}
}
}
]
}
}
]
}
},
"aggregations": {
"properties": {
"filter": {
"bool": {
"should": [
{
"bool": {
"must_not": [
{
"nested": {
"path": "categories",
"query": {
"terms": {
"categories.id": [
"a2e3ce1f6e7241a783db0a98b0003a84"
]
}
}
}
}
]
}
}
]
}
},
"aggregations": {
"properties": {
"nested": {
"path": "properties"
},
"aggregations": {
"properties": {
"terms": {
"field": "properties.id",
"size": 10000
}
}
}
}
}
}
}
}
}
}
}
}
}
},
"options": {
"nested": {
"path": "options"
},
"aggregations": {
"options": {
"terms": {
"field": "options.id",
"size": 10000
}
}
}
},
"propertiesCount": {
"filter": {
"script": {
"script": {
"inline": "double getPrice(def accessors, def doc, def decimals, def round, def multiplier) {\n for (accessor in accessors) {\n def key = accessor['key'];\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\ndef price = getPrice(params['accessors'], doc, params['decimals'], params['round'], params['multiplier']);\n\ndef match = true;\nif (params.containsKey('gte')) {\n match = match && price >= params['gte'];\n}\nif (params.containsKey('gt')) {\n match = match && price > params['gt'];\n}\nif (params.containsKey('lte')) {\n match = match && price <= params['lte'];\n}\nif (params.containsKey('lt')) {\n match = match && price < params['lt'];\n}\n\nreturn match;\n",
"params": {
"gte": 10.0,
"lte": 500.0,
"accessors": [
{
"key": "cheapest_price_rule471f2ca5e74440568ba57912bb0f3d50_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5bc757970f38af8d735ac2bef24_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5bc757d738cb8f62b8ca13162fd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5bc781372e48ae25e3fc49e6c75_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5c9aba570cdb1eb3cecd2cd9c14_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5c9abd170d5a439e74a4020e81c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule018c7cebb95d7085930868a24624ed56_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5bc758c718ca89324f9e2d1b64e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5bc758c718ca89324f9e3bbcdfd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5c9ab9b73b8b6ca8da792e44880_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
}
],
"decimals": 100,
"round": true,
"multiplier": 100.0
}
}
}
},
"aggregations": {
"propertiesCount": {
"filter": {
"range": {
"ratingAverage": {
"gte": 5.0
}
}
},
"aggregations": {
"propertiesCount": {
"filter": {
"bool": {
"should": [
{
"bool": {
"must_not": [
{
"nested": {
"path": "categories",
"query": {
"terms": {
"categories.id": [
"89ee44dcf85c46718ba0744360e5fcc1"
]
}
}
}
}
]
}
}
]
}
},
"aggregations": {
"propertiesCount": {
"filter": {
"bool": {
"should": [
{
"bool": {
"must_not": [
{
"nested": {
"path": "categories",
"query": {
"terms": {
"categories.id": [
"3adaca5df47943339a045e91f212ee90",
"b2e857ff4b84401caef408741cc18d83",
"2e9dc36608504cd0bd340d135922df23",
"87c89b5844a0436db7e7bebadfa24d5f",
"1339fc04d1b14eedae5c6cb1269b34af",
"b78d026c06064f24b92e69b8e1feadb0",
"eb1bb24fb4a64c9295a69f327f7a5899",
"b69d2b1c914342ecb0a0ba8cc0980393",
"4e33f457de524946ab593df85fba15ed"
]
}
}
}
}
]
}
}
]
}
},
"aggregations": {
"propertiesCount": {
"filter": {
"bool": {
"should": [
{
"bool": {
"must_not": [
{
"nested": {
"path": "categories",
"query": {
"terms": {
"categories.id": [
"a2e3ce1f6e7241a783db0a98b0003a84"
]
}
}
}
}
]
}
}
]
}
},
"aggregations": {
"propertiesCount": {
"terms": {
"field": "propertyIds",
"size": 10000
}
}
}
}
}
}
}
}
}
}
}
},
"brands": {
"filter": {
"script": {
"script": {
"inline": "double getPrice(def accessors, def doc, def decimals, def round, def multiplier) {\n for (accessor in accessors) {\n def key = accessor['key'];\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\ndef price = getPrice(params['accessors'], doc, params['decimals'], params['round'], params['multiplier']);\n\ndef match = true;\nif (params.containsKey('gte')) {\n match = match && price >= params['gte'];\n}\nif (params.containsKey('gt')) {\n match = match && price > params['gt'];\n}\nif (params.containsKey('lte')) {\n match = match && price <= params['lte'];\n}\nif (params.containsKey('lt')) {\n match = match && price < params['lt'];\n}\n\nreturn match;\n",
"params": {
"gte": 10.0,
"lte": 500.0,
"accessors": [
{
"key": "cheapest_price_rule471f2ca5e74440568ba57912bb0f3d50_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5bc757970f38af8d735ac2bef24_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5bc757d738cb8f62b8ca13162fd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5bc781372e48ae25e3fc49e6c75_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5c9aba570cdb1eb3cecd2cd9c14_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5c9abd170d5a439e74a4020e81c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule018c7cebb95d7085930868a24624ed56_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5bc758c718ca89324f9e2d1b64e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5bc758c718ca89324f9e3bbcdfd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5c9ab9b73b8b6ca8da792e44880_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
}
],
"decimals": 100,
"round": true,
"multiplier": 100.0
}
}
}
},
"aggregations": {
"brands": {
"filter": {
"range": {
"ratingAverage": {
"gte": 5.0
}
}
},
"aggregations": {
"brands": {
"filter": {
"bool": {
"should": [
{
"bool": {
"must_not": [
{
"nested": {
"path": "categories",
"query": {
"terms": {
"categories.id": [
"89ee44dcf85c46718ba0744360e5fcc1"
]
}
}
}
}
]
}
}
]
}
},
"aggregations": {
"brands": {
"filter": {
"bool": {
"should": [
{
"bool": {
"must_not": [
{
"nested": {
"path": "categories",
"query": {
"terms": {
"categories.id": [
"3adaca5df47943339a045e91f212ee90",
"b2e857ff4b84401caef408741cc18d83",
"2e9dc36608504cd0bd340d135922df23",
"87c89b5844a0436db7e7bebadfa24d5f",
"1339fc04d1b14eedae5c6cb1269b34af",
"b78d026c06064f24b92e69b8e1feadb0",
"eb1bb24fb4a64c9295a69f327f7a5899",
"b69d2b1c914342ecb0a0ba8cc0980393",
"4e33f457de524946ab593df85fba15ed"
]
}
}
}
}
]
}
}
]
}
},
"aggregations": {
"brands": {
"filter": {
"bool": {
"should": [
{
"bool": {
"must_not": [
{
"nested": {
"path": "categories",
"query": {
"terms": {
"categories.id": [
"a2e3ce1f6e7241a783db0a98b0003a84"
]
}
}
}
}
]
}
}
]
}
},
"aggregations": {
"brands": {
"terms": {
"field": "manufacturerId",
"size": 10000
}
}
}
}
}
}
}
}
}
}
}
}
},
"size": 0,
"timeout": "5s"
}
{
"took": 3,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"max_score": null,
"hits": []
},
"aggregations": {
"shipping-free-filter": {
"doc_count": 0,
"shipping-free": {
"value": null
}
},
"propertiesCount": {
"doc_count": 26,
"propertiesCount": {
"doc_count": 5,
"propertiesCount": {
"doc_count": 5,
"propertiesCount": {
"doc_count": 5,
"propertiesCount": {
"doc_count": 5,
"propertiesCount": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "0189b5cf594d723388d3704517e05e76",
"doc_count": 2
},
{
"key": "0189b5cf596c7224be4b404188e8f485",
"doc_count": 2
},
{
"key": "0189b5cf612873268fb7ddb6724a93b9",
"doc_count": 2
},
{
"key": "0189b5cf61f9735a9140044bdff0b579",
"doc_count": 2
},
{
"key": "0189b5cf620a72c7beff7d07f22e15ce",
"doc_count": 2
},
{
"key": "0189b5cf68637219b89a1aed704dcf6e",
"doc_count": 2
},
{
"key": "0189b5cf6b7373cf9bd87e1191d782c9",
"doc_count": 2
},
{
"key": "0189b5cf6ba07140b4d251cea18f943a",
"doc_count": 2
},
{
"key": "0189b5cf557071d98e90248bb3f4fb58",
"doc_count": 1
},
{
"key": "0189b5cf557b72788b3831e4ff77b722",
"doc_count": 1
},
{
"key": "0189b5cf55a4718da016c76efdddedff",
"doc_count": 1
},
{
"key": "0189b5cf587970509c11f4ebfccbce94",
"doc_count": 1
},
{
"key": "0189b5cf590c7304a507dd567ffdbab1",
"doc_count": 1
},
{
"key": "0189b5cf5f8e7025bf908ef32b6a896f",
"doc_count": 1
},
{
"key": "0189b5cf615d7034a4a5e9bf4d63918e",
"doc_count": 1
},
{
"key": "0189b5cf61e672bca21d340dfd97e477",
"doc_count": 1
},
{
"key": "0189b5cf61e9722d934228a39c6df159",
"doc_count": 1
},
{
"key": "0189b5cf625f7102b41b104a1ead8781",
"doc_count": 1
},
{
"key": "0189b5cf626a723ca261222ea304d942",
"doc_count": 1
}
]
}
}
}
}
}
},
"brands": {
"doc_count": 26,
"brands": {
"doc_count": 5,
"brands": {
"doc_count": 5,
"brands": {
"doc_count": 5,
"brands": {
"doc_count": 5,
"brands": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "0189b5cee2107191a01fa1f6edba027c",
"doc_count": 2
},
{
"key": "0189b5ced52270e1b9c399e55e18cddb",
"doc_count": 1
},
{
"key": "0189b5ced58e706890ac8b39799f9c9a",
"doc_count": 1
},
{
"key": "2d08c149dde94b36b579e5dbcc4c5559",
"doc_count": 1
}
]
}
}
}
}
}
},
"rating-exists": {
"doc_count": 36,
"rating": {
"value": 5.0
}
},
"price": {
"count": 36,
"min": 0.0,
"max": 2620.0,
"avg": 206.2936111111111,
"sum": 7426.57
},
"options": {
"doc_count": 1,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "0189b5cf092a70b38fc60a72bdd976ae",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 26,
"properties": {
"doc_count": 5,
"properties": {
"doc_count": 5,
"properties": {
"doc_count": 5,
"properties": {
"doc_count": 5,
"properties": {
"doc_count": 27,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "0189b5cf594d723388d3704517e05e76",
"doc_count": 2
},
{
"key": "0189b5cf596c7224be4b404188e8f485",
"doc_count": 2
},
{
"key": "0189b5cf612873268fb7ddb6724a93b9",
"doc_count": 2
},
{
"key": "0189b5cf61f9735a9140044bdff0b579",
"doc_count": 2
},
{
"key": "0189b5cf620a72c7beff7d07f22e15ce",
"doc_count": 2
},
{
"key": "0189b5cf68637219b89a1aed704dcf6e",
"doc_count": 2
},
{
"key": "0189b5cf6b7373cf9bd87e1191d782c9",
"doc_count": 2
},
{
"key": "0189b5cf6ba07140b4d251cea18f943a",
"doc_count": 2
},
{
"key": "0189b5cf557071d98e90248bb3f4fb58",
"doc_count": 1
},
{
"key": "0189b5cf557b72788b3831e4ff77b722",
"doc_count": 1
},
{
"key": "0189b5cf55a4718da016c76efdddedff",
"doc_count": 1
},
{
"key": "0189b5cf587970509c11f4ebfccbce94",
"doc_count": 1
},
{
"key": "0189b5cf590c7304a507dd567ffdbab1",
"doc_count": 1
},
{
"key": "0189b5cf5f8e7025bf908ef32b6a896f",
"doc_count": 1
},
{
"key": "0189b5cf615d7034a4a5e9bf4d63918e",
"doc_count": 1
},
{
"key": "0189b5cf61e672bca21d340dfd97e477",
"doc_count": 1
},
{
"key": "0189b5cf61e9722d934228a39c6df159",
"doc_count": 1
},
{
"key": "0189b5cf625f7102b41b104a1ead8781",
"doc_count": 1
},
{
"key": "0189b5cf626a723ca261222ea304d942",
"doc_count": 1
}
]
}
}
}
}
}
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "0189b5ced58e706890ac8b39799f9c9a",
"doc_count": 12
},
{
"key": "0189b5cee2107191a01fa1f6edba027c",
"doc_count": 7
},
{
"key": "0189b5cef54970eeb04b151407aa8eb8",
"doc_count": 5
},
{
"key": "0189b5ceda797286b22556d7bc043b75",
"doc_count": 4
},
{
"key": "0189b5ced52270e1b9c399e55e18cddb",
"doc_count": 2
},
{
"key": "0189b5ced54f7150b3878f8504c98853",
"doc_count": 2
},
{
"key": "0189b5ced5897359a1b2b50cde8fb80d",
"doc_count": 1
},
{
"key": "0189b5cedacd7232ab17aa5875e29f58",
"doc_count": 1
},
{
"key": "0189b5cef83e70189d646d46d95fc292",
"doc_count": 1
},
{
"key": "2d08c149dde94b36b579e5dbcc4c5559",
"doc_count": 1
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|