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 (
    79485, 79484, 79483, 79482, 79481, 79480, 
    79479, 79473, 79472, 79475, 79474, 
    78864, 79371, 79362, 78850, 78630, 
    79249, 79248, 79247, 79243
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00096

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
78630 IT027,Infused Traxx,DJ Darroo
78850 FE231,Fatal Energy Records,D-Railed,Hagane Shizuka
78864 FE232,Fatal Energy Records,LEZAMAboy
79243 LWHDB04,LW Recordings,Susumu
79247 LWHDB04,LW Recordings,Forza:Duo,Darren Hall
79248 LWHDB04,LW Recordings,Nina Suerte
79249 LWHDB04,LW Recordings,Cutoff:Sky
79362 DNZF575,DNZ Records,Garbie Project
79371 DNZF578,DNZ Records,T-Jay
79472 DNZ365,DNZ Records,Jamie B,DJ Oskar
79473 DNZ365,DNZ Records,Jamie B,DJ Oskar
79474 DNZF580,DNZ Records,Jamie B,Nova Scotia,MCSB
79475 DNZF581,DNZ Records,Jamie B,Garbie Project
79479 LWIBIZA201904,LW Recordings,Robbie Rivera,Dreamfreak
79480 LWIBIZA201904,LW Recordings,KRIME
79481 LWIBIZA201904,LW Recordings,DJ 5L45H
79482 LWIBIZA201904,LW Recordings,Sean Norvis,Kp London,Irina
79483 LWIBIZA201904,LW Recordings,Alex Spite
79484 LWIBIZA201904,LW Recordings,Simon Cardona
79485 LWIBIZA201904,LW Recordings,Brialmont