| 1 |
328.85 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": 326,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 275,
"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": "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": "018cd0fe3a19725f8b1a248fc35c4f39",
"_score": null,
"_source": {
"autoIncrement": 1224321.0,
"id": "018cd0fe3a19725f8b1a248fc35c4f39"
},
"fields": {
"displayGroup": [
"6a1e61a40a0a079bdc92d0dcb29485f6"
]
},
"sort": [
0,
"018cd0fe3a19725f8b1a248fc35c4f39"
]
},
{
"_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"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018f7b72b94c72859f7482740df0f8dc",
"_score": null,
"_source": {
"autoIncrement": 1785087.0,
"id": "018f7b72b94c72859f7482740df0f8dc"
},
"fields": {
"displayGroup": [
"44bf35307a609ed49be80c724f04323c"
]
},
"sort": [
0,
"018f7b72b94c72859f7482740df0f8dc"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01904f9fc20b73bd972495081b4a101b",
"_score": null,
"_source": {
"autoIncrement": 1805714.0,
"id": "01904f9fc20b73bd972495081b4a101b"
},
"fields": {
"displayGroup": [
"5528eeae0e1828fa1841ad63b3e78490"
]
},
"sort": [
0,
"01904f9fc20b73bd972495081b4a101b"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01904fa0b9a07078b34098a11d00f116",
"_score": null,
"_source": {
"autoIncrement": 1805806.0,
"id": "01904fa0b9a07078b34098a11d00f116"
},
"fields": {
"displayGroup": [
"449f2918712374fdd282e02cb346d3ff"
]
},
"sort": [
0,
"01904fa0b9a07078b34098a11d00f116"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01909c50460f71bab5e8c1c6f69e7fb2",
"_score": null,
"_source": {
"autoIncrement": 1825557.0,
"id": "01909c50460f71bab5e8c1c6f69e7fb2"
},
"fields": {
"displayGroup": [
"42ec423e04cefe8ee979df5049234a9e"
]
},
"sort": [
0,
"01909c50460f71bab5e8c1c6f69e7fb2"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "01909ca08beb70a688b8eb1830d7c854",
"_score": null,
"_source": {
"autoIncrement": 1830367.0,
"id": "01909ca08beb70a688b8eb1830d7c854"
},
"fields": {
"displayGroup": [
"6e1ac5a9a7566fc7a3256d8ea3c1317b"
]
},
"sort": [
0,
"01909ca08beb70a688b8eb1830d7c854"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0190a1a3c461712b979d476e48e65f23",
"_score": null,
"_source": {
"autoIncrement": 1834767.0,
"id": "0190a1a3c461712b979d476e48e65f23"
},
"fields": {
"displayGroup": [
"5254b02713de0937d98eb00d0772fb86"
]
},
"sort": [
0,
"0190a1a3c461712b979d476e48e65f23"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "0190a699bd2a714abaa45a145a2f8193",
"_score": null,
"_source": {
"autoIncrement": 1836089.0,
"id": "0190a699bd2a714abaa45a145a2f8193"
},
"fields": {
"displayGroup": [
"369f863585eaa8d18d39f7ddceb48459"
]
},
"sort": [
0,
"0190a699bd2a714abaa45a145a2f8193"
]
}
]
},
"aggregations": {
"total-count": {
"value": 24
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
24.97 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": 19,
"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": 275,
"rating": {
"value": 0.0
}
},
"price": {
"count": 275,
"min": 24.99,
"max": 111.96,
"avg": 68.45887272727272,
"sum": 18826.19
},
"options": {
"doc_count": 550,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "0190020586ce702ab69a9dbdbddfffac",
"doc_count": 27
},
{
"key": "c2d0a920e328481db842b8da42b54bc1",
"doc_count": 25
},
{
"key": "018dcc33b57f7392ae8b461215470769",
"doc_count": 20
},
{
"key": "13b662e7a3b149b388a87e76e82f3299",
"doc_count": 20
},
{
"key": "62a7e2a2863d4c418b9acd4f6359f6cb",
"doc_count": 17
},
{
"key": "fefc7b01e0504b2fb7aa23b3115fe4f8",
"doc_count": 17
},
{
"key": "528d738a30b847248434b14e905cd91c",
"doc_count": 16
},
{
"key": "c4ca7c83d7b9434dba35d808f3cb587b",
"doc_count": 16
},
{
"key": "018c6904e760723d986b6a748a00efbc",
"doc_count": 15
},
{
"key": "018d796752da71d4bc16000988e14500",
"doc_count": 15
},
{
"key": "24825ae0f7ff41bdbddc49e34931df58",
"doc_count": 15
},
{
"key": "6f242ff7ed204f40be74447de407e8b9",
"doc_count": 15
},
{
"key": "98d6bcd6d5da4c45a80c847b8f441853",
"doc_count": 15
},
{
"key": "d32f5d7c6ff24f32ac2cef76583b3ff3",
"doc_count": 15
},
{
"key": "2ef77dd834ab4ad8bf116883a3624328",
"doc_count": 14
},
{
"key": "799eeec01566421399f0186a0c1929ae",
"doc_count": 14
},
{
"key": "f166e204f18a46cd947eb253dc245521",
"doc_count": 14
},
{
"key": "fb2bcb1d04544f8e91cab9caadccd0e2",
"doc_count": 14
},
{
"key": "01909baa289473c988f5798b39a2ba9c",
"doc_count": 13
},
{
"key": "2055b8652dba4a38bb12157ef8bd8e7c",
"doc_count": 13
},
{
"key": "01909baa8a5e71d19a057b33fe293e3d",
"doc_count": 12
},
{
"key": "c36af3803d914e8bb422246a1b400a68",
"doc_count": 12
},
{
"key": "01901bd3339372b696de1abd019141c9",
"doc_count": 10
},
{
"key": "0190da3aa17072389aa7eb2bb7f19c1e",
"doc_count": 10
},
{
"key": "e1b2548665464da9b4f051e46c78427f",
"doc_count": 10
},
{
"key": "85eb5d1985c34e90a8f328b848a1e510",
"doc_count": 9
},
{
"key": "f1c0d70c9b714c4cb27beb8f22273242",
"doc_count": 9
},
{
"key": "018c690559417041adb5044232bfc8bb",
"doc_count": 8
},
{
"key": "103c221ef5c547a6919548726a45adb7",
"doc_count": 8
},
{
"key": "63a3e4e3a8d0461ca937227647cbc474",
"doc_count": 8
},
{
"key": "b26bb94349e2469ea3e048b8bd50a91d",
"doc_count": 8
},
{
"key": "bace55c509624d8ab8a0c4653bced477",
"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": "64a44b3d85144a88b890b250e7030d5f",
"doc_count": 7
},
{
"key": "6818490b3d264af396bf32b5c741cb18",
"doc_count": 7
},
{
"key": "018c6904c0ff70c0a7d346ac36ccc59b",
"doc_count": 6
},
{
"key": "7f20ca030a894ff8b9c158a43c0cbb9e",
"doc_count": 5
},
{
"key": "97610a9e8a0f4970a7be7eec0bac0378",
"doc_count": 5
},
{
"key": "b5a3d8c7138344dda67987a4eff4cb1c",
"doc_count": 5
},
{
"key": "7189e238f66c4db8831ad403f65df75e",
"doc_count": 4
},
{
"key": "c0088ccb433c49aaadfc61d1966f804c",
"doc_count": 4
},
{
"key": "c2725e1f949d43afafbd92ebcdce5798",
"doc_count": 4
},
{
"key": "018c690369a9714988c0ae7e113fee13",
"doc_count": 3
},
{
"key": "01909baa426d72e6a4ee1d0950c74af3",
"doc_count": 3
},
{
"key": "a5d7196c2514479f857621c32bb84608",
"doc_count": 3
},
{
"key": "018c69038764708789affe7ed0a20b95",
"doc_count": 2
},
{
"key": "018db35838f4716196f36dc1d5302554",
"doc_count": 2
},
{
"key": "01909baa8d2f73ff99d303a16c1c9075",
"doc_count": 2
},
{
"key": "189e0d4708a24426bd8480e503c94688",
"doc_count": 2
},
{
"key": "3d0b11d1db0f48f7acb284976d0b45e0",
"doc_count": 2
},
{
"key": "018c6904a60a71d58e25430d71ee064a",
"doc_count": 1
},
{
"key": "019091974b0f73d88d5927c8ac9dc0f6",
"doc_count": 1
},
{
"key": "01909baa4d9072658b9722deb8eea0a6",
"doc_count": 1
},
{
"key": "01909baad70e70e49d44a8805f521a25",
"doc_count": 1
},
{
"key": "1e787749081e41c0988899cdfdd52cc7",
"doc_count": 1
},
{
"key": "349230794a4c47459c132dd470cef634",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 1003,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "018963e5f13871739bde1b0eb26bb21b",
"doc_count": 201
},
{
"key": "01896412712e7033ae5fe5b82ad53b07",
"doc_count": 165
},
{
"key": "018963ea3aba7042895b047285c1402e",
"doc_count": 137
},
{
"key": "01896411e3007292bbf291a9837a8cc8",
"doc_count": 115
},
{
"key": "018963e5f53b7292b003bf6803f624b7",
"doc_count": 74
},
{
"key": "018dcc3373f47133833772ee8dfc3fe4",
"doc_count": 58
},
{
"key": "01896411e11071498f66a862f5383700",
"doc_count": 55
},
{
"key": "018963ea1812737fb7f416641565cd24",
"doc_count": 42
},
{
"key": "018963ea2bce70d7876c75f434e017d1",
"doc_count": 40
},
{
"key": "01896412d947725f982fc682b748509d",
"doc_count": 40
},
{
"key": "018963ea415c7217b4dc8cb62572ed16",
"doc_count": 36
},
{
"key": "018ae9d2bdd473c88477b20ff8be8bb8",
"doc_count": 15
},
{
"key": "01896411e3af718192fb7f9ee45ad6fb",
"doc_count": 12
},
{
"key": "018bbe146ffe71f5b995756cff67f838",
"doc_count": 12
},
{
"key": "018963ea3964707fbbfb35b2b8e8084b",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "57f85a1341f34ad284dc91714711a009",
"doc_count": 127
},
{
"key": "d8ac016c293145ff9d20f96184a4ad02",
"doc_count": 87
},
{
"key": "018c7c9a622870078a62e47c70408932",
"doc_count": 58
},
{
"key": "9cdb250390f640078ffc3e4e8ed2e543",
"doc_count": 2
},
{
"key": "6f10e4ac0c444f1a91667bad688d924f",
"doc_count": 1
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|