| 1 |
525.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":"018b1e88c28e70dcb3728310b0202f6d"}}}},{"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": 522,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 465,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_all4team_product_1716336301",
"_id": "018ce287fe0a72d49ffc07ea1a56c8ef",
"_score": null,
"_source": {
"autoIncrement": 1233849.0,
"id": "018ce287fe0a72d49ffc07ea1a56c8ef"
},
"fields": {
"displayGroup": [
"35f28cf4436e2bae163542ff51e114eb"
]
},
"sort": [
0,
"018ce287fe0a72d49ffc07ea1a56c8ef"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d1369879672758c5898dedf441799",
"_score": null,
"_source": {
"autoIncrement": 1250412.0,
"id": "018d1369879672758c5898dedf441799"
},
"fields": {
"displayGroup": [
"0df04e34a51d73d8c66a71af9ddf876a"
]
},
"sort": [
0,
"018d1369879672758c5898dedf441799"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d896e19bf72208925cdc0e0a9cea2",
"_score": null,
"_source": {
"autoIncrement": 1277909.0,
"id": "018d896e19bf72208925cdc0e0a9cea2"
},
"fields": {
"displayGroup": [
"1f0b5ba934e208dc651023f4241d6efe"
]
},
"sort": [
0,
"018d896e19bf72208925cdc0e0a9cea2"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d9922b9ce7379aa638c2316bbd84f",
"_score": null,
"_source": {
"autoIncrement": 1293236.0,
"id": "018d9922b9ce7379aa638c2316bbd84f"
},
"fields": {
"displayGroup": [
"045e9c9177a85990399bec1aabdfddf3"
]
},
"sort": [
0,
"018d9922b9ce7379aa638c2316bbd84f"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d9937283c72668be27fe8b3325dd1",
"_score": null,
"_source": {
"autoIncrement": 1293415.0,
"id": "018d9937283c72668be27fe8b3325dd1"
},
"fields": {
"displayGroup": [
"ba654568e1d4a9c33c01b5fad2463353"
]
},
"sort": [
0,
"018d9937283c72668be27fe8b3325dd1"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018daa218e1370c1ba87394941cf937a",
"_score": null,
"_source": {
"autoIncrement": 1309467.0,
"id": "018daa218e1370c1ba87394941cf937a"
},
"fields": {
"displayGroup": [
"ee5818282cee1ec099bfe63aa518e5f4"
]
},
"sort": [
0,
"018daa218e1370c1ba87394941cf937a"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01907320863470658830e7a2670e567b",
"_score": null,
"_source": {
"autoIncrement": 1808723.0,
"id": "01907320863470658830e7a2670e567b"
},
"fields": {
"displayGroup": [
"74aaef2cfbe666653f4b9836cec9b1ad"
]
},
"sort": [
0,
"01907320863470658830e7a2670e567b"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01907320a56370b99a773f13cd4988bb",
"_score": null,
"_source": {
"autoIncrement": 1808728.0,
"id": "01907320a56370b99a773f13cd4988bb"
},
"fields": {
"displayGroup": [
"1413c60f27d4e679556e92708439b0c1"
]
},
"sort": [
0,
"01907320a56370b99a773f13cd4988bb"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01907320e99071c289e4de0dc27f2af9",
"_score": null,
"_source": {
"autoIncrement": 1808756.0,
"id": "01907320e99071c289e4de0dc27f2af9"
},
"fields": {
"displayGroup": [
"e8f8f979249a1adad02a5b9e11bb59fd"
]
},
"sort": [
0,
"01907320e99071c289e4de0dc27f2af9"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0190732119e873f2adf4438d368a6b89",
"_score": null,
"_source": {
"autoIncrement": 1808766.0,
"id": "0190732119e873f2adf4438d368a6b89"
},
"fields": {
"displayGroup": [
"db4a6340b87a426b8c48d9c6d42efa93"
]
},
"sort": [
0,
"0190732119e873f2adf4438d368a6b89"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0190732148407158a46fb497390a06bc",
"_score": null,
"_source": {
"autoIncrement": 1808770.0,
"id": "0190732148407158a46fb497390a06bc"
},
"fields": {
"displayGroup": [
"03e0f1e374dc71462f6352dfc6ac21b5"
]
},
"sort": [
0,
"0190732148407158a46fb497390a06bc"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01909c50db877374a9756822c939eca8",
"_score": null,
"_source": {
"autoIncrement": 1825632.0,
"id": "01909c50db877374a9756822c939eca8"
},
"fields": {
"displayGroup": [
"5c2f60c9e45a5e9b647473734bdac853"
]
},
"sort": [
0,
"01909c50db877374a9756822c939eca8"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0190a6d29b8f703f9a563e7340ac4029",
"_score": null,
"_source": {
"autoIncrement": 1836499.0,
"id": "0190a6d29b8f703f9a563e7340ac4029"
},
"fields": {
"displayGroup": [
"9ae68a3efb8ffcaf71de1e16c4bde671"
]
},
"sort": [
0,
"0190a6d29b8f703f9a563e7340ac4029"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0190a6d300597085a92ffef0661373f2",
"_score": null,
"_source": {
"autoIncrement": 1836557.0,
"id": "0190a6d300597085a92ffef0661373f2"
},
"fields": {
"displayGroup": [
"3599feee850b3c4cc3ff245df4f4914d"
]
},
"sort": [
0,
"0190a6d300597085a92ffef0661373f2"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0190a6d431e7723ab86d2ad547b6bf36",
"_score": null,
"_source": {
"autoIncrement": 1836722.0,
"id": "0190a6d431e7723ab86d2ad547b6bf36"
},
"fields": {
"displayGroup": [
"f055f6ef9e3c091063835cdcfa95b0dd"
]
},
"sort": [
0,
"0190a6d431e7723ab86d2ad547b6bf36"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0190a6d9d1a972abb19ccef7243eb9e3",
"_score": null,
"_source": {
"autoIncrement": 1837520.0,
"id": "0190a6d9d1a972abb19ccef7243eb9e3"
},
"fields": {
"displayGroup": [
"cf825d21792af172dc0d8b268f6b3f20"
]
},
"sort": [
0,
"0190a6d9d1a972abb19ccef7243eb9e3"
]
}
]
},
"aggregations": {
"total-count": {
"value": 34
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
11.55 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":"018b1e88c28e70dcb3728310b0202f6d"}}}},{"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": 465,
"rating": {
"value": 0.0
}
},
"price": {
"count": 465,
"min": 27.99,
"max": 60.0,
"avg": 46.400408602150534,
"sum": 21576.19
},
"options": {
"doc_count": 930,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "018d79675466735989015568610f58b3",
"doc_count": 76
},
{
"key": "018dcc33f84c71f49a5cfac761b33f39",
"doc_count": 72
},
{
"key": "018dcc33ef3e71b98f00b79ebc1d3165",
"doc_count": 54
},
{
"key": "018d7967562073d29d87ac0d1805a758",
"doc_count": 53
},
{
"key": "c2d0a920e328481db842b8da42b54bc1",
"doc_count": 36
},
{
"key": "018d7967553a72ca97faf14b9d69a419",
"doc_count": 35
},
{
"key": "018dcc33d1f4700f9e35e85caff09a05",
"doc_count": 35
},
{
"key": "13aa12d0ba23429a91307cd1c7ab8897",
"doc_count": 29
},
{
"key": "549603b6c17f42a595c6cd3e44675888",
"doc_count": 28
},
{
"key": "7d02ec05b3f54d9aa4afe8e13731ce4c",
"doc_count": 28
},
{
"key": "a053c882e22f4d3e96fe143b7f870cc4",
"doc_count": 27
},
{
"key": "a9cad9e916b7460b887df2bcef6f7cae",
"doc_count": 27
},
{
"key": "b333e4fbe005414bb4cb752913be4b46",
"doc_count": 27
},
{
"key": "d39074020fe54e79ab8a2c3c1db6c411",
"doc_count": 26
},
{
"key": "493cae969e0b4e75a2e4272d2a6fa240",
"doc_count": 25
},
{
"key": "649a663803e842b1a413e97fac062e26",
"doc_count": 23
},
{
"key": "97610a9e8a0f4970a7be7eec0bac0378",
"doc_count": 23
},
{
"key": "a132823eaf34421c82c307567af7ec32",
"doc_count": 23
},
{
"key": "a5d7196c2514479f857621c32bb84608",
"doc_count": 23
},
{
"key": "b5a3d8c7138344dda67987a4eff4cb1c",
"doc_count": 23
},
{
"key": "c0088ccb433c49aaadfc61d1966f804c",
"doc_count": 23
},
{
"key": "018b6a9f6a7b7345bcf7865560e3a2f6",
"doc_count": 22
},
{
"key": "0ce57e954af348fc877968b48409adc4",
"doc_count": 22
},
{
"key": "24e9a79fae5e4d58b20fd03ed636782c",
"doc_count": 22
},
{
"key": "7189e238f66c4db8831ad403f65df75e",
"doc_count": 22
},
{
"key": "3e6f2c0acacf4984a857b40c34a28d92",
"doc_count": 21
},
{
"key": "018d796752da71d4bc16000988e14500",
"doc_count": 18
},
{
"key": "018dcc33e46a716389ec321e2e2e86ab",
"doc_count": 18
},
{
"key": "be28c3ef2f744318a13f72f200abfc9a",
"doc_count": 8
},
{
"key": "018d8d9938fa72e5b1d413ab8427febc",
"doc_count": 6
},
{
"key": "0e960fe2c23e49478ba05ff39f5e7eeb",
"doc_count": 6
},
{
"key": "011ff954f597497aad9ff53c419d3afd",
"doc_count": 5
},
{
"key": "018c690369a9714988c0ae7e113fee13",
"doc_count": 5
},
{
"key": "749c25bad2ce4820be84bc4e494c8646",
"doc_count": 5
},
{
"key": "0ba48fdc65a64eaca8fb2faa0f87861f",
"doc_count": 4
},
{
"key": "21d23887998c46edafa7d3eb2b3116d6",
"doc_count": 4
},
{
"key": "cf7179d03f394a93ada8b8f065cab004",
"doc_count": 4
},
{
"key": "29b5ae909a2044589870afe7895f5e2b",
"doc_count": 3
},
{
"key": "d01cd56ccf1947759efccca469cb7cad",
"doc_count": 3
},
{
"key": "01909baa6cbc71deaaf0a7271455cdca",
"doc_count": 2
},
{
"key": "1239d8c2b0774f95bec8ca2120ad7876",
"doc_count": 2
},
{
"key": "49a6fc05cfec41919f75c6ad63c4bd7e",
"doc_count": 2
},
{
"key": "93fee3ed40e24fa69a3584d7c66bc340",
"doc_count": 2
},
{
"key": "dff453c781a343db802aba3434932eb3",
"doc_count": 2
},
{
"key": "018dcc34018170a3ae6c2411ee6a0607",
"doc_count": 1
},
{
"key": "018dcc3403977271b8d95041e23f1108",
"doc_count": 1
},
{
"key": "01909baa4d9072658b9722deb8eea0a6",
"doc_count": 1
},
{
"key": "32379b13453543bf9d8e18506c4e2110",
"doc_count": 1
},
{
"key": "8c323a5d6d694f269bf15944f4817031",
"doc_count": 1
},
{
"key": "a1b16c0b889547219de3c5a29864a17b",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 1633,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "018964127310726584383deb5cc336f8",
"doc_count": 384
},
{
"key": "018963e5f32b703288aad57690802852",
"doc_count": 357
},
{
"key": "01896411e11071498f66a862f5383700",
"doc_count": 308
},
{
"key": "018963ea20b670278236dc7103bcceb8",
"doc_count": 130
},
{
"key": "018963ea3aba7042895b047285c1402e",
"doc_count": 120
},
{
"key": "018963e5f53b7292b003bf6803f624b7",
"doc_count": 81
},
{
"key": "018963ea336b7003ba1d74549036192d",
"doc_count": 54
},
{
"key": "018963ea1812737fb7f416641565cd24",
"doc_count": 37
},
{
"key": "018ae9d2bdd473c88477b20ff8be8bb8",
"doc_count": 36
},
{
"key": "01896411e3007292bbf291a9837a8cc8",
"doc_count": 35
},
{
"key": "018963e5f5e173a4afde33792d6fe12f",
"doc_count": 21
},
{
"key": "018963ea1a0071e3b903843432a2818e",
"doc_count": 18
},
{
"key": "0190a6bca60c70d6979f3a69eb39a7e8",
"doc_count": 18
},
{
"key": "018bbe13b7757294bf18b34533cada9d",
"doc_count": 17
},
{
"key": "018963ea3964707fbbfb35b2b8e8084b",
"doc_count": 5
},
{
"key": "018963e5f06f716dadb0fe95b3c53d22",
"doc_count": 1
},
{
"key": "018963e5f13871739bde1b0eb26bb21b",
"doc_count": 1
},
{
"key": "01896411def07326a9a675aa2efc40ea",
"doc_count": 1
},
{
"key": "01896411e3af718192fb7f9ee45ad6fb",
"doc_count": 1
},
{
"key": "01896411e78a73399a29ed714246da0d",
"doc_count": 1
},
{
"key": "018bbe13c29d7030b84ca02c030b4e39",
"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": 404
},
{
"key": "1a0ffc50b3584a1abd28c2d06d6c6465",
"doc_count": 31
},
{
"key": "1cadc079599b4e0386adc59541691ef7",
"doc_count": 22
},
{
"key": "d8ac016c293145ff9d20f96184a4ad02",
"doc_count": 8
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|