資料庫語法 |
---|
0.000123 - SET SQL_BIG_SELECTS = 1 |
0.001079 - SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC |
0.000246 - SELECT sess_data, sess_ip FROM session WHERE sess_id = '1afoupvhon9gm6tevh9fu8cck1' |
0.000300 - SELECT * FROM modules WHERE dirname = 'tadnews' |
0.000448 - SELECT COUNT(*) FROM group_permission WHERE (gperm_modid = '1' AND (gperm_groupid = '3') AND gperm_name = 'module_read' AND gperm_itemid = '9') |
0.000387 - SELECT * FROM config WHERE (conf_modid = '9') ORDER BY conf_order ASC |
0.000151 - select * from tad_news_cate where ncsn='29' |
0.002217 - select count(*) from tad_news where ncsn='29' |
0.000108 - SELECT groupid,name FROM groups |
0.000100 - SELECT groupid,name FROM groups |
0.000120 - select not_news from tad_news_cate where ncsn='29' |
0.000163 - SELECT * FROM modules WHERE dirname = 'tadtools' |
0.000233 - SELECT * FROM config WHERE (conf_modid = '3') ORDER BY conf_order ASC |
0.000145 - select * from tad_news_cate where 1 and not_news!='1' and `ncsn` = '29' order by sort |
0.015938 - select * from tad_news where 1 and enable='1' and `ncsn` = '29' and start_day < '2024-10-05 11:18:37' and (end_day > '2024-10-05 11:18:37' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc |
0.002563 - select * from tad_news where 1 and enable='1' and `ncsn` = '29' and start_day < '2024-10-05 11:18:37' and (end_day > '2024-10-05 11:18:37' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc LIMIT 0, 20 |
0.000681 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1401' order by sort |
0.000139 - select * from tad_news where nsn='1401' |
0.000144 - SELECT * FROM users WHERE uid = '1' |
0.000108 - SELECT groupid,name FROM groups |
0.000592 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1401' order by sort |
0.000569 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1401' order by sort |
0.010623 - 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-10-05 11:18:37' and (a.end_day > '2024-10-05 11:18:37' 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.000176 - SELECT * FROM smiles |
0.001642 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1400' order by sort |
0.000532 - select * from tad_news where nsn='1400' |
0.000293 - SELECT groupid,name FROM groups |
0.001510 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1400' order by sort |
0.001440 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1400' order by sort |
0.013879 - 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-10-05 11:18:37' and (a.end_day > '2024-10-05 11:18:37' 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.001110 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1399' order by sort |
0.000245 - select * from tad_news where nsn='1399' |
0.000236 - SELECT * FROM users WHERE uid = '6' |
0.000171 - SELECT groupid,name FROM groups |
0.000955 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1399' order by sort |
0.000944 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1399' order by sort |
0.000193 - select font_color,color,tag from tad_news_tags where `tag_sn`='4' and enable='1' |
0.011378 - 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-10-05 11:18:37' and (a.end_day > '2024-10-05 11:18:37' 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.000591 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1398' order by sort |
0.000125 - select * from tad_news where nsn='1398' |
0.000132 - SELECT * FROM users WHERE uid = '13' |
0.000112 - SELECT groupid,name FROM groups |
0.000551 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1398' order by sort |
0.000528 - 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-10-05 11:18:37' and (a.end_day > '2024-10-05 11:18:37' 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.000715 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1397' order by sort |
0.000137 - select * from tad_news where nsn='1397' |
0.000104 - SELECT groupid,name FROM groups |
0.000545 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1397' order by sort |
0.000516 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1397' order by sort |
0.000129 - select font_color,color,tag from tad_news_tags where `tag_sn`='4' and enable='1' |
0.010215 - 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-10-05 11:18:37' and (a.end_day > '2024-10-05 11:18:37' 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.001801 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1396' order by sort |
0.000368 - select * from tad_news where nsn='1396' |
0.000267 - SELECT groupid,name FROM groups |
0.001230 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1396' order by sort |
0.001201 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1396' order by sort |
0.014974 - 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-10-05 11:18:37' and (a.end_day > '2024-10-05 11:18:37' 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.000636 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1395' order by sort |
0.000155 - select * from tad_news where nsn='1395' |
0.000120 - SELECT groupid,name FROM groups |
0.000531 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1395' order by sort |
0.000564 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1395' order by sort |
0.010271 - 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-10-05 11:18:37' and (a.end_day > '2024-10-05 11:18:37' 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.001633 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1394' order by sort |
0.000337 - select * from tad_news where nsn='1394' |
0.000241 - SELECT groupid,name FROM groups |
0.001321 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1394' order by sort |
0.001381 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1394' order by sort |
0.011013 - 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-10-05 11:18:37' and (a.end_day > '2024-10-05 11:18:37' 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.000642 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1393' order by sort |
0.000154 - select * from tad_news where nsn='1393' |
0.000104 - SELECT groupid,name FROM groups |
0.000565 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1393' order by sort |
0.000521 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1393' order by sort |
0.010094 - 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-10-05 11:18:37' and (a.end_day > '2024-10-05 11:18:37' 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.000636 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1392' order by sort |
0.000128 - select * from tad_news where nsn='1392' |
0.000097 - SELECT groupid,name FROM groups |
0.000534 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1392' order by sort |
0.000524 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1392' order by sort |
0.010435 - 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-10-05 11:18:37' and (a.end_day > '2024-10-05 11:18:37' 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.001779 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1391' order by sort |
0.000386 - select * from tad_news where nsn='1391' |
0.000282 - SELECT groupid,name FROM groups |
0.001464 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1391' order by sort |
0.001454 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1391' order by sort |
0.012180 - 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-10-05 11:18:37' and (a.end_day > '2024-10-05 11:18:37' 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.001209 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1390' order by sort |
0.000232 - select * from tad_news where nsn='1390' |
0.000211 - SELECT groupid,name FROM groups |
0.001026 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1390' order by sort |
0.001000 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1390' order by sort |
0.000205 - select font_color,color,tag from tad_news_tags where `tag_sn`='4' and enable='1' |
0.012016 - 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-10-05 11:18:37' and (a.end_day > '2024-10-05 11:18:37' 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.000883 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1389' order by sort |
0.000241 - select * from tad_news where nsn='1389' |
0.000201 - SELECT groupid,name FROM groups |
0.001006 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1389' order by sort |
0.001006 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1389' order by sort |
0.013076 - 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-10-05 11:18:37' and (a.end_day > '2024-10-05 11:18:37' 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.000915 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1388' order by sort |
0.000181 - select * from tad_news where nsn='1388' |
0.000162 - SELECT groupid,name FROM groups |
0.000767 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1388' order by sort |
0.000719 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1388' order by sort |
0.000138 - select font_color,color,tag from tad_news_tags where `tag_sn`='4' and enable='1' |
0.011754 - 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-10-05 11:18:37' and (a.end_day > '2024-10-05 11:18:37' 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`='1387' order by sort |
0.000181 - select * from tad_news where nsn='1387' |
0.000195 - SELECT * FROM users WHERE uid = '15' |
0.000139 - SELECT groupid,name FROM groups |
0.000741 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1387' order by sort |
0.000778 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1387' order by sort |
0.000158 - select font_color,color,tag from tad_news_tags where `tag_sn`='1' and enable='1' |
0.010871 - 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-10-05 11:18:37' and (a.end_day > '2024-10-05 11:18:37' 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.000677 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1386' order by sort |
0.000140 - select * from tad_news where nsn='1386' |
0.000104 - SELECT groupid,name FROM groups |
0.000696 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1386' order by sort |
0.000740 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1386' order by sort |
0.000172 - select font_color,color,tag from tad_news_tags where `tag_sn`='1' and enable='1' |
0.012550 - 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-10-05 11:18:37' and (a.end_day > '2024-10-05 11:18:37' 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.000956 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1385' order by sort |
0.000187 - select * from tad_news where nsn='1385' |
0.000141 - SELECT groupid,name FROM groups |
0.000733 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1385' order by sort |
0.000778 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1385' order by sort |
0.011033 - 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-10-05 11:18:37' and (a.end_day > '2024-10-05 11:18:37' 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.000948 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1384' order by sort |
0.000192 - select * from tad_news where nsn='1384' |
0.000154 - SELECT groupid,name FROM groups |
0.000756 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1384' order by sort |
0.000725 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1384' order by sort |
0.011720 - 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-10-05 11:18:37' and (a.end_day > '2024-10-05 11:18:37' 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.000681 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1383' order by sort |
0.000178 - select * from tad_news where nsn='1383' |
0.000128 - SELECT groupid,name FROM groups |
0.000704 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1383' order by sort |
0.000693 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1383' order by sort |
0.000146 - select font_color,color,tag from tad_news_tags where `tag_sn`='1' and enable='1' |
0.011912 - 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-10-05 11:18:37' and (a.end_day > '2024-10-05 11:18:37' 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.000917 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1382' order by sort |
0.000187 - select * from tad_news where nsn='1382' |
0.000137 - SELECT groupid,name FROM groups |
0.000734 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1382' order by sort |
0.000729 - 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.011022 - 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-10-05 11:18:37' and (a.end_day > '2024-10-05 11:18:37' 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.000364 - 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 |