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 (
    104503, 104502, 104566, 104565, 104564, 
    104563, 105544, 104462, 105512, 105462, 
    105461, 105460, 104547, 105405, 105404, 
    105403, 105402, 105401, 105400, 105399
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00037

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
104462 Gee, Mikey P, Painkiller, Stomp-Inc UK, Original Mix, Hardcore, Toolbox Digital Download Painkiller (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. STI292,Stomp-Inc UK,Mikey P,Gee
104502 BRR189,Black Reverb,Assuc
104503 BRR189,Black Reverb,B-Ya!
104547 XPN007E,XPN Music,X-Pander,Hatred
104563 DARKUG003,Darkside Underground,Kit Williams,Scrapeface
104564 DARKUG003,Darkside Underground,Kit Williams,Scrapeface,Tirans From Terrorville
104565 DARKUG003,Darkside Underground,Angernoizer
104566 DARKUG003,Darkside Underground,Angernoizer
105399 SD1012,Scarred Digital,Sethrow
105400 SD1012,Scarred Digital,Sethrow
105401 SD1012,Scarred Digital,Sethrow
105402 SD1012,Scarred Digital,Sethrow
105403 SD1012,Scarred Digital,Sethrow
105404 SD1012,Scarred Digital,Sethrow
105405 SD1012,Scarred Digital,Sethrow
105460 DARKUL137,Darkside Unleashed,Basspunkz
105461 DARKUL137,Darkside Unleashed,Basspunkz
105462 DARKUL137,Darkside Unleashed,Basspunkz,Oculatorz
105512 XTR041,X-tinction Recordz,Uncreated
105544 Div Eadie, Gary McF, Robbie Hutton, Leave Me, Justice Hardcore, Original Mix, Hardcore, Toolbox Digital Download Leave Me (Original Mix) by Justice Hardcore from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. JH335,Justice Hardcore,Div Eadie,Gary McF,Robbie Hutton