資料庫語法 |
---|
0.000145 - SET SQL_BIG_SELECTS = 1 |
0.001325 - SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC |
0.000225 - SELECT sess_data, sess_ip FROM session WHERE sess_id = '417f79e8uqiasp3aupohvtp2p0' |
0.000199 - SELECT * FROM modules WHERE dirname = 'tad_web' |
0.000280 - SELECT COUNT(*) FROM group_permission WHERE (gperm_modid = '1' AND (gperm_groupid = '3') AND gperm_name = 'module_read' AND gperm_itemid = '12') |
0.000283 - SELECT * FROM config WHERE (conf_modid = '12') ORDER BY conf_order ASC |
0.000214 - select * from tad_web where WebID='10' |
0.000274 - select `ConfigName`,`ConfigValue` from tad_web_config where `WebID`='10' |
0.000190 - update `tad_web` set `last_accessed`='2024-05-19 23:14:43' where `WebID`='10' |
0.000269 - select `ConfigName`,`ConfigValue` from tad_web_config where `WebID`='10' |
0.000165 - select `name`, `type`, `value` from tad_web_plugins_setup where `WebID`='10' and plugin='news' |
0.000180 - SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '5') ORDER BY conf_order ASC |
0.000229 - SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '3') ORDER BY conf_order ASC |
0.000709 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3) |
0.000880 - 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.000310 - 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.000319 - 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.000153 - select ncsn,of_ncsn,nc_title from tad_news_cate where not_news='1' and `ncsn`='30' |
0.002623 - select nsn,news_title from tad_news where ncsn='30' order by page_sort |
0.000128 - select ncsn,nc_title from tad_news_cate where of_ncsn='30' order by sort |
0.000402 - 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.000254 - 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.000138 - SELECT * FROM modules WHERE dirname = 'tad_uploader' |
0.000291 - SELECT COUNT(*) FROM group_permission WHERE (gperm_modid = '14' AND (gperm_groupid = '3') AND gperm_name = 'catalog' AND gperm_itemid = '2') |
0.000244 - SELECT COUNT(*) FROM group_permission WHERE (gperm_modid = '14' AND (gperm_groupid = '3') AND gperm_name = 'catalog' AND gperm_itemid = '2') |
0.000263 - SELECT COUNT(*) FROM group_permission WHERE (gperm_modid = '14' AND (gperm_groupid = '3') AND gperm_name = 'catalog' AND gperm_itemid = '2') |
0.000228 - SELECT COUNT(*) FROM group_permission WHERE (gperm_modid = '14' AND (gperm_groupid = '3') AND gperm_name = 'catalog' AND gperm_itemid = '2') |
0.000250 - 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.000282 - 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.000158 - select * from tad_link_cate where cate_sn in(8) order by of_cate_sn,cate_sort |
0.000259 - select * from tad_link where `cate_sn` = '8' and `enable`='1' and (`unable_date`='0000-00-00' or `unable_date` >='2024-05-19') order by link_sort |
0.000364 - 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.000317 - 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.000227 - select * from `tad_web_cate` where `WebID` = '10' and `ColName`='news' and `CateEnable`='1' order by CateSort |
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.000269 - 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, 10 |
0.000175 - select `WebID`, `WebTitle` from tad_web order by WebSort |
0.000189 - select count(*),CateID from `tad_web_news` where `WebID` = '10' group by CateID |
0.000198 - select * from `tad_web_cate` where 1 and `WebID` = '10' and `ColName`='news' order by CateSort |
0.000093 - select `AssistantType`, `AssistantID` from `tad_web_cate_assistant` where `CateID`='178' |
0.000127 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='CateID' and col_sn='178' and power_name='read' |
0.000137 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='NewsID' and col_sn='4' and power_name='read' |
0.000322 - select `AssistantType`,`AssistantID` from `tad_web_assistant_post` where `ColName`='NewsID' and `ColSN`='4' and `CateID`='178' |
0.000164 - select * from tad_web_plugins where WebID='10' and PluginDirname='news' |
0.000671 - select * from tad_web_blocks where `WebID`='10' and `BlockEnable`='1' and `BlockPosition`='side' order by `BlockPosition`,`BlockSort` |
0.000128 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='BlockID' and col_sn='308' and power_name='read' |
0.000122 - SELECT `WebOwnerUid` FROM `tad_web` WHERE `WebID` = '10' |
0.000158 - SELECT `uid` FROM `tad_web_roles` WHERE `WebID` = '10' and `role` = 'admin' |
0.000156 - SELECT `uid`,`name`,`uname`,`email` FROM `users` WHERE `uid` in('1','10') |
0.000130 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='BlockID' and col_sn='312' and power_name='read' |
0.000232 - select ActionName,ActionID from tad_web_action where WebID='10' order by rand() |
0.000125 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='ActionID' and col_sn='35' and power_name='read' |
0.000240 - select * from `tad_web_files_center` where `col_name`='ActionID' and `col_sn`='35' order by sort |
0.000138 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='BlockID' and col_sn='322' and power_name='read' |
0.000195 - SELECT `CateName`, `CateID`
FROM `tad_web_cate`
WHERE `WebID` = '10' AND `ColName` = 'page' AND `CateEnable` = '1'
ORDER BY `CateSort` limit 0,40 |
0.000116 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='BlockID' and col_sn='324' and power_name='read' |
0.000129 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='BlockID' and col_sn='326' and power_name='read' |
0.000562 - SELECT * FROM tad_web WHERE WebEnable='1' ORDER BY CateID,WebSort |
0.000137 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='BlockID' and col_sn='328' and power_name='read' |
0.000135 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='BlockID' and col_sn='329' and power_name='read' |
0.000133 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='BlockID' and col_sn='330' and power_name='read' |
0.000126 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='BlockID' and col_sn='332' and power_name='read' |
0.000168 - select `name`, `type`, `value` from tad_web_plugins_setup where `WebID`='10' and plugin='aboutus' |
0.000127 - SELECT * FROM modules WHERE dirname = 'tad_login' |
0.000127 - select `tt_theme`,`tt_use_bootstrap`,`tt_bootstrap_color`,`tt_theme_kind` from `tadtools_setup` where `tt_theme`='for_tad_web_theme_2' |
0.000247 - 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_tpl.tpl') ORDER BY tpl_refid |