| 1 |
4.66 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":"ff18757c09c14cd1b7d00b351b9c5004"}}}},{"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": 13,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "rosland_product_1712914068",
"_id": "4221cc52a66e426e87c4f2a4bac7aaad",
"_score": null,
"_source": {
"id": "4221cc52a66e426e87c4f2a4bac7aaad",
"autoIncrement": 4269.0
},
"fields": {
"displayGroup": [
"b96ce550bdf3b61d73eddd97fa3b922b"
]
},
"sort": [
2022.0,
"4221cc52a66e426e87c4f2a4bac7aaad"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "0a999c649ee84f07aaa710cf8173f4f4",
"_score": null,
"_source": {
"id": "0a999c649ee84f07aaa710cf8173f4f4",
"autoIncrement": 2389.0
},
"fields": {
"displayGroup": [
"29a0ae1ae3aba347cc4d835ee8a8288e"
]
},
"sort": [
2019.0,
"0a999c649ee84f07aaa710cf8173f4f4"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "46eb8bf774c74bd0ae02b0c56adc2f51",
"_score": null,
"_source": {
"id": "46eb8bf774c74bd0ae02b0c56adc2f51",
"autoIncrement": 929.0
},
"fields": {
"displayGroup": [
"4273e8e11518553aaea3106758ed82b9"
]
},
"sort": [
2019.0,
"46eb8bf774c74bd0ae02b0c56adc2f51"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "4cd7a03805b6490caa7ccdc3a808c88b",
"_score": null,
"_source": {
"id": "4cd7a03805b6490caa7ccdc3a808c88b",
"autoIncrement": 3218.0
},
"fields": {
"displayGroup": [
"0ab7a195a14e481351a70dd84dbbd00c"
]
},
"sort": [
2019.0,
"4cd7a03805b6490caa7ccdc3a808c88b"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "8026eda9221541dbb7d9a16219c21b26",
"_score": null,
"_source": {
"id": "8026eda9221541dbb7d9a16219c21b26",
"autoIncrement": 608.0
},
"fields": {
"displayGroup": [
"bea47c36d6a3303bb45eccbc7ceda7d7"
]
},
"sort": [
2019.0,
"8026eda9221541dbb7d9a16219c21b26"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "8eb73d8c5586461896b816d1ce4c09aa",
"_score": null,
"_source": {
"id": "8eb73d8c5586461896b816d1ce4c09aa",
"autoIncrement": 597.0
},
"fields": {
"displayGroup": [
"115f711c305b0e036b4650db4a5affee"
]
},
"sort": [
2017.0,
"8eb73d8c5586461896b816d1ce4c09aa"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "dabdc530d51f402ab25972019837d452",
"_score": null,
"_source": {
"id": "dabdc530d51f402ab25972019837d452",
"autoIncrement": 930.0
},
"fields": {
"displayGroup": [
"ce02c48cf07bab34ad13f9d6a0702e80"
]
},
"sort": [
2015.0,
"dabdc530d51f402ab25972019837d452"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "8220a77a7e6d469091289733cfbee5ef",
"_score": null,
"_source": {
"id": "8220a77a7e6d469091289733cfbee5ef",
"autoIncrement": 212.0
},
"fields": {
"displayGroup": [
"ae4c096dd658dd8ed585769fc04ab77e"
]
},
"sort": [
2009.0,
"8220a77a7e6d469091289733cfbee5ef"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "d2c94f98a073418e92d1844d1d299c49",
"_score": null,
"_source": {
"id": "d2c94f98a073418e92d1844d1d299c49",
"autoIncrement": 238.0
},
"fields": {
"displayGroup": [
"10e2e43230913ff71a7ec0ed5850836e"
]
},
"sort": [
2008.0,
"d2c94f98a073418e92d1844d1d299c49"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "595208c1369c433da567ccc1e9115b78",
"_score": null,
"_source": {
"id": "595208c1369c433da567ccc1e9115b78",
"autoIncrement": 3364.0
},
"fields": {
"displayGroup": [
"6803da51b952ddb01b83c0b87c434b05"
]
},
"sort": [
2007.0,
"595208c1369c433da567ccc1e9115b78"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "59e67352d9954711a264a60ccbd803ee",
"_score": null,
"_source": {
"id": "59e67352d9954711a264a60ccbd803ee",
"autoIncrement": 578.0
},
"fields": {
"displayGroup": [
"a361be66fb11deddcbe7a42be985a800"
]
},
"sort": [
2007.0,
"59e67352d9954711a264a60ccbd803ee"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "a936cac6ad8148b187297e43bde4461a",
"_score": null,
"_source": {
"id": "a936cac6ad8148b187297e43bde4461a",
"autoIncrement": 251.0
},
"fields": {
"displayGroup": [
"6802545192cef7df5d9a98db67ddd10b"
]
},
"sort": [
1994.0,
"a936cac6ad8148b187297e43bde4461a"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "23c2b5e74337433ea8b35ab616037937",
"_score": null,
"_source": {
"id": "23c2b5e74337433ea8b35ab616037937",
"autoIncrement": 255.0
},
"fields": {
"displayGroup": [
"e0472fcf7fd875d84b1e7e48088ff015"
]
},
"sort": [
1989.0,
"23c2b5e74337433ea8b35ab616037937"
]
}
]
},
"aggregations": {
"total-count": {
"value": 13
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
2.30 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":"ff18757c09c14cd1b7d00b351b9c5004"}}}},{"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": 13,
"rating": {
"value": 0.0
}
},
"properties": {
"doc_count": 226,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "2641f8888eea4fb68d423e97f3399a88",
"doc_count": 13
},
{
"key": "45018ee86cc84c47b8d18583215e11fb",
"doc_count": 13
},
{
"key": "df10d98b0f734d97b772665f9d8e5c4e",
"doc_count": 13
},
{
"key": "5da84ba5d2244bf1be9feadcba813cfd",
"doc_count": 11
},
{
"key": "f3addfa0aa8f492b93ef4d41f76ff1fd",
"doc_count": 11
},
{
"key": "7b0b4005d21e44b096ed3d4b26b4f971",
"doc_count": 9
},
{
"key": "a6ab6bf14e60463b9609c75edbf26193",
"doc_count": 9
},
{
"key": "b1db92116aaf46d5a308b7ad5f134d9d",
"doc_count": 9
},
{
"key": "f31c43715025471199f45ce9f8f03d77",
"doc_count": 9
},
{
"key": "256aa072d598469cbe2a99d63859b36e",
"doc_count": 8
},
{
"key": "50bede51bbaa4f4aba7003a45cf998b3",
"doc_count": 6
},
{
"key": "d0c07ddcae6a4425b96e363887660b9f",
"doc_count": 6
},
{
"key": "004c9f1122be4d3db1dadecc53a44cdf",
"doc_count": 5
},
{
"key": "adfd37fa8d88405d8be97bde6b963aef",
"doc_count": 4
},
{
"key": "0d9c94bf2b884dc4a0eab0e95173ea42",
"doc_count": 3
},
{
"key": "276cdd68b28844569066cf000ab6cb31",
"doc_count": 3
},
{
"key": "27e5bf7420c14d1e82c251f92742efbd",
"doc_count": 3
},
{
"key": "51ebe59299ac4057b371590d933448f3",
"doc_count": 3
},
{
"key": "a8546c1bbd6f4829b47555f51685b62d",
"doc_count": 3
},
{
"key": "b040cc0159d544d7b4d29a65b03e143c",
"doc_count": 3
},
{
"key": "b1fab21e8d1f46deb424703d0e124d9d",
"doc_count": 3
},
{
"key": "c00d09ec51844aefa2781fcc00839644",
"doc_count": 3
},
{
"key": "c0b5f008b4a744d1be32e3d7c1a1004a",
"doc_count": 3
},
{
"key": "da73ead1b1964a929f9369fb17e21c3b",
"doc_count": 3
},
{
"key": "e577924c14df48179d45585b28aacca1",
"doc_count": 3
},
{
"key": "f290de6ae2a340748bad76f3fc85d8a5",
"doc_count": 3
},
{
"key": "242d9eeb033d472695da322d18b95f36",
"doc_count": 2
},
{
"key": "43cb2ad8fbcc481cbd882cd375c90484",
"doc_count": 2
},
{
"key": "56d20f1ad13544208169c0758f16fa89",
"doc_count": 2
},
{
"key": "62caf1e804b64dcc82fbdcb37abe44c5",
"doc_count": 2
},
{
"key": "62d4c20d312d417a976263df5bdf8dc4",
"doc_count": 2
},
{
"key": "70d623b6cfc0418c841d5717feb365d3",
"doc_count": 2
},
{
"key": "9f63919f237d4a99826fb4355de59356",
"doc_count": 2
},
{
"key": "b17e0030883f443eb86e83ea0e398602",
"doc_count": 2
},
{
"key": "bf2d854da22c41e0a79a72de4697db5b",
"doc_count": 2
},
{
"key": "cbab77cd44dc47278affef9879ee6687",
"doc_count": 2
},
{
"key": "ea14bf5deae249608bba53c077e3b678",
"doc_count": 2
},
{
"key": "ea38f806b6b94986a83aad7e6a5d3040",
"doc_count": 2
},
{
"key": "eacf349b35b7494c8bbf7cb92ee7e3d6",
"doc_count": 2
},
{
"key": "ebf2b6a28d4b4ba895892d40c738b122",
"doc_count": 2
},
{
"key": "f2defb0db2d84b1ebfde406b7515654b",
"doc_count": 2
},
{
"key": "ff72a755153044a4bd2a2da464d123b6",
"doc_count": 2
},
{
"key": "07ce79d7e90d4c2f8d49a5da64992b50",
"doc_count": 1
},
{
"key": "0ad2db72f8c446a29c956ed6e9f78fb4",
"doc_count": 1
},
{
"key": "19283a85d9994f6ca2c5c5daa06275e2",
"doc_count": 1
},
{
"key": "1ad091da93a147d8827d88bf82fac8b6",
"doc_count": 1
},
{
"key": "1af482d544b54aecac5af66a28566895",
"doc_count": 1
},
{
"key": "1baebe6a6ef6423f95778600eb89c7f8",
"doc_count": 1
},
{
"key": "2cfa71698f8846af805a68264beefa3c",
"doc_count": 1
},
{
"key": "33b1f52b7b84409bac1c026250a8a05f",
"doc_count": 1
},
{
"key": "3769eba6ea054b828bc9d6a594785c6e",
"doc_count": 1
},
{
"key": "412fad5d763d48ee911d9bfb941f6035",
"doc_count": 1
},
{
"key": "53a9a7a312b94cc69f7d8aba992d287c",
"doc_count": 1
},
{
"key": "5b2854b6c9da458e8bf92359a79545e8",
"doc_count": 1
},
{
"key": "6d9393d5212f408991b5e01da2463513",
"doc_count": 1
},
{
"key": "871c59225fb949df930d053b8d2081da",
"doc_count": 1
},
{
"key": "950074db1e3749c6a39dbce3b25beda3",
"doc_count": 1
},
{
"key": "9a7a1448813a4ffaa106891cec570f2c",
"doc_count": 1
},
{
"key": "ae21e9df3c704e44964baa3298dfb679",
"doc_count": 1
},
{
"key": "b23a0e01be4a4cb08c7be759fee4c2f3",
"doc_count": 1
},
{
"key": "b577174053d2456d8307a6b59d762ca8",
"doc_count": 1
},
{
"key": "b57d1d0eb833459bbda07a3adca6714c",
"doc_count": 1
},
{
"key": "b5c73f0d79784906b1999de292c86507",
"doc_count": 1
},
{
"key": "b984287e3db147ceb624506b60b5294b",
"doc_count": 1
},
{
"key": "bbbeca6e506a4bc1a6b344837517355c",
"doc_count": 1
},
{
"key": "bcfd8dff179149088e720a4ff4527e56",
"doc_count": 1
},
{
"key": "c1d70719badf4382b9dabd1bb5a380bf",
"doc_count": 1
},
{
"key": "c7cc8a656cf841ca898ab1f1ad507138",
"doc_count": 1
},
{
"key": "c9e46345cea0481c911c52e138daf4b5",
"doc_count": 1
},
{
"key": "cb8fb88a45b14b95a3d271d192ff42c8",
"doc_count": 1
},
{
"key": "e2226bd30155466397357ea0a672e50c",
"doc_count": 1
},
{
"key": "e7c738c7b72544ef91970e7293647d75",
"doc_count": 1
},
{
"key": "f95e6b5702664c9b9965b75635a9cc0c",
"doc_count": 1
},
{
"key": "fcebc86ac3954b8092f471d6315e7c61",
"doc_count": 1
}
]
}
},
"price": {
"count": 13,
"min": 0.0,
"max": 2821.45,
"avg": 415.0530769230769,
"sum": 5395.69
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "2a164e08292b491997d23e90d110b622",
"doc_count": 13
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|