| 1 |
6.71 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":"5395918a94b14781a22ee26605cc76ae"}}}},{"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": "dd886d860fa445a6adc885123d8b35f9",
"_score": null,
"_source": {
"id": "dd886d860fa445a6adc885123d8b35f9",
"autoIncrement": 1063.0
},
"fields": {
"displayGroup": [
"d3945299773dae89f200262614521339"
]
},
"sort": [
1997.0,
"dd886d860fa445a6adc885123d8b35f9"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "b4cad2c5f94e4fc4bea77af5e97bfc69",
"_score": null,
"_source": {
"id": "b4cad2c5f94e4fc4bea77af5e97bfc69",
"autoIncrement": 1064.0
},
"fields": {
"displayGroup": [
"d5839fb0298bd023c3af95301a8cae59"
]
},
"sort": [
1996.0,
"b4cad2c5f94e4fc4bea77af5e97bfc69"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "7c218394591c43049b9b04715189cc22",
"_score": null,
"_source": {
"id": "7c218394591c43049b9b04715189cc22",
"autoIncrement": 1065.0
},
"fields": {
"displayGroup": [
"8db12b629c9a0c572acaaa5c117c8598"
]
},
"sort": [
1995.0,
"7c218394591c43049b9b04715189cc22"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "a197d27caf4c47f5bf12ca0f9cab4dda",
"_score": null,
"_source": {
"id": "a197d27caf4c47f5bf12ca0f9cab4dda",
"autoIncrement": 1066.0
},
"fields": {
"displayGroup": [
"424252481752af92c87611af3d51f260"
]
},
"sort": [
1994.0,
"a197d27caf4c47f5bf12ca0f9cab4dda"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "b85d620780434d41a205222e4d1ae5db",
"_score": null,
"_source": {
"id": "b85d620780434d41a205222e4d1ae5db",
"autoIncrement": 3060.0
},
"fields": {
"displayGroup": [
"05884828dee05bd1d3e8cdc2a58c42f5"
]
},
"sort": [
1993.0,
"b85d620780434d41a205222e4d1ae5db"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "d44513b72f6f46509318a675b50d9042",
"_score": null,
"_source": {
"id": "d44513b72f6f46509318a675b50d9042",
"autoIncrement": 1067.0
},
"fields": {
"displayGroup": [
"45dce178d82affed0f767f4d373c5a30"
]
},
"sort": [
1992.0,
"d44513b72f6f46509318a675b50d9042"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "2a4ebc7dcc1c42a699c94861ab502101",
"_score": null,
"_source": {
"id": "2a4ebc7dcc1c42a699c94861ab502101",
"autoIncrement": 1068.0
},
"fields": {
"displayGroup": [
"302b38249fc807472fa162f5a66e2ed1"
]
},
"sort": [
1991.0,
"2a4ebc7dcc1c42a699c94861ab502101"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "cc46e15dd20b4375a6ef05bc0abc9906",
"_score": null,
"_source": {
"id": "cc46e15dd20b4375a6ef05bc0abc9906",
"autoIncrement": 1069.0
},
"fields": {
"displayGroup": [
"dfbacf47b0e04e73883751a27c7f7294"
]
},
"sort": [
1990.0,
"cc46e15dd20b4375a6ef05bc0abc9906"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "2b4426eb9aad4e6984bf7e912020d0f4",
"_score": null,
"_source": {
"id": "2b4426eb9aad4e6984bf7e912020d0f4",
"autoIncrement": 1070.0
},
"fields": {
"displayGroup": [
"047c1434eda0dd0f4751681e74b04077"
]
},
"sort": [
1989.0,
"2b4426eb9aad4e6984bf7e912020d0f4"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "948524aa42a3462baf384e7424a00e35",
"_score": null,
"_source": {
"id": "948524aa42a3462baf384e7424a00e35",
"autoIncrement": 1071.0
},
"fields": {
"displayGroup": [
"e388d5c4cc9c996d0fdb3be558703f14"
]
},
"sort": [
1988.0,
"948524aa42a3462baf384e7424a00e35"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "2b7be0fcdc5643389d035b901a342259",
"_score": null,
"_source": {
"id": "2b7be0fcdc5643389d035b901a342259",
"autoIncrement": 1072.0
},
"fields": {
"displayGroup": [
"e95a11f17e77d44be459c0b00f31462f"
]
},
"sort": [
1987.0,
"2b7be0fcdc5643389d035b901a342259"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "03d87928c6f542ab828e779de76e6e60",
"_score": null,
"_source": {
"id": "03d87928c6f542ab828e779de76e6e60",
"autoIncrement": 3061.0
},
"fields": {
"displayGroup": [
"7ea7fd22e189c9a6369cff4a58336c5c"
]
},
"sort": [
1986.0,
"03d87928c6f542ab828e779de76e6e60"
]
}
]
},
"aggregations": {
"total-count": {
"value": 48
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
2.75 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":"5395918a94b14781a22ee26605cc76ae"}}}},{"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": 834,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "16c63023894f40c29a8d441f052b01fd",
"doc_count": 48
},
{
"key": "3a7e5383173049a9870e0213864728e3",
"doc_count": 48
},
{
"key": "45018ee86cc84c47b8d18583215e11fb",
"doc_count": 48
},
{
"key": "de13eba6d2fc4edc96f91a594e3bb0ba",
"doc_count": 48
},
{
"key": "276cdd68b28844569066cf000ab6cb31",
"doc_count": 47
},
{
"key": "b4027b3a06744f9b8000817889b34f70",
"doc_count": 47
},
{
"key": "c057aaf844b84af9a250efc7be0def2c",
"doc_count": 47
},
{
"key": "f1d5de05f6c345a68b742dd2528af946",
"doc_count": 47
},
{
"key": "34680579f19740cfac012f53c2d14579",
"doc_count": 45
},
{
"key": "75b3bac4e87041dfb2b7707e34c37775",
"doc_count": 45
},
{
"key": "80e3982c09e14668b61b2435788dd74e",
"doc_count": 45
},
{
"key": "c00d09ec51844aefa2781fcc00839644",
"doc_count": 45
},
{
"key": "4665fd14d872415baeb2e71e59780f94",
"doc_count": 44
},
{
"key": "b81318b1758e42bc8be1559a7f6df0bc",
"doc_count": 40
},
{
"key": "4261829747ec48b884a9e118599ebdbf",
"doc_count": 39
},
{
"key": "e0a7f42ebaf743c694883cd85d2ba906",
"doc_count": 39
},
{
"key": "50bede51bbaa4f4aba7003a45cf998b3",
"doc_count": 6
},
{
"key": "5ab38019ed7843e7b3b2218c5a19e933",
"doc_count": 4
},
{
"key": "004c9f1122be4d3db1dadecc53a44cdf",
"doc_count": 3
},
{
"key": "20307aa6ea24472fbcbae9213a330f80",
"doc_count": 3
},
{
"key": "2b1d38fab0634d6ba9bc37ae28f6adcf",
"doc_count": 3
},
{
"key": "8a6ac1662b934451b6e3bc6e665c3bea",
"doc_count": 3
},
{
"key": "99544516e0e04f7f9cd839b4d9bc2b91",
"doc_count": 3
},
{
"key": "c7cc8a656cf841ca898ab1f1ad507138",
"doc_count": 3
},
{
"key": "d0c07ddcae6a4425b96e363887660b9f",
"doc_count": 3
},
{
"key": "998c9b372d1a4245a79724d3c6f0289e",
"doc_count": 2
},
{
"key": "ca0798b913784ff9880ac954d5b61825",
"doc_count": 2
},
{
"key": "d3359e7ac09a42d3b7d5cf34c349a688",
"doc_count": 2
},
{
"key": "018af03e1d7c7c8dabe65059358dbeba",
"doc_count": 1
},
{
"key": "04404dd812da49eca47a9e2ba04bf3f9",
"doc_count": 1
},
{
"key": "06e4d27eb94d4cc1aca5541219423d71",
"doc_count": 1
},
{
"key": "09359c82dfe94da99d378b1ed89b83a0",
"doc_count": 1
},
{
"key": "0ad2db72f8c446a29c956ed6e9f78fb4",
"doc_count": 1
},
{
"key": "0e05ac3f05854a34beaa2572f759b414",
"doc_count": 1
},
{
"key": "14fd0605339a47ad8436471564c5813d",
"doc_count": 1
},
{
"key": "19ff354e70aa45dba8fe4f7c2f81db8a",
"doc_count": 1
},
{
"key": "1baebe6a6ef6423f95778600eb89c7f8",
"doc_count": 1
},
{
"key": "2334aa08473b48aa8726fb604f443515",
"doc_count": 1
},
{
"key": "2426ab4a3fa246309f117c267dda1068",
"doc_count": 1
},
{
"key": "27afa12e8fd1402e8ce3638e19a98d9a",
"doc_count": 1
},
{
"key": "2cfa71698f8846af805a68264beefa3c",
"doc_count": 1
},
{
"key": "31436e1f2add44468bf2734baf79dbb0",
"doc_count": 1
},
{
"key": "3a1b11945c4c47fdad4333944e884b6b",
"doc_count": 1
},
{
"key": "3c038b44e46442589661994ae6e4eb42",
"doc_count": 1
},
{
"key": "3c0aabc08db641c48171fb5bfaa1d462",
"doc_count": 1
},
{
"key": "4f146b4ced904c95b0ff8ceaf78bfe3a",
"doc_count": 1
},
{
"key": "51e406d8e6d749579649fe4d51ee1c54",
"doc_count": 1
},
{
"key": "537c35baf622434483a28ffa45b338f7",
"doc_count": 1
},
{
"key": "54ce87786b834c69b24ae0297c9f0351",
"doc_count": 1
},
{
"key": "5b2854b6c9da458e8bf92359a79545e8",
"doc_count": 1
},
{
"key": "5d2b43ace64d4264b270a31fdd0dfb03",
"doc_count": 1
},
{
"key": "60f3a33fb6e74ec0b6c83ace74194df5",
"doc_count": 1
},
{
"key": "63c7c0ee51bd4b8bae0750b3526c7c97",
"doc_count": 1
},
{
"key": "6510ee217d0b45669e11e70251317061",
"doc_count": 1
},
{
"key": "65f728ef98644adc99d2cd6096372808",
"doc_count": 1
},
{
"key": "67a9362566364ef3b47900fec846a095",
"doc_count": 1
},
{
"key": "689dad6891304a8fbea1f783eca4904a",
"doc_count": 1
},
{
"key": "7573e574686c4ec795fd776ef193fe69",
"doc_count": 1
},
{
"key": "7c815e57ecd94e67b586db0965857046",
"doc_count": 1
},
{
"key": "7d6b09bee0ef4c2bbbc31ece8a32a605",
"doc_count": 1
},
{
"key": "82ef30faf3994ebb8aa8e7396bc9c379",
"doc_count": 1
},
{
"key": "843f0d732e514cf7b704ae4ad4594c79",
"doc_count": 1
},
{
"key": "8c0ed145da6547fa904a128e210c9c34",
"doc_count": 1
},
{
"key": "8c20bf91075b479d8f778a5718feeb41",
"doc_count": 1
},
{
"key": "8c880ef6522c49ab8a6ffa074c214214",
"doc_count": 1
},
{
"key": "8dedb3f255ff420ba88ac7fb25b2d50c",
"doc_count": 1
},
{
"key": "8ec352868f014295ae31805c1807be40",
"doc_count": 1
},
{
"key": "8f5ab78328db42f290c5c4b028bd491b",
"doc_count": 1
},
{
"key": "9270bfdb608f44aba87a8540c8d22a10",
"doc_count": 1
},
{
"key": "92d245898010464a95cfc3e4673530c9",
"doc_count": 1
},
{
"key": "93dcea5ec8474de58987a8a26d862a8d",
"doc_count": 1
},
{
"key": "9861fdd7cd7f48188c9ab82dd0c9556a",
"doc_count": 1
},
{
"key": "9a60f14fa86443ff98d00b82e1578dd0",
"doc_count": 1
},
{
"key": "a22ffb31eeef4dec9f2742125159dc7d",
"doc_count": 1
},
{
"key": "a54a989d62e7495ebc3985be99df4de7",
"doc_count": 1
},
{
"key": "a9705b0538cb42a3be5018cf5701955d",
"doc_count": 1
},
{
"key": "a9d56d52acfb41d092aa7110050aaa33",
"doc_count": 1
},
{
"key": "aa35c83e833544e993ac9d4bf95bd7f6",
"doc_count": 1
},
{
"key": "acc15fd13ca94d30a191529d268a7256",
"doc_count": 1
},
{
"key": "adac28fc0ee643c1b43adea098dca42c",
"doc_count": 1
},
{
"key": "adfd37fa8d88405d8be97bde6b963aef",
"doc_count": 1
},
{
"key": "ae21e9df3c704e44964baa3298dfb679",
"doc_count": 1
},
{
"key": "b0fd24cfb9784ab4a1236ab5ece09415",
"doc_count": 1
},
{
"key": "b7e86b99a51b4e418d44e4f86e7f0ba0",
"doc_count": 1
},
{
"key": "b8c377b1cc35445fa63894319560dde7",
"doc_count": 1
},
{
"key": "bf2d854da22c41e0a79a72de4697db5b",
"doc_count": 1
},
{
"key": "c76c2b61f9f14f69ab038961666e3a3a",
"doc_count": 1
},
{
"key": "c9d8feb6b5404d34aab01190decc3c57",
"doc_count": 1
},
{
"key": "ca2d0e9faeb64f869346e61cc11d05bc",
"doc_count": 1
},
{
"key": "cc61a08034264c0db3ba4fd0c3cac5e0",
"doc_count": 1
},
{
"key": "cca45554e2274564aa8fdc6adc80a860",
"doc_count": 1
},
{
"key": "ce44d69a3e4e46ce9aa84b8515364889",
"doc_count": 1
},
{
"key": "cf387c70e3fa4517b5dc2e6ed19660c6",
"doc_count": 1
},
{
"key": "d203639f7b4541deab3c1d6440258dd4",
"doc_count": 1
},
{
"key": "d87edd2454464161b85302e13bb3d42d",
"doc_count": 1
},
{
"key": "e577924c14df48179d45585b28aacca1",
"doc_count": 1
},
{
"key": "e8800fea53ee4087a0afd683a283ac96",
"doc_count": 1
},
{
"key": "ead060caa7294aae8318e8939f446ca3",
"doc_count": 1
},
{
"key": "ec8fcd9772ee451d91c03f532bc464f3",
"doc_count": 1
},
{
"key": "ef060cd426844b678bc6f4276355d74b",
"doc_count": 1
},
{
"key": "eff689d23e264c44b773885f2a4a39e9",
"doc_count": 1
},
{
"key": "fb3cb615b2f94d15843386656370f903",
"doc_count": 1
},
{
"key": "fcebc86ac3954b8092f471d6315e7c61",
"doc_count": 1
}
]
}
},
"price": {
"count": 48,
"min": 0.0,
"max": 2889.44,
"avg": 384.99875,
"sum": 18479.94
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "0345f5142cf242648058475ab4182b6d",
"doc_count": 48
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|