| 1 |
12.02 ms |
Request:
{"index":"shopware6-stage_product","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"term":{"manufacturerId":"96c388341791599bd705a51696b2a005"}},{"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": 4,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 3,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "shopware6-stage_product_1773667835",
"_id": "82d3149fc1f8d2305e7c6d56a6c5689d",
"_score": null,
"_source": {
"id": "82d3149fc1f8d2305e7c6d56a6c5689d",
"autoIncrement": 81763.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 6,
"productNumber": "9469",
"ean": "4711946198138",
"displayGroup": "6c6ef2c0ca991991ac58812066c0af27",
"sales": 0,
"stock": 6,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "96c388341791599bd705a51696b2a005",
"manufacturerNumber": "061-30792",
"releaseDate": null,
"createdAt": "2023-10-16T11:12:16+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"357a6fdf7642bf815a88822c447d9dc4",
"140f6969d5213fd0ece03148e62e461e",
"b73ce398c39f506af761d2277d853a92",
"a4a042cf4fd6bfb47701cbc8a1653ada",
"1ff8a7b5dc7a7d1f0ed65aaa29c04b1e",
"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": "1ff8a7b5dc7a7d1f0ed65aaa29c04b1e",
"_count": 1
},
{
"id": "f7e6c85504ce6e82442c770f7c8606f0",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": "eeebd92dadc008d3ce94764f8ddaa96a",
"coverId": "7c8cb6a2dac0ed77a4816efb5db691c2",
"childCount": 0,
"categories": [
{
"id": "140f6969d5213fd0ece03148e62e461e",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "S\u00e4ttel & Sattelst\u00fctzen"
}
},
{
"id": "1ff8a7b5dc7a7d1f0ed65aaa29c04b1e",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "City"
}
},
{
"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": "96c388341791599bd705a51696b2a005",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Comodoro"
},
"_count": 1
},
"properties": [
{
"id": "3a616a5305e06ccc883bda3ab63b10b5",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
},
{
"id": "6597de4ceee5335f2b0cb927ffcc1064",
"_count": 1,
"groupId": "e682e5d097523765cde5e59df6139363",
"group": {
"id": "e682e5d097523765cde5e59df6139363",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "L"
}
}
],
"options": [
{
"id": "6597de4ceee5335f2b0cb927ffcc1064",
"_count": 1,
"groupId": "e682e5d097523765cde5e59df6139363",
"group": {
"id": "e682e5d097523765cde5e59df6139363",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "L"
}
}
],
"categoryIds": [
"140f6969d5213fd0ece03148e62e461e",
"1ff8a7b5dc7a7d1f0ed65aaa29c04b1e",
"28dd2c7955ce926456240b2ff0100bde",
"357a6fdf7642bf815a88822c447d9dc4",
"a4a042cf4fd6bfb47701cbc8a1653ada",
"b73ce398c39f506af761d2277d853a92",
"f7e6c85504ce6e82442c770f7c8606f0"
],
"optionIds": [
"6597de4ceee5335f2b0cb927ffcc1064"
],
"propertyIds": [
"3a616a5305e06ccc883bda3ab63b10b5",
"6597de4ceee5335f2b0cb927ffcc1064"
],
"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": 9467.1,
"product_vk2_amazon": 59.95,
"product_vk3_ebay": 59.95
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Comodoro Hydro Foam"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Die neue Sattellinie Comodoro wird exclusiv f\u00fcr die ZEG produziert. Entwickelt vom Produktmanagement der ZEG. Das Modell Comodoro wird in 3 Gr\u00f6\u00dfen angeboten. So findet jeder Fahrertyp den passenden Sattel. S 163mm Breite \/ 275mm L\u00e4ngeM 195mm Breite \/ 266mm L\u00e4ngeL 220mm Breite \/ 270mm L\u00e4nge Hydrofoam (high density foam)Nach einem langen Entwicklungszeitraum haben wir eine optimale L\u00f6sung gefunden welche mit einer einzigartigen Formel das richtige Ma\u00df an Druckentlastung, Halt und Sto\u00dfd\u00e4mpfung bietet. Hydrofoam erm\u00f6glicht es das sich das Polster perfekt an die Anatomie des Fahrers anpasst und trotzdem den ben\u00f6tigten Halt bietet. Kombiniert mit der Arctech Federung wird ein maximum an Komfort f\u00fcr Ganztagsausfl\u00fcge generiert. Stufensattel DesignDurch die tiefer liegende Sattelnase wird wertvoller Platz f\u00fcr die sensiblen Bereiche von Frau und Mann erzeugt. Dadurch k\u00f6nnen Druckbeschwerden und Taubheitsgef\u00fchle eliminiert werden. ArcTechArcTech passt sich intuitiv den Bewegungen des Fahrers an. Die patentierte ArchTech Sattelstrebentechnologie erm\u00f6glicht eine verbesserte Flexibilit\u00e4t sowie eine zus\u00e4tzliche D\u00e4mpfung Produktdetails:Polster: HydrofoamBefestigung: Patentsattelst\u00fctzeL\u00e4nge: 270 mmBreite: 220 mmH\u00f6he: 82 mmHerstellerfarbe: schwarzHerstellerfarbe: schwarz"
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 39.99,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 33.61
},
"fields": {
"displayGroup": [
"6c6ef2c0ca991991ac58812066c0af27"
]
},
"sort": [
"comodoro hydro foam"
]
}
]
},
"aggregations": {
"total-count": {
"value": 1
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|