Citroen Relay 35 Heavy L4 Diesel Leasing Deals:

CITROEN RELAY HEAVY L4

Page 22 of 68 pages

People who viewed Citroen Relay Heavy L4 deals also viewed:

Citroen Relay Heavy L4 variants:

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

Filter your results:

Lease details:

Van details:

Request history8.2.27PHP Version318msRequest Duration2MBMemory UsageGET van-leasing/{manufacturer}/{model}/{variant}Route
  • warninglog[06:26:19] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[06:26:19] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[06:26:19] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[06:26:19] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[06:26:19] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[06:26:19] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • Booting (37.72ms)time
  • Application (280ms)time
  • 1 x Application (88.12%)
    280ms
    1 x Booting (11.88%)
    37.72ms
    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
    25 statements were executed105ms
    • 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` = 'citroen' and `model_slug` = 'relay-heavy-l4' and `model_long_slug` = 'relay-35-heavy-l4-diesel') limit 1
      900μsvandirectController.php#385
      Bindings
      • 0: citroen
      • 1: relay-heavy-l4
      • 2: relay-35-heavy-l4-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` = 'citroen' and `model_slug` = 'relay-heavy-l4' and `live` = 1 and `capid` > 1 and `lease_live` = 1 and `price_monthly` > 0) and `model_long_slug` = 'relay-35-heavy-l4-diesel'
      5.92msvandirectVanLeasingSearch.php#45
      Bindings
      • 0: citroen
      • 1: relay-heavy-l4
      • 2: 1
      • 3: 1
      • 4: 1
      • 5: 0
      • 6: relay-35-heavy-l4-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` = 'citroen' and `model_slug` = 'relay-heavy-l4' and `live` = 1 and `capid` > 1 and `lease_live` = 1 and `price_monthly` > 0) and `model_long_slug` = 'relay-35-heavy-l4-diesel' order by price_monthly limit 10 offset 210
      7.17msvandirectVanLeasingSearch.php#45
      Bindings
      • 0: citroen
      • 1: relay-heavy-l4
      • 2: 1
      • 3: 1
      • 4: 1
      • 5: 0
      • 6: relay-35-heavy-l4-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` = 'CITROEN' and `vandirect`.`vans`.`model` = 'RELAY HEAVY L4' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'LCV' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
      750μsbrampacImagesRepository.php#66
      Bindings
      • 0: CITROEN
      • 1: RELAY HEAVY L4
      • 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` = 'CITROEN' and `model` = 'RELAY HEAVY L4' and `stamp` <= '2025-01-21' and `stamp` >= '2025-01-11' and `ipuser` != '' and `make_rule` = 0 and `robot_rule` = 0) group by `ipuser`
      24.14msvandirectVanLeaseClickRepository.php#105
      Bindings
      • 0: CITROEN
      • 1: RELAY HEAVY L4
      • 2: 2025-01-21
      • 3: 2025-01-11
      • 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 ('3b34c587a9f088ff166aed40cd860b2a', '3c9804025e0fdfb89f5bb048b39eab8b', '3face1d3fa7268a8a64a902edbcef6cc', '584911a52be0bfa928f4d8ffe78c7454', '61c4b8aaddaa9ef84d162845070ec83e', '68635540f57aaa4cad97e6ae3965bea8', '7032a7bb0892ef73a94280c09226049f', '7062a20de082335adaa04112ca3367dc', '9ccf3f92bca9a83fe0d13688931aee17', 'd3d7dfab8891c9200531a9559ef83426', 'd4301b75c0eb3fb0c9719a96c41e81dd') and (`make` != 'CITROEN' and `model` != 'RELAY HEAVY L4' and `stamp` < '2025-01-21' and `stamp` >= '2025-01-11' and `make_rule` = 0 and `robot_rule` = 0) group by `model`, `make` order by `count` desc limit 5
      24.91msvandirectVanLeaseClickRepository.php#77
      Bindings
      • 0: 3b34c587a9f088ff166aed40cd860b2a
      • 1: 3c9804025e0fdfb89f5bb048b39eab8b
      • 2: 3face1d3fa7268a8a64a902edbcef6cc
      • 3: 584911a52be0bfa928f4d8ffe78c7454
      • 4: 61c4b8aaddaa9ef84d162845070ec83e
      • 5: 68635540f57aaa4cad97e6ae3965bea8
      • 6: 7032a7bb0892ef73a94280c09226049f
      • 7: 7062a20de082335adaa04112ca3367dc
      • 8: 9ccf3f92bca9a83fe0d13688931aee17
      • 9: d3d7dfab8891c9200531a9559ef83426
      • 10: d4301b75c0eb3fb0c9719a96c41e81dd
      • 11: CITROEN
      • 12: RELAY HEAVY L4
      • 13: 2025-01-21
      • 14: 2025-01-11
      • 15: 0
      • 16: 0
      Backtrace
      • 15. app/Queries/VanLeaseClickRepository.php:77
      • 16. app/Http/Controllers/VanLeasingController.php:136
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select `path`, `izmoAlias` from `images_izmo` inner join `vandirect`.`vans` on `images_izmo`.`cap_id` = `vandirect`.`vans`.`capid` where `vandirect`.`vans`.`make` = 'TOYOTA' and `vandirect`.`vans`.`model` = 'PROACE CITY L1' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'LCV' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
      510μsbrampacImagesRepository.php#66
      Bindings
      • 0: TOYOTA
      • 1: PROACE CITY L1
      • 2: 
      • 3: 
      • 4: LCV
      Backtrace
      • 14. app/Queries/ImagesRepository.php:66
      • 15. app/Traits/VehicleImage.php:112
      • 16. app/Queries/VanLeaseClickRepository.php:84
      • 17. app/Http/Controllers/VanLeasingController.php:136
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select `path`, `izmoAlias` from `images_backfill` where `ima_make` = 'TOYOTA' and `ima_model` = 'PROACE CITY L1' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'LCV' limit 1
      260μsbrampacImagesRepository.php#97
      Bindings
      • 0: TOYOTA
      • 1: PROACE CITY L1
      • 2: 
      • 3: 
      • 4: LCV
      Backtrace
      • 16. app/Queries/ImagesRepository.php:97
      • 17. app/Traits/VehicleImage.php:121
      • 18. app/Queries/VanLeaseClickRepository.php:84
      • 19. app/Http/Controllers/VanLeasingController.php:136
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select `model_cap` from `vandirect`.`vans` where `model` = 'PROACE CITY L1' limit 1
      280μsbrampacImagesRepository.php#106
      Bindings
      • 0: PROACE CITY L1
      Backtrace
      • 14. app/Queries/ImagesRepository.php:106
      • 18. app/Queries/ImagesRepository.php:102
      • 19. app/Traits/VehicleImage.php:121
      • 20. app/Queries/VanLeaseClickRepository.php:84
      • 21. app/Http/Controllers/VanLeasingController.php:136
    • select `path`, `izmoAlias` from `images_backfill` where `ima_make` = 'TOYOTA' and `ima_model` = (select `model_cap` from `vandirect`.`vans` where `model` = 'PROACE CITY L1' limit 1) and `path` != '' and `izmoAlias` != '' and `ima_type` = 'LCV' limit 1
      530μsbrampacImagesRepository.php#111
      Bindings
      • 0: TOYOTA
      • 1: PROACE CITY L1
      • 2: 
      • 3: 
      • 4: LCV
      Backtrace
      • 16. app/Queries/ImagesRepository.php:111
      • 17. app/Traits/VehicleImage.php:121
      • 18. app/Queries/VanLeaseClickRepository.php:84
      • 19. app/Http/Controllers/VanLeasingController.php:136
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select distinct `make`, `model`, `model_long`, `model_long_slug`, `derivative`, `van_id`, `derivative_slug` from `vans` where (`make_slug` = 'citroen' and `model_slug` = 'relay-heavy-l4' and `model_long` = 'RELAY 35 HEAVY L4 DIESEL') order by `derivative` asc
      540μsvandirectVanModel.php#163
      Bindings
      • 0: citroen
      • 1: relay-heavy-l4
      • 2: RELAY 35 HEAVY L4 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` = 'citroen' and `model_slug` = 'relay-heavy-l4') and `model_long_slug` = 'relay-35-heavy-l4-diesel' limit 1
      5.54msvandirectVanLeasingSearch.php#234
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: 0
      • 4: citroen
      • 5: relay-heavy-l4
      • 6: relay-35-heavy-l4-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
      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` = 'citroen' order by `model` asc
      90μsvandirectVanModel.php#26
      Bindings
      • 0: citroen
      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` = 'citroen' and `model_slug` = 'relay-heavy-l4' and `did` = 160 and `live` = 1 and `capid` > 1 and `lease_live` = 1 and `price_monthly` > 0) and `model_long_slug` = 'relay-35-heavy-l4-diesel' order by `price_monthly` asc limit 1
      3.36msvandirectVanLeasingSearch.php#102
      Bindings
      • 0: citroen
      • 1: relay-heavy-l4
      • 2: 160
      • 3: 1
      • 4: 1
      • 5: 1
      • 6: 0
      • 7: relay-35-heavy-l4-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` = 'citroen' and `model_slug` = 'relay-heavy-l4' and `d_live` = 1 and `live` = 1 and `otrprice` > 4000 and `amount` > 0) order by `otrprice` asc limit 1
      460μsvandirectNewVanSearch.php#205
      Bindings
      • 0: citroen
      • 1: relay-heavy-l4
      • 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` = 'citroen' and `model_slug` = 'relay-heavy-l4' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `model_long_slug` = 'relay-35-heavy-l4-diesel' order by `derivative` asc
      1.68msvandirectVanLeaseFilter.php#69
      Bindings
      • 0: citroen
      • 1: relay-heavy-l4
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: relay-35-heavy-l4-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` = 'citroen' and `model_slug` = 'relay-heavy-l4' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `model_long_slug` = 'relay-35-heavy-l4-diesel' order by `fuel` asc
      1.62msvandirectVanLeaseFilter.php#99
      Bindings
      • 0: citroen
      • 1: relay-heavy-l4
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: relay-35-heavy-l4-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` = 'citroen' and `model_slug` = 'relay-heavy-l4' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `model_long_slug` = 'relay-35-heavy-l4-diesel' order by `transmission` asc
      1.61msvandirectVanLeaseFilter.php#114
      Bindings
      • 0: citroen
      • 1: relay-heavy-l4
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: relay-35-heavy-l4-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` = 'citroen' and `model_slug` = 'relay-heavy-l4' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `model_long_slug` = 'relay-35-heavy-l4-diesel' and `term` in (6, 12, 18, 24, 36, 48, 60) order by `term` asc
      5.66msvandirectVanLeaseFilter.php#138
      Bindings
      • 0: citroen
      • 1: relay-heavy-l4
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: relay-35-heavy-l4-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` = 'citroen' and `model_slug` = 'relay-heavy-l4' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `model_long_slug` = 'relay-35-heavy-l4-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
      5.85msvandirectVanLeaseFilter.php#153
      Bindings
      • 0: citroen
      • 1: relay-heavy-l4
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: relay-35-heavy-l4-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` = 'citroen' and `model_slug` = 'relay-heavy-l4' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `model_long_slug` = 'relay-35-heavy-l4-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
      5.79msvandirectVanLeaseFilter.php#169
      Bindings
      • 0: citroen
      • 1: relay-heavy-l4
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: relay-35-heavy-l4-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` = 'citroen' and `model_slug` = 'relay-heavy-l4' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `model_long_slug` = 'relay-35-heavy-l4-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
      5.87msvandirectVanLeaseFilter.php#193
      Bindings
      • 0: citroen
      • 1: relay-heavy-l4
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: relay-35-heavy-l4-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` = 'citroen' and `model_slug` = 'relay-heavy-l4') group by `make`, `model`, `model_long`, `model_long_slug`, `make_slug`, `model_slug` order by `model_long` asc
      480μsvandirectVanModel.php#131
      Bindings
      • 0: citroen
      • 1: relay-heavy-l4
      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` = 'citroen' and `model_slug` = 'relay-heavy-l4' and `d_live` = 1 and `live` = 1 and `otrprice` > 4000 and `amount` > 0 and `capid` > 1) and `model_long_slug` = 'relay-35-heavy-l4-diesel' order by `otrprice` asc limit 2
      630μsvandirectNewVanSearch.php#276
      Bindings
      • 0: citroen
      • 1: relay-heavy-l4
      • 2: 1
      • 3: 1
      • 4: 4000
      • 5: 0
      • 6: 1
      • 7: relay-35-heavy-l4-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
    50Van.php#?
    App\Models\VanLeaseOffer
    31VanLeaseOffer.php#?
    App\Models\VanLeaseClick
    12VanLeaseClick.php#?
    App\Models\VanCusCar
    2VanCusCar.php#?
        _token
        WREs4EJAMxsojFbzzJZPQDiboIa7ykFvb6YjYOu1
        views
        6
        uid
        0e81e746723b2223386858ad43980e34
        _previous
        array:1 [ "url" => "https://laravel.cars2buy.co.uk/van-leasing/citroen/relay-heavy-l4/relay-35-hea...
        _flash
        array:2 [ "old" => [] "new" => [] ]
        last_results_page
        /business-car-leasing/mini/cooper-convertible/2.0-c-classic-2dr-auto_88805?fCarID=88805&page=15
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /van-leasing/citroen/relay-heavy-l4/relay-35-heavy-l4-diesel/
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        0 of 0
        array:2 [ "fVariant" => "relay-35-heavy-l4-diesel" "page" => "22" ]
        request_request
        []
        
        request_headers
        0 of 0
        array:19 [ "cookie" => array:1 [ 0 => "_pbjs_userid_consent_data=3524755945110770; _pubcid=f2131f3b-94d0-4bdf-9c60-bfbcb90beff8; _ga=GA1.1.220818139.1737440758; _gcl_au=1.1.1134257764.1737440758; uid=eyJpdiI6InUwVW1QQUgxZkN3S3dTSFZubmxmelE9PSIsInZhbHVlIjoiOFQvMnJHSCtzL3o5VlpKVHY0bldhVmpIZE9rNFNuMTJLRTVUditpYWIvbWVxL040RDZtMjBxMWx3RGtUU2RxK2drYUlZUlFpQnJQNDJhU2ZWYm1sKzFxcXlXbGhxSzZ3VHowUTdETnZIb3c9IiwibWFjIjoiZDYwYzc0ZTlkYTkwMmM1NzczNzIxZjI1MTVjN2ZkM2IzN2MzMDNlZDJiZTAzNDZmMGFhOTMwZmUyY2I4NmZlYSIsInRhZyI6IiJ9; XSRF-TOKEN=eyJpdiI6Ik5JQ0s2OTRkWmxKc2dqelozUzNCNlE9PSIsInZhbHVlIjoiL1o3RWpkaXVMTFl4MElHNFI3U0RkbXhsbHBlWHk0eGd4ZUZWa1MxdFFZWEsyb0l3VytSQUEwbXFsbjdSMVp3Y3FpdmIvcTdLSnZ0MXBPMnYwVVNtS2NtaWZ5VitaZlEyNWFNZTVJdjNMbzFudHR0LzYxTnp4dVNlelUrRXQzeEUiLCJtYWMiOiIxOTJmM2EyZTlkM2Y2NmQ3NWMxYTFiNmNlNDBjN2JhNjY4NmE1ZmMxODliZDZhZmQzN2ZiY2FkMWU3ZjE4YmJlIiwidGFnIjoiIn0%3D; laravel_session=eyJpdiI6IkZYODRyZ3lGU1ZlMVUxK29XVVA5TkE9PSIsInZhbHVlIjoiUWNkTG9hNFNoay9NUTVrZ0V6YUZyMnVKZHBlVTNPNHdjbm96NnZ5UjFlRWIzRElRT0hCdS9mcW1WNFZzRWtDRE84THpReEhEQTFpMXE1MGFRWkZFajNGbmRZcENIN2dZL0puYUwybUx5STZwK0ZTQ1lOdUhscFgvR01DQ2ZuMjUiLCJtYWMiOiIzNGE2OWI2YzllNTdiZDhhZjQ1ZWYyZGI4ZDBhOWRhNzczNzA2NmQ3ZGI5MWQzMTNlMzE4NGNmYmU5OGM2YTFjIiwidGFnIjoiIn0%3D; _ga_N9GLTHNRLQ=GS1.1.1737440757.1.1.1737440777.40.0.0_pbjs_userid_consent_data=3524755945110770; _pubcid=f2131f3b-94d0-4bdf-9c60-bfbcb90beff8; _ga=GA1.1.220818139.1737440758; _gcl_au=1.1.1134257764.1737440758; uid" ] "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.135.219.104" ] "host" => array:1 [ 0 => "laravel.cars2buy.co.uk" ] ]
        request_cookies
        0 of 0
        array:8 [ "_pbjs_userid_consent_data" => null "_pubcid" => null "_ga" => null "_gcl_au" => null "uid" => "0e81e746723b2223386858ad43980e34" "XSRF-TOKEN" => "WREs4EJAMxsojFbzzJZPQDiboIa7ykFvb6YjYOu1" "laravel_session" => "zLNaFXxI0XCTbWWQqcZg7U3nHD22H64gqjFIGMK5" "_ga_N9GLTHNRLQ" => 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 => "Tue, 21 Jan 2025 06:26:19 GMT" ] "pragma" => array:1 [ 0 => "no-cache" ] "expires" => array:1 [ 0 => "-1" ] "set-cookie" => array:3 [ 0 => "uid=eyJpdiI6Imd1Q3J1THIrcHkzaTI5OU9TQTd4RGc9PSIsInZhbHVlIjoiSGpZRmFHZ2lOMXdtVDVDbS8rTlJmNkQwclBJTEpDclNGTERXNU5MWDdrQzhjczZkeHpiRHJRL3duZVRORXluM0NUR0U4SEEzYldyajlDYjJhQUhMOGZZK3djdytmc1Z5MGpoQTVPNHVEWlE9IiwibWFjIjoiZTNkOTAyZDhkMzZkZmI2YWE0ZjAxNTk4NWMxNTNiOGQ1NDg1NDU3YjQwYzlhMjkxOWMwYzU3NzEzYTljM2QyNyIsInRhZyI6IiJ9; expires=Tue, 24 Jan 5358 08:45:19 GMT; Max-Age=105179566740; path=/; secure; httponly; samesite=laxuid=eyJpdiI6Imd1Q3J1THIrcHkzaTI5OU9TQTd4RGc9PSIsInZhbHVlIjoiSGpZRmFHZ2lOMXdtVDVDbS8rTlJmNkQwclBJTEpDclNGTERXNU5MWDdrQzhjczZkeHpiRHJRL3duZVRORXluM0NUR0U4SEEzYldy" 1 => "XSRF-TOKEN=eyJpdiI6IkN6NlZxeVYyOU9nck5xWHgrREZpS3c9PSIsInZhbHVlIjoiUThsVEV2MkUwUUlKajlQOXRkbDlWOS9wMUhiUG1NbExUUktYcTJQMGNLUm9reHZTMXZ1VnM3UlNIRzFWUFNUM3Z2bTk0ZHkxaWE1Nkd6Qlpacnd4K1JZOG1PZGs4U0xHNEFVVDNhMEROaWxDN2kwWXJ4bDRUY1JZV3VSb3FsU3UiLCJtYWMiOiIxNWM5MDM1ODM2YTc5MmU0ZWM2YWZiOGI3ZDkwMTdkMWJjN2IzNGQyMWQxYmM3NTczNGEwMDI1MmY0OTU3OWM5IiwidGFnIjoiIn0%3D; expires=Tue, 21 Jan 2025 08:26:19 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IkN6NlZxeVYyOU9nck5xWHgrREZpS3c9PSIsInZhbHVlIjoiUThsVEV2MkUwUUlKajlQOXRkbDlWOS9wMUhiUG1NbExUUktYcTJQMGNLUm9reHZTMXZ1VnM3UlNIRzFWUFNUM3Z2bTk0Z" 2 => "laravel_session=eyJpdiI6InJpazhRZjFSaUlkb1I1VmtJT0RPV1E9PSIsInZhbHVlIjoicEE3SDFoVkFGdlo5ckJxNzJDeDZpV3BFVVB6MThvdjMwQ0FzWmRpWW5RVFJ5RmlpaW52YlZvV3k4dDg5MTRLcE40Q2NuVVpjcHQ0VEFvKzN5aDc3Y04rZi9SUEg5TmQyQXRxWXcxUlJHc3pVcHFUZk5KWmozYWV1UTVxN1hqZkUiLCJtYWMiOiIxYmVmNTk2MWQ5MWQ0ODlhNjlhOTdhYjIxZTNhOTRiNThmMTQwY2ExM2Q5MWIxYmJiOWUxMmZjOTMxMWQ3N2QzIiwidGFnIjoiIn0%3D; expires=Tue, 21 Jan 2025 08:26:19 GMT; Max-Age=7200; path=/; httponly; samesite=laxlaravel_session=eyJpdiI6InJpazhRZjFSaUlkb1I1VmtJT0RPV1E9PSIsInZhbHVlIjoicEE3SDFoVkFGdlo5ckJxNzJDeDZpV3BFVVB6MThvdjMwQ0FzWmRpWW5RVFJ5RmlpaW52YlZvV3k4dDg5MTRLcE40" ] "Set-Cookie" => array:3 [ 0 => "uid=eyJpdiI6Imd1Q3J1THIrcHkzaTI5OU9TQTd4RGc9PSIsInZhbHVlIjoiSGpZRmFHZ2lOMXdtVDVDbS8rTlJmNkQwclBJTEpDclNGTERXNU5MWDdrQzhjczZkeHpiRHJRL3duZVRORXluM0NUR0U4SEEzYldyajlDYjJhQUhMOGZZK3djdytmc1Z5MGpoQTVPNHVEWlE9IiwibWFjIjoiZTNkOTAyZDhkMzZkZmI2YWE0ZjAxNTk4NWMxNTNiOGQ1NDg1NDU3YjQwYzlhMjkxOWMwYzU3NzEzYTljM2QyNyIsInRhZyI6IiJ9; expires=Tue, 24-Jan-5358 08:45:19 GMT; path=/; secure; httponlyuid=eyJpdiI6Imd1Q3J1THIrcHkzaTI5OU9TQTd4RGc9PSIsInZhbHVlIjoiSGpZRmFHZ2lOMXdtVDVDbS8rTlJmNkQwclBJTEpDclNGTERXNU5MWDdrQzhjczZkeHpiRHJRL3duZVRORXluM0NUR0U4SEEzYldy" 1 => "XSRF-TOKEN=eyJpdiI6IkN6NlZxeVYyOU9nck5xWHgrREZpS3c9PSIsInZhbHVlIjoiUThsVEV2MkUwUUlKajlQOXRkbDlWOS9wMUhiUG1NbExUUktYcTJQMGNLUm9reHZTMXZ1VnM3UlNIRzFWUFNUM3Z2bTk0ZHkxaWE1Nkd6Qlpacnd4K1JZOG1PZGs4U0xHNEFVVDNhMEROaWxDN2kwWXJ4bDRUY1JZV3VSb3FsU3UiLCJtYWMiOiIxNWM5MDM1ODM2YTc5MmU0ZWM2YWZiOGI3ZDkwMTdkMWJjN2IzNGQyMWQxYmM3NTczNGEwMDI1MmY0OTU3OWM5IiwidGFnIjoiIn0%3D; expires=Tue, 21-Jan-2025 08:26:19 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IkN6NlZxeVYyOU9nck5xWHgrREZpS3c9PSIsInZhbHVlIjoiUThsVEV2MkUwUUlKajlQOXRkbDlWOS9wMUhiUG1NbExUUktYcTJQMGNLUm9reHZTMXZ1VnM3UlNIRzFWUFNUM3Z2bTk0Z" 2 => "laravel_session=eyJpdiI6InJpazhRZjFSaUlkb1I1VmtJT0RPV1E9PSIsInZhbHVlIjoicEE3SDFoVkFGdlo5ckJxNzJDeDZpV3BFVVB6MThvdjMwQ0FzWmRpWW5RVFJ5RmlpaW52YlZvV3k4dDg5MTRLcE40Q2NuVVpjcHQ0VEFvKzN5aDc3Y04rZi9SUEg5TmQyQXRxWXcxUlJHc3pVcHFUZk5KWmozYWV1UTVxN1hqZkUiLCJtYWMiOiIxYmVmNTk2MWQ5MWQ0ODlhNjlhOTdhYjIxZTNhOTRiNThmMTQwY2ExM2Q5MWIxYmJiOWUxMmZjOTMxMWQ3N2QzIiwidGFnIjoiIn0%3D; expires=Tue, 21-Jan-2025 08:26:19 GMT; path=/; httponlylaravel_session=eyJpdiI6InJpazhRZjFSaUlkb1I1VmtJT0RPV1E9PSIsInZhbHVlIjoicEE3SDFoVkFGdlo5ckJxNzJDeDZpV3BFVVB6MThvdjMwQ0FzWmRpWW5RVFJ5RmlpaW52YlZvV3k4dDg5MTRLcE40" ] ]
        session_attributes
        0 of 0
        array:7 [ "_token" => "WREs4EJAMxsojFbzzJZPQDiboIa7ykFvb6YjYOu1" "views" => 6 "uid" => "0e81e746723b2223386858ad43980e34" "_previous" => array:1 [ "url" => "https://laravel.cars2buy.co.uk/van-leasing/citroen/relay-heavy-l4/relay-35-heavy-l4-diesel?fVariant=relay-35-heavy-l4-diesel&page=22" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "last_results_page" => "/business-car-leasing/mini/cooper-convertible/2.0-c-classic-2dr-auto_88805?fCarID=88805&page=15" "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-01-21 06:26:19GET/van-leasing/citroen/relay-heavy-l4/relay-35-heavy-l4-diesel/?fVariant=relay-35-heavy-l4-diesel&page=226142595