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 (
    104473, 104472, 104471, 104470, 104469, 
    104468, 104467, 104466, 104465, 104464, 
    102273, 102272, 102271, 102241, 105014, 
    104448, 102207, 105000, 104893, 104892
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00036

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
102207 MQDRHRD01,+QDance Records,Comare
102241 DARKULLP004t02,Darkside Unleashed,Lady Dammage,MC Prime
102271 MOK251,Mokum Records,M-Project
102272 MOK251,Mokum Records,M-Project
102273 MOK251,Mokum Records,M-Project
104448 Lynsey Tibbs, Rasper, Ravergirl, Yorkshire Core Records, Original Mix, Hardcore, Toolbox Digital Download Ravergirl (Original Mix) by Yorkshire Core Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Ycore44,Yorkshire Core Records,Rasper,Lynsey Tibbs
104464 MOUTHLP006,Motormouth Recordz,eDUB
104465 MOUTHLP006,Motormouth Recordz,Stormtrooper,Syprexa
104466 MOUTHLP006,Motormouth Recordz,Relapse
104467 MOUTHLP006,Motormouth Recordz,Dave Dope
104468 MOUTHLP006,Motormouth Recordz,Densha Crisis
104469 MOUTHLP006,Motormouth Recordz,The Satan
104470 MOUTHLP006,Motormouth Recordz,Stormtrooper
104471 MOUTHLP006,Motormouth Recordz,Detest
104472 MOUTHLP006,Motormouth Recordz,Tripped
104473 MOUTHLP006,Motormouth Recordz,Syprexa
104892 R90983,R909 Records,Dark Bayron
104893 R90983,R909 Records,Dark Bayron
105000 Kacky, Piece Of You, Justice Hardcore, Original Mix, Hardcore, Toolbox Digital Download Piece Of You (Original Mix) by Justice Hardcore from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. JH333,Justice Hardcore,Kacky
105014 Smeets, Baby, Justice Hardcore, Original Mix, Hardcore, Toolbox Digital Download Baby (Original Mix) by Justice Hardcore from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. JH334,Justice Hardcore,Smeets