| 1 |
5.58 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":"2e0775c4ba4048faa99dec77dff8aaab"}}}},{"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": 18,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "rosland_product_1712914068",
"_id": "018d789dc2be73848a8fafe8a1ad3a1d",
"_score": null,
"_source": {
"id": "018d789dc2be73848a8fafe8a1ad3a1d",
"autoIncrement": 4764.0
},
"fields": {
"displayGroup": [
"263889b68c775bf3a27948a465716ab9"
]
},
"sort": [
2024.0,
"018d789dc2be73848a8fafe8a1ad3a1d"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "018d78a7440e71ff87d06eca9d60b579",
"_score": null,
"_source": {
"id": "018d78a7440e71ff87d06eca9d60b579",
"autoIncrement": 4765.0
},
"fields": {
"displayGroup": [
"4115025dcbb40aabc3d88ee6fbb981e3"
]
},
"sort": [
2024.0,
"018d78a7440e71ff87d06eca9d60b579"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "018d78b2af2d7375a230682578760aa0",
"_score": null,
"_source": {
"id": "018d78b2af2d7375a230682578760aa0",
"autoIncrement": 4766.0
},
"fields": {
"displayGroup": [
"a0980484686baac210a1c9467294c98f"
]
},
"sort": [
2024.0,
"018d78b2af2d7375a230682578760aa0"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "018e37cbd953723cbe16feed53f830a6",
"_score": null,
"_source": {
"id": "018e37cbd953723cbe16feed53f830a6",
"autoIncrement": 4787.0
},
"fields": {
"displayGroup": [
"08435a195fa95cbd81e9f94a0c374ec3"
]
},
"sort": [
2024.0,
"018e37cbd953723cbe16feed53f830a6"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "018fb9a4bf14711da4d82a7c53ce1566",
"_score": null,
"_source": {
"id": "018fb9a4bf14711da4d82a7c53ce1566",
"autoIncrement": 4806.0
},
"fields": {
"displayGroup": [
"e355468c11d5addd663e50fd3747c15e"
]
},
"sort": [
2024.0,
"018fb9a4bf14711da4d82a7c53ce1566"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "018a940da0c272a680e439b2a9cd4e2e",
"_score": null,
"_source": {
"id": "018a940da0c272a680e439b2a9cd4e2e",
"autoIncrement": 4552.0
},
"fields": {
"displayGroup": [
"82d1d6b3c25c922a2ff715f85a3053f1"
]
},
"sort": [
2023.0,
"018a940da0c272a680e439b2a9cd4e2e"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "018a9414d68270b68dec662f258fd710",
"_score": null,
"_source": {
"id": "018a9414d68270b68dec662f258fd710",
"autoIncrement": 4553.0
},
"fields": {
"displayGroup": [
"8963f30883df3d834161595f30994aae"
]
},
"sort": [
2023.0,
"018a9414d68270b68dec662f258fd710"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "018a941a55bf71aeb0daf020aa7266e1",
"_score": null,
"_source": {
"id": "018a941a55bf71aeb0daf020aa7266e1",
"autoIncrement": 4554.0
},
"fields": {
"displayGroup": [
"a45e087d97830484623a59e6a9bbeb36"
]
},
"sort": [
2023.0,
"018a941a55bf71aeb0daf020aa7266e1"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "018a942075577155ae205e37345ec20a",
"_score": null,
"_source": {
"id": "018a942075577155ae205e37345ec20a",
"autoIncrement": 4555.0
},
"fields": {
"displayGroup": [
"9208b94f49a3ce5844b7974bacc49d7f"
]
},
"sort": [
2023.0,
"018a942075577155ae205e37345ec20a"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "018a97f8b9ca73c8bab8d8e4ab24d161",
"_score": null,
"_source": {
"id": "018a97f8b9ca73c8bab8d8e4ab24d161",
"autoIncrement": 4557.0
},
"fields": {
"displayGroup": [
"2623c6c2f0da95e72ae6b2b228ae44c6"
]
},
"sort": [
2023.0,
"018a97f8b9ca73c8bab8d8e4ab24d161"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "018a9800094a7202b01e45573cffc868",
"_score": null,
"_source": {
"id": "018a9800094a7202b01e45573cffc868",
"autoIncrement": 4558.0
},
"fields": {
"displayGroup": [
"81c9feeeb0428f273c587a79ecb01a54"
]
},
"sort": [
2023.0,
"018a9800094a7202b01e45573cffc868"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "018a98040b7c713dab0c291db8dc82b3",
"_score": null,
"_source": {
"id": "018a98040b7c713dab0c291db8dc82b3",
"autoIncrement": 4559.0
},
"fields": {
"displayGroup": [
"1ec4320de4ed6f5e18b7b1f76eaf4817"
]
},
"sort": [
2023.0,
"018a98040b7c713dab0c291db8dc82b3"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "018a9808e60d7135a1093e005fa45aa9",
"_score": null,
"_source": {
"id": "018a9808e60d7135a1093e005fa45aa9",
"autoIncrement": 4560.0
},
"fields": {
"displayGroup": [
"8f18499319fb89236c97f781cd22a4c8"
]
},
"sort": [
2023.0,
"018a9808e60d7135a1093e005fa45aa9"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "018a980cd73b732291a178d467849361",
"_score": null,
"_source": {
"id": "018a980cd73b732291a178d467849361",
"autoIncrement": 4561.0
},
"fields": {
"displayGroup": [
"eaf2adcbe78d0daa60275497723048dc"
]
},
"sort": [
2023.0,
"018a980cd73b732291a178d467849361"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "018a984c17a471a3bf8ba1e2a37aae9d",
"_score": null,
"_source": {
"id": "018a984c17a471a3bf8ba1e2a37aae9d",
"autoIncrement": 4562.0
},
"fields": {
"displayGroup": [
"7db86fa0c7781df9b9eccd8cbc2c8ea1"
]
},
"sort": [
2023.0,
"018a984c17a471a3bf8ba1e2a37aae9d"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "018a985487fc72c7b797abde0138a6d5",
"_score": null,
"_source": {
"id": "018a985487fc72c7b797abde0138a6d5",
"autoIncrement": 4563.0
},
"fields": {
"displayGroup": [
"805d09892f48540df05fcd5b042ae248"
]
},
"sort": [
2023.0,
"018a985487fc72c7b797abde0138a6d5"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "05cc2e991d2d47ca840179bb3eb75ba9",
"_score": null,
"_source": {
"id": "05cc2e991d2d47ca840179bb3eb75ba9",
"autoIncrement": 4444.0
},
"fields": {
"displayGroup": [
"7049452c323ee55ac163818733bf7400"
]
},
"sort": [
2023.0,
"05cc2e991d2d47ca840179bb3eb75ba9"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "ce4610e9ad914cfd8e5cf192f6f5339d",
"_score": null,
"_source": {
"id": "ce4610e9ad914cfd8e5cf192f6f5339d",
"autoIncrement": 4230.0
},
"fields": {
"displayGroup": [
"7d6ca47464c5f5948a98dfecf8970ad0"
]
},
"sort": [
2023.0,
"ce4610e9ad914cfd8e5cf192f6f5339d"
]
}
]
},
"aggregations": {
"total-count": {
"value": 18
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
2.06 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":"2e0775c4ba4048faa99dec77dff8aaab"}}}},{"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": 18,
"rating": {
"value": 0.0
}
},
"properties": {
"doc_count": 299,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "16c63023894f40c29a8d441f052b01fd",
"doc_count": 18
},
{
"key": "3a7e5383173049a9870e0213864728e3",
"doc_count": 18
},
{
"key": "45018ee86cc84c47b8d18583215e11fb",
"doc_count": 18
},
{
"key": "de13eba6d2fc4edc96f91a594e3bb0ba",
"doc_count": 18
},
{
"key": "c00d09ec51844aefa2781fcc00839644",
"doc_count": 15
},
{
"key": "8a6ac1662b934451b6e3bc6e665c3bea",
"doc_count": 13
},
{
"key": "75b3bac4e87041dfb2b7707e34c37775",
"doc_count": 11
},
{
"key": "80e3982c09e14668b61b2435788dd74e",
"doc_count": 11
},
{
"key": "256aa072d598469cbe2a99d63859b36e",
"doc_count": 8
},
{
"key": "7492acc04b454c3d961a64c10b94643a",
"doc_count": 8
},
{
"key": "be7a046a01af4ef683a2d61d0d49feeb",
"doc_count": 8
},
{
"key": "c4bb576e968f4bd7995150ffc4a7a44d",
"doc_count": 8
},
{
"key": "d9fa2505750f417e81edbcbf558f6959",
"doc_count": 8
},
{
"key": "f3addfa0aa8f492b93ef4d41f76ff1fd",
"doc_count": 8
},
{
"key": "99544516e0e04f7f9cd839b4d9bc2b91",
"doc_count": 7
},
{
"key": "b81318b1758e42bc8be1559a7f6df0bc",
"doc_count": 6
},
{
"key": "da73ead1b1964a929f9369fb17e21c3b",
"doc_count": 6
},
{
"key": "018af03e1d7c7c8dabe65059358dbeba",
"doc_count": 5
},
{
"key": "950074db1e3749c6a39dbce3b25beda3",
"doc_count": 5
},
{
"key": "acc15fd13ca94d30a191529d268a7256",
"doc_count": 5
},
{
"key": "fb3cb615b2f94d15843386656370f903",
"doc_count": 5
},
{
"key": "3c0aabc08db641c48171fb5bfaa1d462",
"doc_count": 4
},
{
"key": "82ef30faf3994ebb8aa8e7396bc9c379",
"doc_count": 4
},
{
"key": "a9705b0538cb42a3be5018cf5701955d",
"doc_count": 4
},
{
"key": "d0c07ddcae6a4425b96e363887660b9f",
"doc_count": 4
},
{
"key": "e577924c14df48179d45585b28aacca1",
"doc_count": 4
},
{
"key": "ef060cd426844b678bc6f4276355d74b",
"doc_count": 4
},
{
"key": "004c9f1122be4d3db1dadecc53a44cdf",
"doc_count": 3
},
{
"key": "2502dd7c35f344aba0b2238740ee3157",
"doc_count": 3
},
{
"key": "255fbc8387fc471ebebc7f1729675fc6",
"doc_count": 3
},
{
"key": "276cdd68b28844569066cf000ab6cb31",
"doc_count": 3
},
{
"key": "34680579f19740cfac012f53c2d14579",
"doc_count": 3
},
{
"key": "3f7c6b24c4f54a8991e5d757a63803df",
"doc_count": 3
},
{
"key": "50bede51bbaa4f4aba7003a45cf998b3",
"doc_count": 3
},
{
"key": "b4027b3a06744f9b8000817889b34f70",
"doc_count": 3
},
{
"key": "b57d1d0eb833459bbda07a3adca6714c",
"doc_count": 3
},
{
"key": "b8dd631079d34d42b559a3eb42f6cfa6",
"doc_count": 3
},
{
"key": "c057aaf844b84af9a250efc7be0def2c",
"doc_count": 3
},
{
"key": "df82a71019c348f88bf1cebb3175c4b1",
"doc_count": 3
},
{
"key": "eacf349b35b7494c8bbf7cb92ee7e3d6",
"doc_count": 3
},
{
"key": "f1d5de05f6c345a68b742dd2528af946",
"doc_count": 3
},
{
"key": "27dbf2dab398426fb2f3099e28933f81",
"doc_count": 2
},
{
"key": "2b1d38fab0634d6ba9bc37ae28f6adcf",
"doc_count": 2
},
{
"key": "3a0e40c81b2e46e5934261f84f9a932c",
"doc_count": 2
},
{
"key": "4665fd14d872415baeb2e71e59780f94",
"doc_count": 2
},
{
"key": "5d7cdee62433436cb5ff14b769ad2b3e",
"doc_count": 2
},
{
"key": "6f92af8d0f0a4ae99239c1bd9f68d3d3",
"doc_count": 2
},
{
"key": "cdd1e121488840ffaff218a71c4a8a7c",
"doc_count": 2
},
{
"key": "018a980f003778a48b6a616c514deeea",
"doc_count": 1
},
{
"key": "079fd5363b4841a6aac9c8615186b4cd",
"doc_count": 1
},
{
"key": "20307aa6ea24472fbcbae9213a330f80",
"doc_count": 1
},
{
"key": "21c6d9da1151485e8d7df15a2cebf518",
"doc_count": 1
},
{
"key": "233d9b3b401d4def8b2f6f981802562c",
"doc_count": 1
},
{
"key": "38e8473f07354461a08b4a6851c0bb65",
"doc_count": 1
},
{
"key": "4261829747ec48b884a9e118599ebdbf",
"doc_count": 1
},
{
"key": "68d53e4fcb8b46ad9b39942c2553ec76",
"doc_count": 1
},
{
"key": "b577174053d2456d8307a6b59d762ca8",
"doc_count": 1
},
{
"key": "e0a7f42ebaf743c694883cd85d2ba906",
"doc_count": 1
}
]
}
},
"price": {
"count": 18,
"min": 0.0,
"max": 2889.44,
"avg": 1418.8055555555557,
"sum": 25538.5
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "0345f5142cf242648058475ab4182b6d",
"doc_count": 18
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|