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 (
    99645, 98789, 89238, 99517, 98766, 92937, 
    99473, 99472, 99471, 99470, 99469, 
    99467, 99466, 99442, 99437, 99432, 
    99428, 99414, 99276, 99271
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00038

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
89238
92937 Delinquents, Step Ya Game Up, Vicious Circle, Exclusive, Toolbox Digital Download Step Ya Game Up by Vicious Circle from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
98766 ATRREGEN02,Alien Technology,Rebel Frequency
98789 ATRREGEN03,Alien Technology,Rebel Frequency
99271 Global,Awakening,Records Global,Awakening,Records
99276
99414 superfly,hardhouse,release,digital,toolbox,hardance
99428 Babzookaz, Damien Blanes, Frantic Digital, Hard House, Oceana Babzookaz, Damien Blanes, Frantic Digital, Hard House, Oceana
99432
99437 Lab 4, Har House, Slenderman, Visceral, Filth, Hard Dance, Bass Visceral Records is honored and humbled to have the legendary Lab 4 releasing a track with our resident filth lord, Slenderman. This is unprecedented! Get this tune in your face holes! Lab 4, Har House, Slenderman, Visceral, Filth, Hard Dance
99442
99466 EM008, David Marsh, Rock Me Baby, Emmanating Records, Hard House EM008, David Marsh, Rock Me Baby, Emmanating Records, Hard House EM008, David Marsh, Rock Me Baby, Emmanating Records, Hard House
99467 alpha a, full circle productions,
99469 Dark Suspects,Divergent,Tuff Groove Dark Suspects - Divergent - Tuff Groove Recordings #081 Dark Suspects,Divergent,Tuff Groove
99470 stuart,m,eastern,jam,pitch,drift stuart,m,eastern,jam,pitch,drift stuart,m,eastern,jam,pitch,drift
99471 Roosta, X-ite Audio, Hard House, Hard Trance Piece of me Piece of me, roosta, xite, x-ite audio, hard house
99472 Darragh,Mulligan,Hard,House,Trance,Natural, Disaster Darragh,Mulligan,Hard,House,Trance,Natural, Disaster
99473
99517
99645