SELECT 
  company_descriptions.*, 
  companies.*, 
  p.price, 
  p.periodicity, 
  p.commission, 
  p.products_limit, 
  p.revenue_limit, 
  p.vendor_store, 
  p.categories, 
  p.storefronts 
FROM 
  companies 
  LEFT JOIN company_descriptions ON company_descriptions.company_id = companies.company_id 
  AND company_descriptions.lang_code = 'en' 
  LEFT JOIN vendor_plans p ON p.plan_id = companies.plan_id 
WHERE 
  companies.company_id IN('7918') 
ORDER BY 
  companies.company_id asc 
LIMIT 
  0, 1

Query time 0.00142

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "1.00"
    },
    "ordering_operation": {
      "using_filesort": false,
      "nested_loop": [
        {
          "table": {
            "table_name": "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.10",
              "prefix_cost": "0.00",
              "data_read_per_join": "14K"
            },
            "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",
              "plan_id",
              "stripe_connect_account_id",
              "identifier_facebook_pixel",
              "featured_products",
              "sd_ga_tracking_code",
              "paypal_commerce_platform_account_id",
              "tagline",
              "url_facebook",
              "url_instagram",
              "url_twitter",
              "url_pinterest",
              "announcement",
              "shippo_api_token",
              "shippo_carrier",
              "shippo_service_type",
              "vendor_ga_tracking_code",
              "vendor_fb_tracking_code",
              "custom_domain",
              "custom_domain_status",
              "taxjar_key",
              "taxjar_export_statuses",
              "taxjar_export_csv_data",
              "ag_hide_city",
              "updated_timestamp",
              "suspend_date",
              "grace_period_start",
              "last_time_suspended",
              "last_debt_notification_time",
              "tax_number",
              "stripe_connect_account_type",
              "registered_from_storefront_id"
            ]
          }
        },
        {
          "table": {
            "table_name": "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.10",
              "prefix_cost": "0.00",
              "data_read_per_join": "1K"
            },
            "used_columns": [
              "company_id",
              "lang_code",
              "company_description",
              "terms",
              "subdomain_colors",
              "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.10",
              "prefix_cost": "0.00",
              "data_read_per_join": "112"
            },
            "used_columns": [
              "plan_id",
              "price",
              "periodicity",
              "commission",
              "products_limit",
              "revenue_limit",
              "vendor_store",
              "categories",
              "storefronts"
            ]
          }
        }
      ]
    }
  }
}

Result

company_id lang_code company_description terms subdomain_colors 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 plan_id stripe_connect_account_id identifier_facebook_pixel featured_products sd_ga_tracking_code paypal_commerce_platform_account_id tagline url_facebook url_instagram url_twitter url_pinterest announcement shippo_api_token shippo_carrier shippo_service_type vendor_ga_tracking_code vendor_fb_tracking_code custom_domain custom_domain_status taxjar_key taxjar_export_statuses taxjar_export_csv_data ag_hide_city updated_timestamp suspend_date grace_period_start last_time_suspended last_debt_notification_time tax_number stripe_connect_account_type registered_from_storefront_id price periodicity commission products_limit revenue_limit vendor_store categories storefronts
7918 en <p>I'm a homemaker, aspiring homesteader, a wife, a mother, a child of God, and sometimes an artist.&nbsp;</p> <p>Born and raised in Cherokee County, Georgia, I'm a proud southern mess.&nbsp;</p> <p>My greatest accomplishments are my husband and our two daughters who are 3 years old and 1 year old. I'm so blessed that God chose me to be theirs.&nbsp;</p> <p>I worked as a pet groomer for 15 years until recently I decided I didn't want to pass up time with my family anymore. I enjoy more than anything raising my little family and watching them grow. We've started a little homestead in Canton and are learning every step of the way!&nbsp;</p> <p>I've enjoyed drawing and painting my entire life, mostly just as a hobby. Recently I've decided to start creating and selling custom work as a way to help support my family.&nbsp;</p> <p><span class="wixGuard"></span></p> <p>Thank you for taking the time to visit!</p> <p>-Kristi</p> <p></p> null KDH Art 130 DONNA WAY CANTON A KDH Art 130 DONNA WAY CANTON GA US 30115 kdhart813@gmail.com +14706212313 none Y 1666909269 0 1 L4ARGF9MXKND2 Custom art and decor. 100% handmade and unique! https://www.facebook.com/profile.php?id=100086397861584 <p>Grand Opening! </p> A N 0 0 0 0 0 2.50 onetime 5.00 25 0.00 1