Citroen E-Relay L3 Leasing Deals:

CITROEN e-RELAY L3

Page 35 of 138 pages

Citroen E-Relay L3 variants:

New Van Offers:

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

Filter your results:

Lease details:

Van details:

Request history8.2.27PHP Version446msRequest Duration2MBMemory UsageGET van-leasing/{manufacturer}/{model}Route
  • warninglog[06:50:54] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[06:50:54] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[06:50:54] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[06:50:54] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[06:50:54] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[06:50:54] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[06:50:54] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[06:50:54] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • Booting (62.1ms)time
  • Application (384ms)time
  • 1 x Application (86.06%)
    384ms
    1 x Booting (13.94%)
    62.10ms
    14 templates were rendered
    • van-leasing.showshow.blade.php#?blade
    • van-leasing.search-barsearch-bar.blade.php#?blade
    • includes.paginationpagination.blade.php#?blade
    • van-leasing.filters.van-leasing-filtervan-leasing-filter.blade.php#?blade
    • includes.van-filtersvan-filters.blade.php#?blade
    • van-leasing.filters.van-leasing-filtervan-leasing-filter.blade.php#?blade
    • includes.van-filtersvan-filters.blade.php#?blade
    • van-leasing.extraextra.blade.php#?blade
    • appapp.blade.php#?blade
    • share.headhead.blade.php#?blade
    • includes.dfp-codedfp-code.blade.php#?blade
    • share.headerheader.blade.php#?blade
    • share.footerfooter.blade.php#?blade
    • share.footfoot.blade.php#?blade
    uri
    GET van-leasing/{manufacturer}/{model}
    middleware
    web
    controller
    App\Http\Controllers\VanLeasingController@results
    namespace
    where
    as
    van-leasing-results
    file
    app/Http/Controllers/VanLeasingController.php:109-190
    25 statements were executed157ms
    • 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` = 'e-relay-l3') limit 1
      1.82msvandirectController.php#434
      Bindings
      • 0: citroen
      • 1: e-relay-l3
      Backtrace
      • 15. app/Http/Controllers/Controller.php:434
      • 16. app/Http/Controllers/Controller.php:58
      • 18. vendor/laravel/framework/src/Illuminate/Container/Container.php:952
      • 19. vendor/laravel/framework/src/Illuminate/Container/Container.php:795
      • 20. vendor/laravel/framework/src/Illuminate/Foundation/Application.php:957
    • select count(*) as aggregate from `lease_offers` inner join `vans` on `vans`.`van_id` = `lease_offers`.`id_car` inner join `dealers` on `dealers`.`did` = `lease_offers`.`bid` where (`make_slug` = 'citroen' and `model_slug` = 'e-relay-l3' and `live` = 1 and `capid` > 1 and `lease_live` = 1 and `price_monthly` > 0)
      13.24msvandirectVanLeasingSearch.php#45
      Bindings
      • 0: citroen
      • 1: e-relay-l3
      • 2: 1
      • 3: 1
      • 4: 1
      • 5: 0
      Backtrace
      • 16. app/Queries/VanLeasingSearch.php:45
      • 17. app/Http/Controllers/VanLeasingController.php:119
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select `lease_live`, `linked`, `logo`, `derivative`, `derivative_slug`, `capid`, `make`, `make_slug`, `model`, `model_slug`, `model_long`, `model_long_slug`, `bid`, `lease_id`, `type`, `term`, `mileage`, `price_monthly`, `deposit_type`, `deposit`, `vans`.`delivery`, `urllink`, `d_subid`, `name`, `live` from `lease_offers` inner join `vans` on `vans`.`van_id` = `lease_offers`.`id_car` inner join `dealers` on `dealers`.`did` = `lease_offers`.`bid` where (`make_slug` = 'citroen' and `model_slug` = 'e-relay-l3' and `live` = 1 and `capid` > 1 and `lease_live` = 1 and `price_monthly` > 0) order by price_monthly limit 10 offset 340
      10.57msvandirectVanLeasingSearch.php#45
      Bindings
      • 0: citroen
      • 1: e-relay-l3
      • 2: 1
      • 3: 1
      • 4: 1
      • 5: 0
      Backtrace
      • 16. app/Queries/VanLeasingSearch.php:45
      • 17. app/Http/Controllers/VanLeasingController.php:119
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • Connection EstablishedbrampacImagesRepository.php#56
      Backtrace
      • 9. app/Queries/ImagesRepository.php:56
      • 10. app/Traits/VehicleImage.php:112
      • 11. app/Http/Controllers/VanLeasingController.php:133
      • 12. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 13. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `path`, `izmoAlias` from `images_izmo` inner join `vandirect`.`vans` on `images_izmo`.`cap_id` = `vandirect`.`vans`.`capid` where `vandirect`.`vans`.`make` = 'CITROEN' and `vandirect`.`vans`.`model` = 'e-RELAY L3' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'LCV' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
      1.34msbrampacImagesRepository.php#66
      Bindings
      • 0: CITROEN
      • 1: e-RELAY L3
      • 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 `model_cap` from `vandirect`.`vans` where `model` = 'e-RELAY L3' limit 1
      530μsbrampacImagesRepository.php#76
      Bindings
      • 0: e-RELAY L3
      Backtrace
      • 14. app/Queries/ImagesRepository.php:76
      • 17. app/Queries/ImagesRepository.php:72
      • 18. app/Traits/VehicleImage.php:112
      • 19. app/Http/Controllers/VanLeasingController.php:133
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `images_izmo` inner join `vandirect`.`vans` on `images_izmo`.`cap_id` = `vandirect`.`vans`.`capid` where `vandirect`.`vans`.`make` = 'CITROEN' and `vandirect`.`vans`.`model_cap` = (select `model_cap` from `vandirect`.`vans` where `model` = 'e-RELAY L3' limit 1) and `path` != '' and `izmoAlias` != '' and `ima_type` = 'LCV' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
      2.66msbrampacImagesRepository.php#83
      Bindings
      • 0: CITROEN
      • 1: e-RELAY L3
      • 2: 
      • 3: 
      • 4: LCV
      Backtrace
      • 14. app/Queries/ImagesRepository.php:83
      • 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` = 'e-RELAY L3' and `stamp` <= '2025-01-24' and `stamp` >= '2025-01-14' and `ipuser` != '' and `make_rule` = 0 and `robot_rule` = 0) group by `ipuser`
      45.81msvandirectVanLeaseClickRepository.php#105
      Bindings
      • 0: CITROEN
      • 1: e-RELAY L3
      • 2: 2025-01-24
      • 3: 2025-01-14
      • 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 0 = 1 and (`make` != 'CITROEN' and `model` != 'e-RELAY L3' and `stamp` < '2025-01-24' and `stamp` >= '2025-01-14' and `make_rule` = 0 and `robot_rule` = 0) group by `model`, `make` order by `count` desc limit 5
      270μsvandirectVanLeaseClickRepository.php#77
      Bindings
      • 0: CITROEN
      • 1: e-RELAY L3
      • 2: 2025-01-24
      • 3: 2025-01-14
      • 4: 0
      • 5: 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` = 'citroen' and `model_slug` = 'e-relay-l3' and `model_long` = '') order by `derivative` asc
      670μsvandirectVanModel.php#163
      Bindings
      • 0: citroen
      • 1: e-relay-l3
      • 2: 
      Backtrace
      • 15. app/Queries/VanModel.php:163
      • 16. app/Http/Controllers/VanLeasingController.php:148
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select COUNT(DISTINCT bid) as totalBrokers from `lease_offers` inner join `vans` on `vans`.`van_id` = `lease_offers`.`id_car` inner join `dealers` on `dealers`.`did` = `lease_offers`.`bid` where (`live` = 1 and `capid` > 1 and `lease_live` = 1 and `price_monthly` > 0) and (`make_slug` = 'citroen' and `model_slug` = 'e-relay-l3') limit 1
      13.5msvandirectVanLeasingSearch.php#234
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: 0
      • 4: citroen
      • 5: e-relay-l3
      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
      140μ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
      1.54msvandirectVanModel.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` = 'e-relay-l3' and `did` = 160 and `live` = 1 and `capid` > 1 and `lease_live` = 1 and `price_monthly` > 0) order by `price_monthly` asc limit 1
      2.43msvandirectVanLeasingSearch.php#102
      Bindings
      • 0: citroen
      • 1: e-relay-l3
      • 2: 160
      • 3: 1
      • 4: 1
      • 5: 1
      • 6: 0
      Backtrace
      • 15. app/Queries/VanLeasingSearch.php:102
      • 16. app/Http/Controllers/VanLeasingController.php:177
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select `make`, `make_slug`, `model`, `model_slug`, MIN(otrprice/(basic+vans.delivery)) as discount from `cus_cars` inner join `vans` on `vans`.`van_id` = `cus_cars`.`id_car` inner join `dealers` on `dealers`.`did` = `cus_cars`.`bid` inner join `account` on `account`.`broke_id` = `dealers`.`did` where (`make_slug` = 'citroen' and `model_slug` = 'e-relay-l3' and `d_live` = 1 and `live` = 1 and `otrprice` > 4000 and `amount` > 0) order by `otrprice` asc limit 1
      940μsvandirectNewVanSearch.php#205
      Bindings
      • 0: citroen
      • 1: e-relay-l3
      • 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` = 'e-relay-l3' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) order by `derivative` asc
      680μsvandirectVanLeaseFilter.php#69
      Bindings
      • 0: citroen
      • 1: e-relay-l3
      • 2: 1
      • 3: 1
      • 4: 0
      Backtrace
      • 15. app/Queries/SearchFilters/VanLeaseFilter.php:69
      • 16. app/Queries/SearchFilters/VanLeaseFilter.php:19
      • 17. app/Http/Controllers/VanLeasingController.php:180
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select distinct `fuel` from `lease_offers` inner join `vans` on `vans`.`van_id` = `lease_offers`.`id_car` inner join `dealers` on `dealers`.`did` = `lease_offers`.`bid` where (`make_slug` = 'citroen' and `model_slug` = 'e-relay-l3' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) order by `fuel` asc
      610μsvandirectVanLeaseFilter.php#99
      Bindings
      • 0: citroen
      • 1: e-relay-l3
      • 2: 1
      • 3: 1
      • 4: 0
      Backtrace
      • 15. app/Queries/SearchFilters/VanLeaseFilter.php:99
      • 16. app/Queries/SearchFilters/VanLeaseFilter.php:25
      • 17. app/Http/Controllers/VanLeasingController.php:180
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select distinct `transmission` from `lease_offers` inner join `vans` on `vans`.`van_id` = `lease_offers`.`id_car` inner join `dealers` on `dealers`.`did` = `lease_offers`.`bid` where (`make_slug` = 'citroen' and `model_slug` = 'e-relay-l3' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) order by `transmission` asc
      740μsvandirectVanLeaseFilter.php#114
      Bindings
      • 0: citroen
      • 1: e-relay-l3
      • 2: 1
      • 3: 1
      • 4: 0
      Backtrace
      • 15. app/Queries/SearchFilters/VanLeaseFilter.php:114
      • 16. app/Queries/SearchFilters/VanLeaseFilter.php:29
      • 17. app/Http/Controllers/VanLeasingController.php:180
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select distinct `model_long`, `model_long_slug` from `lease_offers` inner join `vans` on `vans`.`van_id` = `lease_offers`.`id_car` inner join `dealers` on `dealers`.`did` = `lease_offers`.`bid` where (`make_slug` = 'citroen' and `model_slug` = 'e-relay-l3' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) order by `model_long` asc
      910μsvandirectVanLeaseFilter.php#123
      Bindings
      • 0: citroen
      • 1: e-relay-l3
      • 2: 1
      • 3: 1
      • 4: 0
      Backtrace
      • 15. app/Queries/SearchFilters/VanLeaseFilter.php:123
      • 16. app/Queries/SearchFilters/VanLeaseFilter.php:33
      • 17. app/Http/Controllers/VanLeasingController.php:180
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select distinct `term` from `lease_offers` inner join `vans` on `vans`.`van_id` = `lease_offers`.`id_car` inner join `dealers` on `dealers`.`did` = `lease_offers`.`bid` where (`make_slug` = 'citroen' and `model_slug` = 'e-relay-l3' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `term` in (6, 12, 18, 24, 36, 48, 60) order by `term` asc
      12.67msvandirectVanLeaseFilter.php#138
      Bindings
      • 0: citroen
      • 1: e-relay-l3
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: 6
      • 6: 12
      • 7: 18
      • 8: 24
      • 9: 36
      • 10: 48
      • 11: 60
      Backtrace
      • 15. app/Queries/SearchFilters/VanLeaseFilter.php:138
      • 16. app/Queries/SearchFilters/VanLeaseFilter.php:37
      • 17. app/Http/Controllers/VanLeasingController.php:180
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select distinct `mileage` from `lease_offers` inner join `vans` on `vans`.`van_id` = `lease_offers`.`id_car` inner join `dealers` on `dealers`.`did` = `lease_offers`.`bid` where (`make_slug` = 'citroen' and `model_slug` = 'e-relay-l3' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `term` in (6, 12, 18, 24, 36, 48, 60) and `mileage` in (5000, 6000, 8000, 10000, 12000, 15000, 20000, 25000, 30000, 35000, 40000) order by `mileage` asc
      14.21msvandirectVanLeaseFilter.php#153
      Bindings
      • 0: citroen
      • 1: e-relay-l3
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: 6
      • 6: 12
      • 7: 18
      • 8: 24
      • 9: 36
      • 10: 48
      • 11: 60
      • 12: 5000
      • 13: 6000
      • 14: 8000
      • 15: 10000
      • 16: 12000
      • 17: 15000
      • 18: 20000
      • 19: 25000
      • 20: 30000
      • 21: 35000
      • 22: 40000
      Backtrace
      • 15. app/Queries/SearchFilters/VanLeaseFilter.php:153
      • 16. app/Queries/SearchFilters/VanLeaseFilter.php:41
      • 17. app/Http/Controllers/VanLeasingController.php:180
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select distinct `mileage`, MAX(price_monthly) as max_price, MIN(price_monthly) as min_price from `lease_offers` inner join `vans` on `vans`.`van_id` = `lease_offers`.`id_car` inner join `dealers` on `dealers`.`did` = `lease_offers`.`bid` where (`make_slug` = 'citroen' and `model_slug` = 'e-relay-l3' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `term` in (6, 12, 18, 24, 36, 48, 60) and `mileage` in (5000, 6000, 8000, 10000, 12000, 15000, 20000, 25000, 30000, 35000, 40000) order by `mileage` asc
      14.06msvandirectVanLeaseFilter.php#169
      Bindings
      • 0: citroen
      • 1: e-relay-l3
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: 6
      • 6: 12
      • 7: 18
      • 8: 24
      • 9: 36
      • 10: 48
      • 11: 60
      • 12: 5000
      • 13: 6000
      • 14: 8000
      • 15: 10000
      • 16: 12000
      • 17: 15000
      • 18: 20000
      • 19: 25000
      • 20: 30000
      • 21: 35000
      • 22: 40000
      Backtrace
      • 15. app/Queries/SearchFilters/VanLeaseFilter.php:169
      • 16. app/Queries/SearchFilters/VanLeaseFilter.php:45
      • 17. app/Http/Controllers/VanLeasingController.php:180
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select distinct `mileage`, MAX(price_monthly) as max_price, MIN(price_monthly) as min_price, MAX(price_monthly) as max_price, MIN(price_monthly) as min_price from `lease_offers` inner join `vans` on `vans`.`van_id` = `lease_offers`.`id_car` inner join `dealers` on `dealers`.`did` = `lease_offers`.`bid` where (`make_slug` = 'citroen' and `model_slug` = 'e-relay-l3' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `term` in (6, 12, 18, 24, 36, 48, 60) and `mileage` in (5000, 6000, 8000, 10000, 12000, 15000, 20000, 25000, 30000, 35000, 40000) order by `mileage` asc
      14.51msvandirectVanLeaseFilter.php#193
      Bindings
      • 0: citroen
      • 1: e-relay-l3
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: 6
      • 6: 12
      • 7: 18
      • 8: 24
      • 9: 36
      • 10: 48
      • 11: 60
      • 12: 5000
      • 13: 6000
      • 14: 8000
      • 15: 10000
      • 16: 12000
      • 17: 15000
      • 18: 20000
      • 19: 25000
      • 20: 30000
      • 21: 35000
      • 22: 40000
      Backtrace
      • 15. app/Queries/SearchFilters/VanLeaseFilter.php:193
      • 16. app/Queries/SearchFilters/VanLeaseFilter.php:49
      • 17. app/Http/Controllers/VanLeasingController.php:180
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select distinct `make`, `model`, `model_long`, `model_long_slug`, `make_slug`, `model_slug`, `derivative` from `vans` where (`make_slug` = 'citroen' and `model_slug` = 'e-relay-l3') group by `make`, `model`, `model_long`, `model_long_slug`, `make_slug`, `model_slug` order by `model_long` asc
      800μsvandirectVanModel.php#131
      Bindings
      • 0: citroen
      • 1: e-relay-l3
      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` = 'e-relay-l3' and `d_live` = 1 and `live` = 1 and `otrprice` > 4000 and `amount` > 0 and `capid` > 1) order by `otrprice` asc limit 2
      1.08msvandirectNewVanSearch.php#276
      Bindings
      • 0: citroen
      • 1: e-relay-l3
      • 2: 1
      • 3: 1
      • 4: 4000
      • 5: 0
      • 6: 1
      Backtrace
      • 15. app/Queries/NewVanSearch.php:276
      • 16. app/Queries/NewVanSearch.php:237
      • 17. app/Http/Controllers/VanLeasingController.php:187
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `make`, `make_slug`, `model`, `model_slug`, `model_long`, `derivative`, `basic`, `capid`, `veh_id`, `urllink`, `logo`, `linked`, `bid`, `d_subid`, `otrprice`, `dealers`.`acc_type`, `cpclick`, `vans`.`delivery` from `cus_cars` inner join `vans` on `vans`.`van_id` = `cus_cars`.`id_car` inner join `dealers` on `dealers`.`did` = `cus_cars`.`bid` inner join `account` on `account`.`broke_id` = `dealers`.`did` where (`make_slug` = 'citroen' and `model_slug` = 'e-relay-l3' and `d_live` = 1 and `live` = 1 and `otrprice` > 4000 and `amount` > 0 and `capid` > 1) order by `otrprice` asc limit 2
      990μsvandirectNewVanSearch.php#241
      Bindings
      • 0: citroen
      • 1: e-relay-l3
      • 2: 1
      • 3: 1
      • 4: 4000
      • 5: 0
      • 6: 1
      Backtrace
      • 15. app/Queries/NewVanSearch.php:241
      • 16. app/Http/Controllers/VanLeasingController.php:187
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    App\Models\Van
    47Van.php#?
    App\Models\VanLeaseOffer
    37VanLeaseOffer.php#?
    App\Models\VanCusCar
    1VanCusCar.php#?
        _token
        Mm8VhaB9rnp2QuffBU6VCWtvk5u1MLYAABolyCkJ
        views
        1
        uid
        fe28eca1291cfc1dffe37e73f29f80e1
        _previous
        array:1 [ "url" => "https://laravel.cars2buy.co.uk/van-leasing/citroen/e-relay-l3?page=35" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /van-leasing/citroen/e-relay-l3/
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        0 of 0
        array:1 [ "page" => "35" ]
        request_request
        []
        
        request_headers
        0 of 0
        array:18 [ "priority" => array:1 [ 0 => "u=0, i" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua" => array:1 [ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "close" ] "x-accel-internal" => array:1 [ 0 => "/internal-nginx-static-location" ] "x-real-ip" => array:1 [ 0 => "18.118.139.202" ] "host" => array:1 [ 0 => "laravel.cars2buy.co.uk" ] ]
        request_cookies
        []
        
        response_headers
        0 of 0
        array:7 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "private, must-revalidate" ] "date" => array:1 [ 0 => "Fri, 24 Jan 2025 06:50:54 GMT" ] "pragma" => array:1 [ 0 => "no-cache" ] "expires" => array:1 [ 0 => "-1" ] "set-cookie" => array:3 [ 0 => "uid=eyJpdiI6ImJRWUN2WnBER3pmcnQ5Ty9qRlFUZ3c9PSIsInZhbHVlIjoib2VvZHJtblZ4dEZPc29LWTk1UUFIZ2tCNmRHU1VyT2lhcHl2M1E0b0xHbzFwQkY5MndXWFNoMm9iamI1NGRVSHYramNxWkRQak8xWjB5a001NE9UV0JaS21ySW5xUWVsQVZuSDYxUkd4enc9IiwibWFjIjoiZTAzMzRkNDkwNzIxOTUwZDZlZWJiNzQxN2NiYjAyNjI5YThjY2M3YTk0ZGRhZTRmMmUwNWIzMzAxN2VkN2Y1ZSIsInRhZyI6IiJ9; expires=Thu, 27 Jul 5358 09:44:54 GMT; Max-Age=105195207240; path=/; secure; httponly; samesite=laxuid=eyJpdiI6ImJRWUN2WnBER3pmcnQ5Ty9qRlFUZ3c9PSIsInZhbHVlIjoib2VvZHJtblZ4dEZPc29LWTk1UUFIZ2tCNmRHU1VyT2lhcHl2M1E0b0xHbzFwQkY5MndXWFNoMm9iamI1NGRVSHYramNxWkRQak8x" 1 => "XSRF-TOKEN=eyJpdiI6IjJ5c1N6RXRpYjVSN2dzdDdNK3c4N2c9PSIsInZhbHVlIjoiMGwxMWJwQittMUtRYzRZRlhBSWw1TVFic1J6VW9oN2FrdFF6SzBGeHVidFppenVKaGtMR1ZUUHl5R2dHNFRVSm1uSEsrMjBvZldIdnZDQXZ0SUVXMmtYNUliSVJsUmtFNFB2NjZlUy8vcFRxcTNSWndMclg1VVo5OGxINTVHMlMiLCJtYWMiOiIxYzRlNGNkODkzYTVkZjcyMmNjNjk4N2Q2Zjk0MTFiNGI2NWU0NDI1MTUzYWQwMTY2MjBhMzhiYTkwZDdiYzdlIiwidGFnIjoiIn0%3D; expires=Fri, 24 Jan 2025 08:50:54 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IjJ5c1N6RXRpYjVSN2dzdDdNK3c4N2c9PSIsInZhbHVlIjoiMGwxMWJwQittMUtRYzRZRlhBSWw1TVFic1J6VW9oN2FrdFF6SzBGeHVidFppenVKaGtMR1ZUUHl5R2dHNFRVSm1uSEsrM" 2 => "laravel_session=eyJpdiI6IjVOUUtodDJPNDM2UnQ4LzE4aUlnQlE9PSIsInZhbHVlIjoiVkJld2wrQTgxa2NDVTdTbjNUaVNSaXFHZ0ltUm94bWpYOGxhMVg3ZjV5aXJwTmw3WEVGZUxrZzZueWg3dkxuVTM0SFJmcktma3E1TUd5Q2FZUDA0USsrWVg3T2syUXA0alZxeFM2MGtLeEkrbkVxOVZ1dTFtZnRLTURIZE9MYkEiLCJtYWMiOiJlZDUzODkxYTk2NzIwZTc3NjJlZGU5MTdmMzY4ODJlOWRhODQwOGFmM2Y5NTFhY2E4ODIwMGU5M2I4ODdlMmFmIiwidGFnIjoiIn0%3D; expires=Fri, 24 Jan 2025 08:50:54 GMT; Max-Age=7200; path=/; httponly; samesite=laxlaravel_session=eyJpdiI6IjVOUUtodDJPNDM2UnQ4LzE4aUlnQlE9PSIsInZhbHVlIjoiVkJld2wrQTgxa2NDVTdTbjNUaVNSaXFHZ0ltUm94bWpYOGxhMVg3ZjV5aXJwTmw3WEVGZUxrZzZueWg3dkxuVTM0" ] "Set-Cookie" => array:3 [ 0 => "uid=eyJpdiI6ImJRWUN2WnBER3pmcnQ5Ty9qRlFUZ3c9PSIsInZhbHVlIjoib2VvZHJtblZ4dEZPc29LWTk1UUFIZ2tCNmRHU1VyT2lhcHl2M1E0b0xHbzFwQkY5MndXWFNoMm9iamI1NGRVSHYramNxWkRQak8xWjB5a001NE9UV0JaS21ySW5xUWVsQVZuSDYxUkd4enc9IiwibWFjIjoiZTAzMzRkNDkwNzIxOTUwZDZlZWJiNzQxN2NiYjAyNjI5YThjY2M3YTk0ZGRhZTRmMmUwNWIzMzAxN2VkN2Y1ZSIsInRhZyI6IiJ9; expires=Thu, 27-Jul-5358 09:44:54 GMT; path=/; secure; httponlyuid=eyJpdiI6ImJRWUN2WnBER3pmcnQ5Ty9qRlFUZ3c9PSIsInZhbHVlIjoib2VvZHJtblZ4dEZPc29LWTk1UUFIZ2tCNmRHU1VyT2lhcHl2M1E0b0xHbzFwQkY5MndXWFNoMm9iamI1NGRVSHYramNxWkRQak8x" 1 => "XSRF-TOKEN=eyJpdiI6IjJ5c1N6RXRpYjVSN2dzdDdNK3c4N2c9PSIsInZhbHVlIjoiMGwxMWJwQittMUtRYzRZRlhBSWw1TVFic1J6VW9oN2FrdFF6SzBGeHVidFppenVKaGtMR1ZUUHl5R2dHNFRVSm1uSEsrMjBvZldIdnZDQXZ0SUVXMmtYNUliSVJsUmtFNFB2NjZlUy8vcFRxcTNSWndMclg1VVo5OGxINTVHMlMiLCJtYWMiOiIxYzRlNGNkODkzYTVkZjcyMmNjNjk4N2Q2Zjk0MTFiNGI2NWU0NDI1MTUzYWQwMTY2MjBhMzhiYTkwZDdiYzdlIiwidGFnIjoiIn0%3D; expires=Fri, 24-Jan-2025 08:50:54 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IjJ5c1N6RXRpYjVSN2dzdDdNK3c4N2c9PSIsInZhbHVlIjoiMGwxMWJwQittMUtRYzRZRlhBSWw1TVFic1J6VW9oN2FrdFF6SzBGeHVidFppenVKaGtMR1ZUUHl5R2dHNFRVSm1uSEsrM" 2 => "laravel_session=eyJpdiI6IjVOUUtodDJPNDM2UnQ4LzE4aUlnQlE9PSIsInZhbHVlIjoiVkJld2wrQTgxa2NDVTdTbjNUaVNSaXFHZ0ltUm94bWpYOGxhMVg3ZjV5aXJwTmw3WEVGZUxrZzZueWg3dkxuVTM0SFJmcktma3E1TUd5Q2FZUDA0USsrWVg3T2syUXA0alZxeFM2MGtLeEkrbkVxOVZ1dTFtZnRLTURIZE9MYkEiLCJtYWMiOiJlZDUzODkxYTk2NzIwZTc3NjJlZGU5MTdmMzY4ODJlOWRhODQwOGFmM2Y5NTFhY2E4ODIwMGU5M2I4ODdlMmFmIiwidGFnIjoiIn0%3D; expires=Fri, 24-Jan-2025 08:50:54 GMT; path=/; httponlylaravel_session=eyJpdiI6IjVOUUtodDJPNDM2UnQ4LzE4aUlnQlE9PSIsInZhbHVlIjoiVkJld2wrQTgxa2NDVTdTbjNUaVNSaXFHZ0ltUm94bWpYOGxhMVg3ZjV5aXJwTmw3WEVGZUxrZzZueWg3dkxuVTM0" ] ]
        session_attributes
        0 of 0
        array:6 [ "_token" => "Mm8VhaB9rnp2QuffBU6VCWtvk5u1MLYAABolyCkJ" "views" => 1 "uid" => "fe28eca1291cfc1dffe37e73f29f80e1" "_previous" => array:1 [ "url" => "https://laravel.cars2buy.co.uk/van-leasing/citroen/e-relay-l3?page=35" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-01-24 06:50:54GET/van-leasing/citroen/e-relay-l3/?page=358142585