| 1 |
19.38 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":"92b822d2e61a4933b0e11a5ee86ccf31"}}}},{"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": 24,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "rosland_product_1712914068",
"_id": "24ee39dd20c5431eabeecca213d98776",
"_score": null,
"_source": {
"id": "24ee39dd20c5431eabeecca213d98776",
"autoIncrement": 3975.0
},
"fields": {
"displayGroup": [
"c0eba06b4cfe9c87c8f59c329fc26765"
]
},
"sort": [
2021.0,
"24ee39dd20c5431eabeecca213d98776"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "d10f600868594d65bdb748816cd5a8ec",
"_score": null,
"_source": {
"id": "d10f600868594d65bdb748816cd5a8ec",
"autoIncrement": 3664.0
},
"fields": {
"displayGroup": [
"df5eef3edc817e8991fb9d2fb4d339e4"
]
},
"sort": [
2020.0,
"d10f600868594d65bdb748816cd5a8ec"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "ccc90e3b99ad40c59758b35a0abf1e5c",
"_score": null,
"_source": {
"id": "ccc90e3b99ad40c59758b35a0abf1e5c",
"autoIncrement": 2937.0
},
"fields": {
"displayGroup": [
"6760ccaec217ff6cab5a0878e5a97bf8"
]
},
"sort": [
2019.0,
"ccc90e3b99ad40c59758b35a0abf1e5c"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "57f6c7e971b046a5909ae4b1ebd6cf2b",
"_score": null,
"_source": {
"id": "57f6c7e971b046a5909ae4b1ebd6cf2b",
"autoIncrement": 3966.0
},
"fields": {
"displayGroup": [
"88efc795a4da40fa8b1c931c6160569c"
]
},
"sort": [
2018.0,
"57f6c7e971b046a5909ae4b1ebd6cf2b"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "baa9ae0f442d4fc5a77f2e14d521f5b4",
"_score": null,
"_source": {
"id": "baa9ae0f442d4fc5a77f2e14d521f5b4",
"autoIncrement": 1153.0
},
"fields": {
"displayGroup": [
"b02b37e234b08f933f6568dcb8e38777"
]
},
"sort": [
2017.0,
"baa9ae0f442d4fc5a77f2e14d521f5b4"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "fe5b0f2ce9134beabddcf23ed998c205",
"_score": null,
"_source": {
"id": "fe5b0f2ce9134beabddcf23ed998c205",
"autoIncrement": 1154.0
},
"fields": {
"displayGroup": [
"8ece033f9331b014fe88549a2876054f"
]
},
"sort": [
2016.0,
"fe5b0f2ce9134beabddcf23ed998c205"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "1b8c78961b044487adc7a3bf9c2c0789",
"_score": null,
"_source": {
"id": "1b8c78961b044487adc7a3bf9c2c0789",
"autoIncrement": 1155.0
},
"fields": {
"displayGroup": [
"0156246b65a13b249e63040ce897e335"
]
},
"sort": [
2015.0,
"1b8c78961b044487adc7a3bf9c2c0789"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "cc21172d4ad54d5abc5d99f6379c5a9c",
"_score": null,
"_source": {
"id": "cc21172d4ad54d5abc5d99f6379c5a9c",
"autoIncrement": 1156.0
},
"fields": {
"displayGroup": [
"7cde7730557e2721793ab441cfc58abf"
]
},
"sort": [
2014.0,
"cc21172d4ad54d5abc5d99f6379c5a9c"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "9234f2da068c4a46a9724014bf9f9794",
"_score": null,
"_source": {
"id": "9234f2da068c4a46a9724014bf9f9794",
"autoIncrement": 1157.0
},
"fields": {
"displayGroup": [
"8ea252a951148bdae2f175be26917800"
]
},
"sort": [
2013.0,
"9234f2da068c4a46a9724014bf9f9794"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "5065d857f27b4ede97bff4a1741dbae4",
"_score": null,
"_source": {
"id": "5065d857f27b4ede97bff4a1741dbae4",
"autoIncrement": 1158.0
},
"fields": {
"displayGroup": [
"7e04d3274026445aee8103a3f1341021"
]
},
"sort": [
2012.0,
"5065d857f27b4ede97bff4a1741dbae4"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "8d936c14a6f14863a023f9d7a31b94de",
"_score": null,
"_source": {
"id": "8d936c14a6f14863a023f9d7a31b94de",
"autoIncrement": 1159.0
},
"fields": {
"displayGroup": [
"ff807289aa4e5fe68cfe086024e7f7b4"
]
},
"sort": [
2011.0,
"8d936c14a6f14863a023f9d7a31b94de"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "eb9f13430269406cbf1df2a2b12d9bc8",
"_score": null,
"_source": {
"id": "eb9f13430269406cbf1df2a2b12d9bc8",
"autoIncrement": 1160.0
},
"fields": {
"displayGroup": [
"2cbcbcb2669027e4065614b018ddbb0f"
]
},
"sort": [
2010.0,
"eb9f13430269406cbf1df2a2b12d9bc8"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "c1f047a1b4b644aaa1901b3734c8c79c",
"_score": null,
"_source": {
"id": "c1f047a1b4b644aaa1901b3734c8c79c",
"autoIncrement": 1161.0
},
"fields": {
"displayGroup": [
"4d66c4407e83057596882b48255af8cd"
]
},
"sort": [
2009.0,
"c1f047a1b4b644aaa1901b3734c8c79c"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "2a126d6c51d64b048bdc1ce0f40c9152",
"_score": null,
"_source": {
"id": "2a126d6c51d64b048bdc1ce0f40c9152",
"autoIncrement": 1162.0
},
"fields": {
"displayGroup": [
"3c6c83d29d9173af099cd8302fb6c0bb"
]
},
"sort": [
2008.0,
"2a126d6c51d64b048bdc1ce0f40c9152"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "9d305dc9b75f409286fc941db7443134",
"_score": null,
"_source": {
"id": "9d305dc9b75f409286fc941db7443134",
"autoIncrement": 1163.0
},
"fields": {
"displayGroup": [
"151f7eb606b75a60e404c8755794936f"
]
},
"sort": [
2007.0,
"9d305dc9b75f409286fc941db7443134"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "071c9efb743447dcb7c8b08dc8c8ad3b",
"_score": null,
"_source": {
"id": "071c9efb743447dcb7c8b08dc8c8ad3b",
"autoIncrement": 1164.0
},
"fields": {
"displayGroup": [
"1790d3b4e5b76f1ad082045ba40b63f0"
]
},
"sort": [
2006.0,
"071c9efb743447dcb7c8b08dc8c8ad3b"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "4d66ffe7256c49f1a9d730ceb0015a46",
"_score": null,
"_source": {
"id": "4d66ffe7256c49f1a9d730ceb0015a46",
"autoIncrement": 1165.0
},
"fields": {
"displayGroup": [
"2801769bc6ff1d6133c93248bbadc389"
]
},
"sort": [
2005.0,
"4d66ffe7256c49f1a9d730ceb0015a46"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "d24de3f32c4b4cdea748b4de619cd7e2",
"_score": null,
"_source": {
"id": "d24de3f32c4b4cdea748b4de619cd7e2",
"autoIncrement": 1166.0
},
"fields": {
"displayGroup": [
"6a0e9aed3239685ec71dcab5a84a11f1"
]
},
"sort": [
2004.0,
"d24de3f32c4b4cdea748b4de619cd7e2"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "6ea937cce4414687bb380e1e77f78643",
"_score": null,
"_source": {
"id": "6ea937cce4414687bb380e1e77f78643",
"autoIncrement": 1167.0
},
"fields": {
"displayGroup": [
"ee13e7e7b2073307a93731d7a124bde7"
]
},
"sort": [
2003.0,
"6ea937cce4414687bb380e1e77f78643"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "e62482fed2304103991fa8be5e24ea3f",
"_score": null,
"_source": {
"id": "e62482fed2304103991fa8be5e24ea3f",
"autoIncrement": 1168.0
},
"fields": {
"displayGroup": [
"0ca5665e9691af2c9b380855c2fbb08a"
]
},
"sort": [
2002.0,
"e62482fed2304103991fa8be5e24ea3f"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "ce077a4420e5425baf295f44c124daa3",
"_score": null,
"_source": {
"id": "ce077a4420e5425baf295f44c124daa3",
"autoIncrement": 1169.0
},
"fields": {
"displayGroup": [
"176faadfbe86ced9cebb0846a35946ec"
]
},
"sort": [
2001.0,
"ce077a4420e5425baf295f44c124daa3"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "19c0fb1ab3294e5a89d56156fe89778c",
"_score": null,
"_source": {
"id": "19c0fb1ab3294e5a89d56156fe89778c",
"autoIncrement": 1170.0
},
"fields": {
"displayGroup": [
"f226d22e205dd105fccf01ae34466742"
]
},
"sort": [
1999.0,
"19c0fb1ab3294e5a89d56156fe89778c"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "ee95965e518b4dd9acde4f23dbb50d8e",
"_score": null,
"_source": {
"id": "ee95965e518b4dd9acde4f23dbb50d8e",
"autoIncrement": 1171.0
},
"fields": {
"displayGroup": [
"cbf80db72e6a63aca7b03fe5e2d8a239"
]
},
"sort": [
1998.0,
"ee95965e518b4dd9acde4f23dbb50d8e"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "ef3c5e9e187e4c97b7e5f2e204baa1a2",
"_score": null,
"_source": {
"id": "ef3c5e9e187e4c97b7e5f2e204baa1a2",
"autoIncrement": 1172.0
},
"fields": {
"displayGroup": [
"5883fb8de7cb16c837d0d839d2abdfef"
]
},
"sort": [
1996.0,
"ef3c5e9e187e4c97b7e5f2e204baa1a2"
]
}
]
},
"aggregations": {
"total-count": {
"value": 24
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
3.18 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":"92b822d2e61a4933b0e11a5ee86ccf31"}}}},{"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": 24,
"rating": {
"value": 0.0
}
},
"properties": {
"doc_count": 379,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "242d9eeb033d472695da322d18b95f36",
"doc_count": 24
},
{
"key": "2641f8888eea4fb68d423e97f3399a88",
"doc_count": 24
},
{
"key": "43cb2ad8fbcc481cbd882cd375c90484",
"doc_count": 24
},
{
"key": "45018ee86cc84c47b8d18583215e11fb",
"doc_count": 24
},
{
"key": "5da84ba5d2244bf1be9feadcba813cfd",
"doc_count": 24
},
{
"key": "70d623b6cfc0418c841d5717feb365d3",
"doc_count": 24
},
{
"key": "7f5dbcb0fae449cd834b245233e7e726",
"doc_count": 24
},
{
"key": "8efb26d3557f463e96b5241d8ed80276",
"doc_count": 24
},
{
"key": "9f63919f237d4a99826fb4355de59356",
"doc_count": 24
},
{
"key": "b1db92116aaf46d5a308b7ad5f134d9d",
"doc_count": 24
},
{
"key": "c00d09ec51844aefa2781fcc00839644",
"doc_count": 24
},
{
"key": "df10d98b0f734d97b772665f9d8e5c4e",
"doc_count": 24
},
{
"key": "f2defb0db2d84b1ebfde406b7515654b",
"doc_count": 24
},
{
"key": "527719b1bd5741e689597f45756f9f3e",
"doc_count": 19
},
{
"key": "fb3cb615b2f94d15843386656370f903",
"doc_count": 19
},
{
"key": "69fccd9024cf4a619fe44f9d4f1cff9a",
"doc_count": 5
},
{
"key": "06e4d27eb94d4cc1aca5541219423d71",
"doc_count": 1
},
{
"key": "0ad2db72f8c446a29c956ed6e9f78fb4",
"doc_count": 1
},
{
"key": "19ff354e70aa45dba8fe4f7c2f81db8a",
"doc_count": 1
},
{
"key": "2cfa71698f8846af805a68264beefa3c",
"doc_count": 1
},
{
"key": "4f146b4ced904c95b0ff8ceaf78bfe3a",
"doc_count": 1
},
{
"key": "5ab38019ed7843e7b3b2218c5a19e933",
"doc_count": 1
},
{
"key": "5b2854b6c9da458e8bf92359a79545e8",
"doc_count": 1
},
{
"key": "60f3a33fb6e74ec0b6c83ace74194df5",
"doc_count": 1
},
{
"key": "8dedb3f255ff420ba88ac7fb25b2d50c",
"doc_count": 1
},
{
"key": "93dcea5ec8474de58987a8a26d862a8d",
"doc_count": 1
},
{
"key": "9861fdd7cd7f48188c9ab82dd0c9556a",
"doc_count": 1
},
{
"key": "998c9b372d1a4245a79724d3c6f0289e",
"doc_count": 1
},
{
"key": "9a60f14fa86443ff98d00b82e1578dd0",
"doc_count": 1
},
{
"key": "a22ffb31eeef4dec9f2742125159dc7d",
"doc_count": 1
},
{
"key": "adfd37fa8d88405d8be97bde6b963aef",
"doc_count": 1
},
{
"key": "b0fd24cfb9784ab4a1236ab5ece09415",
"doc_count": 1
},
{
"key": "bf2d854da22c41e0a79a72de4697db5b",
"doc_count": 1
},
{
"key": "ca0798b913784ff9880ac954d5b61825",
"doc_count": 1
},
{
"key": "ce44d69a3e4e46ce9aa84b8515364889",
"doc_count": 1
},
{
"key": "d203639f7b4541deab3c1d6440258dd4",
"doc_count": 1
},
{
"key": "d87edd2454464161b85302e13bb3d42d",
"doc_count": 1
},
{
"key": "e8800fea53ee4087a0afd683a283ac96",
"doc_count": 1
},
{
"key": "eff689d23e264c44b773885f2a4a39e9",
"doc_count": 1
},
{
"key": "fcebc86ac3954b8092f471d6315e7c61",
"doc_count": 1
}
]
}
},
"price": {
"count": 24,
"min": 0.0,
"max": 333.31,
"avg": 191.70291666666665,
"sum": 4600.87
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "2a164e08292b491997d23e90d110b622",
"doc_count": 24
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|