| 1 |
5.18 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.5494b24b09d445ebace47112836b4458"}},{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.de44571ddc4e4d0095c01af6ee299351"}},{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.2fbb5fe2e29a4d70aa5854ce7ce3e20b"}}]}},{"multi_match":{"query":false,"fields":["customFields.5494b24b09d445ebace47112836b4458.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":"971ca86ad60d4149991792ae440a2c78"}}}},{"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":["5494b24b09d445ebace47112836b4458","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": 1,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw6_stage__product_1742425202",
"_id": "0f57708ac7d34f148f60e9426cc0922b",
"_score": null,
"_source": {
"id": "0f57708ac7d34f148f60e9426cc0922b",
"autoIncrement": 60065.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 1001,
"productNumber": "23rs301",
"ean": "4260529057718",
"displayGroup": "8b70f19174253f12dfbdc2cb0769e943",
"sales": 0,
"stock": 1001,
"weight": 80.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "e8c1a2f622aa4c319cb4b82536ef0dca",
"manufacturerNumber": "x33333",
"releaseDate": null,
"createdAt": "2017-01-01T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"87c86b255c784be7b2eebacd4ca87422",
"d9ae4bbe91814454b741efdb1d9a798a",
"971ca86ad60d4149991792ae440a2c78"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "87c86b255c784be7b2eebacd4ca87422",
"_count": 1
},
{
"id": "d9ae4bbe91814454b741efdb1d9a798a",
"_count": 1
},
{
"id": "971ca86ad60d4149991792ae440a2c78",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [
{
"id": "0194414007e57fa8958d9fe9bbf86052",
"name": "Sperrgut",
"_count": 1
}
],
"parentId": null,
"coverId": "d1c22c254b79491a93348165e210128d",
"childCount": 0,
"categories": [
{
"id": "971ca86ad60d4149991792ae440a2c78",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "2.5L TFSI",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.5L TFSI",
"5494b24b09d445ebace47112836b4458": "2.5L TFSI"
}
}
],
"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": [],
"categoryIds": [
"971ca86ad60d4149991792ae440a2c78"
],
"optionIds": [],
"propertyIds": [
"063defc68cd348f388daa7cdd0ed4083",
"12455be8c09b4186954efa84269c148e",
"1c64681feba0463398eb76febb017273",
"6a3e5f67305541d6b7b6d0905a19101f",
"6ad29fa6f1e6438cb5e0fc6053de7053",
"907caeca0e1e43148a4359bc1a533c67",
"98810049b2d24ea988a77bbe0ff1cb08",
"9c1f771006e44da4b2ac780446836ecc",
"a1bea52c47894809a1dabe0a5e930ede",
"b57b56d48b7542f6b82f8cec0a01af4b",
"c125587add124df28d9591814094a214",
"c16cf20191c4476d8135e30a88cc5d68",
"c3d0d3db70ba4a75b65315743b7a8aaf",
"d26e5bd3389a42a08740bc9892ec2bad"
],
"tagIds": [
"0194414007e57fa8958d9fe9bbf86052"
],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"fts_product_is_bartek": true,
"fts_product_blog_articles": [
"fc80bac1811f414b9310363e27f8d73b"
],
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "Rennmotor",
"migration_Shopware5DB_product_bullet1": " fertig gebauter Motor",
"migration_Shopware5DB_product_bullet2": "problemlos Leistungen weit \u00fcber 1000PS",
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_url": "ttrs-rs3-rennmotor-engine",
"migration_Shopware5DB_product_dreisc_seo_title": "2.5L TFSI RENNMOTOR komplett \u00fcber 1000PS tauglich BAR-TEK\u00ae",
"migration_Shopware5DB_product_onco_universal_article": false
},
"5494b24b09d445ebace47112836b4458": {
"fts_product_is_bartek": true,
"fts_product_blog_articles": [
"fc80bac1811f414b9310363e27f8d73b"
],
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "Rennmotor",
"migration_Shopware5DB_product_bullet1": " fertig gebauter Motor",
"migration_Shopware5DB_product_bullet2": "problemlos Leistungen weit \u00fcber 1000PS",
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_title": "2.5L TFSI RENNMOTOR komplett \u00fcber 1000PS tauglich BAR-TEK\u00ae",
"migration_Shopware5DB_product_onco_universal_article": false
},
"de44571ddc4e4d0095c01af6ee299351": {
"fts_product_is_bartek": true,
"fts_product_blog_articles": [
"fc80bac1811f414b9310363e27f8d73b"
],
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "Racing engine",
"migration_Shopware5DB_product_bullet1": " ready built engine",
"migration_Shopware5DB_product_bullet2": "easily performances far above 1000hp",
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_url": "ttrs-rs3-racing-engine",
"migration_Shopware5DB_product_dreisc_seo_title": "2.5L TFSI RENNMOTOR complete over 1000HP capable BAR-TEK\u00ae",
"migration_Shopware5DB_product_onco_universal_article": false
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.5L TFSI RENNMOTOR komplett \u00fcber 1000PS tauglich BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": "MOTEUR DE COURSE TFSI de 2,5 litres, enti\u00e8rement plus de 1000 CV, adapt\u00e9 au BAR-TEK\u00ae.",
"de44571ddc4e4d0095c01af6ee299351": "2.5L TFSI RACE ENGINE fully tuned over 1000 PS reliable BAR-TEK\u00ae"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Komplett getunter und fertig gebauter Motor auf CEPA\/CZG Basis: F\u00fcr alle 2.5L TFSI Motoren wie im TTRS und RS3.\nDieser Rennmotor ist f\u00fcr dich, wenn du richtig Lust auf Performance und Leistung hast. Wenn du beim Gedanken an die PS schon G\u00e4nsehaut bekommst. Und vor allem dann, wenn du keine Lust hast, einen Motor mit all seinen Komponenten durchzuplanen.\nDas passiert mit dem Motorblock:\nDer Block wird vermessen und auf das erste \u00dcberma\u00df (83 mm) gebohrt. Anschlie\u00dfend gehont, geplant und in deiner Wunschfarbe lackiert. Die Kurbelwelle wird gewuchtet, gerichtet und alle Lagerzapfen werden poliert. Kolben und Pleuel werden vermessen und gewogen. Alle Gewichte werden aneinander angepasst. Die Nebenwellen werden erneuert. Das Laufspiel sowie das Ringspiel werden eingestellt. Alle Teile werden montiert. Nat\u00fcrlich achten wir auch auf s\u00e4mtliche Lagerspiele. Du hast nichts mehr zu tun.\nWir verbauen folgende Teile im Block:\n\nJE Ultra Series Schmiedekolben (optional auch andere Hersteller m\u00f6glich)\nunsere hauseigenen H-Schaft Stahlpleuel mit ARP2000 Schrauben\nGeschmiedete Kurbelwelle, gerichtet, feinstgewuchtet und poliert\nHauptlagerschalen RACE falls m\u00f6glich\nAnlaufscheiben\nACL Race Pleuellager oder Sputter\nARP Stehbolzen f\u00fcr die Hauptlagergasse und ARP Schrauben f\u00fcr die seitliche Verschraubung\nARP Upgrade Block-Schrauben f\u00fcr die \u00d6lwanne (optional)\nAlle Steuerketten neu inkl. Geh\u00e4useabdeckung\n\nAm Zylinderblock f\u00fchren wir folgende Arbeiten durch:\nDer Kopf wird vermessen, gereinigt und geplant. Der Ventilsitz wird gepr\u00fcft und gegebenenfalls nachgeschnitten.\nWir verbauen folgende Teile im Kopf:\n\nARP Kopfstehbolzen High-Boost\nViton Ventilschaftdichtungen\nUnser hauseigenes Ventilfeder-Kit mit Titan-Federtellern\nFerrea Einlassventile (optional)\nUnsere Bar-Tek Nimonic Auslassventile\nCometic MLS Metallkopfdichtung\nNockenwellen vermessen, gerichtet und poliert\n\nDer Motor erfolgt im Austausch und kann Plug and Play gegen unseren Tuning-Motor getauscht werden.\nMit diesem kompletten Rennmotor k\u00f6nnen problemlos Leistungen weit \u00fcber 1000PS standfest gefahren werden! Das Getriebe sollte in jedem Fall ebenfalls verst\u00e4rkt werden. Leistungsangaben k\u00f6nnen variieren und sind abh\u00e4ngig von diversen Faktoren.\nHinweis: Rennmotoren einfahren\nGetunte Motoren m\u00fcssen richtig eingefahren werden, damit du m\u00f6glichst lange viel Spa\u00df daran hast. Hier findest du alles Wichtige zum Thema \"Motor richtig einfahren\"!",
"5494b24b09d445ebace47112836b4458": "Moteur enti\u00e8rement tun\u00e9 et construit sur la base CEPA\/CZG : pour tous les moteurs 2.5L TFSI comme dans la TTRS et la RS3.\nCe moteur de course est fait pour toi si tu as vraiment envie de performance et de puissance. Si tu as la chair de poule rien qu'en pensant \u00e0 ch. Et surtout si tu n'as pas envie de planifier un moteur avec tous ses composants.\nC'est ce qui se passe avec le bloc moteur :\nLe bloc est mesur\u00e9 et perc\u00e9 jusqu'\u00e0 la premi\u00e8re surcote (83 mm). Ensuite, il est rod\u00e9, planifi\u00e9 et peint dans la couleur de ton choix. Le vilebrequin est \u00e9quilibr\u00e9, redress\u00e9 et tous les tourillons sont polis. piston et bielle sont mesur\u00e9s et pes\u00e9s. Tous les poids sont ajust\u00e9s les uns aux autres. Les arbres secondaires sont remplac\u00e9s. Le jeu de fonctionnement et le jeu annulaire sont r\u00e9gl\u00e9s. Toutes les pi\u00e8ces sont mont\u00e9es. Bien entendu, nous veillons aussi \u00e0 tous les jeux de palier. Tu n'as plus rien \u00e0 faire.\nNous montons les pi\u00e8ces suivantes dans le bloc :\n\nLes pistons forg\u00e9s JE Ultra Series (d'autres fabricants sont \u00e9galement possibles en option)\nnos propres bielles en acier \u00e0 tige en H avec vis ARP2000\nVilebrequin forg\u00e9, redress\u00e9, finement \u00e9quilibr\u00e9 et poli\nCoussinets principal RACE si possible\nRondelles de but\u00e9e\nCoussinets de bielle ACL Race ou sputter\nARP boulon d'entretoise pour le chemin de roulement principal et vis ARP pour le vissage lat\u00e9ral\nARP mise \u00e0 niveau Vis de bloc pour le carter d'huile (en option)\nToutes les cha\u00eenes de distribution neuves, y compris le couvercle de carter\n\nNous effectuons les travaux suivants sur le bloc-cylindres :\nla t\u00eate est mesur\u00e9e, nettoy\u00e9e et planifi\u00e9e. Le si\u00e8ge de soupape est contr\u00f4l\u00e9 et \u00e9ventuellement recoup\u00e9.\nNous installons les pi\u00e8ces suivantes dans la t\u00eate :\n\nARP Boulon de t\u00eate High-Boost\nJoints de tige de soupape en Viton\nNotre kit maison ressort de soupape avec des rondelles \u00e9lastiques en titane\nSoupapes d'admission Ferrea (en option)\nNos soupapes d'\u00e9chappement Bar-Tek Nimonic\nJoint de t\u00eate m\u00e9tallique Cometic MLS\nArbres \u00e0 cames mesur\u00e9s, redress\u00e9s et polis\n\nLe moteur est fourni en \u00e9change et peut \u00eatre \u00e9chang\u00e9 plug and play contre notre moteur tuning.\nAvec ce moteur de course complet, il est possible d'atteindre sans probl\u00e8me des puissances bien sup\u00e9rieures \u00e0 1000 ch en toute stabilit\u00e9 ! Dans tous les cas, la bo\u00eete de vitesses doit \u00e9galement \u00eatre renforc\u00e9e. Les performances indiqu\u00e9es peuvent varier et d\u00e9pendent de divers facteurs.\nRemarque : Ex\u00e9cuter dans des moteurs de course\nLes moteurs r\u00e9gl\u00e9s doivent \u00eatre rod\u00e9s correctement pour que vous puissiez en profiter le plus longtemps possible. Vous trouverez ici tout ce que vous devez savoir sur \"Bien roder son moteur\"!",
"de44571ddc4e4d0095c01af6ee299351": "Completely tuned and ready built engine based on CEPA\/CZG: For all 2.5L TFSI engines like in the TTRS and RS3.\nThis racing engine is for you if you really want performance and power. If you get goose bumps just thinking about the HP. And especially if you don't feel like going through an engine with all its components.\nThat's what happens with the engine block:\nThe block is measured and drilled to the first oversize (83 mm). Then honed, planned and painted in your desired color. The crankshaft is balanced, straightened and all bearing journals are polished. piston and conrod are measured and weighed. All weights are adjusted to each other. The auxiliary shafts are renewed. The running clearance and the ring clearance are adjusted. All parts are mounted. Of course we also take care of all bearing clearances. You have nothing more to do.\nWe install the following parts in the block:\n\nJE Ultra Series forged pistons (optionally also other manufacturers possible)\nour own H-Shaft steel connecting rods with ARP2000 bolts\nForged crankshaft, straightened, fine balanced and polished\nMain bearing shells RACE if possible\nThrust washers\nACL Race connecting rod bearings or sputter\nARP stud bolt for main bearing race and ARP screws for side bolting\nARP upgrade block screws for the oil pan (optional)\nAll timing chains new incl. housing cover\n\nOn the cylinder block we perform the following work:\nThe head is measured, cleaned and planned. The valve seat is checked and recut if necessary.\nWe install the following parts in the head:\n\nARP head stud High-Boost\nViton valve stem seals\nOur in-house valve spring kit with titanium spring retainers\nFerrea intake valves (optional)\nOur Bar-Tek Nimonic exhaust valves\nCometic MLS metal head gasket\nCamshafts measured, straightened and polished\n\nThe engine is in exchange and can be plug and play with our tuning engine.\nWith this complete racing engine can be driven without any problems performance well over 1000HP stable! The transmission should also be reinforced in any case. Performance data may vary and are dependent on various factors.\nNote: Run in racing engines\nTuned engines need to be broken in properly so that you can enjoy them for as long as possible. Here you will find everything you need to know about \"Run in the engine correctly\"!"
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.5L TFSI RENNMOTOR komplett \u00fcber 1000PS tauglich BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "2.5L TFSI Audi RS3 RACE Engine complete over 735 kW capable BAR-TEK\u00ae"
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Komplett optimierter 2.5L TFSI Rennmotor f\u00fcr TTRS und RS3 \u27a4 Unglaubliche 1000 PS (735 kW) sind m\u00f6glich! Einfacher Plug & Play Einbau \u2714 Hier gibt\u2019s alle Infos!",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Completely optimized 2.5L TFSI racing engine for Audi TTRS and RS3 \u27a4 Incredible 1000 PS (735 kW) are possible! Easy plug & play mounting \u2714 Here's all the info!"
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 14174.983,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 11911.75,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 14249.95,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 11974.75,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 13387.45,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 11249.958,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 19840.75,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 16672.898,
"shop-customer": "16672.898",
"b-dealer": "11911.75",
"c-dealer": "11974.75",
"a-dealer": "11249.958"
},
"fields": {
"displayGroup": [
"8b70f19174253f12dfbdc2cb0769e943"
]
},
"sort": [
"true",
0,
"0f57708ac7d34f148f60e9426cc0922b"
]
}
]
},
"aggregations": {
"total-count": {
"value": 1
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
5.06 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.5494b24b09d445ebace47112836b4458"}},{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.de44571ddc4e4d0095c01af6ee299351"}},{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.2fbb5fe2e29a4d70aa5854ce7ce3e20b"}}]}},{"multi_match":{"query":false,"fields":["customFields.5494b24b09d445ebace47112836b4458.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":"971ca86ad60d4149991792ae440a2c78"}}}},{"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.5494b24b09d445ebace47112836b4458.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.5494b24b09d445ebace47112836b4458.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.5494b24b09d445ebace47112836b4458"
}
},
{
"exists": {
"field": "customFields.migration_Shopware5DB_product_attr17.de44571ddc4e4d0095c01af6ee299351"
}
},
{
"exists": {
"field": "customFields.migration_Shopware5DB_product_attr17.2fbb5fe2e29a4d70aa5854ce7ce3e20b"
}
}
]
}
},
{
"multi_match": {
"query": false,
"fields": [
"customFields.5494b24b09d445ebace47112836b4458.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": "971ca86ad60d4149991792ae440a2c78"
}
}
}
},
{
"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.5494b24b09d445ebace47112836b4458.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.5494b24b09d445ebace47112836b4458.migration_Shopware5DB_product_onco_universal_article"
}
}
}
}
},
"size": 0,
"timeout": "5s"
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|