SHOW FULL COLUMNS FROM `sysinfo` [ RunTime:0.009829s ]
SELECT * FROM `sysinfo` WHERE `id` = '1' LIMIT 1 [ RunTime:0.008765s ]
SHOW FULL COLUMNS FROM `sheng` [ RunTime:0.014946s ]
SELECT * FROM `sheng` ORDER BY `lasttime` DESC [ RunTime:0.008822s ]
SELECT * FROM `sheng` ORDER BY `lasttime` DESC LIMIT 1 [ RunTime:0.008733s ]
SHOW FULL COLUMNS FROM `report` [ RunTime:0.009393s ]
SELECT * FROM `report` WHERE `addtime` >= 1695895745 AND `class` = 'zhen' AND `tj_type` = 'zhen' AND `sid` = 0 AND `day` = 30 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.044475s ]
SHOW FULL COLUMNS FROM `news` [ RunTime:0.009569s ]
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` = '843' LIMIT 1 [ RunTime:0.008654s ]
UPDATE `news` SET `views` = `views` + 1 WHERE `id` = 843 [ RunTime:0.012044s ]
SHOW FULL COLUMNS FROM `comment` [ RunTime:0.009480s ]
SELECT COUNT(*) AS think_count FROM `comment` LEFT JOIN `user` ON `user`.`uid`=`comment`.`uid` WHERE `comment`.`status` = '1' AND `topic_id` = 843 AND `topic_type` = 'article' AND `toppic_comment_id` <= 0 LIMIT 1 [ RunTime:0.010418s ]
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.042140s ]
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.009716s ]
SHOW FULL COLUMNS FROM `zhen` [ RunTime:0.009528s ]
SHOW FULL COLUMNS FROM `shi` [ RunTime:0.009371s ]
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.011010s ]
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.010836s ]
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.043372s ]
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.010690s ]
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.010972s ]
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.010522s ]
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.012132s ]
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.053579s ]
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.011295s ]
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.010446s ]
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.010939s ]
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.011368s ]
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.054921s ]
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.011855s ]
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.011460s ]
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.010483s ]
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.011270s ]
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.054265s ]
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.010344s ]
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.010372s ]
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.011014s ]
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.011327s ]
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.055245s ]
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.010385s ]
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.010483s ]
评论区
留下您的评论或建议
回复评论