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 (
    73795, 73794, 73793, 73792, 73791, 73790, 
    73789, 73788, 73787, 73434, 73433, 
    73432, 73431, 73430, 73429, 73428, 
    73427, 73426, 73425, 73424
  ) 
  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
73424 LWHDA14,LW Recordings,Ganar
73425 LWHDA14,LW Recordings,Dina Watson,Si Stevens,Charlie Goddard
73426 LWHDA14,LW Recordings,Adyoro
73427 LWHDA14,LW Recordings,@Lex,Hagane Shizuka
73428 LWHDA14,LW Recordings,Ian Moi
73429 LWHDA14,LW Recordings,Doctor B,Groove Control,Nikki
73430 LWHDA14,LW Recordings,Deluxe Corporation,JJ
73431 LWHDA14,LW Recordings,DJ Bonny
73432 LWHDA14,LW Recordings,Clayfacer
73433 LWHDA14,LW Recordings,CJ Alexis
73434 LWHDA14,LW Recordings
73787 LWHTA15,LW Recordings,Sidney Werner
73788 LWHTA15,LW Recordings,Kill Them With Noise,Echoplex
73789 LWHTA15,LW Recordings,Valerio Panizio,2Bee
73790 LWHTA15,LW Recordings,Omega Drive
73791 LWHTA15,LW Recordings,DJ Ogi
73792 LWHTA15,LW Recordings,A.P.
73793 LWHTA15,LW Recordings,Michael Hunter
73794 LWHTA15,LW Recordings,^L_
73795 LWHTA15,LW Recordings,Cristian Glitch,Felix Bernhardt