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

Query time 0.00130

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
25 it <h2><span style="color:rgb(23,54,93);">Leto Ascensori</span></h2> <blockquote><span style="color:rgb(149,55,52);"><strong>Lift Assembly, Repair and Maintenance.</strong></span></blockquote> <p><strong>Leto Ascensori</strong><span style="color:rgb(51,51,51);font-size:16px;">, based in Milazzo, deals with the assembly, repair and maintenance of lifts, also thinking about the disabled, with the assembly and assistance of lifting platforms.</span> Leto Ascensori<span style="color:rgb(51,51,51);font-size:16px;"> is a leading company in the sale and assembly of elevators, escalators and lifting platforms of great quality and reliability; over the years the company has made itself known to its customers also for the after-sales assistance it offers, for repairs, ordinary maintenance and modernization.</span></p> <p><span style="color:rgb(51,51,51);font-size:16px;">&nbsp;The variety of products offered is very wide, to respond as much as possible to the customer's needs and to different situations; the products offered are all of Italian design and production by Monitor elevator, a Milan-based company that is world leader in the elevator sector.</span></p> <h5><span style="color:rgb(51,51,51);font-size:16px;"></span></h5> <p>The technicians of <strong>Ascensori Leto</strong> are equipped with the appropriate qualification, as required by law, and have acquired many years of experience, both in large multinational companies and in local companies in the sector.</p> <p><strong>Ascensori Leto</strong>, based in Via Riccardo D'amico, 29 in Milazzo (Messina), offers itself with the utmost reliability for the maintenance, repair and installation of lifts and hoists.</p> <p><strong>Courtesy and Availability</strong> are the peculiarities to which <strong>Ascensori Leto</strong>, impeccably cares, precisely to assist and advise customers to their needs, and it is precisely for this reason that it uses specialized personnel and CE certified material.</p> <p>The primary objective of <strong>Ascensori Leto</strong> is total customer satisfaction and is committed to the maximum efficiency of the service, from order to delivery, from installation to maintenance, with complete after-sales assistance. It also offers its customers a service 24 hours a day, 365 days a year.</p> <p><br><br></p> <p><br></p> Leto Ascensori, Lift Assembly, Repair services, Maintenance services, lifting platforms, assistance platforms, webmarco, marcoweb, web marco Leto Ascensori - Lift Assembly Repair and Maintenance. Leto Ascensori, based in Milazzo, deals with the assembly, repair and maintenance of lifts, also thinking about the disabled, with the assembly and assistance of lifting platforms. Leto Ascensori - Lift Assembly Repair and Maintenance | Webmarco | Leto Ascensori Via D'Amico Riccardo 29 Milazzo A Leto Ascensori Via D'Amico Riccardo 29 Milazzo 82 IT 98057 ascensorileto@gmail.com +390909221136 none Y 1592318268 0 N N N 10 223383009 0 0 0 0 0 0 0 0 0 0 0 0 0.00 month 6.10 0 0.00 1