| 1 |
18.65 ms |
Request:
{"index":"shopware6-stage_product","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"term":{"manufacturerId":"007e03b50ca2dd06cfee5c8a2abbfc95"}},{"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": 1,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 2,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "shopware6-stage_product_1773667835",
"_id": "9da187a7a191431db943a9a5a6fec6f4",
"_score": null,
"_source": {
"id": "9da187a7a191431db943a9a5a6fec6f4",
"autoIncrement": 88325.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 17,
"productNumber": "1167",
"ean": "8021890575098",
"displayGroup": "18b02e25ca892f4717b70b2080bd8c7b",
"sales": 0,
"stock": 17,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "007e03b50ca2dd06cfee5c8a2abbfc95",
"manufacturerNumber": "2205597105",
"releaseDate": null,
"createdAt": "2024-03-29T11:27:35+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"357a6fdf7642bf815a88822c447d9dc4",
"140f6969d5213fd0ece03148e62e461e",
"b73ce398c39f506af761d2277d853a92",
"a4a042cf4fd6bfb47701cbc8a1653ada",
"bf8229696f7a3bb4700cfddef19fa23f"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "357a6fdf7642bf815a88822c447d9dc4",
"_count": 1
},
{
"id": "140f6969d5213fd0ece03148e62e461e",
"_count": 1
},
{
"id": "b73ce398c39f506af761d2277d853a92",
"_count": 1
},
{
"id": "a4a042cf4fd6bfb47701cbc8a1653ada",
"_count": 1
},
{
"id": "bf8229696f7a3bb4700cfddef19fa23f",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "019cf93427a973238e3b30f611fe79b2",
"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": "a4a042cf4fd6bfb47701cbc8a1653ada",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Unisex"
}
},
{
"id": "b73ce398c39f506af761d2277d853a92",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "S\u00e4ttel"
}
},
{
"id": "bf8229696f7a3bb4700cfddef19fa23f",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "MTB"
}
}
],
"manufacturer": {
"id": "007e03b50ca2dd06cfee5c8a2abbfc95",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Selle Royal"
},
"_count": 1
},
"properties": [
{
"id": "3a616a5305e06ccc883bda3ab63b10b5",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
}
],
"options": [],
"categoryIds": [
"140f6969d5213fd0ece03148e62e461e",
"28dd2c7955ce926456240b2ff0100bde",
"357a6fdf7642bf815a88822c447d9dc4",
"a4a042cf4fd6bfb47701cbc8a1653ada",
"b73ce398c39f506af761d2277d853a92",
"bf8229696f7a3bb4700cfddef19fa23f"
],
"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": 0.0,
"product_vk2_amazon": 69.95,
"product_vk3_ebay": 69.95
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Selle Royal Sattel Respiro Soft Athletic"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": " F\u00fcr umfassenden Komfort, sowohl f\u00fcr das Pendeln in der Stadt als auch f\u00fcr entspannte Fahrten in der Freizeit, sorgt Respiro f\u00fcr frischen Wind. Als einer der beliebtesten Selle Royal S\u00e4ttel sorgt der Respiro f\u00fcr ein angenehm erfrischendes und k\u00fchles Fahrgef\u00fchl dank eines einzigartigen Bel\u00fcftungskanals, der die Atmungsaktivit\u00e4t f\u00f6rdert und den Druck im Dammbereich verringert. Das innovative Obermaterial des Respiro reflektiert das Sonnenlicht f\u00fcr eine niedrige Oberfl\u00e4chentemperatur, w\u00e4hrend die Royalgel-Polsterung optimalen Halt bietet und sich den Bewegungen des K\u00f6rpers w\u00e4hrend der Fahrt anpasst.Einsatzbereich: SportGewicht: 429 gL\u00e4nge: 279 mmBreite: 159 mmFarbe: schwarzPolster: GelExtras: ICS-Clip System - kompatibel mit sBox und Lookin-Satteltaschen und BlinklichtRESPIRO:RESPIRO ist die Linie f\u00fcr den anspruchsvollen Radfahrer. Die S\u00e4ttel verf\u00fcgen \u00fcber eine innovative k\u00fchlende Decke und einen Ventilationskanal, der zudem die Druckbelastung auf den Genitalbereich reduziert. ATHLETIC:Der Athletic-Fahrer sitzt in der Regel sportlich mit einem Wirbels\u00e4ulenwinkel von 45 Grad auf dem Sattel. "
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 79.9,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 67.14
},
"fields": {
"displayGroup": [
"18b02e25ca892f4717b70b2080bd8c7b"
]
},
"sort": [
"selle royal sattel respiro soft athletic"
]
},
{
"_index": "shopware6-stage_product_1773667835",
"_id": "17ae6739cdbe8fda7dbf9d8a18bb6de0",
"_score": null,
"_source": {
"id": "17ae6739cdbe8fda7dbf9d8a18bb6de0",
"autoIncrement": 94985.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 17,
"productNumber": "11617",
"ean": null,
"displayGroup": "d39355e1439ffecb3a7b3c220bbc5ac9",
"sales": 0,
"stock": 17,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "007e03b50ca2dd06cfee5c8a2abbfc95",
"manufacturerNumber": null,
"releaseDate": null,
"createdAt": "2026-03-17T00:14:37+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"357a6fdf7642bf815a88822c447d9dc4",
"140f6969d5213fd0ece03148e62e461e",
"b73ce398c39f506af761d2277d853a92",
"a4a042cf4fd6bfb47701cbc8a1653ada",
"f7e6c85504ce6e82442c770f7c8606f0"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "357a6fdf7642bf815a88822c447d9dc4",
"_count": 1
},
{
"id": "140f6969d5213fd0ece03148e62e461e",
"_count": 1
},
{
"id": "b73ce398c39f506af761d2277d853a92",
"_count": 1
},
{
"id": "a4a042cf4fd6bfb47701cbc8a1653ada",
"_count": 1
},
{
"id": "f7e6c85504ce6e82442c770f7c8606f0",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "019cf924ff9e7351b83fe916cd768ccf",
"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": "a4a042cf4fd6bfb47701cbc8a1653ada",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Unisex"
}
},
{
"id": "b73ce398c39f506af761d2277d853a92",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "S\u00e4ttel"
}
},
{
"id": "f7e6c85504ce6e82442c770f7c8606f0",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Trekking"
}
}
],
"manufacturer": {
"id": "007e03b50ca2dd06cfee5c8a2abbfc95",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Selle Royal"
},
"_count": 1
},
"properties": [],
"options": [],
"categoryIds": [
"140f6969d5213fd0ece03148e62e461e",
"28dd2c7955ce926456240b2ff0100bde",
"357a6fdf7642bf815a88822c447d9dc4",
"a4a042cf4fd6bfb47701cbc8a1653ada",
"b73ce398c39f506af761d2277d853a92",
"f7e6c85504ce6e82442c770f7c8606f0"
],
"optionIds": [],
"propertyIds": [],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": [],
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Selle Royal Sattel Respiro Soft Moderate"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": " Der Respiro bietet absoluten Komfort, der sich sowohl f\u00fcr das Pendeln in der Stadt als auch f\u00fcr das Fahren in der Freizeit eignet und f\u00fcr frischen Wind sorgt. Durch den einzigartigen Bel\u00fcftungskanal, der die Luftzirkulation f\u00f6rdert und den Druck im Dammbereich mindert, sorgt der Respiro f\u00fcr erfrischendes, k\u00fchles Fahrgef\u00fchl. Das innovative Obermaterial des Respiro reflektiert Sonnenstrahlen, um die Oberfl\u00e4chentemperatur zu senken. Die Royalgel-Polsterung bietet optimalen Halt und passt sich den Bewegungen des K\u00f6rpers an, w\u00e4hrend sto\u00dfd\u00e4mpfende Elastomere Unebenheiten auf der Stra\u00dfe abfedern.Einsatzbereich: TrekkingGewicht: 535 gL\u00e4nge: 277 mmBreite: 182 mmFarbe: schwarzPolster: GelExtras: ICS-Clip System - kompatibel mit sBox und Lookin-Satteltaschen und BlinklichtRESPIRO:RESPIRO ist die Linie f\u00fcr den anspruchsvollen Radfahrer. Die S\u00e4ttel verf\u00fcgen \u00fcber eine innovative k\u00fchlende Decke und einen Ventilationskanal, der zudem die Druckbelastung auf den Genitalbereich reduziert. MODERATE:Der Moderate-Fahrer sitzt in der Regel mit einem Wirbels\u00e4ulenwinkel von 60 Grad auf dem Sattel. "
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 79.9,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 64.72
},
"fields": {
"displayGroup": [
"d39355e1439ffecb3a7b3c220bbc5ac9"
]
},
"sort": [
"selle royal sattel respiro soft moderate"
]
}
]
},
"aggregations": {
"total-count": {
"value": 2
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|