| 1 |
1183.76 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":"0189977b2cdd71019064ccc702ca361d"}}}},{"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": 1180,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 476,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d8f0154d671d5afe6ef32976468c5",
"_score": null,
"_source": {
"autoIncrement": 1284029.0,
"id": "018d8f0154d671d5afe6ef32976468c5"
},
"fields": {
"displayGroup": [
"49f96dbac8a0c36546d5bb39af01812c"
]
},
"sort": [
23,
"018d8f0154d671d5afe6ef32976468c5"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7ec8c74b72e78367ef95480922b4",
"_score": null,
"_source": {
"autoIncrement": 1154999.0,
"id": "018c7ec8c74b72e78367ef95480922b4"
},
"fields": {
"displayGroup": [
"dae0f3bf43de3e4b9fd9b22f380e60a4"
]
},
"sort": [
18,
"018c7ec8c74b72e78367ef95480922b4"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0190a3ec7935731986887d816392dda9",
"_score": null,
"_source": {
"autoIncrement": 1835948.0,
"id": "0190a3ec7935731986887d816392dda9"
},
"fields": {
"displayGroup": [
"cb398d0a7a31b63071d803c3b8bae714"
]
},
"sort": [
10,
"0190a3ec7935731986887d816392dda9"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0190a218ce5c728fb8b6a191a9a27f2b",
"_score": null,
"_source": {
"autoIncrement": 1834968.0,
"id": "0190a218ce5c728fb8b6a191a9a27f2b"
},
"fields": {
"displayGroup": [
"74e7fdb0deb18e903775c8a46253ca86"
]
},
"sort": [
9,
"0190a218ce5c728fb8b6a191a9a27f2b"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7ec8385271c484805ddc0a1b4b28",
"_score": null,
"_source": {
"autoIncrement": 1154891.0,
"id": "018c7ec8385271c484805ddc0a1b4b28"
},
"fields": {
"displayGroup": [
"1b416cc05bfe099408624201c51b1990"
]
},
"sort": [
2,
"018c7ec8385271c484805ddc0a1b4b28"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018cda9c81cc7031a781cd6bf5f382a5",
"_score": null,
"_source": {
"autoIncrement": 1227790.0,
"id": "018cda9c81cc7031a781cd6bf5f382a5"
},
"fields": {
"displayGroup": [
"71bb10b0b27e80fab3430e741c69e9a4"
]
},
"sort": [
2,
"018cda9c81cc7031a781cd6bf5f382a5"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018f779290d0720b88d7215d41d5804b",
"_score": null,
"_source": {
"autoIncrement": 1781313.0,
"id": "018f779290d0720b88d7215d41d5804b"
},
"fields": {
"displayGroup": [
"98f94b4c7b294cda12a71dee34388eef"
]
},
"sort": [
1,
"018f779290d0720b88d7215d41d5804b"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018af465780b71949426cc19bad675f3",
"_score": null,
"_source": {
"autoIncrement": 1131535.0,
"id": "018af465780b71949426cc19bad675f3"
},
"fields": {
"displayGroup": [
"cf31f3a372f98bee98599bcc8f0409d5"
]
},
"sort": [
0,
"018af465780b71949426cc19bad675f3"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018af4674577739fae49e76fa1c96a91",
"_score": null,
"_source": {
"autoIncrement": 1131739.0,
"id": "018af4674577739fae49e76fa1c96a91"
},
"fields": {
"displayGroup": [
"261f3f6f32e1e3c9145e92f5696db8f4"
]
},
"sort": [
0,
"018af4674577739fae49e76fa1c96a91"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018af4675a7f72c9b60c935ff7f77e6d",
"_score": null,
"_source": {
"autoIncrement": 1131750.0,
"id": "018af4675a7f72c9b60c935ff7f77e6d"
},
"fields": {
"displayGroup": [
"6f2067ae8314ad6bc0b837755adf1b64"
]
},
"sort": [
0,
"018af4675a7f72c9b60c935ff7f77e6d"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018af4676b33739da6f2f2372b0133e5",
"_score": null,
"_source": {
"autoIncrement": 1131757.0,
"id": "018af4676b33739da6f2f2372b0133e5"
},
"fields": {
"displayGroup": [
"c5f920b9a8c7e4b379f2defd3b82159e"
]
},
"sort": [
0,
"018af4676b33739da6f2f2372b0133e5"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018af46802047055bf1b214dcf74d54f",
"_score": null,
"_source": {
"autoIncrement": 1131812.0,
"id": "018af46802047055bf1b214dcf74d54f"
},
"fields": {
"displayGroup": [
"6e6096701f8c092314a6c2f622a8086e"
]
},
"sort": [
0,
"018af46802047055bf1b214dcf74d54f"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bd1ed221e70cc936df5be51585714",
"_score": null,
"_source": {
"autoIncrement": 1137970.0,
"id": "018bd1ed221e70cc936df5be51585714"
},
"fields": {
"displayGroup": [
"81df580af16e8ae1a4138ac4b48cd5a2"
]
},
"sort": [
0,
"018bd1ed221e70cc936df5be51585714"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bd2004e6273e8980ab42cfdb9bf2a",
"_score": null,
"_source": {
"autoIncrement": 1138185.0,
"id": "018bd2004e6273e8980ab42cfdb9bf2a"
},
"fields": {
"displayGroup": [
"97123f8d356d434b23eefd328df7453e"
]
},
"sort": [
0,
"018bd2004e6273e8980ab42cfdb9bf2a"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bd200fd7472759813a2910cf1f670",
"_score": null,
"_source": {
"autoIncrement": 1138200.0,
"id": "018bd200fd7472759813a2910cf1f670"
},
"fields": {
"displayGroup": [
"f94e52110e1704bb893c9d59d4593fd7"
]
},
"sort": [
0,
"018bd200fd7472759813a2910cf1f670"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bd202b11d723492da1c3938b61b6b",
"_score": null,
"_source": {
"autoIncrement": 1138213.0,
"id": "018bd202b11d723492da1c3938b61b6b"
},
"fields": {
"displayGroup": [
"05e38020fa8117c8b98127092afa46f1"
]
},
"sort": [
0,
"018bd202b11d723492da1c3938b61b6b"
]
}
]
},
"aggregations": {
"total-count": {
"value": 40
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
12.23 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":"0189977b2cdd71019064ccc702ca361d"}}}},{"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_rulef56aa66553b04105839b38b9288ce3ed_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": 10,
"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": 476,
"rating": {
"value": 0.0
}
},
"price": {
"count": 476,
"min": 13.75,
"max": 155.97,
"avg": 46.98506302521008,
"sum": 22364.89
},
"options": {
"doc_count": 952,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "df41139ab42a4f0dbe2167afb103b833",
"doc_count": 78
},
{
"key": "103c221ef5c547a6919548726a45adb7",
"doc_count": 77
},
{
"key": "bace55c509624d8ab8a0c4653bced477",
"doc_count": 76
},
{
"key": "63a3e4e3a8d0461ca937227647cbc474",
"doc_count": 75
},
{
"key": "6818490b3d264af396bf32b5c741cb18",
"doc_count": 73
},
{
"key": "f1c0d70c9b714c4cb27beb8f22273242",
"doc_count": 60
},
{
"key": "90deb273963c446380e69696e17dbc1c",
"doc_count": 50
},
{
"key": "018b6a9f641e717493ed223910d755b3",
"doc_count": 27
},
{
"key": "018b6aa3d18f7200abf662eedbcbb87a",
"doc_count": 27
},
{
"key": "88e37ca9c31b4575a7e4c105a1139281",
"doc_count": 27
},
{
"key": "f58faace294945af9f1442838b3a6e8d",
"doc_count": 27
},
{
"key": "3d0b11d1db0f48f7acb284976d0b45e0",
"doc_count": 22
},
{
"key": "018b6a9f5f7571c39fe8fc54d481eae4",
"doc_count": 20
},
{
"key": "018b6a9f6c9873379da9231c4e2ac056",
"doc_count": 20
},
{
"key": "addda850cb3d4d8d819a5a9f16b44b50",
"doc_count": 19
},
{
"key": "b26bb94349e2469ea3e048b8bd50a91d",
"doc_count": 15
},
{
"key": "880165329a9044bcb724f3584510bc85",
"doc_count": 12
},
{
"key": "3d4a378833ff43e2b1d708e4dcff645e",
"doc_count": 11
},
{
"key": "173130b9d0a74bffb54773f34ab59969",
"doc_count": 7
},
{
"key": "1893e0d032a345bbb19b4546335821fc",
"doc_count": 7
},
{
"key": "1c4d6bec820a4f29b340e64bfc56c352",
"doc_count": 7
},
{
"key": "bd632db1c2a34df8993e0e518bd1f7fb",
"doc_count": 7
},
{
"key": "cd275ca66d4b46bdbb87b65c61bc764f",
"doc_count": 7
},
{
"key": "df1e3e9fd6ab4cf2b57b05b6c4262297",
"doc_count": 7
},
{
"key": "018c690506c2729cbb113b4d05d2da4a",
"doc_count": 6
},
{
"key": "018c69050adf72eea9ad4878b84a6174",
"doc_count": 6
},
{
"key": "018c6905218c7081807110652a60c479",
"doc_count": 6
},
{
"key": "018c69058b88728cb53dd46b1fa59bc8",
"doc_count": 6
},
{
"key": "018dd5f6ea6641c7b569a0bef47cdc68",
"doc_count": 6
},
{
"key": "018f7657fe5c7175b2f0a6d3f2c3a091",
"doc_count": 6
},
{
"key": "018f7658025270698601b725abce6a5e",
"doc_count": 6
},
{
"key": "018f76580d1c71be9b9a5486525d5bcc",
"doc_count": 6
},
{
"key": "018f765816187361b0bdc94cdefbf0c2",
"doc_count": 6
},
{
"key": "018f765831ac71f2ad5f4747b93b612c",
"doc_count": 6
},
{
"key": "018f7658495e71baabac4f07e8b918af",
"doc_count": 6
},
{
"key": "018f765855837292a9ba22e6ff932368",
"doc_count": 6
},
{
"key": "018f76586134713a840310a42734d8eb",
"doc_count": 6
},
{
"key": "018f76586bd37189be49edbeff042efe",
"doc_count": 6
},
{
"key": "0239b6f7eab64bf09f59f87c760ced0a",
"doc_count": 6
},
{
"key": "187ad318b6834dd088552f34a0dd947e",
"doc_count": 6
},
{
"key": "3522f42969ac48adb918e8a185ef7a4c",
"doc_count": 6
},
{
"key": "50b00542efdb4c3dafc5c8219f89439c",
"doc_count": 6
},
{
"key": "58e4037e6dd94c3f9776ec5664c9bfe1",
"doc_count": 6
},
{
"key": "8ea3effd68d54c9e8ac4653cbd37ee1b",
"doc_count": 6
},
{
"key": "dfff780768784cf1b858239371853d79",
"doc_count": 6
},
{
"key": "018c69036c5d709fa6759781d6dd5cff",
"doc_count": 5
},
{
"key": "1a82b459b30e47a98a4da3220e6eb67e",
"doc_count": 5
},
{
"key": "41d7e80eaa1a4df9a246fa60ff33a8da",
"doc_count": 5
},
{
"key": "62928a9126ab443abc1a143524712ff1",
"doc_count": 5
},
{
"key": "6dac80aa3b164978a79cd7424cee6c66",
"doc_count": 5
},
{
"key": "6ee6a8afee8b4bdf9e967e6ebfebd73e",
"doc_count": 5
},
{
"key": "ac8acff8be384289b146cd07c8f12c17",
"doc_count": 5
},
{
"key": "018c69039a7b71d98cd7e9899ecf1d7d",
"doc_count": 4
},
{
"key": "018c69055fc471ccab7fbd63e522638d",
"doc_count": 4
},
{
"key": "018c6905b0d4703988c2192139dc8561",
"doc_count": 4
},
{
"key": "7a0ac74a37134c3981c2a3a5a6028f3d",
"doc_count": 4
},
{
"key": "1743d6f3c850468f8a07ed115f3c11d4",
"doc_count": 3
},
{
"key": "799c7a073235425488a33d5daae0474c",
"doc_count": 3
},
{
"key": "018b6a9f66e67042bf056d5ced85577a",
"doc_count": 2
},
{
"key": "018c690524db70d39c7b89e47a2beb2d",
"doc_count": 2
},
{
"key": "6b8468942e674a8882d5d85923de7eba",
"doc_count": 2
},
{
"key": "018c69059094709fb7df9f051bc92fdb",
"doc_count": 1
},
{
"key": "018c7c80508a700ba50f1a91c3260292",
"doc_count": 1
},
{
"key": "018d97d42021737288bc8e6860c53d2d",
"doc_count": 1
},
{
"key": "018d97d420fc707eb8569775064e0672",
"doc_count": 1
},
{
"key": "07db9439c51e43a98a0674cab5164624",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 1950,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "01896412c43372e588debf827804f9a2",
"doc_count": 368
},
{
"key": "018963e5f13871739bde1b0eb26bb21b",
"doc_count": 291
},
{
"key": "01896411e3007292bbf291a9837a8cc8",
"doc_count": 228
},
{
"key": "018963e5f53b7292b003bf6803f624b7",
"doc_count": 178
},
{
"key": "018963ea1812737fb7f416641565cd24",
"doc_count": 137
},
{
"key": "018963ea3aba7042895b047285c1402e",
"doc_count": 103
},
{
"key": "018963ea3964707fbbfb35b2b8e8084b",
"doc_count": 92
},
{
"key": "01896411dfa972429a0b5b59515d3cd1",
"doc_count": 79
},
{
"key": "01896411e3af718192fb7f9ee45ad6fb",
"doc_count": 74
},
{
"key": "018bbe147614712bb735c9a8d2d50799",
"doc_count": 73
},
{
"key": "018963ea24c172519a11176e570bcae4",
"doc_count": 36
},
{
"key": "018dcc3373f47133833772ee8dfc3fe4",
"doc_count": 34
},
{
"key": "01896411e05c71f4af78a5552a40b626",
"doc_count": 28
},
{
"key": "018963ea220370f6b3962a1108942bae",
"doc_count": 27
},
{
"key": "01896412c23c713eb9774249e46316d1",
"doc_count": 23
},
{
"key": "018963ea20b670278236dc7103bcceb8",
"doc_count": 22
},
{
"key": "0189641292b27351b91fb77f36a06de0",
"doc_count": 22
},
{
"key": "018e521dcd9d73a2ae6c2864c11790df",
"doc_count": 16
},
{
"key": "01896411e82d73ef973f22bb35c69d07",
"doc_count": 12
},
{
"key": "018bbe13bff4727baa40d87b9df82a76",
"doc_count": 12
},
{
"key": "018bbe13c09d7328ba65279e42d55280",
"doc_count": 12
},
{
"key": "018963ea415c7217b4dc8cb62572ed16",
"doc_count": 10
},
{
"key": "018caa5387457189a250f2a759354448",
"doc_count": 10
},
{
"key": "018f05be38797323a8b66ffcbcbba8c8",
"doc_count": 9
},
{
"key": "01896411def07326a9a675aa2efc40ea",
"doc_count": 7
},
{
"key": "01896412c622722a925b8572430348e5",
"doc_count": 7
},
{
"key": "018f05be3e42705984113fc05f2dcab6",
"doc_count": 7
},
{
"key": "018963ea2f4872f5b65ae53cf081df0e",
"doc_count": 6
},
{
"key": "018963ea313d732aab9f9437134e1b76",
"doc_count": 6
},
{
"key": "018963ea3e0572c6960c0eadf8b16c7f",
"doc_count": 6
},
{
"key": "018bbe13bf4971378f6c9737de6890aa",
"doc_count": 6
},
{
"key": "018e5b89802a707bac98192a0797fc4e",
"doc_count": 6
},
{
"key": "018963ea1a0071e3b903843432a2818e",
"doc_count": 3
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "2a606633b77f4e1bab45f45f3483a835",
"doc_count": 183
},
{
"key": "1cadc079599b4e0386adc59541691ef7",
"doc_count": 150
},
{
"key": "018f76587934730f8674bc05947f9054",
"doc_count": 54
},
{
"key": "69126f5efcab45738b242009148aca51",
"doc_count": 50
},
{
"key": "0eb8635d02c643c2b1d22ea1631c0c90",
"doc_count": 30
},
{
"key": "d8ac016c293145ff9d20f96184a4ad02",
"doc_count": 9
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|