Queries not using index

Code: Select all

SELECT count(pa.product_id) as total FROM product_attribute pa JOIN product p ON pa.product_id = p.product_id WHERE 
                                    (pa.text = 'Gold')
                                AND pa.product_id IN (70,71,72,73,74,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104)
				    AND pa.language_id=1
				    AND pa.attribute_id=15
				    AND p.status = 1;


SELECT count(pa.product_id) as total FROM product_attribute pa JOIN product p ON pa.product_id = p.product_id WHERE 
                                    (pa.text = 'Black')
                                AND pa.product_id IN (70,71,72,73,74,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104)
				    AND pa.language_id=1
				    AND pa.attribute_id=19
				    AND p.status = 1;