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 (
    100273, 100272, 100271, 100270, 100269, 
    100268, 100267, 100266, 100265, 100264, 
    100263, 100262, 100261, 100260, 100166, 
    100165, 100164, 99754, 99738, 99737
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00052

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
99737 Cheek551,Cheeky Tracks,Kid Dynamo,Grapey
99738 Cheek551,Cheeky Tracks,Kid Dynamo,Grapey
99754 TIBUK011A,This Is Bounce UK Music,Pitch Invader,Laura Mac,DJ Shivv,Bon Lee
100164 Ali Wilson, Andy Farley, Matt Smallwood, Piranha, Untidy, Original Mix, Featured Hard House New, Hard House, Toolbox Digital Download Piranha (Original Mix) by Untidy from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. UNTIDYTREP001,Untidy,Ali Wilson,Andy Farley,Matt Smallwood
100165 UNTIDYTREP001,Untidy,Ali Wilson
100166 UNTIDYTREP001,Untidy,Ali Wilson
100260 HDCSU004,Hard Dance Coalition,12 Inch Thumpers
100261 HDCSU004,Hard Dance Coalition,Tony Heron,Frank Farrell,Technikal
100262 HDCSU004,Hard Dance Coalition,Karim,Superfast Oz,DJ Kristian
100263 HDCSU004,Hard Dance Coalition,Base Graffiti
100264 HDCSU004,Hard Dance Coalition,OD404
100265 HDCSU004,Hard Dance Coalition,JP,Jukesy
100266 HDCSU004,Hard Dance Coalition,JP,Jukesy,Pete Wardman
100267 HDCSU004,Hard Dance Coalition,Danny Harris
100268 HDCSU004,Hard Dance Coalition,Dave Owens,Danny Harris
100269 HDCSU004,Hard Dance Coalition,Steve Maynard
100270 HDCSU004,Hard Dance Coalition,Dave Curtis,Digital DJ's
100271 HDCSU004,Hard Dance Coalition,Samuel E Reeve,Jon Rundel
100272 HDCSU004,Hard Dance Coalition,OD404
100273 HDCSU004,Hard Dance Coalition,Frank Farrell,Ian M