| 1 |
7.09 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":"cd4603aea3b4429da79f16919388feb5"}}}},{"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": 21,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "rosland_product_1712914068",
"_id": "42e83a298e644571885cdecffa1a902c",
"_score": null,
"_source": {
"id": "42e83a298e644571885cdecffa1a902c",
"autoIncrement": 3652.0
},
"fields": {
"displayGroup": [
"9a041d73fc7c52aee6c67ff5806fb8b3"
]
},
"sort": [
2020.0,
"42e83a298e644571885cdecffa1a902c"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "b74733befe9647d88458eaa5dee1c0b0",
"_score": null,
"_source": {
"id": "b74733befe9647d88458eaa5dee1c0b0",
"autoIncrement": 1852.0
},
"fields": {
"displayGroup": [
"55bbcc15fb2bb40e1e12b1a196d303cc"
]
},
"sort": [
2019.0,
"b74733befe9647d88458eaa5dee1c0b0"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "f2d4091c6ad548669123f0b90b5be586",
"_score": null,
"_source": {
"id": "f2d4091c6ad548669123f0b90b5be586",
"autoIncrement": 1851.0
},
"fields": {
"displayGroup": [
"2cc145c81dd58ffc508e1aac70aa761f"
]
},
"sort": [
2019.0,
"f2d4091c6ad548669123f0b90b5be586"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "4a16b638657e45b98b9764ff30964d69",
"_score": null,
"_source": {
"id": "4a16b638657e45b98b9764ff30964d69",
"autoIncrement": 1854.0
},
"fields": {
"displayGroup": [
"2ab2e043b2acd40e81ab52b773ea98e9"
]
},
"sort": [
2018.0,
"4a16b638657e45b98b9764ff30964d69"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "62f606a1f40a4f2d82f7f57f268601a7",
"_score": null,
"_source": {
"id": "62f606a1f40a4f2d82f7f57f268601a7",
"autoIncrement": 1855.0
},
"fields": {
"displayGroup": [
"088a9c0b9cf97cc71dca942ca2854f02"
]
},
"sort": [
2018.0,
"62f606a1f40a4f2d82f7f57f268601a7"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "eed29de9fdd346249b69d2438591397e",
"_score": null,
"_source": {
"id": "eed29de9fdd346249b69d2438591397e",
"autoIncrement": 1853.0
},
"fields": {
"displayGroup": [
"af69df736c71600aa76ee90974f4cd49"
]
},
"sort": [
2018.0,
"eed29de9fdd346249b69d2438591397e"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "32d6b923da13419c8238b4f57f0b402d",
"_score": null,
"_source": {
"id": "32d6b923da13419c8238b4f57f0b402d",
"autoIncrement": 1859.0
},
"fields": {
"displayGroup": [
"13e432216258c0fcd15acd0c3c020dc3"
]
},
"sort": [
2017.0,
"32d6b923da13419c8238b4f57f0b402d"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "936929fc15ae44728c04df93e0d7a307",
"_score": null,
"_source": {
"id": "936929fc15ae44728c04df93e0d7a307",
"autoIncrement": 1858.0
},
"fields": {
"displayGroup": [
"2ecc34e587a0a391c4fd2ec783a95fcf"
]
},
"sort": [
2017.0,
"936929fc15ae44728c04df93e0d7a307"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "99ebf8d1dbb24f41957b8850cbd10361",
"_score": null,
"_source": {
"id": "99ebf8d1dbb24f41957b8850cbd10361",
"autoIncrement": 1856.0
},
"fields": {
"displayGroup": [
"3505c730d6b27944fbebc99bfade3485"
]
},
"sort": [
2017.0,
"99ebf8d1dbb24f41957b8850cbd10361"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "b21b04398623454d8891b0f98770f468",
"_score": null,
"_source": {
"id": "b21b04398623454d8891b0f98770f468",
"autoIncrement": 1857.0
},
"fields": {
"displayGroup": [
"c58a7dc31b7053540796e66445131a95"
]
},
"sort": [
2017.0,
"b21b04398623454d8891b0f98770f468"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "333e38a95d7e46edb95e0ed0bd5ae42e",
"_score": null,
"_source": {
"id": "333e38a95d7e46edb95e0ed0bd5ae42e",
"autoIncrement": 3137.0
},
"fields": {
"displayGroup": [
"fd7c7c2e4afb0aa475c8233528e000f5"
]
},
"sort": [
2016.0,
"333e38a95d7e46edb95e0ed0bd5ae42e"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "f6093f3e4b0a471ba2bd98b0f8a9f493",
"_score": null,
"_source": {
"id": "f6093f3e4b0a471ba2bd98b0f8a9f493",
"autoIncrement": 1860.0
},
"fields": {
"displayGroup": [
"51191cda8b4d6e3b0f9d89d8e146fd37"
]
},
"sort": [
2016.0,
"f6093f3e4b0a471ba2bd98b0f8a9f493"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "2b2e97b723ab4811987923bc9676df7d",
"_score": null,
"_source": {
"id": "2b2e97b723ab4811987923bc9676df7d",
"autoIncrement": 1861.0
},
"fields": {
"displayGroup": [
"044f2cc904387f07cd219d8664db9dad"
]
},
"sort": [
2015.0,
"2b2e97b723ab4811987923bc9676df7d"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "cb76814e23ac42afa34a2159fadcfab6",
"_score": null,
"_source": {
"id": "cb76814e23ac42afa34a2159fadcfab6",
"autoIncrement": 1862.0
},
"fields": {
"displayGroup": [
"e1bd5c969d6c4b74ba313036cc2924ea"
]
},
"sort": [
2014.0,
"cb76814e23ac42afa34a2159fadcfab6"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "ed0c0f2e6c3c40b38602f4a3ec623e76",
"_score": null,
"_source": {
"id": "ed0c0f2e6c3c40b38602f4a3ec623e76",
"autoIncrement": 1863.0
},
"fields": {
"displayGroup": [
"9417dc7b69955508539af503c1986bf2"
]
},
"sort": [
2013.0,
"ed0c0f2e6c3c40b38602f4a3ec623e76"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "25ceda51b50b414c97fc1bd3d1c30d1f",
"_score": null,
"_source": {
"id": "25ceda51b50b414c97fc1bd3d1c30d1f",
"autoIncrement": 1864.0
},
"fields": {
"displayGroup": [
"0f045a9a92fde36fd84f535fb6267f91"
]
},
"sort": [
2012.0,
"25ceda51b50b414c97fc1bd3d1c30d1f"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "7824a44b763e4da3853089bf844597d7",
"_score": null,
"_source": {
"id": "7824a44b763e4da3853089bf844597d7",
"autoIncrement": 1865.0
},
"fields": {
"displayGroup": [
"345394aa0ec180f4733501979c870c3f"
]
},
"sort": [
2011.0,
"7824a44b763e4da3853089bf844597d7"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "b8baca1c67fd4c15bf54ee5118e80969",
"_score": null,
"_source": {
"id": "b8baca1c67fd4c15bf54ee5118e80969",
"autoIncrement": 1866.0
},
"fields": {
"displayGroup": [
"2e7ada6d79be22927079c9ea67dcff90"
]
},
"sort": [
2010.0,
"b8baca1c67fd4c15bf54ee5118e80969"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "e46101d93b254d938af016ed07cd22a3",
"_score": null,
"_source": {
"id": "e46101d93b254d938af016ed07cd22a3",
"autoIncrement": 1867.0
},
"fields": {
"displayGroup": [
"14f0eb39d2adeafa8ddf823bccaff52e"
]
},
"sort": [
2009.0,
"e46101d93b254d938af016ed07cd22a3"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "bfd12ca1d6524e108714b91539cc93ac",
"_score": null,
"_source": {
"id": "bfd12ca1d6524e108714b91539cc93ac",
"autoIncrement": 1868.0
},
"fields": {
"displayGroup": [
"4438bd967f609efbc68ca71b950c4c54"
]
},
"sort": [
2008.0,
"bfd12ca1d6524e108714b91539cc93ac"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "0d6a761d3d3c4ce29fcf439e013dad31",
"_score": null,
"_source": {
"id": "0d6a761d3d3c4ce29fcf439e013dad31",
"autoIncrement": 1869.0
},
"fields": {
"displayGroup": [
"47da0a94bb7f8d8e5cd6925abd0f80c1"
]
},
"sort": [
2007.0,
"0d6a761d3d3c4ce29fcf439e013dad31"
]
}
]
},
"aggregations": {
"total-count": {
"value": 21
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
2.46 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":"cd4603aea3b4429da79f16919388feb5"}}}},{"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": 21,
"rating": {
"value": 0.0
}
},
"properties": {
"doc_count": 342,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "256aa072d598469cbe2a99d63859b36e",
"doc_count": 21
},
{
"key": "45018ee86cc84c47b8d18583215e11fb",
"doc_count": 21
},
{
"key": "674eeda781014bc7b35fe9b6e2849616",
"doc_count": 21
},
{
"key": "d3cfb18b53ee4a4486a2f4d64f53934f",
"doc_count": 21
},
{
"key": "d7835742aa644750b59473d1d473ccf7",
"doc_count": 21
},
{
"key": "de88ad12fea44d74b9c2a1f1edf7ecdf",
"doc_count": 21
},
{
"key": "e216ce0edfdd40e4af8bbf624a6da3cf",
"doc_count": 21
},
{
"key": "f3addfa0aa8f492b93ef4d41f76ff1fd",
"doc_count": 21
},
{
"key": "65a41468ad0d4198ac8c958ec4cb2fe5",
"doc_count": 20
},
{
"key": "69fe8056639d4444882ef24c2b912ba8",
"doc_count": 18
},
{
"key": "6f92af8d0f0a4ae99239c1bd9f68d3d3",
"doc_count": 18
},
{
"key": "b81318b1758e42bc8be1559a7f6df0bc",
"doc_count": 18
},
{
"key": "c00d09ec51844aefa2781fcc00839644",
"doc_count": 18
},
{
"key": "0c189ea565ab4573a222115adc6b9258",
"doc_count": 15
},
{
"key": "8cf95386ad3f4cbc911c3258b1a3fbde",
"doc_count": 6
},
{
"key": "bb2aca011dc44badab027fb55a1ec97b",
"doc_count": 6
},
{
"key": "0ad2db72f8c446a29c956ed6e9f78fb4",
"doc_count": 4
},
{
"key": "662edda32d054c32b300e6dd23150b4e",
"doc_count": 4
},
{
"key": "004c9f1122be4d3db1dadecc53a44cdf",
"doc_count": 3
},
{
"key": "412fad5d763d48ee911d9bfb941f6035",
"doc_count": 3
},
{
"key": "50bede51bbaa4f4aba7003a45cf998b3",
"doc_count": 3
},
{
"key": "998c9b372d1a4245a79724d3c6f0289e",
"doc_count": 3
},
{
"key": "d0c07ddcae6a4425b96e363887660b9f",
"doc_count": 3
},
{
"key": "f06e9cb8ae034829b52292d1dc937b5f",
"doc_count": 3
},
{
"key": "1af482d544b54aecac5af66a28566895",
"doc_count": 2
},
{
"key": "adfd37fa8d88405d8be97bde6b963aef",
"doc_count": 2
},
{
"key": "d87edd2454464161b85302e13bb3d42d",
"doc_count": 2
},
{
"key": "06e4d27eb94d4cc1aca5541219423d71",
"doc_count": 1
},
{
"key": "19ff354e70aa45dba8fe4f7c2f81db8a",
"doc_count": 1
},
{
"key": "2cfa71698f8846af805a68264beefa3c",
"doc_count": 1
},
{
"key": "2e8c88cbc45c43b3bc4d094ce117e80c",
"doc_count": 1
},
{
"key": "5b2854b6c9da458e8bf92359a79545e8",
"doc_count": 1
},
{
"key": "65798a73c7e44bcdbe0b0f0b53116c84",
"doc_count": 1
},
{
"key": "72bb3fc9cdc442e6a23350e71643dffb",
"doc_count": 1
},
{
"key": "7396f03e1a45438097b1785fb5300376",
"doc_count": 1
},
{
"key": "7e5a62657e3e40c59990f51841f3d391",
"doc_count": 1
},
{
"key": "83796afc9621434e84ed567b38b4410f",
"doc_count": 1
},
{
"key": "922563a4e1994eb9a59198a1f8c08cf1",
"doc_count": 1
},
{
"key": "9a60f14fa86443ff98d00b82e1578dd0",
"doc_count": 1
},
{
"key": "a22ffb31eeef4dec9f2742125159dc7d",
"doc_count": 1
},
{
"key": "a8027ed660074c3eb5e170224fb32842",
"doc_count": 1
},
{
"key": "a8280ec6e21b412d91399b66a98f9a96",
"doc_count": 1
},
{
"key": "bf2d854da22c41e0a79a72de4697db5b",
"doc_count": 1
},
{
"key": "ca0798b913784ff9880ac954d5b61825",
"doc_count": 1
},
{
"key": "cd98952b2fb54a32b65fc4171a12030d",
"doc_count": 1
},
{
"key": "d3fbc919f5ad480d8649590f9a2b45ef",
"doc_count": 1
},
{
"key": "d4a1739f69934f898d3684dc7882e6e5",
"doc_count": 1
},
{
"key": "eff689d23e264c44b773885f2a4a39e9",
"doc_count": 1
},
{
"key": "f353e604ff1648faacc51e26f7914a4d",
"doc_count": 1
},
{
"key": "fcebc86ac3954b8092f471d6315e7c61",
"doc_count": 1
}
]
}
},
"price": {
"count": 21,
"min": 0.0,
"max": 136.46,
"avg": 49.28666666666667,
"sum": 1035.02
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "0c6346a583ce4d0c93a8911b89371b9a",
"doc_count": 21
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|