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('896') 
ORDER BY 
  companies.company_id asc 
LIMIT 
  0, 1

Query time 0.00077

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
896 en <p></p> <p>Studio 1153 is a&nbsp;South Carolina-based art line designed and crafted by Lori Levine (that's me!)</p> <p></p> <p>With an interest in abstract art, an eye for details and the love of creating things by hand, I have been working in various mediums for many years. I began painting with alcohol ink in 2017, which led to a newfound passion for designing and hand painting glass jewelry.</p> <p></p> <p>My art is influenced by the astounding allure of nature and the inner beauty of living souls. I am&nbsp;inspired by toasted autumn leaves, underwater corals, rolling blue waves, magnificent golden sunsets or the glistening indigo moonlight; and, most importantly, by what is seen and felt in the heart.</p> <p></p> <p>I am a self-taught abstract artist with imaginative visions.&nbsp; Every piece of art brings new challenges and perspectives as alcohol ink rarely responds the same way twice.&nbsp; It may have been painted in my vision, but as they say, "beauty is in the eye of the beholder," so&nbsp;you determine what you see within each piece.</p> <p></p> <p>I want my jewelry to be viewed as elegant and yet playful, unique and inspiring, creative and encouraging, fresh and celebratory.</p> <p></p> <p>When I am not creating, I am thinking about creating. &nbsp;I experiment, take risks, break the rules, and when&nbsp;I make mistakes, I make it part of my art.</p> <p></p> <p>My passion and ultimate goal&nbsp;is to design art for your mind, your soul and your spirit. Art makes my soul grow and if I happen to make a living from it, then I will be ever so more grateful.</p> {"default_colors":"N","link_color":"#007d89","label_color":"#00a0af","icon_color":"#00a0af","main_btn_color":"#6dd1d6","branded_text_color":"#00a0af"} Studio 1153 1153 Warrens Way Manning A Studio 1153 1153 Warrens Way Manning SC US 29102 lori.studio1153@gmail.com none Y 1594645508 0 a:4:{s:14:"company_fields";a:2:{i:37;s:4:"Lori";i:38;s:6:"Levine";}s:15:"admin_firstname";s:4:"Lori";s:14:"admin_lastname";s:6:"Levine";s:6:"fields";a:0:{}} 2 acct_1BT0meHrapKbuzAu art for your mind, your soul, your spirit facebook.com/studio1153 instagram.com/studio_1153 pinterest.com/studio1153 <p></p> <p><span class="color_15">Beautiful, funky, whimsical and versatile&nbsp;</span>works of art may be found at Studio 1153.</p> <p><span class="color_15"></span>I hope you are inspired by my designs, and that the words that are written reach&nbsp;your heart and soul.&nbsp;&nbsp;</p> <p><span class="wixGuard"></span></p> <p><br></p> <p><br></p> A N 0 0 0 0 0 S 5.00 onetime 4.50 100 0.00 1