Fiat Doblo L2 Diesel 1.5 Multijet 100 H1 Van Primo Leasing Deals:

FIAT DOBLO L2

Page 1 of 26 pages

Prev Next

Compare Fiat Doblo L2 Diesel 1.5 Multijet 100 H1 Van Primo 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 Fiat van dealers and leasing companies. We advertise the cheapest Fiat Doblo L2 Diesel 1.5 Multijet 100 H1 Van Primo leases to ensure that you are getting the best deal available. If you are looking to lease a Fiat Doblo L2 Diesel 1.5 Multijet 100 H1 Van Primo then you have come to the right place!

Filter your results:

Lease details:

Van details:

Request history8.2.27PHP Version291msRequest Duration2MBMemory UsageGET van-leasing/{manufacturer}/{model}/{derivative}Route
  • warninglog[18:03:54] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[18:03:54] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[18:03:54] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[18:03:54] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • Booting (37.45ms)time
  • Application (254ms)time
  • 1 x Application (87.14%)
    254ms
    1 x Booting (12.86%)
    37.45ms
    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}/{derivative}
    middleware
    web
    controller
    App\Http\Controllers\VanLeasingController@results
    namespace
    where
    as
    van-leasing-results-derivative
    file
    app/Http/Controllers/VanLeasingController.php:109-190
    26 statements were executed74.85ms
    • 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` = 'fiat' and `model_slug` = 'doblo-l2' and `van_id` = '50241') and CONCAT_WS('-',model_long_slug,derivative_slug)='doblo-l2-diesel-1.5-multijet-100-h1-van-primo' limit 1
      1.09msvandirectController.php#346
      Bindings
      • 0: fiat
      • 1: doblo-l2
      • 2: 50241
      Backtrace
      • 15. app/Http/Controllers/Controller.php:346
      • 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` = 'fiat' and `model_slug` = 'doblo-l2' and `live` = 1 and `capid` > 1 and `lease_live` = 1 and `price_monthly` > 0) and `van_id` = '50241'
      1.55msvandirectVanLeasingSearch.php#45
      Bindings
      • 0: fiat
      • 1: doblo-l2
      • 2: 1
      • 3: 1
      • 4: 1
      • 5: 0
      • 6: 50241
      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` = 'fiat' and `model_slug` = 'doblo-l2' and `live` = 1 and `capid` > 1 and `lease_live` = 1 and `price_monthly` > 0) and `van_id` = '50241' order by price_monthly limit 10 offset 0
      1.97msvandirectVanLeasingSearch.php#45
      Bindings
      • 0: fiat
      • 1: doblo-l2
      • 2: 1
      • 3: 1
      • 4: 1
      • 5: 0
      • 6: 50241
      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` = 'FIAT' and `vandirect`.`vans`.`model` = 'DOBLO L2' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'LCV' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
      630μsbrampacImagesRepository.php#66
      Bindings
      • 0: FIAT
      • 1: DOBLO 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` = 'FIAT' and `ima_model` = 'DOBLO L2' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'LCV' limit 1
      270μsbrampacImagesRepository.php#97
      Bindings
      • 0: FIAT
      • 1: DOBLO 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` = 'DOBLO L2' limit 1
      260μsbrampacImagesRepository.php#106
      Bindings
      • 0: DOBLO 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` = 'FIAT' and `ima_model` = (select `model_cap` from `vandirect`.`vans` where `model` = 'DOBLO L2' limit 1) and `path` != '' and `izmoAlias` != '' and `ima_type` = 'LCV' limit 1
      350μsbrampacImagesRepository.php#111
      Bindings
      • 0: FIAT
      • 1: DOBLO 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` = 'FIAT' and `model` = 'DOBLO L2' and `stamp` <= '2025-01-23' and `stamp` >= '2025-01-13' and `ipuser` != '' and `make_rule` = 0 and `robot_rule` = 0) group by `ipuser`
      27.44msvandirectVanLeaseClickRepository.php#105
      Bindings
      • 0: FIAT
      • 1: DOBLO L2
      • 2: 2025-01-23
      • 3: 2025-01-13
      • 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 ('abe6821d8d41e9d3b496e7c04cf265cf') and (`make` != 'FIAT' and `model` != 'DOBLO L2' and `stamp` < '2025-01-23' and `stamp` >= '2025-01-13' and `make_rule` = 0 and `robot_rule` = 0) group by `model`, `make` order by `count` desc limit 5
      27.82msvandirectVanLeaseClickRepository.php#77
      Bindings
      • 0: abe6821d8d41e9d3b496e7c04cf265cf
      • 1: FIAT
      • 2: DOBLO L2
      • 3: 2025-01-23
      • 4: 2025-01-13
      • 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` = 'fiat' and `model_slug` = 'doblo-l2' and `model_long` = '') order by `derivative` asc
      330μsvandirectVanModel.php#163
      Bindings
      • 0: fiat
      • 1: doblo-l2
      • 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 `id_car` = '50241'
      1.95msvandirectVanLeasingSearch.php#225
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: 0
      • 4: 50241
      Backtrace
      • 15. app/Queries/VanLeasingSearch.php:225
      • 16. app/Http/Controllers/VanLeasingController.php:151
      • 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`, `make_slug` from `vans` order by `make` asc
      100μsvandirectVanManufacturer.php#16
      Backtrace
      • 15. app/Queries/VanManufacturer.php:16
      • 16. app/Http/Controllers/VanLeasingController.php:168
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select distinct `model`, `model_slug`, `make` from `vans` where `make_slug` = 'fiat' order by `model` asc
      100μsvandirectVanModel.php#26
      Bindings
      • 0: fiat
      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` = 'fiat' and `model_slug` = 'doblo-l2' and `did` = 160 and `live` = 1 and `capid` > 1 and `lease_live` = 1 and `price_monthly` > 0) and `van_id` = '50241' order by `price_monthly` asc limit 1
      1.05msvandirectVanLeasingSearch.php#102
      Bindings
      • 0: fiat
      • 1: doblo-l2
      • 2: 160
      • 3: 1
      • 4: 1
      • 5: 1
      • 6: 0
      • 7: 50241
      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` = 'fiat' and `model_slug` = 'doblo-l2' and `d_live` = 1 and `live` = 1 and `otrprice` > 4000 and `amount` > 0) order by `otrprice` asc limit 1
      500μsvandirectNewVanSearch.php#205
      Bindings
      • 0: fiat
      • 1: doblo-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` = 'fiat' and `model_slug` = 'doblo-l2' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `van_id` = '50241' order by `derivative` asc
      460μsvandirectVanLeaseFilter.php#69
      Bindings
      • 0: fiat
      • 1: doblo-l2
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: 50241
      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` = 'fiat' and `model_slug` = 'doblo-l2' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `van_id` = '50241' order by `fuel` asc
      420μsvandirectVanLeaseFilter.php#99
      Bindings
      • 0: fiat
      • 1: doblo-l2
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: 50241
      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` = 'fiat' and `model_slug` = 'doblo-l2' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `van_id` = '50241' order by `transmission` asc
      580μsvandirectVanLeaseFilter.php#114
      Bindings
      • 0: fiat
      • 1: doblo-l2
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: 50241
      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` = 'fiat' and `model_slug` = 'doblo-l2' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `van_id` = '50241' order by `model_long` asc
      540μsvandirectVanLeaseFilter.php#123
      Bindings
      • 0: fiat
      • 1: doblo-l2
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: 50241
      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` = 'fiat' and `model_slug` = 'doblo-l2' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `van_id` = '50241' and `term` in (6, 12, 18, 24, 36, 48, 60) order by `term` asc
      1.48msvandirectVanLeaseFilter.php#138
      Bindings
      • 0: fiat
      • 1: doblo-l2
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: 50241
      • 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` = 'fiat' and `model_slug` = 'doblo-l2' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `van_id` = '50241' 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
      1.53msvandirectVanLeaseFilter.php#153
      Bindings
      • 0: fiat
      • 1: doblo-l2
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: 50241
      • 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` = 'fiat' and `model_slug` = 'doblo-l2' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `van_id` = '50241' 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
      1.53msvandirectVanLeaseFilter.php#169
      Bindings
      • 0: fiat
      • 1: doblo-l2
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: 50241
      • 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` = 'fiat' and `model_slug` = 'doblo-l2' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `van_id` = '50241' 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
      1.53msvandirectVanLeaseFilter.php#193
      Bindings
      • 0: fiat
      • 1: doblo-l2
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: 50241
      • 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` = 'fiat' and `model_slug` = 'doblo-l2') group by `make`, `model`, `model_long`, `model_long_slug`, `make_slug`, `model_slug` order by `model_long` asc
      400μsvandirectVanModel.php#131
      Bindings
      • 0: fiat
      • 1: doblo-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` = 'fiat' and `model_slug` = 'doblo-l2' and `d_live` = 1 and `live` = 1 and `otrprice` > 4000 and `amount` > 0 and `capid` > 1) and `van_id` = '50241' order by `otrprice` asc limit 2
      510μsvandirectNewVanSearch.php#276
      Bindings
      • 0: fiat
      • 1: doblo-l2
      • 2: 1
      • 3: 1
      • 4: 4000
      • 5: 0
      • 6: 1
      • 7: 50241
      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` = 'fiat' and `model_slug` = 'doblo-l2' and `d_live` = 1 and `live` = 1 and `otrprice` > 4000 and `amount` > 0 and `capid` > 1) order by `otrprice` asc limit 2
      460μsvandirectNewVanSearch.php#241
      Bindings
      • 0: fiat
      • 1: doblo-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
    52Van.php#?
    App\Models\VanLeaseOffer
    29VanLeaseOffer.php#?
    App\Models\VanLeaseClick
    1VanLeaseClick.php#?
    App\Models\VanCusCar
    1VanCusCar.php#?
        _token
        zm5Y8QzXUTuHPTJp1X6hTRZXQkXfn2rePjRDmHw4
        views
        7
        uid
        39a15bc0dd8d5f17ad77db95d8b996da
        last_results_page
        /personal-car-leasing/mini/cooper-convertible/2.0-s-classic-level-2-2dr-auto_88815?fDerivative=2.0+S...
        _previous
        array:1 [ "url" => "https://laravel.cars2buy.co.uk/van-leasing/fiat/doblo-l2/doblo-l2-diesel-1.5-m...
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /van-leasing/fiat/doblo-l2/doblo-l2-diesel-1.5-multijet-100-h1-van-primo_50241
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        0 of 0
        array:3 [ "fDerivative" => "Doblo L2 Diesel 1.5 Multijet 100 H1 Van Primo" "page" => "9fCarID=50241" "fCarID" => "50241" ]
        request_request
        []
        
        request_headers
        0 of 0
        array:19 [ "cookie" => array:1 [ 0 => "uid=eyJpdiI6IitTdnZQT3R6dSt4MWtQNmlDMWJjY0E9PSIsInZhbHVlIjoiMG0vSFJDMGozVnNEekNrbDhGMXkyUWtabUowK3BCWFJmM2NSK25mNHJ2S1FjMXVqcDVFRkY4Yld1TDkrUGlYYndPQ0UxaklpTDFxSzBYUk9tMUVHUkRydWQ5RHllQzdiSEErZzFsYmZBdDg9IiwibWFjIjoiYzA4MDFhZTBkNGVjZDYzNDIyZTIwYjlhMWU2ODQwNWQ1YmI0MjY2YTcxOTRmNjUwN2I0NGU2ODRhMjdhYzg3ZSIsInRhZyI6IiJ9; XSRF-TOKEN=eyJpdiI6ImdKS3NoYjFPaWUzWEFjNmpEZmYwM1E9PSIsInZhbHVlIjoiKyt2ZXVETXUvbWsxYUZ3MnVCamh2cXJhODVIWkhrSUVwTmU5MjFEM0RHOWcvaEdIUW8vUmpHd3hBdkRQVmZVVEJPVStlbnlOckxLTlVFRHFNWFVtOUdUMy83UG1pckduZksvNGxFTThMZXZBM3lFNGpHWHBSY3dpdnVyV3FyVkQiLCJtYWMiOiIxOGEyMTI3NjFlOTVhYmYwMDhiNjYxMzgwYzQyYWJjNGQ0NDA3Nzc5NjIwNDdjOTYxNDhiZDMwMjU5MTg5MzBmIiwidGFnIjoiIn0%3D; laravel_session=eyJpdiI6IkM2Z1RvcmFrMFB6OGVKTzVZYzd0NWc9PSIsInZhbHVlIjoiNXdnTG9FcjdCYWlQWFM4TlZlVSs3dkNJeGxPQ21CQ081ZVo1MDErSUl5V3dOZy8xVTUydW1hM0FoQ3VXVWJmaFFmTGQ3TzY0N2ZFU09iSlJUeVhBYmZ2MUVUeXJtSEQ5UTZ0SUg5aFFNM3Bad2ZMd1F0TjRYc0lnTEhKMVA5Y00iLCJtYWMiOiJiYTM5OGI1NGFlNTBlOGU0ZTM0NjgzZTliMmVhNjcyZjA2NzBjNjllYzcyZTYyY2Q2OTYwOGU4ODAxNGUwZTFlIiwidGFnIjoiIn0%3Duid=eyJpdiI6IitTdnZQT3R6dSt4MWtQNmlDMWJjY0E9PSIsInZhbHVlIjoiMG0vSFJDMGozVnNEekNrbDhGMXkyUWtabUowK3BCWFJmM2NSK25mNHJ2S1FjMXVqcDVFRkY4Yld1TDkrUGlYYndPQ0UxaklpTDFx" ] "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.221.226.133" ] "host" => array:1 [ 0 => "laravel.cars2buy.co.uk" ] ]
        request_cookies
        0 of 0
        array:3 [ "uid" => "39a15bc0dd8d5f17ad77db95d8b996da" "XSRF-TOKEN" => "zm5Y8QzXUTuHPTJp1X6hTRZXQkXfn2rePjRDmHw4" "laravel_session" => "gVfMZ5Y6lXwhcenSDUdkTtB6cqqxftQLGi3nwg2c" ]
        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 => "Thu, 23 Jan 2025 18:03:54 GMT" ] "pragma" => array:1 [ 0 => "no-cache" ] "expires" => array:1 [ 0 => "-1" ] "set-cookie" => array:3 [ 0 => "uid=eyJpdiI6Ii9kUnlzRGRyRW9XMjNHWlkvQVo4OVE9PSIsInZhbHVlIjoiOVNxSTYySEZsajRUYTFvVTZsRUY2QkdoOEg2eUNCMEYwVU9yM3hEbkZQUTEwdWhMcGdUbWhSVkNvWm5NVjFpK0sxanp1QVhPbXNFeEVpcGQzY2d2TTFTdWZrbThQbktkNXA2QVcvT0QzTnM9IiwibWFjIjoiY2VkOWZjYzY2MjEwMzAyOGQ5MmNjZmRhMTM1ODdiMzJlYzY4Nzg3NDU3NzNlZGEwYjRiOTgyNDVlN2M1ZTJkZCIsInRhZyI6IiJ9; expires=Sat, 24 Jun 5358 21:57:54 GMT; Max-Age=105192446040; path=/; secure; httponly; samesite=laxuid=eyJpdiI6Ii9kUnlzRGRyRW9XMjNHWlkvQVo4OVE9PSIsInZhbHVlIjoiOVNxSTYySEZsajRUYTFvVTZsRUY2QkdoOEg2eUNCMEYwVU9yM3hEbkZQUTEwdWhMcGdUbWhSVkNvWm5NVjFpK0sxanp1QVhPbXNF" 1 => "XSRF-TOKEN=eyJpdiI6IkxmMEZ6MVNURnYxM3NGZCt4M3BoY1E9PSIsInZhbHVlIjoiUGdXWEQ4TmRMUlJ0TzlBREUwakN5a3BUSlZrbUVCVTRYSzAxQ1JBeFI2ZVB6RmJOendiQXhtQ29wclFhaGxCck9ETkdOSjBPVFFadEV6NExhVE5vRlVzUzlFY0E5RGZMdDFoWVZpdy9LVjFCY0t4YjBueWFzNzQyeEczUEJqYW4iLCJtYWMiOiI0MGI0MGJhNDZiZGZkNTkxOGE0NGFjM2NjZDcxODhlN2Y5YjlkY2QwMjliYjJjMzM2MTgzODZkMGE4OGI4ZGZiIiwidGFnIjoiIn0%3D; expires=Thu, 23 Jan 2025 20:03:54 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IkxmMEZ6MVNURnYxM3NGZCt4M3BoY1E9PSIsInZhbHVlIjoiUGdXWEQ4TmRMUlJ0TzlBREUwakN5a3BUSlZrbUVCVTRYSzAxQ1JBeFI2ZVB6RmJOendiQXhtQ29wclFhaGxCck9ETkdOS" 2 => "laravel_session=eyJpdiI6IlN2eXhNZkpZQ2RqU3Y2UGhxT0M2SlE9PSIsInZhbHVlIjoiUVRYa1hBYS9uMTZHUytqUmlZeHVFK3BhdUhJeUtEcU9MWUVERmp5dVdoWnVUdWdJWTVscGNyVHhpeVpsSkNXaVVrU1Zobk5RM0pIaGhvRlgxcUUyOWtSUzhaZUQ5empaa0U1YkZiUStFaUFnQ2piTW1SNi8xWVVWaVZFaWJublUiLCJtYWMiOiI1ZjIwMjJkNjQ1NzI5ZWZjMzM5ZDU2MGM2NmU0ZTMxODBkMWRjNDVlMjhiMzUzYjliNDY1Y2VjM2I3NDA2Y2Q2IiwidGFnIjoiIn0%3D; expires=Thu, 23 Jan 2025 20:03:54 GMT; Max-Age=7200; path=/; httponly; samesite=laxlaravel_session=eyJpdiI6IlN2eXhNZkpZQ2RqU3Y2UGhxT0M2SlE9PSIsInZhbHVlIjoiUVRYa1hBYS9uMTZHUytqUmlZeHVFK3BhdUhJeUtEcU9MWUVERmp5dVdoWnVUdWdJWTVscGNyVHhpeVpsSkNXaVVr" ] "Set-Cookie" => array:3 [ 0 => "uid=eyJpdiI6Ii9kUnlzRGRyRW9XMjNHWlkvQVo4OVE9PSIsInZhbHVlIjoiOVNxSTYySEZsajRUYTFvVTZsRUY2QkdoOEg2eUNCMEYwVU9yM3hEbkZQUTEwdWhMcGdUbWhSVkNvWm5NVjFpK0sxanp1QVhPbXNFeEVpcGQzY2d2TTFTdWZrbThQbktkNXA2QVcvT0QzTnM9IiwibWFjIjoiY2VkOWZjYzY2MjEwMzAyOGQ5MmNjZmRhMTM1ODdiMzJlYzY4Nzg3NDU3NzNlZGEwYjRiOTgyNDVlN2M1ZTJkZCIsInRhZyI6IiJ9; expires=Sat, 24-Jun-5358 21:57:54 GMT; path=/; secure; httponlyuid=eyJpdiI6Ii9kUnlzRGRyRW9XMjNHWlkvQVo4OVE9PSIsInZhbHVlIjoiOVNxSTYySEZsajRUYTFvVTZsRUY2QkdoOEg2eUNCMEYwVU9yM3hEbkZQUTEwdWhMcGdUbWhSVkNvWm5NVjFpK0sxanp1QVhPbXNF" 1 => "XSRF-TOKEN=eyJpdiI6IkxmMEZ6MVNURnYxM3NGZCt4M3BoY1E9PSIsInZhbHVlIjoiUGdXWEQ4TmRMUlJ0TzlBREUwakN5a3BUSlZrbUVCVTRYSzAxQ1JBeFI2ZVB6RmJOendiQXhtQ29wclFhaGxCck9ETkdOSjBPVFFadEV6NExhVE5vRlVzUzlFY0E5RGZMdDFoWVZpdy9LVjFCY0t4YjBueWFzNzQyeEczUEJqYW4iLCJtYWMiOiI0MGI0MGJhNDZiZGZkNTkxOGE0NGFjM2NjZDcxODhlN2Y5YjlkY2QwMjliYjJjMzM2MTgzODZkMGE4OGI4ZGZiIiwidGFnIjoiIn0%3D; expires=Thu, 23-Jan-2025 20:03:54 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IkxmMEZ6MVNURnYxM3NGZCt4M3BoY1E9PSIsInZhbHVlIjoiUGdXWEQ4TmRMUlJ0TzlBREUwakN5a3BUSlZrbUVCVTRYSzAxQ1JBeFI2ZVB6RmJOendiQXhtQ29wclFhaGxCck9ETkdOS" 2 => "laravel_session=eyJpdiI6IlN2eXhNZkpZQ2RqU3Y2UGhxT0M2SlE9PSIsInZhbHVlIjoiUVRYa1hBYS9uMTZHUytqUmlZeHVFK3BhdUhJeUtEcU9MWUVERmp5dVdoWnVUdWdJWTVscGNyVHhpeVpsSkNXaVVrU1Zobk5RM0pIaGhvRlgxcUUyOWtSUzhaZUQ5empaa0U1YkZiUStFaUFnQ2piTW1SNi8xWVVWaVZFaWJublUiLCJtYWMiOiI1ZjIwMjJkNjQ1NzI5ZWZjMzM5ZDU2MGM2NmU0ZTMxODBkMWRjNDVlMjhiMzUzYjliNDY1Y2VjM2I3NDA2Y2Q2IiwidGFnIjoiIn0%3D; expires=Thu, 23-Jan-2025 20:03:54 GMT; path=/; httponlylaravel_session=eyJpdiI6IlN2eXhNZkpZQ2RqU3Y2UGhxT0M2SlE9PSIsInZhbHVlIjoiUVRYa1hBYS9uMTZHUytqUmlZeHVFK3BhdUhJeUtEcU9MWUVERmp5dVdoWnVUdWdJWTVscGNyVHhpeVpsSkNXaVVr" ] ]
        session_attributes
        0 of 0
        array:7 [ "_token" => "zm5Y8QzXUTuHPTJp1X6hTRZXQkXfn2rePjRDmHw4" "views" => 7 "uid" => "39a15bc0dd8d5f17ad77db95d8b996da" "last_results_page" => "/personal-car-leasing/mini/cooper-convertible/2.0-s-classic-level-2-2dr-auto_88815?fDerivative=2.0+S+Classic+Level+2+2dr+Auto&page=30page%3D29" "_previous" => array:1 [ "url" => "https://laravel.cars2buy.co.uk/van-leasing/fiat/doblo-l2/doblo-l2-diesel-1.5-multijet-100-h1-van-primo_50241?fDerivative=Doblo%20L2%20Diesel%201.5%20Multijet%20100%20H1%20Van%20Primo&page=9fCarID%3D50241https://laravel.cars2buy.co.uk/van-leasing/fiat/doblo-l2/doblo-l2-diesel-1.5-multijet-100-h1-van-primo_50241?fDerivative=Doblo%20L2%20Diesel%201.5%20Multijet%20" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-01-23 18:03:54GET/van-leasing/fiat/doblo-l2/doblo-l2-diesel-1.5-multijet-100-h1-van-primo_50241?fDerivative=Doblo+L2+Diesel+1.5+Multijet+100+H1+Van+Primo&page=9fCarID%3D502414142683