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 (
    44071, 44070, 44069, 44068, 44067, 44066, 
    44065, 44064, 44063, 44062, 44061, 
    44060, 44059, 44058, 44057, 44056, 
    44055, 44054, 44053, 44052, 44051, 
    44050, 44049, 44048, 44047
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00044

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
44047 LWWHAHC08,LW Recordings,S3RL,Minto
44048 LWWHAHC08,LW Recordings,Zekk
44049 LWWHAHC08,LW Recordings,Adam Frantic
44050 LWWHAHC08,LW Recordings,Bass Dealers
44051 LWWHAHC08,LW Recordings,Javi Tracker
44052 LWWHAHC08,LW Recordings,Mickey Rush
44053 LWWHAHC08,LW Recordings,Dj Kito
44054 LWWHAHC08,LW Recordings,Spesh,Area 51
44055 LWWHAHC08,LW Recordings,Ales
44056 LWWHAHC08,LW Recordings,DJ Ixidix
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