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

Query time 0.00023

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE companies system PRIMARY 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 shippings logos request_user_id request_account_name request_account_data
1 A Katanter OÜ ru Boston street Boston MA US 02125 simtech@example.com 555555555 +555555555 http://www.fish.ee fish.ee fish.ee none Y 1269610461 1 0