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

Query time 0.00268

Result

product_id
2917
2921
2922
2923