| 1 |
2.35 ms |
Request:
{"index":"sw_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":"dd427d244e834f599b0648e19a885a7e"}}}},{"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": "sw_product_1717666750",
"_id": "0194b7cc0f6c701e888c7f773b0a5703",
"_score": null,
"_source": {
"id": "0194b7cc0f6c701e888c7f773b0a5703",
"autoIncrement": 4985.0
},
"fields": {
"displayGroup": [
"15345d7a866a25dc8cf04d7e535df647"
]
},
"sort": [
2025.0,
"0194b7cc0f6c701e888c7f773b0a5703"
]
},
{
"_index": "sw_product_1717666750",
"_id": "0194b7d26ab972c0b4ecfcf40c0dd8bd",
"_score": null,
"_source": {
"id": "0194b7d26ab972c0b4ecfcf40c0dd8bd",
"autoIncrement": 4986.0
},
"fields": {
"displayGroup": [
"2f0eb7d9826c796223a0a6abb42b57e4"
]
},
"sort": [
2025.0,
"0194b7d26ab972c0b4ecfcf40c0dd8bd"
]
},
{
"_index": "sw_product_1717666750",
"_id": "0194b7d8911a702f816d1781fb0035d5",
"_score": null,
"_source": {
"id": "0194b7d8911a702f816d1781fb0035d5",
"autoIncrement": 4987.0
},
"fields": {
"displayGroup": [
"e2aefd36e617d536f9bd4c82b457f6e9"
]
},
"sort": [
2025.0,
"0194b7d8911a702f816d1781fb0035d5"
]
},
{
"_index": "sw_product_1717666750",
"_id": "018d7937ceb67278a8588d17bb95e73c",
"_score": null,
"_source": {
"id": "018d7937ceb67278a8588d17bb95e73c",
"autoIncrement": 4769.0
},
"fields": {
"displayGroup": [
"e2edbbb651b15070b9493da0e029ee41"
]
},
"sort": [
2024.0,
"018d7937ceb67278a8588d17bb95e73c"
]
},
{
"_index": "sw_product_1717666750",
"_id": "018a8994ef547023b7c6824a4875571c",
"_score": null,
"_source": {
"id": "018a8994ef547023b7c6824a4875571c",
"autoIncrement": 4519.0
},
"fields": {
"displayGroup": [
"7e7cee4436e34420d5e90a63946ccff4"
]
},
"sort": [
2023.0,
"018a8994ef547023b7c6824a4875571c"
]
},
{
"_index": "sw_product_1717666750",
"_id": "018a89b29aa1705f9100a5667b3a9c78",
"_score": null,
"_source": {
"id": "018a89b29aa1705f9100a5667b3a9c78",
"autoIncrement": 4520.0
},
"fields": {
"displayGroup": [
"0c401fd993cc3c83e76853d72feeb3ee"
]
},
"sort": [
2023.0,
"018a89b29aa1705f9100a5667b3a9c78"
]
},
{
"_index": "sw_product_1717666750",
"_id": "018a8ec83871713b9f002c1ee4b5bac4",
"_score": null,
"_source": {
"id": "018a8ec83871713b9f002c1ee4b5bac4",
"autoIncrement": 4536.0
},
"fields": {
"displayGroup": [
"71347ef4ad1a81105699c26ef936a9de"
]
},
"sort": [
2023.0,
"018a8ec83871713b9f002c1ee4b5bac4"
]
},
{
"_index": "sw_product_1717666750",
"_id": "018a8ef2369572acaaa423a0a0bccf6f",
"_score": null,
"_source": {
"id": "018a8ef2369572acaaa423a0a0bccf6f",
"autoIncrement": 4541.0
},
"fields": {
"displayGroup": [
"e439a68c5db6306193b0b43df5a7eb86"
]
},
"sort": [
2023.0,
"018a8ef2369572acaaa423a0a0bccf6f"
]
},
{
"_index": "sw_product_1717666750",
"_id": "6db905f2697b47d8bcb45a44e1b0b385",
"_score": null,
"_source": {
"id": "6db905f2697b47d8bcb45a44e1b0b385",
"autoIncrement": 3848.0
},
"fields": {
"displayGroup": [
"960ac467fa559cd6b8583b027056ba0b"
]
},
"sort": [
2021.0,
"6db905f2697b47d8bcb45a44e1b0b385"
]
},
{
"_index": "sw_product_1717666750",
"_id": "be3afae91c0f4e7abcbb833a05a4a35d",
"_score": null,
"_source": {
"id": "be3afae91c0f4e7abcbb833a05a4a35d",
"autoIncrement": 3636.0
},
"fields": {
"displayGroup": [
"19de5e87e45e21b50a346f7472e2ed59"
]
},
"sort": [
2020.0,
"be3afae91c0f4e7abcbb833a05a4a35d"
]
},
{
"_index": "sw_product_1717666750",
"_id": "19e998e0916b4dc6a4b91b7bbe218808",
"_score": null,
"_source": {
"id": "19e998e0916b4dc6a4b91b7bbe218808",
"autoIncrement": 3452.0
},
"fields": {
"displayGroup": [
"7161c86bfa3409d518ddc6c730531f7f"
]
},
"sort": [
2019.0,
"19e998e0916b4dc6a4b91b7bbe218808"
]
},
{
"_index": "sw_product_1717666750",
"_id": "bfbc0a330a7644db8686e00f1cb77dfd",
"_score": null,
"_source": {
"id": "bfbc0a330a7644db8686e00f1cb77dfd",
"autoIncrement": 3396.0
},
"fields": {
"displayGroup": [
"dad6b94fd7243a911e456cbf0ae54326"
]
},
"sort": [
2019.0,
"bfbc0a330a7644db8686e00f1cb77dfd"
]
},
{
"_index": "sw_product_1717666750",
"_id": "018a8edd32ea707c9e20381018ea44eb",
"_score": null,
"_source": {
"id": "018a8edd32ea707c9e20381018ea44eb",
"autoIncrement": 4540.0
},
"fields": {
"displayGroup": [
"0e0070db6ef47705de1b13fa20312783"
]
},
"sort": [
2018.0,
"018a8edd32ea707c9e20381018ea44eb"
]
},
{
"_index": "sw_product_1717666750",
"_id": "cf3396fef9384486b7ecec8f0160b544",
"_score": null,
"_source": {
"id": "cf3396fef9384486b7ecec8f0160b544",
"autoIncrement": 292.0
},
"fields": {
"displayGroup": [
"444d2a52cf72d74b7a121e73d66a5b19"
]
},
"sort": [
2018.0,
"cf3396fef9384486b7ecec8f0160b544"
]
},
{
"_index": "sw_product_1717666750",
"_id": "fcec7ea5900546b69b07a73d8576d8c3",
"_score": null,
"_source": {
"id": "fcec7ea5900546b69b07a73d8576d8c3",
"autoIncrement": 293.0
},
"fields": {
"displayGroup": [
"2688f915ec987bee79e943b47b0339cd"
]
},
"sort": [
2018.0,
"fcec7ea5900546b69b07a73d8576d8c3"
]
},
{
"_index": "sw_product_1717666750",
"_id": "24fb6592e6b945fe86950895d66f788c",
"_score": null,
"_source": {
"id": "24fb6592e6b945fe86950895d66f788c",
"autoIncrement": 299.0
},
"fields": {
"displayGroup": [
"2dd2e71e09a3b6eef57e790f188e7ab5"
]
},
"sort": [
2017.0,
"24fb6592e6b945fe86950895d66f788c"
]
},
{
"_index": "sw_product_1717666750",
"_id": "447a3b6043df4fe3871be7d0e3706b94",
"_score": null,
"_source": {
"id": "447a3b6043df4fe3871be7d0e3706b94",
"autoIncrement": 298.0
},
"fields": {
"displayGroup": [
"af0440715a5ee526d4cbcaa16caaca44"
]
},
"sort": [
2016.0,
"447a3b6043df4fe3871be7d0e3706b94"
]
},
{
"_index": "sw_product_1717666750",
"_id": "d953a414ea9c474789900bd8773a6cb7",
"_score": null,
"_source": {
"id": "d953a414ea9c474789900bd8773a6cb7",
"autoIncrement": 296.0
},
"fields": {
"displayGroup": [
"ebe1b0ef3ffc677f73d77494bd4f925a"
]
},
"sort": [
2015.0,
"d953a414ea9c474789900bd8773a6cb7"
]
},
{
"_index": "sw_product_1717666750",
"_id": "98b54d0a7fb346c49bb42945eb5791ff",
"_score": null,
"_source": {
"id": "98b54d0a7fb346c49bb42945eb5791ff",
"autoIncrement": 297.0
},
"fields": {
"displayGroup": [
"9e23ef0ae58bc86c2f24783e350a9763"
]
},
"sort": [
2014.0,
"98b54d0a7fb346c49bb42945eb5791ff"
]
},
{
"_index": "sw_product_1717666750",
"_id": "7a781f59bba4434ba26165b3d683b1cc",
"_score": null,
"_source": {
"id": "7a781f59bba4434ba26165b3d683b1cc",
"autoIncrement": 2588.0
},
"fields": {
"displayGroup": [
"aa0850cd8c80b204baaec5237ec11c52"
]
},
"sort": [
2013.0,
"7a781f59bba4434ba26165b3d683b1cc"
]
},
{
"_index": "sw_product_1717666750",
"_id": "e20dc938933b4929afea008755a0af26",
"_score": null,
"_source": {
"id": "e20dc938933b4929afea008755a0af26",
"autoIncrement": 295.0
},
"fields": {
"displayGroup": [
"2521d64642e2de777c5a795442063a12"
]
},
"sort": [
2012.0,
"e20dc938933b4929afea008755a0af26"
]
},
{
"_index": "sw_product_1717666750",
"_id": "5f731f5668de44f89b6cf355199a2bdb",
"_score": null,
"_source": {
"id": "5f731f5668de44f89b6cf355199a2bdb",
"autoIncrement": 294.0
},
"fields": {
"displayGroup": [
"3ab7ccf53674f1f1d0f0ccf723b1a80b"
]
},
"sort": [
2011.0,
"5f731f5668de44f89b6cf355199a2bdb"
]
},
{
"_index": "sw_product_1717666750",
"_id": "8500c110109f45d7b54f482955d38e00",
"_score": null,
"_source": {
"id": "8500c110109f45d7b54f482955d38e00",
"autoIncrement": 291.0
},
"fields": {
"displayGroup": [
"17956ccf775bad8b99da6aece5bb757b"
]
},
"sort": [
2010.0,
"8500c110109f45d7b54f482955d38e00"
]
},
{
"_index": "sw_product_1717666750",
"_id": "67701a3228974bebb37b9ca56afbd767",
"_score": null,
"_source": {
"id": "67701a3228974bebb37b9ca56afbd767",
"autoIncrement": 290.0
},
"fields": {
"displayGroup": [
"210b72072c7886b950a7b74f8a55b0c4"
]
},
"sort": [
2008.0,
"67701a3228974bebb37b9ca56afbd767"
]
}
]
},
"aggregations": {
"total-count": {
"value": 24
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
2.03 ms |
Request:
{"index":"sw_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":"dd427d244e834f599b0648e19a885a7e"}}}},{"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": 1,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"max_score": null,
"hits": []
},
"aggregations": {
"shipping-free-filter": {
"doc_count": 0,
"shipping-free": {
"value": null
}
},
"rating-exists": {
"doc_count": 24,
"rating": {
"value": 0.0
}
},
"price": {
"count": 24,
"min": 8.33,
"max": 122.13,
"avg": 59.361250000000005,
"sum": 1424.67
},
"options": {
"doc_count": 0,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": []
}
},
"properties": {
"doc_count": 319,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "158d4f380ddb43d482095779cfffafa8",
"doc_count": 24
},
{
"key": "8ea6d7bbbcd24ac7857d738dbba7d056",
"doc_count": 24
},
{
"key": "98301be66a2c41a4914eda011b8b4795",
"doc_count": 24
},
{
"key": "da388262b87f4c54894feeceb9dd421b",
"doc_count": 22
},
{
"key": "528b3840acb344d58eaad59f9085ed0a",
"doc_count": 21
},
{
"key": "45018ee86cc84c47b8d18583215e11fb",
"doc_count": 19
},
{
"key": "b81318b1758e42bc8be1559a7f6df0bc",
"doc_count": 16
},
{
"key": "4a1cd38748fb434f9b51d7373429df51",
"doc_count": 15
},
{
"key": "35c7230af8754beda6518418607405ba",
"doc_count": 14
},
{
"key": "9212eb311fec479bb45a3b6585184513",
"doc_count": 14
},
{
"key": "bb2aca011dc44badab027fb55a1ec97b",
"doc_count": 13
},
{
"key": "c00d09ec51844aefa2781fcc00839644",
"doc_count": 12
},
{
"key": "0c189ea565ab4573a222115adc6b9258",
"doc_count": 11
},
{
"key": "256aa072d598469cbe2a99d63859b36e",
"doc_count": 7
},
{
"key": "6b152dafe3014d5a9606d80e83dd75bd",
"doc_count": 7
},
{
"key": "f3addfa0aa8f492b93ef4d41f76ff1fd",
"doc_count": 7
},
{
"key": "8037bcb96a7f408c8808e61a24bee078",
"doc_count": 6
},
{
"key": "f199b6bbfb3146e8baa63108b08791df",
"doc_count": 6
},
{
"key": "27e5bf7420c14d1e82c251f92742efbd",
"doc_count": 4
},
{
"key": "8a6ac1662b934451b6e3bc6e665c3bea",
"doc_count": 4
},
{
"key": "950074db1e3749c6a39dbce3b25beda3",
"doc_count": 4
},
{
"key": "01928a7829d67d639ecf3241a302231e",
"doc_count": 3
},
{
"key": "50bede51bbaa4f4aba7003a45cf998b3",
"doc_count": 3
},
{
"key": "998c9b372d1a4245a79724d3c6f0289e",
"doc_count": 3
},
{
"key": "004c9f1122be4d3db1dadecc53a44cdf",
"doc_count": 2
},
{
"key": "1285d1a126a342bfa7fc35f5de1d0b93",
"doc_count": 2
},
{
"key": "79709bed515d4a1593cdc09df948021e",
"doc_count": 2
},
{
"key": "85007d00dbb3447c90183857550eb42a",
"doc_count": 2
},
{
"key": "895679cb71af456eb328546d75b620af",
"doc_count": 2
},
{
"key": "a2568bf10c1a40bc85524827db8a457b",
"doc_count": 2
},
{
"key": "adfd37fa8d88405d8be97bde6b963aef",
"doc_count": 2
},
{
"key": "d0c07ddcae6a4425b96e363887660b9f",
"doc_count": 2
},
{
"key": "f5014da77e00404584bd350cebc56ddf",
"doc_count": 2
},
{
"key": "018af03e1d7c7c8dabe65059358dbeba",
"doc_count": 1
},
{
"key": "06e4d27eb94d4cc1aca5541219423d71",
"doc_count": 1
},
{
"key": "0ad2db72f8c446a29c956ed6e9f78fb4",
"doc_count": 1
},
{
"key": "0d610c26cc31452fbd2a2853764fb32c",
"doc_count": 1
},
{
"key": "19ff354e70aa45dba8fe4f7c2f81db8a",
"doc_count": 1
},
{
"key": "2502dd7c35f344aba0b2238740ee3157",
"doc_count": 1
},
{
"key": "5ab38019ed7843e7b3b2218c5a19e933",
"doc_count": 1
},
{
"key": "5b2854b6c9da458e8bf92359a79545e8",
"doc_count": 1
},
{
"key": "9a60f14fa86443ff98d00b82e1578dd0",
"doc_count": 1
},
{
"key": "a22ffb31eeef4dec9f2742125159dc7d",
"doc_count": 1
},
{
"key": "b8dca207ceb6469c9d0c5e7938a0774c",
"doc_count": 1
},
{
"key": "ca0798b913784ff9880ac954d5b61825",
"doc_count": 1
},
{
"key": "d87edd2454464161b85302e13bb3d42d",
"doc_count": 1
},
{
"key": "da73ead1b1964a929f9369fb17e21c3b",
"doc_count": 1
},
{
"key": "eacf349b35b7494c8bbf7cb92ee7e3d6",
"doc_count": 1
},
{
"key": "eff689d23e264c44b773885f2a4a39e9",
"doc_count": 1
},
{
"key": "fa5ba8686d624d83bd45318e5817d5ca",
"doc_count": 1
},
{
"key": "fcebc86ac3954b8092f471d6315e7c61",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "e4c4bbe038b843de97e4cc3d27d3ee57",
"doc_count": 24
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|