| 1 |
5.31 ms |
Request:
{"index":"shopware6-stage_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"should":[{"terms":{"productNumber":["600078"]}}]}},{"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_rule01975ef38cc573348c70ad29f503bcd5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019d0b19e2617d48a24a92ca989c6dd2_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": 2,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"max_score": null,
"hits": [
{
"_index": "shopware6-stage_product_1773667835",
"_id": "3def5d3a2dc174e7595c98856028b1c7",
"_score": null,
"_source": {
"id": "3def5d3a2dc174e7595c98856028b1c7",
"autoIncrement": 87406.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 2,
"productNumber": "600078",
"ean": "4015731041273",
"displayGroup": "936422114a443f6a060eab4d2148db91",
"sales": 0,
"stock": 2,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "02715b264be6320d09a0fa2a841e6551",
"manufacturerNumber": "4127",
"releaseDate": null,
"createdAt": "2023-10-16T12:34:46+00:00",
"categoryTree": [],
"categoriesRo": [],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "95d55ece3d635961c886cfbffb9da4f7",
"childCount": 0,
"categories": [],
"manufacturer": {
"id": "02715b264be6320d09a0fa2a841e6551",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Puky"
},
"_count": 1
},
"properties": [
{
"id": "070ac134efcc0095f5dbbdadce4d7658",
"_count": 1,
"groupId": "b33509e4101693a82829fd320a7394ef",
"group": {
"id": "b33509e4101693a82829fd320a7394ef",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "M\u00e4dchen"
}
},
{
"id": "0e0fa82e5287669c91d7ea4eb141e86c",
"_count": 1,
"groupId": "9ce1042f3530e102e670fd8040e9495a",
"group": {
"id": "9ce1042f3530e102e670fd8040e9495a",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "spezieller Kindersattel"
}
},
{
"id": "352ca97ff32a3f14269cb5b12d43a0d8",
"_count": 1,
"groupId": "cf3fbe199317cb59105ece4c22b93a6f",
"group": {
"id": "cf3fbe199317cb59105ece4c22b93a6f",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Seitenst\u00e4nder"
}
},
{
"id": "361b4aa3a74d719b1280abb0af9746a5",
"_count": 1,
"groupId": "8f5fb50f0ee251c4c2af213e489e63bb",
"group": {
"id": "8f5fb50f0ee251c4c2af213e489e63bb",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "3"
}
},
{
"id": "3ed47e4ae6da84ec4f255ab95fce260f",
"_count": 1,
"groupId": "16fd55d02a23f31097ca58eccfeec97c",
"group": {
"id": "16fd55d02a23f31097ca58eccfeec97c",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "gr\u00fcn"
}
},
{
"id": "410581c6d12156c8a57924212352cb23",
"_count": 1,
"groupId": "bf2129aece92fe202715f8914e9d9e95",
"group": {
"id": "bf2129aece92fe202715f8914e9d9e95",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "geflochtener Lenkerkorb aus Kunststoff"
}
},
{
"id": "485c1f0d0dcb78ae19e9b0ab2eb76318",
"_count": 1,
"groupId": "67257a0b244c56fc1f85cbf6ae0eb5f7",
"group": {
"id": "67257a0b244c56fc1f85cbf6ae0eb5f7",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "60 kg"
}
},
{
"id": "4cbf13633db80961c83f32a06735b580",
"_count": 1,
"groupId": "8d3c06e4ef7fec22377ee4ea56e7df6a",
"group": {
"id": "8d3c06e4ef7fec22377ee4ea56e7df6a",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "ohne Schaltung"
}
},
{
"id": "4ec969a032686f09de30ead2a801c018",
"_count": 1,
"groupId": "611e9d73fb6447db4ff09b58ecadce21",
"group": {
"id": "611e9d73fb6447db4ff09b58ecadce21",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nein"
}
},
{
"id": "58c145c4dae0b06fb70e490691aa683e",
"_count": 1,
"groupId": "f5fed9bc267410759ab04276601a9f42",
"group": {
"id": "f5fed9bc267410759ab04276601a9f42",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "12\""
}
},
{
"id": "6299d093e5b08ce9060c40e1355553ff",
"_count": 1,
"groupId": "6952d7680528b2ba9f7ab0e454eed1db",
"group": {
"id": "6952d7680528b2ba9f7ab0e454eed1db",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "12x1,75 Reifen mit guter D\u00e4mpfungseigenschaft und"
}
},
{
"id": "8033f1c474af9ae74bc1aa53ea9349e7",
"_count": 1,
"groupId": "c3beefaefa0c82a810da3211f962fa99",
"group": {
"id": "c3beefaefa0c82a810da3211f962fa99",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "22 cm"
}
},
{
"id": "8701b86b9b143fc5bddeee6a005d8da0",
"_count": 1,
"groupId": "503f306fc1edbd32bb55a9d4d3994f8d",
"group": {
"id": "503f306fc1edbd32bb55a9d4d3994f8d",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "1"
}
},
{
"id": "948dbe032e97b59da9bb73393433b830",
"_count": 1,
"groupId": "ae1de98645eed200149ba8a40a93df97",
"group": {
"id": "ae1de98645eed200149ba8a40a93df97",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Unicrown-Gabel"
}
},
{
"id": "9acc664466a84ba14ebd9f39e8f4698e",
"_count": 1,
"groupId": "79958f9b32c396332e45ef4487152f13",
"group": {
"id": "79958f9b32c396332e45ef4487152f13",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ja"
}
},
{
"id": "9bb0febe7f032a24e43dbbf2302c1fb4",
"_count": 1,
"groupId": "b452f9cfcee052c98c3cc127a83eb467",
"group": {
"id": "b452f9cfcee052c98c3cc127a83eb467",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "ca. 7,2 kg"
}
},
{
"id": "a02f92ccbe2773615526e843bb5a61cb",
"_count": 1,
"groupId": "a16022e7816ee4b03a8e54519ee7bf02",
"group": {
"id": "a16022e7816ee4b03a8e54519ee7bf02",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "11"
}
},
{
"id": "b36a5fe8ac3493ded80f39d28e54b74d",
"_count": 1,
"groupId": "f7a9fede8828c7ad00054338044d0dbe",
"group": {
"id": "f7a9fede8828c7ad00054338044d0dbe",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Felgenbremse"
}
},
{
"id": "bcfe666d67526d3bd8692c446595ec5c",
"_count": 1,
"groupId": "a8c218e8daf51c2528ffec6ba60c0c07",
"group": {
"id": "a8c218e8daf51c2528ffec6ba60c0c07",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "verstellbar"
}
},
{
"id": "c28e0fa4ab41a3b101ea3782a17db5e9",
"_count": 1,
"groupId": "f9109ae7ce709818cf47ead51feb3096",
"group": {
"id": "f9109ae7ce709818cf47ead51feb3096",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Comfort"
}
},
{
"id": "c6635044fc8b3449acf900f2f9177c0b",
"_count": 1,
"groupId": "ea9a44ed7ed83415d29d57fcdd199e52",
"group": {
"id": "ea9a44ed7ed83415d29d57fcdd199e52",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "rutschfeste Pedale mit drittem Reflektor"
}
},
{
"id": "c72afe318b3b713c5ad486b5fe0ca88b",
"_count": 1,
"groupId": "4b20688ca061fc9a853d8dd3c4625fa8",
"group": {
"id": "4b20688ca061fc9a853d8dd3c4625fa8",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Alu-Lenker, h\u00f6henverstellbar"
}
},
{
"id": "d215aedab5221382a37a177485268129",
"_count": 1,
"groupId": "1dfcee408979620926ced38d7ae45bb3",
"group": {
"id": "1dfcee408979620926ced38d7ae45bb3",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Aluminium"
}
},
{
"id": "f8401f604868143d62b70a4c18d8e2ea",
"_count": 1,
"groupId": "3ea4bb03c22f227764c0c1fc05655f9f",
"group": {
"id": "3ea4bb03c22f227764c0c1fc05655f9f",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Aluminiumfelge"
}
},
{
"id": "fb9a063b7b4cc4449ac8c1afefd47cd1",
"_count": 1,
"groupId": "c259161c2ad279d194b0a5cfe729e273",
"group": {
"id": "c259161c2ad279d194b0a5cfe729e273",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "geschlossenser Kettenkasten"
}
},
{
"id": "fbe1ddde1b262e35d6cebc25d5e2aeb6",
"_count": 1,
"groupId": "adf2abbdb5a021f12b6bc1a1fd34dbc7",
"group": {
"id": "adf2abbdb5a021f12b6bc1a1fd34dbc7",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2026"
}
}
],
"options": [
{
"id": "8033f1c474af9ae74bc1aa53ea9349e7",
"_count": 1,
"groupId": "c3beefaefa0c82a810da3211f962fa99",
"group": {
"id": "c3beefaefa0c82a810da3211f962fa99",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "22 cm"
}
}
],
"categoryIds": [],
"optionIds": [
"8033f1c474af9ae74bc1aa53ea9349e7"
],
"propertyIds": [
"070ac134efcc0095f5dbbdadce4d7658",
"0e0fa82e5287669c91d7ea4eb141e86c",
"352ca97ff32a3f14269cb5b12d43a0d8",
"361b4aa3a74d719b1280abb0af9746a5",
"3ed47e4ae6da84ec4f255ab95fce260f",
"410581c6d12156c8a57924212352cb23",
"485c1f0d0dcb78ae19e9b0ab2eb76318",
"4cbf13633db80961c83f32a06735b580",
"4ec969a032686f09de30ead2a801c018",
"58c145c4dae0b06fb70e490691aa683e",
"6299d093e5b08ce9060c40e1355553ff",
"8033f1c474af9ae74bc1aa53ea9349e7",
"8701b86b9b143fc5bddeee6a005d8da0",
"948dbe032e97b59da9bb73393433b830",
"9acc664466a84ba14ebd9f39e8f4698e",
"9bb0febe7f032a24e43dbbf2302c1fb4",
"a02f92ccbe2773615526e843bb5a61cb",
"b36a5fe8ac3493ded80f39d28e54b74d",
"bcfe666d67526d3bd8692c446595ec5c",
"c28e0fa4ab41a3b101ea3782a17db5e9",
"c6635044fc8b3449acf900f2f9177c0b",
"c72afe318b3b713c5ad486b5fe0ca88b",
"d215aedab5221382a37a177485268129",
"f8401f604868143d62b70a4c18d8e2ea",
"fb9a063b7b4cc4449ac8c1afefd47cd1",
"fbe1ddde1b262e35d6cebc25d5e2aeb6"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"product_slider_einsatz": 0.0,
"product_slider_terrain": 0.0,
"product_slider_ausstattung": 0.0,
"product_slider_e_bike": 0.0,
"product_minderest": 0.0,
"product_zubehora_article": "",
"product_click_and_collect": 1.0,
"product_store_available": 1.0,
"product_parent_article": 600078.0,
"product_vk2_amazon": 279.0,
"product_vk3_ebay": 279.0
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Puky Youke Classic 12'' gr\u00fcn 2026"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": " Puky Youke 12-1 Classic Das erste richtige Kinderfahrrad Das Puky Youke 12-1 Classic ist ideal f\u00fcr Kinder, die vom Laufrad aufs erste richtige Fahrrad umsteigen. Der kindgerechte 12\"-Rahmen mit niedrigem Einstieg und kurzem Oberrohr sorgt f\u00fcr viel Sicherheit und ein leichtes Auf- und Absteigen perfekt f\u00fcr die ersten Runden vor dem Haus, im Park oder auf dem Hof. Die leichtg\u00e4ngige Tretkurbel und das einfache R\u00fccktritt-\/Felgenbremssystem sind optimal auf kleine Kinderh\u00e4nde und -f\u00fc\u00dfe abgestimmt. So lernen die Kids spielerisch Anfahren, Bremsen und Gleichgewicht halten, ohne \u00fcberfordert zu werden. Das gutm\u00fctige Lenkverhalten unterst\u00fctzt dabei jeden Fortschritt. Mit Schutzblechen, Kettenschutz und kindgerechtem Sattel ist das Youke 12-1 Classic alltagstauglich und pflegeleicht einfach draufsetzen, losrollen und Spa\u00df haben. Highlights auf einen Blick: Kindgerechter 12\"-Rahmen mit tiefem Einstieg Sicheres Bremskonzept mit R\u00fccktritt und Handbremse Leichtg\u00e4ngige Tretkurbel f\u00fcr kleine Kinder Voll gesch\u00fctzter Antrieb dank Kettenschutz Robuste Bauweise und stabile Laufr\u00e4der Sichere dir jetzt das Puky Youke 12-1 Classic und mach die ersten Fahrradversuche deines Kindes sicher und spielerisch leicht!"
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 299.0,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 251.26
},
"fields": {
"displayGroup": [
"936422114a443f6a060eab4d2148db91"
]
},
"sort": [
299.0
]
}
]
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|