資料庫語法 |
---|
0.000324 - SET SQL_BIG_SELECTS = 1 |
0.001388 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '1') ORDER BY conf_order ASC |
0.000296 - SELECT sess_data, sess_ip FROM session WHERE sess_id = 't32r3so7402iode2hgic0dn5a2' |
0.000215 - SELECT * FROM modules WHERE dirname = 'tadnews' |
0.000912 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '1' AND (`gperm_groupid` = '3') AND `gperm_name` = 'module_read' AND `gperm_itemid` = '5') |
0.001451 - SELECT * FROM config WHERE (`conf_modid` = '5') ORDER BY conf_order ASC |
0.000429 - SELECT * FROM modules WHERE dirname = 'tadtools' |
0.000213 - SELECT * FROM config WHERE (`conf_modid` = '2') ORDER BY conf_order ASC |
0.000182 - select mid from modules where dirname='tadnews' |
0.000323 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '5') ORDER BY conf_order ASC |
0.000287 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '3') ORDER BY conf_order ASC |
0.001555 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3) |
0.002258 - 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.000529 - 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.000299 - 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.000363 - 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.295944 - update tad_news set always_top='0' WHERE always_top_date <='2025-09-30 23:00:06' and always_top_date!='0000-00-00 00:00:00' |
0.000401 - select not_news from tad_news_cate where ncsn='8' |
0.000199 - select * from tad_news_cate where ncsn='8' |
0.290685 - select count(*) from tad_news where ncsn='8' |
0.012843 - select groupid,name from groups |
0.000074 - select groupid,name from groups |
0.000532 - select * from tad_news_cate where 1 and not_news!='1' and `ncsn` = '8' order by sort |
0.613758 - select * from tad_news where 1 and enable='1' and `ncsn` = '8' and start_day < '2025-09-30 23:00:04' and (end_day > '2025-09-30 23:00:04' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc |
0.259652 - select * from tad_news where 1 and enable='1' and `ncsn` = '8' and start_day < '2025-09-30 23:00:04' and (end_day > '2025-09-30 23:00:04' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc LIMIT 20, 20 |
0.008263 - desc `tadnews_data_center` `sort` |
0.000333 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10999' order by `sort` , `data_sort` |
0.008697 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10999' order by sort |
0.009689 - SELECT * FROM users WHERE uid = '180' |
0.000183 - select * from tad_news where nsn='10999' |
0.000301 - select groupid,name from groups |
0.006475 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10999' order by sort |
0.016856 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10999' order by sort |
0.000233 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000255 - SELECT * FROM smiles |
0.000727 - desc `tadnews_data_center` `sort` |
0.000212 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10997' order by `sort` , `data_sort` |
0.005758 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10997' order by sort |
0.005080 - SELECT * FROM users WHERE uid = '167' |
0.000250 - select * from tad_news where nsn='10997' |
0.000118 - select groupid,name from groups |
0.004549 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10997' order by sort |
0.015831 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10997' order by sort |
0.013874 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.003498 - desc `tadnews_data_center` `sort` |
0.000448 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10996' order by `sort` , `data_sort` |
0.021373 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10996' order by sort |
0.000334 - SELECT * FROM users WHERE uid = '186' |
0.000149 - select * from tad_news where nsn='10996' |
0.000137 - select groupid,name from groups |
0.009747 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10996' order by sort |
0.015723 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10996' order by sort |
0.007892 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000349 - desc `tadnews_data_center` `sort` |
0.000584 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10995' order by `sort` , `data_sort` |
0.008751 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10995' order by sort |
0.002828 - select * from tad_news where nsn='10995' |
0.002249 - select groupid,name from groups |
0.004911 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10995' order by sort |
0.009568 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10995' order by sort |
0.004964 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000884 - desc `tadnews_data_center` `sort` |
0.004525 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10994' order by `sort` , `data_sort` |
0.004839 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10994' order by sort |
0.003298 - SELECT * FROM users WHERE uid = '224' |
0.001969 - select * from tad_news where nsn='10994' |
0.000079 - select groupid,name from groups |
0.006194 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10994' order by sort |
0.010626 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10994' order by sort |
0.004429 - select font_color,color,tag from tad_news_tags where `tag_sn`='9' and enable='1' |
0.000804 - desc `tadnews_data_center` `sort` |
0.000545 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10993' order by `sort` , `data_sort` |
0.006697 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10993' order by sort |
0.006544 - select * from tad_news where nsn='10993' |
0.002205 - select groupid,name from groups |
0.009406 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10993' order by sort |
0.023836 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10993' order by sort |
0.000170 - select font_color,color,tag from tad_news_tags where `tag_sn`='9' and enable='1' |
0.000476 - desc `tadnews_data_center` `sort` |
0.000681 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10992' order by `sort` , `data_sort` |
0.006394 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10992' order by sort |
0.007266 - select * from tad_news where nsn='10992' |
0.000087 - select groupid,name from groups |
0.027031 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10992' order by sort |
0.030544 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10992' order by sort |
0.001321 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.001010 - desc `tadnews_data_center` `sort` |
0.000985 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10991' order by `sort` , `data_sort` |
0.010600 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10991' order by sort |
0.004259 - select * from tad_news where nsn='10991' |
0.000472 - select groupid,name from groups |
0.028014 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10991' order by sort |
0.012907 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10991' order by sort |
0.002373 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.005576 - desc `tadnews_data_center` `sort` |
0.002810 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10990' order by `sort` , `data_sort` |
0.023080 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10990' order by sort |
0.001198 - select * from tad_news where nsn='10990' |
0.000521 - select groupid,name from groups |
0.024030 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10990' order by sort |
0.010034 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10990' order by sort |
0.000980 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.006032 - desc `tadnews_data_center` `sort` |
0.001544 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10989' order by `sort` , `data_sort` |
0.019170 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10989' order by sort |
0.000692 - select * from tad_news where nsn='10989' |
0.000344 - select groupid,name from groups |
0.017657 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10989' order by sort |
0.015277 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10989' order by sort |
0.006564 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.001889 - desc `tadnews_data_center` `sort` |
0.001029 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10988' order by `sort` , `data_sort` |
0.013073 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10988' order by sort |
0.004284 - select * from tad_news where nsn='10988' |
0.000601 - select groupid,name from groups |
0.031340 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10988' order by sort |
0.016567 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10988' order by sort |
0.010161 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.002091 - desc `tadnews_data_center` `sort` |
0.004118 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10987' order by `sort` , `data_sort` |
0.007089 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10987' order by sort |
0.005435 - SELECT * FROM users WHERE uid = '278' |
0.001078 - select * from tad_news where nsn='10987' |
0.001206 - select groupid,name from groups |
0.007961 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10987' order by sort |
0.012456 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10987' order by sort |
0.009251 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001825 - desc `tadnews_data_center` `sort` |
0.000878 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10986' order by `sort` , `data_sort` |
0.017667 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10986' order by sort |
0.002153 - select * from tad_news where nsn='10986' |
0.001162 - select groupid,name from groups |
0.017628 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10986' order by sort |
0.013446 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10986' order by sort |
0.008674 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.001182 - desc `tadnews_data_center` `sort` |
0.005828 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10985' order by `sort` , `data_sort` |
0.012078 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10985' order by sort |
0.001421 - select * from tad_news where nsn='10985' |
0.001787 - select groupid,name from groups |
0.015853 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10985' order by sort |
0.018560 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10985' order by sort |
0.004555 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.001509 - desc `tadnews_data_center` `sort` |
0.000317 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10984' order by `sort` , `data_sort` |
0.009327 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10984' order by sort |
0.010785 - select * from tad_news where nsn='10984' |
0.000786 - SELECT * FROM users WHERE uid = '279' |
0.000509 - select groupid,name from groups |
0.008759 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10984' order by sort |
0.015271 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10984' order by sort |
0.010861 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001206 - desc `tadnews_data_center` `sort` |
0.000367 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10977' order by `sort` , `data_sort` |
0.006237 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10977' order by sort |
0.001220 - select * from tad_news where nsn='10977' |
0.007131 - select groupid,name from groups |
0.010273 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10977' order by sort |
0.016959 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10977' order by sort |
0.006894 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.001565 - desc `tadnews_data_center` `sort` |
0.000378 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10976' order by `sort` , `data_sort` |
0.017540 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10976' order by sort |
0.002102 - select * from tad_news where nsn='10976' |
0.000740 - SELECT * FROM users WHERE uid = '313' |
0.000631 - select groupid,name from groups |
0.006021 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10976' order by sort |
0.018186 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10976' order by sort |
0.007193 - desc `tadnews_data_center` `sort` |
0.004405 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10975' order by `sort` , `data_sort` |
0.009284 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10975' order by sort |
0.009694 - select * from tad_news where nsn='10975' |
0.001121 - select groupid,name from groups |
0.007478 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10975' order by sort |
0.015783 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10975' order by sort |
0.007243 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000945 - desc `tadnews_data_center` `sort` |
0.000827 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10974' order by `sort` , `data_sort` |
0.005686 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10974' order by sort |
0.003409 - select * from tad_news where nsn='10974' |
0.000485 - select groupid,name from groups |
0.014552 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10974' order by sort |
0.011401 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10974' order by sort |
0.000159 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.002201 - desc `tadnews_data_center` `sort` |
0.000852 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10973' order by `sort` , `data_sort` |
0.007431 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10973' order by sort |
0.147234 - select * from tad_news where nsn='10973' |
0.000358 - select groupid,name from groups |
0.007855 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10973' order by sort |
0.012903 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10973' order by sort |
0.012674 - select font_color,color,tag from tad_news_tags where `tag_sn`='9' and enable='1' |
0.000153 - select ncsn,nc_title from tad_news_cate where of_ncsn='0' |
0.000719 - SELECT t1.ncsn AS lev1, t2.ncsn as lev2, t3.ncsn as lev3, t4.ncsn as lev4, t5.ncsn as lev5, t6.ncsn as lev6, t7.ncsn as lev7
FROM `tad_news_cate` t1
LEFT JOIN `tad_news_cate` t2 ON t2.of_ncsn = t1.ncsn
LEFT JOIN `tad_news_cate` t3 ON t3.of_ncsn = t2.ncsn
LEFT JOIN `tad_news_cate` t4 ON t4.of_ncsn = t3.ncsn
LEFT JOIN `tad_news_cate` t5 ON t5.of_ncsn = t4.ncsn
LEFT JOIN `tad_news_cate` t6 ON t6.of_ncsn = t5.ncsn
LEFT JOIN `tad_news_cate` t7 ON t7.of_ncsn = t6.ncsn
WHERE t1.of_ncsn = '0' |
0.000115 - select * from tad_news_cate where ncsn='8' |
0.171086 - select count(*) from tad_news where ncsn='8' |
0.000643 - select groupid,name from groups |
0.001783 - select groupid,name from groups |
0.001654 - select ncsn,nc_title from tad_news_cate where of_ncsn='8' |
0.000184 - select `tt_theme`,`tt_use_bootstrap`,`tt_bootstrap_color`,`tt_theme_kind` from `tadtools_setup` where `tt_theme`='default' |
0.000524 - 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 |