Mazda CX-5 No Deposit Lease Deals:

Mazda CX-5
  • 20 Week Delivery
    Select Car Leasing

    Mazda CX-5

    2.0 e-Skyactiv G MHEV Homura 5dr

    Term: 48 months

    Annual Mileage: 5,000

    Initial Payment: £378.67

    Processing Fees: £294.00

    Total Cost of Lease: £18,470

    Average Monthly Cost: £384.80

    (All prices inc. VAT)

    47Monthly Payments:

    £378.67

    Deal Details
  • Express Vehicle Contracts

    Mazda CX-5

    2.0 e-Skyactiv G MHEV Homura 5dr

    Term: 48 months

    Annual Mileage: 5,000

    Initial Payment: £382.66

    Processing Fees: £294.00

    Total Cost of Lease: £18,662

    Average Monthly Cost: £388.79

    (All prices inc. VAT)

    47Monthly Payments:

    £382.66

    Deal Details
  • mail-icon Subscribe to our hottest deals

    Subscribe to get the hottest lease deals straight to your inbox each week
  • UK Carline

    Mazda CX-5

    2.0 e-Skyactiv G MHEV Homura 5dr

    Term: 48 months

    Annual Mileage: 6,000

    Initial Payment: £384.66

    Processing Fees: £269.99

    Total Cost of Lease: £18,734

    Average Monthly Cost: £390.28

    (All prices inc. VAT)

    47Monthly Payments:

    £384.66

    Deal Details
  • 20 Week Delivery
    Select Car Leasing

    Mazda CX-5

    2.0 e-Skyactiv G MHEV Homura 5dr

    Term: 36 months

    Annual Mileage: 5,000

    Initial Payment: £386.63

    Processing Fees: £294.00

    Total Cost of Lease: £14,213

    Average Monthly Cost: £394.80

    (All prices inc. VAT)

    35Monthly Payments:

    £386.63

    Deal Details
  • 20 Week Delivery
    Select Car Leasing

    Mazda CX-5

    2.0 e-Skyactiv G MHEV Homura 5dr

    Term: 48 months

    Annual Mileage: 8,000

    Initial Payment: £390.30

    Processing Fees: £294.00

    Total Cost of Lease: £19,028

    Average Monthly Cost: £396.43

    (All prices inc. VAT)

    47Monthly Payments:

    £390.30

    Deal Details
  • UK Carline

    Mazda CX-5

    2.0 e-Skyactiv G MHEV Homura 5dr

    Term: 36 months

    Annual Mileage: 6,000

    Initial Payment: £394.80

    Processing Fees: £269.99

    Total Cost of Lease: £14,483

    Average Monthly Cost: £402.30

    (All prices inc. VAT)

    35Monthly Payments:

    £394.80

    Deal Details
  • UK Carline

    Mazda CX-5

    2.0 e-Skyactiv G MHEV Homura 5dr

    Term: 48 months

    Annual Mileage: 8,000

    Initial Payment: £396.58

    Processing Fees: £269.99

    Total Cost of Lease: £19,306

    Average Monthly Cost: £402.20

    (All prices inc. VAT)

    47Monthly Payments:

    £396.58

    Deal Details
  • Express Vehicle Contracts

    Mazda CX-5

    2.0 e-Skyactiv G MHEV Homura 5dr

    Term: 48 months

    Annual Mileage: 8,000

    Initial Payment: £398.06

    Processing Fees: £294.00

    Total Cost of Lease: £19,401

    Average Monthly Cost: £404.19

    (All prices inc. VAT)

    47Monthly Payments:

    £398.06

    Deal Details
  • 20 Week Delivery
    Select Car Leasing

    Mazda CX-5

    2.0 e-Skyactiv G MHEV Homura 5dr

    Term: 24 months

    Annual Mileage: 5,000

    Initial Payment: £398.74

    Processing Fees: £294.00

    Total Cost of Lease: £9,864

    Average Monthly Cost: £410.99

    (All prices inc. VAT)

    23Monthly Payments:

    £398.74

    Deal Details
  • 20 Week Delivery
    Select Car Leasing

    Mazda CX-5

    2.0 e-Skyactiv G MHEV Homura 5dr

    Term: 36 months

    Annual Mileage: 8,000

    Initial Payment: £401.03

    Processing Fees: £294.00

    Total Cost of Lease: £14,731

    Average Monthly Cost: £409.20

    (All prices inc. VAT)

    35Monthly Payments:

    £401.03

    Deal Details

