SitesRelationshipsSqlRepository.php#34aviatickets10.49msselect * from `sites_relationships` where `us` = 'cheap-flights-from-beijing-to-houston-bjs-hou' limit 1

Bindings	0: cheap-flights-from-beijing-to-houston-bjs-hou
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#125aviatickets5.09msselect * from `flights_by` where `flights_by`.`id` = '36901' 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.54msselect * from `cities` where `cities`.`id` = 684 limit 1

Bindings	0: 684
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#136aviatickets3msselect * from `countries` where `countries`.`id` = 70 limit 1

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

Bindings	0: 3098
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#138aviatickets2.18msselect * 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#33aviatickets970μs

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

Bindings	0: 36901
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.16msselect * 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.17ms

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

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

MonthlyPriceStatisticSqlRepository.php#66aviatickets990μsselect * from `monthly_price_statistics` where `origin_city_id` = 684 and `destination_city_id` = 3098 limit 1

Bindings	0: 684 1: 3098
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#470aviatickets900μs

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

Bindings	0: 684 1: 3098
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.59msselect distinct `airline_id` from `timetables` where `origin_city_id` = 684

Bindings	0: 684
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.02msselect distinct `airline_id` from `timetables` where `origin_city_id` = 3098

Bindings	0: 3098
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.6ms

select * from `airlines` where `id` in (136, 322, 328, 1352, 1652, 1676, 2087, 2179, 2338, 2982, 3084, 3314, 4078, 4419, 4929, 5184, 11914, 61733, 5407273) order by `name` asc

Bindings	0: 136 1: 322 2: 328 3: 1352 4: 1652 5: 1676 6: 2087 7: 2179 8: 2338 9: 2982 10: 3084 11: 3314 12: 4078 13: 4419 14: 4929 15: 5184 16: 11914 17: 61733 18: 5407273
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.13ms

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

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

NearbyCitiesAggregateDbProvider.php#73aviatickets1.89ms

select * from `flights_by` where `origin_city_id` in (6251, 8834, 5639, 1430, 5591, 1568, 6164, 8349, 8457, 6318) and `destination_city_id` = 3098 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 6251 1: 8834 2: 5639 3: 1430 4: 5591 5: 1568 6: 6164 7: 8349 8: 8457 9: 6318 10: 3098 11: 0 12: 0
Backtrace	app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:73 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:58 app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:35

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

Backtrace

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

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

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

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

Bindings	0: 6164
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.29msselect * from `offers` where `origin_city_id` = 684 and `destination_city_id` = 3098

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

LocalRouteRepository.php#447aviatickets3.31ms

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

Bindings	0: 684 1: 36901 2: 70 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.17msselect * from `cities` where `cities`.`id` in (684)

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.34msselect * from `cities` where `cities`.`id` in (2437, 2444, 2445)

Backtrace

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

LocalRouteRepository.php#447aviatickets1.08msselect * from `sites_relationships` where `sites_relationships`.`id` in (36902, 36904, 36905)

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

Bindings	0: 83
Backtrace	app/Avia/Infrastructure/Model/LocalRoute.php:125 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Model/LocalRoute.php:122 app/Avia/Infrastructure/Factory/DomainRouteFactory.php:49

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

Bindings	0: 16
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.49ms

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

