基本
文件
流程
错误
SQL
调试
- 请求信息 : 2024-11-05 14:42:53 HTTP/1.1 GET : https://m.peatchina.com/football/169
- 运行时间 : 1.176487s [ 吞吐率：0.85req/s ] 内存消耗：2,578.98kb 文件加载：139
- 查询信息 : 138 queries 6 writes
- 缓存信息 : 6 reads,0 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.144.117.167',
'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.144.117.167, 3.144.117.167',
'x-real-ip' => '3.144.117.167',
'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.004934s ] mysql:host=rm-3ns41jmtlb1g0zd6v.mysql.rds.aliyuncs.com;port=3306;dbname=daxiong;charset=utf8mb4
- [ SQL ] SHOW COLUMNS FROM `cmf_plugin_web` [ RunTime:0.003284s ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%m.peatchina.com%' LIMIT 1 [ RunTime:0.003094s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%m.peatchina.com%' LIMIT 1 [ RunTime:0.002964s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_plugin` [ RunTime:0.003195s ]
- [ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Web' AND `site_id` = 16 LIMIT 1 [ RunTime:0.003098s ]
- [ 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.002998s ]
- [ 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.003423s ]
- [ 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.002918s ]
- [ 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.002949s ]
- [ 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.002915s ]
- [ 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.002910s ]
- [ 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_portal_category` [ RunTime:0.003078s ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` WHERE `status` = 1 [ RunTime:0.004570s ]
- [ 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.002978s ]
- [ 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.003062s ]
- [ 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.003302s ]
- [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `pinyin` = 'nba' LIMIT 1 [ RunTime:0.004846s ]
- [ 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.002911s ]
- [ 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.002928s ]
- [ 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.003088s ]
- [ 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.002889s ]
- [ 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.002958s ]
- [ 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.003137s ]
- [ 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.003168s ]
- [ 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.003167s ]
- [ 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.003695s ]
- [ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `competition_id` = 1 AND `com_type` = 0 AND `match_time` > 1730788973 LIMIT 100 [ RunTime:0.005629s ]
- [ 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.973875045776367,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_nami_teams` [ RunTime:0.003279s ]
- [ SQL ] SELECT `short_name_zh` FROM `cmf_nami_teams` WHERE `cid` IN ('') AND `com_type` = 0 [ RunTime:0.002958s ]
- [ 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.003132s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'exigency01' AND `file` = 'portal/article' LIMIT 1 [ RunTime:0.003021s ]
- [ 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.003279s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'exigency01' AND `file` = 'portal/competition' LIMIT 1 [ RunTime:0.002983s ]
- [ 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.003642s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'exigency01' AND `file` = 'portal/index' LIMIT 1 [ RunTime:0.002967s ]
- [ 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.003383s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'exigency01' AND `file` = 'portal/list' LIMIT 1 [ RunTime:0.003025s ]
- [ 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.003304s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'exigency01' AND `file` = 'portal/match' LIMIT 1 [ RunTime:0.002979s ]
- [ 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.003212s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'exigency01' [ RunTime:0.012439s ]
- [ 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.003165s ]
- [ 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.003004s ]
- [ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = 'exigency01' AND ( `is_public` = 1 OR `file` = 'portal/competition' ) [ RunTime:0.012850s ]
- [ 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.003049s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%m.peatchina.com%' LIMIT 1 [ RunTime:0.002931s ]
- [ 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.003010s ]
- [ 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.011868s ]
- [ 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.007290s ]
- [ 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.003066s ]
- [ SQL ] SELECT `id` FROM `cmf_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.002921s ]
- [ 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.009690s ]
- [ 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.012569s ]
- [ 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.002911s ]
- [ 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.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.003251s ]
- [ 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.003679s ]
- [ 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` > 1730778173 ) ORDER BY `match_time` ASC LIMIT 50 [ RunTime:0.004289s ]
- [ 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' => 915,
'filtered' => 0.6835638880729675,
'extra' => 'Using index condition; Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` = 1 [ RunTime:0.003138s ]
- [ 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.003118s ]
- [ 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 (10133,10118,10120,10122,10115,10125,10155,10124,10137,10128,10149,10126,10127,10154,10117,10130,10219,10148,10135,10131,10116,10129,10114,10119,10156,10121,10136,10132,10134,10123) [ RunTime:0.003268s ]
- [ 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 (10133,10118,10120,10122,10115,10125,10155,10124,10137,10128,10149,10126,10127,10154,10117,10130,10219,10148,10135,10131,10116,10129,10114,10119,10156,10121,10136,10132,10134,10123) [ RunTime:0.003236s ]
- [ 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.004151s ]
- [ 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` > 1730778173 ) ORDER BY `match_time` ASC LIMIT 1000 [ RunTime:0.007758s ]
- [ 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' => 14972,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` IN (3502,1806,6736,7196,586,3489,1689,1815,54,675,1662,1863,349,59,2915,370,1796,1927,3075,297,77,351,374,3124,1696,615,333,656,3375,97,1745,3264,1668,1704,1699,3474,728,264,387,34,1775,512,271,3527,277,3032,243,2725,6737,1719,641,133,347,716,7180,46,132,125,2101,1726,1881,194,2104,2000,100,2737,7200,84,90,2914,89,83,88,87,91,1776,235,1586,1715,1824,1720,429,436,475,481,435,465,486,7206,1842,579,1666,1851,1799,682,1885,263,1788,1819,671,260,337,360,214,1671,1709,684,1708,2064,388,332,47,664,300,128,359,3284,342,375,2040,978,3403,226,456,164,1677,3322,483,488,674,350,616,1723,1902,614,3265,730,1674,642,1785,1679,217,246,1907,376,108,1759,489,699,602,590,255,241,371,368,660,659,628,838,1667,348,1733,3306,717,112,253,658,385,296,1905,722,276,627,870,270,259,301,330,225,721,220,340,341,245,247,315,316,364,130,135,221,211,131,145,209,210,152,178,144,168,169,308,176,143,92,1736,3008,129,180,109,179,121,110,175,303,234,159,142,120,146,1207,151,473,262,249,469,2798,478,569,3295,572,457,567,582,3073,545,1746,581,688) [ RunTime:0.005474s ]
- [ 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' => 239,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` IN (3502,1806,6736,7196,586,3489,1689,1815,54,675,1662,1863,349,59,2915,370,1796,1927,3075,297,77,351,374,3124,1696,615,333,656,3375,97,1745,3264,1668,1704,1699,3474,728,264,387,34,1775,512,271,3527,277,3032,243,2725,6737,1719,641,133,347,716,7180,46,132,125,2101,1726,1881,194,2104,2000,100,2737,7200,84,90,2914,89,83,88,87,91,1776,235,1586,1715,1824,1720,429,436,475,481,435,465,486,7206,1842,579,1666,1851,1799,682,1885,263,1788,1819,671,260,337,360,214,1671,1709,684,1708,2064,388,332,47,664,300,128,359,3284,342,375,2040,978,3403,226,456,164,1677,3322,483,488,674,350,616,1723,1902,614,3265,730,1674,642,1785,1679,217,246,1907,376,108,1759,489,699,602,590,255,241,371,368,660,659,628,838,1667,348,1733,3306,717,112,253,658,385,296,1905,722,276,627,870,270,259,301,330,225,721,220,340,341,245,247,315,316,364,130,135,221,211,131,145,209,210,152,178,144,168,169,308,176,143,92,1736,3008,129,180,109,179,121,110,175,303,234,159,142,120,146,1207,151,473,262,249,469,2798,478,569,3295,572,457,567,582,3073,545,1746,581,688) [ RunTime:0.004496s ]
- [ 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' => 239,
'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 (83936,74681,86041,85746,16230,10223,86059,86047,23804,28715,85963,36615,42355,59968,29731,33504,78784,71396,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,32387,52416,25593,81763,13950,10416,74617,18000,28891,12388,29337,62682,26462,11240,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,30426,31232,22426,18998,15769,44310,20128,15158,21695,48037,25058,49637,15183,14478,82867,62103,83108,74011,71805,66720,62276,28208,16057,86413,52982,71359,13148,18955,25542,26098,22121,18263,31230,31228,17618,17408,32651,50637,33566,25600,32246,18352,20416,10799,39239,11278,49810,21801,22299,18139,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,16893,37840,24222,23777,37624,40043,28185,77402,54959,72610,26393,52848,10682,10140,17195,11414,70269,17543,13544,16202,45241,26274,69270,36995,34897,49388,15263,19099,37975,26866,76232,76256,18917,21291,28199,17351,26754,24708,10267,11680,18322,42181,85619,45435,85574,85463,10375,10808,11407,10317,10648,10683,17773,23263,17838,23246,47193,10749,31199,86155,21737,64221,13873,53025,20792,38530,15111,19993,23456,41430,42664,59453,10613,11024,12886,52780,34649,26752,12361,24523,11428,31225,11527,10177,32373,10734,31200,11528,32278,12018,32525,18938,30384,16655,32229,10860,32954,10127,31227,10535,23159,38423,17540,13254,30425,16129,31202,11113,32999,11412,11842,11964,22400,10817,11115,24552,12216,13140,20344,21747,20966,19378,28052,10130,10021,10571,10538,10290,10004,10101,10184,15603,13857,15566,11413,11862,10573,10728,14755,22565,13493,25294,24378,42832,11179,22654,16897,17113,27781,10796,33003,19298,11502,20391,23207,11966,16356,12120,17115,15068,10534,13040,11480,14997,16214,12057,17022,25320,15736,17061,15799,13141,19444,12058,17027,13042,38962,53179,17477,40124,16357,20186,17401,58359,12423,17398,24578,13041,17399,20915,14834,15599,14134,14135,13758,10859,31314,12019,31315,14655,31313,30233,11567,62045,11569,42412,53121,21451,11570,33546,12213,32944,16264,21911,18665,59382,31375,16127,19525,10680,10955,17197,10957,12832,14252,10998,29015,13051,29012,32333,21029,40113,21722,19227,44394,19885,11175,19310,11177,10068,10492,10025,10364,10030,10171,11207,10467,10249,10054,10217,10420,10206,10181,10256,10185,11844,10022,70023,72296,10165,33035,11206,10377,55375,28813,25010,11791,43710,18952,10428,16524,10105,19244,13649,22739,12154,10813,10818,10758,10147,10211,23761,10126,25483,13305,15217,11632,14964,12357,21521,28053,85451,86375,86377,86376,86379,86378,86381,86380,13194,11386,86368,86367,86370,86369,86372,86371,86374,86373,77374,30082,18780,60831,26410,60706,15034,50701,17265,17266,38094,29164,25533,75006,10417,10138,10336,16060,22019,22285,13059,74593,69638,16437,12451,77646,39144,30326,28215,20671,11256,12298,30563,48504,45145,13473,59136,73548,62852,80792,77563,31164,28847,62345,53867,14289,18461,30311,41207,42185,29876,25938,23194,34466,19331,12240,16610,42255,34579,19790,27310,30024,57454,38860,19225,23763,10628,15366,19189,71609,37715,32296,28263,10355,19248,28216,81269,15592,25154,29592,53132,40484,27990,51005,82456,53797,39000,20619,85399,49445,49449,44970,31809,38839,55216,42841,40234,48481,49530,37628,44971,18411,40367,71683,59375,41977,52456,83510,13184,16635,25409,23377,27868,34846,55055,76973,34877,34998,24917,32830,55072,28141,35175,19089,53344,10502,25544,17703,10447,29970,28389,29781,20220,19692,17566,20228,22200,81238,74412,34065,34412,74393,24459,34411,24919,45415,81239,26793,45413,81639,23111,21702,26153,85678,32927,38102,33744,82364,71750,72174,31597,72643,43204,72644,28851,81215,28852,24881,21101,31991,44472,14595,20710,14941,24550,13056,15066,32250,16012,11799,23069,16682,32156,76504,19878,27808,42438,77975,25366,86163,31640,19526,75140,61897,85200,17253,15759,22362,22543,47574,52171,62201,71661,13182,52893,76286,76254,75419,76282,76233,76257,76292,76255,18350,18476,21701,33096,26634,21197,43723,10233,10277,10120,33078,54340,12513,61143,49327,19562,10199,10640,14895,12469,16728,15352,30188,70037,75420,75421,13249,15771,25906,31653,21783,17999,59206,13938,20896,16201,44161,46110,14055,31285,56811,24866,14041,16948,15579,47230,22402,43203,17407,14046,11886,17604,14576,13033,14539,14481,16960,24622,14079,27264,28255,13670,53909,25432,25576,22735,55669,12485,64310,16575,20042,20242,15128,10363,14818,20928,28487,47807,10049,10411,10265,10200,10132,10365,46606,16949,28033,25050,26993,18415,58180,25772,20243,23989,10254,11440,20658,51845,62274,62879,64404,10325,44248,29495,72983,30989,34286,34340,11235,36962,11639,47271,82919,46629,27418,21355,37678,37683,10128,32213,24292,27926,22577,15129,32492,16818,10497,31316,29566,10108,35222,85762,20757,62857,24891,25744,30413,10790,13400,13399,15252,10351,18760,33040,62802,21730,10681,10175,20740,11526,10006,10246,10245,10011,15138,10569,10016,10146,10820,10015,10080,10000,10692,10215,10368,10251,10875,10109,10050,11060,29840,31125,10174,10024,11840,10023,10303,10167,37956,37971,14966,20475,27102,76799,37049,10093,10166,33091,23834,19854,41727,11408,15828,17935,10757,10208,10117,25928,80093,13335,10753,23319,23267,26890,20634,11241,11863,15107,13115,15945,16418,14891,17840,13470,20235,17474,28363,30318,36526,19257,37357,21062,15655,15169,12210,12976,10062,34100,81292,10238,20439,20180,23895,25416,17635,14197,79326,13058,60349,69939,26429,59314,29207,14220,10767,21067,18342,13505,12238,26310,21864,14650,72669,29349,80938,26037,28224,29847,29863,28067,15864,25514,19699,21191,14552,22870,29885,77511,82866,82469,60389,54409,35034,34050,86408,32786,34413,50844,50845,40284,13055,26365,86410,32249,16707,20822,25901,68371,33807,78323,29364,25902,30717,60195,14411,28273,26346,17861,11794,19181,15859,17054,71605,12233,14473,77688,43615,26567,14809,15572,13149,16359,74499,38933,17188,17095,85361,14471,13381,25114,20107,72387,15261,21782,48546,26244,60612,32326,17316,28806,17254,15760,85977,10042,24637,21455,15124,12235,21472,13257,17542,10078,10236,12345,10125,10874,10123,10203,10313,10330,10643,10183,17597,10027,10529,10079,11056,10423,15323,10906,39874,10642,10333,11631,27375,10134,68749,11816,10212,10950,10387,11314,10283,11361,11607,16895,73916,85887,38388,29496,59443,14525,36510,36951,62195,22515,10253,10458,13939,28512,12137,18704,25574,22003,25968,28903,10811,13402,23977,24053,10081,10400,10748,10195,11015,10268,10322,11372,11194,10148,10135,11054,12143,10222,27727,10293,10005,10010,11506,10059,10029,10359,10524,10320,10180,52279,10464,10826,10064,11007,10040,24418,10285,10695,11001,10641,14578,10053,21523,52829,17859,11532,50065,26206,10338,10164,14962,14009,21171,30642,23519,25871,10083,10169,14965,23481,32953,21520,16657,35510,18133,72737,76355,24460,16714,85155,57787,28556,25895,52560,22517,76334,76335,12475,29156,29968,25833,24307,41528,57788,52543,12477,20213,52161,52928,47289,23016,76419,52901,29133,37597,79329,12538,45699,38273,26458,25751,14815,24677,27399,42087,30135,28009,42091,16510,16512,17419,15140,16513,12464,13631,30068,72532,86437,32694,23951,12761,27226,39923,17988,54569,32749,31750,56244,19938,59214,71476,75426,36040,19404,61773,58206,26800,20163,32872,29986,22314,77510,48915,58906,17989,33469,20371,11943,24627,21308,60082,18046,24628,85848,66153,25666,37027,38491,48197,10735,46977,26681,12624,12148,12433,21539,12625,12528,18885,18884,12527,12627,14477,29727,16583,28724,36823,57546,50984,14258,21630,25280,55552,72286,12905,31717,11368,10574,31719,33458,59273,21310,58202,26798,21342,58204,17569,20162,19191,20212,29606,22316,13150,21473,48912,21400,13057,31528,11365,14779,14523,61642,79758,29555,85445,25276,22630,18047,43149,30467,14430,17137,13474,23357,12365,10505,35078,74862,43843,59224,27739,21126,12352,19700,26360,73433,68315,30749,14366,19877,49516,28601,27975,54749,44518,27779,29273,72668,30495,26825,39008,18266,54751,29651,24772,24384,55119,21729,11850,34066,16713,21060,20385,17684,21312,14920,14918,53993,21124,31807,55195,32098,14420,34435,33276,32283,31820,14470,40186,74098,79129,73238,69153,40181,55697,72823,68261,14632,21407,10672,20649,20985,14658,13382,29754,24340,18410,72386,72385,22747,22033,23844,53852,57507,18864,35021,40507,30239,27298,45771,23259,13251,69583,22041,56788,40518,54117,56830,60279,14633,60750,27731,11238,16746,17664,16871,10673,10145,30883,15436,26687,30208,11953,11951,19273,25693,10002,17327,23944,18400,35623,10398,62407,10350,12430,81316,10281,19577,25850,23811,16997,31413,10821,36917,11009,10966,11134,42290,31769,62455,26719,21645,58017,42676,16443,23838,15794,10324,10051,10038,10589,10902,20632,19880,17638,52991,33400,26190,17045,18706,33261,10803,10676,11697,15811,40224,19732,57308,35318,31735,44957,22156,35411,22723,19528,10332,10591,30172,13302,23262,16543,33260,19118,19956,31867,19234,12955,14996,14679,11367,35463,24187,15321,10383,11313,10670,11046,12943,19550,11151,11878,22629,34830,48472,23009,26323,18363,58348,12732,17925,26353,29136,71537,35350,30227,47296,35313,15032,37394,36456,71665,12970,38476,13450,57763,22689,21179,18576,35492,14466,58126,41840,19116,11243,20968,10384,18757,10431,16304,10434,10644,71606,14051,14354,10308,11896,11432,10412,29923,53174,11510,17144,16749,39582,36252,18245,18153,30699,36442,43072,23501,57745,13423,11699,16748,57930,36515,36766,10075,10432,10107,10443,10376,10382,10104,10399,12568,10442,10647,19328,10433,10077,10084,10091,11265,22288,85395,85402,85536,31231,31203,32277,30429,77632,32998,14440,16944,13956,11370,11531,10402,10671,10693,58650,21332,14825,11891,74474,11320,21476,13036,17086,10131,11657,10100,10088,10385,10645,25580,11716,15978,21810,41827,28166,29226,40532,18582,45792,75434,34772,46874,33190,16095,16096,13186,17476,46875,47076,11767,10607,29924,57762,10129,10173,25023,27712,28200,24162,16025,63655,24000,23146,26132,16674,10857,10058,15228,19261,29974,76749,33758,48682,10729,10759,16460,14509,10243,14340,11525,12092,31626,22286,54039,84752,23012,29578,10301,10690,24536,14521,13301,52622,11504,33724,35954,21928,12422,24904,10294,11627,10679,10508,54284,23148,24466,11051,13290,16350,13657,14660,10421,11344,26877,22048,29052,14253,13408,21102,10974,10386,20981,11845,11260,25697,25655,27570,14631,37699,20947,23850,14905,12260,11838,24440,21477,14570,24093,29788,32282,31353,32804,10149,31044,49132,47538,20573,24585,24584,20571,26332,19842,24670,23810,15235,54027,43735,32639,33259,10814,10210,12356,14010,14734,33583,24383,28238,54623,30040,26506,31922,30710,45111,11073,10334,10525,25413,10061,20273,10526,11681,16122,28678,23642,39916,10150,30993,14649,20001,55750,10271,20060,32452,10418,27257,19177,30675,10594,32417,28101,20565,10380,10066,10457,10898,10069,10071,13967,13968,56559,56543,56556,56560,15751,24017,76651,24969,21947,23021,33290,45877,34306,32501,58679,58678,28550,29057,58661,81936,35933,29716,29125,33432,73086,77381,45536,30683,31748,15569,28213,30655,26425,25204,17984,28007,32297,48171,15508,13006,23993,72319,18855,27238,52700,21563,18856,53240,32043,27129,42773,29020,72357,28603,23932,18402,10394,22741,26299,22322,29813,22257,47638) [ RunTime:0.024983s ]
- [ 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' => 1887,
'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 (83936,74681,86041,85746,16230,10223,86059,86047,23804,28715,85963,36615,42355,59968,29731,33504,78784,71396,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,32387,52416,25593,81763,13950,10416,74617,18000,28891,12388,29337,62682,26462,11240,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,30426,31232,22426,18998,15769,44310,20128,15158,21695,48037,25058,49637,15183,14478,82867,62103,83108,74011,71805,66720,62276,28208,16057,86413,52982,71359,13148,18955,25542,26098,22121,18263,31230,31228,17618,17408,32651,50637,33566,25600,32246,18352,20416,10799,39239,11278,49810,21801,22299,18139,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,16893,37840,24222,23777,37624,40043,28185,77402,54959,72610,26393,52848,10682,10140,17195,11414,70269,17543,13544,16202,45241,26274,69270,36995,34897,49388,15263,19099,37975,26866,76232,76256,18917,21291,28199,17351,26754,24708,10267,11680,18322,42181,85619,45435,85574,85463,10375,10808,11407,10317,10648,10683,17773,23263,17838,23246,47193,10749,31199,86155,21737,64221,13873,53025,20792,38530,15111,19993,23456,41430,42664,59453,10613,11024,12886,52780,34649,26752,12361,24523,11428,31225,11527,10177,32373,10734,31200,11528,32278,12018,32525,18938,30384,16655,32229,10860,32954,10127,31227,10535,23159,38423,17540,13254,30425,16129,31202,11113,32999,11412,11842,11964,22400,10817,11115,24552,12216,13140,20344,21747,20966,19378,28052,10130,10021,10571,10538,10290,10004,10101,10184,15603,13857,15566,11413,11862,10573,10728,14755,22565,13493,25294,24378,42832,11179,22654,16897,17113,27781,10796,33003,19298,11502,20391,23207,11966,16356,12120,17115,15068,10534,13040,11480,14997,16214,12057,17022,25320,15736,17061,15799,13141,19444,12058,17027,13042,38962,53179,17477,40124,16357,20186,17401,58359,12423,17398,24578,13041,17399,20915,14834,15599,14134,14135,13758,10859,31314,12019,31315,14655,31313,30233,11567,62045,11569,42412,53121,21451,11570,33546,12213,32944,16264,21911,18665,59382,31375,16127,19525,10680,10955,17197,10957,12832,14252,10998,29015,13051,29012,32333,21029,40113,21722,19227,44394,19885,11175,19310,11177,10068,10492,10025,10364,10030,10171,11207,10467,10249,10054,10217,10420,10206,10181,10256,10185,11844,10022,70023,72296,10165,33035,11206,10377,55375,28813,25010,11791,43710,18952,10428,16524,10105,19244,13649,22739,12154,10813,10818,10758,10147,10211,23761,10126,25483,13305,15217,11632,14964,12357,21521,28053,85451,86375,86377,86376,86379,86378,86381,86380,13194,11386,86368,86367,86370,86369,86372,86371,86374,86373,77374,30082,18780,60831,26410,60706,15034,50701,17265,17266,38094,29164,25533,75006,10417,10138,10336,16060,22019,22285,13059,74593,69638,16437,12451,77646,39144,30326,28215,20671,11256,12298,30563,48504,45145,13473,59136,73548,62852,80792,77563,31164,28847,62345,53867,14289,18461,30311,41207,42185,29876,25938,23194,34466,19331,12240,16610,42255,34579,19790,27310,30024,57454,38860,19225,23763,10628,15366,19189,71609,37715,32296,28263,10355,19248,28216,81269,15592,25154,29592,53132,40484,27990,51005,82456,53797,39000,20619,85399,49445,49449,44970,31809,38839,55216,42841,40234,48481,49530,37628,44971,18411,40367,71683,59375,41977,52456,83510,13184,16635,25409,23377,27868,34846,55055,76973,34877,34998,24917,32830,55072,28141,35175,19089,53344,10502,25544,17703,10447,29970,28389,29781,20220,19692,17566,20228,22200,81238,74412,34065,34412,74393,24459,34411,24919,45415,81239,26793,45413,81639,23111,21702,26153,85678,32927,38102,33744,82364,71750,72174,31597,72643,43204,72644,28851,81215,28852,24881,21101,31991,44472,14595,20710,14941,24550,13056,15066,32250,16012,11799,23069,16682,32156,76504,19878,27808,42438,77975,25366,86163,31640,19526,75140,61897,85200,17253,15759,22362,22543,47574,52171,62201,71661,13182,52893,76286,76254,75419,76282,76233,76257,76292,76255,18350,18476,21701,33096,26634,21197,43723,10233,10277,10120,33078,54340,12513,61143,49327,19562,10199,10640,14895,12469,16728,15352,30188,70037,75420,75421,13249,15771,25906,31653,21783,17999,59206,13938,20896,16201,44161,46110,14055,31285,56811,24866,14041,16948,15579,47230,22402,43203,17407,14046,11886,17604,14576,13033,14539,14481,16960,24622,14079,27264,28255,13670,53909,25432,25576,22735,55669,12485,64310,16575,20042,20242,15128,10363,14818,20928,28487,47807,10049,10411,10265,10200,10132,10365,46606,16949,28033,25050,26993,18415,58180,25772,20243,23989,10254,11440,20658,51845,62274,62879,64404,10325,44248,29495,72983,30989,34286,34340,11235,36962,11639,47271,82919,46629,27418,21355,37678,37683,10128,32213,24292,27926,22577,15129,32492,16818,10497,31316,29566,10108,35222,85762,20757,62857,24891,25744,30413,10790,13400,13399,15252,10351,18760,33040,62802,21730,10681,10175,20740,11526,10006,10246,10245,10011,15138,10569,10016,10146,10820,10015,10080,10000,10692,10215,10368,10251,10875,10109,10050,11060,29840,31125,10174,10024,11840,10023,10303,10167,37956,37971,14966,20475,27102,76799,37049,10093,10166,33091,23834,19854,41727,11408,15828,17935,10757,10208,10117,25928,80093,13335,10753,23319,23267,26890,20634,11241,11863,15107,13115,15945,16418,14891,17840,13470,20235,17474,28363,30318,36526,19257,37357,21062,15655,15169,12210,12976,10062,34100,81292,10238,20439,20180,23895,25416,17635,14197,79326,13058,60349,69939,26429,59314,29207,14220,10767,21067,18342,13505,12238,26310,21864,14650,72669,29349,80938,26037,28224,29847,29863,28067,15864,25514,19699,21191,14552,22870,29885,77511,82866,82469,60389,54409,35034,34050,86408,32786,34413,50844,50845,40284,13055,26365,86410,32249,16707,20822,25901,68371,33807,78323,29364,25902,30717,60195,14411,28273,26346,17861,11794,19181,15859,17054,71605,12233,14473,77688,43615,26567,14809,15572,13149,16359,74499,38933,17188,17095,85361,14471,13381,25114,20107,72387,15261,21782,48546,26244,60612,32326,17316,28806,17254,15760,85977,10042,24637,21455,15124,12235,21472,13257,17542,10078,10236,12345,10125,10874,10123,10203,10313,10330,10643,10183,17597,10027,10529,10079,11056,10423,15323,10906,39874,10642,10333,11631,27375,10134,68749,11816,10212,10950,10387,11314,10283,11361,11607,16895,73916,85887,38388,29496,59443,14525,36510,36951,62195,22515,10253,10458,13939,28512,12137,18704,25574,22003,25968,28903,10811,13402,23977,24053,10081,10400,10748,10195,11015,10268,10322,11372,11194,10148,10135,11054,12143,10222,27727,10293,10005,10010,11506,10059,10029,10359,10524,10320,10180,52279,10464,10826,10064,11007,10040,24418,10285,10695,11001,10641,14578,10053,21523,52829,17859,11532,50065,26206,10338,10164,14962,14009,21171,30642,23519,25871,10083,10169,14965,23481,32953,21520,16657,35510,18133,72737,76355,24460,16714,85155,57787,28556,25895,52560,22517,76334,76335,12475,29156,29968,25833,24307,41528,57788,52543,12477,20213,52161,52928,47289,23016,76419,52901,29133,37597,79329,12538,45699,38273,26458,25751,14815,24677,27399,42087,30135,28009,42091,16510,16512,17419,15140,16513,12464,13631,30068,72532,86437,32694,23951,12761,27226,39923,17988,54569,32749,31750,56244,19938,59214,71476,75426,36040,19404,61773,58206,26800,20163,32872,29986,22314,77510,48915,58906,17989,33469,20371,11943,24627,21308,60082,18046,24628,85848,66153,25666,37027,38491,48197,10735,46977,26681,12624,12148,12433,21539,12625,12528,18885,18884,12527,12627,14477,29727,16583,28724,36823,57546,50984,14258,21630,25280,55552,72286,12905,31717,11368,10574,31719,33458,59273,21310,58202,26798,21342,58204,17569,20162,19191,20212,29606,22316,13150,21473,48912,21400,13057,31528,11365,14779,14523,61642,79758,29555,85445,25276,22630,18047,43149,30467,14430,17137,13474,23357,12365,10505,35078,74862,43843,59224,27739,21126,12352,19700,26360,73433,68315,30749,14366,19877,49516,28601,27975,54749,44518,27779,29273,72668,30495,26825,39008,18266,54751,29651,24772,24384,55119,21729,11850,34066,16713,21060,20385,17684,21312,14920,14918,53993,21124,31807,55195,32098,14420,34435,33276,32283,31820,14470,40186,74098,79129,73238,69153,40181,55697,72823,68261,14632,21407,10672,20649,20985,14658,13382,29754,24340,18410,72386,72385,22747,22033,23844,53852,57507,18864,35021,40507,30239,27298,45771,23259,13251,69583,22041,56788,40518,54117,56830,60279,14633,60750,27731,11238,16746,17664,16871,10673,10145,30883,15436,26687,30208,11953,11951,19273,25693,10002,17327,23944,18400,35623,10398,62407,10350,12430,81316,10281,19577,25850,23811,16997,31413,10821,36917,11009,10966,11134,42290,31769,62455,26719,21645,58017,42676,16443,23838,15794,10324,10051,10038,10589,10902,20632,19880,17638,52991,33400,26190,17045,18706,33261,10803,10676,11697,15811,40224,19732,57308,35318,31735,44957,22156,35411,22723,19528,10332,10591,30172,13302,23262,16543,33260,19118,19956,31867,19234,12955,14996,14679,11367,35463,24187,15321,10383,11313,10670,11046,12943,19550,11151,11878,22629,34830,48472,23009,26323,18363,58348,12732,17925,26353,29136,71537,35350,30227,47296,35313,15032,37394,36456,71665,12970,38476,13450,57763,22689,21179,18576,35492,14466,58126,41840,19116,11243,20968,10384,18757,10431,16304,10434,10644,71606,14051,14354,10308,11896,11432,10412,29923,53174,11510,17144,16749,39582,36252,18245,18153,30699,36442,43072,23501,57745,13423,11699,16748,57930,36515,36766,10075,10432,10107,10443,10376,10382,10104,10399,12568,10442,10647,19328,10433,10077,10084,10091,11265,22288,85395,85402,85536,31231,31203,32277,30429,77632,32998,14440,16944,13956,11370,11531,10402,10671,10693,58650,21332,14825,11891,74474,11320,21476,13036,17086,10131,11657,10100,10088,10385,10645,25580,11716,15978,21810,41827,28166,29226,40532,18582,45792,75434,34772,46874,33190,16095,16096,13186,17476,46875,47076,11767,10607,29924,57762,10129,10173,25023,27712,28200,24162,16025,63655,24000,23146,26132,16674,10857,10058,15228,19261,29974,76749,33758,48682,10729,10759,16460,14509,10243,14340,11525,12092,31626,22286,54039,84752,23012,29578,10301,10690,24536,14521,13301,52622,11504,33724,35954,21928,12422,24904,10294,11627,10679,10508,54284,23148,24466,11051,13290,16350,13657,14660,10421,11344,26877,22048,29052,14253,13408,21102,10974,10386,20981,11845,11260,25697,25655,27570,14631,37699,20947,23850,14905,12260,11838,24440,21477,14570,24093,29788,32282,31353,32804,10149,31044,49132,47538,20573,24585,24584,20571,26332,19842,24670,23810,15235,54027,43735,32639,33259,10814,10210,12356,14010,14734,33583,24383,28238,54623,30040,26506,31922,30710,45111,11073,10334,10525,25413,10061,20273,10526,11681,16122,28678,23642,39916,10150,30993,14649,20001,55750,10271,20060,32452,10418,27257,19177,30675,10594,32417,28101,20565,10380,10066,10457,10898,10069,10071,13967,13968,56559,56543,56556,56560,15751,24017,76651,24969,21947,23021,33290,45877,34306,32501,58679,58678,28550,29057,58661,81936,35933,29716,29125,33432,73086,77381,45536,30683,31748,15569,28213,30655,26425,25204,17984,28007,32297,48171,15508,13006,23993,72319,18855,27238,52700,21563,18856,53240,32043,27129,42773,29020,72357,28603,23932,18402,10394,22741,26299,22322,29813,22257,47638) [ RunTime:0.023193s ]
- [ 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' => 1887,
'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.003203s ]
- [ 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.003087s ]
- [ 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.003220s ]
- [ 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.003518s ]
- [ 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.003296s ]
- [ 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.003127s ]
- [ SQL ] SELECT `id`,`user_nickname` FROM `cmf_user` [ RunTime:0.002954s ]
- [ 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.002878s ]
- [ 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.003048s ]
- [ SQL ] SELECT `tag_id` FROM `cmf_portal_tag_post` WHERE `post_id` = 7417013 [ RunTime:0.003004s ]
- [ 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.003112s ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (3403,3609,3610,3611,3612,3613) [ RunTime:0.002913s ]
- [ 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.002932s ]
- [ 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.002901s ]
- [ 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.002922s ]
- [ 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.002903s ]
- [ 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.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' => 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.002894s ]
- [ 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.002900s ]
- [ 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.003698s ]
- [ 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.002977s ]
- [ 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.002916s ]
- [ 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.002964s ]
- [ 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.002904s ]
- [ 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.002871s ]
- [ 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.003120s ]
- [ 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.002901s ]
- [ 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.002960s ]
- [ 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.002971s ]
- [ 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.002974s ]
- [ 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.003010s ]
- [ 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.003041s ]
- [ 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.003050s ]
- [ 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.003010s ]
- [ 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.003079s ]
- [ 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.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' => 6,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 122 LIMIT 1 [ RunTime:0.002902s ]
- [ 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.003101s ]
- [ 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.003057s ]
- [ 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.002905s ]
- [ 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.002981s ]
- [ 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.003008s ]
- [ 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.002905s ]
- [ 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.002951s ]
- [ 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.002911s ]
- [ 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.002926s ]
- [ 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.002947s ]
- [ 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.003990s ]
- [ 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.004078s ]
- [ 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.003519s ]
- [ 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.002943s ]
- [ 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.003695s ]
- [ 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.003143s ]
- [ 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.003207s ]
- [ 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.002895s ]
- [ 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.002895s ]
- [ 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.002941s ]
- [ 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.003027s ]
- [ 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.003070s ]
- [ 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.002961s ]
- [ 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.002979s ]
- [ 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.002999s ]
- [ 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.003027s ]
- [ 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.002901s ]
- [ 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.002930s ]
- [ 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.003043s ]
- [ 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.003008s ]
- [ 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.002936s ]
- [ 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.002948s ]
- [ 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.002925s ]
- [ 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.004135s ]
- [ 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` > 1730778174 ) ORDER BY `match_time` ASC LIMIT 1000 [ RunTime:0.006140s ]
- [ 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' => 915,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` IN (5,3,277,222,54,35,1360,2244,11,267,435,266,371,264,57,299,76,41,28,26,29,46,17,74,1,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.003950s ]
- [ 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' => 68,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` IN (5,3,277,222,54,35,1360,2244,11,267,435,266,371,264,57,299,76,41,28,26,29,46,17,74,1,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.003691s ]
- [ 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' => 68,
'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 (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,13300,12814,35421,35146,11154,11820,12145,11037,104470,20462,10133,10118,10120,10122,10115,10125,10155,10124,10137,10128,10149,10126,10127,10154,10117,10130,10219,10148,10135,10131,10116,10129,10114,10119,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,13343,13331,12822,13298,12804,11151,11020,12549,35779,11036,12663,15186,11035,10156,10121,10136,10132,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,12877,13381,12835,11026,15217,38711,11946,12895,12824,104786,10134,10123,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,30384,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,12879,19300,10984,104739,12729,40201,16361,10780,12276,30292,14896,29994,10181,10183,32199,32902,38789,104794,12783,11817,104795,30230,12105,13318,12412,13498,12905,12917,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,13317,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,13435,13385,10224,30698,10285,105168,105246,13374,12426,10782,34048,13526,12900,13379,12807,10896,37663,13035,11600,11628,14175,11823,11272,10530,10496,10526,11274,10515,10512,10514,10508,10511,10829,11951) [ RunTime:0.009519s ]
- [ 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' => 847,
'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 (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,13300,12814,35421,35146,11154,11820,12145,11037,104470,20462,10133,10118,10120,10122,10115,10125,10155,10124,10137,10128,10149,10126,10127,10154,10117,10130,10219,10148,10135,10131,10116,10129,10114,10119,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,13343,13331,12822,13298,12804,11151,11020,12549,35779,11036,12663,15186,11035,10156,10121,10136,10132,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,12877,13381,12835,11026,15217,38711,11946,12895,12824,104786,10134,10123,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,30384,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,12879,19300,10984,104739,12729,40201,16361,10780,12276,30292,14896,29994,10181,10183,32199,32902,38789,104794,12783,11817,104795,30230,12105,13318,12412,13498,12905,12917,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,13317,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,13435,13385,10224,30698,10285,105168,105246,13374,12426,10782,34048,13526,12900,13379,12807,10896,37663,13035,11600,11628,14175,11823,11272,10530,10496,10526,11274,10515,10512,10514,10508,10511,10829,11951) [ RunTime:0.009394s ]
- [ 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' => 847,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
1.178423s
