Mercedes-Benz Vito L3 Leasing Deals:

MERCEDES-BENZ VITO L3

Page 10 of 179 pages

People who viewed Mercedes-Benz Vito L3 deals also viewed:

Mercedes-Benz Vito L3 variants:

New Van Offers:

Compare Mercedes-Benz Vito L3 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 leases to ensure that you are getting the best deal available. If you are looking to lease a Mercedes-Benz Vito L3 then you have come to the right place!

Filter your results:

Lease details:

Van details:

Request history8.2.27PHP Version353msRequest Duration2MBMemory UsageGET van-leasing/{manufacturer}/{model}Route
  • warninglog[22:00:01] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[22:00:01] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[22:00:01] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[22:00:01] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • Booting (35.42ms)time
  • Application (318ms)time
  • 1 x Application (89.97%)
    318ms
    1 x Booting (10.03%)
    35.42ms
    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
    30 statements were executed128ms
    • 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') limit 1
      920μsvandirectController.php#434
      Bindings
      • 0: mercedes-benz
      • 1: vito-l3
      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` = 'mercedes-benz' and `model_slug` = 'vito-l3' and `live` = 1 and `capid` > 1 and `lease_live` = 1 and `price_monthly` > 0)
      8.2msvandirectVanLeasingSearch.php#45
      Bindings
      • 0: mercedes-benz
      • 1: vito-l3
      • 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` = 'mercedes-benz' and `model_slug` = 'vito-l3' and `live` = 1 and `capid` > 1 and `lease_live` = 1 and `price_monthly` > 0) order by price_monthly limit 10 offset 90
      11.13msvandirectVanLeasingSearch.php#45
      Bindings
      • 0: mercedes-benz
      • 1: vito-l3
      • 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` = '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
      260μ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
      310μ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
      510μ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-22' and `stamp` >= '2025-01-12' and `ipuser` != '' and `make_rule` = 0 and `robot_rule` = 0) group by `ipuser`
      27.95msvandirectVanLeaseClickRepository.php#105
      Bindings
      • 0: MERCEDES-BENZ
      • 1: VITO L3
      • 2: 2025-01-22
      • 3: 2025-01-12
      • 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 ('0cdaee584938b7e18b3a85a7c4c899e4', '2796529443397bb6336760e94abb6ea3', '3012bd0363c254483f585ccee13ddfaf', '6910f894c8a9e53b037c6217e1c6d2b5', '8f21a4deda764f33125948515a076297', 'a6bcef04e15f35c11408c7ef8d887c38', 'a9c68cdf741d706471df1d3c6a78c0cd', 'cd8d93c1c30713a2d4d4ac2ab8635aa4', 'ce174a6172d7f18aad7231dcec0bb66b', 'd18a331e6497b5d18f1f1bb7c3b909ac', 'ef2c67500f3608a107d517bef182c431') and (`make` != 'MERCEDES-BENZ' and `model` != 'VITO L3' and `stamp` < '2025-01-22' and `stamp` >= '2025-01-12' and `make_rule` = 0 and `robot_rule` = 0) group by `model`, `make` order by `count` desc limit 5
      27.88msvandirectVanLeaseClickRepository.php#77
      Bindings
      • 0: 0cdaee584938b7e18b3a85a7c4c899e4
      • 1: 2796529443397bb6336760e94abb6ea3
      • 2: 3012bd0363c254483f585ccee13ddfaf
      • 3: 6910f894c8a9e53b037c6217e1c6d2b5
      • 4: 8f21a4deda764f33125948515a076297
      • 5: a6bcef04e15f35c11408c7ef8d887c38
      • 6: a9c68cdf741d706471df1d3c6a78c0cd
      • 7: cd8d93c1c30713a2d4d4ac2ab8635aa4
      • 8: ce174a6172d7f18aad7231dcec0bb66b
      • 9: d18a331e6497b5d18f1f1bb7c3b909ac
      • 10: ef2c67500f3608a107d517bef182c431
      • 11: MERCEDES-BENZ
      • 12: VITO L3
      • 13: 2025-01-22
      • 14: 2025-01-12
      • 15: 0
      • 16: 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 `path`, `izmoAlias` from `images_izmo` inner join `vandirect`.`vans` on `images_izmo`.`cap_id` = `vandirect`.`vans`.`capid` where `vandirect`.`vans`.`make` = 'LAND ROVER' and `vandirect`.`vans`.`model` = 'DISCOVERY' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'LCV' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
      500μsbrampacImagesRepository.php#66
      Bindings
      • 0: LAND ROVER
      • 1: DISCOVERY
      • 2: 
      • 3: 
      • 4: LCV
      Backtrace
      • 14. app/Queries/ImagesRepository.php:66
      • 15. app/Traits/VehicleImage.php:112
      • 16. app/Queries/VanLeaseClickRepository.php:84
      • 17. app/Http/Controllers/VanLeasingController.php:136
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select `path`, `izmoAlias` from `images_backfill` where `ima_make` = 'LAND ROVER' and `ima_model` = 'DISCOVERY' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'LCV' limit 1
      190μsbrampacImagesRepository.php#97
      Bindings
      • 0: LAND ROVER
      • 1: DISCOVERY
      • 2: 
      • 3: 
      • 4: LCV
      Backtrace
      • 16. app/Queries/ImagesRepository.php:97
      • 17. app/Traits/VehicleImage.php:121
      • 18. app/Queries/VanLeaseClickRepository.php:84
      • 19. app/Http/Controllers/VanLeasingController.php:136
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select `model_cap` from `vandirect`.`vans` where `model` = 'DISCOVERY' limit 1
      370μsbrampacImagesRepository.php#106
      Bindings
      • 0: DISCOVERY
      Backtrace
      • 14. app/Queries/ImagesRepository.php:106
      • 18. app/Queries/ImagesRepository.php:102
      • 19. app/Traits/VehicleImage.php:121
      • 20. app/Queries/VanLeaseClickRepository.php:84
      • 21. app/Http/Controllers/VanLeasingController.php:136
    • select `path`, `izmoAlias` from `images_backfill` where `ima_make` = 'LAND ROVER' and `ima_model` = (select `model_cap` from `vandirect`.`vans` where `model` = 'DISCOVERY' limit 1) and `path` != '' and `izmoAlias` != '' and `ima_type` = 'LCV' limit 1
      290μsbrampacImagesRepository.php#111
      Bindings
      • 0: LAND ROVER
      • 1: DISCOVERY
      • 2: 
      • 3: 
      • 4: LCV
      Backtrace
      • 16. app/Queries/ImagesRepository.php:111
      • 17. app/Traits/VehicleImage.php:121
      • 18. app/Queries/VanLeaseClickRepository.php:84
      • 19. app/Http/Controllers/VanLeasingController.php:136
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • 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
      440μ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 (`make_slug` = 'mercedes-benz' and `model_slug` = 'vito-l3') limit 1
      7.91msvandirectVanLeasingSearch.php#234
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: 0
      • 4: mercedes-benz
      • 5: vito-l3
      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
      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.17msvandirectVanModel.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) order by `price_monthly` asc limit 1
      1.27msvandirectVanLeasingSearch.php#102
      Bindings
      • 0: mercedes-benz
      • 1: vito-l3
      • 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` = '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
      620μ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) order by `derivative` asc
      720μsvandirectVanLeaseFilter.php#69
      Bindings
      • 0: mercedes-benz
      • 1: vito-l3
      • 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` = 'mercedes-benz' and `model_slug` = 'vito-l3' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) order by `fuel` asc
      730μsvandirectVanLeaseFilter.php#99
      Bindings
      • 0: mercedes-benz
      • 1: vito-l3
      • 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` = 'mercedes-benz' and `model_slug` = 'vito-l3' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) order by `transmission` asc
      650μsvandirectVanLeaseFilter.php#114
      Bindings
      • 0: mercedes-benz
      • 1: vito-l3
      • 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` = 'mercedes-benz' and `model_slug` = 'vito-l3' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) order by `model_long` asc
      640μsvandirectVanLeaseFilter.php#123
      Bindings
      • 0: mercedes-benz
      • 1: vito-l3
      • 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` = 'mercedes-benz' and `model_slug` = 'vito-l3' 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
      7.71msvandirectVanLeaseFilter.php#138
      Bindings
      • 0: mercedes-benz
      • 1: vito-l3
      • 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` = 'mercedes-benz' and `model_slug` = 'vito-l3' 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
      7.44msvandirectVanLeaseFilter.php#153
      Bindings
      • 0: mercedes-benz
      • 1: vito-l3
      • 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` = 'mercedes-benz' and `model_slug` = 'vito-l3' 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
      7.32msvandirectVanLeaseFilter.php#169
      Bindings
      • 0: mercedes-benz
      • 1: vito-l3
      • 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` = 'mercedes-benz' and `model_slug` = 'vito-l3' 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
      7.7msvandirectVanLeaseFilter.php#193
      Bindings
      • 0: mercedes-benz
      • 1: vito-l3
      • 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` = '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
      480μ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) order by `otrprice` asc limit 2
      610μsvandirectNewVanSearch.php#276
      Bindings
      • 0: mercedes-benz
      • 1: vito-l3
      • 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` = '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
      700μ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
    37VanLeaseOffer.php#?
    App\Models\VanLeaseClick
    12VanLeaseClick.php#?
    App\Models\VanCusCar
    1VanCusCar.php#?
        _token
        HBauNX1cG2UtM6qCS38bjDyjelKoDxSoYIXLnp7w
        views
        1
        uid
        70aa56e7ec2f7889036ce157a8aa9343
        _previous
        array:1 [ "url" => "https://laravel.cars2buy.co.uk/van-leasing/mercedes-benz/vito-l3?page=10" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /van-leasing/mercedes-benz/vito-l3/
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        0 of 0
        array:1 [ "page" => "10" ]
        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 => "3.21.129.214" ] "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 => "Wed, 22 Jan 2025 22:00:01 GMT" ] "pragma" => array:1 [ 0 => "no-cache" ] "expires" => array:1 [ 0 => "-1" ] "set-cookie" => array:3 [ 0 => "uid=eyJpdiI6IlpiUjBMV0dWZUtaWExJcFExU3hWL0E9PSIsInZhbHVlIjoiRTkvbVJCQTRVTVpPaFZKQ3NRMDVxcFFoMitYM2FYWVZPRHJublBoMU5oL0hjUDdiSllTWVVPV1BOUFVyVC9FQ0M3aEllVXRSVElMZGp0aFArWnJPdk1SdmVCQUNQUUxKNW8yeWRUVGNWTW89IiwibWFjIjoiMGFhZTEyZmNmMjFiN2UxNWExOTdmMzM2NDVhY2JjNWNlODc0NzBlYTg5OTg4OWQ4MmY3ZTdlNTQ5NWRmZjBmOSIsInRhZyI6IiJ9; expires=Thu, 04 May 5358 22:01:01 GMT; Max-Age=105188112060; path=/; secure; httponly; samesite=laxuid=eyJpdiI6IlpiUjBMV0dWZUtaWExJcFExU3hWL0E9PSIsInZhbHVlIjoiRTkvbVJCQTRVTVpPaFZKQ3NRMDVxcFFoMitYM2FYWVZPRHJublBoMU5oL0hjUDdiSllTWVVPV1BOUFVyVC9FQ0M3aEllVXRSVElM" 1 => "XSRF-TOKEN=eyJpdiI6InhYSU5QUGVPVWFWcXM0QUpkUzRrNUE9PSIsInZhbHVlIjoiUUZsNGNrL3FaMnlqRVpYeUpUdWZWVllmUi9uWmt2UkQ0Tk1Bbmd1SWFoVnRUdXBla05xNGs5RWlyYW5Od01KL1RYY2xsN21FWk54S3V6dGN1eWgybkFSRkI4TExRcHcrN1JGUjM0OUQ0emZPd3E2NzNEV2VtM2tmbThSWVMvWEIiLCJtYWMiOiJlOWY4NDA5Y2Y4NmJlYTgzOTViNTBiZDE5ZTQyN2Q3ZWExMGIxNDNiNmU5M2E0MjUyNzVhZTNjOTY3MGYxNjE1IiwidGFnIjoiIn0%3D; expires=Thu, 23 Jan 2025 00:00:01 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6InhYSU5QUGVPVWFWcXM0QUpkUzRrNUE9PSIsInZhbHVlIjoiUUZsNGNrL3FaMnlqRVpYeUpUdWZWVllmUi9uWmt2UkQ0Tk1Bbmd1SWFoVnRUdXBla05xNGs5RWlyYW5Od01KL1RYY2xsN" 2 => "laravel_session=eyJpdiI6ImFPeTU1VExValRJcUt3SnJITTZnQUE9PSIsInZhbHVlIjoiMk0zVnA5b2J2aUlmWUVMOFh4UTBjK0sxN1Z0R3hVbzBNaE9MVnRWT1hlNlQ0cXhFQkFmUzkvb3UvbEp2ZFB4ZFQ2ditOM2dRTi92bVlLRWMvZzdLQWo5SmVwNGdsaVpVbTlZbmZTOXN3TnE0c2VWSG1lck55eEY5amxCU1lXVUciLCJtYWMiOiJlZDg2NzJiNjcyYTMzODYwYzBmY2JiMDkyMTMyZWRmZDU2ZWJmOWQzMDA1Yzg5MDRmNDVlNmQxOWRmOGU3ZjhmIiwidGFnIjoiIn0%3D; expires=Thu, 23 Jan 2025 00:00:01 GMT; Max-Age=7200; path=/; httponly; samesite=laxlaravel_session=eyJpdiI6ImFPeTU1VExValRJcUt3SnJITTZnQUE9PSIsInZhbHVlIjoiMk0zVnA5b2J2aUlmWUVMOFh4UTBjK0sxN1Z0R3hVbzBNaE9MVnRWT1hlNlQ0cXhFQkFmUzkvb3UvbEp2ZFB4ZFQ2" ] "Set-Cookie" => array:3 [ 0 => "uid=eyJpdiI6IlpiUjBMV0dWZUtaWExJcFExU3hWL0E9PSIsInZhbHVlIjoiRTkvbVJCQTRVTVpPaFZKQ3NRMDVxcFFoMitYM2FYWVZPRHJublBoMU5oL0hjUDdiSllTWVVPV1BOUFVyVC9FQ0M3aEllVXRSVElMZGp0aFArWnJPdk1SdmVCQUNQUUxKNW8yeWRUVGNWTW89IiwibWFjIjoiMGFhZTEyZmNmMjFiN2UxNWExOTdmMzM2NDVhY2JjNWNlODc0NzBlYTg5OTg4OWQ4MmY3ZTdlNTQ5NWRmZjBmOSIsInRhZyI6IiJ9; expires=Thu, 04-May-5358 22:01:01 GMT; path=/; secure; httponlyuid=eyJpdiI6IlpiUjBMV0dWZUtaWExJcFExU3hWL0E9PSIsInZhbHVlIjoiRTkvbVJCQTRVTVpPaFZKQ3NRMDVxcFFoMitYM2FYWVZPRHJublBoMU5oL0hjUDdiSllTWVVPV1BOUFVyVC9FQ0M3aEllVXRSVElM" 1 => "XSRF-TOKEN=eyJpdiI6InhYSU5QUGVPVWFWcXM0QUpkUzRrNUE9PSIsInZhbHVlIjoiUUZsNGNrL3FaMnlqRVpYeUpUdWZWVllmUi9uWmt2UkQ0Tk1Bbmd1SWFoVnRUdXBla05xNGs5RWlyYW5Od01KL1RYY2xsN21FWk54S3V6dGN1eWgybkFSRkI4TExRcHcrN1JGUjM0OUQ0emZPd3E2NzNEV2VtM2tmbThSWVMvWEIiLCJtYWMiOiJlOWY4NDA5Y2Y4NmJlYTgzOTViNTBiZDE5ZTQyN2Q3ZWExMGIxNDNiNmU5M2E0MjUyNzVhZTNjOTY3MGYxNjE1IiwidGFnIjoiIn0%3D; expires=Thu, 23-Jan-2025 00:00:01 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6InhYSU5QUGVPVWFWcXM0QUpkUzRrNUE9PSIsInZhbHVlIjoiUUZsNGNrL3FaMnlqRVpYeUpUdWZWVllmUi9uWmt2UkQ0Tk1Bbmd1SWFoVnRUdXBla05xNGs5RWlyYW5Od01KL1RYY2xsN" 2 => "laravel_session=eyJpdiI6ImFPeTU1VExValRJcUt3SnJITTZnQUE9PSIsInZhbHVlIjoiMk0zVnA5b2J2aUlmWUVMOFh4UTBjK0sxN1Z0R3hVbzBNaE9MVnRWT1hlNlQ0cXhFQkFmUzkvb3UvbEp2ZFB4ZFQ2ditOM2dRTi92bVlLRWMvZzdLQWo5SmVwNGdsaVpVbTlZbmZTOXN3TnE0c2VWSG1lck55eEY5amxCU1lXVUciLCJtYWMiOiJlZDg2NzJiNjcyYTMzODYwYzBmY2JiMDkyMTMyZWRmZDU2ZWJmOWQzMDA1Yzg5MDRmNDVlNmQxOWRmOGU3ZjhmIiwidGFnIjoiIn0%3D; expires=Thu, 23-Jan-2025 00:00:01 GMT; path=/; httponlylaravel_session=eyJpdiI6ImFPeTU1VExValRJcUt3SnJITTZnQUE9PSIsInZhbHVlIjoiMk0zVnA5b2J2aUlmWUVMOFh4UTBjK0sxN1Z0R3hVbzBNaE9MVnRWT1hlNlQ0cXhFQkFmUzkvb3UvbEp2ZFB4ZFQ2" ] ]
        session_attributes
        0 of 0
        array:6 [ "_token" => "HBauNX1cG2UtM6qCS38bjDyjelKoDxSoYIXLnp7w" "views" => 1 "uid" => "70aa56e7ec2f7889036ce157a8aa9343" "_previous" => array:1 [ "url" => "https://laravel.cars2buy.co.uk/van-leasing/mercedes-benz/vito-l3?page=10" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-01-22 22:00:01GET/van-leasing/mercedes-benz/vito-l3/?page=104143091