3、自测

3.1、查询已分配

SELECT Id,BackgroundID,SKU,TaskUserId,TaskUserName,AssignUserId, FROM AI_SynthesisGraph a 
	force INDEX (idx_SynStatus_IsDeleted_Status)   
	WHERE a.SynthesisStatus =2	AND a.`Status`=1  	AND a.IsDeleted=0  
-- 	and a.SKU='13349739' 
	and a.TaskUserId!=0	and a.ReviewStatus=0
	and SynthesisType='日常' 
	order by Id asc
	limit 100

update AI_SynthesisGraph 
	SET ReviewStatus=0,ReviewUserId=0,ReviewUserName=null
	,TaskUserId=0,TaskUserName=null
	,AssignUserId=0,AssignUserName=null,AssignTime=null
	,SynthesisType='日常'
	WHERE SynthesisStatus =2	AND `Status`=1  	AND IsDeleted=0