The most frequent flight to Tokyo is from Phuket. The cheapest airfare can be purchased with a flight from Penang from $149. The nearest airports from Alor Setar with a flight to Tokyo are in Koh Samui.

Popular International routes from Alor Setar

Alor Setar — Singapore

from $137 one-way

Alor Setar — London

from $436 one-way

Alor Setar — Abu Dhabi

from $588 one-way

Alor Setar — Chiang Mai

from $236 one-way

Alor Setar — Delhi

from $254 one-way

Popular routes from Tokyo

If you are going to fly from Tokyo, then study the popular flights. The most popular flights from Tokyo:

Tokyo — Moscow

from $298 one-way

Tokyo — Papeete

from $801 one-way

Tokyo — Saint Petersburg

from $431 one-way

Tokyo — Bora Bora

from $1,018 one-way

Tokyo — Vladivostok

from $323 one-way

Popular domestic routes from Alor Setar

Alor Setar — Johor Bharu

from $43 one-way

Alor Setar — Penang

from $83 one-way

Alor Setar — Kuala Lumpur

from $14 one-way

Alor Setar — Kuala Terengganu

from $32 one-way

Alor Setar — Bintulu

from $280 round-trip

Return flights Tokyo – Alor Setar

Messages Timeline Exceptions Views53 Route Queries80 Models468 Mails Gate N+1 Queries3 Session Request

Request history8.3.0891ms4MBGET cheap-flights-from-{slug}

Booting (30.03ms)time
Application (861ms)time
1 x Application (96.63%)
861ms
1 x Booting (3.37%)
30.03ms

53 templates were rendered

1x views_us.routes.viewview.blade.php#?blade
1x routes.viewview.blade.php#?blade
1x index.section-slideshowsection-slideshow.blade.php#?blade
1x components.avia-formavia-form.blade.php#?blade
1x breadcrumbs::bootstrap4bootstrap4.blade.php#?blade
1x routes.section-advantagessection-advantages.blade.php#?blade
1x routes.AirlinesListAirlinesList.blade.php#?blade
2x components.airlines-columnairlines-column.blade.php#?blade
4x components.routes-listroutes-list.blade.php#?blade
25x components.routeListItemrouteListItem.blade.php#?blade
1x routes.description-nearbyCitiesdescription-nearbyCities.blade.php#?blade
2x components.routes-columnroutes-column.blade.php#?blade
1x components.related-linksrelated-links.blade.php#?blade
1x layouts.mainmain.blade.php#?blade
1x headerheader.blade.php#?blade
2x menumenu.blade.php#?blade
1x footerfooter.blade.php#?blade
1x components.footer-popular-flightsfooter-popular-flights.blade.php#?blade
1x footer_scriptsfooter_scripts.blade.php#?blade
1x components.currencycurrency.blade.php#?blade
2x components.popuppopup.blade.php#?blade
1x components.languagelanguage.blade.php#?blade

uri: GET cheap-flights-from-{slug}
middleware: web
controller: App\Http\Controllers\RoutesController@view
namespace
prefix: /
where
as: route
file: app/Http/Controllers/RoutesController.php:96-299

80 statements were executed (36 duplicates)Show only duplicates285ms

QueryDetector.php#25aviaticketsConnection Established

Backtrace

vendor/beyondcode/laravel-query-detector/src/QueryDetector.php:25
vendor/beyondcode/laravel-query-detector/src/QueryDetectorMiddleware.php:30
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
app/Http/Middleware/MinifyHtml.php:21

SitesRelationshipsSqlRepository.php#34aviatickets7.37msselect * from `sites_relationships` where `us` = 'cheap-flights-from-alor-setar-to-tokyo-aor-tyo' limit 1

Bindings	0: cheap-flights-from-alor-setar-to-tokyo-aor-tyo
Backtrace	app/Avia/Infrastructure/SitesRelationships/SitesRelationshipsSqlRepository.php:34 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/SitesRelationships/SitesRelationshipsSqlRepository.php:31 app/Http/Controllers/RoutesController.php:113

RoutesController.php#125aviatickets2.2msselect * from `flights_by` where `flights_by`.`id` = '16279' and `flights_by`.`id` is not null limit 1

Bindings	0: [object Object]
Backtrace	app/Http/Controllers/RoutesController.php:125 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

RoutesController.php#135aviatickets1.86msselect * from `cities` where `cities`.`id` = 251 limit 1

Bindings	0: 251
Backtrace	app/Http/Controllers/RoutesController.php:135 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

RoutesController.php#136aviatickets1.82msselect * from `countries` where `countries`.`id` = 108 limit 1

Bindings	0: 108
Backtrace	app/Http/Controllers/RoutesController.php:136 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

RoutesController.php#137aviatickets4.15msselect * from `cities` where `cities`.`id` = 6319 limit 1

Bindings	0: 6319
Backtrace	app/Http/Controllers/RoutesController.php:137 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

RoutesController.php#138aviatickets2.48msselect * from `countries` where `countries`.`id` = 211 limit 1

Bindings	0: 211
Backtrace	app/Http/Controllers/RoutesController.php:138 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

DomainRouteFactory.php#33aviatickets820μs

