Sandbox

SELECT 
  cscart_company_descriptions.*, 
  cscart_companies.*, 
  p.price, 
  p.periodicity, 
  p.commission, 
  p.products_limit, 
  p.revenue_limit, 
  p.vendor_store, 
  p.categories, 
  p.storefronts 
FROM 
  cscart_companies 
  LEFT JOIN cscart_company_descriptions ON cscart_company_descriptions.company_id = cscart_companies.company_id 
  AND cscart_company_descriptions.lang_code = 'tr' 
  LEFT JOIN cscart_vendor_plans p ON p.plan_id = cscart_companies.plan_id 
WHERE 
  cscart_companies.company_id IN('4') 
ORDER BY 
  cscart_companies.company_id asc 
LIMIT 
  0, 1

Query time 0.00019

Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows
1	SIMPLE	cscart_companies	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	cscart_company_descriptions	const	PRIMARY	PRIMARY	10	const,const	1
1	SIMPLE	p	const	PRIMARY	PRIMARY	4	const	1

Result

company_id	lang_code	company_description	terms	status	company	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	tax_number	pre_moderation	pre_moderation_edit	pre_moderation_edit_vendors	plan_id	suspend_date	grace_period_start	last_time_suspended	last_debt_notification_time	tenant_id	price	periodicity	commission	products_limit	revenue_limit	vendor_store	categories	storefronts
4	tr			S	HMC Parça						hmc@hobilife.com					none	Y		1698890375			0				N	N	N	4	1741660494	1738448500	1741660494	1698890375	0	0.00	onetime	10.00	100000	0.00	1