The most frequent flight to Alicante is from Dusseldorf. The cheapest airfare can be purchased with a flight from Cologne from $23. The nearest airports from Rotterdam with a flight to Alicante are in Luxembourg.

Popular International routes from Rotterdam

Rotterdam — Moscow

from $162 one-way

Rotterdam — Saint Petersburg

from $222 one-way

Rotterdam — Algiers

from $161 one-way

Rotterdam — Amman

from $213 one-way

Rotterdam — Ankara

from $183 one-way

Popular routes from Alicante

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

Alicante — Moscow

from $183 one-way

Alicante — Saint Petersburg

from $115 one-way

Alicante — Gdansk

from $27 one-way

Alicante — Guayaquil

from $687 one-way

Alicante — Istanbul

from $63 one-way

Popular domestic routes from Rotterdam

Rotterdam — Amsterdam

from $31 one-way

Rotterdam — Eindhoven

from $130 one-way

Return flights Alicante – Rotterdam

Schedule of direct flights Rotterdam — Alicante

Messages Timeline Exceptions Views54 Route Queries86 Models515 Mails Gate N+1 Queries4 Session Request

Request history8.3.0480ms5MBGET cheap-flights-from-{slug}

Booting (24.18ms)time
Application (456ms)time
1 x Application (94.96%)
456ms
1 x Booting (5.04%)
24.18ms

54 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
6x components.airlines-columnairlines-column.blade.php#?blade
4x components.routes-listroutes-list.blade.php#?blade
22x 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

86 statements were executed (36 duplicates)Show only duplicates117ms

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.02msselect * from `sites_relationships` where `us` = 'cheap-flights-from-rotterdam-to-alicante-rtm-alc' limit 1

Bindings	0: cheap-flights-from-rotterdam-to-alicante-rtm-alc
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.23msselect * from `flights_by` where `flights_by`.`id` = '285751' 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.47msselect * from `cities` where `cities`.`id` = 5420 limit 1

Bindings	0: 5420
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#136aviatickets2.18msselect * from `countries` where `countries`.`id` = 99 limit 1

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

Bindings	0: 178
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.32msselect * from `countries` where `countries`.`id` = 23 limit 1

Bindings	0: 23
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#33aviatickets980μs

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

Bindings	0: 285751
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.26msselect * 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.79ms

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

Bindings	0: 5420 1: 178 2: 2025-05-04 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.34msselect * from `monthly_price_statistics` where `origin_city_id` = 5420 and `destination_city_id` = 178 limit 1

Bindings	0: 5420 1: 178
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#470aviatickets5.06ms

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

