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

Query time 0.00070

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
489 sq <p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<strong> &nbsp; &nbsp; &nbsp; &nbsp;"ALPA" shpk</strong></p> <p class="text-center"><strong>➡ If you value your car, you become an integral partner with us.</strong></p> <p class="text-center">"ALPA" shpk: It is in the top list of companies in the region of Lezha & one of the best in Albania with over 25 years of experience.<br>"ALPA" shpk is the first to set the highest standards in the Albanian market, introducing the "set" equipment of the leader, the leader<br>avant-garde in the world market "GORCHI".<br>"ALPA" shpk has professional staff certified by well-known companies such as: "Gorchi", "Rema Tip-Top", "Spin", "Italmatic", etc.</p> <p class="text-center"><strong>"ALPA" shpk offers you: Tires, Service & Spare Parts.</strong></p> <p class="text-center">The products & brands it offers in the market have the European standard with competitive prices.<br>We, lead the highest demands of the clientele, offering it the highest quality in the Albanian market and the leading brands in the world market.<br>In the field of tires: Premium brands on the market, are part of our daily life, such as: "Continental", "Michelin", "Pireli",<br>"Bridgestone", "BFGoodrich" etc.<br>Quality brands: Kleber, Firestone, Fulda etc.<br>Economic & budget brands: European and Chinese such as Tyfoon, Orium, Kormoran, Malatesta, Windforce, etc.<br>In the field of spare parts, lubricants, batteries, accessories, etc.<br>Luk, Ina, Fag, Sachs, Contitech, Skf, Fag, Trw, ATE, Textar, Topran, Borch, Beru, Denso, Mobil 1, Castrol, Total, Elf, GM, Borch, Banner, Cartechnic, Bimeec, etc.</p> <p class="text-center"><strong>In the services sector.<br></strong>It has at its disposal 1 (one) Auto-Service and 2 (two) tire service points with modern standards.</p> <p class="text-center"><strong>General information about the main services in "AUTO SERVIS":</strong></p> <p class="text-center">-Diagnosis of the vehicle with the computer.<br>-Friction change.<br>-Replacement distributions (phase belt) with warranty.<br>-Onger oil & engine filters & Automatic truck oil with equipment certified by manufacturers such as: Mercedes, BMW, Audi-W, Toyota, etc.<br>-Alcohol exchange for all vehicles.<br>-Replacement of ferrules, brake discs, brake pipes, etc.<br>-Various generic services such as: tires, bus heads, motor legs, parallel heads, etc.</p> <p class="text-center"><strong>- General information about the main services in "GOMISTERI":</strong></p> <p class="text-center">-Robotic convergence for cars & trucks,<br>-Balancing disks of all types from disk 12 "-24".<br>-Aluminum disc steering ,<br>-Change car tires, truck & digger,<br>-Car tire repair services, truck & digger & other ancillary services.</p> <p class="text-center"></p> Alpa Shpk, K37506384R, tires, service, spare parts, Gorchi, auto service, premium brand, Rema Tip-Top, Spin, Italmatic, Spare parts, Lubricants, Batteries, Tires & Discs, Convergence, Disc Calender, webmarco, Tire Blower nitrogen, webmarco, Condon gas fil "ALPA" shpk: It is in the top list of companies in the region of Lezha & one of the best in Albania with over 25 years of experience and is the first to set the highest standards in the Albanian market, introducing "set" equipment of rubber Alpa Shpk - If you value your car, you become an inseparable partner with us. Alpa Sh.p.k Laç-Milot, Ish Parku i Mallrave, Kurbin. Laç A Alpa Sh.p.k Laç-Milot, Ish Parku i Mallrave, Kurbin. Laç 34 AL 4701 alpa.shpk@gmail.com 0685647957 https://alpashpk.com/? none Y 1642152247 0 N N N 13 260505369 0 0 0 0 0 0 0 0 0 0 0 0 0.00 month 12.20 0 0.00 1