Cheap flights Leon — Roxas City (LEN — RXS)

Choose your dates to find the flight:

Good to know - Cheap tickets Leon — Roxas City

Cheapest flight found	$1,473
Flight distance	12027 km

Routes from nearby cities to Roxas City

A flight from a neighbouring city can help you save money on plane tickets.

Bordeaux — Roxas City

from $953 one-way

Madrid — Roxas City

from $791 one-way

Pau — Roxas City

from $847 one-way

The most frequent flight to Roxas City is from Pau. The cheapest airfare can be purchased with a flight from Madrid from $791. The nearest airports from Leon with a flight to Roxas City are in Bordeaux.

Popular International routes from Leon

from $3,555 one-way

from $405 one-way

from $849 one-way

from $1,829 one-way

from $1,474 one-way

Popular routes from Roxas City

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

Roxas City — Bangkok

from $106 one-way

Roxas City — Taveuni

from $1,206 one-way

Roxas City — Mahe Island

from $979 one-way

Roxas City — Vilnius

from $796 one-way

Roxas City — Dushanbe

from $628 one-way

Popular domestic routes from Leon

from $76 one-way

from $122 one-way

from $67 one-way

from $192 one-way

from $147 one-way

Return flights Roxas City – Leon

Messages Timeline Exceptions Views44 Route Queries49 Models107 Mails Gate N+1 Queries Session Request

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

Booting (24.31ms)time
Application (277ms)time
1 x Application (91.94%)
277ms
1 x Booting (8.06%)
24.31ms

44 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
4x components.routes-listroutes-list.blade.php#?blade
18x 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

49 statements were executed (10 duplicates)Show only duplicates52.18ms

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#34aviatickets3.8msselect * from `sites_relationships` where `us` = 'cheap-flights-from-leon-to-roxas-city-len-rxs' limit 1

Bindings	0: cheap-flights-from-leon-to-roxas-city-len-rxs
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#125aviatickets1.07msselect * from `flights_by` where `flights_by`.`id` = '1101955' 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#135aviatickets950μsselect * from `cities` where `cities`.`id` = 3515 limit 1

Bindings	0: 3515
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.04msselect * from `countries` where `countries`.`id` = 23 limit 1

Bindings	0: 23
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#137aviatickets1.09msselect * from `cities` where `cities`.`id` = 5454 limit 1

Bindings	0: 5454
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#138aviatickets930μsselect * from `countries` where `countries`.`id` = 58 limit 1

Bindings	0: 58
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#33aviatickets700μs

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

Bindings	0: 1101955
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#31aviatickets780μsselect * 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#42aviatickets1.08ms

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

Bindings	0: 3515 1: 5454 2: 2025-05-08 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#66aviatickets990μsselect * from `monthly_price_statistics` where `origin_city_id` = 3515 and `destination_city_id` = 5454 limit 1

Bindings	0: 3515 1: 5454
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.04ms

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

Bindings	0: 3515 1: 5454
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#502aviatickets950μsselect distinct `airline_id` from `timetables` where `origin_city_id` = 3515

Bindings	0: 3515
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#502aviatickets910μsselect distinct `airline_id` from `timetables` where `origin_city_id` = 5454

Bindings	0: 5454
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

LocalRouteRepository.php#558aviatickets1.02ms

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

Bindings	0: 3515 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.8ms

select * from `flights_by` where `origin_city_id` in (4762, 5526, 6866, 595, 3476, 3787, 4694, 5132, 768, 3576) and `destination_city_id` = 5454 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 4762 1: 5526 2: 6866 3: 595 4: 3476 5: 3787 6: 4694 7: 5132 8: 768 9: 3576 10: 5454 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#73aviatickets1.05msselect * from `cities` where `cities`.`id` in (768, 3787, 5132)

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#73aviatickets1msselect * from `cities` where `cities`.`id` in (5454)

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#73aviatickets850μsselect * from `sites_relationships` where `sites_relationships`.`id` in (1095345, 1102359, 1105857)

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

CitySqlRepository.php#104aviatickets1.02msselect * from `cities` where `cities`.`id` = 768 limit 1

Bindings	0: 768
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

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

Bindings	0: 3787
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

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

Bindings	0: 5132
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

OfferSqlRepository.php#52aviatickets940μsselect * from `offers` where `origin_city_id` = 3515 and `destination_city_id` = 5454

