问一条简单的sql语句效率有关问题

问一条简单的sql语句效率问题
存储过程如下

SQL code

BEGIN  SELECT * FROM `literature` where `status`=1 and auditstatus=2 and UID in(select ItemId from userfavdata where GroupName='literature' and deviceID=`pDeviceId`  ) order by literatureYear,MagazineName;END

SQL code

IN `pDeviceId` char(36)