SitesRelationshipsSqlRepository.php#34aviatickets3.7msselect * from `sites_relationships` where `us` = 'cheap-flights-from-dalian-to-xiangyang-dlc-xfn' limit 1

Bindings	0: cheap-flights-from-dalian-to-xiangyang-dlc-xfn
Backtrace	app/Avia/Infrastructure/SitesRelationships/SitesRelationshipsSqlRepository.php:34 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/SitesRelationships/SitesRelationshipsSqlRepository.php:31 app/Http/Controllers/RoutesController.php:113

RoutesController.php#125aviatickets1.1msselect * from `flights_by` where `flights_by`.`id` = '1001457' 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.04msselect * from `cities` where `cities`.`id` = 1519 limit 1

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

RoutesController.php#136aviatickets1.05msselect * 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.08msselect * from `cities` where `cities`.`id` = 8926 limit 1

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

Bindings	0: 70
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#33aviatickets860μs

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

Bindings	0: 1001457
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#31aviatickets880μsselect * 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.74ms

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

Bindings	0: 1519 1: 8926 2: 2025-04-30 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.06msselect * from `monthly_price_statistics` where `origin_city_id` = 1519 and `destination_city_id` = 8926 limit 1

Bindings	0: 1519 1: 8926
Backtrace	app/Avia/Infrastructure/Repository/MonthlyPriceStatisticSqlRepository.php:66 app/Avia/Infrastructure/Repository/MonthlyPriceStatisticSqlRepository.php:50 app/Avia/Application/PriceHandler.php:42 app/Http/Controllers/RoutesController.php:156 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

AirlineSqlRepository.php#470aviatickets1.3ms

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

Bindings	0: 1519 1: 8926
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#470aviatickets1.01msselect * from `airlines` where `airlines`.`id` in (20299)

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.2msselect distinct `airline_id` from `timetables` where `origin_city_id` = 1519

Bindings	0: 1519
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.01msselect distinct `airline_id` from `timetables` where `origin_city_id` = 8926

Bindings	0: 8926
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.36msselect * from `airlines` where `id` in (1755, 1763, 3075, 4595, 5587, 17855, 21209) order by `name` asc

Bindings	0: 1755 1: 1763 2: 3075 3: 4595 4: 5587 5: 17855 6: 21209
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.11ms

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

Bindings	0: 1519 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.66ms

select * from `flights_by` where `origin_city_id` in (8932, 5591, 6655, 8375, 244, 5956, 8834, 5584, 6251, 6164) and `destination_city_id` = 8926 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 8932 1: 5591 2: 6655 3: 8375 4: 244 5: 5956 6: 8834 7: 5584 8: 6251 9: 6164 10: 8926 11: 0 12: 0
Backtrace	app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:73 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:58 app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:35

OfferSqlRepository.php#52aviatickets990μsselect * from `offers` where `origin_city_id` = 1519 and `destination_city_id` = 8926

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

LocalRouteRepository.php#447aviatickets1.51ms

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

Bindings	0: 1519 1: 1001457 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.04msselect * from `cities` where `cities`.`id` in (1519)

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.35msselect * from `cities` where `cities`.`id` in (2283, 5429, 9480)

Backtrace

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

LocalRouteRepository.php#447aviatickets1.01msselect * from `sites_relationships` where `sites_relationships`.`id` in (1020350, 1059944, 1082360)

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

Bindings	0: 207
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#412aviatickets2.61ms

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

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

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.85msselect * from `cities` where `cities`.`id` in (4539, 8905)

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.49msselect * from `sites_relationships` where `sites_relationships`.`id` in (86993, 87076)

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.53msselect * from `countries` where `countries`.`id` in (92, 248)

Backtrace

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

LocalRouteRepository.php#149aviatickets1.94ms

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

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

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.44msselect * from `cities` where `cities`.`id` in (696, 3654, 5610, 5907, 8893)

Backtrace

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

