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 (
    98339, 97666, 98898, 89236, 98794, 98793, 
    98791, 98393, 98772, 98771, 98769, 
    98736, 98734, 98672, 98622, 98523, 
    98170, 92934, 98770, 98161
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00051

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
89236
92934
97666 Gary O'Connor, It's Not The Same, Ben Stevens, Digital Snail Gary O'Connor, It's Not The Same, Ben Stevens, Digital Snail
98161 INR078,Immortal Noise Recordings,Spyndl
98170 PMD045,Pumped,Joe Longbottom
98339 ED013,Epidemic Digital,Lok_E,VaderMonkey
98393 BTN018,Bring The Noise Recordings,Paul Clark (CLK)
98523 DirtyBoy Productions,"O" My, Riksta, Random But Raw DirtyBoy Productions,"O" My, Riksta, Random But Raw, Hard House
98622 Bass Jumper, Lucy Fur, Shake It Up, Toolbox Recordings, Bass Jumper Remix, Exclusive, Toolbox Digital Download Shake It Up (Bass Jumper Remix) by Toolbox Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
98672 Global,Awakening,Records Global,Awakening,Records
98734 Gaz F, Ginge P.A, Amazonian Darkness, Frantic Digital, Exclusive, Toolbox Digital Download Amazonian Darkness by Frantic Digital from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Gaz F, Ginge P.A, Frantic Digital, Hard House, Amazonian Darkness
98736
98769 Random But Raw, Burning Blade Random but Raw, Burning Blade
98770 Teck071, Kodokushi Teck071, Kodokushi
98771 Karl,davies,jase,h,house,in,for,the,kill,pitch,drift Karl,davies,jase,h,house,in,for,the,kill,pitch,drift Karl,davies,jase,h,house,in,for,the,kill,pitch,drift
98772 pretty,handsome,bad,habitz,pitch,drift pretty,handsome,bad,habitz,pitch,drift pretty,handsome,bad,habitz,pitch,drift
98791
98793
98794 Zillin, Kevlaar, Full circle productions Zillin, Kevlaar, Full circle productions, Homzy
98898 pat,glenny,desolate,pitch,drift pat,glenny,desolate,pitch,drift pat,glenny,desolate,pitch,drift