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 (
    88313, 88312, 88311, 88310, 88261, 88260, 
    88259, 89141, 88890, 88747, 88679, 
    88678, 88336, 88392, 88206, 88205, 
    88204, 88203, 88202, 88201
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00033

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
88201 HTH001,Riot Recordings,Loop
88202 HTH001,Riot Recordings,Nick Sentience
88203 HTH001,Riot Recordings,Scott Attrill
88204 HTH001,Riot Recordings,Scott Attrill
88205 HTH001,Riot Recordings,Scott Attrill
88206 HTH001,Riot Recordings,Vinylgroover,The Red Hed
88259 Cheek495,Cheeky Tracks,Micky Modelle,Simone Denny,SystemShock
88260 Cheek495,Cheeky Tracks,Micky Modelle,Simone Denny
88261 Cheek495,Cheeky Tracks,Micky Modelle,Simone Denny,SystemShock
88310 Collect005,Jacked Up Records,Zero Range
88311 Collect005,Jacked Up Records,Zero Range
88312 Collect005,Jacked Up Records,Zero Range
88313 Collect005,Jacked Up Records,Zero Range
88336 DNZF853,DNZ Records,Nova Scotia
88392 DNZF852,DNZ Records,Garbie Project
88678 DNZ414,DNZ Records,Jamie B,DJ Oskar
88679 DNZF854,DNZ Records,T-Jay
88747 PTR131,Power Tracks Records,DJ Ruiz,DJ Kano
88890 DNZF858,DNZ Records,Basic Beatz
89141 awe5554,EDM Starlight,Joe N