| 1 |
967.41 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":"01899831084472898af654f278f25ff2"}}}},{"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": 964,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 264,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bd603398970248a0b15f6cad5bb01",
"_score": null,
"_source": {
"autoIncrement": 1139311.0,
"id": "018bd603398970248a0b15f6cad5bb01"
},
"fields": {
"displayGroup": [
"d5f5ff37b0fb8d9b6df8c74edf9bb16a"
]
},
"sort": [
1,
"018bd603398970248a0b15f6cad5bb01"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bd6732af77014bb16876dc11da8db",
"_score": null,
"_source": {
"autoIncrement": 1141023.0,
"id": "018bd6732af77014bb16876dc11da8db"
},
"fields": {
"displayGroup": [
"7a65bfda07bd95f591194a88ccfa473d"
]
},
"sort": [
0,
"018bd6732af77014bb16876dc11da8db"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bf85149fd72b8bb2989f46f9497ba",
"_score": null,
"_source": {
"autoIncrement": 1145631.0,
"id": "018bf85149fd72b8bb2989f46f9497ba"
},
"fields": {
"displayGroup": [
"ded9d973856202986b7ac6522f5f96e9"
]
},
"sort": [
0,
"018bf85149fd72b8bb2989f46f9497ba"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bf852d110712697210d013911689a",
"_score": null,
"_source": {
"autoIncrement": 1145644.0,
"id": "018bf852d110712697210d013911689a"
},
"fields": {
"displayGroup": [
"9f4a95179238f2412a33f1ddbe79b76c"
]
},
"sort": [
0,
"018bf852d110712697210d013911689a"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018cda25066e732598f38f21b2fba9c6",
"_score": null,
"_source": {
"autoIncrement": 1227309.0,
"id": "018cda25066e732598f38f21b2fba9c6"
},
"fields": {
"displayGroup": [
"87950267ed30dfe4fcd5fff97cf00402"
]
},
"sort": [
0,
"018cda25066e732598f38f21b2fba9c6"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018cda97cc7e70f7a4c93305ea5e84d8",
"_score": null,
"_source": {
"autoIncrement": 1227690.0,
"id": "018cda97cc7e70f7a4c93305ea5e84d8"
},
"fields": {
"displayGroup": [
"a38e444fb8facc2674b5ab7c66e979be"
]
},
"sort": [
0,
"018cda97cc7e70f7a4c93305ea5e84d8"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018cdc603bee7108b4346f4648f1eb36",
"_score": null,
"_source": {
"autoIncrement": 1230317.0,
"id": "018cdc603bee7108b4346f4648f1eb36"
},
"fields": {
"displayGroup": [
"01727d4164505a5214825d6818e55105"
]
},
"sort": [
0,
"018cdc603bee7108b4346f4648f1eb36"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d1d775beb71629ea99f9388861fda",
"_score": null,
"_source": {
"autoIncrement": 1257395.0,
"id": "018d1d775beb71629ea99f9388861fda"
},
"fields": {
"displayGroup": [
"7c54741e8ff3b21a89a1fa82e68f3f1f"
]
},
"sort": [
0,
"018d1d775beb71629ea99f9388861fda"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d1d8a5bd273f78dd50647599ee917",
"_score": null,
"_source": {
"autoIncrement": 1257558.0,
"id": "018d1d8a5bd273f78dd50647599ee917"
},
"fields": {
"displayGroup": [
"ac3be80741d74ece33a061439f95722c"
]
},
"sort": [
0,
"018d1d8a5bd273f78dd50647599ee917"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d1dd6a7d471848494184d550b667c",
"_score": null,
"_source": {
"autoIncrement": 1257774.0,
"id": "018d1dd6a7d471848494184d550b667c"
},
"fields": {
"displayGroup": [
"98019af671b5483cb2e47fd2b0206c52"
]
},
"sort": [
0,
"018d1dd6a7d471848494184d550b667c"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d1dd8248770bd95512cd4c74f0336",
"_score": null,
"_source": {
"autoIncrement": 1257791.0,
"id": "018d1dd8248770bd95512cd4c74f0336"
},
"fields": {
"displayGroup": [
"b74f0c27fca2c58b8b42c073ce5ce4c9"
]
},
"sort": [
0,
"018d1dd8248770bd95512cd4c74f0336"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d1f6579b2726fba82d38567f9c966",
"_score": null,
"_source": {
"autoIncrement": 1259319.0,
"id": "018d1f6579b2726fba82d38567f9c966"
},
"fields": {
"displayGroup": [
"bcac6546b1ec139ad88b9fc50eb4b9af"
]
},
"sort": [
0,
"018d1f6579b2726fba82d38567f9c966"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d826536df73948605498c4d695c5b",
"_score": null,
"_source": {
"autoIncrement": 1276805.0,
"id": "018d826536df73948605498c4d695c5b"
},
"fields": {
"displayGroup": [
"b6fce33f7040777e66a02ceba624fd0f"
]
},
"sort": [
0,
"018d826536df73948605498c4d695c5b"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018f77a938b87088aeefba732f747fde",
"_score": null,
"_source": {
"autoIncrement": 1783769.0,
"id": "018f77a938b87088aeefba732f747fde"
},
"fields": {
"displayGroup": [
"caae7a8a9618ccdc3654250ab4f48908"
]
},
"sort": [
0,
"018f77a938b87088aeefba732f747fde"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0190956e785272468dee596b82d0c8b5",
"_score": null,
"_source": {
"autoIncrement": 1824116.0,
"id": "0190956e785272468dee596b82d0c8b5"
},
"fields": {
"displayGroup": [
"07f165fa7d4876385cf0dfc8066ce160"
]
},
"sort": [
0,
"0190956e785272468dee596b82d0c8b5"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0190e98a26d971929099784a1c27b34e",
"_score": null,
"_source": {
"autoIncrement": 1841754.0,
"id": "0190e98a26d971929099784a1c27b34e"
},
"fields": {
"displayGroup": [
"98bb7ebae1a9cf68bb1cad379c22fe99"
]
},
"sort": [
0,
"0190e98a26d971929099784a1c27b34e"
]
}
]
},
"aggregations": {
"total-count": {
"value": 37
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
9.88 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":"01899831084472898af654f278f25ff2"}}}},{"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": 15,
"shipping-free": {
"value": 1.0,
"value_as_string": "true"
}
},
"rating-exists": {
"doc_count": 264,
"rating": {
"value": 0.0
}
},
"price": {
"count": 264,
"min": 17.96,
"max": 53.96,
"avg": 31.380075757575757,
"sum": 8284.34
},
"options": {
"doc_count": 532,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "df41139ab42a4f0dbe2167afb103b833",
"doc_count": 52
},
{
"key": "bace55c509624d8ab8a0c4653bced477",
"doc_count": 46
},
{
"key": "103c221ef5c547a6919548726a45adb7",
"doc_count": 45
},
{
"key": "6818490b3d264af396bf32b5c741cb18",
"doc_count": 41
},
{
"key": "63a3e4e3a8d0461ca937227647cbc474",
"doc_count": 37
},
{
"key": "f1c0d70c9b714c4cb27beb8f22273242",
"doc_count": 23
},
{
"key": "b26bb94349e2469ea3e048b8bd50a91d",
"doc_count": 19
},
{
"key": "17fa42ec405146d0ba13388e75e4fe98",
"doc_count": 15
},
{
"key": "90deb273963c446380e69696e17dbc1c",
"doc_count": 10
},
{
"key": "9bcd709d6b8747e295946e3d3fc9cfef",
"doc_count": 10
},
{
"key": "c1bbc0cf51f34755af438b75702d37a2",
"doc_count": 8
},
{
"key": "f4ae98e61a6e405cb0b5a221ef13dbfe",
"doc_count": 8
},
{
"key": "f87a19ab23ab4b9a87ff14f85cd740b5",
"doc_count": 8
},
{
"key": "3d4a378833ff43e2b1d708e4dcff645e",
"doc_count": 7
},
{
"key": "01750e6f68614c338d32827e5acf1be9",
"doc_count": 6
},
{
"key": "018991241a7b70f6b2cc256794e99657",
"doc_count": 6
},
{
"key": "018c1b6a769770b6ae92785b381a8e9f",
"doc_count": 6
},
{
"key": "018c6903551970d8a468a8198cb25bdc",
"doc_count": 6
},
{
"key": "1c23aae651524363801a44213f31f325",
"doc_count": 6
},
{
"key": "2d698a78a97547d29aad7b1607d32dec",
"doc_count": 6
},
{
"key": "4314baa116af4d10a8202db74494ef1a",
"doc_count": 6
},
{
"key": "5466f9a9a8bd405486a8213b3ae9f1f0",
"doc_count": 6
},
{
"key": "7303e67aef5342d78da48b362e94c9fd",
"doc_count": 6
},
{
"key": "ac4dbcaf8dff4e7d93712090c05bc8e4",
"doc_count": 6
},
{
"key": "b8f573da04aa426b97c745a6d8e5585f",
"doc_count": 6
},
{
"key": "c1ca79cc2b574f87b6eecc3191893a5b",
"doc_count": 6
},
{
"key": "c3e5158073204dcc81f39ea5ac00f976",
"doc_count": 6
},
{
"key": "d75fd1e73aee484ba359a19f81a21acb",
"doc_count": 6
},
{
"key": "da90288a8a0442cf89d838c0a578c691",
"doc_count": 6
},
{
"key": "e1dde66905114503a9f1b55937fb7792",
"doc_count": 6
},
{
"key": "58b2c8583a0f442ea0278e65b1e9e57d",
"doc_count": 5
},
{
"key": "9ae2c81fc475477ba8d6a0975931da1e",
"doc_count": 5
},
{
"key": "c2d8e07b24294c33806daa8e7806a085",
"doc_count": 5
},
{
"key": "018c7c8037847048bbf68be5a20f46fd",
"doc_count": 4
},
{
"key": "018c7c807d9071c68851088d94b54b90",
"doc_count": 4
},
{
"key": "2f668f7acd124b4cb864d0dd2c956f84",
"doc_count": 4
},
{
"key": "8010798477bb48a2894cb3b08b41a2e1",
"doc_count": 4
},
{
"key": "b637fbc230e74f1183657a5a6c31055f",
"doc_count": 4
},
{
"key": "c86007e7098c4228bd9ba9b1be6abc40",
"doc_count": 4
},
{
"key": "cfb5694a62a64f0dbf5ff8df39129fe6",
"doc_count": 4
},
{
"key": "e0bf8b4212194cb3b94137bb6b723768",
"doc_count": 4
},
{
"key": "018c7c8080b373a2b8520ad86a6ad5bf",
"doc_count": 3
},
{
"key": "019884b0c5b8739581eb596ee3b91e2a",
"doc_count": 3
},
{
"key": "019884b0d1cc719086995a0366aa5508",
"doc_count": 3
},
{
"key": "019884b0ec6e704a8799be8e73cd09d1",
"doc_count": 3
},
{
"key": "019884b0f79172d28cd4911a258eecfd",
"doc_count": 3
},
{
"key": "1a82b459b30e47a98a4da3220e6eb67e",
"doc_count": 3
},
{
"key": "3133a66f10a0492e9eaab67595e0db87",
"doc_count": 3
},
{
"key": "4299c56b6ed7431eb16e14152d2655c0",
"doc_count": 3
},
{
"key": "61bf0754013d46c392f76d5028b9ddf4",
"doc_count": 3
},
{
"key": "8b7442faf2fa4077bb2161946af82300",
"doc_count": 3
},
{
"key": "a8c0afa33a3b4c3395bb83146362f91f",
"doc_count": 3
},
{
"key": "a943e1f9366344a488df3d5637ab2b73",
"doc_count": 3
},
{
"key": "b9098912ba704078bf6482acae250e23",
"doc_count": 3
},
{
"key": "018c7c7fe63171bea777315632c088cf",
"doc_count": 2
},
{
"key": "40fed3f805694634974d360639023835",
"doc_count": 2
},
{
"key": "e71b2b657cf841e9b61a448bafb0cceb",
"doc_count": 2
},
{
"key": "018d97d417797148bcdbbdc560511afc",
"doc_count": 1
},
{
"key": "0190a0f0e62672849138a2121985ca86",
"doc_count": 1
},
{
"key": "019884b0ca5e73ed851262b85ba33bac",
"doc_count": 1
},
{
"key": "019884b0e602727e987ef7de99b608bd",
"doc_count": 1
},
{
"key": "54cf2b0f93f04cd2ac223e59bc0aac76",
"doc_count": 1
},
{
"key": "684b0baf4a4b4084a60ef3a41bb894ec",
"doc_count": 1
},
{
"key": "74b7f35774be407687711a6eb6c78ce8",
"doc_count": 1
},
{
"key": "983ba97663fb46f4b703132ff2f11085",
"doc_count": 1
},
{
"key": "989e00393a2342ba8e9daa502600ae47",
"doc_count": 1
},
{
"key": "b29a7c11718244d3b5e8b74a501fb3a1",
"doc_count": 1
},
{
"key": "b8cceeba7beb47c48921fbdb90cc3524",
"doc_count": 1
},
{
"key": "ba02bd5181df4d44b40cda519b7b32be",
"doc_count": 1
},
{
"key": "bdc65e15082843aab932c64c7986d3e6",
"doc_count": 1
},
{
"key": "d329f629bdb14a448f99786e4a6071b0",
"doc_count": 1
},
{
"key": "df4fabf8c61149f985ee963679843941",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 1130,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "018963e5f13871739bde1b0eb26bb21b",
"doc_count": 166
},
{
"key": "01896412f7a5711ea2265147265e0172",
"doc_count": 135
},
{
"key": "01896411e05c71f4af78a5552a40b626",
"doc_count": 93
},
{
"key": "01896411e82d73ef973f22bb35c69d07",
"doc_count": 90
},
{
"key": "018963e5f53b7292b003bf6803f624b7",
"doc_count": 74
},
{
"key": "018963ea1812737fb7f416641565cd24",
"doc_count": 65
},
{
"key": "01896412f3be73e9b9f7c1618b09e578",
"doc_count": 60
},
{
"key": "018963ea3aba7042895b047285c1402e",
"doc_count": 44
},
{
"key": "018963ea3964707fbbfb35b2b8e8084b",
"doc_count": 40
},
{
"key": "018dcc3373f47133833772ee8dfc3fe4",
"doc_count": 37
},
{
"key": "018bbe1476c47169b239563d60e54f70",
"doc_count": 32
},
{
"key": "018963ea24c172519a11176e570bcae4",
"doc_count": 29
},
{
"key": "018963e5f06f716dadb0fe95b3c53d22",
"doc_count": 24
},
{
"key": "01896411e78a73399a29ed714246da0d",
"doc_count": 24
},
{
"key": "01896412f9bc701089f3add28ceb3d44",
"doc_count": 24
},
{
"key": "018963ea415c7217b4dc8cb62572ed16",
"doc_count": 22
},
{
"key": "018e521dcd9d73a2ae6c2864c11790df",
"doc_count": 21
},
{
"key": "018963ea20b670278236dc7103bcceb8",
"doc_count": 20
},
{
"key": "018963ea220370f6b3962a1108942bae",
"doc_count": 17
},
{
"key": "018bbe13b8237164810b74768f091ae7",
"doc_count": 15
},
{
"key": "018bbe13bf4971378f6c9737de6890aa",
"doc_count": 15
},
{
"key": "01896411e6eb71ccbac66ed4a361c281",
"doc_count": 13
},
{
"key": "018c1b62b9947095a00aac5109e05961",
"doc_count": 9
},
{
"key": "018bbe13bba571c9a39ca3fe33a172cd",
"doc_count": 8
},
{
"key": "018c8272ae307310b51499f1ec19bb55",
"doc_count": 7
},
{
"key": "018963ea336b7003ba1d74549036192d",
"doc_count": 6
},
{
"key": "018963ea3609712896e2d21c3a2d91ab",
"doc_count": 6
},
{
"key": "01896411ea347043b0788892761b1dff",
"doc_count": 6
},
{
"key": "018e521dcccd73f99af19d59c64fe353",
"doc_count": 6
},
{
"key": "018963ea1a0071e3b903843432a2818e",
"doc_count": 5
},
{
"key": "018bbe13baeb7369bc549fcbcdce4c6d",
"doc_count": 5
},
{
"key": "018e521dce71734facb10c03003a08ee",
"doc_count": 5
},
{
"key": "018bbe13bff4727baa40d87b9df82a76",
"doc_count": 3
},
{
"key": "018bbe13b7757294bf18b34533cada9d",
"doc_count": 2
},
{
"key": "018bbe13b97a72e79ffb27e38f96bbb2",
"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": 92
},
{
"key": "1cadc079599b4e0386adc59541691ef7",
"doc_count": 74
},
{
"key": "d8ac016c293145ff9d20f96184a4ad02",
"doc_count": 50
},
{
"key": "1a0ffc50b3584a1abd28c2d06d6c6465",
"doc_count": 39
},
{
"key": "38433195e9d345108b1593626fcdaba0",
"doc_count": 9
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|