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 (
    98376, 98365, 98364, 98362, 98353, 98226, 
    98177, 97708, 97684, 97679, 97678, 
    97664, 98178, 98267, 98266, 98265, 
    98264, 98263, 98262, 98261
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00034

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
97664 Gary O'Connor, Animalia, Craig Jones, Digital Snail Gary O'Connor, Animalia, Craig Jones, Digital Snail
97678 ED010,Epidemic Digital,Alpha A
97679 ED010,Epidemic Digital,Alpha A
97684 ED012,Epidemic Digital,Jay Goodall,Legion
97708 PMD042,Pumped,Drake Liddell
98177
98178
98226 Tekneak Tekneak_global awakening records
98261 Gary O'Connor, Discam, Big Dick The Bass, Digital Snail Gary O'Connor, Discam, Big Dick The Bass, Digital Snail
98262 Gary O'Connor, Wayne Smart, Kokaine, Digital Snail Gary O'Connor, Wayne Smart, Kokaine, Digital Snail
98263 Henry Trotton, Charlie & The Hoover Factory, Digital Snail Henry Trotton, Charlie & The Hoover Factory, Digital Snail
98264 Team GB, Going For Gold, Digital Snail Team GB, Going For Gold, Digital Snail
98265 The Pet Detectives, Molehill Ode To Joel, Digital Snail The Pet Detectives, Molehill Ode To Joel, Digital Snail
98266 The Snail, Another Chance, Digital Snail The Snail, Another Chance, Digital Snail
98267 The Snail, U & Aye, Digital Snail The Snail, U & Aye, Digital Snail
98353 superfly,hardhouse,release,digital,toolbox,hardance
98362 Hard trance, hard house, Tara N, hard dance, sugar skull, Sugar Skull Digital is premuim hard house and hard trance label, releasing the best tracks in hard dance today. Hard trance, hard house, Tara N, hard dance, sugar skull,
98364 Dynamic intervention,Rich & Gordi,Move It,2001 Original Mix,Dip Dynamic intervention + Rich & Gordi - Move It (2001 Original Mix) Dip Recordings Dynamic intervention,Rich & Gordi,Move It,2001 Original Mix,Dip
98365 Dynamic intervention,Rich & Gordi,Move It,Wayne G,Dip Dynamic intervention + Rich & Gordi - Move It (Wayne G Remix) Dip Recordings Dynamic intervention,Rich & Gordi,Move It,Wayne G,Dip
98376 MaDa, Taste the acid Mada,mada