基本(ben)
文件
流程
錯(cuo)誤
SQL
調試
- 請求信息 : 2025-03-07 21:48:59 HTTP/1.1 GET : //sxlrcb.cn/portal/competition/index/pinyin/xiyi.html
- 運行時間 : 0.528652s [ 吞吐率：1.89req/s ] 內存消耗：5,803.45kb 文件加載：143
- 查詢信息 : 64 queries 8 writes
- 緩存信息 : 6 reads,0 writes
- [ LANG ] /mnt/7kzhanqun_erji/vendor/thinkphp/lang/zh-cn.php
- [ DB ] INIT mysql
- [ LANG ] /mnt/7kzhanqun_erji/vendor/thinkcmf/cmf/src/behavior/../lang/zh-cn.php
- [ LANG ] /mnt/7kzhanqun_erji/vendor/thinkcmf/cmf-app/src/admin/lang/zh-cn.php
- [ LANG ] /mnt/7kzhanqun_erji/vendor/thinkcmf/cmf-app/src/admin/lang/zh-cn/common.php
- [ LANG ] /mnt/7kzhanqun_erji/vendor/thinkcmf/cmf-app/src/user/lang/zh-cn.php
- [ LANG ] /mnt/7kzhanqun_erji/app/portal/lang/zh-cn/common.php
- [ LANG ] /mnt/7kzhanqun_erji/app/portal//lang/zh-cn.php
- [ ROUTE ] array (
)
- [ HEADER ] array (
'connection' => 'Close',
'host' => 'sxlrcb.cn',
'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36',
'content-type' => 'text/html',
'accept' => 'text/html, application/xhtml+xml, */*',
'content-length' => '',
)
- [ PARAM ] array (
'pinyin' => 'xiyi',
)
- [ LANG ] /mnt/7kzhanqun_erji/app/portal/lang/zh-cn/home.php
- [ VIEW ] /mnt/7kzhanqun_erji/public/themes/w1sport1/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.003052s ] mysql:host=rm-3nshzqnuo6110gvp4.mysql.rds.aliyuncs.com;port=3306;dbname=daxiong_erji;charset=utf8mb4
- [ SQL ] SHOW COLUMNS FROM `cmf_plugin_web` [ RunTime:0.001872s ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%sxlrcb.cn%' LIMIT 1 [ RunTime:0.001602s ]
- [ 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' => 138,
'filtered' => 11.1562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_plugin_web` WHERE `web_url` LIKE '%sxlrcb.cn%' [ RunTime:0.001584s ]
- [ 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' => 138,
'filtered' => 11.1562,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_visit` [ RunTime:0.001614s ]
- [ SQL ] INSERT INTO `cmf_visit` (`param` , `url` , `ip` , `domain` , `referer` , `browser` , `created_at` , `updated_at`) VALUES ('{\"pinyin\":\"xiyi\"}' , '/portal/competition/index/pinyin/xiyi.html' , '137.175.73.24' , 'sxlrcb.cn' , '' , 'Chrome' , '2025-03-07 21:48:59' , '2025-03-07 21:48:59') [ RunTime:0.001623s ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%sxlrcb.cn%' LIMIT 1 [ RunTime:0.001518s ]
- [ 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' => 138,
'filtered' => 11.1562,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_plugin` [ RunTime:0.001619s ]
- [ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Web' AND `site_id` = 12 LIMIT 1 [ RunTime:0.001630s ]
- [ 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' => 147,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%sxlrcb.cn%' LIMIT 1 [ RunTime:0.001448s ]
- [ 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' => 138,
'filtered' => 11.1562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%sxlrcb.cn%' LIMIT 1 [ RunTime:0.001479s ]
- [ 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' => 138,
'filtered' => 11.1562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%sxlrcb.cn%' LIMIT 1 [ RunTime:0.001447s ]
- [ 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' => 138,
'filtered' => 11.1562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 12 LIMIT 1 [ RunTime:0.001462s ]
- [ 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 '%sxlrcb.cn%' LIMIT 1 [ RunTime:0.001417s ]
- [ 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' => 138,
'filtered' => 11.1562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%sxlrcb.cn%' LIMIT 1 [ RunTime:0.001851s ]
- [ 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' => 138,
'filtered' => 11.1562,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.001751s ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` WHERE `status` = 1 [ RunTime:0.002554s ]
- [ 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' => 840,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%sxlrcb.cn%' LIMIT 1 [ RunTime:0.001521s ]
- [ 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' => 138,
'filtered' => 11.1562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 12 LIMIT 1 [ RunTime:0.001557s ]
- [ 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 ] SHOW COLUMNS FROM `cmf_nami_competitions` [ RunTime:0.001964s ]
- [ SQL ] SELECT `pinyin` FROM `cmf_nami_competitions` WHERE `id` = 588 LIMIT 1 [ RunTime:0.001648s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_competitions',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '4',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `com_type` FROM `cmf_nami_competitions` WHERE `id` = 588 LIMIT 1 [ RunTime:0.001629s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_competitions',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '4',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `pinyin` = 'zhongchao' LIMIT 1 [ RunTime:0.002330s ]
- [ 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' => 3841,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%sxlrcb.cn%' LIMIT 1 [ RunTime:0.001470s ]
- [ 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' => 138,
'filtered' => 11.1562,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_nami_competition_hot` [ RunTime:0.001588s ]
- [ SQL ] SELECT `cid` FROM `cmf_nami_competition_hot` WHERE `site_id` = 12 [ RunTime:0.001532s ]
- [ 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 ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `pinyin` = 'xiyi' LIMIT 1 [ RunTime:0.001692s ]
- [ 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' => 3841,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%sxlrcb.cn%' LIMIT 1 [ RunTime:0.001438s ]
- [ 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' => 138,
'filtered' => 11.1562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%sxlrcb.cn%' LIMIT 1 [ RunTime:0.001495s ]
- [ 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' => 138,
'filtered' => 11.1562,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_nav_menu` [ RunTime:0.001707s ]
- [ SQL ] SELECT `name`,`href` FROM `cmf_nav_menu` WHERE `nav_id` = 1 AND `parent_id` = 0 AND `status` = 1 AND `site_id` = 12 [ RunTime:0.001716s ]
- [ 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' => 954,
'filtered' => 0.560791,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%sxlrcb.cn%' LIMIT 1 [ RunTime:0.001443s ]
- [ 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' => 138,
'filtered' => 11.1562,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_nami_matches` [ RunTime:0.001782s ]
- [ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `competition_id` = 121 AND `com_type` = 0 AND `match_time` > 1741355339 LIMIT 100 [ RunTime:0.002853s ]
- [ 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' => 562,
'filtered' => 7.566,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_nami_teams` [ RunTime:0.001747s ]
- [ SQL ] SELECT `short_name_zh` FROM `cmf_nami_teams` WHERE `cid` IN (10390,10031,10219,10048,10035,10690,10301,12097,10466,10221,10044,10043,10458,14777,10743,10292,11441,11847,10045,15735,10531,18759) AND `com_type` = 0 [ RunTime:0.001688s ]
- [ 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' => 22,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.001756s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'w1sport1' AND `file` = 'portal/article' LIMIT 1 [ RunTime:0.001737s ]
- [ 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' => 340,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'w1sport1' , `action` = 'portal/Article/index' , `file` = 'portal/article' , `name` = '詳細頁' , `more` = '[]' , `config_more` = '[]' , `description` = '詳細頁' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 'w1sport1' AND `file` = 'portal/article' [ RunTime:0.002031s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'w1sport1' AND `file` = 'portal/competition' LIMIT 1 [ RunTime:0.002014s ]
- [ 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' => 340,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'w1sport1' , `action` = 'portal/Competition/index' , `file` = 'portal/competition' , `name` = '賽程列表頁' , `more` = '{\"vars\":[]}' , `config_more` = '{\"vars\":[]}' , `description` = '賽程列表模板文件' , `is_public` = 0 , `list_order` = 0 WHERE `theme` = 'w1sport1' AND `file` = 'portal/competition' [ RunTime:0.001938s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'w1sport1' AND `file` = 'portal/index' LIMIT 1 [ RunTime:0.002092s ]
- [ 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' => 340,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'w1sport1' , `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` = 'w1sport1' AND `file` = 'portal/index' [ RunTime:0.002017s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'w1sport1' AND `file` = 'portal/list' LIMIT 1 [ RunTime:0.001854s ]
- [ 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' => 340,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'w1sport1' , `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` = 'w1sport1' AND `file` = 'portal/list' [ RunTime:0.001910s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'w1sport1' AND `file` = 'portal/match' LIMIT 1 [ RunTime:0.001623s ]
- [ 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' => 340,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'w1sport1' , `action` = 'portal/Match/index' , `file` = 'portal/match' , `name` = '賽事詳情頁' , `more` = '{\"vars\":[]}' , `config_more` = '{\"vars\":[]}' , `description` = '賽事詳情頁模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 'w1sport1' AND `file` = 'portal/match' [ RunTime:0.001888s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'w1sport1' AND `file` = 'portal/tag' LIMIT 1 [ RunTime:0.001673s ]
- [ 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' => 340,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'w1sport1' , `action` = 'portal/Tag/index' , `file` = 'portal/tag' , `name` = '標簽列表頁' , `more` = '[]' , `config_more` = '[]' , `description` = '標簽列表頁' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 'w1sport1' AND `file` = 'portal/tag' [ RunTime:0.001773s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'w1sport1' [ RunTime:0.001708s ]
- [ 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' => 340,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_theme` [ RunTime:0.001690s ]
- [ SQL ] UPDATE `cmf_theme` SET `name` = 'w1sport1' , `version` = '1.0.0' , `demo_url` = '//www.nayangtiancai.com/' , `author` = 'zwe' , `lang` = 'zh-cn' , `keywords` = '//www.nayangtiancai.com/' , `description` = '//www.nayangtiancai.com/' WHERE `theme` = 'w1sport1' [ RunTime:0.001516s ]
- [ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = 'w1sport1' AND ( `is_public` = 1 OR `file` = 'portal/competition' ) [ RunTime:0.001659s ]
- [ 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' => 340,
'filtered' => 1.899999737739563,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%sxlrcb.cn%' LIMIT 1 [ RunTime:0.001527s ]
- [ 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' => 138,
'filtered' => 11.1562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%sxlrcb.cn%' LIMIT 1 [ RunTime:0.001820s ]
- [ 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' => 138,
'filtered' => 11.1562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Oss' AND `site_id` = 12 LIMIT 1 [ RunTime:0.001904s ]
- [ 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' => 147,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%sxlrcb.cn%' LIMIT 1 [ RunTime:0.001452s ]
- [ 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' => 138,
'filtered' => 11.1562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%sxlrcb.cn%' LIMIT 1 [ RunTime:0.001504s ]
- [ 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' => 138,
'filtered' => 11.1562,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_nav` [ RunTime:0.003386s ]
- [ SQL ] SELECT `id` FROM `cmf_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.002316s ]
- [ 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` = 12 AND `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.002613s ]
- [ 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' => 954,
'filtered' => 0.560791,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%sxlrcb.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' => 138,
'filtered' => 11.1562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `com_type` = 0 AND ( `match_time` > 1741344539 ) AND ( ( competition_id in (select cid from cmf_nami_competitions where recommend=1) ) ) ORDER BY `match_time` ASC LIMIT 1000 [ RunTime:0.023719s ]
- [ 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' => 18872,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` IN (238,293,220,130,315,121,152,176,168,169,109,175,108,142,83,151,429,465,613,466,568,581,567,589,590,316,82,84,258,347,120,161,159,457,267,266,243,396,555,543,158,575,3,2906,4,2922,490,542,201) [ RunTime:0.004622s ]
- [ 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' => 49,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` IN (238,293,220,130,315,121,152,176,168,169,109,175,108,142,83,151,429,465,613,466,568,581,567,589,590,316,82,84,258,347,120,161,159,457,267,266,243,396,555,543,158,575,3,2906,4,2922,490,542,201) [ RunTime:0.002483s ]
- [ 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' => 49,
'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 (32737,10592,25763,30028,10230,27611,14509,23944,17131,11925,17327,10398,35623,25693,10683,10365,11350,10590,10589,10853,32773,11009,10035,10690,10899,11151,71635,12015,21331,26367,10085,10378,10077,10104,10091,10107,10399,10382,12568,10376,10379,10433,22288,19328,10084,10647,10329,10443,10455,10427,11265,10442,17739,16508,10133,10002,10294,24289,10456,10811,10976,10492,10184,10571,10219,10048,11523,11838,10083,10339,10303,10164,33035,10093,15107,11386,16418,21062,87520,74397,11404,13194,71325,24095,34447,30309,30334,30335,74154,28779,32771,87521,87522,40412,10593,28038,74175,31755,21947,10305,10298,21978,13543,25333,81297,40097,20057,34265,81298,18777,45637,31369,10066,10327,15569,13968,10071,10337,31431,29757,28213,14753,10380,10334,10061,11681,13756,25413,10457,10525,30993,10652,10190,10438,30445,29902,87523,30477,51061,60646,13967,16230,19101,10140,14475,30510,56753,60216,10966,11007,62455,18401,20273,10898,16122,10060,16160,10526,10909,24121,10527,25412,11195,15733,15734,23959,26428,10069,10188,12189,60324,20061,56730,22657,69428,19760,20003,20002,11955,10132,10144,13568,10047,10302,18377,10189,10020,10181,10245,10246,10022,10681,11842,10177,10817,10179,21525,11910,11679,27924,10371,10809,11200,11006,18175,10729,13403,11076,13307,13496,12434,10764,10640,13362,13402,12619,10907,13075,10900,13923,10012,10018,10244,10257,10249,10182,10693,71795,10130,10538,10010,11840,10011,10006,10256,10101,10021,10174,10005,10290,10024,10023,11844,10004,10129,10128,10008,12913,11114,10114,11412,10007,11352,11117,12503,11428,10127,11115,10862,10570,10248,10860,10498,10173,18737,17577,12525,10846,13802,10798,20748,11566,16263,12214,12524,12124,10731,10039,13408,21102,10799,10319,11347,10355,10646,10493,11441,11847,10082,10432,76234,21981,24316,10393,11078,10368,10296,10759,10648,52224,10342,11264,10421,10420,10300,11627,10118,10411,10400,11040,10325,10252,10301,12097,10466,10221,10278,20288,42290,32774,10080,10454,42884,29097,10267,12431,10875,10874,11207,10914,12206,24834,10146,11364,10052,11077,15571,19273,15216,18209,10242,15683,10375,10381,10112,12095,10051,10727,13661,10240,10692,15775,10226,10250,10015,10749,10531,18759,11206,10428,10974,10918,10203,10148,10340,29566,20491,45111,10108,19244,13115,15945,10726,21850,10460,10096,10461,11071,34314,16743,39883,10110,10807,12186,21171,11532,37632,20742,11863,13305,29210,57767,12210,13077,26480,11074,60286,10494,10098,10097,11073,11072,10806,87068,16835,15944,11632,11241,10444,17129,10416,10439,60219,22083,56733,87443,56749,87442,87441,50568,45259,26502,16714,84996,10415,10417,10238,23021,18400,16460,87496,19172,11198,16639,11684,31769,16300,22938,10977,10075,24720,11262,11848,10068,10185,10175,10401,10320,10053,10049,21332,10530,10331,10324,10856,10038,10854,10913,10042,10251,10045,15735,25648,10967,13572,19620,12727,13770,10276,31775,85845,62419,25990,44922,10750,21598,15076,11055,15857,25681,68219,48025,23138,11261,43435,14299,10440,10426,10917,10081,10639,52228,18581,10274,11503,16822,10180,10247,10183,10115,11343,10059,10109,10367,11484,16185,16821,11348,15651,18696,10532,10293,21871,11507,10217,11845,10743,10292,12296,12260,16450,19550,10748,10441,10079,12094,12425,15645,10463,11137,11205,10092,19879,10386,10135,10215,10199,10682,11344,10906,10825,10828,11340,17249,10827,11054,11339,10826,16620,43604,11056,10197,10751,11057,13262,10266,14145,12143,10027,10326,10029,11260,10458,14777,16451,10212,20678,10643,13315,24077,10277,11741,30173,13571,18554,10206,16645,36788,10228,12321,15323,10241,14825,58650,10467,11060,10529,11372,10222,10425,10044,10043,55196,63659,10338,10377,10754,10169,10143,10524,10753,24899,15217,25483,10487,73924,10105,10167,13335,10166,15655,15169,19905,25764,19876,10279,22444,20997,33141,27598,19025,11134,13999,32896,11680,10678,10390,10031,11194,10297,10220,10808,10176,10136,16297,11709,10165,30642,21590,16524,27993,27727,17260,11388,10965,25145,10684,26539,12391,12144,17859,10598,59450,26603,87006,60822,74781,53146,70430,69951,82385,82384,82392,71376,87010,82059,60827,60823,81608,40074,24460,15411,70439,48371,34313,14347,74630,53112,48126,34291,80470,70441,10040,12294,10287,10014,10258,13407,10465,10013,10928,12125,38316,10062,10336,10908,10070,34311,60821,12976,74782,60824,14346,74666,53113,50536,10025,10423,12945,10216,10026,10195,28101,20674,19641,37239,51519,32417,23774,20673,27116,28161,14311,31235,23120,13832,11269,14529,10587,10586,12258,10582,14386,14298,10583,13337,10927,11289,11266,11288,14174,11267,13739,10584,11087,10870,14227,11606,10234,10867,13152,13153,11746,20393,11081,10452,10822,11968,14190,13043,12630,12938,10316,13226,10315,11605,10868,13449,10983,13611,12064,10477,10476,23127,13448,10453,11138,11764,11082,13265,13447,13727,10924,19764,25349,11270,14720,22463,12160,10585,15258,14922,20021,14189,11086,12161,13740,11268,12320,11085,13366,14385,13574,13573,18771,20138,12257,19245,12067,29963,31922,25025,10594,31822,18528,12529,19270,12629,11969,10407,53336,19717,50542,10767,45373,70422,70469,10700,10218,10139,10766,10223,23094,10138,10009,48130,10521,10273,10187,10269) [ RunTime:0.009985s ]
- [ 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' => 840,
'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 (32737,10592,25763,30028,10230,27611,14509,23944,17131,11925,17327,10398,35623,25693,10683,10365,11350,10590,10589,10853,32773,11009,10035,10690,10899,11151,71635,12015,21331,26367,10085,10378,10077,10104,10091,10107,10399,10382,12568,10376,10379,10433,22288,19328,10084,10647,10329,10443,10455,10427,11265,10442,17739,16508,10133,10002,10294,24289,10456,10811,10976,10492,10184,10571,10219,10048,11523,11838,10083,10339,10303,10164,33035,10093,15107,11386,16418,21062,87520,74397,11404,13194,71325,24095,34447,30309,30334,30335,74154,28779,32771,87521,87522,40412,10593,28038,74175,31755,21947,10305,10298,21978,13543,25333,81297,40097,20057,34265,81298,18777,45637,31369,10066,10327,15569,13968,10071,10337,31431,29757,28213,14753,10380,10334,10061,11681,13756,25413,10457,10525,30993,10652,10190,10438,30445,29902,87523,30477,51061,60646,13967,16230,19101,10140,14475,30510,56753,60216,10966,11007,62455,18401,20273,10898,16122,10060,16160,10526,10909,24121,10527,25412,11195,15733,15734,23959,26428,10069,10188,12189,60324,20061,56730,22657,69428,19760,20003,20002,11955,10132,10144,13568,10047,10302,18377,10189,10020,10181,10245,10246,10022,10681,11842,10177,10817,10179,21525,11910,11679,27924,10371,10809,11200,11006,18175,10729,13403,11076,13307,13496,12434,10764,10640,13362,13402,12619,10907,13075,10900,13923,10012,10018,10244,10257,10249,10182,10693,71795,10130,10538,10010,11840,10011,10006,10256,10101,10021,10174,10005,10290,10024,10023,11844,10004,10129,10128,10008,12913,11114,10114,11412,10007,11352,11117,12503,11428,10127,11115,10862,10570,10248,10860,10498,10173,18737,17577,12525,10846,13802,10798,20748,11566,16263,12214,12524,12124,10731,10039,13408,21102,10799,10319,11347,10355,10646,10493,11441,11847,10082,10432,76234,21981,24316,10393,11078,10368,10296,10759,10648,52224,10342,11264,10421,10420,10300,11627,10118,10411,10400,11040,10325,10252,10301,12097,10466,10221,10278,20288,42290,32774,10080,10454,42884,29097,10267,12431,10875,10874,11207,10914,12206,24834,10146,11364,10052,11077,15571,19273,15216,18209,10242,15683,10375,10381,10112,12095,10051,10727,13661,10240,10692,15775,10226,10250,10015,10749,10531,18759,11206,10428,10974,10918,10203,10148,10340,29566,20491,45111,10108,19244,13115,15945,10726,21850,10460,10096,10461,11071,34314,16743,39883,10110,10807,12186,21171,11532,37632,20742,11863,13305,29210,57767,12210,13077,26480,11074,60286,10494,10098,10097,11073,11072,10806,87068,16835,15944,11632,11241,10444,17129,10416,10439,60219,22083,56733,87443,56749,87442,87441,50568,45259,26502,16714,84996,10415,10417,10238,23021,18400,16460,87496,19172,11198,16639,11684,31769,16300,22938,10977,10075,24720,11262,11848,10068,10185,10175,10401,10320,10053,10049,21332,10530,10331,10324,10856,10038,10854,10913,10042,10251,10045,15735,25648,10967,13572,19620,12727,13770,10276,31775,85845,62419,25990,44922,10750,21598,15076,11055,15857,25681,68219,48025,23138,11261,43435,14299,10440,10426,10917,10081,10639,52228,18581,10274,11503,16822,10180,10247,10183,10115,11343,10059,10109,10367,11484,16185,16821,11348,15651,18696,10532,10293,21871,11507,10217,11845,10743,10292,12296,12260,16450,19550,10748,10441,10079,12094,12425,15645,10463,11137,11205,10092,19879,10386,10135,10215,10199,10682,11344,10906,10825,10828,11340,17249,10827,11054,11339,10826,16620,43604,11056,10197,10751,11057,13262,10266,14145,12143,10027,10326,10029,11260,10458,14777,16451,10212,20678,10643,13315,24077,10277,11741,30173,13571,18554,10206,16645,36788,10228,12321,15323,10241,14825,58650,10467,11060,10529,11372,10222,10425,10044,10043,55196,63659,10338,10377,10754,10169,10143,10524,10753,24899,15217,25483,10487,73924,10105,10167,13335,10166,15655,15169,19905,25764,19876,10279,22444,20997,33141,27598,19025,11134,13999,32896,11680,10678,10390,10031,11194,10297,10220,10808,10176,10136,16297,11709,10165,30642,21590,16524,27993,27727,17260,11388,10965,25145,10684,26539,12391,12144,17859,10598,59450,26603,87006,60822,74781,53146,70430,69951,82385,82384,82392,71376,87010,82059,60827,60823,81608,40074,24460,15411,70439,48371,34313,14347,74630,53112,48126,34291,80470,70441,10040,12294,10287,10014,10258,13407,10465,10013,10928,12125,38316,10062,10336,10908,10070,34311,60821,12976,74782,60824,14346,74666,53113,50536,10025,10423,12945,10216,10026,10195,28101,20674,19641,37239,51519,32417,23774,20673,27116,28161,14311,31235,23120,13832,11269,14529,10587,10586,12258,10582,14386,14298,10583,13337,10927,11289,11266,11288,14174,11267,13739,10584,11087,10870,14227,11606,10234,10867,13152,13153,11746,20393,11081,10452,10822,11968,14190,13043,12630,12938,10316,13226,10315,11605,10868,13449,10983,13611,12064,10477,10476,23127,13448,10453,11138,11764,11082,13265,13447,13727,10924,19764,25349,11270,14720,22463,12160,10585,15258,14922,20021,14189,11086,12161,13740,11268,12320,11085,13366,14385,13574,13573,18771,20138,12257,19245,12067,29963,31922,25025,10594,31822,18528,12529,19270,12629,11969,10407,53336,19717,50542,10767,45373,70422,70469,10700,10218,10139,10766,10223,23094,10138,10009,48130,10521,10273,10187,10269) [ RunTime:0.012454s ]
- [ 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' => 840,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT `cid` FROM `cmf_nami_competitions` WHERE `pinyin` = 'xiyi' AND `com_type` = 0 LIMIT 1 [ RunTime:0.001731s ]
- [ 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' => 3841,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `com_type` = 0 AND `competition_id` = 121 AND ( `match_time` > 1741344539 ) ORDER BY `match_time` ASC LIMIT 1000 [ RunTime:0.002754s ]
- [ 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' => 562,
'filtered' => 7.557234287261963,
'extra' => 'Using index condition; Using where; Using filesort',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` = 121 [ RunTime:0.001779s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_competitions',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'cid',
'key' => 'cid',
'key_len' => '7',
'ref' => 'const,const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` = 121 [ RunTime:0.001788s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_competitions',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'cid',
'key' => 'cid',
'key_len' => '7',
'ref' => 'const,const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (10035,10690,10219,10048,11441,11847,10301,12097,10466,10221,10531,18759,10045,15735,10743,10292,10458,14777,10044,10043,10390,10031) [ RunTime:0.001833s ]
- [ 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' => 22,
'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 (10035,10690,10219,10048,11441,11847,10301,12097,10466,10221,10531,18759,10045,15735,10743,10292,10458,14777,10044,10043,10390,10031) [ RunTime:0.001680s ]
- [ 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' => 22,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
阿爾梅里亞 
未開賽
科爾多瓦 
奧維耶多 
卡斯迪隆 
桑坦德競技 
埃登斯 
韋斯卡 
加的斯 
卡塔赫納 
費羅爾競技 
阿爾瓦塞特 
