001- 反馈人：缪金荣
001+ 反馈人：缪金荣 严重级别：严重 所属项目：仓储物流 问题原因：查询导致zhcxkj-center-warehouse OOM，SQL：SELECT a.actual_buy_num, a.process_num, a.bad_num, a.tally_num, a.put_in_area_name, a.put_in_position_code, a.put_in_num, a.task_state, a.buy_user_name, a.buy_time, a.process_user_name, a.process_time, a.check_time, a.check_user_name, a.tally_user_name, a.tally_time, a.put_in_time, a.put_in_user_name, a.source_type, a.box_no, a.is_return_to_good, a.order_buy_id, b.recommend_position_codes, a.is_fragile, a.abnormal_num, a.abnormal_user_id, a.abnormal_user_name, a.abnormal_time, a.abnormal_node, a.is_abnormal, a.abnormal_return_num, a.abnormal_return_user_id, a.abnormal_return_name, a.abnormal_return_time, a.id, a.is_two_tally, a.two_tally_num, a.two_tally_admin_id, a.two_tally_user_name, a.two_tally_time, b.recommend_area_name as recommendAreaName, IFNULL(c.card_no,'') as card_no FROM t_stk_receiptandstorage_detail a left join t_stk_mark_record b on a.box_no=b.mark_no left join t_stk_pallet_record c on a.box_no=c.mark_no and c.bind_type in(1,6,7) order by return_good_box_no asc; 解决方案：建议分页查询，如果有其他问题需要排查
002- 严重级别：严重
003- 所属项目：仓储物流
004- 问题原因：查询导致zhcxkj-center-warehouse OOM，SQL：SELECT a.actual_buy_num, a.process_num, a.bad_num, a.tally_num, a.put_in_area_name, a.put_in_position_code, a.put_in_num, a.task_state, a.buy_user_name, a.buy_time, a.process_user_name, a.process_time, a.check_time, a.check_user_name, a.tally_user_name, a.tally_time, a.put_in_time, a.put_in_user_name, a.source_type, a.box_no, a.is_return_to_good, a.order_buy_id, b.recommend_position_codes, a.is_fragile, a.abnormal_num, a.abnormal_user_id, a.abnormal_user_name, a.abnormal_time, a.abnormal_node, a.is_abnormal, a.abnormal_return_num, a.abnormal_return_user_id, a.abnormal_return_name, a.abnormal_return_time, a.id, a.is_two_tally, a.two_tally_num, a.two_tally_admin_id, a.two_tally_user_name, a.two_tally_time, b.recommend_area_name as recommendAreaName, IFNULL(c.card_no,'') as card_no FROM t_stk_receiptandstorage_detail a left join t_stk_mark_record b on a.box_no=b.mark_no left join t_stk_pallet_record c on a.box_no=c.mark_no and c.bind_type in(1,6,7) order by return_good_box_no asc;
005- 解决方案：建议分页查询，如果有其他问题需要排查

001- 反馈人：缪金荣<br />
001+ 反馈人：缪金荣<br /> 严重级别：严重<br /> 所属项目：仓储物流<br /> 问题原因：查询导致zhcxkj-center-warehouse OOM，SQL：SELECT a.actual_buy_num, a.process_num, a.bad_num, a.tally_num, a.put_in_area_name, a.put_in_position_code, a.put_in_num, a.task_state, a.buy_user_name, a.buy_time, a.process_user_name, a.process_time, a.check_time, a.check_user_name, a.tally_user_name, a.tally_time, a.put_in_time, a.put_in_user_name, a.source_type, a.box_no, a.is_return_to_good, a.order_buy_id, b.recommend_position_codes, a.is_fragile, a.abnormal_num, a.abnormal_user_id, a.abnormal_user_name, a.abnormal_time, a.abnormal_node, a.is_abnormal, a.abnormal_return_num, a.abnormal_return_user_id, a.abnormal_return_name, a.abnormal_return_time, a.id, a.is_two_tally, a.two_tally_num, a.two_tally_admin_id, a.two_tally_user_name, a.two_tally_time, b.recommend_area_name as recommendAreaName, IFNULL(c.card_no,'') as card_no FROM t_stk_receiptandstorage_detail a left join t_stk_mark_record b on a.box_no=b.mark_no left join t_stk_pallet_record c on a.box_no=c.mark_no and c.bind_type in(1,6,7) order by return_good_box_no asc;<br /> 解决方案：建议分页查询，如果有其他问题需要排查
002- 严重级别：严重<br />
003- 所属项目：仓储物流<br />
004- 问题原因：查询导致zhcxkj-center-warehouse OOM，SQL：SELECT a.actual_buy_num, a.process_num, a.bad_num, a.tally_num, a.put_in_area_name, a.put_in_position_code, a.put_in_num, a.task_state, a.buy_user_name, a.buy_time, a.process_user_name, a.process_time, a.check_time, a.check_user_name, a.tally_user_name, a.tally_time, a.put_in_time, a.put_in_user_name, a.source_type, a.box_no, a.is_return_to_good, a.order_buy_id, b.recommend_position_codes, a.is_fragile, a.abnormal_num, a.abnormal_user_id, a.abnormal_user_name, a.abnormal_time, a.abnormal_node, a.is_abnormal, a.abnormal_return_num, a.abnormal_return_user_id, a.abnormal_return_name, a.abnormal_return_time, a.id, a.is_two_tally, a.two_tally_num, a.two_tally_admin_id, a.two_tally_user_name, a.two_tally_time, b.recommend_area_name as recommendAreaName, IFNULL(c.card_no,'') as card_no FROM t_stk_receiptandstorage_detail a left join t_stk_mark_record b on a.box_no=b.mark_no left join t_stk_pallet_record c on a.box_no=c.mark_no and c.bind_type in(1,6,7) order by return_good_box_no asc;<br />
005- 解决方案：建议分页查询，如果有其他问题需要排查