基本
文件
流程
错误
SQL
调试
- 请求信息 : 2024-11-01 09:05:33 HTTP/1.1 GET : www.sdmach.com/cs/zl/7792.html
- 运行时间 : 1.176525s [ 吞吐率:0.85req/s ] 内存消耗:6,714.43kb 文件加载: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.002646s ]
- [ BEHAVIOR ] Run cmf\behavior\ReadHtmlCacheBehavior @app_init [ RunTime:0.000354s ]
- [ 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)',
'cookie' => 'CLIENTID=79b22175-b904-4491-99f0-d85b0a554174; fikker-wMW4-9jON=gJAjALadsjih547R14QlSN9xQBOVq4Cr; fikker-61vm-nk2N=MgPGRI6oXLV7DSLWJk4y6wNi63F1ZE0E; HSESSIONID=8f9ae367-8807-42cd-8bed-d5096ff439d6',
'accept-encoding' => 'gzip, br, zstd, deflate',
'host' => 'www.sdmach.com',
'content-type' => '',
'content-length' => '',
)
- [ PARAM ] array (
'id' => '7792',
'cid' => '16',
)
- [ 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.001043s ]
- [ DB ] INIT mysql
- [ BEHAVIOR ] Run plugins\error\ErrorPlugin @app_begin [ RunTime:0.060925s ]
- [ LANG ] /www/wwwroot/www.sdmach.com/public/../app/portal/lang/zh-cn.php
- [ BEHAVIOR ] Run cmf\behavior\InitAppHookBehavior @module_init [ RunTime:0.000336s ]
- [ LANG ] /www/wwwroot/www.sdmach.com/public/../app/portal/lang/zh-cn/home.php
- [ BEHAVIOR ] Run cmf\behavior\HomeLangBehavior @home_init [ RunTime:0.000448s ]
- [ 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.000292s ]
- [ DB ] CONNECT:[ UseTime:0.049821s ] mysql:host=47.108.154.156;port=3306;dbname=tp5_www_sdmach_com;charset=utf8
- [ SQL ] SHOW COLUMNS FROM `cmf_plugin` [ RunTime:0.001437s ]
- [ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Error' LIMIT 1 [ RunTime:0.000683s ]
- [ 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.001393s ]
- [ 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` = '16' AND `relation`.`post_id` = '7792' AND ( `post`.`published_time` < '1730423133' and `post`.`published_time` > '0' ) LIMIT 1 [ RunTime:0.002470s ]
- [ 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` = '16' AND `relation`.`post_id` < '7792' AND ( `post`.`published_time` < '1730423133' and `post`.`published_time` > '0' ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.014548s ]
- [ 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' => 734,
'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` = '16' AND `relation`.`post_id` > '7792' AND ( `post`.`published_time` < '1730423133' and `post`.`published_time` > '0' ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.003469s ]
- [ 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' => 734,
'filtered' => 33.329998016357422,
'extra' => 'Using index condition; Using where; Using temporary; Using filesort',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.001292s ]
- [ SQL ] SELECT * FROM `cmf_portal_category` WHERE `id` = 16 AND `status` = 1 LIMIT 1 [ RunTime:0.000730s ]
- [ 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` = 7792 [ RunTime:0.003017s ]
- [ SQL ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.002935s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'tpl' [ RunTime:0.001388s ]
- [ 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.001148s ]
- [ 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.002554s ]
- [ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = 'tpl' AND ( `is_public` = 1 OR `file` = 'portal/article_article.htm' ) [ RunTime:0.001195s ]
- [ 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` = 16 LIMIT 1 [ RunTime:0.000650s ]
- [ 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,12,16) ORDER BY `path` ASC [ RunTime:0.000798s ]
- [ 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' => 3,
'filtered' => 100,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_option` [ RunTime:0.002046s ]
- [ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'storage' LIMIT 1 [ RunTime:0.000702s ]
- [ 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` < 1730423133 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 5 [ RunTime:0.399228s ]
- [ 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` < 1730423134 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 4 [ RunTime:0.020297s ]
- [ 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` < 1730423134 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 7 [ RunTime:0.348326s ]
- [ 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` < 1730423134 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 7,7 [ RunTime:0.244287s ]
- [ 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',
) ]
1.181368s