Symfony Profiler

Query Metrics

12.00 ms Query Time

1 Node(s)

195 Indices

Queries

#▲ Execution Time Info

8.70 ms

#▲	Execution Time	Info
1	8.70 ms	Request: {"index":"sw_dev_product","search_type":"query_then_fetch","track_total_hits":true,"body":{"post_filter":{"bool":{"filter":[{"bool":{"must":[{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["89ee44dcf85c46718ba0744360e5fcc1"]}}}}]}}]}},{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["3adaca5df47943339a045e91f212ee90","b2e857ff4b84401caef408741cc18d83","2e9dc36608504cd0bd340d135922df23","87c89b5844a0436db7e7bebadfa24d5f","1339fc04d1b14eedae5c6cb1269b34af","b78d026c06064f24b92e69b8e1feadb0","eb1bb24fb4a64c9295a69f327f7a5899","b69d2b1c914342ecb0a0ba8cc0980393","4e33f457de524946ab593df85fba15ed"]}}}}]}}]}},{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["a2e3ce1f6e7241a783db0a98b0003a84"]}}}}]}}]}}]}}]}},"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"0189b5bd293f71c6a5e92e9980f13639"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"bbc37dc21df04d55a654a66af971f895"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}},{"bool":{"must_not":[{"bool":{"must":[{"term":{"isCloseout":true}},{"term":{"available":false}}]}}]}}]}}]}},"sort":[{"stock":{"order":"DESC"}},{"productNumber":{"order":"ASC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-filtered-count":{"filter":{"bool":{"must":[{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["89ee44dcf85c46718ba0744360e5fcc1"]}}}}]}}]}},{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["3adaca5df47943339a045e91f212ee90","b2e857ff4b84401caef408741cc18d83","2e9dc36608504cd0bd340d135922df23","87c89b5844a0436db7e7bebadfa24d5f","1339fc04d1b14eedae5c6cb1269b34af","b78d026c06064f24b92e69b8e1feadb0","eb1bb24fb4a64c9295a69f327f7a5899","b69d2b1c914342ecb0a0ba8cc0980393","4e33f457de524946ab593df85fba15ed"]}}}}]}}]}},{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["a2e3ce1f6e7241a783db0a98b0003a84"]}}}}]}}]}}]}},"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}}}},"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"}} Item count: 5 View formatted request View formatted response View query backtrace POST http://10.20.0.3:9200/sw_dev_product/_search?search_type=query_then_fetch&track_total_hits=1 Accept: application/json Content-Type: application/json { "post_filter": { "bool": { "filter": [ { "bool": { "must": [ { "bool": { "should": [ { "bool": { "must_not": [ { "nested": { "path": "categories", "query": { "terms": { "categories.id": [ "89ee44dcf85c46718ba0744360e5fcc1" ] } } } } ] } } ] } }, { "bool": { "should": [ { "bool": { "must_not": [ { "nested": { "path": "categories", "query": { "terms": { "categories.id": [ "3adaca5df47943339a045e91f212ee90", "b2e857ff4b84401caef408741cc18d83", "2e9dc36608504cd0bd340d135922df23", "87c89b5844a0436db7e7bebadfa24d5f", "1339fc04d1b14eedae5c6cb1269b34af", "b78d026c06064f24b92e69b8e1feadb0", "eb1bb24fb4a64c9295a69f327f7a5899", "b69d2b1c914342ecb0a0ba8cc0980393", "4e33f457de524946ab593df85fba15ed" ] } } } } ] } } ] } }, { "bool": { "should": [ { "bool": { "must_not": [ { "nested": { "path": "categories", "query": { "terms": { "categories.id": [ "a2e3ce1f6e7241a783db0a98b0003a84" ] } } } } ] } } ] } } ] } } ] } }, "query": { "bool": { "filter": [ { "bool": { "must": [ { "bool": { "must": [ { "nested": { "path": "visibilities", "query": { "bool": { "must": [ { "range": { "visibilities.visibility": { "gte": 30 } } }, { "term": { "visibilities.salesChannelId": "0189b5bd293f71c6a5e92e9980f13639" } } ] } } } }, { "term": { "active": true } } ] } }, { "nested": { "path": "categoriesRo", "query": { "term": { "categoriesRo.id": "bbc37dc21df04d55a654a66af971f895" } } } }, { "bool": { "must_not": [ { "bool": { "must_not": [ { "exists": { "field": "displayGroup" } } ] } } ] } }, { "bool": { "must_not": [ { "bool": { "must": [ { "term": { "isCloseout": true } }, { "term": { "available": false } } ] } } ] } } ] } } ] } }, "sort": [ { "stock": { "order": "DESC" } }, { "productNumber": { "order": "ASC" } }, { "id": { "order": "ASC" } } ], "aggregations": { "total-filtered-count": { "filter": { "bool": { "must": [ { "bool": { "should": [ { "bool": { "must_not": [ { "nested": { "path": "categories", "query": { "terms": { "categories.id": [ "89ee44dcf85c46718ba0744360e5fcc1" ] } } } } ] } } ] } }, { "bool": { "should": [ { "bool": { "must_not": [ { "nested": { "path": "categories", "query": { "terms": { "categories.id": [ "3adaca5df47943339a045e91f212ee90", "b2e857ff4b84401caef408741cc18d83", "2e9dc36608504cd0bd340d135922df23", "87c89b5844a0436db7e7bebadfa24d5f", "1339fc04d1b14eedae5c6cb1269b34af", "b78d026c06064f24b92e69b8e1feadb0", "eb1bb24fb4a64c9295a69f327f7a5899", "b69d2b1c914342ecb0a0ba8cc0980393", "4e33f457de524946ab593df85fba15ed" ] } } } } ] } } ] } }, { "bool": { "should": [ { "bool": { "must_not": [ { "nested": { "path": "categories", "query": { "terms": { "categories.id": [ "a2e3ce1f6e7241a783db0a98b0003a84" ] } } } } ] } } ] } } ] } }, "aggregations": { "total-count": { "cardinality": { "field": "displayGroup" } } } } }, "from": 0, "size": 24, "collapse": { "field": "displayGroup" }, "timeout": "5s" } { "took": 2, "timed_out": false, "_shards": { "total": 3, "successful": 3, "skipped": 0, "failed": 0 }, "hits": { "total": { "value": 5, "relation": "eq" }, "max_score": null, "hits": [ { "_index": "sw_dev_product_1747138014", "_id": "0189b5cf228872a2b310bf8571f615f0", "_score": null, "_source": { "purchasePrices": [ { "currencyId": "b7d2554b0ce847cd82f3ac9bd1c0dfca", "net": 105.1255, "gross": 125.0993, "linked": true, "listPrice": null } ], "referenceUnit": "0.000", "purchaseUnit": "1.0000", "unit": { "id": "0189b5cf096972eba234380aea82e89d", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "St\u00fcck" }, "shortCode": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Stck." }, "_count": 1 }, "crossSellings": [], "keywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "packUnit": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "St\u00fcck" }, "packUnitPlural": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "id": "0189b5cf228872a2b310bf8571f615f0", "autoIncrement": 2409.0, "ratingAverage": 5.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "0189b5bd293f71c6a5e92e9980f13639" } ], "availableStock": 10, "productNumber": "ja-sp-019030.20", "ean": "251019030.20N21C27000090B2A11210914", "displayGroup": "0828c04e05801c11350186f8613c4964", "sales": 1380, "stock": 10, "weight": 0.36, "width": 200.0, "length": 150.0, "height": 50.0, "manufacturerId": "0189b5ceebb7734e990b1e31a9c8ab89", "manufacturerNumber": "19030.20", "releaseDate": null, "createdAt": "2020-02-07T00:00:00+00:00", "categoryTree": [ "ed73937c1fc54757a390ffc31536aa0d", "d7b7b163000841a1876dbff5548c039f", "1e866cbbceb14718b0fc586a82f9bf19", "35dc90db760345fdb823f8a798b7f5ad", "63479e3c30e44bb2b075ea822bec5cb5", "bbc37dc21df04d55a654a66af971f895" ], "categoriesRo": [ { "id": "ed73937c1fc54757a390ffc31536aa0d", "_count": 1 }, { "id": "d7b7b163000841a1876dbff5548c039f", "_count": 1 }, { "id": "1e866cbbceb14718b0fc586a82f9bf19", "_count": 1 }, { "id": "35dc90db760345fdb823f8a798b7f5ad", "_count": 1 }, { "id": "63479e3c30e44bb2b075ea822bec5cb5", "_count": 1 }, { "id": "bbc37dc21df04d55a654a66af971f895", "_count": 1 } ], "taxId": "0189b5bc757f71079ecf17a5e531d81e", "tags": [], "parentId": null, "coverId": "0eaccecf87684d5cb29cbcc3874fc76e", "childCount": 0, "categories": [ { "id": "63479e3c30e44bb2b075ea822bec5cb5", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "8079 - Honeywell" } }, { "id": "bbc37dc21df04d55a654a66af971f895", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sperrelemente" } } ], "manufacturer": { "id": "0189b5ceebb7734e990b1e31a9c8ab89", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Honeywell", "0189b5bd28fd735a9afc1ef90696fc66": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "63479e3c30e44bb2b075ea822bec5cb5", "bbc37dc21df04d55a654a66af971f895" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": { "attr3": "[]", "attr5": "[]", "attr6": "159.0000000000", "attr7": "[]", "attr9": "{\"shipping\":null,\"quantity\":0,\"cuttedCount\":0,\"available\":10,\"deliveries\":[],\"warehouses\":[]}", "jtlorder": "20", "releasedate": "22.12.2022", "tarcode": "39269097" } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "JA-SP-019030.20", "0189b5bd28fd735a9afc1ef90696fc66": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Das elektromechanische Sperrelement JA-SP-019030.20 dient zum Verriegeln von T\u00fcren und Zug\u00e4ngen. Durch das Sperrelement kann z.B. der Zugang zu einem gesicherten Bereich mechanisch blockiert und verhindert werden. Die Funktion des Sperrelement k\u00f6nnen \u00fcber das JA 100 Alarmsystem programmiert werden.Diese Sperrelement kann direkt in den T\u00fcrrahmen \/ Zarge eingebaut werden. Zur Montage auf der T\u00fcr \/ Zarge stehen Aufbaugeh\u00e4use zur Verf\u00fcgung. Bitte beachten Sie die Montage- und Einbauanleitung.\nLeistungsmerkmale:\n\nMontage im T\u00fcrrahmen mit Gegenst\u00fcck im T\u00fcrblatt\nAnsteuerung kann dynamisch oder statisch erfolgen\nelektrische sowie mechanische Notentriegelung m\u00f6glich\nHalbleiterausg\u00e4nge f\u00fcr Endstellungen\n\nTechnische Daten:\n\nBetriebsnennspannung: 12 V DC\nBetriebsspannungsbereich: 9 V bis 15 V DC\nStromaufnahme in Ruhe: 4 mA\nmittlere Stromaufnahme: ca. 130 mA, max. 0,6 sec.\nStrombelastbarkeit Ausg\u00e4nge: max. 20 mA (high aktiv)\nBetriebstemperaturbereich: -25 \u00b0C bis +55 \u00b0C\n\nMechanische Daten:\n\nEinbaulage: beliebig\nAnschlussleitung: 4 m\nAbmessungen (B x H x T): 18 x 140 x 32 mm\nVerschlussbolzen: \u00f8 8,0 mm (austauschbar)\nVerschlussbolzenweg: mind. 10 mm\nStulp Standardma\u00df: 20 x 2 x 188 mm (austauschbar)\n", "0189b5bd28fd735a9afc1ef90696fc66": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "JA-SP-019030.20 Sperrelement \| Honeywell Zubeh\u00f6r \| EPS", "0189b5bd28fd735a9afc1ef90696fc66": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Das elektromechanische Sperrelement JA-SP-019030.20 Honeywell dient zum Verriegeln von T\u00fcren und Zug\u00e4ngen.", "0189b5bd28fd735a9afc1ef90696fc66": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": [ "Sperrelement", "Honeywell", "8079 - Honeywell", "Sperrelemente" ], "0189b5bd28fd735a9afc1ef90696fc66": null }, "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 164.22, "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 138.0, "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 164.22, "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 138.0, "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 164.22, "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 138.0, "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 236.81, "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 199.0, "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 164.22, "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 138.0, "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 144.0798, "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 121.0755, "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 164.22, "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 138.0, "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 164.22, "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 138.0, "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 236.81, "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 199.0, "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 164.22, "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 138.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 236.81, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 199.0, "jtlorder": 20, "custom_numbers": [] }, "fields": { "displayGroup": [ "0828c04e05801c11350186f8613c4964" ] }, "sort": [ 10, "ja-sp-019030.20", "0189b5cf228872a2b310bf8571f615f0" ] }, { "_index": "sw_dev_product_1747138014", "_id": "0189b5cf0ad972f79796b9302056cb65", "_score": null, "_source": { "purchasePrices": [ { "currencyId": "b7d2554b0ce847cd82f3ac9bd1c0dfca", "net": 6.0734, "gross": 7.2273, "linked": true, "listPrice": null } ], "referenceUnit": "0.000", "purchaseUnit": "1.0000", "unit": { "id": "0189b5cf096972eba234380aea82e89d", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "St\u00fcck" }, "shortCode": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Stck." }, "_count": 1 }, "crossSellings": [], "keywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "packUnit": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "St\u00fcck" }, "packUnitPlural": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "id": "0189b5cf0ad972f79796b9302056cb65", "autoIncrement": 1972.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": true, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "0189b5bd293f71c6a5e92e9980f13639" } ], "availableStock": 7, "productNumber": "ja-sp-019022", "ean": "251019022C21190221914005911190403", "displayGroup": "850d54a8450035f3908bc6977d9e3695", "sales": 4, "stock": 7, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "0189b5ceebb7734e990b1e31a9c8ab89", "manufacturerNumber": "251019022C21190221914005911190403", "releaseDate": null, "createdAt": "2022-12-28T00:00:00+00:00", "categoryTree": [ "d7b7b163000841a1876dbff5548c039f", "1e866cbbceb14718b0fc586a82f9bf19", "35dc90db760345fdb823f8a798b7f5ad", "bbc37dc21df04d55a654a66af971f895" ], "categoriesRo": [ { "id": "d7b7b163000841a1876dbff5548c039f", "_count": 1 }, { "id": "1e866cbbceb14718b0fc586a82f9bf19", "_count": 1 }, { "id": "35dc90db760345fdb823f8a798b7f5ad", "_count": 1 }, { "id": "bbc37dc21df04d55a654a66af971f895", "_count": 1 } ], "taxId": "0189b5bc757f71079ecf17a5e531d81e", "tags": [], "parentId": null, "coverId": "939a1712848a46b186069485647529af", "childCount": 0, "categories": [ { "id": "bbc37dc21df04d55a654a66af971f895", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sperrelemente" } } ], "manufacturer": { "id": "0189b5ceebb7734e990b1e31a9c8ab89", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Honeywell", "0189b5bd28fd735a9afc1ef90696fc66": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "bbc37dc21df04d55a654a66af971f895" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": { "short_description": "Gegenst\u00fcck Innenma\u00df 12mm \r\nf\u00fcr Sperrelement 19030\r\n\r\nVerpackungseinheit: 5 St\u00fcck", "attr9": "{\"shipping\":null,\"quantity\":0,\"cuttedCount\":0,\"available\":7,\"deliveries\":[],\"warehouses\":[]}", "jtlorder": "50", "releasedate": "28.12.2022", "tarcode": "83016000" } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "JA-SP-019022", "0189b5bd28fd735a9afc1ef90696fc66": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Gegenst\u00fcck Innenma\u00df 12mm f\u00fcr Sperrelement 19030Verpackungseinheit: 5 St\u00fcck", "0189b5bd28fd735a9afc1ef90696fc66": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "JA-SP-019022 Gegenst\u00fcck Sperrelement \| Jablotron \| EPS", "0189b5bd28fd735a9afc1ef90696fc66": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Entdecken Sie das hochwertige und offizielle Gegenst\u00fcck JA-SP-019022 f\u00fcr das Jablotron Sperrelement der 019030 Serie.", "0189b5bd28fd735a9afc1ef90696fc66": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": [ "Sperrelement", "Honeywell", "Sperrelemente" ], "0189b5bd28fd735a9afc1ef90696fc66": null }, "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 10.2935, "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 8.65, "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 10.2935, "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 8.65, "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 10.2935, "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 8.65, "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 8.1592, "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 6.8565, "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 10.2935, "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 8.65, "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 10.2935, "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 8.65, "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 14.756, "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 12.4, "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 14.756, "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 12.4, "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 10.2935, "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 8.65, "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 10.2935, "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 8.65, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 14.756, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 12.4, "jtlorder": 50, "custom_numbers": [] }, "fields": { "displayGroup": [ "850d54a8450035f3908bc6977d9e3695" ] }, "sort": [ 7, "ja-sp-019022", "0189b5cf0ad972f79796b9302056cb65" ] }, { "_index": "sw_dev_product_1747138014", "_id": "0189b5cf2c1c70f1aedfea155a66dd8d", "_score": null, "_source": { "purchasePrices": [ { "currencyId": "b7d2554b0ce847cd82f3ac9bd1c0dfca", "net": 5.25, "gross": 6.2475, "linked": true, "listPrice": null } ], "referenceUnit": "0.000", "purchaseUnit": "1.0000", "unit": { "id": "0189b5cf096972eba234380aea82e89d", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "St\u00fcck" }, "shortCode": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Stck." }, "_count": 1 }, "crossSellings": [], "keywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "packUnit": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "St\u00fcck" }, "packUnitPlural": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "id": "0189b5cf2c1c70f1aedfea155a66dd8d", "autoIncrement": 2791.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "0189b5bd293f71c6a5e92e9980f13639" } ], "availableStock": 4, "productNumber": "ja-sp-019030.10", "ean": "251019030.10D21903012038013411200919", "displayGroup": "2ae80ee1c1c88518524b8a802f3831cf", "sales": 6, "stock": 4, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "0189b5ceebb7734e990b1e31a9c8ab89", "manufacturerNumber": "251019030.10D21903012038017011200919", "releaseDate": null, "createdAt": "2022-12-28T00:00:00+00:00", "categoryTree": [ "d7b7b163000841a1876dbff5548c039f", "1e866cbbceb14718b0fc586a82f9bf19", "35dc90db760345fdb823f8a798b7f5ad", "bbc37dc21df04d55a654a66af971f895" ], "categoriesRo": [ { "id": "d7b7b163000841a1876dbff5548c039f", "_count": 1 }, { "id": "1e866cbbceb14718b0fc586a82f9bf19", "_count": 1 }, { "id": "35dc90db760345fdb823f8a798b7f5ad", "_count": 1 }, { "id": "bbc37dc21df04d55a654a66af971f895", "_count": 1 } ], "taxId": "0189b5bc757f71079ecf17a5e531d81e", "tags": [], "parentId": null, "coverId": "ed1c4a3edcac432080d4b74728461132", "childCount": 0, "categories": [ { "id": "bbc37dc21df04d55a654a66af971f895", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sperrelemente" } } ], "manufacturer": { "id": "0189b5ceebb7734e990b1e31a9c8ab89", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Honeywell", "0189b5bd28fd735a9afc1ef90696fc66": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "bbc37dc21df04d55a654a66af971f895" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": { "short_description": "Ersatz-Verschlussbolzen zu 19030.20", "attr9": "{\"shipping\":null,\"quantity\":0,\"cuttedCount\":0,\"available\":4,\"deliveries\":[],\"warehouses\":[]}", "jtlorder": "10", "releasedate": "28.12.2022", "tarcode": "83016000" } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "JA-SP-019030.10", "0189b5bd28fd735a9afc1ef90696fc66": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ersatz-Verschlussbolzen zu 19030.20", "0189b5bd28fd735a9afc1ef90696fc66": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "JA-SP-019030.10 Verschlussbolzen \| Jablotron Zubeh\u00f6r \| EPS", "0189b5bd28fd735a9afc1ef90696fc66": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Entdecken Sie den robusten Ersatz Verschlussbolzen JA-SP-019030.10 speziell f\u00fcr das Sperrelement JA-SP-019030.20", "0189b5bd28fd735a9afc1ef90696fc66": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": [ "Sperrelement", "Honeywell", "Sperrelemente" ], "0189b5bd28fd735a9afc1ef90696fc66": null }, "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 9.401, "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 7.9, "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 12.495, "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 10.5, "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 9.401, "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 7.9, "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 9.401, "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 7.9, "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 9.401, "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 7.9, "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 6.5599, "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 5.5125, "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 9.401, "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 7.9, "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 9.401, "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 7.9, "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 9.401, "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 7.9, "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 12.495, "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 10.5, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 12.495, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 10.5, "jtlorder": 10, "custom_numbers": [] }, "fields": { "displayGroup": [ "2ae80ee1c1c88518524b8a802f3831cf" ] }, "sort": [ 4, "ja-sp-019030.10", "0189b5cf2c1c70f1aedfea155a66dd8d" ] }, { "_index": "sw_dev_product_1747138014", "_id": "0189b5cf228271c2b4c6d7607274ff7c", "_score": null, "_source": { "purchasePrices": [ { "currencyId": "b7d2554b0ce847cd82f3ac9bd1c0dfca", "net": 91.1019, "gross": 108.4113, "linked": true, "listPrice": null } ], "referenceUnit": "0.000", "purchaseUnit": "1.0000", "unit": { "id": "0189b5cf096972eba234380aea82e89d", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "St\u00fcck" }, "shortCode": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Stck." }, "_count": 1 }, "crossSellings": [], "keywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "packUnit": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "St\u00fcck" }, "packUnitPlural": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "id": "0189b5cf228271c2b4c6d7607274ff7c", "autoIncrement": 2408.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "0189b5bd293f71c6a5e92e9980f13639" } ], "availableStock": 3, "productNumber": "ja-sp-019025", "ean": "251019025D11210909", "displayGroup": "b2c9f53342e5c93906243c282855a6e7", "sales": 12, "stock": 3, "weight": 0.72, "width": 200.0, "length": 150.0, "height": 50.0, "manufacturerId": "0189b5ceebb7734e990b1e31a9c8ab89", "manufacturerNumber": "19025", "releaseDate": null, "createdAt": "2020-02-07T00:00:00+00:00", "categoryTree": [ "ed73937c1fc54757a390ffc31536aa0d", "d7b7b163000841a1876dbff5548c039f", "1e866cbbceb14718b0fc586a82f9bf19", "35dc90db760345fdb823f8a798b7f5ad", "63479e3c30e44bb2b075ea822bec5cb5", "bbc37dc21df04d55a654a66af971f895" ], "categoriesRo": [ { "id": "ed73937c1fc54757a390ffc31536aa0d", "_count": 1 }, { "id": "d7b7b163000841a1876dbff5548c039f", "_count": 1 }, { "id": "1e866cbbceb14718b0fc586a82f9bf19", "_count": 1 }, { "id": "35dc90db760345fdb823f8a798b7f5ad", "_count": 1 }, { "id": "63479e3c30e44bb2b075ea822bec5cb5", "_count": 1 }, { "id": "bbc37dc21df04d55a654a66af971f895", "_count": 1 } ], "taxId": "0189b5bc757f71079ecf17a5e531d81e", "tags": [], "parentId": null, "coverId": "a2f610b5d4e343f3a00324d5190243f0", "childCount": 0, "categories": [ { "id": "63479e3c30e44bb2b075ea822bec5cb5", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "8079 - Honeywell" } }, { "id": "bbc37dc21df04d55a654a66af971f895", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sperrelemente" } } ], "manufacturer": { "id": "0189b5ceebb7734e990b1e31a9c8ab89", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Honeywell", "0189b5bd28fd735a9afc1ef90696fc66": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "63479e3c30e44bb2b075ea822bec5cb5", "bbc37dc21df04d55a654a66af971f895" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": { "attr3": "[]", "attr5": "[]", "attr6": "149.0000000000", "attr9": "{\"shipping\":null,\"quantity\":0,\"cuttedCount\":0,\"available\":3,\"deliveries\":[],\"warehouses\":[]}", "jtlorder": "40", "releasedate": "21.12.2022", "tarcode": "83016000" } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "JA-SP-019030.25", "0189b5bd28fd735a9afc1ef90696fc66": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Das Aufbaugeh\u00e4use JA-SP-019030.25 ist f\u00fcr das Sperrelement JA-SP-019030.20 konzipiert. Mit diesem Aufbaugeh\u00e4use kann das Sperrelement auch bei T\u00fcren mit planem T\u00fcrblatt aufgebaut werden. Das Sperrelement wird in dieses Aufbaugeh\u00e4use montiert.\nBitte beachten Sie die Montageanleitungen des Herstellers .", "0189b5bd28fd735a9afc1ef90696fc66": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "JA-SP-019030.25 Aufbaugeh\u00e4use \| Jablotron Zubeh\u00f6r \| EPS", "0189b5bd28fd735a9afc1ef90696fc66": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Das Aufbaugeh\u00e4use JA-SP-019030.25 ist f\u00fcr das Sperrelement JA-SP-019030.20 konzipiert und auch bei T\u00fcren mit planem T\u00fcrblatt aufgebaut werden.", "0189b5bd28fd735a9afc1ef90696fc66": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": [ "Sperrelement", "Honeywell", "8079 - Honeywell", "Sperrelemente" ], "0189b5bd28fd735a9afc1ef90696fc66": null }, "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 134.4837, "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 113.0115, "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 253.47, "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 213.0, "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 166.6, "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 140.0, "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 166.6, "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 140.0, "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 166.6, "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 140.0, "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 166.6, "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 140.0, "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 253.47, "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 213.0, "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 166.6, "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 140.0, "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 166.6, "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 140.0, "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 166.6, "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 140.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 253.47, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 213.0, "jtlorder": 40, "custom_numbers": [] }, "fields": { "displayGroup": [ "b2c9f53342e5c93906243c282855a6e7" ] }, "sort": [ 3, "ja-sp-019025", "0189b5cf228271c2b4c6d7607274ff7c" ] }, { "_index": "sw_dev_product_1747138014", "_id": "0189b5cf227b70caadca01fecaf985b9", "_score": null, "_source": { "purchasePrices": [ { "currencyId": "b7d2554b0ce847cd82f3ac9bd1c0dfca", "net": 95.176, "gross": 113.2594, "linked": true, "listPrice": null } ], "referenceUnit": "0.000", "purchaseUnit": "1.0000", "unit": { "id": "0189b5cf096972eba234380aea82e89d", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "St\u00fcck" }, "shortCode": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Stck." }, "_count": 1 }, "crossSellings": [], "keywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "packUnit": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "St\u00fcck" }, "packUnitPlural": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "id": "0189b5cf227b70caadca01fecaf985b9", "autoIncrement": 2407.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "0189b5bd293f71c6a5e92e9980f13639" } ], "availableStock": 2, "productNumber": "ja-sp-019024", "ean": "19024", "displayGroup": "7c83fd1bfcae52127c114dc50a91cf5c", "sales": 19, "stock": 2, "weight": 0.79, "width": 200.0, "length": 150.0, "height": 50.0, "manufacturerId": "0189b5ceebb7734e990b1e31a9c8ab89", "manufacturerNumber": "019024", "releaseDate": null, "createdAt": "2020-02-07T00:00:00+00:00", "categoryTree": [ "ed73937c1fc54757a390ffc31536aa0d", "d7b7b163000841a1876dbff5548c039f", "1e866cbbceb14718b0fc586a82f9bf19", "35dc90db760345fdb823f8a798b7f5ad", "63479e3c30e44bb2b075ea822bec5cb5", "bbc37dc21df04d55a654a66af971f895" ], "categoriesRo": [ { "id": "ed73937c1fc54757a390ffc31536aa0d", "_count": 1 }, { "id": "d7b7b163000841a1876dbff5548c039f", "_count": 1 }, { "id": "1e866cbbceb14718b0fc586a82f9bf19", "_count": 1 }, { "id": "35dc90db760345fdb823f8a798b7f5ad", "_count": 1 }, { "id": "63479e3c30e44bb2b075ea822bec5cb5", "_count": 1 }, { "id": "bbc37dc21df04d55a654a66af971f895", "_count": 1 } ], "taxId": "0189b5bc757f71079ecf17a5e531d81e", "tags": [], "parentId": null, "coverId": "bd528ca0420c4e5ebbd9ce4ec0feafe5", "childCount": 0, "categories": [ { "id": "63479e3c30e44bb2b075ea822bec5cb5", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "8079 - Honeywell" } }, { "id": "bbc37dc21df04d55a654a66af971f895", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sperrelemente" } } ], "manufacturer": { "id": "0189b5ceebb7734e990b1e31a9c8ab89", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Honeywell", "0189b5bd28fd735a9afc1ef90696fc66": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "63479e3c30e44bb2b075ea822bec5cb5", "bbc37dc21df04d55a654a66af971f895" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": { "attr3": "[]", "attr5": "[]", "attr6": "155.0000000000", "attr9": "{\"shipping\":null,\"quantity\":0,\"cuttedCount\":0,\"available\":2,\"deliveries\":[],\"warehouses\":[]}", "jtlorder": "30", "releasedate": "22.12.2022", "tarcode": "83016000" } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "JA-SP-019030.24", "0189b5bd28fd735a9afc1ef90696fc66": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Das Aufbaugeh\u00e4use JA-SP-019030.24 ist f\u00fcr das Sperrelement JA-SP-019030.20 konzipiert. Mit diesem Aufbaugeh\u00e4use kann das Sperrelement auch bei T\u00fcren mit erh\u00f6hten T\u00fcrblatt aufgebaut werden. Das Sperrelement wird in dieses Aufbaugeh\u00e4use montiert. \nBitte beachten Sie die Montageanleitungen des Herstellers.", "0189b5bd28fd735a9afc1ef90696fc66": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "JA-SP-019030.24 Aufbaugeh\u00e4use \| Jablotron Zubeh\u00f6r \| EPS", "0189b5bd28fd735a9afc1ef90696fc66": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Aufbaugeh\u00e4use JA-SP-019030.24 ist f\u00fcr das Sperrelement SP-019030.20 , damit kann das Sperrelement bei T\u00fcren mit erh\u00f6hten T\u00fcrblatt verbaut werden", "0189b5bd28fd735a9afc1ef90696fc66": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": [ "Sperrelement", "Honeywell", "8079 - Honeywell", "Sperrelemente" ], "0189b5bd28fd735a9afc1ef90696fc66": null }, "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 166.838, "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 140.2, "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 166.838, "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 140.2, "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 261.8, "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 220.0, "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 166.838, "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 140.2, "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 147.2911, "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 123.774, "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 166.838, "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 140.2, "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 166.838, "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 140.2, "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 166.838, "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 140.2, "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 261.8, "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 220.0, "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 166.838, "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 140.2, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 261.8, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 220.0, "jtlorder": 30, "custom_numbers": [] }, "fields": { "displayGroup": [ "7c83fd1bfcae52127c114dc50a91cf5c" ] }, "sort": [ 2, "ja-sp-019024", "0189b5cf227b70caadca01fecaf985b9" ] } ] }, "aggregations": { "total-filtered-count": { "doc_count": 5, "total-count": { "value": 5 } } } } `Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search`
2	3.98 ms	Request: {"index":"sw_dev_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"0189b5bd293f71c6a5e92e9980f13639"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"bbc37dc21df04d55a654a66af971f895"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"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_rule471f2ca5e74440568ba57912bb0f3d50_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc757970f38af8d735ac2bef24_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc757d738cb8f62b8ca13162fd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc781372e48ae25e3fc49e6c75_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5c9aba570cdb1eb3cecd2cd9c14_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5c9abd170d5a439e74a4020e81c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule018c7cebb95d7085930868a24624ed56_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc758c718ca89324f9e3bbcdfd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5c9ab9b73b8b6ca8da792e44880_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","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}}}},"manufacturer_count":{"terms":{"field":"manufacturerId","size":10000}},"propertiesCount":{"terms":{"field":"propertyIds","size":10000}},"immediately-available-filter":{"max":{"field":"availableStock"}}},"size":0,"timeout":"5s"},"search_type":"query_then_fetch"} Item count: View formatted request View formatted response View query backtrace POST http://10.20.0.3:9200/sw_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": [ { "nested": { "path": "visibilities", "query": { "bool": { "must": [ { "range": { "visibilities.visibility": { "gte": 30 } } }, { "term": { "visibilities.salesChannelId": "0189b5bd293f71c6a5e92e9980f13639" } } ] } } } }, { "term": { "active": true } } ] } }, { "nested": { "path": "categoriesRo", "query": { "term": { "categoriesRo.id": "bbc37dc21df04d55a654a66af971f895" } } } }, { "bool": { "must_not": [ { "bool": { "must_not": [ { "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_rule471f2ca5e74440568ba57912bb0f3d50_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0189b5bc757970f38af8d735ac2bef24_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0189b5bc757d738cb8f62b8ca13162fd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0189b5bc781372e48ae25e3fc49e6c75_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0189b5c9aba570cdb1eb3cecd2cd9c14_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0189b5c9abd170d5a439e74a4020e81c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule018c7cebb95d7085930868a24624ed56_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0189b5bc758c718ca89324f9e3bbcdfd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0189b5c9ab9b73b8b6ca8da792e44880_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "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 } } } }, "manufacturer_count": { "terms": { "field": "manufacturerId", "size": 10000 } }, "propertiesCount": { "terms": { "field": "propertyIds", "size": 10000 } }, "immediately-available-filter": { "max": { "field": "availableStock" } } }, "size": 0, "timeout": "5s" } { "took": 1, "timed_out": false, "_shards": { "total": 3, "successful": 3, "skipped": 0, "failed": 0 }, "hits": { "max_score": null, "hits": [] }, "aggregations": { "manufacturer_count": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [ { "key": "0189b5ceebb7734e990b1e31a9c8ab89", "doc_count": 5 } ] }, "shipping-free-filter": { "doc_count": 0, "shipping-free": { "value": null } }, "propertiesCount": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [] }, "rating-exists": { "doc_count": 5, "rating": { "value": 5.0 } }, "price": { "count": 5, "min": 10.5, "max": 220.0, "avg": 130.98, "sum": 654.9 }, "immediately-available-filter": { "value": 10.0 }, "options": { "doc_count": 0, "options": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [] } }, "properties": { "doc_count": 0, "properties": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [] } }, "manufacturer": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [ { "key": "0189b5ceebb7734e990b1e31a9c8ab89", "doc_count": 5 } ] } } } `Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate`