Bindings	0: 5420 1: 178
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.35msselect * from `airlines` where `airlines`.`id` in (1544, 5017, 65824)

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` = 5420

Bindings	0: 5420
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.24msselect distinct `airline_id` from `timetables` where `origin_city_id` = 178

Bindings	0: 178
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.75ms

select * from `airlines` where `id` in (879, 1352, 2817, 3020, 3084, 4513, 4943, 5075, 5829, 17856, 17920, 17925, 20121, 24064, 70369, 70392, 259328, 1321150, 5407273, 5438487, 16569751) order by `name` asc

Bindings	0: 879 1: 1352 2: 2817 3: 3020 4: 3084 5: 4513 6: 4943 7: 5075 8: 5829 9: 17856 10: 17920 11: 17925 12: 20121 13: 24064 14: 70369 15: 70392 16: 259328 17: 1321150 18: 5407273 19: 5438487 20: 16569751
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.23ms

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

Bindings	0: 5420 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.84ms

select * from `flights_by` where `origin_city_id` in (214, 9224, 3074, 825, 3535, 3570, 9260, 1102, 1918, 3742) and `destination_city_id` = 178 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 214 1: 9224 2: 3074 3: 825 4: 3535 5: 3570 6: 9260 7: 1102 8: 1918 9: 3742 10: 178 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.37msselect * from `cities` where `cities`.`id` in (214, 825, 1102, 1918, 3074, 3535, 3570, 3742, 9224, 9260)

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#73aviatickets1msselect * from `cities` where `cities`.`id` in (178)

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

select * from `sites_relationships` where `sites_relationships`.`id` in (13390, 15519, 49913, 64565, 94119, 100354, 187318, 188356, 196481, 415682)

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#558aviatickets1.07ms

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

Bindings	0: 5420 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.69ms

select * from `flights_by` where `origin_city_id` in (214, 9224, 3074, 825, 3535, 3570, 9260, 1102, 1918, 3742) and `destination_city_id` = 178 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 214 1: 9224 2: 3074 3: 825 4: 3535 5: 3570 6: 9260 7: 1102 8: 1918 9: 3742 10: 178 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.05msselect * from `cities` where `cities`.`id` in (214, 825, 1102, 1918, 3074, 3535, 3570, 3742, 9224, 9260)

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

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

select * from `sites_relationships` where `sites_relationships`.`id` in (13390, 15519, 49913, 64565, 94119, 100354, 187318, 188356, 196481, 415682)

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#104aviatickets910μsselect * from `cities` where `cities`.`id` = 3742 limit 1

Bindings	0: 3742
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#558aviatickets990μs

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

Bindings	0: 5420 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.62ms

select * from `flights_by` where `origin_city_id` in (214, 9224, 3074, 825, 3535, 3570, 9260, 1102, 1918, 3742) and `destination_city_id` = 178 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 214 1: 9224 2: 3074 3: 825 4: 3535 5: 3570 6: 9260 7: 1102 8: 1918 9: 3742 10: 178 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.03msselect * from `cities` where `cities`.`id` in (214, 825, 1102, 1918, 3074, 3535, 3570, 3742, 9224, 9260)

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.39msselect * from `cities` where `cities`.`id` in (178)

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

select * from `sites_relationships` where `sites_relationships`.`id` in (13390, 15519, 49913, 64565, 94119, 100354, 187318, 188356, 196481, 415682)

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

Bindings	0: 1102
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.2ms

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

Bindings	0: 5420 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 (214, 9224, 3074, 825, 3535, 3570, 9260, 1102, 1918, 3742) and `destination_city_id` = 178 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 214 1: 9224 2: 3074 3: 825 4: 3535 5: 3570 6: 9260 7: 1102 8: 1918 9: 3742 10: 178 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.1msselect * from `cities` where `cities`.`id` in (214, 825, 1102, 1918, 3074, 3535, 3570, 3742, 9224, 9260)

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#73aviatickets1msselect * from `cities` where `cities`.`id` in (178)

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

select * from `sites_relationships` where `sites_relationships`.`id` in (13390, 15519, 49913, 64565, 94119, 100354, 187318, 188356, 196481, 415682)

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

Bindings	0: 9260
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.21ms

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

Bindings	0: 5420 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.18ms

select * from `flights_by` where `origin_city_id` in (214, 9224, 3074, 825, 3535, 3570, 9260, 1102, 1918, 3742) and `destination_city_id` = 178 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 214 1: 9224 2: 3074 3: 825 4: 3535 5: 3570 6: 9260 7: 1102 8: 1918 9: 3742 10: 178 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.2msselect * from `cities` where `cities`.`id` in (214, 825, 1102, 1918, 3074, 3535, 3570, 3742, 9224, 9260)

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

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

select * from `sites_relationships` where `sites_relationships`.`id` in (13390, 15519, 49913, 64565, 94119, 100354, 187318, 188356, 196481, 415682)

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

Bindings	0: 1102
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#52aviatickets860μsselect * from `offers` where `origin_city_id` = 5420 and `destination_city_id` = 178

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

LocalRouteRepository.php#447aviatickets2.97ms

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

Bindings	0: 5420 1: 285751 2: 99 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.1msselect * from `cities` where `cities`.`id` in (5420)

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#447aviatickets1msselect * from `cities` where `cities`.`id` in (182, 208, 612)

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#447aviatickets930μsselect * from `sites_relationships` where `sites_relationships`.`id` in (285752, 285753, 285755)

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#125aviatickets920μsselect * from `countries` where `countries`.`id` = 128 limit 1

Bindings	0: 128
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.16msselect * from `countries` where `countries`.`id` = 111 limit 1

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

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

Bindings	0: 5420 1: 99 2: 0 3: 0 4: 285752
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.26msselect * from `cities` where `cities`.`id` in (5420)

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 (3505, 4081)

Backtrace

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

LocalRouteRepository.php#412aviatickets1.03msselect * from `sites_relationships` where `sites_relationships`.`id` in (285928, 285959)

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

Backtrace

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

LocalRouteRepository.php#149aviatickets1.74ms

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

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

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.3msselect * from `cities` where `cities`.`id` in (2058, 2283, 2686, 3505, 4081)

Backtrace

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

LocalRouteRepository.php#149aviatickets1.49msselect * from `countries` where `countries`.`id` in (105, 134, 207, 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.54msselect * from `sites_relationships` where `sites_relationships`.`id` in (10871, 10886, 10914, 10964, 11008)

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` = 5420 and `destination_country_id` = 99 and (`price_one_way` > 0 or `price` > 0) order by `revenue` desc limit 5 offset 0

