資料庫語法 |
---|
0.000168 - SET SQL_BIG_SELECTS = 1 |
0.001487 - SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC |
0.000227 - SELECT sess_data, sess_ip FROM session WHERE sess_id = '54mefnacal2va5pn8vlitm9755' |
0.000238 - SELECT * FROM modules WHERE dirname = 'tad_web' |
0.000660 - SELECT COUNT(*) FROM group_permission WHERE (gperm_modid = '1' AND (gperm_groupid = '3') AND gperm_name = 'module_read' AND gperm_itemid = '12') |
0.000753 - SELECT * FROM config WHERE (conf_modid = '12') ORDER BY conf_order ASC |
0.000387 - select * from tad_web where WebID='10' |
0.000370 - select `ConfigName`,`ConfigValue` from tad_web_config where `WebID`='10' |
0.000223 - update `tad_web` set `last_accessed`='2024-05-20 13:51:31' where `WebID`='10' |
0.000354 - select `ConfigName`,`ConfigValue` from tad_web_config where `WebID`='10' |
0.000218 - select `name`, `type`, `value` from tad_web_plugins_setup where `WebID`='10' and plugin='news' |
0.000238 - SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '5') ORDER BY conf_order ASC |
0.000291 - SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '3') ORDER BY conf_order ASC |
0.000925 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3) |
0.001073 - 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.000744 - 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.000673 - 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.000363 - select ncsn,of_ncsn,nc_title from tad_news_cate where not_news='1' and `ncsn`='30' |
0.004218 - select nsn,news_title from tad_news where ncsn='30' order by page_sort |
0.000342 - select ncsn,nc_title from tad_news_cate where of_ncsn='30' order by sort |
0.000948 - 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.000265 - 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.000169 - SELECT * FROM modules WHERE dirname = 'tad_uploader' |
0.000265 - 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.000246 - SELECT COUNT(*) FROM group_permission WHERE (gperm_modid = '14' AND (gperm_groupid = '3') AND gperm_name = 'catalog' AND gperm_itemid = '2') |
0.000243 - 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.000254 - SELECT COUNT(*) FROM group_permission WHERE (gperm_modid = '14' AND (gperm_groupid = '3') AND gperm_name = 'catalog' AND gperm_itemid = '2') |
0.000286 - 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.000133 - select * from tad_link_cate where cate_sn in(8) order by of_cate_sn,cate_sort |
0.000258 - select * from tad_link where `cate_sn` = '8' and `enable`='1' and (`unable_date`='0000-00-00' or `unable_date` >='2024-05-20') order by link_sort |
0.000361 - 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.000312 - 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 * from `tad_web_cate` where `WebID` = '10' and `ColName`='news' and `CateEnable`='1' order by CateSort |
0.000129 - select * from `tad_web_cate` where `CateID` = '178' |
0.000306 - 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' and a.`CateID`='178'
order by a.NewsDate desc |
0.000278 - 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' and a.`CateID`='178'
order by a.NewsDate desc LIMIT 0, 10 |
0.000158 - select `WebID`, `WebTitle` from tad_web order by WebSort |
0.000191 - 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.000094 - select `AssistantType`, `AssistantID` from `tad_web_cate_assistant` where `CateID`='178' |
0.000117 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='CateID' and col_sn='178' and power_name='read' |
0.000125 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='NewsID' and col_sn='4' and power_name='read' |
0.000336 - select `AssistantType`,`AssistantID` from `tad_web_assistant_post` where `ColName`='NewsID' and `ColSN`='4' and `CateID`='178' |
0.000137 - select * from tad_web_plugins where WebID='10' and PluginDirname='news' |
0.001157 - select * from tad_web_blocks where `WebID`='10' and `BlockEnable`='1' and `BlockPosition`='side' order by `BlockPosition`,`BlockSort` |
0.000223 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='BlockID' and col_sn='308' and power_name='read' |
0.000201 - SELECT `WebOwnerUid` FROM `tad_web` WHERE `WebID` = '10' |
0.000224 - SELECT `uid` FROM `tad_web_roles` WHERE `WebID` = '10' and `role` = 'admin' |
0.000251 - SELECT `uid`,`name`,`uname`,`email` FROM `users` WHERE `uid` in('1','10') |
0.000216 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='BlockID' and col_sn='312' and power_name='read' |
0.000406 - select ActionName,ActionID from tad_web_action where WebID='10' order by rand() |
0.000207 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='ActionID' and col_sn='35' and power_name='read' |
0.000432 - select * from `tad_web_files_center` where `col_name`='ActionID' and `col_sn`='35' order by sort |
0.000233 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='BlockID' and col_sn='322' and power_name='read' |
0.000334 - SELECT `CateName`, `CateID`
FROM `tad_web_cate`
WHERE `WebID` = '10' AND `ColName` = 'page' AND `CateEnable` = '1'
ORDER BY `CateSort` limit 0,40 |
0.000197 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='BlockID' and col_sn='324' and power_name='read' |
0.000201 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='BlockID' and col_sn='326' and power_name='read' |
0.001102 - SELECT * FROM tad_web WHERE WebEnable='1' ORDER BY CateID,WebSort |
0.000174 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='BlockID' and col_sn='328' and power_name='read' |
0.000138 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='BlockID' and col_sn='329' and power_name='read' |
0.000144 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='BlockID' and col_sn='330' and power_name='read' |
0.000121 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='BlockID' and col_sn='332' and power_name='read' |
0.000154 - select `name`, `type`, `value` from tad_web_plugins_setup where `WebID`='10' and plugin='aboutus' |
0.000120 - SELECT * FROM modules WHERE dirname = 'tad_login' |
0.000097 - select `tt_theme`,`tt_use_bootstrap`,`tt_bootstrap_color`,`tt_theme_kind` from `tadtools_setup` where `tt_theme`='for_tad_web_theme_2' |
0.000268 - 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 |