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 (
    77716, 77715, 77714, 77713, 77712, 77711, 
    77710, 77709, 77708, 77707, 77706, 
    77705, 77704, 77703, 77702, 77701, 
    77700, 77699, 77698, 77697, 77696, 
    77695, 77694, 77693, 77692, 77691, 
    77690, 77689
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00041

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

Result

product_id meta_keywords meta_description search_words promo_text
77689 HDCHVA003RRD,Hard Dance Coalition,Venkman
77690 HDCHVA003RRD,Hard Dance Coalition,Digital Mafia,Josh R U,Big Momma
77691 HDCHVA003RRD,Hard Dance Coalition,Hard Jeli
77692 HDCHVA003RRD,Hard Dance Coalition,Technikal,Max Mozart,Farisha,Ben Stevens
77693 HDCHVA003RRD,Hard Dance Coalition,Camp Collective
77694 HDCHVA003RRD,Hard Dance Coalition,Nicky Wilson
77695 HDCHVA003RRD,Hard Dance Coalition,Skol,Ben Stevens
77696 HDCHVA003RRD,Hard Dance Coalition,Dina Watson
77697 HDCHVA003RRD,Hard Dance Coalition,Lost Boys
77698 HDCHVA003RRD,Hard Dance Coalition,Skol,A vs B
77699 HDCHVA003RRD,Hard Dance Coalition,Jeff Payne,Jon BW
77700 HDCHVA003RRD,Hard Dance Coalition,Camp Collective
77701 HDCHVA003RRD,Hard Dance Coalition,Discam
77702 HDCHVA003RRD,Hard Dance Coalition,Wizard,Dave Owens
77703 HDCHVA003RRD,Hard Dance Coalition,Serotonin Soul
77704 HDCHVA003RRD,Hard Dance Coalition,Alf Graham
77705 HDCHVA003RRD,Hard Dance Coalition,Camp Collective
77706 HDCHVA003RRD,Hard Dance Coalition,Rick James
77707 HDCHVA003RRD,Hard Dance Coalition,Lil Rich,Matt Clarkson
77708 HDCHVA003RRD,Hard Dance Coalition,Alf Graham
77709 HDCHVA003RRD,Hard Dance Coalition,Camp Collective
77710 HDCHVA003RRD,Hard Dance Coalition,Venkman
77711 HDCHVA003RRD,Hard Dance Coalition,Hard Jeli
77712 HDCHVA003RRD,Hard Dance Coalition,Leighton Smith
77713 HDCHVA003RRD,Hard Dance Coalition,Justin Daniels,Ben Stevens
77714 HDCHVA003RRD,Hard Dance Coalition,Sean Inside Out,Tara Banks
77715 HDCHVA003RRD,Hard Dance Coalition,Hard Jeli
77716 HDCHVA003RRD,Hard Dance Coalition,Nailer