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 (
    104632, 104631, 104630, 104629, 104628, 
    104627, 104626, 104625, 104624, 104623, 
    104622, 104621, 104620, 104619, 104618, 
    104617, 104616, 104615, 104614, 104613, 
    104612, 104611, 104610, 104609, 104608, 
    104607, 104606, 104605, 104604, 104603
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00042

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 30 Using where

Result

product_id meta_keywords meta_description search_words promo_text
104603 HDCB19,Hard Dance Coalition,Ross Homson
104604 HDCB19,Hard Dance Coalition,Agent Jack,The Sneaky Ninja
104605 HDCB19,Hard Dance Coalition,Ross Homson
104606 HDCB19,Hard Dance Coalition,Agent Jack,The Sneaky Ninja
104607 HDCB19,Hard Dance Coalition,Ross Homson
104608 Agent Jack, Illuminatae, Hard Dance Coalition, Original Mix, Featured Hard House New, Hard House, Toolbox Digital Download Illuminatae (Original Mix) by Hard Dance Coalition from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. HDCB19,Hard Dance Coalition,Agent Jack
104609 HDCB19,Hard Dance Coalition,Ross Homson,Ben Stevens
104610 HDCB19,Hard Dance Coalition,Andy Farley,Craig Jones,Paul King
104611 HDCB19,Hard Dance Coalition,Andy Farley,Steve Tremlett
104612 HDCB19,Hard Dance Coalition,Danny Clark
104613 K8-e, Paul King, My Kind Of Company, Hard Dance Coalition, Paul King Remix, Featured Hard House New, Hard House, Toolbox Digital Download My Kind Of Company (Paul King Remix) by Hard Dance Coalition from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. HDCB19,Hard Dance Coalition,K8-e,Paul King
104614 HDCB19,Hard Dance Coalition,GSR,Matt Clarkson
104615 HDCB19,Hard Dance Coalition,Team Sly
104616 HDCB19,Hard Dance Coalition,Matt Clarkson,Team Sly,Feat=Sam Sly
104617 HDCB19,Hard Dance Coalition,Team Sly
104618 HDCB19,Hard Dance Coalition,Paul King,K8-e
104619 HDCB19,Hard Dance Coalition,Unit DVSN
104620 HDCB19,Hard Dance Coalition,Matt Clarkson,Miric
104621 HDCB19,Hard Dance Coalition,Equinox,Adam M
104622 HDCB19,Hard Dance Coalition,Paul Glazby
104623 HDCB19,Hard Dance Coalition,Tom Parr,Kev Pickford
104624 HDCB19,Hard Dance Coalition,Frank Farrell,Ben Stevens
104625 HDCB19,Hard Dance Coalition,Adam Butler
104626 HDCB19,Hard Dance Coalition,Kaki Raphael
104627 HDCB19,Hard Dance Coalition,RAM
104628 HDCB19,Hard Dance Coalition,Kaki Raphael
104629 HDCB19,Hard Dance Coalition,Paul Glazby,Wayne German
104630 HDCB19,Hard Dance Coalition,Kaki Raphael
104631 HDCB19,Hard Dance Coalition,Paul Glazby,Scallywags
104632 HDCB19,Hard Dance Coalition,Ben Stevens,Abandon,Random But Raw