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 (
    44451, 44450, 44449, 44448, 44447, 44446, 
    44445, 44444, 44443, 44442, 44441, 
    44440, 44439, 44438, 44437, 44436, 
    44435, 44434, 44433, 44432
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00032

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
44432 LWEGHD14,LW Recordings,UVL
44433 Andy Whitby, Energy Syndicate, Bring It, LW Recordings, Original Mix, Hard Dance, Toolbox Digital Download Bring It (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWEGHD14,LW Recordings,Andy Whitby,Energy Syndicate
44434 LWEGHD14,LW Recordings,DJ Arbrandt
44435 LWEGHD14,LW Recordings,BloodDropz!,DJ Benchuscoro
44436 Criostasis, Datraxx, Sunrise, LW Recordings, Criostasis Remix, Hard Trance, Toolbox Digital Download Sunrise (Criostasis Remix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWEGHD14,LW Recordings,Datraxx,Criostasis
44437 LWEGHD14,LW Recordings,Maniac G
44438 Adam M, Work It, LW Recordings, Original Mix, Hard House, Toolbox Digital Download Work It (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWEGHD14,LW Recordings,Adam M
44439 LWEGHD14,LW Recordings,Jamie M
44440 NG Rezonance, Singularity, LW Recordings, Original Mix, Hard Trance, Toolbox Digital Download Singularity (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWEGHD14,LW Recordings,NG Rezonance
44441 Nikkdbubble, Valex, Helichopter, LW Recordings, Nikkdbubble Remix, Hard Dance, Toolbox Digital Download Helichopter (Nikkdbubble Remix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWEGHD14,LW Recordings,Valex,Nikkdbubble
44442 LWEGHD14,LW Recordings,Irra Dj
44443 LWEGHD14,LW Recordings,Mike Steventon,Side E-Fect
44444 Valex, No More Hiding, LW Recordings, Original Mix, Hard Dance, Toolbox Digital Download No More Hiding (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWEGHD14,LW Recordings,Valex
44445 LWEGHD14,LW Recordings,DJ Arbrandt
44446 Adam M, Tenchy, Underbelly, LW Recordings, Original Mix, Hard Dance, Toolbox Digital Download Underbelly (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWEGHD14,LW Recordings,Adam M,Tenchy
44447 LWEGHD14,LW Recordings,DJ Benchuscoro
44448 Bangerz & Masherz, No Access, LW Recordings, Original Mix, Hard Dance, Toolbox Digital Download No Access (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWEGHD14,LW Recordings,Bangerz & Masherz
44449 LWEGHD14,LW Recordings,Connected
44450 Dynamic Audio, Hardforze, Zelda, LW Recordings, Original Mix, Hard Dance, Toolbox Digital Download Zelda (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWEGHD14,LW Recordings,Hardforze,Dynamic Audio
44451 LWEGHD14,LW Recordings,Scrabify