Nissan Primastar L2 Leasing Deals:

NISSAN PRIMASTAR L2

Page 406 of 2181 pages

Filter your results:

Lease details:

Van details:

Nissan Primastar L2 variants:

New Van Offers:

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

Filter your results:

Lease details:

Van details:

Request history8.2.27PHP Version1.53sRequest Duration2MBMemory UsageGET van-leasing/{manufacturer}/{model}Route
  • warninglog[18:09:05] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[18:09:05] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[18:09:06] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[18:09:06] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • Booting (37.79ms)time
  • Application (1.49s)time
  • 1 x Application (97.53%)
    1.49s
    1 x Booting (2.47%)
    37.79ms
    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
    23 statements were executed1.3s
    • 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` = 'nissan' and `model_slug` = 'primastar-l2') limit 1
      940μsvandirectController.php#434
      Bindings
      • 0: nissan
      • 1: primastar-l2
      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` = 'nissan' and `model_slug` = 'primastar-l2' and `live` = 1 and `capid` > 1 and `lease_live` = 1 and `price_monthly` > 0)
      169msvandirectVanLeasingSearch.php#45
      Bindings
      • 0: nissan
      • 1: primastar-l2
      • 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` = 'nissan' and `model_slug` = 'primastar-l2' and `live` = 1 and `capid` > 1 and `lease_live` = 1 and `price_monthly` > 0) order by price_monthly limit 10 offset 4050
      228msvandirectVanLeasingSearch.php#45
      Bindings
      • 0: nissan
      • 1: primastar-l2
      • 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` = 'NISSAN' and `vandirect`.`vans`.`model` = 'PRIMASTAR L2' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'LCV' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
      1.26msbrampacImagesRepository.php#66
      Bindings
      • 0: NISSAN
      • 1: PRIMASTAR L2
      • 2: 
      • 3: 
      • 4: LCV
      Backtrace
      • 14. app/Queries/ImagesRepository.php:66
      • 15. app/Traits/VehicleImage.php:112
      • 16. app/Http/Controllers/VanLeasingController.php:133
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `ipuser` from `lease_clicks` where (`make` = 'NISSAN' and `model` = 'PRIMASTAR L2' and `stamp` <= '2025-01-23' and `stamp` >= '2025-01-13' and `ipuser` != '' and `make_rule` = 0 and `robot_rule` = 0) group by `ipuser`
      29.77msvandirectVanLeaseClickRepository.php#105
      Bindings
      • 0: NISSAN
      • 1: PRIMASTAR L2
      • 2: 2025-01-23
      • 3: 2025-01-13
      • 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 ('1f2c2e9e35827c09f9a9c3b13f9ff037', '221116c46b3ef5b0e9e971519c18eceb', '3b3e7964ae463b3d23a4e47d552a0617', '3e6511c9f96d4f415a5409ee6fecbf69', '40f5883fbadeb4f9dc529a797868cdf5', '45354f231e81215e6ce719e2a6bccb95', '4b2f62a3f19c34d217c05a8bccd08ebf', '4b57c541a72976afc51e9c583030c7d1', '539d982ee71c5e3e2b9cadadb79f3d0d', '6a273af92dc707110f8f2322d3bc80c9', '8b201c2c078f2906c961f06e4bcce08e', '9b34a5146baa1b629f4d481c502e5821', 'a5514ee05bbcc012de2f0329f01ab4d8', 'ce8f7e8259c3b9597df673df1d593707') and (`make` != 'NISSAN' and `model` != 'PRIMASTAR L2' and `stamp` < '2025-01-23' and `stamp` >= '2025-01-13' and `make_rule` = 0 and `robot_rule` = 0) group by `model`, `make` order by `count` desc limit 5
      35.14msvandirectVanLeaseClickRepository.php#77
      Bindings
      • 0: 1f2c2e9e35827c09f9a9c3b13f9ff037
      • 1: 221116c46b3ef5b0e9e971519c18eceb
      • 2: 3b3e7964ae463b3d23a4e47d552a0617
      • 3: 3e6511c9f96d4f415a5409ee6fecbf69
      • 4: 40f5883fbadeb4f9dc529a797868cdf5
      • 5: 45354f231e81215e6ce719e2a6bccb95
      • 6: 4b2f62a3f19c34d217c05a8bccd08ebf
      • 7: 4b57c541a72976afc51e9c583030c7d1
      • 8: 539d982ee71c5e3e2b9cadadb79f3d0d
      • 9: 6a273af92dc707110f8f2322d3bc80c9
      • 10: 8b201c2c078f2906c961f06e4bcce08e
      • 11: 9b34a5146baa1b629f4d481c502e5821
      • 12: a5514ee05bbcc012de2f0329f01ab4d8
      • 13: ce8f7e8259c3b9597df673df1d593707
      • 14: NISSAN
      • 15: PRIMASTAR L2
      • 16: 2025-01-23
      • 17: 2025-01-13
      • 18: 0
      • 19: 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` = 'nissan' and `model_slug` = 'primastar-l2' and `model_long` = '') order by `derivative` asc
      530μsvandirectVanModel.php#163
      Bindings
      • 0: nissan
      • 1: primastar-l2
      • 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` = 'nissan' and `model_slug` = 'primastar-l2') limit 1
      142msvandirectVanLeasingSearch.php#234
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: 0
      • 4: nissan
      • 5: primastar-l2
      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
      200μ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` = 'nissan' order by `model` asc
      2.09msvandirectVanModel.php#26
      Bindings
      • 0: nissan
      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` = 'nissan' and `model_slug` = 'primastar-l2' and `did` = 160 and `live` = 1 and `capid` > 1 and `lease_live` = 1 and `price_monthly` > 0) order by `price_monthly` asc limit 1
      9.53msvandirectVanLeasingSearch.php#102
      Bindings
      • 0: nissan
      • 1: primastar-l2
      • 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` = 'nissan' and `model_slug` = 'primastar-l2' and `d_live` = 1 and `live` = 1 and `otrprice` > 4000 and `amount` > 0) order by `otrprice` asc limit 1
      750μsvandirectNewVanSearch.php#205
      Bindings
      • 0: nissan
      • 1: primastar-l2
      • 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` = 'nissan' and `model_slug` = 'primastar-l2' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) order by `derivative` asc
      18.78msvandirectVanLeaseFilter.php#69
      Bindings
      • 0: nissan
      • 1: primastar-l2
      • 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` = 'nissan' and `model_slug` = 'primastar-l2' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) order by `fuel` asc
      18.85msvandirectVanLeaseFilter.php#99
      Bindings
      • 0: nissan
      • 1: primastar-l2
      • 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` = 'nissan' and `model_slug` = 'primastar-l2' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) order by `transmission` asc
      18.74msvandirectVanLeaseFilter.php#114
      Bindings
      • 0: nissan
      • 1: primastar-l2
      • 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` = 'nissan' and `model_slug` = 'primastar-l2' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) order by `model_long` asc
      18.79msvandirectVanLeaseFilter.php#123
      Bindings
      • 0: nissan
      • 1: primastar-l2
      • 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` = 'nissan' and `model_slug` = 'primastar-l2' 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
      150msvandirectVanLeaseFilter.php#138
      Bindings
      • 0: nissan
      • 1: primastar-l2
      • 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` = 'nissan' and `model_slug` = 'primastar-l2' 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
      153msvandirectVanLeaseFilter.php#153
      Bindings
      • 0: nissan
      • 1: primastar-l2
      • 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` = 'nissan' and `model_slug` = 'primastar-l2' 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
      148msvandirectVanLeaseFilter.php#169
      Bindings
      • 0: nissan
      • 1: primastar-l2
      • 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` = 'nissan' and `model_slug` = 'primastar-l2' 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
      152msvandirectVanLeaseFilter.php#193
      Bindings
      • 0: nissan
      • 1: primastar-l2
      • 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` = 'nissan' and `model_slug` = 'primastar-l2') group by `make`, `model`, `model_long`, `model_long_slug`, `make_slug`, `model_slug` order by `model_long` asc
      840μsvandirectVanModel.php#131
      Bindings
      • 0: nissan
      • 1: primastar-l2
      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` = 'nissan' and `model_slug` = 'primastar-l2' and `d_live` = 1 and `live` = 1 and `otrprice` > 4000 and `amount` > 0 and `capid` > 1) order by `otrprice` asc limit 2
      900μsvandirectNewVanSearch.php#276
      Bindings
      • 0: nissan
      • 1: primastar-l2
      • 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` = 'nissan' and `model_slug` = 'primastar-l2' and `d_live` = 1 and `live` = 1 and `otrprice` > 4000 and `amount` > 0 and `capid` > 1) order by `otrprice` asc limit 2
      830μsvandirectNewVanSearch.php#241
      Bindings
      • 0: nissan
      • 1: primastar-l2
      • 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
    88VanLeaseOffer.php#?
    App\Models\Van
    31Van.php#?
    App\Models\VanLeaseClick
    14VanLeaseClick.php#?
    App\Models\VanCusCar
    1VanCusCar.php#?
        _token
        1UZOvD1HvMOFIBXMWMcaicJHjwQaKoYlfjBEnKB1
        views
        1
        uid
        23350033371077c53236db14fd7e86a1
        _previous
        array:1 [ "url" => "https://laravel.cars2buy.co.uk/van-leasing/nissan/primastar-l2?page=406" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /van-leasing/nissan/primastar-l2/
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        0 of 0
        array:1 [ "page" => "406" ]
        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.145.165.254" ] "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 => "Thu, 23 Jan 2025 18:09:06 GMT" ] "pragma" => array:1 [ 0 => "no-cache" ] "expires" => array:1 [ 0 => "-1" ] "set-cookie" => array:3 [ 0 => "uid=eyJpdiI6IkpEalhjSmxESnFsQTdkbnJySnFFclE9PSIsInZhbHVlIjoiWGFQaWVUcVZORFdPU1RtL3NnN3VxWmxQeUlLRGtFbEoyVUxlUlJGcnpwUkVmZ1cwcm0rcjFSMDUwQVgrUEtlMGdBZlBWSzEvQWlnMVJmaHJoZzBFTk5relR6b05MVjR2RzZOUzU5RDh2YkU9IiwibWFjIjoiMmFmNzEwNDI4NTRiZWJlMzE4OTZmMzQwMzQ0NDlhMTIwZTYzYTM2ZTViYzhjOTQyMTdiZWM5MDIwNjY3YmJlMSIsInRhZyI6IiJ9; expires=Sun, 25 Jun 5358 03:15:06 GMT; Max-Age=105192464760; path=/; secure; httponly; samesite=laxuid=eyJpdiI6IkpEalhjSmxESnFsQTdkbnJySnFFclE9PSIsInZhbHVlIjoiWGFQaWVUcVZORFdPU1RtL3NnN3VxWmxQeUlLRGtFbEoyVUxlUlJGcnpwUkVmZ1cwcm0rcjFSMDUwQVgrUEtlMGdBZlBWSzEvQWln" 1 => "XSRF-TOKEN=eyJpdiI6IkNEVXh2bnpDSllsaHdWRjAwWDlGamc9PSIsInZhbHVlIjoiTjNOaFBLamg3TmU1QlpNZDNGN1JmY2QyMkhONmROU2NQc2xodW5zcU5zY1VmWkx6QkhOOXRpaC8yRis3Q3h2ZGtRVHUvRnY4SFQ1SXZhalNwVGFTNk9uTFNSQjZhNGhFM2hZQ2VZMExpQXZubTdVWXdlNHAyUGRMMXZLZyt1ekMiLCJtYWMiOiJhMDdlZjYwMzliYjc2OGQ4OTQ5ZDRmMDI0ZDgzMDdhNzA4MGUzZTQ2ZDk2OTM4OTQyNmM0Y2RkMDI3NTU1MTM5IiwidGFnIjoiIn0%3D; expires=Thu, 23 Jan 2025 20:09:06 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IkNEVXh2bnpDSllsaHdWRjAwWDlGamc9PSIsInZhbHVlIjoiTjNOaFBLamg3TmU1QlpNZDNGN1JmY2QyMkhONmROU2NQc2xodW5zcU5zY1VmWkx6QkhOOXRpaC8yRis3Q3h2ZGtRVHUvR" 2 => "laravel_session=eyJpdiI6IkdrZ05ybmdrZVcrWFh4SG9YLzFTZVE9PSIsInZhbHVlIjoiaGFxSm5yTjcySTBKc1ZtTVI4ZUlhcG13dlhjZDM1eGgxcUNwQ29STFNlMDZxZVBHcmwzUHZJc0tKTXRrbm0vZXF5am04OWtkcnQvVFkvMmk5dGZoRi8xakxLb01FVlpJUGYyQUdjRG5nRkFoQTVGWWF3VFZjLzhTUUxwVlNqWVciLCJtYWMiOiI2M2MwYzYxMTdmZGJjMzc2MWE1NzZiZmMxMGY5ZDU5MGJmYmYxMGM0Mzc5OWQwNDFhNGUxYWJmZTYxYWEzODU0IiwidGFnIjoiIn0%3D; expires=Thu, 23 Jan 2025 20:09:06 GMT; Max-Age=7200; path=/; httponly; samesite=laxlaravel_session=eyJpdiI6IkdrZ05ybmdrZVcrWFh4SG9YLzFTZVE9PSIsInZhbHVlIjoiaGFxSm5yTjcySTBKc1ZtTVI4ZUlhcG13dlhjZDM1eGgxcUNwQ29STFNlMDZxZVBHcmwzUHZJc0tKTXRrbm0vZXF5" ] "Set-Cookie" => array:3 [ 0 => "uid=eyJpdiI6IkpEalhjSmxESnFsQTdkbnJySnFFclE9PSIsInZhbHVlIjoiWGFQaWVUcVZORFdPU1RtL3NnN3VxWmxQeUlLRGtFbEoyVUxlUlJGcnpwUkVmZ1cwcm0rcjFSMDUwQVgrUEtlMGdBZlBWSzEvQWlnMVJmaHJoZzBFTk5relR6b05MVjR2RzZOUzU5RDh2YkU9IiwibWFjIjoiMmFmNzEwNDI4NTRiZWJlMzE4OTZmMzQwMzQ0NDlhMTIwZTYzYTM2ZTViYzhjOTQyMTdiZWM5MDIwNjY3YmJlMSIsInRhZyI6IiJ9; expires=Sun, 25-Jun-5358 03:15:06 GMT; path=/; secure; httponlyuid=eyJpdiI6IkpEalhjSmxESnFsQTdkbnJySnFFclE9PSIsInZhbHVlIjoiWGFQaWVUcVZORFdPU1RtL3NnN3VxWmxQeUlLRGtFbEoyVUxlUlJGcnpwUkVmZ1cwcm0rcjFSMDUwQVgrUEtlMGdBZlBWSzEvQWln" 1 => "XSRF-TOKEN=eyJpdiI6IkNEVXh2bnpDSllsaHdWRjAwWDlGamc9PSIsInZhbHVlIjoiTjNOaFBLamg3TmU1QlpNZDNGN1JmY2QyMkhONmROU2NQc2xodW5zcU5zY1VmWkx6QkhOOXRpaC8yRis3Q3h2ZGtRVHUvRnY4SFQ1SXZhalNwVGFTNk9uTFNSQjZhNGhFM2hZQ2VZMExpQXZubTdVWXdlNHAyUGRMMXZLZyt1ekMiLCJtYWMiOiJhMDdlZjYwMzliYjc2OGQ4OTQ5ZDRmMDI0ZDgzMDdhNzA4MGUzZTQ2ZDk2OTM4OTQyNmM0Y2RkMDI3NTU1MTM5IiwidGFnIjoiIn0%3D; expires=Thu, 23-Jan-2025 20:09:06 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IkNEVXh2bnpDSllsaHdWRjAwWDlGamc9PSIsInZhbHVlIjoiTjNOaFBLamg3TmU1QlpNZDNGN1JmY2QyMkhONmROU2NQc2xodW5zcU5zY1VmWkx6QkhOOXRpaC8yRis3Q3h2ZGtRVHUvR" 2 => "laravel_session=eyJpdiI6IkdrZ05ybmdrZVcrWFh4SG9YLzFTZVE9PSIsInZhbHVlIjoiaGFxSm5yTjcySTBKc1ZtTVI4ZUlhcG13dlhjZDM1eGgxcUNwQ29STFNlMDZxZVBHcmwzUHZJc0tKTXRrbm0vZXF5am04OWtkcnQvVFkvMmk5dGZoRi8xakxLb01FVlpJUGYyQUdjRG5nRkFoQTVGWWF3VFZjLzhTUUxwVlNqWVciLCJtYWMiOiI2M2MwYzYxMTdmZGJjMzc2MWE1NzZiZmMxMGY5ZDU5MGJmYmYxMGM0Mzc5OWQwNDFhNGUxYWJmZTYxYWEzODU0IiwidGFnIjoiIn0%3D; expires=Thu, 23-Jan-2025 20:09:06 GMT; path=/; httponlylaravel_session=eyJpdiI6IkdrZ05ybmdrZVcrWFh4SG9YLzFTZVE9PSIsInZhbHVlIjoiaGFxSm5yTjcySTBKc1ZtTVI4ZUlhcG13dlhjZDM1eGgxcUNwQ29STFNlMDZxZVBHcmwzUHZJc0tKTXRrbm0vZXF5" ] ]
        session_attributes
        0 of 0
        array:6 [ "_token" => "1UZOvD1HvMOFIBXMWMcaicJHjwQaKoYlfjBEnKB1" "views" => 1 "uid" => "23350033371077c53236db14fd7e86a1" "_previous" => array:1 [ "url" => "https://laravel.cars2buy.co.uk/van-leasing/nissan/primastar-l2?page=406" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-01-23 18:09:06GET/van-leasing/nissan/primastar-l2/?page=40641423134