| 1 |
19.91 ms |
Request:
{"index":"sw_all4team_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":"a4d331012b00410ab817a4dd8c7bc7f0"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"0189976c1d5a71f1b10cfa55136e2d45"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"sort":[{"sales":{"order":"DESC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":16,"collapse":{"field":"displayGroup"},"timeout":"5s"}}
{
"took": 7,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 21,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_all4team_product_1716336301",
"_id": "018cb27e35207153913b81c9b430212c",
"_score": null,
"_source": {
"autoIncrement": 1211280.0,
"id": "018cb27e35207153913b81c9b430212c"
},
"fields": {
"displayGroup": [
"ec89ee3b274a3dd0a77b1cf34b90376a"
]
},
"sort": [
0,
"018cb27e35207153913b81c9b430212c"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018cb27e885370b09437d68dc359be02",
"_score": null,
"_source": {
"autoIncrement": 1211284.0,
"id": "018cb27e885370b09437d68dc359be02"
},
"fields": {
"displayGroup": [
"45739c5d5b5db4fb816e504e42c7de48"
]
},
"sort": [
0,
"018cb27e885370b09437d68dc359be02"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018cb27ead5472559602c661b3dbe5b5",
"_score": null,
"_source": {
"autoIncrement": 1211288.0,
"id": "018cb27ead5472559602c661b3dbe5b5"
},
"fields": {
"displayGroup": [
"c89e957ea01e912619a44be5dde45985"
]
},
"sort": [
0,
"018cb27ead5472559602c661b3dbe5b5"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d177e499c70b2bce1e22945b23b9f",
"_score": null,
"_source": {
"autoIncrement": 1253668.0,
"id": "018d177e499c70b2bce1e22945b23b9f"
},
"fields": {
"displayGroup": [
"6e3b128c95ad070a1d1659d65fdd177f"
]
},
"sort": [
0,
"018d177e499c70b2bce1e22945b23b9f"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d177e53c1715bbc90f69b13201841",
"_score": null,
"_source": {
"autoIncrement": 1253669.0,
"id": "018d177e53c1715bbc90f69b13201841"
},
"fields": {
"displayGroup": [
"c0d70054405a5e925bbfac6a5b665ef5"
]
},
"sort": [
0,
"018d177e53c1715bbc90f69b13201841"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d58947fc372f0bcbdc0bafb4b9c7d",
"_score": null,
"_source": {
"autoIncrement": 1266539.0,
"id": "018d58947fc372f0bcbdc0bafb4b9c7d"
},
"fields": {
"displayGroup": [
"e38f8ea07c56bf242305bd1cc57c376c"
]
},
"sort": [
0,
"018d58947fc372f0bcbdc0bafb4b9c7d"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d5a3dc6b8727a86eb66fcbbe4125a",
"_score": null,
"_source": {
"autoIncrement": 1269255.0,
"id": "018d5a3dc6b8727a86eb66fcbbe4125a"
},
"fields": {
"displayGroup": [
"c817800b22037220cd89f1f493ab8371"
]
},
"sort": [
0,
"018d5a3dc6b8727a86eb66fcbbe4125a"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d5a3dd7ed739abac0ebe00a4d405a",
"_score": null,
"_source": {
"autoIncrement": 1269256.0,
"id": "018d5a3dd7ed739abac0ebe00a4d405a"
},
"fields": {
"displayGroup": [
"5a99c9e0a79e0c9d60e6e6195c8e40dc"
]
},
"sort": [
0,
"018d5a3dd7ed739abac0ebe00a4d405a"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d7d75db49713798400d0b80d2d361",
"_score": null,
"_source": {
"autoIncrement": 1275265.0,
"id": "018d7d75db49713798400d0b80d2d361"
},
"fields": {
"displayGroup": [
"17258e3f73a9d6bb2a3a1e4788969b48"
]
},
"sort": [
0,
"018d7d75db49713798400d0b80d2d361"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d7d75ec7b726ba32987ec250fa345",
"_score": null,
"_source": {
"autoIncrement": 1275266.0,
"id": "018d7d75ec7b726ba32987ec250fa345"
},
"fields": {
"displayGroup": [
"36ee4c9abb2868a31d6f8efb1c1e0717"
]
},
"sort": [
0,
"018d7d75ec7b726ba32987ec250fa345"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d7d782f777089abbdb783b67f2ce3",
"_score": null,
"_source": {
"autoIncrement": 1275292.0,
"id": "018d7d782f777089abbdb783b67f2ce3"
},
"fields": {
"displayGroup": [
"0c0382977b960154b00255dd5f7fd93f"
]
},
"sort": [
0,
"018d7d782f777089abbdb783b67f2ce3"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d7d783913737e925f7d8a5457bc84",
"_score": null,
"_source": {
"autoIncrement": 1275293.0,
"id": "018d7d783913737e925f7d8a5457bc84"
},
"fields": {
"displayGroup": [
"38f810392fdc57f751f70f08a24a7406"
]
},
"sort": [
0,
"018d7d783913737e925f7d8a5457bc84"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d7d78434f7179bd785f3006a34d31",
"_score": null,
"_source": {
"autoIncrement": 1275294.0,
"id": "018d7d78434f7179bd785f3006a34d31"
},
"fields": {
"displayGroup": [
"01d47e34fd7c8992f2e415143e8bc0a1"
]
},
"sort": [
0,
"018d7d78434f7179bd785f3006a34d31"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d7d784dda735ab463dabb0cd9391b",
"_score": null,
"_source": {
"autoIncrement": 1275295.0,
"id": "018d7d784dda735ab463dabb0cd9391b"
},
"fields": {
"displayGroup": [
"f675fd7319a52aedd2d4e68e29fba7e4"
]
},
"sort": [
0,
"018d7d784dda735ab463dabb0cd9391b"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "12d3502681784723849ac0ea7be34882",
"_score": null,
"_source": {
"autoIncrement": 1120954.0,
"id": "12d3502681784723849ac0ea7be34882"
},
"fields": {
"displayGroup": [
"337412a837a4e43bc787755f7b7bb79e"
]
},
"sort": [
0,
"12d3502681784723849ac0ea7be34882"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "1d25408672c0458099f6f0f8d6ef3c11",
"_score": null,
"_source": {
"autoIncrement": 1120830.0,
"id": "1d25408672c0458099f6f0f8d6ef3c11"
},
"fields": {
"displayGroup": [
"4f39d3610d58ca87fea78c59e6530389"
]
},
"sort": [
0,
"1d25408672c0458099f6f0f8d6ef3c11"
]
}
]
},
"aggregations": {
"total-count": {
"value": 21
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
12.71 ms |
Request:
{"index":"sw_all4team_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":"a4d331012b00410ab817a4dd8c7bc7f0"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"0189976c1d5a71f1b10cfa55136e2d45"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"aggregations":{"manufacturer":{"terms":{"field":"manufacturerId","size":10000}},"price":{"stats":{"script":{"id":"cheapest_price","params":{"accessors":[{"key":"cheapest_price_rule1eac567d7d314563bfa3305e2e8446bb_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule9628985660b5415c9ee8f65bade111bf_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruleeb63558ebb734bde8518103eff3442cf_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule8444b9bcc809444aa5a3fe1f3260a9cc_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule43a89e1a4b454d078913ef45f83aafdf_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule6e3190c99cf44a80a3b9407e5e813c45_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": 10,
"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": 21,
"rating": {
"value": 0.0
}
},
"price": {
"count": 21,
"min": 2.39,
"max": 175.99,
"avg": 27.90047619047619,
"sum": 585.91
},
"options": {
"doc_count": 42,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "eb72ee1138594bdd96373a5ec3f2b7fc",
"doc_count": 19
},
{
"key": "018c6903420a714eab5e5bcf8af20a5d",
"doc_count": 8
},
{
"key": "e2a245dc2c274bb8ae13b0e51076c585",
"doc_count": 3
},
{
"key": "018c6903502670a29b01dc2855133192",
"doc_count": 1
},
{
"key": "018c6904a60a71d58e25430d71ee064a",
"doc_count": 1
},
{
"key": "018c7c7fb7287287a26de06ef11ebe7a",
"doc_count": 1
},
{
"key": "018c7c7fba27731eb9df1e269e5e3fb7",
"doc_count": 1
},
{
"key": "018c7c7fc5917348bed1e0df42bbfe65",
"doc_count": 1
},
{
"key": "42b6455aa6234561acf32e1057c0d4aa",
"doc_count": 1
},
{
"key": "4a1ef1250e6c4a7ca28b4bce6d2d4bac",
"doc_count": 1
},
{
"key": "63eac26e6a124098a9e8e806d4f07fa9",
"doc_count": 1
},
{
"key": "99e0a1d01c2140979597380ec8880523",
"doc_count": 1
},
{
"key": "9b5ec8232a464c748c4e0c6111fe1409",
"doc_count": 1
},
{
"key": "9c7dc5166e9e46c0b9c8781e3903633d",
"doc_count": 1
},
{
"key": "eaf3d78444df46cebde72098473852c6",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 91,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "018963e5f53b7292b003bf6803f624b7",
"doc_count": 21
},
{
"key": "01896411e78a73399a29ed714246da0d",
"doc_count": 19
},
{
"key": "018963ea3aba7042895b047285c1402e",
"doc_count": 11
},
{
"key": "0189641327a072358848ca374bdb7b80",
"doc_count": 8
},
{
"key": "0189641249fb71b6a1d4b85a8ab150e0",
"doc_count": 7
},
{
"key": "018bbe13bff4727baa40d87b9df82a76",
"doc_count": 5
},
{
"key": "018963ea3c15725ea04f1c0eefbb7695",
"doc_count": 4
},
{
"key": "018f05be37cd7285b2099052f9fe2ba4",
"doc_count": 3
},
{
"key": "018964129eff70209b17de692fd8aaf2",
"doc_count": 2
},
{
"key": "018963ea1589737c8cb1cd885a81b6a9",
"doc_count": 1
},
{
"key": "018963ea1d6c71acbf31cf9cb9d7b642",
"doc_count": 1
},
{
"key": "018963ea220370f6b3962a1108942bae",
"doc_count": 1
},
{
"key": "018963ea3964707fbbfb35b2b8e8084b",
"doc_count": 1
},
{
"key": "018963ea415c7217b4dc8cb62572ed16",
"doc_count": 1
},
{
"key": "01896411ea347043b0788892761b1dff",
"doc_count": 1
},
{
"key": "01896412e46d730c90db9993d61f6179",
"doc_count": 1
},
{
"key": "01896413258f73f4b2ef3796cdd67ebb",
"doc_count": 1
},
{
"key": "018c1b62a69a73eeb1dad7620a5dd05d",
"doc_count": 1
},
{
"key": "018c8bce2f8f73bf8105fd34c5b8fd46",
"doc_count": 1
},
{
"key": "018dcc3373f47133833772ee8dfc3fe4",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "0eb8635d02c643c2b1d22ea1631c0c90",
"doc_count": 7
},
{
"key": "69126f5efcab45738b242009148aca51",
"doc_count": 6
},
{
"key": "018c7c9a616c7007bb7960ba88e59312",
"doc_count": 5
},
{
"key": "018c7c9a622870078a62e47c70408932",
"doc_count": 1
},
{
"key": "1a0ffc50b3584a1abd28c2d06d6c6465",
"doc_count": 1
},
{
"key": "d8ac016c293145ff9d20f96184a4ad02",
"doc_count": 1
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|