你自己先
explain SELECT 1,mid,UNIX_TIMESTAMP() FROM members WHERE sitemid IN (1,2,3,4,5) and sid>99
UNION
SELECT mid,1,UNIX_TIMESTAMP() FROM members WHERE sitemid IN (1,2,3,4,5) and sid>99
ON DUPLICATE KEY UPDATE fstatus=0
看看呀!
explain SELECT 1,mid,UNIX_TIMESTAMP() FROM members WHERE sitemid IN (1,2,3,4,5) and sid>99
UNION
SELECT mid,1,UNIX_TIMESTAMP() FROM members WHERE sitemid IN (1,2,3,4,5) and sid>99
ON DUPLICATE KEY UPDATE fstatus=0
看看呀!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货