Bindings	0: 3515 1: 5454
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#447aviatickets1.27ms

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

Bindings	0: 3515 1: 1101955 2: 23 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#447aviatickets910μsselect * from `cities` where `cities`.`id` in (3515)

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.04msselect * from `cities` where `cities`.`id` in (5582, 5822, 5946)

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#447aviatickets740μsselect * from `sites_relationships` where `sites_relationships`.`id` in (1101957, 1101959, 1101960)

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

LocalRoute.php#125aviatickets880μsselect * from `countries` where `countries`.`id` = 143 limit 1

Bindings	0: 143
Backtrace	app/Avia/Infrastructure/Model/LocalRoute.php:125 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Model/LocalRoute.php:122 app/Avia/Infrastructure/Factory/DomainRouteFactory.php:49

LocalRouteRepository.php#412aviatickets1.11ms

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

Bindings	0: 3515 1: 23 2: 0 3: 0 4: 1101957
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#412aviatickets950μsselect * from `cities` where `cities`.`id` in (3515)

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#412aviatickets980μsselect * from `cities` where `cities`.`id` in (1115, 4081)

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#412aviatickets820μsselect * from `sites_relationships` where `sites_relationships`.`id` in (186429, 1151207)

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#412aviatickets860μsselect * from `countries` where `countries`.`id` in (92, 248)

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.47ms

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

Bindings	0: 5454 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.13msselect * from `cities` where `cities`.`id` in (5454)

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.38msselect * from `cities` where `cities`.`id` in (696, 1631, 6561, 8562, 8839)

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.48msselect * from `countries` where `countries`.`id` in (36, 65, 82, 89, 222)

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#149aviatickets990μsselect * from `sites_relationships` where `sites_relationships`.`id` in (472006, 1106757, 1106973, 1107036, 1107060)

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#359aviatickets1.21ms

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

Bindings	0: 3515 1: 23 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.02msselect * from `cities` where `cities`.`id` in (3515)

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.15msselect * from `cities` where `cities`.`id` in (113, 472, 5992, 6543, 9266)

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.06msselect * from `sites_relationships` where `sites_relationships`.`id` in (186413, 186416, 186424, 186439, 186441)

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#359aviatickets910μsselect * from `countries` where `countries`.`id` in (23)

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#39aviatickets870μs

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

Bindings	0: 3515 1: 5454
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#144aviatickets960μs

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

Bindings	0: 3515 1: 5454
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#520aviatickets860μsselect * from `flights_by` where `origin_city_id` = 5454 and `destination_city_id` = 3515 limit 1

Bindings	0: 5454 1: 3515
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#520aviatickets720μsselect * from `sites_relationships` where `sites_relationships`.`id` in (1106841)

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#99aviatickets890μsselect * from `cities` where `cities`.`id` = 3515 limit 1

Bindings	0: 3515
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#547aviatickets810μsselect * from `cities` where `cities`.`id` = 5454 limit 1

Bindings	0: 5454
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#28aviatickets820μsselect * from `cities` where `cities`.`id` = 3515 limit 1

Bindings	0: 3515
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

App\Avia\Infrastructure\Model\City: 31City.php#?
App\Avia\Infrastructure\Model\LocalRoute: 30LocalRoute.php#?
App\Avia\Infrastructure\Model\SitesRelationship: 21SitesRelationship.php#?
App\Avia\Infrastructure\Model\Timetable: 13Timetable.php#?
App\Avia\Infrastructure\Model\Country: 11Country.php#?
App\Avia\Infrastructure\Model\MonthlyPriceStatistic: 1MonthlyPriceStatistic.php#?

