Sandbox

SELECT 
  * 
FROM 
  cscart_users 
WHERE 
  `company_id` = '9572'

Query time 0.61748

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_users",
      "access_type": "ALL",
      "rows": 299995,
      "filtered": 100,
      "attached_condition": "cscart_users.company_id = '9572'"
    }
  }
}

Result

user_id	status	user_type	user_login	referer	is_root	company_id	subdomain	last_login	last_activity	timestamp	password	salt	firstname	lastname	company	email	phone	fax	url	tax_exempt	lang_code	birthday	purchase_timestamp_from	purchase_timestamp_to	responsible_email	password_change_timestamp	api_key	janrain_identifier	partner_id	card_number	valid_thru	card_holder_name	two_steps_auth_secret	remember_data	is_shopify	email_code	verify_email	c_state	c_country	zipcode	email_verification_otp	helpdesk_user_id	first_login_flag	downgrade_plan_status	is_card	plan_id	plan_status	payment_token	downgrade_plan_id	invest_terms_flag	is_subuser	passport_customer_id	is_vendor_subuser	main_vendor_user_id	referral_user_id
306762	A	V	user_306762		Y	9572		1718931404	1718931982	1718745529	$2y$10$m8tTetf8joPE/RLDYOfk..ut/X4nxmHGuZwEz4oWkqc8gTLrjSlYS		Van	Test	Van Test 0618	stgvan0618@yopmail.com	(639) 566-2482			N	en	0	0	0		1718745531			0						0							0	0			0				0	N		N	0	0