| 1 |
418.28 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":"0189984afd9372a7af8a9b56b6e20ec9"}}}},{"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": 415,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 41,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_all4team_product_1716336301",
"_id": "018cdc64cf56715fba3123c6cace7826",
"_score": null,
"_source": {
"autoIncrement": 1230339.0,
"id": "018cdc64cf56715fba3123c6cace7826"
},
"fields": {
"displayGroup": [
"e4d5141a7742f149ce1cb67d1ca1665a"
]
},
"sort": [
0,
"018cdc64cf56715fba3123c6cace7826"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0193c12d7dd6726ea68fb759b6932a14",
"_score": null,
"_source": {
"autoIncrement": 1883527.0,
"id": "0193c12d7dd6726ea68fb759b6932a14"
},
"fields": {
"displayGroup": [
"ae2b6c6ee228b5928551540cea16e855"
]
},
"sort": [
0,
"0193c12d7dd6726ea68fb759b6932a14"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0198893e92f673f893cf508104febd9d",
"_score": null,
"_source": {
"autoIncrement": 1931228.0,
"id": "0198893e92f673f893cf508104febd9d"
},
"fields": {
"displayGroup": [
"ab3465c4349dcadfc2d49575e4b4ba4c"
]
},
"sort": [
0,
"0198893e92f673f893cf508104febd9d"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0198893ec5067254a6bd323e24d8ec4b",
"_score": null,
"_source": {
"autoIncrement": 1931232.0,
"id": "0198893ec5067254a6bd323e24d8ec4b"
},
"fields": {
"displayGroup": [
"26d3401a04706f499e16e7c992cae2ae"
]
},
"sort": [
0,
"0198893ec5067254a6bd323e24d8ec4b"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0198893f045670fc9ec8c3bf48081ba6",
"_score": null,
"_source": {
"autoIncrement": 1931236.0,
"id": "0198893f045670fc9ec8c3bf48081ba6"
},
"fields": {
"displayGroup": [
"e1a40f17b8e9cd310109a72dc8ace73d"
]
},
"sort": [
0,
"0198893f045670fc9ec8c3bf48081ba6"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0198893f4834727c8de26be51e9f7df2",
"_score": null,
"_source": {
"autoIncrement": 1931240.0,
"id": "0198893f4834727c8de26be51e9f7df2"
},
"fields": {
"displayGroup": [
"5e6303557b1c025d62ff78d5ba00a6ca"
]
},
"sort": [
0,
"0198893f4834727c8de26be51e9f7df2"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0198893f7a2d7314835f87120d937d86",
"_score": null,
"_source": {
"autoIncrement": 1931244.0,
"id": "0198893f7a2d7314835f87120d937d86"
},
"fields": {
"displayGroup": [
"aeec8beb1c157093b2798c24179ef269"
]
},
"sort": [
0,
"0198893f7a2d7314835f87120d937d86"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0198893fb8ce71a2b9a78b9dd8a19708",
"_score": null,
"_source": {
"autoIncrement": 1931248.0,
"id": "0198893fb8ce71a2b9a78b9dd8a19708"
},
"fields": {
"displayGroup": [
"2a7637c79f24d8a0ac447333f5e23135"
]
},
"sort": [
0,
"0198893fb8ce71a2b9a78b9dd8a19708"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01988a8b756170bd81c2432fc278a2fa",
"_score": null,
"_source": {
"autoIncrement": 1935358.0,
"id": "01988a8b756170bd81c2432fc278a2fa"
},
"fields": {
"displayGroup": [
"f8a104006d4494e7a4c3720347bfe175"
]
},
"sort": [
0,
"01988a8b756170bd81c2432fc278a2fa"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01988a8c05c271f2947e4f819e99b343",
"_score": null,
"_source": {
"autoIncrement": 1935366.0,
"id": "01988a8c05c271f2947e4f819e99b343"
},
"fields": {
"displayGroup": [
"38a877c8d10da7aaf7eea41b8f294e57"
]
},
"sort": [
0,
"01988a8c05c271f2947e4f819e99b343"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01988a8c232672f6a1ade8e785f7b991",
"_score": null,
"_source": {
"autoIncrement": 1935367.0,
"id": "01988a8c232672f6a1ade8e785f7b991"
},
"fields": {
"displayGroup": [
"106c62809eed628e04991a73dc2e0eac"
]
},
"sort": [
0,
"01988a8c232672f6a1ade8e785f7b991"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01988a8c3a6873b1b4b298771e924c2a",
"_score": null,
"_source": {
"autoIncrement": 1935368.0,
"id": "01988a8c3a6873b1b4b298771e924c2a"
},
"fields": {
"displayGroup": [
"1faba972faff3acaa77bb057be239ce5"
]
},
"sort": [
0,
"01988a8c3a6873b1b4b298771e924c2a"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01988a8c4d4f7217b4057b7a9c4e7dad",
"_score": null,
"_source": {
"autoIncrement": 1935369.0,
"id": "01988a8c4d4f7217b4057b7a9c4e7dad"
},
"fields": {
"displayGroup": [
"783a311dee7e977f2bf3786814ad220b"
]
},
"sort": [
0,
"01988a8c4d4f7217b4057b7a9c4e7dad"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "068a6786fd5f4420ae7dbbea92ec3022",
"_score": null,
"_source": {
"autoIncrement": 1098091.0,
"id": "068a6786fd5f4420ae7dbbea92ec3022"
},
"fields": {
"displayGroup": [
"a61d1d478b509ed2430f3031fa9f106a"
]
},
"sort": [
0,
"068a6786fd5f4420ae7dbbea92ec3022"
]
}
]
},
"aggregations": {
"total-count": {
"value": 14
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
24.34 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":"0189984afd9372a7af8a9b56b6e20ec9"}}}},{"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_rulef56aa66553b04105839b38b9288ce3ed_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": 17,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"max_score": null,
"hits": []
},
"aggregations": {
"shipping-free-filter": {
"doc_count": 11,
"shipping-free": {
"value": 1.0,
"value_as_string": "true"
}
},
"rating-exists": {
"doc_count": 41,
"rating": {
"value": 0.0
}
},
"price": {
"count": 41,
"min": 29.66,
"max": 37.95,
"avg": 32.559024390243906,
"sum": 1334.92
},
"options": {
"doc_count": 72,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "507f2e527d524e359c477d74d4605b1f",
"doc_count": 13
},
{
"key": "05e6c6d1ab25436da9792bf6ff072c86",
"doc_count": 6
},
{
"key": "2106319a53ff44bdbcbc1e6ee3df562c",
"doc_count": 6
},
{
"key": "5e2f46d53cb046f9a5f9736c372966f8",
"doc_count": 6
},
{
"key": "6130d6ee64bb4e2cbba659d921bef11b",
"doc_count": 6
},
{
"key": "c6fd2d3a94264d96a0835ef32f02c21b",
"doc_count": 6
},
{
"key": "20db184c1fdb49508a4ccd08b882a19f",
"doc_count": 5
},
{
"key": "37347e78acc44de0a2b07896ba5339c0",
"doc_count": 4
},
{
"key": "60de90a916684ef696e8ba9bd8060cbc",
"doc_count": 4
},
{
"key": "df7e791689574717a8edfae609e4e340",
"doc_count": 4
},
{
"key": "8010798477bb48a2894cb3b08b41a2e1",
"doc_count": 3
},
{
"key": "019884b0c5b8739581eb596ee3b91e2a",
"doc_count": 1
},
{
"key": "019884b0ca5e73ed851262b85ba33bac",
"doc_count": 1
},
{
"key": "019884b0d1cc719086995a0366aa5508",
"doc_count": 1
},
{
"key": "019884b0e2cf72388fcb70ce6ccab3f9",
"doc_count": 1
},
{
"key": "019884b0e602727e987ef7de99b608bd",
"doc_count": 1
},
{
"key": "019884b0ec6e704a8799be8e73cd09d1",
"doc_count": 1
},
{
"key": "7303e67aef5342d78da48b362e94c9fd",
"doc_count": 1
},
{
"key": "987a11805dec4a0e86ea308b5dddd6c4",
"doc_count": 1
},
{
"key": "cfb5694a62a64f0dbf5ff8df39129fe6",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 182,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "018963e5f32b703288aad57690802852",
"doc_count": 38
},
{
"key": "01896412f86d70b28ec76f2ba82e8329",
"doc_count": 36
},
{
"key": "01896411e05c71f4af78a5552a40b626",
"doc_count": 14
},
{
"key": "018963e5f53b7292b003bf6803f624b7",
"doc_count": 12
},
{
"key": "01896411e3007292bbf291a9837a8cc8",
"doc_count": 12
},
{
"key": "01896411e78a73399a29ed714246da0d",
"doc_count": 12
},
{
"key": "018963ea1812737fb7f416641565cd24",
"doc_count": 8
},
{
"key": "018963ea3aba7042895b047285c1402e",
"doc_count": 8
},
{
"key": "018963ea415c7217b4dc8cb62572ed16",
"doc_count": 7
},
{
"key": "018963ea1a0071e3b903843432a2818e",
"doc_count": 6
},
{
"key": "018bbe13bff4727baa40d87b9df82a76",
"doc_count": 6
},
{
"key": "018bbe13c1f071a095ab51339e1d02ad",
"doc_count": 6
},
{
"key": "018bbe1476c47169b239563d60e54f70",
"doc_count": 4
},
{
"key": "018963e5f5e173a4afde33792d6fe12f",
"doc_count": 3
},
{
"key": "01896411ea347043b0788892761b1dff",
"doc_count": 3
},
{
"key": "018963ea3964707fbbfb35b2b8e8084b",
"doc_count": 2
},
{
"key": "018bbe13b97a72e79ffb27e38f96bbb2",
"doc_count": 2
},
{
"key": "018963ea20b670278236dc7103bcceb8",
"doc_count": 1
},
{
"key": "018963ea220370f6b3962a1108942bae",
"doc_count": 1
},
{
"key": "018963ea24c172519a11176e570bcae4",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "d8ac016c293145ff9d20f96184a4ad02",
"doc_count": 24
},
{
"key": "1a0ffc50b3584a1abd28c2d06d6c6465",
"doc_count": 17
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|