| 1 |
5.20 ms |
Request:
{"index":"sw6_stage__product","search_type":"query_then_fetch","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"should":[{"bool":{"must_not":[{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.2f37bfd0f23f482bad9d34a02199499b"}},{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.de44571ddc4e4d0095c01af6ee299351"}},{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.2fbb5fe2e29a4d70aa5854ce7ce3e20b"}}]}},{"multi_match":{"query":false,"fields":["customFields.2f37bfd0f23f482bad9d34a02199499b.migration_Shopware5DB_product_attr17","customFields.de44571ddc4e4d0095c01af6ee299351.migration_Shopware5DB_product_attr17","customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.migration_Shopware5DB_product_attr17"],"type":"best_fields"}}]}},{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"bc03b12fca6e446c9bbe735ae1f4d0ce"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"d37ff5b062464bf8ac9f7f5c9e68d24e"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"sort":[{"_script":{"type":"string","script":{"source":"def languages = params['languages'];\ndef suffix = params.containsKey('suffix') ? '.' + params['suffix'] : '';\n\nfor (int i = 0; i < languages.length; i++) {\n def field_name = params['field'] + '.' + languages[i] + suffix;\n\n if (doc[field_name].size() > 0 && doc[field_name].value != null && doc[field_name].value.toString().length() > 0) {\n def fieldValue = doc[field_name].value;\n\n return fieldValue.toString();\n }\n}\n\nreturn '';\n","lang":"painless","params":{"field":"customFields","languages":["2f37bfd0f23f482bad9d34a02199499b","de44571ddc4e4d0095c01af6ee299351","2fbb5fe2e29a4d70aa5854ce7ce3e20b"],"suffix":"fts_product_is_bartek"}},"order":"DESC"}},{"sales":{"order":"DESC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"}}
{
"took": 2,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 3,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw6_stage__product_1742425202",
"_id": "a2c20d29a47944ac9747e1680044f0be",
"_score": null,
"_source": {
"id": "a2c20d29a47944ac9747e1680044f0be",
"autoIncrement": 45765.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 1,
"productNumber": "sprk-100-brz",
"ean": null,
"displayGroup": "a7d3ad88d823807ba66f202b695d1a6b",
"sales": 0,
"stock": 1,
"weight": 1.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "97b7da5c3c9f4517ab4fc12582884f81",
"manufacturerNumber": "SPRK-100-BRZ",
"releaseDate": null,
"createdAt": "2022-03-29T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"305cc59fcd2445438f6b263eb3c59613",
"29ed1a88ffeb49eab1b221ebcc52a07a",
"d37ff5b062464bf8ac9f7f5c9e68d24e"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "305cc59fcd2445438f6b263eb3c59613",
"_count": 1
},
{
"id": "29ed1a88ffeb49eab1b221ebcc52a07a",
"_count": 1
},
{
"id": "d37ff5b062464bf8ac9f7f5c9e68d24e",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": null,
"coverId": "a992882c14d843dfa74d6c4c0c96021c",
"childCount": 0,
"categories": [
{
"id": "d37ff5b062464bf8ac9f7f5c9e68d24e",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Toyota",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Toyota",
"5494b24b09d445ebace47112836b4458": "Toyota"
}
}
],
"manufacturer": {
"id": "97b7da5c3c9f4517ab4fc12582884f81",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Supertech",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Supertech"
},
"_count": 1
},
"properties": [],
"options": [],
"categoryIds": [
"d37ff5b062464bf8ac9f7f5c9e68d24e"
],
"optionIds": [],
"propertyIds": [],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"fts_product_video_1": "https:\/\/www.youtube.com\/watch?v=hE_wKHYgIpc",
"fts_product_video_2": "https:\/\/www.youtube.com\/watch?v=PxvqGLmd9ow&t=146s",
"fts_product_video_1_title": "Ventilfedern",
"fts_product_video_2_title": "Titan - Was du wissen solltest",
"fts_product_video_1_description": "Heute dreht sich alles um die Ventilfedern. Bartek zeigt euch am Beispiel einer Ventilfeder was die Funktion der Ventilfedern ist. Wann brauchen wir verst\u00e4rkte Ventilfedern? Wie misst man sie? Auf dem Pr\u00fcfstand zeigt euch Bartek die Messwerte der Leistungs-Messung und beantwortet weitere wichtige Fragen! 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\/2-0l-tfsi-ventilfedern-satz-titan https:\/\/www.bar-tek-tuning.de\/ventilkeile-gehaertet-high-boost-vag https:\/\/www.bar-tek-tuning.de\/20l-tsi-ventilfedern-satz-titan 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 #ventilfedern #ladedruck #kolben",
"fts_product_video_1_upload_date": "2021-01-17 17:00:30.000",
"fts_product_video_2_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_2_upload_date": "2021-02-14 17:30:01.000",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"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_url": "supertech-sport-ventilfedern-fuer-gt86-brz-fa20",
"migration_Shopware5DB_product_dreisc_seo_title": "Supertech Sport Ventilfedern Satz f\u00fcr Toyota GT86 & Subaru BRZ FA20",
"migration_Shopware5DB_product_onco_universal_article": false
},
"5494b24b09d445ebace47112836b4458": {
"fts_product_video_1": "https:\/\/www.youtube.com\/watch?v=hE_wKHYgIpc",
"fts_product_video_2": "https:\/\/www.youtube.com\/watch?v=PxvqGLmd9ow&t=146s",
"fts_product_video_1_title": "Ventilfedern",
"fts_product_video_2_title": "Titan - Was du wissen solltest",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"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": "Supertech Sport Ventilfedern Satz f\u00fcr Toyota GT86 & Subaru BRZ FA20",
"migration_Shopware5DB_product_onco_universal_article": false
},
"de44571ddc4e4d0095c01af6ee299351": {
"fts_product_video_1": "https:\/\/www.youtube.com\/watch?v=hE_wKHYgIpc",
"fts_product_video_2": "https:\/\/www.youtube.com\/watch?v=PxvqGLmd9ow&t=146s",
"fts_product_video_1_title": "Ventilfedern",
"fts_product_video_2_title": "Titan - Was du wissen solltest",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"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_url": "supertech-sport-valve-springs-for-gt86-brz-fa20",
"migration_Shopware5DB_product_dreisc_seo_title": "Supertech Sport Ventilfedern Satz f\u00fcr Toyota GT86 & Subaru BRZ FA20",
"migration_Shopware5DB_product_onco_universal_article": false
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Supertech SPRK-100 Ventilfedern Satz passend f\u00fcr Toyota GT86 & Subaru BRZ FA20",
"5494b24b09d445ebace47112836b4458": "Supertech SPRK-100 Jeu de ressorts de soupapes adaptable sur Toyota GT86 & Subaru BRZ FA20",
"de44571ddc4e4d0095c01af6ee299351": "Supertech SPRK-100 valve spring set fits Toyota GT86 & Subaru BRZ FA20"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sport-Ventilfedern-Satz von Supertech aus hochwertig verg\u00fctetem Stahl mit Titan Federtellern f\u00fcr alle FA20 Boxer Motoren.Diese Ventilfedern haben eine extra angepasste Federrate.Besseres und schnelleres AnsprechverhaltenH\u00f6here Motordrehzahl m\u00f6glichLeichterer Ventiltrieb durch TitantellerAbsolut standfest f\u00fcr hohe Drehzahlen\n\u00c4u\u00dfere Feder Au\u00dfendurchmesser: 30,20mm\u00c4u\u00dfere Feder Innendurchmesser: 22,20mmInnere Feder Au\u00dfendurchmesser: 22,20mmInnere Feder Innendurchmesser: 16,80mmDruck Ventilsitz: 39,46kg\/33,5mmDruck ge\u00f6ffnet: 96,16kg\/10mmMax. Hub: 15,00mmMin. Federh\u00f6he (im gepressten Zustand): 18,50mmFederrate in lbs.\/mm: 12,50\nIm Kit enthalten:\n\n16 Ventilfedern\nFederteller aus Titan oben\nFederteller aus Stahl unten\n",
"5494b24b09d445ebace47112836b4458": "Jeu de ressorts de soupapes sport de Supertech en acier tremp\u00e9 de haute qualit\u00e9 avec coupelles de ressort en titane pour tous les moteurs FA20 Boxer.Ces ressorts de soupapes ont un taux de ressort sp\u00e9cialement adapt\u00e9. - R\u00e9ponse meilleure et plus rapide - Possibilit\u00e9 de r\u00e9gime moteur plus \u00e9lev\u00e9 - Commande de soupape plus l\u00e9g\u00e8re gr\u00e2ce aux rondelles en titane - Stabilit\u00e9 absolue pour les r\u00e9gimes \u00e9lev\u00e9s\nOuter spring external diameter : 30,20mmOuter spring internal diameter : 22,20mmInner spring external diameter : 22,20mmInner spring internal diameter : 16,80mmPressure valve seat : 39,46kg\/33,5mmPressure seat : 96,16kg\/10mmMax. lift : 15,00mmCoil bind (under stress) : 18,50mmRate in lbs.\/mm : 12,50 Le kit comprend :\n\n16 ressorts de soupape\nSi\u00e8ge de ressort en titane en haut\nSi\u00e8ge de ressort en acier en bas\n",
"de44571ddc4e4d0095c01af6ee299351": "Sport valve spring set from Supertech made of high quality tempered steel with titanium spring plates for all FA20 Boxer engines.These valve springs have an extra adjusted spring rate. - Better and faster response - Higher engine speed possible - Lighter valve train due to titanium retainers - Absolutely stable for high rpm\nOuter spring external diameter: 30,20mmOuter spring internal diameter: 22,20mmInner spring external diameter: 22,20mmInner spring internal diameter: 16,80mmPressure valve seat: 39,46kg\/33,5mmPressure seat: 96,16kg\/10mmMax. lift: 15,00mmCoil bind (under stress): 18,50mmRate in lbs.\/mm: 12,50 Includedinkit:\n\n16 valve springs\nSpring retainer titanium top\nSpring retainer steel bottom\n"
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.0 TFSI Sport Ventilfedern Satz SUPERTECH",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 661.6876,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 556.04,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 661.6876,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 556.04,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 661.6876,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 556.04,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 719.96,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 605.00840336134,
"shop-customer": "605.00840336134",
"b-dealer": "556.04",
"c-dealer": "556.04",
"a-dealer": "556.04"
},
"fields": {
"displayGroup": [
"a7d3ad88d823807ba66f202b695d1a6b"
]
},
"sort": [
"",
0,
"a2c20d29a47944ac9747e1680044f0be"
]
},
{
"_index": "sw6_stage__product_1742425202",
"_id": "a77b243a5ac14eb499ba8e6a137eb11e",
"_score": null,
"_source": {
"id": "a77b243a5ac14eb499ba8e6a137eb11e",
"autoIncrement": 70801.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 0,
"productNumber": "21toyo32",
"ean": null,
"displayGroup": "e98650def6d85d900ed8dff512e31780",
"sales": 0,
"stock": 0,
"weight": 2.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "97b7da5c3c9f4517ab4fc12582884f81",
"manufacturerNumber": "SPRK-TC25D-24-2",
"releaseDate": null,
"createdAt": "2023-02-22T14:42:15+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"305cc59fcd2445438f6b263eb3c59613",
"29ed1a88ffeb49eab1b221ebcc52a07a",
"d37ff5b062464bf8ac9f7f5c9e68d24e"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "305cc59fcd2445438f6b263eb3c59613",
"_count": 1
},
{
"id": "29ed1a88ffeb49eab1b221ebcc52a07a",
"_count": 1
},
{
"id": "d37ff5b062464bf8ac9f7f5c9e68d24e",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": null,
"coverId": "6daca32f613547daa36b8c4efd576ce8",
"childCount": 0,
"categories": [
{
"id": "d37ff5b062464bf8ac9f7f5c9e68d24e",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Toyota",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Toyota",
"5494b24b09d445ebace47112836b4458": "Toyota"
}
}
],
"manufacturer": {
"id": "97b7da5c3c9f4517ab4fc12582884f81",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Supertech",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Supertech"
},
"_count": 1
},
"properties": [],
"options": [],
"categoryIds": [
"d37ff5b062464bf8ac9f7f5c9e68d24e"
],
"optionIds": [],
"propertyIds": [],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"fts_product_video_1": "https:\/\/www.youtube.com\/watch?v=hE_wKHYgIpc",
"fts_product_video_2": "https:\/\/www.youtube.com\/watch?v=PxvqGLmd9ow&t=146s",
"fts_product_video_1_title": "Ventilfedern",
"fts_product_video_2_title": "Titan - Was du wissen solltest",
"fts_product_video_1_description": "Heute dreht sich alles um die Ventilfedern. Bartek zeigt euch am Beispiel einer Ventilfeder was die Funktion der Ventilfedern ist. Wann brauchen wir verst\u00e4rkte Ventilfedern? Wie misst man sie? Auf dem Pr\u00fcfstand zeigt euch Bartek die Messwerte der Leistungs-Messung und beantwortet weitere wichtige Fragen! 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\/2-0l-tfsi-ventilfedern-satz-titan https:\/\/www.bar-tek-tuning.de\/ventilkeile-gehaertet-high-boost-vag https:\/\/www.bar-tek-tuning.de\/20l-tsi-ventilfedern-satz-titan 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 #ventilfedern #ladedruck #kolben",
"fts_product_video_1_upload_date": "2021-01-17 17:00:30.000",
"fts_product_video_2_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_2_upload_date": "2021-02-14 17:30:01.000",
"migration_Shopware5DB_product_bullet0": "Sport Ventilfedern Kit",
"migration_Shopware5DB_product_bullet1": "h\u00f6here Drehzahlen",
"migration_Shopware5DB_product_bullet2": "extra angepasste Federrate",
"migration_Shopware5DB_product_bullet3": "leichterer Ventiltrieb ",
"fts_product_is_quick_link_authorized_dealer": true
},
"de44571ddc4e4d0095c01af6ee299351": {
"migration_Shopware5DB_product_bullet0": "Sport valve springs kit",
"migration_Shopware5DB_product_bullet1": "Higher speeds",
"migration_Shopware5DB_product_bullet2": "extra adjusted spring rate",
"migration_Shopware5DB_product_bullet3": "Lighter valve train "
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Supertech Sport Ventilfedern Kit f\u00fcr Toyota Supra 7MGTE 24V",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Supertech Sport Ventilfedern Kit for Toyota Supra 7MGTE 24V"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Supertech verst\u00e4rkter Ventilfedernsatz inkl. Titan Federteller f\u00fcr Toyota 7MGTE 24VDurch das Sport Federn Kit von Supertech mit den Titan Ventilfederteller k\u00f6nnen h\u00f6here Drehzahlen gefahren werden. Au\u00dferdem wird das Ventilflattern bei hohen Drehzahlen vermieden. Bei hohen Drehzahlen k\u00f6nnen die Kipphebel brechen und die Ventilfedern klemmen. Dies kann zu einem Motorschaden f\u00fchren! Die Supertech Ventilfedern haben eine extra angepasste Federrate, um dem Problem entgegen zu wirken. Features:leichterer Ventiltrieb wird dank der Titan Ventilfederteller\nschnelleres Hochdrehen\nh\u00f6here Motordrehzahlen m\u00f6glich\nGerade bei Leistungssteigerungen empfehlenswert\nWir empfehlen dazu noch Einlassventile und Inconel Auslassventile.\nDie Ventilfedern von Supertech werden aus einer extrem reinen Chrom-Silizium-Vanadium-Stahl-Legierung hergestellt, um bei leistungsgesteigerten Motoren sehr gute Haltbarkeit auch bei hohen Drehzahlen zu gew\u00e4hrleisten. Entwickelt mit Hilfe von Computersimulationen um sicherzustellen, dass auch unter extremen Bedingungen die Werkstoffe nicht erm\u00fcden. Die Halter sind aus einer zertifizierten Titan-Legierung hergestellt und CNC gefr\u00e4st f\u00fcr eine optimale Passform, damit eine lange Lebensdauer gew\u00e4hrleistet werden kann.Inhalt: \u2022 24x Doppelventilfeder\u2022 24x Titan-Ventilfederteller\u2022 24x Spring base\u2022 24x kleine \u00d6ldichtung\u2022 24x Valve Guides ",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Supertech reinforced valve spring kit incl. titanium spring retainers for Toyota 7MGTE 24V The sport spring kit from Supertech with the titanium valve spring retainers allows higher RPMs. It also eliminates valve flutter at high RPMs. \nAt high RPMs, the rocker arms can break and the valve springs can jam. This can lead to engine damage! The Supertech valve springs have an extra adjusted spring rate to counteract the problem. Features: lighter valve train becomes faster revving higher engine speeds possible thanks to the titanium valve spring retainers Especially recommended for performance upgrades We also recommend inlet valves and Inconel exhaust valves. Supertech's valve springs are made from an extremely pure chrome-silicon-vanadium steel alloy to ensure very good durability even at high rpm for performance upgraded engines. \nDesigned using computer simulations to ensure that even under extreme conditions the materials will not fatigue. \nBrackets are made of certified titanium alloy and CNC machined for optimal fit to ensure long life.\nContents: \u2022 24x double valve spring \u2022 24x Titanium valve spring retainer \u2022 24x spring base \u2022 24x small oil seal \u2022 24x valve guides"
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"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": 1065.0619,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 895.01,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1065.0619,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 895.01,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1065.0619,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 895.01,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1154.96,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 970.55462184874,
"shop-customer": "970.55462184874",
"c-dealer": "895.01",
"b-dealer": "895.01",
"a-dealer": "895.01"
},
"fields": {
"displayGroup": [
"e98650def6d85d900ed8dff512e31780"
]
},
"sort": [
"",
0,
"a77b243a5ac14eb499ba8e6a137eb11e"
]
},
{
"_index": "sw6_stage__product_1742425202",
"_id": "f81ac861697c435b91e4d79dec3fac89",
"_score": null,
"_source": {
"id": "f81ac861697c435b91e4d79dec3fac89",
"autoIncrement": 45766.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 1,
"productNumber": "sprk-1002-brz",
"ean": null,
"displayGroup": "03b59a66ca2a8cd11b7028bec14a1169",
"sales": 0,
"stock": 1,
"weight": 1.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "97b7da5c3c9f4517ab4fc12582884f81",
"manufacturerNumber": "SPRK-1002-BRZ",
"releaseDate": null,
"createdAt": "2022-03-29T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"305cc59fcd2445438f6b263eb3c59613",
"29ed1a88ffeb49eab1b221ebcc52a07a",
"d37ff5b062464bf8ac9f7f5c9e68d24e"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "305cc59fcd2445438f6b263eb3c59613",
"_count": 1
},
{
"id": "29ed1a88ffeb49eab1b221ebcc52a07a",
"_count": 1
},
{
"id": "d37ff5b062464bf8ac9f7f5c9e68d24e",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": null,
"coverId": "0d796849a31c46f4a967d0bd8a0aed68",
"childCount": 0,
"categories": [
{
"id": "d37ff5b062464bf8ac9f7f5c9e68d24e",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Toyota",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Toyota",
"5494b24b09d445ebace47112836b4458": "Toyota"
}
}
],
"manufacturer": {
"id": "97b7da5c3c9f4517ab4fc12582884f81",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Supertech",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Supertech"
},
"_count": 1
},
"properties": [],
"options": [],
"categoryIds": [
"d37ff5b062464bf8ac9f7f5c9e68d24e"
],
"optionIds": [],
"propertyIds": [],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"fts_product_video_1": "https:\/\/www.youtube.com\/watch?v=hE_wKHYgIpc",
"fts_product_video_2": "https:\/\/www.youtube.com\/watch?v=PxvqGLmd9ow&t=146s",
"fts_product_video_1_title": "Ventilfedern",
"fts_product_video_2_title": "Titan - Was du wissen solltest",
"fts_product_video_1_description": "Heute dreht sich alles um die Ventilfedern. Bartek zeigt euch am Beispiel einer Ventilfeder was die Funktion der Ventilfedern ist. Wann brauchen wir verst\u00e4rkte Ventilfedern? Wie misst man sie? Auf dem Pr\u00fcfstand zeigt euch Bartek die Messwerte der Leistungs-Messung und beantwortet weitere wichtige Fragen! 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\/2-0l-tfsi-ventilfedern-satz-titan https:\/\/www.bar-tek-tuning.de\/ventilkeile-gehaertet-high-boost-vag https:\/\/www.bar-tek-tuning.de\/20l-tsi-ventilfedern-satz-titan 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 #ventilfedern #ladedruck #kolben",
"fts_product_video_1_upload_date": "2021-01-17 17:00:30.000",
"fts_product_video_2_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_2_upload_date": "2021-02-14 17:30:01.000",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"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_url": "supertech-sport-ventilfedern-gt86-brz-fa20-1002",
"migration_Shopware5DB_product_dreisc_seo_title": "Supertech Sport Ventilfedern Satz f\u00fcr Toyota GT86 & Subaru BRZ FA20",
"migration_Shopware5DB_product_onco_universal_article": false
},
"5494b24b09d445ebace47112836b4458": {
"fts_product_video_1": "https:\/\/www.youtube.com\/watch?v=hE_wKHYgIpc",
"fts_product_video_2": "https:\/\/www.youtube.com\/watch?v=PxvqGLmd9ow&t=146s",
"fts_product_video_1_title": "Ventilfedern",
"fts_product_video_2_title": "Titan - Was du wissen solltest",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"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": "Supertech Sport Ventilfedern Satz f\u00fcr Toyota GT86 & Subaru BRZ FA20",
"migration_Shopware5DB_product_onco_universal_article": false
},
"de44571ddc4e4d0095c01af6ee299351": {
"fts_product_video_1": "https:\/\/www.youtube.com\/watch?v=hE_wKHYgIpc",
"fts_product_video_2": "https:\/\/www.youtube.com\/watch?v=PxvqGLmd9ow&t=146s",
"fts_product_video_1_title": "Ventilfedern",
"fts_product_video_2_title": "Titan - Was du wissen solltest",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"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_url": "supertech-sport-valve-springs-gt86-brz-fa20-1002",
"migration_Shopware5DB_product_dreisc_seo_title": "Supertech Sport Ventilfedern Satz f\u00fcr Toyota GT86 & Subaru BRZ FA20",
"migration_Shopware5DB_product_onco_universal_article": false
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Supertech SPRK-1002 Ventilfedern Satz passend f\u00fcr Toyota GT86 & Subaru BRZ FA20",
"5494b24b09d445ebace47112836b4458": "Supertech SPRK-1002 Jeu de ressorts de soupapes adaptable sur Toyota GT86 & Subaru BRZ FA20",
"de44571ddc4e4d0095c01af6ee299351": "Supertech SPRK-1002 valve spring set fits Toyota GT86 & Subaru BRZ FA20"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sport-Ventilfedern-Satz von Supertech aus hochwertig verg\u00fctetem Stahl mit Titan Federtellern f\u00fcr alle FA20 Boxer Motoren.Diese Ventilfedern haben eine extra angepasste Federrate. - Besseres und schnelleres Ansprechverhalten - H\u00f6here Motordrehzahl m\u00f6glich - Leichterer Ventiltrieb durch Titanteller - Absolut standfest f\u00fcr hohe Drehzahlen\n\u00c4u\u00dfere Feder Au\u00dfendurchmesser: 29,05mm\u00c4u\u00dfere Feder Innendurchmesser: 21,85mmInnere Feder Au\u00dfendurchmesser: 20,50mmInnere Feder Innendurchmesser: 15,50mmDruck Ventilsitz: 33,57kg\/33,5mmDruck ge\u00f6ffnet: 78,93kg\/10mmMax. Hub: 14,00mmMin. Federh\u00f6he (im gepressten Zustand): 19,50mmFederrate in lbs.\/mm: 10,00 Im Kit enthalten:\n\n16 Ventilfedern\nFederteller aus Titan oben\nFederteller aus Stahl unten\n",
"5494b24b09d445ebace47112836b4458": "Jeu de ressorts de soupapes sport de Supertech en acier tremp\u00e9 de haute qualit\u00e9 avec coupelles de ressort en titane pour tous les moteurs FA20 Boxer.Ces ressorts de soupapes ont un taux de ressort sp\u00e9cialement adapt\u00e9. - R\u00e9ponse meilleure et plus rapide - Possibilit\u00e9 de r\u00e9gime moteur plus \u00e9lev\u00e9 - Commande de soupape plus l\u00e9g\u00e8re gr\u00e2ce aux rondelles en titane - Stabilit\u00e9 absolue pour les r\u00e9gimes \u00e9lev\u00e9s\nRessort ext\u00e9rieur Diam\u00e8tre ext\u00e9rieur : 29,05mmRessort ext\u00e9rieur Diam\u00e8tre int\u00e9rieur : 21,85mmRessort int\u00e9rieur Diam\u00e8tre ext\u00e9rieur : 20,50mmRessort int\u00e9rieur Diam\u00e8tre int\u00e9rieur : 15,50mmPression du si\u00e8ge de soupape : 33,57kg\/33,5mmPression ouverte : 78,93kg\/10mmPression max. Course : 14,00mmHauteur min. du ressort (\u00e0 l'\u00e9tat comprim\u00e9) : 19,50mmTaux de ressort en lbs.\/mm : 10,00 Inclus dans le kit :\n\n16 ressorts de soupape\nSi\u00e8ge de ressort en titane en haut\nSi\u00e8ge de ressort en acier en bas\n",
"de44571ddc4e4d0095c01af6ee299351": "Sport valve spring set from Supertech made of high quality tempered steel with titanium spring plates for all FA20 Boxer engines.These valve springs have an extra adjusted spring rate. - Better and faster response - Higher engine speed possible - Lighter valve train due to titanium plates - Absolutely stable for high rpm\nOuter spring outer diameter: 29,05mmOuter spring inner diameter: 21,85mmInner spring outer diameter: 20,50mmInner spring inner diameter: 15,50mmValve seat pressure: 33,57kg\/33,5mmPressure open: 78,93kg\/10mmMax. Stroke: 14.00mmMin. spring height (when compressed): 19.50mmSpring rate in lbs.\/mm: 10.00 Included in kit:\n\n16 valve springs\nSpring retainer made of titanium top\nSpring retainer from steel below\n"
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.0 TFSI Sport Ventilfedern Satz SUPERTECH",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 716.8322,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 602.38,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 716.8322,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 602.38,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 716.8322,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 602.38,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 799.96,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 672.23529411765,
"shop-customer": "672.23529411765",
"a-dealer": "602.38",
"b-dealer": "602.38",
"c-dealer": "602.38"
},
"fields": {
"displayGroup": [
"03b59a66ca2a8cd11b7028bec14a1169"
]
},
"sort": [
"",
0,
"f81ac861697c435b91e4d79dec3fac89"
]
}
]
},
"aggregations": {
"total-count": {
"value": 3
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
4.84 ms |
Request:
{"index":"sw6_stage__product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"should":[{"bool":{"must_not":[{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.2f37bfd0f23f482bad9d34a02199499b"}},{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.de44571ddc4e4d0095c01af6ee299351"}},{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.2fbb5fe2e29a4d70aa5854ce7ce3e20b"}}]}},{"multi_match":{"query":false,"fields":["customFields.2f37bfd0f23f482bad9d34a02199499b.migration_Shopware5DB_product_attr17","customFields.de44571ddc4e4d0095c01af6ee299351.migration_Shopware5DB_product_attr17","customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.migration_Shopware5DB_product_attr17"],"type":"best_fields"}}]}},{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"bc03b12fca6e446c9bbe735ae1f4d0ce"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"d37ff5b062464bf8ac9f7f5c9e68d24e"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"aggregations":{"manufacturer":{"terms":{"field":"manufacturerId","size":10000}},"price":{"stats":{"script":{"id":"cheapest_price","params":{"accessors":[{"key":"cheapest_price_rule1cc29aa9f88949329e6cd664b787d516_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule6598b1e356e544aca14190369f541afd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule6fc5504f876847f3a0141e22e4c26a50_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule85d57b12075f46a2900284013873d2a8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulec0412fc3a3f143b28d448bb7159c0093_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulecdb735e7d3134436b8e4903f940fb0c8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruledc8abfeae1214f8293d61d6093798ceb_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule243c52152d234b3687fd0a44399fd191_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulea8f2508d908f42a9b77c36c70e404fc6_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruleb19ca2e7e7b148ce93fa5339fcd72c06_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulee44e6782c64247b796b891cf25ae38f7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule38535ec8e284419db79495611c950227_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule5548eedc74e1440baaa75c289eabeec6_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule6ee4f48f76b049f7bcf4052b54b75610_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruleb2215ffece654a23b0020cb503c2f316_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulec87cc889ffa744f4ab9e76d88c720fc3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1}],"decimals":100,"round":true,"multiplier":100.0}}}},"properties":{"nested":{"path":"properties"},"aggregations":{"properties":{"terms":{"field":"properties.id","size":10000}}}},"options":{"nested":{"path":"options"},"aggregations":{"options":{"terms":{"field":"options.id","size":10000}}}},"isAvailable-filter":{"filter":{"term":{"active":true}},"aggregations":{"isAvailable":{"max":{"field":"stock"}}}},"customPrice-3-100":{"filter":{"range":{"shop-customer":{"gte":2.5210084033613445,"lte":84.03361344537815}}},"aggregations":{"customPrice-3-100":{"value_count":{"field":"id"}}}},"customPrice-100-300":{"filter":{"range":{"shop-customer":{"gte":84.03361344537815,"lte":252.10084033613447}}},"aggregations":{"customPrice-100-300":{"value_count":{"field":"id"}}}},"customPrice-300-500":{"filter":{"range":{"shop-customer":{"gte":252.10084033613447,"lte":420.1680672268908}}},"aggregations":{"customPrice-300-500":{"value_count":{"field":"id"}}}},"customPrice-500-700":{"filter":{"range":{"shop-customer":{"gte":420.1680672268908,"lte":588.2352941176471}}},"aggregations":{"customPrice-500-700":{"value_count":{"field":"id"}}}},"customPrice-700-900":{"filter":{"range":{"shop-customer":{"gte":588.2352941176471,"lte":756.3025210084033}}},"aggregations":{"customPrice-700-900":{"value_count":{"field":"id"}}}},"customPrice-900-1300":{"filter":{"range":{"shop-customer":{"gte":756.3025210084033,"lte":1092.4369747899161}}},"aggregations":{"customPrice-900-1300":{"value_count":{"field":"id"}}}},"customPrice-1300":{"filter":{"range":{"shop-customer":{"gte":1092.4369747899161}}},"aggregations":{"customPrice-1300":{"value_count":{"field":"id"}}}},"isUniversal-filter":{"filter":{"multi_match":{"query":true,"fields":["customFields.2f37bfd0f23f482bad9d34a02199499b.migration_Shopware5DB_product_onco_universal_article","customFields.de44571ddc4e4d0095c01af6ee299351.migration_Shopware5DB_product_onco_universal_article","customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.migration_Shopware5DB_product_onco_universal_article"],"type":"best_fields"}},"aggregations":{"isUniversal":{"max":{"field":"customFields.2f37bfd0f23f482bad9d34a02199499b.migration_Shopware5DB_product_onco_universal_article"}}}}},"size":0,"timeout":"5s"},"search_type":"query_then_fetch"}
POST http://opensearch-master:9200/sw6_stage__product/_search?track_total_hits=0&search_type=query_then_fetch
Accept: application/json
Content-Type: application/json
{
"query": {
"bool": {
"filter": [
{
"bool": {
"must": [
{
"bool": {
"should": [
{
"bool": {
"must_not": [
{
"exists": {
"field": "customFields.migration_Shopware5DB_product_attr17.2f37bfd0f23f482bad9d34a02199499b"
}
},
{
"exists": {
"field": "customFields.migration_Shopware5DB_product_attr17.de44571ddc4e4d0095c01af6ee299351"
}
},
{
"exists": {
"field": "customFields.migration_Shopware5DB_product_attr17.2fbb5fe2e29a4d70aa5854ce7ce3e20b"
}
}
]
}
},
{
"multi_match": {
"query": false,
"fields": [
"customFields.2f37bfd0f23f482bad9d34a02199499b.migration_Shopware5DB_product_attr17",
"customFields.de44571ddc4e4d0095c01af6ee299351.migration_Shopware5DB_product_attr17",
"customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.migration_Shopware5DB_product_attr17"
],
"type": "best_fields"
}
}
]
}
},
{
"bool": {
"must": [
{
"nested": {
"path": "visibilities",
"query": {
"bool": {
"must": [
{
"range": {
"visibilities.visibility": {
"gte": 30
}
}
},
{
"term": {
"visibilities.salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
}
]
}
}
}
},
{
"term": {
"active": true
}
}
]
}
},
{
"nested": {
"path": "categoriesRo",
"query": {
"term": {
"categoriesRo.id": "d37ff5b062464bf8ac9f7f5c9e68d24e"
}
}
}
},
{
"bool": {
"must_not": [
{
"bool": {
"must_not": [
{
"exists": {
"field": "displayGroup"
}
}
]
}
}
]
}
}
]
}
}
]
}
},
"aggregations": {
"manufacturer": {
"terms": {
"field": "manufacturerId",
"size": 10000
}
},
"price": {
"stats": {
"script": {
"id": "cheapest_price",
"params": {
"accessors": [
{
"key": "cheapest_price_rule1cc29aa9f88949329e6cd664b787d516_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule6598b1e356e544aca14190369f541afd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule6fc5504f876847f3a0141e22e4c26a50_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule85d57b12075f46a2900284013873d2a8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rulec0412fc3a3f143b28d448bb7159c0093_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rulecdb735e7d3134436b8e4903f940fb0c8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_ruledc8abfeae1214f8293d61d6093798ceb_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule243c52152d234b3687fd0a44399fd191_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rulea8f2508d908f42a9b77c36c70e404fc6_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_ruleb19ca2e7e7b148ce93fa5339fcd72c06_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rulee44e6782c64247b796b891cf25ae38f7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule38535ec8e284419db79495611c950227_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule5548eedc74e1440baaa75c289eabeec6_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule6ee4f48f76b049f7bcf4052b54b75610_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_ruleb2215ffece654a23b0020cb503c2f316_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rulec87cc889ffa744f4ab9e76d88c720fc3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
}
],
"decimals": 100,
"round": true,
"multiplier": 100.0
}
}
}
},
"properties": {
"nested": {
"path": "properties"
},
"aggregations": {
"properties": {
"terms": {
"field": "properties.id",
"size": 10000
}
}
}
},
"options": {
"nested": {
"path": "options"
},
"aggregations": {
"options": {
"terms": {
"field": "options.id",
"size": 10000
}
}
}
},
"isAvailable-filter": {
"filter": {
"term": {
"active": true
}
},
"aggregations": {
"isAvailable": {
"max": {
"field": "stock"
}
}
}
},
"customPrice-3-100": {
"filter": {
"range": {
"shop-customer": {
"gte": 2.5210084033613445,
"lte": 84.03361344537815
}
}
},
"aggregations": {
"customPrice-3-100": {
"value_count": {
"field": "id"
}
}
}
},
"customPrice-100-300": {
"filter": {
"range": {
"shop-customer": {
"gte": 84.03361344537815,
"lte": 252.10084033613447
}
}
},
"aggregations": {
"customPrice-100-300": {
"value_count": {
"field": "id"
}
}
}
},
"customPrice-300-500": {
"filter": {
"range": {
"shop-customer": {
"gte": 252.10084033613447,
"lte": 420.1680672268908
}
}
},
"aggregations": {
"customPrice-300-500": {
"value_count": {
"field": "id"
}
}
}
},
"customPrice-500-700": {
"filter": {
"range": {
"shop-customer": {
"gte": 420.1680672268908,
"lte": 588.2352941176471
}
}
},
"aggregations": {
"customPrice-500-700": {
"value_count": {
"field": "id"
}
}
}
},
"customPrice-700-900": {
"filter": {
"range": {
"shop-customer": {
"gte": 588.2352941176471,
"lte": 756.3025210084033
}
}
},
"aggregations": {
"customPrice-700-900": {
"value_count": {
"field": "id"
}
}
}
},
"customPrice-900-1300": {
"filter": {
"range": {
"shop-customer": {
"gte": 756.3025210084033,
"lte": 1092.4369747899161
}
}
},
"aggregations": {
"customPrice-900-1300": {
"value_count": {
"field": "id"
}
}
}
},
"customPrice-1300": {
"filter": {
"range": {
"shop-customer": {
"gte": 1092.4369747899161
}
}
},
"aggregations": {
"customPrice-1300": {
"value_count": {
"field": "id"
}
}
}
},
"isUniversal-filter": {
"filter": {
"multi_match": {
"query": true,
"fields": [
"customFields.2f37bfd0f23f482bad9d34a02199499b.migration_Shopware5DB_product_onco_universal_article",
"customFields.de44571ddc4e4d0095c01af6ee299351.migration_Shopware5DB_product_onco_universal_article",
"customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.migration_Shopware5DB_product_onco_universal_article"
],
"type": "best_fields"
}
},
"aggregations": {
"isUniversal": {
"max": {
"field": "customFields.2f37bfd0f23f482bad9d34a02199499b.migration_Shopware5DB_product_onco_universal_article"
}
}
}
}
},
"size": 0,
"timeout": "5s"
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|