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 (
    65926, 65925, 65924, 65923, 65922, 65921, 
    65920, 65919, 65918, 65917, 65916, 
    65915, 65914, 65913, 65912, 65911, 
    65910, 65909, 65908, 65907, 65906, 
    65905, 65904, 65903, 65902, 65901, 
    65900, 65899, 65898, 65897
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00043

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

Result

product_id meta_keywords meta_description search_words promo_text
65897 Ben Stevens, Rodi Style, U Got 2 Know, Hard Dance Coalition, Original Mix, Featured Hard House New, Hard House, Toolbox Digital Download U Got 2 Know (Original Mix) by Hard Dance Coalition from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. DCHVA004,Hard Dance Coalition,Ben Stevens,Rodi Style
65898 DCHVA004,Hard Dance Coalition,Alf Graham
65899 DCHVA004,Hard Dance Coalition,Bulletproof,Ilogik
65900 DCHVA004,Hard Dance Coalition,Sean Inside Out .& Tom Parr
65901 DCHVA004,Hard Dance Coalition,Discam
65902 DCHVA004,Hard Dance Coalition,Brendan Ashley,Dave Owens
65903 DCHVA004,Hard Dance Coalition,Rattez,Ben Stevens
65904 DCHVA004,Hard Dance Coalition,Hard Jeli
65905 DCHVA004,Hard Dance Coalition,Leighton Smith
65906 DCHVA004,Hard Dance Coalition,Rattez,Ben Stevens
65907 DCHVA004,Hard Dance Coalition,Chucky
65908 DCHVA004,Hard Dance Coalition,Hard Jeli
65909 DCHVA004,Hard Dance Coalition,Leighton Smith
65910 DCHVA004,Hard Dance Coalition,Fabio Seramota,Joe 90
65911 Alf Graham, Waiting For, Hard Dance Coalition, Original Mix, Featured Hard House New, Hard House, Toolbox Digital Download Waiting For (Original Mix) by Hard Dance Coalition from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. DCHVA004,Hard Dance Coalition,Alf Graham
65912 DCHVA004,Hard Dance Coalition,Sam & Deano
65913 DCHVA004,Hard Dance Coalition,Ben Stevens,Paul Maddox
65914 DCHVA004,Hard Dance Coalition,Lee Pasch,Technikal
65915 DCHVA004,Hard Dance Coalition,Leighton Smith
65916 DCHVA004,Hard Dance Coalition,Miss Behavin,The Freak Brothers
65917 DCHVA004,Hard Dance Coalition,Discam,Dave Owens
65918 DCHVA004,Hard Dance Coalition,Alf Graham
65919 DCHVA004,Hard Dance Coalition,Valex
65920 DCHVA004,Hard Dance Coalition,Elle
65921 DCHVA004,Hard Dance Coalition,Rattez,Ben Stevens
65922 DCHVA004,Hard Dance Coalition,Leighton Smith
65923 DCHVA004,Hard Dance Coalition,Banks,Taylor
65924 Leighton Smith, Out Of The Blues, Hard Dance Coalition, Original Mix, Featured Hard House New, Hard House, Toolbox Digital Download Out Of The Blues (Original Mix) by Hard Dance Coalition from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. DCHVA004,Hard Dance Coalition,Leighton Smith
65925 DCHVA004,Hard Dance Coalition,Alf Graham
65926 DCHVA004,Hard Dance Coalition,Leighton Smith