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 (
    93498, 93497, 93496, 93495, 93494, 93493, 
    93492, 93491, 93490, 93489, 93488, 
    93487, 93486, 93485, 93484, 93483, 
    93482, 93481, 93480, 93479, 93478, 
    93477, 93476, 93475, 93474, 93473, 
    93466, 94268, 94267, 94266, 93443, 
    93440, 93432, 93430, 93429, 93428, 
    93427, 93426, 93425, 93424
  ) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00042

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