禅道首页地盘仪表盘全空解决中 悬赏5积分

打开debug后日志内容如下，能帮忙看看是什么问题造成的吗
<?php
die();
19:35:25 schedule
cronId: 2
e x e cId: 1179207321
output: push task to queue

19:35:25 schedule
cronId: 3
e x e cId: 1179207321
output: push task to queue

19:35:25 schedule
cronId: 4
e x e cId: 1179207321
output: push task to queue

19:35:25 schedule
cronId: 7
e x e cId: 1179207321
output: push task to queue

19:35:25 schedule
cronId: 8
e x e cId: 1179207321
output: push task to queue

19:35:25 schedule
cronId: 9
e x e cId: 1179207321
output: push task to queue

19:35:25 schedule
cronId: 10
e x e cId: 1179207321
output: push task to queue

19:35:25 schedule
cronId: 11
e x e cId: 1179207321
output: push task to queue

19:35:25 schedule
cronId: 12
e x e cId: 1179207321
output: push task to queue

19:35:25 schedule
cronId: 13
e x e cId: 1179207321
output: push task to queue

19:35:25 schedule
cronId: 14
e x e cId: 1179207321
output: push task to queue

19:35:25 schedule
cronId: 15
e x e cId: 1179207321
output: push task to queue

19:35:25 schedule
cronId: 16
e x e cId: 1179207321
output: push task to queue

19:35:25 schedule
cronId: 17
e x e cId: 1179207321
output: push task to queue

19:35:25 schedule
cronId: 18
e x e cId: 1179207321
output: push task to queue

19:35:25 schedule
cronId: 19
e x e cId: 1179207321
output: push task to queue

19:35:25 schedule
cronId: 21
e x e cId: 1179207321
output: push task to queue

19:35:25 schedule
cronId: 22
e x e cId: 1179207321
output: push task to queue

19:35:25 schedule
cronId: 23
e x e cId: 1179207321
output: push task to queue

19:35:25 schedule
cronId: 24
e x e cId: 1179207321
output: push task to queue

19:35:25 e x e cute
cronId: 2
e x e cId: 1179207321
taskId: 978
command: moduleName=e x e cution&methodName=computeburn
return :
output : {"3":{"e x e cution":"3","date":"2024-10-24","estimate":22,"left":22,"consumed":"19","product":0,"task":0,"e x e cutionName":""},"8":{"e x e cution":"8","date":"2024-10-24","estimate":"0","left":"405.5","consumed":"54.5","product":0,"task":0,"storyPoint":"480","e x e cutionName":""}}

19:35:25 e x e cute
cronId: 3
e x e cId: 1179207321
taskId: 979
command: moduleName=e x e cution&methodName=computecfd
return :
output :

19:35:25 e x e cute
cronId: 4
e x e cId: 1179207321
taskId: 980
command: moduleName=report&methodName=remind
return :
output : You should turn on the Email feature first.


19:35:48 e x e cute
cronId: 7
e x e cId: 1179207321
taskId: 981
command: moduleName=backup&methodName=backup
return :
output : 备份成功！


19:35:48 e x e cute
cronId: 8
e x e cId: 1179207321
taskId: 982
command: moduleName=mail&methodName=asyncSend
return :
output :

19:35:48 e x e cute
cronId: 9
e x e cId: 1179207321
taskId: 983
command: moduleName=webhook&methodName=asyncSend
return :
output : NO WEBHOOK EXIST.


19:35:48 e x e cute
cronId: 10
e x e cId: 1179207321
taskId: 984
command: moduleName=admin&methodName=deleteLog
return :
output :

19:35:48 e x e cute
cronId: 11
e x e cId: 1179207321
taskId: 985
command: moduleName=todo&methodName=createCycle
return :
output :

19:35:48 e x e cute
cronId: 12
e x e cId: 1179207321
taskId: 986
command: moduleName=ci&methodName=initQueue
return :
output : success

19:35:48 e x e cute
cronId: 13
e x e cId: 1179207321
taskId: 987
command: moduleName=ci&methodName=checkCompileStatus
return :
output : {"result":"success","load":"\/www\/index.php?m=compile&f=logs&compileID=0"}

19:35:48 e x e cute
cronId: 14
e x e cId: 1179207321
taskId: 988
command: moduleName=ci&methodName=e x e c
return :
output : success

19:35:48 e x e cute
cronId: 15
e x e cId: 1179207321
taskId: 989
command: moduleName=mr&methodName=syncMR
return :
output : success

19:35:48 e x e cute
cronId: 16
e x e cId: 1179207321
taskId: 990
command: moduleName=compile&methodName=syncCompile
return :
output : success

19:35:48 e x e cute
cronId: 17
e x e cId: 1179207321
taskId: 991
command: moduleName=misc&methodName=cleanCache
return :
output : Cache is disabled.

19:37:43 schedule
cronId: 8
e x e cId: 2022841695
output: push task to queue

19:37:43 schedule
cronId: 9
e x e cId: 2022841695
output: push task to queue

19:37:43 e x e cute
cronId: 19
e x e cId: 2022841695
taskId: 993
command: moduleName=e x e cution&methodName=computeTaskEffort
return :
output :

19:37:46 e x e cute
cronId: 21
e x e cId: 2022841695
taskId: 994
command: moduleName=metric&methodName=updateMetricLib
return :
output : success

19:37:48 e x e cute
cronId: 22
e x e cId: 2022841695
taskId: 995
command: moduleName=metric&methodName=updateDashboardMetricLib
return :
output : success

19:37:48 e x e cute
cronId: 23
e x e cId: 2022841695
taskId: 996
command: moduleName=program&methodName=refreshStats
return :
output : success

19:37:48 e x e cute
cronId: 24
e x e cId: 2022841695
taskId: 997
command: moduleName=product&methodName=refreshStats
return :
output : success

19:37:48 e x e cute
cronId: 8
e x e cId: 2022841695
taskId: 998
command: moduleName=mail&methodName=asyncSend
return :
output :

19:37:48 e x e cute
cronId: 9
e x e cId: 2022841695
taskId: 999
command: moduleName=webhook&methodName=asyncSend
return :
output : NO WEBHOOK EXIST.


19:38:08 schedule
cronId: 8
e x e cId: 2022841695
output: push task to queue

19:38:08 schedule
cronId: 9
e x e cId: 2022841695
output: push task to queue

19:38:08 e x e cute
cronId: 8
e x e cId: 2022841695
taskId: 1000
command: moduleName=mail&methodName=asyncSend
return :
output :

19:38:08 e x e cute
cronId: 9
e x e cId: 2022841695
taskId: 1001
command: moduleName=webhook&methodName=asyncSend
return :
output : NO WEBHOOK EXIST.

