mysql优化手册v1.0

错误：
App(Users::class)->leftjoin('users_basic')->limit(20)->get()
正确：
App(Users::class)->with('usersBasic')->limit(20)->get()
Copy

错误：
App(Users::class)
->whereHas('UsersBasic',function($query)use($mobile){
    $query->where('mobile','like','$mobile%')
})
正确：
App(Users::class)
->whereHasIn('UsersBasic',function($query)use($mobile){
    $query->where('mobile','like','$mobile%')
})
App(Users::class)
->whereHasJoin('UsersBasic',function($query)use($mobile){
    $query->yjwhere('mobile','like','$mobile%')
})
Copy

composer require eugenes/laravel-builderCopy

错误
SELECT * FROM t WHERE username LIKE '%陈%'
正确
SELECT * FROM t WHERE username LIKE '陈%'
Copy