SHOW FULL COLUMNS FROM `sysinfo` [ RunTime:0.009667s ]
SELECT * FROM `sysinfo` WHERE `id` = '1' LIMIT 1 [ RunTime:0.008756s ]
SHOW FULL COLUMNS FROM `sheng` [ RunTime:0.009653s ]
SELECT * FROM `sheng` ORDER BY `lasttime` DESC [ RunTime:0.008842s ]
SELECT * FROM `sheng` ORDER BY `lasttime` DESC LIMIT 1 [ RunTime:0.008894s ]
SHOW FULL COLUMNS FROM `report` [ RunTime:0.009605s ]
SELECT * FROM `report` WHERE `addtime` >= 1695895442 AND `class` = 'zhen' AND `tj_type` = 'zhen' AND `sid` = 0 AND `day` = 30 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.012815s ]
SHOW FULL COLUMNS FROM `news` [ RunTime:0.009577s ]
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` = '1038' LIMIT 1 [ RunTime:0.008925s ]
UPDATE `news` SET `views` = `views` + 1 WHERE `id` = 1038 [ RunTime:0.012030s ]
SHOW FULL COLUMNS FROM `comment` [ RunTime:0.009539s ]
SELECT COUNT(*) AS think_count FROM `comment` LEFT JOIN `user` ON `user`.`uid`=`comment`.`uid` WHERE `comment`.`status` = '1' AND `topic_id` = 1038 AND `topic_type` = 'article' AND `toppic_comment_id` <= 0 LIMIT 1 [ RunTime:0.010232s ]
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.010024s ]
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.010345s ]
SHOW FULL COLUMNS FROM `zhen` [ RunTime:0.009988s ]
SHOW FULL COLUMNS FROM `shi` [ RunTime:0.009818s ]
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.012145s ]
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.011718s ]
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.011401s ]
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.010779s ]
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.011048s ]
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.011329s ]
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.012865s ]
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.010816s ]
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.010711s ]
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.010540s ]
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.011020s ]
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.011660s ]
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.011060s ]
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.012027s ]
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.011506s ]
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.011204s ]
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.011540s ]
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.010992s ]
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.010722s ]
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.010456s ]
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.010388s ]
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.010748s ]
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.010593s ]
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.010962s ]
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.010651s ]
评论区
留下您的评论或建议
回复评论