Request:

{"index":"sw_dev_product","search_type":"query_then_fetch","track_total_hits":true,"body":{"post_filter":{"bool":{"filter":[{"bool":{"must":[{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["89ee44dcf85c46718ba0744360e5fcc1"]}}}}]}}]}},{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["3adaca5df47943339a045e91f212ee90","b2e857ff4b84401caef408741cc18d83","2e9dc36608504cd0bd340d135922df23","87c89b5844a0436db7e7bebadfa24d5f","1339fc04d1b14eedae5c6cb1269b34af","b78d026c06064f24b92e69b8e1feadb0","eb1bb24fb4a64c9295a69f327f7a5899","b69d2b1c914342ecb0a0ba8cc0980393","4e33f457de524946ab593df85fba15ed"]}}}}]}}]}},{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["a2e3ce1f6e7241a783db0a98b0003a84"]}}}}]}}]}}]}}]}},"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"0189b5bd293f71c6a5e92e9980f13639"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"bbc37dc21df04d55a654a66af971f895"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}},{"bool":{"must_not":[{"bool":{"must":[{"term":{"isCloseout":true}},{"term":{"available":false}}]}}]}}]}}]}},"sort":[{"stock":{"order":"DESC"}},{"productNumber":{"order":"ASC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-filtered-count":{"filter":{"bool":{"must":[{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["89ee44dcf85c46718ba0744360e5fcc1"]}}}}]}}]}},{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["3adaca5df47943339a045e91f212ee90","b2e857ff4b84401caef408741cc18d83","2e9dc36608504cd0bd340d135922df23","87c89b5844a0436db7e7bebadfa24d5f","1339fc04d1b14eedae5c6cb1269b34af","b78d026c06064f24b92e69b8e1feadb0","eb1bb24fb4a64c9295a69f327f7a5899","b69d2b1c914342ecb0a0ba8cc0980393","4e33f457de524946ab593df85fba15ed"]}}}}]}}]}},{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["a2e3ce1f6e7241a783db0a98b0003a84"]}}}}]}}]}}]}},"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}}}},"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"}}

