SHOW FULL COLUMNS FROM `sysinfo` [ RunTime:0.009508s ]
SELECT * FROM `sysinfo` WHERE `id` = '1' LIMIT 1 [ RunTime:0.010322s ]
SHOW FULL COLUMNS FROM `sheng` [ RunTime:0.009409s ]
SELECT * FROM `sheng` ORDER BY `lasttime` DESC [ RunTime:0.008692s ]
SELECT * FROM `sheng` ORDER BY `lasttime` DESC LIMIT 1 [ RunTime:0.008709s ]
SHOW FULL COLUMNS FROM `report` [ RunTime:0.009796s ]
SELECT * FROM `report` WHERE `addtime` >= 1695892732 AND `class` = 'zhen' AND `tj_type` = 'zhen' AND `sid` = 0 AND `day` = 30 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.012493s ]
SHOW FULL COLUMNS FROM `news` [ RunTime:0.009953s ]
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` = '889' LIMIT 1 [ RunTime:0.008936s ]
UPDATE `news` SET `views` = `views` + 1 WHERE `id` = 889 [ RunTime:0.012494s ]
SHOW FULL COLUMNS FROM `comment` [ RunTime:0.009902s ]
SELECT COUNT(*) AS think_count FROM `comment` LEFT JOIN `user` ON `user`.`uid`=`comment`.`uid` WHERE `comment`.`status` = '1' AND `topic_id` = 889 AND `topic_type` = 'article' AND `toppic_comment_id` <= 0 LIMIT 1 [ RunTime:0.010439s ]
SELECT `comment`.`id`,`comment`.`topic_id`,`comment`.`topic_type`,`comment`.`content`,`comment`.`praise`,`comment`.`add_time`,`comment`.`picture_ids`,`comment`.`add_ip`,`user`.`uid`,`user`.`nick_name`,`user`.`avatar` FROM `comment` LEFT JOIN `user` ON `user`.`uid`=`comment`.`uid` WHERE `comment`.`status` = '1' AND `topic_id` = 889 AND `topic_type` = 'article' AND `toppic_comment_id` <= 0 ORDER BY `comment`.`id` DESC LIMIT 0,10 [ RunTime:0.011557s ]
SELECT `comment`.`id`,`comment`.`topic_id`,`comment`.`topic_type`,`comment`.`content`,`comment`.`praise`,`comment`.`add_time`,`comment`.`add_ip`,`user`.`uid`,`user`.`nick_name`,`user`.`avatar`,t.nick_name as rt_name FROM `comment` LEFT JOIN `user` ON `user`.`uid`=`comment`.`uid` LEFT JOIN `user` `t` ON `t`.`uid`=`comment`.`re_uid` WHERE `comment`.`status` = '1' AND `toppic_comment_id` = 2639 ORDER BY `comment`.`id` ASC [ RunTime:0.011169s ]
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.009884s ]
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.009673s ]
SHOW FULL COLUMNS FROM `zhen` [ RunTime:0.009441s ]
SHOW FULL COLUMNS FROM `shi` [ RunTime:0.009258s ]
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.010909s ]
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.010931s ]
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.011086s ]
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.010787s ]
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.010951s ]
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.010964s ]
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.011698s ]
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.010515s ]
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.010765s ]
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.011208s ]
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.011002s ]
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.011695s ]
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.010499s ]
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.011167s ]
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.010913s ]
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.010432s ]
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.010628s ]
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.010332s ]
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.010124s ]
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.014890s ]
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.017624s ]
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.012977s ]
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.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` = '31' LIMIT 1 [ RunTime:0.010270s ]
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.010233s ]
冷傲的板凳
山东临沂河东月亮湾集是农历三八日
回复
小光
好的，非常感谢您的补充，已经收录
回复