1 |
12.86 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":"018e1955170e782f9bec98b453f57640"}}}},{"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": 9,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 88,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_product_1726772402",
"_type": "_doc",
"_id": "019091ff1d1c70469774ff30d886761c",
"_score": null,
"_source": {
"autoIncrement": 8725.0,
"id": "019091ff1d1c70469774ff30d886761c"
},
"fields": {
"displayGroup": [
"606a5337019dd8e497e220946f1d184a"
]
},
"sort": [
"industrie-nitrilhandschuhe \"basic\" blau teilbeschichtet",
"019091ff1d1c70469774ff30d886761c"
]
},
{
"_index": "sw_product_1726772402",
"_type": "_doc",
"_id": "01908317c3bf73f986b643be673211f8",
"_score": null,
"_source": {
"autoIncrement": 1737.0,
"id": "01908317c3bf73f986b643be673211f8"
},
"fields": {
"displayGroup": [
"38bc2cc5c6aaba310c6d559e2720b3b6"
]
},
"sort": [
"latex-baumwoll-strickhandschuhe 1603w \"winterblocker\"",
"01908317c3bf73f986b643be673211f8"
]
},
{
"_index": "sw_product_1726772402",
"_type": "_doc",
"_id": "019091fc642a721eae437afcb1320f75",
"_score": null,
"_source": {
"autoIncrement": 7777.0,
"id": "019091fc642a721eae437afcb1320f75"
},
"fields": {
"displayGroup": [
"d706e85cc135f8de54cc1d3253a9d660"
]
},
"sort": [
"latex-chemikalienschutz-handschuhe \"s-blue+\" ger.",
"019091fc642a721eae437afcb1320f75"
]
},
{
"_index": "sw_product_1726772402",
"_type": "_doc",
"_id": "019082dc818a7352b1ee8417c0e36b21",
"_score": null,
"_source": {
"autoIncrement": 663.0,
"id": "019082dc818a7352b1ee8417c0e36b21"
},
"fields": {
"displayGroup": [
"33fb1db7c9f3cf131c17500f017afedf"
]
},
"sort": [
"nappavollleder-arbeitshandschuhe \"fahrer\" natur",
"019082dc818a7352b1ee8417c0e36b21"
]
},
{
"_index": "sw_product_1726772402",
"_type": "_doc",
"_id": "0190920020d2728581d501545e1bc549",
"_score": null,
"_source": {
"autoIncrement": 9040.0,
"id": "0190920020d2728581d501545e1bc549"
},
"fields": {
"displayGroup": [
"8276d4fad69e42923242d3cc249118a6"
]
},
"sort": [
"nitril baumwoll arbeitshandschuhe \"3400\" gelb",
"0190920020d2728581d501545e1bc549"
]
},
{
"_index": "sw_product_1726772402",
"_type": "_doc",
"_id": "0190920034bd7025914dc1213ec76a59",
"_score": null,
"_source": {
"autoIncrement": 9053.0,
"id": "0190920034bd7025914dc1213ec76a59"
},
"fields": {
"displayGroup": [
"d1bf8eadce1c01249960d5dff093e521"
]
},
"sort": [
"nitril baumwoll arbeitshandschuhe \"3400v\" gelb vollbeschichtet",
"0190920034bd7025914dc1213ec76a59"
]
},
{
"_index": "sw_product_1726772402",
"_type": "_doc",
"_id": "019092003bac700088ebcafd47bed9e9",
"_score": null,
"_source": {
"autoIncrement": 9059.0,
"id": "019092003bac700088ebcafd47bed9e9"
},
"fields": {
"displayGroup": [
"c7b050ec8cd625ec7b816962114f5f29"
]
},
"sort": [
"nitril baumwoll industriehandschuhe \"03430\" blau",
"019092003bac700088ebcafd47bed9e9"
]
},
{
"_index": "sw_product_1726772402",
"_type": "_doc",
"_id": "0190831c7c96722ea505fcb4c3eba6d9",
"_score": null,
"_source": {
"autoIncrement": 3689.0,
"id": "0190831c7c96722ea505fcb4c3eba6d9"
},
"fields": {
"displayGroup": [
"5a6cf0537327b23ea4b2f7ac5cbad810"
]
},
"sort": [
"nitril-arbeitshandschuhe \"basic\" gelb",
"0190831c7c96722ea505fcb4c3eba6d9"
]
},
{
"_index": "sw_product_1726772402",
"_type": "_doc",
"_id": "019096ce1c647207b326b839b19c991d",
"_score": null,
"_source": {
"autoIncrement": 10278.0,
"id": "019096ce1c647207b326b839b19c991d"
},
"fields": {
"displayGroup": [
"a618abbbfcd8668141de7a0df9da8f62"
]
},
"sort": [
"nylon-montagehandschuhe \"comfort-one\"",
"019096ce1c647207b326b839b19c991d"
]
},
{
"_index": "sw_product_1726772402",
"_type": "_doc",
"_id": "019091fc6fdf71a198985d31b65bba6c",
"_score": null,
"_source": {
"autoIncrement": 7789.0,
"id": "019091fc6fdf71a198985d31b65bba6c"
},
"fields": {
"displayGroup": [
"97eb828ae0e16e2b944eb9e5e81b582e"
]
},
"sort": [
"nylonhandschuhe nitrilbeschichtet \"oil grip\"",
"019091fc6fdf71a198985d31b65bba6c"
]
},
{
"_index": "sw_product_1726772402",
"_type": "_doc",
"_id": "019091fc6a497283902f28fc498d9475",
"_score": null,
"_source": {
"autoIncrement": 7783.0,
"id": "019091fc6a497283902f28fc498d9475"
},
"fields": {
"displayGroup": [
"0ea383922e169dba50986247497fb7c8"
]
},
"sort": [
"polyester-montagehandschuhe \"gripstar\" latex",
"019091fc6a497283902f28fc498d9475"
]
},
{
"_index": "sw_product_1726772402",
"_type": "_doc",
"_id": "019092002d08731c97addb9afe5d0e48",
"_score": null,
"_source": {
"autoIncrement": 9046.0,
"id": "019092002d08731c97addb9afe5d0e48"
},
"fields": {
"displayGroup": [
"aa1a2d2fbebaf4476cac89c9f97707d4"
]
},
"sort": [
"pu nylon montagehandschuhe \"6205\" grau",
"019092002d08731c97addb9afe5d0e48"
]
},
{
"_index": "sw_product_1726772402",
"_type": "_doc",
"_id": "019092001a1970c5852108961d570a90",
"_score": null,
"_source": {
"autoIncrement": 9033.0,
"id": "019092001a1970c5852108961d570a90"
},
"fields": {
"displayGroup": [
"a2f4255583b5ec6c432184d7455c1255"
]
},
"sort": [
"pu nylon montagehandschuhe \"6215\" schwarz",
"019092001a1970c5852108961d570a90"
]
},
{
"_index": "sw_product_1726772402",
"_type": "_doc",
"_id": "019091fddd6572b39621372abaef2133",
"_score": null,
"_source": {
"autoIncrement": 8280.0,
"id": "019091fddd6572b39621372abaef2133"
},
"fields": {
"displayGroup": [
"3e2cd3529d6e6e6f82fcf9a6ed041c69"
]
},
"sort": [
"pvc-chemikalienschutzhandschuhe rot | 35cm",
"019091fddd6572b39621372abaef2133"
]
},
{
"_index": "sw_product_1726772402",
"_type": "_doc",
"_id": "019091fde26773baa8bd9d3b01c60340",
"_score": null,
"_source": {
"autoIncrement": 8283.0,
"id": "019091fde26773baa8bd9d3b01c60340"
},
"fields": {
"displayGroup": [
"7913bb115d40bc1c45c394e883628206"
]
},
"sort": [
"pvc-chemikalienschutzhandschuhe rot | 40cm",
"019091fde26773baa8bd9d3b01c60340"
]
},
{
"_index": "sw_product_1726772402",
"_type": "_doc",
"_id": "019091fde73a70c1a8722f98e1bb4935",
"_score": null,
"_source": {
"autoIncrement": 8285.0,
"id": "019091fde73a70c1a8722f98e1bb4935"
},
"fields": {
"displayGroup": [
"4b32ae927b8660e23a06bc8311d225f2"
]
},
"sort": [
"pvc-chemikalienschutzhandschuhe rot | 58cm",
"019091fde73a70c1a8722f98e1bb4935"
]
},
{
"_index": "sw_product_1726772402",
"_type": "_doc",
"_id": "019091fc7ca07120b1a78c97f9a54489",
"_score": null,
"_source": {
"autoIncrement": 7801.0,
"id": "019091fc7ca07120b1a78c97f9a54489"
},
"fields": {
"displayGroup": [
"c3fb5c8b9937fc5d253d0d55d611de30"
]
},
"sort": [
"rindvollleder-arbeitshandschuhe \"eisb\u00e4r\" ",
"019091fc7ca07120b1a78c97f9a54489"
]
},
{
"_index": "sw_product_1726772402",
"_type": "_doc",
"_id": "019091fc75a273a4a138760a09a44799",
"_score": null,
"_source": {
"autoIncrement": 7795.0,
"id": "019091fc75a273a4a138760a09a44799"
},
"fields": {
"displayGroup": [
"405ea43f654dd9abcc6d58e4f6ba06ff"
]
},
"sort": [
"rindvollleder-arbeitshandschuhe \"zeus\"",
"019091fc75a273a4a138760a09a44799"
]
},
{
"_index": "sw_product_1726772402",
"_type": "_doc",
"_id": "019091fc898c7348831a6aa86c87f346",
"_score": null,
"_source": {
"autoIncrement": 7814.0,
"id": "019091fc898c7348831a6aa86c87f346"
},
"fields": {
"displayGroup": [
"e6e137df36d6e65235800ebe7cfcd62d"
]
},
"sort": [
"winter-arbeitshandschuhe 7390 pvc, gef\u00fctt.",
"019091fc898c7348831a6aa86c87f346"
]
},
{
"_index": "sw_product_1726772402",
"_type": "_doc",
"_id": "019091fc8dad7160b5867e224a2c9730",
"_score": null,
"_source": {
"autoIncrement": 7816.0,
"id": "019091fc8dad7160b5867e224a2c9730"
},
"fields": {
"displayGroup": [
"f39539bb530c7e820115ff29c951b514"
]
},
"sort": [
"winter-arbeitshandschuhe 9232 m.neopren",
"019091fc8dad7160b5867e224a2c9730"
]
}
]
},
"aggregations": {
"total-count": {
"value": 20
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
2 |
7.88 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":"018e1955170e782f9bec98b453f57640"}}}},{"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": 88,
"relation": "eq"
},
"max_score": null,
"hits": []
},
"aggregations": {
"shipping-free-filter": {
"doc_count": 0,
"shipping-free": {
"value": null
}
},
"rating-exists": {
"doc_count": 88,
"rating": {
"value": 0.0
}
},
"price": {
"count": 88,
"min": 0.69,
"max": 25.2,
"avg": 3.378522727272727,
"sum": 297.31
},
"options": {
"doc_count": 87,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "019073767ced71fc9e928ee63717046a",
"doc_count": 19
},
{
"key": "019073767d0471db8d67879a0bfeb9cd",
"doc_count": 18
},
{
"key": "019073767ced71fc9e928ee64510a148",
"doc_count": 16
},
{
"key": "019073767d0272e78c6187715c102947",
"doc_count": 16
},
{
"key": "019073767d007101a594f06c566a0f3f",
"doc_count": 11
},
{
"key": "019073767cfe712b92e7ec77aeb37bbc",
"doc_count": 4
},
{
"key": "019073767cee716e92929d5b33b7cbd6",
"doc_count": 3
}
]
}
},
"properties": {
"doc_count": 594,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "019073768ef2713cbf2339b6c07b02b2",
"doc_count": 78
},
{
"key": "019073766b767259a373231ebaa75654",
"doc_count": 60
},
{
"key": "019073768ef2713cbf2339b6c1db5064",
"doc_count": 42
},
{
"key": "01907376691573b0b0cba55c2f0aa5e5",
"doc_count": 34
},
{
"key": "01907376645472ca9b7c9fee2957def1",
"doc_count": 32
},
{
"key": "0190737691ae73f8bf42e635f11b872b",
"doc_count": 31
},
{
"key": "01907376677873d6a559f6096e674044",
"doc_count": 29
},
{
"key": "0190737691ae73f8bf42e636017e4f73",
"doc_count": 24
},
{
"key": "01907376645472ca9b7c9fee2aaf58a6",
"doc_count": 19
},
{
"key": "0190737666ac71c59dfb42df63d12d8a",
"doc_count": 19
},
{
"key": "019073766a4e72e69b23197ab50f080e",
"doc_count": 19
},
{
"key": "0190737668427057b18ce0b529dda9d3",
"doc_count": 16
},
{
"key": "01907376645472ca9b7c9fee27fc1c61",
"doc_count": 14
},
{
"key": "0190737665df73ac86c1184177063e89",
"doc_count": 14
},
{
"key": "019073768ef2713cbf2339b6c4396abf",
"doc_count": 14
},
{
"key": "019073766b767259a373231ebb95d18e",
"doc_count": 13
},
{
"key": "0190737668427057b18ce0b528eb2620",
"doc_count": 12
},
{
"key": "0190737666ac71c59dfb42df6430f044",
"doc_count": 10
},
{
"key": "019073766a4e72e69b23197ab5c8e28b",
"doc_count": 10
},
{
"key": "0190737691ae73f8bf42e635fa502d00",
"doc_count": 10
},
{
"key": "0190737666ac71c59dfb42df635ea579",
"doc_count": 9
},
{
"key": "01907376677873d6a559f6096e09c3fa",
"doc_count": 9
},
{
"key": "0190737691af73a1a4d3761960699394",
"doc_count": 9
},
{
"key": "019073768558717bb9854035a8c4571c",
"doc_count": 6
},
{
"key": "019073768ef2713cbf2339b6c0404dfd",
"doc_count": 6
},
{
"key": "0190737665df73ac86c1184178b39f17",
"doc_count": 5
},
{
"key": "0190737668427057b18ce0b52a570635",
"doc_count": 5
},
{
"key": "0190737668427057b18ce0b52ab9234f",
"doc_count": 5
},
{
"key": "019073766a4e72e69b23197ab62b8523",
"doc_count": 5
},
{
"key": "01907376825272b8a2dff0dca4112841",
"doc_count": 5
},
{
"key": "01907376855770898ab8fc2fd15830be",
"doc_count": 5
},
{
"key": "019073768558717bb9854035a497c13d",
"doc_count": 5
},
{
"key": "0190737691ae73f8bf42e6360044fbb3",
"doc_count": 5
},
{
"key": "01907376691671b588917d697f37d2a3",
"doc_count": 4
},
{
"key": "019073766a4e72e69b23197ab539bbc6",
"doc_count": 4
},
{
"key": "0190737691af73a1a4d376196470f3cb",
"doc_count": 4
},
{
"key": "01907376645472ca9b7c9fee2b7c9952",
"doc_count": 1
},
{
"key": "01907376825272b8a2dff0dca1e85978",
"doc_count": 1
},
{
"key": "019073768558717bb9854035abc8187f",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "018f771b5b187018916cc24329317016",
"doc_count": 45
},
{
"key": "018f772144df7b72afd13349779485fc",
"doc_count": 14
},
{
"key": "018f77211af571a1a05df1b9d3ffd248",
"doc_count": 6
},
{
"key": "018f7720d55a7aa8b94631917c26410a",
"doc_count": 5
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|