数据库查询卡住问题
全局生成DB pool
id(self.dbpool) 意味使用同一个池？
DB连接数begin:3,select id,total_run_num,run_ok_num,run_error_num,running_num,run_status,created_at,updated_at from job_status_info WHERE ( id = '1053893') and sleep(10) ;,1567407912.379206 140120844811456
1053893 100 []
DB连接数end:4, select id,total_run_num,run_ok_num,run_error_num,running_num,run_status,created_at,updated_at from job_status_info WHERE ( id = '1053893') and sleep(10) ;, 1567407912.3802826
DB连接数begin:0,select id,total_run_num,run_ok_num,run_error_num,running_num,run_status,created_at,updated_at from job_status_info WHERE ( id = '1053894') ;,1567407915.4672704 140120844811456
1053894 100 []
DB连接数end:1, select id,total_run_num,run_ok_num,run_error_num,running_num,run_status,created_at,updated_at from job_status_info WHERE ( id = '1053894') ;, 1567407922.3824778
{'status': 'success', 'message': '', 'data': {'db_result': [{'id': 1053894, 'total_run_num': 1, 'run_ok_num': 1, 'run_error_num': 0, 'running_num': 0, 'run_status': 2, 'created_at': '2019-08-28 18:07:43', 'updated_at': '2019-08-28 18:08:28'}], 'all_num': 1}}
DB连接数begin:3,select id,total_run_num,run_ok_num,run_error_num,running_num,run_status,created_at,updated_at from job_status_info WHERE ( id = '1053893') and sleep(10) ;,1567407923.071466 140120844811456
1053893 100 []
DB连接数end:4, select id,total_run_num,run_ok_num,run_error_num,running_num,run_status,created_at,updated_at from job_status_info WHERE ( id = '1053893') and sleep(10) ;, 1567407923.0725508
正常情况
DB连接数begin:3,select id,total_run_num,run_ok_num,run_error_num,running_num,run_status,created_at,updated_at from job_status_info WHERE ( id = '1053893') and sleep(10) ;,1567408226.7767687 139796451474792
1053893 100 []
DB连接数end:4, select id,total_run_num,run_ok_num,run_error_num,running_num,run_status,created_at,updated_at from job_status_info WHERE ( id = '1053893') and sleep(10) ;, 1567408226.777331
DB连接数begin:0,select id,total_run_num,run_ok_num,run_error_num,running_num,run_status,created_at,updated_at from job_status_info WHERE ( id = '1053894') ;,1567408227.7535014 139796451474624
1053894 100 []
DB连接数end:1, select id,total_run_num,run_ok_num,run_error_num,running_num,run_status,created_at,updated_at from job_status_info WHERE ( id = '1053894') ;, 1567408227.7543445
{'status': 'success', 'message': '', 'data': {'db_result': [{'id': 1053894, 'total_run_num': 1, 'run_ok_num': 1, 'run_error_num': 0, 'running_num': 0, 'run_status': 2, 'created_at': '2019-08-28 18:07:43', 'updated_at': '2019-08-28 18:08:28'}], 'all_num': 1}}
DB连接数begin:0,select id,total_run_num,run_ok_num,run_error_num,running_num,run_status,created_at,updated_at from job_status_info WHERE ( id = '1057831') ;,1567408227.7584693 139796451474624
1053893 100 []
DB连接数end:1, select id,total_run_num,run_ok_num,run_error_num,running_num,run_status,created_at,updated_at from job_status_info WHERE ( id = '1057831') ;, 1567408227.7587025
DB连接数begin:3,select id,total_run_num,run_ok_num,run_error_num,running_num,run_status,created_at,updated_at from job_status_info WHERE ( id = '1053893') and sleep(10) ;,1567408229.7786055 139796451474792
1053893 100 []
DB连接数end:4, select id,total_run_num,run_ok_num,run_error_num,running_num,run_status,created_at,updated_at from job_status_info WHERE ( id = '1053893') and sleep(10) ;, 1567408229.779398