select * from `sites_relationships` where `sites_relationships`.`id` = 16279 and `sites_relationships`.`id` is not null limit 1

Bindings	0: 16279
Backtrace	app/Avia/Infrastructure/Factory/DomainRouteFactory.php:33 app/Http/Controllers/RoutesController.php:143 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

CountriesRepository.php#31aviatickets1.59msselect * from `countries` where `code` = '' limit 1

Bindings	0:
Backtrace	app/Avia/Infrastructure/Repository/CountriesRepository.php:31 app/Avia/Infrastructure/Provider/CurrentCurrencyProvider.php:61 app/Avia/Infrastructure/Provider/CurrentCurrencyProvider.php:43 app/Avia/Infrastructure/Provider/CurrentCurrencyProvider.php:56 app/Avia/Infrastructure/Model/LocalRoute.php:190

RouteRepository.php#42aviatickets8.45ms

select `depart_date`, `return_date`, `number_of_changes`, `value` from `flights_2025` where `origin_id` = 251 and `destination_id` = 6319 and `date_update` >= '2025-05-06 00:00:00' order by `value` asc limit 10

Bindings	0: 251 1: 6319 2: 2025-05-06 00:00:00
Backtrace	app/Avia/Infrastructure/Repository/RouteRepository.php:42 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Repository/RouteRepository.php:33 app/Http/Controllers/RoutesController.php:150

MonthlyPriceStatisticSqlRepository.php#66aviatickets1.43msselect * from `monthly_price_statistics` where `origin_city_id` = 251 and `destination_city_id` = 6319 limit 1

Bindings	0: 251 1: 6319
Backtrace	app/Avia/Infrastructure/Repository/MonthlyPriceStatisticSqlRepository.php:66 app/Avia/Infrastructure/Repository/MonthlyPriceStatisticSqlRepository.php:50 app/Avia/Application/PriceHandler.php:42 app/Http/Controllers/RoutesController.php:156 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

AirlineSqlRepository.php#470aviatickets1.66ms

select * from `timetables` where `origin_city_id` = 251 and `destination_city_id` = 6319 order by `time_origin` asc limit 1000

Bindings	0: 251 1: 6319
Backtrace	app/Avia/Infrastructure/Repository/AirlineSqlRepository.php:470 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Repository/AirlineSqlRepository.php:461 app/Http/Controllers/RoutesController.php:162

AirlineSqlRepository.php#502aviatickets960μsselect distinct `airline_id` from `timetables` where `origin_city_id` = 251

Bindings	0: 251
Backtrace	app/Avia/Infrastructure/Repository/AirlineSqlRepository.php:502 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Repository/AirlineSqlRepository.php:494 app/Avia/Infrastructure/Repository/AirlineSqlRepository.php:407

AirlineSqlRepository.php#502aviatickets5.16msselect distinct `airline_id` from `timetables` where `origin_city_id` = 6319

Bindings	0: 6319
Backtrace	app/Avia/Infrastructure/Repository/AirlineSqlRepository.php:502 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Repository/AirlineSqlRepository.php:494 app/Avia/Infrastructure/Repository/AirlineSqlRepository.php:408

AirlineSqlRepository.php#90aviatickets1.95msselect * from `airlines` where `id` in (574, 3371, 17852, 21440) order by `name` asc

Bindings	0: 574 1: 3371 2: 17852 3: 21440
Backtrace	app/Avia/Infrastructure/Repository/AirlineSqlRepository.php:90 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Repository/AirlineSqlRepository.php:84 app/Avia/Infrastructure/Repository/AirlineSqlRepository.php:413

LocalRouteRepository.php#558aviatickets1.4ms

select destination_city_id from `flights_by` where `origin_city_id` = 251 and `distance` between 1 and 1000 and (`price_one_way` > 0 or `price` > 0) order by `distance` asc limit 10

Bindings	0: 251 1: 1 2: 1000 3: 0 4: 0
Backtrace	app/Avia/Infrastructure/Repository/LocalRouteRepository.php:558 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Repository/LocalRouteRepository.php:563 app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:62

NearbyCitiesAggregateDbProvider.php#73aviatickets1.69ms

select * from `flights_by` where `origin_city_id` in (3538, 9271, 2896, 9242, 9311, 2382, 3879, 3366, 6906, 3357) and `destination_city_id` = 6319 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 3538 1: 9271 2: 2896 3: 9242 4: 9311 5: 2382 6: 3879 7: 3366 8: 6906 9: 3357 10: 6319 11: 0 12: 0
Backtrace	app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:73 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:58 app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:35

NearbyCitiesAggregateDbProvider.php#73aviatickets2.98msselect * from `cities` where `cities`.`id` in (2382, 2896, 3357, 3366, 3538, 3879, 6906, 9242, 9271, 9311)

Backtrace

app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:73
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:58
app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:35

NearbyCitiesAggregateDbProvider.php#73aviatickets1.27msselect * from `cities` where `cities`.`id` in (6319)

Backtrace

app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:73
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:58
app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:35

NearbyCitiesAggregateDbProvider.php#73aviatickets2.51ms

select * from `sites_relationships` where `sites_relationships`.`id` in (134408, 158528, 158759, 174503, 187598, 206409, 258394, 327262, 349426, 435557)

