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 (
    59836, 59835, 59834, 59833, 59832, 59831, 
    59830, 59829, 59828, 59827, 59826, 
    59825, 59824, 59823, 59822, 59821, 
    59820, 59819, 59818, 59817, 59816, 
    59815, 59814, 59813, 59812, 59811, 
    59810, 59809
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00034

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
59809
59810
59811
59812
59813
59814
59815
59816
59817
59818
59819
59820
59821
59822
59823
59824
59825
59826
59827
59828
59829
59830
59831
59832
59833
59834
59835
59836