SHOW FULL COLUMNS FROM `sysinfo` [ RunTime:0.011355s ]
SELECT * FROM `sysinfo` WHERE `id` = '1' LIMIT 1 [ RunTime:0.009416s ]
SHOW FULL COLUMNS FROM `sheng` [ RunTime:0.010499s ]
SELECT * FROM `sheng` ORDER BY `lasttime` DESC [ RunTime:0.009527s ]
SHOW FULL COLUMNS FROM `shi` [ RunTime:0.010647s ]
SELECT `shi`.*,sheng.sub_title as sheng_sub_title,`sheng`.`sheng` FROM `shi` LEFT JOIN `sheng` ON `sheng`.`ID`=`shi`.`ShengID` WHERE `shi`.`py` = 'ganzhoushi' LIMIT 1 [ RunTime:0.009562s ]
SHOW FULL COLUMNS FROM `report` [ RunTime:0.010273s ]
SELECT * FROM `report` WHERE `addtime` >= 1695889776 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `sid` = 82 AND `day` = 0 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009889s ]
SELECT * FROM `report` WHERE `addtime` >= 1695889776 AND `tj_type` = 'xian' AND `class` = 'shi' AND `sid` = 82 AND `day` = 0 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.022664s ]
SELECT * FROM `report` WHERE `addtime` >= 1695889776 AND `class` = 'shi' AND `tj_type` = 'zhen' AND `sid` = 82 AND `day` = 30 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.010285s ]
SHOW FULL COLUMNS FROM `xian` [ RunTime:0.010359s ]
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` = 82 ORDER BY `lasttime` DESC [ RunTime:0.011729s ]
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` = 'ganzhoushi' ORDER BY `lasttime` DESC [ RunTime:0.018211s ]
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.010777s ]
SHOW FULL COLUMNS FROM `news` [ RunTime:0.010324s ]
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.010381s ]
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.017895s ]
SHOW FULL COLUMNS FROM `zhen` [ RunTime:0.010095s ]
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.010363s ]
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.010260s ]
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.010245s ]
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.010410s ]
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.010186s ]
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.021703s ]
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.010274s ]
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.012275s ]
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.010401s ]
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.010358s ]
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.010244s ]
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.010395s ]
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.010174s ]
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.010339s ]
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.010257s ]
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.010067s ]
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.010230s ]
SELECT * FROM `report` WHERE `addtime` >= 1695889776 AND `class` = 'xian' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 455 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009486s ]
SELECT * FROM `report` WHERE `addtime` >= 1695889776 AND `class` = 'xian' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 442 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009525s ]
SELECT * FROM `report` WHERE `addtime` >= 1695889776 AND `class` = 'xian' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 457 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009602s ]
SELECT * FROM `report` WHERE `addtime` >= 1695889776 AND `class` = 'xian' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 444 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009969s ]
SELECT * FROM `report` WHERE `addtime` >= 1695889776 AND `class` = 'xian' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 459 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009594s ]
SELECT * FROM `report` WHERE `addtime` >= 1695889776 AND `class` = 'xian' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 454 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009591s ]
SELECT * FROM `report` WHERE `addtime` >= 1695889776 AND `class` = 'xian' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 468 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009380s ]
SELECT * FROM `report` WHERE `addtime` >= 1695889776 AND `class` = 'xian' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 450 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009380s ]
SELECT * FROM `report` WHERE `addtime` >= 1695889776 AND `class` = 'xian' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 453 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009508s ]
SELECT * FROM `report` WHERE `addtime` >= 1695889776 AND `class` = 'xian' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 449 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009334s ]
SELECT * FROM `report` WHERE `addtime` >= 1695889776 AND `class` = 'xian' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 441 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009340s ]
SELECT * FROM `report` WHERE `addtime` >= 1695889776 AND `class` = 'xian' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 445 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009451s ]
SELECT * FROM `report` WHERE `addtime` >= 1695889776 AND `class` = 'xian' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 446 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009380s ]
SELECT * FROM `report` WHERE `addtime` >= 1695889776 AND `class` = 'xian' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 447 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009381s ]
SELECT * FROM `report` WHERE `addtime` >= 1695889776 AND `class` = 'xian' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 451 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009871s ]
SELECT * FROM `report` WHERE `addtime` >= 1695889776 AND `class` = 'xian' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 452 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009694s ]
SELECT * FROM `report` WHERE `addtime` >= 1695889776 AND `class` = 'xian' AND `tj_type` = 'zhen' AND `day` = 0 AND `sid` = 458 ORDER BY `addtime` DESC LIMIT 1 [ RunTime:0.009658s ]