| 1 |
24.78 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":"0189982130527019a253411fc1222fe4"}}}},{"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": 22,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 171,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_all4team_product_1716336301",
"_id": "018cd41624af70b98a1f99be7a85941d",
"_score": null,
"_source": {
"autoIncrement": 1225026.0,
"id": "018cd41624af70b98a1f99be7a85941d"
},
"fields": {
"displayGroup": [
"62ee8306781754f582a73c2637b87721"
]
},
"sort": [
1,
"018cd41624af70b98a1f99be7a85941d"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018af465ec7572aab5ca6cf032c427b6",
"_score": null,
"_source": {
"autoIncrement": 1131575.0,
"id": "018af465ec7572aab5ca6cf032c427b6"
},
"fields": {
"displayGroup": [
"e16cfe75e7fff36fd10abc7f0c72272f"
]
},
"sort": [
0,
"018af465ec7572aab5ca6cf032c427b6"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018af469ca0170129204203b40982acb",
"_score": null,
"_source": {
"autoIncrement": 1131899.0,
"id": "018af469ca0170129204203b40982acb"
},
"fields": {
"displayGroup": [
"1a0263d12c32062ef17e94106ef2f70c"
]
},
"sort": [
0,
"018af469ca0170129204203b40982acb"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018af46baa7172d6b44973dcab0c5c1a",
"_score": null,
"_source": {
"autoIncrement": 1132148.0,
"id": "018af46baa7172d6b44973dcab0c5c1a"
},
"fields": {
"displayGroup": [
"917c153561a94a052804f6bd740827cf"
]
},
"sort": [
0,
"018af46baa7172d6b44973dcab0c5c1a"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bcf123486703090b7d4389f8e7773",
"_score": null,
"_source": {
"autoIncrement": 1136082.0,
"id": "018bcf123486703090b7d4389f8e7773"
},
"fields": {
"displayGroup": [
"7d3a86b697ee5d949e9cb0565c523fc9"
]
},
"sort": [
0,
"018bcf123486703090b7d4389f8e7773"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bd1736a0c7342973aec79dcd8bc83",
"_score": null,
"_source": {
"autoIncrement": 1136526.0,
"id": "018bd1736a0c7342973aec79dcd8bc83"
},
"fields": {
"displayGroup": [
"d193bab73dfdbe3ba5bd0854dc1ff953"
]
},
"sort": [
0,
"018bd1736a0c7342973aec79dcd8bc83"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bd1739fad72298068d902f9de9755",
"_score": null,
"_source": {
"autoIncrement": 1136531.0,
"id": "018bd1739fad72298068d902f9de9755"
},
"fields": {
"displayGroup": [
"a75174a05508ac89f564a005ca6906a0"
]
},
"sort": [
0,
"018bd1739fad72298068d902f9de9755"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bd173c32a735eb789240fa5d55821",
"_score": null,
"_source": {
"autoIncrement": 1136535.0,
"id": "018bd173c32a735eb789240fa5d55821"
},
"fields": {
"displayGroup": [
"8f7bbb8ae3df2b8aa0f748c253fbbf4d"
]
},
"sort": [
0,
"018bd173c32a735eb789240fa5d55821"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bf0cbfa35729884ec02719df9b309",
"_score": null,
"_source": {
"autoIncrement": 1142117.0,
"id": "018bf0cbfa35729884ec02719df9b309"
},
"fields": {
"displayGroup": [
"74ac039e3984699bbe14e5165bb4b630"
]
},
"sort": [
0,
"018bf0cbfa35729884ec02719df9b309"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bf0cc3d6c7048a01641d00463cbd0",
"_score": null,
"_source": {
"autoIncrement": 1142123.0,
"id": "018bf0cc3d6c7048a01641d00463cbd0"
},
"fields": {
"displayGroup": [
"32ad107b56d2c690df5b88360b11c15b"
]
},
"sort": [
0,
"018bf0cc3d6c7048a01641d00463cbd0"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bf0cc75b572b5a7ef2c4cf7686710",
"_score": null,
"_source": {
"autoIncrement": 1142129.0,
"id": "018bf0cc75b572b5a7ef2c4cf7686710"
},
"fields": {
"displayGroup": [
"d622bf6e9fdf545628a93bf652a918a2"
]
},
"sort": [
0,
"018bf0cc75b572b5a7ef2c4cf7686710"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bf869e1c672ed943d8053582bfe60",
"_score": null,
"_source": {
"autoIncrement": 1145733.0,
"id": "018bf869e1c672ed943d8053582bfe60"
},
"fields": {
"displayGroup": [
"0b634867b3bc3054802fcc344fcd0dc3"
]
},
"sort": [
0,
"018bf869e1c672ed943d8053582bfe60"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bf9828ddd73b88dc24d1e1956e164",
"_score": null,
"_source": {
"autoIncrement": 1147097.0,
"id": "018bf9828ddd73b88dc24d1e1956e164"
},
"fields": {
"displayGroup": [
"e51c7c67cb967f62c96a163831bfa6f3"
]
},
"sort": [
0,
"018bf9828ddd73b88dc24d1e1956e164"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7eb5a6f070b7877416442437cdd1",
"_score": null,
"_source": {
"autoIncrement": 1153137.0,
"id": "018c7eb5a6f070b7877416442437cdd1"
},
"fields": {
"displayGroup": [
"2880d8c1b5b1d94e23006c4f3e50e496"
]
},
"sort": [
0,
"018c7eb5a6f070b7877416442437cdd1"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7f2fe84d7039915b286591fd7cb6",
"_score": null,
"_source": {
"autoIncrement": 1163490.0,
"id": "018c7f2fe84d7039915b286591fd7cb6"
},
"fields": {
"displayGroup": [
"2a46e262c955a5c88ea0f0435fe0463a"
]
},
"sort": [
0,
"018c7f2fe84d7039915b286591fd7cb6"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7f3703da71b6956956549399c6be",
"_score": null,
"_source": {
"autoIncrement": 1163495.0,
"id": "018c7f3703da71b6956956549399c6be"
},
"fields": {
"displayGroup": [
"d763ca6c9026566d37608816a519c9e1"
]
},
"sort": [
0,
"018c7f3703da71b6956956549399c6be"
]
}
]
},
"aggregations": {
"total-count": {
"value": 55
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
9.46 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":"0189982130527019a253411fc1222fe4"}}}},{"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": 16,
"shipping-free": {
"value": 1.0,
"value_as_string": "true"
}
},
"rating-exists": {
"doc_count": 171,
"rating": {
"value": 0.0
}
},
"price": {
"count": 171,
"min": 3.59,
"max": 499.0,
"avg": 64.6098245614035,
"sum": 11048.279999999999
},
"options": {
"doc_count": 343,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "99e0a1d01c2140979597380ec8880523",
"doc_count": 42
},
{
"key": "90deb273963c446380e69696e17dbc1c",
"doc_count": 28
},
{
"key": "63a3e4e3a8d0461ca937227647cbc474",
"doc_count": 17
},
{
"key": "103c221ef5c547a6919548726a45adb7",
"doc_count": 15
},
{
"key": "6818490b3d264af396bf32b5c741cb18",
"doc_count": 11
},
{
"key": "b092a626e02e4a789d2ece1cfd262bf1",
"doc_count": 11
},
{
"key": "df41139ab42a4f0dbe2167afb103b833",
"doc_count": 11
},
{
"key": "df6fe8b91f9940ab9fb025c7fa1052ed",
"doc_count": 11
},
{
"key": "e66ee1ff38184b57a51761c4b09ad960",
"doc_count": 11
},
{
"key": "4729fb47088a49cdb2f4bb83188b713b",
"doc_count": 10
},
{
"key": "b26bb94349e2469ea3e048b8bd50a91d",
"doc_count": 10
},
{
"key": "e283ab25ca0a4af18e8f553b38129acb",
"doc_count": 10
},
{
"key": "edc28e7992fd46d29d2e2d88b63682b3",
"doc_count": 10
},
{
"key": "f88aa6eda6c344d7b3708c4d8d1ed730",
"doc_count": 9
},
{
"key": "f6c428695914433b80b64e290e7f994e",
"doc_count": 8
},
{
"key": "20151a8a19934d51a37bf88f68599591",
"doc_count": 7
},
{
"key": "ea8d1e88ba3e4de881dd9d8f03273464",
"doc_count": 5
},
{
"key": "018c690506c2729cbb113b4d05d2da4a",
"doc_count": 4
},
{
"key": "018e866f477971bcaa442492cdbb86fc",
"doc_count": 4
},
{
"key": "0195197be89070a58f27ea063842e9bf",
"doc_count": 4
},
{
"key": "0195197bebd972aca2ab56adc992205c",
"doc_count": 4
},
{
"key": "0195197bf5c373058498eaf0d3e0e1e4",
"doc_count": 4
},
{
"key": "024ffff983424181af856486184536b8",
"doc_count": 4
},
{
"key": "1cbee83944f445a4987f64073bb2cb17",
"doc_count": 4
},
{
"key": "579e2319d56b49fe8698fac4dac4bc9b",
"doc_count": 4
},
{
"key": "018c69036c5d709fa6759781d6dd5cff",
"doc_count": 3
},
{
"key": "018c6903a28e726c989aa607602d0293",
"doc_count": 3
},
{
"key": "1a82b459b30e47a98a4da3220e6eb67e",
"doc_count": 3
},
{
"key": "1c23aae651524363801a44213f31f325",
"doc_count": 3
},
{
"key": "411114eb59ab4cdcaa6d304084ad03e2",
"doc_count": 3
},
{
"key": "4f652f0917c54084be8868edf83ae6e3",
"doc_count": 3
},
{
"key": "8a27091e68084ccf9a7d785e5b7999f8",
"doc_count": 3
},
{
"key": "a918ad46a55d4628acd09f8aece1592f",
"doc_count": 3
},
{
"key": "ac081273a21f412f9e895564d1df02be",
"doc_count": 3
},
{
"key": "b468ae137c4644e1bb75a008623b636e",
"doc_count": 3
},
{
"key": "ddccb68a0ff54c5da26db350fa2d6dff",
"doc_count": 3
},
{
"key": "018c6904beab731fb3688f7e59704624",
"doc_count": 2
},
{
"key": "018c6904e760723d986b6a748a00efbc",
"doc_count": 2
},
{
"key": "018c69051f3673ab88c60ad63495622e",
"doc_count": 2
},
{
"key": "018c69055ae37035ac2a71e04ba86420",
"doc_count": 2
},
{
"key": "018c7c803036737fbacbb810d969071b",
"doc_count": 2
},
{
"key": "018c7c80310570e39be7f5f961b0bdd1",
"doc_count": 2
},
{
"key": "018e866f28017303a8ae520ee07a4c0f",
"doc_count": 2
},
{
"key": "018e866f393d73d9a03ecd9a303f4558",
"doc_count": 2
},
{
"key": "0195197beb53724d9be7458fd7e6760f",
"doc_count": 2
},
{
"key": "0195197bff0372dca663cca4f256fe82",
"doc_count": 2
},
{
"key": "38a468d08afe4e1e8cefe06e35e3614f",
"doc_count": 2
},
{
"key": "b9098912ba704078bf6482acae250e23",
"doc_count": 2
},
{
"key": "018c1b6a59b371049f0068e3ab982c25",
"doc_count": 1
},
{
"key": "018c1b6a608f70b4bec46be22f819132",
"doc_count": 1
},
{
"key": "018c6903551970d8a468a8198cb25bdc",
"doc_count": 1
},
{
"key": "018c69045a19716bb98c5decbc2ed0f1",
"doc_count": 1
},
{
"key": "018c6904846c734bb2d819635409e7e5",
"doc_count": 1
},
{
"key": "018c6904a60a71d58e25430d71ee064a",
"doc_count": 1
},
{
"key": "018c6904ea9e7014bddebf56b3879938",
"doc_count": 1
},
{
"key": "018c6905218c7081807110652a60c479",
"doc_count": 1
},
{
"key": "018c6905321570b18d90fcdbe49705fd",
"doc_count": 1
},
{
"key": "018c69053b7f722b801a77431d1abd24",
"doc_count": 1
},
{
"key": "018c69055fc471ccab7fbd63e522638d",
"doc_count": 1
},
{
"key": "018c6905666c730a967a2858ec186d7b",
"doc_count": 1
},
{
"key": "018c7c7fb49572c69f8381994dc0447e",
"doc_count": 1
},
{
"key": "018e866efa9e72d7a7decbf3fd4c8cb2",
"doc_count": 1
},
{
"key": "018e866efb69715ab9b2d571992d7170",
"doc_count": 1
},
{
"key": "018e866f07df7201ba4a6b04a49c7dcf",
"doc_count": 1
},
{
"key": "018e866f0e7a72498b4b8f3acd174814",
"doc_count": 1
},
{
"key": "018e866f11bc723db01343b90d1bfa6f",
"doc_count": 1
},
{
"key": "018e866f2314736ca74181e94dfa0ddc",
"doc_count": 1
},
{
"key": "018e866f36c071d8aa1ee4c420b4e657",
"doc_count": 1
},
{
"key": "119d5af2f27e4d4b846e6f9e2a02ff50",
"doc_count": 1
},
{
"key": "1e2d012fcf12422e8de33f4c035a0438",
"doc_count": 1
},
{
"key": "2d698a78a97547d29aad7b1607d32dec",
"doc_count": 1
},
{
"key": "bace55c509624d8ab8a0c4653bced477",
"doc_count": 1
},
{
"key": "c3aa4214d11049c4ac2ba984cc3b580d",
"doc_count": 1
},
{
"key": "d042facaedcc42baa5c341ca3085aa44",
"doc_count": 1
},
{
"key": "eb72ee1138594bdd96373a5ec3f2b7fc",
"doc_count": 1
},
{
"key": "f1c0d70c9b714c4cb27beb8f22273242",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 699,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "018963e5f53b7292b003bf6803f624b7",
"doc_count": 141
},
{
"key": "01896412e0f47288993f1ddb76a0e7a8",
"doc_count": 106
},
{
"key": "01896411dfa972429a0b5b59515d3cd1",
"doc_count": 65
},
{
"key": "018963ea3aba7042895b047285c1402e",
"doc_count": 58
},
{
"key": "018dcc3373f47133833772ee8dfc3fe4",
"doc_count": 54
},
{
"key": "018bbe146f507088b3871d02245d09d9",
"doc_count": 51
},
{
"key": "018bbe13b6c57304b719d27003780cfe",
"doc_count": 32
},
{
"key": "018bbe13c09d7328ba65279e42d55280",
"doc_count": 28
},
{
"key": "01896411e3007292bbf291a9837a8cc8",
"doc_count": 25
},
{
"key": "018e521dcd9d73a2ae6c2864c11790df",
"doc_count": 25
},
{
"key": "018963ea1812737fb7f416641565cd24",
"doc_count": 11
},
{
"key": "018963ea20b670278236dc7103bcceb8",
"doc_count": 11
},
{
"key": "018963ea3964707fbbfb35b2b8e8084b",
"doc_count": 9
},
{
"key": "018963ea415c7217b4dc8cb62572ed16",
"doc_count": 9
},
{
"key": "01896411ea347043b0788892761b1dff",
"doc_count": 8
},
{
"key": "018e521dca3d73c8a82a7b373c0cbb64",
"doc_count": 8
},
{
"key": "01896411e82d73ef973f22bb35c69d07",
"doc_count": 7
},
{
"key": "018963ea220370f6b3962a1108942bae",
"doc_count": 6
},
{
"key": "018963ea336b7003ba1d74549036192d",
"doc_count": 6
},
{
"key": "018bbe13bff4727baa40d87b9df82a76",
"doc_count": 6
},
{
"key": "018963ea24c172519a11176e570bcae4",
"doc_count": 5
},
{
"key": "01896411e78a73399a29ed714246da0d",
"doc_count": 4
},
{
"key": "018963e5f32b703288aad57690802852",
"doc_count": 3
},
{
"key": "01896411e3af718192fb7f9ee45ad6fb",
"doc_count": 3
},
{
"key": "0189641328eb73f9866e5781cd84c4e2",
"doc_count": 3
},
{
"key": "018963ea3c15725ea04f1c0eefbb7695",
"doc_count": 2
},
{
"key": "01896411e4fb71bbaa58b6140bd33fd1",
"doc_count": 2
},
{
"key": "018dd235f075722daf1b7ecd97e0eee4",
"doc_count": 2
},
{
"key": "018963e5f3d170e3b0919639e3c92da7",
"doc_count": 1
},
{
"key": "018963ea240d70bda7a637be93c20c89",
"doc_count": 1
},
{
"key": "018963ea3609712896e2d21c3a2d91ab",
"doc_count": 1
},
{
"key": "01896411e05c71f4af78a5552a40b626",
"doc_count": 1
},
{
"key": "01896411e25971f98272a565102c3faf",
"doc_count": 1
},
{
"key": "018bbe13b8237164810b74768f091ae7",
"doc_count": 1
},
{
"key": "018bbe13b97a72e79ffb27e38f96bbb2",
"doc_count": 1
},
{
"key": "018bbe13bba571c9a39ca3fe33a172cd",
"doc_count": 1
},
{
"key": "018bbe13c1f071a095ab51339e1d02ad",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "2a606633b77f4e1bab45f45f3483a835",
"doc_count": 109
},
{
"key": "69126f5efcab45738b242009148aca51",
"doc_count": 19
},
{
"key": "018c7c9a622870078a62e47c70408932",
"doc_count": 13
},
{
"key": "0eb8635d02c643c2b1d22ea1631c0c90",
"doc_count": 9
},
{
"key": "38433195e9d345108b1593626fcdaba0",
"doc_count": 8
},
{
"key": "d8ac016c293145ff9d20f96184a4ad02",
"doc_count": 8
},
{
"key": "1a0ffc50b3584a1abd28c2d06d6c6465",
"doc_count": 4
},
{
"key": "018c7c9a616c7007bb7960ba88e59312",
"doc_count": 1
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|