Symfony Profiler

Query Metrics

12.00 ms Query Time

1 Node(s)

139 Indices

Queries

#▲ Execution Time Info

9.04 ms

#▲	Execution Time	Info
1	9.04 ms	Request: {"index":"sw_dev_product","search_type":"query_then_fetch","track_total_hits":true,"body":{"post_filter":{"bool":{"filter":[{"bool":{"must":[{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["89ee44dcf85c46718ba0744360e5fcc1"]}}}}]}}]}},{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["3adaca5df47943339a045e91f212ee90","b2e857ff4b84401caef408741cc18d83","2e9dc36608504cd0bd340d135922df23","87c89b5844a0436db7e7bebadfa24d5f","1339fc04d1b14eedae5c6cb1269b34af","b78d026c06064f24b92e69b8e1feadb0","eb1bb24fb4a64c9295a69f327f7a5899","b69d2b1c914342ecb0a0ba8cc0980393","4e33f457de524946ab593df85fba15ed"]}}}}]}}]}},{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["a2e3ce1f6e7241a783db0a98b0003a84"]}}}}]}}]}}]}}]}},"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"0189b5bd293f71c6a5e92e9980f13639"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"961ff154957b4846af19597e5fe3aee5"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}},{"bool":{"must_not":[{"bool":{"must":[{"term":{"isCloseout":true}},{"term":{"available":false}}]}}]}}]}}]}},"sort":[{"stock":{"order":"DESC"}},{"productNumber":{"order":"ASC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-filtered-count":{"filter":{"bool":{"must":[{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["89ee44dcf85c46718ba0744360e5fcc1"]}}}}]}}]}},{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["3adaca5df47943339a045e91f212ee90","b2e857ff4b84401caef408741cc18d83","2e9dc36608504cd0bd340d135922df23","87c89b5844a0436db7e7bebadfa24d5f","1339fc04d1b14eedae5c6cb1269b34af","b78d026c06064f24b92e69b8e1feadb0","eb1bb24fb4a64c9295a69f327f7a5899","b69d2b1c914342ecb0a0ba8cc0980393","4e33f457de524946ab593df85fba15ed"]}}}}]}}]}},{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["a2e3ce1f6e7241a783db0a98b0003a84"]}}}}]}}]}}]}},"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}}}},"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"}} Item count: 5 View formatted request View formatted response View query backtrace POST http://10.20.0.3:9200/sw_dev_product/_search?search_type=query_then_fetch&track_total_hits=1 Accept: application/json Content-Type: application/json { "post_filter": { "bool": { "filter": [ { "bool": { "must": [ { "bool": { "should": [ { "bool": { "must_not": [ { "nested": { "path": "categories", "query": { "terms": { "categories.id": [ "89ee44dcf85c46718ba0744360e5fcc1" ] } } } } ] } } ] } }, { "bool": { "should": [ { "bool": { "must_not": [ { "nested": { "path": "categories", "query": { "terms": { "categories.id": [ "3adaca5df47943339a045e91f212ee90", "b2e857ff4b84401caef408741cc18d83", "2e9dc36608504cd0bd340d135922df23", "87c89b5844a0436db7e7bebadfa24d5f", "1339fc04d1b14eedae5c6cb1269b34af", "b78d026c06064f24b92e69b8e1feadb0", "eb1bb24fb4a64c9295a69f327f7a5899", "b69d2b1c914342ecb0a0ba8cc0980393", "4e33f457de524946ab593df85fba15ed" ] } } } } ] } } ] } }, { "bool": { "should": [ { "bool": { "must_not": [ { "nested": { "path": "categories", "query": { "terms": { "categories.id": [ "a2e3ce1f6e7241a783db0a98b0003a84" ] } } } } ] } } ] } } ] } } ] } }, "query": { "bool": { "filter": [ { "bool": { "must": [ { "bool": { "must": [ { "nested": { "path": "visibilities", "query": { "bool": { "must": [ { "range": { "visibilities.visibility": { "gte": 30 } } }, { "term": { "visibilities.salesChannelId": "0189b5bd293f71c6a5e92e9980f13639" } } ] } } } }, { "term": { "active": true } } ] } }, { "nested": { "path": "categoriesRo", "query": { "term": { "categoriesRo.id": "961ff154957b4846af19597e5fe3aee5" } } } }, { "bool": { "must_not": [ { "bool": { "must_not": [ { "exists": { "field": "displayGroup" } } ] } } ] } }, { "bool": { "must_not": [ { "bool": { "must": [ { "term": { "isCloseout": true } }, { "term": { "available": false } } ] } } ] } } ] } } ] } }, "sort": [ { "stock": { "order": "DESC" } }, { "productNumber": { "order": "ASC" } }, { "id": { "order": "ASC" } } ], "aggregations": { "total-filtered-count": { "filter": { "bool": { "must": [ { "bool": { "should": [ { "bool": { "must_not": [ { "nested": { "path": "categories", "query": { "terms": { "categories.id": [ "89ee44dcf85c46718ba0744360e5fcc1" ] } } } } ] } } ] } }, { "bool": { "should": [ { "bool": { "must_not": [ { "nested": { "path": "categories", "query": { "terms": { "categories.id": [ "3adaca5df47943339a045e91f212ee90", "b2e857ff4b84401caef408741cc18d83", "2e9dc36608504cd0bd340d135922df23", "87c89b5844a0436db7e7bebadfa24d5f", "1339fc04d1b14eedae5c6cb1269b34af", "b78d026c06064f24b92e69b8e1feadb0", "eb1bb24fb4a64c9295a69f327f7a5899", "b69d2b1c914342ecb0a0ba8cc0980393", "4e33f457de524946ab593df85fba15ed" ] } } } } ] } } ] } }, { "bool": { "should": [ { "bool": { "must_not": [ { "nested": { "path": "categories", "query": { "terms": { "categories.id": [ "a2e3ce1f6e7241a783db0a98b0003a84" ] } } } } ] } } ] } } ] } }, "aggregations": { "total-count": { "cardinality": { "field": "displayGroup" } } } } }, "from": 0, "size": 24, "collapse": { "field": "displayGroup" }, "timeout": "5s" } { "took": 2, "timed_out": false, "_shards": { "total": 3, "successful": 3, "skipped": 0, "failed": 0 }, "hits": { "total": { "value": 5, "relation": "eq" }, "max_score": null, "hits": [ { "_index": "sw_dev_product_1744118278", "_id": "e5e295df4a4d497e851482d087371c7c", "_score": null, "_source": { "purchasePrices": [ { "currencyId": "b7d2554b0ce847cd82f3ac9bd1c0dfca", "net": 163.81, "gross": 194.9339, "linked": true, "listPrice": null } ], "referenceUnit": null, "purchaseUnit": null, "unit": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "0189b5bd28fd735a9afc1ef90696fc66": null }, "shortCode": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "0189b5bd28fd735a9afc1ef90696fc66": null }, "_count": 1 }, "crossSellings": [ { "id": "3a94759ba538406a81e06b70f55011a2", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shopware-CrossSelling" } } ], "keywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "CS-Gas Reizstoffspr\u00fchsystem Furie Cerberus Defence", "0189b5bd28fd735a9afc1ef90696fc66": null }, "packUnit": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "0189b5bd28fd735a9afc1ef90696fc66": null }, "packUnitPlural": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "0189b5bd28fd735a9afc1ef90696fc66": null }, "id": "e5e295df4a4d497e851482d087371c7c", "autoIncrement": 4411.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "0189b5bd293f71c6a5e92e9980f13639" } ], "availableStock": 4, "productNumber": "ersatzkartusche-furie-f-750", "ean": null, "displayGroup": "420b3413df2901a2b0262f20955e1c0e", "sales": 189, "stock": 4, "weight": 0.95, "width": 78.0, "length": 78.0, "height": 239.0, "manufacturerId": "27086d61528846639a1bf42519a999e1", "manufacturerNumber": "CB0002CS", "releaseDate": null, "createdAt": "2024-10-10T11:08:00+00:00", "categoryTree": [ "d7b7b163000841a1876dbff5548c039f", "1e866cbbceb14718b0fc586a82f9bf19", "ed73937c1fc54757a390ffc31536aa0d", "961ff154957b4846af19597e5fe3aee5", "ac4d80ae9ad14fd38a95346e6128d1c8" ], "categoriesRo": [ { "id": "d7b7b163000841a1876dbff5548c039f", "_count": 1 }, { "id": "1e866cbbceb14718b0fc586a82f9bf19", "_count": 1 }, { "id": "ed73937c1fc54757a390ffc31536aa0d", "_count": 1 }, { "id": "961ff154957b4846af19597e5fe3aee5", "_count": 1 }, { "id": "ac4d80ae9ad14fd38a95346e6128d1c8", "_count": 1 } ], "taxId": "0189b5bc757f71079ecf17a5e531d81e", "tags": [], "parentId": null, "coverId": "a2c4f8f0374243ffa6fba5001f995c68", "childCount": 0, "categories": [ { "id": "961ff154957b4846af19597e5fe3aee5", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Reizstoffspr\u00fchsystem" } }, { "id": "ac4d80ae9ad14fd38a95346e6128d1c8", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "8020 - Handelsware" } } ], "manufacturer": { "id": "27086d61528846639a1bf42519a999e1", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "FURIE Defence Systems", "0189b5bd28fd735a9afc1ef90696fc66": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "961ff154957b4846af19597e5fe3aee5", "ac4d80ae9ad14fd38a95346e6128d1c8" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": { "de_only": "1", "attr9": "{\"shipping\":null,\"quantity\":0,\"cuttedCount\":0,\"available\":4,\"deliveries\":[],\"warehouses\":[]}", "releasedate": "01.10.2024", "short_description": "Mit der Ersatzkartusche \"FURIE CS-Cartridge 750\" wechseln Sie den angebrochenen oder abgelaufenen Reizstoff Ihres FURIE Reizgasmodules aus. Sie erhalten von uns immer eine aktuelle und mindestens 24 Monate haltbare Ersatzkartusche." } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "ERSATZKARTUSCHE-FURIE-F-750", "0189b5bd28fd735a9afc1ef90696fc66": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Erstzkartusche f\u00fcr FURIE CS-Cartridge 750, mindestens 24 Monate haltbarErsatzkartusche f\u00fcr das Furie Defence Reizstoffspr\u00fchsystem.Die Reizstoffkartusche und der Wirkstoff CS Reizgas ist zugelassen vom Bundeskriminalamt BKA \"BKA 17r\"\n\nWirkstoff: Tr\u00e4nengas (CS) \nTreibmittel: Unbrennbare Spr\u00fchl\u00f6sung\nF\u00fcllmenge: 750 ml\nInsgesamt 18 Sekunden Spr\u00fchdauer\nMindesthaltbarkeit: 24 Monate", "0189b5bd28fd735a9afc1ef90696fc66": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "0189b5bd28fd735a9afc1ef90696fc66": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "0189b5bd28fd735a9afc1ef90696fc66": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": [ "CS-Gas", "Reizstoffspr\u00fchsystem", "Furie", "Cerberus", "Defence", "FURIE Defence Systems", "Reizstoffspr\u00fchsystem", "8020 - Handelsware" ], "0189b5bd28fd735a9afc1ef90696fc66": null }, "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 300.9748, "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 252.92, "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 224.91, "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 189.0, "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 300.9748, "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 252.92, "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 224.91, "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 189.0, "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 224.91, "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 189.0, "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 224.91, "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 189.0, "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 204.6806, "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 172.0005, "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 224.91, "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 189.0, "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 224.91, "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 189.0, "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 224.91, "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 189.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 300.9748, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 252.92, "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "ersatzkartusche-furie-f-750" ], "jtlorder": 0, "custom_numbers": [] }, "fields": { "displayGroup": [ "420b3413df2901a2b0262f20955e1c0e" ] }, "sort": [ 4, "ersatzkartusche-furie-f-750", "e5e295df4a4d497e851482d087371c7c" ] }, { "_index": "sw_dev_product_1744118278", "_id": "9728211e6a6b4241b97a771c493e1421", "_score": null, "_source": { "purchasePrices": [ { "currencyId": "b7d2554b0ce847cd82f3ac9bd1c0dfca", "net": 1199.0, "gross": 1426.81, "linked": true, "listPrice": null } ], "referenceUnit": null, "purchaseUnit": null, "unit": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "0189b5bd28fd735a9afc1ef90696fc66": null }, "shortCode": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "0189b5bd28fd735a9afc1ef90696fc66": null }, "_count": 1 }, "crossSellings": [ { "id": "046a9cce12b34e3eaf706060792b30a5", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shopware-CrossSelling" } } ], "keywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "CS-Gas Reizstoffspr\u00fchsystem Furie Cerberus Defence ", "0189b5bd28fd735a9afc1ef90696fc66": null }, "packUnit": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "0189b5bd28fd735a9afc1ef90696fc66": null }, "packUnitPlural": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "0189b5bd28fd735a9afc1ef90696fc66": null }, "id": "9728211e6a6b4241b97a771c493e1421", "autoIncrement": 4406.0, "ratingAverage": 5.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "0189b5bd293f71c6a5e92e9980f13639" } ], "availableStock": 2, "productNumber": "reizgasmodul-set furie x-750", "ean": null, "displayGroup": "81cc5c56690444586f79bd187ace26cc", "sales": 1499, "stock": 2, "weight": 1.95, "width": 105.0, "length": 98.0, "height": 396.0, "manufacturerId": "27086d61528846639a1bf42519a999e1", "manufacturerNumber": "CB0001x750", "releaseDate": null, "createdAt": "2024-10-10T08:57:48+00:00", "categoryTree": [ "d7b7b163000841a1876dbff5548c039f", "1e866cbbceb14718b0fc586a82f9bf19", "ed73937c1fc54757a390ffc31536aa0d", "961ff154957b4846af19597e5fe3aee5", "ac4d80ae9ad14fd38a95346e6128d1c8" ], "categoriesRo": [ { "id": "d7b7b163000841a1876dbff5548c039f", "_count": 1 }, { "id": "1e866cbbceb14718b0fc586a82f9bf19", "_count": 1 }, { "id": "ed73937c1fc54757a390ffc31536aa0d", "_count": 1 }, { "id": "961ff154957b4846af19597e5fe3aee5", "_count": 1 }, { "id": "ac4d80ae9ad14fd38a95346e6128d1c8", "_count": 1 } ], "taxId": "0189b5bc757f71079ecf17a5e531d81e", "tags": [], "parentId": null, "coverId": "5a27374203364730bb8421fafeca3d16", "childCount": 0, "categories": [ { "id": "961ff154957b4846af19597e5fe3aee5", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Reizstoffspr\u00fchsystem" } }, { "id": "ac4d80ae9ad14fd38a95346e6128d1c8", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "8020 - Handelsware" } } ], "manufacturer": { "id": "27086d61528846639a1bf42519a999e1", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "FURIE Defence Systems", "0189b5bd28fd735a9afc1ef90696fc66": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "961ff154957b4846af19597e5fe3aee5", "ac4d80ae9ad14fd38a95346e6128d1c8" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": { "de_only": "1", "attr9": "{\"shipping\":null,\"quantity\":0,\"cuttedCount\":0,\"available\":2,\"deliveries\":[],\"warehouses\":[]}", "releasedate": "12.09.2024", "short_description": "Das Furie Reizgasmodul f\u00fcr eine hocheffiziente Art der Personenvertreibung.\r\nIdeal f\u00fcr leerstehende Urlaubsresidenzen, Wohnmobile, Yachten und abgelegene Lagerr\u00e4ume.\r\nSichern Sie Ihr pers\u00f6nliches Eigentum gegen Zugriff\/Diebstahl anderer durch den Einsatz von CS-Gas (Tr\u00e4nengas).", "attr3": "B2B Film,B2C Film", "jtlorder": "0" } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "REIZGASMODUL-SET FURIE X-750", "0189b5bd28fd735a9afc1ef90696fc66": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Das Furie Defence ist ein Reizstoffspr\u00fchsystem, welches sicher und effizient R\u00e4ume und Geb\u00e4ude vor unberechtigtem Betreten und Einbruch sch\u00fctzt.Diese einzigartige Technologie ist hocheffizient und vertreibt T\u00e4ter in Sekunden.Furie Defence ist eine ideale Erg\u00e4nzung eines Alarmsystems und kann z.B. mit Ajax oder Jablotron Alarmsystemen kombiniert werden.Bei einem best\u00e4tigten Alarm wird der zu sichernde Bereich in wenigen Sekunden mit CS Reizgas \/ Tr\u00e4nengas kontaminiert und macht einen Einbruch und \u00dcberfall unm\u00f6glich. Das System und das CS Reitzgas ist r\u00fcckstandsfrei und vom T\u00dcV Nord gepr\u00fcft und vom BKA zugelassen\n\nWirkstoff: Tr\u00e4nengas (CS) \nT\u00dcV gepr\u00fcft nach EN50130-4:2015 \nBKA Zulassung \"BKA 17r\" \nTreibmittel: Unbrennbare Spr\u00fchl\u00f6sung \nF\u00fcllmenge: 750 ml \nInsgesamt 18 Sek. Spr\u00fchdauer \nSpr\u00fchkeule ca. 6m weit und 3m breit (s. Abb.)\nRaumvolumina bis 250m\u00b3 werden in sekundenschnell mit Reizgas geflutet\nSchnelle Montage \nAutarker Batteriebetrieb\nDas Set beinhaltet:\n\n1x FURIE X-750 Spr\u00fchmodul \n1x FURIE CS-Cartridge 750 mit 750ml CS-Gas \n2x FURIE BX-27 Batteriepack \n1x Warnhinweis Aufkleber f\u00fcr Scheiben \n1x Wandbefestigungs-Set", "0189b5bd28fd735a9afc1ef90696fc66": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "REIZGASMODUL-SET FURIE X-750 \| EPS", "0189b5bd28fd735a9afc1ef90696fc66": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Das Furie Reizgasmodul f\u00fcr eine hocheffiziente Art der Personenvertreibung.\r\nIdeal f\u00fcr leerstehende Urlaubsresidenzen, Wohnmobile, Yachten und abgelegene Lagerr\u00e4ume.", "0189b5bd28fd735a9afc1ef90696fc66": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": [ "CS-Gas", "Reizstoffspr\u00fchsystem", "Furie", "Cerberus", "Defence", "FURIE Defence Systems", "Reizstoffspr\u00fchsystem", "8020 - Handelsware" ], "0189b5bd28fd735a9afc1ef90696fc66": null }, "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1783.81, "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 1499.0, "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1783.81, "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 1499.0, "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1783.81, "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 1499.0, "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1498.1505, "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 1258.95, "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1783.81, "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 1499.0, "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1783.81, "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 1499.0, "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1783.81, "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 1499.0, "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 2499.0, "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 2100.0, "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1783.81, "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 1499.0, "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 2499.0, "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 2100.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 2499.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 2100.0, "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "reizgasmodul-set", "furie", "x-750", "reizgasmodul-set furie x-750" ], "jtlorder": 0, "custom_numbers": [] }, "fields": { "displayGroup": [ "81cc5c56690444586f79bd187ace26cc" ] }, "sort": [ 2, "reizgasmodul-set furie x-750", "9728211e6a6b4241b97a771c493e1421" ] }, { "_index": "sw_dev_product_1744118278", "_id": "6724b7391a804501ac32c6ac57403127", "_score": null, "_source": { "purchasePrices": [ { "currencyId": "b7d2554b0ce847cd82f3ac9bd1c0dfca", "net": 47.83, "gross": 56.9177, "linked": true, "listPrice": null } ], "referenceUnit": null, "purchaseUnit": null, "unit": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "0189b5bd28fd735a9afc1ef90696fc66": null }, "shortCode": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "0189b5bd28fd735a9afc1ef90696fc66": null }, "_count": 1 }, "crossSellings": [ { "id": "37130c25696741eea9e613f1d21a4d2f", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shopware-CrossSelling" } } ], "keywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "0189b5bd28fd735a9afc1ef90696fc66": null }, "packUnit": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "0189b5bd28fd735a9afc1ef90696fc66": null }, "packUnitPlural": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "0189b5bd28fd735a9afc1ef90696fc66": null }, "id": "6724b7391a804501ac32c6ac57403127", "autoIncrement": 4448.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "0189b5bd293f71c6a5e92e9980f13639" } ], "availableStock": 0, "productNumber": "ajax-furie-ready-home-siren-w", "ean": null, "displayGroup": "96c7752825f6d7077e885cd073446d96", "sales": 57, "stock": 0, "weight": 1.95, "width": 105.0, "length": 98.0, "height": 396.0, "manufacturerId": "27086d61528846639a1bf42519a999e1", "manufacturerNumber": "Ajax-Ready Home Sirene", "releaseDate": null, "createdAt": "2024-10-30T09:17:13+00:00", "categoryTree": [ "d7b7b163000841a1876dbff5548c039f", "1e866cbbceb14718b0fc586a82f9bf19", "ed73937c1fc54757a390ffc31536aa0d", "961ff154957b4846af19597e5fe3aee5", "ac4d80ae9ad14fd38a95346e6128d1c8" ], "categoriesRo": [ { "id": "d7b7b163000841a1876dbff5548c039f", "_count": 1 }, { "id": "1e866cbbceb14718b0fc586a82f9bf19", "_count": 1 }, { "id": "ed73937c1fc54757a390ffc31536aa0d", "_count": 1 }, { "id": "961ff154957b4846af19597e5fe3aee5", "_count": 1 }, { "id": "ac4d80ae9ad14fd38a95346e6128d1c8", "_count": 1 } ], "taxId": "0189b5bc757f71079ecf17a5e531d81e", "tags": [], "parentId": null, "coverId": "35da71d5362e44a19000b012925cf4af", "childCount": 0, "categories": [ { "id": "961ff154957b4846af19597e5fe3aee5", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Reizstoffspr\u00fchsystem" } }, { "id": "ac4d80ae9ad14fd38a95346e6128d1c8", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "8020 - Handelsware" } } ], "manufacturer": { "id": "27086d61528846639a1bf42519a999e1", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "FURIE Defence Systems", "0189b5bd28fd735a9afc1ef90696fc66": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "961ff154957b4846af19597e5fe3aee5", "ac4d80ae9ad14fd38a95346e6128d1c8" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": { "de_only": "1", "attr9": "{\"shipping\":null,\"quantity\":0,\"cuttedCount\":0,\"available\":0,\"deliveries\":[],\"warehouses\":[]}", "releasedate": "30.10.2024", "short_description": "Ajax-Furie Denfence Ready Home Siren ist für den Einsatz und die Integration des Reizstoffsprühsystems Furie Defence in das Ajax Alarmsystem vorbereitet." } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AJAX-FURIE-READY-HOME-SIREN-W", "0189b5bd28fd735a9afc1ef90696fc66": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Die wei\u00dfe Ajax-Furie Denfence Ready Home Siren ist f\u00fcr den Einsatz und die Integration des Reizstoffspr\u00fchsystems Furie Defence in das Ajax Alarmsystem vorbereitet. \u00dcber die herausgef\u00fchrten Signalleitungen ist eine dirkete Ansteuerung des Furie Defence System m\u00f6glich. Durch eine entsprechende Programmierung der Sirene in der Ajax App kann die Ausl\u00f6sung automatisch oder manuell erfolgen.Leistungsmerkmale: \n\nDirekte Anbindung an Furie Defence \nHohe Funkreichweite \nSignalst\u00f6rungserkennung \nManipulationsalarm", "0189b5bd28fd735a9afc1ef90696fc66": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "0189b5bd28fd735a9afc1ef90696fc66": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "0189b5bd28fd735a9afc1ef90696fc66": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": [ "Furie", "Reizgas", "Ready", "Alarm", "Ajax", "CS", "Gas", "Sirene", "FURIE Defence Systems", "Reizstoffspr\u00fchsystem", "8020 - Handelsware" ], "0189b5bd28fd735a9afc1ef90696fc66": null }, "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 67.83, "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 57.0, "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 67.83, "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 57.0, "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 67.83, "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 57.0, "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 67.83, "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 57.0, "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 67.83, "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 57.0, "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 117.81, "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 99.0, "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 67.83, "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 57.0, "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 117.81, "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 99.0, "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 59.7636, "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 50.2215, "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 67.83, "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 57.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 117.81, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 99.0, "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "ajax-furie-ready-home-siren-w" ], "jtlorder": 0, "custom_numbers": [] }, "fields": { "displayGroup": [ "96c7752825f6d7077e885cd073446d96" ] }, "sort": [ 0, "ajax-furie-ready-home-siren-w", "6724b7391a804501ac32c6ac57403127" ] }, { "_index": "sw_dev_product_1744118278", "_id": "295f5ca6520f44e0881713ddbf508cd5", "_score": null, "_source": { "purchasePrices": [ { "currencyId": "b7d2554b0ce847cd82f3ac9bd1c0dfca", "net": 0.0, "gross": 0.0, "linked": true, "listPrice": null } ], "referenceUnit": null, "purchaseUnit": null, "unit": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "0189b5bd28fd735a9afc1ef90696fc66": null }, "shortCode": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "0189b5bd28fd735a9afc1ef90696fc66": null }, "_count": 1 }, "crossSellings": [ { "id": "af4f2bc9f37b4c24a82cfe38fd127dcc", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shopware-CrossSelling" } } ], "keywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "CS-Gas Reizstoffspr\u00fchsystem Furie Cerberus Defence", "0189b5bd28fd735a9afc1ef90696fc66": null }, "packUnit": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "0189b5bd28fd735a9afc1ef90696fc66": null }, "packUnitPlural": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "0189b5bd28fd735a9afc1ef90696fc66": null }, "id": "295f5ca6520f44e0881713ddbf508cd5", "autoIncrement": 4412.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "0189b5bd293f71c6a5e92e9980f13639" } ], "availableStock": 0, "productNumber": "batterie-set-furie-b-27", "ean": null, "displayGroup": "db5bdabdac9a771f8569ccb813fefd9b", "sales": 129, "stock": 0, "weight": 0.39, "width": 55.0, "length": 63.0, "height": 70.0, "manufacturerId": "27086d61528846639a1bf42519a999e1", "manufacturerNumber": "CB0003B27", "releaseDate": null, "createdAt": "2024-10-10T11:08:01+00:00", "categoryTree": [ "d7b7b163000841a1876dbff5548c039f", "1e866cbbceb14718b0fc586a82f9bf19", "ed73937c1fc54757a390ffc31536aa0d", "961ff154957b4846af19597e5fe3aee5", "ac4d80ae9ad14fd38a95346e6128d1c8" ], "categoriesRo": [ { "id": "d7b7b163000841a1876dbff5548c039f", "_count": 1 }, { "id": "1e866cbbceb14718b0fc586a82f9bf19", "_count": 1 }, { "id": "ed73937c1fc54757a390ffc31536aa0d", "_count": 1 }, { "id": "961ff154957b4846af19597e5fe3aee5", "_count": 1 }, { "id": "ac4d80ae9ad14fd38a95346e6128d1c8", "_count": 1 } ], "taxId": "0189b5bc757f71079ecf17a5e531d81e", "tags": [], "parentId": null, "coverId": "94332480368f4dedbae954786f4bd0cb", "childCount": 0, "categories": [ { "id": "961ff154957b4846af19597e5fe3aee5", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Reizstoffspr\u00fchsystem" } }, { "id": "ac4d80ae9ad14fd38a95346e6128d1c8", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "8020 - Handelsware" } } ], "manufacturer": { "id": "27086d61528846639a1bf42519a999e1", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "FURIE Defence Systems", "0189b5bd28fd735a9afc1ef90696fc66": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "961ff154957b4846af19597e5fe3aee5", "ac4d80ae9ad14fd38a95346e6128d1c8" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": { "attr9": "{\"shipping\":null,\"quantity\":0,\"cuttedCount\":0,\"available\":0,\"deliveries\":[],\"warehouses\":[]}", "releasedate": "01.10.2024", "short_description": "Dieses Set ersetzt die verbrauchten Batterie-Packs in Ihrem \"FURIE Reizgas Spr\u00fchsystem\" und versorgt diese zuverl\u00e4ssig mit Energie." } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BATTERIE-SET-FURIE-B-27", "0189b5bd28fd735a9afc1ef90696fc66": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ersatzbatterien f\u00fcr das Furie Defence Reizstoffspr\u00fchsystem. Dieses Batteriepack bestehend aus 2 Ersatzbatterien.Einfacher Austausch und Anschluss, durch verpolungssicheren Anschluss.Lieferumfang: \n\ndas Set besteht aus 2 Batterien", "0189b5bd28fd735a9afc1ef90696fc66": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "0189b5bd28fd735a9afc1ef90696fc66": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "0189b5bd28fd735a9afc1ef90696fc66": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": [ "CS-Gas", "Reizstoffspr\u00fchsystem", "Furie", "Cerberus", "Defence", "FURIE Defence Systems", "Reizstoffspr\u00fchsystem", "8020 - Handelsware" ], "0189b5bd28fd735a9afc1ef90696fc66": null }, "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 199.8962, "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 167.98, "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 153.51, "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 129.0, "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 153.51, "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 129.0, "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 136.4329, "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 114.6495, "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 153.51, "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 129.0, "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 199.8962, "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 167.98, "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 153.51, "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 129.0, "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 153.51, "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 129.0, "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 153.51, "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 129.0, "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 153.51, "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 129.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 199.8962, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 167.98, "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "batterie-set-furie-b-27" ], "jtlorder": 0, "custom_numbers": [] }, "fields": { "displayGroup": [ "db5bdabdac9a771f8569ccb813fefd9b" ] }, "sort": [ 0, "batterie-set-furie-b-27", "295f5ca6520f44e0881713ddbf508cd5" ] }, { "_index": "sw_dev_product_1744118278", "_id": "ded21dde007f4a4e8535ebb0cd5282d5", "_score": null, "_source": { "purchasePrices": [ { "currencyId": "b7d2554b0ce847cd82f3ac9bd1c0dfca", "net": 163.81, "gross": 194.9339, "linked": true, "listPrice": null } ], "referenceUnit": null, "purchaseUnit": null, "unit": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "0189b5bd28fd735a9afc1ef90696fc66": null }, "shortCode": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "0189b5bd28fd735a9afc1ef90696fc66": null }, "_count": 1 }, "crossSellings": [ { "id": "f0123818e9ce40c4af3eaa31e08bb835", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shopware-CrossSelling" } } ], "keywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "CS-Gas Reizstoffspr\u00fchsystem Furie Cerberus Defence", "0189b5bd28fd735a9afc1ef90696fc66": null }, "packUnit": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "0189b5bd28fd735a9afc1ef90696fc66": null }, "packUnitPlural": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "0189b5bd28fd735a9afc1ef90696fc66": null }, "id": "ded21dde007f4a4e8535ebb0cd5282d5", "autoIncrement": 4413.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "0189b5bd293f71c6a5e92e9980f13639" } ], "availableStock": 0, "productNumber": "inert-kartusche-furie-f-750", "ean": null, "displayGroup": "236a999f402097498d17763a56774c26", "sales": 189, "stock": 0, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "27086d61528846639a1bf42519a999e1", "manufacturerNumber": "INERT", "releaseDate": null, "createdAt": "2024-10-10T11:08:01+00:00", "categoryTree": [ "d7b7b163000841a1876dbff5548c039f", "1e866cbbceb14718b0fc586a82f9bf19", "ed73937c1fc54757a390ffc31536aa0d", "961ff154957b4846af19597e5fe3aee5", "ac4d80ae9ad14fd38a95346e6128d1c8" ], "categoriesRo": [ { "id": "d7b7b163000841a1876dbff5548c039f", "_count": 1 }, { "id": "1e866cbbceb14718b0fc586a82f9bf19", "_count": 1 }, { "id": "ed73937c1fc54757a390ffc31536aa0d", "_count": 1 }, { "id": "961ff154957b4846af19597e5fe3aee5", "_count": 1 }, { "id": "ac4d80ae9ad14fd38a95346e6128d1c8", "_count": 1 } ], "taxId": "0189b5bc757f71079ecf17a5e531d81e", "tags": [], "parentId": null, "coverId": "94e3e9cfc18d48d19f61145bdc963333", "childCount": 0, "categories": [ { "id": "961ff154957b4846af19597e5fe3aee5", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Reizstoffspr\u00fchsystem" } }, { "id": "ac4d80ae9ad14fd38a95346e6128d1c8", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "8020 - Handelsware" } } ], "manufacturer": { "id": "27086d61528846639a1bf42519a999e1", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "FURIE Defence Systems", "0189b5bd28fd735a9afc1ef90696fc66": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "961ff154957b4846af19597e5fe3aee5", "ac4d80ae9ad14fd38a95346e6128d1c8" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": { "de_only": "1", "attr9": "{\"shipping\":null,\"quantity\":0,\"cuttedCount\":0,\"available\":0,\"deliveries\":[],\"warehouses\":[]}", "releasedate": "02.10.2024", "short_description": "INERT Kartusche zur Demonstration des Systems ohne CS Gas" } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "INERT-KARTUSCHE-FURIE-F-750", "0189b5bd28fd735a9afc1ef90696fc66": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "INERT Ersatzkartusche ohne CS-Gas. Diese Kartusche kann f\u00fcr Vorf\u00fchrungen und Testzwecke verwendet werden.Kein Wirkstoff CS Gas enthalten.\n\nTreibmittel: Unbrennbare Spr\u00fchl\u00f6sung\nInsgesamt 18 Sekunden Spr\u00fchdauer", "0189b5bd28fd735a9afc1ef90696fc66": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "0189b5bd28fd735a9afc1ef90696fc66": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "0189b5bd28fd735a9afc1ef90696fc66": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": [ "Defence", "Cerberus", "Furie", "Reizstoffspr\u00fchsystem", "CS-Gas", "FURIE Defence Systems", "Reizstoffspr\u00fchsystem", "8020 - Handelsware" ], "0189b5bd28fd735a9afc1ef90696fc66": null }, "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 224.91, "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 189.0, "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 300.9748, "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 252.92, "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 224.91, "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 189.0, "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 224.91, "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 189.0, "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 224.91, "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 189.0, "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 224.91, "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 189.0, "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 300.9748, "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 252.92, "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 224.91, "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 189.0, "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 204.6806, "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 172.0005, "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 224.91, "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 189.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 300.9748, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 252.92, "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "inert-kartusche-furie-f-750" ], "jtlorder": 0, "custom_numbers": [] }, "fields": { "displayGroup": [ "236a999f402097498d17763a56774c26" ] }, "sort": [ 0, "inert-kartusche-furie-f-750", "ded21dde007f4a4e8535ebb0cd5282d5" ] } ] }, "aggregations": { "total-filtered-count": { "doc_count": 5, "total-count": { "value": 5 } } } } `Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search`
2	3.09 ms	Request: {"index":"sw_dev_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"0189b5bd293f71c6a5e92e9980f13639"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"961ff154957b4846af19597e5fe3aee5"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}},{"bool":{"must_not":[{"bool":{"must":[{"term":{"isCloseout":true}},{"term":{"available":false}}]}}]}}]}}]}},"aggregations":{"manufacturer":{"terms":{"field":"manufacturerId","size":10000}},"price":{"stats":{"script":{"source":"double getPrice(def accessors, def doc, def decimals, def round, def multiplier) {\n for (accessor in accessors) {\n def key = accessor['key'];\n\n if (!doc.containsKey(key) \|\| doc[key].empty) {\n continue;\n }\n\n def factor = accessor['factor'];\n def value = doc[key].value * factor;\n\n value = Math.round(value * decimals);\n value = (double) value \/ decimals;\n\n if (!round) {\n return (double) value;\n }\n\n value = Math.round(value * multiplier);\n\n value = (double) value \/ multiplier;\n\n return (double) value;\n }\n\n return 0;\n}\n\nreturn getPrice(params['accessors'], doc, params['decimals'], params['round'], params['multiplier']);\n","lang":"painless","params":{"accessors":[{"key":"cheapest_price_rule471f2ca5e74440568ba57912bb0f3d50_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc757970f38af8d735ac2bef24_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc757d738cb8f62b8ca13162fd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc781372e48ae25e3fc49e6c75_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5c9aba570cdb1eb3cecd2cd9c14_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5c9abd170d5a439e74a4020e81c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule018c7cebb95d7085930868a24624ed56_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc758c718ca89324f9e3bbcdfd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5c9ab9b73b8b6ca8da792e44880_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1}],"decimals":100,"round":true,"multiplier":100.0}}}},"rating-exists":{"filter":{"range":{"ratingAverage":{"gte":0.0}}},"aggregations":{"rating":{"max":{"field":"ratingAverage"}}}},"shipping-free-filter":{"filter":{"term":{"shippingFree":true}},"aggregations":{"shipping-free":{"max":{"field":"shippingFree"}}}},"properties":{"nested":{"path":"properties"},"aggregations":{"properties":{"terms":{"field":"properties.id","size":10000}}}},"options":{"nested":{"path":"options"},"aggregations":{"options":{"terms":{"field":"options.id","size":10000}}}},"manufacturer_count":{"terms":{"field":"manufacturerId","size":10000}},"propertiesCount":{"terms":{"field":"propertyIds","size":10000}},"immediately-available-filter":{"max":{"field":"availableStock"}}},"size":0,"timeout":"5s"},"search_type":"query_then_fetch"} Item count: View formatted request View formatted response View query backtrace POST http://10.20.0.3:9200/sw_dev_product/_search?track_total_hits=0&search_type=query_then_fetch Accept: application/json Content-Type: application/json { "query": { "bool": { "filter": [ { "bool": { "must": [ { "bool": { "must": [ { "nested": { "path": "visibilities", "query": { "bool": { "must": [ { "range": { "visibilities.visibility": { "gte": 30 } } }, { "term": { "visibilities.salesChannelId": "0189b5bd293f71c6a5e92e9980f13639" } } ] } } } }, { "term": { "active": true } } ] } }, { "nested": { "path": "categoriesRo", "query": { "term": { "categoriesRo.id": "961ff154957b4846af19597e5fe3aee5" } } } }, { "bool": { "must_not": [ { "bool": { "must_not": [ { "exists": { "field": "displayGroup" } } ] } } ] } }, { "bool": { "must_not": [ { "bool": { "must": [ { "term": { "isCloseout": true } }, { "term": { "available": false } } ] } } ] } } ] } } ] } }, "aggregations": { "manufacturer": { "terms": { "field": "manufacturerId", "size": 10000 } }, "price": { "stats": { "script": { "source": "double getPrice(def accessors, def doc, def decimals, def round, def multiplier) {\n for (accessor in accessors) {\n def key = accessor['key'];\n\n if (!doc.containsKey(key) \|\| doc[key].empty) {\n continue;\n }\n\n def factor = accessor['factor'];\n def value = doc[key].value * factor;\n\n value = Math.round(value * decimals);\n value = (double) value \/ decimals;\n\n if (!round) {\n return (double) value;\n }\n\n value = Math.round(value * multiplier);\n\n value = (double) value \/ multiplier;\n\n return (double) value;\n }\n\n return 0;\n}\n\nreturn getPrice(params['accessors'], doc, params['decimals'], params['round'], params['multiplier']);\n", "lang": "painless", "params": { "accessors": [ { "key": "cheapest_price_rule471f2ca5e74440568ba57912bb0f3d50_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0189b5bc757970f38af8d735ac2bef24_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0189b5bc757d738cb8f62b8ca13162fd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0189b5bc781372e48ae25e3fc49e6c75_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0189b5c9aba570cdb1eb3cecd2cd9c14_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0189b5c9abd170d5a439e74a4020e81c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule018c7cebb95d7085930868a24624ed56_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0189b5bc758c718ca89324f9e3bbcdfd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0189b5c9ab9b73b8b6ca8da792e44880_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 } ], "decimals": 100, "round": true, "multiplier": 100.0 } } } }, "rating-exists": { "filter": { "range": { "ratingAverage": { "gte": 0.0 } } }, "aggregations": { "rating": { "max": { "field": "ratingAverage" } } } }, "shipping-free-filter": { "filter": { "term": { "shippingFree": true } }, "aggregations": { "shipping-free": { "max": { "field": "shippingFree" } } } }, "properties": { "nested": { "path": "properties" }, "aggregations": { "properties": { "terms": { "field": "properties.id", "size": 10000 } } } }, "options": { "nested": { "path": "options" }, "aggregations": { "options": { "terms": { "field": "options.id", "size": 10000 } } } }, "manufacturer_count": { "terms": { "field": "manufacturerId", "size": 10000 } }, "propertiesCount": { "terms": { "field": "propertyIds", "size": 10000 } }, "immediately-available-filter": { "max": { "field": "availableStock" } } }, "size": 0, "timeout": "5s" } { "took": 1, "timed_out": false, "_shards": { "total": 3, "successful": 3, "skipped": 0, "failed": 0 }, "hits": { "max_score": null, "hits": [] }, "aggregations": { "manufacturer_count": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [ { "key": "27086d61528846639a1bf42519a999e1", "doc_count": 5 } ] }, "shipping-free-filter": { "doc_count": 0, "shipping-free": { "value": null } }, "propertiesCount": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [] }, "rating-exists": { "doc_count": 5, "rating": { "value": 5.0 } }, "price": { "count": 5, "min": 99.0, "max": 2100.0, "avg": 574.5640000000001, "sum": 2872.82 }, "immediately-available-filter": { "value": 4.0 }, "options": { "doc_count": 0, "options": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [] } }, "properties": { "doc_count": 0, "properties": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [] } }, "manufacturer": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [ { "key": "27086d61528846639a1bf42519a999e1", "doc_count": 5 } ] } } } `Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate`

