基本
文件
流程
错误
SQL
调试
- 请求信息 : 2025-06-20 12:14:43 HTTP/1.1 GET : 47.109.140.190/
- 运行时间 : 1.041603s [ 吞吐率：0.96req/s ] 内存消耗：9,213.06kb 文件加载：230
- 查询信息 : 39 queries 1 writes
- 缓存信息 : 0 reads,0 writes
- 配置加载 : 74
- [ CACHE ] INIT File
- [ BEHAVIOR ] Run cmf\behavior\InitHookBehavior @app_init [ RunTime:0.002557s ]
- [ BEHAVIOR ] Run cmf\behavior\ReadHtmlCacheBehavior @app_init [ RunTime:0.000328s ]
- [ LANG ] /www/wwwroot/www.sdmach.com/simplewind/thinkphp/lang/zh-cn.php
- [ ROUTE ] array (
'type' => 'module',
'module' =>
array (
0 => '',
1 => NULL,
2 => NULL,
),
)
- [ HEADER ] array (
'accept' => '*/*',
'user-agent' => 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)',
'accept-encoding' => 'gzip, br, zstd, deflate',
'host' => '47.109.140.190',
'via' => '1.1 squid-proxy-5b5d847c96-csctg (squid/6.10)',
'x-forwarded-for' => '10.3.242.211',
'cache-control' => 'max-age=259200',
'connection' => 'keep-alive',
'content-type' => '',
'content-length' => '',
)
- [ PARAM ] array (
)
- [ LANG ] /www/wwwroot/www.sdmach.com/simplewind/cmf/behavior/../lang/zh-cn.php
- [ LANG ] /www/wwwroot/www.sdmach.com/public/../app/admin/lang/zh-cn/common.php
- [ LANG ] /www/wwwroot/www.sdmach.com/public/../app/portal/lang/zh-cn/common.php
- [ BEHAVIOR ] Run cmf\behavior\LangBehavior @app_begin [ RunTime:0.001044s ]
- [ DB ] INIT mysql
- [ BEHAVIOR ] Run plugins\error\ErrorPlugin @app_begin [ RunTime:0.024199s ]
- [ LANG ] /www/wwwroot/www.sdmach.com/public/../app/portal/lang/zh-cn.php
- [ BEHAVIOR ] Run cmf\behavior\InitAppHookBehavior @module_init [ RunTime:0.000312s ]
- [ LANG ] /www/wwwroot/www.sdmach.com/public/../app/portal/lang/zh-cn/home.php
- [ BEHAVIOR ] Run cmf\behavior\HomeLangBehavior @home_init [ RunTime:0.000440s ]
- [ RUN ] app\portal\controller\IndexController->index[ /www/wwwroot/www.sdmach.com/app/portal/controller/IndexController.php ]
- [ VIEW ] /www/wwwroot/www.sdmach.com/public/themes/tpl/portal/index.htm [ array (
0 => 'site_info',
1 => 'theme_vars',
2 => 'theme_widgets',
) ]
- [ VIEW ] /www/wwwroot/www.sdmach.com/public/plugins/comment/view/widget.html [ array (
0 => 'site_info',
1 => 'anonymous',
2 => 'verify',
3 => 'captcha',
4 => 'time',
5 => 'datas',
6 => 'page',
7 => 'total',
8 => 'currentpage',
9 => 'object_id',
10 => 'table_name',
11 => 'object_title',
12 => 'url',
13 => 'user_id',
) ]
- [ BEHAVIOR ] Run cmf\behavior\WriteHtmlCacheBehavior @view_filter [ RunTime:0.000229s ]
- [ BEHAVIOR ] Run plugins\comment\CommentPlugin @comment [ RunTime:0.000244s ]
- [ BEHAVIOR ] Run cmf\behavior\WriteHtmlCacheBehavior @view_filter [ RunTime:0.000016s ]
- [ DB ] CONNECT:[ UseTime:0.005290s ] mysql:host=47.108.154.156;port=3306;dbname=tp5_www_sdmach_com;charset=utf8
- [ SQL ] SHOW COLUMNS FROM `cmf_plugin` [ RunTime:0.004110s ]
- [ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Error' LIMIT 1 [ RunTime:0.003385s ]
- [ 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' => 3,
'filtered' => 33.333335876464844,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.003933s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'tpl' [ RunTime:0.003379s ]
- [ 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' => 8,
'filtered' => 12.5,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_theme` [ RunTime:0.003799s ]
- [ SQL ] UPDATE `cmf_theme` SET `name`='tpl',`version`='1.0.2',`demo_url`='http://www.85253000.com',`author`='xbbdf',`lang`='zh-cn',`author_url`='http://www.85253000.com',`keywords`='网站模板',`description`='网站模板' WHERE `theme` = 'tpl' [ RunTime:0.007429s ]
- [ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = 'tpl' AND ( `is_public` = 1 OR `file` = 'portal/index.htm' ) [ RunTime:0.003396s ]
- [ 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' => 8,
'filtered' => 12.5,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.004008s ]
- [ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1750392883 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 10 [ RunTime:0.128415s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'category_post',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 7775,
'filtered' => 100,
'extra' => 'Using temporary; Using filesort',
) ]
- [ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '5' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1750392883 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 6 [ RunTime:0.017772s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'category_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'term_taxonomy_id',
'key' => 'term_taxonomy_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 737,
'filtered' => 100,
'extra' => 'Using index condition; Using temporary; Using filesort',
) ]
- [ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '9' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1750392883 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 6 [ RunTime:0.020107s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'category_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'term_taxonomy_id',
'key' => 'term_taxonomy_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 703,
'filtered' => 100,
'extra' => 'Using index condition; Using temporary; Using filesort',
) ]
- [ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '1' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1750392883 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 1 [ RunTime:0.017101s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'category_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'term_taxonomy_id',
'key' => 'term_taxonomy_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 570,
'filtered' => 100,
'extra' => 'Using index condition; Using temporary; Using filesort',
) ]
- [ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1750392883 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 2 [ RunTime:0.122661s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'category_post',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 7775,
'filtered' => 100,
'extra' => 'Using temporary; Using filesort',
) ]
- [ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '11' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1750392884 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 1 [ RunTime:0.015827s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'category_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'term_taxonomy_id',
'key' => 'term_taxonomy_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 714,
'filtered' => 100,
'extra' => 'Using index condition; Using temporary; Using filesort',
) ]
- [ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '12' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1750392884 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 1 [ RunTime:0.011507s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'category_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'term_taxonomy_id',
'key' => 'term_taxonomy_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 443,
'filtered' => 100,
'extra' => 'Using index condition; Using temporary; Using filesort',
) ]
- [ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '13' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1750392884 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 1 [ RunTime:0.015317s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'category_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'term_taxonomy_id',
'key' => 'term_taxonomy_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 723,
'filtered' => 100,
'extra' => 'Using index condition; Using temporary; Using filesort',
) ]
- [ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '16' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1750392884 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 1 [ RunTime:0.015356s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'category_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'term_taxonomy_id',
'key' => 'term_taxonomy_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 734,
'filtered' => 100,
'extra' => 'Using index condition; Using temporary; Using filesort',
) ]
- [ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '7' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1750392884 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 9 [ RunTime:0.016743s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'category_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'term_taxonomy_id',
'key' => 'term_taxonomy_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 781,
'filtered' => 100,
'extra' => 'Using index condition; Using temporary; Using filesort',
) ]
- [ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '6' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1750392884 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 1,9 [ RunTime:0.012498s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'category_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'term_taxonomy_id',
'key' => 'term_taxonomy_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 501,
'filtered' => 100,
'extra' => 'Using index condition; Using temporary; Using filesort',
) ]
- [ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '8' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1750392884 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 9 [ RunTime:0.010810s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'category_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'term_taxonomy_id',
'key' => 'term_taxonomy_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 423,
'filtered' => 100,
'extra' => 'Using index condition; Using temporary; Using filesort',
) ]
- [ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '10' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1750392884 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 9 [ RunTime:0.011251s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'category_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'term_taxonomy_id',
'key' => 'term_taxonomy_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 449,
'filtered' => 100,
'extra' => 'Using index condition; Using temporary; Using filesort',
) ]
- [ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '13' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1750392884 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 1,9 [ RunTime:0.015622s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'category_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'term_taxonomy_id',
'key' => 'term_taxonomy_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 723,
'filtered' => 100,
'extra' => 'Using index condition; Using temporary; Using filesort',
) ]
- [ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '16' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1750392884 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 1,9 [ RunTime:0.015443s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'category_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'term_taxonomy_id',
'key' => 'term_taxonomy_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 734,
'filtered' => 100,
'extra' => 'Using index condition; Using temporary; Using filesort',
) ]
- [ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '14' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1750392884 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 9 [ RunTime:0.013585s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'category_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'term_taxonomy_id',
'key' => 'term_taxonomy_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 491,
'filtered' => 100,
'extra' => 'Using index condition; Using temporary; Using filesort',
) ]
- [ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '12' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1750392884 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 9 [ RunTime:0.011989s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'category_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'term_taxonomy_id',
'key' => 'term_taxonomy_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 443,
'filtered' => 100,
'extra' => 'Using index condition; Using temporary; Using filesort',
) ]
- [ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1750392884 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 7 [ RunTime:0.121614s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'category_post',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 7775,
'filtered' => 100,
'extra' => 'Using temporary; Using filesort',
) ]
- [ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '11' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1750392884 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 1,10 [ RunTime:0.015802s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'category_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'term_taxonomy_id',
'key' => 'term_taxonomy_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 714,
'filtered' => 100,
'extra' => 'Using index condition; Using temporary; Using filesort',
) ]
- [ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '4' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1750392884 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 9 [ RunTime:0.005685s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'category_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'term_taxonomy_id',
'key' => 'term_taxonomy_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 94,
'filtered' => 100,
'extra' => 'Using index condition; Using temporary; Using filesort',
) ]
- [ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '12' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1750392884 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 1,10 [ RunTime:0.011328s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'category_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'term_taxonomy_id',
'key' => 'term_taxonomy_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 443,
'filtered' => 100,
'extra' => 'Using index condition; Using temporary; Using filesort',
) ]
- [ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '11' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1750392884 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 11,5 [ RunTime:0.019575s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'category_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'term_taxonomy_id',
'key' => 'term_taxonomy_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 714,
'filtered' => 100,
'extra' => 'Using index condition; Using temporary; Using filesort',
) ]
- [ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '13' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1750392884 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 10,5 [ RunTime:0.015720s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'category_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'term_taxonomy_id',
'key' => 'term_taxonomy_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 723,
'filtered' => 100,
'extra' => 'Using index condition; Using temporary; Using filesort',
) ]
- [ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '12' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1750392884 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 11,5 [ RunTime:0.011001s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'category_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'term_taxonomy_id',
'key' => 'term_taxonomy_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 443,
'filtered' => 100,
'extra' => 'Using index condition; Using temporary; Using filesort',
) ]
- [ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '14' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1750392884 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 9,5 [ RunTime:0.012278s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'category_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'term_taxonomy_id',
'key' => 'term_taxonomy_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 491,
'filtered' => 100,
'extra' => 'Using index condition; Using temporary; Using filesort',
) ]
- [ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Comment' LIMIT 1 [ RunTime:0.003324s ]
- [ 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' => 3,
'filtered' => 33.333335876464844,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_comment` [ RunTime:0.008233s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_comment` WHERE `object_id` = 1 AND `status` = 1 AND `delete_time` = 0 LIMIT 1 [ RunTime:0.036818s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_comment',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'object_id,status',
'key' => 'status',
'key_len' => '1',
'ref' => 'const',
'rows' => 22,
'filtered' => 5,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_comment` WHERE `object_id` = 1 AND `status` = 1 AND `delete_time` = 0 ORDER BY `id` DESC LIMIT 0,5 [ RunTime:0.003430s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_comment',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'object_id,status',
'key' => 'status',
'key_len' => '1',
'ref' => 'const',
'rows' => 22,
'filtered' => 5,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_comment` WHERE `id` IN (0,91) [ RunTime:0.003374s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_comment',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => NULL,
'rows' => 2,
'filtered' => 100,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_option` [ RunTime:0.003945s ]
- [ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'storage' LIMIT 1 [ RunTime:0.003334s ]
- [ 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',
) ]
1.054803s
