| 1 |
10.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":"018997fffd4d71dda8670dbec08c9711"}}}},{"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": 7,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 1111,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_all4team_product_1716336301",
"_id": "018af47d4d567081a4e48b9b7d827283",
"_score": null,
"_source": {
"autoIncrement": 1133409.0,
"id": "018af47d4d567081a4e48b9b7d827283"
},
"fields": {
"displayGroup": [
"6be3074ab6ca8948bd8fbd711cc87805"
]
},
"sort": [
0,
"018af47d4d567081a4e48b9b7d827283"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018af47ddd9b730285843418cbbe7bdb",
"_score": null,
"_source": {
"autoIncrement": 1133462.0,
"id": "018af47ddd9b730285843418cbbe7bdb"
},
"fields": {
"displayGroup": [
"89c3a06a308eaf50c51d5bcf0276f1b4"
]
},
"sort": [
0,
"018af47ddd9b730285843418cbbe7bdb"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018af47f054373a18ff188fbf6786924",
"_score": null,
"_source": {
"autoIncrement": 1133598.0,
"id": "018af47f054373a18ff188fbf6786924"
},
"fields": {
"displayGroup": [
"1b532d39784c967d1f3ec5acbe6fed8c"
]
},
"sort": [
0,
"018af47f054373a18ff188fbf6786924"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018af47f314671708978e492dba0d64e",
"_score": null,
"_source": {
"autoIncrement": 1133621.0,
"id": "018af47f314671708978e492dba0d64e"
},
"fields": {
"displayGroup": [
"4b710bf80a6dd979f3709513f1db3e3e"
]
},
"sort": [
0,
"018af47f314671708978e492dba0d64e"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018af47f420970209b7592307a55cc14",
"_score": null,
"_source": {
"autoIncrement": 1133633.0,
"id": "018af47f420970209b7592307a55cc14"
},
"fields": {
"displayGroup": [
"83369f7233ee80e0fa0c5cf49af31a96"
]
},
"sort": [
0,
"018af47f420970209b7592307a55cc14"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018af47f78e77085b1d18381a08b7a57",
"_score": null,
"_source": {
"autoIncrement": 1133663.0,
"id": "018af47f78e77085b1d18381a08b7a57"
},
"fields": {
"displayGroup": [
"28f582a2605c264ed1849ebefd9e16ea"
]
},
"sort": [
0,
"018af47f78e77085b1d18381a08b7a57"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018af47f9e0b70679bea12cabdbc9651",
"_score": null,
"_source": {
"autoIncrement": 1133690.0,
"id": "018af47f9e0b70679bea12cabdbc9651"
},
"fields": {
"displayGroup": [
"16bbd8d067aaffef841761407accff02"
]
},
"sort": [
0,
"018af47f9e0b70679bea12cabdbc9651"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018b3c64fe127180ab3d1b04b8ef8c58",
"_score": null,
"_source": {
"autoIncrement": 1133768.0,
"id": "018b3c64fe127180ab3d1b04b8ef8c58"
},
"fields": {
"displayGroup": [
"560d6f79d0dc0498b624e6ffb987f58b"
]
},
"sort": [
0,
"018b3c64fe127180ab3d1b04b8ef8c58"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018b3c650bcc732781a6db50e333fc16",
"_score": null,
"_source": {
"autoIncrement": 1133778.0,
"id": "018b3c650bcc732781a6db50e333fc16"
},
"fields": {
"displayGroup": [
"43982f38848bb5d5041ef88067d6b6c7"
]
},
"sort": [
0,
"018b3c650bcc732781a6db50e333fc16"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bd029c220719e898bfd245dd5fe36",
"_score": null,
"_source": {
"autoIncrement": 1136293.0,
"id": "018bd029c220719e898bfd245dd5fe36"
},
"fields": {
"displayGroup": [
"b56971103c9ea06caf2d55207faf4184"
]
},
"sort": [
0,
"018bd029c220719e898bfd245dd5fe36"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018cd04310b273f6914d7eef1ce5f25e",
"_score": null,
"_source": {
"autoIncrement": 1223300.0,
"id": "018cd04310b273f6914d7eef1ce5f25e"
},
"fields": {
"displayGroup": [
"83a98443b8ce7f3e475ce716fd837a64"
]
},
"sort": [
0,
"018cd04310b273f6914d7eef1ce5f25e"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d798d76ad71fd84dc00be0ecf778c",
"_score": null,
"_source": {
"autoIncrement": 1273651.0,
"id": "018d798d76ad71fd84dc00be0ecf778c"
},
"fields": {
"displayGroup": [
"77adbc5eb8e709dc9be36cf9a2334e51"
]
},
"sort": [
0,
"018d798d76ad71fd84dc00be0ecf778c"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d7c1bfe594b9ba5225c02ee0d006a",
"_score": null,
"_source": {
"autoIncrement": 1130481.0,
"id": "018d7c1bfe594b9ba5225c02ee0d006a"
},
"fields": {
"displayGroup": [
"7ff42d135b9fbc8f366ea6950f7c83d0"
]
},
"sort": [
0,
"018d7c1bfe594b9ba5225c02ee0d006a"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d895daca0717e8d95934f03aa0185",
"_score": null,
"_source": {
"autoIncrement": 1277899.0,
"id": "018d895daca0717e8d95934f03aa0185"
},
"fields": {
"displayGroup": [
"d70d59b9667c28debc75f12e8d8ff651"
]
},
"sort": [
0,
"018d895daca0717e8d95934f03aa0185"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d898cdb5a7287932358f787736449",
"_score": null,
"_source": {
"autoIncrement": 1277944.0,
"id": "018d898cdb5a7287932358f787736449"
},
"fields": {
"displayGroup": [
"7efcbe34b9b5db9ef3642cb69065049a"
]
},
"sort": [
0,
"018d898cdb5a7287932358f787736449"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d99048458734fa41ff46cd3455329",
"_score": null,
"_source": {
"autoIncrement": 1292835.0,
"id": "018d99048458734fa41ff46cd3455329"
},
"fields": {
"displayGroup": [
"8815c51c296719b8d15ab408584f17e5"
]
},
"sort": [
0,
"018d99048458734fa41ff46cd3455329"
]
}
]
},
"aggregations": {
"total-count": {
"value": 84
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
12.24 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":"018997fffd4d71dda8670dbec08c9711"}}}},{"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": 10,
"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": 1111,
"rating": {
"value": 0.0
}
},
"price": {
"count": 1111,
"min": 27.99,
"max": 104.0,
"avg": 58.299261926192614,
"sum": 64770.479999999996
},
"options": {
"doc_count": 2222,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "018d79675466735989015568610f58b3",
"doc_count": 108
},
{
"key": "018d7967562073d29d87ac0d1805a758",
"doc_count": 90
},
{
"key": "018dcc33ef3e71b98f00b79ebc1d3165",
"doc_count": 90
},
{
"key": "018dcc33f84c71f49a5cfac761b33f39",
"doc_count": 90
},
{
"key": "c2d0a920e328481db842b8da42b54bc1",
"doc_count": 90
},
{
"key": "7189e238f66c4db8831ad403f65df75e",
"doc_count": 72
},
{
"key": "cca87ab4cab5470f85b32ce2b3269b1e",
"doc_count": 70
},
{
"key": "b5a3d8c7138344dda67987a4eff4cb1c",
"doc_count": 69
},
{
"key": "97610a9e8a0f4970a7be7eec0bac0378",
"doc_count": 68
},
{
"key": "a132823eaf34421c82c307567af7ec32",
"doc_count": 68
},
{
"key": "a5d7196c2514479f857621c32bb84608",
"doc_count": 68
},
{
"key": "c0088ccb433c49aaadfc61d1966f804c",
"doc_count": 68
},
{
"key": "549603b6c17f42a595c6cd3e44675888",
"doc_count": 65
},
{
"key": "b333e4fbe005414bb4cb752913be4b46",
"doc_count": 64
},
{
"key": "d39074020fe54e79ab8a2c3c1db6c411",
"doc_count": 63
},
{
"key": "7d02ec05b3f54d9aa4afe8e13731ce4c",
"doc_count": 60
},
{
"key": "493cae969e0b4e75a2e4272d2a6fa240",
"doc_count": 59
},
{
"key": "a053c882e22f4d3e96fe143b7f870cc4",
"doc_count": 59
},
{
"key": "13aa12d0ba23429a91307cd1c7ab8897",
"doc_count": 57
},
{
"key": "a9cad9e916b7460b887df2bcef6f7cae",
"doc_count": 57
},
{
"key": "649a663803e842b1a413e97fac062e26",
"doc_count": 55
},
{
"key": "018d796752da71d4bc16000988e14500",
"doc_count": 54
},
{
"key": "018dcc33bba1712fa8626be89716f904",
"doc_count": 54
},
{
"key": "018dcc33d1f4700f9e35e85caff09a05",
"doc_count": 54
},
{
"key": "018d7967553a72ca97faf14b9d69a419",
"doc_count": 53
},
{
"key": "24e9a79fae5e4d58b20fd03ed636782c",
"doc_count": 51
},
{
"key": "3e6f2c0acacf4984a857b40c34a28d92",
"doc_count": 48
},
{
"key": "0ce57e954af348fc877968b48409adc4",
"doc_count": 45
},
{
"key": "01900205879f7248867868c412fc658d",
"doc_count": 38
},
{
"key": "018dcc33c4b7721b8cf66e4fa3b80686",
"doc_count": 36
},
{
"key": "018dcc33e46a716389ec321e2e2e86ab",
"doc_count": 35
},
{
"key": "01901bd3339372b696de1abd019141c9",
"doc_count": 34
},
{
"key": "a3c0ad99cd1742e485ac4f5f5773c6e0",
"doc_count": 27
},
{
"key": "018dcc33c6d373d890cb382f67400f5e",
"doc_count": 18
},
{
"key": "018d796753a4710b85d12880bdf47b61",
"doc_count": 17
},
{
"key": "018dcc33bdc470a6bef547ac387fbbc2",
"doc_count": 17
},
{
"key": "0190020586ce702ab69a9dbdbddfffac",
"doc_count": 15
},
{
"key": "ac41845e2c4d4fd0b3d810c2bc2b2424",
"doc_count": 15
},
{
"key": "01909baa6cbc71deaaf0a7271455cdca",
"doc_count": 14
},
{
"key": "b4bcc055f4b34f45ac8470f8a86812a3",
"doc_count": 14
},
{
"key": "0190a0efc722732aa975d92e09a5aa69",
"doc_count": 11
},
{
"key": "01909baa289473c988f5798b39a2ba9c",
"doc_count": 10
},
{
"key": "244643826ccc4cac848503d25e7f66ac",
"doc_count": 10
},
{
"key": "f7a15cf3177a47d2b3a4ec13cd3f3e2d",
"doc_count": 9
},
{
"key": "019afb4baa7a4bb99438f94850b0bd02",
"doc_count": 7
},
{
"key": "f505309076a94d57a37b9db180cd1f6f",
"doc_count": 6
},
{
"key": "76a5f76869624203b8e698161857fecc",
"doc_count": 5
},
{
"key": "01909baa4d9072658b9722deb8eea0a6",
"doc_count": 3
},
{
"key": "7827356c7cce40bb96677fa33f721a63",
"doc_count": 3
},
{
"key": "1239d8c2b0774f95bec8ca2120ad7876",
"doc_count": 2
},
{
"key": "2583d76ffb214c698f2349408c44cb61",
"doc_count": 2
},
{
"key": "3ded9781c61c4c91bc85327563d81658",
"doc_count": 2
},
{
"key": "62e1f91b41a448959bdf7061be0480d9",
"doc_count": 2
},
{
"key": "6baf2833d657438ab806b77e54b3f17a",
"doc_count": 2
},
{
"key": "a1b16c0b889547219de3c5a29864a17b",
"doc_count": 2
},
{
"key": "c387c84465444c94b5ccef204f837adf",
"doc_count": 2
},
{
"key": "e3ead7ae02be4a8b9b23ef32cd363a30",
"doc_count": 2
},
{
"key": "018c690369a9714988c0ae7e113fee13",
"doc_count": 1
},
{
"key": "018c6903773872409266c11b029009c9",
"doc_count": 1
},
{
"key": "018c69038764708789affe7ed0a20b95",
"doc_count": 1
},
{
"key": "018d7967c91c71f49a7f42a2fe7a5099",
"doc_count": 1
},
{
"key": "018d7967f3bd70adb1f3840f90880f22",
"doc_count": 1
},
{
"key": "01909baa7787700aa1a69f48d387f0d4",
"doc_count": 1
},
{
"key": "0818c1d6fd154fd88b414d5ab92d52a0",
"doc_count": 1
},
{
"key": "0b2b79c9ecbd4a9586ee38b2cb6caf9c",
"doc_count": 1
},
{
"key": "25148b6f5f0d491d8c6f8797b4c6543d",
"doc_count": 1
},
{
"key": "30bb2cef2b2d4afeb0e77bed6ac48d29",
"doc_count": 1
},
{
"key": "32379b13453543bf9d8e18506c4e2110",
"doc_count": 1
},
{
"key": "76cbf24ec403419ba1a22497d3682735",
"doc_count": 1
},
{
"key": "c36af3803d914e8bb422246a1b400a68",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 3918,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "018963e5f32b703288aad57690802852",
"doc_count": 998
},
{
"key": "01896412751a72d6bee9f7d197ea92d6",
"doc_count": 892
},
{
"key": "01896411e11071498f66a862f5383700",
"doc_count": 707
},
{
"key": "018963ea3aba7042895b047285c1402e",
"doc_count": 213
},
{
"key": "018963ea20b670278236dc7103bcceb8",
"doc_count": 179
},
{
"key": "018963ea415c7217b4dc8cb62572ed16",
"doc_count": 107
},
{
"key": "01896411e3007292bbf291a9837a8cc8",
"doc_count": 104
},
{
"key": "018963ea1812737fb7f416641565cd24",
"doc_count": 91
},
{
"key": "018963ea336b7003ba1d74549036192d",
"doc_count": 90
},
{
"key": "01896412d947725f982fc682b748509d",
"doc_count": 63
},
{
"key": "018963e5f53b7292b003bf6803f624b7",
"doc_count": 58
},
{
"key": "018dcc3373f47133833772ee8dfc3fe4",
"doc_count": 56
},
{
"key": "018bbe13b7757294bf18b34533cada9d",
"doc_count": 53
},
{
"key": "018ae9d2bdd473c88477b20ff8be8bb8",
"doc_count": 50
},
{
"key": "018963ea2bce70d7876c75f434e017d1",
"doc_count": 49
},
{
"key": "01896411e3af718192fb7f9ee45ad6fb",
"doc_count": 41
},
{
"key": "018bbe147153736fbaa17cb7d91264a8",
"doc_count": 41
},
{
"key": "018ae9d2c01971b285b979f0f9f8ef4e",
"doc_count": 36
},
{
"key": "018963ea3964707fbbfb35b2b8e8084b",
"doc_count": 18
},
{
"key": "0189641279ce7072af03a49b888f5da8",
"doc_count": 18
},
{
"key": "0190a6bca60c70d6979f3a69eb39a7e8",
"doc_count": 17
},
{
"key": "018bbe13b6c57304b719d27003780cfe",
"doc_count": 16
},
{
"key": "018963ea1aa171879381a1be09d5fd97",
"doc_count": 14
},
{
"key": "018963e5f13871739bde1b0eb26bb21b",
"doc_count": 2
},
{
"key": "01896411e4587305baecfc84ebf67bc3",
"doc_count": 2
},
{
"key": "018964127d2f70199be2f899e07364a1",
"doc_count": 2
},
{
"key": "018963ea3609712896e2d21c3a2d91ab",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "57f85a1341f34ad284dc91714711a009",
"doc_count": 1076
},
{
"key": "d8ac016c293145ff9d20f96184a4ad02",
"doc_count": 35
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|