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

Query time 0.00065

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
448 en <p style="font-size:40px;" class="text-center"><strong><span style="color: rgb(31, 73, 125);">Vila Blu -&nbsp;We welcome you all year round!</span></strong></p> <div class="row-fluid"> <div class="span8"> <p style="font-size:20px;"><span style="color: rgb(149, 55, 52);"><strong>Our company</strong></span> offers services in the Hotel, mainly during the summer, but also throughout the year.The hotel is set on a picturesque hill, overlooking the entire coast of Himara Bay, the height of which makes the view magical, every morning and evening. We also organize the reception of customers at the airport and return. During the stay at the Hotel, we organize tourist trips along the sea bay and through the picturesque villages of the province. We also serve in ticket offices and tourist trips throughout Albania and beyond, in the Balkan region.</p></div> <div class="span7"><img src="https://webmarco.com/images/All%20vendors/Team%20Cleaning/NewFolder/Vila%20Blu.png?1637588310399"></div></div> <p style="font-size:20px;"><em><strong><span style="color: rgb(149, 55, 52);"><strong>Himara</strong></span> is a fortress on the sea. It has in its bosom two castles and many Churches, for which there are special stories. In Himara a bright part of the Italo-Greek war took place, the signs of which can also be found today. Himara has played an important role in the History of Albania, through the protection of its interests, lobbying with the Pope of Rome, with whom he has many correspondences.</strong></em></p> <p style="font-size:20px;"><strong><span style="color: rgb(149, 55, 52);">Himara</span></strong> is composed of a number of beautiful villages from which we distinguish Qeparo Fshat, Borshi, Lukova, Piluri, Dhermiu, Vunoi, Palasa, with the sea edge about 58 km long, composed of numerous bays from which we distinguish: Gjiri i Grames, Gjipese, Livadhi, Llamani, Borshit, Kakomese. The whole area is accessible by all means, on foot, for all those who frequent Hiking, by motor vehicles and by sea, where you can find Hotels, Restaurants, Bars and beaches that are magical in terms of cleanliness and possible to feel a tourist.</p> <p><img src="https://webmarco.com/images/All%20vendors/Team%20Cleaning/NewFolder/Emme%20Shopping%20%2819%29.png?1637588645236"><em></em></p> Vila Blu, Hotel, Hotel vila blu, hotel a himare, best hotels in himare, holets near me, hotel with view, best hotels, hotels a vlora, himare, holidays in himara, holidays, J82916478M, webmarco, web marco Vila Blu - The best hotel located on a picturesque hill, offering a beautiful view over the bay of Himare, which every morning and evening offers a breathtaking spectacle. Vila Blu - We welcome you all year round! Vila Blu Stefanel, Niko Rapo 6 Himarë A Vila Blu Stefanel, Niko Rapo 6 Himarë AL-12 AL 9425 stefomato@yahoo.com +355692402599 https://vila-blu.com/? none Y 1637229616 0 N N N 13 256147344 0 0 0 0 0 0 0 0 0 0 0 0 0.00 month 12.20 0 0.00 1