[ DB ] CONNECT:[ UseTime:0.004546s ] mysql:host=rm-3ns41jmtlb1g0zd6v.mysql.rds.aliyuncs.com;port=3306;dbname=daxiong_qianli;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `cmf_plugin_web` [ RunTime:0.002832s ]
[ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.cschengding.com%' LIMIT 1 [ RunTime:0.003096s ]
[ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `erji` = 'www' LIMIT 1 [ RunTime:0.002641s ]
[ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%cschengding.com%' LIMIT 1 [ RunTime:0.002712s ]
[ SQL ] SHOW COLUMNS FROM `cmf_plugin` [ RunTime:0.002723s ]
[ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Web' LIMIT 1 [ RunTime:0.002392s ]
[ SQL ] SHOW COLUMNS FROM `cmf_option` [ RunTime:0.002705s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'cdn_settings' AND `site_id` = 334 LIMIT 1 [ RunTime:0.002563s ]
[ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 334 LIMIT 1 [ RunTime:0.002521s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'site_info' AND `site_id` = 334 LIMIT 1 [ RunTime:0.002780s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.002772s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` WHERE `status` = 1 [ RunTime:0.003907s ]
[ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 334 LIMIT 1 [ RunTime:0.002834s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_competitions` [ RunTime:0.002928s ]
[ SQL ] SELECT `pinyin` FROM `cmf_nami_competitions` WHERE `id` = 2419 LIMIT 1 [ RunTime:0.002633s ]
[ SQL ] SELECT `com_type` FROM `cmf_nami_competitions` WHERE `id` = 2419 LIMIT 1 [ RunTime:0.002498s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `pinyin` = 'nba' LIMIT 1 [ RunTime:0.004606s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nav_menu` [ RunTime:0.002728s ]
[ SQL ] SELECT `name`,`href` FROM `cmf_nav_menu` WHERE `nav_id` = 1 AND `parent_id` = 0 AND `status` = 1 AND `site_id` = 334 [ RunTime:0.002864s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_competition_hot` [ RunTime:0.002652s ]
[ SQL ] SELECT `cid` FROM `cmf_nami_competition_hot` WHERE `site_id` = 334 [ RunTime:0.002707s ]
[ SQL ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.003322s ]
[ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = '24_zhibo_12' AND ( `is_public` = 1 OR `file` = 'portal/index' ) [ RunTime:0.002724s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'storage' LIMIT 1 [ RunTime:0.002586s ]
[ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Oss' LIMIT 1 [ RunTime:0.002577s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nav` [ RunTime:0.002753s ]
[ SQL ] SELECT `id` FROM `cmf_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.002507s ]
[ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `site_id` = 334 AND `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.002825s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_matches` [ RunTime:0.002929s ]
[ SQL ] SELECT * FROM `cmf_nami_matches` WHERE ( `match_time` > 1773766114 ) AND ( ( competition_id in (select cid from cmf_nami_competitions where recommend=1) ) ) ORDER BY `match_time` ASC LIMIT 30 [ RunTime:0.004706s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` IN (315,46,109,169,161,83,84,429) [ RunTime:0.003016s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` IN (315,46,109,169,161,83,84,429) [ RunTime:0.002892s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_teams` [ RunTime:0.002952s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (10195,11741,10206,10236,10759,13496,12094,10441,10376,19328,10427,10084,11265,10442,13307,11077,16508,15775,12619,12424,11503,11344,11076,10764,20748,10798,10022,10498,11843,12503,10128,11501,10007,10533,10102,10570,11412,10177,10114,12913,11840,11352,10127,10173,10256,10862,10817,11428,10023,11115,10129,10248,10180,10368,10181,10217,10215,10054,11532,10105) [ RunTime:0.003028s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (10195,11741,10206,10236,10759,13496,12094,10441,10376,19328,10427,10084,11265,10442,13307,11077,16508,15775,12619,12424,11503,11344,11076,10764,20748,10798,10022,10498,11843,12503,10128,11501,10007,10533,10102,10570,11412,10177,10114,12913,11840,11352,10127,10173,10256,10862,10817,11428,10023,11115,10129,10248,10180,10368,10181,10217,10215,10054,11532,10105) [ RunTime:0.003535s ]
[ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `com_type` = 1 AND ( `match_time` > 1773766115 ) ORDER BY `match_time` ASC LIMIT 100 [ RunTime:0.003272s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` IN (240,1,3) [ RunTime:0.002946s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` IN (240,1,3) [ RunTime:0.002909s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (10673,10622,11491,10679,10352,10682,10672,10686,10120,10219,10123,10133,10118,10135,10115,10122,10156,10131,10136,10127,11093,10853,10148,10116,10119,10137,10728,10725,10361,10326,10731,10727,10793,10722,10360,10730,10729,10721,10124,10155,10134,10132,10117,10114,10121,10154,10129,10130,10125,10126,10128,10149,10732,10726,11380,36563,10273,11072,10724,10734) [ RunTime:0.003503s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (10673,10622,11491,10679,10352,10682,10672,10686,10120,10219,10123,10133,10118,10135,10115,10122,10156,10131,10136,10127,11093,10853,10148,10116,10119,10137,10728,10725,10361,10326,10731,10727,10793,10722,10360,10730,10729,10721,10124,10155,10134,10132,10117,10114,10121,10154,10129,10130,10125,10126,10128,10149,10732,10726,11380,36563,10273,11072,10724,10734) [ RunTime:0.003143s ]
[ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `com_type` = 0 AND ( `match_time` > 1773766117 ) ORDER BY `match_time` ASC LIMIT 100 [ RunTime:0.004446s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` IN (315,2791,301,3357,277,1693,351,3185,716,627,7240,7180,348,46,245,132,221,285,224,109,213,671,1699,682,1875,3397,144,642,646,411,179,97,169,655,2000,7200,3008,89,85,731,1696,34,7512,3377,87,2914,88,91,160,161,86) [ RunTime:0.004679s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` IN (315,2791,301,3357,277,1693,351,3185,716,627,7240,7180,348,46,245,132,221,285,224,109,213,671,1699,682,1875,3397,144,642,646,411,179,97,169,655,2000,7200,3008,89,85,731,1696,34,7512,3377,87,2914,88,91,160,161,86) [ RunTime:0.003904s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (10195,11741,30957,70501,45771,69583,56830,40518,34629,48217,19225,47230,31539,34072,10678,11678,50783,54911,14818,42182,20384,16202,17684,23246,85529,85523,85613,85564,85528,85499,10266,12148,10206,10236,10285,11346,10697,30208,39622,24187,39590,15707,34472,16213,10641,10642,10759,13496,24218,13251,23132,57472,30997,14041,15592,15522,24343,54559,15523,16945,44210,37921,37637,37730,38606,37337,28273,14289,14220,86466,13938,28159,14471,49637,70021,70022,14702,10352,32629,58126,32588,38919,23944,30133,33574,10434,18410,15261,17351,13630,17408,21783,16448,24688,28604,28845,26112,28844,72387,29754,24779,72176,30427,31231,32987,31232,12094,10441,10376,19328,10427,10084,11265,10442,13307,11077,16508,15775,12619,12424,11503,11344,33400,26190,30989,22490,37724,37728,50391,37302,37862,39007,15138,31313,11076,10764,63655,27456,19598,13140,11429,14652,18047,26323,92685,39201,45108,87633,29313,19511,21454,22735,69581,70265,23048,72482,16129,10732,16936,17644,16897,15566,16094,14593,12423,17027,21955,11178,10424,12214,42832,25294,77035,15797,17022,22048,24578,13042,20748,10798,11862,22654,27712,16446,18760,18938,16655,11841,85825,14611,14131,20391,19298,20740,11530,11528,25320,11502,10569,10859) [ RunTime:0.004838s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (10195,11741,30957,70501,45771,69583,56830,40518,34629,48217,19225,47230,31539,34072,10678,11678,50783,54911,14818,42182,20384,16202,17684,23246,85529,85523,85613,85564,85528,85499,10266,12148,10206,10236,10285,11346,10697,30208,39622,24187,39590,15707,34472,16213,10641,10642,10759,13496,24218,13251,23132,57472,30997,14041,15592,15522,24343,54559,15523,16945,44210,37921,37637,37730,38606,37337,28273,14289,14220,86466,13938,28159,14471,49637,70021,70022,14702,10352,32629,58126,32588,38919,23944,30133,33574,10434,18410,15261,17351,13630,17408,21783,16448,24688,28604,28845,26112,28844,72387,29754,24779,72176,30427,31231,32987,31232,12094,10441,10376,19328,10427,10084,11265,10442,13307,11077,16508,15775,12619,12424,11503,11344,33400,26190,30989,22490,37724,37728,50391,37302,37862,39007,15138,31313,11076,10764,63655,27456,19598,13140,11429,14652,18047,26323,92685,39201,45108,87633,29313,19511,21454,22735,69581,70265,23048,72482,16129,10732,16936,17644,16897,15566,16094,14593,12423,17027,21955,11178,10424,12214,42832,25294,77035,15797,17022,22048,24578,13042,20748,10798,11862,22654,27712,16446,18760,18938,16655,11841,85825,14611,14131,20391,19298,20740,11530,11528,25320,11502,10569,10859) [ RunTime:0.004785s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = "" LIMIT 1 [ RunTime:0.002573s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = "" [ RunTime:0.002699s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_news` [ RunTime:0.003071s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` ORDER BY `create_time` DESC LIMIT 0,10 [ RunTime:0.002944s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.003035s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 645 LIMIT 1 [ RunTime:0.002591s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 39 LIMIT 1 [ RunTime:0.002429s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 3 LIMIT 1 [ RunTime:0.002397s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 3 LIMIT 1 [ RunTime:0.002452s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 267 LIMIT 1 [ RunTime:0.002503s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 261 LIMIT 1 [ RunTime:0.002441s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 255 LIMIT 1 [ RunTime:0.002848s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 249 LIMIT 1 [ RunTime:0.002632s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 243 LIMIT 1 [ RunTime:0.002417s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 237 LIMIT 1 [ RunTime:0.002507s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = "" LIMIT 1 [ RunTime:0.002402s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = "" [ RunTime:0.002787s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` ORDER BY `create_time` DESC LIMIT 0,10 [ RunTime:0.003195s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.002801s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 645 LIMIT 1 [ RunTime:0.002689s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 39 LIMIT 1 [ RunTime:0.002531s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 3 LIMIT 1 [ RunTime:0.002457s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 3 LIMIT 1 [ RunTime:0.002597s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 267 LIMIT 1 [ RunTime:0.002704s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 261 LIMIT 1 [ RunTime:0.002524s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 255 LIMIT 1 [ RunTime:0.002559s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 249 LIMIT 1 [ RunTime:0.002487s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 243 LIMIT 1 [ RunTime:0.002439s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 237 LIMIT 1 [ RunTime:0.002714s ]
[ SQL ] SELECT `competition_id` FROM `cmf_plugin_web` WHERE `id` = 334 LIMIT 1 [ RunTime:0.002789s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `id` = 2419 LIMIT 1 [ RunTime:0.003070s ]
[ SQL ] SELECT * FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `competition_id` = 1 ORDER BY `id` DESC LIMIT 50 [ RunTime:0.003006s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'site_info' AND `site_id` = 334 LIMIT 1 [ RunTime:0.002596s ]
[ 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.004368s ]
