Cheap flights Vancouver — Caticlan (YVR — MPH)

Good to know - Cheap tickets Vancouver — Caticlan

Flight distance 10729 km
Round-trip from $1,266

Airfare Vancouver – Caticlan by month

Here you can find out in what months how much a ticket Vancouver – Caticlan costs to buy cheap plane tickets.

Month One-way Round-trip
October 2024

Remember that the optimal time for booking air tickets is 59 days before the departure date, this is the average time at which air tickets were sold at the lowest prices.

Popular airlines flying Vancouver — Caticlan

Flight Vancouver – Caticlan is served by 1 airlines.

Flights Vancouver — Caticlan

The selection of cheap flights Vancouver — Caticlan

The price of the flight Vancouver — Caticlan (Philippines) — Vancouver from $1,266 (round-trip).

The average price of the flight Vancouver — Caticlan (Philippines) — Vancouver $1,266 (round-trip).

Low cost flights Vancouver — Caticlan (YVR — MPH)

The distance between Vancouver and Caticlan 6667 miles (or 10729 kilometres).

The time difference between Vancouver and Caticlan is 15 h.

Routes from nearby cities to Caticlan

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

Comox — Caticlan

The closest airports to Vancouver with a flight to Caticlan are in Comox.

Popular International routes from Vancouver

Popular routes from Caticlan

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

Popular domestic routes from Vancouver

FAQ about Vancouver — Caticlan

Yes, you can fly from Vancouver to Caticlan. Vancouver has 3 airports (Boundary Bay Airport, Vancouver International Airport, Coal Harbour Sea Plane Base) for flights. There is a non-direct flight through Philippine Airlines.

The price of flights Vancouver — Caticlan starts from $1,266.

In Vancouver — Boundary Bay Airport, Vancouver International Airport, Coal Harbour Sea Plane Base. In Caticlan — Boracay Airport.

High season is considered to be and the cheapest month is . Enter your preferred airports (or cities) and dates into the search form above to unlock the latest Vancouver — Caticlan flight deals.

All the following airlines flights Vancouver — Caticlan: Philippine Airlines.

Low price calendar

We use cookies and similar technologies for different purposes. Read the privacy policy. If you use the site you agree to them.

