| 資料庫語法 |
|---|
| 0.000517 - SET SQL_BIG_SELECTS = 1 |
| 0.000824 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '1') ORDER BY conf_order ASC |
| 0.000903 - SELECT sess_data, sess_ip FROM session WHERE sess_id = 'i5ik0f2139r6tefhtr3hlo3niq' |
| 0.001297 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '5') ORDER BY conf_order ASC |
| 0.001017 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '3') ORDER BY conf_order ASC |
| 0.001798 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3) |
| 0.002137 - 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.001853 - SELECT * FROM `tad_link_cate` WHERE `cate_sn` IN (1,2,3,4,7) ORDER BY `of_cate_sn`, `cate_sort` |
| 0.001877 - 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.000957 - 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.000807 - 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.000783 - 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.000764 - 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.002438 - 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.001105 - SELECT cfgname, cfgvalue FROM logcounterx_cfg |
| 0.000972 - DELETE FROM logcounterx_ip WHERE acctime < 1787884595 |
| 0.000669 - SELECT accip FROM logcounterx_ip WHERE accip = '216.73.217.179' |
| 0.000837 - INSERT INTO logcounterx_ip (accip, acctime) VALUES ('216.73.217.179', 1787885195) |
| 0.000828 - UPDATE logcounterx_count SET cnt = (cnt + 1), robot = (robot + 1) WHERE ymd = '1111-11-11' |
| 0.000740 - SELECT cnt FROM logcounterx_count WHERE ymd = '2026/08/28' |
| 0.000654 - UPDATE logcounterx_count SET cnt = (cnt + 1), robot = (robot + 1) WHERE ymd = '2026/08/28' |
| 0.000722 - UPDATE logcounterx_hours SET cnt = (cnt + 1), robot = (robot + 1) WHERE hour = '10' |
| 0.000797 - SELECT cnt FROM logcounterx_count WHERE ymd = '1111-11-11' |
| 0.000711 - INSERT INTO logcounterx_log (remote_host, user_agent, path_info, referer, acccnt, uname, accday, acctime, accwday) VALUES ('', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '/', '', 1742464, '', '2026-08-28', '10:46:35', '5') |
| 0.012286 - SELECT MAX(acccnt), COUNT(recid) FROM logcounterx_log |
| 0.000780 - SELECT * FROM config WHERE (`conf_modid` = '16') ORDER BY conf_order ASC |
| 0.001049 - 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.000918 - 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.001091 - 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.000904 - SELECT * FROM config WHERE (`conf_modid` = '21') ORDER BY conf_order ASC |
| 0.000613 - SELECT * FROM config WHERE (`conf_modid` = '4') ORDER BY conf_order ASC |
| 0.000635 - SELECT `tag_sn`, `font_color`, `color`, `tag` FROM `tad_news_tags` |
| 0.000773 - 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.001311 - select * from tad_news where ncsn='1' and enable='1' and start_day < '2026-08-28 10:46:35' and (end_day > '2026-08-28 10:46:35' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc limit 0,10 |
| 0.000655 - SELECT * FROM users WHERE uid = '85' |
| 0.000856 - SELECT * FROM smiles |
| 0.000825 - SELECT * FROM users WHERE uid = '395' |
| 0.000731 - SELECT * FROM users WHERE uid = '372' |
| 0.002599 - select * from tad_news where ncsn='3' and enable='1' and start_day < '2026-08-28 10:46:35' and (end_day > '2026-08-28 10:46:35' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc limit 0,10 |
| 0.000826 - SELECT * FROM users WHERE uid = '406' |
| 0.002232 - select * from tad_news where ncsn='30' and enable='1' and start_day < '2026-08-28 10:46:35' and (end_day > '2026-08-28 10:46:35' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc limit 0,10 |
| 0.000995 - SELECT * FROM users WHERE uid = '412' |
| 0.000987 - SELECT * FROM users WHERE uid = '418' |
| 0.000834 - SELECT * FROM users WHERE uid = '103' |
| 0.005243 - select * from tad_news where ncsn='11' and enable='1' and start_day < '2026-08-28 10:46:35' and (end_day > '2026-08-28 10:46:35' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc limit 0,10 |
| 0.000674 - SELECT * FROM users WHERE uid = '430' |
| 0.001403 - select * from tad_news where ncsn='33' and enable='1' and start_day < '2026-08-28 10:46:35' and (end_day > '2026-08-28 10:46:35' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc limit 0,10 |
| 0.002249 - select * from tad_news where ncsn='10' and enable='1' and start_day < '2026-08-28 10:46:35' and (end_day > '2026-08-28 10:46:35' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc limit 0,10 |
| 0.000829 - SELECT * FROM users WHERE uid = '429' |
| 0.000785 - SELECT * FROM users WHERE uid = '426' |
| 0.000689 - SELECT * FROM users WHERE uid = '398' |
| 0.001096 - select * from tad_news where ncsn='27' and enable='1' and start_day < '2026-08-28 10:46:35' and (end_day > '2026-08-28 10:46:35' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc limit 0,10 |
| 0.004948 - select * from tad_news where ncsn='31' and enable='1' and start_day < '2026-08-28 10:46:35' and (end_day > '2026-08-28 10:46:35' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc limit 0,10 |
| 0.000711 - SELECT * FROM users WHERE uid = '396' |
| 0.000665 - 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.057197 - 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 10:46:35' and (end_day > '2026-08-28 10:46:35' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc |
| 0.020593 - 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 10:46:35' and (end_day > '2026-08-28 10:46:35' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc LIMIT 0, 10 |
| 0.000766 - SELECT `tag_sn`, `font_color`, `color`, `tag` FROM `tad_news_tags` |
| 0.002085 - desc `tadnews_data_center` `sort` |
| 0.000807 - 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.001029 - SELECT * FROM `tadnews_files_center` where `col_name`='nsn' and `col_sn`='4626' order by sort |
| 0.000868 - SELECT * FROM `tad_news` WHERE `nsn` = 4626 |
| 0.001016 - SELECT `groupid`,`name` FROM `groups` |
| 0.000774 - SELECT * FROM `tadnews_files_center` WHERE `col_name`='news_pic' AND `col_sn`='4626' ORDER BY `sort` |
| 0.000625 - SELECT * FROM `tadnews_files_center` WHERE `col_name`='news_pic' AND `col_sn`='4626' ORDER BY `sort` |
| 0.001779 - desc `tadnews_data_center` `sort` |
| 0.001318 - 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.000767 - SELECT * FROM `tadnews_files_center` where `col_name`='nsn' and `col_sn`='4624' order by sort |
| 0.000651 - SELECT * FROM `tad_news` WHERE `nsn` = 4624 |
| 0.000664 - SELECT `groupid`,`name` FROM `groups` |
| 0.000627 - SELECT * FROM `tadnews_files_center` WHERE `col_name`='news_pic' AND `col_sn`='4624' ORDER BY `sort` |
| 0.000783 - SELECT * FROM `tadnews_files_center` WHERE `col_name`='news_pic' AND `col_sn`='4624' ORDER BY `sort` |
| 0.001744 - desc `tadnews_data_center` `sort` |
| 0.000712 - 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.000805 - SELECT * FROM `tadnews_files_center` where `col_name`='nsn' and `col_sn`='4623' order by sort |
| 0.000623 - SELECT * FROM `tad_news` WHERE `nsn` = 4623 |
| 0.000583 - SELECT `groupid`,`name` FROM `groups` |
| 0.000650 - SELECT * FROM `tadnews_files_center` WHERE `col_name`='news_pic' AND `col_sn`='4623' ORDER BY `sort` |
| 0.000595 - SELECT * FROM `tadnews_files_center` WHERE `col_name`='news_pic' AND `col_sn`='4623' ORDER BY `sort` |
| 0.001532 - desc `tadnews_data_center` `sort` |
| 0.000700 - 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.000980 - SELECT * FROM `tadnews_files_center` where `col_name`='nsn' and `col_sn`='4622' order by sort |
| 0.000655 - SELECT * FROM `tad_news` WHERE `nsn` = 4622 |
| 0.000576 - SELECT `groupid`,`name` FROM `groups` |
| 0.000621 - SELECT * FROM `tadnews_files_center` WHERE `col_name`='news_pic' AND `col_sn`='4622' ORDER BY `sort` |
| 0.000687 - SELECT * FROM `tadnews_files_center` WHERE `col_name`='news_pic' AND `col_sn`='4622' ORDER BY `sort` |
| 0.001625 - desc `tadnews_data_center` `sort` |
| 0.000795 - 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.000890 - SELECT * FROM `tadnews_files_center` where `col_name`='nsn' and `col_sn`='4615' order by sort |
| 0.000648 - SELECT * FROM `tad_news` WHERE `nsn` = 4615 |
| 0.000577 - SELECT `groupid`,`name` FROM `groups` |
| 0.000645 - SELECT * FROM `tadnews_files_center` WHERE `col_name`='news_pic' AND `col_sn`='4615' ORDER BY `sort` |
| 0.000647 - SELECT * FROM `tadnews_files_center` WHERE `col_name`='news_pic' AND `col_sn`='4615' ORDER BY `sort` |
| 0.001661 - desc `tadnews_data_center` `sort` |
| 0.000728 - 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.000809 - SELECT * FROM `tadnews_files_center` where `col_name`='nsn' and `col_sn`='4619' order by sort |
| 0.000723 - SELECT * FROM `tad_news` WHERE `nsn` = 4619 |
| 0.000723 - SELECT `groupid`,`name` FROM `groups` |
| 0.000823 - SELECT * FROM `tadnews_files_center` WHERE `col_name`='news_pic' AND `col_sn`='4619' ORDER BY `sort` |
| 0.000707 - SELECT * FROM `tadnews_files_center` WHERE `col_name`='news_pic' AND `col_sn`='4619' ORDER BY `sort` |
| 0.001759 - desc `tadnews_data_center` `sort` |
| 0.000741 - 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.000773 - SELECT * FROM `tadnews_files_center` where `col_name`='nsn' and `col_sn`='4618' order by sort |
| 0.000686 - SELECT * FROM `tad_news` WHERE `nsn` = 4618 |
| 0.000648 - SELECT `groupid`,`name` FROM `groups` |
| 0.000718 - SELECT * FROM `tadnews_files_center` WHERE `col_name`='news_pic' AND `col_sn`='4618' ORDER BY `sort` |
| 0.000604 - SELECT * FROM `tadnews_files_center` WHERE `col_name`='news_pic' AND `col_sn`='4618' ORDER BY `sort` |
| 0.001659 - desc `tadnews_data_center` `sort` |
| 0.000599 - 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.000719 - SELECT * FROM `tadnews_files_center` where `col_name`='nsn' and `col_sn`='4614' order by sort |
| 0.000673 - SELECT * FROM `tad_news` WHERE `nsn` = 4614 |
| 0.000644 - SELECT `groupid`,`name` FROM `groups` |
| 0.000742 - SELECT * FROM `tadnews_files_center` WHERE `col_name`='news_pic' AND `col_sn`='4614' ORDER BY `sort` |
| 0.000605 - SELECT * FROM `tadnews_files_center` WHERE `col_name`='news_pic' AND `col_sn`='4614' ORDER BY `sort` |
| 0.001539 - desc `tadnews_data_center` `sort` |
| 0.000726 - 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.000839 - SELECT * FROM `tadnews_files_center` where `col_name`='nsn' and `col_sn`='4612' order by sort |
| 0.000676 - SELECT * FROM `tad_news` WHERE `nsn` = 4612 |
| 0.000618 - SELECT `groupid`,`name` FROM `groups` |
| 0.000671 - SELECT * FROM `tadnews_files_center` WHERE `col_name`='news_pic' AND `col_sn`='4612' ORDER BY `sort` |
| 0.000644 - SELECT * FROM `tadnews_files_center` WHERE `col_name`='news_pic' AND `col_sn`='4612' ORDER BY `sort` |
| 0.001859 - desc `tadnews_data_center` `sort` |
| 0.000733 - 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.000766 - SELECT * FROM `tadnews_files_center` where `col_name`='nsn' and `col_sn`='4610' order by sort |
| 0.000704 - SELECT * FROM `tad_news` WHERE `nsn` = 4610 |
| 0.000744 - SELECT `groupid`,`name` FROM `groups` |
| 0.000646 - SELECT * FROM `tadnews_files_center` WHERE `col_name`='news_pic' AND `col_sn`='4610' ORDER BY `sort` |
| 0.000553 - SELECT * FROM `tadnews_files_center` WHERE `col_name`='news_pic' AND `col_sn`='4610' ORDER BY `sort` |
| 0.001242 - 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.000965 - SELECT * FROM config WHERE (`conf_modid` = '55') ORDER BY conf_order ASC |
| 0.002249 - desc `tad_lunch3_data_center` `sort` |
| 0.001301 - 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.001247 - 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.000935 - 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.001286 - 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.001426 - SELECT `conf_value` FROM `config` WHERE `conf_name` = 'allow_register' |
| 0.001025 - SELECT `mid`, `name`, `dirname` FROM `modules` WHERE `isactive` = 1 AND `hasmain` = 1 AND `weight` != 0 ORDER BY `weight` |
| 0.000821 - SELECT `conf_value` FROM `config` WHERE `conf_title` = '_MD_AM_DEBUGMODE' |
| 0.000783 - SELECT COUNT(*) FROM `priv_msgs` WHERE `to_userid` = 0 AND `read_msg`=0 GROUP BY `to_userid` |
| 0.001716 - 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.000761 - SELECT `nsn`, `news_title` FROM `tad_news` WHERE `ncsn` = '9' ORDER BY `page_sort` |
| 0.000963 - 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.001193 - SELECT `tt_theme`,`tt_use_bootstrap`,`tt_bootstrap_color`,`tt_theme_kind` FROM `tadtools_setup` WHERE `tt_theme` = 'school2019' |