Query Metrics
4.00 ms
Query Time
1
Node(s)
23
Indices
Queries
| #▲ | Execution Time | Info |
|---|---|---|
| 1 | 4.80 ms |
Request:
{"index":"sw_all4team_product","body":[{"index":{"_id":"01909d16967b72998b0d1884b7663a8e"}},{"id":"01909d16967b72998b0d1884b7663a8e","autoIncrement":1830511.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":"10809615300330","ean":"4067979355575","displayGroup":"44822242929ca66e35da08c664cfae41","sales":0,"stock":0,"weight":0.0,"width":0.0,"length":0.0,"height":0.0,"manufacturerId":"d8ac016c293145ff9d20f96184a4ad02","manufacturerNumber":"108096","releaseDate":"2026-02-05T19:20:05+00:00","createdAt":"2024-07-10T14:40:21+00:00","categoryTree":["e488bb219113483a84172a9a5c446883","23756acc3fa84304877fe50205f7585a","018997685f47711d92351896a28f6110","0189976a323e7232adbeb628d1a78c09","018997fd5a94727bb15810ca3090fb16","018997fffd4d71dda8670dbec08c9711"],"categoriesRo":[{"id":"e488bb219113483a84172a9a5c446883","_count":1},{"id":"23756acc3fa84304877fe50205f7585a","_count":1},{"id":"018997685f47711d92351896a28f6110","_count":1},{"id":"0189976a323e7232adbeb628d1a78c09","_count":1},{"id":"018997fd5a94727bb15810ca3090fb16","_count":1},{"id":"018997fffd4d71dda8670dbec08c9711","_count":1}],"taxId":"572b2f69c09840c6a0c776d306ea2966","tags":[{"id":"01909d16967b72998b0d1884b77668e6","name":"all4team","_count":1},{"id":"01909d16967c72d2b62ed8cf2b1cc775","name":"Teamsportbekleidung","_count":1}],"parentId":"01909c53349a706aa8369aa2b02fbee1","coverId":"019cace819cb73bca57e83d3855b2cfe","childCount":0,"categories":[{"id":"23756acc3fa84304877fe50205f7585a","_count":1,"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Teamsport"}},{"id":"018997fd5a94727bb15810ca3090fb16","_count":1,"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Fussballschuhe"}},{"id":"018997fffd4d71dda8670dbec08c9711","_count":1,"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Fussballschuhe Nocken"}}],"manufacturer":{"id":"d8ac016c293145ff9d20f96184a4ad02","name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"PUMA","87c74cec26c54ed8867507ed00a0983a":null},"_count":1},"properties":[{"id":"018963e5f32b703288aad57690802852","_count":1,"groupId":"018aeef8f32470db855643b76c70939d","group":{"id":"018aeef8f32470db855643b76c70939d","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Kinder"}},{"id":"018963ea1812737fb7f416641565cd24","_count":1,"groupId":"018ae9d28fa471979e520453984303f8","group":{"id":"018ae9d28fa471979e520453984303f8","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Blau"}},{"id":"018963ea3aba7042895b047285c1402e","_count":1,"groupId":"018ae9d28fa471979e520453984303f8","group":{"id":"018ae9d28fa471979e520453984303f8","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Schwarz"}},{"id":"01896411e3007292bbf291a9837a8cc8","_count":1,"groupId":"018963e5e9c372ae844959c17e5007bd","group":{"id":"018963e5e9c372ae844959c17e5007bd","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Fu\u00dfball"}},{"id":"01896412751a72d6bee9f7d197ea92d6","_count":1,"groupId":"018aeef91bde71e8be1f4167e2de9a86","group":{"id":"018aeef91bde71e8be1f4167e2de9a86","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Fu\u00dfb.-Nockensch. (FG) Ki"}}],"options":[{"id":"01909baa8a5e71d19a057b33fe293e3d","_count":1,"groupId":"8b2821798c574ee187d1c58e63d4d424","group":{"id":"8b2821798c574ee187d1c58e63d4d424","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"003 Fizzy Apple-PUMA White-Blu"}},{"id":"a1b16c0b889547219de3c5a29864a17b","_count":1,"groupId":"29b9559a4e0045db8054abf9a0016cce","group":{"id":"29b9559a4e0045db8054abf9a0016cce","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"2"}}],"categoryIds":["018997fd5a94727bb15810ca3090fb16","018997fffd4d71dda8670dbec08c9711","23756acc3fa84304877fe50205f7585a"],"optionIds":["01909baa8a5e71d19a057b33fe293e3d","a1b16c0b889547219de3c5a29864a17b"],"propertyIds":["018963e5f32b703288aad57690802852","018963ea1812737fb7f416641565cd24","018963ea3aba7042895b047285c1402e","01896411e3007292bbf291a9837a8cc8","01896412751a72d6bee9f7d197ea92d6"],"tagIds":["01909d16967b72998b0d1884b77668e6","01909d16967c72d2b62ed8cf2b1cc775"],"states":["is-physical"],"customFields":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":{"sample_order_six_flag":false,"custom_products_update_stock":2.0,"custom_products_update_updatedate":"2025-03-12 19:42:17.000","custom_products_update_planned_stock":0.0,"custom_products_update_incoming_stock":2.0,"purchasable_item":false,"custom_products_update_incoming_date":"2025-03-25 00:00:00.000","kilb_productdesigner_product_fieldset_typ":0.0}},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"ULTRA 5 MATCH FG\/AG Jr 003 Fizzy Apple-PUMA White-Blu 1,5","87c74cec26c54ed8867507ed00a0983a":null},"description":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"ULTRA 5 MATCH FG\/AG Jr 003 Fizzy Apple-PUMA White-Blu 1,5","87c74cec26c54ed8867507ed00a0983a":null},"metaTitle":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"PUMA ULTRA 5 MATCH FG\/AG Jr 003 Fizzy Apple-White-Blu 2","87c74cec26c54ed8867507ed00a0983a":null},"metaDescription":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":null,"87c74cec26c54ed8867507ed00a0983a":null},"customSearchKeywords":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":["Fussballschuhe","Fu\u00dfb.-Nocken (FG)","Fu\u00dfb.-Nockensch. (FG) Ki","Teamsportartikel","Sportartikel","10809615300330","108096","108096153","4067979355575","PUMA","ULTRA 5 MATCH FG\/AG Jr 003 Fizzy Apple-PUMA White-Blu 2"],"87c74cec26c54ed8867507ed00a0983a":null},"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross":51.96,"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net":43.66386554621849,"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage":20.0,"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage":20.0}]}
|
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.03.01-25312 | open | 1, 1 | 710 |
| sw_all4team_product_1716941102 | open | 3, 3 | 5216241 |
| top_queries-2026.02.23-95585 | open | 1, 1 | 1197 |
| top_queries-2026.02.28-95590 | open | 1, 1 | 848 |
| sw_all4team_product_1717545902 | open | 3, 3 | 5217183 |
| sw_all4team_product_1717113901 | open | 3, 3 | 5216814 |
| sw_all4team_product_1717027502 | open | 3, 3 | 5216573 |
| top_queries-2026.03.02-25313 | open | 1, 1 | 220 |
| .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.02.26-95588 | open | 1, 1 | 765 |
| sw_all4team_product_1716336301 | open | 3, 3 | 6274469 |
| .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.02.27-95589 | open | 1, 1 | 733 |
| top_queries-2026.02.25-95587 | open | 1, 1 | 556 |
| 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.02.24-95586 | open | 1, 1 | 1009 |