qq_44501608的博客

200万数据联表查询SQL优化4S至毫秒级背景: 表一表二:原sql共两条一条分页查内容,一条查总行数select h.* from device_info i left join device_mqtt_history h on h.code = i.code where h.id is not null and i.dept_id in ( 17 ,2 , 22 , 21 , 20 , 27 , 25 , 19 , 26 , 1,20 ) order by h.create_time de