基本
文件
流程
错误
SQL
调试
- 请求信息 : 2022-12-05 05:49:51 HTTP/1.1 GET : saxg-ss.com/portal/list/index/id/3.html
- 运行时间 : 0.234102s [ 吞吐率：4.27req/s ] 内存消耗：3,529.87kb 文件加载：89
- 查询信息 : 28 queries 10 writes
- 缓存信息 : 0 reads,0 writes
- 配置加载 : 67
- D:\Wwwroot\web\public\index.php ( 1.27 KB )
- D:\Wwwroot\web\simplewind\thinkphp\base.php ( 2.60 KB )
- D:\Wwwroot\web\simplewind\thinkphp\library\think\Loader.php ( 21.07 KB )
- D:\Wwwroot\web\simplewind\vendor\composer\autoload_static.php ( 5.33 KB )
- D:\Wwwroot\web\simplewind\vendor\topthink\think-helper\src\helper.php ( 2.88 KB )
- D:\Wwwroot\web\simplewind\vendor\ezyang\htmlpurifier\library\HTMLPurifier.composer.php ( 0.10 KB )
- D:\Wwwroot\web\simplewind\vendor\topthink\think-captcha\src\helper.php ( 1.59 KB )
- D:\Wwwroot\web\simplewind\thinkphp\library\think\Route.php ( 60.23 KB )
- D:\Wwwroot\web\simplewind\thinkphp\library\think\Config.php ( 6.38 KB )
- D:\Wwwroot\web\simplewind\thinkphp\library\think\Validate.php ( 41.63 KB )
- D:\Wwwroot\web\simplewind\vendor\topthink\think-queue\src\common.php ( 1.19 KB )
- D:\Wwwroot\web\simplewind\thinkphp\library\think\Console.php ( 23.13 KB )
- D:\Wwwroot\web\simplewind\thinkphp\library\think\Error.php ( 3.75 KB )
- D:\Wwwroot\web\simplewind\thinkphp\convention.php ( 10.37 KB )
- D:\Wwwroot\web\simplewind\thinkphp\library\think\App.php ( 21.54 KB )
- D:\Wwwroot\web\simplewind\thinkphp\library\think\Request.php ( 49.78 KB )
- D:\Wwwroot\web\app\config.php ( 9.55 KB )
- D:\Wwwroot\web\data\conf\config.php ( 0.14 KB )
- D:\Wwwroot\web\app\database.php ( 0.75 KB )
- D:\Wwwroot\web\data\conf\database.php ( 0.50 KB )
- D:\Wwwroot\web\app\debug.php ( 0.71 KB )
- D:\Wwwroot\web\simplewind\thinkphp\library\think\Hook.php ( 4.71 KB )
- D:\Wwwroot\web\app\tags.php ( 1.35 KB )
- D:\Wwwroot\web\simplewind\thinkphp\library\think\Env.php ( 1.21 KB )
- D:\Wwwroot\web\simplewind\cmf\common.php ( 58.14 KB )
- D:\Wwwroot\web\simplewind\thinkphp\helper.php ( 17.30 KB )
- D:\Wwwroot\web\simplewind\thinkphp\library\think\Debug.php ( 7.13 KB )
- D:\Wwwroot\web\simplewind\cmf\behavior\InitHookBehavior.php ( 2.60 KB )
- D:\Wwwroot\web\simplewind\extend\think\facade\Route.php ( 0.75 KB )
- D:\Wwwroot\web\simplewind\thinkphp\library\think\Cache.php ( 6.10 KB )
- D:\Wwwroot\web\simplewind\thinkphp\library\think\Log.php ( 6.05 KB )
- D:\Wwwroot\web\simplewind\thinkphp\library\think\cache\driver\File.php ( 7.27 KB )
- D:\Wwwroot\web\simplewind\thinkphp\library\think\cache\Driver.php ( 5.98 KB )
- D:\Wwwroot\web\simplewind\thinkphp\library\think\Collection.php ( 10.91 KB )
- D:\Wwwroot\web\simplewind\thinkphp\library\think\Lang.php ( 7.23 KB )
- D:\Wwwroot\web\simplewind\thinkphp\lang\zh-cn.php ( 11.81 KB )
- D:\Wwwroot\web\app\route.php ( 0.77 KB )
- D:\Wwwroot\web\data\conf\route.php ( 1.33 KB )
- D:\Wwwroot\web\simplewind\cmf\behavior\LangBehavior.php ( 1.21 KB )
- D:\Wwwroot\web\simplewind\extend\think\facade\Lang.php ( 0.75 KB )
- D:\Wwwroot\web\simplewind\cmf\lang\zh-cn.php ( 3.09 KB )
- D:\Wwwroot\web\app\admin\lang\zh-cn\common.php ( 0.61 KB )
- D:\Wwwroot\web\app\portal\lang\zh-cn\common.php ( 0.78 KB )
- D:\Wwwroot\web\app\portal\lang\zh-cn.php ( 0.94 KB )
- D:\Wwwroot\web\simplewind\cmf\behavior\InitAppHookBehavior.php ( 2.04 KB )
- D:\Wwwroot\web\app\portal\controller\ListController.php ( 1.41 KB )
- D:\Wwwroot\web\simplewind\cmf\controller\HomeBaseController.php ( 8.03 KB )
- D:\Wwwroot\web\simplewind\cmf\controller\BaseController.php ( 2.52 KB )
- D:\Wwwroot\web\simplewind\thinkphp\library\think\Controller.php ( 6.07 KB )
- D:\Wwwroot\web\simplewind\thinkphp\library\traits\controller\Jump.php ( 4.90 KB )
- D:\Wwwroot\web\simplewind\thinkphp\library\think\Cookie.php ( 7.54 KB )
- D:\Wwwroot\web\simplewind\thinkphp\library\think\View.php ( 6.77 KB )
- D:\Wwwroot\web\simplewind\thinkphp\library\think\view\driver\Think.php ( 5.64 KB )
- D:\Wwwroot\web\simplewind\thinkphp\library\think\Template.php ( 44.90 KB )
- D:\Wwwroot\web\simplewind\thinkphp\library\think\template\driver\File.php ( 2.24 KB )
- D:\Wwwroot\web\simplewind\extend\think\facade\Hook.php ( 1.47 KB )
- D:\Wwwroot\web\simplewind\cmf\behavior\HomeLangBehavior.php ( 1.11 KB )
- D:\Wwwroot\web\app\portal\lang\zh-cn\home.php ( 0.64 KB )
- D:\Wwwroot\web\app\portal\model\PortalCategoryModel.php ( 8.99 KB )
- D:\Wwwroot\web\simplewind\thinkphp\library\think\Model.php ( 69.14 KB )
- D:\Wwwroot\web\simplewind\thinkphp\library\think\Db.php ( 6.67 KB )
- D:\Wwwroot\web\simplewind\thinkphp\library\think\db\connector\Mysql.php ( 3.89 KB )
- D:\Wwwroot\web\simplewind\thinkphp\library\think\db\Connection.php ( 29.97 KB )
- D:\Wwwroot\web\simplewind\thinkphp\library\think\db\Query.php ( 93.74 KB )
- D:\Wwwroot\web\simplewind\thinkphp\library\think\db\builder\Mysql.php ( 4.53 KB )
- D:\Wwwroot\web\simplewind\thinkphp\library\think\db\Builder.php ( 31.55 KB )
- D:\Wwwroot\web\app\admin\model\ThemeModel.php ( 8.14 KB )
- D:\Wwwroot\web\app\portal\taglib\Portal.php ( 9.42 KB )
- D:\Wwwroot\web\simplewind\thinkphp\library\think\template\TagLib.php ( 12.30 KB )
- D:\Wwwroot\web\simplewind\cmf\lib\taglib\Cmf.php ( 11.64 KB )
- D:\Wwwroot\web\simplewind\thinkphp\library\think\template\taglib\Cx.php ( 23.82 KB )
- D:\Wwwroot\web\data\runtime\temp\1edcb5a49e1e5c1929f8d706c53ae51e.php ( 12.39 KB )
- D:\Wwwroot\web\app\admin\model\NavMenuModel.php ( 6.73 KB )
- D:\Wwwroot\web\simplewind\thinkphp\library\think\model\Collection.php ( 2.27 KB )
- D:\Wwwroot\web\simplewind\extend\tree\Tree.php ( 13.84 KB )
- D:\Wwwroot\web\app\admin\model\RouteModel.php ( 6.47 KB )
- D:\Wwwroot\web\app\portal\url.php ( 1.56 KB )
- D:\Wwwroot\web\app\user\url.php ( 1.00 KB )
- D:\Wwwroot\web\simplewind\extend\think\facade\Url.php ( 0.75 KB )
- D:\Wwwroot\web\simplewind\thinkphp\library\think\Url.php ( 12.72 KB )
- D:\Wwwroot\web\app\portal\service\ApiService.php ( 16.42 KB )
- D:\Wwwroot\web\app\portal\model\PortalPostModel.php ( 11.50 KB )
- D:\Wwwroot\web\simplewind\thinkphp\library\think\db\Expression.php ( 1.11 KB )
- D:\Wwwroot\web\simplewind\cmf\paginator\Bootstrap.php ( 7.38 KB )
- D:\Wwwroot\web\simplewind\thinkphp\library\think\Paginator.php ( 9.75 KB )
- D:\Wwwroot\web\simplewind\cmf\lib\Storage.php ( 3.91 KB )
- D:\Wwwroot\web\simplewind\cmf\lib\storage\Local.php ( 2.88 KB )
- D:\Wwwroot\web\simplewind\thinkphp\library\think\Response.php ( 8.28 KB )
- D:\Wwwroot\web\simplewind\thinkphp\library\think\debug\Html.php ( 4.17 KB )
- [ CACHE ] INIT File
- [ BEHAVIOR ] Run cmf\behavior\InitHookBehavior @app_init [ RunTime:0.004131s ]
- [ LANG ] D:\Wwwroot\web\simplewind\thinkphp\lang\zh-cn.php
- [ ROUTE ] array (
'type' => 'module',
'module' =>
array (
0 => 'portal',
1 => 'list',
2 => 'index',
),
)
- [ HEADER ] array (
'content-type' => '',
'content-length' => '0',
'x-original-url' => '/portal/list/index/id/3.html',
'user-agent' => 'CCBot/2.0 (https://commoncrawl.org/faq/)',
'if-modified-since' => 'Sun, 22 May 2022 13:58:13 GMT',
'host' => 'saxg-ss.com',
'accept-language' => 'en-US,en;q=0.5',
'accept-encoding' => 'br,gzip',
'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8',
'connection' => 'Keep-Alive',
)
- [ PARAM ] array (
'id' => '3',
)
- [ LANG ] D:\Wwwroot\web\simplewind\cmf\behavior/../lang\zh-cn.php
- [ LANG ] D:\Wwwroot\web\public/../app/admin\lang\zh-cn\common.php
- [ LANG ] D:\Wwwroot\web\public/../app/portal\lang\zh-cn\common.php
- [ BEHAVIOR ] Run cmf\behavior\LangBehavior @app_begin [ RunTime:0.002406s ]
- [ LANG ] D:\Wwwroot\web\public/../app/portal\lang\zh-cn.php
- [ BEHAVIOR ] Run cmf\behavior\InitAppHookBehavior @module_init [ RunTime:0.000646s ]
- [ LANG ] D:\Wwwroot\web\public/../app/portal\lang\zh-cn\home.php
- [ BEHAVIOR ] Run cmf\behavior\HomeLangBehavior @home_init [ RunTime:0.000909s ]
- [ RUN ] app\portal\controller\ListController->index[ D:\Wwwroot\web\app\portal\controller\ListController.php ]
- [ DB ] INIT mysql
- [ VIEW ] D:\Wwwroot\web\public/themes/xinguang/portal\product_list.html [ array (
0 => 'site_info',
1 => 'category',
2 => 'theme_vars',
3 => 'theme_widgets',
) ]
- [ DB ] CONNECT:[ UseTime:0.011102s ] mysql:host=127.0.0.1;port=3306;dbname=saxgss;charset=utf8mb4
- [ SQL ] SHOW COLUMNS FROM `xg_portal_category` [ RunTime:0.001023s ]
- [ SQL ] SELECT * FROM `xg_portal_category` WHERE `id` = 3 AND `status` = 1 LIMIT 1 [ RunTime:0.000628s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'xg_portal_category',
'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 `xg_theme_file` [ RunTime:0.000762s ]
- [ SQL ] SELECT * FROM `xg_theme_file` WHERE `theme` = 'xinguang' AND `file` = 'portal/article_details' LIMIT 1 [ RunTime:0.000387s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'xg_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 17,
'filtered' => 5.882352828979492,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `xg_theme_file` SET `theme`='xinguang',`action`='portal/Article/index',`file`='portal/article_details',`name`='新闻详情',`more`='[]',`config_more`='[]',`description`='新闻详情页面模板文件',`is_public`=0,`list_order`=10 WHERE `theme` = 'xinguang' AND `file` = 'portal/article_details' [ RunTime:0.002721s ]
- [ SQL ] SELECT * FROM `xg_theme_file` WHERE `theme` = 'xinguang' AND `file` = 'portal/article_list' LIMIT 1 [ RunTime:0.000471s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'xg_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 17,
'filtered' => 5.882352828979492,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `xg_theme_file` SET `theme`='xinguang',`action`='portal/List/index',`file`='portal/article_list',`name`='新闻列表',`more`='[]',`config_more`='[]',`description`='新闻列表页面模板文件',`is_public`=0,`list_order`=10 WHERE `theme` = 'xinguang' AND `file` = 'portal/article_list' [ RunTime:0.003426s ]
- [ SQL ] SELECT * FROM `xg_theme_file` WHERE `theme` = 'xinguang' AND `file` = 'portal/contact' LIMIT 1 [ RunTime:0.000451s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'xg_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 17,
'filtered' => 5.882352828979492,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `xg_theme_file` SET `theme`='xinguang',`action`='portal/Page/index',`file`='portal/contact',`name`='联系我们',`more`='[]',`config_more`='[]',`description`='联系我们模板文件',`is_public`=0,`list_order`=10 WHERE `theme` = 'xinguang' AND `file` = 'portal/contact' [ RunTime:0.002817s ]
- [ SQL ] SELECT * FROM `xg_theme_file` WHERE `theme` = 'xinguang' AND `file` = 'portal/download_details' LIMIT 1 [ RunTime:0.000449s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'xg_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 17,
'filtered' => 5.882352828979492,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `xg_theme_file` SET `theme`='xinguang',`action`='portal/Article/index',`file`='portal/download_details',`name`='下载详情',`more`='[]',`config_more`='[]',`description`='下载详情页面模板文件',`is_public`=0,`list_order`=10 WHERE `theme` = 'xinguang' AND `file` = 'portal/download_details' [ RunTime:0.003464s ]
- [ SQL ] SELECT * FROM `xg_theme_file` WHERE `theme` = 'xinguang' AND `file` = 'portal/download_list' LIMIT 1 [ RunTime:0.000587s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'xg_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 17,
'filtered' => 5.882352828979492,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `xg_theme_file` SET `theme`='xinguang',`action`='portal/List/index',`file`='portal/download_list',`name`='下载列表',`more`='[]',`config_more`='[]',`description`='下载列表页面模板文件',`is_public`=0,`list_order`=10 WHERE `theme` = 'xinguang' AND `file` = 'portal/download_list' [ RunTime:0.003341s ]
- [ SQL ] SELECT * FROM `xg_theme_file` WHERE `theme` = 'xinguang' AND `file` = 'portal/page' LIMIT 1 [ RunTime:0.000407s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'xg_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 17,
'filtered' => 5.882352828979492,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `xg_theme_file` SET `theme`='xinguang',`action`='portal/Page/index',`file`='portal/page',`name`='单页面',`more`='[]',`config_more`='[]',`description`='单页面模板文件',`is_public`=0,`list_order`=10 WHERE `theme` = 'xinguang' AND `file` = 'portal/page' [ RunTime:0.003336s ]
- [ SQL ] SELECT * FROM `xg_theme_file` WHERE `theme` = 'xinguang' AND `file` = 'portal/product' LIMIT 1 [ RunTime:0.000421s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'xg_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 17,
'filtered' => 5.882352828979492,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `xg_theme_file` SET `theme`='xinguang',`action`='portal/Page/index',`file`='portal/product',`name`='产品中心',`more`='[]',`config_more`='[]',`description`='单页面模板文件',`is_public`=0,`list_order`=10 WHERE `theme` = 'xinguang' AND `file` = 'portal/product' [ RunTime:0.002543s ]
- [ SQL ] SELECT * FROM `xg_theme_file` WHERE `theme` = 'xinguang' AND `file` = 'portal/product_details' LIMIT 1 [ RunTime:0.000419s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'xg_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 17,
'filtered' => 5.882352828979492,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `xg_theme_file` SET `theme`='xinguang',`action`='portal/Article/index',`file`='portal/product_details',`name`='产品详情',`more`='[]',`config_more`='[]',`description`='产品详情页面模板文件',`is_public`=0,`list_order`=10 WHERE `theme` = 'xinguang' AND `file` = 'portal/product_details' [ RunTime:0.003315s ]
- [ SQL ] SELECT * FROM `xg_theme_file` WHERE `theme` = 'xinguang' AND `file` = 'portal/product_list' LIMIT 1 [ RunTime:0.000431s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'xg_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 17,
'filtered' => 5.882352828979492,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `xg_theme_file` SET `theme`='xinguang',`action`='portal/List/index',`file`='portal/product_list',`name`='产品列表',`more`='[]',`config_more`='[]',`description`='产品列表页面模板文件',`is_public`=0,`list_order`=10 WHERE `theme` = 'xinguang' AND `file` = 'portal/product_list' [ RunTime:0.003269s ]
- [ SQL ] SELECT * FROM `xg_theme_file` WHERE `theme` = 'xinguang' [ RunTime:0.000507s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'xg_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 17,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `xg_theme` [ RunTime:0.000786s ]
- [ SQL ] UPDATE `xg_theme` SET `name`='xinguang',`version`='1.0.0',`demo_url`='',`author`='xinguang',`lang`='zh-cn',`author_url`='',`keywords`='模板',`description`='默认模板' WHERE `theme` = 'xinguang' [ RunTime:0.003326s ]
- [ SQL ] SELECT `more` FROM `xg_theme_file` WHERE `theme` = 'xinguang' AND ( `is_public` = 1 OR `file` = 'portal/product_list' ) [ RunTime:0.000393s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'xg_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 17,
'filtered' => 5.882352828979492,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `xg_nav` [ RunTime:0.000957s ]
- [ SQL ] SELECT `id` FROM `xg_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.000412s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'xg_nav',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 1,
'filtered' => 100.0,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `xg_nav_menu` [ RunTime:0.000702s ]
- [ SQL ] SELECT * FROM `xg_nav_menu` WHERE `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000439s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'xg_nav_menu',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 15,
'filtered' => 6.666666030883789,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT * FROM `xg_portal_category` WHERE `parent_id` = 0 AND `status` = 1 AND `module` = 'product' AND `delete_time` = 0 ORDER BY `list_order` ASC,`id` ASC [ RunTime:0.000487s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'xg_portal_category',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 35,
'filtered' => 2.857142925262451,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT * FROM `xg_portal_category` WHERE `parent_id` = 2 AND `status` = 1 AND `module` = 'product' AND `delete_time` = 0 ORDER BY `list_order` ASC,`id` ASC [ RunTime:0.000462s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'xg_portal_category',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 35,
'filtered' => 2.857142925262451,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT * FROM `xg_portal_category` WHERE `parent_id` = 3 AND `status` = 1 AND `module` = 'product' AND `delete_time` = 0 ORDER BY `list_order` ASC,`id` ASC [ RunTime:0.000526s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'xg_portal_category',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 35,
'filtered' => 2.857142925262451,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT * FROM `xg_portal_category` WHERE `parent_id` = 4 AND `status` = 1 AND `module` = 'product' AND `delete_time` = 0 ORDER BY `list_order` ASC,`id` ASC [ RunTime:0.000467s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'xg_portal_category',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 35,
'filtered' => 2.857142925262451,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT * FROM `xg_portal_category` WHERE `parent_id` = 5 AND `status` = 1 AND `module` = 'product' AND `delete_time` = 0 ORDER BY `list_order` ASC,`id` ASC [ RunTime:0.000639s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'xg_portal_category',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 35,
'filtered' => 2.857142925262451,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT * FROM `xg_portal_category` WHERE `parent_id` = 3 AND `status` = 1 AND `module` = 'product' AND `delete_time` = 0 ORDER BY `list_order` ASC,`id` ASC [ RunTime:0.000549s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'xg_portal_category',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 35,
'filtered' => 2.857142925262451,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SHOW COLUMNS FROM `xg_portal_post` [ RunTime:0.001019s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) FROM `xg_portal_post` `post` INNER JOIN `xg_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`.`create_time` >= 0 ) AND ( `category_post`.`category_id` IN ('011','12','13','14','19','20','21','22','23','24','30','') ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1670190591 ) GROUP BY `post`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.000920s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'PRIMARY',
'table' => '<derived2>',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 2,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `xg_portal_post` `post` INNER JOIN `xg_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`.`create_time` >= 0 ) AND ( `category_post`.`category_id` IN ('011','12','13','14','19','20','21','22','23','24','30','') ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1670190591 ) GROUP BY `post`.`id` ORDER BY `post`.`create_time` DESC LIMIT 0,100 [ RunTime:0.001490s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'post',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'PRIMARY,type_status_date,parent_id,user_id,create_time',
'key' => 'type_status_date',
'key_len' => '6',
'ref' => NULL,
'rows' => 42,
'filtered' => 1.9607844352722168,
'extra' => 'Using index condition; Using where; Using temporary; Using filesort',
) ]
0.235848s
