SHOW FULL COLUMNS FROM `sysinfo` [ RunTime:0.010043s ]
SELECT * FROM `sysinfo` WHERE `id` = '1' LIMIT 1 [ RunTime:0.009022s ]
SHOW FULL COLUMNS FROM `sheng` [ RunTime:0.009775s ]
SELECT * FROM `sheng` ORDER BY `lasttime` DESC [ RunTime:0.008921s ]
SHOW FULL COLUMNS FROM `shi` [ RunTime:0.009614s ]
SELECT `shi`.*,sheng.sub_title as sheng_sub_title,`sheng`.`sheng` FROM `shi` LEFT JOIN `sheng` ON `sheng`.`ID`=`shi`.`ShengID` WHERE `shi`.`py` = 'kunmingshi' LIMIT 1 [ RunTime:0.008787s ]
SHOW FULL COLUMNS FROM `report` [ RunTime:0.009312s ]
SELECT * FROM `report` WHERE `addtime` >= 1695889729 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `sid` = 22 AND `day` = 0 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009179s ]
SHOW FULL COLUMNS FROM `zhen` [ RunTime:0.009613s ]
SELECT COUNT(*) AS think_count FROM `zhen` LEFT JOIN `xian` ON `xian`.`ID`=`zhen`.`XianID` WHERE `xian`.`ShiID` = '22' AND `zhen`.`status` = '1' LIMIT 1 [ RunTime:0.009890s ]
SELECT * FROM `report` WHERE `addtime` >= 1695889729 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `sid` = 22 AND `day` = 0 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009127s ]
SELECT * FROM `report` WHERE `addtime` >= 1695889730 AND `tj_type` = 'xian' AND `class` = 'shi' AND `sid` = 22 AND `day` = 0 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.008935s ]
SHOW FULL COLUMNS FROM `xian` [ RunTime:0.009634s ]
SELECT COUNT(*) AS think_count FROM `xian` WHERE `ShiID` = 22 LIMIT 1 [ RunTime:0.009326s ]
SELECT COUNT(*) AS think_count FROM `xian` WHERE `ShiID` = 22 LIMIT 1 [ RunTime:0.009329s ]
SELECT * FROM `report` WHERE `addtime` >= 1695889730 AND `tj_type` = 'xian' AND `class` = 'shi' AND `sid` = 22 AND `day` = 0 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009249s ]
SELECT * FROM `report` WHERE `addtime` >= 1695889730 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `sid` = 22 AND `day` = 30 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009830s ]
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` = 22 ORDER BY `lasttime` DESC [ RunTime:0.010610s ]
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` = 'kunmingshi' ORDER BY `lasttime` DESC [ RunTime:0.017682s ]
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.010555s ]
SHOW FULL COLUMNS FROM `news` [ RunTime:0.010167s ]
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.010300s ]
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.010604s ]
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.009593s ]
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.009698s ]
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.009567s ]
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.009541s ]
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.009589s ]
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.009612s ]
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.009616s ]
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.009546s ]
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.009530s ]
SELECT * FROM `report` WHERE `addtime` >= 1695889730 AND `class` = 'xian' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 111 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009852s ]
SELECT * FROM `report` WHERE `addtime` >= 1695889730 AND `class` = 'xian' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 107 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.012275s ]
SELECT * FROM `report` WHERE `addtime` >= 1695889730 AND `class` = 'xian' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 1247 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009128s ]
SELECT * FROM `report` WHERE `addtime` >= 1695889730 AND `class` = 'xian' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 113 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009218s ]
SELECT * FROM `report` WHERE `addtime` >= 1695889730 AND `class` = 'xian' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 105 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009176s ]
SELECT * FROM `report` WHERE `addtime` >= 1695889730 AND `class` = 'xian' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 108 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009138s ]
SELECT * FROM `report` WHERE `addtime` >= 1695889730 AND `class` = 'xian' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 114 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009067s ]
SELECT * FROM `report` WHERE `addtime` >= 1695889730 AND `class` = 'xian' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 112 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009161s ]
SELECT * FROM `report` WHERE `addtime` >= 1695889730 AND `class` = 'xian' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 106 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009198s ]
SELECT * FROM `report` WHERE `addtime` >= 1695889730 AND `class` = 'xian' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 104 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009339s ]