SELECT a.id,a.name as pname,a.price,a.member_id as userid,a.stock,c.company,b.property_2,b.property_3,b.property_4  FROM mb_product a left join mb_defind_1 b on a.id=b.product_id left join mb_shop c on a.member_id=c.userid WHERE c.shop_statu=1 and a.status>0 and a.is_shelves=1 and b.property_1=3 and a.is_index=1 order by (CASE WHEN (a.is_top=1 and a.is_rec=1) THEN 3 WHEN (a.is_top=1) THEN 2 WHEN (a.is_rec=1) THEN 1 ELSE 0 END) DESC,c.grade desc,a.uptime desc limit 0,10Query execution was interrupted