Request:

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

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


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

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


                                    {
    "took": 2,
    "timed_out": false,
    "_shards": {
        "total": 3,
        "successful": 3,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": {
            "value": 5,
            "relation": "eq"
        },
        "max_score": null,
        "hits": [
            {
                "_index": "sw_dev_product_1744118278",
                "_id": "e5e295df4a4d497e851482d087371c7c",
                "_score": null,
                "_source": {
                    "purchasePrices": [
                        {
                            "currencyId": "b7d2554b0ce847cd82f3ac9bd1c0dfca",
                            "net": 163.81,
                            "gross": 194.9339,
                            "linked": true,
                            "listPrice": null
                        }
                    ],
                    "referenceUnit": null,
                    "purchaseUnit": null,
                    "unit": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "0189b5bd28fd735a9afc1ef90696fc66": null
                        },
                        "shortCode": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "0189b5bd28fd735a9afc1ef90696fc66": null
                        },
                        "_count": 1
                    },
                    "crossSellings": [
                        {
                            "id": "3a94759ba538406a81e06b70f55011a2",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shopware-CrossSelling"
                            }
                        }
                    ],
                    "keywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "CS-Gas Reizstoffspr\u00fchsystem Furie Cerberus Defence",
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "packUnit": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "packUnitPlural": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "id": "e5e295df4a4d497e851482d087371c7c",
                    "autoIncrement": 4411.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "0189b5bd293f71c6a5e92e9980f13639"
                        }
                    ],
                    "availableStock": 4,
                    "productNumber": "ersatzkartusche-furie-f-750",
                    "ean": null,
                    "displayGroup": "420b3413df2901a2b0262f20955e1c0e",
                    "sales": 189,
                    "stock": 4,
                    "weight": 0.95,
                    "width": 78.0,
                    "length": 78.0,
                    "height": 239.0,
                    "manufacturerId": "27086d61528846639a1bf42519a999e1",
                    "manufacturerNumber": "CB0002CS",
                    "releaseDate": null,
                    "createdAt": "2024-10-10T11:08:00+00:00",
                    "categoryTree": [
                        "d7b7b163000841a1876dbff5548c039f",
                        "1e866cbbceb14718b0fc586a82f9bf19",
                        "ed73937c1fc54757a390ffc31536aa0d",
                        "961ff154957b4846af19597e5fe3aee5",
                        "ac4d80ae9ad14fd38a95346e6128d1c8"
                    ],
                    "categoriesRo": [
                        {
                            "id": "d7b7b163000841a1876dbff5548c039f",
                            "_count": 1
                        },
                        {
                            "id": "1e866cbbceb14718b0fc586a82f9bf19",
                            "_count": 1
                        },
                        {
                            "id": "ed73937c1fc54757a390ffc31536aa0d",
                            "_count": 1
                        },
                        {
                            "id": "961ff154957b4846af19597e5fe3aee5",
                            "_count": 1
                        },
                        {
                            "id": "ac4d80ae9ad14fd38a95346e6128d1c8",
                            "_count": 1
                        }
                    ],
                    "taxId": "0189b5bc757f71079ecf17a5e531d81e",
                    "tags": [],
                    "parentId": null,
                    "coverId": "a2c4f8f0374243ffa6fba5001f995c68",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "961ff154957b4846af19597e5fe3aee5",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Reizstoffspr\u00fchsystem"
                            }
                        },
                        {
                            "id": "ac4d80ae9ad14fd38a95346e6128d1c8",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "8020 - Handelsware"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "27086d61528846639a1bf42519a999e1",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "FURIE Defence Systems",
                            "0189b5bd28fd735a9afc1ef90696fc66": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "961ff154957b4846af19597e5fe3aee5",
                        "ac4d80ae9ad14fd38a95346e6128d1c8"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
                            "de_only": "1",
                            "attr9": "{\"shipping\":null,\"quantity\":0,\"cuttedCount\":0,\"available\":4,\"deliveries\":[],\"warehouses\":[]}",
                            "releasedate": "01.10.2024",
                            "short_description": "Mit der Ersatzkartusche \"FURIE CS-Cartridge 750\" wechseln Sie den angebrochenen oder abgelaufenen Reizstoff Ihres FURIE Reizgasmodules aus. Sie erhalten von uns immer eine aktuelle und mindestens 24 Monate haltbare Ersatzkartusche."
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "ERSATZKARTUSCHE-FURIE-F-750",
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Erstzkartusche f\u00fcr FURIE CS-Cartridge 750, mindestens 24 Monate haltbarErsatzkartusche f\u00fcr das Furie Defence Reizstoffspr\u00fchsystem.Die Reizstoffkartusche und der Wirkstoff CS Reizgas ist zugelassen vom Bundeskriminalamt BKA \"BKA 17r\"\n\nWirkstoff: Tr\u00e4nengas (CS) \nTreibmittel: Unbrennbare Spr\u00fchl\u00f6sung\nF\u00fcllmenge: 750 ml\nInsgesamt 18 Sekunden Spr\u00fchdauer\nMindesthaltbarkeit: 24 Monate",
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": [
                            "CS-Gas",
                            "Reizstoffspr\u00fchsystem",
                            "Furie",
                            "Cerberus",
                            "Defence",
                            "FURIE Defence Systems",
                            "Reizstoffspr\u00fchsystem",
                            "8020 - Handelsware"
                        ],
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 300.9748,
                    "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 252.92,
                    "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 224.91,
                    "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 189.0,
                    "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 300.9748,
                    "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 252.92,
                    "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 224.91,
                    "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 189.0,
                    "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 224.91,
                    "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 189.0,
                    "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 224.91,
                    "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 189.0,
                    "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 204.6806,
                    "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 172.0005,
                    "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 224.91,
                    "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 189.0,
                    "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 224.91,
                    "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 189.0,
                    "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 224.91,
                    "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 189.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 300.9748,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 252.92,
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "ersatzkartusche-furie-f-750"
                    ],
                    "jtlorder": 0,
                    "custom_numbers": []
                },
                "fields": {
                    "displayGroup": [
                        "420b3413df2901a2b0262f20955e1c0e"
                    ]
                },
                "sort": [
                    4,
                    "ersatzkartusche-furie-f-750",
                    "e5e295df4a4d497e851482d087371c7c"
                ]
            },
            {
                "_index": "sw_dev_product_1744118278",
                "_id": "9728211e6a6b4241b97a771c493e1421",
                "_score": null,
                "_source": {
                    "purchasePrices": [
                        {
                            "currencyId": "b7d2554b0ce847cd82f3ac9bd1c0dfca",
                            "net": 1199.0,
                            "gross": 1426.81,
                            "linked": true,
                            "listPrice": null
                        }
                    ],
                    "referenceUnit": null,
                    "purchaseUnit": null,
                    "unit": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "0189b5bd28fd735a9afc1ef90696fc66": null
                        },
                        "shortCode": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "0189b5bd28fd735a9afc1ef90696fc66": null
                        },
                        "_count": 1
                    },
                    "crossSellings": [
                        {
                            "id": "046a9cce12b34e3eaf706060792b30a5",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shopware-CrossSelling"
                            }
                        }
                    ],
                    "keywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "CS-Gas Reizstoffspr\u00fchsystem Furie Cerberus Defence ",
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "packUnit": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "packUnitPlural": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "id": "9728211e6a6b4241b97a771c493e1421",
                    "autoIncrement": 4406.0,
                    "ratingAverage": 5.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "0189b5bd293f71c6a5e92e9980f13639"
                        }
                    ],
                    "availableStock": 2,
                    "productNumber": "reizgasmodul-set furie x-750",
                    "ean": null,
                    "displayGroup": "81cc5c56690444586f79bd187ace26cc",
                    "sales": 1499,
                    "stock": 2,
                    "weight": 1.95,
                    "width": 105.0,
                    "length": 98.0,
                    "height": 396.0,
                    "manufacturerId": "27086d61528846639a1bf42519a999e1",
                    "manufacturerNumber": "CB0001x750",
                    "releaseDate": null,
                    "createdAt": "2024-10-10T08:57:48+00:00",
                    "categoryTree": [
                        "d7b7b163000841a1876dbff5548c039f",
                        "1e866cbbceb14718b0fc586a82f9bf19",
                        "ed73937c1fc54757a390ffc31536aa0d",
                        "961ff154957b4846af19597e5fe3aee5",
                        "ac4d80ae9ad14fd38a95346e6128d1c8"
                    ],
                    "categoriesRo": [
                        {
                            "id": "d7b7b163000841a1876dbff5548c039f",
                            "_count": 1
                        },
                        {
                            "id": "1e866cbbceb14718b0fc586a82f9bf19",
                            "_count": 1
                        },
                        {
                            "id": "ed73937c1fc54757a390ffc31536aa0d",
                            "_count": 1
                        },
                        {
                            "id": "961ff154957b4846af19597e5fe3aee5",
                            "_count": 1
                        },
                        {
                            "id": "ac4d80ae9ad14fd38a95346e6128d1c8",
                            "_count": 1
                        }
                    ],
                    "taxId": "0189b5bc757f71079ecf17a5e531d81e",
                    "tags": [],
                    "parentId": null,
                    "coverId": "5a27374203364730bb8421fafeca3d16",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "961ff154957b4846af19597e5fe3aee5",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Reizstoffspr\u00fchsystem"
                            }
                        },
                        {
                            "id": "ac4d80ae9ad14fd38a95346e6128d1c8",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "8020 - Handelsware"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "27086d61528846639a1bf42519a999e1",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "FURIE Defence Systems",
                            "0189b5bd28fd735a9afc1ef90696fc66": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "961ff154957b4846af19597e5fe3aee5",
                        "ac4d80ae9ad14fd38a95346e6128d1c8"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
                            "de_only": "1",
                            "attr9": "{\"shipping\":null,\"quantity\":0,\"cuttedCount\":0,\"available\":2,\"deliveries\":[],\"warehouses\":[]}",
                            "releasedate": "12.09.2024",
                            "short_description": "Das Furie Reizgasmodul f\u00fcr eine hocheffiziente Art der Personenvertreibung.\r\nIdeal f\u00fcr leerstehende Urlaubsresidenzen, Wohnmobile, Yachten und abgelegene Lagerr\u00e4ume.\r\nSichern Sie Ihr pers\u00f6nliches Eigentum gegen Zugriff\/Diebstahl anderer durch den Einsatz von CS-Gas (Tr\u00e4nengas).",
                            "attr3": "B2B Film,B2C Film",
                            "jtlorder": "0"
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "REIZGASMODUL-SET FURIE X-750",
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Das Furie Defence ist ein Reizstoffspr\u00fchsystem, welches sicher und effizient R\u00e4ume und Geb\u00e4ude vor unberechtigtem Betreten und Einbruch sch\u00fctzt.Diese einzigartige Technologie ist hocheffizient und vertreibt T\u00e4ter in Sekunden.Furie Defence ist eine ideale Erg\u00e4nzung eines Alarmsystems und kann z.B. mit Ajax oder Jablotron Alarmsystemen kombiniert werden.Bei einem best\u00e4tigten Alarm wird der zu sichernde Bereich in wenigen Sekunden mit CS Reizgas \/ Tr\u00e4nengas kontaminiert und macht einen Einbruch und \u00dcberfall unm\u00f6glich. Das System und das CS Reitzgas ist r\u00fcckstandsfrei und vom T\u00dcV Nord gepr\u00fcft und vom BKA zugelassen\n\nWirkstoff: Tr\u00e4nengas (CS) \nT\u00dcV gepr\u00fcft nach EN50130-4:2015 \nBKA Zulassung \"BKA 17r\" \nTreibmittel: Unbrennbare Spr\u00fchl\u00f6sung \nF\u00fcllmenge: 750 ml \nInsgesamt 18 Sek. Spr\u00fchdauer \nSpr\u00fchkeule ca. 6m weit und 3m breit (s. Abb.)\nRaumvolumina bis 250m\u00b3 werden in sekundenschnell mit Reizgas geflutet\nSchnelle Montage \nAutarker Batteriebetrieb\nDas Set beinhaltet:\n\n1x FURIE X-750 Spr\u00fchmodul \n1x FURIE CS-Cartridge 750 mit 750ml CS-Gas \n2x FURIE BX-27 Batteriepack \n1x Warnhinweis Aufkleber f\u00fcr Scheiben \n1x Wandbefestigungs-Set",
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "REIZGASMODUL-SET FURIE X-750 | EPS",
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Das Furie Reizgasmodul f\u00fcr eine hocheffiziente Art der Personenvertreibung.\r\nIdeal f\u00fcr leerstehende Urlaubsresidenzen, Wohnmobile, Yachten und abgelegene Lagerr\u00e4ume.",
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": [
                            "CS-Gas",
                            "Reizstoffspr\u00fchsystem",
                            "Furie",
                            "Cerberus",
                            "Defence",
                            "FURIE Defence Systems",
                            "Reizstoffspr\u00fchsystem",
                            "8020 - Handelsware"
                        ],
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1783.81,
                    "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 1499.0,
                    "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1783.81,
                    "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 1499.0,
                    "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1783.81,
                    "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 1499.0,
                    "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1498.1505,
                    "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 1258.95,
                    "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1783.81,
                    "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 1499.0,
                    "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1783.81,
                    "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 1499.0,
                    "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1783.81,
                    "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 1499.0,
                    "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 2499.0,
                    "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 2100.0,
                    "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1783.81,
                    "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 1499.0,
                    "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 2499.0,
                    "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 2100.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 2499.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 2100.0,
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "reizgasmodul-set",
                        "furie",
                        "x-750",
                        "reizgasmodul-set furie x-750"
                    ],
                    "jtlorder": 0,
                    "custom_numbers": []
                },
                "fields": {
                    "displayGroup": [
                        "81cc5c56690444586f79bd187ace26cc"
                    ]
                },
                "sort": [
                    2,
                    "reizgasmodul-set furie x-750",
                    "9728211e6a6b4241b97a771c493e1421"
                ]
            },
            {
                "_index": "sw_dev_product_1744118278",
                "_id": "6724b7391a804501ac32c6ac57403127",
                "_score": null,
                "_source": {
                    "purchasePrices": [
                        {
                            "currencyId": "b7d2554b0ce847cd82f3ac9bd1c0dfca",
                            "net": 47.83,
                            "gross": 56.9177,
                            "linked": true,
                            "listPrice": null
                        }
                    ],
                    "referenceUnit": null,
                    "purchaseUnit": null,
                    "unit": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "0189b5bd28fd735a9afc1ef90696fc66": null
                        },
                        "shortCode": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "0189b5bd28fd735a9afc1ef90696fc66": null
                        },
                        "_count": 1
                    },
                    "crossSellings": [
                        {
                            "id": "37130c25696741eea9e613f1d21a4d2f",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shopware-CrossSelling"
                            }
                        }
                    ],
                    "keywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "packUnit": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "packUnitPlural": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "id": "6724b7391a804501ac32c6ac57403127",
                    "autoIncrement": 4448.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "0189b5bd293f71c6a5e92e9980f13639"
                        }
                    ],
                    "availableStock": 0,
                    "productNumber": "ajax-furie-ready-home-siren-w",
                    "ean": null,
                    "displayGroup": "96c7752825f6d7077e885cd073446d96",
                    "sales": 57,
                    "stock": 0,
                    "weight": 1.95,
                    "width": 105.0,
                    "length": 98.0,
                    "height": 396.0,
                    "manufacturerId": "27086d61528846639a1bf42519a999e1",
                    "manufacturerNumber": "Ajax-Ready Home Sirene",
                    "releaseDate": null,
                    "createdAt": "2024-10-30T09:17:13+00:00",
                    "categoryTree": [
                        "d7b7b163000841a1876dbff5548c039f",
                        "1e866cbbceb14718b0fc586a82f9bf19",
                        "ed73937c1fc54757a390ffc31536aa0d",
                        "961ff154957b4846af19597e5fe3aee5",
                        "ac4d80ae9ad14fd38a95346e6128d1c8"
                    ],
                    "categoriesRo": [
                        {
                            "id": "d7b7b163000841a1876dbff5548c039f",
                            "_count": 1
                        },
                        {
                            "id": "1e866cbbceb14718b0fc586a82f9bf19",
                            "_count": 1
                        },
                        {
                            "id": "ed73937c1fc54757a390ffc31536aa0d",
                            "_count": 1
                        },
                        {
                            "id": "961ff154957b4846af19597e5fe3aee5",
                            "_count": 1
                        },
                        {
                            "id": "ac4d80ae9ad14fd38a95346e6128d1c8",
                            "_count": 1
                        }
                    ],
                    "taxId": "0189b5bc757f71079ecf17a5e531d81e",
                    "tags": [],
                    "parentId": null,
                    "coverId": "35da71d5362e44a19000b012925cf4af",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "961ff154957b4846af19597e5fe3aee5",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Reizstoffspr\u00fchsystem"
                            }
                        },
                        {
                            "id": "ac4d80ae9ad14fd38a95346e6128d1c8",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "8020 - Handelsware"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "27086d61528846639a1bf42519a999e1",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "FURIE Defence Systems",
                            "0189b5bd28fd735a9afc1ef90696fc66": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "961ff154957b4846af19597e5fe3aee5",
                        "ac4d80ae9ad14fd38a95346e6128d1c8"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
                            "de_only": "1",
                            "attr9": "{\"shipping\":null,\"quantity\":0,\"cuttedCount\":0,\"available\":0,\"deliveries\":[],\"warehouses\":[]}",
                            "releasedate": "30.10.2024",
                            "short_description": "Ajax-Furie Denfence Ready Home Siren ist f&uuml;r den Einsatz und die Integration des Reizstoffspr&uuml;hsystems Furie Defence in das Ajax Alarmsystem vorbereitet."
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AJAX-FURIE-READY-HOME-SIREN-W",
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Die wei\u00dfe Ajax-Furie Denfence Ready Home Siren ist f\u00fcr den Einsatz und die Integration des Reizstoffspr\u00fchsystems Furie Defence in das Ajax Alarmsystem vorbereitet. \u00dcber die herausgef\u00fchrten Signalleitungen ist eine dirkete Ansteuerung des Furie Defence System m\u00f6glich. Durch eine entsprechende Programmierung der Sirene in der Ajax App kann die Ausl\u00f6sung automatisch oder manuell erfolgen.Leistungsmerkmale: \n\nDirekte Anbindung an Furie Defence \nHohe Funkreichweite \nSignalst\u00f6rungserkennung \nManipulationsalarm",
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": [
                            "Furie",
                            "Reizgas",
                            "Ready",
                            "Alarm",
                            "Ajax",
                            "CS",
                            "Gas",
                            "Sirene",
                            "FURIE Defence Systems",
                            "Reizstoffspr\u00fchsystem",
                            "8020 - Handelsware"
                        ],
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 67.83,
                    "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 57.0,
                    "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 67.83,
                    "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 57.0,
                    "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 67.83,
                    "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 57.0,
                    "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 67.83,
                    "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 57.0,
                    "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 67.83,
                    "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 57.0,
                    "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 117.81,
                    "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 99.0,
                    "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 67.83,
                    "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 57.0,
                    "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 117.81,
                    "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 99.0,
                    "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 59.7636,
                    "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 50.2215,
                    "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 67.83,
                    "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 57.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 117.81,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 99.0,
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "ajax-furie-ready-home-siren-w"
                    ],
                    "jtlorder": 0,
                    "custom_numbers": []
                },
                "fields": {
                    "displayGroup": [
                        "96c7752825f6d7077e885cd073446d96"
                    ]
                },
                "sort": [
                    0,
                    "ajax-furie-ready-home-siren-w",
                    "6724b7391a804501ac32c6ac57403127"
                ]
            },
            {
                "_index": "sw_dev_product_1744118278",
                "_id": "295f5ca6520f44e0881713ddbf508cd5",
                "_score": null,
                "_source": {
                    "purchasePrices": [
                        {
                            "currencyId": "b7d2554b0ce847cd82f3ac9bd1c0dfca",
                            "net": 0.0,
                            "gross": 0.0,
                            "linked": true,
                            "listPrice": null
                        }
                    ],
                    "referenceUnit": null,
                    "purchaseUnit": null,
                    "unit": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "0189b5bd28fd735a9afc1ef90696fc66": null
                        },
                        "shortCode": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "0189b5bd28fd735a9afc1ef90696fc66": null
                        },
                        "_count": 1
                    },
                    "crossSellings": [
                        {
                            "id": "af4f2bc9f37b4c24a82cfe38fd127dcc",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shopware-CrossSelling"
                            }
                        }
                    ],
                    "keywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "CS-Gas Reizstoffspr\u00fchsystem Furie Cerberus Defence",
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "packUnit": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "packUnitPlural": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "id": "295f5ca6520f44e0881713ddbf508cd5",
                    "autoIncrement": 4412.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "0189b5bd293f71c6a5e92e9980f13639"
                        }
                    ],
                    "availableStock": 0,
                    "productNumber": "batterie-set-furie-b-27",
                    "ean": null,
                    "displayGroup": "db5bdabdac9a771f8569ccb813fefd9b",
                    "sales": 129,
                    "stock": 0,
                    "weight": 0.39,
                    "width": 55.0,
                    "length": 63.0,
                    "height": 70.0,
                    "manufacturerId": "27086d61528846639a1bf42519a999e1",
                    "manufacturerNumber": "CB0003B27",
                    "releaseDate": null,
                    "createdAt": "2024-10-10T11:08:01+00:00",
                    "categoryTree": [
                        "d7b7b163000841a1876dbff5548c039f",
                        "1e866cbbceb14718b0fc586a82f9bf19",
                        "ed73937c1fc54757a390ffc31536aa0d",
                        "961ff154957b4846af19597e5fe3aee5",
                        "ac4d80ae9ad14fd38a95346e6128d1c8"
                    ],
                    "categoriesRo": [
                        {
                            "id": "d7b7b163000841a1876dbff5548c039f",
                            "_count": 1
                        },
                        {
                            "id": "1e866cbbceb14718b0fc586a82f9bf19",
                            "_count": 1
                        },
                        {
                            "id": "ed73937c1fc54757a390ffc31536aa0d",
                            "_count": 1
                        },
                        {
                            "id": "961ff154957b4846af19597e5fe3aee5",
                            "_count": 1
                        },
                        {
                            "id": "ac4d80ae9ad14fd38a95346e6128d1c8",
                            "_count": 1
                        }
                    ],
                    "taxId": "0189b5bc757f71079ecf17a5e531d81e",
                    "tags": [],
                    "parentId": null,
                    "coverId": "94332480368f4dedbae954786f4bd0cb",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "961ff154957b4846af19597e5fe3aee5",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Reizstoffspr\u00fchsystem"
                            }
                        },
                        {
                            "id": "ac4d80ae9ad14fd38a95346e6128d1c8",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "8020 - Handelsware"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "27086d61528846639a1bf42519a999e1",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "FURIE Defence Systems",
                            "0189b5bd28fd735a9afc1ef90696fc66": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "961ff154957b4846af19597e5fe3aee5",
                        "ac4d80ae9ad14fd38a95346e6128d1c8"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
                            "attr9": "{\"shipping\":null,\"quantity\":0,\"cuttedCount\":0,\"available\":0,\"deliveries\":[],\"warehouses\":[]}",
                            "releasedate": "01.10.2024",
                            "short_description": "Dieses Set ersetzt die verbrauchten Batterie-Packs in Ihrem \"FURIE Reizgas Spr\u00fchsystem\" und versorgt diese zuverl\u00e4ssig mit Energie."
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BATTERIE-SET-FURIE-B-27",
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ersatzbatterien f\u00fcr das Furie Defence Reizstoffspr\u00fchsystem. Dieses Batteriepack bestehend aus 2 Ersatzbatterien.Einfacher Austausch und Anschluss, durch verpolungssicheren Anschluss.Lieferumfang: \n\ndas Set besteht aus 2 Batterien",
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": [
                            "CS-Gas",
                            "Reizstoffspr\u00fchsystem",
                            "Furie",
                            "Cerberus",
                            "Defence",
                            "FURIE Defence Systems",
                            "Reizstoffspr\u00fchsystem",
                            "8020 - Handelsware"
                        ],
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 199.8962,
                    "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 167.98,
                    "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 153.51,
                    "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 129.0,
                    "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 153.51,
                    "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 129.0,
                    "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 136.4329,
                    "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 114.6495,
                    "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 153.51,
                    "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 129.0,
                    "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 199.8962,
                    "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 167.98,
                    "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 153.51,
                    "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 129.0,
                    "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 153.51,
                    "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 129.0,
                    "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 153.51,
                    "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 129.0,
                    "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 153.51,
                    "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 129.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 199.8962,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 167.98,
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "batterie-set-furie-b-27"
                    ],
                    "jtlorder": 0,
                    "custom_numbers": []
                },
                "fields": {
                    "displayGroup": [
                        "db5bdabdac9a771f8569ccb813fefd9b"
                    ]
                },
                "sort": [
                    0,
                    "batterie-set-furie-b-27",
                    "295f5ca6520f44e0881713ddbf508cd5"
                ]
            },
            {
                "_index": "sw_dev_product_1744118278",
                "_id": "ded21dde007f4a4e8535ebb0cd5282d5",
                "_score": null,
                "_source": {
                    "purchasePrices": [
                        {
                            "currencyId": "b7d2554b0ce847cd82f3ac9bd1c0dfca",
                            "net": 163.81,
                            "gross": 194.9339,
                            "linked": true,
                            "listPrice": null
                        }
                    ],
                    "referenceUnit": null,
                    "purchaseUnit": null,
                    "unit": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "0189b5bd28fd735a9afc1ef90696fc66": null
                        },
                        "shortCode": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "0189b5bd28fd735a9afc1ef90696fc66": null
                        },
                        "_count": 1
                    },
                    "crossSellings": [
                        {
                            "id": "f0123818e9ce40c4af3eaa31e08bb835",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shopware-CrossSelling"
                            }
                        }
                    ],
                    "keywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "CS-Gas Reizstoffspr\u00fchsystem Furie Cerberus Defence",
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "packUnit": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "packUnitPlural": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "id": "ded21dde007f4a4e8535ebb0cd5282d5",
                    "autoIncrement": 4413.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "0189b5bd293f71c6a5e92e9980f13639"
                        }
                    ],
                    "availableStock": 0,
                    "productNumber": "inert-kartusche-furie-f-750",
                    "ean": null,
                    "displayGroup": "236a999f402097498d17763a56774c26",
                    "sales": 189,
                    "stock": 0,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "27086d61528846639a1bf42519a999e1",
                    "manufacturerNumber": "INERT",
                    "releaseDate": null,
                    "createdAt": "2024-10-10T11:08:01+00:00",
                    "categoryTree": [
                        "d7b7b163000841a1876dbff5548c039f",
                        "1e866cbbceb14718b0fc586a82f9bf19",
                        "ed73937c1fc54757a390ffc31536aa0d",
                        "961ff154957b4846af19597e5fe3aee5",
                        "ac4d80ae9ad14fd38a95346e6128d1c8"
                    ],
                    "categoriesRo": [
                        {
                            "id": "d7b7b163000841a1876dbff5548c039f",
                            "_count": 1
                        },
                        {
                            "id": "1e866cbbceb14718b0fc586a82f9bf19",
                            "_count": 1
                        },
                        {
                            "id": "ed73937c1fc54757a390ffc31536aa0d",
                            "_count": 1
                        },
                        {
                            "id": "961ff154957b4846af19597e5fe3aee5",
                            "_count": 1
                        },
                        {
                            "id": "ac4d80ae9ad14fd38a95346e6128d1c8",
                            "_count": 1
                        }
                    ],
                    "taxId": "0189b5bc757f71079ecf17a5e531d81e",
                    "tags": [],
                    "parentId": null,
                    "coverId": "94e3e9cfc18d48d19f61145bdc963333",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "961ff154957b4846af19597e5fe3aee5",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Reizstoffspr\u00fchsystem"
                            }
                        },
                        {
                            "id": "ac4d80ae9ad14fd38a95346e6128d1c8",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "8020 - Handelsware"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "27086d61528846639a1bf42519a999e1",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "FURIE Defence Systems",
                            "0189b5bd28fd735a9afc1ef90696fc66": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "961ff154957b4846af19597e5fe3aee5",
                        "ac4d80ae9ad14fd38a95346e6128d1c8"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
                            "de_only": "1",
                            "attr9": "{\"shipping\":null,\"quantity\":0,\"cuttedCount\":0,\"available\":0,\"deliveries\":[],\"warehouses\":[]}",
                            "releasedate": "02.10.2024",
                            "short_description": "INERT Kartusche zur Demonstration des Systems ohne CS Gas"
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "INERT-KARTUSCHE-FURIE-F-750",
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "INERT Ersatzkartusche ohne CS-Gas. Diese Kartusche kann f\u00fcr Vorf\u00fchrungen und Testzwecke verwendet werden.Kein Wirkstoff CS Gas enthalten.\n\nTreibmittel: Unbrennbare Spr\u00fchl\u00f6sung\nInsgesamt 18 Sekunden Spr\u00fchdauer",
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": [
                            "Defence",
                            "Cerberus",
                            "Furie",
                            "Reizstoffspr\u00fchsystem",
                            "CS-Gas",
                            "FURIE Defence Systems",
                            "Reizstoffspr\u00fchsystem",
                            "8020 - Handelsware"
                        ],
                        "0189b5bd28fd735a9afc1ef90696fc66": null
                    },
                    "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 224.91,
                    "cheapest_price_rule0189b5ced55471bc878d7ccf536f4481_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 189.0,
                    "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 300.9748,
                    "cheapest_price_rule0189b5ced54472feb7f1500742eb9c93_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 252.92,
                    "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 224.91,
                    "cheapest_price_rule0189b5ced54c709a92a5564d6c63957f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 189.0,
                    "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 224.91,
                    "cheapest_price_rule0189b5ced54a70ffa7b571b9f7cc3722_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 189.0,
                    "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 224.91,
                    "cheapest_price_rule0189b5ced54672559ba6ce726fdd6127_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 189.0,
                    "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 224.91,
                    "cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 189.0,
                    "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 300.9748,
                    "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 252.92,
                    "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 224.91,
                    "cheapest_price_rule0189b5ced54272c59ee0e1176d63077b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 189.0,
                    "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 204.6806,
                    "cheapest_price_rule0189b5ced53f726c904fe4f578316c00_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 172.0005,
                    "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 224.91,
                    "cheapest_price_rule0189b5ced548730cade93f3c834a4a12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 189.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 300.9748,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 252.92,
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "inert-kartusche-furie-f-750"
                    ],
                    "jtlorder": 0,
                    "custom_numbers": []
                },
                "fields": {
                    "displayGroup": [
                        "236a999f402097498d17763a56774c26"
                    ]
                },
                "sort": [
                    0,
                    "inert-kartusche-furie-f-750",
                    "ded21dde007f4a4e8535ebb0cd5282d5"
                ]
            }
        ]
    },
    "aggregations": {
        "total-filtered-count": {
            "doc_count": 5,
            "total-count": {
                "value": 5
            }
        }
    }
}

Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search

