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 (
    110550, 110388, 110332, 110331, 110329, 
    110328, 110419, 110389, 110424, 110423, 
    110391, 110390, 110349, 110696, 110386, 
    110358, 110357, 110354, 110351, 110350
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00049

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
110328 MQDREP009,+QDance Records,The Only One
110329 MQDREP009,+QDance Records,The Only One
110331 MQDREP009,+QDance Records,Comare
110332 MQDREP009,+QDance Records,The Only One,DJ Will
110349 KKE025,KarmaKontra Records,Mysterioz
110350 KKR159,KarmaKontra Records,LUX3L,Kroxy
110351 KKR159,KarmaKontra Records,LUX3L,Kroxy
110354 KKE024,KarmaKontra Records,Xetlar
110357 KKR160,KarmaKontra Records,Subtraqx
110358 KKR160,KarmaKontra Records,Subtraqx
110386 UPR213,Upcoming Records,Mixturez
110388 INFEXORI011,InfeXious Origins,Daniele Mondello
110389 UPR214,Upcoming Records,Genesiz
110390 KKR162,KarmaKontra Records,Overage,L-Scream
110391 KKR162,KarmaKontra Records,Overage,L-Scream
110419 SDA013,Scarred Digital,Assailant
110423 KKR161,KarmaKontra Records,Refold,Close Encounters
110424 KKR161,KarmaKontra Records,Refold,Close Encounters
110550 HBR129,HBR Black,Double F-ect,Brainkicker
110696 HB17,HB Records,Jimmy The Sound