SHOW FULL COLUMNS FROM `sysinfo` [ RunTime:0.009626s ]
SELECT * FROM `sysinfo` WHERE `id` = '1' LIMIT 1 [ RunTime:0.008793s ]
SHOW FULL COLUMNS FROM `sheng` [ RunTime:0.009997s ]
SELECT * FROM `sheng` ORDER BY `lasttime` DESC [ RunTime:0.009051s ]
SHOW FULL COLUMNS FROM `shi` [ RunTime:0.009764s ]
SELECT `shi`.*,sheng.sub_title as sheng_sub_title,`sheng`.`sheng` FROM `shi` LEFT JOIN `sheng` ON `sheng`.`ID`=`shi`.`ShengID` WHERE `shi`.`py` = 'zunyishi' LIMIT 1 [ RunTime:0.009108s ]
SHOW FULL COLUMNS FROM `report` [ RunTime:0.009782s ]
SELECT * FROM `report` WHERE `addtime` >= 1695895098 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `sid` = 123 AND `day` = 0 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009467s ]
SELECT * FROM `report` WHERE `addtime` >= 1695895098 AND `tj_type` = 'xian' AND `class` = 'shi' AND `sid` = 123 AND `day` = 0 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009085s ]
SELECT * FROM `report` WHERE `addtime` >= 1695895098 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `sid` = 123 AND `day` = 30 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009467s ]
SHOW FULL COLUMNS FROM `xian` [ RunTime:0.009685s ]
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 `ShiID` = 123 ORDER BY `lasttime` DESC [ RunTime:0.010546s ]
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 `shi`.`py` = 'zunyishi' ORDER BY `lasttime` DESC [ RunTime:0.016266s ]
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.010119s ]
SHOW FULL COLUMNS FROM `news` [ RunTime:0.010101s ]
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.010679s ]
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.010912s ]
SHOW FULL COLUMNS FROM `zhen` [ RunTime:0.009841s ]
SELECT `zhen`.`ID`,`zhen`.`zhen`,`zhen`.`num_type`,`zhen`.`num`,`zhen`.`nl`,`zhen`.`qita`,`xian`.`xian` FROM `zhen` LEFT JOIN `xian` ON `xian`.`ID`=`zhen`.`XianID` WHERE `zhen`.`status` = '1' AND `xian` = '桐梓县' [ RunTime:0.009725s ]
SELECT `zhen`.`ID`,`zhen`.`zhen`,`zhen`.`num_type`,`zhen`.`num`,`zhen`.`nl`,`zhen`.`qita`,`xian`.`xian` FROM `zhen` LEFT JOIN `xian` ON `xian`.`ID`=`zhen`.`XianID` WHERE `zhen`.`status` = '1' AND `xian` = '遵义县' [ RunTime:0.009825s ]
SELECT `zhen`.`ID`,`zhen`.`zhen`,`zhen`.`num_type`,`zhen`.`num`,`zhen`.`nl`,`zhen`.`qita`,`xian`.`xian` FROM `zhen` LEFT JOIN `xian` ON `xian`.`ID`=`zhen`.`XianID` WHERE `zhen`.`status` = '1' AND `xian` = '务川县' [ RunTime:0.009767s ]
SELECT `zhen`.`ID`,`zhen`.`zhen`,`zhen`.`num_type`,`zhen`.`num`,`zhen`.`nl`,`zhen`.`qita`,`xian`.`xian` FROM `zhen` LEFT JOIN `xian` ON `xian`.`ID`=`zhen`.`XianID` WHERE `zhen`.`status` = '1' AND `xian` = '绥阳县' [ RunTime:0.009615s ]
SELECT `zhen`.`ID`,`zhen`.`zhen`,`zhen`.`num_type`,`zhen`.`num`,`zhen`.`nl`,`zhen`.`qita`,`xian`.`xian` FROM `zhen` LEFT JOIN `xian` ON `xian`.`ID`=`zhen`.`XianID` WHERE `zhen`.`status` = '1' AND `xian` = '余庆县' [ RunTime:0.009504s ]
SELECT `zhen`.`ID`,`zhen`.`zhen`,`zhen`.`num_type`,`zhen`.`num`,`zhen`.`nl`,`zhen`.`qita`,`xian`.`xian` FROM `zhen` LEFT JOIN `xian` ON `xian`.`ID`=`zhen`.`XianID` WHERE `zhen`.`status` = '1' AND `xian` = '道真县' [ RunTime:0.009595s ]
SELECT `zhen`.`ID`,`zhen`.`zhen`,`zhen`.`num_type`,`zhen`.`num`,`zhen`.`nl`,`zhen`.`qita`,`xian`.`xian` FROM `zhen` LEFT JOIN `xian` ON `xian`.`ID`=`zhen`.`XianID` WHERE `zhen`.`status` = '1' AND `xian` = '凤冈县' [ RunTime:0.009648s ]
SELECT `zhen`.`ID`,`zhen`.`zhen`,`zhen`.`num_type`,`zhen`.`num`,`zhen`.`nl`,`zhen`.`qita`,`xian`.`xian` FROM `zhen` LEFT JOIN `xian` ON `xian`.`ID`=`zhen`.`XianID` WHERE `zhen`.`status` = '1' AND `xian` = '习水县' [ RunTime:0.009607s ]
SELECT `zhen`.`ID`,`zhen`.`zhen`,`zhen`.`num_type`,`zhen`.`num`,`zhen`.`nl`,`zhen`.`qita`,`xian`.`xian` FROM `zhen` LEFT JOIN `xian` ON `xian`.`ID`=`zhen`.`XianID` WHERE `zhen`.`status` = '1' AND `xian` = '赤水市' [ RunTime:0.009536s ]
SELECT `zhen`.`ID`,`zhen`.`zhen`,`zhen`.`num_type`,`zhen`.`num`,`zhen`.`nl`,`zhen`.`qita`,`xian`.`xian` FROM `zhen` LEFT JOIN `xian` ON `xian`.`ID`=`zhen`.`XianID` WHERE `zhen`.`status` = '1' AND `xian` = '播州区' [ RunTime:0.009442s ]
SELECT `zhen`.`ID`,`zhen`.`zhen`,`zhen`.`num_type`,`zhen`.`num`,`zhen`.`nl`,`zhen`.`qita`,`xian`.`xian` FROM `zhen` LEFT JOIN `xian` ON `xian`.`ID`=`zhen`.`XianID` WHERE `zhen`.`status` = '1' AND `xian` = '新蒲新区' [ RunTime:0.009651s ]
SELECT `zhen`.`ID`,`zhen`.`zhen`,`zhen`.`num_type`,`zhen`.`num`,`zhen`.`nl`,`zhen`.`qita`,`xian`.`xian` FROM `zhen` LEFT JOIN `xian` ON `xian`.`ID`=`zhen`.`XianID` WHERE `zhen`.`status` = '1' AND `xian` = '红花岗区' [ RunTime:0.009724s ]
SELECT `zhen`.`ID`,`zhen`.`zhen`,`zhen`.`num_type`,`zhen`.`num`,`zhen`.`nl`,`zhen`.`qita`,`xian`.`xian` FROM `zhen` LEFT JOIN `xian` ON `xian`.`ID`=`zhen`.`XianID` WHERE `zhen`.`status` = '1' AND `xian` = '汇川区' [ RunTime:0.009903s ]
SELECT `zhen`.`ID`,`zhen`.`zhen`,`zhen`.`num_type`,`zhen`.`num`,`zhen`.`nl`,`zhen`.`qita`,`xian`.`xian` FROM `zhen` LEFT JOIN `xian` ON `xian`.`ID`=`zhen`.`XianID` WHERE `zhen`.`status` = '1' AND `xian` = '仁怀市' [ RunTime:0.009551s ]
SELECT `zhen`.`ID`,`zhen`.`zhen`,`zhen`.`num_type`,`zhen`.`num`,`zhen`.`nl`,`zhen`.`qita`,`xian`.`xian` FROM `zhen` LEFT JOIN `xian` ON `xian`.`ID`=`zhen`.`XianID` WHERE `zhen`.`status` = '1' AND `xian` = '正安县' [ RunTime:0.009789s ]
SELECT `zhen`.`ID`,`zhen`.`zhen`,`zhen`.`num_type`,`zhen`.`num`,`zhen`.`nl`,`zhen`.`qita`,`xian`.`xian` FROM `zhen` LEFT JOIN `xian` ON `xian`.`ID`=`zhen`.`XianID` WHERE `zhen`.`status` = '1' AND `xian` = '湄潭县' [ RunTime:0.009597s ]
SELECT * FROM `report` WHERE `addtime` >= 1695895098 AND `class` = 'xian' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 624 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.008981s ]
SELECT * FROM `report` WHERE `addtime` >= 1695895098 AND `class` = 'xian' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 630 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.008909s ]
SELECT * FROM `report` WHERE `addtime` >= 1695895098 AND `class` = 'xian' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 625 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.008869s ]
SELECT * FROM `report` WHERE `addtime` >= 1695895098 AND `class` = 'xian' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 623 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009224s ]
SELECT * FROM `report` WHERE `addtime` >= 1695895098 AND `class` = 'xian' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 627 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009206s ]
SELECT * FROM `report` WHERE `addtime` >= 1695895098 AND `class` = 'xian' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 619 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009075s ]
SELECT * FROM `report` WHERE `addtime` >= 1695895098 AND `class` = 'xian' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 620 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009034s ]
SELECT * FROM `report` WHERE `addtime` >= 1695895098 AND `class` = 'xian' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 626 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.008972s ]
SELECT * FROM `report` WHERE `addtime` >= 1695895098 AND `class` = 'xian' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 618 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.008902s ]
SELECT * FROM `report` WHERE `addtime` >= 1695895098 AND `class` = 'xian' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 1242 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009055s ]
SELECT * FROM `report` WHERE `addtime` >= 1695895098 AND `class` = 'xian' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 1239 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.008893s ]
SELECT * FROM `report` WHERE `addtime` >= 1695895098 AND `class` = 'xian' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 1241 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.008933s ]
SELECT * FROM `report` WHERE `addtime` >= 1695895098 AND `class` = 'xian' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 1240 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.008872s ]
SELECT * FROM `report` WHERE `addtime` >= 1695895098 AND `class` = 'xian' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 621 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.008866s ]
SELECT * FROM `report` WHERE `addtime` >= 1695895098 AND `class` = 'xian' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 628 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009154s ]
SELECT * FROM `report` WHERE `addtime` >= 1695895098 AND `class` = 'xian' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 622 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.008966s ]