3.09 ms

Request:

{"index":"sw_dev_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"0189b5bd293f71c6a5e92e9980f13639"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"961ff154957b4846af19597e5fe3aee5"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}},{"bool":{"must_not":[{"bool":{"must":[{"term":{"isCloseout":true}},{"term":{"available":false}}]}}]}}]}}]}},"aggregations":{"manufacturer":{"terms":{"field":"manufacturerId","size":10000}},"price":{"stats":{"script":{"source":"double getPrice(def accessors, def doc, def decimals, def round, def multiplier) {\n    for (accessor in accessors) {\n        def key = accessor['key'];\n\n        if (!doc.containsKey(key) || doc[key].empty) {\n            continue;\n        }\n\n        def factor = accessor['factor'];\n        def value = doc[key].value * factor;\n\n        value = Math.round(value * decimals);\n        value = (double) value \/ decimals;\n\n        if (!round) {\n            return (double) value;\n        }\n\n        value = Math.round(value * multiplier);\n\n        value = (double) value \/ multiplier;\n\n        return (double) value;\n    }\n\n    return 0;\n}\n\nreturn getPrice(params['accessors'], doc, params['decimals'], params['round'], params['multiplier']);\n","lang":"painless","params":{"accessors":[{"key":"cheapest_price_rule471f2ca5e74440568ba57912bb0f3d50_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc757970f38af8d735ac2bef24_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc757d738cb8f62b8ca13162fd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc781372e48ae25e3fc49e6c75_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5c9aba570cdb1eb3cecd2cd9c14_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5c9abd170d5a439e74a4020e81c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule018c7cebb95d7085930868a24624ed56_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc758c718ca89324f9e3bbcdfd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5c9ab9b73b8b6ca8da792e44880_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1}],"decimals":100,"round":true,"multiplier":100.0}}}},"rating-exists":{"filter":{"range":{"ratingAverage":{"gte":0.0}}},"aggregations":{"rating":{"max":{"field":"ratingAverage"}}}},"shipping-free-filter":{"filter":{"term":{"shippingFree":true}},"aggregations":{"shipping-free":{"max":{"field":"shippingFree"}}}},"properties":{"nested":{"path":"properties"},"aggregations":{"properties":{"terms":{"field":"properties.id","size":10000}}}},"options":{"nested":{"path":"options"},"aggregations":{"options":{"terms":{"field":"options.id","size":10000}}}},"manufacturer_count":{"terms":{"field":"manufacturerId","size":10000}},"propertiesCount":{"terms":{"field":"propertyIds","size":10000}},"immediately-available-filter":{"max":{"field":"availableStock"}}},"size":0,"timeout":"5s"},"search_type":"query_then_fetch"}

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


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

        {
    "query": {
        "bool": {
            "filter": [
                {
                    "bool": {
                        "must": [
                            {
                                "bool": {
                                    "must": [
                                        {
                                            "nested": {
                                                "path": "visibilities",
                                                "query": {
                                                    "bool": {
                                                        "must": [
                                                            {
                                                                "range": {
                                                                    "visibilities.visibility": {
                                                                        "gte": 30
                                                                    }
                                                                }
                                                            },
                                                            {
                                                                "term": {
                                                                    "visibilities.salesChannelId": "0189b5bd293f71c6a5e92e9980f13639"
                                                                }
                                                            }
                                                        ]
                                                    }
                                                }
                                            }
                                        },
                                        {
                                            "term": {
                                                "active": true
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "nested": {
                                    "path": "categoriesRo",
                                    "query": {
                                        "term": {
                                            "categoriesRo.id": "961ff154957b4846af19597e5fe3aee5"
                                        }
                                    }
                                }
                            },
                            {
                                "bool": {
                                    "must_not": [
                                        {
                                            "bool": {
                                                "must_not": [
                                                    {
                                                        "exists": {
                                                            "field": "displayGroup"
                                                        }
                                                    }
                                                ]
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "bool": {
                                    "must_not": [
                                        {
                                            "bool": {
                                                "must": [
                                                    {
                                                        "term": {
                                                            "isCloseout": true
                                                        }
                                                    },
                                                    {
                                                        "term": {
                                                            "available": false
                                                        }
                                                    }
                                                ]
                                            }
                                        }
                                    ]
                                }
                            }
                        ]
                    }
                }
            ]
        }
    },
    "aggregations": {
        "manufacturer": {
            "terms": {
                "field": "manufacturerId",
                "size": 10000
            }
        },
        "price": {
            "stats": {
                "script": {
                    "source": "double getPrice(def accessors, def doc, def decimals, def round, def multiplier) {\n    for (accessor in accessors) {\n        def key = accessor['key'];\n\n        if (!doc.containsKey(key) || doc[key].empty) {\n            continue;\n        }\n\n        def factor = accessor['factor'];\n        def value = doc[key].value * factor;\n\n        value = Math.round(value * decimals);\n        value = (double) value \/ decimals;\n\n        if (!round) {\n            return (double) value;\n        }\n\n        value = Math.round(value * multiplier);\n\n        value = (double) value \/ multiplier;\n\n        return (double) value;\n    }\n\n    return 0;\n}\n\nreturn getPrice(params['accessors'], doc, params['decimals'], params['round'], params['multiplier']);\n",
                    "lang": "painless",
                    "params": {
                        "accessors": [
                            {
                                "key": "cheapest_price_rule471f2ca5e74440568ba57912bb0f3d50_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0189b5bc757970f38af8d735ac2bef24_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0189b5bc757d738cb8f62b8ca13162fd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0189b5bc781372e48ae25e3fc49e6c75_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0189b5c9aba570cdb1eb3cecd2cd9c14_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0189b5c9abd170d5a439e74a4020e81c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule018c7cebb95d7085930868a24624ed56_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0189b5bc758c718ca89324f9e3bbcdfd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0189b5c9ab9b73b8b6ca8da792e44880_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0189b5ced52c716da0b413088634748f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            }
                        ],
                        "decimals": 100,
                        "round": true,
                        "multiplier": 100.0
                    }
                }
            }
        },
        "rating-exists": {
            "filter": {
                "range": {
                    "ratingAverage": {
                        "gte": 0.0
                    }
                }
            },
            "aggregations": {
                "rating": {
                    "max": {
                        "field": "ratingAverage"
                    }
                }
            }
        },
        "shipping-free-filter": {
            "filter": {
                "term": {
                    "shippingFree": true
                }
            },
            "aggregations": {
                "shipping-free": {
                    "max": {
                        "field": "shippingFree"
                    }
                }
            }
        },
        "properties": {
            "nested": {
                "path": "properties"
            },
            "aggregations": {
                "properties": {
                    "terms": {
                        "field": "properties.id",
                        "size": 10000
                    }
                }
            }
        },
        "options": {
            "nested": {
                "path": "options"
            },
            "aggregations": {
                "options": {
                    "terms": {
                        "field": "options.id",
                        "size": 10000
                    }
                }
            }
        },
        "manufacturer_count": {
            "terms": {
                "field": "manufacturerId",
                "size": 10000
            }
        },
        "propertiesCount": {
            "terms": {
                "field": "propertyIds",
                "size": 10000
            }
        },
        "immediately-available-filter": {
            "max": {
                "field": "availableStock"
            }
        }
    },
    "size": 0,
    "timeout": "5s"
}


                                    {
    "took": 1,
    "timed_out": false,
    "_shards": {
        "total": 3,
        "successful": 3,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "max_score": null,
        "hits": []
    },
    "aggregations": {
        "manufacturer_count": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
                {
                    "key": "27086d61528846639a1bf42519a999e1",
                    "doc_count": 5
                }
            ]
        },
        "shipping-free-filter": {
            "doc_count": 0,
            "shipping-free": {
                "value": null
            }
        },
        "propertiesCount": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": []
        },
        "rating-exists": {
            "doc_count": 5,
            "rating": {
                "value": 5.0
            }
        },
        "price": {
            "count": 5,
            "min": 99.0,
            "max": 2100.0,
            "avg": 574.5640000000001,
            "sum": 2872.82
        },
        "immediately-available-filter": {
            "value": 4.0
        },
        "options": {
            "doc_count": 0,
            "options": {
                "doc_count_error_upper_bound": 0,
                "sum_other_doc_count": 0,
                "buckets": []
            }
        },
        "properties": {
            "doc_count": 0,
            "properties": {
                "doc_count_error_upper_bound": 0,
                "sum_other_doc_count": 0,
                "buckets": []
            }
        },
        "manufacturer": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
                {
                    "key": "27086d61528846639a1bf42519a999e1",
                    "doc_count": 5
                }
            ]
        }
    }
}

Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate

Cluster Status

{
    "cluster_name": "shopware",
    "status": "yellow",
    "timed_out": false,
    "number_of_nodes": 1,
    "number_of_data_nodes": 1,
    "discovered_master": true,
    "discovered_cluster_manager": true,
    "active_primary_shards": 152,
    "active_shards": 152,
    "relocating_shards": 0,
    "initializing_shards": 0,
    "unassigned_shards": 173,
    "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": 46.76923076923077
}

Indices

Name▲	Status	Replication (pri, rep)	Doc Count
top_queries-2025.05.12-81245	open	1, 0	775
security-auditlog-2025.03.01	open	1, 1	158
.ql-datasources	open	1, 0	0
security-auditlog-2025.03.02	open	1, 1	234
security-auditlog-2025.03.05	open	1, 1	259
security-auditlog-2025.03.06	open	1, 1	914
security-auditlog-2025.03.03	open	1, 1	287
security-auditlog-2025.03.04	open	1, 1	446
security-auditlog-2025.03.09	open	1, 1	235
.opendistro_security	open	1, 0	10
security-auditlog-2025.03.07	open	1, 1	215
security-auditlog-2025.03.08	open	1, 1	100
security-auditlog-2025.03.12	open	1, 1	393
security-auditlog-2025.03.13	open	1, 1	233
security-auditlog-2025.03.10	open	1, 1	471
.kibana_92668751_admin_1	open	1, 0	1
security-auditlog-2025.03.11	open	1, 1	163
security-auditlog-2025.03.16	open	1, 1	243
security-auditlog-2025.03.17	open	1, 1	378
security-auditlog-2025.03.14	open	1, 1	214
security-auditlog-2025.03.15	open	1, 1	487
security-auditlog-2025.03.18	open	1, 1	243
security-auditlog-2025.03.19	open	1, 1	183
sw6_fr_product_manufacturer_1746284168	open	3, 3	0
security-auditlog-2025.04.30	open	1, 1	23090
top_queries-2025.05.10-81243	open	1, 0	1861
security-auditlog-2025.02.10	open	1, 1	213
security-auditlog-2025.05.04	open	1, 1	1791
security-auditlog-2025.05.03	open	1, 1	1987
security-auditlog-2025.05.02	open	1, 1	13264
security-auditlog-2025.02.12	open	1, 1	158
security-auditlog-2025.02.11	open	1, 1	193
security-auditlog-2025.05.01	open	1, 1	2574
security-auditlog-2025.02.14	open	1, 1	231
security-auditlog-2025.05.08	open	1, 1	18383
security-auditlog-2025.02.13	open	1, 1	135
security-auditlog-2025.05.07	open	1, 1	14573
security-auditlog-2025.02.16	open	1, 1	78
security-auditlog-2025.05.06	open	1, 1	17560
security-auditlog-2025.05.05	open	1, 1	24810
security-auditlog-2025.02.15	open	1, 1	57
security-auditlog-2025.02.18	open	1, 1	74
security-auditlog-2025.02.17	open	1, 1	205
security-auditlog-2025.05.09	open	1, 1	14447
security-auditlog-2025.02.19	open	1, 1	186
top_queries-2025.05.05-81217	open	1, 0	1503
security-auditlog-2025.05.11	open	1, 1	2293
security-auditlog-2025.05.10	open	1, 1	1592
security-auditlog-2025.02.21	open	1, 1	208
security-auditlog-2025.02.20	open	1, 1	251
security-auditlog-2025.02.23	open	1, 1	96
security-auditlog-2025.02.22	open	1, 1	611
security-auditlog-2025.05.12	open	1, 1	22925
security-auditlog-2025.02.25	open	1, 1	125
security-auditlog-2025.02.24	open	1, 1	267
security-auditlog-2025.02.27	open	1, 1	205
security-auditlog-2025.02.26	open	1, 1	295
security-auditlog-2025.02.28	open	1, 1	321
top_queries-2025.05.06-81218	open	1, 0	1748
security-auditlog-2025.04.10	open	1, 1	44590
security-auditlog-2025.04.13	open	1, 1	1642
security-auditlog-2025.01.20	open	1, 1	125
security-auditlog-2025.04.14	open	1, 1	16957
security-auditlog-2025.01.22	open	1, 1	300
security-auditlog-2025.04.11	open	1, 1	17577
security-auditlog-2025.01.21	open	1, 1	396
security-auditlog-2025.04.12	open	1, 1	789
security-auditlog-2025.04.17	open	1, 1	14210
security-auditlog-2025.01.24	open	1, 1	235
security-auditlog-2025.04.18	open	1, 1	1819
security-auditlog-2025.01.23	open	1, 1	1641
security-auditlog-2025.04.15	open	1, 1	21714
security-auditlog-2025.01.26	open	1, 1	91
security-auditlog-2025.01.25	open	1, 1	83
security-auditlog-2025.04.16	open	1, 1	14966
security-auditlog-2025.01.28	open	1, 1	98
security-auditlog-2025.01.27	open	1, 1	164
security-auditlog-2025.04.19	open	1, 1	1309
security-auditlog-2025.01.29	open	1, 1	98
.opensearch-observability	open	1, 0	0
top_queries-2025.05.07-81219	open	1, 0	2200
top_queries-2025.05.11-81244	open	1, 0	1609
security-auditlog-2025.04.20	open	1, 1	800
security-auditlog-2025.04.21	open	1, 1	2399
security-auditlog-2025.04.24	open	1, 1	19635
security-auditlog-2025.01.31	open	1, 1	209
sw_dev_category_1744118278	open	3, 3	1
security-auditlog-2025.01.30	open	1, 1	118
security-auditlog-2025.04.25	open	1, 1	14507
security-auditlog-2025.04.22	open	1, 1	23345
security-auditlog-2025.02.01	open	1, 1	697
security-auditlog-2025.04.23	open	1, 1	41795
security-auditlog-2025.02.03	open	1, 1	489
security-auditlog-2025.04.28	open	1, 1	14984
security-auditlog-2025.04.29	open	1, 1	18696
security-auditlog-2025.02.02	open	1, 1	326
security-auditlog-2025.04.26	open	1, 1	1524
security-auditlog-2025.02.05	open	1, 1	200
sw_dev_product_1744118278	open	3, 3	81016
security-auditlog-2025.02.04	open	1, 1	69
security-auditlog-2025.04.27	open	1, 1	1757
security-auditlog-2025.02.07	open	1, 1	95
security-auditlog-2025.02.06	open	1, 1	113
security-auditlog-2025.02.09	open	1, 1	91
security-auditlog-2025.02.08	open	1, 1	142
sw6_fr_product_1746284168	open	3, 3	83493
security-auditlog-2025.03.20	open	1, 1	477
security-auditlog-2025.03.23	open	1, 1	388
security-auditlog-2025.03.24	open	1, 1	556
security-auditlog-2025.03.21	open	1, 1	203
security-auditlog-2025.03.22	open	1, 1	370
security-auditlog-2025.03.27	open	1, 1	598
security-auditlog-2025.03.28	open	1, 1	244
security-auditlog-2025.03.25	open	1, 1	574
security-auditlog-2025.03.26	open	1, 1	527
top_queries-2025.05.09-81221	open	1, 0	2352
sw6_fr_category_1746284168	open	3, 3	43
security-auditlog-2025.03.29	open	1, 1	360
top_queries-2025.05.08-81220	open	1, 0	2107
security-auditlog-2025.03.30	open	1, 1	622
security-auditlog-2025.03.31	open	1, 1	505
security-auditlog-2025.04.02	open	1, 1	388
security-auditlog-2025.04.03	open	1, 1	523
security-auditlog-2025.04.01	open	1, 1	447
security-auditlog-2025.04.06	open	1, 1	1393
security-auditlog-2025.04.07	open	1, 1	16875
security-auditlog-2025.01.15	open	1, 1	187
security-auditlog-2025.04.04	open	1, 1	3437
security-auditlog-2025.04.05	open	1, 1	1658
security-auditlog-2025.01.14	open	1, 1	122
security-auditlog-2025.01.17	open	1, 1	77
security-auditlog-2025.01.16	open	1, 1	356
.kibana_1	open	1, 0	0
security-auditlog-2025.04.08	open	1, 1	23447
security-auditlog-2025.01.19	open	1, 1	49
security-auditlog-2025.01.18	open	1, 1	248
security-auditlog-2025.04.09	open	1, 1	18794
.plugins-ml-config	open	1, 0	1
sw_dev_product_manufacturer_1744118278	open	3, 3	0

Symfony Profiler

GET https://shopware6.eps-dev.com/navigation/961ff154957b4846af19597e5fe3aee5

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Cluster Status

Indices