| 1 |
4.38 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":"82ae99d370dd40db9229cea17554f175"}}}},{"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": 8,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw6_stage__product_1742425202",
"_id": "0fc12875ced74ccdb5a97be693a2ba3a",
"_score": null,
"_source": {
"id": "0fc12875ced74ccdb5a97be693a2ba3a",
"autoIncrement": 53526.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 0,
"productNumber": "21sub003.4",
"ean": null,
"displayGroup": "cb8ceffea214f12ddce9b3890da6264d",
"sales": 0,
"stock": 0,
"weight": 0.454,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "1ac4e5de8df54c318331a27442a1a52d",
"manufacturerNumber": "WC4587-044",
"releaseDate": null,
"createdAt": "2017-01-01T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"305cc59fcd2445438f6b263eb3c59613",
"47e1b3a06fd54c6b85a2353e2bf052e9",
"82ae99d370dd40db9229cea17554f175"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "305cc59fcd2445438f6b263eb3c59613",
"_count": 1
},
{
"id": "47e1b3a06fd54c6b85a2353e2bf052e9",
"_count": 1
},
{
"id": "82ae99d370dd40db9229cea17554f175",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": "a087eeca93cb4cd69105d05df6b1979b",
"coverId": "a65b2fcf0f9e4c32a64b5568edb89522",
"childCount": 0,
"categories": [
{
"id": "82ae99d370dd40db9229cea17554f175",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Subaru",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Subaru",
"5494b24b09d445ebace47112836b4458": "Subaru"
}
}
],
"manufacturer": {
"id": "1ac4e5de8df54c318331a27442a1a52d",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "cometic",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "cometic"
},
"_count": 1
},
"properties": [
{
"id": "0c2603d99cdb48a59e82c4ed09814b54",
"_count": 1,
"groupId": "22a715b71ff441609b1deade031b2578",
"group": {
"id": "22a715b71ff441609b1deade031b2578",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.5 Boxer",
"de44571ddc4e4d0095c01af6ee299351": "2.5 Boxer",
"5494b24b09d445ebace47112836b4458": "2.5 boxeurs"
}
},
{
"id": "217c8692abf1447dba2bb5c38dfdf511",
"_count": 1,
"groupId": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"group": {
"id": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Subaru",
"5494b24b09d445ebace47112836b4458": "Subaru",
"de44571ddc4e4d0095c01af6ee299351": "Subaru"
}
},
{
"id": "257a235511af418fae68f6bbd1c59575",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "WRX",
"5494b24b09d445ebace47112836b4458": "WRX",
"de44571ddc4e4d0095c01af6ee299351": "WRX"
}
},
{
"id": "3fa6f892374b4ababafd6e93ccbd7c3b",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "FA20F | 300 PS (221 kW)",
"5494b24b09d445ebace47112836b4458": "FA20F | 300 ch (221 kW)",
"de44571ddc4e4d0095c01af6ee299351": " FA20F | 300 hp (221 kW)"
}
},
{
"id": "7b76691f08024f7f9af51b1661238f52",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "VA | BJ 2014-2021",
"5494b24b09d445ebace47112836b4458": "VA | BJ 2014-2021",
"de44571ddc4e4d0095c01af6ee299351": "VA | Year built 2014-2021"
}
},
{
"id": "d858bb63d85b437f9aa3ec900671e5cc",
"_count": 1,
"groupId": "22a715b71ff441609b1deade031b2578",
"group": {
"id": "22a715b71ff441609b1deade031b2578",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.0 Boxer",
"de44571ddc4e4d0095c01af6ee299351": "2.0 Boxer",
"5494b24b09d445ebace47112836b4458": "2.0 boxeur"
}
},
{
"id": "e16c1df371eb4ea1b0582897912fd233",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "EJ257 | 309 PS (227 kW)",
"5494b24b09d445ebace47112836b4458": "EJ257 | 309 ch (227 kW)",
"de44571ddc4e4d0095c01af6ee299351": "EJ257 | 309 hp (227 kW)"
}
},
{
"id": "e2d4de7954f046a9848f6a141e4e4214",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "EJ207 | 309 PS (227 kW)",
"5494b24b09d445ebace47112836b4458": "EJ207 | 309 ch (227 kW)",
"de44571ddc4e4d0095c01af6ee299351": " EJ207 | 309 hp (227 kW)"
}
}
],
"options": [
{
"id": "b44c3eb51b3a44f8bdd810c2292a7f94",
"_count": 1,
"groupId": "51c3c358523e46819535c289de01d92a",
"group": {
"id": "51c3c358523e46819535c289de01d92a",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "1,12 mm",
"5494b24b09d445ebace47112836b4458": "1,12 mm",
"de44571ddc4e4d0095c01af6ee299351": "1.12 mm"
}
}
],
"categoryIds": [
"82ae99d370dd40db9229cea17554f175"
],
"optionIds": [
"b44c3eb51b3a44f8bdd810c2292a7f94"
],
"propertyIds": [
"0c2603d99cdb48a59e82c4ed09814b54",
"217c8692abf1447dba2bb5c38dfdf511",
"257a235511af418fae68f6bbd1c59575",
"3fa6f892374b4ababafd6e93ccbd7c3b",
"7b76691f08024f7f9af51b1661238f52",
"d858bb63d85b437f9aa3ec900671e5cc",
"e16c1df371eb4ea1b0582897912fd233",
"e2d4de7954f046a9848f6a141e4e4214"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2f37bfd0f23f482bad9d34a02199499b": {
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_onco_universal_article": false
},
"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": "Zylinderkopfdichtung",
"migration_Shopware5DB_product_bullet1": "individuelle Verdichtung",
"migration_Shopware5DB_product_bullet2": "101mm Bohrung",
"migration_Shopware5DB_product_bullet3": "extrem stabil",
"migration_Shopware5DB_product_bullet4": "top Qualit\u00e4t",
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_url": "subaru-impreza-sti-wrx-sti-race-zylinderkopfdichtung",
"migration_Shopware5DB_product_dreisc_seo_title": "Cometic Zylinderkopfdichtung f\u00fcr deinen Subaru Impreza STI \/ WRX STI",
"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": "Zylinderkopfdichtung",
"migration_Shopware5DB_product_bullet1": "individuelle Verdichtung",
"migration_Shopware5DB_product_bullet2": "101mm Bohrung",
"migration_Shopware5DB_product_bullet3": "extrem stabil",
"migration_Shopware5DB_product_bullet4": "top Qualit\u00e4t",
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_title": "Cometic Zylinderkopfdichtung f\u00fcr deinen Subaru Impreza STI \/ WRX STI",
"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": "cylinder head gasket",
"migration_Shopware5DB_product_bullet1": "individual compaction",
"migration_Shopware5DB_product_bullet2": "101mm bore",
"migration_Shopware5DB_product_bullet3": "extremely robust",
"migration_Shopware5DB_product_bullet4": "top quality",
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_url": "subaru-impreza-sti-wrc-sti-race-cylinderhead-gasket",
"migration_Shopware5DB_product_dreisc_seo_title": "Cometic Cylinderhead Gasket for your Subaru Impreza STI \/ WRX STI",
"migration_Shopware5DB_product_onco_universal_article": false
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Subaru Impreza WRX\/WRX STI Race Zylinderkopfdichtung",
"5494b24b09d445ebace47112836b4458": "Joint de culasse pour Subaru Impreza WRX\/WRX STI Race",
"de44571ddc4e4d0095c01af6ee299351": "Subaru Impreza WRX\/WRX STI Race Cylinderhead Gasket"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zylinderkopfdichtung RACE f\u00fcr den Subaru Impreza STI \/ WRX STI in verschiedenen St\u00e4rken f\u00fcr individuelle Verdichtung.\nHinweis: In deinem Fahrzeug sind 2 Dichtungen verbaut. Wenn du die Dichtung komplett tauschen m\u00f6chtest, dann musst du 2 Dichtungen kaufen!!!\n101mm Bohrung 0,81mm bis 1,32mm St\u00e4rke (Die Subaru Impreza STI \/ WRX STI 2.5L 16V-Seriendichtung hat eine St\u00e4rke von 0,81mm)\nMit unserem Verdichtungsrechner kannst Du ganz leicht die Verdichtung bei unterschiedlicher Kopfdichtungenst\u00e4rke ausrechnen. So findest Du schnell und einfach die passende St\u00e4rke f\u00fcr deinen Motor.\nZum Verdichtungsrechner\nDiese Kopfdichtungen kommen besonders bei Hochleistungsmotoren im Formel und Rally Sport zum Einsatz. Durch die spezielle Zusammensetzung aus verschiedenen Metall Mehrlagen wird nicht nur eine weit aus bessere W\u00e4rmeleitf\u00e4higkeit erreicht, sondern auch die Druckstabilit\u00e4t wird enorm erh\u00f6ht! Diese Kopfdichtungen werden sowohl bei Saugmotoren wie auch Turbomotoren im Motorsport eingesetzt. Es werden verschiedene St\u00e4rken der Zylinderkopfdichtungen angeboten, so dass die Verdichtung individuell an jeden Subaru Impreza STI \/ WRX STI-Motor angepasst werden kann. Es sollten auf jeden Fall neue Kopfschrauben mitverwendet werden! Oder noch besser ARP Stehbolzen. (Abbildung \u00e4hnlich)",
"5494b24b09d445ebace47112836b4458": "Joint de culasse RACE pour la Subaru Impreza STI \/ WRX STI en diff\u00e9rentes \u00e9paisseurs pour une compression individuelle.\nRemarque : votre v\u00e9hicule est \u00e9quip\u00e9 de 2 joints. Si vous voulez changer compl\u00e8tement le joint, vous devez acheter 2 joints !\n101mm trou de0,81mm \u00e0 1,32mm d'\u00e9paisseur (Le Subaru Impreza STI \/ WRX STI 2,5L 16V joint standard a une \u00e9paisseur de 0,81mm) \nAvec notre calculateur de compactage, vous pouvez facilement calculer le compactage pour diff\u00e9rentes \u00e9paisseurs de joints de culasse. Vous pouvez donc trouver rapidement et facilement l'\u00e9paisseur qui convient \u00e0 votre moteur.\nVers le calculateur de compression\nCes joints de culasse sont particuli\u00e8rement utilis\u00e9s dans les moteurs de haute performance en Formule et en Rallye sportif. Gr\u00e2ce \u00e0 la composition sp\u00e9ciale des diff\u00e9rentes couches m\u00e9talliques, on obtient non seulement une bien meilleure conductivit\u00e9 thermique, mais aussi une stabilit\u00e9 de la pression consid\u00e9rablement accrue ! Ces joints de culasse sont utilis\u00e9s dans les moteurs \u00e0 aspiration naturelle et les moteurs turbocompress\u00e9s dans le sport automobile. Diff\u00e9rentes \u00e9paisseurs de joints de culasse sont propos\u00e9es, afin que la compression puisse \u00eatre adapt\u00e9e individuellement \u00e0 chaque moteur Subaru Impreza STI \/ WRX STI. De nouvelles vis \u00e0 t\u00eate creuse devraient \u00eatre utilis\u00e9es dans tous les cas !Ou encore mieux, des goujons ARP. (Image similaire) ",
"de44571ddc4e4d0095c01af6ee299351": "High performance head gasket for all Subaru Impreza STI \/ WRX STI motors with engine code EJ257.\nNote: There are 2 gaskets in your vehicle. If you want to change the seal completely, then you have to buy 2 seals !!!\nAvailable in different specifications: 101mm bore 0,81mm up to 1,32mm thickness. (For reference : The OEM Subaru Impreza STI \/ WRX STI head gasket is 0,81mm thick)\nWith our compression ratio calculator, you can easily calculate the correct CR (compression ratio) with different head gasket thicknesses. This is the fastest and easiest way to find the right thickness for your engine.\nTo the compression ratio calculator\nThese high performance head gaskets are made for race engines as used in Formula 3 or Rally engines. This head gaskets are made from different multy layer materials for high boost applications. Always use new headbolts or better ARP studs. (Pic shows different gasket)"
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BMW 2.0L 8V M10B20 Race Metall Zylinderkopfdichtung",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Cometic Cylinderhead Gasket for your Subaru Impreza STI \/ WRX STI"
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Mehrschichtig gepr\u00e4gte Edelstahldichtung mit Kautschuk-Deckschicht. \u2713 25 Jahre Motorsport-Erfahrung \u2713 schneller Versand \u2713 BAR-TEK\u00ae proved \u2794 jetzt kaufen",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Multilayered stainless steel seal with rubber cover layer. \u2713 15 years of motorsport experience \u2713 fast shipping \u2713 BAR-TEK\u00ae approved \u2794 buy now"
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 120.55,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 101.30666666667,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 129.17,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 108.54285714286,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 113.02,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 94.975,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 180.83,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 151.95798319328,
"shop-customer": "151.95798319328",
"b-dealer": "101.30666666667",
"c-dealer": "108.54285714286",
"a-dealer": "94.975"
},
"fields": {
"displayGroup": [
"cb8ceffea214f12ddce9b3890da6264d"
]
},
"sort": [
"",
0,
"0fc12875ced74ccdb5a97be693a2ba3a"
]
}
]
},
"aggregations": {
"total-count": {
"value": 1
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
4.20 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":"82ae99d370dd40db9229cea17554f175"}}}},{"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": "82ae99d370dd40db9229cea17554f175"
}
}
}
},
{
"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
|