| 1 |
14.30 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":"01899806314073bb876cc8b477de1b9d"}}}},{"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": 11,
"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": "01b0dee81b83474fa385878450ca1a09",
"_score": null,
"_source": {
"autoIncrement": 1120758.0,
"id": "01b0dee81b83474fa385878450ca1a09"
},
"fields": {
"displayGroup": [
"0bb62370ed1efce9fa6883388e34d508"
]
},
"sort": [
2,
"01b0dee81b83474fa385878450ca1a09"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7ec7dec273d39ddf2f99118babc0",
"_score": null,
"_source": {
"autoIncrement": 1154883.0,
"id": "018c7ec7dec273d39ddf2f99118babc0"
},
"fields": {
"displayGroup": [
"6e74a2f6acc223dde759215f3581b214"
]
},
"sort": [
0,
"018c7ec7dec273d39ddf2f99118babc0"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7ec808f471a7b03c82ac9569b45e",
"_score": null,
"_source": {
"autoIncrement": 1154886.0,
"id": "018c7ec808f471a7b03c82ac9569b45e"
},
"fields": {
"displayGroup": [
"ec3354e2998bb8836b7a070c44b4dc76"
]
},
"sort": [
0,
"018c7ec808f471a7b03c82ac9569b45e"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7efb755f71e1942b9c8ec8fab57d",
"_score": null,
"_source": {
"autoIncrement": 1160162.0,
"id": "018c7efb755f71e1942b9c8ec8fab57d"
},
"fields": {
"displayGroup": [
"68637030dce6af99a64fa014507bd201"
]
},
"sort": [
0,
"018c7efb755f71e1942b9c8ec8fab57d"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c88a4910270ea8da34f3316facef9",
"_score": null,
"_source": {
"autoIncrement": 1171301.0,
"id": "018c88a4910270ea8da34f3316facef9"
},
"fields": {
"displayGroup": [
"ac2921099a9aab2f8720523d324e8de3"
]
},
"sort": [
0,
"018c88a4910270ea8da34f3316facef9"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c88a50d7a72f3b52860cced298af0",
"_score": null,
"_source": {
"autoIncrement": 1171321.0,
"id": "018c88a50d7a72f3b52860cced298af0"
},
"fields": {
"displayGroup": [
"16ff8991289e8079a81c6073d84ef25d"
]
},
"sort": [
0,
"018c88a50d7a72f3b52860cced298af0"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c88a517bc7247b8b80477d055c7c6",
"_score": null,
"_source": {
"autoIncrement": 1171325.0,
"id": "018c88a517bc7247b8b80477d055c7c6"
},
"fields": {
"displayGroup": [
"444b9424053d077d18748b139696c92b"
]
},
"sort": [
0,
"018c88a517bc7247b8b80477d055c7c6"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d1d3002e4737bb4de7ffa97a735ec",
"_score": null,
"_source": {
"autoIncrement": 1256517.0,
"id": "018d1d3002e4737bb4de7ffa97a735ec"
},
"fields": {
"displayGroup": [
"4f4a028ec492dbf37f4857c37b5e8163"
]
},
"sort": [
0,
"018d1d3002e4737bb4de7ffa97a735ec"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d94ace85c73f9be59cbcd65c7fcc1",
"_score": null,
"_source": {
"autoIncrement": 1289343.0,
"id": "018d94ace85c73f9be59cbcd65c7fcc1"
},
"fields": {
"displayGroup": [
"7a94502ee55cbd756b98551f91fd5bb8"
]
},
"sort": [
0,
"018d94ace85c73f9be59cbcd65c7fcc1"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d94acf70d701e8d48a22a63985f4a",
"_score": null,
"_source": {
"autoIncrement": 1289344.0,
"id": "018d94acf70d701e8d48a22a63985f4a"
},
"fields": {
"displayGroup": [
"6ae7ce6642f7f014aa044bf6debc3cbd"
]
},
"sort": [
0,
"018d94acf70d701e8d48a22a63985f4a"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0190e989299b71188bddc3f559ce7e71",
"_score": null,
"_source": {
"autoIncrement": 1841717.0,
"id": "0190e989299b71188bddc3f559ce7e71"
},
"fields": {
"displayGroup": [
"305f961a7c6a3236847fa7e00119517f"
]
},
"sort": [
0,
"0190e989299b71188bddc3f559ce7e71"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "11037a9b35d34d11b417d68debf72840",
"_score": null,
"_source": {
"autoIncrement": 989101.0,
"id": "11037a9b35d34d11b417d68debf72840"
},
"fields": {
"displayGroup": [
"9d6ea7f3500fa9ab21de54063ac126f3"
]
},
"sort": [
0,
"11037a9b35d34d11b417d68debf72840"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "8ab110e66c634c53bf55a19cc0bdc295",
"_score": null,
"_source": {
"autoIncrement": 1120668.0,
"id": "8ab110e66c634c53bf55a19cc0bdc295"
},
"fields": {
"displayGroup": [
"647cfb64f4b0feacaac6475fc652b908"
]
},
"sort": [
0,
"8ab110e66c634c53bf55a19cc0bdc295"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "9d62f9f7bfdd444fa544f0d9fac15a67",
"_score": null,
"_source": {
"autoIncrement": 1120600.0,
"id": "9d62f9f7bfdd444fa544f0d9fac15a67"
},
"fields": {
"displayGroup": [
"af4623828118f4a672ef3dcc7c3dc063"
]
},
"sort": [
0,
"9d62f9f7bfdd444fa544f0d9fac15a67"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "a81d545c81084b7f9ab6b4680794515a",
"_score": null,
"_source": {
"autoIncrement": 964396.0,
"id": "a81d545c81084b7f9ab6b4680794515a"
},
"fields": {
"displayGroup": [
"753796e3b7b10e0d009740220c2c27c2"
]
},
"sort": [
0,
"a81d545c81084b7f9ab6b4680794515a"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "bfd4b188afef43629e53cfc306f2f6a0",
"_score": null,
"_source": {
"autoIncrement": 1120696.0,
"id": "bfd4b188afef43629e53cfc306f2f6a0"
},
"fields": {
"displayGroup": [
"68732ed1320b0ab3bcc633ee170a2b44"
]
},
"sort": [
0,
"bfd4b188afef43629e53cfc306f2f6a0"
]
}
]
},
"aggregations": {
"total-count": {
"value": 18
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
8.26 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":"01899806314073bb876cc8b477de1b9d"}}}},{"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": 0,
"shipping-free": {
"value": null
}
},
"rating-exists": {
"doc_count": 21,
"rating": {
"value": 0.0
}
},
"price": {
"count": 21,
"min": 3.59,
"max": 27.99,
"avg": 14.585714285714285,
"sum": 306.3
},
"options": {
"doc_count": 42,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "eb72ee1138594bdd96373a5ec3f2b7fc",
"doc_count": 18
},
{
"key": "40fed3f805694634974d360639023835",
"doc_count": 3
},
{
"key": "63eac26e6a124098a9e8e806d4f07fa9",
"doc_count": 3
},
{
"key": "88e37ca9c31b4575a7e4c105a1139281",
"doc_count": 2
},
{
"key": "b60d3f90f8c04e8ba88208ad4c82ce31",
"doc_count": 2
},
{
"key": "018c7c7fb3c771799e16e32314ffb52e",
"doc_count": 1
},
{
"key": "01909baab83372b9b1f0ca7c9a6fdc3b",
"doc_count": 1
},
{
"key": "4bbf71f6639e4c1eb040ce1de5b7ba9b",
"doc_count": 1
},
{
"key": "4c021052c64a4daca41cc36e9d697031",
"doc_count": 1
},
{
"key": "61acb46035124ce5b7b61f63cd5aeb7f",
"doc_count": 1
},
{
"key": "86bdb1b150dc41429d05122ba525479e",
"doc_count": 1
},
{
"key": "8b7442faf2fa4077bb2161946af82300",
"doc_count": 1
},
{
"key": "9b634a252d7a434f809f2905b4e5ba53",
"doc_count": 1
},
{
"key": "addda850cb3d4d8d819a5a9f16b44b50",
"doc_count": 1
},
{
"key": "bc8fe7542bcb415e8fd99953e2df09f4",
"doc_count": 1
},
{
"key": "bdc65e15082843aab932c64c7986d3e6",
"doc_count": 1
},
{
"key": "d725665462bb4453bced1cd2d8134d4b",
"doc_count": 1
},
{
"key": "f4ae98e61a6e405cb0b5a221ef13dbfe",
"doc_count": 1
},
{
"key": "f87a19ab23ab4b9a87ff14f85cd740b5",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 82,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "01896412e19a7039a44055caa386438a",
"doc_count": 19
},
{
"key": "018963e5f53b7292b003bf6803f624b7",
"doc_count": 16
},
{
"key": "01896411e78a73399a29ed714246da0d",
"doc_count": 15
},
{
"key": "018963ea3aba7042895b047285c1402e",
"doc_count": 11
},
{
"key": "01896411e3007292bbf291a9837a8cc8",
"doc_count": 5
},
{
"key": "018bbe13bff4727baa40d87b9df82a76",
"doc_count": 4
},
{
"key": "018963ea1812737fb7f416641565cd24",
"doc_count": 2
},
{
"key": "018963ea3964707fbbfb35b2b8e8084b",
"doc_count": 2
},
{
"key": "018963ea1cb372228d923d381e57ce55",
"doc_count": 1
},
{
"key": "018963ea235f7081aea103f2195fbbb0",
"doc_count": 1
},
{
"key": "018963ea313d732aab9f9437134e1b76",
"doc_count": 1
},
{
"key": "018963ea3d5d73cfb8d2ad717ae4bcdc",
"doc_count": 1
},
{
"key": "01896411e4587305baecfc84ebf67bc3",
"doc_count": 1
},
{
"key": "018964127fcb7227b018a1f7c36d6368",
"doc_count": 1
},
{
"key": "01896412ea7d708ba7bbb270597fc106",
"doc_count": 1
},
{
"key": "018bbe13bf4971378f6c9737de6890aa",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "69126f5efcab45738b242009148aca51",
"doc_count": 9
},
{
"key": "1cadc079599b4e0386adc59541691ef7",
"doc_count": 7
},
{
"key": "d8ac016c293145ff9d20f96184a4ad02",
"doc_count": 4
},
{
"key": "0eb8635d02c643c2b1d22ea1631c0c90",
"doc_count": 1
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|