Citroen Berlingo M Petrol Leasing Deals:

CITROEN BERLINGO M

Page 29 of 45 pages

Citroen Berlingo M variants:

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

Filter your results:

Lease details:

Van details:

Request history8.2.27PHP Version273msRequest Duration2MBMemory UsageGET van-leasing/{manufacturer}/{model}/{variant}Route
  • warninglog[20:23:10] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[20:23:10] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[20:23:10] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[20:23:10] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[20:23:10] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[20:23:10] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[20:23:10] LOG.warning: round(): Passing null to parameter #1 ($num) of type int|float is deprecated...
  • warninglog[20:23:10] LOG.warning: round(): Passing null to parameter #1 ($num) of type int|float is deprecated...
  • Booting (39.46ms)time
  • Application (233ms)time
  • 1 x Application (85.53%)
    233ms
    1 x Booting (14.47%)
    39.46ms
    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
    22 statements were executed79.91ms
    • 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-m' and `model_long_slug` = 'berlingo-m-petrol') limit 1
      1.35msvandirectController.php#385
      Bindings
      • 0: citroen
      • 1: berlingo-m
      • 2: berlingo-m-petrol
      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` = 'berlingo-m' and `live` = 1 and `capid` > 1 and `lease_live` = 1 and `price_monthly` > 0) and `model_long_slug` = 'berlingo-m-petrol'
      2.99msvandirectVanLeasingSearch.php#45
      Bindings
      • 0: citroen
      • 1: berlingo-m
      • 2: 1
      • 3: 1
      • 4: 1
      • 5: 0
      • 6: berlingo-m-petrol
      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-m' and `live` = 1 and `capid` > 1 and `lease_live` = 1 and `price_monthly` > 0) and `model_long_slug` = 'berlingo-m-petrol' order by price_monthly limit 10 offset 280
      3.76msvandirectVanLeasingSearch.php#45
      Bindings
      • 0: citroen
      • 1: berlingo-m
      • 2: 1
      • 3: 1
      • 4: 1
      • 5: 0
      • 6: berlingo-m-petrol
      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 M' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'LCV' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
      1.11msbrampacImagesRepository.php#66
      Bindings
      • 0: CITROEN
      • 1: BERLINGO M
      • 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 M' and `stamp` <= '2025-01-21' and `stamp` >= '2025-01-11' and `ipuser` != '' and `make_rule` = 0 and `robot_rule` = 0) group by `ipuser`
      24.44msvandirectVanLeaseClickRepository.php#105
      Bindings
      • 0: CITROEN
      • 1: BERLINGO M
      • 2: 2025-01-21
      • 3: 2025-01-11
      • 4: 
      • 5: 0
      • 6: 0
      Backtrace
      • 15. app/Queries/VanLeaseClickRepository.php:105
      • 16. app/Queries/VanLeaseClickRepository.php:53
      • 17. app/Http/Controllers/VanLeasingController.php:136
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select COUNT(click_id) AS count, make, model from `lease_clicks` where `ipuser` in ('00b1514a773894e8d3f05f8e8ff7bfbe', '020332c1c6a07d0720920c43ba948d7b', '027a4035ca216751993135a8f9ffcaaf', '02a6022494a4b34747bb473821d60cc2', '0352955cd635f2e24ff6a773336a3d66', '03d0db7885917c4f864c8c5cf4c0573d', '0493df022eabf27c1e9d0038354ece4c', '0796dbabb593d75dd113e0fc776b47c8', '09a96438c51e32f6786cd778211b9445', '0a4baf518b135ccf5adf32de3c456dbf', '0ca0aa35c596e739b29327e13f70952f', '0f24c89e9268d59fc2c8ba4e26a3c987', '140cdb6ad219eae47e2eea3ea7e2f618', '1cce4d3bca87f8545fcaf04758fef979', '1d2ad911a26eba97ce02aba806c42a68', '201948f362f02df1a034a23ebc72597c', '27371b183b31bfe206b8c92abaef5e27', '2da619b72aa2809254439fd0a258ba62', '3352789d7b8f4c289b79aaf36e728cdb', '40a8d6082e98e8e788d31dad614928ab', '41f7486ba4a0ffdab75388ba0f6f2699', '42d168ed1a34401baa047a96b367c205', '508dd29d4d877e2e841e3045636a1abf', '58e832a56eb6ad90cad93035e1e8ddf5', '5ae78a4899e47c4627eaa392903d6a02', '5b4fb15321024cf0ea3daeba93cdab9e', '644491a2e00ad00fb49ff363c1220a10', '6594eea6f7179807cadf561cb07815c4', '671341ba11f370734087d927ab3bd93f', '6916498059a545c47ebbed261da3091c', '6b34644543c5d3231a8426697293791a', '6c07a4d92434ea601a79d1763bc0c43b', '6cf457459613fc7df60ac8ad0ecd8f0e', '77c975f7cde7975964ea406fbc739eb9', '79bc9dfe0ff5b4b0c093b2db5c11f161', '81b2fbfc014f4d0603f8c9b1ec8b644c', '84d13db6228fd63cdff1139e2e293101', '87364c97587555c970e27cac210a3570', '87aa59d96ad182b126831c8692c45066', '87bccf14c1f2d3e5c723e34ae0387579', '8dd843dce7b2b439dba4434b21728983', '9581dbde899fe12f7dc1d0f7b68ce706', '982903a6e315b6036e7c7d6b78178ddb', '9a8e9e612a25622b45f64413c082a961', '9eda0e68b15a551b4eed67f682c62ee3', 'a1cdf7453dae5262bb53c31d87721f9c', 'a9eaad9a9a21a47b4157d43d35cb4911', 'add5b6565b07749a906bdd930442c677', 'b4370c33ffa5b58cfd874a43b2f0f9c5', 'b466b3cd13b7eb5ac67e350e55e3d235', 'b72740f265d3cddf012c814247a86b3a', 'b80e8aee4ca6792de06b95be542ef86b', 'b9c7ee5e57a7805ffca82526dc009c7b', 'bfc22e50c226b3723a11653a7ef0c3e7', 'c025f291d65c2120e91fae389d19c5b1', 'c24921652d8335f0a5a85a29ea72d7a4', 'c38dc1431a542ea74d846e3d084d0665', 'c560d0e6f1c32a13c12945bef65fc421', 'd0098d835c0e130b820704a39d916ab1', 'd98a2b178749e55d51b65c53067e5c9e', 'de0b0d95dd2b7932190bea76b62056ec', 'e17220a7879fb2439f737672dba2bc24', 'ea15897d01e3cbafbb1cb52a4a89a40d', 'ea2793992a99b66deba69bf58b5c86ff', 'f10580ebca6a38287bd17578630ddd7a', 'f1dd0d645bd8d2fbab97fa5180b10b89', 'f4ef1cf15d3618b1dd7ffd1d98095891') and (`make` != 'CITROEN' and `model` != 'BERLINGO M' and `stamp` < '2025-01-21' and `stamp` >= '2025-01-11' and `make_rule` = 0 and `robot_rule` = 0) group by `model`, `make` order by `count` desc limit 5
      24.09msvandirectVanLeaseClickRepository.php#77
      Bindings
      • 0: 00b1514a773894e8d3f05f8e8ff7bfbe
      • 1: 020332c1c6a07d0720920c43ba948d7b
      • 2: 027a4035ca216751993135a8f9ffcaaf
      • 3: 02a6022494a4b34747bb473821d60cc2
      • 4: 0352955cd635f2e24ff6a773336a3d66
      • 5: 03d0db7885917c4f864c8c5cf4c0573d
      • 6: 0493df022eabf27c1e9d0038354ece4c
      • 7: 0796dbabb593d75dd113e0fc776b47c8
      • 8: 09a96438c51e32f6786cd778211b9445
      • 9: 0a4baf518b135ccf5adf32de3c456dbf
      • 10: 0ca0aa35c596e739b29327e13f70952f
      • 11: 0f24c89e9268d59fc2c8ba4e26a3c987
      • 12: 140cdb6ad219eae47e2eea3ea7e2f618
      • 13: 1cce4d3bca87f8545fcaf04758fef979
      • 14: 1d2ad911a26eba97ce02aba806c42a68
      • 15: 201948f362f02df1a034a23ebc72597c
      • 16: 27371b183b31bfe206b8c92abaef5e27
      • 17: 2da619b72aa2809254439fd0a258ba62
      • 18: 3352789d7b8f4c289b79aaf36e728cdb
      • 19: 40a8d6082e98e8e788d31dad614928ab
      • 20: 41f7486ba4a0ffdab75388ba0f6f2699
      • 21: 42d168ed1a34401baa047a96b367c205
      • 22: 508dd29d4d877e2e841e3045636a1abf
      • 23: 58e832a56eb6ad90cad93035e1e8ddf5
      • 24: 5ae78a4899e47c4627eaa392903d6a02
      • 25: 5b4fb15321024cf0ea3daeba93cdab9e
      • 26: 644491a2e00ad00fb49ff363c1220a10
      • 27: 6594eea6f7179807cadf561cb07815c4
      • 28: 671341ba11f370734087d927ab3bd93f
      • 29: 6916498059a545c47ebbed261da3091c
      • 30: 6b34644543c5d3231a8426697293791a
      • 31: 6c07a4d92434ea601a79d1763bc0c43b
      • 32: 6cf457459613fc7df60ac8ad0ecd8f0e
      • 33: 77c975f7cde7975964ea406fbc739eb9
      • 34: 79bc9dfe0ff5b4b0c093b2db5c11f161
      • 35: 81b2fbfc014f4d0603f8c9b1ec8b644c
      • 36: 84d13db6228fd63cdff1139e2e293101
      • 37: 87364c97587555c970e27cac210a3570
      • 38: 87aa59d96ad182b126831c8692c45066
      • 39: 87bccf14c1f2d3e5c723e34ae0387579
      • 40: 8dd843dce7b2b439dba4434b21728983
      • 41: 9581dbde899fe12f7dc1d0f7b68ce706
      • 42: 982903a6e315b6036e7c7d6b78178ddb
      • 43: 9a8e9e612a25622b45f64413c082a961
      • 44: 9eda0e68b15a551b4eed67f682c62ee3
      • 45: a1cdf7453dae5262bb53c31d87721f9c
      • 46: a9eaad9a9a21a47b4157d43d35cb4911
      • 47: add5b6565b07749a906bdd930442c677
      • 48: b4370c33ffa5b58cfd874a43b2f0f9c5
      • 49: b466b3cd13b7eb5ac67e350e55e3d235
      • 50: b72740f265d3cddf012c814247a86b3a
      • 51: b80e8aee4ca6792de06b95be542ef86b
      • 52: b9c7ee5e57a7805ffca82526dc009c7b
      • 53: bfc22e50c226b3723a11653a7ef0c3e7
      • 54: c025f291d65c2120e91fae389d19c5b1
      • 55: c24921652d8335f0a5a85a29ea72d7a4
      • 56: c38dc1431a542ea74d846e3d084d0665
      • 57: c560d0e6f1c32a13c12945bef65fc421
      • 58: d0098d835c0e130b820704a39d916ab1
      • 59: d98a2b178749e55d51b65c53067e5c9e
      • 60: de0b0d95dd2b7932190bea76b62056ec
      • 61: e17220a7879fb2439f737672dba2bc24
      • 62: ea15897d01e3cbafbb1cb52a4a89a40d
      • 63: ea2793992a99b66deba69bf58b5c86ff
      • 64: f10580ebca6a38287bd17578630ddd7a
      • 65: f1dd0d645bd8d2fbab97fa5180b10b89
      • 66: f4ef1cf15d3618b1dd7ffd1d98095891
      • 67: CITROEN
      • 68: BERLINGO M
      • 69: 2025-01-21
      • 70: 2025-01-11
      • 71: 0
      • 72: 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-m' and `model_long` = 'BERLINGO M PETROL') order by `derivative` asc
      490μsvandirectVanModel.php#163
      Bindings
      • 0: citroen
      • 1: berlingo-m
      • 2: BERLINGO M PETROL
      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-m') and `model_long_slug` = 'berlingo-m-petrol' limit 1
      2.8msvandirectVanLeasingSearch.php#234
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: 0
      • 4: citroen
      • 5: berlingo-m
      • 6: berlingo-m-petrol
      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
      160μ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
      770μ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-m' and `did` = 160 and `live` = 1 and `capid` > 1 and `lease_live` = 1 and `price_monthly` > 0) and `model_long_slug` = 'berlingo-m-petrol' order by `price_monthly` asc limit 1
      1.95msvandirectVanLeasingSearch.php#102
      Bindings
      • 0: citroen
      • 1: berlingo-m
      • 2: 160
      • 3: 1
      • 4: 1
      • 5: 1
      • 6: 0
      • 7: berlingo-m-petrol
      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-m' and `d_live` = 1 and `live` = 1 and `otrprice` > 4000 and `amount` > 0) order by `otrprice` asc limit 1
      610μsvandirectNewVanSearch.php#205
      Bindings
      • 0: citroen
      • 1: berlingo-m
      • 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-m' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `model_long_slug` = 'berlingo-m-petrol' order by `derivative` asc
      770μsvandirectVanLeaseFilter.php#69
      Bindings
      • 0: citroen
      • 1: berlingo-m
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: berlingo-m-petrol
      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-m' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `model_long_slug` = 'berlingo-m-petrol' order by `fuel` asc
      680μsvandirectVanLeaseFilter.php#99
      Bindings
      • 0: citroen
      • 1: berlingo-m
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: berlingo-m-petrol
      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-m' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `model_long_slug` = 'berlingo-m-petrol' order by `transmission` asc
      720μsvandirectVanLeaseFilter.php#114
      Bindings
      • 0: citroen
      • 1: berlingo-m
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: berlingo-m-petrol
      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` = 'berlingo-m' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `model_long_slug` = 'berlingo-m-petrol' and `term` in (6, 12, 18, 24, 36, 48, 60) order by `term` asc
      2.81msvandirectVanLeaseFilter.php#138
      Bindings
      • 0: citroen
      • 1: berlingo-m
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: berlingo-m-petrol
      • 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` = 'berlingo-m' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `model_long_slug` = 'berlingo-m-petrol' 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
      2.9msvandirectVanLeaseFilter.php#153
      Bindings
      • 0: citroen
      • 1: berlingo-m
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: berlingo-m-petrol
      • 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` = 'berlingo-m' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `model_long_slug` = 'berlingo-m-petrol' 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
      2.86msvandirectVanLeaseFilter.php#169
      Bindings
      • 0: citroen
      • 1: berlingo-m
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: berlingo-m-petrol
      • 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` = 'berlingo-m' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `model_long_slug` = 'berlingo-m-petrol' 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
      2.92msvandirectVanLeaseFilter.php#193
      Bindings
      • 0: citroen
      • 1: berlingo-m
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: berlingo-m-petrol
      • 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` = 'berlingo-m') group by `make`, `model`, `model_long`, `model_long_slug`, `make_slug`, `model_slug` order by `model_long` asc
      450μsvandirectVanModel.php#131
      Bindings
      • 0: citroen
      • 1: berlingo-m
      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-m' and `d_live` = 1 and `live` = 1 and `otrprice` > 4000 and `amount` > 0 and `capid` > 1) and `model_long_slug` = 'berlingo-m-petrol' order by `otrprice` asc limit 2
      660μsvandirectNewVanSearch.php#276
      Bindings
      • 0: citroen
      • 1: berlingo-m
      • 2: 1
      • 3: 1
      • 4: 4000
      • 5: 0
      • 6: 1
      • 7: berlingo-m-petrol
      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` = 'berlingo-m' and `d_live` = 1 and `live` = 1 and `otrprice` > 4000 and `amount` > 0 and `capid` > 1) order by `otrprice` asc limit 2
      620μsvandirectNewVanSearch.php#241
      Bindings
      • 0: citroen
      • 1: berlingo-m
      • 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\VanLeaseClick
    67VanLeaseClick.php#?
    App\Models\Van
    49Van.php#?
    App\Models\VanLeaseOffer
    30VanLeaseOffer.php#?
    App\Models\VanCusCar
    3VanCusCar.php#?
        _token
        O9iHTd20a4uC1OtBjP621apNjgTZ70W3NcAKLZbq
        views
        1
        uid
        6f520a7facfdfba1ab9b3e6a488d26ca
        _previous
        array:1 [ "url" => "https://laravel.cars2buy.co.uk/van-leasing/citroen/berlingo-m/berlingo-m-petro...
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /van-leasing/citroen/berlingo-m/berlingo-m-petrol/
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        0 of 0
        array:2 [ "fVariant" => "berlingo-m-petrol" "page" => "29" ]
        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.147.73.36" ] "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 => "Tue, 21 Jan 2025 20:23:10 GMT" ] "pragma" => array:1 [ 0 => "no-cache" ] "expires" => array:1 [ 0 => "-1" ] "set-cookie" => array:3 [ 0 => "uid=eyJpdiI6IkhKbUZxMloyYmlVVWtVYzMwTlBVaGc9PSIsInZhbHVlIjoiYjlWdHpvbHRnQTJCZDdDYzdNT1NoL2NVSVJXNGd1RFc2K3ZZTUUxMUNpV25UT2hqaEtvb2xMb1FSeHRqRDRyT2lvZEhadG03TThUZjdXYTFDSGlsZ0s2K0hIR2ZRQVFKeTZFQ0VIOXdScnc9IiwibWFjIjoiYjA3OTQ5OTQ4ZTQ1Nzc5ZmQ1OTRlMTFiMWRhZTkzZjRlMDk5Yzg3ZjMzYjMxYjYzODM2NTAwMThhZDE2NmZlOSIsInRhZyI6IiJ9; expires=Tue, 28 Feb 5358 19:33:10 GMT; Max-Age=105182579400; path=/; secure; httponly; samesite=laxuid=eyJpdiI6IkhKbUZxMloyYmlVVWtVYzMwTlBVaGc9PSIsInZhbHVlIjoiYjlWdHpvbHRnQTJCZDdDYzdNT1NoL2NVSVJXNGd1RFc2K3ZZTUUxMUNpV25UT2hqaEtvb2xMb1FSeHRqRDRyT2lvZEhadG03TThU" 1 => "XSRF-TOKEN=eyJpdiI6InhjUTJXWnpqUUtlcVBLQUtpOFRUVWc9PSIsInZhbHVlIjoiLzkvWm1FdEdVa1RpL3FmTVRxQmVkWDF3c1lTMWtYS0Z2SkdFOVMzalpGSG9UTVk5UnRwbldFUGw5eE8xYW41ZXdQYlhZZlNUY2R1SmhGR0U5bWh5S3pTU25KUHdyNkh6MFQ4NzJYUHhvN0hyR0VJTmpDeU96ellRM09rNDRwYUYiLCJtYWMiOiJiODA3MDFlZDlmNmIwNGFjOWRkY2Q3ZjJhNmYzNTA5NDk3ZTUwYzJhMmVjOWEwNTUwMDc0NjIwMTk0NzMzNjRlIiwidGFnIjoiIn0%3D; expires=Tue, 21 Jan 2025 22:23:10 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6InhjUTJXWnpqUUtlcVBLQUtpOFRUVWc9PSIsInZhbHVlIjoiLzkvWm1FdEdVa1RpL3FmTVRxQmVkWDF3c1lTMWtYS0Z2SkdFOVMzalpGSG9UTVk5UnRwbldFUGw5eE8xYW41ZXdQYlhZZ" 2 => "laravel_session=eyJpdiI6IlM4eDN0WEhVM0R0RllGSkxGTlNhU1E9PSIsInZhbHVlIjoiZE1IeWk1bGw4KzFESE43V2wrcitRUmRrTFFKc1BLY1MwUXdQMXdBc1lVaytyZHRvbW8zSnczQTFPRW9TR0E2MEZQVTU2enVxSHUra2o4ZWR3bWYxL0VYdExieUpGazJlNk9pZjNFelZJdlA4My9wcXFCaWxVNmJDN0huZG9CY1kiLCJtYWMiOiIxZjg0MzBiZWVhMzk4N2Y3ZmYxZWExYjExMmU5YzFlNDBiNzgyZmQ0YzU3YzI3ZWJmYzI5YzRkZTQ0MjQ4NjE0IiwidGFnIjoiIn0%3D; expires=Tue, 21 Jan 2025 22:23:10 GMT; Max-Age=7200; path=/; httponly; samesite=laxlaravel_session=eyJpdiI6IlM4eDN0WEhVM0R0RllGSkxGTlNhU1E9PSIsInZhbHVlIjoiZE1IeWk1bGw4KzFESE43V2wrcitRUmRrTFFKc1BLY1MwUXdQMXdBc1lVaytyZHRvbW8zSnczQTFPRW9TR0E2MEZQ" ] "Set-Cookie" => array:3 [ 0 => "uid=eyJpdiI6IkhKbUZxMloyYmlVVWtVYzMwTlBVaGc9PSIsInZhbHVlIjoiYjlWdHpvbHRnQTJCZDdDYzdNT1NoL2NVSVJXNGd1RFc2K3ZZTUUxMUNpV25UT2hqaEtvb2xMb1FSeHRqRDRyT2lvZEhadG03TThUZjdXYTFDSGlsZ0s2K0hIR2ZRQVFKeTZFQ0VIOXdScnc9IiwibWFjIjoiYjA3OTQ5OTQ4ZTQ1Nzc5ZmQ1OTRlMTFiMWRhZTkzZjRlMDk5Yzg3ZjMzYjMxYjYzODM2NTAwMThhZDE2NmZlOSIsInRhZyI6IiJ9; expires=Tue, 28-Feb-5358 19:33:10 GMT; path=/; secure; httponlyuid=eyJpdiI6IkhKbUZxMloyYmlVVWtVYzMwTlBVaGc9PSIsInZhbHVlIjoiYjlWdHpvbHRnQTJCZDdDYzdNT1NoL2NVSVJXNGd1RFc2K3ZZTUUxMUNpV25UT2hqaEtvb2xMb1FSeHRqRDRyT2lvZEhadG03TThU" 1 => "XSRF-TOKEN=eyJpdiI6InhjUTJXWnpqUUtlcVBLQUtpOFRUVWc9PSIsInZhbHVlIjoiLzkvWm1FdEdVa1RpL3FmTVRxQmVkWDF3c1lTMWtYS0Z2SkdFOVMzalpGSG9UTVk5UnRwbldFUGw5eE8xYW41ZXdQYlhZZlNUY2R1SmhGR0U5bWh5S3pTU25KUHdyNkh6MFQ4NzJYUHhvN0hyR0VJTmpDeU96ellRM09rNDRwYUYiLCJtYWMiOiJiODA3MDFlZDlmNmIwNGFjOWRkY2Q3ZjJhNmYzNTA5NDk3ZTUwYzJhMmVjOWEwNTUwMDc0NjIwMTk0NzMzNjRlIiwidGFnIjoiIn0%3D; expires=Tue, 21-Jan-2025 22:23:10 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6InhjUTJXWnpqUUtlcVBLQUtpOFRUVWc9PSIsInZhbHVlIjoiLzkvWm1FdEdVa1RpL3FmTVRxQmVkWDF3c1lTMWtYS0Z2SkdFOVMzalpGSG9UTVk5UnRwbldFUGw5eE8xYW41ZXdQYlhZZ" 2 => "laravel_session=eyJpdiI6IlM4eDN0WEhVM0R0RllGSkxGTlNhU1E9PSIsInZhbHVlIjoiZE1IeWk1bGw4KzFESE43V2wrcitRUmRrTFFKc1BLY1MwUXdQMXdBc1lVaytyZHRvbW8zSnczQTFPRW9TR0E2MEZQVTU2enVxSHUra2o4ZWR3bWYxL0VYdExieUpGazJlNk9pZjNFelZJdlA4My9wcXFCaWxVNmJDN0huZG9CY1kiLCJtYWMiOiIxZjg0MzBiZWVhMzk4N2Y3ZmYxZWExYjExMmU5YzFlNDBiNzgyZmQ0YzU3YzI3ZWJmYzI5YzRkZTQ0MjQ4NjE0IiwidGFnIjoiIn0%3D; expires=Tue, 21-Jan-2025 22:23:10 GMT; path=/; httponlylaravel_session=eyJpdiI6IlM4eDN0WEhVM0R0RllGSkxGTlNhU1E9PSIsInZhbHVlIjoiZE1IeWk1bGw4KzFESE43V2wrcitRUmRrTFFKc1BLY1MwUXdQMXdBc1lVaytyZHRvbW8zSnczQTFPRW9TR0E2MEZQ" ] ]
        session_attributes
        0 of 0
        array:6 [ "_token" => "O9iHTd20a4uC1OtBjP621apNjgTZ70W3NcAKLZbq" "views" => 1 "uid" => "6f520a7facfdfba1ab9b3e6a488d26ca" "_previous" => array:1 [ "url" => "https://laravel.cars2buy.co.uk/van-leasing/citroen/berlingo-m/berlingo-m-petrol?fVariant=berlingo-m-petrol&page=29" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-01-21 20:23:10GET/van-leasing/citroen/berlingo-m/berlingo-m-petrol/?fVariant=berlingo-m-petrol&page=2981422149