| 1 |
10.07 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":"0189976cbaa071c28e12f45173dd08ea"}}}},{"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": 7,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 510,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7ec5301072dc97a9bfddb8d626a9",
"_score": null,
"_source": {
"autoIncrement": 1154838.0,
"id": "018c7ec5301072dc97a9bfddb8d626a9"
},
"fields": {
"displayGroup": [
"757ee4b155e6225c62f13d7f22afc4ff"
]
},
"sort": [
0,
"018c7ec5301072dc97a9bfddb8d626a9"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7ec5556e7299b351ca3830e23c01",
"_score": null,
"_source": {
"autoIncrement": 1154841.0,
"id": "018c7ec5556e7299b351ca3830e23c01"
},
"fields": {
"displayGroup": [
"8969a365866f62700cd10646c8da3f0a"
]
},
"sort": [
0,
"018c7ec5556e7299b351ca3830e23c01"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7ec5a81371889d79aeeb29453221",
"_score": null,
"_source": {
"autoIncrement": 1154845.0,
"id": "018c7ec5a81371889d79aeeb29453221"
},
"fields": {
"displayGroup": [
"ebaeb8dd4d0cecfc280a97145d9aa77d"
]
},
"sort": [
0,
"018c7ec5a81371889d79aeeb29453221"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7ec5d1ba73fc83f56e7368ff6513",
"_score": null,
"_source": {
"autoIncrement": 1154848.0,
"id": "018c7ec5d1ba73fc83f56e7368ff6513"
},
"fields": {
"displayGroup": [
"905a337047f1b5e6305ed376c499b749"
]
},
"sort": [
0,
"018c7ec5d1ba73fc83f56e7368ff6513"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c88a22a4373f2aa34bf7566e6af5c",
"_score": null,
"_source": {
"autoIncrement": 1171132.0,
"id": "018c88a22a4373f2aa34bf7566e6af5c"
},
"fields": {
"displayGroup": [
"a7b1ac2c6dd7f5a2a4c80dda4a791a8d"
]
},
"sort": [
0,
"018c88a22a4373f2aa34bf7566e6af5c"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c88a23e477143ad82cd05efa51c32",
"_score": null,
"_source": {
"autoIncrement": 1171146.0,
"id": "018c88a23e477143ad82cd05efa51c32"
},
"fields": {
"displayGroup": [
"2c68d89c5dd2c65b9a3a109accb68244"
]
},
"sort": [
0,
"018c88a23e477143ad82cd05efa51c32"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c88a25d38706f9be6d78cf7821c0c",
"_score": null,
"_source": {
"autoIncrement": 1171155.0,
"id": "018c88a25d38706f9be6d78cf7821c0c"
},
"fields": {
"displayGroup": [
"8339ae95380657bd52b565e2913a38b2"
]
},
"sort": [
0,
"018c88a25d38706f9be6d78cf7821c0c"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c88a28e7c72679748c4d8589f6817",
"_score": null,
"_source": {
"autoIncrement": 1171177.0,
"id": "018c88a28e7c72679748c4d8589f6817"
},
"fields": {
"displayGroup": [
"09fc0156b162e0a9b1abc257c7ad52b6"
]
},
"sort": [
0,
"018c88a28e7c72679748c4d8589f6817"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d1586ccaf715290ad1ab48734bf5f",
"_score": null,
"_source": {
"autoIncrement": 1250577.0,
"id": "018d1586ccaf715290ad1ab48734bf5f"
},
"fields": {
"displayGroup": [
"f5f550ec5245142c57b9e85ca3eec6a1"
]
},
"sort": [
0,
"018d1586ccaf715290ad1ab48734bf5f"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d1587422272489d8010b70ce84c29",
"_score": null,
"_source": {
"autoIncrement": 1250585.0,
"id": "018d1587422272489d8010b70ce84c29"
},
"fields": {
"displayGroup": [
"f918d24040f8f2f175917bc76ab5bf30"
]
},
"sort": [
0,
"018d1587422272489d8010b70ce84c29"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d1587b9d47130a0a50f7d9219012c",
"_score": null,
"_source": {
"autoIncrement": 1250593.0,
"id": "018d1587b9d47130a0a50f7d9219012c"
},
"fields": {
"displayGroup": [
"eb446e945160d07b55042dd7f71fbb1e"
]
},
"sort": [
0,
"018d1587b9d47130a0a50f7d9219012c"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d1588318e71398e82d2f2762b5a99",
"_score": null,
"_source": {
"autoIncrement": 1250601.0,
"id": "018d1588318e71398e82d2f2762b5a99"
},
"fields": {
"displayGroup": [
"c73cc9f8c2b32c81b8b455fe352d5fe4"
]
},
"sort": [
0,
"018d1588318e71398e82d2f2762b5a99"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d15883f3c724b8338a83705efc1ec",
"_score": null,
"_source": {
"autoIncrement": 1250602.0,
"id": "018d15883f3c724b8338a83705efc1ec"
},
"fields": {
"displayGroup": [
"b60ea4f858e04521e02f9c7e949080fe"
]
},
"sort": [
0,
"018d15883f3c724b8338a83705efc1ec"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d15884df271b687a6e692ee9b4858",
"_score": null,
"_source": {
"autoIncrement": 1250603.0,
"id": "018d15884df271b687a6e692ee9b4858"
},
"fields": {
"displayGroup": [
"4f0acc772a295bc4291a98530c34a0e1"
]
},
"sort": [
0,
"018d15884df271b687a6e692ee9b4858"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d15885bab72b9bd03d881c2d499f2",
"_score": null,
"_source": {
"autoIncrement": 1250604.0,
"id": "018d15885bab72b9bd03d881c2d499f2"
},
"fields": {
"displayGroup": [
"e33ea05a5b4caf06880827427e100213"
]
},
"sort": [
0,
"018d15885bab72b9bd03d881c2d499f2"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d158869f3725f8878b56708f32364",
"_score": null,
"_source": {
"autoIncrement": 1250605.0,
"id": "018d158869f3725f8878b56708f32364"
},
"fields": {
"displayGroup": [
"95647ed04aa57252fa28617502664018"
]
},
"sort": [
0,
"018d158869f3725f8878b56708f32364"
]
}
]
},
"aggregations": {
"total-count": {
"value": 115
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
10.25 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":"0189976cbaa071c28e12f45173dd08ea"}}}},{"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": 36,
"shipping-free": {
"value": 1.0,
"value_as_string": "true"
}
},
"rating-exists": {
"doc_count": 510,
"rating": {
"value": 0.0
}
},
"price": {
"count": 510,
"min": 12.0,
"max": 119.99,
"avg": 53.592019607843135,
"sum": 27331.93
},
"options": {
"doc_count": 984,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "018dcc33aefa71979885cc3935d7e018",
"doc_count": 64
},
{
"key": "018dd2366f0971218b31bd9eb61a21e3",
"doc_count": 48
},
{
"key": "74445db51d28437182018d704c7a3a65",
"doc_count": 44
},
{
"key": "3b518beb8e73464383696938791d0d4d",
"doc_count": 42
},
{
"key": "80590b7d56dd40f9add7abb1cdb3f625",
"doc_count": 40
},
{
"key": "febc1279d59647099435ed3ca06b734c",
"doc_count": 38
},
{
"key": "0190a0efdca070a2b454094dc5f9157f",
"doc_count": 36
},
{
"key": "6b1241d2c8bb4b6dab27bdea2c23ae43",
"doc_count": 36
},
{
"key": "208e8a5e60914ddca7235b7fe2f95277",
"doc_count": 35
},
{
"key": "5bd76e0ea76d49d9be474034d8fd16c9",
"doc_count": 35
},
{
"key": "0dac4ad66d6a42b3be9ae9ac34a1a170",
"doc_count": 34
},
{
"key": "a7fb2b7f89d640b1af1fcb577549dc14",
"doc_count": 29
},
{
"key": "018c69034daa71f3afeabb30220d629e",
"doc_count": 28
},
{
"key": "593390c143e748e3bbdaeec68178b016",
"doc_count": 26
},
{
"key": "e609606a3d18433bb18a8185dce4b98d",
"doc_count": 25
},
{
"key": "100033fbdeb9472aaa334598be045e67",
"doc_count": 23
},
{
"key": "018b804b6c41719aac39246725cfcb15",
"doc_count": 20
},
{
"key": "018c6903536e73cfa6a1671c0c676958",
"doc_count": 20
},
{
"key": "018dd2366cf571918c672d74e339a66d",
"doc_count": 20
},
{
"key": "01907295e1a0719c90455438dcf97062",
"doc_count": 18
},
{
"key": "02ac8ac6da394a42aef20b35178edaaf",
"doc_count": 18
},
{
"key": "018d796867d4732ea6131dfd7156b46e",
"doc_count": 17
},
{
"key": "018d79687e2c70fa8aba8f917629cddd",
"doc_count": 15
},
{
"key": "018dd2364b1c72deb926dd027238a53d",
"doc_count": 15
},
{
"key": "018dd2368f0b700caea19a7008dbd880",
"doc_count": 15
},
{
"key": "00f7f465a9db44e89867cf9f20abbeb5",
"doc_count": 13
},
{
"key": "018c690350f071f9b5c8280183bf8ea2",
"doc_count": 12
},
{
"key": "018c69034bce70cd8bea6089510a1f81",
"doc_count": 11
},
{
"key": "018dcc33ece973b9a0489390acbbcada",
"doc_count": 11
},
{
"key": "5f2ba814ccfc43cf898c9899ecf86783",
"doc_count": 11
},
{
"key": "a35a312994b744eba97a4bd8cec07bdd",
"doc_count": 11
},
{
"key": "018d7967d23770aca1d08a1bfc883182",
"doc_count": 10
},
{
"key": "1cfdc05e31cb4388a10211800ef287b5",
"doc_count": 10
},
{
"key": "01907295d01271819384db83fcc78aa0",
"doc_count": 9
},
{
"key": "018c6903502670a29b01dc2855133192",
"doc_count": 8
},
{
"key": "018c6903528b70b4923155d9e0d5b482",
"doc_count": 8
},
{
"key": "018c690356db705a877debf7eca82e68",
"doc_count": 8
},
{
"key": "018c69035e19710b9c471b17285fd137",
"doc_count": 8
},
{
"key": "018c690491d2716cbd877cc41c5a6791",
"doc_count": 8
},
{
"key": "018c69056a557340a1b67b4660ab63b4",
"doc_count": 8
},
{
"key": "018c7c800e32726a9da06677c344faf6",
"doc_count": 8
},
{
"key": "0190a0f01b4a719da64ff72bd6324d7f",
"doc_count": 8
},
{
"key": "0195b7f3a22b713e81b2429ba7a989b3",
"doc_count": 8
},
{
"key": "018c69051bf7739fb47ac90081254b69",
"doc_count": 6
},
{
"key": "32e6aa706d274b9c8f371c3d93023260",
"doc_count": 6
},
{
"key": "cad0f141e9da4f5591cc2ae759bcd840",
"doc_count": 6
},
{
"key": "e7ee5e1a03d74894954e60078945d69e",
"doc_count": 6
},
{
"key": "018c6904f662738787f29876954279d8",
"doc_count": 5
},
{
"key": "018f80417a117135862b089f88c85a8e",
"doc_count": 5
},
{
"key": "018f80417b987197930d2d928edf6a66",
"doc_count": 5
},
{
"key": "0195b7f3819c7252845b3b51725b28a8",
"doc_count": 5
},
{
"key": "0195b7f3961370448708672e7e4ccee0",
"doc_count": 5
},
{
"key": "aa7c8e4797b04c4ca7a0cb1df3a63074",
"doc_count": 4
},
{
"key": "0ff7ae68b8d5442caf7b88e95c231247",
"doc_count": 3
},
{
"key": "63eac26e6a124098a9e8e806d4f07fa9",
"doc_count": 3
},
{
"key": "86d99aa07a334daf8fb4fc45a5bc18fd",
"doc_count": 3
},
{
"key": "018c6905173f72178bec94774ced9686",
"doc_count": 2
},
{
"key": "466ff77bac5249499b22e0e0ddad42fe",
"doc_count": 2
},
{
"key": "ec04f21cad4b47cea3ea1f12978935c3",
"doc_count": 2
},
{
"key": "018c6905ba6372048ee9b3269131ed97",
"doc_count": 1
},
{
"key": "018c7c809f7a712bad4bfc7fc17d1539",
"doc_count": 1
},
{
"key": "018d79678a61724394bb7ae5527da925",
"doc_count": 1
},
{
"key": "01907295e213734fa84b281e0008f826",
"doc_count": 1
},
{
"key": "b4d2c7bdf2294e37b92c0dbc41579602",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 1914,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "0189641303a7701b8c6075992cf0d4a5",
"doc_count": 374
},
{
"key": "01896411e3007292bbf291a9837a8cc8",
"doc_count": 323
},
{
"key": "018963e5f53b7292b003bf6803f624b7",
"doc_count": 293
},
{
"key": "01896411e11071498f66a862f5383700",
"doc_count": 129
},
{
"key": "018963e5f13871739bde1b0eb26bb21b",
"doc_count": 128
},
{
"key": "018963ea3aba7042895b047285c1402e",
"doc_count": 127
},
{
"key": "018963e5f32b703288aad57690802852",
"doc_count": 77
},
{
"key": "01896413050a7294a14724d6d73f35cc",
"doc_count": 77
},
{
"key": "018963ea220370f6b3962a1108942bae",
"doc_count": 75
},
{
"key": "018963ea415c7217b4dc8cb62572ed16",
"doc_count": 74
},
{
"key": "018963ea1812737fb7f416641565cd24",
"doc_count": 63
},
{
"key": "018bbe13b7757294bf18b34533cada9d",
"doc_count": 44
},
{
"key": "018963ea3609712896e2d21c3a2d91ab",
"doc_count": 42
},
{
"key": "0190a6bca60c70d6979f3a69eb39a7e8",
"doc_count": 26
},
{
"key": "018963ea1a0071e3b903843432a2818e",
"doc_count": 24
},
{
"key": "018dcc3373f47133833772ee8dfc3fe4",
"doc_count": 18
},
{
"key": "018963ea26b971f09527dfc7f4930323",
"doc_count": 10
},
{
"key": "018963ea24c172519a11176e570bcae4",
"doc_count": 5
},
{
"key": "01896411e05c71f4af78a5552a40b626",
"doc_count": 2
},
{
"key": "018c8bbef3a670cbb125c2af46625be1",
"doc_count": 2
},
{
"key": "0189641326fb70ba866a04913980048e",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "57f85a1341f34ad284dc91714711a009",
"doc_count": 173
},
{
"key": "0eb8635d02c643c2b1d22ea1631c0c90",
"doc_count": 157
},
{
"key": "d8ac016c293145ff9d20f96184a4ad02",
"doc_count": 99
},
{
"key": "1cadc079599b4e0386adc59541691ef7",
"doc_count": 48
},
{
"key": "69126f5efcab45738b242009148aca51",
"doc_count": 31
},
{
"key": "018c7c9a616c7007bb7960ba88e59312",
"doc_count": 2
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|