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 (
    93059, 93057, 92492, 92956, 92883, 92900, 
    92899, 92898, 92897, 92895, 92834, 
    92808, 92789, 92788, 92765, 92758, 
    92675, 92673, 92291, 92238
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00031

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
92238 HOT080,Hot Box Digital,Dean Richardson
92291 ED007,Epidemic Digital,FilterFreakz
92492 BMR211,Beast Mode Recordings,FiveOne,NuroGL
92673 twistedtraxx,toolbox,viicouscircle,grady g,dramatik,benstevens,kam-pain,dyson, twistedtraxx digital twistedtraxx,sentinelz,dan dyson,kam-pain,grady g,nikkdbubble,nikdenton,randombutraw
92675 Kelly Ward, Visceral, Chaney, Charged, Hard House Visceral Records, Visceral, Charged, Ward, Chaney
92758 Casey F,Emma-Nate,Get It Right, Re:Form Recordings,Vocal Hard House Casey F,Emma-Nate,Get It Right, Re:Form Recordings,Vocal Hard House Casey F,Emma-Nate,Get It Right, Re:Form Recordings,Vocal Hard House
92765 RPR193, Narc, Disturbed, Raw Power, hard house, filth, hoovers, NRG Narc and Disturded do exactly what they do best with this amazing, filthy number! You know them by now so you know what to expect. Dark synths, hoovers and bass! One of the end of the night! RPR193, Narc, Disturbed, Raw Power, hard house, filth, hoovers, NRG
92788 Cupra, Daimon Hellstrom, Worldwide Normality, Hellstorm Trax, Exclusive, Toolbox Digital Download Worldwide Normality by Hellstorm Trax from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
92789 superfly,hardhouse,release,digital,toolbox,hardance
92808 https://www.facebook.com/search/top?q=global%20awakening%20records
92834 TMP168,Paul Hunter,Peter Davidson,Panic,Tempo Trax,Hard House Hard House TMP168,Paul Hunter,Peter Davidson,Panic,Tempo Trax,Hard House
92883 Hardhouse, hardhousefamily, UKHardHouse, digital Hard House, Hard House family, UK Hard House, EmParty
92895 Hardhouse, hardhousefamily, UKHardHouse, digital, TomWhyld Hard House, Hard House family, Tom Whyld
92897 Boski, Burning Blade Boski, Burning Blade
92898 Batten & Brow,Matt Cox,Tuff Groove,Um Bongo Batten & Brow collaboration with Matt Cox - uplifting funky hard house vibes! Batten & Brow,Matt Cox,Tuff Groove,Um Bongo
92899
92900
92956
93057 Rush Em DJ Serenity Energy Source Productions Hardhouse NRG Rush Em DJ Serenity Energy Source Productions Hardhouse NRG Rush Em DJ Serenity Energy Source Productions Hardhouse NRG
93059