Mercedes-Benz Sprinter 215cdi L1 Diesel FWD 3.0t H1 Pure Van 9g-Tronic Leasing Deals:

MERCEDES-BENZ SPRINTER L1

Page 1 of 25 pages

Prev Next

New Van Offers:

Compare Mercedes-Benz Sprinter 215cdi L1 Diesel FWD 3.0t H1 Pure Van 9g-Tronic 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 Mercedes-Benz van dealers and leasing companies. We advertise the cheapest Mercedes-Benz Sprinter 215cdi L1 Diesel FWD 3.0t H1 Pure Van 9g-Tronic leases to ensure that you are getting the best deal available. If you are looking to lease a Mercedes-Benz Sprinter 215cdi L1 Diesel FWD 3.0t H1 Pure Van 9g-Tronic then you have come to the right place!

Filter your results:

Lease details:

Van details:

Request history8.2.27PHP Version300msRequest Duration2MBMemory UsageGET van-leasing/{manufacturer}/{model}/{derivative}Route
  • warninglog[11:39:30] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[11:39:30] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[11:39:30] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[11:39:30] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[11:39:30] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[11:39:30] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[11:39:30] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[11:39:30] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[11:39:30] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[11:39:30] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[11:39:30] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[11:39:30] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[11:39:30] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[11:39:30] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[11:39:30] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[11:39:30] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[11:39:30] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[11:39:30] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • Booting (37.56ms)time
  • Application (262ms)time
  • 1 x Application (87.46%)
    262ms
    1 x Booting (12.53%)
    37.56ms
    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}/{derivative}
    middleware
    web
    controller
    App\Http\Controllers\VanLeasingController@results
    namespace
    where
    as
    van-leasing-results-derivative
    file
    app/Http/Controllers/VanLeasingController.php:109-190
    23 statements were executed96ms
    • 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` = 'mercedes-benz' and `model_slug` = 'sprinter-l1' and `van_id` = '46732') and CONCAT_WS('-',model_long_slug,derivative_slug)='sprinter-215cdi-l1-diesel-fwd-3.0t-h1-pure-van-9g-tronic' limit 1
      1.19msvandirectController.php#346
      Bindings
      • 0: mercedes-benz
      • 1: sprinter-l1
      • 2: 46732
      Backtrace
      • 15. app/Http/Controllers/Controller.php:346
      • 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` = 'mercedes-benz' and `model_slug` = 'sprinter-l1' and `live` = 1 and `capid` > 1 and `lease_live` = 1 and `price_monthly` > 0) and `van_id` = '46732'
      6.55msvandirectVanLeasingSearch.php#45
      Bindings
      • 0: mercedes-benz
      • 1: sprinter-l1
      • 2: 1
      • 3: 1
      • 4: 1
      • 5: 0
      • 6: 46732
      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` = 'mercedes-benz' and `model_slug` = 'sprinter-l1' and `live` = 1 and `capid` > 1 and `lease_live` = 1 and `price_monthly` > 0) and `van_id` = '46732' order by price_monthly limit 10 offset 0
      7.31msvandirectVanLeasingSearch.php#45
      Bindings
      • 0: mercedes-benz
      • 1: sprinter-l1
      • 2: 1
      • 3: 1
      • 4: 1
      • 5: 0
      • 6: 46732
      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` = 'MERCEDES-BENZ' and `vandirect`.`vans`.`model` = 'SPRINTER L1' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'LCV' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
      1.22msbrampacImagesRepository.php#66
      Bindings
      • 0: MERCEDES-BENZ
      • 1: SPRINTER L1
      • 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 `ipuser` from `lease_clicks` where (`make` = 'MERCEDES-BENZ' and `model` = 'SPRINTER L1' and `stamp` <= '2025-01-19' and `stamp` >= '2025-01-09' and `ipuser` != '' and `make_rule` = 0 and `robot_rule` = 0) group by `ipuser`
      19.87msvandirectVanLeaseClickRepository.php#105
      Bindings
      • 0: MERCEDES-BENZ
      • 1: SPRINTER L1
      • 2: 2025-01-19
      • 3: 2025-01-09
      • 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 `ipuser` in ('5bbb7b4947354f6efb946e00dc5b3a68', '64087482dcc9e67a670194b6164081a2', '7cf143033689e7422cfa7641839eaa07', 'c2df16c0d288417d9c3e901a7df84e96', 'e286853ad6d80142941957ad6f65afdd') and (`make` != 'MERCEDES-BENZ' and `model` != 'SPRINTER L1' and `stamp` < '2025-01-19' and `stamp` >= '2025-01-09' and `make_rule` = 0 and `robot_rule` = 0) group by `model`, `make` order by `count` desc limit 5
      20.33msvandirectVanLeaseClickRepository.php#77
      Bindings
      • 0: 5bbb7b4947354f6efb946e00dc5b3a68
      • 1: 64087482dcc9e67a670194b6164081a2
      • 2: 7cf143033689e7422cfa7641839eaa07
      • 3: c2df16c0d288417d9c3e901a7df84e96
      • 4: e286853ad6d80142941957ad6f65afdd
      • 5: MERCEDES-BENZ
      • 6: SPRINTER L1
      • 7: 2025-01-19
      • 8: 2025-01-09
      • 9: 0
      • 10: 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` = 'mercedes-benz' and `model_slug` = 'sprinter-l1' and `model_long` = '') order by `derivative` asc
      530μsvandirectVanModel.php#163
      Bindings
      • 0: mercedes-benz
      • 1: sprinter-l1
      • 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 `id_car` = '46732'
      4.39msvandirectVanLeasingSearch.php#225
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: 0
      • 4: 46732
      Backtrace
      • 15. app/Queries/VanLeasingSearch.php:225
      • 16. app/Http/Controllers/VanLeasingController.php:151
      • 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`, `make_slug` from `vans` order by `make` asc
      160μ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` = 'mercedes-benz' order by `model` asc
      3.27msvandirectVanModel.php#26
      Bindings
      • 0: mercedes-benz
      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` = 'mercedes-benz' and `model_slug` = 'sprinter-l1' and `did` = 160 and `live` = 1 and `capid` > 1 and `lease_live` = 1 and `price_monthly` > 0) and `van_id` = '46732' order by `price_monthly` asc limit 1
      4.25msvandirectVanLeasingSearch.php#102
      Bindings
      • 0: mercedes-benz
      • 1: sprinter-l1
      • 2: 160
      • 3: 1
      • 4: 1
      • 5: 1
      • 6: 0
      • 7: 46732
      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` = 'mercedes-benz' and `model_slug` = 'sprinter-l1' and `d_live` = 1 and `live` = 1 and `otrprice` > 4000 and `amount` > 0) order by `otrprice` asc limit 1
      530μsvandirectNewVanSearch.php#205
      Bindings
      • 0: mercedes-benz
      • 1: sprinter-l1
      • 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` = 'mercedes-benz' and `model_slug` = 'sprinter-l1' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `van_id` = '46732' order by `derivative` asc
      590μsvandirectVanLeaseFilter.php#69
      Bindings
      • 0: mercedes-benz
      • 1: sprinter-l1
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: 46732
      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` = 'mercedes-benz' and `model_slug` = 'sprinter-l1' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `van_id` = '46732' order by `fuel` asc
      550μsvandirectVanLeaseFilter.php#99
      Bindings
      • 0: mercedes-benz
      • 1: sprinter-l1
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: 46732
      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` = 'mercedes-benz' and `model_slug` = 'sprinter-l1' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `van_id` = '46732' order by `transmission` asc
      570μsvandirectVanLeaseFilter.php#114
      Bindings
      • 0: mercedes-benz
      • 1: sprinter-l1
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: 46732
      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` = 'mercedes-benz' and `model_slug` = 'sprinter-l1' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `van_id` = '46732' order by `model_long` asc
      580μsvandirectVanLeaseFilter.php#123
      Bindings
      • 0: mercedes-benz
      • 1: sprinter-l1
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: 46732
      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` = 'mercedes-benz' and `model_slug` = 'sprinter-l1' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `van_id` = '46732' and `term` in (6, 12, 18, 24, 36, 48, 60) order by `term` asc
      5.61msvandirectVanLeaseFilter.php#138
      Bindings
      • 0: mercedes-benz
      • 1: sprinter-l1
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: 46732
      • 6: 6
      • 7: 12
      • 8: 18
      • 9: 24
      • 10: 36
      • 11: 48
      • 12: 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` = 'mercedes-benz' and `model_slug` = 'sprinter-l1' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `van_id` = '46732' 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
      5.63msvandirectVanLeaseFilter.php#153
      Bindings
      • 0: mercedes-benz
      • 1: sprinter-l1
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: 46732
      • 6: 6
      • 7: 12
      • 8: 18
      • 9: 24
      • 10: 36
      • 11: 48
      • 12: 60
      • 13: 5000
      • 14: 6000
      • 15: 8000
      • 16: 10000
      • 17: 12000
      • 18: 15000
      • 19: 20000
      • 20: 25000
      • 21: 30000
      • 22: 35000
      • 23: 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` = 'mercedes-benz' and `model_slug` = 'sprinter-l1' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `van_id` = '46732' 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
      5.51msvandirectVanLeaseFilter.php#169
      Bindings
      • 0: mercedes-benz
      • 1: sprinter-l1
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: 46732
      • 6: 6
      • 7: 12
      • 8: 18
      • 9: 24
      • 10: 36
      • 11: 48
      • 12: 60
      • 13: 5000
      • 14: 6000
      • 15: 8000
      • 16: 10000
      • 17: 12000
      • 18: 15000
      • 19: 20000
      • 20: 25000
      • 21: 30000
      • 22: 35000
      • 23: 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` = 'mercedes-benz' and `model_slug` = 'sprinter-l1' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `van_id` = '46732' 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
      5.55msvandirectVanLeaseFilter.php#193
      Bindings
      • 0: mercedes-benz
      • 1: sprinter-l1
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: 46732
      • 6: 6
      • 7: 12
      • 8: 18
      • 9: 24
      • 10: 36
      • 11: 48
      • 12: 60
      • 13: 5000
      • 14: 6000
      • 15: 8000
      • 16: 10000
      • 17: 12000
      • 18: 15000
      • 19: 20000
      • 20: 25000
      • 21: 30000
      • 22: 35000
      • 23: 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` = 'mercedes-benz' and `model_slug` = 'sprinter-l1') group by `make`, `model`, `model_long`, `model_long_slug`, `make_slug`, `model_slug` order by `model_long` asc
      570μsvandirectVanModel.php#131
      Bindings
      • 0: mercedes-benz
      • 1: sprinter-l1
      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` = 'mercedes-benz' and `model_slug` = 'sprinter-l1' and `d_live` = 1 and `live` = 1 and `otrprice` > 4000 and `amount` > 0 and `capid` > 1) and `van_id` = '46732' order by `otrprice` asc limit 2
      590μsvandirectNewVanSearch.php#276
      Bindings
      • 0: mercedes-benz
      • 1: sprinter-l1
      • 2: 1
      • 3: 1
      • 4: 4000
      • 5: 0
      • 6: 1
      • 7: 46732
      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` = 'mercedes-benz' and `model_slug` = 'sprinter-l1' and `d_live` = 1 and `live` = 1 and `otrprice` > 4000 and `amount` > 0 and `capid` > 1) order by `otrprice` asc limit 2
      650μsvandirectNewVanSearch.php#241
      Bindings
      • 0: mercedes-benz
      • 1: sprinter-l1
      • 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\Van
    48Van.php#?
    App\Models\VanLeaseOffer
    29VanLeaseOffer.php#?
    App\Models\VanLeaseClick
    5VanLeaseClick.php#?
    App\Models\VanCusCar
    1VanCusCar.php#?
        _token
        OXy9crvP67Qktn1L77UMRvoJxQVFkTMSKEmyEzTa
        views
        3
        uid
        28352e70fe2fbae14f3eb28a199f40bb
        last_results_page
        /business-car-leasing/mini/countryman/150kw-e-exclusive-level-2-66kwh-5dr-auto_85736?fCarID=85736&pa...
        _previous
        array:1 [ "url" => "https://laravel.cars2buy.co.uk/van-leasing/mercedes-benz/sprinter-l1/sprinter-...
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /van-leasing/mercedes-benz/sprinter-l1/sprinter-215cdi-l1-diesel-fwd-3.0t-h1-pure-van-9g-tronic_46732
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        0 of 0
        array:3 [ "fDerivative" => "Sprinter 215cdi L1 Diesel Fwd 3.0t H1 Pure Van 9g Tronic" "page" => "4fCarID=46732" "fCarID" => "46732" ]
        request_request
        []
        
        request_headers
        0 of 0
        array:19 [ "cookie" => array:1 [ 0 => "_ga=GA1.1.2001152217.1737286763; _gcl_au=1.1.1701972271.1737286763; _ga_N9GLTHNRLQ=GS1.1.1737286761.1.0.1737286764.57.0.0; uid=eyJpdiI6IlpvcFV5K3ZLS1JIcWk1akk1bWNnZGc9PSIsInZhbHVlIjoiNWk5SUExR0pBMkhvWG02VnlwN1NjZm04ZlJ6cjdtbWdSd0doU1FwRVVIVFVFV1c4NktaSnFONUpvWStHaWlrbEJLZEhKWGJGUldxL3NMWEQ4eGhJTFAzUm1tZ3p5RWlSNzJPbkFlTktZQTA9IiwibWFjIjoiZjNkNzUyMjRjYzZkZDJmMzEwMjhhNTkxNTAyYzk2YTgwZGYzZjcwYjQ2NTJmNmVhOTAyNzcxYjJhYWNmMGY2ZSIsInRhZyI6IiJ9; XSRF-TOKEN=eyJpdiI6IlNveml2em1yRzdQR1RwaFduQU9JUFE9PSIsInZhbHVlIjoiQ2Zma1JxdDh2bDQ0S1dNZnVSdVh2Sy9kZUV2aGxBRWg0SzNtNlFIdE8ybXJ4WGdSTzNzYjFEaVNlaDIxZWhUWmd4MUZwODVPR0duait6WEZaUFpQN0ljL0dFOTh5S2x6WE1rQ1ZUbkVlbE1LUzhqUTVacldRWUFKYXVBTzhqS28iLCJtYWMiOiJjMWQxMGNkMzBkNTY4NTFkOGQxOTJjYjAyNDBmNDVlZTg3MTNiNzBmOWIzOGY4YTU1ODE0NWNjOTI5ZGJkNjU0IiwidGFnIjoiIn0%3D; laravel_session=eyJpdiI6Ik91by9pVnVwQlhtV0NibVlYQVE2emc9PSIsInZhbHVlIjoicDV4RVBCOGd0WlROM0ZmYjFpRGxDbkFHQld1ZlBNdUlQRHlwb3E3YSt1b3NuOCs0dTJKTlJsSmlvMkkzRnFBK2NselphNDlydXNYUXZ6R3ZCUVlxa2FiemZIOG02OFptOFk4ZXVYWTdiamRMVThtWHQ3T1hWREdSNzd6SEp5ZS8iLCJtYWMiOiJkZDhmMTFmMjJmNjZhODNhNDRiMTNmMDVhNjI0NjEwODg5ZjUwNGU4MzJiMTIwYzkzMmMzZGZiZDU4MGNmYjQ1IiwidGFnIjoiIn0%3D_ga=GA1.1.2001152217.1737286763; _gcl_au=1.1.1701972271.1737286763; _ga_N9GLTHNRLQ=GS1.1.1737286761.1.0.1737286764.57.0.0; uid=eyJpdiI6IlpvcFV5K3ZLS1JIcWk1akk1b" ] "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 => "3.22.240.163" ] "host" => array:1 [ 0 => "laravel.cars2buy.co.uk" ] ]
        request_cookies
        0 of 0
        array:6 [ "_ga" => null "_gcl_au" => null "_ga_N9GLTHNRLQ" => null "uid" => "28352e70fe2fbae14f3eb28a199f40bb" "XSRF-TOKEN" => "OXy9crvP67Qktn1L77UMRvoJxQVFkTMSKEmyEzTa" "laravel_session" => "KQjeO0PLYap3gQpVchVPDWUjkJ6ex4srFesL1QMg" ]
        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 => "Sun, 19 Jan 2025 11:39:30 GMT" ] "pragma" => array:1 [ 0 => "no-cache" ] "expires" => array:1 [ 0 => "-1" ] "set-cookie" => array:3 [ 0 => "uid=eyJpdiI6IlZvNXE2RHpLd3VQR2t2K01sQW1ZTlE9PSIsInZhbHVlIjoicGFyTTF6cUhXaW1WVEYzQmpPZDcvVjIwK2FmMDdTbkI2Tm1DamNPSHFOWGtzUkNUUmZud0Nyb2p4Q3NGVm9yYzdad093aG5DVmhWNmJ1RUJ3aWpHTDQ0SVR5ZDVqMzYwOThUQVNFT1FIYUU9IiwibWFjIjoiNjU1NGYyYWIzNDQwNWE4NDg0NTIxMDk5ZmYzZTY0YmJmYTRmNzMwYjk2YzE4MDZkNjA3ZTQ0MDJlMzc1NDAyNyIsInRhZyI6IiJ9; expires=Fri, 07 Oct 5357 15:09:30 GMT; Max-Age=105170326200; path=/; secure; httponly; samesite=laxuid=eyJpdiI6IlZvNXE2RHpLd3VQR2t2K01sQW1ZTlE9PSIsInZhbHVlIjoicGFyTTF6cUhXaW1WVEYzQmpPZDcvVjIwK2FmMDdTbkI2Tm1DamNPSHFOWGtzUkNUUmZud0Nyb2p4Q3NGVm9yYzdad093aG5DVmhW" 1 => "XSRF-TOKEN=eyJpdiI6InFBV0NPSk55MDV3M1lMTy9PNkNGNWc9PSIsInZhbHVlIjoia1BXZGV1dnhlYml3MDBtd2tlekRaK0IxNXFtWXdwbE5ZcWNvSmxIK2NUTGowNmgxNk81U3prQXBCeXNJaElhM2Q2V05oM3Bzb0lpbzYxUGpBSWNxTlpNdWo0QjBpYkRIcUZoZnBmeThMUTE0UFZXc1BKTmVxSXppZDZrYWRzbEoiLCJtYWMiOiIxMzBjNTQ2ZGYwYzFlNTY0MjUxY2I5MjkzY2U4YzgyMmU5NmE1NDU3MDMwYzlkYzkwNDhiZWU0MDkwYzg4N2RmIiwidGFnIjoiIn0%3D; expires=Sun, 19 Jan 2025 13:39:30 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6InFBV0NPSk55MDV3M1lMTy9PNkNGNWc9PSIsInZhbHVlIjoia1BXZGV1dnhlYml3MDBtd2tlekRaK0IxNXFtWXdwbE5ZcWNvSmxIK2NUTGowNmgxNk81U3prQXBCeXNJaElhM2Q2V05oM" 2 => "laravel_session=eyJpdiI6InR0OEN0TFlEMVhISml3ZWN1RXlCVFE9PSIsInZhbHVlIjoiY2RKU3R3UWJxWnU0dVlObWNVdDd3N0R1YlhSbnpDOUdtakJ2dTZOQkM3MkRHQkVkUXh1Z050dGNVbnZBcWp5V0I3UVNudnVWS05ZdjJpYXY4NzhDWldLenROYU5sdFRtQ1NUcFBYNDd1cllsVjhrYm50NmdJb05WRzJNM25EeFIiLCJtYWMiOiI5ZTkzOTJlYmJmN2MzYzk4YzQzM2I3YWEzNzNiNDVlNmE3YzdiMGM1OGQyZWQzNjJkN2Y3YjA4M2NlMThkMTBmIiwidGFnIjoiIn0%3D; expires=Sun, 19 Jan 2025 13:39:30 GMT; Max-Age=7200; path=/; httponly; samesite=laxlaravel_session=eyJpdiI6InR0OEN0TFlEMVhISml3ZWN1RXlCVFE9PSIsInZhbHVlIjoiY2RKU3R3UWJxWnU0dVlObWNVdDd3N0R1YlhSbnpDOUdtakJ2dTZOQkM3MkRHQkVkUXh1Z050dGNVbnZBcWp5V0I3" ] "Set-Cookie" => array:3 [ 0 => "uid=eyJpdiI6IlZvNXE2RHpLd3VQR2t2K01sQW1ZTlE9PSIsInZhbHVlIjoicGFyTTF6cUhXaW1WVEYzQmpPZDcvVjIwK2FmMDdTbkI2Tm1DamNPSHFOWGtzUkNUUmZud0Nyb2p4Q3NGVm9yYzdad093aG5DVmhWNmJ1RUJ3aWpHTDQ0SVR5ZDVqMzYwOThUQVNFT1FIYUU9IiwibWFjIjoiNjU1NGYyYWIzNDQwNWE4NDg0NTIxMDk5ZmYzZTY0YmJmYTRmNzMwYjk2YzE4MDZkNjA3ZTQ0MDJlMzc1NDAyNyIsInRhZyI6IiJ9; expires=Fri, 07-Oct-5357 15:09:30 GMT; path=/; secure; httponlyuid=eyJpdiI6IlZvNXE2RHpLd3VQR2t2K01sQW1ZTlE9PSIsInZhbHVlIjoicGFyTTF6cUhXaW1WVEYzQmpPZDcvVjIwK2FmMDdTbkI2Tm1DamNPSHFOWGtzUkNUUmZud0Nyb2p4Q3NGVm9yYzdad093aG5DVmhW" 1 => "XSRF-TOKEN=eyJpdiI6InFBV0NPSk55MDV3M1lMTy9PNkNGNWc9PSIsInZhbHVlIjoia1BXZGV1dnhlYml3MDBtd2tlekRaK0IxNXFtWXdwbE5ZcWNvSmxIK2NUTGowNmgxNk81U3prQXBCeXNJaElhM2Q2V05oM3Bzb0lpbzYxUGpBSWNxTlpNdWo0QjBpYkRIcUZoZnBmeThMUTE0UFZXc1BKTmVxSXppZDZrYWRzbEoiLCJtYWMiOiIxMzBjNTQ2ZGYwYzFlNTY0MjUxY2I5MjkzY2U4YzgyMmU5NmE1NDU3MDMwYzlkYzkwNDhiZWU0MDkwYzg4N2RmIiwidGFnIjoiIn0%3D; expires=Sun, 19-Jan-2025 13:39:30 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6InFBV0NPSk55MDV3M1lMTy9PNkNGNWc9PSIsInZhbHVlIjoia1BXZGV1dnhlYml3MDBtd2tlekRaK0IxNXFtWXdwbE5ZcWNvSmxIK2NUTGowNmgxNk81U3prQXBCeXNJaElhM2Q2V05oM" 2 => "laravel_session=eyJpdiI6InR0OEN0TFlEMVhISml3ZWN1RXlCVFE9PSIsInZhbHVlIjoiY2RKU3R3UWJxWnU0dVlObWNVdDd3N0R1YlhSbnpDOUdtakJ2dTZOQkM3MkRHQkVkUXh1Z050dGNVbnZBcWp5V0I3UVNudnVWS05ZdjJpYXY4NzhDWldLenROYU5sdFRtQ1NUcFBYNDd1cllsVjhrYm50NmdJb05WRzJNM25EeFIiLCJtYWMiOiI5ZTkzOTJlYmJmN2MzYzk4YzQzM2I3YWEzNzNiNDVlNmE3YzdiMGM1OGQyZWQzNjJkN2Y3YjA4M2NlMThkMTBmIiwidGFnIjoiIn0%3D; expires=Sun, 19-Jan-2025 13:39:30 GMT; path=/; httponlylaravel_session=eyJpdiI6InR0OEN0TFlEMVhISml3ZWN1RXlCVFE9PSIsInZhbHVlIjoiY2RKU3R3UWJxWnU0dVlObWNVdDd3N0R1YlhSbnpDOUdtakJ2dTZOQkM3MkRHQkVkUXh1Z050dGNVbnZBcWp5V0I3" ] ]
        session_attributes
        0 of 0
        array:7 [ "_token" => "OXy9crvP67Qktn1L77UMRvoJxQVFkTMSKEmyEzTa" "views" => 3 "uid" => "28352e70fe2fbae14f3eb28a199f40bb" "last_results_page" => "/business-car-leasing/mini/countryman/150kw-e-exclusive-level-2-66kwh-5dr-auto_85736?fCarID=85736&page=2page%3D2page%3D2page%3D2page%3D17page%3D16" "_previous" => array:1 [ "url" => "https://laravel.cars2buy.co.uk/van-leasing/mercedes-benz/sprinter-l1/sprinter-215cdi-l1-diesel-fwd-3.0t-h1-pure-van-9g-tronic_46732?fDerivative=Sprinter%20215cdi%20L1%20Diesel%20Fwd%203.0t%20H1%20Pure%20Van%209g%20Tronic&page=4fCarID%3D46732https://laravel.cars2buy.co.uk/van-leasing/mercedes-benz/sprinter-l1/sprinter-215cdi-l1-diesel-fwd-3.0t-h1-pure-van-9g-tronic_46732?fDerivative=Sprinter%20215cd" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-01-19 11:39:30GET/van-leasing/mercedes-benz/sprinter-l1/sprinter-215cdi-l1-diesel-fwd-3.0t-h1-pure-van-9g-tronic_46732?fDerivative=Sprinter+215cdi+L1+Diesel+Fwd+3.0t+H1+Pure+Van+9g+Tronic&page=4fCarID%3D4673218142383