| 1 |
6.31 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":"3e77a084c1ae4f5a87ed8a905ebac167"}}}},{"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": "018acbed6864721a9bc54fa881be3a78",
"_score": null,
"_source": {
"id": "018acbed6864721a9bc54fa881be3a78",
"autoIncrement": 4657.0
},
"fields": {
"displayGroup": [
"d611d0371e34c3e4ebb2ea5223fd1ec8"
]
},
"sort": [
2022.0,
"018acbed6864721a9bc54fa881be3a78"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "018acbf46fe2705d9ed661c00b017c03",
"_score": null,
"_source": {
"id": "018acbf46fe2705d9ed661c00b017c03",
"autoIncrement": 4660.0
},
"fields": {
"displayGroup": [
"5b78451cf247c6cdbaaebc09271e99cf"
]
},
"sort": [
2022.0,
"018acbf46fe2705d9ed661c00b017c03"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "018acbf67fcb7320a071a8578d8122bd",
"_score": null,
"_source": {
"id": "018acbf67fcb7320a071a8578d8122bd",
"autoIncrement": 4661.0
},
"fields": {
"displayGroup": [
"e88a201a1d16eecca4c19541d47220a3"
]
},
"sort": [
2022.0,
"018acbf67fcb7320a071a8578d8122bd"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "ff9984d114a744508c844b7c57ea345d",
"_score": null,
"_source": {
"id": "ff9984d114a744508c844b7c57ea345d",
"autoIncrement": 4385.0
},
"fields": {
"displayGroup": [
"86828b2c426b8ad4f9b67629f0aac1dd"
]
},
"sort": [
2021.0,
"ff9984d114a744508c844b7c57ea345d"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "75b18d6d47c44d6cb1cfbdc37d1b120b",
"_score": null,
"_source": {
"id": "75b18d6d47c44d6cb1cfbdc37d1b120b",
"autoIncrement": 4191.0
},
"fields": {
"displayGroup": [
"7f4e1f9b745b1136aa0650185a51601e"
]
},
"sort": [
2020.0,
"75b18d6d47c44d6cb1cfbdc37d1b120b"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "7c36c6927c6c4f268ad8bfc25fa3c802",
"_score": null,
"_source": {
"id": "7c36c6927c6c4f268ad8bfc25fa3c802",
"autoIncrement": 3291.0
},
"fields": {
"displayGroup": [
"36035075d6bd8e8c02842ca717d31d9a"
]
},
"sort": [
2019.0,
"7c36c6927c6c4f268ad8bfc25fa3c802"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "707e20e516264a488ed07d466950ed3a",
"_score": null,
"_source": {
"id": "707e20e516264a488ed07d466950ed3a",
"autoIncrement": 1744.0
},
"fields": {
"displayGroup": [
"d22deca641e07d387d6af5a0ab20028b"
]
},
"sort": [
2018.0,
"707e20e516264a488ed07d466950ed3a"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "7c70e4b4765245da9421de0ca43c1777",
"_score": null,
"_source": {
"id": "7c70e4b4765245da9421de0ca43c1777",
"autoIncrement": 3528.0
},
"fields": {
"displayGroup": [
"a8c84a66f644b222b277c160c8c57082"
]
},
"sort": [
2017.0,
"7c70e4b4765245da9421de0ca43c1777"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "6fe8532749a5489d88f9f3440b11704a",
"_score": null,
"_source": {
"id": "6fe8532749a5489d88f9f3440b11704a",
"autoIncrement": 1745.0
},
"fields": {
"displayGroup": [
"25388264e1abf505a20cbfdaef510aa4"
]
},
"sort": [
2016.0,
"6fe8532749a5489d88f9f3440b11704a"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "6ca71bfc24564c1cb9d01dda19435a58",
"_score": null,
"_source": {
"id": "6ca71bfc24564c1cb9d01dda19435a58",
"autoIncrement": 1746.0
},
"fields": {
"displayGroup": [
"d10199a0f2d2ccbd2e152df35185d32c"
]
},
"sort": [
2015.0,
"6ca71bfc24564c1cb9d01dda19435a58"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "81aa2506b191431f9b40d24a27e47808",
"_score": null,
"_source": {
"id": "81aa2506b191431f9b40d24a27e47808",
"autoIncrement": 1747.0
},
"fields": {
"displayGroup": [
"b838ab31fcb57f61cb26b4b0974bc55e"
]
},
"sort": [
2014.0,
"81aa2506b191431f9b40d24a27e47808"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "6992e9949ab948e7a461f4c4afa7b4eb",
"_score": null,
"_source": {
"id": "6992e9949ab948e7a461f4c4afa7b4eb",
"autoIncrement": 1748.0
},
"fields": {
"displayGroup": [
"19b26b35686c96027c6a4c35b39d5e0a"
]
},
"sort": [
2013.0,
"6992e9949ab948e7a461f4c4afa7b4eb"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "e83fe27889274805b368c54a5658da52",
"_score": null,
"_source": {
"id": "e83fe27889274805b368c54a5658da52",
"autoIncrement": 1749.0
},
"fields": {
"displayGroup": [
"d8eb1d34cce943a8b6af318d5291f905"
]
},
"sort": [
2011.0,
"e83fe27889274805b368c54a5658da52"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "d52c530f0c10497eb164492b31e9d2fc",
"_score": null,
"_source": {
"id": "d52c530f0c10497eb164492b31e9d2fc",
"autoIncrement": 1750.0
},
"fields": {
"displayGroup": [
"3b3b2831fae9d028302aff3f96f88f4a"
]
},
"sort": [
2010.0,
"d52c530f0c10497eb164492b31e9d2fc"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "237237db92d84844b8eeabb38be0dacb",
"_score": null,
"_source": {
"id": "237237db92d84844b8eeabb38be0dacb",
"autoIncrement": 1751.0
},
"fields": {
"displayGroup": [
"4656a30f87a9bf8e32f1f2f1217ead80"
]
},
"sort": [
2009.0,
"237237db92d84844b8eeabb38be0dacb"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "97e3ff0ccb8f474faaec412a112b31ab",
"_score": null,
"_source": {
"id": "97e3ff0ccb8f474faaec412a112b31ab",
"autoIncrement": 1752.0
},
"fields": {
"displayGroup": [
"0e8aa543e6eb04afa85ef297edc571c7"
]
},
"sort": [
2008.0,
"97e3ff0ccb8f474faaec412a112b31ab"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "f94233ddbabf4743812fd0daabf8e50d",
"_score": null,
"_source": {
"id": "f94233ddbabf4743812fd0daabf8e50d",
"autoIncrement": 1753.0
},
"fields": {
"displayGroup": [
"3fd57d2cbdcdcd605fa163d01e104f91"
]
},
"sort": [
2007.0,
"f94233ddbabf4743812fd0daabf8e50d"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "c08431f4d53a44469f9c51329bb0a9cd",
"_score": null,
"_source": {
"id": "c08431f4d53a44469f9c51329bb0a9cd",
"autoIncrement": 1754.0
},
"fields": {
"displayGroup": [
"d606a7987f49c18b1c29e0a4bd89aadf"
]
},
"sort": [
2006.0,
"c08431f4d53a44469f9c51329bb0a9cd"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "dd6657ed9a7f4ffb85ac1d1587c7bf3f",
"_score": null,
"_source": {
"id": "dd6657ed9a7f4ffb85ac1d1587c7bf3f",
"autoIncrement": 1755.0
},
"fields": {
"displayGroup": [
"e8f00ddedf3c007d4dd3ba790a6edcc4"
]
},
"sort": [
2005.0,
"dd6657ed9a7f4ffb85ac1d1587c7bf3f"
]
}
]
},
"aggregations": {
"total-count": {
"value": 19
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
2.31 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":"3e77a084c1ae4f5a87ed8a905ebac167"}}}},{"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": 19,
"rating": {
"value": 0.0
}
},
"properties": {
"doc_count": 289,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "004c9f1122be4d3db1dadecc53a44cdf",
"doc_count": 19
},
{
"key": "02416711dcc64bba92f95ffae7c16671",
"doc_count": 19
},
{
"key": "276cdd68b28844569066cf000ab6cb31",
"doc_count": 19
},
{
"key": "406fb2b05eb0411b8900ea774373ab66",
"doc_count": 19
},
{
"key": "45018ee86cc84c47b8d18583215e11fb",
"doc_count": 19
},
{
"key": "6d6ea6f00d3b4309b31b2222306bb6f6",
"doc_count": 19
},
{
"key": "7ff9bf65442640a197c3decf055427c4",
"doc_count": 19
},
{
"key": "810d89d977184acca8fa2b1d8cbec2ef",
"doc_count": 19
},
{
"key": "8607b9a5f4b94ea7ad3cd00822deb432",
"doc_count": 19
},
{
"key": "c057aaf844b84af9a250efc7be0def2c",
"doc_count": 19
},
{
"key": "d0c07ddcae6a4425b96e363887660b9f",
"doc_count": 19
},
{
"key": "de11157443fb4362b15963d373823bcd",
"doc_count": 19
},
{
"key": "b81318b1758e42bc8be1559a7f6df0bc",
"doc_count": 17
},
{
"key": "75dd5eab70da446f80d8bf94622759e3",
"doc_count": 4
},
{
"key": "56a1d6dfb7544a49b5ea6fea8e824484",
"doc_count": 3
},
{
"key": "b17e0030883f443eb86e83ea0e398602",
"doc_count": 3
},
{
"key": "c7cc8a656cf841ca898ab1f1ad507138",
"doc_count": 3
},
{
"key": "719d6b854ce24a19b8d6e400d71142b6",
"doc_count": 2
},
{
"key": "ea14bf5deae249608bba53c077e3b678",
"doc_count": 2
},
{
"key": "06e4d27eb94d4cc1aca5541219423d71",
"doc_count": 1
},
{
"key": "0ad2db72f8c446a29c956ed6e9f78fb4",
"doc_count": 1
},
{
"key": "19ff354e70aa45dba8fe4f7c2f81db8a",
"doc_count": 1
},
{
"key": "1ddc1e26f22149cfb512c7f91acbfe95",
"doc_count": 1
},
{
"key": "2cfa71698f8846af805a68264beefa3c",
"doc_count": 1
},
{
"key": "3a9565204c7e4ba39750cae7d8d19534",
"doc_count": 1
},
{
"key": "4f146b4ced904c95b0ff8ceaf78bfe3a",
"doc_count": 1
},
{
"key": "51bed0da96f94ea094216e94132b3f37",
"doc_count": 1
},
{
"key": "53a9a7a312b94cc69f7d8aba992d287c",
"doc_count": 1
},
{
"key": "5ab38019ed7843e7b3b2218c5a19e933",
"doc_count": 1
},
{
"key": "5b2854b6c9da458e8bf92359a79545e8",
"doc_count": 1
},
{
"key": "70ff235152d34208b65f1251a1cc7b4f",
"doc_count": 1
},
{
"key": "75b62c029db84b41adce986abb8291ec",
"doc_count": 1
},
{
"key": "998c9b372d1a4245a79724d3c6f0289e",
"doc_count": 1
},
{
"key": "9a60f14fa86443ff98d00b82e1578dd0",
"doc_count": 1
},
{
"key": "a6450340188a4fa5b90c2c983bc9ad03",
"doc_count": 1
},
{
"key": "adfd37fa8d88405d8be97bde6b963aef",
"doc_count": 1
},
{
"key": "b0fd24cfb9784ab4a1236ab5ece09415",
"doc_count": 1
},
{
"key": "b577174053d2456d8307a6b59d762ca8",
"doc_count": 1
},
{
"key": "bf2d854da22c41e0a79a72de4697db5b",
"doc_count": 1
},
{
"key": "ca0798b913784ff9880ac954d5b61825",
"doc_count": 1
},
{
"key": "d87edd2454464161b85302e13bb3d42d",
"doc_count": 1
},
{
"key": "da73ead1b1964a929f9369fb17e21c3b",
"doc_count": 1
},
{
"key": "eacf349b35b7494c8bbf7cb92ee7e3d6",
"doc_count": 1
},
{
"key": "eff689d23e264c44b773885f2a4a39e9",
"doc_count": 1
},
{
"key": "faccf1a22928444b912cbaa5ec6ad319",
"doc_count": 1
},
{
"key": "fcebc86ac3954b8092f471d6315e7c61",
"doc_count": 1
}
]
}
},
"price": {
"count": 19,
"min": 0.0,
"max": 415.49,
"avg": 43.159473684210525,
"sum": 820.03
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "44664e58a30b46f2b6b0d6d55373d662",
"doc_count": 19
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|