_token: Jbukk86RrPo5IvWGjcPmJ3oLDiOOF3INVSW3zGpC
_previous: array:1 [ "url" => "https://d.lowcost.club/cheap-flights-from-leon-to-roxas-city-len-rxs?_url=%2Fc...
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/cheap-flights-from-leon-to-roxas-city-len-rxs

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:1 [▼
  "_url" => "/cheap-flights-from-leon-to-roxas-city-len-rxs"
]

request_request

[]

request_headers

  0 of 0   
array:16 [▼
  "cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ii9uc2VVYnRkYkptN3JxVk91OFNOQ2c9PSIsInZhbHVlIjoidkt3c3VQUDJoLzArNFhxUE93LzM1VEYwWXcrRXdRejcwSURzV2lpekh4WUgwQjNjaG8wWkNRTTVTc1ZaZUU3OUpzTDRlREhBYUhDMEpNRTFFZ3pLK2h4NnJKMHZadFVNR01xejNYeGxYaWlhRkQyKzU1Y1NjaFptaWJRMzVOL0kiLCJtYWMiOiI3YzQwMzU4MTc0ODJlZWFhNTE5OWY4NGMyYjVmMTgyZmE5OGNjMDdlOTMxM2UwZjYxNDlmMDkzMGNmZmViN2ZmIiwidGFnIjoiIn0%3D; lowcostclub_session=eyJpdiI6IjI4eDM2ZnJleE4rUUJyUWhQa29UdEE9PSIsInZhbHVlIjoiV0dJR01WNXFKRVhiSm5tc0JBNjIyL256WlFVUnpNUzdNUmgrNDRTZUphbXR6THVyOGhLb1VLeDJZclh6Y1dod2pOWUk3MDJYaE9WY2wzcFpMUmV4YnI2M0dLMTlEbnB3U2hrS2VmT0JlNWNFdXZSSzlqYmRoeXJ6QkUvK2ZQOWwiLCJtYWMiOiI2NmU5Mzc0NTM1ZDQxYWNhZTdkNmNhNGFmMTA0ZmEzZmU2YjdhNTdlMGY3MDk4ZDY5YjI4YzNhYmJlOTdiMmUxIiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6Ii9uc2VVYnRkYkptN3JxVk91OFNOQ2c9PSIsInZhbHVlIjoidkt3c3VQUDJoLzArNFhxUE93LzM1VEYwWXcrRXdRejcwSURzV2lpekh4WUgwQjNjaG8wWkNRTTVTc1ZaZUU3OUpzTDRlR ▶"
  ]
  "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" => "Jbukk86RrPo5IvWGjcPmJ3oLDiOOF3INVSW3zGpC"
  "lowcostclub_session" => "1tb10xDMKESDdItuHnOMRZT892dVaW9QlR42I8rQ"
]

response_headers

  0 of 0   
