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

Query time 0.00227

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
6659 en <p>Hey Y'all!&nbsp;</p> <p>I'm Tish and I create hand-drawn and painted mandalas, mixed media encaustics, acrylic fluid paintings, as well as hand-printed marbled monotypes. I occasionally miss my jewelry-making days and have been known to pop out a small collection every now and then. I have a lot going on. LOL!</p> <p>I enjoy using my creativity as a meditative practice. It is how I cope with life. It is how I express my joy, sadness, frustration, and calm. Creative expression is also how I&nbsp;tune out and let the world fall away. Sometimes, I&nbsp;surprise myself.&nbsp;</p> <p>As you take a gander at my work, keep in mind your own joy, sadness, frustration, and calm. What resonates with those emotions? Which one speaks the loudest and makes you feel something? THAT is the one you want in your space! A conversation piece, for not just yourself, but for others as well.&nbsp;</p> <p>___________________</p> <p>I have been an artist all my life. After graduating college, I&nbsp;entered the non-profit art community as an Administrator, creating experiences for people looking to connect to their own creativity. My journey brought me into teaching my techniques to all ages and backgrounds, which I&nbsp;thoroughly enjoyed. I still teach art occasionally, hosting workshops around New Orleans. Currently, I&nbsp;am still doing administration in artistic spaces and until my work pays the bills, I&nbsp;shall remain in that role.&nbsp;</p> <p>Soooooo......who is gonna help me become a full time artist? ;o)</p> <p>Thank you for visiting my page. Your love and support mean the world to me. If you like what you see, share it with others.&nbsp;</p> <p><br></p> <p><strong>Return Policy</strong>:&nbsp;All sales are final.&nbsp;</p> <p>&nbsp; &nbsp;<em>* If a piece is damaged upon receipt, please document everything and contact me. I&nbsp;insure all of my work for shipping. Since most all of my work is original, one-of-a-kind pieces, the possibility of reproducing a replicate is very low.&nbsp;</em></p> <hr> <p><strong>Processing Timeframe</strong>:&nbsp;Please give me 5 - 7 business days to get your work together for shipping. You should receive your art 10 - 15 days after purchase.&nbsp;</p> <p>&nbsp; &nbsp; <em>* Currently, I do not ship internationally.</em>&nbsp;</p> <hr> <p><strong>Disclaimers</strong>:&nbsp;All work listed on my site is 100% my work. I do not use images from other artists.&nbsp;</p> <p>&nbsp; &nbsp; <em>* Regarding encaustic work:&nbsp;Wax should not be exposed to high heat or areas of the house that receive a lot of light. If you need a consult about this, just contact me and together, we can find a spot in your home that is perfect.&nbsp;</em></p> <p><em>&nbsp; &nbsp; * All of my work is sent to you ready to hang, with the exception of my marbled monotypes. They will need to be framed.&nbsp;</em></p> <hr> <p><br></p> {"tmenu_style":"V","default_colors":"N","link_color":"#007d89","label_color":"#00a0af","icon_color":"#00a0af","main_btn_color":"#6dd1d6","branded_text_color":"#00a0af","vbp_1_url":"","vbp_2_url":"","vbp_3_url":"","vba_1_url":"","vba_2_url":"","vba_3_url":""} TD Studio 243 Delaronde Street New Orleans A TD Studio 243 Delaronde Street New Orleans US 70114 tish.douzart@gmail.com +15047232056 none Y 1652395021 0 3 acct_179NXrFhj4LnmikY www.facebook.com/tishdoesart www.instagram.com/tish_douzart A N 0 0 0 0 0 S 7.50 onetime 4.00 250 0.00 1