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 (
    99218, 98671, 98706, 98162, 98629, 98621, 
    98620, 98619, 98614, 98611, 98610, 
    98594, 98482, 98439, 98438, 98429, 
    98180, 97985, 97983, 97982
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00028

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
97982 Cheek541,Cheeky Tracks,Danny Gibson
97983 Cheek541,Cheeky Tracks,Danny Gibson
97985 PMD044,Pumped,Joe Longbottom
98162 BTN017R,Bring The Noise Recordings,Jason Kinetic,Paul Clark (CLK)
98180 Straight, Narrow, Crazy, 4, it Straight & Narrow - Crazy 4 It Straight, Narrow, Crazy, 4, it
98429
98438 Emmanating Records, Kieran B, Emotional, Hard House, Dance Music, Club Music Emmanating Records, Kieran B, Emotional, Hard House, Dance Music, Club Music Emmanating Records, Kieran B, Emotional, Hard House, Dance Music, Club Music
98439 Pat Glenny, Agent Jack, Lost, In, Time, Slingshot, Cupra Pat Glenny, Agent Jack, Lost, In, Time, Slingshot, Cupra
98482 Global,Awakening,Records Global,Awakening,Records
98594
98610 Binty,Mitchell James,Paul Batten,Whoopaa,Tuff Groove Binty, Mitchell James vs Paul Batten - Whoopaa - Tuff Groove Recordings #080 Binty,Mitchell James,Paul Batten,Whoopa,Tuff Groove
98611 Lance, Burning Blade Lance, Burning Blade
98614 High Roller, Homzy homzy,full circle productions
98619 TMP184,Paul Hunter,Peter Davidson,No Gravity,Tempo Trax,Hard House Hard House TMP184,Paul Hunter,Peter Davidson,No Gravity,Tempo Trax,Hard House
98620
98621
98629 dean,richardson,deal,fight,hard,house,hoover dean,richardson,deal,fight,hard,house,hoover
98671
98706
99218