Item count: 5
View formatted request View formatted response View query backtrace


                                    POST http://10.20.0.3:9200/sw_dev_product/_search?search_type=query_then_fetch&track_total_hits=1
    Accept: application/json
    Content-Type: application/json

        {
    "post_filter": {
        "bool": {
            "filter": [
                {
                    "bool": {
                        "must": [
                            {
                                "bool": {
                                    "should": [
                                        {
                                            "bool": {
                                                "must_not": [
                                                    {
                                                        "nested": {
                                                            "path": "categories",
                                                            "query": {
                                                                "terms": {
                                                                    "categories.id": [
                                                                        "89ee44dcf85c46718ba0744360e5fcc1"
                                                                    ]
                                                                }
                                                            }
                                                        }
                                                    }
                                                ]
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "bool": {
                                    "should": [
                                        {
                                            "bool": {
                                                "must_not": [
                                                    {
                                                        "nested": {
                                                            "path": "categories",
                                                            "query": {
                                                                "terms": {
                                                                    "categories.id": [
                                                                        "3adaca5df47943339a045e91f212ee90",
                                                                        "b2e857ff4b84401caef408741cc18d83",
                                                                        "2e9dc36608504cd0bd340d135922df23",
                                                                        "87c89b5844a0436db7e7bebadfa24d5f",
                                                                        "1339fc04d1b14eedae5c6cb1269b34af",
                                                                        "b78d026c06064f24b92e69b8e1feadb0",
                                                                        "eb1bb24fb4a64c9295a69f327f7a5899",
                                                                        "b69d2b1c914342ecb0a0ba8cc0980393",
                                                                        "4e33f457de524946ab593df85fba15ed"
                                                                    ]
                                                                }
                                                            }
                                                        }
                                                    }
                                                ]
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "bool": {
                                    "should": [
                                        {
                                            "bool": {
                                                "must_not": [
                                                    {
                                                        "nested": {
                                                            "path": "categories",
                                                            "query": {
                                                                "terms": {
                                                                    "categories.id": [
                                                                        "a2e3ce1f6e7241a783db0a98b0003a84"
                                                                    ]
                                                                }
                                                            }
                                                        }
                                                    }
                                                ]
                                            }
                                        }
                                    ]
                                }
                            }
                        ]
                    }
                }
            ]
        }
    },
    "query": {
        "bool": {
            "filter": [
                {
                    "bool": {
                        "must": [
                            {
                                "bool": {
                                    "must": [
                                        {
                                            "nested": {
                                                "path": "visibilities",
                                                "query": {
                                                    "bool": {
                                                        "must": [
                                                            {
                                                                "range": {
                                                                    "visibilities.visibility": {
                                                                        "gte": 30
                                                                    }
                                                                }
                                                            },
                                                            {
                                                                "term": {
                                                                    "visibilities.salesChannelId": "0189b5bd293f71c6a5e92e9980f13639"
                                                                }
                                                            }
                                                        ]
                                                    }
                                                }
                                            }
                                        },
                                        {
                                            "term": {
                                                "active": true
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "nested": {
                                    "path": "categoriesRo",
                                    "query": {
                                        "term": {
                                            "categoriesRo.id": "bbc37dc21df04d55a654a66af971f895"
                                        }
                                    }
                                }
                            },
                            {
                                "bool": {
                                    "must_not": [
                                        {
                                            "bool": {
                                                "must_not": [
                                                    {
                                                        "exists": {
                                                            "field": "displayGroup"
                                                        }
                                                    }
                                                ]
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "bool": {
                                    "must_not": [
                                        {
                                            "bool": {
                                                "must": [
                                                    {
                                                        "term": {
                                                            "isCloseout": true
                                                        }
                                                    },
                                                    {
                                                        "term": {
                                                            "available": false
                                                        }
                                                    }
                                                ]
                                            }
                                        }
                                    ]
                                }
                            }
                        ]
                    }
                }
            ]
        }
    },
    "sort": [
        {
            "stock": {
                "order": "DESC"
            }
        },
        {
            "productNumber": {
                "order": "ASC"
            }
        },
        {
            "id": {
                "order": "ASC"
            }
        }
    ],
    "aggregations": {
        "total-filtered-count": {
            "filter": {
                "bool": {
                    "must": [
                        {
                            "bool": {
                                "should": [
                                    {
                                        "bool": {
                                            "must_not": [
                                                {
                                                    "nested": {
                                                        "path": "categories",
                                                        "query": {
                                                            "terms": {
                                                                "categories.id": [
                                                                    "89ee44dcf85c46718ba0744360e5fcc1"
                                                                ]
                                                            }
                                                        }
                                                    }
                                                }
                                            ]
                                        }
                                    }
                                ]
                            }
                        },
                        {
                            "bool": {
                                "should": [
                                    {
                                        "bool": {
                                            "must_not": [
                                                {
                                                    "nested": {
                                                        "path": "categories",
                                                        "query": {
                                                            "terms": {
                                                                "categories.id": [
                                                                    "3adaca5df47943339a045e91f212ee90",
                                                                    "b2e857ff4b84401caef408741cc18d83",
                                                                    "2e9dc36608504cd0bd340d135922df23",
                                                                    "87c89b5844a0436db7e7bebadfa24d5f",
                                                                    "1339fc04d1b14eedae5c6cb1269b34af",
                                                                    "b78d026c06064f24b92e69b8e1feadb0",
                                                                    "eb1bb24fb4a64c9295a69f327f7a5899",
                                                                    "b69d2b1c914342ecb0a0ba8cc0980393",
                                                                    "4e33f457de524946ab593df85fba15ed"
                                                                ]
                                                            }
                                                        }
                                                    }
                                                }
                                            ]
                                        }
                                    }
                                ]
                            }
                        },
                        {
                            "bool": {
                                "should": [
                                    {
                                        "bool": {
                                            "must_not": [
                                                {
                                                    "nested": {
                                                        "path": "categories",
                                                        "query": {
                                                            "terms": {
                                                                "categories.id": [
                                                                    "a2e3ce1f6e7241a783db0a98b0003a84"
                                                                ]
                                                            }
                                                        }
                                                    }
                                                }
                                            ]
                                        }
                                    }
                                ]
                            }
                        }
                    ]
                }
            },
            "aggregations": {
                "total-count": {
                    "cardinality": {
                        "field": "displayGroup"
                    }
                }
            }
        }
    },
    "from": 0,
    "size": 24,
    "collapse": {
        "field": "displayGroup"
    },
    "timeout": "5s"
}


                                    {
    "took": 2,
    "timed_out": false,
    "_shards": {
        "total": 3,
        "successful": 3,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": {
            "value": 5,
            "relation": "eq"
        },
        "max_score": null,
        "hits": [
            {
                "_index": "sw_dev_product_1747138014",
                "_id": "0189b5cf228872a2b310bf8571f615f0",
                "_score": null,
                "_source": {
                    "purchasePrices": [
                        {
                            "currencyId": "b7d2554b0ce847cd82f3ac9bd1c0dfca",
                            "net": 105.1255,
                            "gross": 125.0993,
                            "linked": true,
                            "listPrice": null
                        }
                    ],
                    "referenceUnit": "0.000",
                    "purchaseUnit": "1.0000",
                    "unit": {
                        "id": "0189b5cf096972eba234380aea82e89d",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "St\u00fcck"
                        },
                        "shortCode": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Stck."
                        },
                        "_count": 1
                    },
                    "crossSellings": [],
                    "keywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "packUnit": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "St\u00fcck"
                    },
                    "packUnitPlural": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "id": "0189b5cf228872a2b310bf8571f615f0",
                    "autoIncrement": 2409.0,
                    "ratingAverage": 5.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "0189b5bd293f71c6a5e92e9980f13639"
                        }
                    ],
                    "availableStock": 10,
                    "productNumber": "ja-sp-019030.20",
                    "ean": "251019030.20N21C27000090B2A11210914",
                    "displayGroup": "0828c04e05801c11350186f8613c4964",
                    "sales": 1380,
                    "stock": 10,
                    "weight": 0.36,
                    "width": 200.0,
                    "length": 150.0,
                    "height": 50.0,
                    "manufacturerId": "0189b5ceebb7734e990b1e31a9c8ab89",
                    "manufacturerNumber": "19030.20",
                    "releaseDate": null,
                    "createdAt": "2020-02-07T00:00:00+00:00",
                    "categoryTree": [
                        "ed73937c1fc54757a390ffc31536aa0d",
                        "d7b7b163000841a1876dbff5548c039f",
                        "1e866cbbceb14718b0fc586a82f9bf19",
                        "35dc90db760345fdb823f8a798b7f5ad",
                        "63479e3c30e44bb2b075ea822bec5cb5",
                        "bbc37dc21df04d55a654a66af971f895"
                    ],
                    "categoriesRo": [
                        {
                            "id": "ed73937c1fc54757a390ffc31536aa0d",
                            "_count": 1
                        },
                        {
                            "id": "d7b7b163000841a1876dbff5548c039f",
                            "_count": 1
                        },
                        {
                            "id": "1e866cbbceb14718b0fc586a82f9bf19",
                            "_count": 1
                        },
                        {
                            "id": "35dc90db760345fdb823f8a798b7f5ad",
                            "_count": 1
                        },
                        {
                            "id": "63479e3c30e44bb2b075ea822bec5cb5",
                            "_count": 1
                        },
                        {
                            "id": "bbc37dc21df04d55a654a66af971f895",
                            "_count": 1
                        }
                    ],
                    "taxId": "0189b5bc757f71079ecf17a5e531d81e",
                    "tags": [],
                    "parentId": null,
                    "coverId": "0eaccecf87684d5cb29cbcc3874fc76e",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "63479e3c30e44bb2b075ea822bec5cb5",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "8079 - Honeywell"
                            }
                        },
                        {
                            "id": "bbc37dc21df04d55a654a66af971f895",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sperrelemente"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "0189b5ceebb7734e990b1e31a9c8ab89",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Honeywell",
                            "0189b5bd28fd735a9afc1ef90696fc66": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "63479e3c30e44bb2b075ea822bec5cb5",
                        "bbc37dc21df04d55a654a66af971f895"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
                            "attr3": "[]",
                            "attr5": "[]",
                            "attr6": "159.0000000000",
                            "attr7": "[]",
                            "attr9": "{\"shipping\":null,\"quantity\":0,\"cuttedCount\":0,\"available\":10,\"deliveries\":[],\"warehouses\":[]}",
                            "jtlorder": "20",
                            "releasedate": "22.12.2022",
                            "tarcode": "39269097"
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "JA-SP-019030.20",
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Das elektromechanische Sperrelement JA-SP-019030.20 dient zum Verriegeln von T\u00fcren und Zug\u00e4ngen. Durch das Sperrelement kann z.B. der Zugang zu einem gesicherten Bereich mechanisch blockiert und verhindert werden. Die Funktion des Sperrelement k\u00f6nnen \u00fcber das JA 100 Alarmsystem programmiert werden.Diese Sperrelement kann direkt in den T\u00fcrrahmen \/ Zarge eingebaut werden. Zur Montage auf der T\u00fcr \/ Zarge stehen Aufbaugeh\u00e4use zur Verf\u00fcgung. Bitte beachten Sie die Montage- und Einbauanleitung.\nLeistungsmerkmale:\n\nMontage im T\u00fcrrahmen mit Gegenst\u00fcck im T\u00fcrblatt\nAnsteuerung kann dynamisch oder statisch erfolgen\nelektrische sowie mechanische Notentriegelung m\u00f6glich\nHalbleiterausg\u00e4nge f\u00fcr Endstellungen\n\nTechnische Daten:\n\nBetriebsnennspannung: 12 V DC\nBetriebsspannungsbereich: 9 V bis 15 V DC\nStromaufnahme in Ruhe: 4 mA\nmittlere Stromaufnahme: ca. 130 mA, max. 0,6 sec.\nStrombelastbarkeit Ausg\u00e4nge: max. 20 mA (high aktiv)\nBetriebstemperaturbereich: -25 \u00b0C bis +55 \u00b0C\n\nMechanische Daten:\n\nEinbaulage: beliebig\nAnschlussleitung: 4 m\nAbmessungen (B x H x T): 18 x 140 x 32 mm\nVerschlussbolzen: \u00f8 8,0 mm (austauschbar)\nVerschlussbolzenweg: mind. 10 mm\nStulp Standardma\u00df: 20 x 2 x 188 mm (austauschbar)\n",
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "JA-SP-019030.20 Sperrelement | Honeywell Zubeh\u00f6r | EPS",
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Das elektromechanische Sperrelement JA-SP-019030.20 Honeywell dient zum Verriegeln von T\u00fcren und Zug\u00e4ngen.",
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": [
                            "Sperrelement",
                            "Honeywell",
                            "8079 - Honeywell",
                            "Sperrelemente"
                        ],
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 164.22,
                    "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 138.0,
                    "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 164.22,
                    "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 138.0,
                    "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 164.22,
                    "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 138.0,
                    "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 236.81,
                    "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 199.0,
                    "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 164.22,
                    "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 138.0,
                    "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 144.0798,
                    "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 121.0755,
                    "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 164.22,
                    "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 138.0,
                    "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 164.22,
                    "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 138.0,
                    "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 236.81,
                    "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 199.0,
                    "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 164.22,
                    "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 138.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 236.81,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 199.0,
                    "jtlorder": 20,
                    "custom_numbers": []
                },
                "fields": {
                    "displayGroup": [
                        "0828c04e05801c11350186f8613c4964"
                    ]
                },
                "sort": [
                    10,
                    "ja-sp-019030.20",
                    "0189b5cf228872a2b310bf8571f615f0"
                ]
            },
            {
                "_index": "sw_dev_product_1747138014",
                "_id": "0189b5cf0ad972f79796b9302056cb65",
                "_score": null,
                "_source": {
                    "purchasePrices": [
                        {
                            "currencyId": "b7d2554b0ce847cd82f3ac9bd1c0dfca",
                            "net": 6.0734,
                            "gross": 7.2273,
                            "linked": true,
                            "listPrice": null
                        }
                    ],
                    "referenceUnit": "0.000",
                    "purchaseUnit": "1.0000",
                    "unit": {
                        "id": "0189b5cf096972eba234380aea82e89d",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "St\u00fcck"
                        },
                        "shortCode": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Stck."
                        },
                        "_count": 1
                    },
                    "crossSellings": [],
                    "keywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "packUnit": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "St\u00fcck"
                    },
                    "packUnitPlural": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "id": "0189b5cf0ad972f79796b9302056cb65",
                    "autoIncrement": 1972.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": true,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "0189b5bd293f71c6a5e92e9980f13639"
                        }
                    ],
                    "availableStock": 7,
                    "productNumber": "ja-sp-019022",
                    "ean": "251019022C21190221914005911190403",
                    "displayGroup": "850d54a8450035f3908bc6977d9e3695",
                    "sales": 4,
                    "stock": 7,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "0189b5ceebb7734e990b1e31a9c8ab89",
                    "manufacturerNumber": "251019022C21190221914005911190403",
                    "releaseDate": null,
                    "createdAt": "2022-12-28T00:00:00+00:00",
                    "categoryTree": [
                        "d7b7b163000841a1876dbff5548c039f",
                        "1e866cbbceb14718b0fc586a82f9bf19",
                        "35dc90db760345fdb823f8a798b7f5ad",
                        "bbc37dc21df04d55a654a66af971f895"
                    ],
                    "categoriesRo": [
                        {
                            "id": "d7b7b163000841a1876dbff5548c039f",
                            "_count": 1
                        },
                        {
                            "id": "1e866cbbceb14718b0fc586a82f9bf19",
                            "_count": 1
                        },
                        {
                            "id": "35dc90db760345fdb823f8a798b7f5ad",
                            "_count": 1
                        },
                        {
                            "id": "bbc37dc21df04d55a654a66af971f895",
                            "_count": 1
                        }
                    ],
                    "taxId": "0189b5bc757f71079ecf17a5e531d81e",
                    "tags": [],
                    "parentId": null,
                    "coverId": "939a1712848a46b186069485647529af",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "bbc37dc21df04d55a654a66af971f895",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sperrelemente"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "0189b5ceebb7734e990b1e31a9c8ab89",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Honeywell",
                            "0189b5bd28fd735a9afc1ef90696fc66": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "bbc37dc21df04d55a654a66af971f895"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
                            "short_description": "Gegenst\u00fcck Innenma\u00df 12mm \r\nf\u00fcr Sperrelement 19030\r\n\r\nVerpackungseinheit: 5 St\u00fcck",
                            "attr9": "{\"shipping\":null,\"quantity\":0,\"cuttedCount\":0,\"available\":7,\"deliveries\":[],\"warehouses\":[]}",
                            "jtlorder": "50",
                            "releasedate": "28.12.2022",
                            "tarcode": "83016000"
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "JA-SP-019022",
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Gegenst\u00fcck Innenma\u00df 12mm f\u00fcr Sperrelement 19030Verpackungseinheit: 5 St\u00fcck",
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "JA-SP-019022 Gegenst\u00fcck Sperrelement | Jablotron | EPS",
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Entdecken Sie das hochwertige und offizielle Gegenst\u00fcck  JA-SP-019022 f\u00fcr das Jablotron Sperrelement der 019030 Serie.",
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": [
                            "Sperrelement",
                            "Honeywell",
                            "Sperrelemente"
                        ],
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 10.2935,
                    "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 8.65,
                    "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 10.2935,
                    "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 8.65,
                    "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 10.2935,
                    "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 8.65,
                    "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 8.1592,
                    "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 6.8565,
                    "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 10.2935,
                    "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 8.65,
                    "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 10.2935,
                    "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 8.65,
                    "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 14.756,
                    "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 12.4,
                    "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 14.756,
                    "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 12.4,
                    "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 10.2935,
                    "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 8.65,
                    "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 10.2935,
                    "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 8.65,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 14.756,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 12.4,
                    "jtlorder": 50,
                    "custom_numbers": []
                },
                "fields": {
                    "displayGroup": [
                        "850d54a8450035f3908bc6977d9e3695"
                    ]
                },
                "sort": [
                    7,
                    "ja-sp-019022",
                    "0189b5cf0ad972f79796b9302056cb65"
                ]
            },
            {
                "_index": "sw_dev_product_1747138014",
                "_id": "0189b5cf2c1c70f1aedfea155a66dd8d",
                "_score": null,
                "_source": {
                    "purchasePrices": [
                        {
                            "currencyId": "b7d2554b0ce847cd82f3ac9bd1c0dfca",
                            "net": 5.25,
                            "gross": 6.2475,
                            "linked": true,
                            "listPrice": null
                        }
                    ],
                    "referenceUnit": "0.000",
                    "purchaseUnit": "1.0000",
                    "unit": {
                        "id": "0189b5cf096972eba234380aea82e89d",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "St\u00fcck"
                        },
                        "shortCode": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Stck."
                        },
                        "_count": 1
                    },
                    "crossSellings": [],
                    "keywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "packUnit": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "St\u00fcck"
                    },
                    "packUnitPlural": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "id": "0189b5cf2c1c70f1aedfea155a66dd8d",
                    "autoIncrement": 2791.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "0189b5bd293f71c6a5e92e9980f13639"
                        }
                    ],
                    "availableStock": 4,
                    "productNumber": "ja-sp-019030.10",
                    "ean": "251019030.10D21903012038013411200919",
                    "displayGroup": "2ae80ee1c1c88518524b8a802f3831cf",
                    "sales": 6,
                    "stock": 4,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "0189b5ceebb7734e990b1e31a9c8ab89",
                    "manufacturerNumber": "251019030.10D21903012038017011200919",
                    "releaseDate": null,
                    "createdAt": "2022-12-28T00:00:00+00:00",
                    "categoryTree": [
                        "d7b7b163000841a1876dbff5548c039f",
                        "1e866cbbceb14718b0fc586a82f9bf19",
                        "35dc90db760345fdb823f8a798b7f5ad",
                        "bbc37dc21df04d55a654a66af971f895"
                    ],
                    "categoriesRo": [
                        {
                            "id": "d7b7b163000841a1876dbff5548c039f",
                            "_count": 1
                        },
                        {
                            "id": "1e866cbbceb14718b0fc586a82f9bf19",
                            "_count": 1
                        },
                        {
                            "id": "35dc90db760345fdb823f8a798b7f5ad",
                            "_count": 1
                        },
                        {
                            "id": "bbc37dc21df04d55a654a66af971f895",
                            "_count": 1
                        }
                    ],
                    "taxId": "0189b5bc757f71079ecf17a5e531d81e",
                    "tags": [],
                    "parentId": null,
                    "coverId": "ed1c4a3edcac432080d4b74728461132",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "bbc37dc21df04d55a654a66af971f895",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sperrelemente"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "0189b5ceebb7734e990b1e31a9c8ab89",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Honeywell",
                            "0189b5bd28fd735a9afc1ef90696fc66": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "bbc37dc21df04d55a654a66af971f895"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
                            "short_description": "Ersatz-Verschlussbolzen zu 19030.20",
                            "attr9": "{\"shipping\":null,\"quantity\":0,\"cuttedCount\":0,\"available\":4,\"deliveries\":[],\"warehouses\":[]}",
                            "jtlorder": "10",
                            "releasedate": "28.12.2022",
                            "tarcode": "83016000"
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "JA-SP-019030.10",
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ersatz-Verschlussbolzen zu 19030.20",
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "JA-SP-019030.10 Verschlussbolzen | Jablotron Zubeh\u00f6r | EPS",
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Entdecken Sie den robusten Ersatz Verschlussbolzen  JA-SP-019030.10 speziell f\u00fcr das Sperrelement JA-SP-019030.20",
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": [
                            "Sperrelement",
                            "Honeywell",
                            "Sperrelemente"
                        ],
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 9.401,
                    "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 7.9,
                    "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 12.495,
                    "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 10.5,
                    "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 9.401,
                    "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 7.9,
                    "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 9.401,
                    "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 7.9,
                    "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 9.401,
                    "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 7.9,
                    "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 6.5599,
                    "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 5.5125,
                    "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 9.401,
                    "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 7.9,
                    "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 9.401,
                    "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 7.9,
                    "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 9.401,
                    "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 7.9,
                    "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 12.495,
                    "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 10.5,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 12.495,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 10.5,
                    "jtlorder": 10,
                    "custom_numbers": []
                },
                "fields": {
                    "displayGroup": [
                        "2ae80ee1c1c88518524b8a802f3831cf"
                    ]
                },
                "sort": [
                    4,
                    "ja-sp-019030.10",
                    "0189b5cf2c1c70f1aedfea155a66dd8d"
                ]
            },
            {
                "_index": "sw_dev_product_1747138014",
                "_id": "0189b5cf228271c2b4c6d7607274ff7c",
                "_score": null,
                "_source": {
                    "purchasePrices": [
                        {
                            "currencyId": "b7d2554b0ce847cd82f3ac9bd1c0dfca",
                            "net": 91.1019,
                            "gross": 108.4113,
                            "linked": true,
                            "listPrice": null
                        }
                    ],
                    "referenceUnit": "0.000",
                    "purchaseUnit": "1.0000",
                    "unit": {
                        "id": "0189b5cf096972eba234380aea82e89d",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "St\u00fcck"
                        },
                        "shortCode": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Stck."
                        },
                        "_count": 1
                    },
                    "crossSellings": [],
                    "keywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "packUnit": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "St\u00fcck"
                    },
                    "packUnitPlural": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "id": "0189b5cf228271c2b4c6d7607274ff7c",
                    "autoIncrement": 2408.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "0189b5bd293f71c6a5e92e9980f13639"
                        }
                    ],
                    "availableStock": 3,
                    "productNumber": "ja-sp-019025",
                    "ean": "251019025D11210909",
                    "displayGroup": "b2c9f53342e5c93906243c282855a6e7",
                    "sales": 12,
                    "stock": 3,
                    "weight": 0.72,
                    "width": 200.0,
                    "length": 150.0,
                    "height": 50.0,
                    "manufacturerId": "0189b5ceebb7734e990b1e31a9c8ab89",
                    "manufacturerNumber": "19025",
                    "releaseDate": null,
                    "createdAt": "2020-02-07T00:00:00+00:00",
                    "categoryTree": [
                        "ed73937c1fc54757a390ffc31536aa0d",
                        "d7b7b163000841a1876dbff5548c039f",
                        "1e866cbbceb14718b0fc586a82f9bf19",
                        "35dc90db760345fdb823f8a798b7f5ad",
                        "63479e3c30e44bb2b075ea822bec5cb5",
                        "bbc37dc21df04d55a654a66af971f895"
                    ],
                    "categoriesRo": [
                        {
                            "id": "ed73937c1fc54757a390ffc31536aa0d",
                            "_count": 1
                        },
                        {
                            "id": "d7b7b163000841a1876dbff5548c039f",
                            "_count": 1
                        },
                        {
                            "id": "1e866cbbceb14718b0fc586a82f9bf19",
                            "_count": 1
                        },
                        {
                            "id": "35dc90db760345fdb823f8a798b7f5ad",
                            "_count": 1
                        },
                        {
                            "id": "63479e3c30e44bb2b075ea822bec5cb5",
                            "_count": 1
                        },
                        {
                            "id": "bbc37dc21df04d55a654a66af971f895",
                            "_count": 1
                        }
                    ],
                    "taxId": "0189b5bc757f71079ecf17a5e531d81e",
                    "tags": [],
                    "parentId": null,
                    "coverId": "a2f610b5d4e343f3a00324d5190243f0",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "63479e3c30e44bb2b075ea822bec5cb5",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "8079 - Honeywell"
                            }
                        },
                        {
                            "id": "bbc37dc21df04d55a654a66af971f895",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sperrelemente"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "0189b5ceebb7734e990b1e31a9c8ab89",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Honeywell",
                            "0189b5bd28fd735a9afc1ef90696fc66": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "63479e3c30e44bb2b075ea822bec5cb5",
                        "bbc37dc21df04d55a654a66af971f895"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
                            "attr3": "[]",
                            "attr5": "[]",
                            "attr6": "149.0000000000",
                            "attr9": "{\"shipping\":null,\"quantity\":0,\"cuttedCount\":0,\"available\":3,\"deliveries\":[],\"warehouses\":[]}",
                            "jtlorder": "40",
                            "releasedate": "21.12.2022",
                            "tarcode": "83016000"
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "JA-SP-019030.25",
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Das Aufbaugeh\u00e4use JA-SP-019030.25 ist f\u00fcr das Sperrelement JA-SP-019030.20 konzipiert.  Mit diesem Aufbaugeh\u00e4use kann das Sperrelement auch bei T\u00fcren mit  planem T\u00fcrblatt  aufgebaut werden. Das Sperrelement wird in dieses  Aufbaugeh\u00e4use montiert.\nBitte beachten Sie die Montageanleitungen des Herstellers .",
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "JA-SP-019030.25 Aufbaugeh\u00e4use | Jablotron Zubeh\u00f6r | EPS",
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Das Aufbaugeh\u00e4use JA-SP-019030.25 ist f\u00fcr das Sperrelement JA-SP-019030.20 konzipiert und auch bei T\u00fcren mit planem  T\u00fcrblatt aufgebaut werden.",
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": [
                            "Sperrelement",
                            "Honeywell",
                            "8079 - Honeywell",
                            "Sperrelemente"
                        ],
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 134.4837,
                    "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 113.0115,
                    "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 253.47,
                    "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 213.0,
                    "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 166.6,
                    "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 140.0,
                    "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 166.6,
                    "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 140.0,
                    "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 166.6,
                    "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 140.0,
                    "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 166.6,
                    "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 140.0,
                    "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 253.47,
                    "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 213.0,
                    "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 166.6,
                    "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 140.0,
                    "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 166.6,
                    "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 140.0,
                    "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 166.6,
                    "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 140.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 253.47,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 213.0,
                    "jtlorder": 40,
                    "custom_numbers": []
                },
                "fields": {
                    "displayGroup": [
                        "b2c9f53342e5c93906243c282855a6e7"
                    ]
                },
                "sort": [
                    3,
                    "ja-sp-019025",
                    "0189b5cf228271c2b4c6d7607274ff7c"
                ]
            },
            {
                "_index": "sw_dev_product_1747138014",
                "_id": "0189b5cf227b70caadca01fecaf985b9",
                "_score": null,
                "_source": {
                    "purchasePrices": [
                        {
                            "currencyId": "b7d2554b0ce847cd82f3ac9bd1c0dfca",
                            "net": 95.176,
                            "gross": 113.2594,
                            "linked": true,
                            "listPrice": null
                        }
                    ],
                    "referenceUnit": "0.000",
                    "purchaseUnit": "1.0000",
                    "unit": {
                        "id": "0189b5cf096972eba234380aea82e89d",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "St\u00fcck"
                        },
                        "shortCode": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Stck."
                        },
                        "_count": 1
                    },
                    "crossSellings": [],
                    "keywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "packUnit": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "St\u00fcck"
                    },
                    "packUnitPlural": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "id": "0189b5cf227b70caadca01fecaf985b9",
                    "autoIncrement": 2407.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "0189b5bd293f71c6a5e92e9980f13639"
                        }
                    ],
                    "availableStock": 2,
                    "productNumber": "ja-sp-019024",
                    "ean": "19024",
                    "displayGroup": "7c83fd1bfcae52127c114dc50a91cf5c",
                    "sales": 19,
                    "stock": 2,
                    "weight": 0.79,
                    "width": 200.0,
                    "length": 150.0,
                    "height": 50.0,
                    "manufacturerId": "0189b5ceebb7734e990b1e31a9c8ab89",
                    "manufacturerNumber": "019024",
                    "releaseDate": null,
                    "createdAt": "2020-02-07T00:00:00+00:00",
                    "categoryTree": [
                        "ed73937c1fc54757a390ffc31536aa0d",
                        "d7b7b163000841a1876dbff5548c039f",
                        "1e866cbbceb14718b0fc586a82f9bf19",
                        "35dc90db760345fdb823f8a798b7f5ad",
                        "63479e3c30e44bb2b075ea822bec5cb5",
                        "bbc37dc21df04d55a654a66af971f895"
                    ],
                    "categoriesRo": [
                        {
                            "id": "ed73937c1fc54757a390ffc31536aa0d",
                            "_count": 1
                        },
                        {
                            "id": "d7b7b163000841a1876dbff5548c039f",
                            "_count": 1
                        },
                        {
                            "id": "1e866cbbceb14718b0fc586a82f9bf19",
                            "_count": 1
                        },
                        {
                            "id": "35dc90db760345fdb823f8a798b7f5ad",
                            "_count": 1
                        },
                        {
                            "id": "63479e3c30e44bb2b075ea822bec5cb5",
                            "_count": 1
                        },
                        {
                            "id": "bbc37dc21df04d55a654a66af971f895",
                            "_count": 1
                        }
                    ],
                    "taxId": "0189b5bc757f71079ecf17a5e531d81e",
                    "tags": [],
                    "parentId": null,
                    "coverId": "bd528ca0420c4e5ebbd9ce4ec0feafe5",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "63479e3c30e44bb2b075ea822bec5cb5",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "8079 - Honeywell"
                            }
                        },
                        {
                            "id": "bbc37dc21df04d55a654a66af971f895",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sperrelemente"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "0189b5ceebb7734e990b1e31a9c8ab89",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Honeywell",
                            "0189b5bd28fd735a9afc1ef90696fc66": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "63479e3c30e44bb2b075ea822bec5cb5",
                        "bbc37dc21df04d55a654a66af971f895"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
                            "attr3": "[]",
                            "attr5": "[]",
                            "attr6": "155.0000000000",
                            "attr9": "{\"shipping\":null,\"quantity\":0,\"cuttedCount\":0,\"available\":2,\"deliveries\":[],\"warehouses\":[]}",
                            "jtlorder": "30",
                            "releasedate": "22.12.2022",
                            "tarcode": "83016000"
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "JA-SP-019030.24",
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Das Aufbaugeh\u00e4use JA-SP-019030.24 ist f\u00fcr das Sperrelement JA-SP-019030.20 konzipiert.  Mit diesem Aufbaugeh\u00e4use kann das Sperrelement auch bei T\u00fcren mit erh\u00f6hten T\u00fcrblatt aufgebaut werden. Das Sperrelement wird in dieses Aufbaugeh\u00e4use montiert. \nBitte beachten Sie die Montageanleitungen des Herstellers.",
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "JA-SP-019030.24 Aufbaugeh\u00e4use | Jablotron Zubeh\u00f6r | EPS",
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Aufbaugeh\u00e4use JA-SP-019030.24 ist f\u00fcr das Sperrelement SP-019030.20 , damit kann das Sperrelement bei T\u00fcren mit erh\u00f6hten T\u00fcrblatt verbaut werden",
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": [
                            "Sperrelement",
                            "Honeywell",
                            "8079 - Honeywell",
                            "Sperrelemente"
                        ],
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 166.838,
                    "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 140.2,
                    "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 166.838,
                    "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 140.2,
                    "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 261.8,
                    "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 220.0,
                    "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 166.838,
                    "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 140.2,
                    "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 147.2911,
                    "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 123.774,
                    "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 166.838,
                    "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 140.2,
                    "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 166.838,
                    "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 140.2,
                    "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 166.838,
                    "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 140.2,
                    "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 261.8,
                    "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 220.0,
                    "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 166.838,
                    "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 140.2,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 261.8,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 220.0,
                    "jtlorder": 30,
                    "custom_numbers": []
                },
                "fields": {
                    "displayGroup": [
                        "7c83fd1bfcae52127c114dc50a91cf5c"
                    ]
                },
                "sort": [
                    2,
                    "ja-sp-019024",
                    "0189b5cf227b70caadca01fecaf985b9"
                ]
            }
        ]
    },
    "aggregations": {
        "total-filtered-count": {
            "doc_count": 5,
            "total-count": {
                "value": 5
            }
        }
    }
}

Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search

