Explain Query (mysql)
EXPLAIN SELECT
IF(u.mask_donor_identity = 0, CONCAT(u.first_name, ' ', UPPER(LEFT(u.last_name, 1)), '.'), IF(s.type = 1, 'Lufavore', 'Super Lufavore')) AS user,
-1 * t.amount as amount,
u.family_size as family_size,
t.type,
t.created_time
FROM
`transactions` t
INNER JOIN users u ON (u.user_id = t.user_id)
INNER JOIN subscriptions s ON (u.user_id = s.user_id)
WHERE
t.type IN (109, 110, 111, 112, 1, 2) AND
DATE(t.created_time) BETWEEN SUBDATE(CURDATE(), INTERVAL 7 DAY) AND CURDATE()
ORDER BY
t.`transaction_id` DESC
LIMIT 10
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | t | index | idx_user_id, idx_type | PRIMARY | 4 | 761 | 1.31 | Using where; Backward index scan | ||
| 1 | SIMPLE | s | eq_ref | uniq_sub_per_user, idx_user_id | uniq_sub_per_user | 4 | securelufacom.t.user_id | 1 | 100.00 | ||
| 1 | SIMPLE | u | eq_ref | PRIMARY | PRIMARY | 4 | securelufacom.t.user_id | 1 | 100.00 |