基本
文件
流程
错误
SQL
调试
- 请求信息 : 2024-11-01 10:35:04 HTTP/1.1 GET : sdmach.com/index.php/yydt/5427.html
- 运行时间 : 0.716797s [ 吞吐率:1.40req/s ] 内存消耗:6,734.48kb 文件加载:99
- 查询信息 : 20 queries 2 writes
- 缓存信息 : 1 reads,0 writes
- 配置加载 : 74
- /www/wwwroot/www.sdmach.com/public/index.php ( 1.73 KB )
- /www/wwwroot/www.sdmach.com/simplewind/thinkphp/base.php ( 2.60 KB )
- /www/wwwroot/www.sdmach.com/simplewind/thinkphp/library/think/Loader.php ( 21.07 KB )
- /www/wwwroot/www.sdmach.com/simplewind/vendor/composer/autoload_static.php ( 5.33 KB )
- /www/wwwroot/www.sdmach.com/simplewind/vendor/topthink/think-helper/src/helper.php ( 2.88 KB )
- /www/wwwroot/www.sdmach.com/simplewind/vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php ( 0.10 KB )
- /www/wwwroot/www.sdmach.com/simplewind/vendor/topthink/think-captcha/src/helper.php ( 1.59 KB )
- /www/wwwroot/www.sdmach.com/simplewind/thinkphp/library/think/Route.php ( 60.23 KB )
- /www/wwwroot/www.sdmach.com/simplewind/thinkphp/library/think/Config.php ( 6.38 KB )
- /www/wwwroot/www.sdmach.com/simplewind/thinkphp/library/think/Validate.php ( 41.63 KB )
- /www/wwwroot/www.sdmach.com/simplewind/vendor/topthink/think-queue/src/common.php ( 1.19 KB )
- /www/wwwroot/www.sdmach.com/simplewind/thinkphp/library/think/Console.php ( 23.13 KB )
- /www/wwwroot/www.sdmach.com/simplewind/thinkphp/library/think/Error.php ( 3.75 KB )
- /www/wwwroot/www.sdmach.com/simplewind/thinkphp/convention.php ( 10.37 KB )
- /www/wwwroot/www.sdmach.com/simplewind/thinkphp/library/think/App.php ( 21.54 KB )
- /www/wwwroot/www.sdmach.com/simplewind/thinkphp/library/think/Request.php ( 49.78 KB )
- /www/wwwroot/www.sdmach.com/app/config.php ( 10.94 KB )
- /www/wwwroot/www.sdmach.com/data/conf/config.php ( 0.14 KB )
- /www/wwwroot/www.sdmach.com/app/database.php ( 0.73 KB )
- /www/wwwroot/www.sdmach.com/data/conf/database.php ( 0.52 KB )
- /www/wwwroot/www.sdmach.com/app/debug.php ( 0.69 KB )
- /www/wwwroot/www.sdmach.com/simplewind/thinkphp/library/think/Hook.php ( 4.71 KB )
- /www/wwwroot/www.sdmach.com/app/tags.php ( 1.44 KB )
- /www/wwwroot/www.sdmach.com/app/common.php ( 8.15 KB )
- /www/wwwroot/www.sdmach.com/simplewind/thinkphp/library/think/Env.php ( 1.21 KB )
- /www/wwwroot/www.sdmach.com/simplewind/cmf/common.php ( 60.90 KB )
- /www/wwwroot/www.sdmach.com/simplewind/thinkphp/helper.php ( 17.30 KB )
- /www/wwwroot/www.sdmach.com/simplewind/thinkphp/library/think/Debug.php ( 7.13 KB )
- /www/wwwroot/www.sdmach.com/simplewind/cmf/behavior/InitHookBehavior.php ( 2.58 KB )
- /www/wwwroot/www.sdmach.com/simplewind/extend/think/facade/Route.php ( 0.74 KB )
- /www/wwwroot/www.sdmach.com/simplewind/thinkphp/library/think/Cache.php ( 6.10 KB )
- /www/wwwroot/www.sdmach.com/simplewind/thinkphp/library/think/Log.php ( 6.05 KB )
- /www/wwwroot/www.sdmach.com/simplewind/thinkphp/library/think/cache/driver/File.php ( 7.27 KB )
- /www/wwwroot/www.sdmach.com/simplewind/thinkphp/library/think/cache/Driver.php ( 5.98 KB )
- /www/wwwroot/www.sdmach.com/simplewind/thinkphp/library/think/Collection.php ( 10.91 KB )
- /www/wwwroot/www.sdmach.com/simplewind/extend/think/facade/Hook.php ( 1.46 KB )
- /www/wwwroot/www.sdmach.com/simplewind/cmf/behavior/ReadHtmlCacheBehavior.php ( 6.94 KB )
- /www/wwwroot/www.sdmach.com/simplewind/thinkphp/library/think/Lang.php ( 7.23 KB )
- /www/wwwroot/www.sdmach.com/simplewind/thinkphp/lang/zh-cn.php ( 11.81 KB )
- /www/wwwroot/www.sdmach.com/app/route.php ( 0.75 KB )
- /www/wwwroot/www.sdmach.com/data/conf/route.php ( 5.05 KB )
- /www/wwwroot/www.sdmach.com/simplewind/cmf/behavior/LangBehavior.php ( 1.20 KB )
- /www/wwwroot/www.sdmach.com/simplewind/extend/think/facade/Lang.php ( 0.73 KB )
- /www/wwwroot/www.sdmach.com/simplewind/cmf/lang/zh-cn.php ( 3.08 KB )
- /www/wwwroot/www.sdmach.com/app/admin/lang/zh-cn/common.php ( 0.60 KB )
- /www/wwwroot/www.sdmach.com/app/portal/lang/zh-cn/common.php ( 0.76 KB )
- /www/wwwroot/www.sdmach.com/public/plugins/error/ErrorPlugin.php ( 1.89 KB )
- /www/wwwroot/www.sdmach.com/simplewind/cmf/lib/Plugin.php ( 7.84 KB )
- /www/wwwroot/www.sdmach.com/simplewind/extend/think/facade/Config.php ( 0.94 KB )
- /www/wwwroot/www.sdmach.com/simplewind/thinkphp/library/think/Db.php ( 6.67 KB )
- /www/wwwroot/www.sdmach.com/simplewind/thinkphp/library/think/db/connector/Mysql.php ( 3.89 KB )
- /www/wwwroot/www.sdmach.com/simplewind/thinkphp/library/think/db/Connection.php ( 29.97 KB )
- /www/wwwroot/www.sdmach.com/simplewind/thinkphp/library/think/db/Query.php ( 93.74 KB )
- /www/wwwroot/www.sdmach.com/simplewind/thinkphp/library/think/db/builder/Mysql.php ( 4.53 KB )
- /www/wwwroot/www.sdmach.com/simplewind/thinkphp/library/think/db/Builder.php ( 31.55 KB )
- /www/wwwroot/www.sdmach.com/simplewind/thinkphp/library/think/View.php ( 6.77 KB )
- /www/wwwroot/www.sdmach.com/simplewind/thinkphp/library/think/view/driver/Think.php ( 5.64 KB )
- /www/wwwroot/www.sdmach.com/simplewind/thinkphp/library/think/Template.php ( 44.90 KB )
- /www/wwwroot/www.sdmach.com/simplewind/thinkphp/library/think/template/driver/File.php ( 2.24 KB )
- /www/wwwroot/www.sdmach.com/app/portal/lang/zh-cn.php ( 0.93 KB )
- /www/wwwroot/www.sdmach.com/simplewind/cmf/behavior/InitAppHookBehavior.php ( 2.03 KB )
- /www/wwwroot/www.sdmach.com/app/portal/controller/ArticleController.php ( 3.38 KB )
- /www/wwwroot/www.sdmach.com/simplewind/cmf/controller/HomeBaseController.php ( 10.98 KB )
- /www/wwwroot/www.sdmach.com/simplewind/cmf/controller/BaseController.php ( 2.50 KB )
- /www/wwwroot/www.sdmach.com/simplewind/thinkphp/library/think/Controller.php ( 6.07 KB )
- /www/wwwroot/www.sdmach.com/simplewind/thinkphp/library/traits/controller/Jump.php ( 4.90 KB )
- /www/wwwroot/www.sdmach.com/simplewind/thinkphp/library/think/Cookie.php ( 7.54 KB )
- /www/wwwroot/www.sdmach.com/simplewind/cmf/behavior/HomeLangBehavior.php ( 1.09 KB )
- /www/wwwroot/www.sdmach.com/app/portal/lang/zh-cn/home.php ( 0.62 KB )
- /www/wwwroot/www.sdmach.com/app/portal/model/PortalCategoryModel.php ( 9.05 KB )
- /www/wwwroot/www.sdmach.com/simplewind/thinkphp/library/think/Model.php ( 69.14 KB )
- /www/wwwroot/www.sdmach.com/app/portal/service/PostService.php ( 9.55 KB )
- /www/wwwroot/www.sdmach.com/app/portal/model/PortalPostModel.php ( 11.73 KB )
- /www/wwwroot/www.sdmach.com/app/admin/model/ThemeModel.php ( 8.12 KB )
- /www/wwwroot/www.sdmach.com/app/portal/taglib/Portal.php ( 10.74 KB )
- /www/wwwroot/www.sdmach.com/simplewind/thinkphp/library/think/template/TagLib.php ( 12.30 KB )
- /www/wwwroot/www.sdmach.com/simplewind/cmf/lib/taglib/Cmf.php ( 11.56 KB )
- /www/wwwroot/www.sdmach.com/simplewind/thinkphp/library/think/template/taglib/Cx.php ( 23.82 KB )
- /www/wwwroot/www.sdmach.com/data/runtime/temp/d1a47b122accfbeac108d782da9766da.php ( 13.83 KB )
- /www/wwwroot/www.sdmach.com/app/admin/model/RouteModel.php ( 6.44 KB )
- /www/wwwroot/www.sdmach.com/app/portal/url.php ( 1.55 KB )
- /www/wwwroot/www.sdmach.com/app/user/url.php ( 0.98 KB )
- /www/wwwroot/www.sdmach.com/simplewind/extend/think/facade/Url.php ( 0.73 KB )
- /www/wwwroot/www.sdmach.com/simplewind/thinkphp/library/think/Url.php ( 12.72 KB )
- /www/wwwroot/www.sdmach.com/app/portal/service/ApiService.php ( 16.99 KB )
- /www/wwwroot/www.sdmach.com/simplewind/thinkphp/library/think/model/Collection.php ( 2.27 KB )
- /www/wwwroot/www.sdmach.com/simplewind/vendor/electrolinux/phpquery/phpQuery/phpQuery.php ( 41.76 KB )
- /www/wwwroot/www.sdmach.com/simplewind/vendor/electrolinux/phpquery/phpQuery/phpQuery/DOMEvent.php ( 2.25 KB )
- /www/wwwroot/www.sdmach.com/simplewind/vendor/electrolinux/phpquery/phpQuery/phpQuery/DOMDocumentWrapper.php ( 22.46 KB )
- /www/wwwroot/www.sdmach.com/simplewind/vendor/electrolinux/phpquery/phpQuery/phpQuery/phpQueryEvents.php ( 4.85 KB )
- /www/wwwroot/www.sdmach.com/simplewind/vendor/electrolinux/phpquery/phpQuery/phpQuery/Callback.php ( 4.02 KB )
- /www/wwwroot/www.sdmach.com/simplewind/vendor/electrolinux/phpquery/phpQuery/phpQuery/phpQueryObject.php ( 87.75 KB )
- /www/wwwroot/www.sdmach.com/simplewind/vendor/electrolinux/phpquery/phpQuery/phpQuery/compat/mbstring.php ( 1.51 KB )
- /www/wwwroot/www.sdmach.com/simplewind/cmf/lib/Storage.php ( 3.89 KB )
- /www/wwwroot/www.sdmach.com/simplewind/cmf/lib/storage/Local.php ( 2.86 KB )
- /www/wwwroot/www.sdmach.com/simplewind/thinkphp/library/think/db/Expression.php ( 1.11 KB )
- /www/wwwroot/www.sdmach.com/simplewind/cmf/behavior/WriteHtmlCacheBehavior.php ( 1.67 KB )
- /www/wwwroot/www.sdmach.com/simplewind/thinkphp/library/think/Response.php ( 8.28 KB )
- /www/wwwroot/www.sdmach.com/simplewind/thinkphp/library/think/debug/Html.php ( 4.17 KB )
- [ CACHE ] INIT File
- [ BEHAVIOR ] Run cmf\behavior\InitHookBehavior @app_init [ RunTime:0.002554s ]
- [ BEHAVIOR ] Run cmf\behavior\ReadHtmlCacheBehavior @app_init [ RunTime:0.000336s ]
- [ LANG ] /www/wwwroot/www.sdmach.com/simplewind/thinkphp/lang/zh-cn.php
- [ ROUTE ] array (
'type' => 'module',
'module' =>
array (
0 => 'portal',
1 => 'Article',
2 => 'index',
),
'convert' => false,
)
- [ 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' => 'sdmach.com',
'content-type' => '',
'content-length' => '',
)
- [ PARAM ] array (
'id' => '5427',
'cid' => '1',
)
- [ 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.001095s ]
- [ DB ] INIT mysql
- [ BEHAVIOR ] Run plugins\error\ErrorPlugin @app_begin [ RunTime:0.012044s ]
- [ LANG ] /www/wwwroot/www.sdmach.com/public/../app/portal/lang/zh-cn.php
- [ BEHAVIOR ] Run cmf\behavior\InitAppHookBehavior @module_init [ RunTime:0.000349s ]
- [ LANG ] /www/wwwroot/www.sdmach.com/public/../app/portal/lang/zh-cn/home.php
- [ BEHAVIOR ] Run cmf\behavior\HomeLangBehavior @home_init [ RunTime:0.000430s ]
- [ RUN ] app\portal\controller\ArticleController->index[ /www/wwwroot/www.sdmach.com/app/portal/controller/ArticleController.php ]
- [ VIEW ] /www/wwwroot/www.sdmach.com/public/themes/tpl/portal/article_article.htm [ array (
0 => 'site_info',
1 => 'category',
2 => 'article',
3 => 'prev_article',
4 => 'next_article',
5 => 'theme_vars',
6 => 'theme_widgets',
) ]
- [ BEHAVIOR ] Run cmf\behavior\WriteHtmlCacheBehavior @view_filter [ RunTime:0.000284s ]
- [ DB ] CONNECT:[ UseTime:0.001303s ] mysql:host=47.108.154.156;port=3306;dbname=tp5_www_sdmach_com;charset=utf8
- [ SQL ] SHOW COLUMNS FROM `cmf_plugin` [ RunTime:0.001518s ]
- [ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Error' LIMIT 1 [ RunTime:0.000668s ]
- [ 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_portal_post` [ RunTime:0.001417s ]
- [ SQL ] SELECT `post`.* FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `relation` ON `post`.`id`=`relation`.`post_id` WHERE `post`.`post_type` = 1 AND `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `relation`.`category_id` = '1' AND `relation`.`post_id` = '5427' AND ( `post`.`published_time` < '1730428504' and `post`.`published_time` > '0' ) LIMIT 1 [ RunTime:0.001695s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'post',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY,type_status_date',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100,
'extra' => NULL,
) ]
- [ SQL ] SELECT `post`.* FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `relation` ON `post`.`id`=`relation`.`post_id` WHERE `post`.`post_type` = 1 AND `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `relation`.`category_id` = '1' AND `relation`.`post_id` < '5427' AND ( `post`.`published_time` < '1730428504' and `post`.`published_time` > '0' ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.008959s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'relation',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'term_taxonomy_id',
'key' => 'term_taxonomy_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 570,
'filtered' => 33.329998016357422,
'extra' => 'Using index condition; Using where; Using temporary; Using filesort',
) ]
- [ SQL ] SELECT `post`.* FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `relation` ON `post`.`id`=`relation`.`post_id` WHERE `post`.`post_type` = 1 AND `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `relation`.`category_id` = '1' AND `relation`.`post_id` > '5427' AND ( `post`.`published_time` < '1730428504' and `post`.`published_time` > '0' ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.007181s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'relation',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'term_taxonomy_id',
'key' => 'term_taxonomy_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 570,
'filtered' => 33.329998016357422,
'extra' => 'Using index condition; Using where; Using temporary; Using filesort',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.001494s ]
- [ SQL ] SELECT * FROM `cmf_portal_category` WHERE `id` = 1 AND `status` = 1 LIMIT 1 [ RunTime:0.000677s ]
- [ 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,
'extra' => NULL,
) ]
- [ SQL ] UPDATE `cmf_portal_post` SET `post_hits`=`post_hits`+1 WHERE `id` = 5427 [ RunTime:0.002717s ]
- [ SQL ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.001204s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'tpl' [ RunTime:0.000654s ]
- [ 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.001147s ]
- [ 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.002532s ]
- [ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = 'tpl' AND ( `is_public` = 1 OR `file` = 'portal/article_article.htm' ) [ RunTime:0.000677s ]
- [ 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 ] SELECT `path` FROM `cmf_portal_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000573s ]
- [ 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,
'extra' => NULL,
) ]
- [ SQL ] SELECT * FROM `cmf_portal_category` WHERE `id` IN (0,1) ORDER BY `path` ASC [ RunTime:0.000666s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => NULL,
'rows' => 2,
'filtered' => 100,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_option` [ RunTime:0.001392s ]
- [ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'storage' LIMIT 1 [ RunTime:0.000626s ]
- [ 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 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` < 1730428504 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 5 [ RunTime:0.188887s ]
- [ 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` = '13' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1730428504 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 4 [ RunTime:0.019115s ]
- [ 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 ( `post`.`published_time` > '0' and `post`.`published_time` < 1730428504 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 7 [ RunTime:0.182799s ]
- [ 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 ( `post`.`published_time` > '0' and `post`.`published_time` < 1730428504 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 7,7 [ RunTime:0.217517s ]
- [ 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',
) ]
0.721519s