Backtrace

app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:73
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:58
app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:35

LocalRouteRepository.php#558aviatickets1.88ms

select destination_city_id from `flights_by` where `origin_city_id` = 251 and `distance` between 1 and 1000 and (`price_one_way` > 0 or `price` > 0) order by `distance` asc limit 10

Bindings	0: 251 1: 1 2: 1000 3: 0 4: 0
Backtrace	app/Avia/Infrastructure/Repository/LocalRouteRepository.php:558 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Repository/LocalRouteRepository.php:563 app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:62

NearbyCitiesAggregateDbProvider.php#73aviatickets2.16ms

select * from `flights_by` where `origin_city_id` in (3538, 9271, 2896, 9242, 9311, 2382, 3879, 3366, 6906, 3357) and `destination_city_id` = 6319 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 3538 1: 9271 2: 2896 3: 9242 4: 9311 5: 2382 6: 3879 7: 3366 8: 6906 9: 3357 10: 6319 11: 0 12: 0
Backtrace	app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:73 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:58 app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:85

NearbyCitiesAggregateDbProvider.php#73aviatickets4.08msselect * from `cities` where `cities`.`id` in (2382, 2896, 3357, 3366, 3538, 3879, 6906, 9242, 9271, 9311)

Backtrace

app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:73
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:58
app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:85

NearbyCitiesAggregateDbProvider.php#73aviatickets1.04msselect * from `cities` where `cities`.`id` in (6319)

Backtrace

app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:73
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:58
app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:85

NearbyCitiesAggregateDbProvider.php#73aviatickets10.37ms

select * from `sites_relationships` where `sites_relationships`.`id` in (134408, 158528, 158759, 174503, 187598, 206409, 258394, 327262, 349426, 435557)

Backtrace

app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:73
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:58
app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:85

CitySqlRepository.php#104aviatickets2.41msselect * from `cities` where `cities`.`id` = 6906 limit 1

Bindings	0: 6906
Backtrace	app/Avia/Infrastructure/City/CitySqlRepository.php:104 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/City/CitySqlRepository.php:101 app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:97

LocalRouteRepository.php#558aviatickets4.63ms

select destination_city_id from `flights_by` where `origin_city_id` = 251 and `distance` between 1 and 1000 and (`price_one_way` > 0 or `price` > 0) order by `distance` asc limit 10

Bindings	0: 251 1: 1 2: 1000 3: 0 4: 0
Backtrace	app/Avia/Infrastructure/Repository/LocalRouteRepository.php:558 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Repository/LocalRouteRepository.php:563 app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:62

NearbyCitiesAggregateDbProvider.php#73aviatickets2.64ms

select * from `flights_by` where `origin_city_id` in (3538, 9271, 2896, 9242, 9311, 2382, 3879, 3366, 6906, 3357) and `destination_city_id` = 6319 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 3538 1: 9271 2: 2896 3: 9242 4: 9311 5: 2382 6: 3879 7: 3366 8: 6906 9: 3357 10: 6319 11: 0 12: 0
Backtrace	app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:73 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:58 app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:142

NearbyCitiesAggregateDbProvider.php#73aviatickets3.75msselect * from `cities` where `cities`.`id` in (2382, 2896, 3357, 3366, 3538, 3879, 6906, 9242, 9271, 9311)

Backtrace

app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:73
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:58
app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:142

NearbyCitiesAggregateDbProvider.php#73aviatickets1.21msselect * from `cities` where `cities`.`id` in (6319)

Backtrace

app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:73
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:58
app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:142

NearbyCitiesAggregateDbProvider.php#73aviatickets2.4ms

select * from `sites_relationships` where `sites_relationships`.`id` in (134408, 158528, 158759, 174503, 187598, 206409, 258394, 327262, 349426, 435557)

Backtrace

app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:73
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:58
app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:142

CitySqlRepository.php#104aviatickets2.33msselect * from `cities` where `cities`.`id` = 9271 limit 1

Bindings	0: 9271
Backtrace	app/Avia/Infrastructure/City/CitySqlRepository.php:104 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/City/CitySqlRepository.php:101 app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:158

LocalRouteRepository.php#558aviatickets2.91ms

select destination_city_id from `flights_by` where `origin_city_id` = 251 and `distance` between 1 and 1000 and (`price_one_way` > 0 or `price` > 0) order by `distance` asc limit 10

Bindings	0: 251 1: 1 2: 1000 3: 0 4: 0
Backtrace	app/Avia/Infrastructure/Repository/LocalRouteRepository.php:558 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Repository/LocalRouteRepository.php:563 app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:62

NearbyCitiesAggregateDbProvider.php#73aviatickets8.63ms

select * from `flights_by` where `origin_city_id` in (3538, 9271, 2896, 9242, 9311, 2382, 3879, 3366, 6906, 3357) and `destination_city_id` = 6319 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 3538 1: 9271 2: 2896 3: 9242 4: 9311 5: 2382 6: 3879 7: 3366 8: 6906 9: 3357 10: 6319 11: 0 12: 0
Backtrace	app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:73 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:58 app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:123

