<> use mysql Implementation plan
EXPLAIN SELECT COUNT( 1 ) FROM ( Query table and conditions ) TOTAL 1 SIMPLE tb_humidity ALL
10998200 100.00 1 SIMPLE ca eq_ref PRIMARY PRIMARY 8 cold.tb_humidity.car_id 1
100.00 Using index 1 SIMPLE w eq_ref WeChatUser_ID WeChatUser_ID 8
cold.tb_humidity.wechat_id 1 100.00 Using index

Get the total number of current queries , This is better than direct count Fast Watch
List<Map<String, Object>> mapList = baseMapper.callSize(params); String
page.setTotal(Integer.parseInt(str)); page.setSearchCount(false);
The first is the result of parsing execution conditions
Manual injection of total number of pages
Paging master query switch false

©2019-2020 Toolsou All rights reserved,
springboot Multi profile configuration SpringBoot JpaRepository Database addition, deletion, modification and query ( Essence )2020 year 7 month 21 day ASP.NET Core Use of global filters Theory and formula derivation of univariate linear regression and multiple linear regression 11-5 Output string at specified position TypeScript Data types in is enough element-ui Of el-date-picker Component get value The shortest path of maze BFS algorithm (python realization )elementui select obtain valuemysql Modify primary key