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 (
    81348, 80939, 81337, 80763, 80723, 80893, 
    80892, 81025, 81024, 80749, 80826, 
    80825, 80824, 80823, 80822, 80821, 
    80820, 80819, 80818, 80817
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00038

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
80723 HAR96,Harsh Records,Equalizer
80749 JK Theory, Jon Doe, Destination, G-Core, Jon Doe Remix, Featured Hard Dance New, Hard Dance, Toolbox Digital Download Destination (Jon Doe Remix) by G-Core from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. GCJD55,G-Core,JK Theory,Jon Doe
80763 WAOD045,We Are One Digital,Ganar,TopKat
80817 LWDFK12,LW Recordings,Darinse
80818 LWDFK12,LW Recordings,Luca Facchini DJ,Don Lore V,2Black
80819 LWDFK12,LW Recordings,Rassell,Sabine Berezina
80820 LWDFK12,LW Recordings,Ediz Hun
80821 LWDFK12,LW Recordings,Dimitri Twitz
80822 LWDFK12,LW Recordings,Alexander Orue
80823 LWDFK12,LW Recordings,Misha Klein,Nikita Malinin,Bruno Motta
80824 LWDFK12,LW Recordings,Ninjury
80825 LWDFK12,LW Recordings,Duh Oliver
80826 LWDFK12,LW Recordings,GoldNation,Sir Ari Gold,Jasmin
80892 GCJD56,G-Core,Jon Doe
80893 GCJD56,G-Core,Jon Doe
80939 GCJD58,G-Core,Jon Doe
81024 DNZF650,DNZ Records,Garbie Project
81025 DNZF650,DNZ Records,Garbie Project
81337 DNZF652,DNZ Records,Garbie Project
81348 DNZF654,DNZ Records,Alfre DJ