Query Metrics
4.00 ms
Query Time
1
Node(s)
24
Indices
Queries
| #▲ | Execution Time | Info |
|---|---|---|
| 1 | 4.22 ms |
Request:
{"index":"sw_all4team_product","body":[{"index":{"_id":"0193f5293a867099a471bf28fd2479b7"}},{"id":"0193f5293a867099a471bf28fd2479b7","autoIncrement":1891481.0,"ratingAverage":0.0,"active":true,"available":true,"isCloseout":true,"shippingFree":false,"markAsTopseller":false,"visibilities":[{"_count":1,"visibility":30,"salesChannelId":"fe2c2495fdbc46908e05bdaf8ccc419b"},{"_count":1,"visibility":40,"salesChannelId":"a4d331012b00410ab817a4dd8c7bc7f0"}],"availableStock":146,"productNumber":"22551339726912","ean":"5715454939749","displayGroup":"4891e55a00bab7a04f190bc3a733397d","sales":0,"stock":146,"weight":0.0,"width":0.0,"length":0.0,"height":0.0,"manufacturerId":"1a0ffc50b3584a1abd28c2d06d6c6465","manufacturerNumber":"225513","releaseDate":"2025-12-16T06:35:52+00:00","createdAt":"2024-12-23T20:15:40+00:00","categoryTree":["e488bb219113483a84172a9a5c446883","23756acc3fa84304877fe50205f7585a","018997682a78734eb600767b8b86f756","018997699635722d987669d9a82eaad5","01899779c0b073298602bcf978583eba","01899825820b72e898dc71e56d10a03b"],"categoriesRo":[{"id":"e488bb219113483a84172a9a5c446883","_count":1},{"id":"23756acc3fa84304877fe50205f7585a","_count":1},{"id":"018997682a78734eb600767b8b86f756","_count":1},{"id":"018997699635722d987669d9a82eaad5","_count":1},{"id":"01899779c0b073298602bcf978583eba","_count":1},{"id":"01899825820b72e898dc71e56d10a03b","_count":1}],"taxId":"572b2f69c09840c6a0c776d306ea2966","tags":[],"parentId":"0192e204d2ad7278b3dc373e637115af","coverId":"019bcf1ede7271a8b95e945029f22227","childCount":0,"categories":[{"id":"01899779c0b073298602bcf978583eba","_count":1,"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Hosen"}},{"id":"23756acc3fa84304877fe50205f7585a","_count":1,"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Teamsport"}},{"id":"01899825820b72e898dc71e56d10a03b","_count":1,"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Hosen kurz"}}],"manufacturer":{"id":"1a0ffc50b3584a1abd28c2d06d6c6465","name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"HUMMEL","87c74cec26c54ed8867507ed00a0983a":null},"_count":1},"properties":[{"id":"018963e5f13871739bde1b0eb26bb21b","_count":1,"groupId":"018aeef8f32470db855643b76c70939d","group":{"id":"018aeef8f32470db855643b76c70939d","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Herren"}},{"id":"018963ea20b670278236dc7103bcceb8","_count":1,"groupId":"018ae9d28fa471979e520453984303f8","group":{"id":"018ae9d28fa471979e520453984303f8","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Gelb"}},{"id":"01896411e05c71f4af78a5552a40b626","_count":1,"groupId":"018963e5e9c372ae844959c17e5007bd","group":{"id":"018963e5e9c372ae844959c17e5007bd","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Fitness \/ Workout"}},{"id":"01896412ff1173c79eed112e4156fbad","_count":1,"groupId":"018aeef91bde71e8be1f4167e2de9a86","group":{"id":"018aeef91bde71e8be1f4167e2de9a86","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Tights kurz He\/Uni"}}],"options":[{"id":"7303e67aef5342d78da48b362e94c9fd","_count":1,"groupId":"8b2821798c574ee187d1c58e63d4d424","group":{"id":"8b2821798c574ee187d1c58e63d4d424","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"5269 BLAZING YELLOW"}},{"id":"df41139ab42a4f0dbe2167afb103b833","_count":1,"groupId":"2d5f0f5a4f614de793262c22e833d545","group":{"id":"2d5f0f5a4f614de793262c22e833d545","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"S"}}],"categoryIds":["01899779c0b073298602bcf978583eba","01899825820b72e898dc71e56d10a03b","23756acc3fa84304877fe50205f7585a"],"optionIds":["7303e67aef5342d78da48b362e94c9fd","df41139ab42a4f0dbe2167afb103b833"],"propertyIds":["018963e5f13871739bde1b0eb26bb21b","018963ea20b670278236dc7103bcceb8","01896411e05c71f4af78a5552a40b626","01896412ff1173c79eed112e4156fbad"],"tagIds":[],"states":["is-physical"],"customFields":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":{"sample_order_six_flag":false,"custom_products_update_stock":1000.0,"custom_products_update_updatedate":"2025-03-13 05:39:10.000","custom_products_update_planned_stock":0.0,"custom_products_update_incoming_stock":0.0,"purchasable_item":false,"kilb_productdesigner_product_fieldset_typ":0.0}},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"HUMMEL hmlBL PERFORMANCE SHORT TIGHTS","87c74cec26c54ed8867507ed00a0983a":null},"description":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":null,"87c74cec26c54ed8867507ed00a0983a":null},"metaTitle":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"HUMMEL hmlBL PERFORMANCE SHORT TIGHTS 5269 BLAZING YELLOW S","87c74cec26c54ed8867507ed00a0983a":null},"metaDescription":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":null,"87c74cec26c54ed8867507ed00a0983a":null},"customSearchKeywords":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":["Sporthosen","Tights","Tights kurz He\/Uni","Teamsportartikel","Sportartikel","22551339726912","225513","225513397","5715454939749","HUMMEL","hmlBL PERFORMANCE SHORT TIGHTS 5269 BLAZING YELLOW S"],"87c74cec26c54ed8867507ed00a0983a":null},"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross":26.96,"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net":22.65546218487395,"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage":9.98,"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage":9.98}]}
|
Cluster Status
{
"cluster_name": "opensearch",
"status": "yellow",
"timed_out": false,
"number_of_nodes": 1,
"number_of_data_nodes": 1,
"discovered_master": true,
"discovered_cluster_manager": true,
"active_primary_shards": 47,
"active_shards": 47,
"relocating_shards": 0,
"initializing_shards": 0,
"unassigned_shards": 109,
"delayed_unassigned_shards": 0,
"number_of_pending_tasks": 0,
"number_of_in_flight_fetch": 0,
"task_max_waiting_in_queue_millis": 0,
"active_shards_percent_as_number": 30.128205128205128
}
Indices
| Name▲ | Status | Replication (pri, rep) | Doc Count |
|---|---|---|---|
| top_queries-2026.01.10-65760 | open | 1, 1 | 13 |
| top_queries-2026.01.11-65761 | open | 1, 1 | 13 |
| sw_all4team_product_1716941102 | open | 3, 3 | 5216241 |
| top_queries-2026.01.17-65767 | open | 1, 1 | 1280 |
| sw_all4team_product_1717545902 | open | 3, 3 | 5217183 |
| sw_all4team_product_1717113901 | open | 3, 3 | 5216814 |
| sw_all4team_product_1717027502 | open | 3, 3 | 5216573 |
| .opendistro_security | open | 1, 0 | 10 |
| top_queries-2026.01.18-65768 | open | 1, 1 | 108 |
| sw_all4team_product_1717286702 | open | 3, 3 | 5217102 |
| sw_all4team_product_1717373101 | open | 3, 3 | 5217108 |
| top_queries-2026.01.14-65764 | open | 1, 1 | 1810 |
| sw_all4team_product_1716336301 | open | 3, 3 | 6258703 |
| .plugins-ml-config | open | 1, 0 | 1 |
| .opensearch-observability | open | 1, 0 | 0 |
| sw_all4team_product_1717632302 | open | 3, 3 | 5217457 |
| sw_all4team_product_1717718701 | open | 3, 3 | 5217475 |
| top_queries-2026.01.13-65763 | open | 1, 1 | 1323 |
| top_queries-2026.01.15-65765 | open | 1, 1 | 2055 |
| security-auditlog-2023.07.13 | open | 1, 1 | 44 |
| sw_all4team_product_1717200302 | open | 3, 3 | 5217018 |
| sw_all4team_product_1717459502 | open | 3, 3 | 5217133 |
| top_queries-2026.01.12-65762 | open | 1, 1 | 227 |
| top_queries-2026.01.16-65766 | open | 1, 1 | 483 |