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 (
    110125, 110123, 110441, 110065, 110387, 
    110143, 110062, 110060, 110058, 110057, 
    110056, 110055, 110157, 110118, 110030, 
    110029, 109951, 109950, 109948, 109947
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00036

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
109947 FE457,Fatal Energy Records,Dictiondj,Twinkiedj
109948 KKE021,KarmaKontra Records,Forgiven,HelliXScream
109950 KKR152,KarmaKontra Records,Aftergeneration
109951 KKR152,KarmaKontra Records,Aftergeneration
110029 KKV016,KarmaKontra Records,Amperz
110030 KKV016,KarmaKontra Records,Amperz
110055 KKR155,KarmaKontra Records,Refold
110056 KKR155,KarmaKontra Records,Refold
110057 KKR153,KarmaKontra Records,LillyRazy
110058 FE458,Fatal Energy Records,Dicitondj,LJH
110060 KKRHS2022,KarmaKontra Records,DJ Teejay
110062 BBD099,Blackbox Digital,Jimmy Tailor
110065 FE459,Fatal Energy Records,Dictiondj,Perkins,Samurai DJ
110118 RAR084,Rapture Recordings,Re:Tox'd
110123 KKR154,KarmaKontra Records,Almagest!
110125 KKE022,KarmaKontra Records,Don Wizard
110143 Ycore48,Yorkshire Core Records,Rasper,Lynsey Tibbs,Jonny EL,Fastraxx
110157 HARSH201,Harsh Records,STARX,Velowen,Drean
110387 UPR210,Upcoming Records,Primal
110441 SPOON247,Spoontech Records,Phantom