資料庫語法 |
---|
0.000220 - SET SQL_BIG_SELECTS = 1 |
0.001663 - SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC |
0.000413 - SELECT sess_data, sess_ip FROM session WHERE sess_id = 'm3d65tpqoqoqhum3fo2a2v81v7' |
0.000417 - SELECT * FROM modules WHERE dirname = 'tad_web' |
0.000266 - SELECT COUNT(*) FROM group_permission WHERE (gperm_modid = '1' AND (gperm_groupid = '3') AND gperm_name = 'module_read' AND gperm_itemid = '12') |
0.000305 - SELECT * FROM config WHERE (conf_modid = '12') ORDER BY conf_order ASC |
0.000163 - select * from tad_web where WebID='10' |
0.000270 - select `ConfigName`,`ConfigValue` from tad_web_config where `WebID`='10' |
0.000179 - update `tad_web` set `last_accessed`='2024-05-20 15:46:50' where `WebID`='10' |
0.000264 - select `ConfigName`,`ConfigValue` from tad_web_config where `WebID`='10' |
0.000180 - select `name`, `type`, `value` from tad_web_plugins_setup where `WebID`='10' and plugin='news' |
0.000174 - SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '5') ORDER BY conf_order ASC |
0.000226 - SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '3') ORDER BY conf_order ASC |
0.000776 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3) |
0.000829 - 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.000329 - 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.000296 - 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.000137 - select ncsn,of_ncsn,nc_title from tad_news_cate where not_news='1' and `ncsn`='30' |
0.002169 - select nsn,news_title from tad_news where ncsn='30' order by page_sort |
0.000124 - select ncsn,nc_title from tad_news_cate where of_ncsn='30' order by sort |
0.000370 - 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.000256 - 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.000139 - SELECT * FROM modules WHERE dirname = 'tad_uploader' |
0.000268 - SELECT COUNT(*) FROM group_permission WHERE (gperm_modid = '14' AND (gperm_groupid = '3') AND gperm_name = 'catalog' AND gperm_itemid = '2') |
0.000239 - SELECT COUNT(*) FROM group_permission WHERE (gperm_modid = '14' AND (gperm_groupid = '3') AND gperm_name = 'catalog' AND gperm_itemid = '2') |
0.000245 - SELECT COUNT(*) FROM group_permission WHERE (gperm_modid = '14' AND (gperm_groupid = '3') AND gperm_name = 'catalog' AND gperm_itemid = '2') |
0.000231 - SELECT COUNT(*) FROM group_permission WHERE (gperm_modid = '14' AND (gperm_groupid = '3') AND gperm_name = 'catalog' AND gperm_itemid = '2') |
0.000231 - 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.000240 - 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.000122 - select * from tad_link_cate where cate_sn in(8) order by of_cate_sn,cate_sort |
0.000234 - 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.000336 - 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.000307 - 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.000194 - update tad_web_news set `NewsCounter`=`NewsCounter`+1 where `NewsID`='4' and `NewsEnable`='1' |
0.000131 - select * from tad_web_news where NewsID='4' and `NewsEnable`='1' |
0.000119 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='NewsID' and col_sn='4' and power_name='read' |
0.000149 - select NewsID,NewsTitle from tad_web_news where `WebID`='10' and `NewsEnable`='1' order by NewsDate desc |
0.000115 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='NewsID' and col_sn='4' and power_name='read' |
0.000153 - SELECT * FROM users WHERE uid = '9' |
0.000236 - select * from `tad_web_files_center` where `col_name`='NewsID' and `col_sn`='4' order by sort |
0.000301 - select `AssistantType`,`AssistantID` from `tad_web_assistant_post` where `ColName`='NewsID' and `ColSN`='4' and `CateID`='178' |
0.000288 - select `AssistantType`,`AssistantID` from `tad_web_assistant_post` where `ColName`='NewsID' and `ColSN`='4' and `CateID`='178' |
0.000108 - select * from `tad_web_cate` where `CateID` = '178' |
0.000170 - select tag_name , count(*) from `tad_web_tags` where `WebID` = '10' and `col_name`='NewsID' and `col_sn`='4' group by tag_name |
0.000626 - select * from tad_web_blocks where `WebID`='10' and `BlockEnable`='1' and `BlockPosition`='side' order by `BlockPosition`,`BlockSort` |
0.000126 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='BlockID' and col_sn='308' and power_name='read' |
0.000123 - SELECT `WebOwnerUid` FROM `tad_web` WHERE `WebID` = '10' |
0.000128 - SELECT `uid` FROM `tad_web_roles` WHERE `WebID` = '10' and `role` = 'admin' |
0.000154 - SELECT `uid`,`name`,`uname`,`email` FROM `users` WHERE `uid` in('1','10') |
0.000113 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='BlockID' and col_sn='312' and power_name='read' |
0.000228 - select ActionName,ActionID from tad_web_action where WebID='10' order by rand() |
0.000111 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='ActionID' and col_sn='35' and power_name='read' |
0.000251 - select * from `tad_web_files_center` where `col_name`='ActionID' and `col_sn`='35' order by sort |
0.000113 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='BlockID' and col_sn='322' and power_name='read' |
0.000174 - SELECT `CateName`, `CateID`
FROM `tad_web_cate`
WHERE `WebID` = '10' AND `ColName` = 'page' AND `CateEnable` = '1'
ORDER BY `CateSort` limit 0,40 |
0.000104 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='BlockID' and col_sn='324' and power_name='read' |
0.000103 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='BlockID' and col_sn='326' and power_name='read' |
0.000525 - SELECT * FROM tad_web WHERE WebEnable='1' ORDER BY CateID,WebSort |
0.000138 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='BlockID' and col_sn='328' and power_name='read' |
0.000143 - select power_val from `tad_web_power` where `WebID` = '10' and col_name='BlockID' and col_sn='329' and power_name='read' |
0.000119 - 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.000155 - select `name`, `type`, `value` from tad_web_plugins_setup where `WebID`='10' and plugin='aboutus' |
0.000116 - SELECT * FROM modules WHERE dirname = 'tad_login' |
0.000094 - select `tt_theme`,`tt_use_bootstrap`,`tt_bootstrap_color`,`tt_theme_kind` from `tadtools_setup` where `tt_theme`='for_tad_web_theme_2' |
0.000226 - 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 |