| 1 |
7.15 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":"c5f41c4d69104dd68417fbd54eab441b"}}}},{"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": "rosland_product_1712914068",
"_id": "018b1e6376217249b7bc837215fcb157",
"_score": null,
"_source": {
"id": "018b1e6376217249b7bc837215fcb157",
"autoIncrement": 4684.0
},
"fields": {
"displayGroup": [
"0e6ca5ab6feb77b4a92962a30e9d9b94"
]
},
"sort": [
2023.0,
"018b1e6376217249b7bc837215fcb157"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "018d7e580b2472218ffaab8975df11fa",
"_score": null,
"_source": {
"id": "018d7e580b2472218ffaab8975df11fa",
"autoIncrement": 4776.0
},
"fields": {
"displayGroup": [
"8444f6f88ce8cbcef5c45bf511057b8d"
]
},
"sort": [
2023.0,
"018d7e580b2472218ffaab8975df11fa"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "76d20e08582a441ba37fad1fc892647d",
"_score": null,
"_source": {
"id": "76d20e08582a441ba37fad1fc892647d",
"autoIncrement": 4372.0
},
"fields": {
"displayGroup": [
"625f0921187007057fcba88ea3c172da"
]
},
"sort": [
2022.0,
"76d20e08582a441ba37fad1fc892647d"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "ea8d0dca3c324c0a91ce61348ebb002a",
"_score": null,
"_source": {
"id": "ea8d0dca3c324c0a91ce61348ebb002a",
"autoIncrement": 4061.0
},
"fields": {
"displayGroup": [
"c236fe2c530ce5cc90d817b7a6af3201"
]
},
"sort": [
2021.0,
"ea8d0dca3c324c0a91ce61348ebb002a"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "720e608ffdc14907827080661e231ba6",
"_score": null,
"_source": {
"id": "720e608ffdc14907827080661e231ba6",
"autoIncrement": 3628.0
},
"fields": {
"displayGroup": [
"339a09df59414b7a3ea661ddaddb09d1"
]
},
"sort": [
2020.0,
"720e608ffdc14907827080661e231ba6"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "8ef843b7136945de9034bdfe838cf0d8",
"_score": null,
"_source": {
"id": "8ef843b7136945de9034bdfe838cf0d8",
"autoIncrement": 452.0
},
"fields": {
"displayGroup": [
"308b3a95068c929e0c6e20747346cbb1"
]
},
"sort": [
2019.0,
"8ef843b7136945de9034bdfe838cf0d8"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "dfe255126226481f82d24f3952d143b4",
"_score": null,
"_source": {
"id": "dfe255126226481f82d24f3952d143b4",
"autoIncrement": 3315.0
},
"fields": {
"displayGroup": [
"38fb8fca08cacad3744d3c03d90832a9"
]
},
"sort": [
2018.0,
"dfe255126226481f82d24f3952d143b4"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "9d62112d3bb14a4f8739432d9a710058",
"_score": null,
"_source": {
"id": "9d62112d3bb14a4f8739432d9a710058",
"autoIncrement": 575.0
},
"fields": {
"displayGroup": [
"eafeb58f6a54fdcc5b4a724974ebc07b"
]
},
"sort": [
2017.0,
"9d62112d3bb14a4f8739432d9a710058"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "48529bbc202f4d25ad9c8ca55eefc696",
"_score": null,
"_source": {
"id": "48529bbc202f4d25ad9c8ca55eefc696",
"autoIncrement": 961.0
},
"fields": {
"displayGroup": [
"635785b453e454f01de05bb08c2cd2a8"
]
},
"sort": [
2016.0,
"48529bbc202f4d25ad9c8ca55eefc696"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "555f5ac90c5c482fadc1f0f96f3f02d2",
"_score": null,
"_source": {
"id": "555f5ac90c5c482fadc1f0f96f3f02d2",
"autoIncrement": 3447.0
},
"fields": {
"displayGroup": [
"0cba32d2496565b6f407c8c5010cf922"
]
},
"sort": [
2015.0,
"555f5ac90c5c482fadc1f0f96f3f02d2"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "468b424cd35a4a6facd0602f38255f2b",
"_score": null,
"_source": {
"id": "468b424cd35a4a6facd0602f38255f2b",
"autoIncrement": 570.0
},
"fields": {
"displayGroup": [
"cdb9f72efa9127ba38705f088c81d7bf"
]
},
"sort": [
2014.0,
"468b424cd35a4a6facd0602f38255f2b"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "c9231919da2649d2ad082547d14179f3",
"_score": null,
"_source": {
"id": "c9231919da2649d2ad082547d14179f3",
"autoIncrement": 3446.0
},
"fields": {
"displayGroup": [
"cc36c572727f1395fc15598c508036f7"
]
},
"sort": [
2013.0,
"c9231919da2649d2ad082547d14179f3"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "019706dca9e9469c9312f9c7ddb82968",
"_score": null,
"_source": {
"id": "019706dca9e9469c9312f9c7ddb82968",
"autoIncrement": 2952.0
},
"fields": {
"displayGroup": [
"e4933fb819730a2602dcb68abaec826e"
]
},
"sort": [
2012.0,
"019706dca9e9469c9312f9c7ddb82968"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "e4c75c31c4684a04aa64f54ea1ab9eb4",
"_score": null,
"_source": {
"id": "e4c75c31c4684a04aa64f54ea1ab9eb4",
"autoIncrement": 566.0
},
"fields": {
"displayGroup": [
"6a31c94c07cef5ecb47b93285ca87e56"
]
},
"sort": [
2011.0,
"e4c75c31c4684a04aa64f54ea1ab9eb4"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "90a28d83e67648feb674e5fecb071851",
"_score": null,
"_source": {
"id": "90a28d83e67648feb674e5fecb071851",
"autoIncrement": 2951.0
},
"fields": {
"displayGroup": [
"0c8d47412d172af6b6df828d74389750"
]
},
"sort": [
2010.0,
"90a28d83e67648feb674e5fecb071851"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "801037e762e841538138f66398a51811",
"_score": null,
"_source": {
"id": "801037e762e841538138f66398a51811",
"autoIncrement": 2950.0
},
"fields": {
"displayGroup": [
"194afb1756b331175fbab69c3af94669"
]
},
"sort": [
2009.0,
"801037e762e841538138f66398a51811"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "e7090489e1984ef0b9739f05631bedca",
"_score": null,
"_source": {
"id": "e7090489e1984ef0b9739f05631bedca",
"autoIncrement": 3495.0
},
"fields": {
"displayGroup": [
"3d1294fe3fd9fa7184880c75ef128464"
]
},
"sort": [
2004.0,
"e7090489e1984ef0b9739f05631bedca"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "857c68d34e46494c92d612946884a0c7",
"_score": null,
"_source": {
"id": "857c68d34e46494c92d612946884a0c7",
"autoIncrement": 562.0
},
"fields": {
"displayGroup": [
"a043a5898f393e917f63935ff1dff1da"
]
},
"sort": [
2002.0,
"857c68d34e46494c92d612946884a0c7"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "fc3a867f11e54423a4604b32784ee070",
"_score": null,
"_source": {
"id": "fc3a867f11e54423a4604b32784ee070",
"autoIncrement": 759.0
},
"fields": {
"displayGroup": [
"26d8c40024ae1e67632b8d725afb898b"
]
},
"sort": [
2001.0,
"fc3a867f11e54423a4604b32784ee070"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "b035c38db4e1458b9803db9901e5e7ee",
"_score": null,
"_source": {
"id": "b035c38db4e1458b9803db9901e5e7ee",
"autoIncrement": 284.0
},
"fields": {
"displayGroup": [
"e35ebf12da35a61dd0fae09decfdf2da"
]
},
"sort": [
1999.0,
"b035c38db4e1458b9803db9901e5e7ee"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "ad049c62d2a44c7cb5457638d0bca760",
"_score": null,
"_source": {
"id": "ad049c62d2a44c7cb5457638d0bca760",
"autoIncrement": 558.0
},
"fields": {
"displayGroup": [
"b4d5ae3d21b23343695d48bf7d3e9c4e"
]
},
"sort": [
1998.0,
"ad049c62d2a44c7cb5457638d0bca760"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "26daff55c2de45f7af86ca888da026db",
"_score": null,
"_source": {
"id": "26daff55c2de45f7af86ca888da026db",
"autoIncrement": 3604.0
},
"fields": {
"displayGroup": [
"1ca0c48e2e63b4234fa0efd523057a7c"
]
},
"sort": [
1997.0,
"26daff55c2de45f7af86ca888da026db"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "e7acf14e4b6f4ce8a13d53ebe3e52b1d",
"_score": null,
"_source": {
"id": "e7acf14e4b6f4ce8a13d53ebe3e52b1d",
"autoIncrement": 554.0
},
"fields": {
"displayGroup": [
"c2d91df11ee2feba38882e66f60b9467"
]
},
"sort": [
1996.0,
"e7acf14e4b6f4ce8a13d53ebe3e52b1d"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "526c54216d78425caf0266f5b679112a",
"_score": null,
"_source": {
"id": "526c54216d78425caf0266f5b679112a",
"autoIncrement": 550.0
},
"fields": {
"displayGroup": [
"337e6b52a0c8de3d9f549f1007647bb6"
]
},
"sort": [
1994.0,
"526c54216d78425caf0266f5b679112a"
]
}
]
},
"aggregations": {
"total-count": {
"value": 24
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
3.76 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":"c5f41c4d69104dd68417fbd54eab441b"}}}},{"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": 2,
"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": 24,
"rating": {
"value": 0.0
}
},
"properties": {
"doc_count": 323,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "172ee189fdbb4d31be14a9303f27e6a4",
"doc_count": 24
},
{
"key": "18e9e666d2f04e2a8249d61008880c6a",
"doc_count": 24
},
{
"key": "32137ef409784f0da19874d71a951b99",
"doc_count": 24
},
{
"key": "45018ee86cc84c47b8d18583215e11fb",
"doc_count": 24
},
{
"key": "b1db92116aaf46d5a308b7ad5f134d9d",
"doc_count": 24
},
{
"key": "b57d1d0eb833459bbda07a3adca6714c",
"doc_count": 24
},
{
"key": "b8dd631079d34d42b559a3eb42f6cfa6",
"doc_count": 24
},
{
"key": "c00d09ec51844aefa2781fcc00839644",
"doc_count": 24
},
{
"key": "5d7cdee62433436cb5ff14b769ad2b3e",
"doc_count": 23
},
{
"key": "a1d54d16125240208adff050392c244d",
"doc_count": 22
},
{
"key": "d7118af20e9d4a12b7d673116b0dfde8",
"doc_count": 22
},
{
"key": "65b3045fc8714cebaccca4e940bc0d99",
"doc_count": 18
},
{
"key": "6f92af8d0f0a4ae99239c1bd9f68d3d3",
"doc_count": 10
},
{
"key": "5cdbd288cbae489dacdf95378cde60b3",
"doc_count": 6
},
{
"key": "4fe32edc9a664410a0f1c55832be7089",
"doc_count": 2
},
{
"key": "b8db729d7ccf49b08b6e15619a5b290a",
"doc_count": 2
},
{
"key": "018af03e1d7c7c8dabe65059358dbeba",
"doc_count": 1
},
{
"key": "06e4d27eb94d4cc1aca5541219423d71",
"doc_count": 1
},
{
"key": "0ad2db72f8c446a29c956ed6e9f78fb4",
"doc_count": 1
},
{
"key": "19ff354e70aa45dba8fe4f7c2f81db8a",
"doc_count": 1
},
{
"key": "27afa12e8fd1402e8ce3638e19a98d9a",
"doc_count": 1
},
{
"key": "2cfa71698f8846af805a68264beefa3c",
"doc_count": 1
},
{
"key": "3400562b991f464880f318f7cf0b8c4d",
"doc_count": 1
},
{
"key": "5ab38019ed7843e7b3b2218c5a19e933",
"doc_count": 1
},
{
"key": "60f3a33fb6e74ec0b6c83ace74194df5",
"doc_count": 1
},
{
"key": "8a6ac1662b934451b6e3bc6e665c3bea",
"doc_count": 1
},
{
"key": "8dedb3f255ff420ba88ac7fb25b2d50c",
"doc_count": 1
},
{
"key": "93dcea5ec8474de58987a8a26d862a8d",
"doc_count": 1
},
{
"key": "9861fdd7cd7f48188c9ab82dd0c9556a",
"doc_count": 1
},
{
"key": "998c9b372d1a4245a79724d3c6f0289e",
"doc_count": 1
},
{
"key": "9a60f14fa86443ff98d00b82e1578dd0",
"doc_count": 1
},
{
"key": "a22ffb31eeef4dec9f2742125159dc7d",
"doc_count": 1
},
{
"key": "adfd37fa8d88405d8be97bde6b963aef",
"doc_count": 1
},
{
"key": "ae21e9df3c704e44964baa3298dfb679",
"doc_count": 1
},
{
"key": "b81318b1758e42bc8be1559a7f6df0bc",
"doc_count": 1
},
{
"key": "c7cc8a656cf841ca898ab1f1ad507138",
"doc_count": 1
},
{
"key": "ca0798b913784ff9880ac954d5b61825",
"doc_count": 1
},
{
"key": "d203639f7b4541deab3c1d6440258dd4",
"doc_count": 1
},
{
"key": "d87edd2454464161b85302e13bb3d42d",
"doc_count": 1
},
{
"key": "e8800fea53ee4087a0afd683a283ac96",
"doc_count": 1
},
{
"key": "eff689d23e264c44b773885f2a4a39e9",
"doc_count": 1
},
{
"key": "fcebc86ac3954b8092f471d6315e7c61",
"doc_count": 1
}
]
}
},
"price": {
"count": 24,
"min": 0.0,
"max": 1282.07,
"avg": 262.895,
"sum": 6309.48
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "d8b346bb1b3748be8dd00175221de71a",
"doc_count": 24
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|