sql - Powerless - 学习笔记

基本文件流程错误 SQL 调试

/home/wwwroot/blog/public/index.php ( 1.05 KB )
/home/wwwroot/blog/vendor/autoload.php ( 0.73 KB )
/home/wwwroot/blog/vendor/composer/autoload_real.php ( 1.63 KB )
/home/wwwroot/blog/vendor/composer/platform_check.php ( 0.90 KB )
/home/wwwroot/blog/vendor/composer/ClassLoader.php ( 15.99 KB )
/home/wwwroot/blog/vendor/composer/autoload_static.php ( 8.08 KB )
/home/wwwroot/blog/vendor/topthink/think-helper/src/helper.php ( 8.34 KB )
/home/wwwroot/blog/vendor/topthink/think-orm/stubs/load_stubs.php ( 0.16 KB )
/home/wwwroot/blog/vendor/topthink/framework/src/think/Exception.php ( 1.69 KB )
/home/wwwroot/blog/vendor/topthink/framework/src/think/Facade.php ( 2.71 KB )
/home/wwwroot/blog/vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php ( 0.10 KB )
/home/wwwroot/blog/vendor/thinkcmf/cmf/src/common.php ( 69.14 KB )
/home/wwwroot/blog/vendor/thinkcmf/cmf/think/App.php ( 17.72 KB )
/home/wwwroot/blog/vendor/topthink/framework/src/think/Container.php ( 15.39 KB )
/home/wwwroot/blog/vendor/psr/container/src/ContainerInterface.php ( 1.02 KB )
/home/wwwroot/blog/vendor/thinkcmf/cmf-app/src/provider.php ( 0.24 KB )
/home/wwwroot/blog/vendor/thinkcmf/cmf/think/Http.php ( 7.16 KB )
/home/wwwroot/blog/vendor/topthink/think-helper/src/helper/Str.php ( 7.29 KB )
/home/wwwroot/blog/vendor/topthink/framework/src/think/Env.php ( 4.68 KB )
/home/wwwroot/blog/vendor/topthink/framework/src/helper.php ( 18.47 KB )
/home/wwwroot/blog/vendor/topthink/framework/src/think/Config.php ( 4.62 KB )
/home/wwwroot/blog/vendor/thinkcmf/cmf/src/config/app.php ( 1.35 KB )
/home/wwwroot/blog/vendor/topthink/framework/src/think/facade/Env.php ( 1.67 KB )
/home/wwwroot/blog/vendor/thinkcmf/cmf/src/config/cache.php ( 0.80 KB )
/home/wwwroot/blog/vendor/thinkcmf/cmf/src/config/console.php ( 1.10 KB )
/home/wwwroot/blog/vendor/thinkcmf/cmf/src/config/log.php ( 1.37 KB )
/home/wwwroot/blog/vendor/thinkcmf/cmf/src/config/route.php ( 1.54 KB )
/home/wwwroot/blog/vendor/thinkcmf/cmf/src/config/template.php ( 0.64 KB )
/home/wwwroot/blog/vendor/thinkcmf/cmf/src/config/view.php ( 1.06 KB )
/home/wwwroot/blog/data/config/app.php ( 0.12 KB )
/home/wwwroot/blog/data/config/database.php ( 2.47 KB )
/home/wwwroot/blog/data/config/template.php ( 0.11 KB )
/home/wwwroot/blog/vendor/thinkcmf/cmf-app/src/event.php ( 0.55 KB )
/home/wwwroot/blog/vendor/topthink/framework/src/think/Event.php ( 6.97 KB )
/home/wwwroot/blog/vendor/topthink/framework/src/think/Lang.php ( 7.22 KB )
/home/wwwroot/blog/vendor/topthink/framework/src/lang/zh-cn.php ( 13.27 KB )
/home/wwwroot/blog/vendor/thinkcmf/cmf/src/listener/InitHookListener.php ( 2.53 KB )
/home/wwwroot/blog/vendor/topthink/framework/src/think/facade/Route.php ( 4.68 KB )
/home/wwwroot/blog/vendor/thinkcmf/cmf/think/Route.php ( 23.46 KB )
/home/wwwroot/blog/vendor/topthink/framework/src/think/route/RuleName.php ( 5.34 KB )
/home/wwwroot/blog/vendor/topthink/framework/src/think/route/Domain.php ( 5.53 KB )
/home/wwwroot/blog/vendor/topthink/framework/src/think/route/RuleGroup.php ( 13.42 KB )
/home/wwwroot/blog/vendor/thinkcmf/cmf/think/route/Rule.php ( 23.63 KB )
/home/wwwroot/blog/vendor/topthink/framework/src/think/route/RuleItem.php ( 9.19 KB )
/home/wwwroot/blog/vendor/topthink/framework/src/think/facade/Cache.php ( 2.06 KB )
/home/wwwroot/blog/vendor/topthink/framework/src/think/Cache.php ( 4.91 KB )
/home/wwwroot/blog/vendor/topthink/framework/src/think/Manager.php ( 3.92 KB )
/home/wwwroot/blog/vendor/psr/simple-cache/src/CacheInterface.php ( 4.71 KB )
/home/wwwroot/blog/vendor/topthink/think-helper/src/helper/Arr.php ( 17.45 KB )
/home/wwwroot/blog/vendor/topthink/framework/src/think/cache/driver/File.php ( 7.60 KB )
/home/wwwroot/blog/vendor/topthink/framework/src/think/cache/Driver.php ( 8.17 KB )
/home/wwwroot/blog/vendor/topthink/framework/src/think/contract/CacheHandlerInterface.php ( 1.99 KB )
/home/wwwroot/blog/vendor/topthink/framework/src/think/facade/Event.php ( 1.79 KB )
/home/wwwroot/blog/vendor/topthink/framework/src/think/initializer/Error.php ( 3.27 KB )
/home/wwwroot/blog/vendor/topthink/framework/src/think/initializer/RegisterService.php ( 1.33 KB )
/home/wwwroot/blog/vendor/services.php ( 0.18 KB )
/home/wwwroot/blog/vendor/topthink/framework/src/think/service/PaginatorService.php ( 1.52 KB )
/home/wwwroot/blog/vendor/topthink/framework/src/think/Service.php ( 1.64 KB )
/home/wwwroot/blog/vendor/topthink/framework/src/think/service/ValidateService.php ( 0.99 KB )
/home/wwwroot/blog/vendor/topthink/framework/src/think/service/ModelService.php ( 1.75 KB )
/home/wwwroot/blog/vendor/topthink/think-trace/src/Service.php ( 0.77 KB )
/home/wwwroot/blog/vendor/topthink/framework/src/think/Middleware.php ( 6.65 KB )
/home/wwwroot/blog/vendor/xia/migration/src/Service.php ( 1.97 KB )
/home/wwwroot/blog/vendor/topthink/framework/src/think/initializer/BootService.php ( 0.77 KB )
/home/wwwroot/blog/vendor/topthink/think-orm/src/Paginator.php ( 11.71 KB )
/home/wwwroot/blog/vendor/topthink/framework/src/think/Validate.php ( 46.72 KB )
/home/wwwroot/blog/vendor/topthink/think-orm/src/Model.php ( 26.86 KB )
/home/wwwroot/blog/vendor/topthink/think-orm/src/model/concern/Attribute.php ( 19.19 KB )
/home/wwwroot/blog/vendor/topthink/think-orm/src/model/concern/RelationShip.php ( 26.44 KB )
/home/wwwroot/blog/vendor/topthink/think-orm/src/model/concern/ModelEvent.php ( 2.58 KB )
/home/wwwroot/blog/vendor/topthink/think-orm/src/model/concern/TimeStamp.php ( 5.69 KB )
/home/wwwroot/blog/vendor/topthink/think-orm/src/model/concern/AutoWriteId.php ( 1.44 KB )
/home/wwwroot/blog/vendor/topthink/think-orm/src/model/concern/Conversion.php ( 10.85 KB )
/home/wwwroot/blog/vendor/topthink/think-helper/src/contract/Arrayable.php ( 0.09 KB )
/home/wwwroot/blog/vendor/topthink/think-helper/src/contract/Jsonable.php ( 0.13 KB )
/home/wwwroot/blog/vendor/topthink/framework/src/think/Db.php ( 2.88 KB )
/home/wwwroot/blog/vendor/topthink/think-orm/src/DbManager.php ( 8.33 KB )
/home/wwwroot/blog/vendor/topthink/framework/src/think/Log.php ( 6.27 KB )
/home/wwwroot/blog/vendor/psr/log/src/LoggerTrait.php ( 2.69 KB )
/home/wwwroot/blog/vendor/psr/log/src/LoggerInterface.php ( 2.71 KB )
/home/wwwroot/blog/vendor/thinkcmf/cmf/think/Console.php ( 22.69 KB )
/home/wwwroot/blog/vendor/topthink/framework/src/think/Request.php ( 54.47 KB )
/home/wwwroot/blog/vendor/thinkcmf/cmf-app/src/middleware.php ( 0.25 KB )
/home/wwwroot/blog/vendor/topthink/framework/src/think/Pipeline.php ( 2.61 KB )
/home/wwwroot/blog/vendor/topthink/think-trace/src/TraceDebug.php ( 2.94 KB )
/home/wwwroot/blog/vendor/thinkcmf/cmf/src/middleware/LangDetect.php ( 5.77 KB )
/home/wwwroot/blog/vendor/topthink/framework/src/think/middleware/SessionInit.php ( 1.94 KB )
/home/wwwroot/blog/vendor/topthink/framework/src/think/Session.php ( 1.80 KB )
/home/wwwroot/blog/vendor/topthink/framework/src/think/session/driver/File.php ( 6.27 KB )
/home/wwwroot/blog/vendor/topthink/framework/src/think/contract/SessionHandlerInterface.php ( 0.87 KB )
/home/wwwroot/blog/vendor/topthink/framework/src/think/session/Store.php ( 7.06 KB )
/home/wwwroot/blog/data/route/route.php ( 0.69 KB )
/home/wwwroot/blog/vendor/thinkcmf/cmf/think/route/dispatch/Controller.php ( 7.52 KB )
/home/wwwroot/blog/vendor/topthink/framework/src/think/route/Dispatch.php ( 6.07 KB )
/home/wwwroot/blog/vendor/thinkcmf/cmf/src/listener/ModuleInitListener.php ( 2.14 KB )
/home/wwwroot/blog/vendor/topthink/think-helper/src/Collection.php ( 16.47 KB )
/home/wwwroot/blog/app/portal/controller/SearchController.php ( 0.66 KB )
/home/wwwroot/blog/vendor/thinkcmf/cmf/src/controller/HomeBaseController.php ( 11.21 KB )
/home/wwwroot/blog/vendor/thinkcmf/cmf/src/controller/BaseController.php ( 10.69 KB )
/home/wwwroot/blog/vendor/thinkcmf/cmf/think/View.php ( 4.99 KB )
/home/wwwroot/blog/vendor/topthink/framework/src/think/facade/Config.php ( 1.37 KB )
/home/wwwroot/blog/vendor/topthink/framework/src/think/facade/Cookie.php ( 1.48 KB )
/home/wwwroot/blog/vendor/topthink/framework/src/think/Cookie.php ( 5.97 KB )
/home/wwwroot/blog/vendor/thinkcmf/cmf/think/view/driver/Think.php ( 8.42 KB )
/home/wwwroot/blog/vendor/thinkcmf/cmf/think/Template.php ( 53.66 KB )
/home/wwwroot/blog/vendor/thinkcmf/cmf/think/template/driver/File.php ( 2.33 KB )
/home/wwwroot/blog/vendor/thinkcmf/cmf/src/listener/HomeLangListener.php ( 3.32 KB )
/home/wwwroot/blog/vendor/topthink/framework/src/think/facade/Session.php ( 1.79 KB )
/home/wwwroot/blog/vendor/thinkcmf/cmf/src/lang/zh-cn.php ( 6.92 KB )
/home/wwwroot/blog/app/portal/lang/zh-cn/common.php ( 0.77 KB )
/home/wwwroot/blog/app/portal/lang/zh-cn.php ( 1.13 KB )
/home/wwwroot/blog/app/portal/lang/zh-cn/home.php ( 0.62 KB )
/home/wwwroot/blog/vendor/thinkcmf/cmf-app/src/admin/model/ThemeModel.php ( 12.28 KB )
/home/wwwroot/blog/vendor/thinkcmf/cmf-app/src/admin/model/ThemeFileModel.php ( 1.91 KB )
/home/wwwroot/blog/vendor/topthink/think-orm/src/db/connector/Mysql.php ( 4.33 KB )
/home/wwwroot/blog/vendor/topthink/think-orm/src/db/PDOConnection.php ( 51.60 KB )
/home/wwwroot/blog/vendor/topthink/think-orm/src/db/Connection.php ( 8.81 KB )
/home/wwwroot/blog/vendor/topthink/think-orm/src/db/ConnectionInterface.php ( 4.86 KB )
/home/wwwroot/blog/vendor/topthink/think-orm/src/db/builder/Mysql.php ( 16.56 KB )
/home/wwwroot/blog/vendor/topthink/think-orm/src/db/Builder.php ( 22.26 KB )
/home/wwwroot/blog/vendor/topthink/think-orm/src/db/BaseBuilder.php ( 27.29 KB )
/home/wwwroot/blog/vendor/topthink/think-orm/src/db/Query.php ( 15.21 KB )
/home/wwwroot/blog/vendor/topthink/think-orm/src/db/BaseQuery.php ( 41.60 KB )
/home/wwwroot/blog/vendor/topthink/think-orm/src/db/concern/TimeFieldQuery.php ( 7.43 KB )
/home/wwwroot/blog/vendor/topthink/think-orm/src/db/concern/AggregateQuery.php ( 3.26 KB )
/home/wwwroot/blog/vendor/topthink/think-orm/src/db/concern/ModelRelationQuery.php ( 19.29 KB )
/home/wwwroot/blog/vendor/topthink/think-orm/src/db/concern/ParamsBind.php ( 3.66 KB )
/home/wwwroot/blog/vendor/topthink/think-orm/src/db/concern/ResultOperation.php ( 6.98 KB )
/home/wwwroot/blog/vendor/topthink/think-orm/src/db/concern/Transaction.php ( 2.77 KB )
/home/wwwroot/blog/vendor/topthink/think-orm/src/db/concern/WhereQuery.php ( 18.79 KB )
/home/wwwroot/blog/vendor/topthink/think-orm/src/db/concern/JoinAndViewQuery.php ( 6.96 KB )
/home/wwwroot/blog/vendor/topthink/think-orm/src/db/concern/TableFieldInfo.php ( 2.46 KB )
/home/wwwroot/blog/vendor/topthink/framework/src/think/log/driver/File.php ( 6.17 KB )
/home/wwwroot/blog/vendor/topthink/framework/src/think/contract/LogHandlerInterface.php ( 0.86 KB )
/home/wwwroot/blog/vendor/topthink/framework/src/think/log/Channel.php ( 3.88 KB )
/home/wwwroot/blog/vendor/topthink/framework/src/think/event/LogRecord.php ( 0.86 KB )
/home/wwwroot/blog/vendor/topthink/think-orm/src/model/Collection.php ( 6.96 KB )
/home/wwwroot/blog/vendor/topthink/think-orm/src/facade/Db.php ( 0.93 KB )
/home/wwwroot/blog/data/runtime/temp/zh-cn_9a3d4ff8f3aafb352f68b253887e5b3b.php ( 33.45 KB )
/home/wwwroot/blog/vendor/thinkcmf/cmf-app/src/admin/model/NavMenuModel.php ( 7.52 KB )
/home/wwwroot/blog/vendor/thinkcmf/cmf-extend/src/tree/Tree.php ( 9.98 KB )
/home/wwwroot/blog/vendor/thinkcmf/cmf-app/src/admin/model/RouteModel.php ( 8.92 KB )
/home/wwwroot/blog/app/portal/url.php ( 1.55 KB )
/home/wwwroot/blog/vendor/thinkcmf/cmf-app/src/user/url.php ( 0.99 KB )
/home/wwwroot/blog/vendor/thinkcmf/cmf/think/route/Url.php ( 16.58 KB )
/home/wwwroot/blog/app/portal/model/PortalTagModel.php ( 0.84 KB )
/home/wwwroot/blog/vendor/thinkcmf/cmf-app/src/admin/model/PluginModel.php ( 3.76 KB )
/home/wwwroot/blog/app/portal/service/ApiService.php ( 17.63 KB )
/home/wwwroot/blog/app/portal/model/PortalPostModel.php ( 11.58 KB )
/home/wwwroot/blog/vendor/topthink/think-orm/src/db/Raw.php ( 1.22 KB )
/home/wwwroot/blog/vendor/topthink/think-orm/src/db/Fetch.php ( 13.25 KB )
/home/wwwroot/blog/vendor/thinkcmf/cmf/src/paginator/Bootstrap.php ( 7.37 KB )
/home/wwwroot/blog/app/portal/model/UserModel.php ( 0.80 KB )
/home/wwwroot/blog/vendor/topthink/think-orm/src/model/relation/BelongsTo.php ( 11.65 KB )
/home/wwwroot/blog/vendor/topthink/think-orm/src/model/relation/OneToOne.php ( 10.49 KB )
/home/wwwroot/blog/vendor/topthink/think-orm/src/model/Relation.php ( 5.12 KB )
/home/wwwroot/blog/public/plugins/love/LovePlugin.php ( 0.86 KB )
/home/wwwroot/blog/vendor/thinkcmf/cmf/src/lib/Plugin.php ( 8.35 KB )
/home/wwwroot/blog/data/runtime/temp/2cf8782f1845c2b482f08dfd9697ee0f.php ( 0.18 KB )
/home/wwwroot/blog/public/plugins/mouse_attract/MouseAttractPlugin.php ( 0.97 KB )
/home/wwwroot/blog/data/runtime/temp/74f3fa539a50cdcabe9b6afdb34de1f4.php ( 0.29 KB )
/home/wwwroot/blog/vendor/thinkcmf/cmf-app/src/admin/service/ApiService.php ( 1.40 KB )
/home/wwwroot/blog/vendor/thinkcmf/cmf-app/src/admin/model/LinkModel.php ( 0.75 KB )
/home/wwwroot/blog/vendor/topthink/framework/src/think/Response.php ( 8.65 KB )
/home/wwwroot/blog/vendor/topthink/framework/src/think/response/Html.php ( 0.97 KB )
/home/wwwroot/blog/vendor/topthink/think-trace/src/Html.php ( 4.37 KB )

