SELECT * FROM `h291804`.`by_member_login` WHERE logintime < 1741465980; [ RunTime:0.000101s ]
UPDATE `h291804`.`by_member` SET `islock`='1' WHERE `userid` = '7'; [ RunTime:0.004623s ]
UPDATE `h291804`.`by_member` SET `islock`='1' WHERE `userid` = '6'; [ RunTime:0.004540s ]
SELECT * FROM `h291804`.`by_admin_login` WHERE logintime < 1741465980; [ RunTime:0.000107s ]
SELECT * FROM `h291804`.`by_wiki` WHERE `id` = '1032' LIMIT 1; [ RunTime:0.000560s ]
SELECT * FROM `h291804`.`by_wiki_data_0` WHERE `id` = '1032' LIMIT 1; [ RunTime:0.001070s ]
SELECT * FROM `h291804`.`by_category_priv` WHERE `catid` = '77' AND `is_admin` = '0' AND `action` = 'visit' ; [ RunTime:0.000101s ]
SELECT * FROM `h291804`.`by_wiki` WHERE `catid` = '77' AND `id`<'1032' AND `status`=99 ORDER BY id DESC LIMIT 1; [ RunTime:0.002043s ]
SELECT * FROM `h291804`.`by_wiki` WHERE `catid`= '77' AND `id`>'1032' AND `status`=99 ORDER BY id ASC LIMIT 1; [ RunTime:0.000363s ]
SELECT * FROM `h291804`.`by_position_data` WHERE catid='0' AND `posid` = '6' AND `siteid` = '1' ORDER BY id LIMIT 10; [ RunTime:0.001966s ]
SELECT `title` FROM `h291804`.`by_wiki` WHERE status=99 ORDER BY posids DESC,id ASC LIMIT 0,500000; [ RunTime:0.006323s ]
select * from by_wiki_relation where byid='1032' or xgid='1032' or xgtitle='魏讽' order by id ASC LIMIT 8; [ RunTime:0.004320s ]
SELECT `title` FROM `h291804`.`by_wiki` WHERE status=99 ORDER BY posids DESC,id ASC LIMIT 0,500000; [ RunTime:0.005074s ]
SELECT `title` FROM `h291804`.`by_wiki` WHERE status=99 ORDER BY posids DESC,id ASC LIMIT 0,500000; [ RunTime:0.000321s ]
SELECT `title` FROM `h291804`.`by_wiki` WHERE status=99 ORDER BY posids DESC,id ASC LIMIT 0,500000; [ RunTime:0.002259s ]
SELECT `title` FROM `h291804`.`by_wiki` WHERE status=99 ORDER BY posids DESC,id ASC LIMIT 0,500000; [ RunTime:0.000807s ]
SELECT `title` FROM `h291804`.`by_wiki` WHERE status=99 ORDER BY posids DESC,id ASC LIMIT 0,500000; [ RunTime:0.001325s ]
SELECT `title` FROM `h291804`.`by_wiki` WHERE status=99 ORDER BY posids DESC,id ASC LIMIT 0,500000; [ RunTime:0.002027s ]
SELECT `title` FROM `h291804`.`by_wiki` WHERE status=99 ORDER BY posids DESC,id ASC LIMIT 0,500000; [ RunTime:0.000612s ]
SELECT `title` FROM `h291804`.`by_wiki` WHERE status=99 ORDER BY posids DESC,id ASC LIMIT 0,500000; [ RunTime:0.000472s ]
SELECT * FROM `h291804`.`by_article` WHERE status=99 AND catid IN (7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39) AND (title like '%魏讽%' or keywords like '%魏讽%') ORDER BY posids DESC,id DESC LIMIT 1; [ RunTime:0.001771s ]
SELECT * FROM `h291804`.`by_article` WHERE status=99 AND catid IN (7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39) AND (title like '%魏讽%' or keywords like '%魏讽%') ORDER BY posids DESC,id DESC LIMIT 10; [ RunTime:0.001581s ]
