Explain Query (mysql)
EXPLAIN SELECT COUNT(*) AS nb FROM `basket_designs` WHERE `close_date` = '2025-04-18' AND status > 0 AND basket_id IN ('12')
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | basket_designs | ref | close_date | close_date | 4 | const | 5 | 3.33 | Using where |