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 (
    78060, 78059, 78058, 78057, 78056, 78055, 
    77717, 77716, 77715, 77714, 77713, 
    77712, 77711, 77710, 77709, 77708, 
    77707, 77706, 77705, 77704
  ) 
  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
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
77717 HDCHVA003RRD,Hard Dance Coalition
78055 HDCWS002RR,Hard Dance Coalition,Norgzki
78056 HDCWS002RR,Hard Dance Coalition,Shaun Williams,Oliver Marks
78057 HDCWS002RR,Hard Dance Coalition,Dark by Design
78058 HDCWS002RR,Hard Dance Coalition,Cut-Up
78059 HDCWS002RR,Hard Dance Coalition,Sonik,Digital Mafia
78060 HDCWS002RR,Hard Dance Coalition,Andy Whitby