| 1 |
21.06 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":"0189977888fd71b0a3c9f459d008008c"}}}},{"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": 18,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 596,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_all4team_product_1716336301",
"_id": "018af46ae723708cabfd890d9242f633",
"_score": null,
"_source": {
"autoIncrement": 1132036.0,
"id": "018af46ae723708cabfd890d9242f633"
},
"fields": {
"displayGroup": [
"9c32c21d5df8a883d54130081aca37ee"
]
},
"sort": [
0,
"018af46ae723708cabfd890d9242f633"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018af47079827120a4b973b2a5878018",
"_score": null,
"_source": {
"autoIncrement": 1132556.0,
"id": "018af47079827120a4b973b2a5878018"
},
"fields": {
"displayGroup": [
"f8be1c329919b46879a8e55c1e252cbf"
]
},
"sort": [
0,
"018af47079827120a4b973b2a5878018"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018af470ad3f709dba8f2d810b1ea43e",
"_score": null,
"_source": {
"autoIncrement": 1132588.0,
"id": "018af470ad3f709dba8f2d810b1ea43e"
},
"fields": {
"displayGroup": [
"d555681604072e6459d8dfc48a675f4f"
]
},
"sort": [
0,
"018af470ad3f709dba8f2d810b1ea43e"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bd6540de67180a793cabc303e1f64",
"_score": null,
"_source": {
"autoIncrement": 1140604.0,
"id": "018bd6540de67180a793cabc303e1f64"
},
"fields": {
"displayGroup": [
"15de320db7dd2b298b3f5c686c2f0770"
]
},
"sort": [
0,
"018bd6540de67180a793cabc303e1f64"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bf095b17370ca9246e56ae5470548",
"_score": null,
"_source": {
"autoIncrement": 1141712.0,
"id": "018bf095b17370ca9246e56ae5470548"
},
"fields": {
"displayGroup": [
"dee576386f7ebcd7ef1c3675b0129621"
]
},
"sort": [
0,
"018bf095b17370ca9246e56ae5470548"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bf891aa1a73098cd8611237acaa8a",
"_score": null,
"_source": {
"autoIncrement": 1145990.0,
"id": "018bf891aa1a73098cd8611237acaa8a"
},
"fields": {
"displayGroup": [
"3c9022ea61fde770294ad3c77320f7cc"
]
},
"sort": [
0,
"018bf891aa1a73098cd8611237acaa8a"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bf896177d722eb6d53db5e77900f8",
"_score": null,
"_source": {
"autoIncrement": 1146026.0,
"id": "018bf896177d722eb6d53db5e77900f8"
},
"fields": {
"displayGroup": [
"4a475f657607660e3952723677493b55"
]
},
"sort": [
0,
"018bf896177d722eb6d53db5e77900f8"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bf898b6147368be69641bed768acc",
"_score": null,
"_source": {
"autoIncrement": 1146054.0,
"id": "018bf898b6147368be69641bed768acc"
},
"fields": {
"displayGroup": [
"4855b844ccaebcbf0c6aad8d792e23c8"
]
},
"sort": [
0,
"018bf898b6147368be69641bed768acc"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bf93807e47333bfee8044d0f1f6f7",
"_score": null,
"_source": {
"autoIncrement": 1146715.0,
"id": "018bf93807e47333bfee8044d0f1f6f7"
},
"fields": {
"displayGroup": [
"49d70ae77695a7d74744867a5ef37797"
]
},
"sort": [
0,
"018bf93807e47333bfee8044d0f1f6f7"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7e80741373e98bf521f7cbd0174f",
"_score": null,
"_source": {
"autoIncrement": 1150066.0,
"id": "018c7e80741373e98bf521f7cbd0174f"
},
"fields": {
"displayGroup": [
"2df479fc75d1cccf5bd414526ddb96d1"
]
},
"sort": [
0,
"018c7e80741373e98bf521f7cbd0174f"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7e80b1b17004a9953d30f1eecc28",
"_score": null,
"_source": {
"autoIncrement": 1150079.0,
"id": "018c7e80b1b17004a9953d30f1eecc28"
},
"fields": {
"displayGroup": [
"4ab7a6cd8cc3f3ec9ca0900c77fb4d1f"
]
},
"sort": [
0,
"018c7e80b1b17004a9953d30f1eecc28"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7e8109a4707aa84a9a618728e010",
"_score": null,
"_source": {
"autoIncrement": 1150089.0,
"id": "018c7e8109a4707aa84a9a618728e010"
},
"fields": {
"displayGroup": [
"aa053d8b70a7396c861fb91e06f0d757"
]
},
"sort": [
0,
"018c7e8109a4707aa84a9a618728e010"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7e9061c272948ff0e5f823847566",
"_score": null,
"_source": {
"autoIncrement": 1150841.0,
"id": "018c7e9061c272948ff0e5f823847566"
},
"fields": {
"displayGroup": [
"03b899d274618a488421041a14bac24c"
]
},
"sort": [
0,
"018c7e9061c272948ff0e5f823847566"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018cd9ee9972725baeef299a7f4ec2c1",
"_score": null,
"_source": {
"autoIncrement": 1227085.0,
"id": "018cd9ee9972725baeef299a7f4ec2c1"
},
"fields": {
"displayGroup": [
"9ca15931f247f51bcff9b28936b3bc1f"
]
},
"sort": [
0,
"018cd9ee9972725baeef299a7f4ec2c1"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018cda84c6fb736d9ec5b551aaeecd71",
"_score": null,
"_source": {
"autoIncrement": 1227516.0,
"id": "018cda84c6fb736d9ec5b551aaeecd71"
},
"fields": {
"displayGroup": [
"3eb5a7115754d2d7c4f53d22b14f0a32"
]
},
"sort": [
0,
"018cda84c6fb736d9ec5b551aaeecd71"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018cda861bfc7225bcb668fda36b4eb0",
"_score": null,
"_source": {
"autoIncrement": 1227549.0,
"id": "018cda861bfc7225bcb668fda36b4eb0"
},
"fields": {
"displayGroup": [
"0a1b33e85e9aa49c7e488ef8a4972069"
]
},
"sort": [
0,
"018cda861bfc7225bcb668fda36b4eb0"
]
}
]
},
"aggregations": {
"total-count": {
"value": 30
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
19.43 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":"0189977888fd71b0a3c9f459d008008c"}}}},{"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_rulef56aa66553b04105839b38b9288ce3ed_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": 17,
"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": 596,
"rating": {
"value": 0.0
}
},
"price": {
"count": 596,
"min": 53.96,
"max": 168.97,
"avg": 110.82543624161075,
"sum": 66051.96
},
"options": {
"doc_count": 1192,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "fb2bcb1d04544f8e91cab9caadccd0e2",
"doc_count": 66
},
{
"key": "7189e238f66c4db8831ad403f65df75e",
"doc_count": 65
},
{
"key": "97610a9e8a0f4970a7be7eec0bac0378",
"doc_count": 65
},
{
"key": "c36af3803d914e8bb422246a1b400a68",
"doc_count": 64
},
{
"key": "e1b2548665464da9b4f051e46c78427f",
"doc_count": 63
},
{
"key": "b5a3d8c7138344dda67987a4eff4cb1c",
"doc_count": 60
},
{
"key": "f166e204f18a46cd947eb253dc245521",
"doc_count": 59
},
{
"key": "2ef77dd834ab4ad8bf116883a3624328",
"doc_count": 54
},
{
"key": "02b2bfe9b0e14a4984499e6f7eda59f4",
"doc_count": 35
},
{
"key": "90deb273963c446380e69696e17dbc1c",
"doc_count": 24
},
{
"key": "9320d9f0b3ab4d3281c7cbff0afc916e",
"doc_count": 24
},
{
"key": "c0088ccb433c49aaadfc61d1966f804c",
"doc_count": 22
},
{
"key": "018c690428667196b293271b93c8fce8",
"doc_count": 19
},
{
"key": "018d9389d5447237a80328cdb9e3e58a",
"doc_count": 19
},
{
"key": "018dc10b817573e5baff6ad3eba633ff",
"doc_count": 19
},
{
"key": "a5d7196c2514479f857621c32bb84608",
"doc_count": 19
},
{
"key": "d1405d94a50b43e5bc5d087b0fb832d3",
"doc_count": 19
},
{
"key": "018c690373db70d1a8b4431b5d201d5a",
"doc_count": 13
},
{
"key": "018d7967737a722ba5a01a03248ac8dd",
"doc_count": 11
},
{
"key": "0f42543ad7144042892dccb06b81b891",
"doc_count": 11
},
{
"key": "2b54c8efa8924e548357b0ebc2bef0d1",
"doc_count": 11
},
{
"key": "2bc45bc05df945f8a5403892f38513f9",
"doc_count": 11
},
{
"key": "329ca6bd895e42be927eb470cc8f2f62",
"doc_count": 11
},
{
"key": "333b5256e0d5444d9b61e615ed840214",
"doc_count": 11
},
{
"key": "53925a17c71d4d54b08527c466fcc436",
"doc_count": 11
},
{
"key": "58b1767830db4f3682a1e6b6c7a14366",
"doc_count": 11
},
{
"key": "a132823eaf34421c82c307567af7ec32",
"doc_count": 11
},
{
"key": "af985f0f29164155b1c51cce3071b732",
"doc_count": 11
},
{
"key": "018d7967a24d7231a7903b11c65b87d0",
"doc_count": 10
},
{
"key": "37e29d38048647618ed7473a4ee58783",
"doc_count": 10
},
{
"key": "927535966aa243289d45f2f7f79b3495",
"doc_count": 10
},
{
"key": "5327caf6ba19446293c2e42edaa49e1c",
"doc_count": 9
},
{
"key": "6f242ff7ed204f40be74447de407e8b9",
"doc_count": 9
},
{
"key": "f18d7885bd82457aa21cce68115a2cac",
"doc_count": 9
},
{
"key": "00154c3577bd4a1687ab64558d702e29",
"doc_count": 8
},
{
"key": "018c6905159270e8a76a7d8095e4318d",
"doc_count": 8
},
{
"key": "018c6905314d708e857e899290f40007",
"doc_count": 8
},
{
"key": "018c6905442c71c79f2bf590ce28f6f0",
"doc_count": 8
},
{
"key": "018c69054ecc7138aebccac90ff8982f",
"doc_count": 8
},
{
"key": "018c690578b970f68928af0656c335ba",
"doc_count": 8
},
{
"key": "018c7c80197c71d1943b0bf2e55d6c15",
"doc_count": 8
},
{
"key": "018dc10b629f72e79fe7f3fd342529f3",
"doc_count": 8
},
{
"key": "018dc10b646a703eac665bf19eabf53c",
"doc_count": 8
},
{
"key": "018dc10b66307178a90d1ad4673d533d",
"doc_count": 8
},
{
"key": "018dc10b84e17231a40a683b39377776",
"doc_count": 8
},
{
"key": "018dc10b8a4f709eb4a92670502c7c7a",
"doc_count": 8
},
{
"key": "018dc10b8b3471a8ba8a017608722e1e",
"doc_count": 8
},
{
"key": "018f4d5bbbe9709a82c9d030658fc4f1",
"doc_count": 8
},
{
"key": "1a82b459b30e47a98a4da3220e6eb67e",
"doc_count": 8
},
{
"key": "31f525e0cb5c4615bceaf6c8ed443403",
"doc_count": 8
},
{
"key": "61683401240543bf9d4b8b01e95b15e8",
"doc_count": 8
},
{
"key": "97fee4720c0b460882641f1473402f69",
"doc_count": 8
},
{
"key": "990d01c0767c4511b1e18acbd945aff0",
"doc_count": 8
},
{
"key": "c7946d520147493d8d1def8694925a19",
"doc_count": 8
},
{
"key": "018c6905468370e0b90b0defaf07809e",
"doc_count": 7
},
{
"key": "018c690557ac7286a2c8aa284aba36fd",
"doc_count": 7
},
{
"key": "01909baa88ff72b7a294fd1959daaf10",
"doc_count": 7
},
{
"key": "3f6cc38aafaf40dda299f20bdc57f0f4",
"doc_count": 7
},
{
"key": "4e560868c267419a844d8275d09a01bc",
"doc_count": 7
},
{
"key": "8e1bf769aa3f431e88d2a26b37e69cfd",
"doc_count": 7
},
{
"key": "eb352525be744cf08b7ccec9986fd7b3",
"doc_count": 7
},
{
"key": "26dc7ee19e2d40f0a1bd51049c7e2087",
"doc_count": 6
},
{
"key": "3dbf707950a44056be3e7f5936787d33",
"doc_count": 6
},
{
"key": "804aaf77a61b44a48b33c75b8773c9b2",
"doc_count": 6
},
{
"key": "a43113822447451c8801a7acd30a92da",
"doc_count": 6
},
{
"key": "c7db1e848c194abe9915ffb9a1c4fd4d",
"doc_count": 6
},
{
"key": "2055b8652dba4a38bb12157ef8bd8e7c",
"doc_count": 5
},
{
"key": "24825ae0f7ff41bdbddc49e34931df58",
"doc_count": 5
},
{
"key": "315cb9310b214613b5cb9ce8baa33f56",
"doc_count": 5
},
{
"key": "528d738a30b847248434b14e905cd91c",
"doc_count": 5
},
{
"key": "799eeec01566421399f0186a0c1929ae",
"doc_count": 5
},
{
"key": "98d6bcd6d5da4c45a80c847b8f441853",
"doc_count": 5
},
{
"key": "c4ca7c83d7b9434dba35d808f3cb587b",
"doc_count": 5
},
{
"key": "018c69048f28715ba04fac04833aa6e9",
"doc_count": 4
},
{
"key": "01909baa4a097194bf00f4a8ed5f2d50",
"doc_count": 4
},
{
"key": "d2defd0f49804e81a1052d4f0e7d419a",
"doc_count": 4
},
{
"key": "d32f5d7c6ff24f32ac2cef76583b3ff3",
"doc_count": 4
},
{
"key": "018c6903759d704f89c3dcc58ee7f902",
"doc_count": 3
},
{
"key": "018d8d98f13f72079975617aeabab440",
"doc_count": 3
},
{
"key": "018c690534787194888a45182b3640dd",
"doc_count": 2
},
{
"key": "018d796796d57086aad224e6c4dc1aeb",
"doc_count": 2
},
{
"key": "018d79691698724882ea67e81a5925c7",
"doc_count": 2
},
{
"key": "01909baa7af972ceb97b55c21ac53e25",
"doc_count": 2
},
{
"key": "f1450bc9e5634646b01a7d79f816a9ea",
"doc_count": 2
},
{
"key": "018c69036c5d709fa6759781d6dd5cff",
"doc_count": 1
},
{
"key": "018c6904661973d7894fbed40489b909",
"doc_count": 1
},
{
"key": "018c6904898d739c98b26ab538ea2e57",
"doc_count": 1
},
{
"key": "01907295cac07196bab5e718fe028e0c",
"doc_count": 1
},
{
"key": "01909baa260a726b9c0ce16449850c92",
"doc_count": 1
},
{
"key": "0b2b79c9ecbd4a9586ee38b2cb6caf9c",
"doc_count": 1
},
{
"key": "2583d76ffb214c698f2349408c44cb61",
"doc_count": 1
},
{
"key": "32379b13453543bf9d8e18506c4e2110",
"doc_count": 1
},
{
"key": "62e1f91b41a448959bdf7061be0480d9",
"doc_count": 1
},
{
"key": "6baf2833d657438ab806b77e54b3f17a",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 2324,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "018963e5f06f716dadb0fe95b3c53d22",
"doc_count": 569
},
{
"key": "01896411e82d73ef973f22bb35c69d07",
"doc_count": 526
},
{
"key": "01896412ce257222b5e891706c8b902f",
"doc_count": 392
},
{
"key": "018bbe1474b972549ff49ff501fe894c",
"doc_count": 256
},
{
"key": "018963ea3aba7042895b047285c1402e",
"doc_count": 126
},
{
"key": "018dcc3373f47133833772ee8dfc3fe4",
"doc_count": 78
},
{
"key": "018bbe13c09d7328ba65279e42d55280",
"doc_count": 60
},
{
"key": "01896411e1b67172ac7120fc2f0fa574",
"doc_count": 56
},
{
"key": "018963ea220370f6b3962a1108942bae",
"doc_count": 53
},
{
"key": "018963ea415c7217b4dc8cb62572ed16",
"doc_count": 44
},
{
"key": "018963ea336b7003ba1d74549036192d",
"doc_count": 33
},
{
"key": "018963ea3609712896e2d21c3a2d91ab",
"doc_count": 24
},
{
"key": "018963ea1812737fb7f416641565cd24",
"doc_count": 23
},
{
"key": "018963e5f13871739bde1b0eb26bb21b",
"doc_count": 22
},
{
"key": "018963ea24c172519a11176e570bcae4",
"doc_count": 13
},
{
"key": "018963ea20b670278236dc7103bcceb8",
"doc_count": 11
},
{
"key": "018963ea3964707fbbfb35b2b8e8084b",
"doc_count": 11
},
{
"key": "018963ea1a0071e3b903843432a2818e",
"doc_count": 8
},
{
"key": "018963e5f53b7292b003bf6803f624b7",
"doc_count": 5
},
{
"key": "01896411e25971f98272a565102c3faf",
"doc_count": 5
},
{
"key": "018c8882c6587134b1bb432cbbffd81c",
"doc_count": 5
},
{
"key": "018e5c605ca5725aa4a586968ccd3b5f",
"doc_count": 4
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "2a606633b77f4e1bab45f45f3483a835",
"doc_count": 530
},
{
"key": "d8ac016c293145ff9d20f96184a4ad02",
"doc_count": 66
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|