pas-debug.log 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960
  1. [pas:0.0.0.0:8877] [,] 2023-12-13 11:12:22.893 DEBUG 15248 [main] cn.cslg.pas.mapper.TreeNodeMapper.selectList ==> Preparing: SELECT id,name,type,parent_id,type_id,path,level,create_id,create_time,description FROM tree_node WHERE (id = ?)
  2. [pas:0.0.0.0:8877] [,] 2023-12-13 11:12:22.909 DEBUG 15248 [main] cn.cslg.pas.mapper.TreeNodeMapper.selectList ==> Parameters: [2023](ArrayList)
  3. [pas:0.0.0.0:8877] [,] 2023-12-13 11:12:22.921 DEBUG 15248 [main] cn.cslg.pas.mapper.TreeNodeMapper.selectList <== Total: 0
  4. [pas:0.0.0.0:8877] [,] 2023-12-20 16:13:36.485 DEBUG 8600 [http-nio-8877-exec-4] cn.cslg.pas.mapper.CustomFieldMapper.getCustomField ==> Preparing: select id,name,description,project_id as projectId,type as type,status,create_id as createId,create_time as createTime from custom_field where project_id='101' limit 0,10
  5. [pas:0.0.0.0:8877] [,] 2023-12-20 16:13:36.492 DEBUG 8600 [http-nio-8877-exec-4] cn.cslg.pas.mapper.CustomFieldMapper.getCustomField ==> Parameters:
  6. [pas:0.0.0.0:8877] [,] 2023-12-20 16:13:36.514 DEBUG 8600 [http-nio-8877-exec-4] cn.cslg.pas.mapper.CustomFieldMapper.getCustomField <== Total: 6
  7. [pas:0.0.0.0:8877] [,] 2023-12-20 16:13:36.516 DEBUG 8600 [http-nio-8877-exec-4] cn.cslg.pas.mapper.CustomFieldMapper.getCustomFieldCount ==> Preparing: select count(*) from custom_field where project_id='101'
  8. [pas:0.0.0.0:8877] [,] 2023-12-20 16:13:36.517 DEBUG 8600 [http-nio-8877-exec-4] cn.cslg.pas.mapper.CustomFieldMapper.getCustomFieldCount ==> Parameters:
  9. [pas:0.0.0.0:8877] [,] 2023-12-20 16:13:36.519 DEBUG 8600 [http-nio-8877-exec-4] cn.cslg.pas.mapper.CustomFieldMapper.getCustomFieldCount <== Total: 1
  10. [pas:0.0.0.0:8877] [,] 2023-12-20 16:14:00.170 DEBUG 8600 [http-nio-8877-exec-9] cn.cslg.pas.mapper.SystemDictMapper.selectList ==> Preparing: SELECT id,label,value,type,group_type FROM os_system_dict WHERE (group_type = ?)
  11. [pas:0.0.0.0:8877] [,] 2023-12-20 16:14:00.171 DEBUG 8600 [http-nio-8877-exec-9] cn.cslg.pas.mapper.SystemDictMapper.selectList ==> Parameters: ASSESS(String)
  12. [pas:0.0.0.0:8877] [,] 2023-12-20 16:14:00.174 DEBUG 8600 [http-nio-8877-exec-9] cn.cslg.pas.mapper.SystemDictMapper.selectList <== Total: 20
  13. [pas:0.0.0.0:8877] [,] 2023-12-20 16:14:00.191 DEBUG 8600 [http-nio-8877-exec-10] cn.cslg.pas.mapper.ReportProjectMapper.getReportProject ==> Preparing: select distinct p.id as id,p.name as name ,rp.sign_patent_no as signPatentNo,p.contract_no as contract_no,p.volume_number as volumeNumber,p.commission_case_day as commissionCaseDay,p.description as description,p.create_id as createId,p.create_time as createTime, rp.report_type as reportType ,p.head_id as headId,p.department_id as departmentId, p.entrust_type as entrustType,p.entrust_id as entrustId,rp.product_or_tech as productOrTech,rp.cron_description as cronDescription ,rp.status as status from report as rp left join project as p on rp.project_id =p.id left join asso_report_cron arc on p.id =arc.project_id left join asso_project_event as aspe on p.id =aspe.project_id order by p.create_time desc limit 0,10
  14. [pas:0.0.0.0:8877] [,] 2023-12-20 16:14:00.192 DEBUG 8600 [http-nio-8877-exec-10] cn.cslg.pas.mapper.ReportProjectMapper.getReportProject ==> Parameters:
  15. [pas:0.0.0.0:8877] [,] 2023-12-20 16:14:00.197 DEBUG 8600 [http-nio-8877-exec-10] cn.cslg.pas.mapper.ReportProjectMapper.getReportProject <== Total: 10
  16. [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:08.608 DEBUG 7368 [http-nio-8877-exec-3] cn.cslg.pas.mapper.SystemDictMapper.selectList ==> Preparing: SELECT id,label,value,type,group_type FROM os_system_dict WHERE (group_type = ?)
  17. [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:08.615 DEBUG 7368 [http-nio-8877-exec-3] cn.cslg.pas.mapper.SystemDictMapper.selectList ==> Parameters: ASSESS(String)
  18. [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:08.624 DEBUG 7368 [http-nio-8877-exec-3] cn.cslg.pas.mapper.SystemDictMapper.selectList <== Total: 20
  19. [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:08.659 DEBUG 7368 [http-nio-8877-exec-4] cn.cslg.pas.mapper.ReportProjectMapper.getReportProject ==> Preparing: select distinct p.id as id,p.name as name ,rp.sign_patent_no as signPatentNo,p.contract_no as contract_no,p.volume_number as volumeNumber,p.commission_case_day as commissionCaseDay,p.description as description,p.create_id as createId,p.create_time as createTime, rp.report_type as reportType ,p.head_id as headId,p.department_id as departmentId, p.entrust_type as entrustType,p.entrust_id as entrustId,rp.product_or_tech as productOrTech,rp.cron_description as cronDescription ,rp.status as status from report as rp left join project as p on rp.project_id =p.id left join asso_report_cron arc on p.id =arc.project_id left join asso_project_event as aspe on p.id =aspe.project_id order by p.create_time desc limit 0,10
  20. [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:08.660 DEBUG 7368 [http-nio-8877-exec-4] cn.cslg.pas.mapper.ReportProjectMapper.getReportProject ==> Parameters:
  21. [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:08.666 DEBUG 7368 [http-nio-8877-exec-4] cn.cslg.pas.mapper.ReportProjectMapper.getReportProject <== Total: 10
  22. [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:20.834 DEBUG 7368 [http-nio-8877-exec-5] cn.cslg.pas.mapper.ProductCategoryMapper.getProductCategory ==> Preparing: select distinct category.id as id,category.name as name,category.license_rate as licenseRate,category.show_type as showType,category.description,category.create_id as createId,category.create_time as createTime, category.tenant from product_category as category left join product as product on category.id = product.category_id order by category.create_time desc limit 0,10
  23. [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:20.834 DEBUG 7368 [http-nio-8877-exec-5] cn.cslg.pas.mapper.ProductCategoryMapper.getProductCategory ==> Parameters:
  24. [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:20.840 DEBUG 7368 [http-nio-8877-exec-5] cn.cslg.pas.mapper.ProductCategoryMapper.getProductCategory <== Total: 5
  25. [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:20.842 DEBUG 7368 [http-nio-8877-exec-5] cn.cslg.pas.mapper.ProductCategoryMapper.getProductCategoryCount ==> Preparing: select count(*) from (select distinct category.id as id from product_category as category left join product as product on category.id = product.category_id ) as c
  26. [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:20.842 DEBUG 7368 [http-nio-8877-exec-5] cn.cslg.pas.mapper.ProductCategoryMapper.getProductCategoryCount ==> Parameters:
  27. [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:20.845 DEBUG 7368 [http-nio-8877-exec-5] cn.cslg.pas.mapper.ProductCategoryMapper.getProductCategoryCount <== Total: 1
  28. [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:20.848 DEBUG 7368 [http-nio-8877-exec-5] cn.cslg.pas.mapper.AssoProductCategoryFileMapper.selectList ==> Preparing: SELECT id,product_category_id,file_guid,create_id,create_time FROM asso_product_category_file WHERE (product_category_id IN (?,?,?,?,?))
  29. [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:20.849 DEBUG 7368 [http-nio-8877-exec-5] cn.cslg.pas.mapper.AssoProductCategoryFileMapper.selectList ==> Parameters: 17(Integer), 16(Integer), 9(Integer), 8(Integer), 7(Integer)
  30. [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:20.850 DEBUG 7368 [http-nio-8877-exec-5] cn.cslg.pas.mapper.AssoProductCategoryFileMapper.selectList <== Total: 3
  31. [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:22.883 DEBUG 7368 [http-nio-8877-exec-9] cn.cslg.pas.mapper.PatentProjectMapper.getPatentProject ==> Preparing: select distinct p.id as id,p.name as name ,p.contract_no as contract_no,p.volume_number as volumeNumber,p.commission_case_day as commissionCaseDay,p.description as description,p.create_id as createId,p.create_time as createTime,pp.if_update as ifUpdate,pp.crons as crons, p.entrust_type as entrustType,p.entrust_id as entrustId,p.head_id as headId,p.department_id as departmentId from patent_project as pp left join project as p on pp.project_id =p.id left join asso_project_tree_node as aspt on p.id =aspt.project_id left join asso_project_event as aspe on p.id = aspe.project_id order by p.create_time desc limit 0,10
  32. [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:22.884 DEBUG 7368 [http-nio-8877-exec-9] cn.cslg.pas.mapper.PatentProjectMapper.getPatentProject ==> Parameters:
  33. [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:22.888 DEBUG 7368 [http-nio-8877-exec-9] cn.cslg.pas.mapper.PatentProjectMapper.getPatentProject <== Total: 9
  34. [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:22.888 DEBUG 7368 [http-nio-8877-exec-9] cn.cslg.pas.mapper.PatentProjectMapper.getPatentProjectCount ==> Preparing: select count(*) from (select distinct p.id from patent_project as pp left join project as p on pp.project_id =p.id left join asso_project_tree_node as aspt on p.id =aspt.project_id left join asso_project_event as aspe on p.id =aspe.project_id ) as c
  35. [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:22.889 DEBUG 7368 [http-nio-8877-exec-9] cn.cslg.pas.mapper.PatentProjectMapper.getPatentProjectCount ==> Parameters:
  36. [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:22.891 DEBUG 7368 [http-nio-8877-exec-9] cn.cslg.pas.mapper.PatentProjectMapper.getPatentProjectCount <== Total: 1
  37. [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:24.414 DEBUG 7368 [http-nio-8877-exec-2] cn.cslg.pas.mapper.EventMapper.getEvent ==> Preparing: select id,name,description,client_id as clientId,scenario_id as scenarioId,event_date as eventDate,create_id as createId,create_time as createTime from event order by create_time desc limit 0,10
  38. [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:24.415 DEBUG 7368 [http-nio-8877-exec-2] cn.cslg.pas.mapper.EventMapper.getEvent ==> Parameters:
  39. [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:24.418 DEBUG 7368 [http-nio-8877-exec-2] cn.cslg.pas.mapper.EventMapper.getEvent <== Total: 10
  40. [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:24.419 DEBUG 7368 [http-nio-8877-exec-2] cn.cslg.pas.mapper.EventMapper.getEventCount ==> Preparing: select count(*) from event
  41. [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:24.419 DEBUG 7368 [http-nio-8877-exec-2] cn.cslg.pas.mapper.EventMapper.getEventCount ==> Parameters:
  42. [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:24.421 DEBUG 7368 [http-nio-8877-exec-2] cn.cslg.pas.mapper.EventMapper.getEventCount <== Total: 1
  43. [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:24.424 DEBUG 7368 [http-nio-8877-exec-2] cn.cslg.pas.mapper.AssoEventFileMapper.selectList ==> Preparing: SELECT id,event_id,file_guid,create_id,create_time FROM asso_event_file WHERE (event_id IN (?,?,?,?,?,?,?,?,?,?))
  44. [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:24.424 DEBUG 7368 [http-nio-8877-exec-2] cn.cslg.pas.mapper.AssoEventFileMapper.selectList ==> Parameters: 70(Integer), 69(Integer), 68(Integer), 67(Integer), 66(Integer), 65(Integer), 64(Integer), 62(Integer), 61(Integer), 60(Integer)
  45. [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:24.427 DEBUG 7368 [http-nio-8877-exec-2] cn.cslg.pas.mapper.AssoEventFileMapper.selectList <== Total: 2
  46. [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:24.429 DEBUG 7368 [http-nio-8877-exec-2] cn.cslg.pas.mapper.AssoProjectEventMapper.getEventProjectCount ==> Preparing: select event_id as eventId,project_type as projectType,count(*) as projectCount from pas_prod2.asso_project_event WHERE event_id in ( ? or ? or ? or ? or ? or ? or ? or ? or ? or ? ) group by event_id,project_type
  47. [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:24.430 DEBUG 7368 [http-nio-8877-exec-2] cn.cslg.pas.mapper.AssoProjectEventMapper.getEventProjectCount ==> Parameters: 70(Integer), 69(Integer), 68(Integer), 67(Integer), 66(Integer), 65(Integer), 64(Integer), 62(Integer), 61(Integer), 60(Integer)
  48. [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:24.432 DEBUG 7368 [http-nio-8877-exec-2] cn.cslg.pas.mapper.AssoProjectEventMapper.getEventProjectCount <== Total: 0
  49. [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:28.104 DEBUG 7368 [http-nio-8877-exec-5] cn.cslg.pas.mapper.ProjectTaskMapper.getProjectTask ==> Preparing: select id,name,project_id,type,handler,handler_type as handlerType,deadline_time as deadLineTime,finish_time as finishTime, description, last_task_id as lastTaskId,asso_task_id as assoTaskId,status,process_id as processId,progress,result,create_id as createId,create_time as createTime from project_task order by create_time desc limit 0,10
  50. [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:28.104 DEBUG 7368 [http-nio-8877-exec-5] cn.cslg.pas.mapper.ProjectTaskMapper.getProjectTask ==> Parameters:
  51. [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:28.109 DEBUG 7368 [http-nio-8877-exec-5] cn.cslg.pas.mapper.ProjectTaskMapper.getProjectTask <== Total: 10
  52. [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:28.110 DEBUG 7368 [http-nio-8877-exec-5] cn.cslg.pas.mapper.ProjectTaskMapper.getProjectTaskCount ==> Preparing: select count(*) from project_task
  53. [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:28.110 DEBUG 7368 [http-nio-8877-exec-5] cn.cslg.pas.mapper.ProjectTaskMapper.getProjectTaskCount ==> Parameters:
  54. [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:28.112 DEBUG 7368 [http-nio-8877-exec-5] cn.cslg.pas.mapper.ProjectTaskMapper.getProjectTaskCount <== Total: 1
  55. [pas:0.0.0.0:8877] [,] 2023-12-26 10:10:57.794 DEBUG 18752 [http-nio-8877-exec-1] cn.cslg.pas.mapper.ReportAffairMapper.selectList ==> Preparing: SELECT id,affair_type,project_id,occurred_time,description,create_id,create_time FROM report_affair WHERE (project_id = ?)
  56. [pas:0.0.0.0:8877] [,] 2023-12-26 10:10:57.800 DEBUG 18752 [http-nio-8877-exec-1] cn.cslg.pas.mapper.ReportAffairMapper.selectList ==> Parameters: 101(Integer)
  57. [pas:0.0.0.0:8877] [,] 2023-12-26 10:10:57.809 DEBUG 18752 [http-nio-8877-exec-1] cn.cslg.pas.mapper.ReportAffairMapper.selectList <== Total: 0
  58. [pas:0.0.0.0:8877] [,] 2023-12-26 10:10:57.822 DEBUG 18752 [http-nio-8877-exec-2] cn.cslg.pas.mapper.ReportProjectMapper.getReportProject ==> Preparing: select distinct p.id as id,p.name as name ,rp.sign_patent_no as signPatentNo,p.contract_no as contract_no,p.volume_number as volumeNumber,p.commission_case_day as commissionCaseDay,p.description as description,p.create_id as createId,p.create_time as createTime, rp.report_type as reportType ,p.head_id as headId,p.department_id as departmentId, p.entrust_type as entrustType,p.entrust_id as entrustId,rp.product_or_tech as productOrTech,rp.cron_description as cronDescription ,rp.status as status from report as rp left join project as p on rp.project_id =p.id left join asso_report_cron arc on p.id =arc.project_id left join asso_project_event as aspe on p.id =aspe.project_id where p.id='101'
  59. [pas:0.0.0.0:8877] [,] 2023-12-26 10:10:57.823 DEBUG 18752 [http-nio-8877-exec-2] cn.cslg.pas.mapper.ReportProjectMapper.getReportProject ==> Parameters:
  60. [pas:0.0.0.0:8877] [,] 2023-12-26 10:10:57.830 DEBUG 18752 [http-nio-8877-exec-2] cn.cslg.pas.mapper.ReportProjectMapper.getReportProject <== Total: 1