SELECT 
  pd.product_id 
FROM 
  cscart_product_descriptions AS pd 
WHERE 
  pd.lang_code = 'en' 
  AND (
    pd.product LIKE '%calculator product%' 
    OR pd.full_description LIKE '%calculator product%' 
    OR pd.meta_keywords LIKE '%calculator product%'
  ) 
LIMIT 
  5

Query time 0.00247