| 1 |
3.25 ms |
Request:
{"index":"dev_product","search_type":"query_then_fetch","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"term":{"active":true}},{"range":{"visibility_08d2beb617754d2e9b8813e67fbd3a10":{"gte":30}}}]}},{"term":{"categoryTree":"3a4903e587284a8fb136b1a53dec1421"}},{"exists":{"field":"displayGroup"}},{"bool":{"must_not":[{"bool":{"must":[{"term":{"isCloseout":true}},{"term":{"available":false}}]}}]}}]}}]}},"sort":[{"sales":{"order":"DESC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":32,"size":32,"collapse":{"field":"displayGroup"},"timeout":"5s"}}
{
"took": 1,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 39,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "dev_product_1762781623",
"_id": "daf2224ea71343979673763f5758de46",
"_score": null,
"_source": {
"purchasePrices": [
{
"currencyId": "b7d2554b0ce847cd82f3ac9bd1c0dfca",
"gross": 0.0,
"net": 0.0,
"linked": true
}
],
"referenceUnit": null,
"purchaseUnit": null,
"unit": {
"id": null,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5059dc45b5104c368cc2a7f890b80123": null
},
"shortCode": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5059dc45b5104c368cc2a7f890b80123": null
},
"_count": 1
},
"crossSellings": [
{
"id": "85476e90910e4c458b8c7ca56920169f",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "\u00c4hnliche Artikel"
}
},
{
"id": "516c39426fb544be93ea8cc738c71c04",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Das k\u00f6nnte Sie auch interessieren"
}
}
],
"keywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "VIAIR, Kompressor, Druckluft, 330C, 33035, Offroad Kompressor, Continous, Kompressorkit, Constant Duty, VIAIR Constant Duty, Viair , Kompressor, Druckluftanlage, constant",
"5059dc45b5104c368cc2a7f890b80123": "VIAIR, Compressor, Compressed Air, 330C, 33035, Offroad Compressor"
},
"packUnit": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Set",
"5059dc45b5104c368cc2a7f890b80123": null
},
"packUnitPlural": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5059dc45b5104c368cc2a7f890b80123": null
},
"id": "daf2224ea71343979673763f5758de46",
"autoIncrement": 4933.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "08d2beb617754d2e9b8813e67fbd3a10"
}
],
"availableStock": 4,
"productNumber": "NAVIA-33035",
"ean": null,
"displayGroup": "f87eca5752ef51878f043d6744362c4a",
"sales": 0,
"stock": 4,
"weight": 5.5,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "01912bf65a18701ab5400991e8b02977",
"manufacturerNumber": null,
"deliveryTimeId": null,
"releaseDate": null,
"createdAt": "2021-06-16T00:00:00+00:00",
"categoryTree": [
"e95720b66e054265932a3d4f1d75ea24",
"5aa5729c95404d31837be01faa113843",
"574c8f322c8045ff901f4585c15cdcfb",
"57073e55ab544d4f8c23b2c9b8e7d21c",
"3a4903e587284a8fb136b1a53dec1421",
"6e94791f9ee443588d590c587c1202b8"
],
"categoriesRo": [
{
"id": "e95720b66e054265932a3d4f1d75ea24",
"_count": 1
},
{
"id": "5aa5729c95404d31837be01faa113843",
"_count": 1
},
{
"id": "574c8f322c8045ff901f4585c15cdcfb",
"_count": 1
},
{
"id": "57073e55ab544d4f8c23b2c9b8e7d21c",
"_count": 1
},
{
"id": "3a4903e587284a8fb136b1a53dec1421",
"_count": 1
},
{
"id": "6e94791f9ee443588d590c587c1202b8",
"_count": 1
}
],
"taxId": "d97cf5cff5d945aa8624948165e25887",
"tags": [
{
"id": "01917f485cef7a409544dca6df2593fc",
"name": "Verkaufsartikel",
"_count": 1
}
],
"parentId": null,
"coverId": "9f08687f2c3c49e28ed668547384d614",
"childCount": 0,
"categories": [
{
"id": "3a4903e587284a8fb136b1a53dec1421",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Druckluft",
"5059dc45b5104c368cc2a7f890b80123": "Compressed air"
}
},
{
"id": "6e94791f9ee443588d590c587c1202b8",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Air Supply",
"5059dc45b5104c368cc2a7f890b80123": "Air Supply"
}
}
],
"manufacturer": {
"id": "01912bf65a18701ab5400991e8b02977",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "VIAIR Corporation",
"5059dc45b5104c368cc2a7f890b80123": null
},
"_count": 1
},
"deliveryTime": {
"id": null,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5059dc45b5104c368cc2a7f890b80123": null
},
"_count": 1
},
"properties": [
{
"id": "018b5c9eba8f72798f1bfee38337f3de",
"_count": 1,
"groupId": "018b5c9e19117a4598d83f5b2f7ce5b0",
"group": {
"id": "018b5c9e19117a4598d83f5b2f7ce5b0",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Druckluft",
"5059dc45b5104c368cc2a7f890b80123": "Compressed air"
}
}
],
"options": [],
"categoryIds": [
"3a4903e587284a8fb136b1a53dec1421",
"6e94791f9ee443588d590c587c1202b8"
],
"optionIds": [],
"propertyIds": [
"018b5c9eba8f72798f1bfee38337f3de"
],
"tagIds": [
"01917f485cef7a409544dca6df2593fc"
],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"migration_MigrationSW501092023V_product_attr6": false,
"migration_MigrationSW501092023V_product_attr7": true,
"migration_MigrationSW501092023V_product_attr8": false,
"migration_MigrationSW501092023V_product_attr13": "'0'",
"migration_MigrationSW501092023V_product_attr14": false,
"migration_MigrationSW501092023V_product_attr15": false,
"migration_MigrationSW501092023V_product_attr16": true,
"migration_MigrationSW501092023V_product_attr19": false,
"migration_MigrationSW501092023V_product_icue_pseudoprice": 0.0,
"migration_MigrationSW501092023V_product_icue_min_order_exception": false,
"migration_MigrationSW501092023V_product_pixel_is_configurator": false,
"migration_MigrationSW501092023V_product_pixel_is_confianfrage": false,
"migration_MigrationSW501092023V_product_kilb_article_hider_is_hidden": false,
"migration_MigrationSW501092023V_product_kilb_article_hider_is_hidden_seo": false,
"icueproducts_allowlinks": true,
"twt_electric_pro_custom_field__product__custom_tab_text": "<ul class=\"content--list list--unstyled\"><li class=\"list--entry\"><a href=\"\/media\/25\/38\/a2\/1693556997\/33035_hg_datenblatt.pdf\" target=_blank\" rel=\"noopener\"> Datenblatt<\/a><\/li><\/ul>",
"migration_MigrationSW501092023V_product_custom_shippingtime_y3": "Leider k\u00f6nnen wir derzeit keinen Liefertermin nennen."
},
"5059dc45b5104c368cc2a7f890b80123": {
"migration_MigrationSW501092023V_product_pixel_is_confianfrage": false,
"migration_MigrationSW501092023V_product_pixel_is_configurator": false,
"migration_MigrationSW501092023V_product_custom_shippingtime_y3": "No new delivery date known",
"migration_MigrationSW501092023V_product_attr16": true
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "VIAIR Kompressor 330C-HG, 12V, zum Festeinbau",
"5059dc45b5104c368cc2a7f890b80123": "VIAIR 330C-HG 200 PSI compressor, 12 volts"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "VIAIR 330C-HG 200 PSI (13,8 bar), 12V CE-Kompressor\nSpezifikationen\/ technische Daten:\n\n12-Volt\nPermanentmagnetischer Motor\nEinschaltdauer: 100 % bei 100 PSI ( 6,9 bar )\nEinschaltdauer: 50% @ 200 PSI ( 13,8 bar)\nMax. Arbeitsdruck: 200 PSI\nMax. Lufttankgröße: 5,0 Gallonen (ca. 19L )\nMax. 12V Stromaufnahme: 14 Ampere\nSchutzart: IP67\nMax. Umgebungstemperatur: +158°F (70°C)\nMin. Umgebungstemperatur: -40°F (4°C)\nAbmessungen: 230mm L x 101mm B x 171mm H\nNettogewicht: 3,8 kg\n\nHyper Grade (HG) Verdichter sind speziell für die Befüllung von Druckluftbehältern konzipiert und verfügen über eine Kopfbaugruppe mit einem innovativen, patentierten Kopfdesign für eine bessere Wärmeableitung. Alle HG-Verdichter sind CE-zertifiziert und verfügen über hervorragende Dichtungseigenschaften gegenüber den Elementen. Zusätzlich sind alle HG-Verdichter mit einem separaten, aus Edelstahl geflochtenen und mit PTFE ausgekleideten Vorlaufschlauch und einer Rückschlagventilbaugruppe ausgestattet.\nMerkmale:\n\nThermischer Überlastschutz\nSchwingungsisolatoren\nBefestigungsmaterial\nHochbelastbares 1\/4″ NPT-Rückschlagventil\nEdelstahl geflochtener PTFE-ummantelter Führungsschlauch\nLuftleitung für fernmontierten Luftfilter\nFernmontierte Luftfilterbaugruppe\n(2) Ersatz-Luftfilterelemente\nMontageanleitung \n\nAdapter mit variablen Düsenführungen finden sie hier in unserem Shop. Die Adapter sind mit unseren VIAIR-Kompressoren kompatibel\nAnwendungshinweisFür weitere Anwendungsinformationen beachten Sie bitte das Produktdatenblatt",
"5059dc45b5104c368cc2a7f890b80123": "VIAIR 330C-HG 200 PSI (13.8 bar), 12V CE compressor\nSpecifications\/ technical data:\n\n12-volt\nPermanent magnet motor\nDuty cycle: 100% @ 100 PSI ( 6.9 bar )\nDuty cycle: 50% @ 200 PSI ( 13.8 bar )\nMax. Working pressure: 200 PSI\nMax. Air tank size: 5.0 gallons (approx. 19L )\nMax. 12V power consumption: 14 amps\nProtection class: IP67\nMax. Ambient temperature: +158°F (70°C)\nMin. ambient temperature: -40°F (4°C)\nDimensions: 230 mm L x 101 mm W x 171 mm H\nNet weight: 3.8kg\n\nHyper Grade (HG) compressors are specifically designed for filling air receivers and feature a head assembly with an innovative patented head design for better heat dissipation. All HG compressors are CE certified and have excellent sealing properties against the elements. In addition, all HG compressors are equipped with a separate stainless steel braided PTFE lined supply hose and check valve assembly.\n Features:\n\nThermal overload protection\nVibration isolators\nMounting hardware\nHeavy duty 1\/4″ NPT check valve\nStainless steel braided PTFE coated guide hose\nAir line for remote mounted air cleaner\nRemote mounted air filter assembly\n(2) Replacement air filter elements\nAssembly instructions\n\nAdapters with variable nozzle guides can be found here in our shop. The adapters are compatible with our VIAIR compressors.\nApplication noteFor further application information, please refer to the product data sheet"
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "\u25b7 VIAIR CE-Kompressor 330C-HG, 12V, zum Festeinbau - hier erh\u00e4ltlich!",
"5059dc45b5104c368cc2a7f890b80123": "\u25b7 VIAIR 330C-HG 200 PSI compressor - available here!"
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "\u21aa\ufe0f VIAIR 330C-HG 200 PSI (13,8 bar) Kompressor \u2714\ufe0f 12V \u2714\ufe0f 14 Ampere \u2714\ufe0f beste Qualit\u00e4t \u2714\ufe0f schneller Versand",
"5059dc45b5104c368cc2a7f890b80123": "\u21aa\ufe0f VIAIR 330C-HG 200 PSI compressor \u2714\ufe0f 12V \u2714\ufe0f 14 amps \u2714\ufe0f best quality \u2714\ufe0f fast shipping"
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": [
"VIAIR",
"Kompressor",
"Druckluft",
"330C",
" 33035",
"Offroad Kompressor",
"Continous",
"Kompressorkit",
"Constant Duty",
"VIAIR Constant Duty",
"Viair ",
"Kompressor",
"Druckluftanlage",
"constant"
],
"5059dc45b5104c368cc2a7f890b80123": [
"VIAIR",
"Compressor",
"Compressed Air",
"330C",
"33035",
"Offroad Compressor"
]
},
"cheapest_price_rule892bba83aadf4e539a3c6a1446af67c3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 529.0,
"cheapest_price_rule892bba83aadf4e539a3c6a1446af67c3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 444.5378,
"cheapest_price_rule1601200eea0d4bee8c49cc14788ea44b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 423.2,
"cheapest_price_rule1601200eea0d4bee8c49cc14788ea44b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 355.6303,
"cheapest_price_rule061ab606cc7f44b4857e9b27b6a71420_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 476.1,
"cheapest_price_rule061ab606cc7f44b4857e9b27b6a71420_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 400.084,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 529.0,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 444.5378,
"visibility_08d2beb617754d2e9b8813e67fbd3a10": 30,
"warehouseGroupStockField": {
"warehouse_group_stock": null,
"parent_warehouse_group_stock": null
},
"warehouseGroups": [
{
"id": null,
"_count": 0
}
],
"completion": [
{
"key": "all",
"value": "navia-33035"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "viair"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "kompressor"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "330c-hg,"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "12v,"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "zum"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "festeinbau"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "ce-kompressor"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "hier"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "erh\u00e4ltlich!"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "viair kompressor 330c-hg, 12v, zum festeinbau"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "\u25b7 viair ce-kompressor 330c-hg, 12v, zum festeinbau - hier erh\u00e4ltlich!"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "viair"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "330c-hg"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "200"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "psi"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "compressor,"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "volts"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "compressor"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "available"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "here!"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "viair 330c-hg 200 psi compressor, 12 volts"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "\u25b7 viair 330c-hg 200 psi compressor - available here!"
}
]
},
"fields": {
"displayGroup": [
"f87eca5752ef51878f043d6744362c4a"
]
},
"sort": [
0,
"daf2224ea71343979673763f5758de46"
]
}
]
},
"aggregations": {
"total-count": {
"value": 33
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
1.61 ms |
Request:
{"index":"dev_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"term":{"active":true}},{"range":{"visibility_08d2beb617754d2e9b8813e67fbd3a10":{"gte":30}}}]}},{"term":{"categoryTree":"3a4903e587284a8fb136b1a53dec1421"}},{"exists":{"field":"displayGroup"}},{"bool":{"must_not":[{"bool":{"must":[{"term":{"isCloseout":true}},{"term":{"available":false}}]}}]}}]}}]}},"aggregations":{"manufacturer":{"terms":{"field":"manufacturerId","size":10000}},"price":{"stats":{"script":{"source":"double getPrice(def accessors, def doc, def decimals, def round, def multiplier) {\n for (accessor in accessors) {\n def key = accessor['key'];\n\n if (!doc.containsKey(key) || doc[key].empty) {\n continue;\n }\n\n def factor = accessor['factor'];\n def value = doc[key].value * factor;\n\n value = Math.round(value * decimals);\n value = (double) value \/ decimals;\n\n if (!round) {\n return (double) value;\n }\n\n value = Math.round(value * multiplier);\n\n value = (double) value \/ multiplier;\n\n return (double) value;\n }\n\n return 0;\n}\n\nreturn getPrice(params['accessors'], doc, params['decimals'], params['round'], params['multiplier']);\n","lang":"painless","params":{"accessors":[{"key":"cheapest_price_rule76a1b37a7dbf4165b46c7ab2ff1a4841_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule56b8897938be44a48f5d23076fee8aa4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179b5053d723cbcc2ffca7e2f1d37_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179b50593737ca9f4a6695a28df19_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179b505a971d6b33bc2b7f77ff188_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179b50779728dbd34b221819dbf1f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179b5077e722793b82b3113582988_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019266bd95457bad916f0e7402a76e90_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule89396462b19442de853b499f33b78cef_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule8a3d72aab5a5468fa089505163f644f9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulef9da93f84ada4ccd8efd95692a615991_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule06c3e6c40cde40fb88ada175db3b7938_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed59dd72ecb5248c3701a4a9a7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5a33735dadfaae7d48ee3774_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5a7373caa742a3ca2b474faa_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5abc7260ba0d7f86a5f49012_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5ae473cc8acbdbd09e697f1a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5afd73938316ce5d62b21885_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5b3472fb8689bff52c36d24e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5b47710cbb88d4cabe575530_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5b657021952452aa52c2f262_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5b887386bf07cbfb0c6dc4d9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5bb77063b42436de2bb2654d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5be971dfb78ef0b9ab954636_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5c0f732b83a6fa611b17c9b0_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5c1c72e1bd5dd45fa91ae988_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5c48709db0bb1d772acb893a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5c61739288a8f19f5fee5c9f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5c83710a9f725ed88fa40977_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5cb47127996aaac8a7f6bdbe_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5ce97102b94464fe862ca787_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5d78715b957280e0dd517331_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5e047192aaa473cfc729c45f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5e987014b27850d1f01683cb_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5eb972a9811e6559447a6fdc_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5f01707fbf3a6adca420f5b1_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5f4a728eb343c4ceca55df24_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5fc1716ab9e26008508a989e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed601171ca8bcbf7c4e4b15d12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed604073a8a7cc7283597bc561_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed6086727a8ed87d86b79ab028_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed60bb7173b3c5caa2b21a03e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed611b719b8c493426397e071b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed616973d6ae87df29ca6fab45_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed617970548b9ab2028aaccee3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed61d27021a6d3f256f1fe6301_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed6233707282cee72b0a78165c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed629f739f81ef49fbfd3175b8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed630d72bfb80b0b616e56f094_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed632870c88f4d50e0091bdc8d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed6337724eaaf100fe723a9c73_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed63797281ae1e4a20fee27b7e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed63a670b0b0b52d88b864e4db_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed63dc70b69dd94cbfea630307_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed63ff71859ac60b2064da4af9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule892bba83aadf4e539a3c6a1446af67c3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1}],"decimals":100,"round":true,"multiplier":100.0}}}},"rating-exists":{"filter":{"range":{"ratingAverage":{"gte":0.0}}},"aggregations":{"rating":{"max":{"field":"ratingAverage"}}}},"shipping-free-filter":{"filter":{"term":{"shippingFree":true}},"aggregations":{"shipping-free":{"max":{"field":"shippingFree"}}}},"properties":{"nested":{"path":"properties"},"aggregations":{"properties":{"terms":{"field":"properties.id","size":10000}}}},"options":{"nested":{"path":"options"},"aggregations":{"options":{"terms":{"field":"options.id","size":10000}}}}},"size":0,"timeout":"5s"},"search_type":"query_then_fetch"}
POST http://localhost:9200/dev_product/_search?track_total_hits=0&search_type=query_then_fetch
Accept: application/json
Content-Type: application/json
{
"query": {
"bool": {
"filter": [
{
"bool": {
"must": [
{
"bool": {
"must": [
{
"term": {
"active": true
}
},
{
"range": {
"visibility_08d2beb617754d2e9b8813e67fbd3a10": {
"gte": 30
}
}
}
]
}
},
{
"term": {
"categoryTree": "3a4903e587284a8fb136b1a53dec1421"
}
},
{
"exists": {
"field": "displayGroup"
}
},
{
"bool": {
"must_not": [
{
"bool": {
"must": [
{
"term": {
"isCloseout": true
}
},
{
"term": {
"available": false
}
}
]
}
}
]
}
}
]
}
}
]
}
},
"aggregations": {
"manufacturer": {
"terms": {
"field": "manufacturerId",
"size": 10000
}
},
"price": {
"stats": {
"script": {
"source": "double getPrice(def accessors, def doc, def decimals, def round, def multiplier) {\n for (accessor in accessors) {\n def key = accessor['key'];\n\n if (!doc.containsKey(key) || doc[key].empty) {\n continue;\n }\n\n def factor = accessor['factor'];\n def value = doc[key].value * factor;\n\n value = Math.round(value * decimals);\n value = (double) value \/ decimals;\n\n if (!round) {\n return (double) value;\n }\n\n value = Math.round(value * multiplier);\n\n value = (double) value \/ multiplier;\n\n return (double) value;\n }\n\n return 0;\n}\n\nreturn getPrice(params['accessors'], doc, params['decimals'], params['round'], params['multiplier']);\n",
"lang": "painless",
"params": {
"accessors": [
{
"key": "cheapest_price_rule76a1b37a7dbf4165b46c7ab2ff1a4841_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule56b8897938be44a48f5d23076fee8aa4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179b5053d723cbcc2ffca7e2f1d37_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179b50593737ca9f4a6695a28df19_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179b505a971d6b33bc2b7f77ff188_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179b50779728dbd34b221819dbf1f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179b5077e722793b82b3113582988_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019266bd95457bad916f0e7402a76e90_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule89396462b19442de853b499f33b78cef_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule8a3d72aab5a5468fa089505163f644f9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rulef9da93f84ada4ccd8efd95692a615991_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule06c3e6c40cde40fb88ada175db3b7938_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed59dd72ecb5248c3701a4a9a7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5a33735dadfaae7d48ee3774_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5a7373caa742a3ca2b474faa_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5abc7260ba0d7f86a5f49012_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5ae473cc8acbdbd09e697f1a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5afd73938316ce5d62b21885_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5b3472fb8689bff52c36d24e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5b47710cbb88d4cabe575530_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5b657021952452aa52c2f262_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5b887386bf07cbfb0c6dc4d9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5bb77063b42436de2bb2654d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5be971dfb78ef0b9ab954636_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5c0f732b83a6fa611b17c9b0_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5c1c72e1bd5dd45fa91ae988_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5c48709db0bb1d772acb893a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5c61739288a8f19f5fee5c9f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5c83710a9f725ed88fa40977_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5cb47127996aaac8a7f6bdbe_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5ce97102b94464fe862ca787_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5d78715b957280e0dd517331_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5e047192aaa473cfc729c45f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5e987014b27850d1f01683cb_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5eb972a9811e6559447a6fdc_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5f01707fbf3a6adca420f5b1_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5f4a728eb343c4ceca55df24_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5fc1716ab9e26008508a989e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed601171ca8bcbf7c4e4b15d12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed604073a8a7cc7283597bc561_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed6086727a8ed87d86b79ab028_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed60bb7173b3c5caa2b21a03e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed611b719b8c493426397e071b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed616973d6ae87df29ca6fab45_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed617970548b9ab2028aaccee3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed61d27021a6d3f256f1fe6301_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed6233707282cee72b0a78165c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed629f739f81ef49fbfd3175b8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed630d72bfb80b0b616e56f094_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed632870c88f4d50e0091bdc8d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed6337724eaaf100fe723a9c73_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed63797281ae1e4a20fee27b7e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed63a670b0b0b52d88b864e4db_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed63dc70b69dd94cbfea630307_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed63ff71859ac60b2064da4af9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule892bba83aadf4e539a3c6a1446af67c3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
}
],
"decimals": 100,
"round": true,
"multiplier": 100.0
}
}
}
},
"rating-exists": {
"filter": {
"range": {
"ratingAverage": {
"gte": 0.0
}
}
},
"aggregations": {
"rating": {
"max": {
"field": "ratingAverage"
}
}
}
},
"shipping-free-filter": {
"filter": {
"term": {
"shippingFree": true
}
},
"aggregations": {
"shipping-free": {
"max": {
"field": "shippingFree"
}
}
}
},
"properties": {
"nested": {
"path": "properties"
},
"aggregations": {
"properties": {
"terms": {
"field": "properties.id",
"size": 10000
}
}
}
},
"options": {
"nested": {
"path": "options"
},
"aggregations": {
"options": {
"terms": {
"field": "options.id",
"size": 10000
}
}
}
}
},
"size": 0,
"timeout": "5s"
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|