Sandbox

SELECT 
  cscart_ult_product_descriptions.product_id, 
  cscart_ult_product_descriptions.short_description, 
  IF(
    cscart_ult_product_descriptions.short_description = "", 
    cscart_ult_product_descriptions.full_description, 
    ""
  ) AS full_description, 
  cscart_ult_product_descriptions.meta_keywords, 
  cscart_ult_product_descriptions.meta_description, 
  cscart_ult_product_descriptions.search_words, 
  cscart_ult_product_descriptions.promo_text 
FROM 
  cscart_ult_product_descriptions 
WHERE 
  cscart_ult_product_descriptions.product_id IN (
    94625, 94624, 94623, 94622, 94621, 94620, 
    94619, 94618, 94617, 94616, 94615, 
    94614, 94613, 94612, 94611, 94610, 
    94609, 94608, 94607, 94606, 94605, 
    94604, 94603, 94602, 94601, 94600, 
    94599, 94598, 94597, 94596, 94595, 
    94594, 94593, 95222, 95221, 95220, 
    95219, 94863, 94862, 94697
  ) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00028

Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cscart_ult_product_descriptions	ALL	PRIMARY,product_id,company_id				1	Using where