Citroen Dispatch M Leasing Deals:

CITROEN DISPATCH M

Page 17 of 172 pages

Filter your results:

Lease details:

Van details:

Citroen Dispatch M variants:

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

Filter your results:

Lease details:

Van details:

Request history8.2.27PHP Version335msRequest Duration2MBMemory UsageGET van-leasing/{manufacturer}/{model}Route
  • warninglog[23:47:17] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[23:47:17] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[23:47:17] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[23:47:17] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • Booting (37.01ms)time
  • Application (298ms)time
  • 1 x Application (88.97%)
    298ms
    1 x Booting (11.03%)
    37.01ms
    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 executed142ms
    • 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` = 'dispatch-m') limit 1
      930μsvandirectController.php#434
      Bindings
      • 0: citroen
      • 1: dispatch-m
      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` = 'dispatch-m' and `live` = 1 and `capid` > 1 and `lease_live` = 1 and `price_monthly` > 0)
      13.41msvandirectVanLeasingSearch.php#45
      Bindings
      • 0: citroen
      • 1: dispatch-m
      • 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` = 'dispatch-m' and `live` = 1 and `capid` > 1 and `lease_live` = 1 and `price_monthly` > 0) order by price_monthly limit 10 offset 160
      16.16msvandirectVanLeasingSearch.php#45
      Bindings
      • 0: citroen
      • 1: dispatch-m
      • 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` = 'DISPATCH M' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'LCV' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
      870μsbrampacImagesRepository.php#66
      Bindings
      • 0: CITROEN
      • 1: DISPATCH 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` = 'DISPATCH M' and `stamp` <= '2025-01-20' and `stamp` >= '2025-01-10' and `ipuser` != '' and `make_rule` = 0 and `robot_rule` = 0) group by `ipuser`
      19.35msvandirectVanLeaseClickRepository.php#105
      Bindings
      • 0: CITROEN
      • 1: DISPATCH M
      • 2: 2025-01-20
      • 3: 2025-01-10
      • 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 ('0d41ea7ab7baace472c9d72ce7455c97', '104cc49f6755f08c87632ab7ea2c8b53', '1062254186b1661506bb0c6867253909', '13ccf319a3210e3cf0b22d259428c297', '1814d46990e82ef29b34143eaaa0ffc2', '191afb1a5b1280552126b5df49445229', '20454fb97ef83ed9a821f031f97d844b', '20580596c04a233064a62cd31bcc6ac8', '28935cededeeeced18fc1b5932989b11', '29fbb39037c61dc2f610a7fd17bce3e7', '2cecff88b492a6dca465de2f68cb5c36', '2d64743987948892976d6280510c98c6', '2e797db17ad615c6275c434d1b5e769e', '36be14b275a1a6cb0bee19e6471403cc', '3d2946525c326a00fe39c99e260232a1', '4194cac2e631e25f0f0d6f9ebc161085', '4522a7d9f96c70983343fb79650a84d4', '49444b9fea72afdea2886c0afbeeb1a5', '4a3317dbbe596258707130bed009a83b', '4bfdf1d5d6ed55d256146a9590ebff53', '4df3ed925be970fa9573cc3fb0b517d2', '507de5043035064853a211b28e8e4d48', '52cf0a5611f7bc67a50c9ef382e76a43', '5387aeda53bb2a55b1301bfc3343c761', '5816eeef95bb072f228416249bd6a8ea', '59fcdb81db72a3ac7ee81c633edb5f3f', '5b01ab846160f6d1bd749eb13b87e34b', '5f94aea59406e2733f0a74d33b8555df', '620994a548bb4f743c96816ccbe6b71a', '62242a3ece0d57e603c31af9fe170a39', '64aff5c3f6a66e16944cef0513a6ad32', '6768185d8d29150aa887badfa0e0d144', '698b54cf16321ddbb26063b45afa56c9', '6b49655267ad45aca01ea77f138e91e5', '719ed4ff2e68e86f15f21ed06965ae8c', '74927112ea92b45f4099c216bf912cc0', '7cb5d5d10f88a305340baddbf3a9499d', '7cb88e2a7bf6ba86c600648380acfede', '7ce78806a8e4c5e6b184d7afa67b952c', '7e3e20be647bd06ea11c0da678e73809', '80ca4dbf73af7714f028a5d937c42551', '844ee8059c7bf1bb3570d9613d936208', '8570660965c4a7ba28d2bf67e8e4dc2f', '878e88389e6ba5b97c3fa9d876a29afe', '8bd80776741d619c010888b5aae1062c', '91a206dad0ffdd49f90083890a38d695', '948c297b947afb814a82006b5d8842bc', '953db802a0ec014fd550542694721620', '996d0122cc72f6a55c263ecd3e59c247', '9d86c886bfa176dd5b0851c0b8f7e33e', '9d891c8390f05a094f9321f626700b1a', 'a0da29210b9eeb05158560c01cd203ac', 'a1cf2382fb78cb212d2e4c6f2c1b2b6e', 'a4e26ab9e5e4f792bd0f2693d35e5507', 'a5ee775d0b25169a2c4b102c986e0e4d', 'b04758b5598c281c053b588258e171a4', 'b6d3f2a5c42c23a8beb6f3bbf414a91d', 'bea11f54f00486ecace4a4808915fdbb', 'bf6850285deb4be200713c111d9f0dfa', 'c4ed6dc6e62418701916d386313557ef', 'c7cb0e2c268330823c7b3daf07d22255', 'c99a15dd19164224a74c9bb2729abbe5', 'caf3c3773ad2c98c91b754ecdf4a6acc', 'ccda5fd9aab8ed32f5c6f6dcca4fce85', 'd03df72bc7c99fa2098227195cc5931a', 'd279d57ef4e66fe9249cac0597a650a5', 'd2c261534f52b87fd2422cb671977f62', 'd4ec4091057b4905b373de9f27d8ff87', 'da07fe520aaae1db36fe6489a696dc06', 'df54b10c16aa979c95d0f22f3f490409', 'e2f836593c955df20cc111f104c007c3', 'e7acbf05f9371f668737b4ba86efc676', 'eefb482a159ed66bf40a2cf287ae6e57', 'f0245fdb7851cb30d299d808fff79d17', 'f04c1a40811caa0a24f1330cdb5c0d69', 'f096ad65896848d4353735bbc7a4711f', 'f29ba805113860bd0d7be6e837b082e0', 'f34a68b9006dd30f0fcafcf124356d76', 'f3519b6ed05f5bcb509dbaa2df9a5f42') and (`make` != 'CITROEN' and `model` != 'DISPATCH M' and `stamp` < '2025-01-20' and `stamp` >= '2025-01-10' and `make_rule` = 0 and `robot_rule` = 0) group by `model`, `make` order by `count` desc limit 5
      20.25msvandirectVanLeaseClickRepository.php#77
      Bindings
      • 0: 0d41ea7ab7baace472c9d72ce7455c97
      • 1: 104cc49f6755f08c87632ab7ea2c8b53
      • 2: 1062254186b1661506bb0c6867253909
      • 3: 13ccf319a3210e3cf0b22d259428c297
      • 4: 1814d46990e82ef29b34143eaaa0ffc2
      • 5: 191afb1a5b1280552126b5df49445229
      • 6: 20454fb97ef83ed9a821f031f97d844b
      • 7: 20580596c04a233064a62cd31bcc6ac8
      • 8: 28935cededeeeced18fc1b5932989b11
      • 9: 29fbb39037c61dc2f610a7fd17bce3e7
      • 10: 2cecff88b492a6dca465de2f68cb5c36
      • 11: 2d64743987948892976d6280510c98c6
      • 12: 2e797db17ad615c6275c434d1b5e769e
      • 13: 36be14b275a1a6cb0bee19e6471403cc
      • 14: 3d2946525c326a00fe39c99e260232a1
      • 15: 4194cac2e631e25f0f0d6f9ebc161085
      • 16: 4522a7d9f96c70983343fb79650a84d4
      • 17: 49444b9fea72afdea2886c0afbeeb1a5
      • 18: 4a3317dbbe596258707130bed009a83b
      • 19: 4bfdf1d5d6ed55d256146a9590ebff53
      • 20: 4df3ed925be970fa9573cc3fb0b517d2
      • 21: 507de5043035064853a211b28e8e4d48
      • 22: 52cf0a5611f7bc67a50c9ef382e76a43
      • 23: 5387aeda53bb2a55b1301bfc3343c761
      • 24: 5816eeef95bb072f228416249bd6a8ea
      • 25: 59fcdb81db72a3ac7ee81c633edb5f3f
      • 26: 5b01ab846160f6d1bd749eb13b87e34b
      • 27: 5f94aea59406e2733f0a74d33b8555df
      • 28: 620994a548bb4f743c96816ccbe6b71a
      • 29: 62242a3ece0d57e603c31af9fe170a39
      • 30: 64aff5c3f6a66e16944cef0513a6ad32
      • 31: 6768185d8d29150aa887badfa0e0d144
      • 32: 698b54cf16321ddbb26063b45afa56c9
      • 33: 6b49655267ad45aca01ea77f138e91e5
      • 34: 719ed4ff2e68e86f15f21ed06965ae8c
      • 35: 74927112ea92b45f4099c216bf912cc0
      • 36: 7cb5d5d10f88a305340baddbf3a9499d
      • 37: 7cb88e2a7bf6ba86c600648380acfede
      • 38: 7ce78806a8e4c5e6b184d7afa67b952c
      • 39: 7e3e20be647bd06ea11c0da678e73809
      • 40: 80ca4dbf73af7714f028a5d937c42551
      • 41: 844ee8059c7bf1bb3570d9613d936208
      • 42: 8570660965c4a7ba28d2bf67e8e4dc2f
      • 43: 878e88389e6ba5b97c3fa9d876a29afe
      • 44: 8bd80776741d619c010888b5aae1062c
      • 45: 91a206dad0ffdd49f90083890a38d695
      • 46: 948c297b947afb814a82006b5d8842bc
      • 47: 953db802a0ec014fd550542694721620
      • 48: 996d0122cc72f6a55c263ecd3e59c247
      • 49: 9d86c886bfa176dd5b0851c0b8f7e33e
      • 50: 9d891c8390f05a094f9321f626700b1a
      • 51: a0da29210b9eeb05158560c01cd203ac
      • 52: a1cf2382fb78cb212d2e4c6f2c1b2b6e
      • 53: a4e26ab9e5e4f792bd0f2693d35e5507
      • 54: a5ee775d0b25169a2c4b102c986e0e4d
      • 55: b04758b5598c281c053b588258e171a4
      • 56: b6d3f2a5c42c23a8beb6f3bbf414a91d
      • 57: bea11f54f00486ecace4a4808915fdbb
      • 58: bf6850285deb4be200713c111d9f0dfa
      • 59: c4ed6dc6e62418701916d386313557ef
      • 60: c7cb0e2c268330823c7b3daf07d22255
      • 61: c99a15dd19164224a74c9bb2729abbe5
      • 62: caf3c3773ad2c98c91b754ecdf4a6acc
      • 63: ccda5fd9aab8ed32f5c6f6dcca4fce85
      • 64: d03df72bc7c99fa2098227195cc5931a
      • 65: d279d57ef4e66fe9249cac0597a650a5
      • 66: d2c261534f52b87fd2422cb671977f62
      • 67: d4ec4091057b4905b373de9f27d8ff87
      • 68: da07fe520aaae1db36fe6489a696dc06
      • 69: df54b10c16aa979c95d0f22f3f490409
      • 70: e2f836593c955df20cc111f104c007c3
      • 71: e7acbf05f9371f668737b4ba86efc676
      • 72: eefb482a159ed66bf40a2cf287ae6e57
      • 73: f0245fdb7851cb30d299d808fff79d17
      • 74: f04c1a40811caa0a24f1330cdb5c0d69
      • 75: f096ad65896848d4353735bbc7a4711f
      • 76: f29ba805113860bd0d7be6e837b082e0
      • 77: f34a68b9006dd30f0fcafcf124356d76
      • 78: f3519b6ed05f5bcb509dbaa2df9a5f42
      • 79: CITROEN
      • 80: DISPATCH M
      • 81: 2025-01-20
      • 82: 2025-01-10
      • 83: 0
      • 84: 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` = 'dispatch-m' and `model_long` = '') order by `derivative` asc
      470μsvandirectVanModel.php#163
      Bindings
      • 0: citroen
      • 1: dispatch-m
      • 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` = 'dispatch-m') limit 1
      12.86msvandirectVanLeasingSearch.php#234
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: 0
      • 4: citroen
      • 5: dispatch-m
      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
      810μ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` = 'dispatch-m' and `did` = 160 and `live` = 1 and `capid` > 1 and `lease_live` = 1 and `price_monthly` > 0) order by `price_monthly` asc limit 1
      1.6msvandirectVanLeasingSearch.php#102
      Bindings
      • 0: citroen
      • 1: dispatch-m
      • 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` = 'dispatch-m' and `d_live` = 1 and `live` = 1 and `otrprice` > 4000 and `amount` > 0) order by `otrprice` asc limit 1
      670μsvandirectNewVanSearch.php#205
      Bindings
      • 0: citroen
      • 1: dispatch-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` = 'dispatch-m' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) order by `derivative` asc
      850μsvandirectVanLeaseFilter.php#69
      Bindings
      • 0: citroen
      • 1: dispatch-m
      • 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` = 'dispatch-m' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) order by `fuel` asc
      800μsvandirectVanLeaseFilter.php#99
      Bindings
      • 0: citroen
      • 1: dispatch-m
      • 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` = 'dispatch-m' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) order by `transmission` asc
      790μsvandirectVanLeaseFilter.php#114
      Bindings
      • 0: citroen
      • 1: dispatch-m
      • 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` = 'dispatch-m' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) order by `model_long` asc
      810μsvandirectVanLeaseFilter.php#123
      Bindings
      • 0: citroen
      • 1: dispatch-m
      • 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` = 'dispatch-m' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `term` in (6, 12, 18, 24, 36, 48, 60) order by `term` asc
      12.68msvandirectVanLeaseFilter.php#138
      Bindings
      • 0: citroen
      • 1: dispatch-m
      • 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` = 'dispatch-m' 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
      12.51msvandirectVanLeaseFilter.php#153
      Bindings
      • 0: citroen
      • 1: dispatch-m
      • 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` = 'dispatch-m' 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
      12.4msvandirectVanLeaseFilter.php#169
      Bindings
      • 0: citroen
      • 1: dispatch-m
      • 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` = 'dispatch-m' 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
      12.39msvandirectVanLeaseFilter.php#193
      Bindings
      • 0: citroen
      • 1: dispatch-m
      • 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` = 'dispatch-m') group by `make`, `model`, `model_long`, `model_long_slug`, `make_slug`, `model_slug` order by `model_long` asc
      580μsvandirectVanModel.php#131
      Bindings
      • 0: citroen
      • 1: dispatch-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` = 'dispatch-m' and `d_live` = 1 and `live` = 1 and `otrprice` > 4000 and `amount` > 0 and `capid` > 1) order by `otrprice` asc limit 2
      640μsvandirectNewVanSearch.php#276
      Bindings
      • 0: citroen
      • 1: dispatch-m
      • 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\VanLeaseClick
    79VanLeaseClick.php#?
    App\Models\Van
    45Van.php#?
    App\Models\VanLeaseOffer
    45VanLeaseOffer.php#?
    App\Models\VanCusCar
    3VanCusCar.php#?
        _token
        0N08TV3qN9V5J6E2P2fa96mJFi10gnjtIPVppiC0
        views
        1
        uid
        d340d55158169656d3f9695d64c0b6a2
        _previous
        array:1 [ "url" => "https://laravel.cars2buy.co.uk/van-leasing/citroen/dispatch-m?page=17" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /van-leasing/citroen/dispatch-m/
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        0 of 0
        array:1 [ "page" => "17" ]
        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.148.115.33" ] "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 => "Mon, 20 Jan 2025 23:47:17 GMT" ] "pragma" => array:1 [ 0 => "no-cache" ] "expires" => array:1 [ 0 => "-1" ] "set-cookie" => array:3 [ 0 => "uid=eyJpdiI6Ik1KLzhXeGNFYkFDeXB3YzhiSEhNc1E9PSIsInZhbHVlIjoiOWpxTWNsanZadTdwWUtKM1QxMzZPVGYyRUZsek90QkRlSldlZFY0N25NRFpNZWR1L3lPZndmQm5hb3N4ZE9oTkh4SmhqSzVwdldsMjdJZytPSU5jS0ErSnA3eVNLYk1uZVRVcUIvSWFlcms9IiwibWFjIjoiMzhiNDE1M2NiYzMzNjY4YTY4NWI3OTY3MGQ3NmQxZTk3ODZhYzlhNmU1MDkzNTE1MjcyNmJkZDFmMThhY2I5NSIsInRhZyI6IiJ9; expires=Sat, 07 Jan 5358 11:04:17 GMT; Max-Age=105178130220; path=/; secure; httponly; samesite=laxuid=eyJpdiI6Ik1KLzhXeGNFYkFDeXB3YzhiSEhNc1E9PSIsInZhbHVlIjoiOWpxTWNsanZadTdwWUtKM1QxMzZPVGYyRUZsek90QkRlSldlZFY0N25NRFpNZWR1L3lPZndmQm5hb3N4ZE9oTkh4SmhqSzVwdlds" 1 => "XSRF-TOKEN=eyJpdiI6IjVabXZCU2FJTjBVYVQrTlIwTlozS3c9PSIsInZhbHVlIjoiYnZBQ2RwMTlUeHFyNWxLcXlxTGlqWGZaWWtIR2RadlNuK3ZpY2dGQ2I2eUN6OUZ4eWg4a29RWWFIUGJCbC9oR0Q0UUU2K2Z4ckwvUXNxT1VGZm56K3RRQXZqL0RYT3M1enBOK0xrZndUUUxwUmo3ZzJYRklSY21rZEJuSFc0SjMiLCJtYWMiOiI5M2I2NDc3YzRhYjYwZmMyMzVlYjZlOWU5MjEyZDQ5ZjFiZTI5YmIyYmZlMzNkNDYyZTlmYzczNWRhMDNmN2M0IiwidGFnIjoiIn0%3D; expires=Tue, 21 Jan 2025 01:47:17 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IjVabXZCU2FJTjBVYVQrTlIwTlozS3c9PSIsInZhbHVlIjoiYnZBQ2RwMTlUeHFyNWxLcXlxTGlqWGZaWWtIR2RadlNuK3ZpY2dGQ2I2eUN6OUZ4eWg4a29RWWFIUGJCbC9oR0Q0UUU2K" 2 => "laravel_session=eyJpdiI6IllJZ3ZVMXhsOTl5Vm1sMXFLNFhMdGc9PSIsInZhbHVlIjoiUDFmY3FYZmZGNVk3OEYxbUN1SDE5djJacGkxdks2Z0VXS0FjYVRGTEdoRGVaZTh3OTlBc1UrNENCTTM3VU81SEl2aWhjU2ZpZmtUa3dpZm0xMitaaGloTmFkSStnS09qVnk0NWdXK0VSQ3QrcXpZVWtuRUx3by9YWG01dmFSRm8iLCJtYWMiOiI2ZTgxZGY2NjUzYmRhMTU0YmZjOGUwNjM2ODZjNGNiZmYwMjgyMjA2ZDY3MjBlZmUwYjVjZjljMjc1ZTA5NThjIiwidGFnIjoiIn0%3D; expires=Tue, 21 Jan 2025 01:47:17 GMT; Max-Age=7200; path=/; httponly; samesite=laxlaravel_session=eyJpdiI6IllJZ3ZVMXhsOTl5Vm1sMXFLNFhMdGc9PSIsInZhbHVlIjoiUDFmY3FYZmZGNVk3OEYxbUN1SDE5djJacGkxdks2Z0VXS0FjYVRGTEdoRGVaZTh3OTlBc1UrNENCTTM3VU81SEl2" ] "Set-Cookie" => array:3 [ 0 => "uid=eyJpdiI6Ik1KLzhXeGNFYkFDeXB3YzhiSEhNc1E9PSIsInZhbHVlIjoiOWpxTWNsanZadTdwWUtKM1QxMzZPVGYyRUZsek90QkRlSldlZFY0N25NRFpNZWR1L3lPZndmQm5hb3N4ZE9oTkh4SmhqSzVwdldsMjdJZytPSU5jS0ErSnA3eVNLYk1uZVRVcUIvSWFlcms9IiwibWFjIjoiMzhiNDE1M2NiYzMzNjY4YTY4NWI3OTY3MGQ3NmQxZTk3ODZhYzlhNmU1MDkzNTE1MjcyNmJkZDFmMThhY2I5NSIsInRhZyI6IiJ9; expires=Sat, 07-Jan-5358 11:04:17 GMT; path=/; secure; httponlyuid=eyJpdiI6Ik1KLzhXeGNFYkFDeXB3YzhiSEhNc1E9PSIsInZhbHVlIjoiOWpxTWNsanZadTdwWUtKM1QxMzZPVGYyRUZsek90QkRlSldlZFY0N25NRFpNZWR1L3lPZndmQm5hb3N4ZE9oTkh4SmhqSzVwdlds" 1 => "XSRF-TOKEN=eyJpdiI6IjVabXZCU2FJTjBVYVQrTlIwTlozS3c9PSIsInZhbHVlIjoiYnZBQ2RwMTlUeHFyNWxLcXlxTGlqWGZaWWtIR2RadlNuK3ZpY2dGQ2I2eUN6OUZ4eWg4a29RWWFIUGJCbC9oR0Q0UUU2K2Z4ckwvUXNxT1VGZm56K3RRQXZqL0RYT3M1enBOK0xrZndUUUxwUmo3ZzJYRklSY21rZEJuSFc0SjMiLCJtYWMiOiI5M2I2NDc3YzRhYjYwZmMyMzVlYjZlOWU5MjEyZDQ5ZjFiZTI5YmIyYmZlMzNkNDYyZTlmYzczNWRhMDNmN2M0IiwidGFnIjoiIn0%3D; expires=Tue, 21-Jan-2025 01:47:17 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IjVabXZCU2FJTjBVYVQrTlIwTlozS3c9PSIsInZhbHVlIjoiYnZBQ2RwMTlUeHFyNWxLcXlxTGlqWGZaWWtIR2RadlNuK3ZpY2dGQ2I2eUN6OUZ4eWg4a29RWWFIUGJCbC9oR0Q0UUU2K" 2 => "laravel_session=eyJpdiI6IllJZ3ZVMXhsOTl5Vm1sMXFLNFhMdGc9PSIsInZhbHVlIjoiUDFmY3FYZmZGNVk3OEYxbUN1SDE5djJacGkxdks2Z0VXS0FjYVRGTEdoRGVaZTh3OTlBc1UrNENCTTM3VU81SEl2aWhjU2ZpZmtUa3dpZm0xMitaaGloTmFkSStnS09qVnk0NWdXK0VSQ3QrcXpZVWtuRUx3by9YWG01dmFSRm8iLCJtYWMiOiI2ZTgxZGY2NjUzYmRhMTU0YmZjOGUwNjM2ODZjNGNiZmYwMjgyMjA2ZDY3MjBlZmUwYjVjZjljMjc1ZTA5NThjIiwidGFnIjoiIn0%3D; expires=Tue, 21-Jan-2025 01:47:17 GMT; path=/; httponlylaravel_session=eyJpdiI6IllJZ3ZVMXhsOTl5Vm1sMXFLNFhMdGc9PSIsInZhbHVlIjoiUDFmY3FYZmZGNVk3OEYxbUN1SDE5djJacGkxdks2Z0VXS0FjYVRGTEdoRGVaZTh3OTlBc1UrNENCTTM3VU81SEl2" ] ]
        session_attributes
        0 of 0
        array:6 [ "_token" => "0N08TV3qN9V5J6E2P2fa96mJFi10gnjtIPVppiC0" "views" => 1 "uid" => "d340d55158169656d3f9695d64c0b6a2" "_previous" => array:1 [ "url" => "https://laravel.cars2buy.co.uk/van-leasing/citroen/dispatch-m?page=17" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-01-20 23:47:17GET/van-leasing/citroen/dispatch-m/?page=1741422172