IT界-青草根,青草根博客,程序员技术博客,it技术交流-IT界青草根

测试一个系统

Response基类提供了data方法用于设置响应数据。response()->data($data);json()->data($data); 不过需要注意的是data方法设置的只是原...

2019-11-04 09:30:04

基本文件流程错误 SQL 调试

/data/www/cmmblog/public/index.php ( 0.96 KB )
/data/www/cmmblog/thinkphp/start.php ( 0.74 KB )
/data/www/cmmblog/thinkphp/base.php ( 2.66 KB )
/data/www/cmmblog/thinkphp/library/think/Loader.php ( 21.73 KB )
/data/www/cmmblog/vendor/composer/autoload_static.php ( 53.69 KB )
/data/www/cmmblog/vendor/symfony/polyfill-mbstring/bootstrap.php ( 4.01 KB )
/data/www/cmmblog/vendor/topthink/think-captcha/src/helper.php ( 1.66 KB )
/data/www/cmmblog/thinkphp/library/think/Route.php ( 61.83 KB )
/data/www/cmmblog/thinkphp/library/think/Config.php ( 6.58 KB )
/data/www/cmmblog/thinkphp/library/think/Validate.php ( 42.96 KB )
/data/www/cmmblog/vendor/topthink/think-migration/src/config.php ( 0.79 KB )
/data/www/cmmblog/thinkphp/library/think/Console.php ( 23.98 KB )
/data/www/cmmblog/vendor/topthink/think-queue/src/config.php ( 0.78 KB )
/data/www/cmmblog/vendor/topthink/think-testing/src/config.php ( 0.67 KB )
/data/www/cmmblog/thinkphp/library/think/Error.php ( 3.88 KB )
/data/www/cmmblog/thinkphp/convention.php ( 10.66 KB )
/data/www/cmmblog/thinkphp/library/think/App.php ( 22.17 KB )
/data/www/cmmblog/thinkphp/library/think/Request.php ( 51.43 KB )
/data/www/cmmblog/app/config.php ( 14.37 KB )
/data/www/cmmblog/app/database.php ( 2.20 KB )
/data/www/cmmblog/thinkphp/library/think/Hook.php ( 4.86 KB )
/data/www/cmmblog/app/tags.php ( 0.99 KB )
/data/www/cmmblog/app/common.php ( 27.06 KB )
/data/www/cmmblog/thinkphp/library/think/Env.php ( 1.25 KB )
/data/www/cmmblog/thinkphp/helper.php ( 17.87 KB )
/data/www/cmmblog/thinkphp/library/think/Lang.php ( 7.49 KB )
/data/www/cmmblog/thinkphp/library/think/Log.php ( 6.28 KB )
/data/www/cmmblog/thinkphp/lang/zh-cn.php ( 11.94 KB )
/data/www/cmmblog/app/route.php ( 4.15 KB )
/data/www/cmmblog/app/index/controller/Search.php ( 0.75 KB )
/data/www/cmmblog/app/index/controller/Base.php ( 1.00 KB )
/data/www/cmmblog/thinkphp/library/think/Controller.php ( 6.29 KB )
/data/www/cmmblog/thinkphp/library/traits/controller/Jump.php ( 5.06 KB )
/data/www/cmmblog/thinkphp/library/think/View.php ( 7.01 KB )
/data/www/cmmblog/thinkphp/library/think/view/driver/Think.php ( 5.80 KB )
/data/www/cmmblog/thinkphp/library/think/Template.php ( 46.02 KB )
/data/www/cmmblog/thinkphp/library/think/template/driver/File.php ( 2.31 KB )
/data/www/cmmblog/app/index/service/ArticleService.php ( 5.95 KB )
/data/www/cmmblog/app/index/service/Common.php ( 0.31 KB )
/data/www/cmmblog/app/common/model/ArticleModel.php ( 12.97 KB )
/data/www/cmmblog/thinkphp/library/think/Model.php ( 71.44 KB )
/data/www/cmmblog/thinkphp/library/think/Db.php ( 6.85 KB )
/data/www/cmmblog/thinkphp/library/think/db/connector/Mysql.php ( 4.02 KB )
/data/www/cmmblog/thinkphp/library/think/db/Connection.php ( 31.00 KB )
/data/www/cmmblog/thinkphp/library/think/db/Query.php ( 96.72 KB )
/data/www/cmmblog/thinkphp/library/think/db/builder/Mysql.php ( 4.66 KB )
/data/www/cmmblog/thinkphp/library/think/db/Builder.php ( 32.43 KB )
/data/www/cmmblog/app/common/model/ArticleCateModel.php ( 8.31 KB )
/data/www/cmmblog/thinkphp/library/think/Debug.php ( 7.37 KB )
/data/www/cmmblog/thinkphp/library/think/Collection.php ( 11.36 KB )
/data/www/cmmblog/thinkphp/library/think/db/Expression.php ( 1.16 KB )
/data/www/cmmblog/thinkphp/library/think/paginator/driver/Bootstrap.php ( 5.43 KB )
/data/www/cmmblog/thinkphp/library/think/Paginator.php ( 10.14 KB )
/data/www/cmmblog/thinkphp/library/think/Response.php ( 8.61 KB )
/data/www/cmmblog/thinkphp/library/think/response/View.php ( 2.52 KB )
/data/www/cmmblog/runtime/temp/6b1259ad381ea8fc370a8728a7eb7f7f.php ( 23.71 KB )
/data/www/cmmblog/thinkphp/library/think/debug/Html.php ( 4.28 KB )
/data/www/cmmblog/thinkphp/library/think/Cache.php ( 6.34 KB )

