| 1 |
13.61 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":"018997a60b4d718b8e179774daa245ae"}}}},{"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": 10,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 308,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_all4team_product_1716336301",
"_id": "018af45e8bd07264b5f505a0dac5e5bd",
"_score": null,
"_source": {
"autoIncrement": 1131049.0,
"id": "018af45e8bd07264b5f505a0dac5e5bd"
},
"fields": {
"displayGroup": [
"5e7ea966aabdf7caf0e6d42320ebd071"
]
},
"sort": [
0,
"018af45e8bd07264b5f505a0dac5e5bd"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018af47f88a97059b52c633ece48ac6d",
"_score": null,
"_source": {
"autoIncrement": 1133677.0,
"id": "018af47f88a97059b52c633ece48ac6d"
},
"fields": {
"displayGroup": [
"e51d2902007523419b35ab527d4b87b4"
]
},
"sort": [
0,
"018af47f88a97059b52c633ece48ac6d"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bce1a535f73f29d4abc76169685bd",
"_score": null,
"_source": {
"autoIncrement": 1135992.0,
"id": "018bce1a535f73f29d4abc76169685bd"
},
"fields": {
"displayGroup": [
"a2cab2b93d446722a145b97fd88a2cb6"
]
},
"sort": [
0,
"018bce1a535f73f29d4abc76169685bd"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bd02d399572adadb13d526bc7414a",
"_score": null,
"_source": {
"autoIncrement": 1136355.0,
"id": "018bd02d399572adadb13d526bc7414a"
},
"fields": {
"displayGroup": [
"db1fff00368906fd81d3fb6a8dbba7f2"
]
},
"sort": [
0,
"018bd02d399572adadb13d526bc7414a"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7f06e2fa707c8ee3d5cdc542adc6",
"_score": null,
"_source": {
"autoIncrement": 1162464.0,
"id": "018c7f06e2fa707c8ee3d5cdc542adc6"
},
"fields": {
"displayGroup": [
"edd8c9988b3e582b5365abb2fbeb2d4e"
]
},
"sort": [
0,
"018c7f06e2fa707c8ee3d5cdc542adc6"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c80dde57373dd8ccf601e346f4bb1",
"_score": null,
"_source": {
"autoIncrement": 1164915.0,
"id": "018c80dde57373dd8ccf601e346f4bb1"
},
"fields": {
"displayGroup": [
"1013fed912ad0b0ac666b0db166395c9"
]
},
"sort": [
0,
"018c80dde57373dd8ccf601e346f4bb1"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c888f17b772cc88e47128ff03bec4",
"_score": null,
"_source": {
"autoIncrement": 1169125.0,
"id": "018c888f17b772cc88e47128ff03bec4"
},
"fields": {
"displayGroup": [
"db2dccd5288b2aa150ab84ffd05c7dc6"
]
},
"sort": [
0,
"018c888f17b772cc88e47128ff03bec4"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d99111c75707190dd963f8e60be3f",
"_score": null,
"_source": {
"autoIncrement": 1293021.0,
"id": "018d99111c75707190dd963f8e60be3f"
},
"fields": {
"displayGroup": [
"dc5f080d1e45b52170f5f74b980ec1a1"
]
},
"sort": [
0,
"018d99111c75707190dd963f8e60be3f"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d993c45c072269b13723e1d2b4924",
"_score": null,
"_source": {
"autoIncrement": 1293459.0,
"id": "018d993c45c072269b13723e1d2b4924"
},
"fields": {
"displayGroup": [
"5bb8325644ad27b973c5ae2a16880be2"
]
},
"sort": [
0,
"018d993c45c072269b13723e1d2b4924"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01904f9e9662719fa09804d4cd32dd7a",
"_score": null,
"_source": {
"autoIncrement": 1805604.0,
"id": "01904f9e9662719fa09804d4cd32dd7a"
},
"fields": {
"displayGroup": [
"90ff0609c1f8421a35d3f63c77f4967c"
]
},
"sort": [
0,
"01904f9e9662719fa09804d4cd32dd7a"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01909c4f843072d1830ad2c0ab9bacb7",
"_score": null,
"_source": {
"autoIncrement": 1825495.0,
"id": "01909c4f843072d1830ad2c0ab9bacb7"
},
"fields": {
"displayGroup": [
"edb38dcd2a74872db3bc54c4377b4617"
]
},
"sort": [
0,
"01909c4f843072d1830ad2c0ab9bacb7"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01909c4ff36671d499fc64e5442b8a3a",
"_score": null,
"_source": {
"autoIncrement": 1825529.0,
"id": "01909c4ff36671d499fc64e5442b8a3a"
},
"fields": {
"displayGroup": [
"22b2a7adb687170d10e8a04fb0f07755"
]
},
"sort": [
0,
"01909c4ff36671d499fc64e5442b8a3a"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0190a6d4104a70cc81c9a44110810934",
"_score": null,
"_source": {
"autoIncrement": 1836701.0,
"id": "0190a6d4104a70cc81c9a44110810934"
},
"fields": {
"displayGroup": [
"f8909ec015584e411879be2dbc984b87"
]
},
"sort": [
0,
"0190a6d4104a70cc81c9a44110810934"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0190a6d658d972c49994747c74b590ed",
"_score": null,
"_source": {
"autoIncrement": 1837039.0,
"id": "0190a6d658d972c49994747c74b590ed"
},
"fields": {
"displayGroup": [
"9c0b776123776c70e20ec3c4ad6a5d3b"
]
},
"sort": [
0,
"0190a6d658d972c49994747c74b590ed"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0190a6dcc3e071b688a5fdd4e350f470",
"_score": null,
"_source": {
"autoIncrement": 1837956.0,
"id": "0190a6dcc3e071b688a5fdd4e350f470"
},
"fields": {
"displayGroup": [
"8d80434a8983e4548471f572f9a88fb4"
]
},
"sort": [
0,
"0190a6dcc3e071b688a5fdd4e350f470"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0190a6dce17d72e283b03f23689c6125",
"_score": null,
"_source": {
"autoIncrement": 1837977.0,
"id": "0190a6dce17d72e283b03f23689c6125"
},
"fields": {
"displayGroup": [
"bc9dfaf4b0ca6a1262489d8f1ffbd29a"
]
},
"sort": [
0,
"0190a6dce17d72e283b03f23689c6125"
]
}
]
},
"aggregations": {
"total-count": {
"value": 23
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
8.25 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":"018997a60b4d718b8e179774daa245ae"}}}},{"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": 6,
"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
}
},
"rating-exists": {
"doc_count": 308,
"rating": {
"value": 0.0
}
},
"price": {
"count": 308,
"min": 59.99,
"max": 216.0,
"avg": 153.12626623376624,
"sum": 47162.89
},
"options": {
"doc_count": 616,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "018d7967562073d29d87ac0d1805a758",
"doc_count": 55
},
{
"key": "018dcc33ef3e71b98f00b79ebc1d3165",
"doc_count": 40
},
{
"key": "98d6bcd6d5da4c45a80c847b8f441853",
"doc_count": 23
},
{
"key": "01909baa289473c988f5798b39a2ba9c",
"doc_count": 21
},
{
"key": "24825ae0f7ff41bdbddc49e34931df58",
"doc_count": 21
},
{
"key": "2ef77dd834ab4ad8bf116883a3624328",
"doc_count": 21
},
{
"key": "6f242ff7ed204f40be74447de407e8b9",
"doc_count": 21
},
{
"key": "f166e204f18a46cd947eb253dc245521",
"doc_count": 21
},
{
"key": "2187203b11f344b6a815ba773a93bb44",
"doc_count": 20
},
{
"key": "3093f1af1d8642c5ac39bb2ecc9ee2b1",
"doc_count": 20
},
{
"key": "528d738a30b847248434b14e905cd91c",
"doc_count": 20
},
{
"key": "799eeec01566421399f0186a0c1929ae",
"doc_count": 20
},
{
"key": "c4ca7c83d7b9434dba35d808f3cb587b",
"doc_count": 20
},
{
"key": "018d7967fbc47234a7737c0c64fb6b7a",
"doc_count": 19
},
{
"key": "2055b8652dba4a38bb12157ef8bd8e7c",
"doc_count": 19
},
{
"key": "d32f5d7c6ff24f32ac2cef76583b3ff3",
"doc_count": 19
},
{
"key": "018c690369a9714988c0ae7e113fee13",
"doc_count": 17
},
{
"key": "fb2bcb1d04544f8e91cab9caadccd0e2",
"doc_count": 17
},
{
"key": "e1b2548665464da9b4f051e46c78427f",
"doc_count": 16
},
{
"key": "018d79675466735989015568610f58b3",
"doc_count": 15
},
{
"key": "fefc7b01e0504b2fb7aa23b3115fe4f8",
"doc_count": 14
},
{
"key": "018c690374bb738aa0421895b19398ff",
"doc_count": 13
},
{
"key": "c36af3803d914e8bb422246a1b400a68",
"doc_count": 13
},
{
"key": "01909baa4d9072658b9722deb8eea0a6",
"doc_count": 12
},
{
"key": "cca87ab4cab5470f85b32ce2b3269b1e",
"doc_count": 12
},
{
"key": "01909baa8a5e71d19a057b33fe293e3d",
"doc_count": 11
},
{
"key": "64a44b3d85144a88b890b250e7030d5f",
"doc_count": 11
},
{
"key": "01909baa426d72e6a4ee1d0950c74af3",
"doc_count": 10
},
{
"key": "0190da3aa17072389aa7eb2bb7f19c1e",
"doc_count": 10
},
{
"key": "7189e238f66c4db8831ad403f65df75e",
"doc_count": 8
},
{
"key": "a5d7196c2514479f857621c32bb84608",
"doc_count": 8
},
{
"key": "c0088ccb433c49aaadfc61d1966f804c",
"doc_count": 8
},
{
"key": "c2725e1f949d43afafbd92ebcdce5798",
"doc_count": 8
},
{
"key": "97610a9e8a0f4970a7be7eec0bac0378",
"doc_count": 7
},
{
"key": "b5a3d8c7138344dda67987a4eff4cb1c",
"doc_count": 7
},
{
"key": "b9098912ba704078bf6482acae250e23",
"doc_count": 4
},
{
"key": "019091974b0f73d88d5927c8ac9dc0f6",
"doc_count": 3
},
{
"key": "0190a0f0f1ae72fa8bf68020f89be56d",
"doc_count": 3
},
{
"key": "04fba7aa2b5e4d4ba49f6e2464da8644",
"doc_count": 3
},
{
"key": "01909baa8de17351bcc7515ba3f6e4d4",
"doc_count": 2
},
{
"key": "209a3a1ec0e146688922fb9d78b72f61",
"doc_count": 2
},
{
"key": "01900205879f7248867868c412fc658d",
"doc_count": 1
},
{
"key": "01909baa7830735b8922c00ab7cb2dfc",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 1141,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "0189641275be72e7941246e7b15d1e76",
"doc_count": 241
},
{
"key": "018963e5f13871739bde1b0eb26bb21b",
"doc_count": 196
},
{
"key": "01896411e11071498f66a862f5383700",
"doc_count": 152
},
{
"key": "018963e5f53b7292b003bf6803f624b7",
"doc_count": 112
},
{
"key": "01896411e3007292bbf291a9837a8cc8",
"doc_count": 76
},
{
"key": "018963ea3aba7042895b047285c1402e",
"doc_count": 67
},
{
"key": "018963ea20b670278236dc7103bcceb8",
"doc_count": 55
},
{
"key": "018963ea336b7003ba1d74549036192d",
"doc_count": 40
},
{
"key": "018963ea1812737fb7f416641565cd24",
"doc_count": 35
},
{
"key": "01896411e3af718192fb7f9ee45ad6fb",
"doc_count": 32
},
{
"key": "018bbe147153736fbaa17cb7d91264a8",
"doc_count": 32
},
{
"key": "018963ea2bce70d7876c75f434e017d1",
"doc_count": 22
},
{
"key": "01896412d947725f982fc682b748509d",
"doc_count": 22
},
{
"key": "018963ea1aa171879381a1be09d5fd97",
"doc_count": 20
},
{
"key": "018dc71933ba73f29d979240d3813950",
"doc_count": 18
},
{
"key": "018963ea3609712896e2d21c3a2d91ab",
"doc_count": 17
},
{
"key": "018963ea415c7217b4dc8cb62572ed16",
"doc_count": 2
},
{
"key": "018abc1fb8d371e781e6c47ddfe830f7",
"doc_count": 1
},
{
"key": "018abc1fc4cd70a9b7819ff882124c97",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "57f85a1341f34ad284dc91714711a009",
"doc_count": 175
},
{
"key": "d8ac016c293145ff9d20f96184a4ad02",
"doc_count": 124
},
{
"key": "6f10e4ac0c444f1a91667bad688d924f",
"doc_count": 9
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|