| 1 |
7.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":"45e66aebd9c444aea2036c25a6053ade"}}}},{"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": 14,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "rosland_product_1712914068",
"_id": "0a168c50077242b285496d8d079024b4",
"_score": null,
"_source": {
"id": "0a168c50077242b285496d8d079024b4",
"autoIncrement": 3532.0
},
"fields": {
"displayGroup": [
"958424219975439f2b43c50a76596b3c"
]
},
"sort": [
2019.0,
"0a168c50077242b285496d8d079024b4"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "18e5b2a0c0e24ac0a0dcd0599f477b38",
"_score": null,
"_source": {
"id": "18e5b2a0c0e24ac0a0dcd0599f477b38",
"autoIncrement": 1909.0
},
"fields": {
"displayGroup": [
"cb73d1d002db7558514e46e083a891d3"
]
},
"sort": [
2019.0,
"18e5b2a0c0e24ac0a0dcd0599f477b38"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "1a7b4582c0a94b958d35f6085154a50a",
"_score": null,
"_source": {
"id": "1a7b4582c0a94b958d35f6085154a50a",
"autoIncrement": 1908.0
},
"fields": {
"displayGroup": [
"52a336d9f6d203b86bd7bb911ac0ac40"
]
},
"sort": [
2019.0,
"1a7b4582c0a94b958d35f6085154a50a"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "1d1429c86e054f1283aa8c758ce4855c",
"_score": null,
"_source": {
"id": "1d1429c86e054f1283aa8c758ce4855c",
"autoIncrement": 3141.0
},
"fields": {
"displayGroup": [
"b83289d0f478c357ee09334d77373a10"
]
},
"sort": [
2019.0,
"1d1429c86e054f1283aa8c758ce4855c"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "1fd382f08ec04beeac25e400f94f562a",
"_score": null,
"_source": {
"id": "1fd382f08ec04beeac25e400f94f562a",
"autoIncrement": 1905.0
},
"fields": {
"displayGroup": [
"318c2d43f6fe5d7225a9b31948487b44"
]
},
"sort": [
2019.0,
"1fd382f08ec04beeac25e400f94f562a"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "32a30ac6ff2543d9b66a58916b0db713",
"_score": null,
"_source": {
"id": "32a30ac6ff2543d9b66a58916b0db713",
"autoIncrement": 3140.0
},
"fields": {
"displayGroup": [
"ba0ab641562ee6f728ca9ee18573b9da"
]
},
"sort": [
2019.0,
"32a30ac6ff2543d9b66a58916b0db713"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "4af6ecd9c7da4592a1c71cb6b1e54a0e",
"_score": null,
"_source": {
"id": "4af6ecd9c7da4592a1c71cb6b1e54a0e",
"autoIncrement": 3142.0
},
"fields": {
"displayGroup": [
"ef6e78ee6cc39fa5cfc1fdaf856703d3"
]
},
"sort": [
2019.0,
"4af6ecd9c7da4592a1c71cb6b1e54a0e"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "4f2ecbb0be814178b1914ce3a40be15c",
"_score": null,
"_source": {
"id": "4f2ecbb0be814178b1914ce3a40be15c",
"autoIncrement": 1906.0
},
"fields": {
"displayGroup": [
"e9cc5944bedcea257e211be7786d1141"
]
},
"sort": [
2019.0,
"4f2ecbb0be814178b1914ce3a40be15c"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "544b4eb007664d76990e2f359ce6bfaf",
"_score": null,
"_source": {
"id": "544b4eb007664d76990e2f359ce6bfaf",
"autoIncrement": 1902.0
},
"fields": {
"displayGroup": [
"c2d55bf61b8d7734ebb7288ac7b99125"
]
},
"sort": [
2019.0,
"544b4eb007664d76990e2f359ce6bfaf"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "5c5bd69e4a5b4353bf23ce6e0ebbd780",
"_score": null,
"_source": {
"id": "5c5bd69e4a5b4353bf23ce6e0ebbd780",
"autoIncrement": 1903.0
},
"fields": {
"displayGroup": [
"340a6fe8cab4207c7bda8072881ec02c"
]
},
"sort": [
2019.0,
"5c5bd69e4a5b4353bf23ce6e0ebbd780"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "7f6763922d51445f918ab93a52649660",
"_score": null,
"_source": {
"id": "7f6763922d51445f918ab93a52649660",
"autoIncrement": 1910.0
},
"fields": {
"displayGroup": [
"c5c7a76c4783c79474f678a1c41567b6"
]
},
"sort": [
2019.0,
"7f6763922d51445f918ab93a52649660"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "8304891b332148faa6eadab97f982ef2",
"_score": null,
"_source": {
"id": "8304891b332148faa6eadab97f982ef2",
"autoIncrement": 2021.0
},
"fields": {
"displayGroup": [
"f1c7e386a0ba8c28d394798c37ec1460"
]
},
"sort": [
2019.0,
"8304891b332148faa6eadab97f982ef2"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "dec78e68a07443c58926c6d2a9f32422",
"_score": null,
"_source": {
"id": "dec78e68a07443c58926c6d2a9f32422",
"autoIncrement": 1907.0
},
"fields": {
"displayGroup": [
"91f07347f27d00d1d471b55664516a6a"
]
},
"sort": [
2019.0,
"dec78e68a07443c58926c6d2a9f32422"
]
},
{
"_index": "rosland_product_1712914068",
"_id": "ef9ac6d2c07e4f03b6b9045ea7e13e57",
"_score": null,
"_source": {
"id": "ef9ac6d2c07e4f03b6b9045ea7e13e57",
"autoIncrement": 1904.0
},
"fields": {
"displayGroup": [
"f37560fc6c48cba8e9e8600d7b601cfa"
]
},
"sort": [
2019.0,
"ef9ac6d2c07e4f03b6b9045ea7e13e57"
]
}
]
},
"aggregations": {
"total-count": {
"value": 14
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
2.74 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":"45e66aebd9c444aea2036c25a6053ade"}}}},{"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": 14,
"rating": {
"value": 0.0
}
},
"properties": {
"doc_count": 230,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "45018ee86cc84c47b8d18583215e11fb",
"doc_count": 14
},
{
"key": "70d623b6cfc0418c841d5717feb365d3",
"doc_count": 14
},
{
"key": "adfd37fa8d88405d8be97bde6b963aef",
"doc_count": 14
},
{
"key": "b1db92116aaf46d5a308b7ad5f134d9d",
"doc_count": 14
},
{
"key": "cec1efc6548f4599930d3a4e6db53689",
"doc_count": 14
},
{
"key": "d3cfb18b53ee4a4486a2f4d64f53934f",
"doc_count": 14
},
{
"key": "de88ad12fea44d74b9c2a1f1edf7ecdf",
"doc_count": 14
},
{
"key": "b81318b1758e42bc8be1559a7f6df0bc",
"doc_count": 8
},
{
"key": "c00d09ec51844aefa2781fcc00839644",
"doc_count": 8
},
{
"key": "004c9f1122be4d3db1dadecc53a44cdf",
"doc_count": 6
},
{
"key": "50bede51bbaa4f4aba7003a45cf998b3",
"doc_count": 6
},
{
"key": "d0c07ddcae6a4425b96e363887660b9f",
"doc_count": 6
},
{
"key": "6f92af8d0f0a4ae99239c1bd9f68d3d3",
"doc_count": 5
},
{
"key": "c82b182269744cecbfea2fc49d9b6766",
"doc_count": 5
},
{
"key": "d3a2f712b61249b2888f1f071396654b",
"doc_count": 5
},
{
"key": "f3addfa0aa8f492b93ef4d41f76ff1fd",
"doc_count": 5
},
{
"key": "256aa072d598469cbe2a99d63859b36e",
"doc_count": 4
},
{
"key": "5ef30141011b40d7863ad6aae9217493",
"doc_count": 4
},
{
"key": "14b9d6582da24b8da3125aa5edaece5f",
"doc_count": 3
},
{
"key": "1f819bce5fc84bcea16f7793e2ad7466",
"doc_count": 3
},
{
"key": "276cdd68b28844569066cf000ab6cb31",
"doc_count": 3
},
{
"key": "54d95eb6d8e6492aa1ffeb60b06040d3",
"doc_count": 3
},
{
"key": "90fa3a7cc950451b91847fc8d1faa77f",
"doc_count": 3
},
{
"key": "d5a5144d153f4755a8ee22bd046c174e",
"doc_count": 3
},
{
"key": "e577924c14df48179d45585b28aacca1",
"doc_count": 3
},
{
"key": "18a60018f5894416a3ba174954b557c8",
"doc_count": 2
},
{
"key": "a9705b0538cb42a3be5018cf5701955d",
"doc_count": 2
},
{
"key": "c057aaf844b84af9a250efc7be0def2c",
"doc_count": 2
},
{
"key": "fb2fc0a14b79451dac8829bfbac80116",
"doc_count": 2
},
{
"key": "1624edcb7cc244f6b75dbc77f844c23d",
"doc_count": 1
},
{
"key": "2ba9657c9c574e9aa85f70814078ad7e",
"doc_count": 1
},
{
"key": "2e4f79e00ecd48dfb1212bfa6adf839f",
"doc_count": 1
},
{
"key": "39556c542db348c6ac22908d604d0d50",
"doc_count": 1
},
{
"key": "3f06559cf4884d74a5afdeae798ab6e9",
"doc_count": 1
},
{
"key": "44f682ab37154ba28ea6c18236159358",
"doc_count": 1
},
{
"key": "4d0caa14da8741f3b3809e6dbda669ab",
"doc_count": 1
},
{
"key": "56a1d6dfb7544a49b5ea6fea8e824484",
"doc_count": 1
},
{
"key": "654db2468a5f44b49b398a893a358d22",
"doc_count": 1
},
{
"key": "79709bed515d4a1593cdc09df948021e",
"doc_count": 1
},
{
"key": "7acdd820ece049b888fbee329af0cd5f",
"doc_count": 1
},
{
"key": "7af1972af00d450889a1a91efaecec7d",
"doc_count": 1
},
{
"key": "7d98a41c504648b59fc8a9046d4545ca",
"doc_count": 1
},
{
"key": "815603eeacfd418fb360ad2e9469c0b1",
"doc_count": 1
},
{
"key": "85007d00dbb3447c90183857550eb42a",
"doc_count": 1
},
{
"key": "8e630823e6b940e88db3ec45984e9c63",
"doc_count": 1
},
{
"key": "91cb201c1fb9490b8ab25f3dc6706db1",
"doc_count": 1
},
{
"key": "94dd585006d04491a0204de65ff0b85e",
"doc_count": 1
},
{
"key": "9f63919f237d4a99826fb4355de59356",
"doc_count": 1
},
{
"key": "ad799a5d08034eb29cc48599b830b580",
"doc_count": 1
},
{
"key": "af4493ae34e84428bc07df5696f8f180",
"doc_count": 1
},
{
"key": "afa4b03acf7d4b77bcff4718f8bd30bc",
"doc_count": 1
},
{
"key": "b3b5e9838a334178abcab9f217af98e2",
"doc_count": 1
},
{
"key": "b57d1d0eb833459bbda07a3adca6714c",
"doc_count": 1
},
{
"key": "b5f152dffd5d448c8f5701dbe139b710",
"doc_count": 1
},
{
"key": "b6c9b40b7de442d28b2c97790830e1e5",
"doc_count": 1
},
{
"key": "b791b38a3b464e77ba7ac233fc68303f",
"doc_count": 1
},
{
"key": "b8dd631079d34d42b559a3eb42f6cfa6",
"doc_count": 1
},
{
"key": "bb62085cec734c48a25a9f07470cf013",
"doc_count": 1
},
{
"key": "bb69eafb448d471cb8c5644a87579082",
"doc_count": 1
},
{
"key": "bcfd8dff179149088e720a4ff4527e56",
"doc_count": 1
},
{
"key": "bda6fb3980a84a4197e33a8c6e3d90bf",
"doc_count": 1
},
{
"key": "c1d70719badf4382b9dabd1bb5a380bf",
"doc_count": 1
},
{
"key": "d4a351b83deb42719a00ef284e34b4ce",
"doc_count": 1
},
{
"key": "d7fbeb9111714623878116b0e0dda717",
"doc_count": 1
},
{
"key": "dbc9df5e0bfe45c09a795a0a77f597e1",
"doc_count": 1
},
{
"key": "dfd75a4a228b42acaeab2188dfd4e878",
"doc_count": 1
},
{
"key": "e619b0c9f2f445fe92f6ac929f92d286",
"doc_count": 1
},
{
"key": "e88bf62d26854292b8c9b23202472dc6",
"doc_count": 1
},
{
"key": "eac8c8144d2e468883704735d116f85f",
"doc_count": 1
},
{
"key": "ed25d0f13c934600bbc33b8db2b7962d",
"doc_count": 1
}
]
}
},
"price": {
"count": 14,
"min": 0.0,
"max": 5431.38,
"avg": 653.1821428571428,
"sum": 9144.55
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "0c6346a583ce4d0c93a8911b89371b9a",
"doc_count": 14
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|