Explain Query (mysql)
EXPLAIN SELECT
SUM(IF(t.amount>0, t.amount, 0)) AS 'total_contribution_past_week',
SUM(IF(t.amount<0, t.amount, 0)) AS 'total_spent_past_week'
FROM `transactions` t
LEFT JOIN users u ON u.user_id = t.staff_id
WHERE DATE(t.created_time) BETWEEN SUBDATE(CURDATE(), INTERVAL 7 DAY) AND CURDATE()
AND t.user_id = 311062
ORDER BY `transaction_id` DESC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | t | ref | idx_user_id | idx_user_id | 4 | const | 366554 | 100.00 | Using where | |
| 1 | SIMPLE | u | eq_ref | PRIMARY | PRIMARY | 4 | securelufacom.t.staff_id | 1 | 100.00 | Using index |