The most frequent flight to Ontario is from Aguadilla. The cheapest airfare can be purchased with a flight from Saint Thomas from $290. The nearest airports from San Juan with a flight to Ontario are in Punta Cana.

Popular International routes from San Juan

San Juan — Lima

from $138 one-way

San Juan — Frankfurt

from $340 one-way

San Juan — Norfolk

from $150 one-way

San Juan — Worcester

from $179 one-way

San Juan — Orlando

from $40 one-way

Popular routes from Ontario

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

Ontario — Moscow

from $685 one-way

Ontario — Yerevan

from $446 one-way

Ontario — Istanbul

from $439 one-way

Ontario — Saint Petersburg

from $697 one-way

Ontario — Honolulu

from $116 one-way

Popular domestic routes from San Juan

from $39 one-way

from $730 round-trip

from $59 one-way

from $79 one-way

from $427 round-trip

Return flights Ontario – San Juan

Schedule of direct flights San Juan — Ontario

Messages Timeline Exceptions Views51 Route Queries84 Models377 Mails Gate N+1 Queries3 Session Request

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

Booting (25.99ms)time
Application (409ms)time
1 x Application (94.02%)
409ms
1 x Booting (5.98%)
25.99ms

51 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.airlines-columnairlines-column.blade.php#?blade
4x components.routes-listroutes-list.blade.php#?blade
21x 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

84 statements were executed (38 duplicates)Show only duplicates114ms

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#34aviatickets4.2msselect * from `sites_relationships` where `us` = 'cheap-flights-from-san-juan-to-ontario-sju-ont' limit 1

Bindings	0: cheap-flights-from-san-juan-to-ontario-sju-ont
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#125aviatickets960μsselect * from `flights_by` where `flights_by`.`id` = '305906' 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.11msselect * from `cities` where `cities`.`id` = 8758 limit 1

Bindings	0: 8758
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#136aviatickets910μsselect * from `countries` where `countries`.`id` = 188 limit 1

Bindings	0: 188
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.11msselect * from `cities` where `cities`.`id` = 8645 limit 1

Bindings	0: 8645
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#138aviatickets1.05msselect * from `countries` where `countries`.`id` = 92 limit 1

Bindings	0: 92
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#33aviatickets1.67ms

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

Bindings	0: 305906
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.47msselect * 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#42aviatickets2.22ms

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

Bindings	0: 8758 1: 8645 2: 2025-05-04 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.68msselect * from `monthly_price_statistics` where `origin_city_id` = 8758 and `destination_city_id` = 8645 limit 1

Bindings	0: 8758 1: 8645
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#470aviatickets2.36ms

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

Bindings	0: 8758 1: 8645
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#470aviatickets890μsselect * from `airlines` where `airlines`.`id` in (244)

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#502aviatickets2.41msselect distinct `airline_id` from `timetables` where `origin_city_id` = 8758

Bindings	0: 8758
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#502aviatickets1.32msselect distinct `airline_id` from `timetables` where `origin_city_id` = 8645

Bindings	0: 8645
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.56ms

select * from `airlines` where `id` in (24, 49, 296, 476, 513, 926, 2005, 2338, 2464, 3023, 3633, 4340, 4531, 5184, 5238, 68994) order by `name` asc

Bindings	0: 24 1: 49 2: 296 3: 476 4: 513 5: 926 6: 2005 7: 2338 8: 2464 9: 3023 10: 3633 11: 4340 12: 4531 13: 5184 14: 5238 15: 68994
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.32ms

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

Bindings	0: 8758 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.95ms

select * from `flights_by` where `origin_city_id` in (5089, 9162, 1265, 8314, 3806, 5827, 3036, 8810, 6527, 5136) and `destination_city_id` = 8645 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 5089 1: 9162 2: 1265 3: 8314 4: 3806 5: 5827 6: 3036 7: 8810 8: 6527 9: 5136 10: 8645 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.48msselect * from `cities` where `cities`.`id` in (3036, 3806, 5089, 5136, 5827, 8314)

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.32msselect * from `cities` where `cities`.`id` in (8645)

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

select * from `sites_relationships` where `sites_relationships`.`id` in (393922, 466510, 998112, 1034583, 1084423, 1152694)

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

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

