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 (
    89975, 89974, 89973, 89971, 89969, 89968, 
    89967, 89965, 89963, 89962, 89959, 
    89957, 89956, 89953, 89951, 89480, 
    89476, 89464, 89463, 89427
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00048

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
89427 LTR02,Lightning Trax,Dawson,Jon BW,Rich Resonate
89463 Cheek488A,Cheeky Tracks,Micky Modelle Vs. Friday Night Posse,Simone Denny,Poomstyles
89464 Cheek488A,Cheeky Tracks,Micky Modelle Vs. Friday Night Posse,Simone Denny,Poomstyles
89476 ST017,SHED TRAX,Mutzz,Drake Liddell
89480 PMD032,Pumped,MartynB,Joe Longbottom
89951 LWSHD01,LW Recordings,Dizko H3D
89953 LWSHD01,LW Recordings,Sean Inside Out,Vandalize
89956 LWSHD01,LW Recordings,Jolene
89957 LWSHD01,LW Recordings,Nicee,Imogen,Hardy M
89959 LWSHD01,LW Recordings,Goldie,NuroGL
89962 LWSHD01,LW Recordings,DJ Rayne
89963 LWSHD01,LW Recordings,Damien Blanes
89965 LWSHD01,LW Recordings,Nando Cp
89967 LWSHD01,LW Recordings,Charlie F,Joe Longbottom
89968 LWSHD01,LW Recordings,Nikkdbubble,Fithy Kitten,Chucky
89969 LWSHD01,LW Recordings,Krovax
89971 LWSHD01,LW Recordings,Gaz Pritchard,Legion
89973 LWSHD01,LW Recordings,Mavrik
89974 LWSHD01,LW Recordings,Gibby
89975 LWSHD01,LW Recordings,Frany SP