Query Metrics
5.00 ms
Query Time
1
Node(s)
23
Indices
Queries
| #▲ | Execution Time | Info |
|---|---|---|
| 1 | 5.35 ms |
Request:
{"index":"sw_all4team_product","body":[{"index":{"_id":"fa5aaeaf5a53428a8ac48371279b058b"}},{"id":"fa5aaeaf5a53428a8ac48371279b058b","autoIncrement":992219.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":102,"productNumber":"190826478000240","ean":"7318573199186","displayGroup":"15de320db7dd2b298b3f5c686c2f0770","sales":0,"stock":102,"weight":0.0,"width":0.0,"length":0.0,"height":0.0,"manufacturerId":"2a606633b77f4e1bab45f45f3483a835","manufacturerNumber":"1908264","releaseDate":"2023-06-27T03:27:44+00:00","createdAt":"2023-06-27T03:27:44+00:00","categoryTree":["e488bb219113483a84172a9a5c446883","23756acc3fa84304877fe50205f7585a","01899767eecf73e2b11b9e65fbdd4d20","01899769632173d3a8557d9a49d0a345","0189977888fd71b0a3c9f459d008008c","8bee7ab7cacf45d78a47947b902095b9"],"categoriesRo":[{"id":"e488bb219113483a84172a9a5c446883","_count":1},{"id":"23756acc3fa84304877fe50205f7585a","_count":1},{"id":"01899767eecf73e2b11b9e65fbdd4d20","_count":1},{"id":"01899769632173d3a8557d9a49d0a345","_count":1},{"id":"0189977888fd71b0a3c9f459d008008c","_count":1},{"id":"8bee7ab7cacf45d78a47947b902095b9","_count":1}],"taxId":"572b2f69c09840c6a0c776d306ea2966","tags":[{"id":"24253e36f5aa4c81a5cafe1397211007","name":"all4team","_count":1},{"id":"3b9a95ee1ff24928aacd53fa96673acc","name":"Teamsportbekleidung","_count":1}],"parentId":"493ecf3197cb4b49b1240cd7935dd670","coverId":"019ef829e14a71b2aba03ecd01f4a610","childCount":0,"categories":[{"id":"01899769632173d3a8557d9a49d0a345","_count":1,"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Schuhe"}},{"id":"23756acc3fa84304877fe50205f7585a","_count":1,"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Teamsport"}},{"id":"0189977888fd71b0a3c9f459d008008c","_count":1,"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Laufschuhe"}},{"id":"8bee7ab7cacf45d78a47947b902095b9","_count":1,"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"trikot-meister.de"}}],"manufacturer":{"id":"2a606633b77f4e1bab45f45f3483a835","name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"CRAFT","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":"01896412ce257222b5e891706c8b902f","_count":1,"groupId":"018aeef91bde71e8be1f4167e2de9a86","group":{"id":"018aeef91bde71e8be1f4167e2de9a86","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Running-Sch. Da"}},{"id":"018bbe1474b972549ff49ff501fe894c","_count":1,"groupId":"018aeef91bde71e8be1f4167e2de9a86","group":{"id":"018aeef91bde71e8be1f4167e2de9a86","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Laufschuhe"}}],"options":[{"id":"2bc45bc05df945f8a5403892f38513f9","_count":1,"groupId":"8b2821798c574ee187d1c58e63d4d424","group":{"id":"8b2821798c574ee187d1c58e63d4d424","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"430000 BRIGHT RED"}},{"id":"c36af3803d914e8bb422246a1b400a68","_count":1,"groupId":"29b9559a4e0045db8054abf9a0016cce","group":{"id":"29b9559a4e0045db8054abf9a0016cce","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"6"}}],"categoryIds":["01899769632173d3a8557d9a49d0a345","0189977888fd71b0a3c9f459d008008c","23756acc3fa84304877fe50205f7585a","8bee7ab7cacf45d78a47947b902095b9"],"optionIds":["2bc45bc05df945f8a5403892f38513f9","c36af3803d914e8bb422246a1b400a68"],"propertyIds":["018963e5f06f716dadb0fe95b3c53d22","018963ea3964707fbbfb35b2b8e8084b","01896411e82d73ef973f22bb35c69d07","01896412ce257222b5e891706c8b902f","018bbe1474b972549ff49ff501fe894c"],"tagIds":["24253e36f5aa4c81a5cafe1397211007","3b9a95ee1ff24928aacd53fa96673acc"],"states":["is-physical"],"customFields":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":{"sample_order_six_flag":false,"custom_products_update_stock":2793.0,"custom_products_update_updatedate":"2025-02-19 21:03:08.000","custom_products_update_planned_date":"2025-03-01 00:00:00.000","custom_products_update_incoming_date":"2025-03-01 00:00:00.000","custom_products_update_planned_stock":155.0,"custom_products_update_incoming_stock":145.0,"purchasable_item":false,"kilb_productdesigner_product_fieldset_typ":0.0}},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"CRAFT Damen Schuh V150 ENGINEERED W","87c74cec26c54ed8867507ed00a0983a":null},"description":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Leichter Laufschuh mit hervorragender Flexibilit\u00e4t und hohem Rebound. Optimal f\u00fcr l\u00e4ngere L\u00e4ufe und Intervalltraining. Das Mesh-Obermaterial sorgt f\u00fcr optimale Bewegungsfreiheit und hohen Tragekomfort. Die Zwischensohle aus Ar-Foam garantiert eine hohe Energier\u00fcckgabe. Ausgestattet mit einer Vibram\u00ae-Sohle, bietet der Schuh maximalen Grip auf allen Oberfl\u00e4chen. Durch die gro\u00dfe Farbauswahl bietet sich der V150 Engineered zur individuellen Veredelung mit dem Firmen- oder Vereinslogo an. Perfekt f\u00fcr Mitarbeiter, Teams und Vereine, f\u00fcr einen einheitlichen, herausragenden Auftritt.","87c74cec26c54ed8867507ed00a0983a":null},"metaTitle":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"CRAFT V150 ENGINEERED W 430000 BRIGHT RED 6","87c74cec26c54ed8867507ed00a0983a":null},"metaDescription":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":null,"87c74cec26c54ed8867507ed00a0983a":null},"customSearchKeywords":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":["Laufschuhe","Running-Sch.","Running-Sch. Da","Teamsportartikel","Sportartikel","190826478000240","1908264","1908264780","7318573199186","CRAFT","V150 ENGINEERED W 430000 BRIGHT RED 6"],"87c74cec26c54ed8867507ed00a0983a":null},"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross":84.47,"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net":70.98319327731093,"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage":35.0,"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage":35.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 |
|---|---|---|---|
| sw_all4team_product_1716941102 | open | 3, 3 | 5216241 |
| sw_all4team_product_1717545902 | open | 3, 3 | 5217183 |
| top_queries-2026.06.19-14724 | open | 1, 1 | 856 |
| top_queries-2026.06.23-14749 | open | 1, 1 | 597 |
| sw_all4team_product_1717113901 | open | 3, 3 | 5216814 |
| top_queries-2026.06.24-14750 | open | 1, 1 | 60 |
| top_queries-2026.06.20-14746 | open | 1, 1 | 1523 |
| sw_all4team_product_1717027502 | open | 3, 3 | 5216573 |
| top_queries-2026.06.18-14723 | open | 1, 1 | 777 |
| .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.17-14722 | open | 1, 1 | 449 |
| 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 |
| top_queries-2026.06.21-14747 | open | 1, 1 | 564 |
| top_queries-2026.06.22-14748 | open | 1, 1 | 392 |
| 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 |