| 1 |
912.98 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":"01899824b6137279af40cdf8e76a1291"}}}},{"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": 910,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 438,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d9be086fd7298af06398a18ea45ac",
"_score": null,
"_source": {
"autoIncrement": 1301391.0,
"id": "018d9be086fd7298af06398a18ea45ac"
},
"fields": {
"displayGroup": [
"eb9046e82c0705946b81cb768a14e1c7"
]
},
"sort": [
50,
"018d9be086fd7298af06398a18ea45ac"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "7852b5163e394ef38fb5abeb28c47cee",
"_score": null,
"_source": {
"autoIncrement": 1116779.0,
"id": "7852b5163e394ef38fb5abeb28c47cee"
},
"fields": {
"displayGroup": [
"dde9122f191e123dd5537831ae2344c6"
]
},
"sort": [
42,
"7852b5163e394ef38fb5abeb28c47cee"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018af47dc84f72d4b62669556f1294c4",
"_score": null,
"_source": {
"autoIncrement": 1133458.0,
"id": "018af47dc84f72d4b62669556f1294c4"
},
"fields": {
"displayGroup": [
"bb080608344d48f9beea7319498239b9"
]
},
"sort": [
1,
"018af47dc84f72d4b62669556f1294c4"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d9bd7f9a3725997753d3c08404411",
"_score": null,
"_source": {
"autoIncrement": 1301215.0,
"id": "018d9bd7f9a3725997753d3c08404411"
},
"fields": {
"displayGroup": [
"3d83f9ca771a4121d709a0c174897f18"
]
},
"sort": [
1,
"018d9bd7f9a3725997753d3c08404411"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018af479562e711697489c5e66aa6d51",
"_score": null,
"_source": {
"autoIncrement": 1133069.0,
"id": "018af479562e711697489c5e66aa6d51"
},
"fields": {
"displayGroup": [
"4b774c939e7c700af9a0d6b3b170400b"
]
},
"sort": [
0,
"018af479562e711697489c5e66aa6d51"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018af47b08f0711eb203db9f83267748",
"_score": null,
"_source": {
"autoIncrement": 1133246.0,
"id": "018af47b08f0711eb203db9f83267748"
},
"fields": {
"displayGroup": [
"e94b4448239b5f8872fb1ada8e547b0a"
]
},
"sort": [
0,
"018af47b08f0711eb203db9f83267748"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018af47d715a7105acc65fbf5f8a7ff2",
"_score": null,
"_source": {
"autoIncrement": 1133438.0,
"id": "018af47d715a7105acc65fbf5f8a7ff2"
},
"fields": {
"displayGroup": [
"09486902607bfea89b427681381961c1"
]
},
"sort": [
0,
"018af47d715a7105acc65fbf5f8a7ff2"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d5a2808de72be8dcab7cb953c1142",
"_score": null,
"_source": {
"autoIncrement": 1268687.0,
"id": "018d5a2808de72be8dcab7cb953c1142"
},
"fields": {
"displayGroup": [
"5da20dc8a3430c3f55aabc011e966bdd"
]
},
"sort": [
0,
"018d5a2808de72be8dcab7cb953c1142"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d8e86597a73c6aeda570ea14b3e2d",
"_score": null,
"_source": {
"autoIncrement": 1281182.0,
"id": "018d8e86597a73c6aeda570ea14b3e2d"
},
"fields": {
"displayGroup": [
"c1b8bc17807fc884082c21e77dd44fd3"
]
},
"sort": [
0,
"018d8e86597a73c6aeda570ea14b3e2d"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d9bd3545b7192ab3f23258b0961f0",
"_score": null,
"_source": {
"autoIncrement": 1301127.0,
"id": "018d9bd3545b7192ab3f23258b0961f0"
},
"fields": {
"displayGroup": [
"3ed0f4ffcb32cfc2738a4e75a624d7b3"
]
},
"sort": [
0,
"018d9bd3545b7192ab3f23258b0961f0"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d9c0a9eb8728395c950e2a0bd2938",
"_score": null,
"_source": {
"autoIncrement": 1303138.0,
"id": "018d9c0a9eb8728395c950e2a0bd2938"
},
"fields": {
"displayGroup": [
"bbaec956527ce18262760a806a073dd0"
]
},
"sort": [
0,
"018d9c0a9eb8728395c950e2a0bd2938"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d9c0b6a3f702988390f56335b0a48",
"_score": null,
"_source": {
"autoIncrement": 1303175.0,
"id": "018d9c0b6a3f702988390f56335b0a48"
},
"fields": {
"displayGroup": [
"c3f01dd6d74279feaa2ea5380cb0574e"
]
},
"sort": [
0,
"018d9c0b6a3f702988390f56335b0a48"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d9c0e11ec703990119e733c90a254",
"_score": null,
"_source": {
"autoIncrement": 1303247.0,
"id": "018d9c0e11ec703990119e733c90a254"
},
"fields": {
"displayGroup": [
"5875aea08ac5d079d56aa2a221b88ba8"
]
},
"sort": [
0,
"018d9c0e11ec703990119e733c90a254"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d9c112d0671bcac9d5662381bf7d5",
"_score": null,
"_source": {
"autoIncrement": 1303312.0,
"id": "018d9c112d0671bcac9d5662381bf7d5"
},
"fields": {
"displayGroup": [
"a1ded3ec6165efadf2c88f85d9e3ab17"
]
},
"sort": [
0,
"018d9c112d0671bcac9d5662381bf7d5"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d9c1803097290b3489f288dd56954",
"_score": null,
"_source": {
"autoIncrement": 1303558.0,
"id": "018d9c1803097290b3489f288dd56954"
},
"fields": {
"displayGroup": [
"6778e652e18a9afb89c7179d15e44bb6"
]
},
"sort": [
0,
"018d9c1803097290b3489f288dd56954"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018fa4e60265702b86fdc0f3bc23757b",
"_score": null,
"_source": {
"autoIncrement": 1785828.0,
"id": "018fa4e60265702b86fdc0f3bc23757b"
},
"fields": {
"displayGroup": [
"cc3a6d46b7e774fe6da1355ddddd253c"
]
},
"sort": [
0,
"018fa4e60265702b86fdc0f3bc23757b"
]
}
]
},
"aggregations": {
"total-count": {
"value": 40
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
10.85 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":"01899824b6137279af40cdf8e76a1291"}}}},{"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": 8,
"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": 438,
"rating": {
"value": 0.0
}
},
"price": {
"count": 438,
"min": 16.19,
"max": 125.96,
"avg": 37.28255707762557,
"sum": 16329.76
},
"options": {
"doc_count": 882,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "bace55c509624d8ab8a0c4653bced477",
"doc_count": 77
},
{
"key": "df41139ab42a4f0dbe2167afb103b833",
"doc_count": 75
},
{
"key": "103c221ef5c547a6919548726a45adb7",
"doc_count": 73
},
{
"key": "f1c0d70c9b714c4cb27beb8f22273242",
"doc_count": 72
},
{
"key": "63a3e4e3a8d0461ca937227647cbc474",
"doc_count": 71
},
{
"key": "6818490b3d264af396bf32b5c741cb18",
"doc_count": 66
},
{
"key": "018d7968314f730c83c28f6bdcf418ee",
"doc_count": 18
},
{
"key": "018d79681423729787b33b926ae14fe3",
"doc_count": 13
},
{
"key": "018d79677b08714798cbb4d52f0457b1",
"doc_count": 12
},
{
"key": "018d7967a9e871d49b6e9c067ef87338",
"doc_count": 12
},
{
"key": "018d7967f0d071b899040096bfdf292e",
"doc_count": 12
},
{
"key": "018d7968527b73f69b6c463de6376f3e",
"doc_count": 12
},
{
"key": "018d7968d986707b9122d97aac235137",
"doc_count": 12
},
{
"key": "01909baa4749737fac18ebc025c88e0f",
"doc_count": 12
},
{
"key": "84b645877b964a1fb33eac80d05c2e41",
"doc_count": 12
},
{
"key": "01909baa47f9718b97ab6eaf9097aff2",
"doc_count": 9
},
{
"key": "018adf8a6fb670c2be49aee4006c9a64",
"doc_count": 8
},
{
"key": "018d796846da72cb93d936ac6d725417",
"doc_count": 7
},
{
"key": "01909baa861f71a8b8a869c7ac35c598",
"doc_count": 7
},
{
"key": "489ab7a68fb7402f81f190225fcd412a",
"doc_count": 7
},
{
"key": "018bbe1c421e7123b6f6c40fe29ee862",
"doc_count": 6
},
{
"key": "018d7968461a726e84ec5806201b72a6",
"doc_count": 6
},
{
"key": "018d79686e1a7134a5a88fc0de00f7ef",
"doc_count": 6
},
{
"key": "018d796880c971b0ab7285269b7330a0",
"doc_count": 6
},
{
"key": "018d796890f271eba8d5820bcff665a8",
"doc_count": 6
},
{
"key": "018d796898e27129b323a107f1284c34",
"doc_count": 6
},
{
"key": "018d79689f0c715f82fbd21b89cdf3e6",
"doc_count": 6
},
{
"key": "018d7968a64471ebb946f8b135d0f3d2",
"doc_count": 6
},
{
"key": "018d7968c22071e7a77c251f0ef3f253",
"doc_count": 6
},
{
"key": "018d7968c4787036b6626e854531c9db",
"doc_count": 6
},
{
"key": "018d7968cf487045b2b895b4347ecc37",
"doc_count": 6
},
{
"key": "018d7969000c70a5b57a6291e5a0d3a0",
"doc_count": 6
},
{
"key": "018d79691a5a73899f8ee0a837e293d7",
"doc_count": 6
},
{
"key": "018d79692158711c9a14409ad0464ff3",
"doc_count": 6
},
{
"key": "018d796964df72ff99b1e83025025178",
"doc_count": 6
},
{
"key": "018d79696a5a73f08f698582a176ca37",
"doc_count": 6
},
{
"key": "01909baa68987118bb81e3d410bc42fc",
"doc_count": 6
},
{
"key": "01909baaf7cf72c6ab820184e003ef1f",
"doc_count": 6
},
{
"key": "01f53106a64a48b9a0a0a92ab2aa0143",
"doc_count": 6
},
{
"key": "08aa9ed18dfc4e5fae3cc92f53d2bbd1",
"doc_count": 6
},
{
"key": "1b1b055455924603a63a34da9beea9ac",
"doc_count": 6
},
{
"key": "2061c947994340538cde2e002582b12b",
"doc_count": 6
},
{
"key": "2b4185caffb84950b438e21ff579388a",
"doc_count": 6
},
{
"key": "3d9e6617ebcd404b910b739d31f92f30",
"doc_count": 6
},
{
"key": "52202a0098b34cad8489ae72ec96bb2f",
"doc_count": 6
},
{
"key": "55efae40f28b4877949a118edfd07a06",
"doc_count": 6
},
{
"key": "68c5fbac948b4459a0a6a8999b1d68b7",
"doc_count": 6
},
{
"key": "6c8c082cdbb54f0b9942c4e01cf26469",
"doc_count": 6
},
{
"key": "7a1b97a11e584453ad6f328c6eecc054",
"doc_count": 6
},
{
"key": "866959185b184a50943e0b0e748290ab",
"doc_count": 6
},
{
"key": "a9fc45f2f64f490b940b21c917a15c64",
"doc_count": 6
},
{
"key": "c073e1b4450848baa5a22a48f6098515",
"doc_count": 6
},
{
"key": "ceee326838e84e179feac212955baed4",
"doc_count": 6
},
{
"key": "e50791a4a10e4d658d16d16a49d6de98",
"doc_count": 6
},
{
"key": "f8a08067d7f44f67b757dbb5b54bf123",
"doc_count": 6
},
{
"key": "ff57380ad2a04a4186917f9a4b4cea4d",
"doc_count": 6
},
{
"key": "018d79677c9471a8a93fd377940bbc54",
"doc_count": 5
},
{
"key": "018d7967ca9373f59437e0200ae5bb7b",
"doc_count": 5
},
{
"key": "018d7967f01970d4bfd2cf2130972cdd",
"doc_count": 5
},
{
"key": "01909baa884c72f2bde769fb5be201a3",
"doc_count": 5
},
{
"key": "01909bab08b072f3905be10e9fa9bc0a",
"doc_count": 5
},
{
"key": "a6b15298622746a08cd4adcb635b7411",
"doc_count": 5
},
{
"key": "018adf8a735072c7a05442a100e3724b",
"doc_count": 4
},
{
"key": "018d79698dbc726689b93d40627decce",
"doc_count": 4
},
{
"key": "a74fdb8db9fe46fc90481124df698be5",
"doc_count": 4
},
{
"key": "018d79695f9073f9a59761d59db527fe",
"doc_count": 3
},
{
"key": "b26bb94349e2469ea3e048b8bd50a91d",
"doc_count": 3
},
{
"key": "018adf8a723571d9839924ed17dc4e6b",
"doc_count": 2
},
{
"key": "018d7967b492716c8d9c12075d9dfde5",
"doc_count": 2
},
{
"key": "01909baa4484713f829b6c82183726dc",
"doc_count": 2
},
{
"key": "01909baa4ef3731b838061319cb8744a",
"doc_count": 2
},
{
"key": "01909baa5346735f9f2319871e082726",
"doc_count": 2
},
{
"key": "01909baa5f4f727a8eb8b7f0077dd9a4",
"doc_count": 2
},
{
"key": "01909bab7b7e732f9e1f12a5cd693af7",
"doc_count": 2
},
{
"key": "0190a0f04e9a73e9acb47cb87c7f3a0b",
"doc_count": 2
},
{
"key": "0190a0f0a93a7342b4f46d60dd2a3be0",
"doc_count": 2
},
{
"key": "861a62ced8344a9c8a870d28227455c8",
"doc_count": 2
},
{
"key": "018adf8a6d81720a932725876bc6e3f8",
"doc_count": 1
},
{
"key": "018c6903a28e726c989aa607602d0293",
"doc_count": 1
},
{
"key": "018d7967649971b5a372e2c61c573703",
"doc_count": 1
},
{
"key": "018d79677d4e71909558d3a71784402a",
"doc_count": 1
},
{
"key": "01909baa319f727ab204879f3128586a",
"doc_count": 1
},
{
"key": "01909baa48a57020a3e871c67c90e074",
"doc_count": 1
},
{
"key": "01909baa56c170c08f20d70025369133",
"doc_count": 1
},
{
"key": "01909baa9e2270b6afdc6a2f682b26a9",
"doc_count": 1
},
{
"key": "01909baafec172ccbe57425a16c60a1f",
"doc_count": 1
},
{
"key": "1b8fb62983154749b07df41b3d5c891c",
"doc_count": 1
},
{
"key": "3d0b11d1db0f48f7acb284976d0b45e0",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 1850,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "018963e5f13871739bde1b0eb26bb21b",
"doc_count": 438
},
{
"key": "01896411e3007292bbf291a9837a8cc8",
"doc_count": 393
},
{
"key": "0189641267e47006b19d9ae7507ff0c1",
"doc_count": 393
},
{
"key": "018963ea1812737fb7f416641565cd24",
"doc_count": 91
},
{
"key": "018963ea20b670278236dc7103bcceb8",
"doc_count": 57
},
{
"key": "018963ea415c7217b4dc8cb62572ed16",
"doc_count": 49
},
{
"key": "018963ea3964707fbbfb35b2b8e8084b",
"doc_count": 46
},
{
"key": "01896411e3af718192fb7f9ee45ad6fb",
"doc_count": 39
},
{
"key": "018963ea24c172519a11176e570bcae4",
"doc_count": 38
},
{
"key": "018963ea3aba7042895b047285c1402e",
"doc_count": 34
},
{
"key": "018bbe13b8237164810b74768f091ae7",
"doc_count": 30
},
{
"key": "018e197a679a70aeac1d54d99ef59f24",
"doc_count": 30
},
{
"key": "018963ea220370f6b3962a1108942bae",
"doc_count": 20
},
{
"key": "018963ea26b971f09527dfc7f4930323",
"doc_count": 20
},
{
"key": "018bbe13bf4971378f6c9737de6890aa",
"doc_count": 19
},
{
"key": "018963ea336b7003ba1d74549036192d",
"doc_count": 18
},
{
"key": "018bbe13b97a72e79ffb27e38f96bbb2",
"doc_count": 17
},
{
"key": "018bbe13c1f071a095ab51339e1d02ad",
"doc_count": 14
},
{
"key": "018963ea1a0071e3b903843432a2818e",
"doc_count": 12
},
{
"key": "018bbe13baeb7369bc549fcbcdce4c6d",
"doc_count": 12
},
{
"key": "018bbe13bba571c9a39ca3fe33a172cd",
"doc_count": 12
},
{
"key": "018bbe13bc59715e84f9af38463344b8",
"doc_count": 12
},
{
"key": "018bbe13bff4727baa40d87b9df82a76",
"doc_count": 12
},
{
"key": "018963ea3609712896e2d21c3a2d91ab",
"doc_count": 9
},
{
"key": "01896411e11071498f66a862f5383700",
"doc_count": 6
},
{
"key": "018ae9d32e427346bfff156a3adad8f3",
"doc_count": 6
},
{
"key": "018bbe13bdd6710caab556fe464c8b20",
"doc_count": 6
},
{
"key": "018bbe147d4870d1a3ef7b9a0e8f4342",
"doc_count": 6
},
{
"key": "018ae9d2c1dd72c68e1e635735064004",
"doc_count": 4
},
{
"key": "018963ea38137163a2609d568e49c94a",
"doc_count": 2
},
{
"key": "018964130fce737abe083a7d26d0c414",
"doc_count": 2
},
{
"key": "018bbe13b7757294bf18b34533cada9d",
"doc_count": 2
},
{
"key": "018964131120733b8196f00849c63a13",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "d8ac016c293145ff9d20f96184a4ad02",
"doc_count": 423
},
{
"key": "57f85a1341f34ad284dc91714711a009",
"doc_count": 15
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|