| 1 |
146.67 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}}]}},{"bool":{"should":[{"term":{"productNumber":"86000016"}},{"term":{"productNumber":"86000017"}},{"term":{"productNumber":"86000018"}},{"term":{"productNumber":"86000019"}},{"term":{"productNumber":"64000002"}},{"term":{"productNumber":"96086002"}}]}},{"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","0192b898b715744a99f9c5f61d439c2d","0192b8ddb4ee76a3ac6b82e3b8d43e6d","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","0192b898b715744a99f9c5f61d439c2d","0192b8ddb4ee76a3ac6b82e3b8d43e6d","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":["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
}
}
]
}
},
{
"bool": {
"should": [
{
"term": {
"productNumber": "86000016"
}
},
{
"term": {
"productNumber": "86000017"
}
},
{
"term": {
"productNumber": "86000018"
}
},
{
"term": {
"productNumber": "86000019"
}
},
{
"term": {
"productNumber": "64000002"
}
},
{
"term": {
"productNumber": "96086002"
}
}
]
}
},
{
"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",
"0192b898b715744a99f9c5f61d439c2d",
"0192b8ddb4ee76a3ac6b82e3b8d43e6d",
"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",
"0192b898b715744a99f9c5f61d439c2d",
"0192b8ddb4ee76a3ac6b82e3b8d43e6d",
"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": [
"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": 17,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 1,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_product_1772854806",
"_id": "0194a9b948df727591c748d0b48985e4",
"_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": "019c3ba007517026ba950895e71e4678",
"_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": "0194a9b948df727591c748d0b48985e4",
"autoIncrement": 11172.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": 25,
"productNumber": "96086002",
"ean": null,
"displayGroup": "97b57725d792accee52ed2a0ec35c1f3",
"sales": 0,
"stock": 25,
"weight": 0.204,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": null,
"manufacturerNumber": null,
"deliveryTimeId": null,
"releaseDate": null,
"createdAt": "2025-01-27T21:44:58+00:00",
"categoryTree": [],
"categoriesRo": [],
"taxId": "018c4418fad37041a0e90672f2cf1d8e",
"tags": [],
"parentId": "0194a9b9314b721b820826835aa59143",
"coverId": "0194a9e46601718d911e6d1cb9706c6e",
"childCount": 0,
"categories": [],
"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": "0193a87191167308ba7c2784241590c3",
"_count": 1,
"groupId": "0193a871910e719ba3e1d770c7352ab8",
"group": {
"id": "0193a871910e719ba3e1d770c7352ab8",
"_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": "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": "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": "0193a871924f7211a7efc0a4df00dd83",
"_count": 1,
"groupId": "0193a8719247726a9f4224b107fb6066",
"group": {
"id": "0193a8719247726a9f4224b107fb6066",
"_count": 1
},
"name": {
"018dcfe159447f0babc72dd985fa25ba": "Nero",
"018dcfdcc7527afda4d7e8943c89a90b": "Noir",
"018c441a028a73d09246e628782bdd72": "Black",
"018dcfdf67ff7019ae54528e014b46c3": "Negro",
"018dcfe1c522789e871b753174b3b10f": "Zwart",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "\u9ed1\u8272",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Schwarz"
}
},
{
"id": "0193a87192e47320b128728541a38ac7",
"_count": 1,
"groupId": "0193a87192dc7073929ec7af3856ffdf",
"group": {
"id": "0193a87192dc7073929ec7af3856ffdf",
"_count": 1
},
"name": {
"018c441a028a73d09246e628782bdd72": "115-230V",
"018dcfdcc7527afda4d7e8943c89a90b": "115-230V",
"018dcfdf67ff7019ae54528e014b46c3": "115-230V",
"018dcfe159447f0babc72dd985fa25ba": "115-230V",
"018dcfe1c522789e871b753174b3b10f": "115-230V",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "115-230V",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "115-230V"
}
},
{
"id": "0193a87192f471a08be65222fa88f495",
"_count": 1,
"groupId": "0193a87192eb708eb4e4fb4db4d4e254",
"group": {
"id": "0193a87192eb708eb4e4fb4db4d4e254",
"_count": 1
},
"name": {
"018c441a028a73d09246e628782bdd72": "AC",
"018dcfdcc7527afda4d7e8943c89a90b": "AC",
"018dcfdf67ff7019ae54528e014b46c3": "AC",
"018dcfe159447f0babc72dd985fa25ba": "AC",
"018dcfe1c522789e871b753174b3b10f": "AC",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "AC",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AC"
}
},
{
"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": "0193a8719329726a94ea146fbb924ef5",
"_count": 1,
"groupId": "0193a871932073bbb2f0b6580f68a50c",
"group": {
"id": "0193a871932073bbb2f0b6580f68a50c",
"_count": 1
},
"name": {
"018c441a028a73d09246e628782bdd72": "230 VAC",
"018dcfdcc7527afda4d7e8943c89a90b": "230 VAC",
"018dcfdf67ff7019ae54528e014b46c3": "230 VAC",
"018dcfe159447f0babc72dd985fa25ba": "230 VAC",
"018dcfe1c522789e871b753174b3b10f": "230 VAC",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "230 VAC",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "230 VAC"
}
},
{
"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": "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": "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": "0193a88a5873729c97114b4ff752019c",
"_count": 1,
"groupId": "0193a8718fbd72539ef3a00ec205c5ef",
"group": {
"id": "0193a8718fbd72539ef3a00ec205c5ef",
"_count": 1
},
"name": {
"018c441a028a73d09246e628782bdd72": "No",
"018dcfdcc7527afda4d7e8943c89a90b": "No",
"018dcfdf67ff7019ae54528e014b46c3": "No",
"018dcfe159447f0babc72dd985fa25ba": "No",
"018dcfe1c522789e871b753174b3b10f": "No",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "No",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nein"
}
},
{
"id": "0193a88a587c707a8b95512645e8ab4f",
"_count": 1,
"groupId": "0193a8719199734e88df72a7898291d3",
"group": {
"id": "0193a8719199734e88df72a7898291d3",
"_count": 1
},
"name": {
"018c441a028a73d09246e628782bdd72": "No",
"018dcfdf67ff7019ae54528e014b46c3": "No",
"018dcfe159447f0babc72dd985fa25ba": "No",
"018dcfe1c522789e871b753174b3b10f": "Nee",
"018dcfdcc7527afda4d7e8943c89a90b": "Non",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "\u5426",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nein"
}
},
{
"id": "0193a9af524471a58328f6dd898f4b7f",
"_count": 1,
"groupId": "0193a871916572f6885055b69563c6e7",
"group": {
"id": "0193a871916572f6885055b69563c6e7",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ja",
"018c441a028a73d09246e628782bdd72": "Yes",
"018dcfdcc7527afda4d7e8943c89a90b": "Yes",
"018dcfdf67ff7019ae54528e014b46c3": "Yes",
"018dcfe159447f0babc72dd985fa25ba": "Yes",
"018dcfe1c522789e871b753174b3b10f": "Yes",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "Yes"
}
},
{
"id": "0194842074a97141b87a4a7eb0afcec8",
"_count": 1,
"groupId": "0193a87192fd70f6b02053447be9b935",
"group": {
"id": "0193a87192fd70f6b02053447be9b935",
"_count": 1
},
"name": {
"018dcfdf67ff7019ae54528e014b46c3": "50Hz a 230V; 60Hz a 115V",
"018dcfe159447f0babc72dd985fa25ba": "50Hz a 230V; 60Hz a 115V",
"018c441a028a73d09246e628782bdd72": "50Hz at 230V; 60Hz at 115V",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "50Hz at 230V; 60Hz at 115V",
"018dcfdcc7527afda4d7e8943c89a90b": "50Hz \u00e0 230V; 60Hz \u00e0 115V",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "50Hz bei 230V; 60Hz bei 115V",
"018dcfe1c522789e871b753174b3b10f": "50Hz bij 230V; 60Hz bij 115V"
}
},
{
"id": "0194a567751f72c3a6aa452f8f7a942f",
"_count": 1,
"groupId": "0193a87192bb70ef9a63cab928fbca5e",
"group": {
"id": "0193a87192bb70ef9a63cab928fbca5e",
"_count": 1
},
"name": {
"018c441a028a73d09246e628782bdd72": "204",
"018dcfdcc7527afda4d7e8943c89a90b": "204",
"018dcfdf67ff7019ae54528e014b46c3": "204",
"018dcfe159447f0babc72dd985fa25ba": "204",
"018dcfe1c522789e871b753174b3b10f": "204",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "204",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "204,00 g"
}
},
{
"id": "0194a689e8dd72fbbe117a4380d342d6",
"_count": 1,
"groupId": "0193a87192cc72098f2de9d6b5b55f9d",
"group": {
"id": "0193a87192cc72098f2de9d6b5b55f9d",
"_count": 1
},
"name": {
"018c441a028a73d09246e628782bdd72": "178",
"018dcfdcc7527afda4d7e8943c89a90b": "178",
"018dcfdf67ff7019ae54528e014b46c3": "178",
"018dcfe159447f0babc72dd985fa25ba": "178",
"018dcfe1c522789e871b753174b3b10f": "178",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "178",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "178,00 g"
}
},
{
"id": "0194a6eba0f872f598a9322ddbd7e145",
"_count": 1,
"groupId": "0193a872e63e71aa804a8ab10b913326",
"group": {
"id": "0193a872e63e71aa804a8ab10b913326",
"_count": 1
},
"name": {
"018c441a028a73d09246e628782bdd72": "46",
"018dcfdcc7527afda4d7e8943c89a90b": "46",
"018dcfdf67ff7019ae54528e014b46c3": "46",
"018dcfe159447f0babc72dd985fa25ba": "46",
"018dcfe1c522789e871b753174b3b10f": "46",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "46",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "46,00 mm"
}
},
{
"id": "0194a6eba10573fe92fbf2cdd9244c89",
"_count": 1,
"groupId": "0193a872e64e714d8c881bb3b5f331d6",
"group": {
"id": "0193a872e64e714d8c881bb3b5f331d6",
"_count": 1
},
"name": {
"018c441a028a73d09246e628782bdd72": "37",
"018dcfdcc7527afda4d7e8943c89a90b": "37",
"018dcfdf67ff7019ae54528e014b46c3": "37",
"018dcfe159447f0babc72dd985fa25ba": "37",
"018dcfe1c522789e871b753174b3b10f": "37",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "37",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "37,00 mm"
}
},
{
"id": "0194a6eba1137138ba609d05fa636dc6",
"_count": 1,
"groupId": "0193a871921270e19420f5ee8427741a",
"group": {
"id": "0193a871921270e19420f5ee8427741a",
"_count": 1
},
"name": {
"018c441a028a73d09246e628782bdd72": "94",
"018dcfdcc7527afda4d7e8943c89a90b": "94",
"018dcfdf67ff7019ae54528e014b46c3": "94",
"018dcfe159447f0babc72dd985fa25ba": "94",
"018dcfe1c522789e871b753174b3b10f": "94",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "94",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "94,00 mm"
}
},
{
"id": "01953f68e16771c991f56231e738679a",
"_count": 1,
"groupId": "0193a87190fd717abc49700486891b20",
"group": {
"id": "0193a87190fd717abc49700486891b20",
"_count": 1
},
"name": {
"018dcfe1c522789e871b753174b3b10f": "Conform Stofbeperking",
"018dcfe159447f0babc72dd985fa25ba": "Conforme limitazione sostanze",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "erf\u00fcllt Stoffbeschr\u00e4nkungen",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "\u662f (\u9075\u5b88\u7269\u8d28\u9650\u5236\u7684\u89c4",
"018dcfdcc7527afda4d7e8943c89a90b": "Conforme limitation substances",
"018dcfdf67ff7019ae54528e014b46c3": "Cubre las reglas de sustancias",
"018c441a028a73d09246e628782bdd72": "Fulfills substance restriction"
}
},
{
"id": "0199acc182ce72a6bdf1229927c3709f",
"_count": 1,
"groupId": "0199acbd4ee572489d2f21c589fd8424",
"group": {
"id": "0199acbd4ee572489d2f21c589fd8424",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ja",
"018c441a028a73d09246e628782bdd72": "Yes",
"018dcfdcc7527afda4d7e8943c89a90b": "Yes",
"018dcfdf67ff7019ae54528e014b46c3": "Yes",
"018dcfe1c522789e871b753174b3b10f": "Yes",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "Yes"
}
}
],
"options": [
{
"id": "0194a888b15973f59e4a70766482a4ad",
"_count": 1,
"groupId": "0191b8806374734aa259d00c6b2a53d8",
"group": {
"id": "0191b8806374734aa259d00c6b2a53d8",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "115-230V AC"
}
}
],
"categoryIds": [],
"optionIds": [
"0194a888b15973f59e4a70766482a4ad"
],
"propertyIds": [
"0193a87191167308ba7c2784241590c3",
"0193a8719127736cb59d64cc1b877f30",
"0193a8719138723f9f2813b3e9b2f6db",
"0193a87191b172708180a489b94f87df",
"0193a87191c2709292a220a65531a4d8",
"0193a87191d471468377642e19853a92",
"0193a871920872919bf8b4b25e5fd825",
"0193a871924f7211a7efc0a4df00dd83",
"0193a87192e47320b128728541a38ac7",
"0193a87192f471a08be65222fa88f495",
"0193a8719318705c89eb3266d4b43571",
"0193a8719329726a94ea146fbb924ef5",
"0193a871f9e272648b53b7f1320a156c",
"0193a8724642704e89c9b872fabca74c",
"0193a87537dc71cc8a7d9240f6d48486",
"0193a88a5873729c97114b4ff752019c",
"0193a88a587c707a8b95512645e8ab4f",
"0193a9af524471a58328f6dd898f4b7f",
"0194842074a97141b87a4a7eb0afcec8",
"0194a567751f72c3a6aa452f8f7a942f",
"0194a689e8dd72fbbe117a4380d342d6",
"0194a6eba0f872f598a9322ddbd7e145",
"0194a6eba10573fe92fbf2cdd9244c89",
"0194a6eba1137138ba609d05fa636dc6",
"01953f68e16771c991f56231e738679a",
"0199acc182ce72a6bdf1229927c3709f"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"018c441a028a73d09246e628782bdd72": {
"additional_downloads": "{\"datasheet\":{\"mediaId\":\"01943c265bdc701ab928a5e2c31a2056\"}}"
},
"018dcfdcc7527afda4d7e8943c89a90b": {
"additional_downloads": "{\"datasheet\":{\"mediaId\":\"01943c265c7572eabd9e0750fa3a9bf5\"}}"
},
"018dcfdf67ff7019ae54528e014b46c3": {
"additional_downloads": "{\"datasheet\":{\"mediaId\":\"01943c265d06723087bb07fe2876ddeb\"}}"
},
"018dcfe159447f0babc72dd985fa25ba": {
"additional_downloads": "{\"datasheet\":{\"mediaId\":\"01943c265d9a710ea6a0a86d39184031\"}}"
},
"018dcfe1c522789e871b753174b3b10f": {
"additional_downloads": "{\"datasheet\":{\"mediaId\":\"01943c265e2b71208fa34c96d5e18ff6\"}}"
},
"018dcfe3b2ed7b778b19a53ab0f38fdd": {
"additional_downloads": "{\"datasheet\":{\"mediaId\":\"01943c265ec07142a5e50d3d3e769ee0\"}}"
},
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"additional_grp_no": "110001000010200000",
"werma_article_number": "960.860.02",
"plant_us_ca": 19.0,
"additional_downloads": "{\"datasheet\":{\"mediaId\":\"0193124874207023b70d8da2f3ca8474\"}}"
}
},
"name": {
"018c441a028a73d09246e628782bdd72": "Power supply incl. adapter 100-240VAC BK",
"018dcfdcc7527afda4d7e8943c89a90b": "Alimentation et adaptateur 100-240VAC BK",
"018dcfdf67ff7019ae54528e014b46c3": "Fuente de energ\u00eda con adaptador 100-240V",
"018dcfe159447f0babc72dd985fa25ba": "Alimentatore incl. adattatore 100-240VAC",
"018dcfe1c522789e871b753174b3b10f": "Stroomvoorziening inclusief adapter 100-",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "Power supply incl. adapter 100-240VAC BK",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Netzteil inkl. Adapter 100-240VAC BK"
},
"description": {
"018c441a028a73d09246e628782bdd72": "Power supply unit for connection sets with plug.The power supply unit comes with an EU, UK and US adapter.",
"018dcfdcc7527afda4d7e8943c89a90b": "Unit\u00e9 d'alimentation pour les ensembles de connexion avec priseLe bloc d'alimentation est livr\u00e9 avec un adaptateur pour l'UE, le",
"018dcfdf67ff7019ae54528e014b46c3": "Fuente de alimentaci\u00f3n para juegos de conexi\u00f3n con enchufe hueco.La fuente de alimentaci\u00f3n incluye un adaptador para la UE, el Reino",
"018dcfe159447f0babc72dd985fa25ba": "Alimentatore per set di collegamento con presa cava.L'alimentatore \u00e8 dotato di un adattatore UE, UK e USA.",
"018dcfe1c522789e871b753174b3b10f": "Voedingseenheid voor aansluitsets met stekker.De voedingseenheid wordt geleverd met een adapter voor de EU, UK en",
"018dcfe3b2ed7b778b19a53ab0f38fdd": "Power supply unit for connection sets with plug.The power supply unit comes with an EU, UK and US adapter.",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Netzteil f\u00fcr Anschluss-Sets mit Hohlbuchse.Dem Netzteil liegen ein EU-, UK- und US-Adapter bei."
},
"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": 36.95,
"cheapest_price_rule0192b8c104d5720c8cc277b787a407c3_currency018c4418fa4871c9805a5f0b4d28930b_net": 36.95,
"cheapest_price_rule0192b8c104d5720c8cc277b787a407c3_currency018c4418fa4871c9805a5f0b4e05212d_gross": 27.31,
"cheapest_price_rule0192b8c104d5720c8cc277b787a407c3_currency018c4418fa4871c9805a5f0b4e05212d_net": 27.31,
"cheapest_price_rule0192b8c104d5720c8cc277b787a407c3_currency018c44191f84725c9aee2a829d557a63_gross": 30.84,
"cheapest_price_rule0192b8c104d5720c8cc277b787a407c3_currency018c44191f84725c9aee2a829d557a63_net": 30.84,
"cheapest_price_rule0192b8c104d5720c8cc277b787a407c3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 32.13,
"cheapest_price_rule0192b8c104d5720c8cc277b787a407c3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 32.13,
"cheapest_price_rule0195cd9f3a9b70de90a64df7fe7e97d5_currency018c4418fa4871c9805a5f0b4d28930b_gross": 36.95,
"cheapest_price_rule0195cd9f3a9b70de90a64df7fe7e97d5_currency018c4418fa4871c9805a5f0b4d28930b_net": 36.95,
"cheapest_price_rule0195cd9f3a9b70de90a64df7fe7e97d5_currency018c4418fa4871c9805a5f0b4e05212d_gross": 27.31,
"cheapest_price_rule0195cd9f3a9b70de90a64df7fe7e97d5_currency018c4418fa4871c9805a5f0b4e05212d_net": 27.31,
"cheapest_price_rule0195cd9f3a9b70de90a64df7fe7e97d5_currency018c44191f84725c9aee2a829d557a63_gross": 30.84,
"cheapest_price_rule0195cd9f3a9b70de90a64df7fe7e97d5_currency018c44191f84725c9aee2a829d557a63_net": 30.84,
"cheapest_price_rule0195cd9f3a9b70de90a64df7fe7e97d5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 32.13,
"cheapest_price_rule0195cd9f3a9b70de90a64df7fe7e97d5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 32.13,
"cheapest_price_rule0194884696027f609aad4efeaa36863a_currency018c4418fa4871c9805a5f0b4d28930b_gross": 48.035,
"cheapest_price_rule0194884696027f609aad4efeaa36863a_currency018c4418fa4871c9805a5f0b4d28930b_net": 48.035,
"cheapest_price_rule0194884696027f609aad4efeaa36863a_currency018c4418fa4871c9805a5f0b4e05212d_gross": 35.503,
"cheapest_price_rule0194884696027f609aad4efeaa36863a_currency018c4418fa4871c9805a5f0b4e05212d_net": 35.503,
"cheapest_price_rule0194884696027f609aad4efeaa36863a_currency018c44191f84725c9aee2a829d557a63_gross": 40.092,
"cheapest_price_rule0194884696027f609aad4efeaa36863a_currency018c44191f84725c9aee2a829d557a63_net": 40.092,
"cheapest_price_rule0194884696027f609aad4efeaa36863a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 41.769000000000005,
"cheapest_price_rule0194884696027f609aad4efeaa36863a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 41.769000000000005,
"cheapest_price_rule019488482b9d7801a9f1ad9141bf4340_currency018c4418fa4871c9805a5f0b4d28930b_gross": 84.06125,
"cheapest_price_rule019488482b9d7801a9f1ad9141bf4340_currency018c4418fa4871c9805a5f0b4d28930b_net": 84.06125,
"cheapest_price_rule019488482b9d7801a9f1ad9141bf4340_currency018c4418fa4871c9805a5f0b4e05212d_gross": 62.13025,
"cheapest_price_rule019488482b9d7801a9f1ad9141bf4340_currency018c4418fa4871c9805a5f0b4e05212d_net": 62.13025,
"cheapest_price_rule019488482b9d7801a9f1ad9141bf4340_currency018c44191f84725c9aee2a829d557a63_gross": 70.161,
"cheapest_price_rule019488482b9d7801a9f1ad9141bf4340_currency018c44191f84725c9aee2a829d557a63_net": 70.161,
"cheapest_price_rule019488482b9d7801a9f1ad9141bf4340_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 73.09575000000001,
"cheapest_price_rule019488482b9d7801a9f1ad9141bf4340_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 73.09575000000001,
"cheapest_price_rule0192f66821f27feb9bf0006e6a603cc3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 56.23,
"cheapest_price_rule0192f66821f27feb9bf0006e6a603cc3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 56.23,
"cheapest_price_rule0192f6668a7e75ffac421df6abe479df_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 38.55,
"cheapest_price_rule0192f6668a7e75ffac421df6abe479df_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 38.55,
"cheapest_price_rule018c4418fb697089b4105d454ff53c36_currency018c4418fa4871c9805a5f0b4d28930b_gross": 80.82,
"cheapest_price_rule018c4418fb697089b4105d454ff53c36_currency018c4418fa4871c9805a5f0b4d28930b_net": 80.82,
"cheapest_price_rule018c4418fb697089b4105d454ff53c36_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 80.82,
"cheapest_price_rule018c4418fb697089b4105d454ff53c36_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 80.82,
"cheapest_price_rule01948838e9287883829705d505db9e67_currency018c4418fa4871c9805a5f0b4d28930b_gross": 80.82,
"cheapest_price_rule01948838e9287883829705d505db9e67_currency018c4418fa4871c9805a5f0b4d28930b_net": 80.82,
"cheapest_price_rule01948838e9287883829705d505db9e67_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 80.82,
"cheapest_price_rule01948838e9287883829705d505db9e67_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 80.82,
"cheapest_price_rule0192f667ac2d7192b5f83ff640899e48_currency018c44191f84725c9aee2a829d557a63_gross": 40.95,
"cheapest_price_rule0192f667ac2d7192b5f83ff640899e48_currency018c44191f84725c9aee2a829d557a63_net": 40.95,
"cheapest_price_rule0192f667ac2d7192b5f83ff640899e48_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 32.13,
"cheapest_price_rule0192f667ac2d7192b5f83ff640899e48_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 32.13,
"cheapest_price_rule0192f66525a97488a280d3c1580a35cd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 48.19,
"cheapest_price_rule0192f66525a97488a280d3c1580a35cd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 48.19,
"cheapest_price_rule0192f66725ee71fcaa9702e615e1998c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 86.89,
"cheapest_price_rule0192f66725ee71fcaa9702e615e1998c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 86.89,
"cheapest_price_ruledefault_currency018c4418fa4871c9805a5f0b4d28930b_gross": 36.95,
"cheapest_price_ruledefault_currency018c4418fa4871c9805a5f0b4d28930b_net": 36.95,
"cheapest_price_ruledefault_currency018c4418fa4871c9805a5f0b4e05212d_gross": 27.31,
"cheapest_price_ruledefault_currency018c4418fa4871c9805a5f0b4e05212d_net": 27.31,
"cheapest_price_ruledefault_currency018c44191f84725c9aee2a829d557a63_gross": 30.84,
"cheapest_price_ruledefault_currency018c44191f84725c9aee2a829d557a63_net": 30.84,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 32.13,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 32.13,
"warehouseGroups": [
{
"id": null,
"_count": 0
}
],
"completion": [
{
"key": "all",
"value": "96086002"
},
{
"key": "018c441a028a73d09246e628782bdd72",
"value": "power"
},
{
"key": "018c441a028a73d09246e628782bdd72",
"value": "supply"
},
{
"key": "018c441a028a73d09246e628782bdd72",
"value": "incl."
},
{
"key": "018c441a028a73d09246e628782bdd72",
"value": "adapter"
},
{
"key": "018c441a028a73d09246e628782bdd72",
"value": "100-240vac"
},
{
"key": "018c441a028a73d09246e628782bdd72",
"value": "power supply incl. adapter 100-240vac bk"
},
{
"key": "018dcfdcc7527afda4d7e8943c89a90b",
"value": "alimentation"
},
{
"key": "018dcfdcc7527afda4d7e8943c89a90b",
"value": "adaptateur"
},
{
"key": "018dcfdcc7527afda4d7e8943c89a90b",
"value": "100-240vac"
},
{
"key": "018dcfdcc7527afda4d7e8943c89a90b",
"value": "alimentation et adaptateur 100-240vac bk"
},
{
"key": "018dcfdf67ff7019ae54528e014b46c3",
"value": "fuente"
},
{
"key": "018dcfdf67ff7019ae54528e014b46c3",
"value": "energ\u00eda"
},
{
"key": "018dcfdf67ff7019ae54528e014b46c3",
"value": "con"
},
{
"key": "018dcfdf67ff7019ae54528e014b46c3",
"value": "adaptador"
},
{
"key": "018dcfdf67ff7019ae54528e014b46c3",
"value": "100-240v"
},
{
"key": "018dcfdf67ff7019ae54528e014b46c3",
"value": "fuente de energ\u00eda con adaptador 100-240v"
},
{
"key": "018dcfe159447f0babc72dd985fa25ba",
"value": "alimentatore"
},
{
"key": "018dcfe159447f0babc72dd985fa25ba",
"value": "incl."
},
{
"key": "018dcfe159447f0babc72dd985fa25ba",
"value": "adattatore"
},
{
"key": "018dcfe159447f0babc72dd985fa25ba",
"value": "100-240vac"
},
{
"key": "018dcfe159447f0babc72dd985fa25ba",
"value": "alimentatore incl. adattatore 100-240vac"
},
{
"key": "018dcfe1c522789e871b753174b3b10f",
"value": "stroomvoorziening"
},
{
"key": "018dcfe1c522789e871b753174b3b10f",
"value": "inclusief"
},
{
"key": "018dcfe1c522789e871b753174b3b10f",
"value": "adapter"
},
{
"key": "018dcfe1c522789e871b753174b3b10f",
"value": "100-"
},
{
"key": "018dcfe1c522789e871b753174b3b10f",
"value": "stroomvoorziening inclusief adapter 100-"
},
{
"key": "018dcfe3b2ed7b778b19a53ab0f38fdd",
"value": "power"
},
{
"key": "018dcfe3b2ed7b778b19a53ab0f38fdd",
"value": "supply"
},
{
"key": "018dcfe3b2ed7b778b19a53ab0f38fdd",
"value": "incl."
},
{
"key": "018dcfe3b2ed7b778b19a53ab0f38fdd",
"value": "adapter"
},
{
"key": "018dcfe3b2ed7b778b19a53ab0f38fdd",
"value": "100-240vac"
},
{
"key": "018dcfe3b2ed7b778b19a53ab0f38fdd",
"value": "power supply incl. adapter 100-240vac bk"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "netzteil"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "inkl."
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "adapter"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "100-240vac"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "netzteil inkl. adapter 100-240vac bk"
}
],
"swagDynamicAccessRules": [
{
"id": null,
"_count": 1
}
],
"parent": {
"swagDynamicAccessRules": [
{
"id": null,
"_count": 1
}
]
}
},
"fields": {
"displayGroup": [
"97b57725d792accee52ed2a0ec35c1f3"
]
},
"sort": [
5.0e-324,
0,
"0194a9b948df727591c748d0b48985e4"
]
}
]
},
"aggregations": {
"total-count": {
"value": 1
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
15.87 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}}]}},{"bool":{"should":[{"term":{"productNumber":"86000016"}},{"term":{"productNumber":"86000017"}},{"term":{"productNumber":"86000018"}},{"term":{"productNumber":"86000019"}},{"term":{"productNumber":"64000002"}},{"term":{"productNumber":"96086002"}}]}},{"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","0192b898b715744a99f9c5f61d439c2d","0192b8ddb4ee76a3ac6b82e3b8d43e6d","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","0192b898b715744a99f9c5f61d439c2d","0192b8ddb4ee76a3ac6b82e3b8d43e6d","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}},"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
}
}
]
}
},
{
"bool": {
"should": [
{
"term": {
"productNumber": "86000016"
}
},
{
"term": {
"productNumber": "86000017"
}
},
{
"term": {
"productNumber": "86000018"
}
},
{
"term": {
"productNumber": "86000019"
}
},
{
"term": {
"productNumber": "64000002"
}
},
{
"term": {
"productNumber": "96086002"
}
}
]
}
},
{
"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",
"0192b898b715744a99f9c5f61d439c2d",
"0192b8ddb4ee76a3ac6b82e3b8d43e6d",
"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",
"0192b898b715744a99f9c5f61d439c2d",
"0192b8ddb4ee76a3ac6b82e3b8d43e6d",
"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
}
},
"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"
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|