| 1 |
3.75 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":"cac1b19f49584fb39f293f089d12d307"}}}},{"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": 1,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 54,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "rosland_product_1712914068",
"_id": "6d5b31c91cac4dad88120a635318f143",
"_score": null,
"_source": {
"id": "6d5b31c91cac4dad88120a635318f143",
"autoIncrement": 3893.0
},
"fields": {
"displayGroup": [
"2b5891bb1b9b24cf7ed3fd1a71386d1b"
]
},
"sort": [
2000.0,
"6d5b31c91cac4dad88120a635318f143"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "967474e9b474452f906e0e9b6abd9aef",
"_score": null,
"_source": {
"id": "967474e9b474452f906e0e9b6abd9aef",
"autoIncrement": 1201.0
},
"fields": {
"displayGroup": [
"021eb96d2b9e98d9fe525de07f65b501"
]
},
"sort": [
2000.0,
"967474e9b474452f906e0e9b6abd9aef"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "c108eed21fa5451f92e54be785be3075",
"_score": null,
"_source": {
"id": "c108eed21fa5451f92e54be785be3075",
"autoIncrement": 3892.0
},
"fields": {
"displayGroup": [
"9dbd5c9a089de45dea64ed5fc6252e62"
]
},
"sort": [
1999.0,
"c108eed21fa5451f92e54be785be3075"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "6ca27377dd9d4fb08d2d7b826944a2c8",
"_score": null,
"_source": {
"id": "6ca27377dd9d4fb08d2d7b826944a2c8",
"autoIncrement": 3891.0
},
"fields": {
"displayGroup": [
"7f4dbb1e1b77e4a20739a5b184b3214b"
]
},
"sort": [
1996.0,
"6ca27377dd9d4fb08d2d7b826944a2c8"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "c681906cfd0c48a097d0ba47ae7d3e13",
"_score": null,
"_source": {
"id": "c681906cfd0c48a097d0ba47ae7d3e13",
"autoIncrement": 3890.0
},
"fields": {
"displayGroup": [
"248ef92d4cf8966a0ef5f9511dbd777c"
]
},
"sort": [
1995.0,
"c681906cfd0c48a097d0ba47ae7d3e13"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "9bc476317695431b833eb7edc25f2a1b",
"_score": null,
"_source": {
"id": "9bc476317695431b833eb7edc25f2a1b",
"autoIncrement": 1202.0
},
"fields": {
"displayGroup": [
"0b1c50ff579b9d89d73a53891a847a69"
]
},
"sort": [
1994.0,
"9bc476317695431b833eb7edc25f2a1b"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "d0a9fed719d346fc8870146ebe2ccf3c",
"_score": null,
"_source": {
"id": "d0a9fed719d346fc8870146ebe2ccf3c",
"autoIncrement": 3888.0
},
"fields": {
"displayGroup": [
"fc32114c8fc74aeec8d77b650b5bc2c6"
]
},
"sort": [
1993.0,
"d0a9fed719d346fc8870146ebe2ccf3c"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "6f07d1a6b9544bb68f72fb88b416a6a2",
"_score": null,
"_source": {
"id": "6f07d1a6b9544bb68f72fb88b416a6a2",
"autoIncrement": 3887.0
},
"fields": {
"displayGroup": [
"62a73ae8635cd4e5830ed57c07a9acdb"
]
},
"sort": [
1989.0,
"6f07d1a6b9544bb68f72fb88b416a6a2"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "9fb1f468fcea41e29fdf2849fcb28e87",
"_score": null,
"_source": {
"id": "9fb1f468fcea41e29fdf2849fcb28e87",
"autoIncrement": 3885.0
},
"fields": {
"displayGroup": [
"daac6448eae8b8750eca94ad63b5419e"
]
},
"sort": [
1988.0,
"9fb1f468fcea41e29fdf2849fcb28e87"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "d0519da5ef2843669dc0b1176b74b2d5",
"_score": null,
"_source": {
"id": "d0519da5ef2843669dc0b1176b74b2d5",
"autoIncrement": 3886.0
},
"fields": {
"displayGroup": [
"78c298b39ac0ec8d0718898d739fde05"
]
},
"sort": [
1988.0,
"d0519da5ef2843669dc0b1176b74b2d5"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "c9f60dffe699402f8f0866a9f91e0ccf",
"_score": null,
"_source": {
"id": "c9f60dffe699402f8f0866a9f91e0ccf",
"autoIncrement": 3884.0
},
"fields": {
"displayGroup": [
"00845c02696cc1595720b4a0a18a1c68"
]
},
"sort": [
1987.0,
"c9f60dffe699402f8f0866a9f91e0ccf"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "5c374f4bbce746a9bda347775d81ef0d",
"_score": null,
"_source": {
"id": "5c374f4bbce746a9bda347775d81ef0d",
"autoIncrement": 3883.0
},
"fields": {
"displayGroup": [
"7f4d3e56215bb079e08d033a8c8903d9"
]
},
"sort": [
1986.0,
"5c374f4bbce746a9bda347775d81ef0d"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "7ceeef2e335c443a8d5c3f20c743a6c0",
"_score": null,
"_source": {
"id": "7ceeef2e335c443a8d5c3f20c743a6c0",
"autoIncrement": 3882.0
},
"fields": {
"displayGroup": [
"71704bde3907f339fbac2f02d64c6ce7"
]
},
"sort": [
1985.0,
"7ceeef2e335c443a8d5c3f20c743a6c0"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "e432afe8caa046f3beadd1068b67fd02",
"_score": null,
"_source": {
"id": "e432afe8caa046f3beadd1068b67fd02",
"autoIncrement": 3881.0
},
"fields": {
"displayGroup": [
"822afd777dd28ad0ea09ae8e74c28ff0"
]
},
"sort": [
1984.0,
"e432afe8caa046f3beadd1068b67fd02"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "2d4d7f23d88245af9d8a90f22a0564cf",
"_score": null,
"_source": {
"id": "2d4d7f23d88245af9d8a90f22a0564cf",
"autoIncrement": 3880.0
},
"fields": {
"displayGroup": [
"619e47c5b9852a32d941676cc770a0e3"
]
},
"sort": [
1983.0,
"2d4d7f23d88245af9d8a90f22a0564cf"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "ee349ac8528a41529ea9f468e1ca6611",
"_score": null,
"_source": {
"id": "ee349ac8528a41529ea9f468e1ca6611",
"autoIncrement": 3508.0
},
"fields": {
"displayGroup": [
"bf298a0bc19f8487a3300ba70776775b"
]
},
"sort": [
1982.0,
"ee349ac8528a41529ea9f468e1ca6611"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "fd3fb2af6f924641a8d2d67bad9ec8ef",
"_score": null,
"_source": {
"id": "fd3fb2af6f924641a8d2d67bad9ec8ef",
"autoIncrement": 3879.0
},
"fields": {
"displayGroup": [
"c01ee7407f916f448338d46856c5ff53"
]
},
"sort": [
1981.0,
"fd3fb2af6f924641a8d2d67bad9ec8ef"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "eeb15c71387b44b3a39d5ca77bbe2476",
"_score": null,
"_source": {
"id": "eeb15c71387b44b3a39d5ca77bbe2476",
"autoIncrement": 3072.0
},
"fields": {
"displayGroup": [
"aaf2f3e2280788021037f67717cbabb9"
]
},
"sort": [
1980.0,
"eeb15c71387b44b3a39d5ca77bbe2476"
]
}
]
},
"aggregations": {
"total-count": {
"value": 54
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
1.48 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":"cac1b19f49584fb39f293f089d12d307"}}}},{"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": 54,
"rating": {
"value": 0.0
}
},
"properties": {
"doc_count": 758,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "00f4b1252e1540b7975b0d2dc01493cb",
"doc_count": 54
},
{
"key": "45018ee86cc84c47b8d18583215e11fb",
"doc_count": 54
},
{
"key": "a565d8093d284c968759c313c53119ac",
"doc_count": 54
},
{
"key": "a9705b0538cb42a3be5018cf5701955d",
"doc_count": 54
},
{
"key": "e577924c14df48179d45585b28aacca1",
"doc_count": 54
},
{
"key": "fb2c731579284c588fa1fe56c130231a",
"doc_count": 54
},
{
"key": "004c9f1122be4d3db1dadecc53a44cdf",
"doc_count": 29
},
{
"key": "d0c07ddcae6a4425b96e363887660b9f",
"doc_count": 29
},
{
"key": "466b5ec1a65e45cfaabe2fd9c30a4048",
"doc_count": 27
},
{
"key": "75b3bac4e87041dfb2b7707e34c37775",
"doc_count": 27
},
{
"key": "99544516e0e04f7f9cd839b4d9bc2b91",
"doc_count": 27
},
{
"key": "d6bf0226fcb541c9a5e8db4084b017a7",
"doc_count": 27
},
{
"key": "df1d883cf15a46f8ba34654e6a4e393a",
"doc_count": 27
},
{
"key": "ff8c432754f74be18895c359206d2f9e",
"doc_count": 27
},
{
"key": "4261829747ec48b884a9e118599ebdbf",
"doc_count": 25
},
{
"key": "5d7cdee62433436cb5ff14b769ad2b3e",
"doc_count": 25
},
{
"key": "80e3982c09e14668b61b2435788dd74e",
"doc_count": 25
},
{
"key": "c00d09ec51844aefa2781fcc00839644",
"doc_count": 25
},
{
"key": "b81318b1758e42bc8be1559a7f6df0bc",
"doc_count": 20
},
{
"key": "50bede51bbaa4f4aba7003a45cf998b3",
"doc_count": 10
},
{
"key": "9777f181ffe843dea6d2c8ea503871f9",
"doc_count": 5
},
{
"key": "0ad2db72f8c446a29c956ed6e9f78fb4",
"doc_count": 3
},
{
"key": "adfd37fa8d88405d8be97bde6b963aef",
"doc_count": 3
},
{
"key": "2cfa71698f8846af805a68264beefa3c",
"doc_count": 2
},
{
"key": "54ce87786b834c69b24ae0297c9f0351",
"doc_count": 2
},
{
"key": "5ab38019ed7843e7b3b2218c5a19e933",
"doc_count": 2
},
{
"key": "60f3a33fb6e74ec0b6c83ace74194df5",
"doc_count": 2
},
{
"key": "80e833585b2c4aca950cebfb2aaabd1a",
"doc_count": 2
},
{
"key": "8a6ac1662b934451b6e3bc6e665c3bea",
"doc_count": 2
},
{
"key": "9270bfdb608f44aba87a8540c8d22a10",
"doc_count": 2
},
{
"key": "998c9b372d1a4245a79724d3c6f0289e",
"doc_count": 2
},
{
"key": "9a60f14fa86443ff98d00b82e1578dd0",
"doc_count": 2
},
{
"key": "ca0798b913784ff9880ac954d5b61825",
"doc_count": 2
},
{
"key": "cce1e9f6f74d4013b63a51eac20d12dc",
"doc_count": 2
},
{
"key": "d87edd2454464161b85302e13bb3d42d",
"doc_count": 2
},
{
"key": "fcebc86ac3954b8092f471d6315e7c61",
"doc_count": 2
},
{
"key": "01fae2acf5614760ab3f6d4232366793",
"doc_count": 1
},
{
"key": "06e4d27eb94d4cc1aca5541219423d71",
"doc_count": 1
},
{
"key": "0fbe76176eee4f278b8f5a808b833039",
"doc_count": 1
},
{
"key": "14fd0605339a47ad8436471564c5813d",
"doc_count": 1
},
{
"key": "17fe7d47a81b4c8691b0e4c7bc80e286",
"doc_count": 1
},
{
"key": "19ff354e70aa45dba8fe4f7c2f81db8a",
"doc_count": 1
},
{
"key": "1baebe6a6ef6423f95778600eb89c7f8",
"doc_count": 1
},
{
"key": "2c3e712abb254016bb27376c648cebda",
"doc_count": 1
},
{
"key": "31436e1f2add44468bf2734baf79dbb0",
"doc_count": 1
},
{
"key": "3f7f2498f6b44d8e95ebe1c8728c7cf8",
"doc_count": 1
},
{
"key": "4f146b4ced904c95b0ff8ceaf78bfe3a",
"doc_count": 1
},
{
"key": "572f23c4632b492aa130b10b39b5fd77",
"doc_count": 1
},
{
"key": "5abe5490998f44e89091f30e98759fe5",
"doc_count": 1
},
{
"key": "5b2854b6c9da458e8bf92359a79545e8",
"doc_count": 1
},
{
"key": "5d6f6e6d29aa404f8d54b3c4ab0af26d",
"doc_count": 1
},
{
"key": "6919ff944a474dfea158b750c26f5ad4",
"doc_count": 1
},
{
"key": "6bdfc04591ed4e8eaadb176740095b4b",
"doc_count": 1
},
{
"key": "6d9393d5212f408991b5e01da2463513",
"doc_count": 1
},
{
"key": "79a5930ee0eb4cfbac3f6c63d6caeb36",
"doc_count": 1
},
{
"key": "7aa0ac667fd1476b8151f47f5744ab11",
"doc_count": 1
},
{
"key": "7d98a41c504648b59fc8a9046d4545ca",
"doc_count": 1
},
{
"key": "7de336e85bd14d9b8c9ef2f7b37eb7f7",
"doc_count": 1
},
{
"key": "8046c2026757422e8de8c94728320b90",
"doc_count": 1
},
{
"key": "84fc9ece27334fcfa64b2186bd31627f",
"doc_count": 1
},
{
"key": "8dedb3f255ff420ba88ac7fb25b2d50c",
"doc_count": 1
},
{
"key": "93dcea5ec8474de58987a8a26d862a8d",
"doc_count": 1
},
{
"key": "9861fdd7cd7f48188c9ab82dd0c9556a",
"doc_count": 1
},
{
"key": "988a420b6ac5475bb6b53725a4eede31",
"doc_count": 1
},
{
"key": "9f63f7a9675e490aa0c2ce7eb91381df",
"doc_count": 1
},
{
"key": "a22ffb31eeef4dec9f2742125159dc7d",
"doc_count": 1
},
{
"key": "ad0f710872604c0fba3d4cc8627219f9",
"doc_count": 1
},
{
"key": "ad799a5d08034eb29cc48599b830b580",
"doc_count": 1
},
{
"key": "adac28fc0ee643c1b43adea098dca42c",
"doc_count": 1
},
{
"key": "ae21e9df3c704e44964baa3298dfb679",
"doc_count": 1
},
{
"key": "b0fd24cfb9784ab4a1236ab5ece09415",
"doc_count": 1
},
{
"key": "b6384ba7bcb74086b88386d26347569d",
"doc_count": 1
},
{
"key": "b895d1ef4db34818bd3bd3f45fa5063a",
"doc_count": 1
},
{
"key": "bf2d854da22c41e0a79a72de4697db5b",
"doc_count": 1
},
{
"key": "c6c41d85dee047eb85a5a6e772cf38e2",
"doc_count": 1
},
{
"key": "c7cc8a656cf841ca898ab1f1ad507138",
"doc_count": 1
},
{
"key": "cbcf4de279734c658d003d6d3bfb8e1c",
"doc_count": 1
},
{
"key": "cc5ba8979f7a4fa1bf4bac8182181d79",
"doc_count": 1
},
{
"key": "cc61a08034264c0db3ba4fd0c3cac5e0",
"doc_count": 1
},
{
"key": "ce44d69a3e4e46ce9aa84b8515364889",
"doc_count": 1
},
{
"key": "d203639f7b4541deab3c1d6440258dd4",
"doc_count": 1
},
{
"key": "e2635cdac9f44e46b25539ecb2f85382",
"doc_count": 1
},
{
"key": "eff689d23e264c44b773885f2a4a39e9",
"doc_count": 1
}
]
}
},
"price": {
"count": 54,
"min": 0.0,
"max": 1721.61,
"avg": 80.15981481481482,
"sum": 4328.63
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "aab03f73cdd447e6b65315b83ddfeb79",
"doc_count": 54
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|