SELECT * FROM (SELECT g.goods_id, g.goods_name, g.goods_name_style, g.cat_id, g.market_price, g.is_new, g.is_best, g.is_hot, g.shop_price AS org_price, IFNULL(mp.user_price, g.shop_price * '1') AS shop_price, g.promote_price, g.goods_type, g.promote_start_date, g.promote_end_date, g.goods_brief, g.goods_thumb , g.goods_img FROM `got1shop_wangdian_dev`.`ecs_goods` AS g FORCE INDEX (combine2) LEFT JOIN `got1shop_wangdian_dev`.`ecs_member_price` AS mp ON mp.goods_id = g.goods_id AND mp.user_rank = '0' WHERE g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 AND (g.cat_id IN ('304','397','307','317','325','326','314','322','323','324','321','401','399','308','310','311','312','309','396','315','329','400','358','387','306','328','327','316','335','332','318','333','334','331','313','338','339','336','340','337') OR g.goods_id IN ('53667','53668','53669','53671','53672','53673','53674','53676','53677','53678','53679','53681','53698','53700','53701','53722','53723','53724','53725','53726','53727','53728','53729','53730','53731','53732','53733','53734','53735','53736','53737','53739','53740','53741','53742','53743','53745','53746','53747','53748','53768','53769','53770','53771','53772','53773','53774','53775','53776','53777','53778','53779','53780','53781','53782','53783','53784','53785','53786','53787','53788','53789','53790','53791','53792','53796','53797','53798','53799','53800','53801','53802','53803','53804','53805','53806','53807','53808','53809','53810','53811','53812','53813','53814','53815','53816','53817','53818','53819','53822','53823','53849','53850','53851','53852','53854','53855','57823','57827','57828','57835','57839','57850','57851','57855','57863','57866','57868','57869','57871','57872','57873','57875','57876','57877','57879','57881','57882','57883','57884','57885','57887','57888','57890','57891','72398','73576','73581','73582','73583','73591','73598','73599','74310','75343','75344','75346','75347','75348','75349','75350','75351','75352','75354','75355','75357','75358','75359','75360','75361','75363','75364','75365','75366','75367','75368','75369','75370','75371','75372','77285','77286','77287','77288','77289','81174','87826','88613','89996','143150','148995','173382','186606','205732','286593','286594','286595') ) ORDER BY last_update DESC LIMIT 0, 10) a LEFT JOIN ecs_goods b ON a.goods_id = b.goods_id