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 (
    66092, 66091, 66090, 66089, 66088, 66087, 
    66086, 66085, 66084, 66083, 66082, 
    66081, 66080, 66079, 66078, 66077, 
    66076, 66075, 66074, 66073, 66072, 
    66071, 66070, 66069, 66068, 66067, 
    66066, 66065, 66064, 66063
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00057

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
66063 HDCHA003,Hard Dance Coalition,Perfect Poise
66064 HDCHA003,Hard Dance Coalition,Wayne Smart
66065 HDCHA003,Hard Dance Coalition,JoJo,Mumbles
66066 HDCHA003,Hard Dance Coalition,Valex
66067 HDCHA003,Hard Dance Coalition,Base Graffiti
66068 HDCHA003,Hard Dance Coalition,Leon Allen
66069 HDCHA003,Hard Dance Coalition,Mumbles,DJ Tony K
66070 HDCHA003,Hard Dance Coalition,Ben Stevens
66071 HDCHA003,Hard Dance Coalition,Defective Audio
66072 HDCHA003,Hard Dance Coalition,Paul Glazby,Hilly
66073 HDCHA003,Hard Dance Coalition,RR Fierce
66074 HDCHA003,Hard Dance Coalition,Mischief Duo
66075 HDCHA003,Hard Dance Coalition,Aaron James,Matt Mara
66076 HDCHA003,Hard Dance Coalition,Mike Taylor,Aaron Langstaff
66077 HDCHA003,Hard Dance Coalition,Ben Stevens,Adam M,Dave Neale
66078 HDCHA003,Hard Dance Coalition,OD404
66079 HDCHA003,Hard Dance Coalition,Muzz,Big Noddy,Wayne Smart
66080 HDCHA003,Hard Dance Coalition,Technikal,Discam
66081 HDCHA003,Hard Dance Coalition,Sam Townend,Klubfiller,BK
66082 HDCHA003,Hard Dance Coalition,Mumbles
66083 HDCHA003,Hard Dance Coalition,BK,Adam M
66084 HDCHA003,Hard Dance Coalition,Defective Audio
66085 HDCHA003,Hard Dance Coalition,Forbidden Friends
66086 HDCHA003,Hard Dance Coalition,F1,Ben Stevens
66087 HDCHA003,Hard Dance Coalition,Base Graffiti,Lucy Fur
66088 HDCHA003,Hard Dance Coalition,Wayne German
66089 HDCHA003,Hard Dance Coalition,RR Fierce
66090 HDCHA003,Hard Dance Coalition,Boca Byrne
66091 HDCHA003,Hard Dance Coalition,Defective Audio
66092 HDCHA003,Hard Dance Coalition,Andy Farley,Valex,Grady G