| 1 |
544.03 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":"0189976cee97734898274f67f420541f"}}}},{"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": 541,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 16,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_all4team_product_1716336301",
"_id": "3cc7e840ccaa44468e81a4ba2c7156ee",
"_score": null,
"_source": {
"autoIncrement": 1120754.0,
"id": "3cc7e840ccaa44468e81a4ba2c7156ee"
},
"fields": {
"displayGroup": [
"0308fc5d9ce74ab0f8b1c4a229cbc8fc"
]
},
"sort": [
1,
"3cc7e840ccaa44468e81a4ba2c7156ee"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018cb27ced4571d687e8124f4b364b88",
"_score": null,
"_source": {
"autoIncrement": 1211094.0,
"id": "018cb27ced4571d687e8124f4b364b88"
},
"fields": {
"displayGroup": [
"e2c75e1010161ff0f7e71b2af591304f"
]
},
"sort": [
0,
"018cb27ced4571d687e8124f4b364b88"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018cb27d00ab727985247e5f76b7ace0",
"_score": null,
"_source": {
"autoIncrement": 1211101.0,
"id": "018cb27d00ab727985247e5f76b7ace0"
},
"fields": {
"displayGroup": [
"a29d21aa1bd22fc454e4031f2eb03684"
]
},
"sort": [
0,
"018cb27d00ab727985247e5f76b7ace0"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018cdd8b21f672a0a60630d1e48190f7",
"_score": null,
"_source": {
"autoIncrement": 1230966.0,
"id": "018cdd8b21f672a0a60630d1e48190f7"
},
"fields": {
"displayGroup": [
"fabae5cd0f475d1088cf29f375b2ae25"
]
},
"sort": [
0,
"018cdd8b21f672a0a60630d1e48190f7"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d7d780c9f739e915761626fbb821a",
"_score": null,
"_source": {
"autoIncrement": 1275289.0,
"id": "018d7d780c9f739e915761626fbb821a"
},
"fields": {
"displayGroup": [
"e591029042c6092ce919db3cab864ec9"
]
},
"sort": [
0,
"018d7d780c9f739e915761626fbb821a"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d7d781b2e7111916f09cc100ab59d",
"_score": null,
"_source": {
"autoIncrement": 1275290.0,
"id": "018d7d781b2e7111916f09cc100ab59d"
},
"fields": {
"displayGroup": [
"0869fb214b92ed68cea1b6b3b4d009d8"
]
},
"sort": [
0,
"018d7d781b2e7111916f09cc100ab59d"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d9c061f5e70708d3fb35914835936",
"_score": null,
"_source": {
"autoIncrement": 1303002.0,
"id": "018d9c061f5e70708d3fb35914835936"
},
"fields": {
"displayGroup": [
"808ae8bfe87f11a533e5890219fbce0f"
]
},
"sort": [
0,
"018d9c061f5e70708d3fb35914835936"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d9c062a20711ba088f20437d07253",
"_score": null,
"_source": {
"autoIncrement": 1303003.0,
"id": "018d9c062a20711ba088f20437d07253"
},
"fields": {
"displayGroup": [
"ac0cc85777c403e5469b1ab3ebc08eb5"
]
},
"sort": [
0,
"018d9c062a20711ba088f20437d07253"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0190a18c580b728897a0629c799768ef",
"_score": null,
"_source": {
"autoIncrement": 1833752.0,
"id": "0190a18c580b728897a0629c799768ef"
},
"fields": {
"displayGroup": [
"93b8c1fae974cfef30d9e68626e62402"
]
},
"sort": [
0,
"0190a18c580b728897a0629c799768ef"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "124e4ca1894e4f86a2e467ff9ba7b9f7",
"_score": null,
"_source": {
"autoIncrement": 1120926.0,
"id": "124e4ca1894e4f86a2e467ff9ba7b9f7"
},
"fields": {
"displayGroup": [
"4320e2c3ca34777b9764f469cb59712d"
]
},
"sort": [
0,
"124e4ca1894e4f86a2e467ff9ba7b9f7"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "3fef1a4a40634ea4a249073dfa88f693",
"_score": null,
"_source": {
"autoIncrement": 1120914.0,
"id": "3fef1a4a40634ea4a249073dfa88f693"
},
"fields": {
"displayGroup": [
"09e34394beb0281b9b4d72fdc8978bdc"
]
},
"sort": [
0,
"3fef1a4a40634ea4a249073dfa88f693"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "b2d33a73ad8142409a6409cb7a4c3eac",
"_score": null,
"_source": {
"autoIncrement": 999909.0,
"id": "b2d33a73ad8142409a6409cb7a4c3eac"
},
"fields": {
"displayGroup": [
"7bb3846aac0e30a81d30c7beb6798dea"
]
},
"sort": [
0,
"b2d33a73ad8142409a6409cb7a4c3eac"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "e6f4b255ed1246578c50d0174d130c62",
"_score": null,
"_source": {
"autoIncrement": 1120918.0,
"id": "e6f4b255ed1246578c50d0174d130c62"
},
"fields": {
"displayGroup": [
"87bd5f67a996cdd79b181edc9ccb2fe5"
]
},
"sort": [
0,
"e6f4b255ed1246578c50d0174d130c62"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "ea3fc91655e544dc84f884c7b4cccd80",
"_score": null,
"_source": {
"autoIncrement": 1120922.0,
"id": "ea3fc91655e544dc84f884c7b4cccd80"
},
"fields": {
"displayGroup": [
"4807ff53e7219cc9b656de2d99ab852e"
]
},
"sort": [
0,
"ea3fc91655e544dc84f884c7b4cccd80"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "eb7bf35823664e0dafc0bdb3477fd962",
"_score": null,
"_source": {
"autoIncrement": 1120910.0,
"id": "eb7bf35823664e0dafc0bdb3477fd962"
},
"fields": {
"displayGroup": [
"c6e6c0d283601659053384660317265b"
]
},
"sort": [
0,
"eb7bf35823664e0dafc0bdb3477fd962"
]
}
]
},
"aggregations": {
"total-count": {
"value": 15
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
11.04 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":"0189976cee97734898274f67f420541f"}}}},{"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": 9,
"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": 16,
"rating": {
"value": 0.0
}
},
"price": {
"count": 16,
"min": 4.49,
"max": 31.49,
"avg": 11.853125,
"sum": 189.65
},
"options": {
"doc_count": 32,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "eb72ee1138594bdd96373a5ec3f2b7fc",
"doc_count": 8
},
{
"key": "018c690351b470e9b83caaf323845f8d",
"doc_count": 4
},
{
"key": "63eac26e6a124098a9e8e806d4f07fa9",
"doc_count": 4
},
{
"key": "018c6903502670a29b01dc2855133192",
"doc_count": 3
},
{
"key": "018c6905b45373c981f5c03dc00fee32",
"doc_count": 2
},
{
"key": "018c7c809b46731d9477cbcfd6968f13",
"doc_count": 2
},
{
"key": "4a1ef1250e6c4a7ca28b4bce6d2d4bac",
"doc_count": 2
},
{
"key": "018dd5f6ea6641c7b569a0bef47cdc68",
"doc_count": 1
},
{
"key": "0190a0efbd1471739e380e2f4c3d6627",
"doc_count": 1
},
{
"key": "38a468d08afe4e1e8cefe06e35e3614f",
"doc_count": 1
},
{
"key": "4de74b20b3024ec082119e3b3d51426a",
"doc_count": 1
},
{
"key": "addda850cb3d4d8d819a5a9f16b44b50",
"doc_count": 1
},
{
"key": "bfbd1e647c1f4b57b97fbeda483abb94",
"doc_count": 1
},
{
"key": "dfff780768784cf1b858239371853d79",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 66,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "018963e5f53b7292b003bf6803f624b7",
"doc_count": 16
},
{
"key": "01896411e78a73399a29ed714246da0d",
"doc_count": 13
},
{
"key": "01896413126f7290be6abb0268cf090f",
"doc_count": 9
},
{
"key": "018963ea3aba7042895b047285c1402e",
"doc_count": 6
},
{
"key": "0189641326377376b6dfc717015949f7",
"doc_count": 4
},
{
"key": "018bbe13bff4727baa40d87b9df82a76",
"doc_count": 4
},
{
"key": "018963ea415c7217b4dc8cb62572ed16",
"doc_count": 2
},
{
"key": "01896411ea347043b0788892761b1dff",
"doc_count": 2
},
{
"key": "018963ea235f7081aea103f2195fbbb0",
"doc_count": 1
},
{
"key": "018963ea313d732aab9f9437134e1b76",
"doc_count": 1
},
{
"key": "018963ea3609712896e2d21c3a2d91ab",
"doc_count": 1
},
{
"key": "018963ea3964707fbbfb35b2b8e8084b",
"doc_count": 1
},
{
"key": "018963ea3eaf711483d350e0ebe0847a",
"doc_count": 1
},
{
"key": "01896411e05c71f4af78a5552a40b626",
"doc_count": 1
},
{
"key": "01896412e7b871978e0548f17372adef",
"doc_count": 1
},
{
"key": "018bbe13bf4971378f6c9737de6890aa",
"doc_count": 1
},
{
"key": "018bbe13c1457345958c7029f79b23fd",
"doc_count": 1
},
{
"key": "018f05beb6d070a79d0cbc12cb79c9ea",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "69126f5efcab45738b242009148aca51",
"doc_count": 6
},
{
"key": "0eb8635d02c643c2b1d22ea1631c0c90",
"doc_count": 4
},
{
"key": "018c7c9a616c7007bb7960ba88e59312",
"doc_count": 3
},
{
"key": "1a0ffc50b3584a1abd28c2d06d6c6465",
"doc_count": 2
},
{
"key": "d8ac016c293145ff9d20f96184a4ad02",
"doc_count": 1
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|