Cheap flights Denpasar — Surabaya (DPS — SUB)

Good to know - Cheap tickets Denpasar — Surabaya

Cheapest flight found $26
Minimal flight time 35m
Flight distance 303 km
Most popular airline Lion Air

Sales of tickets from Denpasar to Surabaya in the last 48 hours

Routes from nearby cities to Surabaya

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

The most frequent flight to Surabaya is from Labuan Bajo. The cheapest airfare can be purchased with a flight from Praya from $40. The nearest airports from Denpasar with a flight to Surabaya are in Malang.

Popular International routes from Denpasar

Popular routes from Surabaya

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

Popular domestic routes from Denpasar

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 Version359msRequest Duration4MBMemory UsageGET cheap-flights-from-{slug}Route
    • Booting (21.75ms)time
    • Application (337ms)time
    • 1 x Application (93.93%)
      337ms
      1 x Booting (6.06%)
      21.75ms
      57 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
      • 6x components.airlines-columnairlines-column.blade.php#?blade
      • 1x routes.LastSales48LastSales48.blade.php#?blade
      • 1x components.last-sales-48-recordslast-sales-48-records.blade.php#?blade
      • 4x components.routes-listroutes-list.blade.php#?blade
      • 23x 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
      53 statements were executed (12 duplicates)Show only duplicates86.53ms
      • QueryDetector.php#25aviaticketsConnection Established
        Backtrace
        • vendor/beyondcode/laravel-query-detector/src/QueryDetector.php:25
        • vendor/beyondcode/laravel-query-detector/src/QueryDetectorMiddleware.php:30
        • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
        • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
        • app/Http/Middleware/MinifyHtml.php:21
      • SitesRelationshipsSqlRepository.php#34aviatickets3.87msselect * from `sites_relationships` where `us` = 'cheap-flights-from-denpasar-to-surabaya-dps-sub' limit 1
        Bindings
        • 0: cheap-flights-from-denpasar-to-surabaya-dps-sub
        Backtrace
        • app/Avia/Infrastructure/SitesRelationships/SitesRelationshipsSqlRepository.php:34
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/SitesRelationships/SitesRelationshipsSqlRepository.php:31
        • app/Http/Controllers/RoutesController.php:113
      • RoutesController.php#125aviatickets1.05msselect * from `flights_by` where `flights_by`.`id` = '90512' 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.18msselect * from `cities` where `cities`.`id` = 1574 limit 1
        Bindings
        • 0: 1574
        Backtrace
        • app/Http/Controllers/RoutesController.php:135
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • RoutesController.php#136aviatickets1.08msselect * from `countries` where `countries`.`id` = 114 limit 1
        Bindings
        • 0: 114
        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.15msselect * from `cities` where `cities`.`id` = 5833 limit 1
        Bindings
        • 0: 5833
        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.32msselect * from `countries` where `countries`.`id` = 114 limit 1
        Bindings
        • 0: 114
        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#33aviatickets2.03msselect * from `sites_relationships` where `sites_relationships`.`id` = 90512 and `sites_relationships`.`id` is not null limit 1
        Bindings
        • 0: 90512
        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.13msselect * 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#42aviatickets5.71msselect `depart_date`, `return_date`, `number_of_changes`, `value` from `flights_2025` where `origin_id` = 1574 and `destination_id` = 5833 and `date_update` >= '2025-05-01 00:00:00' order by `value` asc limit 10
        Bindings
        • 0: 1574
        • 1: 5833
        • 2: 2025-05-01 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#66aviatickets4.05msselect * from `monthly_price_statistics` where `origin_city_id` = 1574 and `destination_city_id` = 5833 limit 1
        Bindings
        • 0: 1574
        • 1: 5833
        Backtrace
        • app/Avia/Infrastructure/Repository/MonthlyPriceStatisticSqlRepository.php:66
        • app/Avia/Infrastructure/Repository/MonthlyPriceStatisticSqlRepository.php:50
        • app/Avia/Application/PriceHandler.php:42
        • app/Http/Controllers/RoutesController.php:156
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • AirlineSqlRepository.php#470aviatickets1.58msselect * from `timetables` where `origin_city_id` = 1574 and `destination_city_id` = 5833 order by `time_origin` asc limit 1000
        Bindings
        • 0: 1574
        • 1: 5833
        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#470aviatickets1.12msselect * from `airlines` where `airlines`.`id` in (2516, 2852, 3284, 19935, 21440, 158278)
        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.46msselect distinct `airline_id` from `timetables` where `origin_city_id` = 1574
        Bindings
        • 0: 1574
        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.62msselect distinct `airline_id` from `timetables` where `origin_city_id` = 5833
        Bindings
        • 0: 5833
        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#90aviatickets3.25msselect * from `airlines` where `id` in (574, 1676, 1763, 3015, 3046, 3371, 4419, 4438, 4517, 4914, 5894, 17852, 20024, 157933) order by `name` asc
        Bindings
        • 0: 574
        • 1: 1676
        • 2: 1763
        • 3: 3015
        • 4: 3046
        • 5: 3371
        • 6: 4419
        • 7: 4438
        • 8: 4517
        • 9: 4914
        • 10: 5894
        • 11: 17852
        • 12: 20024
        • 13: 157933
        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.17msselect destination_city_id from `flights_by` where `origin_city_id` = 1574 and `distance` between 1 and 1000 and (`price_one_way` > 0 or `price` > 0) order by `distance` asc limit 10
        Bindings
        • 0: 1574
        • 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#73aviatickets3.2msselect * from `flights_by` where `origin_city_id` in (9431, 8069, 5877, 8563, 5833, 742, 8832, 8803, 3455, 2815) and `destination_city_id` = 5833 and (`price_one_way` > 0 or `price` > 0) limit 10
        Bindings
        • 0: 9431
        • 1: 8069
        • 2: 5877
        • 3: 8563
        • 4: 5833
        • 5: 742
        • 6: 8832
        • 7: 8803
        • 8: 3455
        • 9: 2815
        • 10: 5833
        • 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#73aviatickets7.16msselect * from `cities` where `cities`.`id` in (2815, 3455, 5877, 8069, 8563, 8803, 8832, 9431)
        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#73aviatickets990μsselect * from `cities` where `cities`.`id` in (5833)
        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#73aviatickets970μsselect * from `sites_relationships` where `sites_relationships`.`id` in (156778, 182305, 193463, 214064, 310019, 482420, 486389, 1054153)
        Backtrace
        • app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:73
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:58
        • app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:35
      • CitySqlRepository.php#104aviatickets1.1msselect * from `cities` where `cities`.`id` = 8563 limit 1
        Bindings
        • 0: 8563
        Backtrace
        • app/Avia/Infrastructure/City/CitySqlRepository.php:104
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/City/CitySqlRepository.php:101
        • app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:97
      • CitySqlRepository.php#104aviatickets1.28msselect * from `cities` where `cities`.`id` = 8069 limit 1
        Bindings
        • 0: 8069
        Backtrace
        • app/Avia/Infrastructure/City/CitySqlRepository.php:104
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/City/CitySqlRepository.php:101
        • app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:158
      • CitySqlRepository.php#104aviatickets1.15msselect * from `cities` where `cities`.`id` = 3455 limit 1
        Bindings
        • 0: 3455
        Backtrace
        • app/Avia/Infrastructure/City/CitySqlRepository.php:104
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/City/CitySqlRepository.php:101
        • app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:131
      • OfferSqlRepository.php#52aviatickets970μsselect * from `offers` where `origin_city_id` = 1574 and `destination_city_id` = 5833
        Bindings
        • 0: 1574
        • 1: 5833
        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.47msselect * from `flights_by` where `origin_city_id` = 1574 and `id` > 90512 and `destination_country_id` <> 114 and (`price_one_way` > 0 or `price` > 0) order by `id` asc limit 3
        Bindings
        • 0: 1574
        • 1: 90512
        • 2: 114
        • 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#447aviatickets780μsselect * from `cities` where `cities`.`id` in (1574)
        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#447aviatickets1msselect * from `cities` where `cities`.`id` in (6940, 8522, 9279)
        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#447aviatickets860μsselect * from `sites_relationships` where `sites_relationships`.`id` in (90513, 90514, 90515)
        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.23msselect * from `flights_by` where `origin_city_id` = 1574 and `destination_country_id` <> 114 and (`price_one_way` > 0 or `price` > 0) and `id` not in (90513) order by `revenue` desc limit 2 offset 0
        Bindings
        • 0: 1574
        • 1: 114
        • 2: 0
        • 3: 0
        • 4: 90513
        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.02msselect * from `cities` where `cities`.`id` in (1574)
        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#412aviatickets960μsselect * from `cities` where `cities`.`id` in (3505, 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#412aviatickets910μsselect * from `sites_relationships` where `sites_relationships`.`id` in (90306, 90364)
        Backtrace
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:412
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:417
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:209
      • LocalRouteRepository.php#412aviatickets950μsselect * from `countries` where `countries`.`id` in (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.31msselect * from `flights_by` where `origin_city_id` = 5833 and (`price_one_way` > 0 or `price` > 0) and 1 = 1 order by `revenue` desc limit 5
        Bindings
        • 0: 5833
        • 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#149aviatickets840μsselect * from `cities` where `cities`.`id` in (5833)
        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.06msselect * from `cities` where `cities`.`id` in (1934, 2354, 2761, 4081, 9069)
        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#149aviatickets980μsselect * from `countries` where `countries`.`id` in (70, 94, 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#149aviatickets980μsselect * from `sites_relationships` where `sites_relationships`.`id` in (316551, 316591, 481616, 481622, 481647)
        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.82msselect * from `flights_by` where `origin_city_id` = 1574 and `destination_country_id` = 114 and (`price_one_way` > 0 or `price` > 0) order by `revenue` desc limit 5 offset 0
        Bindings
        • 0: 1574
        • 1: 114
        • 2: 0
        • 3: 0
        Backtrace
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:359
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:363
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:330
      • LocalRouteRepository.php#359aviatickets1.5msselect * from `cities` where `cities`.`id` in (1574)
        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.63msselect * from `cities` where `cities`.`id` in (2794, 3455, 5732, 5833, 8069)
        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.24msselect * from `sites_relationships` where `sites_relationships`.`id` in (90254, 90302, 90317, 90500, 90512)
        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.38msselect * from `countries` where `countries`.`id` in (114)
        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.94msselect * from `timetables` where `origin_city_id` = 1574 and `destination_city_id` = 5833 order by `time_origin` asc limit 10
        Bindings
        • 0: 1574
        • 1: 5833
        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.35msselect * from `airports` where `airports`.`id` in (10016)
        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 (1847)
        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.36msselect * from `airlines` where `airlines`.`id` in (3284, 19935, 158278)
        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.78msselect * from `timetables` where `origin_city_id` = 1574 and `destination_city_id` = 5833 order by `travel_time` asc limit 1
        Bindings
        • 0: 1574
        • 1: 5833
        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` = 5833 and `destination_city_id` = 1574 limit 1
        Bindings
        • 0: 5833
        • 1: 1574
        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#520aviatickets1.05msselect * from `sites_relationships` where `sites_relationships`.`id` in (316527)
        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
      • RoutesController.php#547aviatickets1.11msselect * from `cities` where `cities`.`id` = 5833 limit 1
        Bindings
        • 0: 5833
        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
      • RoutesController.php#548aviatickets980μsselect * from `cities` where `cities`.`id` = 1574 limit 1
        Bindings
        • 0: 1574
        Backtrace
        • app/Http/Controllers/RoutesController.php:548
        • 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.47msselect * from `cities` where `cities`.`id` = 1574 limit 1
        Bindings
        • 0: 1574
        Backtrace
        • view::routes.description-nearbyCities:28
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • vendor/laravel/framework/src/Illuminate/View/View.php:207
      App\Avia\Infrastructure\Model\Timetable
      125Timetable.php#?
      App\Avia\Infrastructure\Model\City
      36City.php#?
      App\Avia\Infrastructure\Model\LocalRoute
      35LocalRoute.php#?
      App\Avia\Infrastructure\Model\SitesRelationship
      26SitesRelationship.php#?
      App\Avia\Infrastructure\Model\Airline
      23Airline.php#?
      App\Avia\Infrastructure\Model\Route
      10Route.php#?
      App\Avia\Infrastructure\Model\Country
      7Country.php#?
      App\Avia\Infrastructure\Model\Airport
      2Airport.php#?
      App\Avia\Infrastructure\Model\MonthlyPriceStatistic
      1MonthlyPriceStatistic.php#?
            _token
            dVE8dZ6cgTsJN71q7pb6DgMK4eCx9g9ycPd3mwYn
            _previous
            array:1 [ "url" => "https://d.lowcost.club/cheap-flights-from-denpasar-to-surabaya-dps-sub?_url=%2...
            _flash
            array:2 [ "old" => [] "new" => [] ]
            path_info
            /cheap-flights-from-denpasar-to-surabaya-dps-sub
            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-denpasar-to-surabaya-dps-sub" ]
            request_request
            []
            
            request_headers
            0 of 0
            array:16 [ "cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6InpkYS90K09peEp4MWNGQ0JWdFlLV0E9PSIsInZhbHVlIjoiQzZnVmdNYWUwT3c5V240SFpBUURmTTh4bG92Zy9LbUhkYy9IQWVoUUZuNUVmOVphbmdoajJiUldhdlQzeWF0NHRsWGxFS1pla3ZMaHdyTmNyR3hjNXdodE9GVlV4N0pEYit2bU5rZkNyYzNoQUYwYjJMKzQrcTVRMnFmK3ZGNXUiLCJtYWMiOiI4OTM1YjUzNGIxZGU2N2RhNjdkYzg0OWVkYzY2NjhmOThlM2VlZjJhODMyZDUwMWY0NGRlOWQzZTA4NTIzNzZjIiwidGFnIjoiIn0%3D; lowcostclub_session=eyJpdiI6IkQrZzZyRXVCaFJtWkJXTnpaWm1xVXc9PSIsInZhbHVlIjoiVkFXRzJ4blc2UnR6UTY3eXVVekx2MnBubmt0WSttRkMxQStLZlZEbWhPS3JscXVSMEY5VTBtNHhId2lrczNYMGMxUmZwQVRsaCtMOU1UQ3k5NVF6L0pyTXViR3lnU1ZJQlpSQk1jQ1JPYkIrL0tudmJhSGo1Qm9qeW5ZdW9yRWgiLCJtYWMiOiI5OWFkNjQ1MjZjYjBiNWE0NTRkMDViN2E3MzRkNjQ3MjM1MjBiY2U5YmQzMTA0YWMwMjU3YjFiNWZiYWQ2MjQxIiwidGFnIjoiIn0%3DXSRF-TOKEN=eyJpdiI6InpkYS90K09peEp4MWNGQ0JWdFlLV0E9PSIsInZhbHVlIjoiQzZnVmdNYWUwT3c5V240SFpBUURmTTh4bG92Zy9LbUhkYy9IQWVoUUZuNUVmOVphbmdoajJiUldhdlQzeWF0NHRsWGxFS" ] "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" => "dVE8dZ6cgTsJN71q7pb6DgMK4eCx9g9ycPd3mwYn" "lowcostclub_session" => "JZg1xJHCkZz1Ss1Pf5li1wtCCMxzIlk8N7pSv6Dl" ]
            response_headers
            0 of 0
            array:6 [ "cache-control" => array:1 [ 0 => "max-age=604800, public" ] "date" => array:1 [ 0 => "Sat, 03 May 2025 02:43:00 GMT" ] "etag" => array:1 [ 0 => ""3ad6de8a9b78fd228625516cb87809f9"" ] "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Im1rSjNwb3VlV1V6NUc1NnFDMXpZQ3c9PSIsInZhbHVlIjoidGdrYmVETEF0UUhmR2szRFVvRkhreXRLVitlbUNiSFRLenpUdEdqTDFjRHU1V2VwZTc2V0hTb3QzNjZuSkNhQlpBNmRPVUJBNVk3ZFFiNlE0NXJ1bnA4ais2U0dFOVFmc3Y0ejdQZEY5TUZQa0xnWlBxdUUvNjRhZmxrbEZLUXMiLCJtYWMiOiJiMjVhZWU3OTdlNDA1MWJlNTM1MmEyNzUxMzBhZmNmNjU1ZWE0NTU0MTMyYzg2MTc1ZDAyYmQ0ZWFmYjUyODc5IiwidGFnIjoiIn0%3D; expires=Sat, 03 May 2025 04:43:00 GMT; Max-Age=7200; path=/; samesite=laxXSRF-TOKEN=eyJpdiI6Im1rSjNwb3VlV1V6NUc1NnFDMXpZQ3c9PSIsInZhbHVlIjoidGdrYmVETEF0UUhmR2szRFVvRkhreXRLVitlbUNiSFRLenpUdEdqTDFjRHU1V2VwZTc2V0hTb3QzNjZuSkNhQlpBNmRPV" 1 => "lowcostclub_session=eyJpdiI6IkV4TEkyekxOOU5CTWd3S3V5Rk14Wnc9PSIsInZhbHVlIjoic3lJQzBHdWtYVzNGQlh0TWdJVWhXT25tS0NVT2E3UTRpbkV2czhhRFdNRmx4b21ycHBJT3hMMVFKcGFrU1M4bDhFZXpXUTNSdThPV1Q3S3EvRCtiUkpad0sraElwdnQ0ZXdDdEJqeUxOWGt3YUV2S1JrdWRwQnNiUmhDc3pWUG8iLCJtYWMiOiJkYmIxYjVkYzUxOTNiNDIyNDI3ZjFjZWY0NzZlNjVjNjZiNmUxMzEwOWNiZWIzZGQwZTY0NDVjYzdiNTVkMWYzIiwidGFnIjoiIn0%3D; expires=Sat, 03 May 2025 04:43:00 GMT; Max-Age=7200; path=/; httponly; samesite=laxlowcostclub_session=eyJpdiI6IkV4TEkyekxOOU5CTWd3S3V5Rk14Wnc9PSIsInZhbHVlIjoic3lJQzBHdWtYVzNGQlh0TWdJVWhXT25tS0NVT2E3UTRpbkV2czhhRFdNRmx4b21ycHBJT3hMMVFKcGFrU1M4" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Im1rSjNwb3VlV1V6NUc1NnFDMXpZQ3c9PSIsInZhbHVlIjoidGdrYmVETEF0UUhmR2szRFVvRkhreXRLVitlbUNiSFRLenpUdEdqTDFjRHU1V2VwZTc2V0hTb3QzNjZuSkNhQlpBNmRPVUJBNVk3ZFFiNlE0NXJ1bnA4ais2U0dFOVFmc3Y0ejdQZEY5TUZQa0xnWlBxdUUvNjRhZmxrbEZLUXMiLCJtYWMiOiJiMjVhZWU3OTdlNDA1MWJlNTM1MmEyNzUxMzBhZmNmNjU1ZWE0NTU0MTMyYzg2MTc1ZDAyYmQ0ZWFmYjUyODc5IiwidGFnIjoiIn0%3D; expires=Sat, 03-May-2025 04:43:00 GMT; path=/XSRF-TOKEN=eyJpdiI6Im1rSjNwb3VlV1V6NUc1NnFDMXpZQ3c9PSIsInZhbHVlIjoidGdrYmVETEF0UUhmR2szRFVvRkhreXRLVitlbUNiSFRLenpUdEdqTDFjRHU1V2VwZTc2V0hTb3QzNjZuSkNhQlpBNmRPV" 1 => "lowcostclub_session=eyJpdiI6IkV4TEkyekxOOU5CTWd3S3V5Rk14Wnc9PSIsInZhbHVlIjoic3lJQzBHdWtYVzNGQlh0TWdJVWhXT25tS0NVT2E3UTRpbkV2czhhRFdNRmx4b21ycHBJT3hMMVFKcGFrU1M4bDhFZXpXUTNSdThPV1Q3S3EvRCtiUkpad0sraElwdnQ0ZXdDdEJqeUxOWGt3YUV2S1JrdWRwQnNiUmhDc3pWUG8iLCJtYWMiOiJkYmIxYjVkYzUxOTNiNDIyNDI3ZjFjZWY0NzZlNjVjNjZiNmUxMzEwOWNiZWIzZGQwZTY0NDVjYzdiNTVkMWYzIiwidGFnIjoiIn0%3D; expires=Sat, 03-May-2025 04:43:00 GMT; path=/; httponlylowcostclub_session=eyJpdiI6IkV4TEkyekxOOU5CTWd3S3V5Rk14Wnc9PSIsInZhbHVlIjoic3lJQzBHdWtYVzNGQlh0TWdJVWhXT25tS0NVT2E3UTRpbkV2czhhRFdNRmx4b21ycHBJT3hMMVFKcGFrU1M4" ] ]
            session_attributes
            0 of 0
            array:3 [ "_token" => "dVE8dZ6cgTsJN71q7pb6DgMK4eCx9g9ycPd3mwYn" "_previous" => array:1 [ "url" => "https://d.lowcost.club/cheap-flights-from-denpasar-to-surabaya-dps-sub?_url=%2Fcheap-flights-from-denpasar-to-surabaya-dps-sub" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
            ClearShow all
            Date ↕MethodURLData
            #12025-05-03 02:43:00GET/cheap-flights-from-denpasar-to-surabaya-dps-sub5753265