SHOW FULL COLUMNS FROM `sysinfo` [ RunTime:0.010875s ]
SELECT * FROM `sysinfo` WHERE `id` = '1' LIMIT 1 [ RunTime:0.009784s ]
SHOW FULL COLUMNS FROM `sheng` [ RunTime:0.010277s ]
SELECT * FROM `sheng` ORDER BY `lasttime` DESC [ RunTime:0.009395s ]
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` = 'sichuan' ORDER BY `shi`.`num` DESC [ RunTime:0.009379s ]
SHOW FULL COLUMNS FROM `report` [ RunTime:0.009627s ]
SELECT * FROM `report` WHERE `addtime` >= 1695887638 AND `class` = 'sheng' AND `tj_type` = 'zhen' AND `sid` = 4 AND `day` = 0 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009826s ]
SHOW FULL COLUMNS FROM `shi` [ RunTime:0.009879s ]
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.026573s ]
SHOW FULL COLUMNS FROM `xian` [ RunTime:0.009962s ]
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` = '4' ORDER BY `num` DESC LIMIT 12 [ RunTime:0.011935s ]
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` = 57 [ RunTime:0.010801s ]
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` = 66 [ RunTime:0.010729s ]
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` = 65 [ RunTime:0.010624s ]
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` = 56 [ RunTime:0.010513s ]
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` = 61 [ RunTime:0.010508s ]
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` = 59 [ RunTime:0.010557s ]
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` = 60 [ RunTime:0.010872s ]
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` = 132 [ RunTime:0.010558s ]
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` = 62 [ RunTime:0.010485s ]
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` = 58 [ RunTime:0.010489s ]
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` = 63 [ RunTime:0.010479s ]
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` = 67 [ RunTime:0.010505s ]
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` = 64 [ 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` = 155 [ RunTime:0.010479s ]
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` = 156 [ 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` = 154 [ RunTime:0.010744s ]
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` = 157 [ RunTime:0.010532s ]
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` = 215 [ RunTime:0.010543s ]
SHOW FULL COLUMNS FROM `news` [ RunTime:0.009762s ]
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.010001s ]
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.010403s ]
SELECT * FROM `report` WHERE `addtime` >= 1695887638 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 57 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009608s ]
SELECT * FROM `report` WHERE `addtime` >= 1695887638 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 66 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009323s ]
SELECT * FROM `report` WHERE `addtime` >= 1695887638 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 65 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009233s ]
SELECT * FROM `report` WHERE `addtime` >= 1695887638 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 56 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009645s ]
SELECT * FROM `report` WHERE `addtime` >= 1695887638 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 61 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009467s ]
SELECT * FROM `report` WHERE `addtime` >= 1695887638 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 59 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009601s ]
SELECT * FROM `report` WHERE `addtime` >= 1695887638 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 60 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009407s ]
SELECT * FROM `report` WHERE `addtime` >= 1695887638 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 132 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009302s ]
SHOW FULL COLUMNS FROM `zhen` [ RunTime:0.009740s ]
SELECT COUNT(*) AS think_count FROM `zhen` LEFT JOIN `xian` ON `xian`.`ID`=`zhen`.`XianID` WHERE `xian`.`ShiID` = '132' AND `zhen`.`status` = '1' LIMIT 1 [ RunTime:0.009855s ]
SELECT * FROM `report` WHERE `addtime` >= 1695887638 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 132 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009299s ]
SELECT * FROM `report` WHERE `addtime` >= 1695887638 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 62 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009634s ]
SELECT * FROM `report` WHERE `addtime` >= 1695887638 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 58 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009304s ]
SELECT * FROM `report` WHERE `addtime` >= 1695887638 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 63 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009255s ]
SELECT * FROM `report` WHERE `addtime` >= 1695887638 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 67 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009538s ]
SELECT COUNT(*) AS think_count FROM `zhen` LEFT JOIN `xian` ON `xian`.`ID`=`zhen`.`XianID` WHERE `xian`.`ShiID` = '67' AND `zhen`.`status` = '1' LIMIT 1 [ RunTime:0.009962s ]
SELECT * FROM `report` WHERE `addtime` >= 1695887638 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 67 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009425s ]
SELECT * FROM `report` WHERE `addtime` >= 1695887638 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 64 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009301s ]
SELECT COUNT(*) AS think_count FROM `zhen` LEFT JOIN `xian` ON `xian`.`ID`=`zhen`.`XianID` WHERE `xian`.`ShiID` = '64' AND `zhen`.`status` = '1' LIMIT 1 [ RunTime:0.010088s ]
SELECT * FROM `report` WHERE `addtime` >= 1695887638 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 64 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009370s ]
SELECT * FROM `report` WHERE `addtime` >= 1695887638 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 155 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009292s ]
SELECT * FROM `report` WHERE `addtime` >= 1695887638 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 156 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009245s ]
SELECT * FROM `report` WHERE `addtime` >= 1695887638 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 154 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009194s ]
SELECT * FROM `report` WHERE `addtime` >= 1695887638 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 157 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009240s ]
SELECT * FROM `report` WHERE `addtime` >= 1695887639 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 215 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009257s ]
