Renault Trafic SWB Leasing Deals:

RENAULT TRAFIC SWB

Page 7 of 49 pages

Renault Trafic SWB variants:

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

Filter your results:

Lease details:

Van details:

Request history8.2.27PHP Version235msRequest Duration2MBMemory UsageGET van-leasing/{manufacturer}/{model}/{derivative}Route
  • warninglog[22:29:29] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[22:29:29] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[22:29:29] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[22:29:29] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[22:29:29] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[22:29:29] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • Booting (37.62ms)time
  • Application (198ms)time
  • 1 x Application (84%)
    198ms
    1 x Booting (15.99%)
    37.62ms
    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 executed33.29ms
    • 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` = 'renault' and `model_slug` = 'trafic-swb' and `van_id` = '50008') and CONCAT_WS('-',model_long_slug,derivative_slug)='trafic-swb-diesel-sl30-blue-dci-150-extra-sport-safety-van' limit 1
      1.41msvandirectController.php#346
      Bindings
      • 0: renault
      • 1: trafic-swb
      • 2: 50008
      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` = 'renault' and `model_slug` = 'trafic-swb' and `live` = 1 and `capid` > 1 and `lease_live` = 1 and `price_monthly` > 0) and `van_id` = '50008'
      1.46msvandirectVanLeasingSearch.php#45
      Bindings
      • 0: renault
      • 1: trafic-swb
      • 2: 1
      • 3: 1
      • 4: 1
      • 5: 0
      • 6: 50008
      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` = 'renault' and `model_slug` = 'trafic-swb' and `live` = 1 and `capid` > 1 and `lease_live` = 1 and `price_monthly` > 0) and `van_id` = '50008' order by price_monthly limit 10 offset 60
      2.29msvandirectVanLeasingSearch.php#45
      Bindings
      • 0: renault
      • 1: trafic-swb
      • 2: 1
      • 3: 1
      • 4: 1
      • 5: 0
      • 6: 50008
      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` = 'RENAULT' and `vandirect`.`vans`.`model` = 'TRAFIC SWB' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'LCV' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
      940μsbrampacImagesRepository.php#66
      Bindings
      • 0: RENAULT
      • 1: TRAFIC SWB
      • 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` = 'RENAULT' and `model` = 'TRAFIC SWB' and `stamp` <= '2025-02-02' and `stamp` >= '2025-01-23' and `ipuser` != '' and `make_rule` = 0 and `robot_rule` = 0) group by `ipuser`
      4.96msvandirectVanLeaseClickRepository.php#105
      Bindings
      • 0: RENAULT
      • 1: TRAFIC SWB
      • 2: 2025-02-02
      • 3: 2025-01-23
      • 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 ('04c9fdda7d48f76a2195c5fff89e50d0', 'afea240ca0ab569e74d13b8e952f1d05', 'c0f5dc99af69d36dc0eab08e7979b840', 'fb1d3ba221d8a0275b1758f9d18af2c1') and (`make` != 'RENAULT' and `model` != 'TRAFIC SWB' and `stamp` < '2025-02-02' and `stamp` >= '2025-01-23' and `make_rule` = 0 and `robot_rule` = 0) group by `model`, `make` order by `count` desc limit 5
      5.04msvandirectVanLeaseClickRepository.php#77
      Bindings
      • 0: 04c9fdda7d48f76a2195c5fff89e50d0
      • 1: afea240ca0ab569e74d13b8e952f1d05
      • 2: c0f5dc99af69d36dc0eab08e7979b840
      • 3: fb1d3ba221d8a0275b1758f9d18af2c1
      • 4: RENAULT
      • 5: TRAFIC SWB
      • 6: 2025-02-02
      • 7: 2025-01-23
      • 8: 0
      • 9: 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` = 'renault' and `model_slug` = 'trafic-swb' and `model_long` = '') order by `derivative` asc
      480μsvandirectVanModel.php#163
      Bindings
      • 0: renault
      • 1: trafic-swb
      • 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` = '50008'
      3.58msvandirectVanLeasingSearch.php#225
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: 0
      • 4: 50008
      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` = 'renault' order by `model` asc
      730μsvandirectVanModel.php#26
      Bindings
      • 0: renault
      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` = 'renault' and `model_slug` = 'trafic-swb' and `did` = 160 and `live` = 1 and `capid` > 1 and `lease_live` = 1 and `price_monthly` > 0) and `van_id` = '50008' order by `price_monthly` asc limit 1
      1.41msvandirectVanLeasingSearch.php#102
      Bindings
      • 0: renault
      • 1: trafic-swb
      • 2: 160
      • 3: 1
      • 4: 1
      • 5: 1
      • 6: 0
      • 7: 50008
      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` = 'renault' and `model_slug` = 'trafic-swb' and `d_live` = 1 and `live` = 1 and `otrprice` > 4000 and `amount` > 0) order by `otrprice` asc limit 1
      900μsvandirectNewVanSearch.php#205
      Bindings
      • 0: renault
      • 1: trafic-swb
      • 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` = 'renault' and `model_slug` = 'trafic-swb' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `van_id` = '50008' order by `derivative` asc
      600μsvandirectVanLeaseFilter.php#69
      Bindings
      • 0: renault
      • 1: trafic-swb
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: 50008
      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` = 'renault' and `model_slug` = 'trafic-swb' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `van_id` = '50008' order by `fuel` asc
      600μsvandirectVanLeaseFilter.php#99
      Bindings
      • 0: renault
      • 1: trafic-swb
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: 50008
      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` = 'renault' and `model_slug` = 'trafic-swb' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `van_id` = '50008' order by `transmission` asc
      570μsvandirectVanLeaseFilter.php#114
      Bindings
      • 0: renault
      • 1: trafic-swb
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: 50008
      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` = 'renault' and `model_slug` = 'trafic-swb' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `van_id` = '50008' order by `model_long` asc
      630μsvandirectVanLeaseFilter.php#123
      Bindings
      • 0: renault
      • 1: trafic-swb
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: 50008
      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` = 'renault' and `model_slug` = 'trafic-swb' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `van_id` = '50008' and `term` in (6, 12, 18, 24, 36, 48, 60) order by `term` asc
      1.5msvandirectVanLeaseFilter.php#138
      Bindings
      • 0: renault
      • 1: trafic-swb
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: 50008
      • 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` = 'renault' and `model_slug` = 'trafic-swb' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `van_id` = '50008' and `term` in (6, 12, 18, 24, 36, 48, 60) and `mileage` in (5000, 6000, 8000, 10000, 12000, 15000, 20000, 25000, 30000, 35000, 40000) order by `mileage` asc
      1.51msvandirectVanLeaseFilter.php#153
      Bindings
      • 0: renault
      • 1: trafic-swb
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: 50008
      • 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` = 'renault' and `model_slug` = 'trafic-swb' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `van_id` = '50008' and `term` in (6, 12, 18, 24, 36, 48, 60) and `mileage` in (5000, 6000, 8000, 10000, 12000, 15000, 20000, 25000, 30000, 35000, 40000) order by `mileage` asc
      1.57msvandirectVanLeaseFilter.php#169
      Bindings
      • 0: renault
      • 1: trafic-swb
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: 50008
      • 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` = 'renault' and `model_slug` = 'trafic-swb' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `van_id` = '50008' and `term` in (6, 12, 18, 24, 36, 48, 60) and `mileage` in (5000, 6000, 8000, 10000, 12000, 15000, 20000, 25000, 30000, 35000, 40000) order by `mileage` asc
      1.6msvandirectVanLeaseFilter.php#193
      Bindings
      • 0: renault
      • 1: trafic-swb
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: 50008
      • 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` = 'renault' and `model_slug` = 'trafic-swb') group by `make`, `model`, `model_long`, `model_long_slug`, `make_slug`, `model_slug` order by `model_long` asc
      640μsvandirectVanModel.php#131
      Bindings
      • 0: renault
      • 1: trafic-swb
      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` = 'renault' and `model_slug` = 'trafic-swb' and `d_live` = 1 and `live` = 1 and `otrprice` > 4000 and `amount` > 0 and `capid` > 1) and `van_id` = '50008' order by `otrprice` asc limit 2
      770μsvandirectNewVanSearch.php#276
      Bindings
      • 0: renault
      • 1: trafic-swb
      • 2: 1
      • 3: 1
      • 4: 4000
      • 5: 0
      • 6: 1
      • 7: 50008
      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
    33Van.php#?
    App\Models\VanLeaseOffer
    31VanLeaseOffer.php#?
    App\Models\VanLeaseClick
    4VanLeaseClick.php#?
    App\Models\VanCusCar
    3VanCusCar.php#?
        _token
        OtHiTNqUMi4TPqpz6nADVbPJUt8yHgFXLuuXfkDS
        views
        3
        uid
        ae54143682366b9bc090a2f23c28ee06
        last_results_page
        /business-car-leasing/ds/ds-3/1.2-puretech-130-performance-line-5dr-eat8_82133?fDerivative=1.2%20Pur...
        _previous
        array:1 [ "url" => "https://laravel.cars2buy.co.uk/van-leasing/renault/trafic-swb/trafic-swb-diese...
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /van-leasing/renault/trafic-swb/trafic-swb-diesel-sl30-blue-dci-150-extra-sport-safety-van_50008
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        0 of 0
        array:3 [ "fCarID" => "50008" "fDerivative" => "Trafic Swb Diesel Sl30 Blue Dci 150 Extra Sport Safety Van" "page" => "7" ]
        request_request
        []
        
        request_headers
        0 of 0
        array:19 [ "cookie" => array:1 [ 0 => "uid=eyJpdiI6IlFiVFpRcld2LzRnbVlsZGdBYjdWQnc9PSIsInZhbHVlIjoiWElOY3YxbnRsaVBTbFNvdWhzdlE5WkRBR2s3dHBsbndFc1djd0VRa0R1OHc2cC9GSlNhaDdGVk9ISExEcU5oRGlrQ1dXLy9DVDNTbnJQZ3RPajVuQXUzcURmaXRBaWFLVXcyV292Y2RJWWc9IiwibWFjIjoiYTJlODRhYzc5NDllZjRlY2RmMzc2YjlkNmI4ZTIxZTY5ODI2Yzg5ZDA1MjQwMzU0NmU2YmEzNGEzMDFkNTI1NSIsInRhZyI6IiJ9; XSRF-TOKEN=eyJpdiI6ImpJZXJ3T1hxYk9ucGw2RUtMcDRoTnc9PSIsInZhbHVlIjoiUmYraWhNYWpBcUVKd2luMzAwYkVoWXplcFhrVXNrMWVFWVN1Rk1QUVlKVlVtVEQ3Ykd0NzlqS1BQQm9EMEFOaUFKajlVdEE3eDBaN3lHRlpwbW9LbnBUVjllRkFUdHFWT1cyZlQzU2tLbk1rU2dZQllGTTNEYXhuOTJwaXJaRDMiLCJtYWMiOiIyODI0NDZjOGRhZjZjZDIxNmQ5NDNkZDVkMzVmMjI0NTJkY2M4ZGE4YzA0OTg2YjM1YjFlODJjODViY2EzYTM0IiwidGFnIjoiIn0%3D; laravel_session=eyJpdiI6IjAyQlNTWHJMSVMyYUJlb0lLK0pPdkE9PSIsInZhbHVlIjoiMmx6N0xLSGhmL2gvY0F0N1h2eEJKNjEzdElEcWFrT3M1NWdublBNUGkzOW93aUJUbjMvaTRZU3FnZURjenZnTXFzTGZtMU9xc3pmTWc5VVUwdk1mUVYyTkRNMXhRMDdoUVdOWjdZZCtFNEFoL3IvRU1sTGZiSVFxS2I1MWpKdmciLCJtYWMiOiJjNTEyZWJlMDMyMzRkNzk5YjNlNzYzYzU1NjQ0MjNjMGE3ZjdiOWI2MGIzY2E5YzZmOTMwNzM3NWRjNTM4OTczIiwidGFnIjoiIn0%3D; _pbjs_userid_consent_data=3524755945110770; _pubcid=5f0050c9-7484-4021-b3da-db8740326cd1uid=eyJpdiI6IlFiVFpRcld2LzRnbVlsZGdBYjdWQnc9PSIsInZhbHVlIjoiWElOY3YxbnRsaVBTbFNvdWhzdlE5WkRBR2s3dHBsbndFc1djd0VRa0R1OHc2cC9GSlNhaDdGVk9ISExEcU5oRGlrQ1dXLy9DVDNT" ] "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.147.42.23" ] "host" => array:1 [ 0 => "laravel.cars2buy.co.uk" ] ]
        request_cookies
        0 of 0
        array:5 [ "uid" => "ae54143682366b9bc090a2f23c28ee06" "XSRF-TOKEN" => "OtHiTNqUMi4TPqpz6nADVbPJUt8yHgFXLuuXfkDS" "laravel_session" => "DH8bThrsQsEM6CiTXhzbYP7kjZXeV2MNw0dLn2XJ" "_pbjs_userid_consent_data" => null "_pubcid" => null ]
        response_headers
        0 of 0
        array:7 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "private, must-revalidate" ] "date" => array:1 [ 0 => "Sun, 02 Feb 2025 22:29:29 GMT" ] "pragma" => array:1 [ 0 => "no-cache" ] "expires" => array:1 [ 0 => "-1" ] "set-cookie" => array:3 [ 0 => "uid=eyJpdiI6IlVwaXpWZVNUNGFzODZMQ2ZscnR0aXc9PSIsInZhbHVlIjoicWRVTmZXY1pCd0d4TytsYktDT0ovUXZsYktheVAxcTQ2c2lpRERQUmJqR0hpa0dObVJESFFaNnpKYXZYK3ppTzNESnBDNHlJOWFjdzZFUlRZTlp4TnFhSFh5aW85TUdsTG5IZ2MvU3laYm89IiwibWFjIjoiZTQyZWQ5YzZhNGNmOGRiZWJiN2FiYWM5ZWU2N2JjNzMzZjBmZTQ2MjcxZGJiMGNjMWUxMmNjNWFlMjdmMWM0ZiIsInRhZyI6IiJ9; expires=Fri, 07 Mar 5360 03:58:29 GMT; Max-Age=105245242140; path=/; secure; httponly; samesite=laxuid=eyJpdiI6IlVwaXpWZVNUNGFzODZMQ2ZscnR0aXc9PSIsInZhbHVlIjoicWRVTmZXY1pCd0d4TytsYktDT0ovUXZsYktheVAxcTQ2c2lpRERQUmJqR0hpa0dObVJESFFaNnpKYXZYK3ppTzNESnBDNHlJOWFj" 1 => "XSRF-TOKEN=eyJpdiI6Ik9pN05TMy9QYVBEaWFrNXJYVWdZZUE9PSIsInZhbHVlIjoiZEtnd3VtNzJJQkpLQmY2cEVEVCtRWDcyV0t5NHNneEhTSHFnc1NsOW96ZmpjK2xSUkkrdlRDUXJyNkNrOXhUK0x5TE1xQzBTMzdIRWh5blhSekJvZDlicWR3YWpWVXBEKzFMVDNJK0hZNEtIdHpJOW1IcU5VYzN6M2hmV0NoNGMiLCJtYWMiOiI1OTM1YjVjOWIyOGRlNTBiN2I3NTJiMGZkODgyNTU3YTA1OWJiZTY2N2RhNzhiM2Y5YzMwYjZkMjQyOTMxNDA0IiwidGFnIjoiIn0%3D; expires=Mon, 03 Feb 2025 00:29:29 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6Ik9pN05TMy9QYVBEaWFrNXJYVWdZZUE9PSIsInZhbHVlIjoiZEtnd3VtNzJJQkpLQmY2cEVEVCtRWDcyV0t5NHNneEhTSHFnc1NsOW96ZmpjK2xSUkkrdlRDUXJyNkNrOXhUK0x5TE1xQ" 2 => "laravel_session=eyJpdiI6IkxSaHNBakJRRXk4L292SWgzZW4wUFE9PSIsInZhbHVlIjoicFJLaUJ6Y0RyazQxL3cwWko5S3lNY0xiOUczYVc1RmFvZzFxdGVNWWEydjBVV3Ezc3lWQUY2YUtHVXN1eHdpSC9CQU9PYmNmUnR3Z0hqRUVoTDZacEhNUnZHSEVHUzFsbkZaeGJnSjNpcE9wNVZTaHg5OWhRM0g2VS9EM0NQWXkiLCJtYWMiOiI1ODQ4OTJlY2Q4NWFjNTI2ODFhMWM5YTk5YTBkYWUwZjljMjcwZmUyZGEwZDMyNjU2MjA4MmJiZDY3NjhiMzhkIiwidGFnIjoiIn0%3D; expires=Mon, 03 Feb 2025 00:29:29 GMT; Max-Age=7200; path=/; httponly; samesite=laxlaravel_session=eyJpdiI6IkxSaHNBakJRRXk4L292SWgzZW4wUFE9PSIsInZhbHVlIjoicFJLaUJ6Y0RyazQxL3cwWko5S3lNY0xiOUczYVc1RmFvZzFxdGVNWWEydjBVV3Ezc3lWQUY2YUtHVXN1eHdpSC9C" ] "Set-Cookie" => array:3 [ 0 => "uid=eyJpdiI6IlVwaXpWZVNUNGFzODZMQ2ZscnR0aXc9PSIsInZhbHVlIjoicWRVTmZXY1pCd0d4TytsYktDT0ovUXZsYktheVAxcTQ2c2lpRERQUmJqR0hpa0dObVJESFFaNnpKYXZYK3ppTzNESnBDNHlJOWFjdzZFUlRZTlp4TnFhSFh5aW85TUdsTG5IZ2MvU3laYm89IiwibWFjIjoiZTQyZWQ5YzZhNGNmOGRiZWJiN2FiYWM5ZWU2N2JjNzMzZjBmZTQ2MjcxZGJiMGNjMWUxMmNjNWFlMjdmMWM0ZiIsInRhZyI6IiJ9; expires=Fri, 07-Mar-5360 03:58:29 GMT; path=/; secure; httponlyuid=eyJpdiI6IlVwaXpWZVNUNGFzODZMQ2ZscnR0aXc9PSIsInZhbHVlIjoicWRVTmZXY1pCd0d4TytsYktDT0ovUXZsYktheVAxcTQ2c2lpRERQUmJqR0hpa0dObVJESFFaNnpKYXZYK3ppTzNESnBDNHlJOWFj" 1 => "XSRF-TOKEN=eyJpdiI6Ik9pN05TMy9QYVBEaWFrNXJYVWdZZUE9PSIsInZhbHVlIjoiZEtnd3VtNzJJQkpLQmY2cEVEVCtRWDcyV0t5NHNneEhTSHFnc1NsOW96ZmpjK2xSUkkrdlRDUXJyNkNrOXhUK0x5TE1xQzBTMzdIRWh5blhSekJvZDlicWR3YWpWVXBEKzFMVDNJK0hZNEtIdHpJOW1IcU5VYzN6M2hmV0NoNGMiLCJtYWMiOiI1OTM1YjVjOWIyOGRlNTBiN2I3NTJiMGZkODgyNTU3YTA1OWJiZTY2N2RhNzhiM2Y5YzMwYjZkMjQyOTMxNDA0IiwidGFnIjoiIn0%3D; expires=Mon, 03-Feb-2025 00:29:29 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6Ik9pN05TMy9QYVBEaWFrNXJYVWdZZUE9PSIsInZhbHVlIjoiZEtnd3VtNzJJQkpLQmY2cEVEVCtRWDcyV0t5NHNneEhTSHFnc1NsOW96ZmpjK2xSUkkrdlRDUXJyNkNrOXhUK0x5TE1xQ" 2 => "laravel_session=eyJpdiI6IkxSaHNBakJRRXk4L292SWgzZW4wUFE9PSIsInZhbHVlIjoicFJLaUJ6Y0RyazQxL3cwWko5S3lNY0xiOUczYVc1RmFvZzFxdGVNWWEydjBVV3Ezc3lWQUY2YUtHVXN1eHdpSC9CQU9PYmNmUnR3Z0hqRUVoTDZacEhNUnZHSEVHUzFsbkZaeGJnSjNpcE9wNVZTaHg5OWhRM0g2VS9EM0NQWXkiLCJtYWMiOiI1ODQ4OTJlY2Q4NWFjNTI2ODFhMWM5YTk5YTBkYWUwZjljMjcwZmUyZGEwZDMyNjU2MjA4MmJiZDY3NjhiMzhkIiwidGFnIjoiIn0%3D; expires=Mon, 03-Feb-2025 00:29:29 GMT; path=/; httponlylaravel_session=eyJpdiI6IkxSaHNBakJRRXk4L292SWgzZW4wUFE9PSIsInZhbHVlIjoicFJLaUJ6Y0RyazQxL3cwWko5S3lNY0xiOUczYVc1RmFvZzFxdGVNWWEydjBVV3Ezc3lWQUY2YUtHVXN1eHdpSC9C" ] ]
        session_attributes
        0 of 0
        array:7 [ "_token" => "OtHiTNqUMi4TPqpz6nADVbPJUt8yHgFXLuuXfkDS" "views" => 3 "uid" => "ae54143682366b9bc090a2f23c28ee06" "last_results_page" => "/business-car-leasing/ds/ds-3/1.2-puretech-130-performance-line-5dr-eat8_82133?fDerivative=1.2%20Puretech%20130%20Performance%20Line%205dr%20Eat8&page=3" "_previous" => array:1 [ "url" => "https://laravel.cars2buy.co.uk/van-leasing/renault/trafic-swb/trafic-swb-diesel-sl30-blue-dci-150-extra-sport-safety-van_50008?fCarID=50008&fDerivative=Trafic%20Swb%20Diesel%20Sl30%20Blue%20Dci%20150%20Extra%20Sport%20Safety%20Van&page=7https://laravel.cars2buy.co.uk/van-leasing/renault/trafic-swb/trafic-swb-diesel-sl30-blue-dci-150-extra-sport-safety-van_50008?fCarID=50008&fDerivative=Trafic%2" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-02 22:29:29GET/van-leasing/renault/trafic-swb/trafic-swb-diesel-sl30-blue-dci-150-extra-sport-safety-van_50008?fCarID=50008&fDerivative=Trafic+Swb+Diesel+Sl30+Blue+Dci+150+Extra+Sport+Safety+Van&page=76142271