| 1 |
4.28 ms |
Request:
{"index":"shopware6-stage_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"should":[{"terms":{"productNumber":["770041"]}}]}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}},{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":10}}},{"term":{"visibilities.salesChannelId":"01895226670e72a4a15f371adce297ad"}}]}}}},{"term":{"active":true}}]}}]}}]}},"sort":[{"_script":{"type":"number","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_rule01894ed2c3f9725883fd3e2c980adaaa_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01894ed2c3fe723e9e7e6790bb62adc1_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01894ed2c63170738ac1fb06e2f9a3cf_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01894ed2c40b73e7a27925fdb16701ab_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b2915dc11756f9ae3331d8b23bde5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b344c883071bc80a3509bc4043140_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b344d56317c42bf44bb7336973244_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b344f5ba07d9a98b86c5bc7d1410a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b34500e857ae3ab1cffcf1594d77b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b38dcb139726da7e7f62faff160fa_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b38e14e777e389a388cd9175c40cc_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018bae1d69bc75b1aa820316abe211f2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018bd73f09d7705595baff2c8cf92203_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018c15b8de9c709599df768cb6a224be_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018c19f988aa7cf1ba8f9463cb39048a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulee44e6782c64247b796b891cf25ae38f7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1}],"decimals":100,"round":true,"multiplier":100.0}},"order":"ASC"}}],"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"},"search_type":"query_then_fetch"}
{
"took": 1,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"max_score": null,
"hits": [
{
"_index": "shopware6-stage_product_1725967126",
"_id": "8bb2ca5d5971911f4204fdec97ff2d7e",
"_score": null,
"_source": {
"id": "8bb2ca5d5971911f4204fdec97ff2d7e",
"autoIncrement": 91265.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 1,
"productNumber": "770041",
"ean": "8721055331735",
"displayGroup": "fec09d3bd130b3a5f4fec211f1fe4fa1",
"sales": 0,
"stock": 1,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "1bb353a1cfd2afe16cda463b071f2d83",
"manufacturerNumber": "081301500030",
"releaseDate": null,
"createdAt": "2024-12-09T05:26:21+00:00",
"categoryTree": [],
"categoriesRo": [],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": "2ee15c506831e0d2259f6d410c6b8f26",
"coverId": null,
"childCount": 0,
"categories": [],
"manufacturer": {
"id": "1bb353a1cfd2afe16cda463b071f2d83",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Tenways"
},
"_count": 1
},
"properties": [
{
"id": "0622c5290bcc24edde88c19018975298",
"_count": 1,
"groupId": "ecc93cb4118559ffc538281ac056e6b0",
"group": {
"id": "ecc93cb4118559ffc538281ac056e6b0",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "integriert"
}
},
{
"id": "143b5940fcf88a8757712db87c9e5791",
"_count": 1,
"groupId": "67257a0b244c56fc1f85cbf6ae0eb5f7",
"group": {
"id": "67257a0b244c56fc1f85cbf6ae0eb5f7",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "140 Kg"
}
},
{
"id": "1ed920c9e27592593e21a6ddaba1a979",
"_count": 1,
"groupId": "8d3c06e4ef7fec22377ee4ea56e7df6a",
"group": {
"id": "8d3c06e4ef7fec22377ee4ea56e7df6a",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kettenschaltung"
}
},
{
"id": "2ca06d1a91fa0beac12dc5b993bef46c",
"_count": 1,
"groupId": "3f89663f0ab68bdf364a590c8f133f4b",
"group": {
"id": "3f89663f0ab68bdf364a590c8f133f4b",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Tenways C9"
}
},
{
"id": "4e93759a50b70b433ccdb1ef4185fcc1",
"_count": 1,
"groupId": "16fd55d02a23f31097ca58eccfeec97c",
"group": {
"id": "16fd55d02a23f31097ca58eccfeec97c",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "blau"
}
},
{
"id": "522236c215d5464299f82e064ae67ae2",
"_count": 1,
"groupId": "c4b89253123017ee3fbb833485a18a6c",
"group": {
"id": "c4b89253123017ee3fbb833485a18a6c",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "360 Wh"
}
},
{
"id": "56041c3f35d0cbb4087e2b9fee8a9a48",
"_count": 1,
"groupId": "b452f9cfcee052c98c3cc127a83eb467",
"group": {
"id": "b452f9cfcee052c98c3cc127a83eb467",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "ca. 20 kg"
}
},
{
"id": "57ea44f19b74405f40baa45fc561493a",
"_count": 1,
"groupId": "79958f9b32c396332e45ef4487152f13",
"group": {
"id": "79958f9b32c396332e45ef4487152f13",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nein"
}
},
{
"id": "6499e9e3b3fc50b22f9edaf996927496",
"_count": 1,
"groupId": "57d10a42e9e995a36d6bdafd88387f18",
"group": {
"id": "57d10a42e9e995a36d6bdafd88387f18",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Tenways"
}
},
{
"id": "7052790f352e0b66c5f5ceea1429da94",
"_count": 1,
"groupId": "f424bfe0316bd62a53f56a46d5eb8d7d",
"group": {
"id": "f424bfe0316bd62a53f56a46d5eb8d7d",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ja"
}
},
{
"id": "73465d77a1aef3c3db2b5f7a3756942e",
"_count": 1,
"groupId": "6952d7680528b2ba9f7ab0e454eed1db",
"group": {
"id": "6952d7680528b2ba9f7ab0e454eed1db",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "CST Puncture-proof 700\u00d748C"
}
},
{
"id": "788ea7fd6c03951350c1d486e9b8044d",
"_count": 1,
"groupId": "f7a9fede8828c7ad00054338044d0dbe",
"group": {
"id": "f7a9fede8828c7ad00054338044d0dbe",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Tektro"
}
},
{
"id": "7f9cbf2de52f7dbd5b0400e56665f8e1",
"_count": 1,
"groupId": "b7353c4ace70858b93234198b10691b5",
"group": {
"id": "b7353c4ace70858b93234198b10691b5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "einstellbar"
}
},
{
"id": "99f62d71952cbd7c3c834eb1347ab82e",
"_count": 1,
"groupId": "b33538179f5661a86cbe327a1793e199",
"group": {
"id": "b33538179f5661a86cbe327a1793e199",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hinterradmotor"
}
},
{
"id": "9d9dd4ed6d2c6a1c00069a994ecd1311",
"_count": 1,
"groupId": "ceb6fd21dc31360b88ac128686052a5e",
"group": {
"id": "ceb6fd21dc31360b88ac128686052a5e",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Aluminium"
}
},
{
"id": "9e50863eeadd4c4bf87c00afd0f8e401",
"_count": 1,
"groupId": "b9987a246a537f4fe86f1f2e3d10dbdb",
"group": {
"id": "b9987a246a537f4fe86f1f2e3d10dbdb",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "OLED Display"
}
},
{
"id": "a4270cc232aa5ee75d1ba77223966083",
"_count": 1,
"groupId": "a16022e7816ee4b03a8e54519ee7bf02",
"group": {
"id": "a16022e7816ee4b03a8e54519ee7bf02",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Trekking"
}
},
{
"id": "a5aed87367f01898658a8f433330fcfb",
"_count": 1,
"groupId": "503f306fc1edbd32bb55a9d4d3994f8d",
"group": {
"id": "503f306fc1edbd32bb55a9d4d3994f8d",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "8"
}
},
{
"id": "ab39b070cb469e332975dd3d72163cad",
"_count": 1,
"groupId": "ecf1a4775ece0c53ee7dc9957d1edd24",
"group": {
"id": "ecf1a4775ece0c53ee7dc9957d1edd24",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "im Rahmen integriert"
}
},
{
"id": "b2d5be5032608c0d18328961e32a342a",
"_count": 1,
"groupId": "05044f92622e2a4b4b94bf95bb76fa5d",
"group": {
"id": "05044f92622e2a4b4b94bf95bb76fa5d",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shimano Claris"
}
},
{
"id": "b367d783dc3e2a24f69be0edaed40c67",
"_count": 1,
"groupId": "adf2abbdb5a021f12b6bc1a1fd34dbc7",
"group": {
"id": "adf2abbdb5a021f12b6bc1a1fd34dbc7",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2025"
}
},
{
"id": "c03a01c3a1bb726efcfa077db5dc4e24",
"_count": 1,
"groupId": "205d463d996b4cee01479ac2f05ec614",
"group": {
"id": "205d463d996b4cee01479ac2f05ec614",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nein"
}
},
{
"id": "c79208e454f3d892d08b5b98b286f85d",
"_count": 1,
"groupId": "ae1de98645eed200149ba8a40a93df97",
"group": {
"id": "ae1de98645eed200149ba8a40a93df97",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "6061 Aluminiumgabel"
}
},
{
"id": "c8bb250ce4ae8f1cb3003218719fbfd5",
"_count": 1,
"groupId": "f9109ae7ce709818cf47ead51feb3096",
"group": {
"id": "f9109ae7ce709818cf47ead51feb3096",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Diamant"
}
},
{
"id": "cd990d4a557338970229a93662e403e5",
"_count": 1,
"groupId": "f8508f576cd3f742dfc268258dcdf0dd",
"group": {
"id": "f8508f576cd3f742dfc268258dcdf0dd",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Vector Sine Wave Controller"
}
},
{
"id": "cf1ff5152622668e0692ce394889b962",
"_count": 1,
"groupId": "d9c530b6b501df9943bed7514c2b54d7",
"group": {
"id": "d9c530b6b501df9943bed7514c2b54d7",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lithium-Ionen mit LG Zellen"
}
},
{
"id": "d215aedab5221382a37a177485268129",
"_count": 1,
"groupId": "1dfcee408979620926ced38d7ae45bb3",
"group": {
"id": "1dfcee408979620926ced38d7ae45bb3",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Aluminium"
}
},
{
"id": "db53e617bab07cd00e41debe9eee2269",
"_count": 1,
"groupId": "3ea4bb03c22f227764c0c1fc05655f9f",
"group": {
"id": "3ea4bb03c22f227764c0c1fc05655f9f",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "700C Aluminium Felgen"
}
},
{
"id": "e330a259b38a4839bae4f1295c5a8a98",
"_count": 1,
"groupId": "c3beefaefa0c82a810da3211f962fa99",
"group": {
"id": "c3beefaefa0c82a810da3211f962fa99",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "50 cm"
}
},
{
"id": "ebe2946d388e152e4e37f0829ff81e54",
"_count": 1,
"groupId": "e445d5074a7f9c03ce70dcd85141cdb4",
"group": {
"id": "e445d5074a7f9c03ce70dcd85141cdb4",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "bis 25 km\/h"
}
},
{
"id": "eebcb5c057f13483476f1d48a050fd6b",
"_count": 1,
"groupId": "a1beca20c312f61bd82db0d0e523cefc",
"group": {
"id": "a1beca20c312f61bd82db0d0e523cefc",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "45 Nm"
}
},
{
"id": "fc7c95e8a0c10edfec779479917546ca",
"_count": 1,
"groupId": "f5fed9bc267410759ab04276601a9f42",
"group": {
"id": "f5fed9bc267410759ab04276601a9f42",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "28\""
}
}
],
"options": [
{
"id": "e330a259b38a4839bae4f1295c5a8a98",
"_count": 1,
"groupId": "c3beefaefa0c82a810da3211f962fa99",
"group": {
"id": "c3beefaefa0c82a810da3211f962fa99",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "50 cm"
}
}
],
"categoryIds": [],
"optionIds": [
"e330a259b38a4839bae4f1295c5a8a98"
],
"propertyIds": [
"0622c5290bcc24edde88c19018975298",
"143b5940fcf88a8757712db87c9e5791",
"1ed920c9e27592593e21a6ddaba1a979",
"2ca06d1a91fa0beac12dc5b993bef46c",
"4e93759a50b70b433ccdb1ef4185fcc1",
"522236c215d5464299f82e064ae67ae2",
"56041c3f35d0cbb4087e2b9fee8a9a48",
"57ea44f19b74405f40baa45fc561493a",
"6499e9e3b3fc50b22f9edaf996927496",
"7052790f352e0b66c5f5ceea1429da94",
"73465d77a1aef3c3db2b5f7a3756942e",
"788ea7fd6c03951350c1d486e9b8044d",
"7f9cbf2de52f7dbd5b0400e56665f8e1",
"99f62d71952cbd7c3c834eb1347ab82e",
"9d9dd4ed6d2c6a1c00069a994ecd1311",
"9e50863eeadd4c4bf87c00afd0f8e401",
"a4270cc232aa5ee75d1ba77223966083",
"a5aed87367f01898658a8f433330fcfb",
"ab39b070cb469e332975dd3d72163cad",
"b2d5be5032608c0d18328961e32a342a",
"b367d783dc3e2a24f69be0edaed40c67",
"c03a01c3a1bb726efcfa077db5dc4e24",
"c79208e454f3d892d08b5b98b286f85d",
"c8bb250ce4ae8f1cb3003218719fbfd5",
"cd990d4a557338970229a93662e403e5",
"cf1ff5152622668e0692ce394889b962",
"d215aedab5221382a37a177485268129",
"db53e617bab07cd00e41debe9eee2269",
"e330a259b38a4839bae4f1295c5a8a98",
"ebe2946d388e152e4e37f0829ff81e54",
"eebcb5c057f13483476f1d48a050fd6b",
"fc7c95e8a0c10edfec779479917546ca"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"product_slider_einsatz": 5.0,
"product_slider_terrain": 3.0,
"product_slider_ausstattung": 5.0,
"product_slider_e_bike": 6.0,
"product_minderest": 0.0,
"product_zubehora_article": "",
"product_click_and_collect": 0.0,
"product_store_available": 0.0,
"product_vk2_amazon": 1799.0,
"product_vk3_ebay": 1799.0,
"product_parent_article": 770041.1
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Tenways CGO600 Plus 360 Wh Herren blau 2025"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1799.0,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 1511.76,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 0.0,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 0.0
},
"fields": {
"displayGroup": [
"fec09d3bd130b3a5f4fec211f1fe4fa1"
]
},
"sort": [
1799.0
]
}
]
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|