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 (
    92901, 92884, 93763, 93762, 93758, 93743, 
    93741, 93740, 93739, 93738, 93737, 
    93736, 93472, 92820, 92345, 89225, 
    93548, 93517, 93345, 92683
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00054

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
89225
92345 Casey F, Frantic Digital, Hard House, In Control Casey F, Frantic Digital, Hard House, In Control
92683 hardhouse,filth,harddance,dance,dancemusic hardhouse,filth,harddance,dance,dancemusic
92820 DBD054,Drop Bear Digital ,G.W.R.,Leeroy
92884 Hardhouse, hardhousefamily, UKHardHouse, digital, TomWhyld Hard House, Hard House family, Tom Whyld
92901 DJ CLK, SubZero, Bring The Noise Recordings, Original Mix, Exclusive, Toolbox Digital Download SubZero (Original Mix) by Bring The Noise Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. BTN004,Bring The Noise Recordings,DJ CLK
93345
93472
93517
93548
93736 superfly,hardhouse,release,digital,toolbox,hardance
93737 superfly,hardhouse,release,digital,toolbox,hardance
93738 superfly,hardhouse,release,digital,toolbox,hardance
93739
93740
93741 Burning Blade, Zillin Burning Blade, Zillin
93743 Boski,Tekneak,Human,Nature,Black,Dog Boski,Tekneak,Human,Nature,Black,Dog
93758 Shenton,Baseglitz,Don't be afraid,Tuff Groove,hard house Shenton & Baseglitz - Don't Be Afraid - Tuff Groove Recordings #074 Shenton,Baseglitz,Don't be afraid,Tuff Groove,hard house
93762
93763 TMP171,Gaz A,Phase One,Tempo Trax,Hard House Hard House TMP171,Gaz A,Phase One,Tempo Trax,Hard House