| 1 |
3.65 ms |
Request:
{"index":"sw_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":"f733e175386a492b842ac909d6b7f7de"}}}},{"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": 18,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_product_1717666750",
"_id": "9f0e3f7df1204c61849deeaf91eebb12",
"_score": null,
"_source": {
"id": "9f0e3f7df1204c61849deeaf91eebb12",
"autoIncrement": 904.0
},
"fields": {
"displayGroup": [
"d5ca4867582ba7d5ae8062eade9dfe18"
]
},
"sort": [
2018.0,
"9f0e3f7df1204c61849deeaf91eebb12"
]
},
{
"_index": "sw_product_1717666750",
"_id": "f284fe8bfb164d4f8d0e1c2ad340bba8",
"_score": null,
"_source": {
"id": "f284fe8bfb164d4f8d0e1c2ad340bba8",
"autoIncrement": 907.0
},
"fields": {
"displayGroup": [
"49659be34c4fea15434fe7dccd4117b5"
]
},
"sort": [
2018.0,
"f284fe8bfb164d4f8d0e1c2ad340bba8"
]
},
{
"_index": "sw_product_1717666750",
"_id": "c565c41b09894f07a450ee621b196382",
"_score": null,
"_source": {
"id": "c565c41b09894f07a450ee621b196382",
"autoIncrement": 903.0
},
"fields": {
"displayGroup": [
"b23be52ccf5040ba95374d382217c09a"
]
},
"sort": [
2017.0,
"c565c41b09894f07a450ee621b196382"
]
},
{
"_index": "sw_product_1717666750",
"_id": "059c1a407b1e495fbf359060b3de3d73",
"_score": null,
"_source": {
"id": "059c1a407b1e495fbf359060b3de3d73",
"autoIncrement": 932.0
},
"fields": {
"displayGroup": [
"9993b093548e4c489d6066ba0d799041"
]
},
"sort": [
2016.0,
"059c1a407b1e495fbf359060b3de3d73"
]
},
{
"_index": "sw_product_1717666750",
"_id": "cd4f372212274c44baf68ee95321c2ef",
"_score": null,
"_source": {
"id": "cd4f372212274c44baf68ee95321c2ef",
"autoIncrement": 1950.0
},
"fields": {
"displayGroup": [
"65d24a97aac47802182a1e8c4bcc85b9"
]
},
"sort": [
2015.0,
"cd4f372212274c44baf68ee95321c2ef"
]
},
{
"_index": "sw_product_1717666750",
"_id": "5c8c45be0ba841dd9b29eb8e3200a661",
"_score": null,
"_source": {
"id": "5c8c45be0ba841dd9b29eb8e3200a661",
"autoIncrement": 906.0
},
"fields": {
"displayGroup": [
"7d644f14bb17057f099a569834ca805e"
]
},
"sort": [
2014.0,
"5c8c45be0ba841dd9b29eb8e3200a661"
]
},
{
"_index": "sw_product_1717666750",
"_id": "652d024102794192a39e9d6b238cc7d3",
"_score": null,
"_source": {
"id": "652d024102794192a39e9d6b238cc7d3",
"autoIncrement": 1962.0
},
"fields": {
"displayGroup": [
"93c9ba0edd0a1ce9842e11f3d9d181c5"
]
},
"sort": [
2013.0,
"652d024102794192a39e9d6b238cc7d3"
]
},
{
"_index": "sw_product_1717666750",
"_id": "84a72f49ae5a46d4b089477fb3ef29f1",
"_score": null,
"_source": {
"id": "84a72f49ae5a46d4b089477fb3ef29f1",
"autoIncrement": 1970.0
},
"fields": {
"displayGroup": [
"c1ece3ecf1283774bb83249ce7275bda"
]
},
"sort": [
2012.0,
"84a72f49ae5a46d4b089477fb3ef29f1"
]
},
{
"_index": "sw_product_1717666750",
"_id": "cf5bd70f43a74c879b94d8010973adb9",
"_score": null,
"_source": {
"id": "cf5bd70f43a74c879b94d8010973adb9",
"autoIncrement": 931.0
},
"fields": {
"displayGroup": [
"922c42f3b5bb764a6bc09a62063e4088"
]
},
"sort": [
2012.0,
"cf5bd70f43a74c879b94d8010973adb9"
]
},
{
"_index": "sw_product_1717666750",
"_id": "4170f44a3b904948bcdc57e5a6338cd5",
"_score": null,
"_source": {
"id": "4170f44a3b904948bcdc57e5a6338cd5",
"autoIncrement": 1979.0
},
"fields": {
"displayGroup": [
"871241f70ab9498519a47d1a9080ee0a"
]
},
"sort": [
2011.0,
"4170f44a3b904948bcdc57e5a6338cd5"
]
},
{
"_index": "sw_product_1717666750",
"_id": "bbdea77e15b04b88839cea87877f2f59",
"_score": null,
"_source": {
"id": "bbdea77e15b04b88839cea87877f2f59",
"autoIncrement": 3161.0
},
"fields": {
"displayGroup": [
"984e3e25a17ce6754225d06984001be6"
]
},
"sort": [
2011.0,
"bbdea77e15b04b88839cea87877f2f59"
]
},
{
"_index": "sw_product_1717666750",
"_id": "6f376408bf814d9685dacfad99b34037",
"_score": null,
"_source": {
"id": "6f376408bf814d9685dacfad99b34037",
"autoIncrement": 1990.0
},
"fields": {
"displayGroup": [
"92b64aeaef77a1c1101403490f38ea75"
]
},
"sort": [
2010.0,
"6f376408bf814d9685dacfad99b34037"
]
},
{
"_index": "sw_product_1717666750",
"_id": "7ba411ed46bd4da6a58595a28dfa9e3b",
"_score": null,
"_source": {
"id": "7ba411ed46bd4da6a58595a28dfa9e3b",
"autoIncrement": 1989.0
},
"fields": {
"displayGroup": [
"9c24a5d1b1ec58c293c273a8124cef6e"
]
},
"sort": [
2010.0,
"7ba411ed46bd4da6a58595a28dfa9e3b"
]
},
{
"_index": "sw_product_1717666750",
"_id": "1e5e52471d0a4ecbbbf82ae8a2b8ddd7",
"_score": null,
"_source": {
"id": "1e5e52471d0a4ecbbbf82ae8a2b8ddd7",
"autoIncrement": 3163.0
},
"fields": {
"displayGroup": [
"148d4f11547c1f59bf895f606052d4d7"
]
},
"sort": [
2009.0,
"1e5e52471d0a4ecbbbf82ae8a2b8ddd7"
]
},
{
"_index": "sw_product_1717666750",
"_id": "a5ff6bc3551444948ef0048432383f0c",
"_score": null,
"_source": {
"id": "a5ff6bc3551444948ef0048432383f0c",
"autoIncrement": 2000.0
},
"fields": {
"displayGroup": [
"1c5a70bb61f3601e4a12e1b2d96f54d6"
]
},
"sort": [
2009.0,
"a5ff6bc3551444948ef0048432383f0c"
]
},
{
"_index": "sw_product_1717666750",
"_id": "28b9d6f1bb454b629b76d8009b11cc6b",
"_score": null,
"_source": {
"id": "28b9d6f1bb454b629b76d8009b11cc6b",
"autoIncrement": 2009.0
},
"fields": {
"displayGroup": [
"92120c39a740e884428fde6f2f7ae37b"
]
},
"sort": [
2008.0,
"28b9d6f1bb454b629b76d8009b11cc6b"
]
},
{
"_index": "sw_product_1717666750",
"_id": "38d664c4e8e04755ab062d5e85afcedc",
"_score": null,
"_source": {
"id": "38d664c4e8e04755ab062d5e85afcedc",
"autoIncrement": 2011.0
},
"fields": {
"displayGroup": [
"05fb87857b7103c191705d6964fd28ad"
]
},
"sort": [
2008.0,
"38d664c4e8e04755ab062d5e85afcedc"
]
},
{
"_index": "sw_product_1717666750",
"_id": "efa5491b7acb4d28a27fa10aeec770ec",
"_score": null,
"_source": {
"id": "efa5491b7acb4d28a27fa10aeec770ec",
"autoIncrement": 2010.0
},
"fields": {
"displayGroup": [
"50f2675abbe92f536685050c662e3a79"
]
},
"sort": [
2008.0,
"efa5491b7acb4d28a27fa10aeec770ec"
]
}
]
},
"aggregations": {
"total-count": {
"value": 18
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
2.93 ms |
Request:
{"index":"sw_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":"f733e175386a492b842ac909d6b7f7de"}}}},{"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": 1,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"max_score": null,
"hits": []
},
"aggregations": {
"shipping-free-filter": {
"doc_count": 0,
"shipping-free": {
"value": null
}
},
"rating-exists": {
"doc_count": 18,
"rating": {
"value": 0.0
}
},
"price": {
"count": 18,
"min": 8.0,
"max": 45.0,
"avg": 24.166666666666668,
"sum": 435.0
},
"options": {
"doc_count": 0,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": []
}
},
"properties": {
"doc_count": 304,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "45018ee86cc84c47b8d18583215e11fb",
"doc_count": 18
},
{
"key": "b1db92116aaf46d5a308b7ad5f134d9d",
"doc_count": 18
},
{
"key": "cec1efc6548f4599930d3a4e6db53689",
"doc_count": 18
},
{
"key": "d3cfb18b53ee4a4486a2f4d64f53934f",
"doc_count": 18
},
{
"key": "de88ad12fea44d74b9c2a1f1edf7ecdf",
"doc_count": 18
},
{
"key": "c00d09ec51844aefa2781fcc00839644",
"doc_count": 15
},
{
"key": "70d623b6cfc0418c841d5717feb365d3",
"doc_count": 12
},
{
"key": "d4a351b83deb42719a00ef284e34b4ce",
"doc_count": 12
},
{
"key": "b81318b1758e42bc8be1559a7f6df0bc",
"doc_count": 11
},
{
"key": "c82b182269744cecbfea2fc49d9b6766",
"doc_count": 8
},
{
"key": "4d0caa14da8741f3b3809e6dbda669ab",
"doc_count": 7
},
{
"key": "256aa072d598469cbe2a99d63859b36e",
"doc_count": 6
},
{
"key": "5ef30141011b40d7863ad6aae9217493",
"doc_count": 6
},
{
"key": "d3a2f712b61249b2888f1f071396654b",
"doc_count": 6
},
{
"key": "da73ead1b1964a929f9369fb17e21c3b",
"doc_count": 6
},
{
"key": "eacf349b35b7494c8bbf7cb92ee7e3d6",
"doc_count": 6
},
{
"key": "f3addfa0aa8f492b93ef4d41f76ff1fd",
"doc_count": 6
},
{
"key": "6f92af8d0f0a4ae99239c1bd9f68d3d3",
"doc_count": 5
},
{
"key": "654db2468a5f44b49b398a893a358d22",
"doc_count": 4
},
{
"key": "69fe8056639d4444882ef24c2b912ba8",
"doc_count": 4
},
{
"key": "7acdd820ece049b888fbee329af0cd5f",
"doc_count": 4
},
{
"key": "b57d1d0eb833459bbda07a3adca6714c",
"doc_count": 4
},
{
"key": "b8dd631079d34d42b559a3eb42f6cfa6",
"doc_count": 4
},
{
"key": "004c9f1122be4d3db1dadecc53a44cdf",
"doc_count": 3
},
{
"key": "14b9d6582da24b8da3125aa5edaece5f",
"doc_count": 3
},
{
"key": "18a60018f5894416a3ba174954b557c8",
"doc_count": 3
},
{
"key": "1f819bce5fc84bcea16f7793e2ad7466",
"doc_count": 3
},
{
"key": "276cdd68b28844569066cf000ab6cb31",
"doc_count": 3
},
{
"key": "54d95eb6d8e6492aa1ffeb60b06040d3",
"doc_count": 3
},
{
"key": "5b2854b6c9da458e8bf92359a79545e8",
"doc_count": 3
},
{
"key": "90fa3a7cc950451b91847fc8d1faa77f",
"doc_count": 3
},
{
"key": "950074db1e3749c6a39dbce3b25beda3",
"doc_count": 3
},
{
"key": "a9705b0538cb42a3be5018cf5701955d",
"doc_count": 3
},
{
"key": "b577174053d2456d8307a6b59d762ca8",
"doc_count": 3
},
{
"key": "c057aaf844b84af9a250efc7be0def2c",
"doc_count": 3
},
{
"key": "d0c07ddcae6a4425b96e363887660b9f",
"doc_count": 3
},
{
"key": "d5a5144d153f4755a8ee22bd046c174e",
"doc_count": 3
},
{
"key": "e577924c14df48179d45585b28aacca1",
"doc_count": 3
},
{
"key": "e7c738c7b72544ef91970e7293647d75",
"doc_count": 3
},
{
"key": "f06e9cb8ae034829b52292d1dc937b5f",
"doc_count": 3
},
{
"key": "2cfa71698f8846af805a68264beefa3c",
"doc_count": 2
},
{
"key": "2e4f79e00ecd48dfb1212bfa6adf839f",
"doc_count": 2
},
{
"key": "7af1972af00d450889a1a91efaecec7d",
"doc_count": 2
},
{
"key": "8e630823e6b940e88db3ec45984e9c63",
"doc_count": 2
},
{
"key": "998c9b372d1a4245a79724d3c6f0289e",
"doc_count": 2
},
{
"key": "9a60f14fa86443ff98d00b82e1578dd0",
"doc_count": 2
},
{
"key": "9f63919f237d4a99826fb4355de59356",
"doc_count": 2
},
{
"key": "a22ffb31eeef4dec9f2742125159dc7d",
"doc_count": 2
},
{
"key": "b9d4346c4fa84a85a5419f545afd43a1",
"doc_count": 2
},
{
"key": "d7fbeb9111714623878116b0e0dda717",
"doc_count": 2
},
{
"key": "eff689d23e264c44b773885f2a4a39e9",
"doc_count": 2
},
{
"key": "06e4d27eb94d4cc1aca5541219423d71",
"doc_count": 1
},
{
"key": "0ad2db72f8c446a29c956ed6e9f78fb4",
"doc_count": 1
},
{
"key": "1624edcb7cc244f6b75dbc77f844c23d",
"doc_count": 1
},
{
"key": "19ff354e70aa45dba8fe4f7c2f81db8a",
"doc_count": 1
},
{
"key": "1a16add4b76e4b21ba291c96bf7fd2bb",
"doc_count": 1
},
{
"key": "3a82720f032a4b0297e35b8c77784fa1",
"doc_count": 1
},
{
"key": "4c9478116c694dfa8c14b7f3c1b7f447",
"doc_count": 1
},
{
"key": "57c1ef3b77c346e3a304f5c96ed59a18",
"doc_count": 1
},
{
"key": "6cdad13c1d0b41dba4cf978cad6f5d13",
"doc_count": 1
},
{
"key": "91cb201c1fb9490b8ab25f3dc6706db1",
"doc_count": 1
},
{
"key": "b67cb460d5e34c3ca7fc83111a1164bb",
"doc_count": 1
},
{
"key": "bdc92572276a41a58217350cb349da30",
"doc_count": 1
},
{
"key": "d87edd2454464161b85302e13bb3d42d",
"doc_count": 1
},
{
"key": "dfd75a4a228b42acaeab2188dfd4e878",
"doc_count": 1
},
{
"key": "fcebc86ac3954b8092f471d6315e7c61",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "0c6346a583ce4d0c93a8911b89371b9a",
"doc_count": 18
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|