[ DB ] CONNECT:[ UseTime:0.008536s ] mysql:host=rm-3ns41jmtlb1g0zd6v.mysql.rds.aliyuncs.com;port=3306;dbname=daxiong_6000;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `cmf_plugin_web` [ RunTime:0.002846s ]
[ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.chengxiangdianqi.cn%' LIMIT 1 [ RunTime:0.002792s ]
[ SQL ] SHOW COLUMNS FROM `cmf_plugin` [ RunTime:0.002697s ]
[ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Web' LIMIT 1 [ RunTime:0.002586s ]
[ SQL ] SHOW COLUMNS FROM `cmf_option` [ RunTime:0.002809s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'cdn_settings' AND `site_id` = 311 LIMIT 1 [ RunTime:0.002689s ]
[ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 311 LIMIT 1 [ RunTime:0.002563s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'site_info' AND `site_id` = 311 LIMIT 1 [ RunTime:0.002450s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.003610s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` WHERE `status` = 1 [ RunTime:0.007080s ]
[ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 311 LIMIT 1 [ RunTime:0.002928s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_competitions` [ RunTime:0.003028s ]
[ SQL ] SELECT `pinyin` FROM `cmf_nami_competitions` WHERE `id` = 529 LIMIT 1 [ RunTime:0.002713s ]
[ SQL ] SELECT `com_type` FROM `cmf_nami_competitions` WHERE `id` = 529 LIMIT 1 [ RunTime:0.002462s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `pinyin` = 'yazhouyuxuan' LIMIT 1 [ RunTime:0.003645s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nav_menu` [ RunTime:0.002644s ]
[ 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.007541s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_competition_hot` [ RunTime:0.002561s ]
[ SQL ] SELECT `cid` FROM `cmf_nami_competition_hot` WHERE `site_id` = 311 [ RunTime:0.002808s ]
[ SQL ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.003073s ]
[ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = '24_zhibo_9' AND ( `is_public` = 1 OR `file` = 'portal/index' ) [ RunTime:0.002739s ]
[ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Oss' LIMIT 1 [ RunTime:0.002413s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nav` [ RunTime:0.002573s ]
[ SQL ] SELECT `id` FROM `cmf_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.003086s ]
[ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `site_id` = 311 AND `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.007079s ]
[ 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.003889s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1891 LIMIT 1 [ RunTime:0.002588s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 1891 [ RunTime:0.003475s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_news` [ RunTime:0.002859s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` WHERE ( `category_id` IN (1891,1892,1893) ) ORDER BY `create_time` DESC LIMIT 0,1 [ RunTime:0.003997s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.008245s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1891 LIMIT 1 [ RunTime:0.002294s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1891 LIMIT 1 [ RunTime:0.002388s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 1891 [ RunTime:0.003410s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` WHERE ( `category_id` IN (1891,1892,1893) ) ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.003622s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.005187s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1891 LIMIT 1 [ RunTime:0.002647s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1891 LIMIT 1 [ RunTime:0.002807s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1891 LIMIT 1 [ RunTime:0.002879s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1891 LIMIT 1 [ RunTime:0.003573s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_matches` [ RunTime:0.004754s ]
[ SQL ] SELECT * FROM `cmf_nami_matches` WHERE ( `match_time` > 1779973583 ) AND ( ( competition_id in (select cid from cmf_nami_competitions where recommend=1) ) ) ORDER BY `match_time` ASC LIMIT 20 [ RunTime:0.004896s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` IN (151,396,398,1,543,542,293,201) [ RunTime:0.003888s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` IN (151,396,398,1,543,542,293,201) [ RunTime:0.002994s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_teams` [ RunTime:0.002849s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (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) [ RunTime:0.003085s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (10137,10219) [ RunTime:0.002628s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (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) [ RunTime:0.002940s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (10137,10219) [ RunTime:0.002681s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `pinyin` = 'yazhouyuxuan' AND `com_type` = 0 LIMIT 1 [ RunTime:0.003246s ]
[ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `competition_id` = 3 AND `com_type` = 0 AND ( `match_time` > 1779973583 ) ORDER BY `match_time` ASC LIMIT 100 [ RunTime:0.003454s ]
[ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `competition_id` = 3 AND `com_type` = 0 ORDER BY `match_time` DESC LIMIT 20 [ RunTime:0.003449s ]
[ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `competition_id` = 3 ORDER BY `match_time` DESC LIMIT 20 [ RunTime:0.003418s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` = 3 [ RunTime:0.002664s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` = 3 [ RunTime:0.002584s ]
[ 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.002766s ]
[ 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.002715s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `pinyin` = 'yazhouyuxuan' AND `com_type` = 0 LIMIT 1 [ RunTime:0.003192s ]
[ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `competition_id` = 3 AND `com_type` = 0 AND ( `match_time` > 1779973583 ) ORDER BY `match_time` ASC LIMIT 300 [ RunTime:0.003551s ]
[ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `competition_id` = 3 AND `com_type` = 0 ORDER BY `match_time` DESC LIMIT 20 [ RunTime:0.003513s ]
[ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `competition_id` = 3 ORDER BY `match_time` DESC LIMIT 20 [ RunTime:0.003498s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` = 3 [ RunTime:0.002671s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` = 3 [ RunTime:0.003165s ]
[ 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.006350s ]
[ 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.002900s ]
[ SQL ] SELECT * FROM `cmf_nami_matches` WHERE ( `match_time` > 1779973583 ) AND ( ( competition_id in (select cid from cmf_nami_competitions where recommend=1) ) ) ORDER BY `match_time` ASC LIMIT 100 [ RunTime:0.024956s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` IN (151,396,398,1,543,542,293,201,184,109,7306,195,202,121,46,435,152,15,186) [ RunTime:0.003137s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` IN (151,396,398,1,543,542,293,201,184,109,7306,195,202,121,46,435,152,15,186) [ RunTime:0.002861s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (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,10230,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,27598,75354,11440,10031,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) [ RunTime:0.004080s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (10137,10219) [ RunTime:0.002712s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (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,10230,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,27598,75354,11440,10031,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) [ RunTime:0.003761s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (10137,10219) [ RunTime:0.002391s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1891 LIMIT 1 [ RunTime:0.002193s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 1891 [ RunTime:0.003431s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` WHERE ( `category_id` IN (1891,1892,1893) ) ORDER BY `create_time` DESC LIMIT 0,6 [ RunTime:0.003861s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.005475s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1891 LIMIT 1 [ RunTime:0.002661s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1891 LIMIT 1 [ RunTime:0.002323s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 1891 [ RunTime:0.003326s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` WHERE ( `category_id` IN (1891,1892,1893) ) ORDER BY `create_time` DESC LIMIT 0,9 [ RunTime:0.003710s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.004949s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1891 LIMIT 1 [ RunTime:0.002908s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1891 LIMIT 1 [ RunTime:0.002742s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1891 LIMIT 1 [ RunTime:0.004164s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_tag` [ RunTime:0.003135s ]
[ SQL ] SELECT * FROM `cmf_portal_tag` WHERE `site_id` = 311 AND `status` = 1 LIMIT 20 [ RunTime:0.003926s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = "" LIMIT 1 [ RunTime:0.003391s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = "" [ RunTime:0.004751s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` ORDER BY `create_time` DESC LIMIT 0,10 [ RunTime:0.002842s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.004513s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4963 LIMIT 1 [ RunTime:0.002599s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4951 LIMIT 1 [ RunTime:0.002384s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 4957 LIMIT 1 [ RunTime:0.002694s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 2863 LIMIT 1 [ RunTime:0.002395s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 2851 LIMIT 1 [ RunTime:0.002292s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 2857 LIMIT 1 [ RunTime:0.002313s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 967 LIMIT 1 [ RunTime:0.002767s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 973 LIMIT 1 [ RunTime:0.002442s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 961 LIMIT 1 [ RunTime:0.002499s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5463 LIMIT 1 [ RunTime:0.002677s ]
[ 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.003225s ]