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 (
    103976, 103975, 103974, 103973, 103972, 
    103971, 103970, 103969, 103968, 103967, 
    103966, 103965, 103964, 103963, 103962, 
    103961, 103960, 103959, 103947, 103946
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00038

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
103946 RES004D,Tidy,Lee Haslam,Euphony
103947 RES004D,Tidy
103959 TIDYTVA01D,Tidy,Gaz West
103960 TIDYTVA01D,Tidy,Colin Barratt
103961 TIDYTVA01D,Tidy,K-Series
103962 TIDYTVA01D,Tidy,Wid & Ben
103963 TIDYTVA01D,Tidy,Nick Rowland
103964 TIDYTVA01D,Tidy,Caroline Banx
103965 TIDYTVA01D,Tidy,Anne Savage,Vinylgroover,The Red Hed
103966 TIDYTVA01D,Tidy,Colin Barratt
103967 TIDYTVA01D,Tidy,Nick Rafferty,The Coalition
103968 TIDYTVA01D,Tidy,Colin Barratt
103969 TIDYTVA01D,Tidy,Lee Haslam,Nick Sentience
103970 TIDYTVA01D,Tidy,Ed Real,The Coalition
103971 TIDYTVA01D,Tidy,NR2
103972 TIDYTVA01D,Tidy,Rob Tissera,Vinylgroover,The Red Hed
103973 TIDYTVA01D,Tidy,Barely Legal,Ingo
103974 TIDYTVA01D,Tidy,BK,Ed Real
103975 TIDYTVA01D,Tidy,Colin Barratt
103976 TIDYTVA01D,Tidy,Guyver