| 1 |
3.19 ms |
Request:
{"index":"sw_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":"250c23c94a704f8ba1b4819c38901688"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"0b0b7f4e3e2e495bab3ce3e84353ec53"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"sort":[{"_script":{"type":"number","script":{"source":"def languages = params['languages'];\ndef suffix = params.containsKey('suffix') ? '.' + params['suffix'] : '';\n\nfor (int i = 0; i < languages.length; i++) {\n def field_name = params['field'] + '.' + languages[i] + suffix;\n\n if (doc[field_name].size() > 0 && doc[field_name].value != null && doc[field_name].value.toString().length() > 0) {\n def fieldValue = doc[field_name].value;\n\n return fieldValue;\n }\n}\n\nif (params['order'] == 'asc') {\n return Double.MAX_VALUE;\n}\n\nreturn Double.MIN_VALUE;\n","lang":"painless","params":{"field":"customFields","languages":["2fbb5fe2e29a4d70aa5854ce7ce3e20b"],"suffix":"custom_product_rosland_set_year","order":"desc"}},"order":"DESC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":36,"size":36,"collapse":{"field":"displayGroup"},"timeout":"5s"}}
{
"took": 1,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 53,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_product_1717666750",
"_id": "351fc2823dd047e19f11f13de5cd06d2",
"_score": null,
"_source": {
"id": "351fc2823dd047e19f11f13de5cd06d2",
"autoIncrement": 3945.0
},
"fields": {
"displayGroup": [
"cf6b2eecc36510a30e5de09e0b1f2ce6"
]
},
"sort": [
2021.0,
"351fc2823dd047e19f11f13de5cd06d2"
]
},
{
"_index": "sw_product_1717666750",
"_id": "39c906445ecd4513a751b4964f27ab2c",
"_score": null,
"_source": {
"id": "39c906445ecd4513a751b4964f27ab2c",
"autoIncrement": 4066.0
},
"fields": {
"displayGroup": [
"99fa0f4fad2932f660fd24a7f160bada"
]
},
"sort": [
2021.0,
"39c906445ecd4513a751b4964f27ab2c"
]
},
{
"_index": "sw_product_1717666750",
"_id": "3c620072d6654babbe5a50e56af286eb",
"_score": null,
"_source": {
"id": "3c620072d6654babbe5a50e56af286eb",
"autoIncrement": 4068.0
},
"fields": {
"displayGroup": [
"5c03e66b0fac0248fc9ba106c199a194"
]
},
"sort": [
2021.0,
"3c620072d6654babbe5a50e56af286eb"
]
},
{
"_index": "sw_product_1717666750",
"_id": "436ddd9ed9f14041bba5c256ad709b30",
"_score": null,
"_source": {
"id": "436ddd9ed9f14041bba5c256ad709b30",
"autoIncrement": 3953.0
},
"fields": {
"displayGroup": [
"6c16b0e887ebc4a3ad5450d60a46bdc6"
]
},
"sort": [
2021.0,
"436ddd9ed9f14041bba5c256ad709b30"
]
},
{
"_index": "sw_product_1717666750",
"_id": "8461107f98ed49c5a60760cc506754b7",
"_score": null,
"_source": {
"id": "8461107f98ed49c5a60760cc506754b7",
"autoIncrement": 4065.0
},
"fields": {
"displayGroup": [
"801530738443b58f53ba29a94eedf8ec"
]
},
"sort": [
2021.0,
"8461107f98ed49c5a60760cc506754b7"
]
},
{
"_index": "sw_product_1717666750",
"_id": "8eed88e790704496ac1c737b88233833",
"_score": null,
"_source": {
"id": "8eed88e790704496ac1c737b88233833",
"autoIncrement": 4064.0
},
"fields": {
"displayGroup": [
"25608d425b7ba63260e795ab843e9533"
]
},
"sort": [
2021.0,
"8eed88e790704496ac1c737b88233833"
]
},
{
"_index": "sw_product_1717666750",
"_id": "a48b0941157044908c7d73c886f1736f",
"_score": null,
"_source": {
"id": "a48b0941157044908c7d73c886f1736f",
"autoIncrement": 4063.0
},
"fields": {
"displayGroup": [
"a34c8812607449c8de76f481214b9050"
]
},
"sort": [
2021.0,
"a48b0941157044908c7d73c886f1736f"
]
},
{
"_index": "sw_product_1717666750",
"_id": "f6de907cf5a14d1584babbcb44da0cb1",
"_score": null,
"_source": {
"id": "f6de907cf5a14d1584babbcb44da0cb1",
"autoIncrement": 4069.0
},
"fields": {
"displayGroup": [
"b72447b661b37798401495de92a045ed"
]
},
"sort": [
2021.0,
"f6de907cf5a14d1584babbcb44da0cb1"
]
},
{
"_index": "sw_product_1717666750",
"_id": "188e9dbc8f314a259c716a35cc208336",
"_score": null,
"_source": {
"id": "188e9dbc8f314a259c716a35cc208336",
"autoIncrement": 2383.0
},
"fields": {
"displayGroup": [
"cb6095dca8d47fdbd08f6c3034139602"
]
},
"sort": [
2020.0,
"188e9dbc8f314a259c716a35cc208336"
]
},
{
"_index": "sw_product_1717666750",
"_id": "30002b6b550b4a38b7e1f0ee05e8664f",
"_score": null,
"_source": {
"id": "30002b6b550b4a38b7e1f0ee05e8664f",
"autoIncrement": 4071.0
},
"fields": {
"displayGroup": [
"e5d37240cfacf485b7e3c8787aecb1a1"
]
},
"sort": [
2020.0,
"30002b6b550b4a38b7e1f0ee05e8664f"
]
},
{
"_index": "sw_product_1717666750",
"_id": "33e90dd2b0dc46be81f6c2d059523ae4",
"_score": null,
"_source": {
"id": "33e90dd2b0dc46be81f6c2d059523ae4",
"autoIncrement": 3776.0
},
"fields": {
"displayGroup": [
"2ba3aa253b9db6f52118c70cded3f154"
]
},
"sort": [
2020.0,
"33e90dd2b0dc46be81f6c2d059523ae4"
]
},
{
"_index": "sw_product_1717666750",
"_id": "6b2d3e35ad9d48b68e539c5a3e0c6863",
"_score": null,
"_source": {
"id": "6b2d3e35ad9d48b68e539c5a3e0c6863",
"autoIncrement": 3775.0
},
"fields": {
"displayGroup": [
"54ccdf44587ad4758cf334616f046079"
]
},
"sort": [
2020.0,
"6b2d3e35ad9d48b68e539c5a3e0c6863"
]
},
{
"_index": "sw_product_1717666750",
"_id": "9646b4e1f79d48a89a18ee1b0f0ed1d6",
"_score": null,
"_source": {
"id": "9646b4e1f79d48a89a18ee1b0f0ed1d6",
"autoIncrement": 4070.0
},
"fields": {
"displayGroup": [
"09f96bd341f1a2656744a22e1b91e4ce"
]
},
"sort": [
2020.0,
"9646b4e1f79d48a89a18ee1b0f0ed1d6"
]
},
{
"_index": "sw_product_1717666750",
"_id": "ae7b806109b64ebfbf5ed71f1f3072af",
"_score": null,
"_source": {
"id": "ae7b806109b64ebfbf5ed71f1f3072af",
"autoIncrement": 3777.0
},
"fields": {
"displayGroup": [
"fd435fff4c4ce3ce1c48deb73de62310"
]
},
"sort": [
2020.0,
"ae7b806109b64ebfbf5ed71f1f3072af"
]
},
{
"_index": "sw_product_1717666750",
"_id": "f2d05fc90dc64f189bba12f377054187",
"_score": null,
"_source": {
"id": "f2d05fc90dc64f189bba12f377054187",
"autoIncrement": 3233.0
},
"fields": {
"displayGroup": [
"a5292235ec6a48c92a3775ea21b63855"
]
},
"sort": [
2020.0,
"f2d05fc90dc64f189bba12f377054187"
]
},
{
"_index": "sw_product_1717666750",
"_id": "fc94cac7673647d286bdff9ce9d0cfbc",
"_score": null,
"_source": {
"id": "fc94cac7673647d286bdff9ce9d0cfbc",
"autoIncrement": 4072.0
},
"fields": {
"displayGroup": [
"0e3da07ce381369510204482c01e7269"
]
},
"sort": [
2020.0,
"fc94cac7673647d286bdff9ce9d0cfbc"
]
},
{
"_index": "sw_product_1717666750",
"_id": "018aac82466a730f8f05e1ab42f20303",
"_score": null,
"_source": {
"id": "018aac82466a730f8f05e1ab42f20303",
"autoIncrement": 4583.0
},
"fields": {
"displayGroup": [
"524dd0a668d0f00de697544f9d7fc5cb"
]
},
"sort": [
2006.0,
"018aac82466a730f8f05e1ab42f20303"
]
}
]
},
"aggregations": {
"total-count": {
"value": 53
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
1.48 ms |
Request:
{"index":"sw_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":"250c23c94a704f8ba1b4819c38901688"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"0b0b7f4e3e2e495bab3ce3e84353ec53"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"aggregations":{"manufacturer":{"terms":{"field":"manufacturerId","size":10000}},"price":{"stats":{"script":{"source":"double getPrice(def accessors, def doc, def decimals, def round, def multiplier) {\n for (accessor in accessors) {\n def key = accessor['key'];\n\n if (!doc.containsKey(key) || doc[key].empty) {\n continue;\n }\n\n def factor = accessor['factor'];\n def value = doc[key].value * factor;\n\n value = Math.round(value * decimals);\n value = (double) value \/ decimals;\n\n if (!round) {\n return (double) value;\n }\n\n value = Math.round(value * multiplier);\n\n value = (double) value \/ multiplier;\n\n return (double) value;\n }\n\n return 0;\n}\n\nreturn getPrice(params['accessors'], doc, params['decimals'], params['round'], params['multiplier']);\n","lang":"painless","params":{"accessors":[{"key":"cheapest_price_rule64bf19224e314563aba24460dda765f8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule89d3fe06bd7c478194fe9179a9602df5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruled980a6dfc7774cd192e0b1a183764274_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01961afbc995737796b164a7b5355b5d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01961afbca2673cf9fb2d67da0cd8a62_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule0197e9e4d10e7293b705c1d0eee95b29_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule0197e9e4d446718a91aafc7b03ab341a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule6235b68395cd475f90278d41d7b1b36c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruleac5af03b5965434681e7c4cb42720d2b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulecc1de6f5416545d3a68a00f78e8f20f3_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": 0,
"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": 53,
"rating": {
"value": 0.0
}
},
"price": {
"count": 53,
"min": 3.57,
"max": 1558.39,
"avg": 94.69037735849057,
"sum": 5018.59
},
"options": {
"doc_count": 0,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": []
}
},
"properties": {
"doc_count": 761,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "d3cfb18b53ee4a4486a2f4d64f53934f",
"doc_count": 53
},
{
"key": "de88ad12fea44d74b9c2a1f1edf7ecdf",
"doc_count": 53
},
{
"key": "048b41590faf47549a3f88e1737c9144",
"doc_count": 52
},
{
"key": "8cf95386ad3f4cbc911c3258b1a3fbde",
"doc_count": 52
},
{
"key": "bb2aca011dc44badab027fb55a1ec97b",
"doc_count": 52
},
{
"key": "45018ee86cc84c47b8d18583215e11fb",
"doc_count": 51
},
{
"key": "b81318b1758e42bc8be1559a7f6df0bc",
"doc_count": 33
},
{
"key": "c00d09ec51844aefa2781fcc00839644",
"doc_count": 30
},
{
"key": "50bede51bbaa4f4aba7003a45cf998b3",
"doc_count": 22
},
{
"key": "8a6ac1662b934451b6e3bc6e665c3bea",
"doc_count": 16
},
{
"key": "63edad6641f44fbb9149528017bf8d0d",
"doc_count": 15
},
{
"key": "674eeda781014bc7b35fe9b6e2849616",
"doc_count": 15
},
{
"key": "8e630823e6b940e88db3ec45984e9c63",
"doc_count": 15
},
{
"key": "256aa072d598469cbe2a99d63859b36e",
"doc_count": 14
},
{
"key": "d0c07ddcae6a4425b96e363887660b9f",
"doc_count": 14
},
{
"key": "d7835742aa644750b59473d1d473ccf7",
"doc_count": 14
},
{
"key": "f3addfa0aa8f492b93ef4d41f76ff1fd",
"doc_count": 14
},
{
"key": "5ab38019ed7843e7b3b2218c5a19e933",
"doc_count": 11
},
{
"key": "5b8f5b04a97b47e2b04efe565e99a70a",
"doc_count": 11
},
{
"key": "6f92af8d0f0a4ae99239c1bd9f68d3d3",
"doc_count": 11
},
{
"key": "97e91b44c63045459a74bf3a7637a658",
"doc_count": 11
},
{
"key": "a5474d0593844b66a1240fdcdc0b9953",
"doc_count": 11
},
{
"key": "c1d70719badf4382b9dabd1bb5a380bf",
"doc_count": 11
},
{
"key": "01928a7829d67d639ecf3241a302231e",
"doc_count": 10
},
{
"key": "63003514bc4246e8a23e7606ca7f515d",
"doc_count": 10
},
{
"key": "7441f3c736e44d829df17973e24e150c",
"doc_count": 10
},
{
"key": "7d8ad8823f454b6985e477453c0e195b",
"doc_count": 10
},
{
"key": "b57d1d0eb833459bbda07a3adca6714c",
"doc_count": 10
},
{
"key": "b8dd631079d34d42b559a3eb42f6cfa6",
"doc_count": 8
},
{
"key": "beb3700040e8485a9994e2820548b7e6",
"doc_count": 8
},
{
"key": "ca0798b913784ff9880ac954d5b61825",
"doc_count": 8
},
{
"key": "c7cc8a656cf841ca898ab1f1ad507138",
"doc_count": 7
},
{
"key": "f06e9cb8ae034829b52292d1dc937b5f",
"doc_count": 7
},
{
"key": "3c2db6395a33412b8c6890ac992b94ea",
"doc_count": 6
},
{
"key": "477ed0ba0c3c41cb824e1b100fa514e4",
"doc_count": 6
},
{
"key": "79709bed515d4a1593cdc09df948021e",
"doc_count": 6
},
{
"key": "85007d00dbb3447c90183857550eb42a",
"doc_count": 6
},
{
"key": "05562f74e05a4ac8b043a602c3d29b33",
"doc_count": 5
},
{
"key": "437945a836cd45e0a9f0d5265ed07c9c",
"doc_count": 5
},
{
"key": "454a5b55c34244a3bbabb5b80faf589c",
"doc_count": 5
},
{
"key": "7f0f1ba818a847638754a338f5381646",
"doc_count": 5
},
{
"key": "815603eeacfd418fb360ad2e9469c0b1",
"doc_count": 5
},
{
"key": "94dd585006d04491a0204de65ff0b85e",
"doc_count": 5
},
{
"key": "bcfd8dff179149088e720a4ff4527e56",
"doc_count": 5
},
{
"key": "2f71c6ffbd5a4138a05a054799dc6b4e",
"doc_count": 4
},
{
"key": "1a6f7887106e4fb2bcf5bcd7d4f95b79",
"doc_count": 3
},
{
"key": "cce1e9f6f74d4013b63a51eac20d12dc",
"doc_count": 3
},
{
"key": "27e5bf7420c14d1e82c251f92742efbd",
"doc_count": 2
},
{
"key": "38e8473f07354461a08b4a6851c0bb65",
"doc_count": 2
},
{
"key": "5d37ddbc6c4e43b484ae23e227fd1637",
"doc_count": 2
},
{
"key": "65798a73c7e44bcdbe0b0f0b53116c84",
"doc_count": 2
},
{
"key": "af0166d26c6a421bbf4b37c35b1f5636",
"doc_count": 2
},
{
"key": "fa4d302b3fd54418899166bcabe83011",
"doc_count": 2
},
{
"key": "0b764a915436467e9c6fe52c9c0c3871",
"doc_count": 1
},
{
"key": "0c189ea565ab4573a222115adc6b9258",
"doc_count": 1
},
{
"key": "33a6b259d7944757808f958567245fb9",
"doc_count": 1
},
{
"key": "54ca4312c29b41349a560906e2284912",
"doc_count": 1
},
{
"key": "59e1857b1afd4723bb1349a45de3c652",
"doc_count": 1
},
{
"key": "69c4d4228f384f6781872c615bff9d88",
"doc_count": 1
},
{
"key": "88aa9298b63b43fc94db7c0ebb483c22",
"doc_count": 1
},
{
"key": "b0fd24cfb9784ab4a1236ab5ece09415",
"doc_count": 1
},
{
"key": "bfeb3a8f47334625946a49780d00db95",
"doc_count": 1
},
{
"key": "de9dd8e6f87942da83e00cc6769b431f",
"doc_count": 1
},
{
"key": "f7fcd5b43919408abc47ad22817057e8",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "0c6346a583ce4d0c93a8911b89371b9a",
"doc_count": 53
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|