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 (
    97698, 97697, 97696, 97695, 97669, 97655, 
    97558, 97393, 96323, 96738, 89235, 
    97593, 97584, 97095, 97094, 97582, 
    97562, 97561, 97511, 94776
  ) 
  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
89235
94776 Daiv, Frantic Digital, Hard House, Love Is Blind Daiv, Frantic Digital, Hard House, Love Is Blind
96323
96738 James Nardi, Hard House, Tears James Nardi, Hard House, Tears James Nardi, Hard House, Tears
97094 BTN014,Bring The Noise Recordings,Jason Nawty,Laura Skelton
97095 BTN014,Bring The Noise Recordings,Jason Nawty,Laura Skelton
97393 TaraN
97511 Fall,Forward,Homzy,Toolboxdigitalshop.com/Homzy Homzy,homzy,global awakening,
97558 Ben, Warren, Rooms, Hot Ben, Warren, Rooms, Hot
97561 Tara N, Burning Blade Tara N, Burning Blade
97562
97582 hard house, hard dance, trance, hard nrg,, hardnrg, nrg, electronic, club, clubbing, farley, glazby, tinrib, nukleuz, tidy, tripoli, rave, synthesizer, DAW new, banging, high bpm, trance, trancey, uplifting, melodic, running bass, four on the floor, amazing shit remix, hard house, hard dance, trance, hard nrg,, hardnrg, nrg, electronic, club, clubbing, farley, glazby, tinrib, nukleuz, tidy, tripoli, rave
97584 U Wanna Play DJ Serenity Energy Source Productions Hard House U Wanna Play DJ Serenity Energy Source Productions Hard House U Wanna Play DJ Serenity Energy Source Productions Hard House
97593
97655 Global,Awakening,Records
97669 TMP180,Karl Davies,Wayne G,Bad Shit,Tempo Trax,Hard House Hard House TMP180,Karl Davies,Wayne G,Bad Shit,Tempo Trax,Hard House
97695 Full Circle Productions Homzy,Random But Raw, Full Circle Productions
97696 Sugar Skull Digital, Boski, Machine Gun, Hoover, hard house, hard trance, NRG, trance, banging hard house, Sugar Skull Digital is premium hard house/hard trance label, bringing you all the best tracks from all the best artists. Sugar Skull Digital, Boski, Machine Gun, Hoover, hard house, hard trance, NRG, trance, banging hard house,
97697 Dexitron,Acetate,Dip Recordings Dexitron - Acetate - Dip Recordings Dexitron,Acetate,Dip Recordings
97698 Dexitron,Drop the Needle,Dip Recordings Dexitron - Drop the Needle - Dip Recordings Dexitron,Drop the Needle,Dip Recordings