資料庫語法 |
---|
0.000688 - SET SQL_BIG_SELECTS = 1 |
0.001699 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '1') ORDER BY conf_order ASC |
0.000617 - SELECT sess_data, sess_ip FROM session WHERE sess_id = 'mfenf2qk0n25l1naehp0372jdf' |
0.000592 - SELECT * FROM modules WHERE dirname = 'tadnews' |
0.001184 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '1' AND (`gperm_groupid` = '3') AND `gperm_name` = 'module_read' AND `gperm_itemid` = '5') |
0.000940 - SELECT * FROM config WHERE (`conf_modid` = '5') ORDER BY conf_order ASC |
0.000371 - SELECT * FROM modules WHERE dirname = 'tadtools' |
0.000574 - SELECT * FROM config WHERE (`conf_modid` = '2') ORDER BY conf_order ASC |
0.000421 - select mid from modules where dirname='tadnews' |
0.000403 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '5') ORDER BY conf_order ASC |
0.000355 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '3') ORDER BY conf_order ASC |
0.001463 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3) |
0.002978 - SELECT b.* FROM newblocks b, block_module_link m WHERE m.block_id=b.bid AND b.isactive=1 AND b.visible=1 AND m.module_id IN (0,5) AND b.bid IN (152,150,148,147,146,145,135,134,133,132,122,121,120,125,118,117,116,115,114,113,112,111,96,92,91,105,104,103,102,101,88,87,86,85,84,83,82,110,80,79,69,68,67,66,65,62,61,60,127,109,108,107,106,100,59,57,55,54,53,52,51,41,40,39,38,37,36,35,34,33,32,31,30,29,28,27,26,25,24,23,124,19,18,17,16,15,14,13,11,10,9,8,7,6,5,4,3,2,1,119,74,72,22,136,95,94,93,89,77,76,75,73,71,70,21) ORDER BY b.weight, m.block_id |
0.000407 - 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` = 'system_block_login.tpl') ORDER BY tpl_refid |
0.000579 - 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` = 'tadtools_app_block.tpl') ORDER BY tpl_refid |
0.000477 - 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` = 'system_block_dummy.tpl') ORDER BY tpl_refid |
0.175267 - update tad_news set always_top='0' WHERE always_top_date <='2025-09-30 19:26:48' and always_top_date!='0000-00-00 00:00:00' |
0.000359 - select * from tad_news_cate where 1 and not_news!='1' order by sort |
0.453743 - select * from tad_news where 1 and enable='1' and (ncsn in(8,9,10,12,11,13,4) or ncsn='0') and start_day < '2025-09-30 19:26:46' and (end_day > '2025-09-30 19:26:46' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc |
0.173754 - select * from tad_news where 1 and enable='1' and (ncsn in(8,9,10,12,11,13,4) or ncsn='0') and start_day < '2025-09-30 19:26:46' and (end_day > '2025-09-30 19:26:46' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc LIMIT 400, 20 |
0.002320 - desc `tadnews_data_center` `sort` |
0.001649 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10582' order by `sort` , `data_sort` |
0.009995 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10582' order by sort |
0.000832 - SELECT * FROM users WHERE uid = '182' |
0.000449 - select * from tad_news where nsn='10582' |
0.000317 - select groupid,name from groups |
0.008108 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10582' order by sort |
0.007169 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10582' order by sort |
0.000509 - select font_color,color,tag from tad_news_tags where `tag_sn`='9' and enable='1' |
0.000151 - SELECT * FROM smiles |
0.002296 - desc `tadnews_data_center` `sort` |
0.000963 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10581' order by `sort` , `data_sort` |
0.009811 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10581' order by sort |
0.000916 - select * from tad_news where nsn='10581' |
0.000579 - SELECT * FROM users WHERE uid = '37' |
0.000629 - select groupid,name from groups |
0.007561 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10581' order by sort |
0.007825 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10581' order by sort |
0.000717 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.001606 - desc `tadnews_data_center` `sort` |
0.000457 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10580' order by `sort` , `data_sort` |
0.008499 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10580' order by sort |
0.000547 - SELECT * FROM users WHERE uid = '225' |
0.001195 - select * from tad_news where nsn='10580' |
0.000685 - select groupid,name from groups |
0.008590 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10580' order by sort |
0.008034 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10580' order by sort |
0.000330 - select font_color,color,tag from tad_news_tags where `tag_sn`='9' and enable='1' |
0.001051 - desc `tadnews_data_center` `sort` |
0.000220 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10579' order by `sort` , `data_sort` |
0.007842 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10579' order by sort |
0.000541 - SELECT * FROM users WHERE uid = '172' |
0.001094 - select * from tad_news where nsn='10579' |
0.000243 - select groupid,name from groups |
0.008240 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10579' order by sort |
0.007977 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10579' order by sort |
0.001056 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.001285 - desc `tadnews_data_center` `sort` |
0.001091 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10577' order by `sort` , `data_sort` |
0.011926 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10577' order by sort |
0.000482 - SELECT * FROM users WHERE uid = '230' |
0.000806 - select * from tad_news where nsn='10577' |
0.000570 - select groupid,name from groups |
0.008818 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10577' order by sort |
0.010915 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10577' order by sort |
0.001377 - select font_color,color,tag from tad_news_tags where `tag_sn`='10' and enable='1' |
0.002001 - desc `tadnews_data_center` `sort` |
0.000453 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10578' order by `sort` , `data_sort` |
0.007722 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10578' order by sort |
0.000569 - select * from tad_news where nsn='10578' |
0.000836 - select groupid,name from groups |
0.008717 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10578' order by sort |
0.007654 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10578' order by sort |
0.000744 - select font_color,color,tag from tad_news_tags where `tag_sn`='9' and enable='1' |
0.002028 - desc `tadnews_data_center` `sort` |
0.000415 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10576' order by `sort` , `data_sort` |
0.010127 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10576' order by sort |
0.000698 - select * from tad_news where nsn='10576' |
0.000149 - select groupid,name from groups |
0.008726 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10576' order by sort |
0.007636 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10576' order by sort |
0.000748 - select font_color,color,tag from tad_news_tags where `tag_sn`='9' and enable='1' |
0.001980 - desc `tadnews_data_center` `sort` |
0.000732 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10575' order by `sort` , `data_sort` |
0.008170 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10575' order by sort |
0.000230 - select * from tad_news where nsn='10575' |
0.000345 - select groupid,name from groups |
0.006727 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10575' order by sort |
0.007736 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10575' order by sort |
0.000379 - select font_color,color,tag from tad_news_tags where `tag_sn`='9' and enable='1' |
0.001116 - desc `tadnews_data_center` `sort` |
0.000632 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10574' order by `sort` , `data_sort` |
0.009714 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10574' order by sort |
0.000443 - SELECT * FROM users WHERE uid = '169' |
0.000299 - select * from tad_news where nsn='10574' |
0.000420 - select groupid,name from groups |
0.007213 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10574' order by sort |
0.006973 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10574' order by sort |
0.001814 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.002079 - desc `tadnews_data_center` `sort` |
0.000257 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10573' order by `sort` , `data_sort` |
0.007506 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10573' order by sort |
0.000710 - select * from tad_news where nsn='10573' |
0.000534 - select groupid,name from groups |
0.006777 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10573' order by sort |
0.007188 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10573' order by sort |
0.000661 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001137 - desc `tadnews_data_center` `sort` |
0.001116 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10572' order by `sort` , `data_sort` |
0.007988 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10572' order by sort |
0.000928 - select * from tad_news where nsn='10572' |
0.000170 - select groupid,name from groups |
0.007835 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10572' order by sort |
0.008304 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10572' order by sort |
0.000247 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001262 - desc `tadnews_data_center` `sort` |
0.001262 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10571' order by `sort` , `data_sort` |
0.008563 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10571' order by sort |
0.000390 - select * from tad_news where nsn='10571' |
0.000491 - select groupid,name from groups |
0.009042 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10571' order by sort |
0.008400 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10571' order by sort |
0.001007 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001262 - desc `tadnews_data_center` `sort` |
0.000483 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10570' order by `sort` , `data_sort` |
0.007736 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10570' order by sort |
0.000684 - SELECT * FROM users WHERE uid = '249' |
0.000779 - select * from tad_news where nsn='10570' |
0.000127 - select groupid,name from groups |
0.005282 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10570' order by sort |
0.005751 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10570' order by sort |
0.000308 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000410 - desc `tadnews_data_center` `sort` |
0.000329 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10569' order by `sort` , `data_sort` |
0.005922 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10569' order by sort |
0.000281 - select * from tad_news where nsn='10569' |
0.000262 - select groupid,name from groups |
0.006351 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10569' order by sort |
0.006221 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10569' order by sort |
0.000953 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001207 - desc `tadnews_data_center` `sort` |
0.000487 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10568' order by `sort` , `data_sort` |
0.006759 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10568' order by sort |
0.000199 - select * from tad_news where nsn='10568' |
0.000183 - select groupid,name from groups |
0.005644 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10568' order by sort |
0.006439 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10568' order by sort |
0.000237 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.000648 - desc `tadnews_data_center` `sort` |
0.000206 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10567' order by `sort` , `data_sort` |
0.008026 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10567' order by sort |
0.000238 - SELECT * FROM users WHERE uid = '186' |
0.000482 - select * from tad_news where nsn='10567' |
0.000162 - select groupid,name from groups |
0.007225 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10567' order by sort |
0.004515 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10567' order by sort |
0.000192 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000449 - desc `tadnews_data_center` `sort` |
0.000453 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10566' order by `sort` , `data_sort` |
0.007640 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10566' order by sort |
0.000906 - select * from tad_news where nsn='10566' |
0.000120 - select groupid,name from groups |
0.007584 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10566' order by sort |
0.007142 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10566' order by sort |
0.000579 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.001787 - desc `tadnews_data_center` `sort` |
0.001463 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10565' order by `sort` , `data_sort` |
0.007365 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10565' order by sort |
0.000516 - select * from tad_news where nsn='10565' |
0.000381 - select groupid,name from groups |
0.008136 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10565' order by sort |
0.007404 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10565' order by sort |
0.000405 - select font_color,color,tag from tad_news_tags where `tag_sn`='10' and enable='1' |
0.002561 - desc `tadnews_data_center` `sort` |
0.000637 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10563' order by `sort` , `data_sort` |
0.007770 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10563' order by sort |
0.000950 - select * from tad_news where nsn='10563' |
0.000105 - select groupid,name from groups |
0.007844 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10563' order by sort |
0.008113 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10563' order by sort |
0.000667 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.001433 - desc `tadnews_data_center` `sort` |
0.000941 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10562' order by `sort` , `data_sort` |
0.008146 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10562' order by sort |
0.000740 - select * from tad_news where nsn='10562' |
0.000156 - select groupid,name from groups |
0.006093 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10562' order by sort |
0.007137 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10562' order by sort |
0.000261 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000182 - select `tt_theme`,`tt_use_bootstrap`,`tt_bootstrap_color`,`tt_theme_kind` from `tadtools_setup` where `tt_theme`='default' |
0.001299 - 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_index.tpl') ORDER BY tpl_refid |