資料庫語法 |
---|
0.000104 - SET SQL_BIG_SELECTS = 1 |
0.001539 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '1') ORDER BY conf_order ASC |
0.001176 - SELECT sess_data, sess_ip FROM session WHERE sess_id = 'n3nmu54qo9s14bjgig9567v44d' |
0.000345 - SELECT * FROM config WHERE (`conf_modid` = '5') ORDER BY conf_order ASC |
0.002657 - SELECT * FROM `tad_themes` WHERE `theme_name` = 'school2019' |
0.000989 - SELECT * FROM `tad_themes_blocks` WHERE `theme_id` = 4 |
0.001168 - desc `tad_themes_data_center` `sort` |
0.001131 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tad_themes_data_center`
 where `mid`= '5' and `col_name`='theme_id' and `col_sn`='4' order by `sort` , `data_sort` |
0.000772 - SELECT * FROM `tad_themes_config2` WHERE `theme_id`=4 |
0.001556 - SELECT a.* FROM `tad_themes_files_center` AS a

 LEFT JOIN `tad_themes` AS b ON a.`col_sn` = b.`theme_id`

 WHERE a.`col_name` = 'slide' AND b.`theme_name` = 'school2019' |
0.001301 - SHOW COLUMNS FROM `configcategory` LIKE 'confcat_modid' |
0.000877 - SHOW TABLES LIKE 'block_instance' |
0.000485 - SELECT `conf_id` FROM `config` WHERE `conf_name` = 'ldap_provisionning' AND `conf_catid` = 7 |
0.000445 - SELECT `conf_id` FROM `config` WHERE `conf_name` = 'ldap_use_TLS' AND `conf_catid` = 7 |
0.000574 - SELECT `conf_id` FROM `config` WHERE `conf_name` = 'ldap_use_TLS' AND `conf_catid` = 7 |
0.000785 - SHOW COLUMNS FROM config LIKE 'conf_title' |
0.000511 - SELECT COUNT(*) FROM `config` WHERE `conf_name` IN ('welcome_type', 'cpanel') |
0.000786 - SHOW TABLES LIKE 'cache_model' |
0.007202 - SHOW KEYS FROM `block_module_link` |
0.000955 - SHOW COLUMNS FROM `cache_model` LIKE 'cache_data' |
0.000953 - SHOW COLUMNS FROM `banner` LIKE 'htmlcode' |
0.000913 - SHOW COLUMNS FROM `bannerclient` LIKE 'extrainfo' |
0.001084 - SHOW COLUMNS FROM `xoopscomments` LIKE 'com_text' |
0.000615 - SHOW COLUMNS FROM `config` LIKE 'conf_value' |
0.000965 - SHOW COLUMNS FROM `groups` LIKE 'description' |
0.000920 - SHOW COLUMNS FROM `imgsetimg` LIKE 'imgsetimg_body' |
0.001079 - SHOW COLUMNS FROM `newblocks` LIKE 'content' |
0.000934 - SHOW COLUMNS FROM `priv_msgs` LIKE 'msg_text' |
0.000629 - SHOW COLUMNS FROM `session` LIKE 'sess_data' |
0.000981 - SHOW COLUMNS FROM `tplset` LIKE 'tplset_credits' |
0.000920 - SHOW COLUMNS FROM `tplsource` LIKE 'tpl_source' |
0.001077 - SHOW COLUMNS FROM `users` LIKE 'user_sig' |
0.000646 - SHOW COLUMNS FROM `users` LIKE 'bio' |
0.023025 - SHOW KEYS FROM `modules` |
0.013981 - SHOW KEYS FROM `users` |
0.009012 - SHOW KEYS FROM `online` |
0.012911 - SHOW KEYS FROM `config` |
0.017341 - SHOW KEYS FROM `xoopscomments` |
0.000532 - SELECT COUNT(*) FROM `config` WHERE `conf_name` IN ('break1', 'usetips') |
0.001026 - SELECT COUNT(*) FROM `tplfile` WHERE `tpl_file` IN ('system_header.html', 'system_header.tpl') AND `tpl_type` = 'admin' |
0.000838 - SELECT COUNT(*) as `count` FROM newblocks WHERE (`mid` = '1' AND `block_type` = 'S' AND `func_num` = '1' AND `template` = 'system_block_user.html') |
0.012392 - SHOW KEYS FROM `groups_users_link` |
0.000579 - SELECT `imptotal` FROM `banner` WHERE `bid` = 1 |
0.000862 - SHOW COLUMNS FROM xoopscomments LIKE 'com_user' |
0.000714 - SHOW COLUMNS FROM xoopscomments LIKE 'com_email' |
0.000641 - SHOW COLUMNS FROM xoopscomments LIKE 'com_url' |
0.000612 - SELECT `CHARACTER_MAXIMUM_LENGTH` FROM `information_schema`.`COLUMNS` WHERE TABLE_SCHEMA = 'dnjh_life'AND TABLE_NAME = 'users' AND COLUMN_NAME = 'pass' |
0.000526 - SELECT `CHARACTER_MAXIMUM_LENGTH` FROM `information_schema`.`COLUMNS` WHERE TABLE_SCHEMA = 'dnjh_life'AND TABLE_NAME = 'xoopscomments' AND COLUMN_NAME = 'com_ip' |
0.000557 - SELECT `CHARACTER_MAXIMUM_LENGTH` FROM `information_schema`.`COLUMNS` WHERE TABLE_SCHEMA = 'dnjh_life'AND TABLE_NAME = 'session' AND COLUMN_NAME = 'sess_ip' |
0.000547 - SELECT `CHARACTER_MAXIMUM_LENGTH` FROM `information_schema`.`COLUMNS` WHERE TABLE_SCHEMA = 'dnjh_life'AND TABLE_NAME = 'online' AND COLUMN_NAME = 'online_ip' |
0.000542 - SELECT `CHARACTER_MAXIMUM_LENGTH` FROM `information_schema`.`COLUMNS` WHERE TABLE_SCHEMA = 'dnjh_life'AND TABLE_NAME = 'session' AND COLUMN_NAME = 'sess_id' |
0.000369 - SELECT count(*) FROM `config` WHERE `conf_formtype` = 'select' AND `conf_name` = 'meta_robots' AND `conf_modid` = 0 |
0.003165 - SELECT TABLE_NAME, ENGINE, CHARACTER_SET_NAME FROM `INFORMATION_SCHEMA`.`TABLES` t, `INFORMATION_SCHEMA`.`COLLATIONS` c WHERE t.TABLE_SCHEMA = 'dnjh_life' AND t.TABLE_NAME = 'banner' AND t.TABLE_COLLATION = c.COLLATION_NAME |
0.000803 - SELECT * FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'dnjh_life' AND TABLE_NAME = 'banner' ORDER BY `ORDINAL_POSITION` |
0.001057 - SELECT `INDEX_NAME`, `SEQ_IN_INDEX`, `NON_UNIQUE`, `COLUMN_NAME`, `SUB_PART` FROM `INFORMATION_SCHEMA`.`STATISTICS` WHERE TABLE_SCHEMA = 'dnjh_life' AND TABLE_NAME = 'banner' ORDER BY `INDEX_NAME`, `SEQ_IN_INDEX` |
0.001842 - SELECT TABLE_NAME, ENGINE, CHARACTER_SET_NAME FROM `INFORMATION_SCHEMA`.`TABLES` t, `INFORMATION_SCHEMA`.`COLLATIONS` c WHERE t.TABLE_SCHEMA = 'dnjh_life' AND t.TABLE_NAME = 'config' AND t.TABLE_COLLATION = c.COLLATION_NAME |
0.000767 - SELECT * FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'dnjh_life' AND TABLE_NAME = 'config' ORDER BY `ORDINAL_POSITION` |
0.000640 - SELECT `INDEX_NAME`, `SEQ_IN_INDEX`, `NON_UNIQUE`, `COLUMN_NAME`, `SUB_PART` FROM `INFORMATION_SCHEMA`.`STATISTICS` WHERE TABLE_SCHEMA = 'dnjh_life' AND TABLE_NAME = 'config' ORDER BY `INDEX_NAME`, `SEQ_IN_INDEX` |
0.001808 - SELECT TABLE_NAME, ENGINE, CHARACTER_SET_NAME FROM `INFORMATION_SCHEMA`.`TABLES` t, `INFORMATION_SCHEMA`.`COLLATIONS` c WHERE t.TABLE_SCHEMA = 'dnjh_life' AND t.TABLE_NAME = 'modules' AND t.TABLE_COLLATION = c.COLLATION_NAME |
0.000791 - SELECT * FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'dnjh_life' AND TABLE_NAME = 'modules' ORDER BY `ORDINAL_POSITION` |
0.000712 - SELECT `INDEX_NAME`, `SEQ_IN_INDEX`, `NON_UNIQUE`, `COLUMN_NAME`, `SUB_PART` FROM `INFORMATION_SCHEMA`.`STATISTICS` WHERE TABLE_SCHEMA = 'dnjh_life' AND TABLE_NAME = 'modules' ORDER BY `INDEX_NAME`, `SEQ_IN_INDEX` |
0.000789 - SELECT count(*) FROM `configoption` WHERE `conf_id` = 64 AND `confop_name` = 'qmail' |
0.000391 - SELECT COUNT(*) FROM `tplfile` WHERE `tpl_file` IN ('system_confirm.tpl') AND `tpl_type` = 'module' |
0.000246 - SELECT COUNT(*) FROM `tplfile` WHERE `tpl_file` IN ('system_modules.tpl') AND `tpl_type` = 'admin' |
0.000423 - SELECT COUNT(*) FROM `config` WHERE `conf_name` IN ('default_notification') |