深圳智汇创想科技有限公司

001- 反馈人：李冠 严重级别：严重 所属项目：账号管理 问题原因：超慢SQL、，严重影响公共库其它业务正常运行，SQL为：（ SELECT * FROM ( SELECT wpi.proc_info_id, wps.step_name AS cur_step_name, ifnull(wps.step_code, 0) AS cur_step_code, wfsu.exec_user_name AS exec_user_name, row_number() over ( PARTITION BY wpi.proc_info_id ORDER BY wps.step_code DESC ) row_num FROM rb_wf_process_info wpi LEFT JOIN rb_wf_finish_step wfs ON wfs.proc_info_id = wpi.proc_info_id AND wfs.customer_id = wpi.customer_id LEFT JOIN rb_wf_process_step wps ON wfs.step_id = wps.step_id AND wfs.proc_info_id = wps.proc_info_id AND wfs.customer_id = wps.customer_id LEFT JOIN rb_wf_finish_step_user wfsu ON wfsu.es_id = wfs.es_id AND wfsu.proc_info_id = wfs.proc_info_id AND wfsu.customer_id = wfs.customer_id WHERE wpi.proc_id IN ( 420, 424 ) AND wpi.customer_id = 1 and wpi.proc_info_id in ( 284996 , 282631 , 284992 , 284865 , 309761 , 284866 , 284994 , 268355 , 282894 , 300238 , 304655 , 265419 , 287755 , 306710 , 295059 , 309725 , 292760 , 309720 , 278950 , 287584 , 287022 , 277610 , 309748 , 309750 , 309746 , 294526 , 291455 , 271992 , 271993 , 298299 ) ) a WHERE row_num = 1） 解决方案：请使用合适的索引，或减少JOIN
001+ 反馈人：李冠 严重级别：严重 所属项目：账号管理 问题原因：超慢SQL、，严重影响公共库其它业务正常运行，SQL为：（ SELECT * FROM ( SELECT wpi.proc_info_id, wps.step_name AS cur_step_name, ifnull(wps.step_code, 0) AS cur_step_code, wfsu.exec_user_name AS exec_user_name, row_number() over ( PARTITION BY wpi.proc_info_id ORDER BY wps.step_code DESC ) row_num FROM rb_wf_process_info wpi LEFT JOIN rb_wf_finish_step wfs ON wfs.proc_info_id = wpi.proc_info_id AND wfs.customer_id = wpi.customer_id LEFT JOIN rb_wf_process_step wps ON wfs.step_id = wps.step_id AND wfs.proc_info_id = wps.proc_info_id AND wfs.customer_id = wps.customer_id LEFT JOIN rb_wf_finish_step_user wfsu ON wfsu.es_id = wfs.es_id AND wfsu.proc_info_id = wfs.proc_info_id AND wfsu.customer_id = wfs.customer_id WHERE wpi.proc_id IN ( 420, 424 ) AND wpi.customer_id = 1 and wpi.proc_info_id in ( 284996 , 282631 , 284992 , 284865 , 309761 , 284866 , 284994 , 268355 , 282894 , 300238 , 304655 , 265419 , 287755 , 306710 , 295059 , 309725 , 292760 , 309720 , 278950 , 287584 , 287022 , 277610 , 309748 , 309750 , 309746 , 294526 , 291455 , 271992 , 271993 , 298299 ) ) a WHERE row_num = 1）解决方案：请使用合适的索引，或减少JOIN
002+ https://alidocs.dingtalk.com/i/nodes/KGZLxjv9VG32K57Mt0AKdXpEV6EDybno?utm_scene=team_space