Request history8.3.0PHP Version416msRequest Duration4MBMemory UsageGET cheap-flights-from-{slug}Route
    • Booting (26.11ms)time
    • Application (390ms)time
    • 1 x Application (93.72%)
      390ms
      1 x Booting (6.28%)
      26.11ms
      48 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.section-MonthlyPricesection-MonthlyPrice.blade.php#?blade
      • 1x routes.section-timetablesection-timetable.blade.php#?blade
      • 1x routes.AirlinesListAirlinesList.blade.php#?blade
      • 1x components.airlines-columnairlines-column.blade.php#?blade
      • 1x routes.section-DynamicsAirfaresection-DynamicsAirfare.blade.php#?blade
      • 4x components.routes-listroutes-list.blade.php#?blade
      • 16x components.routeListItemrouteListItem.blade.php#?blade
      • 1x routes.description-nearbyCitiesdescription-nearbyCities.blade.php#?blade
      • 2x components.routes-columnroutes-column.blade.php#?blade
      • 1x components.faqfaq.blade.php#?blade
      • 1x components.calendarcalendar.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
      57 statements were executed (17 duplicates)Show only duplicates123ms
      • 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.15msselect * from `sites_relationships` where `us` = 'cheap-flights-from-vancouver-to-caticlan-yvr-mph' limit 1
        Bindings
        • 0: cheap-flights-from-vancouver-to-caticlan-yvr-mph
        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#125aviatickets990μsselect * from `flights_by` where `flights_by`.`id` = '373212' 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.01msselect * from `cities` where `cities`.`id` = 8893 limit 1
        Bindings
        • 0: 8893
        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#136aviatickets2.63msselect * from `countries` where `countries`.`id` = 6 limit 1
        Bindings
        • 0: 6
        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#137aviatickets2.24msselect * from `cities` where `cities`.`id` = 9235 limit 1
        Bindings
        • 0: 9235
        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#138aviatickets870μ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#33aviatickets910μsselect * from `sites_relationships` where `sites_relationships`.`id` = 373212 and `sites_relationships`.`id` is not null limit 1
        Bindings
        • 0: 373212
        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#31aviatickets6.84msselect * 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.2msselect `depart_date`, `return_date`, `number_of_changes`, `value` from `flights_2025` where `origin_id` = 8893 and `destination_id` = 9235 and `date_update` >= '2025-04-26 00:00:00' order by `value` asc limit 10
        Bindings
        • 0: 8893
        • 1: 9235
        • 2: 2025-04-26 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#66aviatickets970μsselect * from `monthly_price_statistics` where `origin_city_id` = 8893 and `destination_city_id` = 9235 limit 1
        Bindings
        • 0: 8893
        • 1: 9235
        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#470aviatickets970μsselect * from `timetables` where `origin_city_id` = 8893 and `destination_city_id` = 9235 order by `time_origin` asc limit 1000
        Bindings
        • 0: 8893
        • 1: 9235
        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#502aviatickets1.15msselect distinct `airline_id` from `timetables` where `origin_city_id` = 8893
        Bindings
        • 0: 8893
        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.05msselect distinct `airline_id` from `timetables` where `origin_city_id` = 9235
        Bindings
        • 0: 9235
        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#90aviatickets860μsselect * from `airlines` where `id` in (3941) order by `name` asc
        Bindings
        • 0: 3941
        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.27msselect destination_city_id from `flights_by` where `origin_city_id` = 8893 and `distance` between 1 and 1000 and (`price_one_way` > 0 or `price` > 0) order by `distance` asc limit 10
        Bindings
        • 0: 8893
        • 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.21msselect * from `flights_by` where `origin_city_id` in (7994, 8312, 8898, 7293, 4796, 7097, 5531, 7197, 7382, 7225) and `destination_city_id` = 9235 and (`price_one_way` > 0 or `price` > 0) limit 10
        Bindings
        • 0: 7994
        • 1: 8312
        • 2: 8898
        • 3: 7293
        • 4: 4796
        • 5: 7097
        • 6: 5531
        • 7: 7197
        • 8: 7382
        • 9: 7225
        • 10: 9235
        • 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.66msselect * from `cities` where `cities`.`id` in (7293)
        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.42msselect * from `cities` where `cities`.`id` in (9235)
        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#73aviatickets4.18msselect * from `sites_relationships` where `sites_relationships`.`id` in (1173162)
        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#104aviatickets3.39msselect * from `cities` where `cities`.`id` = 7293 limit 1
        Bindings
        • 0: 7293
        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
      • OfferSqlRepository.php#52aviatickets1.9msselect * from `offers` where `origin_city_id` = 8893 and `destination_city_id` = 9235
        Bindings
        • 0: 8893
        • 1: 9235
        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#447aviatickets3.12msselect * from `flights_by` where `origin_city_id` = 8893 and `id` > 373212 and `destination_country_id` <> 6 and (`price_one_way` > 0 or `price` > 0) order by `id` asc limit 3
        Bindings
        • 0: 8893
        • 1: 373212
        • 2: 6
        • 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.77msselect * from `cities` where `cities`.`id` in (8893)
        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#447aviatickets4.48msselect * from `cities` where `cities`.`id` in (4146, 4148, 8575)
        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#447aviatickets2.38msselect * from `sites_relationships` where `sites_relationships`.`id` in (373214, 373215, 373216)
        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#125aviatickets1.19msselect * from `countries` where `countries`.`id` = 213 limit 1
        Bindings
        • 0: 213
        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.3msselect * from `flights_by` where `origin_city_id` = 8893 and `destination_country_id` <> 6 and (`price_one_way` > 0 or `price` > 0) and `id` not in (373214) order by `revenue` desc limit 2 offset 0
        Bindings
        • 0: 8893
        • 1: 6
        • 2: 0
        • 3: 0
        • 4: 373214
        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#412aviatickets2.13msselect * from `cities` where `cities`.`id` in (8893)
        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#412aviatickets2.26msselect * from `cities` where `cities`.`id` in (2686, 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#412aviatickets1.19msselect * from `sites_relationships` where `sites_relationships`.`id` in (373095, 373211)
        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 `countries` where `countries`.`id` in (134, 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.25msselect * from `flights_by` where `origin_city_id` = 9235 and (`price_one_way` > 0 or `price` > 0) and 1 = 1 order by `revenue` desc limit 5
        Bindings
        • 0: 9235
        • 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.9msselect * from `cities` where `cities`.`id` in (9235)
        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.43msselect * from `cities` where `cities`.`id` in (1058, 3505, 4051, 4081, 8390)
        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.5msselect * from `countries` where `countries`.`id` in (58, 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#149aviatickets2.09msselect * from `sites_relationships` where `sites_relationships`.`id` in (219596, 219626, 219634, 219635, 450244)
        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.65msselect * from `flights_by` where `origin_city_id` = 8893 and `destination_country_id` = 6 and (`price_one_way` > 0 or `price` > 0) order by `revenue` desc limit 5 offset 0
        Bindings
        • 0: 8893
        • 1: 6
        • 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#359aviatickets6.77msselect * from `cities` where `cities`.`id` in (8893)
        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.87msselect * from `cities` where `cities`.`id` in (7241, 7268, 7344, 9245, 9291)
        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#359aviatickets3.57msselect * from `sites_relationships` where `sites_relationships`.`id` in (373507, 373511, 373513, 373529, 373543)
        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#359aviatickets830μsselect * from `countries` where `countries`.`id` in (6)
        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.19msselect * from `timetables` where `origin_city_id` = 8893 and `destination_city_id` = 9235 order by `time_origin` asc limit 10
        Bindings
        • 0: 8893
        • 1: 9235
        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.15msselect * from `timetables` where `origin_city_id` = 8893 and `destination_city_id` = 9235 order by `travel_time` asc limit 1
        Bindings
        • 0: 8893
        • 1: 9235
        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.32msselect * from `flights_by` where `origin_city_id` = 9235 and `destination_city_id` = 8893 limit 1
        Bindings
        • 0: 9235
        • 1: 8893
        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#520aviatickets960μsselect * from `sites_relationships` where `sites_relationships`.`id` in (840626)
        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.08msselect * from `cities` where `cities`.`id` = 8893 limit 1
        Bindings
        • 0: 8893
        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#547aviatickets1.33msselect * from `cities` where `cities`.`id` = 9235 limit 1
        Bindings
        • 0: 9235
        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
      • City.php#136aviatickets2.17msselect * from `airports` where `airports`.`city_id` = 8893 and `airports`.`city_id` is not null and `is_active` = 1 and `is_active` = '1'
        Bindings
        • 0: 8893
        • 1: 1
        • 2: 1
        Backtrace
        • app/Avia/Infrastructure/Model/City.php:136
        • view::routes.view:95
        • 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
      • City.php#136aviatickets1.62msselect * from `airports` where `airports`.`city_id` = 9235 and `airports`.`city_id` is not null and `is_active` = 1 and `is_active` = '1'
        Bindings
        • 0: 9235
        • 1: 1
        • 2: 1
        Backtrace
        • app/Avia/Infrastructure/Model/City.php:136
        • view::routes.view:122
        • 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
      • description-nearbyCities.blade.php#32aviatickets2.38msselect * from `cities` where `cities`.`id` = 9235 limit 1
        Bindings
        • 0: 9235
        Backtrace
        • view::routes.description-nearbyCities:32
        • 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
      • description-nearbyCities.blade.php#32aviatickets2.84msselect * from `cities` where `cities`.`id` = 8893 limit 1
        Bindings
        • 0: 8893
        Backtrace
        • view::routes.description-nearbyCities:32
        • 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
      • FlightSqlRepository.php#98aviatickets1.04msselect * from `timetables` where `origin_city_id` = 8893 and `destination_city_id` = 9235
        Bindings
        • 0: 8893
        • 1: 9235
        Backtrace
        • app/Avia/Infrastructure/Repository/FlightSqlRepository.php:98
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/FlightSqlRepository.php:104
        • app/Avia/Infrastructure/FaqRouteFactory/AreThereDirectFlights.php:21
      • CanWeFlyFromTo.php#30aviatickets1.14msselect * from `airports` where `airports`.`city_id` = 8893 and `airports`.`city_id` is not null and `is_active` = 1
        Bindings
        • 0: 8893
        • 1: 1
        Backtrace
        • app/Avia/Infrastructure/FaqRouteFactory/CanWeFlyFromTo.php:30
        • app/Avia/Domain/Faq/FaqRouteAggregate.php:32
        • app/View/Components/FaqRoute.php:39
        • vendor/laravel/framework/src/Illuminate/View/Component.php:135
        • view::routes.view:305
      • CanWeFlyFromTo.php#35aviatickets1.57msselect * from `airports` where `airports`.`city_id` = 9235 and `airports`.`city_id` is not null and `is_active` = 1
        Bindings
        • 0: 9235
        • 1: 1
        Backtrace
        • app/Avia/Infrastructure/FaqRouteFactory/CanWeFlyFromTo.php:35
        • app/Avia/Domain/Faq/FaqRouteAggregate.php:32
        • app/View/Components/FaqRoute.php:39
        • vendor/laravel/framework/src/Illuminate/View/Component.php:135
        • view::routes.view:305
      • TimetableRepository.php#39aviatickets1.69msselect * from `timetables` where `origin_city_id` = 8893 and `destination_city_id` = 9235 order by `time_origin` asc limit 1000
        Bindings
        • 0: 8893
        • 1: 9235
        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/Avia/Infrastructure/FaqRouteFactory/CanWeFlyFromTo.php:42
      • TimetableRepository.php#144aviatickets2.33msselect * from `timetables` where `origin_city_id` = 8893 and `destination_city_id` = 9235 order by `travel_time` asc limit 1
        Bindings
        • 0: 8893
        • 1: 9235
        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/Avia/Infrastructure/FaqRouteFactory/HowLongDoesItTakeToFly.php:27
      • MonthlyPriceStatisticSqlRepository.php#66aviatickets2.16msselect * from `monthly_price_statistics` where `origin_city_id` = 8893 and `destination_city_id` = 9235 limit 1
        Bindings
        • 0: 8893
        • 1: 9235
        Backtrace
        • app/Avia/Infrastructure/Repository/MonthlyPriceStatisticSqlRepository.php:66
        • app/Avia/Infrastructure/Repository/MonthlyPriceStatisticSqlRepository.php:44
        • app/Avia/Infrastructure/FaqRouteFactory/WhatMonthCheapest.php:27
        • app/Avia/Domain/Faq/FaqRouteAggregate.php:32
        • app/View/Components/FaqRoute.php:39
      App\Avia\Infrastructure\Model\Timetable
      59Timetable.php#?
      App\Avia\Infrastructure\Model\LocalRoute
      28LocalRoute.php#?
      App\Avia\Infrastructure\Model\City
      28City.php#?
      App\Avia\Infrastructure\Model\SitesRelationship
      19SitesRelationship.php#?
      App\Avia\Infrastructure\Model\Country
      8Country.php#?
      App\Avia\Infrastructure\Model\Airport
      8Airport.php#?
      App\Avia\Infrastructure\Model\MonthlyPriceStatistic
      2MonthlyPriceStatistic.php#?
      App\Avia\Infrastructure\Model\Airline
      1Airline.php#?
          • infoModel: App\Avia\Infrastructure\Model\City => Relation: App\Avia\Infrastructure\Model\Airport - You s...
          _token
          VDmiqAbAShflPK6b23dCD3E2HeOAkhvfKyDp5O1B
          _previous
          array:1 [ "url" => "https://d.lowcost.club/cheap-flights-from-vancouver-to-caticlan-yvr-mph?_url=%...
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /cheap-flights-from-vancouver-to-caticlan-yvr-mph
          status_code
          200
          
          status_text
          OK
          format
          html
          content_type
          text/html; charset=UTF-8
          request_query
          0 of 0
          array:1 [ "_url" => "/cheap-flights-from-vancouver-to-caticlan-yvr-mph" ]
          request_request
          []
          
          request_headers
          0 of 0
          array:15 [ "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 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "host" => array:1 [ 0 => "d.lowcost.club" ] ]
          request_cookies
          []
          
          response_headers
          0 of 0
          array:6 [ "cache-control" => array:1 [ 0 => "max-age=604800, public" ] "date" => array:1 [ 0 => "Mon, 28 Apr 2025 18:50:16 GMT" ] "etag" => array:1 [ 0 => ""bf36dc5d626c6e5902da676c557e1616"" ] "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImRrbEpZbnVocmwzQTVkMkNodWwyZEE9PSIsInZhbHVlIjoieldZcTkrV053QmQrOFpYTTRBKzB2WlY1WEZ2c3FOU1pDU3VzQjlLaHJ4YWFHLzJFUllQeTg1YmFaYWFycVdpQXBGZWk2VVB2c1VPRnV0NWd3WHM1MVJuQXBYTnBWbjJFMTIycll2eVJ0MUtCL0ZXYXgrcm5od2VDZVBBVHozL1kiLCJtYWMiOiJlODU4MGRmMDk0ZmFlMzBjZjJkNTVhYzY0NWUxMjViMGNkNWFmMTAwMzFmNTBiZTdjZmFmMjE3OWVmNjZiNGY5IiwidGFnIjoiIn0%3D; expires=Mon, 28 Apr 2025 20:50:16 GMT; Max-Age=7200; path=/; samesite=laxXSRF-TOKEN=eyJpdiI6ImRrbEpZbnVocmwzQTVkMkNodWwyZEE9PSIsInZhbHVlIjoieldZcTkrV053QmQrOFpYTTRBKzB2WlY1WEZ2c3FOU1pDU3VzQjlLaHJ4YWFHLzJFUllQeTg1YmFaYWFycVdpQXBGZWk2V" 1 => "lowcostclub_session=eyJpdiI6InRzc3p4TlJEZ2d5RVh6Sk91WnNvY0E9PSIsInZhbHVlIjoiZVdicER1cE04SFdMMjdNdzc2bVlCdDNKMmNEblhTand5eUtvbWZnYndJUzFBcW9WTmYyRDJEZ256MVlkTUNKL0l3Y1NQTEYvRkxYeDdrMnZsa1hOM3ZuVHlxeG9QZndBSktpQTJkNW1MbGN2b1A3LzhBQi9oNEVuby9lVEtMbUwiLCJtYWMiOiI1ZmQwMGZhMDZkNDk1NmIzYzhmOTk3MDhlODBhNjgxYmQ0ZTFhMWJhNmU2ZDMzZmE0YTA2MWJkNzEwZDU1NTMwIiwidGFnIjoiIn0%3D; expires=Mon, 28 Apr 2025 20:50:16 GMT; Max-Age=7200; path=/; httponly; samesite=laxlowcostclub_session=eyJpdiI6InRzc3p4TlJEZ2d5RVh6Sk91WnNvY0E9PSIsInZhbHVlIjoiZVdicER1cE04SFdMMjdNdzc2bVlCdDNKMmNEblhTand5eUtvbWZnYndJUzFBcW9WTmYyRDJEZ256MVlkTUNK" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImRrbEpZbnVocmwzQTVkMkNodWwyZEE9PSIsInZhbHVlIjoieldZcTkrV053QmQrOFpYTTRBKzB2WlY1WEZ2c3FOU1pDU3VzQjlLaHJ4YWFHLzJFUllQeTg1YmFaYWFycVdpQXBGZWk2VVB2c1VPRnV0NWd3WHM1MVJuQXBYTnBWbjJFMTIycll2eVJ0MUtCL0ZXYXgrcm5od2VDZVBBVHozL1kiLCJtYWMiOiJlODU4MGRmMDk0ZmFlMzBjZjJkNTVhYzY0NWUxMjViMGNkNWFmMTAwMzFmNTBiZTdjZmFmMjE3OWVmNjZiNGY5IiwidGFnIjoiIn0%3D; expires=Mon, 28-Apr-2025 20:50:16 GMT; path=/XSRF-TOKEN=eyJpdiI6ImRrbEpZbnVocmwzQTVkMkNodWwyZEE9PSIsInZhbHVlIjoieldZcTkrV053QmQrOFpYTTRBKzB2WlY1WEZ2c3FOU1pDU3VzQjlLaHJ4YWFHLzJFUllQeTg1YmFaYWFycVdpQXBGZWk2V" 1 => "lowcostclub_session=eyJpdiI6InRzc3p4TlJEZ2d5RVh6Sk91WnNvY0E9PSIsInZhbHVlIjoiZVdicER1cE04SFdMMjdNdzc2bVlCdDNKMmNEblhTand5eUtvbWZnYndJUzFBcW9WTmYyRDJEZ256MVlkTUNKL0l3Y1NQTEYvRkxYeDdrMnZsa1hOM3ZuVHlxeG9QZndBSktpQTJkNW1MbGN2b1A3LzhBQi9oNEVuby9lVEtMbUwiLCJtYWMiOiI1ZmQwMGZhMDZkNDk1NmIzYzhmOTk3MDhlODBhNjgxYmQ0ZTFhMWJhNmU2ZDMzZmE0YTA2MWJkNzEwZDU1NTMwIiwidGFnIjoiIn0%3D; expires=Mon, 28-Apr-2025 20:50:16 GMT; path=/; httponlylowcostclub_session=eyJpdiI6InRzc3p4TlJEZ2d5RVh6Sk91WnNvY0E9PSIsInZhbHVlIjoiZVdicER1cE04SFdMMjdNdzc2bVlCdDNKMmNEblhTand5eUtvbWZnYndJUzFBcW9WTmYyRDJEZ256MVlkTUNK" ] ]
          session_attributes
          0 of 0
          array:3 [ "_token" => "VDmiqAbAShflPK6b23dCD3E2HeOAkhvfKyDp5O1B" "_previous" => array:1 [ "url" => "https://d.lowcost.club/cheap-flights-from-vancouver-to-caticlan-yvr-mph?_url=%2Fcheap-flights-from-vancouver-to-caticlan-yvr-mph" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
          ClearShow all
          Date ↕MethodURLData
          #12025-04-28 18:50:16GET/cheap-flights-from-vancouver-to-caticlan-yvr-mph48571531