The most frequent flight to Dayong is from Xian. The cheapest airfare can be purchased with a flight from Chongqing from $62. The nearest airports from Changde with a flight to Dayong are in Changsha.

Popular International routes from Changde

Changde — Moscow

from $322 one-way

Changde — Phnom Penh

from $161 one-way

Changde — Hanoi

from $192 one-way

Changde — Hong Kong

from $151 one-way

Changde — Macau

from $114 one-way

Popular routes from Dayong

If you are going to fly from Dayong, then study the popular flights. The most popular flights from Dayong:

from $60 one-way

from $107 one-way

from $238 one-way

from $47 one-way

from $135 one-way

Popular domestic routes from Changde

from $131 one-way

from $222 one-way

from $481 one-way

from $96 one-way

from $92 one-way

Return flights Dayong – Changde

Messages Timeline Exceptions Views53 Route Queries81 Models362 Mails Gate N+1 Queries3 Session Request

Request history8.3.0471ms4MBGET cheap-flights-from-{slug}

Booting (25.4ms)time
Application (445ms)time
1 x Application (94.6%)
445ms
1 x Booting (5.39%)
25.40ms

53 templates were rendered

1x views_us.routes.viewview.blade.php#?blade
1x routes.viewview.blade.php#?blade
1x index.section-slideshowsection-slideshow.blade.php#?blade
1x components.avia-formavia-form.blade.php#?blade
1x breadcrumbs::bootstrap4bootstrap4.blade.php#?blade
1x routes.section-advantagessection-advantages.blade.php#?blade
1x routes.AirlinesListAirlinesList.blade.php#?blade
3x components.airlines-columnairlines-column.blade.php#?blade
4x components.routes-listroutes-list.blade.php#?blade
24x components.routeListItemrouteListItem.blade.php#?blade
1x routes.description-nearbyCitiesdescription-nearbyCities.blade.php#?blade
2x components.routes-columnroutes-column.blade.php#?blade
1x components.related-linksrelated-links.blade.php#?blade
1x layouts.mainmain.blade.php#?blade
1x headerheader.blade.php#?blade
2x menumenu.blade.php#?blade
1x footerfooter.blade.php#?blade
1x components.footer-popular-flightsfooter-popular-flights.blade.php#?blade
1x footer_scriptsfooter_scripts.blade.php#?blade
1x components.currencycurrency.blade.php#?blade
2x components.popuppopup.blade.php#?blade
1x components.languagelanguage.blade.php#?blade

uri: GET cheap-flights-from-{slug}
middleware: web
controller: App\Http\Controllers\RoutesController@view
namespace
prefix: /
where
as: route
file: app/Http/Controllers/RoutesController.php:96-299

81 statements were executed (38 duplicates)Show only duplicates106ms

QueryDetector.php#25aviaticketsConnection Established

Backtrace

vendor/beyondcode/laravel-query-detector/src/QueryDetector.php:25
vendor/beyondcode/laravel-query-detector/src/QueryDetectorMiddleware.php:30
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
app/Http/Middleware/MinifyHtml.php:21

SitesRelationshipsSqlRepository.php#34aviatickets4.28msselect * from `sites_relationships` where `us` = 'cheap-flights-from-changde-to-dayong-cgd-dyg' limit 1

Bindings	0: cheap-flights-from-changde-to-dayong-cgd-dyg
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.43msselect * from `flights_by` where `flights_by`.`id` = '64494' 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.29msselect * from `cities` where `cities`.`id` = 8348 limit 1

Bindings	0: 8348
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.41msselect * 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.19msselect * from `cities` where `cities`.`id` = 1627 limit 1

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

RoutesController.php#138aviatickets1.42msselect * 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#33aviatickets1.1ms

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

Bindings	0: 64494
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#31aviatickets990μ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.24ms

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

Bindings	0: 8348 1: 1627 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#66aviatickets1.15msselect * from `monthly_price_statistics` where `origin_city_id` = 8348 and `destination_city_id` = 1627 limit 1

Bindings	0: 8348 1: 1627
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.15ms

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

Bindings	0: 8348 1: 1627
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.03msselect distinct `airline_id` from `timetables` where `origin_city_id` = 8348

Bindings	0: 8348
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.16msselect distinct `airline_id` from `timetables` where `origin_city_id` = 1627

Bindings	0: 1627
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.23msselect * from `airlines` where `id` in (1755, 1763, 4591, 4592, 5587) order by `name` asc

Bindings	0: 1755 1: 1763 2: 4591 3: 4592 4: 5587
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.05ms

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

