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('5720') 
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
5720 en <p><span style="color: rgb(0, 0, 0);">Hi there! I am an educator, cat mom, and maker in San Diego, CA.&nbsp; I make jewelry and I upcycle boxes into wall art.&nbsp;&nbsp;</span></p> <p><span style="color: rgb(0, 0, 0);">My start in making jewelry was difficult but I&nbsp;overcame those difficulties through effort and with help from others.&nbsp; After separating from a problematic jewelry company, which included not investing in me, I said to myself, "If they're not going to teach me, I'll teach myself," and that is what I&nbsp;have done.&nbsp;&nbsp;</span></p> <p><span style="color: rgb(0, 0, 0);">With friends donating beads and supplies to start, I began teaching myself.&nbsp; I could not have gotten here without investment from my friends at this critical juncture.&nbsp; Today,&nbsp;I design and make jewelry that is functional, unique, and beautiful, and that starts with shopping for components that inspire me.&nbsp; The pieces that I make are the ones that I would wear myself, so I know you will look fantastic, too! When someone wears my jewelry, I imagine that the wearer feels a boost of confidence to run the world.</span></p> <p><span style="color: rgb(0, 0, 0);">In addition to jewelry, I also work with my hands by upcycling.&nbsp; I have been upcycling since I was a kid, but I didn't get here until I&nbsp;taught an upcycling course.&nbsp; This course is about the importance of producing less waste, preserving resources, and sustainability.&nbsp; I practice this in my life as well.&nbsp; For example, I give ice cream and snack boxes a second chance at life by turning them into wall art, and you may see some of them in my store.&nbsp;&nbsp;</span></p> <p><span style="color: rgb(0, 0, 0);">Customers also see that I promote sustainability by using paper-based jewelry boxes, and sometimes, packaging materials are reused.&nbsp; I also give jewelry a second chance at life.&nbsp; Some customers ask me to make a bracelet from a broken necklace or fix a pair of earrings.&nbsp; I do my best to do good for customers and Earth.</span></p> <p><b>Processing Timeframe</b><br></p> <p>I take 1-3 days to process, pack, and ship your order.&nbsp; I use USPS so please allow time for delivery. </p> <p>We can alternatively schedule a date, time, and place for local pickup.&nbsp; Please note that if the location is too far or there is too much conflict with scheduling for pickup, your order will be shipped.&nbsp;&nbsp;</p> <p>If the address for an order is an apartment, but there is no field to input an apartment number or suite when checking out your cart, please send me a message with&nbsp;</p> <ul><li>Your name,</li><li>Your order number,</li><li>The apartment number or suite&nbsp;</li></ul> <p>so I&nbsp;can add it to the shipping label.&nbsp; It's better to be clear and thorough so you get what you ordered.</p> <p>The customer is responsible for inputting the correct address and at a location that is not prone to package theft.&nbsp; The shop owner not responsible for package theft.</p> <p><strong>Issues with Order</strong></p> <p>Please send me a message as soon as you notice any issue with your order, and include photos and/or videos of how the package(s) and item(s) arrived.&nbsp; You have&nbsp;<b>7 days from the day the package arrived</b>&nbsp;to notify me of any issues with your order.&nbsp;&nbsp;</p> <p>If jewelry arrived broken,</p> <ol><li>We can set up a date, time, and place for me to fix it&nbsp;</li><li>You can send it to me, and I will send it back when I fix it</li></ol> <p>If wall art arrived misshapen or in pieces, I will need to fix it at my workspace and send it back to you.&nbsp;&nbsp;It is recommended that all wall art is picked up instead of delivered.</p> <p><strong>Return Policy</strong></p> <p>Please send me a message with the reason(s) why you want to return the item(s).&nbsp;&nbsp;</p> <p>When returning, the customer is responsible for properly packing the item(s) and for the cost of shipping.&nbsp; The amount refunded may be deducted for issues with products where the customer is at fault, for example, not packing items properly or plating is removed from jewelry due to actual wear.</p><p>Items marked in the <strong>Clearance</strong> category are <strong>not eligible for return, replacement, or repair</strong>.<br></p> <p><strong>Jewelry Care</strong></p> <p>Plated jewelry.&nbsp; Please avoid activities where moisture is involved (such as swimming, bathing, and exercising) while wearing plated jewelry to maintain the plating.&nbsp;&nbsp;</p> <p>When not worn, it is best to keep jewelry in a cool, dry, and dark place, such as in a jewelry box.&nbsp; Hang chains and necklaces to prevent tangling.</p> <p><strong>Wall Art Care</strong></p> <p>Keep art in a cool place that avoids sunlight and water.&nbsp; When placed or hung in hot weather or a hot room, the art piece can curl or bend.&nbsp; It will straighten again in cool temperatures.&nbsp; Additionally, when in sunlight for prolonged periods of time, the colors will fade and/or change.</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":""} O Kim 7521 Judson Ct. San Diego A O Kim 7521 Judson Ct. San Diego CA US 92111 okimjewelry@outlook.com +18585278963 none Y 1646179626 0 1 acct_1KdJsTBvuiD1bio9 Functional, beautiful, and special oauth.yS1K611nuEyGiPnCA5TG8b8SO6ICFt1InWLKIXN8.V7cbsF0behBu8NmviaWc4wN8L-8RbQhTfRwJ-1XV7cs A N 0 0 0 0 0 S 2.50 onetime 5.00 25 0.00 1