SitesRelationshipsSqlRepository.php#34aviatickets8.02msselect * from `sites_relationships` where `us` = 'cheap-flights-from-lappeenranta-to-kazan-lpp-kzn' limit 1

Bindings	0: cheap-flights-from-lappeenranta-to-kazan-lpp-kzn
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#125aviatickets3.56msselect * from `flights_by` where `flights_by`.`id` = '1046575' 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#135aviatickets3.76msselect * from `cities` where `cities`.`id` = 8527 limit 1

Bindings	0: 8527
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#136aviatickets4.77msselect * from `countries` where `countries`.`id` = 210 limit 1

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

Bindings	0: 3430
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#138aviatickets4.85msselect * from `countries` where `countries`.`id` = 248 limit 1

Bindings	0: 248
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.74ms

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

Bindings	0: 1046575
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#31aviatickets4.38msselect * from `countries` where `code` = '' limit 1

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

RouteRepository.php#42aviatickets2.11ms

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

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

MonthlyPriceStatisticSqlRepository.php#66aviatickets4.16msselect * from `monthly_price_statistics` where `origin_city_id` = 8527 and `destination_city_id` = 3430 limit 1

Bindings	0: 8527 1: 3430
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#470aviatickets2.7ms

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

Bindings	0: 8527 1: 3430
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.51msselect distinct `airline_id` from `timetables` where `origin_city_id` = 8527

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

AirlineSqlRepository.php#502aviatickets1.62msselect distinct `airline_id` from `timetables` where `origin_city_id` = 3430

Bindings	0: 3430
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.72ms

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

Bindings	0: 8527 1: 1 2: 1000 3: 0 4: 0
Backtrace	app/Avia/Infrastructure/Repository/LocalRouteRepository.php:558 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Repository/LocalRouteRepository.php:563 app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:62

NearbyCitiesAggregateDbProvider.php#73aviatickets3.23ms

select * from `flights_by` where `origin_city_id` in (3505, 2340, 2814, 3369, 6156, 6136, 2864, 4752, 5324, 5824) and `destination_city_id` = 3430 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 3505 1: 2340 2: 2814 3: 3369 4: 6156 5: 6136 6: 2864 7: 4752 8: 5324 9: 5824 10: 3430 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#73aviatickets5.05msselect * from `cities` where `cities`.`id` in (2340, 3505, 4752, 5324, 5824, 6136)

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#73aviatickets10.47msselect * from `cities` where `cities`.`id` in (3430)

Backtrace

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

NearbyCitiesAggregateDbProvider.php#73aviatickets4.19msselect * from `sites_relationships` where `sites_relationships`.`id` in (130535, 184770, 251216, 280587, 314295, 331449)

Backtrace

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

CitySqlRepository.php#104aviatickets1.45msselect * from `cities` where `cities`.`id` = 3505 limit 1

Bindings	0: 3505
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.35msselect * from `offers` where `origin_city_id` = 8527 and `destination_city_id` = 3430

Bindings	0: 8527 1: 3430
Backtrace	app/Avia/Infrastructure/Repository/OfferSqlRepository.php:52 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Repository/OfferSqlRepository.php:57 app/Http/Controllers/RoutesController.php:205

LocalRouteRepository.php#447aviatickets2.62ms

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

Bindings	0: 8527 1: 1046575 2: 210 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#447aviatickets10.05msselect * from `cities` where `cities`.`id` in (8527)

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.37msselect * from `cities` where `cities`.`id` in (5586, 5610, 5907)

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 (1046590, 1046591, 1046592)

Backtrace

app/Avia/Infrastructure/Repository/LocalRouteRepository.php:447
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:451
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:202

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

Bindings	0: 136
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.73ms

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

Bindings	0: 8527 1: 210 2: 0 3: 0 4: 1046590
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.82msselect * from `cities` where `cities`.`id` in (8527)

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.41msselect * from `cities` where `cities`.`id` in (3958, 6319)

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.38msselect * from `sites_relationships` where `sites_relationships`.`id` in (195334, 1046597)

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 `countries` where `countries`.`id` in (109, 211)

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

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

