Land Rover Discovery Leasing Deals:

LAND ROVER DISCOVERY

Page 80 of 114 pages

People who viewed Land Rover Discovery deals also viewed:

Land Rover Discovery variants:

New Van Offers:

Compare Land Rover Discovery 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 Land Rover van dealers and leasing companies. We advertise the cheapest Land Rover Discovery leases to ensure that you are getting the best deal available. If you are looking to lease a Land Rover Discovery then you have come to the right place!

Filter your results:

Lease details:

Van details:

Request history8.2.27PHP Version344msRequest Duration2MBMemory UsageGET van-leasing/{manufacturer}/{model}Route
  • warninglog[05:27:35] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[05:27:35] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[05:27:35] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[05:27:35] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • Booting (35.49ms)time
  • Application (309ms)time
  • 1 x Application (89.68%)
    309ms
    1 x Booting (10.31%)
    35.49ms
    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 executed120ms
    • 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` = 'land-rover' and `model_slug` = 'discovery') limit 1
      1.2msvandirectController.php#434
      Bindings
      • 0: land-rover
      • 1: discovery
      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` = 'land-rover' and `model_slug` = 'discovery' and `live` = 1 and `capid` > 1 and `lease_live` = 1 and `price_monthly` > 0)
      7msvandirectVanLeasingSearch.php#45
      Bindings
      • 0: land-rover
      • 1: discovery
      • 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` = 'land-rover' and `model_slug` = 'discovery' and `live` = 1 and `capid` > 1 and `lease_live` = 1 and `price_monthly` > 0) order by price_monthly limit 10 offset 790
      9.21msvandirectVanLeasingSearch.php#45
      Bindings
      • 0: land-rover
      • 1: discovery
      • 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` = '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
      780μ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/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` = 'LAND ROVER' and `ima_model` = 'DISCOVERY' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'LCV' limit 1
      340μ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/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` = 'DISCOVERY' limit 1
      280μ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/Http/Controllers/VanLeasingController.php:133
      • 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • 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
      310μ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/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` = 'LAND ROVER' and `model` = 'DISCOVERY' and `stamp` <= '2025-01-22' and `stamp` >= '2025-01-12' and `ipuser` != '' and `make_rule` = 0 and `robot_rule` = 0) group by `ipuser`
      26.25msvandirectVanLeaseClickRepository.php#105
      Bindings
      • 0: LAND ROVER
      • 1: DISCOVERY
      • 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', '386b66ca85c922553d107eb53c202420', '54644b928e765f3a3629f3dab50026fe', '5504ca66e7ffff5c532348594aff28e5', '714a23fa806be14f93571e828bf2ba12', '716a2e2b70cd910e4f04547e55d993fc', '7a3da6a54beb6951b67d372cc3e5b1e0', '86a1463da0e7a46308e1467c01ea5e2f', '8bb4da4398cb6952133d85c7f7f05bad', '9136512d6196f7715cc3afe65f659dbf', '920e7dc7d3d67d6521840b12588b5b5c', 'ab83b763011ae7342e58f81f14d73653', 'ac2e108cf7cf5bb627c3670be21644de', 'b9f82a5cd6a6720db7622dbb9fafee5f', 'c2b827b1f7aacce9a2d4ab6de67c0445', 'cefec236450f65d6f2ef1171412fbdc5', 'd453378388c33be897e8446c7c848ca1', 'e7483e08932d0679ad3a30842bab85fa', 'f472844c6f3a616faa0be31a6e6031e8') and (`make` != 'LAND ROVER' and `model` != 'DISCOVERY' 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
      28.53msvandirectVanLeaseClickRepository.php#77
      Bindings
      • 0: 0cdaee584938b7e18b3a85a7c4c899e4
      • 1: 386b66ca85c922553d107eb53c202420
      • 2: 54644b928e765f3a3629f3dab50026fe
      • 3: 5504ca66e7ffff5c532348594aff28e5
      • 4: 714a23fa806be14f93571e828bf2ba12
      • 5: 716a2e2b70cd910e4f04547e55d993fc
      • 6: 7a3da6a54beb6951b67d372cc3e5b1e0
      • 7: 86a1463da0e7a46308e1467c01ea5e2f
      • 8: 8bb4da4398cb6952133d85c7f7f05bad
      • 9: 9136512d6196f7715cc3afe65f659dbf
      • 10: 920e7dc7d3d67d6521840b12588b5b5c
      • 11: ab83b763011ae7342e58f81f14d73653
      • 12: ac2e108cf7cf5bb627c3670be21644de
      • 13: b9f82a5cd6a6720db7622dbb9fafee5f
      • 14: c2b827b1f7aacce9a2d4ab6de67c0445
      • 15: cefec236450f65d6f2ef1171412fbdc5
      • 16: d453378388c33be897e8446c7c848ca1
      • 17: e7483e08932d0679ad3a30842bab85fa
      • 18: f472844c6f3a616faa0be31a6e6031e8
      • 19: LAND ROVER
      • 20: DISCOVERY
      • 21: 2025-01-22
      • 22: 2025-01-12
      • 23: 0
      • 24: 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` = '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
      510μ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/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` = '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/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` = '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/Queries/VanLeaseClickRepository.php:84
      • 21. app/Http/Controllers/VanLeasingController.php:136
    • 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
      410μ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/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` = 'land-rover' and `model_slug` = 'discovery' and `model_long` = '') order by `derivative` asc
      410μsvandirectVanModel.php#163
      Bindings
      • 0: land-rover
      • 1: discovery
      • 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` = 'land-rover' and `model_slug` = 'discovery') limit 1
      7.29msvandirectVanLeasingSearch.php#234
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: 0
      • 4: land-rover
      • 5: discovery
      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
      170μ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` = 'land-rover' order by `model` asc
      500μsvandirectVanModel.php#26
      Bindings
      • 0: land-rover
      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` = 'land-rover' and `model_slug` = 'discovery' and `did` = 160 and `live` = 1 and `capid` > 1 and `lease_live` = 1 and `price_monthly` > 0) order by `price_monthly` asc limit 1
      4.01msvandirectVanLeasingSearch.php#102
      Bindings
      • 0: land-rover
      • 1: discovery
      • 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` = 'land-rover' and `model_slug` = 'discovery' 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: land-rover
      • 1: discovery
      • 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` = 'land-rover' and `model_slug` = 'discovery' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) order by `derivative` asc
      760μsvandirectVanLeaseFilter.php#69
      Bindings
      • 0: land-rover
      • 1: discovery
      • 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` = 'land-rover' and `model_slug` = 'discovery' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) order by `fuel` asc
      760μsvandirectVanLeaseFilter.php#99
      Bindings
      • 0: land-rover
      • 1: discovery
      • 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` = 'land-rover' and `model_slug` = 'discovery' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) order by `transmission` asc
      750μsvandirectVanLeaseFilter.php#114
      Bindings
      • 0: land-rover
      • 1: discovery
      • 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` = 'land-rover' and `model_slug` = 'discovery' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) order by `model_long` asc
      720μsvandirectVanLeaseFilter.php#123
      Bindings
      • 0: land-rover
      • 1: discovery
      • 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` = 'land-rover' and `model_slug` = 'discovery' 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
      6.78msvandirectVanLeaseFilter.php#138
      Bindings
      • 0: land-rover
      • 1: discovery
      • 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` = 'land-rover' and `model_slug` = 'discovery' 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
      6.81msvandirectVanLeaseFilter.php#153
      Bindings
      • 0: land-rover
      • 1: discovery
      • 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` = 'land-rover' and `model_slug` = 'discovery' 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
      6.66msvandirectVanLeaseFilter.php#169
      Bindings
      • 0: land-rover
      • 1: discovery
      • 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` = 'land-rover' and `model_slug` = 'discovery' 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
      6.84msvandirectVanLeaseFilter.php#193
      Bindings
      • 0: land-rover
      • 1: discovery
      • 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` = 'land-rover' and `model_slug` = 'discovery') group by `make`, `model`, `model_long`, `model_long_slug`, `make_slug`, `model_slug` order by `model_long` asc
      410μsvandirectVanModel.php#131
      Bindings
      • 0: land-rover
      • 1: discovery
      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` = 'land-rover' and `model_slug` = 'discovery' and `d_live` = 1 and `live` = 1 and `otrprice` > 4000 and `amount` > 0 and `capid` > 1) order by `otrprice` asc limit 2
      490μsvandirectNewVanSearch.php#276
      Bindings
      • 0: land-rover
      • 1: discovery
      • 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` = 'land-rover' and `model_slug` = 'discovery' and `d_live` = 1 and `live` = 1 and `otrprice` > 4000 and `amount` > 0 and `capid` > 1) order by `otrprice` asc limit 2
      560μsvandirectNewVanSearch.php#241
      Bindings
      • 0: land-rover
      • 1: discovery
      • 2: 1
      • 3: 1
      • 4: 4000
      • 5: 0
      • 6: 1
      Backtrace
      • 15. app/Queries/NewVanSearch.php:241
      • 16. app/Http/Controllers/VanLeasingController.php:187
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    App\Models\VanLeaseOffer
    33VanLeaseOffer.php#?
    App\Models\Van
    25Van.php#?
    App\Models\VanLeaseClick
    20VanLeaseClick.php#?
    App\Models\VanCusCar
    1VanCusCar.php#?
        _token
        UuzMFGpJQb3gURCcd85PADOvKlIV3r0S9zcN7i1K
        views
        1
        uid
        e9a49055683f69a3476a7de3862518c8
        _previous
        array:1 [ "url" => "https://laravel.cars2buy.co.uk/van-leasing/land-rover/discovery?page=80" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /van-leasing/land-rover/discovery/
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        0 of 0
        array:1 [ "page" => "80" ]
        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.133.142.212" ] "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 05:27:35 GMT" ] "pragma" => array:1 [ 0 => "no-cache" ] "expires" => array:1 [ 0 => "-1" ] "set-cookie" => array:3 [ 0 => "uid=eyJpdiI6IkwxaExrRFRDc3ozNU92VGt0TU0vTXc9PSIsInZhbHVlIjoibkdOM2ZSamIrZ0hCc3BDNVo2dXlGSk1RcG9ybnBWejlRM1ZvUkt1RlJFTlNqeWpFYmxteUVqdXYrL0x4TDMzVEo0V1BsSVFyUTBkVjcrRllEay95d2JobHVHVm54NTZldithUkoyM3R3SGs9IiwibWFjIjoiNWY3YzI3YjQ0N2E1ZjYwNjM4MGY3MDJjMjc0NzJiYmY4MTZiNmEyNjllZGZiNGQyYjE5NzJmODUyYjE3N2ZjMCIsInRhZyI6IiJ9; expires=Thu, 23 Mar 5358 21:02:35 GMT; Max-Age=105184539300; path=/; secure; httponly; samesite=laxuid=eyJpdiI6IkwxaExrRFRDc3ozNU92VGt0TU0vTXc9PSIsInZhbHVlIjoibkdOM2ZSamIrZ0hCc3BDNVo2dXlGSk1RcG9ybnBWejlRM1ZvUkt1RlJFTlNqeWpFYmxteUVqdXYrL0x4TDMzVEo0V1BsSVFyUTBk" 1 => "XSRF-TOKEN=eyJpdiI6InByTWh2WlpHUG52WkZOS1NVM0wvdkE9PSIsInZhbHVlIjoicGdZTTcvc1dsSy95SVY2ODRCclVrNnVCR2p5NnlFZEQ2NUkxSUNaelpycXNHejJGMGcxdHYyekJpLzA4dVl0TXVNbTFENTJUbTNWcjBoZS9SUDZZMGFxeXo4a1FTK3JxOXVRVlNVZTA1RG4vZnd6QmFPYlJ3UXNiTGszaVNuWXAiLCJtYWMiOiI2MDc1MmJjMTk1OGMzNDVlZWUyZjgxNWNlZTA3M2RlNTEwNmUyNzQyNDAxZWQ5OTA0NDgxMTRjNTZjNTJjYTI5IiwidGFnIjoiIn0%3D; expires=Wed, 22 Jan 2025 07:27:35 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6InByTWh2WlpHUG52WkZOS1NVM0wvdkE9PSIsInZhbHVlIjoicGdZTTcvc1dsSy95SVY2ODRCclVrNnVCR2p5NnlFZEQ2NUkxSUNaelpycXNHejJGMGcxdHYyekJpLzA4dVl0TXVNbTFEN" 2 => "laravel_session=eyJpdiI6IlVyVUE2dld0OTJnT1pNaFVOS0N4VEE9PSIsInZhbHVlIjoiVHVxYlB3ZGU3d2JCMUdjT2xvOGd0NWVjeDZkTnRmelhOR3JWdnhKc0FnUEJ1VG1OUTFUYm5ULzBUbjlZRTRXR0JKQVFTWWJwekNSREdCSGFpM2xGVHQ2c3lRem9PODE5RFdFalYxTENsQi9VaWNPcElZdFR0THNpaGkySC9Wd2EiLCJtYWMiOiJjZDg5NzA0MzkxNGE1MDkxMTgxYjNkOWExMDY5ZDhjMDVmYTRkOGVkMjllMWViODgwZDk4YjdjYTZlZDlhNjM0IiwidGFnIjoiIn0%3D; expires=Wed, 22 Jan 2025 07:27:35 GMT; Max-Age=7200; path=/; httponly; samesite=laxlaravel_session=eyJpdiI6IlVyVUE2dld0OTJnT1pNaFVOS0N4VEE9PSIsInZhbHVlIjoiVHVxYlB3ZGU3d2JCMUdjT2xvOGd0NWVjeDZkTnRmelhOR3JWdnhKc0FnUEJ1VG1OUTFUYm5ULzBUbjlZRTRXR0JK" ] "Set-Cookie" => array:3 [ 0 => "uid=eyJpdiI6IkwxaExrRFRDc3ozNU92VGt0TU0vTXc9PSIsInZhbHVlIjoibkdOM2ZSamIrZ0hCc3BDNVo2dXlGSk1RcG9ybnBWejlRM1ZvUkt1RlJFTlNqeWpFYmxteUVqdXYrL0x4TDMzVEo0V1BsSVFyUTBkVjcrRllEay95d2JobHVHVm54NTZldithUkoyM3R3SGs9IiwibWFjIjoiNWY3YzI3YjQ0N2E1ZjYwNjM4MGY3MDJjMjc0NzJiYmY4MTZiNmEyNjllZGZiNGQyYjE5NzJmODUyYjE3N2ZjMCIsInRhZyI6IiJ9; expires=Thu, 23-Mar-5358 21:02:35 GMT; path=/; secure; httponlyuid=eyJpdiI6IkwxaExrRFRDc3ozNU92VGt0TU0vTXc9PSIsInZhbHVlIjoibkdOM2ZSamIrZ0hCc3BDNVo2dXlGSk1RcG9ybnBWejlRM1ZvUkt1RlJFTlNqeWpFYmxteUVqdXYrL0x4TDMzVEo0V1BsSVFyUTBk" 1 => "XSRF-TOKEN=eyJpdiI6InByTWh2WlpHUG52WkZOS1NVM0wvdkE9PSIsInZhbHVlIjoicGdZTTcvc1dsSy95SVY2ODRCclVrNnVCR2p5NnlFZEQ2NUkxSUNaelpycXNHejJGMGcxdHYyekJpLzA4dVl0TXVNbTFENTJUbTNWcjBoZS9SUDZZMGFxeXo4a1FTK3JxOXVRVlNVZTA1RG4vZnd6QmFPYlJ3UXNiTGszaVNuWXAiLCJtYWMiOiI2MDc1MmJjMTk1OGMzNDVlZWUyZjgxNWNlZTA3M2RlNTEwNmUyNzQyNDAxZWQ5OTA0NDgxMTRjNTZjNTJjYTI5IiwidGFnIjoiIn0%3D; expires=Wed, 22-Jan-2025 07:27:35 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6InByTWh2WlpHUG52WkZOS1NVM0wvdkE9PSIsInZhbHVlIjoicGdZTTcvc1dsSy95SVY2ODRCclVrNnVCR2p5NnlFZEQ2NUkxSUNaelpycXNHejJGMGcxdHYyekJpLzA4dVl0TXVNbTFEN" 2 => "laravel_session=eyJpdiI6IlVyVUE2dld0OTJnT1pNaFVOS0N4VEE9PSIsInZhbHVlIjoiVHVxYlB3ZGU3d2JCMUdjT2xvOGd0NWVjeDZkTnRmelhOR3JWdnhKc0FnUEJ1VG1OUTFUYm5ULzBUbjlZRTRXR0JKQVFTWWJwekNSREdCSGFpM2xGVHQ2c3lRem9PODE5RFdFalYxTENsQi9VaWNPcElZdFR0THNpaGkySC9Wd2EiLCJtYWMiOiJjZDg5NzA0MzkxNGE1MDkxMTgxYjNkOWExMDY5ZDhjMDVmYTRkOGVkMjllMWViODgwZDk4YjdjYTZlZDlhNjM0IiwidGFnIjoiIn0%3D; expires=Wed, 22-Jan-2025 07:27:35 GMT; path=/; httponlylaravel_session=eyJpdiI6IlVyVUE2dld0OTJnT1pNaFVOS0N4VEE9PSIsInZhbHVlIjoiVHVxYlB3ZGU3d2JCMUdjT2xvOGd0NWVjeDZkTnRmelhOR3JWdnhKc0FnUEJ1VG1OUTFUYm5ULzBUbjlZRTRXR0JK" ] ]
        session_attributes
        0 of 0
        array:6 [ "_token" => "UuzMFGpJQb3gURCcd85PADOvKlIV3r0S9zcN7i1K" "views" => 1 "uid" => "e9a49055683f69a3476a7de3862518c8" "_previous" => array:1 [ "url" => "https://laravel.cars2buy.co.uk/van-leasing/land-rover/discovery?page=80" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-01-22 05:27:35GET/van-leasing/land-rover/discovery/?page=804143079