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

Query time 0.00160

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
189 en <p>The name&nbsp;<strong>Dark Poet Designs</strong>&nbsp;was lifted from my once-upon-a-time one-line resume: </p> <p>"...wife, mother, Girl Scout leader, bookkeeper (in both senses), dark poet..." </p> <p>I am a retired elementary school teacher who has been designing bead jewelry for over 20 years. Originally, I hosted in-home studio shows. Over time, teaching and Argentine tango became my focus. I kept creating, but quit marketing my work. </p> <p>I create necklace/earring sets, earrings, and an occasional bracelet.&nbsp;Each of my designs is one-of-a-kind. I frequently use mid-century vintage glass beads, usually post-war Japanese, German, or Czech. Other materials include semi-precious stones, freshwater pearls, crystals, seed beads, glass rondelles, raku or ceramic beads, contemporary artisan-made beads in various media, and sterling silver or bronze beads and clasps. <br><br>Thank you for visiting my page. To see some of my past work and browse through some interesting links, visit my <a href="http://www.darkpoetdesigns.com/"></a><a href="http://www.darkpoetdesigns.com/" target="_blank"><span style="color: rgb(49, 133, 155);">website</span></a>. My work is for sale online exclusively here at&nbsp;<a href="https://goimagine.com/dark-poet-designs/"><span style="color: rgb(49, 133, 155);">goimagine</span></a>.&nbsp;Some of my work may be seen on <a href="https://www.instagram.com/darkpoetdesigns/" target="_blank"><span style="color: rgb(49, 133, 155);">Instagram</span></a>. I'm also on <a href="https://www.pinterest.com/karenr0133/dark-poet-designs/"><span style="color: rgb(49, 133, 155);">Pinterest</span></a>, <a href="https://www.facebook.com/DarkPoetDesigns">Facebook,</a>&nbsp;and <a href="https://www.tumblr.com/darkpoetdesigns">Tumblr</a>.</p><p><span style="font-size: 16px;">&mdash; Karen Reck | Los Ranchos de Albuquerque, New Mexico</span></p><p><br></p> <p>P.S. I haven't written a dark (vampires, ghosts, and demon lovers) poem in several years.&nbsp; </p> <p></p> <p><strong>Contact me</strong></p> <p>Please <a href="mailto:karen.abqnm@gmail.com">contact me</a> if you have any questions about your order, my work, or my terms.<br><strong><br>Shipping</strong></p> <p>U.S. shipping is FREE/included in price (First Class).<br>Time in transit may vary depending on USPS.<br></p> <p>Estimated packing/shipping times:&nbsp;2-5 days.</p> <p><strong>I will accept returns if you:</strong></p> <ul><li>Contact me within 5 days of delivery</li><li>Ship items back within 7 days of delivery</li></ul> <p><strong>Conditions of return</strong></p> <p>Buyers are responsible for return shipping costs.<br>Item(s) must be returned in their original condition and in original packaging.<br>Refunds will be issued after I've received your return.<br>Custom orders cannot be returned or exchanged.<br></p> <p><strong><br>Thank you</strong> for your support of <strong>goimagine</strong> and my work!</p> {"tmenu_style":"H","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":""} Dark Poet Designs | Unique Bead Jewelry 620 Charles Pl NW Los Ranchos A Dark Poet Designs | Unique Bead Jewelry 620 Charles Pl NW Los Ranchos NM US 87107 karen.abqnm@gmail.com none Y 1585453177 0 a:4:{s:14:"company_fields";a:2:{i:37;s:5:"Karen";i:38;s:4:"Reck";}s:15:"admin_firstname";s:5:"Karen";s:14:"admin_lastname";s:4:"Reck";s:6:"fields";a:0:{}} 3 acct_1GS89DIA5ZAcZzsC 300427,300426,306954,300411,299317,63605,300425,300414,54694 UA-177223349-1 OOAK designs inspired by beautiful and quirky/beautiful beads https://www.facebook.com/DarkPoetDesigns https://www.instagram.com/darkpoetdesigns/ https://www.pinterest.com/karenr0133/dark-poet-designs/ <p>My work is OOAK and artisan designed. Thanks for visiting and thanks for your support of The Marketplace That Cares!</p> UA-177223349-1 darkpoetdesigns-uniquebeadjewelry.com A {"items_per_file":"2500","time_from":"","time_to":""} N 0 0 0 0 0 S 7.50 onetime 4.00 250 0.00 1