資料庫語法 |
---|
0.000174 - SET SQL_BIG_SELECTS = 1 |
0.001519 - SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC |
0.000284 - SELECT sess_data, sess_ip FROM session WHERE sess_id = '105i4s5p5cu5s88ediedh0pgj2' |
0.000307 - SELECT * FROM modules WHERE dirname = 'tadnews' |
0.000449 - SELECT COUNT(*) FROM group_permission WHERE (gperm_modid = '1' AND (gperm_groupid = '3') AND gperm_name = 'module_read' AND gperm_itemid = '9') |
0.000605 - SELECT * FROM config WHERE (conf_modid = '9') ORDER BY conf_order ASC |
0.000294 - select * from tad_news_cate where ncsn='29' |
0.002754 - select count(*) from tad_news where ncsn='29' |
0.000176 - SELECT groupid,name FROM groups |
0.000127 - SELECT groupid,name FROM groups |
0.000174 - select not_news from tad_news_cate where ncsn='29' |
0.000202 - SELECT * FROM modules WHERE dirname = 'tadtools' |
0.000288 - SELECT * FROM config WHERE (conf_modid = '3') ORDER BY conf_order ASC |
0.000205 - select * from tad_news_cate where 1 and not_news!='1' and `ncsn` = '29' order by sort |
0.018249 - select * from tad_news where 1 and enable='1' and `ncsn` = '29' and start_day < '2024-12-28 00:02:33' and (end_day > '2024-12-28 00:02:33' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc |
0.002762 - select * from tad_news where 1 and enable='1' and `ncsn` = '29' and start_day < '2024-12-28 00:02:33' and (end_day > '2024-12-28 00:02:33' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc LIMIT 0, 20 |
0.000650 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1401' order by sort |
0.000180 - select * from tad_news where nsn='1401' |
0.000174 - SELECT * FROM users WHERE uid = '1' |
0.000120 - SELECT groupid,name FROM groups |
0.000557 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1401' order by sort |
0.000553 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1401' order by sort |
0.011246 - 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-12-28 00:02:33' and (a.end_day > '2024-12-28 00:02:33' 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.000207 - SELECT * FROM smiles |
0.000643 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1400' order by sort |
0.000141 - select * from tad_news where nsn='1400' |
0.000105 - SELECT groupid,name FROM groups |
0.000538 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1400' order by sort |
0.000558 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1400' order by sort |
0.011262 - 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-12-28 00:02:33' and (a.end_day > '2024-12-28 00:02:33' 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.001204 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1399' order by sort |
0.000267 - select * from tad_news where nsn='1399' |
0.000253 - SELECT * FROM users WHERE uid = '6' |
0.000265 - SELECT groupid,name FROM groups |
0.001387 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1399' order by sort |
0.001317 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1399' order by sort |
0.000372 - select font_color,color,tag from tad_news_tags where `tag_sn`='4' and enable='1' |
0.014136 - 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-12-28 00:02:33' and (a.end_day > '2024-12-28 00:02:33' 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.000660 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1398' order by sort |
0.000138 - select * from tad_news where nsn='1398' |
0.000158 - SELECT * FROM users WHERE uid = '13' |
0.000108 - SELECT groupid,name FROM groups |
0.000579 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1398' order by sort |
0.000569 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1398' order by sort |
0.010378 - 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-12-28 00:02:33' and (a.end_day > '2024-12-28 00:02:33' 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.000710 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1397' order by sort |
0.000139 - select * from tad_news where nsn='1397' |
0.000111 - SELECT groupid,name FROM groups |
0.000528 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1397' order by sort |
0.000525 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1397' order by sort |
0.000115 - select font_color,color,tag from tad_news_tags where `tag_sn`='4' and enable='1' |
0.010460 - 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-12-28 00:02:33' and (a.end_day > '2024-12-28 00:02:33' 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.001728 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1396' order by sort |
0.000351 - select * from tad_news where nsn='1396' |
0.000261 - SELECT groupid,name FROM groups |
0.001484 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1396' order by sort |
0.001513 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1396' order by sort |
0.014014 - 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-12-28 00:02:33' and (a.end_day > '2024-12-28 00:02:33' 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.000674 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1395' order by sort |
0.000130 - select * from tad_news where nsn='1395' |
0.000115 - SELECT groupid,name FROM groups |
0.000575 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1395' order by sort |
0.000551 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1395' order by sort |
0.010568 - 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-12-28 00:02:33' and (a.end_day > '2024-12-28 00:02:33' 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.001755 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1394' order by sort |
0.000340 - select * from tad_news where nsn='1394' |
0.000260 - SELECT groupid,name FROM groups |
0.001538 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1394' order by sort |
0.000623 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1394' order by sort |
0.011644 - 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-12-28 00:02:33' and (a.end_day > '2024-12-28 00:02:33' 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.000935 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1393' order by sort |
0.000196 - select * from tad_news where nsn='1393' |
0.000139 - SELECT groupid,name FROM groups |
0.000792 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1393' order by sort |
0.000787 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1393' order by sort |
0.011052 - 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-12-28 00:02:33' and (a.end_day > '2024-12-28 00:02:33' 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.000577 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1392' order by sort |
0.000139 - select * from tad_news where nsn='1392' |
0.000100 - SELECT groupid,name FROM groups |
0.000636 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1392' order by sort |
0.000690 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1392' order by sort |
0.012393 - 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-12-28 00:02:33' and (a.end_day > '2024-12-28 00:02:33' 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.001810 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1391' order by sort |
0.000420 - select * from tad_news where nsn='1391' |
0.000268 - SELECT groupid,name FROM groups |
0.000791 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1391' order by sort |
0.000776 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1391' order by sort |
0.012908 - 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-12-28 00:02:33' and (a.end_day > '2024-12-28 00:02:33' 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.000620 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1390' order by sort |
0.000185 - select * from tad_news where nsn='1390' |
0.000133 - SELECT groupid,name FROM groups |
0.000701 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1390' order by sort |
0.000726 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1390' order by sort |
0.000151 - select font_color,color,tag from tad_news_tags where `tag_sn`='4' and enable='1' |
0.010552 - 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-12-28 00:02:33' and (a.end_day > '2024-12-28 00:02:33' 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.000911 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1389' order by sort |
0.000174 - select * from tad_news where nsn='1389' |
0.000128 - SELECT groupid,name FROM groups |
0.000710 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1389' order by sort |
0.000721 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1389' order by sort |
0.011539 - 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-12-28 00:02:33' and (a.end_day > '2024-12-28 00:02:33' 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.000901 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1388' order by sort |
0.000197 - select * from tad_news where nsn='1388' |
0.000137 - SELECT groupid,name FROM groups |
0.000730 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1388' order by sort |
0.000749 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1388' order by sort |
0.000173 - select font_color,color,tag from tad_news_tags where `tag_sn`='4' and enable='1' |
0.010582 - 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-12-28 00:02:33' and (a.end_day > '2024-12-28 00:02:33' 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.000898 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1387' order by sort |
0.000193 - select * from tad_news where nsn='1387' |
0.000189 - SELECT * FROM users WHERE uid = '15' |
0.000135 - SELECT groupid,name FROM groups |
0.000721 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1387' order by sort |
0.000737 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1387' order by sort |
0.000153 - select font_color,color,tag from tad_news_tags where `tag_sn`='1' and enable='1' |
0.011290 - 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-12-28 00:02:33' and (a.end_day > '2024-12-28 00:02:33' 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.000866 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1386' order by sort |
0.000169 - select * from tad_news where nsn='1386' |
0.000128 - SELECT groupid,name FROM groups |
0.000721 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1386' order by sort |
0.000648 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1386' order by sort |
0.000161 - select font_color,color,tag from tad_news_tags where `tag_sn`='1' and enable='1' |
0.011803 - 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-12-28 00:02:33' and (a.end_day > '2024-12-28 00:02:33' 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.000852 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1385' order by sort |
0.000165 - select * from tad_news where nsn='1385' |
0.000123 - SELECT groupid,name FROM groups |
0.000678 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1385' order by sort |
0.000689 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1385' order by sort |
0.010846 - 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-12-28 00:02:33' and (a.end_day > '2024-12-28 00:02:33' 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.000628 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1384' order by sort |
0.000178 - select * from tad_news where nsn='1384' |
0.000100 - SELECT groupid,name FROM groups |
0.000592 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1384' order by sort |
0.000641 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1384' order by sort |
0.012457 - 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-12-28 00:02:33' and (a.end_day > '2024-12-28 00:02:33' 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.000646 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1383' order by sort |
0.000194 - select * from tad_news where nsn='1383' |
0.000128 - SELECT groupid,name FROM groups |
0.000716 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1383' order by sort |
0.000679 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1383' order by sort |
0.000166 - select font_color,color,tag from tad_news_tags where `tag_sn`='1' and enable='1' |
0.010853 - 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-12-28 00:02:33' and (a.end_day > '2024-12-28 00:02:33' 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.000894 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1382' order by sort |
0.000201 - select * from tad_news where nsn='1382' |
0.000135 - SELECT groupid,name FROM groups |
0.000756 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1382' order by sort |
0.000747 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1382' order by sort |
0.000156 - select font_color,color,tag from tad_news_tags where `tag_sn`='1' and enable='1' |
0.012022 - 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-12-28 00:02:33' and (a.end_day > '2024-12-28 00:02:33' 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.000270 - 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 |