| 1 |
5.51 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":"c8253ae2960445238391c7970a53c65e"}}}},{"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":36,"size":36,"collapse":{"field":"displayGroup"},"timeout":"5s"}}
{
"took": 1,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 48,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "rosland_product_1712914068",
"_id": "183cd6a6f13e48f79ec07d2aa554e9e0",
"_score": null,
"_source": {
"id": "183cd6a6f13e48f79ec07d2aa554e9e0",
"autoIncrement": 2071.0
},
"fields": {
"displayGroup": [
"7e51adf7ed61c0313c54fa8ca5764011"
]
},
"sort": [
1997.0,
"183cd6a6f13e48f79ec07d2aa554e9e0"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "05151fb30ae4442f8045fcc3c3e09956",
"_score": null,
"_source": {
"id": "05151fb30ae4442f8045fcc3c3e09956",
"autoIncrement": 3178.0
},
"fields": {
"displayGroup": [
"e2aebfbe6b532be0780b273b08afa5ef"
]
},
"sort": [
1996.0,
"05151fb30ae4442f8045fcc3c3e09956"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "295095185b9c4e1fafb12196468fab7b",
"_score": null,
"_source": {
"id": "295095185b9c4e1fafb12196468fab7b",
"autoIncrement": 3179.0
},
"fields": {
"displayGroup": [
"23df49af83fd97caf91aabd7b0303245"
]
},
"sort": [
1995.0,
"295095185b9c4e1fafb12196468fab7b"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "cfc8b8eb25f842efaab21ba6e9f8a2ec",
"_score": null,
"_source": {
"id": "cfc8b8eb25f842efaab21ba6e9f8a2ec",
"autoIncrement": 3180.0
},
"fields": {
"displayGroup": [
"c783a05048631d1ae9dc8afe2b23d6a9"
]
},
"sort": [
1994.0,
"cfc8b8eb25f842efaab21ba6e9f8a2ec"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "95a8cf0a54fa424c8059b2e6be5bb227",
"_score": null,
"_source": {
"id": "95a8cf0a54fa424c8059b2e6be5bb227",
"autoIncrement": 3181.0
},
"fields": {
"displayGroup": [
"fa076fe459a4039fb9ba4bebfa62df92"
]
},
"sort": [
1993.0,
"95a8cf0a54fa424c8059b2e6be5bb227"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "12511c2db0544ae4bed4a48c585093a8",
"_score": null,
"_source": {
"id": "12511c2db0544ae4bed4a48c585093a8",
"autoIncrement": 3182.0
},
"fields": {
"displayGroup": [
"96c610569bf111ba8f23c95b18099f3f"
]
},
"sort": [
1992.0,
"12511c2db0544ae4bed4a48c585093a8"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "3b753820a6714b80be3427252b040439",
"_score": null,
"_source": {
"id": "3b753820a6714b80be3427252b040439",
"autoIncrement": 3183.0
},
"fields": {
"displayGroup": [
"dfc8531c1a3d3fbdb37171007205e251"
]
},
"sort": [
1991.0,
"3b753820a6714b80be3427252b040439"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "47360379dcde4530b9bdcf8b9223b7fa",
"_score": null,
"_source": {
"id": "47360379dcde4530b9bdcf8b9223b7fa",
"autoIncrement": 3184.0
},
"fields": {
"displayGroup": [
"e4cc75d7065da299f62a55ce987391d0"
]
},
"sort": [
1990.0,
"47360379dcde4530b9bdcf8b9223b7fa"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "58e245d083f8453289b25c877eba1641",
"_score": null,
"_source": {
"id": "58e245d083f8453289b25c877eba1641",
"autoIncrement": 3185.0
},
"fields": {
"displayGroup": [
"ce4da54a23c6c070ec573cbfb25007f6"
]
},
"sort": [
1989.0,
"58e245d083f8453289b25c877eba1641"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "6fbc9115288c4af88b8efe6446abc7e6",
"_score": null,
"_source": {
"id": "6fbc9115288c4af88b8efe6446abc7e6",
"autoIncrement": 3186.0
},
"fields": {
"displayGroup": [
"c71b510b3f71e0d6565c8589534dff51"
]
},
"sort": [
1988.0,
"6fbc9115288c4af88b8efe6446abc7e6"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "33026468c81c4f41880e0d5da65084e4",
"_score": null,
"_source": {
"id": "33026468c81c4f41880e0d5da65084e4",
"autoIncrement": 3187.0
},
"fields": {
"displayGroup": [
"cd256bf3a5ada57cc81c91ec2f9a8959"
]
},
"sort": [
1987.0,
"33026468c81c4f41880e0d5da65084e4"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "36e65ed16d98412e98644eac5e974442",
"_score": null,
"_source": {
"id": "36e65ed16d98412e98644eac5e974442",
"autoIncrement": 3188.0
},
"fields": {
"displayGroup": [
"3fdb3f225fb0a0e2d3ebe62a3f4cf3f4"
]
},
"sort": [
1986.0,
"36e65ed16d98412e98644eac5e974442"
]
}
]
},
"aggregations": {
"total-count": {
"value": 48
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
1.90 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":"c8253ae2960445238391c7970a53c65e"}}}},{"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": 48,
"rating": {
"value": 0.0
}
},
"properties": {
"doc_count": 797,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "0c189ea565ab4573a222115adc6b9258",
"doc_count": 48
},
{
"key": "256aa072d598469cbe2a99d63859b36e",
"doc_count": 48
},
{
"key": "27c31ee026e74b64b3b8fc5ede21fd61",
"doc_count": 48
},
{
"key": "3a7e5383173049a9870e0213864728e3",
"doc_count": 48
},
{
"key": "45018ee86cc84c47b8d18583215e11fb",
"doc_count": 48
},
{
"key": "528b3840acb344d58eaad59f9085ed0a",
"doc_count": 48
},
{
"key": "674eeda781014bc7b35fe9b6e2849616",
"doc_count": 48
},
{
"key": "69c4d4228f384f6781872c615bff9d88",
"doc_count": 48
},
{
"key": "c00d09ec51844aefa2781fcc00839644",
"doc_count": 48
},
{
"key": "de13eba6d2fc4edc96f91a594e3bb0ba",
"doc_count": 48
},
{
"key": "f3addfa0aa8f492b93ef4d41f76ff1fd",
"doc_count": 48
},
{
"key": "f7fcd5b43919408abc47ad22817057e8",
"doc_count": 48
},
{
"key": "6f92af8d0f0a4ae99239c1bd9f68d3d3",
"doc_count": 39
},
{
"key": "b81318b1758e42bc8be1559a7f6df0bc",
"doc_count": 39
},
{
"key": "cdd1e121488840ffaff218a71c4a8a7c",
"doc_count": 39
},
{
"key": "48fe0a1a8740427e905c7b2f1e0dd86b",
"doc_count": 12
},
{
"key": "5ab38019ed7843e7b3b2218c5a19e933",
"doc_count": 10
},
{
"key": "d3359e7ac09a42d3b7d5cf34c349a688",
"doc_count": 8
},
{
"key": "3f0cca1db1e6486b92d3e46e21df8a38",
"doc_count": 4
},
{
"key": "c7cc8a656cf841ca898ab1f1ad507138",
"doc_count": 2
},
{
"key": "00e126a8ef834c00bf990797051f058e",
"doc_count": 1
},
{
"key": "018af03e1d7c7c8dabe65059358dbeba",
"doc_count": 1
},
{
"key": "05560388f552483ba9ac164020140494",
"doc_count": 1
},
{
"key": "06e4d27eb94d4cc1aca5541219423d71",
"doc_count": 1
},
{
"key": "0ad2db72f8c446a29c956ed6e9f78fb4",
"doc_count": 1
},
{
"key": "0d8f4b29d24947eb93f21b8c79ffb715",
"doc_count": 1
},
{
"key": "0e52c677f6eb4b4ebcb7bf705fd38edd",
"doc_count": 1
},
{
"key": "100d8976f63f4c52ac427209160d9a82",
"doc_count": 1
},
{
"key": "11207f5c167248769cd1e3f99bf79e2b",
"doc_count": 1
},
{
"key": "14fd0605339a47ad8436471564c5813d",
"doc_count": 1
},
{
"key": "19ff354e70aa45dba8fe4f7c2f81db8a",
"doc_count": 1
},
{
"key": "1b31f1343bb5438d8f088251d076bcf0",
"doc_count": 1
},
{
"key": "1baebe6a6ef6423f95778600eb89c7f8",
"doc_count": 1
},
{
"key": "1ea3320fa60946d9bfa07179565c4e31",
"doc_count": 1
},
{
"key": "1ee2995db21b40d7a29163b39f94889e",
"doc_count": 1
},
{
"key": "27afa12e8fd1402e8ce3638e19a98d9a",
"doc_count": 1
},
{
"key": "2cfa71698f8846af805a68264beefa3c",
"doc_count": 1
},
{
"key": "31436e1f2add44468bf2734baf79dbb0",
"doc_count": 1
},
{
"key": "3c038b44e46442589661994ae6e4eb42",
"doc_count": 1
},
{
"key": "3f6b07a3d4d645309a894e6dc08fbbf3",
"doc_count": 1
},
{
"key": "4f146b4ced904c95b0ff8ceaf78bfe3a",
"doc_count": 1
},
{
"key": "54ce87786b834c69b24ae0297c9f0351",
"doc_count": 1
},
{
"key": "561ed30e5e85483fb8fafe272a8c98a0",
"doc_count": 1
},
{
"key": "56b98afd1c5e4cdb8536f1bd5b978b1f",
"doc_count": 1
},
{
"key": "58b3269953d24c14b0203df29fb01ac3",
"doc_count": 1
},
{
"key": "5b2854b6c9da458e8bf92359a79545e8",
"doc_count": 1
},
{
"key": "60f3a33fb6e74ec0b6c83ace74194df5",
"doc_count": 1
},
{
"key": "661d9e25ce1249a3883385f2d99a342d",
"doc_count": 1
},
{
"key": "766b701b94344e10815de145c821498d",
"doc_count": 1
},
{
"key": "7c4a8379c9504273995c7348f7ada35d",
"doc_count": 1
},
{
"key": "7c5d3832339e4bebb6a14d21cf1e9506",
"doc_count": 1
},
{
"key": "8625a4d74b9240799a9427ee13b500df",
"doc_count": 1
},
{
"key": "884bc9f9d3d84b2a81b9327e2dc5039e",
"doc_count": 1
},
{
"key": "8dedb3f255ff420ba88ac7fb25b2d50c",
"doc_count": 1
},
{
"key": "9270bfdb608f44aba87a8540c8d22a10",
"doc_count": 1
},
{
"key": "93dcea5ec8474de58987a8a26d862a8d",
"doc_count": 1
},
{
"key": "9861fdd7cd7f48188c9ab82dd0c9556a",
"doc_count": 1
},
{
"key": "998c9b372d1a4245a79724d3c6f0289e",
"doc_count": 1
},
{
"key": "9a60f14fa86443ff98d00b82e1578dd0",
"doc_count": 1
},
{
"key": "9c73f08d4e644ecea5d88645f23ad2ad",
"doc_count": 1
},
{
"key": "a22ffb31eeef4dec9f2742125159dc7d",
"doc_count": 1
},
{
"key": "a7f8cbeca8ba402c824f4317d2d57d04",
"doc_count": 1
},
{
"key": "a808cb86986745c2b35b0832f7e19697",
"doc_count": 1
},
{
"key": "adac28fc0ee643c1b43adea098dca42c",
"doc_count": 1
},
{
"key": "adfd37fa8d88405d8be97bde6b963aef",
"doc_count": 1
},
{
"key": "ae21e9df3c704e44964baa3298dfb679",
"doc_count": 1
},
{
"key": "b0fd24cfb9784ab4a1236ab5ece09415",
"doc_count": 1
},
{
"key": "b3146cf9ec9944cf92b7e3cf0475a84f",
"doc_count": 1
},
{
"key": "bb8a42dae79046a3aeef68dfc7c43a52",
"doc_count": 1
},
{
"key": "bd58ab760b9d481099fece5b3049bf0a",
"doc_count": 1
},
{
"key": "bf2d854da22c41e0a79a72de4697db5b",
"doc_count": 1
},
{
"key": "ca0798b913784ff9880ac954d5b61825",
"doc_count": 1
},
{
"key": "cc61a08034264c0db3ba4fd0c3cac5e0",
"doc_count": 1
},
{
"key": "cca45554e2274564aa8fdc6adc80a860",
"doc_count": 1
},
{
"key": "cd2d9377dd074c76b5a354954cdd92fe",
"doc_count": 1
},
{
"key": "ce44d69a3e4e46ce9aa84b8515364889",
"doc_count": 1
},
{
"key": "cf387c70e3fa4517b5dc2e6ed19660c6",
"doc_count": 1
},
{
"key": "cf5248cd1fcb4fe08adde1b2aef52d5a",
"doc_count": 1
},
{
"key": "d203639f7b4541deab3c1d6440258dd4",
"doc_count": 1
},
{
"key": "d4d263228ed542d2ba77981a7dea3e11",
"doc_count": 1
},
{
"key": "d74fe7288d00413db651a504dd01c975",
"doc_count": 1
},
{
"key": "d87edd2454464161b85302e13bb3d42d",
"doc_count": 1
},
{
"key": "e8800fea53ee4087a0afd683a283ac96",
"doc_count": 1
},
{
"key": "e9d310af292e4092bdf618cedb0960e1",
"doc_count": 1
},
{
"key": "eff689d23e264c44b773885f2a4a39e9",
"doc_count": 1
},
{
"key": "f12cfaf8778344c1ab07e806815b8b67",
"doc_count": 1
},
{
"key": "f9bc11fb12b64a7d806ab6df2cfe82dd",
"doc_count": 1
},
{
"key": "fcebc86ac3954b8092f471d6315e7c61",
"doc_count": 1
}
]
}
},
"price": {
"count": 48,
"min": 0.0,
"max": 143.98,
"avg": 58.009166666666665,
"sum": 2784.44
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "0345f5142cf242648058475ab4182b6d",
"doc_count": 48
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|