Explain Query (mysql)
EXPLAIN SELECT opted_in FROM promo_users_log WHERE user_id = '203694' AND promo = '30_percent_off_3_weeks_2024'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | promo_users_log | ref | promo_users_log_user_id | promo_users_log_user_id | 4 | const | 3 | 10.00 | Using where |