[ DB ] CONNECT:[ UseTime:0.031727s ] mysql:host=rm-3ns41jmtlb1g0zd6v.mysql.rds.aliyuncs.com;port=3306;dbname=daxiong_6000;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `cmf_plugin_web` [ RunTime:0.017804s ]
[ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%yijad.cn%' LIMIT 1 [ RunTime:0.006582s ]
[ SQL ] SHOW COLUMNS FROM `cmf_plugin` [ RunTime:0.008062s ]
[ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Web' LIMIT 1 [ RunTime:0.009139s ]
[ SQL ] SHOW COLUMNS FROM `cmf_option` [ RunTime:0.003290s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'cdn_settings' AND `site_id` = 305 LIMIT 1 [ RunTime:0.002828s ]
[ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 305 LIMIT 1 [ RunTime:0.003366s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'site_info' AND `site_id` = 305 LIMIT 1 [ RunTime:0.003740s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.005027s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` WHERE `status` = 1 [ RunTime:0.825336s ]
[ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 305 LIMIT 1 [ RunTime:0.027127s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_competitions` [ RunTime:0.023567s ]
[ SQL ] SELECT `pinyin` FROM `cmf_nami_competitions` WHERE `id` = 100 LIMIT 1 [ RunTime:0.009244s ]
[ SQL ] SELECT `com_type` FROM `cmf_nami_competitions` WHERE `id` = 100 LIMIT 1 [ RunTime:0.006521s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `pinyin` = 'yijia' LIMIT 1 [ RunTime:0.020553s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `id` = 4687 AND `status` = 1 LIMIT 1 [ RunTime:0.005515s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'site_info' AND `site_id` = 305 LIMIT 1 [ RunTime:0.007890s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nav_menu` [ RunTime:0.004015s ]
[ 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.815053s ]
[ SQL ] SHOW COLUMNS FROM `cmf_route` [ RunTime:0.012694s ]
[ SQL ] SELECT `url` FROM `cmf_route` WHERE `full_url` = 'portal/List/index?id=4687' AND `site_id` IS NULL LIMIT 1 [ RunTime:0.014616s ]
[ SQL ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.013805s ]
[ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = '24_zhibo_12' AND ( `is_public` = 1 OR `file` = 'portal/list' ) [ RunTime:0.015838s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'storage' LIMIT 1 [ RunTime:0.008085s ]
[ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Oss' LIMIT 1 [ RunTime:0.003089s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'cdn_settings' AND `site_id` = 305 LIMIT 1 [ RunTime:0.003516s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'storage' LIMIT 1 [ RunTime:0.003947s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nav` [ RunTime:0.003751s ]
[ SQL ] SELECT `id` FROM `cmf_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.009293s ]
[ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `site_id` = 305 AND `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.007567s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4687 LIMIT 1 [ RunTime:0.003214s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 4687 [ RunTime:0.003929s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_news` [ RunTime:0.006687s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_portal_news` `post` WHERE ( `category_id` IN (4687,4688,4689) ) [ RunTime:0.817112s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` WHERE ( `category_id` IN (4687,4688,4689) ) ORDER BY `id` DESC LIMIT 20,20 [ RunTime:0.007755s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.019160s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4687 LIMIT 1 [ RunTime:0.013959s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4687 LIMIT 1 [ RunTime:0.023392s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4687 LIMIT 1 [ RunTime:0.007290s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4687 LIMIT 1 [ RunTime:0.021613s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4687 LIMIT 1 [ RunTime:0.004004s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4687 LIMIT 1 [ RunTime:0.006688s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4687 LIMIT 1 [ RunTime:0.009326s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4687 LIMIT 1 [ RunTime:0.004566s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4687 LIMIT 1 [ RunTime:0.004233s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4687 LIMIT 1 [ RunTime:0.011637s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4687 LIMIT 1 [ RunTime:0.007017s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4687 LIMIT 1 [ RunTime:0.017238s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4687 LIMIT 1 [ RunTime:0.009356s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4687 LIMIT 1 [ RunTime:0.814429s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4687 LIMIT 1 [ RunTime:0.011641s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4687 LIMIT 1 [ RunTime:0.017368s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4687 LIMIT 1 [ RunTime:0.010351s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4687 LIMIT 1 [ RunTime:0.019541s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4687 LIMIT 1 [ RunTime:0.015222s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4687 LIMIT 1 [ RunTime:0.017825s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.016753s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 1855 [ RunTime:0.015348s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` WHERE ( `category_id` IN (1855,1856,1857) ) ORDER BY `create_time` DESC LIMIT 0,10 [ RunTime:0.024531s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.851039s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.027960s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.017006s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.011742s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.003145s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.006528s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.004662s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.003802s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.006302s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.002516s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.010122s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = "" LIMIT 1 [ RunTime:0.003045s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = "" [ RunTime:0.010255s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` ORDER BY `create_time` DESC LIMIT 0,10 [ RunTime:0.005569s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.044520s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5463 LIMIT 1 [ RunTime:0.015189s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5451 LIMIT 1 [ RunTime:0.829811s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5439 LIMIT 1 [ RunTime:0.009922s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5433 LIMIT 1 [ RunTime:0.027047s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5427 LIMIT 1 [ RunTime:0.004919s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5415 LIMIT 1 [ RunTime:0.009253s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5421 LIMIT 1 [ RunTime:0.016797s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5409 LIMIT 1 [ RunTime:0.007237s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5385 LIMIT 1 [ RunTime:0.007773s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5391 LIMIT 1 [ RunTime:0.020801s ]
[ SQL ] SELECT `competition_id` FROM `cmf_plugin_web` WHERE `id` = 305 LIMIT 1 [ RunTime:0.024186s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `id` = 100 LIMIT 1 [ RunTime:0.014101s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_teams` [ RunTime:0.018242s ]
[ SQL ] SELECT * FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `competition_id` = 108 ORDER BY `id` DESC LIMIT 50 [ RunTime:0.006673s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'site_info' AND `site_id` = 305 LIMIT 1 [ RunTime:0.005327s ]
[ 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.018848s ]
