Nissan Primastar L1 Leasing Deals:

NISSAN PRIMASTAR L1

Page 35 of 44 pages

Nissan Primastar L1 variants:

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

Filter your results:

Lease details:

Van details:

Request history8.2.27PHP Version260msRequest Duration2MBMemory UsageGET van-leasing/{manufacturer}/{model}/{derivative}Route
  • warninglog[15:09:27] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[15:09:27] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[15:09:27] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[15:09:27] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • Booting (36.29ms)time
  • Application (224ms)time
  • 1 x Application (86.05%)
    224ms
    1 x Booting (13.94%)
    36.29ms
    14 templates were rendered
    • van-leasing.showshow.blade.php#?blade
    • van-leasing.search-barsearch-bar.blade.php#?blade
    • includes.paginationpagination.blade.php#?blade
    • van-leasing.filters.van-leasing-filtervan-leasing-filter.blade.php#?blade
    • includes.van-filtersvan-filters.blade.php#?blade
    • van-leasing.filters.van-leasing-filtervan-leasing-filter.blade.php#?blade
    • includes.van-filtersvan-filters.blade.php#?blade
    • van-leasing.extraextra.blade.php#?blade
    • appapp.blade.php#?blade
    • share.headhead.blade.php#?blade
    • includes.dfp-codedfp-code.blade.php#?blade
    • share.headerheader.blade.php#?blade
    • share.footerfooter.blade.php#?blade
    • share.footfoot.blade.php#?blade
    uri
    GET van-leasing/{manufacturer}/{model}/{derivative}
    middleware
    web
    controller
    App\Http\Controllers\VanLeasingController@results
    namespace
    where
    as
    van-leasing-results-derivative
    file
    app/Http/Controllers/VanLeasingController.php:109-190
    22 statements were executed68.16ms
    • 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-l1' and `van_id` = '53250') and CONCAT_WS('-',model_long_slug,derivative_slug)='primastar-30-l1-diesel-2.0-dci-110ps-h1-acenta-van' limit 1
      1.16msvandirectController.php#346
      Bindings
      • 0: nissan
      • 1: primastar-l1
      • 2: 53250
      Backtrace
      • 15. app/Http/Controllers/Controller.php:346
      • 16. app/Http/Controllers/Controller.php:58
      • 18. vendor/laravel/framework/src/Illuminate/Container/Container.php:952
      • 19. vendor/laravel/framework/src/Illuminate/Container/Container.php:795
      • 20. vendor/laravel/framework/src/Illuminate/Foundation/Application.php:957
    • select count(*) as aggregate from `lease_offers` inner join `vans` on `vans`.`van_id` = `lease_offers`.`id_car` inner join `dealers` on `dealers`.`did` = `lease_offers`.`bid` where (`make_slug` = 'nissan' and `model_slug` = 'primastar-l1' and `live` = 1 and `capid` > 1 and `lease_live` = 1 and `price_monthly` > 0) and `van_id` = '53250'
      2.38msvandirectVanLeasingSearch.php#45
      Bindings
      • 0: nissan
      • 1: primastar-l1
      • 2: 1
      • 3: 1
      • 4: 1
      • 5: 0
      • 6: 53250
      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-l1' and `live` = 1 and `capid` > 1 and `lease_live` = 1 and `price_monthly` > 0) and `van_id` = '53250' order by price_monthly limit 10 offset 340
      3.47msvandirectVanLeasingSearch.php#45
      Bindings
      • 0: nissan
      • 1: primastar-l1
      • 2: 1
      • 3: 1
      • 4: 1
      • 5: 0
      • 6: 53250
      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 L1' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'LCV' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
      1.12msbrampacImagesRepository.php#66
      Bindings
      • 0: NISSAN
      • 1: PRIMASTAR L1
      • 2: 
      • 3: 
      • 4: LCV
      Backtrace
      • 14. app/Queries/ImagesRepository.php:66
      • 15. app/Traits/VehicleImage.php:112
      • 16. app/Http/Controllers/VanLeasingController.php:133
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `ipuser` from `lease_clicks` where (`make` = 'NISSAN' and `model` = 'PRIMASTAR L1' and `stamp` <= '2025-01-18' and `stamp` >= '2025-01-08' and `ipuser` != '' and `make_rule` = 0 and `robot_rule` = 0) group by `ipuser`
      18.84msvandirectVanLeaseClickRepository.php#105
      Bindings
      • 0: NISSAN
      • 1: PRIMASTAR L1
      • 2: 2025-01-18
      • 3: 2025-01-08
      • 4: 
      • 5: 0
      • 6: 0
      Backtrace
      • 15. app/Queries/VanLeaseClickRepository.php:105
      • 16. app/Queries/VanLeaseClickRepository.php:53
      • 17. app/Http/Controllers/VanLeasingController.php:136
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select COUNT(click_id) AS count, make, model from `lease_clicks` where `ipuser` in ('0a18c26cbff3f8d52c994ff1c269926e', '1e64451f05a42993bb27d5c80996a820', '2bc0e0b574d85924cee4b319e0305dde', '30bcd94d2da0fe2557b63fc84e0995e3', '4a8d1eae46f5e917a2c5444663c030e0', '8d2b58dad066ddb3d3dccc498f0a6030', 'd44b78d7981094b324ce5f1602730e87') and (`make` != 'NISSAN' and `model` != 'PRIMASTAR L1' and `stamp` < '2025-01-18' and `stamp` >= '2025-01-08' and `make_rule` = 0 and `robot_rule` = 0) group by `model`, `make` order by `count` desc limit 5
      19.41msvandirectVanLeaseClickRepository.php#77
      Bindings
      • 0: 0a18c26cbff3f8d52c994ff1c269926e
      • 1: 1e64451f05a42993bb27d5c80996a820
      • 2: 2bc0e0b574d85924cee4b319e0305dde
      • 3: 30bcd94d2da0fe2557b63fc84e0995e3
      • 4: 4a8d1eae46f5e917a2c5444663c030e0
      • 5: 8d2b58dad066ddb3d3dccc498f0a6030
      • 6: d44b78d7981094b324ce5f1602730e87
      • 7: NISSAN
      • 8: PRIMASTAR L1
      • 9: 2025-01-18
      • 10: 2025-01-08
      • 11: 0
      • 12: 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-l1' and `model_long` = '') order by `derivative` asc
      510μsvandirectVanModel.php#163
      Bindings
      • 0: nissan
      • 1: primastar-l1
      • 2: 
      Backtrace
      • 15. app/Queries/VanModel.php:163
      • 16. app/Http/Controllers/VanLeasingController.php:148
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select COUNT(DISTINCT bid) as totalBrokers from `lease_offers` inner join `vans` on `vans`.`van_id` = `lease_offers`.`id_car` inner join `dealers` on `dealers`.`did` = `lease_offers`.`bid` where (`live` = 1 and `capid` > 1 and `lease_live` = 1 and `price_monthly` > 0) and `id_car` = '53250'
      3.32msvandirectVanLeasingSearch.php#225
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: 0
      • 4: 53250
      Backtrace
      • 15. app/Queries/VanLeasingSearch.php:225
      • 16. app/Http/Controllers/VanLeasingController.php:151
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select distinct `make`, `make_slug` from `vans` order by `make` asc
      100μ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.03msvandirectVanModel.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-l1' and `did` = 160 and `live` = 1 and `capid` > 1 and `lease_live` = 1 and `price_monthly` > 0) and `van_id` = '53250' order by `price_monthly` asc limit 1
      1.55msvandirectVanLeasingSearch.php#102
      Bindings
      • 0: nissan
      • 1: primastar-l1
      • 2: 160
      • 3: 1
      • 4: 1
      • 5: 1
      • 6: 0
      • 7: 53250
      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-l1' and `d_live` = 1 and `live` = 1 and `otrprice` > 4000 and `amount` > 0) order by `otrprice` asc limit 1
      950μsvandirectNewVanSearch.php#205
      Bindings
      • 0: nissan
      • 1: primastar-l1
      • 2: 1
      • 3: 1
      • 4: 4000
      • 5: 0
      Backtrace
      • 15. app/Queries/NewVanSearch.php:205
      • 16. app/Http/Controllers/VanLeasingController.php:179
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select distinct `van_id`, `derivative`, `model_long` from `lease_offers` inner join `vans` on `vans`.`van_id` = `lease_offers`.`id_car` inner join `dealers` on `dealers`.`did` = `lease_offers`.`bid` where (`make_slug` = 'nissan' and `model_slug` = 'primastar-l1' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `van_id` = '53250' order by `derivative` asc
      890μsvandirectVanLeaseFilter.php#69
      Bindings
      • 0: nissan
      • 1: primastar-l1
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: 53250
      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-l1' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `van_id` = '53250' order by `fuel` asc
      520μsvandirectVanLeaseFilter.php#99
      Bindings
      • 0: nissan
      • 1: primastar-l1
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: 53250
      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-l1' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `van_id` = '53250' order by `transmission` asc
      500μsvandirectVanLeaseFilter.php#114
      Bindings
      • 0: nissan
      • 1: primastar-l1
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: 53250
      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-l1' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `van_id` = '53250' order by `model_long` asc
      490μsvandirectVanLeaseFilter.php#123
      Bindings
      • 0: nissan
      • 1: primastar-l1
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: 53250
      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-l1' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `van_id` = '53250' and `term` in (6, 12, 18, 24, 36, 48, 60) order by `term` asc
      2.37msvandirectVanLeaseFilter.php#138
      Bindings
      • 0: nissan
      • 1: primastar-l1
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: 53250
      • 6: 6
      • 7: 12
      • 8: 18
      • 9: 24
      • 10: 36
      • 11: 48
      • 12: 60
      Backtrace
      • 15. app/Queries/SearchFilters/VanLeaseFilter.php:138
      • 16. app/Queries/SearchFilters/VanLeaseFilter.php:37
      • 17. app/Http/Controllers/VanLeasingController.php:180
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select distinct `mileage` from `lease_offers` inner join `vans` on `vans`.`van_id` = `lease_offers`.`id_car` inner join `dealers` on `dealers`.`did` = `lease_offers`.`bid` where (`make_slug` = 'nissan' and `model_slug` = 'primastar-l1' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `van_id` = '53250' 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
      2.54msvandirectVanLeaseFilter.php#153
      Bindings
      • 0: nissan
      • 1: primastar-l1
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: 53250
      • 6: 6
      • 7: 12
      • 8: 18
      • 9: 24
      • 10: 36
      • 11: 48
      • 12: 60
      • 13: 5000
      • 14: 6000
      • 15: 8000
      • 16: 10000
      • 17: 12000
      • 18: 15000
      • 19: 20000
      • 20: 25000
      • 21: 30000
      • 22: 35000
      • 23: 40000
      Backtrace
      • 15. app/Queries/SearchFilters/VanLeaseFilter.php:153
      • 16. app/Queries/SearchFilters/VanLeaseFilter.php:41
      • 17. app/Http/Controllers/VanLeasingController.php:180
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select distinct `mileage`, MAX(price_monthly) as max_price, MIN(price_monthly) as min_price from `lease_offers` inner join `vans` on `vans`.`van_id` = `lease_offers`.`id_car` inner join `dealers` on `dealers`.`did` = `lease_offers`.`bid` where (`make_slug` = 'nissan' and `model_slug` = 'primastar-l1' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `van_id` = '53250' 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
      2.26msvandirectVanLeaseFilter.php#169
      Bindings
      • 0: nissan
      • 1: primastar-l1
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: 53250
      • 6: 6
      • 7: 12
      • 8: 18
      • 9: 24
      • 10: 36
      • 11: 48
      • 12: 60
      • 13: 5000
      • 14: 6000
      • 15: 8000
      • 16: 10000
      • 17: 12000
      • 18: 15000
      • 19: 20000
      • 20: 25000
      • 21: 30000
      • 22: 35000
      • 23: 40000
      Backtrace
      • 15. app/Queries/SearchFilters/VanLeaseFilter.php:169
      • 16. app/Queries/SearchFilters/VanLeaseFilter.php:45
      • 17. app/Http/Controllers/VanLeasingController.php:180
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select distinct `mileage`, MAX(price_monthly) as max_price, MIN(price_monthly) as min_price, MAX(price_monthly) as max_price, MIN(price_monthly) as min_price from `lease_offers` inner join `vans` on `vans`.`van_id` = `lease_offers`.`id_car` inner join `dealers` on `dealers`.`did` = `lease_offers`.`bid` where (`make_slug` = 'nissan' and `model_slug` = 'primastar-l1' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `van_id` = '53250' 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
      2.43msvandirectVanLeaseFilter.php#193
      Bindings
      • 0: nissan
      • 1: primastar-l1
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: 53250
      • 6: 6
      • 7: 12
      • 8: 18
      • 9: 24
      • 10: 36
      • 11: 48
      • 12: 60
      • 13: 5000
      • 14: 6000
      • 15: 8000
      • 16: 10000
      • 17: 12000
      • 18: 15000
      • 19: 20000
      • 20: 25000
      • 21: 30000
      • 22: 35000
      • 23: 40000
      Backtrace
      • 15. app/Queries/SearchFilters/VanLeaseFilter.php:193
      • 16. app/Queries/SearchFilters/VanLeaseFilter.php:49
      • 17. app/Http/Controllers/VanLeasingController.php:180
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select distinct `make`, `model`, `model_long`, `model_long_slug`, `make_slug`, `model_slug`, `derivative` from `vans` where (`make_slug` = 'nissan' and `model_slug` = 'primastar-l1') group by `make`, `model`, `model_long`, `model_long_slug`, `make_slug`, `model_slug` order by `model_long` asc
      680μsvandirectVanModel.php#131
      Bindings
      • 0: nissan
      • 1: primastar-l1
      Backtrace
      • 15. app/Queries/VanModel.php:131
      • 16. app/Http/Controllers/VanLeasingController.php:183
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select `make`, `make_slug`, `model`, `model_slug`, `model_long`, `model_long_slug`, `derivative`, `derivative_slug`, `basic`, `capid`, `veh_id`, `urllink`, `logo`, `linked`, `bid`, `d_subid`, `otrprice`, `dealers`.`acc_type`, `cpclick`, `vans`.`delivery`, `motr` from `cus_cars` inner join `vans` on `vans`.`van_id` = `cus_cars`.`id_car` inner join `dealers` on `dealers`.`did` = `cus_cars`.`bid` inner join `account` on `account`.`broke_id` = `dealers`.`did` where (`make_slug` = 'nissan' and `model_slug` = 'primastar-l1' and `d_live` = 1 and `live` = 1 and `otrprice` > 4000 and `amount` > 0 and `capid` > 1) and `van_id` = '53250' order by `otrprice` asc limit 2
      640μsvandirectNewVanSearch.php#276
      Bindings
      • 0: nissan
      • 1: primastar-l1
      • 2: 1
      • 3: 1
      • 4: 4000
      • 5: 0
      • 6: 1
      • 7: 53250
      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
    App\Models\Van
    31Van.php#?
    App\Models\VanLeaseOffer
    30VanLeaseOffer.php#?
    App\Models\VanLeaseClick
    7VanLeaseClick.php#?
    App\Models\VanCusCar
    3VanCusCar.php#?
        _token
        543FwX9NST60lRAv4ZkuCQrWPXObcxJweoDZ13Db
        views
        8
        uid
        8932cdc0bebf37f0f8316b51f33416d9
        last_results_page
        /personal-car-leasing/bmw/4-series-gran-coupe/420i-m-sport-5dr-step-auto-tech-pack_79052?fDerivative...
        _previous
        array:1 [ "url" => "https://laravel.cars2buy.co.uk/van-leasing/nissan/primastar-l1/primastar-30-l1...
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /van-leasing/nissan/primastar-l1/primastar-30-l1-diesel-2.0-dci-110ps-h1-acenta-van_53250
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        0 of 0
        array:3 [ "fCarID" => "53250" "fDerivative" => "Primastar 30 L1 Diesel 2.0 Dci 110ps H1 Acenta Van" "page" => "35" ]
        request_request
        []
        
        request_headers
        0 of 0
        array:19 [ "cookie" => array:1 [ 0 => "_ga=GA1.1.1158562113.1737212943; _gcl_au=1.1.452916414.1737212943; _ga_N9GLTHNRLQ=GS1.1.1737212942.1.1.1737212955.47.0.0; uid=eyJpdiI6IlRMNWgzUkZEY2lxblY5YXAxbmxrcVE9PSIsInZhbHVlIjoiQSs1Tmt6ZDI2Q3NndHV6WkVleTlaTTk2eTM4Skc3L1hkTkNJaGUxaDdLVkc0NHduQzBVV0NBRW53VXpxd0M1YkFWRVM2S2h6Zm1HaDN2QTRTTVJkZHRPQXNhS1ptYk1lQ2xNS1VuNmFNZkU9IiwibWFjIjoiNDU1ZTJlZmYyZTE3NGM5MmE1MjdiZmVmOWFhODZhNjMyM2I0OGM4ZjQxMzViNDgxMDJlODU0OWE0ZWNhMWRmOCIsInRhZyI6IiJ9; XSRF-TOKEN=eyJpdiI6Iks0R2x3SE1uWEtTMVc4eDhoL2tFUlE9PSIsInZhbHVlIjoiSGt3QkJudVpGNUpPdTN1R0o4NW5SOVVXU0ZCc2pmYk5QbThxbEdsZlhaS0hydjFsYUpzemY3MmNmTldKcnFsdmRaME1QN2pmcUd1Nlo5YmZka1dNQ25hTUFFd01SeGNJTUZyQys0eVZ0Z3Q1QkY3NkFzeUpSai9Mc2g4bm01YVMiLCJtYWMiOiJmOGVhYThkMTYwOTI0ODA2Mzg2MThmYTQyYTkxMDE2OTUzNWUzODI2MDljYmZhMzM1MzE5OTJmYTE0YWE1MGRmIiwidGFnIjoiIn0%3D; laravel_session=eyJpdiI6IlNzcDd1WnpKTlQrUnE3eUlLd1pvT3c9PSIsInZhbHVlIjoidm4rVHVvam9ZMmUzNk54UTlsSmlnRC8zVU8wWVM0MStvV2JQMU5RTzVrZDB0cEMzNjVEMVgyWExqdk1yaytCRGlnOXl3L1VuZFhqNW5ieHZUV0xOUzN1d2xlRVdNZElIQmRrZ0luZXQ1LzF2YVBHL21yRjlBbEN2Si8xWnpJQzYiLCJtYWMiOiJmMWU2ZTk2M2ZkMmM3NWRiYjM5ZGQ4NjlkZDk4ZmRkN2RiNzgzOGExZjU2NzA2Mzg0OTUwNDk2YjI2ZmYzOTk2IiwidGFnIjoiIn0%3D_ga=GA1.1.1158562113.1737212943; _gcl_au=1.1.452916414.1737212943; _ga_N9GLTHNRLQ=GS1.1.1737212942.1.1.1737212955.47.0.0; uid=eyJpdiI6IlRMNWgzUkZEY2lxblY5YXAxbm" ] "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.154.214" ] "host" => array:1 [ 0 => "laravel.cars2buy.co.uk" ] ]
        request_cookies
        0 of 0
        array:6 [ "_ga" => null "_gcl_au" => null "_ga_N9GLTHNRLQ" => null "uid" => "8932cdc0bebf37f0f8316b51f33416d9" "XSRF-TOKEN" => "543FwX9NST60lRAv4ZkuCQrWPXObcxJweoDZ13Db" "laravel_session" => "jqLbziNVN2dxfNsz7WFC6qTb6M0gixtnKU8nOLhe" ]
        response_headers
        0 of 0
        array:7 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "private, must-revalidate" ] "date" => array:1 [ 0 => "Sat, 18 Jan 2025 15:09:27 GMT" ] "pragma" => array:1 [ 0 => "no-cache" ] "expires" => array:1 [ 0 => "-1" ] "set-cookie" => array:3 [ 0 => "uid=eyJpdiI6ImhINGdoVXdjcWQ5LzdxM0YxSWZTWmc9PSIsInZhbHVlIjoiTm5VcDFEL3duUlg3c0dlMnh1RUtMcEJwLy9IZkt5K1pxc1hvTWtYdkpOZ2xVc0NaQUIvMnpKazFVcG9UZWJtK3UrblpXNkRKRkY1dU9wMGtKY0VmSHlSNnduc0FmanYyb2w0dE1yWlFzVzA9IiwibWFjIjoiMjY2NDlhNmQ4MGJlYzUxZmI0Y2Q5NTYyOWZmNjIzOTYyZTcwODQ0YjIyNGMzNGVmZmQ1NzViZTJlZTQ4NzRjZCIsInRhZyI6IiJ9; expires=Tue, 16 Aug 5357 12:36:27 GMT; Max-Age=105165898020; path=/; secure; httponly; samesite=laxuid=eyJpdiI6ImhINGdoVXdjcWQ5LzdxM0YxSWZTWmc9PSIsInZhbHVlIjoiTm5VcDFEL3duUlg3c0dlMnh1RUtMcEJwLy9IZkt5K1pxc1hvTWtYdkpOZ2xVc0NaQUIvMnpKazFVcG9UZWJtK3UrblpXNkRKRkY1" 1 => "XSRF-TOKEN=eyJpdiI6InJDbnIyMjF6bi9jcTZaOWNLWEN1YUE9PSIsInZhbHVlIjoidG42SU9KOVZsNGYwT1BTbStDS1JEak1OL3NHaTM4OVM5MGxxRGtQeWhGd2x3cFpWV2dtekgyZmQ5RDl2ZWVlbUtzeGxNWEVMT0l4Qjg2amp3N29CYm9KOHNmb3o0Q0l5N3J2bkQvVXEweHhLZ0Y2aWovNnZxZHpFYTREMExSM0oiLCJtYWMiOiJhZTFlOWIzNjBkODI2NjQ1MWFlYWEwYjEwYWZmMzExY2QzNDAxM2JjMzQzZWI4ODJiZWQyZTA4M2FjNmY5NjQ2IiwidGFnIjoiIn0%3D; expires=Sat, 18 Jan 2025 17:09:27 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6InJDbnIyMjF6bi9jcTZaOWNLWEN1YUE9PSIsInZhbHVlIjoidG42SU9KOVZsNGYwT1BTbStDS1JEak1OL3NHaTM4OVM5MGxxRGtQeWhGd2x3cFpWV2dtekgyZmQ5RDl2ZWVlbUtzeGxNW" 2 => "laravel_session=eyJpdiI6IlJuWGRqZ3FkY2lpMUVFYU1aTVZHRXc9PSIsInZhbHVlIjoiNlhLKzRvUWtETnRxWjdTektZaFNpZnhrK3NCTEZ5ZXdFaFhTRUVlM3VyNmVZT1NQNy85cFRWdUpQOWUwRWxiM1l3eFJ2dC9hNVpUZkVodmpjQVBJeW1yaFNId1kwK0Q0OHk4ZlJkd2ZVUDNLTXFKQTZXU1NLcUl2UklwM1VMdXEiLCJtYWMiOiI5NDc2Y2E4YjczZTZlMWYzNDVkMWM3NGU0MDY0OWU5NTA0ODNmYWIyNGEwNWM3MWVjNzMwYzMwMDIwMTVmOGM4IiwidGFnIjoiIn0%3D; expires=Sat, 18 Jan 2025 17:09:27 GMT; Max-Age=7200; path=/; httponly; samesite=laxlaravel_session=eyJpdiI6IlJuWGRqZ3FkY2lpMUVFYU1aTVZHRXc9PSIsInZhbHVlIjoiNlhLKzRvUWtETnRxWjdTektZaFNpZnhrK3NCTEZ5ZXdFaFhTRUVlM3VyNmVZT1NQNy85cFRWdUpQOWUwRWxiM1l3" ] "Set-Cookie" => array:3 [ 0 => "uid=eyJpdiI6ImhINGdoVXdjcWQ5LzdxM0YxSWZTWmc9PSIsInZhbHVlIjoiTm5VcDFEL3duUlg3c0dlMnh1RUtMcEJwLy9IZkt5K1pxc1hvTWtYdkpOZ2xVc0NaQUIvMnpKazFVcG9UZWJtK3UrblpXNkRKRkY1dU9wMGtKY0VmSHlSNnduc0FmanYyb2w0dE1yWlFzVzA9IiwibWFjIjoiMjY2NDlhNmQ4MGJlYzUxZmI0Y2Q5NTYyOWZmNjIzOTYyZTcwODQ0YjIyNGMzNGVmZmQ1NzViZTJlZTQ4NzRjZCIsInRhZyI6IiJ9; expires=Tue, 16-Aug-5357 12:36:27 GMT; path=/; secure; httponlyuid=eyJpdiI6ImhINGdoVXdjcWQ5LzdxM0YxSWZTWmc9PSIsInZhbHVlIjoiTm5VcDFEL3duUlg3c0dlMnh1RUtMcEJwLy9IZkt5K1pxc1hvTWtYdkpOZ2xVc0NaQUIvMnpKazFVcG9UZWJtK3UrblpXNkRKRkY1" 1 => "XSRF-TOKEN=eyJpdiI6InJDbnIyMjF6bi9jcTZaOWNLWEN1YUE9PSIsInZhbHVlIjoidG42SU9KOVZsNGYwT1BTbStDS1JEak1OL3NHaTM4OVM5MGxxRGtQeWhGd2x3cFpWV2dtekgyZmQ5RDl2ZWVlbUtzeGxNWEVMT0l4Qjg2amp3N29CYm9KOHNmb3o0Q0l5N3J2bkQvVXEweHhLZ0Y2aWovNnZxZHpFYTREMExSM0oiLCJtYWMiOiJhZTFlOWIzNjBkODI2NjQ1MWFlYWEwYjEwYWZmMzExY2QzNDAxM2JjMzQzZWI4ODJiZWQyZTA4M2FjNmY5NjQ2IiwidGFnIjoiIn0%3D; expires=Sat, 18-Jan-2025 17:09:27 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6InJDbnIyMjF6bi9jcTZaOWNLWEN1YUE9PSIsInZhbHVlIjoidG42SU9KOVZsNGYwT1BTbStDS1JEak1OL3NHaTM4OVM5MGxxRGtQeWhGd2x3cFpWV2dtekgyZmQ5RDl2ZWVlbUtzeGxNW" 2 => "laravel_session=eyJpdiI6IlJuWGRqZ3FkY2lpMUVFYU1aTVZHRXc9PSIsInZhbHVlIjoiNlhLKzRvUWtETnRxWjdTektZaFNpZnhrK3NCTEZ5ZXdFaFhTRUVlM3VyNmVZT1NQNy85cFRWdUpQOWUwRWxiM1l3eFJ2dC9hNVpUZkVodmpjQVBJeW1yaFNId1kwK0Q0OHk4ZlJkd2ZVUDNLTXFKQTZXU1NLcUl2UklwM1VMdXEiLCJtYWMiOiI5NDc2Y2E4YjczZTZlMWYzNDVkMWM3NGU0MDY0OWU5NTA0ODNmYWIyNGEwNWM3MWVjNzMwYzMwMDIwMTVmOGM4IiwidGFnIjoiIn0%3D; expires=Sat, 18-Jan-2025 17:09:27 GMT; path=/; httponlylaravel_session=eyJpdiI6IlJuWGRqZ3FkY2lpMUVFYU1aTVZHRXc9PSIsInZhbHVlIjoiNlhLKzRvUWtETnRxWjdTektZaFNpZnhrK3NCTEZ5ZXdFaFhTRUVlM3VyNmVZT1NQNy85cFRWdUpQOWUwRWxiM1l3" ] ]
        session_attributes
        0 of 0
        array:7 [ "_token" => "543FwX9NST60lRAv4ZkuCQrWPXObcxJweoDZ13Db" "views" => 8 "uid" => "8932cdc0bebf37f0f8316b51f33416d9" "last_results_page" => "/personal-car-leasing/bmw/4-series-gran-coupe/420i-m-sport-5dr-step-auto-tech-pack_79052?fDerivative=420i+M+Sport+5dr+Step+Auto+Tech+Pack&page=15page%3D14" "_previous" => array:1 [ "url" => "https://laravel.cars2buy.co.uk/van-leasing/nissan/primastar-l1/primastar-30-l1-diesel-2.0-dci-110ps-h1-acenta-van_53250?fCarID=53250&fDerivative=Primastar%2030%20L1%20Diesel%202.0%20Dci%20110ps%20H1%20Acenta%20Van&page=35https://laravel.cars2buy.co.uk/van-leasing/nissan/primastar-l1/primastar-30-l1-diesel-2.0-dci-110ps-h1-acenta-van_53250?fCarID=53250&fDerivative=Primastar%2030%" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-01-18 15:09:27GET/van-leasing/nissan/primastar-l1/primastar-30-l1-diesel-2.0-dci-110ps-h1-acenta-van_53250?fCarID=53250&fDerivative=Primastar+30+L1+Diesel+2.0+Dci+110ps+H1+Acenta+Van&page=354142271