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 (
    69285, 69284, 69283, 69282, 69281, 69280, 
    69279, 69278, 69277, 69276, 69275, 
    69274, 69273, 69272, 69271, 69270, 
    69269, 69268, 69267, 69266, 69265, 
    69264, 69263, 69262, 69261, 69260, 
    69259, 69258, 69128, 68673, 68672, 
    68671, 68670, 68669, 68668, 69121, 
    68664, 68460, 68380, 68611
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00063

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 40 Using where

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
68380 CheekA33,Cheeky Tracks,Digital Mafia,DJ Lolly
68460 dan108mx,Dance Solution,DJ DBC
68611 RE109,Relay Records,Jumpin Jack
68664 Jue, Be Magic, Relay Records, Original Mix, Bounce, Featured Hard House New, Hard House, Toolbox Digital Download Be Magic (Original Mix) by Relay Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. RE110,Relay Records,Jue
68668 Cheek379,Cheeky Tracks,Starman,Italo Bounce
68669 Cheek379,Cheeky Tracks,Starman,Italo Bounce
68670 Cheek379,Cheeky Tracks,Starman,Italo Bounce
68671 Cheek379,Cheeky Tracks,Starman,Italo Bounce
68672 Cheek379,Cheeky Tracks,Starman,Italo Bounce
68673 Cheek379,Cheeky Tracks,Starman,Italo Bounce
69121 RE112,Relay Records,A-Side
69128 RE113,Relay Records,Cruse Control
69258 HDCPS004,Hard Dance Coalition,Andy Farley,Frank Farrell
69259 HDCPS004,Hard Dance Coalition,Frank Farrell
69260 HDCPS004,Hard Dance Coalition,Andy Farley,Frank Farrell
69261 HDCPS004,Hard Dance Coalition,Paul King,Frank Farrell
69262 HDCPS004,Hard Dance Coalition,Defamation,Frank Farrell
69263 HDCPS004,Hard Dance Coalition,Frank Farrell
69264 HDCPS004,Hard Dance Coalition,Tony Heron,Frank Farrell
69265 HDCPS004,Hard Dance Coalition,Richard Toomz,Frank Farrell
69266 HDCPS004,Hard Dance Coalition,Frank Farrell
69267 HDCPS004,Hard Dance Coalition,Nik Denton,Frank Farrell
69268 HDCPS004,Hard Dance Coalition,Frank Farrell,Captain Tinrib
69269 HDCPS004,Hard Dance Coalition,Rodi Style,Frank Farrell
69270 HDCPS004,Hard Dance Coalition,Munkjack
69271 HDCPS004,Hard Dance Coalition,Frank Farrell,Dave Owens
69272 HDCPS004,Hard Dance Coalition,Ian M,Frank Farrell
69273 HDCPS004,Hard Dance Coalition,Frank Farrell
69274 HDCPS004,Hard Dance Coalition,Frank Farrell
69275 HDCPS004,Hard Dance Coalition,Munkjack
69276 HDCPS004,Hard Dance Coalition,DNG,Frank Farrell
69277 HDCPS004,Hard Dance Coalition,Andy Farley,Frank Farrell
69278 HDCPS004,Hard Dance Coalition,The Tom,Frank Farrell
69279 HDCPS004,Hard Dance Coalition,Frank Farrell
69280 HDCPS004,Hard Dance Coalition,WGM,Frank Farrell
69281 HDCPS004,Hard Dance Coalition,Karim,Frank Farrell
69282 HDCPS004,Hard Dance Coalition,Adam M,Frank Farrell
69283 HDCPS004,Hard Dance Coalition,Frank Farrell
69284 HDCPS004,Hard Dance Coalition,Dustbin Barrell
69285 HDCPS004,Hard Dance Coalition,Dion,Frank Farrell