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 (
    104633, 104632, 104631, 104630, 104629, 
    104628, 104627, 104626, 104625, 104624, 
    104623, 104622, 104621, 104620, 104619, 
    104618, 104617, 104616, 104615, 104614
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00030

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
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
104633 Various Artists, Best Of 2019, Hard Dance Coalition, Hard House, Featured Compilations, Compilations, Toolbox Digital Download Best Of 2019 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