09月11日
星期三
09月12日
星期四
09月13日
星期五
02:30
下半场
雷克瑟姆
vs
索尔福德市
02:30
下半场
圣马力诺U21
vs
土耳其U21
02:30
待定
桑坦尼体育会
vs
克莱西亚莱斯竞技
02:30
待定
韦尔卡
vs
班卡里奥斯
02:30
下半场
RE学生队
vs
唐奥利翁
02:45
下半场
北爱尔兰U21
vs
乌克兰U21
02:45
下半场
泰福特
vs
布朗史葛夫竞技
02:45
下半场
班布里
vs
希斯奧云镇
02:45
中场
比格尔斯威德
vs
巴福特城
02:45
下半场
哈伯勒镇
vs
斯伯丁
02:45
下半场
希治
vs
比夏史托福
02:45
下半场
李斯顿
vs
萨德贝利
02:45
下半场
洛斯托夫特镇
vs
罗伊斯顿镇
02:45
下半场
斯坦福
vs
巴韦尔
02:45
下半场
斯托桥
vs
斯特拉特福镇
02:45
下半场
捷克
vs
乌克兰
00:00
未开赛
塔林利瓦迪亚
vs
土勒维克
00:00
未开赛
赫鲁钦
vs
乌尼邱夫
00:00
未开赛
格瑞巴吉
vs
伊高洛
00:00
未开赛
艾斯卡尔
vs
FK波德戈里察
00:00
未开赛
洛夫琴
vs
KOM朴高利卡
00:00
未开赛
马拉多特DG
vs
普列夫利亚矿工
00:00
未开赛
安特卫普B队
vs
比尔森贝利西亚
00:00
未开赛
那慕尔
vs
班尼瑟
00:00
未开赛
瓦夫斯
vs
罗什福尔
00:00
未开赛
奥罗拉
vs
奇基穆拉
00:30
未开赛
卡罗维瓦利
vs
霍穆托夫
00:30
未开赛
艾福特女足
vs
法兰克福女足
00:30
未开赛
荷尔斯泰因U17
vs
圣保利U17
01:00
未开赛
艾尔格里尼克
vs
卡尔蔡司耶拿
01:00
未开赛
爱尔福特红白
vs
巴贝尔斯贝格03
01:00
未开赛
莱比锡火车头
vs
茨维考FC
00:00
未开赛
阿科夏普尔
vs
迪克瓦夏普尔
00:00
未开赛
法萨巴夏普尔
vs
特拉维夫叶胡达
00:00
未开赛
特拉维夫夏普尔
vs
拉那那夏普尔
00:00
未开赛
乌姆阿法姆夏普尔
vs
拿撒勒伊里特夏普尔
00:00
未开赛
拉马甘夏普尔
vs
夏雷姆
00:00
未开赛
卡比利奥马卡比
vs
阿富拉夏普尔
00:00
未开赛
赫兹立亚马卡比
vs
里雄莱锡安夏普尔
00:00
未开赛
卡法尔卡瑟姆
vs
哈萨隆
00:00
未开赛
拜仁慕尼黑U19
vs
因戈尔施塔特U19
00:00
未开赛
多多玛吉吉FC
vs
纳姆古戈俱乐部
00:00
未开赛
塔什干棉农
vs
费尔干纳夫兹
00:00
未开赛
克孜勒库姆
vs
索格迪纳吉扎克
01:15
未开赛
哈夫纳夫约杜尔女足
vs
维京古女足
01:30
未开赛
VFB希尔顿
vs
SV索尼克斯
02:00
未开赛
穆尼斯
vs
伊图萨因戈
02:00
未开赛
布莱克本U21
vs
里昂B队
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2024-09-11 04:14:35 HTTP/2.0 GET : https://wxpanguan.com/
- 运行时间 : 2.086339s [ 吞吐率：0.48req/s ] 内存消耗：6,116.86kb 文件加载：142
- 查询信息 : 259 queries 7 writes
- 缓存信息 : 7 reads,4 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 (
'accept-encoding' => 'br,gzip',
'accept-language' => 'en-US,en;q=0.5',
'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8',
'user-agent' => 'CCBot/2.0 (https://commoncrawl.org/faq/)',
'host' => 'wxpanguan.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 => 'navigation',
6 => 'theme_vars',
7 => 'theme_widgets',
) ]
- [ DB ] CONNECT:[ UseTime:0.008420s ] mysql:host=rm-3ns41jmtlb1g0zd6v.mysql.rds.aliyuncs.com;port=3306;dbname=daxiong;charset=utf8mb4
- [ SQL ] SHOW COLUMNS FROM `cmf_plugin_web` [ RunTime:0.005735s ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%wxpanguan.com%' LIMIT 1 [ RunTime:0.009027s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%wxpanguan.com%' LIMIT 1 [ RunTime:0.006658s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_plugin` [ RunTime:0.004294s ]
- [ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Web' AND `site_id` = 62 LIMIT 1 [ RunTime:0.004441s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 136,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%wxpanguan.com%' LIMIT 1 [ RunTime:0.003150s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_option` [ RunTime:0.003083s ]
- [ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'cdn_settings' AND `site_id` = 62 LIMIT 1 [ RunTime:0.002941s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_option',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'site_id',
'key' => 'site_id',
'key_len' => '5',
'ref' => 'const',
'rows' => 5,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%wxpanguan.com%' LIMIT 1 [ RunTime:0.003150s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%wxpanguan.com%' LIMIT 1 [ RunTime:0.002808s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 62 LIMIT 1 [ RunTime:0.002920s ]
- [ 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 '%wxpanguan.com%' LIMIT 1 [ RunTime:0.003044s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%wxpanguan.com%' LIMIT 1 [ RunTime:0.003042s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%wxpanguan.com%' LIMIT 1 [ RunTime:0.003010s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'site_info' AND `site_id` = 62 LIMIT 1 [ RunTime:0.003050s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_option',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'site_id',
'key' => 'site_id',
'key_len' => '5',
'ref' => 'const',
'rows' => 5,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'admin_settings' AND `site_id` = 62 LIMIT 1 [ RunTime:0.003265s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_option',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'site_id',
'key' => 'site_id',
'key_len' => '5',
'ref' => 'const',
'rows' => 5,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.003428s ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` WHERE `status` = 1 [ RunTime:0.005690s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 756,
'filtered' => 9.999999046325684,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%wxpanguan.com%' LIMIT 1 [ RunTime:0.003006s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 62 LIMIT 1 [ RunTime:0.002882s ]
- [ 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.005007s ]
- [ SQL ] SELECT `pinyin` FROM `cmf_nami_competitions` WHERE `id` = 0 LIMIT 1 [ RunTime:0.003062s ]
- [ 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.002885s ]
- [ 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 '%wxpanguan.com%' LIMIT 1 [ RunTime:0.003035s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%wxpanguan.com%' LIMIT 1 [ RunTime:0.002944s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_nav_menu` [ RunTime:0.003269s ]
- [ SQL ] SELECT `name`,`href` FROM `cmf_nav_menu` WHERE `nav_id` = 1 AND `parent_id` = 0 AND `status` = 1 AND `site_id` = 62 [ RunTime:0.003187s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nav_menu',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 948,
'filtered' => 0.1054852306842804,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.003124s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'seo_pc' AND `file` = 'portal/article' LIMIT 1 [ RunTime:0.003190s ]
- [ 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' => 237,
'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.003923s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'seo_pc' AND `file` = 'portal/competition' LIMIT 1 [ RunTime:0.003674s ]
- [ 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' => 237,
'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.005347s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'seo_pc' AND `file` = 'portal/index' LIMIT 1 [ RunTime:0.003773s ]
- [ 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' => 237,
'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.007420s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'seo_pc' AND `file` = 'portal/list' LIMIT 1 [ RunTime:0.003084s ]
- [ 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' => 237,
'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.003121s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'seo_pc' AND `file` = 'portal/match' LIMIT 1 [ RunTime:0.012862s ]
- [ 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' => 237,
'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.003173s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'seo_pc' AND `file` = 'portal/tag' LIMIT 1 [ RunTime:0.002976s ]
- [ 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' => 237,
'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.003353s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'seo_pc' [ RunTime:0.003135s ]
- [ 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' => 237,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_theme` [ RunTime:0.003150s ]
- [ 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.003091s ]
- [ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = 'seo_pc' AND ( `is_public` = 1 OR `file` = 'portal/index' ) [ RunTime:0.003109s ]
- [ 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' => 237,
'filtered' => 1.899999976158142,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%wxpanguan.com%' LIMIT 1 [ RunTime:0.005770s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'storage' AND `site_id` = 62 LIMIT 1 [ RunTime:0.003159s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_option',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'site_id',
'key' => 'site_id',
'key_len' => '5',
'ref' => 'const',
'rows' => 5,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%wxpanguan.com%' LIMIT 1 [ RunTime:0.002850s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Oss' AND `site_id` = 62 LIMIT 1 [ RunTime:0.003351s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 136,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%wxpanguan.com%' LIMIT 1 [ RunTime:0.002985s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%wxpanguan.com%' LIMIT 1 [ RunTime:0.003055s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_nav` [ RunTime:0.003047s ]
- [ SQL ] SELECT `id` FROM `cmf_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.002947s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nav',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 2,
'filtered' => 50.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `site_id` = 62 AND `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.003212s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nav_menu',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 948,
'filtered' => 0.1054852306842804,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%wxpanguan.com%' LIMIT 1 [ RunTime:0.002914s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM cmf_nami_competitions WHERE id IN ('529', '588', '32', '33', '5', '6', '2538', '123', '623', '640', '181', '199', '624', '589', '70', '122', '112', '136', '100') ORDER BY FIELD(id, '529', '588', '32', '33', '5', '6', '2538', '123', '623', '640', '181', '199', '624', '589', '70', '122', '112', '136', '100') limit 20 [ RunTime:0.005039s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_competitions',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '4',
'ref' => NULL,
'rows' => 19,
'filtered' => 100.0,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `cid` FROM `cmf_nami_competitions` WHERE `pinyin` = AND `com_type` = 0 LIMIT 1 [ RunTime:0.006193s ]
- [ 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' => 3768,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_nami_matches` [ RunTime:0.003277s ]
- [ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `com_type` = 0 AND ( `match_time` > 1725992075 ) ORDER BY `match_time` ASC LIMIT 500 [ RunTime:0.007275s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_matches',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'com_type,match_time',
'key' => 'com_type',
'key_len' => '7',
'ref' => NULL,
'rows' => 21338,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` IN (100,51,470,3225,2914,2906,86,90,89,106,1715,1586,1824,700,2922,2000,3136,4,486,464,1895,1752,34,24,4474,3375,2066,1834,37,1748,1788,119,2952,577,613,2778,269,325,1796,675,673,1666,254,354,297,331,323,1704,1819,1733,338,277,264,260,1940,1890,205,365,1094,1163,1729,138,133,132,217,2104,194,978,431,2737,2101,124,226,1767,476,452,1683,488,469,18,435,3380,475,3139,1768,458,450,436,489,586,357,659,545,350,371,3394,3075,196,197,348,6907,674,281,376,85,481,2115,466,255,263,1815,567,349,581,542,310,1863,2846,632,616,635,240,239,1668,301,296,340,336,368,241,332,684,293,1667,3527) [ RunTime:0.004454s ]
- [ 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' => 135,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` IN (100,51,470,3225,2914,2906,86,90,89,106,1715,1586,1824,700,2922,2000,3136,4,486,464,1895,1752,34,24,4474,3375,2066,1834,37,1748,1788,119,2952,577,613,2778,269,325,1796,675,673,1666,254,354,297,331,323,1704,1819,1733,338,277,264,260,1940,1890,205,365,1094,1163,1729,138,133,132,217,2104,194,978,431,2737,2101,124,226,1767,476,452,1683,488,469,18,435,3380,475,3139,1768,458,450,436,489,586,357,659,545,350,371,3394,3075,196,197,348,6907,674,281,376,85,481,2115,466,255,263,1815,567,349,581,542,310,1863,2846,632,616,635,240,239,1668,301,296,340,336,368,241,332,684,293,1667,3527) [ RunTime:0.004063s ]
- [ 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' => 135,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_nami_teams` [ RunTime:0.003756s ]
- [ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (10498,24781,12159,13900,27301,14553,68799,62191,61649,49913,13263,13801,17775,15676,15596,12216,24928,14130,61620,19806,17024,11180,22049,17644,24552,18743,11178,28658,24297,24926,10979,12938,11079,10304,10822,11605,10927,10478,11271,11969,10410,14190,10870,11746,10307,11968,11112,12949,11113,10537,10859,13254,10732,12018,73352,10497,10734,25123,11528,16129,11530,16128,12019,18760,16655,18938,11841,25328,11119,14655,20710,19509,31991,28052,14595,20966,11176,19151,14564,44472,10572,24881,25296,22400,19378,21298,58546,21747,11964,21101,20967,28659,22048,19598,24927,16094,18314,24925,17784,15604,18750,20344,17110,24979,13140,19066,54668,68604,13462,13460,48420,15896,24882,35580,22047,41403,20188,32581,17643,12122,19452,32448,14138,77035,12123,21297,18745,67435,19521,58375,21033,15597,10795,16449,10482,10406,10309,12366,11083,20389,19320,11141,10481,25749,15918,23092,55687,62261,12247,21957,22809,18140,12246,21170,38384,72983,85751,29122,10476,13727,11143,21751,11082,13448,10983,10453,13265,13447,28053,21521,12505,25297,69751,50035,40641,61808,50100,70597,74336,74337,35288,33204,18309,22841,69667,55330,29117,15970,26500,82048,54582,49064,35381,51963,10634,13678,13611,14400,26242,37632,83569,77644,13449,10477,10116,77757,11138,11764,20634,26890,11016,11708,37357,21523,50141,77668,47482,34390,30209,22056,31174,19438,54684,60575,72909,77650,22076,18940,33369,18145,61283,32115,14725,26310,30180,33835,33675,72151,38355,77464,23935,59845,36063,85750,16015,49896,10062,10071,26048,18136,18702,21389,72651,33880,19338,37410,26167,31173,77688,37059,25731,23718,48090,19135,32764,13038,18116,23717,53389,23568,77853,23873,19132,10760,31801,19133,85694,85695,23061,23716,10344,11145,49794,53067,36350,38336,44306,34649,27685,38401,59318,62802,24041,58947,48737,25240,34656,38385,44165,27058,54817,37678,22491,37686,85727,59647,20783,32254,23731,32948,15523,17715,15925,29289,15720,16058,14197,12451,21191,38215,77646,79326,19699,12538,45699,79329,76744,60623,21404,24380,14041,14128,30267,32187,19443,14593,22655,13143,18748,24978,26877,15797,35857,23187,21368,74587,47124,57923,21138,29644,24558,76415,76412,51937,12833,41459,44885,57924,15824,14711,23758,13858,20812,10923,15184,11366,10877,22717,81807,81763,20015,10872,36126,15567,58633,14756,69116,69127,14478,29727,20117,16583,75046,21020,28724,30313,26997,14477,17616,15183,17958,24905,10962,53005,42008,16443,20957,36337,47424,20818,30342,15803,15579,72158,24294,23867,17002,16998,42094,14888,35456,30514,53289,14510,17811,23763,37163,31012,10660,13369,14052,17664,13477,17944,13274,10922,13269,11839,13372,17945,13271,17356,55882,13588,74597,52860,29592,19742,23902,23901,18403,52427,32179,17987,53132,26665,49039,41102,23225,20416,17452,38512,29541,44248,15419,17033,56876,25131,54659,41130,76740,35058,15518,22519,27278,27281,10921,18533,11153,26708,17566,26462,28389,20220,19691,23031,53344,17703,72041,20096,19823,32253,19829,29295,40573,84682,18839,15670,27007,46437,27968,32586,13122,16266,10124,16816,14679,35463,17074,24187,35455,10905,13864,11313,22092,41809,17634,13083,85092,18927,21598,12945,82025,11317,36502,25336,13423,24208,41492,47065,11699,57930,41402,85378,35317,13203,31639,28034,47184,20768,28033,10843,29137,29483,29431,31679,20767,12750,32091,42598,31029,25050,32945,31965,12608,29110,30076,31030,12749,30641,12309,31199,19826,11187,10422,13660,32999,14427,22490,29496,17501,47675,10561,61550,27926,36673,37097,45078,69397,37418,38097,21687,14116,14117,25966,25871,23519,22456,53565,55881,36526,15229,18658,30228,14963,20233,33091,52829,13102,39824,57672,36821,60265,24824,69481,61542,59687,72184,19758,12149,16891,30195,38693,18457,10818,11304,81410,34305,14009,14964,57461,34712,41716,28013,49962,28719,50564,50565,62594,53560,12391,19842,10496,10600,60977,77663,15974,10815,29215,44995,10756,10211,26206,18048,23834,19257,23267,47559,14814,21775,22342,21837,16657,21520,57671,28470,83739,50838,77645,77664,35074,35072,34126,31764,15569,24460,40341,45735,28715,27339,23974,28714,23804,26040,19130,21001,60751,64267,21067,16060,32154,23194,12789,31228,18342,32287,80938,72669,28224,29349,29863,26037,28067,29847,30404,52928,29133,76417,58506,30780,82381,25004,33738,74468,20106,19097,17491,27599,57391,48037,42291,11199,16945,24343,54559,25154,32387,14941,15522,32507,12597,19917,55837,19173,74713,11321,12624,12528,11039,11678,12433,12625,34515,18885,12627,25932,21539,22698,12148,18884,13161,12527,18350,33199,58129,53995,17618,22967,13057,21399,23800,11023,14183,36780,23040,23041,32278,27514,72188,12888,28828,58496,15798,10533,50493,22638,11946,18673,19034,21836,18113,79461,43710,22125,70663,81344,15674,18355,14965,20475,10117,12154,10757,10813,43229,41930,26603,15944,15588,47476,10989,21774,12340,47586,77629,31100,52560,12477,57787,28556,76335,52543,12475,29156,25833,29968,25895,57788,76334,41528,24307,22517,85155,21684,40103,81292,25533,44700,34100,10336,20273,10070,10457,10908,10526,59379,30068,32694,37641,23822,29337,34514,29336,23777,62889,38273,37840,22014,26866,24222,23823,10415,10417,10416,23021,59453,37975,46023,34304,74873,74380,19717,45373,47806,24758,49449,53797,57043,45893,62514,46969,32655,43055,76501,35506,10767,10223,14530,12239,10138,53336,29786,34466,33469,54569,21128,58906,17988,85696,17989,29885,11943,27739,48915,77510,77511,22314,21126,20371,14571,85106,76418,20907,81768,50944,82406,27364,81773,81774,82417,81772,13950,19986,69981,24807,58610,55731,20439,39897,41638,23280,29456,24718,85361,76973,85399,39549,21864,74617,13251,14633,24076,12761,24684,39878,27533,14344,10950,14251,35945,12207,10359,11402,10404,10353,13190,13191,15421,11314,28220,25751,27399,14815,42091,42087,20213,20212,58204,17569,26798,21342,20162,19191,52161,58202,75426,26800,58206,71476,20163,36040,19404,19938,59214,61773,11774,16147,41181,36823,20198,36140,17999,31505,27504,27727,13277,48197,28782,81760,14077,18010,76286,76282,75420,76264) [ RunTime:0.012864s ]
- [ 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' => 975,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (10498,24781,12159,13900,27301,14553,68799,62191,61649,49913,13263,13801,17775,15676,15596,12216,24928,14130,61620,19806,17024,11180,22049,17644,24552,18743,11178,28658,24297,24926,10979,12938,11079,10304,10822,11605,10927,10478,11271,11969,10410,14190,10870,11746,10307,11968,11112,12949,11113,10537,10859,13254,10732,12018,73352,10497,10734,25123,11528,16129,11530,16128,12019,18760,16655,18938,11841,25328,11119,14655,20710,19509,31991,28052,14595,20966,11176,19151,14564,44472,10572,24881,25296,22400,19378,21298,58546,21747,11964,21101,20967,28659,22048,19598,24927,16094,18314,24925,17784,15604,18750,20344,17110,24979,13140,19066,54668,68604,13462,13460,48420,15896,24882,35580,22047,41403,20188,32581,17643,12122,19452,32448,14138,77035,12123,21297,18745,67435,19521,58375,21033,15597,10795,16449,10482,10406,10309,12366,11083,20389,19320,11141,10481,25749,15918,23092,55687,62261,12247,21957,22809,18140,12246,21170,38384,72983,85751,29122,10476,13727,11143,21751,11082,13448,10983,10453,13265,13447,28053,21521,12505,25297,69751,50035,40641,61808,50100,70597,74336,74337,35288,33204,18309,22841,69667,55330,29117,15970,26500,82048,54582,49064,35381,51963,10634,13678,13611,14400,26242,37632,83569,77644,13449,10477,10116,77757,11138,11764,20634,26890,11016,11708,37357,21523,50141,77668,47482,34390,30209,22056,31174,19438,54684,60575,72909,77650,22076,18940,33369,18145,61283,32115,14725,26310,30180,33835,33675,72151,38355,77464,23935,59845,36063,85750,16015,49896,10062,10071,26048,18136,18702,21389,72651,33880,19338,37410,26167,31173,77688,37059,25731,23718,48090,19135,32764,13038,18116,23717,53389,23568,77853,23873,19132,10760,31801,19133,85694,85695,23061,23716,10344,11145,49794,53067,36350,38336,44306,34649,27685,38401,59318,62802,24041,58947,48737,25240,34656,38385,44165,27058,54817,37678,22491,37686,85727,59647,20783,32254,23731,32948,15523,17715,15925,29289,15720,16058,14197,12451,21191,38215,77646,79326,19699,12538,45699,79329,76744,60623,21404,24380,14041,14128,30267,32187,19443,14593,22655,13143,18748,24978,26877,15797,35857,23187,21368,74587,47124,57923,21138,29644,24558,76415,76412,51937,12833,41459,44885,57924,15824,14711,23758,13858,20812,10923,15184,11366,10877,22717,81807,81763,20015,10872,36126,15567,58633,14756,69116,69127,14478,29727,20117,16583,75046,21020,28724,30313,26997,14477,17616,15183,17958,24905,10962,53005,42008,16443,20957,36337,47424,20818,30342,15803,15579,72158,24294,23867,17002,16998,42094,14888,35456,30514,53289,14510,17811,23763,37163,31012,10660,13369,14052,17664,13477,17944,13274,10922,13269,11839,13372,17945,13271,17356,55882,13588,74597,52860,29592,19742,23902,23901,18403,52427,32179,17987,53132,26665,49039,41102,23225,20416,17452,38512,29541,44248,15419,17033,56876,25131,54659,41130,76740,35058,15518,22519,27278,27281,10921,18533,11153,26708,17566,26462,28389,20220,19691,23031,53344,17703,72041,20096,19823,32253,19829,29295,40573,84682,18839,15670,27007,46437,27968,32586,13122,16266,10124,16816,14679,35463,17074,24187,35455,10905,13864,11313,22092,41809,17634,13083,85092,18927,21598,12945,82025,11317,36502,25336,13423,24208,41492,47065,11699,57930,41402,85378,35317,13203,31639,28034,47184,20768,28033,10843,29137,29483,29431,31679,20767,12750,32091,42598,31029,25050,32945,31965,12608,29110,30076,31030,12749,30641,12309,31199,19826,11187,10422,13660,32999,14427,22490,29496,17501,47675,10561,61550,27926,36673,37097,45078,69397,37418,38097,21687,14116,14117,25966,25871,23519,22456,53565,55881,36526,15229,18658,30228,14963,20233,33091,52829,13102,39824,57672,36821,60265,24824,69481,61542,59687,72184,19758,12149,16891,30195,38693,18457,10818,11304,81410,34305,14009,14964,57461,34712,41716,28013,49962,28719,50564,50565,62594,53560,12391,19842,10496,10600,60977,77663,15974,10815,29215,44995,10756,10211,26206,18048,23834,19257,23267,47559,14814,21775,22342,21837,16657,21520,57671,28470,83739,50838,77645,77664,35074,35072,34126,31764,15569,24460,40341,45735,28715,27339,23974,28714,23804,26040,19130,21001,60751,64267,21067,16060,32154,23194,12789,31228,18342,32287,80938,72669,28224,29349,29863,26037,28067,29847,30404,52928,29133,76417,58506,30780,82381,25004,33738,74468,20106,19097,17491,27599,57391,48037,42291,11199,16945,24343,54559,25154,32387,14941,15522,32507,12597,19917,55837,19173,74713,11321,12624,12528,11039,11678,12433,12625,34515,18885,12627,25932,21539,22698,12148,18884,13161,12527,18350,33199,58129,53995,17618,22967,13057,21399,23800,11023,14183,36780,23040,23041,32278,27514,72188,12888,28828,58496,15798,10533,50493,22638,11946,18673,19034,21836,18113,79461,43710,22125,70663,81344,15674,18355,14965,20475,10117,12154,10757,10813,43229,41930,26603,15944,15588,47476,10989,21774,12340,47586,77629,31100,52560,12477,57787,28556,76335,52543,12475,29156,25833,29968,25895,57788,76334,41528,24307,22517,85155,21684,40103,81292,25533,44700,34100,10336,20273,10070,10457,10908,10526,59379,30068,32694,37641,23822,29337,34514,29336,23777,62889,38273,37840,22014,26866,24222,23823,10415,10417,10416,23021,59453,37975,46023,34304,74873,74380,19717,45373,47806,24758,49449,53797,57043,45893,62514,46969,32655,43055,76501,35506,10767,10223,14530,12239,10138,53336,29786,34466,33469,54569,21128,58906,17988,85696,17989,29885,11943,27739,48915,77510,77511,22314,21126,20371,14571,85106,76418,20907,81768,50944,82406,27364,81773,81774,82417,81772,13950,19986,69981,24807,58610,55731,20439,39897,41638,23280,29456,24718,85361,76973,85399,39549,21864,74617,13251,14633,24076,12761,24684,39878,27533,14344,10950,14251,35945,12207,10359,11402,10404,10353,13190,13191,15421,11314,28220,25751,27399,14815,42091,42087,20213,20212,58204,17569,26798,21342,20162,19191,52161,58202,75426,26800,58206,71476,20163,36040,19404,19938,59214,61773,11774,16147,41181,36823,20198,36140,17999,31505,27504,27727,13277,48197,28782,81760,14077,18010,76286,76282,75420,76264) [ RunTime:0.014187s ]
- [ 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' => 975,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT `cid` FROM `cmf_nami_competitions` WHERE `pinyin` = AND `com_type` = 0 LIMIT 1 [ RunTime:0.004338s ]
- [ 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' => 3768,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `com_type` = 0 AND ( `match_time` > 1725992075 ) ORDER BY `match_time` ASC LIMIT 500 [ RunTime:0.005167s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_matches',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'com_type,match_time',
'key' => 'com_type',
'key_len' => '7',
'ref' => NULL,
'rows' => 21338,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` IN (100,51,470,3225,2914,2906,86,90,89,106,1715,1586,1824,700,2922,2000,3136,4,486,464,1895,1752,34,24,4474,3375,2066,1834,37,1748,1788,119,2952,577,613,2778,269,325,1796,675,673,1666,254,354,297,331,323,1704,1819,1733,338,277,264,260,1940,1890,205,365,1094,1163,1729,138,133,132,217,2104,194,978,431,2737,2101,124,226,1767,476,452,1683,488,469,18,435,3380,475,3139,1768,458,450,436,489,586,357,659,545,350,371,3394,3075,196,197,348,6907,674,281,376,85,481,2115,466,255,263,1815,567,349,581,542,310,1863,2846,632,616,635,240,239,1668,301,296,340,336,368,241,332,684,293,1667,3527) [ RunTime:0.004729s ]
- [ 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' => 135,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` IN (100,51,470,3225,2914,2906,86,90,89,106,1715,1586,1824,700,2922,2000,3136,4,486,464,1895,1752,34,24,4474,3375,2066,1834,37,1748,1788,119,2952,577,613,2778,269,325,1796,675,673,1666,254,354,297,331,323,1704,1819,1733,338,277,264,260,1940,1890,205,365,1094,1163,1729,138,133,132,217,2104,194,978,431,2737,2101,124,226,1767,476,452,1683,488,469,18,435,3380,475,3139,1768,458,450,436,489,586,357,659,545,350,371,3394,3075,196,197,348,6907,674,281,376,85,481,2115,466,255,263,1815,567,349,581,542,310,1863,2846,632,616,635,240,239,1668,301,296,340,336,368,241,332,684,293,1667,3527) [ RunTime:0.004071s ]
- [ 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' => 135,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (10498,24781,12159,13900,27301,14553,68799,62191,61649,49913,13263,13801,17775,15676,15596,12216,24928,14130,61620,19806,17024,11180,22049,17644,24552,18743,11178,28658,24297,24926,10979,12938,11079,10304,10822,11605,10927,10478,11271,11969,10410,14190,10870,11746,10307,11968,11112,12949,11113,10537,10859,13254,10732,12018,73352,10497,10734,25123,11528,16129,11530,16128,12019,18760,16655,18938,11841,25328,11119,14655,20710,19509,31991,28052,14595,20966,11176,19151,14564,44472,10572,24881,25296,22400,19378,21298,58546,21747,11964,21101,20967,28659,22048,19598,24927,16094,18314,24925,17784,15604,18750,20344,17110,24979,13140,19066,54668,68604,13462,13460,48420,15896,24882,35580,22047,41403,20188,32581,17643,12122,19452,32448,14138,77035,12123,21297,18745,67435,19521,58375,21033,15597,10795,16449,10482,10406,10309,12366,11083,20389,19320,11141,10481,25749,15918,23092,55687,62261,12247,21957,22809,18140,12246,21170,38384,72983,85751,29122,10476,13727,11143,21751,11082,13448,10983,10453,13265,13447,28053,21521,12505,25297,69751,50035,40641,61808,50100,70597,74336,74337,35288,33204,18309,22841,69667,55330,29117,15970,26500,82048,54582,49064,35381,51963,10634,13678,13611,14400,26242,37632,83569,77644,13449,10477,10116,77757,11138,11764,20634,26890,11016,11708,37357,21523,50141,77668,47482,34390,30209,22056,31174,19438,54684,60575,72909,77650,22076,18940,33369,18145,61283,32115,14725,26310,30180,33835,33675,72151,38355,77464,23935,59845,36063,85750,16015,49896,10062,10071,26048,18136,18702,21389,72651,33880,19338,37410,26167,31173,77688,37059,25731,23718,48090,19135,32764,13038,18116,23717,53389,23568,77853,23873,19132,10760,31801,19133,85694,85695,23061,23716,10344,11145,49794,53067,36350,38336,44306,34649,27685,38401,59318,62802,24041,58947,48737,25240,34656,38385,44165,27058,54817,37678,22491,37686,85727,59647,20783,32254,23731,32948,15523,17715,15925,29289,15720,16058,14197,12451,21191,38215,77646,79326,19699,12538,45699,79329,76744,60623,21404,24380,14041,14128,30267,32187,19443,14593,22655,13143,18748,24978,26877,15797,35857,23187,21368,74587,47124,57923,21138,29644,24558,76415,76412,51937,12833,41459,44885,57924,15824,14711,23758,13858,20812,10923,15184,11366,10877,22717,81807,81763,20015,10872,36126,15567,58633,14756,69116,69127,14478,29727,20117,16583,75046,21020,28724,30313,26997,14477,17616,15183,17958,24905,10962,53005,42008,16443,20957,36337,47424,20818,30342,15803,15579,72158,24294,23867,17002,16998,42094,14888,35456,30514,53289,14510,17811,23763,37163,31012,10660,13369,14052,17664,13477,17944,13274,10922,13269,11839,13372,17945,13271,17356,55882,13588,74597,52860,29592,19742,23902,23901,18403,52427,32179,17987,53132,26665,49039,41102,23225,20416,17452,38512,29541,44248,15419,17033,56876,25131,54659,41130,76740,35058,15518,22519,27278,27281,10921,18533,11153,26708,17566,26462,28389,20220,19691,23031,53344,17703,72041,20096,19823,32253,19829,29295,40573,84682,18839,15670,27007,46437,27968,32586,13122,16266,10124,16816,14679,35463,17074,24187,35455,10905,13864,11313,22092,41809,17634,13083,85092,18927,21598,12945,82025,11317,36502,25336,13423,24208,41492,47065,11699,57930,41402,85378,35317,13203,31639,28034,47184,20768,28033,10843,29137,29483,29431,31679,20767,12750,32091,42598,31029,25050,32945,31965,12608,29110,30076,31030,12749,30641,12309,31199,19826,11187,10422,13660,32999,14427,22490,29496,17501,47675,10561,61550,27926,36673,37097,45078,69397,37418,38097,21687,14116,14117,25966,25871,23519,22456,53565,55881,36526,15229,18658,30228,14963,20233,33091,52829,13102,39824,57672,36821,60265,24824,69481,61542,59687,72184,19758,12149,16891,30195,38693,18457,10818,11304,81410,34305,14009,14964,57461,34712,41716,28013,49962,28719,50564,50565,62594,53560,12391,19842,10496,10600,60977,77663,15974,10815,29215,44995,10756,10211,26206,18048,23834,19257,23267,47559,14814,21775,22342,21837,16657,21520,57671,28470,83739,50838,77645,77664,35074,35072,34126,31764,15569,24460,40341,45735,28715,27339,23974,28714,23804,26040,19130,21001,60751,64267,21067,16060,32154,23194,12789,31228,18342,32287,80938,72669,28224,29349,29863,26037,28067,29847,30404,52928,29133,76417,58506,30780,82381,25004,33738,74468,20106,19097,17491,27599,57391,48037,42291,11199,16945,24343,54559,25154,32387,14941,15522,32507,12597,19917,55837,19173,74713,11321,12624,12528,11039,11678,12433,12625,34515,18885,12627,25932,21539,22698,12148,18884,13161,12527,18350,33199,58129,53995,17618,22967,13057,21399,23800,11023,14183,36780,23040,23041,32278,27514,72188,12888,28828,58496,15798,10533,50493,22638,11946,18673,19034,21836,18113,79461,43710,22125,70663,81344,15674,18355,14965,20475,10117,12154,10757,10813,43229,41930,26603,15944,15588,47476,10989,21774,12340,47586,77629,31100,52560,12477,57787,28556,76335,52543,12475,29156,25833,29968,25895,57788,76334,41528,24307,22517,85155,21684,40103,81292,25533,44700,34100,10336,20273,10070,10457,10908,10526,59379,30068,32694,37641,23822,29337,34514,29336,23777,62889,38273,37840,22014,26866,24222,23823,10415,10417,10416,23021,59453,37975,46023,34304,74873,74380,19717,45373,47806,24758,49449,53797,57043,45893,62514,46969,32655,43055,76501,35506,10767,10223,14530,12239,10138,53336,29786,34466,33469,54569,21128,58906,17988,85696,17989,29885,11943,27739,48915,77510,77511,22314,21126,20371,14571,85106,76418,20907,81768,50944,82406,27364,81773,81774,82417,81772,13950,19986,69981,24807,58610,55731,20439,39897,41638,23280,29456,24718,85361,76973,85399,39549,21864,74617,13251,14633,24076,12761,24684,39878,27533,14344,10950,14251,35945,12207,10359,11402,10404,10353,13190,13191,15421,11314,28220,25751,27399,14815,42091,42087,20213,20212,58204,17569,26798,21342,20162,19191,52161,58202,75426,26800,58206,71476,20163,36040,19404,19938,59214,61773,11774,16147,41181,36823,20198,36140,17999,31505,27504,27727,13277,48197,28782,81760,14077,18010,76286,76282,75420,76264) [ RunTime:0.012279s ]
- [ 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' => 975,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (10498,24781,12159,13900,27301,14553,68799,62191,61649,49913,13263,13801,17775,15676,15596,12216,24928,14130,61620,19806,17024,11180,22049,17644,24552,18743,11178,28658,24297,24926,10979,12938,11079,10304,10822,11605,10927,10478,11271,11969,10410,14190,10870,11746,10307,11968,11112,12949,11113,10537,10859,13254,10732,12018,73352,10497,10734,25123,11528,16129,11530,16128,12019,18760,16655,18938,11841,25328,11119,14655,20710,19509,31991,28052,14595,20966,11176,19151,14564,44472,10572,24881,25296,22400,19378,21298,58546,21747,11964,21101,20967,28659,22048,19598,24927,16094,18314,24925,17784,15604,18750,20344,17110,24979,13140,19066,54668,68604,13462,13460,48420,15896,24882,35580,22047,41403,20188,32581,17643,12122,19452,32448,14138,77035,12123,21297,18745,67435,19521,58375,21033,15597,10795,16449,10482,10406,10309,12366,11083,20389,19320,11141,10481,25749,15918,23092,55687,62261,12247,21957,22809,18140,12246,21170,38384,72983,85751,29122,10476,13727,11143,21751,11082,13448,10983,10453,13265,13447,28053,21521,12505,25297,69751,50035,40641,61808,50100,70597,74336,74337,35288,33204,18309,22841,69667,55330,29117,15970,26500,82048,54582,49064,35381,51963,10634,13678,13611,14400,26242,37632,83569,77644,13449,10477,10116,77757,11138,11764,20634,26890,11016,11708,37357,21523,50141,77668,47482,34390,30209,22056,31174,19438,54684,60575,72909,77650,22076,18940,33369,18145,61283,32115,14725,26310,30180,33835,33675,72151,38355,77464,23935,59845,36063,85750,16015,49896,10062,10071,26048,18136,18702,21389,72651,33880,19338,37410,26167,31173,77688,37059,25731,23718,48090,19135,32764,13038,18116,23717,53389,23568,77853,23873,19132,10760,31801,19133,85694,85695,23061,23716,10344,11145,49794,53067,36350,38336,44306,34649,27685,38401,59318,62802,24041,58947,48737,25240,34656,38385,44165,27058,54817,37678,22491,37686,85727,59647,20783,32254,23731,32948,15523,17715,15925,29289,15720,16058,14197,12451,21191,38215,77646,79326,19699,12538,45699,79329,76744,60623,21404,24380,14041,14128,30267,32187,19443,14593,22655,13143,18748,24978,26877,15797,35857,23187,21368,74587,47124,57923,21138,29644,24558,76415,76412,51937,12833,41459,44885,57924,15824,14711,23758,13858,20812,10923,15184,11366,10877,22717,81807,81763,20015,10872,36126,15567,58633,14756,69116,69127,14478,29727,20117,16583,75046,21020,28724,30313,26997,14477,17616,15183,17958,24905,10962,53005,42008,16443,20957,36337,47424,20818,30342,15803,15579,72158,24294,23867,17002,16998,42094,14888,35456,30514,53289,14510,17811,23763,37163,31012,10660,13369,14052,17664,13477,17944,13274,10922,13269,11839,13372,17945,13271,17356,55882,13588,74597,52860,29592,19742,23902,23901,18403,52427,32179,17987,53132,26665,49039,41102,23225,20416,17452,38512,29541,44248,15419,17033,56876,25131,54659,41130,76740,35058,15518,22519,27278,27281,10921,18533,11153,26708,17566,26462,28389,20220,19691,23031,53344,17703,72041,20096,19823,32253,19829,29295,40573,84682,18839,15670,27007,46437,27968,32586,13122,16266,10124,16816,14679,35463,17074,24187,35455,10905,13864,11313,22092,41809,17634,13083,85092,18927,21598,12945,82025,11317,36502,25336,13423,24208,41492,47065,11699,57930,41402,85378,35317,13203,31639,28034,47184,20768,28033,10843,29137,29483,29431,31679,20767,12750,32091,42598,31029,25050,32945,31965,12608,29110,30076,31030,12749,30641,12309,31199,19826,11187,10422,13660,32999,14427,22490,29496,17501,47675,10561,61550,27926,36673,37097,45078,69397,37418,38097,21687,14116,14117,25966,25871,23519,22456,53565,55881,36526,15229,18658,30228,14963,20233,33091,52829,13102,39824,57672,36821,60265,24824,69481,61542,59687,72184,19758,12149,16891,30195,38693,18457,10818,11304,81410,34305,14009,14964,57461,34712,41716,28013,49962,28719,50564,50565,62594,53560,12391,19842,10496,10600,60977,77663,15974,10815,29215,44995,10756,10211,26206,18048,23834,19257,23267,47559,14814,21775,22342,21837,16657,21520,57671,28470,83739,50838,77645,77664,35074,35072,34126,31764,15569,24460,40341,45735,28715,27339,23974,28714,23804,26040,19130,21001,60751,64267,21067,16060,32154,23194,12789,31228,18342,32287,80938,72669,28224,29349,29863,26037,28067,29847,30404,52928,29133,76417,58506,30780,82381,25004,33738,74468,20106,19097,17491,27599,57391,48037,42291,11199,16945,24343,54559,25154,32387,14941,15522,32507,12597,19917,55837,19173,74713,11321,12624,12528,11039,11678,12433,12625,34515,18885,12627,25932,21539,22698,12148,18884,13161,12527,18350,33199,58129,53995,17618,22967,13057,21399,23800,11023,14183,36780,23040,23041,32278,27514,72188,12888,28828,58496,15798,10533,50493,22638,11946,18673,19034,21836,18113,79461,43710,22125,70663,81344,15674,18355,14965,20475,10117,12154,10757,10813,43229,41930,26603,15944,15588,47476,10989,21774,12340,47586,77629,31100,52560,12477,57787,28556,76335,52543,12475,29156,25833,29968,25895,57788,76334,41528,24307,22517,85155,21684,40103,81292,25533,44700,34100,10336,20273,10070,10457,10908,10526,59379,30068,32694,37641,23822,29337,34514,29336,23777,62889,38273,37840,22014,26866,24222,23823,10415,10417,10416,23021,59453,37975,46023,34304,74873,74380,19717,45373,47806,24758,49449,53797,57043,45893,62514,46969,32655,43055,76501,35506,10767,10223,14530,12239,10138,53336,29786,34466,33469,54569,21128,58906,17988,85696,17989,29885,11943,27739,48915,77510,77511,22314,21126,20371,14571,85106,76418,20907,81768,50944,82406,27364,81773,81774,82417,81772,13950,19986,69981,24807,58610,55731,20439,39897,41638,23280,29456,24718,85361,76973,85399,39549,21864,74617,13251,14633,24076,12761,24684,39878,27533,14344,10950,14251,35945,12207,10359,11402,10404,10353,13190,13191,15421,11314,28220,25751,27399,14815,42091,42087,20213,20212,58204,17569,26798,21342,20162,19191,52161,58202,75426,26800,58206,71476,20163,36040,19404,19938,59214,61773,11774,16147,41181,36823,20198,36140,17999,31505,27504,27727,13277,48197,28782,81760,14077,18010,76286,76282,75420,76264) [ RunTime:0.022254s ]
- [ 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' => 975,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT * FROM cmf_nami_competitions WHERE id IN ('529', '588', '32', '33', '5', '6', '2538', '123', '623', '640', '181', '199', '624', '589', '70', '122', '112', '136', '100') ORDER BY FIELD(id, '529', '588', '32', '33', '5', '6', '2538', '123', '623', '640', '181', '199', '624', '589', '70', '122', '112', '136', '100') limit 20 [ RunTime:0.004353s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nami_competitions',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '4',
'ref' => NULL,
'rows' => 19,
'filtered' => 100.0,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%wxpanguan.com%' LIMIT 1 [ RunTime:0.002999s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 397 [ RunTime:0.003054s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 756,
'filtered' => 9.999999046325684,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.003187s ]
- [ SQL ] SELECT * FROM `cmf_portal_post` `post` WHERE `site_id` = 62 AND `post_status` = 1 AND `post_type` = 1 AND `delete_time` = 0 AND ( `category_id` IN (397,398,399) ) AND ( `published_time` > 0 and `published_time` < 1725999275 ) ORDER BY `post_hits` DESC LIMIT 0,4 [ RunTime:0.003950s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'post',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'type_status_date,category_id,idx_siteid_deletetime_posttype_poststatus_publishedtime',
'key' => 'category_id',
'key_len' => '14',
'ref' => NULL,
'rows' => 207,
'filtered' => 0.08263935148715973,
'extra' => 'Using index condition; Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.003409s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 756,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_user` [ RunTime:0.003196s ]
- [ SQL ] SELECT `id`,`user_nickname` FROM `cmf_user` [ RunTime:0.002965s ]
- [ 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.004394s ]
- [ 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.004376s ]
- [ SQL ] SELECT `tag_id` FROM `cmf_portal_tag_post` WHERE `post_id` = 89727 [ RunTime:0.003738s ]
- [ 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' => 19,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_portal_tag` [ RunTime:0.006112s ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (12199,3278,11708,3349,42,6640,11703,4150,4063,4367,2351,3964,4355,12527,12591,12033,12588,12081,13799) [ RunTime:0.003975s ]
- [ 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' => 19,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 399 LIMIT 1 [ RunTime:0.002926s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `tag_id` FROM `cmf_portal_tag_post` WHERE `post_id` = 231850 [ RunTime:0.002944s ]
- [ 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 (14577,77,2064,2215,13362) [ RunTime:0.003269s ]
- [ 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` = 398 LIMIT 1 [ RunTime:0.004321s ]
- [ 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` = 267389 [ RunTime:0.002980s ]
- [ 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 (27892,27893,27894,27895,27896) [ RunTime:0.002897s ]
- [ 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` = 398 LIMIT 1 [ RunTime:0.002893s ]
- [ 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` = 267437 [ RunTime:0.003314s ]
- [ 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 (15841,22233,22234,22235,22236,22237) [ RunTime:0.003008s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => NULL,
'rows' => 6,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 398 LIMIT 1 [ RunTime:0.003695s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%wxpanguan.com%' LIMIT 1 [ RunTime:0.002904s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 397 [ RunTime:0.003531s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 756,
'filtered' => 9.999999046325684,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_portal_post` `post` WHERE `site_id` = 62 AND `post_status` = 1 AND `post_type` = 1 AND `delete_time` = 0 AND ( `category_id` IN (397,398,399) ) AND ( `published_time` > 0 and `published_time` < 1725999276 ) ORDER BY `post_hits` DESC LIMIT 0,8 [ RunTime:0.004432s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'post',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'type_status_date,category_id,idx_siteid_deletetime_posttype_poststatus_publishedtime',
'key' => 'category_id',
'key_len' => '14',
'ref' => NULL,
'rows' => 207,
'filtered' => 0.08263935148715973,
'extra' => 'Using index condition; Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.004992s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 756,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`user_nickname` FROM `cmf_user` [ RunTime:0.003476s ]
- [ 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.002863s ]
- [ 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` = 89727 [ RunTime:0.003066s ]
- [ 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' => 19,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (12199,3278,11708,3349,42,6640,11703,4150,4063,4367,2351,3964,4355,12527,12591,12033,12588,12081,13799) [ RunTime:0.002949s ]
- [ 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' => 19,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 399 LIMIT 1 [ RunTime:0.003027s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `tag_id` FROM `cmf_portal_tag_post` WHERE `post_id` = 231850 [ RunTime:0.003028s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'post_id',
'key' => 'post_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 5,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (14577,77,2064,2215,13362) [ RunTime:0.002951s ]
- [ 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` = 398 LIMIT 1 [ RunTime:0.002934s ]
- [ 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` = 267389 [ RunTime:0.003086s ]
- [ 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 (27892,27893,27894,27895,27896) [ RunTime:0.003004s ]
- [ 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` = 398 LIMIT 1 [ RunTime:0.002930s ]
- [ 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` = 267437 [ RunTime:0.003818s ]
- [ 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 (15841,22233,22234,22235,22236,22237) [ RunTime:0.004050s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => NULL,
'rows' => 6,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 398 LIMIT 1 [ RunTime:0.003540s ]
- [ 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` = 93301 [ RunTime:0.003250s ]
- [ 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 (13291,4720,212,622,2349,4841,5105,5807,5059,5402,5437,10239,4890,7351,12852,13216,14061) [ RunTime:0.003113s ]
- [ 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` = 399 LIMIT 1 [ RunTime:0.002829s ]
- [ 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` = 267388 [ RunTime:0.002852s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'post_id',
'key' => 'post_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 8,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (17320,21622,21623,21624,21625,21626,21627,21628) [ RunTime:0.002839s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => NULL,
'rows' => 8,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 398 LIMIT 1 [ RunTime:0.003489s ]
- [ 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` = 267436 [ RunTime:0.002958s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'post_id',
'key' => 'post_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 6,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (15984,24142,24143,24144,24145,24146) [ RunTime:0.003077s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => NULL,
'rows' => 6,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 398 LIMIT 1 [ RunTime:0.002904s ]
- [ 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` = 267541 [ RunTime:0.003555s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'post_id',
'key' => 'post_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 2,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (28537,28780) [ RunTime:0.002903s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => NULL,
'rows' => 2,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 398 LIMIT 1 [ RunTime:0.003138s ]
- [ 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 '%wxpanguan.com%' LIMIT 1 [ RunTime:0.003033s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 399 [ RunTime:0.003422s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 756,
'filtered' => 9.999999046325684,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_portal_post` `post` WHERE `site_id` = 62 AND `post_status` = 1 AND `post_type` = 1 AND `delete_time` = 0 AND ( `category_id` = 399 ) AND ( `published_time` > 0 and `published_time` < 1725999276 ) ORDER BY `published_time` DESC LIMIT 1,11 [ RunTime:0.006016s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'type_status_date,category_id,idx_siteid_deletetime_posttype_poststatus_publishedtime',
'key' => 'category_id',
'key_len' => '14',
'ref' => 'const,const,const,const',
'rows' => 16,
'filtered' => 0.3125,
'extra' => 'Using index condition; Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.003337s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 756,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`user_nickname` FROM `cmf_user` [ RunTime:0.002978s ]
- [ 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.003029s ]
- [ 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` = 93586 [ RunTime:0.003387s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'post_id',
'key' => 'post_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 27,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (13408,2300,12018,3268,171,1628,3409,3428,3108,4982,2335,3353,3798,11807,11821,13046,12280,13126,11810,12841,12047,11743,11795,11929,14148,14169) [ RunTime:0.003041s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => NULL,
'rows' => 26,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 399 LIMIT 1 [ RunTime:0.003284s ]
- [ 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` = 93301 [ RunTime:0.002870s ]
- [ 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 (13291,4720,212,622,2349,4841,5105,5807,5059,5402,5437,10239,4890,7351,12852,13216,14061) [ RunTime:0.002961s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => NULL,
'rows' => 17,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 399 LIMIT 1 [ RunTime:0.002932s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `tag_id` FROM `cmf_portal_tag_post` WHERE `post_id` = 93299 [ RunTime:0.003055s ]
- [ 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' => 36,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (13290,230,2342,1298,3823,245,6976,5850,12618,7241,12456,13395,3843,8332,12784,3916,6010,6165,5851,5323,13375,12268,12439,5811,11783,12615,12607,13985,3390,14243,11949,11778,13830,12625,12596,13175) [ RunTime:0.003115s ]
- [ 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' => 36,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 399 LIMIT 1 [ RunTime:0.003117s ]
- [ 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` = 92943 [ RunTime:0.004375s ]
- [ 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 (13089,263,3329,2482,3824,3844,5772,6472,12912,6752,13397,11857,13376,13322,11817,12712,11868,13648,11749,12634,11980,13889,13317,12627,3391,12217) [ RunTime:0.004873s ]
- [ 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` = 399 LIMIT 1 [ RunTime:0.003566s ]
- [ 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` = 92940 [ RunTime:0.003065s ]
- [ 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' => 24,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (13086,2335,171,1628,3268,4982,2300,3798,13046,3353,11810,3409,3108,12280,3428,11807,12841,12018,12047,11821,11743,11795,11929) [ RunTime:0.003025s ]
- [ 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' => 23,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 399 LIMIT 1 [ RunTime:0.002959s ]
- [ 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` = 92636 [ RunTime:0.003037s ]
- [ 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' => 23,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (12982,1298,6976,5850,230,11783,2342,12784,12607,3916,3823,3843,12439,12625,12615,12618,12456,12268,3390,11949,11778,12596,13175) [ RunTime:0.002978s ]
- [ 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' => 23,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 399 LIMIT 1 [ RunTime:0.002884s ]
- [ 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` = 92635 [ RunTime:0.003359s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'post_id',
'key' => 'post_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 21,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (12981,3844,263,6472,5772,2482,3824,3329,12912,6752,11857,13376,11817,12712,11749,12634,11980,13317,12627,3391,12217) [ RunTime:0.002943s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => NULL,
'rows' => 21,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 399 LIMIT 1 [ RunTime:0.002884s ]
- [ 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` = 90009 [ RunTime:0.003069s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'post_id',
'key' => 'post_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 17,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (12688,12715,5620,12641,6402,12677,13204,13198,12775,11818,13613,6916,11747,12311,13219,10525,14010) [ RunTime:0.003235s ]
- [ 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` = 399 LIMIT 1 [ RunTime:0.003013s ]
- [ 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` = 90006 [ RunTime:0.003397s ]
- [ 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' => 31,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (12685,1328,263,2482,647,3824,3329,5772,3844,12912,6472,5274,9243,6752,6665,11857,13376,8587,9286,11817,12712,11749,12634,14075,14011,11980,13317,12627,3391,12231,12217) [ RunTime:0.003414s ]
- [ 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' => 31,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 399 LIMIT 1 [ RunTime:0.003332s ]
- [ 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` = 89885 [ RunTime:0.003063s ]
- [ 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' => 46,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (12450,1628,3268,3108,2300,171,3409,2335,1298,4982,6976,3843,3823,3916,11807,230,3353,3428,11810,3798,12280,12615,2342,5850,12625,12439,11783,12784,12841,12607,13046,12018,12047,11821,12618,12456,12268,11743,11795,11929,3390,11949,11778,12596,13175) [ RunTime:0.003003s ]
- [ 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' => 45,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 399 LIMIT 1 [ RunTime:0.003137s ]
- [ 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` = 89883 [ RunTime:0.002984s ]
- [ 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' => 21,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (12448,939,11808,12614,11811,12661,12573,12493,12388,13483,12785,13656,13181,12633,11879,13734,13173,13463,11983,13569,1506) [ RunTime:0.003127s ]
- [ 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' => 21,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 399 LIMIT 1 [ RunTime:0.003024s ]
- [ 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 '%wxpanguan.com%' LIMIT 1 [ RunTime:0.002967s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 399 [ RunTime:0.002991s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 756,
'filtered' => 9.999999046325684,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_portal_post` `post` WHERE `site_id` = 62 AND `post_status` = 1 AND `post_type` = 1 AND `delete_time` = 0 AND ( `category_id` = 399 ) AND ( `published_time` > 0 and `published_time` < 1725999276 ) ORDER BY `published_time` DESC LIMIT 0,1 [ RunTime:0.003265s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'type_status_date,category_id,idx_siteid_deletetime_posttype_poststatus_publishedtime',
'key' => 'category_id',
'key_len' => '14',
'ref' => 'const,const,const,const',
'rows' => 16,
'filtered' => 0.3125,
'extra' => 'Using index condition; Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.003253s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 756,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`user_nickname` FROM `cmf_user` [ RunTime:0.003016s ]
- [ 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.003834s ]
- [ 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` = 170960 [ RunTime:0.003291s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'post_id',
'key' => 'post_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 8,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (14346,939,6402,11808,11983,12633,13734,11811) [ RunTime:0.003151s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => NULL,
'rows' => 8,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 399 LIMIT 1 [ RunTime:0.002947s ]
- [ 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 '%wxpanguan.com%' LIMIT 1 [ RunTime:0.003141s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 398 [ RunTime:0.003024s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 756,
'filtered' => 9.999999046325684,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_portal_post` `post` WHERE `site_id` = 62 AND `post_status` = 1 AND `post_type` = 1 AND `delete_time` = 0 AND ( `category_id` = 398 ) AND ( `published_time` > 0 and `published_time` < 1725999276 ) ORDER BY `published_time` DESC LIMIT 1,11 [ RunTime:0.003916s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'type_status_date,category_id,idx_siteid_deletetime_posttype_poststatus_publishedtime',
'key' => 'category_id',
'key_len' => '14',
'ref' => 'const,const,const,const',
'rows' => 190,
'filtered' => 0.08263915777206421,
'extra' => 'Using index condition; Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.003165s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 756,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`user_nickname` FROM `cmf_user` [ RunTime:0.002873s ]
- [ 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.002759s ]
- [ 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` = 271006 [ RunTime:0.003043s ]
- [ 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 (28537,32665,28538) [ RunTime:0.002919s ]
- [ 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` = 398 LIMIT 1 [ RunTime:0.002892s ]
- [ 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` = 270833 [ RunTime:0.002866s ]
- [ 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 (17220,24802,24803,24804,24805,24806,24807) [ RunTime:0.002870s ]
- [ 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` = 398 LIMIT 1 [ RunTime:0.002857s ]
- [ 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` = 270690 [ RunTime:0.003233s ]
- [ 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 (28537,32066,29653) [ RunTime:0.003105s ]
- [ 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` = 398 LIMIT 1 [ RunTime:0.003087s ]
- [ 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` = 270625 [ RunTime:0.002886s ]
- [ 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 (31986,31987,31988) [ RunTime:0.002873s ]
- [ 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` = 398 LIMIT 1 [ RunTime:0.002928s ]
- [ 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` = 270387 [ RunTime:0.002982s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'post_id',
'key' => 'post_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 8,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (17320,21622,21623,21624,21625,21626,21627,21628) [ RunTime:0.002951s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => NULL,
'rows' => 8,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 398 LIMIT 1 [ RunTime:0.002885s ]
- [ 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` = 270373 [ RunTime:0.002916s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'post_id',
'key' => 'post_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 4,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (28537,29653,31596,29255) [ RunTime:0.002882s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => NULL,
'rows' => 4,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 398 LIMIT 1 [ RunTime:0.002936s ]
- [ 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` = 270299 [ RunTime:0.002856s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'post_id',
'key' => 'post_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 2,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (31524,31525) [ RunTime:0.002975s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => NULL,
'rows' => 2,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 398 LIMIT 1 [ RunTime:0.002876s ]
- [ 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` = 270184 [ RunTime:0.002944s ]
- [ 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 (16243,23349,23350,23351,23352,23353,23354) [ RunTime:0.002932s ]
- [ 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` = 398 LIMIT 1 [ RunTime:0.002979s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `tag_id` FROM `cmf_portal_tag_post` WHERE `post_id` = 270035 [ RunTime:0.002955s ]
- [ 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 (28537,30926,30927) [ RunTime:0.002936s ]
- [ 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` = 398 LIMIT 1 [ RunTime:0.002930s ]
- [ 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` = 269984 [ RunTime:0.002972s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'post_id',
'key' => 'post_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 8,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (17320,21622,21623,21624,21625,21626,21627,21628) [ RunTime:0.002916s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => NULL,
'rows' => 8,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 398 LIMIT 1 [ RunTime:0.002923s ]
- [ 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` = 269983 [ RunTime:0.002930s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'post_id',
'key' => 'post_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 8,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (17320,21622,21623,21624,21625,21626,21627,21628) [ RunTime:0.003076s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => NULL,
'rows' => 8,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 398 LIMIT 1 [ RunTime:0.002955s ]
- [ 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 '%wxpanguan.com%' LIMIT 1 [ RunTime:0.002904s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 398 [ RunTime:0.003040s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 756,
'filtered' => 9.999999046325684,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_portal_post` `post` WHERE `site_id` = 62 AND `post_status` = 1 AND `post_type` = 1 AND `delete_time` = 0 AND ( `category_id` = 398 ) AND ( `published_time` > 0 and `published_time` < 1725999276 ) ORDER BY `published_time` DESC LIMIT 0,1 [ RunTime:0.003726s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'type_status_date,category_id,idx_siteid_deletetime_posttype_poststatus_publishedtime',
'key' => 'category_id',
'key_len' => '14',
'ref' => 'const,const,const,const',
'rows' => 190,
'filtered' => 0.08263906091451645,
'extra' => 'Using index condition; Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.003171s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 756,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`user_nickname` FROM `cmf_user` [ RunTime:0.002905s ]
- [ 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.002907s ]
- [ 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` = 271234 [ RunTime:0.002915s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'post_id',
'key' => 'post_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 4,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (28537,33071,28918,29517) [ RunTime:0.002943s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => NULL,
'rows' => 4,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 398 LIMIT 1 [ RunTime:0.002921s ]
- [ 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 '%wxpanguan.com%' LIMIT 1 [ RunTime:0.002877s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 400 [ RunTime:0.003158s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 756,
'filtered' => 9.999999046325684,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_portal_post` `post` WHERE `site_id` = 62 AND `post_status` = 1 AND `post_type` = 1 AND `delete_time` = 0 AND ( `category_id` IN (400,401,402) ) AND ( `published_time` > 0 and `published_time` < 1725999276 ) ORDER BY `published_time` DESC LIMIT 0,1 [ RunTime:0.003244s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'post',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'type_status_date,category_id,idx_siteid_deletetime_posttype_poststatus_publishedtime',
'key' => 'idx_siteid_deletetime_posttype_poststatus_publishedtime',
'key_len' => '15',
'ref' => NULL,
'rows' => 9278,
'filtered' => 30.000001907348633,
'extra' => 'Using index condition; Using where',
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.003140s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 756,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`user_nickname` FROM `cmf_user` [ RunTime:0.002889s ]
- [ 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.002944s ]
- [ 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` = 933936 [ RunTime:0.002876s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'post_id',
'key' => 'post_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 2,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (15662,15844) [ RunTime:0.002884s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => NULL,
'rows' => 2,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 400 LIMIT 1 [ RunTime:0.002813s ]
- [ 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 '%wxpanguan.com%' LIMIT 1 [ RunTime:0.002948s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 400 [ RunTime:0.003021s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 756,
'filtered' => 9.999999046325684,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_portal_post` `post` WHERE `site_id` = 62 AND `post_status` = 1 AND `post_type` = 1 AND `delete_time` = 0 AND ( `category_id` IN (400,401,402) ) AND ( `published_time` > 0 and `published_time` < 1725999276 ) ORDER BY `published_time` DESC LIMIT 0,10 [ RunTime:0.003305s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'post',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'type_status_date,category_id,idx_siteid_deletetime_posttype_poststatus_publishedtime',
'key' => 'idx_siteid_deletetime_posttype_poststatus_publishedtime',
'key_len' => '15',
'ref' => NULL,
'rows' => 9278,
'filtered' => 30.000001907348633,
'extra' => 'Using index condition; Using where',
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.003152s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 756,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`user_nickname` FROM `cmf_user` [ RunTime:0.002938s ]
- [ 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.002887s ]
- [ 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` = 933936 [ RunTime:0.003028s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'post_id',
'key' => 'post_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 2,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (15662,15844) [ RunTime:0.003209s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => NULL,
'rows' => 2,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 400 LIMIT 1 [ RunTime:0.002948s ]
- [ 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` = 933797 [ RunTime:0.002923s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'post_id',
'key' => 'post_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 2,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (15662,15844) [ RunTime:0.002808s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => NULL,
'rows' => 2,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 400 LIMIT 1 [ RunTime:0.002831s ]
- [ 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` = 933658 [ RunTime:0.002729s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'post_id',
'key' => 'post_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 2,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (15662,15844) [ RunTime:0.002880s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => NULL,
'rows' => 2,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 400 LIMIT 1 [ RunTime:0.002853s ]
- [ 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` = 933519 [ RunTime:0.002919s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'post_id',
'key' => 'post_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 4,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (42832,42833,15662,15844) [ RunTime:0.002888s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => NULL,
'rows' => 4,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 400 LIMIT 1 [ RunTime:0.002919s ]
- [ 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` = 933380 [ RunTime:0.002792s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'post_id',
'key' => 'post_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 2,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (15662,15844) [ RunTime:0.002815s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => NULL,
'rows' => 2,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 400 LIMIT 1 [ RunTime:0.002805s ]
- [ 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` = 933241 [ RunTime:0.002997s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'post_id',
'key' => 'post_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 2,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (15662,15844) [ RunTime:0.002903s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => NULL,
'rows' => 2,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 400 LIMIT 1 [ RunTime:0.002836s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `tag_id` FROM `cmf_portal_tag_post` WHERE `post_id` = 933102 [ RunTime:0.003077s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'post_id',
'key' => 'post_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 4,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (15662,15844,36302,36303) [ RunTime:0.002956s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => NULL,
'rows' => 4,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 400 LIMIT 1 [ RunTime:0.003036s ]
- [ 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` = 932963 [ RunTime:0.003111s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'post_id',
'key' => 'post_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 4,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (37903,37904,15662,15844) [ RunTime:0.002927s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => NULL,
'rows' => 4,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 400 LIMIT 1 [ RunTime:0.002866s ]
- [ 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` = 932824 [ RunTime:0.002909s ]
- [ 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 (15662,15844,38939) [ RunTime:0.002908s ]
- [ 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` = 400 LIMIT 1 [ RunTime:0.002801s ]
- [ 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` = 932685 [ RunTime:0.003109s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'post_id',
'key' => 'post_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 4,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (40661,40662,15662,15844) [ RunTime:0.002955s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => NULL,
'rows' => 4,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 400 LIMIT 1 [ RunTime:0.002922s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%wxpanguan.com%' LIMIT 1 [ RunTime:0.003083s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 124,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_link` [ RunTime:0.003203s ]
- [ SQL ] SELECT * FROM `cmf_link` WHERE `status` = 1 AND `site_id` = 62 ORDER BY `list_order` ASC [ RunTime:0.003094s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_link',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => 'status',
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 7,
'filtered' => 14.285713195800781,
'extra' => 'Using where; Using filesort',
) ]
2.089305s
赛事
时间
状态
对阵
直播源
