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 (
    77538, 77537, 77028, 77529, 77528, 76938, 
    76936, 76909, 77308, 77103, 77356, 
    77354, 77351, 77316, 77313, 76858, 
    76900, 76899, 77353, 77352
  ) 
  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
76858 FE217,Fatal Energy Records,On NRG,Ludo
76899 BH008,Bloc Hard Music,Durky Bass,Pulserz
76900 BH008,Bloc Hard Music,Durky Bass,Pulserz
76909 FE219,Fatal Energy Records,Trance Atlantic,Mental Pro
76936 CheekA46,Cheeky Tracks,Fred Swift,Charlie Goddard
76938 CheekA46,Cheeky Tracks,John Carr
77028 Scott Attrill, Tried Everything, Riot Recordings, Original Mix, Featured Hard Dance New, Hard Dance, Toolbox Digital Download Tried Everything (Original Mix) by Riot Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. RIOT177,Riot Recordings,Scott Attrill
77103 PTR099,Power Tracks Records,Sweet Dance
77308 DNZF545,DNZ Records,Jamie B
77313 DNZF541,DNZ Records,Garbie Project
77316 DNZF542,DNZ Records,Jamie B,Nova Scotia
77351 DNZF544,DNZ Records,Garbie Project
77352 DNZF538,DNZ Records,Sparkos
77353 DNZF538,DNZ Records,Sparkos
77354 DNZF543,DNZ Records,T-Jay,Zander Nation,Jamie B
77356 DNZF543,DNZ Records,T-Jay,Zander Nation,Garbie Project
77528 DNZF547,DNZ Records,T-Jay,Elle Mariachi
77529 DNZF548,DNZ Records,Susumu,Deekay
77537 DNZF549,DNZ Records,Garbie Project
77538 DNZF549,DNZ Records,Garbie Project