1 |
6.38 ms |
Request:
{"index":"sw_product","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":"01905e09959472e39dfc5a26763d4488"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"01905dfb44907120b1096661c1530d7b"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}},{"bool":{"should":[{"bool":{"must":[{"nested":{"path":"parent.swagDynamicAccessRules","query":{"terms":{"parent.swagDynamicAccessRules.id":["0189e51498b172ffaba28fb1e58dee02","0189e514995d71cdace03f1dbda1f1f6","0189e514cec07203af0b602d25cfe21d","01910d9b14ee709cb429be0ad075e8aa","3858957016644de4ae48c0500bf3ccc8","e1378db7808a478f919e0d740d5d6c1a","018f7b1212d571aa9aefd8cfc5126bd3","01909b60cbda73faaad9bb30a2d6711a"]}}}},{"nested":{"path":"swagDynamicAccessRules","query":{"bool":{"must_not":[{"exists":{"field":"swagDynamicAccessRules.id"}}]}}}}]}},{"nested":{"path":"swagDynamicAccessRules","query":{"terms":{"swagDynamicAccessRules.id":["0189e51498b172ffaba28fb1e58dee02","0189e514995d71cdace03f1dbda1f1f6","0189e514cec07203af0b602d25cfe21d","01910d9b14ee709cb429be0ad075e8aa","3858957016644de4ae48c0500bf3ccc8","e1378db7808a478f919e0d740d5d6c1a","018f7b1212d571aa9aefd8cfc5126bd3","01909b60cbda73faaad9bb30a2d6711a"]}}}},{"bool":{"must":[{"nested":{"path":"parent.swagDynamicAccessRules","query":{"bool":{"must_not":[{"exists":{"field":"parent.swagDynamicAccessRules.id"}}]}}}},{"nested":{"path":"swagDynamicAccessRules","query":{"bool":{"must_not":[{"exists":{"field":"swagDynamicAccessRules.id"}}]}}}}]}}]}}]}}]}},"sort":[{"_script":{"type":"string","script":{"id":"translated_field_sorting","params":{"field":"name","languages":["2fbb5fe2e29a4d70aa5854ce7ce3e20b"]}},"order":"ASC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"}}
{
"took": 3,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 122,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_product_1726772402",
"_type": "_doc",
"_id": "0190c553ce64702dbc2da2d8885194bc",
"_score": null,
"_source": {
"autoIncrement": 10541.0,
"id": "0190c553ce64702dbc2da2d8885194bc"
},
"fields": {
"displayGroup": [
"fd8a0cbea42abebb4559618fae7c1afe"
]
},
"sort": [
"cycle funktions t-shirt \"jn520\" schwarz",
"0190c553ce64702dbc2da2d8885194bc"
]
},
{
"_index": "sw_product_1726772402",
"_type": "_doc",
"_id": "0190c55359bf72eaa24e90a5db27da76",
"_score": null,
"_source": {
"autoIncrement": 10524.0,
"id": "0190c55359bf72eaa24e90a5db27da76"
},
"fields": {
"displayGroup": [
"c0ebf0e18a1f357dbf6caf46fef02c51"
]
},
"sort": [
"cycle kapuzen-sweatjacke \"manchester\" schwarz",
"0190c55359bf72eaa24e90a5db27da76"
]
},
{
"_index": "sw_product_1726772402",
"_type": "_doc",
"_id": "0190c55a8e9d71c994cee42fb7c0fa90",
"_score": null,
"_source": {
"autoIncrement": 10580.0,
"id": "0190c55a8e9d71c994cee42fb7c0fa90"
},
"fields": {
"displayGroup": [
"ea445ead3a942231a2c67673fc49e3af"
]
},
"sort": [
"cycle piratenhose \"oxford\" schwarz",
"0190c55a8e9d71c994cee42fb7c0fa90"
]
},
{
"_index": "sw_product_1726772402",
"_type": "_doc",
"_id": "0190c55a333f7379b0f5f0c2781cd734",
"_score": null,
"_source": {
"autoIncrement": 10571.0,
"id": "0190c55a333f7379b0f5f0c2781cd734"
},
"fields": {
"displayGroup": [
"1e3150cb8020e9871db8a378f1d81d07"
]
},
"sort": [
"cycle regenhose \"1301\" schwarz",
"0190c55a333f7379b0f5f0c2781cd734"
]
},
{
"_index": "sw_product_1726772402",
"_type": "_doc",
"_id": "0190c552e9fd7370a07ae94407ead391",
"_score": null,
"_source": {
"autoIncrement": 10515.0,
"id": "0190c552e9fd7370a07ae94407ead391"
},
"fields": {
"displayGroup": [
"b66c38a700c7bf0a44242c695f11e6fa"
]
},
"sort": [
"cycle regenjacke \"manchester\" schwarz",
"0190c552e9fd7370a07ae94407ead391"
]
},
{
"_index": "sw_product_1726772402",
"_type": "_doc",
"_id": "0190c55ada8173a3ad18b053fb8ab18e",
"_score": null,
"_source": {
"autoIncrement": 10598.0,
"id": "0190c55ada8173a3ad18b053fb8ab18e"
},
"fields": {
"displayGroup": [
"a2a1ab11c67bc5ae6821e543a72e3887"
]
},
"sort": [
"cycle stretch bundhose \"oxford 4x\" schwarz",
"0190c55ada8173a3ad18b053fb8ab18e"
]
},
{
"_index": "sw_product_1726772402",
"_type": "_doc",
"_id": "0190c559e252730d82c64fe3b9ba27c5",
"_score": null,
"_source": {
"autoIncrement": 10559.0,
"id": "0190c559e252730d82c64fe3b9ba27c5"
},
"fields": {
"displayGroup": [
"11aaa62a721472b8ff1d1ae8778dc0ba"
]
},
"sort": [
"cycle stretch shorts \"1446\" schwarz",
"0190c559e252730d82c64fe3b9ba27c5"
]
},
{
"_index": "sw_product_1726772402",
"_type": "_doc",
"_id": "0190c55398d373c7811fc39ec06c7d1b",
"_score": null,
"_source": {
"autoIncrement": 10533.0,
"id": "0190c55398d373c7811fc39ec06c7d1b"
},
"fields": {
"displayGroup": [
"8d19f8f8dacdf21d9bf8b59799e53750"
]
},
"sort": [
"cycle winterjacke \"1102\" schwarz",
"0190c55398d373c7811fc39ec06c7d1b"
]
},
{
"_index": "sw_product_1726772402",
"_type": "_doc",
"_id": "0190c55b666470e6a151e85d143a7b5e",
"_score": null,
"_source": {
"autoIncrement": 10629.0,
"id": "0190c55b666470e6a151e85d143a7b5e"
},
"fields": {
"displayGroup": [
"e4731e31da3ebcf7e000f55ac240098e"
]
},
"sort": [
"cycle winterm\u00fctze thinsulate \"bodo\" schwarz",
"0190c55b666470e6a151e85d143a7b5e"
]
},
{
"_index": "sw_product_1726772402",
"_type": "_doc",
"_id": "0190c55942a3736f9793da462c66b873",
"_score": null,
"_source": {
"autoIncrement": 10548.0,
"id": "0190c55942a3736f9793da462c66b873"
},
"fields": {
"displayGroup": [
"b7d88f55063303514bfeea0a46879500"
]
},
"sort": [
"sicherheitshalbschuhe s3 \"terrier\" propulsion",
"0190c55942a3736f9793da462c66b873"
]
},
{
"_index": "sw_product_1726772402",
"_type": "_doc",
"_id": "0190c4e725fa716ab3a8743818021b4d",
"_score": null,
"_source": {
"autoIncrement": 10504.0,
"id": "0190c4e725fa716ab3a8743818021b4d"
},
"fields": {
"displayGroup": [
"b99f0b8fe15c78d39b9819c7099f13b0"
]
},
"sort": [
"sicherheitshochschuhe s3 \"jumper\" propulsion ",
"0190c4e725fa716ab3a8743818021b4d"
]
},
{
"_index": "sw_product_1726772402",
"_type": "_doc",
"_id": "0190c4e712be7145815b143c9a17f080",
"_score": null,
"_source": {
"autoIncrement": 10492.0,
"id": "0190c4e712be7145815b143c9a17f080"
},
"fields": {
"displayGroup": [
"4ddb292a4824e199ff888df3de3c1995"
]
},
"sort": [
"winterhandschuhe \"2249\"",
"0190c4e712be7145815b143c9a17f080"
]
}
]
},
"aggregations": {
"total-count": {
"value": 12
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
2 |
4.16 ms |
Request:
{"index":"sw_product","body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"01905e09959472e39dfc5a26763d4488"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"01905dfb44907120b1096661c1530d7b"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}},{"bool":{"should":[{"bool":{"must":[{"nested":{"path":"parent.swagDynamicAccessRules","query":{"terms":{"parent.swagDynamicAccessRules.id":["0189e51498b172ffaba28fb1e58dee02","0189e514995d71cdace03f1dbda1f1f6","0189e514cec07203af0b602d25cfe21d","01910d9b14ee709cb429be0ad075e8aa","3858957016644de4ae48c0500bf3ccc8","e1378db7808a478f919e0d740d5d6c1a","018f7b1212d571aa9aefd8cfc5126bd3","01909b60cbda73faaad9bb30a2d6711a"]}}}},{"nested":{"path":"swagDynamicAccessRules","query":{"bool":{"must_not":[{"exists":{"field":"swagDynamicAccessRules.id"}}]}}}}]}},{"nested":{"path":"swagDynamicAccessRules","query":{"terms":{"swagDynamicAccessRules.id":["0189e51498b172ffaba28fb1e58dee02","0189e514995d71cdace03f1dbda1f1f6","0189e514cec07203af0b602d25cfe21d","01910d9b14ee709cb429be0ad075e8aa","3858957016644de4ae48c0500bf3ccc8","e1378db7808a478f919e0d740d5d6c1a","018f7b1212d571aa9aefd8cfc5126bd3","01909b60cbda73faaad9bb30a2d6711a"]}}}},{"bool":{"must":[{"nested":{"path":"parent.swagDynamicAccessRules","query":{"bool":{"must_not":[{"exists":{"field":"parent.swagDynamicAccessRules.id"}}]}}}},{"nested":{"path":"swagDynamicAccessRules","query":{"bool":{"must_not":[{"exists":{"field":"swagDynamicAccessRules.id"}}]}}}}]}}]}}]}}]}},"aggregations":{"manufacturer":{"terms":{"field":"manufacturerId","size":10000}},"price":{"stats":{"script":{"id":"cheapest_price","params":{"accessors":[{"key":"cheapest_price_rule0189e51498b172ffaba28fb1e58dee02_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189e514995d71cdace03f1dbda1f1f6_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189e514cec07203af0b602d25cfe21d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule01910d9b14ee709cb429be0ad075e8aa_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule3858957016644de4ae48c0500bf3ccc8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rulee1378db7808a478f919e0d740d5d6c1a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule018f7b1212d571aa9aefd8cfc5126bd3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule01909b60cbda73faaad9bb30a2d6711a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","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"}}
{
"took": 3,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 122,
"relation": "eq"
},
"max_score": null,
"hits": []
},
"aggregations": {
"shipping-free-filter": {
"doc_count": 0,
"shipping-free": {
"value": null
}
},
"rating-exists": {
"doc_count": 122,
"rating": {
"value": 0.0
}
},
"price": {
"count": 122,
"min": 4.45,
"max": 179.55,
"avg": 59.48196721311476,
"sum": 7256.8
},
"options": {
"doc_count": 121,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "019073767cf7719c8fe0781065f8fd1b",
"doc_count": 5
},
{
"key": "019073767d0e70dbbeab026b410b24ab",
"doc_count": 5
},
{
"key": "41e5013b67d64d3a92b7a275da8af441",
"doc_count": 5
},
{
"key": "54147692cbfb43419a6d11e26cad44dc",
"doc_count": 5
},
{
"key": "5997d91dc0784997bdef68dfc5a08912",
"doc_count": 5
},
{
"key": "acfd7586d02848f1ac801f4776efa414",
"doc_count": 5
},
{
"key": "019073767d0e70dbbeab026b3dd12d51",
"doc_count": 4
},
{
"key": "019073767cfc728799874d85b7827b07",
"doc_count": 3
},
{
"key": "019073767d067339a87b8b9e19163ce6",
"doc_count": 3
},
{
"key": "019073767d067339a87b8b9e1a9260a2",
"doc_count": 3
},
{
"key": "019073767d067339a87b8b9e1d98fda5",
"doc_count": 3
},
{
"key": "019073767d067339a87b8b9e1f8ad06d",
"doc_count": 3
},
{
"key": "019073767d067339a87b8b9e217a91f8",
"doc_count": 3
},
{
"key": "019073767d067339a87b8b9e23bfe2f1",
"doc_count": 3
},
{
"key": "019073767d07733eb1b05374f6e1269c",
"doc_count": 3
},
{
"key": "019073767d07733eb1b05374f7c6116b",
"doc_count": 3
},
{
"key": "019073767d07733eb1b05374f86ca981",
"doc_count": 3
},
{
"key": "019073767d07733eb1b05374f8faa26d",
"doc_count": 3
},
{
"key": "019073767d07733eb1b05374f9415f67",
"doc_count": 3
},
{
"key": "019073767cf7719c8fe078105e638ecb",
"doc_count": 2
},
{
"key": "019073767cf7719c8fe078106bd460a3",
"doc_count": 2
},
{
"key": "019073767cf871bdb3f75a7b2dfb9c8b",
"doc_count": 2
},
{
"key": "019073767cf871bdb3f75a7b333ba252",
"doc_count": 2
},
{
"key": "019073767cf973c699d5f64a9ccdff9c",
"doc_count": 2
},
{
"key": "019073767cf973c699d5f64aa344afbe",
"doc_count": 2
},
{
"key": "019073767cfa71de95b6d909c0edd802",
"doc_count": 2
},
{
"key": "019073767cfa71de95b6d909c74340fc",
"doc_count": 2
},
{
"key": "019073767cfb72789bd7754d77e2d66c",
"doc_count": 2
},
{
"key": "019073767cfb72789bd7754d7d0df3c0",
"doc_count": 2
},
{
"key": "019073767d07733eb1b05374f9c392bd",
"doc_count": 2
},
{
"key": "019073767d07733eb1b05374fb0f3724",
"doc_count": 2
},
{
"key": "019073767d07733eb1b05374fc53f4a7",
"doc_count": 2
},
{
"key": "019073767d07733eb1b05374fdedf3f4",
"doc_count": 2
},
{
"key": "019073767d07733eb1b05374fee290e8",
"doc_count": 2
},
{
"key": "019073767d0870938742f230e3bf09be",
"doc_count": 2
},
{
"key": "019073767ced71fc9e928ee63717046a",
"doc_count": 1
},
{
"key": "019073767ced71fc9e928ee64510a148",
"doc_count": 1
},
{
"key": "019073767cee716e92929d5b33b7cbd6",
"doc_count": 1
},
{
"key": "019073767d0272e78c6187715c102947",
"doc_count": 1
},
{
"key": "019073767d0471db8d67879a0bfeb9cd",
"doc_count": 1
},
{
"key": "019073767d0572f999bc4dae26fc9247",
"doc_count": 1
},
{
"key": "019073767d0572f999bc4dae2723aaf9",
"doc_count": 1
},
{
"key": "019073767d0572f999bc4dae281808e0",
"doc_count": 1
},
{
"key": "019073767d0572f999bc4dae28bc4754",
"doc_count": 1
},
{
"key": "019073767d0572f999bc4dae290c2bbd",
"doc_count": 1
},
{
"key": "019073767d07733eb1b053750271aa0f",
"doc_count": 1
},
{
"key": "019073767d07733eb1b05375030f1239",
"doc_count": 1
},
{
"key": "019073767d07733eb1b0537503b2ed42",
"doc_count": 1
},
{
"key": "019073767d07733eb1b0537505398e7e",
"doc_count": 1
},
{
"key": "019073767d07733eb1b0537505dca196",
"doc_count": 1
},
{
"key": "019073767d07733eb1b05375064c0c6b",
"doc_count": 1
},
{
"key": "019073767d07733eb1b053750654ba36",
"doc_count": 1
},
{
"key": "019073767d0870938742f230e324e090",
"doc_count": 1
},
{
"key": "019073767d0870938742f230e3cdcc15",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 185,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "01907376651f7101ad085869c4193067",
"doc_count": 20
},
{
"key": "019073766dbb7206a44937ad6cc8c855",
"doc_count": 20
},
{
"key": "019073768b3a71388c83b4384ad11474",
"doc_count": 20
},
{
"key": "019073768ef1718b8e65f49884551f0c",
"doc_count": 20
},
{
"key": "019073768ef2713cbf2339b6bb0e3a18",
"doc_count": 20
},
{
"key": "019073768fdf73c58eca6f55f339926b",
"doc_count": 20
},
{
"key": "0190737690e171a7a23f58e01e1c61b4",
"doc_count": 20
},
{
"key": "01907376955d708a870530bd2ffc1beb",
"doc_count": 20
},
{
"key": "0190737665df73ac86c1184177063e89",
"doc_count": 5
},
{
"key": "019073766b767259a373231ebaa75654",
"doc_count": 5
},
{
"key": "019073768ef2713cbf2339b6c07b02b2",
"doc_count": 5
},
{
"key": "019073768ef2713cbf2339b6c4396abf",
"doc_count": 5
},
{
"key": "0190737691ae73f8bf42e635f9b87973",
"doc_count": 5
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "018f770ee98078a1b058524b23d16f16",
"doc_count": 20
},
{
"key": "018f770db4bf77e29d5e02311cf7c3be",
"doc_count": 5
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|