Query Metrics
4.00 ms
Query Time
1
Node(s)
23
Indices
Queries
| #▲ | Execution Time | Info |
|---|---|---|
| 1 | 4.72 ms |
Request:
{"index":"sw_all4team_product","body":[{"index":{"_id":"0192f4950f8c71b6a8b7c8c69af7998e"}},{"id":"0192f4950f8c71b6a8b7c8c69af7998e","autoIncrement":1857412.0,"ratingAverage":0.0,"active":false,"available":false,"isCloseout":true,"shippingFree":false,"markAsTopseller":false,"visibilities":[{"_count":1,"visibility":30,"salesChannelId":"fe2c2495fdbc46908e05bdaf8ccc419b"},{"_count":1,"visibility":40,"salesChannelId":"a4d331012b00410ab817a4dd8c7bc7f0"}],"availableStock":0,"productNumber":"21193939714642","ean":"5700498421343","displayGroup":"36b0704aa020c9372e57431e3b9862fd","sales":0,"stock":0,"weight":0.0,"width":0.0,"length":0.0,"height":0.0,"manufacturerId":"1a0ffc50b3584a1abd28c2d06d6c6465","manufacturerNumber":"211939","releaseDate":"2026-02-11T05:15:03+00:00","createdAt":"2024-11-04T00:31:02+00:00","categoryTree":["e488bb219113483a84172a9a5c446883","23756acc3fa84304877fe50205f7585a","018997682a78734eb600767b8b86f756","01899769cac47058ab3fc7095c75b45d","018997a53bfd7114b6ca743e62357935","01899838ba86736d8f95285380b962f0"],"categoriesRo":[{"id":"e488bb219113483a84172a9a5c446883","_count":1},{"id":"23756acc3fa84304877fe50205f7585a","_count":1},{"id":"018997682a78734eb600767b8b86f756","_count":1},{"id":"01899769cac47058ab3fc7095c75b45d","_count":1},{"id":"018997a53bfd7114b6ca743e62357935","_count":1},{"id":"01899838ba86736d8f95285380b962f0","_count":1}],"taxId":"572b2f69c09840c6a0c776d306ea2966","tags":[{"id":"b963969f1e994c698015b5c8a293fc3a","name":"all4team","_count":1},{"id":"ee84a54038854314a8d3eb036e381f1c","name":"Teamsportbekleidung","_count":1}],"parentId":"b76aee35d9e345b182dc258ff40f837c","coverId":"019d67a45025705f96f2da7d0548bf58","childCount":0,"categories":[{"id":"23756acc3fa84304877fe50205f7585a","_count":1,"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Teamsport"}},{"id":"018997a53bfd7114b6ca743e62357935","_count":1,"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Freizeitschuhe"}},{"id":"01899838ba86736d8f95285380b962f0","_count":1,"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Lifestyle Schuhe nieder"}}],"manufacturer":{"id":"1a0ffc50b3584a1abd28c2d06d6c6465","name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"HUMMEL","87c74cec26c54ed8867507ed00a0983a":null},"_count":1},"properties":[{"id":"018963e5f53b7292b003bf6803f624b7","_count":1,"groupId":"018aeef8f32470db855643b76c70939d","group":{"id":"018aeef8f32470db855643b76c70939d","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Unisex"}},{"id":"018963ea38bc73dfb904152df1cb0c75","_count":1,"groupId":"018ae9d28fa471979e520453984303f8","group":{"id":"018ae9d28fa471979e520453984303f8","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"rosa"}},{"id":"01896411e1b67172ac7120fc2f0fa574","_count":1,"groupId":"018963e5e9c372ae844959c17e5007bd","group":{"id":"018963e5e9c372ae844959c17e5007bd","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Footwear"}}],"options":[{"id":"34cbea0035d84600904d39e5238023c9","_count":1,"groupId":"29b9559a4e0045db8054abf9a0016cce","group":{"id":"29b9559a4e0045db8054abf9a0016cce","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"40"}},{"id":"596451407e60481d9e37148ca7a2031f","_count":1,"groupId":"8b2821798c574ee187d1c58e63d4d424","group":{"id":"8b2821798c574ee187d1c58e63d4d424","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"4146 ROSE DUST"}}],"categoryIds":["018997a53bfd7114b6ca743e62357935","01899838ba86736d8f95285380b962f0","23756acc3fa84304877fe50205f7585a"],"optionIds":["34cbea0035d84600904d39e5238023c9","596451407e60481d9e37148ca7a2031f"],"propertyIds":["018963e5f53b7292b003bf6803f624b7","018963ea38bc73dfb904152df1cb0c75","01896411e1b67172ac7120fc2f0fa574"],"tagIds":["b963969f1e994c698015b5c8a293fc3a","ee84a54038854314a8d3eb036e381f1c"],"states":["is-physical"],"customFields":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":{"sample_order_six_flag":false,"custom_products_update_stock":16.0,"custom_products_update_updatedate":"2024-12-03 22:38:37.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 TATUM SEAMLESS","87c74cec26c54ed8867507ed00a0983a":null},"description":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Ein klassischer Slipper, perfekt f\u00fcr den Alltag. Mit einem komplett gestrickten Obermaterial und markanten Winkeln sowie einer weichen EVA-Au\u00dfensohle mit sportlicher \u00c4sthetik.","87c74cec26c54ed8867507ed00a0983a":null},"metaTitle":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"HUMMEL TATUM SEAMLESS 4146 ROSE DUST 40","87c74cec26c54ed8867507ed00a0983a":null},"metaDescription":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":null,"87c74cec26c54ed8867507ed00a0983a":null},"customSearchKeywords":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":["Freizeitschuhe","Lifestyle-Sch.","Lifestyle-Sch. nieder He\/Uni","Teamsportartikel","Sportartikel","21193939714642","211939","211939397","5700498421343","HUMMEL","TATUM SEAMLESS 4146 ROSE DUST 40"],"87c74cec26c54ed8867507ed00a0983a":null},"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross":35.96,"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net":30.218487394957986,"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage":9.99,"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage":9.99}]}
|
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": 46,
"active_shards": 46,
"relocating_shards": 0,
"initializing_shards": 0,
"unassigned_shards": 108,
"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": 29.87012987012987
}
Indices
| Name▲ | Status | Replication (pri, rep) | Doc Count |
|---|---|---|---|
| top_queries-2026.04.04-55106 | open | 1, 1 | 563 |
| sw_all4team_product_1716941102 | open | 3, 3 | 5216241 |
| sw_all4team_product_1717545902 | open | 3, 3 | 5217183 |
| sw_all4team_product_1717113901 | open | 3, 3 | 5216814 |
| top_queries-2026.04.06-55108 | open | 1, 1 | 1092 |
| sw_all4team_product_1717027502 | open | 3, 3 | 5216573 |
| .opendistro_security | open | 1, 0 | 10 |
| top_queries-2026.04.07-55109 | open | 1, 1 | 441 |
| top_queries-2026.03.31-25405 | open | 1, 1 | 1473 |
| top_queries-2026.04.03-55105 | open | 1, 1 | 609 |
| sw_all4team_product_1717286702 | open | 3, 3 | 5217102 |
| sw_all4team_product_1717373101 | open | 3, 3 | 5217108 |
| sw_all4team_product_1716336301 | open | 3, 3 | 6275001 |
| .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 |
| security-auditlog-2023.07.13 | open | 1, 1 | 44 |
| top_queries-2026.04.02-55104 | open | 1, 1 | 795 |
| sw_all4team_product_1717200302 | open | 3, 3 | 5217018 |
| sw_all4team_product_1717459502 | open | 3, 3 | 5217133 |
| top_queries-2026.04.05-55107 | open | 1, 1 | 977 |
| top_queries-2026.04.01-55103 | open | 1, 1 | 924 |