| 1 |
891.89 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":"018997fd5a94727bb15810ca3090fb16"}}}},{"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": 890,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 185,
"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": "018bd029c220719e898bfd245dd5fe36",
"_score": null,
"_source": {
"autoIncrement": 1136293.0,
"id": "018bd029c220719e898bfd245dd5fe36"
},
"fields": {
"displayGroup": [
"b56971103c9ea06caf2d55207faf4184"
]
},
"sort": [
0,
"018bd029c220719e898bfd245dd5fe36"
]
},
{
"_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": "018cd04310b273f6914d7eef1ce5f25e",
"_score": null,
"_source": {
"autoIncrement": 1223300.0,
"id": "018cd04310b273f6914d7eef1ce5f25e"
},
"fields": {
"displayGroup": [
"83a98443b8ce7f3e475ce716fd837a64"
]
},
"sort": [
0,
"018cd04310b273f6914d7eef1ce5f25e"
]
},
{
"_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": "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": "018d1bace88e7252a735108e660cd751",
"_score": null,
"_source": {
"autoIncrement": 1253701.0,
"id": "018d1bace88e7252a735108e660cd751"
},
"fields": {
"displayGroup": [
"58b932811559b24e1e6262daffb64ad1"
]
},
"sort": [
0,
"018d1bace88e7252a735108e660cd751"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d798d76ad71fd84dc00be0ecf778c",
"_score": null,
"_source": {
"autoIncrement": 1273651.0,
"id": "018d798d76ad71fd84dc00be0ecf778c"
},
"fields": {
"displayGroup": [
"77adbc5eb8e709dc9be36cf9a2334e51"
]
},
"sort": [
0,
"018d798d76ad71fd84dc00be0ecf778c"
]
},
{
"_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": "018d99048458734fa41ff46cd3455329",
"_score": null,
"_source": {
"autoIncrement": 1292835.0,
"id": "018d99048458734fa41ff46cd3455329"
},
"fields": {
"displayGroup": [
"8815c51c296719b8d15ab408584f17e5"
]
},
"sort": [
0,
"018d99048458734fa41ff46cd3455329"
]
},
{
"_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": "018dc0c6e7a7706da7e2e3d552a7e150",
"_score": null,
"_source": {
"autoIncrement": 1318116.0,
"id": "018dc0c6e7a7706da7e2e3d552a7e150"
},
"fields": {
"displayGroup": [
"047ec815d8fb92c820df0ec837f0ac02"
]
},
"sort": [
0,
"018dc0c6e7a7706da7e2e3d552a7e150"
]
},
{
"_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"
]
}
]
},
"aggregations": {
"total-count": {
"value": 34
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
19.15 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":"018997fd5a94727bb15810ca3090fb16"}}}},{"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": 17,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"max_score": null,
"hits": []
},
"aggregations": {
"shipping-free-filter": {
"doc_count": 1,
"shipping-free": {
"value": 1.0,
"value_as_string": "true"
}
},
"rating-exists": {
"doc_count": 185,
"rating": {
"value": 0.0
}
},
"price": {
"count": 185,
"min": 19.99,
"max": 87.96,
"avg": 38.654378378378375,
"sum": 7151.0599999999995
},
"options": {
"doc_count": 370,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "0190020586ce702ab69a9dbdbddfffac",
"doc_count": 36
},
{
"key": "01909baa6cbc71deaaf0a7271455cdca",
"doc_count": 22
},
{
"key": "018b6a9f6a7b7345bcf7865560e3a2f6",
"doc_count": 20
},
{
"key": "018d796752da71d4bc16000988e14500",
"doc_count": 18
},
{
"key": "0190a0efc722732aa975d92e09a5aa69",
"doc_count": 18
},
{
"key": "13aa12d0ba23429a91307cd1c7ab8897",
"doc_count": 12
},
{
"key": "7189e238f66c4db8831ad403f65df75e",
"doc_count": 12
},
{
"key": "a5d7196c2514479f857621c32bb84608",
"doc_count": 11
},
{
"key": "01909baa289473c988f5798b39a2ba9c",
"doc_count": 10
},
{
"key": "97610a9e8a0f4970a7be7eec0bac0378",
"doc_count": 10
},
{
"key": "493cae969e0b4e75a2e4272d2a6fa240",
"doc_count": 9
},
{
"key": "549603b6c17f42a595c6cd3e44675888",
"doc_count": 9
},
{
"key": "7d02ec05b3f54d9aa4afe8e13731ce4c",
"doc_count": 9
},
{
"key": "a132823eaf34421c82c307567af7ec32",
"doc_count": 9
},
{
"key": "a9cad9e916b7460b887df2bcef6f7cae",
"doc_count": 9
},
{
"key": "b5a3d8c7138344dda67987a4eff4cb1c",
"doc_count": 9
},
{
"key": "d39074020fe54e79ab8a2c3c1db6c411",
"doc_count": 9
},
{
"key": "018db35838f4716196f36dc1d5302554",
"doc_count": 8
},
{
"key": "c0088ccb433c49aaadfc61d1966f804c",
"doc_count": 8
},
{
"key": "a053c882e22f4d3e96fe143b7f870cc4",
"doc_count": 7
},
{
"key": "b333e4fbe005414bb4cb752913be4b46",
"doc_count": 7
},
{
"key": "be28c3ef2f744318a13f72f200abfc9a",
"doc_count": 7
},
{
"key": "018c690369a9714988c0ae7e113fee13",
"doc_count": 6
},
{
"key": "649a663803e842b1a413e97fac062e26",
"doc_count": 5
},
{
"key": "749c25bad2ce4820be84bc4e494c8646",
"doc_count": 5
},
{
"key": "011ff954f597497aad9ff53c419d3afd",
"doc_count": 4
},
{
"key": "01909baa4d9072658b9722deb8eea0a6",
"doc_count": 4
},
{
"key": "0ce57e954af348fc877968b48409adc4",
"doc_count": 4
},
{
"key": "1239d8c2b0774f95bec8ca2120ad7876",
"doc_count": 4
},
{
"key": "24e9a79fae5e4d58b20fd03ed636782c",
"doc_count": 4
},
{
"key": "29b5ae909a2044589870afe7895f5e2b",
"doc_count": 4
},
{
"key": "3e6f2c0acacf4984a857b40c34a28d92",
"doc_count": 4
},
{
"key": "cf7179d03f394a93ada8b8f065cab004",
"doc_count": 4
},
{
"key": "018c6903773872409266c11b029009c9",
"doc_count": 3
},
{
"key": "019091974b0f73d88d5927c8ac9dc0f6",
"doc_count": 3
},
{
"key": "32379b13453543bf9d8e18506c4e2110",
"doc_count": 3
},
{
"key": "a1b16c0b889547219de3c5a29864a17b",
"doc_count": 3
},
{
"key": "d01cd56ccf1947759efccca469cb7cad",
"doc_count": 3
},
{
"key": "018c69038764708789affe7ed0a20b95",
"doc_count": 2
},
{
"key": "0ba48fdc65a64eaca8fb2faa0f87861f",
"doc_count": 2
},
{
"key": "21d23887998c46edafa7d3eb2b3116d6",
"doc_count": 2
},
{
"key": "2583d76ffb214c698f2349408c44cb61",
"doc_count": 2
},
{
"key": "62e1f91b41a448959bdf7061be0480d9",
"doc_count": 2
},
{
"key": "6baf2833d657438ab806b77e54b3f17a",
"doc_count": 2
},
{
"key": "93fee3ed40e24fa69a3584d7c66bc340",
"doc_count": 2
},
{
"key": "ac41845e2c4d4fd0b3d810c2bc2b2424",
"doc_count": 2
},
{
"key": "c387c84465444c94b5ccef204f837adf",
"doc_count": 2
},
{
"key": "dff453c781a343db802aba3434932eb3",
"doc_count": 2
},
{
"key": "018c6cf0f27272dc8f1d3a0479cc4115",
"doc_count": 1
},
{
"key": "018d7967c91c71f49a7f42a2fe7a5099",
"doc_count": 1
},
{
"key": "018d7967f3bd70adb1f3840f90880f22",
"doc_count": 1
},
{
"key": "018d8d9938fa72e5b1d413ab8427febc",
"doc_count": 1
},
{
"key": "01909baa7787700aa1a69f48d387f0d4",
"doc_count": 1
},
{
"key": "01909baa89b470819369dfd6c3af4dd1",
"doc_count": 1
},
{
"key": "01909bab7d617134b996d1191f9ae602",
"doc_count": 1
},
{
"key": "0b2b79c9ecbd4a9586ee38b2cb6caf9c",
"doc_count": 1
},
{
"key": "219b1dbeeacf4fcdb2fe0e48b85b3259",
"doc_count": 1
},
{
"key": "25148b6f5f0d491d8c6f8797b4c6543d",
"doc_count": 1
},
{
"key": "30bb2cef2b2d4afeb0e77bed6ac48d29",
"doc_count": 1
},
{
"key": "49a6fc05cfec41919f75c6ad63c4bd7e",
"doc_count": 1
},
{
"key": "97c628a763324e31ab19ad331303320f",
"doc_count": 1
},
{
"key": "a3c0ad99cd1742e485ac4f5f5773c6e0",
"doc_count": 1
},
{
"key": "b4bcc055f4b34f45ac8470f8a86812a3",
"doc_count": 1
},
{
"key": "b9098912ba704078bf6482acae250e23",
"doc_count": 1
},
{
"key": "c36af3803d914e8bb422246a1b400a68",
"doc_count": 1
},
{
"key": "cd6d4a10e77b48a2bc1b6b52f93330b1",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 707,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "018963e5f32b703288aad57690802852",
"doc_count": 136
},
{
"key": "01896411e3007292bbf291a9837a8cc8",
"doc_count": 124
},
{
"key": "018963ea3aba7042895b047285c1402e",
"doc_count": 93
},
{
"key": "0189641271d073e08b42a53d7da04b62",
"doc_count": 86
},
{
"key": "018963ea415c7217b4dc8cb62572ed16",
"doc_count": 42
},
{
"key": "018964127310726584383deb5cc336f8",
"doc_count": 37
},
{
"key": "018963e5f53b7292b003bf6803f624b7",
"doc_count": 33
},
{
"key": "01896412751a72d6bee9f7d197ea92d6",
"doc_count": 32
},
{
"key": "01896411e3af718192fb7f9ee45ad6fb",
"doc_count": 28
},
{
"key": "018bbe146ffe71f5b995756cff67f838",
"doc_count": 26
},
{
"key": "01896411e11071498f66a862f5383700",
"doc_count": 18
},
{
"key": "018963e5f5e173a4afde33792d6fe12f",
"doc_count": 14
},
{
"key": "018dcc3373f47133833772ee8dfc3fe4",
"doc_count": 12
},
{
"key": "018963ea1812737fb7f416641565cd24",
"doc_count": 5
},
{
"key": "018963ea20b670278236dc7103bcceb8",
"doc_count": 5
},
{
"key": "018963ea3964707fbbfb35b2b8e8084b",
"doc_count": 5
},
{
"key": "018963e5f13871739bde1b0eb26bb21b",
"doc_count": 2
},
{
"key": "01896411e4587305baecfc84ebf67bc3",
"doc_count": 2
},
{
"key": "018964127d2f70199be2f899e07364a1",
"doc_count": 2
},
{
"key": "018963ea1a0071e3b903843432a2818e",
"doc_count": 1
},
{
"key": "018963ea3609712896e2d21c3a2d91ab",
"doc_count": 1
},
{
"key": "01896412786e7099a0193539ac67a018",
"doc_count": 1
},
{
"key": "018bbe13c29d7030b84ca02c030b4e39",
"doc_count": 1
},
{
"key": "018bbe147153736fbaa17cb7d91264a8",
"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": 55
},
{
"key": "1a0ffc50b3584a1abd28c2d06d6c6465",
"doc_count": 23
},
{
"key": "1cadc079599b4e0386adc59541691ef7",
"doc_count": 20
},
{
"key": "9cdb250390f640078ffc3e4e8ed2e543",
"doc_count": 8
},
{
"key": "6f10e4ac0c444f1a91667bad688d924f",
"doc_count": 3
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|