Explain Query (mysql)
EXPLAIN SELECT * FROM `tickets` `t` WHERE ((ticket_type='Email') AND (status='1')) AND (agent_id='618755')
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | t | ref | agent_id, status | agent_id | 5 | const | 2 | 2.50 | Using where |