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 (
    95338, 95301, 95193, 95192, 94875, 94822, 
    94657, 94656, 93317, 95297, 95296, 
    94543, 94800, 95005, 92915, 95267, 
    95266, 95265, 95263, 95257
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00034

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
92915 Random But Raw, Got What It Takes, Vicious Circle, Exclusive, Toolbox Digital Download Got What It Takes by Vicious Circle from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
93317 J2S, Frantic Digital, Hard House, Rave Day J2S, Frantic Digital, Hard House, Rave Day
94543 BTN008,Bring The Noise Recordings,CLK,Dark By Design
94656 ED009,Epidemic Digital,Tara N
94657 ED009,Epidemic Digital,Tara N
94800 nurogl,pat,glenny,hardline,pitch,drift nurogl,pat,glenny,hardline,pitch,drift nurogl,pat,glenny,hardline,pitch,drift
94822 hardhouse,filth,harddance,dance,dancemusic hardhouse,filth,harddance,dance,dancemusic hardhouse,filth,harddance,dance,dancemusic
94875 FILTH011,The Filth Foundry,Boris The Noss
95005
95192 Digital Mafia, Mike Taylor, Rave To The Grave, Tidy, Original Mix, Hard House, Toolbox Digital Download Rave To The Grave (Original Mix) by Tidy from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. TIDY278T,Tidy,Digital Mafia,Mike Taylor
95193 Digital Mafia, JLF, Doin' That, Tidy, Energy) (Original Mix, Hard House, Toolbox Digital Download Doin' That (Energy) (Original Mix) by Tidy from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. TIDY278T,Tidy,Digital Mafia,JLF
95257 Make It Home, David Morrish, Jeli Jams, Exclusive, Toolbox Digital After taking a year out from releasing we are back, maybe not to full on one release a month schedule but we are putting out some new music. We start with Make It Home from David Morrish, David has delivered an absolute weapon with this hard hitting vocal Make It Home, David Morrish, Jeli Jams, Exclusive, Toolbox Digital
95263
95265 Visceral, Hard, Hard House, The Light, Ross, Ross Farley, Slenderman, Visceral Records, Toolbox Digital, Hard Trance Ross Farley & Slenderman bring youth release of one of the most requested singles from the IN:VISION album. This hard house/hard trancer will melt your face and leave you gasping for air during the epic build up. Visceral, Hard, Hard House, The Light, Ross, Ross Farley, Slenderman, Visceral Records, Toolbox Digital, Hard Trance, Matt Clarkson
95266 Visceral, Hard, Hard House, The Dark, Ross, Ross Farley, Slenderman, Visceral Records, Toolbox Digital, Filth With Ross Farley's first single on the harder sub-genre Visceral Filth, we bring you an absolute dark-hoover-laiden wasteland. Some men just want to watch the world burn. Visceral, Hard, Hard House, The Dark, Ross, Ross Farley, Slenderman, Visceral Records, Toolbox Digital, Filth
95267 Burning Blade, Tekneak, Burning Blade, Tekneak,
95296
95297
95301 superfly,hardhouse,release,digital,toolbox,hardance
95338