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 (
    45646, 45645, 45644, 45643, 45642, 45641, 
    45640, 45240, 45239, 45238, 45237, 
    45236, 45235, 45234, 45233, 45232, 
    45231, 45230, 45229, 45228
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00035

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
45228 LWWHAHC09,LW Recordings,Haze
45229 LWWHAHC09,LW Recordings,Scott Brown,Al Storm
45230 LWWHAHC09,LW Recordings,Phat Boyz
45231 LWWHAHC09,LW Recordings,Miss Special K,Dionne
45232 LWWHAHC09,LW Recordings,Noize
45233 LWWHAHC09,LW Recordings,Anon
45234 LWWHAHC09,LW Recordings,Jordi K-Stana,V-Nax
45235 LWWHAHC09,LW Recordings,Hyperforce,IYF,Deanne
45236 LWWHAHC09,LW Recordings,Para Italia
45237 LWWHAHC09,LW Recordings,M-Style
45238 Joey Riot, Kris Kinetic, Walking On The Moon, LW Recordings, Original Mix, Hardcore, Toolbox Digital Download Walking On The Moon (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWWHAHC09,LW Recordings,Joey Riot,Kris Kinetic
45239 LWWHAHC09,LW Recordings,Sc@r
45240 LWWHAHC09,LW Recordings
45640 LWEGHD15,LW Recordings,Scott Attrill
45641 NG Rezonance, Trance-Pennine Express, Don't Tell Me, LW Recordings, NG Rezonance Remix, Hard Trance, Toolbox Digital Download Don't Tell Me (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. LWEGHD15,LW Recordings,Trance-Pennine Express,NG Rezonance
45642 LWEGHD15,LW Recordings,Merz
45643 DBS, GHDA, Hardforze, Origins, LW Recordings, GHDA Remix, Hard Dance, Toolbox Digital Download Origins (GHDA Remix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWEGHD15,LW Recordings,Hardforze,DBS,GHDA
45644 LWEGHD15,LW Recordings,Audio Hedz,Alex Burn,Technikal
45645 Perfect Poise, Ultimate Adventure, LW Recordings, Original Mix, Hard Dance, Toolbox Digital Download Ultimate Adventure (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWEGHD15,LW Recordings,Perfect Poise
45646 F2, F2, LW Recordings, Original Mix, Hard Dance, Toolbox Digital Download F2 (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWEGHD15,LW Recordings,F2