SHOW FULL COLUMNS FROM `sysinfo` [ RunTime:0.009832s ]
SELECT * FROM `sysinfo` WHERE `id` = '1' LIMIT 1 [ RunTime:0.008982s ]
SHOW FULL COLUMNS FROM `sheng` [ RunTime:0.009848s ]
SELECT * FROM `sheng` ORDER BY `lasttime` DESC [ RunTime:0.009009s ]
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` = 'liaoning' ORDER BY `shi`.`num` DESC [ RunTime:0.009328s ]
SHOW FULL COLUMNS FROM `report` [ RunTime:0.010259s ]
SELECT * FROM `report` WHERE `addtime` >= 1695892470 AND `class` = 'sheng' AND `tj_type` = 'zhen' AND `sid` = 28 AND `day` = 0 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.010029s ]
SHOW FULL COLUMNS FROM `shi` [ RunTime:0.010112s ]
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.010315s ]
SHOW FULL COLUMNS FROM `xian` [ RunTime:0.009845s ]
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` = '28' ORDER BY `num` DESC LIMIT 12 [ RunTime:0.014420s ]
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` = 149 [ RunTime:0.010597s ]
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` = 230 [ RunTime:0.024114s ]
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` = 150 [ RunTime:0.010810s ]
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` = 240 [ RunTime:0.010593s ]
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` = 151 [ 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` = 238 [ RunTime:0.010507s ]
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` = 233 [ RunTime:0.010490s ]
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` = 231 [ RunTime:0.010507s ]
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` = 237 [ RunTime:0.010546s ]
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` = 153 [ RunTime:0.010453s ]
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` = 152 [ RunTime:0.010530s ]
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` = 232 [ RunTime:0.010924s ]
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` = 236 [ RunTime:0.010901s ]
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` = 234 [ RunTime:0.010685s ]
SHOW FULL COLUMNS FROM `news` [ RunTime:0.009865s ]
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.010278s ]
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.010620s ]
SELECT * FROM `report` WHERE `addtime` >= 1695892471 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 149 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009443s ]
SHOW FULL COLUMNS FROM `zhen` [ RunTime:0.023215s ]
SELECT COUNT(*) AS think_count FROM `zhen` LEFT JOIN `xian` ON `xian`.`ID`=`zhen`.`XianID` WHERE `xian`.`ShiID` = '149' AND `zhen`.`status` = '1' LIMIT 1 [ RunTime:0.010027s ]
SELECT * FROM `report` WHERE `addtime` >= 1695892471 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 149 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009563s ]
SELECT * FROM `report` WHERE `addtime` >= 1695892471 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 230 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009545s ]
SELECT * FROM `report` WHERE `addtime` >= 1695892471 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 150 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009382s ]
SELECT COUNT(*) AS think_count FROM `zhen` LEFT JOIN `xian` ON `xian`.`ID`=`zhen`.`XianID` WHERE `xian`.`ShiID` = '150' AND `zhen`.`status` = '1' LIMIT 1 [ RunTime:0.009882s ]
SELECT * FROM `report` WHERE `addtime` >= 1695892471 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 150 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009398s ]
SELECT * FROM `report` WHERE `addtime` >= 1695892471 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 240 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009262s ]
SELECT * FROM `report` WHERE `addtime` >= 1695892471 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 151 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009311s ]
SELECT * FROM `report` WHERE `addtime` >= 1695892471 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 238 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009596s ]
SELECT * FROM `report` WHERE `addtime` >= 1695892471 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 233 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009365s ]
SELECT * FROM `report` WHERE `addtime` >= 1695892471 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 231 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009201s ]
SELECT * FROM `report` WHERE `addtime` >= 1695892471 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 237 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.030726s ]
SELECT COUNT(*) AS think_count FROM `zhen` LEFT JOIN `xian` ON `xian`.`ID`=`zhen`.`XianID` WHERE `xian`.`ShiID` = '237' AND `zhen`.`status` = '1' LIMIT 1 [ RunTime:0.009877s ]
SELECT * FROM `report` WHERE `addtime` >= 1695892471 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 237 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009401s ]
SELECT * FROM `report` WHERE `addtime` >= 1695892471 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 153 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009303s ]
SELECT * FROM `report` WHERE `addtime` >= 1695892471 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 152 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009462s ]
SELECT * FROM `report` WHERE `addtime` >= 1695892471 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 232 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009345s ]
SELECT * FROM `report` WHERE `addtime` >= 1695892471 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 236 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009207s ]
SELECT * FROM `report` WHERE `addtime` >= 1695892471 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 234 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009206s ]
