SHOW FULL COLUMNS FROM `sysinfo` [ RunTime:0.009682s ]
SELECT * FROM `sysinfo` WHERE `id` = '1' LIMIT 1 [ RunTime:0.008753s ]
SHOW FULL COLUMNS FROM `sheng` [ RunTime:0.031638s ]
SELECT * FROM `sheng` ORDER BY `lasttime` DESC [ RunTime:0.009108s ]
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` = 'guangdongsheng' ORDER BY `shi`.`num` DESC [ RunTime:0.009182s ]
SHOW FULL COLUMNS FROM `report` [ RunTime:0.009575s ]
SELECT * FROM `report` WHERE `addtime` >= 1695890197 AND `class` = 'sheng' AND `tj_type` = 'zhen' AND `sid` = 2 AND `day` = 0 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009694s ]
SHOW FULL COLUMNS FROM `shi` [ RunTime:0.009610s ]
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.009901s ]
SHOW FULL COLUMNS FROM `xian` [ RunTime:0.009643s ]
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` = '2' ORDER BY `num` DESC LIMIT 12 [ RunTime:0.028064s ]
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` = 39 [ RunTime:0.010553s ]
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` = 21 [ RunTime:0.010356s ]
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` = 35 [ RunTime:0.010586s ]
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` = 40 [ RunTime:0.010556s ]
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` = 38 [ RunTime:0.010416s ]
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` = 36 [ RunTime:0.010425s ]
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` = 28 [ RunTime:0.010381s ]
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` = 126 [ RunTime:0.029313s ]
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` = 37 [ RunTime:0.010355s ]
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` = 41 [ RunTime:0.010438s ]
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` = 31 [ RunTime:0.010408s ]
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` = 30 [ RunTime:0.066588s ]
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` = 29 [ RunTime:0.010957s ]
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` = 34 [ RunTime:0.010911s ]
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` = 43 [ RunTime:0.010854s ]
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` = 33 [ RunTime:0.010887s ]
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` = 127 [ RunTime:0.010482s ]
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` = 32 [ RunTime:0.039527s ]
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` = 42 [ RunTime:0.010584s ]
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` = 27 [ RunTime:0.010436s ]
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` = 26 [ RunTime:0.010472s ]
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` = 25 [ RunTime:0.010418s ]
SHOW FULL COLUMNS FROM `news` [ RunTime:0.009547s ]
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.009891s ]
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.040458s ]
SELECT * FROM `report` WHERE `addtime` >= 1695890197 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 39 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009364s ]
SELECT * FROM `report` WHERE `addtime` >= 1695890197 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 21 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009379s ]
SELECT * FROM `report` WHERE `addtime` >= 1695890197 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 35 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009340s ]
SELECT * FROM `report` WHERE `addtime` >= 1695890197 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 40 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009460s ]
SELECT * FROM `report` WHERE `addtime` >= 1695890197 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 38 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009626s ]
SHOW FULL COLUMNS FROM `zhen` [ RunTime:0.009876s ]
SELECT COUNT(*) AS think_count FROM `zhen` LEFT JOIN `xian` ON `xian`.`ID`=`zhen`.`XianID` WHERE `xian`.`ShiID` = '38' AND `zhen`.`status` = '1' LIMIT 1 [ RunTime:0.029593s ]
SELECT * FROM `report` WHERE `addtime` >= 1695890197 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 38 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009125s ]
SELECT * FROM `report` WHERE `addtime` >= 1695890197 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 36 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009156s ]
SELECT * FROM `report` WHERE `addtime` >= 1695890197 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 28 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009537s ]
SELECT * FROM `report` WHERE `addtime` >= 1695890197 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 126 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009131s ]
SELECT * FROM `report` WHERE `addtime` >= 1695890197 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 37 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009033s ]
SELECT * FROM `report` WHERE `addtime` >= 1695890197 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 41 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009136s ]
SELECT * FROM `report` WHERE `addtime` >= 1695890197 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 31 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009391s ]
SELECT * FROM `report` WHERE `addtime` >= 1695890197 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 30 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009587s ]
SELECT * FROM `report` WHERE `addtime` >= 1695890197 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 29 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009477s ]
SELECT * FROM `report` WHERE `addtime` >= 1695890197 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 34 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009543s ]
SELECT * FROM `report` WHERE `addtime` >= 1695890197 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 43 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009256s ]
SELECT * FROM `report` WHERE `addtime` >= 1695890197 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 33 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009581s ]
SELECT * FROM `report` WHERE `addtime` >= 1695890197 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 127 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009169s ]
SELECT * FROM `report` WHERE `addtime` >= 1695890197 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 32 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009603s ]
SELECT * FROM `report` WHERE `addtime` >= 1695890197 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 42 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009305s ]
SELECT * FROM `report` WHERE `addtime` >= 1695890198 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 27 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009099s ]
SELECT * FROM `report` WHERE `addtime` >= 1695890198 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 26 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.018951s ]
SELECT * FROM `report` WHERE `addtime` >= 1695890198 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 25 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009103s ]
