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 (
    44874, 44873, 44872, 44871, 44870, 44869, 
    44868, 44866, 44865, 44864, 44863, 
    44862, 44861, 44860, 44859, 44858, 
    44857, 44856, 44453, 44452
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00031

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
44452 LWEGHD14,LW Recordings,BloodDropz!,RaymanRave
44453 LWEGHD14,LW Recordings
44856 Andy Whitby, Energy Syndicate, F*cked Up, LW Recordings, Original Mix, Hard Dance, Toolbox Digital Download F*cked Up (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWHDS08,LW Recordings,Andy Whitby,Energy Syndicate
44857 Venkman, Almost Famous, LW Recordings, Original Mix, Hard House, Toolbox Digital Download Almost Famous (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWHDS08,LW Recordings,Venkman
44858 Lee Walls, NG Rezonance, Pure Thrust, LW Recordings, NG Rezonance Remix, Hard Trance, Toolbox Digital Download Pure Thrust (NG Rezonance Remix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWHDS08,LW Recordings,Lee Walls,NG Rezonance
44859 LWHDS08,LW Recordings,Noizy Boy
44860 LWHDS08,LW Recordings,DJ Simpatic
44861 LWHDS08,LW Recordings,Dance Solution,Anne
44862 LWHDS08,LW Recordings,Gaz O'H
44863 LWHDS08,LW Recordings,BloodDropz!
44864 LWHDS08,LW Recordings,Scott Attrill,Mc Freestyle
44865 LWHDS08,LW Recordings,DJ eM
44866 LWHDS08,LW Recordings,Dark By Design,F8
44868 LWHDS08,LW Recordings,Luan
44869 LWHDS08,LW Recordings,Maniac G
44870 NG Rezonance, Memento, LW Recordings, Original Mix, Hard Trance, Toolbox Digital Download Memento (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWHDS08,LW Recordings,NG Rezonance
44871 Noizy Boy, Ultra Violence, Save Me, LW Recordings, Noizy Boy Remix, Hard Dance, Toolbox Digital Download Save Me (Noizy Boy Remix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWHDS08,LW Recordings,Ultra Violence,Noizy Boy
44872 Damo Cassetti, Shake Out, LW Recordings, Original Mix, Hard House, Toolbox Digital Download Shake Out (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWHDS08,LW Recordings,Damo Cassetti
44873 Forbidden Friends, Pears, LW Recordings, Original Mix, Hard Dance, Toolbox Digital Download Pears (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWHDS08,LW Recordings,Forbidden Friends
44874 LWHDS08,LW Recordings,Miky One,DJ Kino