SELECT 
  cscart_product_descriptions.product_id, 
  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 (
    105210, 105209, 105250, 105249, 105248, 
    105247, 105246, 105245, 105244, 105243, 
    105242, 105241, 105240, 105208, 105207, 
    105206, 105205, 105204, 105203, 105202
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00037

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 meta_keywords meta_description search_words promo_text
105202 TW10CD2D,Tidy,Andy Farley
105203 TW10CD2D,Tidy,Marc Johnson,Nik Denton
105204 TW10CD2D,Tidy,Trauma,Ian M
105205 TW10CD2D,Tidy,Defective Audio
105206 TW10CD2D,Tidy,Tony De Vit
105207 TW10CD2D,Tidy,Riggsy,Steve-NRG
105208 TW10CD2D,Tidy
105209 TIDYW11LAD,Tidy,Andy Farley,Nick Sentience
105210 TIDYW11LAD,Tidy,BK,Nick Sentience
105240 TW10CD3D,Tidy,Defective Audio
105241 TW10CD3D,Tidy,Steve Maynard,WMD
105242 TW10CD3D,Tidy,Andy Farley
105243 TW10CD3D,Tidy,Karl Davis,WMD,Captain Tinrib
105244 TW10CD3D,Tidy,Munkjack
105245 TW10CD3D,Tidy,RR Fierce
105246 TW10CD3D,Tidy,Steve Maynard,WMD
105247 TW10CD3D,Tidy,DJ Opel,WMD
105248 TW10CD3D,Tidy,Defective Audio
105249 TW10CD3D,Tidy,Hyperlogic,Stimulant DJ's
105250 TW10CD3D,Tidy