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 (
    100147, 100146, 100145, 100000, 99981, 
    99977, 99976, 99975, 99974, 99961, 
    99926, 99925, 100304, 100253, 99999, 
    99998, 99997, 99897, 99896, 100294
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00055

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
99896 Cheek553A,Cheeky Tracks,Kritikal Mass
99897 Kritikal Mass, Iguana, Cheeky Tracks, Harder Mix, Featured Hard House New, Hard House, Toolbox Digital Download Iguana (Harder Mix) by Cheeky Tracks from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Cheek553A,Cheeky Tracks,Kritikal Mass
99925 LTR18,Lightning Trax,Ben Warren
99926 LTR18,Lightning Trax,Ben Warren
99961 NUROGL, Sambo, Make Your Bed, Beast Mode Recordings, Original Mix, Featured Hard House New, Hard House, Toolbox Digital Download Make Your Bed (Original Mix) by Beast Mode Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. BMR2211,Beast Mode Recordings,Sambo,NuroGL
99974 TIBUK013,This Is Bounce UK Music,Pokyeo FX
99975 TIBUK013,This Is Bounce UK Music,Pokyeo FX
99976 TIBUK013,This Is Bounce UK Music,Pokyeo FX
99977 TIBUK013,This Is Bounce UK Music,Pokyeo FX
99981 Nik Denton, Paul King, Spacehopper, Untidy, Nik Denton Remix, Featured Hard House New, Hard House, Toolbox Digital Download Spacehopper (Nik Denton Remix) by Untidy from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. UNTIDYUX006,Untidy,Nik Denton,Paul King
99997 Jodie, Party Never Hurt Nobody, Untidy, Original Mix, Featured Hard House New, Hard House, Toolbox Digital Download Party Never Hurt Nobody (Original Mix) by Untidy from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. UNTIDYT002,Untidy,Jodie
99998 Rawkus, 4 U, Untidy, Original Mix, Featured Hard House New, Hard House, Toolbox Digital Download 4 U (Original Mix) by Untidy from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. UNTIDYT002,Untidy,Rawkus
99999 Gary Whatley, Bring It Down, Untidy, Original Mix, Featured Hard House New, Hard House, Toolbox Digital Download Bring It Down (Original Mix) by Untidy from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. UNTIDYT002,Untidy,Gary Whatley
100000 BK, Paul Maddox, Tension, Tidy Trax, BK Remix - D6, Featured Hard House New, Hard House, Toolbox Digital Download Tension (BK Remix - D6) by Tidy Trax from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. TIDYD06,Tidy,Paul Maddox,BK
100145 Ali Wilson, Uno, Untidy, Original Mix, Featured Hard House New, Hard House, Toolbox Digital Download Uno (Original Mix) by Untidy from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. UNTIUDYTR001,Untidy,Ali Wilson
100146 UNTIUDYTR001,Untidy,Ali Wilson
100147 UNTIUDYTR001,Untidy,Ali Wilson,Andy Farley,Matt Smallwood
100253 Blend, The Sharp Boys, Rise Of Tonight, Sharp Digital Recordings, Sharp Boys London Riot Mix, Featured Hard House New, Hard House, Toolbox Digital Download Rise Of Tonight (Sharp Boys London Riot Mix) by Sharp Digital Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. SHARPD013,Sharp Digital Recordings,Blend,The Sharp Boys
100294 HDCSU004,Hard Dance Coalition,Captain Tinrib,Max Alien
100304 MR2 MR2 MR2