SHOW FULL COLUMNS FROM `sysinfo` [ RunTime:0.009775s ]
SELECT * FROM `sysinfo` WHERE `id` = '1' LIMIT 1 [ RunTime:0.008880s ]
SHOW FULL COLUMNS FROM `sheng` [ RunTime:0.009909s ]
SELECT * FROM `sheng` ORDER BY `lasttime` DESC [ RunTime:0.008889s ]
SELECT * FROM `sheng` ORDER BY `lasttime` DESC LIMIT 1 [ RunTime:0.008812s ]
SHOW FULL COLUMNS FROM `report` [ RunTime:0.009533s ]
SELECT * FROM `report` WHERE `addtime` >= 1695892435 AND `class` = 'zhen' AND `tj_type` = 'zhen' AND `sid` = 0 AND `day` = 30 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.012156s ]
SHOW FULL COLUMNS FROM `news` [ RunTime:0.010587s ]
SELECT `news`.*,news.views as num,news.id as ID,user.nick_name as author,news_class.name as classname FROM `news` LEFT JOIN `news_class` ON `news_class`.`id`=`news`.`class_id` LEFT JOIN `user` ON `user`.`uid`=`news`.`uid` WHERE `news`.`id` = '1051' LIMIT 1 [ RunTime:0.008898s ]
UPDATE `news` SET `views` = `views` + 1 WHERE `id` = 1051 [ RunTime:0.011716s ]
SHOW FULL COLUMNS FROM `comment` [ RunTime:0.009881s ]
SELECT COUNT(*) AS think_count FROM `comment` LEFT JOIN `user` ON `user`.`uid`=`comment`.`uid` WHERE `comment`.`status` = '1' AND `topic_id` = 1051 AND `topic_type` = 'article' AND `toppic_comment_id` <= 0 LIMIT 1 [ RunTime:0.011608s ]
SELECT id,title,IFNULL(user.nick_name,admin) as author,date_format(addtime,"%Y/%m/%d") as createTime,addtime,views,content,sort FROM `news` LEFT JOIN `user` ON `user`.`uid`=`news`.`uid` ORDER BY `sort` DESC,`addtime` DESC LIMIT 3 [ RunTime:0.010089s ]
SELECT id,title,IFNULL(user.nick_name,news.admin) as author,date_format(addtime,"%Y/%m/%d") as createTime,addtime,views,content,sort FROM `news` LEFT JOIN `user` ON `user`.`uid`=`news`.`uid` WHERE `id` NOT IN (944,910,98) AND `class_id` = 16 AND `news`.`status` = '1' AND `news`.`not_display` NOT LIKE '%未知%' ORDER BY `sort` DESC,`addtime` DESC LIMIT 5 [ RunTime:0.010057s ]
SHOW FULL COLUMNS FROM `zhen` [ RunTime:0.009657s ]
SHOW FULL COLUMNS FROM `shi` [ RunTime:0.021508s ]
SELECT COUNT(*) AS think_count FROM `shi` INNER JOIN `xian` ON `xian`.`ShiID`=`shi`.`ID` INNER JOIN `zhen` ON `zhen`.`XianID`=`xian`.`ID` WHERE `shi`.`ShengID` = '3' LIMIT 1 [ RunTime:0.011091s ]
SELECT COUNT(*) AS think_count FROM `shi` INNER JOIN `xian` ON `xian`.`ShiID`=`shi`.`ID` INNER JOIN `zhen` ON `zhen`.`XianID`=`xian`.`ID` WHERE `shi`.`ShengID` = '1' LIMIT 1 [ RunTime:0.010977s ]
SELECT COUNT(*) AS think_count FROM `shi` INNER JOIN `xian` ON `xian`.`ShiID`=`shi`.`ID` INNER JOIN `zhen` ON `zhen`.`XianID`=`xian`.`ID` WHERE `shi`.`ShengID` = '6' LIMIT 1 [ RunTime:0.011400s ]
SELECT COUNT(*) AS think_count FROM `shi` INNER JOIN `xian` ON `xian`.`ShiID`=`shi`.`ID` INNER JOIN `zhen` ON `zhen`.`XianID`=`xian`.`ID` WHERE `shi`.`ShengID` = '5' LIMIT 1 [ RunTime:0.010989s ]
SELECT COUNT(*) AS think_count FROM `shi` INNER JOIN `xian` ON `xian`.`ShiID`=`shi`.`ID` INNER JOIN `zhen` ON `zhen`.`XianID`=`xian`.`ID` WHERE `shi`.`ShengID` = '7' LIMIT 1 [ RunTime:0.011393s ]
SELECT COUNT(*) AS think_count FROM `shi` INNER JOIN `xian` ON `xian`.`ShiID`=`shi`.`ID` INNER JOIN `zhen` ON `zhen`.`XianID`=`xian`.`ID` WHERE `shi`.`ShengID` = '28' LIMIT 1 [ RunTime:0.011647s ]
SELECT COUNT(*) AS think_count FROM `shi` INNER JOIN `xian` ON `xian`.`ShiID`=`shi`.`ID` INNER JOIN `zhen` ON `zhen`.`XianID`=`xian`.`ID` WHERE `shi`.`ShengID` = '11' LIMIT 1 [ RunTime:0.012905s ]
SELECT COUNT(*) AS think_count FROM `shi` INNER JOIN `xian` ON `xian`.`ShiID`=`shi`.`ID` INNER JOIN `zhen` ON `zhen`.`XianID`=`xian`.`ID` WHERE `shi`.`ShengID` = '8' LIMIT 1 [ RunTime:0.019644s ]
SELECT COUNT(*) AS think_count FROM `shi` INNER JOIN `xian` ON `xian`.`ShiID`=`shi`.`ID` INNER JOIN `zhen` ON `zhen`.`XianID`=`xian`.`ID` WHERE `shi`.`ShengID` = '16' LIMIT 1 [ RunTime:0.010688s ]
SELECT COUNT(*) AS think_count FROM `shi` INNER JOIN `xian` ON `xian`.`ShiID`=`shi`.`ID` INNER JOIN `zhen` ON `zhen`.`XianID`=`xian`.`ID` WHERE `shi`.`ShengID` = '12' LIMIT 1 [ RunTime:0.010622s ]
SELECT COUNT(*) AS think_count FROM `shi` INNER JOIN `xian` ON `xian`.`ShiID`=`shi`.`ID` INNER JOIN `zhen` ON `zhen`.`XianID`=`xian`.`ID` WHERE `shi`.`ShengID` = '2' LIMIT 1 [ RunTime:0.011116s ]
SELECT COUNT(*) AS think_count FROM `shi` INNER JOIN `xian` ON `xian`.`ShiID`=`shi`.`ID` INNER JOIN `zhen` ON `zhen`.`XianID`=`xian`.`ID` WHERE `shi`.`ShengID` = '17' LIMIT 1 [ RunTime:0.011797s ]
SELECT COUNT(*) AS think_count FROM `shi` INNER JOIN `xian` ON `xian`.`ShiID`=`shi`.`ID` INNER JOIN `zhen` ON `zhen`.`XianID`=`xian`.`ID` WHERE `shi`.`ShengID` = '29' LIMIT 1 [ RunTime:0.010785s ]
SELECT COUNT(*) AS think_count FROM `shi` INNER JOIN `xian` ON `xian`.`ShiID`=`shi`.`ID` INNER JOIN `zhen` ON `zhen`.`XianID`=`xian`.`ID` WHERE `shi`.`ShengID` = '4' LIMIT 1 [ RunTime:0.011561s ]
SELECT COUNT(*) AS think_count FROM `shi` INNER JOIN `xian` ON `xian`.`ShiID`=`shi`.`ID` INNER JOIN `zhen` ON `zhen`.`XianID`=`xian`.`ID` WHERE `shi`.`ShengID` = '14' LIMIT 1 [ RunTime:0.010978s ]
SELECT COUNT(*) AS think_count FROM `shi` INNER JOIN `xian` ON `xian`.`ShiID`=`shi`.`ID` INNER JOIN `zhen` ON `zhen`.`XianID`=`xian`.`ID` WHERE `shi`.`ShengID` = '19' LIMIT 1 [ RunTime:0.010619s ]
SELECT COUNT(*) AS think_count FROM `shi` INNER JOIN `xian` ON `xian`.`ShiID`=`shi`.`ID` INNER JOIN `zhen` ON `zhen`.`XianID`=`xian`.`ID` WHERE `shi`.`ShengID` = '13' LIMIT 1 [ RunTime:0.011274s ]
SELECT COUNT(*) AS think_count FROM `shi` INNER JOIN `xian` ON `xian`.`ShiID`=`shi`.`ID` INNER JOIN `zhen` ON `zhen`.`XianID`=`xian`.`ID` WHERE `shi`.`ShengID` = '9' LIMIT 1 [ RunTime:0.010668s ]
SELECT COUNT(*) AS think_count FROM `shi` INNER JOIN `xian` ON `xian`.`ShiID`=`shi`.`ID` INNER JOIN `zhen` ON `zhen`.`XianID`=`xian`.`ID` WHERE `shi`.`ShengID` = '34' LIMIT 1 [ RunTime:0.010594s ]
SELECT COUNT(*) AS think_count FROM `shi` INNER JOIN `xian` ON `xian`.`ShiID`=`shi`.`ID` INNER JOIN `zhen` ON `zhen`.`XianID`=`xian`.`ID` WHERE `shi`.`ShengID` = '18' LIMIT 1 [ RunTime:0.010983s ]
SELECT COUNT(*) AS think_count FROM `shi` INNER JOIN `xian` ON `xian`.`ShiID`=`shi`.`ID` INNER JOIN `zhen` ON `zhen`.`XianID`=`xian`.`ID` WHERE `shi`.`ShengID` = '32' LIMIT 1 [ RunTime:0.010963s ]
SELECT COUNT(*) AS think_count FROM `shi` INNER JOIN `xian` ON `xian`.`ShiID`=`shi`.`ID` INNER JOIN `zhen` ON `zhen`.`XianID`=`xian`.`ID` WHERE `shi`.`ShengID` = '33' LIMIT 1 [ RunTime:0.011447s ]
SELECT COUNT(*) AS think_count FROM `shi` INNER JOIN `xian` ON `xian`.`ShiID`=`shi`.`ID` INNER JOIN `zhen` ON `zhen`.`XianID`=`xian`.`ID` WHERE `shi`.`ShengID` = '10' LIMIT 1 [ RunTime:0.011058s ]
SELECT COUNT(*) AS think_count FROM `shi` INNER JOIN `xian` ON `xian`.`ShiID`=`shi`.`ID` INNER JOIN `zhen` ON `zhen`.`XianID`=`xian`.`ID` WHERE `shi`.`ShengID` = '31' LIMIT 1 [ RunTime:0.011178s ]
SELECT COUNT(*) AS think_count FROM `shi` INNER JOIN `xian` ON `xian`.`ShiID`=`shi`.`ID` INNER JOIN `zhen` ON `zhen`.`XianID`=`xian`.`ID` WHERE `shi`.`ShengID` = '30' LIMIT 1 [ RunTime:0.010751s ]
评论区
留下您的评论或建议
回复评论