Internal Server Error

Illuminate\Routing\Exceptions\UrlGenerationException

vendor/laravel/framework/src/Illuminate/Routing/Exceptions/UrlGenerationException.php:35

Missing required parameter for [Route: city] [URI: city-{city_slug}] [Missing parameter: city_slug].

LARAVEL 12.55.1
PHP 8.2.28
UNHANDLED
CODE 0
500
GET
http://www.worldstandardtime.com/bra

Exception trace

5 vendor frames
Illuminate\Routing\Exceptions\UrlGenerationException::forMissingParameters()
vendor/laravel/framework/src/Illuminate/Routing/Exceptions/UrlGenerationException.php:35
Illuminate\Routing\Exceptions\UrlGenerationException::forMissingParameters()
vendor/laravel/framework/src/Illuminate/Routing/RouteUrlGenerator.php:94
Illuminate\Routing\RouteUrlGenerator->to()
vendor/laravel/framework/src/Illuminate/Routing/UrlGenerator.php:543
Illuminate\Routing\UrlGenerator->toRoute()
vendor/laravel/framework/src/Illuminate/Routing/UrlGenerator.php:520
Illuminate\Routing\UrlGenerator->route()
vendor/laravel/framework/src/Illuminate/Foundation/helpers.php:870
route()
app/Models/City.php:103
98    {99        $locale = \Illuminate\Support\Facades\App::getLocale();100        $params = ['city_slug' => $this->slug];101        102        if ($locale === 'en') {103            return route('city', $params);104        }105        106        $params['locale'] = $locale;107        return route('city.locale', $params);108    }109}110
App\Models\City->get_absolute_url()
resources/views/country.blade.php:627
622                                        @endforeach623                                    </td>624                                    <td class="px-6 py-4 text-sm">625                                        @foreach ($utc->cities()->orderByDesc('population')->limit(20)->get() as $c)626                                            <div class="inline-block mr-2 mb-1">627                                                <a href="{{ $c->get_absolute_url() }}" class="flex items-center text-muted-themed hover:text-themed-primary">628                                                    <img loading="lazy" src="https://cdnjs.cloudflare.com/ajax/libs/flag-icon-css/4.1.4/flags/4x3/{{ strtolower($c->country->alpha2) }}.svg" class="mr-1 h-3 w-auto" alt="{{ $c->country->name }} flag" aria-hidden="true">629                                                    {{ $c->name }}630                                                </a>631                                            </div>632                                        @endforeach633                                    </td>634                                </tr>635                            @endforeach636                        </tbody>637                    </table>638                </div>639
13 vendor frames
require(string)
vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:123
Illuminate\Filesystem\Filesystem::Illuminate\Filesystem\{closure}()
vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
Illuminate\Filesystem\Filesystem->getRequire()
vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:57
Illuminate\View\Engines\PhpEngine->evaluatePath()
vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:76
Illuminate\View\Engines\CompilerEngine->get()
vendor/laravel/framework/src/Illuminate/View/View.php:208
Illuminate\View\View->getContents()
vendor/laravel/framework/src/Illuminate/View/View.php:191
Illuminate\View\View->renderContents()
vendor/laravel/framework/src/Illuminate/View/View.php:160
Illuminate\View\View->render()
vendor/laravel/framework/src/Illuminate/Http/Response.php:78
Illuminate\Http\Response->setContent()
vendor/laravel/framework/src/Illuminate/Http/Response.php:34
Illuminate\Http\Response->__construct()
vendor/laravel/framework/src/Illuminate/Routing/Router.php:939
Illuminate\Routing\Router::toResponse()
vendor/laravel/framework/src/Illuminate/Routing/Router.php:906
Illuminate\Routing\Router->prepareResponse()
vendor/laravel/framework/src/Illuminate/Routing/Router.php:821
Illuminate\Routing\Router->Illuminate\Routing\{closure}()
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
app/Http/Middleware/ResponseCache.php:29
24        if (Cache::has($cacheKey)) {25            $cachedContent = Cache::get($cacheKey);26            return response($cachedContent)->header('X-Cache', 'HIT');27        }2829        $response = $next($request);3031        if ($response->getStatusCode() === 200) {32            $cacheMinutes = (int) ($minutes ?? config('cache.response_cache_duration', 60));33            Cache::put($cacheKey, $response->getContent(), now()->addMinutes($cacheMinutes));34            $response->header('X-Cache', 'MISS');35        }3637        return $response;38    }39}40
1 vendor frame
App\Http\Middleware\ResponseCache->handle()
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
app/Http/Middleware/SetLocale.php:62
5758        View::share('availableLocales', $allLocales);59        View::share('currentLocale', App::getLocale());60        View::share('homeUrl', App::getLocale() === 'en' ? route('index') : route('index.locale', ['locale' => App::getLocale()]));6162        return $next($request);63    }64}65
43 vendor frames
App\Http\Middleware\SetLocale->handle()
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:50
Illuminate\Routing\Middleware\SubstituteBindings->handle()
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:87
Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle()
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:48
Illuminate\View\Middleware\ShareErrorsFromSession->handle()
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:120
Illuminate\Session\Middleware\StartSession->handleStatefulRequest()
vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:63
Illuminate\Session\Middleware\StartSession->handle()
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:36
Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle()
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:74
Illuminate\Cookie\Middleware\EncryptCookies->handle()
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:137
Illuminate\Pipeline\Pipeline->then()
vendor/laravel/framework/src/Illuminate/Routing/Router.php:821
Illuminate\Routing\Router->runRouteWithinStack()
vendor/laravel/framework/src/Illuminate/Routing/Router.php:800
Illuminate\Routing\Router->runRoute()
vendor/laravel/framework/src/Illuminate/Routing/Router.php:764
Illuminate\Routing\Router->dispatchToRoute()
vendor/laravel/framework/src/Illuminate/Routing/Router.php:753
Illuminate\Routing\Router->dispatch()
vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:200
Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}()
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
Illuminate\Foundation\Http\Middleware\TransformsRequest->handle()
vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php:31
Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle()
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
Illuminate\Foundation\Http\Middleware\TransformsRequest->handle()
vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php:51
Illuminate\Foundation\Http\Middleware\TrimStrings->handle()
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePostSize.php:27
Illuminate\Http\Middleware\ValidatePostSize->handle()
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php:109
Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle()
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php:61
Illuminate\Http\Middleware\HandleCors->handle()
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php:58
Illuminate\Http\Middleware\TrustProxies->handle()
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/InvokeDeferredCallbacks.php:22
Illuminate\Foundation\Http\Middleware\InvokeDeferredCallbacks->handle()
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePathEncoding.php:26
Illuminate\Http\Middleware\ValidatePathEncoding->handle()
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:137
Illuminate\Pipeline\Pipeline->then()
vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:175
Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter()
vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:144
Illuminate\Foundation\Http\Kernel->handle()
vendor/laravel/framework/src/Illuminate/Foundation/Application.php:1220
Illuminate\Foundation\Application->handleRequest()
public/index.php:20
1516// Bootstrap Laravel and handle the request...17/** @var Application $app */18$app = require_once __DIR__.'/../bootstrap/app.php';1920$app->handleRequest(Request::capture());21

