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 (
    101808, 101807, 101806, 101805, 101804, 
    101803, 101802, 101801, 101800, 101799, 
    101798, 101797, 101796, 101795, 101794, 
    101793, 101792, 101791, 101790, 101789, 
    101788, 101787, 101786, 101785, 101784, 
    101783, 101782, 101781, 101780, 101779
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00137

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
101779 HDCHA005,Hard Dance Coalition,Base Graffiti
101780 HDCHA005,Hard Dance Coalition,Defective Audio
101781 HDCHA005,Hard Dance Coalition,Little Jon
101782 HDCHA005,Hard Dance Coalition,JP,Jukesy
101783 HDCHA005,Hard Dance Coalition,Phlash!,BK
101784 HDCHA005,Hard Dance Coalition,Wizard
101785 HDCHA005,Hard Dance Coalition,Karim
101786 HDCHA005,Hard Dance Coalition,Defective Audio,Paul Glazby
101787 HDCHA005,Hard Dance Coalition,Base Graffiti
101788 HDCHA005,Hard Dance Coalition,Masmada,Paul Glazby
101789 HDCHA005,Hard Dance Coalition,Daley,Adz,Alex Calver
101790 HDCHA005,Hard Dance Coalition,Gary Cooke,Frank Farrell
101791 HDCHA005,Hard Dance Coalition,Paul Glazby
101792 HDCHA005,Hard Dance Coalition,Leon Allen
101793 HDCHA005,Hard Dance Coalition,JoJo,Gary O'Connor
101794 HDCHA005,Hard Dance Coalition,12 Inch Thumpers,Paul Glazby
101795 HDCHA005,Hard Dance Coalition,Boca Byrne
101796 HDCHA005,Hard Dance Coalition,Henry Trotton
101797 HDCHA005,Hard Dance Coalition,Aaron James
101798 HDCHA005,Hard Dance Coalition,Gary Byrne
101799 HDCHA005,Hard Dance Coalition,Leon Allen
101800 HDCHA005,Hard Dance Coalition,Base Graffiti
101801 HDCHA005,Hard Dance Coalition,Karim
101802 HDCHA005,Hard Dance Coalition,The Pandemics
101803 HDCHA005,Hard Dance Coalition,Eufex,Jay B,Justin Bourne,Dynamic Intervention
101804 HDCHA005,Hard Dance Coalition,Unknown
101805 HDCHA005,Hard Dance Coalition,Unknown
101806 HDCHA005,Hard Dance Coalition,12 Inch Thumpers,Paul Glazby
101807 HDCHA005,Hard Dance Coalition,Adam M
101808 HDCHA005,Hard Dance Coalition,Paul Glazby,Adam M