3.98 ms

Request:

{"index":"sw_dev_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"0189b5bd293f71c6a5e92e9980f13639"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"bbc37dc21df04d55a654a66af971f895"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"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_rule471f2ca5e74440568ba57912bb0f3d50_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc757970f38af8d735ac2bef24_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc757d738cb8f62b8ca13162fd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc781372e48ae25e3fc49e6c75_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5c9aba570cdb1eb3cecd2cd9c14_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5c9abd170d5a439e74a4020e81c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule018c7cebb95d7085930868a24624ed56_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc758c718ca89324f9e3bbcdfd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5c9ab9b73b8b6ca8da792e44880_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","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}}}},"manufacturer_count":{"terms":{"field":"manufacturerId","size":10000}},"propertiesCount":{"terms":{"field":"propertyIds","size":10000}},"immediately-available-filter":{"max":{"field":"availableStock"}}},"size":0,"timeout":"5s"},"search_type":"query_then_fetch"}

Item count:
View formatted request View formatted response View query backtrace


                                    POST http://10.20.0.3:9200/sw_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": [
                                        {
                                            "nested": {
                                                "path": "visibilities",
                                                "query": {
                                                    "bool": {
                                                        "must": [
                                                            {
                                                                "range": {
                                                                    "visibilities.visibility": {
                                                                        "gte": 30
                                                                    }
                                                                }
                                                            },
                                                            {
                                                                "term": {
                                                                    "visibilities.salesChannelId": "0189b5bd293f71c6a5e92e9980f13639"
                                                                }
                                                            }
                                                        ]
                                                    }
                                                }
                                            }
                                        },
                                        {
                                            "term": {
                                                "active": true
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "nested": {
                                    "path": "categoriesRo",
                                    "query": {
                                        "term": {
                                            "categoriesRo.id": "bbc37dc21df04d55a654a66af971f895"
                                        }
                                    }
                                }
                            },
                            {
                                "bool": {
                                    "must_not": [
                                        {
                                            "bool": {
                                                "must_not": [
                                                    {
                                                        "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_rule471f2ca5e74440568ba57912bb0f3d50_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0189b5bc757970f38af8d735ac2bef24_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0189b5bc757d738cb8f62b8ca13162fd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0189b5bc781372e48ae25e3fc49e6c75_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0189b5c9aba570cdb1eb3cecd2cd9c14_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0189b5c9abd170d5a439e74a4020e81c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule018c7cebb95d7085930868a24624ed56_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0189b5bc758c718ca89324f9e3bbcdfd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0189b5c9ab9b73b8b6ca8da792e44880_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "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
                    }
                }
            }
        },
        "manufacturer_count": {
            "terms": {
                "field": "manufacturerId",
                "size": 10000
            }
        },
        "propertiesCount": {
            "terms": {
                "field": "propertyIds",
                "size": 10000
            }
        },
        "immediately-available-filter": {
            "max": {
                "field": "availableStock"
            }
        }
    },
    "size": 0,
    "timeout": "5s"
}


                                    {
    "took": 1,
    "timed_out": false,
    "_shards": {
        "total": 3,
        "successful": 3,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "max_score": null,
        "hits": []
    },
    "aggregations": {
        "manufacturer_count": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
                {
                    "key": "0189b5ceebb7734e990b1e31a9c8ab89",
                    "doc_count": 5
                }
            ]
        },
        "shipping-free-filter": {
            "doc_count": 0,
            "shipping-free": {
                "value": null
            }
        },
        "propertiesCount": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": []
        },
        "rating-exists": {
            "doc_count": 5,
            "rating": {
                "value": 5.0
            }
        },
        "price": {
            "count": 5,
            "min": 10.5,
            "max": 220.0,
            "avg": 130.98,
            "sum": 654.9
        },
        "immediately-available-filter": {
            "value": 10.0
        },
        "options": {
            "doc_count": 0,
            "options": {
                "doc_count_error_upper_bound": 0,
                "sum_other_doc_count": 0,
                "buckets": []
            }
        },
        "properties": {
            "doc_count": 0,
            "properties": {
                "doc_count_error_upper_bound": 0,
                "sum_other_doc_count": 0,
                "buckets": []
            }
        },
        "manufacturer": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
                {
                    "key": "0189b5ceebb7734e990b1e31a9c8ab89",
                    "doc_count": 5
                }
            ]
        }
    }
}

Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate

