11月05日 星期二
直播节目列表
-
完场
-
下半场
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
推迟
-
未开赛
11月06日 星期三
直播节目列表
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
待定
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
11月07日 星期四
直播节目列表
-
未开赛
-
未开赛
-
推迟
-
未开赛
-
取消
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
11月08日 星期五
直播节目列表
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
11月09日 星期六
直播节目列表
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
-
未开赛
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2024-11-05 11:48:46 HTTP/2.0 GET : https://www.shindq.com/football/jianalian
- 运行时间 : 1.131591s [ 吞吐率：0.88req/s ] 内存消耗：1,561.23kb 文件加载：141
- 查询信息 : 150 queries 7 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 (
'referer' => 'https://shindq.com/football/jianalian',
'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.018950s ] mysql:host=rm-3ns41jmtlb1g0zd6v.mysql.rds.aliyuncs.com;port=3306;dbname=daxiong;charset=utf8mb4
- [ SQL ] SHOW COLUMNS FROM `cmf_plugin_web` [ RunTime:0.017840s ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.shindq.com%' LIMIT 1 [ RunTime:0.011256s ]
- [ 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.002819s ]
- [ 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.012662s ]
- [ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Web' AND `site_id` = 11 LIMIT 1 [ RunTime:0.002645s ]
- [ 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.002550s ]
- [ 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.002793s ]
- [ 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.002575s ]
- [ 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.002499s ]
- [ 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.002668s ]
- [ 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.002940s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.003642s ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` WHERE `status` = 1 [ RunTime:0.004140s ]
- [ 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.002532s ]
- [ 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.003478s ]
- [ 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.003070s ]
- [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `pinyin` = 'nba' LIMIT 1 [ RunTime:0.004663s ]
- [ 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.002928s ]
- [ 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.002818s ]
- [ 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.002809s ]
- [ 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.002580s ]
- [ 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.002634s ]
- [ 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.002808s ]
- [ 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.002800s ]
- [ 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.002589s ]
- [ 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.003192s ]
- [ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `competition_id` = 1 AND `com_type` = 0 AND `match_time` > 1730778526 LIMIT 100 [ RunTime:0.008309s ]
- [ 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.975234985351562,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_nami_teams` [ RunTime:0.002962s ]
- [ SQL ] SELECT `short_name_zh` FROM `cmf_nami_teams` WHERE `cid` IN ('') AND `com_type` = 0 [ RunTime:0.002639s ]
- [ 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.002844s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 're_sport08' AND `file` = 'portal/article' LIMIT 1 [ RunTime:0.002784s ]
- [ 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.005933s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 're_sport08' AND `file` = 'portal/competition' LIMIT 1 [ RunTime:0.002943s ]
- [ 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.003022s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 're_sport08' AND `file` = 'portal/index' LIMIT 1 [ RunTime:0.003140s ]
- [ 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.004196s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 're_sport08' AND `file` = 'portal/list' LIMIT 1 [ RunTime:0.002883s ]
- [ 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.002869s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 're_sport08' AND `file` = 'portal/match' LIMIT 1 [ RunTime:0.002729s ]
- [ 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.003039s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 're_sport08' AND `file` = 'portal/tag' LIMIT 1 [ RunTime:0.002702s ]
- [ 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.002916s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 're_sport08' [ RunTime:0.002999s ]
- [ 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.003004s ]
- [ 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.003006s ]
- [ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = 're_sport08' AND ( `is_public` = 1 OR `file` = 'portal/competition' ) [ RunTime:0.002851s ]
- [ 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.003128s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.shindq.com%' LIMIT 1 [ RunTime:0.003536s ]
- [ 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.002813s ]
- [ 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.002786s ]
- [ 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.003501s ]
- [ 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.004046s ]
- [ SQL ] SELECT `id` FROM `cmf_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.002529s ]
- [ 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.003232s ]
- [ 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.002473s ]
- [ 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.002981s ]
- [ 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.002714s ]
- [ 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.002589s ]
- [ 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.002844s ]
- [ 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.002996s ]
- [ 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.004390s ]
- [ 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.004073s ]
- [ 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` > 1730767726 ) ORDER BY `match_time` ASC LIMIT 1000 [ RunTime:0.006707s ]
- [ 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 (475,2181,1806,6736,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,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.006194s ]
- [ 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' => 238,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` IN (475,2181,1806,6736,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,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.004435s ]
- [ 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' => 238,
'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 (14966,12356,44277,29099,86041,85746,16230,10223,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,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,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.025658s ]
- [ 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' => 1885,
'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 (14966,12356,44277,29099,86041,85746,16230,10223,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,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,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.026126s ]
- [ 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' => 1885,
'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.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 `id` FROM `cmf_portal_category` WHERE `parent_id` = 92 [ RunTime:0.002958s ]
- [ 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.003019s ]
- [ 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.003357s ]
- [ 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.003025s ]
- [ 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.002842s ]
- [ SQL ] SELECT `id`,`user_nickname` FROM `cmf_user` [ RunTime:0.002762s ]
- [ 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.002843s ]
- [ 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.002724s ]
- [ SQL ] SELECT `tag_id` FROM `cmf_portal_tag_post` WHERE `post_id` = 7417008 [ RunTime:0.002717s ]
- [ 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.002777s ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (2745,2746,2747,2748,2749,2750) [ RunTime:0.002659s ]
- [ 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.002856s ]
- [ 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.005039s ]
- [ 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.002577s ]
- [ 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.002672s ]
- [ 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.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' => 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.002640s ]
- [ 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.002666s ]
- [ 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.004888s ]
- [ 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.002545s ]
- [ 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.002578s ]
- [ 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.002646s ]
- [ 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.002634s ]
- [ 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.002646s ]
- [ 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.002843s ]
- [ 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.002651s ]
- [ 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.002602s ]
- [ 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.002574s ]
- [ 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.002699s ]
- [ 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.002740s ]
- [ 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.002606s ]
- [ 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.002590s ]
- [ 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.002687s ]
- [ 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.002631s ]
- [ 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.002642s ]
- [ 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.002634s ]
- [ 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.002604s ]
- [ 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.003672s ]
- [ 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.002631s ]
- [ 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.002641s ]
- [ 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.002658s ]
- [ 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.002859s ]
- [ 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.003138s ]
- [ 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.002604s ]
- [ 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.002595s ]
- [ 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.002643s ]
- [ 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.002609s ]
- [ 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.002552s ]
- [ 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.002558s ]
- [ 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.003022s ]
- [ 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.002930s ]
- [ 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.002844s ]
- [ 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.003078s ]
- [ 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.002613s ]
- [ 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.003028s ]
- [ 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.002565s ]
- [ 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.002607s ]
- [ 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.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' => 5,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (3262,3394,9445,3265,3266) [ RunTime:0.002877s ]
- [ 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.002506s ]
- [ 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.002723s ]
- [ 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.002727s ]
- [ 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.002566s ]
- [ 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.002667s ]
- [ 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.002539s ]
- [ 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.002600s ]
- [ 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.003047s ]
- [ 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.002670s ]
- [ 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.002689s ]
- [ 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.004517s ]
- [ 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.002519s ]
- [ 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.002704s ]
- [ 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.002639s ]
- [ 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.002596s ]
- [ 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.002581s ]
- [ 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.002532s ]
- [ 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.002652s ]
- [ 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.002603s ]
- [ 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.005171s ]
- [ 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.002655s ]
- [ 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.002486s ]
- [ 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.002589s ]
- [ 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.002561s ]
- [ 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.002587s ]
- [ 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.002461s ]
- [ 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.003335s ]
- [ 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.002570s ]
- [ 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.002814s ]
- [ SQL ] SELECT * FROM `cmf_link` WHERE `status` = 1 AND `site_id` = 11 ORDER BY `list_order` ASC [ RunTime:0.002642s ]
- [ 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.133688s
