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 (
    111643, 111642, 111641, 111640, 111639, 
    111638, 111637, 111669, 110650, 111393, 
    111392, 110577, 110576, 110559, 110558, 
    110557, 111872, 111667, 111666, 111385
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00052

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
110557 KKR168,KarmaKontra Records,Vampaya
110558 KKV022,KarmaKontra Records,Sky Fire,Adven
110559 KKV022,KarmaKontra Records,Sky Fire,Adven
110576 KKR167,KarmaKontra Records,BroTek
110577 KKR167,KarmaKontra Records,BroTek
110650 SPOON249A,Spoontech Records,Chapter V,Amduscias
111385 KKRMX001,KarmaKontra Records,CategorieN,MBW
111392 MQDRHRD012,+QDance Records,The Only One
111393 MQDRHRD012,+QDance Records,The Only One
111637 KKRC002,KarmaKontra Records,RVRS
111638 KKRC002,KarmaKontra Records,Jano
111639 KKRC002,KarmaKontra Records,DYSTH
111640 KKRC002,KarmaKontra Records,MBW
111641 KKRC002,KarmaKontra Records,Anarkic
111642 KKRC002,KarmaKontra Records,Skully
111643 KKRC002,KarmaKontra Records,Ephrcz
111666 UPR217,Upcoming Records,Mindst8
111667 WRD018,Wardog Records,Simox
111669 UPR218,Upcoming Records,Verdict
111872 HB18,HB Records,Jimmy The Sound,Alpheratz