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 (
    59546, 59545, 59544, 59543, 59542, 59541, 
    59540, 59539, 59538, 59537, 59536, 
    59535, 59534, 59533, 59532, 59530, 
    59529, 59528, 59527, 59526
  ) 
  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 20 Using where

Result

product_id meta_keywords meta_description search_words promo_text
59526 Ben Stevens, The Warning, Fireball, Exclusive, Toolbox Digital Download The Warning by Fireball from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
59527 Ben Stevens, Super Groover, Fireball, Exclusive, Toolbox Digital Download Super Groover by Fireball from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
59528 Ben Stevens, Bryan Doyle, Marc Johnson, Chinook, Fireball, Marc Johnson Remix, Featured Hard House New, Hard House, Toolbox Digital Download Chinook (Marc Johnson Remix) by Fireball from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
59529 Steve Maynard, Slipped Disc, Fireball, Exclusive, Toolbox Digital Download Slipped Disc by Fireball from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
59530 Ben Stevens, Captain Tinrib, Dirty Mushroom, Fireball, Featured Hard House New, Hard House, Toolbox Digital Download Dirty Mushroom by Fireball from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
59532 Ben Stevens, Defective Audio, Radio Telescope, Fireball, Exclusive, Toolbox Digital Download Radio Telescope by Fireball from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
59533 Base Graffiti, Ben Stevens, Signal Jam, Fireball, Featured Hard House New, Hard House, Toolbox Digital Download Signal Jam by Fireball from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
59534 Ben Stevens, Frequency Response, Fireball, Exclusive, Toolbox Digital Download Frequency Response by Fireball from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
59535 Velos, The Joker, Fireball, Exclusive, Toolbox Digital Download The Joker by Fireball from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
59536 Ben Stevens, Damage, Narkotique, Better Watch Out, Fireball, Exclusive, Toolbox Digital Download Better Watch Out by Fireball from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
59537 James Devlin, Step Up, Fireball, Do Dat Dance, Exclusive, Toolbox Digital Download Step Up (Do Dat Dance) by Fireball from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
59538 Ben Stevens, Pwomp It Up, Fireball, Exclusive, Toolbox Digital Download Pwomp It Up by Fireball from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
59539 Morgan, Unstoppable, Fireball, Exclusive, Toolbox Digital Download Unstoppable by Fireball from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
59540 Jody 6, Japanese Robot Girl, Fireball, Exclusive, Toolbox Digital Download Japanese Robot Girl by Fireball from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
59541 Morgan, Take You Back, Fireball, Exclusive, Toolbox Digital Download Take You Back by Fireball from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
59542 Gaz Gibson, The Equaliser, Fireball, Exclusive, Toolbox Digital Download The Equaliser by Fireball from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
59543 Konekt, Resonate, Everyday, Fireball, Exclusive, Toolbox Digital Download Everyday by Fireball from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
59544 Adam M, Pickup & Rise, Something Like This, Fireball, Exclusive, Toolbox Digital Download Something Like This by Fireball from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
59545 Gary O'Connor, Go With The Flow, Fireball, Exclusive, Toolbox Digital Download Go With The Flow by Fireball from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
59546 Dr Device, Rodi Style, What Da Fuck, Fireball, Exclusive, Toolbox Digital Download What Da Fuck by Fireball from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.