| 1 |
4.22 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":"956bbc3deaa64e798f3b474ea6e4f090"}}}},{"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": 4,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw6_stage__product_1742425202",
"_id": "1220552c43e24856a1b38a49571fab96",
"_score": null,
"_source": {
"id": "1220552c43e24856a1b38a49571fab96",
"autoIncrement": 52690.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 1000,
"productNumber": "21rs360.1",
"ean": "4260630974317",
"displayGroup": "1c27835c89ba3ff368b1b97b821b0f5c",
"sales": 0,
"stock": 1000,
"weight": 0.001,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "e8c1a2f622aa4c319cb4b82536ef0dca",
"manufacturerNumber": null,
"releaseDate": null,
"createdAt": "2017-01-01T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"eb27df81065f4f6fa3fc825e4a49bdd6",
"4f325ac5501a40fa98f239034ed2f949",
"c2ae32cf01d64b04a20f1145ab12aea3",
"956bbc3deaa64e798f3b474ea6e4f090"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "eb27df81065f4f6fa3fc825e4a49bdd6",
"_count": 1
},
{
"id": "4f325ac5501a40fa98f239034ed2f949",
"_count": 1
},
{
"id": "c2ae32cf01d64b04a20f1145ab12aea3",
"_count": 1
},
{
"id": "956bbc3deaa64e798f3b474ea6e4f090",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": "d8bfb72152584d47bc7f824eae6d4e95",
"coverId": "2002096cec854d69ba5fcb5c84e138ab",
"childCount": 0,
"categories": [
{
"id": "956bbc3deaa64e798f3b474ea6e4f090",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "RS3",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "RS3",
"5494b24b09d445ebace47112836b4458": "RS3",
"de44571ddc4e4d0095c01af6ee299351": "RS3"
}
}
],
"manufacturer": {
"id": "e8c1a2f622aa4c319cb4b82536ef0dca",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": "BAR-TEK\u00ae",
"de44571ddc4e4d0095c01af6ee299351": "BAR-TEK\u00ae"
},
"_count": 1
},
"properties": [
{
"id": "12455be8c09b4186954efa84269c148e",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "8P, 8PA | BJ 2003-2013",
"5494b24b09d445ebace47112836b4458": "8P, 8PA | ANN\u00c9E 2003-2013",
"de44571ddc4e4d0095c01af6ee299351": "8P, 8PA | Year built 2003-2013"
}
},
{
"id": "6a3e5f67305541d6b7b6d0905a19101f",
"_count": 1,
"groupId": "22a715b71ff441609b1deade031b2578",
"group": {
"id": "22a715b71ff441609b1deade031b2578",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.5 TFSI (EA855)",
"5494b24b09d445ebace47112836b4458": "2.5 TFSI (EA855)",
"de44571ddc4e4d0095c01af6ee299351": "2.5 TFSI (EA855)"
}
},
{
"id": "6ad29fa6f1e6438cb5e0fc6053de7053",
"_count": 1,
"groupId": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"group": {
"id": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Audi",
"5494b24b09d445ebace47112836b4458": "Audi",
"de44571ddc4e4d0095c01af6ee299351": "Audi"
}
},
{
"id": "98810049b2d24ea988a77bbe0ff1cb08",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "A3 \/ S3 \/ RS3",
"5494b24b09d445ebace47112836b4458": "A3 \/ S3 \/ RS3",
"de44571ddc4e4d0095c01af6ee299351": "A3 \/ S3 \/ RS3"
}
},
{
"id": "a1bea52c47894809a1dabe0a5e930ede",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "TT \/ TTS \/ TT RS",
"5494b24b09d445ebace47112836b4458": "TT \/ TTS \/ TT RS",
"de44571ddc4e4d0095c01af6ee299351": "TT \/ TTS \/ TT RS"
}
},
{
"id": "c125587add124df28d9591814094a214",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "8J | BJ 2006-2014",
"5494b24b09d445ebace47112836b4458": "8J | ANN\u00c9E 2006-2014",
"de44571ddc4e4d0095c01af6ee299351": "8J | Year built 2006-2014"
}
},
{
"id": "c16cf20191c4476d8135e30a88cc5d68",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "CEPA | 340 PS (250 kW)",
"5494b24b09d445ebace47112836b4458": "CEPA | 340 ch (250 kW)",
"de44571ddc4e4d0095c01af6ee299351": "CEPA | 340 hp (250 kW)"
}
}
],
"options": [
{
"id": "ee9eadd10cd64893b44da556086fe925",
"_count": 1,
"groupId": "08c38d44024442a2a3a55906cd8f69b5",
"group": {
"id": "08c38d44024442a2a3a55906cd8f69b5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Chiptuning V2",
"5494b24b09d445ebace47112836b4458": "Chiptuning V2",
"de44571ddc4e4d0095c01af6ee299351": "Chiptuning V2"
}
}
],
"categoryIds": [
"956bbc3deaa64e798f3b474ea6e4f090"
],
"optionIds": [
"ee9eadd10cd64893b44da556086fe925"
],
"propertyIds": [
"12455be8c09b4186954efa84269c148e",
"6a3e5f67305541d6b7b6d0905a19101f",
"6ad29fa6f1e6438cb5e0fc6053de7053",
"98810049b2d24ea988a77bbe0ff1cb08",
"a1bea52c47894809a1dabe0a5e930ede",
"c125587add124df28d9591814094a214",
"c16cf20191c4476d8135e30a88cc5d68"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2f37bfd0f23f482bad9d34a02199499b": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_title": "Audi RS3 8P 2.5L TFSI 340PS Chiptuning BAR-TEK\u00ae",
"migration_Shopware5DB_product_onco_universal_article": false
},
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "BAR-TEK\u00ae Chiptuning",
"migration_Shopware5DB_product_bullet1": "Bis zu 550 PS!",
"migration_Shopware5DB_product_bullet2": "Bis zu 675 Nm!",
"migration_Shopware5DB_product_bullet3": "Optimale Leistung",
"migration_Shopware5DB_product_bullet4": "Optimale Haltbarkeit",
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_made_in_germany": true,
"migration_Shopware5DB_product_dreisc_seo_url": "audi-rs3-8p-25l-tfsi-340ps-chiptuning",
"migration_Shopware5DB_product_dreisc_seo_title": "Audi RS3 8P 2.5L TFSI 340PS Chiptuning BAR-TEK\u00ae",
"migration_Shopware5DB_product_onco_universal_article": false
},
"5494b24b09d445ebace47112836b4458": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "BAR-TEK\u00ae Chiptuning",
"migration_Shopware5DB_product_bullet1": "Bis zu 550 PS!",
"migration_Shopware5DB_product_bullet2": "Bis zu 675 Nm!",
"migration_Shopware5DB_product_bullet3": "Optimale Leistung",
"migration_Shopware5DB_product_bullet4": "Optimale Haltbarkeit",
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_title": "Audi RS3 8P 2.5L TFSI 340PS Chiptuning BAR-TEK\u00ae",
"migration_Shopware5DB_product_onco_universal_article": false
},
"de44571ddc4e4d0095c01af6ee299351": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "BAR-TEK\u00ae Chiptuning",
"migration_Shopware5DB_product_bullet1": "Up to 550 hp!",
"migration_Shopware5DB_product_bullet2": "Up to 675 Nm!",
"migration_Shopware5DB_product_bullet3": "Optimal performance",
"migration_Shopware5DB_product_bullet4": "Optimum durability",
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_title": "Chiptuning to 380 up to 550 HP in Audi 2.5L TFSI RS3 8P",
"migration_Shopware5DB_product_onco_universal_article": false,
"migration_Shopware5DB_product_dreisc_seo_url": "chiptuning-bar-tek-audi-rs3-8p"
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.5L TFSI Audi RS3 8P 340 PS Chiptuning BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": "2.5L TFSI Audi RS3 8P 340 ch Chiptuning BAR-TEK\u00ae",
"de44571ddc4e4d0095c01af6ee299351": "2.5L TFSI Audi RS3 8P 340 HP Chiptuning BAR-TEK\u00ae"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BAR-TEK\u00ae Chiptuning f\u00fcr den Audi RS3 8P 2.5L TFSI mit 340 PS Motor.\nBei der Abstimmung haben wir das Augenmerk auf optimale Leistung in Verbindung mit Haltbarkeit gelegt.\nBitte w\u00e4hle zwischen folgenden Konfigurationen:\nChiptuning V1:\n\nHardware Serie\nca. 40 PS Mehrleistung (auf ca. 380 PS)\nca. 50 Nm mehr Drehmoment (auf ca. 500 Nm Drehmoment)\nDrehmomentbegrenzung im DSG angehoben\nV-Max aufgehoben\n\nChiptuning V2:\n\nHardware Serie\nca. 65 PS Mehrleistung (auf ca. 405 PS)\nca. 100 Nm mehr Drehmoment (auf ca. 550 Nm Drehmoment)\nDrehmomentbegrenzung im DSG angehoben\nV-Max aufgehoben\nNur f\u00fcr mindestens 100 Oktan Kraftstoff\nWir empfehlen unsere NGK Race Z\u00fcndkerzen\n\nChiptuning V3:\n\nF\u00fcr Downpipe & Abgasanlage (wie unsere 4\" Downpipe mit Milltek Abgasanlage)\nca. 85 PS Mehrleistung (auf ca. 425 PS)\nca. 130 Nm mehr Drehmoment (auf ca. 580 Nm Drehmoment)\nDrehmomentbegrenzung im DSG angehoben\nV-Max aufgehoben\nNur f\u00fcr mindestens 100 Oktan Kraftstoff\nWir empfehlen unsere NGK Race Z\u00fcndkerzen\n\nChiptuning V4:\n\nF\u00fcr Downpipe & Abgasanlage (wie unsere 4\" Downpipe mit Milltek Abgasanlage)\nca. 216 PS Mehrleistung (auf ca. 556 PS)\nca. 225 Nm mehr Drehmoment (auf ca. 675 Nm Drehmoment)\nDrehmomentbegrenzung im DSG angehoben\nV-Max aufgehoben\nNur f\u00fcr mindestens 100 Oktan Kraftstoff\nWir empfehlen unsere NGK Race Z\u00fcndkerzen\nUpgrade Turbolader, Upgrade Hochdruckpumpe m\u00fcssen verbaut sein\n\nSteuerger\u00e4t muss nach dem Kauf an uns versendet werden, oder Abstimmung bei uns vor Ort.\nAndere Konfigurationen gerne auf Anfrage.",
"5494b24b09d445ebace47112836b4458": "BAR-TEK\u00ae Chiptuning pour l'Audi RS3 8P 2.5L TFSI avec moteur 340 ch.\nLors de la mise au point, nous nous sommes concentr\u00e9s sur les performances optimales combin\u00e9es \u00e0 la durabilit\u00e9.\nVeuillez choisir entre les configurations suivantes :\nChiptuning V1 :\n\nS\u00e9rie Mat\u00e9riel\nenv. 40 ch plus de puissance (jusqu'\u00e0 env. 380 ch)\nenv. 50 Nm de couple en plus (jusqu'\u00e0 env. 500 Nm de couple)\nLimitation du couple dans la bo\u00eete DSG\nV-Max soulev\u00e9\n\nChiptuning V2 :\n\nS\u00e9rie de mat\u00e9riel\nenv. 65 ch plus de puissance (jusqu'\u00e0 env. 405 PS)\nenv. 100 Nm de couple en plus (jusqu'\u00e0 env. 550 Nm de couple)\nLimitation du couple dans la bo\u00eete DSG\nV-Max soulev\u00e9\nSeulement pour un carburant d'au moins 100 octanes\nNous recommandons nos bougies d'allumage NGK Race\n\nChiptuning V3 :\n\nPour Downpipe et syst\u00e8me d'\u00e9chappement (comme notre 4\" Downpipe avec syst\u00e8me d'\u00e9chappement Milltek)\nenv. 85 ch plus de puissance (jusqu'\u00e0 env. 425 ch)\nenv. 130 Nm de couple en plus (jusqu'\u00e0 env. 580 Nm de couple)\nLimitation du couple dans la bo\u00eete DSG\nV-Max soulev\u00e9\nSeulement pour un carburant d'au moins 100 octanes\nNous recommandons nos bougies d'allumage NGK Race\n\nChiptuning V4 :\n\nPour Downpipe et syst\u00e8me d'\u00e9chappement (comme notre 4\" Downpipe avec syst\u00e8me d'\u00e9chappement Milltek)\nenv. 216 ch plus de puissance (jusqu'\u00e0 env. 556 ch)\nenv. 225 Nm de couple en plus (jusqu'\u00e0 env. 675 Nm de couple)\nLimitation du couple dans la bo\u00eete DSG\nV-Max soulev\u00e9\nSeulement pour un carburant d'au moins 100 octanes\nNous recommandons nos bougies d'allumage NGK Race\nMise \u00e0 niveau turbocompresseur, mise \u00e0 niveau pompe haute pression doit \u00eatre install\u00e9e\n\nL'ECU doit nous \u00eatre exp\u00e9di\u00e9 apr\u00e8s l'achat, ou \u00eatre r\u00e9gl\u00e9 dans nos locaux.\nD'autres configurations sont disponibles sur demande.",
"de44571ddc4e4d0095c01af6ee299351": "BAR-TEK\u00ae Chiptuning for the Audi RS3 8P 2.5L TFSI with 340 HP engine.\nWhen tuning, we focused on optimal performance combined with durability.\nPlease choose between the following configurations:\nChiptuning V1:\n\nHardware Series\napprox. 40 HP more power (to approx. 380 hp)\napprox. 50 Nm more torque (to approx. 500 Nm torque)\nTorque limitation in DSG raised\nV-Max lifted\n\nChiptuning V2:\n\nHardware series\napprox. 65 HP more power (to approx. 405 PS)\napprox. 100 Nm more torque (to approx. 550 Nm torque)\nTorque limitation in DSG raised\nV-Max lifted\nOnly for at least 100 octane fuel\nWe recommend our NGK Race spark plugs\n\nChiptuning V3:\n\nFor Downpipe & exhaust system (like our 4\" Downpipe with Milltek exhaust system)\napprox. 85 HP more power (to approx. 425 hp)\napprox. 130 Nm more torque (to approx. 580 Nm torque)\nTorque limitation in DSG raised\nV-Max lifted\nOnly for at least 100 octane fuel\nWe recommend our NGK Race spark plugs\n\nChiptuning V4:\n\nFor Downpipe & exhaust system (like our 4\" Downpipe with Milltek exhaust system)\napprox. 216 HP more power (to approx. 556 hp)\napprox. 225 Nm more torque (to approx. 675 Nm torque)\nTorque limitation in DSG raised\nV-Max lifted\nOnly for at least 100 octane fuel\nWe recommend our NGK Race spark plugs\nUpgrade turbocharger, upgrade high pressure pump must be installed\n\nECU must be shipped to us after purchase, or tuning at our location.\nOther configurations available upon request."
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Audi RS3 8P 2.5L TFSI 340PS Chiptuning BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Chiptuning to 380 up to 550 HP in Audi 2.5L TFSI RS3 8P"
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Chiptuning Stufe I bis IV - f\u00fcr bis zu 210 PS Mehrleistung! \u2714 25 Jahre Motorsport-Erfahrung \u2714 schneller Versand \u2714 BAR-TEK\u00ae proved \u2794 jetzt kaufen",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Chiptuning stage I to IV - for up to 210 HP more power! \u2714 15 years of motorsport experience \u2714 fast shipping \u2714 BAR-TEK\u00ae proved \u2794 buy now"
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 854.96,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 718.45,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 803.25,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 674.99994,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 850.49304,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 714.7,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 986.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 829.3697,
"shop-customer": "829.3697",
"c-dealer": "718.45",
"a-dealer": "674.99994",
"b-dealer": "714.7"
},
"fields": {
"displayGroup": [
"1c27835c89ba3ff368b1b97b821b0f5c"
]
},
"sort": [
"true",
0,
"1220552c43e24856a1b38a49571fab96"
]
}
]
},
"aggregations": {
"total-count": {
"value": 1
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
4.69 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":"956bbc3deaa64e798f3b474ea6e4f090"}}}},{"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": "956bbc3deaa64e798f3b474ea6e4f090"
}
}
}
},
{
"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
|