| 1 |
3.81 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.2fbb5fe2e29a4d70aa5854ce7ce3e20b"}}]}},{"multi_match":{"query":false,"fields":["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":"3747392b096146cda8b51f7f3d8b696c"}}}},{"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":["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": "33426e801d5b480fbfe6cd797e66a59c",
"_score": null,
"_source": {
"id": "33426e801d5b480fbfe6cd797e66a59c",
"autoIncrement": 45710.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 0,
"productNumber": "21st003",
"ean": "4250580442776",
"displayGroup": "87e14aed493e891c05dccb7ef67eea0a",
"sales": 0,
"stock": 0,
"weight": 25.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "b2ae8e52009f46408e3ca94eb7499247",
"manufacturerNumber": "13282016",
"releaseDate": null,
"createdAt": "2021-11-15T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"2e8eb18374c5436ea8d0f9f47b5da11f",
"27f9e3ecf3b642e5afe0bc2c87a81d21",
"3747392b096146cda8b51f7f3d8b696c"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "2e8eb18374c5436ea8d0f9f47b5da11f",
"_count": 1
},
{
"id": "27f9e3ecf3b642e5afe0bc2c87a81d21",
"_count": 1
},
{
"id": "3747392b096146cda8b51f7f3d8b696c",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": null,
"coverId": "50731be241d24dd5b7ce14cea9a10482",
"childCount": 0,
"categories": [
{
"id": "3747392b096146cda8b51f7f3d8b696c",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Amortiguadores ST",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "ST Gewindefahrwerke",
"5494b24b09d445ebace47112836b4458": "Suspensions filet\u00e9es ST",
"de44571ddc4e4d0095c01af6ee299351": "ST Coilover Kits"
}
}
],
"manufacturer": {
"id": "b2ae8e52009f46408e3ca94eb7499247",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "ST Fahrwerke",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "ST Chassis"
},
"_count": 1
},
"properties": [],
"options": [],
"categoryIds": [
"3747392b096146cda8b51f7f3d8b696c"
],
"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": "ST-X Gewindefahrwerk",
"migration_Shopware5DB_product_bullet1": "Sportlichkeit gepaart ",
"migration_Shopware5DB_product_bullet2": "mit herausragender Optik",
"migration_Shopware5DB_product_bullet3": "vorab optimal eingestellt",
"migration_Shopware5DB_product_bullet4": "Stufenlose Tieferlegung",
"migration_Shopware5DB_product_socialfeed": false,
"migration_Shopware5DB_product_dreisc_seo_url": "golf7r-variant-cupra-st-x-gewindefahrwerk",
"migration_Shopware5DB_product_dreisc_seo_title": "Golf 7R Variant & Leon Cupra ST AWD ST X Gewindefahrwerk",
"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": "ST-X Gewindefahrwerk",
"migration_Shopware5DB_product_bullet1": "Sportlichkeit gepaart ",
"migration_Shopware5DB_product_bullet2": "mit herausragender Optik",
"migration_Shopware5DB_product_bullet3": "vorab optimal eingestellt",
"migration_Shopware5DB_product_bullet4": "Stufenlose Tieferlegung",
"migration_Shopware5DB_product_socialfeed": false,
"migration_Shopware5DB_product_dreisc_seo_title": "Golf 7R Variant & Leon Cupra ST AWD ST X Gewindefahrwerk",
"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": "KW Variant 1",
"migration_Shopware5DB_product_bullet1": "Sportiness paired",
"migration_Shopware5DB_product_bullet2": "with outstanding optics",
"migration_Shopware5DB_product_bullet3": "pre-adjusted",
"migration_Shopware5DB_product_bullet4": "Stainless steel technology \"inox-line",
"migration_Shopware5DB_product_socialfeed": false,
"migration_Shopware5DB_product_dreisc_seo_url": "golf7r-variant-cupra-st-x-coilover-suspension",
"migration_Shopware5DB_product_dreisc_seo_title": "Golf 7R Variant & Leon Cupra ST AWD ST X Gewindefahrwerk",
"migration_Shopware5DB_product_onco_universal_article": false
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Golf 7R Variant & Leon Cupra ST AWD ST X Gewindefahrwerk",
"5494b24b09d445ebace47112836b4458": "Golf 7R Variant & Leon Cupra ST AWD ST X Coilover Suspension",
"de44571ddc4e4d0095c01af6ee299351": "Golf 7R Variant & Leon Cupra ST AWD ST X Coilover Suspension"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Bitte bei Bestellung immer die Schl\u00fcsselnummer HSN\/TSN mit angeben.\nDer Einstieg in die FahrdynamikMit dem ST X Gewindefahrwerk liegt Dein Fahrzeug sportlich und doch komfortabel auf der Stra\u00dfe. Durch die maximal m\u00f6gliche Tieferlegung, die Du stufenlos einstellen kannst, wird Dein Wagen zum optischen Highlight!\nIndividuell H\u00f6heneinstellbarMit dem ST X Gewindefahrwerk kannst Du dank der stufenlosen Tieferlegung den Look Deines Fahrzeugs ideal einstellen. Wir fertigen den Gewindefederteller aus einem widerstandsf\u00e4higen und reibungsoptimierten Polyamid-Verbundwerkstoff mit Edelstahleinlage. Dank des Verbundwerkstoffs wird im Gegensatz zu eloxierten Federtellern aus Aluminium eine m\u00f6gliche Oxidation verhindert. So kannst Du dauerhaft die H\u00f6heneinstellung Deines ST X Gewindefahrwerks nutzen.\nMehrfach versiegelte und verzinkte Stahld\u00e4mpferDie verzinkten Gewindefederbeine werden wie in der Erstausr\u00fcstung \u00fcblich aus verzinktem Stahl gefertigt und unsere zus\u00e4tzliche Versiegelung sorgt f\u00fcr einen optimierten Korrosionsschutz. Die inneren Werte Deines hochwertigen ST Gewindefahrwerks mit seinen KW D\u00e4mpfern sch\u00fctzen wir mit einem reibungsarmen und druckbest\u00e4ndigen D\u00e4mpfergeh\u00e4use, dem Einsatz hartverchromter Kolbenstange sowie einem Monoblock-F\u00fchrungs- und Dichtungspaket.\n\n\nNur f\u00fcr Fahrzeuge mit einem Klemmdurchmesser an der VA von 55mm\n85 mm gepr\u00fcfter Einstellbereich\nTieferlegung VA 5-35, HA 5-30\nStufenlose Tieferlegung\nComposite Federteller\nStaubschutz und Bumpstop\nVerzinkte Stahlfederbeine\n\n",
"5494b24b09d445ebace47112836b4458": "Veuillez toujours indiquer le num\u00e9ro de cl\u00e9 HSN\/TSN lors de votre commande.\nL'entr\u00e9e dans la dynamique de conduiteAvec la suspension \u00e0 ressorts h\u00e9lico\u00efdaux ST X, votre v\u00e9hicule est \u00e0 la fois sportif et confortable sur la route. L'abaissement maximal possible, que vous pouvez ajuster en continu, transforme votre voiture en un point de mire !\nR\u00e9glage individuel de la hauteurAvec la suspension coilover ST X, vous pouvez ajuster id\u00e9alement le look de votre v\u00e9hicule gr\u00e2ce \u00e0 l'abaissement infiniment variable. Nous fabriquons la plaque du ressort h\u00e9lico\u00efdal \u00e0 partir d'un mat\u00e9riau composite polyamide r\u00e9sistant et \u00e0 friction optimis\u00e9e, avec un insert en acier inoxydable. Gr\u00e2ce au mat\u00e9riau composite, l'oxydation \u00e9ventuelle est \u00e9vit\u00e9e, contrairement aux plaques de ressort en aluminium anodis\u00e9. Cela signifie que vous pouvez utiliser le r\u00e9glage en hauteur de votre suspension coilover ST X de mani\u00e8re permanente.\nAmortisseurs en acier galvanis\u00e9 et multi-scell\u00e9sLes amortisseurs galvanis\u00e9s des coilover sont fabriqu\u00e9s en acier galvanis\u00e9, comme c'est habituellement le cas en \u00e9quipement d'origine, et notre scellement suppl\u00e9mentaire assure une protection optimale contre la corrosion. Nous prot\u00e9geons les valeurs internes de votre suspension coilover ST de haute qualit\u00e9 avec ses amortisseurs KW gr\u00e2ce \u00e0 un bo\u00eetier d'amortisseur \u00e0 faible frottement et r\u00e9sistant \u00e0 la pression, \u00e0 l'utilisation de tiges de piston chrom\u00e9es dur et \u00e0 un ensemble monobloc de guides et de joints.\n\n\nUniquement pour les v\u00e9hicules avec un diam\u00e8tre de serrage au VA de 55mm\nPlage de r\u00e9glage test\u00e9e de 85 mm\nAbaissement VA 5-35, HA 5-30\nAbaissement progressif\nComposite si\u00e8ge de ressort\nProtection contre la poussi\u00e8re et pare-chocs\n\u00c9tais en acier galvanis\u00e9\n\n",
"de44571ddc4e4d0095c01af6ee299351": "Please always state the HSN\/TSN key number when ordering.\nThe entry into driving dynamicsWith the ST X coilover suspension, your vehicle is sporty and yet comfortable on the road. Due to the maximum possible lowering, which you can adjust continuously, your car becomes a visual highlight!\nIndividually height adjustableWith the ST X coilover suspension, you can ideally adjust the look of your vehicle thanks to the infinitely variable lowering. We manufacture the coil spring plate from a resistant and friction-optimized polyamide composite material with stainless steel inlay. Thanks to the composite material, possible oxidation is prevented in contrast to anodized aluminum spring plates. So you can permanently use the height adjustment of your ST X coilover suspension.\nMulti-sealed and galvanized steel shocksThe galvanized coilover shocks are made of galvanized steel, as usual in original equipment, and our additional sealing ensures optimized corrosion protection. We protect the inner values of your high-quality ST coilover suspension with its KW dampers with a low-friction and pressure-resistant damper housing, the use of hard-chrome plated piston rods and a monoblock guide and seal package.\n\n\nOnly for vehicles with a clamping diameter at the VA of 55mm\n85 mm tested adjustment range\nLowering VA 5-35, HA 5-30\nStepless lowering\nComposite spring retainer\nDust protection and bumpstop\nGalvanized steel struts\n\n"
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sportlichkeit gepaart mit herausragender Optik. ST Gewindefahrwerke \u2714 15 Jahre Motorsporterfahrung \u2714 schneller Versand \u2714 BAR-TEK\u00ae proved \u2794 jetzt kaufen",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Sportiness paired with outstanding looks. ST coilovers \u2714 15 years of motorsport experience \u2714 fast shipping \u2714 BAR-TEK\u00ae proven \u2794 buy now"
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 969,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 814.28571428571,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 969,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 814.28571428571,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 969,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 814.28571428571,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 979.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 823.48739495798,
"shop-customer": "823.48739495798",
"a-dealer": "814.28571428571",
"c-dealer": "814.28571428571",
"b-dealer": "814.28571428571"
},
"fields": {
"displayGroup": [
"87e14aed493e891c05dccb7ef67eea0a"
]
},
"sort": [
"",
0,
"33426e801d5b480fbfe6cd797e66a59c"
]
}
]
},
"aggregations": {
"total-count": {
"value": 1
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
3.79 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.2fbb5fe2e29a4d70aa5854ce7ce3e20b"}}]}},{"multi_match":{"query":false,"fields":["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":"3747392b096146cda8b51f7f3d8b696c"}}}},{"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-filter":{"nested":{"path":"properties"},"aggregations":{"properties-filter":{"filter":{"terms":{"properties.groupId":["a8bf3b8377cb4590865f2dbe94ba8d0a","711e47e772ca4a4ab448b7212cbf19cb"]}},"aggregations":{"properties":{"terms":{"field":"properties.id","size":10000}}}}}},"options-filter":{"nested":{"path":"options"},"aggregations":{"options-filter":{"filter":{"terms":{"options.groupId":["a8bf3b8377cb4590865f2dbe94ba8d0a","711e47e772ca4a4ab448b7212cbf19cb"]}},"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"}}}},"properties":{"nested":{"path":"properties"},"aggregations":{"properties":{"terms":{"field":"properties.id","size":10000}}}},"options":{"nested":{"path":"options"},"aggregations":{"options":{"terms":{"field":"options.id","size":10000}}}},"isUniversal-filter":{"filter":{"multi_match":{"query":true,"fields":["customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.migration_Shopware5DB_product_onco_universal_article"],"type":"best_fields"}},"aggregations":{"isUniversal":{"max":{"field":"customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.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.2fbb5fe2e29a4d70aa5854ce7ce3e20b"
}
}
]
}
},
{
"multi_match": {
"query": false,
"fields": [
"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": "3747392b096146cda8b51f7f3d8b696c"
}
}
}
},
{
"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-filter": {
"nested": {
"path": "properties"
},
"aggregations": {
"properties-filter": {
"filter": {
"terms": {
"properties.groupId": [
"a8bf3b8377cb4590865f2dbe94ba8d0a",
"711e47e772ca4a4ab448b7212cbf19cb"
]
}
},
"aggregations": {
"properties": {
"terms": {
"field": "properties.id",
"size": 10000
}
}
}
}
}
},
"options-filter": {
"nested": {
"path": "options"
},
"aggregations": {
"options-filter": {
"filter": {
"terms": {
"options.groupId": [
"a8bf3b8377cb4590865f2dbe94ba8d0a",
"711e47e772ca4a4ab448b7212cbf19cb"
]
}
},
"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"
}
}
}
},
"properties": {
"nested": {
"path": "properties"
},
"aggregations": {
"properties": {
"terms": {
"field": "properties.id",
"size": 10000
}
}
}
},
"options": {
"nested": {
"path": "options"
},
"aggregations": {
"options": {
"terms": {
"field": "options.id",
"size": 10000
}
}
}
},
"isUniversal-filter": {
"filter": {
"multi_match": {
"query": true,
"fields": [
"customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.migration_Shopware5DB_product_onco_universal_article"
],
"type": "best_fields"
}
},
"aggregations": {
"isUniversal": {
"max": {
"field": "customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.migration_Shopware5DB_product_onco_universal_article"
}
}
}
}
},
"size": 0,
"timeout": "5s"
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|