Most often, departures to Denpasar are from Cairo, this is the cheapest flight from $396. The nearest airports from Hurghada with a flight to Denpasar are located in Tabuk.

Popular International routes from Hurghada

Hurghada — Moscow

from $53 one-way

Hurghada — Saint Petersburg

from $54 one-way

Hurghada — Dresden

from $346 one-way

Hurghada — Dortmund

from $96 one-way

Hurghada — Dublin

from $378 one-way

Popular routes from Denpasar

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

Denpasar — Moscow

from $252 one-way

Denpasar — Saint Petersburg

from $371 one-way

Denpasar — Kuala Lumpur

from $2 one-way

Denpasar — Dubai

from $256 one-way

Denpasar — Singapore

from $2 one-way

Popular domestic routes from Hurghada

Hurghada — Cairo

from $21 one-way

Hurghada — Sharm el Sheikh

from $40 one-way

Hurghada — Alexandria

from $42 one-way

Hurghada — Luxor

from $156 one-way

Hurghada — Marsa Alam

from $133 one-way

Return flights Denpasar – Hurghada

Messages Timeline Exceptions Views50 Route Queries80 Models457 Mails Gate N+1 Queries3 Session Request

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

Booting (29.62ms)time
Application (413ms)time
1 x Application (93.31%)
413ms
1 x Booting (6.69%)
29.62ms

50 templates were rendered

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

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

80 statements were executed (37 duplicates)Show only duplicates108ms

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.34msselect * from `sites_relationships` where `us` = 'cheap-flights-from-hurghada-to-denpasar-hrg-dps' limit 1

Bindings	0: cheap-flights-from-hurghada-to-denpasar-hrg-dps
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#125aviatickets810μsselect * from `flights_by` where `flights_by`.`id` = '137677' 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` = 2445 limit 1

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

Bindings	0: 16
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.08msselect * from `cities` where `cities`.`id` = 1574 limit 1

Bindings	0: 1574
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.01msselect * 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#33aviatickets1.01ms

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

Bindings	0: 137677
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.23msselect * from `countries` where `code` = '' limit 1

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

RouteRepository.php#42aviatickets1.48ms

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

Bindings	0: 2445 1: 1574 2: 2025-05-05 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.31msselect * from `monthly_price_statistics` where `origin_city_id` = 2445 and `destination_city_id` = 1574 limit 1

Bindings	0: 2445 1: 1574
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.25ms

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

Bindings	0: 2445 1: 1574
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.92msselect distinct `airline_id` from `timetables` where `origin_city_id` = 2445

Bindings	0: 2445
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.17msselect 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:408

AirlineSqlRepository.php#90aviatickets1.01msselect * from `airlines` where `id` in (129, 4929) order by `name` asc

Bindings	0: 129 1: 4929
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.09ms

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

Bindings	0: 2445 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.68ms

select * from `flights_by` where `origin_city_id` in (8789, 9116, 3763, 8167, 340, 1794, 275, 6288, 317, 985) and `destination_city_id` = 1574 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 8789 1: 9116 2: 3763 3: 8167 4: 340 5: 1794 6: 275 7: 6288 8: 317 9: 985 10: 1574 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.33msselect * from `cities` where `cities`.`id` in (275, 985, 1794, 3763, 6288, 8789, 9116)

Backtrace

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

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

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

select * from `sites_relationships` where `sites_relationships`.`id` in (58442, 312710, 341911, 413368, 443064, 470080, 1014852)

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

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

Bindings	0: 2445 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.08ms

select * from `flights_by` where `origin_city_id` in (8789, 9116, 3763, 8167, 340, 1794, 275, 6288, 317, 985) and `destination_city_id` = 1574 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 8789 1: 9116 2: 3763 3: 8167 4: 340 5: 1794 6: 275 7: 6288 8: 317 9: 985 10: 1574 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.27msselect * from `cities` where `cities`.`id` in (275, 985, 1794, 3763, 6288, 8789, 9116)

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

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

select * from `sites_relationships` where `sites_relationships`.`id` in (58442, 312710, 341911, 413368, 443064, 470080, 1014852)

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

