| 1 |
8.58 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":"cdaab14764e84e70817c834ca84ada32"}}}},{"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": 5,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 67,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_product_1721227718",
"_id": "15096165b6b3427aa5cb94349e50ac10",
"_score": null,
"_source": {
"autoIncrement": 4585.0,
"id": "15096165b6b3427aa5cb94349e50ac10"
},
"fields": {
"displayGroup": [
"aa2ad7d8760a6e4789ef4bb420d56f5e"
]
},
"sort": [
1835,
"15096165b6b3427aa5cb94349e50ac10"
]
},
{
"_index": "sw_product_1721227718",
"_id": "20408b03dc224b88969495c15a7c6290",
"_score": null,
"_source": {
"autoIncrement": 4548.0,
"id": "20408b03dc224b88969495c15a7c6290"
},
"fields": {
"displayGroup": [
"febef705d9ba4a280bc56aa5c477cb57"
]
},
"sort": [
1628,
"20408b03dc224b88969495c15a7c6290"
]
},
{
"_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": "025c1f01b7aa40ab880a8e4a4b3cd531",
"_score": null,
"_source": {
"autoIncrement": 4605.0,
"id": "025c1f01b7aa40ab880a8e4a4b3cd531"
},
"fields": {
"displayGroup": [
"c27423e572e06849fc789a905fc57a32"
]
},
"sort": [
1165,
"025c1f01b7aa40ab880a8e4a4b3cd531"
]
},
{
"_index": "sw_product_1721227718",
"_id": "1d035b43d23d447c8fec85f1ebd12cfd",
"_score": null,
"_source": {
"autoIncrement": 4589.0,
"id": "1d035b43d23d447c8fec85f1ebd12cfd"
},
"fields": {
"displayGroup": [
"8a8896be1fd690cacd384db7adf23500"
]
},
"sort": [
1109,
"1d035b43d23d447c8fec85f1ebd12cfd"
]
},
{
"_index": "sw_product_1721227718",
"_id": "6b795681e7c449fc83460284ae35fa47",
"_score": null,
"_source": {
"autoIncrement": 4560.0,
"id": "6b795681e7c449fc83460284ae35fa47"
},
"fields": {
"displayGroup": [
"faaab93f9782fc01c9235399d1d7a9db"
]
},
"sort": [
447,
"6b795681e7c449fc83460284ae35fa47"
]
},
{
"_index": "sw_product_1721227718",
"_id": "bf72a302c0ee4115ba83299136c07ab4",
"_score": null,
"_source": {
"autoIncrement": 4541.0,
"id": "bf72a302c0ee4115ba83299136c07ab4"
},
"fields": {
"displayGroup": [
"5ad4b59c98615a0e85d7e5dfdd661047"
]
},
"sort": [
446,
"bf72a302c0ee4115ba83299136c07ab4"
]
},
{
"_index": "sw_product_1721227718",
"_id": "fc882403cf20462cb3649518b7b4679e",
"_score": null,
"_source": {
"autoIncrement": 4609.0,
"id": "fc882403cf20462cb3649518b7b4679e"
},
"fields": {
"displayGroup": [
"27c61bf97d3bc98b2881fc4914f816fe"
]
},
"sort": [
420,
"fc882403cf20462cb3649518b7b4679e"
]
},
{
"_index": "sw_product_1721227718",
"_id": "e18dcea887b3491a84a07b33ea29dd27",
"_score": null,
"_source": {
"autoIncrement": 4564.0,
"id": "e18dcea887b3491a84a07b33ea29dd27"
},
"fields": {
"displayGroup": [
"e5ac435310ba36fa7af8189d09645f5c"
]
},
"sort": [
249,
"e18dcea887b3491a84a07b33ea29dd27"
]
},
{
"_index": "sw_product_1721227718",
"_id": "850b55e4524e46999607d3f9edf5e48c",
"_score": null,
"_source": {
"autoIncrement": 4602.0,
"id": "850b55e4524e46999607d3f9edf5e48c"
},
"fields": {
"displayGroup": [
"c67148967838a5e30ae4738a6c26b56e"
]
},
"sort": [
179,
"850b55e4524e46999607d3f9edf5e48c"
]
},
{
"_index": "sw_product_1721227718",
"_id": "3a9561c429a1466197d37a9e44e6470a",
"_score": null,
"_source": {
"autoIncrement": 4597.0,
"id": "3a9561c429a1466197d37a9e44e6470a"
},
"fields": {
"displayGroup": [
"4987116e98363338f22a4da037dedb22"
]
},
"sort": [
153,
"3a9561c429a1466197d37a9e44e6470a"
]
},
{
"_index": "sw_product_1721227718",
"_id": "759ce44f53c740f9982fed819671660b",
"_score": null,
"_source": {
"autoIncrement": 5267.0,
"id": "759ce44f53c740f9982fed819671660b"
},
"fields": {
"displayGroup": [
"62d8d1dc4580366710c11d48f5385207"
]
},
"sort": [
128,
"759ce44f53c740f9982fed819671660b"
]
},
{
"_index": "sw_product_1721227718",
"_id": "6053a07aa5c4481082973992716c3ac2",
"_score": null,
"_source": {
"autoIncrement": 4593.0,
"id": "6053a07aa5c4481082973992716c3ac2"
},
"fields": {
"displayGroup": [
"8856aca28d80d6ee0d7ba73651c83796"
]
},
"sort": [
123,
"6053a07aa5c4481082973992716c3ac2"
]
},
{
"_index": "sw_product_1721227718",
"_id": "e5923c3423884774a5f28eec8624a03b",
"_score": null,
"_source": {
"autoIncrement": 5264.0,
"id": "e5923c3423884774a5f28eec8624a03b"
},
"fields": {
"displayGroup": [
"80e536cf911834eadb01deb0615c974a"
]
},
"sort": [
115,
"e5923c3423884774a5f28eec8624a03b"
]
},
{
"_index": "sw_product_1721227718",
"_id": "19002c132834416e859b6f8f97b20412",
"_score": null,
"_source": {
"autoIncrement": 4617.0,
"id": "19002c132834416e859b6f8f97b20412"
},
"fields": {
"displayGroup": [
"ba435bba721d9dcc3d6e99952dad1b15"
]
},
"sort": [
85,
"19002c132834416e859b6f8f97b20412"
]
},
{
"_index": "sw_product_1721227718",
"_id": "c6720dc7829d438cb97b9ff4d64fb191",
"_score": null,
"_source": {
"autoIncrement": 4613.0,
"id": "c6720dc7829d438cb97b9ff4d64fb191"
},
"fields": {
"displayGroup": [
"22886e4dc76bf68742fd320e3e28db78"
]
},
"sort": [
68,
"c6720dc7829d438cb97b9ff4d64fb191"
]
},
{
"_index": "sw_product_1721227718",
"_id": "69c9b3cbd32c491183f5b86b01f011f4",
"_score": null,
"_source": {
"autoIncrement": 5288.0,
"id": "69c9b3cbd32c491183f5b86b01f011f4"
},
"fields": {
"displayGroup": [
"fef6bd00ba39ab9f9e9ebc84cc0f8a05"
]
},
"sort": [
61,
"69c9b3cbd32c491183f5b86b01f011f4"
]
},
{
"_index": "sw_product_1721227718",
"_id": "f46220f15f374094b4c91f0ca76252a1",
"_score": null,
"_source": {
"autoIncrement": 4621.0,
"id": "f46220f15f374094b4c91f0ca76252a1"
},
"fields": {
"displayGroup": [
"215c25ffd931f297754bd655ceb809dc"
]
},
"sort": [
44,
"f46220f15f374094b4c91f0ca76252a1"
]
}
]
},
"aggregations": {
"total-count": {
"value": 18
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
5.32 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":"cdaab14764e84e70817c834ca84ada32"}}}},{"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": 4,
"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": 67,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "30676338dcef46c19dbc5ca680e33874",
"doc_count": 10,
"products": {
"doc_count": 10,
"total-count": {
"value": 10
}
}
},
{
"key": "8333c94c45924b3cb6f7ee4266fc7907",
"doc_count": 10,
"products": {
"doc_count": 10,
"total-count": {
"value": 10
}
}
},
{
"key": "5326ff2862e3462ea4945cfbe4b322ad",
"doc_count": 8,
"products": {
"doc_count": 8,
"total-count": {
"value": 8
}
}
},
{
"key": "e560d30fcd5749c1b4f83ff37c3b7c7a",
"doc_count": 8,
"products": {
"doc_count": 8,
"total-count": {
"value": 8
}
}
},
{
"key": "a36620a52b8a4be9b7bd71e759879d20",
"doc_count": 7,
"products": {
"doc_count": 7,
"total-count": {
"value": 7
}
}
},
{
"key": "ded9012e00b644dabe57683cf2f2891d",
"doc_count": 7,
"products": {
"doc_count": 7,
"total-count": {
"value": 7
}
}
},
{
"key": "8aea83ddf74047ce97c4efec190c70ee",
"doc_count": 5,
"products": {
"doc_count": 5,
"total-count": {
"value": 5
}
}
},
{
"key": "18fd1bbdd6fe45a8a0e08f632d990f0f",
"doc_count": 4,
"products": {
"doc_count": 4,
"total-count": {
"value": 4
}
}
},
{
"key": "4e7b5e21963c4b078dd630ea96e248d3",
"doc_count": 3,
"products": {
"doc_count": 3,
"total-count": {
"value": 3
}
}
},
{
"key": "01ebf407f808465581af25c87cac2058",
"doc_count": 1,
"products": {
"doc_count": 1,
"total-count": {
"value": 1
}
}
},
{
"key": "13616b49292a4852a08852548271273d",
"doc_count": 1,
"products": {
"doc_count": 1,
"total-count": {
"value": 1
}
}
},
{
"key": "15297aaf06d049eea95f2cc918407e28",
"doc_count": 1,
"products": {
"doc_count": 1,
"total-count": {
"value": 1
}
}
},
{
"key": "309cab98abea4222b4d2ebe4e65875f5",
"doc_count": 1,
"products": {
"doc_count": 1,
"total-count": {
"value": 1
}
}
},
{
"key": "3d4e6404ba5540659df23d217f66509d",
"doc_count": 1,
"products": {
"doc_count": 1,
"total-count": {
"value": 1
}
}
}
]
}
},
"properties": {
"doc_count": 124,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "1cdbabef0ea1411ba1cbc3081a6fa4c1",
"doc_count": 24,
"products": {
"doc_count": 24,
"total-count": {
"value": 6
}
}
},
{
"key": "683868808afe4e1eb0bcc3146945e8f9",
"doc_count": 20,
"products": {
"doc_count": 20,
"total-count": {
"value": 5
}
}
},
{
"key": "8c246253dfc64226a7f826ec18510add",
"doc_count": 20,
"products": {
"doc_count": 20,
"total-count": {
"value": 5
}
}
},
{
"key": "cdba722b9db84af289bfe67be2659144",
"doc_count": 20,
"products": {
"doc_count": 20,
"total-count": {
"value": 5
}
}
},
{
"key": "1357b50d1c654ba38c76b0765ca8c570",
"doc_count": 8,
"products": {
"doc_count": 8,
"total-count": {
"value": 2
}
}
},
{
"key": "457465ee569f4718a7be3fb47c827ce0",
"doc_count": 8,
"products": {
"doc_count": 8,
"total-count": {
"value": 2
}
}
},
{
"key": "84214de4ff864b3bafc26a06a22b1567",
"doc_count": 8,
"products": {
"doc_count": 8,
"total-count": {
"value": 2
}
}
},
{
"key": "a6b820cd9c494776b3bfed6f2ca5e490",
"doc_count": 8,
"products": {
"doc_count": 8,
"total-count": {
"value": 2
}
}
},
{
"key": "c24d9d6ff2b547f8830611db64b2ae44",
"doc_count": 8,
"products": {
"doc_count": 8,
"total-count": {
"value": 2
}
}
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "2bbbe6df1c2e425b8a3a5192c4e3b8e1",
"doc_count": 67,
"total-count": {
"value": 18
}
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|