Explain Query (mysql)
EXPLAIN SELECT * FROM `user_payments` `t` WHERE `t`.`user_id`='308842' AND `t`.`in_use`=1 ORDER BY card_priority ASC LIMIT 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | t | ref | user_id Index | user_id Index | 5 | const | 5 | 10.00 | Using where; Using filesort |