| 1 |
1009.01 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":"01899805fe8572cbad05e24258445438"}}}},{"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": 1005,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 86,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7fa4c89b72eaaf7681fc4563dbe9",
"_score": null,
"_source": {
"autoIncrement": 1164092.0,
"id": "018c7fa4c89b72eaaf7681fc4563dbe9"
},
"fields": {
"displayGroup": [
"2ec1c0f47e004f099ee59287e48045b4"
]
},
"sort": [
0,
"018c7fa4c89b72eaaf7681fc4563dbe9"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7fa4d37f70c88991c4df01689ad2",
"_score": null,
"_source": {
"autoIncrement": 1164093.0,
"id": "018c7fa4d37f70c88991c4df01689ad2"
},
"fields": {
"displayGroup": [
"b42dcb7188919704cc6ab6d861c169c1"
]
},
"sort": [
0,
"018c7fa4d37f70c88991c4df01689ad2"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7fa4ea4c73d382ccbc36144fe508",
"_score": null,
"_source": {
"autoIncrement": 1164094.0,
"id": "018c7fa4ea4c73d382ccbc36144fe508"
},
"fields": {
"displayGroup": [
"bdbed3e17fc5430719311cb9debc1e06"
]
},
"sort": [
0,
"018c7fa4ea4c73d382ccbc36144fe508"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7fa4f45272c3b76c1db8a45e8778",
"_score": null,
"_source": {
"autoIncrement": 1164095.0,
"id": "018c7fa4f45272c3b76c1db8a45e8778"
},
"fields": {
"displayGroup": [
"799a39e10a5ae3899bbd11d6616f4870"
]
},
"sort": [
0,
"018c7fa4f45272c3b76c1db8a45e8778"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7fa4feb873fc932a711613461658",
"_score": null,
"_source": {
"autoIncrement": 1164096.0,
"id": "018c7fa4feb873fc932a711613461658"
},
"fields": {
"displayGroup": [
"a947c232b45924c7aa0833ed0cdbd58e"
]
},
"sort": [
0,
"018c7fa4feb873fc932a711613461658"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7fa5540e70dd943e918f85316526",
"_score": null,
"_source": {
"autoIncrement": 1164100.0,
"id": "018c7fa5540e70dd943e918f85316526"
},
"fields": {
"displayGroup": [
"35e5d15a14d6360f5113732d2767622f"
]
},
"sort": [
0,
"018c7fa5540e70dd943e918f85316526"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7fa55e7670c29b9323a1bea7c7b7",
"_score": null,
"_source": {
"autoIncrement": 1164101.0,
"id": "018c7fa55e7670c29b9323a1bea7c7b7"
},
"fields": {
"displayGroup": [
"340aa0def7fccbbd8c8b25ca9717b7c0"
]
},
"sort": [
0,
"018c7fa55e7670c29b9323a1bea7c7b7"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7fa58b35705294b1393067888d7e",
"_score": null,
"_source": {
"autoIncrement": 1164103.0,
"id": "018c7fa58b35705294b1393067888d7e"
},
"fields": {
"displayGroup": [
"39e069623509beeb2c7abc2bb8eb5b76"
]
},
"sort": [
0,
"018c7fa58b35705294b1393067888d7e"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7fa5b6047076ae9a52e6de8ce462",
"_score": null,
"_source": {
"autoIncrement": 1164105.0,
"id": "018c7fa5b6047076ae9a52e6de8ce462"
},
"fields": {
"displayGroup": [
"4dcdec0c84acb4c95789da8648d515d4"
]
},
"sort": [
0,
"018c7fa5b6047076ae9a52e6de8ce462"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7fa5c027736e8c7c479e49bc7bec",
"_score": null,
"_source": {
"autoIncrement": 1164106.0,
"id": "018c7fa5c027736e8c7c479e49bc7bec"
},
"fields": {
"displayGroup": [
"eb10f64fbbead48bb5f7e3a48eabd8c5"
]
},
"sort": [
0,
"018c7fa5c027736e8c7c479e49bc7bec"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7fb19f72716fb31857b05fbccd4c",
"_score": null,
"_source": {
"autoIncrement": 1164128.0,
"id": "018c7fb19f72716fb31857b05fbccd4c"
},
"fields": {
"displayGroup": [
"0aa88f291414d5db29b1f7d736c8c494"
]
},
"sort": [
0,
"018c7fb19f72716fb31857b05fbccd4c"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7fb5dde670b2b222f403c1b1c117",
"_score": null,
"_source": {
"autoIncrement": 1164133.0,
"id": "018c7fb5dde670b2b222f403c1b1c117"
},
"fields": {
"displayGroup": [
"b24a80750c8b7061b318483587b93487"
]
},
"sort": [
0,
"018c7fb5dde670b2b222f403c1b1c117"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018cf1071e1973aa8e9ffd83ed4d3109",
"_score": null,
"_source": {
"autoIncrement": 1237986.0,
"id": "018cf1071e1973aa8e9ffd83ed4d3109"
},
"fields": {
"displayGroup": [
"384a906cb8ecfaadbedfbdf642736d8f"
]
},
"sort": [
0,
"018cf1071e1973aa8e9ffd83ed4d3109"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d0f70e82b729186048a6f8950fafe",
"_score": null,
"_source": {
"autoIncrement": 1239076.0,
"id": "018d0f70e82b729186048a6f8950fafe"
},
"fields": {
"displayGroup": [
"df40ff0210a4aafcc4e4362feaa61a28"
]
},
"sort": [
0,
"018d0f70e82b729186048a6f8950fafe"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d1251528072eda639ebc817cb1626",
"_score": null,
"_source": {
"autoIncrement": 1247985.0,
"id": "018d1251528072eda639ebc817cb1626"
},
"fields": {
"displayGroup": [
"ab0b04dd097dc783c920c82cc6fc5a82"
]
},
"sort": [
0,
"018d1251528072eda639ebc817cb1626"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d5858814e7343afd2df367e1e155c",
"_score": null,
"_source": {
"autoIncrement": 1266244.0,
"id": "018d5858814e7343afd2df367e1e155c"
},
"fields": {
"displayGroup": [
"425c34ee4c96888d8bdc522e85fdf794"
]
},
"sort": [
0,
"018d5858814e7343afd2df367e1e155c"
]
}
]
},
"aggregations": {
"total-count": {
"value": 62
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
19.42 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":"01899805fe8572cbad05e24258445438"}}}},{"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": 17,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"max_score": null,
"hits": []
},
"aggregations": {
"shipping-free-filter": {
"doc_count": 17,
"shipping-free": {
"value": 1.0,
"value_as_string": "true"
}
},
"rating-exists": {
"doc_count": 86,
"rating": {
"value": 0.0
}
},
"price": {
"count": 86,
"min": 5.25,
"max": 58.46,
"avg": 24.638953488372092,
"sum": 2118.95
},
"options": {
"doc_count": 140,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "eb72ee1138594bdd96373a5ec3f2b7fc",
"doc_count": 68
},
{
"key": "018c6904e760723d986b6a748a00efbc",
"doc_count": 14
},
{
"key": "018c6905a29f7081ae2ba42ac45b8f66",
"doc_count": 5
},
{
"key": "018c6904a6e2731d9b605fbe89e3502e",
"doc_count": 4
},
{
"key": "018c6905a1c073a7ac65039bbe7e0626",
"doc_count": 4
},
{
"key": "018c6904a60a71d58e25430d71ee064a",
"doc_count": 3
},
{
"key": "018c6904c1b972bea687501fd5b7d6e3",
"doc_count": 3
},
{
"key": "018c6904e82873ceb2edba9f152f829b",
"doc_count": 3
},
{
"key": "018c6905666c730a967a2858ec186d7b",
"doc_count": 3
},
{
"key": "018c7c80012f71249252bb9b3bbf1ac4",
"doc_count": 3
},
{
"key": "40fed3f805694634974d360639023835",
"doc_count": 3
},
{
"key": "018c6904beab731fb3688f7e59704624",
"doc_count": 2
},
{
"key": "018c6904c0ff70c0a7d346ac36ccc59b",
"doc_count": 2
},
{
"key": "018c6904c824732184b6a6c6ebff7729",
"doc_count": 2
},
{
"key": "018c6904defa72c7aa4751e288939727",
"doc_count": 2
},
{
"key": "018c7c7ffed472c39488c02bffba8c73",
"doc_count": 2
},
{
"key": "018c7c7fff98709db41d86071b8bd023",
"doc_count": 2
},
{
"key": "b4d2c7bdf2294e37b92c0dbc41579602",
"doc_count": 2
},
{
"key": "c67489a1b58f451ca9c66a78de423110",
"doc_count": 2
},
{
"key": "018c6903c2c5709685b15012706f3e30",
"doc_count": 1
},
{
"key": "018c69059d59739e9367b2c771b262c5",
"doc_count": 1
},
{
"key": "018c69059e53714e92dcd4a66857ddf1",
"doc_count": 1
},
{
"key": "0190a0f0c2c4724b828a85d2be630918",
"doc_count": 1
},
{
"key": "1b5ab1d529ad4416b7aab2e8cac1e22d",
"doc_count": 1
},
{
"key": "476d3085cf474460bc2575974a9e29c1",
"doc_count": 1
},
{
"key": "49c221e63443476288fe926f30f1592b",
"doc_count": 1
},
{
"key": "54cf2b0f93f04cd2ac223e59bc0aac76",
"doc_count": 1
},
{
"key": "72920208d2c44b4faeabefa145ae7021",
"doc_count": 1
},
{
"key": "9210a7722cb145edad85bdc95ccc3cf2",
"doc_count": 1
},
{
"key": "ac151ae726704d3e846aafa194ba4dea",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 239,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "018dcc3373f47133833772ee8dfc3fe4",
"doc_count": 53
},
{
"key": "018963e5f53b7292b003bf6803f624b7",
"doc_count": 34
},
{
"key": "018963ea3aba7042895b047285c1402e",
"doc_count": 30
},
{
"key": "0189641259c2711ebec4774ee52b9a4d",
"doc_count": 27
},
{
"key": "018963ea220370f6b3962a1108942bae",
"doc_count": 17
},
{
"key": "018963ea1812737fb7f416641565cd24",
"doc_count": 16
},
{
"key": "01896411e05c71f4af78a5552a40b626",
"doc_count": 16
},
{
"key": "018963ea3964707fbbfb35b2b8e8084b",
"doc_count": 10
},
{
"key": "01896411e78a73399a29ed714246da0d",
"doc_count": 8
},
{
"key": "018963ea24c172519a11176e570bcae4",
"doc_count": 6
},
{
"key": "01896411e25971f98272a565102c3faf",
"doc_count": 3
},
{
"key": "0190fecfa43d70d2a167f6252e052a9f",
"doc_count": 3
},
{
"key": "018963e5f13871739bde1b0eb26bb21b",
"doc_count": 2
},
{
"key": "018963ea1aa171879381a1be09d5fd97",
"doc_count": 2
},
{
"key": "01896411e9917199967095243438b4f6",
"doc_count": 2
},
{
"key": "018bbe13b8237164810b74768f091ae7",
"doc_count": 2
},
{
"key": "018e197a6b7970bb93d75d15d3216b05",
"doc_count": 2
},
{
"key": "018963e5f5e173a4afde33792d6fe12f",
"doc_count": 1
},
{
"key": "018963ea1e14736f89733679e4ac807d",
"doc_count": 1
},
{
"key": "01896411e59f727b8b482ff954d67fa9",
"doc_count": 1
},
{
"key": "01896411ea347043b0788892761b1dff",
"doc_count": 1
},
{
"key": "018bbe13bf4971378f6c9737de6890aa",
"doc_count": 1
},
{
"key": "018c6ceeef6e734c802444f580d23b2b",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "018c7c9a622870078a62e47c70408932",
"doc_count": 54
},
{
"key": "1a0ffc50b3584a1abd28c2d06d6c6465",
"doc_count": 21
},
{
"key": "d8ac016c293145ff9d20f96184a4ad02",
"doc_count": 11
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|