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 (
    121273, 121272, 121271, 121270, 121269, 
    121268, 121267, 121266, 121265, 121264, 
    121263, 121262, 121261, 121260, 121259, 
    121258, 121257, 121256, 121255, 121254, 
    121253, 121252, 121251
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00044

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
121251 CheekA91,Cheeky Tracks,The HIIT Company,SubRush
121252 CheekA91,Cheeky Tracks,Catchy
121253 CheekA91,Cheeky Tracks,DJ Kambel
121254 CheekA91,Cheeky Tracks,Greedy DJs,The Punterz
121255 CheekA91,Cheeky Tracks,Kid Dynamo,Groove Control
121256 CheekA91,Cheeky Tracks,Starman,Italo Bounce
121257 CheekA91,Cheeky Tracks,Eezy Inc,Kelle,Catchy,Projekt B
121258 CheekA91,Cheeky Tracks,The R.Y.E
121259 CheekA91,Cheeky Tracks,Micky Modelle,Darren Glancy,Axel Gear
121260 CheekA91,Cheeky Tracks,KlubbHammer,ADF
121261 CheekA91,Cheeky Tracks,Catchy,Groove Control
121262 CheekA91,Cheeky Tracks,Scott Farrimond,Adelle
121263 CheekA91,Cheeky Tracks,Harry Hard,General Bounce,Tiffany Jackson,Initi8
121264 CheekA91,Cheeky Tracks,Jamie B
121265 CheekA91,Cheeky Tracks,Groove Control
121266 CheekA91,Cheeky Tracks,Luke DJ
121267 CheekA91,Cheeky Tracks,Scott Farrimond
121268 CheekA91,Cheeky Tracks,Steven Jay
121269 CheekA91,Cheeky Tracks,Charlie Bosh,Gem Harrison,Bounce Assassins
121270 CheekA91,Cheeky Tracks,Ashton,Scott Farrimond
121271 CheekA91,Cheeky Tracks,Groove Control,Hardy M
121272 CheekA91,Cheeky Tracks,Kelle
121273 CheekA91,Cheeky Tracks,Catchy,Scott Farrimond,Jodie Poye