array:6 [▼
  "cache-control" => array:1 [▶
    0 => "max-age=604800, public"
  ]
  "date" => array:1 [▶
    0 => "Sat, 10 May 2025 02:19:42 GMT"
  ]
  "etag" => array:1 [▶
    0 => ""32b213c420285e8deb305dd9361e4849""
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjlzRGV0Zzcrbjh0dG90MFdaYXNadVE9PSIsInZhbHVlIjoiOVB0ZlRTUHRMZFdrTTRFMVNBei9SbmNDd1hibXkyblFmeCtITzNYVzNyY2pLd0V6L3BVUzh2ZGRubFZZTUpoanRPRTBwdUpsWkYrYWRnL0cyclhKcmZZVWJCWmxhTVN2NDBsQmZvSFU2SU1sSVBOM2pKTnhnblJvaWZsZG02dEUiLCJtYWMiOiIzZGQ0MTYxMzYwZWQ2ZmYyMzY3ZWJhYWE0OTkzOWEzZjJjMDkzZmQ0MWM3YTRiYjJjMWJlZDI3ZjkxOGE5N2Q3IiwidGFnIjoiIn0%3D; expires=Sat, 10 May 2025 04:19:42 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IjlzRGV0Zzcrbjh0dG90MFdaYXNadVE9PSIsInZhbHVlIjoiOVB0ZlRTUHRMZFdrTTRFMVNBei9SbmNDd1hibXkyblFmeCtITzNYVzNyY2pLd0V6L3BVUzh2ZGRubFZZTUpoanRPRTBwd ▶"
    1 => "lowcostclub_session=eyJpdiI6ImhUSVVxYnA1VlZYMzJWYk5XZERmcEE9PSIsInZhbHVlIjoiRFBUMC8yL0huOG1BcjRQRWl0ZnVCUUhrcXNKcU5oc1QzM1E4NUExRjI1WFNSejJCTUQyWmV6dnBVTUgwMVN5TVROM29QbnJnVUo2VjdVcG41NEpOZmNLa0FaOXVoc0ZFNXJuYzhFV3ZQTlNieERrenJlMXBUTzI1OWNPbzhKc0YiLCJtYWMiOiIzYmE3MDYzZjMwNGZmMTk4MDJjNzIzN2M5ZmQ4NmM5NGJlNWVkYTM3OGZjZjRjYzc2YWFjNjE4NzllNWM3Njg3IiwidGFnIjoiIn0%3D; expires=Sat, 10 May 2025 04:19:42 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀lowcostclub_session=eyJpdiI6ImhUSVVxYnA1VlZYMzJWYk5XZERmcEE9PSIsInZhbHVlIjoiRFBUMC8yL0huOG1BcjRQRWl0ZnVCUUhrcXNKcU5oc1QzM1E4NUExRjI1WFNSejJCTUQyWmV6dnBVTUgwMVN5 ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjlzRGV0Zzcrbjh0dG90MFdaYXNadVE9PSIsInZhbHVlIjoiOVB0ZlRTUHRMZFdrTTRFMVNBei9SbmNDd1hibXkyblFmeCtITzNYVzNyY2pLd0V6L3BVUzh2ZGRubFZZTUpoanRPRTBwdUpsWkYrYWRnL0cyclhKcmZZVWJCWmxhTVN2NDBsQmZvSFU2SU1sSVBOM2pKTnhnblJvaWZsZG02dEUiLCJtYWMiOiIzZGQ0MTYxMzYwZWQ2ZmYyMzY3ZWJhYWE0OTkzOWEzZjJjMDkzZmQ0MWM3YTRiYjJjMWJlZDI3ZjkxOGE5N2Q3IiwidGFnIjoiIn0%3D; expires=Sat, 10-May-2025 04:19:42 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IjlzRGV0Zzcrbjh0dG90MFdaYXNadVE9PSIsInZhbHVlIjoiOVB0ZlRTUHRMZFdrTTRFMVNBei9SbmNDd1hibXkyblFmeCtITzNYVzNyY2pLd0V6L3BVUzh2ZGRubFZZTUpoanRPRTBwd ▶"
    1 => "lowcostclub_session=eyJpdiI6ImhUSVVxYnA1VlZYMzJWYk5XZERmcEE9PSIsInZhbHVlIjoiRFBUMC8yL0huOG1BcjRQRWl0ZnVCUUhrcXNKcU5oc1QzM1E4NUExRjI1WFNSejJCTUQyWmV6dnBVTUgwMVN5TVROM29QbnJnVUo2VjdVcG41NEpOZmNLa0FaOXVoc0ZFNXJuYzhFV3ZQTlNieERrenJlMXBUTzI1OWNPbzhKc0YiLCJtYWMiOiIzYmE3MDYzZjMwNGZmMTk4MDJjNzIzN2M5ZmQ4NmM5NGJlNWVkYTM3OGZjZjRjYzc2YWFjNjE4NzllNWM3Njg3IiwidGFnIjoiIn0%3D; expires=Sat, 10-May-2025 04:19:42 GMT; path=/; httponly ◀lowcostclub_session=eyJpdiI6ImhUSVVxYnA1VlZYMzJWYk5XZERmcEE9PSIsInZhbHVlIjoiRFBUMC8yL0huOG1BcjRQRWl0ZnVCUUhrcXNKcU5oc1QzM1E4NUExRjI1WFNSejJCTUQyWmV6dnBVTUgwMVN5 ▶"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "Jbukk86RrPo5IvWGjcPmJ3oLDiOOF3INVSW3zGpC"
  "_previous" => array:1 [▶
    "url" => "https://d.lowcost.club/cheap-flights-from-leon-to-roxas-city-len-rxs?_url=%2Fcheap-flights-from-leon-to-roxas-city-len-rxs"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-05-10 02:19:42	GET	/cheap-flights-from-leon-to-roxas-city-len-rxs	44 49 107

1 x Application (91.94%)	277ms
1 x Booting (8.06%)	24.31ms

Cheap flights Leon — Roxas City (LEN — RXS)

Choose your dates to find the flight:

Good to know - Cheap tickets Leon — Roxas City

Routes from nearby cities to Roxas City

Popular International routes from Leon

Popular routes from Roxas City

Popular domestic routes from Leon

Related pages

Select your currency

All currencies

Select your language

All languages