Page 1 of 9 pages

Prev Next

Why use cars2buy?

  • Compare over 4.2 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 Mazda CX-5

The Mazda CX-5 is a SUV crossover that offers everything you could wish for in an all-round family car. In terms of practicality it really comes up with the goods, offering plenty of internal space for a growing family and a roomy boot for their luggage or sports equipment. The refined interior houses a large amount of equipment that comes as standard across the trim range; and the car is extremely comfortable to ride in. Keen drivers will appreciate the Mazda CX-5 which handles well and is great to drive; with punchy engines and relatively low running costs it does seem to have something of everything needed for modern day family driving.

Why lease a Mazda CX-5?

With the help of a Mazda CX-5 personal lease deal you could find yourself driving the perfect family car very soon. For a fixed monthly rental this stylish SUV could be sitting in your parking spot and you would be relieved of the responsibilities and worries that go with full ownership. A full manufacturer’s warranty will be yours but the concerns of selling on will not be yours. When the contract reaches term after, typically 2, 3 or 4 years, you simply hand the car back leaving you free to get another brand new one.

Compare Mazda CX-5 leases

Family life can be time consuming enough without having to spend hours scouring a lot of different websites for personal lease deals. Here at cars2buy we can help save you both time and money by offering a large range of Mazda CX-5 leases, provided by some of the UK’s best leasing companies, from which you can select the best choice for you. Our prices are updated daily and searching is simple – just enter your requirements, adjust the filters and see what is available. You may be pleasantly surprised.

Mazda CX-5 no deposit lease deals

A number of providers are offering Mazda CX-5 lease deals with no large up-front deposit to pay; all they will need is a down payment of one month’s rental, and the car will be yours to drive away.

×

Filter your results:

Lease details:

Car details:

