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 (
    73215, 73214, 73213, 73212, 73211, 73210, 
    73209, 73208, 73207, 73206, 73205, 
    73204, 73203, 73202, 73201, 73200, 
    73199, 73198, 73197, 73196, 73195
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00037

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

Result

product_id meta_keywords meta_description search_words promo_text
73195 CheekA38,Cheeky Tracks,Miss Detonate
73196 CheekA38,Cheeky Tracks,Groove Control,Gary O'Connor
73197 CheekA38,Cheeky Tracks,Jamie Tennant
73198 CheekA38,Cheeky Tracks,Brendan Ashley,Dave Owens,Vandalize
73199 CheekA38,Cheeky Tracks,Digital Mafia,Ben Warren
73200 CheekA38,Cheeky Tracks,DJ Saber
73201 CheekA38,Cheeky Tracks,Rick James,General Bounce
73202 CheekA38,Cheeky Tracks,Elivate,Rownz
73203 CheekA38,Cheeky Tracks,Griffiths,Dodd
73204 CheekA38,Cheeky Tracks,Rick James,Cat
73205 CheekA38,Cheeky Tracks,Rob Oakley,Rob Tissera
73206 CheekA38,Cheeky Tracks,James Valentine
73207 CheekA38,Cheeky Tracks,Griffiths & Dodd,Ben Kaye
73208 CheekA38,Cheeky Tracks,Matt Wade,Joe Swales
73209 CheekA38,Cheeky Tracks,Alan Sharkey
73210 CheekA38,Cheeky Tracks,Kirk P
73211 CheekA38,Cheeky Tracks,Leighton Smith,Jenni G
73212 CheekA38,Cheeky Tracks,Dale West
73213 CheekA38,Cheeky Tracks,Filthykitten,Random But Raw
73214 CheekA38,Cheeky Tracks,Drake Liddell
73215 CheekA38,Cheeky Tracks,Nikkdbubble