Bindings	0: 8348 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#73aviatickets2ms

select * from `flights_by` where `origin_city_id` in (1627, 1310, 6782, 1162, 2347, 8447, 1103, 9369, 5942, 4419) and `destination_city_id` = 1627 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 1627 1: 1310 2: 6782 3: 1162 4: 2347 5: 8447 6: 1103 7: 9369 8: 5942 9: 4419 10: 1627 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.36msselect * from `cities` where `cities`.`id` in (1103, 1162, 1310, 2347, 4419, 5942, 6782, 8447, 9369)

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

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

select * from `sites_relationships` where `sites_relationships`.`id` in (59485, 65236, 69331, 76897, 131814, 234726, 301939, 322535, 364565)

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

LocalRouteRepository.php#558aviatickets2.77ms

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

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

NearbyCitiesAggregateDbProvider.php#73aviatickets2.15ms

select * from `flights_by` where `origin_city_id` in (1627, 1310, 6782, 1162, 2347, 8447, 1103, 9369, 5942, 4419) and `destination_city_id` = 1627 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 1627 1: 1310 2: 6782 3: 1162 4: 2347 5: 8447 6: 1103 7: 9369 8: 5942 9: 4419 10: 1627 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:85

NearbyCitiesAggregateDbProvider.php#73aviatickets1.31msselect * from `cities` where `cities`.`id` in (1103, 1162, 1310, 2347, 4419, 5942, 6782, 8447, 9369)

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:85

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

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:85

NearbyCitiesAggregateDbProvider.php#73aviatickets1.08ms

select * from `sites_relationships` where `sites_relationships`.`id` in (59485, 65236, 69331, 76897, 131814, 234726, 301939, 322535, 364565)

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:85

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

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

LocalRouteRepository.php#558aviatickets1.09ms

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

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

NearbyCitiesAggregateDbProvider.php#73aviatickets2.04ms

select * from `flights_by` where `origin_city_id` in (1627, 1310, 6782, 1162, 2347, 8447, 1103, 9369, 5942, 4419) and `destination_city_id` = 1627 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 1627 1: 1310 2: 6782 3: 1162 4: 2347 5: 8447 6: 1103 7: 9369 8: 5942 9: 4419 10: 1627 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:142

NearbyCitiesAggregateDbProvider.php#73aviatickets1.53msselect * from `cities` where `cities`.`id` in (1103, 1162, 1310, 2347, 4419, 5942, 6782, 8447, 9369)

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:142

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

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:142

NearbyCitiesAggregateDbProvider.php#73aviatickets1.05ms

select * from `sites_relationships` where `sites_relationships`.`id` in (59485, 65236, 69331, 76897, 131814, 234726, 301939, 322535, 364565)

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:142

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

Bindings	0: 1162
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:158

LocalRouteRepository.php#558aviatickets1.14ms

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

Bindings	0: 8348 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.86ms

select * from `flights_by` where `origin_city_id` in (1627, 1310, 6782, 1162, 2347, 8447, 1103, 9369, 5942, 4419) and `destination_city_id` = 1627 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 1627 1: 1310 2: 6782 3: 1162 4: 2347 5: 8447 6: 1103 7: 9369 8: 5942 9: 4419 10: 1627 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:123

NearbyCitiesAggregateDbProvider.php#73aviatickets1.11msselect * from `cities` where `cities`.`id` in (1103, 1162, 1310, 2347, 4419, 5942, 6782, 8447, 9369)

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:123

NearbyCitiesAggregateDbProvider.php#73aviatickets940μsselect * from `cities` where `cities`.`id` in (1627)

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:123

NearbyCitiesAggregateDbProvider.php#73aviatickets960μs

select * from `sites_relationships` where `sites_relationships`.`id` in (59485, 65236, 69331, 76897, 131814, 234726, 301939, 322535, 364565)

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:123

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

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

LocalRouteRepository.php#558aviatickets1.25ms

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

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

NearbyCitiesAggregateDbProvider.php#73aviatickets2.01ms

select * from `flights_by` where `origin_city_id` in (1627, 1310, 6782, 1162, 2347, 8447, 1103, 9369, 5942, 4419) and `destination_city_id` = 1627 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 1627 1: 1310 2: 6782 3: 1162 4: 2347 5: 8447 6: 1103 7: 9369 8: 5942 9: 4419 10: 1627 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:142

NearbyCitiesAggregateDbProvider.php#73aviatickets1.24msselect * from `cities` where `cities`.`id` in (1103, 1162, 1310, 2347, 4419, 5942, 6782, 8447, 9369)

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:142

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

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:142

