| 1 |
29.20 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":"0197d8f984e27181814175cac2d72ff6"}}}},{"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": 8,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 89,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_all4team_product_1716336301",
"_id": "01982d80e3e573cf84a13f3bcf233541",
"_score": null,
"_source": {
"autoIncrement": 1929376.0,
"id": "01982d80e3e573cf84a13f3bcf233541"
},
"fields": {
"displayGroup": [
"8610b43999ca4a79b12a94db8ee690bc"
]
},
"sort": [
1,
"01982d80e3e573cf84a13f3bcf233541"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01982d80f621715db875829e6809c1ed",
"_score": null,
"_source": {
"autoIncrement": 1929383.0,
"id": "01982d80f621715db875829e6809c1ed"
},
"fields": {
"displayGroup": [
"37ef96498a103d15aa7c33c1b7c81234"
]
},
"sort": [
1,
"01982d80f621715db875829e6809c1ed"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01982d800804735a8dbf962e87670325",
"_score": null,
"_source": {
"autoIncrement": 1929282.0,
"id": "01982d800804735a8dbf962e87670325"
},
"fields": {
"displayGroup": [
"2d2b780fa42d5e5e5ded314ad6a9bbb6"
]
},
"sort": [
0,
"01982d800804735a8dbf962e87670325"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01982d801a3e72328582d7c04c73c4ac",
"_score": null,
"_source": {
"autoIncrement": 1929289.0,
"id": "01982d801a3e72328582d7c04c73c4ac"
},
"fields": {
"displayGroup": [
"d603aa12e7404ea941ef147f4b4b2525"
]
},
"sort": [
0,
"01982d801a3e72328582d7c04c73c4ac"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01982d8029f67211958c106f49427e8b",
"_score": null,
"_source": {
"autoIncrement": 1929296.0,
"id": "01982d8029f67211958c106f49427e8b"
},
"fields": {
"displayGroup": [
"c048ea43bba3f358c98322a0d4be5f5f"
]
},
"sort": [
0,
"01982d8029f67211958c106f49427e8b"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01982d803bc772709ce3a23095838ff4",
"_score": null,
"_source": {
"autoIncrement": 1929303.0,
"id": "01982d803bc772709ce3a23095838ff4"
},
"fields": {
"displayGroup": [
"0edd771e4df5c6c7171896e5fb630309"
]
},
"sort": [
0,
"01982d803bc772709ce3a23095838ff4"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01982d804a927272b32212fabccddd7d",
"_score": null,
"_source": {
"autoIncrement": 1929310.0,
"id": "01982d804a927272b32212fabccddd7d"
},
"fields": {
"displayGroup": [
"8e9e72bdc8cd3ef74f42a5b9bab7fffe"
]
},
"sort": [
0,
"01982d804a927272b32212fabccddd7d"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01982d805ccf7346b6d58559ac179d86",
"_score": null,
"_source": {
"autoIncrement": 1929317.0,
"id": "01982d805ccf7346b6d58559ac179d86"
},
"fields": {
"displayGroup": [
"1c5c635f2a84ce1c3476f8056890696f"
]
},
"sort": [
0,
"01982d805ccf7346b6d58559ac179d86"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01982d806bbd7241a317c0852b549264",
"_score": null,
"_source": {
"autoIncrement": 1929324.0,
"id": "01982d806bbd7241a317c0852b549264"
},
"fields": {
"displayGroup": [
"bccd1d5d24dfea70ac5056a9fa0ad80f"
]
},
"sort": [
0,
"01982d806bbd7241a317c0852b549264"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01982d807cfe72cf9fbf00872c646d5c",
"_score": null,
"_source": {
"autoIncrement": 1929331.0,
"id": "01982d807cfe72cf9fbf00872c646d5c"
},
"fields": {
"displayGroup": [
"5ab234e796d6d74b17f5b69cd70d2c36"
]
},
"sort": [
0,
"01982d807cfe72cf9fbf00872c646d5c"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01982d808b0771e29569c78b94ed80b7",
"_score": null,
"_source": {
"autoIncrement": 1929338.0,
"id": "01982d808b0771e29569c78b94ed80b7"
},
"fields": {
"displayGroup": [
"e34aa01447f9368cd2bb9a00f73ff547"
]
},
"sort": [
0,
"01982d808b0771e29569c78b94ed80b7"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01982d809c9f70b69cfe7a52f88e78f2",
"_score": null,
"_source": {
"autoIncrement": 1929345.0,
"id": "01982d809c9f70b69cfe7a52f88e78f2"
},
"fields": {
"displayGroup": [
"9d49f8a81d70b3a12601960ae3077c14"
]
},
"sort": [
0,
"01982d809c9f70b69cfe7a52f88e78f2"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01982d80add5726c8e40e44c82df3d56",
"_score": null,
"_source": {
"autoIncrement": 1929351.0,
"id": "01982d80add5726c8e40e44c82df3d56"
},
"fields": {
"displayGroup": [
"8c1d2cad289818b05b6eb9b105629cc5"
]
},
"sort": [
0,
"01982d80add5726c8e40e44c82df3d56"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01982d80bfc37274bdcdec6615dfa9ad",
"_score": null,
"_source": {
"autoIncrement": 1929358.0,
"id": "01982d80bfc37274bdcdec6615dfa9ad"
},
"fields": {
"displayGroup": [
"2e657de0b30b3161f9dc517ade7a70e9"
]
},
"sort": [
0,
"01982d80bfc37274bdcdec6615dfa9ad"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01982d80d17e70aa8b6e41fc0b97c444",
"_score": null,
"_source": {
"autoIncrement": 1929371.0,
"id": "01982d80d17e70aa8b6e41fc0b97c444"
},
"fields": {
"displayGroup": [
"71763428e57485aa449ce0d4445e0d29"
]
},
"sort": [
0,
"01982d80d17e70aa8b6e41fc0b97c444"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01984372890071d1888dd1e5661d4ad3",
"_score": null,
"_source": {
"autoIncrement": 1929693.0,
"id": "01984372890071d1888dd1e5661d4ad3"
},
"fields": {
"displayGroup": [
"5acab20f59c8330b737073dd76034e08"
]
},
"sort": [
0,
"01984372890071d1888dd1e5661d4ad3"
]
}
]
},
"aggregations": {
"total-count": {
"value": 21
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
7.83 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":"0197d8f984e27181814175cac2d72ff6"}}}},{"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": 6,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"max_score": null,
"hits": []
},
"aggregations": {
"shipping-free-filter": {
"doc_count": 89,
"shipping-free": {
"value": 1.0,
"value_as_string": "true"
}
},
"rating-exists": {
"doc_count": 89,
"rating": {
"value": 0.0
}
},
"price": {
"count": 89,
"min": 19.95,
"max": 64.95,
"avg": 41.074044943820226,
"sum": 3655.59
},
"options": {
"doc_count": 166,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "8d8af228e5f24f6780baeae00632d903",
"doc_count": 51
},
{
"key": "6c8c082cdbb54f0b9942c4e01cf26469",
"doc_count": 13
},
{
"key": "489ab7a68fb7402f81f190225fcd412a",
"doc_count": 12
},
{
"key": "103c221ef5c547a6919548726a45adb7",
"doc_count": 9
},
{
"key": "63a3e4e3a8d0461ca937227647cbc474",
"doc_count": 9
},
{
"key": "df41139ab42a4f0dbe2167afb103b833",
"doc_count": 9
},
{
"key": "6818490b3d264af396bf32b5c741cb18",
"doc_count": 8
},
{
"key": "bace55c509624d8ab8a0c4653bced477",
"doc_count": 8
},
{
"key": "f1c0d70c9b714c4cb27beb8f22273242",
"doc_count": 8
},
{
"key": "ceee326838e84e179feac212955baed4",
"doc_count": 6
},
{
"key": "37347e78acc44de0a2b07896ba5339c0",
"doc_count": 5
},
{
"key": "507f2e527d524e359c477d74d4605b1f",
"doc_count": 5
},
{
"key": "5e2f46d53cb046f9a5f9736c372966f8",
"doc_count": 5
},
{
"key": "60de90a916684ef696e8ba9bd8060cbc",
"doc_count": 5
},
{
"key": "df7e791689574717a8edfae609e4e340",
"doc_count": 5
},
{
"key": "20db184c1fdb49508a4ccd08b882a19f",
"doc_count": 4
},
{
"key": "b26bb94349e2469ea3e048b8bd50a91d",
"doc_count": 2
},
{
"key": "2106319a53ff44bdbcbc1e6ee3df562c",
"doc_count": 1
},
{
"key": "d9bf32757e4140179d83b4a2304bfe4a",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 266,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "01896411e3af718192fb7f9ee45ad6fb",
"doc_count": 83
},
{
"key": "018963e5f13871739bde1b0eb26bb21b",
"doc_count": 45
},
{
"key": "018963e5f32b703288aad57690802852",
"doc_count": 29
},
{
"key": "018e197a6461717bb7959cd3d830a9ba",
"doc_count": 27
},
{
"key": "018bbe1479bd7172a96f8a7ec65759d6",
"doc_count": 24
},
{
"key": "018963e5f06f716dadb0fe95b3c53d22",
"doc_count": 14
},
{
"key": "018bbe1476c47169b239563d60e54f70",
"doc_count": 13
},
{
"key": "018c1b62afa8710c908ab4134bbf7c6b",
"doc_count": 13
},
{
"key": "018bbe14777c70d4969157204edbd72b",
"doc_count": 6
},
{
"key": "018963ea3964707fbbfb35b2b8e8084b",
"doc_count": 5
},
{
"key": "01896411e3007292bbf291a9837a8cc8",
"doc_count": 2
},
{
"key": "018963e5f53b7292b003bf6803f624b7",
"doc_count": 1
},
{
"key": "01896411e05c71f4af78a5552a40b626",
"doc_count": 1
},
{
"key": "01896412b55873f299598ced460418f9",
"doc_count": 1
},
{
"key": "01896412b5fc7191b412ee67da021b6b",
"doc_count": 1
},
{
"key": "018bbe147a78717b94b60022a37c3021",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "d8ac016c293145ff9d20f96184a4ad02",
"doc_count": 89
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|