| 1 |
20.25 ms |
Request:
{"index":"staging-67_product","search_type":"query_then_fetch","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"term":{"active":true}},{"range":{"visibility_132e445c03814d67ac47c04afb6d5d99":{"gte":30}}}]}},{"term":{"categoryTree":"35bd54d08a7bfc2cd92f1274bcb1af4e"}},{"exists":{"field":"displayGroup"}}]}}],"should":[{"constant_score":{"filter":{"bool":{"should":[{"nested":{"path":"streams","query":{"terms":{"streams.id":["018f0ea07ad57e59841906b9dac1ae23"]}}}}]}},"boost":350.0}},{"constant_score":{"filter":{"bool":{"should":[{"nested":{"path":"streams","query":{"terms":{"streams.id":["018f0ea3242c77a3ad7aaa686586f79c"]}}}}]}},"boost":150.0}},{"constant_score":{"filter":{"bool":{"should":[{"nested":{"path":"streams","query":{"terms":{"streams.id":["018fe3229d5677949c032d1a4983f006"]}}}}]}},"boost":350.0}},{"constant_score":{"filter":{"bool":{"should":[{"nested":{"path":"streams","query":{"terms":{"streams.id":["f4e67c126b4e4b4f8b4f4b8295613b5b"]}}}}]}},"boost":1000.0}},{"constant_score":{"filter":{"bool":{"should":[{"nested":{"path":"streams","query":{"terms":{"streams.id":["15706c7290284128acdcdc0aa07bda52"]}}}}]}},"boost":400.0}},{"constant_score":{"filter":{"bool":{"should":[{"nested":{"path":"streams","query":{"terms":{"streams.id":["a33aa3f47e2147c9be62a08216f92c1c"]}}}}]}},"boost":300.0}},{"constant_score":{"filter":{"bool":{"should":[{"nested":{"path":"streams","query":{"terms":{"streams.id":["e3d0223b8cfd4edb8b5581ae7e9ab5cf"]}}}}]}},"boost":300.0}},{"constant_score":{"filter":{"bool":{"should":[{"nested":{"path":"streams","query":{"terms":{"streams.id":["62000891305f4ae4837e16e336cf2868"]}}}}]}},"boost":200.0}},{"constant_score":{"filter":{"bool":{"should":[{"nested":{"path":"streams","query":{"terms":{"streams.id":["9222eeebbd984a1fbba6521d6c03bc43"]}}}}]}},"boost":250.0}},{"constant_score":{"filter":{"bool":{"should":[{"nested":{"path":"streams","query":{"terms":{"streams.id":["cb292e1aaf854891a0d4e2fca32dd02f"]}}}}]}},"boost":100.0}}]}},"sort":[{"customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.acris_search_sorting_relevance":{"unmapped_type":"integer","missing":0,"order":"DESC"}},{"_score":{"order":"DESC"}},{"markAsTopseller":{"order":"DESC"}},{"autoIncrement":{"order":"DESC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"}}
{
"took": 6,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 31,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "staging-67_product_1776930924",
"_id": "d3f8390eb8e9c60ff854b8f90c27b5e4",
"_score": 1100.0,
"_source": {
"id": "d3f8390eb8e9c60ff854b8f90c27b5e4",
"autoIncrement": 137814.0
},
"fields": {
"displayGroup": [
"451df2ab9bb41e9c3f42408518cd9a6a"
]
},
"sort": [
0,
1100.0,
0,
137814,
"d3f8390eb8e9c60ff854b8f90c27b5e4"
]
},
{
"_index": "staging-67_product_1776930924",
"_id": "05e437f5a29d1b55bb7671ef05171355",
"_score": 1100.0,
"_source": {
"id": "05e437f5a29d1b55bb7671ef05171355",
"autoIncrement": 137813.0
},
"fields": {
"displayGroup": [
"a3231c14dc8b76ea083bf5fb0de2baca"
]
},
"sort": [
0,
1100.0,
0,
137813,
"05e437f5a29d1b55bb7671ef05171355"
]
},
{
"_index": "staging-67_product_1776930924",
"_id": "6db6e27c35346c04ab28b00b6ab63cf8",
"_score": 1100.0,
"_source": {
"id": "6db6e27c35346c04ab28b00b6ab63cf8",
"autoIncrement": 128749.0
},
"fields": {
"displayGroup": [
"3345e04b4c03269d6baf8a4fd25e3b28"
]
},
"sort": [
0,
1100.0,
0,
128749,
"6db6e27c35346c04ab28b00b6ab63cf8"
]
},
{
"_index": "staging-67_product_1776930924",
"_id": "405ba1839cf33b67d391ecdfd840d6e2",
"_score": 1100.0,
"_source": {
"id": "405ba1839cf33b67d391ecdfd840d6e2",
"autoIncrement": 121311.0
},
"fields": {
"displayGroup": [
"b8bec893589b522c6ed8882abf2a1b5f"
]
},
"sort": [
0,
1100.0,
0,
121311,
"405ba1839cf33b67d391ecdfd840d6e2"
]
},
{
"_index": "staging-67_product_1776930924",
"_id": "25b292afb17a8c3d583375dabd9b6159",
"_score": 1100.0,
"_source": {
"id": "25b292afb17a8c3d583375dabd9b6159",
"autoIncrement": 59823.0
},
"fields": {
"displayGroup": [
"3fca7a2c22d23f4cfd6785b744e6ec3e"
]
},
"sort": [
0,
1100.0,
0,
59823,
"25b292afb17a8c3d583375dabd9b6159"
]
},
{
"_index": "staging-67_product_1776930924",
"_id": "fc13bf0cfc10a894c243caa7eda963d9",
"_score": 1100.0,
"_source": {
"id": "fc13bf0cfc10a894c243caa7eda963d9",
"autoIncrement": 59822.0
},
"fields": {
"displayGroup": [
"bd48f37a86757e3f796aac8036638b7f"
]
},
"sort": [
0,
1100.0,
0,
59822,
"fc13bf0cfc10a894c243caa7eda963d9"
]
},
{
"_index": "staging-67_product_1776930924",
"_id": "39baf66ce09a0b50b0ce20a8929bfe0b",
"_score": 1100.0,
"_source": {
"id": "39baf66ce09a0b50b0ce20a8929bfe0b",
"autoIncrement": 59821.0
},
"fields": {
"displayGroup": [
"1aebe5574f8d620cf0d4fe7a323734bf"
]
},
"sort": [
0,
1100.0,
0,
59821,
"39baf66ce09a0b50b0ce20a8929bfe0b"
]
},
{
"_index": "staging-67_product_1776930924",
"_id": "4420158e38a7e5b0f6ee89d43cee812a",
"_score": 1100.0,
"_source": {
"id": "4420158e38a7e5b0f6ee89d43cee812a",
"autoIncrement": 59820.0
},
"fields": {
"displayGroup": [
"b6a71c9e0b0501d2224988501b9d774b"
]
},
"sort": [
0,
1100.0,
0,
59820,
"4420158e38a7e5b0f6ee89d43cee812a"
]
},
{
"_index": "staging-67_product_1776930924",
"_id": "074bdfc2a15a2d05a8b2394ebc2844d6",
"_score": 1100.0,
"_source": {
"id": "074bdfc2a15a2d05a8b2394ebc2844d6",
"autoIncrement": 59819.0
},
"fields": {
"displayGroup": [
"dc9bf09e3d39026fa85c712388888bc7"
]
},
"sort": [
0,
1100.0,
0,
59819,
"074bdfc2a15a2d05a8b2394ebc2844d6"
]
},
{
"_index": "staging-67_product_1776930924",
"_id": "4676ac702c8b35c1b85d23fe6a88352a",
"_score": 1100.0,
"_source": {
"id": "4676ac702c8b35c1b85d23fe6a88352a",
"autoIncrement": 59818.0
},
"fields": {
"displayGroup": [
"4879ce27d3647b1d55f841b642940973"
]
},
"sort": [
0,
1100.0,
0,
59818,
"4676ac702c8b35c1b85d23fe6a88352a"
]
},
{
"_index": "staging-67_product_1776930924",
"_id": "e00a8a465cd35187c58b6fdc53e9dadc",
"_score": 1100.0,
"_source": {
"id": "e00a8a465cd35187c58b6fdc53e9dadc",
"autoIncrement": 59743.0
},
"fields": {
"displayGroup": [
"ab989501abc6f7b9147d56ee5bcfc05a"
]
},
"sort": [
0,
1100.0,
0,
59743,
"e00a8a465cd35187c58b6fdc53e9dadc"
]
},
{
"_index": "staging-67_product_1776930924",
"_id": "1804a3a7d0df5507852d0f5e7aa20bdf",
"_score": 1100.0,
"_source": {
"id": "1804a3a7d0df5507852d0f5e7aa20bdf",
"autoIncrement": 59742.0
},
"fields": {
"displayGroup": [
"1a89f1d70171af82dfa1abe59961ee96"
]
},
"sort": [
0,
1100.0,
0,
59742,
"1804a3a7d0df5507852d0f5e7aa20bdf"
]
},
{
"_index": "staging-67_product_1776930924",
"_id": "e753f56cb08f0203420183c3a1c2851b",
"_score": 1100.0,
"_source": {
"id": "e753f56cb08f0203420183c3a1c2851b",
"autoIncrement": 59741.0
},
"fields": {
"displayGroup": [
"99a52e79fd1c20cc9797ce33e1985f35"
]
},
"sort": [
0,
1100.0,
0,
59741,
"e753f56cb08f0203420183c3a1c2851b"
]
},
{
"_index": "staging-67_product_1776930924",
"_id": "866dd9facc13c67eeae3074e07ecd15a",
"_score": 1100.0,
"_source": {
"id": "866dd9facc13c67eeae3074e07ecd15a",
"autoIncrement": 59740.0
},
"fields": {
"displayGroup": [
"bf053aae054a1f32520ad3280aeac6be"
]
},
"sort": [
0,
1100.0,
0,
59740,
"866dd9facc13c67eeae3074e07ecd15a"
]
},
{
"_index": "staging-67_product_1776930924",
"_id": "43d2b2c36f24294bccb229e7928ceee3",
"_score": 1100.0,
"_source": {
"id": "43d2b2c36f24294bccb229e7928ceee3",
"autoIncrement": 59737.0
},
"fields": {
"displayGroup": [
"117fc32da7d17327a20e72fa202bea39"
]
},
"sort": [
0,
1100.0,
0,
59737,
"43d2b2c36f24294bccb229e7928ceee3"
]
},
{
"_index": "staging-67_product_1776930924",
"_id": "3c0d3f51e864eea6e43b569fe0c1b5c9",
"_score": 1100.0,
"_source": {
"id": "3c0d3f51e864eea6e43b569fe0c1b5c9",
"autoIncrement": 41730.0
},
"fields": {
"displayGroup": [
"dc8272e8c7ddadc175bc6b4718a7e8b8"
]
},
"sort": [
0,
1100.0,
0,
41730,
"3c0d3f51e864eea6e43b569fe0c1b5c9"
]
},
{
"_index": "staging-67_product_1776930924",
"_id": "8f19ab4f937e6ecdd0f0fd9f61d8f564",
"_score": 1100.0,
"_source": {
"id": "8f19ab4f937e6ecdd0f0fd9f61d8f564",
"autoIncrement": 11147.0
},
"fields": {
"displayGroup": [
"b9f1d39f3b38fe63121841152e9bb9da"
]
},
"sort": [
0,
1100.0,
0,
11147,
"8f19ab4f937e6ecdd0f0fd9f61d8f564"
]
},
{
"_index": "staging-67_product_1776930924",
"_id": "406ede0a5d583813c2c1e2ebe756cc25",
"_score": 1100.0,
"_source": {
"id": "406ede0a5d583813c2c1e2ebe756cc25",
"autoIncrement": 11146.0
},
"fields": {
"displayGroup": [
"bde7c907e46872ddd59435c4d3ac8078"
]
},
"sort": [
0,
1100.0,
0,
11146,
"406ede0a5d583813c2c1e2ebe756cc25"
]
},
{
"_index": "staging-67_product_1776930924",
"_id": "b94d1bc0165fba73d72ac7481c5b5e25",
"_score": 1100.0,
"_source": {
"id": "b94d1bc0165fba73d72ac7481c5b5e25",
"autoIncrement": 11145.0
},
"fields": {
"displayGroup": [
"f45e63bdb45c68e1bc992fced281f21e"
]
},
"sort": [
0,
1100.0,
0,
11145,
"b94d1bc0165fba73d72ac7481c5b5e25"
]
},
{
"_index": "staging-67_product_1776930924",
"_id": "39ecf148b3983b9586393296a2757738",
"_score": 1100.0,
"_source": {
"id": "39ecf148b3983b9586393296a2757738",
"autoIncrement": 11142.0
},
"fields": {
"displayGroup": [
"850be532551ff52662f37065477501a8"
]
},
"sort": [
0,
1100.0,
0,
11142,
"39ecf148b3983b9586393296a2757738"
]
},
{
"_index": "staging-67_product_1776930924",
"_id": "92c72d0d03d78c14663e275c5e961218",
"_score": 1100.0,
"_source": {
"id": "92c72d0d03d78c14663e275c5e961218",
"autoIncrement": 11141.0
},
"fields": {
"displayGroup": [
"afa5ac21e55c23d93ba6b8f35a692810"
]
},
"sort": [
0,
1100.0,
0,
11141,
"92c72d0d03d78c14663e275c5e961218"
]
},
{
"_index": "staging-67_product_1776930924",
"_id": "000cb2d98f98ebbdfec9daebe1ff72af",
"_score": 1100.0,
"_source": {
"id": "000cb2d98f98ebbdfec9daebe1ff72af",
"autoIncrement": 11139.0
},
"fields": {
"displayGroup": [
"33376ba5cbf030d8168c2c38543c5bf2"
]
},
"sort": [
0,
1100.0,
0,
11139,
"000cb2d98f98ebbdfec9daebe1ff72af"
]
},
{
"_index": "staging-67_product_1776930924",
"_id": "07ddf3a23888925d771139a380c8064b",
"_score": 1100.0,
"_source": {
"id": "07ddf3a23888925d771139a380c8064b",
"autoIncrement": 10166.0
},
"fields": {
"displayGroup": [
"094171118104988fb7a1d1eb6eacf0a8"
]
},
"sort": [
0,
1100.0,
0,
10166,
"07ddf3a23888925d771139a380c8064b"
]
},
{
"_index": "staging-67_product_1776930924",
"_id": "46cff31429143f8a296038a14fd5118a",
"_score": 1100.0,
"_source": {
"id": "46cff31429143f8a296038a14fd5118a",
"autoIncrement": 10164.0
},
"fields": {
"displayGroup": [
"a63e15bda3078d218acbae4ee7c125cc"
]
},
"sort": [
0,
1100.0,
0,
10164,
"46cff31429143f8a296038a14fd5118a"
]
}
]
},
"aggregations": {
"total-count": {
"value": 31
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
13.28 ms |
Request:
{"index":"staging-67_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"term":{"active":true}},{"range":{"visibility_132e445c03814d67ac47c04afb6d5d99":{"gte":30}}}]}},{"term":{"categoryTree":"35bd54d08a7bfc2cd92f1274bcb1af4e"}},{"exists":{"field":"displayGroup"}}]}}]}},"aggregations":{"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_rule07f438d06a8a4951a3023a5e7810f884_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule2772e1f3cc52436593ed4c7b229426fe_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rulec019dd2f47394d68874602781a1eb06a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rulef43239e32e16483181a57e49cae1db77_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule643070c6755c43f3ad58eba50f4d0b17_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rulea755c64836d24743b295845250c45862_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":{"nested":{"path":"properties"},"aggregations":{"properties":{"terms":{"field":"properties.id","size":10000}}}},"options":{"nested":{"path":"options"},"aggregations":{"options":{"terms":{"field":"options.id","size":10000}}}},"manufacturer-count-filter":{"composite":{"sources":[{"manufacturer-count-filter.sorting":{"terms":{"field":"manufacturerId","order":"ASC"}}},{"manufacturer-count-filter.key":{"terms":{"field":"manufacturerId"}}}],"size":"99999"}},"bool-reduced":{"filter":{"script":{"script":{"source":"String getPercentageKey(def accessors, def doc) {\n for (accessor in accessors) {\n def key = accessor['key'];\n if (!doc.containsKey(key) || doc[key].empty) {\n continue;\n }\n\n return key;\n }\n\n return '';\n}\n\ndef percentageKey = getPercentageKey(params['accessors'], doc);\n\nif (percentageKey == '') {\n if (params.containsKey('eq') && params['eq'] === null) {\n return true;\n }\n\n return false;\n}\n\ndef percentage = (double) doc[percentageKey].value;\n\ndef match = true;\nif (params.containsKey('eq')) {\n match = match && percentage == params['eq'];\n}\nif (params.containsKey('gte')) {\n match = match && percentage >= params['gte'];\n}\nif (params.containsKey('gt')) {\n match = match && percentage > params['gt'];\n}\nif (params.containsKey('lte')) {\n match = match && percentage <= params['lte'];\n}\nif (params.containsKey('lt')) {\n match = match && percentage < params['lt'];\n}\n\nreturn match;\n","params":{"gt":1.0,"accessors":[{"key":"cheapest_price_rule07f438d06a8a4951a3023a5e7810f884_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage","factor":1},{"key":"cheapest_price_rule2772e1f3cc52436593ed4c7b229426fe_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage","factor":1},{"key":"cheapest_price_rulec019dd2f47394d68874602781a1eb06a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage","factor":1},{"key":"cheapest_price_rulef43239e32e16483181a57e49cae1db77_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage","factor":1},{"key":"cheapest_price_rule643070c6755c43f3ad58eba50f4d0b17_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage","factor":1},{"key":"cheapest_price_rulea755c64836d24743b295845250c45862_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage","factor":1}]}}}},"aggregations":{"bool-reduced":{"value_count":{"field":"id"}}}},"width":{"stats":{"field":"width"}},"width-stats":{"filter":{"range":{"width":{"gt":0.0}}},"aggregations":{"width-stats":{"stats":{"field":"width"}}}},"height":{"stats":{"field":"height"}},"height-stats":{"filter":{"range":{"height":{"gt":0.0}}},"aggregations":{"height-stats":{"stats":{"field":"height"}}}},"tiefe":{"stats":{"field":"attribute_tiefe"}},"multi-typModel":{"composite":{"sources":[{"multi-typModel.sorting":{"terms":{"field":"attribute_typModel","order":"ASC"}}},{"multi-typModel.key":{"terms":{"field":"attribute_typModel"}}}],"size":"99999"}},"multi-farbe":{"composite":{"sources":[{"multi-farbe.sorting":{"terms":{"field":"attribute_farbe","order":"ASC"}}},{"multi-farbe.key":{"terms":{"field":"attribute_farbe"}}}],"size":"99999"}},"multi-material":{"composite":{"sources":[{"multi-material.sorting":{"terms":{"field":"attribute_material","order":"ASC"}}},{"multi-material.key":{"terms":{"field":"attribute_material"}}}],"size":"99999"}},"manufacturer-count":{"terms":{"field":"manufacturerId","size":10000}}},"size":0,"timeout":"5s"},"search_type":"query_then_fetch"}
POST http://localhost:9200/staging-67_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_132e445c03814d67ac47c04afb6d5d99": {
"gte": 30
}
}
}
]
}
},
{
"term": {
"categoryTree": "35bd54d08a7bfc2cd92f1274bcb1af4e"
}
},
{
"exists": {
"field": "displayGroup"
}
}
]
}
}
]
}
},
"aggregations": {
"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_rule07f438d06a8a4951a3023a5e7810f884_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule2772e1f3cc52436593ed4c7b229426fe_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rulec019dd2f47394d68874602781a1eb06a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rulef43239e32e16483181a57e49cae1db77_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule643070c6755c43f3ad58eba50f4d0b17_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rulea755c64836d24743b295845250c45862_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": {
"nested": {
"path": "properties"
},
"aggregations": {
"properties": {
"terms": {
"field": "properties.id",
"size": 10000
}
}
}
},
"options": {
"nested": {
"path": "options"
},
"aggregations": {
"options": {
"terms": {
"field": "options.id",
"size": 10000
}
}
}
},
"manufacturer-count-filter": {
"composite": {
"sources": [
{
"manufacturer-count-filter.sorting": {
"terms": {
"field": "manufacturerId",
"order": "ASC"
}
}
},
{
"manufacturer-count-filter.key": {
"terms": {
"field": "manufacturerId"
}
}
}
],
"size": "99999"
}
},
"bool-reduced": {
"filter": {
"script": {
"script": {
"source": "String getPercentageKey(def accessors, def doc) {\n for (accessor in accessors) {\n def key = accessor['key'];\n if (!doc.containsKey(key) || doc[key].empty) {\n continue;\n }\n\n return key;\n }\n\n return '';\n}\n\ndef percentageKey = getPercentageKey(params['accessors'], doc);\n\nif (percentageKey == '') {\n if (params.containsKey('eq') && params['eq'] === null) {\n return true;\n }\n\n return false;\n}\n\ndef percentage = (double) doc[percentageKey].value;\n\ndef match = true;\nif (params.containsKey('eq')) {\n match = match && percentage == params['eq'];\n}\nif (params.containsKey('gte')) {\n match = match && percentage >= params['gte'];\n}\nif (params.containsKey('gt')) {\n match = match && percentage > params['gt'];\n}\nif (params.containsKey('lte')) {\n match = match && percentage <= params['lte'];\n}\nif (params.containsKey('lt')) {\n match = match && percentage < params['lt'];\n}\n\nreturn match;\n",
"params": {
"gt": 1.0,
"accessors": [
{
"key": "cheapest_price_rule07f438d06a8a4951a3023a5e7810f884_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage",
"factor": 1
},
{
"key": "cheapest_price_rule2772e1f3cc52436593ed4c7b229426fe_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage",
"factor": 1
},
{
"key": "cheapest_price_rulec019dd2f47394d68874602781a1eb06a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage",
"factor": 1
},
{
"key": "cheapest_price_rulef43239e32e16483181a57e49cae1db77_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage",
"factor": 1
},
{
"key": "cheapest_price_rule643070c6755c43f3ad58eba50f4d0b17_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage",
"factor": 1
},
{
"key": "cheapest_price_rulea755c64836d24743b295845250c45862_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage",
"factor": 1
},
{
"key": "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage",
"factor": 1
}
]
}
}
}
},
"aggregations": {
"bool-reduced": {
"value_count": {
"field": "id"
}
}
}
},
"width": {
"stats": {
"field": "width"
}
},
"width-stats": {
"filter": {
"range": {
"width": {
"gt": 0.0
}
}
},
"aggregations": {
"width-stats": {
"stats": {
"field": "width"
}
}
}
},
"height": {
"stats": {
"field": "height"
}
},
"height-stats": {
"filter": {
"range": {
"height": {
"gt": 0.0
}
}
},
"aggregations": {
"height-stats": {
"stats": {
"field": "height"
}
}
}
},
"tiefe": {
"stats": {
"field": "attribute_tiefe"
}
},
"multi-typModel": {
"composite": {
"sources": [
{
"multi-typModel.sorting": {
"terms": {
"field": "attribute_typModel",
"order": "ASC"
}
}
},
{
"multi-typModel.key": {
"terms": {
"field": "attribute_typModel"
}
}
}
],
"size": "99999"
}
},
"multi-farbe": {
"composite": {
"sources": [
{
"multi-farbe.sorting": {
"terms": {
"field": "attribute_farbe",
"order": "ASC"
}
}
},
{
"multi-farbe.key": {
"terms": {
"field": "attribute_farbe"
}
}
}
],
"size": "99999"
}
},
"multi-material": {
"composite": {
"sources": [
{
"multi-material.sorting": {
"terms": {
"field": "attribute_material",
"order": "ASC"
}
}
},
{
"multi-material.key": {
"terms": {
"field": "attribute_material"
}
}
}
],
"size": "99999"
}
},
"manufacturer-count": {
"terms": {
"field": "manufacturerId",
"size": 10000
}
}
},
"size": 0,
"timeout": "5s"
}
{
"took": 7,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"max_score": null,
"hits": []
},
"aggregations": {
"price": {
"count": 31,
"min": 52.0,
"max": 569.0,
"avg": 212.16129032258064,
"sum": 6577.0
},
"rating-exists": {
"doc_count": 31,
"rating": {
"value": 0.0
}
},
"shipping-free-filter": {
"doc_count": 0,
"shipping-free": {
"value": null
}
},
"properties": {
"doc_count": 0,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": []
}
},
"options": {
"doc_count": 0,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": []
}
},
"manufacturer-count-filter": {
"after_key": {
"manufacturer-count-filter.sorting": "90d90755dfdd3900014ff56c823d2246",
"manufacturer-count-filter.key": "90d90755dfdd3900014ff56c823d2246"
},
"buckets": [
{
"key": {
"manufacturer-count-filter.sorting": "6702a27cc2ed074813e1d59f22465957",
"manufacturer-count-filter.key": "6702a27cc2ed074813e1d59f22465957"
},
"doc_count": 19
},
{
"key": {
"manufacturer-count-filter.sorting": "90d90755dfdd3900014ff56c823d2246",
"manufacturer-count-filter.key": "90d90755dfdd3900014ff56c823d2246"
},
"doc_count": 6
}
]
},
"bool-reduced": {
"doc_count": 2,
"bool-reduced": {
"value": 2
}
},
"width": {
"count": 17,
"min": 300.0,
"max": 2000.0,
"avg": 896.4705882352941,
"sum": 15240.0
},
"width-stats": {
"doc_count": 17,
"width-stats": {
"count": 17,
"min": 300.0,
"max": 2000.0,
"avg": 896.4705882352941,
"sum": 15240.0
}
},
"height": {
"count": 31,
"min": 120.0,
"max": 1900.0,
"avg": 1259.516129032258,
"sum": 39045.0
},
"height-stats": {
"doc_count": 31,
"height-stats": {
"count": 31,
"min": 120.0,
"max": 1900.0,
"avg": 1259.516129032258,
"sum": 39045.0
}
},
"tiefe": {
"count": 17,
"min": 120.0,
"max": 460.0,
"avg": 268.8235294117647,
"sum": 4570.0
},
"multi-typModel": {
"after_key": {
"multi-typModel.sorting": "Wandgarderoben",
"multi-typModel.key": "Wandgarderoben"
},
"buckets": [
{
"key": {
"multi-typModel.sorting": "Garderobenst\u00e4nder",
"multi-typModel.key": "Garderobenst\u00e4nder"
},
"doc_count": 16
},
{
"key": {
"multi-typModel.sorting": "Reihengarderoben",
"multi-typModel.key": "Reihengarderoben"
},
"doc_count": 6
},
{
"key": {
"multi-typModel.sorting": "Wandgarderoben",
"multi-typModel.key": "Wandgarderoben"
},
"doc_count": 9
}
]
},
"multi-farbe": {
"after_key": {
"multi-farbe.sorting": "verchromt\/schwarz",
"multi-farbe.key": "verchromt\/schwarz"
},
"buckets": [
{
"key": {
"multi-farbe.sorting": "Edelstahl",
"multi-farbe.key": "Edelstahl"
},
"doc_count": 7
},
{
"key": {
"multi-farbe.sorting": "alusilber",
"multi-farbe.key": "alusilber"
},
"doc_count": 4
},
{
"key": {
"multi-farbe.sorting": "alusilber\/buche",
"multi-farbe.key": "alusilber\/buche"
},
"doc_count": 4
},
{
"key": {
"multi-farbe.sorting": "alusilber\/schwarz",
"multi-farbe.key": "alusilber\/schwarz"
},
"doc_count": 4
},
{
"key": {
"multi-farbe.sorting": "schwarz",
"multi-farbe.key": "schwarz"
},
"doc_count": 1
},
{
"key": {
"multi-farbe.sorting": "schwarz\/alusilber",
"multi-farbe.key": "schwarz\/alusilber"
},
"doc_count": 4
},
{
"key": {
"multi-farbe.sorting": "silbergrau",
"multi-farbe.key": "silbergrau"
},
"doc_count": 6
},
{
"key": {
"multi-farbe.sorting": "verchromt\/schwarz",
"multi-farbe.key": "verchromt\/schwarz"
},
"doc_count": 1
}
]
},
"multi-material": {
"after_key": {
"multi-material.sorting": "Stahl\/Marmor",
"multi-material.key": "Stahl\/Marmor"
},
"buckets": [
{
"key": {
"multi-material.sorting": "Edelstahl",
"multi-material.key": "Edelstahl"
},
"doc_count": 5
},
{
"key": {
"multi-material.sorting": "Edelstahl\/Sicherheitsglas",
"multi-material.key": "Edelstahl\/Sicherheitsglas"
},
"doc_count": 2
},
{
"key": {
"multi-material.sorting": "Stahl",
"multi-material.key": "Stahl"
},
"doc_count": 14
},
{
"key": {
"multi-material.sorting": "Stahl\/Kunststoff",
"multi-material.key": "Stahl\/Kunststoff"
},
"doc_count": 4
},
{
"key": {
"multi-material.sorting": "Stahl\/Marmor",
"multi-material.key": "Stahl\/Marmor"
},
"doc_count": 6
}
]
},
"manufacturer-count": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "6702a27cc2ed074813e1d59f22465957",
"doc_count": 19
},
{
"key": "90d90755dfdd3900014ff56c823d2246",
"doc_count": 6
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|