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

Query time 0.00096

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
562 en <p><strong><em>Broken & Renewed Glass Art</em></strong>&nbsp; is the embodiment of my journey into mixed media jewelry which began over 25 years ago when I started working with stained glass in Tucson, AZ.&nbsp;</p> <p> After moving to St. Charles, MO, I was introduced to glass fusing.&nbsp; I love the dynamic way that color can change when heated in a kiln.&nbsp; The variety of color possibilities is amazing...talk about rainbows.&nbsp; Learning to wire wrap became my way to turn the cabochons (focal pieces) into pendants, bracelets, earrings, and other accessories.&nbsp; I enjoy working with hand-painted porcelain cabochons&hellip;which are both colorful and lightweight&hellip;along with fused glass, Silver Silk knitted cord, satin cord, along with a variety of beads, wire and findings.&nbsp;</p> <p>Throughout the years, I have taken classes to learn different techniques including Kumihimo cord and bead work, a unique addition to my portfolio, together with a variety of new wire wrapping techniques.&nbsp; I continue to learn through classes and online sources drawing inspiration and encouragement from them and allowing me to continue my passion for creating unique pieces of wearable art.&nbsp;&nbsp;</p> <p>I am affiliated with several art organizations who have helped me to stay grounded and broaden my relationships within the artist community.&nbsp; &nbsp;&nbsp;</p> <p>• Self-Representing Artists in Jewelry Design (SRAJD) – Member for 10+ Years</p> <p> • Best of Missouri Hands (BOMH) –&nbsp;<em>Juried Member</em>&nbsp;</p> <p>• Greater St. Louis Art Association (GSLAA) -&nbsp;<em>Member</em></p> <p> • St. Charles County Arts Council -&nbsp;Member</p> <p> •&nbsp;Crossroads Arts Council - Artist Member&nbsp;</p> <p>When you visit the Greater St. Louis area, you can find my work at the following locations:&nbsp; </p> <p>• Framations Art Gallery (St. Charles, MO)</p> <p> • Lillian Yahn Gallery (O’Fallon, MO)</p> <p> • Missouri’s Trading Post (Hermann, MO)</p> <p>&nbsp; </p> <p><br></p> <p></p> <p><b>TERMS AND CONDITIONS</b></p> <p>Because our jewelry is individually handcrafted, it is important to answer any of your questions/concerns up front.&nbsp; Please do not hesitate to contact us directly before you make your purchase.&nbsp; Thank you.&nbsp; </p> <p>&nbsp; </p> <p>The pictures that you see in the shop are taken using a photo booth.&nbsp; The lighting is as natural as it can be.&nbsp; Many of the porcelain pieces are coated in mother of pearl and because of that they reflect varying colors.&nbsp; Please be aware that this can affect what you see.&nbsp; Also be aware that your screen will see things differently than mine.&nbsp; We work with a base color pallet but when mixing colors together new colors evolve.&nbsp; If you are concerned about coloring, please let us know before you purchase the piece and we will take several additional pictures and forward them to you.&nbsp; <strong>NO ITEM CAN BE RETURNED JUST BECAUSE THE COLOR ISN’T EXACTLY WHAT YOU EXPECTED.&nbsp;</strong> Thank you for understanding.&nbsp; </p> <p>&nbsp; </p> <p><b>CUSTOM ORDERS</b> </p> <p>&nbsp; </p> <p>We do take custom orders.&nbsp; Time involved in processing evolves around several things.&nbsp; </p> <ul><li>If ordering a piece with a porcelain focal, do we have that cab in our inventory or do we have to create it. If it is in our inventory, the next question is whether I have it in stock here or does it have to be shipped by my coworker.&nbsp; The time involved varies.&nbsp; &nbsp;We can discuss all of this prior to placing your order. </li><li>A wire-wrapped piece takes approximately two business days to complete and ship if I have the wire in stock.&nbsp; If it has to be ordered, it can take up to two weeks based on wire delivery.&nbsp; &nbsp;&nbsp;</li><li>Wire-wrapped cuff bracelets take two business days to complete and ship if I have the wire in stock.&nbsp; If it has to be ordered, it can take up to two weeks based on wire delivery.</li><li>Other custom requests will be discussed prior to order. </li><li>And, of course, orders will be processed in the order they are received. </li></ul> <p>&nbsp;</p> <p><b>RETURNS AND EXCHANGES</b> </p> <p>&nbsp; </p> <p>Our goal is to sell you a handcrafted piece of jewelry art that you will love wearing.&nbsp; Each piece is individually created.&nbsp; Once again, please ask questions, express any concerns, etc. before you make your purchase.&nbsp; &nbsp;Should your item arrive damaged, PLEASE contact us immediately.&nbsp; We want you to be completely satisfied.&nbsp; </p> <p>&nbsp; </p> <p>We will accept returns and exchanges under the following circumstances:</p> <ul><li>The item is damaged, <i>i.e.</i> the wire wrapping is loose, the porcelain is cracked, the beading is flawed, the clasps are coming off, some other flaw in the craftsmanship. &nbsp;Please note that a picture of the item will be taken prior to shipping so that it can be compared with your concern.</li><li>The item was bought as a gift and the person receiving the gift would prefer a different design or color.&nbsp; </li><li>The order is incorrect in any way.&nbsp; Getting it right is our job.&nbsp; </li></ul> <p>&nbsp; </p> <p><b>Pre-approval</b> is required on all returns, refunds, or exchanges.&nbsp; We must be contacted <b>within 7 days</b> of your receipt of the item.&nbsp; <i>Please <b>do not return</b> the item before we have discussed all options.&nbsp; </i>If you do, you may not receive a full refund.&nbsp; </p> <p>&nbsp; </p> <p><b>Return shipping</b> is at your expense.&nbsp; We will NOT pay for return shipping.&nbsp; </p> <p>&nbsp; </p> <p>Once the item is question has been returned to us, we will proceed with the terms and process as agreed upon. </p> <p>&nbsp; </p> <p><b>Please note:</b> </p> <ul><li>Custom orders are non-refundable.&nbsp; We will have thoroughly discussed the order during its creation process and pictures were provided upon completion.&nbsp; The order was shipped with your approval. </li><li><b>Earrings:</b>&nbsp; For health reasons, we cannot restock earrings.&nbsp; Therefore, earrings are nonrefundable and nonexchangeable. </li></ul> <p>&nbsp; </p> <p><b>PAYMENT</b> </p> <ul><li>Goimagine and Broken & Renewed Glass Art uses both PayPal and Stripe to process payments.&nbsp; Both keep your payment information secure and we never receive your credit card information. </li><li>Orders will not be processed until payment has cleared. Orders will be cancelled if payment has not cleared within the items processing time plus 2 business days. </li><li>We do not offer any payment plans.&nbsp;</li><li>The Goimagine platform and Broken & Renewed Glass Art accept all major debit and credit cards.&nbsp;</li><li>If you are having any issues at checkout, please feel free to contact us or the Goimagine Team.</li></ul> <p>&nbsp; </p> <p><b>SHIPPING</b> </p> <ul><li>Purchase of items listed for sale on the site will be processed immediately and shipped within two business days.&nbsp;</li><li>Custom orders will be shipped based on time involved to create the item.&nbsp; This will be explained at the time of the order as the timing can vary. </li><li>All items will be shipped USPS either First Class or Priority Mail. &nbsp;These methods are<b> free</b> to the purchaser.&nbsp; If you want a different method, we can discuss this at the time you place your order.&nbsp; </li><li>Because we use First Class and Priority Mail, tracking of your package is included.&nbsp; </li><li>In all instances, it is the purchaser’s responsibility to make sure that we have the correct mailing information.&nbsp; We <b>will not</b> be responsible for incorrect mailing information.&nbsp; </li></ul> <p>&nbsp; </p> <p><b>SHIPPING TO SOMEONE OTHER THAN PURCHASER</b> </p> <p>&nbsp; </p> <p>If you want your purchase shipped to an address other than yours, please make sure to double-check that the shipping information is included in your order and that it is correct.&nbsp; We <b>will not</b> be responsible for incorrect shipping information.&nbsp;&nbsp; </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":""} Broken & Renewed Glass Art 6 Piepers Glen Ct O Fallon A Broken & Renewed Glass Art 6 Piepers Glen Ct O Fallon MO US 63366 brokenandrenewedglassart@gmail.com none Y 1589037614 0 a:4:{s:14:"company_fields";a:2:{i:37;s:5:"Donna";i:38;s:4:"Knox";}s:15:"admin_firstname";s:5:"Donna";s:14:"admin_lastname";s:4:"Knox";s:6:"fields";a:0:{}} 3 acct_1Gi5ijFz887c9iSE 142580,55908,47696,54962,47967,49683 78F9KKE5V6B9N Mixed Media Jewelry and Assemblage Art https://www.facebook.com/Broken-Renewed-Glass-Art-by-Donna-Knox brokenandrenewedglassart <p>Welcome to Broken & Renewed!&nbsp; We are in the process of totally redoing the shop.&nbsp; Please be patient.&nbsp; We will be featuring our newest creations and designs.&nbsp; Thanks for visiting.&nbsp;&nbsp;</p> 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