001- 反馈人：李冠<br /> 严重级别：严重<br /> 所属项目：账号管理<br /> 问题原因：超慢SQL、，严重影响公共库其它业务正常运行，SQL为：（<br /> SELECT<br /> *<br /> FROM<br /> (<br /> SELECT<br /> wpi.proc_info_id,<br /> wps.step_name AS cur_step_name,<br /> ifnull(wps.step_code, 0) AS cur_step_code,<br /> wfsu.exec_user_name AS exec_user_name,<br /> row_number() over ( PARTITION BY wpi.proc_info_id ORDER BY wps.step_code DESC ) row_num<br /> FROM<br /> rb_wf_process_info wpi<br /> LEFT JOIN rb_wf_finish_step wfs ON wfs.proc_info_id = wpi.proc_info_id<br /> AND wfs.customer_id = wpi.customer_id<br /> LEFT JOIN rb_wf_process_step wps ON wfs.step_id = wps.step_id<br /> AND wfs.proc_info_id = wps.proc_info_id<br /> AND wfs.customer_id = wps.customer_id<br /> LEFT JOIN rb_wf_finish_step_user wfsu ON wfsu.es_id = wfs.es_id<br /> AND wfsu.proc_info_id = wfs.proc_info_id<br /> AND wfsu.customer_id = wfs.customer_id<br /> WHERE<br /> wpi.proc_id IN ( 420, 424 )<br /> AND wpi.customer_id = 1<br /><br /> and wpi.proc_info_id in<br /> ( <br /> 284996<br /> , <br /> 282631<br /> , <br /> 284992<br /> , <br /> 284865<br /> , <br /> 309761<br /> , <br /> 284866<br /> , <br /> 284994<br /> , <br /> 268355<br /> , <br /> 282894<br /> , <br /> 300238<br /> , <br /> 304655<br /> , <br /> 265419<br /> , <br /> 287755<br /> , <br /> 306710<br /> , <br /> 295059<br /> , <br /> 309725<br /> , <br /> 292760<br /> , <br /> 309720<br /> , <br /> 278950<br /> , <br /> 287584<br /> , <br /> 287022<br /> , <br /> 277610<br /> , <br /> 309748<br /> , <br /> 309750<br /> , <br /> 309746<br /> , <br /> 294526<br /> , <br /> 291455<br /> , <br /> 271992<br /> , <br /> 271993<br /> , <br /> 298299<br /> ) <br /><br /> ) a<br /> WHERE<br /> row_num = 1）<br /> 解决方案：请使用合适的索引，或减少JOIN
001+ 反馈人：李冠<br /> 严重级别：严重<br /> 所属项目：账号管理<br /> 问题原因：超慢SQL、，严重影响公共库其它业务正常运行，SQL为：（<br /> SELECT<br /> *<br /> FROM<br /> (<br /> SELECT<br /> wpi.proc_info_id,<br /> wps.step_name AS cur_step_name,<br /> ifnull(wps.step_code, 0) AS cur_step_code,<br /> wfsu.exec_user_name AS exec_user_name,<br /> row_number() over ( PARTITION BY wpi.proc_info_id ORDER BY wps.step_code DESC ) row_num<br /> FROM<br /> rb_wf_process_info wpi<br /> LEFT JOIN rb_wf_finish_step wfs ON wfs.proc_info_id = wpi.proc_info_id<br /> AND wfs.customer_id = wpi.customer_id<br /> LEFT JOIN rb_wf_process_step wps ON wfs.step_id = wps.step_id<br /> AND wfs.proc_info_id = wps.proc_info_id<br /> AND wfs.customer_id = wps.customer_id<br /> LEFT JOIN rb_wf_finish_step_user wfsu ON wfsu.es_id = wfs.es_id<br /> AND wfsu.proc_info_id = wfs.proc_info_id<br /> AND wfsu.customer_id = wfs.customer_id<br /> WHERE<br /> wpi.proc_id IN ( 420, 424 )<br /> AND wpi.customer_id = 1<br /><br /> and wpi.proc_info_id in<br /> ( <br /> 284996<br /> , <br /> 282631<br /> , <br /> 284992<br /> , <br /> 284865<br /> , <br /> 309761<br /> , <br /> 284866<br /> , <br /> 284994<br /> , <br /> 268355<br /> , <br /> 282894<br /> , <br /> 300238<br /> , <br /> 304655<br /> , <br /> 265419<br /> , <br /> 287755<br /> , <br /> 306710<br /> , <br /> 295059<br /> , <br /> 309725<br /> , <br /> 292760<br /> , <br /> 309720<br /> , <br /> 278950<br /> , <br /> 287584<br /> , <br /> 287022<br /> , <br /> 277610<br /> , <br /> 309748<br /> , <br /> 309750<br /> , <br /> 309746<br /> , <br /> 294526<br /> , <br /> 291455<br /> , <br /> 271992<br /> , <br /> 271993<br /> , <br /> 298299<br /> ) <br /><br /> ) a<br /> WHERE<br /> row_num = 1）<br /><p>解决方案：请使用合适的索引，或减少JOIN</p>
002+ <p>https://alidocs.dingtalk.com/i/nodes/KGZLxjv9VG32K57Mt0AKdXpEV6EDybno?utm_scene=team_space</p>