Bindings	0: 8758 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 (5089, 9162, 1265, 8314, 3806, 5827, 3036, 8810, 6527, 5136) and `destination_city_id` = 8645 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 5089 1: 9162 2: 1265 3: 8314 4: 3806 5: 5827 6: 3036 7: 8810 8: 6527 9: 5136 10: 8645 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#73aviatickets1.31msselect * from `cities` where `cities`.`id` in (3036, 3806, 5089, 5136, 5827, 8314)

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.16msselect * from `cities` where `cities`.`id` in (8645)

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

select * from `sites_relationships` where `sites_relationships`.`id` in (393922, 466510, 998112, 1034583, 1084423, 1152694)

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#104aviatickets1.16msselect * from `cities` where `cities`.`id` = 5136 limit 1

Bindings	0: 5136
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#558aviatickets1.19ms

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

Bindings	0: 8758 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.86ms

select * from `flights_by` where `origin_city_id` in (5089, 9162, 1265, 8314, 3806, 5827, 3036, 8810, 6527, 5136) and `destination_city_id` = 8645 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 5089 1: 9162 2: 1265 3: 8314 4: 3806 5: 5827 6: 3036 7: 8810 8: 6527 9: 5136 10: 8645 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#73aviatickets1.16msselect * from `cities` where `cities`.`id` in (3036, 3806, 5089, 5136, 5827, 8314)

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

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

select * from `sites_relationships` where `sites_relationships`.`id` in (393922, 466510, 998112, 1034583, 1084423, 1152694)

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#104aviatickets1.39msselect * from `cities` where `cities`.`id` = 5827 limit 1

Bindings	0: 5827
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#558aviatickets1.38ms

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

Bindings	0: 8758 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.93ms

select * from `flights_by` where `origin_city_id` in (5089, 9162, 1265, 8314, 3806, 5827, 3036, 8810, 6527, 5136) and `destination_city_id` = 8645 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 5089 1: 9162 2: 1265 3: 8314 4: 3806 5: 5827 6: 3036 7: 8810 8: 6527 9: 5136 10: 8645 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#73aviatickets1.1msselect * from `cities` where `cities`.`id` in (3036, 3806, 5089, 5136, 5827, 8314)

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#73aviatickets1.08msselect * from `cities` where `cities`.`id` in (8645)

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#73aviatickets950μs

select * from `sites_relationships` where `sites_relationships`.`id` in (393922, 466510, 998112, 1034583, 1084423, 1152694)

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#104aviatickets1.15msselect * from `cities` where `cities`.`id` = 8314 limit 1

Bindings	0: 8314
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#558aviatickets1.15ms

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

Bindings	0: 8758 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 (5089, 9162, 1265, 8314, 3806, 5827, 3036, 8810, 6527, 5136) and `destination_city_id` = 8645 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 5089 1: 9162 2: 1265 3: 8314 4: 3806 5: 5827 6: 3036 7: 8810 8: 6527 9: 5136 10: 8645 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#73aviatickets1.13msselect * from `cities` where `cities`.`id` in (3036, 3806, 5089, 5136, 5827, 8314)

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#73aviatickets950μsselect * from `cities` where `cities`.`id` in (8645)

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#73aviatickets890μs

select * from `sites_relationships` where `sites_relationships`.`id` in (393922, 466510, 998112, 1034583, 1084423, 1152694)

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#104aviatickets1.82msselect * from `cities` where `cities`.`id` = 5827 limit 1

Bindings	0: 5827
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#52aviatickets1.15msselect * from `offers` where `origin_city_id` = 8758 and `destination_city_id` = 8645

Bindings	0: 8758 1: 8645
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#447aviatickets2.71ms

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

