Dacia Spring Leasing Deals:

DACIA SPRING

Page 2 of 30 pages

Compare Dacia Spring van leases and contract hire on cars2buy's van leasing and contract hire comparison site to find the best van leasing deals available in the UK from Dacia van dealers and leasing companies. We advertise the cheapest Dacia Spring leases to ensure that you are getting the best deal available. If you are looking to lease a Dacia Spring then you have come to the right place!

Filter your results:

Lease details:

Van details:

Request history8.2.27PHP Version255msRequest Duration2MBMemory UsageGET van-leasing/{manufacturer}/{model}Route
  • warninglog[06:53:42] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[06:53:42] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[06:53:42] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[06:53:42] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • Booting (39.48ms)time
  • Application (216ms)time
  • 1 x Application (84.52%)
    216ms
    1 x Booting (15.47%)
    39.48ms
    14 templates were rendered
    • van-leasing.showshow.blade.php#?blade
    • van-leasing.search-barsearch-bar.blade.php#?blade
    • includes.paginationpagination.blade.php#?blade
    • van-leasing.filters.van-leasing-filtervan-leasing-filter.blade.php#?blade
    • includes.van-filtersvan-filters.blade.php#?blade
    • van-leasing.filters.van-leasing-filtervan-leasing-filter.blade.php#?blade
    • includes.van-filtersvan-filters.blade.php#?blade
    • van-leasing.extraextra.blade.php#?blade
    • appapp.blade.php#?blade
    • share.headhead.blade.php#?blade
    • includes.dfp-codedfp-code.blade.php#?blade
    • share.headerheader.blade.php#?blade
    • share.footerfooter.blade.php#?blade
    • share.footfoot.blade.php#?blade
    uri
    GET van-leasing/{manufacturer}/{model}
    middleware
    web
    controller
    App\Http\Controllers\VanLeasingController@results
    namespace
    where
    as
    van-leasing-results
    file
    app/Http/Controllers/VanLeasingController.php:109-190
    28 statements were executed, 2 of which were duplicates, 26 unique. Show only duplicated9.94ms
    • Connection EstablishedvandirectController.php#304
      Backtrace
      • 14. app/Http/Controllers/Controller.php:304
      • 15. app/Http/Controllers/Controller.php:58
      • 17. vendor/laravel/framework/src/Illuminate/Container/Container.php:952
      • 18. vendor/laravel/framework/src/Illuminate/Container/Container.php:795
      • 19. vendor/laravel/framework/src/Illuminate/Foundation/Application.php:957
    • select `van_id` from `vans` where (`make_slug` = 'dacia' and `model_slug` = 'spring') limit 1
      1.05msvandirectController.php#434
      Bindings
      • 0: dacia
      • 1: spring
      Backtrace
      • 15. app/Http/Controllers/Controller.php:434
      • 16. app/Http/Controllers/Controller.php:58
      • 18. vendor/laravel/framework/src/Illuminate/Container/Container.php:952
      • 19. vendor/laravel/framework/src/Illuminate/Container/Container.php:795
      • 20. vendor/laravel/framework/src/Illuminate/Foundation/Application.php:957
    • select count(*) as aggregate from `lease_offers` inner join `vans` on `vans`.`van_id` = `lease_offers`.`id_car` inner join `dealers` on `dealers`.`did` = `lease_offers`.`bid` where (`make_slug` = 'dacia' and `model_slug` = 'spring' and `live` = 1 and `capid` > 1 and `lease_live` = 1 and `price_monthly` > 0)
      220μsvandirectVanLeasingSearch.php#45
      Bindings
      • 0: dacia
      • 1: spring
      • 2: 1
      • 3: 1
      • 4: 1
      • 5: 0
      Backtrace
      • 16. app/Queries/VanLeasingSearch.php:45
      • 17. app/Http/Controllers/VanLeasingController.php:119
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select `lease_live`, `linked`, `logo`, `derivative`, `derivative_slug`, `capid`, `make`, `make_slug`, `model`, `model_slug`, `model_long`, `model_long_slug`, `bid`, `lease_id`, `type`, `term`, `mileage`, `price_monthly`, `deposit_type`, `deposit`, `vans`.`delivery`, `urllink`, `d_subid`, `name`, `live` from `lease_offers` inner join `vans` on `vans`.`van_id` = `lease_offers`.`id_car` inner join `dealers` on `dealers`.`did` = `lease_offers`.`bid` where (`make_slug` = 'dacia' and `model_slug` = 'spring' and `live` = 1 and `capid` > 1 and `lease_live` = 1 and `price_monthly` > 0) order by price_monthly limit 10 offset 10
      3.44msvandirectVanLeasingSearch.php#45
      Bindings
      • 0: dacia
      • 1: spring
      • 2: 1
      • 3: 1
      • 4: 1
      • 5: 0
      Backtrace
      • 16. app/Queries/VanLeasingSearch.php:45
      • 17. app/Http/Controllers/VanLeasingController.php:119
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • Connection EstablishedbrampacImagesRepository.php#56
      Backtrace
      • 9. app/Queries/ImagesRepository.php:56
      • 10. app/Traits/VehicleImage.php:112
      • 11. app/Http/Controllers/VanLeasingController.php:133
      • 12. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 13. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `path`, `izmoAlias` from `images_izmo` inner join `vandirect`.`vans` on `images_izmo`.`cap_id` = `vandirect`.`vans`.`capid` where `vandirect`.`vans`.`make` = 'DACIA' and `vandirect`.`vans`.`model` = 'SPRING' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'LCV' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
      360μsbrampacImagesRepository.php#66
      Bindings
      • 0: DACIA
      • 1: SPRING
      • 2: 
      • 3: 
      • 4: LCV
      Backtrace
      • 14. app/Queries/ImagesRepository.php:66
      • 15. app/Traits/VehicleImage.php:112
      • 16. app/Http/Controllers/VanLeasingController.php:133
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `model_cap` from `vandirect`.`vans` where `model` = 'SPRING' limit 1
      140μsbrampacImagesRepository.php#76
      Bindings
      • 0: SPRING
      Backtrace
      • 14. app/Queries/ImagesRepository.php:76
      • 17. app/Queries/ImagesRepository.php:72
      • 18. app/Traits/VehicleImage.php:112
      • 19. app/Http/Controllers/VanLeasingController.php:133
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `images_izmo` inner join `vandirect`.`vans` on `images_izmo`.`cap_id` = `vandirect`.`vans`.`capid` where `vandirect`.`vans`.`make` = 'DACIA' and `vandirect`.`vans`.`model_cap` = (select `model_cap` from `vandirect`.`vans` where `model` = 'SPRING' limit 1) and `path` != '' and `izmoAlias` != '' and `ima_type` = 'LCV' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
      310μsbrampacImagesRepository.php#83
      Bindings
      • 0: DACIA
      • 1: SPRING
      • 2: 
      • 3: 
      • 4: LCV
      Backtrace
      • 14. app/Queries/ImagesRepository.php:83
      • 15. app/Traits/VehicleImage.php:112
      • 16. app/Http/Controllers/VanLeasingController.php:133
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `path`, `izmoAlias` from `images_backfill` where `ima_make` = 'DACIA' and `ima_model` = 'SPRING' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'LCV' limit 1
      160μsbrampacImagesRepository.php#97
      Bindings
      • 0: DACIA
      • 1: SPRING
      • 2: 
      • 3: 
      • 4: LCV
      Backtrace
      • 16. app/Queries/ImagesRepository.php:97
      • 17. app/Traits/VehicleImage.php:121
      • 18. app/Http/Controllers/VanLeasingController.php:133
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `model_cap` from `vandirect`.`vans` where `model` = 'SPRING' limit 1
      120μsbrampacImagesRepository.php#106
      Bindings
      • 0: SPRING
      Backtrace
      • 14. app/Queries/ImagesRepository.php:106
      • 18. app/Queries/ImagesRepository.php:102
      • 19. app/Traits/VehicleImage.php:121
      • 20. app/Http/Controllers/VanLeasingController.php:133
      • 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select `path`, `izmoAlias` from `images_backfill` where `ima_make` = 'DACIA' and `ima_model` = (select `model_cap` from `vandirect`.`vans` where `model` = 'SPRING' limit 1) and `path` != '' and `izmoAlias` != '' and `ima_type` = 'LCV' limit 1
      170μsbrampacImagesRepository.php#111
      Bindings
      • 0: DACIA
      • 1: SPRING
      • 2: 
      • 3: 
      • 4: LCV
      Backtrace
      • 16. app/Queries/ImagesRepository.php:111
      • 17. app/Traits/VehicleImage.php:121
      • 18. app/Http/Controllers/VanLeasingController.php:133
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `ipuser` from `lease_clicks` where (`make` = 'DACIA' and `model` = 'SPRING' and `stamp` <= '2025-02-03' and `stamp` >= '2025-01-24' and `ipuser` != '' and `make_rule` = 0 and `robot_rule` = 0) group by `ipuser`
      180μsvandirectVanLeaseClickRepository.php#105
      Bindings
      • 0: DACIA
      • 1: SPRING
      • 2: 2025-02-03
      • 3: 2025-01-24
      • 4: 
      • 5: 0
      • 6: 0
      Backtrace
      • 15. app/Queries/VanLeaseClickRepository.php:105
      • 16. app/Queries/VanLeaseClickRepository.php:53
      • 17. app/Http/Controllers/VanLeasingController.php:136
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select COUNT(click_id) AS count, make, model from `lease_clicks` where 0 = 1 and (`make` != 'DACIA' and `model` != 'SPRING' and `stamp` < '2025-02-03' and `stamp` >= '2025-01-24' and `make_rule` = 0 and `robot_rule` = 0) group by `model`, `make` order by `count` desc limit 5
      180μsvandirectVanLeaseClickRepository.php#77
      Bindings
      • 0: DACIA
      • 1: SPRING
      • 2: 2025-02-03
      • 3: 2025-01-24
      • 4: 0
      • 5: 0
      Backtrace
      • 15. app/Queries/VanLeaseClickRepository.php:77
      • 16. app/Http/Controllers/VanLeasingController.php:136
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select distinct `make`, `model`, `model_long`, `model_long_slug`, `derivative`, `van_id`, `derivative_slug` from `vans` where (`make_slug` = 'dacia' and `model_slug` = 'spring' and `model_long` = '') order by `derivative` asc
      160μsvandirectVanModel.php#163
      Bindings
      • 0: dacia
      • 1: spring
      • 2: 
      Backtrace
      • 15. app/Queries/VanModel.php:163
      • 16. app/Http/Controllers/VanLeasingController.php:148
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select COUNT(DISTINCT bid) as totalBrokers from `lease_offers` inner join `vans` on `vans`.`van_id` = `lease_offers`.`id_car` inner join `dealers` on `dealers`.`did` = `lease_offers`.`bid` where (`live` = 1 and `capid` > 1 and `lease_live` = 1 and `price_monthly` > 0) and (`make_slug` = 'dacia' and `model_slug` = 'spring') limit 1
      200μsvandirectVanLeasingSearch.php#234
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: 0
      • 4: dacia
      • 5: spring
      Backtrace
      • 16. app/Queries/VanLeasingSearch.php:234
      • 17. app/Http/Controllers/VanLeasingController.php:151
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select distinct `make`, `make_slug` from `vans` order by `make` asc
      130μsvandirectVanManufacturer.php#16
      Backtrace
      • 15. app/Queries/VanManufacturer.php:16
      • 16. app/Http/Controllers/VanLeasingController.php:168
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select distinct `model`, `model_slug`, `make` from `vans` where `make_slug` = 'dacia' order by `model` asc
      130μsvandirectVanModel.php#26
      Bindings
      • 0: dacia
      Backtrace
      • 15. app/Queries/VanModel.php:26
      • 16. app/Http/Controllers/VanLeasingController.php:169
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select `lease_live`, `linked`, `logo`, `derivative`, `derivative_slug`, `capid`, `make`, `make_slug`, `model`, `model_slug`, `model_long`, `model_long_slug`, `bid`, `lease_id`, `type`, `term`, `mileage`, `price_monthly`, `deposit_type`, `deposit`, `vans`.`delivery`, `urllink`, `d_subid`, `name`, `live` from `lease_offers` inner join `vans` on `vans`.`van_id` = `lease_offers`.`id_car` inner join `dealers` on `dealers`.`did` = `lease_offers`.`bid` where (`make_slug` = 'dacia' and `model_slug` = 'spring' and `did` = 160 and `live` = 1 and `capid` > 1 and `lease_live` = 1 and `price_monthly` > 0) order by `price_monthly` asc limit 1
      270μsvandirectVanLeasingSearch.php#102
      Bindings
      • 0: dacia
      • 1: spring
      • 2: 160
      • 3: 1
      • 4: 1
      • 5: 1
      • 6: 0
      Backtrace
      • 15. app/Queries/VanLeasingSearch.php:102
      • 16. app/Http/Controllers/VanLeasingController.php:177
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select `make`, `make_slug`, `model`, `model_slug`, MIN(otrprice/(basic+vans.delivery)) as discount from `cus_cars` inner join `vans` on `vans`.`van_id` = `cus_cars`.`id_car` inner join `dealers` on `dealers`.`did` = `cus_cars`.`bid` inner join `account` on `account`.`broke_id` = `dealers`.`did` where (`make_slug` = 'dacia' and `model_slug` = 'spring' and `d_live` = 1 and `live` = 1 and `otrprice` > 4000 and `amount` > 0) order by `otrprice` asc limit 1
      250μsvandirectNewVanSearch.php#205
      Bindings
      • 0: dacia
      • 1: spring
      • 2: 1
      • 3: 1
      • 4: 4000
      • 5: 0
      Backtrace
      • 15. app/Queries/NewVanSearch.php:205
      • 16. app/Http/Controllers/VanLeasingController.php:179
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select distinct `van_id`, `derivative`, `model_long` from `lease_offers` inner join `vans` on `vans`.`van_id` = `lease_offers`.`id_car` inner join `dealers` on `dealers`.`did` = `lease_offers`.`bid` where (`make_slug` = 'dacia' and `model_slug` = 'spring' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) order by `derivative` asc
      190μsvandirectVanLeaseFilter.php#69
      Bindings
      • 0: dacia
      • 1: spring
      • 2: 1
      • 3: 1
      • 4: 0
      Backtrace
      • 15. app/Queries/SearchFilters/VanLeaseFilter.php:69
      • 16. app/Queries/SearchFilters/VanLeaseFilter.php:19
      • 17. app/Http/Controllers/VanLeasingController.php:180
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select distinct `fuel` from `lease_offers` inner join `vans` on `vans`.`van_id` = `lease_offers`.`id_car` inner join `dealers` on `dealers`.`did` = `lease_offers`.`bid` where (`make_slug` = 'dacia' and `model_slug` = 'spring' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) order by `fuel` asc
      180μsvandirectVanLeaseFilter.php#99
      Bindings
      • 0: dacia
      • 1: spring
      • 2: 1
      • 3: 1
      • 4: 0
      Backtrace
      • 15. app/Queries/SearchFilters/VanLeaseFilter.php:99
      • 16. app/Queries/SearchFilters/VanLeaseFilter.php:25
      • 17. app/Http/Controllers/VanLeasingController.php:180
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select distinct `transmission` from `lease_offers` inner join `vans` on `vans`.`van_id` = `lease_offers`.`id_car` inner join `dealers` on `dealers`.`did` = `lease_offers`.`bid` where (`make_slug` = 'dacia' and `model_slug` = 'spring' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) order by `transmission` asc
      190μsvandirectVanLeaseFilter.php#114
      Bindings
      • 0: dacia
      • 1: spring
      • 2: 1
      • 3: 1
      • 4: 0
      Backtrace
      • 15. app/Queries/SearchFilters/VanLeaseFilter.php:114
      • 16. app/Queries/SearchFilters/VanLeaseFilter.php:29
      • 17. app/Http/Controllers/VanLeasingController.php:180
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select distinct `model_long`, `model_long_slug` from `lease_offers` inner join `vans` on `vans`.`van_id` = `lease_offers`.`id_car` inner join `dealers` on `dealers`.`did` = `lease_offers`.`bid` where (`make_slug` = 'dacia' and `model_slug` = 'spring' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) order by `model_long` asc
      200μsvandirectVanLeaseFilter.php#123
      Bindings
      • 0: dacia
      • 1: spring
      • 2: 1
      • 3: 1
      • 4: 0
      Backtrace
      • 15. app/Queries/SearchFilters/VanLeaseFilter.php:123
      • 16. app/Queries/SearchFilters/VanLeaseFilter.php:33
      • 17. app/Http/Controllers/VanLeasingController.php:180
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select distinct `term` from `lease_offers` inner join `vans` on `vans`.`van_id` = `lease_offers`.`id_car` inner join `dealers` on `dealers`.`did` = `lease_offers`.`bid` where (`make_slug` = 'dacia' and `model_slug` = 'spring' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `term` in (6, 12, 18, 24, 36, 48, 60) order by `term` asc
      210μsvandirectVanLeaseFilter.php#138
      Bindings
      • 0: dacia
      • 1: spring
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: 6
      • 6: 12
      • 7: 18
      • 8: 24
      • 9: 36
      • 10: 48
      • 11: 60
      Backtrace
      • 15. app/Queries/SearchFilters/VanLeaseFilter.php:138
      • 16. app/Queries/SearchFilters/VanLeaseFilter.php:37
      • 17. app/Http/Controllers/VanLeasingController.php:180
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select distinct `mileage` from `lease_offers` inner join `vans` on `vans`.`van_id` = `lease_offers`.`id_car` inner join `dealers` on `dealers`.`did` = `lease_offers`.`bid` where (`make_slug` = 'dacia' and `model_slug` = 'spring' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `term` in (6, 12, 18, 24, 36, 48, 60) and `mileage` in (5000, 6000, 8000, 10000, 12000, 15000, 20000, 25000, 30000, 35000, 40000) order by `mileage` asc
      240μsvandirectVanLeaseFilter.php#153
      Bindings
      • 0: dacia
      • 1: spring
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: 6
      • 6: 12
      • 7: 18
      • 8: 24
      • 9: 36
      • 10: 48
      • 11: 60
      • 12: 5000
      • 13: 6000
      • 14: 8000
      • 15: 10000
      • 16: 12000
      • 17: 15000
      • 18: 20000
      • 19: 25000
      • 20: 30000
      • 21: 35000
      • 22: 40000
      Backtrace
      • 15. app/Queries/SearchFilters/VanLeaseFilter.php:153
      • 16. app/Queries/SearchFilters/VanLeaseFilter.php:41
      • 17. app/Http/Controllers/VanLeasingController.php:180
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select distinct `mileage`, MAX(price_monthly) as max_price, MIN(price_monthly) as min_price from `lease_offers` inner join `vans` on `vans`.`van_id` = `lease_offers`.`id_car` inner join `dealers` on `dealers`.`did` = `lease_offers`.`bid` where (`make_slug` = 'dacia' and `model_slug` = 'spring' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `term` in (6, 12, 18, 24, 36, 48, 60) and `mileage` in (5000, 6000, 8000, 10000, 12000, 15000, 20000, 25000, 30000, 35000, 40000) order by `mileage` asc
      260μsvandirectVanLeaseFilter.php#169
      Bindings
      • 0: dacia
      • 1: spring
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: 6
      • 6: 12
      • 7: 18
      • 8: 24
      • 9: 36
      • 10: 48
      • 11: 60
      • 12: 5000
      • 13: 6000
      • 14: 8000
      • 15: 10000
      • 16: 12000
      • 17: 15000
      • 18: 20000
      • 19: 25000
      • 20: 30000
      • 21: 35000
      • 22: 40000
      Backtrace
      • 15. app/Queries/SearchFilters/VanLeaseFilter.php:169
      • 16. app/Queries/SearchFilters/VanLeaseFilter.php:45
      • 17. app/Http/Controllers/VanLeasingController.php:180
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select distinct `mileage`, MAX(price_monthly) as max_price, MIN(price_monthly) as min_price, MAX(price_monthly) as max_price, MIN(price_monthly) as min_price from `lease_offers` inner join `vans` on `vans`.`van_id` = `lease_offers`.`id_car` inner join `dealers` on `dealers`.`did` = `lease_offers`.`bid` where (`make_slug` = 'dacia' and `model_slug` = 'spring' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `term` in (6, 12, 18, 24, 36, 48, 60) and `mileage` in (5000, 6000, 8000, 10000, 12000, 15000, 20000, 25000, 30000, 35000, 40000) order by `mileage` asc
      270μsvandirectVanLeaseFilter.php#193
      Bindings
      • 0: dacia
      • 1: spring
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: 6
      • 6: 12
      • 7: 18
      • 8: 24
      • 9: 36
      • 10: 48
      • 11: 60
      • 12: 5000
      • 13: 6000
      • 14: 8000
      • 15: 10000
      • 16: 12000
      • 17: 15000
      • 18: 20000
      • 19: 25000
      • 20: 30000
      • 21: 35000
      • 22: 40000
      Backtrace
      • 15. app/Queries/SearchFilters/VanLeaseFilter.php:193
      • 16. app/Queries/SearchFilters/VanLeaseFilter.php:49
      • 17. app/Http/Controllers/VanLeasingController.php:180
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select distinct `make`, `model`, `model_long`, `model_long_slug`, `make_slug`, `model_slug`, `derivative` from `vans` where (`make_slug` = 'dacia' and `model_slug` = 'spring') group by `make`, `model`, `model_long`, `model_long_slug`, `make_slug`, `model_slug` order by `model_long` asc
      180μsvandirectVanModel.php#131
      Bindings
      • 0: dacia
      • 1: spring
      Backtrace
      • 15. app/Queries/VanModel.php:131
      • 16. app/Http/Controllers/VanLeasingController.php:183
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select `make`, `make_slug`, `model`, `model_slug`, `model_long`, `model_long_slug`, `derivative`, `derivative_slug`, `basic`, `capid`, `veh_id`, `urllink`, `logo`, `linked`, `bid`, `d_subid`, `otrprice`, `dealers`.`acc_type`, `cpclick`, `vans`.`delivery`, `motr` from `cus_cars` inner join `vans` on `vans`.`van_id` = `cus_cars`.`id_car` inner join `dealers` on `dealers`.`did` = `cus_cars`.`bid` inner join `account` on `account`.`broke_id` = `dealers`.`did` where (`make_slug` = 'dacia' and `model_slug` = 'spring' and `d_live` = 1 and `live` = 1 and `otrprice` > 4000 and `amount` > 0 and `capid` > 1) order by `otrprice` asc limit 2
      280μsvandirectNewVanSearch.php#276
      Bindings
      • 0: dacia
      • 1: spring
      • 2: 1
      • 3: 1
      • 4: 4000
      • 5: 0
      • 6: 1
      Backtrace
      • 15. app/Queries/NewVanSearch.php:276
      • 16. app/Queries/NewVanSearch.php:237
      • 17. app/Http/Controllers/VanLeasingController.php:187
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `make`, `make_slug`, `model`, `model_slug`, `model_long`, `derivative`, `basic`, `capid`, `veh_id`, `urllink`, `logo`, `linked`, `bid`, `d_subid`, `otrprice`, `dealers`.`acc_type`, `cpclick`, `vans`.`delivery` from `cus_cars` inner join `vans` on `vans`.`van_id` = `cus_cars`.`id_car` inner join `dealers` on `dealers`.`did` = `cus_cars`.`bid` inner join `account` on `account`.`broke_id` = `dealers`.`did` where (`make_slug` = 'dacia' and `model_slug` = 'spring' and `d_live` = 1 and `live` = 1 and `otrprice` > 4000 and `amount` > 0 and `capid` > 1) order by `otrprice` asc limit 2
      270μsvandirectNewVanSearch.php#241
      Bindings
      • 0: dacia
      • 1: spring
      • 2: 1
      • 3: 1
      • 4: 4000
      • 5: 0
      • 6: 1
      Backtrace
      • 15. app/Queries/NewVanSearch.php:241
      • 16. app/Http/Controllers/VanLeasingController.php:187
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    App\Models\VanLeaseOffer
    30VanLeaseOffer.php#?
    App\Models\Van
    25Van.php#?
    App\Models\VanCusCar
    1VanCusCar.php#?
        _token
        vYwashi5XJTNGXmDJrczGBFSXq8zJbEwqFvVGLGg
        views
        1
        uid
        db3bf10e1a31f76cb30e8a1d22dd4968
        _previous
        array:1 [ "url" => "https://laravel.cars2buy.co.uk/van-leasing/dacia/spring?page=2" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /van-leasing/dacia/spring/
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        0 of 0
        array:1 [ "page" => "2" ]
        request_request
        []
        
        request_headers
        0 of 0
        array:18 [ "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 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "close" ] "x-accel-internal" => array:1 [ 0 => "/internal-nginx-static-location" ] "x-real-ip" => array:1 [ 0 => "18.224.212.84" ] "host" => array:1 [ 0 => "laravel.cars2buy.co.uk" ] ]
        request_cookies
        []
        
        response_headers
        0 of 0
        array:7 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "private, must-revalidate" ] "date" => array:1 [ 0 => "Mon, 03 Feb 2025 06:53:42 GMT" ] "pragma" => array:1 [ 0 => "no-cache" ] "expires" => array:1 [ 0 => "-1" ] "set-cookie" => array:3 [ 0 => "uid=eyJpdiI6Ii9mbVd4a1RTUUg4QzEyNFpPU3pGL1E9PSIsInZhbHVlIjoiU0RxWmlucG1LbFFLUkErYlBsK0ZNZ05EM3AvRUVqWGlLa2VwQnRwSDlXYngrUUd6a2NCTTNkQ3JoaGEvYUlzcEkxSVVmUFdwK2lBSzFLaVZNcWMvRkhQYlhueElmWExsNmxiWTl5YWExT289IiwibWFjIjoiZWNjZWQzODQyYTY2OTcwNTE3NDMwZGY1NWE2MWZmMmQwZmNiODE0N2QwMjQ4MTQ0MjMzNzY5Njk1ZjU3OWRjMCIsInRhZyI6IiJ9; expires=Fri, 28 Mar 5360 12:35:42 GMT; Max-Age=105247057320; path=/; secure; httponly; samesite=laxuid=eyJpdiI6Ii9mbVd4a1RTUUg4QzEyNFpPU3pGL1E9PSIsInZhbHVlIjoiU0RxWmlucG1LbFFLUkErYlBsK0ZNZ05EM3AvRUVqWGlLa2VwQnRwSDlXYngrUUd6a2NCTTNkQ3JoaGEvYUlzcEkxSVVmUFdwK2lB" 1 => "XSRF-TOKEN=eyJpdiI6InpkQUdUUkN0Q2wxNFMvU2NuWWxmU0E9PSIsInZhbHVlIjoiVm10WTc3MUNsejZ5WXowdGNUUEp3Q0MxcU9sSkNpOUJkZjlBZ1JpQlp1cXl3YzA2WnhobUlUQTllOUtRZzhPamhvdkdWNzF5NXBmcHdOOG9OMTFMaGtkcjJ5ejI0VER0eFpHMnRHRUkwaG1RN1o3eXFSQURTc1d4V1NFSkVPL00iLCJtYWMiOiJhZjlmODQ2ZDFiOTg2ODZlMGI4ZDBhMmU1ZjBiZmYxOWMxNmZhNWU0Y2ZhY2NjYTQ4ZTJlNzg1YWMzNWUyYWQyIiwidGFnIjoiIn0%3D; expires=Mon, 03 Feb 2025 08:53:42 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6InpkQUdUUkN0Q2wxNFMvU2NuWWxmU0E9PSIsInZhbHVlIjoiVm10WTc3MUNsejZ5WXowdGNUUEp3Q0MxcU9sSkNpOUJkZjlBZ1JpQlp1cXl3YzA2WnhobUlUQTllOUtRZzhPamhvdkdWN" 2 => "laravel_session=eyJpdiI6ImxnYXliVVg3Ti9JdENGbFNvaXAxVWc9PSIsInZhbHVlIjoiU1RaVnpIbkVWS1lSc1F1SkN5YkpibWdHSVEvNmNyZjhkMXZubUNCaE51enRYMDBwQnJuWTB3dGF5QWlNdVB6amRMWDdabzBRTENhZ0xENDQ1NnR0QXZtZ3RsSmJOVW1UWmQwQ1pNYVluU2dGN1VsVGhJK0tKV2dSN3ZtSmtMM0MiLCJtYWMiOiI4ZGI2ZjA4MGY4ZGY4MGNlM2ZlYjE2YjgxYmQ1NDZiMmRhOTIxYmVkNDFiM2YxYjk0MmUyZTM4MWRjMWM0MGNjIiwidGFnIjoiIn0%3D; expires=Mon, 03 Feb 2025 08:53:42 GMT; Max-Age=7200; path=/; httponly; samesite=laxlaravel_session=eyJpdiI6ImxnYXliVVg3Ti9JdENGbFNvaXAxVWc9PSIsInZhbHVlIjoiU1RaVnpIbkVWS1lSc1F1SkN5YkpibWdHSVEvNmNyZjhkMXZubUNCaE51enRYMDBwQnJuWTB3dGF5QWlNdVB6amRM" ] "Set-Cookie" => array:3 [ 0 => "uid=eyJpdiI6Ii9mbVd4a1RTUUg4QzEyNFpPU3pGL1E9PSIsInZhbHVlIjoiU0RxWmlucG1LbFFLUkErYlBsK0ZNZ05EM3AvRUVqWGlLa2VwQnRwSDlXYngrUUd6a2NCTTNkQ3JoaGEvYUlzcEkxSVVmUFdwK2lBSzFLaVZNcWMvRkhQYlhueElmWExsNmxiWTl5YWExT289IiwibWFjIjoiZWNjZWQzODQyYTY2OTcwNTE3NDMwZGY1NWE2MWZmMmQwZmNiODE0N2QwMjQ4MTQ0MjMzNzY5Njk1ZjU3OWRjMCIsInRhZyI6IiJ9; expires=Fri, 28-Mar-5360 12:35:42 GMT; path=/; secure; httponlyuid=eyJpdiI6Ii9mbVd4a1RTUUg4QzEyNFpPU3pGL1E9PSIsInZhbHVlIjoiU0RxWmlucG1LbFFLUkErYlBsK0ZNZ05EM3AvRUVqWGlLa2VwQnRwSDlXYngrUUd6a2NCTTNkQ3JoaGEvYUlzcEkxSVVmUFdwK2lB" 1 => "XSRF-TOKEN=eyJpdiI6InpkQUdUUkN0Q2wxNFMvU2NuWWxmU0E9PSIsInZhbHVlIjoiVm10WTc3MUNsejZ5WXowdGNUUEp3Q0MxcU9sSkNpOUJkZjlBZ1JpQlp1cXl3YzA2WnhobUlUQTllOUtRZzhPamhvdkdWNzF5NXBmcHdOOG9OMTFMaGtkcjJ5ejI0VER0eFpHMnRHRUkwaG1RN1o3eXFSQURTc1d4V1NFSkVPL00iLCJtYWMiOiJhZjlmODQ2ZDFiOTg2ODZlMGI4ZDBhMmU1ZjBiZmYxOWMxNmZhNWU0Y2ZhY2NjYTQ4ZTJlNzg1YWMzNWUyYWQyIiwidGFnIjoiIn0%3D; expires=Mon, 03-Feb-2025 08:53:42 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6InpkQUdUUkN0Q2wxNFMvU2NuWWxmU0E9PSIsInZhbHVlIjoiVm10WTc3MUNsejZ5WXowdGNUUEp3Q0MxcU9sSkNpOUJkZjlBZ1JpQlp1cXl3YzA2WnhobUlUQTllOUtRZzhPamhvdkdWN" 2 => "laravel_session=eyJpdiI6ImxnYXliVVg3Ti9JdENGbFNvaXAxVWc9PSIsInZhbHVlIjoiU1RaVnpIbkVWS1lSc1F1SkN5YkpibWdHSVEvNmNyZjhkMXZubUNCaE51enRYMDBwQnJuWTB3dGF5QWlNdVB6amRMWDdabzBRTENhZ0xENDQ1NnR0QXZtZ3RsSmJOVW1UWmQwQ1pNYVluU2dGN1VsVGhJK0tKV2dSN3ZtSmtMM0MiLCJtYWMiOiI4ZGI2ZjA4MGY4ZGY4MGNlM2ZlYjE2YjgxYmQ1NDZiMmRhOTIxYmVkNDFiM2YxYjk0MmUyZTM4MWRjMWM0MGNjIiwidGFnIjoiIn0%3D; expires=Mon, 03-Feb-2025 08:53:42 GMT; path=/; httponlylaravel_session=eyJpdiI6ImxnYXliVVg3Ti9JdENGbFNvaXAxVWc9PSIsInZhbHVlIjoiU1RaVnpIbkVWS1lSc1F1SkN5YkpibWdHSVEvNmNyZjhkMXZubUNCaE51enRYMDBwQnJuWTB3dGF5QWlNdVB6amRM" ] ]
        session_attributes
        0 of 0
        array:6 [ "_token" => "vYwashi5XJTNGXmDJrczGBFSXq8zJbEwqFvVGLGg" "views" => 1 "uid" => "db3bf10e1a31f76cb30e8a1d22dd4968" "_previous" => array:1 [ "url" => "https://laravel.cars2buy.co.uk/van-leasing/dacia/spring?page=2" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-03 06:53:42GET/van-leasing/dacia/spring/?page=24142856