Some queries are missing an index

[nickvergessen]

E.g.

EXPLAIN SELECT * FROM `oc_suspicious_login_model` WHERE `address_type` = 'ipv6' ORDER BY `created_at` desc LIMIT 1;
+------+-------------+---------------------------+------+---------------+------+---------+------+------+-----------------------------+
| id   | select_type | table                     | type | possible_keys | key  | key_len | ref  | rows | Extra                       |
+------+-------------+---------------------------+------+---------------+------+---------+------+------+-----------------------------+
|    1 | SIMPLE      | oc_suspicious_login_model | ALL  | NULL          | NULL | NULL    | NULL | 1155 | Using where; Using filesort |
+------+-------------+---------------------------+------+---------------+------+---------+------+------+-----------------------------+
1 row in set (0.000 sec)