| 1 |
3.31 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":"820ffa045f22487a91897759c15ca172"}}}},{"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": 20,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_product_1717666750",
"_id": "018aae9e9f4a73f6914cf736f196b1ff",
"_score": null,
"_source": {
"id": "018aae9e9f4a73f6914cf736f196b1ff",
"autoIncrement": 4594.0
},
"fields": {
"displayGroup": [
"99fde071c90914496019e8467a002183"
]
},
"sort": [
2023.0,
"018aae9e9f4a73f6914cf736f196b1ff"
]
},
{
"_index": "sw_product_1717666750",
"_id": "018aaea1d36b71c28b772911c677523c",
"_score": null,
"_source": {
"id": "018aaea1d36b71c28b772911c677523c",
"autoIncrement": 4595.0
},
"fields": {
"displayGroup": [
"7495b343b826dbf28700255bdceddd6a"
]
},
"sort": [
2023.0,
"018aaea1d36b71c28b772911c677523c"
]
},
{
"_index": "sw_product_1717666750",
"_id": "018aaea40d8c71b2a5253f0b31a81241",
"_score": null,
"_source": {
"id": "018aaea40d8c71b2a5253f0b31a81241",
"autoIncrement": 4596.0
},
"fields": {
"displayGroup": [
"9a21981264d2e28a296e52f9547a4874"
]
},
"sort": [
2023.0,
"018aaea40d8c71b2a5253f0b31a81241"
]
},
{
"_index": "sw_product_1717666750",
"_id": "07e46b17022c4fdca8a761311f9abe5d",
"_score": null,
"_source": {
"id": "07e46b17022c4fdca8a761311f9abe5d",
"autoIncrement": 4368.0
},
"fields": {
"displayGroup": [
"ec6cc93d6e753ce9009bbbb3d940dd54"
]
},
"sort": [
2021.0,
"07e46b17022c4fdca8a761311f9abe5d"
]
},
{
"_index": "sw_product_1717666750",
"_id": "2f9a28576ab840328cfb7e4947ce2725",
"_score": null,
"_source": {
"id": "2f9a28576ab840328cfb7e4947ce2725",
"autoIncrement": 2344.0
},
"fields": {
"displayGroup": [
"b133ed82c531e05afc5ca9981b06ba57"
]
},
"sort": [
2019.0,
"2f9a28576ab840328cfb7e4947ce2725"
]
},
{
"_index": "sw_product_1717666750",
"_id": "7d2d5958dcc54bfa9a9f70b784e674ad",
"_score": null,
"_source": {
"id": "7d2d5958dcc54bfa9a9f70b784e674ad",
"autoIncrement": 3769.0
},
"fields": {
"displayGroup": [
"0a9ea5b932c4f96b0dbe046546c7596d"
]
},
"sort": [
2019.0,
"7d2d5958dcc54bfa9a9f70b784e674ad"
]
},
{
"_index": "sw_product_1717666750",
"_id": "e4edf7f490224ffda3c62f559ca43348",
"_score": null,
"_source": {
"id": "e4edf7f490224ffda3c62f559ca43348",
"autoIncrement": 2345.0
},
"fields": {
"displayGroup": [
"a70cfb32676c28ca01664e218fbb3d84"
]
},
"sort": [
2019.0,
"e4edf7f490224ffda3c62f559ca43348"
]
},
{
"_index": "sw_product_1717666750",
"_id": "2fe6e6964c7f42e9aba496763ff1bf17",
"_score": null,
"_source": {
"id": "2fe6e6964c7f42e9aba496763ff1bf17",
"autoIncrement": 3216.0
},
"fields": {
"displayGroup": [
"3dba640b7ecf2ccd07cb6631339966ef"
]
},
"sort": [
2018.0,
"2fe6e6964c7f42e9aba496763ff1bf17"
]
},
{
"_index": "sw_product_1717666750",
"_id": "f56c1c065c74483b8621d81370809c19",
"_score": null,
"_source": {
"id": "f56c1c065c74483b8621d81370809c19",
"autoIncrement": 3577.0
},
"fields": {
"displayGroup": [
"9db1f9e62d1cdbfb6ef85553cca55cec"
]
},
"sort": [
2018.0,
"f56c1c065c74483b8621d81370809c19"
]
},
{
"_index": "sw_product_1717666750",
"_id": "05fb3c4c3c2f4d06b7a13d2d70ef9c9a",
"_score": null,
"_source": {
"id": "05fb3c4c3c2f4d06b7a13d2d70ef9c9a",
"autoIncrement": 3767.0
},
"fields": {
"displayGroup": [
"ca7da379fe8898c6a7c1b01817df909b"
]
},
"sort": [
2017.0,
"05fb3c4c3c2f4d06b7a13d2d70ef9c9a"
]
},
{
"_index": "sw_product_1717666750",
"_id": "1533b784126841adbb34887db0b80fbd",
"_score": null,
"_source": {
"id": "1533b784126841adbb34887db0b80fbd",
"autoIncrement": 2318.0
},
"fields": {
"displayGroup": [
"98db30ae75673157fbc0285e940c3f39"
]
},
"sort": [
2017.0,
"1533b784126841adbb34887db0b80fbd"
]
},
{
"_index": "sw_product_1717666750",
"_id": "1bbb87f653724b659662b76e245bd260",
"_score": null,
"_source": {
"id": "1bbb87f653724b659662b76e245bd260",
"autoIncrement": 2319.0
},
"fields": {
"displayGroup": [
"658c5d7b1ebf76cd5c15106fdef2f4a8"
]
},
"sort": [
2017.0,
"1bbb87f653724b659662b76e245bd260"
]
},
{
"_index": "sw_product_1717666750",
"_id": "936b4bf0f875433bab8ff8f577b7250a",
"_score": null,
"_source": {
"id": "936b4bf0f875433bab8ff8f577b7250a",
"autoIncrement": 2320.0
},
"fields": {
"displayGroup": [
"05f9965137e96196be2819a5459871ed"
]
},
"sort": [
2017.0,
"936b4bf0f875433bab8ff8f577b7250a"
]
},
{
"_index": "sw_product_1717666750",
"_id": "0190de951f4d7379a5114b52a76d86d3",
"_score": null,
"_source": {
"id": "0190de951f4d7379a5114b52a76d86d3",
"autoIncrement": 4821.0
},
"fields": {
"displayGroup": [
"241cd0fbbcd40af80badbdf9dd6e54ed"
]
},
"sort": [
2015.0,
"0190de951f4d7379a5114b52a76d86d3"
]
},
{
"_index": "sw_product_1717666750",
"_id": "0191f13e29b571b9817f7f751ec6706d",
"_score": null,
"_source": {
"id": "0191f13e29b571b9817f7f751ec6706d",
"autoIncrement": 4849.0
},
"fields": {
"displayGroup": [
"91039f82b3115afbed920ac43f055375"
]
},
"sort": [
2015.0,
"0191f13e29b571b9817f7f751ec6706d"
]
},
{
"_index": "sw_product_1717666750",
"_id": "8b8d296ec5844c15a50c2104a6780d1d",
"_score": null,
"_source": {
"id": "8b8d296ec5844c15a50c2104a6780d1d",
"autoIncrement": 3578.0
},
"fields": {
"displayGroup": [
"619befff980047327ef93d528498abf0"
]
},
"sort": [
2015.0,
"8b8d296ec5844c15a50c2104a6780d1d"
]
},
{
"_index": "sw_product_1717666750",
"_id": "c159f2ae3f87451f8766669f21c54b77",
"_score": null,
"_source": {
"id": "c159f2ae3f87451f8766669f21c54b77",
"autoIncrement": 3768.0
},
"fields": {
"displayGroup": [
"2275fad2ce7b3c13f31251dc58a7b9f6"
]
},
"sort": [
2015.0,
"c159f2ae3f87451f8766669f21c54b77"
]
},
{
"_index": "sw_product_1717666750",
"_id": "3492e4f78d214e8e93225d9141d6f290",
"_score": null,
"_source": {
"id": "3492e4f78d214e8e93225d9141d6f290",
"autoIncrement": 2346.0
},
"fields": {
"displayGroup": [
"0a0613ed518a26d991b67e3a62a7a4ea"
]
},
"sort": [
2009.0,
"3492e4f78d214e8e93225d9141d6f290"
]
},
{
"_index": "sw_product_1717666750",
"_id": "7dbb8829195945d896441d19e7a909b5",
"_score": null,
"_source": {
"id": "7dbb8829195945d896441d19e7a909b5",
"autoIncrement": 2361.0
},
"fields": {
"displayGroup": [
"ba42625d597fcf8320cd73f1c639cef7"
]
},
"sort": [
2009.0,
"7dbb8829195945d896441d19e7a909b5"
]
},
{
"_index": "sw_product_1717666750",
"_id": "ff7a856af75e46a9a4ddd13e4efb17d2",
"_score": null,
"_source": {
"id": "ff7a856af75e46a9a4ddd13e4efb17d2",
"autoIncrement": 3586.0
},
"fields": {
"displayGroup": [
"746888f22db871faf1d17f27b68a9c9f"
]
},
"sort": [
2009.0,
"ff7a856af75e46a9a4ddd13e4efb17d2"
]
}
]
},
"aggregations": {
"total-count": {
"value": 20
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
3.00 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":"820ffa045f22487a91897759c15ca172"}}}},{"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": 20,
"rating": {
"value": 0.0
}
},
"price": {
"count": 20,
"min": 15.0,
"max": 4939.06,
"avg": 1576.7005000000001,
"sum": 31534.010000000002
},
"options": {
"doc_count": 0,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": []
}
},
"properties": {
"doc_count": 347,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "16c63023894f40c29a8d441f052b01fd",
"doc_count": 20
},
{
"key": "45018ee86cc84c47b8d18583215e11fb",
"doc_count": 20
},
{
"key": "70d623b6cfc0418c841d5717feb365d3",
"doc_count": 20
},
{
"key": "9ef2870d13474eb38067352c55470b76",
"doc_count": 20
},
{
"key": "b1db92116aaf46d5a308b7ad5f134d9d",
"doc_count": 20
},
{
"key": "de13eba6d2fc4edc96f91a594e3bb0ba",
"doc_count": 20
},
{
"key": "f8649d96f8c949818be35fecf3c9d73e",
"doc_count": 20
},
{
"key": "256aa072d598469cbe2a99d63859b36e",
"doc_count": 18
},
{
"key": "4f50fa69c4834ae89caf236b403c5a77",
"doc_count": 18
},
{
"key": "ba1ae82c7f89460984bb7c92c505957e",
"doc_count": 18
},
{
"key": "f3addfa0aa8f492b93ef4d41f76ff1fd",
"doc_count": 18
},
{
"key": "f06e9cb8ae034829b52292d1dc937b5f",
"doc_count": 17
},
{
"key": "da73ead1b1964a929f9369fb17e21c3b",
"doc_count": 12
},
{
"key": "3400562b991f464880f318f7cf0b8c4d",
"doc_count": 11
},
{
"key": "50bede51bbaa4f4aba7003a45cf998b3",
"doc_count": 8
},
{
"key": "eacf349b35b7494c8bbf7cb92ee7e3d6",
"doc_count": 8
},
{
"key": "004c9f1122be4d3db1dadecc53a44cdf",
"doc_count": 6
},
{
"key": "b577174053d2456d8307a6b59d762ca8",
"doc_count": 6
},
{
"key": "d0c07ddcae6a4425b96e363887660b9f",
"doc_count": 6
},
{
"key": "e7c738c7b72544ef91970e7293647d75",
"doc_count": 6
},
{
"key": "d4a1739f69934f898d3684dc7882e6e5",
"doc_count": 5
},
{
"key": "0ad2db72f8c446a29c956ed6e9f78fb4",
"doc_count": 4
},
{
"key": "265fb978d54e4f84b437fc47650766e0",
"doc_count": 4
},
{
"key": "950074db1e3749c6a39dbce3b25beda3",
"doc_count": 4
},
{
"key": "fcebc86ac3954b8092f471d6315e7c61",
"doc_count": 4
},
{
"key": "2cfa71698f8846af805a68264beefa3c",
"doc_count": 3
},
{
"key": "8a6ac1662b934451b6e3bc6e665c3bea",
"doc_count": 3
},
{
"key": "adfd37fa8d88405d8be97bde6b963aef",
"doc_count": 3
},
{
"key": "ceda4066832842afb541c39944fe7d18",
"doc_count": 3
},
{
"key": "2502dd7c35f344aba0b2238740ee3157",
"doc_count": 2
},
{
"key": "276cdd68b28844569066cf000ab6cb31",
"doc_count": 2
},
{
"key": "38cb115a96c14b268167fd32c0d70515",
"doc_count": 2
},
{
"key": "4665fd14d872415baeb2e71e59780f94",
"doc_count": 2
},
{
"key": "998c9b372d1a4245a79724d3c6f0289e",
"doc_count": 2
},
{
"key": "c00d09ec51844aefa2781fcc00839644",
"doc_count": 2
},
{
"key": "c057aaf844b84af9a250efc7be0def2c",
"doc_count": 2
},
{
"key": "ef060cd426844b678bc6f4276355d74b",
"doc_count": 2
},
{
"key": "4933a2a13bc04252a63f3ac884a2dcff",
"doc_count": 1
},
{
"key": "4ac2ad05eb1d46e1a22f234fc498f315",
"doc_count": 1
},
{
"key": "5ab38019ed7843e7b3b2218c5a19e933",
"doc_count": 1
},
{
"key": "66c476d2bbdc47419efdc062df3d0a14",
"doc_count": 1
},
{
"key": "9825d86d563447e8bf6cec12d5b341fa",
"doc_count": 1
},
{
"key": "f703073a5a7d4a6aa7e55fa178b454e9",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "0345f5142cf242648058475ab4182b6d",
"doc_count": 20
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|