| 1 |
5.31 ms |
Request:
{"index":"shopware6-stage_product","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"term":{"manufacturerId":"6ade65952b3e86de75865d31749e3b75"}},{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"01895226670e72a4a15f371adce297ad"}}]}}}},{"term":{"active":true}}]}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"sort":[{"_script":{"type":"string","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.toString();\n }\n}\n\nreturn '';\n","lang":"painless","params":{"field":"name","languages":["2fbb5fe2e29a4d70aa5854ce7ce3e20b"]}},"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":12,"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": {
"total": {
"value": 4,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "shopware6-stage_product_1773667835",
"_id": "c96c08f8bb7960e11a1239352a479053",
"_score": null,
"_source": {
"id": "c96c08f8bb7960e11a1239352a479053",
"autoIncrement": 86967.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 6,
"productNumber": "4310",
"ean": "4251239301277",
"displayGroup": "d57a167276ee079beb31e1f4c2c7541d",
"sales": 0,
"stock": 6,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "6ade65952b3e86de75865d31749e3b75",
"manufacturerNumber": "060-32500",
"releaseDate": null,
"createdAt": "2023-10-16T11:39:47+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"357a6fdf7642bf815a88822c447d9dc4",
"140f6969d5213fd0ece03148e62e461e",
"4c5bde74a8f110656874902f07378009",
"eecca5b6365d9607ee5a9d336962c534"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "357a6fdf7642bf815a88822c447d9dc4",
"_count": 1
},
{
"id": "140f6969d5213fd0ece03148e62e461e",
"_count": 1
},
{
"id": "4c5bde74a8f110656874902f07378009",
"_count": 1
},
{
"id": "eecca5b6365d9607ee5a9d336962c534",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "e48803ba118090d9594e4dcae98f39f4",
"childCount": 0,
"categories": [
{
"id": "140f6969d5213fd0ece03148e62e461e",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "S\u00e4ttel & Sattelst\u00fctzen"
}
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
}
},
{
"id": "357a6fdf7642bf815a88822c447d9dc4",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrradteile"
}
},
{
"id": "4c5bde74a8f110656874902f07378009",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sattelst\u00fctzen"
}
},
{
"id": "eecca5b6365d9607ee5a9d336962c534",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r"
}
}
],
"manufacturer": {
"id": "6ade65952b3e86de75865d31749e3b75",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BySchluz"
},
"_count": 1
},
"properties": [
{
"id": "3a616a5305e06ccc883bda3ab63b10b5",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
}
],
"options": [],
"categoryIds": [
"140f6969d5213fd0ece03148e62e461e",
"28dd2c7955ce926456240b2ff0100bde",
"357a6fdf7642bf815a88822c447d9dc4",
"4c5bde74a8f110656874902f07378009",
"eecca5b6365d9607ee5a9d336962c534"
],
"optionIds": [],
"propertyIds": [
"3a616a5305e06ccc883bda3ab63b10b5"
],
"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": "Montage",
"product_click_and_collect": 1.0,
"product_store_available": 1.0,
"product_parent_article": "",
"product_vk2_amazon": 10.95,
"product_vk3_ebay": 10.95
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BySchulz Feder soft rot 45-65 kg"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Mit unterschiedlich stark federnden Federelementen kann jeder Fahrer seine byschulz parallelogramm Sattelst\u00fctze G.2 bzw. D2 individuell auf sein Gewicht abstimmen. Die einfach austauschbaren Federelemente bestehen aus einer Flachdrahtstahlfeder mit innenliegendem Elastomer. F\u00fcr die ST \/short travel Versionen werden jeweils in 5 verschiedenen H\u00e4rtegraden f\u00fcr Fahrergewichte von 45 bis 150 kg angeboten. Die Grundfarbe der Feder ist silber, mit einem Farbcode ist die Federh\u00e4rte gekennzeichnet. Produktdetails:L\u00e4nge: 72 mmFederweg Sattelst\u00fctze: 30 mmMaterial: StahlGewicht **: 90 gBelastbarkeit: Fahrergewicht 45 - 65 kgHerstellerfarbe: rot"
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 23.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 20.13
},
"fields": {
"displayGroup": [
"d57a167276ee079beb31e1f4c2c7541d"
]
},
"sort": [
"byschulz feder soft rot 45-65 kg"
]
},
{
"_index": "shopware6-stage_product_1773667835",
"_id": "46c7cb50b373877fb2f8d5c4517bb969",
"_score": null,
"_source": {
"id": "46c7cb50b373877fb2f8d5c4517bb969",
"autoIncrement": 81748.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 5,
"productNumber": "7941",
"ean": "4251239307491",
"displayGroup": "c8d03b01ab0228915b8218f61388dc30",
"sales": 0,
"stock": 5,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "6ade65952b3e86de75865d31749e3b75",
"manufacturerNumber": "060-32451",
"releaseDate": null,
"createdAt": "2023-10-16T11:12:16+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"357a6fdf7642bf815a88822c447d9dc4",
"140f6969d5213fd0ece03148e62e461e",
"4c5bde74a8f110656874902f07378009",
"cedebb6e872f539bef8c3f919874e9d7"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "357a6fdf7642bf815a88822c447d9dc4",
"_count": 1
},
{
"id": "140f6969d5213fd0ece03148e62e461e",
"_count": 1
},
{
"id": "4c5bde74a8f110656874902f07378009",
"_count": 1
},
{
"id": "cedebb6e872f539bef8c3f919874e9d7",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": "f819c8f48fb2a7c124b13b344ea63ae9",
"coverId": "fb79a562da8bcd113931acbac589c6d3",
"childCount": 0,
"categories": [
{
"id": "140f6969d5213fd0ece03148e62e461e",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "S\u00e4ttel & Sattelst\u00fctzen"
}
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
}
},
{
"id": "357a6fdf7642bf815a88822c447d9dc4",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrradteile"
}
},
{
"id": "4c5bde74a8f110656874902f07378009",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sattelst\u00fctzen"
}
},
{
"id": "cedebb6e872f539bef8c3f919874e9d7",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "gefedert"
}
}
],
"manufacturer": {
"id": "6ade65952b3e86de75865d31749e3b75",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BySchluz"
},
"_count": 1
},
"properties": [
{
"id": "3a616a5305e06ccc883bda3ab63b10b5",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
},
{
"id": "9ff38779cbffeae98512db007a31be0f",
"_count": 1,
"groupId": "e682e5d097523765cde5e59df6139363",
"group": {
"id": "e682e5d097523765cde5e59df6139363",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "27,2\/350 mm"
}
}
],
"options": [
{
"id": "9ff38779cbffeae98512db007a31be0f",
"_count": 1,
"groupId": "e682e5d097523765cde5e59df6139363",
"group": {
"id": "e682e5d097523765cde5e59df6139363",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "27,2\/350 mm"
}
}
],
"categoryIds": [
"140f6969d5213fd0ece03148e62e461e",
"28dd2c7955ce926456240b2ff0100bde",
"357a6fdf7642bf815a88822c447d9dc4",
"4c5bde74a8f110656874902f07378009",
"cedebb6e872f539bef8c3f919874e9d7"
],
"optionIds": [
"9ff38779cbffeae98512db007a31be0f"
],
"propertyIds": [
"3a616a5305e06ccc883bda3ab63b10b5",
"9ff38779cbffeae98512db007a31be0f"
],
"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": "Montage",
"product_click_and_collect": 1.0,
"product_store_available": 1.0,
"product_parent_article": 7941.1,
"product_vk2_amazon": 24.95,
"product_vk3_ebay": 24.95
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BySchulz G2 ST schwarz"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Mit top Ansprechverhalten und Fahrkomfort dank bew\u00e4hrtem Parallelogramm-Federmechanismus punktet die byschulz-Federst\u00fctze G.2 ST und das bei nur 100 mm Aufbauh\u00f6he und 30 mm Federweg. Etwa, wenn City- und Trekkingbiker \u00fcber Kopfsteinpflaster oder holprigen Schotter rollen. Um die Ersch\u00fctterungen auf Tour r\u00fcckenschonend zu kompensieren, gibt\u00b4s die verbaute Stahlfeder in f\u00fcnf verschiedenen Federh\u00e4rten. Der Federwechsel an der G.2 ST gestaltet sich kinderleicht. Mit aufs Fahrergewicht abgestimmter Stahlfeder arbeitet die Federst\u00fctze effizient, bietet bei gr\u00f6\u00dferen St\u00f6\u00dfen Reserven. Die verschiedenen Federh\u00e4rten erlauben die Nutzung der G.2 ST bei einem K\u00f6rpergewicht von 45 bis 150 kg. Nebenbei schafft es die G.2 ST, verflixt gut auszusehen: Kraftvolle, organisch flie\u00dfende Linien setzen optische Akzente. Produktdetails:L\u00e4nge: 350 mmFederweg Sattelst\u00fctze: 30 mmAusf\u00fchrung: Parallelogramm Sattelst\u00fctzeMaterial: AluminiumGewicht **: 670 gBelastbarkeit: Fahrergewich 60 - 85 kgAufbauh\u00f6he 100 mmperfekt f\u00fcr das E-BikeHerstellerfarbe: schwarz"
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 189.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 159.62
},
"fields": {
"displayGroup": [
"c8d03b01ab0228915b8218f61388dc30"
]
},
"sort": [
"byschulz g2 st schwarz"
]
},
{
"_index": "shopware6-stage_product_1773667835",
"_id": "b052e2e0c0ad1b2d5036bd56e27d061c",
"_score": null,
"_source": {
"id": "b052e2e0c0ad1b2d5036bd56e27d061c",
"autoIncrement": 86541.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 25,
"productNumber": "4303",
"ean": "4251239301314",
"displayGroup": "9e9fd578ffb3c389c1b2748e235719f1",
"sales": 0,
"stock": 25,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "6ade65952b3e86de75865d31749e3b75",
"manufacturerNumber": "060-32506",
"releaseDate": null,
"createdAt": "2023-10-16T11:37:31+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"357a6fdf7642bf815a88822c447d9dc4",
"140f6969d5213fd0ece03148e62e461e",
"4c5bde74a8f110656874902f07378009",
"eecca5b6365d9607ee5a9d336962c534"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "357a6fdf7642bf815a88822c447d9dc4",
"_count": 1
},
{
"id": "140f6969d5213fd0ece03148e62e461e",
"_count": 1
},
{
"id": "4c5bde74a8f110656874902f07378009",
"_count": 1
},
{
"id": "eecca5b6365d9607ee5a9d336962c534",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "febf06b19e76f5a2c8c1384756132837",
"childCount": 0,
"categories": [
{
"id": "140f6969d5213fd0ece03148e62e461e",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "S\u00e4ttel & Sattelst\u00fctzen"
}
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
}
},
{
"id": "357a6fdf7642bf815a88822c447d9dc4",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrradteile"
}
},
{
"id": "4c5bde74a8f110656874902f07378009",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sattelst\u00fctzen"
}
},
{
"id": "eecca5b6365d9607ee5a9d336962c534",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r"
}
}
],
"manufacturer": {
"id": "6ade65952b3e86de75865d31749e3b75",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BySchluz"
},
"_count": 1
},
"properties": [
{
"id": "3a616a5305e06ccc883bda3ab63b10b5",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
}
],
"options": [],
"categoryIds": [
"140f6969d5213fd0ece03148e62e461e",
"28dd2c7955ce926456240b2ff0100bde",
"357a6fdf7642bf815a88822c447d9dc4",
"4c5bde74a8f110656874902f07378009",
"eecca5b6365d9607ee5a9d336962c534"
],
"optionIds": [],
"propertyIds": [
"3a616a5305e06ccc883bda3ab63b10b5"
],
"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": "",
"product_vk2_amazon": 10.95,
"product_vk3_ebay": 10.95
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BySchulz Textil Schutzh\u00fclle"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Die Schutzh\u00fclle f\u00fcr die byschulz gefederten G.Serie und D.2 Sattelst\u00fctzen covert den parallellogramm Federmechanismus vor Feuchtigkeit und Schmutz. So bleibt die einwandfreie Funktion der Federung gew\u00e4hrleistet. Die Schutzh\u00fclle ist aus hochwertigem Neopren gefertigt, Sie dient auch als Fingerschutz f\u00fcr Kinderh\u00e4nde (bei Benutzung mit Kindersitz). Produktdetails:Material: NeoprenGewicht **: 13 gHerstellerfarbe: schwarz"
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 11.5,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 9.66
},
"fields": {
"displayGroup": [
"9e9fd578ffb3c389c1b2748e235719f1"
]
},
"sort": [
"byschulz textil schutzh\u00fclle"
]
}
]
},
"aggregations": {
"total-count": {
"value": 3
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|