SitesRelationshipsSqlRepository.php#34aviatickets4.66msselect * from `sites_relationships` where `us` = 'cheap-flights-from-zagreb-to-queenstown-zag-zqn' limit 1

Bindings	0: cheap-flights-from-zagreb-to-queenstown-zag-zqn
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.1msselect * from `flights_by` where `flights_by`.`id` = '376564' 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.26msselect * from `cities` where `cities`.`id` = 7404 limit 1

Bindings	0: 7404
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.34msselect * from `countries` where `countries`.`id` = 107 limit 1

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

Bindings	0: 7485
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.38msselect * from `countries` where `countries`.`id` = 214 limit 1

Bindings	0: 214
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.37ms

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

Bindings	0: 376564
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.08msselect * 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.64ms

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

Bindings	0: 7404 1: 7485 2: 2025-05-04 00:00:00
Backtrace	app/Avia/Infrastructure/Repository/RouteRepository.php:42 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Repository/RouteRepository.php:33 app/Http/Controllers/RoutesController.php:150

MonthlyPriceStatisticSqlRepository.php#66aviatickets1.65msselect * from `monthly_price_statistics` where `origin_city_id` = 7404 and `destination_city_id` = 7485 limit 1

Bindings	0: 7404 1: 7485
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.97ms

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

Bindings	0: 7404 1: 7485
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.48msselect distinct `airline_id` from `timetables` where `origin_city_id` = 7404

Bindings	0: 7404
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.25msselect distinct `airline_id` from `timetables` where `origin_city_id` = 7485

Bindings	0: 7485
Backtrace	app/Avia/Infrastructure/Repository/AirlineSqlRepository.php:502 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Repository/AirlineSqlRepository.php:494 app/Avia/Infrastructure/Repository/AirlineSqlRepository.php:408

LocalRouteRepository.php#558aviatickets1.36ms

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

Bindings	0: 7404 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.38ms

select * from `flights_by` where `origin_city_id` in (5329, 763, 3585, 2213, 3208, 7403, 5149, 6236, 4722, 5750) and `destination_city_id` = 7485 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 5329 1: 763 2: 3585 3: 2213 4: 3208 5: 7403 6: 5149 7: 6236 8: 4722 9: 5750 10: 7485 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.3msselect * from `cities` where `cities`.`id` in (3585)

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

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

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#104aviatickets2.25msselect * from `cities` where `cities`.`id` = 3585 limit 1

Bindings	0: 3585
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.92msselect * from `offers` where `origin_city_id` = 7404 and `destination_city_id` = 7485

Bindings	0: 7404 1: 7485
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.44ms

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

Bindings	0: 7404 1: 376564 2: 107 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.19msselect * from `cities` where `cities`.`id` in (7404)

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#447aviatickets3.55msselect * from `cities` where `cities`.`id` in (12, 7487, 7562)

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.08msselect * from `sites_relationships` where `sites_relationships`.`id` in (376565, 376566, 500740)

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#125aviatickets3.24msselect * from `countries` where `countries`.`id` = 131 limit 1

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

LocalRoute.php#125aviatickets1.24msselect * from `countries` where `countries`.`id` = 209 limit 1

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

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

Bindings	0: 7404 1: 107 2: 0 3: 0 4: 376565
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.03msselect * from `cities` where `cities`.`id` in (7404)

Backtrace

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

