| 1 |
713.47 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":"018b1dc24a927010ae7a845639deb9e1"}}}},{"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": 710,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 628,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_all4team_product_1716336301",
"_id": "018af47c540c71608bf73c8883e671c2",
"_score": null,
"_source": {
"autoIncrement": 1133264.0,
"id": "018af47c540c71608bf73c8883e671c2"
},
"fields": {
"displayGroup": [
"34d69b0742832e2c332be03a0d0c00be"
]
},
"sort": [
0,
"018af47c540c71608bf73c8883e671c2"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bcee539ca709d9fe4c8aba4b988d1",
"_score": null,
"_source": {
"autoIncrement": 1136025.0,
"id": "018bcee539ca709d9fe4c8aba4b988d1"
},
"fields": {
"displayGroup": [
"cb0b3a9b2e8db5fc4aa8b9f9a78e1a31"
]
},
"sort": [
0,
"018bcee539ca709d9fe4c8aba4b988d1"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c80d47b757384b931dd67419d04b5",
"_score": null,
"_source": {
"autoIncrement": 1164790.0,
"id": "018c80d47b757384b931dd67419d04b5"
},
"fields": {
"displayGroup": [
"17e84f8dd9d4b60826a52b1864661a09"
]
},
"sort": [
0,
"018c80d47b757384b931dd67419d04b5"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018cd01cd89f72a4b7451ba89915859a",
"_score": null,
"_source": {
"autoIncrement": 1222965.0,
"id": "018cd01cd89f72a4b7451ba89915859a"
},
"fields": {
"displayGroup": [
"b6396ed5ff999d890ba6205cd72c455f"
]
},
"sort": [
0,
"018cd01cd89f72a4b7451ba89915859a"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d94e5209c737097fc3b63d97bcdf2",
"_score": null,
"_source": {
"autoIncrement": 1289732.0,
"id": "018d94e5209c737097fc3b63d97bcdf2"
},
"fields": {
"displayGroup": [
"c837b6ce780b2d7f0886366046814d05"
]
},
"sort": [
0,
"018d94e5209c737097fc3b63d97bcdf2"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d993b28577186847fa35eb9888fa8",
"_score": null,
"_source": {
"autoIncrement": 1293449.0,
"id": "018d993b28577186847fa35eb9888fa8"
},
"fields": {
"displayGroup": [
"efd1ab447ad506ffcd70b1fadd152654"
]
},
"sort": [
0,
"018d993b28577186847fa35eb9888fa8"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018daa1f4edc72e392c3cbeddfd4d6ed",
"_score": null,
"_source": {
"autoIncrement": 1309446.0,
"id": "018daa1f4edc72e392c3cbeddfd4d6ed"
},
"fields": {
"displayGroup": [
"e23160566bcf0fbd43678ee0f67e12f4"
]
},
"sort": [
0,
"018daa1f4edc72e392c3cbeddfd4d6ed"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01909c4fc228732785ef84005e26a7c9",
"_score": null,
"_source": {
"autoIncrement": 1825515.0,
"id": "01909c4fc228732785ef84005e26a7c9"
},
"fields": {
"displayGroup": [
"f948357fb7e5217e29ad1750472e043c"
]
},
"sort": [
0,
"01909c4fc228732785ef84005e26a7c9"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01909c5099f873cdb3547fd786d61666",
"_score": null,
"_source": {
"autoIncrement": 1825588.0,
"id": "01909c5099f873cdb3547fd786d61666"
},
"fields": {
"displayGroup": [
"34cfc82569ce4c460ffc07fd4fd2946e"
]
},
"sort": [
0,
"01909c5099f873cdb3547fd786d61666"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01909c9bfc0b72629ce32e07662dfb68",
"_score": null,
"_source": {
"autoIncrement": 1830332.0,
"id": "01909c9bfc0b72629ce32e07662dfb68"
},
"fields": {
"displayGroup": [
"131adae17e7393c48b944a78c51d4c16"
]
},
"sort": [
0,
"01909c9bfc0b72629ce32e07662dfb68"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0190a5d9c35171bab4cc2ec9c8296905",
"_score": null,
"_source": {
"autoIncrement": 1836051.0,
"id": "0190a5d9c35171bab4cc2ec9c8296905"
},
"fields": {
"displayGroup": [
"3a8fc29d98af179a10400a2161a93654"
]
},
"sort": [
0,
"0190a5d9c35171bab4cc2ec9c8296905"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0190a69a84a373b8b402260f4f3130db",
"_score": null,
"_source": {
"autoIncrement": 1836124.0,
"id": "0190a69a84a373b8b402260f4f3130db"
},
"fields": {
"displayGroup": [
"5b7b988be5fb8c0f1b52c612a143a12b"
]
},
"sort": [
0,
"0190a69a84a373b8b402260f4f3130db"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0190a6d2bd4b7016957f4f40bc2982ef",
"_score": null,
"_source": {
"autoIncrement": 1836517.0,
"id": "0190a6d2bd4b7016957f4f40bc2982ef"
},
"fields": {
"displayGroup": [
"da36631ea1595b8bb09d315dcada8029"
]
},
"sort": [
0,
"0190a6d2bd4b7016957f4f40bc2982ef"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0190a6d3423c730ba95b520bfc8032a2",
"_score": null,
"_source": {
"autoIncrement": 1836597.0,
"id": "0190a6d3423c730ba95b520bfc8032a2"
},
"fields": {
"displayGroup": [
"c2e7f613304924a85a0f081a9660b1e0"
]
},
"sort": [
0,
"0190a6d3423c730ba95b520bfc8032a2"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0190a6d3aa76718fae409c072bf7c235",
"_score": null,
"_source": {
"autoIncrement": 1836645.0,
"id": "0190a6d3aa76718fae409c072bf7c235"
},
"fields": {
"displayGroup": [
"9bf93419cbbbd84c2f192dc1be1fce2b"
]
},
"sort": [
0,
"0190a6d3aa76718fae409c072bf7c235"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0190a6d452fb71fd87553477676d538b",
"_score": null,
"_source": {
"autoIncrement": 1836741.0,
"id": "0190a6d452fb71fd87553477676d538b"
},
"fields": {
"displayGroup": [
"34ede33c9be0af050143ffefcad936eb"
]
},
"sort": [
0,
"0190a6d452fb71fd87553477676d538b"
]
}
]
},
"aggregations": {
"total-count": {
"value": 46
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
9.92 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":"018b1dc24a927010ae7a845639deb9e1"}}}},{"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_rulef56aa66553b04105839b38b9288ce3ed_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": 1,
"shipping-free": {
"value": 1.0,
"value_as_string": "true"
}
},
"rating-exists": {
"doc_count": 628,
"rating": {
"value": 0.0
}
},
"price": {
"count": 628,
"min": 35.99,
"max": 183.96,
"avg": 73.87495222929937,
"sum": 46393.47
},
"options": {
"doc_count": 1254,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "018d79675466735989015568610f58b3",
"doc_count": 90
},
{
"key": "018d7967562073d29d87ac0d1805a758",
"doc_count": 75
},
{
"key": "018d796752da71d4bc16000988e14500",
"doc_count": 55
},
{
"key": "018d7967553a72ca97faf14b9d69a419",
"doc_count": 45
},
{
"key": "018dcc33ef3e71b98f00b79ebc1d3165",
"doc_count": 40
},
{
"key": "2ef77dd834ab4ad8bf116883a3624328",
"doc_count": 40
},
{
"key": "f166e204f18a46cd947eb253dc245521",
"doc_count": 40
},
{
"key": "528d738a30b847248434b14e905cd91c",
"doc_count": 38
},
{
"key": "98d6bcd6d5da4c45a80c847b8f441853",
"doc_count": 38
},
{
"key": "2055b8652dba4a38bb12157ef8bd8e7c",
"doc_count": 37
},
{
"key": "6f242ff7ed204f40be74447de407e8b9",
"doc_count": 37
},
{
"key": "799eeec01566421399f0186a0c1929ae",
"doc_count": 37
},
{
"key": "d32f5d7c6ff24f32ac2cef76583b3ff3",
"doc_count": 36
},
{
"key": "fb2bcb1d04544f8e91cab9caadccd0e2",
"doc_count": 36
},
{
"key": "018dcc33d1f4700f9e35e85caff09a05",
"doc_count": 35
},
{
"key": "24825ae0f7ff41bdbddc49e34931df58",
"doc_count": 35
},
{
"key": "c2d0a920e328481db842b8da42b54bc1",
"doc_count": 35
},
{
"key": "c4ca7c83d7b9434dba35d808f3cb587b",
"doc_count": 35
},
{
"key": "e1b2548665464da9b4f051e46c78427f",
"doc_count": 35
},
{
"key": "c36af3803d914e8bb422246a1b400a68",
"doc_count": 34
},
{
"key": "64a44b3d85144a88b890b250e7030d5f",
"doc_count": 31
},
{
"key": "c2725e1f949d43afafbd92ebcdce5798",
"doc_count": 31
},
{
"key": "018d796753a4710b85d12880bdf47b61",
"doc_count": 30
},
{
"key": "13b662e7a3b149b388a87e76e82f3299",
"doc_count": 30
},
{
"key": "a3c0ad99cd1742e485ac4f5f5773c6e0",
"doc_count": 23
},
{
"key": "018dcc33c6d373d890cb382f67400f5e",
"doc_count": 20
},
{
"key": "018dcc33f84c71f49a5cfac761b33f39",
"doc_count": 20
},
{
"key": "2187203b11f344b6a815ba773a93bb44",
"doc_count": 20
},
{
"key": "7863d08ba253497a89e1cfa6d1f070b9",
"doc_count": 19
},
{
"key": "7189e238f66c4db8831ad403f65df75e",
"doc_count": 18
},
{
"key": "b5a3d8c7138344dda67987a4eff4cb1c",
"doc_count": 18
},
{
"key": "fefc7b01e0504b2fb7aa23b3115fe4f8",
"doc_count": 18
},
{
"key": "97610a9e8a0f4970a7be7eec0bac0378",
"doc_count": 17
},
{
"key": "a5d7196c2514479f857621c32bb84608",
"doc_count": 17
},
{
"key": "c0088ccb433c49aaadfc61d1966f804c",
"doc_count": 17
},
{
"key": "018dcc33d6a272b59e6bb631899ed7ce",
"doc_count": 15
},
{
"key": "018dcc33ddd5728c9f81f88820ccc4d3",
"doc_count": 15
},
{
"key": "018dcc33b77c727da1e18a8cf002c746",
"doc_count": 10
},
{
"key": "01901bd3339372b696de1abd019141c9",
"doc_count": 10
},
{
"key": "01909baa6cbc71deaaf0a7271455cdca",
"doc_count": 7
},
{
"key": "018c690369a9714988c0ae7e113fee13",
"doc_count": 5
},
{
"key": "01909baa8a5e71d19a057b33fe293e3d",
"doc_count": 3
},
{
"key": "018d7967fbc47234a7737c0c64fb6b7a",
"doc_count": 2
},
{
"key": "01909baa289473c988f5798b39a2ba9c",
"doc_count": 1
},
{
"key": "01909baa426d72e6a4ee1d0950c74af3",
"doc_count": 1
},
{
"key": "7827356c7cce40bb96677fa33f721a63",
"doc_count": 1
},
{
"key": "b4bcc055f4b34f45ac8470f8a86812a3",
"doc_count": 1
},
{
"key": "b9098912ba704078bf6482acae250e23",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 2252,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "018963e5f13871739bde1b0eb26bb21b",
"doc_count": 567
},
{
"key": "01896412726f738286e29c074c21499b",
"doc_count": 515
},
{
"key": "01896411e11071498f66a862f5383700",
"doc_count": 481
},
{
"key": "018963ea3aba7042895b047285c1402e",
"doc_count": 227
},
{
"key": "018963ea20b670278236dc7103bcceb8",
"doc_count": 95
},
{
"key": "018963ea1812737fb7f416641565cd24",
"doc_count": 48
},
{
"key": "018963e5f53b7292b003bf6803f624b7",
"doc_count": 45
},
{
"key": "018bbe13b7757294bf18b34533cada9d",
"doc_count": 45
},
{
"key": "018963ea2bce70d7876c75f434e017d1",
"doc_count": 41
},
{
"key": "01896412d947725f982fc682b748509d",
"doc_count": 41
},
{
"key": "018963ea336b7003ba1d74549036192d",
"doc_count": 40
},
{
"key": "018963ea415c7217b4dc8cb62572ed16",
"doc_count": 35
},
{
"key": "01896411e3007292bbf291a9837a8cc8",
"doc_count": 31
},
{
"key": "018ae9d2bdd473c88477b20ff8be8bb8",
"doc_count": 20
},
{
"key": "018963ea3964707fbbfb35b2b8e8084b",
"doc_count": 15
},
{
"key": "01896411e3af718192fb7f9ee45ad6fb",
"doc_count": 3
},
{
"key": "018bbe1470a8709db3af5581f36bb264",
"doc_count": 3
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "57f85a1341f34ad284dc91714711a009",
"doc_count": 590
},
{
"key": "d8ac016c293145ff9d20f96184a4ad02",
"doc_count": 38
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|