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 (
    39989, 39981, 39862, 40074, 39961, 39818, 
    39808, 39643, 39642, 39445, 39505, 
    39150, 39149, 39271, 39418, 39074, 
    39119, 38831, 38821, 38943
  ) 
  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
38821 Zac F, Cut The Mid Range, OMPTraxx, Original Mix, Bounce, Hard House, Toolbox Digital Download Cut The Mid Range (Original Mix) by OMPTraxx from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. OMP018,OMPTraxx,Zac F
38831 Ash, Zac F, All U Dj's, OMPTraxx, Original Mix, Bounce, Hard House, Toolbox Digital Download All U Dj's (Original Mix) by OMPTraxx from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. OMP019,OMPTraxx,Zac F,Ash
38943 DNZF065,DNZ Records,Dj Nillos
39074 ACTD61,Active Sound Records,Deejay Laura
39119 dan040mx,Dance Solution,Paco Banaclocha,Sandra Polop,Dj Oskar
39149 DNZ130,DNZ Records,Dj Oskar
39150 DNZ130,DNZ Records,Dj Oskar,Phil Mac
39271 Buzzed, You Are In The Move!, DNZ Records, Original Mix, Hard House, Toolbox Digital Download You Are In The Move! (Original Mix) by DNZ Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. DNZ131,DNZ Records,Buzzed
39418 RE012,Relay Records,Dj Ransome
39445 DNZ133,DNZ Records,Andres Ballesteros
39505 RE013,Relay Records,Dj Ransome
39642 EDD083,Emotive Dance Digital,Dj Trip,Dj Xito
39643 EDD083,Emotive Dance Digital,Dj Trip,Dj Xito
39808 YEAH071,Yeah Boi Recordings,Bowie666,Pob EG,DJ Ransome
39818 DNZF069,DNZ Records,Dj Nillos
39862 YEAH074,Yeah Boi Recordings,Miss Fenetic
39961 DNZF071,DNZ Records,Nu-Breed DJ
39981 DNZF073,DNZ Records,Nu-Breed DJ
39989 DNZ134,DNZ Records,Miky One,Dj Kino
40074 DJ Ransome, Kumo, Set Me Free, Relay Records, Original Mix, Bounce, Hard House, Toolbox Digital Download Set Me Free (Original Mix) by Relay Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. RE015,Relay Records,Kumo,DJ Ransome