| 1 |
4.03 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.2fbb5fe2e29a4d70aa5854ce7ce3e20b"}}]}},{"multi_match":{"query":false,"fields":["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":"0baa38c25e7f412d87c04b058b8e9c5a"}}}},{"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":["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": 10,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw6_stage__product_1742425202",
"_id": "0100b09b8f7245919fdbf235cfa5e1cc",
"_score": null,
"_source": {
"id": "0100b09b8f7245919fdbf235cfa5e1cc",
"autoIncrement": 55279.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 0,
"productNumber": "31600057.1",
"ean": "2010000058930",
"displayGroup": "90a041bef4615a97590121ea7f38f77a",
"sales": 0,
"stock": 0,
"weight": 10.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "25edf2df3c3d4fcbbfdbc8c7de863ef3",
"manufacturerNumber": "177283",
"releaseDate": null,
"createdAt": "2020-10-08T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"356a4a2234f94af7b8ec77a57731335e",
"f6252de8549c43b08b7fc500c89b9914",
"0baa38c25e7f412d87c04b058b8e9c5a"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "356a4a2234f94af7b8ec77a57731335e",
"_count": 1
},
{
"id": "f6252de8549c43b08b7fc500c89b9914",
"_count": 1
},
{
"id": "0baa38c25e7f412d87c04b058b8e9c5a",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": "0d2b0ea9ece64d699929d9051cf82d20",
"coverId": "bed3e842a863428e84cbc0a9bd67be34",
"childCount": 0,
"categories": [
{
"id": "0baa38c25e7f412d87c04b058b8e9c5a",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Serie AirWerks",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AirWerks-Serie",
"5494b24b09d445ebace47112836b4458": "S\u00e9rie AirWerks",
"de44571ddc4e4d0095c01af6ee299351": "AirWerks Series"
}
}
],
"manufacturer": {
"id": "25edf2df3c3d4fcbbfdbc8c7de863ef3",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "EFR BorgWarner",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "EFR BorgWarner"
},
"_count": 1
},
"properties": [],
"options": [
{
"id": "d97a0699dcf349c4b0e2ce0b37527ee6",
"_count": 1,
"groupId": "08c38d44024442a2a3a55906cd8f69b5",
"group": {
"id": "08c38d44024442a2a3a55906cd8f69b5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "0.88ar - 63\/87,4 mm, T4 Single",
"5494b24b09d445ebace47112836b4458": "0.88ar - 63\/87,4 mm, T4 simple",
"de44571ddc4e4d0095c01af6ee299351": "0.88ar - 63 \/ 87.4mm, T4 Single"
}
}
],
"categoryIds": [
"0baa38c25e7f412d87c04b058b8e9c5a"
],
"optionIds": [
"d97a0699dcf349c4b0e2ce0b37527ee6"
],
"propertyIds": [],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"migration_Shopware5DB_product_attr15": false,
"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": "borgarner-airwerks-s300-sx3-t4-turbolader",
"migration_Shopware5DB_product_dreisc_seo_title": "BorgWarner AirWerks S300SX3 T4 Turbolader",
"migration_Shopware5DB_product_onco_universal_article": true
},
"5494b24b09d445ebace47112836b4458": {
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_socialfeed": false,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_title": "BorgWarner AirWerks S300SX3 T4 Turbolader",
"migration_Shopware5DB_product_onco_universal_article": true
},
"de44571ddc4e4d0095c01af6ee299351": {
"migration_Shopware5DB_product_attr15": false,
"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": "BorgWarner AirWerks S300SX3 T4 Turbolader",
"migration_Shopware5DB_product_onco_universal_article": true,
"migration_Shopware5DB_product_dreisc_seo_url": "borgarner-airwerks-s300-sx3-t4-turbocharger"
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BorgWarner AirWerks S300SX3 T4 Turbolader",
"5494b24b09d445ebace47112836b4458": "Turbocompresseur BorgWarner AirWerks S300SX3 T4",
"de44571ddc4e4d0095c01af6ee299351": "BorgWarner AirWerks S300SX3 T4 turbocharger"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Die AirWerks S300SX3 Turbolader von BorgWarner sind Turbolader aus dem Aftermarket f\u00fcr den Performance Sektor. Bei den Ladern werden bew\u00e4hrte Serienteile entsprechend kombiniert um eine Anwendung im perfekten Preis- \/ Leistungsverh\u00e4ltnis f\u00fcr Tuning und Motorsport zu schaffen.\ntechnische Daten:\n\nLeistungsangabe: 320 - 800 PS\nVerdichtergeh\u00e4use: Ansaugung 101mm \/ Druckseite 76mm\nKompressorrad: Eintritt 66,11mm \/ Austritt 91,44mm\nAbgasgeh\u00e4use: 0.88 AR oder 0.91 AR Kr\u00fcmmerflansch BorgWarner T4 Twin Scroll (T4 geteilt) \/ Hosenrohrflansch BorgWarner V-Band\nTurbinenrad: Au\u00dfendurchmesser 79,76mm \/ Durchmesser am Austritt 76,37mm\nexternes Wastegate\n\nFeatures:\n\ndoppeltes hydrodynamisches Gleitlager\nextended Tip Technologie\nTwin Scroll Abgasgeh\u00e4use\nanpassbare Position von Verdichter- und Abgasgeh\u00e4use\nFrischluftgeh\u00e4use mit \u00dcberstromkan\u00e4len (High-Flow)\n\nBorgWarner Teilenummern: 177280, 177283, 177281, 177272, 177275, 177284",
"5494b24b09d445ebace47112836b4458": "Les turbocompresseurs AirWerks S300SX3 de BorgWarner sont des turbocompresseurs de rechange pour le secteur de la performance. Dans le cas des turbocompresseurs, des pi\u00e8ces de s\u00e9rie \u00e9prouv\u00e9es sont combin\u00e9es en cons\u00e9quence pour cr\u00e9er une application avec un rapport prix\/performance parfait pour le tuning et le sport automobile.\nles donn\u00e9es techniques :\n\nPuissance : 320 - 800 HP\nBo\u00eetier du compresseur : entr\u00e9e 101 mm \/ sortie 76 mm\nRoue de compresseur : entr\u00e9e 66,11mm \/ sortie 91,44mm\nBo\u00eetier d'\u00e9chappement : bride de collecteur 0,88 AR ou 0,91 AR BorgWarner T4 Twin Scroll (T4 split) \/ bride de tuyau en Y BorgWarner V-Band\nRoue de turbine : diam\u00e8tre ext\u00e9rieur 79,76 mm \/ diam\u00e8tre \u00e0 la sortie 76,37 mm\nporte ext\u00e9rieure sur les d\u00e9chets\n\nCaract\u00e9ristiques :\n\ndouble palier \u00e0 glissement hydrodynamique\ntechnologie de pointe \u00e9tendue\nBo\u00eetier d'\u00e9chappement \u00e0 double volutes\nPosition r\u00e9glable du compresseur et du carter d'\u00e9chappement\nLogement d'air frais avec canaux de d\u00e9bordement (High-Flow)\n\nNum\u00e9ros de pi\u00e8ces BorgWarner : 177280, 177283 177281, 177272, 177275, 177284",
"de44571ddc4e4d0095c01af6ee299351": "The AirWerks S300SX3 turbochargers from BorgWarner are aftermarket turbochargers for the performance sector. The superchargers combine proven series parts accordingly to create an application in the perfect price \/ performance ratio for tuning and motorsports.\ntechnical data:\n\nPower rating: 320 - 800 HP\nCompressor housing: suction 101mm \/ pressure side 76mm\nCompressor wheel: inlet 66,11mm \/ outlet 91,44mm\nExhaust housing: 0.88 AR or 0.91 AR manifold flange BorgWarner T4 Twin Scroll (T4 split) \/ Y-pipe flange BorgWarner V-Band\nTurbine wheel: outer diameter 79.76mm \/ diameter at outlet 76.37mm\nexternal Wastegate\n\nFeatures:\n\ndouble hydrodynamic plain bearing\nextended tip technology\nTwin scroll exhaust housing\nadjustable position of compressor and exhaust housing\nFresh air housing with overflow channels (High-Flow)\n\nBorgWarner part numbers: 177280, 177283, 177281, 177272, 177275, 177284"
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BorgWarner AirWerks S300SX3 T4 Turbolader",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BorgWarner AirWerks S300SX3 T4 Turbolader \u2714 25 Jahre Motorsport-Erfahrung \u2714 schneller Versand \u2714 BAR-TEK\u00ae proved \u2794 jetzt kaufen",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 953.4518,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 801.22,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 953.4518,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 801.22,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 953.4518,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 801.22,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1033.96,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 868.87396,
"shop-customer": "868.87396",
"c-dealer": "801.22",
"b-dealer": "801.22",
"a-dealer": "801.22"
},
"fields": {
"displayGroup": [
"90a041bef4615a97590121ea7f38f77a"
]
},
"sort": [
"",
0,
"0100b09b8f7245919fdbf235cfa5e1cc"
]
},
{
"_index": "sw6_stage__product_1742425202",
"_id": "32a4cfae9ef340eeaacd8be118014afa",
"_score": null,
"_source": {
"id": "32a4cfae9ef340eeaacd8be118014afa",
"autoIncrement": 55266.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 0,
"productNumber": "31600055.3",
"ean": "2010000043677",
"displayGroup": "c82e97d36e15800a9238ce6b908bff07",
"sales": 0,
"stock": 0,
"weight": 10.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "25edf2df3c3d4fcbbfdbc8c7de863ef3",
"manufacturerNumber": "177268",
"releaseDate": null,
"createdAt": "2020-10-08T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"356a4a2234f94af7b8ec77a57731335e",
"f6252de8549c43b08b7fc500c89b9914",
"0baa38c25e7f412d87c04b058b8e9c5a"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "356a4a2234f94af7b8ec77a57731335e",
"_count": 1
},
{
"id": "f6252de8549c43b08b7fc500c89b9914",
"_count": 1
},
{
"id": "0baa38c25e7f412d87c04b058b8e9c5a",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": "f309d94a82764b659ebb8beb565a16a4",
"coverId": "d6109e00548e4dde8f8ca1a55715b5cb",
"childCount": 0,
"categories": [
{
"id": "0baa38c25e7f412d87c04b058b8e9c5a",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Serie AirWerks",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AirWerks-Serie",
"5494b24b09d445ebace47112836b4458": "S\u00e9rie AirWerks",
"de44571ddc4e4d0095c01af6ee299351": "AirWerks Series"
}
}
],
"manufacturer": {
"id": "25edf2df3c3d4fcbbfdbc8c7de863ef3",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "EFR BorgWarner",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "EFR BorgWarner"
},
"_count": 1
},
"properties": [],
"options": [
{
"id": "4a68abd5ee2a414ebd4361cd74ed5998",
"_count": 1,
"groupId": "08c38d44024442a2a3a55906cd8f69b5",
"group": {
"id": "08c38d44024442a2a3a55906cd8f69b5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "1.22ar - 56 mm 76\/70",
"5494b24b09d445ebace47112836b4458": "1.22ar - 56 mm 76\/70",
"de44571ddc4e4d0095c01af6ee299351": "1.22ar - 56 mm 76\/70"
}
}
],
"categoryIds": [
"0baa38c25e7f412d87c04b058b8e9c5a"
],
"optionIds": [
"4a68abd5ee2a414ebd4361cd74ed5998"
],
"propertyIds": [],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"migration_Shopware5DB_product_attr14": "2820",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "BorgWarner Turbolader",
"migration_Shopware5DB_product_bullet1": "AirWerks S200SX",
"migration_Shopware5DB_product_bullet2": "Doppelt gelagert",
"migration_Shopware5DB_product_bullet3": "Top Qualit\u00e4t",
"migration_Shopware5DB_product_bullet4": "Anpassbare Geh\u00e4use",
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_url": "borgwarner-airwerks-s200sx-turbolader",
"migration_Shopware5DB_product_dreisc_seo_title": "BorgWarner AirWerks S200SX Turbolader - bis 580 PS",
"migration_Shopware5DB_product_onco_universal_article": true
},
"5494b24b09d445ebace47112836b4458": {
"migration_Shopware5DB_product_attr14": "2820",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "BorgWarner Turbolader",
"migration_Shopware5DB_product_bullet1": "AirWerks S200SX",
"migration_Shopware5DB_product_bullet2": "Doppelt gelagert",
"migration_Shopware5DB_product_bullet3": "Top Qualit\u00e4t",
"migration_Shopware5DB_product_bullet4": "Anpassbare Geh\u00e4use",
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_title": "BorgWarner AirWerks S200SX Turbolader - bis 580 PS",
"migration_Shopware5DB_product_onco_universal_article": true
},
"de44571ddc4e4d0095c01af6ee299351": {
"migration_Shopware5DB_product_attr14": "2820",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "BorgWarner turbocharger",
"migration_Shopware5DB_product_bullet1": "AirWerks S200SX",
"migration_Shopware5DB_product_bullet2": "Double bearing",
"migration_Shopware5DB_product_bullet3": "Top quality",
"migration_Shopware5DB_product_bullet4": "Customizable housing",
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_title": "BorgWarner AirWerks S200SX turbocharger - up to 580 HP",
"migration_Shopware5DB_product_onco_universal_article": true,
"migration_Shopware5DB_product_dreisc_seo_url": "borgwarner-airwerks-s200sx-turbocharger"
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BorgWarner AirWerks S200SX Turbolader",
"5494b24b09d445ebace47112836b4458": "Turbocompresseur BorgWarner AirWerks S200SX",
"de44571ddc4e4d0095c01af6ee299351": "BorgWarner AirWerks S200SX turbocharger"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Die AirWerks S200er Turbolader von BorgWarner sind Turbolader aus dem Aftermarket f\u00fcr den Performance Sektor. Bei den Ladern werden bew\u00e4hrte Serienteile entsprechend kombiniert um eine Anwendung im perfekten Preis- \/ Leistungsverh\u00e4ltnis f\u00fcr Tuning und Motorsport zu schaffen.\ntechnische Daten:\n\nLeistungsangabe: 220 - 580 PS\nVerdichtergeh\u00e4use: Ansaugung 76mm \/ Druckseite 51mm\nKompressorrad: Eintritt 50,72mm \/ Austritt 69,57mm\nAbgasgeh\u00e4use: 0.83 AR Kr\u00fcmmerflansch BorgWarner T4 Twin Scroll (T4 geteilt) \/ Hosenrohrflansch BorgWarner V-Band\nTurbinenrad: Au\u00dfendurchmesser 69,56mm \/ Durchmesser am Austritt 61,43mm\nexternes Wastegate\n\nFeatures:\n\ndoppeltes hydrodynamisches Gleitlager\nextended Tip Technologie\nTwin Scroll Abgasgeh\u00e4use\nanpassbare Position von Verdichter- und Abgasgeh\u00e4use\n\nBorgWarner Teilenummern: 177258, 177257, 177267, 177268",
"5494b24b09d445ebace47112836b4458": "Les turbocompresseurs AirWerks S200 de BorgWarner sont des turbocompresseurs de rechange pour le secteur de la performance. Dans le cas des turbocompresseurs, des pi\u00e8ces de s\u00e9rie \u00e9prouv\u00e9es sont combin\u00e9es en cons\u00e9quence pour cr\u00e9er une application avec un rapport prix\/performance parfait pour le tuning et le sport automobile.\nles donn\u00e9es techniques :\n\nPuissance : 220 - 580 HP\nBo\u00eetier du compresseur : aspiration 76 mm \/ refoulement 51 mm\nRoue de compresseur : entr\u00e9e 50,72mm \/ sortie 69,57mm\nBo\u00eetier d'\u00e9chappement : bride de collecteur 0,83 AR BorgWarner T4 Twin Scroll (T4 split) \/ bride de tuyau en Y BorgWarner V-Band\nRoue de turbine : diam\u00e8tre ext\u00e9rieur 69,56 mm \/ diam\u00e8tre \u00e0 la sortie 61,43 mm\nporte ext\u00e9rieure sur les d\u00e9chets\n\nCaract\u00e9ristiques :\n\ndouble palier \u00e0 glissement hydrodynamique\ntechnologie de pointe \u00e9tendue\nBo\u00eetier d'\u00e9chappement \u00e0 double volutes\nPosition r\u00e9glable du compresseur et du carter d'\u00e9chappement\n\nNum\u00e9ros de pi\u00e8ces BorgWarner : 177258, 177257, 177267, 177268",
"de44571ddc4e4d0095c01af6ee299351": "The AirWerks S200 turbochargers from BorgWarner are aftermarket turbochargers for the performance sector. In the case of the turbochargers, proven series parts are combined accordingly to create an application with a perfect price\/performance ratio for tuning and motor sports.\nTechnical data:\n\nPower rating: 220 - 580 HP\nCompressor housing: Suction 76mm \/ discharge 51mm\nCompressor wheel: inlet 50,72mm \/ outlet 69,57mm\nExhaust housing: 0.83 AR manifold flange BorgWarner T4 Twin Scroll (T4 split) \/ Y-pipe flange BorgWarner V-Band\nTurbine wheel: Outer diameter 69.56mm \/ diameter at outlet 61.43mm\nexternal waste gate\n\nFeatures:\n\ndouble hydrodynamic slide bearing\nextended tip technology\nTwin Scroll exhaust housing\nAdjustable position of compressor and exhaust housing\n\nBorgWarner part numbers: 177258, 177257, 177267, 177268"
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BorgWarner AirWerks S200SX Turbolader",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "BorgWarner AirWerks S200SX turbocharger - up to 580 HP"
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Turbolader f\u00fcr den Motorsport im perfekten Preis-\/Leistungsverh\u00e4ltnis. \u2714 25 Jahre Motorsport-Erfahrung \u2714 schneller Versand \u2714 BAR-TEK\u00ae proved \u2794 jetzt kaufen",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Turbochargers for motor sports with a perfect price\/performance ratio. \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": 975.6239,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 819.852,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 975.6239,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 819.852,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 975.6239,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 819.852,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1055.96,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 887.3613,
"shop-customer": "887.3613",
"a-dealer": "819.852",
"c-dealer": "819.852",
"b-dealer": "819.852"
},
"fields": {
"displayGroup": [
"c82e97d36e15800a9238ce6b908bff07"
]
},
"sort": [
"",
0,
"32a4cfae9ef340eeaacd8be118014afa"
]
}
]
},
"aggregations": {
"total-count": {
"value": 2
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
4.25 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.2fbb5fe2e29a4d70aa5854ce7ce3e20b"}}]}},{"multi_match":{"query":false,"fields":["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":"0baa38c25e7f412d87c04b058b8e9c5a"}}}},{"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-filter":{"nested":{"path":"properties"},"aggregations":{"properties-filter":{"filter":{"terms":{"properties.groupId":["a8bf3b8377cb4590865f2dbe94ba8d0a","711e47e772ca4a4ab448b7212cbf19cb"]}},"aggregations":{"properties":{"terms":{"field":"properties.id","size":10000}}}}}},"options-filter":{"nested":{"path":"options"},"aggregations":{"options-filter":{"filter":{"terms":{"options.groupId":["a8bf3b8377cb4590865f2dbe94ba8d0a","711e47e772ca4a4ab448b7212cbf19cb"]}},"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"}}}},"properties":{"nested":{"path":"properties"},"aggregations":{"properties":{"terms":{"field":"properties.id","size":10000}}}},"options":{"nested":{"path":"options"},"aggregations":{"options":{"terms":{"field":"options.id","size":10000}}}},"isUniversal-filter":{"filter":{"multi_match":{"query":true,"fields":["customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.migration_Shopware5DB_product_onco_universal_article"],"type":"best_fields"}},"aggregations":{"isUniversal":{"max":{"field":"customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.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.2fbb5fe2e29a4d70aa5854ce7ce3e20b"
}
}
]
}
},
{
"multi_match": {
"query": false,
"fields": [
"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": "0baa38c25e7f412d87c04b058b8e9c5a"
}
}
}
},
{
"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-filter": {
"nested": {
"path": "properties"
},
"aggregations": {
"properties-filter": {
"filter": {
"terms": {
"properties.groupId": [
"a8bf3b8377cb4590865f2dbe94ba8d0a",
"711e47e772ca4a4ab448b7212cbf19cb"
]
}
},
"aggregations": {
"properties": {
"terms": {
"field": "properties.id",
"size": 10000
}
}
}
}
}
},
"options-filter": {
"nested": {
"path": "options"
},
"aggregations": {
"options-filter": {
"filter": {
"terms": {
"options.groupId": [
"a8bf3b8377cb4590865f2dbe94ba8d0a",
"711e47e772ca4a4ab448b7212cbf19cb"
]
}
},
"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"
}
}
}
},
"properties": {
"nested": {
"path": "properties"
},
"aggregations": {
"properties": {
"terms": {
"field": "properties.id",
"size": 10000
}
}
}
},
"options": {
"nested": {
"path": "options"
},
"aggregations": {
"options": {
"terms": {
"field": "options.id",
"size": 10000
}
}
}
},
"isUniversal-filter": {
"filter": {
"multi_match": {
"query": true,
"fields": [
"customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.migration_Shopware5DB_product_onco_universal_article"
],
"type": "best_fields"
}
},
"aggregations": {
"isUniversal": {
"max": {
"field": "customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.migration_Shopware5DB_product_onco_universal_article"
}
}
}
}
},
"size": 0,
"timeout": "5s"
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|