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 (
    122285, 122284, 122283, 122282, 109540, 
    109539, 109538, 109537, 109536, 109535, 
    109534, 109533, 109532, 109531, 109530, 
    109529, 109528, 109270, 109808, 109735
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00042

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
109270 Brett Cooper, RPL, Just You & I, Stomp-Inc UK, Original Mix, Hardcore, Toolbox Digital Download Just You & I (Original Mix) by Stomp-Inc UK from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. STI305,Stomp-Inc UK,Brett Cooper,RPL
109528 LWHTS05,LW Recordings,Zaphy
109529 LWHTS05,LW Recordings,Panthera By B & J
109530 LWHTS05,LW Recordings,Tiago Santos,Carl Shorts,D.A.V.E. The Drummer
109531 LWHTS05,LW Recordings,Tech C
109532 LWHTS05,LW Recordings,Pyraxx
109533 LWHTS05,LW Recordings,Hector Da Rosa,MarAxe
109534 LWHTS05,LW Recordings,Ayako Mori,kaori
109535 LWHTS05,LW Recordings,COACH
109536 LWHTS05,LW Recordings,Jon Krieger
109537 LWHTS05,LW Recordings,Roentgen Limiter
109538 LWHTS05,LW Recordings,Riotbot
109539 LWHTS05,LW Recordings,Isgang,Etam
109540 LWHTS05,LW Recordings,PVR (ARG),EDUVEK
109735 247HCLP018,24/7 Hardcore,Rob IYF,Al Storm,MC Enemy
109808 DARKUL150,Darkside Unleashed,LARA
122282 LWHTS05b,LW Recordings,Zaphy
122283 LWHTS05b,LW Recordings,Panthera By B & J
122284 LWHTS05b,LW Recordings,Tiago Santos,Carl Shorts,D.A.V.E. The Drummer
122285 LWHTS05b,LW Recordings,Tech C