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 (
    89286, 89010, 89009, 89008, 89007, 88970, 
    88969, 88928, 88925, 110658, 89204, 
    89203, 89006, 89005, 89004, 88697, 
    89289, 88426, 88351, 88350
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00049

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
88350 HTH002,Riot Recordings,Mark Sherry,BK
88351 HTH002,Riot Recordings,Mark Young,Derek Jones
88426 FE313,Fatal Energy Records,Pete Untitled,Chris F
88697 CheekUDC0,Cheeky Tracks,Mikey O'Hare,Jonno
88925 EF019,Energy Field,Transcend
88928 FD51,Freestyle Digital Recordings,Charlie Bosh
88969 FE317,Fatal Energy Records,Triple B,Samora DJ
88970 FD50,Freestyle Digital Recordings,Charlie Bosh
89004 INFEXHD008,Infexious Harddance,DarkbyDesign
89005 INFEXHD008,Infexious Harddance,DarkbyDesign
89006 INFEXHD008,Infexious Harddance,DarkbyDesign
89007 INFEXHD009,Infexious Harddance,Danny V
89008 INFEXHD009,Infexious Harddance,Danny V,Dermot Bateman
89009 INFEXHD009,Infexious Harddance,Danny V,Arhetium R
89010 INFEXHD009,Infexious Harddance,Danny V,Stu Fusion
89203 KU80,Klubbed Up,Klubfiller
89204 KU80,Klubbed Up,Klubfiller
89286 KU81,Klubbed Up,Trip
89289 DNZ416,DNZ Records,DJ Chiki
110658 CNMTK104DJ,Cinematik Recordings,Dimatik