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 (
    100213, 100212, 100211, 100210, 100208, 
    100207, 100192, 100174, 93464, 100169, 
    100168, 100167, 100138, 100137, 100132, 
    100067, 100046, 100037, 99649, 99639
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00042

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
93464 Adam M, K-Live, RR Fierce, Tenchy, Yamamba, Vicious Circle, Adam M & Tenchy Remix, Exclusive, Toolbox Digital Download Yamamba (Adam M & Tenchy Remix) by Vicious Circle from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
99639 UTHHT023b,Ultratech,VaderMonkey,Raz & Obbo
99649 twistedtraxx,shockrecords,cheekytracks twistedtraxx hardhouse,nrg,bouncyhardhouse,
100037 Global,Awakening,Records Global,Awakening,Records
100046 Cupra, Quantum, slingshot, Tinrib Cupra, Quantum, slingshot, Tinrib
100067
100132 DjOne7TOut, Burning Blade DjOne7TOut, Burning Blade
100137
100138 Full Circle Productions Tash Tikka, full circle productions
100167 BDR,Black,dog,hard,house,sense, BDR,Black,dog,hard,house,sense,
100168 BDR,BDR2,Hard,house,time,hoover BDR,BDR2,Hard,house,time,hoover
100169
100174 old skool, happy hardcore, hardcore, breakbeat, fat controller Latest release from Fat Controller revisiting the early days of Happy Hardcore. A euphoric track with a old skool feeling fat controller, wanna b free, old skool, happy hardcore
100192
100207
100208
100210
100211
100212
100213