Да и вообще как реализовать Multi connection для db (не в env же всё прописывать).
([a-z])\/\1[^\/]+
Route::any('/genres/{literaGenre}', function ($literaAndGenre) {
dump('Got it', explode('/', $literaAndGenre));
})->where(['literaGenre' => '(?P<litera>[a-z]{1})\/(?P=litera)[^\/]+']);
echo SomeModel::setConnection('')->count();
protected $connection = '';
$fleets = DB::table('fleets') // записи кроме $arr
->join('fleet_dictionaries', 'fleet_dictionaries.id', '=', 'fleets.fleet_id')
->select('fleets.fleet_id','fleet_dictionaries.manufacture','fleet_dictionaries.description', DB::RAW('IF(ISNULL(fleets_with_dopusk.fleet_id), "есть допуск", "нет допуска")'))
->leftJoinSub(function($query) use($id){
return $query->from('fleet_users')
->join('fleet_dictionaries', 'fleet_dictionaries.id', '=', 'fleet_users.fleet_id')
->select('fleet_users.fleet_id')
->where('fleet_users.user_id', $id);
}, 'fleets_with_dopusk', 'fleets_with_dopusk.fleet_id', '=', 'fleet_users.fleet_id')
->where('fleets.airline_id', $idport)
->distinct('fleets.fleet_id')
->get();
$fleets = DB::table('fleets') // записи кроме $arr
->join('fleet_dictionaries', 'fleet_dictionaries.id', '=', 'fleets.fleet_id')
->select('fleets.fleet_id','fleet_dictionaries.manufacture','fleet_dictionaries.description')
->whereNotIn('fleets.fleet_id', function($query) use($id){
return $query->from('fleet_users')
->join('fleet_dictionaries', 'fleet_dictionaries.id', '=', 'fleet_users.fleet_id')
->select('fleet_users.fleet_id')
->where('fleet_users.user_id', $id);
})
->where('fleets.airline_id', $idport)
->distinct('fleets.fleet_id')
->get();
php -i | egrep 'limit|timeout|max'
hard_timeout => 2 => 2
log_errors_max_len => 1024 => 1024
max_execution_time => 0 => 0
max_file_uploads => 20 => 20
max_input_nesting_level => 64 => 64
max_input_time => -1 => -1
max_input_vars => 1000 => 1000
memory_limit => -1 => -1
post_max_size => 8M => 8M
upload_max_filesize => 2M => 2M
zend.exception_string_param_max_len => 0 => 0
mbstring.regex_retry_limit => 1000000 => 1000000
mbstring.regex_stack_limit => 100000 => 100000
memcached.default_connect_timeout => 0 => 0
memcached.sess_connect_timeout => 0 => 0
memcached.sess_lock_max_wait => not set => not set
memcached.sess_lock_wait_max => 150 => 150
memcached.sess_server_failure_limit => 0 => 0
mysqli.max_links => Unlimited => Unlimited
mysqli.max_persistent => Unlimited => Unlimited
Read timeout => 86400
pcre.backtrack_limit => 1000000 => 1000000
pcre.recursion_limit => 100000 => 100000
pgsql.max_links => Unlimited => Unlimited
pgsql.max_persistent => Unlimited => Unlimited
session.cache_limiter => nocache => nocache
session.gc_maxlifetime => 1440 => 1440
default_socket_timeout => 60 => 60
unserialize_max_depth => 4096 => 4096
xdebug.connect_timeout_ms => 200 => 200
xdebug.max_nesting_level => 256 => 256
xdebug.max_stack_frames => -1 => -1
xdebug.remote_timeout => (setting renamed in Xdebug 3) => (setting renamed in Xdebug 3)
xdebug.var_display_max_children => 128 => 128
xdebug.var_display_max_data => 512 => 512
xdebug.var_display_max_depth => 3 => 3
opcache.force_restart_timeout => 180 => 180
opcache.jit_bisect_limit => 0 => 0
opcache.jit_max_exit_counters => 8192 => 8192
opcache.jit_max_loop_unrolls => 8 => 8
opcache.jit_max_polymorphic_calls => 2 => 2
opcache.jit_max_recursive_calls => 2 => 2
opcache.jit_max_recursive_returns => 2 => 2
opcache.jit_max_root_traces => 1024 => 1024
opcache.jit_max_side_traces => 128 => 128
opcache.max_accelerated_files => 10000 => 10000
opcache.max_file_size => 0 => 0
opcache.max_wasted_percentage => 5 => 5