| 1 |
4.86 ms |
Request:
{"index":"shopware6-stage_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"should":[{"terms":{"productNumber":["600087"]}}]}},{"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": "96634c9eae730560554db331c5020cb7",
"_score": null,
"_source": {
"id": "96634c9eae730560554db331c5020cb7",
"autoIncrement": 87447.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 2,
"productNumber": "600087",
"ean": "4015731043406",
"displayGroup": "6ab4952f4c2c78d7e292791e69e463b5",
"sales": 0,
"stock": 2,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "02715b264be6320d09a0fa2a841e6551",
"manufacturerNumber": "4340",
"releaseDate": null,
"createdAt": "2023-10-16T12:47:04+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"33e75ff09dd601bbe69f351039152189",
"72b32a1f754ba1c09b3695e0cb6cde7f",
"072b030ba126b2f4b2374f342be9ed44"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "33e75ff09dd601bbe69f351039152189",
"_count": 1
},
{
"id": "72b32a1f754ba1c09b3695e0cb6cde7f",
"_count": 1
},
{
"id": "072b030ba126b2f4b2374f342be9ed44",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "2db28ed5604a9ddbffd7cba5510fd1b0",
"childCount": 0,
"categories": [
{
"id": "072b030ba126b2f4b2374f342be9ed44",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Spielfahrrad 18 Zoll"
}
},
{
"id": "33e75ff09dd601bbe69f351039152189",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrr\u00e4der"
}
},
{
"id": "72b32a1f754ba1c09b3695e0cb6cde7f",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Spielfahrrad 12 - 18 Zoll"
}
}
],
"manufacturer": {
"id": "02715b264be6320d09a0fa2a841e6551",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Puky"
},
"_count": 1
},
"properties": [
{
"id": "0976a89012ccad20811433a053b0b60c",
"_count": 1,
"groupId": "6952d7680528b2ba9f7ab0e454eed1db",
"group": {
"id": "6952d7680528b2ba9f7ab0e454eed1db",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "18x1,75 Reifen mit guter D\u00e4mpfungseigenschaft und geringem Rollwiderstand"
}
},
{
"id": "118b2e1704ce3dd22a61e2c1cb5422a6",
"_count": 1,
"groupId": "bf2129aece92fe202715f8914e9d9e95",
"group": {
"id": "bf2129aece92fe202715f8914e9d9e95",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "zul\u00e4ssiges Gesamtgewicht 60kg, Seitenst\u00e4nder, felochtener Lenkerkorb aus Kunststoff"
}
},
{
"id": "1aaa2e480c643a401f0cce830d242241",
"_count": 1,
"groupId": "f5fed9bc267410759ab04276601a9f42",
"group": {
"id": "f5fed9bc267410759ab04276601a9f42",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "18\""
}
},
{
"id": "1eefc25dfb07df4e200ed6e6b5ebfd7a",
"_count": 1,
"groupId": "f424bfe0316bd62a53f56a46d5eb8d7d",
"group": {
"id": "f424bfe0316bd62a53f56a46d5eb8d7d",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nein"
}
},
{
"id": "319a89fc514556255bab919cc9791ece",
"_count": 1,
"groupId": "8f5fb50f0ee251c4c2af213e489e63bb",
"group": {
"id": "8f5fb50f0ee251c4c2af213e489e63bb",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "4"
}
},
{
"id": "3a616a5305e06ccc883bda3ab63b10b5",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
},
{
"id": "3ed47e4ae6da84ec4f255ab95fce260f",
"_count": 1,
"groupId": "16fd55d02a23f31097ca58eccfeec97c",
"group": {
"id": "16fd55d02a23f31097ca58eccfeec97c",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "gr\u00fcn"
}
},
{
"id": "4abe9bab22c60b3a423d71f36f961175",
"_count": 1,
"groupId": "c3beefaefa0c82a810da3211f962fa99",
"group": {
"id": "c3beefaefa0c82a810da3211f962fa99",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "27 cm"
}
},
{
"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": "6157791e1632eee1c30ede004c4b558a",
"_count": 1,
"groupId": "c259161c2ad279d194b0a5cfe729e273",
"group": {
"id": "c259161c2ad279d194b0a5cfe729e273",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "geschlossener Kettenkasten"
}
},
{
"id": "7c03ab1ae7980106bf3e79671f37ad56",
"_count": 1,
"groupId": "b33509e4101693a82829fd320a7394ef",
"group": {
"id": "b33509e4101693a82829fd320a7394ef",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Jungen"
}
},
{
"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": "9f8183796b1e2870cc29338c7f657bb9",
"_count": 1,
"groupId": "b452f9cfcee052c98c3cc127a83eb467",
"group": {
"id": "b452f9cfcee052c98c3cc127a83eb467",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "ca. 8,7 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": "fbe1ddde1b262e35d6cebc25d5e2aeb6",
"_count": 1,
"groupId": "adf2abbdb5a021f12b6bc1a1fd34dbc7",
"group": {
"id": "adf2abbdb5a021f12b6bc1a1fd34dbc7",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2026"
}
}
],
"options": [
{
"id": "4abe9bab22c60b3a423d71f36f961175",
"_count": 1,
"groupId": "c3beefaefa0c82a810da3211f962fa99",
"group": {
"id": "c3beefaefa0c82a810da3211f962fa99",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "27 cm"
}
}
],
"categoryIds": [
"072b030ba126b2f4b2374f342be9ed44",
"33e75ff09dd601bbe69f351039152189",
"72b32a1f754ba1c09b3695e0cb6cde7f"
],
"optionIds": [
"4abe9bab22c60b3a423d71f36f961175"
],
"propertyIds": [
"0976a89012ccad20811433a053b0b60c",
"118b2e1704ce3dd22a61e2c1cb5422a6",
"1aaa2e480c643a401f0cce830d242241",
"1eefc25dfb07df4e200ed6e6b5ebfd7a",
"319a89fc514556255bab919cc9791ece",
"3a616a5305e06ccc883bda3ab63b10b5",
"3ed47e4ae6da84ec4f255ab95fce260f",
"4abe9bab22c60b3a423d71f36f961175",
"4cbf13633db80961c83f32a06735b580",
"4ec969a032686f09de30ead2a801c018",
"6157791e1632eee1c30ede004c4b558a",
"7c03ab1ae7980106bf3e79671f37ad56",
"8701b86b9b143fc5bddeee6a005d8da0",
"948dbe032e97b59da9bb73393433b830",
"9acc664466a84ba14ebd9f39e8f4698e",
"9f8183796b1e2870cc29338c7f657bb9",
"a02f92ccbe2773615526e843bb5a61cb",
"b36a5fe8ac3493ded80f39d28e54b74d",
"bcfe666d67526d3bd8692c446595ec5c",
"c28e0fa4ab41a3b101ea3782a17db5e9",
"c6635044fc8b3449acf900f2f9177c0b",
"c72afe318b3b713c5ad486b5fe0ca88b",
"d215aedab5221382a37a177485268129",
"f8401f604868143d62b70a4c18d8e2ea",
"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": 600087.0,
"product_vk2_amazon": 309.0,
"product_vk3_ebay": 309.0
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Puky Youke Classic 18'' gr\u00fcn 2026"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": " Puky Youke 18-1 Kinderfahrrad f\u00fcr kleine Alltagshelden Das Puky Youke 18-1 ist ideal f\u00fcr Kinder, die schon sicher fahren und jetzt l\u00e4ngere Strecken meistern wollen. Der kindgerechte 18\"-Rahmen mit niedrigem Einstieg sorgt f\u00fcr einfaches Auf- und Absteigen und gibt viel Sicherheit perfekt f\u00fcr den Schulweg, Besuche bei Freunden oder gr\u00f6\u00dfere Touren mit der Familie. Die leichtg\u00e4ngige Tretkurbel und das Bremskonzept aus R\u00fccktrittbremse hinten und Handbremse vorne sind optimal auf Kinder abgestimmt. So lernen sie kontrolliertes Bremsen und sicheres Anhalten, ohne \u00fcberfordert zu werden. Das gutm\u00fctige Lenkverhalten hilft dabei, immer die Kontrolle zu behalten, auch wenn es mal schneller wird. Mit Schutzblechen, Kettenschutz und kindgerechtem Sattel ist das Youke 18-1 robust, pflegeleicht und alltagstauglich einfach aufsteigen, losfahren und Spa\u00df haben. Highlights auf einen Blick: Kindgerechter 18\"-Rahmen mit tiefem Einstieg Sicheres Bremskonzept mit R\u00fccktritt und Handbremse vorne Leichtg\u00e4ngige Tretkurbel f\u00fcr kleine Beine Voll gesch\u00fctzter Antrieb dank Kettenschutz Robuste Bauweise und stabile Laufr\u00e4der Ideal f\u00fcr Schulweg, Alltag und Freizeit Sichere dir jetzt das Puky Youke 18-1 und mach jede Fahrt deines Kindes sicher, spielerisch und voller Fahrspa\u00df!"
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 339.0,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 284.87
},
"fields": {
"displayGroup": [
"6ab4952f4c2c78d7e292791e69e463b5"
]
},
"sort": [
339.0
]
}
]
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|