| 資料庫語法 |
|---|
| 0.000483 - SET SQL_BIG_SELECTS = 1 |
| 0.000895 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '1') ORDER BY conf_order ASC |
| 0.000889 - SELECT sess_data, sess_ip FROM session WHERE sess_id = 'qtviij9v0os79qsubodqorte6e' |
| 0.001423 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '5') ORDER BY conf_order ASC |
| 0.000659 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '3') ORDER BY conf_order ASC |
| 0.001484 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3) |
| 0.001960 - 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,-1) AND b.bid IN (168,162,136,135,153,149,111,110,109,108,107,124,106,159,104,103,102,101,113,100,143,116,115,91,90,89,88,87,86,84,83,78,148,127,126,75,74,66,152,151,150,142,141,140,139,70,69,68,67,65,64,63,62,61,60,59,57,56,144,125,19,11,10,9,8,7,6,5,4,3,2,1,166,165,164,155,163,157,18,16,15,169,170,171,172,173,174,175,204,203,202,201,200,199,198,197,176,177,178,179,180,181,167,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,205,206,207,208,209,210,212,213) ORDER BY b.weight, m.block_id |
| 0.001986 - SELECT * FROM `tad_link_cate` WHERE `cate_sn` IN (1,2,3,4,7) ORDER BY `of_cate_sn`, `cate_sort` |
| 0.001915 - SELECT * FROM `tad_link` WHERE `cate_sn` ='1' AND `enable`='1' AND (`unable_date`='0000-00-00' OR `unable_date` >= '2026-08-28') ORDER BY `link_sort` |
| 0.000870 - SELECT * FROM `tad_link` WHERE `cate_sn` ='2' AND `enable`='1' AND (`unable_date`='0000-00-00' OR `unable_date` >= '2026-08-28') ORDER BY `link_sort` |
| 0.000833 - SELECT * FROM `tad_link` WHERE `cate_sn` ='3' AND `enable`='1' AND (`unable_date`='0000-00-00' OR `unable_date` >= '2026-08-28') ORDER BY `link_sort` |
| 0.000814 - SELECT * FROM `tad_link` WHERE `cate_sn` ='4' AND `enable`='1' AND (`unable_date`='0000-00-00' OR `unable_date` >= '2026-08-28') ORDER BY `link_sort` |
| 0.000751 - SELECT * FROM `tad_link` WHERE `cate_sn` ='7' AND `enable`='1' AND (`unable_date`='0000-00-00' OR `unable_date` >= '2026-08-28') ORDER BY `link_sort` |
| 0.000900 - 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` = 'tad_link_block_all.tpl') ORDER BY tpl_refid |
| 0.000958 - SELECT cfgname, cfgvalue FROM logcounterx_cfg |
| 0.000977 - DELETE FROM logcounterx_ip WHERE acctime < 1787887562 |
| 0.000732 - SELECT accip FROM logcounterx_ip WHERE accip = '216.73.217.179' |
| 0.000784 - UPDATE logcounterx_ip SET acctime = 1787888162 WHERE accip = '216.73.217.179' |
| 0.000833 - SELECT * FROM config WHERE (`conf_modid` = '16') ORDER BY conf_order ASC |
| 0.000996 - 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` = 'tad_login.tpl') ORDER BY tpl_refid |
| 0.000991 - 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.000998 - 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` = 'tad_honor_marquee.tpl') ORDER BY tpl_refid |
| 0.000778 - SELECT * FROM config WHERE (`conf_modid` = '21') ORDER BY conf_order ASC |
| 0.000696 - SELECT * FROM config WHERE (`conf_modid` = '4') ORDER BY conf_order ASC |
| 0.000684 - SELECT `tag_sn`, `font_color`, `color`, `tag` FROM `tad_news_tags` |
| 0.000836 - SELECT `ncsn`,`nc_title`,`enable_group`,`enable_post_group`,`cate_pic`,`setup` FROM `tad_news_cate` WHERE 1 AND `ncsn` in(1,3,30,11,33,10,27,31) AND `not_news`!='1' ORDER BY `sort` |
| 0.001411 - select * from tad_news where ncsn='1' and enable='1' and start_day < '2026-08-28 11:36:02' and (end_day > '2026-08-28 11:36:02' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc limit 0,10 |
| 0.000769 - SELECT * FROM users WHERE uid = '85' |
| 0.000652 - SELECT * FROM smiles |
| 0.000995 - SELECT * FROM users WHERE uid = '395' |
| 0.000886 - SELECT * FROM users WHERE uid = '372' |
| 0.002559 - select * from tad_news where ncsn='3' and enable='1' and start_day < '2026-08-28 11:36:02' and (end_day > '2026-08-28 11:36:02' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc limit 0,10 |
| 0.000760 - SELECT * FROM users WHERE uid = '406' |
| 0.002023 - select * from tad_news where ncsn='30' and enable='1' and start_day < '2026-08-28 11:36:02' and (end_day > '2026-08-28 11:36:02' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc limit 0,10 |
| 0.000804 - SELECT * FROM users WHERE uid = '412' |
| 0.000708 - SELECT * FROM users WHERE uid = '418' |
| 0.000858 - SELECT * FROM users WHERE uid = '103' |
| 0.004759 - select * from tad_news where ncsn='11' and enable='1' and start_day < '2026-08-28 11:36:02' and (end_day > '2026-08-28 11:36:02' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc limit 0,10 |
| 0.000766 - SELECT * FROM users WHERE uid = '430' |
| 0.001045 - select * from tad_news where ncsn='33' and enable='1' and start_day < '2026-08-28 11:36:02' and (end_day > '2026-08-28 11:36:02' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc limit 0,10 |
| 0.002152 - select * from tad_news where ncsn='10' and enable='1' and start_day < '2026-08-28 11:36:02' and (end_day > '2026-08-28 11:36:02' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc limit 0,10 |
| 0.001417 - SELECT * FROM users WHERE uid = '429' |
| 0.000806 - SELECT * FROM users WHERE uid = '426' |
| 0.000764 - SELECT * FROM users WHERE uid = '398' |
| 0.001073 - select * from tad_news where ncsn='27' and enable='1' and start_day < '2026-08-28 11:36:02' and (end_day > '2026-08-28 11:36:02' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc limit 0,10 |
| 0.007477 - select * from tad_news where ncsn='31' and enable='1' and start_day < '2026-08-28 11:36:02' and (end_day > '2026-08-28 11:36:02' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc limit 0,10 |
| 0.000916 - SELECT * FROM users WHERE uid = '396' |
| 0.000859 - SELECT * FROM `tad_news_cate` WHERE 1 and not_news!='1' and ncsn in(1,3,30,11,33,10,27,31) ORDER BY `sort` |
| 0.057306 - select * from tad_news where 1 and enable='1' and ncsn in(1,3,30,11,33,10,27,31) and start_day < '2026-08-28 11:36:02' and (end_day > '2026-08-28 11:36:02' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc |
| 0.016041 - select * from tad_news where 1 and enable='1' and ncsn in(1,3,30,11,33,10,27,31) and start_day < '2026-08-28 11:36:02' and (end_day > '2026-08-28 11:36:02' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc LIMIT 0, 10 |
| 0.000859 - SELECT `tag_sn`, `font_color`, `color`, `tag` FROM `tad_news_tags` |
| 0.002944 - desc `tadnews_data_center` `sort` |
| 0.000905 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
 where `mid`= '21' and `col_name`='nsn' and `col_sn`='4626' order by `sort` , `data_sort` |
| 0.000909 - SELECT * FROM `tadnews_files_center` where `col_name`='nsn' and `col_sn`='4626' order by sort |
| 0.000744 - SELECT * FROM `tad_news` WHERE `nsn` = 4626 |
| 0.000680 - SELECT `groupid`,`name` FROM `groups` |
| 0.000763 - SELECT * FROM `tadnews_files_center` WHERE `col_name`='news_pic' AND `col_sn`='4626' ORDER BY `sort` |
| 0.000623 - SELECT * FROM `tadnews_files_center` WHERE `col_name`='news_pic' AND `col_sn`='4626' ORDER BY `sort` |
| 0.001672 - desc `tadnews_data_center` `sort` |
| 0.000862 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
 where `mid`= '21' and `col_name`='nsn' and `col_sn`='4624' order by `sort` , `data_sort` |
| 0.000810 - SELECT * FROM `tadnews_files_center` where `col_name`='nsn' and `col_sn`='4624' order by sort |
| 0.000619 - SELECT * FROM `tad_news` WHERE `nsn` = 4624 |
| 0.000512 - SELECT `groupid`,`name` FROM `groups` |
| 0.000757 - SELECT * FROM `tadnews_files_center` WHERE `col_name`='news_pic' AND `col_sn`='4624' ORDER BY `sort` |
| 0.000618 - SELECT * FROM `tadnews_files_center` WHERE `col_name`='news_pic' AND `col_sn`='4624' ORDER BY `sort` |
| 0.001680 - desc `tadnews_data_center` `sort` |
| 0.000753 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
 where `mid`= '21' and `col_name`='nsn' and `col_sn`='4623' order by `sort` , `data_sort` |
| 0.000853 - SELECT * FROM `tadnews_files_center` where `col_name`='nsn' and `col_sn`='4623' order by sort |
| 0.000856 - SELECT * FROM `tad_news` WHERE `nsn` = 4623 |
| 0.000664 - SELECT `groupid`,`name` FROM `groups` |
| 0.000643 - SELECT * FROM `tadnews_files_center` WHERE `col_name`='news_pic' AND `col_sn`='4623' ORDER BY `sort` |
| 0.000667 - SELECT * FROM `tadnews_files_center` WHERE `col_name`='news_pic' AND `col_sn`='4623' ORDER BY `sort` |
| 0.001808 - desc `tadnews_data_center` `sort` |
| 0.000869 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
 where `mid`= '21' and `col_name`='nsn' and `col_sn`='4622' order by `sort` , `data_sort` |
| 0.000844 - SELECT * FROM `tadnews_files_center` where `col_name`='nsn' and `col_sn`='4622' order by sort |
| 0.000597 - SELECT * FROM `tad_news` WHERE `nsn` = 4622 |
| 0.000573 - SELECT `groupid`,`name` FROM `groups` |
| 0.000742 - SELECT * FROM `tadnews_files_center` WHERE `col_name`='news_pic' AND `col_sn`='4622' ORDER BY `sort` |
| 0.000924 - SELECT * FROM `tadnews_files_center` WHERE `col_name`='news_pic' AND `col_sn`='4622' ORDER BY `sort` |
| 0.001706 - desc `tadnews_data_center` `sort` |
| 0.000703 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
 where `mid`= '21' and `col_name`='nsn' and `col_sn`='4615' order by `sort` , `data_sort` |
| 0.000843 - SELECT * FROM `tadnews_files_center` where `col_name`='nsn' and `col_sn`='4615' order by sort |
| 0.000651 - SELECT * FROM `tad_news` WHERE `nsn` = 4615 |
| 0.000568 - SELECT `groupid`,`name` FROM `groups` |
| 0.000614 - SELECT * FROM `tadnews_files_center` WHERE `col_name`='news_pic' AND `col_sn`='4615' ORDER BY `sort` |
| 0.000721 - SELECT * FROM `tadnews_files_center` WHERE `col_name`='news_pic' AND `col_sn`='4615' ORDER BY `sort` |
| 0.001974 - desc `tadnews_data_center` `sort` |
| 0.000743 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
 where `mid`= '21' and `col_name`='nsn' and `col_sn`='4619' order by `sort` , `data_sort` |
| 0.000835 - SELECT * FROM `tadnews_files_center` where `col_name`='nsn' and `col_sn`='4619' order by sort |
| 0.000607 - SELECT * FROM `tad_news` WHERE `nsn` = 4619 |
| 0.000617 - SELECT `groupid`,`name` FROM `groups` |
| 0.000665 - SELECT * FROM `tadnews_files_center` WHERE `col_name`='news_pic' AND `col_sn`='4619' ORDER BY `sort` |
| 0.000566 - SELECT * FROM `tadnews_files_center` WHERE `col_name`='news_pic' AND `col_sn`='4619' ORDER BY `sort` |
| 0.001650 - desc `tadnews_data_center` `sort` |
| 0.000579 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
 where `mid`= '21' and `col_name`='nsn' and `col_sn`='4618' order by `sort` , `data_sort` |
| 0.000635 - SELECT * FROM `tadnews_files_center` where `col_name`='nsn' and `col_sn`='4618' order by sort |
| 0.000633 - SELECT * FROM `tad_news` WHERE `nsn` = 4618 |
| 0.000490 - SELECT `groupid`,`name` FROM `groups` |
| 0.000558 - SELECT * FROM `tadnews_files_center` WHERE `col_name`='news_pic' AND `col_sn`='4618' ORDER BY `sort` |
| 0.000625 - SELECT * FROM `tadnews_files_center` WHERE `col_name`='news_pic' AND `col_sn`='4618' ORDER BY `sort` |
| 0.001792 - desc `tadnews_data_center` `sort` |
| 0.000744 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
 where `mid`= '21' and `col_name`='nsn' and `col_sn`='4614' order by `sort` , `data_sort` |
| 0.000824 - SELECT * FROM `tadnews_files_center` where `col_name`='nsn' and `col_sn`='4614' order by sort |
| 0.000705 - SELECT * FROM `tad_news` WHERE `nsn` = 4614 |
| 0.000572 - SELECT `groupid`,`name` FROM `groups` |
| 0.000646 - SELECT * FROM `tadnews_files_center` WHERE `col_name`='news_pic' AND `col_sn`='4614' ORDER BY `sort` |
| 0.000741 - SELECT * FROM `tadnews_files_center` WHERE `col_name`='news_pic' AND `col_sn`='4614' ORDER BY `sort` |
| 0.001763 - desc `tadnews_data_center` `sort` |
| 0.000854 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
 where `mid`= '21' and `col_name`='nsn' and `col_sn`='4612' order by `sort` , `data_sort` |
| 0.001754 - SELECT * FROM `tadnews_files_center` where `col_name`='nsn' and `col_sn`='4612' order by sort |
| 0.000704 - SELECT * FROM `tad_news` WHERE `nsn` = 4612 |
| 0.000699 - SELECT `groupid`,`name` FROM `groups` |
| 0.000704 - SELECT * FROM `tadnews_files_center` WHERE `col_name`='news_pic' AND `col_sn`='4612' ORDER BY `sort` |
| 0.000767 - SELECT * FROM `tadnews_files_center` WHERE `col_name`='news_pic' AND `col_sn`='4612' ORDER BY `sort` |
| 0.001626 - desc `tadnews_data_center` `sort` |
| 0.000713 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
 where `mid`= '21' and `col_name`='nsn' and `col_sn`='4610' order by `sort` , `data_sort` |
| 0.000777 - SELECT * FROM `tadnews_files_center` where `col_name`='nsn' and `col_sn`='4610' order by sort |
| 0.000661 - SELECT * FROM `tad_news` WHERE `nsn` = 4610 |
| 0.000535 - SELECT `groupid`,`name` FROM `groups` |
| 0.000719 - SELECT * FROM `tadnews_files_center` WHERE `col_name`='news_pic' AND `col_sn`='4610' ORDER BY `sort` |
| 0.000656 - SELECT * FROM `tadnews_files_center` WHERE `col_name`='news_pic' AND `col_sn`='4610' ORDER BY `sort` |
| 0.001102 - 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_block_tab_news.tpl') ORDER BY tpl_refid |
| 0.000755 - SELECT * FROM config WHERE (`conf_modid` = '55') ORDER BY conf_order ASC |
| 0.001927 - desc `tad_lunch3_data_center` `sort` |
| 0.001321 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tad_lunch3_data_center`
 where `mid`= '55' and `col_name`='SchoolId' and `col_sn`='64736435' and `data_name`='2026-08-28' order by `sort` , `data_sort` |
