| 1 |
13.68 ms |
Request:
{"index":"shopware6-stage_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"should":[{"terms":{"productNumber":["600028","600029"]}}]}},{"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": "0c6dce80dc1c3dfa405399ba0374ce55",
"_score": null,
"_source": {
"id": "0c6dce80dc1c3dfa405399ba0374ce55",
"autoIncrement": 86042.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": true,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 1,
"productNumber": "600028",
"ean": "4015731041341",
"displayGroup": "178e69c04650d6e7b5ed4161c93f7c63",
"sales": 0,
"stock": 1,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "02715b264be6320d09a0fa2a841e6551",
"manufacturerNumber": "4134",
"releaseDate": null,
"createdAt": "2023-10-16T11:34:29+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"33e75ff09dd601bbe69f351039152189",
"72b32a1f754ba1c09b3695e0cb6cde7f",
"66f041e16a60928b05a7e228a89c3799"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "33e75ff09dd601bbe69f351039152189",
"_count": 1
},
{
"id": "72b32a1f754ba1c09b3695e0cb6cde7f",
"_count": 1
},
{
"id": "66f041e16a60928b05a7e228a89c3799",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "cb1475abfb39ae04c945ac32fff59565",
"childCount": 0,
"categories": [
{
"id": "33e75ff09dd601bbe69f351039152189",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrr\u00e4der"
}
},
{
"id": "66f041e16a60928b05a7e228a89c3799",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Spielfahrrad 12 Zoll"
}
},
{
"id": "72b32a1f754ba1c09b3695e0cb6cde7f",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Spielfahrrad 12 - 18 Zoll"
}
}
],
"manufacturer": {
"id": "02715b264be6320d09a0fa2a841e6551",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Puky"
},
"_count": 1
},
"properties": [
{
"id": "00057c99e5e8d330a7a5d13745109017",
"_count": 1,
"groupId": "3ea4bb03c22f227764c0c1fc05655f9f",
"group": {
"id": "3ea4bb03c22f227764c0c1fc05655f9f",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Alu-Felgen"
}
},
{
"id": "01c3b1b8d5d97cba1f77c145f8933dc2",
"_count": 1,
"groupId": "16fd55d02a23f31097ca58eccfeec97c",
"group": {
"id": "16fd55d02a23f31097ca58eccfeec97c",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "pink"
}
},
{
"id": "070ac134efcc0095f5dbbdadce4d7658",
"_count": 1,
"groupId": "b33509e4101693a82829fd320a7394ef",
"group": {
"id": "b33509e4101693a82829fd320a7394ef",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "M\u00e4dchen"
}
},
{
"id": "0d2073271c4c722f78733c30f2428a33",
"_count": 1,
"groupId": "4b20688ca061fc9a853d8dd3c4625fa8",
"group": {
"id": "4b20688ca061fc9a853d8dd3c4625fa8",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Alu-Lenker h\u00f6henverstellbar"
}
},
{
"id": "1eefc25dfb07df4e200ed6e6b5ebfd7a",
"_count": 1,
"groupId": "f424bfe0316bd62a53f56a46d5eb8d7d",
"group": {
"id": "f424bfe0316bd62a53f56a46d5eb8d7d",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nein"
}
},
{
"id": "361b4aa3a74d719b1280abb0af9746a5",
"_count": 1,
"groupId": "8f5fb50f0ee251c4c2af213e489e63bb",
"group": {
"id": "8f5fb50f0ee251c4c2af213e489e63bb",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "3"
}
},
{
"id": "3a616a5305e06ccc883bda3ab63b10b5",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
},
{
"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": "6157791e1632eee1c30ede004c4b558a",
"_count": 1,
"groupId": "c259161c2ad279d194b0a5cfe729e273",
"group": {
"id": "c259161c2ad279d194b0a5cfe729e273",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "geschlossener Kettenkasten"
}
},
{
"id": "68852a4dc9ab0d2c3856f621d06e76ce",
"_count": 1,
"groupId": "bf2129aece92fe202715f8914e9d9e95",
"group": {
"id": "bf2129aece92fe202715f8914e9d9e95",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "zul\u00e4ssiges Gesamtgewicht 60 kg"
}
},
{
"id": "77b9f5e6491324816ee959ba249443d0",
"_count": 1,
"groupId": "6c08e78b28fa89c1c312ff53e2d81088",
"group": {
"id": "6c08e78b28fa89c1c312ff53e2d81088",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kunststoffkantensch\u00fctzer am Vorderrad- und Hinterradschutzblech"
}
},
{
"id": "7d83eab4f69a2428147fef78e8d33fe8",
"_count": 1,
"groupId": "a6422bb08b1146d1c55779ac81586ab3",
"group": {
"id": "a6422bb08b1146d1c55779ac81586ab3",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "inklusive"
}
},
{
"id": "8701b86b9b143fc5bddeee6a005d8da0",
"_count": 1,
"groupId": "503f306fc1edbd32bb55a9d4d3994f8d",
"group": {
"id": "503f306fc1edbd32bb55a9d4d3994f8d",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "1"
}
},
{
"id": "98a153ccf54d41da6a3402a43b703eb1",
"_count": 1,
"groupId": "c3beefaefa0c82a810da3211f962fa99",
"group": {
"id": "c3beefaefa0c82a810da3211f962fa99",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Onesize"
}
},
{
"id": "9acc664466a84ba14ebd9f39e8f4698e",
"_count": 1,
"groupId": "79958f9b32c396332e45ef4487152f13",
"group": {
"id": "79958f9b32c396332e45ef4487152f13",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ja"
}
},
{
"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": "b91712f86147fa09ada8320b560a6633",
"_count": 1,
"groupId": "ea9a44ed7ed83415d29d57fcdd199e52",
"group": {
"id": "ea9a44ed7ed83415d29d57fcdd199e52",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "kindgerechte, rutschfeste Pedale mit drittem Reflektor"
}
},
{
"id": "c28e0fa4ab41a3b101ea3782a17db5e9",
"_count": 1,
"groupId": "f9109ae7ce709818cf47ead51feb3096",
"group": {
"id": "f9109ae7ce709818cf47ead51feb3096",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Comfort"
}
},
{
"id": "d14234136d6d332d9605d06a7a79a122",
"_count": 1,
"groupId": "adf2abbdb5a021f12b6bc1a1fd34dbc7",
"group": {
"id": "adf2abbdb5a021f12b6bc1a1fd34dbc7",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2023"
}
},
{
"id": "d215aedab5221382a37a177485268129",
"_count": 1,
"groupId": "1dfcee408979620926ced38d7ae45bb3",
"group": {
"id": "1dfcee408979620926ced38d7ae45bb3",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Aluminium"
}
},
{
"id": "ee6e26dddd2c1946b64e840368396777",
"_count": 1,
"groupId": "ae1de98645eed200149ba8a40a93df97",
"group": {
"id": "ae1de98645eed200149ba8a40a93df97",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Stahl"
}
}
],
"options": [
{
"id": "98a153ccf54d41da6a3402a43b703eb1",
"_count": 1,
"groupId": "c3beefaefa0c82a810da3211f962fa99",
"group": {
"id": "c3beefaefa0c82a810da3211f962fa99",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Onesize"
}
}
],
"categoryIds": [
"33e75ff09dd601bbe69f351039152189",
"66f041e16a60928b05a7e228a89c3799",
"72b32a1f754ba1c09b3695e0cb6cde7f"
],
"optionIds": [
"98a153ccf54d41da6a3402a43b703eb1"
],
"propertyIds": [
"00057c99e5e8d330a7a5d13745109017",
"01c3b1b8d5d97cba1f77c145f8933dc2",
"070ac134efcc0095f5dbbdadce4d7658",
"0d2073271c4c722f78733c30f2428a33",
"1eefc25dfb07df4e200ed6e6b5ebfd7a",
"361b4aa3a74d719b1280abb0af9746a5",
"3a616a5305e06ccc883bda3ab63b10b5",
"4cbf13633db80961c83f32a06735b580",
"4ec969a032686f09de30ead2a801c018",
"58c145c4dae0b06fb70e490691aa683e",
"6157791e1632eee1c30ede004c4b558a",
"68852a4dc9ab0d2c3856f621d06e76ce",
"77b9f5e6491324816ee959ba249443d0",
"7d83eab4f69a2428147fef78e8d33fe8",
"8701b86b9b143fc5bddeee6a005d8da0",
"98a153ccf54d41da6a3402a43b703eb1",
"9acc664466a84ba14ebd9f39e8f4698e",
"a02f92ccbe2773615526e843bb5a61cb",
"b36a5fe8ac3493ded80f39d28e54b74d",
"b91712f86147fa09ada8320b560a6633",
"c28e0fa4ab41a3b101ea3782a17db5e9",
"d14234136d6d332d9605d06a7a79a122",
"d215aedab5221382a37a177485268129",
"ee6e26dddd2c1946b64e840368396777"
],
"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": 1.0,
"product_zubehora_article": "",
"product_click_and_collect": 1.0,
"product_store_available": 1.0,
"product_parent_article": 600028.0,
"product_vk2_amazon": 259.99,
"product_vk3_ebay": 259.99
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Puky Youke 12 Alu rosa 2023"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "PUKY Youke 12-1 PUKY Youke 12\" ist das Kinderfahrrad f\u00fcr Alle, mit dem wir Fahrradfahren lernen garantieren. Die neueste Generation Kinderfahrrad mit perfekter Geometrie ist das Ergebnis aus 70 Jahren Erfahrung. Ein tiefer Rahmeneinstieg und die niedrige \u00dcberstandsh\u00f6he des PUKY Youke 12\" sorgen f\u00fcr optimales Auf- und Absteigen des Kindes. Zudem wurden die Lenkerbreiten sowie das \u00dcbersetzungsverh\u00e4ltnis am Youke optimiert und neu abgestimmt. Leichte Aluminiumkomponenten wie der Rahmen, Lenker und die Kurbeln gew\u00e4hrleisten ein perfektes Gewichtsverh\u00e4ltnis zwischen dem Kind und seinem PUKY Youke 12\". Vollausgestattet mit einem serienm\u00e4\u00dfigen Gep\u00e4cktr\u00e4ger und einem kindgerechten V-Brake Bremssystem l\u00e4sst das PUKY Youke 12\" keine W\u00fcnsche offen. Selbst ohne vorherige Erfahrung mit einem Laufrad gemacht zu haben, werden die zuk\u00fcnftigen Helden der Stra\u00dfe innerhalb von 14 Tagen eigenst\u00e4ndig fahren k\u00f6nnen."
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 259.0,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 217.65,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 0.38,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 0.38
},
"fields": {
"displayGroup": [
"178e69c04650d6e7b5ed4161c93f7c63"
]
},
"sort": [
259.0
]
}
]
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|