| 1 |
15.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":"018998528e767060a898e7bdf05be803"}}}},{"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": 138,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_all4team_product_1716336301",
"_id": "0016475b0e7740cdb62c333e16e41c45",
"_score": null,
"_source": {
"autoIncrement": 1021901.0,
"id": "0016475b0e7740cdb62c333e16e41c45"
},
"fields": {
"displayGroup": [
"9c1c1f4e7b83171612374ec59b90a952"
]
},
"sort": [
0,
"0016475b0e7740cdb62c333e16e41c45"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018cdb413aaf7318a2f7c9306d033de9",
"_score": null,
"_source": {
"autoIncrement": 1228830.0,
"id": "018cdb413aaf7318a2f7c9306d033de9"
},
"fields": {
"displayGroup": [
"5a1b244430daffa009c2913fb2948c84"
]
},
"sort": [
0,
"018cdb413aaf7318a2f7c9306d033de9"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018cdb450d3e7130a1ada620037807db",
"_score": null,
"_source": {
"autoIncrement": 1228846.0,
"id": "018cdb450d3e7130a1ada620037807db"
},
"fields": {
"displayGroup": [
"438d0fd7edda11de4a198377f2fbc217"
]
},
"sort": [
0,
"018cdb450d3e7130a1ada620037807db"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018ce32d5ffe70be94b282ac34e1afe2",
"_score": null,
"_source": {
"autoIncrement": 1234401.0,
"id": "018ce32d5ffe70be94b282ac34e1afe2"
},
"fields": {
"displayGroup": [
"0cb21c1e1203cb819d8672d8c10a2d7f"
]
},
"sort": [
0,
"018ce32d5ffe70be94b282ac34e1afe2"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018ce330ca1a73ba9f9a3fec3d9023ec",
"_score": null,
"_source": {
"autoIncrement": 1234431.0,
"id": "018ce330ca1a73ba9f9a3fec3d9023ec"
},
"fields": {
"displayGroup": [
"87c407b919902fd8dd1af10e4522b05a"
]
},
"sort": [
0,
"018ce330ca1a73ba9f9a3fec3d9023ec"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018ce3325e6c72cf87d2a9c60b4d711b",
"_score": null,
"_source": {
"autoIncrement": 1234440.0,
"id": "018ce3325e6c72cf87d2a9c60b4d711b"
},
"fields": {
"displayGroup": [
"49f110f6fe71c27fcf093a62c9a05302"
]
},
"sort": [
0,
"018ce3325e6c72cf87d2a9c60b4d711b"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018ce3360e7673b98c38655ed781a9f1",
"_score": null,
"_source": {
"autoIncrement": 1234471.0,
"id": "018ce3360e7673b98c38655ed781a9f1"
},
"fields": {
"displayGroup": [
"344037751e2b42b8bfe64ce7493061b9"
]
},
"sort": [
0,
"018ce3360e7673b98c38655ed781a9f1"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018ce337526d709f8fa96aeb3d7f4c49",
"_score": null,
"_source": {
"autoIncrement": 1234483.0,
"id": "018ce337526d709f8fa96aeb3d7f4c49"
},
"fields": {
"displayGroup": [
"e02bbd67b73a491e87e9716461b9d59d"
]
},
"sort": [
0,
"018ce337526d709f8fa96aeb3d7f4c49"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018ce3378bb37005a7ac893e84713ff2",
"_score": null,
"_source": {
"autoIncrement": 1234487.0,
"id": "018ce3378bb37005a7ac893e84713ff2"
},
"fields": {
"displayGroup": [
"e4eb7e42b3dad0ac5fb4e79853e30067"
]
},
"sort": [
0,
"018ce3378bb37005a7ac893e84713ff2"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d10aaab3a70a3ac12ca89f3ae06c8",
"_score": null,
"_source": {
"autoIncrement": 1241818.0,
"id": "018d10aaab3a70a3ac12ca89f3ae06c8"
},
"fields": {
"displayGroup": [
"723ec8472e08cf22a8894db03e35981d"
]
},
"sort": [
0,
"018d10aaab3a70a3ac12ca89f3ae06c8"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d114c014270d9a0ad737cc62ac223",
"_score": null,
"_source": {
"autoIncrement": 1244576.0,
"id": "018d114c014270d9a0ad737cc62ac223"
},
"fields": {
"displayGroup": [
"a31d78125683c729b98713a429814526"
]
},
"sort": [
0,
"018d114c014270d9a0ad737cc62ac223"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d114db707705aa7dc003ebe04b41f",
"_score": null,
"_source": {
"autoIncrement": 1244619.0,
"id": "018d114db707705aa7dc003ebe04b41f"
},
"fields": {
"displayGroup": [
"7f345bbf3b2aafe37093fa134b544a4c"
]
},
"sort": [
0,
"018d114db707705aa7dc003ebe04b41f"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d115f18e071dab35d5f43d41ddf6d",
"_score": null,
"_source": {
"autoIncrement": 1244958.0,
"id": "018d115f18e071dab35d5f43d41ddf6d"
},
"fields": {
"displayGroup": [
"5bd6bd7cd48fb18ad09e9e776e9b88ba"
]
},
"sort": [
0,
"018d115f18e071dab35d5f43d41ddf6d"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d1748239c72469727c28bae315a88",
"_score": null,
"_source": {
"autoIncrement": 1252996.0,
"id": "018d1748239c72469727c28bae315a88"
},
"fields": {
"displayGroup": [
"4db1bfaf457ed9e3635cd513a0e450fc"
]
},
"sort": [
0,
"018d1748239c72469727c28bae315a88"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d98d3b7da7028a37ac357fdc4dbfe",
"_score": null,
"_source": {
"autoIncrement": 1291767.0,
"id": "018d98d3b7da7028a37ac357fdc4dbfe"
},
"fields": {
"displayGroup": [
"8d7b3b11a4179cd8fbcf6ca98b1fe3da"
]
},
"sort": [
0,
"018d98d3b7da7028a37ac357fdc4dbfe"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d9bedad71702baec3f792dd6c0dca",
"_score": null,
"_source": {
"autoIncrement": 1301805.0,
"id": "018d9bedad71702baec3f792dd6c0dca"
},
"fields": {
"displayGroup": [
"228a3af0cb32f2313b0c9412c4200f35"
]
},
"sort": [
0,
"018d9bedad71702baec3f792dd6c0dca"
]
}
]
},
"aggregations": {
"total-count": {
"value": 21
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
12.62 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":"018998528e767060a898e7bdf05be803"}}}},{"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": 0,
"shipping-free": {
"value": null
}
},
"rating-exists": {
"doc_count": 138,
"rating": {
"value": 0.0
}
},
"price": {
"count": 138,
"min": 13.46,
"max": 49.46,
"avg": 34.82688405797102,
"sum": 4806.110000000001
},
"options": {
"doc_count": 274,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "1c23aae651524363801a44213f31f325",
"doc_count": 25
},
{
"key": "064439ae09c14e1aad7c74e176cfef4f",
"doc_count": 13
},
{
"key": "0bc3b8ff11d44f1b86b39e6e7b1bc3a4",
"doc_count": 13
},
{
"key": "13778f1f0f7542e9873538c46cc1af87",
"doc_count": 13
},
{
"key": "21d23887998c46edafa7d3eb2b3116d6",
"doc_count": 13
},
{
"key": "0ba48fdc65a64eaca8fb2faa0f87861f",
"doc_count": 11
},
{
"key": "a05b35fcb0114033a469ff047a0b9349",
"doc_count": 10
},
{
"key": "13aa12d0ba23429a91307cd1c7ab8897",
"doc_count": 9
},
{
"key": "493cae969e0b4e75a2e4272d2a6fa240",
"doc_count": 9
},
{
"key": "7d02ec05b3f54d9aa4afe8e13731ce4c",
"doc_count": 9
},
{
"key": "b9098912ba704078bf6482acae250e23",
"doc_count": 9
},
{
"key": "d39074020fe54e79ab8a2c3c1db6c411",
"doc_count": 9
},
{
"key": "dff453c781a343db802aba3434932eb3",
"doc_count": 9
},
{
"key": "a9cad9e916b7460b887df2bcef6f7cae",
"doc_count": 8
},
{
"key": "549603b6c17f42a595c6cd3e44675888",
"doc_count": 7
},
{
"key": "a053c882e22f4d3e96fe143b7f870cc4",
"doc_count": 7
},
{
"key": "b333e4fbe005414bb4cb752913be4b46",
"doc_count": 7
},
{
"key": "29b5ae909a2044589870afe7895f5e2b",
"doc_count": 6
},
{
"key": "cf7179d03f394a93ada8b8f065cab004",
"doc_count": 5
},
{
"key": "018d7968a8a9720c9dfd30cfd353e3b4",
"doc_count": 4
},
{
"key": "018d796942a0718db6a5d055c2df44e7",
"doc_count": 4
},
{
"key": "3538488ca4684d5eb288c947a2819a2c",
"doc_count": 4
},
{
"key": "476d3085cf474460bc2575974a9e29c1",
"doc_count": 4
},
{
"key": "93fee3ed40e24fa69a3584d7c66bc340",
"doc_count": 4
},
{
"key": "be28c3ef2f744318a13f72f200abfc9a",
"doc_count": 4
},
{
"key": "0b2b79c9ecbd4a9586ee38b2cb6caf9c",
"doc_count": 3
},
{
"key": "27c8631adebe4dbaa488d434a60fede1",
"doc_count": 3
},
{
"key": "845eea5f9ddf446486a872a8238c5f21",
"doc_count": 3
},
{
"key": "a132823eaf34421c82c307567af7ec32",
"doc_count": 3
},
{
"key": "afb4180992e84c01abeb0246496205ad",
"doc_count": 3
},
{
"key": "aff8d7e674d147848b5562ded9cd73f9",
"doc_count": 3
},
{
"key": "c0088ccb433c49aaadfc61d1966f804c",
"doc_count": 3
},
{
"key": "c387c84465444c94b5ccef204f837adf",
"doc_count": 3
},
{
"key": "c3aa4214d11049c4ac2ba984cc3b580d",
"doc_count": 3
},
{
"key": "ee22bae57e9d44699fc9af5a7fc15ac0",
"doc_count": 3
},
{
"key": "018d7968567071a9b0cef9671b290d48",
"doc_count": 2
},
{
"key": "018d8d992ae473bcb7058c4ea70aa3ec",
"doc_count": 2
},
{
"key": "58714ad071934d0f90bda899f7a5b3a6",
"doc_count": 2
},
{
"key": "62e1f91b41a448959bdf7061be0480d9",
"doc_count": 2
},
{
"key": "97610a9e8a0f4970a7be7eec0bac0378",
"doc_count": 2
},
{
"key": "a1b16c0b889547219de3c5a29864a17b",
"doc_count": 2
},
{
"key": "b0df7d03ea404cbc804ca0728a4a4a5b",
"doc_count": 2
},
{
"key": "be733d55959d442f8d34f270d7bf5e6c",
"doc_count": 2
},
{
"key": "c36af3803d914e8bb422246a1b400a68",
"doc_count": 2
},
{
"key": "018d8d9919f471ceadd3c9b9881191d4",
"doc_count": 1
},
{
"key": "2583d76ffb214c698f2349408c44cb61",
"doc_count": 1
},
{
"key": "2d02d3b9b77b467caf001aa703019205",
"doc_count": 1
},
{
"key": "3ebeab725a3e46729c85a7f65161440f",
"doc_count": 1
},
{
"key": "7bcecb23603246ebbcf259006dee810d",
"doc_count": 1
},
{
"key": "87a0cc4aee8d4e9ea2cbe9789c0d8efa",
"doc_count": 1
},
{
"key": "94240c17ab79487e8b5b0923ac586645",
"doc_count": 1
},
{
"key": "b61578f0df8540c382e014c5fcfaf74f",
"doc_count": 1
},
{
"key": "cb52eda8a65947e3b6eda99736ee4834",
"doc_count": 1
},
{
"key": "f295c2e9927744ec9739d5707bdb43ad",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 522,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "01896412d20b73fc9e519aec3fcba13b",
"doc_count": 92
},
{
"key": "01896411e25971f98272a565102c3faf",
"doc_count": 71
},
{
"key": "01896411e1b67172ac7120fc2f0fa574",
"doc_count": 65
},
{
"key": "018963e5f32b703288aad57690802852",
"doc_count": 55
},
{
"key": "018963e5f5e173a4afde33792d6fe12f",
"doc_count": 41
},
{
"key": "018963e5f3d170e3b0919639e3c92da7",
"doc_count": 32
},
{
"key": "018bbe13bff4727baa40d87b9df82a76",
"doc_count": 27
},
{
"key": "018963e5f53b7292b003bf6803f624b7",
"doc_count": 23
},
{
"key": "018963ea3aba7042895b047285c1402e",
"doc_count": 20
},
{
"key": "018963ea1e14736f89733679e4ac807d",
"doc_count": 16
},
{
"key": "018963ea1812737fb7f416641565cd24",
"doc_count": 13
},
{
"key": "018963ea3964707fbbfb35b2b8e8084b",
"doc_count": 13
},
{
"key": "018963ea26b971f09527dfc7f4930323",
"doc_count": 12
},
{
"key": "018bbe13b8cd710c9456aa52d02306b1",
"doc_count": 10
},
{
"key": "018963ea24c172519a11176e570bcae4",
"doc_count": 6
},
{
"key": "018963ea1a0071e3b903843432a2818e",
"doc_count": 4
},
{
"key": "018963ea3609712896e2d21c3a2d91ab",
"doc_count": 4
},
{
"key": "018963ea415c7217b4dc8cb62572ed16",
"doc_count": 4
},
{
"key": "018c1b62b20671548792a3bddc8c9df7",
"doc_count": 4
},
{
"key": "018c825be40470e093149253f848d6d3",
"doc_count": 4
},
{
"key": "018963ea220370f6b3962a1108942bae",
"doc_count": 3
},
{
"key": "018963ea38bc73dfb904152df1cb0c75",
"doc_count": 2
},
{
"key": "018963ea32bc710986d01ebd29a92f48",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "1a0ffc50b3584a1abd28c2d06d6c6465",
"doc_count": 115
},
{
"key": "d8ac016c293145ff9d20f96184a4ad02",
"doc_count": 23
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|