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 (
    93232, 1645, 93574, 93526, 93067, 93064, 
    93063, 93003, 93002, 93001, 93000, 
    92999, 92998, 92997, 92996, 92995, 
    92994, 92993, 92992, 92991
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00045

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
1645 Rikrom & Simon PaulDot CottonTwisted TraxHard HouseHard DanceNRG Rikrom & Simon PaulDot CottonTwisted TraxHard HouseHard DanceNRG Rikrom & Simon PaulDot CottonTwisted TraxHard HouseHard DanceNRG
92991 BORHH1,Alien Technology,DJ Masterhouse
92992 BORHH1,Alien Technology,Distorted Robocops,DJ Whyld
92993 BORHH1,Alien Technology,Type Zero
92994 BORHH1,Alien Technology,Rebel Frequency
92995 BORHH1,Alien Technology,Distorted Robocops,Phoenix,N-Gen
92996 BORHH1,Alien Technology,Rebel Frequency
92997 BORHH1,Alien Technology,S.I.D.R.,Andy Wolf
92998 BORHH1,Alien Technology,Rebel Frequency
92999 BORHH1,Alien Technology,Reactor DJ Team
93000 BORHH1,Alien Technology,OUT&UP,Distorted Robocops
93001 BORHH1,Alien Technology,Rebel Frequency
93002 BORHH1,Alien Technology,Reactor DJ Team,DJ Kosar
93003 BORHH1,Alien Technology,Puls@r
93063 Cheek514A,Cheeky Tracks,Brysi,Grapey
93064 Brysi, Grapey, 4 O'Clock, Cheeky Tracks, In The Morning) (Original Mix, Featured Hard House New, Bounce, Hard House, Toolbox Digital Download 4 O'Clock (In The Morning) (Original Mix) by Cheeky Tracks from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Cheek514A,Cheeky Tracks,Brysi,Grapey
93067 Ben Warren, The Show, SHED TRAX, Original Mix, Featured Hard House New, Hard House, Toolbox Digital Download The Show (Original Mix) by SHED TRAX from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. ST026,SHED TRAX,Ben Warren
93232 Jon BW, The Way, Cantina Records, Original Mix, Featured Hard House New, Hard House, Toolbox Digital Download The Way (Original Mix) by Cantina Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. CR009,Cantina Records,Jon BW
93526 PTR156,Power Tracks Records,DJ Manry
93574 DNZF959,DNZ Records,DJ Pulse,DJ Oskar,Silent Skies