SitesRelationshipsSqlRepository.php#34aviatickets15.74msselect * from `sites_relationships` where `us` = 'cheap-flights-from-hanoi-to-lisbon-han-lis' limit 1

Bindings	0: cheap-flights-from-hanoi-to-lisbon-han-lis
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#125aviatickets900μsselect * from `flights_by` where `flights_by`.`id` = '128307' 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#135aviatickets850μsselect * from `cities` where `cities`.`id` = 2305 limit 1

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

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

Bindings	0: 3576
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#138aviatickets970μsselect * from `countries` where `countries`.`id` = 215 limit 1

Bindings	0: 215
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#33aviatickets5.88ms

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

Bindings	0: 128307
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#31aviatickets12.05msselect * 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.85ms

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

Bindings	0: 2305 1: 3576 2: 2025-04-29 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.22msselect * from `monthly_price_statistics` where `origin_city_id` = 2305 and `destination_city_id` = 3576 limit 1

Bindings	0: 2305 1: 3576
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#470aviatickets890μs

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

Bindings	0: 2305 1: 3576
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.17msselect distinct `airline_id` from `timetables` where `origin_city_id` = 2305

Bindings	0: 2305
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.44msselect distinct `airline_id` from `timetables` where `origin_city_id` = 3576

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

AirlineSqlRepository.php#90aviatickets1.12msselect * from `airlines` where `id` in (2179, 2218, 3157, 4078, 4929, 11914, 17859, 65824) order by `name` asc

Bindings	0: 2179 1: 2218 2: 3157 3: 4078 4: 4929 5: 11914 6: 17859 7: 65824
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.75ms

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

Bindings	0: 2305 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#73aviatickets11.73ms

select * from `flights_by` where `origin_city_id` in (2437, 9381, 9498, 4587, 6526, 8608, 8383, 7012, 8550, 7754) and `destination_city_id` = 3576 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 2437 1: 9381 2: 9498 3: 4587 4: 6526 5: 8608 6: 8383 7: 7012 8: 8550 9: 7754 10: 3576 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#73aviatickets920μsselect * from `cities` where `cities`.`id` in (8550, 8608)

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

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#73aviatickets740μsselect * from `sites_relationships` where `sites_relationships`.`id` in (195448, 235287)

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

Bindings	0: 8550
Backtrace	app/Avia/Infrastructure/City/CitySqlRepository.php:104 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/City/CitySqlRepository.php:101 app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:97

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

Bindings	0: 8608
Backtrace	app/Avia/Infrastructure/City/CitySqlRepository.php:104 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/City/CitySqlRepository.php:101 app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:131

OfferSqlRepository.php#52aviatickets4.44msselect * from `offers` where `origin_city_id` = 2305 and `destination_city_id` = 3576

Bindings	0: 2305 1: 3576
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.36ms

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

Bindings	0: 2305 1: 128307 2: 240 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#447aviatickets3.08msselect * from `cities` where `cities`.`id` in (2305)

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.28msselect * from `cities` where `cities`.`id` in (3583, 3585, 3654)

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

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.99msselect * from `countries` where `countries`.`id` = 66 limit 1

Bindings	0: 66
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#412aviatickets2ms

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

