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 (
    111882, 111881, 111880, 111878, 112552, 
    111863, 111845, 114692, 114691, 114690, 
    114689, 112371, 112370, 112369, 112017, 
    112010, 111861, 111860, 111859, 111858
  ) 
  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
111845 PUR066,Pink Unicorn Records,Sarah Garlot Darkdomina
111858 STMLP021,Stamina Records,K-Wire,Lost Faith
111859 STMLP021,Stamina Records,Rick Chubbs
111860 STMLP021,Stamina Records,Tamerax
111861 STMLP021,Stamina Records,A.B
111863 Darren Tyler, Donna, Summer Body, 24/7 Hardcore, Extended Mix, Hardcore, Toolbox Digital Download Summer Body (Extended Mix) by 24/7 Hardcore from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. 247HC289,24/7 Hardcore,Darren Tyler,Donna
111878 ASD003,Addiktive Sounds Digital,BenAddikt,Oddball Savage
111880 THR202203,Twisted Hardcore Records,Noctyz
111881 THR202203,Twisted Hardcore Records,Noctyz
111882 AAA008,Triple A - Acid Artists In Action,Ben Fraser
112010 Dune, M-Project, I Got What U Like, Keeping The Rave Alive, Original Mix, Hardcore, Toolbox Digital Download I Got What U Like (Original Mix) by Keeping The Rave Alive from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. KTRAR075,Keeping The Rave Alive,Dune,M-Project
112017 Winterlake, Close To You, The World Of Obsession Recordings, Extended Mix, Hardcore, Toolbox Digital Download Close To You (Extended Mix) by The World Of Obsession Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. NTWO029,The World Of Obsession Recordings,Winterlake
112369 VDR023,Violent Disorder Records,Mozz
112370 VDR023,Violent Disorder Records,Mozz
112371 VDR023,Violent Disorder Records,Mozz
112552 PCR091A,Peacock Records,Deathroar
114689 DTK08,DTK Records,Get Han
114690 DTK08,DTK Records,Get Han
114691 DTK08,DTK Records,Ergoth
114692 DTK08,DTK Records,Ergoth