| 1 |
1041.45 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":"0189981e780e73f38ce2d27989c15fa4"}}}},{"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": 1038,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 402,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7e8f230173c4951ea1c957286968",
"_score": null,
"_source": {
"autoIncrement": 1150743.0,
"id": "018c7e8f230173c4951ea1c957286968"
},
"fields": {
"displayGroup": [
"f299f002a84170acb271b7c46432da37"
]
},
"sort": [
0,
"018c7e8f230173c4951ea1c957286968"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7e8f92b87219830fcdd7b5d9df47",
"_score": null,
"_source": {
"autoIncrement": 1150767.0,
"id": "018c7e8f92b87219830fcdd7b5d9df47"
},
"fields": {
"displayGroup": [
"5912df248ed521a46151601302b6b18d"
]
},
"sort": [
0,
"018c7e8f92b87219830fcdd7b5d9df47"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018ce3687f6e701284f58755dbff6041",
"_score": null,
"_source": {
"autoIncrement": 1234797.0,
"id": "018ce3687f6e701284f58755dbff6041"
},
"fields": {
"displayGroup": [
"4f8fa217d211b8d86afeb8a95d5fcb7d"
]
},
"sort": [
0,
"018ce3687f6e701284f58755dbff6041"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018ce36f2a607207908d91bcf1317337",
"_score": null,
"_source": {
"autoIncrement": 1234857.0,
"id": "018ce36f2a607207908d91bcf1317337"
},
"fields": {
"displayGroup": [
"db262420c0da2f9807429d2d1b588156"
]
},
"sort": [
0,
"018ce36f2a607207908d91bcf1317337"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018ce36fafd071eeae1ea16ff50f07f2",
"_score": null,
"_source": {
"autoIncrement": 1234861.0,
"id": "018ce36fafd071eeae1ea16ff50f07f2"
},
"fields": {
"displayGroup": [
"f47aed4d565294f1988d7dbe8e05f87d"
]
},
"sort": [
0,
"018ce36fafd071eeae1ea16ff50f07f2"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018ce3735c8c7372b1bc66ed1f532dc6",
"_score": null,
"_source": {
"autoIncrement": 1234892.0,
"id": "018ce3735c8c7372b1bc66ed1f532dc6"
},
"fields": {
"displayGroup": [
"c6334f9cef35ddcee8f32f68101bf59a"
]
},
"sort": [
0,
"018ce3735c8c7372b1bc66ed1f532dc6"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018ce5a7ae8e7014a2324ba76e7debca",
"_score": null,
"_source": {
"autoIncrement": 1237216.0,
"id": "018ce5a7ae8e7014a2324ba76e7debca"
},
"fields": {
"displayGroup": [
"8fe5466898f5c3e8f8a6ca1ca8dbd93a"
]
},
"sort": [
0,
"018ce5a7ae8e7014a2324ba76e7debca"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d1342795471cc843dd5bb764af357",
"_score": null,
"_source": {
"autoIncrement": 1250082.0,
"id": "018d1342795471cc843dd5bb764af357"
},
"fields": {
"displayGroup": [
"85e8a2d195c1041b4f1f629352d7b672"
]
},
"sort": [
0,
"018d1342795471cc843dd5bb764af357"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d166e740c72cb970726d4bb3810a7",
"_score": null,
"_source": {
"autoIncrement": 1251392.0,
"id": "018d166e740c72cb970726d4bb3810a7"
},
"fields": {
"displayGroup": [
"158cea5220fcfe80b069db7c7e037b67"
]
},
"sort": [
0,
"018d166e740c72cb970726d4bb3810a7"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d16d6d031707b8350369c55eb8ae9",
"_score": null,
"_source": {
"autoIncrement": 1252202.0,
"id": "018d16d6d031707b8350369c55eb8ae9"
},
"fields": {
"displayGroup": [
"c015225c94c54d273c3921204fc5e719"
]
},
"sort": [
0,
"018d16d6d031707b8350369c55eb8ae9"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d172e6635713bba997142241af468",
"_score": null,
"_source": {
"autoIncrement": 1252792.0,
"id": "018d172e6635713bba997142241af468"
},
"fields": {
"displayGroup": [
"d02ff95848ba314f774806e0aa4db165"
]
},
"sort": [
0,
"018d172e6635713bba997142241af468"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d1778d9f3737ea67f2f8c1175c7c8",
"_score": null,
"_source": {
"autoIncrement": 1253543.0,
"id": "018d1778d9f3737ea67f2f8c1175c7c8"
},
"fields": {
"displayGroup": [
"b0e294c442fdce434b97c948401c24e2"
]
},
"sort": [
0,
"018d1778d9f3737ea67f2f8c1175c7c8"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d8f78594b734da7a65b764c078db6",
"_score": null,
"_source": {
"autoIncrement": 1285708.0,
"id": "018d8f78594b734da7a65b764c078db6"
},
"fields": {
"displayGroup": [
"943e0a9fd59e3b0c0e8c1a110304173e"
]
},
"sort": [
0,
"018d8f78594b734da7a65b764c078db6"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d98c688ec71c9afde67f13bbad59b",
"_score": null,
"_source": {
"autoIncrement": 1291485.0,
"id": "018d98c688ec71c9afde67f13bbad59b"
},
"fields": {
"displayGroup": [
"f47e8624c680e41417e65561e1d92862"
]
},
"sort": [
0,
"018d98c688ec71c9afde67f13bbad59b"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d98ede03871a99ccefaa922d726bc",
"_score": null,
"_source": {
"autoIncrement": 1292380.0,
"id": "018d98ede03871a99ccefaa922d726bc"
},
"fields": {
"displayGroup": [
"74089f88387dd6bdd96fd1719a1e89a6"
]
},
"sort": [
0,
"018d98ede03871a99ccefaa922d726bc"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d98f39dfe714bb0adc190408518cc",
"_score": null,
"_source": {
"autoIncrement": 1292499.0,
"id": "018d98f39dfe714bb0adc190408518cc"
},
"fields": {
"displayGroup": [
"46bcd396d8ec09962339bbda1ad49c24"
]
},
"sort": [
0,
"018d98f39dfe714bb0adc190408518cc"
]
}
]
},
"aggregations": {
"total-count": {
"value": 38
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
13.45 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":"0189981e780e73f38ce2d27989c15fa4"}}}},{"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": 11,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"max_score": null,
"hits": []
},
"aggregations": {
"shipping-free-filter": {
"doc_count": 4,
"shipping-free": {
"value": 1.0,
"value_as_string": "true"
}
},
"rating-exists": {
"doc_count": 402,
"rating": {
"value": 0.0
}
},
"price": {
"count": 402,
"min": 40.46,
"max": 134.96,
"avg": 70.13435323383085,
"sum": 28194.010000000002
},
"options": {
"doc_count": 804,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "fb2bcb1d04544f8e91cab9caadccd0e2",
"doc_count": 37
},
{
"key": "97610a9e8a0f4970a7be7eec0bac0378",
"doc_count": 35
},
{
"key": "a5d7196c2514479f857621c32bb84608",
"doc_count": 34
},
{
"key": "7189e238f66c4db8831ad403f65df75e",
"doc_count": 33
},
{
"key": "b5a3d8c7138344dda67987a4eff4cb1c",
"doc_count": 32
},
{
"key": "c0088ccb433c49aaadfc61d1966f804c",
"doc_count": 32
},
{
"key": "e1b2548665464da9b4f051e46c78427f",
"doc_count": 32
},
{
"key": "c36af3803d914e8bb422246a1b400a68",
"doc_count": 31
},
{
"key": "f166e204f18a46cd947eb253dc245521",
"doc_count": 31
},
{
"key": "2ef77dd834ab4ad8bf116883a3624328",
"doc_count": 30
},
{
"key": "6f242ff7ed204f40be74447de407e8b9",
"doc_count": 27
},
{
"key": "086b3eb228ec48e4a3aebc6cadf04a13",
"doc_count": 21
},
{
"key": "d0ac62514db74122ba7bf480ac21da52",
"doc_count": 19
},
{
"key": "98b22f58897849ab93cfb08e475e9fcd",
"doc_count": 16
},
{
"key": "2f438714c2af4a7e96af7b2e54253125",
"doc_count": 12
},
{
"key": "3b234f5e39574973a57cb1b5fe9cbb48",
"doc_count": 12
},
{
"key": "4113131b7ca54d478171d58ccee82fea",
"doc_count": 12
},
{
"key": "acfe1289602842d9ae00912da2d7fad7",
"doc_count": 12
},
{
"key": "ea6d60eb327443a9a1af1adecea6607c",
"doc_count": 12
},
{
"key": "018c6903766173829716fbeca1a22176",
"doc_count": 11
},
{
"key": "018c6cf122287039afd8dc267e11885e",
"doc_count": 11
},
{
"key": "018d796785b9712d9b5bf691ab031824",
"doc_count": 11
},
{
"key": "018d7967d53e72a7baac08ccd772e112",
"doc_count": 11
},
{
"key": "018d7968dbe67261a23d2b6e16911545",
"doc_count": 11
},
{
"key": "01909bab4149728693ae37c31e2ed2e9",
"doc_count": 11
},
{
"key": "12e2af0cc27c42069475b5c6c85a8e1e",
"doc_count": 11
},
{
"key": "2a3ebd3532fb4e8188df262ee3c6f054",
"doc_count": 11
},
{
"key": "3eef1a1bcc8d497886e4eab5ba0326a0",
"doc_count": 11
},
{
"key": "5d879a5a38694fc4979d848b7549eb89",
"doc_count": 11
},
{
"key": "74ce888639ff4eb7967d2ff70cf7a47b",
"doc_count": 11
},
{
"key": "9c7dc5166e9e46c0b9c8781e3903633d",
"doc_count": 11
},
{
"key": "eb1baf3c1c284567b53773a355a2a979",
"doc_count": 11
},
{
"key": "01909baa7c5b71e0910bed86ff00da0a",
"doc_count": 10
},
{
"key": "d77c127201e64d458d90fe87c67a5368",
"doc_count": 10
},
{
"key": "fefc7b01e0504b2fb7aa23b3115fe4f8",
"doc_count": 10
},
{
"key": "018d7968165273439e310920c09a419e",
"doc_count": 9
},
{
"key": "5271ece519ba4ffdb4718ad5743e6d2d",
"doc_count": 9
},
{
"key": "93fee3ed40e24fa69a3584d7c66bc340",
"doc_count": 9
},
{
"key": "1032cce732234c2da6d124956f00ed50",
"doc_count": 8
},
{
"key": "349230794a4c47459c132dd470cef634",
"doc_count": 8
},
{
"key": "63d84acf788c49e59731e1cb511d7474",
"doc_count": 8
},
{
"key": "53fa35fb1a20468f9bfb38aa77218f3d",
"doc_count": 6
},
{
"key": "cc672ce090b24f2789874a95d8632a2d",
"doc_count": 6
},
{
"key": "018c6cf12dfb73a6ae39ce87b2de2a9e",
"doc_count": 5
},
{
"key": "018d79678d71730cbe1d7a4c494461bb",
"doc_count": 5
},
{
"key": "34cbea0035d84600904d39e5238023c9",
"doc_count": 5
},
{
"key": "72a01cb10f73405e8ef303ee0e68362e",
"doc_count": 5
},
{
"key": "cb52eda8a65947e3b6eda99736ee4834",
"doc_count": 5
},
{
"key": "cf7179d03f394a93ada8b8f065cab004",
"doc_count": 5
},
{
"key": "018c6cf132b6713baf72b5461c100721",
"doc_count": 4
},
{
"key": "01909baa4100718cba079f8f9e653170",
"doc_count": 4
},
{
"key": "1c23aae651524363801a44213f31f325",
"doc_count": 4
},
{
"key": "a132823eaf34421c82c307567af7ec32",
"doc_count": 4
},
{
"key": "b4f59fa87a5240159c442583cb204141",
"doc_count": 4
},
{
"key": "d3b0afc20b104d49bd8b113a67e08cff",
"doc_count": 4
},
{
"key": "018c20c3126170f8afdfc71b87fb3bc7",
"doc_count": 3
},
{
"key": "1705ea081458425cacc7861a6083136a",
"doc_count": 3
},
{
"key": "799eeec01566421399f0186a0c1929ae",
"doc_count": 3
},
{
"key": "dd7ece81a9aa40c085e0fd4dee9d054c",
"doc_count": 3
},
{
"key": "e787469225dc44f1b15cb3c6186e4000",
"doc_count": 3
},
{
"key": "018d79678430729ea5d1de819d180074",
"doc_count": 2
},
{
"key": "018d8d99335d7352becc7fc7f4a8e30a",
"doc_count": 2
},
{
"key": "01a5b606c256465a953c9ee6dd91ef21",
"doc_count": 2
},
{
"key": "0cf73714b6974c3b9117d29129e3acf1",
"doc_count": 2
},
{
"key": "1c4813b5bfb3498eb9b77a52de18b2f9",
"doc_count": 2
},
{
"key": "255a4e022df445f3b3fe3464db121959",
"doc_count": 2
},
{
"key": "49b44d5132ed4576b0945770ac9da552",
"doc_count": 2
},
{
"key": "fed8bd68420247988685738501efa65c",
"doc_count": 2
},
{
"key": "018d79680b2f7190a14abecbad2080e9",
"doc_count": 1
},
{
"key": "018d796828c5724e8d82542781ddfabf",
"doc_count": 1
},
{
"key": "018d8d990f7172ce9587cc90ed4cab7d",
"doc_count": 1
},
{
"key": "018d8d99319f7158bf7ce3926e4711d2",
"doc_count": 1
},
{
"key": "033fac34000947e0a8337dba521efeae",
"doc_count": 1
},
{
"key": "27c8631adebe4dbaa488d434a60fede1",
"doc_count": 1
},
{
"key": "29b5ae909a2044589870afe7895f5e2b",
"doc_count": 1
},
{
"key": "4226eb03e960403ab2cfc8c254f2562f",
"doc_count": 1
},
{
"key": "4ecefeb40651472abced2eb36b431be2",
"doc_count": 1
},
{
"key": "596451407e60481d9e37148ca7a2031f",
"doc_count": 1
},
{
"key": "b4b11511c888420f8101141ab1703116",
"doc_count": 1
},
{
"key": "b9098912ba704078bf6482acae250e23",
"doc_count": 1
},
{
"key": "f60ea2b7b36342a4ba1a54c749cfb320",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 1668,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "018963e5f06f716dadb0fe95b3c53d22",
"doc_count": 394
},
{
"key": "01896412a78e71088e5210d9c9c16606",
"doc_count": 357
},
{
"key": "01896411e25971f98272a565102c3faf",
"doc_count": 332
},
{
"key": "018963ea415c7217b4dc8cb62572ed16",
"doc_count": 239
},
{
"key": "018963ea3aba7042895b047285c1402e",
"doc_count": 80
},
{
"key": "018bbe13c1f071a095ab51339e1d02ad",
"doc_count": 61
},
{
"key": "01896411e4587305baecfc84ebf67bc3",
"doc_count": 32
},
{
"key": "018964127bda71deaa81911fd311c310",
"doc_count": 32
},
{
"key": "018c825be40470e093149253f848d6d3",
"doc_count": 30
},
{
"key": "018963ea3c15725ea04f1c0eefbb7695",
"doc_count": 22
},
{
"key": "018963ea220370f6b3962a1108942bae",
"doc_count": 18
},
{
"key": "01896411e1b67172ac7120fc2f0fa574",
"doc_count": 14
},
{
"key": "018963ea3609712896e2d21c3a2d91ab",
"doc_count": 12
},
{
"key": "018963ea1a0071e3b903843432a2818e",
"doc_count": 9
},
{
"key": "018963e5f53b7292b003bf6803f624b7",
"doc_count": 8
},
{
"key": "018bbe13bff4727baa40d87b9df82a76",
"doc_count": 8
},
{
"key": "018dcc3373f47133833772ee8dfc3fe4",
"doc_count": 8
},
{
"key": "018bbe13c29d7030b84ca02c030b4e39",
"doc_count": 4
},
{
"key": "018963ea26b971f09527dfc7f4930323",
"doc_count": 3
},
{
"key": "018bbe13b8cd710c9456aa52d02306b1",
"doc_count": 3
},
{
"key": "01896412a84e70c098444f2e8487ed0c",
"doc_count": 1
},
{
"key": "018e2ee56a8f71dc803950858727ef20",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "d8ac016c293145ff9d20f96184a4ad02",
"doc_count": 361
},
{
"key": "1a0ffc50b3584a1abd28c2d06d6c6465",
"doc_count": 41
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|