OneBase开源架构|PHP开源系统

基本文件流程错误 SQL 调试

/www/wwwroot/demo.ichen.cc/public/index.php ( 0.79 KB )
/www/wwwroot/demo.ichen.cc/public/public.php ( 1.08 KB )
/www/wwwroot/demo.ichen.cc/thinkphp/start.php ( 0.73 KB )
/www/wwwroot/demo.ichen.cc/thinkphp/base.php ( 2.66 KB )
/www/wwwroot/demo.ichen.cc/thinkphp/library/think/Loader.php ( 19.47 KB )
/www/wwwroot/demo.ichen.cc/vendor/composer/autoload_namespaces.php ( 0.21 KB )
/www/wwwroot/demo.ichen.cc/vendor/composer/autoload_psr4.php ( 0.84 KB )
/www/wwwroot/demo.ichen.cc/vendor/composer/autoload_classmap.php ( 0.14 KB )
/www/wwwroot/demo.ichen.cc/vendor/composer/autoload_files.php ( 0.42 KB )
/www/wwwroot/demo.ichen.cc/vendor/qiniu/php-sdk/src/Qiniu/functions.php ( 7.10 KB )
/www/wwwroot/demo.ichen.cc/vendor/qiniu/php-sdk/src/Qiniu/Config.php ( 0.70 KB )
/www/wwwroot/demo.ichen.cc/vendor/topthink/think-captcha/src/helper.php ( 1.59 KB )
/www/wwwroot/demo.ichen.cc/thinkphp/library/think/Route.php ( 59.82 KB )
/www/wwwroot/demo.ichen.cc/thinkphp/library/think/Config.php ( 6.03 KB )
/www/wwwroot/demo.ichen.cc/thinkphp/library/think/Validate.php ( 40.27 KB )
/www/wwwroot/demo.ichen.cc/vendor/topthink/think-queue/src/config.php ( 0.77 KB )
/www/wwwroot/demo.ichen.cc/thinkphp/library/think/Console.php ( 21.22 KB )
/www/wwwroot/demo.ichen.cc/thinkphp/library/think/Error.php ( 3.59 KB )
/www/wwwroot/demo.ichen.cc/thinkphp/convention.php ( 10.31 KB )
/www/wwwroot/demo.ichen.cc/thinkphp/library/think/App.php ( 21.04 KB )
/www/wwwroot/demo.ichen.cc/thinkphp/library/think/Request.php ( 50.94 KB )
/www/wwwroot/demo.ichen.cc/app/config.php ( 11.07 KB )
/www/wwwroot/demo.ichen.cc/app/database.php ( 1.46 KB )
/www/wwwroot/demo.ichen.cc/thinkphp/library/think/Hook.php ( 4.76 KB )
/www/wwwroot/demo.ichen.cc/app/tags.php ( 1.16 KB )
/www/wwwroot/demo.ichen.cc/app/common/behavior/InitBase.php ( 8.25 KB )
/www/wwwroot/demo.ichen.cc/app/common.php ( 16.83 KB )
/www/wwwroot/demo.ichen.cc/thinkphp/library/think/Env.php ( 1.25 KB )
/www/wwwroot/demo.ichen.cc/thinkphp/helper.php ( 17.86 KB )
/www/wwwroot/demo.ichen.cc/app/function.php ( 0.78 KB )
/www/wwwroot/demo.ichen.cc/app/extend.php ( 10.82 KB )
/www/wwwroot/demo.ichen.cc/thinkphp/library/think/Debug.php ( 7.06 KB )
/www/wwwroot/demo.ichen.cc/app/common/model/Config.php ( 0.78 KB )
/www/wwwroot/demo.ichen.cc/app/common/model/ModelBase.php ( 12.18 KB )
/www/wwwroot/demo.ichen.cc/thinkphp/library/think/Model.php ( 66.83 KB )
/www/wwwroot/demo.ichen.cc/thinkphp/library/think/Db.php ( 6.54 KB )
/www/wwwroot/demo.ichen.cc/thinkphp/library/think/Log.php ( 5.84 KB )
/www/wwwroot/demo.ichen.cc/thinkphp/library/think/db/connector/Mysql.php ( 3.94 KB )
/www/wwwroot/demo.ichen.cc/thinkphp/library/think/db/Connection.php ( 29.97 KB )
/www/wwwroot/demo.ichen.cc/thinkphp/library/think/db/Query.php ( 89.54 KB )
/www/wwwroot/demo.ichen.cc/thinkphp/library/think/db/builder/Mysql.php ( 2.16 KB )
/www/wwwroot/demo.ichen.cc/thinkphp/library/think/db/Builder.php ( 30.47 KB )
/www/wwwroot/demo.ichen.cc/thinkphp/library/think/Cache.php ( 6.17 KB )
/www/wwwroot/demo.ichen.cc/thinkphp/library/think/cache/driver/File.php ( 6.98 KB )
/www/wwwroot/demo.ichen.cc/thinkphp/library/think/cache/Driver.php ( 5.52 KB )
/www/wwwroot/demo.ichen.cc/app/common/behavior/InitHook.php ( 1.25 KB )
/www/wwwroot/demo.ichen.cc/app/common/model/Hook.php ( 0.77 KB )
/www/wwwroot/demo.ichen.cc/thinkphp/library/think/Lang.php ( 6.95 KB )
/www/wwwroot/demo.ichen.cc/thinkphp/lang/zh-cn.php ( 3.85 KB )
/www/wwwroot/demo.ichen.cc/app/route.php ( 0.91 KB )
/www/wwwroot/demo.ichen.cc/app/index/config.php ( 0.96 KB )
/www/wwwroot/demo.ichen.cc/app/index/common.php ( 0.68 KB )
/www/wwwroot/demo.ichen.cc/app/index/controller/Index.php ( 1.77 KB )
/www/wwwroot/demo.ichen.cc/app/index/controller/IndexBase.php ( 1.10 KB )
/www/wwwroot/demo.ichen.cc/app/common/controller/ControllerBase.php ( 4.75 KB )
/www/wwwroot/demo.ichen.cc/thinkphp/library/think/Controller.php ( 6.20 KB )
/www/wwwroot/demo.ichen.cc/thinkphp/library/traits/controller/Jump.php ( 4.97 KB )
/www/wwwroot/demo.ichen.cc/thinkphp/library/think/View.php ( 6.86 KB )
/www/wwwroot/demo.ichen.cc/thinkphp/library/think/view/driver/Think.php ( 5.61 KB )
/www/wwwroot/demo.ichen.cc/thinkphp/library/think/Template.php ( 46.46 KB )
/www/wwwroot/demo.ichen.cc/thinkphp/library/think/template/driver/File.php ( 2.24 KB )
/www/wwwroot/demo.ichen.cc/app/common/logic/Article.php ( 5.89 KB )
/www/wwwroot/demo.ichen.cc/app/common/logic/LogicBase.php ( 0.83 KB )
/www/wwwroot/demo.ichen.cc/app/common/model/Article.php ( 0.78 KB )
/www/wwwroot/demo.ichen.cc/thinkphp/library/think/paginator/driver/Bootstrap.php ( 5.43 KB )
/www/wwwroot/demo.ichen.cc/thinkphp/library/think/Paginator.php ( 9.45 KB )
/www/wwwroot/demo.ichen.cc/thinkphp/library/think/Collection.php ( 8.63 KB )
/www/wwwroot/demo.ichen.cc/app/common/logic/File.php ( 8.01 KB )
/www/wwwroot/demo.ichen.cc/app/common/model/Picture.php ( 0.78 KB )
/www/wwwroot/demo.ichen.cc/app/common/model/ArticleCategory.php ( 0.79 KB )
/www/wwwroot/demo.ichen.cc/runtime/temp/e42e81b515a028794848b681c8199c29.php ( 6.44 KB )
/www/wwwroot/demo.ichen.cc/thinkphp/library/think/Url.php ( 12.97 KB )
/www/wwwroot/demo.ichen.cc/thinkphp/library/think/Response.php ( 8.64 KB )
/www/wwwroot/demo.ichen.cc/thinkphp/library/think/debug/Html.php ( 4.27 KB )

