資料庫語法 |
---|
0.000388 - SET SQL_BIG_SELECTS = 1 |
0.002341 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '1') ORDER BY conf_order ASC |
0.000810 - SELECT sess_data, sess_ip FROM session WHERE sess_id = 'et04g56el13vc2n39hjvhkdir6' |
0.000402 - SELECT * FROM modules WHERE dirname = 'tadgallery' |
0.001028 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '1' AND (`gperm_groupid` = '3') AND `gperm_name` = 'module_read' AND `gperm_itemid` = '32') |
0.001248 - SELECT * FROM config WHERE (`conf_modid` = '32') ORDER BY conf_order ASC |
0.000287 - select csn,enable_upload_group from tad_gallery_cate |
0.000088 - select csn,enable_group from tad_gallery_cate |
0.000063 - select csn,enable_upload_group from tad_gallery_cate |
0.000172 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '5') ORDER BY conf_order ASC |
0.000333 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '3') ORDER BY conf_order ASC |
0.001751 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3) |
0.002629 - 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,32) AND b.bid IN (152,150,148,147,146,145,135,134,133,132,122,121,120,125,118,117,116,115,114,113,112,111,96,92,91,105,104,103,102,101,88,87,86,85,84,83,82,110,80,79,69,68,67,66,65,62,61,60,127,109,108,107,106,100,59,57,55,54,53,52,51,41,40,39,38,37,36,35,34,33,32,31,30,29,28,27,26,25,24,23,124,19,18,17,16,15,14,13,11,10,9,8,7,6,5,4,3,2,1,119,74,72,22,136,95,94,93,89,77,76,75,73,71,70,21) ORDER BY b.weight, m.block_id |
0.001078 - 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.007689 - 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_app_block.tpl') ORDER BY tpl_refid |
0.000555 - 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.001612 - select count(*),csn from tad_gallery where 1 group by csn |
0.000345 - select count(*),of_csn from tad_gallery_cate group by of_csn |
0.000097 - select csn,enable_group from tad_gallery_cate |
0.000125 - select `csn`,`passwd` from tad_gallery_cate where `enable`='1' order by `csn` desc limit 0,10 |
0.004739 - select a.* , b.title as album_title from tad_gallery as a left join tad_gallery_cate as b on a.csn=b.csn where 1 and a.`csn` in(1,2,3,4,5,6,7,8,9) order by rand() |
0.003273 - select a.* , b.title as album_title from tad_gallery as a left join tad_gallery_cate as b on a.csn=b.csn where 1 and a.`csn` in(1,2,3,4,5,6,7,8,9) order by rand() LIMIT 60, 30 |
0.001004 - SELECT * FROM users WHERE uid = '184' |
0.000511 - SELECT * FROM users WHERE uid = '1' |
0.000321 - SELECT * FROM users WHERE uid = '228' |
0.000177 - SELECT * FROM users WHERE uid = '181' |
0.001052 - select count(*),csn from tad_gallery where 1 group by csn |
0.000375 - select count(*),of_csn from tad_gallery_cate group by of_csn |
0.000815 - select csn,title,passwd,show_mode,cover,uid,content from tad_gallery_cate where of_csn='' order by sort |
0.001009 - select * from tad_gallery where csn='9' order by rand() limit 0,1 |
0.000778 - select * from tad_gallery where csn='1' order by rand() limit 0,1 |
0.000603 - select * from tad_gallery where csn='2' order by rand() limit 0,1 |
0.000667 - select * from tad_gallery where csn='3' order by rand() limit 0,1 |
0.001587 - select * from tad_gallery as a
join tad_gallery_cate as b on a.csn=b.csn
where a.csn='3' or b.of_csn='3'
order by rand() limit 0,1 |
0.000585 - select * from tad_gallery where csn='4' order by rand() limit 0,1 |
0.001044 - select * from tad_gallery as a
join tad_gallery_cate as b on a.csn=b.csn
where a.csn='4' or b.of_csn='4'
order by rand() limit 0,1 |
0.000310 - select csn,title from tad_gallery_cate where of_csn='0' order by sort |
0.000286 - select `tt_theme`,`tt_use_bootstrap`,`tt_bootstrap_color`,`tt_theme_kind` from `tadtools_setup` where `tt_theme`='default' |
0.000576 - 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` = 'tadgallery_list_normal.tpl') ORDER BY tpl_refid |
0.000628 - 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` = 'tadgallery_list_header.tpl') ORDER BY tpl_refid |
0.000382 - 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` = 'tadgallery_cate_fancybox.tpl') ORDER BY tpl_refid |
0.000292 - 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` = 'tadgallery_content.tpl') ORDER BY tpl_refid |