| 1 |
4.95 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":"9d0d7cdaf6a4407bad0a14dad330300b"}}}},{"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": 19,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "rosland_product_1712914068",
"_id": "018b3d431434702fa5999a6900b11ea1",
"_score": null,
"_source": {
"id": "018b3d431434702fa5999a6900b11ea1",
"autoIncrement": 4690.0
},
"fields": {
"displayGroup": [
"b67fc195f69946025678457640aa053b"
]
},
"sort": [
2023.0,
"018b3d431434702fa5999a6900b11ea1"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "018b3d82e1e573afacaa81fcc1d64ecd",
"_score": null,
"_source": {
"id": "018b3d82e1e573afacaa81fcc1d64ecd",
"autoIncrement": 4695.0
},
"fields": {
"displayGroup": [
"369c2ce10f8d143586e621063c1047cf"
]
},
"sort": [
2023.0,
"018b3d82e1e573afacaa81fcc1d64ecd"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "5aa91fd67274441cbf0923eebe8fb8f3",
"_score": null,
"_source": {
"id": "5aa91fd67274441cbf0923eebe8fb8f3",
"autoIncrement": 4281.0
},
"fields": {
"displayGroup": [
"b25314b914bc9748f3bf0e34e9b995d0"
]
},
"sort": [
2022.0,
"5aa91fd67274441cbf0923eebe8fb8f3"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "81564f2ac45e486f9f345c4ff7f799e6",
"_score": null,
"_source": {
"id": "81564f2ac45e486f9f345c4ff7f799e6",
"autoIncrement": 4282.0
},
"fields": {
"displayGroup": [
"91d615121f3cf0a762b440d836bab1b3"
]
},
"sort": [
2022.0,
"81564f2ac45e486f9f345c4ff7f799e6"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "97d1aaa411134e59b4eeee4b6dc24173",
"_score": null,
"_source": {
"id": "97d1aaa411134e59b4eeee4b6dc24173",
"autoIncrement": 4280.0
},
"fields": {
"displayGroup": [
"43c379cf9ee6815ddd081fd6669eb0f1"
]
},
"sort": [
2022.0,
"97d1aaa411134e59b4eeee4b6dc24173"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "02c80ec8189d4e089330d734db6260d4",
"_score": null,
"_source": {
"id": "02c80ec8189d4e089330d734db6260d4",
"autoIncrement": 2827.0
},
"fields": {
"displayGroup": [
"f0cf7feec90f62d6dc6d85356402419a"
]
},
"sort": [
2020.0,
"02c80ec8189d4e089330d734db6260d4"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "d2338aec5abe4696871b2a4728e26c08",
"_score": null,
"_source": {
"id": "d2338aec5abe4696871b2a4728e26c08",
"autoIncrement": 715.0
},
"fields": {
"displayGroup": [
"fcb01ab199ec4533070819319a07d047"
]
},
"sort": [
2019.0,
"d2338aec5abe4696871b2a4728e26c08"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "4d1ea6642a5c4213ba311be64c1befe0",
"_score": null,
"_source": {
"id": "4d1ea6642a5c4213ba311be64c1befe0",
"autoIncrement": 278.0
},
"fields": {
"displayGroup": [
"92a38983e0e7b5263228e02ed20c019b"
]
},
"sort": [
2018.0,
"4d1ea6642a5c4213ba311be64c1befe0"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "58deeaf2682048cea7c5bbdb5a7defc1",
"_score": null,
"_source": {
"id": "58deeaf2682048cea7c5bbdb5a7defc1",
"autoIncrement": 256.0
},
"fields": {
"displayGroup": [
"0bb346cf2d043dd5334df0e6e0934ffe"
]
},
"sort": [
2018.0,
"58deeaf2682048cea7c5bbdb5a7defc1"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "3c30adb5629d47b1aadde880c72924e1",
"_score": null,
"_source": {
"id": "3c30adb5629d47b1aadde880c72924e1",
"autoIncrement": 257.0
},
"fields": {
"displayGroup": [
"1e62406242d1ff87f06a21aa6dbac896"
]
},
"sort": [
2017.0,
"3c30adb5629d47b1aadde880c72924e1"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "efc27a20e2e5425882cb0f4fc2814876",
"_score": null,
"_source": {
"id": "efc27a20e2e5425882cb0f4fc2814876",
"autoIncrement": 272.0
},
"fields": {
"displayGroup": [
"e83f30318649d7b6707fdb57dc6665a1"
]
},
"sort": [
2012.0,
"efc27a20e2e5425882cb0f4fc2814876"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "be00b210cc77456d905ca6daa52acf89",
"_score": null,
"_source": {
"id": "be00b210cc77456d905ca6daa52acf89",
"autoIncrement": 4081.0
},
"fields": {
"displayGroup": [
"5fc90d7ccd0eabf4a31454de469d6d2e"
]
},
"sort": [
2011.0,
"be00b210cc77456d905ca6daa52acf89"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "28ac7a4f813947198ab4eca0beb43a79",
"_score": null,
"_source": {
"id": "28ac7a4f813947198ab4eca0beb43a79",
"autoIncrement": 266.0
},
"fields": {
"displayGroup": [
"b187d6b447ecf01b75828ac6f3c0f8d4"
]
},
"sort": [
2006.0,
"28ac7a4f813947198ab4eca0beb43a79"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "e1da487d741646cca6a3af3273ee7b35",
"_score": null,
"_source": {
"id": "e1da487d741646cca6a3af3273ee7b35",
"autoIncrement": 265.0
},
"fields": {
"displayGroup": [
"b8563f69d8093a95ccf96859bfab62c2"
]
},
"sort": [
2006.0,
"e1da487d741646cca6a3af3273ee7b35"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "67ca86c8c1584e5895fa0b591ddb9a8f",
"_score": null,
"_source": {
"id": "67ca86c8c1584e5895fa0b591ddb9a8f",
"autoIncrement": 270.0
},
"fields": {
"displayGroup": [
"e8114a5421f0faf4601cb9de9dde5e46"
]
},
"sort": [
1999.0,
"67ca86c8c1584e5895fa0b591ddb9a8f"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "54ced92d1896439098a5de846a9b0866",
"_score": null,
"_source": {
"id": "54ced92d1896439098a5de846a9b0866",
"autoIncrement": 264.0
},
"fields": {
"displayGroup": [
"2999117a478883ebcde1bd28d5e1e34c"
]
},
"sort": [
1989.0,
"54ced92d1896439098a5de846a9b0866"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "480088a74ed242cc95fa79b700ed1e6e",
"_score": null,
"_source": {
"id": "480088a74ed242cc95fa79b700ed1e6e",
"autoIncrement": 3372.0
},
"fields": {
"displayGroup": [
"d13e8e8f1f542bd20b6e7b72fd90bf62"
]
},
"sort": [
1987.0,
"480088a74ed242cc95fa79b700ed1e6e"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "a43ee658d7814c56aff8fe844f80a6fe",
"_score": null,
"_source": {
"id": "a43ee658d7814c56aff8fe844f80a6fe",
"autoIncrement": 262.0
},
"fields": {
"displayGroup": [
"62fa3e5eede5f00f0ce44a71c1ee00e7"
]
},
"sort": [
1987.0,
"a43ee658d7814c56aff8fe844f80a6fe"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "f9a4b4ffd0f54a86a4eb259fd0568e33",
"_score": null,
"_source": {
"id": "f9a4b4ffd0f54a86a4eb259fd0568e33",
"autoIncrement": 263.0
},
"fields": {
"displayGroup": [
"43d20f1244f38bb240390d997fbc3c41"
]
},
"sort": [
1987.0,
"f9a4b4ffd0f54a86a4eb259fd0568e33"
]
}
]
},
"aggregations": {
"total-count": {
"value": 19
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
4.24 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":"9d0d7cdaf6a4407bad0a14dad330300b"}}}},{"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": 3,
"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": 19,
"rating": {
"value": 0.0
}
},
"properties": {
"doc_count": 288,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "004c9f1122be4d3db1dadecc53a44cdf",
"doc_count": 19
},
{
"key": "13230fbd89994e96b4aea1770a8ce826",
"doc_count": 19
},
{
"key": "1b390b2547f84681a5aaf6b93875c1ef",
"doc_count": 19
},
{
"key": "45018ee86cc84c47b8d18583215e11fb",
"doc_count": 19
},
{
"key": "d0c07ddcae6a4425b96e363887660b9f",
"doc_count": 19
},
{
"key": "d6071c2d7c6a4af885ab399ff929d1dd",
"doc_count": 19
},
{
"key": "b1db92116aaf46d5a308b7ad5f134d9d",
"doc_count": 12
},
{
"key": "50bede51bbaa4f4aba7003a45cf998b3",
"doc_count": 10
},
{
"key": "99544516e0e04f7f9cd839b4d9bc2b91",
"doc_count": 7
},
{
"key": "e577924c14df48179d45585b28aacca1",
"doc_count": 6
},
{
"key": "1af89084374c423fb6d1a5300204fa25",
"doc_count": 5
},
{
"key": "5d7cdee62433436cb5ff14b769ad2b3e",
"doc_count": 5
},
{
"key": "803f661fc69e408faf532169a7bf976b",
"doc_count": 5
},
{
"key": "a9705b0538cb42a3be5018cf5701955d",
"doc_count": 5
},
{
"key": "b52b6f16a76a4aaca05e9d987fb1721b",
"doc_count": 5
},
{
"key": "256aa072d598469cbe2a99d63859b36e",
"doc_count": 4
},
{
"key": "4c19642233cf41b58047a7de6b497f20",
"doc_count": 4
},
{
"key": "5b8f5b04a97b47e2b04efe565e99a70a",
"doc_count": 4
},
{
"key": "5bcdada80ac64d00972779429fa87332",
"doc_count": 4
},
{
"key": "6e8b2e81036642ff93b15ff1520bdc03",
"doc_count": 4
},
{
"key": "97e91b44c63045459a74bf3a7637a658",
"doc_count": 4
},
{
"key": "bf11c7caeab94fb8a1c508ba6d222fed",
"doc_count": 4
},
{
"key": "d9fa2505750f417e81edbcbf558f6959",
"doc_count": 4
},
{
"key": "f38c00d66e7340cf9c07fd64a8c1204b",
"doc_count": 4
},
{
"key": "f3addfa0aa8f492b93ef4d41f76ff1fd",
"doc_count": 4
},
{
"key": "14fd0605339a47ad8436471564c5813d",
"doc_count": 3
},
{
"key": "27dbf2dab398426fb2f3099e28933f81",
"doc_count": 3
},
{
"key": "4fe32edc9a664410a0f1c55832be7089",
"doc_count": 3
},
{
"key": "a826531a01aa4901b180a99a7c11a94f",
"doc_count": 3
},
{
"key": "b57d1d0eb833459bbda07a3adca6714c",
"doc_count": 3
},
{
"key": "b8dd631079d34d42b559a3eb42f6cfa6",
"doc_count": 3
},
{
"key": "c7cc8a656cf841ca898ab1f1ad507138",
"doc_count": 3
},
{
"key": "044cb9f98277482ab756a8fe2f6f9407",
"doc_count": 2
},
{
"key": "276cdd68b28844569066cf000ab6cb31",
"doc_count": 2
},
{
"key": "27e5bf7420c14d1e82c251f92742efbd",
"doc_count": 2
},
{
"key": "2e2fe62342314bad81f59040348e82fa",
"doc_count": 2
},
{
"key": "3a15a1e4e8cb4b08983a8e81003281fe",
"doc_count": 2
},
{
"key": "740639084dcd465aa68eb6e53d386aa3",
"doc_count": 2
},
{
"key": "8a6ac1662b934451b6e3bc6e665c3bea",
"doc_count": 2
},
{
"key": "998c9b372d1a4245a79724d3c6f0289e",
"doc_count": 2
},
{
"key": "b0fd24cfb9784ab4a1236ab5ece09415",
"doc_count": 2
},
{
"key": "b24ee16021be483d93181b79c989c05d",
"doc_count": 2
},
{
"key": "b577174053d2456d8307a6b59d762ca8",
"doc_count": 2
},
{
"key": "b81318b1758e42bc8be1559a7f6df0bc",
"doc_count": 2
},
{
"key": "c057aaf844b84af9a250efc7be0def2c",
"doc_count": 2
},
{
"key": "c1c3a11356ca4688b8ab4d4e7799fe14",
"doc_count": 2
},
{
"key": "e28447ac3684491a9166aa805f6aa2ce",
"doc_count": 2
},
{
"key": "ee2b4d552ab44917a1cdf0bc57889c58",
"doc_count": 2
},
{
"key": "0ad2db72f8c446a29c956ed6e9f78fb4",
"doc_count": 1
},
{
"key": "1285d1a126a342bfa7fc35f5de1d0b93",
"doc_count": 1
},
{
"key": "1baebe6a6ef6423f95778600eb89c7f8",
"doc_count": 1
},
{
"key": "458f436726e54283a627c2bb9cfdf7de",
"doc_count": 1
},
{
"key": "51bed0da96f94ea094216e94132b3f37",
"doc_count": 1
},
{
"key": "5335433309cb49b6a78598777d2ef375",
"doc_count": 1
},
{
"key": "6d9393d5212f408991b5e01da2463513",
"doc_count": 1
},
{
"key": "7eadb3e1245f4fe18b7bf09af1f52c41",
"doc_count": 1
},
{
"key": "9f63f7a9675e490aa0c2ce7eb91381df",
"doc_count": 1
},
{
"key": "a22ffb31eeef4dec9f2742125159dc7d",
"doc_count": 1
},
{
"key": "adfd37fa8d88405d8be97bde6b963aef",
"doc_count": 1
},
{
"key": "bcfd8dff179149088e720a4ff4527e56",
"doc_count": 1
},
{
"key": "c1d70719badf4382b9dabd1bb5a380bf",
"doc_count": 1
},
{
"key": "ca0798b913784ff9880ac954d5b61825",
"doc_count": 1
},
{
"key": "d203639f7b4541deab3c1d6440258dd4",
"doc_count": 1
},
{
"key": "e48741e2462d492ebf269e24872605d0",
"doc_count": 1
},
{
"key": "e7c738c7b72544ef91970e7293647d75",
"doc_count": 1
},
{
"key": "eacf349b35b7494c8bbf7cb92ee7e3d6",
"doc_count": 1
},
{
"key": "efa30880f07644c693e4a1eb51826377",
"doc_count": 1
},
{
"key": "efdf642333864f51973546267f9cd2fa",
"doc_count": 1
},
{
"key": "eff689d23e264c44b773885f2a4a39e9",
"doc_count": 1
}
]
}
},
"price": {
"count": 19,
"min": 0.0,
"max": 2769.11,
"avg": 258.73263157894735,
"sum": 4915.92
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "ff11ff1ee9364e74ac0058d300b888d1",
"doc_count": 19
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|