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 (
    94857, 94814, 95739, 95696, 95695, 89230, 
    95546, 95200, 94865, 94683, 93093, 
    92916, 95501, 95500, 95499, 95498, 
    95497, 95496, 95495, 95494
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00048

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
89230
92916 Cupra, RR Fierce, Neurone X, Vicious Circle, Cupra Remix, Exclusive, Toolbox Digital Download Neurone X (Cupra Remix) by Vicious Circle from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
93093 Hardhouse, hardhousefamily, UKHardHouse, digital Hard House, Hard House family, Matt Clarkson, TMC, UK Hard House
94683 PMD038,Pumped,Joe Longbottom,SRJ
94814 PMD039,Pumped,M.A.R.C
94857 UTHHD047,Ultratech,VaderMonkey
94865 BTN009,Bring The Noise Recordings,Ben Kaye
95200 BMR213,Beast Mode Recordings,Renshi,NuroGL
95494
95495 Burning Blade, Burning Blade,
95496 Kodokushi, Dan Dyson Kodokushi, Dan Dyson
95497 Paul Reeves, Paul, Visceral, Filth, Dirty, Hoover, Hoovers, Visceral Filth, Hard House, House For VR Filth's 8th release, Paul Reeves is BACK with another punishing tune for your face holes Paul Reeves, Paul, Visceral, Filth, Dirty, Hoover, Hoovers, Visceral Filth, Hard House, House
95498 Boski,men,brave,hard,house,movie Boski,men,brave,hard,house,movie
95499 Your Time DJ Serenity Energy Source Productions Hard House Hard Dance Your Time DJ Serenity Energy Source Productions Hard House Hard Dance Your Time DJ Serenity Energy Source Productions Hard House Hard Dance
95500 TMP174,Mada,Homzy,Dream Forever,Tempo Trax,Hard House Hard House TMP174,Mada,Homzy,Dream Forever,Tempo Trax,Hard House
95501 TMP175,Base 22,Got House,Tempo Trax,Hard House Hard House TMP175,Base 22,Got House,Tempo Trax,Hard House
95546
95695 boski,legion,remix,mofo,hard,house,blade,born,ready boski,legion,remix,mofo,hard,house,blade,born,ready
95696 boski,Tara,N,remix,mofo,hard,house,blade,born,ready boski,Tara,N,remix,mofo,hard,house,blade,born,ready
95739 James Nardi, NRG, Hardhouse, Scorpion Trax James Nardi, NRG, Hardhouse, Scorpion Trax James Nardi, NRG, Hardhouse, Scorpion Trax