Show the indexes on a MySQL table

SHOW INDEX FROM orders;

SELECT INDEX_NAME, SEQ_IN_INDEX, COLUMN_NAME, CARDINALITY
  FROM information_schema.STATISTICS
 WHERE TABLE_SCHEMA = 'shop' AND TABLE_NAME = 'orders'
 ORDER BY INDEX_NAME, SEQ_IN_INDEX;