[ DB ] CONNECT:[ UseTime:0.766808s ] mysql:host=rm-3ns41jmtlb1g0zd6v.mysql.rds.aliyuncs.com;port=3306;dbname=daxiong_6000;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `cmf_plugin_web` [ RunTime:0.017181s ]
[ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%yijad.cn%' LIMIT 1 [ RunTime:0.003870s ]
[ SQL ] SHOW COLUMNS FROM `cmf_plugin` [ RunTime:0.004540s ]
[ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Web' LIMIT 1 [ RunTime:0.003092s ]
[ SQL ] SHOW COLUMNS FROM `cmf_option` [ RunTime:0.003545s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'cdn_settings' AND `site_id` = 305 LIMIT 1 [ RunTime:0.007599s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'cdn_settings' AND `site_id` = 305 LIMIT 1 [ RunTime:0.003101s ]
[ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 305 LIMIT 1 [ RunTime:0.019681s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'site_info' AND `site_id` = 305 LIMIT 1 [ RunTime:0.007402s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.006288s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` WHERE `status` = 1 [ RunTime:0.015321s ]
[ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 305 LIMIT 1 [ RunTime:0.006085s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_competitions` [ RunTime:0.008458s ]
[ SQL ] SELECT `pinyin` FROM `cmf_nami_competitions` WHERE `id` = 100 LIMIT 1 [ RunTime:0.798519s ]
[ SQL ] SELECT `com_type` FROM `cmf_nami_competitions` WHERE `id` = 100 LIMIT 1 [ RunTime:0.019459s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `pinyin` = 'yijia' LIMIT 1 [ RunTime:0.008428s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `id` = 12 AND `status` = 1 LIMIT 1 [ RunTime:0.006763s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nav_menu` [ RunTime:0.016032s ]
[ 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.023576s ]
[ SQL ] SHOW COLUMNS FROM `cmf_route` [ RunTime:0.037689s ]
[ SQL ] SELECT `url` FROM `cmf_route` WHERE `full_url` = 'portal/List/index?id=12' AND `site_id` IS NULL LIMIT 1 [ RunTime:0.032737s ]
[ SQL ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.008533s ]
[ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = '24_zhibo_12' AND ( `is_public` = 1 OR `file` = 'portal/list' ) [ RunTime:0.006048s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'storage' LIMIT 1 [ RunTime:0.003693s ]
[ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Oss' LIMIT 1 [ RunTime:0.006581s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'cdn_settings' AND `site_id` = 305 LIMIT 1 [ RunTime:0.005048s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nav` [ RunTime:0.010712s ]
[ SQL ] SELECT `id` FROM `cmf_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.004079s ]
[ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `site_id` = 305 AND `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.008243s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = "" LIMIT 1 [ RunTime:0.011679s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = "" [ RunTime:0.005180s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_news` [ RunTime:0.010432s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_portal_news` `post` [ RunTime:0.918192s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` ORDER BY `id` DESC LIMIT 200,20 [ RunTime:0.006659s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.026497s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4183 LIMIT 1 [ RunTime:0.010430s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4165 LIMIT 1 [ RunTime:0.009613s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4153 LIMIT 1 [ RunTime:0.006464s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4159 LIMIT 1 [ RunTime:0.006782s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4141 LIMIT 1 [ RunTime:0.020031s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4147 LIMIT 1 [ RunTime:0.013942s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4135 LIMIT 1 [ RunTime:0.020995s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4129 LIMIT 1 [ RunTime:0.003449s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4123 LIMIT 1 [ RunTime:0.003311s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4117 LIMIT 1 [ RunTime:0.003682s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4105 LIMIT 1 [ RunTime:0.003710s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4111 LIMIT 1 [ RunTime:0.005513s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4099 LIMIT 1 [ RunTime:0.007321s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4081 LIMIT 1 [ RunTime:0.003621s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4093 LIMIT 1 [ RunTime:0.003612s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4087 LIMIT 1 [ RunTime:0.004735s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4069 LIMIT 1 [ RunTime:0.004762s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4063 LIMIT 1 [ RunTime:0.012690s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4075 LIMIT 1 [ RunTime:0.008396s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4051 LIMIT 1 [ RunTime:0.004578s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.003666s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 1855 [ RunTime:0.024617s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` WHERE ( `category_id` IN (1855,1856,1857) ) ORDER BY `create_time` DESC LIMIT 0,10 [ RunTime:0.773267s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.011543s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.012690s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.003170s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.013212s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.003198s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.004318s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.005217s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.003316s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.009964s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.005030s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.005802s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = "" LIMIT 1 [ RunTime:0.003652s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = "" [ RunTime:0.007050s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` ORDER BY `create_time` DESC LIMIT 0,10 [ RunTime:0.003217s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.014700s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5463 LIMIT 1 [ RunTime:0.013558s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5451 LIMIT 1 [ RunTime:0.007827s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5439 LIMIT 1 [ RunTime:0.003136s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5433 LIMIT 1 [ RunTime:0.007061s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5427 LIMIT 1 [ RunTime:0.017824s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5415 LIMIT 1 [ RunTime:0.005258s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5421 LIMIT 1 [ RunTime:0.003796s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5409 LIMIT 1 [ RunTime:0.007733s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5385 LIMIT 1 [ RunTime:0.004549s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5391 LIMIT 1 [ RunTime:0.008972s ]
[ SQL ] SELECT `competition_id` FROM `cmf_plugin_web` WHERE `id` = 305 LIMIT 1 [ RunTime:0.003939s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `id` = 100 LIMIT 1 [ RunTime:0.004500s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_teams` [ RunTime:0.016602s ]
[ SQL ] SELECT * FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `competition_id` = 108 ORDER BY `id` DESC LIMIT 50 [ RunTime:0.005745s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'site_info' AND `site_id` = 305 LIMIT 1 [ RunTime:0.018663s ]
[ 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.016383s ]
