Volvo XC40 No Deposit Lease Deals:

Volvo XC40

Page 18 of 20 pages

Why use cars2buy?

  • Compare over 3.7 million lease deals
  • All advertising partners are authorised & regulated by the FCA
  • All cars supplied by main UK dealers
  • Manufacturer’s warranty & road tax included on every car
  • Completely free service with no registration required

About the Volvo XC40

Volvo is one of, if not the safest car brands in the world, and the award-winning XC40 is no exception. The company’s smallest SUV proves that the best things come in small packages, bringing everything needed in a family car and all of it in Volvo’s renowned level of quality. The Volvo XC40 is packed with impressive safety technology and is deemed to be one of the safest cars in its class while offering clever storage ideas in the cabin and ample boot space.

The Volvo XC40 is stylish, smooth and refined - perfect for the family wanting something sophisticated but practical. With cars2buy’s range of Volvo XC40 lease deals, you could be driving away in one sooner than you think.

Why Lease a Volvo XC40?

A Volvo XC40 personal lease deal will grant you instant peace of mind when it comes to the financing of your new car, because you will benefit from fixed monthly payments on a contract lasting as long as you want it to, within limits. Typically, personal lease deals will last 24, 36 or 48 months, at the end of which you just hand the car back – no worries about depreciation, no hassles with selling. A Volvo XC40 lease deal will allow you to drive a brand-new car, armed with a full manufacturer’s warranty, with none of the drawbacks of car ownership. Start your search today with our Volvo XC40 leasing options.

Why Choose cars2buy for Volvo XC40 Leasing?

If you’ve decided to seek out an XC40, you’ll naturally want to find and compare whatever is on offer, which can be a bit time-consuming. However, at cars2buy, we have done the work for you and brought together a vast array of Volvo XC40 lease deals all in one place. Simply filter your search and our site will show you the best Volvo XC40 lease deals for your needs. Quick, simple and effective!

What are the Alternatives to the Volvo XC40?

If you want to weigh up more options, the Volvo XC40 has several comparable options that could also meet your needs. If you wish to stay within the Volvo family, the XC60 is a slightly larger model that could be a better fit for you. In Germany, you’ll find many suitors to compete with the Volvo XC40, including the premium-feeling Audi Q3, spacious Volkswagen Tiguan and dynamic BMW X1. Lastly, the Lexus NX is a valiant hybrid option that provides a luxurious, fuel-efficient ride.

How Much Is It to Lease a Volvo XC40?

The cost to lease a Volvo XC40 can vary wildly based on the lease term, mileage allowance and more. To find the most current and competitive lease deals, browse our Volvo XC40 leasing deals above, which is updated daily with the latest offers.

How Long is the Waiting List for a Volvo XC40?

Demand for the Volvo XC40 is extremely high, with a waiting list of around four months for new purchases. But, you can get ahead and drive it now with cars2buy’s range of Volvo XC40 hybrid leases.

×

Filter your results:

Lease details:

Car details:

