Query Metrics
7.00 ms
Query Time
1
Node(s)
23
Indices
Queries
| #▲ | Execution Time | Info |
|---|---|---|
| 1 | 7.71 ms |
Request:
{"index":"sw_all4team_product","body":[{"index":{"_id":"cd17f082a3dd438984e4e3958b0ed6d5"}},{"id":"cd17f082a3dd438984e4e3958b0ed6d5","autoIncrement":1034813.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":8,"productNumber":"3141820K16950121","ean":"4043523866537","displayGroup":"b875a32a12b8669d95b322530d79ee37","sales":0,"stock":8,"weight":0.0,"width":0.0,"length":0.0,"height":0.0,"manufacturerId":"69126f5efcab45738b242009148aca51","manufacturerNumber":"3141820K","releaseDate":"2023-06-27T05:25:55+00:00","createdAt":"2023-06-27T05:25:55+00:00","categoryTree":["e488bb219113483a84172a9a5c446883","23756acc3fa84304877fe50205f7585a","018997685f47711d92351896a28f6110","01899769fec370a5b5e1928c86c411de","018997cd8b7671fc9ab2b947735e6801","2ed97bbb21a840a4a74174028a008a89","0189984e914c71cfad59845f8d079d79","472042bbc4ab42cea38631c70b02e657","8bee7ab7cacf45d78a47947b902095b9"],"categoriesRo":[{"id":"e488bb219113483a84172a9a5c446883","_count":1},{"id":"23756acc3fa84304877fe50205f7585a","_count":1},{"id":"018997685f47711d92351896a28f6110","_count":1},{"id":"01899769fec370a5b5e1928c86c411de","_count":1},{"id":"018997cd8b7671fc9ab2b947735e6801","_count":1},{"id":"2ed97bbb21a840a4a74174028a008a89","_count":1},{"id":"0189984e914c71cfad59845f8d079d79","_count":1},{"id":"472042bbc4ab42cea38631c70b02e657","_count":1},{"id":"8bee7ab7cacf45d78a47947b902095b9","_count":1}],"taxId":"572b2f69c09840c6a0c776d306ea2966","tags":[{"id":"9f9d6cd2b4bd4e49b673ee7e10f973cb","name":"all4team","_count":1},{"id":"65040ee5c9f249edaa5754b3c74e4773","name":"Teamsportbekleidung","_count":1}],"parentId":"0c4bc97b49ce49e6bcbad4cf081a69ae","coverId":"019de12c06ba729d89b32160f2b5413c","childCount":0,"categories":[{"id":"018997cd8b7671fc9ab2b947735e6801","_count":1,"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Trikots"}},{"id":"472042bbc4ab42cea38631c70b02e657","_count":1,"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Tiefbau"}},{"id":"23756acc3fa84304877fe50205f7585a","_count":1,"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Teamsport"}},{"id":"8bee7ab7cacf45d78a47947b902095b9","_count":1,"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"trikot-meister.de"}},{"id":"0189984e914c71cfad59845f8d079d79","_count":1,"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Torwarttrikots Langarm"}}],"manufacturer":{"id":"69126f5efcab45738b242009148aca51","name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"ERIMA","87c74cec26c54ed8867507ed00a0983a":null},"_count":1},"properties":[{"id":"018963e5f32b703288aad57690802852","_count":1,"groupId":"018aeef8f32470db855643b76c70939d","group":{"id":"018aeef8f32470db855643b76c70939d","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Kinder"}},{"id":"018963ea313d732aab9f9437134e1b76","_count":1,"groupId":"018ae9d28fa471979e520453984303f8","group":{"id":"018ae9d28fa471979e520453984303f8","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"new royal"}},{"id":"01896411e3007292bbf291a9837a8cc8","_count":1,"groupId":"018963e5e9c372ae844959c17e5007bd","group":{"id":"018963e5e9c372ae844959c17e5007bd","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Fu\u00dfball"}},{"id":"01896413099c714695272cd7867bcd2e","_count":1,"groupId":"018aeef91bde71e8be1f4167e2de9a86","group":{"id":"018aeef91bde71e8be1f4167e2de9a86","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Torwarttrikots lg.Arm Ki"}}],"options":[{"id":"018dd5f6ea6641c7b569a0bef47cdc68","_count":1,"groupId":"8b2821798c574ee187d1c58e63d4d424","group":{"id":"8b2821798c574ee187d1c58e63d4d424","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"501 new royal"}},{"id":"60de90a916684ef696e8ba9bd8060cbc","_count":1,"groupId":"2d5f0f5a4f614de793262c22e833d545","group":{"id":"2d5f0f5a4f614de793262c22e833d545","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"128"}}],"categoryIds":["018997cd8b7671fc9ab2b947735e6801","0189984e914c71cfad59845f8d079d79","23756acc3fa84304877fe50205f7585a","472042bbc4ab42cea38631c70b02e657","8bee7ab7cacf45d78a47947b902095b9"],"optionIds":["018dd5f6ea6641c7b569a0bef47cdc68","60de90a916684ef696e8ba9bd8060cbc"],"propertyIds":["018963e5f32b703288aad57690802852","018963ea313d732aab9f9437134e1b76","01896411e3007292bbf291a9837a8cc8","01896413099c714695272cd7867bcd2e"],"tagIds":["65040ee5c9f249edaa5754b3c74e4773","9f9d6cd2b4bd4e49b673ee7e10f973cb"],"states":["is-physical"],"customFields":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":{"sample_order_six_flag":true,"custom_products_update_stock":550.0,"custom_products_update_updatedate":"2025-02-20 08:24:11.000","custom_products_update_planned_stock":0.0,"custom_products_update_incoming_stock":0.0,"allforteam_designer_extension_product_assigned_configuration":"fa5c2f0fa8a44b4abf5044eb39fb66f8,930cc74132114514a32140b5c700c65e,adb0688e631d43a2ac024a5ea9c18506,f496498b9c084948a978244c72bff5da","kilb_productdesigner_product_fieldset_assigned_configuration":"fa5c2f0fa8a44b4abf5044eb39fb66f8,930cc74132114514a32140b5c700c65e,adb0688e631d43a2ac024a5ea9c18506,f496498b9c084948a978244c72bff5da","purchasable_item":false,"kilb_productdesigner_product_fieldset_typ":13.0}},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"ERIMA Kinder Trikot Liga langarm","87c74cec26c54ed8867507ed00a0983a":null},"description":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Klassisches funktionelles Langarm-Trikot mit gezielter Mesh-Bel\u00fcftung.","87c74cec26c54ed8867507ed00a0983a":null},"metaTitle":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"ERIMA LIGA jersey longsleeve 501 new royal 128","87c74cec26c54ed8867507ed00a0983a":null},"metaDescription":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":null,"87c74cec26c54ed8867507ed00a0983a":null},"customSearchKeywords":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":["Fussball Torwartbekleidung","Torwarttrikots","Torwarttrikots lg.Arm Ki","Teamsportartikel","Sportartikel","3141820K16950121","3141820K","3141820K169","4043523866537","ERIMA","LIGA jersey longsleeve 501 new royal 128"],"87c74cec26c54ed8867507ed00a0983a":null},"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross":12.0,"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net":10.084033613445378,"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage":49.98,"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage":49.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": 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.27-55171 | open | 1, 1 | 424 |
| top_queries-2026.04.28-55172 | open | 1, 1 | 606 |
| sw_all4team_product_1716941102 | open | 3, 3 | 5216241 |
| top_queries-2026.05.01-84894 | open | 1, 1 | 52 |
| sw_all4team_product_1717545902 | open | 3, 3 | 5217183 |
| sw_all4team_product_1717113901 | open | 3, 3 | 5216814 |
| top_queries-2026.04.24-55168 | open | 1, 1 | 861 |
| top_queries-2026.04.30-55195 | open | 1, 1 | 777 |
| top_queries-2026.04.29-55173 | open | 1, 1 | 853 |
| 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 |
| 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 |
| sw_all4team_product_1717200302 | open | 3, 3 | 5217018 |
| sw_all4team_product_1717459502 | open | 3, 3 | 5217133 |
| top_queries-2026.04.26-55170 | open | 1, 1 | 909 |
| top_queries-2026.04.25-55169 | open | 1, 1 | 530 |