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 (
    95922, 95921, 95839, 94774, 96891, 96733, 
    95876, 96757, 96756, 96755, 96754, 
    96753, 96752, 96751, 96750, 96749, 
    96748, 96743, 96715, 96711
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00040

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
94774 Jason Nawty, Direct Drive, Frantic Digital, Hard Trance, Everything Changed Jason Nawty, Direct Drive, Frantic Digital, Hard Trance, Everything Changed
95839 Hard trance, hard house, Boris the Noss, mofo, hard dance, bounce, hard bounce, scouse bouse, Sugar Skull Digital is premuim hard house and hard trance label, releasing the best tracks in hard dance today. Hard trance, hard house, Boris the Noss, mofo, hard dance, bounce, hard bounce, scouse bouse,
95876
95921 Cheek529,Cheeky Tracks,Steve Thornton,Digital Mafia
95922 Cheek529,Cheeky Tracks,Steve Thornton,Digital Mafia
96711 James Dub, Burning Blade James Dub, Burning Blade
96715 Higher and Higher DJ Serenity Energy Source Productions Hard House Higher and Higher DJ Serenity Energy Source Productions Hard House Higher and Higher DJ Serenity Energy Source Productions Hard House
96733 James Nardi, Scorpion Trax, Hardhouse James Nardi, Scorpion Trax, Hardhouse James Nardi, Scorpion Trax, Hardhouse
96743
96748
96749
96750
96751
96752
96753
96754
96755
96756
96757
96891 pat,glenny,split,groove,pitch,drift,recordings pat,glenny,split,groove,pitch,drift,recordings pat,glenny,split,groove,pitch,drift,recordings