| 1 |
321.78 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":"018997a60b4d718b8e179774daa245ae"}}}},{"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": 318,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 188,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_all4team_product_1716336301",
"_id": "018af45e8bd07264b5f505a0dac5e5bd",
"_score": null,
"_source": {
"autoIncrement": 1131049.0,
"id": "018af45e8bd07264b5f505a0dac5e5bd"
},
"fields": {
"displayGroup": [
"5e7ea966aabdf7caf0e6d42320ebd071"
]
},
"sort": [
0,
"018af45e8bd07264b5f505a0dac5e5bd"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bce1a535f73f29d4abc76169685bd",
"_score": null,
"_source": {
"autoIncrement": 1135992.0,
"id": "018bce1a535f73f29d4abc76169685bd"
},
"fields": {
"displayGroup": [
"a2cab2b93d446722a145b97fd88a2cb6"
]
},
"sort": [
0,
"018bce1a535f73f29d4abc76169685bd"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bd02d399572adadb13d526bc7414a",
"_score": null,
"_source": {
"autoIncrement": 1136355.0,
"id": "018bd02d399572adadb13d526bc7414a"
},
"fields": {
"displayGroup": [
"db1fff00368906fd81d3fb6a8dbba7f2"
]
},
"sort": [
0,
"018bd02d399572adadb13d526bc7414a"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c80dde57373dd8ccf601e346f4bb1",
"_score": null,
"_source": {
"autoIncrement": 1164915.0,
"id": "018c80dde57373dd8ccf601e346f4bb1"
},
"fields": {
"displayGroup": [
"1013fed912ad0b0ac666b0db166395c9"
]
},
"sort": [
0,
"018c80dde57373dd8ccf601e346f4bb1"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c888f17b772cc88e47128ff03bec4",
"_score": null,
"_source": {
"autoIncrement": 1169125.0,
"id": "018c888f17b772cc88e47128ff03bec4"
},
"fields": {
"displayGroup": [
"db2dccd5288b2aa150ab84ffd05c7dc6"
]
},
"sort": [
0,
"018c888f17b772cc88e47128ff03bec4"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d99111c75707190dd963f8e60be3f",
"_score": null,
"_source": {
"autoIncrement": 1293021.0,
"id": "018d99111c75707190dd963f8e60be3f"
},
"fields": {
"displayGroup": [
"dc5f080d1e45b52170f5f74b980ec1a1"
]
},
"sort": [
0,
"018d99111c75707190dd963f8e60be3f"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d993c45c072269b13723e1d2b4924",
"_score": null,
"_source": {
"autoIncrement": 1293459.0,
"id": "018d993c45c072269b13723e1d2b4924"
},
"fields": {
"displayGroup": [
"5bb8325644ad27b973c5ae2a16880be2"
]
},
"sort": [
0,
"018d993c45c072269b13723e1d2b4924"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01904f9e96607308b1b5121f36796e95",
"_score": null,
"_source": {
"autoIncrement": 1805596.0,
"id": "01904f9e96607308b1b5121f36796e95"
},
"fields": {
"displayGroup": [
"90ff0609c1f8421a35d3f63c77f4967c"
]
},
"sort": [
0,
"01904f9e96607308b1b5121f36796e95"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "019091cba10c72f78425cc53cfa2a6d7",
"_score": null,
"_source": {
"autoIncrement": 1822032.0,
"id": "019091cba10c72f78425cc53cfa2a6d7"
},
"fields": {
"displayGroup": [
"edd8c9988b3e582b5365abb2fbeb2d4e"
]
},
"sort": [
0,
"019091cba10c72f78425cc53cfa2a6d7"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01909c4f843170b2a94671a1e59329de",
"_score": null,
"_source": {
"autoIncrement": 1825496.0,
"id": "01909c4f843170b2a94671a1e59329de"
},
"fields": {
"displayGroup": [
"edb38dcd2a74872db3bc54c4377b4617"
]
},
"sort": [
0,
"01909c4f843170b2a94671a1e59329de"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01909c4ff36671d499fc64e5442b8a3a",
"_score": null,
"_source": {
"autoIncrement": 1825529.0,
"id": "01909c4ff36671d499fc64e5442b8a3a"
},
"fields": {
"displayGroup": [
"22b2a7adb687170d10e8a04fb0f07755"
]
},
"sort": [
0,
"01909c4ff36671d499fc64e5442b8a3a"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0190da5028f270f5b1dc65eb8e173172",
"_score": null,
"_source": {
"autoIncrement": 1840705.0,
"id": "0190da5028f270f5b1dc65eb8e173172"
},
"fields": {
"displayGroup": [
"3e08bdab11d04764bda9cc0bed70e808"
]
},
"sort": [
0,
"0190da5028f270f5b1dc65eb8e173172"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0190e4669ffa714a89ddcd1f41cc2fbc",
"_score": null,
"_source": {
"autoIncrement": 1840866.0,
"id": "0190e4669ffa714a89ddcd1f41cc2fbc"
},
"fields": {
"displayGroup": [
"ff281dfb7933d7012029db0e40be2596"
]
},
"sort": [
0,
"0190e4669ffa714a89ddcd1f41cc2fbc"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0190e4681e897304adf557b03b583cc9",
"_score": null,
"_source": {
"autoIncrement": 1840946.0,
"id": "0190e4681e897304adf557b03b583cc9"
},
"fields": {
"displayGroup": [
"7cddc9fef42d1894a112f1714ec648bf"
]
},
"sort": [
0,
"0190e4681e897304adf557b03b583cc9"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01931d1579c7712491584d31c86f7919",
"_score": null,
"_source": {
"autoIncrement": 1861849.0,
"id": "01931d1579c7712491584d31c86f7919"
},
"fields": {
"displayGroup": [
"ff4a5e2aa0362a62349868184d5d3986"
]
},
"sort": [
0,
"01931d1579c7712491584d31c86f7919"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "398a7a432af04f389c18d66e1d49cb3f",
"_score": null,
"_source": {
"autoIncrement": 1130207.0,
"id": "398a7a432af04f389c18d66e1d49cb3f"
},
"fields": {
"displayGroup": [
"e907a03e7a45999dd8ba33d6b8bc08c2"
]
},
"sort": [
0,
"398a7a432af04f389c18d66e1d49cb3f"
]
}
]
},
"aggregations": {
"total-count": {
"value": 16
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
11.75 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":"018997a60b4d718b8e179774daa245ae"}}}},{"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": 188,
"rating": {
"value": 0.0
}
},
"price": {
"count": 188,
"min": 59.99,
"max": 183.96,
"avg": 129.63281914893616,
"sum": 24370.97
},
"options": {
"doc_count": 376,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "01909baa289473c988f5798b39a2ba9c",
"doc_count": 20
},
{
"key": "2187203b11f344b6a815ba773a93bb44",
"doc_count": 20
},
{
"key": "018d7967fbc47234a7737c0c64fb6b7a",
"doc_count": 19
},
{
"key": "018c690369a9714988c0ae7e113fee13",
"doc_count": 17
},
{
"key": "98d6bcd6d5da4c45a80c847b8f441853",
"doc_count": 16
},
{
"key": "018d79675466735989015568610f58b3",
"doc_count": 15
},
{
"key": "24825ae0f7ff41bdbddc49e34931df58",
"doc_count": 15
},
{
"key": "6f242ff7ed204f40be74447de407e8b9",
"doc_count": 15
},
{
"key": "f166e204f18a46cd947eb253dc245521",
"doc_count": 15
},
{
"key": "2ef77dd834ab4ad8bf116883a3624328",
"doc_count": 14
},
{
"key": "528d738a30b847248434b14e905cd91c",
"doc_count": 14
},
{
"key": "799eeec01566421399f0186a0c1929ae",
"doc_count": 14
},
{
"key": "c4ca7c83d7b9434dba35d808f3cb587b",
"doc_count": 14
},
{
"key": "fefc7b01e0504b2fb7aa23b3115fe4f8",
"doc_count": 14
},
{
"key": "018c690374bb738aa0421895b19398ff",
"doc_count": 13
},
{
"key": "d32f5d7c6ff24f32ac2cef76583b3ff3",
"doc_count": 13
},
{
"key": "01909baa4d9072658b9722deb8eea0a6",
"doc_count": 12
},
{
"key": "2055b8652dba4a38bb12157ef8bd8e7c",
"doc_count": 12
},
{
"key": "01909baa8a5e71d19a057b33fe293e3d",
"doc_count": 11
},
{
"key": "01900205879f7248867868c412fc658d",
"doc_count": 10
},
{
"key": "01909baa426d72e6a4ee1d0950c74af3",
"doc_count": 10
},
{
"key": "0190da3aa17072389aa7eb2bb7f19c1e",
"doc_count": 10
},
{
"key": "fb2bcb1d04544f8e91cab9caadccd0e2",
"doc_count": 10
},
{
"key": "e1b2548665464da9b4f051e46c78427f",
"doc_count": 9
},
{
"key": "c36af3803d914e8bb422246a1b400a68",
"doc_count": 7
},
{
"key": "64a44b3d85144a88b890b250e7030d5f",
"doc_count": 5
},
{
"key": "b9098912ba704078bf6482acae250e23",
"doc_count": 4
},
{
"key": "019091974b0f73d88d5927c8ac9dc0f6",
"doc_count": 3
},
{
"key": "0190a0f0f1ae72fa8bf68020f89be56d",
"doc_count": 3
},
{
"key": "7189e238f66c4db8831ad403f65df75e",
"doc_count": 3
},
{
"key": "a5d7196c2514479f857621c32bb84608",
"doc_count": 3
},
{
"key": "c0088ccb433c49aaadfc61d1966f804c",
"doc_count": 3
},
{
"key": "01909baa8de17351bcc7515ba3f6e4d4",
"doc_count": 2
},
{
"key": "04fba7aa2b5e4d4ba49f6e2464da8644",
"doc_count": 2
},
{
"key": "209a3a1ec0e146688922fb9d78b72f61",
"doc_count": 2
},
{
"key": "97610a9e8a0f4970a7be7eec0bac0378",
"doc_count": 2
},
{
"key": "b5a3d8c7138344dda67987a4eff4cb1c",
"doc_count": 2
},
{
"key": "c2725e1f949d43afafbd92ebcdce5798",
"doc_count": 2
},
{
"key": "01909baa7830735b8922c00ab7cb2dfc",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 697,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "0189641275be72e7941246e7b15d1e76",
"doc_count": 134
},
{
"key": "018963e5f13871739bde1b0eb26bb21b",
"doc_count": 97
},
{
"key": "018963e5f53b7292b003bf6803f624b7",
"doc_count": 91
},
{
"key": "01896411e3007292bbf291a9837a8cc8",
"doc_count": 84
},
{
"key": "018963ea3aba7042895b047285c1402e",
"doc_count": 65
},
{
"key": "01896411e11071498f66a862f5383700",
"doc_count": 37
},
{
"key": "018963ea1812737fb7f416641565cd24",
"doc_count": 35
},
{
"key": "01896411e3af718192fb7f9ee45ad6fb",
"doc_count": 32
},
{
"key": "018bbe147153736fbaa17cb7d91264a8",
"doc_count": 32
},
{
"key": "018963ea2bce70d7876c75f434e017d1",
"doc_count": 22
},
{
"key": "01896412d947725f982fc682b748509d",
"doc_count": 22
},
{
"key": "018dc71933ba73f29d979240d3813950",
"doc_count": 18
},
{
"key": "018963ea3609712896e2d21c3a2d91ab",
"doc_count": 17
},
{
"key": "018963ea415c7217b4dc8cb62572ed16",
"doc_count": 11
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "d8ac016c293145ff9d20f96184a4ad02",
"doc_count": 123
},
{
"key": "57f85a1341f34ad284dc91714711a009",
"doc_count": 57
},
{
"key": "6f10e4ac0c444f1a91667bad688d924f",
"doc_count": 8
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|