(root@localhost) [uem_prod]>  show index from lastlogs;
+----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Table    | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| lastlogs |          0 | PRIMARY  |            1 | id          | A         |        NULL |     NULL | NULL   |      | BTREE      |         |
| lastlogs |          0 | PRIMARY  |            2 | datetime    | A         |   128018679 |     NULL | NULL   |      | BTREE      |         |
| lastlogs |          1 | user     |            1 | user        | A         |        NULL |     NULL | NULL   | YES  | BTREE      |         |
| lastlogs |          1 | user     |            2 | datetime    | A         |        NULL |     NULL | NULL   |      | BTREE      |         |
+----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+