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 = 'en' 
  LEFT JOIN cscart_vendor_plans p ON p.plan_id = cscart_companies.plan_id 
WHERE 
  cscart_companies.company_id IN('662') 
ORDER BY 
  cscart_companies.company_id asc 
LIMIT 
  0, 1

Query time 0.00071

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "1.00"
    },
    "ordering_operation": {
      "using_filesort": false,
      "nested_loop": [
        {
          "table": {
            "table_name": "cscart_companies",
            "access_type": "const",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "company_id"
            ],
            "key_length": "4",
            "ref": [
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 1,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.00",
              "eval_cost": "0.20",
              "prefix_cost": "0.00",
              "data_read_per_join": "9K"
            },
            "used_columns": [
              "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",
              "sd_vendor_helper",
              "identifier_facebook_pixel",
              "stripe_connect_account_id",
              "tax_number",
              "facebook_pixel_id",
              "facebook_api_token",
              "handling_time_us",
              "handling_time_uk",
              "handling_time_it",
              "handling_time_in",
              "handling_time_mx",
              "handling_time_es",
              "handling_time_de",
              "handling_time_fr",
              "handling_time_cn",
              "handling_time_ca",
              "handling_time_jp",
              "handling_time",
              "blocked_date",
              "booking_data",
              "stripe_connect_account_type",
              "registered_from_storefront_id",
              "ec_rfq_whatsapp_number",
              "ec_rfq_phone_number",
              "ec_rfq_bhf",
              "ec_rfq_bht",
              "sd_ga_tracking_code",
              "sd_ga_api_secret"
            ]
          }
        },
        {
          "table": {
            "table_name": "cscart_company_descriptions",
            "access_type": "const",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "company_id",
              "lang_code"
            ],
            "key_length": "10",
            "ref": [
              "const",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 1,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.00",
              "eval_cost": "0.20",
              "prefix_cost": "0.00",
              "data_read_per_join": "3K"
            },
            "used_columns": [
              "company_id",
              "lang_code",
              "company_description",
              "terms",
              "meta_keywords",
              "meta_description",
              "page_title",
              "i18n_company",
              "i18n_address",
              "i18n_city"
            ]
          }
        },
        {
          "table": {
            "table_name": "p",
            "access_type": "const",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "plan_id"
            ],
            "key_length": "4",
            "ref": [
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 1,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.00",
              "eval_cost": "0.20",
              "prefix_cost": "0.00",
              "data_read_per_join": "80"
            },
            "used_columns": [
              "plan_id",
              "price",
              "periodicity",
              "commission",
              "products_limit",
              "revenue_limit",
              "vendor_store",
              "categories",
              "storefronts"
            ]
          }
        }
      ]
    }
  }
}

Result

company_id	lang_code	company_description	terms	meta_keywords	meta_description	page_title	i18n_company	i18n_address	i18n_city	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	pre_moderation	pre_moderation_edit	pre_moderation_edit_vendors	plan_id	sd_vendor_helper	identifier_facebook_pixel	stripe_connect_account_id	tax_number	facebook_pixel_id	facebook_api_token	handling_time_us	handling_time_uk	handling_time_it	handling_time_in	handling_time_mx	handling_time_es	handling_time_de	handling_time_fr	handling_time_cn	handling_time_ca	handling_time_jp	handling_time	blocked_date	booking_data	stripe_connect_account_type	registered_from_storefront_id	ec_rfq_whatsapp_number	ec_rfq_phone_number	ec_rfq_bhf	ec_rfq_bht	sd_ga_tracking_code	sd_ga_api_secret	price	periodicity	commission	products_limit	revenue_limit	vendor_store	categories	storefronts
662	sq	<p>FXH SARAÇI SHPK has been operating in the market for more than 20 years.</p> <p>FXH SARAÇI SHPK is engaged in the sale of new agricultural machinery used as well as spare parts with these machines. The products are all Italian and guaranteed</p> <p></p>		pjesë kembimi, bujqësi, të reja, të perdorura. cilësi, italiane, servis, makineri, blegtori, fshat, qytet, makina, motorra, ,korrëse bari, pjesë, piston, kambje, vaj motorri, ingranzh, freksion, termostat	FXH SARACI SHPK has been operating in the market for more than 20 years. FX SARACI SHPK sells new agricultural machinery and used ones.	FXH SARACI SHPK	Makineri Bujqesore Fredi	Kercukaj, 12 Rrogozhinë, 2508, Rrogozhinë Albani	Rrogozhinë	A	Makineri Bujqesore Fredi	Kercukaj, 12 Rrogozhinë, 2508, Rrogozhinë Albani	Rrogozhinë	53	AL	2508	fxhsaraci@gmail.com	+355692096403	https://makineribujqesorefredi.com/?			none	Y		1673253761	129,100,98,10,9,77,44,19,12,43,48,49,78,96,97,38,45,46,47,40,39,17,42,11,23,24,116,86,85,84,83,82,81,80		0			N	N	N	14	282869688						0	0	0	0	0	0	0	0	0	0	0	0											0.00	month	20.00	0	0.00	1