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 (
    87105, 87104, 87103, 87102, 87101, 87100, 
    87099, 87098, 87097, 87096, 87095, 
    87094, 87093, 87092, 87091, 87090, 
    87089, 87088, 87087, 87086
  ) 
  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
87086 LWHDB13,LW Recordings,Jonny EL
87087 LWHDB13,LW Recordings,Expulze,Splinta
87088 LWHDB13,LW Recordings,N3CKBR34KR
87089 LWHDB13,LW Recordings,S3RL,Outforce,Hartshorn
87090 LWHDB13,LW Recordings,Deluxe Corporation
87091 LWHDB13,LW Recordings,Dj Kano
87092 LWHDB13,LW Recordings,Ganar
87093 LWHDB13,LW Recordings,John Carr
87094 LWHDB13,LW Recordings,Phil Mackintosh
87095 LWHDB13,LW Recordings,Milano The Don,Daryl Di-Kar
87096 LWHDB13,LW Recordings,Jon Doe
87097 LWHDB13,LW Recordings,First Gift
87098 LWHDB13,LW Recordings,Robbie Teeze
87099 LWHDB13,LW Recordings,Cookie
87100 LWHDB13,LW Recordings,BloodDropz!
87101 LWHDB13,LW Recordings,Ludo
87102 LWHDB13,LW Recordings,M1dy
87103 LWHDB13,LW Recordings,BloodDropz!,Cyber_dj Project
87104 LWHDB13,LW Recordings,HybridBeats
87105 LWHDB13,LW Recordings,DJ Trevor,MC Clarkie