[ DB ] CONNECT:[ UseTime:0.000589s ] mysql:host=127.0.0.1;port=3306;dbname=52qcgblog;charset=utf8
[ SQL ] SHOW COLUMNS FROM `think_article_cate` [ RunTime:0.001540s ]
[ SQL ] SELECT * FROM `think_article_cate` WHERE `status` = 1 [ RunTime:0.000385s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'think_article_cate', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 15, 'filtered' => 10.0, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `think_article_cate` [ RunTime:0.000279s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'think_article_cate', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 15, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SHOW COLUMNS FROM `think_article` [ RunTime:0.001312s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `think_article` `r` INNER JOIN `think_article_cate` `rc` ON `r`.`cate_id`=`rc`.`id` WHERE `r`.`cate_id` IN ('1','7','8','9','2','10','11','3','12','13','14','4','5','6','15','0') AND `r`.`status` = 1 LIMIT 1 [ RunTime:0.000419s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'r', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 12, 'filtered' => 8.3333339691162109, 'extra' => 'Using where', ) ]
[ SQL ] SELECT r.id,r.title,r.cate_id,r.photo,r.remark,r.keyword,r.content,r.views,r.type,r.is_tui,r.from,r.writer,r.ip,r.create_time,r.update_time,r.status,rc.name,r.music,r.is_pub,r.is_hot,r.is_img,r.pub_time,DATE_FORMAT(pub_time,'%Y') as for_year,DATE_FORMAT(pub_time,'%m') as for_month,DATE_FORMAT(pub_time,'%d') as for_day,tags,r.ora_content FROM `think_article` `r` INNER JOIN `think_article_cate` `rc` ON `r`.`cate_id`=`rc`.`id` WHERE `r`.`cate_id` IN ('1','7','8','9','2','10','11','3','12','13','14','4','5','6','15','0') AND `r`.`status` = 1 ORDER BY `views` DESC LIMIT 0,10 [ RunTime:0.000905s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'r', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 12, 'filtered' => 8.3333339691162109, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `think_article_cate` [ RunTime:0.000288s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'think_article_cate', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 15, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `think_article` `r` INNER JOIN `think_article_cate` `rc` ON `r`.`cate_id`=`rc`.`id` WHERE `r`.`status` = 1 AND `r`.`is_tui` = 1 AND `r`.`cate_id` IN ('1','7','8','9','2','10','11','3','12','13','14','4','5','6','15','0') LIMIT 1 [ RunTime:0.000354s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'r', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 12, 'filtered' => 8.3333339691162109, 'extra' => 'Using where', ) ]
[ SQL ] SELECT r.id,r.title,r.cate_id,r.photo,r.remark,r.keyword,r.content,r.views,r.type,r.is_tui,r.from,r.writer,r.ip,r.create_time,r.update_time,r.status,rc.name,r.music,r.is_pub,r.is_hot,r.is_img,r.pub_time,DATE_FORMAT(pub_time,'%Y') as for_year,DATE_FORMAT(pub_time,'%m') as for_month,DATE_FORMAT(pub_time,'%d') as for_day,tags,r.ora_content FROM `think_article` `r` INNER JOIN `think_article_cate` `rc` ON `r`.`cate_id`=`rc`.`id` WHERE `r`.`status` = 1 AND `r`.`is_tui` = 1 AND `r`.`cate_id` IN ('1','7','8','9','2','10','11','3','12','13','14','4','5','6','15','0') ORDER BY `pub_time` DESC LIMIT 0,10 [ RunTime:0.000868s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'r', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 12, 'filtered' => 8.3333339691162109, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `think_article_cate` [ RunTime:0.000294s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'think_article_cate', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 15, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `think_article` `r` INNER JOIN `think_article_cate` `rc` ON `r`.`cate_id`=`rc`.`id` WHERE `r`.`status` = 1 AND `r`.`cate_id` IN ('1','7','8','9','2','10','11','3','12','13','14','4','5','6','15','0') LIMIT 1 [ RunTime:0.000367s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'r', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 12, 'filtered' => 8.3333339691162109, 'extra' => 'Using where', ) ]
[ SQL ] SELECT r.id,r.title,r.cate_id,r.photo,r.remark,r.keyword,r.content,r.views,r.type,r.is_tui,r.from,r.writer,r.ip,r.create_time,r.update_time,r.status,rc.name,r.music,r.is_pub,r.is_hot,r.is_img,r.pub_time,DATE_FORMAT(pub_time,'%Y') as for_year,DATE_FORMAT(pub_time,'%m') as for_month,DATE_FORMAT(pub_time,'%d') as for_day,tags,r.ora_content FROM `think_article` `r` INNER JOIN `think_article_cate` `rc` ON `r`.`cate_id`=`rc`.`id` WHERE `r`.`status` = 1 AND `r`.`cate_id` IN ('1','7','8','9','2','10','11','3','12','13','14','4','5','6','15','0') ORDER BY `pub_time` DESC LIMIT 0,10 [ RunTime:0.000832s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'r', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 12, 'filtered' => 8.3333339691162109, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SHOW COLUMNS FROM `think_article_tag` [ RunTime:0.001066s ]
[ SQL ] SELECT tag,count(*) number FROM `think_article_tag` GROUP BY `tag` ORDER BY `number` DESC LIMIT 15 [ RunTime:0.000322s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'think_article_tag', 'partitions' => NULL, 'type' => 'index', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '96', 'ref' => NULL, 'rows' => 13, 'filtered' => 100.0, 'extra' => 'Using index; Using temporary; Using filesort', ) ]
[ SQL ] SELECT * FROM `think_article_cate` [ RunTime:0.000265s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'think_article_cate', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 15, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `think_article` `r` INNER JOIN `think_article_cate` `rc` ON `r`.`cate_id`=`rc`.`id` WHERE `r`.`status` = 1 AND `r`.`is_img` = 1 AND `r`.`cate_id` IN ('1','7','8','9','2','10','11','3','12','13','14','4','5','6','15','0') LIMIT 1 [ RunTime:0.000351s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'r', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 12, 'filtered' => 8.3333339691162109, 'extra' => 'Using where', ) ]
[ SQL ] SELECT r.id,r.title,r.cate_id,r.photo,r.remark,r.keyword,r.content,r.views,r.type,r.is_tui,r.from,r.writer,r.ip,r.create_time,r.update_time,r.status,rc.name,r.music,r.is_pub,r.is_hot,r.is_img,r.pub_time,DATE_FORMAT(pub_time,'%Y') as for_year,DATE_FORMAT(pub_time,'%m') as for_month,DATE_FORMAT(pub_time,'%d') as for_day,tags,r.ora_content FROM `think_article` `r` INNER JOIN `think_article_cate` `rc` ON `r`.`cate_id`=`rc`.`id` WHERE `r`.`status` = 1 AND `r`.`is_img` = 1 AND `r`.`cate_id` IN ('1','7','8','9','2','10','11','3','12','13','14','4','5','6','15','0') ORDER BY `pub_time` DESC LIMIT 0,10 [ RunTime:0.000806s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'r', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 12, 'filtered' => 8.3333339691162109, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `id`,`pid`,`name`,`type` FROM `think_article_cate` [ RunTime:0.000255s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'think_article_cate', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 15, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT `id`,`pid`,`name`,`type` FROM `think_article_cate` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000252s ]
[ 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 `article_id` FROM `think_article_tag` WHERE `tag` = '你好' [ RunTime:0.000251s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'think_article_tag', 'partitions' => NULL, 'type' => 'index', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '96', 'ref' => NULL, 'rows' => 13, 'filtered' => 10.0, 'extra' => 'Using where; Using index', ) ]
[ SQL ] SELECT * FROM `think_article` WHERE `id` IN (120) AND `status` = 1 AND `is_pub` = 1 ORDER BY `pub_time` DESC [ RunTime:0.000350s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'think_article', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]

0.047541s

测试一个系统

最新文章

Tags

热门文章

图片文章

关于博主

订阅消息

关注我

联系我