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 (
    98892, 100136, 100131, 100045, 100011, 
    100035, 100010, 100009, 100002, 100001, 
    99991, 99966, 99863, 99862, 99436, 
    99430, 99427, 99280, 98828, 92941
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00044

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
92941
98828 hardhouse,filth,harddance,dance,dancemusic hardhouse,filth,harddance,dance,dancemusic hardhouse,filth,harddance,dance,dancemusic
98892
99280
99427 DBD061,Drop Bear Digital ,Boris The Noss
99430 Direct Drive, Frantic Digital, Hard Trance, IYAN Direct Drive, Frantic Digital, Hard Trance, IYAN
99436
99862 Global,Awakening,Records Global,Awakening,Records
99863 Global,Awakening,Records Global,Awakening,Records
99966 Lets Go DJ Serenity Energy Source Productions Hard House Lets Go DJ Serenity Energy Source Productions Hard House Lets Go DJ Serenity Energy Source Productions Hard House
99991
100001 Hard trance, hard house, Tara N, KP, spyndl, hard dance, 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, KP, spyndl, hard dance,
100002
100009 Boris,noss,twisted,time,trip,hard,house,trance,bass Boris,noss,twisted,time,trip,hard,house,trance,bass
100010 Gary O'Connor, The Story, Digital Snail, Hard House Gary O'Connor, The Story, Digital Snail, Hard House
100011 Time To Party DJ Serenity Energ Source Productions Hard House Time To Party DJ Serenity Energ Source Productions Hard House Time To Party DJ Serenity Energ Source Productions Hard House
100035 hard house, hard dance, trance, hard nrg, electronic, club, clubbing, farley, glazby, tinrib, ravage, nukleuz, tidy, tripoli All for the love eufex, new, banging, high bpm, little miss natalie, have it, having it, proper, proppa, hard house, hard dance, trance, hard nrg, electronic, club, clubbing, farley, glazby, tinrib, ravage, nukleuz, tidy, tripoli, new, best, hard, chunky, funky, old school, tdv
100045
100131 Retrobate, Supercharged, Exclusive, Toolbox Digital Download Retrobate by Supercharged from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
100136 Hard trance, hard house, team sly, slenderman, 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, team sly, slenderman, hard dance, bounce, hard bounce, scouse bouse,