| 1 |
2.65 ms |
Request:
{"index":"sw_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":"6ea664abc17141e6a0efa6d2ee317c7b"}}}},{"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": 26,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_product_1717666750",
"_id": "01959447d3357231bf316a0d18b69af7",
"_score": null,
"_source": {
"id": "01959447d3357231bf316a0d18b69af7",
"autoIncrement": 5086.0
},
"fields": {
"displayGroup": [
"a5273c3910fb62f38039a1e2799f5309"
]
},
"sort": [
2024.0,
"01959447d3357231bf316a0d18b69af7"
]
},
{
"_index": "sw_product_1717666750",
"_id": "0195944c471170a1aa872abac02ea9d6",
"_score": null,
"_source": {
"id": "0195944c471170a1aa872abac02ea9d6",
"autoIncrement": 5087.0
},
"fields": {
"displayGroup": [
"fb8d3a2f4f6ba9573091616e0ac83fdb"
]
},
"sort": [
2024.0,
"0195944c471170a1aa872abac02ea9d6"
]
},
{
"_index": "sw_product_1717666750",
"_id": "0195944f8604703791bcd3a6397f271b",
"_score": null,
"_source": {
"id": "0195944f8604703791bcd3a6397f271b",
"autoIncrement": 5088.0
},
"fields": {
"displayGroup": [
"50bdf51952085f4c219cfcd1b3cd0cb8"
]
},
"sort": [
2024.0,
"0195944f8604703791bcd3a6397f271b"
]
},
{
"_index": "sw_product_1717666750",
"_id": "0195945244f0731abf681a22b37955ca",
"_score": null,
"_source": {
"id": "0195945244f0731abf681a22b37955ca",
"autoIncrement": 5089.0
},
"fields": {
"displayGroup": [
"fa9b8d6c11e26201382dca34883b4124"
]
},
"sort": [
2024.0,
"0195945244f0731abf681a22b37955ca"
]
},
{
"_index": "sw_product_1717666750",
"_id": "9a8f1a40f4144e42af35a4c3a1a4b512",
"_score": null,
"_source": {
"id": "9a8f1a40f4144e42af35a4c3a1a4b512",
"autoIncrement": 4279.0
},
"fields": {
"displayGroup": [
"37fa93991380118070fc74f2c9ffab27"
]
},
"sort": [
2022.0,
"9a8f1a40f4144e42af35a4c3a1a4b512"
]
},
{
"_index": "sw_product_1717666750",
"_id": "018ebcd0310e712580b92be8a41dc0f4",
"_score": null,
"_source": {
"id": "018ebcd0310e712580b92be8a41dc0f4",
"autoIncrement": 4803.0
},
"fields": {
"displayGroup": [
"23de16bd6018058163b8b453bb8becbf"
]
},
"sort": [
2021.0,
"018ebcd0310e712580b92be8a41dc0f4"
]
},
{
"_index": "sw_product_1717666750",
"_id": "cda43abf2a4f48c0a032659df6c6f27b",
"_score": null,
"_source": {
"id": "cda43abf2a4f48c0a032659df6c6f27b",
"autoIncrement": 4173.0
},
"fields": {
"displayGroup": [
"54bb075ac5620322ee9ffdd83480fa71"
]
},
"sort": [
2021.0,
"cda43abf2a4f48c0a032659df6c6f27b"
]
},
{
"_index": "sw_product_1717666750",
"_id": "dc916e864f55472c995ad8d7eac835f3",
"_score": null,
"_source": {
"id": "dc916e864f55472c995ad8d7eac835f3",
"autoIncrement": 4132.0
},
"fields": {
"displayGroup": [
"cf3c156906685662cd97225e7c489c46"
]
},
"sort": [
2021.0,
"dc916e864f55472c995ad8d7eac835f3"
]
},
{
"_index": "sw_product_1717666750",
"_id": "32f6659cec1946968298a5568e59dbc9",
"_score": null,
"_source": {
"id": "32f6659cec1946968298a5568e59dbc9",
"autoIncrement": 2868.0
},
"fields": {
"displayGroup": [
"2f9c0b7dde2bfc63d0740dbb00010632"
]
},
"sort": [
2020.0,
"32f6659cec1946968298a5568e59dbc9"
]
},
{
"_index": "sw_product_1717666750",
"_id": "7a8e961a90454aacb470be1b079a7987",
"_score": null,
"_source": {
"id": "7a8e961a90454aacb470be1b079a7987",
"autoIncrement": 3691.0
},
"fields": {
"displayGroup": [
"2c36bb411e5e168ea8e8ff48d870b168"
]
},
"sort": [
2020.0,
"7a8e961a90454aacb470be1b079a7987"
]
},
{
"_index": "sw_product_1717666750",
"_id": "c0ce488cc2c8436bbc73dc95c8dd5861",
"_score": null,
"_source": {
"id": "c0ce488cc2c8436bbc73dc95c8dd5861",
"autoIncrement": 3696.0
},
"fields": {
"displayGroup": [
"4988250b8e899f1090dc8944acc41043"
]
},
"sort": [
2020.0,
"c0ce488cc2c8436bbc73dc95c8dd5861"
]
},
{
"_index": "sw_product_1717666750",
"_id": "e9d4f2321a144a3095ecf0ec794318fa",
"_score": null,
"_source": {
"id": "e9d4f2321a144a3095ecf0ec794318fa",
"autoIncrement": 2841.0
},
"fields": {
"displayGroup": [
"1319c81be7af3b8b505a1727eeeb403a"
]
},
"sort": [
2020.0,
"e9d4f2321a144a3095ecf0ec794318fa"
]
},
{
"_index": "sw_product_1717666750",
"_id": "0dc253ed442e4c99929d0c26d6e98647",
"_score": null,
"_source": {
"id": "0dc253ed442e4c99929d0c26d6e98647",
"autoIncrement": 3758.0
},
"fields": {
"displayGroup": [
"65087f9dff09b292407416b802d53f59"
]
},
"sort": [
2019.0,
"0dc253ed442e4c99929d0c26d6e98647"
]
},
{
"_index": "sw_product_1717666750",
"_id": "1280364704b64bcda1f421268de57dbf",
"_score": null,
"_source": {
"id": "1280364704b64bcda1f421268de57dbf",
"autoIncrement": 3463.0
},
"fields": {
"displayGroup": [
"ff61763ec4db1c9c3847cd427de85081"
]
},
"sort": [
2019.0,
"1280364704b64bcda1f421268de57dbf"
]
},
{
"_index": "sw_product_1717666750",
"_id": "226fbd5e0b5e4857a0f56e253782a51e",
"_score": null,
"_source": {
"id": "226fbd5e0b5e4857a0f56e253782a51e",
"autoIncrement": 3462.0
},
"fields": {
"displayGroup": [
"034ee7ea5cb99dcc0d20008c85da89c5"
]
},
"sort": [
2019.0,
"226fbd5e0b5e4857a0f56e253782a51e"
]
},
{
"_index": "sw_product_1717666750",
"_id": "7d9aaad389d34f6fa90e93e017eab1ed",
"_score": null,
"_source": {
"id": "7d9aaad389d34f6fa90e93e017eab1ed",
"autoIncrement": 3679.0
},
"fields": {
"displayGroup": [
"03113235fbe56f15a928d5890f1b0da9"
]
},
"sort": [
2019.0,
"7d9aaad389d34f6fa90e93e017eab1ed"
]
},
{
"_index": "sw_product_1717666750",
"_id": "d780c7fd62e0421a80d6a1540544b79b",
"_score": null,
"_source": {
"id": "d780c7fd62e0421a80d6a1540544b79b",
"autoIncrement": 2839.0
},
"fields": {
"displayGroup": [
"765b919ee49dc7f7430f82a693ef7533"
]
},
"sort": [
2019.0,
"d780c7fd62e0421a80d6a1540544b79b"
]
},
{
"_index": "sw_product_1717666750",
"_id": "fbaad7102c324c2eb59bda92c969c556",
"_score": null,
"_source": {
"id": "fbaad7102c324c2eb59bda92c969c556",
"autoIncrement": 3569.0
},
"fields": {
"displayGroup": [
"554c202c4c4ce8631238b80644306c85"
]
},
"sort": [
2019.0,
"fbaad7102c324c2eb59bda92c969c556"
]
},
{
"_index": "sw_product_1717666750",
"_id": "15a742999a1f4ce88ff422882af3079f",
"_score": null,
"_source": {
"id": "15a742999a1f4ce88ff422882af3079f",
"autoIncrement": 3361.0
},
"fields": {
"displayGroup": [
"c77afb4528e679d13d86c1e835dc0607"
]
},
"sort": [
2018.0,
"15a742999a1f4ce88ff422882af3079f"
]
},
{
"_index": "sw_product_1717666750",
"_id": "91864e33c37941238f4e8c01300f05ed",
"_score": null,
"_source": {
"id": "91864e33c37941238f4e8c01300f05ed",
"autoIncrement": 3359.0
},
"fields": {
"displayGroup": [
"b34865555d88f16d6dc7de7f0e003aa4"
]
},
"sort": [
2018.0,
"91864e33c37941238f4e8c01300f05ed"
]
},
{
"_index": "sw_product_1717666750",
"_id": "a94582ea1ff242249426f84d33421b68",
"_score": null,
"_source": {
"id": "a94582ea1ff242249426f84d33421b68",
"autoIncrement": 204.0
},
"fields": {
"displayGroup": [
"127449025f3c82d0723d34ab6eef78d7"
]
},
"sort": [
2018.0,
"a94582ea1ff242249426f84d33421b68"
]
},
{
"_index": "sw_product_1717666750",
"_id": "d25012f5c67d44c6a92a20ef976fb96b",
"_score": null,
"_source": {
"id": "d25012f5c67d44c6a92a20ef976fb96b",
"autoIncrement": 2559.0
},
"fields": {
"displayGroup": [
"467c3743f90e5501ee2f5ffce400f1ba"
]
},
"sort": [
2018.0,
"d25012f5c67d44c6a92a20ef976fb96b"
]
},
{
"_index": "sw_product_1717666750",
"_id": "ee53b6dbfa0e4b9fb5a04aa81d23d058",
"_score": null,
"_source": {
"id": "ee53b6dbfa0e4b9fb5a04aa81d23d058",
"autoIncrement": 2846.0
},
"fields": {
"displayGroup": [
"fd748e99ba70c7459be5bcbc126466d5"
]
},
"sort": [
2018.0,
"ee53b6dbfa0e4b9fb5a04aa81d23d058"
]
},
{
"_index": "sw_product_1717666750",
"_id": "732e1e9ee3174dbfaeec31c11739011d",
"_score": null,
"_source": {
"id": "732e1e9ee3174dbfaeec31c11739011d",
"autoIncrement": 441.0
},
"fields": {
"displayGroup": [
"ff6829c3daa1b7143c355398420dcd8a"
]
},
"sort": [
2017.0,
"732e1e9ee3174dbfaeec31c11739011d"
]
},
{
"_index": "sw_product_1717666750",
"_id": "b97fb6464d8d497e9a7cd85f855251b3",
"_score": null,
"_source": {
"id": "b97fb6464d8d497e9a7cd85f855251b3",
"autoIncrement": 3360.0
},
"fields": {
"displayGroup": [
"83506ce6e6809d66a183039b4d5c0922"
]
},
"sort": [
2017.0,
"b97fb6464d8d497e9a7cd85f855251b3"
]
},
{
"_index": "sw_product_1717666750",
"_id": "d02400245a214c0e8d8b5202366c8112",
"_score": null,
"_source": {
"id": "d02400245a214c0e8d8b5202366c8112",
"autoIncrement": 1046.0
},
"fields": {
"displayGroup": [
"c9f6a7ee1a73db78239adccea4f9b124"
]
},
"sort": [
2017.0,
"d02400245a214c0e8d8b5202366c8112"
]
}
]
},
"aggregations": {
"total-count": {
"value": 26
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
2.08 ms |
Request:
{"index":"sw_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":"6ea664abc17141e6a0efa6d2ee317c7b"}}}},{"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": {
"shipping-free-filter": {
"doc_count": 0,
"shipping-free": {
"value": null
}
},
"rating-exists": {
"doc_count": 26,
"rating": {
"value": 0.0
}
},
"price": {
"count": 26,
"min": 35.0,
"max": 3449.13,
"avg": 852.4319230769231,
"sum": 22163.23
},
"options": {
"doc_count": 0,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": []
}
},
"properties": {
"doc_count": 395,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "45018ee86cc84c47b8d18583215e11fb",
"doc_count": 26
},
{
"key": "70e8246142234bf3923338d04420df89",
"doc_count": 26
},
{
"key": "b1db92116aaf46d5a308b7ad5f134d9d",
"doc_count": 26
},
{
"key": "d3cfb18b53ee4a4486a2f4d64f53934f",
"doc_count": 26
},
{
"key": "de88ad12fea44d74b9c2a1f1edf7ecdf",
"doc_count": 26
},
{
"key": "256aa072d598469cbe2a99d63859b36e",
"doc_count": 25
},
{
"key": "d3a2f712b61249b2888f1f071396654b",
"doc_count": 25
},
{
"key": "f3addfa0aa8f492b93ef4d41f76ff1fd",
"doc_count": 25
},
{
"key": "7d8ad8823f454b6985e477453c0e195b",
"doc_count": 19
},
{
"key": "80e833585b2c4aca950cebfb2aaabd1a",
"doc_count": 18
},
{
"key": "c82b182269744cecbfea2fc49d9b6766",
"doc_count": 17
},
{
"key": "950074db1e3749c6a39dbce3b25beda3",
"doc_count": 10
},
{
"key": "da73ead1b1964a929f9369fb17e21c3b",
"doc_count": 10
},
{
"key": "b81318b1758e42bc8be1559a7f6df0bc",
"doc_count": 8
},
{
"key": "004c9f1122be4d3db1dadecc53a44cdf",
"doc_count": 6
},
{
"key": "0aabada48aa64df995d6e54d86f3779b",
"doc_count": 6
},
{
"key": "70d623b6cfc0418c841d5717feb365d3",
"doc_count": 6
},
{
"key": "adfd37fa8d88405d8be97bde6b963aef",
"doc_count": 6
},
{
"key": "d0c07ddcae6a4425b96e363887660b9f",
"doc_count": 6
},
{
"key": "eacf349b35b7494c8bbf7cb92ee7e3d6",
"doc_count": 6
},
{
"key": "018af03e1d7c7c8dabe65059358dbeba",
"doc_count": 5
},
{
"key": "998c9b372d1a4245a79724d3c6f0289e",
"doc_count": 5
},
{
"key": "f06e9cb8ae034829b52292d1dc937b5f",
"doc_count": 5
},
{
"key": "39556c542db348c6ac22908d604d0d50",
"doc_count": 4
},
{
"key": "50bede51bbaa4f4aba7003a45cf998b3",
"doc_count": 4
},
{
"key": "556705f410e2457383395ccdac88e393",
"doc_count": 4
},
{
"key": "af4493ae34e84428bc07df5696f8f180",
"doc_count": 4
},
{
"key": "ca0798b913784ff9880ac954d5b61825",
"doc_count": 4
},
{
"key": "0ad2db72f8c446a29c956ed6e9f78fb4",
"doc_count": 3
},
{
"key": "2502dd7c35f344aba0b2238740ee3157",
"doc_count": 3
},
{
"key": "b577174053d2456d8307a6b59d762ca8",
"doc_count": 3
},
{
"key": "c00d09ec51844aefa2781fcc00839644",
"doc_count": 3
},
{
"key": "5ab38019ed7843e7b3b2218c5a19e933",
"doc_count": 2
},
{
"key": "6d9393d5212f408991b5e01da2463513",
"doc_count": 2
},
{
"key": "719d6b854ce24a19b8d6e400d71142b6",
"doc_count": 2
},
{
"key": "bb2aca011dc44badab027fb55a1ec97b",
"doc_count": 2
},
{
"key": "e7c738c7b72544ef91970e7293647d75",
"doc_count": 2
},
{
"key": "0a2817a3ada641419609f11314724061",
"doc_count": 1
},
{
"key": "1a20ffe852d24f6688f20ab2a459f530",
"doc_count": 1
},
{
"key": "1ddc1e26f22149cfb512c7f91acbfe95",
"doc_count": 1
},
{
"key": "27e5bf7420c14d1e82c251f92742efbd",
"doc_count": 1
},
{
"key": "39af2c06830c4a2c97f9d7228ef1f853",
"doc_count": 1
},
{
"key": "45e07c1b54aa48e1b7472611452c5ae9",
"doc_count": 1
},
{
"key": "699eb37c46684e1cb3958b9bd268e87c",
"doc_count": 1
},
{
"key": "6f92af8d0f0a4ae99239c1bd9f68d3d3",
"doc_count": 1
},
{
"key": "7b0b4005d21e44b096ed3d4b26b4f971",
"doc_count": 1
},
{
"key": "7b75df5ba9904f16845036b9daf1d1d4",
"doc_count": 1
},
{
"key": "bb796c42107e4d5cbfcd5a57b76dd446",
"doc_count": 1
},
{
"key": "c7cc8a656cf841ca898ab1f1ad507138",
"doc_count": 1
},
{
"key": "d30f8cbee16747ebae7947ccac7cc2c2",
"doc_count": 1
},
{
"key": "d7835742aa644750b59473d1d473ccf7",
"doc_count": 1
},
{
"key": "e7ab134d7d664528b9eb1c6bfd8e26c7",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "0c6346a583ce4d0c93a8911b89371b9a",
"doc_count": 26
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|