| 資料庫語法 |
|---|
| 0.000242 - SET SQL_BIG_SELECTS = 1 |
| 0.002079 - SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC |
| 0.000223 - SELECT sess_data, sess_ip FROM session WHERE sess_id = 'q3rl4lapbememp62rit09nfni5' |
| 0.000252 - SELECT * FROM modules WHERE dirname = 'tadnews' |
| 0.000378 - SELECT COUNT(*) FROM group_permission WHERE (gperm_modid = '1' AND (gperm_groupid = '3') AND gperm_name = 'module_read' AND gperm_itemid = '9') |
| 0.000508 - SELECT * FROM config WHERE (conf_modid = '9') ORDER BY conf_order ASC |
| 0.000206 - select * from tad_news_cate where ncsn='29' |
| 0.003294 - select count(*) from tad_news where ncsn='29' |
| 0.000150 - SELECT groupid,name FROM groups |
| 0.000107 - SELECT groupid,name FROM groups |
| 0.000148 - select not_news from tad_news_cate where ncsn='29' |
| 0.000175 - SELECT * FROM modules WHERE dirname = 'tadtools' |
| 0.000237 - SELECT * FROM config WHERE (conf_modid = '3') ORDER BY conf_order ASC |
| 0.000189 - select * from tad_news_cate where 1 and not_news!='1' and `ncsn` = '29' order by sort |
| 0.023495 - select * from tad_news where 1 and enable='1' and `ncsn` = '29' and start_day < '2024-04-27 13:42:32' and (end_day > '2024-04-27 13:42:32' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc |
| 0.002774 - select * from tad_news where 1 and enable='1' and `ncsn` = '29' and start_day < '2024-04-27 13:42:32' and (end_day > '2024-04-27 13:42:32' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc LIMIT 0, 20 |
| 0.000782 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1333' order by sort |
| 0.000156 - select * from tad_news where nsn='1333' |
| 0.000177 - SELECT * FROM users WHERE uid = '1' |
| 0.000143 - SELECT groupid,name FROM groups |
| 0.000568 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1333' order by sort |
| 0.000574 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1333' order by sort |
| 0.010780 - select a.nsn,a.news_title,a.start_day,a.enable_group,a.ncsn from tad_news as a left join tad_news_cate as b on a.ncsn=b.ncsn where a.start_day < '2024-04-27 13:42:32' and (a.end_day > '2024-04-27 13:42:32' or a.end_day='0000-00-00 00:00:00') and a.enable='1' and b.not_news='0' order by a.start_day desc |
| 0.000488 - SELECT * FROM smiles |
| 0.000631 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1332' order by sort |
| 0.000176 - select * from tad_news where nsn='1332' |
| 0.000114 - SELECT groupid,name FROM groups |
| 0.000527 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1332' order by sort |
| 0.000505 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1332' order by sort |
| 0.010447 - select a.nsn,a.news_title,a.start_day,a.enable_group,a.ncsn from tad_news as a left join tad_news_cate as b on a.ncsn=b.ncsn where a.start_day < '2024-04-27 13:42:32' and (a.end_day > '2024-04-27 13:42:32' or a.end_day='0000-00-00 00:00:00') and a.enable='1' and b.not_news='0' order by a.start_day desc |
| 0.001386 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1331' order by sort |
| 0.000168 - select * from tad_news where nsn='1331' |
| 0.000151 - SELECT * FROM users WHERE uid = '5' |
| 0.000113 - SELECT groupid,name FROM groups |
| 0.000590 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1331' order by sort |
| 0.000561 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1331' order by sort |
| 0.000137 - select font_color,color,tag from tad_news_tags where `tag_sn`='4' and enable='1' |
| 0.010389 - select a.nsn,a.news_title,a.start_day,a.enable_group,a.ncsn from tad_news as a left join tad_news_cate as b on a.ncsn=b.ncsn where a.start_day < '2024-04-27 13:42:32' and (a.end_day > '2024-04-27 13:42:32' or a.end_day='0000-00-00 00:00:00') and a.enable='1' and b.not_news='0' order by a.start_day desc |
| 0.001361 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1328' order by sort |
| 0.000289 - select * from tad_news where nsn='1328' |
| 0.000197 - SELECT groupid,name FROM groups |
| 0.001025 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1328' order by sort |
| 0.001027 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1328' order by sort |
| 0.013118 - select a.nsn,a.news_title,a.start_day,a.enable_group,a.ncsn from tad_news as a left join tad_news_cate as b on a.ncsn=b.ncsn where a.start_day < '2024-04-27 13:42:32' and (a.end_day > '2024-04-27 13:42:32' or a.end_day='0000-00-00 00:00:00') and a.enable='1' and b.not_news='0' order by a.start_day desc |
| 0.000832 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1327' order by sort |
| 0.000186 - select * from tad_news where nsn='1327' |
| 0.000154 - SELECT groupid,name FROM groups |
| 0.000798 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1327' order by sort |
| 0.000819 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1327' order by sort |
| 0.013320 - select a.nsn,a.news_title,a.start_day,a.enable_group,a.ncsn from tad_news as a left join tad_news_cate as b on a.ncsn=b.ncsn where a.start_day < '2024-04-27 13:42:32' and (a.end_day > '2024-04-27 13:42:32' or a.end_day='0000-00-00 00:00:00') and a.enable='1' and b.not_news='0' order by a.start_day desc |
| 0.000864 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1326' order by sort |
| 0.000227 - select * from tad_news where nsn='1326' |
| 0.000134 - SELECT groupid,name FROM groups |
| 0.000687 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1326' order by sort |
| 0.000699 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1326' order by sort |
| 0.000152 - select font_color,color,tag from tad_news_tags where `tag_sn`='1' and enable='1' |
| 0.010303 - select a.nsn,a.news_title,a.start_day,a.enable_group,a.ncsn from tad_news as a left join tad_news_cate as b on a.ncsn=b.ncsn where a.start_day < '2024-04-27 13:42:32' and (a.end_day > '2024-04-27 13:42:32' or a.end_day='0000-00-00 00:00:00') and a.enable='1' and b.not_news='0' order by a.start_day desc |
| 0.000885 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1325' order by sort |
| 0.000178 - select * from tad_news where nsn='1325' |
| 0.000150 - SELECT groupid,name FROM groups |
| 0.000745 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1325' order by sort |
| 0.000715 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1325' order by sort |
| 0.000160 - select font_color,color,tag from tad_news_tags where `tag_sn`='1' and enable='1' |
| 0.011690 - select a.nsn,a.news_title,a.start_day,a.enable_group,a.ncsn from tad_news as a left join tad_news_cate as b on a.ncsn=b.ncsn where a.start_day < '2024-04-27 13:42:32' and (a.end_day > '2024-04-27 13:42:32' or a.end_day='0000-00-00 00:00:00') and a.enable='1' and b.not_news='0' order by a.start_day desc |
| 0.000879 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1324' order by sort |
| 0.000202 - select * from tad_news where nsn='1324' |
| 0.000191 - SELECT * FROM users WHERE uid = '13' |
| 0.000139 - SELECT groupid,name FROM groups |
| 0.000701 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1324' order by sort |
| 0.000645 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1324' order by sort |
| 0.011673 - select a.nsn,a.news_title,a.start_day,a.enable_group,a.ncsn from tad_news as a left join tad_news_cate as b on a.ncsn=b.ncsn where a.start_day < '2024-04-27 13:42:32' and (a.end_day > '2024-04-27 13:42:32' or a.end_day='0000-00-00 00:00:00') and a.enable='1' and b.not_news='0' order by a.start_day desc |
| 0.000951 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1323' order by sort |
| 0.000186 - select * from tad_news where nsn='1323' |
| 0.000141 - SELECT groupid,name FROM groups |
| 0.000727 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1323' order by sort |
| 0.000743 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1323' order by sort |
| 0.011241 - select a.nsn,a.news_title,a.start_day,a.enable_group,a.ncsn from tad_news as a left join tad_news_cate as b on a.ncsn=b.ncsn where a.start_day < '2024-04-27 13:42:32' and (a.end_day > '2024-04-27 13:42:32' or a.end_day='0000-00-00 00:00:00') and a.enable='1' and b.not_news='0' order by a.start_day desc |
| 0.000657 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1322' order by sort |
| 0.000153 - select * from tad_news where nsn='1322' |
| 0.000108 - SELECT groupid,name FROM groups |
| 0.000662 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1322' order by sort |
| 0.000716 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1322' order by sort |
| 0.012322 - select a.nsn,a.news_title,a.start_day,a.enable_group,a.ncsn from tad_news as a left join tad_news_cate as b on a.ncsn=b.ncsn where a.start_day < '2024-04-27 13:42:32' and (a.end_day > '2024-04-27 13:42:32' or a.end_day='0000-00-00 00:00:00') and a.enable='1' and b.not_news='0' order by a.start_day desc |
| 0.000904 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1321' order by sort |
| 0.000173 - select * from tad_news where nsn='1321' |
| 0.000182 - SELECT * FROM users WHERE uid = '15' |
| 0.000136 - SELECT groupid,name FROM groups |
| 0.000700 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1321' order by sort |
| 0.000695 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1321' order by sort |
| 0.000152 - select font_color,color,tag from tad_news_tags where `tag_sn`='1' and enable='1' |
| 0.010470 - select a.nsn,a.news_title,a.start_day,a.enable_group,a.ncsn from tad_news as a left join tad_news_cate as b on a.ncsn=b.ncsn where a.start_day < '2024-04-27 13:42:32' and (a.end_day > '2024-04-27 13:42:32' or a.end_day='0000-00-00 00:00:00') and a.enable='1' and b.not_news='0' order by a.start_day desc |
| 0.000645 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1320' order by sort |
| 0.000205 - select * from tad_news where nsn='1320' |
| 0.000141 - SELECT groupid,name FROM groups |
| 0.000761 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1320' order by sort |
| 0.000746 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1320' order by sort |
| 0.000158 - select font_color,color,tag from tad_news_tags where `tag_sn`='1' and enable='1' |
| 0.011870 - select a.nsn,a.news_title,a.start_day,a.enable_group,a.ncsn from tad_news as a left join tad_news_cate as b on a.ncsn=b.ncsn where a.start_day < '2024-04-27 13:42:32' and (a.end_day > '2024-04-27 13:42:32' or a.end_day='0000-00-00 00:00:00') and a.enable='1' and b.not_news='0' order by a.start_day desc |
| 0.000940 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1319' order by sort |
| 0.000185 - select * from tad_news where nsn='1319' |
| 0.000139 - SELECT groupid,name FROM groups |
| 0.000724 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1319' order by sort |
| 0.000733 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1319' order by sort |
| 0.000161 - select font_color,color,tag from tad_news_tags where `tag_sn`='1' and enable='1' |
| 0.010691 - select a.nsn,a.news_title,a.start_day,a.enable_group,a.ncsn from tad_news as a left join tad_news_cate as b on a.ncsn=b.ncsn where a.start_day < '2024-04-27 13:42:32' and (a.end_day > '2024-04-27 13:42:32' or a.end_day='0000-00-00 00:00:00') and a.enable='1' and b.not_news='0' order by a.start_day desc |
| 0.000662 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1318' order by sort |
| 0.000203 - select * from tad_news where nsn='1318' |
| 0.000140 - SELECT groupid,name FROM groups |
| 0.000762 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1318' order by sort |
| 0.000745 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1318' order by sort |
| 0.000158 - select font_color,color,tag from tad_news_tags where `tag_sn`='1' and enable='1' |
| 0.011717 - select a.nsn,a.news_title,a.start_day,a.enable_group,a.ncsn from tad_news as a left join tad_news_cate as b on a.ncsn=b.ncsn where a.start_day < '2024-04-27 13:42:32' and (a.end_day > '2024-04-27 13:42:32' or a.end_day='0000-00-00 00:00:00') and a.enable='1' and b.not_news='0' order by a.start_day desc |
| 0.000666 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1317' order by sort |
| 0.000192 - select * from tad_news where nsn='1317' |
| 0.000145 - SELECT groupid,name FROM groups |
| 0.000759 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1317' order by sort |
| 0.000719 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1317' order by sort |
| 0.010497 - select a.nsn,a.news_title,a.start_day,a.enable_group,a.ncsn from tad_news as a left join tad_news_cate as b on a.ncsn=b.ncsn where a.start_day < '2024-04-27 13:42:32' and (a.end_day > '2024-04-27 13:42:32' or a.end_day='0000-00-00 00:00:00') and a.enable='1' and b.not_news='0' order by a.start_day desc |
| 0.000631 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1315' order by sort |
| 0.000183 - select * from tad_news where nsn='1315' |
| 0.000146 - SELECT groupid,name FROM groups |
| 0.000709 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1315' order by sort |
| 0.000740 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1315' order by sort |
| 0.011902 - select a.nsn,a.news_title,a.start_day,a.enable_group,a.ncsn from tad_news as a left join tad_news_cate as b on a.ncsn=b.ncsn where a.start_day < '2024-04-27 13:42:32' and (a.end_day > '2024-04-27 13:42:32' or a.end_day='0000-00-00 00:00:00') and a.enable='1' and b.not_news='0' order by a.start_day desc |
| 0.000908 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1314' order by sort |
| 0.000186 - select * from tad_news where nsn='1314' |
| 0.000144 - SELECT groupid,name FROM groups |
| 0.000738 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1314' order by sort |
| 0.000714 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1314' order by sort |
| 0.010422 - select a.nsn,a.news_title,a.start_day,a.enable_group,a.ncsn from tad_news as a left join tad_news_cate as b on a.ncsn=b.ncsn where a.start_day < '2024-04-27 13:42:32' and (a.end_day > '2024-04-27 13:42:32' or a.end_day='0000-00-00 00:00:00') and a.enable='1' and b.not_news='0' order by a.start_day desc |
| 0.000880 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1313' order by sort |
| 0.000175 - select * from tad_news where nsn='1313' |
| 0.000137 - SELECT groupid,name FROM groups |
| 0.000699 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1313' order by sort |
| 0.000708 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1313' order by sort |
| 0.011731 - select a.nsn,a.news_title,a.start_day,a.enable_group,a.ncsn from tad_news as a left join tad_news_cate as b on a.ncsn=b.ncsn where a.start_day < '2024-04-27 13:42:32' and (a.end_day > '2024-04-27 13:42:32' or a.end_day='0000-00-00 00:00:00') and a.enable='1' and b.not_news='0' order by a.start_day desc |
| 0.000862 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1312' order by sort |
| 0.000223 - select * from tad_news where nsn='1312' |
| 0.000132 - SELECT groupid,name FROM groups |
| 0.000689 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1312' order by sort |
| 0.000702 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1312' order by sort |
| 0.000153 - select font_color,color,tag from tad_news_tags where `tag_sn`='1' and enable='1' |
| 0.010333 - select a.nsn,a.news_title,a.start_day,a.enable_group,a.ncsn from tad_news as a left join tad_news_cate as b on a.ncsn=b.ncsn where a.start_day < '2024-04-27 13:42:32' and (a.end_day > '2024-04-27 13:42:32' or a.end_day='0000-00-00 00:00:00') and a.enable='1' and b.not_news='0' order by a.start_day desc |
| 0.000663 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1311' order by sort |
| 0.000199 - select * from tad_news where nsn='1311' |
| 0.000145 - SELECT groupid,name FROM groups |
| 0.000764 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1311' order by sort |
| 0.000712 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1311' order by sort |
| 0.011877 - select a.nsn,a.news_title,a.start_day,a.enable_group,a.ncsn from tad_news as a left join tad_news_cate as b on a.ncsn=b.ncsn where a.start_day < '2024-04-27 13:42:32' and (a.end_day > '2024-04-27 13:42:32' or a.end_day='0000-00-00 00:00:00') and a.enable='1' and b.not_news='0' order by a.start_day desc |
| 0.000452 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'tadnews_rss.tpl') ORDER BY tpl_refid |