Citroen Berlingo L1 Leasing Deals:

CITROEN BERLINGO L1

Page 170 of 241 pages

Filter your results:

Lease details:

Van details:

Citroen Berlingo L1 variants:

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

Filter your results:

Lease details:

Van details:

Request history8.2.27PHP Version313msRequest Duration2MBMemory UsageGET van-leasing/{manufacturer}/{model}Route
  • warninglog[15:03:23] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[15:03:23] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[15:03:23] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[15:03:23] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[15:03:23] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[15:03:23] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • Booting (36.77ms)time
  • Application (277ms)time
  • 1 x Application (88.27%)
    277ms
    1 x Booting (11.73%)
    36.77ms
    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
    22 statements were executed125ms
    • 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` = 'berlingo-l1') limit 1
      960μsvandirectController.php#434
      Bindings
      • 0: citroen
      • 1: berlingo-l1
      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` = 'berlingo-l1' and `live` = 1 and `capid` > 1 and `lease_live` = 1 and `price_monthly` > 0)
      10.93msvandirectVanLeasingSearch.php#45
      Bindings
      • 0: citroen
      • 1: berlingo-l1
      • 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` = 'berlingo-l1' and `live` = 1 and `capid` > 1 and `lease_live` = 1 and `price_monthly` > 0) order by price_monthly limit 10 offset 1690
      15.46msvandirectVanLeasingSearch.php#45
      Bindings
      • 0: citroen
      • 1: berlingo-l1
      • 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` = 'BERLINGO L1' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'LCV' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
      800μsbrampacImagesRepository.php#66
      Bindings
      • 0: CITROEN
      • 1: BERLINGO L1
      • 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` = 'BERLINGO L1' and `stamp` <= '2025-01-18' and `stamp` >= '2025-01-08' and `ipuser` != '' and `make_rule` = 0 and `robot_rule` = 0) group by `ipuser`
      17.68msvandirectVanLeaseClickRepository.php#105
      Bindings
      • 0: CITROEN
      • 1: BERLINGO L1
      • 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 `ipuser` in ('66303f20b42d0f90cbf477181fb9fb6a') and (`make` != 'CITROEN' and `model` != 'BERLINGO L1' 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
      17.41msvandirectVanLeaseClickRepository.php#77
      Bindings
      • 0: 66303f20b42d0f90cbf477181fb9fb6a
      • 1: CITROEN
      • 2: BERLINGO L1
      • 3: 2025-01-18
      • 4: 2025-01-08
      • 5: 0
      • 6: 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` = 'berlingo-l1' and `model_long` = '') order by `derivative` asc
      450μsvandirectVanModel.php#163
      Bindings
      • 0: citroen
      • 1: berlingo-l1
      • 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` = 'berlingo-l1') limit 1
      10.35msvandirectVanLeasingSearch.php#234
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: 0
      • 4: citroen
      • 5: berlingo-l1
      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
      120μ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
      820μ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` = 'berlingo-l1' and `did` = 160 and `live` = 1 and `capid` > 1 and `lease_live` = 1 and `price_monthly` > 0) order by `price_monthly` asc limit 1
      5.56msvandirectVanLeasingSearch.php#102
      Bindings
      • 0: citroen
      • 1: berlingo-l1
      • 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` = 'berlingo-l1' and `d_live` = 1 and `live` = 1 and `otrprice` > 4000 and `amount` > 0) order by `otrprice` asc limit 1
      470μsvandirectNewVanSearch.php#205
      Bindings
      • 0: citroen
      • 1: berlingo-l1
      • 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` = 'berlingo-l1' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) order by `derivative` asc
      540μsvandirectVanLeaseFilter.php#69
      Bindings
      • 0: citroen
      • 1: berlingo-l1
      • 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` = 'berlingo-l1' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) order by `fuel` asc
      480μsvandirectVanLeaseFilter.php#99
      Bindings
      • 0: citroen
      • 1: berlingo-l1
      • 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` = 'berlingo-l1' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) order by `transmission` asc
      500μsvandirectVanLeaseFilter.php#114
      Bindings
      • 0: citroen
      • 1: berlingo-l1
      • 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` = 'berlingo-l1' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) order by `model_long` asc
      520μsvandirectVanLeaseFilter.php#123
      Bindings
      • 0: citroen
      • 1: berlingo-l1
      • 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` = 'berlingo-l1' 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
      10.11msvandirectVanLeaseFilter.php#138
      Bindings
      • 0: citroen
      • 1: berlingo-l1
      • 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` = 'berlingo-l1' 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
      10.09msvandirectVanLeaseFilter.php#153
      Bindings
      • 0: citroen
      • 1: berlingo-l1
      • 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` = 'berlingo-l1' 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
      10.2msvandirectVanLeaseFilter.php#169
      Bindings
      • 0: citroen
      • 1: berlingo-l1
      • 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` = 'berlingo-l1' 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
      10.31msvandirectVanLeaseFilter.php#193
      Bindings
      • 0: citroen
      • 1: berlingo-l1
      • 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` = 'berlingo-l1') group by `make`, `model`, `model_long`, `model_long_slug`, `make_slug`, `model_slug` order by `model_long` asc
      350μsvandirectVanModel.php#131
      Bindings
      • 0: citroen
      • 1: berlingo-l1
      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` = 'berlingo-l1' and `d_live` = 1 and `live` = 1 and `otrprice` > 4000 and `amount` > 0 and `capid` > 1) order by `otrprice` asc limit 2
      530μsvandirectNewVanSearch.php#276
      Bindings
      • 0: citroen
      • 1: berlingo-l1
      • 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
    App\Models\Van
    46Van.php#?
    App\Models\VanLeaseOffer
    37VanLeaseOffer.php#?
    App\Models\VanCusCar
    3VanCusCar.php#?
    App\Models\VanLeaseClick
    1VanLeaseClick.php#?
        _token
        Aq9dzgBgCfSUpVvtZbEFHdlf26kM0qZoIMIyyNuq
        views
        1
        uid
        e75fed87aeb4ed70c3c0aab423b7d9d1
        _previous
        array:1 [ "url" => "https://laravel.cars2buy.co.uk/van-leasing/citroen/berlingo-l1?page=170" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /van-leasing/citroen/berlingo-l1/
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        0 of 0
        array:1 [ "page" => "170" ]
        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 => "3.149.255.239" ] "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 => "Sat, 18 Jan 2025 15:03:23 GMT" ] "pragma" => array:1 [ 0 => "no-cache" ] "expires" => array:1 [ 0 => "-1" ] "set-cookie" => array:3 [ 0 => "uid=eyJpdiI6ImpiZkRneGRqY243YTRzU043dmc5akE9PSIsInZhbHVlIjoiOHpYVVNrcmJ1b0ZrTndVdlBLei8wTC8yUkM5ZWYzRi9PaEkrT2dFSEpSaEpBMmRrM0lBUVRUeVhpYWR6SDZ1Vk5EUnhWOXovemhsdzJ4UXBvdnhua0pPSFJpT0NMZG5ka0lRNy8wUEhHUDQ9IiwibWFjIjoiNTFlZmEyZDA5NzBjYThkYzEwZGM0NWI0NzI2NzBjMWJlY2NjOTJmMzc3ZjY0NjYzYjdiMjYzMDllMTY0Y2JmOSIsInRhZyI6IiJ9; expires=Tue, 16 Aug 5357 06:26:23 GMT; Max-Age=105165876180; path=/; secure; httponly; samesite=laxuid=eyJpdiI6ImpiZkRneGRqY243YTRzU043dmc5akE9PSIsInZhbHVlIjoiOHpYVVNrcmJ1b0ZrTndVdlBLei8wTC8yUkM5ZWYzRi9PaEkrT2dFSEpSaEpBMmRrM0lBUVRUeVhpYWR6SDZ1Vk5EUnhWOXovemhs" 1 => "XSRF-TOKEN=eyJpdiI6Ink3RDNyaGtKUmtkMFhybzJpR1ZSOUE9PSIsInZhbHVlIjoiTStGWGVab0hZVUFQdm9SeFJ0cWZvb1FXTmhrY24zZzUybVZ5ZFRPR1ZQNVUvbW1PWkxqSkNITG5SSENSNy8vR3N1UklGL3dTMzRhakxzVmUzd082R3lCSVdjRnRQWlNyVk0rUGo1ZFRyWDR6S0Y5QW9wVGxVR0QzVXNQemQvakQiLCJtYWMiOiJlMjQ2NjMzMzdmMDA1NTBjZjU3YmYwNGU4Mjc0NTY4OTEzNDI2MmVhMjc0M2JmODA1NmRjM2JiMTEzN2U2ZmQzIiwidGFnIjoiIn0%3D; expires=Sat, 18 Jan 2025 17:03:23 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6Ink3RDNyaGtKUmtkMFhybzJpR1ZSOUE9PSIsInZhbHVlIjoiTStGWGVab0hZVUFQdm9SeFJ0cWZvb1FXTmhrY24zZzUybVZ5ZFRPR1ZQNVUvbW1PWkxqSkNITG5SSENSNy8vR3N1UklGL" 2 => "laravel_session=eyJpdiI6IlJ0aXhWU1U0ZTI0YnV1MkoyMFFDcWc9PSIsInZhbHVlIjoiNjhic3RTS1lpVitGakYwUnZRTUVIK3FGWTRta21KR3A0YVF1a3hDZHRFQ01qTTBoYlpBT0NwRGx1d0J2VzVFaVNrY0p1eHpsaHhhSmo1V1loV1ZycGZzZW5qRU5oNTgxQi8yRHpqVWh1RTgyaExWUmN3cWZkNnlKNldyeE4rcGciLCJtYWMiOiIyZTdhZjgyYTZiMTNmZjQ0OTYzNDc1YTM0ZTBiODZlYWZjMzhkMjM4MmRhZDA1ZTM4NmRkMjEzMjM3M2Q1OGE2IiwidGFnIjoiIn0%3D; expires=Sat, 18 Jan 2025 17:03:23 GMT; Max-Age=7200; path=/; httponly; samesite=laxlaravel_session=eyJpdiI6IlJ0aXhWU1U0ZTI0YnV1MkoyMFFDcWc9PSIsInZhbHVlIjoiNjhic3RTS1lpVitGakYwUnZRTUVIK3FGWTRta21KR3A0YVF1a3hDZHRFQ01qTTBoYlpBT0NwRGx1d0J2VzVFaVNr" ] "Set-Cookie" => array:3 [ 0 => "uid=eyJpdiI6ImpiZkRneGRqY243YTRzU043dmc5akE9PSIsInZhbHVlIjoiOHpYVVNrcmJ1b0ZrTndVdlBLei8wTC8yUkM5ZWYzRi9PaEkrT2dFSEpSaEpBMmRrM0lBUVRUeVhpYWR6SDZ1Vk5EUnhWOXovemhsdzJ4UXBvdnhua0pPSFJpT0NMZG5ka0lRNy8wUEhHUDQ9IiwibWFjIjoiNTFlZmEyZDA5NzBjYThkYzEwZGM0NWI0NzI2NzBjMWJlY2NjOTJmMzc3ZjY0NjYzYjdiMjYzMDllMTY0Y2JmOSIsInRhZyI6IiJ9; expires=Tue, 16-Aug-5357 06:26:23 GMT; path=/; secure; httponlyuid=eyJpdiI6ImpiZkRneGRqY243YTRzU043dmc5akE9PSIsInZhbHVlIjoiOHpYVVNrcmJ1b0ZrTndVdlBLei8wTC8yUkM5ZWYzRi9PaEkrT2dFSEpSaEpBMmRrM0lBUVRUeVhpYWR6SDZ1Vk5EUnhWOXovemhs" 1 => "XSRF-TOKEN=eyJpdiI6Ink3RDNyaGtKUmtkMFhybzJpR1ZSOUE9PSIsInZhbHVlIjoiTStGWGVab0hZVUFQdm9SeFJ0cWZvb1FXTmhrY24zZzUybVZ5ZFRPR1ZQNVUvbW1PWkxqSkNITG5SSENSNy8vR3N1UklGL3dTMzRhakxzVmUzd082R3lCSVdjRnRQWlNyVk0rUGo1ZFRyWDR6S0Y5QW9wVGxVR0QzVXNQemQvakQiLCJtYWMiOiJlMjQ2NjMzMzdmMDA1NTBjZjU3YmYwNGU4Mjc0NTY4OTEzNDI2MmVhMjc0M2JmODA1NmRjM2JiMTEzN2U2ZmQzIiwidGFnIjoiIn0%3D; expires=Sat, 18-Jan-2025 17:03:23 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6Ink3RDNyaGtKUmtkMFhybzJpR1ZSOUE9PSIsInZhbHVlIjoiTStGWGVab0hZVUFQdm9SeFJ0cWZvb1FXTmhrY24zZzUybVZ5ZFRPR1ZQNVUvbW1PWkxqSkNITG5SSENSNy8vR3N1UklGL" 2 => "laravel_session=eyJpdiI6IlJ0aXhWU1U0ZTI0YnV1MkoyMFFDcWc9PSIsInZhbHVlIjoiNjhic3RTS1lpVitGakYwUnZRTUVIK3FGWTRta21KR3A0YVF1a3hDZHRFQ01qTTBoYlpBT0NwRGx1d0J2VzVFaVNrY0p1eHpsaHhhSmo1V1loV1ZycGZzZW5qRU5oNTgxQi8yRHpqVWh1RTgyaExWUmN3cWZkNnlKNldyeE4rcGciLCJtYWMiOiIyZTdhZjgyYTZiMTNmZjQ0OTYzNDc1YTM0ZTBiODZlYWZjMzhkMjM4MmRhZDA1ZTM4NmRkMjEzMjM3M2Q1OGE2IiwidGFnIjoiIn0%3D; expires=Sat, 18-Jan-2025 17:03:23 GMT; path=/; httponlylaravel_session=eyJpdiI6IlJ0aXhWU1U0ZTI0YnV1MkoyMFFDcWc9PSIsInZhbHVlIjoiNjhic3RTS1lpVitGakYwUnZRTUVIK3FGWTRta21KR3A0YVF1a3hDZHRFQ01qTTBoYlpBT0NwRGx1d0J2VzVFaVNr" ] ]
        session_attributes
        0 of 0
        array:6 [ "_token" => "Aq9dzgBgCfSUpVvtZbEFHdlf26kM0qZoIMIyyNuq" "views" => 1 "uid" => "e75fed87aeb4ed70c3c0aab423b7d9d1" "_previous" => array:1 [ "url" => "https://laravel.cars2buy.co.uk/van-leasing/citroen/berlingo-l1?page=170" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-01-18 15:03:23GET/van-leasing/citroen/berlingo-l1/?page=1706142287