NearbyCitiesAggregateDbProvider.php#73aviatickets5.75msselect * from `cities` where `cities`.`id` in (2382, 2896, 3357, 3366, 3538, 3879, 6906, 9242, 9271, 9311)

Backtrace

app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:73
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:58
app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:123

NearbyCitiesAggregateDbProvider.php#73aviatickets7.18msselect * from `cities` where `cities`.`id` in (6319)

Backtrace

app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:73
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:58
app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:123

NearbyCitiesAggregateDbProvider.php#73aviatickets13.06ms

select * from `sites_relationships` where `sites_relationships`.`id` in (134408, 158528, 158759, 174503, 187598, 206409, 258394, 327262, 349426, 435557)

Backtrace

app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:73
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:58
app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:123

CitySqlRepository.php#104aviatickets970μsselect * from `cities` where `cities`.`id` = 2382 limit 1

Bindings	0: 2382
Backtrace	app/Avia/Infrastructure/City/CitySqlRepository.php:104 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/City/CitySqlRepository.php:101 app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:131

LocalRouteRepository.php#558aviatickets790μs

select destination_city_id from `flights_by` where `origin_city_id` = 251 and `distance` between 1 and 1000 and (`price_one_way` > 0 or `price` > 0) order by `distance` asc limit 10

Bindings	0: 251 1: 1 2: 1000 3: 0 4: 0
Backtrace	app/Avia/Infrastructure/Repository/LocalRouteRepository.php:558 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Repository/LocalRouteRepository.php:563 app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:62

NearbyCitiesAggregateDbProvider.php#73aviatickets1.53ms

select * from `flights_by` where `origin_city_id` in (3538, 9271, 2896, 9242, 9311, 2382, 3879, 3366, 6906, 3357) and `destination_city_id` = 6319 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 3538 1: 9271 2: 2896 3: 9242 4: 9311 5: 2382 6: 3879 7: 3366 8: 6906 9: 3357 10: 6319 11: 0 12: 0
Backtrace	app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:73 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:58 app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:142

NearbyCitiesAggregateDbProvider.php#73aviatickets900μsselect * from `cities` where `cities`.`id` in (2382, 2896, 3357, 3366, 3538, 3879, 6906, 9242, 9271, 9311)

Backtrace

app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:73
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:58
app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:142

NearbyCitiesAggregateDbProvider.php#73aviatickets830μsselect * from `cities` where `cities`.`id` in (6319)

Backtrace

app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:73
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:58
app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:142

NearbyCitiesAggregateDbProvider.php#73aviatickets790μs

select * from `sites_relationships` where `sites_relationships`.`id` in (134408, 158528, 158759, 174503, 187598, 206409, 258394, 327262, 349426, 435557)

Backtrace

app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:73
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:58
app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:142

CitySqlRepository.php#104aviatickets960μsselect * from `cities` where `cities`.`id` = 9271 limit 1

Bindings	0: 9271
Backtrace	app/Avia/Infrastructure/City/CitySqlRepository.php:104 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/City/CitySqlRepository.php:101 app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:158

OfferSqlRepository.php#52aviatickets2.25msselect * from `offers` where `origin_city_id` = 251 and `destination_city_id` = 6319

Bindings	0: 251 1: 6319
Backtrace	app/Avia/Infrastructure/Repository/OfferSqlRepository.php:52 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Repository/OfferSqlRepository.php:57 app/Http/Controllers/RoutesController.php:205

LocalRouteRepository.php#447aviatickets4.77ms

select * from `flights_by` where `origin_city_id` = 251 and `id` > 16279 and `destination_country_id` <> 108 and (`price_one_way` > 0 or `price` > 0) order by `id` asc limit 3

Bindings	0: 251 1: 16279 2: 108 3: 0 4: 0
Backtrace	app/Avia/Infrastructure/Repository/LocalRouteRepository.php:447 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Repository/LocalRouteRepository.php:451 app/Avia/Infrastructure/Repository/LocalRouteRepository.php:202

LocalRouteRepository.php#447aviatickets1.11msselect * from `cities` where `cities`.`id` in (251)

Backtrace

app/Avia/Infrastructure/Repository/LocalRouteRepository.php:447
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:451
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:202

LocalRouteRepository.php#447aviatickets1.57msselect * from `cities` where `cities`.`id` in (25, 347, 1462)

Backtrace

app/Avia/Infrastructure/Repository/LocalRouteRepository.php:447
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:451
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:202

LocalRouteRepository.php#447aviatickets19.7msselect * from `sites_relationships` where `sites_relationships`.`id` in (383768, 383772, 383773)

Backtrace

app/Avia/Infrastructure/Repository/LocalRouteRepository.php:447
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:451
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:202

LocalRouteRepository.php#412aviatickets1.51ms

select * from `flights_by` where `origin_city_id` = 251 and `destination_country_id` <> 108 and (`price_one_way` > 0 or `price` > 0) and `id` not in (383768) order by `revenue` desc limit 2 offset 0

Bindings	0: 251 1: 108 2: 0 3: 0 4: 383768
Backtrace	app/Avia/Infrastructure/Repository/LocalRouteRepository.php:412 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Repository/LocalRouteRepository.php:417 app/Avia/Infrastructure/Repository/LocalRouteRepository.php:209

