1 |
8.81 ms |
Request:
{"index":"sw_product","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":"018aa81ce101726a9439817685a207b7"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"018e1955724a7a36a7270a75db2b7110"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}},{"bool":{"should":[{"bool":{"must":[{"nested":{"path":"parent.swagDynamicAccessRules","query":{"terms":{"parent.swagDynamicAccessRules.id":["0189e51498b172ffaba28fb1e58dee02","0189e514995d71cdace03f1dbda1f1f6","0189e514cec07203af0b602d25cfe21d","01910d9b14ee709cb429be0ad075e8aa","3858957016644de4ae48c0500bf3ccc8","e1378db7808a478f919e0d740d5d6c1a","018aa881a98878e58932a7721e054d1a","018f7b1212d571aa9aefd8cfc5126bd3","01909b60cbda73faaad9bb30a2d6711a"]}}}},{"nested":{"path":"swagDynamicAccessRules","query":{"bool":{"must_not":[{"exists":{"field":"swagDynamicAccessRules.id"}}]}}}}]}},{"nested":{"path":"swagDynamicAccessRules","query":{"terms":{"swagDynamicAccessRules.id":["0189e51498b172ffaba28fb1e58dee02","0189e514995d71cdace03f1dbda1f1f6","0189e514cec07203af0b602d25cfe21d","01910d9b14ee709cb429be0ad075e8aa","3858957016644de4ae48c0500bf3ccc8","e1378db7808a478f919e0d740d5d6c1a","018aa881a98878e58932a7721e054d1a","018f7b1212d571aa9aefd8cfc5126bd3","01909b60cbda73faaad9bb30a2d6711a"]}}}},{"bool":{"must":[{"nested":{"path":"parent.swagDynamicAccessRules","query":{"bool":{"must_not":[{"exists":{"field":"parent.swagDynamicAccessRules.id"}}]}}}},{"nested":{"path":"swagDynamicAccessRules","query":{"bool":{"must_not":[{"exists":{"field":"swagDynamicAccessRules.id"}}]}}}}]}}]}}]}}]}},"sort":[{"_script":{"type":"string","script":{"id":"translated_field_sorting","params":{"field":"name","languages":["2fbb5fe2e29a4d70aa5854ce7ce3e20b"]}},"order":"ASC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"}}
{
"took": 5,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 179,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_product_1726772402",
"_type": "_doc",
"_id": "019091fccc3472dbacbbe04b60bccfe7",
"_score": null,
"_source": {
"autoIncrement": 7902.0,
"id": "019091fccc3472dbacbbe04b60bccfe7"
},
"fields": {
"displayGroup": [
"e646dcf4d368839e3b75ef0be1b06aed"
]
},
"sort": [
"asphalt sicherheitshochschuhe s2 \u201e8211\u201c asphaltprofi ",
"019091fccc3472dbacbbe04b60bccfe7"
]
},
{
"_index": "sw_product_1726772402",
"_type": "_doc",
"_id": "019096ce3f3b704fb59b2f06eca747a6",
"_score": null,
"_source": {
"autoIncrement": 10314.0,
"id": "019096ce3f3b704fb59b2f06eca747a6"
},
"fields": {
"displayGroup": [
"29b69cc9f06976def4322d9ba323a5e6"
]
},
"sort": [
"pvc-sicherheitsstiefel s5 \"basic\" gelb",
"019096ce3f3b704fb59b2f06eca747a6"
]
},
{
"_index": "sw_product_1726772402",
"_type": "_doc",
"_id": "019091fdaeac70fabb305966a71946d1",
"_score": null,
"_source": {
"autoIncrement": 8211.0,
"id": "019091fdaeac70fabb305966a71946d1"
},
"fields": {
"displayGroup": [
"3855c057e7a75a40c047f069fb40c116"
]
},
"sort": [
"sicherheitshalbschuhe s3 \"nepal\" braun - canadianline\u00ae",
"019091fdaeac70fabb305966a71946d1"
]
},
{
"_index": "sw_product_1726772402",
"_type": "_doc",
"_id": "019096c1a4af706daab18f87bba079f9",
"_score": null,
"_source": {
"autoIncrement": 10049.0,
"id": "019096c1a4af706daab18f87bba079f9"
},
"fields": {
"displayGroup": [
"beaeae2c8b0971a8709bd7cc4de55eb9"
]
},
"sort": [
"sicherheitshochschuhe s3 \"anatomic bau 500\" ",
"019096c1a4af706daab18f87bba079f9"
]
},
{
"_index": "sw_product_1726772402",
"_type": "_doc",
"_id": "019091fe10a471acbb68e87d08730b02",
"_score": null,
"_source": {
"autoIncrement": 8339.0,
"id": "019091fe10a471acbb68e87d08730b02"
},
"fields": {
"displayGroup": [
"bc7baa674b1045dc3d0d46b101092a37"
]
},
"sort": [
"sicherheitshochschuhe s3 \"anatomic bau 500\" w12",
"019091fe10a471acbb68e87d08730b02"
]
},
{
"_index": "sw_product_1726772402",
"_type": "_doc",
"_id": "019082d07ba27108aa1ada84c38f66af",
"_score": null,
"_source": {
"autoIncrement": 217.0,
"id": "019082d07ba27108aa1ada84c38f66af"
},
"fields": {
"displayGroup": [
"4c4b18635712d1b8e030df235806d6ea"
]
},
"sort": [
"sicherheitshochschuhe s3 \"safety 54 mid\" ",
"019082d07ba27108aa1ada84c38f66af"
]
},
{
"_index": "sw_product_1726772402",
"_type": "_doc",
"_id": "019091fdb6fa7227a497324077f121bd",
"_score": null,
"_source": {
"autoIncrement": 8223.0,
"id": "019091fdb6fa7227a497324077f121bd"
},
"fields": {
"displayGroup": [
"daef5b64d722ac20258c4dda146d3e24"
]
},
"sort": [
"sicherheitshochschuhe s3 \"sherpa\" braun - canadianline\u00ae",
"019091fdb6fa7227a497324077f121bd"
]
},
{
"_index": "sw_product_1726772402",
"_type": "_doc",
"_id": "019091fca55e721d9b6261e65a306f3b",
"_score": null,
"_source": {
"autoIncrement": 7841.0,
"id": "019091fca55e721d9b6261e65a306f3b"
},
"fields": {
"displayGroup": [
"3b4fa374eea01e6be84b6698ecfc3a34"
]
},
"sort": [
"sicherheitssandale s1p \"new don\" techno ",
"019091fca55e721d9b6261e65a306f3b"
]
},
{
"_index": "sw_product_1726772402",
"_type": "_doc",
"_id": "019091fcb76b73f2b8a8bd7087b778e5",
"_score": null,
"_source": {
"autoIncrement": 7869.0,
"id": "019091fcb76b73f2b8a8bd7087b778e5"
},
"fields": {
"displayGroup": [
"a2608a6b8f2730445d3f581e4b6e8bdb"
]
},
"sort": [
"sicherheitsstiefel s3 \"airpower xr3\" workwear",
"019091fcb76b73f2b8a8bd7087b778e5"
]
},
{
"_index": "sw_product_1726772402",
"_type": "_doc",
"_id": "01909200844e716b92b257679740b5bb",
"_score": null,
"_source": {
"autoIncrement": 9144.0,
"id": "01909200844e716b92b257679740b5bb"
},
"fields": {
"displayGroup": [
"c2e53587cbda458433c6cb5d9ccf6a22"
]
},
"sort": [
"sicherheitsstiefel s3 \"airpower xr3\" workwear ",
"01909200844e716b92b257679740b5bb"
]
},
{
"_index": "sw_product_1726772402",
"_type": "_doc",
"_id": "019091fec2737039bb724d9fe40ede0e",
"_score": null,
"_source": {
"autoIncrement": 8617.0,
"id": "019091fec2737039bb724d9fe40ede0e"
},
"fields": {
"displayGroup": [
"3455857ed788eb40c8ba5dadcc4f67c4"
]
},
"sort": [
"sicherheitsstiefel s3 \"thermo tech 800\" ",
"019091fec2737039bb724d9fe40ede0e"
]
},
{
"_index": "sw_product_1726772402",
"_type": "_doc",
"_id": "0190831878bf7350812f9cea586a7d70",
"_score": null,
"_source": {
"autoIncrement": 2003.0,
"id": "0190831878bf7350812f9cea586a7d70"
},
"fields": {
"displayGroup": [
"1f4037a9d9fe7bbbd040d4f6f04c5032"
]
},
"sort": [
"winter sicherheitsstiefel s3 \"bering bis\" ",
"0190831878bf7350812f9cea586a7d70"
]
},
{
"_index": "sw_product_1726772402",
"_type": "_doc",
"_id": "019091fc9d21713fb753402f2ec32d87",
"_score": null,
"_source": {
"autoIncrement": 7830.0,
"id": "019091fc9d21713fb753402f2ec32d87"
},
"fields": {
"displayGroup": [
"6580eebe83c8df89bb05ba3b47dfe513"
]
},
"sort": [
"winter-sicherheitsstiefel s3 \"nordholz\" ",
"019091fc9d21713fb753402f2ec32d87"
]
}
]
},
"aggregations": {
"total-count": {
"value": 13
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
2 |
5.38 ms |
Request:
{"index":"sw_product","body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"018aa81ce101726a9439817685a207b7"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"018e1955724a7a36a7270a75db2b7110"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}},{"bool":{"should":[{"bool":{"must":[{"nested":{"path":"parent.swagDynamicAccessRules","query":{"terms":{"parent.swagDynamicAccessRules.id":["0189e51498b172ffaba28fb1e58dee02","0189e514995d71cdace03f1dbda1f1f6","0189e514cec07203af0b602d25cfe21d","01910d9b14ee709cb429be0ad075e8aa","3858957016644de4ae48c0500bf3ccc8","e1378db7808a478f919e0d740d5d6c1a","018aa881a98878e58932a7721e054d1a","018f7b1212d571aa9aefd8cfc5126bd3","01909b60cbda73faaad9bb30a2d6711a"]}}}},{"nested":{"path":"swagDynamicAccessRules","query":{"bool":{"must_not":[{"exists":{"field":"swagDynamicAccessRules.id"}}]}}}}]}},{"nested":{"path":"swagDynamicAccessRules","query":{"terms":{"swagDynamicAccessRules.id":["0189e51498b172ffaba28fb1e58dee02","0189e514995d71cdace03f1dbda1f1f6","0189e514cec07203af0b602d25cfe21d","01910d9b14ee709cb429be0ad075e8aa","3858957016644de4ae48c0500bf3ccc8","e1378db7808a478f919e0d740d5d6c1a","018aa881a98878e58932a7721e054d1a","018f7b1212d571aa9aefd8cfc5126bd3","01909b60cbda73faaad9bb30a2d6711a"]}}}},{"bool":{"must":[{"nested":{"path":"parent.swagDynamicAccessRules","query":{"bool":{"must_not":[{"exists":{"field":"parent.swagDynamicAccessRules.id"}}]}}}},{"nested":{"path":"swagDynamicAccessRules","query":{"bool":{"must_not":[{"exists":{"field":"swagDynamicAccessRules.id"}}]}}}}]}}]}}]}}]}},"aggregations":{"manufacturer":{"terms":{"field":"manufacturerId","size":10000}},"price":{"stats":{"script":{"id":"cheapest_price","params":{"accessors":[{"key":"cheapest_price_rule0189e51498b172ffaba28fb1e58dee02_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189e514995d71cdace03f1dbda1f1f6_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189e514cec07203af0b602d25cfe21d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule01910d9b14ee709cb429be0ad075e8aa_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule3858957016644de4ae48c0500bf3ccc8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rulee1378db7808a478f919e0d740d5d6c1a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule018aa881a98878e58932a7721e054d1a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule018f7b1212d571aa9aefd8cfc5126bd3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule01909b60cbda73faaad9bb30a2d6711a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","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"}}
{
"took": 3,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 179,
"relation": "eq"
},
"max_score": null,
"hits": []
},
"aggregations": {
"shipping-free-filter": {
"doc_count": 0,
"shipping-free": {
"value": null
}
},
"rating-exists": {
"doc_count": 179,
"rating": {
"value": 0.0
}
},
"price": {
"count": 179,
"min": 13.85,
"max": 133.7,
"avg": 82.96536312849162,
"sum": 14850.8
},
"options": {
"doc_count": 179,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "019073767cf7719c8fe078106bd460a3",
"doc_count": 10
},
{
"key": "019073767cf871bdb3f75a7b2dfb9c8b",
"doc_count": 10
},
{
"key": "019073767cf871bdb3f75a7b333ba252",
"doc_count": 10
},
{
"key": "019073767cf973c699d5f64a9ccdff9c",
"doc_count": 10
},
{
"key": "019073767cf973c699d5f64aa344afbe",
"doc_count": 10
},
{
"key": "019073767cfa71de95b6d909c0edd802",
"doc_count": 10
},
{
"key": "019073767cfa71de95b6d909c74340fc",
"doc_count": 10
},
{
"key": "019073767cfb72789bd7754d77e2d66c",
"doc_count": 10
},
{
"key": "019073767cf7719c8fe078105e638ecb",
"doc_count": 9
},
{
"key": "019073767cfb72789bd7754d7d0df3c0",
"doc_count": 8
},
{
"key": "019073767cf67165ac3f6b6e1cff4e22",
"doc_count": 7
},
{
"key": "019073767cf5729ba58e994b29de23a2",
"doc_count": 3
},
{
"key": "019073767cf67165ac3f6b6e149517fd",
"doc_count": 3
},
{
"key": "019073767cfc728799874d85b598865e",
"doc_count": 3
},
{
"key": "019073767cfc728799874d85be46ca51",
"doc_count": 3
},
{
"key": "019073767d0c7399a21ba6ee80d9affd",
"doc_count": 3
},
{
"key": "019073767d0c7399a21ba6ee81d6e816",
"doc_count": 3
},
{
"key": "019073767d0c7399a21ba6ee839bc83a",
"doc_count": 3
},
{
"key": "019073767d0c7399a21ba6ee84e95edc",
"doc_count": 3
},
{
"key": "019073767d0c7399a21ba6ee857ea245",
"doc_count": 3
},
{
"key": "019073767d0c7399a21ba6ee867758d4",
"doc_count": 3
},
{
"key": "019073767d0c7399a21ba6ee8864df31",
"doc_count": 3
},
{
"key": "019073767d0c7399a21ba6ee8b365a68",
"doc_count": 3
},
{
"key": "019073767d0c7399a21ba6ee8e7ecd79",
"doc_count": 3
},
{
"key": "019073767d0c7399a21ba6ee8f100eae",
"doc_count": 3
},
{
"key": "019073767d0c7399a21ba6ee901aea69",
"doc_count": 3
},
{
"key": "019073767d0c7399a21ba6ee9096758a",
"doc_count": 3
},
{
"key": "019073767d0c7399a21ba6ee917238c3",
"doc_count": 3
},
{
"key": "019073767d0d737aba7b71a1837727da",
"doc_count": 3
},
{
"key": "019073767d0d737aba7b71a1844e313f",
"doc_count": 3
},
{
"key": "019073767d0d737aba7b71a185366db8",
"doc_count": 3
},
{
"key": "019073767d0d737aba7b71a18613ade0",
"doc_count": 3
},
{
"key": "019073767d0d737aba7b71a187a1d66b",
"doc_count": 3
},
{
"key": "019073767d0d737aba7b71a1887eaba5",
"doc_count": 3
},
{
"key": "019073767d0d737aba7b71a18a4c733a",
"doc_count": 3
},
{
"key": "019073767d0c7399a21ba6ee8673bc7e",
"doc_count": 1
},
{
"key": "019073767d0c7399a21ba6ee86c7ef84",
"doc_count": 1
},
{
"key": "019073767d0c7399a21ba6ee89575825",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 1626,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "019073768ef2713cbf2339b6bb0e3a18",
"doc_count": 179
},
{
"key": "019073768b3a71388c83b4384ad11474",
"doc_count": 168
},
{
"key": "0190737690e171a7a23f58e01e1c61b4",
"doc_count": 125
},
{
"key": "018f047c9230742084f7620216000346",
"doc_count": 118
},
{
"key": "019073766dbb7206a44937ad6cc8c855",
"doc_count": 118
},
{
"key": "01907376651f7101ad085869c4193067",
"doc_count": 105
},
{
"key": "019073768fdf73c58eca6f55f3a01691",
"doc_count": 105
},
{
"key": "019073768ef1718b8e65f49884551f0c",
"doc_count": 95
},
{
"key": "01907376651f7101ad085869c36930c5",
"doc_count": 66
},
{
"key": "019073768fdf73c58eca6f55f402111b",
"doc_count": 62
},
{
"key": "01907376955d708a870530bd2ffc1beb",
"doc_count": 58
},
{
"key": "01907376955d708a870530bd2eee22a9",
"doc_count": 50
},
{
"key": "019073766d82739a98293eed34b76892",
"doc_count": 42
},
{
"key": "0190737677e2701ebb9150dad3238613",
"doc_count": 40
},
{
"key": "0190737665df73ac86c1184179233d6e",
"doc_count": 38
},
{
"key": "019073766c3d708d93ffd1ca42aaed41",
"doc_count": 23
},
{
"key": "019073768ef2713cbf2339b6c5045466",
"doc_count": 23
},
{
"key": "0190737677df7082a4f0d250d133b479",
"doc_count": 15
},
{
"key": "0190737677df7082a4f0d250d2390204",
"doc_count": 15
},
{
"key": "0190737677d9709a8a94e880b4a96dcd",
"doc_count": 13
},
{
"key": "0190737690e171a7a23f58e01dac8942",
"doc_count": 13
},
{
"key": "0190737693c671c188f13d8f3e569939",
"doc_count": 13
},
{
"key": "0190737677e072cc8fa892ec0228d1b1",
"doc_count": 12
},
{
"key": "018f047bdfa87eacb5f6ff97ed5d0017",
"doc_count": 11
},
{
"key": "019073766d8b7393b72c5e6013acbdb6",
"doc_count": 11
},
{
"key": "0190737677d373a58ddadaabd9b3c988",
"doc_count": 11
},
{
"key": "0190737677dd73a5a8b960b7fa147672",
"doc_count": 11
},
{
"key": "019073768b3b7058911d187b559a9612",
"doc_count": 11
},
{
"key": "0190737690e171a7a23f58e01ebedc1c",
"doc_count": 11
},
{
"key": "0190737665df73ac86c1184178c1fdf1",
"doc_count": 10
},
{
"key": "0190737677e072cc8fa892ec004b5a49",
"doc_count": 10
},
{
"key": "0190737677e2701ebb9150dad1451e17",
"doc_count": 10
},
{
"key": "0190737690e171a7a23f58e01fa3d4b9",
"doc_count": 10
},
{
"key": "0190737677e072cc8fa892ebfe781cb2",
"doc_count": 8
},
{
"key": "0190737690e171a7a23f58e01dd563b1",
"doc_count": 8
},
{
"key": "2bfd278e87204807a890da4a3e81dd90",
"doc_count": 8
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "018f7715e8927b79861849d42565f20b",
"doc_count": 63
},
{
"key": "018f770cd4ec79b79de73c8e9ea3293f",
"doc_count": 42
},
{
"key": "018f770ee98078a1b058524b23d16f16",
"doc_count": 23
},
{
"key": "018f7714bab274f08b09bb711bf019e0",
"doc_count": 10
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|