Symfony Profiler

Query Metrics

16.00 ms Query Time

1 Node(s)

6 Indices

Queries

#▲ Execution Time Info

11.20 ms

#▲	Execution Time	Info
1	11.20 ms	Request: {"index":"sw6_fr_product","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":"c65d225496bb4f7b961e072a3e2d9e4f"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"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"},"search_type":"query_then_fetch"} Item count: 4 View formatted request View formatted response View query backtrace POST http://10.20.0.2:9200/sw6_fr_product/_search?track_total_hits=1&search_type=query_then_fetch 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": "c65d225496bb4f7b961e072a3e2d9e4f" } } } }, { "bool": { "must_not": [ { "bool": { "must_not": [ { "exists": { "field": "displayGroup" } } ] } } ] } } ] } } ] } }, "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": 4, "timed_out": false, "_shards": { "total": 3, "successful": 3, "skipped": 0, "failed": 0 }, "hits": { "total": { "value": 4, "relation": "eq" }, "max_score": null, "hits": [ { "_index": "sw6_fr_product_1719221316", "_id": "0189b5cf3c7e70d98a398f2cfcc561b4", "_score": null, "_source": { "purchasePrices": [ { "currencyId": "b7d2554b0ce847cd82f3ac9bd1c0dfca", "net": 83.4341, "gross": 99.2866, "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": "0189b5cf3c7e70d98a398f2cfcc561b4", "autoIncrement": 2885.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "0189b5bd293f71c6a5e92e9980f13639" } ], "availableStock": 11, "productNumber": "ji-111c", "ean": "8595614119719", "displayGroup": "10e2951ec5f003d0bd39a60ab04f13e9", "sales": 205, "stock": 11, "weight": 0.76, "width": 195.0, "length": 190.0, "height": 160.0, "manufacturerId": "0189b5ced58e706890ac8b39799f9c9a", "manufacturerNumber": "JI-111C", "releaseDate": null, "createdAt": "2019-05-09T00:00:00+00:00", "categoryTree": [ "d7b7b163000841a1876dbff5548c039f", "1e866cbbceb14718b0fc586a82f9bf19", "35dc90db760345fdb823f8a798b7f5ad", "ed73937c1fc54757a390ffc31536aa0d", "c65d225496bb4f7b961e072a3e2d9e4f", "f96d13220e5c41cbac18d02c6331e43e" ], "categoriesRo": [ { "id": "d7b7b163000841a1876dbff5548c039f", "_count": 1 }, { "id": "1e866cbbceb14718b0fc586a82f9bf19", "_count": 1 }, { "id": "35dc90db760345fdb823f8a798b7f5ad", "_count": 1 }, { "id": "ed73937c1fc54757a390ffc31536aa0d", "_count": 1 }, { "id": "c65d225496bb4f7b961e072a3e2d9e4f", "_count": 1 }, { "id": "f96d13220e5c41cbac18d02c6331e43e", "_count": 1 } ], "taxId": "0189b5bc757f71079ecf17a5e531d81e", "tags": [], "parentId": null, "coverId": "fa6c02fb4fcd4f578e63571b86981272", "childCount": 0, "categories": [ { "id": "c65d225496bb4f7b961e072a3e2d9e4f", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Jablotron Video JI-100+" } }, { "id": "f96d13220e5c41cbac18d02c6331e43e", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "8060 - Jablotron" } } ], "manufacturer": { "id": "0189b5ced58e706890ac8b39799f9c9a", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Jablotron" }, "_count": 1 }, "properties": [ { "id": "0189b5cf5f5f7330bcf35b775cc1b543", "_count": 1, "groupId": "0189b5cf5f4373aea156ba4f6334d89f", "group": { "id": "0189b5cf5f4373aea156ba4f6334d89f", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "-20 bis +60\u00b0C" } }, { "id": "0189b5cf5f8f73498431f1ee5ff7a452", "_count": 1, "groupId": "0189b5cf5f8f73498431f1ee66947f0f", "group": { "id": "0189b5cf5f8f73498431f1ee66947f0f", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2MP" } }, { "id": "0189b5cf5f9171179ab24aac63bac490", "_count": 1, "groupId": "0189b5cf5f8f73498431f1ee66947f0f", "group": { "id": "0189b5cf5f8f73498431f1ee66947f0f", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "1920x1080 Pixel" } }, { "id": "0189b5cf622b72b29d72ad2c3ea44522", "_count": 1, "groupId": "0189b5cf62297196ba7ea4958d9a4abe", "group": { "id": "0189b5cf62297196ba7ea4958d9a4abe", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "30m" } }, { "id": "0189b5cf625f7102b41b104a1ead8781", "_count": 1, "groupId": "0189b5cf6260739bbbf4551dd3cfeb3e", "group": { "id": "0189b5cf6260739bbbf4551dd3cfeb3e", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "100" } }, { "id": "9ca9a210df8444938c7e80fa08dde355", "_count": 1, "groupId": "0189b5cf0a0f71f08bc4f2efb072a8d5", "group": { "id": "0189b5cf0a0f71f08bc4f2efb072a8d5", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "wei\u00df" } } ], "options": [], "categoryIds": [ "c65d225496bb4f7b961e072a3e2d9e4f", "f96d13220e5c41cbac18d02c6331e43e" ], "optionIds": [], "propertyIds": [ "0189b5cf5f5f7330bcf35b775cc1b543", "0189b5cf5f8f73498431f1ee5ff7a452", "0189b5cf5f9171179ab24aac63bac490", "0189b5cf622b72b29d72ad2c3ea44522", "0189b5cf625f7102b41b104a1ead8781", "9ca9a210df8444938c7e80fa08dde355" ], "tagIds": [], "states": [ "is-physical" ], "customFields": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": { "ran_artikel": "Ja", "warenzolltarifnummer": 85258900.0, "ger\u00e4teart___alt_l\u00f6schen": "Jablotron", "ear_hersteller": "Jablotron", "verpackung_meldung": "ja", "hersteller___alt_l\u00f6schen": "Jablotron", "gewicht_(verpackung)": 0.11, "altg_meldung_ear": "Ja", "aktiv_o_alt___alt_ps": "aktiv", "liefersperre": 0.0, "verpackung_meldung_=_ja": "ja", "verpackung_gewicht": 0.11, "ear_altg_meldung_=_ja": "Ja", "attr1": "D8FD96B7-7319-423C-BF23-BBFD7DB17791", "attr3": "[]", "attr5": "[{\"id\":\"167\",\"pleasant_id\":\"D8FD96B7-7319-423C-BF23-BBFD7DB17791\",\"youtube_id\":\"gYAUQL1THN8\",\"label\":\"eps - Jablotron JA 100 Installation einer Video Verifikation\",\"description\":\"\",\"position\":null,\"date_create\":\"2019-05-09 18:05:07\"}]", "attr6": 371.0, "attr9": "{\"shipping\":null,\"quantity\":0,\"cuttedCount\":0,\"available\":11,\"deliveries\":[]}", "attr17": "https:\/\/www.eps-system.de\/detail\/index\/sArticle\/1319", "attr16": "https:\/\/www.eps-vertrieb.de\/detail\/index\/sArticle\/343", "jtlorder": 0.0 } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "JI-111C" }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Die Jablotron Kuppelkamera JI-111C ist f\u00fcr den Au\u00dfen- und Inneneinsatz geeignet. Die IP basierte Videoverifikationskamera wird an das lokale Netzwerk \/ Router angeschlossen und ist sehr einfach zu installieren und in die APP MyJablotron ein lernbar. Durch die kompakte und unauff\u00e4llige Bauform ist diese Kuppelkamera bestens geeignet zur diskreten und unauff\u00e4lligen Video\u00fcberwachung. Die Kamera verf\u00fcgt \u00fcber einen lokalen Ringspeicher, in dem die Videobilder lokal permanent f\u00fcr eine Minute gespeichert werden. Im Alarmfall werden die Bilddaten als Videosequenz an die APP MyJablotron oder zur NSL Leitstelle \u00fcbertragen. Die Stromversorgung erfolgt \u00fcber PoE (Power over Ethernet). Alternativ kann ein 12 V Netzteil verwendet werden. Die Jablotron IP Kameras sind nur mit MyJablotron verwendbar und k\u00f6nnen nicht f\u00fcr andere Videosystem verwendet werden.\nLeistungsmerkmale:\n\nIP Netzwerkkamera zur Integration in MyJablotron\nAufl\u00f6sung: 2 MP \/ 1920 x 1080\nObjektivbrennweite: 2,8 mm ca. 115\u00b0 Blickwinkel\nintegrierter IR Strahler: Reichweite ca. 30 m\nintegrierter Ringspeicher 1 Min.\nBildrate: 8 Bilder \/ Sek.\nGegenlichtkompensation WDR\nInklusive AP Anschlussdose\nformsch\u00f6nes Design f\u00fcr diskrete Anwendungen\n\nTechnische Daten:\n\nDie Jablotron IP Kameras belegen keine Position im JA 100 System\nStromversorgung 12 V DC\/ 350 mA\nStromversorgung \u00fcber POE, alternativ 12 V Netzteil (bitte separat bestellen)\nAbmessungen: Durchmesser 111 mm, H\u00f6he 82 mm\nSchutzklasse IP 67\nBetriebstemperatur: -25 bis 60 \u00b0C\nZulassung EN 50130-4, EN 55032\n" }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "JI-111C Kuppelkamera \| Jablotron Videotechnik \| EPS" }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Entdecken Sie die innovative IP basierte Kuppelkamera JI-111C f\u00fcr den Innen- und Au\u00dfenbereich in einer kompakten und unauff\u00e4lligen Bauform." }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": [] }, "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 198.73, "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 167.0, "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 198.73, "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 167.0, "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 198.73, "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 167.0, "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 198.73, "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 167.0, "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 441.49, "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 371.0, "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 441.49, "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 371.0, "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 198.73, "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 167.0, "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 198.73, "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 167.0, "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 198.73, "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 167.0, "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 104.1333, "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 87.507, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 441.49, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 371.0, "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "ji-111c", "8595614119719", "kuppelkamera", "jablotron", "videotechnik", "eps", "ji-111c kuppelkamera \| jablotron videotechnik \| eps" ], "jtlOrder": 0, "custom_numbers": [] }, "fields": { "displayGroup": [ "10e2951ec5f003d0bd39a60ab04f13e9" ] }, "sort": [ 11, "ji-111c", "0189b5cf3c7e70d98a398f2cfcc561b4" ] }, { "_index": "sw6_fr_product_1719221316", "_id": "0189b5cf3c86730b92ceb685f1b7cd97", "_score": null, "_source": { "purchasePrices": [ { "currencyId": "b7d2554b0ce847cd82f3ac9bd1c0dfca", "net": 89.1681, "gross": 106.11, "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": "0189b5cf3c86730b92ceb685f1b7cd97", "autoIncrement": 2886.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "0189b5bd293f71c6a5e92e9980f13639" } ], "availableStock": 10, "productNumber": "ji-112c", "ean": "8595614119726", "displayGroup": "c79bc50402c2ddebf3fa8d914c129699", "sales": 126, "stock": 10, "weight": 1.56, "width": 160.0, "length": 390.0, "height": 160.0, "manufacturerId": "0189b5ced58e706890ac8b39799f9c9a", "manufacturerNumber": "JI-112C", "releaseDate": null, "createdAt": "2019-05-09T00:00:00+00:00", "categoryTree": [ "d7b7b163000841a1876dbff5548c039f", "1e866cbbceb14718b0fc586a82f9bf19", "35dc90db760345fdb823f8a798b7f5ad", "ed73937c1fc54757a390ffc31536aa0d", "c65d225496bb4f7b961e072a3e2d9e4f", "f96d13220e5c41cbac18d02c6331e43e" ], "categoriesRo": [ { "id": "d7b7b163000841a1876dbff5548c039f", "_count": 1 }, { "id": "1e866cbbceb14718b0fc586a82f9bf19", "_count": 1 }, { "id": "35dc90db760345fdb823f8a798b7f5ad", "_count": 1 }, { "id": "ed73937c1fc54757a390ffc31536aa0d", "_count": 1 }, { "id": "c65d225496bb4f7b961e072a3e2d9e4f", "_count": 1 }, { "id": "f96d13220e5c41cbac18d02c6331e43e", "_count": 1 } ], "taxId": "0189b5bc757f71079ecf17a5e531d81e", "tags": [], "parentId": null, "coverId": "ab4acf4687644fcf9c61c7fc162f95f7", "childCount": 0, "categories": [ { "id": "c65d225496bb4f7b961e072a3e2d9e4f", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Jablotron Video JI-100+" } }, { "id": "f96d13220e5c41cbac18d02c6331e43e", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "8060 - Jablotron" } } ], "manufacturer": { "id": "0189b5ced58e706890ac8b39799f9c9a", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Jablotron" }, "_count": 1 }, "properties": [ { "id": "0189b5cf5f5f7330bcf35b775cc1b543", "_count": 1, "groupId": "0189b5cf5f4373aea156ba4f6334d89f", "group": { "id": "0189b5cf5f4373aea156ba4f6334d89f", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "-20 bis +60\u00b0C" } }, { "id": "0189b5cf5f8f73498431f1ee5ff7a452", "_count": 1, "groupId": "0189b5cf5f8f73498431f1ee66947f0f", "group": { "id": "0189b5cf5f8f73498431f1ee66947f0f", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2MP" } }, { "id": "0189b5cf5f9171179ab24aac63bac490", "_count": 1, "groupId": "0189b5cf5f8f73498431f1ee66947f0f", "group": { "id": "0189b5cf5f8f73498431f1ee66947f0f", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "1920x1080 Pixel" } }, { "id": "0189b5cf622d70bebb8f8084e965dd87", "_count": 1, "groupId": "0189b5cf62297196ba7ea4958d9a4abe", "group": { "id": "0189b5cf62297196ba7ea4958d9a4abe", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "50m" } }, { "id": "0189b5cf625f7102b41b104a1ead8781", "_count": 1, "groupId": "0189b5cf6260739bbbf4551dd3cfeb3e", "group": { "id": "0189b5cf6260739bbbf4551dd3cfeb3e", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "100" } }, { "id": "0189b5cf6a03716bb77a6737db744c14", "_count": 1, "groupId": "0189b5cf69fd7078bc3dfe56e0a6fa5d", "group": { "id": "0189b5cf69fd7078bc3dfe56e0a6fa5d", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "200mA" } }, { "id": "9ca9a210df8444938c7e80fa08dde355", "_count": 1, "groupId": "0189b5cf0a0f71f08bc4f2efb072a8d5", "group": { "id": "0189b5cf0a0f71f08bc4f2efb072a8d5", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "wei\u00df" } } ], "options": [], "categoryIds": [ "c65d225496bb4f7b961e072a3e2d9e4f", "f96d13220e5c41cbac18d02c6331e43e" ], "optionIds": [], "propertyIds": [ "0189b5cf5f5f7330bcf35b775cc1b543", "0189b5cf5f8f73498431f1ee5ff7a452", "0189b5cf5f9171179ab24aac63bac490", "0189b5cf622d70bebb8f8084e965dd87", "0189b5cf625f7102b41b104a1ead8781", "0189b5cf6a03716bb77a6737db744c14", "9ca9a210df8444938c7e80fa08dde355" ], "tagIds": [], "states": [ "is-physical" ], "customFields": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": { "ear_hersteller": "Jablotron", "aktiv_o_alt___alt_ps": "aktiv", "warenzolltarifnummer": 85258900.0, "ger\u00e4teart___alt_l\u00f6schen": "Jablotron", "gewicht_(verpackung)": 0.11, "verpackung_meldung": "ja", "altg_meldung_ear": "Ja", "ran_artikel": "Ja", "hersteller___alt_l\u00f6schen": "Jablotron", "verpackung_gewicht": 0.11, "verpackung_meldung_=_ja": "ja", "ear_altg_meldung_=_ja": "Ja", "attr1": "C0007A8E-CBC2-49FC-A43E-FA9E75C1A8DD", "attr3": "[]", "attr5": "[{\"id\":\"168\",\"pleasant_id\":\"C0007A8E-CBC2-49FC-A43E-FA9E75C1A8DD\",\"youtube_id\":\"gYAUQL1THN8\",\"label\":\"eps - Jablotron JA 100 Installation einer Video Verifikation\",\"description\":\"https:\\\/\\\/www.youtube.com\\\/watch?v=gYAUQL1THN8\",\"position\":null,\"date_create\":\"2019-05-09 18:50:09\"}]", "attr6": 393.0, "attr9": "{\"shipping\":null,\"quantity\":0,\"cuttedCount\":0,\"available\":10,\"deliveries\":[]}", "attr17": "https:\/\/www.eps-system.de\/detail\/index\/sArticle\/1229", "attr16": "https:\/\/www.eps-vertrieb.de\/detail\/index\/sArticle\/344", "liefersperre": 0.0, "jtlorder": 0.0 } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "JI-112C" }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Die Jablotron Bulletkamera JI-112C ist haupts\u00e4chlich f\u00fcr den Au\u00dfeneinsatz konzipiert. Die IP basierte Videoverifikationskamera wird an das lokale Netzwerk \/ Router angeschlossen und ist sehr einfach zu installieren und in die APP MyJablotron ein lernbar. Dieses formsch\u00f6ne Geh\u00e4use und die kompakte Bauform passen sich jeder Fassade und Geb\u00e4udeart gut an. Die Kamera verf\u00fcgt \u00fcber einen lokalen Ringspeicher, in dem die Videobilder lokal permanent f\u00fcr eine Minute gespeichert werden. Im Alarmfall werden die Bilddaten als Videosequenz an die APP MyJablotron oder zur Notruf-Service-Leitstelle (NSL) \u00fcbertragen. Die Stromversorgung erfolgt \u00fcber PoE (Power over Ethernet). Alternativ kann ein 12 V Netzteil verwendet werden. Die Jablotron IP Kameras sind nur mit MyJablotron verwendbar und k\u00f6nnen nicht f\u00fcr andere Videosystem verwendet werden.\nLeistungsmerkmale:\n\nIP Netzwerkkamera zur Integration in MyJablotron\nAufl\u00f6sung: 2 MP \/ 1920 x 1080\nObjektivbrennweite: 4 mm ca. 90\u00b0 Blickwinkel\nintegrierter IR Strahler: Reichweite ca. 50 m\nintegrierter Ringspeicher 1 Min.\nBildrate: 8 Bilder \/ Sek.\nGegenlichtkompensation WDR\nInklusive AP Anschlussdose\nformsch\u00f6nes Design f\u00fcr diskrete Anwendungen\n\nTechnische Daten:\n\nDie Jablotron IP Kameras belegen keine Position im JA 100 System\nStromversorgung 12 V DC\/ 350 mA\nStromversorgung \u00fcber POE, alternativ 12 V Netzteil (bitte separat bestellen)\nAbmessungen: Durchmesser 300 x 90 x 90 mm\nSchutzklasse IP 67\nBetriebstemperatur: -25 bis 60 \u00b0C\nZulassung EN 50130-4, EN 55032\n" }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "JI-112C Au\u00dfenkamera \| Jablotron Videotechnik \| EPS" }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Die Kamera JI 112C ist f\u00fcr den Au\u00dfeneinsatz konzipiert. Die IP basierte Videoverifikationskamera wird an das lokale Netzwerk \/ Router angeschlossen." }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": [] }, "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 210.63, "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 177.0, "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 210.63, "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 177.0, "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 210.63, "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 177.0, "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 467.67, "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 393.0, "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 210.63, "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 177.0, "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 210.63, "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 177.0, "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 210.63, "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 177.0, "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 467.67, "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 393.0, "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 210.63, "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 177.0, "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 110.8057, "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 93.114, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 467.67, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 393.0, "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "ji-112c", "8595614119726", "au\u00dfenkamera", "jablotron", "videotechnik", "eps", "ji-112c au\u00dfenkamera \| jablotron videotechnik \| eps" ], "jtlOrder": 0, "custom_numbers": [] }, "fields": { "displayGroup": [ "c79bc50402c2ddebf3fa8d914c129699" ] }, "sort": [ 10, "ji-112c", "0189b5cf3c86730b92ceb685f1b7cd97" ] }, { "_index": "sw6_fr_product_1719221316", "_id": "0189b5cf20c2708d8e70b7f6dbfde4d6", "_score": null, "_source": { "purchasePrices": [ { "currencyId": "b7d2554b0ce847cd82f3ac9bd1c0dfca", "net": 49.099, "gross": 58.4278, "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": "0189b5cf20c2708d8e70b7f6dbfde4d6", "autoIncrement": 2338.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "0189b5bd293f71c6a5e92e9980f13639" } ], "availableStock": 9, "productNumber": "ja-vibo-5010", "ean": null, "displayGroup": "74f12fcd21b1aed0cbb78fc4a0afd505", "sales": 43, "stock": 9, "weight": 0.135, "width": 100.0, "length": 100.0, "height": 40.0, "manufacturerId": "0189b5ced58e706890ac8b39799f9c9a", "manufacturerNumber": "JA-ViBo 5010", "releaseDate": null, "createdAt": "2019-06-19T00:00:00+00:00", "categoryTree": [ "d7b7b163000841a1876dbff5548c039f", "1e866cbbceb14718b0fc586a82f9bf19", "0c075974861844fcac5e84b79a8457bb", "35dc90db760345fdb823f8a798b7f5ad", "ed73937c1fc54757a390ffc31536aa0d", "96155915065d498e9fe4170600df2004", "c65d225496bb4f7b961e072a3e2d9e4f", "f96d13220e5c41cbac18d02c6331e43e" ], "categoriesRo": [ { "id": "d7b7b163000841a1876dbff5548c039f", "_count": 1 }, { "id": "1e866cbbceb14718b0fc586a82f9bf19", "_count": 1 }, { "id": "0c075974861844fcac5e84b79a8457bb", "_count": 1 }, { "id": "35dc90db760345fdb823f8a798b7f5ad", "_count": 1 }, { "id": "ed73937c1fc54757a390ffc31536aa0d", "_count": 1 }, { "id": "96155915065d498e9fe4170600df2004", "_count": 1 }, { "id": "c65d225496bb4f7b961e072a3e2d9e4f", "_count": 1 }, { "id": "f96d13220e5c41cbac18d02c6331e43e", "_count": 1 } ], "taxId": "0189b5bc757f71079ecf17a5e531d81e", "tags": [], "parentId": null, "coverId": "4ee5e5624e57423b88c385ffc7935840", "childCount": 0, "categories": [ { "id": "96155915065d498e9fe4170600df2004", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Bus Ausgangsmodule und Eingangsmodule" } }, { "id": "c65d225496bb4f7b961e072a3e2d9e4f", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Jablotron Video JI-100+" } }, { "id": "f96d13220e5c41cbac18d02c6331e43e", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "8060 - Jablotron" } } ], "manufacturer": { "id": "0189b5ced58e706890ac8b39799f9c9a", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Jablotron" }, "_count": 1 }, "properties": [ { "id": "0189b5cf587b72079e6fb353c31955d8", "_count": 1, "groupId": "0189b5cf587970509c11f4ec00c8b0d7", "group": { "id": "0189b5cf587970509c11f4ec00c8b0d7", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "4" } }, { "id": "0189b5cf5f85734694cf4101034837c4", "_count": 1, "groupId": "0189b5cf5f4373aea156ba4f6334d89f", "group": { "id": "0189b5cf5f4373aea156ba4f6334d89f", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "10 \u00b0C bis +40 \u00b0C" } }, { "id": "0189b5cf615e70839d374fd5b1d8496f", "_count": 1, "groupId": "0189b5cf615d7034a4a5e9bf51836360", "group": { "id": "0189b5cf615d7034a4a5e9bf51836360", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Bus" } }, { "id": "0189b5cf625f7102b41b104a1ead8781", "_count": 1, "groupId": "0189b5cf6260739bbbf4551dd3cfeb3e", "group": { "id": "0189b5cf6260739bbbf4551dd3cfeb3e", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "100" } }, { "id": "0189b5cf6a05736aaae2b9c190cacb8c", "_count": 1, "groupId": "0189b5cf69fd7078bc3dfe56e0a6fa5d", "group": { "id": "0189b5cf69fd7078bc3dfe56e0a6fa5d", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "25 mA" } }, { "id": "0189b5cf6a2a7086a1d4a706a60c98c9", "_count": 1, "groupId": "0189b5cf6a1c7017801fd47cbf51d753", "group": { "id": "0189b5cf6a1c7017801fd47cbf51d753", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "200 mA" } }, { "id": "9ca9a210df8444938c7e80fa08dde355", "_count": 1, "groupId": "0189b5cf0a0f71f08bc4f2efb072a8d5", "group": { "id": "0189b5cf0a0f71f08bc4f2efb072a8d5", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "wei\u00df" } } ], "options": [], "categoryIds": [ "96155915065d498e9fe4170600df2004", "c65d225496bb4f7b961e072a3e2d9e4f", "f96d13220e5c41cbac18d02c6331e43e" ], "optionIds": [], "propertyIds": [ "0189b5cf587b72079e6fb353c31955d8", "0189b5cf5f85734694cf4101034837c4", "0189b5cf615e70839d374fd5b1d8496f", "0189b5cf625f7102b41b104a1ead8781", "0189b5cf6a05736aaae2b9c190cacb8c", "0189b5cf6a2a7086a1d4a706a60c98c9", "9ca9a210df8444938c7e80fa08dde355" ], "tagIds": [], "states": [ "is-physical" ], "customFields": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": { "warenzolltarifnummer": 85319000.0, "hersteller___alt_l\u00f6schen": "Jablotron", "ger\u00e4teart___alt_l\u00f6schen": "Jablotron", "ran_artikel": "Nein", "gewicht_(verpackung)": 0.021, "aktiv_o_alt___alt_ps": "aktiv", "liefersperre": 0.0, "verpackung_gewicht": 0.021, "attr1": "4A0E528B-B56F-47B8-96BE-7AE05B9E3CA4", "attr3": "[]", "attr5": "[]", "attr6": 225.0, "attr9": "{\"shipping\":null,\"quantity\":0,\"cuttedCount\":0,\"available\":9,\"deliveries\":[]}", "attr17": "https:\/\/www.eps-system.de\/detail\/index\/sArticle\/1306", "attr16": "https:\/\/www.eps-vertrieb.de\/detail\/index\/sArticle\/2011", "jtlorder": 0.0 } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "JA-ViBo 5010" }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Die Video - Anschlussbox ViBO 5010 dient als Schnittstelle zwischen dem JA 100 Alarmsystem und Video\u00fcberwachungsanlagen. \u00dcber das Jablotron Bus - Modul JA-114H k\u00f6nnen unterschiedlichen Ein - und Ausg\u00e4nge aus dem Alarmsystem an die Video\u00fcberwachungsanlage \u00fcbergeben werden.\nEs k\u00f6nnen auch Meldungen und Ereignisse von dem Video\u00fcberwachungssystem NVR an die Alarmanlage \u00fcbergeben werden. Die Videobox ist anschlussfertig vormontiert inkl. Geh\u00e4use.\nLeistungsmerkmale:\n\n4 Eing\u00e4nge und 4 Ausg\u00e4ngen\nbelegt vier Positionen im JA 100 Alarmsystem\nStromversorgung: 12 V \u00fcber den Bus der Zentrale\nInkl. Geh\u00e4use JA-190PL\n" }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "JA-ViBo 5010 Video - Anschlussbox \| Jablotron Zubeh\u00f6r \| EPS" }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Die Video - Anschlussbox ViBO 5010 dient als Schnittstelle zwischen dem JA 100 Alarmsystem und Video\u00fcberwachungsanlagen." }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": [] }, "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 134.47, "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 113.0, "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 134.47, "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 113.0, "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 283.22, "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 238.0, "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 134.47, "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 113.0, "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 283.22, "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 238.0, "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 134.47, "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 113.0, "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 134.47, "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 113.0, "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 134.47, "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 113.0, "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 134.47, "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 113.0, "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 78.2663, "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 65.77, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 283.22, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 238.0, "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "ja-vibo-5010", "ja-vibo", "5010", "video", "anschlussbox", "jablotron", "zubeh\u00f6r", "eps", "ja-vibo 5010", "ja-vibo 5010 video - anschlussbox \| jablotron zubeh\u00f6r \| eps" ], "jtlOrder": 0, "custom_numbers": [] }, "fields": { "displayGroup": [ "74f12fcd21b1aed0cbb78fc4a0afd505" ] }, "sort": [ 9, "ja-vibo-5010", "0189b5cf20c2708d8e70b7f6dbfde4d6" ] }, { "_index": "sw6_fr_product_1719221316", "_id": "0189b5cf203772d683ef1cccd483b303", "_score": null, "_source": { "purchasePrices": [ { "currencyId": "b7d2554b0ce847cd82f3ac9bd1c0dfca", "net": 24.3439, "gross": 28.9692, "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": "0189b5cf203772d683ef1cccd483b303", "autoIncrement": 2315.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "0189b5bd293f71c6a5e92e9980f13639" } ], "availableStock": 2, "productNumber": "ji-114z", "ean": "8595614123921", "displayGroup": "60665b67fd735262ac6965e16b3653e0", "sales": 59, "stock": 2, "weight": 0.635, "width": 110.0, "length": 200.0, "height": 90.0, "manufacturerId": "0189b5ced58e706890ac8b39799f9c9a", "manufacturerNumber": "JI-114Z", "releaseDate": null, "createdAt": "2019-05-24T00:00:00+00:00", "categoryTree": [ "d7b7b163000841a1876dbff5548c039f", "1e866cbbceb14718b0fc586a82f9bf19", "35dc90db760345fdb823f8a798b7f5ad", "ed73937c1fc54757a390ffc31536aa0d", "c65d225496bb4f7b961e072a3e2d9e4f", "f96d13220e5c41cbac18d02c6331e43e" ], "categoriesRo": [ { "id": "d7b7b163000841a1876dbff5548c039f", "_count": 1 }, { "id": "1e866cbbceb14718b0fc586a82f9bf19", "_count": 1 }, { "id": "35dc90db760345fdb823f8a798b7f5ad", "_count": 1 }, { "id": "ed73937c1fc54757a390ffc31536aa0d", "_count": 1 }, { "id": "c65d225496bb4f7b961e072a3e2d9e4f", "_count": 1 }, { "id": "f96d13220e5c41cbac18d02c6331e43e", "_count": 1 } ], "taxId": "0189b5bc757f71079ecf17a5e531d81e", "tags": [], "parentId": null, "coverId": "f42e7154cf7e4299b029a20dbdd9df99", "childCount": 0, "categories": [ { "id": "c65d225496bb4f7b961e072a3e2d9e4f", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Jablotron Video JI-100+" } }, { "id": "f96d13220e5c41cbac18d02c6331e43e", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "8060 - Jablotron" } } ], "manufacturer": { "id": "0189b5ced58e706890ac8b39799f9c9a", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Jablotron" }, "_count": 1 }, "properties": [ { "id": "0189b5cf625f7102b41b104a1ead8781", "_count": 1, "groupId": "0189b5cf6260739bbbf4551dd3cfeb3e", "group": { "id": "0189b5cf6260739bbbf4551dd3cfeb3e", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "100" } }, { "id": "0189b5cf6261731aa3b57e889fb380be", "_count": 1, "groupId": "0189b5cf6260739bbbf4551dd3cfeb3e", "group": { "id": "0189b5cf6260739bbbf4551dd3cfeb3e", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "100+" } } ], "options": [], "categoryIds": [ "c65d225496bb4f7b961e072a3e2d9e4f", "f96d13220e5c41cbac18d02c6331e43e" ], "optionIds": [], "propertyIds": [ "0189b5cf625f7102b41b104a1ead8781", "0189b5cf6261731aa3b57e889fb380be" ], "tagIds": [], "states": [ "is-physical" ], "customFields": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": { "aktiv_o_alt___alt_ps": "aktiv", "ear_hersteller": "Jablotron", "ger\u00e4teart___alt_l\u00f6schen": "Jablotron", "altg_meldung_ear": "Ja", "ran_artikel": "Ja", "gewicht_(verpackung)": 0.29, "warenzolltarifnummer": 85176200.0, "verpackung_meldung": "ja", "hersteller___alt_l\u00f6schen": "Jablotron", "liefersperre": 0.0, "ear_altg_meldung_=_ja": "Ja", "verpackung_gewicht": 0.29, "verpackung_meldung_=_ja": "ja", "attr1": "2022117F-C664-4DC9-A21F-AF2EF92F35CE", "attr3": "[]", "attr5": "[]", "attr6": 140.0, "attr7": "[]", "attr9": "{\"shipping\":null,\"quantity\":0,\"cuttedCount\":0,\"available\":2,\"deliveries\":[]}", "attr17": "https:\/\/www.eps-system.de\/detail\/index\/sArticle\/1382", "attr16": "https:\/\/www.eps-vertrieb.de\/detail\/index\/sArticle\/1511", "jtlorder": 0.0 } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "JI-114Z" }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "PoE Switch - 4 Ports der Switch passend f\u00fcr die Jablotron Kameras: JI-111C und JI-112C Teil des JABLOTRON 100+ Systems\nLeistungsmerkmale:\n\nzur Einbindung der IP Netzwerkkameras von JABLOTRON\nNetzteil\n\nTechnische Daten:\n\nDie Jablotron IP Kameras belegen keine Position im JA 100 System\nStromversorgung mit POE f\u00fcr die Kameras, alternativ 12 V Netzteil (bitte separat bestellen)\n" }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "JI-114Z PoE Switch 4 Port \| Jablotron Zubeh\u00f6r \| EPS" }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Entdecken Sie den 4 Port PoE Switch JI-114Z speziell f\u00fcr die Jablotron Kameras JI-111C und JI-112C des JA-100 Systems" }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": [] }, "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 78.54, "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 66.0, "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 78.54, "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 66.0, "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 78.54, "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 66.0, "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 174.93, "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 147.0, "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 78.54, "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 66.0, "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 41.0711, "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 34.5135, "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 78.54, "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 66.0, "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 78.54, "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 66.0, "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 78.54, "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 66.0, "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 174.93, "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 147.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 174.93, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 147.0, "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "ji-114z", "8595614123921", "poe", "switch", "port", "jablotron", "zubeh\u00f6r", "eps", "ji-114z poe switch 4 port \| jablotron zubeh\u00f6r \| eps" ], "jtlOrder": 0, "custom_numbers": [] }, "fields": { "displayGroup": [ "60665b67fd735262ac6965e16b3653e0" ] }, "sort": [ 2, "ji-114z", "0189b5cf203772d683ef1cccd483b303" ] } ] }, "aggregations": { "total-filtered-count": { "doc_count": 4, "total-count": { "value": 4 } } } } `Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search`
2	5.72 ms	Request: {"index":"sw6_fr_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":"c65d225496bb4f7b961e072a3e2d9e4f"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"aggregations":{"manufacturer":{"terms":{"field":"manufacturerId","size":10000}},"price":{"stats":{"script":{"id":"cheapest_price","params":{"accessors":[{"key":"cheapest_price_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}}}},"brands":{"terms":{"field":"manufacturerId","size":10000}}},"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.2:9200/sw6_fr_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": "c65d225496bb4f7b961e072a3e2d9e4f" } } } }, { "bool": { "must_not": [ { "bool": { "must_not": [ { "exists": { "field": "displayGroup" } } ] } } ] } } ] } } ] } }, "aggregations": { "manufacturer": { "terms": { "field": "manufacturerId", "size": 10000 } }, "price": { "stats": { "script": { "id": "cheapest_price", "params": { "accessors": [ { "key": "cheapest_price_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 } } } }, "brands": { "terms": { "field": "manufacturerId", "size": 10000 } } }, "size": 0, "timeout": "5s" } { "took": 3, "timed_out": false, "_shards": { "total": 3, "successful": 3, "skipped": 0, "failed": 0 }, "hits": { "max_score": null, "hits": [] }, "aggregations": { "shipping-free-filter": { "doc_count": 0, "shipping-free": { "value": null } }, "brands": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [ { "key": "0189b5ced58e706890ac8b39799f9c9a", "doc_count": 4 } ] }, "rating-exists": { "doc_count": 4, "rating": { "value": 0.0 } }, "price": { "count": 4, "min": 147.0, "max": 393.0, "avg": 287.25, "sum": 1149.0 }, "options": { "doc_count": 0, "options": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [] } }, "properties": { "doc_count": 22, "properties": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [ { "key": "0189b5cf625f7102b41b104a1ead8781", "doc_count": 4 }, { "key": "9ca9a210df8444938c7e80fa08dde355", "doc_count": 3 }, { "key": "0189b5cf5f5f7330bcf35b775cc1b543", "doc_count": 2 }, { "key": "0189b5cf5f8f73498431f1ee5ff7a452", "doc_count": 2 }, { "key": "0189b5cf5f9171179ab24aac63bac490", "doc_count": 2 }, { "key": "0189b5cf587b72079e6fb353c31955d8", "doc_count": 1 }, { "key": "0189b5cf5f85734694cf4101034837c4", "doc_count": 1 }, { "key": "0189b5cf615e70839d374fd5b1d8496f", "doc_count": 1 }, { "key": "0189b5cf622b72b29d72ad2c3ea44522", "doc_count": 1 }, { "key": "0189b5cf622d70bebb8f8084e965dd87", "doc_count": 1 }, { "key": "0189b5cf6261731aa3b57e889fb380be", "doc_count": 1 }, { "key": "0189b5cf6a03716bb77a6737db744c14", "doc_count": 1 }, { "key": "0189b5cf6a05736aaae2b9c190cacb8c", "doc_count": 1 }, { "key": "0189b5cf6a2a7086a1d4a706a60c98c9", "doc_count": 1 } ] } }, "manufacturer": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [ { "key": "0189b5ced58e706890ac8b39799f9c9a", "doc_count": 4 } ] } } } `Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate`

