| 1 |
2.25 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":"62640aab2e3547f6934c1c61a9d9e3d2"}}}},{"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": 57,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_product_1717666750",
"_id": "0384c9aae4ee4dd39c4c7da0f60b2e1a",
"_score": null,
"_source": {
"id": "0384c9aae4ee4dd39c4c7da0f60b2e1a",
"autoIncrement": 2424.0
},
"fields": {
"displayGroup": [
"a858c0bb92b8663fda60281493caa98c"
]
},
"sort": [
2007.0,
"0384c9aae4ee4dd39c4c7da0f60b2e1a"
]
},
{
"_index": "sw_product_1717666750",
"_id": "bcb2d343f3ba4122b2a282626da46042",
"_score": null,
"_source": {
"id": "bcb2d343f3ba4122b2a282626da46042",
"autoIncrement": 3254.0
},
"fields": {
"displayGroup": [
"2cd9e71bbd033f30bfcf7ffb2c865b7e"
]
},
"sort": [
2006.0,
"bcb2d343f3ba4122b2a282626da46042"
]
},
{
"_index": "sw_product_1717666750",
"_id": "9c912ca63d574e72b36ad5982e746a18",
"_score": null,
"_source": {
"id": "9c912ca63d574e72b36ad5982e746a18",
"autoIncrement": 3606.0
},
"fields": {
"displayGroup": [
"ee9a274f649c0b8fb94a065b07eef15e"
]
},
"sort": [
2005.0,
"9c912ca63d574e72b36ad5982e746a18"
]
},
{
"_index": "sw_product_1717666750",
"_id": "a7873c5524d0444694c46aeed871dc47",
"_score": null,
"_source": {
"id": "a7873c5524d0444694c46aeed871dc47",
"autoIncrement": 3255.0
},
"fields": {
"displayGroup": [
"fa5bf55189f42345374aa20dbef17ff8"
]
},
"sort": [
2004.0,
"a7873c5524d0444694c46aeed871dc47"
]
},
{
"_index": "sw_product_1717666750",
"_id": "9f5b9dc758ec41a29bacfe4e05fc3db3",
"_score": null,
"_source": {
"id": "9f5b9dc758ec41a29bacfe4e05fc3db3",
"autoIncrement": 3607.0
},
"fields": {
"displayGroup": [
"eda4d61a1587890fe7c9ec360bf4ab5b"
]
},
"sort": [
2003.0,
"9f5b9dc758ec41a29bacfe4e05fc3db3"
]
},
{
"_index": "sw_product_1717666750",
"_id": "63d8b4e1e1ea45b4bf883f5670ded715",
"_score": null,
"_source": {
"id": "63d8b4e1e1ea45b4bf883f5670ded715",
"autoIncrement": 3608.0
},
"fields": {
"displayGroup": [
"dbbf48dca9b636ecc464e23f9cb64de3"
]
},
"sort": [
2002.0,
"63d8b4e1e1ea45b4bf883f5670ded715"
]
},
{
"_index": "sw_product_1717666750",
"_id": "dce124ddc247426fa139896684716870",
"_score": null,
"_source": {
"id": "dce124ddc247426fa139896684716870",
"autoIncrement": 2425.0
},
"fields": {
"displayGroup": [
"38a7c0676473d3c3f3370d2a20520838"
]
},
"sort": [
2001.0,
"dce124ddc247426fa139896684716870"
]
},
{
"_index": "sw_product_1717666750",
"_id": "b931a06dead645d3bbaaeb704f723b80",
"_score": null,
"_source": {
"id": "b931a06dead645d3bbaaeb704f723b80",
"autoIncrement": 2426.0
},
"fields": {
"displayGroup": [
"24e7adc0143753a907fb454cbb8c1165"
]
},
"sort": [
2000.0,
"b931a06dead645d3bbaaeb704f723b80"
]
},
{
"_index": "sw_product_1717666750",
"_id": "3b6f7de526b94ec3a1196d66e9de1609",
"_score": null,
"_source": {
"id": "3b6f7de526b94ec3a1196d66e9de1609",
"autoIncrement": 3256.0
},
"fields": {
"displayGroup": [
"fe1344b6cfeaa60e49138883b393daf1"
]
},
"sort": [
1999.0,
"3b6f7de526b94ec3a1196d66e9de1609"
]
},
{
"_index": "sw_product_1717666750",
"_id": "bf2e218b44794c08ac3c799dd05eb473",
"_score": null,
"_source": {
"id": "bf2e218b44794c08ac3c799dd05eb473",
"autoIncrement": 2436.0
},
"fields": {
"displayGroup": [
"830bf7877826cae93642c1bf17e5a668"
]
},
"sort": [
1999.0,
"bf2e218b44794c08ac3c799dd05eb473"
]
},
{
"_index": "sw_product_1717666750",
"_id": "82edc4a9a61f42cd9e0ad8a473e6ec5c",
"_score": null,
"_source": {
"id": "82edc4a9a61f42cd9e0ad8a473e6ec5c",
"autoIncrement": 3257.0
},
"fields": {
"displayGroup": [
"c031158b636e383d282967a27993e9e5"
]
},
"sort": [
1998.0,
"82edc4a9a61f42cd9e0ad8a473e6ec5c"
]
},
{
"_index": "sw_product_1717666750",
"_id": "40f08fa750e047919a610b5bb013cfe4",
"_score": null,
"_source": {
"id": "40f08fa750e047919a610b5bb013cfe4",
"autoIncrement": 2427.0
},
"fields": {
"displayGroup": [
"c2134f3b9fcaf8870b662ee383610777"
]
},
"sort": [
1997.0,
"40f08fa750e047919a610b5bb013cfe4"
]
},
{
"_index": "sw_product_1717666750",
"_id": "ac559e9c41264594a94186bd8558d5c9",
"_score": null,
"_source": {
"id": "ac559e9c41264594a94186bd8558d5c9",
"autoIncrement": 2428.0
},
"fields": {
"displayGroup": [
"758e3c507f59ef1400befbd69dc20ea5"
]
},
"sort": [
1996.0,
"ac559e9c41264594a94186bd8558d5c9"
]
},
{
"_index": "sw_product_1717666750",
"_id": "83e94330a42a439fb6cb66cc4cfc65cc",
"_score": null,
"_source": {
"id": "83e94330a42a439fb6cb66cc4cfc65cc",
"autoIncrement": 2429.0
},
"fields": {
"displayGroup": [
"7878ebbb9684f322f3e85fdff34c77be"
]
},
"sort": [
1995.0,
"83e94330a42a439fb6cb66cc4cfc65cc"
]
},
{
"_index": "sw_product_1717666750",
"_id": "104bbed6f30a4c7ab04b460963191122",
"_score": null,
"_source": {
"id": "104bbed6f30a4c7ab04b460963191122",
"autoIncrement": 2430.0
},
"fields": {
"displayGroup": [
"0f02f2cad848bf1dbf41f062b68bbc29"
]
},
"sort": [
1994.0,
"104bbed6f30a4c7ab04b460963191122"
]
},
{
"_index": "sw_product_1717666750",
"_id": "0b0573cc57924fb5934b97b72d4cabb4",
"_score": null,
"_source": {
"id": "0b0573cc57924fb5934b97b72d4cabb4",
"autoIncrement": 3258.0
},
"fields": {
"displayGroup": [
"b080447be2a1bf3cb775b08528756485"
]
},
"sort": [
1993.0,
"0b0573cc57924fb5934b97b72d4cabb4"
]
},
{
"_index": "sw_product_1717666750",
"_id": "a3ee434cd7314c08b33b53abd73ab54b",
"_score": null,
"_source": {
"id": "a3ee434cd7314c08b33b53abd73ab54b",
"autoIncrement": 2431.0
},
"fields": {
"displayGroup": [
"4143efe1b94af887ff530c7728eab856"
]
},
"sort": [
1992.0,
"a3ee434cd7314c08b33b53abd73ab54b"
]
},
{
"_index": "sw_product_1717666750",
"_id": "79823c25014f46d9b3566b0ecd34bac0",
"_score": null,
"_source": {
"id": "79823c25014f46d9b3566b0ecd34bac0",
"autoIncrement": 2432.0
},
"fields": {
"displayGroup": [
"26867adacf09a4717ac7773e132b9c06"
]
},
"sort": [
1991.0,
"79823c25014f46d9b3566b0ecd34bac0"
]
},
{
"_index": "sw_product_1717666750",
"_id": "bb16215aa2754996b5cf0e29bc811408",
"_score": null,
"_source": {
"id": "bb16215aa2754996b5cf0e29bc811408",
"autoIncrement": 3259.0
},
"fields": {
"displayGroup": [
"1c2e2b22ae52feff61e882fbbb5249f7"
]
},
"sort": [
1990.0,
"bb16215aa2754996b5cf0e29bc811408"
]
},
{
"_index": "sw_product_1717666750",
"_id": "c5d32f36d44741598e280b2cea3d912d",
"_score": null,
"_source": {
"id": "c5d32f36d44741598e280b2cea3d912d",
"autoIncrement": 3260.0
},
"fields": {
"displayGroup": [
"2aefc4ac7665f2ff3b1de9be2c02061c"
]
},
"sort": [
1989.0,
"c5d32f36d44741598e280b2cea3d912d"
]
},
{
"_index": "sw_product_1717666750",
"_id": "7d1f70dc84de4ecbbf269e546ef4ecb7",
"_score": null,
"_source": {
"id": "7d1f70dc84de4ecbbf269e546ef4ecb7",
"autoIncrement": 3261.0
},
"fields": {
"displayGroup": [
"9f037fc24a11d58e6dcd4ca6c4ff1e95"
]
},
"sort": [
1988.0,
"7d1f70dc84de4ecbbf269e546ef4ecb7"
]
}
]
},
"aggregations": {
"total-count": {
"value": 57
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
1.01 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":"62640aab2e3547f6934c1c61a9d9e3d2"}}}},{"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": 57,
"rating": {
"value": 0.0
}
},
"price": {
"count": 57,
"min": 8.33,
"max": 88.62,
"avg": 45.578771929824555,
"sum": 2597.99
},
"options": {
"doc_count": 0,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": []
}
},
"properties": {
"doc_count": 944,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "2641f8888eea4fb68d423e97f3399a88",
"doc_count": 57
},
{
"key": "45018ee86cc84c47b8d18583215e11fb",
"doc_count": 57
},
{
"key": "5da84ba5d2244bf1be9feadcba813cfd",
"doc_count": 57
},
{
"key": "bb2aca011dc44badab027fb55a1ec97b",
"doc_count": 57
},
{
"key": "df10d98b0f734d97b772665f9d8e5c4e",
"doc_count": 57
},
{
"key": "256aa072d598469cbe2a99d63859b36e",
"doc_count": 56
},
{
"key": "5d7cdee62433436cb5ff14b769ad2b3e",
"doc_count": 56
},
{
"key": "8cf95386ad3f4cbc911c3258b1a3fbde",
"doc_count": 56
},
{
"key": "a56c3e0a2c494c61a7cc919c5093292b",
"doc_count": 56
},
{
"key": "bb129801262543ef8ee5e37cab3c478f",
"doc_count": 56
},
{
"key": "f290de6ae2a340748bad76f3fc85d8a5",
"doc_count": 56
},
{
"key": "f3addfa0aa8f492b93ef4d41f76ff1fd",
"doc_count": 56
},
{
"key": "745d9946202e4310a3288c5a80070301",
"doc_count": 54
},
{
"key": "cdd1e121488840ffaff218a71c4a8a7c",
"doc_count": 54
},
{
"key": "c00d09ec51844aefa2781fcc00839644",
"doc_count": 52
},
{
"key": "d4a1739f69934f898d3684dc7882e6e5",
"doc_count": 14
},
{
"key": "645e181b5cc8460285d21cfd365b2306",
"doc_count": 7
},
{
"key": "58f55dc63ff7438c919cd908e6bf9298",
"doc_count": 5
},
{
"key": "b984287e3db147ceb624506b60b5294b",
"doc_count": 5
},
{
"key": "d0c07ddcae6a4425b96e363887660b9f",
"doc_count": 5
},
{
"key": "d87edd2454464161b85302e13bb3d42d",
"doc_count": 5
},
{
"key": "0ad2db72f8c446a29c956ed6e9f78fb4",
"doc_count": 4
},
{
"key": "998c9b372d1a4245a79724d3c6f0289e",
"doc_count": 4
},
{
"key": "06e4d27eb94d4cc1aca5541219423d71",
"doc_count": 3
},
{
"key": "adfd37fa8d88405d8be97bde6b963aef",
"doc_count": 3
},
{
"key": "19ff354e70aa45dba8fe4f7c2f81db8a",
"doc_count": 2
},
{
"key": "3008f099194e49fca0e7b250c0ae75da",
"doc_count": 2
},
{
"key": "89a3bfb413014d32804a8a142496ea90",
"doc_count": 2
},
{
"key": "a22ffb31eeef4dec9f2742125159dc7d",
"doc_count": 2
},
{
"key": "ca0798b913784ff9880ac954d5b61825",
"doc_count": 2
},
{
"key": "d203639f7b4541deab3c1d6440258dd4",
"doc_count": 2
},
{
"key": "fcebc86ac3954b8092f471d6315e7c61",
"doc_count": 2
},
{
"key": "018af03e1d7c7c8dabe65059358dbeba",
"doc_count": 1
},
{
"key": "01928a7829d67d639ecf3241a302231e",
"doc_count": 1
},
{
"key": "1baebe6a6ef6423f95778600eb89c7f8",
"doc_count": 1
},
{
"key": "27afa12e8fd1402e8ce3638e19a98d9a",
"doc_count": 1
},
{
"key": "2cfa71698f8846af805a68264beefa3c",
"doc_count": 1
},
{
"key": "399f3680903c4f8487dab3f10b472b46",
"doc_count": 1
},
{
"key": "3c038b44e46442589661994ae6e4eb42",
"doc_count": 1
},
{
"key": "4f146b4ced904c95b0ff8ceaf78bfe3a",
"doc_count": 1
},
{
"key": "50bede51bbaa4f4aba7003a45cf998b3",
"doc_count": 1
},
{
"key": "528b3840acb344d58eaad59f9085ed0a",
"doc_count": 1
},
{
"key": "54ce87786b834c69b24ae0297c9f0351",
"doc_count": 1
},
{
"key": "5ab38019ed7843e7b3b2218c5a19e933",
"doc_count": 1
},
{
"key": "5b2854b6c9da458e8bf92359a79545e8",
"doc_count": 1
},
{
"key": "60f3a33fb6e74ec0b6c83ace74194df5",
"doc_count": 1
},
{
"key": "7d98a41c504648b59fc8a9046d4545ca",
"doc_count": 1
},
{
"key": "7dd4792638cd4355a29752344ca447ec",
"doc_count": 1
},
{
"key": "800cde44bd344c75bd903fc8b0afcedb",
"doc_count": 1
},
{
"key": "8a6ac1662b934451b6e3bc6e665c3bea",
"doc_count": 1
},
{
"key": "8dedb3f255ff420ba88ac7fb25b2d50c",
"doc_count": 1
},
{
"key": "9270bfdb608f44aba87a8540c8d22a10",
"doc_count": 1
},
{
"key": "93dcea5ec8474de58987a8a26d862a8d",
"doc_count": 1
},
{
"key": "9861fdd7cd7f48188c9ab82dd0c9556a",
"doc_count": 1
},
{
"key": "9a60f14fa86443ff98d00b82e1578dd0",
"doc_count": 1
},
{
"key": "a8546c1bbd6f4829b47555f51685b62d",
"doc_count": 1
},
{
"key": "adac28fc0ee643c1b43adea098dca42c",
"doc_count": 1
},
{
"key": "ae21e9df3c704e44964baa3298dfb679",
"doc_count": 1
},
{
"key": "b0fd24cfb9784ab4a1236ab5ece09415",
"doc_count": 1
},
{
"key": "bcfd8dff179149088e720a4ff4527e56",
"doc_count": 1
},
{
"key": "bf11c7caeab94fb8a1c508ba6d222fed",
"doc_count": 1
},
{
"key": "bf2d854da22c41e0a79a72de4697db5b",
"doc_count": 1
},
{
"key": "c1d70719badf4382b9dabd1bb5a380bf",
"doc_count": 1
},
{
"key": "c7cc8a656cf841ca898ab1f1ad507138",
"doc_count": 1
},
{
"key": "cc61a08034264c0db3ba4fd0c3cac5e0",
"doc_count": 1
},
{
"key": "cca45554e2274564aa8fdc6adc80a860",
"doc_count": 1
},
{
"key": "ce44d69a3e4e46ce9aa84b8515364889",
"doc_count": 1
},
{
"key": "cf387c70e3fa4517b5dc2e6ed19660c6",
"doc_count": 1
},
{
"key": "e8800fea53ee4087a0afd683a283ac96",
"doc_count": 1
},
{
"key": "eff689d23e264c44b773885f2a4a39e9",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "2a164e08292b491997d23e90d110b622",
"doc_count": 57
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|