Bindings	0: 8758 1: 305906 2: 188 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.09msselect * from `cities` where `cities`.`id` in (8758)

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.05msselect * from `cities` where `cities`.`id` in (8624, 8922, 9221)

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#447aviatickets970μsselect * from `sites_relationships` where `sites_relationships`.`id` in (305907, 305908, 305909)

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` = 8758 and `destination_country_id` <> 188 and (`price_one_way` > 0 or `price` > 0) and `id` not in (305907) order by `revenue` desc limit 2 offset 0

Bindings	0: 8758 1: 188 2: 0 3: 0 4: 305907
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.16msselect * from `cities` where `cities`.`id` in (8758)

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.17msselect * from `cities` where `cities`.`id` in (1949, 3571)

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#412aviatickets870μsselect * from `sites_relationships` where `sites_relationships`.`id` in (305728, 305830)

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.14msselect * from `countries` where `countries`.`id` in (97, 125)

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

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

Bindings	0: 8645 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#149aviatickets2.23msselect * from `cities` where `cities`.`id` in (8645)

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.45msselect * from `cities` where `cities`.`id` in (1811, 2686, 3505, 4081, 8458)

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.09msselect * from `countries` where `countries`.`id` in (92, 124, 134, 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#149aviatickets940μsselect * from `sites_relationships` where `sites_relationships`.`id` in (246104, 246150, 246168, 246185, 246224)

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

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

Bindings	0: 8758 1: 188 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#359aviatickets1msselect * from `cities` where `cities`.`id` in (8758)

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.05msselect * from `cities` where `cities`.`id` in (1265, 3806, 5089, 8314, 9162)

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.53msselect * from `sites_relationships` where `sites_relationships`.`id` in (305634, 305674, 305850, 305937, 306052)

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

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#39aviatickets1.14ms

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

Bindings	0: 8758 1: 8645
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#39aviatickets1.66msselect * from `airports` where `airports`.`id` in (9802)

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#39aviatickets1.5msselect * from `airports` where `airports`.`id` in (6031)

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#39aviatickets970μsselect * from `airlines` where `airlines`.`id` in (244)

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#144aviatickets1.06ms

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

Bindings	0: 8758 1: 8645
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#520aviatickets1.08msselect * from `flights_by` where `origin_city_id` = 8645 and `destination_city_id` = 8758 limit 1

Bindings	0: 8645 1: 8758
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#520aviatickets830μsselect * from `sites_relationships` where `sites_relationships`.`id` in (246313)

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#99aviatickets1.05msselect * from `cities` where `cities`.`id` = 8758 limit 1

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

Bindings	0: 8645
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#28aviatickets1.06msselect * from `cities` where `cities`.`id` = 8758 limit 1

Bindings	0: 8758
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#175aviatickets980μsselect * 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#175aviatickets1.23msselect * 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.09msselect * 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#175aviatickets1.61msselect * 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#175aviatickets1.12msselect * 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#149aviatickets1.79ms

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#149aviatickets1.21msselect * 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.16msselect * 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#149aviatickets1.11msselect * 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#149aviatickets1.1ms

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: 112LocalRoute.php#?
App\Avia\Infrastructure\Model\City: 84City.php#?
App\Avia\Infrastructure\Model\Timetable: 79Timetable.php#?
App\Avia\Infrastructure\Model\SitesRelationship: 63SitesRelationship.php#?
App\Avia\Infrastructure\Model\Country: 18Country.php#?
App\Avia\Infrastructure\Model\Airline: 18Airline.php#?
App\Avia\Infrastructure\Model\Airport: 2Airport.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: CDwLHKcZQunl3xYFrH4pPq6trowyBoxEoc0lsNSD
_previous: array:1 [ "url" => "https://d.lowcost.club/cheap-flights-from-san-juan-to-ontario-sju-ont?_url=%2F...
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/cheap-flights-from-san-juan-to-ontario-sju-ont

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:1 [▼
  "_url" => "/cheap-flights-from-san-juan-to-ontario-sju-ont"
]

request_request

[]

request_headers

  0 of 0   
array:16 [▼
  "cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InRiVG5hWFBGaEh6aFE4a3Z0N3BIQWc9PSIsInZhbHVlIjoia1lmRVNNNEhoRFR6eTNNaitwSEdWcGZaUENZVzEvTUN4OTYvc2dwTXhxYkFxOE1VTW0yWk5ZMHR2cy9iNmllNFg0RHFhTUpSUVNhSThKa3BPMklNVldwRWE0MGc5NVFneEszb01DRncrNWxMUVFuY3lVcEVYM0hIaWdOMEZVRjQiLCJtYWMiOiI5NDE4NWQ0Y2I0MTdlNjQ2NzA5M2JmZTE4MmFlYmFiZjIwYjJkMDdjZGQxY2EwYzkwZTI2ZmRlMTUwMTg2YWE2IiwidGFnIjoiIn0%3D; lowcostclub_session=eyJpdiI6IlpMVkF3ODNLSlo0Uyt2N2pHZXhMZlE9PSIsInZhbHVlIjoiNC9saGxKVFR2Ykl1ZzgzU2o5a0NyWUlHaEtiSGpuMDlHNFlKZ1pHUlE2bWVwaWNUVjZhc0lEMWdEc3dTQXBoNWJhcEdsaThYY0ZYWFF6NTc1OTdwOVpGVmVkUXFTODFhV1J1cnBYV3VPNWdFRG41MW9kRlYyRDNFZkwxS1lJbDEiLCJtYWMiOiJiMGUyOTkwZDlmNDk1NDk2Njg1ZDlkNDhhMmY4YWYxZTBkNzAyMzhjZWE5YTAyMDQ0ODg1YWY3MDFiOTg5ZGIwIiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6InRiVG5hWFBGaEh6aFE4a3Z0N3BIQWc9PSIsInZhbHVlIjoia1lmRVNNNEhoRFR6eTNNaitwSEdWcGZaUENZVzEvTUN4OTYvc2dwTXhxYkFxOE1VTW0yWk5ZMHR2cy9iNmllNFg0RHFhT ▶"
  ]
  "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" => "CDwLHKcZQunl3xYFrH4pPq6trowyBoxEoc0lsNSD"
  "lowcostclub_session" => "O1JAmSVRK0VEuwMhouIss4XWPoEjaRuTLyDmMcKH"
]

response_headers

  0 of 0   
array:6 [▼
  "cache-control" => array:1 [▶
    0 => "max-age=604800, public"
  ]
  "date" => array:1 [▶
    0 => "Tue, 06 May 2025 14:12:18 GMT"
  ]
  "etag" => array:1 [▶
    0 => ""5746de662fff2ca889ed92ad02a5f35c""
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InFzS0pjZE5UbExqMnMzaktVQmJMVFE9PSIsInZhbHVlIjoidnAxK3gxOEFHTkpmQTE0SmRKTm1LajV3UlRpMURuYWdGUHQxUXJnWnZOSTN4TkMwTHA2OWl1TDZON085TkdhZ0NIR0FsbStGY2hwM0lnaEV5ZCsvRGlaZlRDVWZUT2QyUlI2VkdBdmdaZFFCKys3UmtYc1ZCbzQ3WFh2KzZVWmoiLCJtYWMiOiJjYjFhNDNlZmM5Y2RmM2ZhNzFjZDNhMzQzNzkyMDk1ZjRmY2E5YjhiMjY3ZjMwZjRjNDQ4ZmZkOGU4ZmNkYjk2IiwidGFnIjoiIn0%3D; expires=Tue, 06 May 2025 16:12:18 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6InFzS0pjZE5UbExqMnMzaktVQmJMVFE9PSIsInZhbHVlIjoidnAxK3gxOEFHTkpmQTE0SmRKTm1LajV3UlRpMURuYWdGUHQxUXJnWnZOSTN4TkMwTHA2OWl1TDZON085TkdhZ0NIR0Fsb ▶"
    1 => "lowcostclub_session=eyJpdiI6IkQ2Si9BTnM0TEFLdHRpNnhoanFRcXc9PSIsInZhbHVlIjoieDBuT0hvYzFrYzJ1dUVrMWR1ZEVXQVU1dERBUVY1eWd0V2tLb1F2dlpOWk9KdDN0a3FSb3dneURYeTI3NG9QdDB1SkYzeFdmb1JnV05pTEkwcnBiY2NEbGRzbU1TSXRLVWJubDJ5Wi9DY2l2N3o0UkZST0ZEZVR3bGVIZng3N0ciLCJtYWMiOiI5NTcyZTY5YTI0NTA5NjM3MTg0NzUzYWVmNjQ1Nzg4YmRkZDU1Yjk3MWE2YWI1YzdmMzE0ODFlYWI2YTI3YWRhIiwidGFnIjoiIn0%3D; expires=Tue, 06 May 2025 16:12:18 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀lowcostclub_session=eyJpdiI6IkQ2Si9BTnM0TEFLdHRpNnhoanFRcXc9PSIsInZhbHVlIjoieDBuT0hvYzFrYzJ1dUVrMWR1ZEVXQVU1dERBUVY1eWd0V2tLb1F2dlpOWk9KdDN0a3FSb3dneURYeTI3NG9Q ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InFzS0pjZE5UbExqMnMzaktVQmJMVFE9PSIsInZhbHVlIjoidnAxK3gxOEFHTkpmQTE0SmRKTm1LajV3UlRpMURuYWdGUHQxUXJnWnZOSTN4TkMwTHA2OWl1TDZON085TkdhZ0NIR0FsbStGY2hwM0lnaEV5ZCsvRGlaZlRDVWZUT2QyUlI2VkdBdmdaZFFCKys3UmtYc1ZCbzQ3WFh2KzZVWmoiLCJtYWMiOiJjYjFhNDNlZmM5Y2RmM2ZhNzFjZDNhMzQzNzkyMDk1ZjRmY2E5YjhiMjY3ZjMwZjRjNDQ4ZmZkOGU4ZmNkYjk2IiwidGFnIjoiIn0%3D; expires=Tue, 06-May-2025 16:12:18 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6InFzS0pjZE5UbExqMnMzaktVQmJMVFE9PSIsInZhbHVlIjoidnAxK3gxOEFHTkpmQTE0SmRKTm1LajV3UlRpMURuYWdGUHQxUXJnWnZOSTN4TkMwTHA2OWl1TDZON085TkdhZ0NIR0Fsb ▶"
    1 => "lowcostclub_session=eyJpdiI6IkQ2Si9BTnM0TEFLdHRpNnhoanFRcXc9PSIsInZhbHVlIjoieDBuT0hvYzFrYzJ1dUVrMWR1ZEVXQVU1dERBUVY1eWd0V2tLb1F2dlpOWk9KdDN0a3FSb3dneURYeTI3NG9QdDB1SkYzeFdmb1JnV05pTEkwcnBiY2NEbGRzbU1TSXRLVWJubDJ5Wi9DY2l2N3o0UkZST0ZEZVR3bGVIZng3N0ciLCJtYWMiOiI5NTcyZTY5YTI0NTA5NjM3MTg0NzUzYWVmNjQ1Nzg4YmRkZDU1Yjk3MWE2YWI1YzdmMzE0ODFlYWI2YTI3YWRhIiwidGFnIjoiIn0%3D; expires=Tue, 06-May-2025 16:12:18 GMT; path=/; httponly ◀lowcostclub_session=eyJpdiI6IkQ2Si9BTnM0TEFLdHRpNnhoanFRcXc9PSIsInZhbHVlIjoieDBuT0hvYzFrYzJ1dUVrMWR1ZEVXQVU1dERBUVY1eWd0V2tLb1F2dlpOWk9KdDN0a3FSb3dneURYeTI3NG9Q ▶"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "CDwLHKcZQunl3xYFrH4pPq6trowyBoxEoc0lsNSD"
  "_previous" => array:1 [▶
    "url" => "https://d.lowcost.club/cheap-flights-from-san-juan-to-ontario-sju-ont?_url=%2Fcheap-flights-from-san-juan-to-ontario-sju-ont"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-05-06 14:12:18	GET	/cheap-flights-from-san-juan-to-ontario-sju-ont	51 84 377 3

1 x Application (94.02%)	409ms
1 x Booting (5.98%)	25.99ms

Cheap flights San Juan — Ontario (SJU — ONT)

Choose your dates to find the flight:

Good to know - Cheap tickets San Juan — Ontario

Popular airlines flying San Juan — Ontario

Airlines with direct flights

Other airlines flying with transfers

Routes from nearby cities to Ontario

Popular International routes from San Juan

Popular routes from Ontario

Popular domestic routes from San Juan

Related pages

Select your currency

All currencies

Select your language

All languages