Query Metrics
11.00 ms
Query Time
1
Node(s)
23
Indices
Queries
| #▲ | Execution Time | Info |
|---|---|---|
| 1 | 11.03 ms |
Request:
{"index":"sw_all4team_product","body":[{"index":{"_id":"0190ee41ed3673729ccc20a818fd25cc"}},{"id":"0190ee41ed3673729ccc20a818fd25cc","autoIncrement":1842452.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":"100285K74145001","ean":"9995840945035","displayGroup":"47f7fad7f87fbfd2c446f8b194dd0032","sales":0,"stock":1,"weight":0.0,"width":0.0,"length":0.0,"height":0.0,"manufacturerId":"018f76587934730f8674bc05947f9054","manufacturerNumber":"100285K","releaseDate":"2026-02-05T15:00:52+00:00","createdAt":"2024-07-26T08:56:56+00:00","categoryTree":["e488bb219113483a84172a9a5c446883","23756acc3fa84304877fe50205f7585a","018997685f47711d92351896a28f6110","01899769fec370a5b5e1928c86c411de","018997bf6f5072778844c1f04f26c4f0"],"categoriesRo":[{"id":"e488bb219113483a84172a9a5c446883","_count":1},{"id":"23756acc3fa84304877fe50205f7585a","_count":1},{"id":"018997685f47711d92351896a28f6110","_count":1},{"id":"01899769fec370a5b5e1928c86c411de","_count":1},{"id":"018997bf6f5072778844c1f04f26c4f0","_count":1}],"taxId":"572b2f69c09840c6a0c776d306ea2966","tags":[],"parentId":"0190ea31a1f8734fb4b900b67449594e","coverId":"019ec505bec6719f81d755ed6852d96b","childCount":0,"categories":[{"id":"23756acc3fa84304877fe50205f7585a","_count":1,"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Teamsport"}},{"id":"01899769fec370a5b5e1928c86c411de","_count":1,"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Bekleidung"}},{"id":"018997bf6f5072778844c1f04f26c4f0","_count":1,"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Sweatshirts"}}],"manufacturer":{"id":"018f76587934730f8674bc05947f9054","name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"JOMA","87c74cec26c54ed8867507ed00a0983a":null},"_count":1},"properties":[{"id":"018963e5f13871739bde1b0eb26bb21b","_count":1,"groupId":"018aeef8f32470db855643b76c70939d","group":{"id":"018aeef8f32470db855643b76c70939d","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Herren"}},{"id":"01896411e3af718192fb7f9ee45ad6fb","_count":1,"groupId":"018963e5e9c372ae844959c17e5007bd","group":{"id":"018963e5e9c372ae844959c17e5007bd","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Fussball"}},{"id":"018bbe1479bd7172a96f8a7ec65759d6","_count":1,"groupId":"018aeef91bde71e8be1f4167e2de9a86","group":{"id":"018aeef91bde71e8be1f4167e2de9a86","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Sweatshirt"}}],"options":[{"id":"018f7658495e71baabac4f07e8b918af","_count":1,"groupId":"8b2821798c574ee187d1c58e63d4d424","group":{"id":"8b2821798c574ee187d1c58e63d4d424","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"450 GR\u00dcN"}},{"id":"018f76587536718c872c84e2afe3f9a5","_count":1,"groupId":"2d5f0f5a4f614de793262c22e833d545","group":{"id":"2d5f0f5a4f614de793262c22e833d545","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"6XS"}}],"categoryIds":["01899769fec370a5b5e1928c86c411de","018997bf6f5072778844c1f04f26c4f0","23756acc3fa84304877fe50205f7585a"],"optionIds":["018f7658495e71baabac4f07e8b918af","018f76587536718c872c84e2afe3f9a5"],"propertyIds":["018963e5f13871739bde1b0eb26bb21b","01896411e3af718192fb7f9ee45ad6fb","018bbe1479bd7172a96f8a7ec65759d6"],"tagIds":[],"states":["is-physical"],"customFields":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":{"sample_order_six_flag":true,"custom_products_update_stock":7.0,"custom_products_update_updatedate":"2025-03-13 14:36:13.000","custom_products_update_planned_stock":0.0,"custom_products_update_incoming_stock":0.0,"allforteam_designer_extension_product_assigned_configuration":"fa5a518e796e4b308163c67b3ad4abc0,133f016161684ee1811ae72ed9ccc952,ecc4673adb984bf787080373f3f20dca,3627bd136040432aaa1924f1db2a02f9","kilb_productdesigner_product_fieldset_assigned_configuration":"fa5a518e796e4b308163c67b3ad4abc0,133f016161684ee1811ae72ed9ccc952,ecc4673adb984bf787080373f3f20dca,3627bd136040432aaa1924f1db2a02f9","purchasable_item":true,"kilb_productdesigner_product_fieldset_typ":6.0}},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"JOMA Herren ZipTop Combi Faraon","87c74cec26c54ed8867507ed00a0983a":null},"description":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"ZIPTOP COMBI FARAON 020 FLUORGR\u00dcN 3XS","87c74cec26c54ed8867507ed00a0983a":null},"metaTitle":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"JOMA ZIPTOP COMBI FARAON 450 GR\u00dcN 6XS","87c74cec26c54ed8867507ed00a0983a":null},"metaDescription":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":null,"87c74cec26c54ed8867507ed00a0983a":null},"customSearchKeywords":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":["Fussball Oberteile","Sweatshirts","Sweatshirts lg.Arm Ki","Teamsportartikel","Sportartikel","100285K74145001","100285K","100285K741","9995840945035","JOMA","ZIPTOP COMBI FARAON 450 GR\u00dcN 6XS"],"87c74cec26c54ed8867507ed00a0983a":null},"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross":15.75,"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net":13.23529411764706,"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.06.09-14693 | open | 1, 1 | 400 |
| sw_all4team_product_1716941102 | open | 3, 3 | 5216241 |
| sw_all4team_product_1717545902 | open | 3, 3 | 5217183 |
| top_queries-2026.06.14-14719 | open | 1, 1 | 18 |
| sw_all4team_product_1717113901 | open | 3, 3 | 5216814 |
| top_queries-2026.06.10-14715 | open | 1, 1 | 700 |
| sw_all4team_product_1717027502 | open | 3, 3 | 5216573 |
| top_queries-2026.06.13-14718 | open | 1, 1 | 14 |
| .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.06.12-14717 | open | 1, 1 | 390 |
| sw_all4team_product_1716336301 | open | 3, 3 | 6275005 |
| .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.06.07-14691 | open | 1, 1 | 486 |
| top_queries-2026.06.08-14692 | open | 1, 1 | 644 |
| top_queries-2026.06.11-14716 | open | 1, 1 | 838 |