Bindings	0: 3430 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#149aviatickets4.14msselect * from `cities` where `cities`.`id` in (3430)

Backtrace

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

LocalRouteRepository.php#149aviatickets2.81msselect * from `cities` where `cities`.`id` in (86, 696, 2382, 3505, 4081)

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#149aviatickets6.28msselect * from `countries` where `countries`.`id` in (89, 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#149aviatickets3.74msselect * from `sites_relationships` where `sites_relationships`.`id` in (177351, 177436, 177699, 177865, 177948)

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

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

Bindings	0: 8527 1: 210 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#359aviatickets5.46msselect * from `cities` where `cities`.`id` in (8527)

Backtrace

app/Avia/Infrastructure/Repository/LocalRouteRepository.php:359
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:363
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:330

LocalRouteRepository.php#359aviatickets2.3msselect * from `cities` where `cities`.`id` in (2814, 2864, 3369, 5443, 6156)

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.76msselect * from `sites_relationships` where `sites_relationships`.`id` in (834273, 1046586, 1075259, 1075266, 1091080)

Backtrace

app/Avia/Infrastructure/Repository/LocalRouteRepository.php:359
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:363
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:330

LocalRouteRepository.php#359aviatickets2.25msselect * from `countries` where `countries`.`id` in (210)

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

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

Bindings	0: 8527 1: 3430
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.51ms

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

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

Bindings	0: 3430 1: 8527
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#520aviatickets1msselect * from `sites_relationships` where `sites_relationships`.`id` in (1027726)

Backtrace

app/Avia/Infrastructure/Repository/LocalRouteRepository.php:520
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:514
app/Http/Controllers/RoutesController.php:530

LocalRoute.php#99aviatickets1.74msselect * from `cities` where `cities`.`id` = 8527 limit 1

Bindings	0: 8527
Backtrace	app/Avia/Infrastructure/Model/LocalRoute.php:99 app/Avia/Infrastructure/Factory/DomainRouteFactory.php:30 app/Http/Controllers/RoutesController.php:536 app/Http/Controllers/RoutesController.php:279 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

RoutesController.php#547aviatickets1.5msselect * from `cities` where `cities`.`id` = 3430 limit 1

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

description-nearbyCities.blade.php#12aviatickets1.37msselect * from `cities` where `cities`.`id` = 8527 limit 1

Bindings	0: 8527
Backtrace	view::routes.description-nearbyCities:12 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.27msselect * 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.29msselect * 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.5msselect * 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.13msselect * 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.2msselect * 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.8ms

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.76msselect * 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.95msselect * 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.38msselect * 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.03ms

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\City: 53City.php#?
App\Avia\Infrastructure\Model\LocalRoute: 48LocalRoute.php#?
App\Avia\Infrastructure\Model\Timetable: 40Timetable.php#?
App\Avia\Infrastructure\Model\SitesRelationship: 39SitesRelationship.php#?
App\Avia\Infrastructure\Model\Country: 17Country.php#?
App\Avia\Infrastructure\Model\MonthlyPriceStatistic: 1MonthlyPriceStatistic.php#?

