| 1 |
4.81 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":"9b8e4f834b9a49cda9cbb3d54df4a27d"}}}},{"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": 2,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 9,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw6_stage__product_1742425202",
"_id": "038152fbe41546bb8047ae56488404d4",
"_score": null,
"_source": {
"id": "038152fbe41546bb8047ae56488404d4",
"autoIncrement": 51118.0,
"ratingAverage": 5.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 0,
"productNumber": "H010701002.3",
"ean": null,
"displayGroup": "468c2a1deae4e59e19774a8582c5be33",
"sales": 0,
"stock": 0,
"weight": 3.0,
"width": 0.0,
"length": 1014.0,
"height": 0.0,
"manufacturerId": "385705f0da5a4d21ad2289eb3c1d9fb9",
"manufacturerNumber": "010147",
"releaseDate": null,
"createdAt": "2017-01-01T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"12298808f73a4bf781a9dcc9b2800801",
"cbbb14c819094376b33f3700d8787ff7",
"9b8e4f834b9a49cda9cbb3d54df4a27d"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "12298808f73a4bf781a9dcc9b2800801",
"_count": 1
},
{
"id": "cbbb14c819094376b33f3700d8787ff7",
"_count": 1
},
{
"id": "9b8e4f834b9a49cda9cbb3d54df4a27d",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": "98100b722b754f1abf40c31b36844de4",
"coverId": "a592292bbb18459da2666d1310db0ea5",
"childCount": 0,
"categories": [
{
"id": "9b8e4f834b9a49cda9cbb3d54df4a27d",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Protecci\u00f3n t\u00e9rmica turbo",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Turbo-Hitzeschutz",
"5494b24b09d445ebace47112836b4458": "Turbo protection contre la chaleur",
"de44571ddc4e4d0095c01af6ee299351": "Turbo Heat Protection"
}
}
],
"manufacturer": {
"id": "385705f0da5a4d21ad2289eb3c1d9fb9",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "DEI",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "DEI"
},
"_count": 1
},
"properties": [],
"options": [
{
"id": "f9a1c125d12f4f2fbd43f496f8a371a1",
"_count": 1,
"groupId": "335273dd163e4d09bb3ca3cdff219a87",
"group": {
"id": "335273dd163e4d09bb3ca3cdff219a87",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "T6",
"5494b24b09d445ebace47112836b4458": "T6",
"de44571ddc4e4d0095c01af6ee299351": "T6"
}
}
],
"categoryIds": [
"9b8e4f834b9a49cda9cbb3d54df4a27d"
],
"optionIds": [
"f9a1c125d12f4f2fbd43f496f8a371a1"
],
"propertyIds": [],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"fts_product_video_1": "https:\/\/www.youtube.com\/watch?v=PxvqGLmd9ow",
"fts_product_video_1_title": "Titan - Alles was du wissen musst",
"fts_product_video_1_description": "Heute dreht sich alles um Titan! Was genau zeichnet Titan aus und was sind die Vorteile einer Titannietrierten Beschichtung? Worauf muss man bei der Montage achten? Und warum solltest du die Beschichtung nicht mit blanken Fingern anfassen? Wie kann man Titandestillat am Motor anwenden? Diese und weitere wichtige Fragen beantwortet euch Bartek in diesem Video! Was m\u00f6chtet ihr als n\u00e4chstes sehen, was interessiert euch besonders? Schreibt es in die Kommentare! Hier geht\u2019s zu den Produkten im Video: https:\/\/www.bar-tek-tuning.de\/h-schaft-pleuel-titannitriert-2-0-l-tsi-ea888 https:\/\/www.bar-tek-tuning.de\/2-0l-tfsi-ventilfedern-satz-titan https:\/\/www.bar-tek-tuning.de\/titan-destillat-150-ml Stay tuned! Ihr habt Fragen?! @: info@bar-tek.de Folgt uns unbedingt auch auf unseren Social-Media-Kan\u00e4len! Ihr findet uns auch auf Facebook: https:\/\/de-de.facebook.com\/BARTEK.Motorsport Checkt jetzt unseren Instagram Kanal aus: https:\/\/www.instagram.com\/bartekmotorsport\/?hl=de Nutzt auch unsere eigenen GIPHYs: https:\/\/giphy.com\/BAR-TEK_Motorsport #titan #titannietriert #titandestillat",
"fts_product_video_1_upload_date": "2021-02-14 17:30:01.000",
"migration_Shopware5DB_product_attr9": "DEI",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_url": "titanhitzeschutz-turbohitzeschutz-schutzfuerdenturbo",
"migration_Shopware5DB_product_dreisc_seo_title": "Titan Turbo-Schild - Kit",
"migration_Shopware5DB_product_onco_universal_article": true
},
"5494b24b09d445ebace47112836b4458": {
"fts_product_video_1": "https:\/\/www.youtube.com\/watch?v=PxvqGLmd9ow&t=146s",
"fts_product_video_1_title": "Titan - Alles was du wissen musst",
"migration_Shopware5DB_product_attr9": "DEI",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_socialfeed": false,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_title": "Titan Turbo-Schild - Kit",
"migration_Shopware5DB_product_onco_universal_article": true
},
"de44571ddc4e4d0095c01af6ee299351": {
"fts_product_video_1": "https:\/\/www.youtube.com\/watch?v=PxvqGLmd9ow",
"fts_product_video_2": "https:\/\/www.youtube.com\/watch?v=Mdqafk-mLxk",
"fts_product_video_1_title": "Titan - All you need to know",
"fts_product_video_2_title": "Titanium - Everything you need to know! ",
"migration_Shopware5DB_product_attr9": "DEI",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_url": " ",
"migration_Shopware5DB_product_dreisc_seo_title": "Titan Turbo-Schild - Kit",
"migration_Shopware5DB_product_onco_universal_article": true
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Titan Turbo-Schild - Kit",
"5494b24b09d445ebace47112836b4458": "Bouclier turbo en titane - Kit",
"de44571ddc4e4d0095c01af6ee299351": "Customized titanium turbo shield"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ma\u00dfgeschneiderte Titan Turbo Schilde Als Kit zus\u00e4tzliche Lieferung von Isolations-Tape (5cm x 4,6m), zwei rostfreien Stahl-Schellen und Befestigungsdraht (1,5m). Ultimatives Mittel zur Reduzierung des Turbolochs. Abschirmung und Schutz aller Motorkomponenten. Aus pulverisiertem Vulkangestein hergestellt, mit Silizium F\u00fcllmaterial. Im Carbon-Faser Design. Mit integrierten Verankerungshaken zur Sicherung. Ma\u00dfe der verschiedenen Modelle: T25\/T28 - Au\u00dfenumfang: 48 cm - Innenabstand: 6,35 cm T3 - Au\u00dfenumfang: 48 cm - Innenabstand: ca. 6,35 cm T4 - Au\u00dfenumfang: 56 cm - Innenabstand: ca. 7 cm T6 - Au\u00dfenumfang: 66 cm - Innenabstand: ca. 9,5 cm Extremer Schutz gegen turboladererzeugte Hitze. Sicherheitshinweise:Prinzipiell nicht brennbar, au\u00dfer nat\u00fcrlich wenn brennbare Fl\u00fcssigkeiten eingebracht werden. Wir bitten Sie alle entsprechenden Vorkehrungen zu treffen, um sicherzustellen, dass alle Fl\u00fcssigkeits-Armaturen in technisch einwandfreiem Zustand, versiegelt und dicht sind. Das Schild ist nicht darauf ausgelegt entfernt zu werden, nachdem es mehrfach erhitzt wurde. Durch mehrfaches Erhitzen verlieren die Fasern ihre anf\u00e4ngliche Flexibilit\u00e4t. Dadurch verringern sich nicht die thermischen Eigenschaften.",
"5494b24b09d445ebace47112836b4458": "Boucliers de turbo en titane sur mesure En kit, livraison suppl\u00e9mentaire de ruban isolant (5cm x 4,6m), de deux colliers de serrage en acier inoxydable et de fil de fixation (1,5m). Le moyen ultime de r\u00e9duire le d\u00e9calage du turbo. Blindage et protection de tous les composants du moteur. Fait de poudre de roche volcanique, avec un mat\u00e9riau de remplissage en silicium. En fibre de carbone. Avec des crochets d'ancrage int\u00e9gr\u00e9s pour la s\u00e9curit\u00e9. Dimensions des diff\u00e9rents mod\u00e8les : T25\/T28 - circonf\u00e9rence ext\u00e9rieure : 48 cm - distance int\u00e9rieure : 6,35 cm T3 - circonf\u00e9rence ext\u00e9rieure : 48 cm - distance int\u00e9rieure : environ 6,35 cm T4 - circonf\u00e9rence ext\u00e9rieure : 56 cm - distance int\u00e9rieure : environ 7 cm T6 - circonf\u00e9rence ext\u00e9rieure : 66 cm - distance int\u00e9rieure : environ 9,5 cm Protection extr\u00eame contre la chaleur g\u00e9n\u00e9r\u00e9e par le turbocompresseur. Consignes de s\u00e9curit\u00e9 : En principe non inflammable, sauf bien s\u00fbr en cas d'utilisation de liquides inflammables. Veuillez prendre toutes les pr\u00e9cautions n\u00e9cessaires pour vous assurer que tous les raccords de liquide sont en parfait \u00e9tat technique, scell\u00e9s et \u00e9tanches. L'\u00e9tiquette n'est pas con\u00e7ue pour \u00eatre retir\u00e9e apr\u00e8s avoir \u00e9t\u00e9 chauff\u00e9e plusieurs fois. Les chauffages r\u00e9p\u00e9t\u00e9s font perdre aux fibres leur souplesse initiale. Cela ne r\u00e9duit pas les propri\u00e9t\u00e9s thermiques.",
"de44571ddc4e4d0095c01af6ee299351": "Customized titanium turbo shield\n\nAs a kit additional supply of insulation tape (5cm x 4.6m), two stainless steel clamps and fixing wire (1.5m). \n\nUltimate means of reducing turbo lag. Shielding and protection of all engine components. Made of powdered volcanic rock, with silicon filler. In carbon fiber design. With integrated anchoring hooks for securing. \nT25\/T28 - Outer circumference: 48 cm - Inner distance: 6.35 cmT3 - outer circumference: 48 cm - inner distance: approx. 6.35 cmT4 - Outer circumference: 56 cm - Inner distance: approx. 7 cm T6 - outer circumference: 66 cm - inner distance: approx. 9.5 cmExtreme protection against turbocharger generated heat. Safety instructions:In principle non-flammable, except of course when flammable liquids are introduced. We ask that you take all appropriate precautions to ensure that all liquid fittings are in technically sound condition, sealed and tight. The shield is not designed to be removed after it has been heated multiple times. Multiple heating causes the fibers to lose their initial flexibility. This does not reduce the thermal properties."
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Titan Turbo-Schild - Kit",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Titanium Turbo Shield - Kit"
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 501.81,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 421.68674698795,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 473.3,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 397.72727272727,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 484.3,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 406.97674418605,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 519.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 436.93277310924,
"shop-customer": "436.93277310924",
"c-dealer": "421.68674698795",
"a-dealer": "397.72727272727",
"b-dealer": "406.97674418605"
},
"fields": {
"displayGroup": [
"468c2a1deae4e59e19774a8582c5be33"
]
},
"sort": [
"",
0,
"038152fbe41546bb8047ae56488404d4"
]
},
{
"_index": "sw6_stage__product_1742425202",
"_id": "4445281926d442f19e3dbbc208c0e420",
"_score": null,
"_source": {
"id": "4445281926d442f19e3dbbc208c0e420",
"autoIncrement": 47509.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 0,
"productNumber": "H010701003",
"ean": "607078101136",
"displayGroup": "22ebe49ef8cf223af134692c914832f8",
"sales": 0,
"stock": 0,
"weight": 3.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "385705f0da5a4d21ad2289eb3c1d9fb9",
"manufacturerNumber": "010113",
"releaseDate": null,
"createdAt": "2017-01-01T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"12298808f73a4bf781a9dcc9b2800801",
"cbbb14c819094376b33f3700d8787ff7",
"9b8e4f834b9a49cda9cbb3d54df4a27d"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "12298808f73a4bf781a9dcc9b2800801",
"_count": 1
},
{
"id": "cbbb14c819094376b33f3700d8787ff7",
"_count": 1
},
{
"id": "9b8e4f834b9a49cda9cbb3d54df4a27d",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": null,
"coverId": "28e58b5e1afb49d39292104051add213",
"childCount": 0,
"categories": [
{
"id": "9b8e4f834b9a49cda9cbb3d54df4a27d",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Protecci\u00f3n t\u00e9rmica turbo",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Turbo-Hitzeschutz",
"5494b24b09d445ebace47112836b4458": "Turbo protection contre la chaleur",
"de44571ddc4e4d0095c01af6ee299351": "Turbo Heat Protection"
}
}
],
"manufacturer": {
"id": "385705f0da5a4d21ad2289eb3c1d9fb9",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "DEI",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "DEI"
},
"_count": 1
},
"properties": [],
"options": [],
"categoryIds": [
"9b8e4f834b9a49cda9cbb3d54df4a27d"
],
"optionIds": [],
"propertyIds": [],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"migration_Shopware5DB_product_attr9": "DEI 010113",
"migration_Shopware5DB_product_attr14": "908",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_socialfeed": false,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_url": "turboschutz-turboisolation-hitzeschutz",
"migration_Shopware5DB_product_dreisc_seo_title": "Turbo Isolations Kit",
"migration_Shopware5DB_product_onco_universal_article": true
},
"5494b24b09d445ebace47112836b4458": {
"migration_Shopware5DB_product_attr9": "DEI 010113",
"migration_Shopware5DB_product_attr14": "908",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_socialfeed": false,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_title": "Turbo Isolations Kit",
"migration_Shopware5DB_product_onco_universal_article": true
},
"de44571ddc4e4d0095c01af6ee299351": {
"migration_Shopware5DB_product_attr9": "DEI 010113",
"migration_Shopware5DB_product_attr14": "908",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_socialfeed": false,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_url": " ",
"migration_Shopware5DB_product_dreisc_seo_title": "Turbo Isolations Kit",
"migration_Shopware5DB_product_onco_universal_article": true
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Turbo Isolations Kit",
"5494b24b09d445ebace47112836b4458": "Kit d'isolation des turbos",
"de44571ddc4e4d0095c01af6ee299351": "Turbo Insulation Kits"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Turbo Isolations Kit. Passt auf ann\u00e4hernd alle Turbolader, auch f\u00fcr Diesel Fahrzeuge. Designed um das Turboloch und Temperaturen unter der Motorhaube zu reduzieren. Leistungssteigerung durch Zufuhr k\u00fchlerer Luft. Sch\u00fctzt auch andere Motorkomponenten vor Hitzesch\u00e4den. Einfache Installation.",
"5494b24b09d445ebace47112836b4458": "Kit d'isolation du turbo. Convient \u00e0 presque tous les turbocompresseurs, y compris pour les v\u00e9hicules diesel. Con\u00e7u pour r\u00e9duire le d\u00e9calage du turbo et les temp\u00e9ratures sous le capot. Am\u00e9lioration des performances gr\u00e2ce \u00e0 l'apport d'air plus frais. Il prot\u00e8ge \u00e9galement les autres composants du moteur contre les dommages caus\u00e9s par la chaleur. Facile \u00e0 installer.",
"de44571ddc4e4d0095c01af6ee299351": "Turbo Insulation Kits. Designed for all turbochargers, also for diesels. Reduces the turbo lag and the temperatures under the hood. Improved performance by cooler air charge. Protection from heat damages at other motor components. Easy to install."
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Turbo Isolations Kit",
"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": 84,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 70.588235294118,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 81.14,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 68.181818181818,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 82.07,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 68.965517241379,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 89.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 75.588235294118,
"shop-customer": "75.588235294118",
"c-dealer": "70.588235294118",
"a-dealer": "68.181818181818",
"b-dealer": "68.965517241379"
},
"fields": {
"displayGroup": [
"22ebe49ef8cf223af134692c914832f8"
]
},
"sort": [
"",
0,
"4445281926d442f19e3dbbc208c0e420"
]
},
{
"_index": "sw6_stage__product_1742425202",
"_id": "80bf0ce8c1894d9ead4ccfff03945a98",
"_score": null,
"_source": {
"id": "80bf0ce8c1894d9ead4ccfff03945a98",
"autoIncrement": 51120.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 0,
"productNumber": "H010701001.3",
"ean": null,
"displayGroup": "8ecd3f7347f9e450510c766229649bd3",
"sales": 0,
"stock": 0,
"weight": 3.0,
"width": 0.0,
"length": 1014.0,
"height": 0.0,
"manufacturerId": "385705f0da5a4d21ad2289eb3c1d9fb9",
"manufacturerNumber": "010146",
"releaseDate": null,
"createdAt": "2017-01-01T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"12298808f73a4bf781a9dcc9b2800801",
"cbbb14c819094376b33f3700d8787ff7",
"9b8e4f834b9a49cda9cbb3d54df4a27d"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "12298808f73a4bf781a9dcc9b2800801",
"_count": 1
},
{
"id": "cbbb14c819094376b33f3700d8787ff7",
"_count": 1
},
{
"id": "9b8e4f834b9a49cda9cbb3d54df4a27d",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": "6ab234ed950044d4a2d2e068c80ab8df",
"coverId": "7d4739f302d54eaa97c47436bad9d537",
"childCount": 0,
"categories": [
{
"id": "9b8e4f834b9a49cda9cbb3d54df4a27d",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Protecci\u00f3n t\u00e9rmica turbo",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Turbo-Hitzeschutz",
"5494b24b09d445ebace47112836b4458": "Turbo protection contre la chaleur",
"de44571ddc4e4d0095c01af6ee299351": "Turbo Heat Protection"
}
}
],
"manufacturer": {
"id": "385705f0da5a4d21ad2289eb3c1d9fb9",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "DEI",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "DEI"
},
"_count": 1
},
"properties": [],
"options": [
{
"id": "f9a1c125d12f4f2fbd43f496f8a371a1",
"_count": 1,
"groupId": "335273dd163e4d09bb3ca3cdff219a87",
"group": {
"id": "335273dd163e4d09bb3ca3cdff219a87",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "T6",
"5494b24b09d445ebace47112836b4458": "T6",
"de44571ddc4e4d0095c01af6ee299351": "T6"
}
}
],
"categoryIds": [
"9b8e4f834b9a49cda9cbb3d54df4a27d"
],
"optionIds": [
"f9a1c125d12f4f2fbd43f496f8a371a1"
],
"propertyIds": [],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"fts_product_video_1": "https:\/\/www.youtube.com\/watch?v=PxvqGLmd9ow",
"fts_product_video_1_title": "Titan - Alles was du wissen musst",
"fts_product_video_1_description": "Heute dreht sich alles um Titan! Was genau zeichnet Titan aus und was sind die Vorteile einer Titannietrierten Beschichtung? Worauf muss man bei der Montage achten? Und warum solltest du die Beschichtung nicht mit blanken Fingern anfassen? Wie kann man Titandestillat am Motor anwenden? Diese und weitere wichtige Fragen beantwortet euch Bartek in diesem Video! Was m\u00f6chtet ihr als n\u00e4chstes sehen, was interessiert euch besonders? Schreibt es in die Kommentare! Hier geht\u2019s zu den Produkten im Video: https:\/\/www.bar-tek-tuning.de\/h-schaft-pleuel-titannitriert-2-0-l-tsi-ea888 https:\/\/www.bar-tek-tuning.de\/2-0l-tfsi-ventilfedern-satz-titan https:\/\/www.bar-tek-tuning.de\/titan-destillat-150-ml Stay tuned! Ihr habt Fragen?! @: info@bar-tek.de Folgt uns unbedingt auch auf unseren Social-Media-Kan\u00e4len! Ihr findet uns auch auf Facebook: https:\/\/de-de.facebook.com\/BARTEK.Motorsport Checkt jetzt unseren Instagram Kanal aus: https:\/\/www.instagram.com\/bartekmotorsport\/?hl=de Nutzt auch unsere eigenen GIPHYs: https:\/\/giphy.com\/BAR-TEK_Motorsport #titan #titannietriert #titandestillat",
"fts_product_video_1_upload_date": "2021-02-14 17:30:01.000",
"migration_Shopware5DB_product_attr14": "908",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_socialfeed": false,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_url": "titan-turbo-schild-einzeln",
"migration_Shopware5DB_product_dreisc_seo_title": "Titan Turbo-Schild - einzeln",
"migration_Shopware5DB_product_onco_universal_article": true,
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0"
},
"5494b24b09d445ebace47112836b4458": {
"fts_product_video_1": "https:\/\/www.youtube.com\/watch?v=PxvqGLmd9ow&t=146s",
"fts_product_video_1_title": "Titan - Alles was du wissen musst",
"migration_Shopware5DB_product_attr14": "908",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_title": "Titan Turbo-Schild - einzeln",
"migration_Shopware5DB_product_onco_universal_article": true
},
"de44571ddc4e4d0095c01af6ee299351": {
"fts_product_video_1": "https:\/\/www.youtube.com\/watch?v=PxvqGLmd9ow",
"fts_product_video_2": "https:\/\/www.youtube.com\/watch?v=Mdqafk-mLxk",
"fts_product_video_1_title": "Titan - All you need to know",
"fts_product_video_2_title": "Titanium - Everything you need to know! ",
"migration_Shopware5DB_product_attr14": "908",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_socialfeed": false,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_url": " ",
"migration_Shopware5DB_product_dreisc_seo_title": "Titan turbo shield",
"migration_Shopware5DB_product_onco_universal_article": true,
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0"
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Titan Turbo-Schild - einzeln",
"5494b24b09d445ebace47112836b4458": "Titan Turbo Shield - simple",
"de44571ddc4e4d0095c01af6ee299351": "Titanium Turbo Shield"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ma\u00dfgeschneidertes Titan Turbo Schild (Turbopampers). Ultimatives Mittel zur Reduzierung des Turbolochs. Abschirmung und Schutz aller Motorkomponenten. Aus pulverisiertem Vulkangestein hergestellt, mit Silizium F\u00fcllmaterial. Extremer Schutz gegen vom Turboladererzeugte Hitze. Mit integrierten Verankerungshaken zur Sicherung. Im Carbon-Faser Design. Ma\u00dfe der verschiedenen Modelle: T25\/T28 - Au\u00dfenumfang: 48,0 cm - Innenabstand: 6,35 cm T3 - Au\u00dfenumfang: 48,3 cm - Innenabstand: ca. 6,35 cm T4 - Au\u00dfenumfang: 56,0 cm - Innenabstand: ca. 7 cm T6 - Au\u00dfenumfang: 66,0 cm - Innenabstand: ca. 9,5 cm Sicherheitshinweise: Prinzipiell nicht brennbar, au\u00dfer nat\u00fcrlich wenn brennbare Fl\u00fcssigkeiten eingebracht werden. Wir bitten Sie, alle entsprechenden Vorkehrungen zu treffen, um sicherzustellen, dass alle Fl\u00fcssigkeits-Armaturen in technisch einwandfreiem Zustand, versiegelt und dicht sind. Das Schild ist nicht darauf ausgelegt entfernt zu werden, nachdem es mehrfach erhitzt wurde. Durch mehrfaches Erhitzen verlieren die Fasern ihre anf\u00e4ngliche Flexibilit\u00e4t. Dadurch verringern sich nicht die thermischen Eigenschaften.",
"5494b24b09d445ebace47112836b4458": "Bouclier turbo en titane sur mesure (turbopampers). Le moyen ultime de r\u00e9duire le d\u00e9calage du turbo. Blindage et protection de tous les composants du moteur. Fait de poudre de roche volcanique, avec un mat\u00e9riau de remplissage en silicium. Protection extr\u00eame contre la chaleur g\u00e9n\u00e9r\u00e9e par le turbocompresseur. Avec des crochets d'ancrage int\u00e9gr\u00e9s pour la s\u00e9curit\u00e9. En fibre de carbone. Dimensions des diff\u00e9rents mod\u00e8les : T25\/T28 - circonf\u00e9rence ext\u00e9rieure : 48,0 cm - distance int\u00e9rieure : 6,35 cm T3 - circonf\u00e9rence ext\u00e9rieure : 48,3 cm - distance int\u00e9rieure : environ 6,35 cm T4 - circonf\u00e9rence ext\u00e9rieure : 56,0 cm - distance int\u00e9rieure : environ 7 cm T6 - circonf\u00e9rence ext\u00e9rieure : 66,0 cm - distance int\u00e9rieure : environ 9,5 cm Consignes de s\u00e9curit\u00e9 : En principe non inflammable, sauf bien s\u00fbr lorsque des liquides inflammables sont utilis\u00e9s. Nous vous demandons de prendre toutes les pr\u00e9cautions n\u00e9cessaires pour garantir que tous les raccords de liquide sont en parfait \u00e9tat technique, scell\u00e9s et \u00e9tanches. L'\u00e9tiquette n'est pas con\u00e7ue pour \u00eatre retir\u00e9e apr\u00e8s avoir \u00e9t\u00e9 chauff\u00e9e plusieurs fois. Les chauffages r\u00e9p\u00e9t\u00e9s font perdre aux fibres leur souplesse initiale. Cela ne r\u00e9duit pas les propri\u00e9t\u00e9s thermiques.",
"de44571ddc4e4d0095c01af6ee299351": "Tailor-made titanium turbo shields. The ultimate mean for reduction of the turbo lag. Shielding and protection of all engine components. Made of pulverized volcanic rock and produced with silica padding. Protection against extreme heat generated by the turbocharger.With integrated anchoring hook for backup. Carbon-fiber design. Dimensions of the different models: T3 - the outer circumference: 48.3 cm - inner distance: 6.35 cm T4 - the outer circumference: 55.9 cm - inner distance: 7 cm T6 - the outer circumference: 66 cm - inner distance: 9.5 cm T25\/T28 - outer circumference: 48.3 - inner distance: 6.35 cm Safety instructions: Non-combustible, except of course when flammable liquids are incorporated. We want you to take all appropriate arrangements to ensure that all liquid fittings are in perfect condition, sealed and leak free. The shield is not designed to be removed after it was heated several times. The fibers lose their initial flexibility.This does not reduce the thermal properties."
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Titan Turbo-Schild - einzeln",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Titan turbo shield"
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Titan turbo shield (turbopumpers) made of powdered volcanic rock.✓ 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": 407.99,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 342.85,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 455.95,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 383.15,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 431.97,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 363,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 499.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 420.12605042017,
"shop-customer": "420.12605042017",
"a-dealer": "342.85",
"c-dealer": "383.15",
"b-dealer": "363"
},
"fields": {
"displayGroup": [
"8ecd3f7347f9e450510c766229649bd3"
]
},
"sort": [
"",
0,
"80bf0ce8c1894d9ead4ccfff03945a98"
]
}
]
},
"aggregations": {
"total-count": {
"value": 3
}
}
}
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":"9b8e4f834b9a49cda9cbb3d54df4a27d"}}}},{"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": "9b8e4f834b9a49cda9cbb3d54df4a27d"
}
}
}
},
{
"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
|