&

基本文件流程錯誤 SQL 調試

/home/www/zzx/public/index.php ( 0.86 KB )
/home/www/zzx/vendor/autoload.php ( 0.75 KB )
/home/www/zzx/vendor/composer/autoload_real.php ( 1.63 KB )
/home/www/zzx/vendor/composer/platform_check.php ( 0.90 KB )
/home/www/zzx/vendor/composer/ClassLoader.php ( 16.14 KB )
/home/www/zzx/vendor/composer/autoload_static.php ( 5.51 KB )
/home/www/zzx/vendor/topthink/think-helper/src/helper.php ( 8.34 KB )
/home/www/zzx/vendor/topthink/think-orm/stubs/load_stubs.php ( 0.16 KB )
/home/www/zzx/vendor/topthink/framework/src/think/Exception.php ( 1.69 KB )
/home/www/zzx/vendor/topthink/framework/src/think/Facade.php ( 2.71 KB )
/home/www/zzx/vendor/symfony/polyfill-mbstring/bootstrap.php ( 8.26 KB )
/home/www/zzx/vendor/symfony/polyfill-php80/bootstrap.php ( 1.50 KB )
/home/www/zzx/vendor/symfony/var-dumper/Resources/functions/dump.php ( 0.79 KB )
/home/www/zzx/vendor/topthink/framework/src/think/App.php ( 14.17 KB )
/home/www/zzx/vendor/topthink/framework/src/think/Container.php ( 15.38 KB )
/home/www/zzx/vendor/psr/container/src/ContainerInterface.php ( 1.02 KB )
/home/www/zzx/app/provider.php ( 0.19 KB )
/home/www/zzx/vendor/topthink/framework/src/think/Http.php ( 6.12 KB )
/home/www/zzx/vendor/topthink/think-helper/src/helper/Str.php ( 7.29 KB )
/home/www/zzx/vendor/topthink/framework/src/think/Env.php ( 4.64 KB )
/home/www/zzx/app/common.php ( 0.45 KB )
/home/www/zzx/vendor/topthink/framework/src/helper.php ( 18.44 KB )
/home/www/zzx/vendor/topthink/framework/src/think/Config.php ( 5.03 KB )
/home/www/zzx/config/app.php ( 1.24 KB )
/home/www/zzx/vendor/topthink/framework/src/think/facade/Env.php ( 1.67 KB )
/home/www/zzx/config/cache.php ( 0.80 KB )
/home/www/zzx/config/console.php ( 0.23 KB )
/home/www/zzx/config/cookie.php ( 0.56 KB )
/home/www/zzx/config/database.php ( 2.22 KB )
/home/www/zzx/config/filesystem.php ( 0.63 KB )
/home/www/zzx/config/lang.php ( 0.81 KB )
/home/www/zzx/config/log.php ( 1.37 KB )
/home/www/zzx/config/middleware.php ( 0.19 KB )
/home/www/zzx/config/route.php ( 1.70 KB )
/home/www/zzx/config/session.php ( 0.57 KB )
/home/www/zzx/config/trace.php ( 0.34 KB )
/home/www/zzx/config/view.php ( 0.88 KB )
/home/www/zzx/app/event.php ( 0.25 KB )
/home/www/zzx/vendor/topthink/framework/src/think/Event.php ( 6.96 KB )
/home/www/zzx/app/service.php ( 0.13 KB )
/home/www/zzx/app/AppService.php ( 0.26 KB )
/home/www/zzx/vendor/topthink/framework/src/think/Service.php ( 1.67 KB )
/home/www/zzx/vendor/topthink/framework/src/think/Lang.php ( 7.60 KB )
/home/www/zzx/vendor/topthink/framework/src/lang/zh-cn.php ( 12.88 KB )
/home/www/zzx/vendor/topthink/framework/src/think/initializer/Error.php ( 3.27 KB )
/home/www/zzx/vendor/topthink/framework/src/think/initializer/RegisterService.php ( 1.33 KB )
/home/www/zzx/vendor/services.php ( 0.17 KB )
/home/www/zzx/vendor/topthink/framework/src/think/service/PaginatorService.php ( 1.52 KB )
/home/www/zzx/vendor/topthink/framework/src/think/service/ValidateService.php ( 0.99 KB )
/home/www/zzx/vendor/topthink/framework/src/think/service/ModelService.php ( 1.76 KB )
/home/www/zzx/vendor/topthink/think-multi-app/src/Service.php ( 1.08 KB )
/home/www/zzx/vendor/topthink/think-trace/src/Service.php ( 0.77 KB )
/home/www/zzx/vendor/topthink/framework/src/think/Middleware.php ( 6.78 KB )
/home/www/zzx/vendor/topthink/framework/src/think/initializer/BootService.php ( 0.77 KB )
/home/www/zzx/vendor/topthink/think-orm/src/Paginator.php ( 11.80 KB )
/home/www/zzx/vendor/topthink/framework/src/think/Validate.php ( 46.10 KB )
/home/www/zzx/vendor/topthink/think-orm/src/Model.php ( 25.67 KB )
/home/www/zzx/vendor/topthink/think-orm/src/model/concern/Attribute.php ( 17.61 KB )
/home/www/zzx/vendor/topthink/think-orm/src/model/concern/RelationShip.php ( 26.12 KB )
/home/www/zzx/vendor/topthink/think-orm/src/model/concern/ModelEvent.php ( 2.27 KB )
/home/www/zzx/vendor/topthink/think-orm/src/model/concern/TimeStamp.php ( 5.70 KB )
/home/www/zzx/vendor/topthink/think-orm/src/model/concern/Conversion.php ( 10.41 KB )
/home/www/zzx/vendor/topthink/think-helper/src/contract/Arrayable.php ( 0.09 KB )
/home/www/zzx/vendor/topthink/think-helper/src/contract/Jsonable.php ( 0.13 KB )
/home/www/zzx/vendor/topthink/framework/src/think/Db.php ( 2.87 KB )
/home/www/zzx/vendor/topthink/think-orm/src/DbManager.php ( 8.28 KB )
/home/www/zzx/vendor/topthink/framework/src/think/Log.php ( 8.50 KB )
/home/www/zzx/vendor/topthink/framework/src/think/Manager.php ( 3.98 KB )
/home/www/zzx/vendor/psr/log/Psr/Log/LoggerInterface.php ( 3.04 KB )
/home/www/zzx/vendor/topthink/framework/src/think/Cache.php ( 4.79 KB )
/home/www/zzx/vendor/psr/simple-cache/src/CacheInterface.php ( 4.50 KB )
/home/www/zzx/vendor/topthink/think-helper/src/helper/Arr.php ( 16.08 KB )
/home/www/zzx/vendor/topthink/framework/src/think/cache/driver/File.php ( 7.42 KB )
/home/www/zzx/vendor/topthink/framework/src/think/cache/Driver.php ( 8.06 KB )
/home/www/zzx/vendor/topthink/framework/src/think/contract/CacheHandlerInterface.php ( 2.25 KB )
/home/www/zzx/vendor/topthink/framework/src/think/Console.php ( 22.65 KB )
/home/www/zzx/app/Request.php ( 0.09 KB )
/home/www/zzx/vendor/topthink/framework/src/think/Request.php ( 54.04 KB )
/home/www/zzx/app/middleware.php ( 0.30 KB )
/home/www/zzx/vendor/topthink/framework/src/think/Pipeline.php ( 2.61 KB )
/home/www/zzx/vendor/topthink/think-trace/src/TraceDebug.php ( 2.94 KB )
/home/www/zzx/vendor/topthink/framework/src/think/middleware/SessionInit.php ( 2.06 KB )
/home/www/zzx/vendor/topthink/framework/src/think/Session.php ( 1.80 KB )
/home/www/zzx/vendor/topthink/framework/src/think/session/driver/File.php ( 6.28 KB )
/home/www/zzx/vendor/topthink/framework/src/think/contract/SessionHandlerInterface.php ( 0.87 KB )
/home/www/zzx/vendor/topthink/framework/src/think/session/Store.php ( 7.26 KB )
/home/www/zzx/vendor/topthink/think-multi-app/src/MultiApp.php ( 7.06 KB )
/home/www/zzx/app/home/common.php ( 0.05 KB )
/home/www/zzx/app/home/event.php ( 0.07 KB )
/home/www/zzx/app/home/middleware.php ( 0.07 KB )
/home/www/zzx/vendor/topthink/framework/src/think/Route.php ( 23.96 KB )
/home/www/zzx/vendor/topthink/framework/src/think/route/RuleName.php ( 5.33 KB )
/home/www/zzx/vendor/topthink/framework/src/think/route/Domain.php ( 5.55 KB )
/home/www/zzx/vendor/topthink/framework/src/think/route/RuleGroup.php ( 13.61 KB )
/home/www/zzx/vendor/topthink/framework/src/think/route/Rule.php ( 22.85 KB )
/home/www/zzx/vendor/topthink/framework/src/think/route/RuleItem.php ( 8.81 KB )
/home/www/zzx/vendor/topthink/framework/src/think/route/dispatch/Url.php ( 3.42 KB )
/home/www/zzx/vendor/topthink/framework/src/think/route/dispatch/Controller.php ( 6.61 KB )
/home/www/zzx/vendor/topthink/framework/src/think/route/Dispatch.php ( 6.49 KB )
/home/www/zzx/app/middleware/AuthMiddleware.php ( 0.82 KB )
/home/www/zzx/app/home/controller/Course.php ( 3.21 KB )
/home/www/zzx/app/BaseController.php ( 4.06 KB )
/home/www/zzx/app/admin/model/SystemModel.php ( 0.24 KB )
/home/www/zzx/app/BaseModel.php ( 1.02 KB )
/home/www/zzx/vendor/topthink/think-orm/src/db/connector/Mysql.php ( 4.39 KB )
/home/www/zzx/vendor/topthink/think-orm/src/db/PDOConnection.php ( 52.45 KB )
/home/www/zzx/vendor/topthink/think-orm/src/db/Connection.php ( 7.67 KB )
/home/www/zzx/vendor/topthink/think-orm/src/db/ConnectionInterface.php ( 4.56 KB )
/home/www/zzx/vendor/topthink/think-orm/src/db/builder/Mysql.php ( 15.93 KB )
/home/www/zzx/vendor/topthink/think-orm/src/db/Builder.php ( 41.58 KB )
/home/www/zzx/vendor/topthink/think-orm/src/db/Query.php ( 10.64 KB )
/home/www/zzx/vendor/topthink/think-orm/src/db/BaseQuery.php ( 36.47 KB )
/home/www/zzx/vendor/topthink/think-orm/src/db/concern/TimeFieldQuery.php ( 7.50 KB )
/home/www/zzx/vendor/topthink/think-orm/src/db/concern/AggregateQuery.php ( 3.26 KB )
/home/www/zzx/vendor/topthink/think-orm/src/db/concern/ModelRelationQuery.php ( 16.06 KB )
/home/www/zzx/vendor/topthink/think-orm/src/db/concern/ResultOperation.php ( 6.29 KB )
/home/www/zzx/vendor/topthink/think-orm/src/db/concern/Transaction.php ( 2.85 KB )
/home/www/zzx/vendor/topthink/think-orm/src/db/concern/WhereQuery.php ( 16.22 KB )
/home/www/zzx/vendor/topthink/think-orm/src/db/concern/JoinAndViewQuery.php ( 6.86 KB )
/home/www/zzx/vendor/topthink/think-orm/src/db/concern/ParamsBind.php ( 3.36 KB )
/home/www/zzx/vendor/topthink/think-orm/src/db/concern/TableFieldInfo.php ( 2.51 KB )
/home/www/zzx/vendor/topthink/framework/src/think/log/driver/File.php ( 6.17 KB )
/home/www/zzx/vendor/topthink/framework/src/think/contract/LogHandlerInterface.php ( 0.86 KB )
/home/www/zzx/vendor/topthink/framework/src/think/log/Channel.php ( 6.54 KB )
/home/www/zzx/vendor/topthink/framework/src/think/event/LogRecord.php ( 0.86 KB )
/home/www/zzx/vendor/topthink/framework/src/think/facade/View.php ( 1.71 KB )
/home/www/zzx/vendor/topthink/framework/src/think/View.php ( 4.41 KB )
/home/www/zzx/app/admin/model/CourseModel.php ( 4.85 KB )
/home/www/zzx/app/admin/model/CatelModel.php ( 1.46 KB )
/home/www/zzx/app/admin/model/SchoolModel.php ( 5.57 KB )
/home/www/zzx/app/Status.php ( 0.25 KB )
/home/www/zzx/vendor/topthink/think-orm/src/model/Collection.php ( 6.78 KB )
/home/www/zzx/vendor/topthink/think-helper/src/Collection.php ( 16.48 KB )
/home/www/zzx/vendor/topthink/think-orm/src/facade/Db.php ( 0.94 KB )
/home/www/zzx/vendor/topthink/think-orm/src/db/Raw.php ( 1.39 KB )
/home/www/zzx/vendor/topthink/think-orm/src/db/Fetch.php ( 12.82 KB )
/home/www/zzx/vendor/topthink/think-orm/src/paginator/driver/Bootstrap.php ( 5.41 KB )
/home/www/zzx/vendor/topthink/think-view/src/Think.php ( 8.42 KB )
/home/www/zzx/vendor/topthink/think-template/src/Template.php ( 47.01 KB )
/home/www/zzx/vendor/topthink/think-template/src/template/driver/File.php ( 2.33 KB )
/home/www/zzx/runtime/home/temp/a1778c969f27fd642a91a4003994acbe.php ( 18.73 KB )
/home/www/zzx/vendor/topthink/framework/src/think/facade/Route.php ( 4.88 KB )
/home/www/zzx/vendor/topthink/think-multi-app/src/Url.php ( 7.52 KB )
/home/www/zzx/vendor/topthink/framework/src/think/route/Url.php ( 14.66 KB )
/home/www/zzx/vendor/topthink/framework/src/think/Response.php ( 8.60 KB )
/home/www/zzx/vendor/topthink/framework/src/think/response/Html.php ( 0.98 KB )
/home/www/zzx/vendor/topthink/framework/src/think/Cookie.php ( 6.28 KB )
/home/www/zzx/vendor/topthink/think-trace/src/Html.php ( 4.49 KB )

