| 1 |
19.86 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":"018998123bdd7148996181b7bc0e0bd1"}}}},{"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": 16,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 267,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_all4team_product_1716336301",
"_id": "018af46b30537260bad2fac68ee548ed",
"_score": null,
"_source": {
"autoIncrement": 1132077.0,
"id": "018af46b30537260bad2fac68ee548ed"
},
"fields": {
"displayGroup": [
"f4e7d084966d3a1604135ad46d759863"
]
},
"sort": [
0,
"018af46b30537260bad2fac68ee548ed"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018af46b88ce7207a8eda88ea0ec2633",
"_score": null,
"_source": {
"autoIncrement": 1132123.0,
"id": "018af46b88ce7207a8eda88ea0ec2633"
},
"fields": {
"displayGroup": [
"bb4b2fafd0ea2bd99ff0b8a7fe59c12e"
]
},
"sort": [
0,
"018af46b88ce7207a8eda88ea0ec2633"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bf099a8b471388171693ca80be81b",
"_score": null,
"_source": {
"autoIncrement": 1141743.0,
"id": "018bf099a8b471388171693ca80be81b"
},
"fields": {
"displayGroup": [
"87e78911306931f12430503728c06dde"
]
},
"sort": [
0,
"018bf099a8b471388171693ca80be81b"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bf0a00f7f71b4a7f500574981d503",
"_score": null,
"_source": {
"autoIncrement": 1141779.0,
"id": "018bf0a00f7f71b4a7f500574981d503"
},
"fields": {
"displayGroup": [
"b16bd470f6c31f214570a3d5dc24e064"
]
},
"sort": [
0,
"018bf0a00f7f71b4a7f500574981d503"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bf0a3e6e970dcb16993cd4051acd5",
"_score": null,
"_source": {
"autoIncrement": 1141797.0,
"id": "018bf0a3e6e970dcb16993cd4051acd5"
},
"fields": {
"displayGroup": [
"a8f70f845b351b3c492bfaf58d7f3d64"
]
},
"sort": [
0,
"018bf0a3e6e970dcb16993cd4051acd5"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7e80407e71199712331065cb1989",
"_score": null,
"_source": {
"autoIncrement": 1150041.0,
"id": "018c7e80407e71199712331065cb1989"
},
"fields": {
"displayGroup": [
"8ad5c4295e8882dce733f274f6501512"
]
},
"sort": [
0,
"018c7e80407e71199712331065cb1989"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018cd9803488738cade9a56c278a8243",
"_score": null,
"_source": {
"autoIncrement": 1226908.0,
"id": "018cd9803488738cade9a56c278a8243"
},
"fields": {
"displayGroup": [
"8dbec5a1fc9f34bb0b28635c25f23c5b"
]
},
"sort": [
0,
"018cd9803488738cade9a56c278a8243"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d0f1c9f677130a8a62aea879b01bd",
"_score": null,
"_source": {
"autoIncrement": 1238751.0,
"id": "018d0f1c9f677130a8a62aea879b01bd"
},
"fields": {
"displayGroup": [
"667943ac52edbcc9e2f40ef23a824a7f"
]
},
"sort": [
0,
"018d0f1c9f677130a8a62aea879b01bd"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d0fb4d75570ce90e1f44872a2de75",
"_score": null,
"_source": {
"autoIncrement": 1239873.0,
"id": "018d0fb4d75570ce90e1f44872a2de75"
},
"fields": {
"displayGroup": [
"0a2e7d6eaa0a092452b9d37b48806ba6"
]
},
"sort": [
0,
"018d0fb4d75570ce90e1f44872a2de75"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d11147ead72c3a2924dba2b32b56d",
"_score": null,
"_source": {
"autoIncrement": 1243511.0,
"id": "018d11147ead72c3a2924dba2b32b56d"
},
"fields": {
"displayGroup": [
"d2bf32659f4d6a76ecff61e931bd0239"
]
},
"sort": [
0,
"018d11147ead72c3a2924dba2b32b56d"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018f779eceea723698b8e5b9f7d4bc5c",
"_score": null,
"_source": {
"autoIncrement": 1782980.0,
"id": "018f779eceea723698b8e5b9f7d4bc5c"
},
"fields": {
"displayGroup": [
"9f9b59b8bdb16c41c3fd50b4ea051c35"
]
},
"sort": [
0,
"018f779eceea723698b8e5b9f7d4bc5c"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0192e528834770bcabe87d6da58dcb10",
"_score": null,
"_source": {
"autoIncrement": 1855591.0,
"id": "0192e528834770bcabe87d6da58dcb10"
},
"fields": {
"displayGroup": [
"1893326174213cea5460154b1375868c"
]
},
"sort": [
0,
"0192e528834770bcabe87d6da58dcb10"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "cee2cc592ce944df9c37855011fb537b",
"_score": null,
"_source": {
"autoIncrement": 1006730.0,
"id": "cee2cc592ce944df9c37855011fb537b"
},
"fields": {
"displayGroup": [
"7fa7ca7e28101c689725d2edafbc9a85"
]
},
"sort": [
0,
"cee2cc592ce944df9c37855011fb537b"
]
}
]
},
"aggregations": {
"total-count": {
"value": 13
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
15.03 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":"018998123bdd7148996181b7bc0e0bd1"}}}},{"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": 267,
"rating": {
"value": 0.0
}
},
"price": {
"count": 267,
"min": 29.22,
"max": 64.97,
"avg": 45.655842696629215,
"sum": 12190.11
},
"options": {
"doc_count": 534,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "b26bb94349e2469ea3e048b8bd50a91d",
"doc_count": 53
},
{
"key": "df41139ab42a4f0dbe2167afb103b833",
"doc_count": 50
},
{
"key": "63a3e4e3a8d0461ca937227647cbc474",
"doc_count": 49
},
{
"key": "6818490b3d264af396bf32b5c741cb18",
"doc_count": 44
},
{
"key": "103c221ef5c547a6919548726a45adb7",
"doc_count": 40
},
{
"key": "bace55c509624d8ab8a0c4653bced477",
"doc_count": 31
},
{
"key": "90deb273963c446380e69696e17dbc1c",
"doc_count": 12
},
{
"key": "b6f8ccd3471845ac9e1a53342d2f5dc8",
"doc_count": 12
},
{
"key": "c2a298815e814368a097536a4063b025",
"doc_count": 12
},
{
"key": "1c23aae651524363801a44213f31f325",
"doc_count": 11
},
{
"key": "f83b103497404ca09a44302034b21032",
"doc_count": 11
},
{
"key": "32b7f689c19f425d9de20e215684cb85",
"doc_count": 9
},
{
"key": "018c7c7ff28d70a297b59aad4a5767f7",
"doc_count": 6
},
{
"key": "018d9389c57c7058a7a15236c3deb2c1",
"doc_count": 6
},
{
"key": "04e676596926494cad4295f146a65815",
"doc_count": 6
},
{
"key": "1be4b2bd0fb24df3be7b82f9edc1af6e",
"doc_count": 6
},
{
"key": "41d7e80eaa1a4df9a246fa60ff33a8da",
"doc_count": 6
},
{
"key": "4314baa116af4d10a8202db74494ef1a",
"doc_count": 6
},
{
"key": "4d8ee4d9aac44a5c9332945395b9b669",
"doc_count": 6
},
{
"key": "533b1f5a5c9e489ab43e23a4f35716f4",
"doc_count": 6
},
{
"key": "54cf2b0f93f04cd2ac223e59bc0aac76",
"doc_count": 6
},
{
"key": "5d99685a591644fd88699c47591c2efe",
"doc_count": 6
},
{
"key": "7303e67aef5342d78da48b362e94c9fd",
"doc_count": 6
},
{
"key": "8010798477bb48a2894cb3b08b41a2e1",
"doc_count": 6
},
{
"key": "a1bf9be58e76450b88003349bec2f1c9",
"doc_count": 6
},
{
"key": "b2e2354ac4d04e4b872600d469fd1bdf",
"doc_count": 6
},
{
"key": "cfb5694a62a64f0dbf5ff8df39129fe6",
"doc_count": 6
},
{
"key": "d966e8ae911b448e8f8ab3c88f32722f",
"doc_count": 6
},
{
"key": "df1f192e0e8f446cb0704a2ad3308052",
"doc_count": 6
},
{
"key": "fb30441665254535bd2f3931a491af07",
"doc_count": 6
},
{
"key": "018c69034aef724c97bfe71d324803dd",
"doc_count": 5
},
{
"key": "018c7c7ff1d2723199bd5cac1436bdf5",
"doc_count": 5
},
{
"key": "0190a0f057e771e98235b74a998632a7",
"doc_count": 5
},
{
"key": "0190a0f065517356a2d1f83f9c213c4a",
"doc_count": 5
},
{
"key": "0190a0f0661273cfa6137de60f499daf",
"doc_count": 5
},
{
"key": "0190a0f066d97008851d3c163d306e9e",
"doc_count": 5
},
{
"key": "2c85f1acf4e648d5830165598cae79ac",
"doc_count": 5
},
{
"key": "8e58eacaf854499192808c266e47724b",
"doc_count": 5
},
{
"key": "b570a47e4d3549d1ae59e8016eeb2065",
"doc_count": 5
},
{
"key": "f3aea1d1f31f440eb1200a8aaa63322c",
"doc_count": 5
},
{
"key": "018d9389ceb97326b0a8a4531e521d9c",
"doc_count": 4
},
{
"key": "48e1dd7529b14f7da0cb74f8737bf339",
"doc_count": 4
},
{
"key": "5e83293ae3944a1d8c4eb34850572cfa",
"doc_count": 4
},
{
"key": "6f6db67df6af4b788624e4ce0643df39",
"doc_count": 4
},
{
"key": "018c69034933706fb91344c1e2340ece",
"doc_count": 3
},
{
"key": "3cf8067de75947bcb53e4cd1de94d52a",
"doc_count": 3
},
{
"key": "5daeccdf7530471193a331b7002c5f97",
"doc_count": 3
},
{
"key": "9749dfa4e41c445e8daad76d0f83ab82",
"doc_count": 3
},
{
"key": "49048c5074974ee792675a3e49c87f7e",
"doc_count": 2
},
{
"key": "b7aca45fea4645f1aa5ad3fd2b81cc85",
"doc_count": 2
},
{
"key": "b9a0f3a4f9714b989bfb4bc9a9cb946e",
"doc_count": 2
},
{
"key": "cb23b5caf37d4f21a985ca764320f1e2",
"doc_count": 2
},
{
"key": "018c690452bb7143a1ee4713800bfe93",
"doc_count": 1
},
{
"key": "0190a0f0572972e5ab41701e4c201ca1",
"doc_count": 1
},
{
"key": "040270ac50774fb7803d3b1811b85db2",
"doc_count": 1
},
{
"key": "05f0d2b5046e4896a18f271c13b4893d",
"doc_count": 1
},
{
"key": "bb33cd0d7fa840ffb474544891c3545c",
"doc_count": 1
},
{
"key": "fa42f5b49cbc44468108852a47eaeb0b",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 1088,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "018963e5f06f716dadb0fe95b3c53d22",
"doc_count": 267
},
{
"key": "01896411e25971f98272a565102c3faf",
"doc_count": 128
},
{
"key": "018964131ee071d8a11b8fd8591cf749",
"doc_count": 105
},
{
"key": "018c1b62bb0472019ea8c10c63014d4e",
"doc_count": 103
},
{
"key": "01896412913b7038950ef278d2351ea4",
"doc_count": 65
},
{
"key": "018abc1fb79370b68273746c73fcc4f5",
"doc_count": 65
},
{
"key": "018dcc3373f47133833772ee8dfc3fe4",
"doc_count": 59
},
{
"key": "018963ea220370f6b3962a1108942bae",
"doc_count": 49
},
{
"key": "018963ea3aba7042895b047285c1402e",
"doc_count": 37
},
{
"key": "018963ea1812737fb7f416641565cd24",
"doc_count": 30
},
{
"key": "018bbe13c09d7328ba65279e42d55280",
"doc_count": 24
},
{
"key": "018963ea3964707fbbfb35b2b8e8084b",
"doc_count": 21
},
{
"key": "018963ea1a0071e3b903843432a2818e",
"doc_count": 20
},
{
"key": "018963ea24c172519a11176e570bcae4",
"doc_count": 17
},
{
"key": "01896411e9917199967095243438b4f6",
"doc_count": 17
},
{
"key": "018963ea336b7003ba1d74549036192d",
"doc_count": 16
},
{
"key": "018963ea415c7217b4dc8cb62572ed16",
"doc_count": 12
},
{
"key": "018963ea3609712896e2d21c3a2d91ab",
"doc_count": 7
},
{
"key": "018963ea20b670278236dc7103bcceb8",
"doc_count": 6
},
{
"key": "018963ea3c15725ea04f1c0eefbb7695",
"doc_count": 6
},
{
"key": "018bbe13b7757294bf18b34533cada9d",
"doc_count": 6
},
{
"key": "018bbe13bff4727baa40d87b9df82a76",
"doc_count": 6
},
{
"key": "018dd235f075722daf1b7ecd97e0eee4",
"doc_count": 6
},
{
"key": "018e5b89802a707bac98192a0797fc4e",
"doc_count": 6
},
{
"key": "018963ea26b971f09527dfc7f4930323",
"doc_count": 3
},
{
"key": "018bbe13b8237164810b74768f091ae7",
"doc_count": 3
},
{
"key": "018bbe13bd1172acb357b364589f9242",
"doc_count": 3
},
{
"key": "018bbe13bc59715e84f9af38463344b8",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "2a606633b77f4e1bab45f45f3483a835",
"doc_count": 204
},
{
"key": "1a0ffc50b3584a1abd28c2d06d6c6465",
"doc_count": 63
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|