LocalRouteRepository.php#412aviatickets1.17msselect * from `cities` where `cities`.`id` in (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#412aviatickets1.1msselect * from `sites_relationships` where `sites_relationships`.`id` in (376315, 376354)

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.13msselect * 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.73ms

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

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

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.27msselect * from `cities` where `cities`.`id` in (877, 4081, 8325, 8773, 8893)

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.31msselect * from `countries` where `countries`.`id` in (6, 21, 214, 217, 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#149aviatickets1.08msselect * from `sites_relationships` where `sites_relationships`.`id` in (377191, 377205, 377253, 377279, 377298)

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

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

Bindings	0: 7404 1: 107 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.15msselect * from `cities` where `cities`.`id` in (7404)

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 (1445, 5149, 5329, 5750, 7403)

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#359aviatickets990μsselect * from `sites_relationships` where `sites_relationships`.`id` in (376185, 376424, 376438, 376482, 376561)

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

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

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

Bindings	0: 7404 1: 7485
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.2ms

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

Bindings	0: 7404 1: 7485
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.38msselect * from `flights_by` where `origin_city_id` = 7485 and `destination_city_id` = 7404 limit 1

Bindings	0: 7485 1: 7404
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

description-nearbyCities.blade.php#32aviatickets1.15msselect * from `cities` where `cities`.`id` = 7485 limit 1

Bindings	0: 7485
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#32aviatickets1.03msselect * from `cities` where `cities`.`id` = 7404 limit 1

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

LocalRouteRepository.php#175aviatickets1.3msselect * 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.31msselect * 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.34msselect * 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.29msselect * from `countries` where `countries`.`id` in (17, 70, 79, 92, 105)

Backtrace

app/Avia/Infrastructure/Repository/LocalRouteRepository.php:175
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:179
app/Avia/Application/SeoRoutesHandler.php:40

LocalRouteRepository.php#175aviatickets1.02msselect * 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#149aviatickets2.34ms

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.3msselect * 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.39msselect * 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.23msselect * 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#149aviatickets950μs

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: 63Timetable.php#?
App\Avia\Infrastructure\Model\City: 47City.php#?
App\Avia\Infrastructure\Model\LocalRoute: 42LocalRoute.php#?
App\Avia\Infrastructure\Model\SitesRelationship: 33SitesRelationship.php#?
App\Avia\Infrastructure\Model\Country: 20Country.php#?
App\Avia\Infrastructure\Model\MonthlyPriceStatistic: 1MonthlyPriceStatistic.php#?

infoModel: App\Avia\Infrastructure\Model\LocalRoute => Relation: destinationCountry - You should add `wi...

_token: V2YMqKJnxaeTxMGz5jp3MU8bC8gHT2DKkzvaRA5p
_previous: array:1 [ "url" => "https://d.lowcost.club/cheap-flights-from-zagreb-to-queenstown-zag-zqn?_url=%2...
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/cheap-flights-from-zagreb-to-queenstown-zag-zqn

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:1 [▼
  "_url" => "/cheap-flights-from-zagreb-to-queenstown-zag-zqn"
]

request_request

[]

request_headers

  0 of 0   
array:16 [▼
  "cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IklhN1VpU3FrVDhnYk5ESmlTWCtiQnc9PSIsInZhbHVlIjoiUEJ1ZmtsbFJ3b0lkVkNIWUVwWVk4S3FiTlA2T1o3Um1CbkRJL2N4V3R6Zkl2Y3IxQzdsc0VYYnlMZjFMWWxEb2pGVFJ1TThJcEpMUkdDUjVqcEJOVGQ5M0xZLzhlREJNaUNvcExnRmJXR1RsRDM0Znd1aUZkelVia2Q0QTI3dE8iLCJtYWMiOiI2MTQwZTVjNDBiMDdkMWRiZjRlY2Q1OTA1MDhlM2I1OWM3YTJmYjIzOTgzZGY5NGVlMGNmNDNiYTcyZGE0MzAzIiwidGFnIjoiIn0%3D; lowcostclub_session=eyJpdiI6IjB3aytTTmhDWGJyMkRNZnNzRXhmYlE9PSIsInZhbHVlIjoiUnE3UlZZdmZCSEJ2YU1LcW5kSURMb0YwOXFaaU9FekpOaHhmdkhjZldoU0VVWDJpWVBTV1NlWjFXTTZOSnRKeDRNVGdKMVpCVi81L0xpTWNPTnBDQVY2L2w5YmlxWXNPb1BOOFk5UVkxSk5lcnk0MXNwOC9Eb0ZVSm5LbFJKUTciLCJtYWMiOiI0NmUyNGI2MzQ0ZTMwNGQ2ZDQxNDYxYmY0NzkyMWFiOTY4MDViMzY0NmQwZDg0OTMxODkzZDM0MzNkMGE0YTM3IiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6IklhN1VpU3FrVDhnYk5ESmlTWCtiQnc9PSIsInZhbHVlIjoiUEJ1ZmtsbFJ3b0lkVkNIWUVwWVk4S3FiTlA2T1o3Um1CbkRJL2N4V3R6Zkl2Y3IxQzdsc0VYYnlMZjFMWWxEb2pGVFJ1T ▶"
  ]
  "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" => "V2YMqKJnxaeTxMGz5jp3MU8bC8gHT2DKkzvaRA5p"
  "lowcostclub_session" => "c0tEBvcRQ6LGdz2HZ1MiDysE5yKur8Kv2NOQMJfw"
]

response_headers

  0 of 0   
array:6 [▼
  "cache-control" => array:1 [▶
    0 => "max-age=604800, public"
  ]
  "date" => array:1 [▶
    0 => "Tue, 06 May 2025 17:31:27 GMT"
  ]
  "etag" => array:1 [▶
    0 => ""0bb9dc44657f89c2765a7f63bbd4eeea""
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlBYOUE3WmdFemZHRUpHZVdwRnRwQlE9PSIsInZhbHVlIjoicU54NFFSMUFqWVF5R2ZIZG83YzhWZWllN3owclFZRkVNYUZWWmR4SXE0a01MQy8xSkNocUM1UHF6WEtWa3VaTHBmdVNvbWNkaDhIS2FLWmpYd2xVWE0xQXhsNElzTE1SbTdTRnhRbDJWU2gzL2FJUWNENFhiaWhlazBhcTl0YlIiLCJtYWMiOiI5NDgwM2JhMmUzZjkyZGIyY2M0YmY1ZDczOTQ2MzY2ODNmMTZlNjg5MzgyNGYyMmU0OGMxOTc1YTExYTg2MzE1IiwidGFnIjoiIn0%3D; expires=Tue, 06 May 2025 19:31:27 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IlBYOUE3WmdFemZHRUpHZVdwRnRwQlE9PSIsInZhbHVlIjoicU54NFFSMUFqWVF5R2ZIZG83YzhWZWllN3owclFZRkVNYUZWWmR4SXE0a01MQy8xSkNocUM1UHF6WEtWa3VaTHBmdVNvb ▶"
    1 => "lowcostclub_session=eyJpdiI6ImZwd2ZKRlc3MnJzNHdEeGN5V1pxcXc9PSIsInZhbHVlIjoiU2J5NS95WmlhbW5PSVJZTldycW56VnBGUVZJS2RqV3lzV29NUFg5Nm5EaWZOZVU3eHV2ZWJ1MkR4YklreUlqempJYVcvTjIvMUs2cWZSS1cxZ2FiclVJbEVoUHhTUUppU2hMZjdGdUR0d0wzbW1jbHhWbFIrWFE1SnEvMUJFcmMiLCJtYWMiOiI4YjhlNDk3YmZhYjljNDJjNTAwODQxMGNlNzRmZDMzZThjZjExMGVmN2UyZjkwYzU3ZjBhOTg5ZjRlNDM4NzgyIiwidGFnIjoiIn0%3D; expires=Tue, 06 May 2025 19:31:27 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀lowcostclub_session=eyJpdiI6ImZwd2ZKRlc3MnJzNHdEeGN5V1pxcXc9PSIsInZhbHVlIjoiU2J5NS95WmlhbW5PSVJZTldycW56VnBGUVZJS2RqV3lzV29NUFg5Nm5EaWZOZVU3eHV2ZWJ1MkR4YklreUlq ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlBYOUE3WmdFemZHRUpHZVdwRnRwQlE9PSIsInZhbHVlIjoicU54NFFSMUFqWVF5R2ZIZG83YzhWZWllN3owclFZRkVNYUZWWmR4SXE0a01MQy8xSkNocUM1UHF6WEtWa3VaTHBmdVNvbWNkaDhIS2FLWmpYd2xVWE0xQXhsNElzTE1SbTdTRnhRbDJWU2gzL2FJUWNENFhiaWhlazBhcTl0YlIiLCJtYWMiOiI5NDgwM2JhMmUzZjkyZGIyY2M0YmY1ZDczOTQ2MzY2ODNmMTZlNjg5MzgyNGYyMmU0OGMxOTc1YTExYTg2MzE1IiwidGFnIjoiIn0%3D; expires=Tue, 06-May-2025 19:31:27 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IlBYOUE3WmdFemZHRUpHZVdwRnRwQlE9PSIsInZhbHVlIjoicU54NFFSMUFqWVF5R2ZIZG83YzhWZWllN3owclFZRkVNYUZWWmR4SXE0a01MQy8xSkNocUM1UHF6WEtWa3VaTHBmdVNvb ▶"
    1 => "lowcostclub_session=eyJpdiI6ImZwd2ZKRlc3MnJzNHdEeGN5V1pxcXc9PSIsInZhbHVlIjoiU2J5NS95WmlhbW5PSVJZTldycW56VnBGUVZJS2RqV3lzV29NUFg5Nm5EaWZOZVU3eHV2ZWJ1MkR4YklreUlqempJYVcvTjIvMUs2cWZSS1cxZ2FiclVJbEVoUHhTUUppU2hMZjdGdUR0d0wzbW1jbHhWbFIrWFE1SnEvMUJFcmMiLCJtYWMiOiI4YjhlNDk3YmZhYjljNDJjNTAwODQxMGNlNzRmZDMzZThjZjExMGVmN2UyZjkwYzU3ZjBhOTg5ZjRlNDM4NzgyIiwidGFnIjoiIn0%3D; expires=Tue, 06-May-2025 19:31:27 GMT; path=/; httponly ◀lowcostclub_session=eyJpdiI6ImZwd2ZKRlc3MnJzNHdEeGN5V1pxcXc9PSIsInZhbHVlIjoiU2J5NS95WmlhbW5PSVJZTldycW56VnBGUVZJS2RqV3lzV29NUFg5Nm5EaWZOZVU3eHV2ZWJ1MkR4YklreUlq ▶"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "V2YMqKJnxaeTxMGz5jp3MU8bC8gHT2DKkzvaRA5p"
  "_previous" => array:1 [▶
    "url" => "https://d.lowcost.club/cheap-flights-from-zagreb-to-queenstown-zag-zqn?_url=%2Fcheap-flights-from-zagreb-to-queenstown-zag-zqn"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-05-06 17:31:27	GET	/cheap-flights-from-zagreb-to-queenstown-zag-zqn	42 56 206 1

1 x Application (90.04%)	319ms
1 x Booting (9.95%)	35.25ms

Cheap flights Zagreb — Queenstown (ZAG — ZQN)

Choose your dates to find the flight:

Good to know - Cheap tickets Zagreb — Queenstown

Routes from nearby cities to Queenstown

Popular International routes from Zagreb

Popular routes from Queenstown

Popular domestic routes from Zagreb

Select your currency

All currencies

Select your language

All languages