Mercedes-Benz Sprinter 215cdi L2 Diesel FWD Leasing Deals:

MERCEDES-BENZ SPRINTER L2

Page 15 of 97 pages

People who viewed Mercedes-Benz Sprinter L2 deals also viewed:

New Van Offers:

Compare Mercedes-Benz Sprinter 215cdi L2 Diesel FWD 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 Mercedes-Benz van dealers and leasing companies. We advertise the cheapest Mercedes-Benz Sprinter 215cdi L2 Diesel FWD leases to ensure that you are getting the best deal available. If you are looking to lease a Mercedes-Benz Sprinter 215cdi L2 Diesel FWD then you have come to the right place!

Filter your results:

Lease details:

Van details:

Request history8.2.27PHP Version461msRequest Duration2MBMemory UsageGET van-leasing/{manufacturer}/{model}/{variant}Route
  • warninglog[05:38:36] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[05:38:36] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[05:38:36] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[05:38:36] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[05:38:36] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[05:38:36] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[05:38:36] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[05:38:36] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[05:38:36] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[05:38:36] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[05:38:36] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[05:38:36] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[05:38:36] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[05:38:36] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[05:38:36] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[05:38:36] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[05:38:36] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[05:38:36] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[05:38:36] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[05:38:36] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[05:38:36] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[05:38:36] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[05:38:36] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[05:38:36] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[05:38:36] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[05:38:36] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[05:38:36] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • warninglog[05:38:36] LOG.warning: strlen(): Passing null to parameter #1 ($string) of type string is deprecate...
  • Booting (36.56ms)time
  • Application (425ms)time
  • 1 x Application (92.07%)
    425ms
    1 x Booting (7.92%)
    36.56ms
    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
    28 statements were executed, 2 of which were duplicates, 26 unique. Show only duplicated226ms
    • 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` = 'mercedes-benz' and `model_slug` = 'sprinter-l2' and `model_long_slug` = 'sprinter-215cdi-l2-diesel-fwd') limit 1
      850μsvandirectController.php#385
      Bindings
      • 0: mercedes-benz
      • 1: sprinter-l2
      • 2: sprinter-215cdi-l2-diesel-fwd
      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` = 'mercedes-benz' and `model_slug` = 'sprinter-l2' and `live` = 1 and `capid` > 1 and `lease_live` = 1 and `price_monthly` > 0) and `model_long_slug` = 'sprinter-215cdi-l2-diesel-fwd'
      19.8msvandirectVanLeasingSearch.php#45
      Bindings
      • 0: mercedes-benz
      • 1: sprinter-l2
      • 2: 1
      • 3: 1
      • 4: 1
      • 5: 0
      • 6: sprinter-215cdi-l2-diesel-fwd
      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` = 'mercedes-benz' and `model_slug` = 'sprinter-l2' and `live` = 1 and `capid` > 1 and `lease_live` = 1 and `price_monthly` > 0) and `model_long_slug` = 'sprinter-215cdi-l2-diesel-fwd' order by price_monthly limit 10 offset 140
      21.01msvandirectVanLeasingSearch.php#45
      Bindings
      • 0: mercedes-benz
      • 1: sprinter-l2
      • 2: 1
      • 3: 1
      • 4: 1
      • 5: 0
      • 6: sprinter-215cdi-l2-diesel-fwd
      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` = 'MERCEDES-BENZ' and `vandirect`.`vans`.`model` = 'SPRINTER L2' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'LCV' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
      2.11msbrampacImagesRepository.php#66
      Bindings
      • 0: MERCEDES-BENZ
      • 1: SPRINTER 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 `ipuser` from `lease_clicks` where (`make` = 'MERCEDES-BENZ' and `model` = 'SPRINTER L2' and `stamp` <= '2025-01-22' and `stamp` >= '2025-01-12' and `ipuser` != '' and `make_rule` = 0 and `robot_rule` = 0) group by `ipuser`
      29.41msvandirectVanLeaseClickRepository.php#105
      Bindings
      • 0: MERCEDES-BENZ
      • 1: SPRINTER L2
      • 2: 2025-01-22
      • 3: 2025-01-12
      • 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 ('059593d8103d472c3c234a8f24c95494', '0872d3f6c6b78ec0f60ba4e29e19ee53', '09d5646fbbb170d083c26006774434cb', '0b5f69d66e785bb65c26908dead688ab', '0d5f0091b0616ebefa4c3a97e539f3f2', '11087d6c657443cb7c865cf342668a38', '1641ce1304950b0dbc4c38cb66fb8dc3', '16e4d17420c7772bd29b94376bb8f5e0', '185e5512846786d04f13e9f410496488', '19166e8d8de09e67a2175ba7a2de9dba', '1b7dc6a258ceafff84d22ae8d7ef1ab7', '21a9fc64321476725d8e8a145c1cd203', '23b78ab142f2f1a60fc2f90d9f87dc44', '24ab2dced69ef5905700389548e0cca0', '2a7b68216be04c1e63013c22c8afa080', '2b994ab3acd0f91bca8883d5f1e53221', '2c7db285fd26755b696217878d443f83', '2ca911f90a499c7e06bb4f22d07b5d35', '2cc903bd9db537a14bde4bf30190bf42', '2d5c01d88acd88dd022e77fc20ddcdda', '2e3311f55b703f2cfb0cb2ced496f733', '2f08382e47d06f818f9bcc6f37e371d0', '2fccfa51c9899fce824879a079d90dca', '33bdeec50c337d701cacbb9baeb22949', '3452953e5eb4009fca69f702dcd01dbc', '376ff55762846ae43ce59b8bb0874db3', '390e101f2a11f78128945e745cd1adad', '39a85c229c2066661663dc1a23e0b2fe', '39e69592352373df4f7ee0c350c30961', '3c1c6db4b2cf15fa8ce26eab50d6e656', '4033bc05460b76b3125761847cf3a029', '41ae369e2cedad58b8801b5255878f75', '4abb2a181274378a262437f83267bc66', '4e6c39ff7e3d1f942046b4a8a28e518b', '51d64d02f7858281eb055fdfc6f91546', '527d42469fdaf12114bc663461b768ad', '52ddeac191c73ad0a13739353a48c832', '57c72c47a769e355f5237771326ce49f', '589cdec88a25de1f96ac13ae3b65db80', '58a35b03d7842b86035cab384d6fb04b', '58a371d98615d0261eea47f331cce7dd', '5fd4f16899356e209cfda8ce35950bfa', '600084ae17a74053e5f2789baca6d1af', '65440eaab6d7948b014b5cd07268d3f7', '679e5949dd071c3187aeac5508a5dda2', '6ac265da1e96d402a843ed70dbffd7a6', '6b0a179a3d70f51c284bbd54be1cec75', '6c11cc117bedca470023b637fe158c9b', '6cbc43f444771bf52d7361f9c088a854', '6f5ecbbe8127b081b9df2a1b755a3c41', '71abfbcc16a9def76ab9193235c5615b', '7206a3f053f2975836daaaa7c1509b60', '72bdd2feeae396f5de34321a0b913e05', '73ae812743d473e81404f01596227032', '76340c0a4a256c7eeb42b2e1941f9e43', '783d496b155a040328ca93ad2dedf8ff', '7d5361892ee1257db23490ad2f0311f3', '7d5bb0d67602a8ff9091370663853aed', '7e1e032addf5d1061dd60dd14d61363b', '7f487f3c6b4a1a6c6aefbdf64382cf4c', '7fa300d639f55f14b901caf586bde48c', '8072be79ca01bba33afcbfc24e8d1cec', '8094ad27ff4c89f9195f9dd66b80b008', '82a04fbdfe34e5e2aab5e1bcd3652733', '836d5e7ec37c7abc418e7c550ac90c72', '83d59f74755b32f33a3a8b7fcc58f5b1', '844901ba3809d208048dde7cdb358940', '85ab41f85338ed8a104df4d5c0866e53', '865b7240ba99f00f05d8d7b3bec13d4c', '88060f3808aa8e8f54b01c994c0fde6c', '8bb08df97030594f948ffd2678d53e87', '8f145ea6a33bcc3821bddd202eda9bb7', '90c72bcbd3220bfc97cca1df91ffcead', '94460378ce94644519a6fd3b71e92ab5', '9472a86fad20a1743b438310f90a0662', '9613bdaa709152dbcac41c3c037d4d46', '9dbfd95bd567ca214f3a5807280d6b45', 'a12be6ce1c59dbbdc0f040daae3a80e8', 'a25df03c2427b9833daf4512f5aa4f06', 'a2bf278571470f0cc7b44cb3fd71a5d7', 'a64a11cf70f7a58ca4f8d45f6186795c', 'a7950b3093f175d8241eec49bf0b74be', 'abb46847b4e4ac28bedd347da777477e', 'adaf61141245d470f86b78a89b8a6399', 'aeff132e9e20272aaf9371605ef04f6c', 'b155eacaef20b3ffa027ba9b348e458e', 'b26b0d5f7dcda446133bb9512e791f2e', 'b454645c152711952a711a32a33b784b', 'b62a28fe4b22cca3ba3b79ff89942052', 'b6d155280882b502bbc2070c96613c29', 'b6f95c5efee751357ebbea0847c6cb43', 'bbde181a75f917d214d07520e3ad4d3e', 'bc044dc0ac0b38cea3c88f2b31c76f64', 'bc0799d6a16e99e7139c988012a71d4c', 'bceb283bd63889b06a73324a8689cd40', 'bfd00acd2714380073563339091c658f', 'c0df7818c1c8724c2e366a0c3a32b762', 'c166fd39c7573c7daa83c5331e820710', 'c6ba823c1e82fde4ee2a44d1843efada', 'c7bd6ca91c6e0a4310be9c911102e3d4', 'cccc2974bd9fbb2af8e72ef751410dbe', 'cd8349cf387cd7293df6abd99ed0fb09', 'd03b40a46a6f2b0b2e28bc2f0fdf3b89', 'd42cf784fdb80f1870d2ada9237838a1', 'd4dd9aed1dc5edb48330d1f32d70c9f5', 'ddb7424548f7c93a74cd8deaf1df0f30', 'df3c86887de99cfaf88616acfa57b197', 'e19b531a5a3bc1a98718937a42effc91', 'e274febfe9355891387aa315d347bb5b', 'e47b4333f04fa7dd25f5f4ee83d4e20f', 'e67cab6830a5060bf4f16d9ca1372de7', 'e7e4a632dc1e086d9540548c37ac2a83', 'ea0322014bb319be46ecea3e4b72d34b', 'ea4ec847e6415986098aa88e065f7924', 'eb8f5da2184057dfa40c42069ad4e610', 'f29d7dc2bb6f30ead0a8cf22c8a2c744', 'f30f854082055bcf2f69f8e724a4bcdf', 'f437a386e3c8b87d0abe1e199d5f5548', 'f71b24539a5e2b0606da9704b1a0f8b6', 'f9eef464621126b7838f78d08caa0e46') and (`make` != 'MERCEDES-BENZ' and `model` != 'SPRINTER L2' and `stamp` < '2025-01-22' and `stamp` >= '2025-01-12' and `make_rule` = 0 and `robot_rule` = 0) group by `model`, `make` order by `count` desc limit 5
      28.62msvandirectVanLeaseClickRepository.php#77
      Bindings
      • 0: 059593d8103d472c3c234a8f24c95494
      • 1: 0872d3f6c6b78ec0f60ba4e29e19ee53
      • 2: 09d5646fbbb170d083c26006774434cb
      • 3: 0b5f69d66e785bb65c26908dead688ab
      • 4: 0d5f0091b0616ebefa4c3a97e539f3f2
      • 5: 11087d6c657443cb7c865cf342668a38
      • 6: 1641ce1304950b0dbc4c38cb66fb8dc3
      • 7: 16e4d17420c7772bd29b94376bb8f5e0
      • 8: 185e5512846786d04f13e9f410496488
      • 9: 19166e8d8de09e67a2175ba7a2de9dba
      • 10: 1b7dc6a258ceafff84d22ae8d7ef1ab7
      • 11: 21a9fc64321476725d8e8a145c1cd203
      • 12: 23b78ab142f2f1a60fc2f90d9f87dc44
      • 13: 24ab2dced69ef5905700389548e0cca0
      • 14: 2a7b68216be04c1e63013c22c8afa080
      • 15: 2b994ab3acd0f91bca8883d5f1e53221
      • 16: 2c7db285fd26755b696217878d443f83
      • 17: 2ca911f90a499c7e06bb4f22d07b5d35
      • 18: 2cc903bd9db537a14bde4bf30190bf42
      • 19: 2d5c01d88acd88dd022e77fc20ddcdda
      • 20: 2e3311f55b703f2cfb0cb2ced496f733
      • 21: 2f08382e47d06f818f9bcc6f37e371d0
      • 22: 2fccfa51c9899fce824879a079d90dca
      • 23: 33bdeec50c337d701cacbb9baeb22949
      • 24: 3452953e5eb4009fca69f702dcd01dbc
      • 25: 376ff55762846ae43ce59b8bb0874db3
      • 26: 390e101f2a11f78128945e745cd1adad
      • 27: 39a85c229c2066661663dc1a23e0b2fe
      • 28: 39e69592352373df4f7ee0c350c30961
      • 29: 3c1c6db4b2cf15fa8ce26eab50d6e656
      • 30: 4033bc05460b76b3125761847cf3a029
      • 31: 41ae369e2cedad58b8801b5255878f75
      • 32: 4abb2a181274378a262437f83267bc66
      • 33: 4e6c39ff7e3d1f942046b4a8a28e518b
      • 34: 51d64d02f7858281eb055fdfc6f91546
      • 35: 527d42469fdaf12114bc663461b768ad
      • 36: 52ddeac191c73ad0a13739353a48c832
      • 37: 57c72c47a769e355f5237771326ce49f
      • 38: 589cdec88a25de1f96ac13ae3b65db80
      • 39: 58a35b03d7842b86035cab384d6fb04b
      • 40: 58a371d98615d0261eea47f331cce7dd
      • 41: 5fd4f16899356e209cfda8ce35950bfa
      • 42: 600084ae17a74053e5f2789baca6d1af
      • 43: 65440eaab6d7948b014b5cd07268d3f7
      • 44: 679e5949dd071c3187aeac5508a5dda2
      • 45: 6ac265da1e96d402a843ed70dbffd7a6
      • 46: 6b0a179a3d70f51c284bbd54be1cec75
      • 47: 6c11cc117bedca470023b637fe158c9b
      • 48: 6cbc43f444771bf52d7361f9c088a854
      • 49: 6f5ecbbe8127b081b9df2a1b755a3c41
      • 50: 71abfbcc16a9def76ab9193235c5615b
      • 51: 7206a3f053f2975836daaaa7c1509b60
      • 52: 72bdd2feeae396f5de34321a0b913e05
      • 53: 73ae812743d473e81404f01596227032
      • 54: 76340c0a4a256c7eeb42b2e1941f9e43
      • 55: 783d496b155a040328ca93ad2dedf8ff
      • 56: 7d5361892ee1257db23490ad2f0311f3
      • 57: 7d5bb0d67602a8ff9091370663853aed
      • 58: 7e1e032addf5d1061dd60dd14d61363b
      • 59: 7f487f3c6b4a1a6c6aefbdf64382cf4c
      • 60: 7fa300d639f55f14b901caf586bde48c
      • 61: 8072be79ca01bba33afcbfc24e8d1cec
      • 62: 8094ad27ff4c89f9195f9dd66b80b008
      • 63: 82a04fbdfe34e5e2aab5e1bcd3652733
      • 64: 836d5e7ec37c7abc418e7c550ac90c72
      • 65: 83d59f74755b32f33a3a8b7fcc58f5b1
      • 66: 844901ba3809d208048dde7cdb358940
      • 67: 85ab41f85338ed8a104df4d5c0866e53
      • 68: 865b7240ba99f00f05d8d7b3bec13d4c
      • 69: 88060f3808aa8e8f54b01c994c0fde6c
      • 70: 8bb08df97030594f948ffd2678d53e87
      • 71: 8f145ea6a33bcc3821bddd202eda9bb7
      • 72: 90c72bcbd3220bfc97cca1df91ffcead
      • 73: 94460378ce94644519a6fd3b71e92ab5
      • 74: 9472a86fad20a1743b438310f90a0662
      • 75: 9613bdaa709152dbcac41c3c037d4d46
      • 76: 9dbfd95bd567ca214f3a5807280d6b45
      • 77: a12be6ce1c59dbbdc0f040daae3a80e8
      • 78: a25df03c2427b9833daf4512f5aa4f06
      • 79: a2bf278571470f0cc7b44cb3fd71a5d7
      • 80: a64a11cf70f7a58ca4f8d45f6186795c
      • 81: a7950b3093f175d8241eec49bf0b74be
      • 82: abb46847b4e4ac28bedd347da777477e
      • 83: adaf61141245d470f86b78a89b8a6399
      • 84: aeff132e9e20272aaf9371605ef04f6c
      • 85: b155eacaef20b3ffa027ba9b348e458e
      • 86: b26b0d5f7dcda446133bb9512e791f2e
      • 87: b454645c152711952a711a32a33b784b
      • 88: b62a28fe4b22cca3ba3b79ff89942052
      • 89: b6d155280882b502bbc2070c96613c29
      • 90: b6f95c5efee751357ebbea0847c6cb43
      • 91: bbde181a75f917d214d07520e3ad4d3e
      • 92: bc044dc0ac0b38cea3c88f2b31c76f64
      • 93: bc0799d6a16e99e7139c988012a71d4c
      • 94: bceb283bd63889b06a73324a8689cd40
      • 95: bfd00acd2714380073563339091c658f
      • 96: c0df7818c1c8724c2e366a0c3a32b762
      • 97: c166fd39c7573c7daa83c5331e820710
      • 98: c6ba823c1e82fde4ee2a44d1843efada
      • 99: c7bd6ca91c6e0a4310be9c911102e3d4
      • 100: cccc2974bd9fbb2af8e72ef751410dbe
      • 101: cd8349cf387cd7293df6abd99ed0fb09
      • 102: d03b40a46a6f2b0b2e28bc2f0fdf3b89
      • 103: d42cf784fdb80f1870d2ada9237838a1
      • 104: d4dd9aed1dc5edb48330d1f32d70c9f5
      • 105: ddb7424548f7c93a74cd8deaf1df0f30
      • 106: df3c86887de99cfaf88616acfa57b197
      • 107: e19b531a5a3bc1a98718937a42effc91
      • 108: e274febfe9355891387aa315d347bb5b
      • 109: e47b4333f04fa7dd25f5f4ee83d4e20f
      • 110: e67cab6830a5060bf4f16d9ca1372de7
      • 111: e7e4a632dc1e086d9540548c37ac2a83
      • 112: ea0322014bb319be46ecea3e4b72d34b
      • 113: ea4ec847e6415986098aa88e065f7924
      • 114: eb8f5da2184057dfa40c42069ad4e610
      • 115: f29d7dc2bb6f30ead0a8cf22c8a2c744
      • 116: f30f854082055bcf2f69f8e724a4bcdf
      • 117: f437a386e3c8b87d0abe1e199d5f5548
      • 118: f71b24539a5e2b0606da9704b1a0f8b6
      • 119: f9eef464621126b7838f78d08caa0e46
      • 120: MERCEDES-BENZ
      • 121: SPRINTER L2
      • 122: 2025-01-22
      • 123: 2025-01-12
      • 124: 0
      • 125: 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 `path`, `izmoAlias` from `images_izmo` inner join `vandirect`.`vans` on `images_izmo`.`cap_id` = `vandirect`.`vans`.`capid` where `vandirect`.`vans`.`make` = 'NISSAN' and `vandirect`.`vans`.`model` = 'INTERSTAR L2' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'LCV' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
      990μsbrampacImagesRepository.php#66
      Bindings
      • 0: NISSAN
      • 1: INTERSTAR L2
      • 2: 
      • 3: 
      • 4: LCV
      Backtrace
      • 14. app/Queries/ImagesRepository.php:66
      • 15. app/Traits/VehicleImage.php:112
      • 16. app/Queries/VanLeaseClickRepository.php:84
      • 17. app/Http/Controllers/VanLeasingController.php:136
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select `model_cap` from `vandirect`.`vans` where `model` = 'INTERSTAR L2' limit 1
      220μsbrampacImagesRepository.php#76
      Bindings
      • 0: INTERSTAR L2
      Backtrace
      • 14. app/Queries/ImagesRepository.php:76
      • 17. app/Queries/ImagesRepository.php:72
      • 18. app/Traits/VehicleImage.php:112
      • 19. app/Queries/VanLeaseClickRepository.php:84
      • 20. app/Http/Controllers/VanLeasingController.php:136
    • select * from `images_izmo` inner join `vandirect`.`vans` on `images_izmo`.`cap_id` = `vandirect`.`vans`.`capid` where `vandirect`.`vans`.`make` = 'NISSAN' and `vandirect`.`vans`.`model_cap` = (select `model_cap` from `vandirect`.`vans` where `model` = 'INTERSTAR L2' limit 1) and `path` != '' and `izmoAlias` != '' and `ima_type` = 'LCV' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
      2.28msbrampacImagesRepository.php#83
      Bindings
      • 0: NISSAN
      • 1: INTERSTAR L2
      • 2: 
      • 3: 
      • 4: LCV
      Backtrace
      • 14. app/Queries/ImagesRepository.php:83
      • 15. app/Traits/VehicleImage.php:112
      • 16. app/Queries/VanLeaseClickRepository.php:84
      • 17. app/Http/Controllers/VanLeasingController.php:136
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select `path`, `izmoAlias` from `images_backfill` where `ima_make` = 'NISSAN' and `ima_model` = 'INTERSTAR L2' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'LCV' limit 1
      260μsbrampacImagesRepository.php#97
      Bindings
      • 0: NISSAN
      • 1: INTERSTAR L2
      • 2: 
      • 3: 
      • 4: LCV
      Backtrace
      • 16. app/Queries/ImagesRepository.php:97
      • 17. app/Traits/VehicleImage.php:121
      • 18. app/Queries/VanLeaseClickRepository.php:84
      • 19. app/Http/Controllers/VanLeasingController.php:136
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select `model_cap` from `vandirect`.`vans` where `model` = 'INTERSTAR L2' limit 1
      160μsbrampacImagesRepository.php#106
      Bindings
      • 0: INTERSTAR L2
      Backtrace
      • 14. app/Queries/ImagesRepository.php:106
      • 18. app/Queries/ImagesRepository.php:102
      • 19. app/Traits/VehicleImage.php:121
      • 20. app/Queries/VanLeaseClickRepository.php:84
      • 21. app/Http/Controllers/VanLeasingController.php:136
    • select `path`, `izmoAlias` from `images_backfill` where `ima_make` = 'NISSAN' and `ima_model` = (select `model_cap` from `vandirect`.`vans` where `model` = 'INTERSTAR L2' limit 1) and `path` != '' and `izmoAlias` != '' and `ima_type` = 'LCV' limit 1
      360μsbrampacImagesRepository.php#111
      Bindings
      • 0: NISSAN
      • 1: INTERSTAR L2
      • 2: 
      • 3: 
      • 4: LCV
      Backtrace
      • 16. app/Queries/ImagesRepository.php:111
      • 17. app/Traits/VehicleImage.php:121
      • 18. app/Queries/VanLeaseClickRepository.php:84
      • 19. app/Http/Controllers/VanLeasingController.php:136
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select distinct `make`, `model`, `model_long`, `model_long_slug`, `derivative`, `van_id`, `derivative_slug` from `vans` where (`make_slug` = 'mercedes-benz' and `model_slug` = 'sprinter-l2' and `model_long` = 'SPRINTER 215CDI L2 DIESEL FWD') order by `derivative` asc
      490μsvandirectVanModel.php#163
      Bindings
      • 0: mercedes-benz
      • 1: sprinter-l2
      • 2: SPRINTER 215CDI L2 DIESEL FWD
      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` = 'mercedes-benz' and `model_slug` = 'sprinter-l2') and `model_long_slug` = 'sprinter-215cdi-l2-diesel-fwd' limit 1
      19.19msvandirectVanLeasingSearch.php#234
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: 0
      • 4: mercedes-benz
      • 5: sprinter-l2
      • 6: sprinter-215cdi-l2-diesel-fwd
      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
      170μ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` = 'mercedes-benz' order by `model` asc
      3.19msvandirectVanModel.php#26
      Bindings
      • 0: mercedes-benz
      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` = 'mercedes-benz' and `model_slug` = 'sprinter-l2' and `did` = 160 and `live` = 1 and `capid` > 1 and `lease_live` = 1 and `price_monthly` > 0) and `model_long_slug` = 'sprinter-215cdi-l2-diesel-fwd' order by `price_monthly` asc limit 1
      11.16msvandirectVanLeasingSearch.php#102
      Bindings
      • 0: mercedes-benz
      • 1: sprinter-l2
      • 2: 160
      • 3: 1
      • 4: 1
      • 5: 1
      • 6: 0
      • 7: sprinter-215cdi-l2-diesel-fwd
      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` = 'mercedes-benz' and `model_slug` = 'sprinter-l2' and `d_live` = 1 and `live` = 1 and `otrprice` > 4000 and `amount` > 0) order by `otrprice` asc limit 1
      1.26msvandirectNewVanSearch.php#205
      Bindings
      • 0: mercedes-benz
      • 1: sprinter-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` = 'mercedes-benz' and `model_slug` = 'sprinter-l2' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `model_long_slug` = 'sprinter-215cdi-l2-diesel-fwd' order by `derivative` asc
      680μsvandirectVanLeaseFilter.php#69
      Bindings
      • 0: mercedes-benz
      • 1: sprinter-l2
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: sprinter-215cdi-l2-diesel-fwd
      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` = 'mercedes-benz' and `model_slug` = 'sprinter-l2' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `model_long_slug` = 'sprinter-215cdi-l2-diesel-fwd' order by `fuel` asc
      660μsvandirectVanLeaseFilter.php#99
      Bindings
      • 0: mercedes-benz
      • 1: sprinter-l2
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: sprinter-215cdi-l2-diesel-fwd
      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` = 'mercedes-benz' and `model_slug` = 'sprinter-l2' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `model_long_slug` = 'sprinter-215cdi-l2-diesel-fwd' order by `transmission` asc
      650μsvandirectVanLeaseFilter.php#114
      Bindings
      • 0: mercedes-benz
      • 1: sprinter-l2
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: sprinter-215cdi-l2-diesel-fwd
      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` = 'mercedes-benz' and `model_slug` = 'sprinter-l2' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `model_long_slug` = 'sprinter-215cdi-l2-diesel-fwd' and `term` in (6, 12, 18, 24, 36, 48, 60) order by `term` asc
      19.52msvandirectVanLeaseFilter.php#138
      Bindings
      • 0: mercedes-benz
      • 1: sprinter-l2
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: sprinter-215cdi-l2-diesel-fwd
      • 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` = 'mercedes-benz' and `model_slug` = 'sprinter-l2' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `model_long_slug` = 'sprinter-215cdi-l2-diesel-fwd' 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
      20.32msvandirectVanLeaseFilter.php#153
      Bindings
      • 0: mercedes-benz
      • 1: sprinter-l2
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: sprinter-215cdi-l2-diesel-fwd
      • 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` = 'mercedes-benz' and `model_slug` = 'sprinter-l2' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `model_long_slug` = 'sprinter-215cdi-l2-diesel-fwd' 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
      19.73msvandirectVanLeaseFilter.php#169
      Bindings
      • 0: mercedes-benz
      • 1: sprinter-l2
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: sprinter-215cdi-l2-diesel-fwd
      • 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` = 'mercedes-benz' and `model_slug` = 'sprinter-l2' and `lease_live` = 1 and `live` = 1 and `price_monthly` > 0) and `model_long_slug` = 'sprinter-215cdi-l2-diesel-fwd' 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
      19.42msvandirectVanLeaseFilter.php#193
      Bindings
      • 0: mercedes-benz
      • 1: sprinter-l2
      • 2: 1
      • 3: 1
      • 4: 0
      • 5: sprinter-215cdi-l2-diesel-fwd
      • 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` = 'mercedes-benz' and `model_slug` = 'sprinter-l2') group by `make`, `model`, `model_long`, `model_long_slug`, `make_slug`, `model_slug` order by `model_long` asc
      1.67msvandirectVanModel.php#131
      Bindings
      • 0: mercedes-benz
      • 1: sprinter-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` = 'mercedes-benz' and `model_slug` = 'sprinter-l2' and `d_live` = 1 and `live` = 1 and `otrprice` > 4000 and `amount` > 0 and `capid` > 1) and `model_long_slug` = 'sprinter-215cdi-l2-diesel-fwd' order by `otrprice` asc limit 2
      590μsvandirectNewVanSearch.php#276
      Bindings
      • 0: mercedes-benz
      • 1: sprinter-l2
      • 2: 1
      • 3: 1
      • 4: 4000
      • 5: 0
      • 6: 1
      • 7: sprinter-215cdi-l2-diesel-fwd
      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` = 'mercedes-benz' and `model_slug` = 'sprinter-l2' and `d_live` = 1 and `live` = 1 and `otrprice` > 4000 and `amount` > 0 and `capid` > 1) order by `otrprice` asc limit 2
      1.23msvandirectNewVanSearch.php#241
      Bindings
      • 0: mercedes-benz
      • 1: sprinter-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\VanLeaseClick
    121VanLeaseClick.php#?
    App\Models\Van
    57Van.php#?
    App\Models\VanLeaseOffer
    32VanLeaseOffer.php#?
    App\Models\ImagesBackfill
    1ImagesBackfill.php#?
    App\Models\VanCusCar
    1VanCusCar.php#?
        _token
        I0Gujw3nEMIqtkymw4OfGH3kZSfpfrMFf7o1HHcg
        views
        5
        uid
        7201a6e1f5e1bea893a4c3b847640fd6
        last_results_page
        /business-car-leasing/audi/q3-sportback/black-edition/?fTrim=black-edition&page=531trimText%3DBlack%...
        _previous
        array:1 [ "url" => "https://laravel.cars2buy.co.uk/van-leasing/mercedes-benz/sprinter-l2/sprinter-...
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /van-leasing/mercedes-benz/sprinter-l2/sprinter-215cdi-l2-diesel-fwd/
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        0 of 0
        array:2 [ "fVariant" => "sprinter-215cdi-l2-diesel-fwd" "page" => "15" ]
        request_request
        []
        
        request_headers
        0 of 0
        array:19 [ "cookie" => array:1 [ 0 => "_ga=GA1.1.1452880928.1737524294; _gcl_au=1.1.1458568756.1737524294; uid=eyJpdiI6ImNjVFgxWEVZcFhvZWN0ZEFDMjFqQ0E9PSIsInZhbHVlIjoialFITGFxZXlXSXl5UUJSVHhpaHhzRU1FQkM1bzE0YmJKcGNFblQ5dTl3TDlhb29acExmeXFIdVFFaFFjVDlNVDZsWGpzY2EzS3BQVS9sUzYxZGJpbXFOZXVYa2R5djJQS2lqSjM3amFiK0U9IiwibWFjIjoiMTE2ZDMyMWIwNzc4NjhlZTA0YTRjNmY1OTU4NjVjNDFiOTk3MmMwNzFlZWU1YTQxYmM3ZjI1YjA5YzA4YzFmMCIsInRhZyI6IiJ9; XSRF-TOKEN=eyJpdiI6ImI0bkJNU25JaXB0ZzlIT3JCOHp5SXc9PSIsInZhbHVlIjoicGd2aUlIN0E3TEVzRXVnR0dnNWJoeWg1Um4vZUl5N2UycFBvMGpDTTVkdDNsQWdvdm5QVWh3YUpRcHdkU29mNHpzMmwvOFJIMUNGWTZJV0RpM01Ia0RPekV5TTFiYmxtbzQ4TzBqek1ESUl6N0x5bHdFR2FjaXpUWXk4c1lGRzkiLCJtYWMiOiIyMGUzZWYwMDNjNGFhZDk1OGQ0ODhhMDllNWE3NGJiZWE4OWJiNmQ1NzIyNDU5ZmRhNTFjMTE2MmQxZDcxNzEwIiwidGFnIjoiIn0%3D; laravel_session=eyJpdiI6ImkvUmo0UFg0ZVRtdmRqOCtMRkprbEE9PSIsInZhbHVlIjoiRkFTM3hBR1VacjBCaVlQQ3d4cmo5ZVFsbXdQTm8xSHNhaTFzaEFLTkhneVhqUm5FdTNFb0JQaXlOQ0JCT3VjYmlDKzNJbUUzRWFuWmVRRjFrM1NXYWpCeVIzVEZTVmZtT0p0SUdVejNhUjR2S2lqVjB5Mkl6MDY1b3NjZVZEV08iLCJtYWMiOiIxYTIzZTExMTQyMGZlMjg2MGU4MDFkMjYzNWJiZWRjMTI1NDJlN2MwMWQwYWVlMDQ2MTg2ZGUwZTQxYTU1MDg1IiwidGFnIjoiIn0%3D; _ga_N9GLTHNRLQ=GS1.1.1737524293.1.1.1737524314.39.0.0_ga=GA1.1.1452880928.1737524294; _gcl_au=1.1.1458568756.1737524294; uid=eyJpdiI6ImNjVFgxWEVZcFhvZWN0ZEFDMjFqQ0E9PSIsInZhbHVlIjoialFITGFxZXlXSXl5UUJSVHhpaHhzRU1F" ] "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.118.195.223" ] "host" => array:1 [ 0 => "laravel.cars2buy.co.uk" ] ]
        request_cookies
        0 of 0
        array:6 [ "_ga" => null "_gcl_au" => null "uid" => "7201a6e1f5e1bea893a4c3b847640fd6" "XSRF-TOKEN" => "I0Gujw3nEMIqtkymw4OfGH3kZSfpfrMFf7o1HHcg" "laravel_session" => "ffZkHUpSJfTw2Sby9wK2VmRfFwgxSOljLjv4wBxA" "_ga_N9GLTHNRLQ" => null ]
        response_headers
        0 of 0
        array:7 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "private, must-revalidate" ] "date" => array:1 [ 0 => "Wed, 22 Jan 2025 05:38:36 GMT" ] "pragma" => array:1 [ 0 => "no-cache" ] "expires" => array:1 [ 0 => "-1" ] "set-cookie" => array:3 [ 0 => "uid=eyJpdiI6IitCQUZkMFZsWnNHaE1PcFNrOVdRaHc9PSIsInZhbHVlIjoiVTRWQmtNQjhYZkJlL3dGaDgwQ1Jma3RVUE5hVVc5Q2lDOHMzL0lYMm53ZFNaSUJDMFBOWExTT1YxN082UDFJa2JPY3BybnpOOHc5YytoMnRvaXF1R3lWWE81Y0xEZ3FDVFo2V1RGQzhjbUk9IiwibWFjIjoiZTM2ZGNlOWIwYzRlNDk5YTdlZDA0ZDIyMGNjNjM2NmI1YzdmZDM0ODkxZWRjMzQ0MmI4NGM5NmQyN2YyY2VhZiIsInRhZyI6IiJ9; expires=Fri, 24 Mar 5358 08:14:36 GMT; Max-Age=105184578960; path=/; secure; httponly; samesite=laxuid=eyJpdiI6IitCQUZkMFZsWnNHaE1PcFNrOVdRaHc9PSIsInZhbHVlIjoiVTRWQmtNQjhYZkJlL3dGaDgwQ1Jma3RVUE5hVVc5Q2lDOHMzL0lYMm53ZFNaSUJDMFBOWExTT1YxN082UDFJa2JPY3BybnpOOHc5" 1 => "XSRF-TOKEN=eyJpdiI6IldhZ0NBZ3k0Vmx0L0JFdmJPdlBiNWc9PSIsInZhbHVlIjoiUnhUanJoVW82US9XWHR1Z0JDaWxhMUMxQytjbnViSEg4Q1BKNk9pN0w2NUNHMXBGdldKeW93NUowREhUNit4alFXcnQxOGZ5QjJGUndobDl4Rmhwc2w3OGh1Z2MyaW56V2xLMVpCWThvOUIzdzl4QW5mNXRVUU5yYWFOdGYrcmkiLCJtYWMiOiJkZDVjMTI0NzQ5ZTFhYzFjY2FlNjdlYTgwYjMwNTE0MjJiZTAwYjgxZTIwMWUyZGM5MTU1MmRkZjcwZGRjZTJlIiwidGFnIjoiIn0%3D; expires=Wed, 22 Jan 2025 07:38:36 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IldhZ0NBZ3k0Vmx0L0JFdmJPdlBiNWc9PSIsInZhbHVlIjoiUnhUanJoVW82US9XWHR1Z0JDaWxhMUMxQytjbnViSEg4Q1BKNk9pN0w2NUNHMXBGdldKeW93NUowREhUNit4alFXcnQxO" 2 => "laravel_session=eyJpdiI6IkJVeHhZU3BXdDVBSFQ1a3d2VEQrT1E9PSIsInZhbHVlIjoiZFJ2WEtRaWs4NTBIL3Z1Tzh1SnRROW5ReWFHeHhGbFA4RWFPYllYeXd2Q0VQNDMxT1FHWjIwWkt5NFhqRVdKcFZ0THRkU2dWc0pTa2dlbkE3US9YM3YwWnE2V3hPOG8rVkswTXRoZWxURkNxS3JFYmtRY3Bwejl5d2N6RWtSSUEiLCJtYWMiOiIyYWJmZmJlNDI0MTIzYzY3OTQ0ZjRhODgyYzhmZjQzNTc2NzJlODBhYmRiZmVjODI1YTEwZGQ1Yzc2YzhjMGMzIiwidGFnIjoiIn0%3D; expires=Wed, 22 Jan 2025 07:38:36 GMT; Max-Age=7200; path=/; httponly; samesite=laxlaravel_session=eyJpdiI6IkJVeHhZU3BXdDVBSFQ1a3d2VEQrT1E9PSIsInZhbHVlIjoiZFJ2WEtRaWs4NTBIL3Z1Tzh1SnRROW5ReWFHeHhGbFA4RWFPYllYeXd2Q0VQNDMxT1FHWjIwWkt5NFhqRVdKcFZ0" ] "Set-Cookie" => array:3 [ 0 => "uid=eyJpdiI6IitCQUZkMFZsWnNHaE1PcFNrOVdRaHc9PSIsInZhbHVlIjoiVTRWQmtNQjhYZkJlL3dGaDgwQ1Jma3RVUE5hVVc5Q2lDOHMzL0lYMm53ZFNaSUJDMFBOWExTT1YxN082UDFJa2JPY3BybnpOOHc5YytoMnRvaXF1R3lWWE81Y0xEZ3FDVFo2V1RGQzhjbUk9IiwibWFjIjoiZTM2ZGNlOWIwYzRlNDk5YTdlZDA0ZDIyMGNjNjM2NmI1YzdmZDM0ODkxZWRjMzQ0MmI4NGM5NmQyN2YyY2VhZiIsInRhZyI6IiJ9; expires=Fri, 24-Mar-5358 08:14:36 GMT; path=/; secure; httponlyuid=eyJpdiI6IitCQUZkMFZsWnNHaE1PcFNrOVdRaHc9PSIsInZhbHVlIjoiVTRWQmtNQjhYZkJlL3dGaDgwQ1Jma3RVUE5hVVc5Q2lDOHMzL0lYMm53ZFNaSUJDMFBOWExTT1YxN082UDFJa2JPY3BybnpOOHc5" 1 => "XSRF-TOKEN=eyJpdiI6IldhZ0NBZ3k0Vmx0L0JFdmJPdlBiNWc9PSIsInZhbHVlIjoiUnhUanJoVW82US9XWHR1Z0JDaWxhMUMxQytjbnViSEg4Q1BKNk9pN0w2NUNHMXBGdldKeW93NUowREhUNit4alFXcnQxOGZ5QjJGUndobDl4Rmhwc2w3OGh1Z2MyaW56V2xLMVpCWThvOUIzdzl4QW5mNXRVUU5yYWFOdGYrcmkiLCJtYWMiOiJkZDVjMTI0NzQ5ZTFhYzFjY2FlNjdlYTgwYjMwNTE0MjJiZTAwYjgxZTIwMWUyZGM5MTU1MmRkZjcwZGRjZTJlIiwidGFnIjoiIn0%3D; expires=Wed, 22-Jan-2025 07:38:36 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IldhZ0NBZ3k0Vmx0L0JFdmJPdlBiNWc9PSIsInZhbHVlIjoiUnhUanJoVW82US9XWHR1Z0JDaWxhMUMxQytjbnViSEg4Q1BKNk9pN0w2NUNHMXBGdldKeW93NUowREhUNit4alFXcnQxO" 2 => "laravel_session=eyJpdiI6IkJVeHhZU3BXdDVBSFQ1a3d2VEQrT1E9PSIsInZhbHVlIjoiZFJ2WEtRaWs4NTBIL3Z1Tzh1SnRROW5ReWFHeHhGbFA4RWFPYllYeXd2Q0VQNDMxT1FHWjIwWkt5NFhqRVdKcFZ0THRkU2dWc0pTa2dlbkE3US9YM3YwWnE2V3hPOG8rVkswTXRoZWxURkNxS3JFYmtRY3Bwejl5d2N6RWtSSUEiLCJtYWMiOiIyYWJmZmJlNDI0MTIzYzY3OTQ0ZjRhODgyYzhmZjQzNTc2NzJlODBhYmRiZmVjODI1YTEwZGQ1Yzc2YzhjMGMzIiwidGFnIjoiIn0%3D; expires=Wed, 22-Jan-2025 07:38:36 GMT; path=/; httponlylaravel_session=eyJpdiI6IkJVeHhZU3BXdDVBSFQ1a3d2VEQrT1E9PSIsInZhbHVlIjoiZFJ2WEtRaWs4NTBIL3Z1Tzh1SnRROW5ReWFHeHhGbFA4RWFPYllYeXd2Q0VQNDMxT1FHWjIwWkt5NFhqRVdKcFZ0" ] ]
        session_attributes
        0 of 0
        array:7 [ "_token" => "I0Gujw3nEMIqtkymw4OfGH3kZSfpfrMFf7o1HHcg" "views" => 5 "uid" => "7201a6e1f5e1bea893a4c3b847640fd6" "last_results_page" => "/business-car-leasing/audi/q3-sportback/black-edition/?fTrim=black-edition&page=531trimText%3DBlack%20Edition" "_previous" => array:1 [ "url" => "https://laravel.cars2buy.co.uk/van-leasing/mercedes-benz/sprinter-l2/sprinter-215cdi-l2-diesel-fwd?fVariant=sprinter-215cdi-l2-diesel-fwd&page=15" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-01-22 05:38:36GET/van-leasing/mercedes-benz/sprinter-l2/sprinter-215cdi-l2-diesel-fwd/?fVariant=sprinter-215cdi-l2-diesel-fwd&page=15281428212