| 1 |
2.26 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":"d50bc0114a95440b98f77f1d193c29ee"}}}},{"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":0,"size":36,"collapse":{"field":"displayGroup"},"timeout":"5s"}}
{
"took": 1,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 24,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_product_1717666750",
"_id": "018c43ff87797376b4f4271b59f07ba0",
"_score": null,
"_source": {
"id": "018c43ff87797376b4f4271b59f07ba0",
"autoIncrement": 4738.0
},
"fields": {
"displayGroup": [
"bd7ba7dfe4a8fe34f1a3731273ebc298"
]
},
"sort": [
2024.0,
"018c43ff87797376b4f4271b59f07ba0"
]
},
{
"_index": "sw_product_1717666750",
"_id": "d628c1de5f314dbba7ccf9d90d7a9984",
"_score": null,
"_source": {
"id": "d628c1de5f314dbba7ccf9d90d7a9984",
"autoIncrement": 2478.0
},
"fields": {
"displayGroup": [
"605909f4c97d138a0bb23bb774cf4b61"
]
},
"sort": [
2019.0,
"d628c1de5f314dbba7ccf9d90d7a9984"
]
},
{
"_index": "sw_product_1717666750",
"_id": "927150ea01404587981a2320a9fca8a6",
"_score": null,
"_source": {
"id": "927150ea01404587981a2320a9fca8a6",
"autoIncrement": 2479.0
},
"fields": {
"displayGroup": [
"0a599de2c869de3b1837b63d9e2cf9c9"
]
},
"sort": [
2018.0,
"927150ea01404587981a2320a9fca8a6"
]
},
{
"_index": "sw_product_1717666750",
"_id": "001f49a7d65b435eb2867907984ee187",
"_score": null,
"_source": {
"id": "001f49a7d65b435eb2867907984ee187",
"autoIncrement": 2480.0
},
"fields": {
"displayGroup": [
"a747b4206fcc07d0c14268eb2c65213a"
]
},
"sort": [
2017.0,
"001f49a7d65b435eb2867907984ee187"
]
},
{
"_index": "sw_product_1717666750",
"_id": "f642b82d337e4497b0fd6bcef3dc02f5",
"_score": null,
"_source": {
"id": "f642b82d337e4497b0fd6bcef3dc02f5",
"autoIncrement": 2483.0
},
"fields": {
"displayGroup": [
"a3680ea0a81bc41256dbc911d7c050cc"
]
},
"sort": [
2016.0,
"f642b82d337e4497b0fd6bcef3dc02f5"
]
},
{
"_index": "sw_product_1717666750",
"_id": "a9ba7ef2fd4e45c5b10b1348935644da",
"_score": null,
"_source": {
"id": "a9ba7ef2fd4e45c5b10b1348935644da",
"autoIncrement": 2484.0
},
"fields": {
"displayGroup": [
"c7bf690a6713ac48ccb523e9af9a5462"
]
},
"sort": [
2015.0,
"a9ba7ef2fd4e45c5b10b1348935644da"
]
},
{
"_index": "sw_product_1717666750",
"_id": "8c6ff7bb9db14e318673cb478692cddb",
"_score": null,
"_source": {
"id": "8c6ff7bb9db14e318673cb478692cddb",
"autoIncrement": 2485.0
},
"fields": {
"displayGroup": [
"c3e1f37733ac6cb532a338f14ad5982a"
]
},
"sort": [
2014.0,
"8c6ff7bb9db14e318673cb478692cddb"
]
},
{
"_index": "sw_product_1717666750",
"_id": "c9414c4daafa4a8da581e7cb914dcac4",
"_score": null,
"_source": {
"id": "c9414c4daafa4a8da581e7cb914dcac4",
"autoIncrement": 2486.0
},
"fields": {
"displayGroup": [
"8cf92874dcb521f6ec3b46ff7a32e952"
]
},
"sort": [
2013.0,
"c9414c4daafa4a8da581e7cb914dcac4"
]
},
{
"_index": "sw_product_1717666750",
"_id": "2d63a53cb50c427b88e3af03ffd8def3",
"_score": null,
"_source": {
"id": "2d63a53cb50c427b88e3af03ffd8def3",
"autoIncrement": 2487.0
},
"fields": {
"displayGroup": [
"1c3a2294de80f146e8cd4719f43d958e"
]
},
"sort": [
2012.0,
"2d63a53cb50c427b88e3af03ffd8def3"
]
},
{
"_index": "sw_product_1717666750",
"_id": "426ffb1ccfff49c4aea70d4930301dc1",
"_score": null,
"_source": {
"id": "426ffb1ccfff49c4aea70d4930301dc1",
"autoIncrement": 2488.0
},
"fields": {
"displayGroup": [
"94b209cea7563a84501e3e1a3f776b94"
]
},
"sort": [
2011.0,
"426ffb1ccfff49c4aea70d4930301dc1"
]
},
{
"_index": "sw_product_1717666750",
"_id": "d21ded4898cc42638b77477b4c770d4b",
"_score": null,
"_source": {
"id": "d21ded4898cc42638b77477b4c770d4b",
"autoIncrement": 2489.0
},
"fields": {
"displayGroup": [
"2282eb6a8f16c81017486e8703739bc5"
]
},
"sort": [
2009.0,
"d21ded4898cc42638b77477b4c770d4b"
]
},
{
"_index": "sw_product_1717666750",
"_id": "fe6881da2d4543de8f9baa92db6179d3",
"_score": null,
"_source": {
"id": "fe6881da2d4543de8f9baa92db6179d3",
"autoIncrement": 2490.0
},
"fields": {
"displayGroup": [
"fc9523e1a7166fbaea8ff3d31760425e"
]
},
"sort": [
2008.0,
"fe6881da2d4543de8f9baa92db6179d3"
]
},
{
"_index": "sw_product_1717666750",
"_id": "14e745057269437faccb1ed4f587cf50",
"_score": null,
"_source": {
"id": "14e745057269437faccb1ed4f587cf50",
"autoIncrement": 2491.0
},
"fields": {
"displayGroup": [
"f4b18356233d3b5b6440f759798596ec"
]
},
"sort": [
2007.0,
"14e745057269437faccb1ed4f587cf50"
]
},
{
"_index": "sw_product_1717666750",
"_id": "fd97ec438186491cbd5ea46f6d6b2ee4",
"_score": null,
"_source": {
"id": "fd97ec438186491cbd5ea46f6d6b2ee4",
"autoIncrement": 2492.0
},
"fields": {
"displayGroup": [
"4567f29c832cdf0393562a3b84c36e9f"
]
},
"sort": [
2006.0,
"fd97ec438186491cbd5ea46f6d6b2ee4"
]
},
{
"_index": "sw_product_1717666750",
"_id": "b7e6dec5e2e64dbd86f3d335f88a8f78",
"_score": null,
"_source": {
"id": "b7e6dec5e2e64dbd86f3d335f88a8f78",
"autoIncrement": 2493.0
},
"fields": {
"displayGroup": [
"673ba4b101c35e46cc40e3bf12e55819"
]
},
"sort": [
2005.0,
"b7e6dec5e2e64dbd86f3d335f88a8f78"
]
},
{
"_index": "sw_product_1717666750",
"_id": "e40912a9f5f0478bb4aa108f2ad045c8",
"_score": null,
"_source": {
"id": "e40912a9f5f0478bb4aa108f2ad045c8",
"autoIncrement": 2494.0
},
"fields": {
"displayGroup": [
"b890f4ff737769af4da68d80e6513d45"
]
},
"sort": [
2004.0,
"e40912a9f5f0478bb4aa108f2ad045c8"
]
},
{
"_index": "sw_product_1717666750",
"_id": "a358c62369294a689165f20a09c15abd",
"_score": null,
"_source": {
"id": "a358c62369294a689165f20a09c15abd",
"autoIncrement": 2495.0
},
"fields": {
"displayGroup": [
"337b66f141efefc69bf945616e4a0e95"
]
},
"sort": [
2003.0,
"a358c62369294a689165f20a09c15abd"
]
},
{
"_index": "sw_product_1717666750",
"_id": "27ab3076b84e432d8e129cb48b4db8de",
"_score": null,
"_source": {
"id": "27ab3076b84e432d8e129cb48b4db8de",
"autoIncrement": 2496.0
},
"fields": {
"displayGroup": [
"91e073814ef97d27cc87a5e69d0636c8"
]
},
"sort": [
2002.0,
"27ab3076b84e432d8e129cb48b4db8de"
]
},
{
"_index": "sw_product_1717666750",
"_id": "cf4e806115184df58bc70830974aa9a3",
"_score": null,
"_source": {
"id": "cf4e806115184df58bc70830974aa9a3",
"autoIncrement": 2497.0
},
"fields": {
"displayGroup": [
"4197f90865291db89596251bab6d8672"
]
},
"sort": [
2001.0,
"cf4e806115184df58bc70830974aa9a3"
]
},
{
"_index": "sw_product_1717666750",
"_id": "add9d51de8de40c79104e8ef148f3395",
"_score": null,
"_source": {
"id": "add9d51de8de40c79104e8ef148f3395",
"autoIncrement": 2498.0
},
"fields": {
"displayGroup": [
"427b92d893098806eae3780f0509d29b"
]
},
"sort": [
2000.0,
"add9d51de8de40c79104e8ef148f3395"
]
},
{
"_index": "sw_product_1717666750",
"_id": "721ccd588eb249acb4ecb821ab10147e",
"_score": null,
"_source": {
"id": "721ccd588eb249acb4ecb821ab10147e",
"autoIncrement": 2499.0
},
"fields": {
"displayGroup": [
"55cdd7c0d1f111c5193520c35466e113"
]
},
"sort": [
1999.0,
"721ccd588eb249acb4ecb821ab10147e"
]
},
{
"_index": "sw_product_1717666750",
"_id": "69927312bed944108c2d85abc2d8abc8",
"_score": null,
"_source": {
"id": "69927312bed944108c2d85abc2d8abc8",
"autoIncrement": 2500.0
},
"fields": {
"displayGroup": [
"27fae12b0330ceec3f81a6febe002e11"
]
},
"sort": [
1998.0,
"69927312bed944108c2d85abc2d8abc8"
]
},
{
"_index": "sw_product_1717666750",
"_id": "504683ba5526477ea976611d30173e1c",
"_score": null,
"_source": {
"id": "504683ba5526477ea976611d30173e1c",
"autoIncrement": 2501.0
},
"fields": {
"displayGroup": [
"4ae065c7d087d35bbde15c6adf7d6867"
]
},
"sort": [
1997.0,
"504683ba5526477ea976611d30173e1c"
]
},
{
"_index": "sw_product_1717666750",
"_id": "909512020f7b41c7aebf18a139a039c5",
"_score": null,
"_source": {
"id": "909512020f7b41c7aebf18a139a039c5",
"autoIncrement": 2502.0
},
"fields": {
"displayGroup": [
"bfe69e2ec4b38d6e8453f73b98e32d16"
]
},
"sort": [
1996.0,
"909512020f7b41c7aebf18a139a039c5"
]
}
]
},
"aggregations": {
"total-count": {
"value": 24
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
1.04 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":"d50bc0114a95440b98f77f1d193c29ee"}}}},{"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": 24,
"rating": {
"value": 0.0
}
},
"price": {
"count": 24,
"min": 42.8,
"max": 1012.24,
"avg": 236.23541666666668,
"sum": 5669.650000000001
},
"options": {
"doc_count": 0,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": []
}
},
"properties": {
"doc_count": 384,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "0c189ea565ab4573a222115adc6b9258",
"doc_count": 24
},
{
"key": "45018ee86cc84c47b8d18583215e11fb",
"doc_count": 24
},
{
"key": "4988dd26e79942d98cd0eb3b4742a991",
"doc_count": 24
},
{
"key": "5b8f5b04a97b47e2b04efe565e99a70a",
"doc_count": 24
},
{
"key": "69fe8056639d4444882ef24c2b912ba8",
"doc_count": 24
},
{
"key": "6d6ea6f00d3b4309b31b2222306bb6f6",
"doc_count": 24
},
{
"key": "71de6d2a0af841dc856061e5c8c01d33",
"doc_count": 24
},
{
"key": "8607b9a5f4b94ea7ad3cd00822deb432",
"doc_count": 24
},
{
"key": "b81318b1758e42bc8be1559a7f6df0bc",
"doc_count": 24
},
{
"key": "c00d09ec51844aefa2781fcc00839644",
"doc_count": 24
},
{
"key": "d07b4fc633bd40beb399e46075eede63",
"doc_count": 24
},
{
"key": "de11157443fb4362b15963d373823bcd",
"doc_count": 24
},
{
"key": "fc4cb3aa0adf4ae8a02c230d3cb41aea",
"doc_count": 24
},
{
"key": "97e91b44c63045459a74bf3a7637a658",
"doc_count": 23
},
{
"key": "80e833585b2c4aca950cebfb2aaabd1a",
"doc_count": 3
},
{
"key": "22a8860b9903479c925747bb7932c8ab",
"doc_count": 2
},
{
"key": "412fad5d763d48ee911d9bfb941f6035",
"doc_count": 2
},
{
"key": "7d98a41c504648b59fc8a9046d4545ca",
"doc_count": 2
},
{
"key": "af0166d26c6a421bbf4b37c35b1f5636",
"doc_count": 2
},
{
"key": "018af03e1d7c7c8dabe65059358dbeba",
"doc_count": 1
},
{
"key": "06e4d27eb94d4cc1aca5541219423d71",
"doc_count": 1
},
{
"key": "0ad2db72f8c446a29c956ed6e9f78fb4",
"doc_count": 1
},
{
"key": "0ee5bddb58024eebb1b5e025090a6bab",
"doc_count": 1
},
{
"key": "19ff354e70aa45dba8fe4f7c2f81db8a",
"doc_count": 1
},
{
"key": "27afa12e8fd1402e8ce3638e19a98d9a",
"doc_count": 1
},
{
"key": "2cfa71698f8846af805a68264beefa3c",
"doc_count": 1
},
{
"key": "4f146b4ced904c95b0ff8ceaf78bfe3a",
"doc_count": 1
},
{
"key": "50cec4516b414dfbb6c5dc8e3340cf9d",
"doc_count": 1
},
{
"key": "5b2854b6c9da458e8bf92359a79545e8",
"doc_count": 1
},
{
"key": "60f3a33fb6e74ec0b6c83ace74194df5",
"doc_count": 1
},
{
"key": "638c219b15d94543961ae12914510534",
"doc_count": 1
},
{
"key": "6e93e57366dc4b6f913cc9087e047377",
"doc_count": 1
},
{
"key": "8dedb3f255ff420ba88ac7fb25b2d50c",
"doc_count": 1
},
{
"key": "9270bfdb608f44aba87a8540c8d22a10",
"doc_count": 1
},
{
"key": "93dcea5ec8474de58987a8a26d862a8d",
"doc_count": 1
},
{
"key": "9861fdd7cd7f48188c9ab82dd0c9556a",
"doc_count": 1
},
{
"key": "998c9b372d1a4245a79724d3c6f0289e",
"doc_count": 1
},
{
"key": "a22ffb31eeef4dec9f2742125159dc7d",
"doc_count": 1
},
{
"key": "ac74e149797347cdb23d44c4933e6350",
"doc_count": 1
},
{
"key": "aca2278dd7cb406fb0d3b5407da74ad0",
"doc_count": 1
},
{
"key": "ad799a5d08034eb29cc48599b830b580",
"doc_count": 1
},
{
"key": "adfd37fa8d88405d8be97bde6b963aef",
"doc_count": 1
},
{
"key": "b0fd24cfb9784ab4a1236ab5ece09415",
"doc_count": 1
},
{
"key": "b41e3fd4954f46e6872077122a72871e",
"doc_count": 1
},
{
"key": "b7c812a36d9f41e79b4378755bbab475",
"doc_count": 1
},
{
"key": "bf2d854da22c41e0a79a72de4697db5b",
"doc_count": 1
},
{
"key": "bfbb369aaf974a39a447d2aee136dafd",
"doc_count": 1
},
{
"key": "c5a905b9998b4101bda1e2c16a564f4f",
"doc_count": 1
},
{
"key": "c94f8b8a5bd94bd682dce2e4622c906b",
"doc_count": 1
},
{
"key": "ce44d69a3e4e46ce9aa84b8515364889",
"doc_count": 1
},
{
"key": "d203639f7b4541deab3c1d6440258dd4",
"doc_count": 1
},
{
"key": "d7a1f6868a3e455199af162d0f26788f",
"doc_count": 1
},
{
"key": "d87edd2454464161b85302e13bb3d42d",
"doc_count": 1
},
{
"key": "e8800fea53ee4087a0afd683a283ac96",
"doc_count": 1
},
{
"key": "eff689d23e264c44b773885f2a4a39e9",
"doc_count": 1
},
{
"key": "f133326f89ec4dd3bbc594d478eccc58",
"doc_count": 1
},
{
"key": "fcebc86ac3954b8092f471d6315e7c61",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "44664e58a30b46f2b6b0d6d55373d662",
"doc_count": 24
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|