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

Query time 0.00076

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
462 en <p style="text-align:center;font-size:40px;font-weight:bold;color:#b47b4f;"><strong>Zerja Resort & SPA </strong></p> <p style="text-align:center;font-size:25px;font-weight: bold;"> - You are not leaving a dream , You are leaving Zerja Resort!<br></p> <p><br> </p> <p><video class="vid" controls="" width="100%" height="100%"><br> <source src="https://webmarco.com/images/All%20vendors/Zerja%20resort/ezgif.com-gif-maker.mp4?1639473767073"><br> </video></p> <div class="span7"> <p style="font-size:22px;margin-top:10px;font-weight: bold;">Our Cousine</p> <p style="font-size:18px;margin-top:10px;">Peshkopia already has something to be proud of. We offer the best conditions with the best prices in the Peshkopi area.Our resort already offers a variety of services such as: Restaurant - combined with German and Italian cuisine.The best and most delicious pizzas prepared in the wood oven with the characteristic aroma of the wood oven. We are considered the best in Hospitality, our hotel has 5 stars certified by the Ministry of Tourism. Professional staff and with a fantastic care for every client who visits our hotel.</p> </div> <br> <div class="span7"> <img src="https://webmarco.com/images/icons_wa_flags_contact/studio%20jovial/fotooo.jpg?1642090622174"> </div> </div> <br> <br> <br> <br> <div class="row-fluid" bis_skin_checked="1"> <div class="span7" bis_skin_checked="1"> <video controls="" width="70%" height="50%"> <source src="https://webmarco.com/images/All%20vendors/Zerja%20resort/124009958_977004719377285_1656584945943761450_n.mp4?1639478425878"> </video> </div> <br> <br> <br> <div class="span7 cimi" bis_skin_checked="1"> <p class="par4"><b style="font-size: 18px;"> The newest innovation in the city of Peshkopi is that Resort Zerja already offers SPA services:</p> <br> <br> <div class="span7"> <p style="font-size:18px;"> Sauna <br> SHamam Turk <br> Solar <br> Jacuzzi (soon) <br> Massage Room (soon) <br> Indoor Pool (soon) </p> <br> <p><br></p> <p style="font-size:18px;"> </p> </div> </div> <p><br></p> <br> <br> <div class="row-fluid"> <p style="text-align:center;font-size:16px;"> In Summer we offer canoe trips, a fantastic ride along <b>"Drin i Zi River"</b> to remain in your mind as an unforgettable experience. </p> <p style="text-align:center;font-weight:bold;font-size:16px;"> As for all tourists at home and abroad Our Tourist Guide, so that everyone who comes here can see how beautiful the City of Peshkopi is. </p> <br> <ul style="font-size:18px;text-align:center;font-weight: bold;">Our Guide Includes: <li style="text-align:center;font-size:18px;">-Climbing Mount Korab (the highest mountain in the Balkans)</li> <li style="text-align:center;font-size:18px;">-Visit Beautiful "Lura" with it's 7 lakes</li> <li style="text-align:center;font-size:18px;">-Pucesti Waterfall</li> <li style="text-align:center;font-size:18px;">-Radomira</li> <li style="text-align:center;font-size:18px;">-Grama</li> </ul> <br> <p style="font-size:18px;"> Some features of <b>"Zerja Resort & SPA" </b>are the organization of holidays and parties offering you an extraordinary family environment in order to spend your joys in the best possible way.</p> </div> <br> <p style="font-size:18px;text-align: center;"> Come visit us, you will not be disappointed .</p> </div> <p style="font-size:25px;text-align: center;font-weight: bold;color:#b47b4f"> We Love You To The Moon and Back!</p> </div> Zerja Resort & SPA, zerja resort, spa, hotel, hotel peshkop, hoteli më i mirë, hoteli me 5 yje, prenotim hoteli, sauna, xhakuzi, restorant zerja, pushime, dhoma, rezervime, K87018701L, web marco, webmarco Le të mos flasim më, por të veprojmë! Ne jemi më të mirët në Hoteleri, hoteli ynë ka 5 yje të certifikuar nga Ministria e Turizmit dhe ofron kushtet më të mira me çmimet më të mira në zonë. Zerja Resort & SPA - Nuk po jeton një ëndërr, po jeton Resort Zerja! Zerja Resort & SPA Rruga Peshkopi-Tirane Km1 Peshkopi A Zerja Resort & SPA Rruga Peshkopi-Tirane Km1 Peshkopi AL-09 AL 8301 zerja2021@gmail.com +355675431510 https://zerja.al/? none Y 1638546069 0 N N N 13 257395583 0 0 0 0 0 0 0 0 0 0 0 0 0.00 month 12.20 0 0.00 1