错误信息:查询结果出错

TRACE

#0 错误代码:1317
#1 错误信息:Query execution was interrupted
#2 SQL语句:select a.id , a.name , b.valuess , c.minpicurl from prolisttab as a left join prodpropertab as b on b.prodid = a.id
left join (select prolisttabid , minpicurl from piclisttab where classt = '1' group by prolisttabid) as c on c.prolisttabid = a.id
where a.id in (select product_id from product_visit_record where user_is_del = '0' and type = '3' group by product_id order by visit_time desc)
and a.grounding in (1,2) and a.verify = '1' and a.isdel = '0' and b.propertyabid = '1' order by a.rectypeid desc limit 6