LocalRouteRepository.php#412aviatickets1msselect * from `cities` where `cities`.`id` in (251)

Backtrace

app/Avia/Infrastructure/Repository/LocalRouteRepository.php:412
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:417
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:209

LocalRouteRepository.php#412aviatickets900μsselect * from `cities` where `cities`.`id` in (3654, 5610)

Backtrace

app/Avia/Infrastructure/Repository/LocalRouteRepository.php:412
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:417
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:209

LocalRouteRepository.php#412aviatickets1.32msselect * from `sites_relationships` where `sites_relationships`.`id` in (16261, 16274)

Backtrace

app/Avia/Infrastructure/Repository/LocalRouteRepository.php:412
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:417
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:209

LocalRouteRepository.php#412aviatickets1.1msselect * from `countries` where `countries`.`id` in (17, 136)

Backtrace

app/Avia/Infrastructure/Repository/LocalRouteRepository.php:412
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:417
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:209

LocalRouteRepository.php#149aviatickets1.79ms

select * from `flights_by` where `origin_city_id` = 6319 and (`price_one_way` > 0 or `price` > 0) and 1 = 1 order by `revenue` desc limit 5

Bindings	0: 6319 1: 0 2: 0
Backtrace	app/Avia/Infrastructure/Repository/LocalRouteRepository.php:149 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Repository/LocalRouteRepository.php:153 app/Http/Controllers/RoutesController.php:216

LocalRouteRepository.php#149aviatickets1.28msselect * from `cities` where `cities`.`id` in (6319)

Backtrace

app/Avia/Infrastructure/Repository/LocalRouteRepository.php:149
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:153
app/Http/Controllers/RoutesController.php:216

LocalRouteRepository.php#149aviatickets14.44msselect * from `cities` where `cities`.`id` in (767, 3505, 4081, 5051, 8905)

Backtrace

app/Avia/Infrastructure/Repository/LocalRouteRepository.php:149
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:153
app/Http/Controllers/RoutesController.php:216

LocalRouteRepository.php#149aviatickets8.89msselect * from `countries` where `countries`.`id` in (166, 248)

Backtrace

app/Avia/Infrastructure/Repository/LocalRouteRepository.php:149
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:153
app/Http/Controllers/RoutesController.php:216

LocalRouteRepository.php#149aviatickets7.79msselect * from `sites_relationships` where `sites_relationships`.`id` in (342515, 342859, 342934, 343051, 343286)

Backtrace

app/Avia/Infrastructure/Repository/LocalRouteRepository.php:149
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:153
app/Http/Controllers/RoutesController.php:216

LocalRouteRepository.php#359aviatickets4.3ms

select * from `flights_by` where `origin_city_id` = 251 and `destination_country_id` = 108 and (`price_one_way` > 0 or `price` > 0) order by `revenue` desc limit 5 offset 0

Bindings	0: 251 1: 108 2: 0 3: 0
Backtrace	app/Avia/Infrastructure/Repository/LocalRouteRepository.php:359 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Repository/LocalRouteRepository.php:363 app/Avia/Infrastructure/Repository/LocalRouteRepository.php:330

LocalRouteRepository.php#359aviatickets1.5msselect * from `cities` where `cities`.`id` in (251)

Backtrace

app/Avia/Infrastructure/Repository/LocalRouteRepository.php:359
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:363
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:330

LocalRouteRepository.php#359aviatickets2.18msselect * from `cities` where `cities`.`id` in (26, 871, 3366, 9271, 9311)

Backtrace

app/Avia/Infrastructure/Repository/LocalRouteRepository.php:359
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:363
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:330

LocalRouteRepository.php#359aviatickets4.35msselect * from `sites_relationships` where `sites_relationships`.`id` in (16254, 16258, 16269, 16276, 383770)

Backtrace

app/Avia/Infrastructure/Repository/LocalRouteRepository.php:359
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:363
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:330

LocalRouteRepository.php#359aviatickets1.81msselect * from `countries` where `countries`.`id` in (108)

Backtrace

app/Avia/Infrastructure/Repository/LocalRouteRepository.php:359
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:363
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:330

TimetableRepository.php#39aviatickets2.44ms

select * from `timetables` where `origin_city_id` = 251 and `destination_city_id` = 6319 order by `time_origin` asc limit 10

Bindings	0: 251 1: 6319
Backtrace	app/Avia/Infrastructure/Repository/TimetableRepository.php:39 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Repository/TimetableRepository.php:30 app/Http/Controllers/RoutesController.php:264

TimetableRepository.php#144aviatickets4.6ms

select * from `timetables` where `origin_city_id` = 251 and `destination_city_id` = 6319 order by `travel_time` asc limit 1

Bindings	0: 251 1: 6319
Backtrace	app/Avia/Infrastructure/Repository/TimetableRepository.php:144 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Repository/TimetableRepository.php:137 app/Http/Controllers/RoutesController.php:274

LocalRouteRepository.php#520aviatickets2.45msselect * from `flights_by` where `origin_city_id` = 6319 and `destination_city_id` = 251 limit 1

