| 1 |
17.18 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":"018997a56fb07287abefad886b1e7408"}}}},{"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": 13,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 793,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bcee4eb9b72589f09776b73fa2eb2",
"_score": null,
"_source": {
"autoIncrement": 1136019.0,
"id": "018bcee4eb9b72589f09776b73fa2eb2"
},
"fields": {
"displayGroup": [
"9426c86c848de680b611e9a1cb32805a"
]
},
"sort": [
3,
"018bcee4eb9b72589f09776b73fa2eb2"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018af47d34fd734dadaecb0b46b66b1a",
"_score": null,
"_source": {
"autoIncrement": 1133406.0,
"id": "018af47d34fd734dadaecb0b46b66b1a"
},
"fields": {
"displayGroup": [
"250345ad6bf594c830e78d39ad1d0ca8"
]
},
"sort": [
1,
"018af47d34fd734dadaecb0b46b66b1a"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018af47f19c87036841dbc7de40946c9",
"_score": null,
"_source": {
"autoIncrement": 1133612.0,
"id": "018af47f19c87036841dbc7de40946c9"
},
"fields": {
"displayGroup": [
"7eee65889f9e416e744b7dbc9ec32887"
]
},
"sort": [
1,
"018af47f19c87036841dbc7de40946c9"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "007aa3c6f119424a8f28492baa62363f",
"_score": null,
"_source": {
"autoIncrement": 1130515.0,
"id": "007aa3c6f119424a8f28492baa62363f"
},
"fields": {
"displayGroup": [
"68707e9754f656d216eaf1dbc65f7db1"
]
},
"sort": [
0,
"007aa3c6f119424a8f28492baa62363f"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018af47c6abb7262b62528ff29eabce2",
"_score": null,
"_source": {
"autoIncrement": 1133278.0,
"id": "018af47c6abb7262b62528ff29eabce2"
},
"fields": {
"displayGroup": [
"47f981e0bd882b5d96ffa4a6248fc754"
]
},
"sort": [
0,
"018af47c6abb7262b62528ff29eabce2"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018af47cb88b71d3a7193f82b86ea26e",
"_score": null,
"_source": {
"autoIncrement": 1133322.0,
"id": "018af47cb88b71d3a7193f82b86ea26e"
},
"fields": {
"displayGroup": [
"9e8b892020fbb4d84549edecd19810d2"
]
},
"sort": [
0,
"018af47cb88b71d3a7193f82b86ea26e"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018af47ccc4c73cf84c4d827a610acf4",
"_score": null,
"_source": {
"autoIncrement": 1133336.0,
"id": "018af47ccc4c73cf84c4d827a610acf4"
},
"fields": {
"displayGroup": [
"4f8c5fd117966519145f7b9394a48c49"
]
},
"sort": [
0,
"018af47ccc4c73cf84c4d827a610acf4"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c80c6096b70edbdb96a3e2fab9826",
"_score": null,
"_source": {
"autoIncrement": 1164667.0,
"id": "018c80c6096b70edbdb96a3e2fab9826"
},
"fields": {
"displayGroup": [
"d0b80324f08c61705b856098c25a4f10"
]
},
"sort": [
0,
"018c80c6096b70edbdb96a3e2fab9826"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018cd0124c557289aecc0f03d3ae7452",
"_score": null,
"_source": {
"autoIncrement": 1222853.0,
"id": "018cd0124c557289aecc0f03d3ae7452"
},
"fields": {
"displayGroup": [
"c88562fb25ad59f7a5b4614bb263fe29"
]
},
"sort": [
0,
"018cd0124c557289aecc0f03d3ae7452"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018cd061bed27027aadb3ab4fef8358b",
"_score": null,
"_source": {
"autoIncrement": 1223471.0,
"id": "018cd061bed27027aadb3ab4fef8358b"
},
"fields": {
"displayGroup": [
"920bedb82c520ee5e63c4cfc80152d9b"
]
},
"sort": [
0,
"018cd061bed27027aadb3ab4fef8358b"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018cd0fdf7f772c4b06f937ca7cb31c9",
"_score": null,
"_source": {
"autoIncrement": 1224319.0,
"id": "018cd0fdf7f772c4b06f937ca7cb31c9"
},
"fields": {
"displayGroup": [
"6a1e61a40a0a079bdc92d0dcb29485f6"
]
},
"sort": [
0,
"018cd0fdf7f772c4b06f937ca7cb31c9"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d79763ba473c7bd884adeaf7f43af",
"_score": null,
"_source": {
"autoIncrement": 1273487.0,
"id": "018d79763ba473c7bd884adeaf7f43af"
},
"fields": {
"displayGroup": [
"72e7f1d9aa43adfc0c3663da658283a1"
]
},
"sort": [
0,
"018d79763ba473c7bd884adeaf7f43af"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018d991edde372a9be29c7aa1ab77086",
"_score": null,
"_source": {
"autoIncrement": 1293206.0,
"id": "018d991edde372a9be29c7aa1ab77086"
},
"fields": {
"displayGroup": [
"6901f20993f2f8a4e10f903384009cbd"
]
},
"sort": [
0,
"018d991edde372a9be29c7aa1ab77086"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018daa1ff5b770d48a2f8d7fd4654c45",
"_score": null,
"_source": {
"autoIncrement": 1309452.0,
"id": "018daa1ff5b770d48a2f8d7fd4654c45"
},
"fields": {
"displayGroup": [
"328cc3cbf0dbeb48bb8dcae3e9e6e891"
]
},
"sort": [
0,
"018daa1ff5b770d48a2f8d7fd4654c45"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018dc0c251327386a9e8abd9de6dba60",
"_score": null,
"_source": {
"autoIncrement": 1318066.0,
"id": "018dc0c251327386a9e8abd9de6dba60"
},
"fields": {
"displayGroup": [
"522a7999d11a91d9ddfafc05857ac28d"
]
},
"sort": [
0,
"018dc0c251327386a9e8abd9de6dba60"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018dc0c43b96732a8eef8e87cf075b39",
"_score": null,
"_source": {
"autoIncrement": 1318093.0,
"id": "018dc0c43b96732a8eef8e87cf075b39"
},
"fields": {
"displayGroup": [
"e9f189b1af84ae058830254e439c52af"
]
},
"sort": [
0,
"018dc0c43b96732a8eef8e87cf075b39"
]
}
]
},
"aggregations": {
"total-count": {
"value": 63
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
9.71 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":"018997a56fb07287abefad886b1e7408"}}}},{"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": 7,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"max_score": null,
"hits": []
},
"aggregations": {
"shipping-free-filter": {
"doc_count": 2,
"shipping-free": {
"value": 1.0,
"value_as_string": "true"
}
},
"rating-exists": {
"doc_count": 793,
"rating": {
"value": 0.0
}
},
"price": {
"count": 793,
"min": 24.99,
"max": 112.0,
"avg": 65.11277427490542,
"sum": 51634.43
},
"options": {
"doc_count": 1586,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "018d79675466735989015568610f58b3",
"doc_count": 65
},
{
"key": "2055b8652dba4a38bb12157ef8bd8e7c",
"doc_count": 51
},
{
"key": "2ef77dd834ab4ad8bf116883a3624328",
"doc_count": 51
},
{
"key": "528d738a30b847248434b14e905cd91c",
"doc_count": 51
},
{
"key": "799eeec01566421399f0186a0c1929ae",
"doc_count": 51
},
{
"key": "c4ca7c83d7b9434dba35d808f3cb587b",
"doc_count": 51
},
{
"key": "d32f5d7c6ff24f32ac2cef76583b3ff3",
"doc_count": 51
},
{
"key": "24825ae0f7ff41bdbddc49e34931df58",
"doc_count": 50
},
{
"key": "6f242ff7ed204f40be74447de407e8b9",
"doc_count": 50
},
{
"key": "98d6bcd6d5da4c45a80c847b8f441853",
"doc_count": 50
},
{
"key": "cca87ab4cab5470f85b32ce2b3269b1e",
"doc_count": 48
},
{
"key": "f166e204f18a46cd947eb253dc245521",
"doc_count": 47
},
{
"key": "fb2bcb1d04544f8e91cab9caadccd0e2",
"doc_count": 46
},
{
"key": "c36af3803d914e8bb422246a1b400a68",
"doc_count": 45
},
{
"key": "e1b2548665464da9b4f051e46c78427f",
"doc_count": 43
},
{
"key": "13b662e7a3b149b388a87e76e82f3299",
"doc_count": 35
},
{
"key": "64a44b3d85144a88b890b250e7030d5f",
"doc_count": 33
},
{
"key": "018d7967562073d29d87ac0d1805a758",
"doc_count": 30
},
{
"key": "018dcc33a64b71ab9c8c86e74d17af5c",
"doc_count": 30
},
{
"key": "3093f1af1d8642c5ac39bb2ecc9ee2b1",
"doc_count": 30
},
{
"key": "c2725e1f949d43afafbd92ebcdce5798",
"doc_count": 29
},
{
"key": "0190020586ce702ab69a9dbdbddfffac",
"doc_count": 27
},
{
"key": "c2d0a920e328481db842b8da42b54bc1",
"doc_count": 25
},
{
"key": "01900205879f7248867868c412fc658d",
"doc_count": 23
},
{
"key": "018dcc33b57f7392ae8b461215470769",
"doc_count": 20
},
{
"key": "018dcc33c8e571bb8a8e2fa6bc92426e",
"doc_count": 20
},
{
"key": "62a7e2a2863d4c418b9acd4f6359f6cb",
"doc_count": 18
},
{
"key": "fefc7b01e0504b2fb7aa23b3115fe4f8",
"doc_count": 17
},
{
"key": "018c6904e760723d986b6a748a00efbc",
"doc_count": 15
},
{
"key": "018d796752da71d4bc16000988e14500",
"doc_count": 15
},
{
"key": "018d7967553a72ca97faf14b9d69a419",
"doc_count": 15
},
{
"key": "018dcc33a42b739e922af6129ca57fff",
"doc_count": 15
},
{
"key": "018dcc33bba1712fa8626be89716f904",
"doc_count": 15
},
{
"key": "018dcc33c0187166a02cdee6223f4c39",
"doc_count": 15
},
{
"key": "018dcc33c29a701d90ce64a256851001",
"doc_count": 15
},
{
"key": "018dcc33c4b7721b8cf66e4fa3b80686",
"doc_count": 15
},
{
"key": "018dcc33caf570518d0894be78e37728",
"doc_count": 15
},
{
"key": "018dcc33cd29725e88c498df8bff7ea9",
"doc_count": 15
},
{
"key": "018dcc33cf86706683b9c16c260c4811",
"doc_count": 15
},
{
"key": "018dcc33e67c71119e1fea2ed6ce8db2",
"doc_count": 15
},
{
"key": "018dcc33ea727119a9be5b04adbd06a8",
"doc_count": 15
},
{
"key": "018dcc33ef3e71b98f00b79ebc1d3165",
"doc_count": 15
},
{
"key": "018dcc33f84c71f49a5cfac761b33f39",
"doc_count": 15
},
{
"key": "01909baa289473c988f5798b39a2ba9c",
"doc_count": 13
},
{
"key": "85eb5d1985c34e90a8f328b848a1e510",
"doc_count": 13
},
{
"key": "a3c0ad99cd1742e485ac4f5f5773c6e0",
"doc_count": 13
},
{
"key": "ac41845e2c4d4fd0b3d810c2bc2b2424",
"doc_count": 13
},
{
"key": "b4bcc055f4b34f45ac8470f8a86812a3",
"doc_count": 13
},
{
"key": "01909baa8a5e71d19a057b33fe293e3d",
"doc_count": 12
},
{
"key": "01901bd3339372b696de1abd019141c9",
"doc_count": 10
},
{
"key": "0190da3aa17072389aa7eb2bb7f19c1e",
"doc_count": 10
},
{
"key": "103c221ef5c547a6919548726a45adb7",
"doc_count": 9
},
{
"key": "f1c0d70c9b714c4cb27beb8f22273242",
"doc_count": 9
},
{
"key": "018c690559417041adb5044232bfc8bb",
"doc_count": 8
},
{
"key": "63a3e4e3a8d0461ca937227647cbc474",
"doc_count": 8
},
{
"key": "b26bb94349e2469ea3e048b8bd50a91d",
"doc_count": 8
},
{
"key": "bace55c509624d8ab8a0c4653bced477",
"doc_count": 8
},
{
"key": "d42230d1b2e443189cfdcdd64bd157ef",
"doc_count": 8
},
{
"key": "df41139ab42a4f0dbe2167afb103b833",
"doc_count": 8
},
{
"key": "018c7c806832736db9bacfda62bcc76c",
"doc_count": 7
},
{
"key": "018c7c806bb572f2b866af84c888b7ee",
"doc_count": 7
},
{
"key": "018c7c807a6672e2a15f746cbb03947e",
"doc_count": 7
},
{
"key": "018c7c8091e77067ac12d2c22971634f",
"doc_count": 7
},
{
"key": "6818490b3d264af396bf32b5c741cb18",
"doc_count": 7
},
{
"key": "7189e238f66c4db8831ad403f65df75e",
"doc_count": 7
},
{
"key": "97610a9e8a0f4970a7be7eec0bac0378",
"doc_count": 7
},
{
"key": "b5a3d8c7138344dda67987a4eff4cb1c",
"doc_count": 7
},
{
"key": "018c6904c0ff70c0a7d346ac36ccc59b",
"doc_count": 6
},
{
"key": "c0088ccb433c49aaadfc61d1966f804c",
"doc_count": 6
},
{
"key": "4d57fd9c89e045d2b959501c32c77f47",
"doc_count": 5
},
{
"key": "7f20ca030a894ff8b9c158a43c0cbb9e",
"doc_count": 5
},
{
"key": "a5d7196c2514479f857621c32bb84608",
"doc_count": 5
},
{
"key": "018c690369a9714988c0ae7e113fee13",
"doc_count": 3
},
{
"key": "018db35838f4716196f36dc1d5302554",
"doc_count": 3
},
{
"key": "01909baa426d72e6a4ee1d0950c74af3",
"doc_count": 3
},
{
"key": "018c69038764708789affe7ed0a20b95",
"doc_count": 2
},
{
"key": "018c6904a60a71d58e25430d71ee064a",
"doc_count": 2
},
{
"key": "01909baa8d2f73ff99d303a16c1c9075",
"doc_count": 2
},
{
"key": "189e0d4708a24426bd8480e503c94688",
"doc_count": 2
},
{
"key": "3d0b11d1db0f48f7acb284976d0b45e0",
"doc_count": 2
},
{
"key": "019091974b0f73d88d5927c8ac9dc0f6",
"doc_count": 1
},
{
"key": "01909baa4d9072658b9722deb8eea0a6",
"doc_count": 1
},
{
"key": "01909baad70e70e49d44a8805f521a25",
"doc_count": 1
},
{
"key": "019afb4baa7a4bb99438f94850b0bd02",
"doc_count": 1
},
{
"key": "1e787749081e41c0988899cdfdd52cc7",
"doc_count": 1
},
{
"key": "34702c78a7eb4e1ba4eae3b7783f5a5c",
"doc_count": 1
},
{
"key": "349230794a4c47459c132dd470cef634",
"doc_count": 1
},
{
"key": "3ded9781c61c4c91bc85327563d81658",
"doc_count": 1
},
{
"key": "affaf560314e4c4f853adaeb8bd54beb",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 2752,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "018963e5f13871739bde1b0eb26bb21b",
"doc_count": 677
},
{
"key": "01896412712e7033ae5fe5b82ad53b07",
"doc_count": 528
},
{
"key": "01896411e11071498f66a862f5383700",
"doc_count": 432
},
{
"key": "018963ea3aba7042895b047285c1402e",
"doc_count": 230
},
{
"key": "01896411e3007292bbf291a9837a8cc8",
"doc_count": 129
},
{
"key": "018963e5f53b7292b003bf6803f624b7",
"doc_count": 94
},
{
"key": "018963ea415c7217b4dc8cb62572ed16",
"doc_count": 94
},
{
"key": "018963ea220370f6b3962a1108942bae",
"doc_count": 65
},
{
"key": "018963ea2bce70d7876c75f434e017d1",
"doc_count": 62
},
{
"key": "01896412d947725f982fc682b748509d",
"doc_count": 62
},
{
"key": "018dcc3373f47133833772ee8dfc3fe4",
"doc_count": 59
},
{
"key": "018963ea20b670278236dc7103bcceb8",
"doc_count": 45
},
{
"key": "018963ea26b971f09527dfc7f4930323",
"doc_count": 45
},
{
"key": "018963ea1812737fb7f416641565cd24",
"doc_count": 42
},
{
"key": "0190a6bca60c70d6979f3a69eb39a7e8",
"doc_count": 30
},
{
"key": "0190a6bca6cf7152b269db6e1934b4be",
"doc_count": 30
},
{
"key": "01896411e3af718192fb7f9ee45ad6fb",
"doc_count": 28
},
{
"key": "018bbe146ffe71f5b995756cff67f838",
"doc_count": 27
},
{
"key": "018963e5f32b703288aad57690802852",
"doc_count": 15
},
{
"key": "018963ea336b7003ba1d74549036192d",
"doc_count": 15
},
{
"key": "018ae9d2bdd473c88477b20ff8be8bb8",
"doc_count": 15
},
{
"key": "018bbe13b7757294bf18b34533cada9d",
"doc_count": 15
},
{
"key": "018ae9d2c01971b285b979f0f9f8ef4e",
"doc_count": 9
},
{
"key": "018963ea3964707fbbfb35b2b8e8084b",
"doc_count": 3
},
{
"key": "0189641277c173c2b84e865902856093",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "57f85a1341f34ad284dc91714711a009",
"doc_count": 638
},
{
"key": "d8ac016c293145ff9d20f96184a4ad02",
"doc_count": 92
},
{
"key": "018c7c9a622870078a62e47c70408932",
"doc_count": 59
},
{
"key": "9cdb250390f640078ffc3e4e8ed2e543",
"doc_count": 3
},
{
"key": "6f10e4ac0c444f1a91667bad688d924f",
"doc_count": 1
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|