| 1 |
2.40 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":"f82770d911a04c3caf1e29b5cbf8a156"}}}},{"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":72,"size":36,"collapse":{"field":"displayGroup"},"timeout":"5s"}}
{
"took": 1,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 82,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_product_1717666750",
"_id": "b464f8fab08e4a0cb00c6e76ff7dfdf7",
"_score": null,
"_source": {
"id": "b464f8fab08e4a0cb00c6e76ff7dfdf7",
"autoIncrement": 663.0
},
"fields": {
"displayGroup": [
"80d8628792b108b095d0a01f790e7ad5"
]
},
"sort": [
1998.0,
"b464f8fab08e4a0cb00c6e76ff7dfdf7"
]
},
{
"_index": "sw_product_1717666750",
"_id": "0df9b1ca2fe24ce2983324e453cb305a",
"_score": null,
"_source": {
"id": "0df9b1ca2fe24ce2983324e453cb305a",
"autoIncrement": 661.0
},
"fields": {
"displayGroup": [
"1642394fcd71d65e519180f8d8108903"
]
},
"sort": [
1997.0,
"0df9b1ca2fe24ce2983324e453cb305a"
]
},
{
"_index": "sw_product_1717666750",
"_id": "3ba2810b926b4cf9a66ca9c1618c0ae0",
"_score": null,
"_source": {
"id": "3ba2810b926b4cf9a66ca9c1618c0ae0",
"autoIncrement": 659.0
},
"fields": {
"displayGroup": [
"0e7b0cc5765e660dea2ed1fa0b2e0884"
]
},
"sort": [
1997.0,
"3ba2810b926b4cf9a66ca9c1618c0ae0"
]
},
{
"_index": "sw_product_1717666750",
"_id": "47984f2b6a6f4b709fce712c83f11cd6",
"_score": null,
"_source": {
"id": "47984f2b6a6f4b709fce712c83f11cd6",
"autoIncrement": 1604.0
},
"fields": {
"displayGroup": [
"34a36eabed418cab5dbcab3b23e8d79b"
]
},
"sort": [
1997.0,
"47984f2b6a6f4b709fce712c83f11cd6"
]
},
{
"_index": "sw_product_1717666750",
"_id": "29b6ab8c14f94fb291539ff7f42e5aa1",
"_score": null,
"_source": {
"id": "29b6ab8c14f94fb291539ff7f42e5aa1",
"autoIncrement": 3116.0
},
"fields": {
"displayGroup": [
"94ae7dd2ba4b34b268a66989b9142bfd"
]
},
"sort": [
1996.0,
"29b6ab8c14f94fb291539ff7f42e5aa1"
]
},
{
"_index": "sw_product_1717666750",
"_id": "e6dd1416bd554f26b339e55bb9812ca8",
"_score": null,
"_source": {
"id": "e6dd1416bd554f26b339e55bb9812ca8",
"autoIncrement": 3117.0
},
"fields": {
"displayGroup": [
"abfa0053825961f493f0ee3d5067b3e7"
]
},
"sort": [
1995.0,
"e6dd1416bd554f26b339e55bb9812ca8"
]
},
{
"_index": "sw_product_1717666750",
"_id": "554ab0a054814153b351b2caa29a4eb7",
"_score": null,
"_source": {
"id": "554ab0a054814153b351b2caa29a4eb7",
"autoIncrement": 1605.0
},
"fields": {
"displayGroup": [
"e4965116ddcef587f21b38772476ae06"
]
},
"sort": [
1994.0,
"554ab0a054814153b351b2caa29a4eb7"
]
},
{
"_index": "sw_product_1717666750",
"_id": "d9e358227d154322a17d7b9d706dd84e",
"_score": null,
"_source": {
"id": "d9e358227d154322a17d7b9d706dd84e",
"autoIncrement": 3118.0
},
"fields": {
"displayGroup": [
"27c39a4675ac12e63a4838775d7867c0"
]
},
"sort": [
1992.0,
"d9e358227d154322a17d7b9d706dd84e"
]
},
{
"_index": "sw_product_1717666750",
"_id": "b9034b4c27424c3288e7de534a5f94b1",
"_score": null,
"_source": {
"id": "b9034b4c27424c3288e7de534a5f94b1",
"autoIncrement": 1606.0
},
"fields": {
"displayGroup": [
"c04977f4d66218c948e7cea3fe90bee2"
]
},
"sort": [
1991.0,
"b9034b4c27424c3288e7de534a5f94b1"
]
},
{
"_index": "sw_product_1717666750",
"_id": "7e4d538c126642019441992a1bfee9d2",
"_score": null,
"_source": {
"id": "7e4d538c126642019441992a1bfee9d2",
"autoIncrement": 3119.0
},
"fields": {
"displayGroup": [
"507bd9cfbdb268875109a046ebc9a39e"
]
},
"sort": [
1988.0,
"7e4d538c126642019441992a1bfee9d2"
]
}
]
},
"aggregations": {
"total-count": {
"value": 82
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
1.19 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":"f82770d911a04c3caf1e29b5cbf8a156"}}}},{"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": 82,
"rating": {
"value": 0.0
}
},
"price": {
"count": 82,
"min": 17.85,
"max": 1994.07,
"avg": 571.14,
"sum": 46833.479999999996
},
"options": {
"doc_count": 0,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": []
}
},
"properties": {
"doc_count": 1137,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "45018ee86cc84c47b8d18583215e11fb",
"doc_count": 82
},
{
"key": "a2c4090b0dcc4af680692047254fb901",
"doc_count": 79
},
{
"key": "c00d09ec51844aefa2781fcc00839644",
"doc_count": 75
},
{
"key": "256aa072d598469cbe2a99d63859b36e",
"doc_count": 64
},
{
"key": "f3addfa0aa8f492b93ef4d41f76ff1fd",
"doc_count": 64
},
{
"key": "5d7cdee62433436cb5ff14b769ad2b3e",
"doc_count": 39
},
{
"key": "0aabada48aa64df995d6e54d86f3779b",
"doc_count": 38
},
{
"key": "b81318b1758e42bc8be1559a7f6df0bc",
"doc_count": 34
},
{
"key": "16c63023894f40c29a8d441f052b01fd",
"doc_count": 25
},
{
"key": "de13eba6d2fc4edc96f91a594e3bb0ba",
"doc_count": 25
},
{
"key": "1b390b2547f84681a5aaf6b93875c1ef",
"doc_count": 22
},
{
"key": "2641f8888eea4fb68d423e97f3399a88",
"doc_count": 20
},
{
"key": "5da84ba5d2244bf1be9feadcba813cfd",
"doc_count": 20
},
{
"key": "7e5fecaf5bbf486f850de454593f7009",
"doc_count": 20
},
{
"key": "a6ab6bf14e60463b9609c75edbf26193",
"doc_count": 20
},
{
"key": "df10d98b0f734d97b772665f9d8e5c4e",
"doc_count": 20
},
{
"key": "ff41fb5857a8452ba25dab223256654d",
"doc_count": 20
},
{
"key": "296befd4bc214f238255e0e07e7e5fbb",
"doc_count": 19
},
{
"key": "4f50fa69c4834ae89caf236b403c5a77",
"doc_count": 17
},
{
"key": "be7a046a01af4ef683a2d61d0d49feeb",
"doc_count": 17
},
{
"key": "c82b182269744cecbfea2fc49d9b6766",
"doc_count": 17
},
{
"key": "1af89084374c423fb6d1a5300204fa25",
"doc_count": 15
},
{
"key": "4c19642233cf41b58047a7de6b497f20",
"doc_count": 15
},
{
"key": "13230fbd89994e96b4aea1770a8ce826",
"doc_count": 13
},
{
"key": "d6071c2d7c6a4af885ab399ff929d1dd",
"doc_count": 13
},
{
"key": "69fe8056639d4444882ef24c2b912ba8",
"doc_count": 12
},
{
"key": "adfd37fa8d88405d8be97bde6b963aef",
"doc_count": 12
},
{
"key": "810d89d977184acca8fa2b1d8cbec2ef",
"doc_count": 10
},
{
"key": "172ee189fdbb4d31be14a9303f27e6a4",
"doc_count": 9
},
{
"key": "18e9e666d2f04e2a8249d61008880c6a",
"doc_count": 9
},
{
"key": "2fa142e259134152ad5ce4d44127447d",
"doc_count": 9
},
{
"key": "32137ef409784f0da19874d71a951b99",
"doc_count": 9
},
{
"key": "5ab38019ed7843e7b3b2218c5a19e933",
"doc_count": 9
},
{
"key": "998c9b372d1a4245a79724d3c6f0289e",
"doc_count": 9
},
{
"key": "20307aa6ea24472fbcbae9213a330f80",
"doc_count": 8
},
{
"key": "276cdd68b28844569066cf000ab6cb31",
"doc_count": 8
},
{
"key": "4cf6f930d13848d395b8a7ff6af82442",
"doc_count": 8
},
{
"key": "c057aaf844b84af9a250efc7be0def2c",
"doc_count": 8
},
{
"key": "ca0798b913784ff9880ac954d5b61825",
"doc_count": 8
},
{
"key": "004c9f1122be4d3db1dadecc53a44cdf",
"doc_count": 7
},
{
"key": "50bede51bbaa4f4aba7003a45cf998b3",
"doc_count": 7
},
{
"key": "8fe2495d43f04764a6f6abd2c2e9c247",
"doc_count": 7
},
{
"key": "bbc9a65a8ce0401f8798330fd6ffb44b",
"doc_count": 7
},
{
"key": "d0c07ddcae6a4425b96e363887660b9f",
"doc_count": 7
},
{
"key": "31a18e7f928b429b8aef6d9fc5d7a915",
"doc_count": 6
},
{
"key": "4fe32edc9a664410a0f1c55832be7089",
"doc_count": 6
},
{
"key": "b8db729d7ccf49b08b6e15619a5b290a",
"doc_count": 6
},
{
"key": "008a196ec73a45b0b973a8a46aa36664",
"doc_count": 5
},
{
"key": "00f4b1252e1540b7975b0d2dc01493cb",
"doc_count": 5
},
{
"key": "0ad2db72f8c446a29c956ed6e9f78fb4",
"doc_count": 5
},
{
"key": "7b0b4005d21e44b096ed3d4b26b4f971",
"doc_count": 5
},
{
"key": "8fd4e5476e184e8c86e2fc1904bbc3bc",
"doc_count": 5
},
{
"key": "a9705b0538cb42a3be5018cf5701955d",
"doc_count": 5
},
{
"key": "b17e0030883f443eb86e83ea0e398602",
"doc_count": 5
},
{
"key": "ce208163f6d54098b8f5f01f1966852e",
"doc_count": 5
},
{
"key": "e577924c14df48179d45585b28aacca1",
"doc_count": 5
},
{
"key": "fb2c731579284c588fa1fe56c130231a",
"doc_count": 5
},
{
"key": "018af03e1d7c7c8dabe65059358dbeba",
"doc_count": 4
},
{
"key": "745d9946202e4310a3288c5a80070301",
"doc_count": 4
},
{
"key": "975484cdbc7c495e9a09a3f4f25f6847",
"doc_count": 4
},
{
"key": "99a6b355be2f454db9e8411a8fec4e6b",
"doc_count": 4
},
{
"key": "b24ee16021be483d93181b79c989c05d",
"doc_count": 4
},
{
"key": "cdd1e121488840ffaff218a71c4a8a7c",
"doc_count": 4
},
{
"key": "ef060cd426844b678bc6f4276355d74b",
"doc_count": 4
},
{
"key": "01928a7829d67d639ecf3241a302231e",
"doc_count": 3
},
{
"key": "098e4c78035743c1a34bd91e06dcd9ae",
"doc_count": 3
},
{
"key": "27afa12e8fd1402e8ce3638e19a98d9a",
"doc_count": 3
},
{
"key": "288f1ee6bc2043618226e8abd7f9891e",
"doc_count": 3
},
{
"key": "3edb26d3028d425e85d2a17b9d44c28f",
"doc_count": 3
},
{
"key": "719d6b854ce24a19b8d6e400d71142b6",
"doc_count": 3
},
{
"key": "937316f260814e689113aa8cbe236948",
"doc_count": 3
},
{
"key": "9b2da382ba80450581990e787dbf573f",
"doc_count": 3
},
{
"key": "b52b6f16a76a4aaca05e9d987fb1721b",
"doc_count": 3
},
{
"key": "d87edd2454464161b85302e13bb3d42d",
"doc_count": 3
},
{
"key": "0191b1e1b59a79598dd995135dad40f0",
"doc_count": 2
},
{
"key": "0e52c677f6eb4b4ebcb7bf705fd38edd",
"doc_count": 2
},
{
"key": "27dbf2dab398426fb2f3099e28933f81",
"doc_count": 2
},
{
"key": "3c0aabc08db641c48171fb5bfaa1d462",
"doc_count": 2
},
{
"key": "3f7c6b24c4f54a8991e5d757a63803df",
"doc_count": 2
},
{
"key": "4168693edd8f470887e060209cb6ab20",
"doc_count": 2
},
{
"key": "5b2854b6c9da458e8bf92359a79545e8",
"doc_count": 2
},
{
"key": "5c8b169be6c445cebdbb2c3cf98abaf6",
"doc_count": 2
},
{
"key": "7492acc04b454c3d961a64c10b94643a",
"doc_count": 2
},
{
"key": "b0fd24cfb9784ab4a1236ab5ece09415",
"doc_count": 2
},
{
"key": "b57d1d0eb833459bbda07a3adca6714c",
"doc_count": 2
},
{
"key": "bf2d854da22c41e0a79a72de4697db5b",
"doc_count": 2
},
{
"key": "e8800fea53ee4087a0afd683a283ac96",
"doc_count": 2
},
{
"key": "f38c00d66e7340cf9c07fd64a8c1204b",
"doc_count": 2
},
{
"key": "01951eddf5747afbb41016c63dbe0d55",
"doc_count": 1
},
{
"key": "06e4d27eb94d4cc1aca5541219423d71",
"doc_count": 1
},
{
"key": "19ff354e70aa45dba8fe4f7c2f81db8a",
"doc_count": 1
},
{
"key": "2502dd7c35f344aba0b2238740ee3157",
"doc_count": 1
},
{
"key": "2cfa71698f8846af805a68264beefa3c",
"doc_count": 1
},
{
"key": "4f146b4ced904c95b0ff8ceaf78bfe3a",
"doc_count": 1
},
{
"key": "54ce87786b834c69b24ae0297c9f0351",
"doc_count": 1
},
{
"key": "60f3a33fb6e74ec0b6c83ace74194df5",
"doc_count": 1
},
{
"key": "6f92af8d0f0a4ae99239c1bd9f68d3d3",
"doc_count": 1
},
{
"key": "7d8ad8823f454b6985e477453c0e195b",
"doc_count": 1
},
{
"key": "9270bfdb608f44aba87a8540c8d22a10",
"doc_count": 1
},
{
"key": "93dcea5ec8474de58987a8a26d862a8d",
"doc_count": 1
},
{
"key": "950074db1e3749c6a39dbce3b25beda3",
"doc_count": 1
},
{
"key": "9861fdd7cd7f48188c9ab82dd0c9556a",
"doc_count": 1
},
{
"key": "9a60f14fa86443ff98d00b82e1578dd0",
"doc_count": 1
},
{
"key": "a22ffb31eeef4dec9f2742125159dc7d",
"doc_count": 1
},
{
"key": "ae21e9df3c704e44964baa3298dfb679",
"doc_count": 1
},
{
"key": "cc61a08034264c0db3ba4fd0c3cac5e0",
"doc_count": 1
},
{
"key": "cca45554e2274564aa8fdc6adc80a860",
"doc_count": 1
},
{
"key": "ce434fa752e54b9aad280d8aaf6e580c",
"doc_count": 1
},
{
"key": "ce44d69a3e4e46ce9aa84b8515364889",
"doc_count": 1
},
{
"key": "cf387c70e3fa4517b5dc2e6ed19660c6",
"doc_count": 1
},
{
"key": "d203639f7b4541deab3c1d6440258dd4",
"doc_count": 1
},
{
"key": "d3a2f712b61249b2888f1f071396654b",
"doc_count": 1
},
{
"key": "d3cfb18b53ee4a4486a2f4d64f53934f",
"doc_count": 1
},
{
"key": "de88ad12fea44d74b9c2a1f1edf7ecdf",
"doc_count": 1
},
{
"key": "fcebc86ac3954b8092f471d6315e7c61",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "0345f5142cf242648058475ab4182b6d",
"doc_count": 25
},
{
"key": "ff11ff1ee9364e74ac0058d300b888d1",
"doc_count": 22
},
{
"key": "2a164e08292b491997d23e90d110b622",
"doc_count": 20
},
{
"key": "d8b346bb1b3748be8dd00175221de71a",
"doc_count": 9
},
{
"key": "aab03f73cdd447e6b65315b83ddfeb79",
"doc_count": 5
},
{
"key": "0c6346a583ce4d0c93a8911b89371b9a",
"doc_count": 1
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|