Query Metrics
5.00 ms
Query Time
1
Node(s)
23
Indices
Queries
| #▲ | Execution Time | Info |
|---|---|---|
| 1 | 5.83 ms |
Request:
{"index":"sw_all4team_product","body":[{"index":{"_id":"018f814628cd73daabd0092326b19923"}},{"id":"018f814628cd73daabd0092326b19923","autoIncrement":1785517.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":1,"productNumber":"22724639736509","ean":"5715454992096","displayGroup":"faa2585e6571c9f5bebe6e161e2bf100","sales":0,"stock":1,"weight":0.0,"width":0.0,"length":0.0,"height":0.0,"manufacturerId":"1a0ffc50b3584a1abd28c2d06d6c6465","manufacturerNumber":"227246","releaseDate":"2024-05-16T14:00:07+00:00","createdAt":"2024-05-16T14:00:07+00:00","categoryTree":["e488bb219113483a84172a9a5c446883","23756acc3fa84304877fe50205f7585a","01899767eecf73e2b11b9e65fbdd4d20","018997692f4972ac8670db116485b1a7","0189977481587156a22ab263435d8720","01899818c11871d59a6841ea343f58b0"],"categoriesRo":[{"id":"e488bb219113483a84172a9a5c446883","_count":1},{"id":"23756acc3fa84304877fe50205f7585a","_count":1},{"id":"01899767eecf73e2b11b9e65fbdd4d20","_count":1},{"id":"018997692f4972ac8670db116485b1a7","_count":1},{"id":"0189977481587156a22ab263435d8720","_count":1},{"id":"01899818c11871d59a6841ea343f58b0","_count":1}],"taxId":"572b2f69c09840c6a0c776d306ea2966","tags":[{"id":"018f814628c67271bd1304b6bbea30ee","name":"all4team","_count":1},{"id":"018f814628c771aba8e0e98757ea799e","name":"Teamsportbekleidung","_count":1}],"parentId":"018f814628c67271bd1304b6bad444fb","coverId":"019d9a30906571bbaf927c8b79576a97","childCount":0,"categories":[{"id":"01899818c11871d59a6841ea343f58b0","_count":1,"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"langarm"}},{"id":"0189977481587156a22ab263435d8720","_count":1,"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"T-Shirts"}},{"id":"23756acc3fa84304877fe50205f7585a","_count":1,"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Teamsport"}}],"manufacturer":{"id":"1a0ffc50b3584a1abd28c2d06d6c6465","name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"HUMMEL","87c74cec26c54ed8867507ed00a0983a":null},"_count":1},"properties":[{"id":"018963e5f06f716dadb0fe95b3c53d22","_count":1,"groupId":"018aeef8f32470db855643b76c70939d","group":{"id":"018aeef8f32470db855643b76c70939d","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Damen"}},{"id":"018963ea3964707fbbfb35b2b8e8084b","_count":1,"groupId":"018ae9d28fa471979e520453984303f8","group":{"id":"018ae9d28fa471979e520453984303f8","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Rot"}},{"id":"01896411e82d73ef973f22bb35c69d07","_count":1,"groupId":"018963e5e9c372ae844959c17e5007bd","group":{"id":"018963e5e9c372ae844959c17e5007bd","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Running"}},{"id":"01896412f703702f8629f58ca6f495fb","_count":1,"groupId":"018aeef91bde71e8be1f4167e2de9a86","group":{"id":"018aeef91bde71e8be1f4167e2de9a86","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"T-Shirts\/Tanks lg.Arm Da"}},{"id":"018dcc3373f47133833772ee8dfc3fe4","_count":1,"groupId":"018aeef8f32470db855643b76c70939d","group":{"id":"018aeef8f32470db855643b76c70939d","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Teamsport"}}],"options":[{"id":"a8c0afa33a3b4c3395bb83146362f91f","_count":1,"groupId":"8b2821798c574ee187d1c58e63d4d424","group":{"id":"8b2821798c574ee187d1c58e63d4d424","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"3365 TANGO RED"}},{"id":"b26bb94349e2469ea3e048b8bd50a91d","_count":1,"groupId":"2d5f0f5a4f614de793262c22e833d545","group":{"id":"2d5f0f5a4f614de793262c22e833d545","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"XS"}}],"categoryIds":["0189977481587156a22ab263435d8720","01899818c11871d59a6841ea343f58b0","23756acc3fa84304877fe50205f7585a"],"optionIds":["a8c0afa33a3b4c3395bb83146362f91f","b26bb94349e2469ea3e048b8bd50a91d"],"propertyIds":["018963e5f06f716dadb0fe95b3c53d22","018963ea3964707fbbfb35b2b8e8084b","01896411e82d73ef973f22bb35c69d07","01896412f703702f8629f58ca6f495fb","018dcc3373f47133833772ee8dfc3fe4"],"tagIds":["018f814628c67271bd1304b6bbea30ee","018f814628c771aba8e0e98757ea799e"],"states":["is-physical"],"customFields":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":{"purchasable_item":false,"sample_order_six_flag":true,"custom_products_update_stock":396.0,"custom_products_update_updatedate":"2025-03-03 17:27:03.000","custom_products_update_planned_stock":0.0,"custom_products_update_incoming_stock":0.0,"kilb_productdesigner_product_fieldset_typ":1.0,"allforteam_designer_extension_product_assigned_configuration":"f84088cef62f40f3b5d834145c6329c4,595535bfed0243a38965bb5562959bb2,fc5c6b87ae9f4373afba2bfbf6a1f977,124ba5b120fd441f9eb6643627da66b6","kilb_productdesigner_product_fieldset_assigned_configuration":"f84088cef62f40f3b5d834145c6329c4,595535bfed0243a38965bb5562959bb2,fc5c6b87ae9f4373afba2bfbf6a1f977,124ba5b120fd441f9eb6643627da66b6"}},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"HUMMEL hmlRUN JERSEY L\/S WOMAN - TANGO RED - XS","87c74cec26c54ed8867507ed00a0983a":null},"description":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Die Marke HUMMEL mit ihren T-Shirts \/ Tanks hmlRUN JERSEY L\/S WOMAN - TANGO RED - XS in der Fabre Rot f\u00fcr Damen.","87c74cec26c54ed8867507ed00a0983a":null},"metaTitle":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"HUMMEL hmlRUN JERSEY L\/S WOMAN 3365 TANGO RED XS","87c74cec26c54ed8867507ed00a0983a":null},"metaDescription":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":null,"87c74cec26c54ed8867507ed00a0983a":null},"customSearchKeywords":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":["Laufshirts","T-Shirts \/ Tanks","T-Shirts\/Tanks lg.Arm Da","Teamsportartikel","Sportartikel","22724639736509","227246","227246397","5715454992096","HUMMEL","hmlRUN JERSEY L\/S WOMAN 3365 TANGO RED XS"],"87c74cec26c54ed8867507ed00a0983a":null},"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross":17.96,"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net":15.092436974789917,"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage":9.97,"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage":9.97}]}
|
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 |
|---|---|---|---|
| sw_all4team_product_1716941102 | open | 3, 3 | 5216241 |
| top_queries-2026.04.12-55135 | open | 1, 1 | 597 |
| top_queries-2026.04.14-55137 | open | 1, 1 | 721 |
| 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 |
| sw_all4team_product_1717286702 | open | 3, 3 | 5217102 |
| sw_all4team_product_1717373101 | open | 3, 3 | 5217108 |
| top_queries-2026.04.13-55136 | open | 1, 1 | 659 |
| 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.10-55133 | open | 1, 1 | 767 |
| top_queries-2026.04.16-55139 | open | 1, 1 | 1892 |
| sw_all4team_product_1717200302 | open | 3, 3 | 5217018 |
| sw_all4team_product_1717459502 | open | 3, 3 | 5217133 |
| top_queries-2026.04.17-55140 | open | 1, 1 | 129 |
| top_queries-2026.04.11-55134 | open | 1, 1 | 1202 |
| top_queries-2026.04.15-55138 | open | 1, 1 | 1167 |