2025-06-13
2025-06-14
2025-06-15
2025-06-16
2025-06-17
2025-06-18
2025-06-19
2025-06-20
2025-06-21
2025-06-22
2025-06-23
2025-06-24
2025-06-25
2025-06-26
基本
文件
流程
错误
SQL
调试
请求信息 : 2025-06-13 11:25:36 HTTP/1.1 GET : http://rwy.org.cn/football/ 运行时间 : 0.618897s [ 吞吐率:1.62req/s ] 内存消耗:6,340.83kb 文件加载:142 查询信息 : 85 queries 10 writes 缓存信息 : 6 reads,3 writes
[ LANG ] /mnt/7kzhanqun_xym/vendor/thinkphp/lang/zh-cn.php [ DB ] INIT mysql [ LANG ] /mnt/7kzhanqun_xym/vendor/thinkcmf/cmf/src/behavior/../lang/zh-cn.php [ LANG ] /mnt/7kzhanqun_xym/vendor/thinkcmf/cmf-app/src/admin/lang/zh-cn.php [ LANG ] /mnt/7kzhanqun_xym/vendor/thinkcmf/cmf-app/src/admin/lang/zh-cn/common.php [ LANG ] /mnt/7kzhanqun_xym/vendor/thinkcmf/cmf-app/src/user/lang/zh-cn.php [ LANG ] /mnt/7kzhanqun_xym/app/portal/lang/zh-cn/common.php [ LANG ] /mnt/7kzhanqun_xym/app/portal//lang/zh-cn.php [ ROUTE ] array (
'rule' => 'football',
'route' => 'portal/Competition/index?type=0',
'option' =>
array (
'merge_rule_regex' => false,
),
'var' =>
array (
),
) [ HEADER ] array (
'connection' => 'Keep-Alive',
'host' => 'rwy.org.cn',
'accept-encoding' => 'br,gzip',
'accept-language' => 'en-US,en;q=0.5',
'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8',
'user-agent' => 'CCBot/2.0 (https://commoncrawl.org/faq/)',
'content-length' => '',
'content-type' => '',
) [ PARAM ] array (
'type' => '0',
) [ LANG ] /mnt/7kzhanqun_xym/app/portal/lang/zh-cn/home.php [ VIEW ] /mnt/7kzhanqun_xym/public/themes/24_zhibo_15/portal/competition.html [ array (
0 => 'site_info',
1 => 'event_info',
2 => 'categories',
3 => 'front_theme',
4 => 'hot',
5 => 'com_type',
6 => 'date',
7 => 'competition_name',
8 => 'navigation',
9 => 'pinyin',
10 => 'tdk',
11 => 'introduce',
12 => 'competition',
13 => 'theme_vars',
14 => 'theme_widgets',
) ]
[ DB ] CONNECT:[ UseTime:0.003322s ] mysql:host=rm-3nshzqnuo6110gvp4.mysql.rds.aliyuncs.com;port=3306;dbname=daxiong_xym;charset=utf8mb4 [ SQL ] SHOW COLUMNS FROM `cmf_plugin_web` [ RunTime:0.002025s ] [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%rwy.org.cn%' LIMIT 1 [ RunTime:0.001738s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 237,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_plugin_web` WHERE `web_url` LIKE '%rwy.org.cn%' [ RunTime:0.001792s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 237,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ] [ SQL ] SHOW COLUMNS FROM `cmf_visit_24` [ RunTime:0.001982s ] [ SQL ] INSERT INTO `cmf_visit_24` (`param` , `url` , `ip` , `domain` , `referer` , `browser` , `created_at` , `updated_at`) VALUES ('{\"type\":\"0\"}' , '/football/' , '18.97.14.86' , 'rwy.org.cn' , '' , 'Other' , '2025-06-13 11:25:36' , '2025-06-13 11:25:36') [ RunTime:0.001970s ] [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%rwy.org.cn%' LIMIT 1 [ RunTime:0.001751s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 237,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ] [ SQL ] SHOW COLUMNS FROM `cmf_plugin` [ RunTime:0.001904s ] [ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Web' AND `site_id` = 147 LIMIT 1 [ RunTime:0.001874s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 246,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ] [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%rwy.org.cn%' LIMIT 1 [ RunTime:0.001649s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 237,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ] [ SQL ] SHOW COLUMNS FROM `cmf_option` [ RunTime:0.001824s ] [ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'cdn_settings' AND `site_id` = 147 LIMIT 1 [ RunTime:0.001659s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_option',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'site_id',
'key' => 'site_id',
'key_len' => '5',
'ref' => 'const',
'rows' => 5,
'filtered' => 10.0,
'extra' => 'Using where',
) ] [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%rwy.org.cn%' LIMIT 1 [ RunTime:0.001739s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 237,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ] [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%rwy.org.cn%' LIMIT 1 [ RunTime:0.001731s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 237,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ] [ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 147 LIMIT 1 [ RunTime:0.001649s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ] [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%rwy.org.cn%' LIMIT 1 [ RunTime:0.002275s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 237,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ] [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%rwy.org.cn%' LIMIT 1 [ RunTime:0.001703s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 237,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ] [ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'site_info' AND `site_id` = 147 LIMIT 1 [ RunTime:0.001738s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_option',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'site_id',
'key' => 'site_id',
'key_len' => '5',
'ref' => 'const',
'rows' => 5,
'filtered' => 10.0,
'extra' => 'Using where',
) ] [ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.001865s ] [ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` WHERE `status` = 1 [ RunTime:0.002687s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 1434,
'filtered' => 10.0,
'extra' => 'Using where',
) ] [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%rwy.org.cn%' LIMIT 1 [ RunTime:0.001763s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 237,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ] [ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 147 LIMIT 1 [ RunTime:0.001671s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ] [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%rwy.org.cn%' LIMIT 1 [ RunTime:0.001649s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 237,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ] [ SQL ] SHOW COLUMNS FROM `cmf_nami_competition_hot` [ RunTime:0.001751s ] [ SQL ] SELECT `cid` FROM `cmf_nami_competition_hot` WHERE `site_id` = 147 [ RunTime:0.001902s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_competition_hot',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 769,
'filtered' => 10.0,
'extra' => 'Using where',
) ] [ SQL ] SHOW COLUMNS FROM `cmf_nami_competitions` [ RunTime:0.002048s ] [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 LIMIT 1 [ RunTime:0.001977s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_competitions',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 3895,
'filtered' => 10.0,
'extra' => 'Using where',
) ] [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%rwy.org.cn%' LIMIT 1 [ RunTime:0.001674s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 237,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ] [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%rwy.org.cn%' LIMIT 1 [ RunTime:0.001654s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 237,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ] [ SQL ] SHOW COLUMNS FROM `cmf_nav_menu` [ RunTime:0.001704s ] [ SQL ] SELECT `name`,`href` FROM `cmf_nav_menu` WHERE `nav_id` = 1 AND `parent_id` = 0 AND `status` = 1 AND `site_id` = 147 [ RunTime:0.002012s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nav_menu',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 1548,
'filtered' => 0.06459948420524597,
'extra' => 'Using where',
) ] [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%rwy.org.cn%' LIMIT 1 [ RunTime:0.001722s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 237,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ] [ SQL ] SHOW COLUMNS FROM `cmf_nami_matches` [ RunTime:0.002005s ] [ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `competition_id` = 1 AND `com_type` = 0 AND `match_time` > 1749785136 LIMIT 100 [ RunTime:0.005628s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_matches',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'com_type,match_time,season_id',
'key' => 'season_id',
'key_len' => '5',
'ref' => 'const',
'rows' => 2191,
'filtered' => 1.5407477617263794,
'extra' => 'Using where',
) ] [ SQL ] SHOW COLUMNS FROM `cmf_nami_teams` [ RunTime:0.002013s ] [ SQL ] SELECT `short_name_zh` FROM `cmf_nami_teams` WHERE `cid` IN ('') AND `com_type` = 0 [ RunTime:0.001740s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => NULL,
'partitions' => NULL,
'type' => NULL,
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => NULL,
'filtered' => NULL,
'extra' => 'no matching row in const table',
) ] [ SQL ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.001878s ] [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = '24_zhibo_15' AND `file` = 'portal/article' LIMIT 1 [ RunTime:0.001965s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 388,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ] [ SQL ] UPDATE `cmf_theme_file` SET `theme` = '24_zhibo_15' , `action` = 'portal/Article/index' , `file` = 'portal/article' , `name` = '文章页' , `more` = '{\"vars\":[]}' , `config_more` = '{\"vars\":[]}' , `description` = '文章页模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = '24_zhibo_15' AND `file` = 'portal/article' [ RunTime:0.001951s ] [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = '24_zhibo_15' AND `file` = 'portal/competition' LIMIT 1 [ RunTime:0.002247s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 388,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ] [ SQL ] UPDATE `cmf_theme_file` SET `theme` = '24_zhibo_15' , `action` = 'portal/Competition/index' , `file` = 'portal/competition' , `name` = '赛程列表页' , `more` = '{\"vars\":[]}' , `config_more` = '{\"vars\":[]}' , `description` = '赛程列表模板文件' , `is_public` = 0 , `list_order` = 0 WHERE `theme` = '24_zhibo_15' AND `file` = 'portal/competition' [ RunTime:0.002097s ] [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = '24_zhibo_15' AND `file` = 'portal/index' LIMIT 1 [ RunTime:0.002105s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 388,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ] [ SQL ] UPDATE `cmf_theme_file` SET `theme` = '24_zhibo_15' , `action` = 'portal/Index/index' , `file` = 'portal/index' , `name` = '首页' , `more` = '{\"vars\":{\"name\":{\"title\":\"\\u59d3\\u540d\",\"value\":\"\",\"type\":\"text\",\"placeholder\":\"\\u8bf7\\u586b\\u5199\\u7528\\u6237\\u59d3\\u540d\",\"tip\":\"\\u8bbe\\u7f6e\\u540e\\u60a8\\u7684\\u59d3\\u540d\\u5c06\\u4f1a\\u663e\\u793a\\u5728\\u9996\\u9875\",\"rule\":{\"require\":true}}}}' , `config_more` = '{\"vars\":{\"name\":{\"title\":\"\\u59d3\\u540d\",\"value\":\"\",\"type\":\"text\",\"placeholder\":\"\\u8bf7\\u586b\\u5199\\u7528\\u6237\\u59d3\\u540d\",\"tip\":\"\\u8bbe\\u7f6e\\u540e\\u60a8\\u7684\\u59d3\\u540d\\u5c06\\u4f1a\\u663e\\u793a\\u5728\\u9996\\u9875\",\"rule\":{\"require\":true}}}}' , `description` = '首页模板文件' , `is_public` = 0 , `list_order` = 5 WHERE `theme` = '24_zhibo_15' AND `file` = 'portal/index' [ RunTime:0.002017s ] [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = '24_zhibo_15' AND `file` = 'portal/list' LIMIT 1 [ RunTime:0.002022s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 388,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ] [ SQL ] UPDATE `cmf_theme_file` SET `theme` = '24_zhibo_15' , `action` = 'portal/List/index' , `file` = 'portal/list' , `name` = '文章列表页' , `more` = '{\"vars\":[],\"widgets\":{\"hottest_articles\":{\"title\":\"\\u70ed\\u95e8\\u6587\\u7ae0\",\"display\":\"1\",\"vars\":{\"hottest_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"last_articles\":{\"title\":\"\\u6700\\u65b0\\u53d1\\u5e03\",\"display\":\"1\",\"vars\":{\"last_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}' , `config_more` = '{\"vars\":[],\"widgets\":{\"hottest_articles\":{\"title\":\"\\u70ed\\u95e8\\u6587\\u7ae0\",\"display\":\"1\",\"vars\":{\"hottest_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"last_articles\":{\"title\":\"\\u6700\\u65b0\\u53d1\\u5e03\",\"display\":\"1\",\"vars\":{\"last_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}' , `description` = '文章列表模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = '24_zhibo_15' AND `file` = 'portal/list' [ RunTime:0.002259s ] [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = '24_zhibo_15' AND `file` = 'portal/match' LIMIT 1 [ RunTime:0.001881s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 388,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ] [ SQL ] UPDATE `cmf_theme_file` SET `theme` = '24_zhibo_15' , `action` = 'portal/Match/index' , `file` = 'portal/match' , `name` = '赛事详情页' , `more` = '{\"vars\":[]}' , `config_more` = '{\"vars\":[]}' , `description` = '赛事详情页模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = '24_zhibo_15' AND `file` = 'portal/match' [ RunTime:0.001951s ] [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = '24_zhibo_15' AND `file` = 'portal/page' LIMIT 1 [ RunTime:0.001866s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 388,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ] [ SQL ] UPDATE `cmf_theme_file` SET `theme` = '24_zhibo_15' , `action` = 'portal/Page/index' , `file` = 'portal/page' , `name` = '文章页' , `more` = '{\"vars\":[]}' , `config_more` = '{\"vars\":[]}' , `description` = '文章页模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = '24_zhibo_15' AND `file` = 'portal/page' [ RunTime:0.001982s ] [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = '24_zhibo_15' AND `file` = 'portal/search' LIMIT 1 [ RunTime:0.002110s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 388,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ] [ SQL ] UPDATE `cmf_theme_file` SET `theme` = '24_zhibo_15' , `action` = 'portal/List/index' , `file` = 'portal/search' , `name` = '文章列表页' , `more` = '{\"vars\":[],\"widgets\":{\"hottest_articles\":{\"title\":\"\\u70ed\\u95e8\\u6587\\u7ae0\",\"display\":\"1\",\"vars\":{\"hottest_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"last_articles\":{\"title\":\"\\u6700\\u65b0\\u53d1\\u5e03\",\"display\":\"1\",\"vars\":{\"last_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}' , `config_more` = '{\"vars\":[],\"widgets\":{\"hottest_articles\":{\"title\":\"\\u70ed\\u95e8\\u6587\\u7ae0\",\"display\":\"1\",\"vars\":{\"hottest_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"last_articles\":{\"title\":\"\\u6700\\u65b0\\u53d1\\u5e03\",\"display\":\"1\",\"vars\":{\"last_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}' , `description` = '文章列表模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = '24_zhibo_15' AND `file` = 'portal/search' [ RunTime:0.002129s ] [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = '24_zhibo_15' AND `file` = 'portal/tag' LIMIT 1 [ RunTime:0.001882s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 388,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ] [ SQL ] UPDATE `cmf_theme_file` SET `theme` = '24_zhibo_15' , `action` = 'portal/Tag/index' , `file` = 'portal/tag' , `name` = '文章标签页' , `more` = '{\"vars\":[],\"widgets\":{\"hottest_articles\":{\"title\":\"\\u70ed\\u95e8\\u6587\\u7ae0\",\"display\":\"1\",\"vars\":{\"hottest_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"last_articles\":{\"title\":\"\\u6700\\u65b0\\u53d1\\u5e03\",\"display\":\"1\",\"vars\":{\"last_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}' , `config_more` = '{\"vars\":[],\"widgets\":{\"hottest_articles\":{\"title\":\"\\u70ed\\u95e8\\u6587\\u7ae0\",\"display\":\"1\",\"vars\":{\"hottest_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"last_articles\":{\"title\":\"\\u6700\\u65b0\\u53d1\\u5e03\",\"display\":\"1\",\"vars\":{\"last_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}' , `description` = '文章标签模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = '24_zhibo_15' AND `file` = 'portal/tag' [ RunTime:0.002139s ] [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = '24_zhibo_15' [ RunTime:0.002042s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 388,
'filtered' => 9.999999046325684,
'extra' => 'Using where',
) ] [ SQL ] SHOW COLUMNS FROM `cmf_theme` [ RunTime:0.001917s ] [ SQL ] UPDATE `cmf_theme` SET `name` = '二级域名' , `version` = '1.0.0' , `demo_url` = 'http://www.sdylsl.com/' , `author` = '老谭' , `lang` = 'zh-cn' , `keywords` = '二级域名' , `description` = '二级域名' WHERE `theme` = '24_zhibo_15' [ RunTime:0.001738s ] [ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = '24_zhibo_15' AND ( `is_public` = 1 OR `file` = 'portal/competition' ) [ RunTime:0.001901s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 388,
'filtered' => 1.899999976158142,
'extra' => 'Using where',
) ] [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%rwy.org.cn%' LIMIT 1 [ RunTime:0.001691s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 237,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ] [ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'storage' AND `site_id` = 147 LIMIT 1 [ RunTime:0.001640s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_option',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'site_id',
'key' => 'site_id',
'key_len' => '5',
'ref' => 'const',
'rows' => 5,
'filtered' => 10.0,
'extra' => 'Using where',
) ] [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%rwy.org.cn%' LIMIT 1 [ RunTime:0.001767s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 237,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ] [ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Oss' AND `site_id` = 147 LIMIT 1 [ RunTime:0.001793s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 246,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ] [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%rwy.org.cn%' LIMIT 1 [ RunTime:0.001720s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 237,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ] [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%rwy.org.cn%' LIMIT 1 [ RunTime:0.001656s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 237,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ] [ SQL ] SHOW COLUMNS FROM `cmf_nav` [ RunTime:0.001867s ] [ SQL ] SELECT `id` FROM `cmf_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.001657s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nav',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 2,
'filtered' => 50.0,
'extra' => 'Using where',
) ] [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `site_id` = 147 AND `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.002067s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nav_menu',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 1548,
'filtered' => 0.10000000149011612,
'extra' => 'Using where; Using filesort',
) ] [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%rwy.org.cn%' LIMIT 1 [ RunTime:0.001734s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 237,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ] [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%rwy.org.cn%' LIMIT 1 [ RunTime:0.001709s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 237,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ] [ 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.003645s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_competitions',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '4',
'ref' => NULL,
'rows' => 14,
'filtered' => 100.0,
'extra' => 'Using where; Using filesort',
) ] [ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `com_type` = 0 AND ( `match_time` > 1749774336 ) AND ( ( competition_id in (select cid from cmf_nami_competitions where recommend=1) ) ) ORDER BY `match_time` ASC LIMIT 300 [ RunTime:0.009923s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_matches',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'com_type,match_time,season_id',
'key' => 'com_type',
'key_len' => '7',
'ref' => NULL,
'rows' => 4575,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ] [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` IN (435,2918,15,581,544,542,293,457,613,567,568,195,543,186,202,52,397,121,109,555,201) [ RunTime:0.004183s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_competitions',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'cid',
'key' => 'cid',
'key_len' => '7',
'ref' => NULL,
'rows' => 21,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ] [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` IN (435,2918,15,581,544,542,293,457,613,567,568,195,543,186,202,52,397,121,109,555,201) [ RunTime:0.002240s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_competitions',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'cid',
'key' => 'cid',
'key_len' => '7',
'ref' => NULL,
'rows' => 21,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ] [ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (10757,10818,10813,10211,33160,70465,87565,74667,87557,80472,15266,22223,23021,10238,10415,10305,87560,87563,60823,82384,70469,23094,50542,10139,11900,18057,10230,25763,30028,27598,10471,13248,17260,27611,45111,16743,11074,10444,87790,29146,10767,19717,75181,13028,82059,82062,71376,53146,11681,25413,10334,10062,13756,10908,15733,10526,70423,60827,10652,10417,10439,10190,21947,30993,10061,10457,53336,70422,10009,10700,10746,10541,27993,33141,34291,14347,14272,14896,13823,15164,24236,40366,70439,50536,48126,34313,60824,53112,69951,60822,87225,87226,45373,10223,10766,48130,10218,10138,15475,10387,14994,44917,11801,27299,22971,15423,10596,16752,12758,28749,36069,56162,15874,10489,14229,14111,10687,10972,13899,12155,11722,11577,14343,25725,10744,10973,10437,10436,27727,26539,13547,13737,13738,11209,10311,14084,73924,10487,10461,34314,10112,11073,11071,63659,10097,26480,12095,11072,60286,10110,10096,10098,17129,87068,10806,10460,10494,12186,11764,20020,10066,10336,26428,24121,16122,30510,25333,16160,10527,10593,10069,14475,28038,13543,18279,74787,70460,40074,70470,71374,81608,70441,10070,10525,10327,10380,21978,10898,11195,25412,10337,10071,10909,23959,15734,10060,71266,70468,74630,14346,48371,74666,34311,53113,74782,60821,10858,12217,18968,33270,11472,31855,69682,11401,28663,12669,30960,40945,19501,35962,14101,14018,11564,12115,11666,13078,10632,10491,11212,13639,10343,13801,11441,11847,10631,10237,12434,10729,10296,10578,12156,11020,11144,13611,10634,11089,10584,11837,24514,12064,20137,11708,12065,28503,26302,26516,40126,22588,22026,60494,21117,33203,11139,11138,11016,10438,20273,10236,10269,10488,10695,31055,18435,10633,10523,23373,10521,10522,11311,10696,11578,16383,10273,10490,10187,10416,39883) [ RunTime:0.004688s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_teams',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'cid',
'key' => 'cid',
'key_len' => '7',
'ref' => NULL,
'rows' => 287,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ] [ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (10757,10818,10813,10211,33160,70465,87565,74667,87557,80472,15266,22223,23021,10238,10415,10305,87560,87563,60823,82384,70469,23094,50542,10139,11900,18057,10230,25763,30028,27598,10471,13248,17260,27611,45111,16743,11074,10444,87790,29146,10767,19717,75181,13028,82059,82062,71376,53146,11681,25413,10334,10062,13756,10908,15733,10526,70423,60827,10652,10417,10439,10190,21947,30993,10061,10457,53336,70422,10009,10700,10746,10541,27993,33141,34291,14347,14272,14896,13823,15164,24236,40366,70439,50536,48126,34313,60824,53112,69951,60822,87225,87226,45373,10223,10766,48130,10218,10138,15475,10387,14994,44917,11801,27299,22971,15423,10596,16752,12758,28749,36069,56162,15874,10489,14229,14111,10687,10972,13899,12155,11722,11577,14343,25725,10744,10973,10437,10436,27727,26539,13547,13737,13738,11209,10311,14084,73924,10487,10461,34314,10112,11073,11071,63659,10097,26480,12095,11072,60286,10110,10096,10098,17129,87068,10806,10460,10494,12186,11764,20020,10066,10336,26428,24121,16122,30510,25333,16160,10527,10593,10069,14475,28038,13543,18279,74787,70460,40074,70470,71374,81608,70441,10070,10525,10327,10380,21978,10898,11195,25412,10337,10071,10909,23959,15734,10060,71266,70468,74630,14346,48371,74666,34311,53113,74782,60821,10858,12217,18968,33270,11472,31855,69682,11401,28663,12669,30960,40945,19501,35962,14101,14018,11564,12115,11666,13078,10632,10491,11212,13639,10343,13801,11441,11847,10631,10237,12434,10729,10296,10578,12156,11020,11144,13611,10634,11089,10584,11837,24514,12064,20137,11708,12065,28503,26302,26516,40126,22588,22026,60494,21117,33203,11139,11138,11016,10438,20273,10236,10269,10488,10695,31055,18435,10633,10523,23373,10521,10522,11311,10696,11578,16383,10273,10490,10187,10416,39883) [ RunTime:0.011937s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_teams',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'cid',
'key' => 'cid',
'key_len' => '7',
'ref' => NULL,
'rows' => 287,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ] [ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `com_type` = 0 AND ( `match_time` > 1749774337 ) AND ( ( competition_id in (select cid from cmf_nami_competitions where recommend=1) ) ) ORDER BY `match_time` ASC LIMIT 300 [ RunTime:0.009029s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_matches',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'com_type,match_time,season_id',
'key' => 'com_type',
'key_len' => '7',
'ref' => NULL,
'rows' => 4575,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ] [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` IN (435,2918,15,581,544,542,293,457,613,567,568,195,543,186,202,52,397,121,109,555,201) [ RunTime:0.003025s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_competitions',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'cid',
'key' => 'cid',
'key_len' => '7',
'ref' => NULL,
'rows' => 21,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ] [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` IN (435,2918,15,581,544,542,293,457,613,567,568,195,543,186,202,52,397,121,109,555,201) [ RunTime:0.002094s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_competitions',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'cid',
'key' => 'cid',
'key_len' => '7',
'ref' => NULL,
'rows' => 21,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ] [ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (10757,10818,10813,10211,33160,70465,87565,74667,87557,80472,15266,22223,23021,10238,10415,10305,87560,87563,60823,82384,70469,23094,50542,10139,11900,18057,10230,25763,30028,27598,10471,13248,17260,27611,45111,16743,11074,10444,87790,29146,10767,19717,75181,13028,82059,82062,71376,53146,11681,25413,10334,10062,13756,10908,15733,10526,70423,60827,10652,10417,10439,10190,21947,30993,10061,10457,53336,70422,10009,10700,10746,10541,27993,33141,34291,14347,14272,14896,13823,15164,24236,40366,70439,50536,48126,34313,60824,53112,69951,60822,87225,87226,45373,10223,10766,48130,10218,10138,15475,10387,14994,44917,11801,27299,22971,15423,10596,16752,12758,28749,36069,56162,15874,10489,14229,14111,10687,10972,13899,12155,11722,11577,14343,25725,10744,10973,10437,10436,27727,26539,13547,13737,13738,11209,10311,14084,73924,10487,10461,34314,10112,11073,11071,63659,10097,26480,12095,11072,60286,10110,10096,10098,17129,87068,10806,10460,10494,12186,11764,20020,10066,10336,26428,24121,16122,30510,25333,16160,10527,10593,10069,14475,28038,13543,18279,74787,70460,40074,70470,71374,81608,70441,10070,10525,10327,10380,21978,10898,11195,25412,10337,10071,10909,23959,15734,10060,71266,70468,74630,14346,48371,74666,34311,53113,74782,60821,10858,12217,18968,33270,11472,31855,69682,11401,28663,12669,30960,40945,19501,35962,14101,14018,11564,12115,11666,13078,10632,10491,11212,13639,10343,13801,11441,11847,10631,10237,12434,10729,10296,10578,12156,11020,11144,13611,10634,11089,10584,11837,24514,12064,20137,11708,12065,28503,26302,26516,40126,22588,22026,60494,21117,33203,11139,11138,11016,10438,20273,10236,10269,10488,10695,31055,18435,10633,10523,23373,10521,10522,11311,10696,11578,16383,10273,10490,10187,10416,39883) [ RunTime:0.003809s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_teams',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'cid',
'key' => 'cid',
'key_len' => '7',
'ref' => NULL,
'rows' => 287,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ] [ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (10757,10818,10813,10211,33160,70465,87565,74667,87557,80472,15266,22223,23021,10238,10415,10305,87560,87563,60823,82384,70469,23094,50542,10139,11900,18057,10230,25763,30028,27598,10471,13248,17260,27611,45111,16743,11074,10444,87790,29146,10767,19717,75181,13028,82059,82062,71376,53146,11681,25413,10334,10062,13756,10908,15733,10526,70423,60827,10652,10417,10439,10190,21947,30993,10061,10457,53336,70422,10009,10700,10746,10541,27993,33141,34291,14347,14272,14896,13823,15164,24236,40366,70439,50536,48126,34313,60824,53112,69951,60822,87225,87226,45373,10223,10766,48130,10218,10138,15475,10387,14994,44917,11801,27299,22971,15423,10596,16752,12758,28749,36069,56162,15874,10489,14229,14111,10687,10972,13899,12155,11722,11577,14343,25725,10744,10973,10437,10436,27727,26539,13547,13737,13738,11209,10311,14084,73924,10487,10461,34314,10112,11073,11071,63659,10097,26480,12095,11072,60286,10110,10096,10098,17129,87068,10806,10460,10494,12186,11764,20020,10066,10336,26428,24121,16122,30510,25333,16160,10527,10593,10069,14475,28038,13543,18279,74787,70460,40074,70470,71374,81608,70441,10070,10525,10327,10380,21978,10898,11195,25412,10337,10071,10909,23959,15734,10060,71266,70468,74630,14346,48371,74666,34311,53113,74782,60821,10858,12217,18968,33270,11472,31855,69682,11401,28663,12669,30960,40945,19501,35962,14101,14018,11564,12115,11666,13078,10632,10491,11212,13639,10343,13801,11441,11847,10631,10237,12434,10729,10296,10578,12156,11020,11144,13611,10634,11089,10584,11837,24514,12064,20137,11708,12065,28503,26302,26516,40126,22588,22026,60494,21117,33203,11139,11138,11016,10438,20273,10236,10269,10488,10695,31055,18435,10633,10523,23373,10521,10522,11311,10696,11578,16383,10273,10490,10187,10416,39883) [ RunTime:0.003441s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_teams',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'cid',
'key' => 'cid',
'key_len' => '7',
'ref' => NULL,
'rows' => 287,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ] [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%rwy.org.cn%' LIMIT 1 [ RunTime:0.001890s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 237,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ] [ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 910 [ RunTime:0.001947s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 1434,
'filtered' => 10.0,
'extra' => 'Using where',
) ] [ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.002015s ] [ SQL ] SELECT * FROM `cmf_portal_post` `post` WHERE `site_id` = 147 AND `post_status` = 1 AND `post_type` = 1 AND `delete_time` = 0 AND ( `category_id` IN (910,911,912) ) ORDER BY `create_time` DESC LIMIT 0,10 [ RunTime:0.002061s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'type_status_date,category_id,idx_siteid_deletetime_posttype_poststatus_publishedtime,idx_8f8efa778253e4a38b4800acfaedd014',
'key' => 'idx_siteid_deletetime_posttype_poststatus_publishedtime',
'key_len' => '11',
'ref' => 'const,const,const,const',
'rows' => 4,
'filtered' => 30.000001907348633,
'extra' => 'Using index condition; Using where; Using filesort',
) ] [ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.002763s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 1434,
'filtered' => 100.0,
'extra' => NULL,
) ] [ SQL ] SHOW COLUMNS FROM `cmf_user` [ RunTime:0.001922s ] [ SQL ] SELECT `id`,`user_nickname` FROM `cmf_user` [ RunTime:0.001824s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_user',
'partitions' => NULL,
'type' => 'index',
'possible_keys' => NULL,
'key' => 'user_nickname',
'key_len' => '202',
'ref' => NULL,
'rows' => 2,
'filtered' => 100.0,
'extra' => 'Using index',
) ] [ SQL ] SELECT `id`,`avatar` FROM `cmf_user` [ RunTime:0.001696s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_user',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 2,
'filtered' => 100.0,
'extra' => NULL,
) ] [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%rwy.org.cn%' LIMIT 1 [ RunTime:0.001738s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 237,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ] [ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 910 [ RunTime:0.001862s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 1434,
'filtered' => 10.0,
'extra' => 'Using where',
) ] [ SQL ] SELECT * FROM `cmf_portal_post` `post` WHERE `site_id` = 147 AND `post_status` = 1 AND `post_type` = 1 AND `delete_time` = 0 AND ( `category_id` IN (910,911,912) ) ORDER BY `create_time` DESC LIMIT 0,10 [ RunTime:0.002028s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'type_status_date,category_id,idx_siteid_deletetime_posttype_poststatus_publishedtime,idx_8f8efa778253e4a38b4800acfaedd014',
'key' => 'idx_siteid_deletetime_posttype_poststatus_publishedtime',
'key_len' => '11',
'ref' => 'const,const,const,const',
'rows' => 4,
'filtered' => 30.000001907348633,
'extra' => 'Using index condition; Using where; Using filesort',
) ] [ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.002537s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 1434,
'filtered' => 100.0,
'extra' => NULL,
) ] [ SQL ] SELECT `id`,`user_nickname` FROM `cmf_user` [ RunTime:0.001682s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_user',
'partitions' => NULL,
'type' => 'index',
'possible_keys' => NULL,
'key' => 'user_nickname',
'key_len' => '202',
'ref' => NULL,
'rows' => 2,
'filtered' => 100.0,
'extra' => 'Using index',
) ] [ SQL ] SELECT `id`,`avatar` FROM `cmf_user` [ RunTime:0.001778s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_user',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 2,
'filtered' => 100.0,
'extra' => NULL,
) ] [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%rwy.org.cn%' LIMIT 1 [ RunTime:0.001664s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 237,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ] [ SQL ] SHOW COLUMNS FROM `cmf_portal_tag` [ RunTime:0.001815s ] [ SQL ] SELECT * FROM `cmf_portal_tag` WHERE `site_id` = 147 AND `status` = 1 LIMIT 20 [ RunTime:0.036298s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 160785,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
0.621486s