SHOW FULL COLUMNS FROM `sysinfo` [ RunTime:0.010065s ]
SELECT * FROM `sysinfo` WHERE `id` = '1' LIMIT 1 [ RunTime:0.008736s ]
SHOW FULL COLUMNS FROM `sheng` [ RunTime:0.009539s ]
SELECT * FROM `sheng` ORDER BY `lasttime` DESC [ RunTime:0.008770s ]
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` = 'shandongsheng' ORDER BY `shi`.`num` DESC [ RunTime:0.009228s ]
SHOW FULL COLUMNS FROM `report` [ RunTime:0.009413s ]
SELECT * FROM `report` WHERE `addtime` >= 1695888293 AND `class` = 'sheng' AND `tj_type` = 'zhen' AND `sid` = 11 AND `day` = 0 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009420s ]
SHOW FULL COLUMNS FROM `shi` [ RunTime:0.023928s ]
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.009865s ]
SHOW FULL COLUMNS FROM `xian` [ RunTime:0.009530s ]
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` = '11' ORDER BY `num` DESC LIMIT 12 [ RunTime:0.012158s ]
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` = 116 [ 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` = 105 [ RunTime:0.011278s ]
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` = 188 [ RunTime:0.010465s ]
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` = 169 [ RunTime:0.028310s ]
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` = 187 [ RunTime:0.010471s ]
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` = 196 [ RunTime:0.010412s ]
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` = 195 [ RunTime:0.010385s ]
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` = 120 [ RunTime:0.010259s ]
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` = 182 [ RunTime:0.011006s ]
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` = 193 [ RunTime:0.011006s ]
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` = 192 [ RunTime:0.011069s ]
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` = 170 [ RunTime:0.023584s ]
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` = 166 [ RunTime:0.010430s ]
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` = 189 [ RunTime:0.010303s ]
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` = 185 [ RunTime:0.010159s ]
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` = 186 [ RunTime:0.010860s ]
SHOW FULL COLUMNS FROM `news` [ RunTime:0.009835s ]
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.010280s ]
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.010355s ]
SELECT * FROM `report` WHERE `addtime` >= 1695888293 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 116 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009240s ]
SELECT * FROM `report` WHERE `addtime` >= 1695888293 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 105 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009323s ]
SELECT * FROM `report` WHERE `addtime` >= 1695888293 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 188 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009077s ]
SELECT * FROM `report` WHERE `addtime` >= 1695888293 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 169 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009429s ]
SELECT * FROM `report` WHERE `addtime` >= 1695888293 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 187 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009307s ]
SELECT * FROM `report` WHERE `addtime` >= 1695888293 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 196 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009197s ]
SELECT * FROM `report` WHERE `addtime` >= 1695888293 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 195 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009170s ]
SELECT * FROM `report` WHERE `addtime` >= 1695888293 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 120 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009328s ]
SELECT * FROM `report` WHERE `addtime` >= 1695888293 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 182 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009186s ]
SELECT * FROM `report` WHERE `addtime` >= 1695888293 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 193 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.008992s ]
SHOW FULL COLUMNS FROM `zhen` [ RunTime:0.018384s ]
SELECT COUNT(*) AS think_count FROM `zhen` LEFT JOIN `xian` ON `xian`.`ID`=`zhen`.`XianID` WHERE `xian`.`ShiID` = '193' AND `zhen`.`status` = '1' LIMIT 1 [ RunTime:0.010217s ]
SELECT * FROM `report` WHERE `addtime` >= 1695888293 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 193 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009290s ]
SELECT * FROM `report` WHERE `addtime` >= 1695888293 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 192 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009022s ]
SELECT * FROM `report` WHERE `addtime` >= 1695888293 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 170 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009109s ]
SELECT * FROM `report` WHERE `addtime` >= 1695888293 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 166 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009034s ]
SELECT * FROM `report` WHERE `addtime` >= 1695888293 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 189 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009034s ]
SELECT * FROM `report` WHERE `addtime` >= 1695888293 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 185 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009147s ]
SELECT * FROM `report` WHERE `addtime` >= 1695888293 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 186 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009320s ]
