[ DB ] CONNECT:[ UseTime:0.019470s ] mysql:host=rm-3ns41jmtlb1g0zd6v.mysql.rds.aliyuncs.com;port=3306;dbname=daxiong_6000;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `cmf_plugin_web` [ RunTime:0.003526s ]
[ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%yijad.cn%' LIMIT 1 [ RunTime:0.008813s ]
[ SQL ] SHOW COLUMNS FROM `cmf_plugin` [ RunTime:0.006482s ]
[ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Web' LIMIT 1 [ RunTime:0.003134s ]
[ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 305 LIMIT 1 [ RunTime:0.004111s ]
[ SQL ] SHOW COLUMNS FROM `cmf_option` [ RunTime:0.010604s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'site_info' AND `site_id` = 305 LIMIT 1 [ RunTime:0.003189s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.003692s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` WHERE `status` = 1 [ RunTime:0.013480s ]
[ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 305 LIMIT 1 [ RunTime:0.007581s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_competitions` [ RunTime:0.003771s ]
[ SQL ] SELECT `pinyin` FROM `cmf_nami_competitions` WHERE `id` = 100 LIMIT 1 [ RunTime:0.004236s ]
[ SQL ] SELECT `com_type` FROM `cmf_nami_competitions` WHERE `id` = 100 LIMIT 1 [ RunTime:0.005938s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `pinyin` = 'yijia' LIMIT 1 [ RunTime:0.003872s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `id` = 3925 AND `status` = 1 LIMIT 1 [ RunTime:0.004991s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nav_menu` [ RunTime:0.019415s ]
[ SQL ] SELECT `name`,`href` FROM `cmf_nav_menu` WHERE `nav_id` = 1 AND `parent_id` = 0 AND `status` = 1 AND `site_id` = 305 [ RunTime:0.005883s ]
[ SQL ] SHOW COLUMNS FROM `cmf_route` [ RunTime:0.003893s ]
[ SQL ] SELECT `url` FROM `cmf_route` WHERE `full_url` = 'portal/List/index?id=3925' AND `site_id` IS NULL LIMIT 1 [ RunTime:0.802439s ]
[ SQL ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.010206s ]
[ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = '24_zhibo_12' AND ( `is_public` = 1 OR `file` = 'portal/list' ) [ RunTime:0.005412s ]
[ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Oss' LIMIT 1 [ RunTime:0.006108s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nav` [ RunTime:0.032649s ]
[ SQL ] SELECT `id` FROM `cmf_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.006486s ]
[ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `site_id` = 305 AND `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.003939s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 3925 LIMIT 1 [ RunTime:0.003912s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 3925 [ RunTime:0.004506s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_news` [ RunTime:0.003017s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_portal_news` `post` WHERE ( `category_id` IN (3925,3926,3927) ) [ RunTime:0.003957s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` WHERE ( `category_id` IN (3925,3926,3927) ) ORDER BY `id` DESC LIMIT 20,20 [ RunTime:0.003820s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.009996s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.901395s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 1855 [ RunTime:0.014108s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` WHERE ( `category_id` IN (1855,1856,1857) ) ORDER BY `create_time` DESC LIMIT 0,10 [ RunTime:0.007342s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.005181s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = "" LIMIT 1 [ RunTime:0.022733s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = "" [ RunTime:0.004932s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` ORDER BY `create_time` DESC LIMIT 0,10 [ RunTime:0.006472s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.011278s ]
[ SQL ] SELECT `competition_id` FROM `cmf_plugin_web` WHERE `id` = 305 LIMIT 1 [ RunTime:0.046795s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `id` = 100 LIMIT 1 [ RunTime:0.019160s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_teams` [ RunTime:0.004197s ]
[ SQL ] SELECT * FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `competition_id` = 108 ORDER BY `id` DESC LIMIT 50 [ RunTime:0.820720s ]
[ SQL ] SELECT * FROM cmf_nami_competitions WHERE id IN (70, 2419, 588, 32, 122, 112, 136, 100, 33, 530, 529, 589, 623, 640) ORDER BY FIELD(id, 70, 2419, 588, 32, 122, 112, 136, 100, 33, 530, 529, 589, 623, 640) limit 20 [ RunTime:0.003890s ]
