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 (
    96636, 96635, 96634, 96633, 96632, 96631, 
    96630, 96629, 96628, 96627, 96626, 
    95927, 95925, 95924, 95919, 95918, 
    95917, 95916, 95915, 95914, 95913, 
    95912, 95911, 95910, 95909, 95908, 
    95907, 95906, 95905, 95904, 95903, 
    95902, 95901, 95900, 95899, 96116, 
    96115, 95890, 95889, 95888
  ) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00025

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