| 1 |
40.25 ms |
Request:
{"index":"sw_product","search_type":"query_then_fetch","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"018c441a15d77028a057088b5c4e9b69"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"0190307963627d0e9b414d038fd396fe"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}},{"bool":{"should":[{"bool":{"must":[{"nested":{"path":"parent.swagDynamicAccessRules","query":{"terms":{"parent.swagDynamicAccessRules.id":["018c4418fa6b70e69206501ca305a339","018c4418fab27100942169d9f4f972b5","018c4418fb697089b4105d454ff53c36","018c44192de470828312e8074b88e33e","0195a39cac8f7184b89d79acff8b5c7c","0192b8ddb4ee76a3ac6b82e3b8d43e6d","0192b98b93437a7aa639ab0dff2c5408","0192f669841276bf991799df8ff204df","0194a7fbc80971d8a909a66ed475575c","0194a836ec8c70afb734c53018ddab65","0194a83a2012708b9e41108a5c98cdae","0194a83dc1a274fd85d8ad67417f3024","0194a83e7ee97910a4fa1a67902198ff","0194a83ee6377cdab21b148d34b4d6c9","0194a83f8aa577429ab84305c276cc83","0194a8403f497262880a4c79ade66e2b","0194a840e033727fbaf8c7580054a815","0194a841bad97a51832d50e9f0b77cfb","0194a842419174ddb8c93930e9034281","0194a843103f704e9b4eb8f7466e24fd","0194a84393b27d1db64cb9af1436bf8e","0194a844bd9d7acd894d13f0a10afbb8","0194a8458ec07277bfe9dde7be03269f","0194a84610807c428badf27c745d237a","0194a8347d7373a2936d1e3532c1016c","018c4418fb6471e89cd37d82a7ef7bf5","0194937b525c7a238da1b92ee06c4aa1"]}}}},{"nested":{"path":"swagDynamicAccessRules","query":{"bool":{"must_not":[{"exists":{"field":"swagDynamicAccessRules.id"}}]}}}}]}},{"nested":{"path":"swagDynamicAccessRules","query":{"terms":{"swagDynamicAccessRules.id":["018c4418fa6b70e69206501ca305a339","018c4418fab27100942169d9f4f972b5","018c4418fb697089b4105d454ff53c36","018c44192de470828312e8074b88e33e","0195a39cac8f7184b89d79acff8b5c7c","0192b8ddb4ee76a3ac6b82e3b8d43e6d","0192b98b93437a7aa639ab0dff2c5408","0192f669841276bf991799df8ff204df","0194a7fbc80971d8a909a66ed475575c","0194a836ec8c70afb734c53018ddab65","0194a83a2012708b9e41108a5c98cdae","0194a83dc1a274fd85d8ad67417f3024","0194a83e7ee97910a4fa1a67902198ff","0194a83ee6377cdab21b148d34b4d6c9","0194a83f8aa577429ab84305c276cc83","0194a8403f497262880a4c79ade66e2b","0194a840e033727fbaf8c7580054a815","0194a841bad97a51832d50e9f0b77cfb","0194a842419174ddb8c93930e9034281","0194a843103f704e9b4eb8f7466e24fd","0194a84393b27d1db64cb9af1436bf8e","0194a844bd9d7acd894d13f0a10afbb8","0194a8458ec07277bfe9dde7be03269f","0194a84610807c428badf27c745d237a","0194a8347d7373a2936d1e3532c1016c","018c4418fb6471e89cd37d82a7ef7bf5","0194937b525c7a238da1b92ee06c4aa1"]}}}},{"bool":{"must":[{"nested":{"path":"parent.swagDynamicAccessRules","query":{"bool":{"must_not":[{"exists":{"field":"parent.swagDynamicAccessRules.id"}}]}}}},{"nested":{"path":"swagDynamicAccessRules","query":{"bool":{"must_not":[{"exists":{"field":"swagDynamicAccessRules.id"}}]}}}}]}}]}}]}}]}},"sort":[{"_script":{"type":"number","script":{"source":"def languages = params['languages'];\ndef suffix = params.containsKey('suffix') ? '.' + params['suffix'] : '';\n\nfor (int i = 0; i < languages.length; i++) {\n def field_name = params['field'] + '.' + languages[i] + suffix;\n\n if (doc[field_name].size() > 0 && doc[field_name].value != null && doc[field_name].value.toString().length() > 0) {\n def fieldValue = doc[field_name].value;\n\n return fieldValue;\n }\n}\n\nif (params['order'] == 'asc') {\n return Double.MAX_VALUE;\n}\n\nreturn Double.MIN_VALUE;\n","lang":"painless","params":{"field":"customFields","languages":["018dcfe1c522789e871b753174b3b10f","018c441a028a73d09246e628782bdd72","2fbb5fe2e29a4d70aa5854ce7ce3e20b"],"suffix":"custom_sorting","order":"desc"}},"order":"DESC"}},{"sales":{"order":"DESC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":9,"collapse":{"field":"displayGroup"},"timeout":"5s"}}
POST https://10.10.1.5:9200/sw_product/_search?search_type=query_then_fetch&track_total_hits=1
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": "018c441a15d77028a057088b5c4e9b69"
}
}
]
}
}
}
},
{
"term": {
"active": true
}
}
]
}
},
{
"nested": {
"path": "categoriesRo",
"query": {
"term": {
"categoriesRo.id": "0190307963627d0e9b414d038fd396fe"
}
}
}
},
{
"bool": {
"must_not": [
{
"bool": {
"must_not": [
{
"exists": {
"field": "displayGroup"
}
}
]
}
}
]
}
},
{
"bool": {
"should": [
{
"bool": {
"must": [
{
"nested": {
"path": "parent.swagDynamicAccessRules",
"query": {
"terms": {
"parent.swagDynamicAccessRules.id": [
"018c4418fa6b70e69206501ca305a339",
"018c4418fab27100942169d9f4f972b5",
"018c4418fb697089b4105d454ff53c36",
"018c44192de470828312e8074b88e33e",
"0195a39cac8f7184b89d79acff8b5c7c",
"0192b8ddb4ee76a3ac6b82e3b8d43e6d",
"0192b98b93437a7aa639ab0dff2c5408",
"0192f669841276bf991799df8ff204df",
"0194a7fbc80971d8a909a66ed475575c",
"0194a836ec8c70afb734c53018ddab65",
"0194a83a2012708b9e41108a5c98cdae",
"0194a83dc1a274fd85d8ad67417f3024",
"0194a83e7ee97910a4fa1a67902198ff",
"0194a83ee6377cdab21b148d34b4d6c9",
"0194a83f8aa577429ab84305c276cc83",
"0194a8403f497262880a4c79ade66e2b",
"0194a840e033727fbaf8c7580054a815",
"0194a841bad97a51832d50e9f0b77cfb",
"0194a842419174ddb8c93930e9034281",
"0194a843103f704e9b4eb8f7466e24fd",
"0194a84393b27d1db64cb9af1436bf8e",
"0194a844bd9d7acd894d13f0a10afbb8",
"0194a8458ec07277bfe9dde7be03269f",
"0194a84610807c428badf27c745d237a",
"0194a8347d7373a2936d1e3532c1016c",
"018c4418fb6471e89cd37d82a7ef7bf5",
"0194937b525c7a238da1b92ee06c4aa1"
]
}
}
}
},
{
"nested": {
"path": "swagDynamicAccessRules",
"query": {
"bool": {
"must_not": [
{
"exists": {
"field": "swagDynamicAccessRules.id"
}
}
]
}
}
}
}
]
}
},
{
"nested": {
"path": "swagDynamicAccessRules",
"query": {
"terms": {
"swagDynamicAccessRules.id": [
"018c4418fa6b70e69206501ca305a339",
"018c4418fab27100942169d9f4f972b5",
"018c4418fb697089b4105d454ff53c36",
"018c44192de470828312e8074b88e33e",
"0195a39cac8f7184b89d79acff8b5c7c",
"0192b8ddb4ee76a3ac6b82e3b8d43e6d",
"0192b98b93437a7aa639ab0dff2c5408",
"0192f669841276bf991799df8ff204df",
"0194a7fbc80971d8a909a66ed475575c",
"0194a836ec8c70afb734c53018ddab65",
"0194a83a2012708b9e41108a5c98cdae",
"0194a83dc1a274fd85d8ad67417f3024",
"0194a83e7ee97910a4fa1a67902198ff",
"0194a83ee6377cdab21b148d34b4d6c9",
"0194a83f8aa577429ab84305c276cc83",
"0194a8403f497262880a4c79ade66e2b",
"0194a840e033727fbaf8c7580054a815",
"0194a841bad97a51832d50e9f0b77cfb",
"0194a842419174ddb8c93930e9034281",
"0194a843103f704e9b4eb8f7466e24fd",
"0194a84393b27d1db64cb9af1436bf8e",
"0194a844bd9d7acd894d13f0a10afbb8",
"0194a8458ec07277bfe9dde7be03269f",
"0194a84610807c428badf27c745d237a",
"0194a8347d7373a2936d1e3532c1016c",
"018c4418fb6471e89cd37d82a7ef7bf5",
"0194937b525c7a238da1b92ee06c4aa1"
]
}
}
}
},
{
"bool": {
"must": [
{
"nested": {
"path": "parent.swagDynamicAccessRules",
"query": {
"bool": {
"must_not": [
{
"exists": {
"field": "parent.swagDynamicAccessRules.id"
}
}
]
}
}
}
},
{
"nested": {
"path": "swagDynamicAccessRules",
"query": {
"bool": {
"must_not": [
{
"exists": {
"field": "swagDynamicAccessRules.id"
}
}
]
}
}
}
}
]
}
}
]
}
}
]
}
}
]
}
},
"sort": [
{
"_script": {
"type": "number",
"script": {
"source": "def languages = params['languages'];\ndef suffix = params.containsKey('suffix') ? '.' + params['suffix'] : '';\n\nfor (int i = 0; i < languages.length; i++) {\n def field_name = params['field'] + '.' + languages[i] + suffix;\n\n if (doc[field_name].size() > 0 && doc[field_name].value != null && doc[field_name].value.toString().length() > 0) {\n def fieldValue = doc[field_name].value;\n\n return fieldValue;\n }\n}\n\nif (params['order'] == 'asc') {\n return Double.MAX_VALUE;\n}\n\nreturn Double.MIN_VALUE;\n",
"lang": "painless",
"params": {
"field": "customFields",
"languages": [
"018dcfe1c522789e871b753174b3b10f",
"018c441a028a73d09246e628782bdd72",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b"
],
"suffix": "custom_sorting",
"order": "desc"
}
},
"order": "DESC"
}
},
{
"sales": {
"order": "DESC"
}
},
{
"id": {
"order": "ASC"
}
}
],
"aggregations": {
"total-count": {
"cardinality": {
"field": "displayGroup"
}
}
},
"from": 0,
"size": 9,
"collapse": {
"field": "displayGroup"
},
"timeout": "5s"
}
{
"took": 12,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 2,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_product_1772854806",
"_id": "0194a9963145700c8f5ff57c0a7acaac",
"_score": null,
"_source": {
"purchasePrices": [],
"referenceUnit": null,
"purchaseUnit": null,
"unit": {
"id": null,
"name": {
"018c441a028a73d09246e628782bdd72": null,
"018dcfdcc7527afda4d7e8943c89a90b": null,
"018dcfdf67ff7019ae54528e014b46c3": null,
"018dcfe159447f0babc72dd985fa25ba": null,
"018dcfe1c522789e871b753174b3b10f": null,
"018dcfe3b2ed7b778b19a53ab0f38fdd": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"shortCode": {
"018c441a028a73d09246e628782bdd72": null,
"018dcfdcc7527afda4d7e8943c89a90b": null,
"018dcfdf67ff7019ae54528e014b46c3": null,
"018dcfe159447f0babc72dd985fa25ba": null,
"018dcfe1c522789e871b753174b3b10f": null,
"018dcfe3b2ed7b778b19a53ab0f38fdd": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"_count": 1
},
"crossSellings": [
{
"id": "019c3ba0075070d78c63270909f0012e",
"_count": 1,
"name": {
"018dcfe3b2ed7b778b19a53ab0f38fdd": "\u66ff\u4ee3\u4ea7\u54c1",
"018c441a028a73d09246e628782bdd72": "Alternate products",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Alternative Produkte",
"018dcfe159447f0babc72dd985fa25ba": "Prodotti alternativi",
"018dcfdcc7527afda4d7e8943c89a90b": "Produits alternatifs",
"018dcfe1c522789e871b753174b3b10f": "Alternatieve producten",
"018dcfdf67ff7019ae54528e014b46c3": "Productos alternativos"
}
}
],
"keywords": {
"018c441a028a73d09246e628782bdd72": null,
"018dcfdcc7527afda4d7e8943c89a90b": null,
"018dcfdf67ff7019ae54528e014b46c3": null,
"018dcfe159447f0babc72dd985fa25ba": null,
"018dcfe1c522789e871b753174b3b10f": null,
"018dcfe3b2ed7b778b19a53ab0f38fdd": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"packUnit": {
"018c441a028a73d09246e628782bdd72": null,
"018dcfdcc7527afda4d7e8943c89a90b": null,
"018dcfdf67ff7019ae54528e014b46c3": null,
"018dcfe159447f0babc72dd985fa25ba": null,
"018dcfe1c522789e871b753174b3b10f": null,
"018dcfe3b2ed7b778b19a53ab0f38fdd": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"packUnitPlural": {
"018c441a028a73d09246e628782bdd72": null,
"018dcfdcc7527afda4d7e8943c89a90b": null,
"018dcfdf67ff7019ae54528e014b46c3": null,
"018dcfe159447f0babc72dd985fa25ba": null,
"018dcfe1c522789e871b753174b3b10f": null,
"018dcfe3b2ed7b778b19a53ab0f38fdd": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"id": "0194a9963145700c8f5ff57c0a7acaac",
"autoIncrement": 11124.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "018c441a15d77028a057088b5c4e9b69"
},
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01973639e563769bb536d5292ce01244"
}
],
"availableStock": 261,
"productNumber": "91405255",
"ean": null,
"displayGroup": "c64bdb353e2b5f9642d4cc2807eaaae4",
"sales": 0,
"stock": 261,
"weight": 1.501,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": null,
"manufacturerNumber": null,
"deliveryTimeId": null,
"releaseDate": null,
"createdAt": "2025-01-27T21:06:28+00:00",
"categoryTree": [
"018c4418fadb72bbb85ab38170d20f0f",
"018d83d4b50c7396bf732bc84482dde6",
"018fa4706f627d0e8809d6fe0026dd6a",
"01903075cde877b9b9bf4fd8a85cb967",
"0190307963627d0e9b414d038fd396fe"
],
"categoriesRo": [
{
"id": "018c4418fadb72bbb85ab38170d20f0f",
"_count": 1
},
{
"id": "018d83d4b50c7396bf732bc84482dde6",
"_count": 1
},
{
"id": "018fa4706f627d0e8809d6fe0026dd6a",
"_count": 1
},
{
"id": "01903075cde877b9b9bf4fd8a85cb967",
"_count": 1
},
{
"id": "0190307963627d0e9b414d038fd396fe",
"_count": 1
}
],
"taxId": "018c4418fad37041a0e90672f2cf1d8e",
"tags": [],
"parentId": "0194a996231e73cf99442d9037638d77",
"coverId": "0194a9e45f2073a5b16b28d1f458b892",
"childCount": 0,
"categories": [
{
"id": "0190307963627d0e9b414d038fd396fe",
"_count": 1,
"name": {
"018c441a028a73d09246e628782bdd72": "Alarm Bell Listing",
"018dcfdcc7527afda4d7e8943c89a90b": "Sonnerie d\u2019alarme Listing",
"018dcfdf67ff7019ae54528e014b46c3": "Campana de alarma Listing",
"018dcfe159447f0babc72dd985fa25ba": "Suoneria Listing",
"018dcfe1c522789e871b753174b3b10f": "Alarmbel Listing",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "\u8b66\u62a5\u94c3 Listing",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "L\u00e4utewerk Listing "
}
}
],
"manufacturer": {
"id": null,
"name": {
"018c441a028a73d09246e628782bdd72": null,
"018dcfdcc7527afda4d7e8943c89a90b": null,
"018dcfdf67ff7019ae54528e014b46c3": null,
"018dcfe159447f0babc72dd985fa25ba": null,
"018dcfe1c522789e871b753174b3b10f": null,
"018dcfe3b2ed7b778b19a53ab0f38fdd": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"_count": 1
},
"deliveryTime": {
"id": null,
"name": {
"018c441a028a73d09246e628782bdd72": null,
"018dcfdcc7527afda4d7e8943c89a90b": null,
"018dcfdf67ff7019ae54528e014b46c3": null,
"018dcfe159447f0babc72dd985fa25ba": null,
"018dcfe1c522789e871b753174b3b10f": null,
"018dcfe3b2ed7b778b19a53ab0f38fdd": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"_count": 1
},
"properties": [
{
"id": "0193a87190f471e3aca5ddd1a5d12030",
"_count": 1,
"groupId": "0193a8718fbd72539ef3a00ec205c5ef",
"group": {
"id": "0193a8718fbd72539ef3a00ec205c5ef",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ja",
"018c441a028a73d09246e628782bdd72": "Yes",
"018dcfdcc7527afda4d7e8943c89a90b": "Yes",
"018dcfdf67ff7019ae54528e014b46c3": "Yes",
"018dcfe159447f0babc72dd985fa25ba": "Yes",
"018dcfe1c522789e871b753174b3b10f": "Yes",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "Yes"
}
},
{
"id": "0193a8719107713387d0dcb2f21bfdde",
"_count": 1,
"groupId": "0193a87190fd717abc49700486891b20",
"group": {
"id": "0193a87190fd717abc49700486891b20",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ja",
"018c441a028a73d09246e628782bdd72": "Yes",
"018dcfdcc7527afda4d7e8943c89a90b": "Yes",
"018dcfdf67ff7019ae54528e014b46c3": "Yes",
"018dcfe159447f0babc72dd985fa25ba": "Yes",
"018dcfe1c522789e871b753174b3b10f": "Yes",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "Yes"
}
},
{
"id": "0193a8719127736cb59d64cc1b877f30",
"_count": 1,
"groupId": "0193a871911f70d68c9077891f5e5b8d",
"group": {
"id": "0193a871911f70d68c9077891f5e5b8d",
"_count": 1
},
"name": {
"018c441a028a73d09246e628782bdd72": "No",
"018dcfdcc7527afda4d7e8943c89a90b": "No",
"018dcfdf67ff7019ae54528e014b46c3": "No",
"018dcfe159447f0babc72dd985fa25ba": "No",
"018dcfe1c522789e871b753174b3b10f": "No",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "No",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nein"
}
},
{
"id": "0193a8719138723f9f2813b3e9b2f6db",
"_count": 1,
"groupId": "0193a871912f706b9a62f3d78fd9dcc7",
"group": {
"id": "0193a871912f706b9a62f3d78fd9dcc7",
"_count": 1
},
"name": {
"018c441a028a73d09246e628782bdd72": "No",
"018dcfdcc7527afda4d7e8943c89a90b": "No",
"018dcfdf67ff7019ae54528e014b46c3": "No",
"018dcfe159447f0babc72dd985fa25ba": "No",
"018dcfe1c522789e871b753174b3b10f": "No",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "No",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nein"
}
},
{
"id": "0193a871916e73749120ef91e33e0eeb",
"_count": 1,
"groupId": "0193a871916572f6885055b69563c6e7",
"group": {
"id": "0193a871916572f6885055b69563c6e7",
"_count": 1
},
"name": {
"018c441a028a73d09246e628782bdd72": "No",
"018dcfdcc7527afda4d7e8943c89a90b": "No",
"018dcfdf67ff7019ae54528e014b46c3": "No",
"018dcfe159447f0babc72dd985fa25ba": "No",
"018dcfe1c522789e871b753174b3b10f": "No",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "No",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nein"
}
},
{
"id": "0193a87191b172708180a489b94f87df",
"_count": 1,
"groupId": "0193a87191a973dabe06909614c7a963",
"group": {
"id": "0193a87191a973dabe06909614c7a963",
"_count": 1
},
"name": {
"018c441a028a73d09246e628782bdd72": "No",
"018dcfdcc7527afda4d7e8943c89a90b": "No",
"018dcfdf67ff7019ae54528e014b46c3": "No",
"018dcfe159447f0babc72dd985fa25ba": "No",
"018dcfe1c522789e871b753174b3b10f": "No",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "No",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nein"
}
},
{
"id": "0193a87191c2709292a220a65531a4d8",
"_count": 1,
"groupId": "0193a87191b971879036aec175c33a1e",
"group": {
"id": "0193a87191b971879036aec175c33a1e",
"_count": 1
},
"name": {
"018c441a028a73d09246e628782bdd72": "No",
"018dcfdcc7527afda4d7e8943c89a90b": "No",
"018dcfdf67ff7019ae54528e014b46c3": "No",
"018dcfe159447f0babc72dd985fa25ba": "No",
"018dcfe1c522789e871b753174b3b10f": "No",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "No",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nein"
}
},
{
"id": "0193a87191d471468377642e19853a92",
"_count": 1,
"groupId": "0193a87191cb734daa31ec8f92349ed7",
"group": {
"id": "0193a87191cb734daa31ec8f92349ed7",
"_count": 1
},
"name": {
"018c441a028a73d09246e628782bdd72": "No",
"018dcfdf67ff7019ae54528e014b46c3": "No",
"018dcfe159447f0babc72dd985fa25ba": "No",
"018dcfe1c522789e871b753174b3b10f": "Nee",
"018dcfdcc7527afda4d7e8943c89a90b": "Non",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "\u5426",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nein"
}
},
{
"id": "0193a87191e67017ad9902fbace63bfb",
"_count": 1,
"groupId": "0193a87191dd700eb143c964637c14f5",
"group": {
"id": "0193a87191dd700eb143c964637c14f5",
"_count": 1
},
"name": {
"018c441a028a73d09246e628782bdd72": "No",
"018dcfdcc7527afda4d7e8943c89a90b": "No",
"018dcfdf67ff7019ae54528e014b46c3": "No",
"018dcfe159447f0babc72dd985fa25ba": "No",
"018dcfe1c522789e871b753174b3b10f": "No",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "No",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nein"
}
},
{
"id": "0193a871920872919bf8b4b25e5fd825",
"_count": 1,
"groupId": "0193a87191ff71e7ba39aff645e96ce2",
"group": {
"id": "0193a87191ff71e7ba39aff645e96ce2",
"_count": 1
},
"name": {
"018c441a028a73d09246e628782bdd72": "No",
"018dcfdcc7527afda4d7e8943c89a90b": "No",
"018dcfdf67ff7019ae54528e014b46c3": "No",
"018dcfe159447f0babc72dd985fa25ba": "No",
"018dcfe1c522789e871b753174b3b10f": "No",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "No",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nein"
}
},
{
"id": "0193a871927170d2b60fbc31785eb4c7",
"_count": 1,
"groupId": "0193a87192697163884838bb95d92eed",
"group": {
"id": "0193a87192697163884838bb95d92eed",
"_count": 1
},
"name": {
"018dcfe1c522789e871b753174b3b10f": "Schroefklem",
"018dcfdcc7527afda4d7e8943c89a90b": "Borne \u00e0 vis",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "\u87ba\u4e1d\u7aef\u5b50",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Schraubklemme",
"018dcfe159447f0babc72dd985fa25ba": "Morsetto a vite",
"018c441a028a73d09246e628782bdd72": "Screw terminals",
"018dcfdf67ff7019ae54528e014b46c3": "Terminal de tornillo de fijaci"
}
},
{
"id": "0193a8719281732fab9b8d6948e0952c",
"_count": 1,
"groupId": "0193a871927972d5b08a70ef4e6700b8",
"group": {
"id": "0193a871927972d5b08a70ef4e6700b8",
"_count": 1
},
"name": {
"018c441a028a73d09246e628782bdd72": "1,50mm\u00b2 \/ 16AWG",
"018dcfdcc7527afda4d7e8943c89a90b": "1,50mm\u00b2 \/ 16AWG",
"018dcfe1c522789e871b753174b3b10f": "1,50mm\u00b2 \/ 16AWG",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "1,50mm\u00b2 \/ 16AWG",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "1,50mm\u00b2 \/ 16AWG",
"018dcfe159447f0babc72dd985fa25ba": "1,50 mm\u00b2 \/ 16AWG",
"018dcfdf67ff7019ae54528e014b46c3": "1,50 mm\u00b2 \/ 16 AWG"
}
},
{
"id": "0193a87192b273c897de5fd74efb5b45",
"_count": 1,
"groupId": "0193a87192aa72f189b84b0fa89452ea",
"group": {
"id": "0193a87192aa72f189b84b0fa89452ea",
"_count": 1
},
"name": {
"018c441a028a73d09246e628782bdd72": "+50\u00b0C",
"018dcfdcc7527afda4d7e8943c89a90b": "+50\u00b0C",
"018dcfdf67ff7019ae54528e014b46c3": "+50\u00b0C",
"018dcfe159447f0babc72dd985fa25ba": "+50\u00b0C",
"018dcfe1c522789e871b753174b3b10f": "+50\u00b0C",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "+50\u00b0C",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "+50\u00b0C"
}
},
{
"id": "0193a8719318705c89eb3266d4b43571",
"_count": 1,
"groupId": "0193a871930e70f4a32dc35668725d12",
"group": {
"id": "0193a871930e70f4a32dc35668725d12",
"_count": 1
},
"name": {
"018c441a028a73d09246e628782bdd72": "+\/- 10%",
"018dcfdcc7527afda4d7e8943c89a90b": "+\/- 10%",
"018dcfdf67ff7019ae54528e014b46c3": "+\/- 10%",
"018dcfe159447f0babc72dd985fa25ba": "+\/- 10%",
"018dcfe1c522789e871b753174b3b10f": "+\/- 10%",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "+\/- 10%",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "+\/- 10%"
}
},
{
"id": "0193a8719366735ab96ad3f5d1594c84",
"_count": 1,
"groupId": "0193a871935e704db1fc68f961353c8e",
"group": {
"id": "0193a871935e704db1fc68f961353c8e",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Schutzklasse 2",
"018c441a028a73d09246e628782bdd72": "Protection class 2",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "\u9632\u62a4\u7b49\u7ea7\u4e8c\u7ea7",
"018dcfe1c522789e871b753174b3b10f": "Beschermingsklasse 2",
"018dcfdf67ff7019ae54528e014b46c3": "Clase de protecci\u00f3n 2",
"018dcfdcc7527afda4d7e8943c89a90b": "Classe de protection 2",
"018dcfe159447f0babc72dd985fa25ba": "Classe di protezione 2"
}
},
{
"id": "0193a87193ba726ba1210a796467f13a",
"_count": 1,
"groupId": "0193a87193b170deaac97b850a4cd6cd",
"group": {
"id": "0193a87193b170deaac97b850a4cd6cd",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Dauerton",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "\u8fde\u7eed\u97f3",
"018dcfe159447f0babc72dd985fa25ba": "Suono continuo",
"018c441a028a73d09246e628782bdd72": "Continuous tone",
"018dcfdf67ff7019ae54528e014b46c3": "Tono permanente",
"018dcfe1c522789e871b753174b3b10f": "Onafgebroken toon",
"018dcfdcc7527afda4d7e8943c89a90b": "Tonalit\u00e9 continue"
}
},
{
"id": "0193a8719c4d7232aae125bbf9d1d202",
"_count": 1,
"groupId": "0193a871932073bbb2f0b6580f68a50c",
"group": {
"id": "0193a871932073bbb2f0b6580f68a50c",
"_count": 1
},
"name": {
"018c441a028a73d09246e628782bdd72": "24 VDC",
"018dcfdcc7527afda4d7e8943c89a90b": "24 VDC",
"018dcfdf67ff7019ae54528e014b46c3": "24 VDC",
"018dcfe159447f0babc72dd985fa25ba": "24 VDC",
"018dcfe1c522789e871b753174b3b10f": "24 VDC",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "24 VDC",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "24 VDC"
}
},
{
"id": "0193a871f9e272648b53b7f1320a156c",
"_count": 1,
"groupId": "0193a871f9d97084a9a4757d4a4b0203",
"group": {
"id": "0193a871f9d97084a9a4757d4a4b0203",
"_count": 1
},
"name": {
"018c441a028a73d09246e628782bdd72": "No",
"018dcfdf67ff7019ae54528e014b46c3": "No",
"018dcfe159447f0babc72dd985fa25ba": "No",
"018dcfe1c522789e871b753174b3b10f": "Nee",
"018dcfdcc7527afda4d7e8943c89a90b": "Non",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "\u5426",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nein"
}
},
{
"id": "0193a8720b2171b99f0c941cf9a9217a",
"_count": 1,
"groupId": "0193a87192dc7073929ec7af3856ffdf",
"group": {
"id": "0193a87192dc7073929ec7af3856ffdf",
"_count": 1
},
"name": {
"018c441a028a73d09246e628782bdd72": "24V",
"018dcfdcc7527afda4d7e8943c89a90b": "24V",
"018dcfdf67ff7019ae54528e014b46c3": "24V",
"018dcfe159447f0babc72dd985fa25ba": "24V",
"018dcfe1c522789e871b753174b3b10f": "24V",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "24V",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "24V"
}
},
{
"id": "0193a8724642704e89c9b872fabca74c",
"_count": 1,
"groupId": "0193a871914172ef83976f7f8d5c9d61",
"group": {
"id": "0193a871914172ef83976f7f8d5c9d61",
"_count": 1
},
"name": {
"018c441a028a73d09246e628782bdd72": "No",
"018dcfdf67ff7019ae54528e014b46c3": "No",
"018dcfe159447f0babc72dd985fa25ba": "No",
"018dcfe1c522789e871b753174b3b10f": "Nee",
"018dcfdcc7527afda4d7e8943c89a90b": "Non",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "\u5426",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nein"
}
},
{
"id": "0193a872466f72f9b276459c9c59251e",
"_count": 1,
"groupId": "0193a87192eb708eb4e4fb4db4d4e254",
"group": {
"id": "0193a87192eb708eb4e4fb4db4d4e254",
"_count": 1
},
"name": {
"018c441a028a73d09246e628782bdd72": "DC",
"018dcfdcc7527afda4d7e8943c89a90b": "DC",
"018dcfdf67ff7019ae54528e014b46c3": "DC",
"018dcfe159447f0babc72dd985fa25ba": "DC",
"018dcfe1c522789e871b753174b3b10f": "DC",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "DC",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "DC"
}
},
{
"id": "0193a87263c9720b81a241c287f3a990",
"_count": 1,
"groupId": "0193a8719247726a9f4224b107fb6066",
"group": {
"id": "0193a8719247726a9f4224b107fb6066",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Grau",
"018c441a028a73d09246e628782bdd72": "Grey",
"018dcfdcc7527afda4d7e8943c89a90b": "Gris",
"018dcfdf67ff7019ae54528e014b46c3": "Gris",
"018dcfe1c522789e871b753174b3b10f": "Grijs",
"018dcfe159447f0babc72dd985fa25ba": "Grigio",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "\u7070\u8272"
}
},
{
"id": "0193a8728d3871bfbd74ef8a70290459",
"_count": 1,
"groupId": "0193a871928a701ca62bdf308b45830d",
"group": {
"id": "0193a871928a701ca62bdf308b45830d",
"_count": 1
},
"name": {
"018dcfe1c522789e871b753174b3b10f": "Wandmontage",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Wandmontage",
"018dcfdcc7527afda4d7e8943c89a90b": "Montage mural",
"018dcfdf67ff7019ae54528e014b46c3": "Montaje mural",
"018c441a028a73d09246e628782bdd72": "Wall mounting",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "\u58c1\u6302\u5f0f\u5b89\u88c5",
"018dcfe159447f0babc72dd985fa25ba": "Montaggio a parete"
}
},
{
"id": "0193a872e6917162be16db0802efbab4",
"_count": 1,
"groupId": "0193a871929a706999dae2891b17241a",
"group": {
"id": "0193a871929a706999dae2891b17241a",
"_count": 1
},
"name": {
"018c441a028a73d09246e628782bdd72": "-30\u00b0C",
"018dcfdcc7527afda4d7e8943c89a90b": "-30\u00b0C",
"018dcfdf67ff7019ae54528e014b46c3": "-30\u00b0C",
"018dcfe159447f0babc72dd985fa25ba": "-30\u00b0C",
"018dcfe1c522789e871b753174b3b10f": "-30\u00b0C",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "-30\u00b0C",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "-30\u00b0C"
}
},
{
"id": "0193a872e6c9710fa26f64b09d229280",
"_count": 1,
"groupId": "0193a871936f70659e828c06ff59eb23",
"group": {
"id": "0193a871936f70659e828c06ff59eb23",
"_count": 1
},
"name": {
"018c441a028a73d09246e628782bdd72": "3",
"018dcfdcc7527afda4d7e8943c89a90b": "3",
"018dcfdf67ff7019ae54528e014b46c3": "3",
"018dcfe159447f0babc72dd985fa25ba": "3",
"018dcfe1c522789e871b753174b3b10f": "3",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "3",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "3"
}
},
{
"id": "0193a873024771e59d7cd55dd8c7f5ff",
"_count": 1,
"groupId": "0193a873023d71998e1b9493dd6e71ae",
"group": {
"id": "0193a873023d71998e1b9493dd6e71ae",
"_count": 1
},
"name": {
"018c441a028a73d09246e628782bdd72": "d = 9 mm",
"018dcfdcc7527afda4d7e8943c89a90b": "d = 9 mm",
"018dcfdf67ff7019ae54528e014b46c3": "d = 9 mm",
"018dcfe159447f0babc72dd985fa25ba": "d = 9 mm",
"018dcfe1c522789e871b753174b3b10f": "d = 9 mm",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "d = 9 mm",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "d = 9 mm"
}
},
{
"id": "0193a8730bf37272a026a3483e2da71a",
"_count": 1,
"groupId": "0193a873022c724dacd3682d20c58d23",
"group": {
"id": "0193a873022c724dacd3682d20c58d23",
"_count": 1
},
"name": {
"018dcfe159447f0babc72dd985fa25ba": "Pressacavi",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kabelverschraubung",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "\u87ba\u7eb9\u7535\u7f06\u63a5\u5934",
"018c441a028a73d09246e628782bdd72": "Screwed cable gland",
"018dcfdcc7527afda4d7e8943c89a90b": "Vissage pour c\u00e2ble",
"018dcfe1c522789e871b753174b3b10f": "Kabelschroefverbinding",
"018dcfdf67ff7019ae54528e014b46c3": "Uni\u00f3n roscada de cables"
}
},
{
"id": "0193a8730c1d71ff99d89f33653271ed",
"_count": 1,
"groupId": "0193a8730c1572c880918675de57d0e5",
"group": {
"id": "0193a8730c1572c880918675de57d0e5",
"_count": 1
},
"name": {
"018dcfe3b2ed7b778b19a53ab0f38fdd": "\u73b0\u5728\uff08\u7b26\u5408VDE\uff09",
"018dcfe1c522789e871b753174b3b10f": "Aanwezig (VDE-conform)",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Vorhanden (VDE-Konform)",
"018c441a028a73d09246e628782bdd72": "Present (conforms to VDE)",
"018dcfdf67ff7019ae54528e014b46c3": "Presente (conforme a VDE)",
"018dcfdcc7527afda4d7e8943c89a90b": "Pr\u00e9sent (conforme \u00e0 VDE)",
"018dcfe159447f0babc72dd985fa25ba": "Presente (conf alla norma VDE)"
}
},
{
"id": "0193a87330cc71f48df23f4c6c33e8bf",
"_count": 1,
"groupId": "0193a871910e719ba3e1d770c7352ab8",
"group": {
"id": "0193a871910e719ba3e1d770c7352ab8",
"_count": 1
},
"name": {
"018c441a028a73d09246e628782bdd72": "No",
"018dcfdcc7527afda4d7e8943c89a90b": "No",
"018dcfdf67ff7019ae54528e014b46c3": "No",
"018dcfe159447f0babc72dd985fa25ba": "No",
"018dcfe1c522789e871b753174b3b10f": "No",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "No",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nein"
}
},
{
"id": "0193a87330ed7147b553bb17142a5c5e",
"_count": 1,
"groupId": "0193a87192587388ba6bba6ad2d567a9",
"group": {
"id": "0193a87192587388ba6bba6ad2d567a9",
"_count": 1
},
"name": {
"018c441a028a73d09246e628782bdd72": "IP66",
"018dcfdcc7527afda4d7e8943c89a90b": "IP66",
"018dcfdf67ff7019ae54528e014b46c3": "IP66",
"018dcfe159447f0babc72dd985fa25ba": "IP66",
"018dcfe1c522789e871b753174b3b10f": "IP66",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "IP66",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "IP66"
}
},
{
"id": "0193a87537dc71cc8a7d9240f6d48486",
"_count": 1,
"groupId": "0193a871918972cb84020fa2f1a145c7",
"group": {
"id": "0193a871918972cb84020fa2f1a145c7",
"_count": 1
},
"name": {
"018c441a028a73d09246e628782bdd72": "No",
"018dcfdcc7527afda4d7e8943c89a90b": "No",
"018dcfdf67ff7019ae54528e014b46c3": "No",
"018dcfe159447f0babc72dd985fa25ba": "No",
"018dcfe1c522789e871b753174b3b10f": "No",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "No",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nein"
}
},
{
"id": "0193a89544857001932d8c1415e48514",
"_count": 1,
"groupId": "0193a8730bfb72f28a990bf4a45d9534",
"group": {
"id": "0193a8730bfb72f28a990bf4a45d9534",
"_count": 1
},
"name": {
"018c441a028a73d09246e628782bdd72": "d = 5 mm",
"018dcfdcc7527afda4d7e8943c89a90b": "d = 5 mm",
"018dcfdf67ff7019ae54528e014b46c3": "d = 5 mm",
"018dcfe159447f0babc72dd985fa25ba": "d = 5 mm",
"018dcfe1c522789e871b753174b3b10f": "d = 5 mm",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "d = 5 mm",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "d = 5 mm"
}
},
{
"id": "0193a89b09d9704b9042c44fc0f298ca",
"_count": 1,
"groupId": "0193a871934b70b98662a2bd7b14eec6",
"group": {
"id": "0193a871934b70b98662a2bd7b14eec6",
"_count": 1
},
"name": {
"018c441a028a73d09246e628782bdd72": "1.000 mA",
"018dcfdcc7527afda4d7e8943c89a90b": "1.000 mA",
"018dcfdf67ff7019ae54528e014b46c3": "1.000 mA",
"018dcfe159447f0babc72dd985fa25ba": "1.000 mA",
"018dcfe1c522789e871b753174b3b10f": "1.000 mA",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "1.000 mA",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "1.000 mA"
}
},
{
"id": "0193a89b09e17205b9a9b9b5e491b643",
"_count": 1,
"groupId": "0193a871939171fe8b19c1d8a90e6c31",
"group": {
"id": "0193a871939171fe8b19c1d8a90e6c31",
"_count": 1
},
"name": {
"018c441a028a73d09246e628782bdd72": "98,0 dB (A)",
"018dcfdcc7527afda4d7e8943c89a90b": "98,0 dB (A)",
"018dcfdf67ff7019ae54528e014b46c3": "98,0 dB (A)",
"018dcfe159447f0babc72dd985fa25ba": "98,0 dB (A)",
"018dcfe1c522789e871b753174b3b10f": "98,0 dB (A)",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "98,0 dB (A)",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "98,0 dB (A)"
}
},
{
"id": "0193a9dfd45a73f9b82f0f64cf78010f",
"_count": 1,
"groupId": "0193a871923670349733d268bcc00acb",
"group": {
"id": "0193a871923670349733d268bcc00acb",
"_count": 1
},
"name": {
"018dcfe3b2ed7b778b19a53ab0f38fdd": "\u94c1",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Stahl",
"018c441a028a73d09246e628782bdd72": "Steel",
"018dcfe1c522789e871b753174b3b10f": "Stalen",
"018dcfe159447f0babc72dd985fa25ba": "Siderurgica",
"018dcfdf67ff7019ae54528e014b46c3": "Sider\u00fargico",
"018dcfdcc7527afda4d7e8943c89a90b": "Sid\u00e9rurgique"
}
},
{
"id": "0193a9dfd4757066b2f0e9c4e6f17db6",
"_count": 1,
"groupId": "0193a873311d72fda1a5dd7670ffe089",
"group": {
"id": "0193a873311d72fda1a5dd7670ffe089",
"_count": 1
},
"name": {
"018dcfdcc7527afda4d7e8943c89a90b": "min. 200 h",
"018dcfe159447f0babc72dd985fa25ba": "min. 200 h",
"018dcfe1c522789e871b753174b3b10f": "min. 200 h",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "min. 200 h",
"018dcfdf67ff7019ae54528e014b46c3": "m\u00edn. 200 h",
"018c441a028a73d09246e628782bdd72": "200 h minimum",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "200 h \uff08\u6700\u4f4e\uff09"
}
},
{
"id": "0193a9dfd47e71aaa1125b9649ba87be",
"_count": 1,
"groupId": "0193a87193e672049e5ac01133b28ead",
"group": {
"id": "0193a87193e672049e5ac01133b28ead",
"_count": 1
},
"name": {
"018dcfdcc7527afda4d7e8943c89a90b": "min. 200 h",
"018dcfe159447f0babc72dd985fa25ba": "min. 200 h",
"018dcfe1c522789e871b753174b3b10f": "min. 200 h",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "min. 200 h",
"018dcfdf67ff7019ae54528e014b46c3": "m\u00edn. 200 h",
"018c441a028a73d09246e628782bdd72": "200 h minimum",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "200 h \uff08\u6700\u4f4e\uff09"
}
},
{
"id": "0194a5d748ab72af9a8da61a52b49ed8",
"_count": 1,
"groupId": "0193a871933271b0b1a06b8b59273eec",
"group": {
"id": "0193a871933271b0b1a06b8b59273eec",
"_count": 1
},
"name": {
"018c441a028a73d09246e628782bdd72": "300",
"018dcfdcc7527afda4d7e8943c89a90b": "300",
"018dcfdf67ff7019ae54528e014b46c3": "300",
"018dcfe159447f0babc72dd985fa25ba": "300",
"018dcfe1c522789e871b753174b3b10f": "300",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "300",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "300,00 mA"
}
},
{
"id": "0194a6a7e7a37284862b76cd80c183f2",
"_count": 1,
"groupId": "0193a871921270e19420f5ee8427741a",
"group": {
"id": "0193a871921270e19420f5ee8427741a",
"_count": 1
},
"name": {
"018c441a028a73d09246e628782bdd72": "76",
"018dcfdcc7527afda4d7e8943c89a90b": "76",
"018dcfdf67ff7019ae54528e014b46c3": "76",
"018dcfe159447f0babc72dd985fa25ba": "76",
"018dcfe1c522789e871b753174b3b10f": "76",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "76",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "76,00 mm"
}
},
{
"id": "0194a6a7e7b47033aea0511506300e26",
"_count": 1,
"groupId": "0193a87192237218996e9d42a74aa753",
"group": {
"id": "0193a87192237218996e9d42a74aa753",
"_count": 1
},
"name": {
"018c441a028a73d09246e628782bdd72": "167",
"018dcfdcc7527afda4d7e8943c89a90b": "167",
"018dcfdf67ff7019ae54528e014b46c3": "167",
"018dcfe159447f0babc72dd985fa25ba": "167",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "167",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "167,00 mm",
"018dcfe1c522789e871b753174b3b10f": "167.000000"
}
},
{
"id": "0194a6a7e7c171b890c3070ce3d7af0b",
"_count": 1,
"groupId": "0193a87192bb70ef9a63cab928fbca5e",
"group": {
"id": "0193a87192bb70ef9a63cab928fbca5e",
"_count": 1
},
"name": {
"018c441a028a73d09246e628782bdd72": "1501",
"018dcfdcc7527afda4d7e8943c89a90b": "1501",
"018dcfdf67ff7019ae54528e014b46c3": "1501",
"018dcfe159447f0babc72dd985fa25ba": "1501",
"018dcfe1c522789e871b753174b3b10f": "1501",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "1501",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "1501,00 g"
}
},
{
"id": "0194a6a7e7d070bc8acc5e02311c037d",
"_count": 1,
"groupId": "0193a87192cc72098f2de9d6b5b55f9d",
"group": {
"id": "0193a87192cc72098f2de9d6b5b55f9d",
"_count": 1
},
"name": {
"018c441a028a73d09246e628782bdd72": "1405",
"018dcfdcc7527afda4d7e8943c89a90b": "1405",
"018dcfdf67ff7019ae54528e014b46c3": "1405",
"018dcfe159447f0babc72dd985fa25ba": "1405",
"018dcfe1c522789e871b753174b3b10f": "1405",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "1405",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "1405,00 g"
}
},
{
"id": "0199acbd4eee73b7a5be696018335c17",
"_count": 1,
"groupId": "0199acbd4ee572489d2f21c589fd8424",
"group": {
"id": "0199acbd4ee572489d2f21c589fd8424",
"_count": 1
},
"name": {
"018c441a028a73d09246e628782bdd72": "No",
"018dcfdcc7527afda4d7e8943c89a90b": "No",
"018dcfdf67ff7019ae54528e014b46c3": "No",
"018dcfe1c522789e871b753174b3b10f": "No",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "No",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nein"
}
}
],
"options": [
{
"id": "0194a889a513726095acbf542214d535",
"_count": 1,
"groupId": "0191b8806374734aa259d00c6b2a53d8",
"group": {
"id": "0191b8806374734aa259d00c6b2a53d8",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "24V DC"
}
}
],
"categoryIds": [
"0190307963627d0e9b414d038fd396fe"
],
"optionIds": [
"0194a889a513726095acbf542214d535"
],
"propertyIds": [
"0193a87190f471e3aca5ddd1a5d12030",
"0193a8719107713387d0dcb2f21bfdde",
"0193a8719127736cb59d64cc1b877f30",
"0193a8719138723f9f2813b3e9b2f6db",
"0193a871916e73749120ef91e33e0eeb",
"0193a87191b172708180a489b94f87df",
"0193a87191c2709292a220a65531a4d8",
"0193a87191d471468377642e19853a92",
"0193a87191e67017ad9902fbace63bfb",
"0193a871920872919bf8b4b25e5fd825",
"0193a871927170d2b60fbc31785eb4c7",
"0193a8719281732fab9b8d6948e0952c",
"0193a87192b273c897de5fd74efb5b45",
"0193a8719318705c89eb3266d4b43571",
"0193a8719366735ab96ad3f5d1594c84",
"0193a87193ba726ba1210a796467f13a",
"0193a8719c4d7232aae125bbf9d1d202",
"0193a871f9e272648b53b7f1320a156c",
"0193a8720b2171b99f0c941cf9a9217a",
"0193a8724642704e89c9b872fabca74c",
"0193a872466f72f9b276459c9c59251e",
"0193a87263c9720b81a241c287f3a990",
"0193a8728d3871bfbd74ef8a70290459",
"0193a872e6917162be16db0802efbab4",
"0193a872e6c9710fa26f64b09d229280",
"0193a873024771e59d7cd55dd8c7f5ff",
"0193a8730bf37272a026a3483e2da71a",
"0193a8730c1d71ff99d89f33653271ed",
"0193a87330cc71f48df23f4c6c33e8bf",
"0193a87330ed7147b553bb17142a5c5e",
"0193a87537dc71cc8a7d9240f6d48486",
"0193a89544857001932d8c1415e48514",
"0193a89b09d9704b9042c44fc0f298ca",
"0193a89b09e17205b9a9b9b5e491b643",
"0193a9dfd45a73f9b82f0f64cf78010f",
"0193a9dfd4757066b2f0e9c4e6f17db6",
"0193a9dfd47e71aaa1125b9649ba87be",
"0194a5d748ab72af9a8da61a52b49ed8",
"0194a6a7e7a37284862b76cd80c183f2",
"0194a6a7e7b47033aea0511506300e26",
"0194a6a7e7c171b890c3070ce3d7af0b",
"0194a6a7e7d070bc8acc5e02311c037d",
"0199acbd4eee73b7a5be696018335c17"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"018c441a028a73d09246e628782bdd72": {
"additional_downloads": "{\"datasheet\":{\"mediaId\":\"01943c0e9d3372e4a4c771fff8fc5c50\"},\"sounds\":[{\"artNo\":\"91405255\",\"docID\":\"47747\",\"type\":\"2\",\"language\":\"en\",\"name\":\"Sound\",\"extension\":\"mp3\",\"version\":\"00\",\"checksum\":\"3b306af7c944d0df0d33846260329887ac515dd7\",\"tsUpdate\":\"2022-03-14 22:14:18\",\"mediaId\":\"01943c0ea12b7248a83d25df979727b5\"}],\"downloads\":[{\"artNo\":\"91405255\",\"docID\":\"2095423\",\"type\":\"8\",\"language\":\"en\",\"name\":\"Operating instructions\",\"extension\":\"pdf\",\"version\":\"00\",\"checksum\":\"3e7fc39b309cc36eccbe5ba8b7664d4445a7e69d\",\"tsUpdate\":\"2022-03-16 11:40:59\",\"mediaId\":\"01943c0ea23f73ec8b3b96393fa71bf5\"},{\"artNo\":\"91405255\",\"docID\":\"1481445\",\"type\":\"4\",\"language\":\"en\",\"name\":\"Dimensional drawing\",\"extension\":\"jpg\",\"version\":\"AA\",\"checksum\":\"bc76aa516e1492757abe49c1406e1cf37215118b\",\"tsUpdate\":\"2022-03-15 23:04:51\",\"mediaId\":\"01943c0ea320722fbf3502dc2e404e6b\"}]}"
},
"018dcfdcc7527afda4d7e8943c89a90b": {
"additional_downloads": "{\"datasheet\":{\"mediaId\":\"01943c0e9dcc73c09f23a858efe9f2fe\"},\"sounds\":[{\"artNo\":\"91405255\",\"docID\":\"47747\",\"type\":\"2\",\"language\":\"en\",\"name\":\"Sound\",\"extension\":\"mp3\",\"version\":\"00\",\"checksum\":\"3b306af7c944d0df0d33846260329887ac515dd7\",\"tsUpdate\":\"2022-03-14 22:14:18\",\"mediaId\":\"01943c0ea12b7248a83d25df979727b5\"}],\"downloads\":[{\"artNo\":\"91405255\",\"docID\":\"2095423\",\"type\":\"8\",\"language\":\"en\",\"name\":\"Operating instructions\",\"extension\":\"pdf\",\"version\":\"00\",\"checksum\":\"3e7fc39b309cc36eccbe5ba8b7664d4445a7e69d\",\"tsUpdate\":\"2022-03-16 11:40:59\",\"mediaId\":\"01943c0ea23f73ec8b3b96393fa71bf5\"},{\"artNo\":\"91405255\",\"docID\":\"1481445\",\"type\":\"4\",\"language\":\"en\",\"name\":\"Dimensional drawing\",\"extension\":\"jpg\",\"version\":\"AA\",\"checksum\":\"bc76aa516e1492757abe49c1406e1cf37215118b\",\"tsUpdate\":\"2022-03-15 23:04:51\",\"mediaId\":\"01943c0ea320722fbf3502dc2e404e6b\"}]}"
},
"018dcfdf67ff7019ae54528e014b46c3": {
"additional_downloads": "{\"datasheet\":{\"mediaId\":\"01943c0e9e5b7010b3c35be2b2ccd502\"},\"sounds\":[{\"artNo\":\"91405255\",\"docID\":\"47747\",\"type\":\"2\",\"language\":\"en\",\"name\":\"Sound\",\"extension\":\"mp3\",\"version\":\"00\",\"checksum\":\"3b306af7c944d0df0d33846260329887ac515dd7\",\"tsUpdate\":\"2022-03-14 22:14:18\",\"mediaId\":\"01943c0ea12b7248a83d25df979727b5\"}],\"downloads\":[{\"artNo\":\"91405255\",\"docID\":\"2095423\",\"type\":\"8\",\"language\":\"en\",\"name\":\"Operating instructions\",\"extension\":\"pdf\",\"version\":\"00\",\"checksum\":\"3e7fc39b309cc36eccbe5ba8b7664d4445a7e69d\",\"tsUpdate\":\"2022-03-16 11:40:59\",\"mediaId\":\"01943c0ea23f73ec8b3b96393fa71bf5\"},{\"artNo\":\"91405255\",\"docID\":\"1481445\",\"type\":\"4\",\"language\":\"en\",\"name\":\"Dimensional drawing\",\"extension\":\"jpg\",\"version\":\"AA\",\"checksum\":\"bc76aa516e1492757abe49c1406e1cf37215118b\",\"tsUpdate\":\"2022-03-15 23:04:51\",\"mediaId\":\"01943c0ea320722fbf3502dc2e404e6b\"}]}"
},
"018dcfe159447f0babc72dd985fa25ba": {
"additional_downloads": "{\"datasheet\":{\"mediaId\":\"01943c0e9ef2731d9fc1267360f740fc\"},\"sounds\":[{\"artNo\":\"91405255\",\"docID\":\"47747\",\"type\":\"2\",\"language\":\"en\",\"name\":\"Sound\",\"extension\":\"mp3\",\"version\":\"00\",\"checksum\":\"3b306af7c944d0df0d33846260329887ac515dd7\",\"tsUpdate\":\"2022-03-14 22:14:18\",\"mediaId\":\"01943c0ea12b7248a83d25df979727b5\"}],\"downloads\":[{\"artNo\":\"91405255\",\"docID\":\"2095423\",\"type\":\"8\",\"language\":\"en\",\"name\":\"Operating instructions\",\"extension\":\"pdf\",\"version\":\"00\",\"checksum\":\"3e7fc39b309cc36eccbe5ba8b7664d4445a7e69d\",\"tsUpdate\":\"2022-03-16 11:40:59\",\"mediaId\":\"01943c0ea23f73ec8b3b96393fa71bf5\"},{\"artNo\":\"91405255\",\"docID\":\"1481445\",\"type\":\"4\",\"language\":\"en\",\"name\":\"Dimensional drawing\",\"extension\":\"jpg\",\"version\":\"AA\",\"checksum\":\"bc76aa516e1492757abe49c1406e1cf37215118b\",\"tsUpdate\":\"2022-03-15 23:04:51\",\"mediaId\":\"01943c0ea320722fbf3502dc2e404e6b\"}]}"
},
"018dcfe1c522789e871b753174b3b10f": {
"additional_downloads": "{\"datasheet\":{\"mediaId\":\"01943c0e9f877187926b40ad83463831\"},\"sounds\":[{\"artNo\":\"91405255\",\"docID\":\"47747\",\"type\":\"2\",\"language\":\"en\",\"name\":\"Sound\",\"extension\":\"mp3\",\"version\":\"00\",\"checksum\":\"3b306af7c944d0df0d33846260329887ac515dd7\",\"tsUpdate\":\"2022-03-14 22:14:18\",\"mediaId\":\"01943c0ea12b7248a83d25df979727b5\"}],\"downloads\":[{\"artNo\":\"91405255\",\"docID\":\"2095423\",\"type\":\"8\",\"language\":\"en\",\"name\":\"Operating instructions\",\"extension\":\"pdf\",\"version\":\"00\",\"checksum\":\"3e7fc39b309cc36eccbe5ba8b7664d4445a7e69d\",\"tsUpdate\":\"2022-03-16 11:40:59\",\"mediaId\":\"01943c0ea23f73ec8b3b96393fa71bf5\"},{\"artNo\":\"91405255\",\"docID\":\"1481445\",\"type\":\"4\",\"language\":\"en\",\"name\":\"Dimensional drawing\",\"extension\":\"jpg\",\"version\":\"AA\",\"checksum\":\"bc76aa516e1492757abe49c1406e1cf37215118b\",\"tsUpdate\":\"2022-03-15 23:04:51\",\"mediaId\":\"01943c0ea320722fbf3502dc2e404e6b\"}]}"
},
"018dcfe3b2ed7b778b19a53ab0f38fdd": {
"additional_downloads": "{\"datasheet\":{\"mediaId\":\"01943c0ea037711097ac500f93757155\"},\"sounds\":[{\"artNo\":\"91405255\",\"docID\":\"47747\",\"type\":\"2\",\"language\":\"en\",\"name\":\"Sound\",\"extension\":\"mp3\",\"version\":\"00\",\"checksum\":\"3b306af7c944d0df0d33846260329887ac515dd7\",\"tsUpdate\":\"2022-03-14 22:14:18\",\"mediaId\":\"01943c0ea12b7248a83d25df979727b5\"}],\"downloads\":[{\"artNo\":\"91405255\",\"docID\":\"2095423\",\"type\":\"8\",\"language\":\"en\",\"name\":\"Operating instructions\",\"extension\":\"pdf\",\"version\":\"00\",\"checksum\":\"3e7fc39b309cc36eccbe5ba8b7664d4445a7e69d\",\"tsUpdate\":\"2022-03-16 11:40:59\",\"mediaId\":\"01943c0ea23f73ec8b3b96393fa71bf5\"},{\"artNo\":\"91405255\",\"docID\":\"1481445\",\"type\":\"4\",\"language\":\"en\",\"name\":\"Dimensional drawing\",\"extension\":\"jpg\",\"version\":\"AA\",\"checksum\":\"bc76aa516e1492757abe49c1406e1cf37215118b\",\"tsUpdate\":\"2022-03-15 23:04:51\",\"mediaId\":\"01943c0ea320722fbf3502dc2e404e6b\"}]}"
},
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"additional_grp_no": "110001010010128000",
"werma_article_number": "914.052.55",
"plant_us_ca": 0.0,
"additional_downloads": "{\"datasheet\":{\"mediaId\":\"01931245c27970929506de4bf2ce3720\"},\"sounds\":[{\"artNo\":\"91405255\",\"docID\":\"47746\",\"type\":\"2\",\"language\":\"de\",\"name\":\"T\\u00f6ne\",\"extension\":\"mp3\",\"version\":\"00\",\"checksum\":\"3b306af7c944d0df0d33846260329887ac515dd7\",\"tsUpdate\":\"2022-03-14 22:14:18\",\"mediaId\":\"01931245c2fd7067ac20c6a66e12d31b\"}],\"downloads\":[{\"artNo\":\"91405255\",\"docID\":\"2095422\",\"type\":\"8\",\"language\":\"de\",\"name\":\"Bedienungsanleitung\",\"extension\":\"pdf\",\"version\":\"00\",\"checksum\":\"3e7fc39b309cc36eccbe5ba8b7664d4445a7e69d\",\"tsUpdate\":\"2022-03-16 11:40:59\",\"mediaId\":\"01931245c3c8734cad82b1974e14204b\"},{\"artNo\":\"91405255\",\"docID\":\"1481444\",\"type\":\"4\",\"language\":\"de\",\"name\":\"Masszeichnung\",\"extension\":\"jpg\",\"version\":\"AA\",\"checksum\":\"bc76aa516e1492757abe49c1406e1cf37215118b\",\"tsUpdate\":\"2022-03-15 23:04:51\",\"mediaId\":\"01931245c46e7394873edecf58b534d5\"}]}"
}
},
"name": {
"018c441a028a73d09246e628782bdd72": "Bell continuous tone 24VDC GY",
"018dcfdcc7527afda4d7e8943c89a90b": "Sonnerie d'alarme continu 24VDC GY",
"018dcfdf67ff7019ae54528e014b46c3": "Campana de alarma continuo 24VDC GY",
"018dcfe159447f0babc72dd985fa25ba": "Campanello d'allarme permanente 24VDC GY",
"018dcfe1c522789e871b753174b3b10f": "Alarmbel continue 24VDC GY",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "Bell continuous tone 24VDC GY",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "L\u00e4utewerk Dauerton 24VDC GY"
},
"description": {
"018c441a028a73d09246e628782bdd72": "Durable steel bell\nHigh protection rating IP 66",
"018dcfdcc7527afda4d7e8943c89a90b": "Sonnerie d'alarme robuste avec cloche en acier\nIndice de protection \u00e9lev\u00e9 : IP66",
"018dcfdf67ff7019ae54528e014b46c3": "Robusto timbre con campana en acero\nGrado de protecci\u00f3n elevado IP 66",
"018dcfe159447f0babc72dd985fa25ba": "Robusta suoneria con campana in acciaio\nClasse di protezione elevata, IP 66",
"018dcfe1c522789e871b753174b3b10f": "Robuuste elektrische bel met stalen klok\nHoge beschermingsgraad IP 66",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "Durable steel bell\nHigh protection rating IP 66",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Robustes L\u00e4utewerk mit Glocke in Stahlausf\u00fchrung\nHohe Schutzart IP 66"
},
"metaTitle": {
"018c441a028a73d09246e628782bdd72": null,
"018dcfdcc7527afda4d7e8943c89a90b": null,
"018dcfdf67ff7019ae54528e014b46c3": null,
"018dcfe159447f0babc72dd985fa25ba": null,
"018dcfe1c522789e871b753174b3b10f": null,
"018dcfe3b2ed7b778b19a53ab0f38fdd": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"018c441a028a73d09246e628782bdd72": null,
"018dcfdcc7527afda4d7e8943c89a90b": null,
"018dcfdf67ff7019ae54528e014b46c3": null,
"018dcfe159447f0babc72dd985fa25ba": null,
"018dcfe1c522789e871b753174b3b10f": null,
"018dcfe3b2ed7b778b19a53ab0f38fdd": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"018c441a028a73d09246e628782bdd72": null,
"018dcfdcc7527afda4d7e8943c89a90b": null,
"018dcfdf67ff7019ae54528e014b46c3": null,
"018dcfe159447f0babc72dd985fa25ba": null,
"018dcfe1c522789e871b753174b3b10f": null,
"018dcfe3b2ed7b778b19a53ab0f38fdd": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_rule0192b8c104d5720c8cc277b787a407c3_currency018c4418fa4871c9805a5f0b4d28930b_gross": 278.14,
"cheapest_price_rule0192b8c104d5720c8cc277b787a407c3_currency018c4418fa4871c9805a5f0b4d28930b_net": 278.14,
"cheapest_price_rule0192b8c104d5720c8cc277b787a407c3_currency018c4418fa4871c9805a5f0b4e05212d_gross": 205.58,
"cheapest_price_rule0192b8c104d5720c8cc277b787a407c3_currency018c4418fa4871c9805a5f0b4e05212d_net": 205.58,
"cheapest_price_rule0192b8c104d5720c8cc277b787a407c3_currency018c44191f84725c9aee2a829d557a63_gross": 232.19,
"cheapest_price_rule0192b8c104d5720c8cc277b787a407c3_currency018c44191f84725c9aee2a829d557a63_net": 232.19,
"cheapest_price_rule0192b8c104d5720c8cc277b787a407c3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 241.86,
"cheapest_price_rule0192b8c104d5720c8cc277b787a407c3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 241.86,
"cheapest_price_rule0195cd9f3a9b70de90a64df7fe7e97d5_currency018c4418fa4871c9805a5f0b4d28930b_gross": 278.14,
"cheapest_price_rule0195cd9f3a9b70de90a64df7fe7e97d5_currency018c4418fa4871c9805a5f0b4d28930b_net": 278.14,
"cheapest_price_rule0195cd9f3a9b70de90a64df7fe7e97d5_currency018c4418fa4871c9805a5f0b4e05212d_gross": 205.58,
"cheapest_price_rule0195cd9f3a9b70de90a64df7fe7e97d5_currency018c4418fa4871c9805a5f0b4e05212d_net": 205.58,
"cheapest_price_rule0195cd9f3a9b70de90a64df7fe7e97d5_currency018c44191f84725c9aee2a829d557a63_gross": 232.19,
"cheapest_price_rule0195cd9f3a9b70de90a64df7fe7e97d5_currency018c44191f84725c9aee2a829d557a63_net": 232.19,
"cheapest_price_rule0195cd9f3a9b70de90a64df7fe7e97d5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 241.86,
"cheapest_price_rule0195cd9f3a9b70de90a64df7fe7e97d5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 241.86,
"cheapest_price_rule0194884696027f609aad4efeaa36863a_currency018c4418fa4871c9805a5f0b4d28930b_gross": 361.582,
"cheapest_price_rule0194884696027f609aad4efeaa36863a_currency018c4418fa4871c9805a5f0b4d28930b_net": 361.582,
"cheapest_price_rule0194884696027f609aad4efeaa36863a_currency018c4418fa4871c9805a5f0b4e05212d_gross": 267.254,
"cheapest_price_rule0194884696027f609aad4efeaa36863a_currency018c4418fa4871c9805a5f0b4e05212d_net": 267.254,
"cheapest_price_rule0194884696027f609aad4efeaa36863a_currency018c44191f84725c9aee2a829d557a63_gross": 301.847,
"cheapest_price_rule0194884696027f609aad4efeaa36863a_currency018c44191f84725c9aee2a829d557a63_net": 301.847,
"cheapest_price_rule0194884696027f609aad4efeaa36863a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 314.418,
"cheapest_price_rule0194884696027f609aad4efeaa36863a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 314.418,
"cheapest_price_rule019488482b9d7801a9f1ad9141bf4340_currency018c4418fa4871c9805a5f0b4d28930b_gross": 632.7684999999999,
"cheapest_price_rule019488482b9d7801a9f1ad9141bf4340_currency018c4418fa4871c9805a5f0b4d28930b_net": 632.7684999999999,
"cheapest_price_rule019488482b9d7801a9f1ad9141bf4340_currency018c4418fa4871c9805a5f0b4e05212d_gross": 467.6945,
"cheapest_price_rule019488482b9d7801a9f1ad9141bf4340_currency018c4418fa4871c9805a5f0b4e05212d_net": 467.6945,
"cheapest_price_rule019488482b9d7801a9f1ad9141bf4340_currency018c44191f84725c9aee2a829d557a63_gross": 528.23225,
"cheapest_price_rule019488482b9d7801a9f1ad9141bf4340_currency018c44191f84725c9aee2a829d557a63_net": 528.23225,
"cheapest_price_rule019488482b9d7801a9f1ad9141bf4340_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 550.2315,
"cheapest_price_rule019488482b9d7801a9f1ad9141bf4340_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 550.2315,
"cheapest_price_rule0192f66821f27feb9bf0006e6a603cc3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 423.25,
"cheapest_price_rule0192f66821f27feb9bf0006e6a603cc3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 423.25,
"cheapest_price_rule0192f6668a7e75ffac421df6abe479df_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 290.23,
"cheapest_price_rule0192f6668a7e75ffac421df6abe479df_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 290.23,
"cheapest_price_rule018c4418fb697089b4105d454ff53c36_currency018c4418fa4871c9805a5f0b4d28930b_gross": 468.71,
"cheapest_price_rule018c4418fb697089b4105d454ff53c36_currency018c4418fa4871c9805a5f0b4d28930b_net": 468.71,
"cheapest_price_rule018c4418fb697089b4105d454ff53c36_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 468.71,
"cheapest_price_rule018c4418fb697089b4105d454ff53c36_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 468.71,
"cheapest_price_rule01948838e9287883829705d505db9e67_currency018c4418fa4871c9805a5f0b4d28930b_gross": 468.71,
"cheapest_price_rule01948838e9287883829705d505db9e67_currency018c4418fa4871c9805a5f0b4d28930b_net": 468.71,
"cheapest_price_rule01948838e9287883829705d505db9e67_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 468.71,
"cheapest_price_rule01948838e9287883829705d505db9e67_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 468.71,
"cheapest_price_rule0192f667ac2d7192b5f83ff640899e48_currency018c44191f84725c9aee2a829d557a63_gross": 308.2,
"cheapest_price_rule0192f667ac2d7192b5f83ff640899e48_currency018c44191f84725c9aee2a829d557a63_net": 308.2,
"cheapest_price_rule0192f667ac2d7192b5f83ff640899e48_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 241.86,
"cheapest_price_rule0192f667ac2d7192b5f83ff640899e48_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 241.86,
"cheapest_price_rule0192f66525a97488a280d3c1580a35cd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 362.79,
"cheapest_price_rule0192f66525a97488a280d3c1580a35cd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 362.79,
"cheapest_price_rule0192f66725ee71fcaa9702e615e1998c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 336.66,
"cheapest_price_rule0192f66725ee71fcaa9702e615e1998c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 336.66,
"cheapest_price_ruledefault_currency018c4418fa4871c9805a5f0b4d28930b_gross": 278.14,
"cheapest_price_ruledefault_currency018c4418fa4871c9805a5f0b4d28930b_net": 278.14,
"cheapest_price_ruledefault_currency018c4418fa4871c9805a5f0b4e05212d_gross": 205.58,
"cheapest_price_ruledefault_currency018c4418fa4871c9805a5f0b4e05212d_net": 205.58,
"cheapest_price_ruledefault_currency018c44191f84725c9aee2a829d557a63_gross": 232.19,
"cheapest_price_ruledefault_currency018c44191f84725c9aee2a829d557a63_net": 232.19,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 241.86,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 241.86,
"warehouseGroups": [
{
"id": null,
"_count": 0
}
],
"completion": [
{
"key": "all",
"value": "91405255"
},
{
"key": "018c441a028a73d09246e628782bdd72",
"value": "bell"
},
{
"key": "018c441a028a73d09246e628782bdd72",
"value": "continuous"
},
{
"key": "018c441a028a73d09246e628782bdd72",
"value": "tone"
},
{
"key": "018c441a028a73d09246e628782bdd72",
"value": "24vdc"
},
{
"key": "018c441a028a73d09246e628782bdd72",
"value": "bell continuous tone 24vdc gy"
},
{
"key": "018dcfdcc7527afda4d7e8943c89a90b",
"value": "sonnerie"
},
{
"key": "018dcfdcc7527afda4d7e8943c89a90b",
"value": "d'alarme"
},
{
"key": "018dcfdcc7527afda4d7e8943c89a90b",
"value": "continu"
},
{
"key": "018dcfdcc7527afda4d7e8943c89a90b",
"value": "24vdc"
},
{
"key": "018dcfdcc7527afda4d7e8943c89a90b",
"value": "sonnerie d'alarme continu 24vdc gy"
},
{
"key": "018dcfdf67ff7019ae54528e014b46c3",
"value": "campana"
},
{
"key": "018dcfdf67ff7019ae54528e014b46c3",
"value": "alarma"
},
{
"key": "018dcfdf67ff7019ae54528e014b46c3",
"value": "continuo"
},
{
"key": "018dcfdf67ff7019ae54528e014b46c3",
"value": "24vdc"
},
{
"key": "018dcfdf67ff7019ae54528e014b46c3",
"value": "campana de alarma continuo 24vdc gy"
},
{
"key": "018dcfe159447f0babc72dd985fa25ba",
"value": "campanello"
},
{
"key": "018dcfe159447f0babc72dd985fa25ba",
"value": "d'allarme"
},
{
"key": "018dcfe159447f0babc72dd985fa25ba",
"value": "permanente"
},
{
"key": "018dcfe159447f0babc72dd985fa25ba",
"value": "24vdc"
},
{
"key": "018dcfe159447f0babc72dd985fa25ba",
"value": "campanello d'allarme permanente 24vdc gy"
},
{
"key": "018dcfe1c522789e871b753174b3b10f",
"value": "alarmbel"
},
{
"key": "018dcfe1c522789e871b753174b3b10f",
"value": "continue"
},
{
"key": "018dcfe1c522789e871b753174b3b10f",
"value": "24vdc"
},
{
"key": "018dcfe1c522789e871b753174b3b10f",
"value": "alarmbel continue 24vdc gy"
},
{
"key": "018dcfe3b2ed7b778b19a53ab0f38fdd",
"value": "bell"
},
{
"key": "018dcfe3b2ed7b778b19a53ab0f38fdd",
"value": "continuous"
},
{
"key": "018dcfe3b2ed7b778b19a53ab0f38fdd",
"value": "tone"
},
{
"key": "018dcfe3b2ed7b778b19a53ab0f38fdd",
"value": "24vdc"
},
{
"key": "018dcfe3b2ed7b778b19a53ab0f38fdd",
"value": "bell continuous tone 24vdc gy"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "l\u00e4utewerk"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "dauerton"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "24vdc"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "l\u00e4utewerk dauerton 24vdc gy"
}
],
"swagDynamicAccessRules": [
{
"id": null,
"_count": 1
}
],
"parent": {
"swagDynamicAccessRules": [
{
"id": null,
"_count": 1
}
]
}
},
"fields": {
"displayGroup": [
"c64bdb353e2b5f9642d4cc2807eaaae4"
]
},
"sort": [
5.0e-324,
0,
"0194a9963145700c8f5ff57c0a7acaac"
]
}
]
},
"aggregations": {
"total-count": {
"value": 1
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
9.96 ms |
Request:
{"index":"sw_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":"018c441a15d77028a057088b5c4e9b69"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"0190307963627d0e9b414d038fd396fe"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}},{"bool":{"should":[{"bool":{"must":[{"nested":{"path":"parent.swagDynamicAccessRules","query":{"terms":{"parent.swagDynamicAccessRules.id":["018c4418fa6b70e69206501ca305a339","018c4418fab27100942169d9f4f972b5","018c4418fb697089b4105d454ff53c36","018c44192de470828312e8074b88e33e","0195a39cac8f7184b89d79acff8b5c7c","0192b8ddb4ee76a3ac6b82e3b8d43e6d","0192b98b93437a7aa639ab0dff2c5408","0192f669841276bf991799df8ff204df","0194a7fbc80971d8a909a66ed475575c","0194a836ec8c70afb734c53018ddab65","0194a83a2012708b9e41108a5c98cdae","0194a83dc1a274fd85d8ad67417f3024","0194a83e7ee97910a4fa1a67902198ff","0194a83ee6377cdab21b148d34b4d6c9","0194a83f8aa577429ab84305c276cc83","0194a8403f497262880a4c79ade66e2b","0194a840e033727fbaf8c7580054a815","0194a841bad97a51832d50e9f0b77cfb","0194a842419174ddb8c93930e9034281","0194a843103f704e9b4eb8f7466e24fd","0194a84393b27d1db64cb9af1436bf8e","0194a844bd9d7acd894d13f0a10afbb8","0194a8458ec07277bfe9dde7be03269f","0194a84610807c428badf27c745d237a","0194a8347d7373a2936d1e3532c1016c","018c4418fb6471e89cd37d82a7ef7bf5","0194937b525c7a238da1b92ee06c4aa1"]}}}},{"nested":{"path":"swagDynamicAccessRules","query":{"bool":{"must_not":[{"exists":{"field":"swagDynamicAccessRules.id"}}]}}}}]}},{"nested":{"path":"swagDynamicAccessRules","query":{"terms":{"swagDynamicAccessRules.id":["018c4418fa6b70e69206501ca305a339","018c4418fab27100942169d9f4f972b5","018c4418fb697089b4105d454ff53c36","018c44192de470828312e8074b88e33e","0195a39cac8f7184b89d79acff8b5c7c","0192b8ddb4ee76a3ac6b82e3b8d43e6d","0192b98b93437a7aa639ab0dff2c5408","0192f669841276bf991799df8ff204df","0194a7fbc80971d8a909a66ed475575c","0194a836ec8c70afb734c53018ddab65","0194a83a2012708b9e41108a5c98cdae","0194a83dc1a274fd85d8ad67417f3024","0194a83e7ee97910a4fa1a67902198ff","0194a83ee6377cdab21b148d34b4d6c9","0194a83f8aa577429ab84305c276cc83","0194a8403f497262880a4c79ade66e2b","0194a840e033727fbaf8c7580054a815","0194a841bad97a51832d50e9f0b77cfb","0194a842419174ddb8c93930e9034281","0194a843103f704e9b4eb8f7466e24fd","0194a84393b27d1db64cb9af1436bf8e","0194a844bd9d7acd894d13f0a10afbb8","0194a8458ec07277bfe9dde7be03269f","0194a84610807c428badf27c745d237a","0194a8347d7373a2936d1e3532c1016c","018c4418fb6471e89cd37d82a7ef7bf5","0194937b525c7a238da1b92ee06c4aa1"]}}}},{"bool":{"must":[{"nested":{"path":"parent.swagDynamicAccessRules","query":{"bool":{"must_not":[{"exists":{"field":"parent.swagDynamicAccessRules.id"}}]}}}},{"nested":{"path":"swagDynamicAccessRules","query":{"bool":{"must_not":[{"exists":{"field":"swagDynamicAccessRules.id"}}]}}}}]}}]}}]}}]}},"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_rule018c4418fa6b70e69206501ca305a339_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule018c4418fab27100942169d9f4f972b5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule018c4418fb697089b4105d454ff53c36_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule018c44192de470828312e8074b88e33e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0195a39cac8f7184b89d79acff8b5c7c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0192b8ddb4ee76a3ac6b82e3b8d43e6d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0192b98b93437a7aa639ab0dff2c5408_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0192f669841276bf991799df8ff204df_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0194a7fbc80971d8a909a66ed475575c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0194a836ec8c70afb734c53018ddab65_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0194a83a2012708b9e41108a5c98cdae_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0194a83dc1a274fd85d8ad67417f3024_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0194a83e7ee97910a4fa1a67902198ff_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0194a83ee6377cdab21b148d34b4d6c9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0194a83f8aa577429ab84305c276cc83_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0194a8403f497262880a4c79ade66e2b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0194a840e033727fbaf8c7580054a815_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0194a841bad97a51832d50e9f0b77cfb_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0194a842419174ddb8c93930e9034281_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0194a843103f704e9b4eb8f7466e24fd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0194a84393b27d1db64cb9af1436bf8e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0194a844bd9d7acd894d13f0a10afbb8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0194a8458ec07277bfe9dde7be03269f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0194a84610807c428badf27c745d237a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0194a8347d7373a2936d1e3532c1016c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule018c4418fb6471e89cd37d82a7ef7bf5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0194937b525c7a238da1b92ee06c4aa1_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}}}}},"size":0,"timeout":"5s"},"search_type":"query_then_fetch"}
POST https://10.10.1.5:9200/sw_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": "018c441a15d77028a057088b5c4e9b69"
}
}
]
}
}
}
},
{
"term": {
"active": true
}
}
]
}
},
{
"nested": {
"path": "categoriesRo",
"query": {
"term": {
"categoriesRo.id": "0190307963627d0e9b414d038fd396fe"
}
}
}
},
{
"bool": {
"must_not": [
{
"bool": {
"must_not": [
{
"exists": {
"field": "displayGroup"
}
}
]
}
}
]
}
},
{
"bool": {
"should": [
{
"bool": {
"must": [
{
"nested": {
"path": "parent.swagDynamicAccessRules",
"query": {
"terms": {
"parent.swagDynamicAccessRules.id": [
"018c4418fa6b70e69206501ca305a339",
"018c4418fab27100942169d9f4f972b5",
"018c4418fb697089b4105d454ff53c36",
"018c44192de470828312e8074b88e33e",
"0195a39cac8f7184b89d79acff8b5c7c",
"0192b8ddb4ee76a3ac6b82e3b8d43e6d",
"0192b98b93437a7aa639ab0dff2c5408",
"0192f669841276bf991799df8ff204df",
"0194a7fbc80971d8a909a66ed475575c",
"0194a836ec8c70afb734c53018ddab65",
"0194a83a2012708b9e41108a5c98cdae",
"0194a83dc1a274fd85d8ad67417f3024",
"0194a83e7ee97910a4fa1a67902198ff",
"0194a83ee6377cdab21b148d34b4d6c9",
"0194a83f8aa577429ab84305c276cc83",
"0194a8403f497262880a4c79ade66e2b",
"0194a840e033727fbaf8c7580054a815",
"0194a841bad97a51832d50e9f0b77cfb",
"0194a842419174ddb8c93930e9034281",
"0194a843103f704e9b4eb8f7466e24fd",
"0194a84393b27d1db64cb9af1436bf8e",
"0194a844bd9d7acd894d13f0a10afbb8",
"0194a8458ec07277bfe9dde7be03269f",
"0194a84610807c428badf27c745d237a",
"0194a8347d7373a2936d1e3532c1016c",
"018c4418fb6471e89cd37d82a7ef7bf5",
"0194937b525c7a238da1b92ee06c4aa1"
]
}
}
}
},
{
"nested": {
"path": "swagDynamicAccessRules",
"query": {
"bool": {
"must_not": [
{
"exists": {
"field": "swagDynamicAccessRules.id"
}
}
]
}
}
}
}
]
}
},
{
"nested": {
"path": "swagDynamicAccessRules",
"query": {
"terms": {
"swagDynamicAccessRules.id": [
"018c4418fa6b70e69206501ca305a339",
"018c4418fab27100942169d9f4f972b5",
"018c4418fb697089b4105d454ff53c36",
"018c44192de470828312e8074b88e33e",
"0195a39cac8f7184b89d79acff8b5c7c",
"0192b8ddb4ee76a3ac6b82e3b8d43e6d",
"0192b98b93437a7aa639ab0dff2c5408",
"0192f669841276bf991799df8ff204df",
"0194a7fbc80971d8a909a66ed475575c",
"0194a836ec8c70afb734c53018ddab65",
"0194a83a2012708b9e41108a5c98cdae",
"0194a83dc1a274fd85d8ad67417f3024",
"0194a83e7ee97910a4fa1a67902198ff",
"0194a83ee6377cdab21b148d34b4d6c9",
"0194a83f8aa577429ab84305c276cc83",
"0194a8403f497262880a4c79ade66e2b",
"0194a840e033727fbaf8c7580054a815",
"0194a841bad97a51832d50e9f0b77cfb",
"0194a842419174ddb8c93930e9034281",
"0194a843103f704e9b4eb8f7466e24fd",
"0194a84393b27d1db64cb9af1436bf8e",
"0194a844bd9d7acd894d13f0a10afbb8",
"0194a8458ec07277bfe9dde7be03269f",
"0194a84610807c428badf27c745d237a",
"0194a8347d7373a2936d1e3532c1016c",
"018c4418fb6471e89cd37d82a7ef7bf5",
"0194937b525c7a238da1b92ee06c4aa1"
]
}
}
}
},
{
"bool": {
"must": [
{
"nested": {
"path": "parent.swagDynamicAccessRules",
"query": {
"bool": {
"must_not": [
{
"exists": {
"field": "parent.swagDynamicAccessRules.id"
}
}
]
}
}
}
},
{
"nested": {
"path": "swagDynamicAccessRules",
"query": {
"bool": {
"must_not": [
{
"exists": {
"field": "swagDynamicAccessRules.id"
}
}
]
}
}
}
}
]
}
}
]
}
}
]
}
}
]
}
},
"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_rule018c4418fa6b70e69206501ca305a339_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule018c4418fab27100942169d9f4f972b5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule018c4418fb697089b4105d454ff53c36_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule018c44192de470828312e8074b88e33e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0195a39cac8f7184b89d79acff8b5c7c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0192b8ddb4ee76a3ac6b82e3b8d43e6d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0192b98b93437a7aa639ab0dff2c5408_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0192f669841276bf991799df8ff204df_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0194a7fbc80971d8a909a66ed475575c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0194a836ec8c70afb734c53018ddab65_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0194a83a2012708b9e41108a5c98cdae_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0194a83dc1a274fd85d8ad67417f3024_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0194a83e7ee97910a4fa1a67902198ff_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0194a83ee6377cdab21b148d34b4d6c9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0194a83f8aa577429ab84305c276cc83_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0194a8403f497262880a4c79ade66e2b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0194a840e033727fbaf8c7580054a815_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0194a841bad97a51832d50e9f0b77cfb_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0194a842419174ddb8c93930e9034281_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0194a843103f704e9b4eb8f7466e24fd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0194a84393b27d1db64cb9af1436bf8e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0194a844bd9d7acd894d13f0a10afbb8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0194a8458ec07277bfe9dde7be03269f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0194a84610807c428badf27c745d237a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0194a8347d7373a2936d1e3532c1016c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule018c4418fb6471e89cd37d82a7ef7bf5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
"factor": 1
},
{
"key": "cheapest_price_rule0194937b525c7a238da1b92ee06c4aa1_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
}
}
}
}
},
"size": 0,
"timeout": "5s"
}
{
"took": 6,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"max_score": null,
"hits": []
},
"aggregations": {
"shipping-free-filter": {
"doc_count": 0,
"shipping-free": {
"value": null
}
},
"rating-exists": {
"doc_count": 2,
"rating": {
"value": 0.0
}
},
"price": {
"count": 2,
"min": 349.47,
"max": 468.71,
"avg": 409.09000000000003,
"sum": 818.1800000000001
},
"options": {
"doc_count": 2,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "0194a888e77972e5a07f25c02757ca4c",
"doc_count": 1
},
{
"key": "0194a889a513726095acbf542214d535",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 89,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "0193a87190f471e3aca5ddd1a5d12030",
"doc_count": 2
},
{
"key": "0193a8719107713387d0dcb2f21bfdde",
"doc_count": 2
},
{
"key": "0193a8719127736cb59d64cc1b877f30",
"doc_count": 2
},
{
"key": "0193a8719138723f9f2813b3e9b2f6db",
"doc_count": 2
},
{
"key": "0193a871916e73749120ef91e33e0eeb",
"doc_count": 2
},
{
"key": "0193a87191b172708180a489b94f87df",
"doc_count": 2
},
{
"key": "0193a87191c2709292a220a65531a4d8",
"doc_count": 2
},
{
"key": "0193a87191d471468377642e19853a92",
"doc_count": 2
},
{
"key": "0193a87191e67017ad9902fbace63bfb",
"doc_count": 2
},
{
"key": "0193a871920872919bf8b4b25e5fd825",
"doc_count": 2
},
{
"key": "0193a871927170d2b60fbc31785eb4c7",
"doc_count": 2
},
{
"key": "0193a8719281732fab9b8d6948e0952c",
"doc_count": 2
},
{
"key": "0193a87192b273c897de5fd74efb5b45",
"doc_count": 2
},
{
"key": "0193a8719318705c89eb3266d4b43571",
"doc_count": 2
},
{
"key": "0193a8719366735ab96ad3f5d1594c84",
"doc_count": 2
},
{
"key": "0193a87193ba726ba1210a796467f13a",
"doc_count": 2
},
{
"key": "0193a871f9e272648b53b7f1320a156c",
"doc_count": 2
},
{
"key": "0193a8724642704e89c9b872fabca74c",
"doc_count": 2
},
{
"key": "0193a87263c9720b81a241c287f3a990",
"doc_count": 2
},
{
"key": "0193a8728d3871bfbd74ef8a70290459",
"doc_count": 2
},
{
"key": "0193a872e6917162be16db0802efbab4",
"doc_count": 2
},
{
"key": "0193a872e6c9710fa26f64b09d229280",
"doc_count": 2
},
{
"key": "0193a873024771e59d7cd55dd8c7f5ff",
"doc_count": 2
},
{
"key": "0193a8730bf37272a026a3483e2da71a",
"doc_count": 2
},
{
"key": "0193a8730c1d71ff99d89f33653271ed",
"doc_count": 2
},
{
"key": "0193a87330cc71f48df23f4c6c33e8bf",
"doc_count": 2
},
{
"key": "0193a87330ed7147b553bb17142a5c5e",
"doc_count": 2
},
{
"key": "0193a87537dc71cc8a7d9240f6d48486",
"doc_count": 2
},
{
"key": "0193a89544857001932d8c1415e48514",
"doc_count": 2
},
{
"key": "0193a9dfd45a73f9b82f0f64cf78010f",
"doc_count": 2
},
{
"key": "0193a9dfd4757066b2f0e9c4e6f17db6",
"doc_count": 2
},
{
"key": "0193a9dfd47e71aaa1125b9649ba87be",
"doc_count": 2
},
{
"key": "0194a6a7e7a37284862b76cd80c183f2",
"doc_count": 2
},
{
"key": "0194a6a7e7b47033aea0511506300e26",
"doc_count": 2
},
{
"key": "0199acbd4eee73b7a5be696018335c17",
"doc_count": 2
},
{
"key": "0193a87192f471a08be65222fa88f495",
"doc_count": 1
},
{
"key": "0193a8719329726a94ea146fbb924ef5",
"doc_count": 1
},
{
"key": "0193a8719c4d7232aae125bbf9d1d202",
"doc_count": 1
},
{
"key": "0193a871fa1a710caf29db4865d34eed",
"doc_count": 1
},
{
"key": "0193a871fa237080b82c1763d6e53b58",
"doc_count": 1
},
{
"key": "0193a871fa46713095290cce2130c4ce",
"doc_count": 1
},
{
"key": "0193a8720b2171b99f0c941cf9a9217a",
"doc_count": 1
},
{
"key": "0193a8722c3d725289ea642d49c726e6",
"doc_count": 1
},
{
"key": "0193a872466f72f9b276459c9c59251e",
"doc_count": 1
},
{
"key": "0193a872e6b973cbbc820f010e4ff237",
"doc_count": 1
},
{
"key": "0193a89b09d9704b9042c44fc0f298ca",
"doc_count": 1
},
{
"key": "0193a89b09e17205b9a9b9b5e491b643",
"doc_count": 1
},
{
"key": "0194a4f092fc709d822268efe210a179",
"doc_count": 1
},
{
"key": "0194a5d748ab72af9a8da61a52b49ed8",
"doc_count": 1
},
{
"key": "0194a6a7e7c171b890c3070ce3d7af0b",
"doc_count": 1
},
{
"key": "0194a6a7e7d070bc8acc5e02311c037d",
"doc_count": 1
},
{
"key": "0194a6a8777b7001b69c99e69d40180b",
"doc_count": 1
},
{
"key": "0194a6a87786703bb48d07d39d1c4db9",
"doc_count": 1
},
{
"key": "0199cba3cb3d7392bdf9d7486e799b90",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": []
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|