SHOW FULL COLUMNS FROM `sysinfo` [ RunTime:0.009906s ]
SELECT * FROM `sysinfo` WHERE `id` = '1' LIMIT 1 [ RunTime:0.008913s ]
SHOW FULL COLUMNS FROM `sheng` [ RunTime:0.009600s ]
SELECT * FROM `sheng` ORDER BY `lasttime` DESC [ RunTime:0.009016s ]
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` = 'jiangsusheng' ORDER BY `shi`.`num` DESC [ RunTime:0.009332s ]
SHOW FULL COLUMNS FROM `report` [ RunTime:0.009506s ]
SELECT * FROM `report` WHERE `addtime` >= 1695894557 AND `class` = 'sheng' AND `tj_type` = 'zhen' AND `sid` = 14 AND `day` = 0 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009695s ]
SHOW FULL COLUMNS FROM `shi` [ RunTime:0.010066s ]
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.010720s ]
SHOW FULL COLUMNS FROM `xian` [ RunTime:0.009849s ]
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` = '14' ORDER BY `num` DESC LIMIT 12 [ RunTime:0.015139s ]
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` = 121 [ RunTime:0.010563s ]
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` = 122 [ RunTime:0.010589s ]
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` = 129 [ RunTime:0.010517s ]
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` = 130 [ RunTime:0.010554s ]
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` = 221 [ RunTime:0.010589s ]
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` = 178 [ RunTime:0.011215s ]
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` = 246 [ RunTime:0.010709s ]
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` = 261 [ RunTime:0.010654s ]
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` = 263 [ RunTime:0.010659s ]
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` = 260 [ 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` = 259 [ RunTime:0.010649s ]
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` = 257 [ RunTime:0.011007s ]
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` = 262 [ RunTime:0.010745s ]
SHOW FULL COLUMNS FROM `news` [ RunTime:0.009839s ]
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.010481s ]
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.010299s ]
SELECT * FROM `report` WHERE `addtime` >= 1695894558 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 121 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009387s ]
SHOW FULL COLUMNS FROM `zhen` [ RunTime:0.009880s ]
SELECT COUNT(*) AS think_count FROM `zhen` LEFT JOIN `xian` ON `xian`.`ID`=`zhen`.`XianID` WHERE `xian`.`ShiID` = '121' AND `zhen`.`status` = '1' LIMIT 1 [ RunTime:0.010228s ]
SELECT * FROM `report` WHERE `addtime` >= 1695894558 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 121 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009575s ]
SELECT * FROM `report` WHERE `addtime` >= 1695894558 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 122 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009326s ]
SELECT COUNT(*) AS think_count FROM `zhen` LEFT JOIN `xian` ON `xian`.`ID`=`zhen`.`XianID` WHERE `xian`.`ShiID` = '122' AND `zhen`.`status` = '1' LIMIT 1 [ RunTime:0.010186s ]
SELECT * FROM `report` WHERE `addtime` >= 1695894558 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 122 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009574s ]
SELECT * FROM `report` WHERE `addtime` >= 1695894558 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 129 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009293s ]
SELECT COUNT(*) AS think_count FROM `zhen` LEFT JOIN `xian` ON `xian`.`ID`=`zhen`.`XianID` WHERE `xian`.`ShiID` = '129' AND `zhen`.`status` = '1' LIMIT 1 [ RunTime:0.009874s ]
SELECT * FROM `report` WHERE `addtime` >= 1695894558 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 129 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009415s ]
SELECT * FROM `report` WHERE `addtime` >= 1695894558 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 130 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009600s ]
SELECT COUNT(*) AS think_count FROM `zhen` LEFT JOIN `xian` ON `xian`.`ID`=`zhen`.`XianID` WHERE `xian`.`ShiID` = '130' AND `zhen`.`status` = '1' LIMIT 1 [ RunTime:0.010024s ]
SELECT * FROM `report` WHERE `addtime` >= 1695894558 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 130 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009451s ]
SELECT * FROM `report` WHERE `addtime` >= 1695894558 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 221 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009280s ]
SELECT COUNT(*) AS think_count FROM `zhen` LEFT JOIN `xian` ON `xian`.`ID`=`zhen`.`XianID` WHERE `xian`.`ShiID` = '221' AND `zhen`.`status` = '1' LIMIT 1 [ RunTime:0.009841s ]
SELECT * FROM `report` WHERE `addtime` >= 1695894558 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 221 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009423s ]
SELECT * FROM `report` WHERE `addtime` >= 1695894558 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 178 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009757s ]
SELECT COUNT(*) AS think_count FROM `zhen` LEFT JOIN `xian` ON `xian`.`ID`=`zhen`.`XianID` WHERE `xian`.`ShiID` = '178' AND `zhen`.`status` = '1' LIMIT 1 [ RunTime:0.009956s ]
SELECT * FROM `report` WHERE `addtime` >= 1695894558 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 178 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009515s ]
SELECT * FROM `report` WHERE `addtime` >= 1695894558 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 246 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009650s ]
SELECT COUNT(*) AS think_count FROM `zhen` LEFT JOIN `xian` ON `xian`.`ID`=`zhen`.`XianID` WHERE `xian`.`ShiID` = '246' AND `zhen`.`status` = '1' LIMIT 1 [ RunTime:0.010373s ]
SELECT * FROM `report` WHERE `addtime` >= 1695894558 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 246 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009755s ]
SELECT * FROM `report` WHERE `addtime` >= 1695894558 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 261 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009495s ]
SELECT COUNT(*) AS think_count FROM `zhen` LEFT JOIN `xian` ON `xian`.`ID`=`zhen`.`XianID` WHERE `xian`.`ShiID` = '261' AND `zhen`.`status` = '1' LIMIT 1 [ RunTime:0.010091s ]
SELECT * FROM `report` WHERE `addtime` >= 1695894558 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 261 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009371s ]
SELECT * FROM `report` WHERE `addtime` >= 1695894558 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 263 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` = '263' AND `zhen`.`status` = '1' LIMIT 1 [ RunTime:0.010103s ]
SELECT * FROM `report` WHERE `addtime` >= 1695894558 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 263 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009692s ]
SELECT * FROM `report` WHERE `addtime` >= 1695894558 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 260 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009421s ]
SELECT COUNT(*) AS think_count FROM `zhen` LEFT JOIN `xian` ON `xian`.`ID`=`zhen`.`XianID` WHERE `xian`.`ShiID` = '260' AND `zhen`.`status` = '1' LIMIT 1 [ RunTime:0.010163s ]
SELECT * FROM `report` WHERE `addtime` >= 1695894558 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 260 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009603s ]
SELECT * FROM `report` WHERE `addtime` >= 1695894558 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 259 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.014117s ]
SELECT COUNT(*) AS think_count FROM `zhen` LEFT JOIN `xian` ON `xian`.`ID`=`zhen`.`XianID` WHERE `xian`.`ShiID` = '259' AND `zhen`.`status` = '1' LIMIT 1 [ RunTime:0.010145s ]
SELECT * FROM `report` WHERE `addtime` >= 1695894558 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 259 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009441s ]
SELECT * FROM `report` WHERE `addtime` >= 1695894558 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 257 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009356s ]
SELECT COUNT(*) AS think_count FROM `zhen` LEFT JOIN `xian` ON `xian`.`ID`=`zhen`.`XianID` WHERE `xian`.`ShiID` = '257' AND `zhen`.`status` = '1' LIMIT 1 [ RunTime:0.014258s ]
SELECT * FROM `report` WHERE `addtime` >= 1695894558 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 257 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009489s ]
SELECT * FROM `report` WHERE `addtime` >= 1695894558 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 262 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009254s ]
SELECT COUNT(*) AS think_count FROM `zhen` LEFT JOIN `xian` ON `xian`.`ID`=`zhen`.`XianID` WHERE `xian`.`ShiID` = '262' AND `zhen`.`status` = '1' LIMIT 1 [ RunTime:0.009855s ]
SELECT * FROM `report` WHERE `addtime` >= 1695894558 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 262 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009312s ]
