| 1 |
8.15 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":"cc09ce4a89be4cfd82f59a0a34f0cee4"}},{"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": 3,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 63,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "dev_product_1762781623",
"_id": "eedd81d79fa24a548fb91326020453e5",
"_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": "4465a820f6084068885d53b3648dcf3a",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "\u00c4hnliche Artikel"
}
},
{
"id": "3f74269df54d4ec8b13cdfb290817e3c",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Das k\u00f6nnte Sie auch interessieren"
}
}
],
"keywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kippschalter, Wippenschalter, Kontrollleuchte, Kontrollbeleuchtung, ON\/OFF, Rocker Switch ",
"5059dc45b5104c368cc2a7f890b80123": "Toggle switch, rocker switch, pilot light, pilot light, ON\/OFF, rocker switch"
},
"packUnit": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "St\u00fcck",
"5059dc45b5104c368cc2a7f890b80123": "Piece"
},
"packUnitPlural": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5059dc45b5104c368cc2a7f890b80123": null
},
"id": "eedd81d79fa24a548fb91326020453e5",
"autoIncrement": 5091.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "08d2beb617754d2e9b8813e67fbd3a10"
}
],
"availableStock": 444,
"productNumber": "WSMBBS",
"ean": null,
"displayGroup": "d6518cd3a882e4a388dbf9865b21a0bb",
"sales": 0,
"stock": 444,
"weight": 0.1,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "1843652dadb745df81d87fa1d5b929a7",
"manufacturerNumber": null,
"deliveryTimeId": null,
"releaseDate": null,
"createdAt": "2021-07-16T00:00:00+00:00",
"categoryTree": [
"574c8f322c8045ff901f4585c15cdcfb",
"86699840fae64a0fa47ff448d7ba6858",
"e95720b66e054265932a3d4f1d75ea24",
"f5748d2faf1a4e9a8a9c6303ce81181d",
"ade8a3c3d01a4a9598e54e48ec91945f",
"cc09ce4a89be4cfd82f59a0a34f0cee4"
],
"categoriesRo": [
{
"id": "574c8f322c8045ff901f4585c15cdcfb",
"_count": 1
},
{
"id": "86699840fae64a0fa47ff448d7ba6858",
"_count": 1
},
{
"id": "e95720b66e054265932a3d4f1d75ea24",
"_count": 1
},
{
"id": "f5748d2faf1a4e9a8a9c6303ce81181d",
"_count": 1
},
{
"id": "ade8a3c3d01a4a9598e54e48ec91945f",
"_count": 1
},
{
"id": "cc09ce4a89be4cfd82f59a0a34f0cee4",
"_count": 1
}
],
"taxId": "d97cf5cff5d945aa8624948165e25887",
"tags": [
{
"id": "01917f485cef7a409544dca6df2593fc",
"name": "Verkaufsartikel",
"_count": 1
}
],
"parentId": null,
"coverId": "ad3b2423521d4ead941581135f096a79",
"childCount": 0,
"categories": [
{
"id": "ade8a3c3d01a4a9598e54e48ec91945f",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Switches",
"5059dc45b5104c368cc2a7f890b80123": "Switches"
}
},
{
"id": "cc09ce4a89be4cfd82f59a0a34f0cee4",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Schalter, Blenden und Konsolen",
"5059dc45b5104c368cc2a7f890b80123": "Switches, Panels and Consoles"
}
}
],
"manufacturer": {
"id": "1843652dadb745df81d87fa1d5b929a7",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nakatanenga",
"5059dc45b5104c368cc2a7f890b80123": null
},
"_count": 1
},
"deliveryTime": {
"id": null,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5059dc45b5104c368cc2a7f890b80123": null
},
"_count": 1
},
"properties": [
{
"id": "018b5cb1803b777a845ebf1627f20f3d",
"_count": 1,
"groupId": "018b5cb0152a78fca8a63153b7b997d0",
"group": {
"id": "018b5cb0152a78fca8a63153b7b997d0",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Schalter, Blenden und Konsolen",
"5059dc45b5104c368cc2a7f890b80123": "Switches, panels and consoles"
}
}
],
"options": [],
"categoryIds": [
"ade8a3c3d01a4a9598e54e48ec91945f",
"cc09ce4a89be4cfd82f59a0a34f0cee4"
],
"optionIds": [],
"propertyIds": [
"018b5cb1803b777a845ebf1627f20f3d"
],
"tagIds": [
"01917f485cef7a409544dca6df2593fc"
],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"migration_MigrationSW501092023V_product_attr1": "0",
"migration_MigrationSW501092023V_product_attr2": "0",
"migration_MigrationSW501092023V_product_attr8": false,
"migration_MigrationSW501092023V_product_attr13": "'0'",
"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_deposit": 0.0,
"migration_MigrationSW501092023V_product_kilb_article_hider_is_hidden": false,
"migration_MigrationSW501092023V_product_kilb_article_hider_is_hidden_seo": false,
"icueproducts_allowlinks": true,
"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": "ON\/OFF Schalter mit Kontrollbeleuchtung",
"5059dc45b5104c368cc2a7f890b80123": "ON\/OFF switch with control light"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Schalter ON\/OFF mit Kontrollbeleuchtung in Einbaugeh\u00e4use, rund\nON\/OFF Schalter mit roter Kontrollbeleuchtung in rundem Einbaugeh\u00e4use.Der Schalter kann auch einfach gegen unsere Wippenschalter mit Auffindbeleuchtung oder andere Wippenschalter in diesem Format getauscht werden.\nBelastbarkeit: 12V 10A \/ 24V 6ALochdurchmesser Bohrung: 29mm",
"5059dc45b5104c368cc2a7f890b80123": "ON\/OFF switch with pilot light in round recessed housing\nON\/OFF switch with red control light in round installation housing.The switch can also be easily exchanged for our rocker switches with location lighting or other rocker switches in this format.Load capacity: 12V 10A \/ 24V 6AHole diameter bore: 29mm"
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "\u25b7 ON\/OFF Schalter mit Kontrollbeleuchtung",
"5059dc45b5104c368cc2a7f890b80123": "\u25b7 ON\/OFF switch with indicator light"
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "\u21aa\ufe0f Schalter in Einbaugeh\u00e4use \u2714\ufe0f Belastbarkeit: 12V 10A \/ 24V 6A \u2714\ufe0f Lochdurchmesser Bohrung: 29mm \u2714\ufe0f mit roter Kontrollbeleuchtung",
"5059dc45b5104c368cc2a7f890b80123": "\u21aa\ufe0f\ufe0f Switch in installation housing \u2714\ufe0f Load capacity: 12V 10A \/ 24V 6A \u2714\ufe0f Hole diameter bore: 29mm \u2714\ufe0f With red indicator light"
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": [
"Kippschalter",
"Wippenschalter",
"Kontrollleuchte",
"Kontrollbeleuchtung",
"ON\/OFF",
"Rocker Switch "
],
"5059dc45b5104c368cc2a7f890b80123": [
"Toggle switch",
"rocker switch",
"pilot light",
"pilot light",
"ON\/OFF",
"rocker switch"
]
},
"cheapest_price_rule892bba83aadf4e539a3c6a1446af67c3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 10.0,
"cheapest_price_rule892bba83aadf4e539a3c6a1446af67c3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 8.4034,
"cheapest_price_rule1601200eea0d4bee8c49cc14788ea44b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 9.0,
"cheapest_price_rule1601200eea0d4bee8c49cc14788ea44b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 7.563,
"cheapest_price_rule061ab606cc7f44b4857e9b27b6a71420_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 9.5,
"cheapest_price_rule061ab606cc7f44b4857e9b27b6a71420_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 7.9832,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 10.0,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 8.4034,
"visibility_08d2beb617754d2e9b8813e67fbd3a10": 30,
"warehouseGroupStockField": {
"warehouse_group_stock": null,
"parent_warehouse_group_stock": null
},
"warehouseGroups": [
{
"id": null,
"_count": 0
}
],
"completion": [
{
"key": "all",
"value": "wsmbbs"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "on\/off"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "schalter"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "mit"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "kontrollbeleuchtung"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "on\/off schalter mit kontrollbeleuchtung"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "\u25b7 on\/off schalter mit kontrollbeleuchtung"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "on\/off"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "switch"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "with"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "control"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "light"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "indicator"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "on\/off switch with control light"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "\u25b7 on\/off switch with indicator light"
}
]
},
"fields": {
"displayGroup": [
"d6518cd3a882e4a388dbf9865b21a0bb"
]
},
"sort": [
0,
"eedd81d79fa24a548fb91326020453e5"
]
}
]
},
"aggregations": {
"total-count": {
"value": 33
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
4.66 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":"cc09ce4a89be4cfd82f59a0a34f0cee4"}},{"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": "cc09ce4a89be4cfd82f59a0a34f0cee4"
}
},
{
"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"
}
{
"took": 1,
"timed_out": false,
"terminated_early": true,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"max_score": null,
"hits": []
},
"aggregations": {
"shipping-free-filter": {
"doc_count": 0,
"shipping-free": {
"value": null
}
},
"rating-exists": {
"doc_count": 63,
"rating": {
"value": 0.0
}
},
"price": {
"count": 63,
"min": 1.5,
"max": 699.0,
"avg": 55.300000000000004,
"sum": 3483.9
},
"options": {
"doc_count": 38,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "018e79df473a7342b72835c3eceb0387",
"doc_count": 1
},
{
"key": "018e79df4744716f81eb0c31aa3e971b",
"doc_count": 1
},
{
"key": "018e79dfe74a704882da2a871d3d78d1",
"doc_count": 1
},
{
"key": "018e79dfe750722aa52409b9d73ebd40",
"doc_count": 1
},
{
"key": "018e79dfe755708db2dfe8cfeb03704d",
"doc_count": 1
},
{
"key": "018e79dfe75c73ffaa5035033a7ff853",
"doc_count": 1
},
{
"key": "018e79dfe76173e5a7800149e31d7c44",
"doc_count": 1
},
{
"key": "018e79dfe76770a58285166d9b445dd4",
"doc_count": 1
},
{
"key": "018e79dfe76d7244b08404f98c0e58c1",
"doc_count": 1
},
{
"key": "018e79dfe772735496768f54f8fe1b90",
"doc_count": 1
},
{
"key": "018e79dfe778711d8498967966c38148",
"doc_count": 1
},
{
"key": "018e79dfe77e7131a42dbdefcc795d4e",
"doc_count": 1
},
{
"key": "018e79dfe7837106b6f16f56c9a31be6",
"doc_count": 1
},
{
"key": "018e79dfe78870ba8647b5f2785241c6",
"doc_count": 1
},
{
"key": "018e79dfe78e714ebca53e84e2df140a",
"doc_count": 1
},
{
"key": "018e79dfe79370378f211d57ac2fce1f",
"doc_count": 1
},
{
"key": "018e79dfe799734bafb8c20b88b20a2b",
"doc_count": 1
},
{
"key": "018e79dfe79e72bfb6c844eb66abae86",
"doc_count": 1
},
{
"key": "018e79dfe7a4701a8e2196e3b24356a0",
"doc_count": 1
},
{
"key": "019540a3f4dd716a8175cca2da7515df",
"doc_count": 1
},
{
"key": "019540a44360793196a1a1e7fc0c2888",
"doc_count": 1
},
{
"key": "019540b3d68c7089a4f9d2ba1016f595",
"doc_count": 1
},
{
"key": "019540b44cdb747a81fef015a966fdcc",
"doc_count": 1
},
{
"key": "049a4d7f79c94bfe841374459c271b8d",
"doc_count": 1
},
{
"key": "0d784a285c334109ac26e4b9931aa9fb",
"doc_count": 1
},
{
"key": "194ae6dd28d641958da3216639cfa0f0",
"doc_count": 1
},
{
"key": "5648adcf0a7b4fb5a83c9f2e9b77b746",
"doc_count": 1
},
{
"key": "5d6d660be7794f0d93bcdf37f182b14e",
"doc_count": 1
},
{
"key": "63e96af82ebb49888c7defd01d2e0a0f",
"doc_count": 1
},
{
"key": "6f1a0dafb6e34f02996bc91f71487583",
"doc_count": 1
},
{
"key": "71c1bc54164c4596bf9c8f53781425f1",
"doc_count": 1
},
{
"key": "7e23da88b33640e2abbb07a53f627b4d",
"doc_count": 1
},
{
"key": "933ab837c18240b68e28139355fb69c5",
"doc_count": 1
},
{
"key": "966a62cc0f7e4a31ac516d1800dc7a04",
"doc_count": 1
},
{
"key": "b4a0eccb9c5041a7864b07b680713189",
"doc_count": 1
},
{
"key": "b8882bf9e3ab42fa84fd197d916714bc",
"doc_count": 1
},
{
"key": "ba67430238494a46aa4f79f487bc085c",
"doc_count": 1
},
{
"key": "d74b9a2ba04d45ef90653d7481f5a8a3",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 82,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "018b5cb1803b777a845ebf1627f20f3d",
"doc_count": 62
},
{
"key": "018b5cb1353b754886d14d0540bbc56f",
"doc_count": 5
},
{
"key": "018b00438f8c7dffbc38f1aa32164fc0",
"doc_count": 4
},
{
"key": "018b5cb626787905854f2a07a5afe8b9",
"doc_count": 4
},
{
"key": "018b0fdf321376aa82e38344ff570ea1",
"doc_count": 1
},
{
"key": "018b0fe15962778589c85e1e5d228a29",
"doc_count": 1
},
{
"key": "018b25206da97114858eab187ca02781",
"doc_count": 1
},
{
"key": "018b292041fe7ddfb97be724934ae0b7",
"doc_count": 1
},
{
"key": "018b5caa8a76725ab7b3bcf1e1169093",
"doc_count": 1
},
{
"key": "018b5cb0d21f7094b2f518701699bf00",
"doc_count": 1
},
{
"key": "018ea5552e467fa381d4c04b3168dbeb",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "1843652dadb745df81d87fa1d5b929a7",
"doc_count": 40
},
{
"key": "01912bf624547219aefd61928c1e6053",
"doc_count": 18
},
{
"key": "01912bf64d667086b993d6c8d05cc6bc",
"doc_count": 2
},
{
"key": "01912bf678aa717fb0abb84af5a168f9",
"doc_count": 2
},
{
"key": "01912bf6c70a73a7b84941f3f2ac4e1d",
"doc_count": 1
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|