| 1 |
6.08 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":"d841b9322933480e8bcd6742b7c43581"}}}},{"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": "018d7e9ad86b7061a1e046b96d480226",
"_score": null,
"_source": {
"id": "018d7e9ad86b7061a1e046b96d480226",
"autoIncrement": 4778.0
},
"fields": {
"displayGroup": [
"85626ede6d01acf33864e0e0dc877e9d"
]
},
"sort": [
2023.0,
"018d7e9ad86b7061a1e046b96d480226"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "9754d449aae442628034777f08cb36fe",
"_score": null,
"_source": {
"id": "9754d449aae442628034777f08cb36fe",
"autoIncrement": 4439.0
},
"fields": {
"displayGroup": [
"69394fa651db4adb3d435213732092cb"
]
},
"sort": [
2023.0,
"9754d449aae442628034777f08cb36fe"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "1fbb3ab4c2e94e569a1f519b965961c0",
"_score": null,
"_source": {
"id": "1fbb3ab4c2e94e569a1f519b965961c0",
"autoIncrement": 4370.0
},
"fields": {
"displayGroup": [
"ce91f3fcb5ace0b394b9187ab1e0b17d"
]
},
"sort": [
2022.0,
"1fbb3ab4c2e94e569a1f519b965961c0"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "0ac811e0e75f47c9975a61f4f0ea30f9",
"_score": null,
"_source": {
"id": "0ac811e0e75f47c9975a61f4f0ea30f9",
"autoIncrement": 4058.0
},
"fields": {
"displayGroup": [
"b1e1322a5e702465ea06bd12a46ce246"
]
},
"sort": [
2021.0,
"0ac811e0e75f47c9975a61f4f0ea30f9"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "c943838d089d4372814d4d3d9e710000",
"_score": null,
"_source": {
"id": "c943838d089d4372814d4d3d9e710000",
"autoIncrement": 2768.0
},
"fields": {
"displayGroup": [
"710c0d45a98e79c345e824027efda125"
]
},
"sort": [
2020.0,
"c943838d089d4372814d4d3d9e710000"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "d522fd89351a48a4b768993acc838a4e",
"_score": null,
"_source": {
"id": "d522fd89351a48a4b768993acc838a4e",
"autoIncrement": 453.0
},
"fields": {
"displayGroup": [
"aed18970fd7c312708d1999ae2476aba"
]
},
"sort": [
2019.0,
"d522fd89351a48a4b768993acc838a4e"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "6819f8a5485c469785b9a5d502cb1310",
"_score": null,
"_source": {
"id": "6819f8a5485c469785b9a5d502cb1310",
"autoIncrement": 3734.0
},
"fields": {
"displayGroup": [
"8c355bed344279cd04eb17d9e434b6fa"
]
},
"sort": [
2018.0,
"6819f8a5485c469785b9a5d502cb1310"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "b3f448dabbe44e32a9d01521bbc8c917",
"_score": null,
"_source": {
"id": "b3f448dabbe44e32a9d01521bbc8c917",
"autoIncrement": 576.0
},
"fields": {
"displayGroup": [
"efeb94f21ea17f238593e026d29b1cf2"
]
},
"sort": [
2017.0,
"b3f448dabbe44e32a9d01521bbc8c917"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "cdb5bdf9173340b1ad5b355452a53baa",
"_score": null,
"_source": {
"id": "cdb5bdf9173340b1ad5b355452a53baa",
"autoIncrement": 574.0
},
"fields": {
"displayGroup": [
"e950931f0af6c726edce301a1f42dd53"
]
},
"sort": [
2016.0,
"cdb5bdf9173340b1ad5b355452a53baa"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "51730372b4eb4b59a2dd5f96b77dab20",
"_score": null,
"_source": {
"id": "51730372b4eb4b59a2dd5f96b77dab20",
"autoIncrement": 572.0
},
"fields": {
"displayGroup": [
"c980e77cd6a750b16d06682aaaa94610"
]
},
"sort": [
2015.0,
"51730372b4eb4b59a2dd5f96b77dab20"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "0aaf300742e746f09e77482ede70c960",
"_score": null,
"_source": {
"id": "0aaf300742e746f09e77482ede70c960",
"autoIncrement": 2955.0
},
"fields": {
"displayGroup": [
"f6a5942832c29936720952c7b85bcdd0"
]
},
"sort": [
2014.0,
"0aaf300742e746f09e77482ede70c960"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "16b731312c3f4690b66a0d21f27c06f3",
"_score": null,
"_source": {
"id": "16b731312c3f4690b66a0d21f27c06f3",
"autoIncrement": 2953.0
},
"fields": {
"displayGroup": [
"bdac5632254ecb81b9ffb8b5dee8ef8c"
]
},
"sort": [
2013.0,
"16b731312c3f4690b66a0d21f27c06f3"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "6f1672b4f8984cf788ac5a66628b5ef3",
"_score": null,
"_source": {
"id": "6f1672b4f8984cf788ac5a66628b5ef3",
"autoIncrement": 567.0
},
"fields": {
"displayGroup": [
"4d6c20d00a994779e15a238cbe071224"
]
},
"sort": [
2011.0,
"6f1672b4f8984cf788ac5a66628b5ef3"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "39b282840a23420aa3f182376c938f40",
"_score": null,
"_source": {
"id": "39b282840a23420aa3f182376c938f40",
"autoIncrement": 564.0
},
"fields": {
"displayGroup": [
"0d415903775a32865b16b9f5316126a7"
]
},
"sort": [
2010.0,
"39b282840a23420aa3f182376c938f40"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "0663244c777f4b6b8f82ef0eb6066fe4",
"_score": null,
"_source": {
"id": "0663244c777f4b6b8f82ef0eb6066fe4",
"autoIncrement": 563.0
},
"fields": {
"displayGroup": [
"717a21fa99ca52609306e96227ad4bcf"
]
},
"sort": [
2009.0,
"0663244c777f4b6b8f82ef0eb6066fe4"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "96cb09c196084eef8ed957d48eeb5bbd",
"_score": null,
"_source": {
"id": "96cb09c196084eef8ed957d48eeb5bbd",
"autoIncrement": 561.0
},
"fields": {
"displayGroup": [
"ba83823020115e9dc53eb22a2fc4b466"
]
},
"sort": [
2004.0,
"96cb09c196084eef8ed957d48eeb5bbd"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "4b8d0ea893ec44bea272593b28144bd8",
"_score": null,
"_source": {
"id": "4b8d0ea893ec44bea272593b28144bd8",
"autoIncrement": 761.0
},
"fields": {
"displayGroup": [
"3bc02215b780ee02e990712de424f965"
]
},
"sort": [
2001.0,
"4b8d0ea893ec44bea272593b28144bd8"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "a185b22d154446778346092dfb48c789",
"_score": null,
"_source": {
"id": "a185b22d154446778346092dfb48c789",
"autoIncrement": 963.0
},
"fields": {
"displayGroup": [
"5bc53a017e329ef77d03a74affbf4217"
]
},
"sort": [
2000.0,
"a185b22d154446778346092dfb48c789"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "6949a4cad1d34070b53a0709cd7683c0",
"_score": null,
"_source": {
"id": "6949a4cad1d34070b53a0709cd7683c0",
"autoIncrement": 2947.0
},
"fields": {
"displayGroup": [
"36c312c8cdda620f518059e0d485f0bc"
]
},
"sort": [
1999.0,
"6949a4cad1d34070b53a0709cd7683c0"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "f9e4921ba7f24ef485baa9eb18592b02",
"_score": null,
"_source": {
"id": "f9e4921ba7f24ef485baa9eb18592b02",
"autoIncrement": 559.0
},
"fields": {
"displayGroup": [
"d027f537c345c0dccfd5fcad0bd9f435"
]
},
"sort": [
1998.0,
"f9e4921ba7f24ef485baa9eb18592b02"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "a4467484c09b4ce380f5b2ad59be23ed",
"_score": null,
"_source": {
"id": "a4467484c09b4ce380f5b2ad59be23ed",
"autoIncrement": 556.0
},
"fields": {
"displayGroup": [
"60ab036fad12c2fd20232780ee21bb4d"
]
},
"sort": [
1997.0,
"a4467484c09b4ce380f5b2ad59be23ed"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "2133d1a5ac014e33bb0a24088934f8b8",
"_score": null,
"_source": {
"id": "2133d1a5ac014e33bb0a24088934f8b8",
"autoIncrement": 555.0
},
"fields": {
"displayGroup": [
"269c4af434f8c2f799b6dee71daefbfb"
]
},
"sort": [
1996.0,
"2133d1a5ac014e33bb0a24088934f8b8"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "f7012081738f40268fedf768de81c38b",
"_score": null,
"_source": {
"id": "f7012081738f40268fedf768de81c38b",
"autoIncrement": 552.0
},
"fields": {
"displayGroup": [
"b90df54957d4f08870a33b35c6bf5783"
]
},
"sort": [
1995.0,
"f7012081738f40268fedf768de81c38b"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "924267f0a54b4d9cb756ce98e1b9ddc3",
"_score": null,
"_source": {
"id": "924267f0a54b4d9cb756ce98e1b9ddc3",
"autoIncrement": 549.0
},
"fields": {
"displayGroup": [
"415cf57a67ebd9075accba941ca552d0"
]
},
"sort": [
1993.0,
"924267f0a54b4d9cb756ce98e1b9ddc3"
]
}
]
},
"aggregations": {
"total-count": {
"value": 24
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
3.52 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":"d841b9322933480e8bcd6742b7c43581"}}}},{"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": 339,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "172ee189fdbb4d31be14a9303f27e6a4",
"doc_count": 24
},
{
"key": "18e9e666d2f04e2a8249d61008880c6a",
"doc_count": 24
},
{
"key": "276cdd68b28844569066cf000ab6cb31",
"doc_count": 24
},
{
"key": "32137ef409784f0da19874d71a951b99",
"doc_count": 24
},
{
"key": "45018ee86cc84c47b8d18583215e11fb",
"doc_count": 24
},
{
"key": "b1db92116aaf46d5a308b7ad5f134d9d",
"doc_count": 24
},
{
"key": "c00d09ec51844aefa2781fcc00839644",
"doc_count": 24
},
{
"key": "c057aaf844b84af9a250efc7be0def2c",
"doc_count": 24
},
{
"key": "51faf497db16494a8fec0b1d60e3c843",
"doc_count": 23
},
{
"key": "5d7cdee62433436cb5ff14b769ad2b3e",
"doc_count": 23
},
{
"key": "cbab77cd44dc47278affef9879ee6687",
"doc_count": 23
},
{
"key": "6f92af8d0f0a4ae99239c1bd9f68d3d3",
"doc_count": 21
},
{
"key": "a8b0663ddfda46c69ad94802c4ca880e",
"doc_count": 15
},
{
"key": "56fa14fde3df4ada967696a28fff5794",
"doc_count": 8
},
{
"key": "70d623b6cfc0418c841d5717feb365d3",
"doc_count": 6
},
{
"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": "9270bfdb608f44aba87a8540c8d22a10",
"doc_count": 1
},
{
"key": "93dcea5ec8474de58987a8a26d862a8d",
"doc_count": 1
},
{
"key": "9861fdd7cd7f48188c9ab82dd0c9556a",
"doc_count": 1
},
{
"key": "998c9b372d1a4245a79724d3c6f0289e",
"doc_count": 1
},
{
"key": "9a60f14fa86443ff98d00b82e1578dd0",
"doc_count": 1
},
{
"key": "adac28fc0ee643c1b43adea098dca42c",
"doc_count": 1
},
{
"key": "adfd37fa8d88405d8be97bde6b963aef",
"doc_count": 1
},
{
"key": "b81318b1758e42bc8be1559a7f6df0bc",
"doc_count": 1
},
{
"key": "c7cc8a656cf841ca898ab1f1ad507138",
"doc_count": 1
},
{
"key": "ca0798b913784ff9880ac954d5b61825",
"doc_count": 1
},
{
"key": "cab271930e7e4062a5be7c2bcfcf464d",
"doc_count": 1
},
{
"key": "cc61a08034264c0db3ba4fd0c3cac5e0",
"doc_count": 1
},
{
"key": "d203639f7b4541deab3c1d6440258dd4",
"doc_count": 1
},
{
"key": "d267acfe953a4114966f1b383e01213f",
"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": 350.31,
"avg": 105.185,
"sum": 2524.44
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "d8b346bb1b3748be8dd00175221de71a",
"doc_count": 24
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|