| 1 |
27.08 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":"caffcd458e2b55738eb20b1227aa4406"}}}},{"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": 24,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 7,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_product_1743509857",
"_type": "_doc",
"_id": "017321d1100856ea85da47c9bf6ac377",
"_score": null,
"_ignored": [
"customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.importedAt"
],
"_source": {
"id": "017321d1100856ea85da47c9bf6ac377",
"autoIncrement": 8192.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "3aaa0b8abe954c09892d40b581d29df3"
}
],
"availableStock": 0,
"productNumber": "312-387.610",
"ean": "8720168709042",
"displayGroup": "f1c54fa65fb7ecf6a8c9127c384e498e",
"sales": 0,
"stock": 0,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": null,
"manufacturerNumber": "387.610",
"releaseDate": null,
"createdAt": "2024-09-01T00:40:13+00:00",
"categoryTree": [
"960adcd8bdb7465e888a7f0e0d739de3",
"e37bb61902b64d49a0a4636302925e4f",
"e463192ee1344ba785e6c3fb01c12a0b",
"caffcd458e2b55738eb20b1227aa4406"
],
"categoriesRo": [
{
"id": "960adcd8bdb7465e888a7f0e0d739de3",
"_count": 1
},
{
"id": "e37bb61902b64d49a0a4636302925e4f",
"_count": 1
},
{
"id": "e463192ee1344ba785e6c3fb01c12a0b",
"_count": 1
},
{
"id": "caffcd458e2b55738eb20b1227aa4406",
"_count": 1
}
],
"taxId": "8b79f09838fd4d9b8d060a8bb8c9b39d",
"tags": [],
"parentId": null,
"coverId": "b254fd4de6315e2b9f3a55715cb4ef76",
"childCount": 0,
"categories": [
{
"id": "caffcd458e2b55738eb20b1227aa4406",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Figuren"
}
}
],
"manufacturer": {
"id": null,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"_count": 1
},
"properties": [
{
"id": "01c3597ed9a458568ff2229158203d02",
"_count": 1,
"groupId": "f00956ca61d15e71b32bb35d68c8deef",
"group": {
"id": "f00956ca61d15e71b32bb35d68c8deef",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2024"
}
},
{
"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": [
"caffcd458e2b55738eb20b1227aa4406"
],
"optionIds": [],
"propertyIds": [
"01c3597ed9a458568ff2229158203d02",
"5c7c0cabef365bd28653e9d4e0f81045",
"a7bf0a869ea95f54aad9e1cdfe705db5"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"wbo": "MBF",
"mlok_product_availability": "1",
"isPreOrderProduct": false,
"importedAt": "2025-07-03 09:45:06.183",
"repertus_packstation_delivery_enabled": true,
"eva_product_mc4": "NEU2024",
"eva_product_rueckstand": 0.0,
"eva_product_resibestandkasse": 0.0,
"eva_product_resibestandfaktura": 0.0
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "387.610 M\u00e4hbalken mit Pferd"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "M\u00e4hbalken mit Pferd + Figur - 1:87 Fertigmodell aus Resin, lackiert"
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 28.6,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 24.033613445378155,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 10.06,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 10.06
},
"fields": {
"displayGroup": [
"f1c54fa65fb7ecf6a8c9127c384e498e"
]
},
"sort": [
0,
"017321d1100856ea85da47c9bf6ac377"
]
},
{
"_index": "sw_product_1743509857",
"_type": "_doc",
"_id": "017ae90221595d739e5834823ccf5cdf",
"_score": null,
"_ignored": [
"customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.importedAt"
],
"_source": {
"id": "017ae90221595d739e5834823ccf5cdf",
"autoIncrement": 15604.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "3aaa0b8abe954c09892d40b581d29df3"
}
],
"availableStock": 0,
"productNumber": "312-5720017",
"ean": "8721098322165",
"displayGroup": "cf98414596df34dfe5f7fcf77bd15621",
"sales": 0,
"stock": 0,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": null,
"manufacturerNumber": "5720017",
"releaseDate": null,
"createdAt": "2025-01-31T08:47:46+00:00",
"categoryTree": [
"960adcd8bdb7465e888a7f0e0d739de3",
"e37bb61902b64d49a0a4636302925e4f",
"e463192ee1344ba785e6c3fb01c12a0b",
"caffcd458e2b55738eb20b1227aa4406"
],
"categoriesRo": [
{
"id": "960adcd8bdb7465e888a7f0e0d739de3",
"_count": 1
},
{
"id": "e37bb61902b64d49a0a4636302925e4f",
"_count": 1
},
{
"id": "e463192ee1344ba785e6c3fb01c12a0b",
"_count": 1
},
{
"id": "caffcd458e2b55738eb20b1227aa4406",
"_count": 1
}
],
"taxId": "8b79f09838fd4d9b8d060a8bb8c9b39d",
"tags": [],
"parentId": null,
"coverId": "d8eeda3457bb567bb9a90340b866b8c7",
"childCount": 0,
"categories": [
{
"id": "caffcd458e2b55738eb20b1227aa4406",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Figuren"
}
}
],
"manufacturer": {
"id": null,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"_count": 1
},
"properties": [
{
"id": "73a3499a73d75acfb09773266f45687f",
"_count": 1,
"groupId": "f00956ca61d15e71b32bb35d68c8deef",
"group": {
"id": "f00956ca61d15e71b32bb35d68c8deef",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2025"
}
},
{
"id": "d3e14042777e5cdfb7688b45f8dfeccb",
"_count": 1,
"groupId": "0670df00da5d528a9b01a0c8b8b0fe18",
"group": {
"id": "0670df00da5d528a9b01a0c8b8b0fe18",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "1:72"
}
}
],
"options": [],
"categoryIds": [
"caffcd458e2b55738eb20b1227aa4406"
],
"optionIds": [],
"propertyIds": [
"73a3499a73d75acfb09773266f45687f",
"d3e14042777e5cdfb7688b45f8dfeccb"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"wbo": "MBF",
"isPreOrderProduct": true,
"importedAt": "2025-03-05 03:04:14.965",
"repertus_packstation_delivery_enabled": true,
"mlok_product_availability": "5",
"eva_product_mc4": "NEU2025",
"eva_product_rueckstand": 0.0,
"eva_product_resibestandkasse": 0.0,
"eva_product_resibestandfaktura": 0.0
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "5720017 US Military Police (2)"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "US Military Police (2)"
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 13.9,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 11.680672268907564,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 0.0,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 0.0
},
"fields": {
"displayGroup": [
"cf98414596df34dfe5f7fcf77bd15621"
]
},
"sort": [
0,
"017ae90221595d739e5834823ccf5cdf"
]
},
{
"_index": "sw_product_1743509857",
"_type": "_doc",
"_id": "2b134204818a55f09c31540a1b25a2ab",
"_score": null,
"_ignored": [
"customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.importedAt"
],
"_source": {
"id": "2b134204818a55f09c31540a1b25a2ab",
"autoIncrement": 84892.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-40000",
"ean": "9005033400002",
"displayGroup": "25e0bc9912cadd06c2fc9fb5c59f8840",
"sales": 0,
"stock": 0,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "b22980915e045ea79d6da709a178ca41",
"manufacturerNumber": "40000",
"releaseDate": null,
"createdAt": "2025-07-06T08:44:35+00:00",
"categoryTree": [
"960adcd8bdb7465e888a7f0e0d739de3",
"e37bb61902b64d49a0a4636302925e4f",
"e463192ee1344ba785e6c3fb01c12a0b",
"caffcd458e2b55738eb20b1227aa4406"
],
"categoriesRo": [
{
"id": "960adcd8bdb7465e888a7f0e0d739de3",
"_count": 1
},
{
"id": "e37bb61902b64d49a0a4636302925e4f",
"_count": 1
},
{
"id": "e463192ee1344ba785e6c3fb01c12a0b",
"_count": 1
},
{
"id": "caffcd458e2b55738eb20b1227aa4406",
"_count": 1
}
],
"taxId": "8b79f09838fd4d9b8d060a8bb8c9b39d",
"tags": [],
"parentId": null,
"coverId": "06ba6ee46eee57c8b6ff271fe5097afd",
"childCount": 0,
"categories": [
{
"id": "caffcd458e2b55738eb20b1227aa4406",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Figuren"
}
}
],
"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": [
"caffcd458e2b55738eb20b1227aa4406"
],
"optionIds": [],
"propertyIds": [
"5c7c0cabef365bd28653e9d4e0f81045",
"a7bf0a869ea95f54aad9e1cdfe705db5"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"wbo": "MBF",
"isPreOrderProduct": false,
"importedAt": "2025-09-09 10:06:38.449",
"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": "40000 Bahnfiguren, 24 St."
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Unbemalt zum selber bemalen. Inhalt 24 St\u00fcck\/Packung."
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 8.9,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 7.478991596638656,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 10.1,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 10.1
},
"fields": {
"displayGroup": [
"25e0bc9912cadd06c2fc9fb5c59f8840"
]
},
"sort": [
0,
"2b134204818a55f09c31540a1b25a2ab"
]
},
{
"_index": "sw_product_1743509857",
"_type": "_doc",
"_id": "51a13764d78f57908eb46377aad5835b",
"_score": null,
"_ignored": [
"customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.importedAt"
],
"_source": {
"id": "51a13764d78f57908eb46377aad5835b",
"autoIncrement": 90785.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-55731",
"ean": "4015615557319",
"displayGroup": "b1834a9f43104211eaa5d98ca338d7c6",
"sales": 0,
"stock": 0,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "9392bc19331159aabca04b682fa53fa4",
"manufacturerNumber": "55731",
"releaseDate": null,
"createdAt": "2025-07-10T14:22:02+00:00",
"categoryTree": [
"960adcd8bdb7465e888a7f0e0d739de3",
"e37bb61902b64d49a0a4636302925e4f",
"e463192ee1344ba785e6c3fb01c12a0b",
"caffcd458e2b55738eb20b1227aa4406"
],
"categoriesRo": [
{
"id": "960adcd8bdb7465e888a7f0e0d739de3",
"_count": 1
},
{
"id": "e37bb61902b64d49a0a4636302925e4f",
"_count": 1
},
{
"id": "e463192ee1344ba785e6c3fb01c12a0b",
"_count": 1
},
{
"id": "caffcd458e2b55738eb20b1227aa4406",
"_count": 1
}
],
"taxId": "8b79f09838fd4d9b8d060a8bb8c9b39d",
"tags": [],
"parentId": null,
"coverId": "3e68fe48dcae59f8828b13709510ba06",
"childCount": 0,
"categories": [
{
"id": "caffcd458e2b55738eb20b1227aa4406",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Figuren"
}
}
],
"manufacturer": {
"id": "9392bc19331159aabca04b682fa53fa4",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Piko"
},
"_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": [
"caffcd458e2b55738eb20b1227aa4406"
],
"optionIds": [],
"propertyIds": [
"5c7c0cabef365bd28653e9d4e0f81045",
"a7bf0a869ea95f54aad9e1cdfe705db5"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"wbo": "MBF",
"isPreOrderProduct": false,
"importedAt": "2025-08-28 13:05:45.163",
"repertus_packstation_delivery_enabled": true,
"mlok_product_availability": "1",
"eva_product_mc4": "NP-004",
"eva_product_rueckstand": 0.0,
"eva_product_resibestandkasse": 0.0,
"eva_product_resibestandfaktura": 0.0
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "55731 Figurenset Reisende"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Figurenset Reisende 6-tlg"
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 17.1,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 14.369747899159666,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 9.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 9.95
},
"fields": {
"displayGroup": [
"b1834a9f43104211eaa5d98ca338d7c6"
]
},
"sort": [
0,
"51a13764d78f57908eb46377aad5835b"
]
},
{
"_index": "sw_product_1743509857",
"_type": "_doc",
"_id": "5c1a848cb2ce5b3ea14509021e2bf043",
"_score": null,
"_ignored": [
"customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.importedAt"
],
"_source": {
"id": "5c1a848cb2ce5b3ea14509021e2bf043",
"autoIncrement": 93748.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-55730",
"ean": "4015615557302",
"displayGroup": "0181516070e4e2573b5393b1541b4dab",
"sales": 0,
"stock": 0,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "9392bc19331159aabca04b682fa53fa4",
"manufacturerNumber": "55730",
"releaseDate": null,
"createdAt": "2025-07-10T20:14:42+00:00",
"categoryTree": [
"960adcd8bdb7465e888a7f0e0d739de3",
"e37bb61902b64d49a0a4636302925e4f",
"e463192ee1344ba785e6c3fb01c12a0b",
"caffcd458e2b55738eb20b1227aa4406"
],
"categoriesRo": [
{
"id": "960adcd8bdb7465e888a7f0e0d739de3",
"_count": 1
},
{
"id": "e37bb61902b64d49a0a4636302925e4f",
"_count": 1
},
{
"id": "e463192ee1344ba785e6c3fb01c12a0b",
"_count": 1
},
{
"id": "caffcd458e2b55738eb20b1227aa4406",
"_count": 1
}
],
"taxId": "8b79f09838fd4d9b8d060a8bb8c9b39d",
"tags": [],
"parentId": null,
"coverId": "97278ac1524b5b059623907c40eb5e3d",
"childCount": 0,
"categories": [
{
"id": "caffcd458e2b55738eb20b1227aa4406",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Figuren"
}
}
],
"manufacturer": {
"id": "9392bc19331159aabca04b682fa53fa4",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Piko"
},
"_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": [
"caffcd458e2b55738eb20b1227aa4406"
],
"optionIds": [],
"propertyIds": [
"5c7c0cabef365bd28653e9d4e0f81045",
"a7bf0a869ea95f54aad9e1cdfe705db5"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"wbo": "MBF",
"isPreOrderProduct": false,
"importedAt": "2025-08-28 13:20:29.116",
"repertus_packstation_delivery_enabled": true,
"mlok_product_availability": "1",
"eva_product_mc4": "NP-004",
"eva_product_rueckstand": 0.0,
"eva_product_resibestandkasse": 0.0,
"eva_product_resibestandfaktura": 0.0
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "55730 Figurenset Bahnpersonal"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Figurenset Bahnpersonal 6-tlg"
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 17.1,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 14.369747899159666,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 9.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 9.95
},
"fields": {
"displayGroup": [
"0181516070e4e2573b5393b1541b4dab"
]
},
"sort": [
0,
"5c1a848cb2ce5b3ea14509021e2bf043"
]
},
{
"_index": "sw_product_1743509857",
"_type": "_doc",
"_id": "856f62e804345cf89e7211e9061ee0af",
"_score": null,
"_ignored": [
"customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.importedAt"
],
"_source": {
"id": "856f62e804345cf89e7211e9061ee0af",
"autoIncrement": 56521.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "3aaa0b8abe954c09892d40b581d29df3"
}
],
"availableStock": 4,
"productNumber": "32-40001",
"ean": "9005033400019",
"displayGroup": "4170736deebdbe79c856b1caba856a03",
"sales": 0,
"stock": 4,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "b22980915e045ea79d6da709a178ca41",
"manufacturerNumber": "40001",
"releaseDate": null,
"createdAt": "2025-07-05T20:26:41+00:00",
"categoryTree": [
"960adcd8bdb7465e888a7f0e0d739de3",
"e37bb61902b64d49a0a4636302925e4f",
"e463192ee1344ba785e6c3fb01c12a0b",
"caffcd458e2b55738eb20b1227aa4406"
],
"categoriesRo": [
{
"id": "960adcd8bdb7465e888a7f0e0d739de3",
"_count": 1
},
{
"id": "e37bb61902b64d49a0a4636302925e4f",
"_count": 1
},
{
"id": "e463192ee1344ba785e6c3fb01c12a0b",
"_count": 1
},
{
"id": "caffcd458e2b55738eb20b1227aa4406",
"_count": 1
}
],
"taxId": "8b79f09838fd4d9b8d060a8bb8c9b39d",
"tags": [],
"parentId": null,
"coverId": "b790b00b702458b5976be8b0f43a18ce",
"childCount": 0,
"categories": [
{
"id": "caffcd458e2b55738eb20b1227aa4406",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Figuren"
}
}
],
"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": [
"caffcd458e2b55738eb20b1227aa4406"
],
"optionIds": [],
"propertyIds": [
"5c7c0cabef365bd28653e9d4e0f81045",
"a7bf0a869ea95f54aad9e1cdfe705db5"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"wbo": "MBF",
"isPreOrderProduct": false,
"importedAt": "2025-09-25 13:06:40.646",
"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": "40001 Lokf\u00fchrer und Heizer"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Figuren-Set Lokf\u00fchrer und Heizer. Bestehend aus 3 x Lokf\u00fchrer und 3 x Heizer"
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 10.45,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 8.781512605042016,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 9.91,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 9.91
},
"fields": {
"displayGroup": [
"4170736deebdbe79c856b1caba856a03"
]
},
"sort": [
0,
"856f62e804345cf89e7211e9061ee0af"
]
},
{
"_index": "sw_product_1743509857",
"_type": "_doc",
"_id": "e44632ecacb356bc906e5e8c04972f88",
"_score": null,
"_ignored": [
"customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.importedAt"
],
"_source": {
"id": "e44632ecacb356bc906e5e8c04972f88",
"autoIncrement": 91145.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-36200",
"ean": "4015615362005",
"displayGroup": "6823b8505f63b1bbe12e2159c7a3c11f",
"sales": 0,
"stock": 0,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "9392bc19331159aabca04b682fa53fa4",
"manufacturerNumber": "36200",
"releaseDate": null,
"createdAt": "2025-07-10T14:51:06+00:00",
"categoryTree": [
"960adcd8bdb7465e888a7f0e0d739de3",
"e37bb61902b64d49a0a4636302925e4f",
"e463192ee1344ba785e6c3fb01c12a0b",
"caffcd458e2b55738eb20b1227aa4406"
],
"categoriesRo": [
{
"id": "960adcd8bdb7465e888a7f0e0d739de3",
"_count": 1
},
{
"id": "e37bb61902b64d49a0a4636302925e4f",
"_count": 1
},
{
"id": "e463192ee1344ba785e6c3fb01c12a0b",
"_count": 1
},
{
"id": "caffcd458e2b55738eb20b1227aa4406",
"_count": 1
}
],
"taxId": "8b79f09838fd4d9b8d060a8bb8c9b39d",
"tags": [],
"parentId": null,
"coverId": "02660f8c236c56bf8dbce60191f49e53",
"childCount": 0,
"categories": [
{
"id": "caffcd458e2b55738eb20b1227aa4406",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Figuren"
}
}
],
"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": [
"caffcd458e2b55738eb20b1227aa4406"
],
"optionIds": [],
"propertyIds": [
"583d4fa0fcae5e0fb7304551d3274be7",
"5f83e618d72555d9b05b232caffa0252"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"wbo": "MBF",
"isPreOrderProduct": false,
"importedAt": "2025-08-28 13:05:36.927",
"repertus_packstation_delivery_enabled": true,
"mlok_product_availability": "1",
"eva_product_mc4": "NP-113",
"eva_product_rueckstand": 0.0,
"eva_product_resibestandkasse": 0.0,
"eva_product_resibestandfaktura": 0.0
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "36200 Lokf\u00fchrer bemalt"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 9.85,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 8.277310924369749,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 29.64,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 29.64
},
"fields": {
"displayGroup": [
"6823b8505f63b1bbe12e2159c7a3c11f"
]
},
"sort": [
0,
"e44632ecacb356bc906e5e8c04972f88"
]
}
]
},
"aggregations": {
"total-count": {
"value": 7
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
1.54 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":"caffcd458e2b55738eb20b1227aa4406"}}}},{"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
|