SELECT 
  cscart_company_descriptions.*, 
  cscart_companies.*, 
  p.price, 
  p.periodicity, 
  p.commission, 
  p.products_limit, 
  p.revenue_limit, 
  p.vendor_store, 
  p.categories, 
  p.storefronts 
FROM 
  cscart_companies 
  LEFT JOIN cscart_company_descriptions ON cscart_company_descriptions.company_id = cscart_companies.company_id 
  AND cscart_company_descriptions.lang_code = 'en' 
  LEFT JOIN cscart_vendor_plans p ON p.plan_id = cscart_companies.plan_id 
WHERE 
  cscart_companies.company_id IN('451') 
ORDER BY 
  cscart_companies.company_id asc 
LIMIT 
  0, 1

Query time 0.00105

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "1.00"
    },
    "ordering_operation": {
      "using_filesort": false,
      "nested_loop": [
        {
          "table": {
            "table_name": "cscart_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.20",
              "prefix_cost": "0.00",
              "data_read_per_join": "9K"
            },
            "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",
              "pre_moderation",
              "pre_moderation_edit",
              "pre_moderation_edit_vendors",
              "plan_id",
              "sd_vendor_helper",
              "identifier_facebook_pixel",
              "stripe_connect_account_id",
              "tax_number",
              "facebook_pixel_id",
              "facebook_api_token",
              "handling_time_us",
              "handling_time_uk",
              "handling_time_it",
              "handling_time_in",
              "handling_time_mx",
              "handling_time_es",
              "handling_time_de",
              "handling_time_fr",
              "handling_time_cn",
              "handling_time_ca",
              "handling_time_jp",
              "handling_time",
              "blocked_date",
              "booking_data",
              "stripe_connect_account_type",
              "registered_from_storefront_id",
              "ec_rfq_whatsapp_number",
              "ec_rfq_phone_number",
              "ec_rfq_bhf",
              "ec_rfq_bht",
              "sd_ga_tracking_code",
              "sd_ga_api_secret"
            ]
          }
        },
        {
          "table": {
            "table_name": "cscart_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.20",
              "prefix_cost": "0.00",
              "data_read_per_join": "3K"
            },
            "used_columns": [
              "company_id",
              "lang_code",
              "company_description",
              "terms",
              "meta_keywords",
              "meta_description",
              "page_title",
              "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.20",
              "prefix_cost": "0.00",
              "data_read_per_join": "80"
            },
            "used_columns": [
              "plan_id",
              "price",
              "periodicity",
              "commission",
              "products_limit",
              "revenue_limit",
              "vendor_store",
              "categories",
              "storefronts"
            ]
          }
        }
      ]
    }
  }
}

Result

