| 1 |
2.34 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":"4739ee5150ec4c428ef00a1c4320641d"}}}},{"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": 20,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_product_1717666750",
"_id": "27e04922bfdb4f35b4b70bafb0faf595",
"_score": null,
"_source": {
"id": "27e04922bfdb4f35b4b70bafb0faf595",
"autoIncrement": 4446.0
},
"fields": {
"displayGroup": [
"144786fdf95eb780f5efba6a1916b935"
]
},
"sort": [
2022.0,
"27e04922bfdb4f35b4b70bafb0faf595"
]
},
{
"_index": "sw_product_1717666750",
"_id": "018cf3cf60a5737283e6cb08e954a347",
"_score": null,
"_source": {
"id": "018cf3cf60a5737283e6cb08e954a347",
"autoIncrement": 4757.0
},
"fields": {
"displayGroup": [
"6615f9c819aef074830f706a7530d5dc"
]
},
"sort": [
2021.0,
"018cf3cf60a5737283e6cb08e954a347"
]
},
{
"_index": "sw_product_1717666750",
"_id": "07d493ef9f0f4441aaf75ec2a99c0e05",
"_score": null,
"_source": {
"id": "07d493ef9f0f4441aaf75ec2a99c0e05",
"autoIncrement": 4105.0
},
"fields": {
"displayGroup": [
"c22614f3db136a526a63ab2d08c8724c"
]
},
"sort": [
2021.0,
"07d493ef9f0f4441aaf75ec2a99c0e05"
]
},
{
"_index": "sw_product_1717666750",
"_id": "0c1155efa584484da5ab4749d163a891",
"_score": null,
"_source": {
"id": "0c1155efa584484da5ab4749d163a891",
"autoIncrement": 4123.0
},
"fields": {
"displayGroup": [
"54c397a43d05750f3fdecab43bd2bf12"
]
},
"sort": [
2021.0,
"0c1155efa584484da5ab4749d163a891"
]
},
{
"_index": "sw_product_1717666750",
"_id": "23033c59b7d5471692f23f735a6c288a",
"_score": null,
"_source": {
"id": "23033c59b7d5471692f23f735a6c288a",
"autoIncrement": 4108.0
},
"fields": {
"displayGroup": [
"a550bdc93e35a5311db767e0c10cd49e"
]
},
"sort": [
2021.0,
"23033c59b7d5471692f23f735a6c288a"
]
},
{
"_index": "sw_product_1717666750",
"_id": "59800f56818a4eb6aa07599017fb17de",
"_score": null,
"_source": {
"id": "59800f56818a4eb6aa07599017fb17de",
"autoIncrement": 4104.0
},
"fields": {
"displayGroup": [
"2c3402602f6b1b32d730a03a054161bd"
]
},
"sort": [
2021.0,
"59800f56818a4eb6aa07599017fb17de"
]
},
{
"_index": "sw_product_1717666750",
"_id": "b007ff76ad96484593c945c9c12451d3",
"_score": null,
"_source": {
"id": "b007ff76ad96484593c945c9c12451d3",
"autoIncrement": 4107.0
},
"fields": {
"displayGroup": [
"295644e26b011fe887227e2e0b724254"
]
},
"sort": [
2021.0,
"b007ff76ad96484593c945c9c12451d3"
]
},
{
"_index": "sw_product_1717666750",
"_id": "81bd689b2ad4479a861e43426cb5350c",
"_score": null,
"_source": {
"id": "81bd689b2ad4479a861e43426cb5350c",
"autoIncrement": 3795.0
},
"fields": {
"displayGroup": [
"1b46a51d9111c27d74276019e5ec644c"
]
},
"sort": [
2020.0,
"81bd689b2ad4479a861e43426cb5350c"
]
},
{
"_index": "sw_product_1717666750",
"_id": "e11322b38e064788acb5b451dff555d2",
"_score": null,
"_source": {
"id": "e11322b38e064788acb5b451dff555d2",
"autoIncrement": 3723.0
},
"fields": {
"displayGroup": [
"0657cb4b0018555290fa7ed866f18abf"
]
},
"sort": [
2020.0,
"e11322b38e064788acb5b451dff555d2"
]
},
{
"_index": "sw_product_1717666750",
"_id": "0837f01e61134d3981a3f4502c093289",
"_score": null,
"_source": {
"id": "0837f01e61134d3981a3f4502c093289",
"autoIncrement": 1584.0
},
"fields": {
"displayGroup": [
"51309451946c4ccaca8a1235e7119e82"
]
},
"sort": [
2019.0,
"0837f01e61134d3981a3f4502c093289"
]
},
{
"_index": "sw_product_1717666750",
"_id": "0a77262bbe4d49aca7aca434949dee83",
"_score": null,
"_source": {
"id": "0a77262bbe4d49aca7aca434949dee83",
"autoIncrement": 3762.0
},
"fields": {
"displayGroup": [
"d794365668855882ea9b8677d22c2fcf"
]
},
"sort": [
2019.0,
"0a77262bbe4d49aca7aca434949dee83"
]
},
{
"_index": "sw_product_1717666750",
"_id": "66e005754a2748329aee79273a6a06ec",
"_score": null,
"_source": {
"id": "66e005754a2748329aee79273a6a06ec",
"autoIncrement": 1590.0
},
"fields": {
"displayGroup": [
"4104190bc9e7973b9ff89a754df9b49c"
]
},
"sort": [
2019.0,
"66e005754a2748329aee79273a6a06ec"
]
},
{
"_index": "sw_product_1717666750",
"_id": "6e3a2214fb86466c86e27a89d2b1ecef",
"_score": null,
"_source": {
"id": "6e3a2214fb86466c86e27a89d2b1ecef",
"autoIncrement": 1585.0
},
"fields": {
"displayGroup": [
"00f37ce76b9780b645f1b7c7e897ab7e"
]
},
"sort": [
2019.0,
"6e3a2214fb86466c86e27a89d2b1ecef"
]
},
{
"_index": "sw_product_1717666750",
"_id": "8256df65fa3e481db37b3c879f19a02e",
"_score": null,
"_source": {
"id": "8256df65fa3e481db37b3c879f19a02e",
"autoIncrement": 1587.0
},
"fields": {
"displayGroup": [
"3f2c7727a44eaea7fa1c9424f2a568d0"
]
},
"sort": [
2019.0,
"8256df65fa3e481db37b3c879f19a02e"
]
},
{
"_index": "sw_product_1717666750",
"_id": "9abac85d784d473182b51f724d699fac",
"_score": null,
"_source": {
"id": "9abac85d784d473182b51f724d699fac",
"autoIncrement": 3858.0
},
"fields": {
"displayGroup": [
"7b98a55d088fb9b9595ea0f90a6db594"
]
},
"sort": [
2019.0,
"9abac85d784d473182b51f724d699fac"
]
},
{
"_index": "sw_product_1717666750",
"_id": "fb2f977ee8324538b232abe7dc6fdc17",
"_score": null,
"_source": {
"id": "fb2f977ee8324538b232abe7dc6fdc17",
"autoIncrement": 1586.0
},
"fields": {
"displayGroup": [
"c34a138a44642b77ee2931fe849bdd3a"
]
},
"sort": [
2019.0,
"fb2f977ee8324538b232abe7dc6fdc17"
]
},
{
"_index": "sw_product_1717666750",
"_id": "018cee4e512e70acbdf01e29207d7c66",
"_score": null,
"_source": {
"id": "018cee4e512e70acbdf01e29207d7c66",
"autoIncrement": 4756.0
},
"fields": {
"displayGroup": [
"260ad91696c99c25693f41558b4ccef7"
]
},
"sort": [
2018.0,
"018cee4e512e70acbdf01e29207d7c66"
]
},
{
"_index": "sw_product_1717666750",
"_id": "21c4ac0685d74790a7a7551999ddcc8e",
"_score": null,
"_source": {
"id": "21c4ac0685d74790a7a7551999ddcc8e",
"autoIncrement": 1589.0
},
"fields": {
"displayGroup": [
"122ef374a6cb55e37bd99d15eb374e98"
]
},
"sort": [
2018.0,
"21c4ac0685d74790a7a7551999ddcc8e"
]
},
{
"_index": "sw_product_1717666750",
"_id": "8c39bb4aa85f40f99e7c5acc410fb65d",
"_score": null,
"_source": {
"id": "8c39bb4aa85f40f99e7c5acc410fb65d",
"autoIncrement": 1588.0
},
"fields": {
"displayGroup": [
"13b085f380a32014ec40a3d245b4855e"
]
},
"sort": [
2018.0,
"8c39bb4aa85f40f99e7c5acc410fb65d"
]
},
{
"_index": "sw_product_1717666750",
"_id": "b92582b9bcea4c689a58d5b76b3fa01e",
"_score": null,
"_source": {
"id": "b92582b9bcea4c689a58d5b76b3fa01e",
"autoIncrement": 1583.0
},
"fields": {
"displayGroup": [
"77e6a221a684a6348e6a462004422287"
]
},
"sort": [
2018.0,
"b92582b9bcea4c689a58d5b76b3fa01e"
]
}
]
},
"aggregations": {
"total-count": {
"value": 20
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
1.12 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":"4739ee5150ec4c428ef00a1c4320641d"}}}},{"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_rule0197e9e4d10e7293b705c1d0eee95b29_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule0197e9e4d446718a91aafc7b03ab341a_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": {
"shipping-free-filter": {
"doc_count": 0,
"shipping-free": {
"value": null
}
},
"rating-exists": {
"doc_count": 20,
"rating": {
"value": 0.0
}
},
"price": {
"count": 20,
"min": 8.33,
"max": 1361.18,
"avg": 156.4575,
"sum": 3129.15
},
"options": {
"doc_count": 0,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": []
}
},
"properties": {
"doc_count": 298,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "0c189ea565ab4573a222115adc6b9258",
"doc_count": 20
},
{
"key": "45018ee86cc84c47b8d18583215e11fb",
"doc_count": 20
},
{
"key": "5affebe282fa4815b16b8cbf1ffe586a",
"doc_count": 20
},
{
"key": "5dbcbace2b244c9faaf06c6c22121dde",
"doc_count": 20
},
{
"key": "c00d09ec51844aefa2781fcc00839644",
"doc_count": 20
},
{
"key": "d1ffe31ac2db4177b9d2179f91f16173",
"doc_count": 20
},
{
"key": "ab5a91723f3547fba5214d182e94e799",
"doc_count": 13
},
{
"key": "b81318b1758e42bc8be1559a7f6df0bc",
"doc_count": 11
},
{
"key": "e216ce0edfdd40e4af8bbf624a6da3cf",
"doc_count": 11
},
{
"key": "f3addfa0aa8f492b93ef4d41f76ff1fd",
"doc_count": 10
},
{
"key": "256aa072d598469cbe2a99d63859b36e",
"doc_count": 9
},
{
"key": "501073135cd94357a9438f29267e89ec",
"doc_count": 8
},
{
"key": "65798a73c7e44bcdbe0b0f0b53116c84",
"doc_count": 8
},
{
"key": "adfd37fa8d88405d8be97bde6b963aef",
"doc_count": 7
},
{
"key": "50bede51bbaa4f4aba7003a45cf998b3",
"doc_count": 6
},
{
"key": "5ab38019ed7843e7b3b2218c5a19e933",
"doc_count": 5
},
{
"key": "cdd1e121488840ffaff218a71c4a8a7c",
"doc_count": 5
},
{
"key": "745d9946202e4310a3288c5a80070301",
"doc_count": 4
},
{
"key": "bcfd8dff179149088e720a4ff4527e56",
"doc_count": 4
},
{
"key": "457816050d9e4b619e7fdddfbf31b579",
"doc_count": 3
},
{
"key": "79709bed515d4a1593cdc09df948021e",
"doc_count": 3
},
{
"key": "84fb63e56b124a1b8351cbf81a6d69ed",
"doc_count": 3
},
{
"key": "85007d00dbb3447c90183857550eb42a",
"doc_count": 3
},
{
"key": "950074db1e3749c6a39dbce3b25beda3",
"doc_count": 3
},
{
"key": "998c9b372d1a4245a79724d3c6f0289e",
"doc_count": 3
},
{
"key": "9c2a7772fd914dfcb36cad04c8a9d892",
"doc_count": 3
},
{
"key": "b17e0030883f443eb86e83ea0e398602",
"doc_count": 3
},
{
"key": "da73ead1b1964a929f9369fb17e21c3b",
"doc_count": 3
},
{
"key": "004c9f1122be4d3db1dadecc53a44cdf",
"doc_count": 2
},
{
"key": "2ba9657c9c574e9aa85f70814078ad7e",
"doc_count": 2
},
{
"key": "410881ebf6734b9793a17eef2dd2eb40",
"doc_count": 2
},
{
"key": "5b8f5b04a97b47e2b04efe565e99a70a",
"doc_count": 2
},
{
"key": "5e0ef15734344f53b08844500db65cd7",
"doc_count": 2
},
{
"key": "6e0de86206a64595afd3ec2f042ae45a",
"doc_count": 2
},
{
"key": "7427730fb0284146926899bc82c437ac",
"doc_count": 2
},
{
"key": "786db9f574684aecafe974251ed266f5",
"doc_count": 2
},
{
"key": "8a6ac1662b934451b6e3bc6e665c3bea",
"doc_count": 2
},
{
"key": "9777f181ffe843dea6d2c8ea503871f9",
"doc_count": 2
},
{
"key": "97e91b44c63045459a74bf3a7637a658",
"doc_count": 2
},
{
"key": "b45112415fc24167b2a3f7b257a9cf8f",
"doc_count": 2
},
{
"key": "bb62085cec734c48a25a9f07470cf013",
"doc_count": 2
},
{
"key": "c1d70719badf4382b9dabd1bb5a380bf",
"doc_count": 2
},
{
"key": "ca0798b913784ff9880ac954d5b61825",
"doc_count": 2
},
{
"key": "d0c07ddcae6a4425b96e363887660b9f",
"doc_count": 2
},
{
"key": "d36d9414811c4f578fa271cae17b9937",
"doc_count": 2
},
{
"key": "e4fd8f415a434a81b75226eb5e08a154",
"doc_count": 2
},
{
"key": "e55048c6f6704f79a2a866ae802be089",
"doc_count": 2
},
{
"key": "eacf349b35b7494c8bbf7cb92ee7e3d6",
"doc_count": 2
},
{
"key": "fc4cb3aa0adf4ae8a02c230d3cb41aea",
"doc_count": 2
},
{
"key": "902e73e5a195427a8c2acadf9b62e530",
"doc_count": 1
},
{
"key": "95b225def2a7402c9e6f2e5b647ac8cb",
"doc_count": 1
},
{
"key": "9891a6c97f5d4246993d1c45545ce697",
"doc_count": 1
},
{
"key": "a8e7b52ef0fe44b5b2a9b14cbc26023d",
"doc_count": 1
},
{
"key": "aca2278dd7cb406fb0d3b5407da74ad0",
"doc_count": 1
},
{
"key": "aec02b3ec4a34abf96988ed52b463e09",
"doc_count": 1
},
{
"key": "b20e8c1d91b144b0a9a41fe43aa6b521",
"doc_count": 1
},
{
"key": "c7cc8a656cf841ca898ab1f1ad507138",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "62c6c9fe64c64ade84cac314d374d37e",
"doc_count": 20
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|