SELECT 
  companies.* 
FROM 
  cscart_companies AS companies 
WHERE 
  companies.company_id = 2

Query time 0.00029

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE companies const PRIMARY PRIMARY 4 const 1

Result

company_id status company lang_code address city state country zipcode email phone fax url storefront secure_storefront entry_page redirect_customer countries_list timestamp categories shippings logos commission commission_type request_user_id request_account_name request_account_data staff_notes
2 A byggbaY.se de www.byggbay.se www.byggbay.se none N SE,DK,NO,FI 1269610461 87,89,90,92,139 0.00 A 0