| 1 |
5.96 ms |
Request:
{"index":"sw_product","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":"23c98bbe2a9749cb9001245287edcc2e"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"7986125bef384b148249f54c08bd704a"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}},{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categoriesRo","query":{"terms":{"categoriesRo.id":["018e9f02546e7c82a9b5bda06cc934e9","01918ec9c5fa73c5a1574670671bee08"]}}}}]}}]}}]}}]}},"sort":[{"sales":{"order":"DESC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"},"search_type":"query_then_fetch"}
{
"took": 4,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 30,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_product_1721227718",
"_id": "2ede1c9a24524256a45c8bc517855cb9",
"_score": null,
"_source": {
"autoIncrement": 5088.0,
"id": "2ede1c9a24524256a45c8bc517855cb9"
},
"fields": {
"displayGroup": [
"ee2e2ce32f04b13afb55b34f2404f293"
]
},
"sort": [
2068,
"2ede1c9a24524256a45c8bc517855cb9"
]
},
{
"_index": "sw_product_1721227718",
"_id": "6e6d12912a514dd8b89b43c25e676b61",
"_score": null,
"_source": {
"autoIncrement": 4544.0,
"id": "6e6d12912a514dd8b89b43c25e676b61"
},
"fields": {
"displayGroup": [
"8fc31c3f49638b3fc01933bc81f3eff4"
]
},
"sort": [
1360,
"6e6d12912a514dd8b89b43c25e676b61"
]
},
{
"_index": "sw_product_1721227718",
"_id": "01899c8def0b732182509895f62a5814",
"_score": null,
"_source": {
"autoIncrement": 5390.0,
"id": "01899c8def0b732182509895f62a5814"
},
"fields": {
"displayGroup": [
"79e708b6d1f36a7ee95e2590d5037708"
]
},
"sort": [
1359,
"01899c8def0b732182509895f62a5814"
]
},
{
"_index": "sw_product_1721227718",
"_id": "01899c6ffc557169a7df00b0d2be107e",
"_score": null,
"_source": {
"autoIncrement": 5385.0,
"id": "01899c6ffc557169a7df00b0d2be107e"
},
"fields": {
"displayGroup": [
"f287fa6f627c831053a9420c5491c021"
]
},
"sort": [
1020,
"01899c6ffc557169a7df00b0d2be107e"
]
},
{
"_index": "sw_product_1721227718",
"_id": "01899c4f2af67029afa4d16dca17384e",
"_score": null,
"_source": {
"autoIncrement": 5380.0,
"id": "01899c4f2af67029afa4d16dca17384e"
},
"fields": {
"displayGroup": [
"c782547616713ba3707f42fe4dd18e49"
]
},
"sort": [
773,
"01899c4f2af67029afa4d16dca17384e"
]
},
{
"_index": "sw_product_1721227718",
"_id": "01899becfe137297b0c5dbc412ab1194",
"_score": null,
"_source": {
"autoIncrement": 5375.0,
"id": "01899becfe137297b0c5dbc412ab1194"
},
"fields": {
"displayGroup": [
"967a059ca69061b4372f3fef80883a6d"
]
},
"sort": [
485,
"01899becfe137297b0c5dbc412ab1194"
]
},
{
"_index": "sw_product_1721227718",
"_id": "83d9f8ff22914d1e9e3e9f8908be903e",
"_score": null,
"_source": {
"autoIncrement": 4349.0,
"id": "83d9f8ff22914d1e9e3e9f8908be903e"
},
"fields": {
"displayGroup": [
"1a0593c5f0d2a5dec48a964d25a5d6ba"
]
},
"sort": [
232,
"83d9f8ff22914d1e9e3e9f8908be903e"
]
},
{
"_index": "sw_product_1721227718",
"_id": "01899ca580587352a53c3edbe7db7690",
"_score": null,
"_source": {
"autoIncrement": 5397.0,
"id": "01899ca580587352a53c3edbe7db7690"
},
"fields": {
"displayGroup": [
"d0afea4c959bd92be8a5be168fc7057a"
]
},
"sort": [
88,
"01899ca580587352a53c3edbe7db7690"
]
},
{
"_index": "sw_product_1721227718",
"_id": "d0cdee055354441b9d7e998c9dd889df",
"_score": null,
"_source": {
"autoIncrement": 5400.0,
"id": "d0cdee055354441b9d7e998c9dd889df"
},
"fields": {
"displayGroup": [
"3c853b0f0e7d09ca3c9a42f22daf32cc"
]
},
"sort": [
22,
"d0cdee055354441b9d7e998c9dd889df"
]
},
{
"_index": "sw_product_1721227718",
"_id": "4813cb6fe04643d183b335dec3a71aef",
"_score": null,
"_source": {
"autoIncrement": 5206.0,
"id": "4813cb6fe04643d183b335dec3a71aef"
},
"fields": {
"displayGroup": [
"b16ad52da28ad8678eb7013d63caad49"
]
},
"sort": [
20,
"4813cb6fe04643d183b335dec3a71aef"
]
},
{
"_index": "sw_product_1721227718",
"_id": "018def7cce6e72d1a7e760b840a61c2b",
"_score": null,
"_source": {
"autoIncrement": 5626.0,
"id": "018def7cce6e72d1a7e760b840a61c2b"
},
"fields": {
"displayGroup": [
"29e21258154b83b107b801282c1f1494"
]
},
"sort": [
0,
"018def7cce6e72d1a7e760b840a61c2b"
]
},
{
"_index": "sw_product_1721227718",
"_id": "623635b7abe1402fbbaa7960813891e8",
"_score": null,
"_source": {
"autoIncrement": 5211.0,
"id": "623635b7abe1402fbbaa7960813891e8"
},
"fields": {
"displayGroup": [
"dc180baf70f8633b4d63343a5d76248b"
]
},
"sort": [
0,
"623635b7abe1402fbbaa7960813891e8"
]
}
]
},
"aggregations": {
"total-count": {
"value": 12
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
4.99 ms |
Request:
{"index":"sw_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":"23c98bbe2a9749cb9001245287edcc2e"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"7986125bef384b148249f54c08bd704a"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}},{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categoriesRo","query":{"terms":{"categoriesRo.id":["018e9f02546e7c82a9b5bda06cc934e9","01918ec9c5fa73c5a1574670671bee08"]}}}}]}}]}}]}}]}},"aggregations":{"manufacturer":{"terms":{"field":"manufacturerId","size":10000},"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}}},"shipping-free-filter":{"filter":{"term":{"shippingFree":true}},"aggregations":{"shipping-free":{"max":{"field":"shippingFree"}},"total-count":{"cardinality":{"field":"displayGroup"}}}},"properties":{"nested":{"path":"properties"},"aggregations":{"properties":{"terms":{"field":"properties.id","size":10000},"aggregations":{"products":{"reverse_nested":{},"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}}}}}}},"options":{"nested":{"path":"options"},"aggregations":{"options":{"terms":{"field":"options.id","size":10000},"aggregations":{"products":{"reverse_nested":{},"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}}}}}}}},"size":0,"timeout":"5s"},"search_type":"query_then_fetch"}
{
"took": 3,
"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
},
"total-count": {
"value": 0
}
},
"options": {
"doc_count": 25,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "a36620a52b8a4be9b7bd71e759879d20",
"doc_count": 6,
"products": {
"doc_count": 6,
"total-count": {
"value": 6
}
}
},
{
"key": "ded9012e00b644dabe57683cf2f2891d",
"doc_count": 6,
"products": {
"doc_count": 6,
"total-count": {
"value": 6
}
}
},
{
"key": "18fd1bbdd6fe45a8a0e08f632d990f0f",
"doc_count": 3,
"products": {
"doc_count": 3,
"total-count": {
"value": 3
}
}
},
{
"key": "8aea83ddf74047ce97c4efec190c70ee",
"doc_count": 3,
"products": {
"doc_count": 3,
"total-count": {
"value": 3
}
}
},
{
"key": "30676338dcef46c19dbc5ca680e33874",
"doc_count": 2,
"products": {
"doc_count": 2,
"total-count": {
"value": 2
}
}
},
{
"key": "8333c94c45924b3cb6f7ee4266fc7907",
"doc_count": 2,
"products": {
"doc_count": 2,
"total-count": {
"value": 2
}
}
},
{
"key": "7a4776317c0a4895a9944e85223bc09e",
"doc_count": 1,
"products": {
"doc_count": 1,
"total-count": {
"value": 1
}
}
},
{
"key": "e4005f6d783c44059d30ea3781877691",
"doc_count": 1,
"products": {
"doc_count": 1,
"total-count": {
"value": 1
}
}
},
{
"key": "f54e0b0a43ec4e2490552bc63a3f622d",
"doc_count": 1,
"products": {
"doc_count": 1,
"total-count": {
"value": 1
}
}
}
]
}
},
"properties": {
"doc_count": 37,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "f6aa6b9831994fdc8f07e39b40e1253a",
"doc_count": 11,
"products": {
"doc_count": 11,
"total-count": {
"value": 3
}
}
},
{
"key": "ae35403f4d8342f5bcc88835d8818a10",
"doc_count": 10,
"products": {
"doc_count": 10,
"total-count": {
"value": 3
}
}
},
{
"key": "ecac491636944a9cbd895ed1729d99fa",
"doc_count": 8,
"products": {
"doc_count": 8,
"total-count": {
"value": 2
}
}
},
{
"key": "84214de4ff864b3bafc26a06a22b1567",
"doc_count": 4,
"products": {
"doc_count": 4,
"total-count": {
"value": 1
}
}
},
{
"key": "8c246253dfc64226a7f826ec18510add",
"doc_count": 1,
"products": {
"doc_count": 1,
"total-count": {
"value": 1
}
}
},
{
"key": "cdba722b9db84af289bfe67be2659144",
"doc_count": 1,
"products": {
"doc_count": 1,
"total-count": {
"value": 1
}
}
},
{
"key": "e370578618464c95aff732f91b25fac4",
"doc_count": 1,
"products": {
"doc_count": 1,
"total-count": {
"value": 1
}
}
},
{
"key": "f7804d8f1cd849568c7bd971f37c1b00",
"doc_count": 1,
"products": {
"doc_count": 1,
"total-count": {
"value": 1
}
}
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "bba2d91cda99401a87aca0fba2c430b8",
"doc_count": 25,
"total-count": {
"value": 10
}
},
{
"key": "2bbbe6df1c2e425b8a3a5192c4e3b8e1",
"doc_count": 4,
"total-count": {
"value": 1
}
},
{
"key": "37ab974b3dda435bb3d91c643509e5dd",
"doc_count": 1,
"total-count": {
"value": 1
}
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|