| 1 |
2043.30 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":"018997d0242273cd81441519a0b46d58"}}}},{"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": 2040,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 482,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_all4team_product_1716336301",
"_id": "018af47d5f3b730cbd1280f35741c86b",
"_score": null,
"_source": {
"autoIncrement": 1133429.0,
"id": "018af47d5f3b730cbd1280f35741c86b"
},
"fields": {
"displayGroup": [
"dac9b4854c19c53ec4904317559d024e"
]
},
"sort": [
1,
"018af47d5f3b730cbd1280f35741c86b"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018af47f568f717a8039593d56ad7bb9",
"_score": null,
"_source": {
"autoIncrement": 1133651.0,
"id": "018af47f568f717a8039593d56ad7bb9"
},
"fields": {
"displayGroup": [
"15905b834d9323fb1fe0f8cfb90f5dee"
]
},
"sort": [
1,
"018af47f568f717a8039593d56ad7bb9"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018af47c7d1572a88996e8d6a016a102",
"_score": null,
"_source": {
"autoIncrement": 1133292.0,
"id": "018af47c7d1572a88996e8d6a016a102"
},
"fields": {
"displayGroup": [
"a62edabf884bd829c9c93efadb2f4c43"
]
},
"sort": [
0,
"018af47c7d1572a88996e8d6a016a102"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c888b467c72fca0f3c1de4af2cce3",
"_score": null,
"_source": {
"autoIncrement": 1168658.0,
"id": "018c888b467c72fca0f3c1de4af2cce3"
},
"fields": {
"displayGroup": [
"7724a88b4dc87640a97c85a246d536ec"
]
},
"sort": [
0,
"018c888b467c72fca0f3c1de4af2cce3"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018cd0439096728d8c4e4f4183fdbb12",
"_score": null,
"_source": {
"autoIncrement": 1223308.0,
"id": "018cd0439096728d8c4e4f4183fdbb12"
},
"fields": {
"displayGroup": [
"22058ab48188c8df8bbdc0f4daea9d2b"
]
},
"sort": [
0,
"018cd0439096728d8c4e4f4183fdbb12"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d1bace88e7252a735108e660cd751",
"_score": null,
"_source": {
"autoIncrement": 1253701.0,
"id": "018d1bace88e7252a735108e660cd751"
},
"fields": {
"displayGroup": [
"58b932811559b24e1e6262daffb64ad1"
]
},
"sort": [
0,
"018d1bace88e7252a735108e660cd751"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d94dd2597738e98e14712f481c1e5",
"_score": null,
"_source": {
"autoIncrement": 1289672.0,
"id": "018d94dd2597738e98e14712f481c1e5"
},
"fields": {
"displayGroup": [
"380b3bdbc7d984f1be9cda00619ab713"
]
},
"sort": [
0,
"018d94dd2597738e98e14712f481c1e5"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d9935308a7396951000f1206c2af2",
"_score": null,
"_source": {
"autoIncrement": 1293395.0,
"id": "018d9935308a7396951000f1206c2af2"
},
"fields": {
"displayGroup": [
"26edf01d9c6f72886c6cc1861d3f43ae"
]
},
"sort": [
0,
"018d9935308a7396951000f1206c2af2"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018e18dea76d73698cd278bdb0ea6000",
"_score": null,
"_source": {
"autoIncrement": 1774039.0,
"id": "018e18dea76d73698cd278bdb0ea6000"
},
"fields": {
"displayGroup": [
"1c0d9dc312c198524239f5c54017e411"
]
},
"sort": [
0,
"018e18dea76d73698cd278bdb0ea6000"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018f7b72cf3a72e99f09f2ea1b1a8d55",
"_score": null,
"_source": {
"autoIncrement": 1785094.0,
"id": "018f7b72cf3a72e99f09f2ea1b1a8d55"
},
"fields": {
"displayGroup": [
"90a2681b815348e8111e7c0bf679a070"
]
},
"sort": [
0,
"018f7b72cf3a72e99f09f2ea1b1a8d55"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01904f9f3f7572da9298f2d7a7ba08a0",
"_score": null,
"_source": {
"autoIncrement": 1805660.0,
"id": "01904f9f3f7572da9298f2d7a7ba08a0"
},
"fields": {
"displayGroup": [
"c38e00cbd73981a0d53a9c8b1a3198f5"
]
},
"sort": [
0,
"01904f9f3f7572da9298f2d7a7ba08a0"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01904f9fe4a973b4987a91061f5fef2e",
"_score": null,
"_source": {
"autoIncrement": 1805729.0,
"id": "01904f9fe4a973b4987a91061f5fef2e"
},
"fields": {
"displayGroup": [
"7974bc74931469f822036ed54125c846"
]
},
"sort": [
0,
"01904f9fe4a973b4987a91061f5fef2e"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0190644bc2dd70c8814daf8c1e67b4ac",
"_score": null,
"_source": {
"autoIncrement": 1807480.0,
"id": "0190644bc2dd70c8814daf8c1e67b4ac"
},
"fields": {
"displayGroup": [
"5ad34bc87dc909806d6dd7aa86270762"
]
},
"sort": [
0,
"0190644bc2dd70c8814daf8c1e67b4ac"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01909c50fe6e731ba0c1387e217be906",
"_score": null,
"_source": {
"autoIncrement": 1825651.0,
"id": "01909c50fe6e731ba0c1387e217be906"
},
"fields": {
"displayGroup": [
"04fe66a794814d9cc24a3931d73516fa"
]
},
"sort": [
0,
"01909c50fe6e731ba0c1387e217be906"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01909c5182a7726592b49a473b03cf1d",
"_score": null,
"_source": {
"autoIncrement": 1825704.0,
"id": "01909c5182a7726592b49a473b03cf1d"
},
"fields": {
"displayGroup": [
"46a59edf643266ee83782c7d948edd50"
]
},
"sort": [
0,
"01909c5182a7726592b49a473b03cf1d"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0190a1a3a2e5719b816d818eb196a8c2",
"_score": null,
"_source": {
"autoIncrement": 1834761.0,
"id": "0190a1a3a2e5719b816d818eb196a8c2"
},
"fields": {
"displayGroup": [
"774616f4f1c9142e6d86da48bc67ebc3"
]
},
"sort": [
0,
"0190a1a3a2e5719b816d818eb196a8c2"
]
}
]
},
"aggregations": {
"total-count": {
"value": 41
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
13.00 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":"018997d0242273cd81441519a0b46d58"}}}},{"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": 10,
"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": 482,
"rating": {
"value": 0.0
}
},
"price": {
"count": 482,
"min": 19.99,
"max": 56.0,
"avg": 40.625145228215764,
"sum": 19581.32
},
"options": {
"doc_count": 964,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "cca87ab4cab5470f85b32ce2b3269b1e",
"doc_count": 42
},
{
"key": "018d796752da71d4bc16000988e14500",
"doc_count": 36
},
{
"key": "018d7967562073d29d87ac0d1805a758",
"doc_count": 36
},
{
"key": "0190020586ce702ab69a9dbdbddfffac",
"doc_count": 36
},
{
"key": "a132823eaf34421c82c307567af7ec32",
"doc_count": 33
},
{
"key": "018d79675466735989015568610f58b3",
"doc_count": 31
},
{
"key": "b333e4fbe005414bb4cb752913be4b46",
"doc_count": 29
},
{
"key": "549603b6c17f42a595c6cd3e44675888",
"doc_count": 28
},
{
"key": "7189e238f66c4db8831ad403f65df75e",
"doc_count": 28
},
{
"key": "97610a9e8a0f4970a7be7eec0bac0378",
"doc_count": 28
},
{
"key": "d39074020fe54e79ab8a2c3c1db6c411",
"doc_count": 28
},
{
"key": "493cae969e0b4e75a2e4272d2a6fa240",
"doc_count": 27
},
{
"key": "a053c882e22f4d3e96fe143b7f870cc4",
"doc_count": 27
},
{
"key": "a5d7196c2514479f857621c32bb84608",
"doc_count": 27
},
{
"key": "b5a3d8c7138344dda67987a4eff4cb1c",
"doc_count": 27
},
{
"key": "c0088ccb433c49aaadfc61d1966f804c",
"doc_count": 27
},
{
"key": "13aa12d0ba23429a91307cd1c7ab8897",
"doc_count": 26
},
{
"key": "a9cad9e916b7460b887df2bcef6f7cae",
"doc_count": 26
},
{
"key": "7d02ec05b3f54d9aa4afe8e13731ce4c",
"doc_count": 25
},
{
"key": "0ce57e954af348fc877968b48409adc4",
"doc_count": 23
},
{
"key": "24e9a79fae5e4d58b20fd03ed636782c",
"doc_count": 22
},
{
"key": "649a663803e842b1a413e97fac062e26",
"doc_count": 22
},
{
"key": "3e6f2c0acacf4984a857b40c34a28d92",
"doc_count": 21
},
{
"key": "018d7967553a72ca97faf14b9d69a419",
"doc_count": 18
},
{
"key": "018dcc33a64b71ab9c8c86e74d17af5c",
"doc_count": 18
},
{
"key": "018dcc33c0187166a02cdee6223f4c39",
"doc_count": 18
},
{
"key": "018dcc33c29a701d90ce64a256851001",
"doc_count": 18
},
{
"key": "018dcc33caf570518d0894be78e37728",
"doc_count": 18
},
{
"key": "018dcc33cd29725e88c498df8bff7ea9",
"doc_count": 18
},
{
"key": "018dcc33d1f4700f9e35e85caff09a05",
"doc_count": 18
},
{
"key": "018dcc33e67c71119e1fea2ed6ce8db2",
"doc_count": 18
},
{
"key": "018dcc33ea727119a9be5b04adbd06a8",
"doc_count": 18
},
{
"key": "018dcc33ef3e71b98f00b79ebc1d3165",
"doc_count": 18
},
{
"key": "0190a0efc722732aa975d92e09a5aa69",
"doc_count": 18
},
{
"key": "b4bcc055f4b34f45ac8470f8a86812a3",
"doc_count": 18
},
{
"key": "01900205879f7248867868c412fc658d",
"doc_count": 16
},
{
"key": "a3c0ad99cd1742e485ac4f5f5773c6e0",
"doc_count": 13
},
{
"key": "ac41845e2c4d4fd0b3d810c2bc2b2424",
"doc_count": 12
},
{
"key": "018db35838f4716196f36dc1d5302554",
"doc_count": 8
},
{
"key": "2ed6465638e54c78a0b0210861947a6e",
"doc_count": 7
},
{
"key": "01909baa6cbc71deaaf0a7271455cdca",
"doc_count": 6
},
{
"key": "0818c1d6fd154fd88b414d5ab92d52a0",
"doc_count": 6
},
{
"key": "019091974b0f73d88d5927c8ac9dc0f6",
"doc_count": 3
},
{
"key": "3ded9781c61c4c91bc85327563d81658",
"doc_count": 3
},
{
"key": "018c6903773872409266c11b029009c9",
"doc_count": 2
},
{
"key": "7827356c7cce40bb96677fa33f721a63",
"doc_count": 2
},
{
"key": "018c69038764708789affe7ed0a20b95",
"doc_count": 1
},
{
"key": "018c6cf0f27272dc8f1d3a0479cc4115",
"doc_count": 1
},
{
"key": "01909baa89b470819369dfd6c3af4dd1",
"doc_count": 1
},
{
"key": "01909bab7d617134b996d1191f9ae602",
"doc_count": 1
},
{
"key": "019afb4baa7a4bb99438f94850b0bd02",
"doc_count": 1
},
{
"key": "219b1dbeeacf4fcdb2fe0e48b85b3259",
"doc_count": 1
},
{
"key": "29b5ae909a2044589870afe7895f5e2b",
"doc_count": 1
},
{
"key": "2b23b41398364461aff44e01c2f08c66",
"doc_count": 1
},
{
"key": "32379b13453543bf9d8e18506c4e2110",
"doc_count": 1
},
{
"key": "93fee3ed40e24fa69a3584d7c66bc340",
"doc_count": 1
},
{
"key": "9760cf0a61e341ab903176d3a3b4d027",
"doc_count": 1
},
{
"key": "97c628a763324e31ab19ad331303320f",
"doc_count": 1
},
{
"key": "b9098912ba704078bf6482acae250e23",
"doc_count": 1
},
{
"key": "cd6d4a10e77b48a2bc1b6b52f93330b1",
"doc_count": 1
},
{
"key": "cf7179d03f394a93ada8b8f065cab004",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 1623,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "018963e5f32b703288aad57690802852",
"doc_count": 415
},
{
"key": "0189641271d073e08b42a53d7da04b62",
"doc_count": 320
},
{
"key": "01896411e11071498f66a862f5383700",
"doc_count": 272
},
{
"key": "018963ea3aba7042895b047285c1402e",
"doc_count": 94
},
{
"key": "018963ea415c7217b4dc8cb62572ed16",
"doc_count": 73
},
{
"key": "01896411e3007292bbf291a9837a8cc8",
"doc_count": 64
},
{
"key": "01896411e3af718192fb7f9ee45ad6fb",
"doc_count": 44
},
{
"key": "018bbe146ffe71f5b995756cff67f838",
"doc_count": 42
},
{
"key": "018963ea20b670278236dc7103bcceb8",
"doc_count": 37
},
{
"key": "018963ea220370f6b3962a1108942bae",
"doc_count": 36
},
{
"key": "0190a6bca60c70d6979f3a69eb39a7e8",
"doc_count": 36
},
{
"key": "018963e5f13871739bde1b0eb26bb21b",
"doc_count": 32
},
{
"key": "018963e5f53b7292b003bf6803f624b7",
"doc_count": 23
},
{
"key": "018963ea2bce70d7876c75f434e017d1",
"doc_count": 20
},
{
"key": "01896412d947725f982fc682b748509d",
"doc_count": 20
},
{
"key": "018963ea1812737fb7f416641565cd24",
"doc_count": 18
},
{
"key": "018963ea26b971f09527dfc7f4930323",
"doc_count": 18
},
{
"key": "018963ea336b7003ba1d74549036192d",
"doc_count": 18
},
{
"key": "018bbe13b7757294bf18b34533cada9d",
"doc_count": 18
},
{
"key": "018dcc3373f47133833772ee8dfc3fe4",
"doc_count": 12
},
{
"key": "018963e5f06f716dadb0fe95b3c53d22",
"doc_count": 1
},
{
"key": "018963ea1a0071e3b903843432a2818e",
"doc_count": 1
},
{
"key": "01896411def07326a9a675aa2efc40ea",
"doc_count": 1
},
{
"key": "01896411e78a73399a29ed714246da0d",
"doc_count": 1
},
{
"key": "01896412786e7099a0193539ac67a018",
"doc_count": 1
},
{
"key": "018bbe14735f7284ba6d5630b0de21d1",
"doc_count": 1
},
{
"key": "018bbe147614712bb735c9a8d2d50799",
"doc_count": 1
},
{
"key": "018c1b62bb0472019ea8c10c63014d4e",
"doc_count": 1
},
{
"key": "018e197a6eb2725f987d52032d641c4e",
"doc_count": 1
},
{
"key": "018f05bda7ca735faaff8f84c963cd06",
"doc_count": 1
},
{
"key": "0190a7459fd770b89e174cd975f7aa4a",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "57f85a1341f34ad284dc91714711a009",
"doc_count": 459
},
{
"key": "d8ac016c293145ff9d20f96184a4ad02",
"doc_count": 12
},
{
"key": "9cdb250390f640078ffc3e4e8ed2e543",
"doc_count": 8
},
{
"key": "6f10e4ac0c444f1a91667bad688d924f",
"doc_count": 3
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|