資料庫語法 |
---|
0.000099 - SET SQL_BIG_SELECTS = 1 |
0.000976 - SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC |
0.000234 - SELECT sess_data, sess_ip FROM session WHERE sess_id = '959hb7lg3g3jsauvbq1u9njsa1' |
0.000289 - SELECT * FROM modules WHERE dirname = 'tad_web' |
0.000421 - SELECT COUNT(*) FROM group_permission WHERE (gperm_modid = '1' AND (gperm_groupid = '3') AND gperm_name = 'module_read' AND gperm_itemid = '12') |
0.000362 - SELECT * FROM config WHERE (conf_modid = '12') ORDER BY conf_order ASC |
0.000303 - select * from tad_web where WebID='10' |
0.000823 - select `ConfigName`,`ConfigValue` from tad_web_config where `WebID`='10' |
0.000476 - update `tad_web` set `last_accessed`='2024-05-12 20:26:00' where `WebID`='10' |
0.000373 - SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '5') ORDER BY conf_order ASC |
0.000444 - SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '3') ORDER BY conf_order ASC |
0.001350 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3) |
0.002816 - 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,12) AND b.bid IN (1,2,3,4,6,7,8,9,10,11,13,14,16,19,22,23,24,38,25,27,28,29,30,31,32,33,34,35,36,37,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,56,57,58,59,60,61,62,63,64,66,67,68,69,70,71,72,73,75,76,77,78,79,80,81,82,26,85) ORDER BY b.weight, m.block_id |
0.000999 - 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_search.tpl') ORDER BY tpl_refid |
0.000756 - 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_qrcode_block.tpl') ORDER BY tpl_refid |
0.000413 - select ncsn,of_ncsn,nc_title from tad_news_cate where not_news='1' and `ncsn`='30' |
0.005303 - select nsn,news_title from tad_news where ncsn='30' order by page_sort |
0.000167 - select ncsn,nc_title from tad_news_cate where of_ncsn='30' order by sort |
0.000442 - 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_page_list.tpl') ORDER BY tpl_refid |
0.000305 - select a.cfsn,a.cat_sn,a.cf_name,a.cf_desc,a.file_url from tad_uploader_file as a left join tad_uploader as b on a.cat_sn=b.cat_sn where b.cat_share='1' and b.cat_sn in(2) order by a.up_date desc limit 0,20 |
0.000158 - SELECT * FROM modules WHERE dirname = 'tad_uploader' |
0.000285 - SELECT COUNT(*) FROM group_permission WHERE (gperm_modid = '14' AND (gperm_groupid = '3') AND gperm_name = 'catalog' AND gperm_itemid = '2') |
0.000270 - SELECT COUNT(*) FROM group_permission WHERE (gperm_modid = '14' AND (gperm_groupid = '3') AND gperm_name = 'catalog' AND gperm_itemid = '2') |
0.000259 - SELECT COUNT(*) FROM group_permission WHERE (gperm_modid = '14' AND (gperm_groupid = '3') AND gperm_name = 'catalog' AND gperm_itemid = '2') |
0.000271 - SELECT COUNT(*) FROM group_permission WHERE (gperm_modid = '14' AND (gperm_groupid = '3') AND gperm_name = 'catalog' AND gperm_itemid = '2') |
0.000255 - SELECT COUNT(*) FROM group_permission WHERE (gperm_modid = '14' AND (gperm_groupid = '3') AND gperm_name = 'catalog' AND gperm_itemid = '2') |
0.000252 - SELECT COUNT(*) FROM group_permission WHERE (gperm_modid = '14' AND (gperm_groupid = '3') AND gperm_name = 'catalog' AND gperm_itemid = '2') |
0.000313 - 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_uploader_block_1.tpl') ORDER BY tpl_refid |
0.000173 - select * from tad_link_cate where cate_sn in(8) order by of_cate_sn,cate_sort |
0.000275 - select * from tad_link where `cate_sn` = '8' and `enable`='1' and (`unable_date`='0000-00-00' or `unable_date` >='2024-05-12') order by link_sort |
0.000409 - 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.000339 - 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.000228 - select `name`, `type`, `value` from tad_web_plugins_setup where `WebID`='10' and plugin='aboutus' |
0.000168 - select count(*) from tad_web_link_mems where WebID='10' order by MemNum |
0.000174 - select `name`, `type`, `value` from tad_web_plugins_setup where `WebID`='10' and plugin='action' |
0.000223 - select count(*) from tad_web_action where WebID='10' |
0.000172 - select `name`, `type`, `value` from tad_web_plugins_setup where `WebID`='10' and plugin='calendar' |
0.000180 - select count(*) from tad_web_calendar where WebID='10' |
0.000168 - select `name`, `type`, `value` from tad_web_plugins_setup where `WebID`='10' and plugin='aboutus' |
0.000163 - select `name`, `type`, `value` from tad_web_plugins_setup where `WebID`='10' and plugin='discuss' |
0.000231 - select count(*) from tad_web_discuss where WebID='10' |
0.000167 - select `name`, `type`, `value` from tad_web_plugins_setup where `WebID`='10' and plugin='homework' |
0.000156 - select `name`, `type`, `value` from tad_web_plugins_setup where `WebID`='10' and plugin='calendar' |
0.000123 - select count(*) from tad_web_homework where WebID='10' |
0.000165 - select `name`, `type`, `value` from tad_web_plugins_setup where `WebID`='10' and plugin='news' |
0.000188 - select count(*) from tad_web_news where WebID='10' and `NewsEnable`='1' |
0.000180 - select `name`, `type`, `value` from tad_web_plugins_setup where `WebID`='10' and plugin='page' |
0.000841 - select count(*) from tad_web_page where WebID='10' |
0.000377 - select count(*) from tad_web_schedule where WebID='10' |
0.000464 - select `name`, `type`, `value` from tad_web_plugins_setup where `WebID`='10' and plugin='works' |
0.000327 - select count(*) from tad_web_works where WebID='10' |
0.000601 - update tad_web set `WebCounter` = `WebCounter` +1 where WebID ='10' |
0.000845 - select * from tad_web_blocks where `WebID`='10' and `BlockEnable`='1' order by `BlockPosition`,`BlockSort` |
0.000198 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='BlockID' and col_sn='319' and power_name='read' |
0.000174 - select `name`, `type`, `value` from tad_web_plugins_setup where `WebID`='10' and plugin='news' |
0.000337 - select a.* from tad_web_news as a
left join tad_web as b on a.WebID=b.WebID
left join tad_web_cate as c on a.CateID=c.CateID
where b.`WebEnable`='1' and (c.CateEnable='1' or a.CateID='0') and a.`NewsEnable`='1' and a.WebID='10'
order by a.NewsDate desc |
0.000289 - select a.* from tad_web_news as a
left join tad_web as b on a.WebID=b.WebID
left join tad_web_cate as c on a.CateID=c.CateID
where b.`WebEnable`='1' and (c.CateEnable='1' or a.CateID='0') and a.`NewsEnable`='1' and a.WebID='10'
order by a.NewsDate desc LIMIT 0, 5 |
0.000162 - select `WebID`, `WebTitle` from tad_web order by WebSort |
0.000198 - select count(*),CateID from `tad_web_news` where `WebID` = '10' group by CateID |
0.000213 - select * from `tad_web_cate` where 1 and `WebID` = '10' and `ColName`='news' order by CateSort |
0.000096 - select `AssistantType`, `AssistantID` from `tad_web_cate_assistant` where `CateID`='178' |
0.000133 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='CateID' and col_sn='178' and power_name='read' |
0.000130 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='NewsID' and col_sn='4' and power_name='read' |
0.000323 - select `AssistantType`,`AssistantID` from `tad_web_assistant_post` where `ColName`='NewsID' and `ColSN`='4' and `CateID`='178' |
0.000136 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='BlockID' and col_sn='309' and power_name='read' |
0.000181 - select `name`, `type`, `value` from tad_web_plugins_setup where `WebID`='10' and plugin='aboutus' |
0.000142 - select * from `tad_web_cate` where `CateID` = '12' |
0.000165 - select * from `tad_web_files_center` where `col_name`='ClassPic' and `col_sn`='12' and `sort`='1' order by sort limit 0,1 |
0.000201 - select a.*,b.* from tad_web_link_mems as a left join tad_web_mems as b on a.MemID=b.MemID where a.WebID ='10' and a.MemEnable='1' and a.CateID='12' |
0.000120 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='BlockID' and col_sn='321' and power_name='read' |
0.000167 - select `name`, `type`, `value` from tad_web_plugins_setup where `WebID`='10' and plugin='page' |
0.000757 - select count(*),CateID from `tad_web_page` where `WebID` = '10' group by CateID |
0.000206 - select * from `tad_web_cate` where 1 and `WebID` = '10' and `ColName`='page' order by CateSort |
0.000775 - select a.* from tad_web_page as a
left join tad_web as b on a.WebID=b.WebID
left join tad_web_cate as c on a.CateID=c.CateID
where b.`WebEnable`='1' and (c.CateEnable='1' or a.CateID='0') and a.WebID='10'
order by a.PageSort |
0.000733 - select a.* from tad_web_page as a
left join tad_web as b on a.WebID=b.WebID
left join tad_web_cate as c on a.CateID=c.CateID
where b.`WebEnable`='1' and (c.CateEnable='1' or a.CateID='0') and a.WebID='10'
order by a.PageSort LIMIT 0, 20 |
0.000163 - select `WebID`, `WebTitle` from tad_web order by WebSort |
0.000136 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='BlockID' and col_sn='316' and power_name='read' |
0.000169 - select `name`, `type`, `value` from tad_web_plugins_setup where `WebID`='10' and plugin='homework' |
0.000448 - select `name`, `type`, `value` from tad_web_plugins_setup where `WebID`='10' and plugin='calendar' |
0.000580 - select a.* from tad_web_homework as a
left join tad_web as b on a.WebID=b.WebID
left join tad_web_cate as c on a.CateID=c.CateID
where b.`WebEnable`='1' and (c.CateEnable='1' or a.CateID='0') and a.HomeworkPostDate <= '2024-05-12 20:26:01' and a.WebID='10'
order by a.toCal desc |
0.000565 - select a.* from tad_web_homework as a
left join tad_web as b on a.WebID=b.WebID
left join tad_web_cate as c on a.CateID=c.CateID
where b.`WebEnable`='1' and (c.CateEnable='1' or a.CateID='0') and a.HomeworkPostDate <= '2024-05-12 20:26:01' and a.WebID='10'
order by a.toCal desc LIMIT 0, 5 |
0.000382 - select `WebID`, `WebTitle` from tad_web order by WebSort |
0.000407 - select `WebID`, `WebName` from tad_web order by WebSort |
0.000344 - select count(*),CateID from `tad_web_homework` where `WebID` = '10' group by CateID |
0.000509 - select * from `tad_web_cate` where 1 and `WebID` = '10' and `ColName`='homework' order by CateSort |
0.000329 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='BlockID' and col_sn='337' and power_name='read' |
0.001092 - select * from tad_web_video where WebID='10' order by rand() limit 0,1 |
0.000334 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='BlockID' and col_sn='340' and power_name='read' |
0.000409 - select `name`, `type`, `value` from tad_web_plugins_setup where `WebID`='10' and plugin='works' |
0.001117 - select a.* from tad_web_works as a
left join tad_web as b on a.WebID=b.WebID
left join tad_web_cate as c on a.CateID=c.CateID
where b.`WebEnable`='1' and (c.CateEnable='1' or a.CateID='0') and a.WebID='10' and ((a.WorksKind ='mem_after_end' and a.WorksDate < '2024-05-12 20:26:01') or a.WorksKind!='mem_after_end') order by rand() |
0.000510 - select a.* from tad_web_works as a
left join tad_web as b on a.WebID=b.WebID
left join tad_web_cate as c on a.CateID=c.CateID
where b.`WebEnable`='1' and (c.CateEnable='1' or a.CateID='0') and a.WebID='10' and ((a.WorksKind ='mem_after_end' and a.WorksDate < '2024-05-12 20:26:01') or a.WorksKind!='mem_after_end') order by rand() LIMIT 0, 1 |
0.000171 - select `WebID`, `WebTitle` from tad_web order by WebSort |
0.000155 - select count(*),CateID from `tad_web_works` where `WebID` = '10' group by CateID |
0.000233 - select * from `tad_web_cate` where 1 and `WebID` = '10' and `ColName`='works' order by CateSort |
0.000143 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='BlockID' and col_sn='338' and power_name='read' |
0.000168 - select * from tad_web_video where WebID='10' order by VideoDate desc , VideoID desc limit 0,1 |
0.000131 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='BlockID' and col_sn='341' and power_name='read' |
0.000185 - select `name`, `type`, `value` from tad_web_plugins_setup where `WebID`='10' and plugin='works' |
0.000243 - select a.* from tad_web_works as a
left join tad_web as b on a.WebID=b.WebID
left join tad_web_cate as c on a.CateID=c.CateID
where b.`WebEnable`='1' and (c.CateEnable='1' or a.CateID='0') and a.WebID='10' and ((a.WorksKind ='mem_after_end' and a.WorksDate < '2024-05-12 20:26:01') or a.WorksKind!='mem_after_end') order by WorksDate desc |
0.000245 - select a.* from tad_web_works as a
left join tad_web as b on a.WebID=b.WebID
left join tad_web_cate as c on a.CateID=c.CateID
where b.`WebEnable`='1' and (c.CateEnable='1' or a.CateID='0') and a.WebID='10' and ((a.WorksKind ='mem_after_end' and a.WorksDate < '2024-05-12 20:26:01') or a.WorksKind!='mem_after_end') order by WorksDate desc LIMIT 0, 1 |
0.000171 - select `WebID`, `WebTitle` from tad_web order by WebSort |
0.000149 - select count(*),CateID from `tad_web_works` where `WebID` = '10' group by CateID |
0.000209 - select * from `tad_web_cate` where 1 and `WebID` = '10' and `ColName`='works' order by CateSort |
0.000147 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='BlockID' and col_sn='311' and power_name='read' |
0.000184 - select `name`, `type`, `value` from tad_web_plugins_setup where `WebID`='10' and plugin='action' |
0.000350 - select a.* from tad_web_action as a
left join tad_web as b on a.WebID=b.WebID
left join tad_web_cate as c on a.CateID=c.CateID
where b.`WebEnable`='1' and (c.CateEnable='1' or a.CateID='0') and a.WebID='10'
order by a.ActionID desc |
0.000350 - select a.* from tad_web_action as a
left join tad_web as b on a.WebID=b.WebID
left join tad_web_cate as c on a.CateID=c.CateID
where b.`WebEnable`='1' and (c.CateEnable='1' or a.CateID='0') and a.WebID='10'
order by a.ActionID desc LIMIT 0, 10 |
0.000161 - select `WebID`, `WebTitle` from tad_web order by WebSort |
0.000242 - select count(*),CateID from `tad_web_action` where `WebID` = '10' group by CateID |
0.000232 - select * from `tad_web_cate` where 1 and `WebID` = '10' and `ColName`='action' order by CateSort |
0.000102 - select `AssistantType`, `AssistantID` from `tad_web_cate_assistant` where `CateID`='149' |
0.000122 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='CateID' and col_sn='149' and power_name='read' |
0.000143 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='ActionID' and col_sn='35' and power_name='read' |
0.000387 - select `AssistantType`,`AssistantID` from `tad_web_assistant_post` where `ColName`='ActionID' and `ColSN`='35' and `CateID`='149' |
0.000282 - select * from `tad_web_files_center` where `col_name`='ActionID' and `col_sn`='35' order by sort limit 0,1 |
0.000166 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='BlockID' and col_sn='313' and power_name='read' |
0.000180 - select `name`, `type`, `value` from tad_web_plugins_setup where `WebID`='10' and plugin='calendar' |
0.000158 - select count(*) from tad_web_calendar where WebID='10' |
0.000132 - select count(*) from tad_web_homework where WebID='10' |
0.000170 - select count(*) from tad_web_news where WebID='10' and toCal!='0000-00-00 00:00:00' |
0.000119 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='BlockID' and col_sn='314' and power_name='read' |
0.000152 - select `name`, `type`, `value` from tad_web_plugins_setup where `WebID`='10' and plugin='aboutus' |
0.000240 - select `name`, `type`, `value` from tad_web_plugins_setup where `WebID`='10' and plugin='discuss' |
0.000375 - select a.* from tad_web_discuss as a
left join tad_web as b on a.WebID=b.WebID
left join tad_web_cate as c on a.CateID=c.CateID
where b.`WebEnable`='1' and (c.CateEnable='1' or a.CateID='0') and a.ReDiscussID='0' and a.WebID='10'
order by a.LastTime desc |
0.000353 - select a.* from tad_web_discuss as a
left join tad_web as b on a.WebID=b.WebID
left join tad_web_cate as c on a.CateID=c.CateID
where b.`WebEnable`='1' and (c.CateEnable='1' or a.CateID='0') and a.ReDiscussID='0' and a.WebID='10'
order by a.LastTime desc LIMIT 0, 5 |
0.000147 - select `WebID`, `WebTitle` from tad_web order by WebSort |
0.000226 - select count(*),CateID from `tad_web_discuss` where `WebID` = '10' group by CateID |
0.000177 - select * from `tad_web_cate` where 1 and `WebID` = '10' and `ColName`='discuss' order by CateSort |
0.000121 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='BlockID' and col_sn='315' and power_name='read' |
0.000321 - select a.* , b.files_sn, b.col_name, b.col_sn, b.sort, b.kind, b.file_name, b.file_type, b.file_size, b.description, b.counter, b.original_filename, b.hash_filename, b.sub_dir from tad_web_files as a
left join tad_web_files_center as b on a.fsn=b.col_sn and b.col_name='fsn'
left join tad_web as c on a.WebID=c.WebID
left join tad_web_cate as d on a.CateID=d.CateID
where c.`WebEnable`='1' and (d.CateEnable='1' or a.CateID='0') and a.WebID='10'
order by a.file_date desc |
0.000310 - select a.* , b.files_sn, b.col_name, b.col_sn, b.sort, b.kind, b.file_name, b.file_type, b.file_size, b.description, b.counter, b.original_filename, b.hash_filename, b.sub_dir from tad_web_files as a
left join tad_web_files_center as b on a.fsn=b.col_sn and b.col_name='fsn'
left join tad_web as c on a.WebID=c.WebID
left join tad_web_cate as d on a.CateID=d.CateID
where c.`WebEnable`='1' and (d.CateEnable='1' or a.CateID='0') and a.WebID='10'
order by a.file_date desc LIMIT 0, 5 |
0.000144 - select `WebID`, `WebTitle` from tad_web order by WebSort |
0.000136 - select count(*),CateID from `tad_web_files` where `WebID` = '10' group by CateID |
0.000184 - select * from `tad_web_cate` where 1 and `WebID` = '10' and `ColName`='files' order by CateSort |
0.000144 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='BlockID' and col_sn='317' and power_name='read' |
0.000259 - select a.* from tad_web_link as a
left join tad_web as b on a.WebID=b.WebID
left join tad_web_cate as c on a.CateID=c.CateID
where b.`WebEnable`='1' and (c.CateEnable='1' or a.CateID='0') and a.WebID='10'
order by a.LinkSort, a.LinkID desc |
0.000234 - select a.* from tad_web_link as a
left join tad_web as b on a.WebID=b.WebID
left join tad_web_cate as c on a.CateID=c.CateID
where b.`WebEnable`='1' and (c.CateEnable='1' or a.CateID='0') and a.WebID='10'
order by a.LinkSort, a.LinkID desc LIMIT 0, 5 |
0.000144 - select `WebID`, `WebTitle` from tad_web order by WebSort |
0.000164 - select count(*),CateID from `tad_web_link` where `WebID` = '10' group by CateID |
0.000193 - select * from `tad_web_cate` where 1 and `WebID` = '10' and `ColName`='link' order by CateSort |
0.000116 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='BlockID' and col_sn='318' and power_name='read' |
0.000163 - select `name`, `type`, `value` from tad_web_plugins_setup where `WebID`='10' and plugin='menu' |
0.000155 - select count(*),CateID from `tad_web_menu` where `WebID` = '10' group by CateID |
0.000172 - select * from `tad_web_cate` where 1 and `WebID` = '10' and `ColName`='menu' order by CateSort |
0.000182 - select a.* from tad_web_menu as a
left join tad_web as b on a.WebID=b.WebID
left join tad_web_cate as c on a.CateID=c.CateID
where b.`WebEnable`='1' and c.CateEnable='1' and a.WebID='10'
order by a.Sort |
0.000130 - select `WebID`, `WebTitle` from tad_web order by WebSort |
0.000131 - select count(*),CateID from `tad_web_menu` where `WebID` = '10' group by CateID |
0.000192 - select * from `tad_web_cate` where 1 and `WebID` = '10' and `ColName`='menu' order by CateSort |
0.000124 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='BlockID' and col_sn='323' and power_name='read' |
0.000223 - select a.* from tad_web_schedule as a
left join tad_web as b on a.WebID=b.WebID
left join tad_web_cate as c on a.CateID=c.CateID
where b.`WebEnable`='1' and (c.CateEnable='1' or a.CateID='0') and a.WebID='10' order by a.ScheduleDisplay desc, b.WebSort |
0.000143 - select `WebID`, `WebTitle` from tad_web order by WebSort |
0.000131 - select count(*),CateID from `tad_web_schedule` where `WebID` = '10' group by CateID |
0.000189 - select * from `tad_web_cate` where 1 and `WebID` = '10' and `ColName`='schedule' order by CateSort |
0.000137 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='BlockID' and col_sn='336' and power_name='read' |
0.000158 - select `name`, `type`, `value` from tad_web_plugins_setup where `WebID`='10' and plugin='video' |
0.000209 - select a.* from tad_web_video as a
left join tad_web as b on a.WebID=b.WebID
left join tad_web_cate as c on a.CateID=c.CateID
where b.`WebEnable`='1' and (c.CateEnable='1' or a.CateID='0') and a.WebID='10'
order by a.VideoDate desc , a.VideoID desc |
0.000209 - select a.* from tad_web_video as a
left join tad_web as b on a.WebID=b.WebID
left join tad_web_cate as c on a.CateID=c.CateID
where b.`WebEnable`='1' and (c.CateEnable='1' or a.CateID='0') and a.WebID='10'
order by a.VideoDate desc , a.VideoID desc LIMIT 0, 5 |
0.000146 - select `WebID`, `WebTitle` from tad_web order by WebSort |
0.000142 - select count(*),CateID from `tad_web_video` where `WebID` = '10' group by CateID |
0.000175 - select * from `tad_web_cate` where 1 and `WebID` = '10' and `ColName`='video' order by CateSort |
0.000114 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='BlockID' and col_sn='339' and power_name='read' |
0.000158 - select `name`, `type`, `value` from tad_web_plugins_setup where `WebID`='10' and plugin='works' |
0.000201 - select a.* from tad_web_works as a
left join tad_web as b on a.WebID=b.WebID
left join tad_web_cate as c on a.CateID=c.CateID
where b.`WebEnable`='1' and (c.CateEnable='1' or a.CateID='0') and a.WebID='10' and ((a.WorksKind ='mem_after_end' and a.WorksDate < '2024-05-12 20:26:01') or a.WorksKind!='mem_after_end') order by a.WorksDate desc |
0.000223 - select a.* from tad_web_works as a
left join tad_web as b on a.WebID=b.WebID
left join tad_web_cate as c on a.CateID=c.CateID
where b.`WebEnable`='1' and (c.CateEnable='1' or a.CateID='0') and a.WebID='10' and ((a.WorksKind ='mem_after_end' and a.WorksDate < '2024-05-12 20:26:01') or a.WorksKind!='mem_after_end') order by a.WorksDate desc LIMIT 0, 5 |
0.000131 - select `WebID`, `WebTitle` from tad_web order by WebSort |
0.000134 - select count(*),CateID from `tad_web_works` where `WebID` = '10' group by CateID |
0.000171 - select * from `tad_web_cate` where 1 and `WebID` = '10' and `ColName`='works' order by CateSort |
0.000120 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='BlockID' and col_sn='308' and power_name='read' |
0.000113 - SELECT `WebOwnerUid` FROM `tad_web` WHERE `WebID` = '10' |
0.000150 - SELECT `uid` FROM `tad_web_roles` WHERE `WebID` = '10' and `role` = 'admin' |
0.000161 - SELECT `uid`,`name`,`uname`,`email` FROM `users` WHERE `uid` in('1','10') |
0.000117 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='BlockID' and col_sn='312' and power_name='read' |
0.000221 - select ActionName,ActionID from tad_web_action where WebID='10' order by rand() |
0.000122 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='ActionID' and col_sn='35' and power_name='read' |
0.000235 - select * from `tad_web_files_center` where `col_name`='ActionID' and `col_sn`='35' order by sort |
0.000125 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='BlockID' and col_sn='322' and power_name='read' |
0.000179 - SELECT `CateName`, `CateID`
FROM `tad_web_cate`
WHERE `WebID` = '10' AND `ColName` = 'page' AND `CateEnable` = '1'
ORDER BY `CateSort` limit 0,40 |
0.000108 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='BlockID' and col_sn='324' and power_name='read' |
0.000112 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='BlockID' and col_sn='326' and power_name='read' |
0.000539 - SELECT * FROM tad_web WHERE WebEnable='1' ORDER BY CateID,WebSort |
0.000131 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='BlockID' and col_sn='328' and power_name='read' |
0.000128 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='BlockID' and col_sn='329' and power_name='read' |
0.000124 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='BlockID' and col_sn='330' and power_name='read' |
0.000116 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='BlockID' and col_sn='332' and power_name='read' |
0.000165 - select `name`, `type`, `value` from tad_web_plugins_setup where `WebID`='10' and plugin='aboutus' |
0.000130 - SELECT * FROM modules WHERE dirname = 'tad_login' |
0.000118 - select `tt_theme`,`tt_use_bootstrap`,`tt_bootstrap_color`,`tt_theme_kind` from `tadtools_setup` where `tt_theme`='for_tad_web_theme_2' |
0.000263 - 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_web_index.tpl') ORDER BY tpl_refid |