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

Query time 0.00050

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
707 ro <p>General Rules for using the Oricare.ro online store</p> <p>2.1. The online store can only be used by people who have<br />age over 18 years.<br />2.2. People under 18 can only use the online store<br />with the consent of the parents or legal guardian.<br />2.3. The customer is considered a consumer, provided that the purpose for ordering the supplies and services cannot be attributed primarily to the commercial or independent professional activities of that party. A merchant is any legal person or individual who acts in the exercise of commercial or independent activities at the conclusion of the contract.<br />*Please note that we omit the direct targeting of all genders just to make it easier to read, but this text refers to both male and female customers.<br />2.4. By registering on the site, you give your consent to transfer your personal data. We request your consent to process your data, and without it the online store cannot be used. The type and manner of personal data processing are explained here: Privacy Policy<br />2.5. To make sure that we have registered your data correctly, we will send you an e-mail after you have registered in the online store, by which we will ask you to verify and confirm the information.<br />2.6. Products are sold only in quantities suitable for personal use.<br />2.7. The seller's online store is only a product catalog. By listing the products in the online store, the Seller invites the Customer to make a purchase from the presented products and conclude a sales contract (hereinafter referred to as "Order").<br />2.8. The contracted language is exclusively Romanian.<br />Processing of personal data<br />3.1. The agreement regarding the processing of personal data is voluntary. However, we note that the lack of consent leads to the impossibility of registering on the site and using the online store. All information regarding the processing of personal data is available in the Privacy Policy.<br />3.2. In some situations we will request your consent in the online store to be able to send you announcements, offers, special discounts. This consent is also voluntary and may be withdrawn at any time. More information is available in the Privacy Policy</p> 1001produse.ro Aleea ilia , Nr5 bl57 sc2 Bucuresti, Bucuresti, 7000 Romania Bucuresti A 1001produse.ro Aleea ilia , Nr5 bl57 sc2 Bucuresti, Bucuresti, 7000 Romania Bucuresti RO-B RO 7000 colniceanu1@yahoo.com +40763710278 none Y 1683306081 0 N N N 14 0 0 0 0 0 0 0 0 0 0 0 0 a:32:{s:12:"booking_type";s:1:"N";s:9:"from_date";i:1683237600;s:7:"to_date";i:1683237600;s:9:"slot_time";s:1:"0";s:9:"free_time";s:1:"0";s:9:"days_data";s:738:"a:21:{s:13:"sunday_status";i:0;s:24:"sunday_timing_start_time";s:0:"";s:22:"sunday_timing_end_time";s:0:"";s:13:"monday_status";i:0;s:24:"monday_timing_start_time";s:0:"";s:22:"monday_timing_end_time";s:0:"";s:14:"tuesday_status";i:0;s:25:"tuesday_timing_start_time";s:0:"";s:23:"tuesday_timing_end_time";s:0:"";s:16:"wednesday_status";i:0;s:27:"wednesday_timing_start_time";s:0:"";s:25:"wednesday_timing_end_time";s:0:"";s:15:"thursday_status";i:0;s:26:"thursday_timing_start_time";s:0:"";s:24:"thursday_timing_end_time";s:0:"";s:13:"friday_status";i:0;s:24:"friday_timing_start_time";s:0:"";s:22:"friday_timing_end_time";s:0:"";s:15:"saturday_status";i:0;s:26:"saturday_timing_start_time";s:0:"";s:24:"saturday_timing_end_time";s:0:"";}";s:17:"quantity_selector";s:1:"N";s:24:"sunday_timing_start_time";s:0:"";s:22:"sunday_timing_end_time";s:0:"";s:24:"monday_timing_start_time";s:0:"";s:22:"monday_timing_end_time";s:0:"";s:25:"tuesday_timing_start_time";s:0:"";s:23:"tuesday_timing_end_time";s:0:"";s:27:"wednesday_timing_start_time";s:0:"";s:25:"wednesday_timing_end_time";s:0:"";s:26:"thursday_timing_start_time";s:0:"";s:24:"thursday_timing_end_time";s:0:"";s:24:"friday_timing_start_time";s:0:"";s:22:"friday_timing_end_time";s:0:"";s:26:"saturday_timing_start_time";s:0:"";s:24:"saturday_timing_end_time";s:0:"";s:1:"R";a:4:{s:9:"from_date";s:10:"05/05/2023";s:7:"to_date";s:10:"05/05/2023";s:20:"minimum_booking_time";s:1:"0";s:10:"price_wise";a:0:{}}s:15:"show_price_date";s:1:"N";s:12:"blocked_date";s:0:"";s:13:"sunday_status";i:0;s:13:"monday_status";i:0;s:14:"tuesday_status";i:0;s:16:"wednesday_status";i:0;s:15:"thursday_status";i:0;s:13:"friday_status";i:0;s:15:"saturday_status";i:0;s:10:"price_wise";a:0:{}} 0.00 month 20.00 0 0.00 1