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 (
    85887, 85886, 85885, 85884, 85883, 85882, 
    85881, 85880, 85879, 85878, 85877, 
    85876, 85875, 85874, 85873, 85872, 
    85871, 85870, 85869, 85868
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00033

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
85868 LWIBIZA202004,LW Recordings,DJ Skywalk,Lisa Lucius,Arnold Palmer
85869 LWIBIZA202004,LW Recordings,Supamono,Zsozeatya,Sunset Blvd
85870 LWIBIZA202004,LW Recordings,Cihanback,Joan Jose
85871 LWIBIZA202004,LW Recordings,Pillows,Kaan Pars
85872 LWIBIZA202004,LW Recordings,Dogg Scar,Chris Scott
85873 LWIBIZA202004,LW Recordings,Max Pavlov,Vika Grand
85874 LWIBIZA202004,LW Recordings,Shady Sabry
85875 LWIBIZA202004,LW Recordings,Blond Kid
85876 LWIBIZA202004,LW Recordings,Transform
85877 LWIBIZA202004,LW Recordings,Dino Del Moro,B4O
85878 LWIBIZA202004,LW Recordings,NoDi Ataraxia,Hazeman,Victoria Stilmant
85879 LWIBIZA202004,LW Recordings,Calibur
85880 LWIBIZA202004,LW Recordings,Luke Dreamhood
85881 LWIBIZA202004,LW Recordings,Dark Intensity,Angelica Joni,Sal Medina
85882 LWIBIZA202004,LW Recordings,Vyntage Haze
85883 LWIBIZA202004,LW Recordings,Rodion Gordin,Dinara Rudane,Dave Loyd
85884 LWIBIZA202004,LW Recordings,House Anatomy
85885 LWIBIZA202004,LW Recordings,Atlantic Crew
85886 LWIBIZA202004,LW Recordings,DJ Trife,Blackout Ja,Dark Intensity,Sophia May
85887 LWIBIZA202004,LW Recordings,Retrostatic