Explain Query (mysql)
EXPLAIN SELECT * FROM `user_payments` `t` WHERE `t`.`user_id`='203694' AND `t`.`in_use`=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 | 6 | 10.00 | Using where |