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 (
    98240, 98239, 98238, 98237, 98236, 98234, 
    98233, 98218, 97607, 98225, 98224, 
    98217, 98200, 98179, 98176, 98165, 
    98078, 97968, 97967, 97537
  ) 
  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
97537 BMR217,Beast Mode Recordings,Renshi,NuroGL
97607 BTN016,Bring The Noise Recordings,MartynB
97967
97968 Global,Awakening,Records Global,Awakening,Records
98078
98165
98176
98179 4 the kill, Homzy,full circle productions,full circle, random but raw homzy,random but raw, full circle productions,
98200 boris,the,noss,24/7,pitch,drift,recordings boris,the,noss,24/7,pitch,drift,recordings boris,the,noss,24/7,pitch,drift,recordings
98217 TMP183,BuzzBass,Rio,Sexy baby,Tempo Trax,Hard House Hard House TMP183,BuzzBass,Rio,Sexy baby,Tempo Trax,Hard House
98218 Together Energy Source Productions DJ Serenity Hardhouse Together Energy Source Productions DJ Serenity Hardhouse Together Energy Source Productions DJ Serenity Hardhouse
98224 RPR195, Narc, Disturbed, Piston Records Remix, Raw Power, hard house, filth, hoovers, NRG As such a brutal original track, there's only a handful of producers who would do it justice and Matt Rains was exactly the man to do it! Having taken some time away from the scene he's now making a comeback as a Raw Power resident. Be sure to check out h RPR195, Narc, Disturbed, Piston Records Remix, Raw Power, hard house, filth, hoovers, NRG
98225 RPR196, Gem Stone, Chloroform, darkness, Raw Power, hard house, filth, hoovers, NRG Raw Power's leading lady, Gem Stone comes back from a short break with a tune that could quite literally knock you out! With some hoovers, quirky beats and bass mixed with the powerful main riff, you won't be disappointed! RPR196, Gem Stone, Chloroform, darkness, Raw Power, hard house, filth, hoovers, NRG
98233
98234
98236 Ben Stevens, Gary O'Connor, In My Mind, Digital Snail Ben Stevens, Gary O'Connor, In My Mind, Digital Snail
98237 Dave Curtis, Gary O'Connor, You Make Me, Digital Snail Dave Curtis, Gary O'Connor, You Make Me, Digital Snail
98238 Gary O'Connor, Animalia, Digital Snail Gary O'Connor, Animalia, Digital Snail
98239 Gary O'Connor, Fantastic Mr Fanny Fox, Digital Snail Gary O'Connor, Fantastic Mr Fanny Fox, Digital Snail
98240 Gary O'Connor, Over The Limit, Digital Snail Gary O'Connor, Over The Limit, Digital Snail