Request history8.2.27PHP Version371msRequest Duration2MBMemory UsageGET personal-car-leasing/{manufacturer}/{model}/{derivative}/no-depositRoute
    • Booting (37.23ms)time
    • Application (334ms)time
    • 1 x Application (89.96%)
      334ms
      1 x Booting (10.04%)
      37.23ms
      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}/{derivative}/no-deposit
      middleware
      web
      controller
      App\Http\Controllers\CarLeasingController@results
      namespace
      where
      as
      personal-leasing-results-derivative-nodeposit
      file
      app/Http/Controllers/CarLeasingController.php:228-390
      49 statements were executed38.1ms
      • Connection EstablishedbrampacController.php#308
        Backtrace
        • 14. app/Http/Controllers/Controller.php:308
        • 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 `car_id` from `car_specs` where (`make_slug` = 'mazda' and `model_slug` = 'cx-5' and `car_id` = '82545' and `version_slug` = '2.0-e-skyactiv-g-mhev-homura-5dr') limit 1
        800μsbrampacController.php#327
        Bindings
        • 0: mazda
        • 1: cx-5
        • 2: 82545
        • 3: 2.0-e-skyactiv-g-mhev-homura-5dr
        Backtrace
        • 15. app/Http/Controllers/Controller.php:327
        • 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` = 'mazda' and `model_slug` = 'cx-5' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `car_id` = '82545' and `deposit_type` <= 1
        2.29msbrampacCarLeasingSearch.php#58
        Bindings
        • 0: mazda
        • 1: cx-5
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 82545
        • 6: 1
        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` = 'mazda' and `model_slug` = 'cx-5' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `car_id` = '82545' and `deposit_type` <= 1 order by price_monthly, effective_cost limit 10 offset 0
        2.39msbrampacCarLeasingSearch.php#58
        Bindings
        • 0: mazda
        • 1: cx-5
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 82545
        • 6: 1
        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` = 'mazda' and `model_slug` = 'cx-5' and `car_id` = '82545' order by `car_specs`.`cap_id` desc limit 1
        130μsbrampacModel.php#154
        Bindings
        • 0: mazda
        • 1: cx-5
        • 2: 82545
        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` = 101686 and `ima_type` = 'CAR' and `path` != '' and `izmoAlias` != '' order by `ima_model_year` desc limit 1
        100μsbrampacImagesRepository.php#28
        Bindings
        • 0: 101686
        • 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 `bid` from `lease_features` where `manufacturer` = 'Mazda' order by RAND() limit 1
        150μsbrampacCarLeasingSearch.php#117
        Bindings
        • 0: Mazda
        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` = 'Mazda' and `related_lease_models`.`model` = 'CX-5') group by `make_related`, `model_related` order by sort_order ASC limit 5
        450μsbrampacCarLeasingSearch.php#173
        Bindings
        • 0: Mazda
        • 1: CX-5
        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` = '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
        200μ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
        180μ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` = '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
        190μ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` = '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
        150μ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 `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` = 'X-Trail' 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: Nissan
        • 1: X-Trail
        • 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` = 'X-Trail' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' limit 1
        130μsbrampacImagesRepository.php#97
        Bindings
        • 0: Nissan
        • 1: X-Trail
        • 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` = 'Vauxhall' and `car_specs`.`model` = 'Grandland' 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: Vauxhall
        • 1: Grandland
        • 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` = 'mazda' and `model_slug` = 'cx-5') group by `trim` order by `trim` asc
        180μsbrampacModel.php#128
        Bindings
        • 0: mazda
        • 1: cx-5
        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 `trim` from `car_specs` where `car_id` = '82545' limit 1
        160μsbrampacModel.php#173
        Bindings
        • 0: 82545
        Backtrace
        • 13. app/Queries/Model.php:173
        • 14. app/Http/Controllers/CarLeasingController.php:315
        • 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` = 'mazda' and `model_slug` = 'cx-5' and `trim` = 'Homura') order by `version` asc
        180μsbrampacModel.php#187
        Bindings
        • 0: mazda
        • 1: cx-5
        • 2: Homura
        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` = 'Mazda' and `review_model` = 'CX-5') order by `review_date` asc limit 1
        310μsbrampacVehicleReview.php#61
        Bindings
        • 0: Mazda
        • 1: CX-5
        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` = 'mazda' and `model_slug` = 'cx-5' and `amount` > 0 and `d_live` = 1 and `live` = 1 and `cap_id` > 1 and `otrprice` > 5000 and `pa_pid` = 5) and `car_id` = '82545' order by `otrprice` asc limit 2
        280μsbrampacNewCarSearch.php#227
        Bindings
        • 0: mazda
        • 1: cx-5
        • 2: 0
        • 3: 1
        • 4: 1
        • 5: 1
        • 6: 5000
        • 7: 5
        • 8: 82545
        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, 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` = 'mazda' and `model_slug` = 'cx-5' 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`
        200μsbrampacNewCarSearch.php#260
        Bindings
        • 0: mazda
        • 1: cx-5
        • 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
        100μ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` = 'mazda' group by `car_specs`.`model` order by `car_specs`.`model` asc
        3.52msbrampacModel.php#85
        Bindings
        • 0: mazda
        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` = 'Mazda' and `car_specs`.`model` = '2' 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: Mazda
        • 1: 2
        • 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` = 'Mazda' and `car_specs`.`model` = '3 Hatchback' 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: Mazda
        • 1: 3 Hatchback
        • 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` = 'Mazda' and `ima_model` = '3 Hatchback' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' limit 1
        180μsbrampacImagesRepository.php#97
        Bindings
        • 0: Mazda
        • 1: 3 Hatchback
        • 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` = 'Mazda' and `car_specs`.`model` = '3 Saloon' 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: Mazda
        • 1: 3 Saloon
        • 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` = 'Mazda' and `car_specs`.`model` = 'CX-30' 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: Mazda
        • 1: CX-30
        • 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` = 'Mazda' and `car_specs`.`model` = 'CX-5' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
        140μsbrampacImagesRepository.php#53
        Bindings
        • 0: Mazda
        • 1: CX-5
        • 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` = 'Mazda' and `car_specs`.`model` = 'CX-60' 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: Mazda
        • 1: CX-60
        • 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` = 'Mazda' and `car_specs`.`model` = 'CX-80' 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: Mazda
        • 1: CX-80
        • 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` = 'Mazda' and `ima_model` = 'CX-80' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' limit 1
        180μsbrampacImagesRepository.php#97
        Bindings
        • 0: Mazda
        • 1: CX-80
        • 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` = 'Mazda' and `car_specs`.`model` = 'MX-30' 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: Mazda
        • 1: MX-30
        • 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` = 'Mazda' and `car_specs`.`model` = 'MX-5 Convertible' 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: Mazda
        • 1: MX-5 Convertible
        • 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` = 'Mazda' and `ima_model` = 'MX-5 Convertible' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' limit 1
        190μsbrampacImagesRepository.php#97
        Bindings
        • 0: Mazda
        • 1: MX-5 Convertible
        • 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` = 'Mazda' and `car_specs`.`model` = 'MX-5 RF' 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: Mazda
        • 1: MX-5 RF
        • 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 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` = 'mazda' and `model_slug` = 'cx-5' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `car_id` = '82545' and `deposit_type` <= 1
        2.37msbrampacLeaseCarFilter.php#254
        Bindings
        • 0: mazda
        • 1: cx-5
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 82545
        • 6: 1
        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` = 'mazda' and `model_slug` = 'cx-5' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `car_id` = '82545' and `deposit_type` <= 1
        2.4msbrampacLeaseCarFilter.php#278
        Bindings
        • 0: mazda
        • 1: cx-5
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 82545
        • 6: 1
        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 `trim`, `trim_slug` 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` = 'mazda' and `model_slug` = 'cx-5' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `car_id` = '82545' and `deposit_type` <= 1 order by `trim_slug` asc
        2.41msbrampacLeaseCarFilter.php#87
        Bindings
        • 0: mazda
        • 1: cx-5
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 82545
        • 6: 1
        Backtrace
        • 15. app/Queries/SearchFilters/LeaseCarFilter.php:87
        • 16. app/Queries/SearchFilters/LeaseCarFilter.php:28
        • 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 `version` from `car_specs` where `car_id` = '82545'
        100μsbrampacLeaseCarFilter.php#118
        Bindings
        • 0: 82545
        Backtrace
        • 15. app/Queries/SearchFilters/LeaseCarFilter.php:118
        • 16. app/Queries/SearchFilters/LeaseCarFilter.php:34
        • 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` = 'mazda' and `model_slug` = 'cx-5' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `car_id` = '82545' and `deposit_type` <= 1 order by `fuel` asc
        2.45msbrampacLeaseCarFilter.php#133
        Bindings
        • 0: mazda
        • 1: cx-5
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 82545
        • 6: 1
        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` = 'mazda' and `model_slug` = 'cx-5' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `car_id` = '82545' and `deposit_type` <= 1 order by `transmission` asc
        2.22msbrampacLeaseCarFilter.php#149
        Bindings
        • 0: mazda
        • 1: cx-5
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 82545
        • 6: 1
        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` = 'mazda' and `model_slug` = 'cx-5' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `car_id` = '82545' and `deposit_type` <= 1 order by `engine` asc
        2.3msbrampacLeaseCarFilter.php#164
        Bindings
        • 0: mazda
        • 1: cx-5
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 82545
        • 6: 1
        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` = 'mazda' and `model_slug` = 'cx-5' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `car_id` = '82545' and `deposit_type` <= 1 order by `bodytype` asc
        2.01msbrampacLeaseCarFilter.php#178
        Bindings
        • 0: mazda
        • 1: cx-5
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 82545
        • 6: 1
        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` = 'mazda' and `model_slug` = 'cx-5' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `car_id` = '82545' and `deposit_type` <= 1 order by `doors` asc
        1.97msbrampacLeaseCarFilter.php#193
        Bindings
        • 0: mazda
        • 1: cx-5
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 82545
        • 6: 1
        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` = 'mazda' and `model_slug` = 'cx-5' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `car_id` = '82545' and `deposit_type` <= 1 and `term` in (6, 12, 18, 24, 36, 48, 60) order by `term` asc
        2.1msbrampacLeaseCarFilter.php#208
        Bindings
        • 0: mazda
        • 1: cx-5
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 82545
        • 6: 1
        • 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` = 'mazda' and `model_slug` = 'cx-5' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `car_id` = '82545' and `deposit_type` <= 1 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.27msbrampacLeaseCarFilter.php#238
        Bindings
        • 0: mazda
        • 1: cx-5
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 82545
        • 6: 1
        • 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
        170μ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` = 'Mazda' and `Model` = 'CX-5' and `Type` = 'Car - Personal Lease')
        440μsbrampacSearchOptimisation.php#19
        Bindings
        • 0: Mazda
        • 1: CX-5
        • 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` = 'Mazda' and `model` = 'CX-5' limit 1
        250μsbrampacCarLeasingSearch.php#629
        Bindings
        • 0: Mazda
        • 1: CX-5
        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
      78CarSpec.php#?
      App\Models\LeaseOfferPersonal
      10LeaseOfferPersonal.php#?
      App\Models\RelatedLeaseModel
      5RelatedLeaseModel.php#?
      App\Models\CusCar
      2CusCar.php#?
      App\Models\ImagesIzmo
      1ImagesIzmo.php#?
      App\Models\ImagesBackfill
      1ImagesBackfill.php#?
      App\Models\Review
      1Review.php#?
      App\Models\Seo
      1Seo.php#?
      App\Models\MinPricePersonalLease
      1MinPricePersonalLease.php#?
          _token
          EYRRvWvOTKg2QXJylETHRYMUt73wBpGZqrtiuqjN
          views
          3
          uid
          49953a5ca9c1b8c91794646f7ba8db38
          last_results_page
          /personal-car-leasing/mazda/cx-5/2.0-e-skyactiv-g-mhev-homura-5dr_82545/no-deposit?fCarID=82545&fDer...
          _previous
          array:1 [ "url" => "https://laravel.cars2buy.co.uk/personal-car-leasing/mazda/cx-5/2.0-e-skyactiv-...
          _flash
          array:2 [ "old" => [] "new" => [] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /personal-car-leasing/mazda/cx-5/2.0-e-skyactiv-g-mhev-homura-5dr_82545/no-deposit
          status_code
          200
          
          status_text
          OK
          format
          html
          content_type
          text/html; charset=UTF-8
          request_query
          0 of 0
          array:4 [ "fCarID" => "82545" "fDerivative" => "2.0 E Skyactiv G Mhev Homura 5dr" "page" => "2page=6fDerivative=2.0 E Skyactiv G Mhev Homura 5dr" "fDeposit" => 1 ]
          request_request
          []
          
          request_headers
          0 of 0
          array:19 [ "cookie" => array:1 [ 0 => "uid=eyJpdiI6ImpaUVFLaVlmb1p4azNuUG1wZksxR0E9PSIsInZhbHVlIjoicVI2QlRHSEFJRVk3d1p6OXBTTkFyMFVpTnJld1htL2hQTzhtMHdqZEw5eGtoUlRIcnV3Tml6KytJKzJTdkRhN2xNVVRiNFBrdTdhSVJhZTU5aWZJOFFjTDIrV3FWeVR0MjdLVzg0c01xZlE9IiwibWFjIjoiZTRjZjMyYzViM2E3YmQ2ZmRhMjFlY2U3MGE5NDVhMTJjMzJmZTllM2JhNzM2ZGJhMTMxYzk3OTI4YmVlYTNiZSIsInRhZyI6IiJ9; XSRF-TOKEN=eyJpdiI6IisrVDhxbFBKOUdOSjk4UklzUitWNHc9PSIsInZhbHVlIjoicnBMb083Y2JzdnQzSlN2bVN4anNselBab1hEeGZZUGw2ZnM5dERQR2Q4RFNzbWozdG84YitycUV4aVVMNXd1a1czVEZ1RXU5dWg4b1ovaURHYWFQbnFyTzZ5ZVJpMmVWVDRNRDdaVHRvNktndlJmc2RxRVNOUy9nM3RYL0FjMS8iLCJtYWMiOiI1OGMzNmYxNTAwZmUyY2E3ZTNkYWJmYjJkNjhlYjBjMjc3OTZjNWQyZjQ1ZTA0YmU5MzUwOWI2MGYxMzk0NmY0IiwidGFnIjoiIn0%3D; laravel_session=eyJpdiI6Imx5cllrS1pJdnRhTGI2OVhrVlhvRWc9PSIsInZhbHVlIjoic2hsdEFuMzJtS1NsSEJXK01yTmxyMkdFcGNsRWZ2Y25yVCtrRm4xYXdYSlNaZE00QjhEUGxleFZjMFNUUEtwOWNnejR1eisreU53MXFFVmh3RGFvVGt5QzJlV1FQQ005eGMyMC9EbE9BZVBoQmx1WkNoU0xlekR5bEpWU0ZoR3giLCJtYWMiOiJiZjUyZWQ0YWY3OTAyZGUzZGNjYjViMzRjZTgxMDVjMDU1MzNiY2Y0NTdjMDNiMDU5NjgyYjNmNDVlNjNjNzEwIiwidGFnIjoiIn0%3Duid=eyJpdiI6ImpaUVFLaVlmb1p4azNuUG1wZksxR0E9PSIsInZhbHVlIjoicVI2QlRHSEFJRVk3d1p6OXBTTkFyMFVpTnJld1htL2hQTzhtMHdqZEw5eGtoUlRIcnV3Tml6KytJKzJTdkRhN2xNVVRiNFBrdTdh" ] "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.119.18" ] "host" => array:1 [ 0 => "laravel.cars2buy.co.uk" ] ]
          request_cookies
          0 of 0
          array:3 [ "uid" => "49953a5ca9c1b8c91794646f7ba8db38" "XSRF-TOKEN" => "EYRRvWvOTKg2QXJylETHRYMUt73wBpGZqrtiuqjN" "laravel_session" => "0WTtyEZqZit1pwJ2JprNLzCSiuFMBlBeVFmJVlJv" ]
          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 18:48:24 GMT" ] "pragma" => array:1 [ 0 => "no-cache" ] "expires" => array:1 [ 0 => "-1" ] "set-cookie" => array:3 [ 0 => "uid=eyJpdiI6IkRJZmZlR3Q0bjR5Wk1GQ3N3Y3JFNkE9PSIsInZhbHVlIjoieEV1THVBOFdvWmFhZzE1cE5qZkdWVWFxaGg1ZFlsa1RrQVJBdktKd2o5QnpaNm1mVEJQK0ZxRzZOdWJldDJFSWNzMVR1ZzZLeDhKYkxmMVJxK3lqZmttOGhJdUdEMTFLSEF6OHdrMnR5K0k9IiwibWFjIjoiNDgzYWIzZGFlOTM1YmFiNTM4Mjk4NGY2NjhmNWRlZGViYWE1ZWI0NzQwYjFhMjY4MjY0ZTUwZDc5MjVmZTIyNiIsInRhZyI6IiJ9; expires=Wed, 26 Apr 5358 19:12:24 GMT; Max-Age=105187422240; path=/; secure; httponly; samesite=laxuid=eyJpdiI6IkRJZmZlR3Q0bjR5Wk1GQ3N3Y3JFNkE9PSIsInZhbHVlIjoieEV1THVBOFdvWmFhZzE1cE5qZkdWVWFxaGg1ZFlsa1RrQVJBdktKd2o5QnpaNm1mVEJQK0ZxRzZOdWJldDJFSWNzMVR1ZzZLeDhK" 1 => "XSRF-TOKEN=eyJpdiI6IjFrcER3aTFuYXlGZUJOSjVpdk1tV3c9PSIsInZhbHVlIjoiUURzY2dkWUNoRUwvUGlESXZkSWtkU09Fak1qcldBbDR1SEMxQXJnVUVMUjFkSy9jdGZNcFVadFFvZVgyYmRmUHZjTE9paDk0clovKzhZQjRVYmlSclZpajJMd1BaVUszSFZWL00ydm5EZk1XNURJM2xMTC9URlNla0owMFVraWEiLCJtYWMiOiIwNDc2ZWY3MmI1ZDRkMjAxODVjYTExMDI0ZjBhYTk2NGU3N2UwYzZmOTlhOTRkYjNlZjkxMTdlNmEzYzlkYzNiIiwidGFnIjoiIn0%3D; expires=Wed, 22 Jan 2025 20:48:24 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IjFrcER3aTFuYXlGZUJOSjVpdk1tV3c9PSIsInZhbHVlIjoiUURzY2dkWUNoRUwvUGlESXZkSWtkU09Fak1qcldBbDR1SEMxQXJnVUVMUjFkSy9jdGZNcFVadFFvZVgyYmRmUHZjTE9pa" 2 => "laravel_session=eyJpdiI6IkxzNTZPL3JJNnEzcmJsa2FldjVMVXc9PSIsInZhbHVlIjoiTVFreW9RejZaVllBV25qclJRNWdqdjBOVEYwazFRdEtZdXFndzMrSjFpQzdNQUU4ejJWeW8vK2RMYURVVkNXeWFxQmhWMnBVWXFkajY4UVZSSlBWUWFBMVJrWHRTdEVKSThMbHhpNWRzMWhOb05EZ2lUbWZGa0VmQlFaMFBBNjkiLCJtYWMiOiI5ODI0OTQ5NGM0MWViY2UxZjhlN2Q4ZWQ1MmQyYzY5YTMyZjEzMmIyM2IxZTE1N2VkNjBmOTZmOWEyZDg1Y2JjIiwidGFnIjoiIn0%3D; expires=Wed, 22 Jan 2025 20:48:24 GMT; Max-Age=7200; path=/; httponly; samesite=laxlaravel_session=eyJpdiI6IkxzNTZPL3JJNnEzcmJsa2FldjVMVXc9PSIsInZhbHVlIjoiTVFreW9RejZaVllBV25qclJRNWdqdjBOVEYwazFRdEtZdXFndzMrSjFpQzdNQUU4ejJWeW8vK2RMYURVVkNXeWFx" ] "Set-Cookie" => array:3 [ 0 => "uid=eyJpdiI6IkRJZmZlR3Q0bjR5Wk1GQ3N3Y3JFNkE9PSIsInZhbHVlIjoieEV1THVBOFdvWmFhZzE1cE5qZkdWVWFxaGg1ZFlsa1RrQVJBdktKd2o5QnpaNm1mVEJQK0ZxRzZOdWJldDJFSWNzMVR1ZzZLeDhKYkxmMVJxK3lqZmttOGhJdUdEMTFLSEF6OHdrMnR5K0k9IiwibWFjIjoiNDgzYWIzZGFlOTM1YmFiNTM4Mjk4NGY2NjhmNWRlZGViYWE1ZWI0NzQwYjFhMjY4MjY0ZTUwZDc5MjVmZTIyNiIsInRhZyI6IiJ9; expires=Wed, 26-Apr-5358 19:12:24 GMT; path=/; secure; httponlyuid=eyJpdiI6IkRJZmZlR3Q0bjR5Wk1GQ3N3Y3JFNkE9PSIsInZhbHVlIjoieEV1THVBOFdvWmFhZzE1cE5qZkdWVWFxaGg1ZFlsa1RrQVJBdktKd2o5QnpaNm1mVEJQK0ZxRzZOdWJldDJFSWNzMVR1ZzZLeDhK" 1 => "XSRF-TOKEN=eyJpdiI6IjFrcER3aTFuYXlGZUJOSjVpdk1tV3c9PSIsInZhbHVlIjoiUURzY2dkWUNoRUwvUGlESXZkSWtkU09Fak1qcldBbDR1SEMxQXJnVUVMUjFkSy9jdGZNcFVadFFvZVgyYmRmUHZjTE9paDk0clovKzhZQjRVYmlSclZpajJMd1BaVUszSFZWL00ydm5EZk1XNURJM2xMTC9URlNla0owMFVraWEiLCJtYWMiOiIwNDc2ZWY3MmI1ZDRkMjAxODVjYTExMDI0ZjBhYTk2NGU3N2UwYzZmOTlhOTRkYjNlZjkxMTdlNmEzYzlkYzNiIiwidGFnIjoiIn0%3D; expires=Wed, 22-Jan-2025 20:48:24 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IjFrcER3aTFuYXlGZUJOSjVpdk1tV3c9PSIsInZhbHVlIjoiUURzY2dkWUNoRUwvUGlESXZkSWtkU09Fak1qcldBbDR1SEMxQXJnVUVMUjFkSy9jdGZNcFVadFFvZVgyYmRmUHZjTE9pa" 2 => "laravel_session=eyJpdiI6IkxzNTZPL3JJNnEzcmJsa2FldjVMVXc9PSIsInZhbHVlIjoiTVFreW9RejZaVllBV25qclJRNWdqdjBOVEYwazFRdEtZdXFndzMrSjFpQzdNQUU4ejJWeW8vK2RMYURVVkNXeWFxQmhWMnBVWXFkajY4UVZSSlBWUWFBMVJrWHRTdEVKSThMbHhpNWRzMWhOb05EZ2lUbWZGa0VmQlFaMFBBNjkiLCJtYWMiOiI5ODI0OTQ5NGM0MWViY2UxZjhlN2Q4ZWQ1MmQyYzY5YTMyZjEzMmIyM2IxZTE1N2VkNjBmOTZmOWEyZDg1Y2JjIiwidGFnIjoiIn0%3D; expires=Wed, 22-Jan-2025 20:48:24 GMT; path=/; httponlylaravel_session=eyJpdiI6IkxzNTZPL3JJNnEzcmJsa2FldjVMVXc9PSIsInZhbHVlIjoiTVFreW9RejZaVllBV25qclJRNWdqdjBOVEYwazFRdEtZdXFndzMrSjFpQzdNQUU4ejJWeW8vK2RMYURVVkNXeWFx" ] ]
          session_attributes
          0 of 0
          array:7 [ "_token" => "EYRRvWvOTKg2QXJylETHRYMUt73wBpGZqrtiuqjN" "views" => 3 "uid" => "49953a5ca9c1b8c91794646f7ba8db38" "last_results_page" => "/personal-car-leasing/mazda/cx-5/2.0-e-skyactiv-g-mhev-homura-5dr_82545/no-deposit?fCarID=82545&fDerivative=2.0+E+Skyactiv+G+Mhev+Homura+5dr&page=2page%3D6fDerivative%3D2.0+E+Skyactiv+G+Mhev+Homura+5dr/personal-car-leasing/mazda/cx-5/2.0-e-skyactiv-g-mhev-homura-5dr_82545/no-deposit?fCarID=82545&fDerivative=2.0+E+Skyactiv+G+Mhev+Homura+5dr&page=2page%3D6fDeri" "_previous" => array:1 [ "url" => "https://laravel.cars2buy.co.uk/personal-car-leasing/mazda/cx-5/2.0-e-skyactiv-g-mhev-homura-5dr_82545/no-deposit?fCarID=82545&fDerivative=2.0%20E%20Skyactiv%20G%20Mhev%20Homura%205dr&page=2page%3D6fDerivative%3D2.0%20E%20Skyactiv%20G%20Mhev%20Homura%205drhttps://laravel.cars2buy.co.uk/personal-car-leasing/mazda/cx-5/2.0-e-skyactiv-g-mhev-homura-5dr_82545/no-deposit?fCarID=82545&fDerivative=2.0%20E%20Skyactiv%20G" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
          ClearShow all
          Date ↕MethodURLData
          #12025-01-22 18:48:24GET/personal-car-leasing/mazda/cx-5/2.0-e-skyactiv-g-mhev-homura-5dr_82545/no-deposit?fCarID=82545&fDerivative=2.0+E+Skyactiv+G+Mhev+Homura+5dr&page=2page%3D6fDerivative%3D2.0+E+Skyactiv+G+Mhev+Homura+5dr1449100