SitesRelationshipsSqlRepository.php#34aviatickets6.72msselect * from `sites_relationships` where `us` = 'cheap-flights-from-zurich-to-madison-zrh-msn' limit 1

Bindings	0: cheap-flights-from-zurich-to-madison-zrh-msn
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.15msselect * from `flights_by` where `flights_by`.`id` = '1043555' 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` = 7487 limit 1

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

Bindings	0: 131
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.15msselect * from `cities` where `cities`.`id` = 8558 limit 1

Bindings	0: 8558
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.89msselect * from `countries` where `countries`.`id` = 92 limit 1

Bindings	0: 92
Backtrace	app/Http/Controllers/RoutesController.php:138 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

DomainRouteFactory.php#33aviatickets940μs

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

Bindings	0: 1043555
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.21msselect * 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.22ms

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

Bindings	0: 7487 1: 8558 2: 2025-05-10 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#66aviatickets2.73msselect * from `monthly_price_statistics` where `origin_city_id` = 7487 and `destination_city_id` = 8558 limit 1

Bindings	0: 7487 1: 8558
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.76ms

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

Bindings	0: 7487 1: 8558
Backtrace	app/Avia/Infrastructure/Repository/AirlineSqlRepository.php:470 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Repository/AirlineSqlRepository.php:461 app/Http/Controllers/RoutesController.php:162

AirlineSqlRepository.php#502aviatickets2.37msselect distinct `airline_id` from `timetables` where `origin_city_id` = 7487

Bindings	0: 7487
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#502aviatickets2.41msselect distinct `airline_id` from `timetables` where `origin_city_id` = 8558

Bindings	0: 8558
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#90aviatickets2.45msselect * from `airlines` where `id` in (24, 2005, 3633, 5184) order by `name` asc

Bindings	0: 24 1: 2005 2: 3633 3: 5184
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.51ms

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

Bindings	0: 7487 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.43ms

select * from `flights_by` where `origin_city_id` in (6941, 1857, 819, 1643, 9261, 9136, 8821, 8489, 2634, 3958) and `destination_city_id` = 8558 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 6941 1: 1857 2: 819 3: 1643 4: 9261 5: 9136 6: 8821 7: 8489 8: 2634 9: 3958 10: 8558 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

OfferSqlRepository.php#52aviatickets2.96msselect * from `offers` where `origin_city_id` = 7487 and `destination_city_id` = 8558

Bindings	0: 7487 1: 8558
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#447aviatickets1.75ms

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

Bindings	0: 7487 1: 1043555 2: 131 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.23msselect * from `cities` where `cities`.`id` in (7487)

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.29msselect * from `cities` where `cities`.`id` in (8621, 9302, 9480)

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.14msselect * from `sites_relationships` where `sites_relationships`.`id` in (1043556, 1043562, 1043563)

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

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

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

LocalRouteRepository.php#412aviatickets2.27msselect * from `cities` where `cities`.`id` in (7487)

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#412aviatickets3.02msselect * 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.57msselect * from `sites_relationships` where `sites_relationships`.`id` in (377727, 377802)

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.78msselect * 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#149aviatickets5.25ms

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

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

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 (696, 3654, 5537, 6319, 9221)

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 (17, 18, 89, 92, 211)

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.04msselect * from `sites_relationships` where `sites_relationships`.`id` in (222626, 222717, 222750, 222786, 222816)

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

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

Bindings	0: 7487 1: 131 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.12msselect * from `cities` where `cities`.`id` in (7487)

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.17msselect * from `cities` where `cities`.`id` in (819, 1643, 2258, 6941)

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#359aviatickets780μsselect * from `sites_relationships` where `sites_relationships`.`id` in (377409, 377519, 377594, 1043547)

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

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

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

Bindings	0: 7487 1: 8558
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#144aviatickets1ms

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

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

Bindings	0: 8558 1: 7487
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 (451047)

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

Bindings	0: 8558
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.03msselect * from `cities` where `cities`.`id` = 7487 limit 1

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

LocalRouteRepository.php#175aviatickets960μsselect * from `flights_by` where `id` in (240458, 46235, 180255, 46251, 201516, 32301)

Bindings	0: 240458 1: 46235 2: 180255 3: 46251 4: 201516 5: 32301
Backtrace	app/Avia/Infrastructure/Repository/LocalRouteRepository.php:175 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Repository/LocalRouteRepository.php:179 app/Avia/Application/SeoRoutesHandler.php:40

LocalRouteRepository.php#175aviatickets1.15msselect * 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.56msselect * 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.44msselect * 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.15msselect * 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.7ms

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.12msselect * 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.15msselect * 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.1msselect * 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#149aviatickets870μ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: 137Timetable.php#?
App\Avia\Infrastructure\Model\City: 43City.php#?
App\Avia\Infrastructure\Model\LocalRoute: 41LocalRoute.php#?
App\Avia\Infrastructure\Model\SitesRelationship: 32SitesRelationship.php#?
App\Avia\Infrastructure\Model\Country: 18Country.php#?
App\Avia\Infrastructure\Model\Airline: 4Airline.php#?
App\Avia\Infrastructure\Model\MonthlyPriceStatistic: 1MonthlyPriceStatistic.php#?

_token: Mlg24ZPYuB1Y8e4DQ2JyNUCllQcp1aZWlvbXh3eD
_previous: array:1 [ "url" => "https://d.lowcost.club/cheap-flights-from-zurich-to-madison-zrh-msn?_url=%2Fch...
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/cheap-flights-from-zurich-to-madison-zrh-msn

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:1 [▼
  "_url" => "/cheap-flights-from-zurich-to-madison-zrh-msn"
]

request_request

[]

request_headers

  0 of 0   
array:16 [▼
  "cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlhxNHFkNkZVOE9SUEFzNExuMllBZ1E9PSIsInZhbHVlIjoiak9MM3hXdFo0TEhpVzlRUloxajF2ZHBaTFNUOGpwYzdSSFJpM25veHdYL01GL2FnVWhuSEdZU0ozVzNTRVFidC9oSU1yYmhXUXJNbmdaZ1FXUExPV3BzSklFRlBhWnZueW1lRlA3Ym41U3FFYUNrQUJCTjNLWDUyMm8zT1orV0kiLCJtYWMiOiJhOTY0MDk1M2I1ZmUyZTI5NjY4NDE5ZWRmMDFlNTlkZDJlZDJkMmVhNzcwNGIwYzFiMDRiNjFhM2E4NDk5ODViIiwidGFnIjoiIn0%3D; lowcostclub_session=eyJpdiI6IlBkbzNMall3MkVxcFVTZTA5SW9mNUE9PSIsInZhbHVlIjoiL0FpTS9kYWlSMWlmb1dvbVZRUmRmK01iYkN1NjY2NEdSbE5ldTBvMEhwQy9LYkNubWoweTJkUHhJMTVzNXlRQ2xlNzRyejgxcUNJTzdhclZPZVNENDdJZnpxNGJtRG54WldYbURrcDBUMW9QbEMvQlNtUVRMdVBhZXd3ZXJaR3YiLCJtYWMiOiJkMTA4YmU5Yjg4ZmQ1YzhiZDE0YTgzNmYyMDZkNTRjYWI4MTQ3Njc3ZTVjZWMyZjdiODMzMTA5MjVjYTk0MjJiIiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6IlhxNHFkNkZVOE9SUEFzNExuMllBZ1E9PSIsInZhbHVlIjoiak9MM3hXdFo0TEhpVzlRUloxajF2ZHBaTFNUOGpwYzdSSFJpM25veHdYL01GL2FnVWhuSEdZU0ozVzNTRVFidC9oSU1yY ▶"
  ]
  "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" => "Mlg24ZPYuB1Y8e4DQ2JyNUCllQcp1aZWlvbXh3eD"
  "lowcostclub_session" => "Ad3OX6OQ9rMCtvkTiioxEPBCQnygjhG2hNwUp253"
]

response_headers

  0 of 0   
array:6 [▼
  "cache-control" => array:1 [▶
    0 => "max-age=604800, public"
  ]
  "date" => array:1 [▶
    0 => "Mon, 12 May 2025 18:04:52 GMT"
  ]
  "etag" => array:1 [▶
    0 => ""67392cc43874216439539e584ff60d82""
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImgzU1dYbVlJWGQ4NFpRRVdQMmVIU3c9PSIsInZhbHVlIjoiM2Z2S1A2YnZGSmI1a3hiUHg3NGJOZkRQRlV4WDVWUDFDcEZ4MHU4cmd3S3Y0Ty9xbFA2ZGsyaHFhQ0dGNUN1QlljWXUxSDFEZXNrVWhPaURPcDNNaU5WNW13SUFQT2tiZHpvMEhzYm9CcXI3eU8yRTZyMm5IbFhaang1N2kxYWwiLCJtYWMiOiIzMTE4MzM0ZWIxNzU5OGY2Y2EwOWM1OWE1YTQ3OThjNWJkN2RlYmFjMjkxYTdhM2M5MWUxYzUxZWZhMzQ4ODFkIiwidGFnIjoiIn0%3D; expires=Mon, 12 May 2025 20:04:53 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6ImgzU1dYbVlJWGQ4NFpRRVdQMmVIU3c9PSIsInZhbHVlIjoiM2Z2S1A2YnZGSmI1a3hiUHg3NGJOZkRQRlV4WDVWUDFDcEZ4MHU4cmd3S3Y0Ty9xbFA2ZGsyaHFhQ0dGNUN1QlljWXUxS ▶"
    1 => "lowcostclub_session=eyJpdiI6Ing3TEc1TEJkUVEvTUlMNU1DcVNpSVE9PSIsInZhbHVlIjoiRmNYdGs0ejB4N3ZQMldvWGl3RkdUY3d3enBiWXIxQW41Q3RiY25RZGRxQ25XenFzeUc3d1gyREVPb2VrajN3cm1RS1VyQjhpVkV1SjVNVE80aEYyS0lWTmlSV1RzbGNTYkFzNGZ1dnVZMzJSUmh3dWEwRk5OWVUrNWRXOTROL3MiLCJtYWMiOiI5ZWQzOWQ5NTY5OWRmYzAwNTAyNTRiNTEzN2I4MGFmNmM4NzQ3NjRhOGVkYWMwMzYxMTYwMWYwOGI4NDBmZGJmIiwidGFnIjoiIn0%3D; expires=Mon, 12 May 2025 20:04:53 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀lowcostclub_session=eyJpdiI6Ing3TEc1TEJkUVEvTUlMNU1DcVNpSVE9PSIsInZhbHVlIjoiRmNYdGs0ejB4N3ZQMldvWGl3RkdUY3d3enBiWXIxQW41Q3RiY25RZGRxQ25XenFzeUc3d1gyREVPb2VrajN3 ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImgzU1dYbVlJWGQ4NFpRRVdQMmVIU3c9PSIsInZhbHVlIjoiM2Z2S1A2YnZGSmI1a3hiUHg3NGJOZkRQRlV4WDVWUDFDcEZ4MHU4cmd3S3Y0Ty9xbFA2ZGsyaHFhQ0dGNUN1QlljWXUxSDFEZXNrVWhPaURPcDNNaU5WNW13SUFQT2tiZHpvMEhzYm9CcXI3eU8yRTZyMm5IbFhaang1N2kxYWwiLCJtYWMiOiIzMTE4MzM0ZWIxNzU5OGY2Y2EwOWM1OWE1YTQ3OThjNWJkN2RlYmFjMjkxYTdhM2M5MWUxYzUxZWZhMzQ4ODFkIiwidGFnIjoiIn0%3D; expires=Mon, 12-May-2025 20:04:53 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6ImgzU1dYbVlJWGQ4NFpRRVdQMmVIU3c9PSIsInZhbHVlIjoiM2Z2S1A2YnZGSmI1a3hiUHg3NGJOZkRQRlV4WDVWUDFDcEZ4MHU4cmd3S3Y0Ty9xbFA2ZGsyaHFhQ0dGNUN1QlljWXUxS ▶"
    1 => "lowcostclub_session=eyJpdiI6Ing3TEc1TEJkUVEvTUlMNU1DcVNpSVE9PSIsInZhbHVlIjoiRmNYdGs0ejB4N3ZQMldvWGl3RkdUY3d3enBiWXIxQW41Q3RiY25RZGRxQ25XenFzeUc3d1gyREVPb2VrajN3cm1RS1VyQjhpVkV1SjVNVE80aEYyS0lWTmlSV1RzbGNTYkFzNGZ1dnVZMzJSUmh3dWEwRk5OWVUrNWRXOTROL3MiLCJtYWMiOiI5ZWQzOWQ5NTY5OWRmYzAwNTAyNTRiNTEzN2I4MGFmNmM4NzQ3NjRhOGVkYWMwMzYxMTYwMWYwOGI4NDBmZGJmIiwidGFnIjoiIn0%3D; expires=Mon, 12-May-2025 20:04:53 GMT; path=/; httponly ◀lowcostclub_session=eyJpdiI6Ing3TEc1TEJkUVEvTUlMNU1DcVNpSVE9PSIsInZhbHVlIjoiRmNYdGs0ejB4N3ZQMldvWGl3RkdUY3d3enBiWXIxQW41Q3RiY25RZGRxQ25XenFzeUc3d1gyREVPb2VrajN3 ▶"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "Mlg24ZPYuB1Y8e4DQ2JyNUCllQcp1aZWlvbXh3eD"
  "_previous" => array:1 [▶
    "url" => "https://d.lowcost.club/cheap-flights-from-zurich-to-madison-zrh-msn?_url=%2Fcheap-flights-from-zurich-to-madison-zrh-msn"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-05-12 18:04:53	GET	/cheap-flights-from-zurich-to-madison-zrh-msn	40 52 276

1 x Application (93.83%)	261ms
1 x Booting (6.17%)	17.18ms

Cheap flights Zurich — Madison (ZRH — MSN)

Choose your dates to find the flight:

Good to know - Cheap tickets Zurich — Madison

Popular airlines flying Zurich — Madison

Popular International routes from Zurich

Popular routes from Madison

Popular domestic routes from Zurich

Related pages

Select your currency

All currencies

Select your language

All languages