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 (
    106113, 106112, 106111, 106110, 106109, 
    106108, 106107, 106106, 106105, 106104, 
    106103, 106102, 106100, 106043, 106042, 
    106041, 106511, 106510, 106509, 106029
  ) 
  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
106029 STI289,Stomp-Inc UK,JKO
106041 Rick Chubbs, Just Fuck, The World Of Obsession Recordings, Extended Mix, Hardcore, Toolbox Digital Download Just Fuck (Extended Mix) 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. NTWO012,The World Of Obsession Recordings,Rick Chubbs
106042 Rick Chubbs, Acid Melody, The World Of Obsession Recordings, Extended Mix, Hardcore, Toolbox Digital Download Acid Melody (Extended Mix) 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. NTWO012,The World Of Obsession Recordings,Rick Chubbs
106043 Rick Chubbs, Freeforming, The World Of Obsession Recordings, Extended Mix, Hardcore, Toolbox Digital Download Freeforming (Extended Mix) 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. NTWO012,The World Of Obsession Recordings,Rick Chubbs
106100 RAVEMUZIK052,Rave Muzik,DJ Manga,Van Heekan,Stormtrooper
106102 MOK254,Mokum Records,M-Project,Kamikaze
106103 MOK254,Mokum Records,M-Project,Kamikaze
106104 MOK254,Mokum Records,M-Project,Kamikaze
106105 MOK254,Mokum Records,M-Project,Kamikaze
106106 MOK254,Mokum Records,M-Project,Kamikaze
106107 MOK254,Mokum Records,M-Project,Kamikaze
106108 MOK254,Mokum Records,M-Project,Kamikaze
106109 MOK254,Mokum Records,M-Project,Kamikaze
106110 MOK254,Mokum Records,M-Project,Kamikaze,DJ Dynamax
106111 MOK254,Mokum Records,M-Project,Kamikaze
106112 MOK254,Mokum Records,M-Project,Kamikaze
106113 MOK254,Mokum Records,M-Project,Kamikaze
106509 BAB23,Bombs & Bullets Records,Super Trash Bros
106510 BAB23,Bombs & Bullets Records,Super Trash Bros
106511 BAB23,Bombs & Bullets Records,Super Trash Bros