SHOW FULL COLUMNS FROM `sysinfo` [ RunTime:0.009678s ]
SELECT * FROM `sysinfo` WHERE `id` = '1' LIMIT 1 [ RunTime:0.008674s ]
SHOW FULL COLUMNS FROM `sheng` [ RunTime:0.009718s ]
SELECT * FROM `sheng` ORDER BY `lasttime` DESC [ RunTime:0.008841s ]
SELECT * FROM `sheng` ORDER BY `lasttime` DESC LIMIT 1 [ RunTime:0.008684s ]
SHOW FULL COLUMNS FROM `report` [ RunTime:0.009403s ]
SELECT * FROM `report` WHERE `addtime` >= 1695895293 AND `class` = 'zhen' AND `tj_type` = 'zhen' AND `sid` = 0 AND `day` = 30 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.012615s ]
SHOW FULL COLUMNS FROM `news` [ RunTime:0.009356s ]
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` = '1054' LIMIT 1 [ RunTime:0.009292s ]
UPDATE `news` SET `views` = `views` + 1 WHERE `id` = 1054 [ RunTime:0.011823s ]
SHOW FULL COLUMNS FROM `comment` [ RunTime:0.009560s ]
SELECT COUNT(*) AS think_count FROM `comment` LEFT JOIN `user` ON `user`.`uid`=`comment`.`uid` WHERE `comment`.`status` = '1' AND `topic_id` = 1054 AND `topic_type` = 'article' AND `toppic_comment_id` <= 0 LIMIT 1 [ RunTime:0.010171s ]
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.009800s ]
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.009891s ]
SHOW FULL COLUMNS FROM `zhen` [ RunTime:0.009671s ]
SHOW FULL COLUMNS FROM `shi` [ RunTime:0.009426s ]
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.011201s ]
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.011189s ]
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.011946s ]
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.010797s ]
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.010995s ]
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.010847s ]
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.012129s ]
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.010782s ]
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.010602s ]
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.010512s ]
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.011389s ]
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.011683s ]
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.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` = '4' LIMIT 1 [ RunTime:0.011427s ]
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.010880s ]
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.010859s ]
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.010872s ]
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.010417s ]
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.010284s ]
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.010604s ]
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.010391s ]
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.010489s ]
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.010383s ]
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.010419s ]
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.010289s ]
评论区
留下您的评论或建议
回复评论