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 (
    108997, 97273, 108863, 108847, 108846, 
    110784, 108984, 97010, 97009, 97008, 
    109024, 110785, 108955, 98935, 108976, 
    108865, 108864, 109010, 108876, 108875
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00039

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
97008 MTR018,MackiTek Records,Keja,Kan10
97009 MTR018,MackiTek Records,Keja,Kan10
97010 MTR018,MackiTek Records,Keja,Kan10
97273 INFEXORI003,InfeXious Origins,Clive King,Pavo
98935 PANDA001,Voodoo Panda,The Watchmen,Rob IYF,Al Storm
108846 KKR045,KarmaKontra Records,MBW
108847 KKR045,KarmaKontra Records,MBW
108863 KKR047,KarmaKontra Records,Jano
108864 KKR041,KarmaKontra Records,MasterOfTime
108865 KKR041,KarmaKontra Records,MasterOfTime
108875 KKR040,KarmaKontra Records,RVRS
108876 KKR040,KarmaKontra Records,RVRS
108955 KKR043,KarmaKontra Records,Sikusia
108976 KKR042,KarmaKontra Records,D-Effect
108984 KKR046,KarmaKontra Records,South Side Psychoz
108997 KKR048,KarmaKontra Records,MBW
109010 KKR040R,KarmaKontra Records,RVRS,Skully
109024 KKR044,KarmaKontra Records,BassCtrl
110784 CNMTK114DJ,Cinematik Recordings,Dimatik,Weaver
110785 CNMTK116DJ,Cinematik Recordings,DNA,Weaver,Overdrive