Cluster Status

{
    "cluster_name": "shopware",
    "status": "yellow",
    "timed_out": false,
    "number_of_nodes": 1,
    "number_of_data_nodes": 1,
    "discovered_master": true,
    "discovered_cluster_manager": true,
    "active_primary_shards": 208,
    "active_shards": 208,
    "relocating_shards": 0,
    "initializing_shards": 0,
    "unassigned_shards": 229,
    "delayed_unassigned_shards": 0,
    "number_of_pending_tasks": 0,
    "number_of_in_flight_fetch": 0,
    "task_max_waiting_in_queue_millis": 0,
    "active_shards_percent_as_number": 47.59725400457666
}

Indices

Name▲	Status	Replication (pri, rep)	Doc Count
security-auditlog-2025.03.01	open	1, 1	158
.ql-datasources	open	1, 0	0
security-auditlog-2025.03.02	open	1, 1	234
security-auditlog-2025.03.05	open	1, 1	259
security-auditlog-2025.03.06	open	1, 1	914
security-auditlog-2025.03.03	open	1, 1	287
security-auditlog-2025.03.04	open	1, 1	446
security-auditlog-2025.03.09	open	1, 1	235
security-auditlog-2025.03.07	open	1, 1	215
security-auditlog-2025.03.08	open	1, 1	100
sw_dev_product_1747138014	open	3, 3	75980
security-auditlog-2025.03.12	open	1, 1	393
security-auditlog-2025.03.13	open	1, 1	233
security-auditlog-2025.03.10	open	1, 1	471
security-auditlog-2025.03.11	open	1, 1	163
security-auditlog-2025.03.16	open	1, 1	243
security-auditlog-2025.03.17	open	1, 1	378
security-auditlog-2025.03.14	open	1, 1	214
security-auditlog-2025.03.15	open	1, 1	487
security-auditlog-2025.03.18	open	1, 1	243
security-auditlog-2025.03.19	open	1, 1	183
sw6_fr_product_manufacturer_1746284168	open	3, 3	11
top_queries-2025.06.30-11096	open	1, 0	4417
top_queries-2025.07.05-40799	open	1, 0	6146
security-auditlog-2025.02.10	open	1, 1	213
security-auditlog-2025.02.12	open	1, 1	158
security-auditlog-2025.02.11	open	1, 1	193
security-auditlog-2025.02.14	open	1, 1	231
security-auditlog-2025.02.13	open	1, 1	135
security-auditlog-2025.02.16	open	1, 1	78
security-auditlog-2025.02.15	open	1, 1	57
security-auditlog-2025.02.18	open	1, 1	74
security-auditlog-2025.02.17	open	1, 1	205
security-auditlog-2025.02.19	open	1, 1	186
security-auditlog-2025.02.21	open	1, 1	208
security-auditlog-2025.02.20	open	1, 1	251
security-auditlog-2025.02.23	open	1, 1	96
security-auditlog-2025.02.22	open	1, 1	611
security-auditlog-2025.02.25	open	1, 1	125
security-auditlog-2025.02.24	open	1, 1	267
security-auditlog-2025.02.27	open	1, 1	205
security-auditlog-2025.02.26	open	1, 1	295
security-auditlog-2025.02.28	open	1, 1	321
security-auditlog-2025.04.10	open	1, 1	44590
security-auditlog-2025.04.13	open	1, 1	1642
top_queries-2025.07.01-40795	open	1, 0	2478
security-auditlog-2025.04.14	open	1, 1	16957
security-auditlog-2025.04.11	open	1, 1	17577
security-auditlog-2025.04.12	open	1, 1	789
security-auditlog-2025.04.17	open	1, 1	14210
security-auditlog-2025.04.18	open	1, 1	1819
security-auditlog-2025.04.15	open	1, 1	21714
security-auditlog-2025.04.16	open	1, 1	14966
security-auditlog-2025.04.19	open	1, 1	1309
.opensearch-observability	open	1, 0	0
top_queries-2025.07.04-40798	open	1, 0	4207
security-auditlog-2025.04.20	open	1, 1	800
security-auditlog-2025.04.21	open	1, 1	2399
security-auditlog-2025.04.24	open	1, 1	19635
security-auditlog-2025.04.25	open	1, 1	14507
sw_dev_category_1747138014	open	3, 3	0
security-auditlog-2025.04.22	open	1, 1	23345
security-auditlog-2025.04.23	open	1, 1	41795
security-auditlog-2025.04.28	open	1, 1	14984
sw_dev_product_manufacturer_1747138014	open	3, 3	0
security-auditlog-2025.04.29	open	1, 1	18696
security-auditlog-2025.04.26	open	1, 1	1524
security-auditlog-2025.04.27	open	1, 1	1757
sw6_fr_product_1746284168	open	3, 3	79618
security-auditlog-2025.03.20	open	1, 1	477
top_queries-2025.07.03-40797	open	1, 0	3822
security-auditlog-2025.03.23	open	1, 1	388
security-auditlog-2025.03.24	open	1, 1	556
security-auditlog-2025.03.21	open	1, 1	203
security-auditlog-2025.03.22	open	1, 1	370
security-auditlog-2025.03.27	open	1, 1	598
security-auditlog-2025.03.28	open	1, 1	244
security-auditlog-2025.03.25	open	1, 1	574
security-auditlog-2025.03.26	open	1, 1	527
sw6_fr_category_1746284168	open	3, 3	121
security-auditlog-2025.03.29	open	1, 1	360
security-auditlog-2025.03.30	open	1, 1	622
security-auditlog-2025.03.31	open	1, 1	505
security-auditlog-2025.04.02	open	1, 1	388
security-auditlog-2025.04.03	open	1, 1	523
security-auditlog-2025.04.01	open	1, 1	447
security-auditlog-2025.04.06	open	1, 1	1393
security-auditlog-2025.04.07	open	1, 1	16875
security-auditlog-2025.04.04	open	1, 1	3437
security-auditlog-2025.04.05	open	1, 1	1658
.kibana_1	open	1, 0	0
security-auditlog-2025.04.08	open	1, 1	23447
security-auditlog-2025.04.09	open	1, 1	18794
security-auditlog-2025.05.22	open	1, 1	16119
security-auditlog-2025.05.21	open	1, 1	23872
security-auditlog-2025.05.20	open	1, 1	25113
security-auditlog-2025.05.26	open	1, 1	19344
security-auditlog-2025.05.25	open	1, 1	2213
security-auditlog-2025.05.24	open	1, 1	1947
security-auditlog-2025.05.23	open	1, 1	18686
security-auditlog-2025.05.29	open	1, 1	2650
security-auditlog-2025.05.28	open	1, 1	17796
security-auditlog-2025.05.27	open	1, 1	18740
.opendistro_security	open	1, 0	10
top_queries-2025.07.06-40800	open	1, 0	4819
security-auditlog-2025.06.01	open	1, 1	2573
top_queries-2025.07.02-40796	open	1, 0	3605
security-auditlog-2025.05.31	open	1, 1	2178
security-auditlog-2025.05.30	open	1, 1	14770
security-auditlog-2025.06.05	open	1, 1	12787
security-auditlog-2025.06.04	open	1, 1	13799
security-auditlog-2025.06.03	open	1, 1	23795
.kibana_92668751_admin_1	open	1, 0	1
security-auditlog-2025.06.02	open	1, 1	17889
security-auditlog-2025.06.09	open	1, 1	2721
security-auditlog-2025.06.08	open	1, 1	1585
security-auditlog-2025.06.07	open	1, 1	1670
security-auditlog-2025.06.06	open	1, 1	15003
security-auditlog-2025.04.30	open	1, 1	23090
security-auditlog-2025.05.04	open	1, 1	1791
security-auditlog-2025.05.03	open	1, 1	1987
security-auditlog-2025.05.02	open	1, 1	13264
security-auditlog-2025.05.01	open	1, 1	2574
security-auditlog-2025.05.08	open	1, 1	18383
security-auditlog-2025.05.07	open	1, 1	14573
security-auditlog-2025.05.06	open	1, 1	17560
security-auditlog-2025.05.05	open	1, 1	24810
security-auditlog-2025.05.09	open	1, 1	14447
security-auditlog-2025.05.11	open	1, 1	2293
security-auditlog-2025.05.10	open	1, 1	1592
security-auditlog-2025.05.15	open	1, 1	17077
security-auditlog-2025.05.14	open	1, 1	17558
security-auditlog-2025.05.13	open	1, 1	17154
security-auditlog-2025.05.12	open	1, 1	24123
security-auditlog-2025.05.19	open	1, 1	30099
security-auditlog-2025.05.18	open	1, 1	2720
security-auditlog-2025.05.17	open	1, 1	2330
security-auditlog-2025.05.16	open	1, 1	16003
security-auditlog-2025.07.03	open	1, 1	16925
security-auditlog-2025.07.04	open	1, 1	16464
security-auditlog-2025.07.05	open	1, 1	1467
security-auditlog-2025.07.06	open	1, 1	2034
security-auditlog-2025.01.20	open	1, 1	125
security-auditlog-2025.01.22	open	1, 1	300
security-auditlog-2025.07.01	open	1, 1	23678
security-auditlog-2025.01.21	open	1, 1	396
security-auditlog-2025.07.02	open	1, 1	16271
security-auditlog-2025.01.24	open	1, 1	235
security-auditlog-2025.01.23	open	1, 1	1641
security-auditlog-2025.01.26	open	1, 1	91
security-auditlog-2025.01.25	open	1, 1	83
security-auditlog-2025.07.07	open	1, 1	14887
security-auditlog-2025.01.28	open	1, 1	98
security-auditlog-2025.01.27	open	1, 1	164
security-auditlog-2025.01.29	open	1, 1	98
security-auditlog-2025.06.30	open	1, 1	12780
security-auditlog-2025.01.31	open	1, 1	209
security-auditlog-2025.01.30	open	1, 1	118
security-auditlog-2025.02.01	open	1, 1	697
security-auditlog-2025.02.03	open	1, 1	489
security-auditlog-2025.02.02	open	1, 1	326
security-auditlog-2025.02.05	open	1, 1	200
security-auditlog-2025.02.04	open	1, 1	69
security-auditlog-2025.02.07	open	1, 1	95
security-auditlog-2025.02.06	open	1, 1	113
security-auditlog-2025.02.09	open	1, 1	91
security-auditlog-2025.02.08	open	1, 1	142
top_queries-2025.07.07-40801	open	1, 0	1231
security-auditlog-2025.06.12	open	1, 1	17250
security-auditlog-2025.06.11	open	1, 1	15252
security-auditlog-2025.06.10	open	1, 1	17823
security-auditlog-2025.06.16	open	1, 1	15829
security-auditlog-2025.06.15	open	1, 1	1544
security-auditlog-2025.06.14	open	1, 1	1817
security-auditlog-2025.06.13	open	1, 1	13260
security-auditlog-2025.06.19	open	1, 1	3554
security-auditlog-2025.06.18	open	1, 1	11007
security-auditlog-2025.06.17	open	1, 1	46144
security-auditlog-2025.06.23	open	1, 1	20465
security-auditlog-2025.06.22	open	1, 1	1547
security-auditlog-2025.06.21	open	1, 1	1586
security-auditlog-2025.06.20	open	1, 1	23776
security-auditlog-2025.06.27	open	1, 1	13471
security-auditlog-2025.06.26	open	1, 1	18283
security-auditlog-2025.06.25	open	1, 1	16643
security-auditlog-2025.06.24	open	1, 1	11274
security-auditlog-2025.06.29	open	1, 1	1520
security-auditlog-2025.01.15	open	1, 1	187
security-auditlog-2025.01.14	open	1, 1	122
security-auditlog-2025.06.28	open	1, 1	1374
security-auditlog-2025.01.17	open	1, 1	77
security-auditlog-2025.01.16	open	1, 1	356
security-auditlog-2025.01.19	open	1, 1	49
security-auditlog-2025.01.18	open	1, 1	248
.plugins-ml-config	open	1, 0	1

Symfony Profiler

GET https://shopware6.eps-dev.com/navigation/bbc37dc21df04d55a654a66af971f895

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Cluster Status

Indices