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 (
    104659, 104658, 104657, 104656, 104655, 
    105977, 105976, 105975, 104560, 104559, 
    104558, 104557, 104556, 104555, 104529, 
    104573, 104572, 104571, 104505, 104504
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00036

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
104504 BRR189,Black Reverb,Ex One
104505 BRR189,Black Reverb,B-Ya!
104529 DARKULLP004t08,Darkside Unleashed,Lady Dammage,SoulBlast
104555 Mike Enemy, RAMY, THNDERZ, Frozen Tears, OneSeventy, Extended Mix, Hardcore, Toolbox Digital Download Frozen Tears (Extended Mix) by OneSeventy from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. ONESEVENTY126,OneSeventy,Mike Enemy,THNDERZ,RAMY
104556 ONESEVENTY126,OneSeventy,Mike Enemy,THNDERZ,RAMY
104557 Darren Tyler, Fitzy-K, LXVE, Karma, 24/7 Hardcore, Extended Mix, Hardcore, Toolbox Digital Download Karma (Extended Mix) by 24/7 Hardcore from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. 247HC257,24/7 Hardcore,Darren Tyler,Fitzy-K,LXVE
104558 247HC257,24/7 Hardcore,Darren Tyler,Fitzy-K,LXVE
104559 Darren Tyler, Fitzy-K, LXVE, Hold On, 24/7 Hardcore, Extended Mix, Hardcore, Toolbox Digital Download Hold On (Extended Mix) by 24/7 Hardcore from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. 247HC257,24/7 Hardcore,Darren Tyler,Fitzy-K,LXVE
104560 247HC257,24/7 Hardcore,Darren Tyler,Fitzy-K,LXVE
104571 Hells059,Hell's Recordings,Outrage
104572 Hells059,Hell's Recordings,Outrage
104573 Hells059,Hell's Recordings,Outrage
104655 Murf, Snipes, RunAway, Contagious Records, Extended Mix, Hardcore, Toolbox Digital Download RunAway (Extended Mix) by Contagious Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. CR230,Contagious Records,Snipes,Murf
104656 CR230,Contagious Records,Snipes,Murf
104657 BRR190,Black Reverb,Assuc
104658 BRR190,Black Reverb,Assuc
104659 BRR190,Black Reverb,Ex One
105975 XTR042,X-tinction Recordz,Serpent Godz
105976 XTR042,X-tinction Recordz,Serpent Godz
105977 XTR042,X-tinction Recordz,Serpent Godz