| 1 |
14.50 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":"0189981208f87032a830c0cc3ebb4482"}}}},{"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": 11,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 602,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7d59659e72e1a6e0dbf04027ca27",
"_score": null,
"_source": {
"autoIncrement": 1147269.0,
"id": "018c7d59659e72e1a6e0dbf04027ca27"
},
"fields": {
"displayGroup": [
"2aa54ee87ba70110a67727e4da3a9aaf"
]
},
"sort": [
0,
"018c7d59659e72e1a6e0dbf04027ca27"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7d5979df72cd86705462498e2309",
"_score": null,
"_source": {
"autoIncrement": 1147271.0,
"id": "018c7d5979df72cd86705462498e2309"
},
"fields": {
"displayGroup": [
"b22566e049273db79cbfe44b2047153b"
]
},
"sort": [
0,
"018c7d5979df72cd86705462498e2309"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7d5b3e147199acb0161e58f31694",
"_score": null,
"_source": {
"autoIncrement": 1147281.0,
"id": "018c7d5b3e147199acb0161e58f31694"
},
"fields": {
"displayGroup": [
"0a952f29582c947e764e8f4dd3d2608f"
]
},
"sort": [
0,
"018c7d5b3e147199acb0161e58f31694"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7d5c7b8c70db93f79628f5b23868",
"_score": null,
"_source": {
"autoIncrement": 1147311.0,
"id": "018c7d5c7b8c70db93f79628f5b23868"
},
"fields": {
"displayGroup": [
"e42a22f617624fe4e9bf836416f5966f"
]
},
"sort": [
0,
"018c7d5c7b8c70db93f79628f5b23868"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7d5d30c872bf8b558884cb31ca71",
"_score": null,
"_source": {
"autoIncrement": 1147315.0,
"id": "018c7d5d30c872bf8b558884cb31ca71"
},
"fields": {
"displayGroup": [
"f972ffdbfca9ef74053ad90bc0768e7d"
]
},
"sort": [
0,
"018c7d5d30c872bf8b558884cb31ca71"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7d5d661372a6bcc117cddd142d8f",
"_score": null,
"_source": {
"autoIncrement": 1147320.0,
"id": "018c7d5d661372a6bcc117cddd142d8f"
},
"fields": {
"displayGroup": [
"0728aa476297d3706165cdfd6d5c5e19"
]
},
"sort": [
0,
"018c7d5d661372a6bcc117cddd142d8f"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7d5de1ee723fb3c215ad2e534940",
"_score": null,
"_source": {
"autoIncrement": 1147325.0,
"id": "018c7d5de1ee723fb3c215ad2e534940"
},
"fields": {
"displayGroup": [
"0372292621b62280f5235396486a04a1"
]
},
"sort": [
0,
"018c7d5de1ee723fb3c215ad2e534940"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7d5dec5a73ba87361ea722ac324b",
"_score": null,
"_source": {
"autoIncrement": 1147326.0,
"id": "018c7d5dec5a73ba87361ea722ac324b"
},
"fields": {
"displayGroup": [
"63badfbf9b2893eeabff181cc52f0e91"
]
},
"sort": [
0,
"018c7d5dec5a73ba87361ea722ac324b"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7d5faea4704e91f0a04ca9152700",
"_score": null,
"_source": {
"autoIncrement": 1147336.0,
"id": "018c7d5faea4704e91f0a04ca9152700"
},
"fields": {
"displayGroup": [
"ee433511ffbcc6dce085b3fde8297b8a"
]
},
"sort": [
0,
"018c7d5faea4704e91f0a04ca9152700"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7f2558f270a2bb6f0b6232c15bf6",
"_score": null,
"_source": {
"autoIncrement": 1163468.0,
"id": "018c7f2558f270a2bb6f0b6232c15bf6"
},
"fields": {
"displayGroup": [
"ef0e2093cfa7fca7246778cc4db03c9f"
]
},
"sort": [
0,
"018c7f2558f270a2bb6f0b6232c15bf6"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7f287fd37237a1a463ebf1327642",
"_score": null,
"_source": {
"autoIncrement": 1163477.0,
"id": "018c7f287fd37237a1a463ebf1327642"
},
"fields": {
"displayGroup": [
"b995762d2c0525003446bab38ed34d11"
]
},
"sort": [
0,
"018c7f287fd37237a1a463ebf1327642"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7f2b9a0e72bdb9bb78db69087bee",
"_score": null,
"_source": {
"autoIncrement": 1163480.0,
"id": "018c7f2b9a0e72bdb9bb78db69087bee"
},
"fields": {
"displayGroup": [
"721783555acc85456200020006e529a3"
]
},
"sort": [
0,
"018c7f2b9a0e72bdb9bb78db69087bee"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018cd0f49e95737183cf245f618e4881",
"_score": null,
"_source": {
"autoIncrement": 1224103.0,
"id": "018cd0f49e95737183cf245f618e4881"
},
"fields": {
"displayGroup": [
"e04c56fbc89a28e755624a9bb22f996f"
]
},
"sort": [
0,
"018cd0f49e95737183cf245f618e4881"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018cd0f6ce9c73cab56f2faae07ad27b",
"_score": null,
"_source": {
"autoIncrement": 1224187.0,
"id": "018cd0f6ce9c73cab56f2faae07ad27b"
},
"fields": {
"displayGroup": [
"484fa095f2b952e15355957e47eebf97"
]
},
"sort": [
0,
"018cd0f6ce9c73cab56f2faae07ad27b"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018cd0f7550671f2b0f13cbc2950179d",
"_score": null,
"_source": {
"autoIncrement": 1224214.0,
"id": "018cd0f7550671f2b0f13cbc2950179d"
},
"fields": {
"displayGroup": [
"0ad96efabb039d7afc6c1747f404a099"
]
},
"sort": [
0,
"018cd0f7550671f2b0f13cbc2950179d"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018cd0f9192270c284f2d2cf22c35b2c",
"_score": null,
"_source": {
"autoIncrement": 1224244.0,
"id": "018cd0f9192270c284f2d2cf22c35b2c"
},
"fields": {
"displayGroup": [
"bca328cfca1dd0651a51131cc52410a7"
]
},
"sort": [
0,
"018cd0f9192270c284f2d2cf22c35b2c"
]
}
]
},
"aggregations": {
"total-count": {
"value": 39
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
9.14 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":"0189981208f87032a830c0cc3ebb4482"}}}},{"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": 0,
"shipping-free": {
"value": null
}
},
"rating-exists": {
"doc_count": 602,
"rating": {
"value": 0.0
}
},
"price": {
"count": 602,
"min": 19.57,
"max": 139.97,
"avg": 55.31058139534884,
"sum": 33296.97
},
"options": {
"doc_count": 1226,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "018c6904e760723d986b6a748a00efbc",
"doc_count": 142
},
{
"key": "018c690559417041adb5044232bfc8bb",
"doc_count": 115
},
{
"key": "df41139ab42a4f0dbe2167afb103b833",
"doc_count": 96
},
{
"key": "63a3e4e3a8d0461ca937227647cbc474",
"doc_count": 92
},
{
"key": "6818490b3d264af396bf32b5c741cb18",
"doc_count": 88
},
{
"key": "b26bb94349e2469ea3e048b8bd50a91d",
"doc_count": 88
},
{
"key": "103c221ef5c547a6919548726a45adb7",
"doc_count": 84
},
{
"key": "bace55c509624d8ab8a0c4653bced477",
"doc_count": 79
},
{
"key": "018c6904c0ff70c0a7d346ac36ccc59b",
"doc_count": 51
},
{
"key": "018c6904a60a71d58e25430d71ee064a",
"doc_count": 44
},
{
"key": "f1c0d70c9b714c4cb27beb8f22273242",
"doc_count": 38
},
{
"key": "018c69059af8737298fac85ba1336ec4",
"doc_count": 27
},
{
"key": "018c7c8072f27105975c50cd0d8b57f1",
"doc_count": 24
},
{
"key": "018c6905a29f7081ae2ba42ac45b8f66",
"doc_count": 23
},
{
"key": "018c6903551970d8a468a8198cb25bdc",
"doc_count": 16
},
{
"key": "2d698a78a97547d29aad7b1607d32dec",
"doc_count": 16
},
{
"key": "3d0b11d1db0f48f7acb284976d0b45e0",
"doc_count": 15
},
{
"key": "018c6904e690706694d553e1e2a8b83b",
"doc_count": 13
},
{
"key": "018c6904d8857287802a1f9bff5c5f0e",
"doc_count": 12
},
{
"key": "018c7c801cad7364b8096d9269f03a7b",
"doc_count": 12
},
{
"key": "018c6904d0507073814ad4395c8f277e",
"doc_count": 11
},
{
"key": "018c6904d12370ccb7f4693d63968fa2",
"doc_count": 11
},
{
"key": "018c6905960870e5a7819a3b05d149da",
"doc_count": 10
},
{
"key": "018c6904de4172a5a1a087558dfcc954",
"doc_count": 8
},
{
"key": "b092a626e02e4a789d2ece1cfd262bf1",
"doc_count": 8
},
{
"key": "e66ee1ff38184b57a51761c4b09ad960",
"doc_count": 8
},
{
"key": "018c69035443706e8e41a0b62539aba6",
"doc_count": 7
},
{
"key": "018c6905588172288eabff6ff1b163eb",
"doc_count": 7
},
{
"key": "018c69045a19716bb98c5decbc2ed0f1",
"doc_count": 6
},
{
"key": "018c69059bbb712f98829781a421dfe3",
"doc_count": 6
},
{
"key": "018c69059e53714e92dcd4a66857ddf1",
"doc_count": 6
},
{
"key": "018c7c806acd734684c14978190341fd",
"doc_count": 6
},
{
"key": "df6fe8b91f9940ab9fb025c7fa1052ed",
"doc_count": 6
},
{
"key": "018c6904a6e2731d9b605fbe89e3502e",
"doc_count": 5
},
{
"key": "018c6905666c730a967a2858ec186d7b",
"doc_count": 5
},
{
"key": "018c7c80674c712da775e064cf24c040",
"doc_count": 5
},
{
"key": "018e866f6f70732c8c13cc5ef83988e4",
"doc_count": 5
},
{
"key": "018c6904beab731fb3688f7e59704624",
"doc_count": 4
},
{
"key": "018c6904e82873ceb2edba9f152f829b",
"doc_count": 4
},
{
"key": "018c6cf0eb06731d94a2627780fcd751",
"doc_count": 4
},
{
"key": "018c6904846c734bb2d819635409e7e5",
"doc_count": 3
},
{
"key": "018c6904e313706faa609e31633f8059",
"doc_count": 3
},
{
"key": "018c7c8065c0701b853439180e303fd8",
"doc_count": 3
},
{
"key": "018c7c80691670329421027cbe512a5c",
"doc_count": 3
},
{
"key": "018c690567267084a1ae531598f2f446",
"doc_count": 2
},
{
"key": "1c23aae651524363801a44213f31f325",
"doc_count": 2
},
{
"key": "018c6904e90670918c646b490d6b1e6f",
"doc_count": 1
},
{
"key": "018c7c806f197069b8e424cf490341ac",
"doc_count": 1
},
{
"key": "018c7c808dd972f9b9b2735d55462343",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 1799,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "018dcc3373f47133833772ee8dfc3fe4",
"doc_count": 587
},
{
"key": "018963e5f06f716dadb0fe95b3c53d22",
"doc_count": 345
},
{
"key": "018963e5f13871739bde1b0eb26bb21b",
"doc_count": 257
},
{
"key": "018963ea1812737fb7f416641565cd24",
"doc_count": 200
},
{
"key": "018963ea3aba7042895b047285c1402e",
"doc_count": 161
},
{
"key": "018963ea220370f6b3962a1108942bae",
"doc_count": 102
},
{
"key": "018963ea3964707fbbfb35b2b8e8084b",
"doc_count": 50
},
{
"key": "018963ea24c172519a11176e570bcae4",
"doc_count": 37
},
{
"key": "018963ea415c7217b4dc8cb62572ed16",
"doc_count": 35
},
{
"key": "018963ea1aa171879381a1be09d5fd97",
"doc_count": 6
},
{
"key": "018963ea20b670278236dc7103bcceb8",
"doc_count": 6
},
{
"key": "01896411e25971f98272a565102c3faf",
"doc_count": 5
},
{
"key": "018963ea336b7003ba1d74549036192d",
"doc_count": 3
},
{
"key": "018e197a639c736c89efac77dea4476e",
"doc_count": 3
},
{
"key": "01896412cf737195bf02206f036d4644",
"doc_count": 2
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "018c7c9a622870078a62e47c70408932",
"doc_count": 600
},
{
"key": "1a0ffc50b3584a1abd28c2d06d6c6465",
"doc_count": 2
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|