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 (
    109465, 109886, 109742, 109741, 109740, 
    109739, 109448, 109447, 109446, 109445, 
    109444, 109376, 122293, 122292, 122291, 
    122290, 122289, 122288, 122287, 122286
  ) 
  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
109376 Alphatech_5, Find You, Smiley Tunes Digital, Original Mix, Hardcore, Toolbox Digital Download Find You (Original Mix) by Smiley Tunes Digital from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. STDIGI066,Smiley Tunes Digital,Alphatech_5
109444 ATECH12,A-Tech Music,Rikki Arkitech,Double Decka,Synthwulf
109445 ATECH12,A-Tech Music,Rikki Arkitech
109446 MOK266,Mokum Records,Rancor Spike
109447 MOK266,Mokum Records,Rancor Spike
109448 MOK266,Mokum Records,Rancor Spike
109465 Cheek599,Cheeky Tracks,Catchy,Eufeion
109739 CATID107,The Funky Cat,Wavolizer
109740 CATID107,The Funky Cat,Wavolizer
109741 CATID107,The Funky Cat,Wavolizer
109742 CATID107,The Funky Cat,Wavolizer
109886 XLUSIVE004,X-tinction Exlusive,Arzadous,Underfire
122286 LWHTS05b,LW Recordings,Pyraxx
122287 LWHTS05b,LW Recordings,Hector Da Rosa,MarAxe
122288 LWHTS05b,LW Recordings,Ayako Mori,kaori
122289 LWHTS05b,LW Recordings,COACH
122290 LWHTS05b,LW Recordings,Jon Krieger
122291 LWHTS05b,LW Recordings,Roentgen Limiter
122292 LWHTS05b,LW Recordings,Riotbot
122293 LWHTS05b,LW Recordings,Isgang,Etam