_token: GR0M7yff9pBGGT0E1Y2mNgoIcHYmVDL3uI18snkD
_previous: array:1 [ "url" => "https://d.lowcost.club/cheap-flights-from-lappeenranta-to-kazan-lpp-kzn?_url=%...
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/cheap-flights-from-lappeenranta-to-kazan-lpp-kzn

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:1 [▼
  "_url" => "/cheap-flights-from-lappeenranta-to-kazan-lpp-kzn"
]

request_request

[]

request_headers

  0 of 0   
array:16 [▼
  "cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InJFRXVhYmJ3a0lqMG1JekhqS3YwdUE9PSIsInZhbHVlIjoiUHRNazI2VWFEQlRsQVFQZzhaaENXVmo0TENXdTNzaGJ2V2V1di93WTF1S2tnMHNDeDlCWkR4djE5T3d4YTZTZU95R05mVC83SFlMRWJibmZkY05LZXA2UUtNTFZQOFRDak9hSFhPWFRSZWVLMVYxZlhuTldrNWp5dVFVbHQ0d0ciLCJtYWMiOiIwMWI0ZjgzMjMyMzBkNmVjNzY2YTg5NGMzNGRhYzQwMzVmMTY3MmZkYzZmMmNiMTFlYzBmMjZjYjdkYzgyZTNlIiwidGFnIjoiIn0%3D; lowcostclub_session=eyJpdiI6IjJCdnJRRUxCeFRrejZTUThUU2p6eXc9PSIsInZhbHVlIjoid09zRFpQL1NVSzB2OEREcjJzTm5QMmNyVUxWZDhZbHRyNnBabDBFS3pMN0dSM09TRkxpQk43RCtpZEVLVDRJMGd3T0VNRklKczIzWGJtR0tOaS92V3NOUHRGYjk1QnhLMlA2aFlFeFMyL1BxeGFuUVBVaktSZ3F1ZW54Y2diMWkiLCJtYWMiOiI5YjQzZThlYWE4MDgzYTZlOTgzOGVmZTc5NTdjMzBjMzU0N2E2ZTEzMThhZThjYTZlN2FlZjRmNWJmMDkxNTFhIiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6InJFRXVhYmJ3a0lqMG1JekhqS3YwdUE9PSIsInZhbHVlIjoiUHRNazI2VWFEQlRsQVFQZzhaaENXVmo0TENXdTNzaGJ2V2V1di93WTF1S2tnMHNDeDlCWkR4djE5T3d4YTZTZU95R05mV ▶"
  ]
  "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" => "GR0M7yff9pBGGT0E1Y2mNgoIcHYmVDL3uI18snkD"
  "lowcostclub_session" => "DldU171udjAa154KC2gQxjN3zXR4g78Wk3hSzqB3"
]

response_headers

  0 of 0   