Bindings	0: 6288
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` = 2445 and `distance` between 1 and 1000 and (`price_one_way` > 0 or `price` > 0) order by `distance` asc limit 10

Bindings	0: 2445 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#73aviatickets5ms

select * from `flights_by` where `origin_city_id` in (8789, 9116, 3763, 8167, 340, 1794, 275, 6288, 317, 985) and `destination_city_id` = 1574 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 8789 1: 9116 2: 3763 3: 8167 4: 340 5: 1794 6: 275 7: 6288 8: 317 9: 985 10: 1574 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.47msselect * from `cities` where `cities`.`id` in (275, 985, 1794, 3763, 6288, 8789, 9116)

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 (1574)

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

select * from `sites_relationships` where `sites_relationships`.`id` in (58442, 312710, 341911, 413368, 443064, 470080, 1014852)

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.04msselect * from `cities` where `cities`.`id` = 985 limit 1

Bindings	0: 985
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.09ms

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

Bindings	0: 2445 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.12ms

select * from `flights_by` where `origin_city_id` in (8789, 9116, 3763, 8167, 340, 1794, 275, 6288, 317, 985) and `destination_city_id` = 1574 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 8789 1: 9116 2: 3763 3: 8167 4: 340 5: 1794 6: 275 7: 6288 8: 317 9: 985 10: 1574 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.28msselect * from `cities` where `cities`.`id` in (275, 985, 1794, 3763, 6288, 8789, 9116)

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

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

select * from `sites_relationships` where `sites_relationships`.`id` in (58442, 312710, 341911, 413368, 443064, 470080, 1014852)

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.12msselect * from `cities` where `cities`.`id` = 985 limit 1

Bindings	0: 985
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.19ms

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

Bindings	0: 2445 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.14ms

select * from `flights_by` where `origin_city_id` in (8789, 9116, 3763, 8167, 340, 1794, 275, 6288, 317, 985) and `destination_city_id` = 1574 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 8789 1: 9116 2: 3763 3: 8167 4: 340 5: 1794 6: 275 7: 6288 8: 317 9: 985 10: 1574 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.48msselect * from `cities` where `cities`.`id` in (275, 985, 1794, 3763, 6288, 8789, 9116)

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

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

select * from `sites_relationships` where `sites_relationships`.`id` in (58442, 312710, 341911, 413368, 443064, 470080, 1014852)

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.19msselect * from `cities` where `cities`.`id` = 985 limit 1

Bindings	0: 985
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#52aviatickets1msselect * from `offers` where `origin_city_id` = 2445 and `destination_city_id` = 1574

Bindings	0: 2445 1: 1574
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.58ms

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

Bindings	0: 2445 1: 137677 2: 16 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#447aviatickets940μsselect * from `cities` where `cities`.`id` in (2445)

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 `cities` where `cities`.`id` in (1586, 1604, 1607)

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#447aviatickets960μsselect * from `sites_relationships` where `sites_relationships`.`id` in (137678, 137679, 137680)

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

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

LocalRouteRepository.php#412aviatickets1.1msselect * from `cities` where `cities`.`id` in (2445)

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.25msselect * 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#412aviatickets980μsselect * from `sites_relationships` where `sites_relationships`.`id` in (137794, 137833)

Backtrace

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

LocalRouteRepository.php#412aviatickets980μsselect * from `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.82ms

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

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

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

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.52msselect * from `cities` where `cities`.`id` in (3366, 3505, 4081, 5610, 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/Http/Controllers/RoutesController.php:216

LocalRouteRepository.php#149aviatickets1.19msselect * from `countries` where `countries`.`id` in (108, 136, 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/Http/Controllers/RoutesController.php:216

LocalRouteRepository.php#149aviatickets970μsselect * from `sites_relationships` where `sites_relationships`.`id` in (90172, 90289, 90306, 90364, 90490)

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

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

Bindings	0: 2445 1: 16 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.25msselect * from `cities` where `cities`.`id` in (2445)

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.42msselect * from `cities` where `cities`.`id` in (985, 3763, 8789, 9116, 9328)

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.25msselect * from `sites_relationships` where `sites_relationships`.`id` in (137593, 137648, 137813, 137899, 137934)

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

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

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

Bindings	0: 2445 1: 1574
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.12ms

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

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

Bindings	0: 1574 1: 2445
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 (90230)

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.21msselect * from `cities` where `cities`.`id` = 1574 limit 1

Bindings	0: 1574
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#548aviatickets1.04msselect * from `cities` where `cities`.`id` = 2445 limit 1

Bindings	0: 2445
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#20aviatickets1.19msselect * from `cities` where `cities`.`id` = 2445 limit 1

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

LocalRouteRepository.php#175aviatickets1.09msselect * 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.1msselect * 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.15msselect * 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.17msselect * 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#175aviatickets920μsselect * 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.81ms

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.1msselect * 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.35msselect * 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.15msselect * 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.12ms

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\Timetable: 163Timetable.php#?
App\Avia\Infrastructure\Model\LocalRoute: 117LocalRoute.php#?
App\Avia\Infrastructure\Model\City: 89City.php#?
App\Avia\Infrastructure\Model\SitesRelationship: 68SitesRelationship.php#?
App\Avia\Infrastructure\Model\Country: 17Country.php#?
App\Avia\Infrastructure\Model\Airline: 2Airline.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: rRLajgQ9fl6nuvIFqmvRNhN1VlnEcwwsBwcd6Puu
_previous: array:1 [ "url" => "https://d.lowcost.club/cheap-flights-from-hurghada-to-denpasar-hrg-dps?_url=%2...
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/cheap-flights-from-hurghada-to-denpasar-hrg-dps

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:1 [▼
  "_url" => "/cheap-flights-from-hurghada-to-denpasar-hrg-dps"
]

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 => ""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

[]

response_headers

  0 of 0   
array:6 [▼
  "cache-control" => array:1 [▶
    0 => "max-age=604800, public"
  ]
  "date" => array:1 [▶
    0 => "Wed, 07 May 2025 03:49:26 GMT"
  ]
  "etag" => array:1 [▶
    0 => ""a994a2d2e97ca8fcc34556031547d5c7""
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImtJN1loeFdDVFl5NTNDUitIS1BROUE9PSIsInZhbHVlIjoicURDSGRLellLeHlsNDEva0RXL083ZUVSOHlZNlVXYXN6Zkw5aHdFQnZwTXFWenV2UUhDczJkTy9uTW9LWVdqOEtSdDgrZHkzcmRlaUFpV0NQRC8wR0JkaE9QaHZVTUxrS2MxVWdXNjRoZnc2cnlQQU9MZWZjcWV5RENwQkNzOEUiLCJtYWMiOiIwZmZiNzk2ZmFhNTMzMzQxMmFkYzdjZmNlODhmNDVlM2E1MzI1OTQxYjFiN2YwMmFiNzBhNDg3MDY0ZGYwOTA4IiwidGFnIjoiIn0%3D; expires=Wed, 07 May 2025 05:49:26 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6ImtJN1loeFdDVFl5NTNDUitIS1BROUE9PSIsInZhbHVlIjoicURDSGRLellLeHlsNDEva0RXL083ZUVSOHlZNlVXYXN6Zkw5aHdFQnZwTXFWenV2UUhDczJkTy9uTW9LWVdqOEtSdDgrZ ▶"
    1 => "lowcostclub_session=eyJpdiI6IlpPcmMvMkRvcGNpWjA1QTRBTkZtTkE9PSIsInZhbHVlIjoiWDR0NVd6REU0TURHVy9TYlE4NDdGVzRLTkZ6a1daMkRVWlhlQnZqMjRWejgrbUhoc0NtYTVYUFYraUhJdSs0WVNaZ29meGp1MWhNOG5uTWJnb28rd0VXN2lnK05WWTI3ZC9udy9yQjhKOHZ3Rkcwdkkzb0FTM0k5d0M3VlhmQWUiLCJtYWMiOiIwODAxYTNkZTllMWI1MGIwNzFlYzY1ZDc3MWFjOWQ3MmJkNDZjYTBiMmM0YWY0YzgwOTQxNWMzMzgxZmEyYzkwIiwidGFnIjoiIn0%3D; expires=Wed, 07 May 2025 05:49:26 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀lowcostclub_session=eyJpdiI6IlpPcmMvMkRvcGNpWjA1QTRBTkZtTkE9PSIsInZhbHVlIjoiWDR0NVd6REU0TURHVy9TYlE4NDdGVzRLTkZ6a1daMkRVWlhlQnZqMjRWejgrbUhoc0NtYTVYUFYraUhJdSs0 ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImtJN1loeFdDVFl5NTNDUitIS1BROUE9PSIsInZhbHVlIjoicURDSGRLellLeHlsNDEva0RXL083ZUVSOHlZNlVXYXN6Zkw5aHdFQnZwTXFWenV2UUhDczJkTy9uTW9LWVdqOEtSdDgrZHkzcmRlaUFpV0NQRC8wR0JkaE9QaHZVTUxrS2MxVWdXNjRoZnc2cnlQQU9MZWZjcWV5RENwQkNzOEUiLCJtYWMiOiIwZmZiNzk2ZmFhNTMzMzQxMmFkYzdjZmNlODhmNDVlM2E1MzI1OTQxYjFiN2YwMmFiNzBhNDg3MDY0ZGYwOTA4IiwidGFnIjoiIn0%3D; expires=Wed, 07-May-2025 05:49:26 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6ImtJN1loeFdDVFl5NTNDUitIS1BROUE9PSIsInZhbHVlIjoicURDSGRLellLeHlsNDEva0RXL083ZUVSOHlZNlVXYXN6Zkw5aHdFQnZwTXFWenV2UUhDczJkTy9uTW9LWVdqOEtSdDgrZ ▶"
    1 => "lowcostclub_session=eyJpdiI6IlpPcmMvMkRvcGNpWjA1QTRBTkZtTkE9PSIsInZhbHVlIjoiWDR0NVd6REU0TURHVy9TYlE4NDdGVzRLTkZ6a1daMkRVWlhlQnZqMjRWejgrbUhoc0NtYTVYUFYraUhJdSs0WVNaZ29meGp1MWhNOG5uTWJnb28rd0VXN2lnK05WWTI3ZC9udy9yQjhKOHZ3Rkcwdkkzb0FTM0k5d0M3VlhmQWUiLCJtYWMiOiIwODAxYTNkZTllMWI1MGIwNzFlYzY1ZDc3MWFjOWQ3MmJkNDZjYTBiMmM0YWY0YzgwOTQxNWMzMzgxZmEyYzkwIiwidGFnIjoiIn0%3D; expires=Wed, 07-May-2025 05:49:26 GMT; path=/; httponly ◀lowcostclub_session=eyJpdiI6IlpPcmMvMkRvcGNpWjA1QTRBTkZtTkE9PSIsInZhbHVlIjoiWDR0NVd6REU0TURHVy9TYlE4NDdGVzRLTkZ6a1daMkRVWlhlQnZqMjRWejgrbUhoc0NtYTVYUFYraUhJdSs0 ▶"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "rRLajgQ9fl6nuvIFqmvRNhN1VlnEcwwsBwcd6Puu"
  "_previous" => array:1 [▶
    "url" => "https://d.lowcost.club/cheap-flights-from-hurghada-to-denpasar-hrg-dps?_url=%2Fcheap-flights-from-hurghada-to-denpasar-hrg-dps"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-05-07 03:49:26	GET	/cheap-flights-from-hurghada-to-denpasar-hrg-dps	50 80 457 3

1 x Application (93.31%)	413ms
1 x Booting (6.69%)	29.62ms

Cheap flights Hurghada — Denpasar (HRG — DPS)

Choose your dates to find the flight:

Good to know - Cheap tickets Hurghada — Denpasar

Popular airlines flying Hurghada — Denpasar

Routes from nearby cities to Denpasar

Popular International routes from Hurghada

Popular routes from Denpasar

Popular domestic routes from Hurghada

Related pages

Select your currency

All currencies

Select your language

All languages