Toyota RAV4 No Deposit Lease Deals:

Toyota RAV4

Page 7 of 36 pages

Why use cars2buy?

  • Compare over 3.1 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

Toyota RAV4 trims:

About the Toyota RAV4

The Toyota RAV 4 has become the kingpin of SUVs around the world, outselling any other for its excellent specs in an affordable package. The 2022 RAV4 comes with a powerful hybrid engine that can travel at an impressive fuel economy, and at cars2buy, the UK’s most trusted lease comparison site, RAV4 deals are ultra-competitive and strive to give you the very best for your money.

Why lease a Toyota RAV4?

As mentioned, even the base RAV4 model has a lot to like. However, if you’re looking for a special upgraded package to feel like a powerhouse on the road, the Toyota RAV4 Black Edition is a dark horse that sharpens the bodywork to a razor’s edge for extra style, dunks every part in menacing black and floods the interior with a wealth of high-tech equipment.

Compare Toyota RAV4 leases

Browse cars2buy for incredible offers on the RAV 4 and other Toyota car deals. You can have a lease anywhere from 12 months to 18 and even 24 months if you’re looking for something more long-term. The RAV4 hybrid edition is an excellent choice for a company car, and if you’re looking for something fuel-efficient and strong to carry you from A to B for a couple of years, you’ve come to the right place.

Toyota RAV4 no deposit lease deals

Better still, we offer no-deposit deals that spread the cost over the length of the contract, you so don’t have to worry about laying down a lump sum just to drive your new car. Search through our many deals from a ream of trusted leasers, and you could be on the road before you know it!

×

Filter your results:

Lease details:

Car details:

