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

Query time 0.00075

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
7353 en <p>Back in October 2018, I had this amazing business idea.</p> <p>So, as one crazy crafty person would do, I ignored my already full schedule and added it to my long list of fantastic business ideas, and ran with it.</p> <p>This time&hellip;I knew this business was different&hellip; &nbsp;special&hellip;so special that I hesitated even to start it.</p> <p>Just as I got started, the unthinkable happened.</p> <p>I found myself pregnant. AGAIN.&nbsp; I wasn't too surprised this time around because it was my 9th child.</p> <p>However, I found myself longing to be joyful and excited, but instead, I was met with so much anger and fear.&nbsp; I was DEVASTATED.&nbsp; I thought I was done.&nbsp; I wanted to be done so long ago and found myself pregnant yet again.&nbsp; I was already exhausted with my 8 children who were under the age of 13.</p> <p>&nbsp;This would begin, what some would call, a 5-year journey through hell and back.&nbsp;</p> <p>My baby boy was born sleeping, I homeschooled 8 kids through the pandemic, my marriage finally dissolved, and I had to move the kids and I back to Arkansas to be near family. </p> <p>&nbsp;As I think back about some of the hardest times of my life, one thing has remained constant.&nbsp; My trust and faith in the Lord; knowing that no matter what hardships I endure, He is always there ready and willing to listen and comfort me.</p> <p>Even though the trials I was experiencing were insurmountable, I continued to pursue my new business, holding on for dear life of my business dreams.</p> <p>I worked tirelessly through the nights after the kids were in bed to build a future for my children.<br></p> <p>As a single mom of such a large number of kids, I know all too well the feelings of being unequipped, scared, and unfit to do this alone.</p> <p>How am I supposed to be able to protect all my children and advocate for them while they are not with me?</p> <p>When I started my business, I simply had a great idea that had little to no meaning to me personally, but as the reality of my circumstances began to unfold, my burning questions began to bring about a newfound meaning and vision for my life.</p> <p>Having experienced years of shame and belittling, it became my mission in life to help others feel safe in their communities, to give children a way to explore their world more safely, and give moms a sense of peace & security while their children are in someone else's care.</p> <p>Please join me on this journey by sharing my mission to bring medical and allergy awareness to those near and far.</p> <p>I've since expanded my line of Medical Bag Tags into bigger things and now incorporate all things that would add joy to someone's life.</p> {"tmenu_style":"V","default_colors":"N","link_color":"#d9ead3","label_color":"#b6d7a8","icon_color":"#d9ead3","main_btn_color":"#b6d7a8","branded_text_color":"#d9ead3","vbp_1_url":"","vbp_2_url":"","vbp_3_url":"","vba_1_url":"","vba_2_url":"","vba_3_url":""} Bag Tags Unlimited 2016 Catherine Benton A Bag Tags Unlimited 2016 Catherine Benton AR US 72019 bagtagsunlimited@gmail.com +19193845020 none Y 1660146211 0 4 acct_1LiObqLachzf5Yfb 252613,261988,249508,252689,252616 WYB2S4FCDVNCC Bag Tags, Key Chains, & More! <p>Thank you for stopping by to check out all things Bag Tags!&nbsp;&nbsp;I fell in love with making Key Chains and then decided to take it to the next level and create all things related to Tags.</p> bagtagsunlimited.com A {"items_per_file":"2500","time_from":"","time_to":""} N 0 0 0 0 0 S 10.00 onetime 3.50 1000 0.00 1