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 (
    89019, 89018, 89017, 89016, 89015, 89014, 
    88971, 89484, 89444, 89278, 88869, 
    88868, 89442, 89441, 89440, 89439, 
    89438, 89139, 89138, 89137, 89136, 
    89135, 89134, 89133, 89132, 89131, 
    89130, 89129, 89128, 89127, 89126, 
    89125, 89124, 89123, 89122, 88918, 
    88726, 88725, 88724, 88723
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00069

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 40 Using where

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
88723 TiOSALBUM005,TIOS Digital,X-Cyte,Hypo-Tinx
88724 TiOSALBUM005,TIOS Digital,KidTek
88725 TiOSALBUM005,TIOS Digital,Jay G
88726 TiOSALBUM005,TIOS Digital,Jay G,Stafford MC
88868 PUR049,Pink Unicorn Records,Alex Greenhouse,Cameron J.,F3z
88869 PUR049,Pink Unicorn Records,Alex Greenhouse,Cameron J.,Gabbanatic
88918 STI0167,Stomp-Inc UK,BenAddikt
88971 KTRAR021,Keeping The Rave Alive,Modul8,Max Grimell,Equinox
89014 DARKUL025,Darkside Unleashed,Nightmare,Thunder,Komarovski
89015 DARKUL025,Darkside Unleashed,Thunder,The Weatherman
89016 DARKUL025,Darkside Unleashed,Thunder,Nightmare
89017 DARKUL025,Darkside Unleashed,Thunder
89018 DARKUL025,Darkside Unleashed,Thunder
89019 DARKUL025,Darkside Unleashed,Thunder
89122 DARKUL122,Darkside Unleashed,Rob Da Rhythm
89123 DARKUL122,Darkside Unleashed,A-Kriv,Mind Compressor
89124 DARKUL122,Darkside Unleashed,Streiks & Kratchs
89125 DARKUL122,Darkside Unleashed,Major Conspiracy
89126 DARKUL122,Darkside Unleashed,The Clamps,STV
89127 DARKUL122,Darkside Unleashed,Psychoweapon
89128 DARKUL122,Darkside Unleashed,Audio Karnage
89129 DARKUL122,Darkside Unleashed,Cik,K.O.R.E
89130 DARKUL122,Darkside Unleashed,Radiate,Psyco
89131 DARKUL122,Darkside Unleashed,Loud Carnage
89132 DARKUL122,Darkside Unleashed,Insanity
89133 DARKUL122,Darkside Unleashed,Xterminate,Sedutchion
89134 DARKUL122,Darkside Unleashed,FrenchFaces
89135 DARKUL122,Darkside Unleashed,Untainted & Shadow
89136 DARKUL122,Darkside Unleashed,Vextor,Frenchkillerz
89137 DARKUL122,Darkside Unleashed,Xterminate
89138 DARKUL122,Darkside Unleashed,The Apprentice
89139 DARKUL122,Darkside Unleashed,Hardbouncer,Febro
89278 RS082,Rebirth Society,Mental Crush
89438 BBR038,Bounce Back records,ToXic Inside
89439 BBR038,Bounce Back records,ToXic Inside
89440 BBR038,Bounce Back records,ToXic Inside
89441 BBR038,Bounce Back records,ToXic Inside
89442 BBR038,Bounce Back records,ToXic Inside
89444 TSR049,Triple Six Records,The Dark Horror
89484 247HC206,24/7 Hardcore,The Three Amigos,Al Storm,Darren Tyler