2024-11-05
2024-11-06
2024-11-07
2024-11-08
2024-11-09
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2024-11-05 07:26:59 HTTP/1.1 GET : https://023mj.com/JRSZHIBOfootball/
- 运行时间 : 0.799238s [ 吞吐率:1.25req/s ] 内存消耗:3,663.34kb 文件加载:138
- 查询信息 : 70 queries 11 writes
- 缓存信息 : 8 reads,5 writes
- [ LANG ] /mnt/7kzhanqun/vendor/thinkphp/lang/zh-cn.php
- [ DB ] INIT mysql
- [ LANG ] /mnt/7kzhanqun/vendor/thinkcmf/cmf/src/behavior/../lang/zh-cn.php
- [ LANG ] /mnt/7kzhanqun/vendor/thinkcmf/cmf-app/src/admin/lang/zh-cn.php
- [ LANG ] /mnt/7kzhanqun/vendor/thinkcmf/cmf-app/src/admin/lang/zh-cn/common.php
- [ LANG ] /mnt/7kzhanqun/vendor/thinkcmf/cmf-app/src/user/lang/zh-cn.php
- [ LANG ] /mnt/7kzhanqun/app/portal/lang/zh-cn/common.php
- [ LANG ] /mnt/7kzhanqun/app/portal//lang/zh-cn.php
- [ ROUTE ] array (
'rule' => 'JRSZHIBOfootball',
'route' => 'portal/Competition/index?type=0',
'option' =>
array (
'merge_rule_regex' => false,
),
'var' =>
array (
),
)
- [ HEADER ] array (
'x-tenant-forward-for' => '18.207.160.209',
'accept-encoding' => 'br,gzip',
'if-modified-since' => 'Wed, 19 Jun 2024 06:34:59 GMT',
'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/)',
'x-forwarded-proto' => 'https',
'x-forwarded-for' => '18.207.160.209, 18.207.160.209',
'x-real-ip' => '18.207.160.209',
'host' => '023mj.com',
'content-length' => '',
'content-type' => '',
)
- [ PARAM ] array (
'type' => '0',
)
- [ LANG ] /mnt/7kzhanqun/app/portal/lang/zh-cn/home.php
- [ VIEW ] /mnt/7kzhanqun/public/themes/sport2/portal/competition.html [ array (
0 => 'site_info',
1 => 'event_info',
2 => 'categories',
3 => 'front_theme',
4 => 'com_type',
5 => 'date',
6 => 'competition_name',
7 => 'navigation',
8 => 'pinyin',
9 => 'tdk',
10 => 'introduce',
11 => 'competition',
12 => 'theme_vars',
13 => 'theme_widgets',
) ]
- [ DB ] CONNECT:[ UseTime:0.005324s ] mysql:host=rm-3ns41jmtlb1g0zd6v.mysql.rds.aliyuncs.com;port=3306;dbname=daxiong;charset=utf8mb4
- [ SQL ] SHOW COLUMNS FROM `cmf_plugin_web` [ RunTime:0.003287s ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%023mj.com%' LIMIT 1 [ RunTime:0.002964s ]
- [ 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' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%023mj.com%' LIMIT 1 [ RunTime:0.003318s ]
- [ 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' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_plugin` [ RunTime:0.003160s ]
- [ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Web' AND `site_id` = 77 LIMIT 1 [ RunTime:0.003158s ]
- [ 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' => 136,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%023mj.com%' LIMIT 1 [ RunTime:0.003048s ]
- [ 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' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_option` [ RunTime:0.003257s ]
- [ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'cdn_settings' AND `site_id` = 77 LIMIT 1 [ RunTime:0.003106s ]
- [ 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 '%023mj.com%' LIMIT 1 [ RunTime:0.003049s ]
- [ 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' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%023mj.com%' LIMIT 1 [ RunTime:0.002965s ]
- [ 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' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 77 LIMIT 1 [ RunTime:0.002983s ]
- [ 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 '%023mj.com%' LIMIT 1 [ RunTime:0.003008s ]
- [ 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' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%023mj.com%' LIMIT 1 [ RunTime:0.002975s ]
- [ 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' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'site_info' AND `site_id` = 77 LIMIT 1 [ RunTime:0.002974s ]
- [ 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.003239s ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` WHERE `status` = 1 [ RunTime:0.004678s ]
- [ 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' => 756,
'filtered' => 9.999999046325684,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%023mj.com%' LIMIT 1 [ RunTime:0.003128s ]
- [ 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' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 77 LIMIT 1 [ RunTime:0.002999s ]
- [ 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.003225s ]
- [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `pinyin` = 'nba' LIMIT 1 [ RunTime:0.004927s ]
- [ 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' => 3784,
'filtered' => 9.999999046325684,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%023mj.com%' LIMIT 1 [ RunTime:0.003350s ]
- [ 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' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `competition_id` FROM `cmf_plugin_web` WHERE `id` = 77 LIMIT 1 [ RunTime:0.003115s ]
- [ 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 * FROM `cmf_nami_competitions` WHERE `com_type` = 0 LIMIT 1 [ RunTime:0.003196s ]
- [ 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' => 3784,
'filtered' => 9.999999046325684,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%023mj.com%' LIMIT 1 [ RunTime:0.002940s ]
- [ 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' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'site_info' AND `site_id` = 77 LIMIT 1 [ RunTime:0.003027s ]
- [ 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 '%023mj.com%' LIMIT 1 [ RunTime:0.003058s ]
- [ 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' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_nav_menu` [ RunTime:0.003077s ]
- [ SQL ] SELECT `name`,`href` FROM `cmf_nav_menu` WHERE `nav_id` = 1 AND `parent_id` = 0 AND `status` = 1 AND `site_id` = 77 [ RunTime:0.003363s ]
- [ 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' => 948,
'filtered' => 0.1054852306842804,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%023mj.com%' LIMIT 1 [ RunTime:0.003125s ]
- [ 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' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_nami_matches` [ RunTime:0.003775s ]
- [ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `competition_id` = 1 AND `com_type` = 0 AND `match_time` > 1730762820 LIMIT 100 [ RunTime:0.005474s ]
- [ 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' => 1140,
'filtered' => 8.978011131286621,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_nami_teams` [ RunTime:0.003177s ]
- [ SQL ] SELECT `short_name_zh` FROM `cmf_nami_teams` WHERE `cid` IN ('') AND `com_type` = 0 [ RunTime:0.003070s ]
- [ 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.003165s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'sport2' AND `file` = 'portal/article' LIMIT 1 [ RunTime:0.003118s ]
- [ 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' => 291,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'sport2' , `action` = 'portal/Article/index' , `file` = 'portal/article' , `name` = '文章页' , `more` = '{\"vars\":[]}' , `config_more` = '{\"vars\":[]}' , `description` = '文章页模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 'sport2' AND `file` = 'portal/article' [ RunTime:0.004315s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'sport2' AND `file` = 'portal/competition' LIMIT 1 [ RunTime:0.003286s ]
- [ 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' => 291,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'sport2' , `action` = 'portal/Competition/index' , `file` = 'portal/competition' , `name` = '赛程列表页' , `more` = '{\"vars\":[]}' , `config_more` = '{\"vars\":[]}' , `description` = '赛程列表模板文件' , `is_public` = 0 , `list_order` = 0 WHERE `theme` = 'sport2' AND `file` = 'portal/competition' [ RunTime:0.003312s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'sport2' AND `file` = 'portal/index' LIMIT 1 [ RunTime:0.003163s ]
- [ 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' => 291,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'sport2' , `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` = 'sport2' AND `file` = 'portal/index' [ RunTime:0.003293s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'sport2' AND `file` = 'portal/jifenbang' LIMIT 1 [ RunTime:0.003193s ]
- [ 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' => 291,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'sport2' , `action` = 'portal/Page/index' , `file` = 'portal/jifenbang' , `name` = '积分榜页' , `more` = '{\"vars\":[]}' , `config_more` = '{\"vars\":[]}' , `description` = '文章页模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 'sport2' AND `file` = 'portal/jifenbang' [ RunTime:0.003291s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'sport2' AND `file` = 'portal/list' LIMIT 1 [ RunTime:0.003139s ]
- [ 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' => 291,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'sport2' , `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` = 'sport2' AND `file` = 'portal/list' [ RunTime:0.003289s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'sport2' AND `file` = 'portal/match' LIMIT 1 [ RunTime:0.003172s ]
- [ 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' => 291,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'sport2' , `action` = 'portal/Match/index' , `file` = 'portal/match' , `name` = '赛事详情页' , `more` = '{\"vars\":[]}' , `config_more` = '{\"vars\":[]}' , `description` = '赛事详情页模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 'sport2' AND `file` = 'portal/match' [ RunTime:0.003242s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'sport2' AND `file` = 'portal/page' LIMIT 1 [ RunTime:0.003127s ]
- [ 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' => 291,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'sport2' , `action` = 'portal/Page/index' , `file` = 'portal/page' , `name` = '文章页' , `more` = '{\"vars\":[]}' , `config_more` = '{\"vars\":[]}' , `description` = '文章页模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 'sport2' AND `file` = 'portal/page' [ RunTime:0.003262s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'sport2' AND `file` = 'portal/search' LIMIT 1 [ RunTime:0.003106s ]
- [ 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' => 291,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'sport2' , `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` = 'sport2' AND `file` = 'portal/search' [ RunTime:0.003278s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'sport2' AND `file` = 'portal/sheshoubang' LIMIT 1 [ RunTime:0.003118s ]
- [ 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' => 291,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'sport2' , `action` = 'portal/Page/index' , `file` = 'portal/sheshoubang' , `name` = '射手榜页' , `more` = '{\"vars\":[]}' , `config_more` = '{\"vars\":[]}' , `description` = '文章页模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 'sport2' AND `file` = 'portal/sheshoubang' [ RunTime:0.003431s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'sport2' AND `file` = 'portal/tag' LIMIT 1 [ RunTime:0.003114s ]
- [ 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' => 291,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'sport2' , `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` = 'sport2' AND `file` = 'portal/tag' [ RunTime:0.003523s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'sport2' [ RunTime:0.003479s ]
- [ 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' => 291,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_theme` [ RunTime:0.003482s ]
- [ SQL ] UPDATE `cmf_theme` SET `name` = 'sport2' , `version` = '1.0.0' , `demo_url` = 'https://www.shuibinglang.com/' , `author` = '老谭' , `lang` = 'zh-cn' , `keywords` = 'https://www.shuibinglang.com/' , `description` = 'https://www.shuibinglang.com/' WHERE `theme` = 'sport2' [ RunTime:0.003264s ]
- [ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = 'sport2' AND ( `is_public` = 1 OR `file` = 'portal/competition' ) [ RunTime:0.003418s ]
- [ 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' => 291,
'filtered' => 1.899999976158142,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%023mj.com%' LIMIT 1 [ RunTime:0.003052s ]
- [ 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' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'storage' AND `site_id` = 77 LIMIT 1 [ RunTime:0.002962s ]
- [ 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 '%023mj.com%' LIMIT 1 [ RunTime:0.003094s ]
- [ 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' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Oss' AND `site_id` = 77 LIMIT 1 [ RunTime:0.003122s ]
- [ 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' => 136,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%023mj.com%' LIMIT 1 [ RunTime:0.002935s ]
- [ 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' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'cdn_settings' AND `site_id` = 77 LIMIT 1 [ RunTime:0.003017s ]
- [ 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 '%023mj.com%' LIMIT 1 [ RunTime:0.003091s ]
- [ 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' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_nav` [ RunTime:0.003258s ]
- [ SQL ] SELECT `id` FROM `cmf_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.002924s ]
- [ 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` = 77 AND `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.003272s ]
- [ 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' => 948,
'filtered' => 0.1054852306842804,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%023mj.com%' LIMIT 1 [ RunTime:0.003047s ]
- [ 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' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `cid` FROM `cmf_nami_competitions` WHERE `pinyin` = 'all' AND `com_type` = 0 LIMIT 1 [ RunTime:0.006139s ]
- [ 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' => 3784,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `com_type` = 0 AND ( `match_time` > 1730752020 ) ORDER BY `match_time` ASC LIMIT 1000 [ RunTime:0.008776s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_matches',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'com_type,match_time',
'key' => 'com_type',
'key_len' => '7',
'ref' => NULL,
'rows' => 14998,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` IN (469,476,3185,481,1722,429,436,473,3375,435,2164,430,475,6736,586,3489,1689,1815,54,675,1662,1863,349,59,2915,370,1796,1927,297,3075,77,351,3124,1696,615,333,656,97,1745,3264,1668,1704,1699,3474,728,264,387,1775,512,271,3527,277,3032,243,2725,6737,1719,641,133,347,716,7180,46,132,125,2101,1726,1881,194,2104,2000,100,2737,7200,84,90,2914,89,83,88,87,91,1776,235,1586,1715,1824,1720,465,486,7206,1842,579,1666,1851,1799,682,1885,263,1788,1819,671,260,337,360,214,374,1671,1709,684,1708,2064,388,332,47,664,300,128,359,3284,342,375,2040,978,3403,34,226,456,164,1677,3322,483,488,674,350,616,1723,1902,614,3265,730,1674,642,1785,1679,217,246,1907,376,108,1759,489,699,602,590,255,241,371,368,660,659,628,838,1667,348,1733,3306,717,112,253,658,385,296,1905,722,276,627,870,270,259,301,330,225,721,220,340,341,245,247,315,316,364,130,135,221,211,131,145,209,210,152,178,144,168,169,308,176,143,92,1736,3008,129,180,109,179,121,110,175,303,234,159,142,120,146,1207,151,262,249,2798,478,569,3295,572,457,567,582,3073,545,1746,581,688) [ RunTime:0.005912s ]
- [ 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' => 241,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` IN (469,476,3185,481,1722,429,436,473,3375,435,2164,430,475,6736,586,3489,1689,1815,54,675,1662,1863,349,59,2915,370,1796,1927,297,3075,77,351,3124,1696,615,333,656,97,1745,3264,1668,1704,1699,3474,728,264,387,1775,512,271,3527,277,3032,243,2725,6737,1719,641,133,347,716,7180,46,132,125,2101,1726,1881,194,2104,2000,100,2737,7200,84,90,2914,89,83,88,87,91,1776,235,1586,1715,1824,1720,465,486,7206,1842,579,1666,1851,1799,682,1885,263,1788,1819,671,260,337,360,214,374,1671,1709,684,1708,2064,388,332,47,664,300,128,359,3284,342,375,2040,978,3403,34,226,456,164,1677,3322,483,488,674,350,616,1723,1902,614,3265,730,1674,642,1785,1679,217,246,1907,376,108,1759,489,699,602,590,255,241,371,368,660,659,628,838,1667,348,1733,3306,717,112,253,658,385,296,1905,722,276,627,870,270,259,301,330,225,721,220,340,341,245,247,315,316,364,130,135,221,211,131,145,209,210,152,178,144,168,169,308,176,143,92,1736,3008,129,180,109,179,121,110,175,303,234,159,142,120,146,1207,151,262,249,2798,478,569,3295,572,457,567,582,3073,545,1746,581,688) [ RunTime:0.004778s ]
- [ 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' => 241,
'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 (19758,15674,14963,18658,69629,54595,52596,68054,53533,48485,24899,10340,26219,10815,12146,12055,31367,45203,10496,10814,49059,79325,61361,74321,30228,16417,12391,14743,22945,52618,21590,10598,10812,10601,23504,10094,16415,15974,25063,25610,14966,12356,16230,10223,23804,28715,85963,36615,42355,59968,29731,33504,44700,34108,74563,76329,10908,19717,10070,10415,17009,19409,22297,22427,16058,15720,32948,23731,35600,35598,35601,74199,39576,27682,29339,22014,23823,37719,23937,12780,62443,71659,52877,18238,76744,51748,13108,31600,25593,81763,13950,10416,74617,18000,28891,12388,29337,62682,42449,23813,37351,37331,21471,83935,61660,29252,18773,27793,50610,33212,59129,68329,62889,38263,39549,56660,32978,32987,23744,30428,39034,39668,58617,28116,23936,48864,22426,18998,15769,44310,20128,15158,21695,48037,25058,49637,15183,14478,82867,62103,83108,74011,71805,66720,62276,28208,16057,86413,16893,37840,52982,71359,24222,23777,37624,40043,13148,18955,25542,26098,22121,18263,31230,31228,30426,31232,17618,17408,32651,50637,33566,25600,32246,18352,20416,10799,39239,11278,49810,21801,29563,29509,37786,38546,43611,14832,11879,12856,14422,16947,37171,61939,23987,23988,21674,21592,76281,76264,76231,76288,75422,76265,76454,52818,71660,47203,76453,47803,22391,30929,18212,12986,33067,70688,33095,21700,17663,17205,10312,26751,37762,49457,28185,77402,54959,72610,26393,52848,10682,10140,17195,11414,70269,17543,13544,16202,45241,26274,69270,36995,34897,49388,15263,19099,37975,26866,76232,76256,18917,21291,28199,17351,26754,24708,10267,11680,18322,42181,85619,45435,85574,85463,10375,10808,11407,10317,10648,10683,17773,23263,17838,23246,47193,10749,31199,86155,21737,64221,13873,53025,20792,38530,15111,19993,23456,41430,42664,59453,10613,11024,12886,52780,34649,26752,12361,24523,11428,31225,11527,10177,32373,10734,31200,11528,32278,12018,32525,18938,30384,16655,32229,10860,32954,10127,31227,10535,23159,38423,17540,13254,30425,16129,31202,11113,32999,11412,11842,11964,22400,10817,11115,24552,12216,13140,20344,21747,20966,19378,28052,10130,10021,10571,10538,10290,10004,10101,10184,15603,13857,15566,11413,11862,10573,10728,14755,22565,13493,25294,24378,42832,11179,22654,16897,17113,27781,10796,33003,19298,11502,20391,23207,11966,16356,12120,17115,15068,10534,13040,11480,14997,16214,12057,17022,25320,15736,17061,15799,13141,19444,12058,17027,13042,38962,53179,17477,40124,16357,20186,17401,58359,12423,17398,24578,13041,17399,20915,14834,15599,14134,14135,13758,10859,31314,12019,31315,14655,31313,30233,11567,62045,11569,42412,53121,21451,11570,33546,12213,32944,16264,21911,18665,59382,31375,16127,19525,10680,10955,17197,10957,12832,14252,10998,29015,13051,29012,32333,21029,40113,21722,19227,44394,19885,11175,19310,11177,10068,10492,10025,10364,10030,10171,11207,10467,10249,10054,10217,10420,10206,10181,10256,10185,11844,10022,70023,72296,10165,33035,11206,10377,55375,28813,25010,11791,43710,18952,10428,16524,10105,19244,13649,22739,12154,10813,10818,10758,10147,10211,23761,10126,25483,13305,15217,11632,14964,12357,21521,28053,85451,86375,86377,86376,86379,86378,86381,86380,13194,11386,86368,86367,86370,86369,86372,86371,86374,86373,77374,30082,18780,60831,26410,60706,15034,50701,17265,17266,38094,29164,25533,75006,10417,10138,10336,16060,22019,22285,13059,74593,69638,16437,12451,77646,39144,30326,28215,20671,11256,12298,30563,48504,45145,13473,59136,73548,62852,80792,77563,31164,28847,62345,53867,14289,18461,30311,41207,42185,29876,25938,23194,34466,19331,12240,16610,42255,34579,19790,27310,30024,57454,38860,19225,23763,10628,15366,19189,71609,37715,32296,28263,10355,19248,28216,81269,15592,25154,29592,53132,40484,27990,51005,82456,53797,39000,20619,85399,49445,49449,44970,31809,38839,55216,42841,40234,48481,49530,37628,44971,18411,40367,71683,59375,41977,52456,83510,13184,16635,25409,23377,27868,34846,55055,76973,34877,34998,24917,32830,55072,28141,35175,19089,53344,10502,25544,17703,10447,29970,28389,29781,20220,19692,17566,26462,11240,20228,22200,81238,74412,34065,34412,74393,24459,34411,24919,45415,81239,26793,45413,81639,23111,21702,26153,85678,32927,38102,33744,82364,71750,72174,31597,72643,43204,72644,28851,81215,28852,24881,21101,31991,44472,14595,20710,14941,24550,13056,15066,32250,16012,11799,23069,16682,32156,76504,19878,27808,42438,77975,25366,86163,31640,19526,75140,61897,85200,17253,15759,22362,22543,47574,52171,62201,71661,13182,52893,76286,76254,75419,76282,76233,76257,76292,76255,18350,18476,21701,33096,26634,21197,43723,10233,10277,10120,33078,54340,12513,61143,49327,19562,10199,10640,14895,12469,16728,15352,30188,70037,75420,75421,13249,15771,25906,31653,21783,17999,59206,13938,20896,16201,44161,46110,14055,31285,56811,24866,14041,16948,15579,47230,22402,43203,17407,14046,11886,17604,14576,13033,14539,14481,16960,24622,14079,27264,28255,13670,53909,25432,25576,22735,55669,12485,64310,16575,20042,20242,15128,10363,14818,20928,28487,47807,10049,10411,10265,10200,10132,10365,46606,16949,28033,25050,26993,18415,58180,25772,20243,23989,10254,11440,20658,51845,62274,62879,64404,10325,44248,29495,72983,30989,34286,34340,11235,36962,11639,47271,82919,46629,27418,21355,37678,37683,10128,32213,24292,27926,22577,15129,32492,16818,10497,31316,29566,10108,35222,85762,20757,62857,24891,25744,30413,10790,13400,13399,15252,10351,18760,33040,62802,21730,10681,10175,20740,11526,10006,10246,10245,10011,15138,10569,10016,10146,10820,10015,10080,10000,10692,10215,10368,10251,10875,10109,10050,11060,29840,31125,10174,10024,11840,10023,10303,10167,37956,37971,20475,27102,76799,37049,10093,10166,33091,23834,19854,41727,11408,15828,17935,10757,10208,10117,25928,80093,13335,10753,23319,23267,26890,20634,11241,11863,15107,13115,15945,16418,14891,17840,13470,20235,17474,28363,30318,36526,19257,37357,21062,15655,15169,12210,12976,10062,34100,81292,10238,20439,20180,23895,25416,17635,14197,79326,13058,60349,69939,26429,59314,29207,14220,10767,21067,18342,13505,12238,26310,21864,14650,72669,29349,80938,26037,28224,29847,29863,28067,15864,25514,19699,21191,14552,22870,29885,77511,82866,82469,60389,54409,35034,34050,86408,32786,34413,50844,50845,40284,13055,26365,86410,32249,16707,20822,25901,68371,33807,78323,29364,25902,30717,60195,14411,28273,26346,17861,11794,19181,15859,17054,71605,12233,14473,77688,43615,26567,14809,15572,13149,16359,74499,38933,17188,17095,85361,14471,13381,25114,20107,72387,15261,21782,48546,26244,60612,32326,17316,28806,17254,15760,85977,10042,24637,21455,15124,12235,21472,13257,17542,10078,10236,12345,10125,10874,10123,10203,10313,10330,10643,10183,17597,10027,10529,10079,11056,10423,15323,10906,39874,10642,10333,11631,27375,10134,68749,11816,10212,10950,10387,11314,10283,11361,11607,16895,73916,85887,38388,29496,59443,14525,36510,36951,62195,22515,10253,10458,13939,28512,12137,18704,25574,22003,25968,28903,10811,13402,23977,24053,10081,10400,10748,10195,11015,10268,10322,11372,11194,10148,10135,11054,12143,10222,27727,10293,10005,10010,11506,10059,10029,10359,10524,10320,10180,52279,10464,10826,10064,11007,10040,24418,10285,10695,11001,10641,14578,10053,21523,52829,17859,11532,50065,26206,10338,10164,14962,14009,21171,30642,23519,25871,10083,10169,14965,23481,32953,21520,16657,35510,18133,72737,76355,24460,16714,85155,57787,28556,25895,52560,22517,76334,76335,12475,29156,29968,25833,24307,41528,57788,52543,12477,20213,52161,52928,47289,23016,76419,52901,29133,37597,79329,12538,45699,38273,26458,25751,14815,24677,27399,42087,30135,28009,42091,16510,16512,17419,15140,16513,12464,13631,30068,72532,86437,32694,23951,12761,27226,39923,17988,54569,32749,31750,32387,56244,52416,19938,59214,71476,75426,36040,19404,61773,58206,26800,20163,32872,29986,22314,77510,48915,58906,17989,33469,20371,11943,24627,21308,60082,18046,24628,85848,66153,25666,37027,38491,48197,10735,46977,26681,12624,12148,12433,21539,12625,12528,18885,18884,12527,12627,14477,29727,16583,28724,36823,57546,50984,14258,21630,25280,55552,72286,12905,31717,11368,10574,31719,33458,59273,21310,58202,26798,21342,58204,17569,20162,19191,20212,29606,22316,13150,21473,48912,21400,13057,31528,11365,14779,14523,61642,79758,29555,85445,25276,22630,18047,43149,30467,14430,17137,13474,23357,12365,10505,35078,74862,43843,59224,27739,21126,12352,19700,26360,73433,68315,30749,14366,19877,49516,28601,27975,54749,44518,27779,29273,72668,30495,26825,39008,18266,54751,29651,24772,24384,55119,21729,11850,34066,16713,21060,20385,17684,21312,14920,14918,53993,21124,31807,55195,32098,14420,34435,33276,32283,31820,14470,40186,74098,79129,73238,69153,40181,55697,72823,68261,14632,21407,10672,20649,20985,14658,13382,29754,24340,18410,72386,72385,22747,22033,23844,53852,57507,18864,35021,40507,30239,27298,45771,23259,13251,69583,22041,56788,40518,54117,56830,60279,14633,60750,27731,11238,16746,17664,16871,10673,10145,30883,15436,26687,30208,11953,11951,19273,25693,10002,17327,23944,18400,35623,10398,62407,10350,12430,81316,10281,19577,25850,23811,16997,31413,10821,36917,11009,10966,11134,42290,31769,62455,26719,21645,58017,42676,16443,23838,15794,10324,10051,10038,10589,10902,20632,19880,17638,52991,33400,26190,17045,18706,33261,10803,10676,11697,15811,40224,19732,57308,35318,31735,44957,22156,35411,22723,19528,10332,10591,30172,13302,23262,16543,33260,19118,19956,31867,19234,12955,14996,14679,11367,35463,24187,15321,10383,11313,10670,11046,12943,19550,11151,11878,22629,34830,48472,23009,26323,18363,58348,12732,17925,26353,29136,71537,35350,30227,47296,35313,15032,37394,36456,71665,12970,38476,13450,57763,22689,21179,18576,35492,14466,58126,41840,19116,11243,20968,10384,18757,10431,16304,10434,10644,71606,14051,14354,10308,11896,11432,10412,29923,53174,11510,17144,16749,39582,36252,18245,18153,30699,36442,43072,23501,57745,13423,11699,16748,57930,36515,36766,10075,10432,10107,10443,10376,10382,10104,10399,12568,10442,10647,19328,10433,10077,10084,10091,11265,22288,85395,85402,85536,31231,31203,32277,30429,77632,32998,14440,16944,13956,11370,11531,10402,10671,10693,58650,21332,14825,11891,74474,11320,21476,13036,17086,10131,11657,10100,10088,10385,10645,25580,11716,15978,21810,41827,28166,29226,40532,18582,45792,75434,34772,46874,33190,16095,16096,13186,17476,46875,47076,11767,10607,29924,57762,10129,10173,25023,27712,28200,24162,16025,63655,24000,23146,26132,16674,10857,10058,15228,19261,29974,76749,33758,48682,10729,10759,16460,14509,10243,14340,11525,12092,31626,22286,54039,84752,23012,29578,10301,10690,24536,14521,13301,52622,11504,33724,35954,21928,12422,24904,10294,11627,10679,10508,54284,23148,24466,11051,13290,16350,13657,14660,10421,11344,26877,22048,29052,14253,13408,21102,10974,10386,20981,11845,11260,25697,25655,27570,14631,37699,20947,23850,14905,12260,11838,24440,21477,14570,24093,29788,32282,31353,32804,10149,31044,49132,47538,20573,24585,24584,20571,26332,19842,24670,23810,15235,54027,43735,32639,33259,10210,14010,14734,33583,24383,28238,54623,30040,26506,31922,30710,45111,11073,10334,10525,25413,10061,20273,10526,11681,16122,28678,23642,39916,10150,30993,14649,20001,55750,10271,20060,32452,10418,27257,19177,30675,10594,32417,28101,20565,10380,10066,10457,10898,10069,10071,13967,13968,56559,56543,56556,56560,15751,24017,76651,24969,21947,23021,33290,45877,34306,32501,58679,58678,28550,29057,58661,81936,35933,29716,29125,33432,73086,77381,45536,30683,31748,15569,28213,30655,26425,25204,17984,28007,32297,48171,15508) [ RunTime:0.024997s ]
- [ 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' => 1892,
'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 (19758,15674,14963,18658,69629,54595,52596,68054,53533,48485,24899,10340,26219,10815,12146,12055,31367,45203,10496,10814,49059,79325,61361,74321,30228,16417,12391,14743,22945,52618,21590,10598,10812,10601,23504,10094,16415,15974,25063,25610,14966,12356,16230,10223,23804,28715,85963,36615,42355,59968,29731,33504,44700,34108,74563,76329,10908,19717,10070,10415,17009,19409,22297,22427,16058,15720,32948,23731,35600,35598,35601,74199,39576,27682,29339,22014,23823,37719,23937,12780,62443,71659,52877,18238,76744,51748,13108,31600,25593,81763,13950,10416,74617,18000,28891,12388,29337,62682,42449,23813,37351,37331,21471,83935,61660,29252,18773,27793,50610,33212,59129,68329,62889,38263,39549,56660,32978,32987,23744,30428,39034,39668,58617,28116,23936,48864,22426,18998,15769,44310,20128,15158,21695,48037,25058,49637,15183,14478,82867,62103,83108,74011,71805,66720,62276,28208,16057,86413,16893,37840,52982,71359,24222,23777,37624,40043,13148,18955,25542,26098,22121,18263,31230,31228,30426,31232,17618,17408,32651,50637,33566,25600,32246,18352,20416,10799,39239,11278,49810,21801,29563,29509,37786,38546,43611,14832,11879,12856,14422,16947,37171,61939,23987,23988,21674,21592,76281,76264,76231,76288,75422,76265,76454,52818,71660,47203,76453,47803,22391,30929,18212,12986,33067,70688,33095,21700,17663,17205,10312,26751,37762,49457,28185,77402,54959,72610,26393,52848,10682,10140,17195,11414,70269,17543,13544,16202,45241,26274,69270,36995,34897,49388,15263,19099,37975,26866,76232,76256,18917,21291,28199,17351,26754,24708,10267,11680,18322,42181,85619,45435,85574,85463,10375,10808,11407,10317,10648,10683,17773,23263,17838,23246,47193,10749,31199,86155,21737,64221,13873,53025,20792,38530,15111,19993,23456,41430,42664,59453,10613,11024,12886,52780,34649,26752,12361,24523,11428,31225,11527,10177,32373,10734,31200,11528,32278,12018,32525,18938,30384,16655,32229,10860,32954,10127,31227,10535,23159,38423,17540,13254,30425,16129,31202,11113,32999,11412,11842,11964,22400,10817,11115,24552,12216,13140,20344,21747,20966,19378,28052,10130,10021,10571,10538,10290,10004,10101,10184,15603,13857,15566,11413,11862,10573,10728,14755,22565,13493,25294,24378,42832,11179,22654,16897,17113,27781,10796,33003,19298,11502,20391,23207,11966,16356,12120,17115,15068,10534,13040,11480,14997,16214,12057,17022,25320,15736,17061,15799,13141,19444,12058,17027,13042,38962,53179,17477,40124,16357,20186,17401,58359,12423,17398,24578,13041,17399,20915,14834,15599,14134,14135,13758,10859,31314,12019,31315,14655,31313,30233,11567,62045,11569,42412,53121,21451,11570,33546,12213,32944,16264,21911,18665,59382,31375,16127,19525,10680,10955,17197,10957,12832,14252,10998,29015,13051,29012,32333,21029,40113,21722,19227,44394,19885,11175,19310,11177,10068,10492,10025,10364,10030,10171,11207,10467,10249,10054,10217,10420,10206,10181,10256,10185,11844,10022,70023,72296,10165,33035,11206,10377,55375,28813,25010,11791,43710,18952,10428,16524,10105,19244,13649,22739,12154,10813,10818,10758,10147,10211,23761,10126,25483,13305,15217,11632,14964,12357,21521,28053,85451,86375,86377,86376,86379,86378,86381,86380,13194,11386,86368,86367,86370,86369,86372,86371,86374,86373,77374,30082,18780,60831,26410,60706,15034,50701,17265,17266,38094,29164,25533,75006,10417,10138,10336,16060,22019,22285,13059,74593,69638,16437,12451,77646,39144,30326,28215,20671,11256,12298,30563,48504,45145,13473,59136,73548,62852,80792,77563,31164,28847,62345,53867,14289,18461,30311,41207,42185,29876,25938,23194,34466,19331,12240,16610,42255,34579,19790,27310,30024,57454,38860,19225,23763,10628,15366,19189,71609,37715,32296,28263,10355,19248,28216,81269,15592,25154,29592,53132,40484,27990,51005,82456,53797,39000,20619,85399,49445,49449,44970,31809,38839,55216,42841,40234,48481,49530,37628,44971,18411,40367,71683,59375,41977,52456,83510,13184,16635,25409,23377,27868,34846,55055,76973,34877,34998,24917,32830,55072,28141,35175,19089,53344,10502,25544,17703,10447,29970,28389,29781,20220,19692,17566,26462,11240,20228,22200,81238,74412,34065,34412,74393,24459,34411,24919,45415,81239,26793,45413,81639,23111,21702,26153,85678,32927,38102,33744,82364,71750,72174,31597,72643,43204,72644,28851,81215,28852,24881,21101,31991,44472,14595,20710,14941,24550,13056,15066,32250,16012,11799,23069,16682,32156,76504,19878,27808,42438,77975,25366,86163,31640,19526,75140,61897,85200,17253,15759,22362,22543,47574,52171,62201,71661,13182,52893,76286,76254,75419,76282,76233,76257,76292,76255,18350,18476,21701,33096,26634,21197,43723,10233,10277,10120,33078,54340,12513,61143,49327,19562,10199,10640,14895,12469,16728,15352,30188,70037,75420,75421,13249,15771,25906,31653,21783,17999,59206,13938,20896,16201,44161,46110,14055,31285,56811,24866,14041,16948,15579,47230,22402,43203,17407,14046,11886,17604,14576,13033,14539,14481,16960,24622,14079,27264,28255,13670,53909,25432,25576,22735,55669,12485,64310,16575,20042,20242,15128,10363,14818,20928,28487,47807,10049,10411,10265,10200,10132,10365,46606,16949,28033,25050,26993,18415,58180,25772,20243,23989,10254,11440,20658,51845,62274,62879,64404,10325,44248,29495,72983,30989,34286,34340,11235,36962,11639,47271,82919,46629,27418,21355,37678,37683,10128,32213,24292,27926,22577,15129,32492,16818,10497,31316,29566,10108,35222,85762,20757,62857,24891,25744,30413,10790,13400,13399,15252,10351,18760,33040,62802,21730,10681,10175,20740,11526,10006,10246,10245,10011,15138,10569,10016,10146,10820,10015,10080,10000,10692,10215,10368,10251,10875,10109,10050,11060,29840,31125,10174,10024,11840,10023,10303,10167,37956,37971,20475,27102,76799,37049,10093,10166,33091,23834,19854,41727,11408,15828,17935,10757,10208,10117,25928,80093,13335,10753,23319,23267,26890,20634,11241,11863,15107,13115,15945,16418,14891,17840,13470,20235,17474,28363,30318,36526,19257,37357,21062,15655,15169,12210,12976,10062,34100,81292,10238,20439,20180,23895,25416,17635,14197,79326,13058,60349,69939,26429,59314,29207,14220,10767,21067,18342,13505,12238,26310,21864,14650,72669,29349,80938,26037,28224,29847,29863,28067,15864,25514,19699,21191,14552,22870,29885,77511,82866,82469,60389,54409,35034,34050,86408,32786,34413,50844,50845,40284,13055,26365,86410,32249,16707,20822,25901,68371,33807,78323,29364,25902,30717,60195,14411,28273,26346,17861,11794,19181,15859,17054,71605,12233,14473,77688,43615,26567,14809,15572,13149,16359,74499,38933,17188,17095,85361,14471,13381,25114,20107,72387,15261,21782,48546,26244,60612,32326,17316,28806,17254,15760,85977,10042,24637,21455,15124,12235,21472,13257,17542,10078,10236,12345,10125,10874,10123,10203,10313,10330,10643,10183,17597,10027,10529,10079,11056,10423,15323,10906,39874,10642,10333,11631,27375,10134,68749,11816,10212,10950,10387,11314,10283,11361,11607,16895,73916,85887,38388,29496,59443,14525,36510,36951,62195,22515,10253,10458,13939,28512,12137,18704,25574,22003,25968,28903,10811,13402,23977,24053,10081,10400,10748,10195,11015,10268,10322,11372,11194,10148,10135,11054,12143,10222,27727,10293,10005,10010,11506,10059,10029,10359,10524,10320,10180,52279,10464,10826,10064,11007,10040,24418,10285,10695,11001,10641,14578,10053,21523,52829,17859,11532,50065,26206,10338,10164,14962,14009,21171,30642,23519,25871,10083,10169,14965,23481,32953,21520,16657,35510,18133,72737,76355,24460,16714,85155,57787,28556,25895,52560,22517,76334,76335,12475,29156,29968,25833,24307,41528,57788,52543,12477,20213,52161,52928,47289,23016,76419,52901,29133,37597,79329,12538,45699,38273,26458,25751,14815,24677,27399,42087,30135,28009,42091,16510,16512,17419,15140,16513,12464,13631,30068,72532,86437,32694,23951,12761,27226,39923,17988,54569,32749,31750,32387,56244,52416,19938,59214,71476,75426,36040,19404,61773,58206,26800,20163,32872,29986,22314,77510,48915,58906,17989,33469,20371,11943,24627,21308,60082,18046,24628,85848,66153,25666,37027,38491,48197,10735,46977,26681,12624,12148,12433,21539,12625,12528,18885,18884,12527,12627,14477,29727,16583,28724,36823,57546,50984,14258,21630,25280,55552,72286,12905,31717,11368,10574,31719,33458,59273,21310,58202,26798,21342,58204,17569,20162,19191,20212,29606,22316,13150,21473,48912,21400,13057,31528,11365,14779,14523,61642,79758,29555,85445,25276,22630,18047,43149,30467,14430,17137,13474,23357,12365,10505,35078,74862,43843,59224,27739,21126,12352,19700,26360,73433,68315,30749,14366,19877,49516,28601,27975,54749,44518,27779,29273,72668,30495,26825,39008,18266,54751,29651,24772,24384,55119,21729,11850,34066,16713,21060,20385,17684,21312,14920,14918,53993,21124,31807,55195,32098,14420,34435,33276,32283,31820,14470,40186,74098,79129,73238,69153,40181,55697,72823,68261,14632,21407,10672,20649,20985,14658,13382,29754,24340,18410,72386,72385,22747,22033,23844,53852,57507,18864,35021,40507,30239,27298,45771,23259,13251,69583,22041,56788,40518,54117,56830,60279,14633,60750,27731,11238,16746,17664,16871,10673,10145,30883,15436,26687,30208,11953,11951,19273,25693,10002,17327,23944,18400,35623,10398,62407,10350,12430,81316,10281,19577,25850,23811,16997,31413,10821,36917,11009,10966,11134,42290,31769,62455,26719,21645,58017,42676,16443,23838,15794,10324,10051,10038,10589,10902,20632,19880,17638,52991,33400,26190,17045,18706,33261,10803,10676,11697,15811,40224,19732,57308,35318,31735,44957,22156,35411,22723,19528,10332,10591,30172,13302,23262,16543,33260,19118,19956,31867,19234,12955,14996,14679,11367,35463,24187,15321,10383,11313,10670,11046,12943,19550,11151,11878,22629,34830,48472,23009,26323,18363,58348,12732,17925,26353,29136,71537,35350,30227,47296,35313,15032,37394,36456,71665,12970,38476,13450,57763,22689,21179,18576,35492,14466,58126,41840,19116,11243,20968,10384,18757,10431,16304,10434,10644,71606,14051,14354,10308,11896,11432,10412,29923,53174,11510,17144,16749,39582,36252,18245,18153,30699,36442,43072,23501,57745,13423,11699,16748,57930,36515,36766,10075,10432,10107,10443,10376,10382,10104,10399,12568,10442,10647,19328,10433,10077,10084,10091,11265,22288,85395,85402,85536,31231,31203,32277,30429,77632,32998,14440,16944,13956,11370,11531,10402,10671,10693,58650,21332,14825,11891,74474,11320,21476,13036,17086,10131,11657,10100,10088,10385,10645,25580,11716,15978,21810,41827,28166,29226,40532,18582,45792,75434,34772,46874,33190,16095,16096,13186,17476,46875,47076,11767,10607,29924,57762,10129,10173,25023,27712,28200,24162,16025,63655,24000,23146,26132,16674,10857,10058,15228,19261,29974,76749,33758,48682,10729,10759,16460,14509,10243,14340,11525,12092,31626,22286,54039,84752,23012,29578,10301,10690,24536,14521,13301,52622,11504,33724,35954,21928,12422,24904,10294,11627,10679,10508,54284,23148,24466,11051,13290,16350,13657,14660,10421,11344,26877,22048,29052,14253,13408,21102,10974,10386,20981,11845,11260,25697,25655,27570,14631,37699,20947,23850,14905,12260,11838,24440,21477,14570,24093,29788,32282,31353,32804,10149,31044,49132,47538,20573,24585,24584,20571,26332,19842,24670,23810,15235,54027,43735,32639,33259,10210,14010,14734,33583,24383,28238,54623,30040,26506,31922,30710,45111,11073,10334,10525,25413,10061,20273,10526,11681,16122,28678,23642,39916,10150,30993,14649,20001,55750,10271,20060,32452,10418,27257,19177,30675,10594,32417,28101,20565,10380,10066,10457,10898,10069,10071,13967,13968,56559,56543,56556,56560,15751,24017,76651,24969,21947,23021,33290,45877,34306,32501,58679,58678,28550,29057,58661,81936,35933,29716,29125,33432,73086,77381,45536,30683,31748,15569,28213,30655,26425,25204,17984,28007,32297,48171,15508) [ RunTime:0.022416s ]
- [ 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' => 1892,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT `cid` FROM `cmf_nami_competitions` WHERE `pinyin` = 'all' AND `com_type` = 0 LIMIT 1 [ RunTime:0.004975s ]
- [ 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' => 3784,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `com_type` = 0 AND ( `match_time` > 1730752020 ) ORDER BY `match_time` ASC LIMIT 1000 [ RunTime:0.006569s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_matches',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'com_type,match_time',
'key' => 'com_type',
'key_len' => '7',
'ref' => NULL,
'rows' => 14998,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` IN (469,476,3185,481,1722,429,436,473,3375,435,2164,430,475,6736,586,3489,1689,1815,54,675,1662,1863,349,59,2915,370,1796,1927,297,3075,77,351,3124,1696,615,333,656,97,1745,3264,1668,1704,1699,3474,728,264,387,1775,512,271,3527,277,3032,243,2725,6737,1719,641,133,347,716,7180,46,132,125,2101,1726,1881,194,2104,2000,100,2737,7200,84,90,2914,89,83,88,87,91,1776,235,1586,1715,1824,1720,465,486,7206,1842,579,1666,1851,1799,682,1885,263,1788,1819,671,260,337,360,214,374,1671,1709,684,1708,2064,388,332,47,664,300,128,359,3284,342,375,2040,978,3403,34,226,456,164,1677,3322,483,488,674,350,616,1723,1902,614,3265,730,1674,642,1785,1679,217,246,1907,376,108,1759,489,699,602,590,255,241,371,368,660,659,628,838,1667,348,1733,3306,717,112,253,658,385,296,1905,722,276,627,870,270,259,301,330,225,721,220,340,341,245,247,315,316,364,130,135,221,211,131,145,209,210,152,178,144,168,169,308,176,143,92,1736,3008,129,180,109,179,121,110,175,303,234,159,142,120,146,1207,151,262,249,2798,478,569,3295,572,457,567,582,3073,545,1746,581,688) [ RunTime:0.006832s ]
- [ 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' => 241,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` IN (469,476,3185,481,1722,429,436,473,3375,435,2164,430,475,6736,586,3489,1689,1815,54,675,1662,1863,349,59,2915,370,1796,1927,297,3075,77,351,3124,1696,615,333,656,97,1745,3264,1668,1704,1699,3474,728,264,387,1775,512,271,3527,277,3032,243,2725,6737,1719,641,133,347,716,7180,46,132,125,2101,1726,1881,194,2104,2000,100,2737,7200,84,90,2914,89,83,88,87,91,1776,235,1586,1715,1824,1720,465,486,7206,1842,579,1666,1851,1799,682,1885,263,1788,1819,671,260,337,360,214,374,1671,1709,684,1708,2064,388,332,47,664,300,128,359,3284,342,375,2040,978,3403,34,226,456,164,1677,3322,483,488,674,350,616,1723,1902,614,3265,730,1674,642,1785,1679,217,246,1907,376,108,1759,489,699,602,590,255,241,371,368,660,659,628,838,1667,348,1733,3306,717,112,253,658,385,296,1905,722,276,627,870,270,259,301,330,225,721,220,340,341,245,247,315,316,364,130,135,221,211,131,145,209,210,152,178,144,168,169,308,176,143,92,1736,3008,129,180,109,179,121,110,175,303,234,159,142,120,146,1207,151,262,249,2798,478,569,3295,572,457,567,582,3073,545,1746,581,688) [ RunTime:0.004841s ]
- [ 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' => 241,
'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 (19758,15674,14963,18658,69629,54595,52596,68054,53533,48485,24899,10340,26219,10815,12146,12055,31367,45203,10496,10814,49059,79325,61361,74321,30228,16417,12391,14743,22945,52618,21590,10598,10812,10601,23504,10094,16415,15974,25063,25610,14966,12356,16230,10223,23804,28715,85963,36615,42355,59968,29731,33504,44700,34108,74563,76329,10908,19717,10070,10415,17009,19409,22297,22427,16058,15720,32948,23731,35600,35598,35601,74199,39576,27682,29339,22014,23823,37719,23937,12780,62443,71659,52877,18238,76744,51748,13108,31600,25593,81763,13950,10416,74617,18000,28891,12388,29337,62682,42449,23813,37351,37331,21471,83935,61660,29252,18773,27793,50610,33212,59129,68329,62889,38263,39549,56660,32978,32987,23744,30428,39034,39668,58617,28116,23936,48864,22426,18998,15769,44310,20128,15158,21695,48037,25058,49637,15183,14478,82867,62103,83108,74011,71805,66720,62276,28208,16057,86413,16893,37840,52982,71359,24222,23777,37624,40043,13148,18955,25542,26098,22121,18263,31230,31228,30426,31232,17618,17408,32651,50637,33566,25600,32246,18352,20416,10799,39239,11278,49810,21801,29563,29509,37786,38546,43611,14832,11879,12856,14422,16947,37171,61939,23987,23988,21674,21592,76281,76264,76231,76288,75422,76265,76454,52818,71660,47203,76453,47803,22391,30929,18212,12986,33067,70688,33095,21700,17663,17205,10312,26751,37762,49457,28185,77402,54959,72610,26393,52848,10682,10140,17195,11414,70269,17543,13544,16202,45241,26274,69270,36995,34897,49388,15263,19099,37975,26866,76232,76256,18917,21291,28199,17351,26754,24708,10267,11680,18322,42181,85619,45435,85574,85463,10375,10808,11407,10317,10648,10683,17773,23263,17838,23246,47193,10749,31199,86155,21737,64221,13873,53025,20792,38530,15111,19993,23456,41430,42664,59453,10613,11024,12886,52780,34649,26752,12361,24523,11428,31225,11527,10177,32373,10734,31200,11528,32278,12018,32525,18938,30384,16655,32229,10860,32954,10127,31227,10535,23159,38423,17540,13254,30425,16129,31202,11113,32999,11412,11842,11964,22400,10817,11115,24552,12216,13140,20344,21747,20966,19378,28052,10130,10021,10571,10538,10290,10004,10101,10184,15603,13857,15566,11413,11862,10573,10728,14755,22565,13493,25294,24378,42832,11179,22654,16897,17113,27781,10796,33003,19298,11502,20391,23207,11966,16356,12120,17115,15068,10534,13040,11480,14997,16214,12057,17022,25320,15736,17061,15799,13141,19444,12058,17027,13042,38962,53179,17477,40124,16357,20186,17401,58359,12423,17398,24578,13041,17399,20915,14834,15599,14134,14135,13758,10859,31314,12019,31315,14655,31313,30233,11567,62045,11569,42412,53121,21451,11570,33546,12213,32944,16264,21911,18665,59382,31375,16127,19525,10680,10955,17197,10957,12832,14252,10998,29015,13051,29012,32333,21029,40113,21722,19227,44394,19885,11175,19310,11177,10068,10492,10025,10364,10030,10171,11207,10467,10249,10054,10217,10420,10206,10181,10256,10185,11844,10022,70023,72296,10165,33035,11206,10377,55375,28813,25010,11791,43710,18952,10428,16524,10105,19244,13649,22739,12154,10813,10818,10758,10147,10211,23761,10126,25483,13305,15217,11632,14964,12357,21521,28053,85451,86375,86377,86376,86379,86378,86381,86380,13194,11386,86368,86367,86370,86369,86372,86371,86374,86373,77374,30082,18780,60831,26410,60706,15034,50701,17265,17266,38094,29164,25533,75006,10417,10138,10336,16060,22019,22285,13059,74593,69638,16437,12451,77646,39144,30326,28215,20671,11256,12298,30563,48504,45145,13473,59136,73548,62852,80792,77563,31164,28847,62345,53867,14289,18461,30311,41207,42185,29876,25938,23194,34466,19331,12240,16610,42255,34579,19790,27310,30024,57454,38860,19225,23763,10628,15366,19189,71609,37715,32296,28263,10355,19248,28216,81269,15592,25154,29592,53132,40484,27990,51005,82456,53797,39000,20619,85399,49445,49449,44970,31809,38839,55216,42841,40234,48481,49530,37628,44971,18411,40367,71683,59375,41977,52456,83510,13184,16635,25409,23377,27868,34846,55055,76973,34877,34998,24917,32830,55072,28141,35175,19089,53344,10502,25544,17703,10447,29970,28389,29781,20220,19692,17566,26462,11240,20228,22200,81238,74412,34065,34412,74393,24459,34411,24919,45415,81239,26793,45413,81639,23111,21702,26153,85678,32927,38102,33744,82364,71750,72174,31597,72643,43204,72644,28851,81215,28852,24881,21101,31991,44472,14595,20710,14941,24550,13056,15066,32250,16012,11799,23069,16682,32156,76504,19878,27808,42438,77975,25366,86163,31640,19526,75140,61897,85200,17253,15759,22362,22543,47574,52171,62201,71661,13182,52893,76286,76254,75419,76282,76233,76257,76292,76255,18350,18476,21701,33096,26634,21197,43723,10233,10277,10120,33078,54340,12513,61143,49327,19562,10199,10640,14895,12469,16728,15352,30188,70037,75420,75421,13249,15771,25906,31653,21783,17999,59206,13938,20896,16201,44161,46110,14055,31285,56811,24866,14041,16948,15579,47230,22402,43203,17407,14046,11886,17604,14576,13033,14539,14481,16960,24622,14079,27264,28255,13670,53909,25432,25576,22735,55669,12485,64310,16575,20042,20242,15128,10363,14818,20928,28487,47807,10049,10411,10265,10200,10132,10365,46606,16949,28033,25050,26993,18415,58180,25772,20243,23989,10254,11440,20658,51845,62274,62879,64404,10325,44248,29495,72983,30989,34286,34340,11235,36962,11639,47271,82919,46629,27418,21355,37678,37683,10128,32213,24292,27926,22577,15129,32492,16818,10497,31316,29566,10108,35222,85762,20757,62857,24891,25744,30413,10790,13400,13399,15252,10351,18760,33040,62802,21730,10681,10175,20740,11526,10006,10246,10245,10011,15138,10569,10016,10146,10820,10015,10080,10000,10692,10215,10368,10251,10875,10109,10050,11060,29840,31125,10174,10024,11840,10023,10303,10167,37956,37971,20475,27102,76799,37049,10093,10166,33091,23834,19854,41727,11408,15828,17935,10757,10208,10117,25928,80093,13335,10753,23319,23267,26890,20634,11241,11863,15107,13115,15945,16418,14891,17840,13470,20235,17474,28363,30318,36526,19257,37357,21062,15655,15169,12210,12976,10062,34100,81292,10238,20439,20180,23895,25416,17635,14197,79326,13058,60349,69939,26429,59314,29207,14220,10767,21067,18342,13505,12238,26310,21864,14650,72669,29349,80938,26037,28224,29847,29863,28067,15864,25514,19699,21191,14552,22870,29885,77511,82866,82469,60389,54409,35034,34050,86408,32786,34413,50844,50845,40284,13055,26365,86410,32249,16707,20822,25901,68371,33807,78323,29364,25902,30717,60195,14411,28273,26346,17861,11794,19181,15859,17054,71605,12233,14473,77688,43615,26567,14809,15572,13149,16359,74499,38933,17188,17095,85361,14471,13381,25114,20107,72387,15261,21782,48546,26244,60612,32326,17316,28806,17254,15760,85977,10042,24637,21455,15124,12235,21472,13257,17542,10078,10236,12345,10125,10874,10123,10203,10313,10330,10643,10183,17597,10027,10529,10079,11056,10423,15323,10906,39874,10642,10333,11631,27375,10134,68749,11816,10212,10950,10387,11314,10283,11361,11607,16895,73916,85887,38388,29496,59443,14525,36510,36951,62195,22515,10253,10458,13939,28512,12137,18704,25574,22003,25968,28903,10811,13402,23977,24053,10081,10400,10748,10195,11015,10268,10322,11372,11194,10148,10135,11054,12143,10222,27727,10293,10005,10010,11506,10059,10029,10359,10524,10320,10180,52279,10464,10826,10064,11007,10040,24418,10285,10695,11001,10641,14578,10053,21523,52829,17859,11532,50065,26206,10338,10164,14962,14009,21171,30642,23519,25871,10083,10169,14965,23481,32953,21520,16657,35510,18133,72737,76355,24460,16714,85155,57787,28556,25895,52560,22517,76334,76335,12475,29156,29968,25833,24307,41528,57788,52543,12477,20213,52161,52928,47289,23016,76419,52901,29133,37597,79329,12538,45699,38273,26458,25751,14815,24677,27399,42087,30135,28009,42091,16510,16512,17419,15140,16513,12464,13631,30068,72532,86437,32694,23951,12761,27226,39923,17988,54569,32749,31750,32387,56244,52416,19938,59214,71476,75426,36040,19404,61773,58206,26800,20163,32872,29986,22314,77510,48915,58906,17989,33469,20371,11943,24627,21308,60082,18046,24628,85848,66153,25666,37027,38491,48197,10735,46977,26681,12624,12148,12433,21539,12625,12528,18885,18884,12527,12627,14477,29727,16583,28724,36823,57546,50984,14258,21630,25280,55552,72286,12905,31717,11368,10574,31719,33458,59273,21310,58202,26798,21342,58204,17569,20162,19191,20212,29606,22316,13150,21473,48912,21400,13057,31528,11365,14779,14523,61642,79758,29555,85445,25276,22630,18047,43149,30467,14430,17137,13474,23357,12365,10505,35078,74862,43843,59224,27739,21126,12352,19700,26360,73433,68315,30749,14366,19877,49516,28601,27975,54749,44518,27779,29273,72668,30495,26825,39008,18266,54751,29651,24772,24384,55119,21729,11850,34066,16713,21060,20385,17684,21312,14920,14918,53993,21124,31807,55195,32098,14420,34435,33276,32283,31820,14470,40186,74098,79129,73238,69153,40181,55697,72823,68261,14632,21407,10672,20649,20985,14658,13382,29754,24340,18410,72386,72385,22747,22033,23844,53852,57507,18864,35021,40507,30239,27298,45771,23259,13251,69583,22041,56788,40518,54117,56830,60279,14633,60750,27731,11238,16746,17664,16871,10673,10145,30883,15436,26687,30208,11953,11951,19273,25693,10002,17327,23944,18400,35623,10398,62407,10350,12430,81316,10281,19577,25850,23811,16997,31413,10821,36917,11009,10966,11134,42290,31769,62455,26719,21645,58017,42676,16443,23838,15794,10324,10051,10038,10589,10902,20632,19880,17638,52991,33400,26190,17045,18706,33261,10803,10676,11697,15811,40224,19732,57308,35318,31735,44957,22156,35411,22723,19528,10332,10591,30172,13302,23262,16543,33260,19118,19956,31867,19234,12955,14996,14679,11367,35463,24187,15321,10383,11313,10670,11046,12943,19550,11151,11878,22629,34830,48472,23009,26323,18363,58348,12732,17925,26353,29136,71537,35350,30227,47296,35313,15032,37394,36456,71665,12970,38476,13450,57763,22689,21179,18576,35492,14466,58126,41840,19116,11243,20968,10384,18757,10431,16304,10434,10644,71606,14051,14354,10308,11896,11432,10412,29923,53174,11510,17144,16749,39582,36252,18245,18153,30699,36442,43072,23501,57745,13423,11699,16748,57930,36515,36766,10075,10432,10107,10443,10376,10382,10104,10399,12568,10442,10647,19328,10433,10077,10084,10091,11265,22288,85395,85402,85536,31231,31203,32277,30429,77632,32998,14440,16944,13956,11370,11531,10402,10671,10693,58650,21332,14825,11891,74474,11320,21476,13036,17086,10131,11657,10100,10088,10385,10645,25580,11716,15978,21810,41827,28166,29226,40532,18582,45792,75434,34772,46874,33190,16095,16096,13186,17476,46875,47076,11767,10607,29924,57762,10129,10173,25023,27712,28200,24162,16025,63655,24000,23146,26132,16674,10857,10058,15228,19261,29974,76749,33758,48682,10729,10759,16460,14509,10243,14340,11525,12092,31626,22286,54039,84752,23012,29578,10301,10690,24536,14521,13301,52622,11504,33724,35954,21928,12422,24904,10294,11627,10679,10508,54284,23148,24466,11051,13290,16350,13657,14660,10421,11344,26877,22048,29052,14253,13408,21102,10974,10386,20981,11845,11260,25697,25655,27570,14631,37699,20947,23850,14905,12260,11838,24440,21477,14570,24093,29788,32282,31353,32804,10149,31044,49132,47538,20573,24585,24584,20571,26332,19842,24670,23810,15235,54027,43735,32639,33259,10210,14010,14734,33583,24383,28238,54623,30040,26506,31922,30710,45111,11073,10334,10525,25413,10061,20273,10526,11681,16122,28678,23642,39916,10150,30993,14649,20001,55750,10271,20060,32452,10418,27257,19177,30675,10594,32417,28101,20565,10380,10066,10457,10898,10069,10071,13967,13968,56559,56543,56556,56560,15751,24017,76651,24969,21947,23021,33290,45877,34306,32501,58679,58678,28550,29057,58661,81936,35933,29716,29125,33432,73086,77381,45536,30683,31748,15569,28213,30655,26425,25204,17984,28007,32297,48171,15508) [ RunTime:0.023675s ]
- [ 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' => 1892,
'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 (19758,15674,14963,18658,69629,54595,52596,68054,53533,48485,24899,10340,26219,10815,12146,12055,31367,45203,10496,10814,49059,79325,61361,74321,30228,16417,12391,14743,22945,52618,21590,10598,10812,10601,23504,10094,16415,15974,25063,25610,14966,12356,16230,10223,23804,28715,85963,36615,42355,59968,29731,33504,44700,34108,74563,76329,10908,19717,10070,10415,17009,19409,22297,22427,16058,15720,32948,23731,35600,35598,35601,74199,39576,27682,29339,22014,23823,37719,23937,12780,62443,71659,52877,18238,76744,51748,13108,31600,25593,81763,13950,10416,74617,18000,28891,12388,29337,62682,42449,23813,37351,37331,21471,83935,61660,29252,18773,27793,50610,33212,59129,68329,62889,38263,39549,56660,32978,32987,23744,30428,39034,39668,58617,28116,23936,48864,22426,18998,15769,44310,20128,15158,21695,48037,25058,49637,15183,14478,82867,62103,83108,74011,71805,66720,62276,28208,16057,86413,16893,37840,52982,71359,24222,23777,37624,40043,13148,18955,25542,26098,22121,18263,31230,31228,30426,31232,17618,17408,32651,50637,33566,25600,32246,18352,20416,10799,39239,11278,49810,21801,29563,29509,37786,38546,43611,14832,11879,12856,14422,16947,37171,61939,23987,23988,21674,21592,76281,76264,76231,76288,75422,76265,76454,52818,71660,47203,76453,47803,22391,30929,18212,12986,33067,70688,33095,21700,17663,17205,10312,26751,37762,49457,28185,77402,54959,72610,26393,52848,10682,10140,17195,11414,70269,17543,13544,16202,45241,26274,69270,36995,34897,49388,15263,19099,37975,26866,76232,76256,18917,21291,28199,17351,26754,24708,10267,11680,18322,42181,85619,45435,85574,85463,10375,10808,11407,10317,10648,10683,17773,23263,17838,23246,47193,10749,31199,86155,21737,64221,13873,53025,20792,38530,15111,19993,23456,41430,42664,59453,10613,11024,12886,52780,34649,26752,12361,24523,11428,31225,11527,10177,32373,10734,31200,11528,32278,12018,32525,18938,30384,16655,32229,10860,32954,10127,31227,10535,23159,38423,17540,13254,30425,16129,31202,11113,32999,11412,11842,11964,22400,10817,11115,24552,12216,13140,20344,21747,20966,19378,28052,10130,10021,10571,10538,10290,10004,10101,10184,15603,13857,15566,11413,11862,10573,10728,14755,22565,13493,25294,24378,42832,11179,22654,16897,17113,27781,10796,33003,19298,11502,20391,23207,11966,16356,12120,17115,15068,10534,13040,11480,14997,16214,12057,17022,25320,15736,17061,15799,13141,19444,12058,17027,13042,38962,53179,17477,40124,16357,20186,17401,58359,12423,17398,24578,13041,17399,20915,14834,15599,14134,14135,13758,10859,31314,12019,31315,14655,31313,30233,11567,62045,11569,42412,53121,21451,11570,33546,12213,32944,16264,21911,18665,59382,31375,16127,19525,10680,10955,17197,10957,12832,14252,10998,29015,13051,29012,32333,21029,40113,21722,19227,44394,19885,11175,19310,11177,10068,10492,10025,10364,10030,10171,11207,10467,10249,10054,10217,10420,10206,10181,10256,10185,11844,10022,70023,72296,10165,33035,11206,10377,55375,28813,25010,11791,43710,18952,10428,16524,10105,19244,13649,22739,12154,10813,10818,10758,10147,10211,23761,10126,25483,13305,15217,11632,14964,12357,21521,28053,85451,86375,86377,86376,86379,86378,86381,86380,13194,11386,86368,86367,86370,86369,86372,86371,86374,86373,77374,30082,18780,60831,26410,60706,15034,50701,17265,17266,38094,29164,25533,75006,10417,10138,10336,16060,22019,22285,13059,74593,69638,16437,12451,77646,39144,30326,28215,20671,11256,12298,30563,48504,45145,13473,59136,73548,62852,80792,77563,31164,28847,62345,53867,14289,18461,30311,41207,42185,29876,25938,23194,34466,19331,12240,16610,42255,34579,19790,27310,30024,57454,38860,19225,23763,10628,15366,19189,71609,37715,32296,28263,10355,19248,28216,81269,15592,25154,29592,53132,40484,27990,51005,82456,53797,39000,20619,85399,49445,49449,44970,31809,38839,55216,42841,40234,48481,49530,37628,44971,18411,40367,71683,59375,41977,52456,83510,13184,16635,25409,23377,27868,34846,55055,76973,34877,34998,24917,32830,55072,28141,35175,19089,53344,10502,25544,17703,10447,29970,28389,29781,20220,19692,17566,26462,11240,20228,22200,81238,74412,34065,34412,74393,24459,34411,24919,45415,81239,26793,45413,81639,23111,21702,26153,85678,32927,38102,33744,82364,71750,72174,31597,72643,43204,72644,28851,81215,28852,24881,21101,31991,44472,14595,20710,14941,24550,13056,15066,32250,16012,11799,23069,16682,32156,76504,19878,27808,42438,77975,25366,86163,31640,19526,75140,61897,85200,17253,15759,22362,22543,47574,52171,62201,71661,13182,52893,76286,76254,75419,76282,76233,76257,76292,76255,18350,18476,21701,33096,26634,21197,43723,10233,10277,10120,33078,54340,12513,61143,49327,19562,10199,10640,14895,12469,16728,15352,30188,70037,75420,75421,13249,15771,25906,31653,21783,17999,59206,13938,20896,16201,44161,46110,14055,31285,56811,24866,14041,16948,15579,47230,22402,43203,17407,14046,11886,17604,14576,13033,14539,14481,16960,24622,14079,27264,28255,13670,53909,25432,25576,22735,55669,12485,64310,16575,20042,20242,15128,10363,14818,20928,28487,47807,10049,10411,10265,10200,10132,10365,46606,16949,28033,25050,26993,18415,58180,25772,20243,23989,10254,11440,20658,51845,62274,62879,64404,10325,44248,29495,72983,30989,34286,34340,11235,36962,11639,47271,82919,46629,27418,21355,37678,37683,10128,32213,24292,27926,22577,15129,32492,16818,10497,31316,29566,10108,35222,85762,20757,62857,24891,25744,30413,10790,13400,13399,15252,10351,18760,33040,62802,21730,10681,10175,20740,11526,10006,10246,10245,10011,15138,10569,10016,10146,10820,10015,10080,10000,10692,10215,10368,10251,10875,10109,10050,11060,29840,31125,10174,10024,11840,10023,10303,10167,37956,37971,20475,27102,76799,37049,10093,10166,33091,23834,19854,41727,11408,15828,17935,10757,10208,10117,25928,80093,13335,10753,23319,23267,26890,20634,11241,11863,15107,13115,15945,16418,14891,17840,13470,20235,17474,28363,30318,36526,19257,37357,21062,15655,15169,12210,12976,10062,34100,81292,10238,20439,20180,23895,25416,17635,14197,79326,13058,60349,69939,26429,59314,29207,14220,10767,21067,18342,13505,12238,26310,21864,14650,72669,29349,80938,26037,28224,29847,29863,28067,15864,25514,19699,21191,14552,22870,29885,77511,82866,82469,60389,54409,35034,34050,86408,32786,34413,50844,50845,40284,13055,26365,86410,32249,16707,20822,25901,68371,33807,78323,29364,25902,30717,60195,14411,28273,26346,17861,11794,19181,15859,17054,71605,12233,14473,77688,43615,26567,14809,15572,13149,16359,74499,38933,17188,17095,85361,14471,13381,25114,20107,72387,15261,21782,48546,26244,60612,32326,17316,28806,17254,15760,85977,10042,24637,21455,15124,12235,21472,13257,17542,10078,10236,12345,10125,10874,10123,10203,10313,10330,10643,10183,17597,10027,10529,10079,11056,10423,15323,10906,39874,10642,10333,11631,27375,10134,68749,11816,10212,10950,10387,11314,10283,11361,11607,16895,73916,85887,38388,29496,59443,14525,36510,36951,62195,22515,10253,10458,13939,28512,12137,18704,25574,22003,25968,28903,10811,13402,23977,24053,10081,10400,10748,10195,11015,10268,10322,11372,11194,10148,10135,11054,12143,10222,27727,10293,10005,10010,11506,10059,10029,10359,10524,10320,10180,52279,10464,10826,10064,11007,10040,24418,10285,10695,11001,10641,14578,10053,21523,52829,17859,11532,50065,26206,10338,10164,14962,14009,21171,30642,23519,25871,10083,10169,14965,23481,32953,21520,16657,35510,18133,72737,76355,24460,16714,85155,57787,28556,25895,52560,22517,76334,76335,12475,29156,29968,25833,24307,41528,57788,52543,12477,20213,52161,52928,47289,23016,76419,52901,29133,37597,79329,12538,45699,38273,26458,25751,14815,24677,27399,42087,30135,28009,42091,16510,16512,17419,15140,16513,12464,13631,30068,72532,86437,32694,23951,12761,27226,39923,17988,54569,32749,31750,32387,56244,52416,19938,59214,71476,75426,36040,19404,61773,58206,26800,20163,32872,29986,22314,77510,48915,58906,17989,33469,20371,11943,24627,21308,60082,18046,24628,85848,66153,25666,37027,38491,48197,10735,46977,26681,12624,12148,12433,21539,12625,12528,18885,18884,12527,12627,14477,29727,16583,28724,36823,57546,50984,14258,21630,25280,55552,72286,12905,31717,11368,10574,31719,33458,59273,21310,58202,26798,21342,58204,17569,20162,19191,20212,29606,22316,13150,21473,48912,21400,13057,31528,11365,14779,14523,61642,79758,29555,85445,25276,22630,18047,43149,30467,14430,17137,13474,23357,12365,10505,35078,74862,43843,59224,27739,21126,12352,19700,26360,73433,68315,30749,14366,19877,49516,28601,27975,54749,44518,27779,29273,72668,30495,26825,39008,18266,54751,29651,24772,24384,55119,21729,11850,34066,16713,21060,20385,17684,21312,14920,14918,53993,21124,31807,55195,32098,14420,34435,33276,32283,31820,14470,40186,74098,79129,73238,69153,40181,55697,72823,68261,14632,21407,10672,20649,20985,14658,13382,29754,24340,18410,72386,72385,22747,22033,23844,53852,57507,18864,35021,40507,30239,27298,45771,23259,13251,69583,22041,56788,40518,54117,56830,60279,14633,60750,27731,11238,16746,17664,16871,10673,10145,30883,15436,26687,30208,11953,11951,19273,25693,10002,17327,23944,18400,35623,10398,62407,10350,12430,81316,10281,19577,25850,23811,16997,31413,10821,36917,11009,10966,11134,42290,31769,62455,26719,21645,58017,42676,16443,23838,15794,10324,10051,10038,10589,10902,20632,19880,17638,52991,33400,26190,17045,18706,33261,10803,10676,11697,15811,40224,19732,57308,35318,31735,44957,22156,35411,22723,19528,10332,10591,30172,13302,23262,16543,33260,19118,19956,31867,19234,12955,14996,14679,11367,35463,24187,15321,10383,11313,10670,11046,12943,19550,11151,11878,22629,34830,48472,23009,26323,18363,58348,12732,17925,26353,29136,71537,35350,30227,47296,35313,15032,37394,36456,71665,12970,38476,13450,57763,22689,21179,18576,35492,14466,58126,41840,19116,11243,20968,10384,18757,10431,16304,10434,10644,71606,14051,14354,10308,11896,11432,10412,29923,53174,11510,17144,16749,39582,36252,18245,18153,30699,36442,43072,23501,57745,13423,11699,16748,57930,36515,36766,10075,10432,10107,10443,10376,10382,10104,10399,12568,10442,10647,19328,10433,10077,10084,10091,11265,22288,85395,85402,85536,31231,31203,32277,30429,77632,32998,14440,16944,13956,11370,11531,10402,10671,10693,58650,21332,14825,11891,74474,11320,21476,13036,17086,10131,11657,10100,10088,10385,10645,25580,11716,15978,21810,41827,28166,29226,40532,18582,45792,75434,34772,46874,33190,16095,16096,13186,17476,46875,47076,11767,10607,29924,57762,10129,10173,25023,27712,28200,24162,16025,63655,24000,23146,26132,16674,10857,10058,15228,19261,29974,76749,33758,48682,10729,10759,16460,14509,10243,14340,11525,12092,31626,22286,54039,84752,23012,29578,10301,10690,24536,14521,13301,52622,11504,33724,35954,21928,12422,24904,10294,11627,10679,10508,54284,23148,24466,11051,13290,16350,13657,14660,10421,11344,26877,22048,29052,14253,13408,21102,10974,10386,20981,11845,11260,25697,25655,27570,14631,37699,20947,23850,14905,12260,11838,24440,21477,14570,24093,29788,32282,31353,32804,10149,31044,49132,47538,20573,24585,24584,20571,26332,19842,24670,23810,15235,54027,43735,32639,33259,10210,14010,14734,33583,24383,28238,54623,30040,26506,31922,30710,45111,11073,10334,10525,25413,10061,20273,10526,11681,16122,28678,23642,39916,10150,30993,14649,20001,55750,10271,20060,32452,10418,27257,19177,30675,10594,32417,28101,20565,10380,10066,10457,10898,10069,10071,13967,13968,56559,56543,56556,56560,15751,24017,76651,24969,21947,23021,33290,45877,34306,32501,58679,58678,28550,29057,58661,81936,35933,29716,29125,33432,73086,77381,45536,30683,31748,15569,28213,30655,26425,25204,17984,28007,32297,48171,15508) [ RunTime:0.025349s ]
- [ 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' => 1892,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
0.801089s