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 (
    106173, 106172, 106171, 106170, 106642, 
    106605, 106596, 106583, 106579, 106565, 
    106546, 106545, 106544, 106543, 106542, 
    106541, 106540, 106539, 106538, 106537
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00040

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
106170 BRR193,Black Reverb,RhythmDial
106171 BRR193,Black Reverb,X6Cta
106172 BRR193,Black Reverb,New Waffen,Assuc
106173 BRR193,Black Reverb,Assuc,X6Cta
106537 DSBCD01,Disobey records,Breakstyle
106538 DSBCD01,Disobey records,Chemical Gorilla
106539 DSBCD01,Disobey records,Chemical Gorilla
106540 DSBCD01,Disobey records,Chemical Gorilla
106541 DSBCD01,Disobey records,The Dissident
106542 DSBCD01,Disobey records,The Dissident
106543 DSBCD01,Disobey records,The Dissident
106544 DSBCD01,Disobey records,The Fuze
106545 DSBCD01,Disobey records,The Fuze
106546 DSBCD01,Disobey records,The Fuze
106565 WAODB001,We Are One Digital,Ganar
106579 WAODB001,We Are One Digital,Ganar
106583 WAODB001,We Are One Digital,Ganar
106596 WAODB001,We Are One Digital,Ganar
106605 WAODB001,We Are One Digital,Ganar,Susumu
106642 CSP011,Conspiracy Music,Carnax