Renault Trafic SWB Diesel Leasing Deals:

RENAULT TRAFIC SWB

Page 1 of 407 pages

Prev Next

Filter your results:

Lease details:

Van details:

Renault Trafic SWB variants:

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

Filter your results:

Lease details:

Van details:

Request history8.2.27PHP Version310msRequest Duration2MBMemory UsageGET van-leasing/{manufacturer}/{model}/{variant}Route
  • warninglog[04:00:41] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[04:00:41] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[04:00:41] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[04:00:41] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[04:00:41] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[04:00:41] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • Booting (36.99ms)time
  • Application (273ms)time
  • 1 x Application (88.05%)
    273ms
    1 x Booting (11.95%)
    36.99ms
    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}/{variant}
    middleware
    web
    controller
    App\Http\Controllers\VanLeasingController@results
    namespace
    where
    as
    van-leasing-results-variant
    file
    app/Http/Controllers/VanLeasingController.php:109-190
    21 statements were executed110ms
    • 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 `model_long_slug` = 'trafic-swb-diesel') limit 1
      2.11msvandirectController.php#385
      Bindings
      • 0: renault
      • 1: trafic-swb
      • 2: trafic-swb-diesel
      Backtrace
      • 15. app/Http/Controllers/Controller.php:385
      • 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 `model_long_slug` = 'trafic-swb-diesel'
      8.5msvandirectVanLeasingSearch.php#45
      Bindings
      • 0: renault
      • 1: trafic-swb
      • 2: 1
      • 3: 1
      • 4: 1
      • 5: 0
      • 6: trafic-swb-diesel
      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 `model_long_slug` = 'trafic-swb-diesel' order by price_monthly limit 10 offset 0
      14.86msvandirectVanLeasingSearch.php#45
      Bindings
      • 0: renault
      • 1: trafic-swb
      • 2: 1
      • 3: 1
      • 4: 1
      • 5: 0
      • 6: trafic-swb-diesel
      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
      1.49msbrampacImagesRepository.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-01' and `stamp` >= '2025-01-22' and `ipuser` != '' and `make_rule` = 0 and `robot_rule` = 0) group by `ipuser`
      5.89msvandirectVanLeaseClickRepository.php#105
      Bindings
      • 0: RENAULT
      • 1: TRAFIC SWB
      • 2: 2025-02-01
      • 3: 2025-01-22
      • 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', '0bb771df18ea5c99642d6a4acd82cd88', '0d1abd1acc36b7491901203f55bd8808', '141acf4965b634451192986c7fa57644', '3caf128d3dcb3e1686754688f8500cda', '5dfcc72e09dec9435555aa86c0efdaab', 'aba51b72d93decb85a074cf1a1a524bf', 'aba9af06337d2c12cfa434ae5ecf8c36', 'afea240ca0ab569e74d13b8e952f1d05', 'c0f5dc99af69d36dc0eab08e7979b840', 'e5529d49086ebac0ae09ec830dd72f0d', 'fb1d3ba221d8a0275b1758f9d18af2c1') and (`make` != 'RENAULT' and `model` != 'TRAFIC SWB' and `stamp` < '2025-02-01' and `stamp` >= '2025-01-22' and `make_rule` = 0 and `robot_rule` = 0) group by `model`, `make` order by `count` desc limit 5
      6.06msvandirectVanLeaseClickRepository.php#77
      Bindings
      • 0: 04c9fdda7d48f76a2195c5fff89e50d0
      • 1: 0bb771df18ea5c99642d6a4acd82cd88
      • 2: 0d1abd1acc36b7491901203f55bd8808
      • 3: 141acf4965b634451192986c7fa57644
      • 4: 3caf128d3dcb3e1686754688f8500cda
      • 5: 5dfcc72e09dec9435555aa86c0efdaab
      • 6: aba51b72d93decb85a074cf1a1a524bf
      • 7: aba9af06337d2c12cfa434ae5ecf8c36
      • 8: afea240ca0ab569e74d13b8e952f1d05
      • 9: c0f5dc99af69d36dc0eab08e7979b840
      • 10: e5529d49086ebac0ae09ec830dd72f0d
      • 11: fb1d3ba221d8a0275b1758f9d18af2c1
      • 12: RENAULT
      • 13: TRAFIC SWB
      • 14: 2025-02-01
      • 15: 2025-01-22
      • 16: 0
      • 17: 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` = 'TRAFIC SWB DIESEL') order by `derivative` asc
      700μsvandirectVanModel.php#163
      Bindings
      • 0: renault
      • 1: trafic-swb
      • 2: TRAFIC SWB DIESEL
      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` = 'renault' and `model_slug` = 'trafic-swb') and `model_long_slug` = 'trafic-swb-diesel' limit 1
      8.15msvandirectVanLeasingSearch.php#234
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: 0
      • 4: renault
      • 5: trafic-swb
      • 6: trafic-swb-diesel
      Backtrace
      • 16. app/Queries/VanLeasingSearch.php:234
      • 17. app/Http/Controllers/VanLeasingController.php:151
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select distinct `make`, `make_slug` from `vans` order by `make` asc
      170μsvandirectVanManufacturer.php#16
      Backtrace
      • 15. app/Queries/VanManufacturer.php:16
      • 16. app/Http/Controllers/VanLeasingController.php:168
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select distinct `model`, `model_slug`, `make` from `vans` where `make_slug` = 'renault' order by `model` asc
      830μ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 `model_long_slug` = 'trafic-swb-diesel' order by `price_monthly` asc limit 1
      7.93msvandirectVanLeasingSearch.php#102
      Bindings
      • 0: renault
      • 1: trafic-swb
      • 2: 160
      • 3: 1
      • 4: 1
      • 5: 1
      • 6: 0
      • 7: trafic-swb-diesel
      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
      910μ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 `model_long_slug` = 'trafic-swb-diesel' order by `derivative` asc
      950μsvandirectVanLeaseFilter.php#69
      Bindings
      • 0: renault
      • 1: trafic-swb
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: trafic-swb-diesel
      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 `model_long_slug` = 'trafic-swb-diesel' order by `fuel` asc
      990μsvandirectVanLeaseFilter.php#99
      Bindings
      • 0: renault
      • 1: trafic-swb
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: trafic-swb-diesel
      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 `model_long_slug` = 'trafic-swb-diesel' order by `transmission` asc
      960μsvandirectVanLeaseFilter.php#114
      Bindings
      • 0: renault
      • 1: trafic-swb
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: trafic-swb-diesel
      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 `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 `model_long_slug` = 'trafic-swb-diesel' and `term` in (6, 12, 18, 24, 36, 48, 60) order by `term` asc
      9.55msvandirectVanLeaseFilter.php#138
      Bindings
      • 0: renault
      • 1: trafic-swb
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: trafic-swb-diesel
      • 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 `model_long_slug` = 'trafic-swb-diesel' 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
      13.75msvandirectVanLeaseFilter.php#153
      Bindings
      • 0: renault
      • 1: trafic-swb
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: trafic-swb-diesel
      • 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 `model_long_slug` = 'trafic-swb-diesel' 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
      11.72msvandirectVanLeaseFilter.php#169
      Bindings
      • 0: renault
      • 1: trafic-swb
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: trafic-swb-diesel
      • 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 `model_long_slug` = 'trafic-swb-diesel' 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
      12.69msvandirectVanLeaseFilter.php#193
      Bindings
      • 0: renault
      • 1: trafic-swb
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: trafic-swb-diesel
      • 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
      570μ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 `model_long_slug` = 'trafic-swb-diesel' order by `otrprice` asc limit 2
      1.62msvandirectNewVanSearch.php#276
      Bindings
      • 0: renault
      • 1: trafic-swb
      • 2: 1
      • 3: 1
      • 4: 4000
      • 5: 0
      • 6: 1
      • 7: trafic-swb-diesel
      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
    45Van.php#?
    App\Models\VanLeaseOffer
    40VanLeaseOffer.php#?
    App\Models\VanLeaseClick
    12VanLeaseClick.php#?
    App\Models\VanCusCar
    3VanCusCar.php#?
        _token
        xfC6xEysSNIAtQ5Vitmw89accLN3uu0c4ojzUD7i
        views
        2
        uid
        66b3929cedf7fe7c855b427e2e1ebffc
        last_results_page
        /business-car-leasing/bmw/x1/sdrive-18d-sport-5dr-step-auto_82380
        _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/
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        0 of 0
        array:2 [ "page" => "426fVariant=trafic-swb-diesel" "fVariant" => "trafic-swb-diesel" ]
        request_request
        []
        
        request_headers
        0 of 0
        array:19 [ "cookie" => array:1 [ 0 => "uid=eyJpdiI6InNBZU83Q0RTRWtKeEtEZ2hYdUpZY1E9PSIsInZhbHVlIjoiRXdkM0NnUVc1MFR3cGVyUElHUWdPcko1ZUE3WjZVOUozSHdqakx0SVVhODkrWEhjTGptY09DZmNjR2crbzBPRTd2VnN1RkgvQllwME5RK2RmZE95eWFQSVVHRVZrMnRlVUFMWkF3c0FnVkU9IiwibWFjIjoiMDNhZDc4NDJiYjEzZGVkMDMzNmFiMjdjMmNhMGM4YjYzNTU2NzA0ZjFjZDk1MWRmMzc4MTNjNGRhY2Q4Y2E5MyIsInRhZyI6IiJ9; XSRF-TOKEN=eyJpdiI6IjcvblhJMUwzTjduS0Izbk9PKzRZTFE9PSIsInZhbHVlIjoibFVCNWFHQTgxOURCR3VNOXJFcVNCWDVlRU83c3dCaE52NWJ6SkFjaUVBV2FzNk1ndkRaMWNVMVdnV1h1K01QYzJYVEx0N2tlSFhHbzR0MVhrYThhQzJibVdwRzhlcFpSc3MvRXY5YUF4MmJwaUZoL0txQk5JdElidG9mYk5LaFIiLCJtYWMiOiI4Yjk4NTYyMzAyNmFjOGE1ZTIzNDYxZGRjZDA3ODQzZmM5NDQyYWZjMTgxM2MxYTcyYzBmODhmYjc1MTg5NjFhIiwidGFnIjoiIn0%3D; laravel_session=eyJpdiI6ImxBcndIYTRUbWc1NzA3NWxMOW16Wnc9PSIsInZhbHVlIjoiQk1taG43bVVuMXU2cUVLODJ5Rkp0WjREVXVxOEc5c1BmSFp5OHNJcFRGb21oKzBJdDRMQ1pwZi9IeTdTN3BwQi8zTHlhcDg4eER4U2hQWm51eXpTZWRIWGV3b1VOZGo5NXdVcmluWSs4cE5FM0E5RWFGM2ZXMkVTVnBhb2tRZWoiLCJtYWMiOiJhMGU4MGZlNWE5ZDI3OGQ2NDhlMGYxZjYzYjZmYzFmMTYxM2MwMGIzYmFjMGEzMTA1MjI2YzBiOTdhYjNhYWY4IiwidGFnIjoiIn0%3Duid=eyJpdiI6InNBZU83Q0RTRWtKeEtEZ2hYdUpZY1E9PSIsInZhbHVlIjoiRXdkM0NnUVc1MFR3cGVyUElHUWdPcko1ZUE3WjZVOUozSHdqakx0SVVhODkrWEhjTGptY09DZmNjR2crbzBPRTd2VnN1RkgvQllw" ] "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.137.149.184" ] "host" => array:1 [ 0 => "laravel.cars2buy.co.uk" ] ]
        request_cookies
        0 of 0
        array:3 [ "uid" => "66b3929cedf7fe7c855b427e2e1ebffc" "XSRF-TOKEN" => "xfC6xEysSNIAtQ5Vitmw89accLN3uu0c4ojzUD7i" "laravel_session" => "nZpMBrReSRvJXKCQD9T9QiRgbp3CC0FGKxntpte4" ]
        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, 01 Feb 2025 04:00:41 GMT" ] "pragma" => array:1 [ 0 => "no-cache" ] "expires" => array:1 [ 0 => "-1" ] "set-cookie" => array:3 [ 0 => "uid=eyJpdiI6Ii9BS1BGL01pVGR0TWxWYVVjNGM5SlE9PSIsInZhbHVlIjoia1FmTUVYdFh6NFBlcDVTbzkwZFJZazNpbWx4WFpmYUo1ZWRMSVh1MHRXUGlCS0VXV2k1OUx1RjAwRER4NS9qYWhsbXZHKzJ3aEVHVWhEOXVudkt4M3pCazBQUmRyN0M2UW1SU0tIdVBmcm89IiwibWFjIjoiYWY3MWY2YTdlY2Y4YzEwZDlhMmNkY2M0YzA1ZjAzYTcyNzUxYTA5MDFkMjAwYzZjNDEyYmRiMjg0MGVmMmY3ZSIsInRhZyI6IiJ9; expires=Tue, 20 Nov 5359 04:41:41 GMT; Max-Age=105236066460; path=/; secure; httponly; samesite=laxuid=eyJpdiI6Ii9BS1BGL01pVGR0TWxWYVVjNGM5SlE9PSIsInZhbHVlIjoia1FmTUVYdFh6NFBlcDVTbzkwZFJZazNpbWx4WFpmYUo1ZWRMSVh1MHRXUGlCS0VXV2k1OUx1RjAwRER4NS9qYWhsbXZHKzJ3aEVH" 1 => "XSRF-TOKEN=eyJpdiI6IlVsU1JBM21IcnpzdVZNMy94V1N3OUE9PSIsInZhbHVlIjoiN2p0K2xZeE5SbE5QcEQ2bmN6NVB0U212OUtYT0lLTkdxcTBINXJlRHVQWVVyV1crK3FxcmVreXpNc1pTd1ZjTXdqRXBoNGxLaXB0MEtSQWlpdHk1NDdoY2krM2t0N3pTVmFMR1dIcTNoM1FpeHg0RDExMlcwR3djVGFUbU1vWEMiLCJtYWMiOiJlYTg4MGM2MDNmYTEyOGEyMTQzMmRhYmQ3NDlhZDM4ZTk2Y2I1MTc4OTBhYzRlNzFkYTFkMWEyOTJiODA0Mzk2IiwidGFnIjoiIn0%3D; expires=Sat, 01 Feb 2025 06:00:41 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IlVsU1JBM21IcnpzdVZNMy94V1N3OUE9PSIsInZhbHVlIjoiN2p0K2xZeE5SbE5QcEQ2bmN6NVB0U212OUtYT0lLTkdxcTBINXJlRHVQWVVyV1crK3FxcmVreXpNc1pTd1ZjTXdqRXBoN" 2 => "laravel_session=eyJpdiI6InNOVFl2bGVwOTZjVnZwZEF4bXlUZVE9PSIsInZhbHVlIjoiUXpEenU5Q2lSdC9JcFMxOUM4SEJkZXhQVS8wcFhnTkdWb1lpZGZyNHYzNm5XU0lQUXFEV0NzbUx3UEtXRmNsMlZINjFBUk16eDJRNFZVRlROWXBaUGMxN05SOEZZbnZENTQvcUZxbDFiVlloelNEelErWC9odlhOTlAwalZTZ0siLCJtYWMiOiIyZGE2NjJlZDYxOWYzNmVmNTM4NDU3ODhkNDA4MjAwMWEzZjc1ZGE0MGE1YjEzOWIyYjYzMmNmOWExYzMxZGRhIiwidGFnIjoiIn0%3D; expires=Sat, 01 Feb 2025 06:00:41 GMT; Max-Age=7200; path=/; httponly; samesite=laxlaravel_session=eyJpdiI6InNOVFl2bGVwOTZjVnZwZEF4bXlUZVE9PSIsInZhbHVlIjoiUXpEenU5Q2lSdC9JcFMxOUM4SEJkZXhQVS8wcFhnTkdWb1lpZGZyNHYzNm5XU0lQUXFEV0NzbUx3UEtXRmNsMlZI" ] "Set-Cookie" => array:3 [ 0 => "uid=eyJpdiI6Ii9BS1BGL01pVGR0TWxWYVVjNGM5SlE9PSIsInZhbHVlIjoia1FmTUVYdFh6NFBlcDVTbzkwZFJZazNpbWx4WFpmYUo1ZWRMSVh1MHRXUGlCS0VXV2k1OUx1RjAwRER4NS9qYWhsbXZHKzJ3aEVHVWhEOXVudkt4M3pCazBQUmRyN0M2UW1SU0tIdVBmcm89IiwibWFjIjoiYWY3MWY2YTdlY2Y4YzEwZDlhMmNkY2M0YzA1ZjAzYTcyNzUxYTA5MDFkMjAwYzZjNDEyYmRiMjg0MGVmMmY3ZSIsInRhZyI6IiJ9; expires=Tue, 20-Nov-5359 04:41:41 GMT; path=/; secure; httponlyuid=eyJpdiI6Ii9BS1BGL01pVGR0TWxWYVVjNGM5SlE9PSIsInZhbHVlIjoia1FmTUVYdFh6NFBlcDVTbzkwZFJZazNpbWx4WFpmYUo1ZWRMSVh1MHRXUGlCS0VXV2k1OUx1RjAwRER4NS9qYWhsbXZHKzJ3aEVH" 1 => "XSRF-TOKEN=eyJpdiI6IlVsU1JBM21IcnpzdVZNMy94V1N3OUE9PSIsInZhbHVlIjoiN2p0K2xZeE5SbE5QcEQ2bmN6NVB0U212OUtYT0lLTkdxcTBINXJlRHVQWVVyV1crK3FxcmVreXpNc1pTd1ZjTXdqRXBoNGxLaXB0MEtSQWlpdHk1NDdoY2krM2t0N3pTVmFMR1dIcTNoM1FpeHg0RDExMlcwR3djVGFUbU1vWEMiLCJtYWMiOiJlYTg4MGM2MDNmYTEyOGEyMTQzMmRhYmQ3NDlhZDM4ZTk2Y2I1MTc4OTBhYzRlNzFkYTFkMWEyOTJiODA0Mzk2IiwidGFnIjoiIn0%3D; expires=Sat, 01-Feb-2025 06:00:41 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IlVsU1JBM21IcnpzdVZNMy94V1N3OUE9PSIsInZhbHVlIjoiN2p0K2xZeE5SbE5QcEQ2bmN6NVB0U212OUtYT0lLTkdxcTBINXJlRHVQWVVyV1crK3FxcmVreXpNc1pTd1ZjTXdqRXBoN" 2 => "laravel_session=eyJpdiI6InNOVFl2bGVwOTZjVnZwZEF4bXlUZVE9PSIsInZhbHVlIjoiUXpEenU5Q2lSdC9JcFMxOUM4SEJkZXhQVS8wcFhnTkdWb1lpZGZyNHYzNm5XU0lQUXFEV0NzbUx3UEtXRmNsMlZINjFBUk16eDJRNFZVRlROWXBaUGMxN05SOEZZbnZENTQvcUZxbDFiVlloelNEelErWC9odlhOTlAwalZTZ0siLCJtYWMiOiIyZGE2NjJlZDYxOWYzNmVmNTM4NDU3ODhkNDA4MjAwMWEzZjc1ZGE0MGE1YjEzOWIyYjYzMmNmOWExYzMxZGRhIiwidGFnIjoiIn0%3D; expires=Sat, 01-Feb-2025 06:00:41 GMT; path=/; httponlylaravel_session=eyJpdiI6InNOVFl2bGVwOTZjVnZwZEF4bXlUZVE9PSIsInZhbHVlIjoiUXpEenU5Q2lSdC9JcFMxOUM4SEJkZXhQVS8wcFhnTkdWb1lpZGZyNHYzNm5XU0lQUXFEV0NzbUx3UEtXRmNsMlZI" ] ]
        session_attributes
        0 of 0
        array:7 [ "_token" => "xfC6xEysSNIAtQ5Vitmw89accLN3uu0c4ojzUD7i" "views" => 2 "uid" => "66b3929cedf7fe7c855b427e2e1ebffc" "last_results_page" => "/business-car-leasing/bmw/x1/sdrive-18d-sport-5dr-step-auto_82380" "_previous" => array:1 [ "url" => "https://laravel.cars2buy.co.uk/van-leasing/renault/trafic-swb/trafic-swb-diesel?page=426fVariant%3Dtrafic-swb-diesel" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-01 04:00:41GET/van-leasing/renault/trafic-swb/trafic-swb-diesel/?page=426fVariant%3Dtrafic-swb-diesel61421100