Sandbox

SELECT 
  * 
FROM 
  cscart_companies AS com 
  LEFT JOIN cscart_products AS prod ON com.company_id = prod.company_id 
WHERE 
  prod.product_id = 357

Query time 0.00030

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "1.00"
    },
    "nested_loop": [
      {
        "table": {
          "table_name": "prod",
          "access_type": "const",
          "possible_keys": [
            "PRIMARY"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "product_id"
          ],
          "key_length": "3",
          "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": "4K"
          },
          "used_columns": [
            "product_id",
            "product_code",
            "product_type",
            "status",
            "company_id",
            "list_price",
            "amount",
            "weight",
            "length",
            "width",
            "height",
            "shipping_freight",
            "low_avail_limit",
            "timestamp",
            "updated_timestamp",
            "usergroup_ids",
            "is_edp",
            "edp_shipping",
            "unlimited_download",
            "tracking",
            "free_shipping",
            "zero_price_action",
            "is_pbp",
            "is_op",
            "is_oper",
            "is_returnable",
            "return_period",
            "avail_since",
            "out_of_stock_actions",
            "localization",
            "min_qty",
            "max_qty",
            "qty_step",
            "list_qty_count",
            "tax_ids",
            "age_verification",
            "age_limit",
            "options_type",
            "exceptions_type",
            "details_layout",
            "shipping_params",
            "facebook_obj_type",
            "parent_product_id",
            "buy_now_url"
          ]
        }
      },
      {
        "table": {
          "table_name": "com",
          "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": "15K"
          },
          "used_columns": [
            "company_id",
            "vendor_zid",
            "customer_zid",
            "status",
            "company",
            "lang_code",
            "address",
            "nit",
            "socio",
            "giro_de_negocio",
            "patente_comercio",
            "rtu",
            "dpi",
            "city",
            "state",
            "country",
            "zipcode",
            "email",
            "phone",
            "pbx",
            "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",
            "wk_vendor_custom_fields",
            "firstname",
            "lastname"
          ]
        }
      }
    ]
  }
}

Result

company_id	vendor_zid	customer_zid	status	company	lang_code	address	nit	socio	giro_de_negocio	patente_comercio	rtu	dpi	city	state	country	zipcode	email	phone	pbx	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	wk_vendor_custom_fields	firstname	lastname	product_id	product_code	product_type	list_price	amount	weight	length	width	height	shipping_freight	low_avail_limit	updated_timestamp	usergroup_ids	is_edp	edp_shipping	unlimited_download	tracking	free_shipping	zero_price_action	is_pbp	is_op	is_oper	is_returnable	return_period	avail_since	out_of_stock_actions	localization	min_qty	max_qty	qty_step	list_qty_count	tax_ids	age_verification	age_limit	options_type	exceptions_type	details_layout	shipping_params	facebook_obj_type	parent_product_id	buy_now_url
115		2404552000000086070	A	MAS Digital	es	13 calle 24-35	123456789	0					Guatemala	Zona 2		1455	flazaro@mas.com.gt	56927580					none	Y		1604973412			0		a:3:{s:6:"fields";a:3:{i:21;s:8:"12345678";i:20;s:1:"N";i:19;s:9:"Guatemala";}s:15:"admin_firstname";s:8:"Fernnado";s:14:"admin_lastname";s:6:"Lazaro";}	N	N	N	25	a:3:{i:21;s:8:"12345678";i:20;s:1:"N";i:19;s:9:"Guatemala";}	Fernando	Lazaro	357	2404552000000086105	P	0.00	2000	0.000	0	0	0	0.00	0	1604973414	0	N	N	N	B	N	R	Y	N	N	Y	10	0	N		0	0	0	0		N	0	P	F	default	a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}	activity	0