| 1 |
15.98 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":"3aaa0b8abe954c09892d40b581d29df3"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"05febc73ad52558eb2390ad9e910716b"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"sort":[{"sales":{"order":"DESC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":30,"collapse":{"field":"displayGroup"},"timeout":"5s"}}
{
"took": 13,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 5,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_product_1743509857",
"_type": "_doc",
"_id": "00d0231761ec5297b730826ff82dc1e2",
"_score": null,
"_ignored": [
"customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.importedAt"
],
"_source": {
"id": "00d0231761ec5297b730826ff82dc1e2",
"autoIncrement": 13019.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "3aaa0b8abe954c09892d40b581d29df3"
}
],
"availableStock": 1,
"productNumber": "25-76494",
"ean": "4001883764948",
"displayGroup": "5dacf0d421a059003edadcf1f5045bd0",
"sales": 0,
"stock": 1,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": null,
"manufacturerNumber": "76494",
"releaseDate": null,
"createdAt": "2024-11-22T23:58:36+00:00",
"categoryTree": [
"960adcd8bdb7465e888a7f0e0d739de3",
"e37bb61902b64d49a0a4636302925e4f",
"e463192ee1344ba785e6c3fb01c12a0b",
"05febc73ad52558eb2390ad9e910716b"
],
"categoriesRo": [
{
"id": "960adcd8bdb7465e888a7f0e0d739de3",
"_count": 1
},
{
"id": "e37bb61902b64d49a0a4636302925e4f",
"_count": 1
},
{
"id": "e463192ee1344ba785e6c3fb01c12a0b",
"_count": 1
},
{
"id": "05febc73ad52558eb2390ad9e910716b",
"_count": 1
}
],
"taxId": "8b79f09838fd4d9b8d060a8bb8c9b39d",
"tags": [],
"parentId": null,
"coverId": "840b3437fd4c5be9b685f7f01945150d",
"childCount": 0,
"categories": [
{
"id": "05febc73ad52558eb2390ad9e910716b",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Signale"
}
}
],
"manufacturer": {
"id": null,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"_count": 1
},
"properties": [
{
"id": "5c7c0cabef365bd28653e9d4e0f81045",
"_count": 1,
"groupId": "a61efc337e945b4ebe4b4c292268087c",
"group": {
"id": "a61efc337e945b4ebe4b4c292268087c",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Spur H0"
}
},
{
"id": "a7bf0a869ea95f54aad9e1cdfe705db5",
"_count": 1,
"groupId": "0670df00da5d528a9b01a0c8b8b0fe18",
"group": {
"id": "0670df00da5d528a9b01a0c8b8b0fe18",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "1:87"
}
},
{
"id": "c30a2f2cf3945026b803046029b46eac",
"_count": 1,
"groupId": "efeda729f6ff556fa8ba3db96b101583",
"group": {
"id": "efeda729f6ff556fa8ba3db96b101583",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Deutschland"
}
},
{
"id": "d415b1cb281d5d6d83b8fb3db2c53d6e",
"_count": 1,
"groupId": "f00956ca61d15e71b32bb35d68c8deef",
"group": {
"id": "f00956ca61d15e71b32bb35d68c8deef",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2014"
}
}
],
"options": [],
"categoryIds": [
"05febc73ad52558eb2390ad9e910716b"
],
"optionIds": [],
"propertyIds": [
"5c7c0cabef365bd28653e9d4e0f81045",
"a7bf0a869ea95f54aad9e1cdfe705db5",
"c30a2f2cf3945026b803046029b46eac",
"d415b1cb281d5d6d83b8fb3db2c53d6e"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"wbo": "SIG",
"isPreOrderProduct": false,
"importedAt": "2025-06-30 09:38:05.108",
"repertus_packstation_delivery_enabled": true,
"mlok_product_availability": "1",
"eva_product_rueckstand": 2.0,
"eva_product_resibestandkasse": 0.0,
"eva_product_resibestandfaktura": 0.0
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "76494 Licht Ausfahrsignal"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Vorbild: Ausfahrsignal in Einheitsbauart der Deutschen Bundesbahn (DB). 4 Stellungen: \"Halt\" - rot\/rot (Hp00), \"Fahrt\" - gr\u00fcn (Hp1) und \"Langsamfahrt\" - gr\u00fcn\/gelb (Hp2) sowie \"Zughalt, Rangieren erlaubt\" - rot\/wei\u00df\/wei\u00df (Hp0\/Sh1).\n\nModell: Mit integrierter Signalelektronik und 1 separaten Signaldecoder. Steuerung aller Funktionen \u00fcber zugeh\u00f6rigen Signaldecoder im Digital-System oder mit Stellpult 72760 bei konventionellen Anlagen m\u00f6glich. Signaldecoder kann unter dem C-Gleis oder unter der Anlage eingebaut werden. F\u00fcr Digital-Betrieb k\u00f6nnen die Konfiguration und die Adresse vor dem Einbau zugewiesen und getestet werden. Am Signaldecoder Anschl\u00fcsse f\u00fcr die Zugbeeinflussung und f\u00fcr 1 Vorsignal. H\u00f6he ohne Sockel 78 mm."
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 83.7,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 70.33613445378151,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 9.99,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 9.99
},
"fields": {
"displayGroup": [
"5dacf0d421a059003edadcf1f5045bd0"
]
},
"sort": [
0,
"00d0231761ec5297b730826ff82dc1e2"
]
},
{
"_index": "sw_product_1743509857",
"_type": "_doc",
"_id": "30589311e9725c73ae2ff71a32f55cc6",
"_score": null,
"_ignored": [
"customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.importedAt"
],
"_source": {
"id": "30589311e9725c73ae2ff71a32f55cc6",
"autoIncrement": 88728.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "3aaa0b8abe954c09892d40b581d29df3"
}
],
"availableStock": 0,
"productNumber": "32-40021",
"ean": "9005033400217",
"displayGroup": "6de49719f138bfe7fa3284353809cf7c",
"sales": 0,
"stock": 0,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "b22980915e045ea79d6da709a178ca41",
"manufacturerNumber": "40021",
"releaseDate": null,
"createdAt": "2025-07-06T16:13:52+00:00",
"categoryTree": [
"960adcd8bdb7465e888a7f0e0d739de3",
"e37bb61902b64d49a0a4636302925e4f",
"e463192ee1344ba785e6c3fb01c12a0b",
"05febc73ad52558eb2390ad9e910716b"
],
"categoriesRo": [
{
"id": "960adcd8bdb7465e888a7f0e0d739de3",
"_count": 1
},
{
"id": "e37bb61902b64d49a0a4636302925e4f",
"_count": 1
},
{
"id": "e463192ee1344ba785e6c3fb01c12a0b",
"_count": 1
},
{
"id": "05febc73ad52558eb2390ad9e910716b",
"_count": 1
}
],
"taxId": "8b79f09838fd4d9b8d060a8bb8c9b39d",
"tags": [],
"parentId": null,
"coverId": "a2647f09e41554d39b7024eed7f2462e",
"childCount": 0,
"categories": [
{
"id": "05febc73ad52558eb2390ad9e910716b",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Signale"
}
}
],
"manufacturer": {
"id": "b22980915e045ea79d6da709a178ca41",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Roco"
},
"_count": 1
},
"properties": [
{
"id": "5c7c0cabef365bd28653e9d4e0f81045",
"_count": 1,
"groupId": "a61efc337e945b4ebe4b4c292268087c",
"group": {
"id": "a61efc337e945b4ebe4b4c292268087c",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Spur H0"
}
},
{
"id": "a7bf0a869ea95f54aad9e1cdfe705db5",
"_count": 1,
"groupId": "0670df00da5d528a9b01a0c8b8b0fe18",
"group": {
"id": "0670df00da5d528a9b01a0c8b8b0fe18",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "1:87"
}
}
],
"options": [],
"categoryIds": [
"05febc73ad52558eb2390ad9e910716b"
],
"optionIds": [],
"propertyIds": [
"5c7c0cabef365bd28653e9d4e0f81045",
"a7bf0a869ea95f54aad9e1cdfe705db5"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"wbo": "SIG",
"isPreOrderProduct": false,
"importedAt": "2025-09-09 10:05:48.491",
"repertus_packstation_delivery_enabled": true,
"mlok_product_availability": "1",
"eva_product_rueckstand": 0.0,
"eva_product_resibestandkasse": 0.0,
"eva_product_resibestandfaktura": 0.0
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "40021 Dreibegriffiges Lichtsignal SNCF"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Dreibegriffiges Lichtsignal SNCF. Signal nach SNCF-Vorbild, in ma\u00dfst\u00e4blicher Ausf\u00fchrung. Ausleuchtung gr\u00fcn\/rot\/orange. Das SNCF-Signal 40021 ist ab Werk mit derdritten, orangen Leuchtdiode entsprechend dem SNCF-Signalbuch ausgestattet."
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 31.4,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 26.386554621848738,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 10.03,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 10.03
},
"fields": {
"displayGroup": [
"6de49719f138bfe7fa3284353809cf7c"
]
},
"sort": [
0,
"30589311e9725c73ae2ff71a32f55cc6"
]
},
{
"_index": "sw_product_1743509857",
"_type": "_doc",
"_id": "53319c4b84d95ee2b4861946c0b3e196",
"_score": null,
"_ignored": [
"customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.importedAt"
],
"_source": {
"id": "53319c4b84d95ee2b4861946c0b3e196",
"autoIncrement": 61352.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "3aaa0b8abe954c09892d40b581d29df3"
}
],
"availableStock": 0,
"productNumber": "32-40020",
"ean": "9005033400200",
"displayGroup": "e12ccecf7a357ad988d9452ff8ac83d1",
"sales": 0,
"stock": 0,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "b22980915e045ea79d6da709a178ca41",
"manufacturerNumber": "40020",
"releaseDate": null,
"createdAt": "2025-07-06T02:25:31+00:00",
"categoryTree": [
"960adcd8bdb7465e888a7f0e0d739de3",
"e37bb61902b64d49a0a4636302925e4f",
"e463192ee1344ba785e6c3fb01c12a0b",
"05febc73ad52558eb2390ad9e910716b"
],
"categoriesRo": [
{
"id": "960adcd8bdb7465e888a7f0e0d739de3",
"_count": 1
},
{
"id": "e37bb61902b64d49a0a4636302925e4f",
"_count": 1
},
{
"id": "e463192ee1344ba785e6c3fb01c12a0b",
"_count": 1
},
{
"id": "05febc73ad52558eb2390ad9e910716b",
"_count": 1
}
],
"taxId": "8b79f09838fd4d9b8d060a8bb8c9b39d",
"tags": [],
"parentId": null,
"coverId": "c99370282ee85f51b79b78f13e856c25",
"childCount": 0,
"categories": [
{
"id": "05febc73ad52558eb2390ad9e910716b",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Signale"
}
}
],
"manufacturer": {
"id": "b22980915e045ea79d6da709a178ca41",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Roco"
},
"_count": 1
},
"properties": [
{
"id": "5c7c0cabef365bd28653e9d4e0f81045",
"_count": 1,
"groupId": "a61efc337e945b4ebe4b4c292268087c",
"group": {
"id": "a61efc337e945b4ebe4b4c292268087c",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Spur H0"
}
},
{
"id": "a7bf0a869ea95f54aad9e1cdfe705db5",
"_count": 1,
"groupId": "0670df00da5d528a9b01a0c8b8b0fe18",
"group": {
"id": "0670df00da5d528a9b01a0c8b8b0fe18",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "1:87"
}
}
],
"options": [],
"categoryIds": [
"05febc73ad52558eb2390ad9e910716b"
],
"optionIds": [],
"propertyIds": [
"5c7c0cabef365bd28653e9d4e0f81045",
"a7bf0a869ea95f54aad9e1cdfe705db5"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"wbo": "SIG",
"isPreOrderProduct": false,
"importedAt": "2025-09-09 10:06:27.568",
"repertus_packstation_delivery_enabled": true,
"mlok_product_availability": "1",
"eva_product_rueckstand": 0.0,
"eva_product_resibestandkasse": 0.0,
"eva_product_resibestandfaktura": 0.0
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "40020 Zweibegriffiges Lichthauptsignal"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 22.4,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 18.823529411764707,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 10.04,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 10.04
},
"fields": {
"displayGroup": [
"e12ccecf7a357ad988d9452ff8ac83d1"
]
},
"sort": [
0,
"53319c4b84d95ee2b4861946c0b3e196"
]
},
{
"_index": "sw_product_1743509857",
"_type": "_doc",
"_id": "9d30f490b6985474ac08c0d350f0c603",
"_score": null,
"_ignored": [
"customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.importedAt"
],
"_source": {
"id": "9d30f490b6985474ac08c0d350f0c603",
"autoIncrement": 92496.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "3aaa0b8abe954c09892d40b581d29df3"
}
],
"availableStock": 0,
"productNumber": "126-62033",
"ean": "4015615620334",
"displayGroup": "3a86b11a610ecdfbd6c1605e97749a34",
"sales": 0,
"stock": 0,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "9392bc19331159aabca04b682fa53fa4",
"manufacturerNumber": "62033",
"releaseDate": null,
"createdAt": "2025-07-10T17:26:38+00:00",
"categoryTree": [
"960adcd8bdb7465e888a7f0e0d739de3",
"e37bb61902b64d49a0a4636302925e4f",
"e463192ee1344ba785e6c3fb01c12a0b",
"05febc73ad52558eb2390ad9e910716b"
],
"categoriesRo": [
{
"id": "960adcd8bdb7465e888a7f0e0d739de3",
"_count": 1
},
{
"id": "e37bb61902b64d49a0a4636302925e4f",
"_count": 1
},
{
"id": "e463192ee1344ba785e6c3fb01c12a0b",
"_count": 1
},
{
"id": "05febc73ad52558eb2390ad9e910716b",
"_count": 1
}
],
"taxId": "8b79f09838fd4d9b8d060a8bb8c9b39d",
"tags": [],
"parentId": null,
"coverId": "897527b6db8550d8bc54f06a7a8f3b0b",
"childCount": 0,
"categories": [
{
"id": "05febc73ad52558eb2390ad9e910716b",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Signale"
}
}
],
"manufacturer": {
"id": "9392bc19331159aabca04b682fa53fa4",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Piko"
},
"_count": 1
},
"properties": [
{
"id": "583d4fa0fcae5e0fb7304551d3274be7",
"_count": 1,
"groupId": "a61efc337e945b4ebe4b4c292268087c",
"group": {
"id": "a61efc337e945b4ebe4b4c292268087c",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Spur G"
}
},
{
"id": "5f83e618d72555d9b05b232caffa0252",
"_count": 1,
"groupId": "0670df00da5d528a9b01a0c8b8b0fe18",
"group": {
"id": "0670df00da5d528a9b01a0c8b8b0fe18",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "1:22,5"
}
}
],
"options": [],
"categoryIds": [
"05febc73ad52558eb2390ad9e910716b"
],
"optionIds": [],
"propertyIds": [
"583d4fa0fcae5e0fb7304551d3274be7",
"5f83e618d72555d9b05b232caffa0252"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"wbo": "SIG",
"isPreOrderProduct": false,
"importedAt": "2025-08-28 13:17:44.452",
"repertus_packstation_delivery_enabled": true,
"mlok_product_availability": "1",
"eva_product_mc4": "NP-007",
"eva_product_rueckstand": 0.0,
"eva_product_resibestandkasse": 0.0,
"eva_product_resibestandfaktura": 0.0
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "62033 Signalbr\u00fccke Rosenbach"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Um den Lokf\u00fchrern uneingeschr\u00e4nkte Sicht auf die Signale zu geben, wurden Signalbr\u00fccken errichtet. Die Br\u00fccke ist eine filigrane Stahlkonstruktion, die zwei vollbewegliche, zweifl\u00fcglige Formsignale tr\u00e4gt. \n"
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 136.14,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 114.40336134453781,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 21.76,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 21.76
},
"fields": {
"displayGroup": [
"3a86b11a610ecdfbd6c1605e97749a34"
]
},
"sort": [
0,
"9d30f490b6985474ac08c0d350f0c603"
]
},
{
"_index": "sw_product_1743509857",
"_type": "_doc",
"_id": "f7defd10eba155a1af104e9e3fea470c",
"_score": null,
"_ignored": [
"customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.importedAt"
],
"_source": {
"id": "f7defd10eba155a1af104e9e3fea470c",
"autoIncrement": 58596.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "3aaa0b8abe954c09892d40b581d29df3"
}
],
"availableStock": 0,
"productNumber": "32-40600",
"ean": "9005033406004",
"displayGroup": "8bb692038465674fbd0eba8a8f45dfef",
"sales": 0,
"stock": 0,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "b22980915e045ea79d6da709a178ca41",
"manufacturerNumber": "40600",
"releaseDate": null,
"createdAt": "2025-07-06T00:58:01+00:00",
"categoryTree": [
"960adcd8bdb7465e888a7f0e0d739de3",
"e37bb61902b64d49a0a4636302925e4f",
"e463192ee1344ba785e6c3fb01c12a0b",
"05febc73ad52558eb2390ad9e910716b"
],
"categoriesRo": [
{
"id": "960adcd8bdb7465e888a7f0e0d739de3",
"_count": 1
},
{
"id": "e37bb61902b64d49a0a4636302925e4f",
"_count": 1
},
{
"id": "e463192ee1344ba785e6c3fb01c12a0b",
"_count": 1
},
{
"id": "05febc73ad52558eb2390ad9e910716b",
"_count": 1
}
],
"taxId": "8b79f09838fd4d9b8d060a8bb8c9b39d",
"tags": [],
"parentId": null,
"coverId": "da2bdbd4a0115545b26f4ad79b229b5b",
"childCount": 0,
"categories": [
{
"id": "05febc73ad52558eb2390ad9e910716b",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Signale"
}
}
],
"manufacturer": {
"id": "b22980915e045ea79d6da709a178ca41",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Roco"
},
"_count": 1
},
"properties": [
{
"id": "5c7c0cabef365bd28653e9d4e0f81045",
"_count": 1,
"groupId": "a61efc337e945b4ebe4b4c292268087c",
"group": {
"id": "a61efc337e945b4ebe4b4c292268087c",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Spur H0"
}
},
{
"id": "a7bf0a869ea95f54aad9e1cdfe705db5",
"_count": 1,
"groupId": "0670df00da5d528a9b01a0c8b8b0fe18",
"group": {
"id": "0670df00da5d528a9b01a0c8b8b0fe18",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "1:87"
}
}
],
"options": [],
"categoryIds": [
"05febc73ad52558eb2390ad9e910716b"
],
"optionIds": [],
"propertyIds": [
"5c7c0cabef365bd28653e9d4e0f81045",
"a7bf0a869ea95f54aad9e1cdfe705db5"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"wbo": "SIG",
"isPreOrderProduct": false,
"importedAt": "2025-09-09 10:03:29.404",
"repertus_packstation_delivery_enabled": true,
"mlok_product_availability": "1",
"eva_product_rueckstand": 0.0,
"eva_product_resibestandkasse": 0.0,
"eva_product_resibestandfaktura": 0.0
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "40600 Licht-Vorsignal"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Signal der Einheitsbauart mit filigranem Messingmast in originalgetreuer Lackierung und Patentsteckfu\u00df f\u00fcr einfache Montage. Mit 4 LEDs, wartungsfrei. Signalbilder Vr0, Vr1 und Vr2."
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 22.4,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 18.823529411764707,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 10.04,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 10.04
},
"fields": {
"displayGroup": [
"8bb692038465674fbd0eba8a8f45dfef"
]
},
"sort": [
0,
"f7defd10eba155a1af104e9e3fea470c"
]
}
]
},
"aggregations": {
"total-count": {
"value": 5
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
1.65 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":"3aaa0b8abe954c09892d40b581d29df3"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"05febc73ad52558eb2390ad9e910716b"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"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_rule7f7788cf3af2461baf0501b1d3fa3467_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule84eba0cd9f104132abf16ec7cab16db3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruled6d70f6002614a40953d9876e8009c60_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule49847b689f7f42c281e8fab5fadaf4cb_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulecc039c828d144b038fa68a61ff71e438_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","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}}}},"is-in-stock-filter":{"filter":{"range":{"stock":{"gt":0}}},"aggregations":{"is-in-stock":{"max":{"field":"stock"}}}},"active-filter":{"filter":{"term":{"isCloseout":true}},"aggregations":{"active":{"max":{"field":"isCloseout"}}}}},"size":0,"timeout":"5s"},"search_type":"query_then_fetch"}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|