| 資料庫語法 |
|---|
| 0.000571 - SET SQL_BIG_SELECTS = 1 |
| 0.002215 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '1') ORDER BY conf_order ASC |
| 0.000914 - SELECT sess_data, sess_ip FROM session WHERE sess_id = 'uabqm6ttj74tenouet34dopu21' |
| 0.000716 - SELECT * FROM modules WHERE dirname = 'tadgallery' |
| 0.001562 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '1' AND (`gperm_groupid` = '3') AND `gperm_name` = 'module_read' AND `gperm_itemid` = '32') |
| 0.001056 - SELECT * FROM config WHERE (`conf_modid` = '32') ORDER BY conf_order ASC |
| 0.000619 - select csn,enable_upload_group from tad_gallery_cate |
| 0.000795 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '5') ORDER BY conf_order ASC |
| 0.000299 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '3') ORDER BY conf_order ASC |
| 0.002450 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3) |
| 0.005038 - 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.001683 - 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.000378 - 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.000614 - 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.001287 - select csn,enable_group from tad_gallery_cate |
| 0.000279 - select csn,enable_upload_group from tad_gallery_cate |
| 0.000596 - select * from tad_gallery where sn='93' |
| 0.000349 - select csn,enable_group from tad_gallery_cate |
| 0.000109 - select * from tad_gallery_cate where csn='8' |
| 0.002589 - select * from tad_gallery where csn='8' order by photo_sort , post_date |
| 0.000916 - select sn from tad_gallery where csn='8' order by photo_sort , post_date |
| 0.000393 - select csn,title from tad_gallery_cate where of_csn='0' order by sort |
| 0.000156 - select csn,enable_group from tad_gallery_cate |
| 0.000072 - select csn,enable_upload_group from tad_gallery_cate |
| 0.001488 - SELECT t1.csn AS lev1, t2.csn as lev2, t3.csn as lev3, t4.csn as lev4, t5.csn as lev5, t6.csn as lev6, t7.csn as lev7
FROM `tad_gallery_cate` t1
LEFT JOIN `tad_gallery_cate` t2 ON t2.of_csn = t1.csn
LEFT JOIN `tad_gallery_cate` t3 ON t3.of_csn = t2.csn
LEFT JOIN `tad_gallery_cate` t4 ON t4.of_csn = t3.csn
LEFT JOIN `tad_gallery_cate` t5 ON t5.of_csn = t4.csn
LEFT JOIN `tad_gallery_cate` t6 ON t6.of_csn = t5.csn
LEFT JOIN `tad_gallery_cate` t7 ON t7.of_csn = t6.csn
WHERE t1.of_csn = '0' order by t1.sort |
| 0.000315 - select * from tad_gallery_cate where csn='2' |
| 0.000276 - select csn,title from tad_gallery_cate where of_csn='2' order by sort |
| 0.000272 - select * from tad_gallery_cate where csn='8' |
| 0.000230 - select csn,title from tad_gallery_cate where of_csn='8' order by sort |
| 0.000259 - update tad_gallery set `counter`=`counter`+1 where sn='93' |
| 0.010109 - select csn,title from tad_gallery_cate where of_csn='0' order by sort |
| 0.000229 - select csn,enable_group from tad_gallery_cate |
| 0.000095 - select csn,enable_upload_group from tad_gallery_cate |
| 0.001317 - SELECT t1.csn AS lev1, t2.csn as lev2, t3.csn as lev3, t4.csn as lev4, t5.csn as lev5, t6.csn as lev6, t7.csn as lev7
FROM `tad_gallery_cate` t1
LEFT JOIN `tad_gallery_cate` t2 ON t2.of_csn = t1.csn
LEFT JOIN `tad_gallery_cate` t3 ON t3.of_csn = t2.csn
LEFT JOIN `tad_gallery_cate` t4 ON t4.of_csn = t3.csn
LEFT JOIN `tad_gallery_cate` t5 ON t5.of_csn = t4.csn
LEFT JOIN `tad_gallery_cate` t6 ON t6.of_csn = t5.csn
LEFT JOIN `tad_gallery_cate` t7 ON t7.of_csn = t6.csn
WHERE t1.of_csn = '0' order by t1.sort |
| 0.000374 - select * from tad_gallery_cate where csn='2' |
| 0.000135 - select csn,title from tad_gallery_cate where of_csn='2' order by sort |
| 0.000135 - select * from tad_gallery_cate where csn='8' |
| 0.004944 - select csn,title from tad_gallery_cate where of_csn='8' order by sort |
| 0.001273 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '1' AND (`gperm_groupid` = '3') AND `gperm_name` = 'system_admin' AND `gperm_itemid` = '14') |
| 0.000618 - SELECT * FROM xoopscomments WHERE (`com_modid` = '32' AND `com_itemid` = '93') ORDER BY com_id ASC |
| 0.000907 - 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_comments_controls.tpl') ORDER BY tpl_refid |
| 0.000339 - select `tt_theme`,`tt_use_bootstrap`,`tt_bootstrap_color`,`tt_theme_kind` from `tadtools_setup` where `tt_theme`='default' |
| 0.003297 - 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_view.tpl') ORDER BY tpl_refid |
| 0.000531 - 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_comments_flat.html') ORDER BY tpl_refid |
