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 (
    91767, 91766, 91765, 91763, 92157, 91716, 
    92113, 92112, 92111, 92110, 92109, 
    92108, 92107, 92106, 91627, 91623, 
    91622, 91621, 91620, 91619
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00042

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
91619 LWSHD03,LW Recordings,NuroGL
91620 LWSHD03,LW Recordings,K8-e,Psycloud
91621 LWSHD03,LW Recordings,Pat Glenny
91622 LWSHD03,LW Recordings,DJ SKYR3SH
91623 LWSHD03,LW Recordings,Mickey G
91627 LWSHD03,LW Recordings,Frany SP
91716 PSRRE041,Project Storm Recordings,Ludo
91763 BTIDMUSIC047,BTID Music,Dekade
91765 UNTIDYFRAC01D,Untidy,Sam Townend
91766 UNTIDYFRAC01D,Untidy,Sam Townend
91767 UNTIDYFRAC01D,Untidy,Sam Townend
92106 DNZA006,DNZ Records,JJ,Baz A
92107 DNZA006,DNZ Records,JJ
92108 DNZA006,DNZ Records,JJ,DJ Oskar
92109 DNZA006,DNZ Records,Kritikal Mass,JJ
92110 DNZA006,DNZ Records,DJ Fitzy,Rossy B,Laura
92111 DNZA006,DNZ Records,JJ
92112 DNZA006,DNZ Records,Buzzed,JJ
92113 DNZA006,DNZ Records,JJ
92157 DNZF931,DNZ Records,DJ Joe Craig