ylrz_saas_pharmacy/java/scripts/QueryStuckGen.java

import java.sql.*;
public class QueryStuckGen {
  public static void main(String[] a) throws Exception {
    Class.forName("com.mysql.cj.jdbc.Driver");
    String url = "jdbc:mysql://cq-cdb-8fjmemkb.sql.tencentcdb.com:27220/fs_tenant_cs1?useSSL=false&useUnicode=true&characterEncoding=UTF-8&serverTimezone=GMT%2B8";
    try (Connection c = DriverManager.getConnection(url, "root", "Ylrz_1q2w3e4r5t6y"); Statement st = c.createStatement()) {
      System.out.println("=== status=0 records ===");
      try (ResultSet rs = st.executeQuery("SELECT id, record_no, company_id, status, LEFT(error_msg,80) err, create_time, update_time FROM company_workflow_lobster_record WHERE del_flag=0 AND status=0 ORDER BY create_time DESC LIMIT 20")) {
        int n=0; while (rs.next()) { n++; System.out.printf("%d | %s | company=%s | created=%s | updated=%s%n", rs.getLong("id"), rs.getString("record_no"), rs.getString("company_id"), rs.getTimestamp("create_time"), rs.getTimestamp("update_time")); }
        System.out.println("count shown="+n);
      }
      System.out.println("=== status distribution ===");
      try (ResultSet rs = st.executeQuery("SELECT status, COUNT(*) cnt FROM company_workflow_lobster_record WHERE del_flag=0 GROUP BY status")) {
        while (rs.next()) System.out.println("status="+rs.getInt(1)+" cnt="+rs.getInt(2));
      }
    }
  }
}