| 1 |
42.50 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":"5b77ff6906974496a883bed325489643"}}}},{"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": 26,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw6_stage__product_1742425202",
"_id": "0e5a4ef48a464bd1b4dbe2be4705724d",
"_score": null,
"_source": {
"id": "0e5a4ef48a464bd1b4dbe2be4705724d",
"autoIncrement": 62714.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 1002,
"productNumber": "2100540.5",
"ean": null,
"displayGroup": "5d265354acc08a1d46b2c15320b81205",
"sales": 0,
"stock": 1002,
"weight": 0.5,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "e8c1a2f622aa4c319cb4b82536ef0dca",
"manufacturerNumber": "117375",
"releaseDate": null,
"createdAt": "2021-11-04T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"12298808f73a4bf781a9dcc9b2800801",
"8e600cbfb4ea4ed3b70f2092fd02feb4",
"5b77ff6906974496a883bed325489643"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "12298808f73a4bf781a9dcc9b2800801",
"_count": 1
},
{
"id": "8e600cbfb4ea4ed3b70f2092fd02feb4",
"_count": 1
},
{
"id": "5b77ff6906974496a883bed325489643",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": "55a8fd823d0a4396930808c75b365bc5",
"coverId": "6cbcf21e7a1f42ee8aef7230fac4d284",
"childCount": 0,
"categories": [
{
"id": "5b77ff6906974496a883bed325489643",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Tubos flexibles",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Flexrohre",
"5494b24b09d445ebace47112836b4458": "Tuyaux flexibles",
"de44571ddc4e4d0095c01af6ee299351": "Flex Pipes"
}
}
],
"manufacturer": {
"id": "e8c1a2f622aa4c319cb4b82536ef0dca",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": "BAR-TEK\u00ae",
"de44571ddc4e4d0095c01af6ee299351": "BAR-TEK\u00ae"
},
"_count": 1
},
"properties": [],
"options": [
{
"id": "dc49e6ac807f4309b64db18941b0fdcf",
"_count": 1,
"groupId": "7d744fc2ef344e23ba93ea37876ddd23",
"group": {
"id": "7d744fc2ef344e23ba93ea37876ddd23",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "76 mm",
"5494b24b09d445ebace47112836b4458": "76 mm",
"de44571ddc4e4d0095c01af6ee299351": "76 mm"
}
}
],
"categoryIds": [
"5b77ff6906974496a883bed325489643"
],
"optionIds": [
"dc49e6ac807f4309b64db18941b0fdcf"
],
"propertyIds": [],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"fts_product_is_bartek": true,
"fts_product_blog_articles": [
"beae37ee41e04108bcdfa0c2a08d3535"
],
"migration_Shopware5DB_product_attr14": "908",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "Kompensator",
"migration_Shopware5DB_product_bullet1": "universell zum Einschwei\u00dfen",
"migration_Shopware5DB_product_bullet2": "komplett aus Edelstahl",
"migration_Shopware5DB_product_bullet3": "bestens geeignet f\u00fcr jede Leistung",
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_made_in_germany": true,
"migration_Shopware5DB_product_dreisc_seo_url": "auspuff-edelstahl-flexrohr-kompensator",
"migration_Shopware5DB_product_dreisc_seo_title": "Auspuff Edelstahl Flexrohr Kompensator BAR-TEK\u00ae",
"migration_Shopware5DB_product_onco_universal_article": true
},
"5494b24b09d445ebace47112836b4458": {
"fts_product_is_bartek": true,
"fts_product_blog_articles": [
"beae37ee41e04108bcdfa0c2a08d3535"
],
"migration_Shopware5DB_product_attr14": "908",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "Kompensator",
"migration_Shopware5DB_product_bullet1": "universell zum Einschwei\u00dfen",
"migration_Shopware5DB_product_bullet2": "komplett aus Edelstahl",
"migration_Shopware5DB_product_bullet3": "bestens geeignet f\u00fcr jede Leistung",
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_title": "Auspuff Edelstahl Flexrohr Kompensator BAR-TEK\u00ae",
"migration_Shopware5DB_product_onco_universal_article": true
},
"de44571ddc4e4d0095c01af6ee299351": {
"fts_product_is_bartek": true,
"fts_product_blog_articles": [
"beae37ee41e04108bcdfa0c2a08d3535"
],
"migration_Shopware5DB_product_attr14": "908",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "Compensator",
"migration_Shopware5DB_product_bullet1": "universal for welding",
"migration_Shopware5DB_product_bullet2": "completely made of stainless steel",
"migration_Shopware5DB_product_bullet3": "best suitable for any performance",
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_url": "exhaust-interlock-stainless-steel-flex-pipe",
"migration_Shopware5DB_product_dreisc_seo_title": "Exhaust interlock stainless steel flex pipe BAR-TEK\u00ae",
"migration_Shopware5DB_product_onco_universal_article": true
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Auspuff Edelstahl Flexrohr Kompensator BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": "Compensateur de tuyau flexible d'\u00e9chappement en acier inoxydable BAR-TEK\u00ae",
"de44571ddc4e4d0095c01af6ee299351": "Exhaust stainless steel flex pipe compensator BAR-TEK\u00ae"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Flexrohr Kompensator komplett aus Edelstahl, gasdicht und extrem stabil. Optimal f\u00fcr Downpipes.Der Kompensator verf\u00fcgt \u00fcber ein innenliegendes Rohr, wodurch der Abgasstrom ohne verwirberlung verl\u00e4uft und die Temperaturen nicht direkt auf die flexiblen Au\u00dfenwellen treffen. Das Rohr f\u00fchrt allerdings zu einer kleinen Verj\u00fcngung. Wir empfehlen daher immer, einen etwas gr\u00f6\u00dferen Kompensators zu w\u00e4hlen. Optimaler Verwendungszweck ist der Bau von Wastegateleitungen und Hosenrohren.\nFeatures:\n\nuniversell zum Einschwei\u00dfen\nkomplett aus Edelstahl\ngasdichte Au\u00dfenwellen\nbestens geeignet f\u00fcr jede Leistung\nSehr flexibel und dennoch stabil\n\nAchtung:Ein Kompensator kompensiert, wie der Name schon sagt, Ausdehnungen durch Temperaturen. Zum Beispiel am Wastegate in einer Downpipe oder Kr\u00fcmmer. Er dient dazu an solch hei\u00dfen stellen die Ausdehnungen der Rohre abzufangen um Rissbildungen zu vermeiden.Ein Kompensator ist nicht in der Lage gr\u00f6\u00dfere Lasten auf sich zu nehmen und dient damit nicht als Flexrohrersatz in einer Abgasanlage. Hier empfehlen wir ein verst\u00e4rktes Interlock Flexrohr aus unserem Sortiment.",
"5494b24b09d445ebace47112836b4458": "Compensateur de tuyau flexible enti\u00e8rement en acier inoxydable, \u00e9tanche aux gaz et extr\u00eamement stable. Optimal pour les tuyaux de descente. Le compensateur est dot\u00e9 d'une conduite interne, ce qui signifie que le flux de gaz d'\u00e9chappement circule sans turbulence et que les temp\u00e9ratures ne frappent pas directement les arbres ext\u00e9rieurs flexibles. Cependant, le tuyau donne lieu \u00e0 un petit c\u00f4ne. C'est pourquoi nous recommandons toujours de choisir un compensateur l\u00e9g\u00e8rement plus grand. L'utilisation optimale est la construction de tuyaux de d\u00e9charge et de tuyaux en Y.\nCaract\u00e9ristiques :\n\nuniversel pour le soudage en\nenti\u00e8rement en acier inoxydable\narbres ext\u00e9rieurs \u00e9tanches au gaz\nid\u00e9alement adapt\u00e9 \u00e0 toute performance\nTr\u00e8s flexible et pourtant stable\n\nAttention :Un compensateur, comme son nom l'indique, compense la dilatation due \u00e0 la temp\u00e9rature. Par exemple, \u00e0 Wastegate dans un Downpipe ou un collecteur. Il sert \u00e0 compenser la dilatation des tuyaux dans ces endroits chauds afin d'\u00e9viter la formation de fissures. Un joint d'expansion n'est pas capable de supporter des charges plus importantes et ne convient donc pas pour remplacer un tuyau flexible dans un syst\u00e8me d'\u00e9chappement. Dans ce cas, nous vous recommandons un tuyau flexible interlock renforc\u00e9 de notre gamme.",
"de44571ddc4e4d0095c01af6ee299351": "Flex pipe compensator completely made of stainless steel, gas-tight and extremely stable. Optimal for downpipes. The compensator has an internal pipe, whereby the exhaust gas flow runs without turbulence and the temperatures do not directly hit the flexible outer shafts. However, the pipe does result in a small taper. We therefore always recommend choosing a slightly larger compensator. Optimal use is the construction of wastegate lines and Y-pipes.\nFeatures:\n\nuniversal for welding in\ncompletely made of stainless steel\ngas-tight outer shafts\nbest suited for any performance\nVery flexible but still stable\n\nAttention:A compensator, as the name suggests, compensates for expansion due to temperature. For example at Wastegate in a Downpipe or manifold. It is used in such hot places to absorb the expansion of the pipes to avoid cracking. A compensator is not able to take larger loads and is therefore not suitable as a flex pipe replacement in an exhaust system. Here we recommend a reinforced interlock flex pipe from our range."
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Exhaust interlock stainless steel flex pipe BAR-TEK\u00ae"
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Flexrohr Kompensator aus Edelstahl f\u00fcr optimale Verform- und Haltbarkeit. \u2714 25 Jahre Motorsport-Erfahrung \u2714 schneller Versand \u2714 BAR-TEK\u00ae proved \u2794 jetzt kaufen",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Flex pipe compensator made of stainless steel for optimum deformation and durability. \u2714 15 years motorsport experience \u2714 fast shipping \u2714 BAR-TEK\u00ae proven \u2794 buy now"
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 62.832,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 52.8,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 58.9,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 49.495796,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 64.12,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 53.885714285714,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 78.7,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 66.134445,
"shop-customer": "66.134445",
"b-dealer": "52.8",
"a-dealer": "49.495796",
"c-dealer": "53.885714285714"
},
"fields": {
"displayGroup": [
"5d265354acc08a1d46b2c15320b81205"
]
},
"sort": [
"true",
0,
"0e5a4ef48a464bd1b4dbe2be4705724d"
]
},
{
"_index": "sw6_stage__product_1742425202",
"_id": "22bc16afb5b1421b93c899f2ec62c290",
"_score": null,
"_source": {
"id": "22bc16afb5b1421b93c899f2ec62c290",
"autoIncrement": 61973.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 1000,
"productNumber": "2100419.2",
"ean": null,
"displayGroup": "2751d6bfd6d8eda0c7afb961e3386895",
"sales": 0,
"stock": 1000,
"weight": 1.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "e8c1a2f622aa4c319cb4b82536ef0dca",
"manufacturerNumber": "SW13967",
"releaseDate": null,
"createdAt": "2020-10-06T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"12298808f73a4bf781a9dcc9b2800801",
"8e600cbfb4ea4ed3b70f2092fd02feb4",
"5b77ff6906974496a883bed325489643",
"620a998ccd3946c6b28692506fd33090"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "12298808f73a4bf781a9dcc9b2800801",
"_count": 1
},
{
"id": "8e600cbfb4ea4ed3b70f2092fd02feb4",
"_count": 1
},
{
"id": "5b77ff6906974496a883bed325489643",
"_count": 1
},
{
"id": "620a998ccd3946c6b28692506fd33090",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": "d9b22fe96e014821b1d25cbfb6258888",
"coverId": "2f0d4f07eb3e45c1ad017e159109504a",
"childCount": 0,
"categories": [
{
"id": "5b77ff6906974496a883bed325489643",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Tubos flexibles",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Flexrohre",
"5494b24b09d445ebace47112836b4458": "Tuyaux flexibles",
"de44571ddc4e4d0095c01af6ee299351": "Flex Pipes"
}
},
{
"id": "8e600cbfb4ea4ed3b70f2092fd02feb4",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Tubos de escape y curvas",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Auspuffrohre und B\u00f6gen",
"5494b24b09d445ebace47112836b4458": " Tuyaux d'\u00e9chappement et arcs",
"de44571ddc4e4d0095c01af6ee299351": "Exhaust Pipes and Bows"
}
},
{
"id": "620a998ccd3946c6b28692506fd33090",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Tubos de escape y codos de titanio",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Titan Auspuffrohre und B\u00f6gen",
"5494b24b09d445ebace47112836b4458": "Titane tuyaux d'\u00e9chappement et arcs",
"de44571ddc4e4d0095c01af6ee299351": "Titanium Exhaust Pipes and Bows"
}
}
],
"manufacturer": {
"id": "e8c1a2f622aa4c319cb4b82536ef0dca",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": "BAR-TEK\u00ae",
"de44571ddc4e4d0095c01af6ee299351": "BAR-TEK\u00ae"
},
"_count": 1
},
"properties": [],
"options": [
{
"id": "e290aebf6634463c83a3a2b1c2cc8af3",
"_count": 1,
"groupId": "7d744fc2ef344e23ba93ea37876ddd23",
"group": {
"id": "7d744fc2ef344e23ba93ea37876ddd23",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "70 mm",
"5494b24b09d445ebace47112836b4458": "70 mm",
"de44571ddc4e4d0095c01af6ee299351": "70 mm"
}
}
],
"categoryIds": [
"5b77ff6906974496a883bed325489643",
"620a998ccd3946c6b28692506fd33090",
"8e600cbfb4ea4ed3b70f2092fd02feb4"
],
"optionIds": [
"e290aebf6634463c83a3a2b1c2cc8af3"
],
"propertyIds": [],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"fts_product_video_1": "https:\/\/www.youtube.com\/watch?v=PxvqGLmd9ow",
"fts_product_is_bartek": true,
"fts_product_video_1_title": "Titan - Alles was du wissen musst",
"fts_product_video_1_description": "Heute dreht sich alles um Titan! Was genau zeichnet Titan aus und was sind die Vorteile einer Titannietrierten Beschichtung? Worauf muss man bei der Montage achten? Und warum solltest du die Beschichtung nicht mit blanken Fingern anfassen? Wie kann man Titandestillat am Motor anwenden? Diese und weitere wichtige Fragen beantwortet euch Bartek in diesem Video! Was m\u00f6chtet ihr als n\u00e4chstes sehen, was interessiert euch besonders? Schreibt es in die Kommentare! Hier geht\u2019s zu den Produkten im Video: https:\/\/www.bar-tek-tuning.de\/h-schaft-pleuel-titannitriert-2-0-l-tsi-ea888 https:\/\/www.bar-tek-tuning.de\/2-0l-tfsi-ventilfedern-satz-titan https:\/\/www.bar-tek-tuning.de\/titan-destillat-150-ml Stay tuned! Ihr habt Fragen?! @: info@bar-tek.de Folgt uns unbedingt auch auf unseren Social-Media-Kan\u00e4len! Ihr findet uns auch auf Facebook: https:\/\/de-de.facebook.com\/BARTEK.Motorsport Checkt jetzt unseren Instagram Kanal aus: https:\/\/www.instagram.com\/bartekmotorsport\/?hl=de Nutzt auch unsere eigenen GIPHYs: https:\/\/giphy.com\/BAR-TEK_Motorsport #titan #titannietriert #titandestillat",
"fts_product_video_1_upload_date": "2021-02-14 17:30:01.000",
"migration_Shopware5DB_product_attr14": "908",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "Titan Flexrohr",
"migration_Shopware5DB_product_bullet1": "Super Qualit\u00e4t",
"migration_Shopware5DB_product_bullet2": "Sehr gut zu verarbeiten",
"migration_Shopware5DB_product_bullet3": "Verschieden Gr\u00f6\u00dfen",
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_made_in_germany": true,
"migration_Shopware5DB_product_dreisc_seo_url": "auspuff-flexrohr-titan",
"migration_Shopware5DB_product_dreisc_seo_title": "Auspuff-Flexrohr aus TITAN, extrem leicht, BAR-TEK\u00ae",
"migration_Shopware5DB_product_onco_universal_article": true
},
"5494b24b09d445ebace47112836b4458": {
"fts_product_video_1": "https:\/\/www.youtube.com\/watch?v=PxvqGLmd9ow&t=146s",
"fts_product_is_bartek": true,
"fts_product_video_1_title": "Titan - Alles was du wissen musst",
"migration_Shopware5DB_product_attr14": "908",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "Titan Flexrohr",
"migration_Shopware5DB_product_bullet1": "Super Qualit\u00e4t",
"migration_Shopware5DB_product_bullet2": "Sehr gut zu verarbeiten",
"migration_Shopware5DB_product_bullet3": "Verschieden Gr\u00f6\u00dfen",
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_title": "Auspuff-Flexrohr aus TITAN, extrem leicht, BAR-TEK\u00ae",
"migration_Shopware5DB_product_onco_universal_article": true
},
"de44571ddc4e4d0095c01af6ee299351": {
"fts_product_video_1": "https:\/\/www.youtube.com\/watch?v=PxvqGLmd9ow",
"fts_product_video_2": "https:\/\/www.youtube.com\/watch?v=Mdqafk-mLxk",
"fts_product_is_bartek": true,
"fts_product_video_1_title": "Titan - All you need to know",
"fts_product_video_2_title": "Titanium - Everything you need to know! ",
"migration_Shopware5DB_product_attr14": "908",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "Titanium flex tube",
"migration_Shopware5DB_product_bullet1": "Super quality",
"migration_Shopware5DB_product_bullet2": "Very good to process",
"migration_Shopware5DB_product_bullet3": "Different sizes",
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_made_in_germany": true,
"migration_Shopware5DB_product_dreisc_seo_url": "exhaust-flexible-pipe-titanium",
"migration_Shopware5DB_product_dreisc_seo_title": "Exhaust flexible pipe made of TITAN, extremely light, BAR-TEK\u00ae.",
"migration_Shopware5DB_product_onco_universal_article": true
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Auspuff-Flexrohr TITAN BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": "Tuyau flexible d'\u00e9chappement TITAN BAR-TEK\u00ae",
"de44571ddc4e4d0095c01af6ee299351": "Exhaust flexible pipe TITAN BAR-TEK\u00ae"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Unsere Titan-Flexrohre werden aus hochwertigstem Grade-2-Titan gefertigt. Das Titan-Flexrohr ist zum Au\u00dfgleich von Temperaturausdehnungen und Schwingungen im Auspuffsystem.\nTitan ist dank seinen speziellen Eigenschaften ein idealer Werkstoff f\u00fcr den Bau von Auspuffanlagen im Motorsport. Geringes Gewicht bei gleichzeitig sehr hoher Festigkeit erlaubt die Verwendung von noch geringeren Materialst\u00e4rken, wodurch eine Auspuffanlage aus hochwertigen Titanbauteilen extrem leicht und widerstandsf\u00e4hig zugleich ist.\nFeatures:\n\nextrem leicht\nextrem stabil\n\nTitan Grade 2 ist eine von insgesamt vier Reintitan-Qualit\u00e4ten. Das Material verf\u00fcgt \u00fcber eine exzellente Biegsamkeit und l\u00e4sst sich sehr gut schwei\u00dfen. Typische Anwendungsbereiche f\u00fcr Grade 2 sind korrosionsresistente Produkte in der chemischen Industrie, der Marine und im Fahrzeug- und Flugzeugbau, wo maximale Verformbarkeit und Haltbarkeit erw\u00fcnscht ist.",
"5494b24b09d445ebace47112836b4458": "Nos tubes flexibles en titane sont fabriqu\u00e9s \u00e0 partir de titane de qualit\u00e9 sup\u00e9rieure de grade 2. Le tuyau flexible en titane sert \u00e0 compenser les dilatations thermiques et les vibrations du syst\u00e8me d'\u00e9chappement.\nGr\u00e2ce \u00e0 ses propri\u00e9t\u00e9s particuli\u00e8res, le titane est un mat\u00e9riau id\u00e9al pour la construction de syst\u00e8mes d'\u00e9chappement dans le sport automobile. Le faible poids combin\u00e9 \u00e0 une tr\u00e8s grande r\u00e9sistance permet l'utilisation de mat\u00e9riaux encore plus fins, ce qui rend un syst\u00e8me d'\u00e9chappement compos\u00e9 de composants en titane de haute qualit\u00e9 \u00e0 la fois extr\u00eamement l\u00e9ger et r\u00e9sistant.\nCaract\u00e9ristiques :\n\nextr\u00eamement l\u00e9ger\nextr\u00eamement forte\n\nLe titane de grade 2 est l'un des quatre grades de titane pur. Le mat\u00e9riau a une excellente flexibilit\u00e9 et peut \u00eatre tr\u00e8s bien soud\u00e9. Les applications typiques du Grade 2 sont les produits r\u00e9sistant \u00e0 la corrosion dans l'industrie chimique, la marine, l'automobile et la construction a\u00e9ronautique, o\u00f9 une formabilit\u00e9 et une durabilit\u00e9 maximales sont requises.",
"de44571ddc4e4d0095c01af6ee299351": "Our titanium flex tubes are manufactured from the highest quality grade 2 titanium. The titanium flex pipe is to compensate for temperature expansions and vibrations in the exhaust system.\nThanks to its special properties, titanium is an ideal material for the construction of exhaust systems in motor sports. Low weight combined with very high strength allows the use of even thinner materials, making an exhaust system made of high-quality titanium components extremely light and resistant at the same time.\nFeatures:\n\nextremely lightweight\nextremely strong\n\nGrade 2 titanium is one of a total of four pure titanium grades. The material has excellent flexibility and can be welded very well. Typical applications for Grade 2 are corrosion resistant products in the chemical industry, marine, automotive and aircraft construction, where maximum formability and durability is required."
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Exhaust flexible pipe made of TITAN, extremely light, BAR-TEK\u00ae."
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Aus hochwertigem Grade-2-Titan f\u00fcr max. Verform- und Haltbarkeit. \u2714 25 Jahre Motorsport-Erfahrung \u2714 schneller Versand \u2714 BAR-TEK\u00ae proved \u2794 jetzt kaufen",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Made of high quality Grade 2 titanium for maximum deformation and durability. \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_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 151.2,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 127.058815,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 144,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 121.0125,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 151.18951,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 127.05,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 174.25,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 146.42856,
"shop-customer": "146.42856",
"a-dealer": "127.058815",
"c-dealer": "121.0125",
"b-dealer": "127.05"
},
"fields": {
"displayGroup": [
"2751d6bfd6d8eda0c7afb961e3386895"
]
},
"sort": [
"true",
0,
"22bc16afb5b1421b93c899f2ec62c290"
]
},
{
"_index": "sw6_stage__product_1742425202",
"_id": "2d697d5bfb904205a19ae7d241801c63",
"_score": null,
"_source": {
"id": "2d697d5bfb904205a19ae7d241801c63",
"autoIncrement": 62487.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 1001,
"productNumber": "2100538.1",
"ean": null,
"displayGroup": "8cec7b7cdecb8511a6af1272cea8a20b",
"sales": 0,
"stock": 1001,
"weight": 0.5,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "e8c1a2f622aa4c319cb4b82536ef0dca",
"manufacturerNumber": "400114",
"releaseDate": null,
"createdAt": "2021-10-29T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"12298808f73a4bf781a9dcc9b2800801",
"8e600cbfb4ea4ed3b70f2092fd02feb4",
"cc11fe134e7d416f935bd42f67cd8dad",
"55f5e05bf8f846a7ad4f101f18e062dd",
"5b77ff6906974496a883bed325489643",
"ff26c879706241e8b79d126177a806bc"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "12298808f73a4bf781a9dcc9b2800801",
"_count": 1
},
{
"id": "8e600cbfb4ea4ed3b70f2092fd02feb4",
"_count": 1
},
{
"id": "cc11fe134e7d416f935bd42f67cd8dad",
"_count": 1
},
{
"id": "55f5e05bf8f846a7ad4f101f18e062dd",
"_count": 1
},
{
"id": "5b77ff6906974496a883bed325489643",
"_count": 1
},
{
"id": "ff26c879706241e8b79d126177a806bc",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": "34f7bf3a04fa4a0aa582deb602b1eef8",
"coverId": "c670c9b759d347e3bd99bb8384078904",
"childCount": 0,
"categories": [
{
"id": "55f5e05bf8f846a7ad4f101f18e062dd",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Bajantes",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Downpipes",
"5494b24b09d445ebace47112836b4458": " Downpipe"
}
},
{
"id": "5b77ff6906974496a883bed325489643",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Tubos flexibles",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Flexrohre",
"5494b24b09d445ebace47112836b4458": "Tuyaux flexibles",
"de44571ddc4e4d0095c01af6ee299351": "Flex Pipes"
}
},
{
"id": "ff26c879706241e8b79d126177a806bc",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Silenciador universal",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Universal Schalld\u00e4mpfer",
"5494b24b09d445ebace47112836b4458": "Silencieux universel",
"de44571ddc4e4d0095c01af6ee299351": "Universal Silencer"
}
},
{
"id": "8e600cbfb4ea4ed3b70f2092fd02feb4",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Tubos de escape y curvas",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Auspuffrohre und B\u00f6gen",
"5494b24b09d445ebace47112836b4458": " Tuyaux d'\u00e9chappement et arcs",
"de44571ddc4e4d0095c01af6ee299351": "Exhaust Pipes and Bows"
}
}
],
"manufacturer": {
"id": "e8c1a2f622aa4c319cb4b82536ef0dca",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": "BAR-TEK\u00ae",
"de44571ddc4e4d0095c01af6ee299351": "BAR-TEK\u00ae"
},
"_count": 1
},
"properties": [],
"options": [
{
"id": "c4b38a09cc444b14b3daebe56ff986e5",
"_count": 1,
"groupId": "2075d8be06684096a383bdce0eb26607",
"group": {
"id": "2075d8be06684096a383bdce0eb26607",
"_count": 1
},
"name": {
"de44571ddc4e4d0095c01af6ee299351": "100 mm",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "102 mm",
"5494b24b09d445ebace47112836b4458": "102 mm"
}
},
{
"id": "e195de3fb73847a1a0b10ea75bbb4f80",
"_count": 1,
"groupId": "7d744fc2ef344e23ba93ea37876ddd23",
"group": {
"id": "7d744fc2ef344e23ba93ea37876ddd23",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "63,5 mm",
"5494b24b09d445ebace47112836b4458": "63,5 mm",
"de44571ddc4e4d0095c01af6ee299351": "63,5 mm"
}
}
],
"categoryIds": [
"55f5e05bf8f846a7ad4f101f18e062dd",
"5b77ff6906974496a883bed325489643",
"8e600cbfb4ea4ed3b70f2092fd02feb4",
"ff26c879706241e8b79d126177a806bc"
],
"optionIds": [
"c4b38a09cc444b14b3daebe56ff986e5",
"e195de3fb73847a1a0b10ea75bbb4f80"
],
"propertyIds": [],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr14": "908",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "Interlock Edelstahl Flexrohr",
"migration_Shopware5DB_product_bullet1": "universell zum Einschwei\u00dfen",
"migration_Shopware5DB_product_bullet2": "Flexrohr komplett aus Edelstahl",
"migration_Shopware5DB_product_bullet3": "bestens geeignet f\u00fcr jede Leistung",
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_made_in_germany": true,
"migration_Shopware5DB_product_dreisc_seo_url": "auspuff-interlock-edelstahl-flexrohr",
"migration_Shopware5DB_product_dreisc_seo_title": "Auspuff Interlock Edelstahl Flexrohr BAR-TEK\u00ae",
"migration_Shopware5DB_product_onco_universal_article": true
},
"5494b24b09d445ebace47112836b4458": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr14": "908",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "Interlock Edelstahl Flexrohr",
"migration_Shopware5DB_product_bullet1": "universell zum Einschwei\u00dfen",
"migration_Shopware5DB_product_bullet2": "Flexrohr komplett aus Edelstahl",
"migration_Shopware5DB_product_bullet3": "bestens geeignet f\u00fcr jede Leistung",
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_title": "Auspuff Interlock Edelstahl Flexrohr BAR-TEK\u00ae",
"migration_Shopware5DB_product_onco_universal_article": true
},
"de44571ddc4e4d0095c01af6ee299351": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr14": "908",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "Interlock stainless steel flex tube",
"migration_Shopware5DB_product_bullet1": "universal for welding",
"migration_Shopware5DB_product_bullet2": "Flex pipe completely made of stainless steel",
"migration_Shopware5DB_product_bullet3": "best suited for any performance",
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_url": "exhaust-flexible-pipe-titanium",
"migration_Shopware5DB_product_dreisc_seo_title": "Exhaust flexible pipe made of TITAN, extremely light, BAR-TEK\u00ae.",
"migration_Shopware5DB_product_onco_universal_article": true
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Auspuff Interlock Edelstahl Flexrohr BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": "Tuyau flexible d'\u00e9chappement en acier inoxydable BAR-TEK\u00ae",
"de44571ddc4e4d0095c01af6ee299351": "Exhaust interlock stainless steel flex pipe BAR-TEK\u00ae"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Unsere Interlock Flexrohre werden aus hochwertigstem Edelstahl gefertigt. Das Flexrohr ist zum Au\u00dfgleich von Temperaturausdehnungen und Schwingungen im Auspuffsystem.\nEdelstahl ist dank seinen speziellen Eigenschaften ein idealer Werkstoff f\u00fcr den Bau von Auspuffanlagen im Motorsport. \nFeatures:\n\nuniversell zum Einschwei\u00dfen\nFlexrohr komplett aus Edelstahl\ngasdichte Spiralwandung\nbestens geeignet f\u00fcr jede Leistung\nSehr flexibel und dennoch stabil\n",
"5494b24b09d445ebace47112836b4458": "Nos tuyaux flexibles Interlock sont fabriqu\u00e9s en acier inoxydable de la plus haute qualit\u00e9. Le tuyau flexible est utilis\u00e9 pour compenser les dilatations de temp\u00e9rature et les vibrations dans le syst\u00e8me d'\u00e9chappement.\nGr\u00e2ce \u00e0 ses propri\u00e9t\u00e9s particuli\u00e8res, l'acier inoxydable est un mat\u00e9riau id\u00e9al pour la construction de syst\u00e8mes d'\u00e9chappement dans le sport automobile. \nCaract\u00e9ristiques :\n\nuniversel pour le soudage en\nTuyau flexible enti\u00e8rement en acier inoxydable\nparoi spirale \u00e9tanche aux gaz\nid\u00e9alement adapt\u00e9 \u00e0 toute performance\nTr\u00e8s flexible et pourtant stable\n",
"de44571ddc4e4d0095c01af6ee299351": "Our interlock flex pipes are made from the highest quality stainless steel. The flex pipe is used to compensate for temperature expansions and vibrations in the exhaust system.\nThanks to its special properties, stainless steel is an ideal material for the construction of exhaust systems in motorsports. \nFeatures:\n\nuniversal for welding\nFlexible pipe completely made of stainless steel\ngas-tight spiral wall\nbest suitable for any performance\nVery flexible but still stable\n"
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Exhaust flexible pipe made of TITAN, extremely light, BAR-TEK\u00ae."
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Interlock Flexrohr aus Edelstahl f\u00fcr optimale Verform- und Haltbarkeit. \u2714 25 Jahre Motorsport-Erfahrung \u2714 schneller Versand \u2714 BAR-TEK\u00ae proved \u2794 jetzt kaufen",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Stainless steel interlock flex pipe for optimum forming and durability. \u2714 15 years motorsport experience \u2714 fast shipping \u2714 BAR-TEK\u00ae proven \u2794 buy now"
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 19.159,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 16.1,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 20.825,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 17.5,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 21.0035,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 17.65,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 26.2,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 22.016806,
"shop-customer": "22.016806",
"a-dealer": "16.1",
"c-dealer": "17.5",
"b-dealer": "17.65"
},
"fields": {
"displayGroup": [
"8cec7b7cdecb8511a6af1272cea8a20b"
]
},
"sort": [
"true",
0,
"2d697d5bfb904205a19ae7d241801c63"
]
}
]
},
"aggregations": {
"total-count": {
"value": 3
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
5.42 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":"5b77ff6906974496a883bed325489643"}}}},{"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": "5b77ff6906974496a883bed325489643"
}
}
}
},
{
"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
|