Query Metrics
6.00 ms
Query Time
1
Node(s)
23
Indices
Queries
| #▲ | Execution Time | Info |
|---|---|---|
| 1 | 6.31 ms |
Request:
{"index":"sw_all4team_product","body":[{"index":{"_id":"d29adddd3eb2447a9f70e540d2482d83"}},{"id":"d29adddd3eb2447a9f70e540d2482d83","autoIncrement":993042.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":334,"productNumber":"190885078000224","ean":"7318573273954","displayGroup":"2ecc5143ae7081ba5fde74a31b0ad888","sales":0,"stock":334,"weight":0.0,"width":0.0,"length":0.0,"height":0.0,"manufacturerId":"2a606633b77f4e1bab45f45f3483a835","manufacturerNumber":"1908850","releaseDate":"2023-06-27T03:29:11+00:00","createdAt":"2023-06-27T03:29:11+00:00","categoryTree":["e488bb219113483a84172a9a5c446883","23756acc3fa84304877fe50205f7585a","018997682a78734eb600767b8b86f756","018997699635722d987669d9a82eaad5","018997a43c98708984a8c04eb61e46a5","01899834fe6b71a6b3a6b5232859ef20","8bee7ab7cacf45d78a47947b902095b9"],"categoriesRo":[{"id":"e488bb219113483a84172a9a5c446883","_count":1},{"id":"23756acc3fa84304877fe50205f7585a","_count":1},{"id":"018997682a78734eb600767b8b86f756","_count":1},{"id":"018997699635722d987669d9a82eaad5","_count":1},{"id":"018997a43c98708984a8c04eb61e46a5","_count":1},{"id":"01899834fe6b71a6b3a6b5232859ef20","_count":1},{"id":"8bee7ab7cacf45d78a47947b902095b9","_count":1}],"taxId":"572b2f69c09840c6a0c776d306ea2966","tags":[{"id":"5bf8b826ee78489d828153bb9047588a","name":"all4team","_count":1},{"id":"e5f8ff23434b4ebfb2d1505cd3fcd63a","name":"Teamsportbekleidung","_count":1}],"parentId":"356cef053fb6441aa5e1b2c092866466","coverId":"019e1196073270468c66c810156dca9a","childCount":0,"categories":[{"id":"23756acc3fa84304877fe50205f7585a","_count":1,"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Teamsport"}},{"id":"01899834fe6b71a6b3a6b5232859ef20","_count":1,"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Unterhemden"}},{"id":"8bee7ab7cacf45d78a47947b902095b9","_count":1,"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"trikot-meister.de"}},{"id":"018997a43c98708984a8c04eb61e46a5","_count":1,"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Unterw\u00e4sche Sommer"}}],"manufacturer":{"id":"2a606633b77f4e1bab45f45f3483a835","name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"CRAFT","87c74cec26c54ed8867507ed00a0983a":null},"_count":1},"properties":[{"id":"018963e5f13871739bde1b0eb26bb21b","_count":1,"groupId":"018aeef8f32470db855643b76c70939d","group":{"id":"018aeef8f32470db855643b76c70939d","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Herren"}},{"id":"018963ea415c7217b4dc8cb62572ed16","_count":1,"groupId":"018ae9d28fa471979e520453984303f8","group":{"id":"018ae9d28fa471979e520453984303f8","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Wei\u00df"}},{"id":"01896411e78a73399a29ed714246da0d","_count":1,"groupId":"018963e5e9c372ae844959c17e5007bd","group":{"id":"018963e5e9c372ae844959c17e5007bd","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Multisport"}},{"id":"01896413187a71de8aec58913856a1c7","_count":1,"groupId":"018aeef91bde71e8be1f4167e2de9a86","group":{"id":"018aeef91bde71e8be1f4167e2de9a86","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Unterhemden o.Arm He\/Uni"}},{"id":"018bbe147e0f70d98b9e28aaa74ff572","_count":1,"groupId":"018aeef91bde71e8be1f4167e2de9a86","group":{"id":"018aeef91bde71e8be1f4167e2de9a86","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Unterhemd"}}],"options":[{"id":"103c221ef5c547a6919548726a45adb7","_count":1,"groupId":"2d5f0f5a4f614de793262c22e833d545","group":{"id":"2d5f0f5a4f614de793262c22e833d545","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"XL"}},{"id":"7a918eed118c4acf92d5132e41a3cd14","_count":1,"groupId":"8b2821798c574ee187d1c58e63d4d424","group":{"id":"8b2821798c574ee187d1c58e63d4d424","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"900000 WHITE"}}],"categoryIds":["018997a43c98708984a8c04eb61e46a5","01899834fe6b71a6b3a6b5232859ef20","23756acc3fa84304877fe50205f7585a","8bee7ab7cacf45d78a47947b902095b9"],"optionIds":["103c221ef5c547a6919548726a45adb7","7a918eed118c4acf92d5132e41a3cd14"],"propertyIds":["018963e5f13871739bde1b0eb26bb21b","018963ea415c7217b4dc8cb62572ed16","01896411e78a73399a29ed714246da0d","01896413187a71de8aec58913856a1c7","018bbe147e0f70d98b9e28aaa74ff572"],"tagIds":["5bf8b826ee78489d828153bb9047588a","e5f8ff23434b4ebfb2d1505cd3fcd63a"],"states":["is-physical"],"customFields":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":{"sample_order_six_flag":true,"custom_products_update_stock":10422.0,"custom_products_update_updatedate":"2025-02-20 06:46:39.000","custom_products_update_planned_date":"2025-03-01 00:00:00.000","custom_products_update_planned_stock":617.0,"custom_products_update_incoming_stock":498.0,"allforteam_designer_extension_product_assigned_configuration":"98b004e9c51a40ac84766fdfa8cfbde6,3dea8bbc2e334dc7b7a10485724d3b8e","kilb_productdesigner_product_fieldset_assigned_configuration":"98b004e9c51a40ac84766fdfa8cfbde6,3dea8bbc2e334dc7b7a10485724d3b8e","purchasable_item":false,"custom_products_update_incoming_date":"2025-03-01 00:00:00.000","kilb_productdesigner_product_fieldset_typ":7.0}},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"CRAFT Herren Unterw\u00e4sche PRO DRY NANOWEIGHT SL M","87c74cec26c54ed8867507ed00a0983a":null},"description":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Sehr leichtes, k\u00fchlendes, \u00e4rmelloses Mesh-Shirt mit hervorragendem Temperaturmanagement f\u00fcr Aktivit\u00e4ten mit hoher Intensit\u00e4t.","87c74cec26c54ed8867507ed00a0983a":null},"metaTitle":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"CRAFT PRO DRY NANOWEIGHT SL M 900000 WHITE XL","87c74cec26c54ed8867507ed00a0983a":null},"metaDescription":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":null,"87c74cec26c54ed8867507ed00a0983a":null},"customSearchKeywords":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":["Sportw\u00e4sche","Unterhemden","Unterhemden o.Arm He\/Uni","Teamsportartikel","Sportartikel","190885078000224","1908850","1908850780","7318573273954","CRAFT","PRO DRY NANOWEIGHT SL M 900000 WHITE XL"],"87c74cec26c54ed8867507ed00a0983a":null},"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross":29.22,"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net":24.554621848739497,"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage":34.99,"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage":34.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 |
|---|---|---|---|
| sw_all4team_product_1716941102 | open | 3, 3 | 5216241 |
| top_queries-2026.05.09-84902 | open | 1, 1 | 798 |
| top_queries-2026.05.07-84900 | open | 1, 1 | 651 |
| sw_all4team_product_1717545902 | open | 3, 3 | 5217183 |
| top_queries-2026.05.10-84924 | open | 1, 1 | 620 |
| 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.05.08-84901 | open | 1, 1 | 455 |
| top_queries-2026.05.04-84897 | open | 1, 1 | 534 |
| 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 |
| top_queries-2026.05.03-84896 | open | 1, 1 | 696 |
| sw_all4team_product_1717718701 | open | 3, 3 | 5217475 |
| top_queries-2026.05.05-84898 | open | 1, 1 | 538 |
| 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.05.06-84899 | open | 1, 1 | 1057 |