| 1 |
8.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":"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": 6,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 99,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_all4team_product_1716336301",
"_id": "018af47c7d1572a88996e8d6a05402df",
"_score": null,
"_source": {
"autoIncrement": 1133293.0,
"id": "018af47c7d1572a88996e8d6a05402df"
},
"fields": {
"displayGroup": [
"a62edabf884bd829c9c93efadb2f4c43"
]
},
"sort": [
0,
"018af47c7d1572a88996e8d6a05402df"
]
},
{
"_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": "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": "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"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01912c7efeb57192a9a9650b5f9f071f",
"_score": null,
"_source": {
"autoIncrement": 1846256.0,
"id": "01912c7efeb57192a9a9650b5f9f071f"
},
"fields": {
"displayGroup": [
"095220b26cd7400d55b9ca820e7d5c40"
]
},
"sort": [
0,
"01912c7efeb57192a9a9650b5f9f071f"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "1424268adb57497384708e7625d2fd38",
"_score": null,
"_source": {
"autoIncrement": 1130445.0,
"id": "1424268adb57497384708e7625d2fd38"
},
"fields": {
"displayGroup": [
"614c6b6c70b33bdc41114bc9ae905da7"
]
},
"sort": [
0,
"1424268adb57497384708e7625d2fd38"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "9ba7e00694e94180818a9b24f27a8a94",
"_score": null,
"_source": {
"autoIncrement": 1130554.0,
"id": "9ba7e00694e94180818a9b24f27a8a94"
},
"fields": {
"displayGroup": [
"f6e0d1a8124a3dcc46cb1b0a2a785bc9"
]
},
"sort": [
0,
"9ba7e00694e94180818a9b24f27a8a94"
]
}
]
},
"aggregations": {
"total-count": {
"value": 15
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
7.17 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": 5,
"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": 99,
"rating": {
"value": 0.0
}
},
"price": {
"count": 99,
"min": 19.99,
"max": 51.96,
"avg": 36.431111111111115,
"sum": 3606.6800000000003
},
"options": {
"doc_count": 198,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "0190020586ce702ab69a9dbdbddfffac",
"doc_count": 36
},
{
"key": "018d796752da71d4bc16000988e14500",
"doc_count": 18
},
{
"key": "0190a0efc722732aa975d92e09a5aa69",
"doc_count": 18
},
{
"key": "018db35838f4716196f36dc1d5302554",
"doc_count": 8
},
{
"key": "01909baa6cbc71deaaf0a7271455cdca",
"doc_count": 6
},
{
"key": "7189e238f66c4db8831ad403f65df75e",
"doc_count": 6
},
{
"key": "97610a9e8a0f4970a7be7eec0bac0378",
"doc_count": 6
},
{
"key": "a132823eaf34421c82c307567af7ec32",
"doc_count": 6
},
{
"key": "a5d7196c2514479f857621c32bb84608",
"doc_count": 6
},
{
"key": "b5a3d8c7138344dda67987a4eff4cb1c",
"doc_count": 6
},
{
"key": "d39074020fe54e79ab8a2c3c1db6c411",
"doc_count": 6
},
{
"key": "13aa12d0ba23429a91307cd1c7ab8897",
"doc_count": 5
},
{
"key": "493cae969e0b4e75a2e4272d2a6fa240",
"doc_count": 5
},
{
"key": "549603b6c17f42a595c6cd3e44675888",
"doc_count": 5
},
{
"key": "649a663803e842b1a413e97fac062e26",
"doc_count": 5
},
{
"key": "a053c882e22f4d3e96fe143b7f870cc4",
"doc_count": 5
},
{
"key": "a9cad9e916b7460b887df2bcef6f7cae",
"doc_count": 5
},
{
"key": "c0088ccb433c49aaadfc61d1966f804c",
"doc_count": 5
},
{
"key": "0ce57e954af348fc877968b48409adc4",
"doc_count": 4
},
{
"key": "24e9a79fae5e4d58b20fd03ed636782c",
"doc_count": 4
},
{
"key": "3e6f2c0acacf4984a857b40c34a28d92",
"doc_count": 4
},
{
"key": "7d02ec05b3f54d9aa4afe8e13731ce4c",
"doc_count": 4
},
{
"key": "b333e4fbe005414bb4cb752913be4b46",
"doc_count": 4
},
{
"key": "019091974b0f73d88d5927c8ac9dc0f6",
"doc_count": 3
},
{
"key": "018c6903773872409266c11b029009c9",
"doc_count": 2
},
{
"key": "ac41845e2c4d4fd0b3d810c2bc2b2424",
"doc_count": 2
},
{
"key": "018c69038764708789affe7ed0a20b95",
"doc_count": 1
},
{
"key": "018c6cf0f27272dc8f1d3a0479cc4115",
"doc_count": 1
},
{
"key": "01909baa89b470819369dfd6c3af4dd1",
"doc_count": 1
},
{
"key": "01909bab7d617134b996d1191f9ae602",
"doc_count": 1
},
{
"key": "219b1dbeeacf4fcdb2fe0e48b85b3259",
"doc_count": 1
},
{
"key": "29b5ae909a2044589870afe7895f5e2b",
"doc_count": 1
},
{
"key": "32379b13453543bf9d8e18506c4e2110",
"doc_count": 1
},
{
"key": "93fee3ed40e24fa69a3584d7c66bc340",
"doc_count": 1
},
{
"key": "97c628a763324e31ab19ad331303320f",
"doc_count": 1
},
{
"key": "a3c0ad99cd1742e485ac4f5f5773c6e0",
"doc_count": 1
},
{
"key": "b4bcc055f4b34f45ac8470f8a86812a3",
"doc_count": 1
},
{
"key": "b9098912ba704078bf6482acae250e23",
"doc_count": 1
},
{
"key": "cd6d4a10e77b48a2bc1b6b52f93330b1",
"doc_count": 1
},
{
"key": "cf7179d03f394a93ada8b8f065cab004",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 417,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "018963e5f32b703288aad57690802852",
"doc_count": 95
},
{
"key": "0189641271d073e08b42a53d7da04b62",
"doc_count": 86
},
{
"key": "01896411e3007292bbf291a9837a8cc8",
"doc_count": 64
},
{
"key": "018963ea3aba7042895b047285c1402e",
"doc_count": 45
},
{
"key": "018963ea415c7217b4dc8cb62572ed16",
"doc_count": 37
},
{
"key": "01896411e3af718192fb7f9ee45ad6fb",
"doc_count": 27
},
{
"key": "018bbe146ffe71f5b995756cff67f838",
"doc_count": 26
},
{
"key": "01896411e11071498f66a862f5383700",
"doc_count": 18
},
{
"key": "018dcc3373f47133833772ee8dfc3fe4",
"doc_count": 12
},
{
"key": "018963e5f53b7292b003bf6803f624b7",
"doc_count": 4
},
{
"key": "018963ea1a0071e3b903843432a2818e",
"doc_count": 1
},
{
"key": "018963ea20b670278236dc7103bcceb8",
"doc_count": 1
},
{
"key": "01896412786e7099a0193539ac67a018",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "57f85a1341f34ad284dc91714711a009",
"doc_count": 76
},
{
"key": "d8ac016c293145ff9d20f96184a4ad02",
"doc_count": 12
},
{
"key": "9cdb250390f640078ffc3e4e8ed2e543",
"doc_count": 8
},
{
"key": "6f10e4ac0c444f1a91667bad688d924f",
"doc_count": 3
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|