SHOW FULL COLUMNS FROM `sysinfo` [ RunTime:0.009611s ]
SELECT * FROM `sysinfo` WHERE `id` = '1' LIMIT 1 [ RunTime:0.009067s ]
SHOW FULL COLUMNS FROM `sheng` [ RunTime:0.009940s ]
SELECT * FROM `sheng` ORDER BY `lasttime` DESC [ RunTime:0.009001s ]
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` = 'yunnan' ORDER BY `shi`.`num` DESC [ RunTime:0.009468s ]
SHOW FULL COLUMNS FROM `report` [ RunTime:0.009866s ]
SELECT * FROM `report` WHERE `addtime` >= 1695892400 AND `class` = 'sheng' AND `tj_type` = 'zhen' AND `sid` = 3 AND `day` = 0 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009726s ]
SHOW FULL COLUMNS FROM `shi` [ RunTime:0.010056s ]
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.010229s ]
SHOW FULL COLUMNS FROM `xian` [ RunTime:0.009772s ]
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` = '3' ORDER BY `num` DESC LIMIT 12 [ RunTime:0.011939s ]
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` = 44 [ RunTime:0.010767s ]
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` = 53 [ RunTime:0.010622s ]
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` = 22 [ RunTime:0.010533s ]
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` = 23 [ RunTime:0.010909s ]
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` = 49 [ RunTime:0.010754s ]
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` = 54 [ RunTime:0.011460s ]
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` = 45 [ RunTime:0.010861s ]
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` = 52 [ RunTime:0.010670s ]
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` = 48 [ RunTime:0.010502s ]
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` = 51 [ RunTime:0.010762s ]
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` = 50 [ RunTime:0.010806s ]
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` = 47 [ RunTime:0.010977s ]
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` = 46 [ RunTime:0.010890s ]
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` = 55 [ RunTime:0.010845s ]
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` = 241 [ RunTime:0.011662s ]
SHOW FULL COLUMNS FROM `news` [ RunTime:0.010295s ]
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.010473s ]
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.010806s ]
SELECT * FROM `report` WHERE `addtime` >= 1695892401 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 44 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009649s ]
SELECT * FROM `report` WHERE `addtime` >= 1695892401 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 53 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009483s ]
SELECT * FROM `report` WHERE `addtime` >= 1695892401 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 22 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009370s ]
SELECT * FROM `report` WHERE `addtime` >= 1695892401 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 23 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009392s ]
SELECT * FROM `report` WHERE `addtime` >= 1695892401 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 49 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009389s ]
SELECT * FROM `report` WHERE `addtime` >= 1695892401 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 54 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009378s ]
SELECT * FROM `report` WHERE `addtime` >= 1695892401 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 45 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009338s ]
SELECT * FROM `report` WHERE `addtime` >= 1695892401 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 52 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009654s ]
SELECT * FROM `report` WHERE `addtime` >= 1695892401 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 48 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.017928s ]
SELECT * FROM `report` WHERE `addtime` >= 1695892401 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 51 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009872s ]
SELECT * FROM `report` WHERE `addtime` >= 1695892401 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 50 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009694s ]
SELECT * FROM `report` WHERE `addtime` >= 1695892401 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 47 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009704s ]
SELECT * FROM `report` WHERE `addtime` >= 1695892401 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 46 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009743s ]
SELECT * FROM `report` WHERE `addtime` >= 1695892401 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 55 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009710s ]
SELECT * FROM `report` WHERE `addtime` >= 1695892401 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 241 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009792s ]