Request history8.2.27PHP Version442msRequest Duration2MBMemory UsageGET personal-car-leasing/{manufacturer}/{model}/{trim}/no-depositRoute
    • Booting (36.01ms)time
    • Application (406ms)time
    • 1 x Application (91.85%)
      406ms
      1 x Booting (8.15%)
      36.01ms
      13 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
      • 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 executed82.5ms
      • 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` = 'toyota' and `model_slug` = 'rav4' and `trim_slug` = 'excel') limit 1
        910μsbrampacModel.php#357
        Bindings
        • 0: toyota
        • 1: rav4
        • 2: excel
        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` = 'toyota' and `model_slug` = 'rav4' and `trim_slug` = 'excel') limit 1
        100μsbrampacController.php#369
        Bindings
        • 0: toyota
        • 1: rav4
        • 2: excel
        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` = 'toyota' and `model_slug` = 'rav4' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `trim_slug` = 'excel' and `deposit_type` <= 1
        7.39msbrampacCarLeasingSearch.php#58
        Bindings
        • 0: toyota
        • 1: rav4
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: excel
        • 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` = 'toyota' and `model_slug` = 'rav4' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `trim_slug` = 'excel' and `deposit_type` <= 1 order by price_monthly, effective_cost limit 10 offset 60
        8.77msbrampacCarLeasingSearch.php#58
        Bindings
        • 0: toyota
        • 1: rav4
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: excel
        • 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` = 'toyota' and `model_slug` = 'rav4' and `trim_slug` = 'excel' order by `car_specs`.`cap_id` desc limit 1
        330μsbrampacModel.php#154
        Bindings
        • 0: toyota
        • 1: rav4
        • 2: excel
        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` = 104523 and `ima_type` = 'CAR' and `path` != '' and `izmoAlias` != '' order by `ima_model_year` desc limit 1
        240μsbrampacImagesRepository.php#28
        Bindings
        • 0: 104523
        • 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` = 'Toyota' order by RAND() limit 1
        160μsbrampacCarLeasingSearch.php#117
        Bindings
        • 0: Toyota
        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` = 'Toyota' and `related_lease_models`.`model` = 'RAV4') group by `make_related`, `model_related` order by sort_order ASC limit 5
        500μsbrampacCarLeasingSearch.php#173
        Bindings
        • 0: Toyota
        • 1: RAV4
        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` = '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` = '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
        200μ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
        170μ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` = '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
        190μ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/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` = 'Tiguan' 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: 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
        90μ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` = 'Nissan' and `car_specs`.`model` = 'Ariya' 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: Ariya
        • 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` = 'toyota' and `model_slug` = 'rav4') group by `trim` order by `trim` asc
        340μsbrampacModel.php#128
        Bindings
        • 0: toyota
        • 1: rav4
        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` = 'toyota' and `model_slug` = 'rav4' and `trim` = 'Excel') order by `version` asc
        330μsbrampacModel.php#187
        Bindings
        • 0: toyota
        • 1: rav4
        • 2: Excel
        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` = 'Toyota' and `review_model` = 'RAV4') order by `review_date` asc limit 1
        180μsbrampacVehicleReview.php#61
        Bindings
        • 0: Toyota
        • 1: RAV4
        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` = 'toyota' and `model_slug` = 'rav4' and `amount` > 0 and `d_live` = 1 and `live` = 1 and `cap_id` > 1 and `otrprice` > 5000 and `pa_pid` = 5) and `trim_slug` = 'excel' order by `otrprice` asc limit 2
        630μsbrampacNewCarSearch.php#227
        Bindings
        • 0: toyota
        • 1: rav4
        • 2: 0
        • 3: 1
        • 4: 1
        • 5: 1
        • 6: 5000
        • 7: 5
        • 8: excel
        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` = 'toyota' and `model_slug` = 'rav4' 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
        620μsbrampacNewCarSearch.php#227
        Bindings
        • 0: toyota
        • 1: rav4
        • 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` = 'toyota' and `model_slug` = 'rav4' 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`
        650μsbrampacNewCarSearch.php#260
        Bindings
        • 0: toyota
        • 1: rav4
        • 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
        170μ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` = 'toyota' group by `car_specs`.`model` order by `car_specs`.`model` asc
        3.61msbrampacModel.php#85
        Bindings
        • 0: toyota
        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` = 'Toyota' and `car_specs`.`model` = 'Aygo X' 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: Toyota
        • 1: Aygo X
        • 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` = 'Toyota' and `ima_model` = 'Aygo X' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' limit 1
        170μsbrampacImagesRepository.php#97
        Bindings
        • 0: Toyota
        • 1: Aygo X
        • 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` = 'Toyota' and `car_specs`.`model` = 'BZ4X' 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: Toyota
        • 1: BZ4X
        • 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` = 'Toyota' and `car_specs`.`model` = 'C-HR' 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: Toyota
        • 1: C-HR
        • 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` = 'Toyota' and `car_specs`.`model` = 'Corolla' 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: Toyota
        • 1: Corolla
        • 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` = 'Toyota' and `car_specs`.`model` = 'Corolla Estate' 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: Toyota
        • 1: Corolla Estate
        • 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` = 'Toyota' and `ima_model` = 'Corolla Estate' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' limit 1
        100μsbrampacImagesRepository.php#97
        Bindings
        • 0: Toyota
        • 1: Corolla Estate
        • 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` = 'Toyota' and `car_specs`.`model` = 'GR Yaris' 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: Toyota
        • 1: GR Yaris
        • 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` = 'Toyota' and `ima_model` = 'GR Yaris' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' limit 1
        80μsbrampacImagesRepository.php#97
        Bindings
        • 0: Toyota
        • 1: GR Yaris
        • 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` = 'Toyota' and `car_specs`.`model` = 'Land Cruiser' 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: Toyota
        • 1: Land Cruiser
        • 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` = 'Toyota' and `car_specs`.`model` = 'Mirai' 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: Toyota
        • 1: Mirai
        • 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` = 'Toyota' and `ima_model` = 'Mirai' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' limit 1
        80μsbrampacImagesRepository.php#97
        Bindings
        • 0: Toyota
        • 1: Mirai
        • 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` = 'Toyota' and `car_specs`.`model` = 'Prius' 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: Toyota
        • 1: Prius
        • 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` = 'Toyota' and `ima_model` = 'Prius' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' limit 1
        180μsbrampacImagesRepository.php#97
        Bindings
        • 0: Toyota
        • 1: Prius
        • 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` = 'Toyota' and `car_specs`.`model` = 'Proace City Verso' 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: Toyota
        • 1: Proace City Verso
        • 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` = 'Toyota' and `car_specs`.`model` = 'Proace Verso' 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: Toyota
        • 1: Proace Verso
        • 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` = 'Toyota' and `car_specs`.`model` = 'RAV4' 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: Toyota
        • 1: RAV4
        • 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` = 'Toyota' and `car_specs`.`model` = 'Yaris' 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: Toyota
        • 1: Yaris
        • 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` = 'Toyota' and `ima_model` = 'Yaris' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' limit 1
        170μsbrampacImagesRepository.php#97
        Bindings
        • 0: Toyota
        • 1: Yaris
        • 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` = 'Toyota' and `car_specs`.`model` = 'Yaris Cross' 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: Toyota
        • 1: Yaris Cross
        • 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` = 'toyota' and `model_slug` = 'rav4' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `trim_slug` = 'excel' and `deposit_type` <= 1
        7.23msbrampacLeaseCarFilter.php#254
        Bindings
        • 0: toyota
        • 1: rav4
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: excel
        • 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` = 'toyota' and `model_slug` = 'rav4' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `trim_slug` = 'excel' and `deposit_type` <= 1
        7.02msbrampacLeaseCarFilter.php#278
        Bindings
        • 0: toyota
        • 1: rav4
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: excel
        • 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 `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` = 'toyota' and `model_slug` = 'rav4' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `trim_slug` = 'excel' and `deposit_type` <= 1 order by `version` asc
        4.05msbrampacLeaseCarFilter.php#103
        Bindings
        • 0: toyota
        • 1: rav4
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: excel
        • 6: 1
        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` = 'toyota' and `model_slug` = 'rav4' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `trim_slug` = 'excel' and `deposit_type` <= 1 order by `fuel` asc
        4.15msbrampacLeaseCarFilter.php#133
        Bindings
        • 0: toyota
        • 1: rav4
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: excel
        • 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` = 'toyota' and `model_slug` = 'rav4' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `trim_slug` = 'excel' and `deposit_type` <= 1 order by `transmission` asc
        4.25msbrampacLeaseCarFilter.php#149
        Bindings
        • 0: toyota
        • 1: rav4
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: excel
        • 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` = 'toyota' and `model_slug` = 'rav4' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `trim_slug` = 'excel' and `deposit_type` <= 1 order by `engine` asc
        4.01msbrampacLeaseCarFilter.php#164
        Bindings
        • 0: toyota
        • 1: rav4
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: excel
        • 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` = 'toyota' and `model_slug` = 'rav4' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `trim_slug` = 'excel' and `deposit_type` <= 1 order by `bodytype` asc
        3.98msbrampacLeaseCarFilter.php#178
        Bindings
        • 0: toyota
        • 1: rav4
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: excel
        • 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` = 'toyota' and `model_slug` = 'rav4' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `trim_slug` = 'excel' and `deposit_type` <= 1 order by `doors` asc
        3.95msbrampacLeaseCarFilter.php#193
        Bindings
        • 0: toyota
        • 1: rav4
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: excel
        • 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` = 'toyota' and `model_slug` = 'rav4' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `trim_slug` = 'excel' and `deposit_type` <= 1 and `term` in (6, 12, 18, 24, 36, 48, 60) order by `term` asc
        6.92msbrampacLeaseCarFilter.php#208
        Bindings
        • 0: toyota
        • 1: rav4
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: excel
        • 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` = 'toyota' and `model_slug` = 'rav4' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `trim_slug` = 'excel' 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
        6.94msbrampacLeaseCarFilter.php#238
        Bindings
        • 0: toyota
        • 1: rav4
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: excel
        • 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
        160μ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` = 'Toyota' and `Model` = 'RAV4' and `Type` = 'Car - Personal Lease')
        420μsbrampacSearchOptimisation.php#19
        Bindings
        • 0: Toyota
        • 1: RAV4
        • 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` = 'Toyota' and `model` = 'RAV4' limit 1
        250μsbrampacCarLeasingSearch.php#629
        Bindings
        • 0: Toyota
        • 1: RAV4
        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
      85CarSpec.php#?
      App\Models\LeaseOfferPersonal
      10LeaseOfferPersonal.php#?
      App\Models\RelatedLeaseModel
      5RelatedLeaseModel.php#?
      App\Models\ImagesIzmo
      1ImagesIzmo.php#?
      App\Models\Seo
      1Seo.php#?
      App\Models\MinPricePersonalLease
      1MinPricePersonalLease.php#?
          _token
          AOwuHp15NJFk4vQ2C2BbbCXwPlfjABYT4pnMbo3i
          views
          1
          uid
          522a9c430237bad2bb5b883bc6eb4f80
          last_results_page
          /personal-car-leasing/toyota/rav4/excel/no-deposit?fTrim=excel&page=7&trimText=Excel
          _previous
          array:1 [ "url" => "https://laravel.cars2buy.co.uk/personal-car-leasing/toyota/rav4/excel/no-depos...
          _flash
          array:2 [ "old" => [] "new" => [] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /personal-car-leasing/toyota/rav4/excel/no-deposit
          status_code
          200
          
          status_text
          OK
          format
          html
          content_type
          text/html; charset=UTF-8
          request_query
          0 of 0
          array:4 [ "fTrim" => "excel" "page" => "7" "trimText" => "Excel" "fDeposit" => 1 ]
          request_request
          []
          
          request_headers
          0 of 0
          array:18 [ "priority" => array:1 [ 0 => "u=0, i" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua" => array:1 [ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "close" ] "x-accel-internal" => array:1 [ 0 => "/internal-nginx-static-location" ] "x-real-ip" => array:1 [ 0 => "3.129.69.189" ] "host" => array:1 [ 0 => "laravel.cars2buy.co.uk" ] ]
          request_cookies
          []
          
          response_headers
          0 of 0
          array:7 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "private, must-revalidate" ] "date" => array:1 [ 0 => "Wed, 15 Jan 2025 23:07:17 GMT" ] "pragma" => array:1 [ 0 => "no-cache" ] "expires" => array:1 [ 0 => "-1" ] "set-cookie" => array:3 [ 0 => "uid=eyJpdiI6Ilo1dDJaYWV0TWJTYWNPVUhrSHMyN0E9PSIsInZhbHVlIjoiYjFadjVtOGdpcVJ5UlI0U2Y3UnNjKzJVUWZrZWVhWEdjZEFsUnQ0Z3ByRkRGTmtSSVNZV1RBaEEvR1MwTE0zY1BKTHVMOE5LWVlwWVhybTN6STZwOE53bTdzWC9qZlRuLy9MR3MvRFNGR1E9IiwibWFjIjoiZjcyNWFlMDY3YjA0MTZjMjYyYzdlZjVmMmFjY2Q2MzMwYWM1MzhjMGVjOTY3MTRiNDdhYmZkZDUzMDQyMjZiYiIsInRhZyI6IiJ9; expires=Sun, 06 Mar 5357 18:24:17 GMT; Max-Age=105152066219; path=/; secure; httponly; samesite=laxuid=eyJpdiI6Ilo1dDJaYWV0TWJTYWNPVUhrSHMyN0E9PSIsInZhbHVlIjoiYjFadjVtOGdpcVJ5UlI0U2Y3UnNjKzJVUWZrZWVhWEdjZEFsUnQ0Z3ByRkRGTmtSSVNZV1RBaEEvR1MwTE0zY1BKTHVMOE5LWVlw" 1 => "XSRF-TOKEN=eyJpdiI6IlNkRWtzMW1pekJUNDN6cTVvN090c3c9PSIsInZhbHVlIjoibTh1YVhSZXZMNHNsOFkxdVZyU1dVd0I2bTU1WWV2bXVWbVd2eXUvelJ1UUJqcDRMYm9NeGVDNGxGRnVWSWFuWnJGUitlVTF1NXlDNDBDa0RqdHB5a3pweTI1bk5IQk5zQ1VJb2lMZGpoaVBibFVtTExURzJyR0dvTEJ0V1FUQVMiLCJtYWMiOiI3ZjIzNTI4NzliNTc5YzhjMjlhYzA5OGExNzFlMjZmOGZjYjY0ZGU0NDZiMGYwNDg4Yzk4Y2MxYjNkOTgzZjI1IiwidGFnIjoiIn0%3D; expires=Thu, 16 Jan 2025 01:07:17 GMT; Max-Age=7199; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IlNkRWtzMW1pekJUNDN6cTVvN090c3c9PSIsInZhbHVlIjoibTh1YVhSZXZMNHNsOFkxdVZyU1dVd0I2bTU1WWV2bXVWbVd2eXUvelJ1UUJqcDRMYm9NeGVDNGxGRnVWSWFuWnJGUitlV" 2 => "laravel_session=eyJpdiI6IktEb0plcVpSekNycDg5TkVKck13b0E9PSIsInZhbHVlIjoiUG5kUjArQU42K2tEVEgvdFpkOGFYWHdXUyt2c3Rab2ozOXhmS1JDRFhwOHFORCtkTnk5YkswRWFPZXc2bUVTUjFmL085UEwrNTl4VHRkaDVZZlR2VXlHdGNPK21tQWNhK2t5dUtBTWN2aWtFTUdad1U5M2ZLZTlNV2psL2NlOWsiLCJtYWMiOiIzYWQ3ZTAyZmI5YTcwYmE5ZDVjZTI2NTZkNjVmMzM3MmIzMGE4NzI3NjA0NTMwY2NkYmQ0ODllZjkxMzI3NjU5IiwidGFnIjoiIn0%3D; expires=Thu, 16 Jan 2025 01:07:17 GMT; Max-Age=7199; path=/; httponly; samesite=laxlaravel_session=eyJpdiI6IktEb0plcVpSekNycDg5TkVKck13b0E9PSIsInZhbHVlIjoiUG5kUjArQU42K2tEVEgvdFpkOGFYWHdXUyt2c3Rab2ozOXhmS1JDRFhwOHFORCtkTnk5YkswRWFPZXc2bUVTUjFm" ] "Set-Cookie" => array:3 [ 0 => "uid=eyJpdiI6Ilo1dDJaYWV0TWJTYWNPVUhrSHMyN0E9PSIsInZhbHVlIjoiYjFadjVtOGdpcVJ5UlI0U2Y3UnNjKzJVUWZrZWVhWEdjZEFsUnQ0Z3ByRkRGTmtSSVNZV1RBaEEvR1MwTE0zY1BKTHVMOE5LWVlwWVhybTN6STZwOE53bTdzWC9qZlRuLy9MR3MvRFNGR1E9IiwibWFjIjoiZjcyNWFlMDY3YjA0MTZjMjYyYzdlZjVmMmFjY2Q2MzMwYWM1MzhjMGVjOTY3MTRiNDdhYmZkZDUzMDQyMjZiYiIsInRhZyI6IiJ9; expires=Sun, 06-Mar-5357 18:24:17 GMT; path=/; secure; httponlyuid=eyJpdiI6Ilo1dDJaYWV0TWJTYWNPVUhrSHMyN0E9PSIsInZhbHVlIjoiYjFadjVtOGdpcVJ5UlI0U2Y3UnNjKzJVUWZrZWVhWEdjZEFsUnQ0Z3ByRkRGTmtSSVNZV1RBaEEvR1MwTE0zY1BKTHVMOE5LWVlw" 1 => "XSRF-TOKEN=eyJpdiI6IlNkRWtzMW1pekJUNDN6cTVvN090c3c9PSIsInZhbHVlIjoibTh1YVhSZXZMNHNsOFkxdVZyU1dVd0I2bTU1WWV2bXVWbVd2eXUvelJ1UUJqcDRMYm9NeGVDNGxGRnVWSWFuWnJGUitlVTF1NXlDNDBDa0RqdHB5a3pweTI1bk5IQk5zQ1VJb2lMZGpoaVBibFVtTExURzJyR0dvTEJ0V1FUQVMiLCJtYWMiOiI3ZjIzNTI4NzliNTc5YzhjMjlhYzA5OGExNzFlMjZmOGZjYjY0ZGU0NDZiMGYwNDg4Yzk4Y2MxYjNkOTgzZjI1IiwidGFnIjoiIn0%3D; expires=Thu, 16-Jan-2025 01:07:17 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IlNkRWtzMW1pekJUNDN6cTVvN090c3c9PSIsInZhbHVlIjoibTh1YVhSZXZMNHNsOFkxdVZyU1dVd0I2bTU1WWV2bXVWbVd2eXUvelJ1UUJqcDRMYm9NeGVDNGxGRnVWSWFuWnJGUitlV" 2 => "laravel_session=eyJpdiI6IktEb0plcVpSekNycDg5TkVKck13b0E9PSIsInZhbHVlIjoiUG5kUjArQU42K2tEVEgvdFpkOGFYWHdXUyt2c3Rab2ozOXhmS1JDRFhwOHFORCtkTnk5YkswRWFPZXc2bUVTUjFmL085UEwrNTl4VHRkaDVZZlR2VXlHdGNPK21tQWNhK2t5dUtBTWN2aWtFTUdad1U5M2ZLZTlNV2psL2NlOWsiLCJtYWMiOiIzYWQ3ZTAyZmI5YTcwYmE5ZDVjZTI2NTZkNjVmMzM3MmIzMGE4NzI3NjA0NTMwY2NkYmQ0ODllZjkxMzI3NjU5IiwidGFnIjoiIn0%3D; expires=Thu, 16-Jan-2025 01:07:17 GMT; path=/; httponlylaravel_session=eyJpdiI6IktEb0plcVpSekNycDg5TkVKck13b0E9PSIsInZhbHVlIjoiUG5kUjArQU42K2tEVEgvdFpkOGFYWHdXUyt2c3Rab2ozOXhmS1JDRFhwOHFORCtkTnk5YkswRWFPZXc2bUVTUjFm" ] ]
          session_attributes
          0 of 0
          array:7 [ "_token" => "AOwuHp15NJFk4vQ2C2BbbCXwPlfjABYT4pnMbo3i" "views" => 1 "uid" => "522a9c430237bad2bb5b883bc6eb4f80" "last_results_page" => "/personal-car-leasing/toyota/rav4/excel/no-deposit?fTrim=excel&page=7&trimText=Excel" "_previous" => array:1 [ "url" => "https://laravel.cars2buy.co.uk/personal-car-leasing/toyota/rav4/excel/no-deposit?fTrim=excel&page=7&trimText=Excel" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
          ClearShow all
          Date ↕MethodURLData
          #12025-01-15 23:07:17GET/personal-car-leasing/toyota/rav4/excel/no-deposit?fTrim=excel&page=7&trimText=Excel1356103