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 (
    93222, 93224, 93165, 92338, 92337, 93157, 
    93156, 93104, 93103, 93058, 93036, 
    92955, 92835, 92833, 92522, 92521, 
    92504, 92502, 92344, 92281
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00039

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
92281
92337 BTN003,Bring The Noise Recordings,Rick James
92338 BTN003,Bring The Noise Recordings,Rick James
92344 Adam Butler, Encoded, Hard House, Technik Adam Butler, Encoded, Hard House, Technik
92502 GHH002,Global Hard House,Pete Maxwell,Matt Clarkson
92504
92521 K8-e, Jon BW, Paul King, WLHH, Hard House K8-e, Jon BW, Paul King, WLHH, Hard House
92522 K8-e, Jon BW, WLHH, Hard House K8-e, Jon BW, WLHH, Hard House
92833
92835 TMP169,G Mix,Hypnotise G,Tempo Trax,Hard House Hard House TMP169,G Mix,Hypnotise G,Tempo Trax,Hard House
92955 Blinding Lights, Drowning in the Night, Hard House, Random but Raw, Slenderman, Visceral Records, Visceral Comin' out swingin'!! Visceral Main's 2nd release is a jammy jammy jammy one with Slenderman, Ross Farley, & Random but Raw on the sesh. Blinding Lights, Drowning in the Night, Hard House, Random but Raw, Slenderman, Visceral Records, Visceral
93036
93058 global,awakening,homzy homzy,global,awakening,records,
93103 Kodokushi, Tekneak, Boski, Burning Blade Kodokushi, Tekneak, Boski, Burning Blade
93104 Hard trance, hard house, horro story, hard dance, sugar skull, carl pearce, cheryl pearce, Sugar Skull Digital is premuim hard house and hard trance label, releasing the best tracks in hard dance today. Hard trance, hard house, horro story, hard dance, sugar skull, carl pearce, cheryl pearce,
93156
93157
93165
93222
93224 Anihilating Rhythm DJ Serenity Energy Source Productions Hard House NRG Anihilating Rhythm DJ Serenity Energy Source Productions Hard House NRG Anihilating Rhythm DJ Serenity Energy Source Productions Hard House NRG