CONNECT:[ UseTime:0.000424s ] mysql:host=127.0.0.1;port=3306;dbname=zhixue;charset=utf8
SHOW FULL COLUMNS FROM `zx_system` [ RunTime:0.000615s ]
SELECT * FROM `zx_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000348s ]
SHOW FULL COLUMNS FROM `zx_course` [ RunTime:0.000474s ]
SHOW FULL COLUMNS FROM `zx_cate` [ RunTime:0.000438s ]
SHOW FULL COLUMNS FROM `zx_school` [ RunTime:0.000446s ]
SELECT * FROM `zx_cate` WHERE `status` = 1 AND `pid` = 52 [ RunTime:0.000342s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `zx_course` `a` LEFT JOIN ( SELECT a.id, GROUP_CONCAT(DISTINCT b.title ORDER BY b.id) AS cate_names FROM `zx_course` `a` INNER JOIN `zx_cate` `b` ON FIND_IN_SET(b.id, a.cate_id) LEFT JOIN `zx_school` `c` ON `a`.`school_id`=`c`.`id` GROUP BY `a`.`id` ) `cate_subquery` ON `a`.`id`=`cate_subquery`.`id` LEFT JOIN ( SELECT a.id, GROUP_CONCAT(DISTINCT c.title ORDER BY c.id) AS tag_names FROM `zx_course` `a` INNER JOIN `zx_tag` `c` ON FIND_IN_SET(c.id, a.tag_id) GROUP BY `a`.`id` ) `tag_subquery` ON `a`.`id`=`tag_subquery`.`id` LEFT JOIN `zx_school` `c` ON `a`.`school_id`=`c`.`id` WHERE `cate_subquery`.`id` IN ('53','54','55','56','57','58','59','60','61','62','63') AND `a`.`status` = '1' AND `c`.`status` = '1' GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.002818s ]
SELECT `a`.`id`,`a`.`title`,`a`.`create_time`,`a`.`school_id`,c.title as school_title,`cate_subquery`.`cate_names`,`tag_subquery`.`tag_names` FROM `zx_course` `a` LEFT JOIN ( SELECT a.id, GROUP_CONCAT(DISTINCT b.title ORDER BY b.id) AS cate_names FROM `zx_course` `a` INNER JOIN `zx_cate` `b` ON FIND_IN_SET(b.id, a.cate_id) LEFT JOIN `zx_school` `c` ON `a`.`school_id`=`c`.`id` GROUP BY `a`.`id` ) `cate_subquery` ON `a`.`id`=`cate_subquery`.`id` LEFT JOIN ( SELECT a.id, GROUP_CONCAT(DISTINCT c.title ORDER BY c.id) AS tag_names FROM `zx_course` `a` INNER JOIN `zx_tag` `c` ON FIND_IN_SET(c.id, a.tag_id) GROUP BY `a`.`id` ) `tag_subquery` ON `a`.`id`=`tag_subquery`.`id` LEFT JOIN `zx_school` `c` ON `a`.`school_id`=`c`.`id` WHERE `cate_subquery`.`id` IN ('53','54','55','56','57','58','59','60','61','62','63') AND `a`.`status` = '1' AND `c`.`status` = '1' GROUP BY `a`.`id` ORDER BY CASE WHEN a.sort = 0 THEN 1 ELSE 0 END,`a`.`sort` ASC,`a`.`create_time` DESC LIMIT 0,30 [ RunTime:0.003016s ]
SELECT * FROM `zx_cate` WHERE `status` = 1 ORDER BY CASE WHEN sort = 0 THEN 1 ELSE 0 END,`sort` ASC,`create_time` DESC [ RunTime:0.000575s ]
SELECT * FROM `zx_school` WHERE `status` = 1 ORDER BY rand() LIMIT 12 [ RunTime:0.000848s ]
SELECT * FROM `zx_school` WHERE `status` = 1 ORDER BY rand() LIMIT 12 [ RunTime:0.000738s ]
SELECT `a`.* FROM `zx_course` `a` LEFT JOIN `zx_school` `b` ON `a`.`school_id`=`b`.`id` WHERE `a`.`status` = '1' AND `b`.`status` = '1' ORDER BY rand() LIMIT 12 [ RunTime:0.001060s ]
SELECT * FROM `zx_cate` WHERE `status` = 1 AND `pid` = 52 [ RunTime:0.000343s ]
SELECT * FROM `zx_cate` WHERE `status` <> -1 AND `id` = 52 LIMIT 1 [ RunTime:0.000275s ]

名校課程

學校推薦

名校展示

最新招考