[ DB ] CONNECT:[ UseTime:0.004722s ] mysql:host=rm-3nshzqnuo6110gvp4.mysql.rds.aliyuncs.com;port=3306;dbname=daxiong_erji;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `cmf_plugin_web` [ RunTime:0.003021s ]
[ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%sysmagic.com.cn%' LIMIT 1 [ RunTime:0.003460s ]
[ SQL ] SHOW COLUMNS FROM `cmf_plugin` [ RunTime:0.003036s ]
[ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Web' LIMIT 1 [ RunTime:0.002591s ]
[ SQL ] SHOW COLUMNS FROM `cmf_option` [ RunTime:0.002887s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'cdn_settings' AND `site_id` = 114 LIMIT 1 [ RunTime:0.002576s ]
[ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 114 LIMIT 1 [ RunTime:0.002928s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'site_info' AND `site_id` = 114 LIMIT 1 [ RunTime:0.003141s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.005300s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` WHERE `status` = 1 [ RunTime:0.004200s ]
[ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 114 LIMIT 1 [ RunTime:0.002448s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_competitions` [ RunTime:0.003462s ]
[ SQL ] SELECT `pinyin` FROM `cmf_nami_competitions` WHERE `id` = 2419 LIMIT 1 [ RunTime:0.005535s ]
[ SQL ] SELECT `com_type` FROM `cmf_nami_competitions` WHERE `id` = 2419 LIMIT 1 [ RunTime:0.002713s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `pinyin` = 'nba' LIMIT 1 [ RunTime:0.005101s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nav_menu` [ RunTime:0.002955s ]
[ SQL ] SELECT `name`,`href` FROM `cmf_nav_menu` WHERE `nav_id` = 1 AND `parent_id` = 0 AND `status` = 1 AND `site_id` = 114 [ RunTime:0.002918s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_competition_hot` [ RunTime:0.002924s ]
[ SQL ] SELECT `cid` FROM `cmf_nami_competition_hot` WHERE `site_id` = 114 [ RunTime:0.002553s ]
[ SQL ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.002804s ]
[ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = '24_zhibo_13' AND ( `is_public` = 1 OR `file` = 'portal/index' ) [ RunTime:0.002633s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'storage' LIMIT 1 [ RunTime:0.002557s ]
[ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Oss' LIMIT 1 [ RunTime:0.002797s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nav` [ RunTime:0.002674s ]
[ SQL ] SELECT `id` FROM `cmf_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.002481s ]
[ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `site_id` = 114 AND `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.002794s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 709 LIMIT 1 [ RunTime:0.002897s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 709 [ RunTime:0.002699s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_news` [ RunTime:0.002838s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` WHERE ( `category_id` IN (709,710,711) ) ORDER BY `create_time` DESC LIMIT 0,1 [ RunTime:0.003119s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.004143s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 709 LIMIT 1 [ RunTime:0.002651s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 709 LIMIT 1 [ RunTime:0.002971s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 709 LIMIT 1 [ RunTime:0.007844s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 709 [ RunTime:0.004451s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` WHERE ( `category_id` IN (709,710,711) ) ORDER BY `create_time` DESC LIMIT 0,10 [ RunTime:0.003912s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.004741s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 709 LIMIT 1 [ RunTime:0.004887s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 709 LIMIT 1 [ RunTime:0.004531s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 709 LIMIT 1 [ RunTime:0.004779s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 709 LIMIT 1 [ RunTime:0.004204s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 709 LIMIT 1 [ RunTime:0.003678s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 709 LIMIT 1 [ RunTime:0.002730s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 709 LIMIT 1 [ RunTime:0.003586s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 709 LIMIT 1 [ RunTime:0.003119s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 709 LIMIT 1 [ RunTime:0.002687s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 709 LIMIT 1 [ RunTime:0.002478s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 709 LIMIT 1 [ RunTime:0.002614s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 709 LIMIT 1 [ RunTime:0.002538s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 709 LIMIT 1 [ RunTime:0.002373s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 709 LIMIT 1 [ RunTime:0.002488s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 709 LIMIT 1 [ RunTime:0.002590s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 709 LIMIT 1 [ RunTime:0.002557s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 709 LIMIT 1 [ RunTime:0.002367s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 709 LIMIT 1 [ RunTime:0.002451s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 709 LIMIT 1 [ RunTime:0.002334s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 709 LIMIT 1 [ RunTime:0.002556s ]
[ 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.005191s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_matches` [ RunTime:0.003880s ]
[ SQL ] SELECT * FROM `cmf_nami_matches` WHERE ( `match_time` > 1780152910 ) AND ( ( competition_id in (select cid from cmf_nami_competitions where recommend=1) ) ) ORDER BY `match_time` ASC LIMIT 100 [ RunTime:0.010518s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` IN (195,46,435,121,152,1,542,184,293,15,186,202,2918,490,544) [ RunTime:0.003965s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` IN (195,46,435,121,152,1,542,184,293,15,186,202,2918,490,544) [ RunTime:0.003413s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_teams` [ RunTime:0.002993s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (10540,10973,10368,10215,10117,10126,10756,23761,10044,10466,62499,24834,12154,10147,10210,10496,11977,10205,10218,70469,50542,70422,11309,11575,10964,10153,10852,10122,15475,10436,17260,25763,17758,17494,69682,12865,27299,10121,31055,18549,18435,12669,22971,14994,13823,14272,11401,10597,28345,12553,40945,10596,16752,18968,12758,30960,19501,40285,28749,24236,12458,35962,11802,40366,11472,60675,15756,10818,11393,10464,14101,10521,11311,11722,10632,10523,15141,10489,14018,12663,15874,11564,10690,10252,10390,29434,12097,10035,10048,15735,10219,11260,10809,11441,10221,10292,14481,12187,10531,10743,93038,33132,10814,10816,10211,10757,12150,10813,10208,10149,92791,92790,92787,92786,87569,87571,92784,32680,19861,48482,46147,33521,82386,87577,87572,70425,92794,79409,74805,92793,33225,21292,10585,12160,70468,87560,18279,70460) [ RunTime:0.004958s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (10219,10137) [ RunTime:0.003479s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (10540,10973,10368,10215,10117,10126,10756,23761,10044,10466,62499,24834,12154,10147,10210,10496,11977,10205,10218,70469,50542,70422,11309,11575,10964,10153,10852,10122,15475,10436,17260,25763,17758,17494,69682,12865,27299,10121,31055,18549,18435,12669,22971,14994,13823,14272,11401,10597,28345,12553,40945,10596,16752,18968,12758,30960,19501,40285,28749,24236,12458,35962,11802,40366,11472,60675,15756,10818,11393,10464,14101,10521,11311,11722,10632,10523,15141,10489,14018,12663,15874,11564,10690,10252,10390,29434,12097,10035,10048,15735,10219,11260,10809,11441,10221,10292,14481,12187,10531,10743,93038,33132,10814,10816,10211,10757,12150,10813,10208,10149,92791,92790,92787,92786,87569,87571,92784,32680,19861,48482,46147,33521,82386,87577,87572,70425,92794,79409,74805,92793,33225,21292,10585,12160,70468,87560,18279,70460) [ RunTime:0.004159s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (10219,10137) [ RunTime:0.002875s ]
[ SQL ] SELECT * FROM `cmf_nami_matches` WHERE ( `match_time` > 1780152910 ) AND ( ( competition_id in (select cid from cmf_nami_competitions where recommend=1) ) ) ORDER BY `match_time` ASC LIMIT 30 [ RunTime:0.007586s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` IN (195,46,435,121,152,1,542,184,293,15,186) [ RunTime:0.004603s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` IN (195,46,435,121,152,1,542,184,293,15,186) [ RunTime:0.003386s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (10540,10973,10368,10215,10117,10126,10756,23761,10044,10466,62499,24834,12154,10147,10210,10496,11977,10205,10218,70469,50542,70422,11309,11575,10964,10153,10852,10122,15475,10436,17260,25763,17758,17494,69682,12865,27299,10121,31055,18549,18435,12669,22971,14994,13823,14272,11401,10597,28345,12553,40945,10596,16752,18968,12758,30960,19501,40285) [ RunTime:0.003458s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (10219,10137) [ RunTime:0.002529s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (10540,10973,10368,10215,10117,10126,10756,23761,10044,10466,62499,24834,12154,10147,10210,10496,11977,10205,10218,70469,50542,70422,11309,11575,10964,10153,10852,10122,15475,10436,17260,25763,17758,17494,69682,12865,27299,10121,31055,18549,18435,12669,22971,14994,13823,14272,11401,10597,28345,12553,40945,10596,16752,18968,12758,30960,19501,40285) [ RunTime:0.003213s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (10219,10137) [ RunTime:0.003063s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 977 LIMIT 1 [ RunTime:0.003171s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 977 [ RunTime:0.003122s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` ORDER BY `create_time` DESC LIMIT 0,12 [ RunTime:0.003139s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.003169s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 977 LIMIT 1 [ RunTime:0.002348s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 977 LIMIT 1 [ RunTime:0.002604s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 977 LIMIT 1 [ RunTime:0.002826s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 977 LIMIT 1 [ RunTime:0.002530s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 977 LIMIT 1 [ RunTime:0.002471s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 977 LIMIT 1 [ RunTime:0.002429s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 977 LIMIT 1 [ RunTime:0.002756s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 977 LIMIT 1 [ RunTime:0.002636s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 977 LIMIT 1 [ RunTime:0.002286s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 977 LIMIT 1 [ RunTime:0.002306s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 977 LIMIT 1 [ RunTime:0.002793s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 977 LIMIT 1 [ RunTime:0.002505s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 977 LIMIT 1 [ RunTime:0.002367s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 977 LIMIT 1 [ RunTime:0.003391s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 977 LIMIT 1 [ RunTime:0.002429s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 977 LIMIT 1 [ RunTime:0.002525s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 977 LIMIT 1 [ RunTime:0.002734s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 977 LIMIT 1 [ RunTime:0.002456s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 977 LIMIT 1 [ RunTime:0.003286s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 977 LIMIT 1 [ RunTime:0.002444s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 977 LIMIT 1 [ RunTime:0.002735s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 977 LIMIT 1 [ RunTime:0.008369s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 977 LIMIT 1 [ RunTime:0.005485s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 977 LIMIT 1 [ RunTime:0.002895s ]
[ SQL ] SELECT `id` FROM `cmf_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.002641s ]
[ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `site_id` = 114 AND `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.003048s ]