CONNECT:[ UseTime:0.011999s ] mysql:host=10.0.30.2;port=3306;dbname=server;charset=utf8mb4
SHOW FULL COLUMNS FROM `wzx_theme_file` [ RunTime:0.008432s ]
SELECT * FROM `wzx_theme_file` WHERE `theme` = 'wzxaini9' AND `file` = 'portal/article' LIMIT 1 [ RunTime:0.008018s ]
UPDATE `wzx_theme_file` SET `theme` = 'wzxaini9' , `action` = 'portal/Article/index' , `file` = 'portal/article' , `name` = '文章页' , `more` = '{\"widgets_blocks\":[]}' , `config_more` = '{\"widgets_blocks\":[]}' , `description` = '博客文章页' , `is_public` = 0 , `list_order` = '2' WHERE `theme` = 'wzxaini9' AND `file` = 'portal/article' [ RunTime:0.007909s ]
SELECT * FROM `wzx_theme_file` WHERE `theme` = 'wzxaini9' AND `file` = 'portal/index' LIMIT 1 [ RunTime:0.008064s ]
UPDATE `wzx_theme_file` SET `theme` = 'wzxaini9' , `action` = 'portal/Index/index' , `file` = 'portal/index' , `name` = '首页' , `more` = '{\"widgets_blocks\":[]}' , `config_more` = '{\"widgets_blocks\":[]}' , `description` = '博客授业' , `is_public` = 0 , `list_order` = '2' WHERE `theme` = 'wzxaini9' AND `file` = 'portal/index' [ RunTime:0.008110s ]
SELECT * FROM `wzx_theme_file` WHERE `theme` = 'wzxaini9' AND `file` = 'portal/list' LIMIT 1 [ RunTime:0.007989s ]
UPDATE `wzx_theme_file` SET `theme` = 'wzxaini9' , `action` = 'portal/List/index' , `file` = 'portal/list' , `name` = '列表页' , `more` = '{\"widgets_blocks\":[]}' , `config_more` = '{\"widgets_blocks\":[]}' , `description` = '博客列表页' , `is_public` = 0 , `list_order` = '2' WHERE `theme` = 'wzxaini9' AND `file` = 'portal/list' [ RunTime:0.008119s ]
SELECT * FROM `wzx_theme_file` WHERE `theme` = 'wzxaini9' AND `file` = 'portal/search' LIMIT 1 [ RunTime:0.007973s ]
UPDATE `wzx_theme_file` SET `theme` = 'wzxaini9' , `action` = 'portal/Search/index' , `file` = 'portal/search' , `name` = '搜索页' , `more` = '{\"widgets_blocks\":[]}' , `config_more` = '{\"widgets_blocks\":[]}' , `description` = '博客搜索页' , `is_public` = 0 , `list_order` = '2' WHERE `theme` = 'wzxaini9' AND `file` = 'portal/search' [ RunTime:0.008046s ]
SELECT * FROM `wzx_theme_file` WHERE `theme` = 'wzxaini9' [ RunTime:0.007885s ]
SHOW FULL COLUMNS FROM `wzx_theme` [ RunTime:0.008547s ]
UPDATE `wzx_theme` SET `name` = 'Powerless' , `version` = '1.0.0' , `demo_url` = 'https://www.wzxaini9.cn/' , `author` = 'Powerless' , `lang` = 'zh-cn' , `author_url` = 'https://www.wzxaini9.cn/' , `keywords` = 'Powerless的海桥声模板' , `description` = '海桥声默认模板' WHERE `theme` = 'wzxaini9' [ RunTime:0.007968s ]
SELECT `more`,`file`,`id`,`is_public` FROM `wzx_theme_file` WHERE `theme` = 'wzxaini9' AND ( `is_public` = 1 OR `file` = 'portal/search' ) ORDER BY `is_public` DESC [ RunTime:0.008005s ]
SHOW FULL COLUMNS FROM `wzx_nav_menu` [ RunTime:0.008285s ]
SELECT * FROM `wzx_nav_menu` WHERE `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.007952s ]
SHOW FULL COLUMNS FROM `wzx_portal_tag` [ RunTime:0.008191s ]
SELECT `id`,`name` FROM `wzx_portal_tag` WHERE ( `status` = 1 AND `recommended` = 1 AND `post_count` > '2' ) ORDER BY `id` DESC [ RunTime:0.008116s ]
SHOW FULL COLUMNS FROM `wzx_plugin` [ RunTime:0.008321s ]
SELECT `status` FROM `wzx_plugin` WHERE `name` = 'Github' LIMIT 1 [ RunTime:0.007937s ]
SELECT `status` FROM `wzx_plugin` WHERE `name` = 'Gitee' LIMIT 1 [ RunTime:0.008064s ]
SELECT `status` FROM `wzx_plugin` WHERE `name` = 'Qq' LIMIT 1 [ RunTime:0.007888s ]
SELECT `status` FROM `wzx_plugin` WHERE `name` = 'Weibo' LIMIT 1 [ RunTime:0.008690s ]
SELECT `status` FROM `wzx_plugin` WHERE `name` = 'Github' LIMIT 1 [ RunTime:0.007877s ]
SELECT `status` FROM `wzx_plugin` WHERE `name` = 'Gitee' LIMIT 1 [ RunTime:0.007885s ]
SELECT `status` FROM `wzx_plugin` WHERE `name` = 'Qq' LIMIT 1 [ RunTime:0.008004s ]
SELECT `status` FROM `wzx_plugin` WHERE `name` = 'Weibo' LIMIT 1 [ RunTime:0.007967s ]
SHOW FULL COLUMNS FROM `wzx_portal_post` [ RunTime:0.008718s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `wzx_portal_post` `post` INNER JOIN `wzx_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`.`post_status` = '1' AND `post`.`post_type` = '1' AND `post`.`delete_time` = '0' AND `post`.`post_title` LIKE '%sql%' ) AND ( `post`.`published_time` > '0' AND `post`.`published_time` < '1769942394' ) GROUP BY `post`.`id` ) `_group_count_` [ RunTime:0.015836s ]
SELECT post_id,max(category_id),post_title,post_excerpt,post_keywords,user_id,published_time,thumbnail FROM `wzx_portal_post` `post` INNER JOIN `wzx_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`.`post_status` = '1' AND `post`.`post_type` = '1' AND `post`.`delete_time` = '0' AND `post`.`post_title` LIKE '%sql%' ) AND ( `post`.`published_time` > '0' AND `post`.`published_time` < '1769942394' ) GROUP BY `post`.`id` ORDER BY `post`.`create_time` DESC LIMIT 20,10 [ RunTime:0.014143s ]
SHOW FULL COLUMNS FROM `wzx_user` [ RunTime:0.008513s ]
SELECT * FROM `wzx_user` WHERE `id` = '18' LIMIT 1 [ RunTime:0.008121s ]
SELECT * FROM `wzx_user` WHERE `id` = '18' LIMIT 1 [ RunTime:0.008128s ]
SELECT * FROM `wzx_user` WHERE `id` = '18' LIMIT 1 [ RunTime:0.008062s ]
SELECT * FROM `wzx_user` WHERE `id` = '1' LIMIT 1 [ RunTime:0.007974s ]
SELECT * FROM `wzx_user` WHERE `id` = '1' LIMIT 1 [ RunTime:0.008159s ]
SELECT * FROM `wzx_user` WHERE `id` = '1' LIMIT 1 [ RunTime:0.011574s ]
SELECT * FROM `wzx_user` WHERE `id` = '1' LIMIT 1 [ RunTime:0.008502s ]
SELECT * FROM `wzx_user` WHERE `id` = '1' LIMIT 1 [ RunTime:0.008134s ]
SELECT * FROM `wzx_user` WHERE `id` = '1' LIMIT 1 [ RunTime:0.008082s ]
SELECT * FROM `wzx_user` WHERE `id` = '1' LIMIT 1 [ RunTime:0.008049s ]
SELECT post_id,max(category_id),post_title,post_excerpt FROM `wzx_portal_post` `post` INNER JOIN `wzx_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`.`post_status` = '1' AND `post`.`post_type` = '1' AND `post`.`delete_time` = '0' AND `post`.`id` NOT IN ('264','263','257','255','162','157','154','150','100','99') AND ( ( find_in_set('Mysql',post.post_keywords) ) OR ( find_in_set('索引',post.post_keywords) ) OR ( find_in_set('MySQL',post.post_keywords) ) OR ( find_in_set('sql',post.post_keywords) ) ) ) AND ( `post`.`published_time` > '0' AND `post`.`published_time` < '1769942395' ) GROUP BY `post`.`id` ORDER BY `post`.`post_hits` ASC LIMIT 15 [ RunTime:0.013112s ]
SHOW FULL COLUMNS FROM `wzx_link` [ RunTime:0.008405s ]
SELECT * FROM `wzx_link` WHERE `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.008020s ]

MySQL索引简介

MySQL实现570k/s写入

MySQL语句加锁分析

MySQL分库分表原理简述

MySQL索引介绍

如何写出高性能SQL语句

SQL 的各种 join 到底是怎么回事

MySQL 规范指南

Mysql联合索引的最左前缀匹配原则

MySQL中的行级锁,表级锁,页级锁

Relevant