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

Query time 0.00063

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
284 it <h3><span style="color:rgb(79,129,189);"></span></h3> <h3 class="text-center"><span style="color:rgb(79,129,189);"><img src="https://webmarco.com/images/All%20vendors/Malice%20Profumeria/aboutmelicecrop.png?1626775594769" alt="aboutmelicecrop.png?1626775594769" /></span></h3> <h1 class="text-center"><span style="color:rgb(79,129,189);">Perfumery, Goldsmith </span></h1> <h1 class="text-center"><span style="color:rgb(79,129,189);"> and Fashion Accessories ...</span></h1> <h3 class="text-center"><span style="color:rgb(79,129,189);"> in Manerba del Garda </span></h3> <h3 class="text-center"><span style="color:rgb(79,129,189);"><br /></span></h3> <h4 class="text-center">Malice Perfumery in Manerba del Garda offers you not only products of the best brands for beauty and body hygiene but also numerous beauty services for women and men in our Aesthetic Center.<br /> At Malice perfumery, you can buy cosmetics dedicated to all skin types, make-up products, sun creams and oils for the summer and products for the treatment of your hair. <br /> The expert and qualified staff of the perfumery will always be at your disposal to assist you and recommend the products for your every need.<br /> In our Beauty Center we carry out for her and for him: face and body treatments, massages, hair removal, pedicure and manicure, pressotherapy, solarium, day/evening make-up and brides personalized packages and much more.<br /> Call now to find out more about our services and book your session.</h4> <h4 class="text-justify"><span style="color:rgb(23,54,93);"></span></h4> <p><span style="color:rgb(34,34,34);font-size:24px;font-weight:700;"></span></p> <h1 class="text-center"><em><span style="color:rgb(31,73,125);">Aesthetic treatments at the perfumery of Manerba del Garda</span></em></h1> <h4 class="text-center">The Malice perfumery is located in Manerba del Garda to offer you numerous collections of products for the care,<br /> personal hygiene and beauty of the face, body and hair, selecting for you only the most prestigious and most requested brands in the sector. The perfumery is also a beauty centre <br />and offers numerous treatments, from manicures to pedicures, from pressotherapy to laser hair removal, from bridal make-up to the solarium. Call now to request your beauty treatment.</h4> <p><br /></p> <p></p> <p><br /></p> <h1 class="text-center"><span style="color:rgb(79,129,189);"><strong><em>Face, body and make-up cosmetics<img src="https://webmarco.com/images/All%20vendors/Malice%20Profumeria/4271feb4-d9ea-4049-a4a2-2b92fe93a5a4-2880w.png?1626782856071" style="width:133px;height:210px;" width="133" height="210" alt="4271feb4-d9ea-4049-a4a2-2b92fe93a5a4-2880w.png?1626782856071" /></em></strong></span></h1><p><br /></p> <p></p> <h4 class="text-center">Malice Perfumery offers very high-quality cosmetic items, specific for the face and body and make-up<br /> products of the best brands on the market, to satisfy the requests of the most demanding customers.<br /> Among the brands present you will find Mesauda Milano, Elizabeth Arden, Shiseido, Collistar, Polì, Aesthetic Project and many others.</h4><p><br /></p> <p></p> <p><br /></p> <p><span style="color:rgb(23,54,93);background-color:rgb(255,255,255);"></span></p> <p><strong><span style="color:rgb(79,129,189);"></span></strong></p> Malice Profumeria & Estetica, Aesthetic center, beauty services web Malice Profumeria & Estetica - Malice Perfumery in Manerba del Garda offers you not only products of the best brands for beauty and body hygiene but also numerous beauty services for women and men in our Aesthetic Center. Malice Profumeria & Estetica - Aesthetic treatments Malice Profumeria & Estetica Via Gassman, 7 CROCIALE Manerba del Garda A Malice Profumeria & Estetica Via Gassman, 7 CROCIALE Manerba del Garda 25 IT 25080 malice.pgmsrls@gmail.com +393486654434 https://maliceprofumeriaestetica.it/? none Y 1624002233 10,9,48,49 0 N N N 10 245489369 0 0 0 0 0 0 0 0 0 0 0 0 0.00 month 6.10 0 0.00 1