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 (
    105398, 105397, 105396, 105395, 105394, 
    105393, 105392, 105391, 104328, 104286, 
    104277, 104276, 104275, 104273, 104272, 
    104271, 104270, 104251, 104250, 104249
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00035

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
104249 Hells058,Hell's Recordings,D-tempo,Screecher
104250 Hells058,Hell's Recordings,D-Tempo,Dmrc
104251 Hells058,Hell's Recordings,D-Tempo
104270 BRR188,Black Reverb,B-Ya!
104271 BRR188,Black Reverb,Ex One
104272 BRR188,Black Reverb,B-Ya!
104273 BRR188,Black Reverb,Assuc,X6Cta
104275 Murf, Snipes, What Is Love, Contagious Records, Extended Mix, Hardcore, Toolbox Digital Download What Is Love (Extended Mix) by Contagious Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. CR229,Contagious Records,Snipes,Murf
104276 CR229,Contagious Records,Snipes,Murf
104277 STI291,Stomp-Inc UK,BenAddikt
104286 Apple Mac, Fracus & Darwin, Real High Real Fast, The World Of Obsession Recordings, Fracus & Darwin Remix, Hardcore, Toolbox Digital Download Real High Real Fast (Fracus & Darwin Remix) by The World Of Obsession Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. NTWO010,The World Of Obsession Recordings,Apple Mac,Fracus & Darwin
104328 DARKULLP004t10,Darkside Unleashed,Lady Dammage
105391 SethroW, Sunlight, Scarred Digital, Original Mix, Hardcore, Toolbox Digital Download Sunlight (Original Mix) by Scarred Digital from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. SD1012,Scarred Digital,Sethrow
105392 SD1012,Scarred Digital,Sethrow
105393 SD1012,Scarred Digital,Sethrow
105394 SD1012,Scarred Digital,Sethrow
105395 SD1012,Scarred Digital,Sethrow
105396 SD1012,Scarred Digital,Sethrow
105397 SD1012,Scarred Digital,Sethrow
105398 SD1012,Scarred Digital,Sethrow