[ DB ] CONNECT:[ UseTime:0.004329s ] mysql:host=rm-3ns41jmtlb1g0zd6v.mysql.rds.aliyuncs.com;port=3306;dbname=daxiong_7000;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `cmf_plugin_web` [ RunTime:0.002709s ]
[ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.yellowrivercloudcable.cn%' LIMIT 1 [ RunTime:0.003126s ]
[ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `erji` = 'www' LIMIT 1 [ RunTime:0.002671s ]
[ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%yellowrivercloudcable.cn%' LIMIT 1 [ RunTime:0.003024s ]
[ SQL ] SHOW COLUMNS FROM `cmf_plugin` [ RunTime:0.003236s ]
[ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Web' LIMIT 1 [ RunTime:0.002606s ]
[ SQL ] SHOW COLUMNS FROM `cmf_option` [ RunTime:0.002859s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'cdn_settings' AND `site_id` = 846 LIMIT 1 [ RunTime:0.002546s ]
[ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 846 LIMIT 1 [ RunTime:0.002704s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'site_info' AND `site_id` = 846 LIMIT 1 [ RunTime:0.002659s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.002660s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` WHERE `status` = 1 [ RunTime:0.007167s ]
[ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 846 LIMIT 1 [ RunTime:0.002850s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_competitions` [ RunTime:0.002936s ]
[ SQL ] SELECT `pinyin` FROM `cmf_nami_competitions` WHERE `id` = 4540 LIMIT 1 [ RunTime:0.002644s ]
[ SQL ] SELECT `com_type` FROM `cmf_nami_competitions` WHERE `id` = 4540 LIMIT 1 [ RunTime:0.002624s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `pinyin` = 'shijubei' LIMIT 1 [ RunTime:0.004771s ]
[ SQL ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.002852s ]
[ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = '24_zhibo_12' AND ( `is_public` = 1 OR `file` = 'portal/index' ) [ RunTime:0.002764s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'storage' LIMIT 1 [ RunTime:0.002610s ]
[ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Oss' LIMIT 1 [ RunTime:0.002529s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nav` [ RunTime:0.002658s ]
[ SQL ] SELECT `id` FROM `cmf_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.002557s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nav_menu` [ RunTime:0.002719s ]
[ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `site_id` = 846 AND `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.003911s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_matches` [ RunTime:0.002954s ]
[ SQL ] SELECT * FROM `cmf_nami_matches` WHERE ( `match_time` > 1781243801 ) AND ( ( competition_id in (select cid from cmf_nami_competitions where recommend=1) ) ) ORDER BY `match_time` ASC LIMIT 30 [ RunTime:0.008377s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` IN (293,1,543,544,15,7306,195) [ RunTime:0.002834s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` IN (293,1,543,544,15,7306,195) [ RunTime:0.002764s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_teams` [ RunTime:0.002934s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (30028,25763,10230,26539,11138,10478,13611,13449,10700,50536,74781,71374,87560,70470,75354,33141,18279,91657,71266,69951,53113,14347,60821,14346,82059,74787,70468,70460,13028,87226,60823,74788,59324,59325,88258,88256,88257,88251,88260,88255,10973,12597,10746,15475,34311,74630,27993,27727,10436,10387,10972,10744,27598,17260,10540,10437,10687,14343,59326,59330) [ RunTime:0.003288s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (30028,25763,10230,26539,11138,10478,13611,13449,10700,50536,74781,71374,87560,70470,75354,33141,18279,91657,71266,69951,53113,14347,60821,14346,82059,74787,70468,70460,13028,87226,60823,74788,59324,59325,88258,88256,88257,88251,88260,88255,10973,12597,10746,15475,34311,74630,27993,27727,10436,10387,10972,10744,27598,17260,10540,10437,10687,14343,59326,59330) [ RunTime:0.003079s ]
[ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `com_type` = 1 AND ( `match_time` > 1781243801 ) ORDER BY `match_time` ASC LIMIT 100 [ RunTime:0.002751s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` = 1 [ RunTime:0.002624s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` = 1 [ RunTime:0.002600s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (10137,10115) [ RunTime:0.002699s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (10137,10115) [ RunTime:0.002785s ]
[ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `com_type` = 0 AND ( `match_time` > 1781243801 ) ORDER BY `match_time` ASC LIMIT 100 [ RunTime:0.003322s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` IN (3524,1964,593,591,595,1871,586,600,651,1796,2815,293,198,196,197,301,361,3478,300,1740,228,229,1,280,481,430,462,1878,570,866,597,3282,829) [ RunTime:0.003091s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` IN (3524,1964,593,591,595,1871,586,600,651,1796,2815,293,198,196,197,301,361,3478,300,1740,228,229,1,280,481,430,462,1878,570,866,597,3282,829) [ RunTime:0.002974s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (80638,93261,57068,17676,45751,25193,57351,17539,22868,69747,30337,40567,24134,24237,28778,30092,24803,29054,23804,28714,24135,21910,28420,22124,33265,30477,75456,80627,27419,30093,76271,93264,29950,93584,76744,20551,59835,34046,45046,86886,30028,25763,48037,77688,51245,49771,24285,18980,25725,12047,45796,12255,18598,14573,11887,34114,13298,81914,60755,23259,60750,35021,59738,17046,21115,19175,10230,26539,26055,23606,22040,40507,54117,27559,73985,79880,17604,24217,11886,27298,81865,13498,47981,53995,10459,10067,10163,10484,10111,10333,10462,10161,10095,10162,10722,11189,73932,11924,60356,11406,13912,10483,11138,10478,15344,27085,14104,14701,27849,52596,21717,80220,23203,29511,11624,11718,13611,13449,13700,16761,15268,35085,16411,17201,26473,26449,14166,28245,30273,29902,30550,34626,14790,74382,60370,30022,28236,40556,46216,28463,46665,22738,45461,30223,46215,29879,45735,23974,26040,40341,69774,87506,22850,74350,35804,50604,15714,74348,35528,40469,87505,81211,92621,57260,30169,30091,26775,26776,29757,31282,28779,30445,34447,87515,33710,41056,45470,29147,13088,26431,26446,22284,23359,45358,30332,45496,33625,34426,75464,80439,26176,26308,39776,35334,33638,14496,25654,26152,45359,21054) [ RunTime:0.004327s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (80638,93261,57068,17676,45751,25193,57351,17539,22868,69747,30337,40567,24134,24237,28778,30092,24803,29054,23804,28714,24135,21910,28420,22124,33265,30477,75456,80627,27419,30093,76271,93264,29950,93584,76744,20551,59835,34046,45046,86886,30028,25763,48037,77688,51245,49771,24285,18980,25725,12047,45796,12255,18598,14573,11887,34114,13298,81914,60755,23259,60750,35021,59738,17046,21115,19175,10230,26539,26055,23606,22040,40507,54117,27559,73985,79880,17604,24217,11886,27298,81865,13498,47981,53995,10459,10067,10163,10484,10111,10333,10462,10161,10095,10162,10722,11189,73932,11924,60356,11406,13912,10483,11138,10478,15344,27085,14104,14701,27849,52596,21717,80220,23203,29511,11624,11718,13611,13449,13700,16761,15268,35085,16411,17201,26473,26449,14166,28245,30273,29902,30550,34626,14790,74382,60370,30022,28236,40556,46216,28463,46665,22738,45461,30223,46215,29879,45735,23974,26040,40341,69774,87506,22850,74350,35804,50604,15714,74348,35528,40469,87505,81211,92621,57260,30169,30091,26775,26776,29757,31282,28779,30445,34447,87515,33710,41056,45470,29147,13088,26431,26446,22284,23359,45358,30332,45496,33625,34426,75464,80439,26176,26308,39776,35334,33638,14496,25654,26152,45359,21054) [ RunTime:0.004206s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5101 LIMIT 1 [ RunTime:0.002693s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 5101 [ RunTime:0.003367s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_news` [ RunTime:0.002721s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` WHERE ( `category_id` IN (5101,5102,5103) ) ORDER BY `create_time` DESC LIMIT 0,10 [ RunTime:0.003472s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.004093s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = "" LIMIT 1 [ RunTime:0.002866s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = "" [ RunTime:0.003642s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` ORDER BY `create_time` DESC LIMIT 0,10 [ RunTime:0.002586s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.003747s ]
[ SQL ] SELECT `competition_id` FROM `cmf_plugin_web` WHERE `id` = 846 LIMIT 1 [ RunTime:0.002648s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `id` = 4540 LIMIT 1 [ RunTime:0.002650s ]
[ SQL ] SELECT * FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `competition_id` = 7221 ORDER BY `id` DESC LIMIT 50 [ RunTime:0.002561s ]
[ 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.002878s ]
[ SQL ] SELECT `id` FROM `cmf_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.002591s ]
[ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `site_id` = 846 AND `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.003940s ]
[ SQL ] SELECT * FROM `cmf_nami_matches` WHERE ( `match_time` > 1781243801 ) AND ( ( competition_id in (select cid from cmf_nami_competitions where recommend=1) ) ) ORDER BY `match_time` ASC LIMIT 30 [ RunTime:0.005204s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` IN (293,1,543,544,15,7306,195) [ RunTime:0.002934s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` IN (293,1,543,544,15,7306,195) [ RunTime:0.002892s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (30028,25763,10230,26539,11138,10478,13611,13449,10700,50536,74781,71374,87560,70470,75354,33141,18279,91657,71266,69951,53113,14347,60821,14346,82059,74787,70468,70460,13028,87226,60823,74788,59324,59325,88258,88256,88257,88251,88260,88255,10973,12597,10746,15475,34311,74630,27993,27727,10436,10387,10972,10744,27598,17260,10540,10437,10687,14343,59326,59330) [ RunTime:0.003072s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (30028,25763,10230,26539,11138,10478,13611,13449,10700,50536,74781,71374,87560,70470,75354,33141,18279,91657,71266,69951,53113,14347,60821,14346,82059,74787,70468,70460,13028,87226,60823,74788,59324,59325,88258,88256,88257,88251,88260,88255,10973,12597,10746,15475,34311,74630,27993,27727,10436,10387,10972,10744,27598,17260,10540,10437,10687,14343,59326,59330) [ RunTime:0.003143s ]
[ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `com_type` = 1 AND ( `match_time` > 1781243801 ) ORDER BY `match_time` ASC LIMIT 100 [ RunTime:0.002918s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` = 1 [ RunTime:0.002704s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` = 1 [ RunTime:0.002737s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (10137,10115) [ RunTime:0.002704s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (10137,10115) [ RunTime:0.002649s ]
[ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `com_type` = 0 AND ( `match_time` > 1781243801 ) ORDER BY `match_time` ASC LIMIT 100 [ RunTime:0.003054s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` IN (3524,1964,593,591,595,1871,586,600,651,1796,2815,293,198,196,197,301,361,3478,300,1740,228,229,1,280,481,430,462,1878,570,866,597,3282,829) [ RunTime:0.003042s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` IN (3524,1964,593,591,595,1871,586,600,651,1796,2815,293,198,196,197,301,361,3478,300,1740,228,229,1,280,481,430,462,1878,570,866,597,3282,829) [ RunTime:0.004331s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (80638,93261,57068,17676,45751,25193,57351,17539,22868,69747,30337,40567,24134,24237,28778,30092,24803,29054,23804,28714,24135,21910,28420,22124,33265,30477,75456,80627,27419,30093,76271,93264,29950,93584,76744,20551,59835,34046,45046,86886,30028,25763,48037,77688,51245,49771,24285,18980,25725,12047,45796,12255,18598,14573,11887,34114,13298,81914,60755,23259,60750,35021,59738,17046,21115,19175,10230,26539,26055,23606,22040,40507,54117,27559,73985,79880,17604,24217,11886,27298,81865,13498,47981,53995,10459,10067,10163,10484,10111,10333,10462,10161,10095,10162,10722,11189,73932,11924,60356,11406,13912,10483,11138,10478,15344,27085,14104,14701,27849,52596,21717,80220,23203,29511,11624,11718,13611,13449,13700,16761,15268,35085,16411,17201,26473,26449,14166,28245,30273,29902,30550,34626,14790,74382,60370,30022,28236,40556,46216,28463,46665,22738,45461,30223,46215,29879,45735,23974,26040,40341,69774,87506,22850,74350,35804,50604,15714,74348,35528,40469,87505,81211,92621,57260,30169,30091,26775,26776,29757,31282,28779,30445,34447,87515,33710,41056,45470,29147,13088,26431,26446,22284,23359,45358,30332,45496,33625,34426,75464,80439,26176,26308,39776,35334,33638,14496,25654,26152,45359,21054) [ RunTime:0.004180s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (80638,93261,57068,17676,45751,25193,57351,17539,22868,69747,30337,40567,24134,24237,28778,30092,24803,29054,23804,28714,24135,21910,28420,22124,33265,30477,75456,80627,27419,30093,76271,93264,29950,93584,76744,20551,59835,34046,45046,86886,30028,25763,48037,77688,51245,49771,24285,18980,25725,12047,45796,12255,18598,14573,11887,34114,13298,81914,60755,23259,60750,35021,59738,17046,21115,19175,10230,26539,26055,23606,22040,40507,54117,27559,73985,79880,17604,24217,11886,27298,81865,13498,47981,53995,10459,10067,10163,10484,10111,10333,10462,10161,10095,10162,10722,11189,73932,11924,60356,11406,13912,10483,11138,10478,15344,27085,14104,14701,27849,52596,21717,80220,23203,29511,11624,11718,13611,13449,13700,16761,15268,35085,16411,17201,26473,26449,14166,28245,30273,29902,30550,34626,14790,74382,60370,30022,28236,40556,46216,28463,46665,22738,45461,30223,46215,29879,45735,23974,26040,40341,69774,87506,22850,74350,35804,50604,15714,74348,35528,40469,87505,81211,92621,57260,30169,30091,26775,26776,29757,31282,28779,30445,34447,87515,33710,41056,45470,29147,13088,26431,26446,22284,23359,45358,30332,45496,33625,34426,75464,80439,26176,26308,39776,35334,33638,14496,25654,26152,45359,21054) [ RunTime:0.004006s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 5101 LIMIT 1 [ RunTime:0.002772s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 5101 [ RunTime:0.003378s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` WHERE ( `category_id` IN (5101,5102,5103) ) ORDER BY `create_time` DESC LIMIT 0,10 [ RunTime:0.003379s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.003837s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = "" LIMIT 1 [ RunTime:0.002490s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = "" [ RunTime:0.003978s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` ORDER BY `create_time` DESC LIMIT 0,10 [ RunTime:0.002717s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.004208s ]
[ SQL ] SELECT `competition_id` FROM `cmf_plugin_web` WHERE `id` = 846 LIMIT 1 [ RunTime:0.003015s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `id` = 4540 LIMIT 1 [ RunTime:0.003139s ]
[ SQL ] SELECT * FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `competition_id` = 7221 ORDER BY `id` DESC LIMIT 50 [ RunTime:0.002883s ]
[ 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.003134s ]
