| 1 |
620.59 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":"018997b7c8d770f3b8f9f961720ab710"}}}},{"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": 617,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 259,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7ec9256973cf98306d75d82f3caa",
"_score": null,
"_source": {
"autoIncrement": 1155042.0,
"id": "018c7ec9256973cf98306d75d82f3caa"
},
"fields": {
"displayGroup": [
"a56497193db71a94cde35c94e96cd1b5"
]
},
"sort": [
11,
"018c7ec9256973cf98306d75d82f3caa"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7ec8682271f2a85c30581cb52af8",
"_score": null,
"_source": {
"autoIncrement": 1154945.0,
"id": "018c7ec8682271f2a85c30581cb52af8"
},
"fields": {
"displayGroup": [
"022e009579fb1ee057a15b3d25160107"
]
},
"sort": [
1,
"018c7ec8682271f2a85c30581cb52af8"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0190ea31592673e4804a7006b95aa462",
"_score": null,
"_source": {
"autoIncrement": 1842227.0,
"id": "0190ea31592673e4804a7006b95aa462"
},
"fields": {
"displayGroup": [
"681b4a4e5c0b06cc159c783b7f8a92ff"
]
},
"sort": [
1,
"0190ea31592673e4804a7006b95aa462"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0038410cbeb548ce9c87930e84929573",
"_score": null,
"_source": {
"autoIncrement": 999828.0,
"id": "0038410cbeb548ce9c87930e84929573"
},
"fields": {
"displayGroup": [
"03f65288f3619193a09cc53f31c4a639"
]
},
"sort": [
0,
"0038410cbeb548ce9c87930e84929573"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bd1f3458a73e5adc184221c9034c3",
"_score": null,
"_source": {
"autoIncrement": 1138020.0,
"id": "018bd1f3458a73e5adc184221c9034c3"
},
"fields": {
"displayGroup": [
"42bfb6948cd54dd7457f245ce9efaf48"
]
},
"sort": [
0,
"018bd1f3458a73e5adc184221c9034c3"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bd61abb8471cf874425b22f447f6b",
"_score": null,
"_source": {
"autoIncrement": 1139556.0,
"id": "018bd61abb8471cf874425b22f447f6b"
},
"fields": {
"displayGroup": [
"3bb0ab0e6bd00921be513914d7ac3c85"
]
},
"sort": [
0,
"018bd61abb8471cf874425b22f447f6b"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7ec9798870aaa9262741bd69f16b",
"_score": null,
"_source": {
"autoIncrement": 1155077.0,
"id": "018c7ec9798870aaa9262741bd69f16b"
},
"fields": {
"displayGroup": [
"20b0ff071d8a81347468f2dde3cf201e"
]
},
"sort": [
0,
"018c7ec9798870aaa9262741bd69f16b"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7ec9bd91722782d4005626ab3e57",
"_score": null,
"_source": {
"autoIncrement": 1155100.0,
"id": "018c7ec9bd91722782d4005626ab3e57"
},
"fields": {
"displayGroup": [
"65718ddb74391acd25e99f9795bd232c"
]
},
"sort": [
0,
"018c7ec9bd91722782d4005626ab3e57"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7f04159a7204aba82607185cdc5b",
"_score": null,
"_source": {
"autoIncrement": 1161925.0,
"id": "018c7f04159a7204aba82607185cdc5b"
},
"fields": {
"displayGroup": [
"5295c0a4dca6ce87a2df4a0041c34c0f"
]
},
"sort": [
0,
"018c7f04159a7204aba82607185cdc5b"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c8895ef2473ad99bc90988ff49f0f",
"_score": null,
"_source": {
"autoIncrement": 1170015.0,
"id": "018c8895ef2473ad99bc90988ff49f0f"
},
"fields": {
"displayGroup": [
"eceaf25549196b3f2a47220ef21ac723"
]
},
"sort": [
0,
"018c8895ef2473ad99bc90988ff49f0f"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c8895fec4703bbc4d2316baa0fb4c",
"_score": null,
"_source": {
"autoIncrement": 1170027.0,
"id": "018c8895fec4703bbc4d2316baa0fb4c"
},
"fields": {
"displayGroup": [
"42c90128bd66881f664fa1c9cfd7608e"
]
},
"sort": [
0,
"018c8895fec4703bbc4d2316baa0fb4c"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c889af68973169c2f755696966791",
"_score": null,
"_source": {
"autoIncrement": 1170436.0,
"id": "018c889af68973169c2f755696966791"
},
"fields": {
"displayGroup": [
"ee82d38ba73572d56f849eae847eece8"
]
},
"sort": [
0,
"018c889af68973169c2f755696966791"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d1021b98173478e65a7f183a47fbd",
"_score": null,
"_source": {
"autoIncrement": 1240046.0,
"id": "018d1021b98173478e65a7f183a47fbd"
},
"fields": {
"displayGroup": [
"d54cc7a01526975a991e90e8e37a279f"
]
},
"sort": [
0,
"018d1021b98173478e65a7f183a47fbd"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d1034773f70f4a25514130ca10dd6",
"_score": null,
"_source": {
"autoIncrement": 1240188.0,
"id": "018d1034773f70f4a25514130ca10dd6"
},
"fields": {
"displayGroup": [
"7300bbdb7086498ed64d774018aaff45"
]
},
"sort": [
0,
"018d1034773f70f4a25514130ca10dd6"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d1137c36c73beadcfe9d0b72b3f3d",
"_score": null,
"_source": {
"autoIncrement": 1244178.0,
"id": "018d1137c36c73beadcfe9d0b72b3f3d"
},
"fields": {
"displayGroup": [
"524a0a55e0cc71f23d52598dc652ef34"
]
},
"sort": [
0,
"018d1137c36c73beadcfe9d0b72b3f3d"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d1fddb10f71858e46c5110715ccd9",
"_score": null,
"_source": {
"autoIncrement": 1259806.0,
"id": "018d1fddb10f71858e46c5110715ccd9"
},
"fields": {
"displayGroup": [
"623f88f37ff2272b0787a0ff845f616e"
]
},
"sort": [
0,
"018d1fddb10f71858e46c5110715ccd9"
]
}
]
},
"aggregations": {
"total-count": {
"value": 21
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
10.84 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":"018997b7c8d770f3b8f9f961720ab710"}}}},{"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": 1,
"shipping-free": {
"value": 1.0,
"value_as_string": "true"
}
},
"rating-exists": {
"doc_count": 259,
"rating": {
"value": 0.0
}
},
"price": {
"count": 259,
"min": 12.75,
"max": 89.99,
"avg": 22.93108108108108,
"sum": 5939.15
},
"options": {
"doc_count": 518,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "507f2e527d524e359c477d74d4605b1f",
"doc_count": 44
},
{
"key": "20db184c1fdb49508a4ccd08b882a19f",
"doc_count": 42
},
{
"key": "5e2f46d53cb046f9a5f9736c372966f8",
"doc_count": 42
},
{
"key": "60de90a916684ef696e8ba9bd8060cbc",
"doc_count": 41
},
{
"key": "37347e78acc44de0a2b07896ba5339c0",
"doc_count": 35
},
{
"key": "018b6aa3d18f7200abf662eedbcbb87a",
"doc_count": 19
},
{
"key": "88e37ca9c31b4575a7e4c105a1139281",
"doc_count": 18
},
{
"key": "018b6a9f641e717493ed223910d755b3",
"doc_count": 17
},
{
"key": "f58faace294945af9f1442838b3a6e8d",
"doc_count": 17
},
{
"key": "018b6a9f5f7571c39fe8fc54d481eae4",
"doc_count": 14
},
{
"key": "018b6a9f6c9873379da9231c4e2ac056",
"doc_count": 14
},
{
"key": "addda850cb3d4d8d819a5a9f16b44b50",
"doc_count": 13
},
{
"key": "b7409471158e4068a053dca04ad51e0a",
"doc_count": 11
},
{
"key": "30fad97b5aa4443ca76571f675554d6a",
"doc_count": 9
},
{
"key": "7eb0072858944b0b852f18f2179064c7",
"doc_count": 7
},
{
"key": "c94ee9600a2c4779a2d6f9468ceaa076",
"doc_count": 7
},
{
"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": "bc67e9d6ebae4d4e9da2b2481b12f7d3",
"doc_count": 6
},
{
"key": "018c690506c2729cbb113b4d05d2da4a",
"doc_count": 5
},
{
"key": "018dd5f6ea6641c7b569a0bef47cdc68",
"doc_count": 5
},
{
"key": "187ad318b6834dd088552f34a0dd947e",
"doc_count": 5
},
{
"key": "189a3e73076d4f488b498140c8a07321",
"doc_count": 5
},
{
"key": "1a82b459b30e47a98a4da3220e6eb67e",
"doc_count": 5
},
{
"key": "1c4d6bec820a4f29b340e64bfc56c352",
"doc_count": 5
},
{
"key": "1d945cc308024f22bf772ff9bd094979",
"doc_count": 5
},
{
"key": "2bc45bc05df945f8a5403892f38513f9",
"doc_count": 5
},
{
"key": "3522f42969ac48adb918e8a185ef7a4c",
"doc_count": 5
},
{
"key": "3d4a378833ff43e2b1d708e4dcff645e",
"doc_count": 5
},
{
"key": "6de5871927ab44a4a0ab18ec391241d2",
"doc_count": 5
},
{
"key": "dfff780768784cf1b858239371853d79",
"doc_count": 5
},
{
"key": "018c6905218c7081807110652a60c479",
"doc_count": 4
},
{
"key": "018c69058b88728cb53dd46b1fa59bc8",
"doc_count": 4
},
{
"key": "476d3085cf474460bc2575974a9e29c1",
"doc_count": 4
},
{
"key": "7a0ac74a37134c3981c2a3a5a6028f3d",
"doc_count": 4
},
{
"key": "af985f0f29164155b1c51cce3071b732",
"doc_count": 4
},
{
"key": "c69433ba9ec14df6a9e44fa247b86507",
"doc_count": 4
},
{
"key": "018b6a9f66e67042bf056d5ced85577a",
"doc_count": 3
},
{
"key": "018c69055fc471ccab7fbd63e522638d",
"doc_count": 3
},
{
"key": "018c69050b9c70d4b739e1a80a38fd35",
"doc_count": 2
},
{
"key": "75ce433a3c32418581a560bbaaeadda1",
"doc_count": 2
},
{
"key": "9889fbcc72f0425fa5b8bc060712ff30",
"doc_count": 2
},
{
"key": "9d5ff5f309c2404788c259b20f8b61c4",
"doc_count": 2
},
{
"key": "abb0ab38286147aeb3d7fe0c4851cc7c",
"doc_count": 2
},
{
"key": "018c690524db70d39c7b89e47a2beb2d",
"doc_count": 1
},
{
"key": "018c6905923172699bc793d6df3aeb5a",
"doc_count": 1
},
{
"key": "1c23aae651524363801a44213f31f325",
"doc_count": 1
},
{
"key": "4032569e02fd47788cce9dfa86eeac55",
"doc_count": 1
},
{
"key": "5affb90217af40c58011013f87e6b516",
"doc_count": 1
},
{
"key": "799c7a073235425488a33d5daae0474c",
"doc_count": 1
},
{
"key": "8ea3effd68d54c9e8ac4653cbd37ee1b",
"doc_count": 1
},
{
"key": "df1e3e9fd6ab4cf2b57b05b6c4262297",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 971,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "018963e5f32b703288aad57690802852",
"doc_count": 173
},
{
"key": "01896411e3007292bbf291a9837a8cc8",
"doc_count": 138
},
{
"key": "01896412c4d372afb007071030df2b40",
"doc_count": 129
},
{
"key": "018bbe147614712bb735c9a8d2d50799",
"doc_count": 66
},
{
"key": "01896411e3af718192fb7f9ee45ad6fb",
"doc_count": 61
},
{
"key": "018963e5f13871739bde1b0eb26bb21b",
"doc_count": 54
},
{
"key": "018963ea3aba7042895b047285c1402e",
"doc_count": 52
},
{
"key": "018963ea1812737fb7f416641565cd24",
"doc_count": 45
},
{
"key": "018963ea3964707fbbfb35b2b8e8084b",
"doc_count": 32
},
{
"key": "018e521dcd9d73a2ae6c2864c11790df",
"doc_count": 23
},
{
"key": "018963ea220370f6b3962a1108942bae",
"doc_count": 19
},
{
"key": "018963ea24c172519a11176e570bcae4",
"doc_count": 19
},
{
"key": "018dcc3373f47133833772ee8dfc3fe4",
"doc_count": 19
},
{
"key": "01896411e78a73399a29ed714246da0d",
"doc_count": 18
},
{
"key": "018964129394713eb8125185729c3a1e",
"doc_count": 16
},
{
"key": "018963e5f53b7292b003bf6803f624b7",
"doc_count": 14
},
{
"key": "0189641292b27351b91fb77f36a06de0",
"doc_count": 14
},
{
"key": "018963e5f06f716dadb0fe95b3c53d22",
"doc_count": 10
},
{
"key": "018963e5f5e173a4afde33792d6fe12f",
"doc_count": 10
},
{
"key": "01896411e59f727b8b482ff954d67fa9",
"doc_count": 10
},
{
"key": "01896412913b7038950ef278d2351ea4",
"doc_count": 10
},
{
"key": "018bbe13bff4727baa40d87b9df82a76",
"doc_count": 9
},
{
"key": "018963ea2f4872f5b65ae53cf081df0e",
"doc_count": 5
},
{
"key": "018963ea313d732aab9f9437134e1b76",
"doc_count": 5
},
{
"key": "018963ea3e0572c6960c0eadf8b16c7f",
"doc_count": 5
},
{
"key": "01896411e05c71f4af78a5552a40b626",
"doc_count": 5
},
{
"key": "018bbe13bf4971378f6c9737de6890aa",
"doc_count": 5
},
{
"key": "018963ea1e14736f89733679e4ac807d",
"doc_count": 4
},
{
"key": "01896412c2e673aa8fda83c9b551489a",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "1cadc079599b4e0386adc59541691ef7",
"doc_count": 102
},
{
"key": "018f76587934730f8674bc05947f9054",
"doc_count": 54
},
{
"key": "69126f5efcab45738b242009148aca51",
"doc_count": 38
},
{
"key": "2a606633b77f4e1bab45f45f3483a835",
"doc_count": 35
},
{
"key": "0eb8635d02c643c2b1d22ea1631c0c90",
"doc_count": 20
},
{
"key": "1a0ffc50b3584a1abd28c2d06d6c6465",
"doc_count": 10
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|