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 (
    99969, 99955, 99968, 99967, 99952, 99948, 
    99923, 99922, 99917, 99915, 99914, 
    99913, 99906, 99867, 99791, 99788, 
    99694, 99678, 99519, 99435
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00041

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
99435
99519 TMP188,Paul Hunter,Matt Clarkson,Tension,Tempo Trax,Hard House Hard House TMP188,Paul Hunter,Matt Clarkson,Tension,Tempo Trax,Hard House
99678 superfly,hardhouse,release,digital,toolbox,hardance
99694 Global,Awakening,Records Global,Awakening,Records
99788 Cupra, Horsepower, slingshot Cupra, Horsepower, slingshot
99791
99867
99906 boski, eyes, hard, house, halloween, eerie, spooky boski, eyes, hard, house, halloween, eerie, spooky
99913 EM009, Direct Drive, The Bond, Emmanating Records, Trance, Club Music, DJ Music EM009, Direct Drive, The Bond, Emmanating Records, Trance, Club Music, DJ Music EM009, Direct Drive, The Bond, Emmanating Records, Trance, Club Music, DJ Music
99914 Full Circle Productions Alpha A, full circle productions, homzy
99915 dean,richardson,eliminated,pitch,drift dean,richardson,eliminated,pitch,drift dean,richardson,eliminated,pitch,drift
99917 Matt Wade, Burning Blade Matt Wade, Burning Blade
99922
99923
99948 Kaki Raphael, Power, Pack, Kaki Trax Kaki Raphael, Power, Pack, Kaki Trax, Snap!
99952 Magic Wand DJ Serenity Energy Source Productions Hard House Magic Wand DJ Serenity Energy Source Productions Hard House Magic Wand DJ Serenity Energy Source Productions Hard House
99955
99967 Magic Wand DJ Serenity Energy Source Productions Hard House Magic Wand DJ Serenity Energy Source Productions Hard House Magic Wand DJ Serenity Energy Source Productions Hard House
99968 Magic Wand DJ Serenity Energy Source Productions Hard House Magic Wand DJ Serenity Energy Source Productions Hard House Magic Wand DJ Serenity Energy Source Productions Hard House
99969