| 1 |
5.76 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":"b7f0ffeddcb94f2588e4ad79c4851271"}}}},{"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": 52,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "rosland_product_1712914068",
"_id": "db280220f53140a0aaa0001c7864d2ac",
"_score": null,
"_source": {
"id": "db280220f53140a0aaa0001c7864d2ac",
"autoIncrement": 1242.0
},
"fields": {
"displayGroup": [
"d6f8cf766ad72e24bcfe8b3e661f040d"
]
},
"sort": [
1992.0,
"db280220f53140a0aaa0001c7864d2ac"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "9da93521cfe64d90ad7197abbceb801a",
"_score": null,
"_source": {
"id": "9da93521cfe64d90ad7197abbceb801a",
"autoIncrement": 3513.0
},
"fields": {
"displayGroup": [
"271c509da74ac9c33d1712aa30ee518a"
]
},
"sort": [
1991.0,
"9da93521cfe64d90ad7197abbceb801a"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "e88abc9054094b52935e9cc625280c1b",
"_score": null,
"_source": {
"id": "e88abc9054094b52935e9cc625280c1b",
"autoIncrement": 1243.0
},
"fields": {
"displayGroup": [
"4958f8abd7f754ac1d3ffc361083a168"
]
},
"sort": [
1991.0,
"e88abc9054094b52935e9cc625280c1b"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "b5a32c2b0ec545fc85473aac5fefa915",
"_score": null,
"_source": {
"id": "b5a32c2b0ec545fc85473aac5fefa915",
"autoIncrement": 3081.0
},
"fields": {
"displayGroup": [
"80289eb816f7c0c4db659ac0b33e2f5f"
]
},
"sort": [
1990.0,
"b5a32c2b0ec545fc85473aac5fefa915"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "c18cefedbb934970ac0909f0b69e04b3",
"_score": null,
"_source": {
"id": "c18cefedbb934970ac0909f0b69e04b3",
"autoIncrement": 1244.0
},
"fields": {
"displayGroup": [
"4d449df21e750cbd3ef1e10ae970c9d2"
]
},
"sort": [
1990.0,
"c18cefedbb934970ac0909f0b69e04b3"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "a014006d635a428bb324abe540cf487e",
"_score": null,
"_source": {
"id": "a014006d635a428bb324abe540cf487e",
"autoIncrement": 1245.0
},
"fields": {
"displayGroup": [
"095b8ac7680374e72a2a51d54a8392e4"
]
},
"sort": [
1989.0,
"a014006d635a428bb324abe540cf487e"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "f470d47966ff4ed5b5a517bd36c159e3",
"_score": null,
"_source": {
"id": "f470d47966ff4ed5b5a517bd36c159e3",
"autoIncrement": 1246.0
},
"fields": {
"displayGroup": [
"ca69c827bee02c38fcb30aaee9a58629"
]
},
"sort": [
1989.0,
"f470d47966ff4ed5b5a517bd36c159e3"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "1f65f787d0bd472eb278722030b0e406",
"_score": null,
"_source": {
"id": "1f65f787d0bd472eb278722030b0e406",
"autoIncrement": 3082.0
},
"fields": {
"displayGroup": [
"09265aa8a55809d92a1ca5278b10490a"
]
},
"sort": [
1988.0,
"1f65f787d0bd472eb278722030b0e406"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "d86e4ab8cece4ea8abfbd587166a69bf",
"_score": null,
"_source": {
"id": "d86e4ab8cece4ea8abfbd587166a69bf",
"autoIncrement": 1247.0
},
"fields": {
"displayGroup": [
"f15ae1bbcf34ad4e4c239b6443cbaf86"
]
},
"sort": [
1988.0,
"d86e4ab8cece4ea8abfbd587166a69bf"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "2aad059c9919488689b7c6238f737c50",
"_score": null,
"_source": {
"id": "2aad059c9919488689b7c6238f737c50",
"autoIncrement": 1248.0
},
"fields": {
"displayGroup": [
"bfe1a291ffa141ec7d04f8abaddc3d85"
]
},
"sort": [
1987.0,
"2aad059c9919488689b7c6238f737c50"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "b80eed24212e45eea060405604311e46",
"_score": null,
"_source": {
"id": "b80eed24212e45eea060405604311e46",
"autoIncrement": 1249.0
},
"fields": {
"displayGroup": [
"a9d4b998b11e8bda7452c95f02d5ee66"
]
},
"sort": [
1987.0,
"b80eed24212e45eea060405604311e46"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "2d3681703dcc48779834f8ddf9d9be90",
"_score": null,
"_source": {
"id": "2d3681703dcc48779834f8ddf9d9be90",
"autoIncrement": 1250.0
},
"fields": {
"displayGroup": [
"67d99ce0054d582505c5a3e2ada3847e"
]
},
"sort": [
1986.0,
"2d3681703dcc48779834f8ddf9d9be90"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "dfa85eb1b36348528afcce10fbbe2229",
"_score": null,
"_source": {
"id": "dfa85eb1b36348528afcce10fbbe2229",
"autoIncrement": 1251.0
},
"fields": {
"displayGroup": [
"fbc584a374a0369ba67a014ea72379d0"
]
},
"sort": [
1985.0,
"dfa85eb1b36348528afcce10fbbe2229"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "dfe2ac39e4f942959a826b778c6291cd",
"_score": null,
"_source": {
"id": "dfe2ac39e4f942959a826b778c6291cd",
"autoIncrement": 3083.0
},
"fields": {
"displayGroup": [
"0ba0ead4d15e639cc1e315c2dbf9de15"
]
},
"sort": [
1984.0,
"dfe2ac39e4f942959a826b778c6291cd"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "e9cbd105acca4845871e186b61a5cf0d",
"_score": null,
"_source": {
"id": "e9cbd105acca4845871e186b61a5cf0d",
"autoIncrement": 3084.0
},
"fields": {
"displayGroup": [
"71823cabf550e870d19a02b1b57bfb38"
]
},
"sort": [
1983.0,
"e9cbd105acca4845871e186b61a5cf0d"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "c7486142c51044cb9a74a2c538cdf340",
"_score": null,
"_source": {
"id": "c7486142c51044cb9a74a2c538cdf340",
"autoIncrement": 1252.0
},
"fields": {
"displayGroup": [
"ca449bf337c7b418c333a630fe8fff54"
]
},
"sort": [
1982.0,
"c7486142c51044cb9a74a2c538cdf340"
]
}
]
},
"aggregations": {
"total-count": {
"value": 52
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
2.35 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":"b7f0ffeddcb94f2588e4ad79c4851271"}}}},{"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": 52,
"rating": {
"value": 0.0
}
},
"properties": {
"doc_count": 743,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "158d4f380ddb43d482095779cfffafa8",
"doc_count": 52
},
{
"key": "256aa072d598469cbe2a99d63859b36e",
"doc_count": 52
},
{
"key": "45018ee86cc84c47b8d18583215e11fb",
"doc_count": 52
},
{
"key": "5a62d81b4f86473eb7f81295523b0456",
"doc_count": 52
},
{
"key": "8ea6d7bbbcd24ac7857d738dbba7d056",
"doc_count": 52
},
{
"key": "f38c00d66e7340cf9c07fd64a8c1204b",
"doc_count": 52
},
{
"key": "f3addfa0aa8f492b93ef4d41f76ff1fd",
"doc_count": 52
},
{
"key": "98301be66a2c41a4914eda011b8b4795",
"doc_count": 51
},
{
"key": "02416711dcc64bba92f95ffae7c16671",
"doc_count": 50
},
{
"key": "c00d09ec51844aefa2781fcc00839644",
"doc_count": 50
},
{
"key": "6d5bc77d42c84ed482f0e82e8be1f36e",
"doc_count": 49
},
{
"key": "d3359e7ac09a42d3b7d5cf34c349a688",
"doc_count": 45
},
{
"key": "eab1bcb867d9474d97d362b23d3fb7f9",
"doc_count": 45
},
{
"key": "da73ead1b1964a929f9369fb17e21c3b",
"doc_count": 5
},
{
"key": "51ebe59299ac4057b371590d933448f3",
"doc_count": 4
},
{
"key": "2cbd54e475564611a23ed8d306d7e513",
"doc_count": 3
},
{
"key": "8b0f7248c5754108b4aa3d1bfc8237b9",
"doc_count": 3
},
{
"key": "adac28fc0ee643c1b43adea098dca42c",
"doc_count": 3
},
{
"key": "eacf349b35b7494c8bbf7cb92ee7e3d6",
"doc_count": 3
},
{
"key": "14fd0605339a47ad8436471564c5813d",
"doc_count": 2
},
{
"key": "19ff354e70aa45dba8fe4f7c2f81db8a",
"doc_count": 2
},
{
"key": "1baebe6a6ef6423f95778600eb89c7f8",
"doc_count": 2
},
{
"key": "27afa12e8fd1402e8ce3638e19a98d9a",
"doc_count": 2
},
{
"key": "2cfa71698f8846af805a68264beefa3c",
"doc_count": 2
},
{
"key": "3c038b44e46442589661994ae6e4eb42",
"doc_count": 2
},
{
"key": "54ce87786b834c69b24ae0297c9f0351",
"doc_count": 2
},
{
"key": "93dcea5ec8474de58987a8a26d862a8d",
"doc_count": 2
},
{
"key": "a22ffb31eeef4dec9f2742125159dc7d",
"doc_count": 2
},
{
"key": "ae21e9df3c704e44964baa3298dfb679",
"doc_count": 2
},
{
"key": "b1db92116aaf46d5a308b7ad5f134d9d",
"doc_count": 2
},
{
"key": "cc61a08034264c0db3ba4fd0c3cac5e0",
"doc_count": 2
},
{
"key": "cca45554e2274564aa8fdc6adc80a860",
"doc_count": 2
},
{
"key": "cf387c70e3fa4517b5dc2e6ed19660c6",
"doc_count": 2
},
{
"key": "d203639f7b4541deab3c1d6440258dd4",
"doc_count": 2
},
{
"key": "e8800fea53ee4087a0afd683a283ac96",
"doc_count": 2
},
{
"key": "eff689d23e264c44b773885f2a4a39e9",
"doc_count": 2
},
{
"key": "004c9f1122be4d3db1dadecc53a44cdf",
"doc_count": 1
},
{
"key": "06e4d27eb94d4cc1aca5541219423d71",
"doc_count": 1
},
{
"key": "2cffdfecef9144dea2c068d9a1031bf9",
"doc_count": 1
},
{
"key": "31436e1f2add44468bf2734baf79dbb0",
"doc_count": 1
},
{
"key": "3c115623f5dd4cd582b1d72fad3a46b1",
"doc_count": 1
},
{
"key": "42bf60d0ac5f4088bd11b270c7f4bbba",
"doc_count": 1
},
{
"key": "4f146b4ced904c95b0ff8ceaf78bfe3a",
"doc_count": 1
},
{
"key": "50bede51bbaa4f4aba7003a45cf998b3",
"doc_count": 1
},
{
"key": "5abe5490998f44e89091f30e98759fe5",
"doc_count": 1
},
{
"key": "5b2854b6c9da458e8bf92359a79545e8",
"doc_count": 1
},
{
"key": "5c8ce0068bdf4ea59357c705321d4e69",
"doc_count": 1
},
{
"key": "60f3a33fb6e74ec0b6c83ace74194df5",
"doc_count": 1
},
{
"key": "66817f91e0e94bce8ec2301a4ac4f33f",
"doc_count": 1
},
{
"key": "6a88c6ab01f84a669b021e9ca398ffe0",
"doc_count": 1
},
{
"key": "708db4bc3aa84113a697f7dbf46efdd6",
"doc_count": 1
},
{
"key": "84fc9ece27334fcfa64b2186bd31627f",
"doc_count": 1
},
{
"key": "8dedb3f255ff420ba88ac7fb25b2d50c",
"doc_count": 1
},
{
"key": "8f43a9ecba1f4737931ca3dfe93fd817",
"doc_count": 1
},
{
"key": "9270bfdb608f44aba87a8540c8d22a10",
"doc_count": 1
},
{
"key": "950074db1e3749c6a39dbce3b25beda3",
"doc_count": 1
},
{
"key": "9861fdd7cd7f48188c9ab82dd0c9556a",
"doc_count": 1
},
{
"key": "9a60f14fa86443ff98d00b82e1578dd0",
"doc_count": 1
},
{
"key": "9bb7ca6b9cb24df9865a0a24ac04c7d9",
"doc_count": 1
},
{
"key": "b0fd24cfb9784ab4a1236ab5ece09415",
"doc_count": 1
},
{
"key": "b81318b1758e42bc8be1559a7f6df0bc",
"doc_count": 1
},
{
"key": "bf2d854da22c41e0a79a72de4697db5b",
"doc_count": 1
},
{
"key": "c6c41d85dee047eb85a5a6e772cf38e2",
"doc_count": 1
},
{
"key": "cc5ba8979f7a4fa1bf4bac8182181d79",
"doc_count": 1
},
{
"key": "ce44d69a3e4e46ce9aa84b8515364889",
"doc_count": 1
},
{
"key": "d0c07ddcae6a4425b96e363887660b9f",
"doc_count": 1
},
{
"key": "d275662a42aa46feb5665fe6dba4e9d7",
"doc_count": 1
},
{
"key": "e6c4733ea9864002a14fabea18b4c67a",
"doc_count": 1
},
{
"key": "fcebc86ac3954b8092f471d6315e7c61",
"doc_count": 1
},
{
"key": "ff0342690efc467cbfa11fc7bee27cdd",
"doc_count": 1
}
]
}
},
"price": {
"count": 52,
"min": 0.0,
"max": 5545.41,
"avg": 1974.6836538461537,
"sum": 102683.54999999999
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "e4c4bbe038b843de97e4cc3d27d3ee57",
"doc_count": 52
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|