SHOW FULL COLUMNS FROM `sysinfo` [ RunTime:0.009884s ]
SELECT * FROM `sysinfo` WHERE `id` = '1' LIMIT 1 [ RunTime:0.009113s ]
SHOW FULL COLUMNS FROM `sheng` [ RunTime:0.009843s ]
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` = 'hunansheng' ORDER BY `shi`.`num` DESC [ RunTime:0.009424s ]
SHOW FULL COLUMNS FROM `report` [ RunTime:0.009861s ]
SELECT * FROM `report` WHERE `addtime` >= 1695895517 AND `class` = 'sheng' AND `tj_type` = 'zhen' AND `sid` = 6 AND `day` = 0 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009805s ]
SHOW FULL COLUMNS FROM `shi` [ RunTime:0.010010s ]
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.010504s ]
SHOW FULL COLUMNS FROM `xian` [ RunTime:0.009905s ]
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` = '6' ORDER BY `num` DESC LIMIT 12 [ RunTime:0.012296s ]
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` = 72 [ RunTime:0.010631s ]
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` = 73 [ RunTime:0.011308s ]
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` = 70 [ RunTime:0.011306s ]
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` = 79 [ RunTime:0.010740s ]
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` = 76 [ RunTime:0.011048s ]
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` = 69 [ RunTime:0.011228s ]
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` = 100 [ RunTime:0.010941s ]
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` = 81 [ RunTime:0.010819s ]
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` = 77 [ RunTime:0.010940s ]
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` = 101 [ RunTime:0.010995s ]
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` = 75 [ RunTime:0.010795s ]
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` = 78 [ RunTime:0.010785s ]
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` = 102 [ RunTime:0.010723s ]
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` = 222 [ RunTime:0.010702s ]
SHOW FULL COLUMNS FROM `news` [ RunTime:0.009881s ]
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.010244s ]
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.010312s ]
SELECT * FROM `report` WHERE `addtime` >= 1695895517 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 72 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009456s ]
SHOW FULL COLUMNS FROM `zhen` [ RunTime:0.009901s ]
SELECT COUNT(*) AS think_count FROM `zhen` LEFT JOIN `xian` ON `xian`.`ID`=`zhen`.`XianID` WHERE `xian`.`ShiID` = '72' AND `zhen`.`status` = '1' LIMIT 1 [ RunTime:0.010337s ]
SELECT * FROM `report` WHERE `addtime` >= 1695895517 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 72 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009393s ]
SELECT * FROM `report` WHERE `addtime` >= 1695895517 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 73 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009680s ]
SELECT * FROM `report` WHERE `addtime` >= 1695895517 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 70 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009374s ]
SELECT * FROM `report` WHERE `addtime` >= 1695895517 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 79 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009362s ]
SELECT COUNT(*) AS think_count FROM `zhen` LEFT JOIN `xian` ON `xian`.`ID`=`zhen`.`XianID` WHERE `xian`.`ShiID` = '79' AND `zhen`.`status` = '1' LIMIT 1 [ RunTime:0.010265s ]
SELECT * FROM `report` WHERE `addtime` >= 1695895517 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 79 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009482s ]
SELECT * FROM `report` WHERE `addtime` >= 1695895517 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 76 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009416s ]
SELECT COUNT(*) AS think_count FROM `zhen` LEFT JOIN `xian` ON `xian`.`ID`=`zhen`.`XianID` WHERE `xian`.`ShiID` = '76' AND `zhen`.`status` = '1' LIMIT 1 [ RunTime:0.010310s ]
SELECT * FROM `report` WHERE `addtime` >= 1695895517 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 76 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009597s ]
SELECT * FROM `report` WHERE `addtime` >= 1695895517 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 69 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009342s ]
SELECT * FROM `report` WHERE `addtime` >= 1695895517 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 100 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009447s ]
SELECT COUNT(*) AS think_count FROM `zhen` LEFT JOIN `xian` ON `xian`.`ID`=`zhen`.`XianID` WHERE `xian`.`ShiID` = '100' AND `zhen`.`status` = '1' LIMIT 1 [ RunTime:0.010123s ]
SELECT * FROM `report` WHERE `addtime` >= 1695895517 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 100 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009617s ]
SELECT * FROM `report` WHERE `addtime` >= 1695895518 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 81 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009564s ]
SELECT * FROM `report` WHERE `addtime` >= 1695895518 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 77 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009843s ]
SELECT * FROM `report` WHERE `addtime` >= 1695895518 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 101 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009701s ]
SELECT * FROM `report` WHERE `addtime` >= 1695895518 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 75 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009856s ]
SELECT * FROM `report` WHERE `addtime` >= 1695895518 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 78 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009778s ]
SELECT COUNT(*) AS think_count FROM `zhen` LEFT JOIN `xian` ON `xian`.`ID`=`zhen`.`XianID` WHERE `xian`.`ShiID` = '78' AND `zhen`.`status` = '1' LIMIT 1 [ RunTime:0.010425s ]
SELECT * FROM `report` WHERE `addtime` >= 1695895518 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 78 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009485s ]
SELECT * FROM `report` WHERE `addtime` >= 1695895518 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 102 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009636s ]
SELECT * FROM `report` WHERE `addtime` >= 1695895518 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 222 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009464s ]
