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 (
    43255, 43254, 43253, 43252, 43251, 43250, 
    43249, 42769, 42768, 42767, 42766, 
    42765, 42764, 42763, 42762, 42761, 
    42759, 42758, 42757, 42756
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00064

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
42756 LWHDS06,LW Recordings,Sergio Caubal,Isaac Sanchez
42757 NG Rezonance, PHD, DNA, LW Recordings, Original Mix, Hard Dance, Toolbox Digital Download DNA (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWHDS06,LW Recordings,NG Rezonance,PHD
42758 LWHDS06,LW Recordings,Attat
42759 Axamathic The Senthime, Desire, LW Recordings, Radio Mix, Hard Dance, Toolbox Digital Download Desire (Radio Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWHDS06,LW Recordings,Axamathic The Senthime
42761 Charlie Goddard, Kye Shand, Bulletproof, LW Recordings, Original Mix, Hard Dance, Toolbox Digital Download Bulletproof (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWHDS06,LW Recordings,Kye Shand,Charlie Goddard
42762 Unit 13, WAV Vibrations, LW Recordings, Original Mix, Hard Trance, Toolbox Digital Download WAV Vibrations (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWHDS06,LW Recordings,Unit 13
42763 LWHDS06,LW Recordings,One,Brivi,Rush Smith
42764 LWHDS06,LW Recordings,Shaun Wiliiams
42765 LWHDS06,LW Recordings,Abzolution
42766 LWHDS06,LW Recordings,Alex Tr
42767 LWHDS06,LW Recordings,DJ Ter
42768 Kris O'Rourke, Marc Johnson, 2 The Beat, LW Recordings, Original Mix, Hard House, Toolbox Digital Download 2 The Beat (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWHDS06,LW Recordings,Marc Johnson,Kris O'Rourke
42769 LWHDS06,LW Recordings
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