Request:

{"index":"sw6_fr_product","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":"c65d225496bb4f7b961e072a3e2d9e4f"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"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"},"search_type":"query_then_fetch"}

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


                                    POST http://10.20.0.2:9200/sw6_fr_product/_search?track_total_hits=1&search_type=query_then_fetch
    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": "c65d225496bb4f7b961e072a3e2d9e4f"
                                        }
                                    }
                                }
                            },
                            {
                                "bool": {
                                    "must_not": [
                                        {
                                            "bool": {
                                                "must_not": [
                                                    {
                                                        "exists": {
                                                            "field": "displayGroup"
                                                        }
                                                    }
                                                ]
                                            }
                                        }
                                    ]
                                }
                            }
                        ]
                    }
                }
            ]
        }
    },
    "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": 4,
    "timed_out": false,
    "_shards": {
        "total": 3,
        "successful": 3,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": {
            "value": 4,
            "relation": "eq"
        },
        "max_score": null,
        "hits": [
            {
                "_index": "sw6_fr_product_1719221316",
                "_id": "0189b5cf3c7e70d98a398f2cfcc561b4",
                "_score": null,
                "_source": {
                    "purchasePrices": [
                        {
                            "currencyId": "b7d2554b0ce847cd82f3ac9bd1c0dfca",
                            "net": 83.4341,
                            "gross": 99.2866,
                            "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": "0189b5cf3c7e70d98a398f2cfcc561b4",
                    "autoIncrement": 2885.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "0189b5bd293f71c6a5e92e9980f13639"
                        }
                    ],
                    "availableStock": 11,
                    "productNumber": "ji-111c",
                    "ean": "8595614119719",
                    "displayGroup": "10e2951ec5f003d0bd39a60ab04f13e9",
                    "sales": 205,
                    "stock": 11,
                    "weight": 0.76,
                    "width": 195.0,
                    "length": 190.0,
                    "height": 160.0,
                    "manufacturerId": "0189b5ced58e706890ac8b39799f9c9a",
                    "manufacturerNumber": "JI-111C",
                    "releaseDate": null,
                    "createdAt": "2019-05-09T00:00:00+00:00",
                    "categoryTree": [
                        "d7b7b163000841a1876dbff5548c039f",
                        "1e866cbbceb14718b0fc586a82f9bf19",
                        "35dc90db760345fdb823f8a798b7f5ad",
                        "ed73937c1fc54757a390ffc31536aa0d",
                        "c65d225496bb4f7b961e072a3e2d9e4f",
                        "f96d13220e5c41cbac18d02c6331e43e"
                    ],
                    "categoriesRo": [
                        {
                            "id": "d7b7b163000841a1876dbff5548c039f",
                            "_count": 1
                        },
                        {
                            "id": "1e866cbbceb14718b0fc586a82f9bf19",
                            "_count": 1
                        },
                        {
                            "id": "35dc90db760345fdb823f8a798b7f5ad",
                            "_count": 1
                        },
                        {
                            "id": "ed73937c1fc54757a390ffc31536aa0d",
                            "_count": 1
                        },
                        {
                            "id": "c65d225496bb4f7b961e072a3e2d9e4f",
                            "_count": 1
                        },
                        {
                            "id": "f96d13220e5c41cbac18d02c6331e43e",
                            "_count": 1
                        }
                    ],
                    "taxId": "0189b5bc757f71079ecf17a5e531d81e",
                    "tags": [],
                    "parentId": null,
                    "coverId": "fa6c02fb4fcd4f578e63571b86981272",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "c65d225496bb4f7b961e072a3e2d9e4f",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Jablotron Video JI-100+"
                            }
                        },
                        {
                            "id": "f96d13220e5c41cbac18d02c6331e43e",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "8060 - Jablotron"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "0189b5ced58e706890ac8b39799f9c9a",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Jablotron"
                        },
                        "_count": 1
                    },
                    "properties": [
                        {
                            "id": "0189b5cf5f5f7330bcf35b775cc1b543",
                            "_count": 1,
                            "groupId": "0189b5cf5f4373aea156ba4f6334d89f",
                            "group": {
                                "id": "0189b5cf5f4373aea156ba4f6334d89f",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "-20 bis +60\u00b0C"
                            }
                        },
                        {
                            "id": "0189b5cf5f8f73498431f1ee5ff7a452",
                            "_count": 1,
                            "groupId": "0189b5cf5f8f73498431f1ee66947f0f",
                            "group": {
                                "id": "0189b5cf5f8f73498431f1ee66947f0f",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2MP"
                            }
                        },
                        {
                            "id": "0189b5cf5f9171179ab24aac63bac490",
                            "_count": 1,
                            "groupId": "0189b5cf5f8f73498431f1ee66947f0f",
                            "group": {
                                "id": "0189b5cf5f8f73498431f1ee66947f0f",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "1920x1080 Pixel"
                            }
                        },
                        {
                            "id": "0189b5cf622b72b29d72ad2c3ea44522",
                            "_count": 1,
                            "groupId": "0189b5cf62297196ba7ea4958d9a4abe",
                            "group": {
                                "id": "0189b5cf62297196ba7ea4958d9a4abe",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "30m"
                            }
                        },
                        {
                            "id": "0189b5cf625f7102b41b104a1ead8781",
                            "_count": 1,
                            "groupId": "0189b5cf6260739bbbf4551dd3cfeb3e",
                            "group": {
                                "id": "0189b5cf6260739bbbf4551dd3cfeb3e",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "100"
                            }
                        },
                        {
                            "id": "9ca9a210df8444938c7e80fa08dde355",
                            "_count": 1,
                            "groupId": "0189b5cf0a0f71f08bc4f2efb072a8d5",
                            "group": {
                                "id": "0189b5cf0a0f71f08bc4f2efb072a8d5",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "wei\u00df"
                            }
                        }
                    ],
                    "options": [],
                    "categoryIds": [
                        "c65d225496bb4f7b961e072a3e2d9e4f",
                        "f96d13220e5c41cbac18d02c6331e43e"
                    ],
                    "optionIds": [],
                    "propertyIds": [
                        "0189b5cf5f5f7330bcf35b775cc1b543",
                        "0189b5cf5f8f73498431f1ee5ff7a452",
                        "0189b5cf5f9171179ab24aac63bac490",
                        "0189b5cf622b72b29d72ad2c3ea44522",
                        "0189b5cf625f7102b41b104a1ead8781",
                        "9ca9a210df8444938c7e80fa08dde355"
                    ],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
                            "ran_artikel": "Ja",
                            "warenzolltarifnummer": 85258900.0,
                            "ger\u00e4teart___alt_l\u00f6schen": "Jablotron",
                            "ear_hersteller": "Jablotron",
                            "verpackung_meldung": "ja",
                            "hersteller___alt_l\u00f6schen": "Jablotron",
                            "gewicht_(verpackung)": 0.11,
                            "altg_meldung_ear": "Ja",
                            "aktiv_o_alt___alt_ps": "aktiv",
                            "liefersperre": 0.0,
                            "verpackung_meldung_=_ja": "ja",
                            "verpackung_gewicht": 0.11,
                            "ear_altg_meldung_=_ja": "Ja",
                            "attr1": "D8FD96B7-7319-423C-BF23-BBFD7DB17791",
                            "attr3": "[]",
                            "attr5": "[{\"id\":\"167\",\"pleasant_id\":\"D8FD96B7-7319-423C-BF23-BBFD7DB17791\",\"youtube_id\":\"gYAUQL1THN8\",\"label\":\"eps - Jablotron JA 100 Installation einer Video Verifikation\",\"description\":\"\",\"position\":null,\"date_create\":\"2019-05-09 18:05:07\"}]",
                            "attr6": 371.0,
                            "attr9": "{\"shipping\":null,\"quantity\":0,\"cuttedCount\":0,\"available\":11,\"deliveries\":[]}",
                            "attr17": "https:\/\/www.eps-system.de\/detail\/index\/sArticle\/1319",
                            "attr16": "https:\/\/www.eps-vertrieb.de\/detail\/index\/sArticle\/343",
                            "jtlorder": 0.0
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "JI-111C"
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Die Jablotron  Kuppelkamera JI-111C  ist f\u00fcr den Au\u00dfen- und Inneneinsatz geeignet. Die  IP basierte Videoverifikationskamera  wird an das lokale Netzwerk \/ Router angeschlossen und ist sehr einfach zu installieren und in die APP MyJablotron ein lernbar. Durch die kompakte und unauff\u00e4llige Bauform ist diese Kuppelkamera bestens geeignet zur diskreten und unauff\u00e4lligen Video\u00fcberwachung. Die Kamera verf\u00fcgt \u00fcber einen lokalen Ringspeicher, in dem die Videobilder lokal permanent f\u00fcr eine Minute gespeichert werden. Im Alarmfall werden die Bilddaten als Videosequenz an die APP MyJablotron oder zur NSL Leitstelle \u00fcbertragen. Die Stromversorgung erfolgt \u00fcber PoE (Power over Ethernet). Alternativ kann ein 12 V Netzteil verwendet werden. Die Jablotron IP Kameras sind nur mit MyJablotron verwendbar und k\u00f6nnen nicht f\u00fcr andere Videosystem verwendet werden.\nLeistungsmerkmale:\n\nIP Netzwerkkamera zur Integration in MyJablotron\nAufl\u00f6sung: 2 MP \/ 1920 x 1080\nObjektivbrennweite: 2,8 mm  ca. 115\u00b0 Blickwinkel\nintegrierter IR Strahler: Reichweite ca. 30 m\nintegrierter Ringspeicher 1 Min.\nBildrate: 8 Bilder \/ Sek.\nGegenlichtkompensation WDR\nInklusive AP Anschlussdose\nformsch\u00f6nes Design f\u00fcr diskrete Anwendungen\n\nTechnische Daten:\n\nDie Jablotron IP Kameras belegen  keine  Position im JA 100 System\nStromversorgung 12 V DC\/ 350 mA\nStromversorgung \u00fcber POE, alternativ 12 V Netzteil (bitte separat bestellen)\nAbmessungen: Durchmesser 111 mm, H\u00f6he 82 mm\nSchutzklasse IP 67\nBetriebstemperatur: -25 bis 60 \u00b0C\nZulassung EN 50130-4, EN 55032\n"
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "JI-111C Kuppelkamera | Jablotron Videotechnik | EPS"
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Entdecken Sie die innovative IP basierte Kuppelkamera JI-111C f\u00fcr den Innen- und Au\u00dfenbereich in einer kompakten und unauff\u00e4lligen Bauform."
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": []
                    },
                    "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 198.73,
                    "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 167.0,
                    "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 198.73,
                    "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 167.0,
                    "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 198.73,
                    "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 167.0,
                    "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 198.73,
                    "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 167.0,
                    "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 441.49,
                    "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 371.0,
                    "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 441.49,
                    "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 371.0,
                    "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 198.73,
                    "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 167.0,
                    "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 198.73,
                    "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 167.0,
                    "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 198.73,
                    "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 167.0,
                    "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 104.1333,
                    "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 87.507,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 441.49,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 371.0,
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "ji-111c",
                        "8595614119719",
                        "kuppelkamera",
                        "jablotron",
                        "videotechnik",
                        "eps",
                        "ji-111c kuppelkamera | jablotron videotechnik | eps"
                    ],
                    "jtlOrder": 0,
                    "custom_numbers": []
                },
                "fields": {
                    "displayGroup": [
                        "10e2951ec5f003d0bd39a60ab04f13e9"
                    ]
                },
                "sort": [
                    11,
                    "ji-111c",
                    "0189b5cf3c7e70d98a398f2cfcc561b4"
                ]
            },
            {
                "_index": "sw6_fr_product_1719221316",
                "_id": "0189b5cf3c86730b92ceb685f1b7cd97",
                "_score": null,
                "_source": {
                    "purchasePrices": [
                        {
                            "currencyId": "b7d2554b0ce847cd82f3ac9bd1c0dfca",
                            "net": 89.1681,
                            "gross": 106.11,
                            "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": "0189b5cf3c86730b92ceb685f1b7cd97",
                    "autoIncrement": 2886.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "0189b5bd293f71c6a5e92e9980f13639"
                        }
                    ],
                    "availableStock": 10,
                    "productNumber": "ji-112c",
                    "ean": "8595614119726",
                    "displayGroup": "c79bc50402c2ddebf3fa8d914c129699",
                    "sales": 126,
                    "stock": 10,
                    "weight": 1.56,
                    "width": 160.0,
                    "length": 390.0,
                    "height": 160.0,
                    "manufacturerId": "0189b5ced58e706890ac8b39799f9c9a",
                    "manufacturerNumber": "JI-112C",
                    "releaseDate": null,
                    "createdAt": "2019-05-09T00:00:00+00:00",
                    "categoryTree": [
                        "d7b7b163000841a1876dbff5548c039f",
                        "1e866cbbceb14718b0fc586a82f9bf19",
                        "35dc90db760345fdb823f8a798b7f5ad",
                        "ed73937c1fc54757a390ffc31536aa0d",
                        "c65d225496bb4f7b961e072a3e2d9e4f",
                        "f96d13220e5c41cbac18d02c6331e43e"
                    ],
                    "categoriesRo": [
                        {
                            "id": "d7b7b163000841a1876dbff5548c039f",
                            "_count": 1
                        },
                        {
                            "id": "1e866cbbceb14718b0fc586a82f9bf19",
                            "_count": 1
                        },
                        {
                            "id": "35dc90db760345fdb823f8a798b7f5ad",
                            "_count": 1
                        },
                        {
                            "id": "ed73937c1fc54757a390ffc31536aa0d",
                            "_count": 1
                        },
                        {
                            "id": "c65d225496bb4f7b961e072a3e2d9e4f",
                            "_count": 1
                        },
                        {
                            "id": "f96d13220e5c41cbac18d02c6331e43e",
                            "_count": 1
                        }
                    ],
                    "taxId": "0189b5bc757f71079ecf17a5e531d81e",
                    "tags": [],
                    "parentId": null,
                    "coverId": "ab4acf4687644fcf9c61c7fc162f95f7",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "c65d225496bb4f7b961e072a3e2d9e4f",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Jablotron Video JI-100+"
                            }
                        },
                        {
                            "id": "f96d13220e5c41cbac18d02c6331e43e",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "8060 - Jablotron"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "0189b5ced58e706890ac8b39799f9c9a",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Jablotron"
                        },
                        "_count": 1
                    },
                    "properties": [
                        {
                            "id": "0189b5cf5f5f7330bcf35b775cc1b543",
                            "_count": 1,
                            "groupId": "0189b5cf5f4373aea156ba4f6334d89f",
                            "group": {
                                "id": "0189b5cf5f4373aea156ba4f6334d89f",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "-20 bis +60\u00b0C"
                            }
                        },
                        {
                            "id": "0189b5cf5f8f73498431f1ee5ff7a452",
                            "_count": 1,
                            "groupId": "0189b5cf5f8f73498431f1ee66947f0f",
                            "group": {
                                "id": "0189b5cf5f8f73498431f1ee66947f0f",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2MP"
                            }
                        },
                        {
                            "id": "0189b5cf5f9171179ab24aac63bac490",
                            "_count": 1,
                            "groupId": "0189b5cf5f8f73498431f1ee66947f0f",
                            "group": {
                                "id": "0189b5cf5f8f73498431f1ee66947f0f",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "1920x1080 Pixel"
                            }
                        },
                        {
                            "id": "0189b5cf622d70bebb8f8084e965dd87",
                            "_count": 1,
                            "groupId": "0189b5cf62297196ba7ea4958d9a4abe",
                            "group": {
                                "id": "0189b5cf62297196ba7ea4958d9a4abe",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "50m"
                            }
                        },
                        {
                            "id": "0189b5cf625f7102b41b104a1ead8781",
                            "_count": 1,
                            "groupId": "0189b5cf6260739bbbf4551dd3cfeb3e",
                            "group": {
                                "id": "0189b5cf6260739bbbf4551dd3cfeb3e",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "100"
                            }
                        },
                        {
                            "id": "0189b5cf6a03716bb77a6737db744c14",
                            "_count": 1,
                            "groupId": "0189b5cf69fd7078bc3dfe56e0a6fa5d",
                            "group": {
                                "id": "0189b5cf69fd7078bc3dfe56e0a6fa5d",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "200mA"
                            }
                        },
                        {
                            "id": "9ca9a210df8444938c7e80fa08dde355",
                            "_count": 1,
                            "groupId": "0189b5cf0a0f71f08bc4f2efb072a8d5",
                            "group": {
                                "id": "0189b5cf0a0f71f08bc4f2efb072a8d5",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "wei\u00df"
                            }
                        }
                    ],
                    "options": [],
                    "categoryIds": [
                        "c65d225496bb4f7b961e072a3e2d9e4f",
                        "f96d13220e5c41cbac18d02c6331e43e"
                    ],
                    "optionIds": [],
                    "propertyIds": [
                        "0189b5cf5f5f7330bcf35b775cc1b543",
                        "0189b5cf5f8f73498431f1ee5ff7a452",
                        "0189b5cf5f9171179ab24aac63bac490",
                        "0189b5cf622d70bebb8f8084e965dd87",
                        "0189b5cf625f7102b41b104a1ead8781",
                        "0189b5cf6a03716bb77a6737db744c14",
                        "9ca9a210df8444938c7e80fa08dde355"
                    ],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
                            "ear_hersteller": "Jablotron",
                            "aktiv_o_alt___alt_ps": "aktiv",
                            "warenzolltarifnummer": 85258900.0,
                            "ger\u00e4teart___alt_l\u00f6schen": "Jablotron",
                            "gewicht_(verpackung)": 0.11,
                            "verpackung_meldung": "ja",
                            "altg_meldung_ear": "Ja",
                            "ran_artikel": "Ja",
                            "hersteller___alt_l\u00f6schen": "Jablotron",
                            "verpackung_gewicht": 0.11,
                            "verpackung_meldung_=_ja": "ja",
                            "ear_altg_meldung_=_ja": "Ja",
                            "attr1": "C0007A8E-CBC2-49FC-A43E-FA9E75C1A8DD",
                            "attr3": "[]",
                            "attr5": "[{\"id\":\"168\",\"pleasant_id\":\"C0007A8E-CBC2-49FC-A43E-FA9E75C1A8DD\",\"youtube_id\":\"gYAUQL1THN8\",\"label\":\"eps - Jablotron JA 100 Installation einer Video Verifikation\",\"description\":\"https:\\\/\\\/www.youtube.com\\\/watch?v=gYAUQL1THN8\",\"position\":null,\"date_create\":\"2019-05-09 18:50:09\"}]",
                            "attr6": 393.0,
                            "attr9": "{\"shipping\":null,\"quantity\":0,\"cuttedCount\":0,\"available\":10,\"deliveries\":[]}",
                            "attr17": "https:\/\/www.eps-system.de\/detail\/index\/sArticle\/1229",
                            "attr16": "https:\/\/www.eps-vertrieb.de\/detail\/index\/sArticle\/344",
                            "liefersperre": 0.0,
                            "jtlorder": 0.0
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "JI-112C"
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Die Jablotron  Bulletkamera JI-112C  ist haupts\u00e4chlich f\u00fcr den Au\u00dfeneinsatz konzipiert. Die  IP basierte Videoverifikationskamera  wird an das lokale Netzwerk \/ Router angeschlossen und ist sehr einfach zu installieren und in die APP MyJablotron ein lernbar. Dieses formsch\u00f6ne Geh\u00e4use und die kompakte Bauform passen sich jeder Fassade und Geb\u00e4udeart gut an. Die Kamera verf\u00fcgt \u00fcber einen lokalen Ringspeicher, in dem die Videobilder lokal permanent f\u00fcr eine Minute gespeichert werden. Im Alarmfall werden die Bilddaten als Videosequenz an die APP MyJablotron oder zur Notruf-Service-Leitstelle  (NSL) \u00fcbertragen. Die Stromversorgung erfolgt \u00fcber PoE (Power over Ethernet). Alternativ kann ein 12 V Netzteil verwendet werden. Die Jablotron IP Kameras sind nur mit MyJablotron verwendbar und k\u00f6nnen nicht f\u00fcr andere Videosystem verwendet werden.\nLeistungsmerkmale:\n\nIP Netzwerkkamera zur Integration in MyJablotron\nAufl\u00f6sung: 2 MP \/ 1920 x 1080\nObjektivbrennweite: 4 mm  ca. 90\u00b0 Blickwinkel\nintegrierter IR Strahler: Reichweite ca. 50 m\nintegrierter Ringspeicher 1 Min.\nBildrate: 8 Bilder \/ Sek.\nGegenlichtkompensation WDR\nInklusive AP Anschlussdose\nformsch\u00f6nes Design f\u00fcr diskrete Anwendungen\n\nTechnische Daten:\n\nDie Jablotron IP Kameras belegen  keine  Position im JA 100 System\nStromversorgung 12 V DC\/ 350 mA\nStromversorgung \u00fcber POE, alternativ 12 V Netzteil (bitte separat bestellen)\nAbmessungen: Durchmesser 300 x 90 x 90 mm\nSchutzklasse IP 67\nBetriebstemperatur: -25 bis 60 \u00b0C\nZulassung EN 50130-4, EN 55032\n"
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "JI-112C Au\u00dfenkamera | Jablotron Videotechnik | EPS"
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Die Kamera JI 112C ist f\u00fcr den Au\u00dfeneinsatz konzipiert. Die IP basierte Videoverifikationskamera wird an das lokale Netzwerk \/ Router angeschlossen."
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": []
                    },
                    "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 210.63,
                    "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 177.0,
                    "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 210.63,
                    "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 177.0,
                    "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 210.63,
                    "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 177.0,
                    "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 467.67,
                    "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 393.0,
                    "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 210.63,
                    "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 177.0,
                    "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 210.63,
                    "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 177.0,
                    "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 210.63,
                    "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 177.0,
                    "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 467.67,
                    "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 393.0,
                    "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 210.63,
                    "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 177.0,
                    "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 110.8057,
                    "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 93.114,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 467.67,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 393.0,
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "ji-112c",
                        "8595614119726",
                        "au\u00dfenkamera",
                        "jablotron",
                        "videotechnik",
                        "eps",
                        "ji-112c au\u00dfenkamera | jablotron videotechnik | eps"
                    ],
                    "jtlOrder": 0,
                    "custom_numbers": []
                },
                "fields": {
                    "displayGroup": [
                        "c79bc50402c2ddebf3fa8d914c129699"
                    ]
                },
                "sort": [
                    10,
                    "ji-112c",
                    "0189b5cf3c86730b92ceb685f1b7cd97"
                ]
            },
            {
                "_index": "sw6_fr_product_1719221316",
                "_id": "0189b5cf20c2708d8e70b7f6dbfde4d6",
                "_score": null,
                "_source": {
                    "purchasePrices": [
                        {
                            "currencyId": "b7d2554b0ce847cd82f3ac9bd1c0dfca",
                            "net": 49.099,
                            "gross": 58.4278,
                            "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": "0189b5cf20c2708d8e70b7f6dbfde4d6",
                    "autoIncrement": 2338.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "0189b5bd293f71c6a5e92e9980f13639"
                        }
                    ],
                    "availableStock": 9,
                    "productNumber": "ja-vibo-5010",
                    "ean": null,
                    "displayGroup": "74f12fcd21b1aed0cbb78fc4a0afd505",
                    "sales": 43,
                    "stock": 9,
                    "weight": 0.135,
                    "width": 100.0,
                    "length": 100.0,
                    "height": 40.0,
                    "manufacturerId": "0189b5ced58e706890ac8b39799f9c9a",
                    "manufacturerNumber": "JA-ViBo 5010",
                    "releaseDate": null,
                    "createdAt": "2019-06-19T00:00:00+00:00",
                    "categoryTree": [
                        "d7b7b163000841a1876dbff5548c039f",
                        "1e866cbbceb14718b0fc586a82f9bf19",
                        "0c075974861844fcac5e84b79a8457bb",
                        "35dc90db760345fdb823f8a798b7f5ad",
                        "ed73937c1fc54757a390ffc31536aa0d",
                        "96155915065d498e9fe4170600df2004",
                        "c65d225496bb4f7b961e072a3e2d9e4f",
                        "f96d13220e5c41cbac18d02c6331e43e"
                    ],
                    "categoriesRo": [
                        {
                            "id": "d7b7b163000841a1876dbff5548c039f",
                            "_count": 1
                        },
                        {
                            "id": "1e866cbbceb14718b0fc586a82f9bf19",
                            "_count": 1
                        },
                        {
                            "id": "0c075974861844fcac5e84b79a8457bb",
                            "_count": 1
                        },
                        {
                            "id": "35dc90db760345fdb823f8a798b7f5ad",
                            "_count": 1
                        },
                        {
                            "id": "ed73937c1fc54757a390ffc31536aa0d",
                            "_count": 1
                        },
                        {
                            "id": "96155915065d498e9fe4170600df2004",
                            "_count": 1
                        },
                        {
                            "id": "c65d225496bb4f7b961e072a3e2d9e4f",
                            "_count": 1
                        },
                        {
                            "id": "f96d13220e5c41cbac18d02c6331e43e",
                            "_count": 1
                        }
                    ],
                    "taxId": "0189b5bc757f71079ecf17a5e531d81e",
                    "tags": [],
                    "parentId": null,
                    "coverId": "4ee5e5624e57423b88c385ffc7935840",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "96155915065d498e9fe4170600df2004",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Bus Ausgangsmodule und Eingangsmodule"
                            }
                        },
                        {
                            "id": "c65d225496bb4f7b961e072a3e2d9e4f",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Jablotron Video JI-100+"
                            }
                        },
                        {
                            "id": "f96d13220e5c41cbac18d02c6331e43e",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "8060 - Jablotron"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "0189b5ced58e706890ac8b39799f9c9a",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Jablotron"
                        },
                        "_count": 1
                    },
                    "properties": [
                        {
                            "id": "0189b5cf587b72079e6fb353c31955d8",
                            "_count": 1,
                            "groupId": "0189b5cf587970509c11f4ec00c8b0d7",
                            "group": {
                                "id": "0189b5cf587970509c11f4ec00c8b0d7",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "4"
                            }
                        },
                        {
                            "id": "0189b5cf5f85734694cf4101034837c4",
                            "_count": 1,
                            "groupId": "0189b5cf5f4373aea156ba4f6334d89f",
                            "group": {
                                "id": "0189b5cf5f4373aea156ba4f6334d89f",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "10 \u00b0C bis +40 \u00b0C"
                            }
                        },
                        {
                            "id": "0189b5cf615e70839d374fd5b1d8496f",
                            "_count": 1,
                            "groupId": "0189b5cf615d7034a4a5e9bf51836360",
                            "group": {
                                "id": "0189b5cf615d7034a4a5e9bf51836360",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Bus"
                            }
                        },
                        {
                            "id": "0189b5cf625f7102b41b104a1ead8781",
                            "_count": 1,
                            "groupId": "0189b5cf6260739bbbf4551dd3cfeb3e",
                            "group": {
                                "id": "0189b5cf6260739bbbf4551dd3cfeb3e",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "100"
                            }
                        },
                        {
                            "id": "0189b5cf6a05736aaae2b9c190cacb8c",
                            "_count": 1,
                            "groupId": "0189b5cf69fd7078bc3dfe56e0a6fa5d",
                            "group": {
                                "id": "0189b5cf69fd7078bc3dfe56e0a6fa5d",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "25 mA"
                            }
                        },
                        {
                            "id": "0189b5cf6a2a7086a1d4a706a60c98c9",
                            "_count": 1,
                            "groupId": "0189b5cf6a1c7017801fd47cbf51d753",
                            "group": {
                                "id": "0189b5cf6a1c7017801fd47cbf51d753",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "200 mA"
                            }
                        },
                        {
                            "id": "9ca9a210df8444938c7e80fa08dde355",
                            "_count": 1,
                            "groupId": "0189b5cf0a0f71f08bc4f2efb072a8d5",
                            "group": {
                                "id": "0189b5cf0a0f71f08bc4f2efb072a8d5",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "wei\u00df"
                            }
                        }
                    ],
                    "options": [],
                    "categoryIds": [
                        "96155915065d498e9fe4170600df2004",
                        "c65d225496bb4f7b961e072a3e2d9e4f",
                        "f96d13220e5c41cbac18d02c6331e43e"
                    ],
                    "optionIds": [],
                    "propertyIds": [
                        "0189b5cf587b72079e6fb353c31955d8",
                        "0189b5cf5f85734694cf4101034837c4",
                        "0189b5cf615e70839d374fd5b1d8496f",
                        "0189b5cf625f7102b41b104a1ead8781",
                        "0189b5cf6a05736aaae2b9c190cacb8c",
                        "0189b5cf6a2a7086a1d4a706a60c98c9",
                        "9ca9a210df8444938c7e80fa08dde355"
                    ],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
                            "warenzolltarifnummer": 85319000.0,
                            "hersteller___alt_l\u00f6schen": "Jablotron",
                            "ger\u00e4teart___alt_l\u00f6schen": "Jablotron",
                            "ran_artikel": "Nein",
                            "gewicht_(verpackung)": 0.021,
                            "aktiv_o_alt___alt_ps": "aktiv",
                            "liefersperre": 0.0,
                            "verpackung_gewicht": 0.021,
                            "attr1": "4A0E528B-B56F-47B8-96BE-7AE05B9E3CA4",
                            "attr3": "[]",
                            "attr5": "[]",
                            "attr6": 225.0,
                            "attr9": "{\"shipping\":null,\"quantity\":0,\"cuttedCount\":0,\"available\":9,\"deliveries\":[]}",
                            "attr17": "https:\/\/www.eps-system.de\/detail\/index\/sArticle\/1306",
                            "attr16": "https:\/\/www.eps-vertrieb.de\/detail\/index\/sArticle\/2011",
                            "jtlorder": 0.0
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "JA-ViBo 5010"
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Die Video - Anschlussbox ViBO 5010 dient als Schnittstelle zwischen dem JA 100 Alarmsystem und Video\u00fcberwachungsanlagen. \u00dcber das Jablotron Bus - Modul JA-114H k\u00f6nnen unterschiedlichen Ein - und Ausg\u00e4nge aus dem Alarmsystem an die Video\u00fcberwachungsanlage \u00fcbergeben werden.\nEs k\u00f6nnen auch Meldungen und Ereignisse von dem Video\u00fcberwachungssystem NVR an die Alarmanlage \u00fcbergeben werden. Die Videobox ist anschlussfertig vormontiert inkl. Geh\u00e4use.\nLeistungsmerkmale:\n\n4 Eing\u00e4nge und 4 Ausg\u00e4ngen\nbelegt vier Positionen im JA 100 Alarmsystem\nStromversorgung: 12 V  \u00fcber den Bus der Zentrale\nInkl. Geh\u00e4use JA-190PL\n"
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "JA-ViBo 5010 Video - Anschlussbox | Jablotron Zubeh\u00f6r | EPS"
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Die Video - Anschlussbox ViBO 5010 dient als Schnittstelle zwischen dem JA 100 Alarmsystem und Video\u00fcberwachungsanlagen."
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": []
                    },
                    "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 134.47,
                    "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 113.0,
                    "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 134.47,
                    "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 113.0,
                    "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 283.22,
                    "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 238.0,
                    "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 134.47,
                    "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 113.0,
                    "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 283.22,
                    "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 238.0,
                    "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 134.47,
                    "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 113.0,
                    "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 134.47,
                    "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 113.0,
                    "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 134.47,
                    "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 113.0,
                    "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 134.47,
                    "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 113.0,
                    "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 78.2663,
                    "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 65.77,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 283.22,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 238.0,
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "ja-vibo-5010",
                        "ja-vibo",
                        "5010",
                        "video",
                        "anschlussbox",
                        "jablotron",
                        "zubeh\u00f6r",
                        "eps",
                        "ja-vibo 5010",
                        "ja-vibo 5010 video - anschlussbox | jablotron zubeh\u00f6r | eps"
                    ],
                    "jtlOrder": 0,
                    "custom_numbers": []
                },
                "fields": {
                    "displayGroup": [
                        "74f12fcd21b1aed0cbb78fc4a0afd505"
                    ]
                },
                "sort": [
                    9,
                    "ja-vibo-5010",
                    "0189b5cf20c2708d8e70b7f6dbfde4d6"
                ]
            },
            {
                "_index": "sw6_fr_product_1719221316",
                "_id": "0189b5cf203772d683ef1cccd483b303",
                "_score": null,
                "_source": {
                    "purchasePrices": [
                        {
                            "currencyId": "b7d2554b0ce847cd82f3ac9bd1c0dfca",
                            "net": 24.3439,
                            "gross": 28.9692,
                            "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": "0189b5cf203772d683ef1cccd483b303",
                    "autoIncrement": 2315.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "0189b5bd293f71c6a5e92e9980f13639"
                        }
                    ],
                    "availableStock": 2,
                    "productNumber": "ji-114z",
                    "ean": "8595614123921",
                    "displayGroup": "60665b67fd735262ac6965e16b3653e0",
                    "sales": 59,
                    "stock": 2,
                    "weight": 0.635,
                    "width": 110.0,
                    "length": 200.0,
                    "height": 90.0,
                    "manufacturerId": "0189b5ced58e706890ac8b39799f9c9a",
                    "manufacturerNumber": "JI-114Z",
                    "releaseDate": null,
                    "createdAt": "2019-05-24T00:00:00+00:00",
                    "categoryTree": [
                        "d7b7b163000841a1876dbff5548c039f",
                        "1e866cbbceb14718b0fc586a82f9bf19",
                        "35dc90db760345fdb823f8a798b7f5ad",
                        "ed73937c1fc54757a390ffc31536aa0d",
                        "c65d225496bb4f7b961e072a3e2d9e4f",
                        "f96d13220e5c41cbac18d02c6331e43e"
                    ],
                    "categoriesRo": [
                        {
                            "id": "d7b7b163000841a1876dbff5548c039f",
                            "_count": 1
                        },
                        {
                            "id": "1e866cbbceb14718b0fc586a82f9bf19",
                            "_count": 1
                        },
                        {
                            "id": "35dc90db760345fdb823f8a798b7f5ad",
                            "_count": 1
                        },
                        {
                            "id": "ed73937c1fc54757a390ffc31536aa0d",
                            "_count": 1
                        },
                        {
                            "id": "c65d225496bb4f7b961e072a3e2d9e4f",
                            "_count": 1
                        },
                        {
                            "id": "f96d13220e5c41cbac18d02c6331e43e",
                            "_count": 1
                        }
                    ],
                    "taxId": "0189b5bc757f71079ecf17a5e531d81e",
                    "tags": [],
                    "parentId": null,
                    "coverId": "f42e7154cf7e4299b029a20dbdd9df99",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "c65d225496bb4f7b961e072a3e2d9e4f",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Jablotron Video JI-100+"
                            }
                        },
                        {
                            "id": "f96d13220e5c41cbac18d02c6331e43e",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "8060 - Jablotron"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "0189b5ced58e706890ac8b39799f9c9a",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Jablotron"
                        },
                        "_count": 1
                    },
                    "properties": [
                        {
                            "id": "0189b5cf625f7102b41b104a1ead8781",
                            "_count": 1,
                            "groupId": "0189b5cf6260739bbbf4551dd3cfeb3e",
                            "group": {
                                "id": "0189b5cf6260739bbbf4551dd3cfeb3e",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "100"
                            }
                        },
                        {
                            "id": "0189b5cf6261731aa3b57e889fb380be",
                            "_count": 1,
                            "groupId": "0189b5cf6260739bbbf4551dd3cfeb3e",
                            "group": {
                                "id": "0189b5cf6260739bbbf4551dd3cfeb3e",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "100+"
                            }
                        }
                    ],
                    "options": [],
                    "categoryIds": [
                        "c65d225496bb4f7b961e072a3e2d9e4f",
                        "f96d13220e5c41cbac18d02c6331e43e"
                    ],
                    "optionIds": [],
                    "propertyIds": [
                        "0189b5cf625f7102b41b104a1ead8781",
                        "0189b5cf6261731aa3b57e889fb380be"
                    ],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
                            "aktiv_o_alt___alt_ps": "aktiv",
                            "ear_hersteller": "Jablotron",
                            "ger\u00e4teart___alt_l\u00f6schen": "Jablotron",
                            "altg_meldung_ear": "Ja",
                            "ran_artikel": "Ja",
                            "gewicht_(verpackung)": 0.29,
                            "warenzolltarifnummer": 85176200.0,
                            "verpackung_meldung": "ja",
                            "hersteller___alt_l\u00f6schen": "Jablotron",
                            "liefersperre": 0.0,
                            "ear_altg_meldung_=_ja": "Ja",
                            "verpackung_gewicht": 0.29,
                            "verpackung_meldung_=_ja": "ja",
                            "attr1": "2022117F-C664-4DC9-A21F-AF2EF92F35CE",
                            "attr3": "[]",
                            "attr5": "[]",
                            "attr6": 140.0,
                            "attr7": "[]",
                            "attr9": "{\"shipping\":null,\"quantity\":0,\"cuttedCount\":0,\"available\":2,\"deliveries\":[]}",
                            "attr17": "https:\/\/www.eps-system.de\/detail\/index\/sArticle\/1382",
                            "attr16": "https:\/\/www.eps-vertrieb.de\/detail\/index\/sArticle\/1511",
                            "jtlorder": 0.0
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "JI-114Z"
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "PoE Switch - 4 Ports der Switch passend f\u00fcr die Jablotron Kameras: JI-111C und JI-112C  Teil des JABLOTRON 100+ Systems\nLeistungsmerkmale:\n\nzur Einbindung der IP Netzwerkkameras von JABLOTRON\nNetzteil\n\nTechnische Daten:\n\nDie Jablotron IP Kameras belegen  keine  Position im JA 100 System\nStromversorgung mit POE f\u00fcr die Kameras, alternativ 12 V Netzteil (bitte separat bestellen)\n"
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "JI-114Z PoE Switch 4 Port | Jablotron Zubeh\u00f6r | EPS"
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Entdecken Sie den 4 Port PoE Switch JI-114Z speziell f\u00fcr die Jablotron Kameras JI-111C und JI-112C des JA-100 Systems"
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": []
                    },
                    "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 78.54,
                    "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 66.0,
                    "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 78.54,
                    "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 66.0,
                    "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 78.54,
                    "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 66.0,
                    "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 174.93,
                    "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 147.0,
                    "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 78.54,
                    "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 66.0,
                    "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 41.0711,
                    "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 34.5135,
                    "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 78.54,
                    "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 66.0,
                    "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 78.54,
                    "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 66.0,
                    "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 78.54,
                    "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 66.0,
                    "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 174.93,
                    "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 147.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 174.93,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 147.0,
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "ji-114z",
                        "8595614123921",
                        "poe",
                        "switch",
                        "port",
                        "jablotron",
                        "zubeh\u00f6r",
                        "eps",
                        "ji-114z poe switch 4 port | jablotron zubeh\u00f6r | eps"
                    ],
                    "jtlOrder": 0,
                    "custom_numbers": []
                },
                "fields": {
                    "displayGroup": [
                        "60665b67fd735262ac6965e16b3653e0"
                    ]
                },
                "sort": [
                    2,
                    "ji-114z",
                    "0189b5cf203772d683ef1cccd483b303"
                ]
            }
        ]
    },
    "aggregations": {
        "total-filtered-count": {
            "doc_count": 4,
            "total-count": {
                "value": 4
            }
        }
    }
}

Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search