Bindings	0: 684 1: 70 2: 0 3: 0 4: 36902
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.01msselect * from `cities` where `cities`.`id` in (684)

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.11msselect * from `cities` where `cities`.`id` in (696, 5537)

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.15msselect * from `sites_relationships` where `sites_relationships`.`id` in (36660, 37284)

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.52msselect * from `countries` where `countries`.`id` in (18, 89)

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

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

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

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.18msselect * from `cities` where `cities`.`id` in (774, 1462, 2515, 4081, 9249)

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 `countries` where `countries`.`id` in (123, 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.13msselect * from `sites_relationships` where `sites_relationships`.`id` in (135987, 136057, 136096, 136248, 136418)

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

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

Bindings	0: 684 1: 70 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.05msselect * from `cities` where `cities`.`id` in (684)

Backtrace

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

LocalRouteRepository.php#359aviatickets1.15msselect * from `cities` where `cities`.`id` in (1627, 2302, 5582, 5922, 8447)

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.04msselect * from `sites_relationships` where `sites_relationships`.`id` in (36707, 36802, 36876, 37290, 37339)

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

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

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

Bindings	0: 684 1: 3098
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.09ms

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

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

Bindings	0: 3098 1: 684
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#520aviatickets1.06msselect * from `sites_relationships` where `sites_relationships`.`id` in (135971)

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

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

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

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

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

LocalRouteRepository.php#175aviatickets1.4msselect * 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.4msselect * 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.49msselect * 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.32msselect * 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.44msselect * 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.68ms

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.31msselect * 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.38msselect * 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.14msselect * 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.01ms

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: 189Timetable.php#?
App\Avia\Infrastructure\Model\City: 49City.php#?
App\Avia\Infrastructure\Model\LocalRoute: 43LocalRoute.php#?
App\Avia\Infrastructure\Model\SitesRelationship: 34SitesRelationship.php#?
App\Avia\Infrastructure\Model\Airline: 19Airline.php#?
App\Avia\Infrastructure\Model\Country: 18Country.php#?
App\Avia\Infrastructure\Model\MonthlyPriceStatistic: 1MonthlyPriceStatistic.php#?

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

_token: EPxPHmXHOxbAkXiOGaPuQ7vvQGhmogVVJJIs9dva
_previous: array:1 [ "url" => "https://d.lowcost.club/cheap-flights-from-beijing-to-houston-bjs-hou?_url=%2Fc...
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/cheap-flights-from-beijing-to-houston-bjs-hou

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:1 [▼
  "_url" => "/cheap-flights-from-beijing-to-houston-bjs-hou"
]

request_request

[]

request_headers

  0 of 0   
array:16 [▼
  "cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InhMTGN2bXJzQ3ZOaEY4SVhMSVE2M3c9PSIsInZhbHVlIjoiSFozUC9rRkMySG5kdlY4VWN2VXVXajNFVWJKekl0ZTEzT1NXK0ZJdmdOS1VFV1pVYXUrTUc4VGJDV3RpSHhWdzFtZTF1czJvWXhJM2F4RTBqcDdzQUt0aUdXcE1Bc3ZkNHVUejlLMTBTK3JGbVZRUTc1a1hoZG9rYnRNNWlDeVEiLCJtYWMiOiI2M2Y5ZmUyODE4MWZmNGEzMDM1ZTFiOWJiMGZjMWYzMDQ0MGU2M2NmNTE1MDE0NTNjMDMwYjJmYmViZGNlMzJmIiwidGFnIjoiIn0%3D; lowcostclub_session=eyJpdiI6IkNxTTNOTW9WY2p1cGw2bU9VeVhaUkE9PSIsInZhbHVlIjoiL2ZSZW1LWXRCenlueWc2THRGcmNFenVNYnFxK3pxYUlZT2k1RWVMQVNtdSs1SCtXZHJYQ1B4L2U0NGdkVlp1VVNRZ25RUzZaclM4K1AyQVZuenNoUk9ueEZCdmpLYjdoNVpQUE9wSVM5VmE1ZFh6bmtPWFFNcU1XM0thd2F0MSsiLCJtYWMiOiJkZGJiYzVlZjMzZTQ4YmRiOGU2OThhNGZhNTlmYTMyYjg3N2MwZThkNTRmZGUyNWEyNjk4NjE0N2UxMGNkYzViIiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6InhMTGN2bXJzQ3ZOaEY4SVhMSVE2M3c9PSIsInZhbHVlIjoiSFozUC9rRkMySG5kdlY4VWN2VXVXajNFVWJKekl0ZTEzT1NXK0ZJdmdOS1VFV1pVYXUrTUc4VGJDV3RpSHhWdzFtZTF1c ▶"
  ]
  "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" => "EPxPHmXHOxbAkXiOGaPuQ7vvQGhmogVVJJIs9dva"
  "lowcostclub_session" => "BHMKoewWaRtvGjlb8INrFcfxWw9x9lH4xORdqQFl"
]

response_headers

  0 of 0   
array:6 [▼
  "cache-control" => array:1 [▶
    0 => "max-age=604800, public"
  ]
  "date" => array:1 [▶
    0 => "Wed, 07 May 2025 02:04:26 GMT"
  ]
  "etag" => array:1 [▶
    0 => ""50cc3054d2b5f36264d7538d1cd3868b""
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkpIUHhudTQvSFpUdkdaOUZnWThiZlE9PSIsInZhbHVlIjoiMTlNUWwzZE9RamV5aFlrV3llWlphYU9rUUd2dUtZU0pYOC9ka05USDg2KzlUSGVQTitkTnhTSnJoK2t4SUo0MFpnVUIvVytvNzJmR2U0b3YwTVBUVnBhZ1AvaWdSbm1PQWFvRzFCNDd6RlozWEEvU2phM3Mrc3FEcG51N2o5bUUiLCJtYWMiOiI5ZTgyZGVhNTU4N2NlZTNkNjJjYThhYzRkNGZmYWRjN2RjMjVmZDRhNzI1YjJkZThmN2Y1Y2Q1ZmJlMzEzOTQ0IiwidGFnIjoiIn0%3D; expires=Wed, 07 May 2025 04:04:26 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IkpIUHhudTQvSFpUdkdaOUZnWThiZlE9PSIsInZhbHVlIjoiMTlNUWwzZE9RamV5aFlrV3llWlphYU9rUUd2dUtZU0pYOC9ka05USDg2KzlUSGVQTitkTnhTSnJoK2t4SUo0MFpnVUIvV ▶"
    1 => "lowcostclub_session=eyJpdiI6IkhoL1FPWTkrUSs0OHRmdkc0Sk9LNVE9PSIsInZhbHVlIjoiTFdMaFM5ZmQxMit2ZldheTVpbzVZQTAyMkJxbTR4WnN0cThhcTRTSGVacTE0cWNrUWhPb0NLU2pkZ1ZTNkVpdzZJa0JRNjhIOUFJRXJoV1QxUFFwQXo3SEs0bzYwaStkTU14dm1wV3NUL1Jwb2NPbVcrT2VmaFhUU2VOODFoYksiLCJtYWMiOiJkZDYzMTYyNDA3YWEwOTA4ZTc2NmY4NWE5MGM1MGI5MjRiMzIwMWUxYmFhMGE4YjZjNThjYTBlODg1ODQ0MzgzIiwidGFnIjoiIn0%3D; expires=Wed, 07 May 2025 04:04:26 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀lowcostclub_session=eyJpdiI6IkhoL1FPWTkrUSs0OHRmdkc0Sk9LNVE9PSIsInZhbHVlIjoiTFdMaFM5ZmQxMit2ZldheTVpbzVZQTAyMkJxbTR4WnN0cThhcTRTSGVacTE0cWNrUWhPb0NLU2pkZ1ZTNkVp ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkpIUHhudTQvSFpUdkdaOUZnWThiZlE9PSIsInZhbHVlIjoiMTlNUWwzZE9RamV5aFlrV3llWlphYU9rUUd2dUtZU0pYOC9ka05USDg2KzlUSGVQTitkTnhTSnJoK2t4SUo0MFpnVUIvVytvNzJmR2U0b3YwTVBUVnBhZ1AvaWdSbm1PQWFvRzFCNDd6RlozWEEvU2phM3Mrc3FEcG51N2o5bUUiLCJtYWMiOiI5ZTgyZGVhNTU4N2NlZTNkNjJjYThhYzRkNGZmYWRjN2RjMjVmZDRhNzI1YjJkZThmN2Y1Y2Q1ZmJlMzEzOTQ0IiwidGFnIjoiIn0%3D; expires=Wed, 07-May-2025 04:04:26 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IkpIUHhudTQvSFpUdkdaOUZnWThiZlE9PSIsInZhbHVlIjoiMTlNUWwzZE9RamV5aFlrV3llWlphYU9rUUd2dUtZU0pYOC9ka05USDg2KzlUSGVQTitkTnhTSnJoK2t4SUo0MFpnVUIvV ▶"
    1 => "lowcostclub_session=eyJpdiI6IkhoL1FPWTkrUSs0OHRmdkc0Sk9LNVE9PSIsInZhbHVlIjoiTFdMaFM5ZmQxMit2ZldheTVpbzVZQTAyMkJxbTR4WnN0cThhcTRTSGVacTE0cWNrUWhPb0NLU2pkZ1ZTNkVpdzZJa0JRNjhIOUFJRXJoV1QxUFFwQXo3SEs0bzYwaStkTU14dm1wV3NUL1Jwb2NPbVcrT2VmaFhUU2VOODFoYksiLCJtYWMiOiJkZDYzMTYyNDA3YWEwOTA4ZTc2NmY4NWE5MGM1MGI5MjRiMzIwMWUxYmFhMGE4YjZjNThjYTBlODg1ODQ0MzgzIiwidGFnIjoiIn0%3D; expires=Wed, 07-May-2025 04:04:26 GMT; path=/; httponly ◀lowcostclub_session=eyJpdiI6IkhoL1FPWTkrUSs0OHRmdkc0Sk9LNVE9PSIsInZhbHVlIjoiTFdMaFM5ZmQxMit2ZldheTVpbzVZQTAyMkJxbTR4WnN0cThhcTRTSGVacTE0cWNrUWhPb0NLU2pkZ1ZTNkVp ▶"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "EPxPHmXHOxbAkXiOGaPuQ7vvQGhmogVVJJIs9dva"
  "_previous" => array:1 [▶
    "url" => "https://d.lowcost.club/cheap-flights-from-beijing-to-houston-bjs-hou?_url=%2Fcheap-flights-from-beijing-to-houston-bjs-hou"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-05-07 02:04:26	GET	/cheap-flights-from-beijing-to-houston-bjs-hou	45 60 353 1

1 x Application (93.12%)	326ms
1 x Booting (6.88%)	24.05ms

Cheap flights Beijing — Houston (BJS — HOU)

Choose your dates to find the flight:

Good to know - Cheap tickets Beijing — Houston

Popular airlines flying Beijing — Houston

Routes from nearby cities to Houston

Popular International routes from Beijing

Popular routes from Houston

Popular domestic routes from Beijing

Related pages

Select your currency

All currencies

Select your language

All languages