| 1 |
8.50 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":"5e1abaca6c6548e99f0c9fc7b1019f29"}}}},{"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": 6,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 123,
"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": "018bcd1f3b5d705681c5688f7769511f",
"_score": null,
"_source": {
"autoIncrement": 5588.0,
"id": "018bcd1f3b5d705681c5688f7769511f"
},
"fields": {
"displayGroup": [
"6922350a16ec7ed8244cf68d4e24c397"
]
},
"sort": [
418,
"018bcd1f3b5d705681c5688f7769511f"
]
},
{
"_index": "sw_product_1721227718",
"_id": "018bcdf3035973c6892b41d9ff8233cd",
"_score": null,
"_source": {
"autoIncrement": 5594.0,
"id": "018bcdf3035973c6892b41d9ff8233cd"
},
"fields": {
"displayGroup": [
"679bc116b4b5ce02d0e782490cb86d55"
]
},
"sort": [
332,
"018bcdf3035973c6892b41d9ff8233cd"
]
},
{
"_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": "68db08019faa4fd6b0537952a834f7d2",
"_score": null,
"_source": {
"autoIncrement": 5182.0,
"id": "68db08019faa4fd6b0537952a834f7d2"
},
"fields": {
"displayGroup": [
"291c33c0b1b81991068aa75c10f91229"
]
},
"sort": [
119,
"68db08019faa4fd6b0537952a834f7d2"
]
},
{
"_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"
]
},
{
"_index": "sw_product_1721227718",
"_id": "018991541e2573ce868eb1fc79171e43",
"_score": null,
"_source": {
"autoIncrement": 5357.0,
"id": "018991541e2573ce868eb1fc79171e43"
},
"fields": {
"displayGroup": [
"38cd4a592c49fd2fb788a7f3226d73b0"
]
},
"sort": [
23,
"018991541e2573ce868eb1fc79171e43"
]
},
{
"_index": "sw_product_1721227718",
"_id": "aeb886f97d6742029356165a53982832",
"_score": null,
"_source": {
"autoIncrement": 5115.0,
"id": "aeb886f97d6742029356165a53982832"
},
"fields": {
"displayGroup": [
"b6c81408dae9f003545c62dcabe9c190"
]
},
"sort": [
20,
"aeb886f97d6742029356165a53982832"
]
},
{
"_index": "sw_product_1721227718",
"_id": "e410d758d1534f2db9b50ac9260915ef",
"_score": null,
"_source": {
"autoIncrement": 5328.0,
"id": "e410d758d1534f2db9b50ac9260915ef"
},
"fields": {
"displayGroup": [
"c153f53c7990b36fe48a6f008ea1b9d7"
]
},
"sort": [
19,
"e410d758d1534f2db9b50ac9260915ef"
]
}
]
},
"aggregations": {
"total-count": {
"value": 63
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
5.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":"5e1abaca6c6548e99f0c9fc7b1019f29"}}}},{"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": 5,
"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": 84,
"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": "a36620a52b8a4be9b7bd71e759879d20",
"doc_count": 9,
"products": {
"doc_count": 9,
"total-count": {
"value": 9
}
}
},
{
"key": "ded9012e00b644dabe57683cf2f2891d",
"doc_count": 9,
"products": {
"doc_count": 9,
"total-count": {
"value": 9
}
}
},
{
"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": "8aea83ddf74047ce97c4efec190c70ee",
"doc_count": 7,
"products": {
"doc_count": 7,
"total-count": {
"value": 7
}
}
},
{
"key": "18fd1bbdd6fe45a8a0e08f632d990f0f",
"doc_count": 6,
"products": {
"doc_count": 6,
"total-count": {
"value": 6
}
}
},
{
"key": "4e7b5e21963c4b078dd630ea96e248d3",
"doc_count": 3,
"products": {
"doc_count": 3,
"total-count": {
"value": 3
}
}
},
{
"key": "c185219754534871a8565da37ba05fbc",
"doc_count": 2,
"products": {
"doc_count": 2,
"total-count": {
"value": 2
}
}
},
{
"key": "e44e9266970547cf821eb7d250742c9c",
"doc_count": 2,
"products": {
"doc_count": 2,
"total-count": {
"value": 2
}
}
},
{
"key": "01ebf407f808465581af25c87cac2058",
"doc_count": 1,
"products": {
"doc_count": 1,
"total-count": {
"value": 1
}
}
},
{
"key": "07aa5d58781b43308ad00d8aba10c336",
"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": "21d2a0f4ccb34134a30ba5a0ce4b634d",
"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
}
}
},
{
"key": "6e6f8743d4d541f3b122b8b11837ad69",
"doc_count": 1,
"products": {
"doc_count": 1,
"total-count": {
"value": 1
}
}
},
{
"key": "74ead0f6ceef46af8ceca59fe848f4d8",
"doc_count": 1,
"products": {
"doc_count": 1,
"total-count": {
"value": 1
}
}
},
{
"key": "8a3ecdecc6f24224b16ff7c68f4c5f07",
"doc_count": 1,
"products": {
"doc_count": 1,
"total-count": {
"value": 1
}
}
}
]
}
},
"properties": {
"doc_count": 186,
"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": "e1d9ffd4e76c4828979cb847415de90b",
"doc_count": 13,
"products": {
"doc_count": 13,
"total-count": {
"value": 13
}
}
},
{
"key": "33552cc436624878b13e60b3462097d0",
"doc_count": 12,
"products": {
"doc_count": 12,
"total-count": {
"value": 12
}
}
},
{
"key": "7b0e47dd213249358dee42c01d140d12",
"doc_count": 10,
"products": {
"doc_count": 10,
"total-count": {
"value": 8
}
}
},
{
"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": "72218b12db3b45e580f9834f909b4c0c",
"doc_count": 8,
"products": {
"doc_count": 8,
"total-count": {
"value": 6
}
}
},
{
"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
}
}
},
{
"key": "8c08281f465947b594102f8daa24a0e3",
"doc_count": 6,
"products": {
"doc_count": 6,
"total-count": {
"value": 5
}
}
},
{
"key": "ea7d1a1fd3e246d3ad6d401da300f716",
"doc_count": 6,
"products": {
"doc_count": 6,
"total-count": {
"value": 4
}
}
},
{
"key": "be30d586751e40bca52cf5c52940130a",
"doc_count": 4,
"products": {
"doc_count": 4,
"total-count": {
"value": 3
}
}
},
{
"key": "ed33f9577a4343bab951993cf23de715",
"doc_count": 2,
"products": {
"doc_count": 2,
"total-count": {
"value": 2
}
}
},
{
"key": "0b39121065f14416a7fa7e5f5974afc9",
"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": "2bbbe6df1c2e425b8a3a5192c4e3b8e1",
"doc_count": 75,
"total-count": {
"value": 20
}
},
{
"key": "37ab974b3dda435bb3d91c643509e5dd",
"doc_count": 33,
"total-count": {
"value": 31
}
},
{
"key": "7f27056e2f68488f9ebda6e3e0f65391",
"doc_count": 14,
"total-count": {
"value": 11
}
},
{
"key": "bba2d91cda99401a87aca0fba2c430b8",
"doc_count": 1,
"total-count": {
"value": 1
}
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|