Sandbox

SELECT 
  company_descriptions.*, 
  companies.*, 
  cscart_vendor_plan_descriptions.plan, 
  cscart_seo_names.name as seo_name, 
  cscart_seo_names.path as seo_path 
FROM 
  cscart_companies AS companies 
  LEFT JOIN cscart_company_descriptions AS company_descriptions ON company_descriptions.company_id = companies.company_id 
  AND company_descriptions.lang_code = 'tr' 
  LEFT JOIN cscart_vendor_plan_descriptions ON companies.plan_id = cscart_vendor_plan_descriptions.plan_id 
  AND cscart_vendor_plan_descriptions.lang_code = 'tr' 
  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 3 
  AND cscart_seo_names.type = 'm' 
  AND cscart_seo_names.dispatch = '' 
  AND cscart_seo_names.lang_code = 'tr' 
WHERE 
  companies.company_id = 3

Query time 0.00084

Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	companies	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	company_descriptions	const	PRIMARY	PRIMARY	10	const,const	1
1	SIMPLE	cscart_vendor_plan_descriptions	const	PRIMARY	PRIMARY	10	const,const	1
1	SIMPLE	cscart_seo_names	ref	PRIMARY,dispatch	PRIMARY	206	const,const,const,const	1	Using where

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	plan	seo_name	seo_path
3	tr			A	Yedek Parça Pazar						magaza@yedekparcapazar.com					none	Y		1698830273	1		0			13667164994	N	N	N	4	1741660494	1741660547	1741660494	1698830273	0	Platinum	yedek-parca-pazar