001- 反馈人：吴荣发
001+ 反馈人：吴荣发 数据库：zhcxkj_center_bi 节点ID：9cdfae993beb44d38947be143de364b6in01 查询时间：17.3597 扫描行数：178914.0 返回行数：24 一天执行次数： 178914.0 慢日志时间：2025-07-17 指纹：4c56c9ee1c34ba77aa5bcc29284169b0 SQL语句：select source_id , 'type' , receive_time , country , sale_admin_id , SUBSTRING_INDEX ( dept_full_path , '?' , ? ) , SUBSTRING_INDEX ( dept_full_path , '?' , ? ) , need_handle_exceptions , already_appealed_count , already_appealed_rate , appeal_success_count , appeal_success_rate , suggestion_appeal_count , delete_appeal_count , delete_appeal_rate , update_time , dept_sort , appeal_fail_count , waiver_appeal_count , cant_appeal_count , other_appeal_count , suggestion_delete_count , unprocessed , process_rate , processed_no_appeal , '?' AS version FROM ? ; 真实SQL：select source_id,'type',receive_time,country,sale_admin_id,SUBSTRING_INDEX(dept_full_path,'_',3),SUBSTRING_INDEX(dept_full_path,'_',4),need_handle_exceptions,already_appealed_count,already_appealed_rate,appeal_success_count,appeal_success_rate,suggestion_appeal_count,delete_appeal_count,delete_appeal_rate,update_time,dept_sort,appeal_fail_count,waiver_appeal_count,cant_appeal_count,other_appeal_count,suggestion_delete_count,unprocessed,process_rate,processed_no_appeal,'1752622358' AS version from t_amazon_health_exception; 负责人参考：公用 项目参考：java项目
002- 数据库：zhcxkj_center_bi
003- 节点ID：9cdfae993beb44d38947be143de364b6in01
004- 查询时间：17.3597
005- 扫描行数：178914.0
006- 返回行数：24
007- 一天执行次数： 178914.0
008- 慢日志时间：2025-07-17
009- 指纹：4c56c9ee1c34ba77aa5bcc29284169b0
010- SQL语句：select source_id , 'type' , receive_time , country , sale_admin_id , SUBSTRING_INDEX ( dept_full_path , '?' , ? ) , SUBSTRING_INDEX ( dept_full_path , '?' , ? ) , need_handle_exceptions , already_appealed_count , already_appealed_rate , appeal_success_count , appeal_success_rate , suggestion_appeal_count , delete_appeal_count , delete_appeal_rate , update_time , dept_sort , appeal_fail_count , waiver_appeal_count , cant_appeal_count , other_appeal_count , suggestion_delete_count , unprocessed , process_rate , processed_no_appeal , '?' AS version FROM ? ;
011- 真实SQL：select source_id,'type',receive_time,country,sale_admin_id,SUBSTRING_INDEX(dept_full_path,'_',3),SUBSTRING_INDEX(dept_full_path,'_',4),need_handle_exceptions,already_appealed_count,already_appealed_rate,appeal_success_count,appeal_success_rate,suggestion_appeal_count,delete_appeal_count,delete_appeal_rate,update_time,dept_sort,appeal_fail_count,waiver_appeal_count,cant_appeal_count,other_appeal_count,suggestion_delete_count,unprocessed,process_rate,processed_no_appeal,'1752622358' AS version from t_amazon_health_exception;
012- 负责人参考：公用
013- 项目参考：java项目

001- 反馈人：吴荣发<br />
001+ 反馈人：吴荣发<br /> 数据库：zhcxkj_center_bi<br /> 节点ID：9cdfae993beb44d38947be143de364b6in01<br /> 查询时间：17.3597<br /> 扫描行数：178914.0<br /> 返回行数：24<br /> 一天执行次数： 178914.0<br /> 慢日志时间：2025-07-17<br /> 指纹：4c56c9ee1c34ba77aa5bcc29284169b0<br /> SQL语句：select source_id , 'type' , receive_time , country , sale_admin_id , SUBSTRING_INDEX ( dept_full_path , '?' , ? ) , SUBSTRING_INDEX ( dept_full_path , '?' , ? ) , need_handle_exceptions , already_appealed_count , already_appealed_rate , appeal_success_count , appeal_success_rate , suggestion_appeal_count , delete_appeal_count , delete_appeal_rate , update_time , dept_sort , appeal_fail_count , waiver_appeal_count , cant_appeal_count , other_appeal_count , suggestion_delete_count , unprocessed , process_rate , processed_no_appeal , '?' AS version FROM ? ;<br /> 真实SQL：select source_id,'type',receive_time,country,sale_admin_id,SUBSTRING_INDEX(dept_full_path,'_',3),SUBSTRING_INDEX(dept_full_path,'_',4),need_handle_exceptions,already_appealed_count,already_appealed_rate,appeal_success_count,appeal_success_rate,suggestion_appeal_count,delete_appeal_count,delete_appeal_rate,update_time,dept_sort,appeal_fail_count,waiver_appeal_count,cant_appeal_count,other_appeal_count,suggestion_delete_count,unprocessed,process_rate,processed_no_appeal,'1752622358' AS version from t_amazon_health_exception;<br /> 负责人参考：公用<br /> 项目参考：java项目<br />
002- 数据库：zhcxkj_center_bi<br />
003- 节点ID：9cdfae993beb44d38947be143de364b6in01<br />
004- 查询时间：17.3597<br />
005- 扫描行数：178914.0<br />
006- 返回行数：24<br />
007- 一天执行次数： 178914.0<br />
008- 慢日志时间：2025-07-17<br />
009- 指纹：4c56c9ee1c34ba77aa5bcc29284169b0<br />
010- SQL语句：select source_id , 'type' , receive_time , country , sale_admin_id , SUBSTRING_INDEX ( dept_full_path , '?' , ? ) , SUBSTRING_INDEX ( dept_full_path , '?' , ? ) , need_handle_exceptions , already_appealed_count , already_appealed_rate , appeal_success_count , appeal_success_rate , suggestion_appeal_count , delete_appeal_count , delete_appeal_rate , update_time , dept_sort , appeal_fail_count , waiver_appeal_count , cant_appeal_count , other_appeal_count , suggestion_delete_count , unprocessed , process_rate , processed_no_appeal , '?' AS version FROM ? ;<br />
011- 真实SQL：select source_id,'type',receive_time,country,sale_admin_id,SUBSTRING_INDEX(dept_full_path,'_',3),SUBSTRING_INDEX(dept_full_path,'_',4),need_handle_exceptions,already_appealed_count,already_appealed_rate,appeal_success_count,appeal_success_rate,suggestion_appeal_count,delete_appeal_count,delete_appeal_rate,update_time,dept_sort,appeal_fail_count,waiver_appeal_count,cant_appeal_count,other_appeal_count,suggestion_delete_count,unprocessed,process_rate,processed_no_appeal,'1752622358' AS version from t_amazon_health_exception;<br />
012- 负责人参考：公用<br />
013- 项目参考：java项目<br />