Mercedes-Benz Vito L3 Diesel RWD 114cdi Pro Van 9g-Tronic Leasing Deals:

MERCEDES-BENZ VITO L3

Page 1 of 25 pages

Prev Next

Compare Mercedes-Benz Vito L3 Diesel RWD 114cdi Pro 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 Vito L3 Diesel RWD 114cdi Pro Van 9g-Tronic leases to ensure that you are getting the best deal available. If you are looking to lease a Mercedes-Benz Vito L3 Diesel RWD 114cdi Pro Van 9g-Tronic then you have come to the right place!

Filter your results:

Lease details:

Van details:

Request history8.2.27PHP Version264msRequest Duration2MBMemory UsageGET van-leasing/{manufacturer}/{model}/{derivative}Route
  • warninglog[05:27:18] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[05:27:18] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[05:27:18] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[05:27:18] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • Booting (35.4ms)time
  • Application (229ms)time
  • 1 x Application (86.61%)
    229ms
    1 x Booting (13.39%)
    35.40ms
    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
    26 statements were executed61.82ms
    • 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` = 'vito-l3' and `van_id` = '52469') and CONCAT_WS('-',model_long_slug,derivative_slug)='vito-l3-diesel-rwd-114cdi-pro-van-9g-tronic' limit 1
      1.27msvandirectController.php#346
      Bindings
      • 0: mercedes-benz
      • 1: vito-l3
      • 2: 52469
      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` = 'vito-l3' and `live` = 1 and `capid` > 1 and `lease_live` = 1 and `price_monthly` > 0) and `van_id` = '52469'
      1.62msvandirectVanLeasingSearch.php#45
      Bindings
      • 0: mercedes-benz
      • 1: vito-l3
      • 2: 1
      • 3: 1
      • 4: 1
      • 5: 0
      • 6: 52469
      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` = 'vito-l3' and `live` = 1 and `capid` > 1 and `lease_live` = 1 and `price_monthly` > 0) and `van_id` = '52469' order by price_monthly limit 10 offset 0
      2.19msvandirectVanLeasingSearch.php#45
      Bindings
      • 0: mercedes-benz
      • 1: vito-l3
      • 2: 1
      • 3: 1
      • 4: 1
      • 5: 0
      • 6: 52469
      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` = 'VITO L3' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'LCV' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
      770μsbrampacImagesRepository.php#66
      Bindings
      • 0: MERCEDES-BENZ
      • 1: VITO L3
      • 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 `path`, `izmoAlias` from `images_backfill` where `ima_make` = 'MERCEDES-BENZ' and `ima_model` = 'VITO L3' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'LCV' limit 1
      310μsbrampacImagesRepository.php#97
      Bindings
      • 0: MERCEDES-BENZ
      • 1: VITO L3
      • 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` = 'VITO L3' limit 1
      250μsbrampacImagesRepository.php#106
      Bindings
      • 0: VITO L3
      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` = 'MERCEDES-BENZ' and `ima_model` = (select `model_cap` from `vandirect`.`vans` where `model` = 'VITO L3' limit 1) and `path` != '' and `izmoAlias` != '' and `ima_type` = 'LCV' limit 1
      320μsbrampacImagesRepository.php#111
      Bindings
      • 0: MERCEDES-BENZ
      • 1: VITO L3
      • 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` = 'MERCEDES-BENZ' and `model` = 'VITO L3' and `stamp` <= '2025-01-18' and `stamp` >= '2025-01-08' and `ipuser` != '' and `make_rule` = 0 and `robot_rule` = 0) group by `ipuser`
      19.06msvandirectVanLeaseClickRepository.php#105
      Bindings
      • 0: MERCEDES-BENZ
      • 1: VITO L3
      • 2: 2025-01-18
      • 3: 2025-01-08
      • 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 ('2796529443397bb6336760e94abb6ea3', '3012bd0363c254483f585ccee13ddfaf', '6910f894c8a9e53b037c6217e1c6d2b5', '8f21a4deda764f33125948515a076297', 'a6bcef04e15f35c11408c7ef8d887c38', 'a9c68cdf741d706471df1d3c6a78c0cd', 'cd8d93c1c30713a2d4d4ac2ab8635aa4', 'ce174a6172d7f18aad7231dcec0bb66b', 'd18a331e6497b5d18f1f1bb7c3b909ac', 'ef2c67500f3608a107d517bef182c431') and (`make` != 'MERCEDES-BENZ' and `model` != 'VITO L3' and `stamp` < '2025-01-18' and `stamp` >= '2025-01-08' and `make_rule` = 0 and `robot_rule` = 0) group by `model`, `make` order by `count` desc limit 5
      18.89msvandirectVanLeaseClickRepository.php#77
      Bindings
      • 0: 2796529443397bb6336760e94abb6ea3
      • 1: 3012bd0363c254483f585ccee13ddfaf
      • 2: 6910f894c8a9e53b037c6217e1c6d2b5
      • 3: 8f21a4deda764f33125948515a076297
      • 4: a6bcef04e15f35c11408c7ef8d887c38
      • 5: a9c68cdf741d706471df1d3c6a78c0cd
      • 6: cd8d93c1c30713a2d4d4ac2ab8635aa4
      • 7: ce174a6172d7f18aad7231dcec0bb66b
      • 8: d18a331e6497b5d18f1f1bb7c3b909ac
      • 9: ef2c67500f3608a107d517bef182c431
      • 10: MERCEDES-BENZ
      • 11: VITO L3
      • 12: 2025-01-18
      • 13: 2025-01-08
      • 14: 0
      • 15: 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` = 'vito-l3' and `model_long` = '') order by `derivative` asc
      450μsvandirectVanModel.php#163
      Bindings
      • 0: mercedes-benz
      • 1: vito-l3
      • 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` = '52469'
      1.91msvandirectVanLeasingSearch.php#225
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: 0
      • 4: 52469
      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
      150μ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.05msvandirectVanModel.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` = 'vito-l3' and `did` = 160 and `live` = 1 and `capid` > 1 and `lease_live` = 1 and `price_monthly` > 0) and `van_id` = '52469' order by `price_monthly` asc limit 1
      1.12msvandirectVanLeasingSearch.php#102
      Bindings
      • 0: mercedes-benz
      • 1: vito-l3
      • 2: 160
      • 3: 1
      • 4: 1
      • 5: 1
      • 6: 0
      • 7: 52469
      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` = 'vito-l3' 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: vito-l3
      • 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` = 'vito-l3' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `van_id` = '52469' order by `derivative` asc
      560μsvandirectVanLeaseFilter.php#69
      Bindings
      • 0: mercedes-benz
      • 1: vito-l3
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: 52469
      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` = 'vito-l3' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `van_id` = '52469' order by `fuel` asc
      550μsvandirectVanLeaseFilter.php#99
      Bindings
      • 0: mercedes-benz
      • 1: vito-l3
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: 52469
      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` = 'vito-l3' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `van_id` = '52469' order by `transmission` asc
      570μsvandirectVanLeaseFilter.php#114
      Bindings
      • 0: mercedes-benz
      • 1: vito-l3
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: 52469
      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` = 'vito-l3' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `van_id` = '52469' order by `model_long` asc
      540μsvandirectVanLeaseFilter.php#123
      Bindings
      • 0: mercedes-benz
      • 1: vito-l3
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: 52469
      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` = 'vito-l3' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `van_id` = '52469' and `term` in (6, 12, 18, 24, 36, 48, 60) order by `term` asc
      1.43msvandirectVanLeaseFilter.php#138
      Bindings
      • 0: mercedes-benz
      • 1: vito-l3
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: 52469
      • 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` = 'vito-l3' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `van_id` = '52469' 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
      1.5msvandirectVanLeaseFilter.php#153
      Bindings
      • 0: mercedes-benz
      • 1: vito-l3
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: 52469
      • 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` = 'vito-l3' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `van_id` = '52469' 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
      1.51msvandirectVanLeaseFilter.php#169
      Bindings
      • 0: mercedes-benz
      • 1: vito-l3
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: 52469
      • 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` = 'vito-l3' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `van_id` = '52469' 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
      1.54msvandirectVanLeaseFilter.php#193
      Bindings
      • 0: mercedes-benz
      • 1: vito-l3
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: 52469
      • 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` = 'vito-l3') group by `make`, `model`, `model_long`, `model_long_slug`, `make_slug`, `model_slug` order by `model_long` asc
      560μsvandirectVanModel.php#131
      Bindings
      • 0: mercedes-benz
      • 1: vito-l3
      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` = 'vito-l3' and `d_live` = 1 and `live` = 1 and `otrprice` > 4000 and `amount` > 0 and `capid` > 1) and `van_id` = '52469' order by `otrprice` asc limit 2
      590μsvandirectNewVanSearch.php#276
      Bindings
      • 0: mercedes-benz
      • 1: vito-l3
      • 2: 1
      • 3: 1
      • 4: 4000
      • 5: 0
      • 6: 1
      • 7: 52469
      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` = 'vito-l3' and `d_live` = 1 and `live` = 1 and `otrprice` > 4000 and `amount` > 0 and `capid` > 1) order by `otrprice` asc limit 2
      580μsvandirectNewVanSearch.php#241
      Bindings
      • 0: mercedes-benz
      • 1: vito-l3
      • 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
    41Van.php#?
    App\Models\VanLeaseOffer
    29VanLeaseOffer.php#?
    App\Models\VanLeaseClick
    10VanLeaseClick.php#?
    App\Models\VanCusCar
    1VanCusCar.php#?
        _token
        HM5bio4mNs033sc119Y9vbYOAA5NaPWc54zMX2L4
        views
        2
        uid
        730245c19b77fc18b10660f6b64869ba
        last_results_page
        /personal-car-leasing/ford/mustang-mach-e/premium/?page=73&trimText=Premium
        _previous
        array:1 [ "url" => "https://laravel.cars2buy.co.uk/van-leasing/mercedes-benz/vito-l3/vito-l3-diese...
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /van-leasing/mercedes-benz/vito-l3/vito-l3-diesel-rwd-114cdi-pro-van-9g-tronic_52469
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        0 of 0
        array:2 [ "fDerivative" => "Vito L3 Diesel Rwd 114cdi Pro Van 9g Tronic" "fCarID" => "52469" ]
        request_request
        []
        
        request_headers
        0 of 0
        array:19 [ "cookie" => array:1 [ 0 => "uid=eyJpdiI6InJLQWpDeDREQnNoQzUxT0wxbDBpRlE9PSIsInZhbHVlIjoiN29XaFJ0S2tHc1RnQjByU2ZKTTNuUW56OHNZcU04V1pCS2s5NmZYOFRRdUZON3hmME5HVTQ5dWVaZHZGZUFIbkxnOWRzSkVidlVZQmFLSnZzc1pEekhueTdMdndsZUVhVGNwQjFlS0c4dlU9IiwibWFjIjoiMmJhMDlmYjU0MTNlMGI0MTAyZTU2MmE3MjA5ZTY0OTAwZGE2NTE2N2I2OWY2YThmMjI4YzJlYTkwZGZmMmYzYyIsInRhZyI6IiJ9; XSRF-TOKEN=eyJpdiI6IjlqSXR6OFowUkZVV3Vjdk1zczRoTEE9PSIsInZhbHVlIjoiMklvYjRTS3JDM0ZHTFhkUWJvVUZ6OC9tb1NoUXlBNG11TEpGN2YxRnZxU3pKZUNUaGxlL0VuMFUxVzRrZ2RYSFIzdDVFcWVudkxYMTdsNy9FZjhrUG5JVmNncHNoalVCd3ZUVXd4Qkh5bDVlWFZXNlk5OEFySTFOSTJNL0UwRE8iLCJtYWMiOiIwOGE1MzYzZGI4OWQ1MjU5MmUwOWEwNDYwOGM2Nzg0MDE4YjQxZmI1ZDU4YzlmYzY4NDg0NTQ0MTUxNGQxY2YzIiwidGFnIjoiIn0%3D; laravel_session=eyJpdiI6InE0VC9vbGtvRW11Y3d2TFhNUlN3WWc9PSIsInZhbHVlIjoiSDRpOG5jZW9qczU1dWZtWEZScTR3emd4WUthVEt2NTFGMnk5Y1FYUFdvc3VYUlZvNkxVWXhBb0JsYWZSWHkrSDRablVuNkxYNGdkZjdFSHA1V2Q0NFVaMlI4K2lWREJFYnFzYkpZRVBQQmQ4aFo5K2Y3c29uV2ZJMVhVSXBKN3giLCJtYWMiOiIyNDRmYTZlNzQwOWFmYWJkYzA2ZjgwOGFkNTAyY2M4MWU1YjVkODEwYWMzZTFlNWZiYTA0YTYwYzQ2OGFhNWYyIiwidGFnIjoiIn0%3D; _ga=GA1.1.639115075.1737178033; _gcl_au=1.1.1079316450.1737178033; _ga_N9GLTHNRLQ=GS1.1.1737178032.1.0.1737178034.58.0.0uid=eyJpdiI6InJLQWpDeDREQnNoQzUxT0wxbDBpRlE9PSIsInZhbHVlIjoiN29XaFJ0S2tHc1RnQjByU2ZKTTNuUW56OHNZcU04V1pCS2s5NmZYOFRRdUZON3hmME5HVTQ5dWVaZHZGZUFIbkxnOWRzSkVidlVZ" ] "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.216.201.7" ] "host" => array:1 [ 0 => "laravel.cars2buy.co.uk" ] ]
        request_cookies
        0 of 0
        array:6 [ "uid" => "730245c19b77fc18b10660f6b64869ba" "XSRF-TOKEN" => "HM5bio4mNs033sc119Y9vbYOAA5NaPWc54zMX2L4" "laravel_session" => "DVAY2xMQoypUh7h9dT2m9B2NA0TQE7z0MfU7482q" "_ga" => null "_gcl_au" => null "_ga_N9GLTHNRLQ" => null ]
        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 => "Sat, 18 Jan 2025 05:27:18 GMT" ] "pragma" => array:1 [ 0 => "no-cache" ] "expires" => array:1 [ 0 => "-1" ] "set-cookie" => array:3 [ 0 => "uid=eyJpdiI6IlJzaEdoZG16ejhLWTh3aGRlSzlxUnc9PSIsInZhbHVlIjoiQWtGOTBmUmk5RExjck1nQXI1Nk9CZk9NTlZVd09qdDdOaE4yZWRvWkRWN25ZdHZxRVpDYUZiSlRtNXJGZmt6VEY0R2lDSmlqV2Z5OHVQYW1HUDgvTnJ2TXBJZHB2ZkxCdFl4ZTdaU08vVEk9IiwibWFjIjoiYTlkODA0OWE3MTExNTkyZjFlN2VlM2MwYmI1ZWJhNmI3ZjEyODFiZGM5NjIwNzlhYWNhNjIwZjg5MmZjZDVmYiIsInRhZyI6IiJ9; expires=Fri, 22 Jul 5357 20:45:18 GMT; Max-Age=105163802280; path=/; secure; httponly; samesite=laxuid=eyJpdiI6IlJzaEdoZG16ejhLWTh3aGRlSzlxUnc9PSIsInZhbHVlIjoiQWtGOTBmUmk5RExjck1nQXI1Nk9CZk9NTlZVd09qdDdOaE4yZWRvWkRWN25ZdHZxRVpDYUZiSlRtNXJGZmt6VEY0R2lDSmlqV2Z5" 1 => "XSRF-TOKEN=eyJpdiI6IjMzRDhwSWIyVS9IR3Q3VHp0WDFJVWc9PSIsInZhbHVlIjoiY3duS2VYOE9rRURLZGJaekYxTW01cmxXQ2xKQXVPQXVCRDZIVlpnSTQ3T2hWbjN0SXU0eFhZQjI3N0QvanFBcVErMUJQM0RTTDJ2QVREWHJmeGFlMDBqOFVsdy9Yb051eVlZaENJVlhOUDFTMDlySVV1cGhkYks1Q1NhWTQvYjAiLCJtYWMiOiIzMjY1ZTZlMzcyYzFlMDRkYjQ1ZWUzZTM3ZDAwZWRmODExMzA1YWU3ZTdlY2JjNDkzMDZjYTZlNmY2MzQyZWYxIiwidGFnIjoiIn0%3D; expires=Sat, 18 Jan 2025 07:27:18 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IjMzRDhwSWIyVS9IR3Q3VHp0WDFJVWc9PSIsInZhbHVlIjoiY3duS2VYOE9rRURLZGJaekYxTW01cmxXQ2xKQXVPQXVCRDZIVlpnSTQ3T2hWbjN0SXU0eFhZQjI3N0QvanFBcVErMUJQM" 2 => "laravel_session=eyJpdiI6IjFMQ2RJRmJrRTVsdjJHeGtnVEgvTGc9PSIsInZhbHVlIjoidnBMd3g2Yjc1UFdwQjA2K0dyejIwZVNkWVN5UWYwc3U4TzNtbkJkd3hNQU5ielZ6MzYrWTYzN29lT2ZkME5MNXZEb2xaZ0poS1dUSC9HV3FiaG4xT01SL0hIclpJQkZxSUpMM2JLTkFnN0Z6UTBKY3YvMkJFOFhCZFJzdThPS28iLCJtYWMiOiJhNzJmYmIwZjZhODViMDA0OTIzNmM3NDMyNDMzNGYwYzBjMDYyMGFlMTlhNTkzMGYwOTVjNjU4NGRmOTZmNzhmIiwidGFnIjoiIn0%3D; expires=Sat, 18 Jan 2025 07:27:18 GMT; Max-Age=7200; path=/; httponly; samesite=laxlaravel_session=eyJpdiI6IjFMQ2RJRmJrRTVsdjJHeGtnVEgvTGc9PSIsInZhbHVlIjoidnBMd3g2Yjc1UFdwQjA2K0dyejIwZVNkWVN5UWYwc3U4TzNtbkJkd3hNQU5ielZ6MzYrWTYzN29lT2ZkME5MNXZE" ] "Set-Cookie" => array:3 [ 0 => "uid=eyJpdiI6IlJzaEdoZG16ejhLWTh3aGRlSzlxUnc9PSIsInZhbHVlIjoiQWtGOTBmUmk5RExjck1nQXI1Nk9CZk9NTlZVd09qdDdOaE4yZWRvWkRWN25ZdHZxRVpDYUZiSlRtNXJGZmt6VEY0R2lDSmlqV2Z5OHVQYW1HUDgvTnJ2TXBJZHB2ZkxCdFl4ZTdaU08vVEk9IiwibWFjIjoiYTlkODA0OWE3MTExNTkyZjFlN2VlM2MwYmI1ZWJhNmI3ZjEyODFiZGM5NjIwNzlhYWNhNjIwZjg5MmZjZDVmYiIsInRhZyI6IiJ9; expires=Fri, 22-Jul-5357 20:45:18 GMT; path=/; secure; httponlyuid=eyJpdiI6IlJzaEdoZG16ejhLWTh3aGRlSzlxUnc9PSIsInZhbHVlIjoiQWtGOTBmUmk5RExjck1nQXI1Nk9CZk9NTlZVd09qdDdOaE4yZWRvWkRWN25ZdHZxRVpDYUZiSlRtNXJGZmt6VEY0R2lDSmlqV2Z5" 1 => "XSRF-TOKEN=eyJpdiI6IjMzRDhwSWIyVS9IR3Q3VHp0WDFJVWc9PSIsInZhbHVlIjoiY3duS2VYOE9rRURLZGJaekYxTW01cmxXQ2xKQXVPQXVCRDZIVlpnSTQ3T2hWbjN0SXU0eFhZQjI3N0QvanFBcVErMUJQM0RTTDJ2QVREWHJmeGFlMDBqOFVsdy9Yb051eVlZaENJVlhOUDFTMDlySVV1cGhkYks1Q1NhWTQvYjAiLCJtYWMiOiIzMjY1ZTZlMzcyYzFlMDRkYjQ1ZWUzZTM3ZDAwZWRmODExMzA1YWU3ZTdlY2JjNDkzMDZjYTZlNmY2MzQyZWYxIiwidGFnIjoiIn0%3D; expires=Sat, 18-Jan-2025 07:27:18 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IjMzRDhwSWIyVS9IR3Q3VHp0WDFJVWc9PSIsInZhbHVlIjoiY3duS2VYOE9rRURLZGJaekYxTW01cmxXQ2xKQXVPQXVCRDZIVlpnSTQ3T2hWbjN0SXU0eFhZQjI3N0QvanFBcVErMUJQM" 2 => "laravel_session=eyJpdiI6IjFMQ2RJRmJrRTVsdjJHeGtnVEgvTGc9PSIsInZhbHVlIjoidnBMd3g2Yjc1UFdwQjA2K0dyejIwZVNkWVN5UWYwc3U4TzNtbkJkd3hNQU5ielZ6MzYrWTYzN29lT2ZkME5MNXZEb2xaZ0poS1dUSC9HV3FiaG4xT01SL0hIclpJQkZxSUpMM2JLTkFnN0Z6UTBKY3YvMkJFOFhCZFJzdThPS28iLCJtYWMiOiJhNzJmYmIwZjZhODViMDA0OTIzNmM3NDMyNDMzNGYwYzBjMDYyMGFlMTlhNTkzMGYwOTVjNjU4NGRmOTZmNzhmIiwidGFnIjoiIn0%3D; expires=Sat, 18-Jan-2025 07:27:18 GMT; path=/; httponlylaravel_session=eyJpdiI6IjFMQ2RJRmJrRTVsdjJHeGtnVEgvTGc9PSIsInZhbHVlIjoidnBMd3g2Yjc1UFdwQjA2K0dyejIwZVNkWVN5UWYwc3U4TzNtbkJkd3hNQU5ielZ6MzYrWTYzN29lT2ZkME5MNXZE" ] ]
        session_attributes
        0 of 0
        array:7 [ "_token" => "HM5bio4mNs033sc119Y9vbYOAA5NaPWc54zMX2L4" "views" => 2 "uid" => "730245c19b77fc18b10660f6b64869ba" "last_results_page" => "/personal-car-leasing/ford/mustang-mach-e/premium/?page=73&trimText=Premium" "_previous" => array:1 [ "url" => "https://laravel.cars2buy.co.uk/van-leasing/mercedes-benz/vito-l3/vito-l3-diesel-rwd-114cdi-pro-van-9g-tronic_52469" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-01-18 05:27:18GET/van-leasing/mercedes-benz/vito-l3/vito-l3-diesel-rwd-114cdi-pro-van-9g-tronic_524694142681