資料庫語法 |
---|
0.000045 - SET SQL_BIG_SELECTS = 1 |
0.000736 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '1') ORDER BY conf_order ASC |
0.000179 - SELECT sess_data, sess_ip FROM session WHERE sess_id = '2j654pkv3ilbdb1e29o37fi7d8' |
0.000552 - SELECT * FROM modules WHERE dirname = 'tadnews' |
0.000374 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '1' AND (`gperm_groupid` = '3') AND `gperm_name` = 'module_read' AND `gperm_itemid` = '5') |
0.000271 - SELECT * FROM config WHERE (`conf_modid` = '5') ORDER BY conf_order ASC |
0.000169 - SELECT * FROM modules WHERE dirname = 'tadtools' |
0.000173 - SELECT * FROM config WHERE (`conf_modid` = '2') ORDER BY conf_order ASC |
0.000108 - select mid from modules where dirname='tadnews' |
0.000203 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '5') ORDER BY conf_order ASC |
0.000232 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '3') ORDER BY conf_order ASC |
0.000692 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3) |
0.001065 - 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.000637 - 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.000351 - 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.000440 - 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.380454 - update tad_news set always_top='0' WHERE always_top_date <='2025-09-30 15:58:56' and always_top_date!='0000-00-00 00:00:00' |
0.001113 - select * from tad_news_cate where 1 and not_news!='1' order by sort |
0.476140 - 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 15:58:54' and (end_day > '2025-09-30 15:58:54' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc |
0.428393 - 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 15:58:54' and (end_day > '2025-09-30 15:58:54' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc LIMIT 6920, 20 |
0.000343 - desc `tadnews_data_center` `sort` |
0.001443 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3512' order by `sort` , `data_sort` |
0.006527 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3512' order by sort |
0.000153 - select * from tad_news where nsn='3512' |
0.000325 - SELECT * FROM users WHERE uid = '37' |
0.000523 - select groupid,name from groups |
0.005439 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3512' order by sort |
0.005001 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3512' order by sort |
0.000162 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.000099 - SELECT * FROM smiles |
0.000487 - desc `tadnews_data_center` `sort` |
0.000170 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3511' order by `sort` , `data_sort` |
0.005054 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3511' order by sort |
0.000159 - select * from tad_news where nsn='3511' |
0.000138 - SELECT * FROM users WHERE uid = '200' |
0.000111 - select groupid,name from groups |
0.004363 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3511' order by sort |
0.004898 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3511' order by sort |
0.000232 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000667 - desc `tadnews_data_center` `sort` |
0.000171 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3510' order by `sort` , `data_sort` |
0.005537 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3510' order by sort |
0.000159 - SELECT * FROM users WHERE uid = '178' |
0.000228 - select * from tad_news where nsn='3510' |
0.000120 - select groupid,name from groups |
0.004839 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3510' order by sort |
0.004037 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3510' order by sort |
0.000153 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000759 - desc `tadnews_data_center` `sort` |
0.000168 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3509' order by `sort` , `data_sort` |
0.013798 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3509' order by sort |
0.000164 - select * from tad_news where nsn='3509' |
0.000092 - select groupid,name from groups |
0.006069 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3509' order by sort |
0.012647 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3509' order by sort |
0.000137 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000647 - desc `tadnews_data_center` `sort` |
0.000711 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3508' order by `sort` , `data_sort` |
0.005226 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3508' order by sort |
0.005568 - select * from tad_news where nsn='3508' |
0.000101 - select groupid,name from groups |
0.005869 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3508' order by sort |
0.013374 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3508' order by sort |
0.000116 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000429 - desc `tadnews_data_center` `sort` |
0.000256 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3507' order by `sort` , `data_sort` |
0.004238 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3507' order by sort |
0.007020 - select * from tad_news where nsn='3507' |
0.000269 - select groupid,name from groups |
0.004167 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3507' order by sort |
0.010736 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3507' order by sort |
0.000286 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001237 - desc `tadnews_data_center` `sort` |
0.001830 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3506' order by `sort` , `data_sort` |
0.005606 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3506' order by sort |
0.010290 - select * from tad_news where nsn='3506' |
0.000231 - SELECT * FROM users WHERE uid = '176' |
0.000145 - select groupid,name from groups |
0.004298 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3506' order by sort |
0.005146 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3506' order by sort |
0.009766 - select font_color,color,tag from tad_news_tags where `tag_sn`='10' and enable='1' |
0.000967 - desc `tadnews_data_center` `sort` |
0.000302 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3505' order by `sort` , `data_sort` |
0.014837 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3505' order by sort |
0.000160 - SELECT * FROM users WHERE uid = '180' |
0.000413 - select * from tad_news where nsn='3505' |
0.000158 - select groupid,name from groups |
0.004189 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3505' order by sort |
0.004115 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3505' order by sort |
0.000108 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000367 - desc `tadnews_data_center` `sort` |
0.000178 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3504' order by `sort` , `data_sort` |
0.004580 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3504' order by sort |
0.000196 - select * from tad_news where nsn='3504' |
0.000097 - select groupid,name from groups |
0.004632 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3504' order by sort |
0.003742 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3504' order by sort |
0.000233 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000278 - desc `tadnews_data_center` `sort` |
0.000269 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3503' order by `sort` , `data_sort` |
0.005843 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3503' order by sort |
0.000245 - SELECT * FROM users WHERE uid = '184' |
0.000318 - select * from tad_news where nsn='3503' |
0.000313 - select groupid,name from groups |
0.004563 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3503' order by sort |
0.005701 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3503' order by sort |
0.000122 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000581 - desc `tadnews_data_center` `sort` |
0.000162 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3502' order by `sort` , `data_sort` |
0.013073 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3502' order by sort |
0.000422 - select * from tad_news where nsn='3502' |
0.000271 - select groupid,name from groups |
0.004292 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3502' order by sort |
0.004759 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3502' order by sort |
0.000289 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000756 - desc `tadnews_data_center` `sort` |
0.000312 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3501' order by `sort` , `data_sort` |
0.005788 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3501' order by sort |
0.001013 - select * from tad_news where nsn='3501' |
0.000107 - select groupid,name from groups |
0.005572 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3501' order by sort |
0.005056 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3501' order by sort |
0.000126 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000324 - desc `tadnews_data_center` `sort` |
0.000163 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3500' order by `sort` , `data_sort` |
0.004921 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3500' order by sort |
0.000268 - select * from tad_news where nsn='3500' |
0.000086 - select groupid,name from groups |
0.004570 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3500' order by sort |
0.003914 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3500' order by sort |
0.000110 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000363 - desc `tadnews_data_center` `sort` |
0.000321 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3499' order by `sort` , `data_sort` |
0.004871 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3499' order by sort |
0.000143 - select * from tad_news where nsn='3499' |
0.000089 - select groupid,name from groups |
0.004462 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3499' order by sort |
0.003962 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3499' order by sort |
0.000329 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000249 - desc `tadnews_data_center` `sort` |
0.000208 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3498' order by `sort` , `data_sort` |
0.004230 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3498' order by sort |
0.000115 - select * from tad_news where nsn='3498' |
0.000125 - select groupid,name from groups |
0.003795 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3498' order by sort |
0.004260 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3498' order by sort |
0.000118 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000333 - desc `tadnews_data_center` `sort` |
0.000172 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3496' order by `sort` , `data_sort` |
0.004265 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3496' order by sort |
0.000124 - select * from tad_news where nsn='3496' |
0.000083 - select groupid,name from groups |
0.003884 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3496' order by sort |
0.003887 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3496' order by sort |
0.000127 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000736 - desc `tadnews_data_center` `sort` |
0.000471 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3495' order by `sort` , `data_sort` |
0.005524 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3495' order by sort |
0.000147 - select * from tad_news where nsn='3495' |
0.000115 - SELECT * FROM users WHERE uid = '177' |
0.000087 - select groupid,name from groups |
0.004968 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3495' order by sort |
0.004950 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3495' order by sort |
0.000374 - desc `tadnews_data_center` `sort` |
0.000272 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3494' order by `sort` , `data_sort` |
0.004746 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3494' order by sort |
0.000363 - select * from tad_news where nsn='3494' |
0.000085 - select groupid,name from groups |
0.004281 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3494' order by sort |
0.004611 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3494' order by sort |
0.000313 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000827 - desc `tadnews_data_center` `sort` |
0.000237 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3493' order by `sort` , `data_sort` |
0.004637 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3493' order by sort |
0.000159 - select * from tad_news where nsn='3493' |
0.000090 - select groupid,name from groups |
0.003624 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3493' order by sort |
0.004633 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3493' order by sort |
0.000144 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000895 - desc `tadnews_data_center` `sort` |
0.000169 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3492' order by `sort` , `data_sort` |
0.004957 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3492' order by sort |
0.000403 - select * from tad_news where nsn='3492' |
0.000272 - select groupid,name from groups |
0.004420 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3492' order by sort |
0.004545 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3492' order by sort |
0.000112 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000105 - select `tt_theme`,`tt_use_bootstrap`,`tt_bootstrap_color`,`tt_theme_kind` from `tadtools_setup` where `tt_theme`='default' |
0.000432 - 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 |