| 1 |
22.94 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":"018998254e497131a07b09a19db60865"}}}},{"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": 19,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 161,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d1f6b0e95732ba660d90bbf409db3",
"_score": null,
"_source": {
"autoIncrement": 1259362.0,
"id": "018d1f6b0e95732ba660d90bbf409db3"
},
"fields": {
"displayGroup": [
"cae55267358f7950d0a9bf34ee11434b"
]
},
"sort": [
1,
"018d1f6b0e95732ba660d90bbf409db3"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7eb4059b708799d1e1ac865bad47",
"_score": null,
"_source": {
"autoIncrement": 1152968.0,
"id": "018c7eb4059b708799d1e1ac865bad47"
},
"fields": {
"displayGroup": [
"30f526b3701c69301132bb9943b65acb"
]
},
"sort": [
0,
"018c7eb4059b708799d1e1ac865bad47"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d1092719073109892ac1c32771433",
"_score": null,
"_source": {
"autoIncrement": 1241487.0,
"id": "018d1092719073109892ac1c32771433"
},
"fields": {
"displayGroup": [
"394ab9a878c9a35717347f0654c9c662"
]
},
"sort": [
0,
"018d1092719073109892ac1c32771433"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d1d6e7a9071318e322b27014958e8",
"_score": null,
"_source": {
"autoIncrement": 1257303.0,
"id": "018d1d6e7a9071318e322b27014958e8"
},
"fields": {
"displayGroup": [
"2638257c7fe8b9d833fb17b8862665ec"
]
},
"sort": [
0,
"018d1d6e7a9071318e322b27014958e8"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d1f687eac71899e239e95062bc0a4",
"_score": null,
"_source": {
"autoIncrement": 1259347.0,
"id": "018d1f687eac71899e239e95062bc0a4"
},
"fields": {
"displayGroup": [
"3bf52bcb83ef5056edb7ffb38d3cfdf5"
]
},
"sort": [
0,
"018d1f687eac71899e239e95062bc0a4"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d1f69e2d37216b6e5b8650f19503b",
"_score": null,
"_source": {
"autoIncrement": 1259355.0,
"id": "018d1f69e2d37216b6e5b8650f19503b"
},
"fields": {
"displayGroup": [
"99cdc2386e9970f8f506bf787e605d8c"
]
},
"sort": [
0,
"018d1f69e2d37216b6e5b8650f19503b"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d83cc5aa07113972e8eccd1af8aa0",
"_score": null,
"_source": {
"autoIncrement": 1277219.0,
"id": "018d83cc5aa07113972e8eccd1af8aa0"
},
"fields": {
"displayGroup": [
"2c50ec66c28a859966e641e93641023b"
]
},
"sort": [
0,
"018d83cc5aa07113972e8eccd1af8aa0"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018def7c37d7702ba959b6192023ed58",
"_score": null,
"_source": {
"autoIncrement": 1741301.0,
"id": "018def7c37d7702ba959b6192023ed58"
},
"fields": {
"displayGroup": [
"e99118cf1286ae256a58f06a600223cf"
]
},
"sort": [
0,
"018def7c37d7702ba959b6192023ed58"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018df045762e73d7874ded31f7057170",
"_score": null,
"_source": {
"autoIncrement": 1742018.0,
"id": "018df045762e73d7874ded31f7057170"
},
"fields": {
"displayGroup": [
"fc2de8b99a1a1d6742808a0f1461786a"
]
},
"sort": [
0,
"018df045762e73d7874ded31f7057170"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018f779154c971c68d53cb23f19c6b12",
"_score": null,
"_source": {
"autoIncrement": 1781189.0,
"id": "018f779154c971c68d53cb23f19c6b12"
},
"fields": {
"displayGroup": [
"5a3c021edad6d9400971a6353e5968db"
]
},
"sort": [
0,
"018f779154c971c68d53cb23f19c6b12"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0190a21b564f703a925df421a87923c7",
"_score": null,
"_source": {
"autoIncrement": 1835330.0,
"id": "0190a21b564f703a925df421a87923c7"
},
"fields": {
"displayGroup": [
"bcc56da85f74e972fa32d7b3334535de"
]
},
"sort": [
0,
"0190a21b564f703a925df421a87923c7"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "04460469d3fd4c6cbfc4202da1af6a7c",
"_score": null,
"_source": {
"autoIncrement": 1128432.0,
"id": "04460469d3fd4c6cbfc4202da1af6a7c"
},
"fields": {
"displayGroup": [
"1e47726416b7a9c18cce81ac0192db20"
]
},
"sort": [
0,
"04460469d3fd4c6cbfc4202da1af6a7c"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "12ba27f4fe844e5aa633ac9e7d2966ca",
"_score": null,
"_source": {
"autoIncrement": 1102486.0,
"id": "12ba27f4fe844e5aa633ac9e7d2966ca"
},
"fields": {
"displayGroup": [
"d64e203d69de15f1debe7fe128e53c27"
]
},
"sort": [
0,
"12ba27f4fe844e5aa633ac9e7d2966ca"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "17db2f0fbe6b4ba986e4e31380666574",
"_score": null,
"_source": {
"autoIncrement": 1080266.0,
"id": "17db2f0fbe6b4ba986e4e31380666574"
},
"fields": {
"displayGroup": [
"8cfecf796178507aaf7927a971510805"
]
},
"sort": [
0,
"17db2f0fbe6b4ba986e4e31380666574"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "1be02e6b6439454ba3d1151cbc13f067",
"_score": null,
"_source": {
"autoIncrement": 1091178.0,
"id": "1be02e6b6439454ba3d1151cbc13f067"
},
"fields": {
"displayGroup": [
"17fd78c565f871817a9d74f6656f9a84"
]
},
"sort": [
0,
"1be02e6b6439454ba3d1151cbc13f067"
]
}
]
},
"aggregations": {
"total-count": {
"value": 15
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
14.24 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":"018998254e497131a07b09a19db60865"}}}},{"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": 12,
"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": 161,
"rating": {
"value": 0.0
}
},
"price": {
"count": 161,
"min": 7.5,
"max": 85.46,
"avg": 45.09639751552795,
"sum": 7260.5199999999995
},
"options": {
"doc_count": 327,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "63a3e4e3a8d0461ca937227647cbc474",
"doc_count": 20
},
{
"key": "6818490b3d264af396bf32b5c741cb18",
"doc_count": 19
},
{
"key": "df41139ab42a4f0dbe2167afb103b833",
"doc_count": 19
},
{
"key": "103c221ef5c547a6919548726a45adb7",
"doc_count": 18
},
{
"key": "7d8be3de88704ccaaaeef3437ee8b170",
"doc_count": 18
},
{
"key": "1c23aae651524363801a44213f31f325",
"doc_count": 17
},
{
"key": "bace55c509624d8ab8a0c4653bced477",
"doc_count": 17
},
{
"key": "9c7dc5166e9e46c0b9c8781e3903633d",
"doc_count": 14
},
{
"key": "018c69036c5d709fa6759781d6dd5cff",
"doc_count": 12
},
{
"key": "018c6903a28e726c989aa607602d0293",
"doc_count": 12
},
{
"key": "018c690506c2729cbb113b4d05d2da4a",
"doc_count": 12
},
{
"key": "f1c0d70c9b714c4cb27beb8f22273242",
"doc_count": 11
},
{
"key": "24df16bc136047dc93e487aa8a9c379f",
"doc_count": 8
},
{
"key": "848eafaf27ed48829d1082f3a4f795da",
"doc_count": 8
},
{
"key": "018e866f95eb7378b4d3c579500a5b81",
"doc_count": 7
},
{
"key": "018f765816187361b0bdc94cdefbf0c2",
"doc_count": 6
},
{
"key": "018f76583979738d91d298046eb7388b",
"doc_count": 6
},
{
"key": "52202a0098b34cad8489ae72ec96bb2f",
"doc_count": 6
},
{
"key": "ceee326838e84e179feac212955baed4",
"doc_count": 6
},
{
"key": "018c6903551970d8a468a8198cb25bdc",
"doc_count": 5
},
{
"key": "2d698a78a97547d29aad7b1607d32dec",
"doc_count": 5
},
{
"key": "40fed3f805694634974d360639023835",
"doc_count": 5
},
{
"key": "addda850cb3d4d8d819a5a9f16b44b50",
"doc_count": 5
},
{
"key": "f4ae98e61a6e405cb0b5a221ef13dbfe",
"doc_count": 5
},
{
"key": "018e866f08b872718b819af0f3300765",
"doc_count": 4
},
{
"key": "39b6f5a47a50414294058e3e59836af5",
"doc_count": 4
},
{
"key": "8010798477bb48a2894cb3b08b41a2e1",
"doc_count": 4
},
{
"key": "e0a98e55784640f5b4d89963a58605ad",
"doc_count": 4
},
{
"key": "f7249de1a4f84d3f838fcce8681fac45",
"doc_count": 4
},
{
"key": "036ec69570114a7a9fb638cce5173fb6",
"doc_count": 3
},
{
"key": "0b30d1b14ce543ab998d82ec50787210",
"doc_count": 3
},
{
"key": "88975b0051754b40904f0120e942d4d3",
"doc_count": 3
},
{
"key": "b45830abd8f447808d0ebb15ba5387bc",
"doc_count": 3
},
{
"key": "cd795f513314473390c0312b99ff2f38",
"doc_count": 3
},
{
"key": "de26cd1add74415294e121b09ba63393",
"doc_count": 3
},
{
"key": "e38f45d3f18d4b408e32de38173ad632",
"doc_count": 3
},
{
"key": "e5e366c501c849ab9d2e659374b399e9",
"doc_count": 3
},
{
"key": "194cbe2797434896a764b400a40fe11c",
"doc_count": 2
},
{
"key": "3bf4873d1b9a42a5b95eaf8475099096",
"doc_count": 2
},
{
"key": "63c4df9862d7462fbb8bdded218f4371",
"doc_count": 2
},
{
"key": "7a30c9fb3c4b455bbd475ef02b5a10be",
"doc_count": 2
},
{
"key": "b26bb94349e2469ea3e048b8bd50a91d",
"doc_count": 2
},
{
"key": "f581d0d127374d81b72fa04e52debbf9",
"doc_count": 2
},
{
"key": "20db184c1fdb49508a4ccd08b882a19f",
"doc_count": 1
},
{
"key": "37347e78acc44de0a2b07896ba5339c0",
"doc_count": 1
},
{
"key": "3d0b11d1db0f48f7acb284976d0b45e0",
"doc_count": 1
},
{
"key": "507f2e527d524e359c477d74d4605b1f",
"doc_count": 1
},
{
"key": "5e2f46d53cb046f9a5f9736c372966f8",
"doc_count": 1
},
{
"key": "60de90a916684ef696e8ba9bd8060cbc",
"doc_count": 1
},
{
"key": "be28c3ef2f744318a13f72f200abfc9a",
"doc_count": 1
},
{
"key": "c411c1ecb5d14739b311bd66356ea73f",
"doc_count": 1
},
{
"key": "c76cb176f273475b884768fc81200c2c",
"doc_count": 1
},
{
"key": "e1d2d15171a64618a31876cd60bae00c",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 679,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "018963e5f13871739bde1b0eb26bb21b",
"doc_count": 124
},
{
"key": "01896412894572ba804117c8c0b6aba1",
"doc_count": 98
},
{
"key": "018963ea3aba7042895b047285c1402e",
"doc_count": 82
},
{
"key": "01896411e4587305baecfc84ebf67bc3",
"doc_count": 48
},
{
"key": "018963e5f53b7292b003bf6803f624b7",
"doc_count": 37
},
{
"key": "018bbe13bff4727baa40d87b9df82a76",
"doc_count": 36
},
{
"key": "018963ea220370f6b3962a1108942bae",
"doc_count": 26
},
{
"key": "018bbe13baeb7369bc549fcbcdce4c6d",
"doc_count": 26
},
{
"key": "01896411e78a73399a29ed714246da0d",
"doc_count": 24
},
{
"key": "01896411e3007292bbf291a9837a8cc8",
"doc_count": 22
},
{
"key": "018963ea1812737fb7f416641565cd24",
"doc_count": 21
},
{
"key": "018bbe13b8237164810b74768f091ae7",
"doc_count": 18
},
{
"key": "018963ea415c7217b4dc8cb62572ed16",
"doc_count": 17
},
{
"key": "018964125dd17251b036e3ade2a1cd41",
"doc_count": 12
},
{
"key": "018964125fc77079a6f439c321914c71",
"doc_count": 12
},
{
"key": "01896412f5b57107a5f77996ea62470b",
"doc_count": 12
},
{
"key": "018dcc3373f47133833772ee8dfc3fe4",
"doc_count": 11
},
{
"key": "018e521dcd9d73a2ae6c2864c11790df",
"doc_count": 11
},
{
"key": "01896411ea347043b0788892761b1dff",
"doc_count": 10
},
{
"key": "01896413187a71de8aec58913856a1c7",
"doc_count": 10
},
{
"key": "01896411dfa972429a0b5b59515d3cd1",
"doc_count": 6
},
{
"key": "018e521e0b1b70d3be9ff1a8fc927bdd",
"doc_count": 6
},
{
"key": "01896411e25971f98272a565102c3faf",
"doc_count": 5
},
{
"key": "01896411e82d73ef973f22bb35c69d07",
"doc_count": 5
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "d8ac016c293145ff9d20f96184a4ad02",
"doc_count": 89
},
{
"key": "1a0ffc50b3584a1abd28c2d06d6c6465",
"doc_count": 16
},
{
"key": "018f76587934730f8674bc05947f9054",
"doc_count": 12
},
{
"key": "0eb8635d02c643c2b1d22ea1631c0c90",
"doc_count": 12
},
{
"key": "2a606633b77f4e1bab45f45f3483a835",
"doc_count": 11
},
{
"key": "1cadc079599b4e0386adc59541691ef7",
"doc_count": 10
},
{
"key": "38433195e9d345108b1593626fcdaba0",
"doc_count": 6
},
{
"key": "69126f5efcab45738b242009148aca51",
"doc_count": 5
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|