select count(1) from tbl_count_info_camera_minute_temporary (小助手查询表单来了多少数据)
差某一个点位的数据
索引丢失导致的查询超时:
关闭中心接收,并对表单进行加索引
1:给tbl_count_info_camera_minute_temporary表单加num索引
CREATE INDEX tbl_count_info_camera_minute_temporary_num
ON tbl_count_info_camera_minute_temporary
USING btree
(num);
2:给tbl_count_info_zone_minute表单加id索引
CREATE INDEX index_count_info_zone_minute_id
ON tbl_count_info_zone_minute
USING btree
(id);
3:给tbl_count_info_zone_day表单加id索引
CREATE INDEX index_count_info_zone_day_id
ON tbl_count_info_zone_day
USING btree
(id);
4:给tbl_count_info_org_day表单加id索引
CREATE INDEX index_count_info_org_day_id
ON tbl_count_info_org_day
USING btree
(id);