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 (
    121576, 121575, 121574, 121573, 121572, 
    121571, 121570, 104342, 102330, 102329, 
    102328, 102327, 102326, 102325, 102324, 
    102323, 102322, 102321, 102320, 102319
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00037

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
102319 LWDNCD05,LW Recordings,Lisette Melendez,Charlie Babie,Tim Spinning Schommer
102320 LWDNCD05,LW Recordings,Kidd Ross
102321 LWDNCD05,LW Recordings,Le Granville
102322 LWDNCD05,LW Recordings,Filip Groenlund,Leeny
102323 LWDNCD05,LW Recordings,Mars Basement
102324 LWDNCD05,LW Recordings,EmilZ
102325 LWDNCD05,LW Recordings,Lee Dagger,Melanie Fontana,Dj Volume
102326 LWDNCD05,LW Recordings,Nolan Koskinen,Gid Sedgwick
102327 LWDNCD05,LW Recordings,Lukulum
102328 LWDNCD05,LW Recordings,That Fatal Error
102329 LWDNCD05,LW Recordings,Ruesche,Goerbig
102330 LWDNCD05,LW Recordings,Steyyx,Rachel Morgan Perry,Bazley
104342 WAOD074,We Are One Digital,Ganar
121570 LWDNCD05b,LW Recordings,Manil
121571 LWDNCD05b,LW Recordings,Jordy Doormen
121572 LWDNCD05b,LW Recordings,Nick Jay,Silke,7Th Heaven
121573 LWDNCD05b,LW Recordings,Anto,Lyle M
121574 LWDNCD05b,LW Recordings,UKRUX,DrewOne
121575 LWDNCD05b,LW Recordings,ADE
121576 LWDNCD05b,LW Recordings,Lisette Melendez,Charlie Babie,Tim Spinning Schommer