mysql> EXPLAIN
SELECT count(1) AS s
FROM item
LEFT JOIN color_info ON color_info.color_no = item.color_no
LEFT JOIN brand ON brand.brand_no = item.brand_no
LEFT JOIN shop_brand ON shop_brand.brand_no = item.brand_no
WHERE 1 = 1;
+----+-------------+------------+--------+---------------+---------------------+---------+-----------------------+--------+-----------------------------------------------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+------------+--------+---------------+---------------------+---------+-----------------------+--------+-----------------------------------------------------------------+
| 1 | SIMPLE | item | index | NULL | ix_brand_color_no_1 | 109 | NULL | 322260 | Using index |
| 1 | SIMPLE | color_info | eq_ref | uk_color_no | uk_color_no | 54 | lottery.item.color_no | 1 | Using index |
| 1 | SIMPLE | brand | eq_ref | uk_brand_no | uk_brand_no | 54 | lottery.item.brand_no | 1 | Using index |
| 1 | SIMPLE | shop_brand | index | NULL | uk_store_brand | 165 | NULL | 61992 | Using where; Using index; Using join buffer (Block Nested Loop) |
+----+-------------+------------+--------+---------------+---------------------+---------+-----------------------+--------+-----------------------------------------------------------------+
4 rows in set
mysql>