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 (
    80587, 80567, 80015, 80010, 80009, 80004, 
    80472, 103007, 80448, 80001, 80272, 
    80080, 80079, 80078, 80077, 80076, 
    80075, 80074, 80073, 80072
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00047

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
80001 BR0058,Broken Records UK,Alexander Norman,Ruth
80004 CheekWE14,Cheeky Tracks,Audio Chimp
80009 CheekWE14,Cheeky Tracks,Elivate,Cut-Up
80010 CheekWE14,Cheeky Tracks,SystemShock,Timmy Coop
80015 CheekWE14,Cheeky Tracks,Eezy Inc,Sophie,Inner Sinner
80072 LWHDB05,LW Recordings,Wragg,Iain Cross,FLUX
80073 LWHDB05,LW Recordings,Euval Spirits
80074 LWHDB05,LW Recordings,Wain Johnstone,Jon The Baptist,Chuck-E
80075 LWHDB05,LW Recordings,Pariah,Wreka,Hardforze
80076 LWHDB05,LW Recordings,Tom Parr
80077 LWHDB05,LW Recordings,Dr Hill,Mr Rezistor
80078 LWHDB05,LW Recordings,Carbo Bass
80079 LWHDB05,LW Recordings,V.S.D. Project
80080 LWHDB05,LW Recordings,T-Factor
80272 DNZF616,DNZ Records,Que & Rkay
80448 DNZF617,DNZ Records,DJ Miho
80472 DNZF620,DNZ Records,Alec Fury
80567 DNZF621,DNZ Records,DJ Joe Mc
80587 DNZF622,DNZ Records,Jamie B
103007 T25DJP05D,Tidy,Audox