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 (
    92453, 92452, 92451, 1643, 92832, 92831, 
    92670, 92669, 92275, 92274, 92272, 
    92271, 92270, 92269, 92268, 92061, 
    92008, 91998, 92557, 92500
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00041

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
1643 ProhibitedIndulgeTwisted TraxHard HouseHard DanceNRG ProhibitedIndulgeTwisted TraxHard HouseHard DanceNRG ProhibitedIndulgeTwisted TraxHard HouseHard DanceNRG
91998 Matt Wigman, Reason, BTID Music, Original Mix, Bounce, Featured Hard House New, Hard House, Toolbox Digital Download Reason (Original Mix) by BTID Music from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. BTIDMUSIC088,BTID Music,Matt Wigman
92008 James Revill, Belgium Durt, Untidy, Original Mix, Featured Hard House New, Hard House, Toolbox Digital Download Belgium Durt (Original Mix) by Untidy from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. UNTIDY042,Untidy,James Revill
92061 ravenew20205,Rave Essentials,Bridson,The stig
92268 Cheek509,Cheeky Tracks,Madagasca,Ash M
92269 Cheek509,Cheeky Tracks,Madagasca,Kritikal Mass
92270 Cheek509,Cheeky Tracks,Madagasca,Tuffcub
92271 Cheek509,Cheeky Tracks,Madagasca,Kritikal Mass
92272 Cheek509,Cheeky Tracks,Madagasca,Ash M
92274 Dan Dyson, Activ8, SHED TRAX, Original Mix, Featured Hard House New, Hard House, Toolbox Digital Download Activ8 (Original Mix) by SHED TRAX from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. ST023,SHED TRAX,Dan Dyson
92275 ST023,SHED TRAX,Dan Dyson
92451 Bass Invaders, KB Project, Crazy About Your Love, BTID Music, KB Project Remix, Bounce, Featured Hard House New, Hard House, Toolbox Digital Download Crazy About Your Love (KB Project Remix) by BTID Music from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. BTIDMUSIC086,BTID Music,Bass Invaders,KB Project
92452 John Hemming, It's Yours, Cantina Records, Original Mix, Featured Hard House New, Hard House, Toolbox Digital Download It's Yours (Original Mix) by Cantina Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. CR007,Cantina Records,John Hemming
92453 Josh Butler, Trauma, Higher, Untidy, Josh Butler Remix, Featured Hard House New, Hard House, Toolbox Digital Download Higher (Josh Butler Remix) by Untidy from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. UNTIDYUX01,Untidy,Trauma,Josh Butler
92500 Bass Jumper, Underground Sound, Tidy, Original Mix, Featured Hard House New, Hard House, Toolbox Digital Download Underground Sound (Original Mix) by Tidy from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. TIDYBAEP01,Tidy,Bass Jumper
92557 DNZ434,DNZ Records,Daz McGregor
92669 BTIDMUSIC066,BTID Music,Eezy Inc,Sophie
92670 BTIDMUSIC066,BTID Music,Eezy Inc,Sophie
92831 DNZ435,DNZ Records,Dj Oskar,Adelle,Jumpin Jack
92832 DNZ435,DNZ Records,Dj Oskar,Adelle,Bounce Enforcerz