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 (
    66018, 66017, 66016, 66015, 66014, 66013, 
    66012, 66011, 66010, 66009, 66008, 
    66007, 66006, 66005, 66004, 66003, 
    66002, 66001, 66000, 65999, 65998, 
    65997, 65996, 65995, 65994
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00066

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 25 Using where

Result

product_id meta_keywords meta_description search_words promo_text
65994 LWHTA09,LW Recordings,Dr. Universe,Mr. Greidor
65995 LWHTA09,LW Recordings,Tommy Libera,Kevin Kranz
65996 LWHTA09,LW Recordings,80 DOPPEL D,Asparuh,Jared Pastore
65997 LWHTA09,LW Recordings,Hannes Matthiessen
65998 LWHTA09,LW Recordings,Tonikattitude,GSM
65999 LWHTA09,LW Recordings,Dr Cyanide
66000 LWHTA09,LW Recordings,Tech C
66001 LWHTA09,LW Recordings,Tito K.
66002 LWHTA09,LW Recordings,Da Mad Mixologist,Mark Cowax
66003 LWHTA09,LW Recordings,Tito K.
66004 LWHTA09,LW Recordings,Unaffected
66005 LWHTA09,LW Recordings,Sergy Casttle
66006 LWHTA09,LW Recordings,Resistohr
66007 LWHTA09,LW Recordings,DJ Deep Noise,Tito K.
66008 LWHTA09,LW Recordings,DJ Dextro,Cyberx
66009 LWHTA09,LW Recordings,Tito K.
66010 LWHTA09,LW Recordings,Mark Cowax,Tito K.
66011 LWHTA09,LW Recordings,Almir Ljusa
66012 LWHTA09,LW Recordings,Goncalo M
66013 LWHTA09,LW Recordings,Danyck
66014 LWHTA09,LW Recordings,Alen Milivojevic,Drzneday
66015 LWHTA09,LW Recordings,DJ Deep Noise,Tito K.
66016 LWHTA09,LW Recordings,Pablo Caballero
66017 LWHTA09,LW Recordings,Sebastian Groth,Patrick DSP
66018 LWHTA09,LW Recordings,Shadym