[ DB ] CONNECT:[ UseTime:0.000746s ] mysql:dbname=demo_ichen_cc;host=127.0.0.1;port=3306;charset=utf8
[ SQL ] SHOW COLUMNS FROM `ob_config` [ RunTime:0.000995s ]
[ SQL ] SELECT * FROM `ob_config` [ RunTime:0.000490s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_config', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 28, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SHOW COLUMNS FROM `ob_hook` [ RunTime:0.000840s ]
[ SQL ] SELECT `id`,`name`,`addon_list` FROM `ob_hook` [ RunTime:0.000341s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_hook', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 3, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SHOW COLUMNS FROM `ob_article` [ RunTime:0.000940s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ob_article` `a` INNER JOIN `ob_article_category` `c` ON `a`.`category_id`=`c`.`id` LIMIT 1 [ RunTime:0.000531s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'c', 'partitions' => NULL, 'type' => 'index', 'possible_keys' => 'PRIMARY', 'key' => 'uk_name', 'key_len' => '92', 'ref' => NULL, 'rows' => 5, 'filtered' => 100.0, 'extra' => 'Using index', ) ]
[ SQL ] SELECT `a`.*,c.name as category_name FROM `ob_article` `a` INNER JOIN `ob_article_category` `c` ON `a`.`category_id`=`c`.`id` ORDER BY a.create_time desc LIMIT 0,10 [ RunTime:0.000508s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'a', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 14, 'filtered' => 100.0, 'extra' => 'Using filesort', ) ]
[ SQL ] SHOW COLUMNS FROM `ob_picture` [ RunTime:0.000831s ]
[ SQL ] SELECT `path`,`url` FROM `ob_picture` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000418s ]
[ 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 `path`,`url` FROM `ob_picture` WHERE `id` = 244 LIMIT 1 [ RunTime:0.000354s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_picture', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `path`,`url` FROM `ob_picture` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000302s ]
[ 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 `path`,`url` FROM `ob_picture` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000697s ]
[ 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 `path`,`url` FROM `ob_picture` WHERE `id` = 222 LIMIT 1 [ RunTime:0.000403s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_picture', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `path`,`url` FROM `ob_picture` WHERE `id` = 221 LIMIT 1 [ RunTime:0.000360s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_picture', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `path`,`url` FROM `ob_picture` WHERE `id` = 220 LIMIT 1 [ RunTime:0.000367s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_picture', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `path`,`url` FROM `ob_picture` WHERE `id` = 219 LIMIT 1 [ RunTime:0.000374s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_picture', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `path`,`url` FROM `ob_picture` WHERE `id` = 223 LIMIT 1 [ RunTime:0.000416s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_picture', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `path`,`url` FROM `ob_picture` WHERE `id` = 224 LIMIT 1 [ RunTime:0.000366s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_picture', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `path`,`url` FROM `ob_picture` WHERE `id` = 225 LIMIT 1 [ RunTime:0.000370s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_picture', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SHOW COLUMNS FROM `ob_article_category` [ RunTime:0.000766s ]
[ SQL ] SELECT `id`,`name`,`describe`,`create_time`,`update_time`,`status`,`icon` FROM `ob_article_category` WHERE `status` <> -1 ORDER BY create_time asc [ RunTime:0.000466s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_article_category', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 5, 'filtered' => 80.0, 'extra' => 'Using where; Using filesort', ) ]

源自相同起点，演绎不同精彩！

测试

出售一个充电宝

吐槽卖花的

这个只有标题

收纳小盒子带镜子便宜出

阿道夫全新未用300g

欧诗漫OSM洗面奶

护发素496ml

出两个电车9成新

98新轮滑鞋