[ DB ] CONNECT:[ UseTime:0.005235s ] mysql:host=rm-3ns41jmtlb1g0zd6v.mysql.rds.aliyuncs.com;port=3306;dbname=daxiong_6000;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `cmf_plugin_web` [ RunTime:0.003811s ]
[ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.chengxiangdianqi.cn%' LIMIT 1 [ RunTime:0.002801s ]
[ SQL ] SHOW COLUMNS FROM `cmf_plugin` [ RunTime:0.002735s ]
[ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Web' LIMIT 1 [ RunTime:0.002516s ]
[ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 311 LIMIT 1 [ RunTime:0.002638s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.006697s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` WHERE `status` = 1 [ RunTime:0.007718s ]
[ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 311 LIMIT 1 [ RunTime:0.002696s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_competitions` [ RunTime:0.002850s ]
[ SQL ] SELECT `pinyin` FROM `cmf_nami_competitions` WHERE `id` = 529 LIMIT 1 [ RunTime:0.003060s ]
[ SQL ] SELECT `com_type` FROM `cmf_nami_competitions` WHERE `id` = 529 LIMIT 1 [ RunTime:0.002684s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `pinyin` = 'yazhouyuxuan' LIMIT 1 [ RunTime:0.004651s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nav_menu` [ RunTime:0.002779s ]
[ SQL ] SELECT `name`,`href` FROM `cmf_nav_menu` WHERE `nav_id` = 1 AND `parent_id` = 0 AND `status` = 1 AND `site_id` = 311 [ RunTime:0.003909s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_competition_hot` [ RunTime:0.002588s ]
[ SQL ] SELECT `cid` FROM `cmf_nami_competition_hot` WHERE `site_id` = 311 [ RunTime:0.010267s ]
[ SQL ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.002686s ]
[ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = '24_zhibo_9' AND ( `is_public` = 1 OR `file` = 'portal/index' ) [ RunTime:0.002796s ]
[ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Oss' LIMIT 1 [ RunTime:0.002598s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nav` [ RunTime:0.002806s ]
[ SQL ] SELECT `id` FROM `cmf_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.002605s ]
[ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `site_id` = 311 AND `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.003947s ]
[ 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 25 [ RunTime:0.004544s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1891 LIMIT 1 [ RunTime:0.002650s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 1891 [ RunTime:0.004029s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_news` [ RunTime:0.004366s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` WHERE ( `category_id` IN (1891,1892,1893) ) ORDER BY `create_time` DESC LIMIT 0,1 [ RunTime:0.003804s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.713321s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1891 LIMIT 1 [ RunTime:0.002530s ]
[ SQL ] SHOW COLUMNS FROM `cmf_option` [ RunTime:0.002783s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'storage' LIMIT 1 [ RunTime:0.002674s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'cdn_settings' AND `site_id` = 311 LIMIT 1 [ RunTime:0.002663s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1891 LIMIT 1 [ RunTime:0.002564s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 1891 [ RunTime:0.003751s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` WHERE ( `category_id` IN (1891,1892,1893) ) ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.003690s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.006768s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1891 LIMIT 1 [ RunTime:0.002708s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1891 LIMIT 1 [ RunTime:0.003410s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1891 LIMIT 1 [ RunTime:0.002575s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1891 LIMIT 1 [ RunTime:0.002545s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_matches` [ RunTime:0.003337s ]
[ SQL ] SELECT * FROM `cmf_nami_matches` WHERE ( `match_time` > 1779792894 ) AND ( ( competition_id in (select cid from cmf_nami_competitions where recommend=1) ) ) ORDER BY `match_time` ASC LIMIT 20 [ RunTime:0.004894s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` IN (544,613,293,398,396,1) [ RunTime:0.002986s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` IN (544,613,293,398,396,1) [ RunTime:0.002672s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_teams` [ RunTime:0.003577s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (74787,40074,87226,82062,40926,33710,17260,10230,25763,27598,10813,14806,15828,17406,10210,34772,14639,30642,12344,38802,11532,23761,11977,13469,11206,61848,10117,27991,10377,13470,15235,10904,14637,14964,91657,71266,70460,48371) [ RunTime:0.004716s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (10219,10137) [ RunTime:0.002947s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (74787,40074,87226,82062,40926,33710,17260,10230,25763,27598,10813,14806,15828,17406,10210,34772,14639,30642,12344,38802,11532,23761,11977,13469,11206,61848,10117,27991,10377,13470,15235,10904,14637,14964,91657,71266,70460,48371) [ RunTime:0.003863s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (10219,10137) [ RunTime:0.006106s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `pinyin` = 'yazhouyuxuan' AND `com_type` = 0 LIMIT 1 [ RunTime:0.003342s ]
[ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `competition_id` = 3 AND `com_type` = 0 AND ( `match_time` > 1779792894 ) ORDER BY `match_time` ASC LIMIT 100 [ RunTime:0.003440s ]
[ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `competition_id` = 3 AND `com_type` = 0 ORDER BY `match_time` DESC LIMIT 20 [ RunTime:0.003990s ]
[ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `competition_id` = 3 ORDER BY `match_time` DESC LIMIT 20 [ RunTime:0.003625s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` = 3 [ RunTime:0.003003s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` = 3 [ RunTime:0.002773s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (10360,10361,10727,10726,10730,36563,10793,10729,11072,11380,10724,10731,10728,10722,10721,10725,10326,10734,10273,10732) [ RunTime:0.003387s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (10360,10361,10727,10726,10730,36563,10793,10729,11072,11380,10724,10731,10728,10722,10721,10725,10326,10734,10273,10732) [ RunTime:0.005068s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `pinyin` = 'yazhouyuxuan' AND `com_type` = 0 LIMIT 1 [ RunTime:0.004291s ]
[ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `competition_id` = 3 AND `com_type` = 0 AND ( `match_time` > 1779792894 ) ORDER BY `match_time` ASC LIMIT 300 [ RunTime:0.007425s ]
[ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `competition_id` = 3 AND `com_type` = 0 ORDER BY `match_time` DESC LIMIT 20 [ RunTime:0.003781s ]
[ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `competition_id` = 3 ORDER BY `match_time` DESC LIMIT 20 [ RunTime:0.003928s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` = 3 [ RunTime:0.002622s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` = 3 [ RunTime:0.002705s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (10360,10361,10727,10726,10730,36563,10793,10729,11072,11380,10724,10731,10728,10722,10721,10725,10326,10734,10273,10732) [ RunTime:0.003112s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (10360,10361,10727,10726,10730,36563,10793,10729,11072,11380,10724,10731,10728,10722,10721,10725,10326,10734,10273,10732) [ RunTime:0.003157s ]
[ SQL ] SELECT * FROM `cmf_nami_matches` WHERE ( `match_time` > 1779792894 ) AND ( ( competition_id in (select cid from cmf_nami_competitions where recommend=1) ) ) ORDER BY `match_time` ASC LIMIT 100 [ RunTime:0.006779s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` IN (544,613,293,398,396,1,3265,151,543,542,201,184,109,7306,195,202,121,46,435) [ RunTime:0.004106s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` IN (544,613,293,398,396,1,3265,151,543,542,201,184,109,7306,195,202,121,46,435) [ RunTime:0.003039s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (74787,40074,87226,82062,40926,33710,17260,10230,25763,27598,10813,14806,15828,17406,10210,34772,14639,30642,12344,38802,11532,23761,11977,13469,11206,61848,10117,27991,10377,13470,15235,10904,14637,14964,91657,71266,70460,48371,74788,13028,70470,18279,22123,24237,11751,24083,24974,50836,18134,19167,23361,26626,81608,71376,69951,74781,87225,82059,10244,11845,10757,32004,14742,17476,10108,48294,15968,10147,19859,10598,12149,25138,18355,11624,10211,29566,10496,21171,10753,16819,15756,16044,10801,21590,10149,27429,14688,12356,18554,24316,10814,11408,12391,14872,14009,18003,10169,16006,10093,12506,10208,14998,14347,34313,74666,53113,74630,74782,34291,19717,33141,27993,10273,10236,10631,10696,10488,16383,10269,10522,10187,10858,23373,11578,26539,27727,11858,10123,15775,11076,53112,10700,53336,10223,10766,10767,50536,60821,14346,60822,23094,34311,70423,60824,48130,10138,88255,86718,88259,88252,88251,88253,88256,86719,10387,10687,30028,70439,10009,45373,10139,10910,12759,11574,10963,10120,10604,10695,10633,11577,10490,13078,10237,10491,12217,14343,10437,10744,10746,12597,10972,75354,11440,10031,10540,10973,10368,10215,10126,10756,10044,10466) [ RunTime:0.006491s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (10219,10137) [ RunTime:0.005368s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (74787,40074,87226,82062,40926,33710,17260,10230,25763,27598,10813,14806,15828,17406,10210,34772,14639,30642,12344,38802,11532,23761,11977,13469,11206,61848,10117,27991,10377,13470,15235,10904,14637,14964,91657,71266,70460,48371,74788,13028,70470,18279,22123,24237,11751,24083,24974,50836,18134,19167,23361,26626,81608,71376,69951,74781,87225,82059,10244,11845,10757,32004,14742,17476,10108,48294,15968,10147,19859,10598,12149,25138,18355,11624,10211,29566,10496,21171,10753,16819,15756,16044,10801,21590,10149,27429,14688,12356,18554,24316,10814,11408,12391,14872,14009,18003,10169,16006,10093,12506,10208,14998,14347,34313,74666,53113,74630,74782,34291,19717,33141,27993,10273,10236,10631,10696,10488,16383,10269,10522,10187,10858,23373,11578,26539,27727,11858,10123,15775,11076,53112,10700,53336,10223,10766,10767,50536,60821,14346,60822,23094,34311,70423,60824,48130,10138,88255,86718,88259,88252,88251,88253,88256,86719,10387,10687,30028,70439,10009,45373,10139,10910,12759,11574,10963,10120,10604,10695,10633,11577,10490,13078,10237,10491,12217,14343,10437,10744,10746,12597,10972,75354,11440,10031,10540,10973,10368,10215,10126,10756,10044,10466) [ RunTime:0.006209s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (10219,10137) [ RunTime:0.006619s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1891 LIMIT 1 [ RunTime:0.004441s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 1891 [ RunTime:0.005862s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` WHERE ( `category_id` IN (1891,1892,1893) ) ORDER BY `create_time` DESC LIMIT 0,6 [ RunTime:0.004131s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.014910s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1891 LIMIT 1 [ RunTime:0.005958s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1891 LIMIT 1 [ RunTime:0.009740s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 1891 [ RunTime:0.005853s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` WHERE ( `category_id` IN (1891,1892,1893) ) ORDER BY `create_time` DESC LIMIT 0,9 [ RunTime:0.008654s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.008552s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1891 LIMIT 1 [ RunTime:0.006549s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1891 LIMIT 1 [ RunTime:0.719003s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1891 LIMIT 1 [ RunTime:0.006294s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_tag` [ RunTime:0.004623s ]
[ SQL ] SELECT * FROM `cmf_portal_tag` WHERE `site_id` = 311 AND `status` = 1 LIMIT 20 [ RunTime:0.003512s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = "" LIMIT 1 [ RunTime:0.003148s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = "" [ RunTime:0.008172s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` ORDER BY `create_time` DESC LIMIT 0,10 [ RunTime:0.004773s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.010312s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5463 LIMIT 1 [ RunTime:0.052049s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5457 LIMIT 1 [ RunTime:0.006837s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5439 LIMIT 1 [ RunTime:0.011554s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5445 LIMIT 1 [ RunTime:0.004108s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5451 LIMIT 1 [ RunTime:0.004200s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5433 LIMIT 1 [ RunTime:0.007820s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5427 LIMIT 1 [ RunTime:0.003559s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5421 LIMIT 1 [ RunTime:0.004890s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5415 LIMIT 1 [ RunTime:0.003208s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5403 LIMIT 1 [ RunTime:0.006612s ]
[ 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 15 [ RunTime:0.006381s ]