[ DB ] CONNECT:[ UseTime:0.043974s ] mysql:host=rm-3ns41jmtlb1g0zd6v.mysql.rds.aliyuncs.com;port=3306;dbname=daxiong_6000;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `cmf_plugin_web` [ RunTime:0.034454s ]
[ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%427312f5-eaac-413c-8171-5984f8fc3f8f.yijad.cn%' LIMIT 1 [ RunTime:0.026301s ]
[ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `erji` = '427312f5-eaac-413c-8171-5984f8fc3f8f' LIMIT 1 [ RunTime:0.021290s ]
[ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%yijad.cn%' LIMIT 1 [ RunTime:0.018081s ]
[ SQL ] SHOW COLUMNS FROM `cmf_plugin` [ RunTime:0.037734s ]
[ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Web' LIMIT 1 [ RunTime:0.009024s ]
[ SQL ] SHOW COLUMNS FROM `cmf_option` [ RunTime:0.004212s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'cdn_settings' AND `site_id` = 305 LIMIT 1 [ RunTime:0.013359s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'cdn_settings' AND `site_id` = 305 LIMIT 1 [ RunTime:0.004052s ]
[ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 305 LIMIT 1 [ RunTime:0.006160s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'site_info' AND `site_id` = 305 LIMIT 1 [ RunTime:0.012880s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.007057s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` WHERE `status` = 1 [ RunTime:0.010918s ]
[ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 305 LIMIT 1 [ RunTime:0.006236s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_competitions` [ RunTime:0.188527s ]
[ SQL ] SELECT `pinyin` FROM `cmf_nami_competitions` WHERE `id` = 100 LIMIT 1 [ RunTime:0.008753s ]
[ SQL ] SELECT `com_type` FROM `cmf_nami_competitions` WHERE `id` = 100 LIMIT 1 [ RunTime:0.006045s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `pinyin` = 'yijia' LIMIT 1 [ RunTime:0.006143s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `id` = 4705 AND `status` = 1 LIMIT 1 [ RunTime:0.014354s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nav_menu` [ RunTime:0.008069s ]
[ 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.007897s ]
[ SQL ] SHOW COLUMNS FROM `cmf_route` [ RunTime:0.007964s ]
[ SQL ] SELECT `url` FROM `cmf_route` WHERE `full_url` = 'portal/List/index?id=4705' AND `site_id` IS NULL LIMIT 1 [ RunTime:0.009498s ]
[ SQL ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.003326s ]
[ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = '24_zhibo_12' AND ( `is_public` = 1 OR `file` = 'portal/list' ) [ RunTime:0.010051s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'storage' LIMIT 1 [ RunTime:0.029823s ]
[ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Oss' LIMIT 1 [ RunTime:0.002582s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nav` [ RunTime:0.461318s ]
[ SQL ] SELECT `id` FROM `cmf_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.029258s ]
[ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `site_id` = 305 AND `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.013359s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4705 LIMIT 1 [ RunTime:0.009970s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 4705 [ RunTime:0.004740s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_news` [ RunTime:0.023764s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_portal_news` `post` WHERE ( `category_id` IN (4705,4706,4707) ) [ RunTime:0.048045s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` WHERE ( `category_id` IN (4705,4706,4707) ) ORDER BY `id` DESC LIMIT 100,20 [ RunTime:0.039737s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.005474s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4705 LIMIT 1 [ RunTime:0.008404s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4705 LIMIT 1 [ RunTime:0.005847s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4705 LIMIT 1 [ RunTime:0.011666s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4705 LIMIT 1 [ RunTime:0.030390s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4705 LIMIT 1 [ RunTime:0.004035s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4705 LIMIT 1 [ RunTime:0.011633s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4705 LIMIT 1 [ RunTime:0.011768s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4705 LIMIT 1 [ RunTime:0.007760s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4705 LIMIT 1 [ RunTime:0.004767s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4705 LIMIT 1 [ RunTime:0.013767s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4705 LIMIT 1 [ RunTime:0.014521s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4705 LIMIT 1 [ RunTime:0.003040s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4705 LIMIT 1 [ RunTime:0.015858s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4705 LIMIT 1 [ RunTime:0.006632s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4705 LIMIT 1 [ RunTime:0.003157s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4705 LIMIT 1 [ RunTime:0.004868s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4705 LIMIT 1 [ RunTime:0.008072s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4705 LIMIT 1 [ RunTime:0.009511s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4705 LIMIT 1 [ RunTime:0.002870s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4705 LIMIT 1 [ RunTime:0.002467s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.002492s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 1855 [ RunTime:0.626266s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` WHERE ( `category_id` IN (1855,1856,1857) ) ORDER BY `create_time` DESC LIMIT 0,10 [ RunTime:0.032053s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.008442s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.016947s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.012745s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.007403s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.006706s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.009311s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.028806s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.004939s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.008171s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.005725s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.003206s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = "" LIMIT 1 [ RunTime:0.003613s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = "" [ RunTime:0.005191s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` ORDER BY `create_time` DESC LIMIT 0,10 [ RunTime:0.023592s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.010151s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5463 LIMIT 1 [ RunTime:0.003691s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5457 LIMIT 1 [ RunTime:0.033521s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5451 LIMIT 1 [ RunTime:0.005451s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5445 LIMIT 1 [ RunTime:0.003988s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5439 LIMIT 1 [ RunTime:0.753678s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5433 LIMIT 1 [ RunTime:0.030818s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5427 LIMIT 1 [ RunTime:0.003262s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5421 LIMIT 1 [ RunTime:0.005144s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5415 LIMIT 1 [ RunTime:0.003889s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5409 LIMIT 1 [ RunTime:0.032078s ]
[ SQL ] SELECT `competition_id` FROM `cmf_plugin_web` WHERE `id` = 305 LIMIT 1 [ RunTime:0.007862s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `id` = 100 LIMIT 1 [ RunTime:0.009547s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_teams` [ RunTime:0.012445s ]
[ SQL ] SELECT * FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `competition_id` = 108 ORDER BY `id` DESC LIMIT 50 [ RunTime:0.023147s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'site_info' AND `site_id` = 305 LIMIT 1 [ RunTime:0.006771s ]
[ 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.013412s ]