还有一个日志如下
<?php
die();
?>
2024-10-24 19:37:43 ----------------------------------
2024-10-24 19:37:43 | The new task: updateMetricLib. |
2024-10-24 19:37:43 ----------------------------------
2024-10-24 19:37:43 Calculate consumed time: 0.082695960998535 seconds, the sql: SELECT `t1`.`project` AS `t1_project`,`t1`.`closedDate` AS `t1_closedDate`,`t1`.`realEnd` AS `t1_realEnd`,`t1`.`status` AS `t1_status`,`t1`.`id` AS `t1_id`,`t1`.`progress` AS `t1_progress`,`t1`.`openedDate` AS `t1_openedDate`,`t1`.`firstEnd` AS `t1_firstEnd` FROM `zt_project` AS t1 LEFT JOIN `zt_project` AS t2 ON t1.project=t2.id WHERE t1.deleted = '0' AND t2.deleted = '0' AND t1.type IN ('sprint','stage','kanban') AND t1.multiple = '1' AND t2.type = 'project' AND ( t1.vision LIKE '%rnd%' OR t1.vision IS NULL ), the codes: count_annual_closed_e x e cution_in_project,count_of_annual_finished_e x e cution_in_project,count_of_closed_e x e cution_in_project,count_of_doing_e x e cution_in_project,count_of_e x e cution_in_project,count_of_suspended_e x e cution_in_project,count_wait_e x e cution_in_project,progress_of_task_in_e x e cution,count_of_annual_closed_e x e cution,count_of_annual_created_e x e cution,count_of_annual_finished_e x e cution,count_of_closed_e x e cution,count_of_delayed_finished_e x e cution_which_annual_finished,count_of_delayed_finished_e x e cution_which_finished,count_of_doing_e x e cution,count_of_e x e cution,count_of_monthly_closed_e x e cution,count_of_monthly_created_e x e cution,count_of_suspended_e x e cution,count_of_unclosed_e x e cution,count_of_undelayed_finished_e x e cution_which_annual_finished,count_of_undelayed_finished_e x e cution_which_finished,count_of_wait_e x e cution,rate_of_delayed_closed_e x e cution_which_annual_finished,rate_of_undelayed_closed_e x e cution_which_annual_finished
2024-10-24 19:37:43 Calculate consumed time: 0.01099705696106 seconds, the sql: SELECT `t1`.`status` AS `t1_status`,`t1`.`project` AS `t1_project` FROM `zt_bug` AS t1 LEFT JOIN `zt_product` AS t2 ON t1.product=t2.id LEFT JOIN `zt_project` AS t3 ON t1.project=t3.id WHERE t1.deleted = '0' AND t2.deleted = '0' AND t3.deleted = '0' AND ( t3.vision LIKE '%rnd%' OR t3.vision IS NULL ), the codes: count_of_activated_bug_in_project,count_of_bug_in_project,count_of_closed_bug_in_project
2024-10-24 19:37:43 Calculate consumed time: 0.022854089736938 seconds, the sql: SELECT `t3`.`project` AS `t3_project`,`t1`.`closedDate` AS `t1_closedDate`,`t1`.`closedReason` AS `t1_closedReason`,`t1`.`status` AS `t1_status`,`t1`.`estimate` AS `t1_estimate`,`t1`.`parent` AS `t1_parent`,t2.id as product,`t3`.`story` AS `t3_story` FROM `zt_story` AS t1 LEFT JOIN `zt_product` AS t2 ON t1.product=t2.id LEFT JOIN `zt_projectstory` AS t3 ON t1.id=t3.story LEFT JOIN `zt_project` AS t4 ON t3.project=t4.id WHERE t1.deleted = '0' AND t2.deleted = '0' AND t1.type = 'story' AND t4.deleted = '0' AND t1.isParent = '0' AND t4.type = 'project' AND ( t1.vision LIKE '%rnd%' OR t1.vision IS NULL ), the codes: count_of_annual_finished_story_in_project,count_of_closed_story_in_project,count_of_invalid_story_in_project,count_of_story_in_project,count_of_valid_story_in_project,scale_of_annual_finished_story_in_project,rate_of_finished_story_in_project,count_of_projected_story_in_product
2024-10-24 19:37:43 Calculate consumed time: 0.012781143188477 seconds, the sql: SELECT `t2`.`project` AS `t2_project`,`t1`.`status` AS `t1_status`,`t1`.`closedReason` AS `t1_closedReason` FROM `zt_story` AS t1 LEFT JOIN `zt_projectstory` AS t2 ON t1.id=t2.story LEFT JOIN `zt_project` AS t3 ON t2.project=t3.id WHERE t1.deleted = '0' AND t3.deleted = '0' AND t1.type = 'epic' AND t3.type = 'project' AND ( t1.vision LIKE '%rnd%' OR t1.vision IS NULL ), the codes: count_of_closed_epic_in_project,count_of_epic_in_project,count_of_finished_epic_in_project,count_of_unclosed_epic_in_project
2024-10-24 19:37:43 Calculate consumed time: 0.013113021850586 seconds, the sql: SELECT `t3`.`project` AS `t3_project`,`t1`.`status` AS `t1_status`,`t1`.`closedReason` AS `t1_closedReason` FROM `zt_story` AS t1 LEFT JOIN `zt_product` AS t2 ON t1.product=t2.id LEFT JOIN `zt_projectstory` AS t3 ON t1.id=t3.story LEFT JOIN `zt_project` AS t4 ON t3.project=t4.id WHERE t1.deleted = '0' AND t2.deleted = '0' AND t1.type = 'r e q u i r ement' AND t4.deleted = '0' AND t4.type = 'project' AND ( t1.vision LIKE '%rnd%' OR t1.vision IS NULL ), the codes: count_of_closed_r e q u i r ement_in_project,count_of_finished_r e q u i r ement_in_project,count_of_r e q u i r ement_in_project,count_of_unclosed_r e q u i r ement_in_project
2024-10-24 19:37:43 Calculate consumed time: 0.09679913520813 seconds, the sql: SELECT `t1`.`status` AS `t1_status`,`t1`.`project` AS `t1_project`,`t1`.`consumed` AS `t1_consumed`,`t1`.`parent` AS `t1_parent`,`t1`.`estimate` AS `t1_estimate`,`t1`.`left` AS `t1_left`,`t1`.`finishedDate` AS `t1_finishedDate`,`t1`.`e x e cution` AS `t1_e x e cution`,`t1`.`type` AS `t1_type`,`t1`.`closedReason` AS `t1_closedReason`,IF(t1.finishedDate, t1.finishedDate, t1.closedDate) AS finishedDate,t2.closedDate AS e x e cutionClosedDate,`t1`.`openedDate` AS `t1_openedDate`,`t2`.`realBegan` AS `t2_realBegan`,`t1`.`fromBug` AS `t1_fromBug`,`t1`.`closedDate` AS `t1_closedDate`,if(t2.multiple = '1', t2.closedDate, t3.closedDate) as e x e cutionClosed,`t1`.`finishedBy` AS `t1_finishedBy`,t3.status as projectStatus,t2.status as e x e cutionStatus,`t1`.`id` AS `t1_id`,`t3`.`status` AS `t3_status`,`t3`.`closedDate` AS `t3_closedDate`,`t2`.`status` AS `t2_status` FROM `zt_task` AS t1 LEFT JOIN `zt_project` AS t2 ON t1.e x e cution=t2.id LEFT JOIN `zt_project` AS t3 ON t2.project=t3.id WHERE t2.type IN ('sprint','kanban','stage') AND t1.deleted = '0' AND t2.deleted = '0' AND t3.deleted = '0' AND ( t1.vision LIKE '%rnd%' OR t1.vision IS NULL ), the codes: count_of_doing_task_in_project,count_of_finished_task_in_project,count_of_task_in_project,count_of_wait_task_in_project,consume_of_task_in_project,estimate_of_task_in_project,left_of_task_in_project,progress_of_task_in_project,count_of_daily_finished_task_in_e x e cution,count_of_finished_task_in_e x e cution,count_of_finished_test_task_in_e x e cution_when_closing,count_of_task_in_e x e cution,count_of_test_task_in_e x e cution,count_of_test_task_in_e x e cution_when_starting,count_of_unfinished_task_in_e x e cution,consume_of_devel_task_in_e x e cution,consume_of_frombug_task_in_e x e cution,consume_of_task_in_e x e cution,consume_of_test_task_in_e x e cution,estimate_of_task_in_e x e cution,left_of_task_in_e x e cution,consume_rate_of_frombug_task_in_e x e cution,rate_of_finished_test_task_in_e x e cution_when_closing,count_of_daily_finished_task_in_user,count_of_annual_created_task,count_of_annual_finished_task,count_of_closed_task,count_of_daily_finished_task,count_of_finished_task,count_of_monthly_created_task,count_of_monthly_finished_task,count_of_task,count_of_unfinished_task,consume_of_task,estimate_of_annual_closed_project,estimate_of_task,left_of_task
2024-10-24 19:37:43 Calculate consumed time: 0.010501861572266 seconds, the sql: SELECT `t3`.`project` AS `t3_project`,`t1`.`closedReason` AS `t1_closedReason`,`t1`.`status` AS `t1_status`,`t1`.`estimate` AS `t1_estimate`,`t1`.`isParent` AS `t1_isParent` FROM `zt_story` AS t1 LEFT JOIN `zt_product` AS t2 ON t1.product=t2.id LEFT JOIN `zt_projectstory` AS t3 ON t1.id=t3.story LEFT JOIN `zt_project` AS t4 ON t3.project=t4.id WHERE t1.deleted = '0' AND t2.deleted = '0' AND t4.deleted = '0' AND t4.type = 'project' AND ( t1.vision LIKE '%rnd%' OR t1.vision IS NULL ), the codes: count_of_finished_story_in_project,count_of_unclosed_story_in_project,scale_of_story_in_project
2024-10-24 19:37:43 Calculate consumed time: 0.0072860717773438 seconds, the sql: SELECT t3.id as project,`t1`.`account` AS `t1_account`,`t2`.`id` AS `t2_id`,`t1`.`days` AS `t1_days`,`t1`.`hours` AS `t1_hours`,`t4`.`role` AS `t4_role` FROM `zt_team` AS t1 LEFT JOIN `zt_project` AS t2 ON t2.id=t1.root LEFT JOIN `zt_project` AS t3 ON t3.id=t2.project LEFT JOIN `zt_user` AS t4 ON t1.account=t4.account WHERE t1.type = 'e x e cution' AND t2.deleted = '0' AND t3.deleted = '0' AND t4.deleted = '0' AND ( t3.vision LIKE '%rnd%' OR t3.vision IS NULL ), the codes: count_of_user_in_project,hour_of_developer_available_in_e x e cution
2024-10-24 19:37:43 Calculate consumed time: 0.0042779445648193 seconds, the sql: SELECT `t1`.`project` AS `t1_project`,`t1`.`date` AS `t1_date`,`t1`.`consumed` AS `t1_consumed` FROM `zt_effort` AS t1 LEFT JOIN `zt_project` AS t2 ON t1.project = t2.id WHERE t1.deleted = '0' AND t2.deleted = '0' AND t2.model = 'waterfall' AND t2.type = 'project' AND ( t2.vision LIKE '%rnd%' OR t2.vision IS NULL ), the codes: ac_of_weekly_all_in_waterfall
2024-10-24 19:37:43 Calculate consumed time: 0.007716178894043 seconds, the sql: SELECT t3.id as project,`t1`.`consumed` AS `t1_consumed`, 8 as defaultHours FROM `zt_effort` AS t1 LEFT JOIN `zt_project` AS t2 ON t1.e x e cution=t2.id LEFT JOIN `zt_project` AS t3 ON t2.project=t3.id WHERE t1.deleted = '0' AND t3.deleted = '0' AND t3.type = 'project' AND ( t3.vision LIKE '%rnd%' OR t3.vision IS NULL ), the codes: consume_of_all_in_project,day_of_invested_in_project
2024-10-24 19:37:43 Calculate consumed time: 0.0070688724517822 seconds, the sql: SELECT `t1`.`project` AS `t1_project`,`t1`.`estimate` AS `t1_estimate`,`t1`.`consumed` AS `t1_consumed`,`t1`.`left` AS `t1_left`,`t1`.`status` AS `t1_status`,`t1`.`closedReason` AS `t1_closedReason`,`t1`.`id` AS `t1_id`,`t1`.`estStarted` AS `t1_estStarted`,`t1`.`deadline` AS `t1_deadline`,t2.begin as e x e cutionBegin,t2.end as e x e cutionEnd,t3.id as project FROM `zt_task` AS t1 LEFT JOIN `zt_project` AS t2 ON t1.e x e cution = t2.id LEFT JOIN `zt_project` AS t3 ON t2.project = t3.id WHERE t1.parent >= '0' AND t1.deleted = '0' AND t1.status != 'cancel' AND t2.deleted = '0' AND t3.type = 'project' AND t3.model IN ('waterfall','waterfallplus') AND ( t3.vision LIKE '%rnd%' OR t3.vision IS NULL ), the codes: ev_of_weekly_finished_task_in_waterfall,pv_of_weekly_task_in_waterfall
2024-10-24 19:37:43 Calculate consumed time: 0.052540063858032 seconds, the sql: SELECT `t1`.`id` AS `t1_id`,`t1`.`realBegan` AS `t1_realBegan`,`t1`.`realEnd` AS `t1_realEnd`,`t1`.`status` AS `t1_status`,`t1`.`end` AS `t1_end`,`t1`.`begin` AS `t1_begin`,`t1`.`closedDate` AS `t1_closedDate`,`t1`.`openedDate` AS `t1_openedDate`,`t1`.`firstEnd` AS `t1_firstEnd` FROM `zt_project` AS t1 WHERE `deleted` = '0' AND `type` = 'project' AND ( t1.vision LIKE '%rnd%' OR t1.vision IS NULL ), the codes: count_of_actual_time_in_project,left_period_of_project,planned_period_of_project,variance_of_time_in_project,count_of_annual_closed_project,count_of_annual_created_project,count_of_annual_finished_project,count_of_closed_project,count_of_delayed_finished_project_which_annual_finished,count_of_delayed_finished_project_which_finished,count_of_doing_project,count_of_monthly_closed_project,count_of_monthly_created_project,count_of_project,count_of_suspended_project,count_of_unclosed_project,count_of_undelayed_finished_project_which_annual_finished,count_of_undelayed_finished_project_which_annual_started,count_of_undelayed_finished_project_which_finished,count_of_wait_project,rate_of_delayed_finished_project_which_annual_finished,rate_of_undelayed_finished_project_which_annual_finished
2024-10-24 19:37:43 Calculate consumed time: 0.085012912750244 seconds, the sql: SELECT `t1`.`product` AS `t1_product`,`t3`.`case_count` AS `t3_case_count`,`t1`.`closedDate` AS `t1_closedDate`,`t1`.`status` AS `t1_status`,`t1`.`openedDate` AS `t1_openedDate`,`t1`.`stage` AS `t1_stage`,`t1`.`releasedDate` AS `t1_releasedDate`,`t1`.`closedReason` AS `t1_closedReason`,`t1`.`estimate` AS `t1_estimate`,`t1`.`parent` AS `t1_parent`,`t1`.`id` AS `t1_id`,`t1`.`reviewedBy` AS `t1_reviewedBy`,`t1`.`reviewedDate` AS `t1_reviewedDate` FROM `zt_story` AS t1 LEFT JOIN `zt_product` AS t2 ON t1.product=t2.id LEFT JOIN `tmp_case_getDevStories` AS t3 ON t1.id=t3.story WHERE t1.deleted = '0' AND t2.deleted = '0' AND t1.type = 'story' AND t1.isParent = '0' AND t2.shadow = '0' AND ( t1.vision LIKE '%rnd%' OR t1.vision IS NULL ), the codes: case_coverage_of_projected_story_in_product,count_of_annual_closed_story_in_product,count_of_annual_created_story_in_product,count_of_annual_delivered_story_in_product,count_of_annual_finished_story_in_product,count_of_closed_story_in_product,count_of_delivered_story_in_product,count_of_developed_story_in_product,count_of_finished_story_in_product,count_of_invalid_story_in_product,count_of_monthly_closed_story_in_product,count_of_monthly_created_story_in_product,count_of_monthly_delivered_story_in_product,count_of_monthly_finished_story_in_product,count_of_story_in_product,count_of_unclosed_story_in_product,count_of_valid_story_in_product,scale_of_annual_closed_story_in_product,scale_of_annual_delivered_story_in_product,scale_of_annual_finished_story_in_product,scale_of_developed_story_in_product,scale_of_monthly_finished_story_in_product,scale_of_story_in_product,rate_of_delivery_story_in_product,rate_of_finish_story_in_product,count_of_daily_review_story_in_user
2024-10-24 19:37:44 Calculate consumed time: 0.049198150634766 seconds, the sql: SELECT `t1`.`product` AS `t1_product`,`t1`.`status` AS `t1_status`,`t1`.`openedDate` AS `t1_openedDate`,`t1`.`resolution` AS `t1_resolution`,`t1`.`closedDate` AS `t1_closedDate`,`t1`.`resolvedDate` AS `t1_resolvedDate`,`t1`.`severity` AS `t1_severity`, 7 as longlife FROM `zt_bug` AS t1 LEFT JOIN `zt_product` AS t2 ON t1.product=t2.id WHERE t1.deleted = '0' AND t2.deleted = '0' AND t2.shadow = '0' AND ( t2.vision LIKE '%rnd%' OR t2.vision IS NULL ), the codes: count_of_activated_bug_in_product,count_of_annual_created_bug_in_product,count_of_annual_created_effective_bug_in_product,count_of_annual_fixed_bug_in_product,count_of_bug_in_product,count_of_daily_closed_bug_in_product,count_of_daily_created_bug_in_product,count_of_daily_resolved_bug_in_product,count_of_effective_bug_in_product,count_of_fixed_bug_in_product,count_of_monthly_closed_bug_in_product,count_of_monthly_created_bug_in_product,count_of_monthly_fixed_bug_in_product,count_of_severe_bug_in_product,count_of_severity_1_bug_in_product,count_of_severity_2_bug_in_product,rate_of_fixed_bug_in_product
2024-10-24 19:37:44 Calculate consumed time: 0.0078690052032471 seconds, the sql: SELECT `t1`.`product` AS `t1_product`,`t1`.`openedDate` AS `t1_openedDate` FROM `zt_case` AS t1 LEFT JOIN `zt_product` AS t2 ON t1.product=t2.id WHERE t1.deleted = '0' AND t2.deleted = '0' AND t2.shadow = '0' AND ( t2.vision LIKE '%rnd%' OR t2.vision IS NULL ), the codes: count_of_annual_created_case_in_product,count_of_case_in_product
2024-10-24 19:37:44 Calculate consumed time: 0.01160192489624 seconds, the sql: SELECT `t1`.`product` AS `t1_product`,`t1`.`createdDate` AS `t1_createdDate`,`t1`.`finishedDate` AS `t1_finishedDate`,`t1`.`id` AS `t1_id` FROM `zt_productplan` AS t1 LEFT JOIN `zt_product` AS t2 ON t1.product=t2.id WHERE t1.deleted = '0' AND t2.deleted = '0' AND t2.shadow = '0' AND ( t2.vision LIKE '%rnd%' OR t2.vision IS NULL ), the codes: count_of_annual_created_productplan_in_product,count_of_annual_finished_productplan_in_product,count_of_productplan_in_product
2024-10-24 19:37:44 Calculate consumed time: 0.010037899017334 seconds, the sql: SELECT `t1`.`id` AS `t1_id`,`t1`.`product` AS `t1_product`,`t1`.`date` AS `t1_date` FROM `zt_release` AS t1 LEFT JOIN `zt_product` AS t2 ON t1.product=t2.id WHERE t1.deleted = '0' AND t2.deleted = '0' AND t2.shadow = '0' AND ( t2.vision LIKE '%rnd%' OR t2.vision IS NULL ), the codes: count_of_annual_created_release_in_product,count_of_monthly_created_release_in_product,count_of_release_in_product
2024-10-24 19:37:44 Calculate consumed time: 0.011659145355225 seconds, the sql: SELECT `t1`.`product` AS `t1_product`,`t1`.`type` AS `t1_type`,`t1`.`openedDate` AS `t1_openedDate`,`t1`.`status` AS `t1_status`,`t1`.`closedReason` AS `t1_closedReason`,`t1`.`closedDate` AS `t1_closedDate`,`t1`.`estimate` AS `t1_estimate`,`t1`.`parent` AS `t1_parent` FROM `zt_story` AS t1 LEFT JOIN `zt_product` AS t2 ON t1.product=t2.id WHERE t1.deleted = '0' AND t2.deleted = '0' AND t2.shadow = '0' AND ( t1.vision LIKE '%rnd%' OR t1.vision IS NULL ), the codes: count_of_annual_created_r e q u i r ement_in_product,count_of_r e q u i r ement_in_product,count_of_weekly_finished_story,scale_of_weekly_finished_story
2024-10-24 19:37:44 Calculate consumed time: 0.0045721530914307 seconds, the sql: SELECT `t1`.`product` AS `t1_product`,`t1`.`story` AS `t1_story` FROM `zt_case` AS t0 LEFT JOIN `zt_projectstory` AS t1 ON t1.story=t0.story LEFT JOIN `zt_story` AS t2 ON t1.story=t2.id LEFT JOIN `zt_product` AS t3 ON t1.product=t3.id WHERE t2.deleted = '0' AND t3.deleted = '0' AND ( t2.vision LIKE '%rnd%' OR t2.vision IS NULL ), the codes: count_of_projected_story_with_case_in_product
2024-10-24 19:37:44 Calculate consumed time: 0.0077431201934814 seconds, the sql: SELECT `t2`.`product` AS `t2_product`,`t1`.`result` AS `t1_result`,`t1`.`reviewer` AS `t1_reviewer`,`t1`.`story` AS `t1_story`,`t1`.`version` AS `t1_version`,`t2`.`status` AS `t2_status` FROM `zt_storyreview` AS t1 LEFT JOIN `zt_story` AS t2 ON t1.story=t2.id LEFT JOIN `zt_product` AS t3 ON t2.product=t3.id WHERE t2.deleted = '0' AND t3.deleted = '0' AND t2.type = 'story' AND ( t3.vision LIKE '%rnd%' OR t3.vision IS NULL ), the codes: rate_of_approved_story_in_product,count_of_reviewing_story_in_user
2024-10-24 19:37:44 Calculate consumed time: 0.0052988529205322 seconds, the sql: SELECT t2.project as e x e cution,`t1`.`expect` AS `t1_expect` FROM `zt_casestep` AS t1 LEFT JOIN `zt_projectcase` AS t2 ON t1.case = t2.case LEFT JOIN `zt_case` AS t3 ON t2.case = t3.id and t1.version = t3.version LEFT JOIN `zt_project` AS t5 ON t5.id = t2.project LEFT JOIN `zt_project` AS t6 ON t6.id = t5.project WHERE t3.deleted = '0' AND t5.deleted = '0' AND t6.deleted = '0' AND t5.type IN ('sprint','kanban','stage') AND ( t5.vision LIKE '%rnd%' OR t5.vision IS NULL ), the codes: count_of_case_expect_in_e x e cution
2024-10-24 19:37:44 Calculate consumed time: 0.0042450428009033 seconds, the sql: SELECT t4.id as e x e cution FROM `zt_projectcase` AS t1 LEFT JOIN `zt_case` AS t2 ON t1.case = t2.id LEFT JOIN `zt_project` AS t4 ON t4.id = t1.project LEFT JOIN `zt_project` AS t5 ON t5.id = t4.project WHERE t4.deleted = '0' AND t2.deleted = '0' AND t5.deleted = '0' AND t4.type IN ('sprint','kanban','stage') AND ( t4.vision LIKE '%rnd%' OR t4.vision IS NULL ), the codes: count_of_case_in_e x e cution
2024-10-24 19:37:44 Calculate consumed time: 0.024025917053223 seconds, the sql: SELECT t4.id as e x e cution,`t1`.`id` AS `t1_id`,if(t4.multiple = '1', t4.closedDate, t5.closedDate) as e x e cutionClosed,t1.closedDate as storyClosedDate,t1.releasedDate as storyReleasedDate,`t1`.`closedReason` AS `t1_closedReason`,`t3`.`project` AS `t3_project`,`t1`.`stage` AS `t1_stage`,`t1`.`verifiedDate` AS `t1_verifiedDate`,`t1`.`releasedDate` AS `t1_releasedDate`,t1.closedDate AS storyClosedDate,`t1`.`estimate` AS `t1_estimate`,`t1`.`isParent` AS `t1_isParent` FROM `zt_story` AS t1 LEFT JOIN `zt_product` AS t2 ON t1.product=t2.id LEFT JOIN `zt_projectstory` AS t3 ON t1.id=t3.story LEFT JOIN `zt_project` AS t4 ON t3.project=t4.id LEFT JOIN `zt_project` AS t5 ON t4.project=t5.id WHERE t1.deleted = '0' AND t2.deleted = '0' AND t1.type = 'story' AND t4.deleted = '0' AND t4.type IN ('sprint','stage','kanban') AND t5.deleted = '0' AND ( t1.vision LIKE '%rnd%' OR t1.vision IS NULL ), the codes: count_of_delivered_story_in_e x e cution_when_closing,count_of_finished_story_in_e x e cution,count_of_invalid_story_in_e x e cution,count_of_valid_story_in_e x e cution,count_of_verified_story_in_e x e cution_when_closing,scale_of_delivered_story_in_e x e cution_when_closing,scale_of_story_in_e x e cution,rate_of_developed_story_in_e x e cution,rate_of_finished_story_in_e x e cution
2024-10-24 19:37:44 Calculate consumed time: 0.0071640014648438 seconds, the sql: SELECT `t3`.`project` AS `t3_project`,`t1`.`stage` AS `t1_stage`,`t1`.`closedReason` AS `t1_closedReason` FROM `zt_story` AS t1 LEFT JOIN `zt_product` AS t2 ON t1.product=t2.id LEFT JOIN `zt_projectstory` AS t3 ON t1.id=t3.story LEFT JOIN `zt_project` AS t4 ON t3.project=t4.id LEFT JOIN `zt_project` AS t5 ON t4.project=t5.id WHERE t1.deleted = '0' AND t2.deleted = '0' AND t4.deleted = '0' AND t4.type IN ('sprint','stage','kanban') AND t5.deleted = '0' AND ( t1.vision LIKE '%rnd%' OR t1.vision IS NULL ), the codes: count_of_developed_story_in_e x e cution,count_of_story_in_e x e cution
2024-10-24 19:37:44 Calculate consumed time: 0.0044319629669189 seconds, the sql: SELECT `t1`.`e x e cution` AS `t1_e x e cution`,`t1`.`status` AS `t1_status`,`t1`.`resolution` AS `t1_resolution` FROM `zt_bug` AS t1 LEFT JOIN `zt_product` AS t2 ON t1.product=t2.id LEFT JOIN `zt_project` AS t3 ON t1.e x e cution=t3.id LEFT JOIN `zt_project` AS t4 ON t1.project=t4.id WHERE t1.deleted = '0' AND t2.shadow = '0' AND t3.deleted = '0' AND t3.type IN ('sprint','stage','kanban') AND t4.deleted = '0' AND ( t2.vision LIKE '%rnd%' OR t2.vision IS NULL ), the codes: count_of_effective_bug_in_e x e cution
2024-10-24 19:37:44 Calculate consumed time: 0.0080928802490234 seconds, the sql: SELECT t1.id as e x e cution,`t1`.`multiple` AS `t1_multiple`,if(t1.multiple = '1', t1.realBegan, t5.realBegan) as realBegan,`t3`.`story` AS `t3_story`,`t6`.`action` AS `t6_action`,t6.id as actionID,t6.date as actionDate,`t4`.`estimate` AS `t4_estimate`,`t4`.`isParent` AS `t4_isParent` FROM `zt_project` AS t1 LEFT JOIN `zt_projectstory` AS t3 ON t1.id=t3.project LEFT JOIN `zt_story` AS t4 ON t3.story=t4.id LEFT JOIN `zt_project` AS t5 ON t1.project=t5.id LEFT JOIN `zt_action` AS t6 ON t3.story=t6.objectID WHERE t1.type IN ('sprint','stage','kanban') AND t6.objectType = 'story' AND t1.deleted = '0' AND t4.type = 'story' AND t4.deleted = '0' AND t5.deleted = '0' AND ( t1.vision LIKE '%rnd%' OR t1.vision IS NULL ), the codes: count_of_story_in_e x e cution_when_starting,scale_of_story_in_e x e cution_when_starting
2024-10-24 19:37:44 Calculate consumed time: 0.039316892623901 seconds, the sql: SELECT `t1`.`assignedTo` AS `t1_assignedTo`,`t1`.`resolvedBy` AS `t1_resolvedBy`,`t1`.`resolvedDate` AS `t1_resolvedDate`,`t1`.`status` AS `t1_status`,`t1`.`openedDate` AS `t1_openedDate`,`t1`.`closedDate` AS `t1_closedDate`,`t1`.`resolution` AS `t1_resolution`,`t1`.`id` AS `t1_id` FROM `zt_bug` AS t1 LEFT JOIN `zt_product` AS t2 ON t1.product=t2.id WHERE t1.deleted = '0' AND t2.deleted = '0' AND ( t2.vision LIKE '%rnd%' OR t2.vision IS NULL ), the codes: count_of_assigned_bug_in_user,count_of_daily_fixed_bug_in_user,count_of_activated_bug,count_of_annual_created_bug,count_of_annual_fixed_bug,count_of_bug,count_of_closed_bug,count_of_daily_closed_bug,count_of_fixed_bug,count_of_monthly_created_bug,count_of_monthly_fixed_bug,count_of_resolved_bug,count_of_unclosed_bug,count_of_valid_bug,rate_of_fixed_bug
2024-10-24 19:37:44 Calculate consumed time: 0.0070028305053711 seconds, the sql: SELECT `t1`.`assignedTo` AS `t1_assignedTo`,`t3`.`status` AS `t3_status` FROM `zt_testrun` AS t1 LEFT JOIN `zt_case` AS t2 ON t1.`case` = t2.id LEFT JOIN `zt_testtask` AS t3 ON t1.task = t3.id WHERE t3.deleted = '0' AND t2.deleted = '0', the codes: count_of_assigned_case_in_user
2024-10-24 19:37:44 Calculate consumed time: 0.0063920021057129 seconds, the sql: SELECT `assignedTo` FROM `zt_story` AS t1 LEFT JOIN `zt_product` AS t2 ON t1.product=t2.id WHERE t1.deleted = '0' AND t2.deleted = '0' AND t1.type = 'epic' AND ( t1.vision LIKE '%rnd%' OR t1.vision IS NULL ), the codes: count_of_assigned_epic_in_user
2024-10-24 19:37:44 Calculate consumed time: 0.029484033584595 seconds, the sql: SELECT `t1`.`assignedTo` AS `t1_assignedTo`,`t1`.`reviewedBy` AS `t1_reviewedBy`,`t1`.`reviewedDate` AS `t1_reviewedDate`,`t1`.`status` AS `t1_status`,`t1`.`closedDate` AS `t1_closedDate`,`openedDate`,`t1`.`id` AS `t1_id` FROM `zt_feedback` AS t1 LEFT JOIN `zt_product` AS t2 ON t1.product=t2.id WHERE t1.deleted = '0' AND t2.deleted = '0' AND ( t2.vision LIKE '%rnd%' OR t2.vision IS NULL ), the codes: count_of_assigned_feedback_in_user,count_of_daily_review_feedback_in_user,count_of_reviewing_feedback_in_user,count_of_annual_closed_feedback,count_of_annual_created_feedback,count_of_closed_feedback,count_of_feedback
2024-10-24 19:37:44 Calculate consumed time: 0.0052709579467773 seconds, the sql: SELECT `assignedTo` FROM `zt_story` AS t1 LEFT JOIN `zt_product` AS t2 ON t1.product=t2.id WHERE t1.deleted = '0' AND t2.deleted = '0' AND t1.type = 'r e q u i r ement' AND ( t1.vision LIKE '%rnd%' OR t1.vision IS NULL ), the codes: count_of_assigned_r e q u i r ement_in_user
2024-10-24 19:37:44 Calculate consumed time: 0.0058369636535645 seconds, the sql: SELECT `t1`.`id` AS `t1_id`,case when t1.mode != '' and t4.status != 'done' then t4.account when t1.mode != '' and t4.status = 'done' then '' else t1.assignedTo end as assignedTo,`t1`.`status` AS `t1_status`,`t1`.`mode` AS `t1_mode`,`t4`.`account` AS `t4_account`,t3.status as projectStatus,t2.status as e x e cutionStatus,t4.status as teamStatus FROM `zt_task` AS t1 LEFT JOIN `zt_project` AS t2 ON t1.e x e cution=t2.id LEFT JOIN `zt_project` AS t3 ON t2.project=t3.id LEFT JOIN `zt_taskteam` AS t4 ON t1.id=t4.task and t1.mode='multi' WHERE t2.type IN ('sprint','kanban','stage') AND t1.deleted = '0' AND t2.deleted = '0' AND t3.deleted = '0' AND ( t1.vision LIKE '%rnd%' OR t1.vision IS NULL ), the codes: count_of_assigned_task_in_user
2024-10-24 19:37:44 Calculate consumed time: 0.0054159164428711 seconds, the sql: SELECT `t1`.`assignedTo` AS `t1_assignedTo` FROM `zt_ticket` AS t1 LEFT JOIN `zt_product` AS t2 ON t1.product=t2.id WHERE t1.deleted = '0' AND t2.deleted = '0' AND ( t2.vision LIKE '%rnd%' OR t2.vision IS NULL ), the codes: count_of_assigned_ticket_in_user
2024-10-24 19:37:44 Calculate consumed time: 0.066534996032715 seconds, the sql: SELECT `assignedTo`,`t1`.`openedDate` AS `t1_openedDate`,`t1`.`stage` AS `t1_stage`,`t1`.`releasedDate` AS `t1_releasedDate`,`t1`.`closedReason` AS `t1_closedReason`,`t1`.`closedDate` AS `t1_closedDate`,`t1`.`status` AS `t1_status`,`t1`.`id` AS `t1_id`,`t1`.`estimate` AS `t1_estimate`,`t1`.`parent` AS `t1_parent` FROM `zt_story` AS t1 LEFT JOIN `zt_product` AS t2 ON t1.product=t2.id WHERE t1.deleted = '0' AND t2.deleted = '0' AND t1.type = 'story' AND t1.isParent = '0' AND ( t1.vision LIKE '%rnd%' OR t1.vision IS NULL ), the codes: count_of_pending_story_in_user,count_of_annual_created_story,count_of_annual_delivered_story,count_of_annual_finished_story,count_of_closed_story,count_of_delivered_story,count_of_finished_story,count_of_invalid_story,count_of_monthly_created_story,count_of_monthly_finished_story,count_of_story,count_of_unclosed_story,count_of_valid_story,scale_of_annual_closed_story,scale_of_annual_delivered_story,scale_of_annual_finished_story,scale_of_finished_story,scale_of_invalid_story,scale_of_monthly_closed_story,scale_of_monthly_delivered_story,scale_of_monthly_finished_story,scale_of_story,scale_of_valid_story,rate_of_annual_delivered_story,rate_of_annual_finished_story,rate_of_delivered_story,rate_of_finished_story
2024-10-24 19:37:44 Calculate consumed time: 0.01478385925293 seconds, the sql: SELECT `t1`.`closedDate` AS `t1_closedDate`,`t1`.`createdDate` AS `t1_createdDate`,`t1`.`status` AS `t1_status`,`t1`.`id` AS `t1_id` FROM `zt_product` AS t1 WHERE t1.deleted = '0' AND t1.shadow = '0' AND ( t1.vision LIKE '%rnd%' OR t1.vision IS NULL ), the codes: count_of_annual_closed_product,count_of_annual_created_product,count_of_closed_product,count_of_normal_product,count_of_product
2024-10-24 19:37:44 Calculate consumed time: 0.016792058944702 seconds, the sql: SELECT `t1`.`closedDate` AS `t1_closedDate`,`t1`.`createdDate` AS `t1_createdDate`,`t1`.`finishedDate` AS `t1_finishedDate`,`t1`.`status` AS `t1_status`,`t1`.`closedReason` AS `t1_closedReason`,`t1`.`id` AS `t1_id` FROM `zt_productplan` AS t1 LEFT JOIN `zt_product` AS t2 ON t1.product=t2.id WHERE t1.deleted = '0' AND t2.deleted = '0' AND ( t2.vision LIKE '%rnd%' OR t2.vision IS NULL ), the codes: count_of_annual_closed_productplan,count_of_annual_created_productplan,count_of_annual_finished_productplan,count_of_finished_productplan,count_of_productplan,count_of_unfinished_productplan
2024-10-24 19:37:44 Calculate consumed time: 0.018266916275024 seconds, the sql: SELECT `status`,`closedDate`,`openedDate` FROM `zt_project` AS t1 WHERE `type` = 'program' AND `grade` = '1' AND `deleted` = '0' AND ( t1.vision LIKE '%rnd%' OR t1.vision IS NULL ), the codes: count_of_annual_closed_top_program,count_of_annual_created_top_program,count_of_closed_top_program,count_of_unclosed_top_program
2024-10-24 19:37:44 Calculate consumed time: 0.0078599452972412 seconds, the sql: SELECT `t1`.`openedDate` AS `t1_openedDate`,`t1`.`id` AS `t1_id` FROM `zt_case` AS t1 LEFT JOIN `zt_product` AS t2 ON t1.product=t2.id WHERE t1.deleted = '0' AND t2.deleted = '0' AND ( t2.vision LIKE '%rnd%' OR t2.vision IS NULL ), the codes: count_of_annual_created_case,count_of_case
2024-10-24 19:37:44 Calculate consumed time: 0.0069770812988281 seconds, the sql: SELECT `t1`.`addedDate` AS `t1_addedDate`,`t1`.`id` AS `t1_id` FROM `zt_doc` AS t1 WHERE t1.deleted = '0' AND ( t1.vision LIKE '%rnd%' OR t1.vision IS NULL ), the codes: count_of_annual_created_doc,count_of_doc
2024-10-24 19:37:44 Calculate consumed time: 0.010863065719604 seconds, the sql: SELECT `t1`.`date` AS `t1_date`,`t1`.`id` AS `t1_id` FROM `zt_release` AS t1 WHERE `deleted` = '0', the codes: count_of_annual_created_release,count_of_monthly_created_release,count_of_release,count_of_weekly_created_release
2024-10-24 19:37:44 Calculate consumed time: 0.0067050457000732 seconds, the sql: SELECT `t1`.`join` AS `t1_join`,`t1`.`id` AS `t1_id` FROM `zt_user` AS t1 WHERE t1.deleted = '0', the codes: count_of_annual_created_user,count_of_user
2024-10-24 19:37:44 Calculate consumed time: 0.0045270919799805 seconds, the sql: SELECT COUNT(1) AS count, 0 as instanceCount FROM `zt_pipeline` WHERE `deleted` = '0', the codes: count_of_application
2024-10-24 19:37:44 Calculate consumed time: 0.0047690868377686 seconds, the sql: SELECT `id` FROM `zt_artifactrepo` WHERE `deleted` = '0', the codes: count_of_artifactrepo
2024-10-24 19:37:44 Calculate consumed time: 0.018640041351318 seconds, the sql: SELECT `status`,`id`,`t1`.`id` AS `t1_id`,`t1`.`grade` AS `t1_grade` FROM `zt_project` AS t1 WHERE `type` = 'program' AND `deleted` = '0' AND ( t1.vision LIKE '%rnd%' OR t1.vision IS NULL ), the codes: count_of_closed_program,count_of_doing_program,count_of_program,count_of_suspended_program,count_of_top_program,count_of_wait_program
2024-10-24 19:37:44 Calculate consumed time: 0.0059490203857422 seconds, the sql: SELECT `id` FROM `zt_repo` WHERE `deleted` = '0', the codes: count_of_codebase
2024-10-24 19:37:44 Calculate consumed time: 0.0049760341644287 seconds, the sql: SELECT `t1`.`openedDate` AS `t1_openedDate` FROM `zt_story` AS t1 LEFT JOIN `zt_product` AS t2 ON t1.product=t2.id WHERE t1.deleted = '0' AND t2.deleted = '0' AND ( t1.vision LIKE '%rnd%' OR t1.vision IS NULL ), the codes: count_of_daily_created_story
2024-10-24 19:37:44 Calculate consumed time: 0.0047199726104736 seconds, the sql: SELECT `t1`.`id` AS `t1_id`,`t1`.`date` AS `t1_date` FROM `zt_testresult` AS t1 LEFT JOIN `zt_case` AS t2 ON t1.`case`=t2.id LEFT JOIN `zt_product` AS t3 ON t2.product=t3.id WHERE t2.deleted = '0' AND t3.deleted = '0' AND ( t3.vision LIKE '%rnd%' OR t3.vision IS NULL ), the codes: count_of_daily_run_case
2024-10-24 19:37:44 Calculate consumed time: 0.0042300224304199 seconds, the sql: SELECT `t1`.`id` AS `t1_id` FROM `zt_module` AS t1 WHERE t1.deleted = '0' AND t1.type = 'line', the codes: count_of_line
2024-10-24 19:37:44 Calculate consumed time: 0.0048239231109619 seconds, the sql: SELECT `t1`.`marker` AS `t1_marker` FROM `zt_release` AS t1 LEFT JOIN `zt_project` AS t2 ON CONCAT(',', t2.id, ',') LIKE CONCAT('%,', t1.project, ',%') LEFT JOIN `zt_product` AS t3 ON t1.product=t3.id WHERE t1.deleted = '0' AND t3.deleted = '0' AND ( t2.vision LIKE '%rnd%' OR t2.vision IS NULL ), the codes: count_of_marker_release
2024-10-24 19:37:44 Calculate consumed time: 0.0045051574707031 seconds, the sql: SELECT `t1`.`id` AS `t1_id` FROM `zt_host` AS t1 LEFT JOIN `zt_image` AS t2 ON t2.id = t1.image WHERE t1.deleted = '0' AND t1.type = 'node' , the codes: count_of_node
2024-10-24 19:37:44 Calculate consumed time: 0.0045759677886963 seconds, the sql: SELECT `t1`.`id` AS `t1_id` FROM `zt_job` AS t1 WHERE t1.deleted = '0', the codes: count_of_pipeline
2024-10-24 19:37:44 Calculate consumed time: 0.005972146987915 seconds, the sql: SELECT `t1`.`resolvedBy` AS `t1_resolvedBy` FROM `zt_bug` AS t1 LEFT JOIN `zt_repo` AS t2 ON t1.repo = t2.id WHERE t1.repo > '0' AND t1.deleted = '0' AND t2.deleted = '0', the codes: count_of_pending_issue
2024-10-24 19:37:44 Calculate consumed time: 0.0053610801696777 seconds, the sql: SELECT `t1`.`status` AS `t1_status` FROM `zt_mr` AS t1 LEFT JOIN `zt_repo` AS t2 ON t1.hostID = t2.id WHERE t1.deleted = '0' AND t2.deleted = '0', the codes: count_of_pending_mergeRequest
2024-10-24 19:37:44 Calculate consumed time: 0.023736953735352 seconds, the sql: SELECT `t1`.`closedDate` AS `t1_closedDate`,`t2`.`consumed` AS `t2_consumed`,t1.id as project,`t1`.`status` AS `t1_status`, 8 AS defaultHours FROM `zt_project` AS t1 LEFT JOIN tmp_task_getProjectTasks AS t2 ON t1.id = t2.project WHERE t1.type = 'project' AND t1.deleted = '0' AND ( t1.vision LIKE '%rnd%' OR t1.vision IS NULL ), the codes: consume_of_annual_closed_project,consume_of_monthly_closed_project,day_of_annual_closed_project
2024-10-24 19:37:44 Calculate consumed time: 0.012046098709106 seconds, the sql: SELECT `t1`.`date` AS `t1_date`,`t1`.`consumed` AS `t1_consumed`, 8 as defaultHours FROM `zt_effort` AS t1 WHERE t1.deleted = '0', the codes: day_of_annual_effort,day_of_daily_effort,hour_of_annual_effort,hour_of_daily_effort
2024-10-24 19:37:44 Calculate consumed time: 0.0043258666992188 seconds, the sql: SELECT `t1`.`status` AS `t1_status` FROM `zt_deploy` AS t1 LEFT JOIN `zt_deployproduct` AS t2 ON t1.id=t2.deploy WHERE t1.deleted = '0', the codes: count_of_pending_deployment
2024-10-24 19:37:44 Calculate consumed time: 0.0077152252197266 seconds, the sql: , the codes: cv_weekly_in_waterfall
2024-10-24 19:37:44 Calculate consumed time: 0.0086028575897217 seconds, the sql: , the codes: sv_weekly_in_waterfall
2024-10-24 19:37:44 Calculate consumed time: 0.009192943572998 seconds, the sql: , the codes: bug_concentration_of_developed_story_in_product
2024-10-24 19:37:44 Calculate consumed time: 0.0076348781585693 seconds, the sql: , the codes: rate_of_verified_story_in_e x e cution_when_closing
2024-10-24 19:37:44 Calculate consumed time: 0.0068631172180176 seconds, the sql: , the codes: test_concentration_in_e x e cution_when_closing
2024-10-24 19:37:44 Calculate consumed time: 0.0079920291900635 seconds, the sql: , the codes: workload_of_plan_in_e x e cution
2024-10-24 19:37:44 Calculate consumed time: 0.0068891048431396 seconds, the sql: , the codes: devel_efficiency_in_e x e cution_when_closing
2024-10-24 19:37:44 Calculate consumed time: 0.0072758197784424 seconds, the sql: , the codes: rate_of_planned_developed_story_in_e x e cution_when_closing
2024-10-24 19:37:46 Deduplicate consumed time: 1.7882950305939 seconds
2024-10-24 19:37:46 -------------------------------------------
2024-10-24 19:37:46 | The new task: updateDashboardMetricLib. |
2024-10-24 19:37:46 -------------------------------------------
2024-10-24 19:37:46 Calculate consumed time: 0.010310888290405 seconds, the sql: SELECT `t1`.`status` AS `t1_status`,`t1`.`project` AS `t1_project` FROM `zt_bug` AS t1 LEFT JOIN `zt_product` AS t2 ON t1.product=t2.id LEFT JOIN `zt_project` AS t3 ON t1.project=t3.id WHERE t1.deleted = '0' AND t2.deleted = '0' AND t3.deleted = '0' AND ( t3.vision LIKE '%rnd%' OR t3.vision IS NULL ), the codes: count_of_activated_bug_in_project,count_of_bug_in_project,count_of_closed_bug_in_project
2024-10-24 19:37:46 Calculate consumed time: 0.038613080978394 seconds, the sql: SELECT `t1`.`status` AS `t1_status`,`t1`.`project` AS `t1_project`,`t1`.`consumed` AS `t1_consumed`,`t1`.`parent` AS `t1_parent`,`t1`.`left` AS `t1_left`,`t1`.`finishedDate` AS `t1_finishedDate`,`t1`.`e x e cution` AS `t1_e x e cution`,`t1`.`estimate` AS `t1_estimate` FROM `zt_task` AS t1 LEFT JOIN `zt_project` AS t2 ON t1.e x e cution=t2.id LEFT JOIN `zt_project` AS t3 ON t2.project=t3.id WHERE t2.type IN ('sprint','kanban','stage') AND t1.deleted = '0' AND t2.deleted = '0' AND t3.deleted = '0' AND ( t1.vision LIKE '%rnd%' OR t1.vision IS NULL ), the codes: count_of_doing_task_in_project,count_of_task_in_project,count_of_wait_task_in_project,consume_of_task_in_project,left_of_task_in_project,progress_of_task_in_project,count_of_daily_finished_task_in_e x e cution,count_of_task_in_e x e cution,count_of_unfinished_task_in_e x e cution,consume_of_task_in_e x e cution,estimate_of_task_in_e x e cution,left_of_task_in_e x e cution,count_of_daily_finished_task
2024-10-24 19:37:46 Calculate consumed time: 0.010460138320923 seconds, the sql: SELECT `t3`.`project` AS `t3_project`,`t1`.`closedReason` AS `t1_closedReason`,`t1`.`status` AS `t1_status`,`t1`.`estimate` AS `t1_estimate`,`t1`.`isParent` AS `t1_isParent` FROM `zt_story` AS t1 LEFT JOIN `zt_product` AS t2 ON t1.product=t2.id LEFT JOIN `zt_projectstory` AS t3 ON t1.id=t3.story LEFT JOIN `zt_project` AS t4 ON t3.project=t4.id WHERE t1.deleted = '0' AND t2.deleted = '0' AND t4.deleted = '0' AND t4.type = 'project' AND ( t1.vision LIKE '%rnd%' OR t1.vision IS NULL ), the codes: count_of_finished_story_in_project,count_of_unclosed_story_in_project,scale_of_story_in_project
2024-10-24 19:37:46 Calculate consumed time: 0.0043108463287354 seconds, the sql: SELECT `t3`.`project` AS `t3_project` FROM `zt_story` AS t1 LEFT JOIN `zt_product` AS t2 ON t1.product=t2.id LEFT JOIN `zt_projectstory` AS t3 ON t1.id=t3.story LEFT JOIN `zt_project` AS t4 ON t3.project=t4.id WHERE t1.deleted = '0' AND t2.deleted = '0' AND t1.type = 'story' AND t4.deleted = '0' AND t1.isParent = '0' AND t4.type = 'project' AND ( t1.vision LIKE '%rnd%' OR t1.vision IS NULL ), the codes: count_of_story_in_project
2024-10-24 19:37:46 Calculate consumed time: 0.004033088684082 seconds, the sql: SELECT `t1`.`project` AS `t1_project`,`t1`.`date` AS `t1_date`,`t1`.`consumed` AS `t1_consumed` FROM `zt_effort` AS t1 LEFT JOIN `zt_project` AS t2 ON t1.project = t2.id WHERE t1.deleted = '0' AND t2.deleted = '0' AND t2.model = 'waterfall' AND t2.type = 'project' AND ( t2.vision LIKE '%rnd%' OR t2.vision IS NULL ), the codes: ac_of_weekly_all_in_waterfall
2024-10-24 19:37:46 Calculate consumed time: 0.0044600963592529 seconds, the sql: SELECT t3.id as project,`t1`.`consumed` AS `t1_consumed`, 8 as defaultHours FROM `zt_effort` AS t1 LEFT JOIN `zt_project` AS t2 ON t1.e x e cution=t2.id LEFT JOIN `zt_project` AS t3 ON t2.project=t3.id WHERE t1.deleted = '0' AND t3.deleted = '0' AND t3.type = 'project' AND ( t3.vision LIKE '%rnd%' OR t3.vision IS NULL ), the codes: day_of_invested_in_project
2024-10-24 19:37:46 Calculate consumed time: 0.0065138339996338 seconds, the sql: SELECT `t1`.`project` AS `t1_project`,`t1`.`estimate` AS `t1_estimate`,`t1`.`consumed` AS `t1_consumed`,`t1`.`left` AS `t1_left`,`t1`.`status` AS `t1_status`,`t1`.`closedReason` AS `t1_closedReason`,`t1`.`id` AS `t1_id`,`t1`.`estStarted` AS `t1_estStarted`,`t1`.`deadline` AS `t1_deadline`,t2.begin as e x e cutionBegin,t2.end as e x e cutionEnd,t3.id as project FROM `zt_task` AS t1 LEFT JOIN `zt_project` AS t2 ON t1.e x e cution = t2.id LEFT JOIN `zt_project` AS t3 ON t2.project = t3.id WHERE t1.parent >= '0' AND t1.deleted = '0' AND t1.status != 'cancel' AND t2.deleted = '0' AND t3.type = 'project' AND t3.model IN ('waterfall','waterfallplus') AND ( t3.vision LIKE '%rnd%' OR t3.vision IS NULL ), the codes: ev_of_weekly_finished_task_in_waterfall,pv_of_weekly_task_in_waterfall
2024-10-24 19:37:46 Calculate consumed time: 0.017031908035278 seconds, the sql: SELECT `t1`.`product` AS `t1_product`,`t1`.`status` AS `t1_status`,`t1`.`resolution` AS `t1_resolution`,`t1`.`closedDate` AS `t1_closedDate`,`t1`.`openedDate` AS `t1_openedDate`, 7 as longlife FROM `zt_bug` AS t1 LEFT JOIN `zt_product` AS t2 ON t1.product=t2.id WHERE t1.deleted = '0' AND t2.deleted = '0' AND t2.shadow = '0' AND ( t2.vision LIKE '%rnd%' OR t2.vision IS NULL ), the codes: count_of_activated_bug_in_product,count_of_annual_fixed_bug_in_product,count_of_effective_bug_in_product,count_of_fixed_bug_in_product,count_of_monthly_closed_bug_in_product,count_of_monthly_created_bug_in_product
2024-10-24 19:37:46 Calculate consumed time: 0.0067698955535889 seconds, the sql: SELECT `t1`.`id` AS `t1_id`,`t1`.`product` AS `t1_product`,`t1`.`date` AS `t1_date` FROM `zt_release` AS t1 LEFT JOIN `zt_product` AS t2 ON t1.product=t2.id WHERE t1.deleted = '0' AND t2.deleted = '0' AND t2.shadow = '0' AND ( t2.vision LIKE '%rnd%' OR t2.vision IS NULL ), the codes: count_of_annual_created_release_in_product,count_of_monthly_created_release_in_product
2024-10-24 19:37:46 Calculate consumed time: 0.022212028503418 seconds, the sql: SELECT `t1`.`product` AS `t1_product`,`t1`.`closedDate` AS `t1_closedDate`,`t1`.`status` AS `t1_status`,`t1`.`closedReason` AS `t1_closedReason`,`t1`.`stage` AS `t1_stage`,`t1`.`openedDate` AS `t1_openedDate`,`t1`.`estimate` AS `t1_estimate`,`t1`.`parent` AS `t1_parent` FROM `zt_story` AS t1 LEFT JOIN `zt_product` AS t2 ON t1.product=t2.id WHERE t1.deleted = '0' AND t2.deleted = '0' AND t1.type = 'story' AND t1.isParent = '0' AND t2.shadow = '0' AND ( t1.vision LIKE '%rnd%' OR t1.vision IS NULL ), the codes: count_of_annual_finished_story_in_product,count_of_delivered_story_in_product,count_of_monthly_created_story_in_product,count_of_monthly_finished_story_in_product,count_of_unclosed_story_in_product,count_of_valid_story_in_product,scale_of_annual_finished_story_in_product,rate_of_delivery_story_in_product
2024-10-24 19:37:46 Calculate consumed time: 0.0046489238739014 seconds, the sql: SELECT `t3`.`project` AS `t3_project`,`t1`.`closedReason` AS `t1_closedReason` FROM `zt_story` AS t1 LEFT JOIN `zt_product` AS t2 ON t1.product=t2.id LEFT JOIN `zt_projectstory` AS t3 ON t1.id=t3.story LEFT JOIN `zt_project` AS t4 ON t3.project=t4.id LEFT JOIN `zt_project` AS t5 ON t4.project=t5.id WHERE t1.deleted = '0' AND t2.deleted = '0' AND t1.type = 'story' AND t4.deleted = '0' AND t4.type IN ('sprint','stage','kanban') AND t5.deleted = '0' AND ( t1.vision LIKE '%rnd%' OR t1.vision IS NULL ), the codes: count_of_finished_story_in_e x e cution
2024-10-24 19:37:46 Calculate consumed time: 0.015120983123779 seconds, the sql: SELECT `t1`.`id` AS `t1_id`,`t1`.`progress` AS `t1_progress`,`t1`.`realEnd` AS `t1_realEnd`,`t1`.`status` AS `t1_status` FROM `zt_project` AS t1 LEFT JOIN `zt_project` AS t2 ON t1.project=t2.id WHERE t1.deleted = '0' AND t2.deleted = '0' AND t1.type IN ('sprint','stage','kanban') AND t1.multiple = '1' AND t2.type = 'project' AND ( t1.vision LIKE '%rnd%' OR t1.vision IS NULL ), the codes: progress_of_task_in_e x e cution,count_of_annual_finished_e x e cution,count_of_doing_e x e cution,count_of_e x e cution,count_of_suspended_e x e cution,count_of_wait_e x e cution
2024-10-24 19:37:46 Calculate consumed time: 0.0056970119476318 seconds, the sql: SELECT `t1`.`status` AS `t1_status`,`t1`.`realEnd` AS `t1_realEnd`,`t1`.`id` AS `t1_id` FROM `zt_project` AS t1 WHERE `deleted` = '0' AND `type` = 'project' AND ( t1.vision LIKE '%rnd%' OR t1.vision IS NULL ), the codes: count_of_annual_finished_project,count_of_project
2024-10-24 19:37:46 Calculate consumed time: 0.0082049369812012 seconds, the sql: SELECT `t1`.`closedDate` AS `t1_closedDate`,`t1`.`openedDate` AS `t1_openedDate`,`t1`.`status` AS `t1_status`,`t1`.`resolution` AS `t1_resolution` FROM `zt_bug` AS t1 LEFT JOIN `zt_product` AS t2 ON t1.product=t2.id WHERE t1.deleted = '0' AND t2.deleted = '0' AND ( t2.vision LIKE '%rnd%' OR t2.vision IS NULL ), the codes: count_of_daily_closed_bug,count_of_monthly_created_bug,count_of_monthly_fixed_bug
2024-10-24 19:37:46 Calculate consumed time: 0.0036959648132324 seconds, the sql: SELECT `t1`.`openedDate` AS `t1_openedDate` FROM `zt_story` AS t1 LEFT JOIN `zt_product` AS t2 ON t1.product=t2.id WHERE t1.deleted = '0' AND t2.deleted = '0' AND ( t1.vision LIKE '%rnd%' OR t1.vision IS NULL ), the codes: count_of_daily_created_story
2024-10-24 19:37:46 Calculate consumed time: 0.0039069652557373 seconds, the sql: SELECT `t1`.`id` AS `t1_id`,`t1`.`date` AS `t1_date` FROM `zt_testresult` AS t1 LEFT JOIN `zt_case` AS t2 ON t1.`case`=t2.id LEFT JOIN `zt_product` AS t3 ON t2.product=t3.id WHERE t2.deleted = '0' AND t3.deleted = '0' AND ( t3.vision LIKE '%rnd%' OR t3.vision IS NULL ), the codes: count_of_daily_run_case
2024-10-24 19:37:46 Calculate consumed time: 0.003680944442749 seconds, the sql: SELECT `t1`.`id` AS `t1_id` FROM `zt_module` AS t1 WHERE t1.deleted = '0' AND t1.type = 'line', the codes: count_of_line
2024-10-24 19:37:46 Calculate consumed time: 0.0056450366973877 seconds, the sql: SELECT `t1`.`openedDate` AS `t1_openedDate`,`t1`.`closedDate` AS `t1_closedDate`,`t1`.`closedReason` AS `t1_closedReason`,`t1`.`estimate` AS `t1_estimate`,`t1`.`parent` AS `t1_parent` FROM `zt_story` AS t1 LEFT JOIN `zt_product` AS t2 ON t1.product=t2.id WHERE t1.deleted = '0' AND t2.deleted = '0' AND t1.type = 'story' AND t1.isParent = '0' AND ( t1.vision LIKE '%rnd%' OR t1.vision IS NULL ), the codes: count_of_monthly_created_story,scale_of_monthly_finished_story
2024-10-24 19:37:46 Calculate consumed time: 0.0033888816833496 seconds, the sql: SELECT `t1`.`id` AS `t1_id` FROM `zt_product` AS t1 WHERE t1.deleted = '0' AND t1.shadow = '0' AND ( t1.vision LIKE '%rnd%' OR t1.vision IS NULL ), the codes: count_of_product
2024-10-24 19:37:46 Calculate consumed time: 0.0033509731292725 seconds, the sql: SELECT `t1`.`status` AS `t1_status`,`t1`.`closedReason` AS `t1_closedReason` FROM `zt_productplan` AS t1 LEFT JOIN `zt_product` AS t2 ON t1.product=t2.id WHERE t1.deleted = '0' AND t2.deleted = '0' AND ( t2.vision LIKE '%rnd%' OR t2.vision IS NULL ), the codes: count_of_unfinished_productplan
2024-10-24 19:37:46 Calculate consumed time: 0.0062310695648193 seconds, the sql: SELECT `t1`.`date` AS `t1_date`,`t1`.`consumed` AS `t1_consumed`, 8 as defaultHours FROM `zt_effort` AS t1 WHERE t1.deleted = '0', the codes: hour_of_annual_effort,hour_of_daily_effort
2024-10-24 19:37:46 Calculate consumed time: 0.005836009979248 seconds, the sql: , the codes: cv_weekly_in_waterfall
2024-10-24 19:37:46 Calculate consumed time: 0.0057110786437988 seconds, the sql: , the codes: sv_weekly_in_waterfall
2024-10-24 19:37:48 Deduplicate consumed time: 1.7846131324768 seconds