[ DB ] CONNECT:[ UseTime:0.011939s ] mysql:host=rm-3ns41jmtlb1g0zd6v.mysql.rds.aliyuncs.com;port=3306;dbname=daxiong_6000;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `cmf_plugin_web` [ RunTime:0.006636s ]
[ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%427312f5-eaac-413c-8171-5984f8fc3f8f.yijad.cn%' LIMIT 1 [ RunTime:0.005919s ]
[ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `erji` = '427312f5-eaac-413c-8171-5984f8fc3f8f' LIMIT 1 [ RunTime:0.003964s ]
[ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%yijad.cn%' LIMIT 1 [ RunTime:0.004121s ]
[ SQL ] SHOW COLUMNS FROM `cmf_plugin` [ RunTime:0.006385s ]
[ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Web' LIMIT 1 [ RunTime:0.003611s ]
[ SQL ] SHOW COLUMNS FROM `cmf_option` [ RunTime:0.003600s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'cdn_settings' AND `site_id` = 305 LIMIT 1 [ RunTime:0.003512s ]
[ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 305 LIMIT 1 [ RunTime:0.002991s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'cdn_settings' AND `site_id` = 305 LIMIT 1 [ RunTime:0.002957s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'site_info' AND `site_id` = 305 LIMIT 1 [ RunTime:0.006037s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.003842s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` WHERE `status` = 1 [ RunTime:0.008997s ]
[ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 305 LIMIT 1 [ RunTime:0.010803s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_competitions` [ RunTime:0.005225s ]
[ SQL ] SELECT `pinyin` FROM `cmf_nami_competitions` WHERE `id` = 100 LIMIT 1 [ RunTime:0.002857s ]
[ SQL ] SELECT `com_type` FROM `cmf_nami_competitions` WHERE `id` = 100 LIMIT 1 [ RunTime:0.006989s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `pinyin` = 'yijia' LIMIT 1 [ RunTime:0.009410s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `id` = 12 AND `status` = 1 LIMIT 1 [ RunTime:0.003850s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nav_menu` [ RunTime:0.007161s ]
[ 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.006405s ]
[ SQL ] SHOW COLUMNS FROM `cmf_route` [ RunTime:0.003165s ]
[ SQL ] SELECT `url` FROM `cmf_route` WHERE `full_url` = 'portal/List/index?id=12' AND `site_id` IS NULL LIMIT 1 [ RunTime:0.008115s ]
[ SQL ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.002922s ]
[ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = '24_zhibo_12' AND ( `is_public` = 1 OR `file` = 'portal/list' ) [ RunTime:0.003128s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'storage' LIMIT 1 [ RunTime:0.002607s ]
[ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Oss' LIMIT 1 [ RunTime:0.002746s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'cdn_settings' AND `site_id` = 305 LIMIT 1 [ RunTime:0.004010s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nav` [ RunTime:0.005902s ]
[ SQL ] SELECT `id` FROM `cmf_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.002826s ]
[ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `site_id` = 305 AND `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.004133s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = "" LIMIT 1 [ RunTime:0.008765s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = "" [ RunTime:0.011050s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_news` [ RunTime:0.755970s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_portal_news` `post` [ RunTime:0.026319s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` ORDER BY `id` DESC LIMIT 217840,20 [ RunTime:0.966260s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.017608s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1051 LIMIT 1 [ RunTime:0.014891s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1303 LIMIT 1 [ RunTime:0.006624s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 451 LIMIT 1 [ RunTime:0.013157s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1927 LIMIT 1 [ RunTime:0.004417s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 235 LIMIT 1 [ RunTime:0.003319s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 91 LIMIT 1 [ RunTime:0.003048s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 217 LIMIT 1 [ RunTime:0.004822s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1081 LIMIT 1 [ RunTime:0.009987s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1123 LIMIT 1 [ RunTime:0.004545s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 409 LIMIT 1 [ RunTime:0.004874s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1735 LIMIT 1 [ RunTime:0.006721s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1231 LIMIT 1 [ RunTime:0.003850s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1675 LIMIT 1 [ RunTime:0.003460s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1519 LIMIT 1 [ RunTime:0.004184s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1003 LIMIT 1 [ RunTime:0.004175s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 349 LIMIT 1 [ RunTime:0.002868s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1651 LIMIT 1 [ RunTime:0.011217s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 85 LIMIT 1 [ RunTime:0.003457s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 439 LIMIT 1 [ RunTime:0.003180s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1639 LIMIT 1 [ RunTime:0.003402s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.003829s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 1855 [ RunTime:0.004730s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` WHERE ( `category_id` IN (1855,1856,1857) ) ORDER BY `create_time` DESC LIMIT 0,10 [ RunTime:0.012491s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.016648s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.007309s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.003607s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.007177s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.810579s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.002945s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.003967s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.009887s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.005074s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.005348s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.006881s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = "" LIMIT 1 [ RunTime:0.003230s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = "" [ RunTime:0.004340s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` ORDER BY `create_time` DESC LIMIT 0,10 [ RunTime:0.004152s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.013114s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5463 LIMIT 1 [ RunTime:0.006668s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5451 LIMIT 1 [ RunTime:0.015704s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5439 LIMIT 1 [ RunTime:0.013615s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5433 LIMIT 1 [ RunTime:0.012649s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5427 LIMIT 1 [ RunTime:0.004574s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5415 LIMIT 1 [ RunTime:0.003396s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5421 LIMIT 1 [ RunTime:0.002651s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5409 LIMIT 1 [ RunTime:0.003371s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5385 LIMIT 1 [ RunTime:0.006193s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5391 LIMIT 1 [ RunTime:0.002812s ]
[ SQL ] SELECT `competition_id` FROM `cmf_plugin_web` WHERE `id` = 305 LIMIT 1 [ RunTime:0.006337s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `id` = 100 LIMIT 1 [ RunTime:0.009413s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_teams` [ RunTime:0.026852s ]
[ SQL ] SELECT * FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `competition_id` = 108 ORDER BY `id` DESC LIMIT 50 [ RunTime:0.805292s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'site_info' AND `site_id` = 305 LIMIT 1 [ RunTime:0.019076s ]
[ 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.005098s ]
