[ DB ] CONNECT:[ UseTime:0.004948s ] mysql:host=rm-3ns41jmtlb1g0zd6v.mysql.rds.aliyuncs.com;port=3306;dbname=daxiong_6000;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `cmf_plugin_web` [ RunTime:0.003272s ]
[ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.chengxiangdianqi.cn%' LIMIT 1 [ RunTime:0.003968s ]
[ SQL ] SHOW COLUMNS FROM `cmf_plugin` [ RunTime:0.003388s ]
[ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Web' LIMIT 1 [ RunTime:0.003212s ]
[ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 311 LIMIT 1 [ RunTime:0.002533s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.003515s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` WHERE `status` = 1 [ RunTime:0.008349s ]
[ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 311 LIMIT 1 [ RunTime:0.002784s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_competitions` [ RunTime:0.002805s ]
[ SQL ] SELECT `pinyin` FROM `cmf_nami_competitions` WHERE `id` = 529 LIMIT 1 [ RunTime:0.002985s ]
[ SQL ] SELECT `com_type` FROM `cmf_nami_competitions` WHERE `id` = 529 LIMIT 1 [ RunTime:0.003918s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `pinyin` = 'yazhouyuxuan' LIMIT 1 [ RunTime:0.007376s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nav_menu` [ RunTime:0.002651s ]
[ 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.003834s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_competition_hot` [ RunTime:0.002659s ]
[ SQL ] SELECT `cid` FROM `cmf_nami_competition_hot` WHERE `site_id` = 311 [ RunTime:0.002740s ]
[ SQL ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.002674s ]
[ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = '24_zhibo_9' AND ( `is_public` = 1 OR `file` = 'portal/index' ) [ RunTime:0.003866s ]
[ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Oss' LIMIT 1 [ RunTime:0.002489s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nav` [ RunTime:0.002776s ]
[ SQL ] SELECT `id` FROM `cmf_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.002498s ]
[ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `site_id` = 311 AND `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.004233s ]
[ SQL ] SHOW COLUMNS FROM `cmf_option` [ RunTime:0.003021s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'site_info' AND `site_id` = 311 LIMIT 1 [ RunTime:0.003130s ]
[ 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.004431s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1891 LIMIT 1 [ RunTime:0.002563s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 1891 [ RunTime:0.003728s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_news` [ RunTime:0.006058s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` WHERE ( `category_id` IN (1891,1892,1893) ) ORDER BY `create_time` DESC LIMIT 0,1 [ RunTime:0.003771s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.007211s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1891 LIMIT 1 [ RunTime:0.002591s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'storage' LIMIT 1 [ RunTime:0.005160s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'cdn_settings' AND `site_id` = 311 LIMIT 1 [ RunTime:0.002643s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1891 LIMIT 1 [ RunTime:0.005209s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 1891 [ RunTime:0.005889s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` WHERE ( `category_id` IN (1891,1892,1893) ) ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.004342s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.006925s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1891 LIMIT 1 [ RunTime:0.002634s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1891 LIMIT 1 [ RunTime:0.002613s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1891 LIMIT 1 [ RunTime:0.002685s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1891 LIMIT 1 [ RunTime:0.002618s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_matches` [ RunTime:0.002985s ]
[ SQL ] SELECT * FROM `cmf_nami_matches` WHERE ( `match_time` > 1779917272 ) AND ( ( competition_id in (select cid from cmf_nami_competitions where recommend=1) ) ) ORDER BY `match_time` ASC LIMIT 20 [ RunTime:0.009527s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` IN (398,396,151) [ RunTime:0.002841s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` IN (398,396,151) [ RunTime:0.002866s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_teams` [ RunTime:0.004480s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (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) [ RunTime:0.003058s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (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) [ RunTime:0.003073s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `pinyin` = 'yazhouyuxuan' AND `com_type` = 0 LIMIT 1 [ RunTime:0.011324s ]
[ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `competition_id` = 3 AND `com_type` = 0 AND ( `match_time` > 1779917272 ) ORDER BY `match_time` ASC LIMIT 100 [ RunTime:0.003791s ]
[ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `competition_id` = 3 AND `com_type` = 0 ORDER BY `match_time` DESC LIMIT 20 [ RunTime:0.003560s ]
[ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `competition_id` = 3 ORDER BY `match_time` DESC LIMIT 20 [ RunTime:0.005287s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` = 3 [ RunTime:0.002955s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` = 3 [ RunTime:0.003801s ]
[ 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.003287s ]
[ 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.003802s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `pinyin` = 'yazhouyuxuan' AND `com_type` = 0 LIMIT 1 [ RunTime:0.004671s ]
[ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `competition_id` = 3 AND `com_type` = 0 AND ( `match_time` > 1779917272 ) ORDER BY `match_time` ASC LIMIT 300 [ RunTime:0.004123s ]
[ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `competition_id` = 3 AND `com_type` = 0 ORDER BY `match_time` DESC LIMIT 20 [ RunTime:0.003629s ]
[ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `competition_id` = 3 ORDER BY `match_time` DESC LIMIT 20 [ RunTime:0.003501s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` = 3 [ RunTime:0.002819s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` = 3 [ RunTime:0.002905s ]
[ 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.003570s ]
[ 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.003273s ]
[ SQL ] SELECT * FROM `cmf_nami_matches` WHERE ( `match_time` > 1779917272 ) AND ( ( competition_id in (select cid from cmf_nami_competitions where recommend=1) ) ) ORDER BY `match_time` ASC LIMIT 100 [ RunTime:0.006643s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` IN (398,396,151,1,543,542,293,201,184,109,7306,195,202,121,46,435,152,15,186) [ RunTime:0.003004s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` IN (398,396,151,1,543,542,293,201,184,109,7306,195,202,121,46,435,152,15,186) [ RunTime:0.002811s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (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,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,10210,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,10818,11393,10464,14101,10521) [ RunTime:0.004075s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (10137,10219) [ RunTime:0.002843s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (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,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,10210,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,10818,11393,10464,14101,10521) [ RunTime:0.004299s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (10137,10219) [ RunTime:0.006627s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1891 LIMIT 1 [ RunTime:0.002538s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 1891 [ RunTime:0.003437s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` WHERE ( `category_id` IN (1891,1892,1893) ) ORDER BY `create_time` DESC LIMIT 0,6 [ RunTime:0.003768s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.009377s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1891 LIMIT 1 [ RunTime:0.005707s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1891 LIMIT 1 [ RunTime:0.003810s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 1891 [ RunTime:0.003830s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` WHERE ( `category_id` IN (1891,1892,1893) ) ORDER BY `create_time` DESC LIMIT 0,9 [ RunTime:0.004559s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.005584s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1891 LIMIT 1 [ RunTime:0.002800s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1891 LIMIT 1 [ RunTime:0.002536s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1891 LIMIT 1 [ RunTime:0.002506s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_tag` [ RunTime:0.003642s ]
[ SQL ] SELECT * FROM `cmf_portal_tag` WHERE `site_id` = 311 AND `status` = 1 LIMIT 20 [ RunTime:0.003848s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = "" LIMIT 1 [ RunTime:0.004288s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = "" [ RunTime:0.007125s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` ORDER BY `create_time` DESC LIMIT 0,10 [ RunTime:0.002934s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.005822s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5463 LIMIT 1 [ RunTime:0.002674s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5457 LIMIT 1 [ RunTime:0.003401s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5439 LIMIT 1 [ RunTime:0.003068s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5445 LIMIT 1 [ RunTime:0.002435s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5451 LIMIT 1 [ RunTime:0.002664s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5433 LIMIT 1 [ RunTime:0.006303s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5427 LIMIT 1 [ RunTime:0.004865s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5421 LIMIT 1 [ RunTime:0.002797s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5415 LIMIT 1 [ RunTime:0.597142s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5403 LIMIT 1 [ RunTime:0.002901s ]
[ 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.005710s ]