5.72 ms

Request:

{"index":"sw6_fr_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":"c65d225496bb4f7b961e072a3e2d9e4f"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"aggregations":{"manufacturer":{"terms":{"field":"manufacturerId","size":10000}},"price":{"stats":{"script":{"id":"cheapest_price","params":{"accessors":[{"key":"cheapest_price_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}}}},"brands":{"terms":{"field":"manufacturerId","size":10000}}},"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.2:9200/sw6_fr_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": "c65d225496bb4f7b961e072a3e2d9e4f"
                                        }
                                    }
                                }
                            },
                            {
                                "bool": {
                                    "must_not": [
                                        {
                                            "bool": {
                                                "must_not": [
                                                    {
                                                        "exists": {
                                                            "field": "displayGroup"
                                                        }
                                                    }
                                                ]
                                            }
                                        }
                                    ]
                                }
                            }
                        ]
                    }
                }
            ]
        }
    },
    "aggregations": {
        "manufacturer": {
            "terms": {
                "field": "manufacturerId",
                "size": 10000
            }
        },
        "price": {
            "stats": {
                "script": {
                    "id": "cheapest_price",
                    "params": {
                        "accessors": [
                            {
                                "key": "cheapest_price_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
                    }
                }
            }
        },
        "brands": {
            "terms": {
                "field": "manufacturerId",
                "size": 10000
            }
        }
    },
    "size": 0,
    "timeout": "5s"
}


                                    {
    "took": 3,
    "timed_out": false,
    "_shards": {
        "total": 3,
        "successful": 3,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "max_score": null,
        "hits": []
    },
    "aggregations": {
        "shipping-free-filter": {
            "doc_count": 0,
            "shipping-free": {
                "value": null
            }
        },
        "brands": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
                {
                    "key": "0189b5ced58e706890ac8b39799f9c9a",
                    "doc_count": 4
                }
            ]
        },
        "rating-exists": {
            "doc_count": 4,
            "rating": {
                "value": 0.0
            }
        },
        "price": {
            "count": 4,
            "min": 147.0,
            "max": 393.0,
            "avg": 287.25,
            "sum": 1149.0
        },
        "options": {
            "doc_count": 0,
            "options": {
                "doc_count_error_upper_bound": 0,
                "sum_other_doc_count": 0,
                "buckets": []
            }
        },
        "properties": {
            "doc_count": 22,
            "properties": {
                "doc_count_error_upper_bound": 0,
                "sum_other_doc_count": 0,
                "buckets": [
                    {
                        "key": "0189b5cf625f7102b41b104a1ead8781",
                        "doc_count": 4
                    },
                    {
                        "key": "9ca9a210df8444938c7e80fa08dde355",
                        "doc_count": 3
                    },
                    {
                        "key": "0189b5cf5f5f7330bcf35b775cc1b543",
                        "doc_count": 2
                    },
                    {
                        "key": "0189b5cf5f8f73498431f1ee5ff7a452",
                        "doc_count": 2
                    },
                    {
                        "key": "0189b5cf5f9171179ab24aac63bac490",
                        "doc_count": 2
                    },
                    {
                        "key": "0189b5cf587b72079e6fb353c31955d8",
                        "doc_count": 1
                    },
                    {
                        "key": "0189b5cf5f85734694cf4101034837c4",
                        "doc_count": 1
                    },
                    {
                        "key": "0189b5cf615e70839d374fd5b1d8496f",
                        "doc_count": 1
                    },
                    {
                        "key": "0189b5cf622b72b29d72ad2c3ea44522",
                        "doc_count": 1
                    },
                    {
                        "key": "0189b5cf622d70bebb8f8084e965dd87",
                        "doc_count": 1
                    },
                    {
                        "key": "0189b5cf6261731aa3b57e889fb380be",
                        "doc_count": 1
                    },
                    {
                        "key": "0189b5cf6a03716bb77a6737db744c14",
                        "doc_count": 1
                    },
                    {
                        "key": "0189b5cf6a05736aaae2b9c190cacb8c",
                        "doc_count": 1
                    },
                    {
                        "key": "0189b5cf6a2a7086a1d4a706a60c98c9",
                        "doc_count": 1
                    }
                ]
            }
        },
        "manufacturer": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
                {
                    "key": "0189b5ced58e706890ac8b39799f9c9a",
                    "doc_count": 4
                }
            ]
        }
    }
}

Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate

Cluster Status

{
    "cluster_name": "elasticsearch",
    "status": "yellow",
    "timed_out": false,
    "number_of_nodes": 1,
    "number_of_data_nodes": 1,
    "active_primary_shards": 49,
    "active_shards": 49,
    "relocating_shards": 0,
    "initializing_shards": 0,
    "unassigned_shards": 54,
    "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.57281553398058
}

Indices

Name▲	Status	Replication (pri, rep)	Doc Count
sw6_fr_product_1719221316	open	3, 3	54905
sw6_fr_product_manufacturer_1719221316	open	3, 3	1
live_index_category_1731064222	open	3, 3	51
live_index_product_1731064222	open	3, 3	59014
sw6_fr_category_1719221316	open	3, 3	0
live_index_product_manufacturer_1731064222	open	3, 3	0

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Cluster Status

Indices