| 1 |
5.01 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":"15ad0b07c6df47018879a49046fc96d8"}}}},{"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":0,"size":36,"collapse":{"field":"displayGroup"},"timeout":"5s"}}
{
"took": 1,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 19,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "rosland_product_1712914068",
"_id": "1391e2cb53124bb9a46d9a74993a6de5",
"_score": null,
"_source": {
"id": "1391e2cb53124bb9a46d9a74993a6de5",
"autoIncrement": 3279.0
},
"fields": {
"displayGroup": [
"6cfc5b60cb4e15683055d8e953fe2002"
]
},
"sort": [
2020.0,
"1391e2cb53124bb9a46d9a74993a6de5"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "8721af90937642cfbed3c18f2f40ca0d",
"_score": null,
"_source": {
"id": "8721af90937642cfbed3c18f2f40ca0d",
"autoIncrement": 3651.0
},
"fields": {
"displayGroup": [
"3d4743ae501453ec53acf98cd9220989"
]
},
"sort": [
2020.0,
"8721af90937642cfbed3c18f2f40ca0d"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "10967d7f729b4aaca66442a8502352f3",
"_score": null,
"_source": {
"id": "10967d7f729b4aaca66442a8502352f3",
"autoIncrement": 3773.0
},
"fields": {
"displayGroup": [
"85aad0bc999f3970b59362068bb597e0"
]
},
"sort": [
2019.0,
"10967d7f729b4aaca66442a8502352f3"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "19f2969318464bf1bccc00758082f3d9",
"_score": null,
"_source": {
"id": "19f2969318464bf1bccc00758082f3d9",
"autoIncrement": 2274.0
},
"fields": {
"displayGroup": [
"82d598cf3943f32cd93034c1d59d714d"
]
},
"sort": [
2019.0,
"19f2969318464bf1bccc00758082f3d9"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "25e532214f4747ff82bfc19cf8ecb847",
"_score": null,
"_source": {
"id": "25e532214f4747ff82bfc19cf8ecb847",
"autoIncrement": 4038.0
},
"fields": {
"displayGroup": [
"cbf510684370ca1585f1537b665cabfa"
]
},
"sort": [
2019.0,
"25e532214f4747ff82bfc19cf8ecb847"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "2fea6a104a45457cb4ee98781c22150c",
"_score": null,
"_source": {
"id": "2fea6a104a45457cb4ee98781c22150c",
"autoIncrement": 3771.0
},
"fields": {
"displayGroup": [
"895c573b9ddb7507239b2a2d773bc3ce"
]
},
"sort": [
2019.0,
"2fea6a104a45457cb4ee98781c22150c"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "45e9a0dbb60141dbb9cace4e1ad5b07e",
"_score": null,
"_source": {
"id": "45e9a0dbb60141dbb9cace4e1ad5b07e",
"autoIncrement": 2269.0
},
"fields": {
"displayGroup": [
"551bde8045439b293e02866bbe5db333"
]
},
"sort": [
2019.0,
"45e9a0dbb60141dbb9cace4e1ad5b07e"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "6487e60766124261963f786b72b770e9",
"_score": null,
"_source": {
"id": "6487e60766124261963f786b72b770e9",
"autoIncrement": 2217.0
},
"fields": {
"displayGroup": [
"5a94593434832a4aa2bdcd7a012b6c39"
]
},
"sort": [
2019.0,
"6487e60766124261963f786b72b770e9"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "8008783cc53a4c1085ef3aa1f4382169",
"_score": null,
"_source": {
"id": "8008783cc53a4c1085ef3aa1f4382169",
"autoIncrement": 3584.0
},
"fields": {
"displayGroup": [
"63297c1767b0f60de788d93fc4556445"
]
},
"sort": [
2019.0,
"8008783cc53a4c1085ef3aa1f4382169"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "933274e9a97840e39f426c4a42c287c5",
"_score": null,
"_source": {
"id": "933274e9a97840e39f426c4a42c287c5",
"autoIncrement": 2293.0
},
"fields": {
"displayGroup": [
"c97233c6b35484a5ffd342eea67231e4"
]
},
"sort": [
2019.0,
"933274e9a97840e39f426c4a42c287c5"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "9f08622143f746ec96bfa8bdad8b6991",
"_score": null,
"_source": {
"id": "9f08622143f746ec96bfa8bdad8b6991",
"autoIncrement": 2406.0
},
"fields": {
"displayGroup": [
"5a5b1949244afbd769dbf47d46d81df8"
]
},
"sort": [
2019.0,
"9f08622143f746ec96bfa8bdad8b6991"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "be3ca0c79af447fdae8433c5421c1606",
"_score": null,
"_source": {
"id": "be3ca0c79af447fdae8433c5421c1606",
"autoIncrement": 3244.0
},
"fields": {
"displayGroup": [
"d26176737856482dc1fd8fcbd1d9347c"
]
},
"sort": [
2019.0,
"be3ca0c79af447fdae8433c5421c1606"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "c0310adc02b347bc95ab79b96b8d7ff0",
"_score": null,
"_source": {
"id": "c0310adc02b347bc95ab79b96b8d7ff0",
"autoIncrement": 2294.0
},
"fields": {
"displayGroup": [
"bc77a1d2ba791022c661cf1ed9bff2ca"
]
},
"sort": [
2019.0,
"c0310adc02b347bc95ab79b96b8d7ff0"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "28db267ec9784cfeb5d47cf4ed83b355",
"_score": null,
"_source": {
"id": "28db267ec9784cfeb5d47cf4ed83b355",
"autoIncrement": 2277.0
},
"fields": {
"displayGroup": [
"cfa7d741d47614823784c4c5beee1fc7"
]
},
"sort": [
2018.0,
"28db267ec9784cfeb5d47cf4ed83b355"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "8d4ccce52f424265b17f1dd2efcb0dbd",
"_score": null,
"_source": {
"id": "8d4ccce52f424265b17f1dd2efcb0dbd",
"autoIncrement": 2275.0
},
"fields": {
"displayGroup": [
"66fdc9054aa0ffe671699b52847351c7"
]
},
"sort": [
2018.0,
"8d4ccce52f424265b17f1dd2efcb0dbd"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "accc9b97e6da4c158ea070ba9de0f2b3",
"_score": null,
"_source": {
"id": "accc9b97e6da4c158ea070ba9de0f2b3",
"autoIncrement": 2296.0
},
"fields": {
"displayGroup": [
"f96e92ffc748682b4c49550a89ad298f"
]
},
"sort": [
2018.0,
"accc9b97e6da4c158ea070ba9de0f2b3"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "d50bd3c7c49b459aa78ad1473af12554",
"_score": null,
"_source": {
"id": "d50bd3c7c49b459aa78ad1473af12554",
"autoIncrement": 2276.0
},
"fields": {
"displayGroup": [
"2086c7187cc24fb900d88e984881bed4"
]
},
"sort": [
2018.0,
"d50bd3c7c49b459aa78ad1473af12554"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "68ec70ffb5444fccbadefe9561835286",
"_score": null,
"_source": {
"id": "68ec70ffb5444fccbadefe9561835286",
"autoIncrement": 2299.0
},
"fields": {
"displayGroup": [
"32b0dd25e31c41ed0b179ac18467599b"
]
},
"sort": [
2017.0,
"68ec70ffb5444fccbadefe9561835286"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "197d160a37e74cf5a31d2421cc486bbf",
"_score": null,
"_source": {
"id": "197d160a37e74cf5a31d2421cc486bbf",
"autoIncrement": 2317.0
},
"fields": {
"displayGroup": [
"985b3c58e1f88cd31cb3f53c9e15784b"
]
},
"sort": [
2016.0,
"197d160a37e74cf5a31d2421cc486bbf"
]
}
]
},
"aggregations": {
"total-count": {
"value": 19
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
3.16 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":"15ad0b07c6df47018879a49046fc96d8"}}}},{"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": 1,
"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": 19,
"rating": {
"value": 0.0
}
},
"properties": {
"doc_count": 319,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "0c189ea565ab4573a222115adc6b9258",
"doc_count": 19
},
{
"key": "45018ee86cc84c47b8d18583215e11fb",
"doc_count": 19
},
{
"key": "9df1f8eac8844fb78c61ebcc956e81ef",
"doc_count": 19
},
{
"key": "d3cfb18b53ee4a4486a2f4d64f53934f",
"doc_count": 19
},
{
"key": "457816050d9e4b619e7fdddfbf31b579",
"doc_count": 18
},
{
"key": "975484cdbc7c495e9a09a3f4f25f6847",
"doc_count": 18
},
{
"key": "f3addfa0aa8f492b93ef4d41f76ff1fd",
"doc_count": 18
},
{
"key": "256aa072d598469cbe2a99d63859b36e",
"doc_count": 17
},
{
"key": "da388262b87f4c54894feeceb9dd421b",
"doc_count": 17
},
{
"key": "4a41330c89cb476490a417a554331dd1",
"doc_count": 16
},
{
"key": "004c9f1122be4d3db1dadecc53a44cdf",
"doc_count": 13
},
{
"key": "50bede51bbaa4f4aba7003a45cf998b3",
"doc_count": 13
},
{
"key": "d0c07ddcae6a4425b96e363887660b9f",
"doc_count": 13
},
{
"key": "f7fcd5b43919408abc47ad22817057e8",
"doc_count": 12
},
{
"key": "412fad5d763d48ee911d9bfb941f6035",
"doc_count": 11
},
{
"key": "adfd37fa8d88405d8be97bde6b963aef",
"doc_count": 11
},
{
"key": "d4a351b83deb42719a00ef284e34b4ce",
"doc_count": 9
},
{
"key": "c00d09ec51844aefa2781fcc00839644",
"doc_count": 6
},
{
"key": "745d9946202e4310a3288c5a80070301",
"doc_count": 4
},
{
"key": "998c9b372d1a4245a79724d3c6f0289e",
"doc_count": 4
},
{
"key": "b81318b1758e42bc8be1559a7f6df0bc",
"doc_count": 4
},
{
"key": "5a8984c734114bf1b451b075e95ad39e",
"doc_count": 3
},
{
"key": "65798a73c7e44bcdbe0b0f0b53116c84",
"doc_count": 3
},
{
"key": "cdd1e121488840ffaff218a71c4a8a7c",
"doc_count": 3
},
{
"key": "4e8f4484450047368546753112add0e2",
"doc_count": 2
},
{
"key": "7eca40a09a444ee59ebd2fecc9f0b2c4",
"doc_count": 2
},
{
"key": "80e833585b2c4aca950cebfb2aaabd1a",
"doc_count": 2
},
{
"key": "ca0798b913784ff9880ac954d5b61825",
"doc_count": 2
},
{
"key": "da73ead1b1964a929f9369fb17e21c3b",
"doc_count": 2
},
{
"key": "e5a5c0592e9b45da82d0ad1d7197cf9e",
"doc_count": 2
},
{
"key": "eacf349b35b7494c8bbf7cb92ee7e3d6",
"doc_count": 2
},
{
"key": "0ad2db72f8c446a29c956ed6e9f78fb4",
"doc_count": 1
},
{
"key": "0e6f6477a8a54b0e9406d075177724cf",
"doc_count": 1
},
{
"key": "1af482d544b54aecac5af66a28566895",
"doc_count": 1
},
{
"key": "283841f65684409691814a47efb14105",
"doc_count": 1
},
{
"key": "4973c89b40144af0a4bedcb6bcfbcff9",
"doc_count": 1
},
{
"key": "51ebe59299ac4057b371590d933448f3",
"doc_count": 1
},
{
"key": "8362224e957a4a70b2c7dddfbd1bf8b6",
"doc_count": 1
},
{
"key": "950074db1e3749c6a39dbce3b25beda3",
"doc_count": 1
},
{
"key": "abe6ca0898974724a606701d0a613a6c",
"doc_count": 1
},
{
"key": "b57d1d0eb833459bbda07a3adca6714c",
"doc_count": 1
},
{
"key": "b8dd631079d34d42b559a3eb42f6cfa6",
"doc_count": 1
},
{
"key": "d74cd11363364391ae490de23f06e212",
"doc_count": 1
},
{
"key": "d87edd2454464161b85302e13bb3d42d",
"doc_count": 1
},
{
"key": "ddf74bb0583c4c78bac5bf9349dc5a03",
"doc_count": 1
},
{
"key": "e71f0585bceb424f9fdfadca9b86393d",
"doc_count": 1
},
{
"key": "f38c00d66e7340cf9c07fd64a8c1204b",
"doc_count": 1
}
]
}
},
"price": {
"count": 19,
"min": 0.0,
"max": 178.63,
"avg": 21.21736842105263,
"sum": 403.13
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "f32ad5b6af944339ba4b06355caa88da",
"doc_count": 19
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|