LocalRouteRepository.php#149aviatickets1.4msselect * from `countries` where `countries`.`id` in (6, 8, 17, 89, 136)

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.28msselect * from `sites_relationships` where `sites_relationships`.`id` in (365004, 495787, 510484, 883299, 1188614)

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

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

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

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.32msselect * from `cities` where `cities`.`id` in (684, 1627, 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#359aviatickets990μsselect * from `sites_relationships` where `sites_relationships`.`id` in (86833, 86846, 86880, 87027, 87045)

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.02msselect * 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.12ms

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

Bindings	0: 1519 1: 8926
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#39aviatickets1.07msselect * from `airports` where `airports`.`id` in (7424)

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#39aviatickets910μsselect * from `airports` where `airports`.`id` in (1784)

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#39aviatickets850μsselect * from `airlines` where `airlines`.`id` in (20299)

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#144aviatickets980μs

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

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

Bindings	0: 8926 1: 1519
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#520aviatickets790μsselect * from `sites_relationships` where `sites_relationships`.`id` in (495777)

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#99aviatickets960μsselect * from `cities` where `cities`.`id` = 1519 limit 1

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

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

LocalRouteRepository.php#175aviatickets1.19msselect * 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.08msselect * 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.12msselect * 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.24msselect * 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.12msselect * 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.6ms

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#149aviatickets980μsselect * 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.13msselect * 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#149aviatickets1msselect * 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#149aviatickets860μs

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: 52Timetable.php#?
App\Avia\Infrastructure\Model\City: 44City.php#?
App\Avia\Infrastructure\Model\LocalRoute: 42LocalRoute.php#?
App\Avia\Infrastructure\Model\SitesRelationship: 33SitesRelationship.php#?
App\Avia\Infrastructure\Model\Country: 21Country.php#?
App\Avia\Infrastructure\Model\Airline: 9Airline.php#?
App\Avia\Infrastructure\Model\Airport: 2Airport.php#?
App\Avia\Infrastructure\Model\MonthlyPriceStatistic: 1MonthlyPriceStatistic.php#?

_token: ACf3G9fj4MGO9HpjIAbotTDvgPQOzDgI2Md8lxJi
_previous: array:1 [ "url" => "https://d.lowcost.club/cheap-flights-from-dalian-to-xiangyang-dlc-xfn?_url=%2F...
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/cheap-flights-from-dalian-to-xiangyang-dlc-xfn

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:1 [▼
  "_url" => "/cheap-flights-from-dalian-to-xiangyang-dlc-xfn"
]

request_request

[]

request_headers

  0 of 0   
array:16 [▼
  "cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IndxelkybUFjdXVYRUFZRmpjd0daRWc9PSIsInZhbHVlIjoicVpWR2FMaTEwWHk3R1ZneEJMOWtyY2REQnlINysxdlpvWnAzakJHUDA4Vm0yOFFGcUNpMmZFUjJWOS8yQ205bU1rZWROd3c5dC9qWXpzSkJzZ0lLdHV2Sm14MG5hTVk4OWJvWjhOV253NVdVcXEvY3hma1NYR0tpTGxVQStpbzMiLCJtYWMiOiJhOWIxNmNkOTAwNzI0Njk5OTkzYjEyYmQzNjdlMzNkOWUxOWRjZmM4YzNiMGVmNWE5YzgxNDIzZWMwOTBiZDJmIiwidGFnIjoiIn0%3D; lowcostclub_session=eyJpdiI6ImhYTThLTzNLZEtob08vWGhxUUxzemc9PSIsInZhbHVlIjoiUmZ0Nkdqbmo2RlY2MUJIYjF2YlVBaUx2OFNsdFBXTkc4RlFmRzNlbDNHYXovWndYeFJGeVVLSEVCL0IybzlTNElmRExiM0V0cHZGS2wwVkl5bXEwM2xxRFUxT2d4Y3JuN3FTY0dieHc2Vnc3a21CQnBtQ1ZncnFIbHRqTDRiYXkiLCJtYWMiOiJkZDAwYTRkZTA5YTA2ZDM2MzVmZjI4M2FiYjJlNjc2YTI5Y2RhNjE3YjA3MjY0ZjQ3Yzc0MGY5ODJhZTQ4ODAzIiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6IndxelkybUFjdXVYRUFZRmpjd0daRWc9PSIsInZhbHVlIjoicVpWR2FMaTEwWHk3R1ZneEJMOWtyY2REQnlINysxdlpvWnAzakJHUDA4Vm0yOFFGcUNpMmZFUjJWOS8yQ205bU1rZWROd ▶"
  ]
  "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" => "ACf3G9fj4MGO9HpjIAbotTDvgPQOzDgI2Md8lxJi"
  "lowcostclub_session" => "eTtOjhkJxowHDsET3xkN2p6LMFAJGU2LTsmJJdcA"
]

response_headers

  0 of 0   
array:6 [▼
  "cache-control" => array:1 [▶
    0 => "max-age=604800, public"
  ]
  "date" => array:1 [▶
    0 => "Fri, 02 May 2025 04:49:27 GMT"
  ]
  "etag" => array:1 [▶
    0 => ""9a2b16f4f0cebeb2bd423b6b5cbea204""
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjZzNGkwUXZCTzlLblNXUDBGU1BWNVE9PSIsInZhbHVlIjoiRzVESmF6R3Fob2kyTXduWlRpd2F4TzJtd0ZPbWtLc2NDNG1FV0RLWEdrdnUwby9HYmN2andwNUJONmd2YVJhdVdWQWtFbytwOTAxQ1JxdmY2MW1HM0lYSWpReFhkR1RZVXZNWitqeGZnUW4wWkdpRXh0Z2VtTDNBbTdKdkQxVEkiLCJtYWMiOiJhNWQ2MzM4OWFiMTI4N2M2YjNhNzQ1ZDA5M2Q2M2IxMDg1MjRlMWI1NzI4NmYyNmIwYTZmNmI1YTkyMDU2ZDEzIiwidGFnIjoiIn0%3D; expires=Fri, 02 May 2025 06:49:27 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IjZzNGkwUXZCTzlLblNXUDBGU1BWNVE9PSIsInZhbHVlIjoiRzVESmF6R3Fob2kyTXduWlRpd2F4TzJtd0ZPbWtLc2NDNG1FV0RLWEdrdnUwby9HYmN2andwNUJONmd2YVJhdVdWQWtFb ▶"
    1 => "lowcostclub_session=eyJpdiI6IjJ4MjF1N3lyZXpQakRoNjFZcmkwS2c9PSIsInZhbHVlIjoieEdqMHpsS1J1YksrREdsOUYwcmU0a1BQQWMyVTh2Q3dLNEptcTdaaE95L1hIZHZVWS9DeWxqV2dlYnZySk5mMldsTzZRbmNOWjIrREJ6MWIxRmxIVEdEeW0vdVQ4OE5MSWtIVkJUby83ZDhIZEF6ejkrY05NREVXNFhyN3VXaG0iLCJtYWMiOiI0MzI4M2EyNGJhODg0YjAzYjA1YjRjMWQzNDk4NDBiYTc0ZTZkMTMzMjFjNmIyZTM1YWFmZTdjMTE5YjMyMTcwIiwidGFnIjoiIn0%3D; expires=Fri, 02 May 2025 06:49:27 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀lowcostclub_session=eyJpdiI6IjJ4MjF1N3lyZXpQakRoNjFZcmkwS2c9PSIsInZhbHVlIjoieEdqMHpsS1J1YksrREdsOUYwcmU0a1BQQWMyVTh2Q3dLNEptcTdaaE95L1hIZHZVWS9DeWxqV2dlYnZySk5m ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjZzNGkwUXZCTzlLblNXUDBGU1BWNVE9PSIsInZhbHVlIjoiRzVESmF6R3Fob2kyTXduWlRpd2F4TzJtd0ZPbWtLc2NDNG1FV0RLWEdrdnUwby9HYmN2andwNUJONmd2YVJhdVdWQWtFbytwOTAxQ1JxdmY2MW1HM0lYSWpReFhkR1RZVXZNWitqeGZnUW4wWkdpRXh0Z2VtTDNBbTdKdkQxVEkiLCJtYWMiOiJhNWQ2MzM4OWFiMTI4N2M2YjNhNzQ1ZDA5M2Q2M2IxMDg1MjRlMWI1NzI4NmYyNmIwYTZmNmI1YTkyMDU2ZDEzIiwidGFnIjoiIn0%3D; expires=Fri, 02-May-2025 06:49:27 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IjZzNGkwUXZCTzlLblNXUDBGU1BWNVE9PSIsInZhbHVlIjoiRzVESmF6R3Fob2kyTXduWlRpd2F4TzJtd0ZPbWtLc2NDNG1FV0RLWEdrdnUwby9HYmN2andwNUJONmd2YVJhdVdWQWtFb ▶"
    1 => "lowcostclub_session=eyJpdiI6IjJ4MjF1N3lyZXpQakRoNjFZcmkwS2c9PSIsInZhbHVlIjoieEdqMHpsS1J1YksrREdsOUYwcmU0a1BQQWMyVTh2Q3dLNEptcTdaaE95L1hIZHZVWS9DeWxqV2dlYnZySk5mMldsTzZRbmNOWjIrREJ6MWIxRmxIVEdEeW0vdVQ4OE5MSWtIVkJUby83ZDhIZEF6ejkrY05NREVXNFhyN3VXaG0iLCJtYWMiOiI0MzI4M2EyNGJhODg0YjAzYjA1YjRjMWQzNDk4NDBiYTc0ZTZkMTMzMjFjNmIyZTM1YWFmZTdjMTE5YjMyMTcwIiwidGFnIjoiIn0%3D; expires=Fri, 02-May-2025 06:49:27 GMT; path=/; httponly ◀lowcostclub_session=eyJpdiI6IjJ4MjF1N3lyZXpQakRoNjFZcmkwS2c9PSIsInZhbHVlIjoieEdqMHpsS1J1YksrREdsOUYwcmU0a1BQQWMyVTh2Q3dLNEptcTdaaE95L1hIZHZVWS9DeWxqV2dlYnZySk5m ▶"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "ACf3G9fj4MGO9HpjIAbotTDvgPQOzDgI2Md8lxJi"
  "_previous" => array:1 [▶
    "url" => "https://d.lowcost.club/cheap-flights-from-dalian-to-xiangyang-dlc-xfn?_url=%2Fcheap-flights-from-dalian-to-xiangyang-dlc-xfn"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-05-02 04:49:27	GET	/cheap-flights-from-dalian-to-xiangyang-dlc-xfn	43 57 204

1 x Application (91.62%)	260ms
1 x Booting (8.38%)	23.79ms

Cheap flights Dalian — Xiangyang (DLC — XFN)

Choose your dates to find the flight:

Good to know - Cheap tickets Dalian — Xiangyang

Popular airlines flying Dalian — Xiangyang

Airlines with direct flights

Other airlines flying with transfers

Popular International routes from Dalian

Popular routes from Xiangyang

Popular domestic routes from Dalian

Related pages

Select your currency

All currencies

Select your language

All languages