Explain Query (mysql)
EXPLAIN SELECT COUNT(DISTINCT products.name) FROM products WHERE products.status = 1 AND supplier_id IN (1, 376, 113)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | products | ref | idx_status | idx_status | 1 | const | 3357 | 30.00 | Using where |