| 1 |
10.90 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":"0189984c8f3873449534071d930766c3"}}}},{"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": 8,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 191,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bd6081414731890e6e99757a81d17",
"_score": null,
"_source": {
"autoIncrement": 1139352.0,
"id": "018bd6081414731890e6e99757a81d17"
},
"fields": {
"displayGroup": [
"7cfd08f08fb8edfbcd7cf12a796c096f"
]
},
"sort": [
0,
"018bd6081414731890e6e99757a81d17"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bf81679817080bb090ce66c0b2fc6",
"_score": null,
"_source": {
"autoIncrement": 1145025.0,
"id": "018bf81679817080bb090ce66c0b2fc6"
},
"fields": {
"displayGroup": [
"be2b8a41b77bc0ae67e5fd9f79293c90"
]
},
"sort": [
0,
"018bf81679817080bb090ce66c0b2fc6"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018ce5900ce771cb9a0a29a4d17834d6",
"_score": null,
"_source": {
"autoIncrement": 1237058.0,
"id": "018ce5900ce771cb9a0a29a4d17834d6"
},
"fields": {
"displayGroup": [
"25646d39c30862703b868a30af110e65"
]
},
"sort": [
0,
"018ce5900ce771cb9a0a29a4d17834d6"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d11812242733da50cc3df3e2b13a4",
"_score": null,
"_source": {
"autoIncrement": 1245567.0,
"id": "018d11812242733da50cc3df3e2b13a4"
},
"fields": {
"displayGroup": [
"560103183f1e89fd2354689191373f27"
]
},
"sort": [
0,
"018d11812242733da50cc3df3e2b13a4"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d11864cf672dd80018cac201a5169",
"_score": null,
"_source": {
"autoIncrement": 1245667.0,
"id": "018d11864cf672dd80018cac201a5169"
},
"fields": {
"displayGroup": [
"4a4d62b31b7aa0e181fe3d51f926d812"
]
},
"sort": [
0,
"018d11864cf672dd80018cac201a5169"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d11ac6ee671e19cb4011e90ec0483",
"_score": null,
"_source": {
"autoIncrement": 1246263.0,
"id": "018d11ac6ee671e19cb4011e90ec0483"
},
"fields": {
"displayGroup": [
"8b12fda3041017d42d30989f19ef5f48"
]
},
"sort": [
0,
"018d11ac6ee671e19cb4011e90ec0483"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d11afac307208b47c77f4708c33c0",
"_score": null,
"_source": {
"autoIncrement": 1246299.0,
"id": "018d11afac307208b47c77f4708c33c0"
},
"fields": {
"displayGroup": [
"825d7c16e1f52e22d6a2ab40a7a6dfd0"
]
},
"sort": [
0,
"018d11afac307208b47c77f4708c33c0"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d11b674b671ca8c97e7c5127bdb8b",
"_score": null,
"_source": {
"autoIncrement": 1246401.0,
"id": "018d11b674b671ca8c97e7c5127bdb8b"
},
"fields": {
"displayGroup": [
"d83d849e794e40a2cf0fe30a7929fec0"
]
},
"sort": [
0,
"018d11b674b671ca8c97e7c5127bdb8b"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d11b6fbf072369589b6cbcf0f83bc",
"_score": null,
"_source": {
"autoIncrement": 1246408.0,
"id": "018d11b6fbf072369589b6cbcf0f83bc"
},
"fields": {
"displayGroup": [
"11634a0aac272ef3bf8b2b50ad532658"
]
},
"sort": [
0,
"018d11b6fbf072369589b6cbcf0f83bc"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d11b84be5733b96c7dc0d9ffcfba9",
"_score": null,
"_source": {
"autoIncrement": 1246419.0,
"id": "018d11b84be5733b96c7dc0d9ffcfba9"
},
"fields": {
"displayGroup": [
"4a4b73e48e9e5c81866233714b0a2f11"
]
},
"sort": [
0,
"018d11b84be5733b96c7dc0d9ffcfba9"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d11b9fc7c720a8301b1c93ae32448",
"_score": null,
"_source": {
"autoIncrement": 1246442.0,
"id": "018d11b9fc7c720a8301b1c93ae32448"
},
"fields": {
"displayGroup": [
"dd6acf9dbfc1cd819ecb3147ba963e13"
]
},
"sort": [
0,
"018d11b9fc7c720a8301b1c93ae32448"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d11ba4eec71b1a3b2209b3b734824",
"_score": null,
"_source": {
"autoIncrement": 1246446.0,
"id": "018d11ba4eec71b1a3b2209b3b734824"
},
"fields": {
"displayGroup": [
"92d23d983e252d76b45e3b3046b8b9d4"
]
},
"sort": [
0,
"018d11ba4eec71b1a3b2209b3b734824"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d11bb8b5e704293f7350cd55320ef",
"_score": null,
"_source": {
"autoIncrement": 1246465.0,
"id": "018d11bb8b5e704293f7350cd55320ef"
},
"fields": {
"displayGroup": [
"e1afdda5813368fe267bef899a3b1020"
]
},
"sort": [
0,
"018d11bb8b5e704293f7350cd55320ef"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d11bc898471c79ac65d8085498c44",
"_score": null,
"_source": {
"autoIncrement": 1246475.0,
"id": "018d11bc898471c79ac65d8085498c44"
},
"fields": {
"displayGroup": [
"994482fc3cdd1693fcc8e8e0d5139b1b"
]
},
"sort": [
0,
"018d11bc898471c79ac65d8085498c44"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d11dbbca17132adc41c243d9d8fee",
"_score": null,
"_source": {
"autoIncrement": 1246839.0,
"id": "018d11dbbca17132adc41c243d9d8fee"
},
"fields": {
"displayGroup": [
"caa98e655153a6596f38d17a7ca68aa2"
]
},
"sort": [
0,
"018d11dbbca17132adc41c243d9d8fee"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d11dd818770bfaadf868a53bdd733",
"_score": null,
"_source": {
"autoIncrement": 1246861.0,
"id": "018d11dd818770bfaadf868a53bdd733"
},
"fields": {
"displayGroup": [
"f926212b12e522e3593bcbcd90cc49b1"
]
},
"sort": [
0,
"018d11dd818770bfaadf868a53bdd733"
]
}
]
},
"aggregations": {
"total-count": {
"value": 32
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
11.44 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":"0189984c8f3873449534071d930766c3"}}}},{"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": 9,
"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": 191,
"rating": {
"value": 0.0
}
},
"price": {
"count": 191,
"min": 9.98,
"max": 44.96,
"avg": 21.48638743455497,
"sum": 4103.9
},
"options": {
"doc_count": 382,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "56727b23c0714935b0d2f91c542b93fb",
"doc_count": 26
},
{
"key": "5af5908ce7a34a44a6a5d6783241bc0a",
"doc_count": 25
},
{
"key": "4032569e02fd47788cce9dfa86eeac55",
"doc_count": 23
},
{
"key": "abb0ab38286147aeb3d7fe0c4851cc7c",
"doc_count": 17
},
{
"key": "87a0cc4aee8d4e9ea2cbe9789c0d8efa",
"doc_count": 15
},
{
"key": "476d3085cf474460bc2575974a9e29c1",
"doc_count": 12
},
{
"key": "a317141cf32e4c75b4a85ae9de65c162",
"doc_count": 12
},
{
"key": "edef8fe807b742ccb87e9f04b73ed2d2",
"doc_count": 11
},
{
"key": "f295c2e9927744ec9739d5707bdb43ad",
"doc_count": 11
},
{
"key": "30fad97b5aa4443ca76571f675554d6a",
"doc_count": 10
},
{
"key": "494a59e6dfa1434eab39d3113fccb069",
"doc_count": 10
},
{
"key": "9ed8c9df3da844d29051206290a06d96",
"doc_count": 10
},
{
"key": "1574d0fff7204d4f83347779d509a5e2",
"doc_count": 9
},
{
"key": "2bc45bc05df945f8a5403892f38513f9",
"doc_count": 9
},
{
"key": "985a1bcc1d7e4eab8de5953213340b27",
"doc_count": 9
},
{
"key": "23fdaff90a21450796e4742e46de6553",
"doc_count": 8
},
{
"key": "9d5ff5f309c2404788c259b20f8b61c4",
"doc_count": 8
},
{
"key": "32b7f689c19f425d9de20e215684cb85",
"doc_count": 7
},
{
"key": "3cf8067de75947bcb53e4cd1de94d52a",
"doc_count": 7
},
{
"key": "75ce433a3c32418581a560bbaaeadda1",
"doc_count": 7
},
{
"key": "9889fbcc72f0425fa5b8bc060712ff30",
"doc_count": 7
},
{
"key": "861d496ea6e8475a8578cd43a64402a9",
"doc_count": 6
},
{
"key": "01750e6f68614c338d32827e5acf1be9",
"doc_count": 5
},
{
"key": "018c69040c13739eb1329b3c9b4c780c",
"doc_count": 5
},
{
"key": "1032cce732234c2da6d124956f00ed50",
"doc_count": 5
},
{
"key": "20db184c1fdb49508a4ccd08b882a19f",
"doc_count": 5
},
{
"key": "280b5db9e27d45188434b732ee80d37e",
"doc_count": 5
},
{
"key": "477fe5dbfb004891a8d84da3949c3772",
"doc_count": 5
},
{
"key": "507f2e527d524e359c477d74d4605b1f",
"doc_count": 5
},
{
"key": "5aebd1b7c56f4514813db4336add7068",
"doc_count": 5
},
{
"key": "5e2f46d53cb046f9a5f9736c372966f8",
"doc_count": 5
},
{
"key": "926da90b6d2344788a3a256a5b28b50a",
"doc_count": 5
},
{
"key": "398c5a16f4b44a009a14979049e78f76",
"doc_count": 4
},
{
"key": "57d58bda04ec4e658bfdc7dca90b1933",
"doc_count": 4
},
{
"key": "58b2c8583a0f442ea0278e65b1e9e57d",
"doc_count": 4
},
{
"key": "6766b267b0cd43449248603d64c40416",
"doc_count": 4
},
{
"key": "7652a1b2324744baa32810d1abf5ac24",
"doc_count": 4
},
{
"key": "9ad4f646179d42268122bbf8d914c493",
"doc_count": 4
},
{
"key": "9ae2c81fc475477ba8d6a0975931da1e",
"doc_count": 4
},
{
"key": "c69433ba9ec14df6a9e44fa247b86507",
"doc_count": 4
},
{
"key": "f59b68c9a83d443b856234afb37cf26a",
"doc_count": 4
},
{
"key": "fbdaa9c6a51b41b3bbc26de99187fea2",
"doc_count": 4
},
{
"key": "17fa42ec405146d0ba13388e75e4fe98",
"doc_count": 3
},
{
"key": "60de90a916684ef696e8ba9bd8060cbc",
"doc_count": 3
},
{
"key": "9bcd709d6b8747e295946e3d3fc9cfef",
"doc_count": 3
},
{
"key": "c1bbc0cf51f34755af438b75702d37a2",
"doc_count": 3
},
{
"key": "d61bd953a6414d08a7d85797a94f42d8",
"doc_count": 3
},
{
"key": "16c0eb7c7b284a77b2e3891ceecf5f35",
"doc_count": 2
},
{
"key": "1d945cc308024f22bf772ff9bd094979",
"doc_count": 2
},
{
"key": "37347e78acc44de0a2b07896ba5339c0",
"doc_count": 2
},
{
"key": "3ebeab725a3e46729c85a7f65161440f",
"doc_count": 2
},
{
"key": "684b0baf4a4b4084a60ef3a41bb894ec",
"doc_count": 2
},
{
"key": "b3dad2b6a8e3403f971a21888808ed6b",
"doc_count": 2
},
{
"key": "f649c34f9aa4450aa6140968bb892b8e",
"doc_count": 2
},
{
"key": "111d18d84c904aae86d9249643bbacf0",
"doc_count": 1
},
{
"key": "4076e5a7d31a47a2b55e4a0052792016",
"doc_count": 1
},
{
"key": "b7409471158e4068a053dca04ad51e0a",
"doc_count": 1
},
{
"key": "df7e791689574717a8edfae609e4e340",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 693,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "01896411e59f727b8b482ff954d67fa9",
"doc_count": 120
},
{
"key": "018963e5f32b703288aad57690802852",
"doc_count": 71
},
{
"key": "01896412f86d70b28ec76f2ba82e8329",
"doc_count": 68
},
{
"key": "018963e5f5e173a4afde33792d6fe12f",
"doc_count": 55
},
{
"key": "018e521dcd9d73a2ae6c2864c11790df",
"doc_count": 44
},
{
"key": "018963e5f1e472e9974ee44cd0cb3dd6",
"doc_count": 38
},
{
"key": "018dcc3373f47133833772ee8dfc3fe4",
"doc_count": 38
},
{
"key": "018bbe13b8237164810b74768f091ae7",
"doc_count": 32
},
{
"key": "018963e5f3d170e3b0919639e3c92da7",
"doc_count": 27
},
{
"key": "018963ea1812737fb7f416641565cd24",
"doc_count": 25
},
{
"key": "01896411e25971f98272a565102c3faf",
"doc_count": 22
},
{
"key": "018963ea32bc710986d01ebd29a92f48",
"doc_count": 20
},
{
"key": "018963ea38bc73dfb904152df1cb0c75",
"doc_count": 15
},
{
"key": "018963e5f53b7292b003bf6803f624b7",
"doc_count": 13
},
{
"key": "018963ea3964707fbbfb35b2b8e8084b",
"doc_count": 13
},
{
"key": "018963ea24c172519a11176e570bcae4",
"doc_count": 12
},
{
"key": "018963ea1e14736f89733679e4ac807d",
"doc_count": 11
},
{
"key": "018963ea415c7217b4dc8cb62572ed16",
"doc_count": 10
},
{
"key": "018963ea3609712896e2d21c3a2d91ab",
"doc_count": 8
},
{
"key": "018963ea3aba7042895b047285c1402e",
"doc_count": 7
},
{
"key": "018bbe1476c47169b239563d60e54f70",
"doc_count": 6
},
{
"key": "018963ea356a71fcab3b3ef2a48c7d90",
"doc_count": 5
},
{
"key": "01896411de4973f5acc405c1d8191288",
"doc_count": 5
},
{
"key": "018bbe13b8cd710c9456aa52d02306b1",
"doc_count": 5
},
{
"key": "018963ea1a0071e3b903843432a2818e",
"doc_count": 4
},
{
"key": "018963ea220370f6b3962a1108942bae",
"doc_count": 4
},
{
"key": "018bbe13baeb7369bc549fcbcdce4c6d",
"doc_count": 4
},
{
"key": "018bbe13bba571c9a39ca3fe33a172cd",
"doc_count": 3
},
{
"key": "018bbe13bf4971378f6c9737de6890aa",
"doc_count": 3
},
{
"key": "018c8272ae307310b51499f1ec19bb55",
"doc_count": 3
},
{
"key": "018bbe13c29d7030b84ca02c030b4e39",
"doc_count": 2
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "1a0ffc50b3584a1abd28c2d06d6c6465",
"doc_count": 129
},
{
"key": "2a606633b77f4e1bab45f45f3483a835",
"doc_count": 44
},
{
"key": "d8ac016c293145ff9d20f96184a4ad02",
"doc_count": 18
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|