company_id lang_code company_description terms meta_keywords meta_description page_title 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 pre_moderation pre_moderation_edit pre_moderation_edit_vendors plan_id sd_vendor_helper identifier_facebook_pixel stripe_connect_account_id tax_number facebook_pixel_id facebook_api_token handling_time_us handling_time_uk handling_time_it handling_time_in handling_time_mx handling_time_es handling_time_de handling_time_fr handling_time_cn handling_time_ca handling_time_jp handling_time blocked_date booking_data stripe_connect_account_type registered_from_storefront_id ec_rfq_whatsapp_number ec_rfq_phone_number ec_rfq_bhf ec_rfq_bht sd_ga_tracking_code sd_ga_api_secret price periodicity commission products_limit revenue_limit vendor_store categories storefronts
451 it <p><img src="https://webmarco.com/images/All%20vendors/BIOMED%20SRL/baner-About.jpg?1638178006683" alt="4%3Ddesktop.png?1635328628676"></p> <p style="text-align:center;font-size:40px;font-weight:bold;color:green;"><strong>Biomed Srl</strong></p> <p style="text-align:center;font-size:18px;"> Biomed, Exclusive revolutionary solutions for your well-being. Biomed srl has revolutionized the world of supplements by positioning itself as a leader in colloidal technology. Thanks to this technology, Biomed extracts the nanocells making them 100% immediately assimilable in suspension in bi-distilled water. This unique revolution is changing the habits of millions of satisfied customers around the world. The quality is ensured in compliance with the European Directives. Thanks to this innovative technology, in addition to supplements, we have created an exclusive line of professional quality cosmetic products, enhanced with our line of colloids. We are also the creators of the ear therapy with Bio-magnets. The brilliant results of these years, the enthusiasm and ideas for the future are the result of a young, dynamic but experienced team and a constantly evolving communication.<br></p> <p><br> </p> <div class="row-fluid"> <div class="span7"> <p style="font-size:25px;font-weight:bold;text-align:center;color:black;">Top Products of the Line: </p> <hr> <br> <br> <p style="font-size:18px;"> -ZERODIET -ZEROSMOKE -CONCENTRA -NAUSEA STOP We have developed a new patented technology for the extraction of nanoparticles from the elements creating the most complete line of colloidal products in the world. We sell tens of millions of pieces per year and supply several distributors around the world with customized brand lines. </p> <br> <p style="font-size:25px; font-weight: bold;"> Top Products: </p> <p style="font-size:18px;"> SILVER - GOLD - COPPER - IRON - MAGNESIUM - ZINC -POTASSIUM - VITAMIN A, B, C, D, E - BROMELAIN BOTANIC EXTRACTS, ECHINACEA, MELATONIN, CARDO MARIANO - SILVER AND COPPER IN GEL - AESTHETIC LINE COLLAGEN, HYALURONIC ACID, MYCOSES <br> We have developed a new technology (which will be released in a few days) for the creation of aesthetic products of the highest level and quality based on colloidal nanoparticles and we are the only ones in the world to have it. </p> </div> <div class="span7"> <br> <br> <br> <br> <br> <img src="https://webmarco.com/images/All%20vendors/BIOMED%20SRL/cofanetto-vitamine-150-done.jpg?1638178386012" alt="logo-finance.jpg?1635328193447"> </div> </div> <div class="row-fluid"> <div class="span7"> <br> <br><br> <br> <img src="https://webmarco.com/images/All%20vendors/BIOMED%20SRL/product-all.jpg?1638178345034" alt="Foto1.jpg?1635329058266"> </div> <br> <br> <br> <p style="text-align:center;font-weight:bold;font-size:25px;"> Top Products: </p> <br> <ul style="font-size:18px;text-align:center;"> <li style="text-align:center;font-size:18px;">DETERGENTS GOLD COLLOIDAL CLEANSING MILK</li> <li style="text-align:center;font-size:18px;">MICELLAR WATER</li> <li style="text-align:center;font-size:18px;">SERUMS GOLD COLLOIDAL SERUM EYE BAGS</li> <li style="text-align:center;font-size:18px;">REVITALIZING SERUM FACE</li> <li style="text-align:center;font-size:18px;">COLLOIDAL GOLD CREAMS FACE AND EYE CONTOUR CREAM</li> <li style="text-align:center;font-size:18px;">1ILLUMINATING EMULSION CREAM.</li> </ul> <br> <br> <div class="span7"> <p style="font-size:25px;font-weight: bold;"> ZEROSUN ULTRA and NATURAL </p> <p><br></p> <p style="font-size:18px;"> We have also created a line for tanning and skincare.A self-tanning spray that does not stain lasts up to 10 years, contains no gas or other harmful substances and tans in less than 10 seconds. </p> </div> </div> <p><br></p> <div class="row-fluid"> <div class="span7"> <p style="font-size:25px;font-weight:bold;text-align:center;color:black;">ANTICELLULITE SCRUB </p> <hr> <br> <p><br></p> <p style="font-size:18px;">Together we have also created a product anticellulite scrub revolutionary based on Sicilian blood oranges. Lastly, we supply BOXES (packages with different products) that have one specific function towards a specific problem. eg: SYSTEM BOX IMMUNE, HEALTHY MUSCLES BOX, ANTI-STRESS BOX, GROWTH WELLNESS BOX, ENERGY BOX ETC. Continuously growing and expanding every year. Top-quality products, customers are thrilled and they get word of it our products are safe and always work. 100% Italians 100% Natural </p> </div> <br> <br> <div class="span7"> <img src="https://webmarco.com/images/All%20vendors/BIOMED%20SRL/5-zerosun-ultra-done.jpg?1638178232473"> </div> </div> Biomed Srl, medical devices sector, bio-magnets, auricular therapy, anticellulite scrub, natural medical products, beauty and health products, skincare, webmarco, web, marco, soluzioni per il benessere, 100% italian products, extraction of nanoparticles Biomed, a company that has been in the medical devices sector for over 20 years. We are manufacturers and patent holders of bio-magnets for auricular therapy. Millions of pieces are sold annually in 60 different countries. Biomed Srl - Soluzioni per il Benessere Biomed Srl Via Teresina Pizzolato, 17 Schio. Schio D Biomed Srl Via Teresina Pizzolato, 17 Schio. Schio 34 IT 36015 matteo@biomedsrl.net +393337233276 none Y 1637336940 0 N N N 12 256498837 0 0 0 0 0 0 0 0 0 0 0 0 0.00 month 10.00 0 0.00 1