laravel 常用的一些例子总结

<?php

    $lockKey = 'lockKey';
    $redis = Illuminate\Support\Facades\Redis::connection();
    $redis->setnx($lockKey, 1);
    $redis->expire($lockKey, 10);
?>

<?php
    $lockKey = 'lockKey';
    $redis = Illuminate\Support\Facades\Redis::connection();
    $lock = $redis->set($lockKey, 1, 'ex', 10,'nx');
?>

//参数一: $key                           缓存键
//参数二: $value                         缓存值
//参数三: $expireResolution              EX/PX
//                                               EX        设置键key的过期时间,单位时秒(seconds)
//                                               PX        设置键key的过期时间,单位时毫秒(milliseconds)              
//   参数四: $expireTTL                     缓存键过期时间,单位由参数三决定
//   参数五: $flag                          NX/XX                               
//                                                NX  只有键key不存在的时候才会设置key的值
//                                                XX  只有键key存在的时候才会设置key的值                            
set($key, $value, $expireResolution = null, $expireTTL = null, $flag = null)

 DB::connection()->enableQueryLog(); // 开启查询日志
 ......
 dd(DB::getQueryLog());

 composer require guanguans/laravel-dump-sql -v
 php artisan vendor:publish --provider="Guanguans\\LaravelDumpSql\\ServiceProvider"

 // Get sql statement.
User::where('id', 1)->toRawSql();
DB::table('user')->where('id', 1)->toRawSql();

// Print SQL statements.
User::where('id', 1)->dumpSql();
DB::table('user')->where('id', 1)->dumpSql();

// Print SQL statements and exit.
User::where('id', 1)->ddSql();
DB::table('user')->where('id', 1)->ddSql();

php artisan vendor:publish --tag="laravel-dump-sql"

return [
    /*
     * Get sql statement.
     */
    'to_raw_sql' => 'Your favorite method name',

    /*
     * Print SQL statements.
     */
    'dump_sql' => 'Your favorite method name',

    /*
     * Print SQL statements and exit.
     */
    'dd_sql' => 'Your favorite method name',
];