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 (
    112148, 111842, 111841, 111840, 111839, 
    112382, 111756, 111755, 111754, 111753, 
    111751, 111750, 111749, 111748, 111747, 
    111746, 111745, 111744, 111743, 111742
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00044

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
111742 LWHTS07,LW Recordings,Asmodeo,DarkMe
111743 LWHTS07,LW Recordings,Roentgen Limiter
111744 LWHTS07,LW Recordings,H! Dude
111745 LWHTS07,LW Recordings,Alex Vigo,Goncalo M
111746 LWHTS07,LW Recordings,H! Dude
111747 LWHTS07,LW Recordings,Vaessar303
111748 LWHTS07,LW Recordings,JGMZ
111749 LWHTS07,LW Recordings,Riotbot
111750 LWHTS07,LW Recordings,SP1TA
111751 LWHTS07,LW Recordings,Nutty T,Bad Panda,Jim E Scavenger
111753 LWHTS07,LW Recordings,Hundzhan
111754 LWHTS07,LW Recordings,Tony Ess
111755 LWHTS07,LW Recordings,Victoria Franches,Marco Ginelli,KHARL
111756 LWHTS07,LW Recordings,Zero Dayz,Chicago Loop
111839 MOUTHDATA101,Motormouth Recordz,Syprexa
111840 MOUTHDATA101,Motormouth Recordz,Stormtrooper,Syprexa
111841 MOUTHDATA101,Motormouth Recordz,Doormouse,Syprexa
111842 MOUTHDATA101,Motormouth Recordz,Syprexa
112148 DARKUL156,Darkside Unleashed,False Idol
112382 DNZF1376,DNZ Records,Brett Cooper