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 (
    44431, 44430, 44429, 44428, 44072, 44071, 
    44070, 44069, 44068, 44067, 44066, 
    44065, 44064, 44063, 44062, 44061, 
    44060, 44059, 44058, 44057
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00032

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
44057 LWWHAHC08,LW Recordings,Flexstyle
44058 LWWHAHC08,LW Recordings,Core-Key
44059 LWWHAHC08,LW Recordings,S3RL,Krystal
44060 LWWHAHC08,LW Recordings,M-Project,DJ Sharpnel
44061 LWWHAHC08,LW Recordings,Scott Brown
44062 LWWHAHC08,LW Recordings,Alex BassJunkie,Richie
44063 It-Man, Joey Riot, Ziyad, Little Bird, LW Recordings, Original Mix, Hardcore, Toolbox Digital Download Little Bird (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWWHAHC08,LW Recordings,Joey Riot,Ziyad,IT-Man
44064 LWWHAHC08,LW Recordings,Audio Stomperz
44065 LWWHAHC08,LW Recordings,Snipes & Ganah
44066 LWWHAHC08,LW Recordings,S3RL,Vau Boy
44067 LWWHAHC08,LW Recordings,Tatttttttt
44068 LWWHAHC08,LW Recordings,DJ Spesh
44069 LWWHAHC08,LW Recordings,Dj Sino
44070 LWWHAHC08,LW Recordings,JDM
44071 LWWHAHC08,LW Recordings,Javi Tracker
44072 LWWHAHC08,LW Recordings
44428 BK, Ilogik, Maddox & Townend, Real Life, LW Recordings, Maddox & Townend Remix, Hard House, Toolbox Digital Download Real Life (Maddox & Townend Remix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWEGHD14,LW Recordings,BK,Ilogik,Maddox & Townend
44429 LWEGHD14,LW Recordings,Rich Halpin
44430 LWEGHD14,LW Recordings,Faze2
44431 LWEGHD14,LW Recordings,Sergio Caubal,Mavy