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 (
    66199, 66198, 66197, 66196, 66195, 66194, 
    66193, 66192, 66191, 66190, 66189, 
    66188, 66187, 66186, 66185, 66184, 
    66183, 66182, 66019, 66018
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00041

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
66018 LWHTA09,LW Recordings,Shadym
66019 LWHTA09,LW Recordings
66182 LWEGHH15,LW Recordings,Kid Rich,Random But Raw,Frank Farrell
66183 LWEGHH15,LW Recordings,Kris O'Rourke
66184 LWEGHH15,LW Recordings,Danny Gilligan
66185 LWEGHH15,LW Recordings,Mavrik
66186 LWEGHH15,LW Recordings,Joe Longbottom
66187 LWEGHH15,LW Recordings,Hilly
66188 LWEGHH15,LW Recordings,Little Miss Natalie,The Testube Babies
66189 LWEGHH15,LW Recordings,Lee Mills
66190 LWEGHH15,LW Recordings,Bowie666
66191 LWEGHH15,LW Recordings,Irra DJ,DJ Moix
66192 LWEGHH15,LW Recordings,Insidious
66193 LWEGHH15,LW Recordings,Gaz F,Ben Stevens
66194 LWEGHH15,LW Recordings,Cupra,Matt Clarkson
66195 LWEGHH15,LW Recordings,Baz Coleman
66196 LWEGHH15,LW Recordings,Sergio Caubal
66197 LWEGHH15,LW Recordings,DJ Nillos
66198 LWEGHH15,LW Recordings,Cally Gage,Audox
66199 LWEGHH15,LW Recordings,LeeRoy