Request history8.2.27PHP Version394msRequest Duration2MBMemory UsageGET personal-car-leasing/{manufacturer}/{model}/{trim}/no-depositRoute
    • Booting (36.08ms)time
    • Application (358ms)time
    • 1 x Application (90.84%)
      358ms
      1 x Booting (9.16%)
      36.08ms
      14 templates were rendered
      • leasing.showshow.blade.php#?blade
      • leasing.search-barsearch-bar.blade.php#?blade
      • includes.paginationpagination.blade.php#?blade
      • leasing.filters.leasing-filterleasing-filter.blade.php#?blade
      • includes.car-filterscar-filters.blade.php#?blade
      • includes.car-reviewcar-review.blade.php#?blade
      • leasing.extraextra.blade.php#?blade
      • leasing.filters.leasing-filterleasing-filter.blade.php#?blade
      • includes.car-filterscar-filters.blade.php#?blade
      • appapp.blade.php#?blade
      • share.headhead.blade.php#?blade
      • share.headerheader.blade.php#?blade
      • share.footerfooter.blade.php#?blade
      • share.footfoot.blade.php#?blade
      uri
      GET personal-car-leasing/{manufacturer}/{model}/{trim}/no-deposit
      middleware
      web
      controller
      App\Http\Controllers\CarLeasingController@results
      namespace
      where
      as
      personal-leasing-results-trim-nodeposit
      file
      app/Http/Controllers/CarLeasingController.php:228-390
      56 statements were executed34.4ms
      • Connection EstablishedbrampacModel.php#350
        Backtrace
        • 14. app/Queries/Model.php:350
        • 15. app/Http/Controllers/Controller.php:53
        • 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 `trim` from `car_specs` where (`make_slug` = 'volvo' and `model_slug` = 'xc40' and `trim_slug` = 'ultra-black-edition') limit 1
        940μsbrampacModel.php#357
        Bindings
        • 0: volvo
        • 1: xc40
        • 2: ultra-black-edition
        Backtrace
        • 15. app/Queries/Model.php:357
        • 16. app/Http/Controllers/Controller.php:53
        • 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 `car_id` from `car_specs` where (`make_slug` = 'volvo' and `model_slug` = 'xc40' and `trim_slug` = 'ultra-black-edition') limit 1
        90μsbrampacController.php#369
        Bindings
        • 0: volvo
        • 1: xc40
        • 2: ultra-black-edition
        Backtrace
        • 15. app/Http/Controllers/Controller.php:369
        • 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_personal` inner join `car_specs` on `car_specs`.`car_id` = `lease_offers_personal`.`id_car` inner join `dealers` on `dealers`.`did` = `lease_offers_personal`.`bid` where (`make_slug` = 'volvo' and `model_slug` = 'xc40' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `deposit_type` <= 1 and `trim_slug` = 'ultra-black-edition'
        2.79msbrampacCarLeasingSearch.php#58
        Bindings
        • 0: volvo
        • 1: xc40
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 1
        • 6: ultra-black-edition
        Backtrace
        • 16. app/Queries/CarLeasingSearch.php:58
        • 17. app/Http/Controllers/CarLeasingController.php:256
        • 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_hash, same_deal_hash, d_sub, d_subid, lease_live, logo, name, linked, cap_id, car_id, business, personal, in_stock, delivery_time_type, delivery_time_value, metallic_inc, term, mileage, deposit, price_monthly, admin_fee, version, urllink, bid, lease_id, make, model, make_slug, model_slug, trim, uk_list from `lease_offers_personal` inner join `car_specs` on `car_specs`.`car_id` = `lease_offers_personal`.`id_car` inner join `dealers` on `dealers`.`did` = `lease_offers_personal`.`bid` where (`make_slug` = 'volvo' and `model_slug` = 'xc40' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `deposit_type` <= 1 and `trim_slug` = 'ultra-black-edition' order by price_monthly, effective_cost limit 10 offset 170
        3.3msbrampacCarLeasingSearch.php#58
        Bindings
        • 0: volvo
        • 1: xc40
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 1
        • 6: ultra-black-edition
        Backtrace
        • 16. app/Queries/CarLeasingSearch.php:58
        • 17. app/Http/Controllers/CarLeasingController.php:256
        • 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 `car_specs`.`cap_id` from `car_specs` inner join `images_izmo` on `car_specs`.`cap_id` = `images_izmo`.`cap_id` where `make_slug` = 'volvo' and `model_slug` = 'xc40' and `trim_slug` = 'ultra-black-edition' order by `car_specs`.`cap_id` desc limit 1
        430μsbrampacModel.php#154
        Bindings
        • 0: volvo
        • 1: xc40
        • 2: ultra-black-edition
        Backtrace
        • 16. app/Queries/Model.php:154
        • 17. app/Http/Controllers/CarLeasingController.php:303
        • 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 `path`, `izmoAlias` from `images_izmo` where `cap_id` = 0 and `ima_type` = 'CAR' and `path` != '' and `izmoAlias` != '' order by `ima_model_year` desc limit 1
        120μsbrampacImagesRepository.php#28
        Bindings
        • 0: 0
        • 1: CAR
        • 2: 
        • 3: 
        Backtrace
        • 16. app/Queries/ImagesRepository.php:28
        • 17. app/Traits/VehicleImage.php:77
        • 18. app/Http/Controllers/CarLeasingController.php:304
        • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select `make`, `model` from `car_specs` where `cap_id` = 0 limit 1
        170μsbrampacVehicleImage.php#85
        Bindings
        • 0: 0
        Backtrace
        • 16. app/Traits/VehicleImage.php:85
        • 17. app/Http/Controllers/CarLeasingController.php:304
        • 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 `bid` from `lease_features` where `manufacturer` = 'Volvo' order by RAND() limit 1
        190μsbrampacCarLeasingSearch.php#117
        Bindings
        • 0: Volvo
        Backtrace
        • 13. app/Queries/CarLeasingSearch.php:117
        • 14. app/Http/Controllers/CarLeasingController.php:306
        • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • select `make_related`, `model_related`, `min_price` from `related_lease_models` inner join `min_price_personal_lease` on `min_price_personal_lease`.`make` = `related_lease_models`.`make_related` and `min_price_personal_lease`.`model` = `related_lease_models`.`model_related` where (`related_lease_models`.`make` = 'Volvo' and `related_lease_models`.`model` = 'XC40') group by `make_related`, `model_related` order by sort_order ASC limit 5
        460μsbrampacCarLeasingSearch.php#173
        Bindings
        • 0: Volvo
        • 1: XC40
        Backtrace
        • 15. app/Queries/CarLeasingSearch.php:173
        • 16. app/Http/Controllers/CarLeasingController.php:307
        • 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 `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'Volkswagen' and `car_specs`.`model` = 'Tiguan' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
        130μsbrampacImagesRepository.php#53
        Bindings
        • 0: Volkswagen
        • 1: Tiguan
        • 2: 
        • 3: 
        • 4: CAR
        Backtrace
        • 14. app/Queries/ImagesRepository.php:53
        • 15. app/Traits/VehicleImage.php:112
        • 16. app/Queries/CarLeasingSearch.php:176
        • 17. app/Http/Controllers/CarLeasingController.php:307
        • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select `path`, `izmoAlias` from `images_backfill` where `ima_make` = 'Volkswagen' and `ima_model` = 'Tiguan' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' limit 1
        200μsbrampacImagesRepository.php#97
        Bindings
        • 0: Volkswagen
        • 1: Tiguan
        • 2: 
        • 3: 
        • 4: CAR
        Backtrace
        • 16. app/Queries/ImagesRepository.php:97
        • 17. app/Traits/VehicleImage.php:121
        • 18. app/Queries/CarLeasingSearch.php:176
        • 19. app/Http/Controllers/CarLeasingController.php:307
        • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'Hyundai' and `car_specs`.`model` = 'Tucson' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
        120μsbrampacImagesRepository.php#53
        Bindings
        • 0: Hyundai
        • 1: Tucson
        • 2: 
        • 3: 
        • 4: CAR
        Backtrace
        • 14. app/Queries/ImagesRepository.php:53
        • 15. app/Traits/VehicleImage.php:112
        • 16. app/Queries/CarLeasingSearch.php:176
        • 17. app/Http/Controllers/CarLeasingController.php:307
        • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'Volkswagen' and `car_specs`.`model` = 'T-Roc' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
        100μsbrampacImagesRepository.php#53
        Bindings
        • 0: Volkswagen
        • 1: T-Roc
        • 2: 
        • 3: 
        • 4: CAR
        Backtrace
        • 14. app/Queries/ImagesRepository.php:53
        • 15. app/Traits/VehicleImage.php:112
        • 16. app/Queries/CarLeasingSearch.php:176
        • 17. app/Http/Controllers/CarLeasingController.php:307
        • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'Nissan' and `car_specs`.`model` = 'Qashqai' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
        100μsbrampacImagesRepository.php#53
        Bindings
        • 0: Nissan
        • 1: Qashqai
        • 2: 
        • 3: 
        • 4: CAR
        Backtrace
        • 14. app/Queries/ImagesRepository.php:53
        • 15. app/Traits/VehicleImage.php:112
        • 16. app/Queries/CarLeasingSearch.php:176
        • 17. app/Http/Controllers/CarLeasingController.php:307
        • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select `path`, `izmoAlias` from `images_backfill` where `ima_make` = 'Nissan' and `ima_model` = 'Qashqai' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' limit 1
        90μsbrampacImagesRepository.php#97
        Bindings
        • 0: Nissan
        • 1: Qashqai
        • 2: 
        • 3: 
        • 4: CAR
        Backtrace
        • 16. app/Queries/ImagesRepository.php:97
        • 17. app/Traits/VehicleImage.php:121
        • 18. app/Queries/CarLeasingSearch.php:176
        • 19. app/Http/Controllers/CarLeasingController.php:307
        • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'SEAT' and `car_specs`.`model` = 'Ateca' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
        190μsbrampacImagesRepository.php#53
        Bindings
        • 0: SEAT
        • 1: Ateca
        • 2: 
        • 3: 
        • 4: CAR
        Backtrace
        • 14. app/Queries/ImagesRepository.php:53
        • 15. app/Traits/VehicleImage.php:112
        • 16. app/Queries/CarLeasingSearch.php:176
        • 17. app/Http/Controllers/CarLeasingController.php:307
        • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select distinct `make`, `model`, `version`, `trim`, `make_slug`, `model_slug` from `car_specs` where (`make_slug` = 'volvo' and `model_slug` = 'xc40') group by `trim` order by `trim` asc
        460μsbrampacModel.php#128
        Bindings
        • 0: volvo
        • 1: xc40
        Backtrace
        • 13. app/Queries/Model.php:128
        • 14. app/Http/Controllers/CarLeasingController.php:308
        • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • select distinct `make`, `model`, `trim`, `version`, `car_id`, `version_slug` from `car_specs` where (`make_slug` = 'volvo' and `model_slug` = 'xc40' and `trim` = 'Ultra Black Edition') order by `version` asc
        350μsbrampacModel.php#187
        Bindings
        • 0: volvo
        • 1: xc40
        • 2: Ultra Black Edition
        Backtrace
        • 15. app/Queries/Model.php:187
        • 16. app/Http/Controllers/CarLeasingController.php:319
        • 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 `score_overall`, `summary`, `review_date` from `reviews` where (`review_make` = 'Volvo' and `review_model` = 'XC40') order by `review_date` asc limit 1
        200μsbrampacVehicleReview.php#61
        Bindings
        • 0: Volvo
        • 1: XC40
        Backtrace
        • 15. app/Queries/VehicleReview.php:61
        • 16. app/Http/Controllers/CarLeasingController.php:323
        • 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_slug`, `model`, `version`, `cap_id`, `veh_id`, `urllink`, `logo`, `bid`, `d_subid`, `otrprice`, `linked`, `uk_list`, `dealers`.`acc_type`, `cpclick` from `cus_cars` inner join `car_specs` on `car_specs`.`car_id` = `cus_cars`.`id_car` inner join `dealers` on `dealers`.`did` = `cus_cars`.`bid` inner join `account` on `broke_id` = `bid` or `broke_id` = `d_subid` inner join `partner_agents` on `partner_agents`.`pa_bid` = `dealers`.`did` where (`make_slug` = 'volvo' and `model_slug` = 'xc40' and `amount` > 0 and `d_live` = 1 and `live` = 1 and `cap_id` > 1 and `otrprice` > 5000 and `pa_pid` = 5) and `trim_slug` = 'ultra-black-edition' order by `otrprice` asc limit 2
        540μsbrampacNewCarSearch.php#227
        Bindings
        • 0: volvo
        • 1: xc40
        • 2: 0
        • 3: 1
        • 4: 1
        • 5: 1
        • 6: 5000
        • 7: 5
        • 8: ultra-black-edition
        Backtrace
        • 15. app/Queries/NewCarSearch.php:227
        • 16. app/Http/Controllers/CarLeasingController.php:326
        • 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_slug`, `model`, `version`, `cap_id`, `veh_id`, `urllink`, `logo`, `bid`, `d_subid`, `otrprice`, `linked`, `uk_list`, `dealers`.`acc_type`, `cpclick` from `cus_cars` inner join `car_specs` on `car_specs`.`car_id` = `cus_cars`.`id_car` inner join `dealers` on `dealers`.`did` = `cus_cars`.`bid` inner join `account` on `broke_id` = `bid` or `broke_id` = `d_subid` inner join `partner_agents` on `partner_agents`.`pa_bid` = `dealers`.`did` where (`make_slug` = 'volvo' and `model_slug` = 'xc40' and `amount` > 0 and `d_live` = 1 and `live` = 1 and `cap_id` > 1 and `otrprice` > 5000 and `pa_pid` = 5) order by `otrprice` asc limit 2
        610μsbrampacNewCarSearch.php#227
        Bindings
        • 0: volvo
        • 1: xc40
        • 2: 0
        • 3: 1
        • 4: 1
        • 5: 1
        • 6: 5000
        • 7: 5
        Backtrace
        • 15. app/Queries/NewCarSearch.php:227
        • 16. app/Http/Controllers/CarLeasingController.php:329
        • 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, model, MIN(otrprice/uk_list) as discount from `cus_cars` inner join `car_specs` on `car_specs`.`car_id` = `cus_cars`.`id_car` inner join `dealers` on `dealers`.`did` = `cus_cars`.`bid` inner join `account` on `broke_id` = `bid` or `broke_id` = `d_subid` inner join `partner_agents` on `partner_agents`.`pa_bid` = `dealers`.`did` where (`make_slug` = 'volvo' and `model_slug` = 'xc40' and `live` = 1 and `cap_id` > 1 and `d_live` = 1 and `amount` > 0 and `otrprice` > 5000 and `uk_list` > 1000 and `pa_pid` = 5) and (otrprice/uk_list) <= 0.995 group by `model`
        590μsbrampacNewCarSearch.php#260
        Bindings
        • 0: volvo
        • 1: xc40
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 0
        • 6: 5000
        • 7: 1000
        • 8: 5
        Backtrace
        • 15. app/Queries/NewCarSearch.php:260
        • 16. app/Http/Controllers/CarLeasingController.php:334
        • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • select distinct `make`, `make_slug` from `car_specs` order by `make` asc
        110μsbrampacManufacturer.php#17
        Backtrace
        • 15. app/Queries/Manufacturer.php:17
        • 16. app/Http/Controllers/CarLeasingController.php:350
        • 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 `car_specs`.`make`, `car_specs`.`model`, `car_specs`.`make_slug`, `car_specs`.`model_slug`, `min_price_personal_lease`.`min_price` as `price_monthly` from `car_specs` left join `min_price_personal_lease` on `car_specs`.`make` = `min_price_personal_lease`.`make` and `car_specs`.`model` = `min_price_personal_lease`.`model` where `car_specs`.`make` = 'volvo' group by `car_specs`.`model` order by `car_specs`.`model` asc
        3.07msbrampacModel.php#85
        Bindings
        • 0: volvo
        Backtrace
        • 13. app/Queries/Model.php:85
        • 14. app/Http/Controllers/CarLeasingController.php:352
        • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'Volvo' and `car_specs`.`model` = 'C40' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
        190μsbrampacImagesRepository.php#53
        Bindings
        • 0: Volvo
        • 1: C40
        • 2: 
        • 3: 
        • 4: CAR
        Backtrace
        • 14. app/Queries/ImagesRepository.php:53
        • 15. app/Traits/VehicleImage.php:112
        • 16. app/Queries/Model.php:88
        • 17. app/Http/Controllers/CarLeasingController.php:352
        • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select `path`, `izmoAlias` from `images_backfill` where `ima_make` = 'Volvo' and `ima_model` = 'C40' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' limit 1
        130μsbrampacImagesRepository.php#97
        Bindings
        • 0: Volvo
        • 1: C40
        • 2: 
        • 3: 
        • 4: CAR
        Backtrace
        • 16. app/Queries/ImagesRepository.php:97
        • 17. app/Traits/VehicleImage.php:121
        • 18. app/Queries/Model.php:88
        • 19. app/Http/Controllers/CarLeasingController.php:352
        • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'Volvo' and `car_specs`.`model` = 'EC40' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
        110μsbrampacImagesRepository.php#53
        Bindings
        • 0: Volvo
        • 1: EC40
        • 2: 
        • 3: 
        • 4: CAR
        Backtrace
        • 14. app/Queries/ImagesRepository.php:53
        • 15. app/Traits/VehicleImage.php:112
        • 16. app/Queries/Model.php:88
        • 17. app/Http/Controllers/CarLeasingController.php:352
        • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select `path`, `izmoAlias` from `images_backfill` where `ima_make` = 'Volvo' and `ima_model` = 'EC40' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' limit 1
        90μsbrampacImagesRepository.php#97
        Bindings
        • 0: Volvo
        • 1: EC40
        • 2: 
        • 3: 
        • 4: CAR
        Backtrace
        • 16. app/Queries/ImagesRepository.php:97
        • 17. app/Traits/VehicleImage.php:121
        • 18. app/Queries/Model.php:88
        • 19. app/Http/Controllers/CarLeasingController.php:352
        • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'Volvo' and `car_specs`.`model` = 'EX30' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
        120μsbrampacImagesRepository.php#53
        Bindings
        • 0: Volvo
        • 1: EX30
        • 2: 
        • 3: 
        • 4: CAR
        Backtrace
        • 14. app/Queries/ImagesRepository.php:53
        • 15. app/Traits/VehicleImage.php:112
        • 16. app/Queries/Model.php:88
        • 17. app/Http/Controllers/CarLeasingController.php:352
        • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select `path`, `izmoAlias` from `images_backfill` where `ima_make` = 'Volvo' and `ima_model` = 'EX30' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' limit 1
        90μsbrampacImagesRepository.php#97
        Bindings
        • 0: Volvo
        • 1: EX30
        • 2: 
        • 3: 
        • 4: CAR
        Backtrace
        • 16. app/Queries/ImagesRepository.php:97
        • 17. app/Traits/VehicleImage.php:121
        • 18. app/Queries/Model.php:88
        • 19. app/Http/Controllers/CarLeasingController.php:352
        • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'Volvo' and `car_specs`.`model` = 'EX40' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
        200μsbrampacImagesRepository.php#53
        Bindings
        • 0: Volvo
        • 1: EX40
        • 2: 
        • 3: 
        • 4: CAR
        Backtrace
        • 14. app/Queries/ImagesRepository.php:53
        • 15. app/Traits/VehicleImage.php:112
        • 16. app/Queries/Model.php:88
        • 17. app/Http/Controllers/CarLeasingController.php:352
        • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select `path`, `izmoAlias` from `images_backfill` where `ima_make` = 'Volvo' and `ima_model` = 'EX40' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' limit 1
        170μsbrampacImagesRepository.php#97
        Bindings
        • 0: Volvo
        • 1: EX40
        • 2: 
        • 3: 
        • 4: CAR
        Backtrace
        • 16. app/Queries/ImagesRepository.php:97
        • 17. app/Traits/VehicleImage.php:121
        • 18. app/Queries/Model.php:88
        • 19. app/Http/Controllers/CarLeasingController.php:352
        • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'Volvo' and `car_specs`.`model` = 'EX90' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
        200μsbrampacImagesRepository.php#53
        Bindings
        • 0: Volvo
        • 1: EX90
        • 2: 
        • 3: 
        • 4: CAR
        Backtrace
        • 14. app/Queries/ImagesRepository.php:53
        • 15. app/Traits/VehicleImage.php:112
        • 16. app/Queries/Model.php:88
        • 17. app/Http/Controllers/CarLeasingController.php:352
        • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select `path`, `izmoAlias` from `images_backfill` where `ima_make` = 'Volvo' and `ima_model` = 'EX90' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' limit 1
        120μsbrampacImagesRepository.php#97
        Bindings
        • 0: Volvo
        • 1: EX90
        • 2: 
        • 3: 
        • 4: CAR
        Backtrace
        • 16. app/Queries/ImagesRepository.php:97
        • 17. app/Traits/VehicleImage.php:121
        • 18. app/Queries/Model.php:88
        • 19. app/Http/Controllers/CarLeasingController.php:352
        • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'Volvo' and `car_specs`.`model` = 'S60' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
        210μsbrampacImagesRepository.php#53
        Bindings
        • 0: Volvo
        • 1: S60
        • 2: 
        • 3: 
        • 4: CAR
        Backtrace
        • 14. app/Queries/ImagesRepository.php:53
        • 15. app/Traits/VehicleImage.php:112
        • 16. app/Queries/Model.php:88
        • 17. app/Http/Controllers/CarLeasingController.php:352
        • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'Volvo' and `car_specs`.`model` = 'S90' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
        210μsbrampacImagesRepository.php#53
        Bindings
        • 0: Volvo
        • 1: S90
        • 2: 
        • 3: 
        • 4: CAR
        Backtrace
        • 14. app/Queries/ImagesRepository.php:53
        • 15. app/Traits/VehicleImage.php:112
        • 16. app/Queries/Model.php:88
        • 17. app/Http/Controllers/CarLeasingController.php:352
        • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'Volvo' and `car_specs`.`model` = 'V60' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
        190μsbrampacImagesRepository.php#53
        Bindings
        • 0: Volvo
        • 1: V60
        • 2: 
        • 3: 
        • 4: CAR
        Backtrace
        • 14. app/Queries/ImagesRepository.php:53
        • 15. app/Traits/VehicleImage.php:112
        • 16. app/Queries/Model.php:88
        • 17. app/Http/Controllers/CarLeasingController.php:352
        • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'Volvo' and `car_specs`.`model` = 'V90' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
        190μsbrampacImagesRepository.php#53
        Bindings
        • 0: Volvo
        • 1: V90
        • 2: 
        • 3: 
        • 4: CAR
        Backtrace
        • 14. app/Queries/ImagesRepository.php:53
        • 15. app/Traits/VehicleImage.php:112
        • 16. app/Queries/Model.php:88
        • 17. app/Http/Controllers/CarLeasingController.php:352
        • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'Volvo' and `car_specs`.`model` = 'XC40' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
        180μsbrampacImagesRepository.php#53
        Bindings
        • 0: Volvo
        • 1: XC40
        • 2: 
        • 3: 
        • 4: CAR
        Backtrace
        • 14. app/Queries/ImagesRepository.php:53
        • 15. app/Traits/VehicleImage.php:112
        • 16. app/Queries/Model.php:88
        • 17. app/Http/Controllers/CarLeasingController.php:352
        • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'Volvo' and `car_specs`.`model` = 'XC60' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
        180μsbrampacImagesRepository.php#53
        Bindings
        • 0: Volvo
        • 1: XC60
        • 2: 
        • 3: 
        • 4: CAR
        Backtrace
        • 14. app/Queries/ImagesRepository.php:53
        • 15. app/Traits/VehicleImage.php:112
        • 16. app/Queries/Model.php:88
        • 17. app/Http/Controllers/CarLeasingController.php:352
        • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select `path`, `izmoAlias` from `images_backfill` where `ima_make` = 'Volvo' and `ima_model` = 'XC60' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' limit 1
        820μsbrampacImagesRepository.php#97
        Bindings
        • 0: Volvo
        • 1: XC60
        • 2: 
        • 3: 
        • 4: CAR
        Backtrace
        • 16. app/Queries/ImagesRepository.php:97
        • 17. app/Traits/VehicleImage.php:121
        • 18. app/Queries/Model.php:88
        • 19. app/Http/Controllers/CarLeasingController.php:352
        • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'Volvo' and `car_specs`.`model` = 'XC90' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
        190μsbrampacImagesRepository.php#53
        Bindings
        • 0: Volvo
        • 1: XC90
        • 2: 
        • 3: 
        • 4: CAR
        Backtrace
        • 14. app/Queries/ImagesRepository.php:53
        • 15. app/Traits/VehicleImage.php:112
        • 16. app/Queries/Model.php:88
        • 17. app/Http/Controllers/CarLeasingController.php:352
        • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select `path`, `izmoAlias` from `images_backfill` where `ima_make` = 'Volvo' and `ima_model` = 'XC90' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' limit 1
        170μsbrampacImagesRepository.php#97
        Bindings
        • 0: Volvo
        • 1: XC90
        • 2: 
        • 3: 
        • 4: CAR
        Backtrace
        • 16. app/Queries/ImagesRepository.php:97
        • 17. app/Traits/VehicleImage.php:121
        • 18. app/Queries/Model.php:88
        • 19. app/Http/Controllers/CarLeasingController.php:352
        • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select distinct MAX(price_monthly) as max_price, MIN(price_monthly) as min_price from `car_specs` inner join `lease_offers_personal` on `lease_offers_personal`.`id_car` = `car_specs`.`car_id` inner join `dealers` on `dealers`.`did` = `lease_offers_personal`.`bid` where (`make_slug` = 'volvo' and `model_slug` = 'xc40' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `deposit_type` <= 1 and `trim_slug` = 'ultra-black-edition'
        2.76msbrampacLeaseCarFilter.php#254
        Bindings
        • 0: volvo
        • 1: xc40
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 1
        • 6: ultra-black-edition
        Backtrace
        • 15. app/Queries/SearchFilters/LeaseCarFilter.php:254
        • 16. app/Queries/SearchFilters/LeaseCarFilter.php:20
        • 17. app/Http/Controllers/CarLeasingController.php:367
        • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select distinct 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 `car_specs` inner join `lease_offers_personal` on `lease_offers_personal`.`id_car` = `car_specs`.`car_id` inner join `dealers` on `dealers`.`did` = `lease_offers_personal`.`bid` where (`make_slug` = 'volvo' and `model_slug` = 'xc40' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `deposit_type` <= 1 and `trim_slug` = 'ultra-black-edition'
        2.59msbrampacLeaseCarFilter.php#278
        Bindings
        • 0: volvo
        • 1: xc40
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 1
        • 6: ultra-black-edition
        Backtrace
        • 15. app/Queries/SearchFilters/LeaseCarFilter.php:278
        • 16. app/Queries/SearchFilters/LeaseCarFilter.php:24
        • 17. app/Http/Controllers/CarLeasingController.php:367
        • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select distinct `car_id`, `version` from `car_specs` inner join `lease_offers_personal` on `lease_offers_personal`.`id_car` = `car_specs`.`car_id` inner join `dealers` on `dealers`.`did` = `lease_offers_personal`.`bid` where (`make_slug` = 'volvo' and `model_slug` = 'xc40' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `deposit_type` <= 1 and `trim_slug` = 'ultra-black-edition' order by `version` asc
        500μsbrampacLeaseCarFilter.php#103
        Bindings
        • 0: volvo
        • 1: xc40
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 1
        • 6: ultra-black-edition
        Backtrace
        • 15. app/Queries/SearchFilters/LeaseCarFilter.php:103
        • 16. app/Queries/SearchFilters/LeaseCarFilter.php:32
        • 17. app/Http/Controllers/CarLeasingController.php:367
        • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select distinct `fuel` from `car_specs` inner join `lease_offers_personal` on `lease_offers_personal`.`id_car` = `car_specs`.`car_id` inner join `dealers` on `dealers`.`did` = `lease_offers_personal`.`bid` where (`make_slug` = 'volvo' and `model_slug` = 'xc40' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `deposit_type` <= 1 and `trim_slug` = 'ultra-black-edition' order by `fuel` asc
        590μsbrampacLeaseCarFilter.php#133
        Bindings
        • 0: volvo
        • 1: xc40
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 1
        • 6: ultra-black-edition
        Backtrace
        • 15. app/Queries/SearchFilters/LeaseCarFilter.php:133
        • 16. app/Queries/SearchFilters/LeaseCarFilter.php:38
        • 17. app/Http/Controllers/CarLeasingController.php:367
        • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select distinct `transmission` from `car_specs` inner join `lease_offers_personal` on `lease_offers_personal`.`id_car` = `car_specs`.`car_id` inner join `dealers` on `dealers`.`did` = `lease_offers_personal`.`bid` where (`make_slug` = 'volvo' and `model_slug` = 'xc40' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `deposit_type` <= 1 and `trim_slug` = 'ultra-black-edition' order by `transmission` asc
        490μsbrampacLeaseCarFilter.php#149
        Bindings
        • 0: volvo
        • 1: xc40
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 1
        • 6: ultra-black-edition
        Backtrace
        • 15. app/Queries/SearchFilters/LeaseCarFilter.php:149
        • 16. app/Queries/SearchFilters/LeaseCarFilter.php:42
        • 17. app/Http/Controllers/CarLeasingController.php:367
        • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select distinct `engine` from `car_specs` inner join `lease_offers_personal` on `lease_offers_personal`.`id_car` = `car_specs`.`car_id` inner join `dealers` on `dealers`.`did` = `lease_offers_personal`.`bid` where (`make_slug` = 'volvo' and `model_slug` = 'xc40' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `deposit_type` <= 1 and `trim_slug` = 'ultra-black-edition' order by `engine` asc
        490μsbrampacLeaseCarFilter.php#164
        Bindings
        • 0: volvo
        • 1: xc40
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 1
        • 6: ultra-black-edition
        Backtrace
        • 15. app/Queries/SearchFilters/LeaseCarFilter.php:164
        • 16. app/Queries/SearchFilters/LeaseCarFilter.php:46
        • 17. app/Http/Controllers/CarLeasingController.php:367
        • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select distinct `bodytype` from `car_specs` inner join `lease_offers_personal` on `lease_offers_personal`.`id_car` = `car_specs`.`car_id` inner join `dealers` on `dealers`.`did` = `lease_offers_personal`.`bid` where (`make_slug` = 'volvo' and `model_slug` = 'xc40' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `deposit_type` <= 1 and `trim_slug` = 'ultra-black-edition' order by `bodytype` asc
        490μsbrampacLeaseCarFilter.php#178
        Bindings
        • 0: volvo
        • 1: xc40
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 1
        • 6: ultra-black-edition
        Backtrace
        • 15. app/Queries/SearchFilters/LeaseCarFilter.php:178
        • 16. app/Queries/SearchFilters/LeaseCarFilter.php:50
        • 17. app/Http/Controllers/CarLeasingController.php:367
        • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select distinct `doors` from `car_specs` inner join `lease_offers_personal` on `lease_offers_personal`.`id_car` = `car_specs`.`car_id` inner join `dealers` on `dealers`.`did` = `lease_offers_personal`.`bid` where (`make_slug` = 'volvo' and `model_slug` = 'xc40' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `deposit_type` <= 1 and `trim_slug` = 'ultra-black-edition' order by `doors` asc
        440μsbrampacLeaseCarFilter.php#193
        Bindings
        • 0: volvo
        • 1: xc40
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 1
        • 6: ultra-black-edition
        Backtrace
        • 15. app/Queries/SearchFilters/LeaseCarFilter.php:193
        • 16. app/Queries/SearchFilters/LeaseCarFilter.php:54
        • 17. app/Http/Controllers/CarLeasingController.php:367
        • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select distinct `term` from `car_specs` inner join `lease_offers_personal` on `lease_offers_personal`.`id_car` = `car_specs`.`car_id` inner join `dealers` on `dealers`.`did` = `lease_offers_personal`.`bid` where (`make_slug` = 'volvo' and `model_slug` = 'xc40' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `deposit_type` <= 1 and `trim_slug` = 'ultra-black-edition' and `term` in (6, 12, 18, 24, 36, 48, 60) order by `term` asc
        3.56msbrampacLeaseCarFilter.php#208
        Bindings
        • 0: volvo
        • 1: xc40
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 1
        • 6: ultra-black-edition
        • 7: 6
        • 8: 12
        • 9: 18
        • 10: 24
        • 11: 36
        • 12: 48
        • 13: 60
        Backtrace
        • 15. app/Queries/SearchFilters/LeaseCarFilter.php:208
        • 16. app/Queries/SearchFilters/LeaseCarFilter.php:58
        • 17. app/Http/Controllers/CarLeasingController.php:367
        • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select distinct `mileage` from `car_specs` inner join `lease_offers_personal` on `lease_offers_personal`.`id_car` = `car_specs`.`car_id` inner join `dealers` on `dealers`.`did` = `lease_offers_personal`.`bid` where (`make_slug` = 'volvo' and `model_slug` = 'xc40' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `deposit_type` <= 1 and `trim_slug` = 'ultra-black-edition' 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.74msbrampacLeaseCarFilter.php#238
        Bindings
        • 0: volvo
        • 1: xc40
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 1
        • 6: ultra-black-edition
        • 7: 6
        • 8: 12
        • 9: 18
        • 10: 24
        • 11: 36
        • 12: 48
        • 13: 60
        • 14: 5000
        • 15: 6000
        • 16: 8000
        • 17: 10000
        • 18: 12000
        • 19: 15000
        • 20: 20000
        • 21: 25000
        • 22: 30000
        • 23: 35000
        • 24: 40000
        Backtrace
        • 15. app/Queries/SearchFilters/LeaseCarFilter.php:238
        • 16. app/Queries/SearchFilters/LeaseCarFilter.php:66
        • 17. app/Http/Controllers/CarLeasingController.php:367
        • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select (personal+business) as total from `lease_offers_count` order by `id` desc limit 1
        100μsbrampacCarLeasingSearch.php#191
        Backtrace
        • 13. app/Queries/CarLeasingSearch.php:191
        • 14. app/Http/Controllers/CarLeasingController.php:368
        • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • select `Text` from `seo` where (`Make` = 'Volvo' and `Model` = 'XC40' and `Type` = 'Car - Personal Lease')
        360μsbrampacSearchOptimisation.php#19
        Bindings
        • 0: Volvo
        • 1: XC40
        • 2: Car - Personal Lease
        Backtrace
        • 15. app/Queries/SearchOptimisation.php:19
        • 16. app/Http/Controllers/CarLeasingController.php:378
        • 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 `min_price` from `min_price_personal_lease` where `make` = 'Volvo' and `model` = 'XC40' limit 1
        180μsbrampacCarLeasingSearch.php#629
        Bindings
        • 0: Volvo
        • 1: XC40
        Backtrace
        • 16. app/Queries/CarLeasingSearch.php:629
        • 17. app/Http/Controllers/CarLeasingController.php:381
        • 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
      App\Models\CarSpec
      75CarSpec.php#?
      App\Models\LeaseOfferPersonal
      10LeaseOfferPersonal.php#?
      App\Models\RelatedLeaseModel
      5RelatedLeaseModel.php#?
      App\Models\ImagesBackfill
      1ImagesBackfill.php#?
      App\Models\Review
      1Review.php#?
      App\Models\Seo
      1Seo.php#?
      App\Models\MinPricePersonalLease
      1MinPricePersonalLease.php#?
          _token
          9biw0kYo2rLBTZYRx1DUojVNUPJDZSPKXT2xYGdR
          views
          2
          uid
          5ea53d5d7ec12470416fe96e14ced8ff
          last_results_page
          /personal-car-leasing/volvo/xc40/ultra-black-edition/no-deposit?fDeposit=1&page=18&trimText=Ultra%20...
          _previous
          array:1 [ "url" => "https://laravel.cars2buy.co.uk/personal-car-leasing/volvo/xc40/ultra-black-edi...
          _flash
          array:2 [ "old" => [] "new" => [] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /personal-car-leasing/volvo/xc40/ultra-black-edition/no-deposit
          status_code
          200
          
          status_text
          OK
          format
          html
          content_type
          text/html; charset=UTF-8
          request_query
          0 of 0
          array:4 [ "fDeposit" => 1 "page" => "18" "trimText" => "Ultra Black Edition" "fTrim" => "ultra-black-edition" ]
          request_request
          []
          
          request_headers
          0 of 0
          array:19 [ "cookie" => array:1 [ 0 => "uid=eyJpdiI6IndDUU95VEYxRitJUkNPZnhlQ0tFb0E9PSIsInZhbHVlIjoiaTRVaHdGTHQ1dEJFMUNIVmRlbkVSbTBvNmlJbTYwMituWUdGSThRcWRwOU5saGxJZklQM3BybW1SamQ0Q0phNFJsdkc1NTRYKy9paDNCZTlOSjc1Nkx3aER0U1Z2RXVXUWhVK0J4UTFHSHM9IiwibWFjIjoiZDkzOGRjOGI5ZDc3Mjg5MWU3ZjUwZDVjNzUwZWU4MDMzZjYzMDJlYzkyYzhhNmJjNTk4N2JjMThjMGEwMDg0MiIsInRhZyI6IiJ9; XSRF-TOKEN=eyJpdiI6IldNV20wV1FFQi91bmtVenNveE91UEE9PSIsInZhbHVlIjoiMlhDWEhnUWRnbmRyc1NNbU5jZk5RbDZoSmJlUkRINlhaWDVRMzhuaUxWMVN6UTQzaG8wRTNPZzZwbEJyenY2YnFvM05TR081cFltekFBc3FDVDg0dWFiNGtjQmxUbnFXVVRGTzJJZEZ6TTJWVktYQVhHa0QxRkJ5MUtXMi9KRGMiLCJtYWMiOiIxMDBjMjk0MzVmYzI4NmRhYWY0NjZiZmM5ZjczYTk0OGZiY2RhYmY2ZmQ4OWYxZTFmMzU3ZTA3NDk3OGY4NjEzIiwidGFnIjoiIn0%3D; laravel_session=eyJpdiI6InhFREhSYURJRlJ0dFNwakVpNnJEc1E9PSIsInZhbHVlIjoiWkZIeWlyS0k4OC83UTkvUGdzMnJPNmhmZmd1ejhWYTRGc2k0YURYN0dOcndRTW9nM1VmUjd1djZ6RHIwMkMzSFI2Rzd3OFVrL3FJenBtdlhaRWtNR0NZdVJZNVZQQTZuZVQxQWdwZFBKbHZtcGNia3EwV3VDVDh2N3ExanpmVnEiLCJtYWMiOiI0M2I5NDlhYjBlNDg4M2U1MGI0OGY1MmE2ZjdjY2I0NDU4Njk4MWFmZTg5ZWJlZTg1ZDIxYTM4MzE4YTQxODAyIiwidGFnIjoiIn0%3D; _ga=GA1.1.1934268627.1737252690; _gcl_au=1.1.1730426684.1737252691; _ga_N9GLTHNRLQ=GS1.1.1737252689.1.0.1737252691.58.0.0uid=eyJpdiI6IndDUU95VEYxRitJUkNPZnhlQ0tFb0E9PSIsInZhbHVlIjoiaTRVaHdGTHQ1dEJFMUNIVmRlbkVSbTBvNmlJbTYwMituWUdGSThRcWRwOU5saGxJZklQM3BybW1SamQ0Q0phNFJsdkc1NTRYKy9p" ] "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.144.113.109" ] "host" => array:1 [ 0 => "laravel.cars2buy.co.uk" ] ]
          request_cookies
          0 of 0
          array:6 [ "uid" => "5ea53d5d7ec12470416fe96e14ced8ff" "XSRF-TOKEN" => "9biw0kYo2rLBTZYRx1DUojVNUPJDZSPKXT2xYGdR" "laravel_session" => "nlxuWIJT3PSLSX22KZRqkPNwbY4H0Q6XQwQobDCn" "_ga" => null "_gcl_au" => null "_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 => "Sun, 19 Jan 2025 02:11:34 GMT" ] "pragma" => array:1 [ 0 => "no-cache" ] "expires" => array:1 [ 0 => "-1" ] "set-cookie" => array:3 [ 0 => "uid=eyJpdiI6Iit1TjN1Z2llRlVYVUMzZTBORlRqcFE9PSIsInZhbHVlIjoiTkUwT2pVZHFvS1VORURRb0pJc0tYSG51dnN4TXdpUUxZYWkxZVFHRjFvSlJDRVZSNUszajRTT1RKWmpyS3g3d3VURkRnejczWThNR1lGZFZFRmlVMWZRbkY3NDJIWkd3ZkhJd0g3bnltaEU9IiwibWFjIjoiYjEzM2Y2MjEyN2YwMmRkMDk1MTY1YjczOTVlMmNlNWMyYzU5ZGQ1ZjA4NDNlOGI5YTIxYmNmZDI0NjgyYmM2OSIsInRhZyI6IiJ9; expires=Tue, 13 Sep 5357 13:45:34 GMT; Max-Age=105168281640; path=/; secure; httponly; samesite=laxuid=eyJpdiI6Iit1TjN1Z2llRlVYVUMzZTBORlRqcFE9PSIsInZhbHVlIjoiTkUwT2pVZHFvS1VORURRb0pJc0tYSG51dnN4TXdpUUxZYWkxZVFHRjFvSlJDRVZSNUszajRTT1RKWmpyS3g3d3VURkRnejczWThN" 1 => "XSRF-TOKEN=eyJpdiI6ImlENFJwVXVjeEJqanUxUVRqTy8yM0E9PSIsInZhbHVlIjoiSzFBZzJSTUpVdnlrakpBMUVLbU1CNkhCWFlyenhPczVBVWwrNmFNSlhDZFhBYWprbGRCM3dCQkNFMkFzMXl5UGMrK1JacmlENGZkWEQ3NU45bTJIZTN0MnVpNHc1UlEvamQ4Mk5OdElWbXM0VEdMalFGbVdpM0hHMW9YbHBtbloiLCJtYWMiOiJmNmZhMWRiOWYwYmQ3YjMzMDdhM2I1ZTNiMTc0ODdkNzZjOWI1ODU5OTI1M2QyMGNkMTFhYzgwODNhZWEyNDJkIiwidGFnIjoiIn0%3D; expires=Sun, 19 Jan 2025 04:11:34 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6ImlENFJwVXVjeEJqanUxUVRqTy8yM0E9PSIsInZhbHVlIjoiSzFBZzJSTUpVdnlrakpBMUVLbU1CNkhCWFlyenhPczVBVWwrNmFNSlhDZFhBYWprbGRCM3dCQkNFMkFzMXl5UGMrK1Jac" 2 => "laravel_session=eyJpdiI6IlBxMUo5WnVSQ3N6RzAvck4rc0UzMUE9PSIsInZhbHVlIjoibHdqUWYydHZ2ZWRPSlFPZ21PQnZIS1FvTXRTUXA3czNqelEwZTFWRzArSlBGNW03YndMdkZqZEh5cnFCKzNNRjZOZWxsVkUvVUVQd2pLMkUvblhVQ3RMN1JrZUVQV09DdXJHT0VrYk9jZTZRb09DWUdBODdHM0Z4RDRWTno1UUgiLCJtYWMiOiI4N2VjOWU5OWVhZjcyMTRhNzRlNTUwZTllZmM5YzQyMGM3MDQ2NzFhNTU1NzY3ZTIyZjcwMDVjM2YzMzIxZWUzIiwidGFnIjoiIn0%3D; expires=Sun, 19 Jan 2025 04:11:34 GMT; Max-Age=7200; path=/; httponly; samesite=laxlaravel_session=eyJpdiI6IlBxMUo5WnVSQ3N6RzAvck4rc0UzMUE9PSIsInZhbHVlIjoibHdqUWYydHZ2ZWRPSlFPZ21PQnZIS1FvTXRTUXA3czNqelEwZTFWRzArSlBGNW03YndMdkZqZEh5cnFCKzNNRjZO" ] "Set-Cookie" => array:3 [ 0 => "uid=eyJpdiI6Iit1TjN1Z2llRlVYVUMzZTBORlRqcFE9PSIsInZhbHVlIjoiTkUwT2pVZHFvS1VORURRb0pJc0tYSG51dnN4TXdpUUxZYWkxZVFHRjFvSlJDRVZSNUszajRTT1RKWmpyS3g3d3VURkRnejczWThNR1lGZFZFRmlVMWZRbkY3NDJIWkd3ZkhJd0g3bnltaEU9IiwibWFjIjoiYjEzM2Y2MjEyN2YwMmRkMDk1MTY1YjczOTVlMmNlNWMyYzU5ZGQ1ZjA4NDNlOGI5YTIxYmNmZDI0NjgyYmM2OSIsInRhZyI6IiJ9; expires=Tue, 13-Sep-5357 13:45:34 GMT; path=/; secure; httponlyuid=eyJpdiI6Iit1TjN1Z2llRlVYVUMzZTBORlRqcFE9PSIsInZhbHVlIjoiTkUwT2pVZHFvS1VORURRb0pJc0tYSG51dnN4TXdpUUxZYWkxZVFHRjFvSlJDRVZSNUszajRTT1RKWmpyS3g3d3VURkRnejczWThN" 1 => "XSRF-TOKEN=eyJpdiI6ImlENFJwVXVjeEJqanUxUVRqTy8yM0E9PSIsInZhbHVlIjoiSzFBZzJSTUpVdnlrakpBMUVLbU1CNkhCWFlyenhPczVBVWwrNmFNSlhDZFhBYWprbGRCM3dCQkNFMkFzMXl5UGMrK1JacmlENGZkWEQ3NU45bTJIZTN0MnVpNHc1UlEvamQ4Mk5OdElWbXM0VEdMalFGbVdpM0hHMW9YbHBtbloiLCJtYWMiOiJmNmZhMWRiOWYwYmQ3YjMzMDdhM2I1ZTNiMTc0ODdkNzZjOWI1ODU5OTI1M2QyMGNkMTFhYzgwODNhZWEyNDJkIiwidGFnIjoiIn0%3D; expires=Sun, 19-Jan-2025 04:11:34 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6ImlENFJwVXVjeEJqanUxUVRqTy8yM0E9PSIsInZhbHVlIjoiSzFBZzJSTUpVdnlrakpBMUVLbU1CNkhCWFlyenhPczVBVWwrNmFNSlhDZFhBYWprbGRCM3dCQkNFMkFzMXl5UGMrK1Jac" 2 => "laravel_session=eyJpdiI6IlBxMUo5WnVSQ3N6RzAvck4rc0UzMUE9PSIsInZhbHVlIjoibHdqUWYydHZ2ZWRPSlFPZ21PQnZIS1FvTXRTUXA3czNqelEwZTFWRzArSlBGNW03YndMdkZqZEh5cnFCKzNNRjZOZWxsVkUvVUVQd2pLMkUvblhVQ3RMN1JrZUVQV09DdXJHT0VrYk9jZTZRb09DWUdBODdHM0Z4RDRWTno1UUgiLCJtYWMiOiI4N2VjOWU5OWVhZjcyMTRhNzRlNTUwZTllZmM5YzQyMGM3MDQ2NzFhNTU1NzY3ZTIyZjcwMDVjM2YzMzIxZWUzIiwidGFnIjoiIn0%3D; expires=Sun, 19-Jan-2025 04:11:34 GMT; path=/; httponlylaravel_session=eyJpdiI6IlBxMUo5WnVSQ3N6RzAvck4rc0UzMUE9PSIsInZhbHVlIjoibHdqUWYydHZ2ZWRPSlFPZ21PQnZIS1FvTXRTUXA3czNqelEwZTFWRzArSlBGNW03YndMdkZqZEh5cnFCKzNNRjZO" ] ]
          session_attributes
          0 of 0
          array:7 [ "_token" => "9biw0kYo2rLBTZYRx1DUojVNUPJDZSPKXT2xYGdR" "views" => 2 "uid" => "5ea53d5d7ec12470416fe96e14ced8ff" "last_results_page" => "/personal-car-leasing/volvo/xc40/ultra-black-edition/no-deposit?fDeposit=1&page=18&trimText=Ultra%20Black%20Edition" "_previous" => array:1 [ "url" => "https://laravel.cars2buy.co.uk/personal-car-leasing/volvo/xc40/ultra-black-edition/no-deposit?fDeposit=1&page=18&trimText=Ultra%20Black%20Edition" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
          ClearShow all
          Date ↕MethodURLData
          #12025-01-19 02:11:34GET/personal-car-leasing/volvo/xc40/ultra-black-edition/no-deposit?fDeposit=1&page=18&trimText=Ultra%20Black%20Edition145694