09月10日
星期二
09月11日
星期三
09月12日
星期四
09月13日
星期五
07:30
下半场
独立FBC
vs
伊特洛体育会
08:00
下半场
波哥大足球会
vs
皇家桑坦德
08:00
下半场
瓦鲁尔FC
vs
渥太华竞技
08:00
下半场
格林纳达
vs
圣卢西亚
08:00
下半场
阿鲁巴
vs
波多黎各
08:10
下半场
科勒加勒斯
vs
洛斯安第斯
08:30
中场
庞特普雷塔
vs
沙佩科恩斯
09:30
未开赛
陶罗
vs
CD尤尼维尔斯塔里奥
10:00
未开赛
危地马拉
vs
哥斯达黎加
14:00
未开赛
广西平果呗侬女足
vs
河北君乐宝女足
14:00
未开赛
辽宁沈北禾丰女足
vs
大连女足
15:30
未开赛
中国U21
vs
乌兹别克U21
16:00
未开赛
蒙古
vs
东帝汶
16:00
未开赛
摩尔多瓦U18
vs
罗马尼亚U18
16:00
未开赛
罗马尼亚U16
vs
捷克U16
16:00
未开赛
波黑女足U19
vs
波兰女足U19
00:00
未开赛
加蓬
vs
中非
00:00
未开赛
几内亚
vs
坦桑尼亚
00:00
未开赛
利比里亚
vs
阿尔及利亚
00:00
未开赛
纳米比亚
vs
肯尼亚
00:00
未开赛
津巴布韦
vs
喀麦隆
00:00
未开赛
阿联酋
vs
伊朗
00:00
未开赛
巴林
vs
日本
00:00
未开赛
爱尔兰U21
vs
拉脱维亚U21
00:00
未开赛
爱沙尼亚U21
vs
德国U21
00:00
未开赛
保加利亚U21
vs
波兰U21
00:00
未开赛
斯洛文尼亚U21
vs
塞浦路斯U21
00:00
未开赛
丹麦U21
vs
捷克U21
00:00
未开赛
尼特拉
vs
布拉迪斯拉发
00:00
未开赛
拉脱维亚
vs
法罗群岛
00:00
未开赛
摩尔多瓦
vs
圣马力诺
00:00
未开赛
帕瓦罗维科特
vs
FF雅罗B队
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-10 09:23:57 HTTP/2.0 GET : https://www.wxpanguan.com/index.php?m=home&c=Tags&a=lists&tagid=40
- 运行时间 : 1.386162s [ 吞吐率：0.72req/s ] 内存消耗：6,160.15kb 文件加载：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' => 'www.wxpanguan.com',
'content-length' => '',
'content-type' => '',
)
- [ PARAM ] array (
'm' => 'home',
'c' => 'Tags',
'a' => 'lists',
'tagid' => '40',
)
- [ 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.003957s ] mysql:host=rm-3ns41jmtlb1g0zd6v.mysql.rds.aliyuncs.com;port=3306;dbname=daxiong;charset=utf8mb4
- [ SQL ] SHOW COLUMNS FROM `cmf_plugin_web` [ RunTime:0.002132s ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.wxpanguan.com%' LIMIT 1 [ RunTime:0.001760s ]
- [ 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' => 138,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.wxpanguan.com%' LIMIT 1 [ RunTime:0.001839s ]
- [ 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' => 138,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_plugin` [ RunTime:0.001957s ]
- [ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Web' AND `site_id` = 62 LIMIT 1 [ RunTime:0.001809s ]
- [ 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' => 146,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.wxpanguan.com%' LIMIT 1 [ RunTime:0.002190s ]
- [ 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' => 138,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_option` [ RunTime:0.001976s ]
- [ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'cdn_settings' AND `site_id` = 62 LIMIT 1 [ RunTime:0.001882s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_option',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'site_id',
'key' => 'site_id',
'key_len' => '5',
'ref' => 'const',
'rows' => 5,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.wxpanguan.com%' LIMIT 1 [ RunTime:0.010598s ]
- [ 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' => 138,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.wxpanguan.com%' LIMIT 1 [ RunTime:0.001913s ]
- [ 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' => 138,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 62 LIMIT 1 [ RunTime:0.001722s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.wxpanguan.com%' LIMIT 1 [ RunTime:0.001726s ]
- [ 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' => 138,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.wxpanguan.com%' LIMIT 1 [ RunTime:0.001800s ]
- [ 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' => 138,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.wxpanguan.com%' LIMIT 1 [ RunTime:0.001779s ]
- [ 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' => 138,
'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.001900s ]
- [ 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.001802s ]
- [ 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.001947s ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` WHERE `status` = 1 [ RunTime:0.002837s ]
- [ 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' => 840,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.wxpanguan.com%' LIMIT 1 [ RunTime:0.001824s ]
- [ 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' => 138,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_plugin_web` WHERE `id` = 62 LIMIT 1 [ RunTime:0.001696s ]
- [ 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.002203s ]
- [ SQL ] SELECT `pinyin` FROM `cmf_nami_competitions` WHERE `id` = 0 LIMIT 1 [ RunTime:0.001992s ]
- [ 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.001941s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => NULL,
'partitions' => NULL,
'type' => NULL,
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => NULL,
'filtered' => NULL,
'extra' => 'no matching row in const table',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.wxpanguan.com%' LIMIT 1 [ RunTime:0.001963s ]
- [ 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' => 138,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.wxpanguan.com%' LIMIT 1 [ RunTime:0.001869s ]
- [ 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' => 138,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_nav_menu` [ RunTime:0.002072s ]
- [ 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.002469s ]
- [ 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' => 954,
'filtered' => 0.10482180118560791,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.001886s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'seo_pc' AND `file` = 'portal/article' LIMIT 1 [ RunTime:0.001754s ]
- [ 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' => 249,
'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.002000s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'seo_pc' AND `file` = 'portal/competition' LIMIT 1 [ RunTime:0.001792s ]
- [ 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' => 249,
'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.001955s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'seo_pc' AND `file` = 'portal/index' LIMIT 1 [ RunTime:0.001874s ]
- [ 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' => 249,
'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.001927s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'seo_pc' AND `file` = 'portal/list' LIMIT 1 [ RunTime:0.001859s ]
- [ 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' => 249,
'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.001920s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'seo_pc' AND `file` = 'portal/match' LIMIT 1 [ RunTime:0.001926s ]
- [ 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' => 249,
'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.002062s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'seo_pc' AND `file` = 'portal/tag' LIMIT 1 [ RunTime:0.001755s ]
- [ 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' => 249,
'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.001956s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'seo_pc' [ RunTime:0.001846s ]
- [ 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' => 249,
'filtered' => 9.999999046325684,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_theme` [ RunTime:0.001909s ]
- [ 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.001728s ]
- [ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = 'seo_pc' AND ( `is_public` = 1 OR `file` = 'portal/index' ) [ RunTime:0.001854s ]
- [ 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' => 249,
'filtered' => 1.899999976158142,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.wxpanguan.com%' LIMIT 1 [ RunTime:0.001657s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_plugin_web',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 138,
'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.001653s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_option',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'site_id',
'key' => 'site_id',
'key_len' => '5',
'ref' => 'const',
'rows' => 5,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.wxpanguan.com%' LIMIT 1 [ RunTime:0.001927s ]
- [ 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' => 138,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Oss' AND `site_id` = 62 LIMIT 1 [ RunTime:0.001830s ]
- [ 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' => 146,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.wxpanguan.com%' LIMIT 1 [ RunTime:0.001784s ]
- [ 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' => 138,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.wxpanguan.com%' LIMIT 1 [ RunTime:0.001998s ]
- [ 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' => 138,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_nav` [ RunTime:0.002004s ]
- [ SQL ] SELECT `id` FROM `cmf_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.001769s ]
- [ 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.002183s ]
- [ 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' => 954,
'filtered' => 0.10482180118560791,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.wxpanguan.com%' LIMIT 1 [ RunTime:0.001756s ]
- [ 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' => 138,
'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.003780s ]
- [ 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.003118s ]
- [ 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' => 3832,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_nami_matches` [ RunTime:0.002043s ]
- [ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `com_type` = 0 AND ( `match_time` > 1725924237 ) ORDER BY `match_time` ASC LIMIT 500 [ RunTime:0.004657s ]
- [ 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' => 21698,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` IN (2927,476,2984,2922,431,436,1673,3134,34,490,1794,2952,2915,325,188,3,4460,97,675,1778,700,239,51,1357,276,1776,277,338,3014,24,260,349,217,625,302,3019,3845,1881,2906,1940,132,2836,100,470,2914,86,90,1715,1586,1824,4,486,464,1895,4474,1834,1748,1788,119,577,613,2778,269,1796,2000,673,331,1666,89,254,354,297,323,1704,1819,1733,264,205,365,1094,1163,1729,138,133,2104,194,978,2737,2101,124,226,1767,452,1683,488,469,18,435,3380,475,3139,1768,458,450,489,586,357,659,545,350,371,3394,3075,196,197,348,6907,674,281,376,85) [ RunTime:0.004287s ]
- [ 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' => 121,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` IN (2927,476,2984,2922,431,436,1673,3134,34,490,1794,2952,2915,325,188,3,4460,97,675,1778,700,239,51,1357,276,1776,277,338,3014,24,260,349,217,625,302,3019,3845,1881,2906,1940,132,2836,100,470,2914,86,90,1715,1586,1824,4,486,464,1895,4474,1834,1748,1788,119,577,613,2778,269,1796,2000,673,331,1666,89,254,354,297,323,1704,1819,1733,264,205,365,1094,1163,1729,138,133,2104,194,978,2737,2101,124,226,1767,452,1683,488,469,18,435,3380,475,3139,1768,458,450,489,586,357,659,545,350,371,3394,3075,196,197,348,6907,674,281,376,85) [ RunTime:0.002799s ]
- [ 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' => 121,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_nami_teams` [ RunTime:0.002016s ]
- [ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (13947,31501,20236,24581,51330,56561,23091,25793,21749,20019,31080,25111,10812,10816,21465,47378,12065,11837,69554,22810,76815,76816,28459,11478,21200,13574,12719,25844,20655,12292,20525,20210,11714,12334,76821,78601,58224,26892,22076,31173,21370,16810,12136,18321,15476,15552,18483,14011,14749,17096,75071,49696,75082,35542,12881,17314,71661,76453,15690,11687,32523,21003,13495,15258,20320,17358,13238,19579,17047,11258,11266,11289,11269,13832,11677,13366,11087,10584,17463,15069,31229,14440,31345,31232,14211,30426,32978,16505,23869,25736,16437,69638,41752,62929,10635,13464,15917,12066,11291,20595,11272,13728,33065,10310,13071,21361,11145,11210,30429,31231,31346,71805,66720,72604,12161,11085,37528,48868,10894,28004,49959,22061,23731,32948,12318,14665,21881,20653,10262,14894,14386,10582,12258,10586,13739,11267,16632,10581,11569,11570,32944,61765,47140,13500,27088,17123,72574,17768,61463,51615,54111,55670,22425,18913,53018,42380,15186,14630,20087,19001,25208,11719,10343,12155,10580,10514,15770,17382,23351,17646,23823,29339,11813,12870,12972,13862,84696,11814,20020,23561,25962,53882,17352,21292,24217,30188,24686,24215,69940,74990,11157,15732,13116,25591,11196,12705,17419,16516,19915,29128,11019,13899,10480,20018,13612,15919,10510,23383,16890,14267,15916,11707,10583,14298,10587,14529,11213,13638,14085,12156,10515,11209,13639,11836,11144,10578,19057,11407,12629,10306,11080,12259,45774,75095,35801,33260,83423,51871,13989,13737,12157,11211,17418,11766,10311,10513,11147,18307,25814,68431,15814,20795,20077,82870,13475,16011,11765,13738,11367,36482,39622,10959,48465,23913,26350,12691,31217,20994,11812,11312,10676,10396,10512,13547,13922,16464,52494,55365,13022,38179,21081,11146,10730,57781,14174,11288,12427,32534,10498,24781,12159,13900,27301,14553,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,13462,13460,48420,15896,24882,35580,22047,41403,20188,32581,17643,12122,10482,10406,10309,12366,11083,20389,19320,11141,10481,25749,15918,23092,11138,11764,12247,21957,22809,18140,12246,21170,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,10634,13678,13611,14400,26242,37632,83569,77644,13449,10477,11016,11708,50141,77668,30209,22056,54684,60575,72909,77650,33369,18145,61283,32115,14725,26310,30180,33835,33675,72151,38355,77464,10062,10071,26048,18136,18702,21389,72651,33880,19338,37410,77688,37059,25731,23718,48090,19135,32764,13038,18116,23717,53389,23568,77853,23873,19132,10760,31801,19133,85694,85695,23061,23716,10344,49794,53067,36350,38336,44306,34649,27685,38401,29541,44248,59318,62802,23935,59845,24041,58947,48737,25240,34656,38385,38384,72983,44165,27058,38388,62195,54817,37678,22491,37686,85727,59647,15523,17715,13477,17944,15925,29289,15720,16058,14197,12451,21191,38215,77646,79326,19699,12538,45699,79329,76744,60623,21404,24380,14041,14128,22048,19598,19443,14593,24927,16094,18314,24925,17784,15604,18750,20344,22655,13143,17110,24979,13140,19066,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,13478,15381,37163,31012,10660,13369,20015,10872,14052,17664,50029,16746,13274,10922,13269,11839,36126,15567,13372,17945,13271,17356,12712,21759,55882,13588,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,74597,52860,29592,19742,23902,23901,18403,52427,32179,17987,53132,26665,49039,41102,23225,20416,17452,38512,15419,17033,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,20634,26890,37357,21523,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) [ RunTime:0.014996s ]
- [ 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' => 993,
'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 (13947,31501,20236,24581,51330,56561,23091,25793,21749,20019,31080,25111,10812,10816,21465,47378,12065,11837,69554,22810,76815,76816,28459,11478,21200,13574,12719,25844,20655,12292,20525,20210,11714,12334,76821,78601,58224,26892,22076,31173,21370,16810,12136,18321,15476,15552,18483,14011,14749,17096,75071,49696,75082,35542,12881,17314,71661,76453,15690,11687,32523,21003,13495,15258,20320,17358,13238,19579,17047,11258,11266,11289,11269,13832,11677,13366,11087,10584,17463,15069,31229,14440,31345,31232,14211,30426,32978,16505,23869,25736,16437,69638,41752,62929,10635,13464,15917,12066,11291,20595,11272,13728,33065,10310,13071,21361,11145,11210,30429,31231,31346,71805,66720,72604,12161,11085,37528,48868,10894,28004,49959,22061,23731,32948,12318,14665,21881,20653,10262,14894,14386,10582,12258,10586,13739,11267,16632,10581,11569,11570,32944,61765,47140,13500,27088,17123,72574,17768,61463,51615,54111,55670,22425,18913,53018,42380,15186,14630,20087,19001,25208,11719,10343,12155,10580,10514,15770,17382,23351,17646,23823,29339,11813,12870,12972,13862,84696,11814,20020,23561,25962,53882,17352,21292,24217,30188,24686,24215,69940,74990,11157,15732,13116,25591,11196,12705,17419,16516,19915,29128,11019,13899,10480,20018,13612,15919,10510,23383,16890,14267,15916,11707,10583,14298,10587,14529,11213,13638,14085,12156,10515,11209,13639,11836,11144,10578,19057,11407,12629,10306,11080,12259,45774,75095,35801,33260,83423,51871,13989,13737,12157,11211,17418,11766,10311,10513,11147,18307,25814,68431,15814,20795,20077,82870,13475,16011,11765,13738,11367,36482,39622,10959,48465,23913,26350,12691,31217,20994,11812,11312,10676,10396,10512,13547,13922,16464,52494,55365,13022,38179,21081,11146,10730,57781,14174,11288,12427,32534,10498,24781,12159,13900,27301,14553,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,13462,13460,48420,15896,24882,35580,22047,41403,20188,32581,17643,12122,10482,10406,10309,12366,11083,20389,19320,11141,10481,25749,15918,23092,11138,11764,12247,21957,22809,18140,12246,21170,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,10634,13678,13611,14400,26242,37632,83569,77644,13449,10477,11016,11708,50141,77668,30209,22056,54684,60575,72909,77650,33369,18145,61283,32115,14725,26310,30180,33835,33675,72151,38355,77464,10062,10071,26048,18136,18702,21389,72651,33880,19338,37410,77688,37059,25731,23718,48090,19135,32764,13038,18116,23717,53389,23568,77853,23873,19132,10760,31801,19133,85694,85695,23061,23716,10344,49794,53067,36350,38336,44306,34649,27685,38401,29541,44248,59318,62802,23935,59845,24041,58947,48737,25240,34656,38385,38384,72983,44165,27058,38388,62195,54817,37678,22491,37686,85727,59647,15523,17715,13477,17944,15925,29289,15720,16058,14197,12451,21191,38215,77646,79326,19699,12538,45699,79329,76744,60623,21404,24380,14041,14128,22048,19598,19443,14593,24927,16094,18314,24925,17784,15604,18750,20344,22655,13143,17110,24979,13140,19066,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,13478,15381,37163,31012,10660,13369,20015,10872,14052,17664,50029,16746,13274,10922,13269,11839,36126,15567,13372,17945,13271,17356,12712,21759,55882,13588,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,74597,52860,29592,19742,23902,23901,18403,52427,32179,17987,53132,26665,49039,41102,23225,20416,17452,38512,15419,17033,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,20634,26890,37357,21523,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) [ RunTime:0.010589s ]
- [ 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' => 993,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT `cid` FROM `cmf_nami_competitions` WHERE `pinyin` = AND `com_type` = 0 LIMIT 1 [ RunTime:0.003355s ]
- [ 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' => 3832,
'filtered' => 1.0000001192092896,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_matches` WHERE `com_type` = 0 AND ( `match_time` > 1725924237 ) ORDER BY `match_time` ASC LIMIT 500 [ RunTime:0.004071s ]
- [ 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' => 21698,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 0 AND `cid` IN (2927,476,2984,2922,431,436,1673,3134,34,490,1794,2952,2915,325,188,3,4460,97,675,1778,700,239,51,1357,276,1776,277,338,3014,24,260,349,217,625,302,3019,3845,1881,2906,1940,132,2836,100,470,2914,86,90,1715,1586,1824,4,486,464,1895,4474,1834,1748,1788,119,577,613,2778,269,1796,2000,673,331,1666,89,254,354,297,323,1704,1819,1733,264,205,365,1094,1163,1729,138,133,2104,194,978,2737,2101,124,226,1767,452,1683,488,469,18,435,3380,475,3139,1768,458,450,489,586,357,659,545,350,371,3394,3075,196,197,348,6907,674,281,376,85) [ RunTime:0.003380s ]
- [ 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' => 121,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT * FROM `cmf_nami_competitions` WHERE `com_type` = 1 AND `cid` IN (2927,476,2984,2922,431,436,1673,3134,34,490,1794,2952,2915,325,188,3,4460,97,675,1778,700,239,51,1357,276,1776,277,338,3014,24,260,349,217,625,302,3019,3845,1881,2906,1940,132,2836,100,470,2914,86,90,1715,1586,1824,4,486,464,1895,4474,1834,1748,1788,119,577,613,2778,269,1796,2000,673,331,1666,89,254,354,297,323,1704,1819,1733,264,205,365,1094,1163,1729,138,133,2104,194,978,2737,2101,124,226,1767,452,1683,488,469,18,435,3380,475,3139,1768,458,450,489,586,357,659,545,350,371,3394,3075,196,197,348,6907,674,281,376,85) [ RunTime:0.002636s ]
- [ 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' => 121,
'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 (13947,31501,20236,24581,51330,56561,23091,25793,21749,20019,31080,25111,10812,10816,21465,47378,12065,11837,69554,22810,76815,76816,28459,11478,21200,13574,12719,25844,20655,12292,20525,20210,11714,12334,76821,78601,58224,26892,22076,31173,21370,16810,12136,18321,15476,15552,18483,14011,14749,17096,75071,49696,75082,35542,12881,17314,71661,76453,15690,11687,32523,21003,13495,15258,20320,17358,13238,19579,17047,11258,11266,11289,11269,13832,11677,13366,11087,10584,17463,15069,31229,14440,31345,31232,14211,30426,32978,16505,23869,25736,16437,69638,41752,62929,10635,13464,15917,12066,11291,20595,11272,13728,33065,10310,13071,21361,11145,11210,30429,31231,31346,71805,66720,72604,12161,11085,37528,48868,10894,28004,49959,22061,23731,32948,12318,14665,21881,20653,10262,14894,14386,10582,12258,10586,13739,11267,16632,10581,11569,11570,32944,61765,47140,13500,27088,17123,72574,17768,61463,51615,54111,55670,22425,18913,53018,42380,15186,14630,20087,19001,25208,11719,10343,12155,10580,10514,15770,17382,23351,17646,23823,29339,11813,12870,12972,13862,84696,11814,20020,23561,25962,53882,17352,21292,24217,30188,24686,24215,69940,74990,11157,15732,13116,25591,11196,12705,17419,16516,19915,29128,11019,13899,10480,20018,13612,15919,10510,23383,16890,14267,15916,11707,10583,14298,10587,14529,11213,13638,14085,12156,10515,11209,13639,11836,11144,10578,19057,11407,12629,10306,11080,12259,45774,75095,35801,33260,83423,51871,13989,13737,12157,11211,17418,11766,10311,10513,11147,18307,25814,68431,15814,20795,20077,82870,13475,16011,11765,13738,11367,36482,39622,10959,48465,23913,26350,12691,31217,20994,11812,11312,10676,10396,10512,13547,13922,16464,52494,55365,13022,38179,21081,11146,10730,57781,14174,11288,12427,32534,10498,24781,12159,13900,27301,14553,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,13462,13460,48420,15896,24882,35580,22047,41403,20188,32581,17643,12122,10482,10406,10309,12366,11083,20389,19320,11141,10481,25749,15918,23092,11138,11764,12247,21957,22809,18140,12246,21170,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,10634,13678,13611,14400,26242,37632,83569,77644,13449,10477,11016,11708,50141,77668,30209,22056,54684,60575,72909,77650,33369,18145,61283,32115,14725,26310,30180,33835,33675,72151,38355,77464,10062,10071,26048,18136,18702,21389,72651,33880,19338,37410,77688,37059,25731,23718,48090,19135,32764,13038,18116,23717,53389,23568,77853,23873,19132,10760,31801,19133,85694,85695,23061,23716,10344,49794,53067,36350,38336,44306,34649,27685,38401,29541,44248,59318,62802,23935,59845,24041,58947,48737,25240,34656,38385,38384,72983,44165,27058,38388,62195,54817,37678,22491,37686,85727,59647,15523,17715,13477,17944,15925,29289,15720,16058,14197,12451,21191,38215,77646,79326,19699,12538,45699,79329,76744,60623,21404,24380,14041,14128,22048,19598,19443,14593,24927,16094,18314,24925,17784,15604,18750,20344,22655,13143,17110,24979,13140,19066,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,13478,15381,37163,31012,10660,13369,20015,10872,14052,17664,50029,16746,13274,10922,13269,11839,36126,15567,13372,17945,13271,17356,12712,21759,55882,13588,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,74597,52860,29592,19742,23902,23901,18403,52427,32179,17987,53132,26665,49039,41102,23225,20416,17452,38512,15419,17033,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,20634,26890,37357,21523,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) [ RunTime:0.018143s ]
- [ 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' => 993,
'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 (13947,31501,20236,24581,51330,56561,23091,25793,21749,20019,31080,25111,10812,10816,21465,47378,12065,11837,69554,22810,76815,76816,28459,11478,21200,13574,12719,25844,20655,12292,20525,20210,11714,12334,76821,78601,58224,26892,22076,31173,21370,16810,12136,18321,15476,15552,18483,14011,14749,17096,75071,49696,75082,35542,12881,17314,71661,76453,15690,11687,32523,21003,13495,15258,20320,17358,13238,19579,17047,11258,11266,11289,11269,13832,11677,13366,11087,10584,17463,15069,31229,14440,31345,31232,14211,30426,32978,16505,23869,25736,16437,69638,41752,62929,10635,13464,15917,12066,11291,20595,11272,13728,33065,10310,13071,21361,11145,11210,30429,31231,31346,71805,66720,72604,12161,11085,37528,48868,10894,28004,49959,22061,23731,32948,12318,14665,21881,20653,10262,14894,14386,10582,12258,10586,13739,11267,16632,10581,11569,11570,32944,61765,47140,13500,27088,17123,72574,17768,61463,51615,54111,55670,22425,18913,53018,42380,15186,14630,20087,19001,25208,11719,10343,12155,10580,10514,15770,17382,23351,17646,23823,29339,11813,12870,12972,13862,84696,11814,20020,23561,25962,53882,17352,21292,24217,30188,24686,24215,69940,74990,11157,15732,13116,25591,11196,12705,17419,16516,19915,29128,11019,13899,10480,20018,13612,15919,10510,23383,16890,14267,15916,11707,10583,14298,10587,14529,11213,13638,14085,12156,10515,11209,13639,11836,11144,10578,19057,11407,12629,10306,11080,12259,45774,75095,35801,33260,83423,51871,13989,13737,12157,11211,17418,11766,10311,10513,11147,18307,25814,68431,15814,20795,20077,82870,13475,16011,11765,13738,11367,36482,39622,10959,48465,23913,26350,12691,31217,20994,11812,11312,10676,10396,10512,13547,13922,16464,52494,55365,13022,38179,21081,11146,10730,57781,14174,11288,12427,32534,10498,24781,12159,13900,27301,14553,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,13462,13460,48420,15896,24882,35580,22047,41403,20188,32581,17643,12122,10482,10406,10309,12366,11083,20389,19320,11141,10481,25749,15918,23092,11138,11764,12247,21957,22809,18140,12246,21170,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,10634,13678,13611,14400,26242,37632,83569,77644,13449,10477,11016,11708,50141,77668,30209,22056,54684,60575,72909,77650,33369,18145,61283,32115,14725,26310,30180,33835,33675,72151,38355,77464,10062,10071,26048,18136,18702,21389,72651,33880,19338,37410,77688,37059,25731,23718,48090,19135,32764,13038,18116,23717,53389,23568,77853,23873,19132,10760,31801,19133,85694,85695,23061,23716,10344,49794,53067,36350,38336,44306,34649,27685,38401,29541,44248,59318,62802,23935,59845,24041,58947,48737,25240,34656,38385,38384,72983,44165,27058,38388,62195,54817,37678,22491,37686,85727,59647,15523,17715,13477,17944,15925,29289,15720,16058,14197,12451,21191,38215,77646,79326,19699,12538,45699,79329,76744,60623,21404,24380,14041,14128,22048,19598,19443,14593,24927,16094,18314,24925,17784,15604,18750,20344,22655,13143,17110,24979,13140,19066,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,13478,15381,37163,31012,10660,13369,20015,10872,14052,17664,50029,16746,13274,10922,13269,11839,36126,15567,13372,17945,13271,17356,12712,21759,55882,13588,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,74597,52860,29592,19742,23902,23901,18403,52427,32179,17987,53132,26665,49039,41102,23225,20416,17452,38512,15419,17033,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,20634,26890,37357,21523,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) [ RunTime:0.012742s ]
- [ 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' => 993,
'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.003128s ]
- [ 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 '%www.wxpanguan.com%' LIMIT 1 [ RunTime:0.001813s ]
- [ 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' => 138,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 397 [ RunTime:0.001846s ]
- [ 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' => 840,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.001938s ]
- [ 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` < 1725931437 ) ORDER BY `post_hits` DESC LIMIT 0,4 [ RunTime:0.002589s ]
- [ 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.09244030714035034,
'extra' => 'Using index condition; Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.002038s ]
- [ 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' => 840,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_user` [ RunTime:0.001883s ]
- [ SQL ] SELECT `id`,`user_nickname` FROM `cmf_user` [ RunTime:0.001738s ]
- [ 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.001631s ]
- [ 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.001853s ]
- [ SQL ] SELECT `tag_id` FROM `cmf_portal_tag_post` WHERE `post_id` = 89727 [ RunTime:0.001758s ]
- [ 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.001957s ]
- [ 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.001888s ]
- [ 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.001777s ]
- [ 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.001723s ]
- [ 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.001969s ]
- [ 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.001800s ]
- [ 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.001855s ]
- [ 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.001801s ]
- [ 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.002445s ]
- [ 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.001742s ]
- [ 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.001747s ]
- [ 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.001799s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.wxpanguan.com%' LIMIT 1 [ RunTime:0.001797s ]
- [ 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' => 138,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 397 [ RunTime:0.001952s ]
- [ 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' => 840,
'filtered' => 10.0,
'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` < 1725931437 ) ORDER BY `post_hits` DESC LIMIT 0,8 [ RunTime:0.002621s ]
- [ 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.09244030714035034,
'extra' => 'Using index condition; Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.002047s ]
- [ 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' => 840,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`user_nickname` FROM `cmf_user` [ RunTime:0.001632s ]
- [ 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.001663s ]
- [ 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.001766s ]
- [ 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.001764s ]
- [ 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.001739s ]
- [ 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.001683s ]
- [ 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.001700s ]
- [ 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.001744s ]
- [ 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.001770s ]
- [ 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.001759s ]
- [ 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.001714s ]
- [ 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.001776s ]
- [ 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.001758s ]
- [ 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.001812s ]
- [ 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.002013s ]
- [ 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.002115s ]
- [ 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.001702s ]
- [ 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.001934s ]
- [ 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.001789s ]
- [ 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.001716s ]
- [ 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.001797s ]
- [ 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.001712s ]
- [ 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.001707s ]
- [ 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.001710s ]
- [ 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.001694s ]
- [ 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.001746s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.wxpanguan.com%' LIMIT 1 [ RunTime:0.001772s ]
- [ 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' => 138,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 399 [ RunTime:0.001865s ]
- [ 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' => 840,
'filtered' => 10.0,
'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` < 1725931437 ) ORDER BY `published_time` DESC LIMIT 1,11 [ RunTime:0.002103s ]
- [ 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.002039s ]
- [ 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' => 840,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`user_nickname` FROM `cmf_user` [ RunTime:0.001731s ]
- [ 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.001661s ]
- [ 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.002371s ]
- [ 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.001845s ]
- [ 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.001813s ]
- [ 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.001886s ]
- [ 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.001841s ]
- [ 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.001797s ]
- [ 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.002198s ]
- [ 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.005145s ]
- [ 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.005383s ]
- [ 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.002311s ]
- [ 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.001828s ]
- [ 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.001700s ]
- [ 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.001729s ]
- [ 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.001902s ]
- [ 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.001744s ]
- [ 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.002156s ]
- [ 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.001790s ]
- [ 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.001856s ]
- [ 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.001732s ]
- [ 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.001908s ]
- [ 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.001731s ]
- [ 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.002634s ]
- [ 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.001814s ]
- [ 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.001700s ]
- [ 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.002195s ]
- [ 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.001884s ]
- [ 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.001713s ]
- [ 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.002136s ]
- [ 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.001923s ]
- [ 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.001969s ]
- [ 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.002194s ]
- [ 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.001927s ]
- [ 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.001716s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.wxpanguan.com%' LIMIT 1 [ RunTime:0.001864s ]
- [ 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' => 138,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 399 [ RunTime:0.002324s ]
- [ 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' => 840,
'filtered' => 10.0,
'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` < 1725931438 ) ORDER BY `published_time` DESC LIMIT 0,1 [ RunTime:0.002165s ]
- [ 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.002122s ]
- [ 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' => 840,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`user_nickname` FROM `cmf_user` [ RunTime:0.001713s ]
- [ 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.001682s ]
- [ 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.002241s ]
- [ 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.001804s ]
- [ 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.001709s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.wxpanguan.com%' LIMIT 1 [ RunTime:0.001809s ]
- [ 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' => 138,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 398 [ RunTime:0.001829s ]
- [ 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' => 840,
'filtered' => 10.0,
'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` < 1725931438 ) ORDER BY `published_time` DESC LIMIT 1,11 [ RunTime:0.002670s ]
- [ 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.09244031459093094,
'extra' => 'Using index condition; Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.002114s ]
- [ 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' => 840,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`user_nickname` FROM `cmf_user` [ RunTime:0.001679s ]
- [ 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.001719s ]
- [ 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.002220s ]
- [ 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.001675s ]
- [ 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.001687s ]
- [ 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.001665s ]
- [ 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.001693s ]
- [ 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.001668s ]
- [ 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.001836s ]
- [ 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.001949s ]
- [ 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.001911s ]
- [ 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.002079s ]
- [ 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.001971s ]
- [ 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.001707s ]
- [ 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.001948s ]
- [ 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.002224s ]
- [ 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.001835s ]
- [ 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.001727s ]
- [ 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.001880s ]
- [ 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.001762s ]
- [ 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.001807s ]
- [ 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.001734s ]
- [ 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.001853s ]
- [ 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.001734s ]
- [ 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.001872s ]
- [ 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.001822s ]
- [ 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.001801s ]
- [ 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.001726s ]
- [ 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.025172s ]
- [ 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.001883s ]
- [ 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.002042s ]
- [ 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.001967s ]
- [ 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.001968s ]
- [ 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.001914s ]
- [ 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.001925s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.wxpanguan.com%' LIMIT 1 [ RunTime:0.001879s ]
- [ 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' => 138,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 398 [ RunTime:0.002105s ]
- [ 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' => 840,
'filtered' => 10.0,
'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` < 1725931438 ) ORDER BY `published_time` DESC LIMIT 0,1 [ RunTime:0.002679s ]
- [ 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.09244031459093094,
'extra' => 'Using index condition; Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.002016s ]
- [ 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' => 840,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`user_nickname` FROM `cmf_user` [ RunTime:0.001870s ]
- [ 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.001732s ]
- [ 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.001755s ]
- [ 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.002001s ]
- [ 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.001776s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.wxpanguan.com%' LIMIT 1 [ RunTime:0.001758s ]
- [ 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' => 138,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 400 [ RunTime:0.001954s ]
- [ 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' => 840,
'filtered' => 10.0,
'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` < 1725931438 ) ORDER BY `published_time` DESC LIMIT 0,1 [ RunTime:0.002074s ]
- [ 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' => 'idx_siteid_deletetime_posttype_poststatus_publishedtime',
'key_len' => '11',
'ref' => 'const,const,const,const',
'rows' => 4180,
'filtered' => 3.3326666355133057,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.002019s ]
- [ 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' => 840,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`user_nickname` FROM `cmf_user` [ RunTime:0.016952s ]
- [ 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.001747s ]
- [ 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` = 771452 [ RunTime:0.001805s ]
- [ 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 (15662,16757,18672,17934,15844,16121) [ RunTime:0.001836s ]
- [ 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` = 400 LIMIT 1 [ RunTime:0.001716s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.wxpanguan.com%' LIMIT 1 [ RunTime:0.001766s ]
- [ 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' => 138,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `parent_id` = 400 [ RunTime:0.001804s ]
- [ 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' => 840,
'filtered' => 10.0,
'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` < 1725931438 ) ORDER BY `published_time` DESC LIMIT 0,10 [ RunTime:0.002284s ]
- [ 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' => 'idx_siteid_deletetime_posttype_poststatus_publishedtime',
'key_len' => '11',
'ref' => 'const,const,const,const',
'rows' => 4180,
'filtered' => 3.3326666355133057,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` [ RunTime:0.002186s ]
- [ 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' => 840,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`user_nickname` FROM `cmf_user` [ RunTime:0.001697s ]
- [ 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.001659s ]
- [ 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` = 771452 [ RunTime:0.001709s ]
- [ 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 (15662,16757,18672,17934,15844,16121) [ RunTime:0.001662s ]
- [ 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` = 400 LIMIT 1 [ RunTime:0.001720s ]
- [ 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` = 771313 [ RunTime:0.001804s ]
- [ 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.002100s ]
- [ 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.002135s ]
- [ 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` = 771174 [ RunTime:0.001736s ]
- [ 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.001753s ]
- [ 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.001692s ]
- [ 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` = 771035 [ RunTime:0.001740s ]
- [ 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.001694s ]
- [ 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.001792s ]
- [ 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` = 770896 [ RunTime:0.001702s ]
- [ 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 (36690,15662,15844) [ RunTime:0.001667s ]
- [ 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.001669s ]
- [ 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` = 770757 [ RunTime:0.001769s ]
- [ 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 (28918,28538,15662,15844) [ RunTime:0.001738s ]
- [ 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.001735s ]
- [ 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` = 770618 [ RunTime:0.001732s ]
- [ 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.001812s ]
- [ 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.001758s ]
- [ 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` = 770479 [ RunTime:0.001712s ]
- [ 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 (15662,16757,16758,25056,15844,16121) [ RunTime:0.001724s ]
- [ 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` = 400 LIMIT 1 [ RunTime:0.002139s ]
- [ 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` = 770340 [ RunTime:0.002020s ]
- [ 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 (15661,15662,23934) [ RunTime:0.001717s ]
- [ 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.001715s ]
- [ 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` = 770201 [ RunTime:0.001742s ]
- [ 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.001962s ]
- [ 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.001684s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id` FROM `cmf_plugin_web` WHERE `web_url` LIKE '%www.wxpanguan.com%' LIMIT 1 [ RunTime:0.001775s ]
- [ 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' => 138,
'filtered' => 11.110000610351562,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_link` [ RunTime:0.001839s ]
- [ SQL ] SELECT * FROM `cmf_link` WHERE `status` = 1 AND `site_id` = 62 ORDER BY `list_order` ASC [ RunTime:0.001861s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_link',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => 'status',
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 7,
'filtered' => 14.285713195800781,
'extra' => 'Using where; Using filesort',
) ]
1.390155s
赛事
时间
状态
对阵
直播源