Bindings	0: 2305 1: 240 2: 0 3: 0 4: 128308
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.72msselect * from `cities` where `cities`.`id` in (2305)

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.27msselect * from `cities` where `cities`.`id` in (2595, 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.14msselect * from `sites_relationships` where `sites_relationships`.`id` in (128247, 128344)

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.34msselect * 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#149aviatickets18.21ms

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

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

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.79msselect * from `cities` where `cities`.`id` in (1923, 2686, 3505, 4081, 6319)

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.58msselect * from `countries` where `countries`.`id` in (134, 211, 215, 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.53msselect * from `sites_relationships` where `sites_relationships`.`id` in (189419, 189505, 189577, 189652, 189940)

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

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

Bindings	0: 2305 1: 240 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#359aviatickets4.21msselect * from `cities` where `cities`.`id` in (2305)

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#359aviatickets3.32msselect * from `cities` where `cities`.`id` in (1419, 5058, 5572, 8374, 8622)

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#359aviatickets8.42msselect * from `sites_relationships` where `sites_relationships`.`id` in (128161, 128170, 128364, 128411, 128450)

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

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#39aviatickets5.51ms

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

Bindings	0: 2305 1: 3576
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#144aviatickets910μs

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

Bindings	0: 2305 1: 3576
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#520aviatickets2.18msselect * from `flights_by` where `origin_city_id` = 3576 and `destination_city_id` = 2305 limit 1

Bindings	0: 3576 1: 2305
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#520aviatickets2.21msselect * from `sites_relationships` where `sites_relationships`.`id` in (189463)

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#547aviatickets2.47msselect * from `cities` where `cities`.`id` = 3576 limit 1

Bindings	0: 3576
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#548aviatickets3.13msselect * from `cities` where `cities`.`id` = 2305 limit 1

Bindings	0: 2305
Backtrace	app/Http/Controllers/RoutesController.php:548 app/Http/Controllers/RoutesController.php:279 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

description-nearbyCities.blade.php#32aviatickets4.9msselect * from `cities` where `cities`.`id` = 3576 limit 1

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

Bindings	0: 2305
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#149aviatickets3.82ms

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#149aviatickets3.79msselect * 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#149aviatickets2.94msselect * from `cities` where `cities`.`id` in (1115, 1903, 2686, 3445, 3448, 3951, 4081, 4805, 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.36msselect * from `countries` where `countries`.`id` in (92, 120, 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#149aviatickets3.87ms

select * from `sites_relationships` where `sites_relationships`.`id` in (239645, 239765, 239824, 239994, 240101, 240103, 240218, 240243, 240377)

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: 188Timetable.php#?
App\Avia\Infrastructure\Model\City: 40City.php#?
App\Avia\Infrastructure\Model\LocalRoute: 38LocalRoute.php#?
App\Avia\Infrastructure\Model\SitesRelationship: 29SitesRelationship.php#?
App\Avia\Infrastructure\Model\Country: 14Country.php#?
App\Avia\Infrastructure\Model\Airline: 8Airline.php#?
App\Avia\Infrastructure\Model\MonthlyPriceStatistic: 1MonthlyPriceStatistic.php#?

_token: 73IyggBm74q5BcGrlEBEm0e6GmRMcp7D3DQRncNs
_previous: array:1 [ "url" => "https://d.lowcost.club/cheap-flights-from-hanoi-to-lisbon-han-lis?_url=%2Fchea...
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/cheap-flights-from-hanoi-to-lisbon-han-lis

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:1 [▼
  "_url" => "/cheap-flights-from-hanoi-to-lisbon-han-lis"
]

request_request

[]

request_headers

  0 of 0   
array:16 [▼
  "cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InpHaXJWSHVpemdZS0Z1VncvclQwWGc9PSIsInZhbHVlIjoibU05MEk3VEJuTzFCVW16aUFKY0RIMy9oQjN1S016TldpU01wMVdkSjJ5UkRudFlaOVp6bTZxbTEwaklHU0pWUU5INW5ZVHkwdXcwQWFLMmVZQzBSODBPeHVrdlJqNWZnMU5WUEExNlNRZnc4M1hUUGI4TU5abWM4SklhK29UWjgiLCJtYWMiOiJmZmI4OWU0OWEzYWNlY2YyNDA3ZjQzYWE2ZjkzZmM3NjYwMGFkN2VlYzM3NmZhN2JmMzIxOTBkMTA2ZTYxNmQ2IiwidGFnIjoiIn0%3D; lowcostclub_session=eyJpdiI6InY0OFd1ZjNScmhGSGNBanAwNzk2Umc9PSIsInZhbHVlIjoiR0pGZnh3cU5la3NyME4yVlcrZW14WkUyKzNoVFhSUXhXYUNVc1RTdzY2QUVsV1dnVklkT0FiN3pqa3hCUEVNMkhjcHN3OXNzOUdMVlM4VTI0V25IdFA4M1BaeHRzTEFGSlJGU0dvcVBNcU1uRmh3QWd6N0xTMEQvZHhrSzF2bXQiLCJtYWMiOiIzMjMxODI2MDQ1ZTMyZmY3ZGUwNzIyZGQ1OWIxMTU1YTc5NWY2YzhkYTZkNzVjMzY4OTM3YzY5MjJkMTQ3Njg1IiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6InpHaXJWSHVpemdZS0Z1VncvclQwWGc9PSIsInZhbHVlIjoibU05MEk3VEJuTzFCVW16aUFKY0RIMy9oQjN1S016TldpU01wMVdkSjJ5UkRudFlaOVp6bTZxbTEwaklHU0pWUU5INW5ZV ▶"
  ]
  "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" => "73IyggBm74q5BcGrlEBEm0e6GmRMcp7D3DQRncNs"
  "lowcostclub_session" => "Ob4Lo2PtklZ1l1dXpfDXVwINcTQV6pFrFQHaZGZZ"
]

response_headers

  0 of 0   
array:6 [▼
  "cache-control" => array:1 [▶
    0 => "max-age=604800, public"
  ]
  "date" => array:1 [▶
    0 => "Thu, 01 May 2025 15:25:53 GMT"
  ]
  "etag" => array:1 [▶
    0 => ""3fec1fd7ccac8e711a6c3a34322149f1""
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImpsUS9rNVB4WFd0Tkh4MXhmYzhDdFE9PSIsInZhbHVlIjoiL0MzK1RQa0FFODh4VGhpSm41TXM2WjNDMzZrL2Zxb2t6SHMyMGJPOURRc1o0V0dZdFk2UjNvZTZBSjNJZlE4aEEvYVVYOTJIRmhQbG5GRGhXQWZxQi9XQkJGN0xkTkRiV1AvLzFTRE1qVUIrVTBEaEZHNkxkZFVxdC9Gemd0K0oiLCJtYWMiOiIxNzdjYzdkYjBjYzNiNDQ2YTMwMTdkMDYzZGQxNzZlNThkN2E4OWQxOWNmNWNiYjkxM2QwMDhlMTc3NmYzNDk0IiwidGFnIjoiIn0%3D; expires=Thu, 01 May 2025 17:25:53 GMT; Max-Age=7199; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6ImpsUS9rNVB4WFd0Tkh4MXhmYzhDdFE9PSIsInZhbHVlIjoiL0MzK1RQa0FFODh4VGhpSm41TXM2WjNDMzZrL2Zxb2t6SHMyMGJPOURRc1o0V0dZdFk2UjNvZTZBSjNJZlE4aEEvYVVYO ▶"
    1 => "lowcostclub_session=eyJpdiI6IjF2Yi91M1dsZUNWbUNHS2tQSGszcWc9PSIsInZhbHVlIjoidmYwbFZVelFPVVhBam1aUjdkVnM3NGJDcEdTOWk4dThXSmlRUmEyeithOHVVV1JnbEl3ODZNWW9oYTJCTFFvNWQ4T0FPWlhYWHl0YzhSbHBTRzlZZlVRYkdIbUdTREp6WjVoZTd4VW90VnVGOWlsMEc0Yko1dEcyNVBLNUJDeGYiLCJtYWMiOiJmODk5MTdhNmMwMGY1ZDI2OGQ5ZGJiYTgzYWJkY2E4MjZlZjkzYWMwNmE3NDZmMzEwZTZlYWM2OGM3YjgyYzE2IiwidGFnIjoiIn0%3D; expires=Thu, 01 May 2025 17:25:53 GMT; Max-Age=7199; path=/; httponly; samesite=lax ◀lowcostclub_session=eyJpdiI6IjF2Yi91M1dsZUNWbUNHS2tQSGszcWc9PSIsInZhbHVlIjoidmYwbFZVelFPVVhBam1aUjdkVnM3NGJDcEdTOWk4dThXSmlRUmEyeithOHVVV1JnbEl3ODZNWW9oYTJCTFFv ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImpsUS9rNVB4WFd0Tkh4MXhmYzhDdFE9PSIsInZhbHVlIjoiL0MzK1RQa0FFODh4VGhpSm41TXM2WjNDMzZrL2Zxb2t6SHMyMGJPOURRc1o0V0dZdFk2UjNvZTZBSjNJZlE4aEEvYVVYOTJIRmhQbG5GRGhXQWZxQi9XQkJGN0xkTkRiV1AvLzFTRE1qVUIrVTBEaEZHNkxkZFVxdC9Gemd0K0oiLCJtYWMiOiIxNzdjYzdkYjBjYzNiNDQ2YTMwMTdkMDYzZGQxNzZlNThkN2E4OWQxOWNmNWNiYjkxM2QwMDhlMTc3NmYzNDk0IiwidGFnIjoiIn0%3D; expires=Thu, 01-May-2025 17:25:53 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6ImpsUS9rNVB4WFd0Tkh4MXhmYzhDdFE9PSIsInZhbHVlIjoiL0MzK1RQa0FFODh4VGhpSm41TXM2WjNDMzZrL2Zxb2t6SHMyMGJPOURRc1o0V0dZdFk2UjNvZTZBSjNJZlE4aEEvYVVYO ▶"
    1 => "lowcostclub_session=eyJpdiI6IjF2Yi91M1dsZUNWbUNHS2tQSGszcWc9PSIsInZhbHVlIjoidmYwbFZVelFPVVhBam1aUjdkVnM3NGJDcEdTOWk4dThXSmlRUmEyeithOHVVV1JnbEl3ODZNWW9oYTJCTFFvNWQ4T0FPWlhYWHl0YzhSbHBTRzlZZlVRYkdIbUdTREp6WjVoZTd4VW90VnVGOWlsMEc0Yko1dEcyNVBLNUJDeGYiLCJtYWMiOiJmODk5MTdhNmMwMGY1ZDI2OGQ5ZGJiYTgzYWJkY2E4MjZlZjkzYWMwNmE3NDZmMzEwZTZlYWM2OGM3YjgyYzE2IiwidGFnIjoiIn0%3D; expires=Thu, 01-May-2025 17:25:53 GMT; path=/; httponly ◀lowcostclub_session=eyJpdiI6IjF2Yi91M1dsZUNWbUNHS2tQSGszcWc9PSIsInZhbHVlIjoidmYwbFZVelFPVVhBam1aUjdkVnM3NGJDcEdTOWk4dThXSmlRUmEyeithOHVVV1JnbEl3ODZNWW9oYTJCTFFv ▶"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "73IyggBm74q5BcGrlEBEm0e6GmRMcp7D3DQRncNs"
  "_previous" => array:1 [▶
    "url" => "https://d.lowcost.club/cheap-flights-from-hanoi-to-lisbon-han-lis?_url=%2Fcheap-flights-from-hanoi-to-lisbon-han-lis"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-05-01 15:25:53	GET	/cheap-flights-from-hanoi-to-lisbon-han-lis	46 55 318

1 x Application (86.21%)	506ms
1 x Booting (13.78%)	80.97ms

Cheap flights Hanoi — Lisbon (HAN — LIS)

Choose your dates to find the flight:

Good to know - Cheap tickets Hanoi — Lisbon

Popular airlines flying Hanoi — Lisbon

Routes from nearby cities to Lisbon

Popular International routes from Hanoi

Popular routes from Lisbon

Popular domestic routes from Hanoi

Related pages

Select your currency

All currencies

Select your language

All languages