SELECT 
  category_id, 
  category, 
  description, 
  lang_code 
FROM 
  cscart_category_descriptions 
WHERE 
  category_id = 244

Query time 0.00027

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_category_descriptions ref PRIMARY PRIMARY 3 const 6

Result

category_id category description lang_code
244 TV Shows (DVD) de
244 TV Shows (DVD) en
244 TV Shows (DVD) es
244 TV Shows (DVD) fr
244 TV Shows (DVD) ru
244 TV Shows (DVD) uk