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 (
    106238, 106237, 106236, 106235, 106234, 
    106233, 106680, 106285, 106284, 106556, 
    106371, 106370, 106208, 106232, 106179, 
    106178, 106177, 106176, 106175, 106174
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00048

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
106174 BRR193,Black Reverb,X6Cta
106175 BRR193,Black Reverb,Entropy Frequency
106176 BRR193,Black Reverb,Tito K.
106177 BRR193,Black Reverb,DJ Deep Noise,Lo-K
106178 BRR193,Black Reverb,B-Ya!
106179 BRR193,Black Reverb,Waffensupermarkt,Julian Longo
106208 STI295,Stomp-Inc UK,Gavalar
106232 HTTC017,Hard To The Core Digital,Arnie
106233 BRR194,Black Reverb,Assuc
106234 BRR194,Black Reverb,X6Cta
106235 BRR194,Black Reverb,Promiscle
106236 BRR194,Black Reverb,M5.5
106237 BRR194,Black Reverb,Loop Obsession
106238 BRR194,Black Reverb,La Calva,Assuc
106284 Hells062,Hell's Recordings,Lunatic,Broken Image,Born2Kill
106285 Hells062,Hell's Recordings,Lunatic,Broken Image,Born2Kill
106370 JDH, Riko, Bass Up, Contagious Records, Extended Mix, Hardcore, Toolbox Digital Download Bass Up (Extended Mix) by Contagious Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. CR231,Contagious Records,Riko,JDH
106371 CR231,Contagious Records,Riko,JDH
106556 DNZF1224,DNZ Records,Basic Beatz,Becky,DJ Teejay
106680 The Boosterz, AxelDina, Justice Hardcore, Original Mix, Hardcore, Toolbox Digital Download AxelDina (Original Mix) by Justice Hardcore from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. JH339,Justice Hardcore,The Boosterz