Mine

EXPLAIN SELECT * FROM product_yahoo INNER JOIN category ON product_yahoo.id = category.prodid WHERE $category LIKE 'T' LIMIT $cur, $limit


---------------

explain:

category  	ALL  	NULL  	NULL  	NULL  	NULL  	56  	where used
product_yahoo 	eq_ref 	id 	id 	100 	category.prodid 	1 	where used