[ DB ] CONNECT:[ UseTime:0.004658s ] mysql:host=rm-3nshzqnuo6110gvp4.mysql.rds.aliyuncs.com;port=3306;dbname=daxiong_xym;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `cmf_plugin_web` [ RunTime:0.002783s ]
[ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%lqr.org.cn%' LIMIT 1 [ RunTime:0.002800s ]
[ SQL ] SHOW COLUMNS FROM `cmf_plugin` [ RunTime:0.002739s ]
[ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Web' LIMIT 1 [ RunTime:0.002490s ]
[ SQL ] SHOW COLUMNS FROM `cmf_option` [ RunTime:0.002591s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'cdn_settings' AND `site_id` = 188 LIMIT 1 [ RunTime:0.002528s ]
[ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 188 LIMIT 1 [ RunTime:0.006142s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'site_info' AND `site_id` = 188 LIMIT 1 [ RunTime:0.005593s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.002857s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` WHERE `status` = 1 [ RunTime:0.004993s ]
[ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 188 LIMIT 1 [ RunTime:0.002562s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_competitions` [ RunTime:0.002789s ]
[ SQL ] SELECT `pinyin` FROM `cmf_nami_competitions` WHERE `id` = 100 LIMIT 1 [ RunTime:0.002472s ]
[ SQL ] SELECT `com_type` FROM `cmf_nami_competitions` WHERE `id` = 100 LIMIT 1 [ RunTime:0.002511s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `pinyin` = 'yijia' LIMIT 1 [ RunTime:0.002994s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nav_menu` [ RunTime:0.002924s ]
[ SQL ] SELECT `name`,`href` FROM `cmf_nav_menu` WHERE `nav_id` = 1 AND `parent_id` = 0 AND `status` = 1 AND `site_id` = 188 [ RunTime:0.003024s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_competition_hot` [ RunTime:0.002876s ]
[ SQL ] SELECT `cid` FROM `cmf_nami_competition_hot` WHERE `site_id` = 188 [ RunTime:0.008589s ]
[ SQL ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.003474s ]
[ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = '24_zhibo_5' AND ( `is_public` = 1 OR `file` = 'portal/index' ) [ RunTime:0.004445s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `site_id` = 188 AND `alias` LIKE '%news%' LIMIT 1 [ RunTime:0.002687s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `site_id` = 188 AND `parent_id` = 1153 [ RunTime:0.004764s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `site_id` = 188 AND `alias` LIKE '%news%' LIMIT 1 [ RunTime:0.002983s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `site_id` = 188 AND `parent_id` = 1153 [ RunTime:0.003011s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `site_id` = 188 AND `alias` LIKE '%luxiang%' LIMIT 1 [ RunTime:0.003934s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `site_id` = 188 AND `parent_id` = 1889 [ RunTime:0.003082s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `site_id` = 188 AND `alias` LIKE '%luxiang%' LIMIT 1 [ RunTime:0.003283s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `site_id` = 188 AND `parent_id` = 1889 [ RunTime:0.003281s ]
[ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'storage' LIMIT 1 [ RunTime:0.002782s ]
[ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Oss' LIMIT 1 [ RunTime:0.003739s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nav` [ RunTime:0.002599s ]
[ SQL ] SELECT `id` FROM `cmf_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.002350s ]
[ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `site_id` = 188 AND `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.003022s ]
[ 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 5 [ RunTime:0.003025s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `pinyin` = 'yijia' AND `com_type` = 0 LIMIT 1 [ RunTime:0.002953s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_matches` [ RunTime:0.003043s ]
[ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `competition_id` = 108 AND `com_type` = 0 AND ( `match_time` > 1780583654 ) ORDER BY `match_time` ASC LIMIT 100 [ RunTime:0.003720s ]
[ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `competition_id` = 108 AND `com_type` = 0 ORDER BY `match_time` DESC LIMIT 20 [ RunTime:0.003329s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` = 108 [ RunTime:0.002696s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` = 108 [ RunTime:0.002703s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nami_teams` [ RunTime:0.002884s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (10906,11194,16822,11343,10467,10059,10811,10420,13402,10907,10692,11848,11060,10068,10297,13403,18581,10421,10456,13075) [ RunTime:0.002891s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (10906,11194,16822,11343,10467,10059,10811,10420,13402,10907,10692,11848,11060,10068,10297,13403,18581,10421,10456,13075) [ RunTime:0.002708s ]
[ SQL ] SELECT * FROM `cmf_nami_matches` WHERE ( `match_time` > 1780583654 ) AND ( ( competition_id in (select cid from cmf_nami_competitions where recommend=1) ) ) ORDER BY `match_time` ASC LIMIT 100 [ RunTime:0.012443s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` IN (490,2918,544,15,1,186,202,613,293,543,7306,195) [ RunTime:0.003928s ]
[ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` IN (490,2918,544,15,1,186,202,613,293,543,7306,195) [ RunTime:0.002951s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (10585,12160,87569,92784,32680,87571,92787,92791,92790,92786,70468,87560,33225,17758,17494,33132,82386,92794,79409,87577,74805,87572,70425,92793,18279,70460,19861,33521,21292,48482,93038,14994,18435,69682,27299,10597,28345,14272,11401,12553,12669,12865,31055,10121,13823,18549,22971,30960,19501,40945,16752,40285,28749,10596,12758,60675,40366,12458,18968,24236,11802,35962,11472,14018,15141,33102,14496,46147,11764,10310,10586,10979,30028,25763,10230,26539,11138,10478,13611,13449,10700,50536,74781,71374,70470,75354,33141,91657,71266,69951,53113,14347,60821,14346,82059,74787,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,11289,10871,10477,11763,11089,10868,13832,13337,48371,75181,74782,70423,60822,23094,60824,74666,34313,53112,40074,82384,82062,81608,71376,87225,10523,11564,10491,10521,10632,10237,14101,12663,10489,13078,11722,15874,12217,11311) [ RunTime:0.004577s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (10137,10115) [ RunTime:0.008620s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (10585,12160,87569,92784,32680,87571,92787,92791,92790,92786,70468,87560,33225,17758,17494,33132,82386,92794,79409,87577,74805,87572,70425,92793,18279,70460,19861,33521,21292,48482,93038,14994,18435,69682,27299,10597,28345,14272,11401,12553,12669,12865,31055,10121,13823,18549,22971,30960,19501,40945,16752,40285,28749,10596,12758,60675,40366,12458,18968,24236,11802,35962,11472,14018,15141,33102,14496,46147,11764,10310,10586,10979,30028,25763,10230,26539,11138,10478,13611,13449,10700,50536,74781,71374,70470,75354,33141,91657,71266,69951,53113,14347,60821,14346,82059,74787,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,11289,10871,10477,11763,11089,10868,13832,13337,48371,75181,74782,70423,60822,23094,60824,74666,34313,53112,40074,82384,82062,81608,71376,87225,10523,11564,10491,10521,10632,10237,14101,12663,10489,13078,11722,15874,12217,11311) [ RunTime:0.005945s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (10137,10115) [ RunTime:0.004599s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1889 LIMIT 1 [ RunTime:0.005420s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 1889 [ RunTime:0.007519s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_news` [ RunTime:0.004100s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` ORDER BY `create_time` DESC LIMIT 0,10 [ RunTime:0.002694s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.007515s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1889 LIMIT 1 [ RunTime:0.008514s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 1889 [ RunTime:0.006275s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` ORDER BY `create_time` DESC LIMIT 0,10 [ RunTime:0.002956s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.005823s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1153 LIMIT 1 [ RunTime:0.002805s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 1153 [ RunTime:0.006410s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` WHERE ( `category_id` IN (1153,1154,1155) ) ORDER BY `create_time` DESC LIMIT 0,10 [ RunTime:0.003033s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.005258s ]
[ SQL ] SELECT `alias` FROM `cmf_portal_category` WHERE `id` = 1153 LIMIT 1 [ RunTime:0.002881s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 1153 [ RunTime:0.003513s ]
[ SQL ] SELECT * FROM `cmf_portal_news` `post` WHERE ( `category_id` IN (1153,1154,1155) ) ORDER BY `create_time` DESC LIMIT 0,10 [ RunTime:0.005629s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.005140s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_tag` [ RunTime:0.002820s ]
[ SQL ] SELECT * FROM `cmf_portal_tag` WHERE `site_id` = 188 AND `status` = 1 LIMIT 20 [ RunTime:0.002545s ]