| 1 |
2.90 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":"9f243b7a91db4a1dab4b784f701a57e9"}}}},{"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": 22,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_product_1717666750",
"_id": "01947f8f3c09724f92e944beec280a9c",
"_score": null,
"_source": {
"id": "01947f8f3c09724f92e944beec280a9c",
"autoIncrement": 4967.0
},
"fields": {
"displayGroup": [
"2bcce7fc0d4e6c32a19635630cd7ba48"
]
},
"sort": [
2025.0,
"01947f8f3c09724f92e944beec280a9c"
]
},
{
"_index": "sw_product_1717666750",
"_id": "f91be89f0d6240979ccc28fce91a964b",
"_score": null,
"_source": {
"id": "f91be89f0d6240979ccc28fce91a964b",
"autoIncrement": 4045.0
},
"fields": {
"displayGroup": [
"d5839d190641fd4364065b2844c106f3"
]
},
"sort": [
2021.0,
"f91be89f0d6240979ccc28fce91a964b"
]
},
{
"_index": "sw_product_1717666750",
"_id": "fab64aa561f14b878d217e9bd88dc93f",
"_score": null,
"_source": {
"id": "fab64aa561f14b878d217e9bd88dc93f",
"autoIncrement": 4044.0
},
"fields": {
"displayGroup": [
"7dba1379fcf0695ef195f098dc0a5176"
]
},
"sort": [
2021.0,
"fab64aa561f14b878d217e9bd88dc93f"
]
},
{
"_index": "sw_product_1717666750",
"_id": "36a93340b85b4a97aa7a4ad04f782e4d",
"_score": null,
"_source": {
"id": "36a93340b85b4a97aa7a4ad04f782e4d",
"autoIncrement": 4046.0
},
"fields": {
"displayGroup": [
"636c6a1452d380bf99f0a7083631e664"
]
},
"sort": [
2020.0,
"36a93340b85b4a97aa7a4ad04f782e4d"
]
},
{
"_index": "sw_product_1717666750",
"_id": "7372ef8853334a59b20ddb3170ea2250",
"_score": null,
"_source": {
"id": "7372ef8853334a59b20ddb3170ea2250",
"autoIncrement": 2748.0
},
"fields": {
"displayGroup": [
"c658a4011f1cd5d44ea81f69eb3801fc"
]
},
"sort": [
2020.0,
"7372ef8853334a59b20ddb3170ea2250"
]
},
{
"_index": "sw_product_1717666750",
"_id": "3fcd7603839c4d24a6adfc7aebee2545",
"_score": null,
"_source": {
"id": "3fcd7603839c4d24a6adfc7aebee2545",
"autoIncrement": 2046.0
},
"fields": {
"displayGroup": [
"46fc79e90666e64c7e613822153124de"
]
},
"sort": [
2019.0,
"3fcd7603839c4d24a6adfc7aebee2545"
]
},
{
"_index": "sw_product_1717666750",
"_id": "ae62ee776ec942fc8f7726d348d91b90",
"_score": null,
"_source": {
"id": "ae62ee776ec942fc8f7726d348d91b90",
"autoIncrement": 2038.0
},
"fields": {
"displayGroup": [
"7e6e7b97cad483d75a9a4d997b974e9d"
]
},
"sort": [
2019.0,
"ae62ee776ec942fc8f7726d348d91b90"
]
},
{
"_index": "sw_product_1717666750",
"_id": "b8e46f2bfe874a0fa9fa81dc384fcf38",
"_score": null,
"_source": {
"id": "b8e46f2bfe874a0fa9fa81dc384fcf38",
"autoIncrement": 2039.0
},
"fields": {
"displayGroup": [
"2b98c4a12b8746b2983aab7af476a499"
]
},
"sort": [
2018.0,
"b8e46f2bfe874a0fa9fa81dc384fcf38"
]
},
{
"_index": "sw_product_1717666750",
"_id": "c4db61d4a24946fb83ebf6708767a1da",
"_score": null,
"_source": {
"id": "c4db61d4a24946fb83ebf6708767a1da",
"autoIncrement": 2047.0
},
"fields": {
"displayGroup": [
"73667cf09017083449d85caa5ee14060"
]
},
"sort": [
2018.0,
"c4db61d4a24946fb83ebf6708767a1da"
]
},
{
"_index": "sw_product_1717666750",
"_id": "0b925cb636ce4aac8747e3e7bb4a3352",
"_score": null,
"_source": {
"id": "0b925cb636ce4aac8747e3e7bb4a3352",
"autoIncrement": 2040.0
},
"fields": {
"displayGroup": [
"db0cfad53cef60d6ff5164e686a39bcc"
]
},
"sort": [
2017.0,
"0b925cb636ce4aac8747e3e7bb4a3352"
]
},
{
"_index": "sw_product_1717666750",
"_id": "112df7fed1754fee88200bdb54ddc28e",
"_score": null,
"_source": {
"id": "112df7fed1754fee88200bdb54ddc28e",
"autoIncrement": 2048.0
},
"fields": {
"displayGroup": [
"46c5e4becce63749cce6c66c62b32bdb"
]
},
"sort": [
2017.0,
"112df7fed1754fee88200bdb54ddc28e"
]
},
{
"_index": "sw_product_1717666750",
"_id": "007c90e3b5384ddaada2a676e25e7c1f",
"_score": null,
"_source": {
"id": "007c90e3b5384ddaada2a676e25e7c1f",
"autoIncrement": 3168.0
},
"fields": {
"displayGroup": [
"fd7123598649cf30379d4d4e766e1df4"
]
},
"sort": [
2016.0,
"007c90e3b5384ddaada2a676e25e7c1f"
]
},
{
"_index": "sw_product_1717666750",
"_id": "364963977d6a450786bf427be4610bfc",
"_score": null,
"_source": {
"id": "364963977d6a450786bf427be4610bfc",
"autoIncrement": 2049.0
},
"fields": {
"displayGroup": [
"3046ec39b199095b1313ad97485dcc75"
]
},
"sort": [
2016.0,
"364963977d6a450786bf427be4610bfc"
]
},
{
"_index": "sw_product_1717666750",
"_id": "800bd5a3b41d4e2e958d4487c668c171",
"_score": null,
"_source": {
"id": "800bd5a3b41d4e2e958d4487c668c171",
"autoIncrement": 2041.0
},
"fields": {
"displayGroup": [
"942fd45f1e60e43553061feda79f3de3"
]
},
"sort": [
2015.0,
"800bd5a3b41d4e2e958d4487c668c171"
]
},
{
"_index": "sw_product_1717666750",
"_id": "57ba7cebec674745b8056f332f17e1aa",
"_score": null,
"_source": {
"id": "57ba7cebec674745b8056f332f17e1aa",
"autoIncrement": 2042.0
},
"fields": {
"displayGroup": [
"8fbea4b56b97bc061b16869729ce0aba"
]
},
"sort": [
2014.0,
"57ba7cebec674745b8056f332f17e1aa"
]
},
{
"_index": "sw_product_1717666750",
"_id": "0b832d2a499942b781a03abc6cec8310",
"_score": null,
"_source": {
"id": "0b832d2a499942b781a03abc6cec8310",
"autoIncrement": 3169.0
},
"fields": {
"displayGroup": [
"1dbc59d0b74fc4c94e6b229a782b2b9b"
]
},
"sort": [
2013.0,
"0b832d2a499942b781a03abc6cec8310"
]
},
{
"_index": "sw_product_1717666750",
"_id": "f66ccdc37a994dd4afc2a3a72ac77498",
"_score": null,
"_source": {
"id": "f66ccdc37a994dd4afc2a3a72ac77498",
"autoIncrement": 2050.0
},
"fields": {
"displayGroup": [
"9c8ea28f66f2ac99fd10dac6e22e3165"
]
},
"sort": [
2013.0,
"f66ccdc37a994dd4afc2a3a72ac77498"
]
},
{
"_index": "sw_product_1717666750",
"_id": "c262878076b547069ba7030d706431c5",
"_score": null,
"_source": {
"id": "c262878076b547069ba7030d706431c5",
"autoIncrement": 2043.0
},
"fields": {
"displayGroup": [
"87a1fc0d8b42abdd3735880352c6322b"
]
},
"sort": [
2012.0,
"c262878076b547069ba7030d706431c5"
]
},
{
"_index": "sw_product_1717666750",
"_id": "7323ad281c3f4245a611e7dcd2dc3d15",
"_score": null,
"_source": {
"id": "7323ad281c3f4245a611e7dcd2dc3d15",
"autoIncrement": 2044.0
},
"fields": {
"displayGroup": [
"2e99a8c57a256fae4d9546cace3bed32"
]
},
"sort": [
2011.0,
"7323ad281c3f4245a611e7dcd2dc3d15"
]
},
{
"_index": "sw_product_1717666750",
"_id": "5a379d9ac23e42d4acdd3151283eeac4",
"_score": null,
"_source": {
"id": "5a379d9ac23e42d4acdd3151283eeac4",
"autoIncrement": 3170.0
},
"fields": {
"displayGroup": [
"f36d78e24b9261286bb4fffaaf6d9dc7"
]
},
"sort": [
2010.0,
"5a379d9ac23e42d4acdd3151283eeac4"
]
},
{
"_index": "sw_product_1717666750",
"_id": "0d64a0561d7048699de2eae689aebaf2",
"_score": null,
"_source": {
"id": "0d64a0561d7048699de2eae689aebaf2",
"autoIncrement": 2045.0
},
"fields": {
"displayGroup": [
"7780ccb85f33db04e015c09fa5b96e9c"
]
},
"sort": [
2009.0,
"0d64a0561d7048699de2eae689aebaf2"
]
},
{
"_index": "sw_product_1717666750",
"_id": "9306bdcce0be4058a77dac08d9e83ef5",
"_score": null,
"_source": {
"id": "9306bdcce0be4058a77dac08d9e83ef5",
"autoIncrement": 3548.0
},
"fields": {
"displayGroup": [
"8368eb69d31c28093a959e12605236b4"
]
},
"sort": [
2008.0,
"9306bdcce0be4058a77dac08d9e83ef5"
]
}
]
},
"aggregations": {
"total-count": {
"value": 22
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
1.28 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":"9f243b7a91db4a1dab4b784f701a57e9"}}}},{"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_rule0197e9e4d10e7293b705c1d0eee95b29_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule0197e9e4d446718a91aafc7b03ab341a_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": {
"shipping-free-filter": {
"doc_count": 0,
"shipping-free": {
"value": null
}
},
"rating-exists": {
"doc_count": 22,
"rating": {
"value": 0.0
}
},
"price": {
"count": 22,
"min": 7.49,
"max": 90.23,
"avg": 27.48136363636364,
"sum": 604.59
},
"options": {
"doc_count": 0,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": []
}
},
"properties": {
"doc_count": 315,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "0c189ea565ab4573a222115adc6b9258",
"doc_count": 22
},
{
"key": "256aa072d598469cbe2a99d63859b36e",
"doc_count": 22
},
{
"key": "37831770e66a45a580dbc44a0da57057",
"doc_count": 22
},
{
"key": "45018ee86cc84c47b8d18583215e11fb",
"doc_count": 22
},
{
"key": "80d1e88530c943118f589722c2b9afe9",
"doc_count": 22
},
{
"key": "975484cdbc7c495e9a09a3f4f25f6847",
"doc_count": 22
},
{
"key": "da388262b87f4c54894feeceb9dd421b",
"doc_count": 22
},
{
"key": "ed20a090ab4848b79f2791c922f525cd",
"doc_count": 22
},
{
"key": "f0591c1d4a4b4eef87136891b48ef32f",
"doc_count": 22
},
{
"key": "f3addfa0aa8f492b93ef4d41f76ff1fd",
"doc_count": 22
},
{
"key": "7f5dbcb0fae449cd834b245233e7e726",
"doc_count": 15
},
{
"key": "c00d09ec51844aefa2781fcc00839644",
"doc_count": 15
},
{
"key": "eab1bcb867d9474d97d362b23d3fb7f9",
"doc_count": 15
},
{
"key": "004c9f1122be4d3db1dadecc53a44cdf",
"doc_count": 7
},
{
"key": "9f63f7a9675e490aa0c2ce7eb91381df",
"doc_count": 7
},
{
"key": "b81318b1758e42bc8be1559a7f6df0bc",
"doc_count": 7
},
{
"key": "d0c07ddcae6a4425b96e363887660b9f",
"doc_count": 7
},
{
"key": "06e4d27eb94d4cc1aca5541219423d71",
"doc_count": 2
},
{
"key": "0ad2db72f8c446a29c956ed6e9f78fb4",
"doc_count": 2
},
{
"key": "5ab38019ed7843e7b3b2218c5a19e933",
"doc_count": 2
},
{
"key": "998c9b372d1a4245a79724d3c6f0289e",
"doc_count": 2
},
{
"key": "adfd37fa8d88405d8be97bde6b963aef",
"doc_count": 2
},
{
"key": "ca0798b913784ff9880ac954d5b61825",
"doc_count": 2
},
{
"key": "d87edd2454464161b85302e13bb3d42d",
"doc_count": 2
},
{
"key": "01928a7829d67d639ecf3241a302231e",
"doc_count": 1
},
{
"key": "19ff354e70aa45dba8fe4f7c2f81db8a",
"doc_count": 1
},
{
"key": "2cfa71698f8846af805a68264beefa3c",
"doc_count": 1
},
{
"key": "5b2854b6c9da458e8bf92359a79545e8",
"doc_count": 1
},
{
"key": "9a60f14fa86443ff98d00b82e1578dd0",
"doc_count": 1
},
{
"key": "a22ffb31eeef4dec9f2742125159dc7d",
"doc_count": 1
},
{
"key": "eff689d23e264c44b773885f2a4a39e9",
"doc_count": 1
},
{
"key": "fcebc86ac3954b8092f471d6315e7c61",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "6e5d654167d94b9886dc5109b8e6451b",
"doc_count": 22
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|