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

Query time 0.00080

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
393 sq <p><img src="https://webmarco.com/images/All%20vendors/Team%20Cleaning/Untitled%20design%20-%202021-10-27T150249.990.png?1635339828830" alt="Untitled%20design%20-%202021-10-27T150249.990.png?1635339828830" /> </p><br /> <p style="font-size:30px;"><span style="color:rgb(79,129,189);"><strong>Who We Are</strong></span></p> <div class="row-fluid"> <div class="span7"> <p style="font-size:20px;"><span style="color:rgb(89,89,89);">-Skerdi Driving School, with address Rruga Berisha in Kamez, 200 meters from the center of Kamez, open since 2018.<br />-Skerdi-2 Driving School with Address ASTIR UNAZE BULEVARDI YZBERISHT opened in January 2020.<br />-Skerdi and Skerdi-2 driving schools have all categories of vehicles for issuing driving licenses starting from category AM, A1, A2, A, B, BE, C1, C1E, CE, D1, D1E, D, DE, and Evidence of professional skills CAP, DAP.</span></p> </div> <div class="span7"> <img src="https://webmarco.com/images/All%20vendors/Team%20Cleaning/98.jpg?1635339978294" style="width:435px;height:244.219px;" width="435" height="244" alt="98.jpg?1635339978294" /></div> </div> <p style="font-size:20px;"><span style="color:rgb(89,89,89);"> <br />-Tools for giving practice of contemporary standards.<br />-Skerdi Driving School Develops theory lessons based on the questionnaire updated by DPSHTRR.<br />-Skerdi Driving School also helps those who have a driver's license and need payment guides for all types of vehicle categories.<br />-Skerdi Driving School Theory Schedules in Kamez.<br />-Berisha Street is from Monday to Friday morning 10.00.11.00 and afternoon 17.00.18.00. <br />-Saturday and Sunday break. <br />-Practice from breakfast to dinner schedules can be dictated by the trainees themselves.<br />-Skerdi Driving School has very talented theory and practice instructors who do their job with more desire and dedication. <br />-There is also a female instructor.<br />-Skerdi Driving School-2 Address Bulevardi YZBERISHT Unaza e Re has these schedules. <br />-Theory from Monday to Friday 18.00.19.00.Saturday and Sunday break.</span></p> <p><img src="https://webmarco.com/images/All%20vendors/Team%20Cleaning/Untitled%20design%20-%202021-10-22T143744.771.png?1634906287453" alt="Untitled%20design%20-%202021-10-22T143744.771.png?1634906287453" /></p> Driving school, Skerdi, Skerdi driving school, Driving license, Driving license courses, Driving courses, Driving school in Tirana, Where to take a driving license? Driving licenses starting from category AM, A1, A2, A, B, EU, C1, C1E, CE, D1, D1E, D, DE, and Proof of professional competence CAP, DAP, And the tools for giving practice standards contemporary. Autoshkolla SKERDI Autoshkolla SKERDI Rruga Berisha Kamëz A Autoshkolla SKERDI Rruga Berisha Kamëz AL-11 AL 1030 autoshkollaskerdi@gmail.com +355674647681 none Y 1633524354 0 N N N 13 253995930 0 0 0 0 0 0 0 0 0 0 0 0 0.00 month 12.20 0 0.00 1