| 資料庫語法 |
|---|
| 0.000200 - SET SQL_BIG_SELECTS = 1 |
| 0.002000 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '1') ORDER BY conf_order ASC |
| 0.009254 - SELECT sess_data, sess_ip FROM session WHERE sess_id = '5vm3hd4hkirj6t4cpnslmhhd8b' |
| 0.000829 - SELECT * FROM modules WHERE dirname = 'tadnews' |
| 0.001410 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '1' AND (`gperm_groupid` = '3') AND `gperm_name` = 'module_read' AND `gperm_itemid` = '5') |
| 0.001046 - SELECT * FROM config WHERE (`conf_modid` = '5') ORDER BY conf_order ASC |
| 0.000562 - SELECT * FROM modules WHERE dirname = 'tadtools' |
| 0.000692 - SELECT * FROM config WHERE (`conf_modid` = '2') ORDER BY conf_order ASC |
| 0.000152 - select mid from modules where dirname='tadnews' |
| 0.000176 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '5') ORDER BY conf_order ASC |
| 0.000449 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '3') ORDER BY conf_order ASC |
| 0.005385 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3) |
| 0.003364 - 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.001072 - 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.000466 - 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.000518 - 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.766826 - update tad_news set always_top='0' WHERE always_top_date <='2025-09-30 21:22:39' and always_top_date!='0000-00-00 00:00:00' |
| 0.004101 - select not_news from tad_news_cate where ncsn='13' |
| 0.003609 - select * from tad_news_cate where ncsn='13' |
| 0.157795 - select count(*) from tad_news where ncsn='13' |
| 0.006267 - select groupid,name from groups |
| 0.004231 - select groupid,name from groups |
| 0.000315 - select * from tad_news_cate where 1 and not_news!='1' and `ncsn` = '13' order by sort |
| 0.360414 - select * from tad_news where 1 and enable='1' and `ncsn` = '13' and start_day < '2025-09-30 21:22:38' and (end_day > '2025-09-30 21:22:38' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc |
| 1.550573 - select * from tad_news where 1 and enable='1' and `ncsn` = '13' and start_day < '2025-09-30 21:22:38' and (end_day > '2025-09-30 21:22:38' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc LIMIT 0, 20 |
| 0.006448 - desc `tadnews_data_center` `sort` |
| 0.001181 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10610' order by `sort` , `data_sort` |
| 0.038472 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10610' order by sort |
| 0.000905 - SELECT * FROM users WHERE uid = '227' |
| 0.000772 - select * from tad_news where nsn='10610' |
| 0.006197 - select groupid,name from groups |
| 0.027410 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10610' order by sort |
| 0.017876 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10610' order by sort |
| 0.016821 - select font_color,color,tag from tad_news_tags where `tag_sn`='13' and enable='1' |
| 0.007173 - SELECT * FROM smiles |
| 0.001175 - desc `tadnews_data_center` `sort` |
| 0.005489 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10609' order by `sort` , `data_sort` |
| 0.019137 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10609' order by sort |
| 0.006062 - select * from tad_news where nsn='10609' |
| 0.000100 - select groupid,name from groups |
| 0.024422 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10609' order by sort |
| 0.024132 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10609' order by sort |
| 0.016236 - select font_color,color,tag from tad_news_tags where `tag_sn`='13' and enable='1' |
| 0.000850 - desc `tadnews_data_center` `sort` |
| 0.003561 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10608' order by `sort` , `data_sort` |
| 0.005724 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10608' order by sort |
| 0.018147 - select * from tad_news where nsn='10608' |
| 0.000171 - select groupid,name from groups |
| 0.022187 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10608' order by sort |
| 0.026178 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10608' order by sort |
| 0.008012 - select font_color,color,tag from tad_news_tags where `tag_sn`='13' and enable='1' |
| 0.000296 - desc `tadnews_data_center` `sort` |
| 0.000585 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10169' order by `sort` , `data_sort` |
| 0.008631 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10169' order by sort |
| 0.000575 - select * from tad_news where nsn='10169' |
| 0.000196 - select groupid,name from groups |
| 0.044965 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10169' order by sort |
| 0.028459 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10169' order by sort |
| 0.007838 - select font_color,color,tag from tad_news_tags where `tag_sn`='13' and enable='1' |
| 0.001087 - desc `tadnews_data_center` `sort` |
| 0.007861 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='9865' order by `sort` , `data_sort` |
| 0.020633 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='9865' order by sort |
| 0.013040 - select * from tad_news where nsn='9865' |
| 0.005207 - select groupid,name from groups |
| 0.015205 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='9865' order by sort |
| 0.016664 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='9865' order by sort |
| 0.025171 - desc `tadnews_data_center` `sort` |
| 0.010429 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='9864' order by `sort` , `data_sort` |
| 0.013903 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='9864' order by sort |
| 0.011309 - select * from tad_news where nsn='9864' |
| 0.000095 - select groupid,name from groups |
| 0.004816 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='9864' order by sort |
| 0.049681 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='9864' order by sort |
| 0.001124 - desc `tadnews_data_center` `sort` |
| 0.005744 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='9863' order by `sort` , `data_sort` |
| 0.015216 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='9863' order by sort |
| 0.010306 - select * from tad_news where nsn='9863' |
| 0.004966 - select groupid,name from groups |
| 0.023227 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='9863' order by sort |
| 0.025756 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='9863' order by sort |
| 0.012154 - desc `tadnews_data_center` `sort` |
| 0.006732 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='9541' order by `sort` , `data_sort` |
| 0.020986 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='9541' order by sort |
| 0.016704 - select * from tad_news where nsn='9541' |
| 0.000089 - select groupid,name from groups |
| 0.029921 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='9541' order by sort |
| 0.018016 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='9541' order by sort |
| 0.025706 - select font_color,color,tag from tad_news_tags where `tag_sn`='13' and enable='1' |
| 0.001211 - desc `tadnews_data_center` `sort` |
| 0.000450 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='9540' order by `sort` , `data_sort` |
| 0.006934 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='9540' order by sort |
| 0.022448 - select * from tad_news where nsn='9540' |
| 0.000242 - select groupid,name from groups |
| 0.034948 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='9540' order by sort |
| 0.026495 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='9540' order by sort |
| 0.000689 - select font_color,color,tag from tad_news_tags where `tag_sn`='13' and enable='1' |
| 0.012496 - desc `tadnews_data_center` `sort` |
| 0.000905 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='9276' order by `sort` , `data_sort` |
| 0.028463 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='9276' order by sort |
| 0.010135 - select * from tad_news where nsn='9276' |
| 0.002334 - select groupid,name from groups |
| 0.030144 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='9276' order by sort |
| 0.012804 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='9276' order by sort |
| 0.014795 - select font_color,color,tag from tad_news_tags where `tag_sn`='13' and enable='1' |
| 0.006599 - 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`='9135' order by `sort` , `data_sort` |
| 0.012093 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='9135' order by sort |
| 0.018185 - select * from tad_news where nsn='9135' |
| 0.000274 - select groupid,name from groups |
| 0.016193 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='9135' order by sort |
| 0.035333 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='9135' order by sort |
| 0.000126 - select font_color,color,tag from tad_news_tags where `tag_sn`='13' and enable='1' |
| 0.004181 - desc `tadnews_data_center` `sort` |
| 0.001912 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='9020' order by `sort` , `data_sort` |
| 0.032062 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='9020' order by sort |
| 0.014106 - select * from tad_news where nsn='9020' |
| 0.000250 - select groupid,name from groups |
| 0.009495 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='9020' order by sort |
| 0.030250 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='9020' order by sort |
| 0.001562 - select font_color,color,tag from tad_news_tags where `tag_sn`='13' and enable='1' |
| 0.000348 - desc `tadnews_data_center` `sort` |
| 0.000482 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='9072' order by `sort` , `data_sort` |
| 0.017597 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='9072' order by sort |
| 0.000686 - select * from tad_news where nsn='9072' |
| 0.003449 - select groupid,name from groups |
| 0.005157 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='9072' order by sort |
| 0.047261 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='9072' order by sort |
| 0.000240 - select font_color,color,tag from tad_news_tags where `tag_sn`='13' and enable='1' |
| 0.000261 - desc `tadnews_data_center` `sort` |
| 0.000307 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='8681' order by `sort` , `data_sort` |
| 0.024869 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='8681' order by sort |
| 0.005026 - select * from tad_news where nsn='8681' |
| 0.009221 - select groupid,name from groups |
| 0.017865 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8681' order by sort |
| 0.013378 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8681' order by sort |
| 0.026135 - select font_color,color,tag from tad_news_tags where `tag_sn`='13' and enable='1' |
| 0.002957 - desc `tadnews_data_center` `sort` |
| 0.005589 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='8527' order by `sort` , `data_sort` |
| 0.037658 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='8527' order by sort |
| 0.007797 - select * from tad_news where nsn='8527' |
| 0.001391 - select groupid,name from groups |
| 0.025853 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8527' order by sort |
| 0.032764 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8527' order by sort |
| 0.009292 - select font_color,color,tag from tad_news_tags where `tag_sn`='13' and enable='1' |
| 0.000420 - desc `tadnews_data_center` `sort` |
| 0.001826 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='8526' order by `sort` , `data_sort` |
| 0.049916 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='8526' order by sort |
| 0.003954 - select * from tad_news where nsn='8526' |
| 0.003654 - select groupid,name from groups |
| 0.027579 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8526' order by sort |
| 0.055929 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8526' order by sort |
| 0.023006 - select font_color,color,tag from tad_news_tags where `tag_sn`='13' and enable='1' |
| 0.006021 - desc `tadnews_data_center` `sort` |
| 0.001249 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='8234' order by `sort` , `data_sort` |
| 0.037875 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='8234' order by sort |
| 0.006919 - select * from tad_news where nsn='8234' |
| 0.005017 - select groupid,name from groups |
| 0.067572 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8234' order by sort |
| 0.063629 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8234' order by sort |
| 0.003583 - select font_color,color,tag from tad_news_tags where `tag_sn`='13' and enable='1' |
| 0.000778 - desc `tadnews_data_center` `sort` |
| 0.001663 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='8098' order by `sort` , `data_sort` |
| 0.020363 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='8098' order by sort |
| 0.002575 - select * from tad_news where nsn='8098' |
| 0.000157 - select groupid,name from groups |
| 0.015618 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8098' order by sort |
| 0.035903 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8098' order by sort |
| 0.000192 - select font_color,color,tag from tad_news_tags where `tag_sn`='13' and enable='1' |
| 0.002021 - desc `tadnews_data_center` `sort` |
| 0.001512 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='7814' order by `sort` , `data_sort` |
| 0.037788 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='7814' order by sort |
| 0.000807 - select * from tad_news where nsn='7814' |
| 0.000241 - select groupid,name from groups |
| 0.011566 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='7814' order by sort |
| 0.032880 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='7814' order by sort |
| 0.004580 - select font_color,color,tag from tad_news_tags where `tag_sn`='13' and enable='1' |
| 0.001263 - desc `tadnews_data_center` `sort` |
| 0.000262 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='7813' order by `sort` , `data_sort` |
| 0.022233 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='7813' order by sort |
| 0.005978 - select * from tad_news where nsn='7813' |
| 0.000272 - select groupid,name from groups |
| 0.014064 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='7813' order by sort |
| 0.024622 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='7813' order by sort |
| 0.014636 - select font_color,color,tag from tad_news_tags where `tag_sn`='13' and enable='1' |
| 0.001140 - select ncsn,nc_title from tad_news_cate where of_ncsn='0' |
| 0.001599 - 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.009168 - select * from tad_news_cate where ncsn='13' |
| 0.113398 - select count(*) from tad_news where ncsn='13' |
| 0.000137 - select groupid,name from groups |
| 0.000061 - select groupid,name from groups |
| 0.000160 - select ncsn,nc_title from tad_news_cate where of_ncsn='13' |
| 0.000101 - select `tt_theme`,`tt_use_bootstrap`,`tt_bootstrap_color`,`tt_theme_kind` from `tadtools_setup` where `tt_theme`='default' |
| 0.000634 - 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 |
