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 (
    119395, 119394, 119393, 119392, 119391, 
    119390, 119389, 119388, 119387, 119386, 
    119385, 119384, 119383, 119382, 119381, 
    119380, 119379, 119378, 119377, 119376, 
    119375, 119374, 119373
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00031

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
119373 TDV25TD,Tidy,Tony De Vit
119374 TDV25TD,Tidy,Tony De Vit
119375 TDV25TD,Tidy,Tony De Vit,Nikki Mac
119376 TDV25TD,Tidy,Tony De Vit
119377 TDV25TD,Tidy,Tony De Vit
119378 TDV25TD,Tidy,Tony De Vit
119379 TDV25TD,Tidy,Tony De Vit
119380 TDV25TD,Tidy,Tony De Vit
119381 TDV25TD,Tidy,Tony De Vit
119382 TDV25TD,Tidy,Tony De Vit
119383 TDV25TD,Tidy,Tony De Vit
119384 TDV25TD,Tidy,Tony De Vit
119385 TDV25TD,Tidy,Tony De Vit
119386 TDV25TD,Tidy,Tony De Vit,Nikki Mac,Eats Everything
119387 TDV25TD,Tidy,Tony De Vit,Nikki Mac,Morgan Seatree
119388 Airwolf Paradise, Tony De Vit, Get Loose, Tidy, Airwolf Paradise Extended Remix, Featured Hard House, Hard House, Toolbox Digital Download Get Loose (Airwolf Paradise Extended Remix) by Tidy from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. TDV25TD,Tidy,Tony De Vit,Airwolf Paradise
119389 TDV25TD,Tidy,Tony De Vit,Nicole Moudaber
119390 Hannah Laing, Tony De Vit, Bring The Beat Back, Tidy, Hannah Laing Extended Remix, Featured Hard House, Hard House, Toolbox Digital Download Bring The Beat Back (Hannah Laing Extended Remix) by Tidy from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. TDV25TD,Tidy,Tony De Vit,Hannah Laing
119391 Mark Sherry, Tony De Vit, The Dawn, Tidy, Mark Sherry Extended Remix, Hard Trance, Featured Hard Trance New, Toolbox Digital Download The Dawn (Mark Sherry Extended Remix) by Tidy from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. TDV25TD,Tidy,Tony De Vit,Mark Sherry
119392 TDV25TD,Tidy,Tony De Vit,Patrick Topping
119393 BK, Tony De Vit, Don't Ever Stop, Tidy, BK Extended Remix, Featured Hard House, Hard House, Toolbox Digital Download Don't Ever Stop (BK Extended Remix) by Tidy from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. TDV25TD,Tidy,Tony De Vit,BK
119394 TDV25TD,Tidy,Tony De Vit,Alan Fitzpatrick
119395 TDV25TD,Tidy,Tony De Vit,ABSOLUTE.