Tad 教材網 - 如何除錯

如何除錯

2014-09-06 22:04:57

老師您好：本校網站近來怪怪的，打開除錯功能顯示有87個問題，請問老師要如何修正這些問題，謝謝!

問題
0.000064 - SET NAMES \'utf8\'
0.000037 - SET SQL_BIG_SELECTS = 1
0.000051 - SELECT * FROM config WHERE (conf_modid = \'0\' AND conf_catid = \'1\') ORDER BY conf_order ASC
0.000178 - SELECT sess_data, sess_ip FROM session WHERE sess_id = \'t1o43ad892m70sjo6gleb2k1r7\'
0.000185 - SELECT * FROM users WHERE uid = \'1\'
0.000036 - SELECT * FROM modules WHERE dirname = \'tadnews\'
0.000041 - SELECT * FROM config WHERE (conf_modid = \'21\') ORDER BY conf_order ASC
0.000037 - select ncsn,enable_post_group from tad_news_cate
0.000036 - SELECT * FROM modules WHERE dirname = \'tadtools\'
0.000034 - SELECT * FROM config WHERE (conf_modid = \'43\') ORDER BY conf_order ASC
0.000036 - select * from tad_news_cate where 1 and not_news!=\'1\' order by sort
0.001109 - select * from tad_news where 1 and enable=\'1\' and ncsn in(1,2,3,4,5,6,7,11,12,13) and start_day < \'2014-09-06 22:00:45\' and (end_day > \'2014-09-06 22:00:45\' or end_day=\'0000-00-00 00:00:00\') order by always_top desc , start_day desc
0.000422 - select * from tad_news where 1 and enable=\'1\' and ncsn in(1,2,3,4,5,6,7,11,12,13) and start_day < \'2014-09-06 22:00:45\' and (end_day > \'2014-09-06 22:00:45\' or end_day=\'0000-00-00 00:00:00\') order by always_top desc , start_day desc LIMIT 0, 10
0.000038 - select * from `tadnews_files_center` where `col_name`=\'nsn\' and `col_sn`=\'197\' order by sort
0.000034 - select * from tad_news where nsn=\'197\'
0.000118 - SELECT * FROM users WHERE uid = \'8\'
0.000031 - select groupid,name from groups
0.000032 - select * from tadnews_files_center where `col_name`=\'news_pic\' and `col_sn`=\'197\' order by sort
0.000030 - select * from tadnews_files_center where `col_name`=\'news_pic\' and `col_sn`=\'197\' order by sort
0.000026 - select font_color,color,tag from tad_news_tags where `tag_sn`=\'7\' and enable=\'1\'
0.000745 - select nsn,news_title,start_day,enable_group,ncsn from tad_news where enable=\'1\' and start_day < \'2014-09-06 22:00:45\' and (end_day > \'2014-09-06 22:00:45\' or end_day=\'0000-00-00 00:00:00\') order by start_day desc
0.000029 - select nc_title,of_ncsn,not_news from tad_news_cate where ncsn=\'13\'
0.000033 - SELECT * FROM smiles
0.000037 - select * from `tadnews_files_center` where `col_name`=\'nsn\' and `col_sn`=\'196\' order by sort
0.000034 - select * from tad_news where nsn=\'196\'
0.000030 - select groupid,name from groups
0.000032 - select * from tadnews_files_center where `col_name`=\'news_pic\' and `col_sn`=\'196\' order by sort
0.000030 - select * from tadnews_files_center where `col_name`=\'news_pic\' and `col_sn`=\'196\' order by sort
0.000025 - select font_color,color,tag from tad_news_tags where `tag_sn`=\'1\' and enable=\'1\'
0.000069 - select nsn,news_title,start_day,enable_group,ncsn from tad_news where enable=\'1\' and start_day < \'2014-09-06 22:00:45\' and (end_day > \'2014-09-06 22:00:45\' or end_day=\'0000-00-00 00:00:00\') order by start_day desc
0.000028 - select nc_title,of_ncsn,not_news from tad_news_cate where ncsn=\'13\'
0.000036 - select * from `tadnews_files_center` where `col_name`=\'nsn\' and `col_sn`=\'195\' order by sort
0.000039 - select * from tad_news where nsn=\'195\'
0.000030 - select groupid,name from groups
0.000032 - select * from tadnews_files_center where `col_name`=\'news_pic\' and `col_sn`=\'195\' order by sort
0.000031 - select * from tadnews_files_center where `col_name`=\'news_pic\' and `col_sn`=\'195\' order by sort
0.000025 - select font_color,color,tag from tad_news_tags where `tag_sn`=\'1\' and enable=\'1\'
0.000069 - select nsn,news_title,start_day,enable_group,ncsn from tad_news where enable=\'1\' and start_day < \'2014-09-06 22:00:45\' and (end_day > \'2014-09-06 22:00:45\' or end_day=\'0000-00-00 00:00:00\') order by start_day desc
0.000027 - select nc_title,of_ncsn,not_news from tad_news_cate where ncsn=\'5\'
0.000025 - select nc_title,of_ncsn,not_news from tad_news_cate where ncsn=\'1\'
0.000036 - select * from `tadnews_files_center` where `col_name`=\'nsn\' and `col_sn`=\'194\' order by sort
0.000039 - select * from tad_news where nsn=\'194\'
0.000029 - select groupid,name from groups
0.000032 - select * from tadnews_files_center where `col_name`=\'news_pic\' and `col_sn`=\'194\' order by sort
0.000030 - select * from tadnews_files_center where `col_name`=\'news_pic\' and `col_sn`=\'194\' order by sort
0.000025 - select font_color,color,tag from tad_news_tags where `tag_sn`=\'1\' and enable=\'1\'
0.000068 - select nsn,news_title,start_day,enable_group,ncsn from tad_news where enable=\'1\' and start_day < \'2014-09-06 22:00:45\' and (end_day > \'2014-09-06 22:00:45\' or end_day=\'0000-00-00 00:00:00\') order by start_day desc
0.000027 - select nc_title,of_ncsn,not_news from tad_news_cate where ncsn=\'5\'
0.000026 - select nc_title,of_ncsn,not_news from tad_news_cate where ncsn=\'1\'
0.000035 - select * from `tadnews_files_center` where `col_name`=\'nsn\' and `col_sn`=\'193\' order by sort
0.000034 - select * from tad_news where nsn=\'193\'
0.000115 - SELECT * FROM users WHERE uid = \'4\'
0.000030 - select groupid,name from groups
0.000031 - select * from tadnews_files_center where `col_name`=\'news_pic\' and `col_sn`=\'193\' order by sort
0.000030 - select * from tadnews_files_center where `col_name`=\'news_pic\' and `col_sn`=\'193\' order by sort
0.000025 - select font_color,color,tag from tad_news_tags where `tag_sn`=\'1\' and enable=\'1\'
0.000070 - select nsn,news_title,start_day,enable_group,ncsn from tad_news where enable=\'1\' and start_day < \'2014-09-06 22:00:45\' and (end_day > \'2014-09-06 22:00:45\' or end_day=\'0000-00-00 00:00:00\') order by start_day desc
0.000028 - select nc_title,of_ncsn,not_news from tad_news_cate where ncsn=\'3\'
0.000025 - select nc_title,of_ncsn,not_news from tad_news_cate where ncsn=\'1\'
0.000035 - select * from `tadnews_files_center` where `col_name`=\'nsn\' and `col_sn`=\'182\' order by sort
0.000033 - select * from tad_news where nsn=\'182\'
0.000029 - select groupid,name from groups
0.000031 - select * from tadnews_files_center where `col_name`=\'news_pic\' and `col_sn`=\'182\' order by sort
0.000031 - select * from tadnews_files_center where `col_name`=\'news_pic\' and `col_sn`=\'182\' order by sort
0.000025 - select font_color,color,tag from tad_news_tags where `tag_sn`=\'4\' and enable=\'1\'
0.000069 - select nsn,news_title,start_day,enable_group,ncsn from tad_news where enable=\'1\' and start_day < \'2014-09-06 22:00:45\' and (end_day > \'2014-09-06 22:00:45\' or end_day=\'0000-00-00 00:00:00\') order by start_day desc
0.000028 - select nc_title,of_ncsn,not_news from tad_news_cate where ncsn=\'5\'
0.000025 - select nc_title,of_ncsn,not_news from tad_news_cate where ncsn=\'1\'
0.000034 - select * from `tadnews_files_center` where `col_name`=\'nsn\' and `col_sn`=\'180\' order by sort
0.000033 - select * from tad_news where nsn=\'180\'
0.000029 - select groupid,name from groups
0.000031 - select * from tadnews_files_center where `col_name`=\'news_pic\' and `col_sn`=\'180\' order by sort
0.000030 - select * from tadnews_files_center where `col_name`=\'news_pic\' and `col_sn`=\'180\' order by sort
0.000025 - select font_color,color,tag from tad_news_tags where `tag_sn`=\'4\' and enable=\'1\'
0.000068 - select nsn,news_title,start_day,enable_group,ncsn from tad_news where enable=\'1\' and start_day < \'2014-09-06 22:00:45\' and (end_day > \'2014-09-06 22:00:45\' or end_day=\'0000-00-00 00:00:00\') order by start_day desc
0.000027 - select nc_title,of_ncsn,not_news from tad_news_cate where ncsn=\'5\'
0.000026 - select nc_title,of_ncsn,not_news from tad_news_cate where ncsn=\'1\'
0.000033 - select * from `tadnews_files_center` where `col_name`=\'nsn\' and `col_sn`=\'179\' order by sort
0.000033 - select * from tad_news where nsn=\'179\'
0.000029 - select groupid,name from groups
0.000032 - select * from tadnews_files_center where `col_name`=\'news_pic\' and `col_sn`=\'179\' order by sort
0.000029 - select * from tadnews_files_center where `col_name`=\'news_pic\' and `col_sn`=\'179\' order by sort
0.000025 - select font_color,color,tag from tad_news_tags where `tag_sn`=\'4\' and enable=\'1\'
0.000068 - select nsn,news_title,start_day,enable_group,ncsn from tad_news where enable=\'1\' and start_day < \'2014-09-06 22:00:45\' and (end_day > \'2014-09-06 22:00:45\' or end_day=\'0000-00-00 00:00:00\') order by start_day desc
0.000028 - select nc_title,of_ncsn,not_news from tad_news_cate where ncsn=\'3\'
0.000026 - select nc_title,of_ncsn,not_news from tad_news_cate where ncsn=\'1\'
0.000032 - select ncsn,nc_title,of_ncsn,not_news from tad_news_cate
總計: 87