Select * vs Select Columns

[Lee Fairbanks]

SELECT *
FROM cw_products P INNER JOIN cw_skus S ON P.product_merchant_product_id = S.sku_merchant_sku_id
WHERE ( P.product_archive <> True AND P.product_merchant_product_id LIKE varSearch) OR (MATCH (P.product_name) AGAINST (varSearch IN NATURAL LANGUAGE MODE) AND P.product_archive <> True ) OR (MATCH (P.product_description) AGAINST (varSearch) AND P.product_archive <> True)

When I Select *, it runs almost instantly but when I list only the columns I need, it's painfully slow which is odd. Any suggestions?