:::
XOOPS使用討論區
如何除錯
老師您好：本校網站近來怪怪的，打開除錯功能顯示有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 |
不是，已經說過了
這些都不是問題，是資料庫的執行流程資訊...
沒有這些流程，網站試跑不出內容的
無法拖曳100%是jquery的問題
這些都不是問題，是資料庫的執行流程資訊...
沒有這些流程，網站試跑不出內容的
無法拖曳100%是jquery的問題
