| 1 |
4.19 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":"e56fbf791860466698118c7677769770"}}}},{"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": 2,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 5,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw6_stage__product_1742425202",
"_id": "13c488995aec4c68b429f42598b2d576",
"_score": null,
"_source": {
"id": "13c488995aec4c68b429f42598b2d576",
"autoIncrement": 62388.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": -1,
"productNumber": "21fi023.1",
"ean": null,
"displayGroup": "f75427e9c1671e2d70d68bd7c9e8ddd3",
"sales": 0,
"stock": -1,
"weight": 2.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "34b70bbe6d4645b1986725293fbe3a69",
"manufacturerNumber": "K9470D050",
"releaseDate": null,
"createdAt": "2017-01-01T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"87c86b255c784be7b2eebacd4ca87422",
"f387061892b04d04bdf38c30bb4a9894",
"0e2f1b1f20974a97a78380d6430b7e06",
"9d51fae00121475fb1b53119cca9cb6c",
"e56fbf791860466698118c7677769770"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "87c86b255c784be7b2eebacd4ca87422",
"_count": 1
},
{
"id": "f387061892b04d04bdf38c30bb4a9894",
"_count": 1
},
{
"id": "0e2f1b1f20974a97a78380d6430b7e06",
"_count": 1
},
{
"id": "9d51fae00121475fb1b53119cca9cb6c",
"_count": 1
},
{
"id": "e56fbf791860466698118c7677769770",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": "5d58b030d03848e995b8c9cf6edef72a",
"coverId": "f41ddd3682a3432c87890ff51be968d9",
"childCount": 0,
"categories": [
{
"id": "e56fbf791860466698118c7677769770",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "1.4L 16V",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "1.4L 16V",
"5494b24b09d445ebace47112836b4458": "1.4L 16V"
}
},
{
"id": "9d51fae00121475fb1b53119cca9cb6c",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Pistones forjados W\u00f6ssner",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "W\u00f6ssner Schmiedekolben",
"5494b24b09d445ebace47112836b4458": "W\u00f6ssner pistons forg\u00e9s",
"de44571ddc4e4d0095c01af6ee299351": "W\u00f6ssner Pistons"
}
}
],
"manufacturer": {
"id": "34b70bbe6d4645b1986725293fbe3a69",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "W\u00f6ssner",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "W\u00f6ssner"
},
"_count": 1
},
"properties": [
{
"id": "0cf6bcd735614d1586ec724ae5b90b57",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "155 PS (114 kW) \/ #0500",
"5494b24b09d445ebace47112836b4458": "155 ch (114 kW) \/ #0500",
"de44571ddc4e4d0095c01af6ee299351": "155 hp (114 kW) \/ #0500"
}
},
{
"id": "1c53cb19211f4bffbab4946e8b8fe009",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "160 PS (118 kW) \/ #1157",
"5494b24b09d445ebace47112836b4458": "160 ch (118 kW) \/ #1157",
"de44571ddc4e4d0095c01af6ee299351": "160 hp (118 kW) \/ #1157"
}
},
{
"id": "293b7d22627b42848c3cb157bd33ae09",
"_count": 1,
"groupId": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"group": {
"id": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fiat",
"5494b24b09d445ebace47112836b4458": "Fiat",
"de44571ddc4e4d0095c01af6ee299351": "Fiat"
}
},
{
"id": "447809f5d7574d27bf8d7bce62735e32",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Punto (Typ 199) | BJ 2012-2018",
"5494b24b09d445ebace47112836b4458": "Punto (type 199) | BJ 2012-2018",
"de44571ddc4e4d0095c01af6ee299351": "Punto (Type 199) | Year built 2012-2018"
}
},
{
"id": "61d612d2a89e4b17a44e9c59e6a83462",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Punto",
"5494b24b09d445ebace47112836b4458": "Punto",
"de44571ddc4e4d0095c01af6ee299351": "Punto"
}
},
{
"id": "68f11461635e4e5eba5149e599e03765",
"_count": 1,
"groupId": "22a715b71ff441609b1deade031b2578",
"group": {
"id": "22a715b71ff441609b1deade031b2578",
"_count": 1
},
"name": {
"5494b24b09d445ebace47112836b4458": "1.4 16V T-JET (FEU)",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "1.4 16V T-JET (FIRE)",
"de44571ddc4e4d0095c01af6ee299351": "1.4 16V T-JET (FIRE)"
}
},
{
"id": "69eeaa9b2c734237b4952af446c6368c",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "500 | BJ 2007->",
"5494b24b09d445ebace47112836b4458": "500 | ANN\u00c9E 2007->",
"de44571ddc4e4d0095c01af6ee299351": "500 | Year built 2007->"
}
},
{
"id": "966e4feed8684295a46b5eadbc3a5ad2",
"_count": 1,
"groupId": "22a715b71ff441609b1deade031b2578",
"group": {
"id": "22a715b71ff441609b1deade031b2578",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "1.4 16V (FIRE)",
"5494b24b09d445ebace47112836b4458": "1.4 16V (FIRE)",
"de44571ddc4e4d0095c01af6ee299351": "1.4 16V (FIRE)"
}
},
{
"id": "c2fc0b530e724b639a80b8f0b16f6684",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "500",
"5494b24b09d445ebace47112836b4458": "500",
"de44571ddc4e4d0095c01af6ee299351": "500"
}
}
],
"options": [
{
"id": "f07c2743bb7148fd8c3316e5c419ee3a",
"_count": 1,
"groupId": "1b3988d5c24541b38d14b30f9df96c23",
"group": {
"id": "1b3988d5c24541b38d14b30f9df96c23",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "72,50 mm \/ 10,8:1",
"5494b24b09d445ebace47112836b4458": "72,50 mm \/ 10,8:1",
"de44571ddc4e4d0095c01af6ee299351": "72.50 mm \/ 10.8:1"
}
}
],
"categoryIds": [
"9d51fae00121475fb1b53119cca9cb6c",
"e56fbf791860466698118c7677769770"
],
"optionIds": [
"f07c2743bb7148fd8c3316e5c419ee3a"
],
"propertyIds": [
"0cf6bcd735614d1586ec724ae5b90b57",
"1c53cb19211f4bffbab4946e8b8fe009",
"293b7d22627b42848c3cb157bd33ae09",
"447809f5d7574d27bf8d7bce62735e32",
"61d612d2a89e4b17a44e9c59e6a83462",
"68f11461635e4e5eba5149e599e03765",
"69eeaa9b2c734237b4952af446c6368c",
"966e4feed8684295a46b5eadbc3a5ad2",
"c2fc0b530e724b639a80b8f0b16f6684"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"migration_Shopware5DB_product_attr14": "2820",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "W\u00f6ssner Schmiedekolben",
"migration_Shopware5DB_product_bullet1": "High boost",
"migration_Shopware5DB_product_bullet2": "Top Materialien",
"migration_Shopware5DB_product_bullet3": "Extrem leicht",
"migration_Shopware5DB_product_bullet4": "Super Verarbeitung",
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_url": "schmiedekolben-satz-woessner-fiat-500-abarth",
"migration_Shopware5DB_product_dreisc_seo_title": "Schmiedekolben-Satz von W\u00f6ssner f\u00fcr deinen Fiat 500 Abarth",
"migration_Shopware5DB_product_onco_universal_article": false
},
"5494b24b09d445ebace47112836b4458": {
"migration_Shopware5DB_product_attr14": "2820",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "W\u00f6ssner Schmiedekolben",
"migration_Shopware5DB_product_bullet1": "High boost",
"migration_Shopware5DB_product_bullet2": "Top Materialien",
"migration_Shopware5DB_product_bullet3": "Extrem leicht",
"migration_Shopware5DB_product_bullet4": "Super Verarbeitung",
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_title": "Schmiedekolben-Satz von W\u00f6ssner f\u00fcr deinen Fiat 500 Abarth",
"migration_Shopware5DB_product_onco_universal_article": false
},
"de44571ddc4e4d0095c01af6ee299351": {
"migration_Shopware5DB_product_attr14": "2820",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "W\u00f6ssner forged piston",
"migration_Shopware5DB_product_bullet1": "High boost",
"migration_Shopware5DB_product_bullet2": "Top materials",
"migration_Shopware5DB_product_bullet3": "Extremely light",
"migration_Shopware5DB_product_bullet4": "Super processing",
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_url": "forged-pistons-woessner-fiat-500-abarth",
"migration_Shopware5DB_product_dreisc_seo_title": "Forged Pistons Kit from W\u00f6ssner for your Fiat 500 Abarth",
"migration_Shopware5DB_product_onco_universal_article": false
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fiat 500 Abarth 1.4L Turbo Schmiedekolben-Satz W\u00f6ssner",
"5494b24b09d445ebace47112836b4458": "Fiat 500 Abarth 1.4L Turbo forg\u00e9 jeu de pistons W\u00f6ssner",
"de44571ddc4e4d0095c01af6ee299351": "Fiat 500 Abarth 1.4L Turbo High Performance Pistons-Kit W\u00f6ssner"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Geschmiedete Hochleistungskolben der Firma W\u00f6ssner f\u00fcr alle 1.4L Turbo Motoren mit 18mm Kolbenbolzen wie im Fiat 500 Abarth.\nInnovative Spezialisten f\u00fcr Hochleistungskolben. W\u00f6ssner Kolben arbeiten in Motoren auf dem h\u00f6chsten Level des Motorsports, sowie im t\u00e4glichen Gebrauch \u2013 \u00fcberall dort wo Leistung und Langlebigkeit sehr wichtige Faktoren sind.\nFeatures:\n\nOriginal W\u00f6ssner\nMADE IN GERMANY\nVerdichtung 10.8:1\nExtrem leicht, nur ca. 190g pro Kolben\nVerst\u00e4rkt f\u00fcr maximale Leistung\n18mm Kolbenbolzen\nKolbenhemd beschichtet f\u00fcr weniger Reibung\nEinbau- und Bohrma\u00dfe liegen bei\n\nW\u00f6ssner Kolben werden mit den entsprechenden Kolbenringen, Kolbenbolzen und Sicherungsclips geliefert\n \nAbbildung \u00e4hnlich",
"5494b24b09d445ebace47112836b4458": "Pistons haute performance forg\u00e9s par W\u00f6ssner pour tous les moteurs 1,4 L turbo avec axe de piston de 18 mm comme dans la Fiat 500 Abarth.\nDes sp\u00e9cialistes innovants pour des pistons de haute performance. Les pistons W\u00f6ssner fonctionnent dans les moteurs au plus haut niveau du sport automobile, ainsi que dans l'utilisation quotidienne - partout o\u00f9 la performance et la durabilit\u00e9 sont des facteurs tr\u00e8s importants.\nCaract\u00e9ristiques :\n\nOriginal W\u00f6ssner\nMADE IN GERMANY\nCompression 10.8:1\nExtr\u00eamement l\u00e9ger, seulement environ 190g par piston\nRenforc\u00e9 pour une performance maximale\nAxe de piston de 18 mm\nJupe de piston rev\u00eatue pour r\u00e9duire les frottements\nLes dimensions de l'installation et du forage sont indiqu\u00e9es dans le tableau ci-dessous\n\nLes pistons W\u00f6ssner sont fournis avec les segments de piston , les goupilles et les clips de s\u00e9curit\u00e9 correspondants \n \nImage similaire",
"de44571ddc4e4d0095c01af6ee299351": "Forged high performance pistons made by W\u00f6ssner for all 1.4L Turbo engines with 18mm piston pin as in the Fiat 500 Abarth or Grande Punto\nInnovative specialists for high performance pistons. W\u00f6ssner pistons work in engines at the highest level of motorsport, as well as in everyday use - wherever performance and longevity are very important factors.\nfeatures:\n\nOriginal W\u00f6ssner\nMADE IN GERMANY\nCompaction 10.8:1\nExtremely light, only about 190g per piston\nReinforced for maximum performance\n18mm piston pin\nPiston skirt coated for less friction\nInstallation and drilling dimensions are included\n\nW\u00f6ssner pistons are supplied with the corresponding piston rings, piston pins and securing clips\n \nPicture similar"
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "1.8T Schmiedekolben-Satz WISECO",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Forged Pistons Kit from W\u00f6ssner for your Fiat 500 Abarth"
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Satz geschmiedete Hochleistungskolben inkl. Ringe, Bolzen und Clips. \u2713 25 Jahre Motorsport-Erfahrung \u2713 schneller Versand \u2713 BAR-TEK\u00ae proved \u2794 jetzt kaufen",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Set of forged high performance pistons incl. Rings, bolts and clips. \u2713 15 years of motorsport experience \u2713 fast shipping \u2713 BAR-TEK\u00ae proved \u2794 buy now"
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1123.06,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 943.75,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1123.06,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 943.75,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1123.06,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 943.75,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1199.0,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 1007.5630252101,
"shop-customer": "1007.5630252101",
"b-dealer": "943.75",
"c-dealer": "943.75",
"a-dealer": "943.75"
},
"fields": {
"displayGroup": [
"f75427e9c1671e2d70d68bd7c9e8ddd3"
]
},
"sort": [
"",
0,
"13c488995aec4c68b429f42598b2d576"
]
},
{
"_index": "sw6_stage__product_1742425202",
"_id": "1df8c79ced8c45d1ad75cb191f4212b6",
"_score": null,
"_source": {
"id": "1df8c79ced8c45d1ad75cb191f4212b6",
"autoIncrement": 62917.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 0,
"productNumber": "21fi010.1",
"ean": null,
"displayGroup": "4ecf2c2b8e03580049ad480df15c992f",
"sales": 0,
"stock": 0,
"weight": 3.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "6aadff5484494e05b2cd9cd32ec57924",
"manufacturerNumber": "JE-315367",
"releaseDate": null,
"createdAt": "2017-01-01T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"87c86b255c784be7b2eebacd4ca87422",
"f387061892b04d04bdf38c30bb4a9894",
"0e2f1b1f20974a97a78380d6430b7e06",
"dd423f04067c42059fc90c7bd91c59f6",
"e56fbf791860466698118c7677769770"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "87c86b255c784be7b2eebacd4ca87422",
"_count": 1
},
{
"id": "f387061892b04d04bdf38c30bb4a9894",
"_count": 1
},
{
"id": "0e2f1b1f20974a97a78380d6430b7e06",
"_count": 1
},
{
"id": "dd423f04067c42059fc90c7bd91c59f6",
"_count": 1
},
{
"id": "e56fbf791860466698118c7677769770",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": "e01ba7ab28784131b08681b55d40b787",
"coverId": "df8d5e9ae82f456e9e7998505e32ce71",
"childCount": 0,
"categories": [
{
"id": "e56fbf791860466698118c7677769770",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "1.4L 16V",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "1.4L 16V",
"5494b24b09d445ebace47112836b4458": "1.4L 16V"
}
},
{
"id": "dd423f04067c42059fc90c7bd91c59f6",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Pistones JE Pistones forjados",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "JE Pistons Schmiedekolben",
"5494b24b09d445ebace47112836b4458": "JE Pistons pistons forg\u00e9s",
"de44571ddc4e4d0095c01af6ee299351": "JE Pistons"
}
}
],
"manufacturer": {
"id": "6aadff5484494e05b2cd9cd32ec57924",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "JE Pistons",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "JE Pistons"
},
"_count": 1
},
"properties": [
{
"id": "1c53cb19211f4bffbab4946e8b8fe009",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "160 PS (118 kW) \/ #1157",
"5494b24b09d445ebace47112836b4458": "160 ch (118 kW) \/ #1157",
"de44571ddc4e4d0095c01af6ee299351": "160 hp (118 kW) \/ #1157"
}
},
{
"id": "293b7d22627b42848c3cb157bd33ae09",
"_count": 1,
"groupId": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"group": {
"id": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fiat",
"5494b24b09d445ebace47112836b4458": "Fiat",
"de44571ddc4e4d0095c01af6ee299351": "Fiat"
}
},
{
"id": "69eeaa9b2c734237b4952af446c6368c",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "500 | BJ 2007->",
"5494b24b09d445ebace47112836b4458": "500 | ANN\u00c9E 2007->",
"de44571ddc4e4d0095c01af6ee299351": "500 | Year built 2007->"
}
},
{
"id": "966e4feed8684295a46b5eadbc3a5ad2",
"_count": 1,
"groupId": "22a715b71ff441609b1deade031b2578",
"group": {
"id": "22a715b71ff441609b1deade031b2578",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "1.4 16V (FIRE)",
"5494b24b09d445ebace47112836b4458": "1.4 16V (FIRE)",
"de44571ddc4e4d0095c01af6ee299351": "1.4 16V (FIRE)"
}
},
{
"id": "c2fc0b530e724b639a80b8f0b16f6684",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "500",
"5494b24b09d445ebace47112836b4458": "500",
"de44571ddc4e4d0095c01af6ee299351": "500"
}
}
],
"options": [
{
"id": "1b3b84ea4216443e9f10ee2df80e2f8f",
"_count": 1,
"groupId": "1b3988d5c24541b38d14b30f9df96c23",
"group": {
"id": "1b3988d5c24541b38d14b30f9df96c23",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "72,50 mm \/ 9,8:1",
"5494b24b09d445ebace47112836b4458": "72,50 mm \/ 9,8:1",
"de44571ddc4e4d0095c01af6ee299351": "72.50 mm \/ 9.8:1"
}
}
],
"categoryIds": [
"dd423f04067c42059fc90c7bd91c59f6",
"e56fbf791860466698118c7677769770"
],
"optionIds": [
"1b3b84ea4216443e9f10ee2df80e2f8f"
],
"propertyIds": [
"1c53cb19211f4bffbab4946e8b8fe009",
"293b7d22627b42848c3cb157bd33ae09",
"69eeaa9b2c734237b4952af446c6368c",
"966e4feed8684295a46b5eadbc3a5ad2",
"c2fc0b530e724b639a80b8f0b16f6684"
],
"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_dreisc_seo_title": "Fiat Abarth 500 1.4L 16V Schmiedekolben-Satz JE",
"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": "Hochleistungskolben",
"migration_Shopware5DB_product_bullet1": "Auch f\u00fcr Serienbohrung 72,00mm",
"migration_Shopware5DB_product_bullet2": "18mm Kolbenbolzen",
"migration_Shopware5DB_product_bullet3": "Verdichtung 9.8:1",
"migration_Shopware5DB_product_bullet4": "Einbau- und Bohrma\u00dfe liegen bei",
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_url": "fiat-1-4l-16v-abarth500-schmiedekolben-je-kolben",
"migration_Shopware5DB_product_dreisc_seo_title": "Fiat Abarth 500 1.4L 16V Schmiedekolben-Satz JE",
"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": "Hochleistungskolben",
"migration_Shopware5DB_product_bullet1": "Auch f\u00fcr Serienbohrung 72,00mm",
"migration_Shopware5DB_product_bullet2": "18mm Kolbenbolzen",
"migration_Shopware5DB_product_bullet3": "Verdichtung 9.8:1",
"migration_Shopware5DB_product_bullet4": "Einbau- und Bohrma\u00dfe liegen bei",
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_title": "Fiat Abarth 500 1.4L 16V Schmiedekolben-Satz JE",
"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": "High performance piston",
"migration_Shopware5DB_product_bullet1": "Also for series bore 72.00mm",
"migration_Shopware5DB_product_bullet2": "18mm piston pin",
"migration_Shopware5DB_product_bullet3": "Compression 9.8:1",
"migration_Shopware5DB_product_bullet4": "Installation and drilling dimensions are enclosed",
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_url": "fiat-abarth-500-1-4l-16v-high-performance-pistons-kit-je",
"migration_Shopware5DB_product_dreisc_seo_title": "Fiat Abarth 500 1.4L 16V Schmiedekolben-Satz JE",
"migration_Shopware5DB_product_onco_universal_article": false
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fiat Abarth 500 1.4L 16V Schmiedekolben-Satz JE",
"5494b24b09d445ebace47112836b4458": "Fiat Abarth 500 1,4L 16V jeu de pistons forg\u00e9s JE",
"de44571ddc4e4d0095c01af6ee299351": "Fiat Abarth 500 1.4L 16V High Performance Pistons-Kit JE"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Geschmiedete Hochleistungskolben von JE Piston f\u00fcr alle Fiat Abarth 500 1.4L 16V Motoren.\nFeatures:\n\nExtrem leicht durch Speziallegierung\nVerst\u00e4rkt f\u00fcr maximale Leistung\nAuch f\u00fcr Serienbohrung 72,00mm\n18mm Kolbenbolzen\nVerdichtung 9.8:1\nKomplettes Set inkl. Kolbenbolzen, Ringen und Clipsen\nEinbau- und Bohrma\u00dfe liegen bei\n\nF\u00fcr Fiat Punto Abarth 500 1.4L 16V Motoren. Preis f\u00fcr einen Satz JE Kolben ohne Beschichtung, diese kann aber gegen Aufpreis speziell von JE gefertigt werden. Das letzte Bild zeigt JE Kolben mit Sonderbeschichtungen an Kolbenhemd und Kolbenboden. Die Sonderbeschichtung kann bei uns separat bestellt werden. (siehe weiter unten) (Abbildung \u00e4hnlich)",
"5494b24b09d445ebace47112836b4458": "Pistons forg\u00e9s haute performance de JE Piston pour tous les moteurs Fiat Abarth 500 1,4L 16V.\nCaract\u00e9ristiques :\n\nExtr\u00eamement l\u00e9ger gr\u00e2ce \u00e0 un alliage sp\u00e9cial\nRenforc\u00e9 pour une performance maximale\nEgalement pour les s\u00e9ries de 72,00mm\nAxe de piston de 18 mm\nCompression 9.8:1\nEnsemble complet comprenant l'axe de piston, les segments et les clips\nLes dimensions de l'installation et du forage sont indiqu\u00e9es dans le tableau ci-dessous\n\nPour la Fiat Punto Abarth 500 1,4L 16V. Prix pour un jeu de pistons JE sans rev\u00eatement, mais celui-ci peut \u00eatre sp\u00e9cialement fabriqu\u00e9 par JE moyennant un suppl\u00e9ment. La derni\u00e8re photo montre des pistons JE avec des rev\u00eatements sp\u00e9ciaux sur la jupe et la couronne du piston.Le rev\u00eatement sp\u00e9cial peut \u00eatre command\u00e9 s\u00e9par\u00e9ment. ( voir ci-dessous) (Illustration similaire )",
"de44571ddc4e4d0095c01af6ee299351": "High Performance Pistons kit for all Fiat Abarth 500 1.4L 16V engines.\r\nFeatures:\r\n\r\nmuch lighter\r\nreinforced\r\ncomplete kit with rings and pins\r\nalso for OEM bore size available 72,00mm\r\n18mm piston pin diameter\r\ncompression 9.8:1\r\n\r\nThe last pic shows JE pistons WITH special coatings. These coatings are not included with this price but can be ordered at JE (scroll down). (Example picture)"
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fiat Abarth 500 1.4L 16V Schmiedekolben-Satz JE",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Fiat Abarth 500 1.4L 16V forged piston set JE"
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 708.73425,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 595.575,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 755.96430042,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 635.264118,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 810.791982,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 681.3378,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 930.96,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 782.31932773109,
"shop-customer": "782.31932773109",
"a-dealer": "595.575",
"b-dealer": "635.264118",
"c-dealer": "681.3378"
},
"fields": {
"displayGroup": [
"4ecf2c2b8e03580049ad480df15c992f"
]
},
"sort": [
"",
0,
"1df8c79ced8c45d1ad75cb191f4212b6"
]
}
]
},
"aggregations": {
"total-count": {
"value": 2
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
3.87 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":"e56fbf791860466698118c7677769770"}}}},{"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": "e56fbf791860466698118c7677769770"
}
}
}
},
{
"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
|