| 1 |
16.71 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":"0189980d5798711da7d8535d39df3a50"}}}},{"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": 14,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 208,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bf7e11094705bbc682bd0fdb61409",
"_score": null,
"_source": {
"autoIncrement": 1144271.0,
"id": "018bf7e11094705bbc682bd0fdb61409"
},
"fields": {
"displayGroup": [
"629194564bdc8b7baed51de18de14f21"
]
},
"sort": [
0,
"018bf7e11094705bbc682bd0fdb61409"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bf7efc5767320bcf1076bce855857",
"_score": null,
"_source": {
"autoIncrement": 1144446.0,
"id": "018bf7efc5767320bcf1076bce855857"
},
"fields": {
"displayGroup": [
"393c436ee27dfcdf599f61afab6da2bb"
]
},
"sort": [
0,
"018bf7efc5767320bcf1076bce855857"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7edaed527076af8dd4e80a074dc1",
"_score": null,
"_source": {
"autoIncrement": 1155750.0,
"id": "018c7edaed527076af8dd4e80a074dc1"
},
"fields": {
"displayGroup": [
"8512143ce0eb6c1d7cf4324ba62a4218"
]
},
"sort": [
0,
"018c7edaed527076af8dd4e80a074dc1"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7edb1614718790650b1c2484d6f2",
"_score": null,
"_source": {
"autoIncrement": 1155753.0,
"id": "018c7edb1614718790650b1c2484d6f2"
},
"fields": {
"displayGroup": [
"f1b229d412911cd3f6fba8cc7223710b"
]
},
"sort": [
0,
"018c7edb1614718790650b1c2484d6f2"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7edb3e9c7281abf64b40fa53a774",
"_score": null,
"_source": {
"autoIncrement": 1155757.0,
"id": "018c7edb3e9c7281abf64b40fa53a774"
},
"fields": {
"displayGroup": [
"6428979df5ff21a63fc7b1c5ec21958b"
]
},
"sort": [
0,
"018c7edb3e9c7281abf64b40fa53a774"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c88a800ad70458c6ec38bd3d29419",
"_score": null,
"_source": {
"autoIncrement": 1171537.0,
"id": "018c88a800ad70458c6ec38bd3d29419"
},
"fields": {
"displayGroup": [
"2456d959bcabdd2f2c5e54e8b6bed5a7"
]
},
"sort": [
0,
"018c88a800ad70458c6ec38bd3d29419"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d108e5d45702a8193e223da6ee6e4",
"_score": null,
"_source": {
"autoIncrement": 1241426.0,
"id": "018d108e5d45702a8193e223da6ee6e4"
},
"fields": {
"displayGroup": [
"d3cc04d489ee5639d53e2764470e3bbf"
]
},
"sort": [
0,
"018d108e5d45702a8193e223da6ee6e4"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d12240b67737a911040a414201546",
"_score": null,
"_source": {
"autoIncrement": 1247536.0,
"id": "018d12240b67737a911040a414201546"
},
"fields": {
"displayGroup": [
"7b97837bc10a964e66c4c6a652955b8f"
]
},
"sort": [
0,
"018d12240b67737a911040a414201546"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d1d3d4e4872f19f32d2a0fb7d4abf",
"_score": null,
"_source": {
"autoIncrement": 1256654.0,
"id": "018d1d3d4e4872f19f32d2a0fb7d4abf"
},
"fields": {
"displayGroup": [
"bb06f0d175f6f554813d6fc9bb0d5482"
]
},
"sort": [
0,
"018d1d3d4e4872f19f32d2a0fb7d4abf"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d1e2d672a7145b89d4ad9ddc9d53c",
"_score": null,
"_source": {
"autoIncrement": 1258139.0,
"id": "018d1e2d672a7145b89d4ad9ddc9d53c"
},
"fields": {
"displayGroup": [
"6fd9f7bdb6a20b51e5b35c403c1e4b88"
]
},
"sort": [
0,
"018d1e2d672a7145b89d4ad9ddc9d53c"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d8edb69f87111b67892e2e11f8cb5",
"_score": null,
"_source": {
"autoIncrement": 1283853.0,
"id": "018d8edb69f87111b67892e2e11f8cb5"
},
"fields": {
"displayGroup": [
"814082b375eea969741effbe96285279"
]
},
"sort": [
0,
"018d8edb69f87111b67892e2e11f8cb5"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d9a72bf287207b9eb59abe8587fbb",
"_score": null,
"_source": {
"autoIncrement": 1295098.0,
"id": "018d9a72bf287207b9eb59abe8587fbb"
},
"fields": {
"displayGroup": [
"149fd98bf323f150627c05555117438e"
]
},
"sort": [
0,
"018d9a72bf287207b9eb59abe8587fbb"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018df045138071d9b9c0ffc7a0279574",
"_score": null,
"_source": {
"autoIncrement": 1741989.0,
"id": "018df045138071d9b9c0ffc7a0279574"
},
"fields": {
"displayGroup": [
"40941c36c2710cedbbbac12311195622"
]
},
"sort": [
0,
"018df045138071d9b9c0ffc7a0279574"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018df04f62687370ad45ec8b52a15006",
"_score": null,
"_source": {
"autoIncrement": 1743188.0,
"id": "018df04f62687370ad45ec8b52a15006"
},
"fields": {
"displayGroup": [
"5b8e565f1f855f77e75d5013a3365256"
]
},
"sort": [
0,
"018df04f62687370ad45ec8b52a15006"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01909c72eb48703fbc2768ba03c805c3",
"_score": null,
"_source": {
"autoIncrement": 1828620.0,
"id": "01909c72eb48703fbc2768ba03c805c3"
},
"fields": {
"displayGroup": [
"26e30d6e06f7719b89ce99fb55eecc07"
]
},
"sort": [
0,
"01909c72eb48703fbc2768ba03c805c3"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01951992ff7b72128658c80cd08c362d",
"_score": null,
"_source": {
"autoIncrement": 1922271.0,
"id": "01951992ff7b72128658c80cd08c362d"
},
"fields": {
"displayGroup": [
"795594cd6c487007788d6b0bfb48672c"
]
},
"sort": [
0,
"01951992ff7b72128658c80cd08c362d"
]
}
]
},
"aggregations": {
"total-count": {
"value": 23
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
10.49 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":"0189980d5798711da7d8535d39df3a50"}}}},{"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": 8,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"max_score": null,
"hits": []
},
"aggregations": {
"shipping-free-filter": {
"doc_count": 7,
"shipping-free": {
"value": 1.0,
"value_as_string": "true"
}
},
"rating-exists": {
"doc_count": 208,
"rating": {
"value": 0.0
}
},
"price": {
"count": 208,
"min": 12.48,
"max": 84.47,
"avg": 40.62576923076923,
"sum": 8450.16
},
"options": {
"doc_count": 416,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "103c221ef5c547a6919548726a45adb7",
"doc_count": 29
},
{
"key": "6818490b3d264af396bf32b5c741cb18",
"doc_count": 29
},
{
"key": "b26bb94349e2469ea3e048b8bd50a91d",
"doc_count": 27
},
{
"key": "63a3e4e3a8d0461ca937227647cbc474",
"doc_count": 26
},
{
"key": "df41139ab42a4f0dbe2167afb103b833",
"doc_count": 24
},
{
"key": "1c23aae651524363801a44213f31f325",
"doc_count": 22
},
{
"key": "bace55c509624d8ab8a0c4653bced477",
"doc_count": 22
},
{
"key": "8010798477bb48a2894cb3b08b41a2e1",
"doc_count": 16
},
{
"key": "32b7f689c19f425d9de20e215684cb85",
"doc_count": 12
},
{
"key": "90deb273963c446380e69696e17dbc1c",
"doc_count": 12
},
{
"key": "fb30441665254535bd2f3931a491af07",
"doc_count": 12
},
{
"key": "40fed3f805694634974d360639023835",
"doc_count": 11
},
{
"key": "2c85f1acf4e648d5830165598cae79ac",
"doc_count": 9
},
{
"key": "5affb90217af40c58011013f87e6b516",
"doc_count": 8
},
{
"key": "b8ddb9b53e2740e58c6385b22bb05e29",
"doc_count": 8
},
{
"key": "0195197bf5c373058498eaf0d3e0e1e4",
"doc_count": 7
},
{
"key": "09df4c6efd80429ca293244b63560c6a",
"doc_count": 7
},
{
"key": "3522f42969ac48adb918e8a185ef7a4c",
"doc_count": 7
},
{
"key": "6b8d9eb2113441598f83a6d7110d18d1",
"doc_count": 7
},
{
"key": "73e7ba66d965447b9ad7e2a05142cd85",
"doc_count": 7
},
{
"key": "a8b13ecee7f74d28af6ed8a74a20757f",
"doc_count": 7
},
{
"key": "018dd5f6ea6641c7b569a0bef47cdc68",
"doc_count": 6
},
{
"key": "26fe66268b1a451f8c6a15e9e1f527b2",
"doc_count": 6
},
{
"key": "2e0c330dc92a4b1e9675b6ded6a51372",
"doc_count": 6
},
{
"key": "3a57082ae23343b199033108897df2e8",
"doc_count": 6
},
{
"key": "4314baa116af4d10a8202db74494ef1a",
"doc_count": 6
},
{
"key": "5615ea5e426b44a8b4b2d69155479413",
"doc_count": 6
},
{
"key": "addda850cb3d4d8d819a5a9f16b44b50",
"doc_count": 6
},
{
"key": "b019ab9ff6554fe9aa13df9a2d58d86e",
"doc_count": 6
},
{
"key": "cc439f46cb05493c85583b67f7a858cb",
"doc_count": 6
},
{
"key": "d0bc348c4bd945f2beb76a7167ceb549",
"doc_count": 6
},
{
"key": "f610065ca5cd456e90b1f2edb6f4cc51",
"doc_count": 6
},
{
"key": "fd5ad16d865548b1a92d8594e31acb36",
"doc_count": 6
},
{
"key": "a8c0afa33a3b4c3395bb83146362f91f",
"doc_count": 5
},
{
"key": "af28a8aa799f477fbbaf5eb63f5add5d",
"doc_count": 5
},
{
"key": "dfff780768784cf1b858239371853d79",
"doc_count": 5
},
{
"key": "018c69036c5d709fa6759781d6dd5cff",
"doc_count": 4
},
{
"key": "54cf2b0f93f04cd2ac223e59bc0aac76",
"doc_count": 4
},
{
"key": "e7380a50cd7d4f58814ec7c9dd2c769d",
"doc_count": 4
},
{
"key": "476d3085cf474460bc2575974a9e29c1",
"doc_count": 2
},
{
"key": "018c6904f0a273138d9e8618fd0fa839",
"doc_count": 1
},
{
"key": "01909bab72c371e39da6b8454fa717d8",
"doc_count": 1
},
{
"key": "398b4672eeb44cfeb482fd652615735f",
"doc_count": 1
},
{
"key": "4f78f0c69c3c4cd88fb9cbde23c9e7d2",
"doc_count": 1
},
{
"key": "cb13282edb624b76b8d753052f211d1c",
"doc_count": 1
},
{
"key": "e79e0f0ea71a47c88535f185ed5e7866",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 774,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "018963e5f06f716dadb0fe95b3c53d22",
"doc_count": 208
},
{
"key": "01896411e25971f98272a565102c3faf",
"doc_count": 72
},
{
"key": "01896411e82d73ef973f22bb35c69d07",
"doc_count": 72
},
{
"key": "01896412963d730bb33f2ca72baaf717",
"doc_count": 54
},
{
"key": "018964128ca7705681bf2178aaca6f0b",
"doc_count": 43
},
{
"key": "018bbe14791071689082984f07aee87b",
"doc_count": 43
},
{
"key": "018963ea3aba7042895b047285c1402e",
"doc_count": 40
},
{
"key": "018963ea1812737fb7f416641565cd24",
"doc_count": 29
},
{
"key": "01896412d9e67359bbc174e3a4deb34a",
"doc_count": 29
},
{
"key": "018bbe13bff4727baa40d87b9df82a76",
"doc_count": 29
},
{
"key": "018c1b62ae397074a02fef7383b25377",
"doc_count": 19
},
{
"key": "018bbe13b8237164810b74768f091ae7",
"doc_count": 16
},
{
"key": "018bbe13bf4971378f6c9737de6890aa",
"doc_count": 15
},
{
"key": "01896411ea347043b0788892761b1dff",
"doc_count": 14
},
{
"key": "018963ea3964707fbbfb35b2b8e8084b",
"doc_count": 13
},
{
"key": "018963ea24c172519a11176e570bcae4",
"doc_count": 11
},
{
"key": "01896411e3007292bbf291a9837a8cc8",
"doc_count": 11
},
{
"key": "01896412978b71dc9678b93ab1c07faa",
"doc_count": 11
},
{
"key": "018963ea3e0572c6960c0eadf8b16c7f",
"doc_count": 7
},
{
"key": "018963ea220370f6b3962a1108942bae",
"doc_count": 6
},
{
"key": "018963ea25737277b207f39850997eb0",
"doc_count": 6
},
{
"key": "018963ea2f4872f5b65ae53cf081df0e",
"doc_count": 6
},
{
"key": "018963ea313d732aab9f9437134e1b76",
"doc_count": 6
},
{
"key": "01896411dfa972429a0b5b59515d3cd1",
"doc_count": 6
},
{
"key": "018bbe13bba571c9a39ca3fe33a172cd",
"doc_count": 6
},
{
"key": "018963ea3609712896e2d21c3a2d91ab",
"doc_count": 1
},
{
"key": "018bbe13b7757294bf18b34533cada9d",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "1a0ffc50b3584a1abd28c2d06d6c6465",
"doc_count": 57
},
{
"key": "69126f5efcab45738b242009148aca51",
"doc_count": 49
},
{
"key": "2a606633b77f4e1bab45f45f3483a835",
"doc_count": 42
},
{
"key": "d8ac016c293145ff9d20f96184a4ad02",
"doc_count": 40
},
{
"key": "38433195e9d345108b1593626fcdaba0",
"doc_count": 19
},
{
"key": "018c7c9a616c7007bb7960ba88e59312",
"doc_count": 1
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|