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

Query time 0.00026

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

Result

category_id category description lang_code
180 MP3 Speaker Systems de
180 MP3 Speaker Systems en
180 MP3 Speaker Systems es
180 MP3 Speaker Systems fr
180 MP3 Speaker Systems ru
180 MP3 Speaker Systems uk