[ DB ] CONNECT:[ UseTime:0.009216s ] mysql:host=rm-3ns41jmtlb1g0zd6v.mysql.rds.aliyuncs.com;port=3306;dbname=daxiong_qianli;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `cmf_plugin_web` [ RunTime:0.009304s ]
[ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%op.zxzbomf.net%' LIMIT 1 [ RunTime:0.005862s ]
[ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `erji` = 'op' LIMIT 1 [ RunTime:0.005571s ]
[ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%zxzbomf.net%' LIMIT 1 [ RunTime:0.004587s ]
[ SQL ] SHOW COLUMNS FROM `cmf_plugin` [ RunTime:0.007392s ]
[ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Web' LIMIT 1 [ RunTime:0.005083s ]
[ SQL ] SHOW COLUMNS FROM `cmf_option` [ RunTime:0.007344s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'cdn_settings' AND `site_id` = 6 LIMIT 1 [ RunTime:0.024396s ]
[ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 6 LIMIT 1 [ RunTime:0.010054s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'site_info' AND `site_id` = 6 LIMIT 1 [ RunTime:0.031906s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.007370s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` WHERE `status` = 1 [ RunTime:0.030092s ]
[ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 6 LIMIT 1 [ RunTime:0.005852s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_competitions` [ RunTime:0.029143s ]
[ SQL ] SELECT `pinyin` FROM `cmf_nami_competitions` WHERE `id` = 640 LIMIT 1 [ RunTime:0.009910s ]
[ SQL ] SELECT `com_type` FROM `cmf_nami_competitions` WHERE `id` = 640 LIMIT 1 [ RunTime:0.014157s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `pinyin` = 'hanklian' LIMIT 1 [ RunTime:0.004950s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nav_menu` [ RunTime:0.174067s ]
[ SQL ] SELECT `name`,`href` FROM `cmf_nav_menu` WHERE `nav_id` = 1 AND `parent_id` = 0 AND `status` = 1 AND `site_id` = 6 [ RunTime:0.005239s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_competition_hot` [ RunTime:0.007883s ]
[ SQL ] SELECT `cid` FROM `cmf_nami_competition_hot` WHERE `site_id` = 6 [ RunTime:0.006194s ]
[ SQL ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.133000s ]
[ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = '24_zhibo_9' AND ( `is_public` = 1 OR `file` = 'portal/index' ) [ RunTime:0.004028s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `site_id` = 6 AND `alias` LIKE '%luxiang%' LIMIT 1 [ RunTime:0.005075s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `site_id` = 6 AND `parent_id` IS NULL [ RunTime:0.002879s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `site_id` = 6 AND `alias` LIKE '%news%' LIMIT 1 [ RunTime:0.004810s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `site_id` = 6 AND `parent_id` = 61 [ RunTime:0.003851s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `site_id` = 6 AND `alias` LIKE '%news%' LIMIT 1 [ RunTime:0.004123s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `site_id` = 6 AND `parent_id` = 61 [ RunTime:0.006392s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `site_id` = 6 AND `alias` LIKE '%news%' LIMIT 1 [ RunTime:0.003734s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `site_id` = 6 AND `parent_id` = 61 [ RunTime:0.004145s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `site_id` = 6 AND `alias` LIKE '%news%' LIMIT 1 [ RunTime:0.006042s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `site_id` = 6 AND `parent_id` = 61 [ RunTime:0.008609s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'storage' LIMIT 1 [ RunTime:0.002602s ]
[ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Oss' LIMIT 1 [ RunTime:0.017567s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'cdn_settings' AND `site_id` = 6 LIMIT 1 [ RunTime:0.003190s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nav` [ RunTime:0.062185s ]
[ SQL ] SELECT `id` FROM `cmf_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.006862s ]
[ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `site_id` = 6 AND `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.005203s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'site_info' AND `site_id` = 6 LIMIT 1 [ RunTime:0.025738s ]
[ 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.040429s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 61 LIMIT 1 [ RunTime:0.008881s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 61 [ RunTime:0.004872s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_news` [ RunTime:0.108081s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` WHERE ( `category_id` IN (61,62,63) ) ORDER BY `create_time` DESC LIMIT 0,1 [ RunTime:0.007247s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.008156s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 61 LIMIT 1 [ RunTime:0.004104s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 61 LIMIT 1 [ RunTime:0.006399s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 61 [ RunTime:0.004205s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` WHERE ( `category_id` IN (61,62,63) ) ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.008986s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.032430s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 61 LIMIT 1 [ RunTime:0.006204s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 61 LIMIT 1 [ RunTime:0.007877s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 61 LIMIT 1 [ RunTime:0.006737s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 61 LIMIT 1 [ RunTime:0.004622s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_matches` [ RunTime:0.008495s ]
[ SQL ] SELECT * FROM `cmf_nami_matches` WHERE ( `match_time` > 1780165405 ) AND ( ( competition_id in (select cid from cmf_nami_competitions where recommend=1) ) ) ORDER BY `match_time` ASC LIMIT 20 [ RunTime:0.020591s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` IN (435,121,152,1,542,184,195,293,15,186) [ RunTime:0.007415s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` IN (435,121,152,1,542,184,195,293,15,186) [ RunTime:0.004135s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_teams` [ RunTime:0.030144s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (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) [ RunTime:0.008216s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (10219,10137) [ RunTime:0.009757s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (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) [ RunTime:0.010314s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (10219,10137) [ RunTime:0.012648s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `pinyin` = 'hanklian' AND `com_type` = 0 LIMIT 1 [ RunTime:0.008469s ]
[ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `competition_id` = 581 AND `com_type` = 0 AND ( `match_time` > 1780165405 ) ORDER BY `match_time` ASC LIMIT 100 [ RunTime:0.005742s ]
[ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `competition_id` = 581 AND `com_type` = 0 ORDER BY `match_time` DESC LIMIT 20 [ RunTime:0.003382s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` = 581 [ RunTime:0.040821s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` = 581 [ RunTime:0.003981s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (10438,10694,10305,30993,10439,10652,10415,23021,10417,10416,20060,10238) [ RunTime:0.007306s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (10438,10694,10305,30993,10439,10652,10415,23021,10417,10416,20060,10238) [ RunTime:0.003867s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `pinyin` = 'hanklian' AND `com_type` = 0 LIMIT 1 [ RunTime:0.011437s ]
[ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `competition_id` = 581 AND `com_type` = 0 AND ( `match_time` > 1780165405 ) ORDER BY `match_time` ASC LIMIT 300 [ RunTime:0.003917s ]
[ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `competition_id` = 581 AND `com_type` = 0 ORDER BY `match_time` DESC LIMIT 20 [ RunTime:0.005663s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` = 581 [ RunTime:0.003093s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` = 581 [ RunTime:0.003839s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (10438,10694,10305,30993,10439,10652,10415,23021,10417,10416,20060,10238) [ RunTime:0.016429s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (10438,10694,10305,30993,10439,10652,10415,23021,10417,10416,20060,10238) [ RunTime:0.005099s ]
[ SQL ] SELECT * FROM `cmf_nami_matches` WHERE ( `match_time` > 1780165405 ) AND ( ( competition_id in (select cid from cmf_nami_competitions where recommend=1) ) ) ORDER BY `match_time` ASC LIMIT 100 [ RunTime:0.067201s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` IN (435,121,152,1,542,184,195,293,15,186,202,2918,490,544) [ RunTime:0.017828s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` IN (435,121,152,1,542,184,195,293,15,186,202,2918,490,544) [ RunTime:0.006147s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (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.012512s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (10219,10137) [ RunTime:0.029609s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (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.010034s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (10219,10137) [ RunTime:0.034938s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 61 LIMIT 1 [ RunTime:0.003806s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 61 [ RunTime:0.008030s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` WHERE ( `category_id` IN (61,62,63) ) ORDER BY `create_time` DESC LIMIT 0,6 [ RunTime:0.005879s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.006452s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 61 LIMIT 1 [ RunTime:0.022487s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'storage' LIMIT 1 [ RunTime:0.002641s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'cdn_settings' AND `site_id` = 6 LIMIT 1 [ RunTime:0.004889s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 61 LIMIT 1 [ RunTime:0.023683s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 61 [ RunTime:0.005270s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` WHERE ( `category_id` IN (61,62,63) ) ORDER BY `create_time` DESC LIMIT 0,9 [ RunTime:0.008183s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.007896s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 61 LIMIT 1 [ RunTime:0.005278s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 61 LIMIT 1 [ RunTime:0.006384s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 61 LIMIT 1 [ RunTime:0.005889s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_tag` [ RunTime:0.174055s ]
[ SQL ] SELECT * FROM `cmf_portal_tag` WHERE `site_id` = 6 AND `status` = 1 LIMIT 20 [ RunTime:0.004435s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = "" LIMIT 1 [ RunTime:0.002953s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = "" [ RunTime:0.004282s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` ORDER BY `create_time` DESC LIMIT 0,10 [ RunTime:0.002854s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.004490s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 91 LIMIT 1 [ RunTime:0.004191s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 2203 LIMIT 1 [ RunTime:0.003570s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 3709 LIMIT 1 [ RunTime:0.003935s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 2209 LIMIT 1 [ RunTime:0.008686s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 3859 LIMIT 1 [ RunTime:0.014787s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 2311 LIMIT 1 [ RunTime:0.027670s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 2263 LIMIT 1 [ RunTime:0.006554s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 3715 LIMIT 1 [ RunTime:0.008624s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 2197 LIMIT 1 [ RunTime:0.003247s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1447 LIMIT 1 [ RunTime:0.004415s ]
[ 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.006767s ]