Bindings	0: 6319 1: 251
Backtrace	app/Avia/Infrastructure/Repository/LocalRouteRepository.php:520 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Repository/LocalRouteRepository.php:514 app/Http/Controllers/RoutesController.php:530

LocalRouteRepository.php#520aviatickets890μsselect * from `sites_relationships` where `sites_relationships`.`id` in (876382)

Backtrace

app/Avia/Infrastructure/Repository/LocalRouteRepository.php:520
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:514
app/Http/Controllers/RoutesController.php:530

LocalRoute.php#99aviatickets2.73msselect * from `cities` where `cities`.`id` = 251 limit 1

Bindings	0: 251
Backtrace	app/Avia/Infrastructure/Model/LocalRoute.php:99 app/Avia/Infrastructure/Factory/DomainRouteFactory.php:30 app/Http/Controllers/RoutesController.php:536 app/Http/Controllers/RoutesController.php:279 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

RoutesController.php#547aviatickets5.47msselect * from `cities` where `cities`.`id` = 6319 limit 1

Bindings	0: 6319
Backtrace	app/Http/Controllers/RoutesController.php:547 app/Http/Controllers/RoutesController.php:279 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

description-nearbyCities.blade.php#28aviatickets2.81msselect * from `cities` where `cities`.`id` = 251 limit 1

Bindings	0: 251
Backtrace	view::routes.description-nearbyCities:28 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72 vendor/laravel/framework/src/Illuminate/View/View.php:207

LocalRouteRepository.php#175aviatickets1.2msselect * from `flights_by` where `id` in (240458, 46235, 180255, 46251, 201516, 32301)

Bindings	0: 240458 1: 46235 2: 180255 3: 46251 4: 201516 5: 32301
Backtrace	app/Avia/Infrastructure/Repository/LocalRouteRepository.php:175 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Repository/LocalRouteRepository.php:179 app/Avia/Application/SeoRoutesHandler.php:40

LocalRouteRepository.php#175aviatickets10.92msselect * from `cities` where `cities`.`id` in (537, 779, 3448, 3796, 4539)

Backtrace

app/Avia/Infrastructure/Repository/LocalRouteRepository.php:175
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:179
app/Avia/Application/SeoRoutesHandler.php:40

LocalRouteRepository.php#175aviatickets1.75msselect * from `cities` where `cities`.`id` in (2122, 3301, 5136, 7738, 8381, 8447)

Backtrace

app/Avia/Infrastructure/Repository/LocalRouteRepository.php:175
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:179
app/Avia/Application/SeoRoutesHandler.php:40

LocalRouteRepository.php#175aviatickets2.13msselect * from `countries` where `countries`.`id` in (17, 70, 79, 92, 105)

Backtrace

app/Avia/Infrastructure/Repository/LocalRouteRepository.php:175
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:179
app/Avia/Application/SeoRoutesHandler.php:40

LocalRouteRepository.php#175aviatickets10.78msselect * from `sites_relationships` where `sites_relationships`.`id` in (32301, 46235, 46251, 180255, 201516, 240458)

Backtrace

app/Avia/Infrastructure/Repository/LocalRouteRepository.php:175
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:179
app/Avia/Application/SeoRoutesHandler.php:40

LocalRouteRepository.php#149aviatickets12.03ms

select * from `flights_by` where `origin_city_id` = 4539 and (`price_one_way` > 0 or `price` > 0) and `id` not in (240458, 46235, 180255, 46251, 201516, 32301) order by `count` desc limit 9

Bindings	0: 4539 1: 0 2: 0 3: 240458 4: 46235 5: 180255 6: 46251 7: 201516 8: 32301
Backtrace	app/Avia/Infrastructure/Repository/LocalRouteRepository.php:149 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Repository/LocalRouteRepository.php:153 app/Avia/Application/SeoRoutesHandler.php:54

LocalRouteRepository.php#149aviatickets850μsselect * from `cities` where `cities`.`id` in (4539)

Backtrace

app/Avia/Infrastructure/Repository/LocalRouteRepository.php:149
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:153
app/Avia/Application/SeoRoutesHandler.php:54

LocalRouteRepository.php#149aviatickets1.71msselect * from `cities` where `cities`.`id` in (1115, 1903, 2686, 3445, 3448, 3505, 3951, 4081, 8389)

Backtrace

app/Avia/Infrastructure/Repository/LocalRouteRepository.php:149
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:153
app/Avia/Application/SeoRoutesHandler.php:54

LocalRouteRepository.php#149aviatickets2.02msselect * from `countries` where `countries`.`id` in (92, 134, 242, 248)

Backtrace

app/Avia/Infrastructure/Repository/LocalRouteRepository.php:149
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:153
app/Avia/Application/SeoRoutesHandler.php:54

LocalRouteRepository.php#149aviatickets2.19ms

select * from `sites_relationships` where `sites_relationships`.`id` in (239645, 239765, 239824, 239994, 240101, 240103, 240116, 240218, 240243)

Backtrace

app/Avia/Infrastructure/Repository/LocalRouteRepository.php:149
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:153
app/Avia/Application/SeoRoutesHandler.php:54