NearbyCitiesAggregateDbProvider.php#73aviatickets990μs

select * from `sites_relationships` where `sites_relationships`.`id` in (59485, 65236, 69331, 76897, 131814, 234726, 301939, 322535, 364565)

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:142

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

Bindings	0: 1162
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:158

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

Bindings	0: 8348 1: 1627
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.73ms

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

Bindings	0: 8348 1: 64494 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.02msselect * from `cities` where `cities`.`id` in (8348)

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 (2305, 2380, 3898)

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#447aviatickets890μsselect * from `sites_relationships` where `sites_relationships`.`id` in (64495, 64496, 64501)

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

Bindings	0: 169
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.44ms

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

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

LocalRouteRepository.php#412aviatickets1.41msselect * from `cities` where `cities`.`id` in (8348)

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

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 `sites_relationships` where `sites_relationships`.`id` in (64502, 1177355)

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.2msselect * from `countries` where `countries`.`id` in (28, 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.43ms

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

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

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.27msselect * from `cities` where `cities`.`id` in (684, 4081, 5582, 5922, 9369)

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 (70, 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#149aviatickets1msselect * from `sites_relationships` where `sites_relationships`.`id` in (96429, 96458, 96466, 96468, 96471)

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

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

Bindings	0: 8348 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#359aviatickets970μsselect * from `cities` where `cities`.`id` in (8348)

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.1msselect * from `cities` where `cities`.`id` in (684, 1627, 5582, 5922, 9369)

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#359aviatickets880μsselect * from `sites_relationships` where `sites_relationships`.`id` in (64488, 64494, 64505, 64506, 399733)

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#359aviatickets980μsselect * 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.41ms

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

Bindings	0: 8348 1: 1627
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.34ms

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

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

Bindings	0: 1627 1: 8348
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.04msselect * from `sites_relationships` where `sites_relationships`.`id` in (96433)

Backtrace

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

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

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

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

description-nearbyCities.blade.php#28aviatickets1.28msselect * from `cities` where `cities`.`id` = 8348 limit 1

Bindings	0: 8348
Backtrace	view::routes.description-nearbyCities:28 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.36msselect * 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.26msselect * 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.26msselect * 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.1msselect * 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#175aviatickets970μsselect * from `sites_relationships` where `sites_relationships`.`id` in (32301, 46235, 46251, 180255, 201516, 240458)

Backtrace

app/Avia/Infrastructure/Repository/LocalRouteRepository.php:175
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:179
app/Avia/Application/SeoRoutesHandler.php:40

LocalRouteRepository.php#149aviatickets2.01ms

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.14msselect * 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.45msselect * from `cities` where `cities`.`id` in (1115, 1903, 2686, 3445, 3448, 3505, 3951, 4081, 8389)

Backtrace

app/Avia/Infrastructure/Repository/LocalRouteRepository.php:149
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:153
app/Avia/Application/SeoRoutesHandler.php:54

LocalRouteRepository.php#149aviatickets1.38msselect * from `countries` where `countries`.`id` in (92, 134, 242, 248)

Backtrace

app/Avia/Infrastructure/Repository/LocalRouteRepository.php:149
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:153
app/Avia/Application/SeoRoutesHandler.php:54

LocalRouteRepository.php#149aviatickets1.07ms

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\LocalRoute: 127LocalRoute.php#?
App\Avia\Infrastructure\Model\City: 99City.php#?
App\Avia\Infrastructure\Model\SitesRelationship: 78SitesRelationship.php#?
App\Avia\Infrastructure\Model\Timetable: 35Timetable.php#?
App\Avia\Infrastructure\Model\Country: 17Country.php#?
App\Avia\Infrastructure\Model\Airline: 5Airline.php#?
App\Avia\Infrastructure\Model\MonthlyPriceStatistic: 1MonthlyPriceStatistic.php#?

infoModel: App\Avia\Infrastructure\Model\LocalRoute => Relation: App\Avia\Infrastructure\Model\City - Yo...
infoModel: App\Avia\Infrastructure\Model\LocalRoute => Relation: App\Avia\Infrastructure\Model\City - Yo...
infoModel: App\Avia\Infrastructure\Model\LocalRoute => Relation: App\Avia\Infrastructure\Model\SitesRela...

_token: oH4rqldl5bs4o1OZzGr2zrWW4VnqDDCEldQco7Pq
_previous: array:1 [ "url" => "https://d.lowcost.club/cheap-flights-from-changde-to-dayong-cgd-dyg?_url=%2Fch...
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/cheap-flights-from-changde-to-dayong-cgd-dyg

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:1 [▼
  "_url" => "/cheap-flights-from-changde-to-dayong-cgd-dyg"
]

request_request

[]

request_headers

  0 of 0   
array:16 [▼
  "cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkNCUG44WlpDbUk3RnFia1cyRGtTeUE9PSIsInZhbHVlIjoiRG5mYVhHdyt6L2F0YlFLL0tNNU5kVFIvenVSbGU2MHFicGt1VWFaUWlqUnJXRXdIMVZ4VDBSMkplUWQ5bDdsR2dVU2RmUlZsTTZWaUdLZnFRWXlIQUNqYlhXUjV1eldYVFJXY00wTzVMd2YvUG9LbUJGaGRwS0lGaWI0dHNnaWMiLCJtYWMiOiJhYjhkYWUwY2Y2N2QxOWU1MDRkYmMzMWQ0M2Y1NGY4MzYwZmIyMjY0ODI5YTgwMmUwNmU5MGZkMGU0MGJhMTMxIiwidGFnIjoiIn0%3D; lowcostclub_session=eyJpdiI6ImR2RXBCcEpXNldFT3hWNmI1TWxrRlE9PSIsInZhbHVlIjoiTEx0KzhoWW1oTkIwQzdYV240TFNKaldIMTgvd3BKQmd5cENqUHg1ZGRKaHFpZTJFblNiQ3doRG94VUVsYTlsbTgyRm5xeE9YeXhhTndvTVMvR1REUm9IQUJBU3cxZTEyc20xQ1N3UUFvNTVZekdSK3Y4VWNRdjI5LzRpV0NFR1oiLCJtYWMiOiIxNDgwYjNlZTE4YzhmOTU4ZTMwYmYwMzNmZjYwMDk1MzQ3MGQ4ZmZjMTJjZmQ4OGMyMDQxMTQxN2Y1YTc0MmQ4IiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6IkNCUG44WlpDbUk3RnFia1cyRGtTeUE9PSIsInZhbHVlIjoiRG5mYVhHdyt6L2F0YlFLL0tNNU5kVFIvenVSbGU2MHFicGt1VWFaUWlqUnJXRXdIMVZ4VDBSMkplUWQ5bDdsR2dVU2RmU ▶"
  ]
  "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" => "oH4rqldl5bs4o1OZzGr2zrWW4VnqDDCEldQco7Pq"
  "lowcostclub_session" => "wSPRZDhD1UqowQPkDzZcUtqLhbD5gtbtVTodpnTZ"
]

response_headers

  0 of 0   
array:6 [▼
  "cache-control" => array:1 [▶
    0 => "max-age=604800, public"
  ]
  "date" => array:1 [▶
    0 => "Wed, 07 May 2025 03:49:34 GMT"
  ]
  "etag" => array:1 [▶
    0 => ""7c46cd33a5269d83af7c8ee1e5819bb3""
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IldLWTRvaGFpUFJmTWpNTTYwcG43Y2c9PSIsInZhbHVlIjoiNmY0Sk9HRUlpMDVTQU83MDIybWlQMkpqdHBJK2lSNUlQSFlNTkpTRTRMZFBIaFVyU2x3UGt4KzUwRGRvczV1d2NLNDRxNnkxanV1cmErK0RDMUxmWEFWZlE3anB5Y3YxVXhvYm04a3l6OWM4Q05zWkN6WjZWaENWOERyd1lUWGYiLCJtYWMiOiI2YTZiNDkyODI4MTA0NWJjYzMxMzk5NmM4MTUwY2E5MGVlYzI5MWQwZTljNzYyZTVlNTViYjJkMGU1ODBhZTZiIiwidGFnIjoiIn0%3D; expires=Wed, 07 May 2025 05:49:34 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IldLWTRvaGFpUFJmTWpNTTYwcG43Y2c9PSIsInZhbHVlIjoiNmY0Sk9HRUlpMDVTQU83MDIybWlQMkpqdHBJK2lSNUlQSFlNTkpTRTRMZFBIaFVyU2x3UGt4KzUwRGRvczV1d2NLNDRxN ▶"
    1 => "lowcostclub_session=eyJpdiI6IndtSmZYa1pzV0E1a3BYWE8rQnZpOXc9PSIsInZhbHVlIjoiNzV6RGVyN1AzdkJuRkowMUUyWHFoaXIrVFFFNWlQZUxRTGowd3FlY0xyRkNnSmxGYVdrUWRuUytxOVF6L3BmS25GeGhwdnlWNXJLcWtMT0ZMNUJaOENOS1U4bEp6UVA3OVlxUlBacldqR29YUE8vTWM4Y1Ftc2N5bkpQRXc5dEoiLCJtYWMiOiIxZmNkMjM1NTJjMTg0MmI0ZDIyZjIwM2UwN2U5MjkyMmUxZTRlYzZiNTNkOWViNWE5YTdkNzMzNWE4MDUxNzQ1IiwidGFnIjoiIn0%3D; expires=Wed, 07 May 2025 05:49:34 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀lowcostclub_session=eyJpdiI6IndtSmZYa1pzV0E1a3BYWE8rQnZpOXc9PSIsInZhbHVlIjoiNzV6RGVyN1AzdkJuRkowMUUyWHFoaXIrVFFFNWlQZUxRTGowd3FlY0xyRkNnSmxGYVdrUWRuUytxOVF6L3Bm ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IldLWTRvaGFpUFJmTWpNTTYwcG43Y2c9PSIsInZhbHVlIjoiNmY0Sk9HRUlpMDVTQU83MDIybWlQMkpqdHBJK2lSNUlQSFlNTkpTRTRMZFBIaFVyU2x3UGt4KzUwRGRvczV1d2NLNDRxNnkxanV1cmErK0RDMUxmWEFWZlE3anB5Y3YxVXhvYm04a3l6OWM4Q05zWkN6WjZWaENWOERyd1lUWGYiLCJtYWMiOiI2YTZiNDkyODI4MTA0NWJjYzMxMzk5NmM4MTUwY2E5MGVlYzI5MWQwZTljNzYyZTVlNTViYjJkMGU1ODBhZTZiIiwidGFnIjoiIn0%3D; expires=Wed, 07-May-2025 05:49:34 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IldLWTRvaGFpUFJmTWpNTTYwcG43Y2c9PSIsInZhbHVlIjoiNmY0Sk9HRUlpMDVTQU83MDIybWlQMkpqdHBJK2lSNUlQSFlNTkpTRTRMZFBIaFVyU2x3UGt4KzUwRGRvczV1d2NLNDRxN ▶"
    1 => "lowcostclub_session=eyJpdiI6IndtSmZYa1pzV0E1a3BYWE8rQnZpOXc9PSIsInZhbHVlIjoiNzV6RGVyN1AzdkJuRkowMUUyWHFoaXIrVFFFNWlQZUxRTGowd3FlY0xyRkNnSmxGYVdrUWRuUytxOVF6L3BmS25GeGhwdnlWNXJLcWtMT0ZMNUJaOENOS1U4bEp6UVA3OVlxUlBacldqR29YUE8vTWM4Y1Ftc2N5bkpQRXc5dEoiLCJtYWMiOiIxZmNkMjM1NTJjMTg0MmI0ZDIyZjIwM2UwN2U5MjkyMmUxZTRlYzZiNTNkOWViNWE5YTdkNzMzNWE4MDUxNzQ1IiwidGFnIjoiIn0%3D; expires=Wed, 07-May-2025 05:49:34 GMT; path=/; httponly ◀lowcostclub_session=eyJpdiI6IndtSmZYa1pzV0E1a3BYWE8rQnZpOXc9PSIsInZhbHVlIjoiNzV6RGVyN1AzdkJuRkowMUUyWHFoaXIrVFFFNWlQZUxRTGowd3FlY0xyRkNnSmxGYVdrUWRuUytxOVF6L3Bm ▶"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "oH4rqldl5bs4o1OZzGr2zrWW4VnqDDCEldQco7Pq"
  "_previous" => array:1 [▶
    "url" => "https://d.lowcost.club/cheap-flights-from-changde-to-dayong-cgd-dyg?_url=%2Fcheap-flights-from-changde-to-dayong-cgd-dyg"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-05-07 03:49:34	GET	/cheap-flights-from-changde-to-dayong-cgd-dyg	53 81 362 3

1 x Application (94.6%)	445ms
1 x Booting (5.39%)	25.40ms

Cheap flights Changde — Dayong (CGD — DYG)

Choose your dates to find the flight:

Good to know - Cheap tickets Changde — Dayong

Popular airlines flying Changde — Dayong

Routes from nearby cities to Dayong

Popular International routes from Changde

Popular routes from Dayong

Popular domestic routes from Changde

Related pages

Select your currency

All currencies

Select your language

All languages