基本
文件(jian)
流程
錯(cuo)誤(wu)
SQL
調試(shi)
- 請求信息 : 2024-04-26 07:52:24 HTTP/1.1 GET : //t4808.cn/
- 運行時間 : 1.042072s [ 吞吐率:0.96req/s ] 內存消耗:5,907.51kb 文件加載:142
- 查詢信息 : 128 queries 6 writes
- 緩存信息 : 7 reads,4 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 (
)
- [ HEADER ] array (
'connection' => 'Close',
'host' => 't4808.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 (
)
- [ LANG ] /mnt/7kzhanqun/app/portal/lang/zh-cn/home.php
- [ VIEW ] /mnt/7kzhanqun/public/themes/re_sport09/portal/index.html [ array (
0 => 'site_info',
1 => 'event_info',
2 => 'categories',
3 => 'front_theme',
4 => 'tdk',
5 => 'theme_vars',
6 => 'theme_widgets',
) ]
- [ DB ] CONNECT:[ UseTime:0.003202s ] mysql:host=rm-3ns41jmtlb1g0zd6v.mysql.rds.aliyuncs.com;port=3306;dbname=daxiong;charset=utf8mb4
- [ SQL ] SHOW COLUMNS FROM `cmf_plugin_web` [ RunTime:0.001839s ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%t4808.cn%' LIMIT 1 [ RunTime:0.001574s ]
- [ 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' => 77,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%t4808.cn%' LIMIT 1 [ RunTime:0.001698s ]
- [ 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' => 77,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_plugin` [ RunTime:0.001692s ]
- [ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Web' AND `site_id` = 57 LIMIT 1 [ RunTime:0.001633s ]
- [ 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' => 84,
'filtered' => 1.1904761791229248,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%t4808.cn%' LIMIT 1 [ RunTime:0.001555s ]
- [ 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' => 77,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_option` [ RunTime:0.001687s ]
- [ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'cdn_settings' AND `site_id` = 57 LIMIT 1 [ RunTime:0.001594s ]
- [ 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 '%t4808.cn%' LIMIT 1 [ RunTime:0.001590s ]
- [ 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' => 77,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%t4808.cn%' LIMIT 1 [ RunTime:0.001498s ]
- [ 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' => 77,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `status` FROM `cmf_plugin_web` WHERE `id` = 57 LIMIT 1 [ RunTime:0.001528s ]
- [ 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 '%t4808.cn%' LIMIT 1 [ RunTime:0.001561s ]
- [ 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' => 77,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 57 LIMIT 1 [ RunTime:0.001534s ]
- [ 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 '%t4808.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' => 77,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%t4808.cn%' LIMIT 1 [ RunTime:0.001516s ]
- [ 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' => 77,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%t4808.cn%' LIMIT 1 [ RunTime:0.001657s ]
- [ 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' => 77,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'site_info' AND `site_id` = 57 LIMIT 1 [ RunTime:0.001595s ]
- [ 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 `option_value` FROM `cmf_option` WHERE `option_name` = 'admin_settings' AND `site_id` = 57 LIMIT 1 [ RunTime:0.001675s ]
- [ 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.001803s ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` WHERE `status` = 1 [ RunTime:0.001802s ]
- [ 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' => 468,
'filtered' => 9.999999046325684,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%t4808.cn%' LIMIT 1 [ RunTime:0.001561s ]
- [ 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' => 77,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 57 LIMIT 1 [ RunTime:0.001618s ]
- [ 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.001892s ]
- [ SQL ] SELECT `pinyin` FROM `cmf_nami_competitions` WHERE `id` = 0 LIMIT 1 [ RunTime:0.001641s ]
- [ 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 ] SELECT `com_type` FROM `cmf_nami_competitions` WHERE `id` = 0 LIMIT 1 [ RunTime:0.001608s ]
- [ 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 ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%t4808.cn%' LIMIT 1 [ RunTime:0.001544s ]
- [ 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' => 77,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.001876s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 're_sport09' AND `file` = 'portal/article' LIMIT 1 [ RunTime:0.001735s ]
- [ 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' => 151,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 're_sport09' , `action` = 'portal/Article/index' , `file` = 'portal/article' , `name` = '資訊詳情頁' , `more` = '[]' , `config_more` = '[]' , `description` = '資訊詳情頁模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 're_sport09' AND `file` = 'portal/article' [ RunTime:0.001754s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 're_sport09' AND `file` = 'portal/competition' 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' => 151,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 're_sport09' , `action` = 'portal/Competition/index' , `file` = 'portal/competition' , `name` = '賽程列表頁' , `more` = '{\"vars\":[]}' , `config_more` = '{\"vars\":[]}' , `description` = '賽程列表模板文件' , `is_public` = 0 , `list_order` = 0 WHERE `theme` = 're_sport09' AND `file` = 'portal/competition' [ RunTime:0.001722s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 're_sport09' AND `file` = 'portal/index' LIMIT 1 [ RunTime:0.001670s ]
- [ 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' => 151,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 're_sport09' , `action` = 'portal/Index/index' , `file` = 'portal/index' , `name` = '首頁' , `more` = '{\"vars\":[]}' , `config_more` = '{\"vars\":[]}' , `description` = '首頁模板文件' , `is_public` = 0 , `list_order` = 0 WHERE `theme` = 're_sport09' AND `file` = 'portal/index' [ RunTime:0.001718s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 're_sport09' AND `file` = 'portal/list' LIMIT 1 [ RunTime:0.001674s ]
- [ 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' => 151,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 're_sport09' , `action` = 'portal/List/index' , `file` = 'portal/list' , `name` = '資訊列表頁' , `more` = '[]' , `config_more` = '[]' , `description` = '資訊列表模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 're_sport09' AND `file` = 'portal/list' [ RunTime:0.001732s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 're_sport09' AND `file` = 'portal/match' LIMIT 1 [ RunTime:0.001637s ]
- [ 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' => 151,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 're_sport09' , `action` = 'portal/Match/index' , `file` = 'portal/match' , `name` = '賽事詳情頁' , `more` = '{\"vars\":[]}' , `config_more` = '{\"vars\":[]}' , `description` = '賽事詳情頁模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 're_sport09' AND `file` = 'portal/match' [ RunTime:0.001668s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 're_sport09' [ RunTime:0.001603s ]
- [ 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' => 151,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_theme` [ RunTime:0.001680s ]
- [ SQL ] UPDATE `cmf_theme` SET `name` = '7k_shanufs' , `version` = '1.0.2' , `demo_url` = '//www.shanufs.cn/' , `author` = '1408' , `lang` = 'zh-cn' , `author_url` = '' , `keywords` = '7k_shanufs' , `description` = '7k_shanufs' WHERE `theme` = 're_sport09' [ RunTime:0.001577s ]
- [ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = 're_sport09' AND ( `is_public` = 1 OR `file` = 'portal/index' ) [ RunTime:0.001630s ]
- [ 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' => 151,
'filtered' => 1.899999976158142,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%t4808.cn%' LIMIT 1 [ RunTime:0.001597s ]
- [ 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' => 77,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'storage' AND `site_id` = 57 LIMIT 1 [ RunTime:0.001561s ]
- [ 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 '%t4808.cn%' LIMIT 1 [ RunTime:0.001644s ]
- [ 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' => 77,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Oss' AND `site_id` = 57 LIMIT 1 [ RunTime:0.001584s ]
- [ 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' => 84,
'filtered' => 1.1904761791229248,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%t4808.cn%' LIMIT 1 [ RunTime:0.001572s ]
- [ 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' => 77,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%t4808.cn%' LIMIT 1 [ RunTime:0.001534s ]
- [ 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' => 77,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_nav` [ RunTime:0.001722s ]
- [ SQL ] SELECT `id` FROM `cmf_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.001520s ]
- [ 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 ] SHOW COLUMNS FROM `cmf_nav_menu` [ RunTime:0.001613s ]
- [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `site_id` = 57 AND `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.001799s ]
- [ 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' => 582,
'filtered' => 0.17182131111621857,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%t4808.cn%' LIMIT 1 [ RunTime:0.001564s ]
- [ 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' => 77,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `cid` FROM `cmf_nami_competitions` WHERE `pinyin` = 'all' AND `com_type` = 0 LIMIT 1 [ RunTime:0.002918s ]
- [ 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' => 3513,
'filtered' => 1.0,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_nami_matches` [ RunTime:0.001808s ]
- [ SQL ] SELECT * FROM `cmf_nami_matches` WHERE ( `match_time` > 1714074745 ) ORDER BY `match_time` ASC LIMIT 1 [ RunTime:0.001764s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_matches',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'match_time',
'key' => 'match_time',
'key_len' => '5',
'ref' => NULL,
'rows' => 24044,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` = 3387 [ RunTime:0.001678s ]
- [ 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` = 3387 [ RunTime:0.001645s ]
- [ 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_nami_teams` [ RunTime:0.001742s ]
- [ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (69752,65349) [ RunTime:0.001562s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_teams',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 1,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (69752,65349) [ RunTime:0.001568s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_teams',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 1,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `cid` FROM `cmf_nami_competitions` WHERE `pinyin` = 'all' AND `com_type` = 0 LIMIT 1 [ RunTime:0.002737s ]
- [ 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' => 3513,
'filtered' => 1.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_matches` WHERE ( `match_time` > 1714074745 ) ORDER BY `match_time` ASC LIMIT 1000 [ RunTime:0.006607s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_matches',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'match_time',
'key' => 'match_time',
'key_len' => '5',
'ref' => NULL,
'rows' => 24044,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` IN (3387,1528,452,1917,3229,1742,3035,1729,396,398,1918,1699,538,477,41,3078,1,3396,4065,3811,483,3706,1683,710,488,2851,76,765,2115,3899,466,282,489,3380,3134,5118,11,5750,500,1926,36,3977,1886,1788,241,3988,4067,34,67,3203,255,2915,357,3083,3900,591,592,3978,254,4235,1923,590,1660,1806,349,1871,595,542,3987,4066,593,598,829,3983,1892,600,1663,31,2846,676,1666,1853,3,3364,3394,3982,1579,682,370,717,1719,368,679,1668,97,2815,548,348,277,1799,617,96,3264,1733,274,1667,3060,301,341,333,3373,534,470,1739,627,626,648,363,297,260,276,405,12,727,385,195,293,614,870,720,1905,337,13,344,3527,47,655,3314,197,296,32,275,69,1940,267,37,66,62,3959,642,361,198,992,294,112,330,245,199,1679,377,220,3478,42,144,130,2159,1831,315,132,221,191,187,209,210,229,131,186,145,270,2791,211,1907,332,219,247,1163,716,178,10,169,179,234,4021,57,308,701,1718,721,86,225,226,58,3008,129,109,113,246,121,228,175,159,108,142,83,120,182,1677,151,1782,471,476,407,473,436,2984,462,1738,469,459,458,478,3972,465,603,5711,486,1834,570,567,572,571,601,569,1878,26,597,581,568,582,584,3079,3295,602,5,4044,2782,545,546,544,3073,1746,543,3374,263,271,838,240,2918,259,133,356,3319,3986,249,248,134,362,364,214,1952,253,124,152,2742,3200,3357,3874,222,659,660,190,1842,2775,1740,3253,1867) [ RunTime:0.006736s ]
- [ 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' => 296,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` IN (3387,1528,452,1917,3229,1742,3035,1729,396,398,1918,1699,538,477,41,3078,1,3396,4065,3811,483,3706,1683,710,488,2851,76,765,2115,3899,466,282,489,3380,3134,5118,11,5750,500,1926,36,3977,1886,1788,241,3988,4067,34,67,3203,255,2915,357,3083,3900,591,592,3978,254,4235,1923,590,1660,1806,349,1871,595,542,3987,4066,593,598,829,3983,1892,600,1663,31,2846,676,1666,1853,3,3364,3394,3982,1579,682,370,717,1719,368,679,1668,97,2815,548,348,277,1799,617,96,3264,1733,274,1667,3060,301,341,333,3373,534,470,1739,627,626,648,363,297,260,276,405,12,727,385,195,293,614,870,720,1905,337,13,344,3527,47,655,3314,197,296,32,275,69,1940,267,37,66,62,3959,642,361,198,992,294,112,330,245,199,1679,377,220,3478,42,144,130,2159,1831,315,132,221,191,187,209,210,229,131,186,145,270,2791,211,1907,332,219,247,1163,716,178,10,169,179,234,4021,57,308,701,1718,721,86,225,226,58,3008,129,109,113,246,121,228,175,159,108,142,83,120,182,1677,151,1782,471,476,407,473,436,2984,462,1738,469,459,458,478,3972,465,603,5711,486,1834,570,567,572,571,601,569,1878,26,597,581,568,582,584,3079,3295,602,5,4044,2782,545,546,544,3073,1746,543,3374,263,271,838,240,2918,259,133,356,3319,3986,249,248,134,362,364,214,1952,253,124,152,2742,3200,3357,3874,222,659,660,190,1842,2775,1740,3253,1867) [ RunTime:0.003981s ]
- [ 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' => 296,
'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 (69752,65349,25902,29364,22255,21242,34229,34341,15975,40251,60259,69465,10547,36478,69688,69691,22493,12341,12391,10149,11572,17859,15674,23810,27430,11532,33251,29106,59979,44210,36036,60033,20235,13399,49897,49853,33688,24019,23320,32953,50493,70663,14998,10813,14639,15828,38802,16007,11304,10093,14116,12357,36503,25064,23319,23266,28470,13102,44793,44923,14010,25010,43872,52269,37632,10726,23481,22494,26206,33450,13470,10338,32639,10818,50591,69711,10553,30318,42064,42063,24095,21850,76821,26892,76815,74761,76818,60474,81382,81481,80880,80857,80866,80952,80870,80855,80856,80895,80858,80948,80881,80869,80894,80865,12643,42893,46442,11123,15616,55406,29786,32174,32115,15284,26800,36040,71476,58202,82513,25904,80936,40228,69554,58224,74191,74192,76816,22810,78601,61835,60102,60221,57786,28556,57788,41528,76453,52818,24807,74468,20106,58610,56838,31414,81697,20514,24134,20582,21910,24237,18138,19167,11927,24558,16347,74382,13968,15569,36346,59772,32719,36347,21318,36610,38081,72532,25978,37640,12625,37626,42957,30068,23822,29336,11740,32694,29340,26866,38263,23777,38273,37840,22014,42664,37624,25932,29339,16893,37975,24222,37719,40043,52560,22517,24804,22124,34514,26723,21856,31282,30273,53336,34313,59214,75426,20163,20162,76452,47574,47203,47796,69536,82485,26152,30337,28313,60282,24974,25653,23659,25285,32780,11990,31262,13233,27613,34721,19996,30338,14790,18134,36370,17388,37861,30092,33866,45373,10139,33738,74873,17491,34304,40692,56837,61661,37740,19638,20522,43055,57215,32948,30780,69638,81775,22967,25280,58505,13059,17618,21399,19700,77646,11602,48183,13157,10766,10700,23094,10767,10009,50542,10218,36751,23194,19404,58206,19191,61773,20213,17569,19938,21342,48130,10138,39495,73147,38215,77647,69636,81773,69491,62583,17253,17407,53867,16948,41977,52456,15064,44952,53433,48481,40234,42841,29779,25751,27399,19157,28220,42087,42091,17055,15356,16789,34050,34846,59247,75212,31232,16505,50491,45046,44797,59835,32544,33491,11678,13262,34515,27924,18885,12148,12527,21539,12624,13161,22698,18884,11039,12627,23778,59379,19566,13473,17419,15140,16512,12464,16510,13631,16513,16515,22623,16511,69534,69537,81500,81628,37992,12859,20772,11828,32998,31201,58617,59375,17002,62187,24577,12269,48197,18010,20212,58204,52161,26798,74845,20479,30239,45771,22349,42856,11362,28259,81269,71750,26247,23331,18054,18057,31502,25128,27265,62433,16738,18700,52702,72904,25200,68190,72319,32784,38502,58534,20518,19639,20242,20384,14918,21309,19105,72298,16663,60612,55751,43301,69488,79909,21135,25837,28782,12761,26708,26665,47664,73135,29820,20372,14424,11236,25458,38899,16732,72668,15760,14046,30243,26084,28159,29207,14411,14220,26751,27397,62201,71660,18238,52877,10746,12047,27611,27598,35021,22041,14633,13251,18065,14077,13150,19182,22380,24550,17057,22935,20671,14722,55697,31820,39053,15446,73275,73527,17035,17813,61642,79129,12353,17519,76231,75419,76265,75422,50906,57642,17052,45241,68191,78303,16688,14425,17246,14786,28598,16121,13387,36758,65571,11321,26103,14779,12977,14895,10363,15439,27468,24340,29754,18410,72387,21035,24705,51245,21410,56830,40518,26445,23452,23067,69787,51286,23500,17483,11887,59179,13544,19642,23961,21759,11839,10281,16700,17259,34123,35704,15525,30788,41947,32893,12645,10398,23944,25693,10803,11262,19273,79885,79884,80032,74014,74059,10435,21476,10047,10331,10912,10332,17559,74024,18981,28163,21312,16713,24627,17684,74843,18310,19620,10643,10312,44256,26353,20991,13302,47595,32343,15707,17131,40754,23851,15761,16723,31481,36469,21112,60540,74844,11743,15321,11046,10383,11313,11214,29381,12209,30133,35411,10483,10722,26687,17072,10017,10449,12275,47318,11672,12547,14994,12669,15164,11401,31855,30960,14914,11891,19234,33574,10412,10984,13122,39622,36482,16816,14726,23913,28663,31901,36049,32757,10402,23993,23110,39765,10396,11779,12870,17542,10073,11042,10676,11312,13076,25431,31783,29313,36510,36951,47582,15319,12442,36766,18413,26681,26243,48546,11925,22723,35492,22157,10434,16664,28799,10308,10384,25636,10644,11243,14051,25580,18757,23334,16304,12839,32629,58126,24876,20658,19199,26713,17621,13666,36531,10431,10213,10397,12978,11951,17330,17328,11068,11815,22176,38919,16748,23501,17144,17743,16973,14996,71646,71758,59183,42181,36493,15046,56495,46213,53356,57762,48048,33443,66954,33820,10938,17827,35779,11244,57546,44950,26190,32651,23385,23559,10107,10427,10077,10433,10442,10329,10084,22288,11265,10091,10977,10454,13257,26567,32279,31199,32954,32229,30384,23159,30425,21731,31200,31315,31313,31225,57798,49037,27835,29052,25850,47760,12744,11510,32492,31227,14971,21820,37537,57763,29408,31581,33758,29923,14818,14757,14525,18411,18207,30158,15637,31564,74616,23520,31541,28646,70232,28904,32532,22510,82433,21188,32573,69194,34933,40698,14685,44539,30001,49598,70091,28709,39398,28787,62300,22508,13329,28644,61984,25806,70102,82435,55159,53069,25926,34456,82434,74621,25707,44534,25929,69196,28027,24849,25893,31543,25872,22462,80088,44543,28936,22458,31565,12815,29007,24894,23513,21181,12816,43551,15633,25927,15634,31542,25777,82432,82437,29002,31396,36606,65348,74923,30883,16942,12949,73352,12680,11315,15729,14049,29924,48682,14660,26572,10028,10322,31625,31626,16822,11076,12619,13403,43203,31597,10285,10243,10517,10516,29434,10221,76981,76982,22689,11909,33105,29887,29655,12647,20576,32658,35193,34069,10161,10162,10484,10067,10111,10462,10095,10459,11924,11188,11406,73932,60356,11189,15216,10300,24749,24890,22397,10955,29012,17197,29013,28949,12831,11000,12524,10216,10729,12434,10914,11205,10333,10163,10290,10175,10222,10217,37984,37971,11838,21981,16166,40751,24967,35405,32282,37058,20234,16438,65350,65347,34101,30802,22342,12183,27301,14778,12054,12055,14806,12145,11303,12053,24093,14570,17673,14688,12146,38079,12051,26475,16415,26219,10815,17187,16551,22635,15235,51493,74603,11263,11977,17406,14508,29926,17127,19842,19758,29427,34422,27791,16891,81339,21431,12063,10816,13469,33259,14117,20233,11404,11241,74541,14887,29672,25511,37018,24251,69573,60531,80859,80861,21521,21520,35073,22056,12600,21836,80862,80871,80854,80860,11386,13194,50071,39500,26451,68782,16122,11681,30510,13543,32417,20674,40568,68779,18778,59235,26447,19775,68781,59282,68756,54558,26409,14310,69829,14959,18779,21919,26407,34244,25461,81471,34245,74386,26381,31537,15921,37232,29311,33628,11930,34426,74095,40781,25654,21447,33693,50836,29908,29069,28503,21445,34626,30446,30447,20387,10438,10305,10069,25413,10066,10061,10070,20273,10593,10060,12529,28038,15733,24121,14311,29963,30710,27116,32452,55750,18777,19760,69452,20002,20061,23641,60216,20003,20004,20057,74245,19172,18780,60706,20565,60831,45461,57702,26302,29360,19177,76355,37495,45266,30445,28779,30334,26776,29757,30169,14475,10909,51063,34447,10457,10336,40083,30332,26502,22083,80864,80874,26364,22190,30093,29902,80863,80868,26416,45901,33625,45496,23023,59898,45359,40430,32994,42255,27612,18136,20231,10986,20230,15315,25070,15020,18279,71266,50536,40074,56559,56560,24969,76516,35072,31898,16714,16230,14753,59450,27419,22861,10652,23021,10415,21947,23642,28678,10271,39916,14346,10194,13028,48371,40926,19190,14845,13943,30507,30104,26518,41056,30478,30476,31780,26431,30655,26425,23932,26994,18461,53240,48171,27238,32043,17984,16875,25204,52700,61939,28007,33419,26634,77349,31805,61688,56543,56557,74806,82052,34258,73346,40102,48184,39579,15452,26591,29147,30202,35987,27369,10356,25702,18408,15331,52860,19742,49039,45893,76501,37171,19889,30477,29611,15332,57577,21333,17449,20985,14572,18402,52859,24231,31061,52543,29156,12477,62063,24307,12475,25085,40399,28420,15558,26308,29054,23359,26176,60370,16394,80867,80840,31763,39830,14841,26517,47691,27295,27317,25554,58314,27888,26691,32586,30570,26756,26755,24624,32657,42062,27293,29877,25233,19552,27294,25188,29997,27980,28384,25555,25232,25273,32688,31335,25272,17778,27706,21798,24708,31656,31680,26753,24626,26754,29271,76423,76424,27968,12905,32156,30819,40556,24135,30022,26048,18137,28673,22266,10736,69862,45470,28746,25906,40103,25938,23931,27312,21684,78337,74022,21368,45816,27541,29818,13590,19789,18845,57582,26757,16960,32722,18125,69939,40691,19458,25761,22993,29540,24274,14152,20655,11748,26775,30336,18533,43572,20291,28902,74259,17154,59738,30419,20509,39915,30410,40126,77501,71647,27602,58017,14546,21683,51937,13490,48009,30799,81896,13505,21735,27868,13967,24460,36178,36366,17754,38627,29732,51411,14440,31229,30654,29876,61936,71963,23187,46047,27280,70182,41460,11015,47124,11368,29817,31089,20572,20573,20571,21765,21764,19256,30779,54721,54741,24964,30989,22515,37683,29496,16300,16450,56544,56556,14538,39718,33418,58660,56879,27333,11043,16930,58638,37414,49398,38345,17015,34818,48217,58455,32847,49969,24601,11120,17080,52045,76321,16998,15108,16150,30610,25666,10777,23377,21736,30487,16387,19780,62345,58356,62393,20529,61498,37641,29029,58333,17923,17922,21734,21737,21733,28892,10905,20632,16060,26429,34394,58554,28616,29020,25384,31370,39923,28695,36709,28615,30101,29985,31750,50110,49803,51805,27226,29061,11024,18927,40763,21115,21453,26993,20719,58180,27310,28603,23259,40507,10324,10051,11274,10589,10913,10853,22600,21138,13566,19200,14906,45676,12548,32738,13296,12661,81073,45828,56567,81807,19654,10896,29936,28345,57475,18078,19322,23664,11367,24187,10124,26350,12349,33296,36151,27686,40530,11470,29103,29063,40377,53876,16741,18350,16682,19389,11812,11814,12435,10395,18107,16846,16979,71665,36456,13959,18268,16829,13549,14819,25600,18214,60999,80041,82425,82426,37741,16701,16919,73371,11744,62156,11773,16827,12872,16935,17067,16988,16621,78581,49081,72774,34540,39706,27195,36387) [ RunTime:0.011029s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_teams',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 1,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (33739,34054,30384,27584,19402,35950,39648,39646,10120,10127,39475,15421,30870,30941,10116,10115,37654,39449,36267,36360,30004,29872,36015,41057,14139,39663,36245,38096,10984,33923,12049,30271,27509,41002,21901,40839,33479,39474,22045,19426,10149,10148,30921,30938,10268,13089,40918,11019,11361,11352,23167,10900,18356,35546,22598,18553,22853,12343,14459,14235,11356,27891,27792,22601,12713,11710,14774,22573,10995,11003,14793,19478,14237,14451,22989,14265,11034,18161,14446,33220,22602,14432,14449,12342,11032,22600,14417,14442,14470,14485,12330,12628,10944,10939,11713,11718,10725,10724,10731,10722,14419,14477,14429,14430,40378,36497,18193,15033,13134,40086,19582,40104,24253,39827,26593,32049,14555,13017,10143,12296,10301,13060,10751,38699,35585,11222,11215,11200,12971,37189,30649,11592,11544,11197,30178,10747,13004,10763,24884,25197,12281,15053,10973,11005,11697,10766,10749,40230,34266,13074,14896,15644,38711,11198,11137,12568,10240,11497,10245,11571,11533,12650,11530,11850,11523,12601,12582,10261,14152,19549,12419,10923,10247,24574,10248,36695,10256,40482,14521,10752,10692,11127,28788,40064,11473,34652,10109,10107,10258,10146,10122,10136,12552,11612,11163,34905,11028,35421,12549,35146,11149,10130,10129,11035,20462,11287,18638,32332,18239,34040,34000,21975,40540,25842,12007,12744,11820,15417,10131,10156,28761,14249,10981,28185,11617,12448,14445,14479,11001,14450,10102,10164,11892,11893,11470,11471,37421,40391,10930,10782,11468,11465,11464,30756,11467,12261,11903,11466,12730,11103,33422,19002,27884,11358,11359,14447,14336,12462,12074,10786,12244,11472,12094,36923,10788,11322,12344,38046,11355,35529,14253,10893,14437,14251,14271,11357,11351,14287,11360,10913,11722,14440,14438,38018,14254,14241,14242,33423,19003,27965,14471,14236,14418,18422,18163,10987,10993,18731,18425,14484,18729,18429,14640,14151,14641,18730,14456,14452,14453,14264,10999,10996,28046,14424,11004,35432,14468,14403,10992,17882,14443,10994,11000,14565,38765,38180,11709,37989,14259,14256,14454,17959,14405,14564,15051,18736,14537,18436,18734,18735,18551,18390,18732,14150,14638,14476,14455,14478,14420,27964,14473,14289) [ RunTime:0.002505s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_teams',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 1,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (69752,65349,25902,29364,22255,21242,34229,34341,15975,40251,60259,69465,10547,36478,69688,69691,22493,12341,12391,10149,11572,17859,15674,23810,27430,11532,33251,29106,59979,44210,36036,60033,20235,13399,49897,49853,33688,24019,23320,32953,50493,70663,14998,10813,14639,15828,38802,16007,11304,10093,14116,12357,36503,25064,23319,23266,28470,13102,44793,44923,14010,25010,43872,52269,37632,10726,23481,22494,26206,33450,13470,10338,32639,10818,50591,69711,10553,30318,42064,42063,24095,21850,76821,26892,76815,74761,76818,60474,81382,81481,80880,80857,80866,80952,80870,80855,80856,80895,80858,80948,80881,80869,80894,80865,12643,42893,46442,11123,15616,55406,29786,32174,32115,15284,26800,36040,71476,58202,82513,25904,80936,40228,69554,58224,74191,74192,76816,22810,78601,61835,60102,60221,57786,28556,57788,41528,76453,52818,24807,74468,20106,58610,56838,31414,81697,20514,24134,20582,21910,24237,18138,19167,11927,24558,16347,74382,13968,15569,36346,59772,32719,36347,21318,36610,38081,72532,25978,37640,12625,37626,42957,30068,23822,29336,11740,32694,29340,26866,38263,23777,38273,37840,22014,42664,37624,25932,29339,16893,37975,24222,37719,40043,52560,22517,24804,22124,34514,26723,21856,31282,30273,53336,34313,59214,75426,20163,20162,76452,47574,47203,47796,69536,82485,26152,30337,28313,60282,24974,25653,23659,25285,32780,11990,31262,13233,27613,34721,19996,30338,14790,18134,36370,17388,37861,30092,33866,45373,10139,33738,74873,17491,34304,40692,56837,61661,37740,19638,20522,43055,57215,32948,30780,69638,81775,22967,25280,58505,13059,17618,21399,19700,77646,11602,48183,13157,10766,10700,23094,10767,10009,50542,10218,36751,23194,19404,58206,19191,61773,20213,17569,19938,21342,48130,10138,39495,73147,38215,77647,69636,81773,69491,62583,17253,17407,53867,16948,41977,52456,15064,44952,53433,48481,40234,42841,29779,25751,27399,19157,28220,42087,42091,17055,15356,16789,34050,34846,59247,75212,31232,16505,50491,45046,44797,59835,32544,33491,11678,13262,34515,27924,18885,12148,12527,21539,12624,13161,22698,18884,11039,12627,23778,59379,19566,13473,17419,15140,16512,12464,16510,13631,16513,16515,22623,16511,69534,69537,81500,81628,37992,12859,20772,11828,32998,31201,58617,59375,17002,62187,24577,12269,48197,18010,20212,58204,52161,26798,74845,20479,30239,45771,22349,42856,11362,28259,81269,71750,26247,23331,18054,18057,31502,25128,27265,62433,16738,18700,52702,72904,25200,68190,72319,32784,38502,58534,20518,19639,20242,20384,14918,21309,19105,72298,16663,60612,55751,43301,69488,79909,21135,25837,28782,12761,26708,26665,47664,73135,29820,20372,14424,11236,25458,38899,16732,72668,15760,14046,30243,26084,28159,29207,14411,14220,26751,27397,62201,71660,18238,52877,10746,12047,27611,27598,35021,22041,14633,13251,18065,14077,13150,19182,22380,24550,17057,22935,20671,14722,55697,31820,39053,15446,73275,73527,17035,17813,61642,79129,12353,17519,76231,75419,76265,75422,50906,57642,17052,45241,68191,78303,16688,14425,17246,14786,28598,16121,13387,36758,65571,11321,26103,14779,12977,14895,10363,15439,27468,24340,29754,18410,72387,21035,24705,51245,21410,56830,40518,26445,23452,23067,69787,51286,23500,17483,11887,59179,13544,19642,23961,21759,11839,10281,16700,17259,34123,35704,15525,30788,41947,32893,12645,10398,23944,25693,10803,11262,19273,79885,79884,80032,74014,74059,10435,21476,10047,10331,10912,10332,17559,74024,18981,28163,21312,16713,24627,17684,74843,18310,19620,10643,10312,44256,26353,20991,13302,47595,32343,15707,17131,40754,23851,15761,16723,31481,36469,21112,60540,74844,11743,15321,11046,10383,11313,11214,29381,12209,30133,35411,10483,10722,26687,17072,10017,10449,12275,47318,11672,12547,14994,12669,15164,11401,31855,30960,14914,11891,19234,33574,10412,10984,13122,39622,36482,16816,14726,23913,28663,31901,36049,32757,10402,23993,23110,39765,10396,11779,12870,17542,10073,11042,10676,11312,13076,25431,31783,29313,36510,36951,47582,15319,12442,36766,18413,26681,26243,48546,11925,22723,35492,22157,10434,16664,28799,10308,10384,25636,10644,11243,14051,25580,18757,23334,16304,12839,32629,58126,24876,20658,19199,26713,17621,13666,36531,10431,10213,10397,12978,11951,17330,17328,11068,11815,22176,38919,16748,23501,17144,17743,16973,14996,71646,71758,59183,42181,36493,15046,56495,46213,53356,57762,48048,33443,66954,33820,10938,17827,35779,11244,57546,44950,26190,32651,23385,23559,10107,10427,10077,10433,10442,10329,10084,22288,11265,10091,10977,10454,13257,26567,32279,31199,32954,32229,30384,23159,30425,21731,31200,31315,31313,31225,57798,49037,27835,29052,25850,47760,12744,11510,32492,31227,14971,21820,37537,57763,29408,31581,33758,29923,14818,14757,14525,18411,18207,30158,15637,31564,74616,23520,31541,28646,70232,28904,32532,22510,82433,21188,32573,69194,34933,40698,14685,44539,30001,49598,70091,28709,39398,28787,62300,22508,13329,28644,61984,25806,70102,82435,55159,53069,25926,34456,82434,74621,25707,44534,25929,69196,28027,24849,25893,31543,25872,22462,80088,44543,28936,22458,31565,12815,29007,24894,23513,21181,12816,43551,15633,25927,15634,31542,25777,82432,82437,29002,31396,36606,65348,74923,30883,16942,12949,73352,12680,11315,15729,14049,29924,48682,14660,26572,10028,10322,31625,31626,16822,11076,12619,13403,43203,31597,10285,10243,10517,10516,29434,10221,76981,76982,22689,11909,33105,29887,29655,12647,20576,32658,35193,34069,10161,10162,10484,10067,10111,10462,10095,10459,11924,11188,11406,73932,60356,11189,15216,10300,24749,24890,22397,10955,29012,17197,29013,28949,12831,11000,12524,10216,10729,12434,10914,11205,10333,10163,10290,10175,10222,10217,37984,37971,11838,21981,16166,40751,24967,35405,32282,37058,20234,16438,65350,65347,34101,30802,22342,12183,27301,14778,12054,12055,14806,12145,11303,12053,24093,14570,17673,14688,12146,38079,12051,26475,16415,26219,10815,17187,16551,22635,15235,51493,74603,11263,11977,17406,14508,29926,17127,19842,19758,29427,34422,27791,16891,81339,21431,12063,10816,13469,33259,14117,20233,11404,11241,74541,14887,29672,25511,37018,24251,69573,60531,80859,80861,21521,21520,35073,22056,12600,21836,80862,80871,80854,80860,11386,13194,50071,39500,26451,68782,16122,11681,30510,13543,32417,20674,40568,68779,18778,59235,26447,19775,68781,59282,68756,54558,26409,14310,69829,14959,18779,21919,26407,34244,25461,81471,34245,74386,26381,31537,15921,37232,29311,33628,11930,34426,74095,40781,25654,21447,33693,50836,29908,29069,28503,21445,34626,30446,30447,20387,10438,10305,10069,25413,10066,10061,10070,20273,10593,10060,12529,28038,15733,24121,14311,29963,30710,27116,32452,55750,18777,19760,69452,20002,20061,23641,60216,20003,20004,20057,74245,19172,18780,60706,20565,60831,45461,57702,26302,29360,19177,76355,37495,45266,30445,28779,30334,26776,29757,30169,14475,10909,51063,34447,10457,10336,40083,30332,26502,22083,80864,80874,26364,22190,30093,29902,80863,80868,26416,45901,33625,45496,23023,59898,45359,40430,32994,42255,27612,18136,20231,10986,20230,15315,25070,15020,18279,71266,50536,40074,56559,56560,24969,76516,35072,31898,16714,16230,14753,59450,27419,22861,10652,23021,10415,21947,23642,28678,10271,39916,14346,10194,13028,48371,40926,19190,14845,13943,30507,30104,26518,41056,30478,30476,31780,26431,30655,26425,23932,26994,18461,53240,48171,27238,32043,17984,16875,25204,52700,61939,28007,33419,26634,77349,31805,61688,56543,56557,74806,82052,34258,73346,40102,48184,39579,15452,26591,29147,30202,35987,27369,10356,25702,18408,15331,52860,19742,49039,45893,76501,37171,19889,30477,29611,15332,57577,21333,17449,20985,14572,18402,52859,24231,31061,52543,29156,12477,62063,24307,12475,25085,40399,28420,15558,26308,29054,23359,26176,60370,16394,80867,80840,31763,39830,14841,26517,47691,27295,27317,25554,58314,27888,26691,32586,30570,26756,26755,24624,32657,42062,27293,29877,25233,19552,27294,25188,29997,27980,28384,25555,25232,25273,32688,31335,25272,17778,27706,21798,24708,31656,31680,26753,24626,26754,29271,76423,76424,27968,12905,32156,30819,40556,24135,30022,26048,18137,28673,22266,10736,69862,45470,28746,25906,40103,25938,23931,27312,21684,78337,74022,21368,45816,27541,29818,13590,19789,18845,57582,26757,16960,32722,18125,69939,40691,19458,25761,22993,29540,24274,14152,20655,11748,26775,30336,18533,43572,20291,28902,74259,17154,59738,30419,20509,39915,30410,40126,77501,71647,27602,58017,14546,21683,51937,13490,48009,30799,81896,13505,21735,27868,13967,24460,36178,36366,17754,38627,29732,51411,14440,31229,30654,29876,61936,71963,23187,46047,27280,70182,41460,11015,47124,11368,29817,31089,20572,20573,20571,21765,21764,19256,30779,54721,54741,24964,30989,22515,37683,29496,16300,16450,56544,56556,14538,39718,33418,58660,56879,27333,11043,16930,58638,37414,49398,38345,17015,34818,48217,58455,32847,49969,24601,11120,17080,52045,76321,16998,15108,16150,30610,25666,10777,23377,21736,30487,16387,19780,62345,58356,62393,20529,61498,37641,29029,58333,17923,17922,21734,21737,21733,28892,10905,20632,16060,26429,34394,58554,28616,29020,25384,31370,39923,28695,36709,28615,30101,29985,31750,50110,49803,51805,27226,29061,11024,18927,40763,21115,21453,26993,20719,58180,27310,28603,23259,40507,10324,10051,11274,10589,10913,10853,22600,21138,13566,19200,14906,45676,12548,32738,13296,12661,81073,45828,56567,81807,19654,10896,29936,28345,57475,18078,19322,23664,11367,24187,10124,26350,12349,33296,36151,27686,40530,11470,29103,29063,40377,53876,16741,18350,16682,19389,11812,11814,12435,10395,18107,16846,16979,71665,36456,13959,18268,16829,13549,14819,25600,18214,60999,80041,82425,82426,37741,16701,16919,73371,11744,62156,11773,16827,12872,16935,17067,16988,16621,78581,49081,72774,34540,39706,27195,36387) [ RunTime:0.010584s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_teams',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 1,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (33739,34054,30384,27584,19402,35950,39648,39646,10120,10127,39475,15421,30870,30941,10116,10115,37654,39449,36267,36360,30004,29872,36015,41057,14139,39663,36245,38096,10984,33923,12049,30271,27509,41002,21901,40839,33479,39474,22045,19426,10149,10148,30921,30938,10268,13089,40918,11019,11361,11352,23167,10900,18356,35546,22598,18553,22853,12343,14459,14235,11356,27891,27792,22601,12713,11710,14774,22573,10995,11003,14793,19478,14237,14451,22989,14265,11034,18161,14446,33220,22602,14432,14449,12342,11032,22600,14417,14442,14470,14485,12330,12628,10944,10939,11713,11718,10725,10724,10731,10722,14419,14477,14429,14430,40378,36497,18193,15033,13134,40086,19582,40104,24253,39827,26593,32049,14555,13017,10143,12296,10301,13060,10751,38699,35585,11222,11215,11200,12971,37189,30649,11592,11544,11197,30178,10747,13004,10763,24884,25197,12281,15053,10973,11005,11697,10766,10749,40230,34266,13074,14896,15644,38711,11198,11137,12568,10240,11497,10245,11571,11533,12650,11530,11850,11523,12601,12582,10261,14152,19549,12419,10923,10247,24574,10248,36695,10256,40482,14521,10752,10692,11127,28788,40064,11473,34652,10109,10107,10258,10146,10122,10136,12552,11612,11163,34905,11028,35421,12549,35146,11149,10130,10129,11035,20462,11287,18638,32332,18239,34040,34000,21975,40540,25842,12007,12744,11820,15417,10131,10156,28761,14249,10981,28185,11617,12448,14445,14479,11001,14450,10102,10164,11892,11893,11470,11471,37421,40391,10930,10782,11468,11465,11464,30756,11467,12261,11903,11466,12730,11103,33422,19002,27884,11358,11359,14447,14336,12462,12074,10786,12244,11472,12094,36923,10788,11322,12344,38046,11355,35529,14253,10893,14437,14251,14271,11357,11351,14287,11360,10913,11722,14440,14438,38018,14254,14241,14242,33423,19003,27965,14471,14236,14418,18422,18163,10987,10993,18731,18425,14484,18729,18429,14640,14151,14641,18730,14456,14452,14453,14264,10999,10996,28046,14424,11004,35432,14468,14403,10992,17882,14443,10994,11000,14565,38765,38180,11709,37989,14259,14256,14454,17959,14405,14564,15051,18736,14537,18436,18734,18735,18551,18390,18732,14150,14638,14476,14455,14478,14420,27964,14473,14289) [ RunTime:0.002504s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_teams',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 1,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `cid` FROM `cmf_nami_competitions` WHERE `pinyin` = 'all' AND `com_type` = 0 LIMIT 1 [ RunTime:0.003858s ]
- [ 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' => 3513,
'filtered' => 1.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_matches` WHERE ( `match_time` > 1714074745 ) ORDER BY `match_time` ASC LIMIT 1000 [ RunTime:0.007228s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_matches',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'match_time',
'key' => 'match_time',
'key_len' => '5',
'ref' => NULL,
'rows' => 24044,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` IN (3387,1528,452,1917,3229,1742,3035,1729,396,398,1918,1699,538,477,41,3078,1,3396,4065,3811,483,3706,1683,710,488,2851,76,765,2115,3899,466,282,489,3380,3134,5118,11,5750,500,1926,36,3977,1886,1788,241,3988,4067,34,67,3203,255,2915,357,3083,3900,591,592,3978,254,4235,1923,590,1660,1806,349,1871,595,542,3987,4066,593,598,829,3983,1892,600,1663,31,2846,676,1666,1853,3,3364,3394,3982,1579,682,370,717,1719,368,679,1668,97,2815,548,348,277,1799,617,96,3264,1733,274,1667,3060,301,341,333,3373,534,470,1739,627,626,648,363,297,260,276,405,12,727,385,195,293,614,870,720,1905,337,13,344,3527,47,655,3314,197,296,32,275,69,1940,267,37,66,62,3959,642,361,198,992,294,112,330,245,199,1679,377,220,3478,42,144,130,2159,1831,315,132,221,191,187,209,210,229,131,186,145,270,2791,211,1907,332,219,247,1163,716,178,10,169,179,234,4021,57,308,701,1718,721,86,225,226,58,3008,129,109,113,246,121,228,175,159,108,142,83,120,182,1677,151,1782,471,476,407,473,436,2984,462,1738,469,459,458,478,3972,465,603,5711,486,1834,570,567,572,571,601,569,1878,26,597,581,568,582,584,3079,3295,602,5,4044,2782,545,546,544,3073,1746,543,3374,263,271,838,240,2918,259,133,356,3319,3986,249,248,134,362,364,214,1952,253,124,152,2742,3200,3357,3874,222,659,660,190,1842,2775,1740,3253,1867) [ RunTime:0.006589s ]
- [ 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' => 296,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` IN (3387,1528,452,1917,3229,1742,3035,1729,396,398,1918,1699,538,477,41,3078,1,3396,4065,3811,483,3706,1683,710,488,2851,76,765,2115,3899,466,282,489,3380,3134,5118,11,5750,500,1926,36,3977,1886,1788,241,3988,4067,34,67,3203,255,2915,357,3083,3900,591,592,3978,254,4235,1923,590,1660,1806,349,1871,595,542,3987,4066,593,598,829,3983,1892,600,1663,31,2846,676,1666,1853,3,3364,3394,3982,1579,682,370,717,1719,368,679,1668,97,2815,548,348,277,1799,617,96,3264,1733,274,1667,3060,301,341,333,3373,534,470,1739,627,626,648,363,297,260,276,405,12,727,385,195,293,614,870,720,1905,337,13,344,3527,47,655,3314,197,296,32,275,69,1940,267,37,66,62,3959,642,361,198,992,294,112,330,245,199,1679,377,220,3478,42,144,130,2159,1831,315,132,221,191,187,209,210,229,131,186,145,270,2791,211,1907,332,219,247,1163,716,178,10,169,179,234,4021,57,308,701,1718,721,86,225,226,58,3008,129,109,113,246,121,228,175,159,108,142,83,120,182,1677,151,1782,471,476,407,473,436,2984,462,1738,469,459,458,478,3972,465,603,5711,486,1834,570,567,572,571,601,569,1878,26,597,581,568,582,584,3079,3295,602,5,4044,2782,545,546,544,3073,1746,543,3374,263,271,838,240,2918,259,133,356,3319,3986,249,248,134,362,364,214,1952,253,124,152,2742,3200,3357,3874,222,659,660,190,1842,2775,1740,3253,1867) [ RunTime:0.004630s ]
- [ 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' => 296,
'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 (69752,65349,25902,29364,22255,21242,34229,34341,15975,40251,60259,69465,10547,36478,69688,69691,22493,12341,12391,10149,11572,17859,15674,23810,27430,11532,33251,29106,59979,44210,36036,60033,20235,13399,49897,49853,33688,24019,23320,32953,50493,70663,14998,10813,14639,15828,38802,16007,11304,10093,14116,12357,36503,25064,23319,23266,28470,13102,44793,44923,14010,25010,43872,52269,37632,10726,23481,22494,26206,33450,13470,10338,32639,10818,50591,69711,10553,30318,42064,42063,24095,21850,76821,26892,76815,74761,76818,60474,81382,81481,80880,80857,80866,80952,80870,80855,80856,80895,80858,80948,80881,80869,80894,80865,12643,42893,46442,11123,15616,55406,29786,32174,32115,15284,26800,36040,71476,58202,82513,25904,80936,40228,69554,58224,74191,74192,76816,22810,78601,61835,60102,60221,57786,28556,57788,41528,76453,52818,24807,74468,20106,58610,56838,31414,81697,20514,24134,20582,21910,24237,18138,19167,11927,24558,16347,74382,13968,15569,36346,59772,32719,36347,21318,36610,38081,72532,25978,37640,12625,37626,42957,30068,23822,29336,11740,32694,29340,26866,38263,23777,38273,37840,22014,42664,37624,25932,29339,16893,37975,24222,37719,40043,52560,22517,24804,22124,34514,26723,21856,31282,30273,53336,34313,59214,75426,20163,20162,76452,47574,47203,47796,69536,82485,26152,30337,28313,60282,24974,25653,23659,25285,32780,11990,31262,13233,27613,34721,19996,30338,14790,18134,36370,17388,37861,30092,33866,45373,10139,33738,74873,17491,34304,40692,56837,61661,37740,19638,20522,43055,57215,32948,30780,69638,81775,22967,25280,58505,13059,17618,21399,19700,77646,11602,48183,13157,10766,10700,23094,10767,10009,50542,10218,36751,23194,19404,58206,19191,61773,20213,17569,19938,21342,48130,10138,39495,73147,38215,77647,69636,81773,69491,62583,17253,17407,53867,16948,41977,52456,15064,44952,53433,48481,40234,42841,29779,25751,27399,19157,28220,42087,42091,17055,15356,16789,34050,34846,59247,75212,31232,16505,50491,45046,44797,59835,32544,33491,11678,13262,34515,27924,18885,12148,12527,21539,12624,13161,22698,18884,11039,12627,23778,59379,19566,13473,17419,15140,16512,12464,16510,13631,16513,16515,22623,16511,69534,69537,81500,81628,37992,12859,20772,11828,32998,31201,58617,59375,17002,62187,24577,12269,48197,18010,20212,58204,52161,26798,74845,20479,30239,45771,22349,42856,11362,28259,81269,71750,26247,23331,18054,18057,31502,25128,27265,62433,16738,18700,52702,72904,25200,68190,72319,32784,38502,58534,20518,19639,20242,20384,14918,21309,19105,72298,16663,60612,55751,43301,69488,79909,21135,25837,28782,12761,26708,26665,47664,73135,29820,20372,14424,11236,25458,38899,16732,72668,15760,14046,30243,26084,28159,29207,14411,14220,26751,27397,62201,71660,18238,52877,10746,12047,27611,27598,35021,22041,14633,13251,18065,14077,13150,19182,22380,24550,17057,22935,20671,14722,55697,31820,39053,15446,73275,73527,17035,17813,61642,79129,12353,17519,76231,75419,76265,75422,50906,57642,17052,45241,68191,78303,16688,14425,17246,14786,28598,16121,13387,36758,65571,11321,26103,14779,12977,14895,10363,15439,27468,24340,29754,18410,72387,21035,24705,51245,21410,56830,40518,26445,23452,23067,69787,51286,23500,17483,11887,59179,13544,19642,23961,21759,11839,10281,16700,17259,34123,35704,15525,30788,41947,32893,12645,10398,23944,25693,10803,11262,19273,79885,79884,80032,74014,74059,10435,21476,10047,10331,10912,10332,17559,74024,18981,28163,21312,16713,24627,17684,74843,18310,19620,10643,10312,44256,26353,20991,13302,47595,32343,15707,17131,40754,23851,15761,16723,31481,36469,21112,60540,74844,11743,15321,11046,10383,11313,11214,29381,12209,30133,35411,10483,10722,26687,17072,10017,10449,12275,47318,11672,12547,14994,12669,15164,11401,31855,30960,14914,11891,19234,33574,10412,10984,13122,39622,36482,16816,14726,23913,28663,31901,36049,32757,10402,23993,23110,39765,10396,11779,12870,17542,10073,11042,10676,11312,13076,25431,31783,29313,36510,36951,47582,15319,12442,36766,18413,26681,26243,48546,11925,22723,35492,22157,10434,16664,28799,10308,10384,25636,10644,11243,14051,25580,18757,23334,16304,12839,32629,58126,24876,20658,19199,26713,17621,13666,36531,10431,10213,10397,12978,11951,17330,17328,11068,11815,22176,38919,16748,23501,17144,17743,16973,14996,71646,71758,59183,42181,36493,15046,56495,46213,53356,57762,48048,33443,66954,33820,10938,17827,35779,11244,57546,44950,26190,32651,23385,23559,10107,10427,10077,10433,10442,10329,10084,22288,11265,10091,10977,10454,13257,26567,32279,31199,32954,32229,30384,23159,30425,21731,31200,31315,31313,31225,57798,49037,27835,29052,25850,47760,12744,11510,32492,31227,14971,21820,37537,57763,29408,31581,33758,29923,14818,14757,14525,18411,18207,30158,15637,31564,74616,23520,31541,28646,70232,28904,32532,22510,82433,21188,32573,69194,34933,40698,14685,44539,30001,49598,70091,28709,39398,28787,62300,22508,13329,28644,61984,25806,70102,82435,55159,53069,25926,34456,82434,74621,25707,44534,25929,69196,28027,24849,25893,31543,25872,22462,80088,44543,28936,22458,31565,12815,29007,24894,23513,21181,12816,43551,15633,25927,15634,31542,25777,82432,82437,29002,31396,36606,65348,74923,30883,16942,12949,73352,12680,11315,15729,14049,29924,48682,14660,26572,10028,10322,31625,31626,16822,11076,12619,13403,43203,31597,10285,10243,10517,10516,29434,10221,76981,76982,22689,11909,33105,29887,29655,12647,20576,32658,35193,34069,10161,10162,10484,10067,10111,10462,10095,10459,11924,11188,11406,73932,60356,11189,15216,10300,24749,24890,22397,10955,29012,17197,29013,28949,12831,11000,12524,10216,10729,12434,10914,11205,10333,10163,10290,10175,10222,10217,37984,37971,11838,21981,16166,40751,24967,35405,32282,37058,20234,16438,65350,65347,34101,30802,22342,12183,27301,14778,12054,12055,14806,12145,11303,12053,24093,14570,17673,14688,12146,38079,12051,26475,16415,26219,10815,17187,16551,22635,15235,51493,74603,11263,11977,17406,14508,29926,17127,19842,19758,29427,34422,27791,16891,81339,21431,12063,10816,13469,33259,14117,20233,11404,11241,74541,14887,29672,25511,37018,24251,69573,60531,80859,80861,21521,21520,35073,22056,12600,21836,80862,80871,80854,80860,11386,13194,50071,39500,26451,68782,16122,11681,30510,13543,32417,20674,40568,68779,18778,59235,26447,19775,68781,59282,68756,54558,26409,14310,69829,14959,18779,21919,26407,34244,25461,81471,34245,74386,26381,31537,15921,37232,29311,33628,11930,34426,74095,40781,25654,21447,33693,50836,29908,29069,28503,21445,34626,30446,30447,20387,10438,10305,10069,25413,10066,10061,10070,20273,10593,10060,12529,28038,15733,24121,14311,29963,30710,27116,32452,55750,18777,19760,69452,20002,20061,23641,60216,20003,20004,20057,74245,19172,18780,60706,20565,60831,45461,57702,26302,29360,19177,76355,37495,45266,30445,28779,30334,26776,29757,30169,14475,10909,51063,34447,10457,10336,40083,30332,26502,22083,80864,80874,26364,22190,30093,29902,80863,80868,26416,45901,33625,45496,23023,59898,45359,40430,32994,42255,27612,18136,20231,10986,20230,15315,25070,15020,18279,71266,50536,40074,56559,56560,24969,76516,35072,31898,16714,16230,14753,59450,27419,22861,10652,23021,10415,21947,23642,28678,10271,39916,14346,10194,13028,48371,40926,19190,14845,13943,30507,30104,26518,41056,30478,30476,31780,26431,30655,26425,23932,26994,18461,53240,48171,27238,32043,17984,16875,25204,52700,61939,28007,33419,26634,77349,31805,61688,56543,56557,74806,82052,34258,73346,40102,48184,39579,15452,26591,29147,30202,35987,27369,10356,25702,18408,15331,52860,19742,49039,45893,76501,37171,19889,30477,29611,15332,57577,21333,17449,20985,14572,18402,52859,24231,31061,52543,29156,12477,62063,24307,12475,25085,40399,28420,15558,26308,29054,23359,26176,60370,16394,80867,80840,31763,39830,14841,26517,47691,27295,27317,25554,58314,27888,26691,32586,30570,26756,26755,24624,32657,42062,27293,29877,25233,19552,27294,25188,29997,27980,28384,25555,25232,25273,32688,31335,25272,17778,27706,21798,24708,31656,31680,26753,24626,26754,29271,76423,76424,27968,12905,32156,30819,40556,24135,30022,26048,18137,28673,22266,10736,69862,45470,28746,25906,40103,25938,23931,27312,21684,78337,74022,21368,45816,27541,29818,13590,19789,18845,57582,26757,16960,32722,18125,69939,40691,19458,25761,22993,29540,24274,14152,20655,11748,26775,30336,18533,43572,20291,28902,74259,17154,59738,30419,20509,39915,30410,40126,77501,71647,27602,58017,14546,21683,51937,13490,48009,30799,81896,13505,21735,27868,13967,24460,36178,36366,17754,38627,29732,51411,14440,31229,30654,29876,61936,71963,23187,46047,27280,70182,41460,11015,47124,11368,29817,31089,20572,20573,20571,21765,21764,19256,30779,54721,54741,24964,30989,22515,37683,29496,16300,16450,56544,56556,14538,39718,33418,58660,56879,27333,11043,16930,58638,37414,49398,38345,17015,34818,48217,58455,32847,49969,24601,11120,17080,52045,76321,16998,15108,16150,30610,25666,10777,23377,21736,30487,16387,19780,62345,58356,62393,20529,61498,37641,29029,58333,17923,17922,21734,21737,21733,28892,10905,20632,16060,26429,34394,58554,28616,29020,25384,31370,39923,28695,36709,28615,30101,29985,31750,50110,49803,51805,27226,29061,11024,18927,40763,21115,21453,26993,20719,58180,27310,28603,23259,40507,10324,10051,11274,10589,10913,10853,22600,21138,13566,19200,14906,45676,12548,32738,13296,12661,81073,45828,56567,81807,19654,10896,29936,28345,57475,18078,19322,23664,11367,24187,10124,26350,12349,33296,36151,27686,40530,11470,29103,29063,40377,53876,16741,18350,16682,19389,11812,11814,12435,10395,18107,16846,16979,71665,36456,13959,18268,16829,13549,14819,25600,18214,60999,80041,82425,82426,37741,16701,16919,73371,11744,62156,11773,16827,12872,16935,17067,16988,16621,78581,49081,72774,34540,39706,27195,36387) [ RunTime:0.011413s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_teams',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 1,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (33739,34054,30384,27584,19402,35950,39648,39646,10120,10127,39475,15421,30870,30941,10116,10115,37654,39449,36267,36360,30004,29872,36015,41057,14139,39663,36245,38096,10984,33923,12049,30271,27509,41002,21901,40839,33479,39474,22045,19426,10149,10148,30921,30938,10268,13089,40918,11019,11361,11352,23167,10900,18356,35546,22598,18553,22853,12343,14459,14235,11356,27891,27792,22601,12713,11710,14774,22573,10995,11003,14793,19478,14237,14451,22989,14265,11034,18161,14446,33220,22602,14432,14449,12342,11032,22600,14417,14442,14470,14485,12330,12628,10944,10939,11713,11718,10725,10724,10731,10722,14419,14477,14429,14430,40378,36497,18193,15033,13134,40086,19582,40104,24253,39827,26593,32049,14555,13017,10143,12296,10301,13060,10751,38699,35585,11222,11215,11200,12971,37189,30649,11592,11544,11197,30178,10747,13004,10763,24884,25197,12281,15053,10973,11005,11697,10766,10749,40230,34266,13074,14896,15644,38711,11198,11137,12568,10240,11497,10245,11571,11533,12650,11530,11850,11523,12601,12582,10261,14152,19549,12419,10923,10247,24574,10248,36695,10256,40482,14521,10752,10692,11127,28788,40064,11473,34652,10109,10107,10258,10146,10122,10136,12552,11612,11163,34905,11028,35421,12549,35146,11149,10130,10129,11035,20462,11287,18638,32332,18239,34040,34000,21975,40540,25842,12007,12744,11820,15417,10131,10156,28761,14249,10981,28185,11617,12448,14445,14479,11001,14450,10102,10164,11892,11893,11470,11471,37421,40391,10930,10782,11468,11465,11464,30756,11467,12261,11903,11466,12730,11103,33422,19002,27884,11358,11359,14447,14336,12462,12074,10786,12244,11472,12094,36923,10788,11322,12344,38046,11355,35529,14253,10893,14437,14251,14271,11357,11351,14287,11360,10913,11722,14440,14438,38018,14254,14241,14242,33423,19003,27965,14471,14236,14418,18422,18163,10987,10993,18731,18425,14484,18729,18429,14640,14151,14641,18730,14456,14452,14453,14264,10999,10996,28046,14424,11004,35432,14468,14403,10992,17882,14443,10994,11000,14565,38765,38180,11709,37989,14259,14256,14454,17959,14405,14564,15051,18736,14537,18436,18734,18735,18551,18390,18732,14150,14638,14476,14455,14478,14420,27964,14473,14289) [ RunTime:0.002548s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_teams',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 1,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (69752,65349,25902,29364,22255,21242,34229,34341,15975,40251,60259,69465,10547,36478,69688,69691,22493,12341,12391,10149,11572,17859,15674,23810,27430,11532,33251,29106,59979,44210,36036,60033,20235,13399,49897,49853,33688,24019,23320,32953,50493,70663,14998,10813,14639,15828,38802,16007,11304,10093,14116,12357,36503,25064,23319,23266,28470,13102,44793,44923,14010,25010,43872,52269,37632,10726,23481,22494,26206,33450,13470,10338,32639,10818,50591,69711,10553,30318,42064,42063,24095,21850,76821,26892,76815,74761,76818,60474,81382,81481,80880,80857,80866,80952,80870,80855,80856,80895,80858,80948,80881,80869,80894,80865,12643,42893,46442,11123,15616,55406,29786,32174,32115,15284,26800,36040,71476,58202,82513,25904,80936,40228,69554,58224,74191,74192,76816,22810,78601,61835,60102,60221,57786,28556,57788,41528,76453,52818,24807,74468,20106,58610,56838,31414,81697,20514,24134,20582,21910,24237,18138,19167,11927,24558,16347,74382,13968,15569,36346,59772,32719,36347,21318,36610,38081,72532,25978,37640,12625,37626,42957,30068,23822,29336,11740,32694,29340,26866,38263,23777,38273,37840,22014,42664,37624,25932,29339,16893,37975,24222,37719,40043,52560,22517,24804,22124,34514,26723,21856,31282,30273,53336,34313,59214,75426,20163,20162,76452,47574,47203,47796,69536,82485,26152,30337,28313,60282,24974,25653,23659,25285,32780,11990,31262,13233,27613,34721,19996,30338,14790,18134,36370,17388,37861,30092,33866,45373,10139,33738,74873,17491,34304,40692,56837,61661,37740,19638,20522,43055,57215,32948,30780,69638,81775,22967,25280,58505,13059,17618,21399,19700,77646,11602,48183,13157,10766,10700,23094,10767,10009,50542,10218,36751,23194,19404,58206,19191,61773,20213,17569,19938,21342,48130,10138,39495,73147,38215,77647,69636,81773,69491,62583,17253,17407,53867,16948,41977,52456,15064,44952,53433,48481,40234,42841,29779,25751,27399,19157,28220,42087,42091,17055,15356,16789,34050,34846,59247,75212,31232,16505,50491,45046,44797,59835,32544,33491,11678,13262,34515,27924,18885,12148,12527,21539,12624,13161,22698,18884,11039,12627,23778,59379,19566,13473,17419,15140,16512,12464,16510,13631,16513,16515,22623,16511,69534,69537,81500,81628,37992,12859,20772,11828,32998,31201,58617,59375,17002,62187,24577,12269,48197,18010,20212,58204,52161,26798,74845,20479,30239,45771,22349,42856,11362,28259,81269,71750,26247,23331,18054,18057,31502,25128,27265,62433,16738,18700,52702,72904,25200,68190,72319,32784,38502,58534,20518,19639,20242,20384,14918,21309,19105,72298,16663,60612,55751,43301,69488,79909,21135,25837,28782,12761,26708,26665,47664,73135,29820,20372,14424,11236,25458,38899,16732,72668,15760,14046,30243,26084,28159,29207,14411,14220,26751,27397,62201,71660,18238,52877,10746,12047,27611,27598,35021,22041,14633,13251,18065,14077,13150,19182,22380,24550,17057,22935,20671,14722,55697,31820,39053,15446,73275,73527,17035,17813,61642,79129,12353,17519,76231,75419,76265,75422,50906,57642,17052,45241,68191,78303,16688,14425,17246,14786,28598,16121,13387,36758,65571,11321,26103,14779,12977,14895,10363,15439,27468,24340,29754,18410,72387,21035,24705,51245,21410,56830,40518,26445,23452,23067,69787,51286,23500,17483,11887,59179,13544,19642,23961,21759,11839,10281,16700,17259,34123,35704,15525,30788,41947,32893,12645,10398,23944,25693,10803,11262,19273,79885,79884,80032,74014,74059,10435,21476,10047,10331,10912,10332,17559,74024,18981,28163,21312,16713,24627,17684,74843,18310,19620,10643,10312,44256,26353,20991,13302,47595,32343,15707,17131,40754,23851,15761,16723,31481,36469,21112,60540,74844,11743,15321,11046,10383,11313,11214,29381,12209,30133,35411,10483,10722,26687,17072,10017,10449,12275,47318,11672,12547,14994,12669,15164,11401,31855,30960,14914,11891,19234,33574,10412,10984,13122,39622,36482,16816,14726,23913,28663,31901,36049,32757,10402,23993,23110,39765,10396,11779,12870,17542,10073,11042,10676,11312,13076,25431,31783,29313,36510,36951,47582,15319,12442,36766,18413,26681,26243,48546,11925,22723,35492,22157,10434,16664,28799,10308,10384,25636,10644,11243,14051,25580,18757,23334,16304,12839,32629,58126,24876,20658,19199,26713,17621,13666,36531,10431,10213,10397,12978,11951,17330,17328,11068,11815,22176,38919,16748,23501,17144,17743,16973,14996,71646,71758,59183,42181,36493,15046,56495,46213,53356,57762,48048,33443,66954,33820,10938,17827,35779,11244,57546,44950,26190,32651,23385,23559,10107,10427,10077,10433,10442,10329,10084,22288,11265,10091,10977,10454,13257,26567,32279,31199,32954,32229,30384,23159,30425,21731,31200,31315,31313,31225,57798,49037,27835,29052,25850,47760,12744,11510,32492,31227,14971,21820,37537,57763,29408,31581,33758,29923,14818,14757,14525,18411,18207,30158,15637,31564,74616,23520,31541,28646,70232,28904,32532,22510,82433,21188,32573,69194,34933,40698,14685,44539,30001,49598,70091,28709,39398,28787,62300,22508,13329,28644,61984,25806,70102,82435,55159,53069,25926,34456,82434,74621,25707,44534,25929,69196,28027,24849,25893,31543,25872,22462,80088,44543,28936,22458,31565,12815,29007,24894,23513,21181,12816,43551,15633,25927,15634,31542,25777,82432,82437,29002,31396,36606,65348,74923,30883,16942,12949,73352,12680,11315,15729,14049,29924,48682,14660,26572,10028,10322,31625,31626,16822,11076,12619,13403,43203,31597,10285,10243,10517,10516,29434,10221,76981,76982,22689,11909,33105,29887,29655,12647,20576,32658,35193,34069,10161,10162,10484,10067,10111,10462,10095,10459,11924,11188,11406,73932,60356,11189,15216,10300,24749,24890,22397,10955,29012,17197,29013,28949,12831,11000,12524,10216,10729,12434,10914,11205,10333,10163,10290,10175,10222,10217,37984,37971,11838,21981,16166,40751,24967,35405,32282,37058,20234,16438,65350,65347,34101,30802,22342,12183,27301,14778,12054,12055,14806,12145,11303,12053,24093,14570,17673,14688,12146,38079,12051,26475,16415,26219,10815,17187,16551,22635,15235,51493,74603,11263,11977,17406,14508,29926,17127,19842,19758,29427,34422,27791,16891,81339,21431,12063,10816,13469,33259,14117,20233,11404,11241,74541,14887,29672,25511,37018,24251,69573,60531,80859,80861,21521,21520,35073,22056,12600,21836,80862,80871,80854,80860,11386,13194,50071,39500,26451,68782,16122,11681,30510,13543,32417,20674,40568,68779,18778,59235,26447,19775,68781,59282,68756,54558,26409,14310,69829,14959,18779,21919,26407,34244,25461,81471,34245,74386,26381,31537,15921,37232,29311,33628,11930,34426,74095,40781,25654,21447,33693,50836,29908,29069,28503,21445,34626,30446,30447,20387,10438,10305,10069,25413,10066,10061,10070,20273,10593,10060,12529,28038,15733,24121,14311,29963,30710,27116,32452,55750,18777,19760,69452,20002,20061,23641,60216,20003,20004,20057,74245,19172,18780,60706,20565,60831,45461,57702,26302,29360,19177,76355,37495,45266,30445,28779,30334,26776,29757,30169,14475,10909,51063,34447,10457,10336,40083,30332,26502,22083,80864,80874,26364,22190,30093,29902,80863,80868,26416,45901,33625,45496,23023,59898,45359,40430,32994,42255,27612,18136,20231,10986,20230,15315,25070,15020,18279,71266,50536,40074,56559,56560,24969,76516,35072,31898,16714,16230,14753,59450,27419,22861,10652,23021,10415,21947,23642,28678,10271,39916,14346,10194,13028,48371,40926,19190,14845,13943,30507,30104,26518,41056,30478,30476,31780,26431,30655,26425,23932,26994,18461,53240,48171,27238,32043,17984,16875,25204,52700,61939,28007,33419,26634,77349,31805,61688,56543,56557,74806,82052,34258,73346,40102,48184,39579,15452,26591,29147,30202,35987,27369,10356,25702,18408,15331,52860,19742,49039,45893,76501,37171,19889,30477,29611,15332,57577,21333,17449,20985,14572,18402,52859,24231,31061,52543,29156,12477,62063,24307,12475,25085,40399,28420,15558,26308,29054,23359,26176,60370,16394,80867,80840,31763,39830,14841,26517,47691,27295,27317,25554,58314,27888,26691,32586,30570,26756,26755,24624,32657,42062,27293,29877,25233,19552,27294,25188,29997,27980,28384,25555,25232,25273,32688,31335,25272,17778,27706,21798,24708,31656,31680,26753,24626,26754,29271,76423,76424,27968,12905,32156,30819,40556,24135,30022,26048,18137,28673,22266,10736,69862,45470,28746,25906,40103,25938,23931,27312,21684,78337,74022,21368,45816,27541,29818,13590,19789,18845,57582,26757,16960,32722,18125,69939,40691,19458,25761,22993,29540,24274,14152,20655,11748,26775,30336,18533,43572,20291,28902,74259,17154,59738,30419,20509,39915,30410,40126,77501,71647,27602,58017,14546,21683,51937,13490,48009,30799,81896,13505,21735,27868,13967,24460,36178,36366,17754,38627,29732,51411,14440,31229,30654,29876,61936,71963,23187,46047,27280,70182,41460,11015,47124,11368,29817,31089,20572,20573,20571,21765,21764,19256,30779,54721,54741,24964,30989,22515,37683,29496,16300,16450,56544,56556,14538,39718,33418,58660,56879,27333,11043,16930,58638,37414,49398,38345,17015,34818,48217,58455,32847,49969,24601,11120,17080,52045,76321,16998,15108,16150,30610,25666,10777,23377,21736,30487,16387,19780,62345,58356,62393,20529,61498,37641,29029,58333,17923,17922,21734,21737,21733,28892,10905,20632,16060,26429,34394,58554,28616,29020,25384,31370,39923,28695,36709,28615,30101,29985,31750,50110,49803,51805,27226,29061,11024,18927,40763,21115,21453,26993,20719,58180,27310,28603,23259,40507,10324,10051,11274,10589,10913,10853,22600,21138,13566,19200,14906,45676,12548,32738,13296,12661,81073,45828,56567,81807,19654,10896,29936,28345,57475,18078,19322,23664,11367,24187,10124,26350,12349,33296,36151,27686,40530,11470,29103,29063,40377,53876,16741,18350,16682,19389,11812,11814,12435,10395,18107,16846,16979,71665,36456,13959,18268,16829,13549,14819,25600,18214,60999,80041,82425,82426,37741,16701,16919,73371,11744,62156,11773,16827,12872,16935,17067,16988,16621,78581,49081,72774,34540,39706,27195,36387) [ RunTime:0.012151s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_teams',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 1,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (33739,34054,30384,27584,19402,35950,39648,39646,10120,10127,39475,15421,30870,30941,10116,10115,37654,39449,36267,36360,30004,29872,36015,41057,14139,39663,36245,38096,10984,33923,12049,30271,27509,41002,21901,40839,33479,39474,22045,19426,10149,10148,30921,30938,10268,13089,40918,11019,11361,11352,23167,10900,18356,35546,22598,18553,22853,12343,14459,14235,11356,27891,27792,22601,12713,11710,14774,22573,10995,11003,14793,19478,14237,14451,22989,14265,11034,18161,14446,33220,22602,14432,14449,12342,11032,22600,14417,14442,14470,14485,12330,12628,10944,10939,11713,11718,10725,10724,10731,10722,14419,14477,14429,14430,40378,36497,18193,15033,13134,40086,19582,40104,24253,39827,26593,32049,14555,13017,10143,12296,10301,13060,10751,38699,35585,11222,11215,11200,12971,37189,30649,11592,11544,11197,30178,10747,13004,10763,24884,25197,12281,15053,10973,11005,11697,10766,10749,40230,34266,13074,14896,15644,38711,11198,11137,12568,10240,11497,10245,11571,11533,12650,11530,11850,11523,12601,12582,10261,14152,19549,12419,10923,10247,24574,10248,36695,10256,40482,14521,10752,10692,11127,28788,40064,11473,34652,10109,10107,10258,10146,10122,10136,12552,11612,11163,34905,11028,35421,12549,35146,11149,10130,10129,11035,20462,11287,18638,32332,18239,34040,34000,21975,40540,25842,12007,12744,11820,15417,10131,10156,28761,14249,10981,28185,11617,12448,14445,14479,11001,14450,10102,10164,11892,11893,11470,11471,37421,40391,10930,10782,11468,11465,11464,30756,11467,12261,11903,11466,12730,11103,33422,19002,27884,11358,11359,14447,14336,12462,12074,10786,12244,11472,12094,36923,10788,11322,12344,38046,11355,35529,14253,10893,14437,14251,14271,11357,11351,14287,11360,10913,11722,14440,14438,38018,14254,14241,14242,33423,19003,27965,14471,14236,14418,18422,18163,10987,10993,18731,18425,14484,18729,18429,14640,14151,14641,18730,14456,14452,14453,14264,10999,10996,28046,14424,11004,35432,14468,14403,10992,17882,14443,10994,11000,14565,38765,38180,11709,37989,14259,14256,14454,17959,14405,14564,15051,18736,14537,18436,18734,18735,18551,18390,18732,14150,14638,14476,14455,14478,14420,27964,14473,14289) [ RunTime:0.002735s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_teams',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 1,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%t4808.cn%' LIMIT 1 [ RunTime:0.001611s ]
- [ 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' => 77,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 370 [ RunTime:0.001686s ]
- [ 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' => 468,
'filtered' => 9.999999046325684,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.002620s ]
- [ SQL ] SELECT * FROM `cmf_portal_post` `post` WHERE `site_id` = 57 AND `post_status` = 1 AND `post_type` = 1 AND `delete_time` = 0 AND ( `category_id` IN (370,371,372) ) AND ( `published_time` > 0 and `published_time` < 1714089145 ) ORDER BY `post_hits` DESC LIMIT 0,1 [ RunTime:0.001973s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'post',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'type_status_date,category_id',
'key' => 'category_id',
'key_len' => '14',
'ref' => NULL,
'rows' => 3,
'filtered' => 1.6666667461395264,
'extra' => 'Using index condition; Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.005648s ]
- [ 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' => 468,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_user` [ RunTime:0.001791s ]
- [ SQL ] SELECT `id`,`user_nickname` FROM `cmf_user` [ RunTime:0.001538s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_user',
'partitions' => NULL,
'type' => 'index',
'possible_keys' => NULL,
'key' => 'user_nickname',
'key_len' => '202',
'ref' => NULL,
'rows' => 2,
'filtered' => 100.0,
'extra' => 'Using index',
) ]
- [ SQL ] SELECT `id`,`avatar` FROM `cmf_user` [ RunTime:0.001478s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_user',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 2,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%t4808.cn%' LIMIT 1 [ RunTime:0.001586s ]
- [ 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' => 77,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 370 [ RunTime:0.001611s ]
- [ 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' => 468,
'filtered' => 9.999999046325684,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_portal_post` `post` WHERE `site_id` = 57 AND `post_status` = 1 AND `post_type` = 1 AND `delete_time` = 0 AND ( `category_id` IN (370,371,372) ) AND ( `published_time` > 0 and `published_time` < 1714089145 ) ORDER BY `post_hits` DESC LIMIT 1,2 [ RunTime:0.001751s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'post',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'type_status_date,category_id',
'key' => 'category_id',
'key_len' => '14',
'ref' => NULL,
'rows' => 3,
'filtered' => 1.6666667461395264,
'extra' => 'Using index condition; Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.001749s ]
- [ 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' => 468,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`user_nickname` FROM `cmf_user` [ RunTime:0.001533s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_user',
'partitions' => NULL,
'type' => 'index',
'possible_keys' => NULL,
'key' => 'user_nickname',
'key_len' => '202',
'ref' => NULL,
'rows' => 2,
'filtered' => 100.0,
'extra' => 'Using index',
) ]
- [ SQL ] SELECT `id`,`avatar` FROM `cmf_user` [ RunTime:0.001471s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_user',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 2,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%t4808.cn%' LIMIT 1 [ RunTime:0.001531s ]
- [ 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' => 77,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 370 [ RunTime:0.001585s ]
- [ 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' => 468,
'filtered' => 9.999999046325684,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_portal_post` `post` WHERE `site_id` = 57 AND `post_status` = 1 AND `post_type` = 1 AND `delete_time` = 0 AND ( `category_id` IN (370,371,372) ) AND ( `published_time` > 0 and `published_time` < 1714089145 ) ORDER BY `post_hits` DESC LIMIT 3,3 [ RunTime:0.001707s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'post',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'type_status_date,category_id',
'key' => 'category_id',
'key_len' => '14',
'ref' => NULL,
'rows' => 3,
'filtered' => 1.6666667461395264,
'extra' => 'Using index condition; Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.001668s ]
- [ 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' => 468,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`user_nickname` FROM `cmf_user` [ RunTime:0.001644s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_user',
'partitions' => NULL,
'type' => 'index',
'possible_keys' => NULL,
'key' => 'user_nickname',
'key_len' => '202',
'ref' => NULL,
'rows' => 2,
'filtered' => 100.0,
'extra' => 'Using index',
) ]
- [ SQL ] SELECT `id`,`avatar` FROM `cmf_user` [ RunTime:0.001424s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_user',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 2,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%t4808.cn%' LIMIT 1 [ RunTime:0.001489s ]
- [ 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' => 77,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 370 [ RunTime:0.001558s ]
- [ 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' => 468,
'filtered' => 9.999999046325684,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_portal_post` `post` WHERE `site_id` = 57 AND `post_status` = 1 AND `post_type` = 1 AND `delete_time` = 0 AND ( `category_id` IN (370,371,372) ) AND ( `published_time` > 0 and `published_time` < 1714089145 ) ORDER BY `published_time` DESC LIMIT 0,6 [ RunTime:0.001708s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'post',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'type_status_date,category_id',
'key' => 'category_id',
'key_len' => '14',
'ref' => NULL,
'rows' => 3,
'filtered' => 1.6666667461395264,
'extra' => 'Using index condition; Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.001656s ]
- [ 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' => 468,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`user_nickname` FROM `cmf_user` [ RunTime:0.001478s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_user',
'partitions' => NULL,
'type' => 'index',
'possible_keys' => NULL,
'key' => 'user_nickname',
'key_len' => '202',
'ref' => NULL,
'rows' => 2,
'filtered' => 100.0,
'extra' => 'Using index',
) ]
- [ SQL ] SELECT `id`,`avatar` FROM `cmf_user` [ RunTime:0.001553s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_user',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 2,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%t4808.cn%' LIMIT 1 [ RunTime:0.001524s ]
- [ 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' => 77,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 367 [ RunTime:0.001581s ]
- [ 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' => 468,
'filtered' => 9.999999046325684,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_portal_post` `post` WHERE `site_id` = 57 AND `post_status` = 1 AND `post_type` = 1 AND `delete_time` = 0 AND ( `category_id` IN (367,368,369) ) AND ( `published_time` > 0 and `published_time` < 1714089145 ) ORDER BY `published_time` DESC LIMIT 0,6 [ RunTime:0.001804s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'post',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'type_status_date,category_id',
'key' => 'category_id',
'key_len' => '14',
'ref' => NULL,
'rows' => 23,
'filtered' => 1.110888957977295,
'extra' => 'Using index condition; Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.001702s ]
- [ 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' => 468,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`user_nickname` FROM `cmf_user` [ RunTime:0.001637s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_user',
'partitions' => NULL,
'type' => 'index',
'possible_keys' => NULL,
'key' => 'user_nickname',
'key_len' => '202',
'ref' => NULL,
'rows' => 2,
'filtered' => 100.0,
'extra' => 'Using index',
) ]
- [ SQL ] SELECT `id`,`avatar` FROM `cmf_user` [ RunTime:0.001616s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_user',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 2,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_portal_tag_post` [ RunTime:0.001844s ]
- [ SQL ] SELECT `tag_id` FROM `cmf_portal_tag_post` WHERE `post_id` = 146241 [ RunTime:0.001619s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'post_id',
'key' => 'post_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_portal_tag` [ RunTime:0.001805s ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` = 14214 [ RunTime:0.008555s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 368 LIMIT 1 [ RunTime:0.001488s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `tag_id` FROM `cmf_portal_tag_post` WHERE `post_id` = 146177 [ RunTime:0.001559s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'post_id',
'key' => 'post_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 5,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (14213,11308,12131,11941,12707) [ RunTime:0.001514s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => NULL,
'rows' => 5,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 369 LIMIT 1 [ RunTime:0.001568s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `tag_id` FROM `cmf_portal_tag_post` WHERE `post_id` = 110019 [ RunTime:0.001626s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'post_id',
'key' => 'post_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 39,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (14077,2330,2325,48,2805,3237,2039,3107,13385,46,3104,195,3002,1749,3233,1624,2062,1739,4388,3958,8267,3198,2474,7308,4893,10509,3750,8977,3251,6607,7779,2341,13367,7769,8295,7774,7764,2840,13118) [ RunTime:0.001797s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => NULL,
'rows' => 39,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 368 LIMIT 1 [ RunTime:0.001581s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `tag_id` FROM `cmf_portal_tag_post` WHERE `post_id` = 109798 [ RunTime:0.001559s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'post_id',
'key' => 'post_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` = 14074 [ RunTime:0.001494s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 368 LIMIT 1 [ RunTime:0.001464s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `tag_id` FROM `cmf_portal_tag_post` WHERE `post_id` = 94573 [ RunTime:0.001767s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'post_id',
'key' => 'post_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 17,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (13826,3107,2330,2325,3104,6607,3237,48,3002,3233,2341,2805,7779,3251,7769,7774,7764) [ RunTime:0.001629s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => NULL,
'rows' => 17,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 368 LIMIT 1 [ RunTime:0.001509s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `tag_id` FROM `cmf_portal_tag_post` WHERE `post_id` = 94572 [ RunTime:0.001590s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'post_id',
'key' => 'post_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 27,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (13825,2996,2811,120,13223,9119,2856,4417,4843,3005,6723,4278,2814,5626,11167,10770,2632,9103,5692,11088,5418,9057,12022,8691,9167,9080) [ RunTime:0.001613s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => NULL,
'rows' => 26,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 368 LIMIT 1 [ RunTime:0.001576s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'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 '%t4808.cn%' LIMIT 1 [ RunTime:0.001556s ]
- [ 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' => 77,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.001501s ]
- [ 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` = 57 AND `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.001764s ]
- [ 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' => 582,
'filtered' => 0.17182131111621857,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%t4808.cn%' LIMIT 1 [ RunTime:0.001583s ]
- [ 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' => 77,
'filtered' => 11.109999656677246,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_link` [ RunTime:0.001720s ]
- [ SQL ] SELECT * FROM `cmf_link` WHERE `status` = 1 AND `site_id` = 57 ORDER BY `list_order` ASC [ RunTime:0.001659s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_link',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => 'status',
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 5,
'filtered' => 20.0,
'extra' => 'Using where; Using filesort',
) ]