基本
文件
流程
错误
SQL
调试
- 请求信息 : 2024-11-05 05:23:03 HTTP/1.1 GET : https://m.peatchina.com/football/zhilinvjia
- 运行时间 : 2.266984s [ 吞吐率：0.44req/s ] 内存消耗：2,616.42kb 文件加载：139
- 查询信息 : 142 queries 6 writes
- 缓存信息 : 6 reads,3 writes
- [ LANG ] /mnt/7kzhanqun/vendor/thinkphp/lang/zh-cn.php
- [ DB ] INIT mysql
- [ LANG ] /mnt/7kzhanqun/vendor/thinkcmf/cmf/src/behavior/../lang/zh-cn.php
- [ LANG ] /mnt/7kzhanqun/vendor/thinkcmf/cmf-app/src/admin/lang/zh-cn.php
- [ LANG ] /mnt/7kzhanqun/vendor/thinkcmf/cmf-app/src/admin/lang/zh-cn/common.php
- [ LANG ] /mnt/7kzhanqun/vendor/thinkcmf/cmf-app/src/user/lang/zh-cn.php
- [ LANG ] /mnt/7kzhanqun/app/portal/lang/zh-cn/common.php
- [ LANG ] /mnt/7kzhanqun/app/portal//lang/zh-cn.php
- [ ROUTE ] array (
'rule' => 'football',
'route' => 'portal/Competition/index?type=0',
'option' =>
array (
'merge_rule_regex' => false,
),
'var' =>
array (
),
)
- [ HEADER ] array (
'x-tenant-forward-for' => '3.136.22.192',
'accept-encoding' => 'gzip, br, zstd, deflate',
'user-agent' => 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)',
'accept' => '*/*',
'x-forwarded-proto' => 'https',
'x-forwarded-for' => '3.136.22.192, 3.136.22.192',
'x-real-ip' => '3.136.22.192',
'host' => 'm.peatchina.com',
'content-length' => '',
'content-type' => '',
)
- [ PARAM ] array (
'type' => '0',
)
- [ LANG ] /mnt/7kzhanqun/app/portal/lang/zh-cn/home.php
- [ VIEW ] /mnt/7kzhanqun/public/themes/exigency01/portal/competition.html [ array (
0 => 'site_info',
1 => 'event_info',
2 => 'categories',
3 => 'front_theme',
4 => 'com_type',
5 => 'date',
6 => 'competition_name',
7 => 'navigation',
8 => 'pinyin',
9 => 'tdk',
10 => 'introduce',
11 => 'competition',
12 => 'theme_vars',
13 => 'theme_widgets',
) ]
- [ DB ] CONNECT:[ UseTime:0.005321s ] mysql:host=rm-3ns41jmtlb1g0zd6v.mysql.rds.aliyuncs.com;port=3306;dbname=daxiong;charset=utf8mb4
- [ SQL ] SHOW COLUMNS FROM `cmf_plugin_web` [ RunTime:0.003424s ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%m.peatchina.com%' LIMIT 1 [ RunTime:0.003163s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%m.peatchina.com%' LIMIT 1 [ RunTime:0.003158s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_plugin` [ RunTime:0.003528s ]
- [ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Web' AND `site_id` = 16 LIMIT 1 [ RunTime:0.003185s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 136,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%m.peatchina.com%' LIMIT 1 [ RunTime:0.003139s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_option` [ RunTime:0.003429s ]
- [ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'cdn_settings' AND `site_id` = 16 LIMIT 1 [ RunTime:0.003237s ]
- [ 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 '%m.peatchina.com%' LIMIT 1 [ RunTime:0.003098s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%m.peatchina.com%' LIMIT 1 [ RunTime:0.002982s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 16 LIMIT 1 [ RunTime:0.003149s ]
- [ 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 '%m.peatchina.com%' LIMIT 1 [ RunTime:0.003243s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%m.peatchina.com%' LIMIT 1 [ RunTime:0.003173s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'site_info' AND `site_id` = 16 LIMIT 1 [ RunTime:0.003170s ]
- [ 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.003540s ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` WHERE `status` = 1 [ RunTime:0.004816s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 756,
'filtered' => 9.999999046325684,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%m.peatchina.com%' LIMIT 1 [ RunTime:0.003262s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 16 LIMIT 1 [ RunTime:0.003117s ]
- [ 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.003448s ]
- [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `pinyin` = 'nba' LIMIT 1 [ RunTime:0.005187s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_competitions',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 3784,
'filtered' => 9.999999046325684,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%m.peatchina.com%' LIMIT 1 [ RunTime:0.003162s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `competition_id` FROM `cmf_plugin_web` WHERE `id` = 16 LIMIT 1 [ RunTime:0.003045s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 LIMIT 1 [ RunTime:0.003444s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_competitions',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 3784,
'filtered' => 9.999999046325684,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%m.peatchina.com%' LIMIT 1 [ RunTime:0.003132s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%m.peatchina.com%' LIMIT 1 [ RunTime:0.003125s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_nav_menu` [ RunTime:0.003248s ]
- [ SQL ] SELECT `name`,`href` FROM `cmf_nav_menu` WHERE `nav_id` = 1 AND `parent_id` = 0 AND `status` = 1 AND `site_id` = 16 [ RunTime:0.003350s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nav_menu',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 948,
'filtered' => 0.1054852306842804,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%m.peatchina.com%' LIMIT 1 [ RunTime:0.003162s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_nami_matches` [ RunTime:0.003482s ]
- [ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `competition_id` = 1 AND `com_type` = 0 AND `match_time` > 1730755383 LIMIT 100 [ RunTime:0.005706s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_matches',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'com_type,match_time,season_id',
'key' => 'season_id',
'key_len' => '5',
'ref' => 'const',
'rows' => 1140,
'filtered' => 8.490537643432617,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_nami_teams` [ RunTime:0.003395s ]
- [ SQL ] SELECT `short_name_zh` FROM `cmf_nami_teams` WHERE `cid` IN ('') AND `com_type` = 0 [ RunTime:0.003280s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => NULL,
'partitions' => NULL,
'type' => NULL,
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => NULL,
'filtered' => NULL,
'extra' => 'no matching row in const table',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.003330s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'exigency01' AND `file` = 'portal/article' LIMIT 1 [ RunTime:0.003287s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 291,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'exigency01' , `action` = 'portal/Article/index' , `file` = 'portal/article' , `name` = '资讯详情页' , `more` = '[]' , `config_more` = '[]' , `description` = '资讯详情页模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 'exigency01' AND `file` = 'portal/article' [ RunTime:0.003480s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'exigency01' AND `file` = 'portal/competition' LIMIT 1 [ RunTime:0.003184s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 291,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'exigency01' , `action` = 'portal/Competition/index' , `file` = 'portal/competition' , `name` = '赛程列表页' , `more` = '{\"vars\":[]}' , `config_more` = '{\"vars\":[]}' , `description` = '赛程列表模板文件' , `is_public` = 0 , `list_order` = 0 WHERE `theme` = 'exigency01' AND `file` = 'portal/competition' [ RunTime:0.003401s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'exigency01' AND `file` = 'portal/index' LIMIT 1 [ RunTime:0.003150s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 291,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'exigency01' , `action` = 'portal/Index/index' , `file` = 'portal/index' , `name` = '首页' , `more` = '{\"vars\":[]}' , `config_more` = '{\"vars\":[]}' , `description` = '首页模板文件' , `is_public` = 0 , `list_order` = 0 WHERE `theme` = 'exigency01' AND `file` = 'portal/index' [ RunTime:0.003370s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'exigency01' AND `file` = 'portal/list' LIMIT 1 [ RunTime:0.003353s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 291,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'exigency01' , `action` = 'portal/List/index' , `file` = 'portal/list' , `name` = '资讯列表页' , `more` = '[]' , `config_more` = '[]' , `description` = '资讯列表模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 'exigency01' AND `file` = 'portal/list' [ RunTime:0.003427s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'exigency01' AND `file` = 'portal/match' LIMIT 1 [ RunTime:0.003594s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 291,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'exigency01' , `action` = 'portal/Match/index' , `file` = 'portal/match' , `name` = '赛事详情页' , `more` = '{\"vars\":[]}' , `config_more` = '{\"vars\":[]}' , `description` = '赛事详情页模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 'exigency01' AND `file` = 'portal/match' [ RunTime:0.003367s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'exigency01' [ RunTime:0.003296s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 291,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_theme` [ RunTime:0.003305s ]
- [ SQL ] UPDATE `cmf_theme` SET `name` = 'ozb_live' , `version` = '1.0.2' , `demo_url` = 'https://www.zhjpec.com/' , `author` = '1408' , `lang` = 'zh-cn' , `author_url` = '' , `keywords` = 'ozb_live' , `description` = 'ozb_live' WHERE `theme` = 'exigency01' [ RunTime:0.003224s ]
- [ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = 'exigency01' AND ( `is_public` = 1 OR `file` = 'portal/competition' ) [ RunTime:0.003303s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 291,
'filtered' => 1.899999976158142,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%m.peatchina.com%' LIMIT 1 [ RunTime:0.003108s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'storage' AND `site_id` = 16 LIMIT 1 [ RunTime:0.003136s ]
- [ 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 '%m.peatchina.com%' LIMIT 1 [ RunTime:0.003098s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Oss' AND `site_id` = 16 LIMIT 1 [ RunTime:0.003161s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 136,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%m.peatchina.com%' LIMIT 1 [ RunTime:0.003237s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%m.peatchina.com%' LIMIT 1 [ RunTime:0.003149s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_nav` [ RunTime:0.003278s ]
- [ SQL ] SELECT `id` FROM `cmf_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.003077s ]
- [ 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` = 16 AND `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.004833s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nav_menu',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 948,
'filtered' => 0.1054852306842804,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%m.peatchina.com%' LIMIT 1 [ RunTime:0.003101s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%m.peatchina.com%' LIMIT 1 [ RunTime:0.003163s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.003051s ]
- [ 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` = 16 AND `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.003401s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nav_menu',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 948,
'filtered' => 0.1054852306842804,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `cid` FROM `cmf_nami_competitions` WHERE `pinyin` = 'nba' AND `com_type` = 1 LIMIT 1 [ RunTime:0.003822s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_competitions',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 3784,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `com_type` = 1 AND `competition_id` = 1 AND ( `match_time` > 1730744584 ) ORDER BY `match_time` ASC LIMIT 50 [ RunTime:0.004431s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_matches',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'com_type,match_time,season_id',
'key' => 'com_type',
'key_len' => '7',
'ref' => NULL,
'rows' => 961,
'filtered' => 0.6842367053031921,
'extra' => 'Using index condition; Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` = 1 [ RunTime:0.003339s ]
- [ 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` = 1 [ RunTime:0.003328s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_competitions',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'cid',
'key' => 'cid',
'key_len' => '7',
'ref' => 'const,const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (10136,10127,10155,10123,10149,10133,10124,10125,10126,10134,10119,10135,10121,10117,10115,10128,10118,10156,10120,10219,10132,10154,10122,10130,10114,10148,10116,10131,10137,10129) [ RunTime:0.003519s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_teams',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'cid',
'key' => 'cid',
'key_len' => '7',
'ref' => NULL,
'rows' => 30,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (10136,10127,10155,10123,10149,10133,10124,10125,10126,10134,10119,10135,10121,10117,10115,10128,10118,10156,10120,10219,10132,10154,10122,10130,10114,10148,10116,10131,10137,10129) [ RunTime:0.003403s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_teams',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'cid',
'key' => 'cid',
'key_len' => '7',
'ref' => NULL,
'rows' => 30,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT `cid` FROM `cmf_nami_competitions` WHERE `pinyin` = 'all' AND `com_type` = 0 LIMIT 1 [ RunTime:0.004561s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_competitions',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 3784,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `com_type` = 0 AND ( `match_time` > 1730744584 ) ORDER BY `match_time` ASC LIMIT 1000 [ RunTime:0.012785s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_matches',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'com_type,match_time',
'key' => 'com_type',
'key_len' => '7',
'ref' => NULL,
'rows' => 14256,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` IN (132,347,3136,431,870,270,309,169,97,2893,476,1696,3185,98,245,121,110,1936,143,108,1697,1824,1586,478,82,120,1736,3294,151,469,481,1722,429,436,473,3375,435,2164,430,475,6736,586,3489,1689,1815,54,675,1662,1863,349,59,2915,370,1796,1927,297,3075,77,351,3124,615,333,656,1745,3264,1668,1704,1699,3474,728,264,387,1775,512,271,3527,277,3032,243,2725,6737,1719,641,133,716,46,125,2101,194,2104,2000,100,2737,7200,84,90,2914,89,83,88,87,91,1776,235,465,486,7206,1842,579,1666,1851,1799,682,1885,263,1788,1819,671,260,337,360,214,374,1709,684,2064,388,332,47,664,300,128,359,3284,342,375,2040,978,3403,34,226,456,164,1677,3322,483,488,674,350,616,1723,1902,614,3265,730,1674,642,1785,1679,217,246,1907,376,1759,489,699,602,590,255,241,371,368,660,659,628,838,1667,348,1733,3306,717,112,253,658,385,296,1905,722,276,627,259,301,330,225,721,220,340,341,247,315,316,364,130,135,221,211,131,145,209,210,152,178,144,168,308,176,92,3008,129,180,109,179,175,303,234,159,142,146,1207,262,249,2798,569,3295,572,567,582) [ RunTime:0.047081s ]
- [ 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' => 237,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` IN (132,347,3136,431,870,270,309,169,97,2893,476,1696,3185,98,245,121,110,1936,143,108,1697,1824,1586,478,82,120,1736,3294,151,469,481,1722,429,436,473,3375,435,2164,430,475,6736,586,3489,1689,1815,54,675,1662,1863,349,59,2915,370,1796,1927,297,3075,77,351,3124,615,333,656,1745,3264,1668,1704,1699,3474,728,264,387,1775,512,271,3527,277,3032,243,2725,6737,1719,641,133,716,46,125,2101,194,2104,2000,100,2737,7200,84,90,2914,89,83,88,87,91,1776,235,465,486,7206,1842,579,1666,1851,1799,682,1885,263,1788,1819,671,260,337,360,214,374,1709,684,2064,388,332,47,664,300,128,359,3284,342,375,2040,978,3403,34,226,456,164,1677,3322,483,488,674,350,616,1723,1902,614,3265,730,1674,642,1785,1679,217,246,1907,376,1759,489,699,602,590,255,241,371,368,660,659,628,838,1667,348,1733,3306,717,112,253,658,385,296,1905,722,276,627,259,301,330,225,721,220,340,341,247,315,316,364,130,135,221,211,131,145,209,210,152,178,144,168,308,176,92,3008,129,180,109,179,175,303,234,159,142,146,1207,262,249,2798,569,3295,572,567,582) [ RunTime:0.004802s ]
- [ 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' => 237,
'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 (36533,26265,11040,10228,86479,68928,51316,68931,28958,26897,55697,72823,11186,38137,16544,18807,19328,10433,31345,72604,58747,71391,61291,58750,46508,85850,43684,58744,34101,14116,37544,45133,37313,44902,37352,35182,37334,37333,10443,12568,51865,55848,17022,12913,10280,10519,10458,10743,11201,18241,38990,19832,11477,37078,16419,10791,21927,37693,86465,73004,10385,10975,11194,10456,37958,37177,38225,38108,36963,76595,37178,37750,20188,42590,58375,19521,25180,24114,10018,10118,10371,10042,17476,16095,36964,53193,37575,36656,14194,23977,11364,12296,19758,15674,69629,54595,14963,18658,52596,68054,53533,48485,24899,10340,26219,10815,12146,12055,31367,45203,10496,10814,49059,79325,61361,74321,30228,16417,12391,14743,22945,52618,21590,10598,10812,10601,23504,10094,16415,15974,25063,25610,14966,12356,16230,10223,23804,28715,85963,36615,42355,59968,29731,33504,44700,34108,74563,76329,10908,19717,10070,10415,17009,19409,22297,22427,16058,15720,32948,23731,35600,35598,35601,74199,39576,27682,29339,22014,23823,37719,23937,12780,62443,71659,52877,18238,76744,51748,13108,31600,25593,81763,13950,10416,74617,18000,28891,12388,29337,62682,42449,23813,37351,37331,21471,83935,61660,29252,18773,27793,50610,33212,59129,68329,62889,38263,39549,56660,32978,32987,23744,30428,39034,39668,58617,28116,23936,48864,22426,18998,15769,44310,20128,15158,21695,48037,25058,49637,15183,14478,82867,62103,83108,74011,71805,66720,62276,28208,16057,86413,16893,37840,52982,71359,24222,23777,37624,40043,13148,18955,25542,26098,22121,18263,31230,31228,30426,31232,17618,17408,32651,50637,33566,25600,32246,18352,20416,10799,39239,11278,49810,21801,29563,29509,37786,38546,43611,14832,11879,12856,14422,16947,37171,61939,23987,23988,21674,21592,76281,76264,76231,76288,75422,76265,76454,52818,71660,47203,76453,47803,22391,30929,18212,12986,33067,70688,33095,21700,17663,17205,10312,26751,37762,49457,28185,77402,54959,72610,26393,52848,10682,10140,17195,11414,70269,17543,13544,16202,45241,26274,69270,36995,34897,49388,15263,19099,37975,26866,76232,76256,18917,21291,28199,17351,26754,24708,10267,11680,18322,42181,10375,10808,11407,10317,10648,10683,17773,23263,17838,23246,47193,10749,31199,86155,21737,64221,42664,59453,10613,11024,12886,52780,34649,26752,11428,31225,11527,10177,32373,10734,31200,11528,32278,12018,32525,18938,30384,16655,32229,10860,32954,10127,31227,10535,23159,38423,17540,13254,30425,16129,31202,11113,32999,11412,11842,11964,22400,10817,11115,24552,12216,13140,20344,21747,20966,19378,28052,10130,10021,10571,10538,10290,10004,10101,10184,15603,13857,15566,11413,11862,10573,10728,14755,22565,13493,25294,24378,42832,11179,22654,16897,17113,27781,10796,33003,19298,11502,20391,23207,11966,16356,12120,17115,15068,10534,13040,11480,14997,16214,12057,25320,15736,17061,15799,13141,19444,12058,17027,13042,38962,53179,17477,40124,16357,20186,17401,58359,12423,17398,24578,13041,17399,20915,14834,15599,14134,14135,13758,10859,31314,12019,31315,14655,31313,30233,11567,62045,11569,42412,53121,21451,11570,33546,12213,32944,16264,21911,18665,59382,31375,16127,19525,10680,10955,17197,10957,12832,14252,10998,29015,13051,29012,10068,10492,10025,10364,10030,10171,11207,10467,10249,10054,10217,10420,10206,10181,10256,10185,11844,10022,10165,33035,11206,10377,55375,28813,43710,18952,10428,16524,10105,19244,13649,22739,12154,10813,10818,10758,10147,10211,23761,10126,25483,13305,15217,11632,21521,28053,85451,86375,86377,86376,86379,86378,86381,86380,13194,11386,86368,86367,86370,86369,86372,86371,86374,86373,77374,30082,18780,60831,26410,60706,15034,50701,17265,17266,38094,29164,25533,75006,10417,10138,10336,16060,22019,22285,13059,74593,69638,16437,12451,77646,39144,30326,28215,20671,11256,12298,30563,48504,45145,13473,59136,73548,62852,80792,77563,31164,28847,62345,53867,14289,18461,30311,41207,42185,29876,25938,23194,34466,19331,12240,16610,42255,34579,19790,27310,30024,57454,38860,19225,23763,10628,15366,19189,71609,37715,32296,28263,10355,19248,28216,81269,15592,25154,29592,53132,40484,27990,51005,82456,53797,39000,20619,85399,49445,49449,44970,31809,38839,55216,42841,40234,48481,49530,37628,44971,18411,40367,71683,59375,41977,52456,83510,13184,16635,25409,23377,27868,34846,55055,76973,34877,34998,24917,32830,55072,28141,35175,19089,53344,10502,25544,17703,10447,29970,28389,29781,20220,19692,17566,26462,11240,20228,22200,21702,26153,85678,32927,38102,33744,82364,71750,72174,31597,72643,43204,72644,28851,81215,28852,24881,21101,31991,44472,14595,20710,14941,24550,13056,15066,32250,16012,11799,23069,16682,32156,76504,19878,27808,42438,77975,25366,86163,31640,61897,85200,17253,15759,22362,22543,47574,52171,62201,71661,13182,52893,76286,76254,75419,76282,76233,76257,76292,76255,18350,18476,21701,33096,26634,21197,43723,10233,10277,10120,10199,10640,14895,12469,16728,15352,30188,70037,75420,75421,13249,15771,25906,31653,21783,17999,59206,13938,20896,16201,44161,46110,33078,54340,12513,61143,49327,19562,14055,31285,56811,24866,14041,16948,15579,47230,22402,43203,17407,14046,11886,17604,14576,13033,14539,14481,16960,24622,14079,27264,28255,13670,53909,25432,25576,22735,55669,12485,64310,16575,20042,20242,15128,10363,14818,20928,28487,47807,10049,10411,10265,10200,10132,10365,46606,16949,28033,25050,26993,18415,58180,25772,20243,23989,10254,11440,20658,51845,62274,62879,64404,10325,44248,29495,72983,30989,34286,34340,11235,36962,11639,47271,82919,46629,27418,21355,37678,37683,10128,32213,24292,27926,22577,15129,32492,16818,10497,31316,29566,10108,35222,85762,20757,62857,24891,25744,30413,10790,15252,10351,18760,33040,62802,21730,10681,10175,20740,11526,10006,10246,10245,10011,15138,10569,10016,10146,10820,10015,10080,10000,10692,10215,10368,10251,10875,10109,10050,11060,29840,31125,10174,10024,11840,10023,10303,10167,37956,37971,14964,14962,20235,11408,14891,14009,14010,20475,13399,17840,25010,27102,13400,15828,14965,11791,13470,12357,76799,37049,33091,23834,10093,10166,19854,41727,17935,10757,10208,10117,25928,80093,13335,10753,23319,23267,26890,20634,11241,11863,15107,13115,15945,16418,17474,28363,30318,36526,19257,37357,21062,15655,15169,12210,12976,10062,34100,81292,10238,20439,20180,23895,25416,17635,14197,79326,13058,60349,69939,26429,59314,29207,14220,10767,21067,18342,13505,12238,26310,21864,14650,72669,29349,80938,26037,28224,29847,29863,28067,15864,25514,19699,21191,14552,22870,29885,77511,82866,82469,60389,54409,85361,14471,35034,34050,86408,32786,13055,26365,86410,32249,16707,20822,14411,28273,26346,17861,11794,19181,15859,17054,71605,12233,14473,77688,43615,26567,14809,15572,13149,16359,74499,38933,17188,17095,13381,25114,20107,72387,15261,21782,25901,68371,33807,78323,22322,29813,28562,37604,47644,24310,29364,25902,30717,60195,22257,47638,48546,26244,60612,32326,17316,28806,17254,15760,85977,24637,21455,15124,12235,21472,13257,17542,10078,10236,12345,10125,10874,10123,10203,10313,10330,10643,10183,17597,10027,10529,10079,11056,10423,15323,10906,39874,10642,10333,11631,27375,10134,68749,11816,10212,10950,10387,11314,10283,11361,11607,16895,73916,85887,38388,29496,59443,14525,36510,36951,62195,22515,10253,13939,28512,12137,18704,25574,22003,25968,28903,10811,13402,24053,10081,10400,10748,10195,11015,10268,10322,11372,10148,10135,11054,12143,10222,27727,10293,10005,10010,11506,10059,10029,10359,10524,10320,10180,52279,10464,10826,10064,11007,10040,24418,10285,10695,11001,10641,14578,10053,21523,52829,17859,11532,50065,26206,10338,10164,21171,30642,23519,25871,10083,10169,23481,32953,21520,16657,35510,18133,72737,76355,24460,16714,85155,57787,28556,25895,52560,22517,76334,76335,12475,29156,29968,25833,24307,41528,57788,52543,12477,20213,52161,52928,47289,23016,76419,52901,29133,37597,79329,12538,45699,38273,26458,25751,14815,24677,27399,42087,30135,28009,42091,16510,16512,17419,15140,16513,12464,13631,30068,72532,86437,32694,23951,12761,27226,39923,17988,54569,32749,31750,32387,56244,52416,19938,59214,71476,75426,36040,19404,61773,58206,26800,20163,32872,29986,22314,77510,48915,58906,17989,33469,20371,11943,24627,21308,60082,18046,24628,85848,66153,25666,37027,38491,48197,10735,46977,26681,12624,12148,12433,21539,12625,12528,18885,18884,12527,12627,14477,29727,16583,28724,36823,57546,50984,14258,21630,25280,55552,72286,12905,31717,11368,10574,31719,33458,59273,21310,58202,26798,21342,58204,17569,20162,19191,20212,29606,22316,13150,21473,48912,21400,13057,31528,11365,14779,14523,61642,79758,29555,85445,25276,22630,18047,43149,30467,14430,17137,13474,23357,12365,10505,35078,74862,43843,59224,27739,21126,12352,19700,26360,73433,68315,30749,14366,19877,49516,28601,27975,54749,44518,27779,29273,72668,30495,26825,39008,18266,54751,29651,24772,24384,55119,21729,11850,34066,16713,21060,20385,17684,21312,14920,14918,53993,21124,31807,55195,32098,14420,34435,33276,32283,31820,14470,40186,74098,79129,73238,69153,40181,68261,14632,21407,10672,20649,20985,14658,13382,29754,24340,18410,72386,72385,22747,22033,23844,53852,57507,18864,35021,40507,30239,27298,45771,23259,13251,69583,22041,56788,40518,54117,56830,60279,14633,60750,27731,11238,16746,17664,16871,11315,12680,10605,18584,10673,10145,30883,15436,26687,30208,11953,11951,19273,25693,10002,17327,23944,18400,35623,10398,62407,10350,12430,81316,10281,19577,25850,23811,16997,31413,10821,36917,11009,10966,11134,42290,31769,62455,26719,21645,58017,42676,16443,23838,15794,10324,10051,10038,10589,10902,20632,19880,17638,52991,33400,26190,17045,18706,33261,10803,10676,11697,15811,40224,19732,57308,35318,31735,44957,22156,35411,22723,19528,10332,10591,30172,13302,23262,16543,33260,19118,19956,31867,19234,12955,14996,14679,11367,35463,24187,15321,10383,11313,10670,11046,12943,19550,11151,11878,22629,34830,48472,23009,26323,18363,58348,12732,17925,26353,29136,71537,35350,30227,47296,35313,15032,37394,36456,71665,12970,38476,13450,57763,22689,21179,18576,35492,14466,58126,41840,19116,11243,20968,10384,18757,10431,16304,10434,10644,71606,14051,14354,10308,11896,11432,10412,29923,53174,11510,17144,16749,39582,36252,18245,18153,30699,36442,43072,23501,57745,13423,11699,16748,57930,36515,36766,10075,10432,10107,10376,10382,10104,10399,10442,10647,10077,10084,10091,11265,22288,85395,85402,85536,31231,31203,32277,30429,77632,32998,14440,16944,13956,11370,11531,10402,10671,10693,58650,21332,14825,11891,74474,11320,21476,13036,17086,10131,11657,10100,10088,10645,25580,11716,15978,21810,41827,28166,29226,40532,18582,45792,75434,34772,46874,33190,16096,13186,46875,47076,11767,10607,29924,57762,10129,10173,25023,27712,28200,24162,16025,63655,24000,23146,26132,16674,10857,10058,15228,19261,29974,76749,33758,48682,10729,10759,16460,14509,10243,14340,11525,12092,31626,22286,54039,84752,23012,29578,10301,10690,24536,14521,13301,52622,11504,33724,35954,21928,12422,24904,10294,11627,10679,10508,54284,23148,24466,11051,13290,16350,13657,14660,10421,11344,26877,22048,29052,14253,13408,21102,10974,10386,20981,11845,11260,15911,49500,49157,18049,11129,21671,25697,25655,27570,14631,37699,20947,23850,14905,12260,11838,24440,21477,14570,24093,29788,32282,31353,32804,10149,31044,49132,47538,20573,24585,24584,20571,26332,19842,24670,23810,15235,54027,43735,32639,33259,10210,14734,33583,24383,28238,54623,30040,26506,31922,30710,10334,10525,25413,10061,20273,10526,11681,16122,28678,23642,39916,10150,30993,14649,20001,55750) [ RunTime:0.025438s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_teams',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'cid',
'key' => 'cid',
'key_len' => '7',
'ref' => NULL,
'rows' => 1882,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (36533,26265,11040,10228,86479,68928,51316,68931,28958,26897,55697,72823,11186,38137,16544,18807,19328,10433,31345,72604,58747,71391,61291,58750,46508,85850,43684,58744,34101,14116,37544,45133,37313,44902,37352,35182,37334,37333,10443,12568,51865,55848,17022,12913,10280,10519,10458,10743,11201,18241,38990,19832,11477,37078,16419,10791,21927,37693,86465,73004,10385,10975,11194,10456,37958,37177,38225,38108,36963,76595,37178,37750,20188,42590,58375,19521,25180,24114,10018,10118,10371,10042,17476,16095,36964,53193,37575,36656,14194,23977,11364,12296,19758,15674,69629,54595,14963,18658,52596,68054,53533,48485,24899,10340,26219,10815,12146,12055,31367,45203,10496,10814,49059,79325,61361,74321,30228,16417,12391,14743,22945,52618,21590,10598,10812,10601,23504,10094,16415,15974,25063,25610,14966,12356,16230,10223,23804,28715,85963,36615,42355,59968,29731,33504,44700,34108,74563,76329,10908,19717,10070,10415,17009,19409,22297,22427,16058,15720,32948,23731,35600,35598,35601,74199,39576,27682,29339,22014,23823,37719,23937,12780,62443,71659,52877,18238,76744,51748,13108,31600,25593,81763,13950,10416,74617,18000,28891,12388,29337,62682,42449,23813,37351,37331,21471,83935,61660,29252,18773,27793,50610,33212,59129,68329,62889,38263,39549,56660,32978,32987,23744,30428,39034,39668,58617,28116,23936,48864,22426,18998,15769,44310,20128,15158,21695,48037,25058,49637,15183,14478,82867,62103,83108,74011,71805,66720,62276,28208,16057,86413,16893,37840,52982,71359,24222,23777,37624,40043,13148,18955,25542,26098,22121,18263,31230,31228,30426,31232,17618,17408,32651,50637,33566,25600,32246,18352,20416,10799,39239,11278,49810,21801,29563,29509,37786,38546,43611,14832,11879,12856,14422,16947,37171,61939,23987,23988,21674,21592,76281,76264,76231,76288,75422,76265,76454,52818,71660,47203,76453,47803,22391,30929,18212,12986,33067,70688,33095,21700,17663,17205,10312,26751,37762,49457,28185,77402,54959,72610,26393,52848,10682,10140,17195,11414,70269,17543,13544,16202,45241,26274,69270,36995,34897,49388,15263,19099,37975,26866,76232,76256,18917,21291,28199,17351,26754,24708,10267,11680,18322,42181,10375,10808,11407,10317,10648,10683,17773,23263,17838,23246,47193,10749,31199,86155,21737,64221,42664,59453,10613,11024,12886,52780,34649,26752,11428,31225,11527,10177,32373,10734,31200,11528,32278,12018,32525,18938,30384,16655,32229,10860,32954,10127,31227,10535,23159,38423,17540,13254,30425,16129,31202,11113,32999,11412,11842,11964,22400,10817,11115,24552,12216,13140,20344,21747,20966,19378,28052,10130,10021,10571,10538,10290,10004,10101,10184,15603,13857,15566,11413,11862,10573,10728,14755,22565,13493,25294,24378,42832,11179,22654,16897,17113,27781,10796,33003,19298,11502,20391,23207,11966,16356,12120,17115,15068,10534,13040,11480,14997,16214,12057,25320,15736,17061,15799,13141,19444,12058,17027,13042,38962,53179,17477,40124,16357,20186,17401,58359,12423,17398,24578,13041,17399,20915,14834,15599,14134,14135,13758,10859,31314,12019,31315,14655,31313,30233,11567,62045,11569,42412,53121,21451,11570,33546,12213,32944,16264,21911,18665,59382,31375,16127,19525,10680,10955,17197,10957,12832,14252,10998,29015,13051,29012,10068,10492,10025,10364,10030,10171,11207,10467,10249,10054,10217,10420,10206,10181,10256,10185,11844,10022,10165,33035,11206,10377,55375,28813,43710,18952,10428,16524,10105,19244,13649,22739,12154,10813,10818,10758,10147,10211,23761,10126,25483,13305,15217,11632,21521,28053,85451,86375,86377,86376,86379,86378,86381,86380,13194,11386,86368,86367,86370,86369,86372,86371,86374,86373,77374,30082,18780,60831,26410,60706,15034,50701,17265,17266,38094,29164,25533,75006,10417,10138,10336,16060,22019,22285,13059,74593,69638,16437,12451,77646,39144,30326,28215,20671,11256,12298,30563,48504,45145,13473,59136,73548,62852,80792,77563,31164,28847,62345,53867,14289,18461,30311,41207,42185,29876,25938,23194,34466,19331,12240,16610,42255,34579,19790,27310,30024,57454,38860,19225,23763,10628,15366,19189,71609,37715,32296,28263,10355,19248,28216,81269,15592,25154,29592,53132,40484,27990,51005,82456,53797,39000,20619,85399,49445,49449,44970,31809,38839,55216,42841,40234,48481,49530,37628,44971,18411,40367,71683,59375,41977,52456,83510,13184,16635,25409,23377,27868,34846,55055,76973,34877,34998,24917,32830,55072,28141,35175,19089,53344,10502,25544,17703,10447,29970,28389,29781,20220,19692,17566,26462,11240,20228,22200,21702,26153,85678,32927,38102,33744,82364,71750,72174,31597,72643,43204,72644,28851,81215,28852,24881,21101,31991,44472,14595,20710,14941,24550,13056,15066,32250,16012,11799,23069,16682,32156,76504,19878,27808,42438,77975,25366,86163,31640,61897,85200,17253,15759,22362,22543,47574,52171,62201,71661,13182,52893,76286,76254,75419,76282,76233,76257,76292,76255,18350,18476,21701,33096,26634,21197,43723,10233,10277,10120,10199,10640,14895,12469,16728,15352,30188,70037,75420,75421,13249,15771,25906,31653,21783,17999,59206,13938,20896,16201,44161,46110,33078,54340,12513,61143,49327,19562,14055,31285,56811,24866,14041,16948,15579,47230,22402,43203,17407,14046,11886,17604,14576,13033,14539,14481,16960,24622,14079,27264,28255,13670,53909,25432,25576,22735,55669,12485,64310,16575,20042,20242,15128,10363,14818,20928,28487,47807,10049,10411,10265,10200,10132,10365,46606,16949,28033,25050,26993,18415,58180,25772,20243,23989,10254,11440,20658,51845,62274,62879,64404,10325,44248,29495,72983,30989,34286,34340,11235,36962,11639,47271,82919,46629,27418,21355,37678,37683,10128,32213,24292,27926,22577,15129,32492,16818,10497,31316,29566,10108,35222,85762,20757,62857,24891,25744,30413,10790,15252,10351,18760,33040,62802,21730,10681,10175,20740,11526,10006,10246,10245,10011,15138,10569,10016,10146,10820,10015,10080,10000,10692,10215,10368,10251,10875,10109,10050,11060,29840,31125,10174,10024,11840,10023,10303,10167,37956,37971,14964,14962,20235,11408,14891,14009,14010,20475,13399,17840,25010,27102,13400,15828,14965,11791,13470,12357,76799,37049,33091,23834,10093,10166,19854,41727,17935,10757,10208,10117,25928,80093,13335,10753,23319,23267,26890,20634,11241,11863,15107,13115,15945,16418,17474,28363,30318,36526,19257,37357,21062,15655,15169,12210,12976,10062,34100,81292,10238,20439,20180,23895,25416,17635,14197,79326,13058,60349,69939,26429,59314,29207,14220,10767,21067,18342,13505,12238,26310,21864,14650,72669,29349,80938,26037,28224,29847,29863,28067,15864,25514,19699,21191,14552,22870,29885,77511,82866,82469,60389,54409,85361,14471,35034,34050,86408,32786,13055,26365,86410,32249,16707,20822,14411,28273,26346,17861,11794,19181,15859,17054,71605,12233,14473,77688,43615,26567,14809,15572,13149,16359,74499,38933,17188,17095,13381,25114,20107,72387,15261,21782,25901,68371,33807,78323,22322,29813,28562,37604,47644,24310,29364,25902,30717,60195,22257,47638,48546,26244,60612,32326,17316,28806,17254,15760,85977,24637,21455,15124,12235,21472,13257,17542,10078,10236,12345,10125,10874,10123,10203,10313,10330,10643,10183,17597,10027,10529,10079,11056,10423,15323,10906,39874,10642,10333,11631,27375,10134,68749,11816,10212,10950,10387,11314,10283,11361,11607,16895,73916,85887,38388,29496,59443,14525,36510,36951,62195,22515,10253,13939,28512,12137,18704,25574,22003,25968,28903,10811,13402,24053,10081,10400,10748,10195,11015,10268,10322,11372,10148,10135,11054,12143,10222,27727,10293,10005,10010,11506,10059,10029,10359,10524,10320,10180,52279,10464,10826,10064,11007,10040,24418,10285,10695,11001,10641,14578,10053,21523,52829,17859,11532,50065,26206,10338,10164,21171,30642,23519,25871,10083,10169,23481,32953,21520,16657,35510,18133,72737,76355,24460,16714,85155,57787,28556,25895,52560,22517,76334,76335,12475,29156,29968,25833,24307,41528,57788,52543,12477,20213,52161,52928,47289,23016,76419,52901,29133,37597,79329,12538,45699,38273,26458,25751,14815,24677,27399,42087,30135,28009,42091,16510,16512,17419,15140,16513,12464,13631,30068,72532,86437,32694,23951,12761,27226,39923,17988,54569,32749,31750,32387,56244,52416,19938,59214,71476,75426,36040,19404,61773,58206,26800,20163,32872,29986,22314,77510,48915,58906,17989,33469,20371,11943,24627,21308,60082,18046,24628,85848,66153,25666,37027,38491,48197,10735,46977,26681,12624,12148,12433,21539,12625,12528,18885,18884,12527,12627,14477,29727,16583,28724,36823,57546,50984,14258,21630,25280,55552,72286,12905,31717,11368,10574,31719,33458,59273,21310,58202,26798,21342,58204,17569,20162,19191,20212,29606,22316,13150,21473,48912,21400,13057,31528,11365,14779,14523,61642,79758,29555,85445,25276,22630,18047,43149,30467,14430,17137,13474,23357,12365,10505,35078,74862,43843,59224,27739,21126,12352,19700,26360,73433,68315,30749,14366,19877,49516,28601,27975,54749,44518,27779,29273,72668,30495,26825,39008,18266,54751,29651,24772,24384,55119,21729,11850,34066,16713,21060,20385,17684,21312,14920,14918,53993,21124,31807,55195,32098,14420,34435,33276,32283,31820,14470,40186,74098,79129,73238,69153,40181,68261,14632,21407,10672,20649,20985,14658,13382,29754,24340,18410,72386,72385,22747,22033,23844,53852,57507,18864,35021,40507,30239,27298,45771,23259,13251,69583,22041,56788,40518,54117,56830,60279,14633,60750,27731,11238,16746,17664,16871,11315,12680,10605,18584,10673,10145,30883,15436,26687,30208,11953,11951,19273,25693,10002,17327,23944,18400,35623,10398,62407,10350,12430,81316,10281,19577,25850,23811,16997,31413,10821,36917,11009,10966,11134,42290,31769,62455,26719,21645,58017,42676,16443,23838,15794,10324,10051,10038,10589,10902,20632,19880,17638,52991,33400,26190,17045,18706,33261,10803,10676,11697,15811,40224,19732,57308,35318,31735,44957,22156,35411,22723,19528,10332,10591,30172,13302,23262,16543,33260,19118,19956,31867,19234,12955,14996,14679,11367,35463,24187,15321,10383,11313,10670,11046,12943,19550,11151,11878,22629,34830,48472,23009,26323,18363,58348,12732,17925,26353,29136,71537,35350,30227,47296,35313,15032,37394,36456,71665,12970,38476,13450,57763,22689,21179,18576,35492,14466,58126,41840,19116,11243,20968,10384,18757,10431,16304,10434,10644,71606,14051,14354,10308,11896,11432,10412,29923,53174,11510,17144,16749,39582,36252,18245,18153,30699,36442,43072,23501,57745,13423,11699,16748,57930,36515,36766,10075,10432,10107,10376,10382,10104,10399,10442,10647,10077,10084,10091,11265,22288,85395,85402,85536,31231,31203,32277,30429,77632,32998,14440,16944,13956,11370,11531,10402,10671,10693,58650,21332,14825,11891,74474,11320,21476,13036,17086,10131,11657,10100,10088,10645,25580,11716,15978,21810,41827,28166,29226,40532,18582,45792,75434,34772,46874,33190,16096,13186,46875,47076,11767,10607,29924,57762,10129,10173,25023,27712,28200,24162,16025,63655,24000,23146,26132,16674,10857,10058,15228,19261,29974,76749,33758,48682,10729,10759,16460,14509,10243,14340,11525,12092,31626,22286,54039,84752,23012,29578,10301,10690,24536,14521,13301,52622,11504,33724,35954,21928,12422,24904,10294,11627,10679,10508,54284,23148,24466,11051,13290,16350,13657,14660,10421,11344,26877,22048,29052,14253,13408,21102,10974,10386,20981,11845,11260,15911,49500,49157,18049,11129,21671,25697,25655,27570,14631,37699,20947,23850,14905,12260,11838,24440,21477,14570,24093,29788,32282,31353,32804,10149,31044,49132,47538,20573,24585,24584,20571,26332,19842,24670,23810,15235,54027,43735,32639,33259,10210,14734,33583,24383,28238,54623,30040,26506,31922,30710,10334,10525,25413,10061,20273,10526,11681,16122,28678,23642,39916,10150,30993,14649,20001,55750) [ RunTime:0.023381s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_teams',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'cid',
'key' => 'cid',
'key_len' => '7',
'ref' => NULL,
'rows' => 1882,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%m.peatchina.com%' LIMIT 1 [ RunTime:0.021530s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 121 [ RunTime:0.021618s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 756,
'filtered' => 9.999999046325684,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.022827s ]
- [ SQL ] SELECT * FROM `cmf_portal_post` `post` WHERE `site_id` = 16 AND `post_status` = 1 AND `post_type` = 1 AND `delete_time` = 0 AND ( `category_id` IN (121,122,123) ) ORDER BY `published_time` DESC LIMIT 0,20 [ RunTime:0.021782s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'post',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'type_status_date,category_id,idx_siteid_deletetime_posttype_poststatus_publishedtime,idx_8f8efa778253e4a38b4800acfaedd014',
'key' => 'category_id',
'key_len' => '14',
'ref' => NULL,
'rows' => 68,
'filtered' => 0.07352941483259201,
'extra' => 'Using index condition; Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.021835s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 756,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_user` [ RunTime:0.021396s ]
- [ SQL ] SELECT `id`,`user_nickname` FROM `cmf_user` [ RunTime:0.021848s ]
- [ 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.021656s ]
- [ 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.021784s ]
- [ SQL ] SELECT `tag_id` FROM `cmf_portal_tag_post` WHERE `post_id` = 7417013 [ RunTime:0.021895s ]
- [ 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' => 7,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_portal_tag` [ RunTime:0.021688s ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (3403,3609,3610,3611,3612,3613) [ RunTime:0.021882s ]
- [ 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' => 6,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 122 LIMIT 1 [ RunTime:0.021757s ]
- [ 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` = 7416863 [ RunTime:0.021604s ]
- [ 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' => 7,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (4285,31397,31398,57041,31400,31401,31402) [ RunTime:0.021800s ]
- [ 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' => 7,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 122 LIMIT 1 [ RunTime:0.021929s ]
- [ 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` = 7416589 [ RunTime:0.021827s ]
- [ 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' => 7,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (4285,31397,31398,57041,31400,31401,31402) [ RunTime:0.021796s ]
- [ 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' => 7,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 122 LIMIT 1 [ RunTime:0.021497s ]
- [ 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` = 7416357 [ RunTime:0.021871s ]
- [ 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' => 7,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (3403,3609,3610,3611,3612,3613) [ RunTime:0.021935s ]
- [ 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' => 6,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 122 LIMIT 1 [ RunTime:0.021769s ]
- [ 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` = 7416127 [ RunTime:0.021766s ]
- [ 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' => 7,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (3403,3609,3610,3611,3612,3613) [ RunTime:0.021634s ]
- [ 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' => 6,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 122 LIMIT 1 [ RunTime:0.021762s ]
- [ 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` = 7415894 [ RunTime:0.021896s ]
- [ 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' => 8,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (2797,2798,2799,2800,2801,2802,2803,2804) [ RunTime:0.021853s ]
- [ 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' => 8,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 122 LIMIT 1 [ RunTime:0.022781s ]
- [ 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` = 7415658 [ RunTime:0.021735s ]
- [ 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 (59646,59647,59648,59649,59650) [ RunTime:0.021799s ]
- [ 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` = 122 LIMIT 1 [ RunTime:0.003053s ]
- [ 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` = 7415382 [ RunTime:0.003132s ]
- [ 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' => 7,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (3403,3609,3610,3611,3612,3613) [ RunTime:0.003108s ]
- [ 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' => 6,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 122 LIMIT 1 [ RunTime:0.003047s ]
- [ 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` = 6895002 [ RunTime:0.003359s ]
- [ 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' => 7,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (3403,3609,3610,3611,3612,3613) [ RunTime:0.003121s ]
- [ 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' => 6,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 122 LIMIT 1 [ RunTime:0.003026s ]
- [ 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` = 6461992 [ RunTime:0.003459s ]
- [ 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' => 7,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (3439,57736,57737,57738,57739,57740,57741) [ RunTime:0.003107s ]
- [ 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' => 7,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 122 LIMIT 1 [ RunTime:0.003051s ]
- [ 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` = 5814533 [ RunTime:0.003387s ]
- [ 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' => 7,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (4285,31397,31398,57041,31400,31401,31402) [ RunTime:0.003107s ]
- [ 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' => 7,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 122 LIMIT 1 [ RunTime:0.003055s ]
- [ 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` = 5412310 [ RunTime:0.003433s ]
- [ 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' => 6,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (3798,56805,56806,56807,56808) [ RunTime:0.003152s ]
- [ 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` = 123 LIMIT 1 [ RunTime:0.003590s ]
- [ 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` = 271115 [ RunTime:0.003144s ]
- [ 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' => 4,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (7716,29570,10873,32849) [ RunTime:0.003041s ]
- [ 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' => 4,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 122 LIMIT 1 [ RunTime:0.003095s ]
- [ 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` = 270877 [ RunTime:0.003171s ]
- [ 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' => 8,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (2797,2798,2799,2800,2801,2802,2803,2804) [ RunTime:0.003124s ]
- [ 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' => 8,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 122 LIMIT 1 [ RunTime:0.003035s ]
- [ 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` = 270840 [ RunTime:0.003089s ]
- [ 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' => 3,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (7716,32394,7718) [ RunTime:0.003126s ]
- [ 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' => 3,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 122 LIMIT 1 [ RunTime:0.003114s ]
- [ 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` = 270536 [ RunTime:0.003264s ]
- [ 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' => 7,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (4285,31397,31398,31399,31400,31401,31402) [ RunTime:0.003149s ]
- [ 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' => 7,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 122 LIMIT 1 [ RunTime:0.003107s ]
- [ 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` = 270486 [ RunTime:0.003558s ]
- [ 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' => 4,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (7716,31771,10894,11014) [ RunTime:0.003093s ]
- [ 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' => 4,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 122 LIMIT 1 [ RunTime:0.003048s ]
- [ 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` = 270437 [ RunTime:0.003096s ]
- [ 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' => 2,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (3748,31729) [ RunTime:0.003097s ]
- [ 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' => 2,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 122 LIMIT 1 [ RunTime:0.003128s ]
- [ 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` = 270263 [ RunTime:0.003072s ]
- [ 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' => 2,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (31461,31462) [ RunTime:0.003052s ]
- [ 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' => 2,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 122 LIMIT 1 [ RunTime:0.003060s ]
- [ 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` = 270245 [ RunTime:0.003069s ]
- [ 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' => 7,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (4285,31397,31398,31399,31400,31401,31402) [ RunTime:0.003077s ]
- [ 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' => 7,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 122 LIMIT 1 [ RunTime:0.003070s ]
- [ 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 `cid` FROM `cmf_nami_competitions` WHERE `pinyin` = 'all' AND `com_type` = 1 LIMIT 1 [ RunTime:0.004350s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_competitions',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 3784,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `com_type` = 1 AND ( `match_time` > 1730744585 ) ORDER BY `match_time` ASC LIMIT 1000 [ RunTime:0.007478s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_matches',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'com_type,match_time',
'key' => 'com_type',
'key_len' => '7',
'ref' => NULL,
'rows' => 961,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` IN (418,299,76,899,41,1,5,3,277,222,54,35,1360,2244,11,267,435,266,371,264,57,28,26,29,46,17,74,3945,2134,201,460,182,43,1146,9,88,274,181,73,93,10,4021,14,58,90,13,72,66,92,91,47,7,34,40,33,32,8,6,12,69,65,3855,86,82,59,70,50,1225,2290,3867) [ RunTime:0.004072s ]
- [ 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' => 70,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` IN (418,299,76,899,41,1,5,3,277,222,54,35,1360,2244,11,267,435,266,371,264,57,28,26,29,46,17,74,3945,2134,201,460,182,43,1146,9,88,274,181,73,93,10,4021,14,58,90,13,72,66,92,91,47,7,34,40,33,32,8,6,12,69,65,3855,86,82,59,70,50,1225,2290,3867) [ RunTime:0.003840s ]
- [ 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' => 70,
'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 (15539,15315,13367,13345,13317,12412,13383,13526,13295,104775,12917,12877,34047,13343,34048,12895,12879,12822,13435,12955,13300,13394,35421,11151,39026,13298,13488,13384,20889,13337,105677,35631,14029,12835,13479,12919,13453,13382,39085,36654,13504,12810,15186,30384,13299,13493,15217,11037,12663,11035,27784,13427,105678,12921,105679,12882,13573,12858,10136,10127,13314,104776,13381,104777,10155,10123,10149,10133,10124,10125,10126,10134,10119,10135,10121,10117,10115,10128,10118,10156,10120,10219,10132,10154,10122,10130,10114,10148,10116,10131,10137,10129,104342,10161,10732,11072,21609,104343,40337,15033,10159,11510,13011,41460,38854,12625,12077,12414,10975,12614,12138,30649,12460,10178,12455,10695,10749,11567,11899,104403,12599,10301,40291,12104,27026,15018,11521,11876,11101,11102,10317,14167,19952,104404,25585,15889,25386,20611,17350,14901,10182,14906,11620,15466,14899,30328,12785,10193,10687,12206,11531,15250,35012,10899,15586,10142,11127,15036,11850,11517,12792,104405,10746,12256,11537,40583,11528,104406,12444,10257,11511,12419,12817,13404,11163,11149,11153,33923,12205,22477,11030,11028,27584,12146,11024,11092,11405,10689,11407,10139,10104,11143,11609,11472,11893,10786,11471,11468,10930,11464,11470,10788,12448,11617,11467,12730,11465,12094,11903,11466,12244,30756,104407,36923,104408,10893,12623,11103,12261,10731,10726,104409,10106,12436,12329,104460,10146,12972,11107,10977,11863,11104,11108,10978,11111,11105,11622,10232,10926,10747,11198,11279,14135,11276,11697,10190,11169,11170,10927,11171,11011,13004,11813,10887,14145,35404,12504,11228,40232,21012,10757,12081,11099,10891,12474,10271,104835,10204,12989,10286,11927,23072,11933,104461,104462,12633,10240,14161,10711,10330,10226,11088,11934,11928,13469,12916,12814,35146,11154,11820,12145,104470,20462,10105,10103,104471,104472,38315,38324,10659,10657,11156,11140,36651,10667,23737,10632,10628,10634,10637,10677,10635,10672,10681,10679,10624,10633,10625,10878,10678,12030,10879,10636,10638,10626,10629,10682,10621,10622,10676,10675,10674,10630,10627,10798,10669,10673,10683,10670,12331,12325,10877,104533,104534,10267,30227,15500,10322,12420,12421,10108,14806,11191,10188,10177,11168,10924,12082,10710,10706,24923,10186,10280,11544,23000,10718,11867,38566,24960,12285,33766,12808,13331,12804,11020,12549,35779,11036,10163,104535,11358,10898,30266,10666,11157,12103,14960,40304,14609,37105,37414,39126,12790,24234,10742,12449,10185,11580,12577,10180,10175,30148,12424,12579,10904,11161,39226,10295,10790,104591,104592,25030,11883,11878,12741,11552,10265,10263,12413,20266,10713,10714,10199,10196,10198,14646,40011,11136,10302,10294,10101,12564,12417,38455,14738,30559,36671,10702,10269,11530,104593,104594,10107,10140,20090,15458,11571,36695,11497,10143,10283,10145,10109,12650,10213,11533,104595,12404,11535,12582,10167,10231,104785,12863,13322,11026,38711,11946,12824,104786,12738,36690,10218,19417,10306,12638,32904,11725,25010,30344,10299,20993,10246,104657,11618,39168,104658,12078,12971,19582,37373,19502,37993,25034,12473,11513,10308,11698,10768,40230,12345,104659,12547,25440,19903,33743,12591,10751,11278,11281,26603,25002,11280,10740,12299,36279,38832,11160,12311,38727,25360,25361,12112,12110,11284,40140,30424,20404,10910,11197,10113,12288,10307,19598,10719,10331,20039,11123,11006,11005,11724,11857,12960,11856,11858,11116,11115,10974,11122,14859,11126,16412,10250,38538,10963,12434,10321,11574,24772,13040,11222,12089,11594,35585,11347,11592,11013,11869,29766,12262,10922,11884,11877,14587,17782,11882,40132,10258,104661,11868,10192,10247,21205,24574,11498,40482,10166,10209,10293,10215,10208,11576,11525,14721,12070,12568,10698,24874,10266,11091,11473,10160,104729,104730,11864,104731,40192,13087,13089,12330,10268,36319,10705,13094,14350,14970,30286,12326,38675,36529,20074,11008,10228,10230,11007,10754,10973,11847,11861,11142,10289,10112,12093,12092,11548,11599,10281,12604,11558,11137,10270,15086,11129,25439,15483,12296,10723,10316,14163,11196,14959,10315,19471,10310,10934,11900,10276,104732,10248,13358,19300,10984,104739,12729,40201,16361,10780,12276,30292,14896,29994,10181,10183,32199,32902,38789,104794,12783,11817,104795,30230,12105,13318,13498,12905,28000,12552,30414,13448,104796,104797,10895,12471,25484,10951,20211,11201,34573,11258,11244,40378,33983,39650,27252,19623,12432,12293,12126,40188,24705,40106,19599,40268,12600,38777,10914,12131,40267,19396,19836,30278,38508,104850,104851,14972,10170,12628,14759,11560,12466,11200,104853,11215,12578,19537,11194,11192,10743,11112,10884,31589,11819,20785,33673,10752,104854,104861,11512,29986,38609,12684,30751,11203,10959,11657,14786,11199,10949,12303,10889,12446,11166,11507,29703,11937,11930,104928,104929,11612,104930,11257,12617,10345,104998,104999,30314,12557,11518,14152,105000,105001,12272,28788,11524,13348,105002,13980,12910,11892,12259,12264,12247,30438,40138,12618,35754,12748,12584,10886,15854,11995,11238,11262,22901,12435,11219,11996,12545,30154,105147,12779,105148,10242,11250,18751,14602,11546,11543,105149,25280,105150,19660,12502,11010,105151,37347,11835,12075,10937,10736,16008,12562,10256,10110,105153,105154,105155,38679,105156,105157,11113,33500,35240,24702,11337,35242,12295,34200,105158,11326,105160,105165,33690,10221,105167,13385,10224,30698,10285,105168,105246,13374,12426,10782,12900,13379,12807,10896,37663,13035,11600,11628,14175,11823,11272,10530,10496,10526,11274,10515,10512,10514,10508,10511,10829,11951) [ RunTime:0.010002s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_teams',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'cid',
'key' => 'cid',
'key_len' => '7',
'ref' => NULL,
'rows' => 886,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (15539,15315,13367,13345,13317,12412,13383,13526,13295,104775,12917,12877,34047,13343,34048,12895,12879,12822,13435,12955,13300,13394,35421,11151,39026,13298,13488,13384,20889,13337,105677,35631,14029,12835,13479,12919,13453,13382,39085,36654,13504,12810,15186,30384,13299,13493,15217,11037,12663,11035,27784,13427,105678,12921,105679,12882,13573,12858,10136,10127,13314,104776,13381,104777,10155,10123,10149,10133,10124,10125,10126,10134,10119,10135,10121,10117,10115,10128,10118,10156,10120,10219,10132,10154,10122,10130,10114,10148,10116,10131,10137,10129,104342,10161,10732,11072,21609,104343,40337,15033,10159,11510,13011,41460,38854,12625,12077,12414,10975,12614,12138,30649,12460,10178,12455,10695,10749,11567,11899,104403,12599,10301,40291,12104,27026,15018,11521,11876,11101,11102,10317,14167,19952,104404,25585,15889,25386,20611,17350,14901,10182,14906,11620,15466,14899,30328,12785,10193,10687,12206,11531,15250,35012,10899,15586,10142,11127,15036,11850,11517,12792,104405,10746,12256,11537,40583,11528,104406,12444,10257,11511,12419,12817,13404,11163,11149,11153,33923,12205,22477,11030,11028,27584,12146,11024,11092,11405,10689,11407,10139,10104,11143,11609,11472,11893,10786,11471,11468,10930,11464,11470,10788,12448,11617,11467,12730,11465,12094,11903,11466,12244,30756,104407,36923,104408,10893,12623,11103,12261,10731,10726,104409,10106,12436,12329,104460,10146,12972,11107,10977,11863,11104,11108,10978,11111,11105,11622,10232,10926,10747,11198,11279,14135,11276,11697,10190,11169,11170,10927,11171,11011,13004,11813,10887,14145,35404,12504,11228,40232,21012,10757,12081,11099,10891,12474,10271,104835,10204,12989,10286,11927,23072,11933,104461,104462,12633,10240,14161,10711,10330,10226,11088,11934,11928,13469,12916,12814,35146,11154,11820,12145,104470,20462,10105,10103,104471,104472,38315,38324,10659,10657,11156,11140,36651,10667,23737,10632,10628,10634,10637,10677,10635,10672,10681,10679,10624,10633,10625,10878,10678,12030,10879,10636,10638,10626,10629,10682,10621,10622,10676,10675,10674,10630,10627,10798,10669,10673,10683,10670,12331,12325,10877,104533,104534,10267,30227,15500,10322,12420,12421,10108,14806,11191,10188,10177,11168,10924,12082,10710,10706,24923,10186,10280,11544,23000,10718,11867,38566,24960,12285,33766,12808,13331,12804,11020,12549,35779,11036,10163,104535,11358,10898,30266,10666,11157,12103,14960,40304,14609,37105,37414,39126,12790,24234,10742,12449,10185,11580,12577,10180,10175,30148,12424,12579,10904,11161,39226,10295,10790,104591,104592,25030,11883,11878,12741,11552,10265,10263,12413,20266,10713,10714,10199,10196,10198,14646,40011,11136,10302,10294,10101,12564,12417,38455,14738,30559,36671,10702,10269,11530,104593,104594,10107,10140,20090,15458,11571,36695,11497,10143,10283,10145,10109,12650,10213,11533,104595,12404,11535,12582,10167,10231,104785,12863,13322,11026,38711,11946,12824,104786,12738,36690,10218,19417,10306,12638,32904,11725,25010,30344,10299,20993,10246,104657,11618,39168,104658,12078,12971,19582,37373,19502,37993,25034,12473,11513,10308,11698,10768,40230,12345,104659,12547,25440,19903,33743,12591,10751,11278,11281,26603,25002,11280,10740,12299,36279,38832,11160,12311,38727,25360,25361,12112,12110,11284,40140,30424,20404,10910,11197,10113,12288,10307,19598,10719,10331,20039,11123,11006,11005,11724,11857,12960,11856,11858,11116,11115,10974,11122,14859,11126,16412,10250,38538,10963,12434,10321,11574,24772,13040,11222,12089,11594,35585,11347,11592,11013,11869,29766,12262,10922,11884,11877,14587,17782,11882,40132,10258,104661,11868,10192,10247,21205,24574,11498,40482,10166,10209,10293,10215,10208,11576,11525,14721,12070,12568,10698,24874,10266,11091,11473,10160,104729,104730,11864,104731,40192,13087,13089,12330,10268,36319,10705,13094,14350,14970,30286,12326,38675,36529,20074,11008,10228,10230,11007,10754,10973,11847,11861,11142,10289,10112,12093,12092,11548,11599,10281,12604,11558,11137,10270,15086,11129,25439,15483,12296,10723,10316,14163,11196,14959,10315,19471,10310,10934,11900,10276,104732,10248,13358,19300,10984,104739,12729,40201,16361,10780,12276,30292,14896,29994,10181,10183,32199,32902,38789,104794,12783,11817,104795,30230,12105,13318,13498,12905,28000,12552,30414,13448,104796,104797,10895,12471,25484,10951,20211,11201,34573,11258,11244,40378,33983,39650,27252,19623,12432,12293,12126,40188,24705,40106,19599,40268,12600,38777,10914,12131,40267,19396,19836,30278,38508,104850,104851,14972,10170,12628,14759,11560,12466,11200,104853,11215,12578,19537,11194,11192,10743,11112,10884,31589,11819,20785,33673,10752,104854,104861,11512,29986,38609,12684,30751,11203,10959,11657,14786,11199,10949,12303,10889,12446,11166,11507,29703,11937,11930,104928,104929,11612,104930,11257,12617,10345,104998,104999,30314,12557,11518,14152,105000,105001,12272,28788,11524,13348,105002,13980,12910,11892,12259,12264,12247,30438,40138,12618,35754,12748,12584,10886,15854,11995,11238,11262,22901,12435,11219,11996,12545,30154,105147,12779,105148,10242,11250,18751,14602,11546,11543,105149,25280,105150,19660,12502,11010,105151,37347,11835,12075,10937,10736,16008,12562,10256,10110,105153,105154,105155,38679,105156,105157,11113,33500,35240,24702,11337,35242,12295,34200,105158,11326,105160,105165,33690,10221,105167,13385,10224,30698,10285,105168,105246,13374,12426,10782,12900,13379,12807,10896,37663,13035,11600,11628,14175,11823,11272,10530,10496,10526,11274,10515,10512,10514,10508,10511,10829,11951) [ RunTime:0.009934s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_teams',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'cid',
'key' => 'cid',
'key_len' => '7',
'ref' => NULL,
'rows' => 886,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
2.268871s
