SELECT 
  * 
FROM 
  cscart_companies 
WHERE 
  company_id = '9565'

Query time 0.00047

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_companies",
      "access_type": "const",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "4",
      "used_key_parts": ["company_id"],
      "ref": ["const"],
      "rows": 1,
      "filtered": 100
    }
  }
}

Result

company_id status company lang_code address city state country zipcode email phone url storefront secure_storefront entry_page redirect_customer countries_list timestamp shippings logos request_user_id request_account_name request_account_data pre_moderation pre_moderation_edit pre_moderation_edit_vendors plan_id suspend_date grace_period_start last_time_suspended last_debt_notification_time paypal_commerce_platform_account_id stripe_connect_account_id paypal_email paypal_base_for_commission paypal_verification ppa_first_name ppa_last_name verify allow_create_payment digitzs_connect_account_id plan_status payment_token downgrade_plan_id password affiliate_merchant affiliate_product_count search_terms shopify_api_key shopify_api_token shopify_store_url vendor_type tax_number stripe_connect_account_type allow_vendor_shopping_option allow_anonymous_shopping_vendor show_products passport_external_id passport_customer_id passport_account_id passport_merchant_id is_lpo
9565 A Van Test Stg 0605 en 11968 stgvantest0605@yopmail.com (639) 566-2482 test.com none Y 0 48 0 a:4:{s:14:"company_fields";a:3:{i:37;s:3:"Van";i:38;s:4:"Test";s:8:"password";s:10:"Qwerty123!";}s:15:"admin_firstname";s:3:"Van";s:14:"admin_lastname";s:4:"Test";s:6:"fields";a:0:{}} N N N 6 0 0 0 0 not_checked 0 N 4001562 aafe06e46da6f8158e7a90926b1b7a84 0 7668776876 0 1 Y 4722040 4012119 4001562