[ DB ] CONNECT:[ UseTime:0.005897s ] mysql:host=rm-3ns41jmtlb1g0zd6v.mysql.rds.aliyuncs.com;port=3306;dbname=daxiong_6000;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `cmf_plugin_web` [ RunTime:0.002889s ]
[ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%yijad.cn%' LIMIT 1 [ RunTime:0.002805s ]
[ SQL ] SHOW COLUMNS FROM `cmf_plugin` [ RunTime:0.003115s ]
[ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Web' LIMIT 1 [ RunTime:0.002637s ]
[ SQL ] SHOW COLUMNS FROM `cmf_option` [ RunTime:0.002794s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'cdn_settings' AND `site_id` = 305 LIMIT 1 [ RunTime:0.004277s ]
[ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 305 LIMIT 1 [ RunTime:0.002702s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'site_info' AND `site_id` = 305 LIMIT 1 [ RunTime:0.003400s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.003549s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` WHERE `status` = 1 [ RunTime:0.006674s ]
[ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 305 LIMIT 1 [ RunTime:0.004498s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_competitions` [ RunTime:0.003601s ]
[ SQL ] SELECT `pinyin` FROM `cmf_nami_competitions` WHERE `id` = 100 LIMIT 1 [ RunTime:0.002499s ]
[ SQL ] SELECT `com_type` FROM `cmf_nami_competitions` WHERE `id` = 100 LIMIT 1 [ RunTime:0.005880s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `pinyin` = 'yijia' LIMIT 1 [ RunTime:0.002907s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nav_menu` [ RunTime:0.004061s ]
[ 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.004631s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_competition_hot` [ RunTime:0.002813s ]
[ SQL ] SELECT `cid` FROM `cmf_nami_competition_hot` WHERE `site_id` = 305 [ RunTime:0.002513s ]
[ SQL ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.002905s ]
[ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = '24_zhibo_12' AND ( `is_public` = 1 OR `file` = 'portal/index' ) [ RunTime:0.002896s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'storage' LIMIT 1 [ RunTime:0.002700s ]
[ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Oss' LIMIT 1 [ RunTime:0.002750s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nav` [ RunTime:0.003960s ]
[ SQL ] SELECT `id` FROM `cmf_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.003200s ]
[ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `site_id` = 305 AND `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.005185s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_matches` [ RunTime:0.004117s ]
[ SQL ] SELECT * FROM `cmf_nami_matches` WHERE ( `match_time` > 1780504630 ) AND ( ( competition_id in (select cid from cmf_nami_competitions where recommend=1) ) ) ORDER BY `match_time` ASC LIMIT 30 [ RunTime:0.007355s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` IN (1,2918,490,544,15,186) [ RunTime:0.003000s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` IN (1,2918,490,544,15,186) [ RunTime:0.002794s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_teams` [ RunTime:0.003055s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (10137,10115) [ RunTime:0.003295s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (92793,87572,87577,92794,79409,82386,70425,74805,10585,12160,87569,92784,32680,87571,92787,92791,92790,92786,70468,87560,33225,17758,17494,33132,18279,70460,19861,33521,21292,48482,93038,14994,18435,69682,27299,10597,28345,14272,11401,12553,12669,12865,31055,10121,13823,18549,22971) [ RunTime:0.003189s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (10137,10115) [ RunTime:0.002631s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (92793,87572,87577,92794,79409,82386,70425,74805,10585,12160,87569,92784,32680,87571,92787,92791,92790,92786,70468,87560,33225,17758,17494,33132,18279,70460,19861,33521,21292,48482,93038,14994,18435,69682,27299,10597,28345,14272,11401,12553,12669,12865,31055,10121,13823,18549,22971) [ RunTime:0.003253s ]
[ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `com_type` = 1 AND ( `match_time` > 1780504630 ) ORDER BY `match_time` ASC LIMIT 100 [ RunTime:0.003397s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` = 1 [ RunTime:0.003262s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` = 1 [ RunTime:0.002610s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (10137,10115) [ RunTime:0.002624s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (10137,10115) [ RunTime:0.002588s ]
[ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `com_type` = 0 AND ( `match_time` > 1780504630 ) ORDER BY `match_time` ASC LIMIT 100 [ RunTime:0.003401s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` IN (192,34,721,7269,1683,2977,481,458,2798,2918,1745,197,490,2159,829,601,3374,5711,263,598,591,592,595,600,2782,593,582,596,1869,544) [ RunTime:0.519647s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` IN (192,34,721,7269,1683,2977,481,458,2798,2918,1745,197,490,2159,829,601,3374,5711,263,598,591,592,595,600,2782,593,582,596,1869,544) [ RunTime:0.003726s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (13566,19712,31297,15055,74479,24236,19270,21751,11475,34374,10867,11142,16791,14045,10410,13151,10870,23383,10823,13728,10407,13153,46310,87635,87497,27675,46141,50901,92721,55881,88376,15165,81344,50493,53560,87606,70663,53566,13073,27070,33186,33259,75158,52596,23523,80220,49962,26242,43671,49680,12064,20020,10586,11139,92793,87572,87577,92794,79409,82386,70425,74805,22429,46110,34897,34896,11677,22463,12630,11604,72795,38839,20585,17964,10585,12160,26054,26103,11271,10982,18211,11290,10980,13612,17559,54979,44376,73988,21917,79096,74024,44399,10869,11605,40366,35962,17114,15436,14227,11288,10234,11141,45230,19859,12344,14213,13956,18003,12065,10979,11764,10315,26518,74259,25461,14959,26216,26381,69829,74612,60956,92433,34245,92432,21919,18779,81471,26407,87569,92784,32680,87571,29622,23023,80853,80868,80870,80952,30654,23931,19190,30410,40126,23697,21910,20582,21445,28503,92787,92791,92790,92786,30446,18137,26723,33866,22861,34447,82995,34898,19167,29360,33265,31755,31763,25286,30092,30273,40567,27663,26152,30550,28313,26048,24974,60282,10271,55750,10190,20002,10150,23641,25082,26175,20287,60494,17698,30551,70468,87560,14189,11087,39238,49388,11086,21200,10408,14922) [ RunTime:0.005410s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (13566,19712,31297,15055,74479,24236,19270,21751,11475,34374,10867,11142,16791,14045,10410,13151,10870,23383,10823,13728,10407,13153,46310,87635,87497,27675,46141,50901,92721,55881,88376,15165,81344,50493,53560,87606,70663,53566,13073,27070,33186,33259,75158,52596,23523,80220,49962,26242,43671,49680,12064,20020,10586,11139,92793,87572,87577,92794,79409,82386,70425,74805,22429,46110,34897,34896,11677,22463,12630,11604,72795,38839,20585,17964,10585,12160,26054,26103,11271,10982,18211,11290,10980,13612,17559,54979,44376,73988,21917,79096,74024,44399,10869,11605,40366,35962,17114,15436,14227,11288,10234,11141,45230,19859,12344,14213,13956,18003,12065,10979,11764,10315,26518,74259,25461,14959,26216,26381,69829,74612,60956,92433,34245,92432,21919,18779,81471,26407,87569,92784,32680,87571,29622,23023,80853,80868,80870,80952,30654,23931,19190,30410,40126,23697,21910,20582,21445,28503,92787,92791,92790,92786,30446,18137,26723,33866,22861,34447,82995,34898,19167,29360,33265,31755,31763,25286,30092,30273,40567,27663,26152,30550,28313,26048,24974,60282,10271,55750,10190,20002,10150,23641,25082,26175,20287,60494,17698,30551,70468,87560,14189,11087,39238,49388,11086,21200,10408,14922) [ RunTime:0.005581s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1855 LIMIT 1 [ RunTime:0.003544s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 1855 [ RunTime:0.008013s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_news` [ RunTime:0.002747s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` WHERE ( `category_id` IN (1855,1856,1857) ) ORDER BY `create_time` DESC LIMIT 0,10 [ RunTime:0.004710s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.004792s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = "" LIMIT 1 [ RunTime:0.005590s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = "" [ RunTime:0.004274s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` ORDER BY `create_time` DESC LIMIT 0,10 [ RunTime:0.004440s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.005499s ]
[ SQL ] SELECT `competition_id` FROM `cmf_plugin_web` WHERE `id` = 305 LIMIT 1 [ RunTime:0.003843s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `id` = 100 LIMIT 1 [ RunTime:0.003702s ]
[ SQL ] SELECT * FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `competition_id` = 108 ORDER BY `id` DESC LIMIT 50 [ RunTime:0.005165s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'site_info' AND `site_id` = 305 LIMIT 1 [ RunTime:0.002525s ]
[ 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.002861s ]
