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

Query time 0.00021

JSON explain

{
  "query_block": {
    "select_id": 1,
    "const_condition": "1",
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_companies",
          "access_type": "const",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "4",
          "used_key_parts": ["company_id"],
          "ref": ["const"],
          "rows": 1,
          "filtered": 100
        }
      },
      {
        "table": {
          "table_name": "cscart_company_descriptions",
          "access_type": "const",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "10",
          "used_key_parts": ["company_id", "lang_code"],
          "ref": ["const", "const"],
          "rows": 1,
          "filtered": 100
        }
      },
      {
        "table": {
          "table_name": "p",
          "access_type": "const",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "4",
          "used_key_parts": ["plan_id"],
          "ref": ["const"],
          "rows": 1,
          "filtered": 100
        }
      }
    ]
  }
}

Result

company_id lang_code company_description terms 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 tax_number registered_from_storefront_id plan_id suspend_date grace_period_start last_time_suspended last_debt_notification_time paypal_commerce_platform_account_id pre_moderation pre_moderation_edit pre_moderation_edit_vendors stripe_connect_account_id stripe_connect_account_type nt_commission_include_price price periodicity commission products_limit revenue_limit vendor_store categories storefronts
947 en Crafted for timeless style and durability, our brand specializes in premium solid pine furniture. From sideboards to wardrobes, each piece is built to last with natural charm and expert craftsmanship—perfect for every home. Pine Furniture Direct 79, Triq Gorg Oliver Borg Rabat A Pine Furniture Direct 79, Triq Gorg Oliver Borg Rabat harkinsclark@gmail.com +35679363231 none Y 1741350566 16 0 a:4:{s:14:"company_fields";a:3:{i:37;s:7:"Matthew";i:38;s:5:"Clark";i:52;s:8:"26162236";}s:15:"admin_firstname";s:7:"Matthew";s:14:"admin_lastname";s:5:"Clark";s:6:"fields";a:0:{}} 1 6 0 0 0 0 N N N acct_1REZcU2KXr5nJL2r S N 0.00 month 1.25 3000 10000.00 1