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 (
    96513, 96512, 96511, 96510, 96503, 96384, 
    96086, 95838, 94773, 95878, 96342, 
    96341, 96340, 96343, 96337, 96336, 
    96335, 96322, 96313, 96182
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00049

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
94773 Mick Doyle, Hayley Duggan, Frantic Digital, Hard House, Never Give Up Mick Doyle, Hayley Duggan, Frantic Digital, Hard House, Never Give Up
95838 Hard trance, hard house, Jud Roper, for the dance, hard dance, bounce, hard bounce, scouse bouse, Sugar Skull Digital is premuim hard house and hard trance label, releasing the best tracks in hard dance today. Hard trance, hard house, Jud Roper, for the dance, hard dance, bounce, hard bounce, scouse bouse,
95878 Dean Richardson, Stu Angus, Set You Free, Resurrection Digital, Original, Exclusive, Toolbox Digital Download Set You Free (Original) by Resurrection Digital from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
96086 HOT086,Hot Box Digital,Dean Richardson
96182
96313
96322 Tekneak, Burning Blade Tekneak, Burning Blade
96335 Slenderman, Visceral, Filth, Filthy, Hard Dance, Hard House, House, Hoovers, Slenderman delivers another punishing blow to the down and dirty Filth genre. All you heathens, miscreants, and reprobates....buy this tune! Slenderman, Visceral, Filth, Filthy, Hard Dance, Hard House, House, Hoovers,
96336 TMP176,G-Mix,G's Gems,Tempo Trax,Hard House Hard House TMP176,G-Mix,G's Gems,Tempo Trax,Hard House
96337 TMP177,Trevor Wilson,Random But Raw,Bring It,Tempo Trax,Hard House Hard House TMP177,Trevor Wilson,Random But Raw,Bring It,Tempo Trax,Hard House
96340
96341
96342
96343
96384
96503
96510 Boski,Evil,Dark,Whisper,Hard,House Boski,Evil,Dark,Whisper,Hard,House
96511
96512
96513 Insidious, Kodokushi Insidious, Kodokushi