09:45
完场
斯派里特
vs
塞尔温联合
09:54
完场
北卡罗来纳大学教堂山分校
vs
阿拉巴马大学
10:00
完场
伯肯黑德联
vs
西海岸游骑兵
10:00
完场
奥林匹克湾
vs
东海岸的海湾
10:00
完场
马努雷瓦
vs
西斯普林斯
10:00
完场
奥克兰城
vs
奥克郊区
10:00
完场
朱蒂亚帕
vs
纽瓦罗莎CDF
10:00
完场
阿瓜卡连特快船
vs
G联盟引爆者
10:14
完场
爱荷华州立
vs
伊利诺伊大学
11:00
完场
蒙特雷女足
vs
蒂华纳女足
11:00
完场
伊斯特恩狮队
vs
博马里斯
11:05
完场
多拉多斯
vs
亚特兰特
12:00
未开赛
NCAATeam
vs
NCAATeam
12:00
未开赛
NCAATeam
vs
NCAATeam
12:00
未开赛
NCAATeam
vs
NCAATeam
12:00
未开赛
NCAATeam
vs
NCAATeam
00:00
未开赛
巴蒂卡青年队
vs
克拉斯诺达尔青年队
00:00
未开赛
威灵
vs
多佛
00:00
未开赛
哈迪亚霍萨纳
vs
汉伯里科杜拉梅
00:00
未开赛
巴提加B队
vs
考纳斯
00:00
未开赛
卡努扎吉里斯B队
vs
尼维斯
00:00
未开赛
斯奥利艾B队
vs
FK海王星克莱佩达
00:00
未开赛
克尔赫提
vs
泰拉维
00:00
未开赛
波罗尼
vs
科马尔诺
00:00
未开赛
布列斯特迪纳摩
vs
斯莫根
00:00
未开赛
赫拉尼斯
vs
TJ塔特拉
00:00
未开赛
多瑞那
vs
艾斯哥比度
00:00
未开赛
尤铁尔
vs
奥丁恩
00:00
未开赛
菲拉尼特斯
vs
桑塔尼
00:00
未开赛
马萨特兰U23
vs
蒂华纳U23
00:00
未开赛
大猩猩FC
vs
卢旺达警察
00:15
未开赛
威尔伯福斯
vs
老爱德华时代
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2024-03-29 13:33:00 HTTP/2.0 GET : https://www.mooktool.com/
- 运行时间 : 1.063546s [ 吞吐率:0.94req/s ] 内存消耗:6,007.82kb 文件加载:142
- 查询信息 : 204 queries 7 writes
- 缓存信息 : 7 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 (
)
- [ HEADER ] array (
'referer' => 'http://www.mooktool.com/',
'user-agent' => 'claudebot',
'accept' => '*/*',
'host' => 'www.mooktool.com',
'content-length' => '',
'content-type' => '',
)
- [ PARAM ] array (
)
- [ LANG ] /mnt/7kzhanqun/app/portal/lang/zh-cn/home.php
- [ VIEW ] /mnt/7kzhanqun/public/themes/seo_pc/portal/index.html [ array (
0 => 'site_info',
1 => 'event_info',
2 => 'categories',
3 => 'front_theme',
4 => 'tdk',
5 => 'theme_vars',
6 => 'theme_widgets',
) ]
- [ DB ] CONNECT:[ UseTime:0.002547s ] mysql:host=rm-3ns6rn8368257272i.mysql.rds.aliyuncs.com;port=3306;dbname=7kzhanqun;charset=utf8mb4
- [ SQL ] SHOW COLUMNS FROM `cmf_plugin_web` [ RunTime:0.001764s ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.mooktool.com%' LIMIT 1 [ RunTime:0.001372s ]
- [ 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' => 44,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.mooktool.com%' LIMIT 1 [ RunTime:0.001386s ]
- [ 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' => 44,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_plugin` [ RunTime:0.001621s ]
- [ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Web' AND `site_id` = 31 LIMIT 1 [ RunTime:0.001360s ]
- [ 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' => 53,
'filtered' => 1.8867924213409424,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.mooktool.com%' LIMIT 1 [ RunTime:0.001284s ]
- [ 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' => 44,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.mooktool.com%' LIMIT 1 [ RunTime:0.001308s ]
- [ 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' => 44,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.mooktool.com%' LIMIT 1 [ RunTime:0.001255s ]
- [ 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' => 44,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `status` FROM `cmf_plugin_web` WHERE `id` = 31 LIMIT 1 [ RunTime:0.001272s ]
- [ 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.mooktool.com%' LIMIT 1 [ RunTime:0.001271s ]
- [ 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' => 44,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 31 LIMIT 1 [ RunTime:0.001264s ]
- [ 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.mooktool.com%' LIMIT 1 [ RunTime:0.001305s ]
- [ 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' => 44,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.mooktool.com%' LIMIT 1 [ RunTime:0.001320s ]
- [ 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' => 44,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.mooktool.com%' LIMIT 1 [ RunTime:0.001335s ]
- [ 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' => 44,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.001526s ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` WHERE `status` = 1 [ RunTime:0.001383s ]
- [ 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' => 272,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.mooktool.com%' LIMIT 1 [ RunTime:0.001264s ]
- [ 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' => 44,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 31 LIMIT 1 [ RunTime:0.001281s ]
- [ 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.001644s ]
- [ SQL ] SELECT `pinyin` FROM `cmf_nami_competitions` WHERE `id` = 0 LIMIT 1 [ RunTime:0.001418s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => NULL,
'partitions' => NULL,
'type' => NULL,
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => NULL,
'filtered' => NULL,
'extra' => 'no matching row in const table',
) ]
- [ SQL ] SELECT `com_type` FROM `cmf_nami_competitions` WHERE `id` = 0 LIMIT 1 [ RunTime:0.001478s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => NULL,
'partitions' => NULL,
'type' => NULL,
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => NULL,
'filtered' => NULL,
'extra' => 'no matching row in const table',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.mooktool.com%' LIMIT 1 [ RunTime:0.001222s ]
- [ 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' => 44,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.001581s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'seo_pc' AND `file` = 'portal/article' LIMIT 1 [ RunTime:0.001413s ]
- [ 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' => 117,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'seo_pc' , `action` = 'portal/Article/index' , `file` = 'portal/article' , `name` = '资讯详情页' , `more` = '[]' , `config_more` = '[]' , `description` = '资讯详情页模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 'seo_pc' AND `file` = 'portal/article' [ RunTime:0.001629s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'seo_pc' AND `file` = 'portal/competition' LIMIT 1 [ RunTime:0.001448s ]
- [ 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' => 117,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'seo_pc' , `action` = 'portal/Competition/index' , `file` = 'portal/competition' , `name` = '赛程列表页' , `more` = '{\"vars\":[]}' , `config_more` = '{\"vars\":[]}' , `description` = '赛程列表模板文件' , `is_public` = 0 , `list_order` = 0 WHERE `theme` = 'seo_pc' AND `file` = 'portal/competition' [ RunTime:0.001405s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'seo_pc' AND `file` = 'portal/index' LIMIT 1 [ RunTime:0.001395s ]
- [ 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' => 117,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'seo_pc' , `action` = 'portal/Index/index' , `file` = 'portal/index' , `name` = '首页' , `more` = '{\"vars\":[]}' , `config_more` = '{\"vars\":[]}' , `description` = '首页模板文件' , `is_public` = 0 , `list_order` = 0 WHERE `theme` = 'seo_pc' AND `file` = 'portal/index' [ RunTime:0.001379s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'seo_pc' AND `file` = 'portal/list' LIMIT 1 [ RunTime:0.001339s ]
- [ 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' => 117,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'seo_pc' , `action` = 'portal/List/index' , `file` = 'portal/list' , `name` = '资讯列表页' , `more` = '[]' , `config_more` = '[]' , `description` = '资讯列表模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 'seo_pc' AND `file` = 'portal/list' [ RunTime:0.001522s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'seo_pc' AND `file` = 'portal/match' LIMIT 1 [ RunTime:0.001404s ]
- [ 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' => 117,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'seo_pc' , `action` = 'portal/Match/index' , `file` = 'portal/match' , `name` = '赛事详情页' , `more` = '{\"vars\":[]}' , `config_more` = '{\"vars\":[]}' , `description` = '赛事详情页模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 'seo_pc' AND `file` = 'portal/match' [ RunTime:0.001428s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'seo_pc' AND `file` = 'portal/tag' LIMIT 1 [ RunTime:0.001352s ]
- [ 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' => 117,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'seo_pc' , `action` = 'portal/Tag/index' , `file` = 'portal/tag' , `name` = '文章标签页' , `more` = '{\"vars\":[]}' , `config_more` = '{\"vars\":[]}' , `description` = '文章标签模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 'seo_pc' AND `file` = 'portal/tag' [ RunTime:0.001493s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'seo_pc' [ RunTime:0.001494s ]
- [ 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' => 117,
'filtered' => 9.999999046325684,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_theme` [ RunTime:0.002724s ]
- [ SQL ] UPDATE `cmf_theme` SET `name` = 'seo_pc' , `version` = '1.0.2' , `demo_url` = '' , `author` = '1408' , `lang` = 'zh-cn' , `author_url` = '' , `keywords` = 'seo_pc' , `description` = 'seo_pc' WHERE `theme` = 'seo_pc' [ RunTime:0.002264s ]
- [ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = 'seo_pc' AND ( `is_public` = 1 OR `file` = 'portal/index' ) [ RunTime:0.001464s ]
- [ 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' => 117,
'filtered' => 1.899999737739563,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.mooktool.com%' LIMIT 1 [ RunTime:0.008352s ]
- [ 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' => 44,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.mooktool.com%' LIMIT 1 [ RunTime:0.001657s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 44,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Oss' AND `site_id` = 31 LIMIT 1 [ RunTime:0.002646s ]
- [ 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' => 53,
'filtered' => 1.8867924213409424,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.mooktool.com%' LIMIT 1 [ RunTime:0.008582s ]
- [ 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' => 44,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.mooktool.com%' LIMIT 1 [ RunTime:0.002665s ]
- [ 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' => 44,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_nav` [ RunTime:0.002427s ]
- [ SQL ] SELECT `id` FROM `cmf_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.001292s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nav',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 2,
'filtered' => 50.0,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_nav_menu` [ RunTime:0.001501s ]
- [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `site_id` = 31 AND `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.001548s ]
- [ 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' => 365,
'filtered' => 0.27397260069847107,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.mooktool.com%' LIMIT 1 [ RunTime:0.001299s ]
- [ 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' => 44,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.mooktool.com%' LIMIT 1 [ RunTime:0.001314s ]
- [ 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' => 44,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_nami_competition_hot` [ RunTime:0.001351s ]
- [ SQL ] SELECT `cid` FROM `cmf_nami_competition_hot` WHERE `site_id` = 31 LIMIT 20 [ RunTime:0.001278s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_competition_hot',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 136,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `id` IN ('') [ RunTime:0.001502s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => NULL,
'partitions' => NULL,
'type' => NULL,
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => NULL,
'filtered' => NULL,
'extra' => 'no matching row in const table',
) ]
- [ SQL ] SELECT `cid` FROM `cmf_nami_competitions` WHERE `pinyin` = 'all' AND `com_type` = 0 LIMIT 1 [ RunTime:0.003682s ]
- [ 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' => 3710,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_nami_matches` [ RunTime:0.001659s ]
- [ SQL ] SELECT * FROM `cmf_nami_matches` WHERE ( `match_time` > 1711675981 ) ORDER BY `match_time` ASC LIMIT 500 [ RunTime:0.004163s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_matches',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'match_time',
'key' => 'match_time',
'key_len' => '5',
'ref' => NULL,
'rows' => 25868,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` IN (1924,299,1925,3194,3974,2115,613,466,1886,601,3900,3986,1871,602,5118,1926,586,546,3874,241,1664,591,590,263,1890,31,1687,260,1660,3120,276,3124,24,349,255,567,3075,90,254,3333,2015,5,12,464,862,2915,675,1679,1867,1676,3240,371,548,249,152,1819,1666,2064,1733,59,4071,3957,2846,435,20,65,542,3,187,364,186,332,132,1675,2856,2244,3493,96,370,361,303,83,388,1862,274,1667,348,1719,1745,88,344,368,359,298,1671,1668,286,2836,1663,1788,3141,354,336,3008,674,293,3060,345,296,337,2791,213,992,1906,97,2857,425,3019,330,1750,84,85,86,87,385,89,91,2914,386,13,2168,237,3527,4413,1824,576,473,217,151,270,69,1739,47,32,52,301,3478,275,238,15) [ RunTime:0.004530s ]
- [ 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' => 150,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` IN (1924,299,1925,3194,3974,2115,613,466,1886,601,3900,3986,1871,602,5118,1926,586,546,3874,241,1664,591,590,263,1890,31,1687,260,1660,3120,276,3124,24,349,255,567,3075,90,254,3333,2015,5,12,464,862,2915,675,1679,1867,1676,3240,371,548,249,152,1819,1666,2064,1733,59,4071,3957,2846,435,20,65,542,3,187,364,186,332,132,1675,2856,2244,3493,96,370,361,303,83,388,1862,274,1667,348,1719,1745,88,344,368,359,298,1671,1668,286,2836,1663,1788,3141,354,336,3008,674,293,3060,345,296,337,2791,213,992,1906,97,2857,425,3019,330,1750,84,85,86,87,385,89,91,2914,386,13,2168,237,3527,4413,1824,576,473,217,151,270,69,1739,47,32,52,301,3478,275,238,15) [ RunTime:0.003411s ]
- [ 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' => 150,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_nami_teams` [ RunTime:0.001633s ]
- [ SQL ] SELECT `cid`,`short_name_zh` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (36166,31419,35505,35569,40321,17251,72507,25957,13414,44718,33693,20742,34088,26445,80936,27575,31537,34244,21919,26407,18779,14774,40444,14640,26176,26024,46541,81502,46442,81718,26040,69555,22574,18736,40781,26800,39776,21447,38129,39238,22344,21910,14959,15569,80192,24804,22124,30655,46960,37625,10938,30138,21425,36366,17754,24120,21211,58100,42566,18190,47867,15332,18402,17203,73062,20181,12297,42449,42312,10387,38273,57786,41528,76334,10327,28715,23974,23804,61773,14650,52416,16361,57924,38554,30329,81550,10164,81595,37173,30323,10315,38744,15402,36466,40362,20213,52818,74593,23187,57213,80554,16621,44042,76571,36242,37840,37624,71759,71605,25978,12475,37640,81014,71476,20572,62499,30823,31020,42508,26054,23763,16909,33808,12538,46229,76418,12047,31791,36824,36758,43423,11543,81459,10939,41063,38312,20691,13490,62501,40291,16893,24222,34331,10202,10152,12469,30263,20211,45373,10360,10273,10726,10793,20163,58202,19200,42676,71647,12669,18413,10959,19352,32484,74479,17905,18305,24464,10972,11024,51845,36549,14072,44877,23823,72716,11102,48139,56110,25353,31227,52893,17046,11385,11631,26177,21622,16446,10130,19699,34976,32158,10735,22698,11039,12627,13262,18885,38491,34066,48481,12865,12548,26713,32757,18968,35098,31602,10681,18314,13076,29936,11472,19802,16955,36049,28296,19157,42091,42087,18600,61875,56535,23111,40284,24459,10540,34877,49637,28256,22277,10740,42314,36371,17080,31973,53944,32847,36931,62187,41181,36003,16971,61456,68190,52702,48646,25200,58539,72595,19497,16738,19815,45468,34714,54021,44817,29119,40438,31751,34466,14725,29334,33675,22717,27088,58204,20212,52161,19191,20112,72482,11444,12553,13058,13057,17260,60539,34067,20479,47464,30180,10896,10394,45139,45453,14523,10393,33270,22519,32179,20416,36006,17035,68753,73121,45782,52932,34929,12779,24212,32978,20818,21095,53127,47427,21271,21212,58667,34788,59894,59889,79309,79498,16470,69964,51066,11206,28737,28200,24000,31633,14660,13290,27681,16350,12022,25023,29345,46977,18403,17121,34748,13583,12885,54482,13450,81720,17234,13477,13277,13269,13373,21759,20611,10023,10114,10538,10184,10174,10290,10101,10182,10129,10011,11352,11997,12913,10127,11501,10177,11117,10862,10248,11115,10861,11843,11963,10102,10536,11842,10734,10225,10495,24781,10535,10498,15138,20391,10732,18760,10537,11526,16129,10497,14755,25328,16655,11119,11179,15596,14595,11113,15566,11862,13493,11413,11502,33003,12019,11480,16214,11966,10569,20711,13143,17115,14997,17061,11841,19199,27633,11365,18876,14593,17022,24925,24978,16357,20186,19595,23213,17775,17024,24881,40285,36012,22408,30890,13183,62461,47225,37373,12638,10687,50761,10957,10999,75419,10973,50906,73469,77428,11826,13128,41015,19151,10749,80910,17291,11944,19582,26475,23224,10328,17452,11838,32896,23993,14759,14550,11279,11281,25360,12591,25197,11280,11013,11201,12580,75426,16356,55216,56788,54117,69583,26751,21094,12978,17305,48049,33178,16112,76264,55055,79883,79881,10404,10628,10648,11276,12420,45393,13540,60887,35198,14734,45392,76679,35101,31426,42064,37495,12954,14309,27663,81471,74386,34245,26381,69829,22573,41438,18729,15558,21055,34287,81500,45514,81504,27339,69552,32839,18390,16394,21342,39775,50726,39025,81623,37623,40556,25461,28213,53616,28420,29054,23931,22522,48554,10944,72912,30202,38627,59772,32719,15670,22648,22520,41116,50725,21333,15331,19225,40897,15586,36430,23580,20339,18980,37975,29156,12477,28556,20273,28714,40341,45735,17569,56244,21864,10780,21138,36010,72701,34741,10104,81626,40648,81415,27026,25636,30234,30543,20053,76452,16058,24558,39718,36387,49081,62854,46648,58540,29340,22014,30665,52928,38081,25833,34514,53876,24584,10899,33767,47299,28608,19917,53005,34332,13391,21191,74594,30404,21993,37451,35779,25450,43420,25279,81382,38644,41064,38082,37144,44885,57215,15018,23777,26866,68578,10254,10200,12123,12641,11244,13157,10725,10729,10721,59214,36040,12860,58017,23070,22971,27378,14679,19948,31853,14912,13666,12661,19700,10436,26993,18927,36547,20198,12473,27921,56888,40230,35004,81728,40569,23159,52456,22912,10508,12252,30617,10679,10509,10247,12352,34812,25034,50029,18884,23778,27924,34515,11678,37015,40234,69270,56970,31900,32738,19413,19780,22429,40377,10005,15603,10961,15164,19501,17976,31901,17043,14815,25751,29779,17055,18606,35857,69575,74412,24919,45413,14343,35175,49641,27275,75274,45131,65571,61547,61484,49969,13212,16817,38662,16701,44950,15324,23419,17107,22559,38264,37740,53441,57590,36908,52704,32700,58365,81628,41062,26815,71434,81729,23410,32115,34126,31764,23036,38738,26997,35945,58206,20162,19404,19938,41977,16674,27712,71356,21630,26365,27611,74844,20549,60537,17205,66997,11401,23633,15578,23015,51882,16450,12349,49039,26665,23225,57577,15419,39765,44974,73120,23132,39768,12971,35588,72604,24294,22062,23223,17372,15325,21272,49916,23540,54783,33711,81719,78014,38114,53580,77991,13068,30480,24162,27680,16025,18942,23148,26572,12808,11051,37557,31293,62838,53132,17813,47510,48197,18598,73371,41221,18820,57557,47060,15381,37744,20079,17664,30853,10024,10245,10246,10256,10173,10008,11844,10004,10860,10128,10179,11527,12503,11861,11114,11428,10571,10007,11412,10185,11411,15798,11116,11319,11429,10533,10817,10178,11781,13254,12504,10570,10859,14652,11530,11528,73352,12949,12018,25123,18938,11112,16128,10103,17113,10728,20740,42832,10573,24378,10796,13857,22565,19298,11180,15799,14134,23207,15736,12057,13141,19444,14655,20344,10534,14983,77501,31528,78640,26877,15604,22048,17027,20915,17398,11622,13145,27781,11964,18302,52861,12345,68579,60367,76111,13033,10301,13060,25725,21814,11001,10958,76257,15475,35100,78172,40483,72461,78893,41019,14833,10763,81730,18474,30467,23810,17449,10078,52859,16297,20979,38137,11819,14547,10910,12081,11278,10751,40140,38699,24884,10180,10951,36251,26798,17401,78268,30239,14633,56830,44256,15366,16957,37175,16386,18207,18813,75421,34050,79880,80032,15421,15128,10140,25361,25439) [ RunTime:0.009450s ]
- [ 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' => 976,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT `cid`,`name_zh` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (36166,31419,35505,35569,40321,17251,72507,25957,13414,44718,33693,20742,34088,26445,80936,27575,31537,34244,21919,26407,18779,14774,40444,14640,26176,26024,46541,81502,46442,81718,26040,69555,22574,18736,40781,26800,39776,21447,38129,39238,22344,21910,14959,15569,80192,24804,22124,30655,46960,37625,10938,30138,21425,36366,17754,24120,21211,58100,42566,18190,47867,15332,18402,17203,73062,20181,12297,42449,42312,10387,38273,57786,41528,76334,10327,28715,23974,23804,61773,14650,52416,16361,57924,38554,30329,81550,10164,81595,37173,30323,10315,38744,15402,36466,40362,20213,52818,74593,23187,57213,80554,16621,44042,76571,36242,37840,37624,71759,71605,25978,12475,37640,81014,71476,20572,62499,30823,31020,42508,26054,23763,16909,33808,12538,46229,76418,12047,31791,36824,36758,43423,11543,81459,10939,41063,38312,20691,13490,62501,40291,16893,24222,34331,10202,10152,12469,30263,20211,45373,10360,10273,10726,10793,20163,58202,19200,42676,71647,12669,18413,10959,19352,32484,74479,17905,18305,24464,10972,11024,51845,36549,14072,44877,23823,72716,11102,48139,56110,25353,31227,52893,17046,11385,11631,26177,21622,16446,10130,19699,34976,32158,10735,22698,11039,12627,13262,18885,38491,34066,48481,12865,12548,26713,32757,18968,35098,31602,10681,18314,13076,29936,11472,19802,16955,36049,28296,19157,42091,42087,18600,61875,56535,23111,40284,24459,10540,34877,49637,28256,22277,10740,42314,36371,17080,31973,53944,32847,36931,62187,41181,36003,16971,61456,68190,52702,48646,25200,58539,72595,19497,16738,19815,45468,34714,54021,44817,29119,40438,31751,34466,14725,29334,33675,22717,27088,58204,20212,52161,19191,20112,72482,11444,12553,13058,13057,17260,60539,34067,20479,47464,30180,10896,10394,45139,45453,14523,10393,33270,22519,32179,20416,36006,17035,68753,73121,45782,52932,34929,12779,24212,32978,20818,21095,53127,47427,21271,21212,58667,34788,59894,59889,79309,79498,16470,69964,51066,11206,28737,28200,24000,31633,14660,13290,27681,16350,12022,25023,29345,46977,18403,17121,34748,13583,12885,54482,13450,81720,17234,13477,13277,13269,13373,21759,20611,10023,10114,10538,10184,10174,10290,10101,10182,10129,10011,11352,11997,12913,10127,11501,10177,11117,10862,10248,11115,10861,11843,11963,10102,10536,11842,10734,10225,10495,24781,10535,10498,15138,20391,10732,18760,10537,11526,16129,10497,14755,25328,16655,11119,11179,15596,14595,11113,15566,11862,13493,11413,11502,33003,12019,11480,16214,11966,10569,20711,13143,17115,14997,17061,11841,19199,27633,11365,18876,14593,17022,24925,24978,16357,20186,19595,23213,17775,17024,24881,40285,36012,22408,30890,13183,62461,47225,37373,12638,10687,50761,10957,10999,75419,10973,50906,73469,77428,11826,13128,41015,19151,10749,80910,17291,11944,19582,26475,23224,10328,17452,11838,32896,23993,14759,14550,11279,11281,25360,12591,25197,11280,11013,11201,12580,75426,16356,55216,56788,54117,69583,26751,21094,12978,17305,48049,33178,16112,76264,55055,79883,79881,10404,10628,10648,11276,12420,45393,13540,60887,35198,14734,45392,76679,35101,31426,42064,37495,12954,14309,27663,81471,74386,34245,26381,69829,22573,41438,18729,15558,21055,34287,81500,45514,81504,27339,69552,32839,18390,16394,21342,39775,50726,39025,81623,37623,40556,25461,28213,53616,28420,29054,23931,22522,48554,10944,72912,30202,38627,59772,32719,15670,22648,22520,41116,50725,21333,15331,19225,40897,15586,36430,23580,20339,18980,37975,29156,12477,28556,20273,28714,40341,45735,17569,56244,21864,10780,21138,36010,72701,34741,10104,81626,40648,81415,27026,25636,30234,30543,20053,76452,16058,24558,39718,36387,49081,62854,46648,58540,29340,22014,30665,52928,38081,25833,34514,53876,24584,10899,33767,47299,28608,19917,53005,34332,13391,21191,74594,30404,21993,37451,35779,25450,43420,25279,81382,38644,41064,38082,37144,44885,57215,15018,23777,26866,68578,10254,10200,12123,12641,11244,13157,10725,10729,10721,59214,36040,12860,58017,23070,22971,27378,14679,19948,31853,14912,13666,12661,19700,10436,26993,18927,36547,20198,12473,27921,56888,40230,35004,81728,40569,23159,52456,22912,10508,12252,30617,10679,10509,10247,12352,34812,25034,50029,18884,23778,27924,34515,11678,37015,40234,69270,56970,31900,32738,19413,19780,22429,40377,10005,15603,10961,15164,19501,17976,31901,17043,14815,25751,29779,17055,18606,35857,69575,74412,24919,45413,14343,35175,49641,27275,75274,45131,65571,61547,61484,49969,13212,16817,38662,16701,44950,15324,23419,17107,22559,38264,37740,53441,57590,36908,52704,32700,58365,81628,41062,26815,71434,81729,23410,32115,34126,31764,23036,38738,26997,35945,58206,20162,19404,19938,41977,16674,27712,71356,21630,26365,27611,74844,20549,60537,17205,66997,11401,23633,15578,23015,51882,16450,12349,49039,26665,23225,57577,15419,39765,44974,73120,23132,39768,12971,35588,72604,24294,22062,23223,17372,15325,21272,49916,23540,54783,33711,81719,78014,38114,53580,77991,13068,30480,24162,27680,16025,18942,23148,26572,12808,11051,37557,31293,62838,53132,17813,47510,48197,18598,73371,41221,18820,57557,47060,15381,37744,20079,17664,30853,10024,10245,10246,10256,10173,10008,11844,10004,10860,10128,10179,11527,12503,11861,11114,11428,10571,10007,11412,10185,11411,15798,11116,11319,11429,10533,10817,10178,11781,13254,12504,10570,10859,14652,11530,11528,73352,12949,12018,25123,18938,11112,16128,10103,17113,10728,20740,42832,10573,24378,10796,13857,22565,19298,11180,15799,14134,23207,15736,12057,13141,19444,14655,20344,10534,14983,77501,31528,78640,26877,15604,22048,17027,20915,17398,11622,13145,27781,11964,18302,52861,12345,68579,60367,76111,13033,10301,13060,25725,21814,11001,10958,76257,15475,35100,78172,40483,72461,78893,41019,14833,10763,81730,18474,30467,23810,17449,10078,52859,16297,20979,38137,11819,14547,10910,12081,11278,10751,40140,38699,24884,10180,10951,36251,26798,17401,78268,30239,14633,56830,44256,15366,16957,37175,16386,18207,18813,75421,34050,79880,80032,15421,15128,10140,25361,25439) [ RunTime:0.008845s ]
- [ 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' => 976,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT `cid`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (36166,31419,35505,35569,40321,17251,72507,25957,13414,44718,33693,20742,34088,26445,80936,27575,31537,34244,21919,26407,18779,14774,40444,14640,26176,26024,46541,81502,46442,81718,26040,69555,22574,18736,40781,26800,39776,21447,38129,39238,22344,21910,14959,15569,80192,24804,22124,30655,46960,37625,10938,30138,21425,36366,17754,24120,21211,58100,42566,18190,47867,15332,18402,17203,73062,20181,12297,42449,42312,10387,38273,57786,41528,76334,10327,28715,23974,23804,61773,14650,52416,16361,57924,38554,30329,81550,10164,81595,37173,30323,10315,38744,15402,36466,40362,20213,52818,74593,23187,57213,80554,16621,44042,76571,36242,37840,37624,71759,71605,25978,12475,37640,81014,71476,20572,62499,30823,31020,42508,26054,23763,16909,33808,12538,46229,76418,12047,31791,36824,36758,43423,11543,81459,10939,41063,38312,20691,13490,62501,40291,16893,24222,34331,10202,10152,12469,30263,20211,45373,10360,10273,10726,10793,20163,58202,19200,42676,71647,12669,18413,10959,19352,32484,74479,17905,18305,24464,10972,11024,51845,36549,14072,44877,23823,72716,11102,48139,56110,25353,31227,52893,17046,11385,11631,26177,21622,16446,10130,19699,34976,32158,10735,22698,11039,12627,13262,18885,38491,34066,48481,12865,12548,26713,32757,18968,35098,31602,10681,18314,13076,29936,11472,19802,16955,36049,28296,19157,42091,42087,18600,61875,56535,23111,40284,24459,10540,34877,49637,28256,22277,10740,42314,36371,17080,31973,53944,32847,36931,62187,41181,36003,16971,61456,68190,52702,48646,25200,58539,72595,19497,16738,19815,45468,34714,54021,44817,29119,40438,31751,34466,14725,29334,33675,22717,27088,58204,20212,52161,19191,20112,72482,11444,12553,13058,13057,17260,60539,34067,20479,47464,30180,10896,10394,45139,45453,14523,10393,33270,22519,32179,20416,36006,17035,68753,73121,45782,52932,34929,12779,24212,32978,20818,21095,53127,47427,21271,21212,58667,34788,59894,59889,79309,79498,16470,69964,51066,11206,28737,28200,24000,31633,14660,13290,27681,16350,12022,25023,29345,46977,18403,17121,34748,13583,12885,54482,13450,81720,17234,13477,13277,13269,13373,21759,20611,10023,10114,10538,10184,10174,10290,10101,10182,10129,10011,11352,11997,12913,10127,11501,10177,11117,10862,10248,11115,10861,11843,11963,10102,10536,11842,10734,10225,10495,24781,10535,10498,15138,20391,10732,18760,10537,11526,16129,10497,14755,25328,16655,11119,11179,15596,14595,11113,15566,11862,13493,11413,11502,33003,12019,11480,16214,11966,10569,20711,13143,17115,14997,17061,11841,19199,27633,11365,18876,14593,17022,24925,24978,16357,20186,19595,23213,17775,17024,24881,40285,36012,22408,30890,13183,62461,47225,37373,12638,10687,50761,10957,10999,75419,10973,50906,73469,77428,11826,13128,41015,19151,10749,80910,17291,11944,19582,26475,23224,10328,17452,11838,32896,23993,14759,14550,11279,11281,25360,12591,25197,11280,11013,11201,12580,75426,16356,55216,56788,54117,69583,26751,21094,12978,17305,48049,33178,16112,76264,55055,79883,79881,10404,10628,10648,11276,12420,45393,13540,60887,35198,14734,45392,76679,35101,31426,42064,37495,12954,14309,27663,81471,74386,34245,26381,69829,22573,41438,18729,15558,21055,34287,81500,45514,81504,27339,69552,32839,18390,16394,21342,39775,50726,39025,81623,37623,40556,25461,28213,53616,28420,29054,23931,22522,48554,10944,72912,30202,38627,59772,32719,15670,22648,22520,41116,50725,21333,15331,19225,40897,15586,36430,23580,20339,18980,37975,29156,12477,28556,20273,28714,40341,45735,17569,56244,21864,10780,21138,36010,72701,34741,10104,81626,40648,81415,27026,25636,30234,30543,20053,76452,16058,24558,39718,36387,49081,62854,46648,58540,29340,22014,30665,52928,38081,25833,34514,53876,24584,10899,33767,47299,28608,19917,53005,34332,13391,21191,74594,30404,21993,37451,35779,25450,43420,25279,81382,38644,41064,38082,37144,44885,57215,15018,23777,26866,68578,10254,10200,12123,12641,11244,13157,10725,10729,10721,59214,36040,12860,58017,23070,22971,27378,14679,19948,31853,14912,13666,12661,19700,10436,26993,18927,36547,20198,12473,27921,56888,40230,35004,81728,40569,23159,52456,22912,10508,12252,30617,10679,10509,10247,12352,34812,25034,50029,18884,23778,27924,34515,11678,37015,40234,69270,56970,31900,32738,19413,19780,22429,40377,10005,15603,10961,15164,19501,17976,31901,17043,14815,25751,29779,17055,18606,35857,69575,74412,24919,45413,14343,35175,49641,27275,75274,45131,65571,61547,61484,49969,13212,16817,38662,16701,44950,15324,23419,17107,22559,38264,37740,53441,57590,36908,52704,32700,58365,81628,41062,26815,71434,81729,23410,32115,34126,31764,23036,38738,26997,35945,58206,20162,19404,19938,41977,16674,27712,71356,21630,26365,27611,74844,20549,60537,17205,66997,11401,23633,15578,23015,51882,16450,12349,49039,26665,23225,57577,15419,39765,44974,73120,23132,39768,12971,35588,72604,24294,22062,23223,17372,15325,21272,49916,23540,54783,33711,81719,78014,38114,53580,77991,13068,30480,24162,27680,16025,18942,23148,26572,12808,11051,37557,31293,62838,53132,17813,47510,48197,18598,73371,41221,18820,57557,47060,15381,37744,20079,17664,30853,10024,10245,10246,10256,10173,10008,11844,10004,10860,10128,10179,11527,12503,11861,11114,11428,10571,10007,11412,10185,11411,15798,11116,11319,11429,10533,10817,10178,11781,13254,12504,10570,10859,14652,11530,11528,73352,12949,12018,25123,18938,11112,16128,10103,17113,10728,20740,42832,10573,24378,10796,13857,22565,19298,11180,15799,14134,23207,15736,12057,13141,19444,14655,20344,10534,14983,77501,31528,78640,26877,15604,22048,17027,20915,17398,11622,13145,27781,11964,18302,52861,12345,68579,60367,76111,13033,10301,13060,25725,21814,11001,10958,76257,15475,35100,78172,40483,72461,78893,41019,14833,10763,81730,18474,30467,23810,17449,10078,52859,16297,20979,38137,11819,14547,10910,12081,11278,10751,40140,38699,24884,10180,10951,36251,26798,17401,78268,30239,14633,56830,44256,15366,16957,37175,16386,18207,18813,75421,34050,79880,80032,15421,15128,10140,25361,25439) [ RunTime:0.011233s ]
- [ 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' => 976,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT `cid`,`short_name_zh` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (36166,31419,35505,35569,40321,17251,72507,25957,13414,44718,33693,20742,34088,26445,80936,27575,31537,34244,21919,26407,18779,14774,40444,14640,26176,26024,46541,81502,46442,81718,26040,69555,22574,18736,40781,26800,39776,21447,38129,39238,22344,21910,14959,15569,80192,24804,22124,30655,46960,37625,10938,30138,21425,36366,17754,24120,21211,58100,42566,18190,47867,15332,18402,17203,73062,20181,12297,42449,42312,10387,38273,57786,41528,76334,10327,28715,23974,23804,61773,14650,52416,16361,57924,38554,30329,81550,10164,81595,37173,30323,10315,38744,15402,36466,40362,20213,52818,74593,23187,57213,80554,16621,44042,76571,36242,37840,37624,71759,71605,25978,12475,37640,81014,71476,20572,62499,30823,31020,42508,26054,23763,16909,33808,12538,46229,76418,12047,31791,36824,36758,43423,11543,81459,10939,41063,38312,20691,13490,62501,40291,16893,24222,34331,10202,10152,12469,30263,20211,45373,10360,10273,10726,10793,20163,58202,19200,42676,71647,12669,18413,10959,19352,32484,74479,17905,18305,24464,10972,11024,51845,36549,14072,44877,23823,72716,11102,48139,56110,25353,31227,52893,17046,11385,11631,26177,21622,16446,10130,19699,34976,32158,10735,22698,11039,12627,13262,18885,38491,34066,48481,12865,12548,26713,32757,18968,35098,31602,10681,18314,13076,29936,11472,19802,16955,36049,28296,19157,42091,42087,18600,61875,56535,23111,40284,24459,10540,34877,49637,28256,22277,10740,42314,36371,17080,31973,53944,32847,36931,62187,41181,36003,16971,61456,68190,52702,48646,25200,58539,72595,19497,16738,19815,45468,34714,54021,44817,29119,40438,31751,34466,14725,29334,33675,22717,27088,58204,20212,52161,19191,20112,72482,11444,12553,13058,13057,17260,60539,34067,20479,47464,30180,10896,10394,45139,45453,14523,10393,33270,22519,32179,20416,36006,17035,68753,73121,45782,52932,34929,12779,24212,32978,20818,21095,53127,47427,21271,21212,58667,34788,59894,59889,79309,79498,16470,69964,51066,11206,28737,28200,24000,31633,14660,13290,27681,16350,12022,25023,29345,46977,18403,17121,34748,13583,12885,54482,13450,81720,17234,13477,13277,13269,13373,21759,20611,10023,10114,10538,10184,10174,10290,10101,10182,10129,10011,11352,11997,12913,10127,11501,10177,11117,10862,10248,11115,10861,11843,11963,10102,10536,11842,10734,10225,10495,24781,10535,10498,15138,20391,10732,18760,10537,11526,16129,10497,14755,25328,16655,11119,11179,15596,14595,11113,15566,11862,13493,11413,11502,33003,12019,11480,16214,11966,10569,20711,13143,17115,14997,17061,11841,19199,27633,11365,18876,14593,17022,24925,24978,16357,20186,19595,23213,17775,17024,24881,40285,36012,22408,30890,13183,62461,47225,37373,12638,10687,50761,10957,10999,75419,10973,50906,73469,77428,11826,13128,41015,19151,10749,80910,17291,11944,19582,26475,23224,10328,17452,11838,32896,23993,14759,14550,11279,11281,25360,12591,25197,11280,11013,11201,12580,75426,16356,55216,56788,54117,69583,26751,21094,12978,17305,48049,33178,16112,76264,55055,79883,79881,10404,10628,10648,11276,12420,45393,13540,60887,35198,14734,45392,76679,35101,31426,42064,37495,12954,14309,27663,81471,74386,34245,26381,69829,22573,41438,18729,15558,21055,34287,81500,45514,81504,27339,69552,32839,18390,16394,21342,39775,50726,39025,81623,37623,40556,25461,28213,53616,28420,29054,23931,22522,48554,10944,72912,30202,38627,59772,32719,15670,22648,22520,41116,50725,21333,15331,19225,40897,15586,36430,23580,20339,18980,37975,29156,12477,28556,20273,28714,40341,45735,17569,56244,21864,10780,21138,36010,72701,34741,10104,81626,40648,81415,27026,25636,30234,30543,20053,76452,16058,24558,39718,36387,49081,62854,46648,58540,29340,22014,30665,52928,38081,25833,34514,53876,24584,10899,33767,47299,28608,19917,53005,34332,13391,21191,74594,30404,21993,37451,35779,25450,43420,25279,81382,38644,41064,38082,37144,44885,57215,15018,23777,26866,68578,10254,10200,12123,12641,11244,13157,10725,10729,10721,59214,36040,12860,58017,23070,22971,27378,14679,19948,31853,14912,13666,12661,19700,10436,26993,18927,36547,20198,12473,27921,56888,40230,35004,81728,40569,23159,52456,22912,10508,12252,30617,10679,10509,10247,12352,34812,25034,50029,18884,23778,27924,34515,11678,37015,40234,69270,56970,31900,32738,19413,19780,22429,40377,10005,15603,10961,15164,19501,17976,31901,17043,14815,25751,29779,17055,18606,35857,69575,74412,24919,45413,14343,35175,49641,27275,75274,45131,65571,61547,61484,49969,13212,16817,38662,16701,44950,15324,23419,17107,22559,38264,37740,53441,57590,36908,52704,32700,58365,81628,41062,26815,71434,81729,23410,32115,34126,31764,23036,38738,26997,35945,58206,20162,19404,19938,41977,16674,27712,71356,21630,26365,27611,74844,20549,60537,17205,66997,11401,23633,15578,23015,51882,16450,12349,49039,26665,23225,57577,15419,39765,44974,73120,23132,39768,12971,35588,72604,24294,22062,23223,17372,15325,21272,49916,23540,54783,33711,81719,78014,38114,53580,77991,13068,30480,24162,27680,16025,18942,23148,26572,12808,11051,37557,31293,62838,53132,17813,47510,48197,18598,73371,41221,18820,57557,47060,15381,37744,20079,17664,30853,10024,10245,10246,10256,10173,10008,11844,10004,10860,10128,10179,11527,12503,11861,11114,11428,10571,10007,11412,10185,11411,15798,11116,11319,11429,10533,10817,10178,11781,13254,12504,10570,10859,14652,11530,11528,73352,12949,12018,25123,18938,11112,16128,10103,17113,10728,20740,42832,10573,24378,10796,13857,22565,19298,11180,15799,14134,23207,15736,12057,13141,19444,14655,20344,10534,14983,77501,31528,78640,26877,15604,22048,17027,20915,17398,11622,13145,27781,11964,18302,52861,12345,68579,60367,76111,13033,10301,13060,25725,21814,11001,10958,76257,15475,35100,78172,40483,72461,78893,41019,14833,10763,81730,18474,30467,23810,17449,10078,52859,16297,20979,38137,11819,14547,10910,12081,11278,10751,40140,38699,24884,10180,10951,36251,26798,17401,78268,30239,14633,56830,44256,15366,16957,37175,16386,18207,18813,75421,34050,79880,80032,15421,15128,10140,25361,25439) [ RunTime:0.008931s ]
- [ 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' => 976,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT `cid`,`name_zh` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (36166,31419,35505,35569,40321,17251,72507,25957,13414,44718,33693,20742,34088,26445,80936,27575,31537,34244,21919,26407,18779,14774,40444,14640,26176,26024,46541,81502,46442,81718,26040,69555,22574,18736,40781,26800,39776,21447,38129,39238,22344,21910,14959,15569,80192,24804,22124,30655,46960,37625,10938,30138,21425,36366,17754,24120,21211,58100,42566,18190,47867,15332,18402,17203,73062,20181,12297,42449,42312,10387,38273,57786,41528,76334,10327,28715,23974,23804,61773,14650,52416,16361,57924,38554,30329,81550,10164,81595,37173,30323,10315,38744,15402,36466,40362,20213,52818,74593,23187,57213,80554,16621,44042,76571,36242,37840,37624,71759,71605,25978,12475,37640,81014,71476,20572,62499,30823,31020,42508,26054,23763,16909,33808,12538,46229,76418,12047,31791,36824,36758,43423,11543,81459,10939,41063,38312,20691,13490,62501,40291,16893,24222,34331,10202,10152,12469,30263,20211,45373,10360,10273,10726,10793,20163,58202,19200,42676,71647,12669,18413,10959,19352,32484,74479,17905,18305,24464,10972,11024,51845,36549,14072,44877,23823,72716,11102,48139,56110,25353,31227,52893,17046,11385,11631,26177,21622,16446,10130,19699,34976,32158,10735,22698,11039,12627,13262,18885,38491,34066,48481,12865,12548,26713,32757,18968,35098,31602,10681,18314,13076,29936,11472,19802,16955,36049,28296,19157,42091,42087,18600,61875,56535,23111,40284,24459,10540,34877,49637,28256,22277,10740,42314,36371,17080,31973,53944,32847,36931,62187,41181,36003,16971,61456,68190,52702,48646,25200,58539,72595,19497,16738,19815,45468,34714,54021,44817,29119,40438,31751,34466,14725,29334,33675,22717,27088,58204,20212,52161,19191,20112,72482,11444,12553,13058,13057,17260,60539,34067,20479,47464,30180,10896,10394,45139,45453,14523,10393,33270,22519,32179,20416,36006,17035,68753,73121,45782,52932,34929,12779,24212,32978,20818,21095,53127,47427,21271,21212,58667,34788,59894,59889,79309,79498,16470,69964,51066,11206,28737,28200,24000,31633,14660,13290,27681,16350,12022,25023,29345,46977,18403,17121,34748,13583,12885,54482,13450,81720,17234,13477,13277,13269,13373,21759,20611,10023,10114,10538,10184,10174,10290,10101,10182,10129,10011,11352,11997,12913,10127,11501,10177,11117,10862,10248,11115,10861,11843,11963,10102,10536,11842,10734,10225,10495,24781,10535,10498,15138,20391,10732,18760,10537,11526,16129,10497,14755,25328,16655,11119,11179,15596,14595,11113,15566,11862,13493,11413,11502,33003,12019,11480,16214,11966,10569,20711,13143,17115,14997,17061,11841,19199,27633,11365,18876,14593,17022,24925,24978,16357,20186,19595,23213,17775,17024,24881,40285,36012,22408,30890,13183,62461,47225,37373,12638,10687,50761,10957,10999,75419,10973,50906,73469,77428,11826,13128,41015,19151,10749,80910,17291,11944,19582,26475,23224,10328,17452,11838,32896,23993,14759,14550,11279,11281,25360,12591,25197,11280,11013,11201,12580,75426,16356,55216,56788,54117,69583,26751,21094,12978,17305,48049,33178,16112,76264,55055,79883,79881,10404,10628,10648,11276,12420,45393,13540,60887,35198,14734,45392,76679,35101,31426,42064,37495,12954,14309,27663,81471,74386,34245,26381,69829,22573,41438,18729,15558,21055,34287,81500,45514,81504,27339,69552,32839,18390,16394,21342,39775,50726,39025,81623,37623,40556,25461,28213,53616,28420,29054,23931,22522,48554,10944,72912,30202,38627,59772,32719,15670,22648,22520,41116,50725,21333,15331,19225,40897,15586,36430,23580,20339,18980,37975,29156,12477,28556,20273,28714,40341,45735,17569,56244,21864,10780,21138,36010,72701,34741,10104,81626,40648,81415,27026,25636,30234,30543,20053,76452,16058,24558,39718,36387,49081,62854,46648,58540,29340,22014,30665,52928,38081,25833,34514,53876,24584,10899,33767,47299,28608,19917,53005,34332,13391,21191,74594,30404,21993,37451,35779,25450,43420,25279,81382,38644,41064,38082,37144,44885,57215,15018,23777,26866,68578,10254,10200,12123,12641,11244,13157,10725,10729,10721,59214,36040,12860,58017,23070,22971,27378,14679,19948,31853,14912,13666,12661,19700,10436,26993,18927,36547,20198,12473,27921,56888,40230,35004,81728,40569,23159,52456,22912,10508,12252,30617,10679,10509,10247,12352,34812,25034,50029,18884,23778,27924,34515,11678,37015,40234,69270,56970,31900,32738,19413,19780,22429,40377,10005,15603,10961,15164,19501,17976,31901,17043,14815,25751,29779,17055,18606,35857,69575,74412,24919,45413,14343,35175,49641,27275,75274,45131,65571,61547,61484,49969,13212,16817,38662,16701,44950,15324,23419,17107,22559,38264,37740,53441,57590,36908,52704,32700,58365,81628,41062,26815,71434,81729,23410,32115,34126,31764,23036,38738,26997,35945,58206,20162,19404,19938,41977,16674,27712,71356,21630,26365,27611,74844,20549,60537,17205,66997,11401,23633,15578,23015,51882,16450,12349,49039,26665,23225,57577,15419,39765,44974,73120,23132,39768,12971,35588,72604,24294,22062,23223,17372,15325,21272,49916,23540,54783,33711,81719,78014,38114,53580,77991,13068,30480,24162,27680,16025,18942,23148,26572,12808,11051,37557,31293,62838,53132,17813,47510,48197,18598,73371,41221,18820,57557,47060,15381,37744,20079,17664,30853,10024,10245,10246,10256,10173,10008,11844,10004,10860,10128,10179,11527,12503,11861,11114,11428,10571,10007,11412,10185,11411,15798,11116,11319,11429,10533,10817,10178,11781,13254,12504,10570,10859,14652,11530,11528,73352,12949,12018,25123,18938,11112,16128,10103,17113,10728,20740,42832,10573,24378,10796,13857,22565,19298,11180,15799,14134,23207,15736,12057,13141,19444,14655,20344,10534,14983,77501,31528,78640,26877,15604,22048,17027,20915,17398,11622,13145,27781,11964,18302,52861,12345,68579,60367,76111,13033,10301,13060,25725,21814,11001,10958,76257,15475,35100,78172,40483,72461,78893,41019,14833,10763,81730,18474,30467,23810,17449,10078,52859,16297,20979,38137,11819,14547,10910,12081,11278,10751,40140,38699,24884,10180,10951,36251,26798,17401,78268,30239,14633,56830,44256,15366,16957,37175,16386,18207,18813,75421,34050,79880,80032,15421,15128,10140,25361,25439) [ RunTime:0.011212s ]
- [ 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' => 976,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT `cid`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (36166,31419,35505,35569,40321,17251,72507,25957,13414,44718,33693,20742,34088,26445,80936,27575,31537,34244,21919,26407,18779,14774,40444,14640,26176,26024,46541,81502,46442,81718,26040,69555,22574,18736,40781,26800,39776,21447,38129,39238,22344,21910,14959,15569,80192,24804,22124,30655,46960,37625,10938,30138,21425,36366,17754,24120,21211,58100,42566,18190,47867,15332,18402,17203,73062,20181,12297,42449,42312,10387,38273,57786,41528,76334,10327,28715,23974,23804,61773,14650,52416,16361,57924,38554,30329,81550,10164,81595,37173,30323,10315,38744,15402,36466,40362,20213,52818,74593,23187,57213,80554,16621,44042,76571,36242,37840,37624,71759,71605,25978,12475,37640,81014,71476,20572,62499,30823,31020,42508,26054,23763,16909,33808,12538,46229,76418,12047,31791,36824,36758,43423,11543,81459,10939,41063,38312,20691,13490,62501,40291,16893,24222,34331,10202,10152,12469,30263,20211,45373,10360,10273,10726,10793,20163,58202,19200,42676,71647,12669,18413,10959,19352,32484,74479,17905,18305,24464,10972,11024,51845,36549,14072,44877,23823,72716,11102,48139,56110,25353,31227,52893,17046,11385,11631,26177,21622,16446,10130,19699,34976,32158,10735,22698,11039,12627,13262,18885,38491,34066,48481,12865,12548,26713,32757,18968,35098,31602,10681,18314,13076,29936,11472,19802,16955,36049,28296,19157,42091,42087,18600,61875,56535,23111,40284,24459,10540,34877,49637,28256,22277,10740,42314,36371,17080,31973,53944,32847,36931,62187,41181,36003,16971,61456,68190,52702,48646,25200,58539,72595,19497,16738,19815,45468,34714,54021,44817,29119,40438,31751,34466,14725,29334,33675,22717,27088,58204,20212,52161,19191,20112,72482,11444,12553,13058,13057,17260,60539,34067,20479,47464,30180,10896,10394,45139,45453,14523,10393,33270,22519,32179,20416,36006,17035,68753,73121,45782,52932,34929,12779,24212,32978,20818,21095,53127,47427,21271,21212,58667,34788,59894,59889,79309,79498,16470,69964,51066,11206,28737,28200,24000,31633,14660,13290,27681,16350,12022,25023,29345,46977,18403,17121,34748,13583,12885,54482,13450,81720,17234,13477,13277,13269,13373,21759,20611,10023,10114,10538,10184,10174,10290,10101,10182,10129,10011,11352,11997,12913,10127,11501,10177,11117,10862,10248,11115,10861,11843,11963,10102,10536,11842,10734,10225,10495,24781,10535,10498,15138,20391,10732,18760,10537,11526,16129,10497,14755,25328,16655,11119,11179,15596,14595,11113,15566,11862,13493,11413,11502,33003,12019,11480,16214,11966,10569,20711,13143,17115,14997,17061,11841,19199,27633,11365,18876,14593,17022,24925,24978,16357,20186,19595,23213,17775,17024,24881,40285,36012,22408,30890,13183,62461,47225,37373,12638,10687,50761,10957,10999,75419,10973,50906,73469,77428,11826,13128,41015,19151,10749,80910,17291,11944,19582,26475,23224,10328,17452,11838,32896,23993,14759,14550,11279,11281,25360,12591,25197,11280,11013,11201,12580,75426,16356,55216,56788,54117,69583,26751,21094,12978,17305,48049,33178,16112,76264,55055,79883,79881,10404,10628,10648,11276,12420,45393,13540,60887,35198,14734,45392,76679,35101,31426,42064,37495,12954,14309,27663,81471,74386,34245,26381,69829,22573,41438,18729,15558,21055,34287,81500,45514,81504,27339,69552,32839,18390,16394,21342,39775,50726,39025,81623,37623,40556,25461,28213,53616,28420,29054,23931,22522,48554,10944,72912,30202,38627,59772,32719,15670,22648,22520,41116,50725,21333,15331,19225,40897,15586,36430,23580,20339,18980,37975,29156,12477,28556,20273,28714,40341,45735,17569,56244,21864,10780,21138,36010,72701,34741,10104,81626,40648,81415,27026,25636,30234,30543,20053,76452,16058,24558,39718,36387,49081,62854,46648,58540,29340,22014,30665,52928,38081,25833,34514,53876,24584,10899,33767,47299,28608,19917,53005,34332,13391,21191,74594,30404,21993,37451,35779,25450,43420,25279,81382,38644,41064,38082,37144,44885,57215,15018,23777,26866,68578,10254,10200,12123,12641,11244,13157,10725,10729,10721,59214,36040,12860,58017,23070,22971,27378,14679,19948,31853,14912,13666,12661,19700,10436,26993,18927,36547,20198,12473,27921,56888,40230,35004,81728,40569,23159,52456,22912,10508,12252,30617,10679,10509,10247,12352,34812,25034,50029,18884,23778,27924,34515,11678,37015,40234,69270,56970,31900,32738,19413,19780,22429,40377,10005,15603,10961,15164,19501,17976,31901,17043,14815,25751,29779,17055,18606,35857,69575,74412,24919,45413,14343,35175,49641,27275,75274,45131,65571,61547,61484,49969,13212,16817,38662,16701,44950,15324,23419,17107,22559,38264,37740,53441,57590,36908,52704,32700,58365,81628,41062,26815,71434,81729,23410,32115,34126,31764,23036,38738,26997,35945,58206,20162,19404,19938,41977,16674,27712,71356,21630,26365,27611,74844,20549,60537,17205,66997,11401,23633,15578,23015,51882,16450,12349,49039,26665,23225,57577,15419,39765,44974,73120,23132,39768,12971,35588,72604,24294,22062,23223,17372,15325,21272,49916,23540,54783,33711,81719,78014,38114,53580,77991,13068,30480,24162,27680,16025,18942,23148,26572,12808,11051,37557,31293,62838,53132,17813,47510,48197,18598,73371,41221,18820,57557,47060,15381,37744,20079,17664,30853,10024,10245,10246,10256,10173,10008,11844,10004,10860,10128,10179,11527,12503,11861,11114,11428,10571,10007,11412,10185,11411,15798,11116,11319,11429,10533,10817,10178,11781,13254,12504,10570,10859,14652,11530,11528,73352,12949,12018,25123,18938,11112,16128,10103,17113,10728,20740,42832,10573,24378,10796,13857,22565,19298,11180,15799,14134,23207,15736,12057,13141,19444,14655,20344,10534,14983,77501,31528,78640,26877,15604,22048,17027,20915,17398,11622,13145,27781,11964,18302,52861,12345,68579,60367,76111,13033,10301,13060,25725,21814,11001,10958,76257,15475,35100,78172,40483,72461,78893,41019,14833,10763,81730,18474,30467,23810,17449,10078,52859,16297,20979,38137,11819,14547,10910,12081,11278,10751,40140,38699,24884,10180,10951,36251,26798,17401,78268,30239,14633,56830,44256,15366,16957,37175,16386,18207,18813,75421,34050,79880,80032,15421,15128,10140,25361,25439) [ RunTime:0.011190s ]
- [ 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' => 976,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT `cid` FROM `cmf_nami_competitions` WHERE `pinyin` = 'all' AND `com_type` = 0 LIMIT 1 [ RunTime:0.002901s ]
- [ 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' => 3710,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_matches` WHERE ( `match_time` > 1711675981 ) ORDER BY `match_time` ASC LIMIT 500 [ RunTime:0.003656s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_matches',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'match_time',
'key' => 'match_time',
'key_len' => '5',
'ref' => NULL,
'rows' => 25868,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` IN (1924,299,1925,3194,3974,2115,613,466,1886,601,3900,3986,1871,602,5118,1926,586,546,3874,241,1664,591,590,263,1890,31,1687,260,1660,3120,276,3124,24,349,255,567,3075,90,254,3333,2015,5,12,464,862,2915,675,1679,1867,1676,3240,371,548,249,152,1819,1666,2064,1733,59,4071,3957,2846,435,20,65,542,3,187,364,186,332,132,1675,2856,2244,3493,96,370,361,303,83,388,1862,274,1667,348,1719,1745,88,344,368,359,298,1671,1668,286,2836,1663,1788,3141,354,336,3008,674,293,3060,345,296,337,2791,213,992,1906,97,2857,425,3019,330,1750,84,85,86,87,385,89,91,2914,386,13,2168,237,3527,4413,1824,576,473,217,151,270,69,1739,47,32,52,301,3478,275,238,15) [ RunTime:0.003440s ]
- [ 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' => 150,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` IN (1924,299,1925,3194,3974,2115,613,466,1886,601,3900,3986,1871,602,5118,1926,586,546,3874,241,1664,591,590,263,1890,31,1687,260,1660,3120,276,3124,24,349,255,567,3075,90,254,3333,2015,5,12,464,862,2915,675,1679,1867,1676,3240,371,548,249,152,1819,1666,2064,1733,59,4071,3957,2846,435,20,65,542,3,187,364,186,332,132,1675,2856,2244,3493,96,370,361,303,83,388,1862,274,1667,348,1719,1745,88,344,368,359,298,1671,1668,286,2836,1663,1788,3141,354,336,3008,674,293,3060,345,296,337,2791,213,992,1906,97,2857,425,3019,330,1750,84,85,86,87,385,89,91,2914,386,13,2168,237,3527,4413,1824,576,473,217,151,270,69,1739,47,32,52,301,3478,275,238,15) [ RunTime:0.002522s ]
- [ 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' => 150,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT `cid`,`short_name_zh` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (36166,31419,35505,35569,40321,17251,72507,25957,13414,44718,33693,20742,34088,26445,80936,27575,31537,34244,21919,26407,18779,14774,40444,14640,26176,26024,46541,81502,46442,81718,26040,69555,22574,18736,40781,26800,39776,21447,38129,39238,22344,21910,14959,15569,80192,24804,22124,30655,46960,37625,10938,30138,21425,36366,17754,24120,21211,58100,42566,18190,47867,15332,18402,17203,73062,20181,12297,42449,42312,10387,38273,57786,41528,76334,10327,28715,23974,23804,61773,14650,52416,16361,57924,38554,30329,81550,10164,81595,37173,30323,10315,38744,15402,36466,40362,20213,52818,74593,23187,57213,80554,16621,44042,76571,36242,37840,37624,71759,71605,25978,12475,37640,81014,71476,20572,62499,30823,31020,42508,26054,23763,16909,33808,12538,46229,76418,12047,31791,36824,36758,43423,11543,81459,10939,41063,38312,20691,13490,62501,40291,16893,24222,34331,10202,10152,12469,30263,20211,45373,10360,10273,10726,10793,20163,58202,19200,42676,71647,12669,18413,10959,19352,32484,74479,17905,18305,24464,10972,11024,51845,36549,14072,44877,23823,72716,11102,48139,56110,25353,31227,52893,17046,11385,11631,26177,21622,16446,10130,19699,34976,32158,10735,22698,11039,12627,13262,18885,38491,34066,48481,12865,12548,26713,32757,18968,35098,31602,10681,18314,13076,29936,11472,19802,16955,36049,28296,19157,42091,42087,18600,61875,56535,23111,40284,24459,10540,34877,49637,28256,22277,10740,42314,36371,17080,31973,53944,32847,36931,62187,41181,36003,16971,61456,68190,52702,48646,25200,58539,72595,19497,16738,19815,45468,34714,54021,44817,29119,40438,31751,34466,14725,29334,33675,22717,27088,58204,20212,52161,19191,20112,72482,11444,12553,13058,13057,17260,60539,34067,20479,47464,30180,10896,10394,45139,45453,14523,10393,33270,22519,32179,20416,36006,17035,68753,73121,45782,52932,34929,12779,24212,32978,20818,21095,53127,47427,21271,21212,58667,34788,59894,59889,79309,79498,16470,69964,51066,11206,28737,28200,24000,31633,14660,13290,27681,16350,12022,25023,29345,46977,18403,17121,34748,13583,12885,54482,13450,81720,17234,13477,13277,13269,13373,21759,20611,10023,10114,10538,10184,10174,10290,10101,10182,10129,10011,11352,11997,12913,10127,11501,10177,11117,10862,10248,11115,10861,11843,11963,10102,10536,11842,10734,10225,10495,24781,10535,10498,15138,20391,10732,18760,10537,11526,16129,10497,14755,25328,16655,11119,11179,15596,14595,11113,15566,11862,13493,11413,11502,33003,12019,11480,16214,11966,10569,20711,13143,17115,14997,17061,11841,19199,27633,11365,18876,14593,17022,24925,24978,16357,20186,19595,23213,17775,17024,24881,40285,36012,22408,30890,13183,62461,47225,37373,12638,10687,50761,10957,10999,75419,10973,50906,73469,77428,11826,13128,41015,19151,10749,80910,17291,11944,19582,26475,23224,10328,17452,11838,32896,23993,14759,14550,11279,11281,25360,12591,25197,11280,11013,11201,12580,75426,16356,55216,56788,54117,69583,26751,21094,12978,17305,48049,33178,16112,76264,55055,79883,79881,10404,10628,10648,11276,12420,45393,13540,60887,35198,14734,45392,76679,35101,31426,42064,37495,12954,14309,27663,81471,74386,34245,26381,69829,22573,41438,18729,15558,21055,34287,81500,45514,81504,27339,69552,32839,18390,16394,21342,39775,50726,39025,81623,37623,40556,25461,28213,53616,28420,29054,23931,22522,48554,10944,72912,30202,38627,59772,32719,15670,22648,22520,41116,50725,21333,15331,19225,40897,15586,36430,23580,20339,18980,37975,29156,12477,28556,20273,28714,40341,45735,17569,56244,21864,10780,21138,36010,72701,34741,10104,81626,40648,81415,27026,25636,30234,30543,20053,76452,16058,24558,39718,36387,49081,62854,46648,58540,29340,22014,30665,52928,38081,25833,34514,53876,24584,10899,33767,47299,28608,19917,53005,34332,13391,21191,74594,30404,21993,37451,35779,25450,43420,25279,81382,38644,41064,38082,37144,44885,57215,15018,23777,26866,68578,10254,10200,12123,12641,11244,13157,10725,10729,10721,59214,36040,12860,58017,23070,22971,27378,14679,19948,31853,14912,13666,12661,19700,10436,26993,18927,36547,20198,12473,27921,56888,40230,35004,81728,40569,23159,52456,22912,10508,12252,30617,10679,10509,10247,12352,34812,25034,50029,18884,23778,27924,34515,11678,37015,40234,69270,56970,31900,32738,19413,19780,22429,40377,10005,15603,10961,15164,19501,17976,31901,17043,14815,25751,29779,17055,18606,35857,69575,74412,24919,45413,14343,35175,49641,27275,75274,45131,65571,61547,61484,49969,13212,16817,38662,16701,44950,15324,23419,17107,22559,38264,37740,53441,57590,36908,52704,32700,58365,81628,41062,26815,71434,81729,23410,32115,34126,31764,23036,38738,26997,35945,58206,20162,19404,19938,41977,16674,27712,71356,21630,26365,27611,74844,20549,60537,17205,66997,11401,23633,15578,23015,51882,16450,12349,49039,26665,23225,57577,15419,39765,44974,73120,23132,39768,12971,35588,72604,24294,22062,23223,17372,15325,21272,49916,23540,54783,33711,81719,78014,38114,53580,77991,13068,30480,24162,27680,16025,18942,23148,26572,12808,11051,37557,31293,62838,53132,17813,47510,48197,18598,73371,41221,18820,57557,47060,15381,37744,20079,17664,30853,10024,10245,10246,10256,10173,10008,11844,10004,10860,10128,10179,11527,12503,11861,11114,11428,10571,10007,11412,10185,11411,15798,11116,11319,11429,10533,10817,10178,11781,13254,12504,10570,10859,14652,11530,11528,73352,12949,12018,25123,18938,11112,16128,10103,17113,10728,20740,42832,10573,24378,10796,13857,22565,19298,11180,15799,14134,23207,15736,12057,13141,19444,14655,20344,10534,14983,77501,31528,78640,26877,15604,22048,17027,20915,17398,11622,13145,27781,11964,18302,52861,12345,68579,60367,76111,13033,10301,13060,25725,21814,11001,10958,76257,15475,35100,78172,40483,72461,78893,41019,14833,10763,81730,18474,30467,23810,17449,10078,52859,16297,20979,38137,11819,14547,10910,12081,11278,10751,40140,38699,24884,10180,10951,36251,26798,17401,78268,30239,14633,56830,44256,15366,16957,37175,16386,18207,18813,75421,34050,79880,80032,15421,15128,10140,25361,25439) [ RunTime:0.010570s ]
- [ 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' => 976,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT `cid`,`name_zh` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (36166,31419,35505,35569,40321,17251,72507,25957,13414,44718,33693,20742,34088,26445,80936,27575,31537,34244,21919,26407,18779,14774,40444,14640,26176,26024,46541,81502,46442,81718,26040,69555,22574,18736,40781,26800,39776,21447,38129,39238,22344,21910,14959,15569,80192,24804,22124,30655,46960,37625,10938,30138,21425,36366,17754,24120,21211,58100,42566,18190,47867,15332,18402,17203,73062,20181,12297,42449,42312,10387,38273,57786,41528,76334,10327,28715,23974,23804,61773,14650,52416,16361,57924,38554,30329,81550,10164,81595,37173,30323,10315,38744,15402,36466,40362,20213,52818,74593,23187,57213,80554,16621,44042,76571,36242,37840,37624,71759,71605,25978,12475,37640,81014,71476,20572,62499,30823,31020,42508,26054,23763,16909,33808,12538,46229,76418,12047,31791,36824,36758,43423,11543,81459,10939,41063,38312,20691,13490,62501,40291,16893,24222,34331,10202,10152,12469,30263,20211,45373,10360,10273,10726,10793,20163,58202,19200,42676,71647,12669,18413,10959,19352,32484,74479,17905,18305,24464,10972,11024,51845,36549,14072,44877,23823,72716,11102,48139,56110,25353,31227,52893,17046,11385,11631,26177,21622,16446,10130,19699,34976,32158,10735,22698,11039,12627,13262,18885,38491,34066,48481,12865,12548,26713,32757,18968,35098,31602,10681,18314,13076,29936,11472,19802,16955,36049,28296,19157,42091,42087,18600,61875,56535,23111,40284,24459,10540,34877,49637,28256,22277,10740,42314,36371,17080,31973,53944,32847,36931,62187,41181,36003,16971,61456,68190,52702,48646,25200,58539,72595,19497,16738,19815,45468,34714,54021,44817,29119,40438,31751,34466,14725,29334,33675,22717,27088,58204,20212,52161,19191,20112,72482,11444,12553,13058,13057,17260,60539,34067,20479,47464,30180,10896,10394,45139,45453,14523,10393,33270,22519,32179,20416,36006,17035,68753,73121,45782,52932,34929,12779,24212,32978,20818,21095,53127,47427,21271,21212,58667,34788,59894,59889,79309,79498,16470,69964,51066,11206,28737,28200,24000,31633,14660,13290,27681,16350,12022,25023,29345,46977,18403,17121,34748,13583,12885,54482,13450,81720,17234,13477,13277,13269,13373,21759,20611,10023,10114,10538,10184,10174,10290,10101,10182,10129,10011,11352,11997,12913,10127,11501,10177,11117,10862,10248,11115,10861,11843,11963,10102,10536,11842,10734,10225,10495,24781,10535,10498,15138,20391,10732,18760,10537,11526,16129,10497,14755,25328,16655,11119,11179,15596,14595,11113,15566,11862,13493,11413,11502,33003,12019,11480,16214,11966,10569,20711,13143,17115,14997,17061,11841,19199,27633,11365,18876,14593,17022,24925,24978,16357,20186,19595,23213,17775,17024,24881,40285,36012,22408,30890,13183,62461,47225,37373,12638,10687,50761,10957,10999,75419,10973,50906,73469,77428,11826,13128,41015,19151,10749,80910,17291,11944,19582,26475,23224,10328,17452,11838,32896,23993,14759,14550,11279,11281,25360,12591,25197,11280,11013,11201,12580,75426,16356,55216,56788,54117,69583,26751,21094,12978,17305,48049,33178,16112,76264,55055,79883,79881,10404,10628,10648,11276,12420,45393,13540,60887,35198,14734,45392,76679,35101,31426,42064,37495,12954,14309,27663,81471,74386,34245,26381,69829,22573,41438,18729,15558,21055,34287,81500,45514,81504,27339,69552,32839,18390,16394,21342,39775,50726,39025,81623,37623,40556,25461,28213,53616,28420,29054,23931,22522,48554,10944,72912,30202,38627,59772,32719,15670,22648,22520,41116,50725,21333,15331,19225,40897,15586,36430,23580,20339,18980,37975,29156,12477,28556,20273,28714,40341,45735,17569,56244,21864,10780,21138,36010,72701,34741,10104,81626,40648,81415,27026,25636,30234,30543,20053,76452,16058,24558,39718,36387,49081,62854,46648,58540,29340,22014,30665,52928,38081,25833,34514,53876,24584,10899,33767,47299,28608,19917,53005,34332,13391,21191,74594,30404,21993,37451,35779,25450,43420,25279,81382,38644,41064,38082,37144,44885,57215,15018,23777,26866,68578,10254,10200,12123,12641,11244,13157,10725,10729,10721,59214,36040,12860,58017,23070,22971,27378,14679,19948,31853,14912,13666,12661,19700,10436,26993,18927,36547,20198,12473,27921,56888,40230,35004,81728,40569,23159,52456,22912,10508,12252,30617,10679,10509,10247,12352,34812,25034,50029,18884,23778,27924,34515,11678,37015,40234,69270,56970,31900,32738,19413,19780,22429,40377,10005,15603,10961,15164,19501,17976,31901,17043,14815,25751,29779,17055,18606,35857,69575,74412,24919,45413,14343,35175,49641,27275,75274,45131,65571,61547,61484,49969,13212,16817,38662,16701,44950,15324,23419,17107,22559,38264,37740,53441,57590,36908,52704,32700,58365,81628,41062,26815,71434,81729,23410,32115,34126,31764,23036,38738,26997,35945,58206,20162,19404,19938,41977,16674,27712,71356,21630,26365,27611,74844,20549,60537,17205,66997,11401,23633,15578,23015,51882,16450,12349,49039,26665,23225,57577,15419,39765,44974,73120,23132,39768,12971,35588,72604,24294,22062,23223,17372,15325,21272,49916,23540,54783,33711,81719,78014,38114,53580,77991,13068,30480,24162,27680,16025,18942,23148,26572,12808,11051,37557,31293,62838,53132,17813,47510,48197,18598,73371,41221,18820,57557,47060,15381,37744,20079,17664,30853,10024,10245,10246,10256,10173,10008,11844,10004,10860,10128,10179,11527,12503,11861,11114,11428,10571,10007,11412,10185,11411,15798,11116,11319,11429,10533,10817,10178,11781,13254,12504,10570,10859,14652,11530,11528,73352,12949,12018,25123,18938,11112,16128,10103,17113,10728,20740,42832,10573,24378,10796,13857,22565,19298,11180,15799,14134,23207,15736,12057,13141,19444,14655,20344,10534,14983,77501,31528,78640,26877,15604,22048,17027,20915,17398,11622,13145,27781,11964,18302,52861,12345,68579,60367,76111,13033,10301,13060,25725,21814,11001,10958,76257,15475,35100,78172,40483,72461,78893,41019,14833,10763,81730,18474,30467,23810,17449,10078,52859,16297,20979,38137,11819,14547,10910,12081,11278,10751,40140,38699,24884,10180,10951,36251,26798,17401,78268,30239,14633,56830,44256,15366,16957,37175,16386,18207,18813,75421,34050,79880,80032,15421,15128,10140,25361,25439) [ RunTime:0.012021s ]
- [ 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' => 976,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT `cid`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (36166,31419,35505,35569,40321,17251,72507,25957,13414,44718,33693,20742,34088,26445,80936,27575,31537,34244,21919,26407,18779,14774,40444,14640,26176,26024,46541,81502,46442,81718,26040,69555,22574,18736,40781,26800,39776,21447,38129,39238,22344,21910,14959,15569,80192,24804,22124,30655,46960,37625,10938,30138,21425,36366,17754,24120,21211,58100,42566,18190,47867,15332,18402,17203,73062,20181,12297,42449,42312,10387,38273,57786,41528,76334,10327,28715,23974,23804,61773,14650,52416,16361,57924,38554,30329,81550,10164,81595,37173,30323,10315,38744,15402,36466,40362,20213,52818,74593,23187,57213,80554,16621,44042,76571,36242,37840,37624,71759,71605,25978,12475,37640,81014,71476,20572,62499,30823,31020,42508,26054,23763,16909,33808,12538,46229,76418,12047,31791,36824,36758,43423,11543,81459,10939,41063,38312,20691,13490,62501,40291,16893,24222,34331,10202,10152,12469,30263,20211,45373,10360,10273,10726,10793,20163,58202,19200,42676,71647,12669,18413,10959,19352,32484,74479,17905,18305,24464,10972,11024,51845,36549,14072,44877,23823,72716,11102,48139,56110,25353,31227,52893,17046,11385,11631,26177,21622,16446,10130,19699,34976,32158,10735,22698,11039,12627,13262,18885,38491,34066,48481,12865,12548,26713,32757,18968,35098,31602,10681,18314,13076,29936,11472,19802,16955,36049,28296,19157,42091,42087,18600,61875,56535,23111,40284,24459,10540,34877,49637,28256,22277,10740,42314,36371,17080,31973,53944,32847,36931,62187,41181,36003,16971,61456,68190,52702,48646,25200,58539,72595,19497,16738,19815,45468,34714,54021,44817,29119,40438,31751,34466,14725,29334,33675,22717,27088,58204,20212,52161,19191,20112,72482,11444,12553,13058,13057,17260,60539,34067,20479,47464,30180,10896,10394,45139,45453,14523,10393,33270,22519,32179,20416,36006,17035,68753,73121,45782,52932,34929,12779,24212,32978,20818,21095,53127,47427,21271,21212,58667,34788,59894,59889,79309,79498,16470,69964,51066,11206,28737,28200,24000,31633,14660,13290,27681,16350,12022,25023,29345,46977,18403,17121,34748,13583,12885,54482,13450,81720,17234,13477,13277,13269,13373,21759,20611,10023,10114,10538,10184,10174,10290,10101,10182,10129,10011,11352,11997,12913,10127,11501,10177,11117,10862,10248,11115,10861,11843,11963,10102,10536,11842,10734,10225,10495,24781,10535,10498,15138,20391,10732,18760,10537,11526,16129,10497,14755,25328,16655,11119,11179,15596,14595,11113,15566,11862,13493,11413,11502,33003,12019,11480,16214,11966,10569,20711,13143,17115,14997,17061,11841,19199,27633,11365,18876,14593,17022,24925,24978,16357,20186,19595,23213,17775,17024,24881,40285,36012,22408,30890,13183,62461,47225,37373,12638,10687,50761,10957,10999,75419,10973,50906,73469,77428,11826,13128,41015,19151,10749,80910,17291,11944,19582,26475,23224,10328,17452,11838,32896,23993,14759,14550,11279,11281,25360,12591,25197,11280,11013,11201,12580,75426,16356,55216,56788,54117,69583,26751,21094,12978,17305,48049,33178,16112,76264,55055,79883,79881,10404,10628,10648,11276,12420,45393,13540,60887,35198,14734,45392,76679,35101,31426,42064,37495,12954,14309,27663,81471,74386,34245,26381,69829,22573,41438,18729,15558,21055,34287,81500,45514,81504,27339,69552,32839,18390,16394,21342,39775,50726,39025,81623,37623,40556,25461,28213,53616,28420,29054,23931,22522,48554,10944,72912,30202,38627,59772,32719,15670,22648,22520,41116,50725,21333,15331,19225,40897,15586,36430,23580,20339,18980,37975,29156,12477,28556,20273,28714,40341,45735,17569,56244,21864,10780,21138,36010,72701,34741,10104,81626,40648,81415,27026,25636,30234,30543,20053,76452,16058,24558,39718,36387,49081,62854,46648,58540,29340,22014,30665,52928,38081,25833,34514,53876,24584,10899,33767,47299,28608,19917,53005,34332,13391,21191,74594,30404,21993,37451,35779,25450,43420,25279,81382,38644,41064,38082,37144,44885,57215,15018,23777,26866,68578,10254,10200,12123,12641,11244,13157,10725,10729,10721,59214,36040,12860,58017,23070,22971,27378,14679,19948,31853,14912,13666,12661,19700,10436,26993,18927,36547,20198,12473,27921,56888,40230,35004,81728,40569,23159,52456,22912,10508,12252,30617,10679,10509,10247,12352,34812,25034,50029,18884,23778,27924,34515,11678,37015,40234,69270,56970,31900,32738,19413,19780,22429,40377,10005,15603,10961,15164,19501,17976,31901,17043,14815,25751,29779,17055,18606,35857,69575,74412,24919,45413,14343,35175,49641,27275,75274,45131,65571,61547,61484,49969,13212,16817,38662,16701,44950,15324,23419,17107,22559,38264,37740,53441,57590,36908,52704,32700,58365,81628,41062,26815,71434,81729,23410,32115,34126,31764,23036,38738,26997,35945,58206,20162,19404,19938,41977,16674,27712,71356,21630,26365,27611,74844,20549,60537,17205,66997,11401,23633,15578,23015,51882,16450,12349,49039,26665,23225,57577,15419,39765,44974,73120,23132,39768,12971,35588,72604,24294,22062,23223,17372,15325,21272,49916,23540,54783,33711,81719,78014,38114,53580,77991,13068,30480,24162,27680,16025,18942,23148,26572,12808,11051,37557,31293,62838,53132,17813,47510,48197,18598,73371,41221,18820,57557,47060,15381,37744,20079,17664,30853,10024,10245,10246,10256,10173,10008,11844,10004,10860,10128,10179,11527,12503,11861,11114,11428,10571,10007,11412,10185,11411,15798,11116,11319,11429,10533,10817,10178,11781,13254,12504,10570,10859,14652,11530,11528,73352,12949,12018,25123,18938,11112,16128,10103,17113,10728,20740,42832,10573,24378,10796,13857,22565,19298,11180,15799,14134,23207,15736,12057,13141,19444,14655,20344,10534,14983,77501,31528,78640,26877,15604,22048,17027,20915,17398,11622,13145,27781,11964,18302,52861,12345,68579,60367,76111,13033,10301,13060,25725,21814,11001,10958,76257,15475,35100,78172,40483,72461,78893,41019,14833,10763,81730,18474,30467,23810,17449,10078,52859,16297,20979,38137,11819,14547,10910,12081,11278,10751,40140,38699,24884,10180,10951,36251,26798,17401,78268,30239,14633,56830,44256,15366,16957,37175,16386,18207,18813,75421,34050,79880,80032,15421,15128,10140,25361,25439) [ RunTime:0.009910s ]
- [ 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' => 976,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT `cid`,`short_name_zh` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (36166,31419,35505,35569,40321,17251,72507,25957,13414,44718,33693,20742,34088,26445,80936,27575,31537,34244,21919,26407,18779,14774,40444,14640,26176,26024,46541,81502,46442,81718,26040,69555,22574,18736,40781,26800,39776,21447,38129,39238,22344,21910,14959,15569,80192,24804,22124,30655,46960,37625,10938,30138,21425,36366,17754,24120,21211,58100,42566,18190,47867,15332,18402,17203,73062,20181,12297,42449,42312,10387,38273,57786,41528,76334,10327,28715,23974,23804,61773,14650,52416,16361,57924,38554,30329,81550,10164,81595,37173,30323,10315,38744,15402,36466,40362,20213,52818,74593,23187,57213,80554,16621,44042,76571,36242,37840,37624,71759,71605,25978,12475,37640,81014,71476,20572,62499,30823,31020,42508,26054,23763,16909,33808,12538,46229,76418,12047,31791,36824,36758,43423,11543,81459,10939,41063,38312,20691,13490,62501,40291,16893,24222,34331,10202,10152,12469,30263,20211,45373,10360,10273,10726,10793,20163,58202,19200,42676,71647,12669,18413,10959,19352,32484,74479,17905,18305,24464,10972,11024,51845,36549,14072,44877,23823,72716,11102,48139,56110,25353,31227,52893,17046,11385,11631,26177,21622,16446,10130,19699,34976,32158,10735,22698,11039,12627,13262,18885,38491,34066,48481,12865,12548,26713,32757,18968,35098,31602,10681,18314,13076,29936,11472,19802,16955,36049,28296,19157,42091,42087,18600,61875,56535,23111,40284,24459,10540,34877,49637,28256,22277,10740,42314,36371,17080,31973,53944,32847,36931,62187,41181,36003,16971,61456,68190,52702,48646,25200,58539,72595,19497,16738,19815,45468,34714,54021,44817,29119,40438,31751,34466,14725,29334,33675,22717,27088,58204,20212,52161,19191,20112,72482,11444,12553,13058,13057,17260,60539,34067,20479,47464,30180,10896,10394,45139,45453,14523,10393,33270,22519,32179,20416,36006,17035,68753,73121,45782,52932,34929,12779,24212,32978,20818,21095,53127,47427,21271,21212,58667,34788,59894,59889,79309,79498,16470,69964,51066,11206,28737,28200,24000,31633,14660,13290,27681,16350,12022,25023,29345,46977,18403,17121,34748,13583,12885,54482,13450,81720,17234,13477,13277,13269,13373,21759,20611,10023,10114,10538,10184,10174,10290,10101,10182,10129,10011,11352,11997,12913,10127,11501,10177,11117,10862,10248,11115,10861,11843,11963,10102,10536,11842,10734,10225,10495,24781,10535,10498,15138,20391,10732,18760,10537,11526,16129,10497,14755,25328,16655,11119,11179,15596,14595,11113,15566,11862,13493,11413,11502,33003,12019,11480,16214,11966,10569,20711,13143,17115,14997,17061,11841,19199,27633,11365,18876,14593,17022,24925,24978,16357,20186,19595,23213,17775,17024,24881,40285,36012,22408,30890,13183,62461,47225,37373,12638,10687,50761,10957,10999,75419,10973,50906,73469,77428,11826,13128,41015,19151,10749,80910,17291,11944,19582,26475,23224,10328,17452,11838,32896,23993,14759,14550,11279,11281,25360,12591,25197,11280,11013,11201,12580,75426,16356,55216,56788,54117,69583,26751,21094,12978,17305,48049,33178,16112,76264,55055,79883,79881,10404,10628,10648,11276,12420,45393,13540,60887,35198,14734,45392,76679,35101,31426,42064,37495,12954,14309,27663,81471,74386,34245,26381,69829,22573,41438,18729,15558,21055,34287,81500,45514,81504,27339,69552,32839,18390,16394,21342,39775,50726,39025,81623,37623,40556,25461,28213,53616,28420,29054,23931,22522,48554,10944,72912,30202,38627,59772,32719,15670,22648,22520,41116,50725,21333,15331,19225,40897,15586,36430,23580,20339,18980,37975,29156,12477,28556,20273,28714,40341,45735,17569,56244,21864,10780,21138,36010,72701,34741,10104,81626,40648,81415,27026,25636,30234,30543,20053,76452,16058,24558,39718,36387,49081,62854,46648,58540,29340,22014,30665,52928,38081,25833,34514,53876,24584,10899,33767,47299,28608,19917,53005,34332,13391,21191,74594,30404,21993,37451,35779,25450,43420,25279,81382,38644,41064,38082,37144,44885,57215,15018,23777,26866,68578,10254,10200,12123,12641,11244,13157,10725,10729,10721,59214,36040,12860,58017,23070,22971,27378,14679,19948,31853,14912,13666,12661,19700,10436,26993,18927,36547,20198,12473,27921,56888,40230,35004,81728,40569,23159,52456,22912,10508,12252,30617,10679,10509,10247,12352,34812,25034,50029,18884,23778,27924,34515,11678,37015,40234,69270,56970,31900,32738,19413,19780,22429,40377,10005,15603,10961,15164,19501,17976,31901,17043,14815,25751,29779,17055,18606,35857,69575,74412,24919,45413,14343,35175,49641,27275,75274,45131,65571,61547,61484,49969,13212,16817,38662,16701,44950,15324,23419,17107,22559,38264,37740,53441,57590,36908,52704,32700,58365,81628,41062,26815,71434,81729,23410,32115,34126,31764,23036,38738,26997,35945,58206,20162,19404,19938,41977,16674,27712,71356,21630,26365,27611,74844,20549,60537,17205,66997,11401,23633,15578,23015,51882,16450,12349,49039,26665,23225,57577,15419,39765,44974,73120,23132,39768,12971,35588,72604,24294,22062,23223,17372,15325,21272,49916,23540,54783,33711,81719,78014,38114,53580,77991,13068,30480,24162,27680,16025,18942,23148,26572,12808,11051,37557,31293,62838,53132,17813,47510,48197,18598,73371,41221,18820,57557,47060,15381,37744,20079,17664,30853,10024,10245,10246,10256,10173,10008,11844,10004,10860,10128,10179,11527,12503,11861,11114,11428,10571,10007,11412,10185,11411,15798,11116,11319,11429,10533,10817,10178,11781,13254,12504,10570,10859,14652,11530,11528,73352,12949,12018,25123,18938,11112,16128,10103,17113,10728,20740,42832,10573,24378,10796,13857,22565,19298,11180,15799,14134,23207,15736,12057,13141,19444,14655,20344,10534,14983,77501,31528,78640,26877,15604,22048,17027,20915,17398,11622,13145,27781,11964,18302,52861,12345,68579,60367,76111,13033,10301,13060,25725,21814,11001,10958,76257,15475,35100,78172,40483,72461,78893,41019,14833,10763,81730,18474,30467,23810,17449,10078,52859,16297,20979,38137,11819,14547,10910,12081,11278,10751,40140,38699,24884,10180,10951,36251,26798,17401,78268,30239,14633,56830,44256,15366,16957,37175,16386,18207,18813,75421,34050,79880,80032,15421,15128,10140,25361,25439) [ RunTime:0.011410s ]
- [ 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' => 976,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT `cid`,`name_zh` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (36166,31419,35505,35569,40321,17251,72507,25957,13414,44718,33693,20742,34088,26445,80936,27575,31537,34244,21919,26407,18779,14774,40444,14640,26176,26024,46541,81502,46442,81718,26040,69555,22574,18736,40781,26800,39776,21447,38129,39238,22344,21910,14959,15569,80192,24804,22124,30655,46960,37625,10938,30138,21425,36366,17754,24120,21211,58100,42566,18190,47867,15332,18402,17203,73062,20181,12297,42449,42312,10387,38273,57786,41528,76334,10327,28715,23974,23804,61773,14650,52416,16361,57924,38554,30329,81550,10164,81595,37173,30323,10315,38744,15402,36466,40362,20213,52818,74593,23187,57213,80554,16621,44042,76571,36242,37840,37624,71759,71605,25978,12475,37640,81014,71476,20572,62499,30823,31020,42508,26054,23763,16909,33808,12538,46229,76418,12047,31791,36824,36758,43423,11543,81459,10939,41063,38312,20691,13490,62501,40291,16893,24222,34331,10202,10152,12469,30263,20211,45373,10360,10273,10726,10793,20163,58202,19200,42676,71647,12669,18413,10959,19352,32484,74479,17905,18305,24464,10972,11024,51845,36549,14072,44877,23823,72716,11102,48139,56110,25353,31227,52893,17046,11385,11631,26177,21622,16446,10130,19699,34976,32158,10735,22698,11039,12627,13262,18885,38491,34066,48481,12865,12548,26713,32757,18968,35098,31602,10681,18314,13076,29936,11472,19802,16955,36049,28296,19157,42091,42087,18600,61875,56535,23111,40284,24459,10540,34877,49637,28256,22277,10740,42314,36371,17080,31973,53944,32847,36931,62187,41181,36003,16971,61456,68190,52702,48646,25200,58539,72595,19497,16738,19815,45468,34714,54021,44817,29119,40438,31751,34466,14725,29334,33675,22717,27088,58204,20212,52161,19191,20112,72482,11444,12553,13058,13057,17260,60539,34067,20479,47464,30180,10896,10394,45139,45453,14523,10393,33270,22519,32179,20416,36006,17035,68753,73121,45782,52932,34929,12779,24212,32978,20818,21095,53127,47427,21271,21212,58667,34788,59894,59889,79309,79498,16470,69964,51066,11206,28737,28200,24000,31633,14660,13290,27681,16350,12022,25023,29345,46977,18403,17121,34748,13583,12885,54482,13450,81720,17234,13477,13277,13269,13373,21759,20611,10023,10114,10538,10184,10174,10290,10101,10182,10129,10011,11352,11997,12913,10127,11501,10177,11117,10862,10248,11115,10861,11843,11963,10102,10536,11842,10734,10225,10495,24781,10535,10498,15138,20391,10732,18760,10537,11526,16129,10497,14755,25328,16655,11119,11179,15596,14595,11113,15566,11862,13493,11413,11502,33003,12019,11480,16214,11966,10569,20711,13143,17115,14997,17061,11841,19199,27633,11365,18876,14593,17022,24925,24978,16357,20186,19595,23213,17775,17024,24881,40285,36012,22408,30890,13183,62461,47225,37373,12638,10687,50761,10957,10999,75419,10973,50906,73469,77428,11826,13128,41015,19151,10749,80910,17291,11944,19582,26475,23224,10328,17452,11838,32896,23993,14759,14550,11279,11281,25360,12591,25197,11280,11013,11201,12580,75426,16356,55216,56788,54117,69583,26751,21094,12978,17305,48049,33178,16112,76264,55055,79883,79881,10404,10628,10648,11276,12420,45393,13540,60887,35198,14734,45392,76679,35101,31426,42064,37495,12954,14309,27663,81471,74386,34245,26381,69829,22573,41438,18729,15558,21055,34287,81500,45514,81504,27339,69552,32839,18390,16394,21342,39775,50726,39025,81623,37623,40556,25461,28213,53616,28420,29054,23931,22522,48554,10944,72912,30202,38627,59772,32719,15670,22648,22520,41116,50725,21333,15331,19225,40897,15586,36430,23580,20339,18980,37975,29156,12477,28556,20273,28714,40341,45735,17569,56244,21864,10780,21138,36010,72701,34741,10104,81626,40648,81415,27026,25636,30234,30543,20053,76452,16058,24558,39718,36387,49081,62854,46648,58540,29340,22014,30665,52928,38081,25833,34514,53876,24584,10899,33767,47299,28608,19917,53005,34332,13391,21191,74594,30404,21993,37451,35779,25450,43420,25279,81382,38644,41064,38082,37144,44885,57215,15018,23777,26866,68578,10254,10200,12123,12641,11244,13157,10725,10729,10721,59214,36040,12860,58017,23070,22971,27378,14679,19948,31853,14912,13666,12661,19700,10436,26993,18927,36547,20198,12473,27921,56888,40230,35004,81728,40569,23159,52456,22912,10508,12252,30617,10679,10509,10247,12352,34812,25034,50029,18884,23778,27924,34515,11678,37015,40234,69270,56970,31900,32738,19413,19780,22429,40377,10005,15603,10961,15164,19501,17976,31901,17043,14815,25751,29779,17055,18606,35857,69575,74412,24919,45413,14343,35175,49641,27275,75274,45131,65571,61547,61484,49969,13212,16817,38662,16701,44950,15324,23419,17107,22559,38264,37740,53441,57590,36908,52704,32700,58365,81628,41062,26815,71434,81729,23410,32115,34126,31764,23036,38738,26997,35945,58206,20162,19404,19938,41977,16674,27712,71356,21630,26365,27611,74844,20549,60537,17205,66997,11401,23633,15578,23015,51882,16450,12349,49039,26665,23225,57577,15419,39765,44974,73120,23132,39768,12971,35588,72604,24294,22062,23223,17372,15325,21272,49916,23540,54783,33711,81719,78014,38114,53580,77991,13068,30480,24162,27680,16025,18942,23148,26572,12808,11051,37557,31293,62838,53132,17813,47510,48197,18598,73371,41221,18820,57557,47060,15381,37744,20079,17664,30853,10024,10245,10246,10256,10173,10008,11844,10004,10860,10128,10179,11527,12503,11861,11114,11428,10571,10007,11412,10185,11411,15798,11116,11319,11429,10533,10817,10178,11781,13254,12504,10570,10859,14652,11530,11528,73352,12949,12018,25123,18938,11112,16128,10103,17113,10728,20740,42832,10573,24378,10796,13857,22565,19298,11180,15799,14134,23207,15736,12057,13141,19444,14655,20344,10534,14983,77501,31528,78640,26877,15604,22048,17027,20915,17398,11622,13145,27781,11964,18302,52861,12345,68579,60367,76111,13033,10301,13060,25725,21814,11001,10958,76257,15475,35100,78172,40483,72461,78893,41019,14833,10763,81730,18474,30467,23810,17449,10078,52859,16297,20979,38137,11819,14547,10910,12081,11278,10751,40140,38699,24884,10180,10951,36251,26798,17401,78268,30239,14633,56830,44256,15366,16957,37175,16386,18207,18813,75421,34050,79880,80032,15421,15128,10140,25361,25439) [ RunTime:0.009226s ]
- [ 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' => 976,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT `cid`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (36166,31419,35505,35569,40321,17251,72507,25957,13414,44718,33693,20742,34088,26445,80936,27575,31537,34244,21919,26407,18779,14774,40444,14640,26176,26024,46541,81502,46442,81718,26040,69555,22574,18736,40781,26800,39776,21447,38129,39238,22344,21910,14959,15569,80192,24804,22124,30655,46960,37625,10938,30138,21425,36366,17754,24120,21211,58100,42566,18190,47867,15332,18402,17203,73062,20181,12297,42449,42312,10387,38273,57786,41528,76334,10327,28715,23974,23804,61773,14650,52416,16361,57924,38554,30329,81550,10164,81595,37173,30323,10315,38744,15402,36466,40362,20213,52818,74593,23187,57213,80554,16621,44042,76571,36242,37840,37624,71759,71605,25978,12475,37640,81014,71476,20572,62499,30823,31020,42508,26054,23763,16909,33808,12538,46229,76418,12047,31791,36824,36758,43423,11543,81459,10939,41063,38312,20691,13490,62501,40291,16893,24222,34331,10202,10152,12469,30263,20211,45373,10360,10273,10726,10793,20163,58202,19200,42676,71647,12669,18413,10959,19352,32484,74479,17905,18305,24464,10972,11024,51845,36549,14072,44877,23823,72716,11102,48139,56110,25353,31227,52893,17046,11385,11631,26177,21622,16446,10130,19699,34976,32158,10735,22698,11039,12627,13262,18885,38491,34066,48481,12865,12548,26713,32757,18968,35098,31602,10681,18314,13076,29936,11472,19802,16955,36049,28296,19157,42091,42087,18600,61875,56535,23111,40284,24459,10540,34877,49637,28256,22277,10740,42314,36371,17080,31973,53944,32847,36931,62187,41181,36003,16971,61456,68190,52702,48646,25200,58539,72595,19497,16738,19815,45468,34714,54021,44817,29119,40438,31751,34466,14725,29334,33675,22717,27088,58204,20212,52161,19191,20112,72482,11444,12553,13058,13057,17260,60539,34067,20479,47464,30180,10896,10394,45139,45453,14523,10393,33270,22519,32179,20416,36006,17035,68753,73121,45782,52932,34929,12779,24212,32978,20818,21095,53127,47427,21271,21212,58667,34788,59894,59889,79309,79498,16470,69964,51066,11206,28737,28200,24000,31633,14660,13290,27681,16350,12022,25023,29345,46977,18403,17121,34748,13583,12885,54482,13450,81720,17234,13477,13277,13269,13373,21759,20611,10023,10114,10538,10184,10174,10290,10101,10182,10129,10011,11352,11997,12913,10127,11501,10177,11117,10862,10248,11115,10861,11843,11963,10102,10536,11842,10734,10225,10495,24781,10535,10498,15138,20391,10732,18760,10537,11526,16129,10497,14755,25328,16655,11119,11179,15596,14595,11113,15566,11862,13493,11413,11502,33003,12019,11480,16214,11966,10569,20711,13143,17115,14997,17061,11841,19199,27633,11365,18876,14593,17022,24925,24978,16357,20186,19595,23213,17775,17024,24881,40285,36012,22408,30890,13183,62461,47225,37373,12638,10687,50761,10957,10999,75419,10973,50906,73469,77428,11826,13128,41015,19151,10749,80910,17291,11944,19582,26475,23224,10328,17452,11838,32896,23993,14759,14550,11279,11281,25360,12591,25197,11280,11013,11201,12580,75426,16356,55216,56788,54117,69583,26751,21094,12978,17305,48049,33178,16112,76264,55055,79883,79881,10404,10628,10648,11276,12420,45393,13540,60887,35198,14734,45392,76679,35101,31426,42064,37495,12954,14309,27663,81471,74386,34245,26381,69829,22573,41438,18729,15558,21055,34287,81500,45514,81504,27339,69552,32839,18390,16394,21342,39775,50726,39025,81623,37623,40556,25461,28213,53616,28420,29054,23931,22522,48554,10944,72912,30202,38627,59772,32719,15670,22648,22520,41116,50725,21333,15331,19225,40897,15586,36430,23580,20339,18980,37975,29156,12477,28556,20273,28714,40341,45735,17569,56244,21864,10780,21138,36010,72701,34741,10104,81626,40648,81415,27026,25636,30234,30543,20053,76452,16058,24558,39718,36387,49081,62854,46648,58540,29340,22014,30665,52928,38081,25833,34514,53876,24584,10899,33767,47299,28608,19917,53005,34332,13391,21191,74594,30404,21993,37451,35779,25450,43420,25279,81382,38644,41064,38082,37144,44885,57215,15018,23777,26866,68578,10254,10200,12123,12641,11244,13157,10725,10729,10721,59214,36040,12860,58017,23070,22971,27378,14679,19948,31853,14912,13666,12661,19700,10436,26993,18927,36547,20198,12473,27921,56888,40230,35004,81728,40569,23159,52456,22912,10508,12252,30617,10679,10509,10247,12352,34812,25034,50029,18884,23778,27924,34515,11678,37015,40234,69270,56970,31900,32738,19413,19780,22429,40377,10005,15603,10961,15164,19501,17976,31901,17043,14815,25751,29779,17055,18606,35857,69575,74412,24919,45413,14343,35175,49641,27275,75274,45131,65571,61547,61484,49969,13212,16817,38662,16701,44950,15324,23419,17107,22559,38264,37740,53441,57590,36908,52704,32700,58365,81628,41062,26815,71434,81729,23410,32115,34126,31764,23036,38738,26997,35945,58206,20162,19404,19938,41977,16674,27712,71356,21630,26365,27611,74844,20549,60537,17205,66997,11401,23633,15578,23015,51882,16450,12349,49039,26665,23225,57577,15419,39765,44974,73120,23132,39768,12971,35588,72604,24294,22062,23223,17372,15325,21272,49916,23540,54783,33711,81719,78014,38114,53580,77991,13068,30480,24162,27680,16025,18942,23148,26572,12808,11051,37557,31293,62838,53132,17813,47510,48197,18598,73371,41221,18820,57557,47060,15381,37744,20079,17664,30853,10024,10245,10246,10256,10173,10008,11844,10004,10860,10128,10179,11527,12503,11861,11114,11428,10571,10007,11412,10185,11411,15798,11116,11319,11429,10533,10817,10178,11781,13254,12504,10570,10859,14652,11530,11528,73352,12949,12018,25123,18938,11112,16128,10103,17113,10728,20740,42832,10573,24378,10796,13857,22565,19298,11180,15799,14134,23207,15736,12057,13141,19444,14655,20344,10534,14983,77501,31528,78640,26877,15604,22048,17027,20915,17398,11622,13145,27781,11964,18302,52861,12345,68579,60367,76111,13033,10301,13060,25725,21814,11001,10958,76257,15475,35100,78172,40483,72461,78893,41019,14833,10763,81730,18474,30467,23810,17449,10078,52859,16297,20979,38137,11819,14547,10910,12081,11278,10751,40140,38699,24884,10180,10951,36251,26798,17401,78268,30239,14633,56830,44256,15366,16957,37175,16386,18207,18813,75421,34050,79880,80032,15421,15128,10140,25361,25439) [ RunTime:0.011006s ]
- [ 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' => 976,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.mooktool.com%' LIMIT 1 [ RunTime:0.001393s ]
- [ 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' => 44,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `cid` FROM `cmf_nami_competition_hot` WHERE `site_id` = 31 LIMIT 20 [ RunTime:0.001279s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_competition_hot',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 136,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `id` IN ('') [ RunTime:0.001547s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => NULL,
'partitions' => NULL,
'type' => NULL,
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => NULL,
'filtered' => NULL,
'extra' => 'no matching row in const table',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.mooktool.com%' LIMIT 1 [ RunTime:0.002183s ]
- [ 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' => 44,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 211 [ RunTime:0.001318s ]
- [ 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' => 272,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.001528s ]
- [ SQL ] SELECT * FROM `cmf_portal_post` `post` WHERE `site_id` = 31 AND `post_status` = 1 AND `post_type` = 1 AND `delete_time` = 0 AND ( `category_id` IN (211,212,213) ) AND ( `published_time` > 0 and `published_time` < 1711690381 ) ORDER BY `post_hits` DESC LIMIT 0,4 [ RunTime:0.001562s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'post',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'type_status_date,category_id',
'key' => 'category_id',
'key_len' => '14',
'ref' => NULL,
'rows' => 29,
'filtered' => 1.110888957977295,
'extra' => 'Using index condition; Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.001400s ]
- [ 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' => 272,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_user` [ RunTime:0.001630s ]
- [ SQL ] SELECT `id`,`user_nickname` FROM `cmf_user` [ RunTime:0.001282s ]
- [ 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.001286s ]
- [ 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.001347s ]
- [ SQL ] SELECT `tag_id` FROM `cmf_portal_tag_post` WHERE `post_id` = 20133 [ RunTime:0.001340s ]
- [ 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' => 30,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_portal_tag` [ RunTime:0.001394s ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (8266,8269,8270,1880,136,1652,132,1878,1394,5635,2885,2574,3387,4610,4687,4673,4503,3404,4892,4371,28,2226,3651,3514,3919,3751,1110,2273,9397,10471) [ RunTime:0.001365s ]
- [ 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' => 30,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 212 LIMIT 1 [ RunTime:0.001287s ]
- [ 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` = 25227 [ RunTime:0.001311s ]
- [ 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' => 26,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (8266,8970,1648,1733,1731,45,8485,1882,2831,8706,8982,3009,4066,2797,4144,4351,5219,2810,8278,9180,8255,9211,9085,9425,8271,9062) [ RunTime:0.001447s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => NULL,
'rows' => 26,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 212 LIMIT 1 [ RunTime:0.001483s ]
- [ 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` = 18043 [ RunTime:0.001278s ]
- [ 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' => 15,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (8030,8031,8032,8033,8034,5291,5318,7775,7410,7765,7760,7770,9224,7755,49) [ RunTime:0.001385s ]
- [ 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' => 15,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 212 LIMIT 1 [ RunTime:0.001282s ]
- [ 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` = 18047 [ RunTime:0.001300s ]
- [ 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' => 15,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (8030,8031,8032,8033,8034,5291,5318,7775,7410,7765,7760,7770,9224,7755,49) [ RunTime:0.001366s ]
- [ 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' => 15,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 212 LIMIT 1 [ RunTime:0.001250s ]
- [ 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.mooktool.com%' LIMIT 1 [ RunTime:0.001266s ]
- [ 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' => 44,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 211 [ RunTime:0.001338s ]
- [ 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' => 272,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_portal_post` `post` WHERE `site_id` = 31 AND `post_status` = 1 AND `post_type` = 1 AND `delete_time` = 0 AND ( `category_id` IN (211,212,213) ) AND ( `published_time` > 0 and `published_time` < 1711690381 ) ORDER BY `post_hits` DESC LIMIT 0,8 [ RunTime:0.001714s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'post',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'type_status_date,category_id',
'key' => 'category_id',
'key_len' => '14',
'ref' => NULL,
'rows' => 29,
'filtered' => 1.110888957977295,
'extra' => 'Using index condition; Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.001363s ]
- [ 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' => 272,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`user_nickname` FROM `cmf_user` [ RunTime:0.001242s ]
- [ 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.001277s ]
- [ 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` = 20133 [ RunTime:0.001333s ]
- [ 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' => 30,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (8266,8269,8270,1880,136,1652,132,1878,1394,5635,2885,2574,3387,4610,4687,4673,4503,3404,4892,4371,28,2226,3651,3514,3919,3751,1110,2273,9397,10471) [ RunTime:0.001406s ]
- [ 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' => 30,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 212 LIMIT 1 [ RunTime:0.001297s ]
- [ 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` = 25227 [ RunTime:0.001360s ]
- [ 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' => 26,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (8266,8970,1648,1733,1731,45,8485,1882,2831,8706,8982,3009,4066,2797,4144,4351,5219,2810,8278,9180,8255,9211,9085,9425,8271,9062) [ RunTime:0.002029s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => NULL,
'rows' => 26,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 212 LIMIT 1 [ RunTime:0.001268s ]
- [ 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` = 18043 [ RunTime:0.001310s ]
- [ 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' => 15,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (8030,8031,8032,8033,8034,5291,5318,7775,7410,7765,7760,7770,9224,7755,49) [ RunTime:0.001316s ]
- [ 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' => 15,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 212 LIMIT 1 [ RunTime:0.001240s ]
- [ 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` = 18047 [ RunTime:0.001343s ]
- [ 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' => 15,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (8030,8031,8032,8033,8034,5291,5318,7775,7410,7765,7760,7770,9224,7755,49) [ RunTime:0.001264s ]
- [ 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' => 15,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 212 LIMIT 1 [ RunTime:0.001269s ]
- [ 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` = 18044 [ RunTime:0.001311s ]
- [ 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' => 15,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (8030,8031,8032,8033,8034,5291,5318,7775,7410,7765,7760,7770,9224,7755,49) [ RunTime:0.001341s ]
- [ 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' => 15,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 212 LIMIT 1 [ RunTime:0.001238s ]
- [ 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` = 18051 [ RunTime:0.001273s ]
- [ 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' => 15,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (8030,8031,8032,8033,8034,5291,5318,7775,7410,7765,7760,7770,9224,7755,49) [ RunTime:0.001302s ]
- [ 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' => 15,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 212 LIMIT 1 [ RunTime:0.001280s ]
- [ 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` = 20132 [ RunTime:0.001312s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'post_id',
'key' => 'post_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 17,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (8266,8267,8268,46,2039,1749,4893,4388,2474,2062,3198,3958,3750,6602,2244,10509,4284) [ RunTime:0.001346s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => NULL,
'rows' => 17,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 212 LIMIT 1 [ RunTime:0.001226s ]
- [ 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` = 18048 [ RunTime:0.001258s ]
- [ 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' => 15,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (8030,8031,8032,8033,8034,5291,5318,7775,7410,7765,7760,7770,9224,7755,49) [ RunTime:0.001312s ]
- [ 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' => 15,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 212 LIMIT 1 [ RunTime:0.001269s ]
- [ 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.mooktool.com%' LIMIT 1 [ RunTime:0.001238s ]
- [ 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' => 44,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 213 [ RunTime:0.001260s ]
- [ 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' => 272,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_portal_post` `post` WHERE `site_id` = 31 AND `post_status` = 1 AND `post_type` = 1 AND `delete_time` = 0 AND ( `category_id` = 213 ) AND ( `published_time` > 0 and `published_time` < 1711690381 ) ORDER BY `published_time` DESC LIMIT 1,11 [ RunTime:0.001458s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'type_status_date,category_id',
'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.001361s ]
- [ 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' => 272,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`user_nickname` FROM `cmf_user` [ RunTime:0.001198s ]
- [ 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.001199s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_user',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 2,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.mooktool.com%' LIMIT 1 [ RunTime:0.001243s ]
- [ 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' => 44,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 213 [ RunTime:0.001256s ]
- [ 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' => 272,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_portal_post` `post` WHERE `site_id` = 31 AND `post_status` = 1 AND `post_type` = 1 AND `delete_time` = 0 AND ( `category_id` = 213 ) AND ( `published_time` > 0 and `published_time` < 1711690381 ) ORDER BY `published_time` DESC LIMIT 0,1 [ RunTime:0.001551s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'type_status_date,category_id',
'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.001510s ]
- [ 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' => 272,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`user_nickname` FROM `cmf_user` [ RunTime:0.001334s ]
- [ 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.001273s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_user',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 2,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.mooktool.com%' LIMIT 1 [ RunTime:0.001291s ]
- [ 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' => 44,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 212 [ RunTime:0.001285s ]
- [ 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' => 272,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_portal_post` `post` WHERE `site_id` = 31 AND `post_status` = 1 AND `post_type` = 1 AND `delete_time` = 0 AND ( `category_id` = 212 ) AND ( `published_time` > 0 and `published_time` < 1711690381 ) ORDER BY `published_time` DESC LIMIT 1,11 [ RunTime:0.001620s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'type_status_date,category_id',
'key' => 'category_id',
'key_len' => '14',
'ref' => 'const,const,const,const',
'rows' => 27,
'filtered' => 1.110888957977295,
'extra' => 'Using index condition; Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.001462s ]
- [ 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' => 272,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`user_nickname` FROM `cmf_user` [ RunTime:0.001265s ]
- [ 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.001249s ]
- [ 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` = 53843 [ RunTime:0.001379s ]
- [ 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' => 15,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (8266,9598,10750,10751,8273,2061,2563,403,8487,2233,74,4065,3918,8688,3489) [ RunTime:0.001495s ]
- [ 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' => 15,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 212 LIMIT 1 [ RunTime:0.001241s ]
- [ 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` = 49067 [ RunTime:0.001319s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'post_id',
'key' => 'post_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 17,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (8266,10677,10678,1203,1735,8256,205,2040,1278,6598,8501,8486,4038,8849,4805,2137,3777) [ RunTime:0.001379s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => NULL,
'rows' => 17,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 212 LIMIT 1 [ RunTime:0.001269s ]
- [ 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` = 49020 [ RunTime:0.001241s ]
- [ 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 (8266,10674,10675) [ RunTime:0.001291s ]
- [ 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` = 212 LIMIT 1 [ RunTime:0.001216s ]
- [ 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` = 40719 [ RunTime:0.001282s ]
- [ 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' => 11,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (8968,10522,8695,8518,1657,1474,53,8260,2843,4980,9359) [ RunTime:0.001315s ]
- [ 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' => 11,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 212 LIMIT 1 [ RunTime:0.001225s ]
- [ 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` = 40695 [ RunTime:0.001302s ]
- [ 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' => 22,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (8266,10520,2831,1731,1882,1733,1648,9085,45,8706,2810,8485,3009,8982,9211,2797,8255,8278,9425,8271,9180,9062) [ RunTime:0.001339s ]
- [ 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' => 22,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 212 LIMIT 1 [ RunTime:0.001280s ]
- [ 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` = 31536 [ RunTime:0.001439s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'post_id',
'key' => 'post_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 27,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (8266,9758,9759,1731,1648,45,8706,8982,9180,9211,8278,9387,8255,3009,2810,1882,2831,4702,1733,9085,8485,9753,2797,9425,4273,8271,9062) [ RunTime:0.001377s ]
- [ 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' => 27,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 212 LIMIT 1 [ RunTime:0.001269s ]
- [ 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` = 31535 [ RunTime:0.001309s ]
- [ 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 (8968,9755,9756,9757,9617,9616,8680) [ RunTime:0.001329s ]
- [ 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` = 212 LIMIT 1 [ RunTime:0.001227s ]
- [ 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` = 30263 [ RunTime:0.001341s ]
- [ 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' => 11,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (8266,9601,9602,9603,1157,2139,8262,4283,9593,1522,8962) [ RunTime:0.001372s ]
- [ 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' => 11,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 212 LIMIT 1 [ RunTime:0.001249s ]
- [ 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` = 30262 [ RunTime:0.001367s ]
- [ 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' => 26,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (8266,9598,9599,9600,5352,7777,403,2061,7772,3485,2233,4065,3918,8864,8688,3140,2563,5860,3489,8487,7757,7762,7686,7767,7693,7721) [ RunTime:0.001335s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => NULL,
'rows' => 26,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 212 LIMIT 1 [ RunTime:0.001214s ]
- [ 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` = 28982 [ RunTime:0.001313s ]
- [ 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 (8266,9408,9409,1085,3913) [ RunTime:0.001295s ]
- [ 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` = 212 LIMIT 1 [ RunTime:0.001239s ]
- [ 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` = 28981 [ RunTime:0.001212s ]
- [ 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 (8266,9407,5862) [ RunTime:0.001251s ]
- [ 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` = 212 LIMIT 1 [ RunTime:0.001285s ]
- [ 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.mooktool.com%' LIMIT 1 [ RunTime:0.001320s ]
- [ 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' => 44,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 212 [ RunTime:0.001341s ]
- [ 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' => 272,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_portal_post` `post` WHERE `site_id` = 31 AND `post_status` = 1 AND `post_type` = 1 AND `delete_time` = 0 AND ( `category_id` = 212 ) AND ( `published_time` > 0 and `published_time` < 1711690381 ) ORDER BY `published_time` DESC LIMIT 0,1 [ RunTime:0.001565s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'type_status_date,category_id',
'key' => 'category_id',
'key_len' => '14',
'ref' => 'const,const,const,const',
'rows' => 27,
'filtered' => 1.110888957977295,
'extra' => 'Using index condition; Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.001501s ]
- [ 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' => 272,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`user_nickname` FROM `cmf_user` [ RunTime:0.001194s ]
- [ 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.001268s ]
- [ 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` = 53866 [ RunTime:0.001274s ]
- [ 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 (8266,10752,8852) [ RunTime:0.001309s ]
- [ 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` = 212 LIMIT 1 [ RunTime:0.001263s ]
- [ 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.mooktool.com%' LIMIT 1 [ RunTime:0.001291s ]
- [ 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' => 44,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 214 [ RunTime:0.001319s ]
- [ 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' => 272,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_portal_post` `post` WHERE `site_id` = 31 AND `post_status` = 1 AND `post_type` = 1 AND `delete_time` = 0 AND ( `category_id` IN (214,215,216) ) AND ( `published_time` > 0 and `published_time` < 1711690381 ) ORDER BY `published_time` DESC LIMIT 0,1 [ RunTime:0.001559s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'post',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'type_status_date,category_id',
'key' => 'category_id',
'key_len' => '14',
'ref' => NULL,
'rows' => 3,
'filtered' => 1.6666667461395264,
'extra' => 'Using index condition; Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.001493s ]
- [ 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' => 272,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`user_nickname` FROM `cmf_user` [ RunTime:0.001292s ]
- [ 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.001235s ]
- [ 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` = 17042 [ RunTime:0.001381s ]
- [ 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' => 30,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (7770,7771,7772,7773,7774,5291,5318,5352,5729,7767,7766,7765,7775,7776,7777,7760,7410,7762,7761,6926,5860,7686,7685,7757,7756,9224,7755,49,7693,7721) [ RunTime:0.001465s ]
- [ 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' => 30,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 214 LIMIT 1 [ RunTime:0.001298s ]
- [ 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.mooktool.com%' LIMIT 1 [ RunTime:0.001309s ]
- [ 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' => 44,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 214 [ RunTime:0.001366s ]
- [ 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' => 272,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_portal_post` `post` WHERE `site_id` = 31 AND `post_status` = 1 AND `post_type` = 1 AND `delete_time` = 0 AND ( `category_id` IN (214,215,216) ) AND ( `published_time` > 0 and `published_time` < 1711690381 ) ORDER BY `published_time` DESC LIMIT 0,10 [ RunTime:0.001532s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'post',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'type_status_date,category_id',
'key' => 'category_id',
'key_len' => '14',
'ref' => NULL,
'rows' => 3,
'filtered' => 1.6666667461395264,
'extra' => 'Using index condition; Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.001486s ]
- [ 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' => 272,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`user_nickname` FROM `cmf_user` [ RunTime:0.001279s ]
- [ 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.001250s ]
- [ 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` = 17042 [ RunTime:0.001368s ]
- [ 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' => 30,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (7770,7771,7772,7773,7774,5291,5318,5352,5729,7767,7766,7765,7775,7776,7777,7760,7410,7762,7761,6926,5860,7686,7685,7757,7756,9224,7755,49,7693,7721) [ RunTime:0.001495s ]
- [ 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' => 30,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 214 LIMIT 1 [ RunTime:0.002278s ]
- [ 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.mooktool.com%' LIMIT 1 [ RunTime:0.001339s ]
- [ 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' => 44,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_link` [ RunTime:0.001572s ]
- [ SQL ] SELECT * FROM `cmf_link` WHERE `status` = 1 AND `site_id` = 31 ORDER BY `list_order` ASC [ RunTime:0.001400s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_link',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => 'status',
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 5,
'filtered' => 20.0,
'extra' => 'Using where; Using filesort',
) ]
1.066689s