MySQL 8.0 优化 in ,exist,join 性能比较 及索引命中情况

环境

windows
MySQL 8.0.21

建表语句

首先建表 t_user1 ， t_class1

-- t_user1
CREATE TABLE
IF
	NOT EXISTS `t_user1` (
		`id` INT UNSIGNED AUTO_INCREMENT,
		user_id INT NOT NULL,
		`name` VARCHAR ( 100 ) NOT NULL,
		`age` INT NOT NULL,
		PRIMARY KEY ( `id` ) 
	) ENGINE = INNODB DEFAULT CHARSET = utf8;

delimiter $$
CREATE PROCEDURE pr () BEGIN
	DECLARE
		i INT;
	
	SET i =