| 1 |
12.23 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":"0189981a852f72ac9627e41de734d5de"}}}},{"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": 9,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 329,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bd60cf2267331ad8d20a4f91f8ee2",
"_score": null,
"_source": {
"autoIncrement": 1139399.0,
"id": "018bd60cf2267331ad8d20a4f91f8ee2"
},
"fields": {
"displayGroup": [
"08f5c837b23377b43865893e318875e0"
]
},
"sort": [
0,
"018bd60cf2267331ad8d20a4f91f8ee2"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bf7c655f77306b804941791985710",
"_score": null,
"_source": {
"autoIncrement": 1143905.0,
"id": "018bf7c655f77306b804941791985710"
},
"fields": {
"displayGroup": [
"552ff3195ff69149224a0fdac908eb34"
]
},
"sort": [
0,
"018bf7c655f77306b804941791985710"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bf81033d5716fa80ccfa681d62c75",
"_score": null,
"_source": {
"autoIncrement": 1144895.0,
"id": "018bf81033d5716fa80ccfa681d62c75"
},
"fields": {
"displayGroup": [
"0b5ff92d41803df3cdef2c739a73fa75"
]
},
"sort": [
0,
"018bf81033d5716fa80ccfa681d62c75"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bf819eab37146b3f3ec402802a982",
"_score": null,
"_source": {
"autoIncrement": 1145085.0,
"id": "018bf819eab37146b3f3ec402802a982"
},
"fields": {
"displayGroup": [
"8d5e603004c59eb0e449a928f18000fa"
]
},
"sort": [
0,
"018bf819eab37146b3f3ec402802a982"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bf88cf9fd73619cb964367f6270a8",
"_score": null,
"_source": {
"autoIncrement": 1145935.0,
"id": "018bf88cf9fd73619cb964367f6270a8"
},
"fields": {
"displayGroup": [
"dde327957bb86fd403fa8c2a8e97e672"
]
},
"sort": [
0,
"018bf88cf9fd73619cb964367f6270a8"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7f9196a072a59ec93c3194a352cf",
"_score": null,
"_source": {
"autoIncrement": 1163822.0,
"id": "018c7f9196a072a59ec93c3194a352cf"
},
"fields": {
"displayGroup": [
"6531913f02f05a0768e8310f01148544"
]
},
"sort": [
0,
"018c7f9196a072a59ec93c3194a352cf"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018cd7e0370f70b0ac274c38ddb605b1",
"_score": null,
"_source": {
"autoIncrement": 1226456.0,
"id": "018cd7e0370f70b0ac274c38ddb605b1"
},
"fields": {
"displayGroup": [
"c2e9bdc662e7572eb692ecaffc19eb0b"
]
},
"sort": [
0,
"018cd7e0370f70b0ac274c38ddb605b1"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d103670db704c978164fc08396898",
"_score": null,
"_source": {
"autoIncrement": 1240225.0,
"id": "018d103670db704c978164fc08396898"
},
"fields": {
"displayGroup": [
"c8d050e5bff0382280e56b6fcddbec61"
]
},
"sort": [
0,
"018d103670db704c978164fc08396898"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d103dfea8722b921ccf806b6ac87d",
"_score": null,
"_source": {
"autoIncrement": 1240354.0,
"id": "018d103dfea8722b921ccf806b6ac87d"
},
"fields": {
"displayGroup": [
"a3489c8d72c89713efe889446dff7344"
]
},
"sort": [
0,
"018d103dfea8722b921ccf806b6ac87d"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d113a3ea972aaa28ef4d483b40d05",
"_score": null,
"_source": {
"autoIncrement": 1244218.0,
"id": "018d113a3ea972aaa28ef4d483b40d05"
},
"fields": {
"displayGroup": [
"f5d592704d328d4c9eec4b96c1d0b0e6"
]
},
"sort": [
0,
"018d113a3ea972aaa28ef4d483b40d05"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d116ee4f9725ca880c8984d5f7620",
"_score": null,
"_source": {
"autoIncrement": 1245210.0,
"id": "018d116ee4f9725ca880c8984d5f7620"
},
"fields": {
"displayGroup": [
"71861d7d70765ae965215f36b2a5f2f7"
]
},
"sort": [
0,
"018d116ee4f9725ca880c8984d5f7620"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d11c851d272819010c509f619bb83",
"_score": null,
"_source": {
"autoIncrement": 1246618.0,
"id": "018d11c851d272819010c509f619bb83"
},
"fields": {
"displayGroup": [
"7434eba320317e4f338bf84bd9bf85c5"
]
},
"sort": [
0,
"018d11c851d272819010c509f619bb83"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d11e16cb671d0b94f2427c8a69388",
"_score": null,
"_source": {
"autoIncrement": 1246908.0,
"id": "018d11e16cb671d0b94f2427c8a69388"
},
"fields": {
"displayGroup": [
"90c42cd2ed3920b9fea3191f27b13d3b"
]
},
"sort": [
0,
"018d11e16cb671d0b94f2427c8a69388"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d1234561f72c085d239f44816a027",
"_score": null,
"_source": {
"autoIncrement": 1247676.0,
"id": "018d1234561f72c085d239f44816a027"
},
"fields": {
"displayGroup": [
"df8bcb9d24044389d9d87af3243caa47"
]
},
"sort": [
0,
"018d1234561f72c085d239f44816a027"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d57c86d04720a962226426b848be8",
"_score": null,
"_source": {
"autoIncrement": 1264437.0,
"id": "018d57c86d04720a962226426b848be8"
},
"fields": {
"displayGroup": [
"6e704b00be3a8c321f5b504449adb821"
]
},
"sort": [
0,
"018d57c86d04720a962226426b848be8"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d5821a9847388a2a7ef07320112e9",
"_score": null,
"_source": {
"autoIncrement": 1265733.0,
"id": "018d5821a9847388a2a7ef07320112e9"
},
"fields": {
"displayGroup": [
"9bdac369021d6f15a2b4d02decff232f"
]
},
"sort": [
0,
"018d5821a9847388a2a7ef07320112e9"
]
}
]
},
"aggregations": {
"total-count": {
"value": 30
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
9.13 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":"0189981a852f72ac9627e41de734d5de"}}}},{"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": 6,
"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": 329,
"rating": {
"value": 0.0
}
},
"price": {
"count": 329,
"min": 7.84,
"max": 51.97,
"avg": 19.47996960486322,
"sum": 6408.91
},
"options": {
"doc_count": 675,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "df41139ab42a4f0dbe2167afb103b833",
"doc_count": 51
},
{
"key": "103c221ef5c547a6919548726a45adb7",
"doc_count": 49
},
{
"key": "b26bb94349e2469ea3e048b8bd50a91d",
"doc_count": 49
},
{
"key": "6818490b3d264af396bf32b5c741cb18",
"doc_count": 47
},
{
"key": "63a3e4e3a8d0461ca937227647cbc474",
"doc_count": 46
},
{
"key": "bace55c509624d8ab8a0c4653bced477",
"doc_count": 39
},
{
"key": "018c6903551970d8a468a8198cb25bdc",
"doc_count": 17
},
{
"key": "018c6904e760723d986b6a748a00efbc",
"doc_count": 17
},
{
"key": "2d698a78a97547d29aad7b1607d32dec",
"doc_count": 17
},
{
"key": "c69433ba9ec14df6a9e44fa247b86507",
"doc_count": 15
},
{
"key": "1f5bfb78f7334c84807976a37b6849b5",
"doc_count": 9
},
{
"key": "5449145d173a4896a723ea31d64cedf7",
"doc_count": 9
},
{
"key": "1a82b459b30e47a98a4da3220e6eb67e",
"doc_count": 8
},
{
"key": "a261e3c9e9924edebdb4f24de2feb2c2",
"doc_count": 8
},
{
"key": "10b3f2d6e6b044a0b979260f8c335710",
"doc_count": 7
},
{
"key": "684b0baf4a4b4084a60ef3a41bb894ec",
"doc_count": 7
},
{
"key": "bdbc4643ce5145e7807d833ba8e06f9e",
"doc_count": 7
},
{
"key": "018c6903a28e726c989aa607602d0293",
"doc_count": 6
},
{
"key": "018c6903e1d7715c8edcd6e50cb3217f",
"doc_count": 6
},
{
"key": "018c69041842717ab513bc499551240a",
"doc_count": 6
},
{
"key": "018c6904de4172a5a1a087558dfcc954",
"doc_count": 6
},
{
"key": "018c690520bf7014980a61a7b5c89357",
"doc_count": 6
},
{
"key": "018c690559417041adb5044232bfc8bb",
"doc_count": 6
},
{
"key": "018c7c806e337387adb13b44bcbd53b0",
"doc_count": 6
},
{
"key": "018dc10b6b6f71b59ef19d4cff6e0630",
"doc_count": 6
},
{
"key": "09df4c6efd80429ca293244b63560c6a",
"doc_count": 6
},
{
"key": "185481f432e44c759e127181f8d05f63",
"doc_count": 6
},
{
"key": "191f563562514082983cb80d5fa411b3",
"doc_count": 6
},
{
"key": "2f15863403514cc292f1b80cd8003c12",
"doc_count": 6
},
{
"key": "33e4c4ae19a046708104f45a9a773015",
"doc_count": 6
},
{
"key": "3d4a378833ff43e2b1d708e4dcff645e",
"doc_count": 6
},
{
"key": "4314baa116af4d10a8202db74494ef1a",
"doc_count": 6
},
{
"key": "5affb90217af40c58011013f87e6b516",
"doc_count": 6
},
{
"key": "61bf0754013d46c392f76d5028b9ddf4",
"doc_count": 6
},
{
"key": "62dab438af224841ac67e136513c0169",
"doc_count": 6
},
{
"key": "6801315e0cf5464796b26c8cae92e291",
"doc_count": 6
},
{
"key": "6b8d9eb2113441598f83a6d7110d18d1",
"doc_count": 6
},
{
"key": "6de5871927ab44a4a0ab18ec391241d2",
"doc_count": 6
},
{
"key": "7a918eed118c4acf92d5132e41a3cd14",
"doc_count": 6
},
{
"key": "7afac8a23eb24ed9adf947179634e773",
"doc_count": 6
},
{
"key": "bf9fbbb8411a4f3fa897341f63806505",
"doc_count": 6
},
{
"key": "d61bd953a6414d08a7d85797a94f42d8",
"doc_count": 6
},
{
"key": "eb9cdf187fa14a468868296025a88539",
"doc_count": 6
},
{
"key": "f847fda88876448f9afde1bbf7a21107",
"doc_count": 6
},
{
"key": "01750e6f68614c338d32827e5acf1be9",
"doc_count": 5
},
{
"key": "018c1b6a81ce72d8a4f00ec19ac9c040",
"doc_count": 5
},
{
"key": "476d3085cf474460bc2575974a9e29c1",
"doc_count": 5
},
{
"key": "73e7ba66d965447b9ad7e2a05142cd85",
"doc_count": 5
},
{
"key": "a6270f6bf6074f378de11d780116bb1d",
"doc_count": 5
},
{
"key": "a8b13ecee7f74d28af6ed8a74a20757f",
"doc_count": 5
},
{
"key": "adf66c9b2a824a02bc9b1cc28c4d5dcb",
"doc_count": 5
},
{
"key": "b8ddb9b53e2740e58c6385b22bb05e29",
"doc_count": 5
},
{
"key": "c7258d79862745349543748382b90dad",
"doc_count": 5
},
{
"key": "e7380a50cd7d4f58814ec7c9dd2c769d",
"doc_count": 5
},
{
"key": "e79e0f0ea71a47c88535f185ed5e7866",
"doc_count": 5
},
{
"key": "018c7c804fad7339bb0d0334de9a88bf",
"doc_count": 4
},
{
"key": "1893e0d032a345bbb19b4546335821fc",
"doc_count": 4
},
{
"key": "018faad1183471ce8ce1df2ed7223807",
"doc_count": 3
},
{
"key": "036bbbf5fde744c1b0017df6bb3201db",
"doc_count": 3
},
{
"key": "2394153257cd46779c19aca0d2597c31",
"doc_count": 3
},
{
"key": "5516d6afffb84ea193e75464a973cc83",
"doc_count": 3
},
{
"key": "d2a9e8cbfb064eb18451b1a8a6c78e61",
"doc_count": 3
},
{
"key": "fbdaa9c6a51b41b3bbc26de99187fea2",
"doc_count": 3
},
{
"key": "05f0d2b5046e4896a18f271c13b4893d",
"doc_count": 2
},
{
"key": "32b7f689c19f425d9de20e215684cb85",
"doc_count": 2
},
{
"key": "3cf8067de75947bcb53e4cd1de94d52a",
"doc_count": 2
},
{
"key": "48af33f665b94a97a4d1251ee9494574",
"doc_count": 2
},
{
"key": "a3252dd7fed04eed97c207be6b392412",
"doc_count": 2
},
{
"key": "bedbd9ce9ad744fdb686bc125357d84c",
"doc_count": 2
},
{
"key": "d13b730b107a4a05902ab8c258ef4519",
"doc_count": 2
},
{
"key": "fb48fb0a5b2f443c9c6455bfb9a039b1",
"doc_count": 2
},
{
"key": "018c69036c5d709fa6759781d6dd5cff",
"doc_count": 1
},
{
"key": "018c6903f0b9728194fee4999580d035",
"doc_count": 1
},
{
"key": "018d7969852b7185a841430ce2316161",
"doc_count": 1
},
{
"key": "0542208150ea4c418deddd988f12b660",
"doc_count": 1
},
{
"key": "10407bd73aaa4053b6911fdaba645abb",
"doc_count": 1
},
{
"key": "13d32c1ef1364f0f877f5440c43b1af5",
"doc_count": 1
},
{
"key": "1c23aae651524363801a44213f31f325",
"doc_count": 1
},
{
"key": "30271612aaf142ca92ff6f897f455f1a",
"doc_count": 1
},
{
"key": "3ef9fb9e2ecb40a69365b75e8cccaa56",
"doc_count": 1
},
{
"key": "4a610d6357ae49d09a2f5b7531b1b1b0",
"doc_count": 1
},
{
"key": "5258510fe2d646ac84abd4e3fbe4ddb0",
"doc_count": 1
},
{
"key": "57c8756a71a04abb8216296128724df9",
"doc_count": 1
},
{
"key": "5a998aa9d1c94c95ae913dcdfaad0e57",
"doc_count": 1
},
{
"key": "78d91a8bfd1c4fce86c8dea6b0fdf3a9",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 1135,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "018963e5f06f716dadb0fe95b3c53d22",
"doc_count": 304
},
{
"key": "018dcc3373f47133833772ee8dfc3fe4",
"doc_count": 171
},
{
"key": "018e521dcd9d73a2ae6c2864c11790df",
"doc_count": 113
},
{
"key": "01896412f91270f9bd7651a90b40289b",
"doc_count": 85
},
{
"key": "01896411e9917199967095243438b4f6",
"doc_count": 56
},
{
"key": "018963ea415c7217b4dc8cb62572ed16",
"doc_count": 48
},
{
"key": "018963ea1812737fb7f416641565cd24",
"doc_count": 45
},
{
"key": "018963ea3aba7042895b047285c1402e",
"doc_count": 40
},
{
"key": "01896411e4fb71bbaa58b6140bd33fd1",
"doc_count": 40
},
{
"key": "018963ea3964707fbbfb35b2b8e8084b",
"doc_count": 35
},
{
"key": "018963ea24c172519a11176e570bcae4",
"doc_count": 27
},
{
"key": "018bbe13bff4727baa40d87b9df82a76",
"doc_count": 21
},
{
"key": "018bbe13c1f071a095ab51339e1d02ad",
"doc_count": 20
},
{
"key": "018bbe1476c47169b239563d60e54f70",
"doc_count": 20
},
{
"key": "01896411dfa972429a0b5b59515d3cd1",
"doc_count": 17
},
{
"key": "018963ea22ba728b91340add918cb0c9",
"doc_count": 9
},
{
"key": "018963ea336b7003ba1d74549036192d",
"doc_count": 9
},
{
"key": "01896411e6eb71ccbac66ed4a361c281",
"doc_count": 8
},
{
"key": "01896411ead671b4af1c717ad0b260cf",
"doc_count": 8
},
{
"key": "018bbe13bdd6710caab556fe464c8b20",
"doc_count": 8
},
{
"key": "018bbe13bf4971378f6c9737de6890aa",
"doc_count": 8
},
{
"key": "018963ea220370f6b3962a1108942bae",
"doc_count": 7
},
{
"key": "018963ea2f4872f5b65ae53cf081df0e",
"doc_count": 7
},
{
"key": "018963ea3609712896e2d21c3a2d91ab",
"doc_count": 6
},
{
"key": "018963ea1e14736f89733679e4ac807d",
"doc_count": 5
},
{
"key": "01896411e25971f98272a565102c3faf",
"doc_count": 4
},
{
"key": "018bbe13b8237164810b74768f091ae7",
"doc_count": 4
},
{
"key": "018963ea26b971f09527dfc7f4930323",
"doc_count": 3
},
{
"key": "018963ea38bc73dfb904152df1cb0c75",
"doc_count": 3
},
{
"key": "018bbe13bc59715e84f9af38463344b8",
"doc_count": 3
},
{
"key": "018963ea3e0572c6960c0eadf8b16c7f",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "2a606633b77f4e1bab45f45f3483a835",
"doc_count": 138
},
{
"key": "1a0ffc50b3584a1abd28c2d06d6c6465",
"doc_count": 59
},
{
"key": "018c7c9a622870078a62e47c70408932",
"doc_count": 58
},
{
"key": "69126f5efcab45738b242009148aca51",
"doc_count": 48
},
{
"key": "d8ac016c293145ff9d20f96184a4ad02",
"doc_count": 26
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|