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 (
    94262, 93316, 95080, 94904, 94798, 94060, 
    92913, 94880, 94870, 94869, 94867, 
    94821, 94759, 94686, 94017, 94016, 
    94015, 94014, 94013, 94012
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00046

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
92913 James Nardi, Ostyn, Asylum, Vicious Circle, Exclusive, Toolbox Digital Download Asylum by Vicious Circle from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
93316 BabzookaZ, Frantic Digital, Hard House, Venus BabzookaZ, Frantic Digital, Hard House, Venus
94012 RFRELOADED1,Alien Technology,Rebel Frequency
94013 RFRELOADED1,Alien Technology,Rebel Frequency
94014 RFRELOADED1,Alien Technology,Distorted Robocops
94015 RFRELOADED1,Alien Technology,Rebel Frequency
94016 RFRELOADED1,Alien Technology,Drome View Killaz,Defective Audio
94017 <table class="album-only-tracks"> <tr> <td class="track-name">OUT&amp;UP - Some Tell You (Original Mix)</td> <td class="track-actions"><span class="album-only-label">Album Only</span></td> </tr> <tr> <td class="track-name">Type Zero - Lunatic (Type Zero Remix)</td> <td class="track-actions"><span class="album-only-label">Album Only</span></td> </tr> <tr> <td class="track-name">Distorted Robocops - Earblind (Original Mix)</td> <td class="track-actions"><span class="album-only-label">Album Only</span></td> </tr> <tr> <td class="track-name">Rebel Frequency - Reloaded (Continuous DJ Mix)</td> <td class="track-actions"><span class="album-only-label">Album Only</span></td> </tr> </table> RFRELOADED1,Alien Technology
94060 IR142,INNERGIZE RECORDS,Noath
94262 Cheek520,Cheeky Tracks,Kid Dynamo
94686
94759 superfly,hardhouse,release,digital,toolbox,hardance
94798 pat,glenny,muttz,don't,need,you,pitch,drift pat,glenny,muttz,don't,need,you,pitch,drift pat,glenny,muttz,don't,need,you,pitch,drift
94821 Cupra,Batten,Tuff,Groove,Abomination Cupra & Paul Batten - Abomination - Tuff Groove #078 Cupra,Batten,Tuff,Groove,Abomination
94867
94869 Visceral, filth, hoover, Visceral Filth, grave, Gravediggin', G.W.R., gritty, hard, hard house G.W.R. is back AGAIN on Visceral Records with another absolute masher like only he can do. Visceral, filth, hoover, Visceral Filth, grave, Gravediggin', G.W.R., gritty, hard, hard house
94870 Boski,Tekneak,Volatile,Horn,Hard,Nrg,Hoover Boski,Tekneak,Volatile,Horn,Hard,Nrg,Hoover
94880
94904
95080 Can you Feel it DJ Serenity Hardhouse Energy Source Productions Can you Feel it DJ Serenity Hardhouse Energy Source Productions Can you Feel it DJ Serenity Hardhouse Energy Source Productions