一，php代码：
| 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 |
public function home(Request $request){
//默认连接
DB::enableQueryLog();
$modelNews = new News();
$rowsNews = $modelNews->getPage(0,1);
$logNews = DB::getQueryLog();
//非默认连接，要指定一下
DB::connection('co_mysql')->enableQueryLog();
$modelComment = new Comment();
$rowsComment = $modelComment->getOneById(3);
$logComment = DB::connection('co_mysql')->getQueryLog();
//返回
$data = [
"news"=>$rowsNews,
"comment"=>$rowsComment,
"logNews"=>$logNews,
"logComment"=>$logComment,
];
return Result::Success($data);
}
|
二，测试效果:
说明：刘宏缔的架构森林—专注it技术的博客，
网站：https://blog.imgtouch.com
原文: https://blog.imgtouch.com/index.php/2023/10/24/laravel-da-yin-sql/
代码: https://github.com/liuhongdi/ 或 https://gitee.com/liuhongdi
说明：作者:刘宏缔 邮箱: [email protected]
三,查看laravel框架的版本:
liuhongdi@lhdpc:/data/laravel/dignews$ php artisan --version
Laravel Framework 10.27.0