| 1 |
4.52 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.de44571ddc4e4d0095c01af6ee299351"}},{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.2fbb5fe2e29a4d70aa5854ce7ce3e20b"}}]}},{"multi_match":{"query":false,"fields":["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":"b1f11c5abdfd44b7a3963429f7ed0224"}}}},{"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":["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": 1,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 5,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw6_stage__product_1742425202",
"_id": "161c1f9727fc4aa980abf7e1bae56e59",
"_score": null,
"_source": {
"id": "161c1f9727fc4aa980abf7e1bae56e59",
"autoIncrement": 47760.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 27,
"productNumber": "2100104",
"ean": "4260630970289",
"displayGroup": "159a27dee4969c673d0da55e1b48f971",
"sales": 0,
"stock": 27,
"weight": 0.1,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "e8c1a2f622aa4c319cb4b82536ef0dca",
"manufacturerNumber": "x393473",
"releaseDate": null,
"createdAt": "2017-01-01T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"356a4a2234f94af7b8ec77a57731335e",
"f6252de8549c43b08b7fc500c89b9914",
"829235db887e48adb5704af79c23b1d2",
"b1f11c5abdfd44b7a3963429f7ed0224"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "356a4a2234f94af7b8ec77a57731335e",
"_count": 1
},
{
"id": "f6252de8549c43b08b7fc500c89b9914",
"_count": 1
},
{
"id": "829235db887e48adb5704af79c23b1d2",
"_count": 1
},
{
"id": "b1f11c5abdfd44b7a3963429f7ed0224",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": null,
"coverId": "39749196d73f42c0a9d67ce08b8f30f1",
"childCount": 0,
"categories": [
{
"id": "b1f11c5abdfd44b7a3963429f7ed0224",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Accesorios",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r",
"5494b24b09d445ebace47112836b4458": " Accessoires",
"de44571ddc4e4d0095c01af6ee299351": "Accessories"
}
},
{
"id": "829235db887e48adb5704af79c23b1d2",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "V\u00e1lvulas de purga",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Blow off-Ventile",
"5494b24b09d445ebace47112836b4458": " Blow off-Vannes",
"de44571ddc4e4d0095c01af6ee299351": "Blow off Valves"
}
}
],
"manufacturer": {
"id": "e8c1a2f622aa4c319cb4b82536ef0dca",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": "BAR-TEK\u00ae",
"de44571ddc4e4d0095c01af6ee299351": "BAR-TEK\u00ae"
},
"_count": 1
},
"properties": [],
"options": [],
"categoryIds": [
"829235db887e48adb5704af79c23b1d2",
"b1f11c5abdfd44b7a3963429f7ed0224"
],
"optionIds": [],
"propertyIds": [],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_url": "efr-turbo-race-abdeckung-fuer-blow-off",
"migration_Shopware5DB_product_dreisc_seo_title": "EFR Turbo RACE Abdeckung f\u00fcr Blow-off BAR-TEK\u00ae",
"migration_Shopware5DB_product_onco_universal_article": true
},
"5494b24b09d445ebace47112836b4458": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_title": "EFR Turbo RACE Abdeckung f\u00fcr Blow-off BAR-TEK\u00ae",
"migration_Shopware5DB_product_onco_universal_article": true
},
"de44571ddc4e4d0095c01af6ee299351": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_url": "efr-turbo-race-cover-for-blow-off",
"migration_Shopware5DB_product_dreisc_seo_title": "EFR Turbo RACE Abdeckung f\u00fcr Blow-off BAR-TEK\u00ae",
"migration_Shopware5DB_product_onco_universal_article": true
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "EFR Turbo RACE Abdeckung f\u00fcr Blow-off BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": "EFR Turbo RACE Couverture pour le BAR-TEK\u00ae \u00e0 soufflage",
"de44571ddc4e4d0095c01af6ee299351": "EFR Turbo RACE cover for Blow off valve BAR-TEK\u00ae"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Spezieller BILLET Aludeckel f\u00fcr alle EFR Turbolader als Ersatz f\u00fcr die anf\u00e4llige Serienabdeckung. Da die originale Blow-off Abdeckung bei den EFR Ladern aus Kunststoff besteht, kann es bei hohen Ladedr\u00fccken zum Bruch kommen! Durch unsere Abdeckung aus hochwertige 6061-T6 Flugzeugaluminium wird dieses Problem behoben. Ein Muss f\u00fcr EFR Turbos die mit hohem Ladedruck fahren! (Bild zwei zeigt Serienabdeckung)",
"5494b24b09d445ebace47112836b4458": "Couvercle sp\u00e9cial en aluminium BILLET pour tous les turbocompresseurs EFR, en remplacement du couvercle de la s\u00e9rie sensible. Comme le couvercle d'origine des chargeurs EFR est en plastique, il peut se casser \u00e0 des pressions de chargement \u00e9lev\u00e9es ! Notre housse en aluminium de haute qualit\u00e9 6061-T6 pour avion r\u00e9sout ce probl\u00e8me. Un must pour les turbos EFR qui fonctionnent \u00e0 haute pression de suralimentation ! (La figure 2 montre la couverture de la s\u00e9rie)",
"de44571ddc4e4d0095c01af6ee299351": "A must have BILLET cover for all EFR Turbos running high boost! The OEM Bov cover can fail due to high boost. The reason is the week material. Our special Race cover is made from high performance material."
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "EFR Turbo RACE Abdeckung f\u00fcr Blow-off BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Aludeckel for EFR turbocharger made of high quality 6061-T6 aircraft aluminum.\n✓ 15 years motorsport experience ✓ worldwide shipping ✓ BAR-TEK® proved ➔ buy now"
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 35.65,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 29.957983,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 37.96,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 31.9,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 37.7825,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 31.75,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 41.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 35.252098,
"shop-customer": "35.252098",
"a-dealer": "29.957983",
"c-dealer": "31.9",
"b-dealer": "31.75"
},
"fields": {
"displayGroup": [
"159a27dee4969c673d0da55e1b48f971"
]
},
"sort": [
"true",
0,
"161c1f9727fc4aa980abf7e1bae56e59"
]
},
{
"_index": "sw6_stage__product_1742425202",
"_id": "0224dc1a8eab4fa2a0a08b7369b53deb",
"_score": null,
"_source": {
"id": "0224dc1a8eab4fa2a0a08b7369b53deb",
"autoIncrement": 47579.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 0,
"productNumber": "efr012",
"ean": null,
"displayGroup": "cb61cfe85bea4474a8cf9e6ade2bd0c3",
"sales": 0,
"stock": 0,
"weight": 1.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "25edf2df3c3d4fcbbfdbc8c7de863ef3",
"manufacturerNumber": "59001095225",
"releaseDate": null,
"createdAt": "2017-01-01T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"356a4a2234f94af7b8ec77a57731335e",
"f6252de8549c43b08b7fc500c89b9914",
"b1f11c5abdfd44b7a3963429f7ed0224"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "356a4a2234f94af7b8ec77a57731335e",
"_count": 1
},
{
"id": "f6252de8549c43b08b7fc500c89b9914",
"_count": 1
},
{
"id": "b1f11c5abdfd44b7a3963429f7ed0224",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": null,
"coverId": "45b019e2151f429a9ac8c905bf5f5e2d",
"childCount": 0,
"categories": [
{
"id": "b1f11c5abdfd44b7a3963429f7ed0224",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Accesorios",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r",
"5494b24b09d445ebace47112836b4458": " Accessoires",
"de44571ddc4e4d0095c01af6ee299351": "Accessories"
}
}
],
"manufacturer": {
"id": "25edf2df3c3d4fcbbfdbc8c7de863ef3",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "EFR BorgWarner",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "EFR BorgWarner"
},
"_count": 1
},
"properties": [],
"options": [],
"categoryIds": [
"b1f11c5abdfd44b7a3963429f7ed0224"
],
"optionIds": [],
"propertyIds": [],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"migration_Shopware5DB_product_attr9": "TZ 3506629102 ???\nBesser Moto\n",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_url": "efr-vband-schelle-downpipe",
"migration_Shopware5DB_product_dreisc_seo_title": "V-Band Schelle Downpipe f\u00fcr EFR Turbolader",
"migration_Shopware5DB_product_onco_universal_article": true
},
"5494b24b09d445ebace47112836b4458": {
"migration_Shopware5DB_product_attr9": "TZ 3506629102 ???\nBesser Moto\n",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_title": "V-Band Schelle Downpipe f\u00fcr EFR Turbolader",
"migration_Shopware5DB_product_onco_universal_article": true
},
"de44571ddc4e4d0095c01af6ee299351": {
"migration_Shopware5DB_product_attr9": "TZ 3506629102 ???\nBesser Moto\n",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_title": "V-Band Schelle Downpipe f\u00fcr EFR Turbolader",
"migration_Shopware5DB_product_onco_universal_article": true
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "V-Band Schelle Downpipe f\u00fcr EFR Turbolader",
"5494b24b09d445ebace47112836b4458": "Collier de serrage en bande V pour les turbocompresseurs EFR",
"de44571ddc4e4d0095c01af6ee299351": "V-band clamp for downpipe, for EFR turbocharger"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "V-Band Schelle zur Befestigung der Downpipe f\u00fcr EFR Turbolader. Passend f\u00fcr EFR Turbolader.",
"5494b24b09d445ebace47112836b4458": "Pince \u00e0 bande en V pour la fixation du tuyau de descente des turbocompresseurs EFR. Convient aux turbocompresseurs EFR.",
"de44571ddc4e4d0095c01af6ee299351": "V-band clamp for mounting the downpipe. Suitable for EFR turbochargers."
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "V-Band Schelle Downpipe f\u00fcr EFR Turbolader",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "V-band clamp for downpipe, for EFR turbocharger"
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 68.7582,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 57.78,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 68.7582,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 57.78,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 68.7582,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 57.78,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 74.96,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 62.991596,
"shop-customer": "62.991596",
"c-dealer": "57.78",
"a-dealer": "57.78",
"b-dealer": "57.78"
},
"fields": {
"displayGroup": [
"cb61cfe85bea4474a8cf9e6ade2bd0c3"
]
},
"sort": [
"",
0,
"0224dc1a8eab4fa2a0a08b7369b53deb"
]
},
{
"_index": "sw6_stage__product_1742425202",
"_id": "19ec4b9b702c462989ad4de71115f12a",
"_score": null,
"_source": {
"id": "19ec4b9b702c462989ad4de71115f12a",
"autoIncrement": 47448.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 0,
"productNumber": "efr013",
"ean": null,
"displayGroup": "e89670b656b4885061070f963452dbe7",
"sales": 0,
"stock": 0,
"weight": 1.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "25edf2df3c3d4fcbbfdbc8c7de863ef3",
"manufacturerNumber": "3506629101",
"releaseDate": null,
"createdAt": "2017-01-01T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"356a4a2234f94af7b8ec77a57731335e",
"f6252de8549c43b08b7fc500c89b9914",
"55ae85fce7fc4d0f811e8aea1dc24fa6",
"b1f11c5abdfd44b7a3963429f7ed0224"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "356a4a2234f94af7b8ec77a57731335e",
"_count": 1
},
{
"id": "f6252de8549c43b08b7fc500c89b9914",
"_count": 1
},
{
"id": "55ae85fce7fc4d0f811e8aea1dc24fa6",
"_count": 1
},
{
"id": "b1f11c5abdfd44b7a3963429f7ed0224",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": null,
"coverId": "3ea0655926f548e59ef6ab7bb195e1ae",
"childCount": 0,
"categories": [
{
"id": "55ae85fce7fc4d0f811e8aea1dc24fa6",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Bridas",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Flansche",
"5494b24b09d445ebace47112836b4458": " Brides",
"de44571ddc4e4d0095c01af6ee299351": "Flange"
}
},
{
"id": "b1f11c5abdfd44b7a3963429f7ed0224",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Accesorios",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r",
"5494b24b09d445ebace47112836b4458": " Accessoires",
"de44571ddc4e4d0095c01af6ee299351": "Accessories"
}
}
],
"manufacturer": {
"id": "25edf2df3c3d4fcbbfdbc8c7de863ef3",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "EFR BorgWarner",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "EFR BorgWarner"
},
"_count": 1
},
"properties": [],
"options": [],
"categoryIds": [
"55ae85fce7fc4d0f811e8aea1dc24fa6",
"b1f11c5abdfd44b7a3963429f7ed0224"
],
"optionIds": [],
"propertyIds": [],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"migration_Shopware5DB_product_attr9": "BB: http:\/\/vibrantperformance.com\/catalog\/index.php?cPath=1022_1125_1338\nVIB 14901",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "EFR Flansch",
"migration_Shopware5DB_product_bullet1": "High Boost",
"migration_Shopware5DB_product_bullet2": "Top QUalit\u00e4t",
"migration_Shopware5DB_product_bullet3": "Super Verarbeitung",
"migration_Shopware5DB_product_bullet4": "Robuste Legierung",
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_url": "efr-vband-flansch-downpipe",
"migration_Shopware5DB_product_dreisc_seo_title": "V-Band Flansch Downpipe f\u00fcr EFR Turbolader",
"migration_Shopware5DB_product_onco_universal_article": true
},
"5494b24b09d445ebace47112836b4458": {
"migration_Shopware5DB_product_attr9": "BB: http:\/\/vibrantperformance.com\/catalog\/index.php?cPath=1022_1125_1338\nVIB 14901",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "EFR Flansch",
"migration_Shopware5DB_product_bullet1": "High Boost",
"migration_Shopware5DB_product_bullet2": "Top QUalit\u00e4t",
"migration_Shopware5DB_product_bullet3": "Super Verarbeitung",
"migration_Shopware5DB_product_bullet4": "Robuste Legierung",
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_title": "V-Band Flansch Downpipe f\u00fcr EFR Turbolader",
"migration_Shopware5DB_product_onco_universal_article": true
},
"de44571ddc4e4d0095c01af6ee299351": {
"migration_Shopware5DB_product_attr9": "BB: http:\/\/vibrantperformance.com\/catalog\/index.php?cPath=1022_1125_1338\nVIB 14901",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "EFR Flange",
"migration_Shopware5DB_product_bullet1": "High boost",
"migration_Shopware5DB_product_bullet2": "Top QUALITY",
"migration_Shopware5DB_product_bullet3": "Super processing",
"migration_Shopware5DB_product_bullet4": "Robust alloy",
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_url": "efr-vband-flange-downpipe",
"migration_Shopware5DB_product_dreisc_seo_title": "V-Band Flansch Downpipe f\u00fcr EFR Turbolader",
"migration_Shopware5DB_product_onco_universal_article": true
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "V-Band Flansch Downpipe f\u00fcr EFR Turbolader",
"5494b24b09d445ebace47112836b4458": "Conduite descendante \u00e0 bride en V pour les turbocompresseurs EFR",
"de44571ddc4e4d0095c01af6ee299351": "V-Band Flange Downpipe for EFR Turbos"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "V-Band Flansch 76mm zum Bauen einer Downpipe f\u00fcr EFR Turbolader. Passend f\u00fcr EFR Turbolader.",
"5494b24b09d445ebace47112836b4458": "Bride en V de 76 mm pour construire un tuyau de descente pour les turbocompresseurs EFR. Convient aux turbocompresseurs EFR.",
"de44571ddc4e4d0095c01af6ee299351": "V-Band clamp 76mm for construct the Downpipe for EFR turbo. Fits for EFR Turbocharger."
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "V-Band Flansch Downpipe f\u00fcr EFR Turbolader",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 47.48,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 39.9,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 44.98,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 37.8,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 42.48,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 35.7,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 49.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 41.97479,
"shop-customer": "41.97479",
"c-dealer": "39.9",
"b-dealer": "37.8",
"a-dealer": "35.7"
},
"fields": {
"displayGroup": [
"e89670b656b4885061070f963452dbe7"
]
},
"sort": [
"",
0,
"19ec4b9b702c462989ad4de71115f12a"
]
},
{
"_index": "sw6_stage__product_1742425202",
"_id": "489b55f324d14beeb2a24e770322348d",
"_score": null,
"_source": {
"id": "489b55f324d14beeb2a24e770322348d",
"autoIncrement": 47250.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 0,
"productNumber": "efr015",
"ean": "2010000072295",
"displayGroup": "fd58bf8e331982f2e0a428089a4f88db",
"sales": 0,
"stock": 0,
"weight": 1.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "25edf2df3c3d4fcbbfdbc8c7de863ef3",
"manufacturerNumber": "179423",
"releaseDate": null,
"createdAt": "2017-01-01T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"356a4a2234f94af7b8ec77a57731335e",
"f6252de8549c43b08b7fc500c89b9914",
"b1f11c5abdfd44b7a3963429f7ed0224"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "356a4a2234f94af7b8ec77a57731335e",
"_count": 1
},
{
"id": "f6252de8549c43b08b7fc500c89b9914",
"_count": 1
},
{
"id": "b1f11c5abdfd44b7a3963429f7ed0224",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": null,
"coverId": "71af14cddc3e4b488f73fe216118ae8e",
"childCount": 0,
"categories": [
{
"id": "b1f11c5abdfd44b7a3963429f7ed0224",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Accesorios",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r",
"5494b24b09d445ebace47112836b4458": " Accessoires",
"de44571ddc4e4d0095c01af6ee299351": "Accessories"
}
}
],
"manufacturer": {
"id": "25edf2df3c3d4fcbbfdbc8c7de863ef3",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "EFR BorgWarner",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "EFR BorgWarner"
},
"_count": 1
},
"properties": [],
"options": [],
"categoryIds": [
"b1f11c5abdfd44b7a3963429f7ed0224"
],
"optionIds": [],
"propertyIds": [],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_url": "efr-montage-kit-turbolader",
"migration_Shopware5DB_product_dreisc_seo_title": "Montage Kit f\u00fcr EFR Turbolader",
"migration_Shopware5DB_product_onco_universal_article": true
},
"5494b24b09d445ebace47112836b4458": {
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_title": "Montage Kit f\u00fcr EFR Turbolader",
"migration_Shopware5DB_product_onco_universal_article": true
},
"de44571ddc4e4d0095c01af6ee299351": {
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_title": "Montage Kit f\u00fcr EFR Turbolader",
"migration_Shopware5DB_product_onco_universal_article": true
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Montage Kit f\u00fcr EFR Turbolader",
"5494b24b09d445ebace47112836b4458": "Kit de montage pour le turbocompresseur EFR",
"de44571ddc4e4d0095c01af6ee299351": "Mounting kit for EFR turbocharger"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Komplettes Montage Kit f\u00fcr BorgWarner EFR Turbolader. In dem Kit ist enthalten: 1x V-Band Schelle zum Kr\u00fcmmer 1x V-Band Schelle f\u00fcr Downpipe 2x Verschlussschrauben Wasseranschluss 6x Kupferdichtringe Wasseranschluss 2x Dichtung \u00d6lr\u00fccklauf 1x \u00d6lzulaufadapter Dash4 mit Dichtung 5x Klemmplatten mit Schrauben f\u00fcr Abgasgeh\u00e4use 1x T25 Kr\u00fcmmerdichtung 1x T3 Kr\u00fcmmerdichtung 1x T4 Kr\u00fcmmerdichtung geteilt Original BorgWarner EFR Kit. Teilenummmer: 179423",
"5494b24b09d445ebace47112836b4458": "Kit de montage complet pour les turbocompresseurs BorgWarner EFR. Inclus dans le kit : 1x collier de serrage pour tuyau de descente 1xcollier de serrage pour tuyau de descente2x bouchons filet\u00e9s connexion eau6x bagues d'\u00e9tanch\u00e9it\u00e9 en cuivre connexion eau2x joint retour d'huile 1xadaptateur d'entr\u00e9e d'huile Dash4 avec joint5x plaques de serrage avec vis pour bo\u00eetier d'\u00e9chappement 1x joint decollecteur T25 1x joint de collecteurT3 1x joint de collecteurT4 split Kit EFR BorgWarner original. Num\u00e9ro de r\u00e9f\u00e9rence : 179423 ",
"de44571ddc4e4d0095c01af6ee299351": "Complete assembly kit for BorgWarner EFR turbocharger.\n\nThe kit includes:\n1x V-band clamp to the manifold\n1x V-band clamp for downpipe\n2x plug screws for water connection\n6x copper gaskets for water connection\n2x gasket for oil return\n1x Oil inlet adapter Dash4 with gasket\n5x Clamp plates with bolts for exhaust housing\n1x T25 manifold gasket\n1x T3 manifold gasket\n1x T4 manifold gasket split\n\nOriginal BorgWarner EFR Kit. Part number: 179423\n"
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Montage Kit f\u00fcr EFR Turbolader",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Mounting kit for EFR turbocharger"
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 137.088,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 115.2,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 137.088,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 115.2,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 137.088,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 115.2,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 148.96,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 125.17647,
"shop-customer": "125.17647",
"c-dealer": "115.2",
"b-dealer": "115.2",
"a-dealer": "115.2"
},
"fields": {
"displayGroup": [
"fd58bf8e331982f2e0a428089a4f88db"
]
},
"sort": [
"",
0,
"489b55f324d14beeb2a24e770322348d"
]
},
{
"_index": "sw6_stage__product_1742425202",
"_id": "807c5c3b9d7e49ea94155d56dad3d655",
"_score": null,
"_source": {
"id": "807c5c3b9d7e49ea94155d56dad3d655",
"autoIncrement": 47075.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 0,
"productNumber": "efr011",
"ean": null,
"displayGroup": "929399dcc45c96023bc1df6fc94146cc",
"sales": 0,
"stock": 0,
"weight": 1.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "25edf2df3c3d4fcbbfdbc8c7de863ef3",
"manufacturerNumber": "826466-0001",
"releaseDate": null,
"createdAt": "2017-01-01T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"356a4a2234f94af7b8ec77a57731335e",
"f6252de8549c43b08b7fc500c89b9914",
"b1f11c5abdfd44b7a3963429f7ed0224"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "356a4a2234f94af7b8ec77a57731335e",
"_count": 1
},
{
"id": "f6252de8549c43b08b7fc500c89b9914",
"_count": 1
},
{
"id": "b1f11c5abdfd44b7a3963429f7ed0224",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": null,
"coverId": "c02dd65144f3479599715ad7bf9bf899",
"childCount": 0,
"categories": [
{
"id": "b1f11c5abdfd44b7a3963429f7ed0224",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Accesorios",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r",
"5494b24b09d445ebace47112836b4458": " Accessoires",
"de44571ddc4e4d0095c01af6ee299351": "Accessories"
}
}
],
"manufacturer": {
"id": "25edf2df3c3d4fcbbfdbc8c7de863ef3",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "EFR BorgWarner",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "EFR BorgWarner"
},
"_count": 1
},
"properties": [],
"options": [],
"categoryIds": [
"b1f11c5abdfd44b7a3963429f7ed0224"
],
"optionIds": [],
"propertyIds": [],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_url": "v-band-schelle-zum-kruemmer-fuer-efr-turbolader",
"migration_Shopware5DB_product_dreisc_seo_title": "V-Band Schelle zum Kr\u00fcmmer f\u00fcr EFR Turbolader",
"migration_Shopware5DB_product_onco_universal_article": true
},
"5494b24b09d445ebace47112836b4458": {
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_title": "V-Band Schelle zum Kr\u00fcmmer f\u00fcr EFR Turbolader",
"migration_Shopware5DB_product_onco_universal_article": true
},
"de44571ddc4e4d0095c01af6ee299351": {
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_url": "v-band-clamp-manifold-for-efr-turbos",
"migration_Shopware5DB_product_dreisc_seo_title": "V-band clamp to the elbow",
"migration_Shopware5DB_product_onco_universal_article": true
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "V-Band Schelle zum Kr\u00fcmmer f\u00fcr EFR Turbolader",
"5494b24b09d445ebace47112836b4458": "Collier de serrage de la bande V au collecteur pour les turbocompresseurs EFR",
"de44571ddc4e4d0095c01af6ee299351": "V-Band Clamp manifold for EFR Turbos"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "V-Band Schelle f\u00fcr Kr\u00fcmmerflansch zur Befestigung vom EFR Turbolader. Passend f\u00fcr folgende EFR Turbolader: -BorgWarner EFR 6258 mit V-Band Abgasgeh\u00e4use -BorgWarner EFR 6758 mit V-Band Abgasgeh\u00e4use -BorgWarner EFR 7163 mit V-Band Abgasgeh\u00e4use",
"5494b24b09d445ebace47112836b4458": "Collier de serrage en V pour la bride du collecteur pour le montage du turbocompresseur EFR. Convient pour les turbocompresseurs EFR suivants : -BorgWarner EFR 6258 avec bo\u00eetier d'\u00e9chappement en V -BorgWarner EFR6758 avec bo\u00eetier d'\u00e9chappement en V -BorgWarner EFR7163 avec bo\u00eetier d'\u00e9chappement en V",
"de44571ddc4e4d0095c01af6ee299351": "V-Band clamp for mounting the EFR turbo on manifold. Fits for Turbocharger -BorgWarner EFR 6258 with V-Band Turbine Housing -BorgWarner EFR 6758 with V-Band Turbine Housing -BorgWarner EFR 7163 with V-Band Turbine Housing"
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "V-Band Schelle zum Kr\u00fcmmer f\u00fcr EFR Turbolader",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "V-band clamp to the elbow"
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "V-band clamp to elbow for EFR turbocharger. ✓ 15 years motorsport experience ✓ worldwide shipping ✓ BAR-TEK® proved ➔ buy now"
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 36.6758,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 30.82,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 36.6758,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 30.82,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 36.6758,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 30.82,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 58.96,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 49.54622,
"shop-customer": "49.54622",
"a-dealer": "30.82",
"b-dealer": "30.82",
"c-dealer": "30.82"
},
"fields": {
"displayGroup": [
"929399dcc45c96023bc1df6fc94146cc"
]
},
"sort": [
"",
0,
"807c5c3b9d7e49ea94155d56dad3d655"
]
}
]
},
"aggregations": {
"total-count": {
"value": 5
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
4.10 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.de44571ddc4e4d0095c01af6ee299351"}},{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.2fbb5fe2e29a4d70aa5854ce7ce3e20b"}}]}},{"multi_match":{"query":false,"fields":["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":"b1f11c5abdfd44b7a3963429f7ed0224"}}}},{"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.de44571ddc4e4d0095c01af6ee299351.migration_Shopware5DB_product_onco_universal_article","customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.migration_Shopware5DB_product_onco_universal_article"],"type":"best_fields"}},"aggregations":{"isUniversal":{"max":{"field":"customFields.de44571ddc4e4d0095c01af6ee299351.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.de44571ddc4e4d0095c01af6ee299351"
}
},
{
"exists": {
"field": "customFields.migration_Shopware5DB_product_attr17.2fbb5fe2e29a4d70aa5854ce7ce3e20b"
}
}
]
}
},
{
"multi_match": {
"query": false,
"fields": [
"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": "b1f11c5abdfd44b7a3963429f7ed0224"
}
}
}
},
{
"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.de44571ddc4e4d0095c01af6ee299351.migration_Shopware5DB_product_onco_universal_article",
"customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.migration_Shopware5DB_product_onco_universal_article"
],
"type": "best_fields"
}
},
"aggregations": {
"isUniversal": {
"max": {
"field": "customFields.de44571ddc4e4d0095c01af6ee299351.migration_Shopware5DB_product_onco_universal_article"
}
}
}
}
},
"size": 0,
"timeout": "5s"
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|