Bindings	0: 5420 1: 99 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.07msselect * from `cities` where `cities`.`id` in (5420)

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#359aviatickets960μsselect * from `cities` where `cities`.`id` in (214, 3074)

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.37msselect * from `sites_relationships` where `sites_relationships`.`id` in (285754, 285844)

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#359aviatickets870μsselect * from `countries` where `countries`.`id` in (99)

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

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

Bindings	0: 5420 1: 178
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 (443)

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

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#39aviatickets960μsselect * from `airlines` where `airlines`.`id` in (5017, 65824)

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

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

Bindings	0: 5420 1: 178
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#520aviatickets880μsselect * from `flights_by` where `origin_city_id` = 178 and `destination_city_id` = 5420 limit 1

Bindings	0: 178 1: 5420
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.17msselect * from `sites_relationships` where `sites_relationships`.`id` in (11115)

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

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

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

Bindings	0: 5420
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.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.07msselect * 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.08msselect * 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#175aviatickets1.21msselect * 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.26ms

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.25msselect * 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.61msselect * 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.28msselect * 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#149aviatickets920μs

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: 157Timetable.php#?
App\Avia\Infrastructure\Model\LocalRoute: 129LocalRoute.php#?
App\Avia\Infrastructure\Model\City: 101City.php#?
App\Avia\Infrastructure\Model\SitesRelationship: 80SitesRelationship.php#?
App\Avia\Infrastructure\Model\Airline: 26Airline.php#?
App\Avia\Infrastructure\Model\Country: 19Country.php#?
App\Avia\Infrastructure\Model\Airport: 2Airport.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...
infoModel: App\Avia\Infrastructure\Model\LocalRoute => Relation: destinationCountry - You should add `wi...

_token: V1k774SnI8oUsKggUXQ6l01cI3tACIceBW958e5T
_previous: array:1 [ "url" => "https://d.lowcost.club/cheap-flights-from-rotterdam-to-alicante-rtm-alc?_url=%...
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/cheap-flights-from-rotterdam-to-alicante-rtm-alc

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:1 [▼
  "_url" => "/cheap-flights-from-rotterdam-to-alicante-rtm-alc"
]

request_request

[]

request_headers

  0 of 0   
array:16 [▼
  "cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Im9JZHBYSkJJcktmS29qbTVHUHA1WGc9PSIsInZhbHVlIjoiV3AyTjlaQ2hJRlVHZEpzQ2VVRTBhd1VTWUxTU2ZJVTV5SGxsY0FUVWZKK0FrR0lXR3Z3WmdMbHZvWFFwKzc3N2JnbkhHTHYwTW9nZ01OZDUrWlg3Z0NSbm1tSEpGdmcvSHI3eTltV0VIWXhDamZuZ2FMWVpuc2d5amdkc0dIY2wiLCJtYWMiOiIzZTRhY2NkZjYzYmFhYzdmYTc0NDYzMjNiZWI5NGYyZGQyYjk3NzI4NmY4NDg2MmNiZDk0MWM0YTBjZmEwNTk2IiwidGFnIjoiIn0%3D; lowcostclub_session=eyJpdiI6ImxodmcxVmkxQjc0MkxSUUdBQlFsb1E9PSIsInZhbHVlIjoiYm4wWVBjdmxVcU5OVXVZRURnT3RaTjdtZVllRlc5eXR0SjZ3VU1oak9ieXVTV2k3RzFSWlJMSFFONkhiSTFCMTBwaGhyZGtaek5ycDMxZERYQlNtN3FvcUxtL0p1c0RIOS9lZVBvSDBQUFYrOE92ZVhMcnlhOTZKcEo5b2hiMXEiLCJtYWMiOiIwMWQ4MDkxMjIzNzUzMmZlNzQwMGE0YTMyNDhmMWJlNzVjZDVkMGRjMDA0ZDQ0Zjk3NTk4YWIwNDg2ZDBiNmRmIiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6Im9JZHBYSkJJcktmS29qbTVHUHA1WGc9PSIsInZhbHVlIjoiV3AyTjlaQ2hJRlVHZEpzQ2VVRTBhd1VTWUxTU2ZJVTV5SGxsY0FUVWZKK0FrR0lXR3Z3WmdMbHZvWFFwKzc3N2JnbkhHT ▶"
  ]
  "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" => "V1k774SnI8oUsKggUXQ6l01cI3tACIceBW958e5T"
  "lowcostclub_session" => "JjO4PQRUUKugdXQVvcFuVRlhw3oxaH6DW63dTaZg"
]

response_headers

  0 of 0   
array:6 [▼
  "cache-control" => array:1 [▶
    0 => "max-age=604800, public"
  ]
  "date" => array:1 [▶
    0 => "Tue, 06 May 2025 10:13:15 GMT"
  ]
  "etag" => array:1 [▶
    0 => ""101d3abcacf489dff9938856f7fbd157""
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjkzOCtUWkRoTVFseXlyTGJ1czlucXc9PSIsInZhbHVlIjoiSjB3dnBrdnJYeDZkc21KeDlNbkdNUlA2Z2lPYUNGbC91R05lQXRiZVE5bHFET1kwODBjMDFONEdjbVZYZld2M3ZPblNGbTJIaUUvU2ppWStyenMvY0xyM3ZER3dQU0JPck04Rk5XMEthZWVoK0c1SHozcXNtcC9DN0VIZGduY3EiLCJtYWMiOiJhNTNkMWRhMWJmNmEwMTMwYWIwZGY0YzAyNjYxZTA1YWRiZTVmY2EzMmIzNGFkZjQxOGM4NGU5YWMxYzcyZjUxIiwidGFnIjoiIn0%3D; expires=Tue, 06 May 2025 12:13:15 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IjkzOCtUWkRoTVFseXlyTGJ1czlucXc9PSIsInZhbHVlIjoiSjB3dnBrdnJYeDZkc21KeDlNbkdNUlA2Z2lPYUNGbC91R05lQXRiZVE5bHFET1kwODBjMDFONEdjbVZYZld2M3ZPblNGb ▶"
    1 => "lowcostclub_session=eyJpdiI6InhxeTMyNkdNSitkUlBVSnN4M2p5U0E9PSIsInZhbHVlIjoiVmhYbVR1MDdVOGdCdnY0NTdRNHViSnBNSEIza1NxUG9jMWF0RDRoUlZrSHlVY1drOGViNDl5dll4aml6WGRPYXY5MjdIYmNVQ2pidWMzVjBpaWg5ZDlNcFVJVVpBdllHQXJOSTBoZmVIR1Q3MGJ5WFBwQiswME9Rak9pTzVPWG0iLCJtYWMiOiJjNzY1NWM4MDQxMmNkM2Y4N2I0OTgwYWE1YjBmMWU4Y2VhYjNjMDU1OTA1ZDRkMTBmZDY1NjA5Mzg4MGNmODJhIiwidGFnIjoiIn0%3D; expires=Tue, 06 May 2025 12:13:15 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀lowcostclub_session=eyJpdiI6InhxeTMyNkdNSitkUlBVSnN4M2p5U0E9PSIsInZhbHVlIjoiVmhYbVR1MDdVOGdCdnY0NTdRNHViSnBNSEIza1NxUG9jMWF0RDRoUlZrSHlVY1drOGViNDl5dll4aml6WGRP ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjkzOCtUWkRoTVFseXlyTGJ1czlucXc9PSIsInZhbHVlIjoiSjB3dnBrdnJYeDZkc21KeDlNbkdNUlA2Z2lPYUNGbC91R05lQXRiZVE5bHFET1kwODBjMDFONEdjbVZYZld2M3ZPblNGbTJIaUUvU2ppWStyenMvY0xyM3ZER3dQU0JPck04Rk5XMEthZWVoK0c1SHozcXNtcC9DN0VIZGduY3EiLCJtYWMiOiJhNTNkMWRhMWJmNmEwMTMwYWIwZGY0YzAyNjYxZTA1YWRiZTVmY2EzMmIzNGFkZjQxOGM4NGU5YWMxYzcyZjUxIiwidGFnIjoiIn0%3D; expires=Tue, 06-May-2025 12:13:15 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IjkzOCtUWkRoTVFseXlyTGJ1czlucXc9PSIsInZhbHVlIjoiSjB3dnBrdnJYeDZkc21KeDlNbkdNUlA2Z2lPYUNGbC91R05lQXRiZVE5bHFET1kwODBjMDFONEdjbVZYZld2M3ZPblNGb ▶"
    1 => "lowcostclub_session=eyJpdiI6InhxeTMyNkdNSitkUlBVSnN4M2p5U0E9PSIsInZhbHVlIjoiVmhYbVR1MDdVOGdCdnY0NTdRNHViSnBNSEIza1NxUG9jMWF0RDRoUlZrSHlVY1drOGViNDl5dll4aml6WGRPYXY5MjdIYmNVQ2pidWMzVjBpaWg5ZDlNcFVJVVpBdllHQXJOSTBoZmVIR1Q3MGJ5WFBwQiswME9Rak9pTzVPWG0iLCJtYWMiOiJjNzY1NWM4MDQxMmNkM2Y4N2I0OTgwYWE1YjBmMWU4Y2VhYjNjMDU1OTA1ZDRkMTBmZDY1NjA5Mzg4MGNmODJhIiwidGFnIjoiIn0%3D; expires=Tue, 06-May-2025 12:13:15 GMT; path=/; httponly ◀lowcostclub_session=eyJpdiI6InhxeTMyNkdNSitkUlBVSnN4M2p5U0E9PSIsInZhbHVlIjoiVmhYbVR1MDdVOGdCdnY0NTdRNHViSnBNSEIza1NxUG9jMWF0RDRoUlZrSHlVY1drOGViNDl5dll4aml6WGRP ▶"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "V1k774SnI8oUsKggUXQ6l01cI3tACIceBW958e5T"
  "_previous" => array:1 [▶
    "url" => "https://d.lowcost.club/cheap-flights-from-rotterdam-to-alicante-rtm-alc?_url=%2Fcheap-flights-from-rotterdam-to-alicante-rtm-alc"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-05-06 10:13:15	GET	/cheap-flights-from-rotterdam-to-alicante-rtm-alc	54 86 515 4

1 x Application (94.96%)	456ms
1 x Booting (5.04%)	24.18ms

Cheap flights Rotterdam — Alicante (RTM — ALC)

Choose your dates to find the flight:

Good to know - Cheap tickets Rotterdam — Alicante

Popular airlines flying Rotterdam — Alicante

Airlines with direct flights

Other airlines flying with transfers

Routes from nearby cities to Alicante

Popular International routes from Rotterdam

Popular routes from Alicante

Popular domestic routes from Rotterdam

Related pages

Select your currency

All currencies

Select your language

All languages