[ DB ] CONNECT:[ UseTime:0.045079s ] mysql:host=rm-3ns41jmtlb1g0zd6v.mysql.rds.aliyuncs.com;port=3306;dbname=daxiong_6000;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `cmf_plugin_web` [ RunTime:0.017689s ]
[ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%427312f5-eaac-413c-8171-5984f8fc3f8f.yijad.cn%' LIMIT 1 [ RunTime:0.036757s ]
[ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `erji` = '427312f5-eaac-413c-8171-5984f8fc3f8f' LIMIT 1 [ RunTime:0.016253s ]
[ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%yijad.cn%' LIMIT 1 [ RunTime:0.026822s ]
[ SQL ] SHOW COLUMNS FROM `cmf_plugin` [ RunTime:0.014636s ]
[ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Web' LIMIT 1 [ RunTime:0.016609s ]
[ SQL ] SHOW COLUMNS FROM `cmf_option` [ RunTime:0.003840s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'cdn_settings' AND `site_id` = 305 LIMIT 1 [ RunTime:0.012879s ]
[ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 305 LIMIT 1 [ RunTime:0.027111s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'site_info' AND `site_id` = 305 LIMIT 1 [ RunTime:0.016481s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.009915s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` WHERE `status` = 1 [ RunTime:0.014312s ]
[ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 305 LIMIT 1 [ RunTime:0.022033s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_competitions` [ RunTime:0.022258s ]
[ SQL ] SELECT `pinyin` FROM `cmf_nami_competitions` WHERE `id` = 100 LIMIT 1 [ RunTime:0.802155s ]
[ SQL ] SELECT `com_type` FROM `cmf_nami_competitions` WHERE `id` = 100 LIMIT 1 [ RunTime:0.004331s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `pinyin` = 'yijia' LIMIT 1 [ RunTime:0.010401s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `id` = 0 AND `status` = 1 LIMIT 1 [ RunTime:0.007876s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'site_info' AND `site_id` = 305 LIMIT 1 [ RunTime:0.004672s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nav_menu` [ RunTime:0.004559s ]
[ 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.007315s ]
[ SQL ] SHOW COLUMNS FROM `cmf_route` [ RunTime:0.008208s ]
[ SQL ] SELECT `url` FROM `cmf_route` WHERE `full_url` = 'portal/List/index?id=0' AND `site_id` IS NULL LIMIT 1 [ RunTime:0.011478s ]
[ SQL ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.004190s ]
[ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = '24_zhibo_12' AND ( `is_public` = 1 OR `file` = 'portal/list' ) [ RunTime:0.008390s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'storage' LIMIT 1 [ RunTime:0.016813s ]
[ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Oss' LIMIT 1 [ RunTime:0.004265s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'cdn_settings' AND `site_id` = 305 LIMIT 1 [ RunTime:0.004266s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nav` [ RunTime:0.006856s ]
[ SQL ] SELECT `id` FROM `cmf_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.011695s ]
[ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `site_id` = 305 AND `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.005303s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = "" LIMIT 1 [ RunTime:0.024600s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = "" [ RunTime:0.010977s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_news` [ RunTime:0.009347s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_portal_news` `post` [ RunTime:0.028872s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` ORDER BY `id` DESC LIMIT 218540,20 [ RunTime:0.873153s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.022367s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1249 LIMIT 1 [ RunTime:0.036061s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 781 LIMIT 1 [ RunTime:0.007194s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1045 LIMIT 1 [ RunTime:0.004056s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1687 LIMIT 1 [ RunTime:0.005006s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1321 LIMIT 1 [ RunTime:0.021012s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1003 LIMIT 1 [ RunTime:0.009052s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 373 LIMIT 1 [ RunTime:0.004067s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 997 LIMIT 1 [ RunTime:0.015177s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1885 LIMIT 1 [ RunTime:0.018794s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1945 LIMIT 1 [ RunTime:0.015285s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1813 LIMIT 1 [ RunTime:0.014960s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1939 LIMIT 1 [ RunTime:0.005050s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 703 LIMIT 1 [ RunTime:0.015705s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 721 LIMIT 1 [ RunTime:0.797239s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1387 LIMIT 1 [ RunTime:0.019991s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 391 LIMIT 1 [ RunTime:0.008211s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1579 LIMIT 1 [ RunTime:0.016177s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1171 LIMIT 1 [ RunTime:0.013784s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 937 LIMIT 1 [ RunTime:0.007449s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 793 LIMIT 1 [ RunTime:0.019571s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.017764s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 1855 [ RunTime:0.018021s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` WHERE ( `category_id` IN (1855,1856,1857) ) ORDER BY `create_time` DESC LIMIT 0,10 [ RunTime:0.013239s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.009443s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.004274s ]
[ 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.004993s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.005687s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.003125s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.004348s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.006291s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.003384s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.005873s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.003237s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = "" LIMIT 1 [ RunTime:0.006590s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = "" [ RunTime:0.018599s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` ORDER BY `create_time` DESC LIMIT 0,10 [ RunTime:0.786130s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.029572s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5173 LIMIT 1 [ RunTime:0.013797s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5089 LIMIT 1 [ RunTime:0.003670s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5107 LIMIT 1 [ RunTime:0.019513s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5029 LIMIT 1 [ RunTime:0.009527s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4585 LIMIT 1 [ RunTime:0.006240s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4543 LIMIT 1 [ RunTime:0.005452s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4447 LIMIT 1 [ RunTime:0.003593s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4441 LIMIT 1 [ RunTime:0.013323s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4327 LIMIT 1 [ RunTime:0.006021s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4321 LIMIT 1 [ RunTime:0.005810s ]
[ SQL ] SELECT `competition_id` FROM `cmf_plugin_web` WHERE `id` = 305 LIMIT 1 [ RunTime:0.004837s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `id` = 100 LIMIT 1 [ RunTime:0.003255s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_teams` [ RunTime:0.003283s ]
[ SQL ] SELECT * FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `competition_id` = 108 ORDER BY `id` DESC LIMIT 50 [ RunTime:0.003292s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'site_info' AND `site_id` = 305 LIMIT 1 [ RunTime:0.003818s ]
[ 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.005232s ]
