| 1 |
3.34 ms |
Request:
{"index":"rosland_product","search_type":"query_then_fetch","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"250c23c94a704f8ba1b4819c38901688"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"97edfefa62c943ceac6328301e10bae0"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"sort":[{"_script":{"type":"number","script":{"source":"def languages = params['languages'];\ndef suffix = params.containsKey('suffix') ? '.' + params['suffix'] : '';\n\nfor (int i = 0; i < languages.length; i++) {\n def field_name = params['field'] + '.' + languages[i] + suffix;\n\n if (doc[field_name].size() > 0 && doc[field_name].value != null && doc[field_name].value.toString().length() > 0) {\n def fieldValue = doc[field_name].value;\n\n return fieldValue;\n }\n}\n\nif (params['order'] == 'asc') {\n return Double.MAX_VALUE;\n}\n\nreturn Double.MIN_VALUE;\n","lang":"painless","params":{"field":"customFields","languages":["2fbb5fe2e29a4d70aa5854ce7ce3e20b"],"suffix":"custom_product_rosland_set_year","order":"desc"}},"order":"DESC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":36,"size":36,"collapse":{"field":"displayGroup"},"timeout":"5s"}}
{
"took": 0,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 47,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "rosland_product_1712914068",
"_id": "3584ca17b16548bfbcf609ccf267912d",
"_score": null,
"_source": {
"id": "3584ca17b16548bfbcf609ccf267912d",
"autoIncrement": 1039.0
},
"fields": {
"displayGroup": [
"8e01148621abbfe69ef26e74dca1b479"
]
},
"sort": [
1994.0,
"3584ca17b16548bfbcf609ccf267912d"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "5ad011f1fdca419d99b6e0db30142c7c",
"_score": null,
"_source": {
"id": "5ad011f1fdca419d99b6e0db30142c7c",
"autoIncrement": 2851.0
},
"fields": {
"displayGroup": [
"4016c3f6735b2199e5743329c2aa965c"
]
},
"sort": [
1994.0,
"5ad011f1fdca419d99b6e0db30142c7c"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "9f9dfe1ddcee458ca0efedb84f4ed23a",
"_score": null,
"_source": {
"id": "9f9dfe1ddcee458ca0efedb84f4ed23a",
"autoIncrement": 1040.0
},
"fields": {
"displayGroup": [
"47266b0a9895681eb580581149910079"
]
},
"sort": [
1993.0,
"9f9dfe1ddcee458ca0efedb84f4ed23a"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "7f3ed6e6f0044d0392f070a53f854b3b",
"_score": null,
"_source": {
"id": "7f3ed6e6f0044d0392f070a53f854b3b",
"autoIncrement": 1041.0
},
"fields": {
"displayGroup": [
"848e0d54a84a81bf5f836d5ad07130b7"
]
},
"sort": [
1992.0,
"7f3ed6e6f0044d0392f070a53f854b3b"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "e1da9245a2294dfe9597175ca5460f7a",
"_score": null,
"_source": {
"id": "e1da9245a2294dfe9597175ca5460f7a",
"autoIncrement": 1042.0
},
"fields": {
"displayGroup": [
"c6310f0724d4d8bda43ee2989fe7fb29"
]
},
"sort": [
1991.0,
"e1da9245a2294dfe9597175ca5460f7a"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "c3e974dfd2fe46f795a64a534480955a",
"_score": null,
"_source": {
"id": "c3e974dfd2fe46f795a64a534480955a",
"autoIncrement": 3054.0
},
"fields": {
"displayGroup": [
"5e3fa6866fc629c031bbe7e90bd64b20"
]
},
"sort": [
1990.0,
"c3e974dfd2fe46f795a64a534480955a"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "83bffa7d279e4221a6a2664de0b15892",
"_score": null,
"_source": {
"id": "83bffa7d279e4221a6a2664de0b15892",
"autoIncrement": 3055.0
},
"fields": {
"displayGroup": [
"669a27944799b3a6335627f6b69865d7"
]
},
"sort": [
1989.0,
"83bffa7d279e4221a6a2664de0b15892"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "cd1f5e4c58de405684859a1ad94ed33b",
"_score": null,
"_source": {
"id": "cd1f5e4c58de405684859a1ad94ed33b",
"autoIncrement": 3057.0
},
"fields": {
"displayGroup": [
"c379da337c90554fafc3436400f273df"
]
},
"sort": [
1988.0,
"cd1f5e4c58de405684859a1ad94ed33b"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "a3449c8c1cd445509d833d8ae100ce5b",
"_score": null,
"_source": {
"id": "a3449c8c1cd445509d833d8ae100ce5b",
"autoIncrement": 3056.0
},
"fields": {
"displayGroup": [
"20d1d9d1c6cf99fc51466c5b8bc19113"
]
},
"sort": [
1987.0,
"a3449c8c1cd445509d833d8ae100ce5b"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "95fc681957e3415b86c4429fe0266ad7",
"_score": null,
"_source": {
"id": "95fc681957e3415b86c4429fe0266ad7",
"autoIncrement": 3506.0
},
"fields": {
"displayGroup": [
"698fd17fa4a15d2ce2c8331d0dc50bdd"
]
},
"sort": [
1986.0,
"95fc681957e3415b86c4429fe0266ad7"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "9b1aad99d2d145729ea56380fc882603",
"_score": null,
"_source": {
"id": "9b1aad99d2d145729ea56380fc882603",
"autoIncrement": 3716.0
},
"fields": {
"displayGroup": [
"1b6cd17e73e8b86f91807775286fedfb"
]
},
"sort": [
1986.0,
"9b1aad99d2d145729ea56380fc882603"
]
}
]
},
"aggregations": {
"total-count": {
"value": 47
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
1.30 ms |
Request:
{"index":"rosland_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"250c23c94a704f8ba1b4819c38901688"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"97edfefa62c943ceac6328301e10bae0"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"aggregations":{"manufacturer":{"terms":{"field":"manufacturerId","size":10000}},"price":{"stats":{"script":{"source":"double getPrice(def accessors, def doc, def decimals, def round, def multiplier) {\n for (accessor in accessors) {\n def key = accessor['key'];\n\n if (!doc.containsKey(key) || doc[key].empty) {\n continue;\n }\n\n def factor = accessor['factor'];\n def value = doc[key].value * factor;\n\n value = Math.round(value * decimals);\n value = (double) value \/ decimals;\n\n if (!round) {\n return (double) value;\n }\n\n value = Math.round(value * multiplier);\n\n value = (double) value \/ multiplier;\n\n return (double) value;\n }\n\n return 0;\n}\n\nreturn getPrice(params['accessors'], doc, params['decimals'], params['round'], params['multiplier']);\n","lang":"painless","params":{"accessors":[{"key":"cheapest_price_rule64bf19224e314563aba24460dda765f8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule89d3fe06bd7c478194fe9179a9602df5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruled980a6dfc7774cd192e0b1a183764274_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01961afbc995737796b164a7b5355b5d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01961afbca2673cf9fb2d67da0cd8a62_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule6235b68395cd475f90278d41d7b1b36c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruleac5af03b5965434681e7c4cb42720d2b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulecc1de6f5416545d3a68a00f78e8f20f3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1}],"decimals":100,"round":true,"multiplier":100.0}}}},"rating-exists":{"filter":{"range":{"ratingAverage":{"gte":0.0}}},"aggregations":{"rating":{"max":{"field":"ratingAverage"}}}},"shipping-free-filter":{"filter":{"term":{"shippingFree":true}},"aggregations":{"shipping-free":{"max":{"field":"shippingFree"}}}},"properties":{"nested":{"path":"properties"},"aggregations":{"properties":{"terms":{"field":"properties.id","size":10000}}}},"options":{"nested":{"path":"options"},"aggregations":{"options":{"terms":{"field":"options.id","size":10000}}}}},"size":0,"timeout":"5s"},"search_type":"query_then_fetch"}
{
"took": 0,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"max_score": null,
"hits": []
},
"aggregations": {
"options": {
"doc_count": 0,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": []
}
},
"shipping-free-filter": {
"doc_count": 0,
"shipping-free": {
"value": null
}
},
"rating-exists": {
"doc_count": 47,
"rating": {
"value": 0.0
}
},
"properties": {
"doc_count": 830,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "16c63023894f40c29a8d441f052b01fd",
"doc_count": 47
},
{
"key": "3a7e5383173049a9870e0213864728e3",
"doc_count": 47
},
{
"key": "3c0aabc08db641c48171fb5bfaa1d462",
"doc_count": 47
},
{
"key": "45018ee86cc84c47b8d18583215e11fb",
"doc_count": 47
},
{
"key": "82ef30faf3994ebb8aa8e7396bc9c379",
"doc_count": 47
},
{
"key": "a9705b0538cb42a3be5018cf5701955d",
"doc_count": 47
},
{
"key": "de13eba6d2fc4edc96f91a594e3bb0ba",
"doc_count": 47
},
{
"key": "df82a71019c348f88bf1cebb3175c4b1",
"doc_count": 47
},
{
"key": "e577924c14df48179d45585b28aacca1",
"doc_count": 47
},
{
"key": "ef060cd426844b678bc6f4276355d74b",
"doc_count": 47
},
{
"key": "c00d09ec51844aefa2781fcc00839644",
"doc_count": 46
},
{
"key": "75b3bac4e87041dfb2b7707e34c37775",
"doc_count": 44
},
{
"key": "80e3982c09e14668b61b2435788dd74e",
"doc_count": 44
},
{
"key": "acc15fd13ca94d30a191529d268a7256",
"doc_count": 41
},
{
"key": "b81318b1758e42bc8be1559a7f6df0bc",
"doc_count": 41
},
{
"key": "fb3cb615b2f94d15843386656370f903",
"doc_count": 41
},
{
"key": "0e52c677f6eb4b4ebcb7bf705fd38edd",
"doc_count": 3
},
{
"key": "5a3c25e9ed0547a0998b524d5df8d5b4",
"doc_count": 3
},
{
"key": "99544516e0e04f7f9cd839b4d9bc2b91",
"doc_count": 3
},
{
"key": "c7cc8a656cf841ca898ab1f1ad507138",
"doc_count": 3
},
{
"key": "31436e1f2add44468bf2734baf79dbb0",
"doc_count": 2
},
{
"key": "451ab9c01fb14c9ab5f6d5d4b2e5d476",
"doc_count": 2
},
{
"key": "5ab38019ed7843e7b3b2218c5a19e933",
"doc_count": 2
},
{
"key": "8a6ac1662b934451b6e3bc6e665c3bea",
"doc_count": 2
},
{
"key": "adfd37fa8d88405d8be97bde6b963aef",
"doc_count": 2
},
{
"key": "ae21e9df3c704e44964baa3298dfb679",
"doc_count": 2
},
{
"key": "ca0798b913784ff9880ac954d5b61825",
"doc_count": 2
},
{
"key": "cd2bff3f51dd4bda9ca20d617e3f64ee",
"doc_count": 2
},
{
"key": "da73ead1b1964a929f9369fb17e21c3b",
"doc_count": 2
},
{
"key": "f8f2704cb7e542598507750f9fc921f6",
"doc_count": 2
},
{
"key": "004c9f1122be4d3db1dadecc53a44cdf",
"doc_count": 1
},
{
"key": "018af03e1d7c7c8dabe65059358dbeba",
"doc_count": 1
},
{
"key": "06e4d27eb94d4cc1aca5541219423d71",
"doc_count": 1
},
{
"key": "0a2817a3ada641419609f11314724061",
"doc_count": 1
},
{
"key": "0ad2db72f8c446a29c956ed6e9f78fb4",
"doc_count": 1
},
{
"key": "0bb9c0cc37d04b93a3f6f278d9227d16",
"doc_count": 1
},
{
"key": "1216829bd2364f0b8dc1cfc4428ec2ab",
"doc_count": 1
},
{
"key": "14fd0605339a47ad8436471564c5813d",
"doc_count": 1
},
{
"key": "15f87509f4b142f59c79c1f211508795",
"doc_count": 1
},
{
"key": "19ff354e70aa45dba8fe4f7c2f81db8a",
"doc_count": 1
},
{
"key": "1baebe6a6ef6423f95778600eb89c7f8",
"doc_count": 1
},
{
"key": "1e385a0f30614dd7b69f5d5b72a27b42",
"doc_count": 1
},
{
"key": "2329dc5d39fc4126b53cf3af6ee3ec22",
"doc_count": 1
},
{
"key": "27afa12e8fd1402e8ce3638e19a98d9a",
"doc_count": 1
},
{
"key": "2851f8449072408a8e5d18d6f9b1d8c5",
"doc_count": 1
},
{
"key": "2b5a482c17f443c6a375342124b63fbc",
"doc_count": 1
},
{
"key": "2cfa71698f8846af805a68264beefa3c",
"doc_count": 1
},
{
"key": "38e8473f07354461a08b4a6851c0bb65",
"doc_count": 1
},
{
"key": "3925d254805340578922828412f8fd34",
"doc_count": 1
},
{
"key": "3a15a1e4e8cb4b08983a8e81003281fe",
"doc_count": 1
},
{
"key": "3a1ef6d9baae4762af1ba42d77b91c84",
"doc_count": 1
},
{
"key": "3c038b44e46442589661994ae6e4eb42",
"doc_count": 1
},
{
"key": "4d4d35ef68194287aba6d8da43f4d216",
"doc_count": 1
},
{
"key": "4f146b4ced904c95b0ff8ceaf78bfe3a",
"doc_count": 1
},
{
"key": "54ce87786b834c69b24ae0297c9f0351",
"doc_count": 1
},
{
"key": "563002f3084142f894113ce992271ef4",
"doc_count": 1
},
{
"key": "567fd2358e4d4042abab671392998404",
"doc_count": 1
},
{
"key": "56fb067aa2874330b6473b1bb5975ec9",
"doc_count": 1
},
{
"key": "579e8eed3192419f97ce0492be65e32e",
"doc_count": 1
},
{
"key": "5b2854b6c9da458e8bf92359a79545e8",
"doc_count": 1
},
{
"key": "5fdba4dbca1746b08a7274d91249690a",
"doc_count": 1
},
{
"key": "60f3a33fb6e74ec0b6c83ace74194df5",
"doc_count": 1
},
{
"key": "6121040b2af4498ea1f9f4efcabff7ff",
"doc_count": 1
},
{
"key": "6465c60b79974f4fab55658d2d8ce548",
"doc_count": 1
},
{
"key": "6d9393d5212f408991b5e01da2463513",
"doc_count": 1
},
{
"key": "76d3c70921ac46ffab30d7e56e44cfef",
"doc_count": 1
},
{
"key": "801542f96f2e4e6cb633a5f3dd57aac0",
"doc_count": 1
},
{
"key": "8cdce387ee6b47ceafd200436af99627",
"doc_count": 1
},
{
"key": "8dedb3f255ff420ba88ac7fb25b2d50c",
"doc_count": 1
},
{
"key": "9270bfdb608f44aba87a8540c8d22a10",
"doc_count": 1
},
{
"key": "93dcea5ec8474de58987a8a26d862a8d",
"doc_count": 1
},
{
"key": "9861fdd7cd7f48188c9ab82dd0c9556a",
"doc_count": 1
},
{
"key": "998c9b372d1a4245a79724d3c6f0289e",
"doc_count": 1
},
{
"key": "9a60f14fa86443ff98d00b82e1578dd0",
"doc_count": 1
},
{
"key": "9b4b3bf586444a16999c4f59bdc1e3f0",
"doc_count": 1
},
{
"key": "a22ffb31eeef4dec9f2742125159dc7d",
"doc_count": 1
},
{
"key": "a377f8dd0cf344109bed75c94bb9cc69",
"doc_count": 1
},
{
"key": "a751a394f03c490fbe1ffaaa117554fb",
"doc_count": 1
},
{
"key": "adac28fc0ee643c1b43adea098dca42c",
"doc_count": 1
},
{
"key": "b0fd24cfb9784ab4a1236ab5ece09415",
"doc_count": 1
},
{
"key": "baa459f49bc54eb4b027b91740ce93f2",
"doc_count": 1
},
{
"key": "bf2d854da22c41e0a79a72de4697db5b",
"doc_count": 1
},
{
"key": "c0b1f0e688084a63ba617a953c6444d1",
"doc_count": 1
},
{
"key": "cb43e4c36647459199e49f5c4d72e968",
"doc_count": 1
},
{
"key": "cc61a08034264c0db3ba4fd0c3cac5e0",
"doc_count": 1
},
{
"key": "cca45554e2274564aa8fdc6adc80a860",
"doc_count": 1
},
{
"key": "ce44d69a3e4e46ce9aa84b8515364889",
"doc_count": 1
},
{
"key": "cf387c70e3fa4517b5dc2e6ed19660c6",
"doc_count": 1
},
{
"key": "d0c07ddcae6a4425b96e363887660b9f",
"doc_count": 1
},
{
"key": "d203639f7b4541deab3c1d6440258dd4",
"doc_count": 1
},
{
"key": "d271d7b82a814e7e9572c5b6d4494c5b",
"doc_count": 1
},
{
"key": "d3b0d7f35ff044119ca943bd7edec759",
"doc_count": 1
},
{
"key": "d62917d865c546128eae42448394dc58",
"doc_count": 1
},
{
"key": "d87edd2454464161b85302e13bb3d42d",
"doc_count": 1
},
{
"key": "dda191f0d7ba4e38bb9793ba3121355b",
"doc_count": 1
},
{
"key": "e7c738c7b72544ef91970e7293647d75",
"doc_count": 1
},
{
"key": "e8800fea53ee4087a0afd683a283ac96",
"doc_count": 1
},
{
"key": "ed2f1be90dde45819987b5046bfe6809",
"doc_count": 1
},
{
"key": "eff689d23e264c44b773885f2a4a39e9",
"doc_count": 1
},
{
"key": "fa3c5bd47df141539321d78794fff1ad",
"doc_count": 1
},
{
"key": "fcebc86ac3954b8092f471d6315e7c61",
"doc_count": 1
}
]
}
},
"price": {
"count": 47,
"min": 0.0,
"max": 1788.3,
"avg": 817.3478723404255,
"sum": 38415.35
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "0345f5142cf242648058475ab4182b6d",
"doc_count": 47
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|