| 1 |
16.19 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":"0189984121fd72c7bb4ddf9df35ba60e"}}}},{"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": 12,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 51,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bd614a95a708e84508b80afcced6b",
"_score": null,
"_source": {
"autoIncrement": 1139489.0,
"id": "018bd614a95a708e84508b80afcced6b"
},
"fields": {
"displayGroup": [
"30f103531a18d34132e8dd367c87d501"
]
},
"sort": [
0,
"018bd614a95a708e84508b80afcced6b"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c88a7b4ef71dea551c6c35be9e63e",
"_score": null,
"_source": {
"autoIncrement": 1171514.0,
"id": "018c88a7b4ef71dea551c6c35be9e63e"
},
"fields": {
"displayGroup": [
"8cdced53591588ea2b3fcd3e73c14508"
]
},
"sort": [
0,
"018c88a7b4ef71dea551c6c35be9e63e"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c88a7d1e27259be2a57f7cd0914ff",
"_score": null,
"_source": {
"autoIncrement": 1171524.0,
"id": "018c88a7d1e27259be2a57f7cd0914ff"
},
"fields": {
"displayGroup": [
"94bd40e51fe7417460648879d7dfde77"
]
},
"sort": [
0,
"018c88a7d1e27259be2a57f7cd0914ff"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c88a81d1272b5a7acdd3dc594698b",
"_score": null,
"_source": {
"autoIncrement": 1171550.0,
"id": "018c88a81d1272b5a7acdd3dc594698b"
},
"fields": {
"displayGroup": [
"790adb134c64e13a271b89cf59bfd77c"
]
},
"sort": [
0,
"018c88a81d1272b5a7acdd3dc594698b"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018cdb25d099714684638c5981c287a7",
"_score": null,
"_source": {
"autoIncrement": 1228815.0,
"id": "018cdb25d099714684638c5981c287a7"
},
"fields": {
"displayGroup": [
"63f7fd7103db247b2502890486540f3c"
]
},
"sort": [
0,
"018cdb25d099714684638c5981c287a7"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018cdc723d35723e96dd8f77b0cc059c",
"_score": null,
"_source": {
"autoIncrement": 1230378.0,
"id": "018cdc723d35723e96dd8f77b0cc059c"
},
"fields": {
"displayGroup": [
"512490bb9c66b4d7fa0e1b2adfe205a3"
]
},
"sort": [
0,
"018cdc723d35723e96dd8f77b0cc059c"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d1db90d0971cd84c77a9e64c853c2",
"_score": null,
"_source": {
"autoIncrement": 1257682.0,
"id": "018d1db90d0971cd84c77a9e64c853c2"
},
"fields": {
"displayGroup": [
"59357aa4c5045be29cfa48d85626a97b"
]
},
"sort": [
0,
"018d1db90d0971cd84c77a9e64c853c2"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d9b71643b7174adf0e442a5370f7d",
"_score": null,
"_source": {
"autoIncrement": 1299151.0,
"id": "018d9b71643b7174adf0e442a5370f7d"
},
"fields": {
"displayGroup": [
"479f0eb1857db02d50c0308ad81c0986"
]
},
"sort": [
0,
"018d9b71643b7174adf0e442a5370f7d"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0190025de95d70d5985383c0519a894f",
"_score": null,
"_source": {
"autoIncrement": 1798852.0,
"id": "0190025de95d70d5985383c0519a894f"
},
"fields": {
"displayGroup": [
"b636faee906158bd21641e56abce1b57"
]
},
"sort": [
0,
"0190025de95d70d5985383c0519a894f"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01988954882772228863b2133b12e7eb",
"_score": null,
"_source": {
"autoIncrement": 1931576.0,
"id": "01988954882772228863b2133b12e7eb"
},
"fields": {
"displayGroup": [
"0522e95d487f2d2fb47bd8d91b48cacc"
]
},
"sort": [
0,
"01988954882772228863b2133b12e7eb"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01988954c3b170c39c9a8b165a6e869e",
"_score": null,
"_source": {
"autoIncrement": 1931580.0,
"id": "01988954c3b170c39c9a8b165a6e869e"
},
"fields": {
"displayGroup": [
"8b6a308c36c44c965902cbea0523625e"
]
},
"sort": [
0,
"01988954c3b170c39c9a8b165a6e869e"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "019889550b4e70db804d8df6ef45e862",
"_score": null,
"_source": {
"autoIncrement": 1931584.0,
"id": "019889550b4e70db804d8df6ef45e862"
},
"fields": {
"displayGroup": [
"0385239b19a11785113054cdee5d4dda"
]
},
"sort": [
0,
"019889550b4e70db804d8df6ef45e862"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0198895548bb73e1a658d6576d7380e6",
"_score": null,
"_source": {
"autoIncrement": 1931588.0,
"id": "0198895548bb73e1a658d6576d7380e6"
},
"fields": {
"displayGroup": [
"2186b8bace9a3bbaede52c8f3103f220"
]
},
"sort": [
0,
"0198895548bb73e1a658d6576d7380e6"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "019889557d3a72b793ea80d2cc825145",
"_score": null,
"_source": {
"autoIncrement": 1931592.0,
"id": "019889557d3a72b793ea80d2cc825145"
},
"fields": {
"displayGroup": [
"531b5679771a1f5793ed64196a1e88ef"
]
},
"sort": [
0,
"019889557d3a72b793ea80d2cc825145"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01988955b267731fbe5504957c77b31e",
"_score": null,
"_source": {
"autoIncrement": 1931596.0,
"id": "01988955b267731fbe5504957c77b31e"
},
"fields": {
"displayGroup": [
"8fea5ec04f789c84cc4bfc61a638e01e"
]
},
"sort": [
0,
"01988955b267731fbe5504957c77b31e"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "3c0b6471afec44e9a85fc978904adcb3",
"_score": null,
"_source": {
"autoIncrement": 1095599.0,
"id": "3c0b6471afec44e9a85fc978904adcb3"
},
"fields": {
"displayGroup": [
"35c038caec906dc86b32ef4a097acd33"
]
},
"sort": [
0,
"3c0b6471afec44e9a85fc978904adcb3"
]
}
]
},
"aggregations": {
"total-count": {
"value": 17
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
10.29 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":"0189984121fd72c7bb4ddf9df35ba60e"}}}},{"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_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": 7,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"max_score": null,
"hits": []
},
"aggregations": {
"shipping-free-filter": {
"doc_count": 6,
"shipping-free": {
"value": 1.0,
"value_as_string": "true"
}
},
"rating-exists": {
"doc_count": 51,
"rating": {
"value": 0.0
}
},
"price": {
"count": 51,
"min": 16.22,
"max": 35.99,
"avg": 24.92294117647059,
"sum": 1271.0700000000002
},
"options": {
"doc_count": 102,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "507f2e527d524e359c477d74d4605b1f",
"doc_count": 18
},
{
"key": "addda850cb3d4d8d819a5a9f16b44b50",
"doc_count": 13
},
{
"key": "5e2f46d53cb046f9a5f9736c372966f8",
"doc_count": 9
},
{
"key": "20db184c1fdb49508a4ccd08b882a19f",
"doc_count": 8
},
{
"key": "60de90a916684ef696e8ba9bd8060cbc",
"doc_count": 8
},
{
"key": "018dd5f6ea6641c7b569a0bef47cdc68",
"doc_count": 5
},
{
"key": "1c23aae651524363801a44213f31f325",
"doc_count": 4
},
{
"key": "af28a8aa799f477fbbaf5eb63f5add5d",
"doc_count": 4
},
{
"key": "2c85f1acf4e648d5830165598cae79ac",
"doc_count": 3
},
{
"key": "987a11805dec4a0e86ea308b5dddd6c4",
"doc_count": 3
},
{
"key": "a8c0afa33a3b4c3395bb83146362f91f",
"doc_count": 3
},
{
"key": "e78c49cf109845568d0b572bddc178c6",
"doc_count": 3
},
{
"key": "30fad97b5aa4443ca76571f675554d6a",
"doc_count": 2
},
{
"key": "861d496ea6e8475a8578cd43a64402a9",
"doc_count": 2
},
{
"key": "018e866f86e8700f803ce73252f7015e",
"doc_count": 1
},
{
"key": "018e866fa3e3728f9f11efbc635381dd",
"doc_count": 1
},
{
"key": "019884b0c5b8739581eb596ee3b91e2a",
"doc_count": 1
},
{
"key": "019884b0d1cc719086995a0366aa5508",
"doc_count": 1
},
{
"key": "019884b0e602727e987ef7de99b608bd",
"doc_count": 1
},
{
"key": "019884b0ebe27036894e1d0c7f406d76",
"doc_count": 1
},
{
"key": "019884b0ec6e704a8799be8e73cd09d1",
"doc_count": 1
},
{
"key": "019884b0f79172d28cd4911a258eecfd",
"doc_count": 1
},
{
"key": "23fdaff90a21450796e4742e46de6553",
"doc_count": 1
},
{
"key": "40fed3f805694634974d360639023835",
"doc_count": 1
},
{
"key": "476d3085cf474460bc2575974a9e29c1",
"doc_count": 1
},
{
"key": "4a1ef1250e6c4a7ca28b4bce6d2d4bac",
"doc_count": 1
},
{
"key": "81afd51fd3d44c2bb251dc61150e30d7",
"doc_count": 1
},
{
"key": "9ed8c9df3da844d29051206290a06d96",
"doc_count": 1
},
{
"key": "cfb5694a62a64f0dbf5ff8df39129fe6",
"doc_count": 1
},
{
"key": "df7e791689574717a8edfae609e4e340",
"doc_count": 1
},
{
"key": "edef8fe807b742ccb87e9f04b73ed2d2",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 180,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "01896412ffc470cbad791a707d399f2c",
"doc_count": 31
},
{
"key": "018963e5f32b703288aad57690802852",
"doc_count": 26
},
{
"key": "018963e5f5e173a4afde33792d6fe12f",
"doc_count": 18
},
{
"key": "01896411ea347043b0788892761b1dff",
"doc_count": 18
},
{
"key": "018bbe13bff4727baa40d87b9df82a76",
"doc_count": 16
},
{
"key": "01896411e82d73ef973f22bb35c69d07",
"doc_count": 15
},
{
"key": "018963ea3aba7042895b047285c1402e",
"doc_count": 10
},
{
"key": "01896411e25971f98272a565102c3faf",
"doc_count": 7
},
{
"key": "018963ea313d732aab9f9437134e1b76",
"doc_count": 5
},
{
"key": "01896411e78a73399a29ed714246da0d",
"doc_count": 5
},
{
"key": "018bbe13bba571c9a39ca3fe33a172cd",
"doc_count": 5
},
{
"key": "018963ea24c172519a11176e570bcae4",
"doc_count": 3
},
{
"key": "018bbe13b8237164810b74768f091ae7",
"doc_count": 3
},
{
"key": "018bbe13b97a72e79ffb27e38f96bbb2",
"doc_count": 3
},
{
"key": "018bbe13bf4971378f6c9737de6890aa",
"doc_count": 3
},
{
"key": "018963ea1812737fb7f416641565cd24",
"doc_count": 2
},
{
"key": "018963ea3964707fbbfb35b2b8e8084b",
"doc_count": 2
},
{
"key": "018dcc3373f47133833772ee8dfc3fe4",
"doc_count": 2
},
{
"key": "018963e5f06f716dadb0fe95b3c53d22",
"doc_count": 1
},
{
"key": "018963e5f3d170e3b0919639e3c92da7",
"doc_count": 1
},
{
"key": "018963ea1e14736f89733679e4ac807d",
"doc_count": 1
},
{
"key": "018963ea415c7217b4dc8cb62572ed16",
"doc_count": 1
},
{
"key": "01896411e59f727b8b482ff954d67fa9",
"doc_count": 1
},
{
"key": "018db3582f287089a20e8df910d67be0",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "69126f5efcab45738b242009148aca51",
"doc_count": 18
},
{
"key": "1a0ffc50b3584a1abd28c2d06d6c6465",
"doc_count": 14
},
{
"key": "38433195e9d345108b1593626fcdaba0",
"doc_count": 13
},
{
"key": "2a606633b77f4e1bab45f45f3483a835",
"doc_count": 5
},
{
"key": "d8ac016c293145ff9d20f96184a4ad02",
"doc_count": 1
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|