ces

网名:新乡市淘大度网络科技有限公司

职业:技术分享

现居地:河南省-新乡-辉县

Phone:

Email:383624314@qq.com

Published on 16 Feb 2020 by admin ,with 1627 readers

sdasdasdsa

<if condition="($vo.is_top ==1)"><span class="cat">Top<i></i></span></if>
<if condition="($vo.recommended ==1)"><span class="cat">推荐<i></i></span></if>

：

Previous Post 流式列表
Next PostNo latest articles...

网名:新乡市淘大度网络科技有限公司

职业:技术分享

现居地:河南省-新乡-辉县

Phone:

Email:383624314@qq.com

基本文件流程错误 SQL 调试

C:\phpstudy_pro\WWW\beian\public\index.php ( 0.97 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\base.php ( 1.71 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\Loader.php ( 12.70 KB )
C:\phpstudy_pro\WWW\beian\vendor\composer\autoload_static.php ( 6.05 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\Error.php ( 4.00 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\Container.php ( 15.53 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkcmf\cmf\src\App.php ( 29.40 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\Env.php ( 2.85 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\Config.php ( 9.71 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\convention.php ( 11.74 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\helper.php ( 20.40 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkcmf\cmf-app\src\app.php ( 5.31 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkcmf\cmf-app\src\database.php ( 0.90 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkcmf\cmf-app\src\template.php ( 2.02 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkcmf\cmf-app\src\paginate.php ( 0.17 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkcmf\cmf-app\src\tags.php ( 1.35 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\Hook.php ( 5.58 KB )
C:\phpstudy_pro\WWW\beian\data\config\database.php ( 0.50 KB )
C:\phpstudy_pro\WWW\beian\data\config\template.php ( 0.11 KB )
C:\phpstudy_pro\WWW\beian\vendor\ezyang\htmlpurifier\library\HTMLPurifier.composer.php ( 0.10 KB )
C:\phpstudy_pro\WWW\beian\vendor\topthink\think-captcha\src\helper.php ( 1.54 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\facade\Route.php ( 3.83 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\Facade.php ( 3.44 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\Route.php ( 25.79 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\Request.php ( 57.50 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\route\Domain.php ( 7.07 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\route\RuleGroup.php ( 16.45 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\route\Rule.php ( 28.92 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\route\RuleItem.php ( 8.84 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\route\RuleName.php ( 3.92 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\facade\Validate.php ( 4.83 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\Validate.php ( 43.85 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkcmf\cmf\src\common.php ( 61.45 KB )
C:\phpstudy_pro\WWW\beian\vendor\topthink\think-helper\src\helper.php ( 2.88 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\Db.php ( 7.67 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\Lang.php ( 7.38 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkcmf\cmf\src\Log.php ( 8.96 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\log\driver\File.php ( 8.97 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\lang\zh-cn.php ( 12.58 KB )
C:\phpstudy_pro\WWW\beian\data\route\route.php ( 0.02 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkcmf\cmf\src\behavior\InitHookBehavior.php ( 2.07 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\facade\Cache.php ( 2.06 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\Cache.php ( 3.27 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\cache\driver\File.php ( 7.99 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\cache\Driver.php ( 8.64 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\facade\Hook.php ( 1.46 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\route\dispatch\Url.php ( 5.24 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\route\Dispatch.php ( 9.26 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkcmf\cmf\src\route\dispatch\Module.php ( 5.15 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\Middleware.php ( 5.34 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\Cookie.php ( 7.35 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\View.php ( 5.74 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\view\driver\Think.php ( 6.12 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\Template.php ( 47.31 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\template\driver\File.php ( 2.29 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\Session.php ( 14.13 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\Debug.php ( 7.57 KB )
C:\phpstudy_pro\WWW\beian\app\portal\lang\zh-cn.php ( 0.93 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkcmf\cmf\src\behavior\LangBehavior.php ( 2.46 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\facade\Lang.php ( 1.75 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkcmf\cmf\src\lang\zh-cn.php ( 3.14 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\facade\Env.php ( 1.17 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkcmf\cmf-app\src\admin\lang\zh-cn.php ( 9.31 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkcmf\cmf-app\src\admin\lang\zh-cn\common.php ( 0.60 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkcmf\cmf-app\src\user\lang\zh-cn.php ( 4.13 KB )
C:\phpstudy_pro\WWW\beian\app\portal\lang\zh-cn\common.php ( 0.76 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkcmf\cmf\src\behavior\InitAppHookBehavior.php ( 2.01 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\Collection.php ( 13.59 KB )
C:\phpstudy_pro\WWW\beian\app\portal\controller\ArticleController.php ( 3.20 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkcmf\cmf\src\controller\HomeBaseController.php ( 8.39 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkcmf\cmf\src\controller\BaseController.php ( 2.24 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\Controller.php ( 7.53 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\traits\controller\Jump.php ( 4.76 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\facade\Config.php ( 1.52 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\facade\Cookie.php ( 1.58 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\facade\View.php ( 1.76 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkcmf\cmf\src\behavior\HomeLangBehavior.php ( 1.52 KB )
C:\phpstudy_pro\WWW\beian\app\portal\lang\zh-cn\home.php ( 0.62 KB )
C:\phpstudy_pro\WWW\beian\app\portal\model\PortalCategoryModel.php ( 8.65 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\Model.php ( 27.48 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\model\concern\Attribute.php ( 17.64 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\model\concern\RelationShip.php ( 19.85 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\model\concern\ModelEvent.php ( 6.04 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\model\concern\TimeStamp.php ( 2.58 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\model\concern\Conversion.php ( 7.83 KB )
C:\phpstudy_pro\WWW\beian\app\portal\service\PostService.php ( 9.06 KB )
C:\phpstudy_pro\WWW\beian\app\portal\model\PortalPostModel.php ( 11.49 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\db\Connection.php ( 58.93 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\db\connector\Mysql.php ( 6.24 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\db\builder\Mysql.php ( 5.54 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\db\Builder.php ( 36.78 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\db\Query.php ( 105.00 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\model\relation\BelongsToMany.php ( 20.08 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\model\Relation.php ( 4.51 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\model\Pivot.php ( 1.17 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\model\Collection.php ( 2.80 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkcmf\cmf-app\src\admin\model\ThemeModel.php ( 8.12 KB )
C:\phpstudy_pro\WWW\beian\data\runtime\temp\59738d0adf31d59a8270b75f6b312d5e.php ( 23.07 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkcmf\cmf-app\src\admin\model\NavMenuModel.php ( 6.76 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkcmf\cmf-extend\src\tree\Tree.php ( 14.39 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkcmf\cmf-app\src\admin\model\RouteModel.php ( 7.06 KB )
C:\phpstudy_pro\WWW\beian\app\portal\url.php ( 1.55 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkcmf\cmf-app\src\user\url.php ( 0.98 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\facade\Url.php ( 1.13 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\Url.php ( 13.22 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkcmf\cmf\src\lib\Storage.php ( 3.89 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkcmf\cmf\src\lib\storage\Local.php ( 2.86 KB )
C:\phpstudy_pro\WWW\beian\app\portal\model\UserModel.php ( 0.72 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\model\relation\BelongsTo.php ( 10.31 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\model\relation\OneToOne.php ( 9.76 KB )
C:\phpstudy_pro\WWW\beian\vendor\electrolinux\phpquery\phpQuery\phpQuery.php ( 41.76 KB )
C:\phpstudy_pro\WWW\beian\vendor\electrolinux\phpquery\phpQuery\phpQuery\DOMEvent.php ( 2.25 KB )
C:\phpstudy_pro\WWW\beian\vendor\electrolinux\phpquery\phpQuery\phpQuery\DOMDocumentWrapper.php ( 22.46 KB )
C:\phpstudy_pro\WWW\beian\vendor\electrolinux\phpquery\phpQuery\phpQuery\phpQueryEvents.php ( 4.85 KB )
C:\phpstudy_pro\WWW\beian\vendor\electrolinux\phpquery\phpQuery\phpQuery\Callback.php ( 4.02 KB )
C:\phpstudy_pro\WWW\beian\vendor\electrolinux\phpquery\phpQuery\phpQuery\phpQueryObject.php ( 87.75 KB )
C:\phpstudy_pro\WWW\beian\vendor\electrolinux\phpquery\phpQuery\phpQuery\compat\mbstring.php ( 1.51 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\facade\Session.php ( 2.05 KB )
C:\phpstudy_pro\WWW\beian\app\portal\service\ApiService.php ( 16.49 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\db\Expression.php ( 1.11 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkcmf\cmf\src\paginator\Bootstrap.php ( 7.37 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\Paginator.php ( 9.83 KB )
C:\phpstudy_pro\WWW\beian\app\portal\model\PortalTagModel.php ( 0.76 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\Response.php ( 9.68 KB )
C:\phpstudy_pro\WWW\beian\vendor\thinkphp\library\think\debug\Html.php ( 4.02 KB )

[ DB ] CONNECT:[ UseTime:0.003697s ] mysql:host=81.70.156.42;port=3306;dbname=beian;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `d_portal_post` [ RunTime:0.002688s ]
[ SQL ] SELECT `post`.* FROM `d_portal_post` `post` WHERE `post`.`post_type` = 1 AND `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `post`.`id` = 58 AND ( `post`.`published_time` < 1785287440 and `post`.`published_time` > 0 ) LIMIT 1 [ RunTime:0.002496s ]
[ 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.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `post`.* FROM `d_portal_post` `post` WHERE `post`.`post_type` = 1 AND `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `post`.`id` < 58 AND ( `post`.`published_time` < 1785287440 and `post`.`published_time` > 0 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.355397s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'post', 'partitions' => NULL, 'type' => 'range', 'possible_keys' => 'PRIMARY,type_status_date', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => NULL, 'rows' => 20, 'filtered' => 2.4390242099761963, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `post`.* FROM `d_portal_post` `post` WHERE `post`.`post_type` = 1 AND `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `post`.`id` > 58 AND ( `post`.`published_time` < 1785287440 and `post`.`published_time` > 0 ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.344692s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'post', 'partitions' => NULL, 'type' => 'range', 'possible_keys' => 'PRIMARY,type_status_date', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => NULL, 'rows' => 1, 'filtered' => 5.0, 'extra' => 'Using where', ) ]
[ SQL ] SHOW COLUMNS FROM `d_portal_category_post` [ RunTime:0.002467s ]
[ SQL ] SHOW COLUMNS FROM `d_portal_category` [ RunTime:0.002357s ]
[ SQL ] SELECT `d_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `d_portal_category` INNER JOIN `d_portal_category_post` `pivot` ON `pivot`.`category_id`=`d_portal_category`.`id` WHERE `pivot`.`post_id` = 58 [ RunTime:0.002418s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'pivot', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => 'term_taxonomy_id', 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 133, 'filtered' => 10.0, 'extra' => 'Using where', ) ]
[ SQL ] UPDATE `d_portal_post` SET `post_hits` = `post_hits` + 1 WHERE `id` = 58 [ RunTime:0.005219s ]
[ SQL ] SHOW COLUMNS FROM `d_theme_file` [ RunTime:0.002563s ]
[ SQL ] SELECT * FROM `d_theme_file` WHERE `theme` = 'BookStars' AND `file` = 'portal/article' LIMIT 1 [ RunTime:0.002262s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'd_theme_file', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 11, 'filtered' => 9.090909004211426, 'extra' => 'Using where', ) ]
[ SQL ] UPDATE `d_theme_file` SET `theme` = 'BookStars' , `action` = 'portal/Article/index' , `file` = 'portal/article' , `name` = '文章内容页' , `more` = '{\"vars\":[]}' , `config_more` = '{\"vars\":[]}' , `description` = '文章内容页文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 'BookStars' AND `file` = 'portal/article' [ RunTime:0.007140s ]
[ SQL ] SELECT * FROM `d_theme_file` WHERE `theme` = 'BookStars' AND `file` = 'portal/article_theme' LIMIT 1 [ RunTime:0.002225s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'd_theme_file', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 11, 'filtered' => 9.090909004211426, 'extra' => 'Using where', ) ]
[ SQL ] UPDATE `d_theme_file` SET `theme` = 'BookStars' , `action` = 'portal/Article/index' , `file` = 'portal/article_theme' , `name` = '模板内容' , `more` = '{\"vars\":[]}' , `config_more` = '{\"vars\":[]}' , `description` = '模板内容文件' , `is_public` = 0 , `list_order` = 15 WHERE `theme` = 'BookStars' AND `file` = 'portal/article_theme' [ RunTime:0.004431s ]
[ SQL ] SELECT * FROM `d_theme_file` WHERE `theme` = 'BookStars' AND `file` = 'portal/index' LIMIT 1 [ RunTime:0.002247s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'd_theme_file', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 11, 'filtered' => 9.090909004211426, 'extra' => 'Using where', ) ]
[ SQL ] UPDATE `d_theme_file` SET `theme` = 'BookStars' , `action` = 'portal/Index/index' , `file` = 'portal/index' , `name` = '首页' , `more` = '{\"vars\":[],\"widgets\":[]}' , `config_more` = '{\"vars\":[],\"widgets\":[]}' , `description` = '首页文件' , `is_public` = 0 , `list_order` = 5 WHERE `theme` = 'BookStars' AND `file` = 'portal/index' [ RunTime:0.004271s ]
[ SQL ] SELECT * FROM `d_theme_file` WHERE `theme` = 'BookStars' AND `file` = 'portal/list' LIMIT 1 [ RunTime:0.002222s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'd_theme_file', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 11, 'filtered' => 9.090909004211426, 'extra' => 'Using where', ) ]
[ SQL ] UPDATE `d_theme_file` SET `theme` = 'BookStars' , `action` = 'portal/List/index' , `file` = 'portal/list' , `name` = '文章列表' , `more` = '{\"vars\":[],\"widgets\":[]}' , `config_more` = '{\"vars\":[],\"widgets\":[]}' , `description` = '文章列表文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 'BookStars' AND `file` = 'portal/list' [ RunTime:0.004380s ]
[ SQL ] SELECT * FROM `d_theme_file` WHERE `theme` = 'BookStars' AND `file` = 'portal/list_flow' LIMIT 1 [ RunTime:0.002213s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'd_theme_file', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 11, 'filtered' => 9.090909004211426, 'extra' => 'Using where', ) ]
[ SQL ] UPDATE `d_theme_file` SET `theme` = 'BookStars' , `action` = 'portal/List/index' , `file` = 'portal/list_flow' , `name` = '流式列表页' , `more` = '{\"vars\":[],\"widgets\":[]}' , `config_more` = '{\"vars\":[],\"widgets\":[]}' , `description` = '流式列表页' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 'BookStars' AND `file` = 'portal/list_flow' [ RunTime:0.004512s ]
[ SQL ] SELECT * FROM `d_theme_file` WHERE `theme` = 'BookStars' AND `file` = 'portal/list_theme' LIMIT 1 [ RunTime:0.002201s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'd_theme_file', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 11, 'filtered' => 9.090909004211426, 'extra' => 'Using where', ) ]
[ SQL ] UPDATE `d_theme_file` SET `theme` = 'BookStars' , `action` = 'portal/List/index' , `file` = 'portal/list_theme' , `name` = '模板列表页' , `more` = '{\"vars\":[],\"widgets\":[]}' , `config_more` = '{\"vars\":[],\"widgets\":[]}' , `description` = '模板列表页文件' , `is_public` = 0 , `list_order` = 15 WHERE `theme` = 'BookStars' AND `file` = 'portal/list_theme' [ RunTime:0.004413s ]
[ SQL ] SELECT * FROM `d_theme_file` WHERE `theme` = 'BookStars' AND `file` = 'portal/page' LIMIT 1 [ RunTime:0.002269s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'd_theme_file', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 11, 'filtered' => 9.090909004211426, 'extra' => 'Using where', ) ]
[ SQL ] UPDATE `d_theme_file` SET `theme` = 'BookStars' , `action` = 'portal/Page/index' , `file` = 'portal/page' , `name` = '单页面' , `more` = '{\"widgets\":[]}' , `config_more` = '{\"widgets\":[]}' , `description` = '单页面模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 'BookStars' AND `file` = 'portal/page' [ RunTime:0.006513s ]
[ SQL ] SELECT * FROM `d_theme_file` WHERE `theme` = 'BookStars' AND `file` = 'public/config' LIMIT 1 [ RunTime:0.002402s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'd_theme_file', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 11, 'filtered' => 9.090909004211426, 'extra' => 'Using where', ) ]
[ SQL ] UPDATE `d_theme_file` SET `theme` = 'BookStars' , `action` = 'public/Config' , `file` = 'public/config' , `name` = '模板全局配置' , `more` = '{\"vars\":{\"avatar\":{\"title\":\"Avatar\",\"value\":\"default\\/20260717\\/1f5c808bb12acfd6f35d263d0a7ed404.png\",\"type\":\"image\",\"tip\":\"\\u7ad9\\u957f\\u5934\\u50cf\",\"rule\":[]},\"user_name\":{\"title\":\"User Name\",\"value\":\"\\u65b0\\u4e61\\u5e02\\u6dd8\\u5927\\u5ea6\\u7f51\\u7edc\\u79d1\\u6280\\u6709\\u9650\\u516c\\u53f8\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"user_job\":{\"title\":\"User Job\",\"value\":\"\\u6280\\u672f\\u5206\\u4eab\",\"type\":\"textarea\",\"tip\":\"\",\"rule\":{\"require\":true}},\"address\":{\"title\":\"Address\",\"value\":\"\\u6cb3\\u5357\\u7701-\\u65b0\\u4e61-\\u8f89\\u53bf\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"email\":{\"title\":\"Email\",\"value\":\"383624314@qq.com\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"phone\":{\"title\":\"Phone\",\"value\":\"010 1010 1010\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"mobile_phone\":{\"title\":\"Mobile Phone\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\",\"rule\":[]},\"qq\":{\"title\":\"QQ\",\"value\":\"000000\",\"type\":\"text\",\"tip\":\"\\u591a\\u4e2a QQ\\u4ee5\\u82f1\\u6587\\u9017\\u53f7\\u9694\\u5f00\",\"rule\":{\"require\":true}},\"wechat_number\":{\"title\":\"Wechat Number\",\"value\":\"oliverwien\",\"type\":\"text\",\"tip\":\"\\u5fae\\u4fe1\\u53f7\",\"rule\":[]},\"wechat_code\":{\"title\":\"Wechat Code\",\"value\":\"\",\"type\":\"image\",\"tip\":\"\\u5fae\\u4fe1\\u4e8c\\u7ef4\\u7801\\u8bbe\\u7f6e\",\"rule\":[]}}}' , `config_more` = '{\"vars\":{\"avatar\":{\"title\":\"Avatar\",\"value\":\"\",\"type\":\"image\",\"tip\":\"\\u7ad9\\u957f\\u5934\\u50cf\",\"rule\":[]},\"user_name\":{\"title\":\"User Name\",\"value\":\"Oliver Wien | \\u5965\\u5229\\u5f17\\u00b7\\u97e6\\u6069\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"user_job\":{\"title\":\"User Job\",\"value\":\"Web\\u524d\\u7aef\\u8bbe\\u8ba1\\u5e08\\u3001\\u7f51\\u9875\\u8bbe\\u8ba1\",\"type\":\"textarea\",\"tip\":\"\",\"rule\":{\"require\":true}},\"address\":{\"title\":\"Address\",\"value\":\"\\u9655\\u897f\\u7701-\\u897f\\u5b89\\u5e02\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"email\":{\"title\":\"Email\",\"value\":\"oliverwien@126.com\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"phone\":{\"title\":\"Phone\",\"value\":\"010 1010 1010\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"mobile_phone\":{\"title\":\"Mobile Phone\",\"value\":\"+86 182 2052 3738\",\"type\":\"text\",\"tip\":\"\",\"rule\":[]},\"qq\":{\"title\":\"QQ\",\"value\":\"921030087\",\"type\":\"text\",\"tip\":\"\\u591a\\u4e2a QQ\\u4ee5\\u82f1\\u6587\\u9017\\u53f7\\u9694\\u5f00\",\"rule\":{\"require\":true}},\"wechat_number\":{\"title\":\"Wechat Number\",\"value\":\"oliverwien\",\"type\":\"text\",\"tip\":\"\\u5fae\\u4fe1\\u53f7\",\"rule\":[]},\"wechat_code\":{\"title\":\"Wechat Code\",\"value\":\"\",\"type\":\"image\",\"tip\":\"\\u5fae\\u4fe1\\u4e8c\\u7ef4\\u7801\\u8bbe\\u7f6e\",\"rule\":[]}}}' , `description` = '模板全局配置文件' , `is_public` = 1 , `list_order` = 0 WHERE `theme` = 'BookStars' AND `file` = 'public/config' [ RunTime:0.004903s ]
[ SQL ] SELECT * FROM `d_theme_file` WHERE `theme` = 'BookStars' AND `file` = 'public/footer' LIMIT 1 [ RunTime:0.002241s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'd_theme_file', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 11, 'filtered' => 9.090909004211426, 'extra' => 'Using where', ) ]
[ SQL ] UPDATE `d_theme_file` SET `theme` = 'BookStars' , `action` = 'public/Footer' , `file` = 'public/footer' , `name` = '通用底部' , `more` = '{\"vars\":[],\"widgets\":[]}' , `config_more` = '{\"vars\":[],\"widgets\":[]}' , `description` = '导航条模板文件' , `is_public` = 1 , `list_order` = 10 WHERE `theme` = 'BookStars' AND `file` = 'public/footer' [ RunTime:0.008374s ]
[ SQL ] SELECT * FROM `d_theme_file` WHERE `theme` = 'BookStars' AND `file` = 'public/nav' LIMIT 1 [ RunTime:0.002248s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'd_theme_file', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 11, 'filtered' => 9.090909004211426, 'extra' => 'Using where', ) ]
[ SQL ] UPDATE `d_theme_file` SET `theme` = 'BookStars' , `action` = 'public/Nav' , `file` = 'public/nav' , `name` = '导航条' , `more` = '{\"vars\":[]}' , `config_more` = '{\"vars\":[]}' , `description` = '导航条模板文件' , `is_public` = 1 , `list_order` = 1 WHERE `theme` = 'BookStars' AND `file` = 'public/nav' [ RunTime:0.004725s ]
[ SQL ] SELECT * FROM `d_theme_file` WHERE `theme` = 'BookStars' AND `file` = 'public/sidebar' LIMIT 1 [ RunTime:0.002233s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'd_theme_file', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 11, 'filtered' => 9.090909004211426, 'extra' => 'Using where', ) ]
[ SQL ] UPDATE `d_theme_file` SET `theme` = 'BookStars' , `action` = 'public/Sidebar' , `file` = 'public/sidebar' , `name` = '导航条' , `more` = '{\"vars\":[],\"widgets\":{\"latest_posts\":{\"title\":\"Latest posts\",\"display\":\"1\",\"vars\":{\"latest_posts_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\\u53ef\\u591a\\u9009\",\"rule\":{\"require\":true}}}},\"categories\":{\"title\":\"Categories\",\"display\":\"1\",\"vars\":{\"category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\\u53ea\\u5355\\u9009\\uff0c\\u9009\\u62e9\\u7236\\u7ea7\\u5206\\u7c7bid\",\"rule\":{\"require\":true}}}}}}' , `config_more` = '{\"vars\":[],\"widgets\":{\"latest_posts\":{\"title\":\"Latest posts\",\"display\":\"1\",\"vars\":{\"latest_posts_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\\u53ef\\u591a\\u9009\",\"rule\":{\"require\":true}}}},\"categories\":{\"title\":\"Categories\",\"display\":\"1\",\"vars\":{\"category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\\u53ea\\u5355\\u9009\\uff0c\\u9009\\u62e9\\u7236\\u7ea7\\u5206\\u7c7bid\",\"rule\":{\"require\":true}}}}}}' , `description` = '侧边栏模板文件' , `is_public` = 1 , `list_order` = 1 WHERE `theme` = 'BookStars' AND `file` = 'public/sidebar' [ RunTime:0.006915s ]
[ SQL ] SELECT * FROM `d_theme_file` WHERE `theme` = 'BookStars' [ RunTime:0.002280s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'd_theme_file', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 11, 'filtered' => 10.0, 'extra' => 'Using where', ) ]
[ SQL ] SHOW COLUMNS FROM `d_theme` [ RunTime:0.002474s ]
[ SQL ] UPDATE `d_theme` SET `name` = 'BookStars' , `version` = '1.0.5' , `demo_url` = 'http://blog.wien.ren' , `author` = 'OLIVER_WIEN' , `lang` = 'zh-cn' , `author_url` = 'http://blog.wien.ren' , `keywords` = '《BookStars》,响应式,博客' , `description` = '《BookStars》星之书笔记' WHERE `theme` = 'BookStars' [ RunTime:0.002198s ]
[ SQL ] SELECT `more` FROM `d_theme_file` WHERE `theme` = 'BookStars' AND ( `is_public` = 1 OR `file` = 'portal/article' ) [ RunTime:0.002253s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'd_theme_file', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 11, 'filtered' => 9.090909004211426, 'extra' => 'Using where', ) ]
[ SQL ] SHOW COLUMNS FROM `d_nav` [ RunTime:0.002360s ]
[ SQL ] SELECT `id` FROM `d_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.002197s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'd_nav', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 2, 'filtered' => 50.0, 'extra' => 'Using where', ) ]
[ SQL ] SHOW COLUMNS FROM `d_nav_menu` [ RunTime:0.002336s ]
[ SQL ] SELECT * FROM `d_nav_menu` WHERE `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.002307s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'd_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 ] SHOW COLUMNS FROM `d_option` [ RunTime:0.002435s ]
[ SQL ] SELECT `option_value` FROM `d_option` WHERE `option_name` = 'storage' LIMIT 1 [ RunTime:0.002221s ]
[ 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 ] SHOW COLUMNS FROM `d_user` [ RunTime:0.002395s ]
[ SQL ] SELECT * FROM `d_user` WHERE `id` = 1 LIMIT 1 [ RunTime:0.002229s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'd_user', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count FROM `d_portal_post` `post` INNER JOIN `d_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` < 1785287441 ) GROUP BY `post`.`id` ) `_group_count_` [ RunTime:0.002867s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'PRIMARY', 'table' => '<derived2>', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 13, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `d_portal_post` `post` INNER JOIN `d_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` < 1785287441 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 0,10 [ RunTime:0.006093s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'post', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'PRIMARY,type_status_date,parent_id,user_id,create_time', 'key' => 'type_status_date', 'key_len' => '2', 'ref' => 'const,const', 'rows' => 42, 'filtered' => 2.4390242099761963, 'extra' => 'Using where; Using temporary; Using filesort', ) ]
[ SQL ] SELECT * FROM `d_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 0 [ RunTime:0.002402s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'd_portal_category', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 17, 'filtered' => 5.882352828979492, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `d_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 1 [ RunTime:0.002380s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'd_portal_category', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 17, 'filtered' => 5.882352828979492, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `d_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 2 [ RunTime:0.002352s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'd_portal_category', '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 `d_portal_tag` [ RunTime:0.002580s ]
[ SQL ] SELECT * FROM `d_portal_tag` `tag` [ RunTime:0.002380s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'tag', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 74, 'filtered' => 100.0, 'extra' => NULL, ) ]

1.367113s

淘大度

ces

Comments 0

Latest posts

Categories

Tags