array:6 [▼
  "cache-control" => array:1 [▶
    0 => "max-age=604800, public"
  ]
  "date" => array:1 [▶
    0 => "Fri, 09 May 2025 07:16:35 GMT"
  ]
  "etag" => array:1 [▶
    0 => ""517b378cd5a605da99df742dfab79d6d""
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InlNRWxzZklQSUxaZk5EM2p0RytnTmc9PSIsInZhbHVlIjoiakpvYkxDSUJLZ1F4RDVaZWlGbkFVRmRVNGVucndiTHAvUm5laG5kc0VIN213cng5SEk1T0xlNUFnRm1zSjg2Y2k2MW1sQnpoVDNKdm5VNlkwaU5VMHpLZFpzbk5aV3ZYRjhhRVNMbVk1aTI3WkpWb1JkUVU2NTZmSHB0cm9RTmEiLCJtYWMiOiI0YmVlNDJlYTVlMDA3MDg1ZTFhMzdjOTA5ZGIzOTJmZDk5ZGQ2OTgwMjUwMzRkYWIxMDQyOGJkNzI1N2U5OGExIiwidGFnIjoiIn0%3D; expires=Fri, 09 May 2025 09:16:35 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6InlNRWxzZklQSUxaZk5EM2p0RytnTmc9PSIsInZhbHVlIjoiakpvYkxDSUJLZ1F4RDVaZWlGbkFVRmRVNGVucndiTHAvUm5laG5kc0VIN213cng5SEk1T0xlNUFnRm1zSjg2Y2k2MW1sQ ▶"
    1 => "lowcostclub_session=eyJpdiI6IlhsSWs2OFJsQ3FpVEtiOXAxbDhLQ0E9PSIsInZhbHVlIjoiaVo4c0NxcU52SklpUVkzUU9xdTFDamlZUkdOZWNCVmQxOFNiSW5uSE96K3llT3pjdVo3enViUENZSnJ5QmowOHhxbGQzRTFRL1RPVFVXbVdwZ1MvdzE3cm5oTlNwSE0yKzM5bFlBSzNNQ09RZmRwR3dpQXgzWXdFd2xxbWdETXoiLCJtYWMiOiJmNjNkNzJkYmEyMjFmNzdiYmUxODdhMGQyMDViOGEzODk5NjRjODMzMmVkMDZlYWQ4OTgxM2Y0YmVjNzBlYzc4IiwidGFnIjoiIn0%3D; expires=Fri, 09 May 2025 09:16:35 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀lowcostclub_session=eyJpdiI6IlhsSWs2OFJsQ3FpVEtiOXAxbDhLQ0E9PSIsInZhbHVlIjoiaVo4c0NxcU52SklpUVkzUU9xdTFDamlZUkdOZWNCVmQxOFNiSW5uSE96K3llT3pjdVo3enViUENZSnJ5Qmow ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InlNRWxzZklQSUxaZk5EM2p0RytnTmc9PSIsInZhbHVlIjoiakpvYkxDSUJLZ1F4RDVaZWlGbkFVRmRVNGVucndiTHAvUm5laG5kc0VIN213cng5SEk1T0xlNUFnRm1zSjg2Y2k2MW1sQnpoVDNKdm5VNlkwaU5VMHpLZFpzbk5aV3ZYRjhhRVNMbVk1aTI3WkpWb1JkUVU2NTZmSHB0cm9RTmEiLCJtYWMiOiI0YmVlNDJlYTVlMDA3MDg1ZTFhMzdjOTA5ZGIzOTJmZDk5ZGQ2OTgwMjUwMzRkYWIxMDQyOGJkNzI1N2U5OGExIiwidGFnIjoiIn0%3D; expires=Fri, 09-May-2025 09:16:35 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6InlNRWxzZklQSUxaZk5EM2p0RytnTmc9PSIsInZhbHVlIjoiakpvYkxDSUJLZ1F4RDVaZWlGbkFVRmRVNGVucndiTHAvUm5laG5kc0VIN213cng5SEk1T0xlNUFnRm1zSjg2Y2k2MW1sQ ▶"
    1 => "lowcostclub_session=eyJpdiI6IlhsSWs2OFJsQ3FpVEtiOXAxbDhLQ0E9PSIsInZhbHVlIjoiaVo4c0NxcU52SklpUVkzUU9xdTFDamlZUkdOZWNCVmQxOFNiSW5uSE96K3llT3pjdVo3enViUENZSnJ5QmowOHhxbGQzRTFRL1RPVFVXbVdwZ1MvdzE3cm5oTlNwSE0yKzM5bFlBSzNNQ09RZmRwR3dpQXgzWXdFd2xxbWdETXoiLCJtYWMiOiJmNjNkNzJkYmEyMjFmNzdiYmUxODdhMGQyMDViOGEzODk5NjRjODMzMmVkMDZlYWQ4OTgxM2Y0YmVjNzBlYzc4IiwidGFnIjoiIn0%3D; expires=Fri, 09-May-2025 09:16:35 GMT; path=/; httponly ◀lowcostclub_session=eyJpdiI6IlhsSWs2OFJsQ3FpVEtiOXAxbDhLQ0E9PSIsInZhbHVlIjoiaVo4c0NxcU52SklpUVkzUU9xdTFDamlZUkdOZWNCVmQxOFNiSW5uSE96K3llT3pjdVo3enViUENZSnJ5Qmow ▶"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "GR0M7yff9pBGGT0E1Y2mNgoIcHYmVDL3uI18snkD"
  "_previous" => array:1 [▶
    "url" => "https://d.lowcost.club/cheap-flights-from-lappeenranta-to-kazan-lpp-kzn?_url=%2Fcheap-flights-from-lappeenranta-to-kazan-lpp-kzn"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-05-09 07:16:35	GET	/cheap-flights-from-lappeenranta-to-kazan-lpp-kzn	47 57 198

1 x Application (93.42%)	551ms
1 x Booting (6.57%)	38.81ms

Cheap flights Lappeenranta — Kazan (LPP — KZN)

Choose your dates to find the flight:

Good to know - Cheap tickets Lappeenranta — Kazan

Routes from nearby cities to Kazan

Popular International routes from Lappeenranta

Popular routes from Kazan

Popular domestic routes from Lappeenranta

Related pages

Select your currency

All currencies

Select your language

All languages