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 (
    96111, 89233, 96931, 96923, 96621, 92921, 
    96897, 96889, 96826, 95940, 95939, 
    95938, 95937, 95936, 95935, 95934, 
    95933, 95932, 95931, 95930
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00037

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
89233
92921 Dave Owens, Fatter Than Your Mate's Mum, Vicious Circle, Exclusive, Toolbox Digital Download Fatter Than Your Mate's Mum by Vicious Circle from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
95930 UTHCMP001HD,Ultratech,Sam Alame,VaderMonkey
95931 UTHCMP001HD,Ultratech,VaderMonkey,Helz Bellz
95932 UTHCMP001HD,Ultratech,Drake Liddell
95933 UTHCMP001HD,Ultratech,VaderMonkey
95934 UTHCMP001HD,Ultratech,Vadermonkey,Ben Stevens
95935 UTHCMP001HD,Ultratech,VaderMonkey,Dave Owens
95936 UTHCMP001HD,Ultratech,VaderMonkey,Stompalott
95937 UTHCMP001HD,Ultratech,VaderMonkey,LOK-E
95938 UTHCMP001HD,Ultratech,Sam E
95939 UTHCMP001HD,Ultratech,LOK-E & Risa
95940 UTHCMP001HD,Ultratech
96111 BMR215,Beast Mode Recordings,Adam Bellew,NuroGL
96621 BTN012,Bring The Noise Recordings,Mobi D
96826
96889 TMP178,Bizarre Q,Lost Kontrol,Tempo Trax,Hard House Hard House TMP178,Bizarre Q,Lost Kontrol,Tempo Trax,Hard House
96897 Tara,Rough,Night,Hard,House,Hoover,Black,Dog Tara,Rough,Night,Hard,House,Hoover,Black,Dog
96923
96931 Golden Eagle DJ Serenity Energy Source Productions Hardhouse Golden Eagle DJ Serenity Energy Source Productions Hardhouse Golden Eagle DJ Serenity Energy Source Productions Hardhouse