App\Avia\Infrastructure\Model\LocalRoute: 132LocalRoute.php#?
App\Avia\Infrastructure\Model\Timetable: 128Timetable.php#?
App\Avia\Infrastructure\Model\City: 104City.php#?
App\Avia\Infrastructure\Model\SitesRelationship: 83SitesRelationship.php#?
App\Avia\Infrastructure\Model\Country: 16Country.php#?
App\Avia\Infrastructure\Model\Airline: 4Airline.php#?
App\Avia\Infrastructure\Model\MonthlyPriceStatistic: 1MonthlyPriceStatistic.php#?

infoModel: App\Avia\Infrastructure\Model\LocalRoute => Relation: App\Avia\Infrastructure\Model\City - Yo...
infoModel: App\Avia\Infrastructure\Model\LocalRoute => Relation: App\Avia\Infrastructure\Model\City - Yo...
infoModel: App\Avia\Infrastructure\Model\LocalRoute => Relation: App\Avia\Infrastructure\Model\SitesRela...

_token: OA1i52YX2o645QRcTQl00UuBpNfbJT6tHnebLOC4
_previous: array:1 [ "url" => "https://d.lowcost.club/cheap-flights-from-alor-setar-to-tokyo-aor-tyo?_url=%2F...
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/cheap-flights-from-alor-setar-to-tokyo-aor-tyo

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:1 [▼
  "_url" => "/cheap-flights-from-alor-setar-to-tokyo-aor-tyo"
]

request_request

[]

request_headers

  0 of 0   
array:16 [▼
  "cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImRUUmhJV3Q2YWhYZ2k1S0Q0TzB2NFE9PSIsInZhbHVlIjoiL2doeVNzMXZITDZvNFZFYjJEYUxZVWVnRDdnRExwOUllYUg5NUVWWWFSZ0FFcVdpWHpLa1pTUTVCcXBZcmVTbHFBdWlOQlBVSXBJMUR0K283UCtEekR6bktyeDFKY3poRzlodkFyV29vcmw5NVhsbFZkaWRLK3laTUkwQ0pWQ2IiLCJtYWMiOiJkZDAwM2Q0ZGQ1N2MwNDAzYjg2NmQ3OTE1OTI2OTM1NmRiYjJjYTA0YmJiNjU0MmI2ZDg2MmY2MzdjZGE2ZTY1IiwidGFnIjoiIn0%3D; lowcostclub_session=eyJpdiI6IjRPdXlUbHFhR0xLOWhDNHNzWnNveGc9PSIsInZhbHVlIjoiTGJvTVlKdERkTkJ4ciszM21EZnVreUFLa3BPeDJCSWp6dnVudlhiWGRHVVB4Zk1idFFCVDJKY2xqcmJkbWJOc20yYzIyM3MrWGtEU3VLWkpiVXNoZFZ6ZC9UWHB2TlAyTllMYXBOQ1dTcnJyN2RXMUlJaksrdXZ3NGpsUzJET0YiLCJtYWMiOiIwYmMwNmQwY2QzYzllNjI1YTk0MmE5YzE5ZjAxNzAyYzM1ODk0ZmU5NTE4N2MxNGUxMWRiOThjMjA0MWMxNDRjIiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6ImRUUmhJV3Q2YWhYZ2k1S0Q0TzB2NFE9PSIsInZhbHVlIjoiL2doeVNzMXZITDZvNFZFYjJEYUxZVWVnRDdnRExwOUllYUg5NUVWWWFSZ0FFcVdpWHpLa1pTUTVCcXBZcmVTbHFBdWlOQ ▶"
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "host" => array:1 [▶
    0 => "d.lowcost.club"
  ]
]

request_cookies

  0 of 0   
array:2 [▼
  "XSRF-TOKEN" => "OA1i52YX2o645QRcTQl00UuBpNfbJT6tHnebLOC4"
  "lowcostclub_session" => "qjby4Jl2fpfmo6f0hpZUqJoPvrOwr0WfbiNaTixB"
]

response_headers

  0 of 0   
array:6 [▼
  "cache-control" => array:1 [▶
    0 => "max-age=604800, public"
  ]
  "date" => array:1 [▶
    0 => "Thu, 08 May 2025 13:56:08 GMT"
  ]
  "etag" => array:1 [▶
    0 => ""1b83788f0a54e0f7782abc38482a3db2""
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ik9tT2g3SXpndjJVcklvSnowbDJuQlE9PSIsInZhbHVlIjoicHpscFVlcDllZEtwNFJHeXFsY2R4dVpPVUlGT2hab3dJVkxHc0FUVGo3RWRiQ2ViS2tuUHByaXkxR2tWVkYydXJCZFJYYnh5N0ZOSS9VWXlDTmgxTjZaWW1tTFZMYWRQY09jSlgvQnVMRkJ1RGVaZDgwNTZRYUNRNlFMMFZ1OGgiLCJtYWMiOiJhYTljZTIzOWVhZTY1ZjFiNGRjYmY3YjkwOTlhOWZlMDU0ZDIxOWQxODhhNzlhNjM4ZGRmODk4MWI3ZTA0ZTI1IiwidGFnIjoiIn0%3D; expires=Thu, 08 May 2025 15:56:08 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6Ik9tT2g3SXpndjJVcklvSnowbDJuQlE9PSIsInZhbHVlIjoicHpscFVlcDllZEtwNFJHeXFsY2R4dVpPVUlGT2hab3dJVkxHc0FUVGo3RWRiQ2ViS2tuUHByaXkxR2tWVkYydXJCZFJYY ▶"
    1 => "lowcostclub_session=eyJpdiI6IjlZUTk5YXFvMmQ0VlhCcUVtT2Q1Q1E9PSIsInZhbHVlIjoiTEE0VSt4NUVsdGZ0TEtMd3Qrc3ZhMG9MUFZYb0dieEM2WWxuTkh4UHozTFpsVnEvZDR4clpqRVVicTJUUkYvN09VU1B2SnVYWjVJbEFmUmYxZFhMSlNVcjhUaU5mQTRxdXVKdDQzaGJFRmNPY1hHdkx4ajlYQlBnaEZJTzJGbUoiLCJtYWMiOiJiYjVlY2QwODk3NGEwN2YwZjVjNzc3YTRiZmU4MjJjZmEwZTVkOTgwNTZmYTQzOGQxNGMyOGEzY2UyOTU5NWY2IiwidGFnIjoiIn0%3D; expires=Thu, 08 May 2025 15:56:08 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀lowcostclub_session=eyJpdiI6IjlZUTk5YXFvMmQ0VlhCcUVtT2Q1Q1E9PSIsInZhbHVlIjoiTEE0VSt4NUVsdGZ0TEtMd3Qrc3ZhMG9MUFZYb0dieEM2WWxuTkh4UHozTFpsVnEvZDR4clpqRVVicTJUUkYv ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ik9tT2g3SXpndjJVcklvSnowbDJuQlE9PSIsInZhbHVlIjoicHpscFVlcDllZEtwNFJHeXFsY2R4dVpPVUlGT2hab3dJVkxHc0FUVGo3RWRiQ2ViS2tuUHByaXkxR2tWVkYydXJCZFJYYnh5N0ZOSS9VWXlDTmgxTjZaWW1tTFZMYWRQY09jSlgvQnVMRkJ1RGVaZDgwNTZRYUNRNlFMMFZ1OGgiLCJtYWMiOiJhYTljZTIzOWVhZTY1ZjFiNGRjYmY3YjkwOTlhOWZlMDU0ZDIxOWQxODhhNzlhNjM4ZGRmODk4MWI3ZTA0ZTI1IiwidGFnIjoiIn0%3D; expires=Thu, 08-May-2025 15:56:08 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Ik9tT2g3SXpndjJVcklvSnowbDJuQlE9PSIsInZhbHVlIjoicHpscFVlcDllZEtwNFJHeXFsY2R4dVpPVUlGT2hab3dJVkxHc0FUVGo3RWRiQ2ViS2tuUHByaXkxR2tWVkYydXJCZFJYY ▶"
    1 => "lowcostclub_session=eyJpdiI6IjlZUTk5YXFvMmQ0VlhCcUVtT2Q1Q1E9PSIsInZhbHVlIjoiTEE0VSt4NUVsdGZ0TEtMd3Qrc3ZhMG9MUFZYb0dieEM2WWxuTkh4UHozTFpsVnEvZDR4clpqRVVicTJUUkYvN09VU1B2SnVYWjVJbEFmUmYxZFhMSlNVcjhUaU5mQTRxdXVKdDQzaGJFRmNPY1hHdkx4ajlYQlBnaEZJTzJGbUoiLCJtYWMiOiJiYjVlY2QwODk3NGEwN2YwZjVjNzc3YTRiZmU4MjJjZmEwZTVkOTgwNTZmYTQzOGQxNGMyOGEzY2UyOTU5NWY2IiwidGFnIjoiIn0%3D; expires=Thu, 08-May-2025 15:56:08 GMT; path=/; httponly ◀lowcostclub_session=eyJpdiI6IjlZUTk5YXFvMmQ0VlhCcUVtT2Q1Q1E9PSIsInZhbHVlIjoiTEE0VSt4NUVsdGZ0TEtMd3Qrc3ZhMG9MUFZYb0dieEM2WWxuTkh4UHozTFpsVnEvZDR4clpqRVVicTJUUkYv ▶"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "OA1i52YX2o645QRcTQl00UuBpNfbJT6tHnebLOC4"
  "_previous" => array:1 [▶
    "url" => "https://d.lowcost.club/cheap-flights-from-alor-setar-to-tokyo-aor-tyo?_url=%2Fcheap-flights-from-alor-setar-to-tokyo-aor-tyo"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-05-08 13:56:08	GET	/cheap-flights-from-alor-setar-to-tokyo-aor-tyo	53 80 468 3

1 x Application (96.63%)	861ms
1 x Booting (3.37%)	30.03ms

Cheap flights Alor Setar — Tokyo (AOR — TYO)

Choose your dates to find the flight:

Good to know - Cheap tickets Alor Setar — Tokyo

Popular airlines flying Alor Setar — Tokyo

Routes from nearby cities to Tokyo

Popular International routes from Alor Setar

Popular routes from Tokyo

Popular domestic routes from Alor Setar

Related pages

Select your currency

All currencies

Select your language

All languages