SHOW FULL COLUMNS FROM `sysinfo` [ RunTime:0.009965s ]
SELECT * FROM `sysinfo` WHERE `id` = '1' LIMIT 1 [ RunTime:0.008982s ]
SHOW FULL COLUMNS FROM `sheng` [ RunTime:0.009871s ]
SELECT * FROM `sheng` ORDER BY `lasttime` DESC [ RunTime:0.009092s ]
SELECT `sheng`.*,sheng.py as sheng_py,shi.sub_title as shi_sub_title,`shi`.`shi`,shi.py as shi_py,shi.lasttime as shi_lasttime FROM `sheng` LEFT JOIN `shi` ON `sheng`.`ID`=`shi`.`ShengID` WHERE `sheng`.`py` = 'guangxi' ORDER BY `shi`.`num` DESC [ RunTime:0.009370s ]
SHOW FULL COLUMNS FROM `report` [ RunTime:0.012496s ]
SELECT * FROM `report` WHERE `addtime` >= 1695893184 AND `class` = 'sheng' AND `tj_type` = 'zhen' AND `sid` = 1 AND `day` = 0 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009956s ]
SHOW FULL COLUMNS FROM `shi` [ RunTime:0.010051s ]
SELECT `shi`.*,shi.num as views,`sheng`.`sheng`,sheng.sub_title as sheng_title FROM `shi` LEFT JOIN `sheng` ON `sheng`.`ID`=`shi`.`ShengID` WHERE `sheng` = '广西' ORDER BY `num` DESC [ RunTime:0.010303s ]
SHOW FULL COLUMNS FROM `xian` [ RunTime:0.010318s ]
SELECT `xian`.*,xian.ID as id,xian.num as views,xian.py as xian_py,`shi`.`shi`,shi.sub_title as shi_title,shi.img as shi_img,shi.py as shi_py,`sheng`.`sheng`,sheng.sub_title as sheng_title FROM `xian` LEFT JOIN `shi` ON `shi`.`ID`=`xian`.`ShiID` LEFT JOIN `sheng` ON `sheng`.`ID`=`shi`.`ShengID` WHERE `sheng`.`ID` = '1' ORDER BY `num` DESC LIMIT 12 [ RunTime:0.011141s ]
SELECT `xian`.*,xian.ID as id,xian.num as views,`shi`.`shi`,shi.sub_title as shi_title,shi.img as shi_img,shi.py as shi_py,`sheng`.`sheng`,sheng.sub_title as sheng_title FROM `xian` LEFT JOIN `shi` ON `shi`.`ID`=`xian`.`ShiID` LEFT JOIN `sheng` ON `sheng`.`ID`=`shi`.`ShengID` WHERE `ShiID` = 2 [ RunTime:0.011407s ]
SELECT `xian`.*,xian.ID as id,xian.num as views,`shi`.`shi`,shi.sub_title as shi_title,shi.img as shi_img,shi.py as shi_py,`sheng`.`sheng`,sheng.sub_title as sheng_title FROM `xian` LEFT JOIN `shi` ON `shi`.`ID`=`xian`.`ShiID` LEFT JOIN `sheng` ON `sheng`.`ID`=`shi`.`ShengID` WHERE `ShiID` = 5 [ RunTime:0.010688s ]
SELECT `xian`.*,xian.ID as id,xian.num as views,`shi`.`shi`,shi.sub_title as shi_title,shi.img as shi_img,shi.py as shi_py,`sheng`.`sheng`,sheng.sub_title as sheng_title FROM `xian` LEFT JOIN `shi` ON `shi`.`ID`=`xian`.`ShiID` LEFT JOIN `sheng` ON `sheng`.`ID`=`shi`.`ShengID` WHERE `ShiID` = 6 [ RunTime:0.010577s ]
SELECT `xian`.*,xian.ID as id,xian.num as views,`shi`.`shi`,shi.sub_title as shi_title,shi.img as shi_img,shi.py as shi_py,`sheng`.`sheng`,sheng.sub_title as sheng_title FROM `xian` LEFT JOIN `shi` ON `shi`.`ID`=`xian`.`ShiID` LEFT JOIN `sheng` ON `sheng`.`ID`=`shi`.`ShengID` WHERE `ShiID` = 1 [ RunTime:0.010798s ]
SELECT `xian`.*,xian.ID as id,xian.num as views,`shi`.`shi`,shi.sub_title as shi_title,shi.img as shi_img,shi.py as shi_py,`sheng`.`sheng`,sheng.sub_title as sheng_title FROM `xian` LEFT JOIN `shi` ON `shi`.`ID`=`xian`.`ShiID` LEFT JOIN `sheng` ON `sheng`.`ID`=`shi`.`ShengID` WHERE `ShiID` = 8 [ RunTime:0.010403s ]
SELECT `xian`.*,xian.ID as id,xian.num as views,`shi`.`shi`,shi.sub_title as shi_title,shi.img as shi_img,shi.py as shi_py,`sheng`.`sheng`,sheng.sub_title as sheng_title FROM `xian` LEFT JOIN `shi` ON `shi`.`ID`=`xian`.`ShiID` LEFT JOIN `sheng` ON `sheng`.`ID`=`shi`.`ShengID` WHERE `ShiID` = 7 [ RunTime:0.010418s ]
SELECT `xian`.*,xian.ID as id,xian.num as views,`shi`.`shi`,shi.sub_title as shi_title,shi.img as shi_img,shi.py as shi_py,`sheng`.`sheng`,sheng.sub_title as sheng_title FROM `xian` LEFT JOIN `shi` ON `shi`.`ID`=`xian`.`ShiID` LEFT JOIN `sheng` ON `sheng`.`ID`=`shi`.`ShengID` WHERE `ShiID` = 12 [ RunTime:0.010582s ]
SELECT `xian`.*,xian.ID as id,xian.num as views,`shi`.`shi`,shi.sub_title as shi_title,shi.img as shi_img,shi.py as shi_py,`sheng`.`sheng`,sheng.sub_title as sheng_title FROM `xian` LEFT JOIN `shi` ON `shi`.`ID`=`xian`.`ShiID` LEFT JOIN `sheng` ON `sheng`.`ID`=`shi`.`ShengID` WHERE `ShiID` = 11 [ RunTime:0.010636s ]
SELECT `xian`.*,xian.ID as id,xian.num as views,`shi`.`shi`,shi.sub_title as shi_title,shi.img as shi_img,shi.py as shi_py,`sheng`.`sheng`,sheng.sub_title as sheng_title FROM `xian` LEFT JOIN `shi` ON `shi`.`ID`=`xian`.`ShiID` LEFT JOIN `sheng` ON `sheng`.`ID`=`shi`.`ShengID` WHERE `ShiID` = 9 [ RunTime:0.010526s ]
SELECT `xian`.*,xian.ID as id,xian.num as views,`shi`.`shi`,shi.sub_title as shi_title,shi.img as shi_img,shi.py as shi_py,`sheng`.`sheng`,sheng.sub_title as sheng_title FROM `xian` LEFT JOIN `shi` ON `shi`.`ID`=`xian`.`ShiID` LEFT JOIN `sheng` ON `sheng`.`ID`=`shi`.`ShengID` WHERE `ShiID` = 4 [ RunTime:0.010413s ]
SELECT `xian`.*,xian.ID as id,xian.num as views,`shi`.`shi`,shi.sub_title as shi_title,shi.img as shi_img,shi.py as shi_py,`sheng`.`sheng`,sheng.sub_title as sheng_title FROM `xian` LEFT JOIN `shi` ON `shi`.`ID`=`xian`.`ShiID` LEFT JOIN `sheng` ON `sheng`.`ID`=`shi`.`ShengID` WHERE `ShiID` = 14 [ RunTime:0.011200s ]
SELECT `xian`.*,xian.ID as id,xian.num as views,`shi`.`shi`,shi.sub_title as shi_title,shi.img as shi_img,shi.py as shi_py,`sheng`.`sheng`,sheng.sub_title as sheng_title FROM `xian` LEFT JOIN `shi` ON `shi`.`ID`=`xian`.`ShiID` LEFT JOIN `sheng` ON `sheng`.`ID`=`shi`.`ShengID` WHERE `ShiID` = 13 [ RunTime:0.010468s ]
SELECT `xian`.*,xian.ID as id,xian.num as views,`shi`.`shi`,shi.sub_title as shi_title,shi.img as shi_img,shi.py as shi_py,`sheng`.`sheng`,sheng.sub_title as sheng_title FROM `xian` LEFT JOIN `shi` ON `shi`.`ID`=`xian`.`ShiID` LEFT JOIN `sheng` ON `sheng`.`ID`=`shi`.`ShengID` WHERE `ShiID` = 15 [ RunTime:0.010786s ]
SELECT `xian`.*,xian.ID as id,xian.num as views,`shi`.`shi`,shi.sub_title as shi_title,shi.img as shi_img,shi.py as shi_py,`sheng`.`sheng`,sheng.sub_title as sheng_title FROM `xian` LEFT JOIN `shi` ON `shi`.`ID`=`xian`.`ShiID` LEFT JOIN `sheng` ON `sheng`.`ID`=`shi`.`ShengID` WHERE `ShiID` = 10 [ RunTime:0.011199s ]
SHOW FULL COLUMNS FROM `news` [ RunTime:0.009748s ]
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.009961s ]
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` = 19 AND `news`.`status` = '1' AND `news`.`not_display` NOT LIKE '%未知%' ORDER BY `sort` DESC,`addtime` DESC LIMIT 5 [ RunTime:0.010333s ]
SELECT * FROM `report` WHERE `addtime` >= 1695893184 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 2 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009800s ]
SELECT * FROM `report` WHERE `addtime` >= 1695893184 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 5 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009464s ]
SELECT * FROM `report` WHERE `addtime` >= 1695893184 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 6 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009793s ]
SELECT * FROM `report` WHERE `addtime` >= 1695893184 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 1 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.010129s ]
SELECT * FROM `report` WHERE `addtime` >= 1695893184 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 8 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.011979s ]
SELECT * FROM `report` WHERE `addtime` >= 1695893184 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 7 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009815s ]
SELECT * FROM `report` WHERE `addtime` >= 1695893184 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 12 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009619s ]
SELECT * FROM `report` WHERE `addtime` >= 1695893184 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 11 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009460s ]
SELECT * FROM `report` WHERE `addtime` >= 1695893184 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 9 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009591s ]
SHOW FULL COLUMNS FROM `zhen` [ RunTime:0.009895s ]
SELECT COUNT(*) AS think_count FROM `zhen` LEFT JOIN `xian` ON `xian`.`ID`=`zhen`.`XianID` WHERE `xian`.`ShiID` = '9' AND `zhen`.`status` = '1' LIMIT 1 [ RunTime:0.009668s ]
SELECT * FROM `report` WHERE `addtime` >= 1695893184 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 9 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009763s ]
SELECT * FROM `report` WHERE `addtime` >= 1695893184 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 4 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009842s ]
SELECT * FROM `report` WHERE `addtime` >= 1695893184 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 14 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009700s ]
SELECT * FROM `report` WHERE `addtime` >= 1695893184 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 13 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009836s ]
SELECT * FROM `report` WHERE `addtime` >= 1695893184 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 15 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009217s ]
SELECT COUNT(*) AS think_count FROM `zhen` LEFT JOIN `xian` ON `xian`.`ID`=`zhen`.`XianID` WHERE `xian`.`ShiID` = '15' AND `zhen`.`status` = '1' LIMIT 1 [ RunTime:0.009881s ]
SELECT * FROM `report` WHERE `addtime` >= 1695893184 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 15 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009488s ]
SELECT * FROM `report` WHERE `addtime` >= 1695893184 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 10 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009436s ]