SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.short_description, 
  IF(
    cscart_product_descriptions.short_description = '' 
    OR cscart_product_descriptions.short_description IS NULL, 
    cscart_product_descriptions.full_description, 
    ''
  ) AS full_description, 
  cscart_product_descriptions.meta_keywords, 
  cscart_product_descriptions.meta_description, 
  cscart_product_descriptions.search_words, 
  cscart_product_descriptions.promo_text 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (
    98260, 98259, 98258, 98257, 98256, 98255, 
    98254, 98253, 98252, 98251, 98250, 
    98249, 98248, 98247, 98246, 98245, 
    98244, 98243, 98242, 98241
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00027

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_product_descriptions range PRIMARY,product_id PRIMARY 9 20 Using where

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
98241 Gary O'Connor, Reloaded, Digital Snail Gary O'Connor, Reloaded, Digital Snail
98242 Gary O'Connor, The Great Escopi, Digital Snail Gary O'Connor, The Great Escopi, Digital Snail
98243 Gary O'Connor, Danny Gilligan, Zeetah Massiah, Eternity, Digital Snail Gary O'Connor, Danny Gilligan, Zeetah Massiah, Eternity, Digital Snail
98244 Gary O'Connor, Ger Quinlan, Nunca Mas, Digital Snail Gary O'Connor, Ger Quinlan, Nunca Mas, Digital Snail
98245 Gary O'Connor, Tenchy, Nasty Pasty, Digital Snail Gary O'Connor, Tenchy, Nasty Pasty, Digital Snail
98246 Gary O'Connor, The Kraken, Digital Snail Gary O'Connor, The Kraken, Digital Snail
98247 Henry Trotton, Hetty Wainthrapper, Digital Snail Henry Trotton, Hetty Wainthrapper, Digital Snail
98248 The Pet Detectives, Pawsome, Digital Snail The Pet Detectives, Pawsome, Digital Snail
98249 The Snail, Plain Snailing, Digital Snail The Snail, Plain Snailing, Digital Snail
98250 The Snail, Sabotaged, Digital Snail The Snail, Sabotaged, Digital Snail
98251 The Snail, Without You, Digital Snail The Snail, Without You, Digital Snail
98252 Andy Farley, Gary O'Connor, What Zapp, Digital Snail Andy Farley, Gary O'Connor, What Zapp, Digital Snail
98253 Gary O'Connor, Clean Sheet, Digital Snail Gary O'Connor, Clean Sheet, Digital Snail
98254 Gary O'Connor, Escargot, Digital Snail Gary O'Connor, Escargot, Digital Snail
98255 Gary O'Connor, Its Not The Same The Honestly Its Not Mix, Digital Snail Gary O'Connor, Its Not The Same The Honestly Its Not Mix, Digital Snail
98256 Gary O'Connor, Moonman, Digital Snail Gary O'Connor, Moonman, Digital Snail
98257 Gary O'Connor, Mysterious Land, Digital Snail Gary O'Connor, Mysterious Land, Digital Snail
98258 Gary O'Connor, Shell Shocka, Digital Snail Gary O'Connor, Shell Shocka, Digital Snail
98259 Gary O'Connor, Shine, Digital Snail Gary O'Connor, Shine, Digital Snail
98260 Gary O'Connor, Amber D, Let It Go, Digital Snail Gary O'Connor, Amber D, Let It Go, Digital Snail