| 0.001295 - delete from `tad_lunch3_data_center`
 where `mid`= '55' and `col_name`='SchoolId' and `col_sn`='64736435' and `data_name`='2026-08-28' and `data_sort`='0' |
| 0.000783 - REPLACE INTO `tad_lunch3_data_center`
 (`mid` , `col_name` , `col_sn` , `data_name` , `data_value` , `data_sort`, `col_id`, `sort`, `update_time`)
 values('55' , 'SchoolId' , '64736435' , '2026-08-28' , '當天不供餐,或尚無該日資訊!' , '0', '' , '0', now()) |
| 0.000935 - 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` = 'tad_lunch3_today.tpl') ORDER BY tpl_refid |
| 0.001581 - SELECT `conf_value` FROM `config` WHERE `conf_name` = 'allow_register' |
| 0.001106 - SELECT `mid`, `name`, `dirname` FROM `modules` WHERE `isactive` = 1 AND `hasmain` = 1 AND `weight` != 0 ORDER BY `weight` |
| 0.000726 - SELECT `conf_value` FROM `config` WHERE `conf_title` = '_MD_AM_DEBUGMODE' |
| 0.000838 - SELECT COUNT(*) FROM `priv_msgs` WHERE `to_userid` = 0 AND `read_msg`=0 GROUP BY `to_userid` |
| 0.001778 - SELECT `menuid`, `itemname`, `itemurl`, `target`, `icon`, `link_cate_name`,

 `link_cate_sn`, `read_group`, `of_level`, `status`

 FROM `tad_themes_menu`

 WHERE `status` = 1

 ORDER BY `of_level`, `position` |
| 0.000766 - SELECT `nsn`, `news_title` FROM `tad_news` WHERE `ncsn` = '9' ORDER BY `page_sort` |
| 0.000730 - 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_homepage.tpl') ORDER BY tpl_refid |
| 0.000749 - SELECT `tt_theme`,`tt_use_bootstrap`,`tt_bootstrap_color`,`tt_theme_kind` FROM `tadtools_setup` WHERE `tt_theme` = 'school2019' |