【MySQL系列3】MySQL执行计划EXPLAIN详细说明和举例，springboot项目运行原理

最新推荐文章于 2024-04-05 07:45:11 发布

m0_65322636

最新推荐文章于 2024-04-05 07:45:11 发布

阅读量951

点赞数

分类专栏：程序员文章标签：面试 java 后端

本文链接：https://blog.csdn.net/m0_65322636/article/details/122085526

版权

本文详细介绍了MySQL的执行计划，包括system、const、eq_ref、ref等不同类型，解释了它们的工作原理。同时，文章还讨论了这些执行计划在SpringBoot项目中的实际应用，帮助读者理解如何优化数据库查询性能。

摘要由CSDN通过智能技术生成

insert into test (id, name, company, age, create_time) values(‘13’,‘张三丰’,‘jd’,‘108’,‘2020-05-29 12:36:31’);

insert into test (id, name, company, age, create_time) values(‘14’,‘张一1’,‘huawei’,‘18’,‘2020-05-29 12:36:11’);

insert into test (id, name, company, age, create_time) values(‘15’,‘张二1’,‘huawei’,‘19’,‘2020-05-29 12:36:13’);

insert into test (id, name, company, age, create_time) values(‘16’,‘张三1’,‘huawei’,‘20’,‘2020-05-29 12:36:15’);

insert into test (id, name, company, age, create_time) values(‘17’,‘张四1’,‘huawei’,‘22’,‘2020-05-29 12:36:16’);

insert into test (id, name, company, age, create_time) values(‘18’,‘李一1’,‘baidu’,‘22’,‘2020-05-29 12:36:18’);

insert into test (id, name, company, age, create_time) values(‘19’,‘李二1’,‘huawei’,‘22’,‘2020-05-29 12:36:24’);

insert into test (id, name, company, age, create_time) values(‘20’,‘李三1’,‘baidu’,‘22’,‘2020-05-29 12:36:25’);

insert into test (id, name, company, age, create_time) values(‘21’,‘李四1’,‘baidu’,‘26’,‘2020-05-29 12:36:28’);

insert into test (id, name, company, age, create_time) values(‘22’,‘李五1’,‘baidu’,‘27’,‘2020-05-29 12:36:30’);

insert into test (id, name, company, age, create_time) values(‘23’,‘李六1’,‘alibaba’,‘28’,‘2020-05-29 12:36:31’);

insert into test (id, name, company, age, create_time) values(‘24’,‘张三丰1’,‘jd’,‘108’,‘2020-05-29 12:36:31’);

insert into test (id, name, company, age, create_time) values(‘25’,‘张三丰1’,‘jd’,‘108’,‘2020-05-29 12:36:31’);

insert into test (id, name, company, age, create_time) values(‘26’,‘张三丰1’,‘jd’,‘108’,‘2020-05-29 12:36:31’);

insert into test (id, name, company, age, create_time) values(‘28’,‘张二1’,‘huawei11’,‘19’,‘2020-05-29 12:36:13’);

insert into test (id, name, company, age, create_time) values(‘29’,‘张三1’,‘huawei11’,‘20’,‘2020-05-29 12:36:15’);

insert into test (id, name, company, age, create_time) values(‘30’,‘张四1’,‘huawei11’,‘22’,‘2020-05-29 12:36:16’);

insert into test (id, name, company, age, create_time) values(‘31’,‘李一1’,‘baidu11’,‘22’,‘2020-05-29 12:36:18’);

insert into test (id, name, company, age, create_time) values(‘32’,‘李二1’,‘huawei11’,‘22’,‘2020-05-29 12:36:24’);

insert into test (id, name, company, age, create_time) values(‘33’,‘李三1’,‘baidu11’,‘22’,‘2020-05-29 12:36:25’);

insert into test (id, name, company, age, create_time) values(‘34’,‘李四1’,‘baidu11’,‘26’,‘2020-05-29 12:36:28’);

insert into test (id, name, company, age, create_time) values(‘35’,‘李五1’,‘baidu11’,‘27’,‘2020-05-29 12:36:30’);

insert into test (id, name, company, age, create_time) values(‘36’,‘李六1’,‘alibaba11’,‘28’,‘2020-05-29 12:36:31’);

insert into test (id, name, company, age, create_time) values(‘37’,‘张三丰1’,‘jd11’,‘108’,‘2020-05-29 12:36:31’);

insert into test (id, name, company, age, create_time) values(‘38’,‘张三丰1’,‘jd11’,‘108’,‘2020-05-29 12:36:31’);

insert into test (id, name, company, age, create_time) values(‘39’,‘张三丰1’,‘jd11’,‘108’,‘2020-05-29 12:36:31’);

insert into test (id, name, company, age, create_time) values(‘40’,‘张一9’,‘huawei11’,‘18’,‘2020-05-29 12:36:11’);

insert into test (id, name, company, age, create_time) values(‘41’,‘张二9’,‘huawei11’,‘19’,‘2020-05-29 12:36:13’);

insert into test (id, name, company, age, create_time) values(‘42’,‘张三9’,‘huawei11’,‘20’,‘2020-05-29 12:36:15’);

insert into test (id, name, company, age, create_time) values(‘43’,‘张四9’,‘huawei11’,‘22’,‘2020-05-29 12:36:16’);

insert into test (id, name, company, age, create_time) values(‘44’,‘李一9’,‘baidu11’,‘22’,‘2020-05-29 12:36:18’);

insert into test (id, name, company, age, create_time) values(‘45’,‘李二9’,‘huawei11’,‘22’,‘2020-05-29 12:36:24’);

insert into test (id, name, company, age, create_time) values(‘46’,‘李三9’,‘baidu11’,‘22’,‘2020-05-29 12:36:25’);

insert into test (id, name, company, age, create_time) values(‘47’,‘李四9’,‘baidu11’,‘26’,‘2020-05-29 12:36:28’);

insert into test (id, name, company, age, create_time) values(‘48’,‘李五9’,‘baidu11’,‘27’,‘2020-05-29 12:36:30’);

insert into test (id, name, company, age, create_time) values(‘49’