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 (
    125018, 125017, 125016, 125015, 125014, 
    125013, 125012, 125011, 125010, 125009, 
    125008, 125007, 125006, 125005, 125004, 
    125003, 125002, 125001, 125000, 124999, 
    124998, 124997, 124996
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00040

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

Result

product_id meta_keywords meta_description search_words promo_text
124996 CheekA97,Cheeky Tracks,G.W.R.
124997 CheekA97,Cheeky Tracks,Base 22,Groove Control
124998 CheekA97,Cheeky Tracks,Ross Homson
124999 CheekA97,Cheeky Tracks,Ste Willo
125000 CheekA97,Cheeky Tracks,The HIIT Company,SubRush
125001 CheekA97,Cheeky Tracks,Ross Homson
125002 CheekA97,Cheeky Tracks,Kid Dynamo
125003 CheekA97,Cheeky Tracks,G.W.R.,Christiana
125004 CheekA97,Cheeky Tracks,Charlie Bosh,Bethany
125005 CheekA97,Cheeky Tracks,Yusef Kifah,Luke DJ
125006 CheekA97,Cheeky Tracks,Mobi D
125007 CheekA97,Cheeky Tracks,Jamie B
125008 CheekA97,Cheeky Tracks,Coccium,Luke DJ
125009 CheekA97,Cheeky Tracks,Smokey
125010 CheekA97,Cheeky Tracks,Vinyl Vandal,Starman,Nikki,Groove Control
125011 CheekA97,Cheeky Tracks,FNKTION II,Kelle
125012 CheekA97,Cheeky Tracks,Catchy
125013 CheekA97,Cheeky Tracks,Steven Jay
125014 CheekA97,Cheeky Tracks,Starman,Italo Bounce
125015 CheekA97,Cheeky Tracks,Ry'N T
125016 CheekA97,Cheeky Tracks,Eezy Inc,Kelle
125017 CheekA97,Cheeky Tracks,Digital Mafia,Justin Daniels,Jamie R
125018 CheekA97,Cheeky Tracks,Matt Alliss