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 (
    100888, 100887, 100886, 100885, 100884, 
    100883, 100882, 100881, 100880, 100878, 
    100844, 100843, 100809, 100780, 100646, 
    100483, 99747, 100808, 100367, 100779
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00043

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
99747 Mischief Duo, Frantic Digital, Hard House, Love Me Mischief Duo, Frantic Digital, Hard House, Love Me
100367 BTN024,Bring The Noise Recordings,Andy Naylor
100483 INR083,Immortal Noise Recordings,Spyndl
100646
100779 Tekneak, Kodokushi Tekneak, Kodokushi
100780 Jay Key, Visceral Records, Hard, Hard House, Filth, Hoover, Rough, Tough We are so proud to have an original Jay Key track! This thing bangs harder than Neil Pert on meth. Come get you some. Jay Key, Visceral Records, Hard, Hard House, Filth, Hoover, Rough, Tough
100808 M-Series, Kimara Records, M-Series, Hard House, Remix, Side Effects M-Series, Kimara Records, M-Series, Hard House, Remix, Side Effects M-Series, Kimara Records, M-Series, Hard House, Remix, Side Effects
100809 Global,Awakening,Records Global,Awakening,Records
100843
100844 Agent Jack, The Snail, Gary O'Connor, Cupra, Slingshot, Nogger, U Got My Glove Agent Jack, The Snail, Gary O'Connor, Cupra, Slingshot, Nogger, U, Got, My, Glove
100878 Full Circle Productions, Tara N full circle productions, Tara N
100880 Niztrip,Teddy,Bear,Hard,House,Hoover Niztrip,Teddy,Bear,Hard,House,Hoover
100881
100882
100883
100884
100885
100886
100887
100888