| 1 |
4.22 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":"a1853caed9e644a99d597e4b17da6ac5"}}}},{"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": 57,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "rosland_product_1712914068",
"_id": "d8a12f3fe0bc470788e39e5ac627cdc1",
"_score": null,
"_source": {
"id": "d8a12f3fe0bc470788e39e5ac627cdc1",
"autoIncrement": 4311.0
},
"fields": {
"displayGroup": [
"22b6e004d79671e9962ac963723252de"
]
},
"sort": [
1997.0,
"d8a12f3fe0bc470788e39e5ac627cdc1"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "c22eec9ab3ae45558173dfb083f3c686",
"_score": null,
"_source": {
"id": "c22eec9ab3ae45558173dfb083f3c686",
"autoIncrement": 973.0
},
"fields": {
"displayGroup": [
"3ae7b8217f1feeac3a5e2b4ec8e6e436"
]
},
"sort": [
1996.0,
"c22eec9ab3ae45558173dfb083f3c686"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "de45b86444d24635b610ea5aeea43327",
"_score": null,
"_source": {
"id": "de45b86444d24635b610ea5aeea43327",
"autoIncrement": 974.0
},
"fields": {
"displayGroup": [
"5ffb0229b95faca7aa4838870f078d7a"
]
},
"sort": [
1995.0,
"de45b86444d24635b610ea5aeea43327"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "bd0ccd2f04eb4dfab26428c0ffb61ec3",
"_score": null,
"_source": {
"id": "bd0ccd2f04eb4dfab26428c0ffb61ec3",
"autoIncrement": 975.0
},
"fields": {
"displayGroup": [
"6c9d942658eb58e4effe746e1297f1b5"
]
},
"sort": [
1994.0,
"bd0ccd2f04eb4dfab26428c0ffb61ec3"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "f7af0f7cedfb4c3eab5f4f174b308487",
"_score": null,
"_source": {
"id": "f7af0f7cedfb4c3eab5f4f174b308487",
"autoIncrement": 3041.0
},
"fields": {
"displayGroup": [
"3e5871a3966c3bc87b2d2509cbb6e314"
]
},
"sort": [
1993.0,
"f7af0f7cedfb4c3eab5f4f174b308487"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "b11ae75853484318b310c110c71ffcea",
"_score": null,
"_source": {
"id": "b11ae75853484318b310c110c71ffcea",
"autoIncrement": 976.0
},
"fields": {
"displayGroup": [
"ac7a94b355688f014050000843d7b147"
]
},
"sort": [
1992.0,
"b11ae75853484318b310c110c71ffcea"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "3ed9cfac33b745d58d3fc5f604507565",
"_score": null,
"_source": {
"id": "3ed9cfac33b745d58d3fc5f604507565",
"autoIncrement": 977.0
},
"fields": {
"displayGroup": [
"a07770882868dffe33828cc26729798c"
]
},
"sort": [
1991.0,
"3ed9cfac33b745d58d3fc5f604507565"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "555dfe093799444a96a18c45c26e2dd1",
"_score": null,
"_source": {
"id": "555dfe093799444a96a18c45c26e2dd1",
"autoIncrement": 3964.0
},
"fields": {
"displayGroup": [
"3f25d541e8c120f6c52ebf4ccc313173"
]
},
"sort": [
1990.0,
"555dfe093799444a96a18c45c26e2dd1"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "1ad5ba63a6d14cfa8d30533833467b4f",
"_score": null,
"_source": {
"id": "1ad5ba63a6d14cfa8d30533833467b4f",
"autoIncrement": 978.0
},
"fields": {
"displayGroup": [
"61e27e7b83eccdf2929b284e5be98c41"
]
},
"sort": [
1989.0,
"1ad5ba63a6d14cfa8d30533833467b4f"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "30ff753f8cff4fb2b80aee7e733f805c",
"_score": null,
"_source": {
"id": "30ff753f8cff4fb2b80aee7e733f805c",
"autoIncrement": 979.0
},
"fields": {
"displayGroup": [
"3992c5abf1103da4ec698e43a4490cfa"
]
},
"sort": [
1988.0,
"30ff753f8cff4fb2b80aee7e733f805c"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "affcfffdcf3d4c3f9a0d80fb95d1b6de",
"_score": null,
"_source": {
"id": "affcfffdcf3d4c3f9a0d80fb95d1b6de",
"autoIncrement": 4290.0
},
"fields": {
"displayGroup": [
"97e2380ac36023bc8a23eafc962716a3"
]
},
"sort": [
1988.0,
"affcfffdcf3d4c3f9a0d80fb95d1b6de"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "d46cfec99d8e43648c9603e0ce153a9e",
"_score": null,
"_source": {
"id": "d46cfec99d8e43648c9603e0ce153a9e",
"autoIncrement": 3042.0
},
"fields": {
"displayGroup": [
"e3c661e33861305977053be89df71751"
]
},
"sort": [
1987.0,
"d46cfec99d8e43648c9603e0ce153a9e"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "32709f54c01148d892fddb8dc155ce70",
"_score": null,
"_source": {
"id": "32709f54c01148d892fddb8dc155ce70",
"autoIncrement": 2568.0
},
"fields": {
"displayGroup": [
"e33fc96d56f9c923c1ce99d6d4765a60"
]
},
"sort": [
1986.0,
"32709f54c01148d892fddb8dc155ce70"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "4258fe2ac7da4a808101ae539e15199a",
"_score": null,
"_source": {
"id": "4258fe2ac7da4a808101ae539e15199a",
"autoIncrement": 980.0
},
"fields": {
"displayGroup": [
"ebd02c1fffd953a45c420b13bd9350ab"
]
},
"sort": [
1985.0,
"4258fe2ac7da4a808101ae539e15199a"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "9a7e256a11ca485da761a41674f466a4",
"_score": null,
"_source": {
"id": "9a7e256a11ca485da761a41674f466a4",
"autoIncrement": 3499.0
},
"fields": {
"displayGroup": [
"89146772994b27fab36b142506808cbc"
]
},
"sort": [
1984.0,
"9a7e256a11ca485da761a41674f466a4"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "6bff016d74a44982a59030b8d92b6e6c",
"_score": null,
"_source": {
"id": "6bff016d74a44982a59030b8d92b6e6c",
"autoIncrement": 3043.0
},
"fields": {
"displayGroup": [
"fec8607cb8d6bce3bf0d25cba28f91a9"
]
},
"sort": [
1983.0,
"6bff016d74a44982a59030b8d92b6e6c"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "24bb6ac637664c95a4f24dea292d04db",
"_score": null,
"_source": {
"id": "24bb6ac637664c95a4f24dea292d04db",
"autoIncrement": 217.0
},
"fields": {
"displayGroup": [
"adee8db64b5ecd0ee522d1d310282b79"
]
},
"sort": [
1982.0,
"24bb6ac637664c95a4f24dea292d04db"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "5de0436fe79f48e1b94f95b0c880bf2b",
"_score": null,
"_source": {
"id": "5de0436fe79f48e1b94f95b0c880bf2b",
"autoIncrement": 4291.0
},
"fields": {
"displayGroup": [
"fc20efd95c1af9c9c6edc2c2662e83bc"
]
},
"sort": [
1982.0,
"5de0436fe79f48e1b94f95b0c880bf2b"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "3b421ab3af044a578433de5f1c14125c",
"_score": null,
"_source": {
"id": "3b421ab3af044a578433de5f1c14125c",
"autoIncrement": 3044.0
},
"fields": {
"displayGroup": [
"b50ad44091db5071a92df11dc3a2ec6b"
]
},
"sort": [
1981.0,
"3b421ab3af044a578433de5f1c14125c"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "da20b9595ebe4d06b5313c95cab04464",
"_score": null,
"_source": {
"id": "da20b9595ebe4d06b5313c95cab04464",
"autoIncrement": 3045.0
},
"fields": {
"displayGroup": [
"c5521a0f8097fe6a152acdbf53187984"
]
},
"sort": [
1980.0,
"da20b9595ebe4d06b5313c95cab04464"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "7c3eddb777be41c8a13432b6c4d6302e",
"_score": null,
"_source": {
"id": "7c3eddb777be41c8a13432b6c4d6302e",
"autoIncrement": 981.0
},
"fields": {
"displayGroup": [
"7cef5ec3e7b319ddb359228be9951e93"
]
},
"sort": [
1979.0,
"7c3eddb777be41c8a13432b6c4d6302e"
]
}
]
},
"aggregations": {
"total-count": {
"value": 57
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
1.55 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":"a1853caed9e644a99d597e4b17da6ac5"}}}},{"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": 57,
"rating": {
"value": 0.0
}
},
"properties": {
"doc_count": 795,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "256aa072d598469cbe2a99d63859b36e",
"doc_count": 57
},
{
"key": "2641f8888eea4fb68d423e97f3399a88",
"doc_count": 57
},
{
"key": "45018ee86cc84c47b8d18583215e11fb",
"doc_count": 57
},
{
"key": "c00d09ec51844aefa2781fcc00839644",
"doc_count": 57
},
{
"key": "df10d98b0f734d97b772665f9d8e5c4e",
"doc_count": 57
},
{
"key": "f31c43715025471199f45ce9f8f03d77",
"doc_count": 57
},
{
"key": "f3addfa0aa8f492b93ef4d41f76ff1fd",
"doc_count": 57
},
{
"key": "5da84ba5d2244bf1be9feadcba813cfd",
"doc_count": 55
},
{
"key": "a6ab6bf14e60463b9609c75edbf26193",
"doc_count": 54
},
{
"key": "b1db92116aaf46d5a308b7ad5f134d9d",
"doc_count": 54
},
{
"key": "5d7cdee62433436cb5ff14b769ad2b3e",
"doc_count": 52
},
{
"key": "7b0b4005d21e44b096ed3d4b26b4f971",
"doc_count": 49
},
{
"key": "0aabada48aa64df995d6e54d86f3779b",
"doc_count": 36
},
{
"key": "c4bb576e968f4bd7995150ffc4a7a44d",
"doc_count": 8
},
{
"key": "70d623b6cfc0418c841d5717feb365d3",
"doc_count": 6
},
{
"key": "8483761088294ffa80403e23c4ad284f",
"doc_count": 5
},
{
"key": "5b2854b6c9da458e8bf92359a79545e8",
"doc_count": 3
},
{
"key": "adfd37fa8d88405d8be97bde6b963aef",
"doc_count": 3
},
{
"key": "b1fab21e8d1f46deb424703d0e124d9d",
"doc_count": 3
},
{
"key": "ff72a755153044a4bd2a2da464d123b6",
"doc_count": 3
},
{
"key": "0d9c94bf2b884dc4a0eab0e95173ea42",
"doc_count": 2
},
{
"key": "27afa12e8fd1402e8ce3638e19a98d9a",
"doc_count": 2
},
{
"key": "2cfa71698f8846af805a68264beefa3c",
"doc_count": 2
},
{
"key": "54ce87786b834c69b24ae0297c9f0351",
"doc_count": 2
},
{
"key": "60f3a33fb6e74ec0b6c83ace74194df5",
"doc_count": 2
},
{
"key": "84fc9ece27334fcfa64b2186bd31627f",
"doc_count": 2
},
{
"key": "9a60f14fa86443ff98d00b82e1578dd0",
"doc_count": 2
},
{
"key": "a22ffb31eeef4dec9f2742125159dc7d",
"doc_count": 2
},
{
"key": "b040cc0159d544d7b4d29a65b03e143c",
"doc_count": 2
},
{
"key": "cdd1e121488840ffaff218a71c4a8a7c",
"doc_count": 2
},
{
"key": "d203639f7b4541deab3c1d6440258dd4",
"doc_count": 2
},
{
"key": "06e4d27eb94d4cc1aca5541219423d71",
"doc_count": 1
},
{
"key": "0ad2db72f8c446a29c956ed6e9f78fb4",
"doc_count": 1
},
{
"key": "14fd0605339a47ad8436471564c5813d",
"doc_count": 1
},
{
"key": "19ff354e70aa45dba8fe4f7c2f81db8a",
"doc_count": 1
},
{
"key": "1af482d544b54aecac5af66a28566895",
"doc_count": 1
},
{
"key": "1baebe6a6ef6423f95778600eb89c7f8",
"doc_count": 1
},
{
"key": "31436e1f2add44468bf2734baf79dbb0",
"doc_count": 1
},
{
"key": "3769eba6ea054b828bc9d6a594785c6e",
"doc_count": 1
},
{
"key": "3c038b44e46442589661994ae6e4eb42",
"doc_count": 1
},
{
"key": "412fad5d763d48ee911d9bfb941f6035",
"doc_count": 1
},
{
"key": "4760288d3c8d46debac89a227e38d01f",
"doc_count": 1
},
{
"key": "4f146b4ced904c95b0ff8ceaf78bfe3a",
"doc_count": 1
},
{
"key": "500862fb9a8c42a68b2e433c9014ab58",
"doc_count": 1
},
{
"key": "5ab38019ed7843e7b3b2218c5a19e933",
"doc_count": 1
},
{
"key": "5abe5490998f44e89091f30e98759fe5",
"doc_count": 1
},
{
"key": "5d6f6e6d29aa404f8d54b3c4ab0af26d",
"doc_count": 1
},
{
"key": "8a6ac1662b934451b6e3bc6e665c3bea",
"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": "9f63f7a9675e490aa0c2ce7eb91381df",
"doc_count": 1
},
{
"key": "adac28fc0ee643c1b43adea098dca42c",
"doc_count": 1
},
{
"key": "ae21e9df3c704e44964baa3298dfb679",
"doc_count": 1
},
{
"key": "b0fd24cfb9784ab4a1236ab5ece09415",
"doc_count": 1
},
{
"key": "b6384ba7bcb74086b88386d26347569d",
"doc_count": 1
},
{
"key": "b81318b1758e42bc8be1559a7f6df0bc",
"doc_count": 1
},
{
"key": "bf2d854da22c41e0a79a72de4697db5b",
"doc_count": 1
},
{
"key": "c6c41d85dee047eb85a5a6e772cf38e2",
"doc_count": 1
},
{
"key": "c7cc8a656cf841ca898ab1f1ad507138",
"doc_count": 1
},
{
"key": "ca0798b913784ff9880ac954d5b61825",
"doc_count": 1
},
{
"key": "cc5ba8979f7a4fa1bf4bac8182181d79",
"doc_count": 1
},
{
"key": "cc61a08034264c0db3ba4fd0c3cac5e0",
"doc_count": 1
},
{
"key": "cca45554e2274564aa8fdc6adc80a860",
"doc_count": 1
},
{
"key": "ce44d69a3e4e46ce9aa84b8515364889",
"doc_count": 1
},
{
"key": "cf387c70e3fa4517b5dc2e6ed19660c6",
"doc_count": 1
},
{
"key": "d0fdde06c70d42ed93c6ec4b8fe0f969",
"doc_count": 1
},
{
"key": "d18fbc4b529040d8a24ce72556f64454",
"doc_count": 1
},
{
"key": "d87edd2454464161b85302e13bb3d42d",
"doc_count": 1
},
{
"key": "e8800fea53ee4087a0afd683a283ac96",
"doc_count": 1
},
{
"key": "eff689d23e264c44b773885f2a4a39e9",
"doc_count": 1
},
{
"key": "fcebc86ac3954b8092f471d6315e7c61",
"doc_count": 1
}
]
}
},
"price": {
"count": 57,
"min": 0.0,
"max": 2837.83,
"avg": 1597.2715789473684,
"sum": 91044.48
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "2a164e08292b491997d23e90d110b622",
"doc_count": 57
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|