| 1 |
6.27 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":"3294860c5073433db20440192b7ab86c"}}}},{"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": 15,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "rosland_product_1712914068",
"_id": "4abebb6f66ad43778de94fd099e28554",
"_score": null,
"_source": {
"id": "4abebb6f66ad43778de94fd099e28554",
"autoIncrement": 733.0
},
"fields": {
"displayGroup": [
"3eebd64a98cc0c007a804a29b9f27790"
]
},
"sort": [
2019.0,
"4abebb6f66ad43778de94fd099e28554"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "095a4d5ee33e4ebeba332b9436eec2b8",
"_score": null,
"_source": {
"id": "095a4d5ee33e4ebeba332b9436eec2b8",
"autoIncrement": 188.0
},
"fields": {
"displayGroup": [
"4e25b1d8caa7db04870161ea0df52ea8"
]
},
"sort": [
2017.0,
"095a4d5ee33e4ebeba332b9436eec2b8"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "1c11145b5cac423cb76ff55794260b05",
"_score": null,
"_source": {
"id": "1c11145b5cac423cb76ff55794260b05",
"autoIncrement": 189.0
},
"fields": {
"displayGroup": [
"ea4ca1ce5616c8ddfe9b9fc367993055"
]
},
"sort": [
2017.0,
"1c11145b5cac423cb76ff55794260b05"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "eac164b014224aecb0d74e63af6aeb69",
"_score": null,
"_source": {
"id": "eac164b014224aecb0d74e63af6aeb69",
"autoIncrement": 2556.0
},
"fields": {
"displayGroup": [
"96a04c03166fccc38a7ae6c498da3c47"
]
},
"sort": [
2017.0,
"eac164b014224aecb0d74e63af6aeb69"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "fa2ae9c3ac5941508b726d4d6f9a9596",
"_score": null,
"_source": {
"id": "fa2ae9c3ac5941508b726d4d6f9a9596",
"autoIncrement": 2870.0
},
"fields": {
"displayGroup": [
"01a0504434f8572b687e3c442043b88d"
]
},
"sort": [
2016.0,
"fa2ae9c3ac5941508b726d4d6f9a9596"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "2a5d13fe5bfb466a805f93fda5166437",
"_score": null,
"_source": {
"id": "2a5d13fe5bfb466a805f93fda5166437",
"autoIncrement": 2216.0
},
"fields": {
"displayGroup": [
"f0d3c1bd4c8ecf4ad443730162d7f531"
]
},
"sort": [
2014.0,
"2a5d13fe5bfb466a805f93fda5166437"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "b77127b2589448efbb3fccb012cd6934",
"_score": null,
"_source": {
"id": "b77127b2589448efbb3fccb012cd6934",
"autoIncrement": 2215.0
},
"fields": {
"displayGroup": [
"f506d93771905e00a309b6205272dfa0"
]
},
"sort": [
2012.0,
"b77127b2589448efbb3fccb012cd6934"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "28719aae949a48198cceddbe26408360",
"_score": null,
"_source": {
"id": "28719aae949a48198cceddbe26408360",
"autoIncrement": 703.0
},
"fields": {
"displayGroup": [
"63d22d401b7011fb433f4f2baf4611b1"
]
},
"sort": [
2011.0,
"28719aae949a48198cceddbe26408360"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "91595aff536c4940a3ad7271fc597fe2",
"_score": null,
"_source": {
"id": "91595aff536c4940a3ad7271fc597fe2",
"autoIncrement": 1421.0
},
"fields": {
"displayGroup": [
"1bb4daf90f129068a9971c7b029f84cd"
]
},
"sort": [
2011.0,
"91595aff536c4940a3ad7271fc597fe2"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "7b9847124d5e42e3820a036e70c34374",
"_score": null,
"_source": {
"id": "7b9847124d5e42e3820a036e70c34374",
"autoIncrement": 2214.0
},
"fields": {
"displayGroup": [
"d89e933c9e1cf007b9d928254b7cdf2b"
]
},
"sort": [
2009.0,
"7b9847124d5e42e3820a036e70c34374"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "df8b37636f0b41fcacf06bf6a642b011",
"_score": null,
"_source": {
"id": "df8b37636f0b41fcacf06bf6a642b011",
"autoIncrement": 1422.0
},
"fields": {
"displayGroup": [
"a30c40792b5eafc73bacec2bd9b8807b"
]
},
"sort": [
1997.0,
"df8b37636f0b41fcacf06bf6a642b011"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "c7d2917d8ff140828959d0584ac05ec7",
"_score": null,
"_source": {
"id": "c7d2917d8ff140828959d0584ac05ec7",
"autoIncrement": 2852.0
},
"fields": {
"displayGroup": [
"e7e74d60ec06a217bceb88754366f45f"
]
},
"sort": [
1993.0,
"c7d2917d8ff140828959d0584ac05ec7"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "45fff9dfb8e3466ab4c3677b4e03f19b",
"_score": null,
"_source": {
"id": "45fff9dfb8e3466ab4c3677b4e03f19b",
"autoIncrement": 1423.0
},
"fields": {
"displayGroup": [
"b20f68af058c67d8664b51e0038395f4"
]
},
"sort": [
1992.0,
"45fff9dfb8e3466ab4c3677b4e03f19b"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "242d719b3aa0455f8126a085c0e8ee61",
"_score": null,
"_source": {
"id": "242d719b3aa0455f8126a085c0e8ee61",
"autoIncrement": 1426.0
},
"fields": {
"displayGroup": [
"0daa56c05fb1a2374eedc8076de903a5"
]
},
"sort": [
1987.0,
"242d719b3aa0455f8126a085c0e8ee61"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "176ff6ae6361478ca58c2dca4b68f3d6",
"_score": null,
"_source": {
"id": "176ff6ae6361478ca58c2dca4b68f3d6",
"autoIncrement": 1427.0
},
"fields": {
"displayGroup": [
"692f2dd36214b4907a8167466854aa0e"
]
},
"sort": [
1986.0,
"176ff6ae6361478ca58c2dca4b68f3d6"
]
}
]
},
"aggregations": {
"total-count": {
"value": 15
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
2.20 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":"3294860c5073433db20440192b7ab86c"}}}},{"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": 15,
"rating": {
"value": 0.0
}
},
"properties": {
"doc_count": 294,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "158d4f380ddb43d482095779cfffafa8",
"doc_count": 15
},
{
"key": "45018ee86cc84c47b8d18583215e11fb",
"doc_count": 15
},
{
"key": "8ea6d7bbbcd24ac7857d738dbba7d056",
"doc_count": 15
},
{
"key": "98301be66a2c41a4914eda011b8b4795",
"doc_count": 14
},
{
"key": "f38c00d66e7340cf9c07fd64a8c1204b",
"doc_count": 13
},
{
"key": "02416711dcc64bba92f95ffae7c16671",
"doc_count": 9
},
{
"key": "5a62d81b4f86473eb7f81295523b0456",
"doc_count": 9
},
{
"key": "c00d09ec51844aefa2781fcc00839644",
"doc_count": 9
},
{
"key": "f3addfa0aa8f492b93ef4d41f76ff1fd",
"doc_count": 9
},
{
"key": "50dc81227301435cb4615de71f316323",
"doc_count": 7
},
{
"key": "6d5bc77d42c84ed482f0e82e8be1f36e",
"doc_count": 7
},
{
"key": "8b0f7248c5754108b4aa3d1bfc8237b9",
"doc_count": 7
},
{
"key": "da73ead1b1964a929f9369fb17e21c3b",
"doc_count": 7
},
{
"key": "eacf349b35b7494c8bbf7cb92ee7e3d6",
"doc_count": 7
},
{
"key": "b1db92116aaf46d5a308b7ad5f134d9d",
"doc_count": 6
},
{
"key": "256aa072d598469cbe2a99d63859b36e",
"doc_count": 5
},
{
"key": "276cdd68b28844569066cf000ab6cb31",
"doc_count": 5
},
{
"key": "2808c5cefa584fbaaa1fd6afb0f5007a",
"doc_count": 5
},
{
"key": "50bede51bbaa4f4aba7003a45cf998b3",
"doc_count": 5
},
{
"key": "51ebe59299ac4057b371590d933448f3",
"doc_count": 5
},
{
"key": "b57d1d0eb833459bbda07a3adca6714c",
"doc_count": 5
},
{
"key": "e577924c14df48179d45585b28aacca1",
"doc_count": 5
},
{
"key": "1e4a0ad681614bcd9a8154efe918e338",
"doc_count": 4
},
{
"key": "27dbf2dab398426fb2f3099e28933f81",
"doc_count": 4
},
{
"key": "2cd2b8fd9e844c88ae0048d927ff86e3",
"doc_count": 4
},
{
"key": "63cb67b0c4d6483a9bc89b1cf914d58b",
"doc_count": 4
},
{
"key": "786d47a70a9f45bb9ca3e58a53b86105",
"doc_count": 4
},
{
"key": "7a4169f89b5c4ac48fdb2cf637c37033",
"doc_count": 4
},
{
"key": "8f67a6ba11f344f4ab0c1aca4c3f6511",
"doc_count": 4
},
{
"key": "950074db1e3749c6a39dbce3b25beda3",
"doc_count": 4
},
{
"key": "9f63919f237d4a99826fb4355de59356",
"doc_count": 4
},
{
"key": "a3729ff16d1b479d92efadb57932cf7c",
"doc_count": 4
},
{
"key": "b22e68532fa04b6e8e7dfa69f730b593",
"doc_count": 4
},
{
"key": "b88e3c07de5e447aa1508f3f7f0a59e6",
"doc_count": 4
},
{
"key": "fdf431f225e547eb9455c787f3b59e47",
"doc_count": 4
},
{
"key": "0ad2db72f8c446a29c956ed6e9f78fb4",
"doc_count": 3
},
{
"key": "27e5bf7420c14d1e82c251f92742efbd",
"doc_count": 3
},
{
"key": "2cbd54e475564611a23ed8d306d7e513",
"doc_count": 3
},
{
"key": "63a46a74d7d346da8a120bbb23181efd",
"doc_count": 3
},
{
"key": "004c9f1122be4d3db1dadecc53a44cdf",
"doc_count": 2
},
{
"key": "0c189ea565ab4573a222115adc6b9258",
"doc_count": 2
},
{
"key": "35c7230af8754beda6518418607405ba",
"doc_count": 2
},
{
"key": "9212eb311fec479bb45a3b6585184513",
"doc_count": 2
},
{
"key": "d0c07ddcae6a4425b96e363887660b9f",
"doc_count": 2
},
{
"key": "eff689d23e264c44b773885f2a4a39e9",
"doc_count": 2
},
{
"key": "fb930346aacc4fd4a2246f9c16755d20",
"doc_count": 2
},
{
"key": "02c57614dc824e57a18a134874babd08",
"doc_count": 1
},
{
"key": "051d25daf1ca46b0b5b363c0b850ff90",
"doc_count": 1
},
{
"key": "0ff7c201ea09456bbe0ff9494f90d817",
"doc_count": 1
},
{
"key": "14fd0605339a47ad8436471564c5813d",
"doc_count": 1
},
{
"key": "19ff354e70aa45dba8fe4f7c2f81db8a",
"doc_count": 1
},
{
"key": "1a840ef1b4dc4c49899b89d9d9a78e0d",
"doc_count": 1
},
{
"key": "27afa12e8fd1402e8ce3638e19a98d9a",
"doc_count": 1
},
{
"key": "2cfa71698f8846af805a68264beefa3c",
"doc_count": 1
},
{
"key": "31436e1f2add44468bf2734baf79dbb0",
"doc_count": 1
},
{
"key": "3a15a1e4e8cb4b08983a8e81003281fe",
"doc_count": 1
},
{
"key": "3c115623f5dd4cd582b1d72fad3a46b1",
"doc_count": 1
},
{
"key": "412fad5d763d48ee911d9bfb941f6035",
"doc_count": 1
},
{
"key": "4419b53ad0874ee1be3ae6f66ad98857",
"doc_count": 1
},
{
"key": "638ea939d2014992b9efab78cfa33df1",
"doc_count": 1
},
{
"key": "6a88c6ab01f84a669b021e9ca398ffe0",
"doc_count": 1
},
{
"key": "6b152dafe3014d5a9606d80e83dd75bd",
"doc_count": 1
},
{
"key": "70d623b6cfc0418c841d5717feb365d3",
"doc_count": 1
},
{
"key": "7cd3936adeeb4b92a96fd5fa84851189",
"doc_count": 1
},
{
"key": "8dbce7093ba44548b1048d01a65575af",
"doc_count": 1
},
{
"key": "8f43a9ecba1f4737931ca3dfe93fd817",
"doc_count": 1
},
{
"key": "9bb7ca6b9cb24df9865a0a24ac04c7d9",
"doc_count": 1
},
{
"key": "9f63f7a9675e490aa0c2ce7eb91381df",
"doc_count": 1
},
{
"key": "a22ffb31eeef4dec9f2742125159dc7d",
"doc_count": 1
},
{
"key": "adac28fc0ee643c1b43adea098dca42c",
"doc_count": 1
},
{
"key": "adfd37fa8d88405d8be97bde6b963aef",
"doc_count": 1
},
{
"key": "b17e0030883f443eb86e83ea0e398602",
"doc_count": 1
},
{
"key": "b449e94d970e42228521a3959685d688",
"doc_count": 1
},
{
"key": "cca45554e2274564aa8fdc6adc80a860",
"doc_count": 1
},
{
"key": "d87edd2454464161b85302e13bb3d42d",
"doc_count": 1
},
{
"key": "de8364dba6b6451d8e2a972bcefd2812",
"doc_count": 1
},
{
"key": "e8178221a73c4f7896964b360227d64c",
"doc_count": 1
},
{
"key": "ff0342690efc467cbfa11fc7bee27cdd",
"doc_count": 1
}
]
}
},
"price": {
"count": 15,
"min": 0.0,
"max": 5516.74,
"avg": 615.3226666666667,
"sum": 9229.84
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "e4c4bbe038b843de97e4cc3d27d3ee57",
"doc_count": 15
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|