| 1 |
3.20 ms |
Request:
{"index":"sw6_stage__product","search_type":"query_then_fetch","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"should":[{"bool":{"must_not":[{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.5494b24b09d445ebace47112836b4458"}},{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.de44571ddc4e4d0095c01af6ee299351"}},{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.2fbb5fe2e29a4d70aa5854ce7ce3e20b"}}]}},{"multi_match":{"query":false,"fields":["customFields.5494b24b09d445ebace47112836b4458.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":"273a0a024d76403d85a656753cb2e316"}}}},{"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":["5494b24b09d445ebace47112836b4458","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": 1,
"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": "201892e6df1649678342fd9656ca450d",
"_score": null,
"_source": {
"id": "201892e6df1649678342fd9656ca450d",
"autoIncrement": 69631.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 0,
"productNumber": "21toyo18",
"ean": null,
"displayGroup": "3bacdd22644371bfdacc79f7214187ad",
"sales": 0,
"stock": 0,
"weight": 25.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "cea36234df5042a19784ce5b8e53f6c6",
"manufacturerNumber": "FMINT25",
"releaseDate": null,
"createdAt": "2022-08-11T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"f220574e2c5b49d3850303e3bb6842cb",
"6624e730057c46eebff1b29d5e7b208b",
"273a0a024d76403d85a656753cb2e316"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "f220574e2c5b49d3850303e3bb6842cb",
"_count": 1
},
{
"id": "6624e730057c46eebff1b29d5e7b208b",
"_count": 1
},
{
"id": "273a0a024d76403d85a656753cb2e316",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": null,
"coverId": "0ecd858fa6fa4979ad4b7bfc4728078d",
"childCount": 0,
"categories": [
{
"id": "273a0a024d76403d85a656753cb2e316",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Toyota",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Toyota",
"5494b24b09d445ebace47112836b4458": "Toyota"
}
}
],
"manufacturer": {
"id": "cea36234df5042a19784ce5b8e53f6c6",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Forge Motorsport",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Forge Motorsport"
},
"_count": 1
},
"properties": [],
"options": [],
"categoryIds": [
"273a0a024d76403d85a656753cb2e316"
],
"optionIds": [],
"propertyIds": [],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "K\u00fchler",
"migration_Shopware5DB_product_bullet1": "K\u00fchlere Luft",
"migration_Shopware5DB_product_bullet2": "L\u00e4ngere Haltbarkeit",
"migration_Shopware5DB_product_bullet3": "H\u00f6here Luftdichte",
"migration_Shopware5DB_product_socialfeed": false,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_url": "forge-ladeluftkuehler-kit-passend-toyota-yaris-gr",
"migration_Shopware5DB_product_dreisc_seo_title": "Forge Ladeluftk\u00fchler Kit passend f\u00fcr Toyota Yaris GR",
"migration_Shopware5DB_product_onco_universal_article": false
},
"5494b24b09d445ebace47112836b4458": {
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "K\u00fchler",
"migration_Shopware5DB_product_bullet1": "K\u00fchlere Luft",
"migration_Shopware5DB_product_bullet2": "L\u00e4ngere Haltbarkeit",
"migration_Shopware5DB_product_bullet3": "H\u00f6here Luftdichte",
"migration_Shopware5DB_product_socialfeed": false,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_title": "Forge Ladeluftk\u00fchler Kit passend f\u00fcr Toyota Yaris GR",
"migration_Shopware5DB_product_onco_universal_article": false
},
"de44571ddc4e4d0095c01af6ee299351": {
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "Cooler",
"migration_Shopware5DB_product_bullet1": "Cooler air",
"migration_Shopware5DB_product_bullet2": "Longer shelf life",
"migration_Shopware5DB_product_bullet3": "Higher air density",
"migration_Shopware5DB_product_socialfeed": false,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_url": "forge-charge-air-cooler-kit-fits-toyota-yaris-gr",
"migration_Shopware5DB_product_dreisc_seo_title": "Forge Ladeluftk\u00fchler Kit passend f\u00fcr Toyota Yaris GR",
"migration_Shopware5DB_product_onco_universal_article": false
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Forge Ladeluftk\u00fchler Kit passend f\u00fcr Toyota Yaris GR",
"5494b24b09d445ebace47112836b4458": "Forge refroidisseur interm\u00e9diaire Kit adaptable sur Toyota Yaris GR",
"de44571ddc4e4d0095c01af6ee299351": "Forge intercooler Kit suitable for Toyota Yaris GR"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "\nNeuster leistungsstarker Ladeluftk\u00fchler von Forge f\u00fcr den Toyota Yaris GR. Made in the UK. W\u00e4hrend des gesamten Entwicklungsprozesses haben wir uns bem\u00fcht, die Effizienz und Leistung des Motors des Yaris GR zu verbessern. Unsere Projektaufgabe bestand darin, einen Ladeluftk\u00fchler zu entwickeln, der den gesamten verf\u00fcgbaren Platz in der urspr\u00fcnglichen Position des OEM-Ladeluftk\u00fchlers nutzt und sicherstellt, dass die Ansauglufttemperatur reduziert wird, ohne negative Auswirkungen auf den Ladedruck oder die Motor- und Getriebek\u00fchlung.\nIm Vergleich zum OEM-Ladeluftk\u00fchler hat der Forge K\u00fchler 42% mehr Oberfl\u00e4che und eine interne Volumenvergr\u00f6\u00dferung von \u00fcber 100 %. Dadurch wurde ein Leistungszuwachs von mehr als 10 PS und 15 Nm erzielt werden. Da die Anschl\u00fcsse am Ladeluftk\u00fchler auf 60 mm vergr\u00f6\u00dfert wurden, haben wir dem Ladeluftk\u00fchler-Kit alle notwendigen Silikonschl\u00e4uche und Hardware beigelegt, um die Installation Plug and Play zu gestalten.\nDer Ladeluftk\u00fchler von Forge Motorsport ist ein perfektes leistungssteigerndes Tuning Teil, das direkt an die OEM-Befestigungspunkte passt und eine einfache Installation in relativ kurzer Zeit erm\u00f6glicht. Es ist kein Schneiden erforderlich, sodass der K\u00fchler jederzeit zur\u00fcck ger\u00fcstet werden kann. Die lebenslange Garantie von Forge Motorsport auf alle Hardware-Produkte zeigt das Vertrauen, das wir in die Qualit\u00e4t unserer Produkte haben.\nFeatures:\n\nBis zu 10 PS und 15 Nm\nBis zu 20\u00b0C niedrigere Ansauglufttemperatur\nReduziertes Turboloch, verbessertes Ansprechverhalten\nGr\u00f6\u00dfere Gesamtoberfl\u00e4che f\u00fcr eine bessere W\u00e4rmeableitung\nGegossene Endst\u00fccke mit hohem Durchfluss gew\u00e4hrleisten einen optimalen Luft\u00fcbergang\nDyno-gepr\u00fcfte PS- und Drehmoment Steigerung\nVolumetrische Steigerung von mehr als 100 %\nLebenslange Garantie\n\n",
"5494b24b09d445ebace47112836b4458": "\nDernier mod\u00e8le performant refroidisseur interm\u00e9diaire de Forge pour la Toyota Yaris GR. Fabriqu\u00e9 au Royaume-Uni. Tout au long du processus de d\u00e9veloppement, nous nous sommes efforc\u00e9s d'am\u00e9liorer l'efficacit\u00e9 et les performances du moteur de la Yaris GR. Notre mission dans le cadre du projet consistait \u00e0 concevoir un refroidisseur interm\u00e9diaire qui utilise tout l'espace disponible dans la position d'origine de l'\u00e9changeur d'air de suralimentation OEM et qui garantit que la temp\u00e9rature de l'air d'admission est r\u00e9duite sans avoir d'impact n\u00e9gatif sur le pression de suralimentation ou sur le refroidissement du moteur et de la transmission.\nPar rapport \u00e0 l'OEMrefroidisseur interm\u00e9diaire, le radiateur Forge a une surface sup\u00e9rieure de 42% et une augmentation de volume interne de plus de 100%. Cela a permis d'obtenir un gain de puissance de plus de 10 ch et 15 Nm. Comme les raccords sur refroidisseur interm\u00e9diaire ont \u00e9t\u00e9 agrandis \u00e0 60 mm, nous avons inclus dans le kit refroidisseur interm\u00e9diaire tous les tuyaux en silicone et le mat\u00e9riel n\u00e9cessaires pour que l'installation soit plug and play.\nLe refroidisseur interm\u00e9diaire de Forge Motorsport est une pi\u00e8ce de tuning parfaite pour am\u00e9liorer les performances, qui s'adapte directement aux points de fixation OEM et permet une installation facile en un temps relativement court. Aucune d\u00e9coupe n'est n\u00e9cessaire, ce qui permet de remettre le radiateur \u00e0 niveau \u00e0 tout moment. La garantie \u00e0 vie de Forge Motorsport sur tous les produits mat\u00e9riels montre la confiance que nous avons dans la qualit\u00e9 de nos produits.\nCaract\u00e9ristiques :\n\nJusqu'\u00e0 10 ch et 15 Nm\nJusqu'\u00e0 20\u00b0C de temp\u00e9rature d'air d'admission en moins\nTrou de turbo r\u00e9duit, r\u00e9ponse am\u00e9lior\u00e9e\nSurface totale plus grande pour une meilleure dissipation de la chaleur\nEmbouts moul\u00e9s \u00e0 haut d\u00e9bit garantissant un transfert d'air optimal\nAugmentation du couple et de la puissance test\u00e9e par Dyno ch\nAugmentation volum\u00e9trique de plus de 100\nGarantie \u00e0 vie\n\n",
"de44571ddc4e4d0095c01af6ee299351": "\nLatest high performance intercooler from Forge for Toyota Yaris GR. Made in the UK. Throughout the development process we have strived to improve the efficiency and performance of the Yaris GR engine. Our project brief was to develop a intercooler that utilized all the available space in the original OEM intercooler position and ensured that intake air temperature was reduced, with no negative impact on the charge pressure or engine and transmission cooling.\nCompared to the OEM-intercooler, the Forge radiator has 42% more surface area and an internal volume increase of over 100%. This has resulted in a power increase of more than 10 HP and 15 Nm. Since the ports on the intercooler have been increased to 60mm, we have included all the necessary silicone tubing and hardware with the intercooler kit to make installation plug and play.\nForge Motorsports' intercooler is a perfect performance tuning part that fits directly to the OEM mounting points and allows for easy installation in a relatively short amount of time. No cutting is required, so the radiator can be retrofitted at any time. Forge Motorsport's lifetime warranty on all hardware products demonstrates the confidence we have in the quality of our products.\nFeatures:\n\nUp to 10 HP and 15 Nm\nUp to 20\u00b0C lower intake air temperature\nReduced turbo lag, improved throttle response\nLarger overall surface area for better heat dissipation\nCast high flow end fittings ensure optimal air transfer\nDyno-tested HP- and torque increase\nVolumetric increase of more than 100\nLifetime warranty\n\n"
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Alles in einem Set: Ladeluftk\u00fchler f\u00fcr deinen Yaris \u2714 Leitungen \u2714 Dicht- und Montagematerial \u2714 Ein Muss f\u00fcr die optimale \u00d6lk\u00fchlung! \u2794 direkt kaufen bei BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "All in one set: intercooler for your Yaris \u2714 lines \u2714 Sealing and mounting material \u2714 A must for optimal oil cooling! \u2794 buy directly from BAR-TEK\u00ae"
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 953.9397,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 801.63,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 988.0094,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 830.26,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 919.87,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 773.0,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1131.1,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 950.50420168067,
"shop-customer": "950.50420168067",
"b-dealer": "801.63",
"c-dealer": "830.26",
"a-dealer": "773.0"
},
"fields": {
"displayGroup": [
"3bacdd22644371bfdacc79f7214187ad"
]
},
"sort": [
"",
0,
"201892e6df1649678342fd9656ca450d"
]
}
]
},
"aggregations": {
"total-count": {
"value": 1
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
3.73 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.5494b24b09d445ebace47112836b4458"}},{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.de44571ddc4e4d0095c01af6ee299351"}},{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.2fbb5fe2e29a4d70aa5854ce7ce3e20b"}}]}},{"multi_match":{"query":false,"fields":["customFields.5494b24b09d445ebace47112836b4458.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":"273a0a024d76403d85a656753cb2e316"}}}},{"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.5494b24b09d445ebace47112836b4458.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.5494b24b09d445ebace47112836b4458.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.5494b24b09d445ebace47112836b4458"
}
},
{
"exists": {
"field": "customFields.migration_Shopware5DB_product_attr17.de44571ddc4e4d0095c01af6ee299351"
}
},
{
"exists": {
"field": "customFields.migration_Shopware5DB_product_attr17.2fbb5fe2e29a4d70aa5854ce7ce3e20b"
}
}
]
}
},
{
"multi_match": {
"query": false,
"fields": [
"customFields.5494b24b09d445ebace47112836b4458.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": "273a0a024d76403d85a656753cb2e316"
}
}
}
},
{
"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.5494b24b09d445ebace47112836b4458.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.5494b24b09d445ebace47112836b4458.migration_Shopware5DB_product_onco_universal_article"
}
}
}
}
},
"size": 0,
"timeout": "5s"
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|