| 1 |
4.02 ms |
Request:
{"index":"sw6_stage__product","search_type":"query_then_fetch","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"should":[{"bool":{"must_not":[{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.2f37bfd0f23f482bad9d34a02199499b"}},{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.de44571ddc4e4d0095c01af6ee299351"}},{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.2fbb5fe2e29a4d70aa5854ce7ce3e20b"}}]}},{"multi_match":{"query":false,"fields":["customFields.2f37bfd0f23f482bad9d34a02199499b.migration_Shopware5DB_product_attr17","customFields.de44571ddc4e4d0095c01af6ee299351.migration_Shopware5DB_product_attr17","customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.migration_Shopware5DB_product_attr17"],"type":"best_fields"}}]}},{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"bc03b12fca6e446c9bbe735ae1f4d0ce"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"66c23aa96ac548e1956dd6a840ed52c6"}}}},{"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":"customFields","languages":["2f37bfd0f23f482bad9d34a02199499b","de44571ddc4e4d0095c01af6ee299351","2fbb5fe2e29a4d70aa5854ce7ce3e20b"],"suffix":"fts_product_is_bartek"}},"order":"DESC"}},{"sales":{"order":"DESC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"}}
{
"took": 2,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 3,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw6_stage__product_1742425202",
"_id": "1d60f6d50434480e9712ee1932f0b60e",
"_score": null,
"_source": {
"id": "1d60f6d50434480e9712ee1932f0b60e",
"autoIncrement": 44775.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 0,
"productNumber": "21rs361",
"ean": null,
"displayGroup": "0a4135e0363d19bb6e88769ee91ddda6",
"sales": 0,
"stock": 0,
"weight": 0.001,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "e8c1a2f622aa4c319cb4b82536ef0dca",
"manufacturerNumber": "21rs361",
"releaseDate": null,
"createdAt": "2017-01-01T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"eb27df81065f4f6fa3fc825e4a49bdd6",
"4f325ac5501a40fa98f239034ed2f949",
"c2ae32cf01d64b04a20f1145ab12aea3",
"66c23aa96ac548e1956dd6a840ed52c6"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "eb27df81065f4f6fa3fc825e4a49bdd6",
"_count": 1
},
{
"id": "4f325ac5501a40fa98f239034ed2f949",
"_count": 1
},
{
"id": "c2ae32cf01d64b04a20f1145ab12aea3",
"_count": 1
},
{
"id": "66c23aa96ac548e1956dd6a840ed52c6",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": "40861d88836e40ecbe99bf8322ef9b60",
"coverId": "0cb4cfd5acb74fee891d913d9d4bf9c4",
"childCount": 0,
"categories": [
{
"id": "66c23aa96ac548e1956dd6a840ed52c6",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "TTRS",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "TTRS",
"5494b24b09d445ebace47112836b4458": "TTRS",
"de44571ddc4e4d0095c01af6ee299351": "TTRS"
}
}
],
"manufacturer": {
"id": "e8c1a2f622aa4c319cb4b82536ef0dca",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": "BAR-TEK\u00ae",
"de44571ddc4e4d0095c01af6ee299351": "BAR-TEK\u00ae"
},
"_count": 1
},
"properties": [
{
"id": "063defc68cd348f388daa7cdd0ed4083",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "CZGA | 340 PS (250 kW)",
"5494b24b09d445ebace47112836b4458": "CZGA | 340 ch (250 kW)",
"de44571ddc4e4d0095c01af6ee299351": "CZGA | 340 hp (250 kW)"
}
},
{
"id": "12455be8c09b4186954efa84269c148e",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "8P, 8PA | BJ 2003-2013",
"5494b24b09d445ebace47112836b4458": "8P, 8PA | ANN\u00c9E 2003-2013",
"de44571ddc4e4d0095c01af6ee299351": "8P, 8PA | Year built 2003-2013"
}
},
{
"id": "1c64681feba0463398eb76febb017273",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "CZGB | 367 PS (270 kW)",
"5494b24b09d445ebace47112836b4458": "CZGB | 367 ch (270 kW)",
"de44571ddc4e4d0095c01af6ee299351": "CZGB | 367 hp (270 kW)"
}
},
{
"id": "6a3e5f67305541d6b7b6d0905a19101f",
"_count": 1,
"groupId": "22a715b71ff441609b1deade031b2578",
"group": {
"id": "22a715b71ff441609b1deade031b2578",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.5 TFSI (EA855)",
"5494b24b09d445ebace47112836b4458": "2.5 TFSI (EA855)",
"de44571ddc4e4d0095c01af6ee299351": "2.5 TFSI (EA855)"
}
},
{
"id": "6ad29fa6f1e6438cb5e0fc6053de7053",
"_count": 1,
"groupId": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"group": {
"id": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Audi",
"5494b24b09d445ebace47112836b4458": "Audi",
"de44571ddc4e4d0095c01af6ee299351": "Audi"
}
},
{
"id": "907caeca0e1e43148a4359bc1a533c67",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "CEPB | 360 PS (265 kW)",
"5494b24b09d445ebace47112836b4458": "CEPB | 360 ch (265 kW)",
"de44571ddc4e4d0095c01af6ee299351": "CEPB | 360 hp (265 kW)"
}
},
{
"id": "98810049b2d24ea988a77bbe0ff1cb08",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "A3 \/ S3 \/ RS3",
"5494b24b09d445ebace47112836b4458": "A3 \/ S3 \/ RS3",
"de44571ddc4e4d0095c01af6ee299351": "A3 \/ S3 \/ RS3"
}
},
{
"id": "9c1f771006e44da4b2ac780446836ecc",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "8V | BJ 2012-2020",
"5494b24b09d445ebace47112836b4458": "8V | ANN\u00c9E 2012-2020",
"de44571ddc4e4d0095c01af6ee299351": "8V | Year built 2012-2020"
}
},
{
"id": "a1bea52c47894809a1dabe0a5e930ede",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "TT \/ TTS \/ TT RS",
"5494b24b09d445ebace47112836b4458": "TT \/ TTS \/ TT RS",
"de44571ddc4e4d0095c01af6ee299351": "TT \/ TTS \/ TT RS"
}
},
{
"id": "b57b56d48b7542f6b82f8cec0a01af4b",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Q3 \/ RS Q3",
"5494b24b09d445ebace47112836b4458": "Q3 \/ RS Q3",
"de44571ddc4e4d0095c01af6ee299351": "Q3 \/ RS Q3"
}
},
{
"id": "c125587add124df28d9591814094a214",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "8J | BJ 2006-2014",
"5494b24b09d445ebace47112836b4458": "8J | ANN\u00c9E 2006-2014",
"de44571ddc4e4d0095c01af6ee299351": "8J | Year built 2006-2014"
}
},
{
"id": "c16cf20191c4476d8135e30a88cc5d68",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "CEPA | 340 PS (250 kW)",
"5494b24b09d445ebace47112836b4458": "CEPA | 340 ch (250 kW)",
"de44571ddc4e4d0095c01af6ee299351": "CEPA | 340 hp (250 kW)"
}
},
{
"id": "c3d0d3db70ba4a75b65315743b7a8aaf",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "8U | BJ 2011-2018",
"5494b24b09d445ebace47112836b4458": "8U | ANN\u00c9E 2011-2018",
"de44571ddc4e4d0095c01af6ee299351": "8U | Year built 2011-2018"
}
},
{
"id": "d26e5bd3389a42a08740bc9892ec2bad",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "CTSA | 310 PS (228 kW)",
"5494b24b09d445ebace47112836b4458": "CTSA | 310 ch (228 kW)",
"de44571ddc4e4d0095c01af6ee299351": "CTSA | 310 hp (228 kW)"
}
}
],
"options": [
{
"id": "8b3aed5db68d4119b4a534a4fe2d3234",
"_count": 1,
"groupId": "08c38d44024442a2a3a55906cd8f69b5",
"group": {
"id": "08c38d44024442a2a3a55906cd8f69b5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Chiptuning V1",
"5494b24b09d445ebace47112836b4458": "Chiptuning V1",
"de44571ddc4e4d0095c01af6ee299351": "Chiptuning V1"
}
}
],
"categoryIds": [
"66c23aa96ac548e1956dd6a840ed52c6"
],
"optionIds": [
"8b3aed5db68d4119b4a534a4fe2d3234"
],
"propertyIds": [
"063defc68cd348f388daa7cdd0ed4083",
"12455be8c09b4186954efa84269c148e",
"1c64681feba0463398eb76febb017273",
"6a3e5f67305541d6b7b6d0905a19101f",
"6ad29fa6f1e6438cb5e0fc6053de7053",
"907caeca0e1e43148a4359bc1a533c67",
"98810049b2d24ea988a77bbe0ff1cb08",
"9c1f771006e44da4b2ac780446836ecc",
"a1bea52c47894809a1dabe0a5e930ede",
"b57b56d48b7542f6b82f8cec0a01af4b",
"c125587add124df28d9591814094a214",
"c16cf20191c4476d8135e30a88cc5d68",
"c3d0d3db70ba4a75b65315743b7a8aaf",
"d26e5bd3389a42a08740bc9892ec2bad"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"fts_product_is_bartek": true,
"fts_product_kompi_filter_groups": [
"c6d5f96c15354a8b9a8f7c4a8a6f0796"
],
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "BAR-TEK\u00ae Chiptuning",
"migration_Shopware5DB_product_bullet1": "Bis zu 425 PS",
"migration_Shopware5DB_product_bullet2": "Bis zu 580 Nm",
"migration_Shopware5DB_product_bullet3": "Optimale Lesitung",
"migration_Shopware5DB_product_bullet4": "Optimale Haltbarkeit",
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_made_in_germany": true,
"migration_Shopware5DB_product_dreisc_seo_url": "chiptuning-bar-tek-audi-rs3-8j",
"migration_Shopware5DB_product_dreisc_seo_title": "Chiptuning auf 380 bis zu 550 PS im Audi 2.5L TFSI RS3 8J",
"migration_Shopware5DB_product_onco_universal_article": false
},
"5494b24b09d445ebace47112836b4458": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "BAR-TEK\u00ae Chiptuning",
"migration_Shopware5DB_product_bullet1": "Bis zu 425 PS",
"migration_Shopware5DB_product_bullet2": "Bis zu 580 Nm",
"migration_Shopware5DB_product_bullet3": "Optimale Lesitung",
"migration_Shopware5DB_product_bullet4": "Optimale Haltbarkeit",
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_title": "Chiptuning auf 380 bis zu 550 PS im Audi 2.5L TFSI RS3 8J",
"migration_Shopware5DB_product_onco_universal_article": false
},
"de44571ddc4e4d0095c01af6ee299351": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "BAR-TEK\u00ae Chiptuning",
"migration_Shopware5DB_product_bullet1": "Up to 425 HP",
"migration_Shopware5DB_product_bullet2": "Up to 580 Nm",
"migration_Shopware5DB_product_bullet3": "Optimum reading",
"migration_Shopware5DB_product_bullet4": "Optimum durability",
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_title": "Chiptuning to 380 up to 550 HP in Audi 2.5L TFSI RS3 8J",
"migration_Shopware5DB_product_onco_universal_article": false,
"migration_Shopware5DB_product_dreisc_seo_url": "chiptuning-bar-tek-audi-rs3-8j",
"migration_Shopware5DB_product_dreisc_seo_title_replace": true
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.5L TFSI Audi TTRS 8J 340PS Chiptuning BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": "2.5L TFSI Audi TTRS 8J 340HP Chiptuning BAR-TEK\u00ae",
"de44571ddc4e4d0095c01af6ee299351": "2.5L TFSI Audi TTRS 8J 340HP Chiptuning BAR-TEK\u00ae"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BAR-TEK\u00ae Chiptuning f\u00fcr den Audi TTRS 8J 2.5L TFSI mit 340 PS Motor.\nBei der Abstimmung haben wir das Augenmerk auf optimale Leistung in Verbindung mit Haltbarkeit gelegt.\nBitte w\u00e4hle zwischen folgenden Konfigurationen:\nChiptuning V1:\n\nHardware Serie\nca. 40 PS Mehrleistung (auf ca. 380 PS)\nca. 50 Nm mehr Drehmoment (auf ca. 500 Nm Drehmoment)\nDrehmomentbegrenzung im DSG angehoben (Nur bei DSG Getriebe)\nV-Max aufgehoben\n\n Chiptuning V2:\n\nHardware Serie\nca. 65 PS Mehrleistung (auf ca. 405 PS)\nca. 100 Nm mehr Drehmoment (auf ca. 550 Nm Drehmoment)\nDrehmomentbegrenzung im DSG aufgehoben (Nur bei DSG Getriebe)\nV-Max aufgehoben\nNur f\u00fcr mindestens 100 Oktan Kraftstoff\nWir empfehlen unsere NGK Race Z\u00fcndkerzen\n\nChiptuning V3:\n\nF\u00fcr Downpipe & Abgasanlage (wie unsere 4\" Downpipe mit Milltek Abgasanlage)\nca. 85 PS Mehrleistung (auf ca. 425 PS)\nca. 130 Nm mehr Drehmoment (auf ca. 580 Nm Drehmoment)\nDrehmomentbegrenzung im DSG angehoben (Nur bei DSG Getriebe)\nV-Max aufgehoben\nNur f\u00fcr mindestens 100 Oktan Kraftstoff\nWir empfehlen unsere NGK Race Z\u00fcndkerzen\n\nDas Steuerger\u00e4t muss nach dem Kauf an uns versendet werden, oder Abstimmung bei uns vor Ort.\nAndere Konfigurationen gerne auf Anfrage.\n ",
"5494b24b09d445ebace47112836b4458": "BAR-TEK\u00ae Chiptuning pour l'Audi TTRS 8J 2.5L TFSI avec moteur 340 ch.\nLors de la mise au point, nous nous sommes concentr\u00e9s sur les performances optimales combin\u00e9es \u00e0 la durabilit\u00e9.\nVeuillez choisir entre les configurations suivantes :\nChiptuning V1 :\n\nS\u00e9rie Mat\u00e9riel\nenv. 40 ch plus de puissance (jusqu'\u00e0 env. 380 ch)\nenv. 50 Nm de couple en plus (jusqu'\u00e0 env. 500 Nm de couple)\nLimitation du couple dans les relev\u00e9s DSG (uniquement avec la bo\u00eete DSG)\nV-Max soulev\u00e9\n\n Chiptuning V2 :\n\nS\u00e9rie de mat\u00e9riel\nenv. 65 ch plus de puissance (jusqu'\u00e0 env. 405 PS)\nenv. 100 Nm de couple en plus (jusqu'\u00e0 env. 550 Nm de couple)\nSuppression de la limitation du couple dans la DSG (uniquement avec la bo\u00eete DSG)\nV-Max retir\u00e9\nSeulement pour un carburant d'au moins 100 octanes\nNous recommandons nos bougies d'allumage NGK Race\n\nChiptuning V3 :\n\nPour Downpipe et syst\u00e8me d'\u00e9chappement (comme notre 4\" Downpipe avec syst\u00e8me d'\u00e9chappement Milltek)\nenv. 85 ch plus de puissance (jusqu'\u00e0 env. 425 ch)\nenv. 130 Nm de couple en plus (jusqu'\u00e0 env. 580 Nm de couple)\nLimitation du couple dans les relev\u00e9s DSG (uniquement avec la bo\u00eete DSG)\nV-Max soulev\u00e9\nSeulement pour un carburant d'au moins 100 octanes\nNous recommandons nos bougies d'allumage NGK Race\n\nL'ECU doit nous \u00eatre exp\u00e9di\u00e9 apr\u00e8s l'achat, ou \u00eatre r\u00e9gl\u00e9 dans nos locaux.\nAutres configurations sur demande.\n ",
"de44571ddc4e4d0095c01af6ee299351": "BAR-TEK\u00ae Chiptuning for the Audi TTRS 8J 2.5L TFSI with 340 HP engine.\nWhen tuning, we focused on optimal performance combined with durability.\nPlease choose between the following configurations:\nChiptuning V1:\n\nHardware Series\napprox. 40 HP more power (to approx. 380 hp)\napprox. 50 Nm more torque (to approx. 500 Nm torque)\nTorque limitation in DSG raised (only with DSG gearbox)\nV-Max lifted\n\n Chiptuning V2:\n\nHardware series\napprox. 65 HP more power (to approx. 405 PS)\napprox. 100 Nm more torque (to approx. 550 Nm torque)\nTorque limitation in DSG removed (only with DSG gearbox)\nV-Max removed\nOnly for at least 100 octane fuel\nWe recommend our NGK Race spark plugs\n\nChiptuning V3:\n\nFor Downpipe & exhaust system (like our 4\" Downpipe with Milltek exhaust system)\napprox. 85 HP more power (to approx. 425 hp)\napprox. 130 Nm more torque (to approx. 580 Nm torque)\nTorque limitation in DSG raised (only with DSG gearbox)\nV-Max lifted\nOnly for at least 100 octane fuel\nWe recommend our NGK Race spark plugs\n\nThe ECU must be shipped to us after purchase, or tuning at our location.\nOther configurations on request.\n "
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Audi TTRS 8J 2.5L TFSI 340PS Chiptuning BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Chiptuning to 380 up to 550 HP in Audi 2.5L TFSI RS3 8J"
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Chiptuning V1 bis V3: bis ca. 425 PS und 580 Nm Drehmoment im RS3 8J. \u2714 25 Jahre Motorsport-Erfahrung \u2714 schneller Versand \u2714 BAR-TEK\u00ae proved \u2794 jetzt kaufen",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Chiptuning V1 to V3: up to approx. 425 HP and 580 Nm torque in the RS3 8J. \u2714 15 years of motorsport experience \u2714 fast shipping \u2714 BAR-TEK\u00ae proved \u2794 buy now"
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 755.9475,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 635.25,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 713.95,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 599.95795,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 759.99,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 638.65,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 881.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 741.1344,
"shop-customer": "741.1344",
"b-dealer": "635.25",
"a-dealer": "599.95795",
"c-dealer": "638.65"
},
"fields": {
"displayGroup": [
"0a4135e0363d19bb6e88769ee91ddda6"
]
},
"sort": [
"true",
0,
"1d60f6d50434480e9712ee1932f0b60e"
]
}
]
},
"aggregations": {
"total-count": {
"value": 1
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
5.37 ms |
Request:
{"index":"sw6_stage__product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"should":[{"bool":{"must_not":[{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.2f37bfd0f23f482bad9d34a02199499b"}},{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.de44571ddc4e4d0095c01af6ee299351"}},{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.2fbb5fe2e29a4d70aa5854ce7ce3e20b"}}]}},{"multi_match":{"query":false,"fields":["customFields.2f37bfd0f23f482bad9d34a02199499b.migration_Shopware5DB_product_attr17","customFields.de44571ddc4e4d0095c01af6ee299351.migration_Shopware5DB_product_attr17","customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.migration_Shopware5DB_product_attr17"],"type":"best_fields"}}]}},{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"bc03b12fca6e446c9bbe735ae1f4d0ce"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"66c23aa96ac548e1956dd6a840ed52c6"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"aggregations":{"manufacturer":{"terms":{"field":"manufacturerId","size":10000}},"price":{"stats":{"script":{"id":"cheapest_price","params":{"accessors":[{"key":"cheapest_price_rule1cc29aa9f88949329e6cd664b787d516_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule6598b1e356e544aca14190369f541afd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule6fc5504f876847f3a0141e22e4c26a50_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule85d57b12075f46a2900284013873d2a8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulec0412fc3a3f143b28d448bb7159c0093_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulecdb735e7d3134436b8e4903f940fb0c8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruledc8abfeae1214f8293d61d6093798ceb_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule243c52152d234b3687fd0a44399fd191_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulea8f2508d908f42a9b77c36c70e404fc6_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruleb19ca2e7e7b148ce93fa5339fcd72c06_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulee44e6782c64247b796b891cf25ae38f7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule38535ec8e284419db79495611c950227_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule5548eedc74e1440baaa75c289eabeec6_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule6ee4f48f76b049f7bcf4052b54b75610_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruleb2215ffece654a23b0020cb503c2f316_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulec87cc889ffa744f4ab9e76d88c720fc3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1}],"decimals":100,"round":true,"multiplier":100.0}}}},"properties":{"nested":{"path":"properties"},"aggregations":{"properties":{"terms":{"field":"properties.id","size":10000}}}},"options":{"nested":{"path":"options"},"aggregations":{"options":{"terms":{"field":"options.id","size":10000}}}},"isAvailable-filter":{"filter":{"term":{"active":true}},"aggregations":{"isAvailable":{"max":{"field":"stock"}}}},"customPrice-3-100":{"filter":{"range":{"shop-customer":{"gte":2.5210084033613445,"lte":84.03361344537815}}},"aggregations":{"customPrice-3-100":{"value_count":{"field":"id"}}}},"customPrice-100-300":{"filter":{"range":{"shop-customer":{"gte":84.03361344537815,"lte":252.10084033613447}}},"aggregations":{"customPrice-100-300":{"value_count":{"field":"id"}}}},"customPrice-300-500":{"filter":{"range":{"shop-customer":{"gte":252.10084033613447,"lte":420.1680672268908}}},"aggregations":{"customPrice-300-500":{"value_count":{"field":"id"}}}},"customPrice-500-700":{"filter":{"range":{"shop-customer":{"gte":420.1680672268908,"lte":588.2352941176471}}},"aggregations":{"customPrice-500-700":{"value_count":{"field":"id"}}}},"customPrice-700-900":{"filter":{"range":{"shop-customer":{"gte":588.2352941176471,"lte":756.3025210084033}}},"aggregations":{"customPrice-700-900":{"value_count":{"field":"id"}}}},"customPrice-900-1300":{"filter":{"range":{"shop-customer":{"gte":756.3025210084033,"lte":1092.4369747899161}}},"aggregations":{"customPrice-900-1300":{"value_count":{"field":"id"}}}},"customPrice-1300":{"filter":{"range":{"shop-customer":{"gte":1092.4369747899161}}},"aggregations":{"customPrice-1300":{"value_count":{"field":"id"}}}},"isUniversal-filter":{"filter":{"multi_match":{"query":true,"fields":["customFields.2f37bfd0f23f482bad9d34a02199499b.migration_Shopware5DB_product_onco_universal_article","customFields.de44571ddc4e4d0095c01af6ee299351.migration_Shopware5DB_product_onco_universal_article","customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.migration_Shopware5DB_product_onco_universal_article"],"type":"best_fields"}},"aggregations":{"isUniversal":{"max":{"field":"customFields.2f37bfd0f23f482bad9d34a02199499b.migration_Shopware5DB_product_onco_universal_article"}}}}},"size":0,"timeout":"5s"},"search_type":"query_then_fetch"}
POST http://opensearch-master:9200/sw6_stage__product/_search?track_total_hits=0&search_type=query_then_fetch
Accept: application/json
Content-Type: application/json
{
"query": {
"bool": {
"filter": [
{
"bool": {
"must": [
{
"bool": {
"should": [
{
"bool": {
"must_not": [
{
"exists": {
"field": "customFields.migration_Shopware5DB_product_attr17.2f37bfd0f23f482bad9d34a02199499b"
}
},
{
"exists": {
"field": "customFields.migration_Shopware5DB_product_attr17.de44571ddc4e4d0095c01af6ee299351"
}
},
{
"exists": {
"field": "customFields.migration_Shopware5DB_product_attr17.2fbb5fe2e29a4d70aa5854ce7ce3e20b"
}
}
]
}
},
{
"multi_match": {
"query": false,
"fields": [
"customFields.2f37bfd0f23f482bad9d34a02199499b.migration_Shopware5DB_product_attr17",
"customFields.de44571ddc4e4d0095c01af6ee299351.migration_Shopware5DB_product_attr17",
"customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.migration_Shopware5DB_product_attr17"
],
"type": "best_fields"
}
}
]
}
},
{
"bool": {
"must": [
{
"nested": {
"path": "visibilities",
"query": {
"bool": {
"must": [
{
"range": {
"visibilities.visibility": {
"gte": 30
}
}
},
{
"term": {
"visibilities.salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
}
]
}
}
}
},
{
"term": {
"active": true
}
}
]
}
},
{
"nested": {
"path": "categoriesRo",
"query": {
"term": {
"categoriesRo.id": "66c23aa96ac548e1956dd6a840ed52c6"
}
}
}
},
{
"bool": {
"must_not": [
{
"bool": {
"must_not": [
{
"exists": {
"field": "displayGroup"
}
}
]
}
}
]
}
}
]
}
}
]
}
},
"aggregations": {
"manufacturer": {
"terms": {
"field": "manufacturerId",
"size": 10000
}
},
"price": {
"stats": {
"script": {
"id": "cheapest_price",
"params": {
"accessors": [
{
"key": "cheapest_price_rule1cc29aa9f88949329e6cd664b787d516_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule6598b1e356e544aca14190369f541afd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule6fc5504f876847f3a0141e22e4c26a50_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule85d57b12075f46a2900284013873d2a8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rulec0412fc3a3f143b28d448bb7159c0093_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rulecdb735e7d3134436b8e4903f940fb0c8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_ruledc8abfeae1214f8293d61d6093798ceb_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule243c52152d234b3687fd0a44399fd191_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rulea8f2508d908f42a9b77c36c70e404fc6_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_ruleb19ca2e7e7b148ce93fa5339fcd72c06_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rulee44e6782c64247b796b891cf25ae38f7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule38535ec8e284419db79495611c950227_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule5548eedc74e1440baaa75c289eabeec6_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule6ee4f48f76b049f7bcf4052b54b75610_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_ruleb2215ffece654a23b0020cb503c2f316_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rulec87cc889ffa744f4ab9e76d88c720fc3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
}
],
"decimals": 100,
"round": true,
"multiplier": 100.0
}
}
}
},
"properties": {
"nested": {
"path": "properties"
},
"aggregations": {
"properties": {
"terms": {
"field": "properties.id",
"size": 10000
}
}
}
},
"options": {
"nested": {
"path": "options"
},
"aggregations": {
"options": {
"terms": {
"field": "options.id",
"size": 10000
}
}
}
},
"isAvailable-filter": {
"filter": {
"term": {
"active": true
}
},
"aggregations": {
"isAvailable": {
"max": {
"field": "stock"
}
}
}
},
"customPrice-3-100": {
"filter": {
"range": {
"shop-customer": {
"gte": 2.5210084033613445,
"lte": 84.03361344537815
}
}
},
"aggregations": {
"customPrice-3-100": {
"value_count": {
"field": "id"
}
}
}
},
"customPrice-100-300": {
"filter": {
"range": {
"shop-customer": {
"gte": 84.03361344537815,
"lte": 252.10084033613447
}
}
},
"aggregations": {
"customPrice-100-300": {
"value_count": {
"field": "id"
}
}
}
},
"customPrice-300-500": {
"filter": {
"range": {
"shop-customer": {
"gte": 252.10084033613447,
"lte": 420.1680672268908
}
}
},
"aggregations": {
"customPrice-300-500": {
"value_count": {
"field": "id"
}
}
}
},
"customPrice-500-700": {
"filter": {
"range": {
"shop-customer": {
"gte": 420.1680672268908,
"lte": 588.2352941176471
}
}
},
"aggregations": {
"customPrice-500-700": {
"value_count": {
"field": "id"
}
}
}
},
"customPrice-700-900": {
"filter": {
"range": {
"shop-customer": {
"gte": 588.2352941176471,
"lte": 756.3025210084033
}
}
},
"aggregations": {
"customPrice-700-900": {
"value_count": {
"field": "id"
}
}
}
},
"customPrice-900-1300": {
"filter": {
"range": {
"shop-customer": {
"gte": 756.3025210084033,
"lte": 1092.4369747899161
}
}
},
"aggregations": {
"customPrice-900-1300": {
"value_count": {
"field": "id"
}
}
}
},
"customPrice-1300": {
"filter": {
"range": {
"shop-customer": {
"gte": 1092.4369747899161
}
}
},
"aggregations": {
"customPrice-1300": {
"value_count": {
"field": "id"
}
}
}
},
"isUniversal-filter": {
"filter": {
"multi_match": {
"query": true,
"fields": [
"customFields.2f37bfd0f23f482bad9d34a02199499b.migration_Shopware5DB_product_onco_universal_article",
"customFields.de44571ddc4e4d0095c01af6ee299351.migration_Shopware5DB_product_onco_universal_article",
"customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.migration_Shopware5DB_product_onco_universal_article"
],
"type": "best_fields"
}
},
"aggregations": {
"isUniversal": {
"max": {
"field": "customFields.2f37bfd0f23f482bad9d34a02199499b.migration_Shopware5DB_product_onco_universal_article"
}
}
}
}
},
"size": 0,
"timeout": "5s"
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|