11月05日 星期二
直播节目列表
-
完场
-
待定
-
下半场
-
完场
-
下半场
-
下半场
-
下半场
-
下半场
-
下半场
-
下半场
-
待定
-
下半场
-
未开赛
-
下半场
-
下半场
-
下半场
11月06日 星期三
直播节目列表
-
上半场
-
上半场
-
上半场
-
推迟
-
待定
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
推迟
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
11月07日 星期四
直播节目列表
-
未开赛
-
未开赛
-
推迟
-
未开赛
-
取消
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
11月08日 星期五
直播节目列表
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
11月09日 星期六
直播节目列表
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2024-11-06 00:30:14 HTTP/2.0 GET : https://www.shindq.com/football/yuedanjia
- 运行时间 : 1.161056s [ 吞吐率：0.86req/s ] 内存消耗：1,565.30kb 文件加载：141
- 查询信息 : 154 queries 7 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 (
'referer' => 'https://shindq.com/football/yuedanjia',
'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' => '*/*',
'host' => 'www.shindq.com',
'content-length' => '',
'content-type' => '',
)
- [ PARAM ] array (
'type' => '0',
)
- [ LANG ] /mnt/7kzhanqun/app/portal/lang/zh-cn/home.php
- [ VIEW ] /mnt/7kzhanqun/public/themes/re_sport08/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.004816s ] mysql:host=rm-3ns41jmtlb1g0zd6v.mysql.rds.aliyuncs.com;port=3306;dbname=daxiong;charset=utf8mb4
- [ SQL ] SHOW COLUMNS FROM `cmf_plugin_web` [ RunTime:0.003066s ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.shindq.com%' LIMIT 1 [ RunTime:0.002774s ]
- [ 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 '%www.shindq.com%' LIMIT 1 [ RunTime:0.002809s ]
- [ 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.003004s ]
- [ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Web' AND `site_id` = 11 LIMIT 1 [ RunTime:0.003001s ]
- [ 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 '%www.shindq.com%' LIMIT 1 [ RunTime:0.002742s ]
- [ 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.002998s ]
- [ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'cdn_settings' AND `site_id` = 11 LIMIT 1 [ RunTime:0.002839s ]
- [ 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 '%www.shindq.com%' LIMIT 1 [ RunTime:0.003086s ]
- [ 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 '%www.shindq.com%' LIMIT 1 [ RunTime:0.002815s ]
- [ 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` = 11 LIMIT 1 [ RunTime:0.002871s ]
- [ 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 '%www.shindq.com%' LIMIT 1 [ RunTime:0.002752s ]
- [ 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 '%www.shindq.com%' LIMIT 1 [ RunTime:0.002908s ]
- [ 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` = 11 LIMIT 1 [ RunTime:0.002817s ]
- [ 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.003101s ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` WHERE `status` = 1 [ RunTime:0.004276s ]
- [ 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 '%www.shindq.com%' LIMIT 1 [ RunTime:0.002933s ]
- [ 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` = 11 LIMIT 1 [ RunTime:0.002791s ]
- [ 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.003215s ]
- [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `pinyin` = 'nba' LIMIT 1 [ RunTime:0.004759s ]
- [ 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 '%www.shindq.com%' LIMIT 1 [ RunTime:0.002917s ]
- [ 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` = 11 LIMIT 1 [ RunTime:0.002688s ]
- [ 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.002981s ]
- [ 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 '%www.shindq.com%' LIMIT 1 [ RunTime:0.002881s ]
- [ 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 '%www.shindq.com%' LIMIT 1 [ RunTime:0.002743s ]
- [ 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.002962s ]
- [ SQL ] SELECT `name`,`href` FROM `cmf_nav_menu` WHERE `nav_id` = 1 AND `parent_id` = 0 AND `status` = 1 AND `site_id` = 11 [ RunTime:0.003037s ]
- [ 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 '%www.shindq.com%' LIMIT 1 [ RunTime:0.002858s ]
- [ 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.003179s ]
- [ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `competition_id` = 1 AND `com_type` = 0 AND `match_time` > 1730824214 LIMIT 100 [ RunTime:0.005498s ]
- [ 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.897521018981934,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_nami_teams` [ RunTime:0.003183s ]
- [ SQL ] SELECT `short_name_zh` FROM `cmf_nami_teams` WHERE `cid` IN ('') AND `com_type` = 0 [ RunTime:0.002878s ]
- [ 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.003010s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 're_sport08' AND `file` = 'portal/article' LIMIT 1 [ RunTime:0.003028s ]
- [ 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` = 're_sport08' , `action` = 'portal/Article/index' , `file` = 'portal/article' , `name` = '资讯详情页' , `more` = '[]' , `config_more` = '[]' , `description` = '资讯详情页模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 're_sport08' AND `file` = 'portal/article' [ RunTime:0.003232s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 're_sport08' AND `file` = 'portal/competition' LIMIT 1 [ RunTime:0.002960s ]
- [ 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` = 're_sport08' , `action` = 'portal/Competition/index' , `file` = 'portal/competition' , `name` = '赛程列表页' , `more` = '{\"vars\":[]}' , `config_more` = '{\"vars\":[]}' , `description` = '赛程列表模板文件' , `is_public` = 0 , `list_order` = 0 WHERE `theme` = 're_sport08' AND `file` = 'portal/competition' [ RunTime:0.003308s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 're_sport08' AND `file` = 'portal/index' LIMIT 1 [ RunTime:0.002963s ]
- [ 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` = 're_sport08' , `action` = 'portal/Index/index' , `file` = 'portal/index' , `name` = '首页' , `more` = '{\"vars\":[]}' , `config_more` = '{\"vars\":[]}' , `description` = '首页模板文件' , `is_public` = 0 , `list_order` = 0 WHERE `theme` = 're_sport08' AND `file` = 'portal/index' [ RunTime:0.003090s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 're_sport08' AND `file` = 'portal/list' LIMIT 1 [ RunTime:0.002992s ]
- [ 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` = 're_sport08' , `action` = 'portal/List/index' , `file` = 'portal/list' , `name` = '资讯列表页' , `more` = '[]' , `config_more` = '[]' , `description` = '资讯列表模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 're_sport08' AND `file` = 'portal/list' [ RunTime:0.003127s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 're_sport08' AND `file` = 'portal/match' LIMIT 1 [ RunTime:0.002981s ]
- [ 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` = 're_sport08' , `action` = 'portal/Match/index' , `file` = 'portal/match' , `name` = '赛事详情页' , `more` = '{\"vars\":[]}' , `config_more` = '{\"vars\":[]}' , `description` = '赛事详情页模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 're_sport08' AND `file` = 'portal/match' [ RunTime:0.003303s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 're_sport08' AND `file` = 'portal/tag' LIMIT 1 [ RunTime:0.002968s ]
- [ 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` = 're_sport08' , `action` = 'portal/Tag/index' , `file` = 'portal/tag' , `name` = '文章标签页' , `more` = '{\"vars\":[]}' , `config_more` = '{\"vars\":[]}' , `description` = '文章标签模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 're_sport08' AND `file` = 'portal/tag' [ RunTime:0.003089s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 're_sport08' [ RunTime:0.003028s ]
- [ 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.003009s ]
- [ SQL ] UPDATE `cmf_theme` SET `name` = '7k_shenfupay' , `version` = '1.0.2' , `demo_url` = 'https://shenfupay.com' , `author` = '1408' , `lang` = 'zh-cn' , `author_url` = '' , `keywords` = '7k_shenfupay' , `description` = '7k_shenfupay' WHERE `theme` = 're_sport08' [ RunTime:0.002907s ]
- [ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = 're_sport08' AND ( `is_public` = 1 OR `file` = 'portal/competition' ) [ RunTime:0.003216s ]
- [ 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 '%www.shindq.com%' LIMIT 1 [ RunTime:0.002935s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'storage' AND `site_id` = 11 LIMIT 1 [ RunTime:0.002977s ]
- [ 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 '%www.shindq.com%' LIMIT 1 [ RunTime:0.003077s ]
- [ 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` = 11 LIMIT 1 [ RunTime:0.002821s ]
- [ 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 '%www.shindq.com%' LIMIT 1 [ RunTime:0.003059s ]
- [ 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 '%www.shindq.com%' LIMIT 1 [ RunTime:0.002867s ]
- [ 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.002989s ]
- [ SQL ] SELECT `id` FROM `cmf_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.002795s ]
- [ 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` = 11 AND `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.003063s ]
- [ 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 '%www.shindq.com%' LIMIT 1 [ RunTime:0.002927s ]
- [ 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_nami_competitions WHERE id IN (70, 2419, 588, 32, 122, 112, 136, 100, 33, 530, 529, 589, 623, 640) ORDER BY FIELD(id, 70, 2419, 588, 32, 122, 112, 136, 100, 33, 530, 529, 589, 623, 640) limit 6 [ RunTime:0.003241s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_competitions',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '4',
'ref' => NULL,
'rows' => 14,
'filtered' => 100.0,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.shindq.com%' LIMIT 1 [ RunTime:0.002881s ]
- [ 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.002793s ]
- [ 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` = 11 AND `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.003147s ]
- [ 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 * FROM cmf_nami_competitions WHERE id IN (70, 2419, 588, 32, 122, 112, 136, 100, 33, 530, 529, 589, 623, 640) ORDER BY FIELD(id, 70, 2419, 588, 32, 122, 112, 136, 100, 33, 530, 529, 589, 623, 640) limit 6 [ RunTime:0.003800s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_competitions',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '4',
'ref' => NULL,
'rows' => 14,
'filtered' => 100.0,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT * FROM cmf_nami_competitions WHERE id IN (70, 2419, 588, 32, 122, 112, 136, 100, 33, 530, 529, 589, 623, 640) ORDER BY FIELD(id, 70, 2419, 588, 32, 122, 112, 136, 100, 33, 530, 529, 589, 623, 640) limit 20 [ RunTime:0.015876s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_competitions',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '4',
'ref' => NULL,
'rows' => 14,
'filtered' => 100.0,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `cid` FROM `cmf_nami_competitions` WHERE `pinyin` = 'all' AND `com_type` = 0 LIMIT 1 [ RunTime:0.004231s ]
- [ 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` > 1730813414 ) ORDER BY `match_time` ASC LIMIT 1000 [ RunTime:0.006409s ]
- [ 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' => 14952,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` IN (1863,728,1357,97,6736,656,77,264,387,34,1749,1775,1699,615,512,271,59,3527,2915,277,349,3032,243,2725,6737,1719,641,54,3185,133,347,716,7180,46,132,125,2101,978,1726,1881,194,2104,2000,3375,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,3322,3394,3474,3393,1842,579,1689,1687,2959,324,1815,675,1666,7196,1851,1799,682,1927,1915,1885,263,1788,374,1841,3316,7186,3489,1819,3264,2166,671,260,337,1745,370,360,214,1668,1671,1709,1710,684,1708,2064,388,3081,332,47,664,300,128,359,3284,342,375,2040,3403,226,456,164,1677,483,488,674,3075,350,616,1723,1902,614,3265,1796,730,1674,642,1785,1679,217,246,1907,376,108,1759,489,699,602,590,255,241,371,297,368,351,660,659,628,838,1667,348,1704,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,586,3073,545,1746,581,688,1748) [ RunTime:0.005661s ]
- [ 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' => 249,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` IN (1863,728,1357,97,6736,656,77,264,387,34,1749,1775,1699,615,512,271,59,3527,2915,277,349,3032,243,2725,6737,1719,641,54,3185,133,347,716,7180,46,132,125,2101,978,1726,1881,194,2104,2000,3375,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,3322,3394,3474,3393,1842,579,1689,1687,2959,324,1815,675,1666,7196,1851,1799,682,1927,1915,1885,263,1788,374,1841,3316,7186,3489,1819,3264,2166,671,260,337,1745,370,360,214,1668,1671,1709,1710,684,1708,2064,388,3081,332,47,664,300,128,359,3284,342,375,2040,3403,226,456,164,1677,483,488,674,3075,350,616,1723,1902,614,3265,1796,730,1674,642,1785,1679,217,246,1907,376,108,1759,489,699,602,590,255,241,371,297,368,351,660,659,628,838,1667,348,1704,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,586,3073,545,1746,581,688,1748) [ RunTime:0.004506s ]
- [ 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' => 249,
'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 (52982,71359,25542,26098,22121,18263,37528,49959,31230,31228,17618,17408,32651,50637,33566,25600,32246,18352,20416,10799,39239,11278,49810,21801,22299,18139,10894,22061,28004,48868,49254,33773,18269,21194,34576,47925,13148,18955,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,23823,37719,45241,26274,69270,36995,15263,19099,37975,26866,76232,76256,18917,21291,28199,17351,50783,50929,26754,24708,10267,11680,18322,42181,85619,45435,85574,85463,10375,10808,11407,10317,10648,10683,17773,23263,13544,16202,17838,23246,47193,10749,31199,86155,31639,31031,29137,20768,21737,64221,13873,53025,20792,38530,15111,19993,41891,30539,23456,41430,42664,59453,10613,11024,52780,12886,34649,26752,12361,24523,11428,31225,11527,10177,32373,32987,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,44695,11529,19312,58547,21030,19219,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,72349,12211,13194,11386,81769,81770,86368,86367,86370,86369,86372,86371,86374,86373,83092,74012,86135,73411,78120,85518,77374,30082,18780,60831,26410,60706,15034,50701,17265,17266,38094,29164,59799,38133,30545,30850,30546,32645,30139,30583,84222,83824,84221,84098,84099,83823,69715,69707,25533,75006,14035,28953,10417,10138,10336,16060,22019,22285,69638,16437,12451,77646,85985,86045,65962,74524,73272,73368,39144,30326,28215,20671,11256,12298,30563,48504,45145,13473,13059,74593,59136,73548,62852,80792,13472,16948,26084,13938,77563,31164,28847,62345,24864,39258,86011,86441,53867,14289,18461,30311,41207,42185,29876,25938,23194,34466,19331,12240,16610,42255,34579,19790,27310,30024,57454,38860,19225,23763,10628,15366,17703,10447,29970,28389,29781,20220,20228,22200,33517,28229,26369,45302,78708,78827,85896,86258,22927,17777,19189,71609,37715,32296,28263,10355,19248,28216,81269,86413,48350,43712,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,19692,17566,81238,74412,34065,34412,74393,24459,34411,24919,45415,81239,26793,45413,81639,23111,73958,73954,21702,26153,85678,32927,38102,33744,82364,71750,72174,31597,72643,43204,72644,28851,81215,28852,49347,58666,50144,53152,11476,72258,30305,38528,37068,44667,37696,39222,38688,33662,37655,29389,31006,30190,24571,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,69827,37973,11410,32262,17253,15759,22362,22543,47574,52171,62201,71661,13182,52893,76286,76254,75419,76282,76233,76257,76292,76255,18350,18476,21701,33096,26634,21197,56812,56814,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,20896,16201,44161,46110,14055,31285,56811,24866,14041,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,58617,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,17009,22297,22427,19409,20213,52161,52928,47289,23016,76419,52901,29133,37597,79329,12538,45699,38263,12780,29339,38273,22014,81763,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,74617,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,23937,27793,18773,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,31232,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,10908,10526,11681,16122,28678,23642,39916,10150,30993,14649,20001,55750,10271,20060,32452,10418,27257,19177,30675,10594,32417,28101,20565,28715,23804,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,54684,19553,38355,60575,21685,30202,21426,38512,23226,27369,18407,19742,17987,15332,52862) [ RunTime:0.028771s ]
- [ 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' => 1909,
'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 (52982,71359,25542,26098,22121,18263,37528,49959,31230,31228,17618,17408,32651,50637,33566,25600,32246,18352,20416,10799,39239,11278,49810,21801,22299,18139,10894,22061,28004,48868,49254,33773,18269,21194,34576,47925,13148,18955,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,23823,37719,45241,26274,69270,36995,15263,19099,37975,26866,76232,76256,18917,21291,28199,17351,50783,50929,26754,24708,10267,11680,18322,42181,85619,45435,85574,85463,10375,10808,11407,10317,10648,10683,17773,23263,13544,16202,17838,23246,47193,10749,31199,86155,31639,31031,29137,20768,21737,64221,13873,53025,20792,38530,15111,19993,41891,30539,23456,41430,42664,59453,10613,11024,52780,12886,34649,26752,12361,24523,11428,31225,11527,10177,32373,32987,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,44695,11529,19312,58547,21030,19219,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,72349,12211,13194,11386,81769,81770,86368,86367,86370,86369,86372,86371,86374,86373,83092,74012,86135,73411,78120,85518,77374,30082,18780,60831,26410,60706,15034,50701,17265,17266,38094,29164,59799,38133,30545,30850,30546,32645,30139,30583,84222,83824,84221,84098,84099,83823,69715,69707,25533,75006,14035,28953,10417,10138,10336,16060,22019,22285,69638,16437,12451,77646,85985,86045,65962,74524,73272,73368,39144,30326,28215,20671,11256,12298,30563,48504,45145,13473,13059,74593,59136,73548,62852,80792,13472,16948,26084,13938,77563,31164,28847,62345,24864,39258,86011,86441,53867,14289,18461,30311,41207,42185,29876,25938,23194,34466,19331,12240,16610,42255,34579,19790,27310,30024,57454,38860,19225,23763,10628,15366,17703,10447,29970,28389,29781,20220,20228,22200,33517,28229,26369,45302,78708,78827,85896,86258,22927,17777,19189,71609,37715,32296,28263,10355,19248,28216,81269,86413,48350,43712,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,19692,17566,81238,74412,34065,34412,74393,24459,34411,24919,45415,81239,26793,45413,81639,23111,73958,73954,21702,26153,85678,32927,38102,33744,82364,71750,72174,31597,72643,43204,72644,28851,81215,28852,49347,58666,50144,53152,11476,72258,30305,38528,37068,44667,37696,39222,38688,33662,37655,29389,31006,30190,24571,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,69827,37973,11410,32262,17253,15759,22362,22543,47574,52171,62201,71661,13182,52893,76286,76254,75419,76282,76233,76257,76292,76255,18350,18476,21701,33096,26634,21197,56812,56814,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,20896,16201,44161,46110,14055,31285,56811,24866,14041,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,58617,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,17009,22297,22427,19409,20213,52161,52928,47289,23016,76419,52901,29133,37597,79329,12538,45699,38263,12780,29339,38273,22014,81763,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,74617,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,23937,27793,18773,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,31232,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,10908,10526,11681,16122,28678,23642,39916,10150,30993,14649,20001,55750,10271,20060,32452,10418,27257,19177,30675,10594,32417,28101,20565,28715,23804,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,54684,19553,38355,60575,21685,30202,21426,38512,23226,27369,18407,19742,17987,15332,52862) [ RunTime:0.023408s ]
- [ 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' => 1909,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.shindq.com%' LIMIT 1 [ RunTime:0.003224s ]
- [ 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` = 92 [ RunTime:0.003738s ]
- [ 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.004063s ]
- [ SQL ] SELECT * FROM `cmf_portal_post` `post` WHERE `site_id` = 11 AND `post_status` = 1 AND `post_type` = 1 AND `delete_time` = 0 AND ( `category_id` = 92 ) ORDER BY `published_time` DESC LIMIT 0,10 [ RunTime:0.003752s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'type_status_date,category_id,idx_siteid_deletetime_posttype_poststatus_publishedtime,idx_8f8efa778253e4a38b4800acfaedd014',
'key' => 'category_id',
'key_len' => '14',
'ref' => 'const,const,const,const',
'rows' => 126,
'filtered' => 0.0396825410425663,
'extra' => 'Using index condition; Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.003110s ]
- [ 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.002961s ]
- [ SQL ] SELECT `id`,`user_nickname` FROM `cmf_user` [ RunTime:0.002775s ]
- [ 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.002722s ]
- [ 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.002920s ]
- [ SQL ] SELECT `tag_id` FROM `cmf_portal_tag_post` WHERE `post_id` = 7417008 [ RunTime:0.002804s ]
- [ 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.002979s ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (2745,2746,2747,2748,2749,2750) [ RunTime:0.002787s ]
- [ 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` = 92 LIMIT 1 [ RunTime:0.002725s ]
- [ 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` = 7416858 [ RunTime:0.004325s ]
- [ 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 (3021,3022,3023,3024,3025,3026,3027,3028) [ RunTime:0.002826s ]
- [ 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` = 92 LIMIT 1 [ RunTime:0.003385s ]
- [ 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` = 7416584 [ RunTime:0.003203s ]
- [ 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 (3021,3022,3023,3024,3025,3026,3027,3028) [ RunTime:0.003824s ]
- [ 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` = 92 LIMIT 1 [ RunTime:0.009531s ]
- [ 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` = 7416352 [ RunTime:0.002908s ]
- [ 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 (3262,8014,8015,60220,8017,8018,8019) [ RunTime:0.002809s ]
- [ 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` = 92 LIMIT 1 [ RunTime:0.002897s ]
- [ 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` = 7416122 [ RunTime:0.002826s ]
- [ 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 (3262,8014,8015,60220,8017,8018,8019) [ RunTime:0.002811s ]
- [ 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` = 92 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` = 7415889 [ RunTime:0.002902s ]
- [ 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 (2936,2937,2938,2939,2940,2941) [ RunTime:0.002802s ]
- [ 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` = 92 LIMIT 1 [ RunTime:0.002776s ]
- [ 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` = 7415653 [ RunTime:0.002768s ]
- [ 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 (59631,59632,59633,59634,59635) [ RunTime:0.002885s ]
- [ 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` = 92 LIMIT 1 [ RunTime:0.002772s ]
- [ 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` = 7415387 [ RunTime:0.002761s ]
- [ 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 (2745,2746,2747,2748,2749,2750) [ RunTime:0.003532s ]
- [ 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` = 92 LIMIT 1 [ RunTime:0.004453s ]
- [ 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` = 6896942 [ RunTime:0.003372s ]
- [ 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 (2745,2746,2747,2748,2749,2750) [ RunTime:0.002945s ]
- [ 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` = 92 LIMIT 1 [ RunTime:0.002836s ]
- [ 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` = 6306314 [ RunTime:0.004012s ]
- [ 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 (2739,2740,32465,32466,2742,32467) [ RunTime:0.002809s ]
- [ 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` = 92 LIMIT 1 [ RunTime:0.002730s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.shindq.com%' LIMIT 1 [ RunTime:0.002818s ]
- [ 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` = 93 [ RunTime:0.002944s ]
- [ 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 * FROM `cmf_portal_post` `post` WHERE `site_id` = 11 AND `post_status` = 1 AND `post_type` = 1 AND `delete_time` = 0 AND ( `category_id` = 93 ) ORDER BY `published_time` DESC LIMIT 0,10 [ RunTime:0.003064s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'type_status_date,category_id,idx_siteid_deletetime_posttype_poststatus_publishedtime,idx_8f8efa778253e4a38b4800acfaedd014',
'key' => 'category_id',
'key_len' => '14',
'ref' => 'const,const,const,const',
'rows' => 1,
'filtered' => 5.0,
'extra' => 'Using index condition; Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.003136s ]
- [ 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 ] SELECT `id`,`user_nickname` FROM `cmf_user` [ RunTime:0.003002s ]
- [ 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.002824s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_user',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 2,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `tag_id` FROM `cmf_portal_tag_post` WHERE `post_id` = 5413824 [ RunTime:0.002809s ]
- [ 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 (3412,56825,56826,56827,56828) [ RunTime:0.004164s ]
- [ 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` = 93 LIMIT 1 [ RunTime:0.003355s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.shindq.com%' LIMIT 1 [ RunTime:0.003824s ]
- [ 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` = 94 [ RunTime:0.002966s ]
- [ 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 * FROM `cmf_portal_post` `post` WHERE `site_id` = 11 AND `post_status` = 1 AND `post_type` = 1 AND `delete_time` = 0 AND ( `category_id` IN (94,95,96) ) ORDER BY `published_time` DESC LIMIT 0,10 [ RunTime:0.003239s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'type_status_date,category_id,idx_siteid_deletetime_posttype_poststatus_publishedtime,idx_8f8efa778253e4a38b4800acfaedd014',
'key' => 'idx_siteid_deletetime_posttype_poststatus_publishedtime',
'key_len' => '11',
'ref' => 'const,const,const,const',
'rows' => 105752,
'filtered' => 30.000001907348633,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.003064s ]
- [ 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 ] SELECT `id`,`user_nickname` FROM `cmf_user` [ RunTime:0.002834s ]
- [ 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.002706s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_user',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 2,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `tag_id` FROM `cmf_portal_tag_post` WHERE `post_id` = 7415302 [ RunTime:0.002779s ]
- [ 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 (3262,5095,4053,3265,3266) [ RunTime:0.002885s ]
- [ 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` = 94 LIMIT 1 [ RunTime:0.002796s ]
- [ 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` = 7415163 [ RunTime:0.002776s ]
- [ 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 (3262,3394,9445,3265,3266) [ RunTime:0.002786s ]
- [ 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` = 94 LIMIT 1 [ RunTime:0.002780s ]
- [ 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` = 7415024 [ RunTime:0.002771s ]
- [ 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 (3021,6468,4078,3265,3266) [ RunTime:0.002898s ]
- [ 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` = 94 LIMIT 1 [ RunTime:0.003962s ]
- [ 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` = 7414885 [ RunTime:0.003484s ]
- [ 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 (3412,3413,9847,4756,3265) [ RunTime:0.003140s ]
- [ 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` = 94 LIMIT 1 [ RunTime:0.004450s ]
- [ 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` = 7414746 [ RunTime:0.002858s ]
- [ 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 (3412,3413,3265) [ RunTime:0.002817s ]
- [ 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` = 94 LIMIT 1 [ RunTime:0.002835s ]
- [ 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` = 7414607 [ RunTime:0.002711s ]
- [ 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 (3262,3394,9445,3265,3266) [ RunTime:0.002837s ]
- [ 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` = 94 LIMIT 1 [ RunTime:0.002766s ]
- [ 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` = 7414468 [ RunTime:0.002998s ]
- [ 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 (3262,3394,9445,3265,3266) [ 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' => 5,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 94 LIMIT 1 [ RunTime:0.002824s ]
- [ 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` = 7414329 [ RunTime:0.003007s ]
- [ 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 (3711,5412,9965,3265,3266) [ RunTime:0.002888s ]
- [ 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` = 94 LIMIT 1 [ RunTime:0.002816s ]
- [ 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` = 7414190 [ 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' => 4,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (3412,3413,3265,25188) [ RunTime:0.004126s ]
- [ 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` = 94 LIMIT 1 [ RunTime:0.002922s ]
- [ 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` = 7414051 [ RunTime:0.003390s ]
- [ 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 (3412,3413,4002,4755,3265) [ RunTime:0.002823s ]
- [ 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` = 94 LIMIT 1 [ RunTime:0.002820s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.shindq.com%' LIMIT 1 [ RunTime:0.002854s ]
- [ 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_portal_tag` WHERE `site_id` = 11 AND `status` = 1 LIMIT 50 [ RunTime:0.003666s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 58795,
'filtered' => 1.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.shindq.com%' LIMIT 1 [ RunTime:0.002829s ]
- [ 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_link` [ RunTime:0.003030s ]
- [ SQL ] SELECT * FROM `cmf_link` WHERE `status` = 1 AND `site_id` = 11 ORDER BY `list_order` ASC [ RunTime:0.002853s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_link',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => 'status',
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 7,
'filtered' => 14.285713195800781,
'extra' => 'Using where; Using filesort',
) ]
1.162953s