Queries

mysql
select count(*) as aggregate from `all_city` where `all_city`.`country_id` = 'brazil' and `all_city`.`country_id` is not null and `majorcitycountry` = '1'
9.33ms
mysql
select * from `all_city` where `all_city`.`country_id` = 'brazil' and `all_city`.`country_id` is not null and `majorcitycountry` = '1' order by `population` desc limit 50 offset 0
8.05ms
mysql
select * from `all_country` where `all_country`.`slug` in ('brazil')
0.86ms
mysql
select * from `all_state` where `all_state`.`fromid` in ('3390290', '3392213', '3392268', '3393098', '3393129', '3395443', '3402362', '3408096', '3447799', '3448433', '3450387', '3451133', '3451189', '3455077', '3457153', '3457415', '3457419', '3462372', '3463504', '3463930', '3471168', '3665361')
1.71ms
mysql
select `all_utc`.*, `all_utc_country`.`country_id` as `pivot_country_id`, `all_utc_country`.`utc_id` as `pivot_utc_id` from `all_utc` inner join `all_utc_country` on `all_utc`.`name` = `all_utc_country`.`utc_id` where `all_utc_country`.`country_id` = 'brazil'
0.77ms
mysql
select `all_city`.*, `all_city_timezone`.`timezone_id` as `pivot_timezone_id`, `all_city_timezone`.`city_id` as `pivot_city_id` from `all_city` inner join `all_city_timezone` on `all_city`.`fromid` = `all_city_timezone`.`city_id` where `all_city_timezone`.`timezone_id` = 'america-araguaina'
5.09ms
mysql
select `all_city`.*, `all_city_timezone`.`timezone_id` as `pivot_timezone_id`, `all_city_timezone`.`city_id` as `pivot_city_id` from `all_city` inner join `all_city_timezone` on `all_city`.`fromid` = `all_city_timezone`.`city_id` where `all_city_timezone`.`timezone_id` = 'america-araguaina' order by `population` desc limit 3
1.71ms
mysql
select `all_city`.*, `all_city_timezone`.`timezone_id` as `pivot_timezone_id`, `all_city_timezone`.`city_id` as `pivot_city_id` from `all_city` inner join `all_city_timezone` on `all_city`.`fromid` = `all_city_timezone`.`city_id` where `all_city_timezone`.`timezone_id` = 'america-bahia'
8.02ms
mysql
select `all_city`.*, `all_city_timezone`.`timezone_id` as `pivot_timezone_id`, `all_city_timezone`.`city_id` as `pivot_city_id` from `all_city` inner join `all_city_timezone` on `all_city`.`fromid` = `all_city_timezone`.`city_id` where `all_city_timezone`.`timezone_id` = 'america-bahia' order by `population` desc limit 3
4.02ms
mysql
select `all_city`.*, `all_city_timezone`.`timezone_id` as `pivot_timezone_id`, `all_city_timezone`.`city_id` as `pivot_city_id` from `all_city` inner join `all_city_timezone` on `all_city`.`fromid` = `all_city_timezone`.`city_id` where `all_city_timezone`.`timezone_id` = 'america-belem'
2.55ms
mysql
select `all_city`.*, `all_city_timezone`.`timezone_id` as `pivot_timezone_id`, `all_city_timezone`.`city_id` as `pivot_city_id` from `all_city` inner join `all_city_timezone` on `all_city`.`fromid` = `all_city_timezone`.`city_id` where `all_city_timezone`.`timezone_id` = 'america-belem' order by `population` desc limit 3
1.66ms
mysql
select `all_city`.*, `all_city_timezone`.`timezone_id` as `pivot_timezone_id`, `all_city_timezone`.`city_id` as `pivot_city_id` from `all_city` inner join `all_city_timezone` on `all_city`.`fromid` = `all_city_timezone`.`city_id` where `all_city_timezone`.`timezone_id` = 'america-boa-vista'
0.56ms
mysql
select `all_city`.*, `all_city_timezone`.`timezone_id` as `pivot_timezone_id`, `all_city_timezone`.`city_id` as `pivot_city_id` from `all_city` inner join `all_city_timezone` on `all_city`.`fromid` = `all_city_timezone`.`city_id` where `all_city_timezone`.`timezone_id` = 'america-boa-vista' order by `population` desc limit 3
0.64ms
mysql
select `all_city`.*, `all_city_timezone`.`timezone_id` as `pivot_timezone_id`, `all_city_timezone`.`city_id` as `pivot_city_id` from `all_city` inner join `all_city_timezone` on `all_city`.`fromid` = `all_city_timezone`.`city_id` where `all_city_timezone`.`timezone_id` = 'america-campo-grande'
1.96ms
mysql
select `all_city`.*, `all_city_timezone`.`timezone_id` as `pivot_timezone_id`, `all_city_timezone`.`city_id` as `pivot_city_id` from `all_city` inner join `all_city_timezone` on `all_city`.`fromid` = `all_city_timezone`.`city_id` where `all_city_timezone`.`timezone_id` = 'america-campo-grande' order by `population` desc limit 3
3.85ms
mysql
select `all_city`.*, `all_city_timezone`.`timezone_id` as `pivot_timezone_id`, `all_city_timezone`.`city_id` as `pivot_city_id` from `all_city` inner join `all_city_timezone` on `all_city`.`fromid` = `all_city_timezone`.`city_id` where `all_city_timezone`.`timezone_id` = 'america-cuiaba'
1.83ms
mysql
select `all_city`.*, `all_city_timezone`.`timezone_id` as `pivot_timezone_id`, `all_city_timezone`.`city_id` as `pivot_city_id` from `all_city` inner join `all_city_timezone` on `all_city`.`fromid` = `all_city_timezone`.`city_id` where `all_city_timezone`.`timezone_id` = 'america-cuiaba' order by `population` desc limit 3
1.07ms
mysql
select `all_city`.*, `all_city_timezone`.`timezone_id` as `pivot_timezone_id`, `all_city_timezone`.`city_id` as `pivot_city_id` from `all_city` inner join `all_city_timezone` on `all_city`.`fromid` = `all_city_timezone`.`city_id` where `all_city_timezone`.`timezone_id` = 'america-eirunepe'
0.84ms
mysql
select `all_city`.*, `all_city_timezone`.`timezone_id` as `pivot_timezone_id`, `all_city_timezone`.`city_id` as `pivot_city_id` from `all_city` inner join `all_city_timezone` on `all_city`.`fromid` = `all_city_timezone`.`city_id` where `all_city_timezone`.`timezone_id` = 'america-eirunepe' order by `population` desc limit 3
0.66ms
mysql
select `all_city`.*, `all_city_timezone`.`timezone_id` as `pivot_timezone_id`, `all_city_timezone`.`city_id` as `pivot_city_id` from `all_city` inner join `all_city_timezone` on `all_city`.`fromid` = `all_city_timezone`.`city_id` where `all_city_timezone`.`timezone_id` = 'america-fortaleza'
11.85ms
mysql
select `all_city`.*, `all_city_timezone`.`timezone_id` as `pivot_timezone_id`, `all_city_timezone`.`city_id` as `pivot_city_id` from `all_city` inner join `all_city_timezone` on `all_city`.`fromid` = `all_city_timezone`.`city_id` where `all_city_timezone`.`timezone_id` = 'america-fortaleza' order by `population` desc limit 3
11.09ms
mysql
select `all_city`.*, `all_city_timezone`.`timezone_id` as `pivot_timezone_id`, `all_city_timezone`.`city_id` as `pivot_city_id` from `all_city` inner join `all_city_timezone` on `all_city`.`fromid` = `all_city_timezone`.`city_id` where `all_city_timezone`.`timezone_id` = 'america-maceio'
5.91ms
mysql
select `all_city`.*, `all_city_timezone`.`timezone_id` as `pivot_timezone_id`, `all_city_timezone`.`city_id` as `pivot_city_id` from `all_city` inner join `all_city_timezone` on `all_city`.`fromid` = `all_city_timezone`.`city_id` where `all_city_timezone`.`timezone_id` = 'america-maceio' order by `population` desc limit 3
2.07ms
mysql
select `all_city`.*, `all_city_timezone`.`timezone_id` as `pivot_timezone_id`, `all_city_timezone`.`city_id` as `pivot_city_id` from `all_city` inner join `all_city_timezone` on `all_city`.`fromid` = `all_city_timezone`.`city_id` where `all_city_timezone`.`timezone_id` = 'america-manaus'
3.69ms
mysql
select `all_city`.*, `all_city_timezone`.`timezone_id` as `pivot_timezone_id`, `all_city_timezone`.`city_id` as `pivot_city_id` from `all_city` inner join `all_city_timezone` on `all_city`.`fromid` = `all_city_timezone`.`city_id` where `all_city_timezone`.`timezone_id` = 'america-manaus' order by `population` desc limit 3
2.3ms
mysql
select `all_city`.*, `all_city_timezone`.`timezone_id` as `pivot_timezone_id`, `all_city_timezone`.`city_id` as `pivot_city_id` from `all_city` inner join `all_city_timezone` on `all_city`.`fromid` = `all_city_timezone`.`city_id` where `all_city_timezone`.`timezone_id` = 'america-noronha'
3.61ms
mysql
select `all_city`.*, `all_city_timezone`.`timezone_id` as `pivot_timezone_id`, `all_city_timezone`.`city_id` as `pivot_city_id` from `all_city` inner join `all_city_timezone` on `all_city`.`fromid` = `all_city_timezone`.`city_id` where `all_city_timezone`.`timezone_id` = 'america-noronha' order by `population` desc limit 3
2.04ms
mysql
select `all_city`.*, `all_city_timezone`.`timezone_id` as `pivot_timezone_id`, `all_city_timezone`.`city_id` as `pivot_city_id` from `all_city` inner join `all_city_timezone` on `all_city`.`fromid` = `all_city_timezone`.`city_id` where `all_city_timezone`.`timezone_id` = 'america-porto-velho'
1.69ms
mysql
select `all_city`.*, `all_city_timezone`.`timezone_id` as `pivot_timezone_id`, `all_city_timezone`.`city_id` as `pivot_city_id` from `all_city` inner join `all_city_timezone` on `all_city`.`fromid` = `all_city_timezone`.`city_id` where `all_city_timezone`.`timezone_id` = 'america-porto-velho' order by `population` desc limit 3
1.15ms
mysql
select `all_city`.*, `all_city_timezone`.`timezone_id` as `pivot_timezone_id`, `all_city_timezone`.`city_id` as `pivot_city_id` from `all_city` inner join `all_city_timezone` on `all_city`.`fromid` = `all_city_timezone`.`city_id` where `all_city_timezone`.`timezone_id` = 'america-recife'
3.77ms
mysql
select `all_city`.*, `all_city_timezone`.`timezone_id` as `pivot_timezone_id`, `all_city_timezone`.`city_id` as `pivot_city_id` from `all_city` inner join `all_city_timezone` on `all_city`.`fromid` = `all_city_timezone`.`city_id` where `all_city_timezone`.`timezone_id` = 'america-recife' order by `population` desc limit 3
2.7ms
mysql
select `all_city`.*, `all_city_timezone`.`timezone_id` as `pivot_timezone_id`, `all_city_timezone`.`city_id` as `pivot_city_id` from `all_city` inner join `all_city_timezone` on `all_city`.`fromid` = `all_city_timezone`.`city_id` where `all_city_timezone`.`timezone_id` = 'america-rio-branco'
0.79ms
mysql
select `all_city`.*, `all_city_timezone`.`timezone_id` as `pivot_timezone_id`, `all_city_timezone`.`city_id` as `pivot_city_id` from `all_city` inner join `all_city_timezone` on `all_city`.`fromid` = `all_city_timezone`.`city_id` where `all_city_timezone`.`timezone_id` = 'america-rio-branco' order by `population` desc limit 3
0.79ms
mysql
select `all_city`.*, `all_city_timezone`.`timezone_id` as `pivot_timezone_id`, `all_city_timezone`.`city_id` as `pivot_city_id` from `all_city` inner join `all_city_timezone` on `all_city`.`fromid` = `all_city_timezone`.`city_id` where `all_city_timezone`.`timezone_id` = 'america-santarem'
0.81ms
mysql
select `all_city`.*, `all_city_timezone`.`timezone_id` as `pivot_timezone_id`, `all_city_timezone`.`city_id` as `pivot_city_id` from `all_city` inner join `all_city_timezone` on `all_city`.`fromid` = `all_city_timezone`.`city_id` where `all_city_timezone`.`timezone_id` = 'america-santarem' order by `population` desc limit 3
0.75ms
mysql
select `all_city`.*, `all_city_timezone`.`timezone_id` as `pivot_timezone_id`, `all_city_timezone`.`city_id` as `pivot_city_id` from `all_city` inner join `all_city_timezone` on `all_city`.`fromid` = `all_city_timezone`.`city_id` where `all_city_timezone`.`timezone_id` = 'america-sao-paulo'
39.62ms
mysql
select `all_city`.*, `all_city_timezone`.`timezone_id` as `pivot_timezone_id`, `all_city_timezone`.`city_id` as `pivot_city_id` from `all_city` inner join `all_city_timezone` on `all_city`.`fromid` = `all_city_timezone`.`city_id` where `all_city_timezone`.`timezone_id` = 'america-sao-paulo' order by `population` desc limit 3
22.78ms
mysql
select `all_timezone`.*, `all_utc_timezone`.`utc_id` as `pivot_utc_id`, `all_utc_timezone`.`timezone_id` as `pivot_timezone_id` from `all_timezone` inner join `all_utc_timezone` on `all_timezone`.`slug` = `all_utc_timezone`.`timezone_id` where `all_utc_timezone`.`utc_id` = '-2'
0.86ms
mysql
select * from `all_country` where `all_country`.`slug` = 'brazil' limit 1
0.51ms
mysql
select * from `all_country` where `all_country`.`slug` = 'south-georgia-sandwich' limit 1
0.51ms
mysql
select * from `all_city` where `all_city`.`gmt` = '-2' and `all_city`.`gmt` is not null order by `population` desc limit 20
157.91ms
mysql
select * from `all_country` where `all_country`.`slug` = 'brazil' limit 1
0.54ms
mysql
select * from `all_country` where `all_country`.`slug` = 'south-georgia-sandwich' limit 1
0.5ms

Headers

accept-encoding
gzip, br
host
www.worldstandardtime.com
connection
Keep-Alive
x-forwarded-proto
https
cf-visitor
{"scheme":"https"}
cf-ipcountry
NL
cf-connecting-ip
162.0.217.198
cdn-loop
cloudflare; loops=1
accept
*/*
referer
https://www.btolat.com/
user-agent
Mozilla/5.0 (Windows NT 10.0; Win64; x64)
cf-ray
9e9fb512bac14b78-ATL
x-forwarded-for
162.0.217.198

Body

// No request body

Routing

controller
App\Http\Controllers\WorldTimeController@country
route name
country
middleware
web, App\Http\Middleware\SetLocale, cache:60

Routing parameters

{
    "country_slug": "bra"
}