[ DB ] CONNECT:[ UseTime:0.028001s ] mysql:host=rm-3ns41jmtlb1g0zd6v.mysql.rds.aliyuncs.com;port=3306;dbname=daxiong_6000;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `cmf_plugin_web` [ RunTime:0.039773s ]
[ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%427312f5-eaac-413c-8171-5984f8fc3f8f.yijad.cn%' LIMIT 1 [ RunTime:0.020568s ]
[ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `erji` = '427312f5-eaac-413c-8171-5984f8fc3f8f' LIMIT 1 [ RunTime:0.020096s ]
[ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%yijad.cn%' LIMIT 1 [ RunTime:0.005476s ]
[ SQL ] SHOW COLUMNS FROM `cmf_plugin` [ RunTime:0.019268s ]
[ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Web' LIMIT 1 [ RunTime:0.011116s ]
[ SQL ] SHOW COLUMNS FROM `cmf_option` [ RunTime:0.033501s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'cdn_settings' AND `site_id` = 305 LIMIT 1 [ RunTime:0.008539s ]
[ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 305 LIMIT 1 [ RunTime:0.005446s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.025888s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` WHERE `status` = 1 [ RunTime:0.050729s ]
[ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 305 LIMIT 1 [ RunTime:0.011877s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_competitions` [ RunTime:0.024639s ]
[ SQL ] SELECT `pinyin` FROM `cmf_nami_competitions` WHERE `id` = 100 LIMIT 1 [ RunTime:0.006202s ]
[ SQL ] SELECT `com_type` FROM `cmf_nami_competitions` WHERE `id` = 100 LIMIT 1 [ RunTime:0.006880s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `pinyin` = 'yijia' LIMIT 1 [ RunTime:0.798423s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `id` = 4603 AND `status` = 1 LIMIT 1 [ RunTime:0.033952s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nav_menu` [ RunTime:0.014191s ]
[ 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.015744s ]
[ SQL ] SHOW COLUMNS FROM `cmf_route` [ RunTime:0.005668s ]
[ SQL ] SELECT `url` FROM `cmf_route` WHERE `full_url` = 'portal/List/index?id=4603' AND `site_id` IS NULL LIMIT 1 [ RunTime:0.015492s ]
[ SQL ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.004089s ]
[ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = '24_zhibo_12' AND ( `is_public` = 1 OR `file` = 'portal/list' ) [ RunTime:0.028345s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'storage' LIMIT 1 [ RunTime:0.004338s ]
[ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Oss' LIMIT 1 [ RunTime:0.005087s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nav` [ RunTime:0.004358s ]
[ SQL ] SELECT `id` FROM `cmf_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.006116s ]
[ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `site_id` = 305 AND `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.005627s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4603 LIMIT 1 [ RunTime:0.820607s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 4603 [ RunTime:0.017037s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_news` [ RunTime:0.009496s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_portal_news` `post` WHERE ( `category_id` IN (4603,4604,4605) ) [ RunTime:0.019112s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` WHERE ( `category_id` IN (4603,4604,4605) ) ORDER BY `id` DESC LIMIT 100,20 [ RunTime:0.006295s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.017530s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4603 LIMIT 1 [ RunTime:0.026963s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4603 LIMIT 1 [ RunTime:0.008587s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4603 LIMIT 1 [ RunTime:0.012828s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4603 LIMIT 1 [ RunTime:0.012936s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4603 LIMIT 1 [ RunTime:0.010703s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4603 LIMIT 1 [ RunTime:0.011494s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4603 LIMIT 1 [ RunTime:0.003317s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4603 LIMIT 1 [ RunTime:0.029561s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4603 LIMIT 1 [ RunTime:0.011302s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4603 LIMIT 1 [ RunTime:0.769868s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4603 LIMIT 1 [ RunTime:0.018232s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4603 LIMIT 1 [ RunTime:0.007385s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4603 LIMIT 1 [ RunTime:0.004750s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4603 LIMIT 1 [ RunTime:0.003338s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4603 LIMIT 1 [ RunTime:0.003650s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4603 LIMIT 1 [ RunTime:0.008101s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4603 LIMIT 1 [ RunTime:0.021241s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4603 LIMIT 1 [ RunTime:0.004972s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4603 LIMIT 1 [ RunTime:0.014593s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4603 LIMIT 1 [ RunTime:0.011623s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.003042s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 1855 [ RunTime:0.017241s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` WHERE ( `category_id` IN (1855,1856,1857) ) ORDER BY `create_time` DESC LIMIT 0,10 [ RunTime:0.009578s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.028032s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.011039s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.828222s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.005656s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.007911s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.004189s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.013627s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.011477s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.003323s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.009016s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.004760s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = "" LIMIT 1 [ RunTime:0.013896s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = "" [ RunTime:0.006053s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` ORDER BY `create_time` DESC LIMIT 0,10 [ RunTime:0.014155s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.007669s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 3505 LIMIT 1 [ RunTime:0.014568s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 3235 LIMIT 1 [ RunTime:0.013449s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 2653 LIMIT 1 [ RunTime:0.004429s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 2623 LIMIT 1 [ RunTime:0.007475s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 2167 LIMIT 1 [ RunTime:0.010932s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1819 LIMIT 1 [ RunTime:0.007199s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5463 LIMIT 1 [ RunTime:0.005110s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5457 LIMIT 1 [ RunTime:0.017729s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5451 LIMIT 1 [ RunTime:0.007474s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5445 LIMIT 1 [ RunTime:0.787281s ]
[ SQL ] SELECT `competition_id` FROM `cmf_plugin_web` WHERE `id` = 305 LIMIT 1 [ RunTime:0.032824s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `id` = 100 LIMIT 1 [ RunTime:0.009132s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_teams` [ RunTime:0.039952s ]
[ SQL ] SELECT * FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `competition_id` = 108 ORDER BY `id` DESC LIMIT 50 [ RunTime:0.008238s ]
[ 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.029775s ]
