MySQL的联合索引和覆盖索引

关于MySQL的联合索引，覆盖索引一直蒙蒙哒，所以写点东西来熟悉一下
首先创建一个表orders，结构如下：

create table orders(
order_id int unsigned auto_increment,
order_status int not null,
total_price int unsigned,
settle_type int,
store_id int,
buyer_id int,
goods varchar(20),
create_time datetime default current_timestamp,
primary key(order_id)
);

然后我们创建一个存储过程，向这个表中插入一些数据：

drop procedure if exists load_orders;
delimiter //
create procedure load_orders(count int unsigned)
begin
declare status int default 0;
declare type int default 0;
declare store int default 133;
declare price int default 85;
declare buyer int default 1001;
declare goods varchar(20) ;
declare i int unsigned default 0;
SET goods= 'al';
while i<count DO
  SET status=mod (status,77);
  SET type=mod(type,29);
<