| 1 |
4.35 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":"953e43f391744d899b07c16bb6a60b37"}}}},{"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": 1,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw6_stage__product_1742425202",
"_id": "19e1f51dba5c4a949fdc4711da399f22",
"_score": null,
"_source": {
"id": "19e1f51dba5c4a949fdc4711da399f22",
"autoIncrement": 45747.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 0,
"productNumber": "21toyo011",
"ean": null,
"displayGroup": "e80ad02495f702cc829f2591b0eb0957",
"sales": 0,
"stock": 0,
"weight": 30.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "7aada85606b14278bf734c0cb6717c3d",
"manufacturerNumber": "11001-KT001",
"releaseDate": null,
"createdAt": "2022-01-25T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"87c86b255c784be7b2eebacd4ca87422",
"312289b38a494dd182913c1eb5e0bc65",
"953e43f391744d899b07c16bb6a60b37"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "87c86b255c784be7b2eebacd4ca87422",
"_count": 1
},
{
"id": "312289b38a494dd182913c1eb5e0bc65",
"_count": 1
},
{
"id": "953e43f391744d899b07c16bb6a60b37",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": null,
"coverId": "8149ad09f77a42d584efc761855ab84d",
"childCount": 0,
"categories": [
{
"id": "953e43f391744d899b07c16bb6a60b37",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "GT86 Y BRZ",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "GT86 & BRZ",
"5494b24b09d445ebace47112836b4458": "GT86 & BRZ"
}
}
],
"manufacturer": {
"id": "7aada85606b14278bf734c0cb6717c3d",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "HKS",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "HKS"
},
"_count": 1
},
"properties": [
{
"id": "217c8692abf1447dba2bb5c38dfdf511",
"_count": 1,
"groupId": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"group": {
"id": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Subaru",
"5494b24b09d445ebace47112836b4458": "Subaru",
"de44571ddc4e4d0095c01af6ee299351": "Subaru"
}
},
{
"id": "28b1f290b5234edf95f5127e4b8d10ca",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BRZ",
"5494b24b09d445ebace47112836b4458": "BRZ",
"de44571ddc4e4d0095c01af6ee299351": "BRZ"
}
},
{
"id": "350113e5e68f40488d8c1b11bb33db3e",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "GT86",
"5494b24b09d445ebace47112836b4458": "GT86",
"de44571ddc4e4d0095c01af6ee299351": "GT86"
}
},
{
"id": "9d55e0fcb7a5411695222e1f90fe7451",
"_count": 1,
"groupId": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"group": {
"id": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Toyota",
"5494b24b09d445ebace47112836b4458": "Toyota",
"de44571ddc4e4d0095c01af6ee299351": "Toyota"
}
},
{
"id": "9e34607d10a3443cbc108690fff811d7",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "FA20D | 200 PS (147 kW)",
"5494b24b09d445ebace47112836b4458": "FA20D | 200 ch (147 kW)",
"de44571ddc4e4d0095c01af6ee299351": " FA20D | 200 hp (147 kW)"
}
},
{
"id": "d2a19b0530e14bebb35228e6f8c65f01",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "ZN6 | BJ 2012-2020",
"5494b24b09d445ebace47112836b4458": "ZN6 | BJ 2012-2020",
"de44571ddc4e4d0095c01af6ee299351": "ZN6 | Year built 2012-2020"
}
},
{
"id": "d858bb63d85b437f9aa3ec900671e5cc",
"_count": 1,
"groupId": "22a715b71ff441609b1deade031b2578",
"group": {
"id": "22a715b71ff441609b1deade031b2578",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.0 Boxer",
"de44571ddc4e4d0095c01af6ee299351": "2.0 Boxer",
"5494b24b09d445ebace47112836b4458": "2.0 boxeur"
}
}
],
"options": [],
"categoryIds": [
"953e43f391744d899b07c16bb6a60b37"
],
"optionIds": [],
"propertyIds": [
"217c8692abf1447dba2bb5c38dfdf511",
"28b1f290b5234edf95f5127e4b8d10ca",
"350113e5e68f40488d8c1b11bb33db3e",
"9d55e0fcb7a5411695222e1f90fe7451",
"9e34607d10a3443cbc108690fff811d7",
"d2a19b0530e14bebb35228e6f8c65f01",
"d858bb63d85b437f9aa3ec900671e5cc"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "HKS Turbo Kit",
"migration_Shopware5DB_product_bullet1": "Bolt On Turbo Kit bis 450 PS",
"migration_Shopware5DB_product_bullet2": "Toyoto GT86 & Subaru BRZ ",
"migration_Shopware5DB_product_bullet3": "HKS GTIII RS Turbolader",
"migration_Shopware5DB_product_bullet4": "Plug and Play",
"migration_Shopware5DB_product_socialfeed": false,
"migration_Shopware5DB_product_dreisc_seo_url": "toyoto-gt86-subaru-brz-bolt-on-turbo-kit-bis-450ps",
"migration_Shopware5DB_product_dreisc_seo_title": "Toyoto GT86 & Subaru BRZ HKS GTIII RS Bolt On Turbo Kit bis 450 PS",
"migration_Shopware5DB_product_onco_universal_article": false
},
"5494b24b09d445ebace47112836b4458": {
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "HKS Turbo Kit",
"migration_Shopware5DB_product_bullet1": "Bolt On Turbo Kit bis 450 PS",
"migration_Shopware5DB_product_bullet2": "Toyoto GT86 & Subaru BRZ ",
"migration_Shopware5DB_product_bullet3": "HKS GTIII RS Turbolader",
"migration_Shopware5DB_product_bullet4": "Plug and Play",
"migration_Shopware5DB_product_socialfeed": false,
"migration_Shopware5DB_product_dreisc_seo_title": "Toyoto GT86 & Subaru BRZ HKS GTIII RS Bolt On Turbo Kit bis 450 PS",
"migration_Shopware5DB_product_onco_universal_article": false
},
"de44571ddc4e4d0095c01af6ee299351": {
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "HKS Turbo Kit",
"migration_Shopware5DB_product_bullet1": "Bolt On Turbo Kit up to 450 HP",
"migration_Shopware5DB_product_bullet2": "Toyoto GT86 & Subaru BRZ",
"migration_Shopware5DB_product_bullet3": "HKS GTIII RS turbocharger",
"migration_Shopware5DB_product_bullet4": "Plug and Play",
"migration_Shopware5DB_product_socialfeed": false,
"migration_Shopware5DB_product_dreisc_seo_url": "toyoto-gt86-subaru-brz-bolt-on-turbo-kit-up-to-450ps",
"migration_Shopware5DB_product_dreisc_seo_title": "Toyoto GT86 & Subaru BRZ HKS GTIII RS Bolt On Turbo Kit bis 450 PS",
"migration_Shopware5DB_product_onco_universal_article": false
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Toyoto GT86 & Subaru BRZ HKS GTIII RS Bolt On Turbo Kit bis 450 PS",
"5494b24b09d445ebace47112836b4458": "Toyoto GT86 & Subaru BRZ HKS GTIII RS Bolt On Turbo Kit jusqu'\u00e0 450 ch",
"de44571ddc4e4d0095c01af6ee299351": "Toyoto GT86 & Subaru BRZ HKS GTIII RS Bolt On Turbo Kit up to 450 HP"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Leider rollen die Toyota GT86 und Subaru BRZ mit \"nur\u201d 200 PS vom Band. Es ist zwar mehr als genug f\u00fcr das t\u00e4gliche Fahren und f\u00fcr kurvige Nebenstra\u00dfen, aber tief im Inneren w\u00fcnscht man sich, man h\u00e4tte ein bisschen mehr Leistung zum Spielen, wenn man sich an das Auto gew\u00f6hnt hat. Die Jungs von HKS haben sich zur Aufgabe gemacht, deinem Wunsch nachzukommen. Bis zu 350 PS sind hier Plug and Play m\u00f6glich. Durch ein verbessertes Kraftstoffsystem und einem gemachten Motor sind auch 450 PS realisierbar.\nDas Kit verwendet die neuesten MHI-Turbos f\u00fcr h\u00f6chste Effizienz. Die Geh\u00e4use werden von HKS f\u00fcr hohe Zuverl\u00e4ssigkeit und Langlebigkeit bearbeitet.\nFeatures:\n\nTurbolader: HKS GTIII-RS, ideal f\u00fcr 2.0L Motoren. Erzeugt bis zu 450 PS bei modifizierten Motoren. 65-mm-Kompressor, 56-mm-Turbine, 0.80 A\/R\nAbgaskr\u00fcmmer: 4-in-1-Design. F\u00fcr bessere Festigkeit von innen verschwei\u00dft. Isolator f\u00fcr Hitzeschutz.\nAuspuffdesign: Spiralflex-Pipe erleichtert die Installation und ist dennoch stabil\nLadeluftk\u00fchler: 390 x 270 x 100mm Netz\nOriginal Subaru MAF Sensor\n3 Bar MAP-Sensor\n440cc Einspritzd\u00fcsen\n\nDas Kit beinhaltet\nGT III-RS Turbolader mit Druckdose\u00d6l- und WasserleitungenLuftfilterAnsaugrohrVorn montierter Ladeluftk\u00fchlerLadeluftverrohrungAbgaskr\u00fcmmerKat ErsatzrohrIsolatorabdeckungIsolatorfolieDichtungen, Halterungen, Schrauben usw.",
"5494b24b09d445ebace47112836b4458": "Malheureusement, les Toyota GT86 et Subaru BRZ sortent de la cha\u00eene de production avec \"seulement\" 200 ch ont. C'est certes plus que suffisant pour la conduite quotidienne et les petites routes sinueuses, mais au fond de soi, on aimerait avoir un peu plus de puissance pour jouer, une fois que l'on s'est habitu\u00e9 \u00e0 la voiture. Les gars de HKS se sont donn\u00e9 pour mission de r\u00e9pondre \u00e0 ton souhait. Jusqu'\u00e0 350 ch sont ici possibles Plug and Play. Gr\u00e2ce \u00e0 un syst\u00e8me de carburant am\u00e9lior\u00e9 et un moteur modifi\u00e9, 450 ch sont \u00e9galement r\u00e9alisables.\nLe kit utilise les derniers turbos MHI pour une efficacit\u00e9 maximale. Les bo\u00eetiers sont usin\u00e9s par HKS pour une grande fiabilit\u00e9 et une longue dur\u00e9e de vie.\nCaract\u00e9ristiques :\n\nTurbocompresseur : HKS GTIII-RS, id\u00e9al pour les moteurs 2.0L. G\u00e9n\u00e8re jusqu'\u00e0 450 ch sur les moteurs modifi\u00e9s. compresseur de 65 mm, turbine de 56 mm, 0,80 A\/R\nCollecteur d'\u00e9chappement : conception 4 en 1. Soud\u00e9 de l'int\u00e9rieur pour une meilleure r\u00e9sistance. Isolateur pour protection thermique\nConception de l'\u00e9chappement : tuyau flexible en spirale facilitant l'installation tout en restant stable\nRefroidisseur interm\u00e9diaire: 390 x 270 x 100mm R\u00e9seau\nCapteur MAF d'origine Subaru\ncapteur MAP 3 bars\ninjecteurs de 440cc\n\nLe kit comprend\nTurbocompresseur GT III-RS avec bo\u00eete de pression. Conduites d'huile et d'eauFiltre \u00e0 airtuyau d'admission refroidisseur interm\u00e9diaire mont\u00e9 \u00e0 l'avantTuyauterie d'air de suralimentationCollecteur d'\u00e9chappementTube catalytique de rechangeCouvercle d'isolateurFilm d'isolateurJoints, supports, Vis, etc.",
"de44571ddc4e4d0095c01af6ee299351": "Bolt On Turbo Kit for Toyoto GT86 & Subaru BRZ\nUnfortunately, the Toyota GT86 and Subaru BRZ roll off the line with \"only\" 200 HP. It's more than enough for daily driving and winding back roads, but deep down you wish you had a little more power to play with once you get used to the car. The guys at HKS have made it their mission to grant your wish. Up to 350 HP is plug and play here. With an improved fuel system and a made engine, 450 HP is also achievable.\nThe kit uses the latest MHI turbos for highest efficiency. The cases are machined by HKS for high reliability and durability.\nFeatures:\n\nTurbocharger: HKS GTIII-RS, ideal for 2.0L engines. Produces up to 450 HP on modified engines. 65mm compressor, 56mm turbine, 0.80 A\/R\nExhaust manifold: 4-in-1 design. Welded from inside for better strength. Insulator for heat protection\nExhaust design: spiral flex pipe makes installation easier while still being strong\nIntercooler: 390 x 270 x 100mm mesh\nOriginal Subaru MAF Sensor\n3 Bar MAP Sensor\n440cc injectors\n\nThe kit includes:\nGT III-RS turbocharger with pressure can Oil and water linesAir filterintake pipe Front mounted intercooler Charge air pipingExhaust manifoldCat replacement pipeInsulator coverInsulator wrapGaskets, brackets, bolts, etc."
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Toyoto GT86 & Subaru BRZ HKS GTIII RS Bolt On Turbo Kit bis 450 PS ",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Toyoto GT86 & Subaru BRZ HKS GTIII RS Bolt On Turbo Kit up to 450 HP"
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Bolt On Turbo Kit f\u00fcr Toyoto GT86 & Subaru von HKS \u27a4 Plug & Play \u2714 Leistung bis zu 450 PS \u2714 perfekt abgestimmtes Set! Hol dir jetzt dein Kit \u270c",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Bolt On Turbo Kit for Toyoto GT86 & Subaru by HKS \u27a4 Plug & Play \u2714 Performance up to 450 HP \u2714 perfectly tuned kit! Get yours now \u270c"
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 6346.67,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 5333.3333333333,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 6346.67,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 5333.3333333333,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 6346.67,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 5333.3333333333,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 8910.99,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 7488.2268907563,
"shop-customer": "7488.2268907563",
"b-dealer": "5333.3333333333",
"c-dealer": "5333.3333333333",
"a-dealer": "5333.3333333333"
},
"fields": {
"displayGroup": [
"e80ad02495f702cc829f2591b0eb0957"
]
},
"sort": [
"",
0,
"19e1f51dba5c4a949fdc4711da399f22"
]
}
]
},
"aggregations": {
"total-count": {
"value": 1
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
5.98 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":"953e43f391744d899b07c16bb6a60b37"}}}},{"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": "953e43f391744d899b07c16bb6a60b37"
}
}
}
},
{
"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
|