| 1 |
4.63 ms |
Request:
{"index":"shopware6-stage_product","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"term":{"manufacturerId":"a69da972a080c20caeee8a6321843cd3"}},{"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": "3d460f2a78c6332c93af8ab63bda4f63",
"_score": null,
"_source": {
"id": "3d460f2a78c6332c93af8ab63bda4f63",
"autoIncrement": 81760.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 36,
"productNumber": "9352",
"ean": null,
"displayGroup": "6f443ad35b3599e2816f805d2803103d",
"sales": 0,
"stock": 36,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "a69da972a080c20caeee8a6321843cd3",
"manufacturerNumber": "060-32377",
"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": "2ec886df244669adc8cadee369ad8934",
"coverId": "78a9dc7de84c417723fe39aaae597fb6",
"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": "a69da972a080c20caeee8a6321843cd3",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Suntour"
},
"_count": 1
},
"properties": [
{
"id": "1bd811bcd5aa96800085bf2250beab72",
"_count": 1,
"groupId": "e682e5d097523765cde5e59df6139363",
"group": {
"id": "e682e5d097523765cde5e59df6139363",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "31,6\/350 mm"
}
},
{
"id": "3a616a5305e06ccc883bda3ab63b10b5",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
}
],
"options": [
{
"id": "1bd811bcd5aa96800085bf2250beab72",
"_count": 1,
"groupId": "e682e5d097523765cde5e59df6139363",
"group": {
"id": "e682e5d097523765cde5e59df6139363",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "31,6\/350 mm"
}
}
],
"categoryIds": [
"140f6969d5213fd0ece03148e62e461e",
"28dd2c7955ce926456240b2ff0100bde",
"357a6fdf7642bf815a88822c447d9dc4",
"4c5bde74a8f110656874902f07378009",
"cedebb6e872f539bef8c3f919874e9d7"
],
"optionIds": [
"1bd811bcd5aa96800085bf2250beab72"
],
"propertyIds": [
"1bd811bcd5aa96800085bf2250beab72",
"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": 0.0,
"product_parent_article": 9350.1,
"product_vk2_amazon": 6.99,
"product_vk3_ebay": 6.99,
"accessory_sorting_order": "6924|7271"
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Suntour G-St\u00fctze SP12NCX schwarz"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Gefederte Sattelst\u00fctze, die nach dem Parallelogramm Prinzip arbeitet. Im Unterschied zu anderen gefederten Sattelst\u00fctzen bewegt sich die Suntour beim Einfedern nicht so weit nach unten, sondern auch etwas nach hinten. Durch diese Verlagerung der Einfederungsbewegung ver\u00e4ndert sich die Sitzh\u00f6he nicht so stark. Als Federungsmedium kommt eine Stahlfeder\/MCU Elastomer-Kombination zum Einsatz. Die Vorspannung ist mittels eines Innensechskantschl\u00fcssels individuell einstellbar. Produktdetails:L\u00e4nge: 350 mmFederweg Sattelst\u00fctze: 50 mmAusf\u00fchrung: PatentMaterial: AluminiumGewicht **: 820 gBelastbarkeit: Fahrergewicht bis 100 kgVersatz: 25 mmHerstellerfarbe: schwarz"
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 119.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 100.8
},
"fields": {
"displayGroup": [
"6f443ad35b3599e2816f805d2803103d"
]
},
"sort": [
"suntour g-st\u00fctze sp12ncx schwarz"
]
},
{
"_index": "shopware6-stage_product_1773667835",
"_id": "a36b598abb934e4528412e5a2127b931",
"_score": null,
"_source": {
"id": "a36b598abb934e4528412e5a2127b931",
"autoIncrement": 87155.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 61,
"productNumber": "3356",
"ean": null,
"displayGroup": "4a505ed0df72798260719c51a681f8cd",
"sales": 0,
"stock": 61,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "a69da972a080c20caeee8a6321843cd3",
"manufacturerNumber": "060-32371",
"releaseDate": null,
"createdAt": "2023-10-16T11:40:48+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": "c671791bddfba3aec880dbe78d09d992",
"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": "a69da972a080c20caeee8a6321843cd3",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Suntour"
},
"_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": 0.0,
"product_parent_article": "",
"product_vk2_amazon": 10.95,
"product_vk3_ebay": 10.95
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Suntour Neoprenschutz Sattelst\u00fctze"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sch\u00fctze deine Suntour-Federsattelst\u00fctze vor Schlamm und Dreck. Besonders die kleinen beweglichen Teile reagieren empfindlich auf Schmutz und k\u00f6nnen so schneller verschlei\u00dfen. Der Protector ist aus ca. 2 mm dickem Neopren gefertigt und h\u00e4lt so wirkungsvoll Wasser, Schmutz und Steine von dem Parallelogramm fern.\u00b7 Material: Neopren\u00b7 einfache Montage mit Klettverschluss\u00b7 passend f\u00fcr Suntour Parallelogramm-Federsattelst\u00fctze Produktdetails:Ausf\u00fchrung: f\u00fcr SR-Suntour Sattelst\u00fctzenMaterial: SynthetikHerstellerfarbe: schwarz "
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 4.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 4.16
},
"fields": {
"displayGroup": [
"4a505ed0df72798260719c51a681f8cd"
]
},
"sort": [
"suntour neoprenschutz sattelst\u00fctze"
]
}
]
},
"aggregations": {
"total-count": {
"value": 2
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|