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 (
    42268, 42267, 42266, 42265, 42264, 42263, 
    42262, 42261, 42260, 42259, 42258, 
    42257, 42256, 42255, 42254, 42253, 
    42252, 42251, 42250, 42249
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00039

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
42249 LWWAHH15,LW Recordings,Ben Townsend
42250 LWWAHH15,LW Recordings,Ultranoize,Basic Pulse
42251 LWWAHH15,LW Recordings,Thomas Garnier
42252 LWWAHH15,LW Recordings,Ben Stevens,Lox,Leigh Green
42253 LWWAHH15,LW Recordings,Kinetic
42254 LWWAHH15,LW Recordings,Dan Diamond
42255 LWWAHH15,LW Recordings,Lewis Adam,Matt Mara
42256 LWWAHH15,LW Recordings,Speedo Killer
42257 LWWAHH15,LW Recordings,Gem Stone
42258 LWWAHH15,LW Recordings,Brainstomper
42259 LWWAHH15,LW Recordings,Mavrik
42260 LWWAHH15,LW Recordings,Sergio Caubal
42261 LWWAHH15,LW Recordings,Buzzed
42262 Mr Bishi, Venkman, (Tell Me) Toyboy, LW Recordings, Venkman Remix, Hard House, Toolbox Digital Download (Tell Me) Toyboy (Venkman Remix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWWAHH15,LW Recordings,Mr Bishi,Venkman
42263 LWWAHH15,LW Recordings,Steve McCone
42264 LWWAHH15,LW Recordings,Ben Townsend
42265 LWWAHH15,LW Recordings,Corran,Steve McCone
42266 LWWAHH15,LW Recordings,ReepR,Sam Crow
42267 LWWAHH15,LW Recordings,Kinetic
42268 LWWAHH15,LW Recordings,The Mungson