Citroen E-Berlingo XL Leasing Deals:

CITROEN e-BERLINGO L2

Page 1 of 126 pages

Prev Next

Citroen E-Berlingo L2 variants:

New Van Offers:

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

Filter your results:

Lease details:

Van details:

Request history8.2.27PHP Version272msRequest Duration2MBMemory UsageGET van-leasing/{manufacturer}/{model}/{variant}Route
  • warninglog[15:09:02] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[15:09:02] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[15:09:02] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[15:09:02] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • Booting (35.78ms)time
  • Application (236ms)time
  • 1 x Application (86.83%)
    236ms
    1 x Booting (13.17%)
    35.78ms
    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 executed71.55ms
    • 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-berlingo-l2' and `model_long_slug` = 'e-berlingo-xl') limit 1
      900μsvandirectController.php#385
      Bindings
      • 0: citroen
      • 1: e-berlingo-l2
      • 2: e-berlingo-xl
      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` = 'e-berlingo-l2' and `live` = 1 and `capid` > 1 and `lease_live` = 1 and `price_monthly` > 0) and `model_long_slug` = 'e-berlingo-xl'
      6.08msvandirectVanLeasingSearch.php#45
      Bindings
      • 0: citroen
      • 1: e-berlingo-l2
      • 2: 1
      • 3: 1
      • 4: 1
      • 5: 0
      • 6: e-berlingo-xl
      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-berlingo-l2' and `live` = 1 and `capid` > 1 and `lease_live` = 1 and `price_monthly` > 0) and `model_long_slug` = 'e-berlingo-xl' order by price_monthly limit 10 offset 0
      7.95msvandirectVanLeasingSearch.php#45
      Bindings
      • 0: citroen
      • 1: e-berlingo-l2
      • 2: 1
      • 3: 1
      • 4: 1
      • 5: 0
      • 6: e-berlingo-xl
      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-BERLINGO L2' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'LCV' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
      770μsbrampacImagesRepository.php#66
      Bindings
      • 0: CITROEN
      • 1: e-BERLINGO L2
      • 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 `path`, `izmoAlias` from `images_backfill` where `ima_make` = 'CITROEN' and `ima_model` = 'e-BERLINGO L2' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'LCV' limit 1
      290μsbrampacImagesRepository.php#97
      Bindings
      • 0: CITROEN
      • 1: e-BERLINGO L2
      • 2: 
      • 3: 
      • 4: LCV
      Backtrace
      • 16. app/Queries/ImagesRepository.php:97
      • 17. app/Traits/VehicleImage.php:121
      • 18. app/Http/Controllers/VanLeasingController.php:133
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `model_cap` from `vandirect`.`vans` where `model` = 'e-BERLINGO L2' limit 1
      290μsbrampacImagesRepository.php#106
      Bindings
      • 0: e-BERLINGO L2
      Backtrace
      • 14. app/Queries/ImagesRepository.php:106
      • 18. app/Queries/ImagesRepository.php:102
      • 19. app/Traits/VehicleImage.php:121
      • 20. app/Http/Controllers/VanLeasingController.php:133
      • 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select `path`, `izmoAlias` from `images_backfill` where `ima_make` = 'CITROEN' and `ima_model` = (select `model_cap` from `vandirect`.`vans` where `model` = 'e-BERLINGO L2' limit 1) and `path` != '' and `izmoAlias` != '' and `ima_type` = 'LCV' limit 1
      370μsbrampacImagesRepository.php#111
      Bindings
      • 0: CITROEN
      • 1: e-BERLINGO L2
      • 2: 
      • 3: 
      • 4: LCV
      Backtrace
      • 16. app/Queries/ImagesRepository.php:111
      • 17. app/Traits/VehicleImage.php:121
      • 18. app/Http/Controllers/VanLeasingController.php:133
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `ipuser` from `lease_clicks` where (`make` = 'CITROEN' and `model` = 'e-BERLINGO L2' and `stamp` <= '2025-01-18' and `stamp` >= '2025-01-08' and `ipuser` != '' and `make_rule` = 0 and `robot_rule` = 0) group by `ipuser`
      18.36msvandirectVanLeaseClickRepository.php#105
      Bindings
      • 0: CITROEN
      • 1: e-BERLINGO L2
      • 2: 2025-01-18
      • 3: 2025-01-08
      • 4: 
      • 5: 0
      • 6: 0
      Backtrace
      • 15. app/Queries/VanLeaseClickRepository.php:105
      • 16. app/Queries/VanLeaseClickRepository.php:53
      • 17. app/Http/Controllers/VanLeasingController.php:136
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select COUNT(click_id) AS count, make, model from `lease_clicks` where 0 = 1 and (`make` != 'CITROEN' and `model` != 'e-BERLINGO L2' and `stamp` < '2025-01-18' and `stamp` >= '2025-01-08' and `make_rule` = 0 and `robot_rule` = 0) group by `model`, `make` order by `count` desc limit 5
      270μsvandirectVanLeaseClickRepository.php#77
      Bindings
      • 0: CITROEN
      • 1: e-BERLINGO L2
      • 2: 2025-01-18
      • 3: 2025-01-08
      • 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-berlingo-l2' and `model_long` = 'e-BERLINGO XL') order by `derivative` asc
      460μsvandirectVanModel.php#163
      Bindings
      • 0: citroen
      • 1: e-berlingo-l2
      • 2: e-BERLINGO XL
      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-berlingo-l2') and `model_long_slug` = 'e-berlingo-xl' limit 1
      5.73msvandirectVanLeasingSearch.php#234
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: 0
      • 4: citroen
      • 5: e-berlingo-l2
      • 6: e-berlingo-xl
      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
      110μ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
      160μ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` = 'e-berlingo-l2' and `did` = 160 and `live` = 1 and `capid` > 1 and `lease_live` = 1 and `price_monthly` > 0) and `model_long_slug` = 'e-berlingo-xl' order by `price_monthly` asc limit 1
      3.17msvandirectVanLeasingSearch.php#102
      Bindings
      • 0: citroen
      • 1: e-berlingo-l2
      • 2: 160
      • 3: 1
      • 4: 1
      • 5: 1
      • 6: 0
      • 7: e-berlingo-xl
      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-berlingo-l2' and `d_live` = 1 and `live` = 1 and `otrprice` > 4000 and `amount` > 0) order by `otrprice` asc limit 1
      510μsvandirectNewVanSearch.php#205
      Bindings
      • 0: citroen
      • 1: e-berlingo-l2
      • 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-berlingo-l2' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `model_long_slug` = 'e-berlingo-xl' order by `derivative` asc
      660μsvandirectVanLeaseFilter.php#69
      Bindings
      • 0: citroen
      • 1: e-berlingo-l2
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: e-berlingo-xl
      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-berlingo-l2' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `model_long_slug` = 'e-berlingo-xl' order by `fuel` asc
      640μsvandirectVanLeaseFilter.php#99
      Bindings
      • 0: citroen
      • 1: e-berlingo-l2
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: e-berlingo-xl
      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-berlingo-l2' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `model_long_slug` = 'e-berlingo-xl' order by `transmission` asc
      700μsvandirectVanLeaseFilter.php#114
      Bindings
      • 0: citroen
      • 1: e-berlingo-l2
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: e-berlingo-xl
      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` = 'e-berlingo-l2' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `model_long_slug` = 'e-berlingo-xl' and `term` in (6, 12, 18, 24, 36, 48, 60) order by `term` asc
      5.65msvandirectVanLeaseFilter.php#138
      Bindings
      • 0: citroen
      • 1: e-berlingo-l2
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: e-berlingo-xl
      • 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` = 'e-berlingo-l2' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `model_long_slug` = 'e-berlingo-xl' 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.69msvandirectVanLeaseFilter.php#153
      Bindings
      • 0: citroen
      • 1: e-berlingo-l2
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: e-berlingo-xl
      • 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` = 'e-berlingo-l2' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `model_long_slug` = 'e-berlingo-xl' 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.56msvandirectVanLeaseFilter.php#169
      Bindings
      • 0: citroen
      • 1: e-berlingo-l2
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: e-berlingo-xl
      • 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` = 'e-berlingo-l2' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `model_long_slug` = 'e-berlingo-xl' 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.7msvandirectVanLeaseFilter.php#193
      Bindings
      • 0: citroen
      • 1: e-berlingo-l2
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: e-berlingo-xl
      • 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` = 'e-berlingo-l2') group by `make`, `model`, `model_long`, `model_long_slug`, `make_slug`, `model_slug` order by `model_long` asc
      390μsvandirectVanModel.php#131
      Bindings
      • 0: citroen
      • 1: e-berlingo-l2
      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-berlingo-l2' and `d_live` = 1 and `live` = 1 and `otrprice` > 4000 and `amount` > 0 and `capid` > 1) and `model_long_slug` = 'e-berlingo-xl' order by `otrprice` asc limit 2
      640μsvandirectNewVanSearch.php#276
      Bindings
      • 0: citroen
      • 1: e-berlingo-l2
      • 2: 1
      • 3: 1
      • 4: 4000
      • 5: 0
      • 6: 1
      • 7: e-berlingo-xl
      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-berlingo-l2' and `d_live` = 1 and `live` = 1 and `otrprice` > 4000 and `amount` > 0 and `capid` > 1) order by `otrprice` asc limit 2
      500μsvandirectNewVanSearch.php#241
      Bindings
      • 0: citroen
      • 1: e-berlingo-l2
      • 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
    48Van.php#?
    App\Models\VanLeaseOffer
    31VanLeaseOffer.php#?
    App\Models\VanCusCar
    1VanCusCar.php#?
        _token
        ZvzrxhxumiKhUgHdEWSgmSSywDff3vG4YpInvg2g
        views
        2
        uid
        eb8619433d26a6bf276d6818234cbf98
        last_results_page
        /personal-car-leasing/fiat/500c/red/?fTrim=red&page=24&trimText=Red
        _previous
        array:1 [ "url" => "https://laravel.cars2buy.co.uk/van-leasing/citroen/e-berlingo-l2/e-berlingo-xl...
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /van-leasing/citroen/e-berlingo-l2/e-berlingo-xl/
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        0 of 0
        array:2 [ "page" => "56fVariant=e-berlingo-xl" "fVariant" => "e-berlingo-xl" ]
        request_request
        []
        
        request_headers
        0 of 0
        array:19 [ "cookie" => array:1 [ 0 => "uid=eyJpdiI6ImdrbkJXamw3Vjlkb3UySndyWVAzd3c9PSIsInZhbHVlIjoiR0MyN2k2SDM2aVIyQ1dPS1FhMWk3TkNobUxrZWxhbkN4aEpLd3VWN0Nrc1UrbllaMnp2WWJWa1RGMTgyVzBJeVNVZjJTWnFzcjdybWJ4RWlrcGp1dHh1b2tMMng3TzJIWDlRdHBHWmp2Rjg9IiwibWFjIjoiMTI4YjFkMDUxY2JlMTNhN2JlM2FmZjNlNzJkNjY0NjUxZGZhNTQwZmUzOWUzYTZlMDZiM2IxNjdjZmU5ZjYwZiIsInRhZyI6IiJ9; XSRF-TOKEN=eyJpdiI6Ii9YOXJ4QXYyY0FJb2U0T3V0SUlld1E9PSIsInZhbHVlIjoiNmtVZ21YaHd5RGs0QXlPL2daKzZjWkVmUDBjVVJCRFZoenNMZHhrcmJ5Q010TlVYaktJeDF2azNxV2FEM1pVZG1yMCs2VVNMdnZLcHNteFdIR0x4MlJKSlhod0FWNEdFKys1NjVyeDJ2QTJiWkZHeFc1N1JlQ0NmMFFldWlvalEiLCJtYWMiOiI5MDk1MGZjYTIyYjFkOGY4YjNmNTgyZTMwMjJhMzM0ZTE4ZTFkZDZiN2RhMjBmMzBjYzYyYWQ5MjE4MzM1NzRhIiwidGFnIjoiIn0%3D; laravel_session=eyJpdiI6Im1rMlJxLzlvNEtuc1FxSXR3cy9MMFE9PSIsInZhbHVlIjoiem91aUlKTTRFRjJTcU44MzczZFNSclRkSk5VazE1c2VZa1JneEpJSDIvZmFZc0QwdlRWUDF1OHk5ZGV3ZnVuWUVWU1VwaTVlamRFelA1NFMwMm9IcTFVUmY3TStnZ3JUM3lXM24rbEhtQ0VrcFJRcTl6ZGVnRnFRRzRrQ29uajEiLCJtYWMiOiIzNmExZDY2MDhhZGJmODlmN2U2OTNmYzQzZjRhOGE4MjIwZmM4MmE2YWM5NWNiNjVlNmI4NmJhYzcwNjE0MTkwIiwidGFnIjoiIn0%3D; _ga=GA1.1.1792685581.1737212939; _gcl_au=1.1.1674817938.1737212939; _ga_N9GLTHNRLQ=GS1.1.1737212938.1.0.1737212940.58.0.0uid=eyJpdiI6ImdrbkJXamw3Vjlkb3UySndyWVAzd3c9PSIsInZhbHVlIjoiR0MyN2k2SDM2aVIyQ1dPS1FhMWk3TkNobUxrZWxhbkN4aEpLd3VWN0Nrc1UrbllaMnp2WWJWa1RGMTgyVzBJeVNVZjJTWnFzcjdy" ] "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.226.226.136" ] "host" => array:1 [ 0 => "laravel.cars2buy.co.uk" ] ]
        request_cookies
        0 of 0
        array:6 [ "uid" => "eb8619433d26a6bf276d6818234cbf98" "XSRF-TOKEN" => "ZvzrxhxumiKhUgHdEWSgmSSywDff3vG4YpInvg2g" "laravel_session" => "uV3yjiVLz3eVuJirMFlU66wAT1vSMstpQjcomJEW" "_ga" => null "_gcl_au" => null "_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 => "Sat, 18 Jan 2025 15:09:02 GMT" ] "pragma" => array:1 [ 0 => "no-cache" ] "expires" => array:1 [ 0 => "-1" ] "set-cookie" => array:3 [ 0 => "uid=eyJpdiI6ImtjMVlDY2RHbE5URzRIaFZZMTRxSGc9PSIsInZhbHVlIjoiVkdWY2xjNHAzYnJ3Q0sxbzBGekp5NkZIRU91Z0x3Ym5KZ080WndPZ1pUcmJ0dE9ObVF1U2pFang3cUFjcVpyV1Jvd0thUWxtaVlhU2MrckhtN2xYTkJEZjZENHhiT2wydy9qV1doUnczTnM9IiwibWFjIjoiYTZiNGQxNWUzYTA0M2Y3YTc5MWY4MGEzNGJlMDk0MjlkOWE5M2JiYzhlY2RjOTJiYzFkODVkMjNkMjY2MDkyMSIsInRhZyI6IiJ9; expires=Tue, 16 Aug 5357 12:11:02 GMT; Max-Age=105165896520; path=/; secure; httponly; samesite=laxuid=eyJpdiI6ImtjMVlDY2RHbE5URzRIaFZZMTRxSGc9PSIsInZhbHVlIjoiVkdWY2xjNHAzYnJ3Q0sxbzBGekp5NkZIRU91Z0x3Ym5KZ080WndPZ1pUcmJ0dE9ObVF1U2pFang3cUFjcVpyV1Jvd0thUWxtaVlh" 1 => "XSRF-TOKEN=eyJpdiI6IndXem9YTU9GS3RCKzBJY04xcTYvQ2c9PSIsInZhbHVlIjoid1ptcGVsZU9YbEF2NU9nQjBrdGhTaytEVS83cVg5Z0VKVlB3NjUrV1E3RmhLeG1UMXpIUnhwNXZDZVB2eC9HUFZuVlZ0c25keitFTk51NDRpUHN3M1laeVhvODdTR3FVa3E4d1NOVzU4c1ZTWFhYQlhQNnpKZjV6QWo0NFBQK3UiLCJtYWMiOiI4MTFjZGJmMjRjMTJhMWVhZDUwMTMzNzczY2U2ZTBiNTM5MzFhODc2Y2RkNTY2NDZlMTJiYThhMmJjMWMwZjUwIiwidGFnIjoiIn0%3D; expires=Sat, 18 Jan 2025 17:09:02 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IndXem9YTU9GS3RCKzBJY04xcTYvQ2c9PSIsInZhbHVlIjoid1ptcGVsZU9YbEF2NU9nQjBrdGhTaytEVS83cVg5Z0VKVlB3NjUrV1E3RmhLeG1UMXpIUnhwNXZDZVB2eC9HUFZuVlZ0c" 2 => "laravel_session=eyJpdiI6Inh2cFpMNGd4ZmNIUU1wc3ludDhFMkE9PSIsInZhbHVlIjoiVlprVEFuUGVIYlVseW1iNUJvVy96ZkRkWXp3V1BXTkxIK2lSdHk0RGZleHhSajZkZGE1c29SdEtSZkYrL3RxcHNMT3FCUnpUZkd6eG8xdHFUcmlJNTFSYUdPMUg3d3h2YjV1RHpjU0psK0RQeVZwT2R0ZGFYTktWNkhuZVdMc1EiLCJtYWMiOiI0YmEwMWY4MjEwNGZkOWY2ZmVhYjliYjU2OWI1NjA4Y2RiMjA5YWE5ZDczNGExODUxZGFlMDZlMzc3ZmY5MmZhIiwidGFnIjoiIn0%3D; expires=Sat, 18 Jan 2025 17:09:02 GMT; Max-Age=7200; path=/; httponly; samesite=laxlaravel_session=eyJpdiI6Inh2cFpMNGd4ZmNIUU1wc3ludDhFMkE9PSIsInZhbHVlIjoiVlprVEFuUGVIYlVseW1iNUJvVy96ZkRkWXp3V1BXTkxIK2lSdHk0RGZleHhSajZkZGE1c29SdEtSZkYrL3RxcHNM" ] "Set-Cookie" => array:3 [ 0 => "uid=eyJpdiI6ImtjMVlDY2RHbE5URzRIaFZZMTRxSGc9PSIsInZhbHVlIjoiVkdWY2xjNHAzYnJ3Q0sxbzBGekp5NkZIRU91Z0x3Ym5KZ080WndPZ1pUcmJ0dE9ObVF1U2pFang3cUFjcVpyV1Jvd0thUWxtaVlhU2MrckhtN2xYTkJEZjZENHhiT2wydy9qV1doUnczTnM9IiwibWFjIjoiYTZiNGQxNWUzYTA0M2Y3YTc5MWY4MGEzNGJlMDk0MjlkOWE5M2JiYzhlY2RjOTJiYzFkODVkMjNkMjY2MDkyMSIsInRhZyI6IiJ9; expires=Tue, 16-Aug-5357 12:11:02 GMT; path=/; secure; httponlyuid=eyJpdiI6ImtjMVlDY2RHbE5URzRIaFZZMTRxSGc9PSIsInZhbHVlIjoiVkdWY2xjNHAzYnJ3Q0sxbzBGekp5NkZIRU91Z0x3Ym5KZ080WndPZ1pUcmJ0dE9ObVF1U2pFang3cUFjcVpyV1Jvd0thUWxtaVlh" 1 => "XSRF-TOKEN=eyJpdiI6IndXem9YTU9GS3RCKzBJY04xcTYvQ2c9PSIsInZhbHVlIjoid1ptcGVsZU9YbEF2NU9nQjBrdGhTaytEVS83cVg5Z0VKVlB3NjUrV1E3RmhLeG1UMXpIUnhwNXZDZVB2eC9HUFZuVlZ0c25keitFTk51NDRpUHN3M1laeVhvODdTR3FVa3E4d1NOVzU4c1ZTWFhYQlhQNnpKZjV6QWo0NFBQK3UiLCJtYWMiOiI4MTFjZGJmMjRjMTJhMWVhZDUwMTMzNzczY2U2ZTBiNTM5MzFhODc2Y2RkNTY2NDZlMTJiYThhMmJjMWMwZjUwIiwidGFnIjoiIn0%3D; expires=Sat, 18-Jan-2025 17:09:02 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IndXem9YTU9GS3RCKzBJY04xcTYvQ2c9PSIsInZhbHVlIjoid1ptcGVsZU9YbEF2NU9nQjBrdGhTaytEVS83cVg5Z0VKVlB3NjUrV1E3RmhLeG1UMXpIUnhwNXZDZVB2eC9HUFZuVlZ0c" 2 => "laravel_session=eyJpdiI6Inh2cFpMNGd4ZmNIUU1wc3ludDhFMkE9PSIsInZhbHVlIjoiVlprVEFuUGVIYlVseW1iNUJvVy96ZkRkWXp3V1BXTkxIK2lSdHk0RGZleHhSajZkZGE1c29SdEtSZkYrL3RxcHNMT3FCUnpUZkd6eG8xdHFUcmlJNTFSYUdPMUg3d3h2YjV1RHpjU0psK0RQeVZwT2R0ZGFYTktWNkhuZVdMc1EiLCJtYWMiOiI0YmEwMWY4MjEwNGZkOWY2ZmVhYjliYjU2OWI1NjA4Y2RiMjA5YWE5ZDczNGExODUxZGFlMDZlMzc3ZmY5MmZhIiwidGFnIjoiIn0%3D; expires=Sat, 18-Jan-2025 17:09:02 GMT; path=/; httponlylaravel_session=eyJpdiI6Inh2cFpMNGd4ZmNIUU1wc3ludDhFMkE9PSIsInZhbHVlIjoiVlprVEFuUGVIYlVseW1iNUJvVy96ZkRkWXp3V1BXTkxIK2lSdHk0RGZleHhSajZkZGE1c29SdEtSZkYrL3RxcHNM" ] ]
        session_attributes
        0 of 0
        array:7 [ "_token" => "ZvzrxhxumiKhUgHdEWSgmSSywDff3vG4YpInvg2g" "views" => 2 "uid" => "eb8619433d26a6bf276d6818234cbf98" "last_results_page" => "/personal-car-leasing/fiat/500c/red/?fTrim=red&page=24&trimText=Red" "_previous" => array:1 [ "url" => "https://laravel.cars2buy.co.uk/van-leasing/citroen/e-berlingo-l2/e-berlingo-xl?page=56fVariant%3De-berlingo-xl" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-01-18 15:09:02GET/van-leasing/citroen/e-berlingo-l2/e-berlingo-xl/?page=56fVariant%3De-berlingo-xl4142580