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 (
    67356, 67355, 67354, 67353, 67352, 67351, 
    67350, 67349, 67348, 67347, 67346, 
    67345, 67344, 67314, 67313, 76804, 
    76803, 76802, 76801, 76800, 76799, 
    76798, 76797, 76796, 76795, 76794, 
    67193, 67179, 67178, 67177, 67176, 
    67175, 67174, 67173, 67172, 67171, 
    67170, 67169, 67168, 67167
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00061

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
67167 CheekPS1,Cheeky Tracks,Digital Mafia,Groove Control
67168 CheekPS1,Cheeky Tracks,Rob Cain,Groove Control
67169 CheekPS1,Cheeky Tracks,Groove Control
67170 CheekPS1,Cheeky Tracks,Groove Control
67171 CheekPS1,Cheeky Tracks,Groove Control
67172 CheekPS1,Cheeky Tracks,Groove Control,General Bounce
67173 CheekPS1,Cheeky Tracks,Groove Control
67174 CheekPS1,Cheeky Tracks,Groove Control,Poomstyles
67175 CheekPS1,Cheeky Tracks,Doctor B,Groove Control
67176 CheekPS1,Cheeky Tracks,Groove Control
67177 CheekPS1,Cheeky Tracks,Groove Control
67178 CheekPS1,Cheeky Tracks,Groove Control
67179 CheekPS1,Cheeky Tracks,Groove Control
67193 Digital Mafia, FTBM, On The Move, Disposition Digital, 88MPH) (Original Mix, Featured Hard House New, Hard House, Toolbox Digital Download On The Move (88MPH) (Original Mix) by Disposition Digital from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. DD036,Disposition Digital,FTBM,Digital Mafia
67313 Cheek376,Cheeky Tracks,Digital Mafia,James Revill
67314 Digital Mafia, James Revill, Neglect Me, Cheeky Tracks, Original Mix, Featured Hard House New, Hard House, Toolbox Digital Download Neglect Me (Original Mix) by Cheeky Tracks from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Cheek376,Cheeky Tracks,Digital Mafia,James Revill
67344 CheekA31,Cheeky Tracks,Johny Favourite,Jimmy Gooders
67345 CheekA31,Cheeky Tracks,John Reilly
67346 CheekA31,Cheeky Tracks,Chris Pears,Digital Mafia
67347 CheekA31,Cheeky Tracks,2 Bald Men
67348 CheekA31,Cheeky Tracks,Digital Mafia,Sonik
67349 CheekA31,Cheeky Tracks,Charm Offensive
67350 CheekA31,Cheeky Tracks,Harry Hard,General Bounce,Tiffany Jackson,Digital Mafia
67351 CheekA31,Cheeky Tracks,Duck & Cover
67352 CheekA31,Cheeky Tracks,Pick & Load
67353 CheekA31,Cheeky Tracks,Headrockers
67354 CheekA31,Cheeky Tracks,Sam Crow
67355 CheekA31,Cheeky Tracks,Venkman
67356 CheekA31,Cheeky Tracks,Alf Graham
76794 HDCEC003RRD,Hard Dance Coalition,Ross Homson
76795 HDCEC003RRD,Hard Dance Coalition,Base Graffiti
76796 HDCEC003RRD,Hard Dance Coalition,Tekno Kings,Baby Doc
76797 HDCEC003RRD,Hard Dance Coalition,Ben Stevens
76798 HDCEC003RRD,Hard Dance Coalition,BK,Tidy Boys
76799 HDCEC003RRD,Hard Dance Coalition,OD404,Nick Sentience
76800 HDCEC003RRD,Hard Dance Coalition,Nailer
76801 HDCEC003RRD,Hard Dance Coalition,OD404
76802 HDCEC003RRD,Hard Dance Coalition,Jupe,Defective Audio
76803 HDCEC003RRD,Hard Dance Coalition,Ben Stevens,Ilogik
76804 HDCEC003RRD,Hard Dance Coalition,Justin Bourne,Project Mayhem