5.3 小助手查询超时需要处理的表

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);