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 (
    43273, 43272, 43271, 43270, 43269, 43268, 
    43267, 43266, 43265, 43264, 43263, 
    43262, 43261, 43260, 43259, 43258, 
    43257, 43256, 43255, 43254, 43253, 
    43252, 43251, 43250, 43249
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00126

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
43249 LWWHAHC07,LW Recordings,Abel Effect
43250 LWWHAHC07,LW Recordings,B-Man,Gisbo,Jodie
43251 LWWHAHC07,LW Recordings,Javiolo
43252 LWWHAHC07,LW Recordings,Interface,The Saint,MC Tha Watcher
43253 LWWHAHC07,LW Recordings,M-Project,MC Steal
43254 LWWHAHC07,LW Recordings,Jakka-B
43255 LWWHAHC07,LW Recordings,Audio Stomperz
43256 LWWHAHC07,LW Recordings,Tatttttttt,DJ 490
43257 LWWHAHC07,LW Recordings,Alex BassJunkie
43258 LWWHAHC07,LW Recordings,Jordi K-Stana,V-Nax
43259 LWWHAHC07,LW Recordings,Javi Tracker
43260 LWWHAHC07,LW Recordings,Dj Metix
43261 LWWHAHC07,LW Recordings,Dirty Harry,KT-W,Clowny
43262 LWWHAHC07,LW Recordings,Area 51
43263 LWWHAHC07,LW Recordings,Just Jack,Kane
43264 DJ DFX, Darwin, Genetix, LW Recordings, Original Mix, Hardcore, Toolbox Digital Download Genetix (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWWHAHC07,LW Recordings,Darwin,DJ DFX
43265 LWWHAHC07,LW Recordings,Zatox,Art Of Fighters
43266 LWWHAHC07,LW Recordings,Scott Brown
43267 LWWHAHC07,LW Recordings,DJ DFX
43268 LWWHAHC07,LW Recordings,Area 51
43269 LWWHAHC07,LW Recordings,Lozzie
43270 LWWHAHC07,LW Recordings,UniqForm,S.I.D.R
43271 LWWHAHC07,LW Recordings,Bananaman,Gisbo,Gemma Macleod
43272 LWWHAHC07,LW Recordings,Doug Horizon,Chris Ross
43273 LWWHAHC07,LW Recordings,Dj Krus