Toyota RAV4 2.5 VVT-i Hybrid GR Sport 5dr CVT Lease Deals:

Toyota RAV4

Page 14 of 21 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 Version610msRequest Duration2MBMemory UsageGET personal-car-leasing/{manufacturer}/{model}/{derivative}Route
    • Booting (38.49ms)time
    • Application (572ms)time
    • 1 x Application (93.69%)
      572ms
      1 x Booting (6.31%)
      38.49ms
      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}/{derivative}
      middleware
      web
      controller
      App\Http\Controllers\CarLeasingController@results
      namespace
      where
      as
      personal-leasing-results-derivative
      file
      app/Http/Controllers/CarLeasingController.php:228-390
      58 statements were executed49.3ms
      • 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` = 'toyota' and `model_slug` = 'rav4' and `car_id` = '86170' and `version_slug` = '2.5-vvt-i-hybrid-gr-sport-5dr-cvt') limit 1
        1.1msbrampacController.php#327
        Bindings
        • 0: toyota
        • 1: rav4
        • 2: 86170
        • 3: 2.5-vvt-i-hybrid-gr-sport-5dr-cvt
        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` = 'toyota' and `model_slug` = 'rav4' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `car_id` = '86170'
        2.71msbrampacCarLeasingSearch.php#58
        Bindings
        • 0: toyota
        • 1: rav4
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 86170
        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 `car_id` = '86170' order by price_monthly, effective_cost limit 10 offset 130
        4.91msbrampacCarLeasingSearch.php#58
        Bindings
        • 0: toyota
        • 1: rav4
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 86170
        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 `car_id` = '86170' order by `car_specs`.`cap_id` desc limit 1
        380μsbrampacModel.php#154
        Bindings
        • 0: toyota
        • 1: rav4
        • 2: 86170
        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` = 103806 and `ima_type` = 'CAR' and `path` != '' and `izmoAlias` != '' order by `ima_model_year` desc limit 1
        420μsbrampacImagesRepository.php#28
        Bindings
        • 0: 103806
        • 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
        270μ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
        190μ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
        160μ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
        160μ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
        160μ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
        180μ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
        160μ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
        140μ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
        160μ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
        130μ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 `trim` from `car_specs` where `car_id` = '86170' limit 1
        250μsbrampacModel.php#173
        Bindings
        • 0: 86170
        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` = 'toyota' and `model_slug` = 'rav4' and `trim` = 'GR Sport') order by `version` asc
        710μsbrampacModel.php#187
        Bindings
        • 0: toyota
        • 1: rav4
        • 2: GR Sport
        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
        150μ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 `car_id` = '86170' order by `otrprice` asc limit 2
        840μsbrampacNewCarSearch.php#227
        Bindings
        • 0: toyota
        • 1: rav4
        • 2: 0
        • 3: 1
        • 4: 1
        • 5: 1
        • 6: 5000
        • 7: 5
        • 8: 86170
        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
        290μ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`
        300μ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
        190μ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
        230μsbrampacModel.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
        160μ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
        200μ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
        190μ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
        190μ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
        200μ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
        170μ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
        190μ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
        160μ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
        220μ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
        210μ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
        160μ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
        190μ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
        320μ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
        210μ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
        200μ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
        210μ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
        240μ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
        200μ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 `car_id` = '86170'
        2.95msbrampacLeaseCarFilter.php#254
        Bindings
        • 0: toyota
        • 1: rav4
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 86170
        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 `car_id` = '86170'
        2.79msbrampacLeaseCarFilter.php#278
        Bindings
        • 0: toyota
        • 1: rav4
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 86170
        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` = 'toyota' and `model_slug` = 'rav4' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `car_id` = '86170' order by `trim_slug` asc
        2.62msbrampacLeaseCarFilter.php#87
        Bindings
        • 0: toyota
        • 1: rav4
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 86170
        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` = '86170'
        240μsbrampacLeaseCarFilter.php#118
        Bindings
        • 0: 86170
        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` = 'toyota' and `model_slug` = 'rav4' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `car_id` = '86170' order by `fuel` asc
        2.54msbrampacLeaseCarFilter.php#133
        Bindings
        • 0: toyota
        • 1: rav4
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 86170
        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 `car_id` = '86170' order by `transmission` asc
        2.53msbrampacLeaseCarFilter.php#149
        Bindings
        • 0: toyota
        • 1: rav4
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 86170
        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 `car_id` = '86170' order by `engine` asc
        2.56msbrampacLeaseCarFilter.php#164
        Bindings
        • 0: toyota
        • 1: rav4
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 86170
        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 `car_id` = '86170' order by `bodytype` asc
        2.53msbrampacLeaseCarFilter.php#178
        Bindings
        • 0: toyota
        • 1: rav4
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 86170
        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 `car_id` = '86170' order by `doors` asc
        2.49msbrampacLeaseCarFilter.php#193
        Bindings
        • 0: toyota
        • 1: rav4
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 86170
        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 `car_id` = '86170' and `term` in (6, 12, 18, 24, 36, 48, 60) order by `term` asc
        3.1msbrampacLeaseCarFilter.php#208
        Bindings
        • 0: toyota
        • 1: rav4
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 86170
        • 6: 6
        • 7: 12
        • 8: 18
        • 9: 24
        • 10: 36
        • 11: 48
        • 12: 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 `deposit_type` 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 `car_id` = '86170' and `term` in (6, 12, 18, 24, 36, 48, 60) and `deposit_type` in (1, 3, 6, 9, 12) order by `deposit_type` asc
        2.99msbrampacLeaseCarFilter.php#223
        Bindings
        • 0: toyota
        • 1: rav4
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 86170
        • 6: 6
        • 7: 12
        • 8: 18
        • 9: 24
        • 10: 36
        • 11: 48
        • 12: 60
        • 13: 1
        • 14: 3
        • 15: 6
        • 16: 9
        • 17: 12
        Backtrace
        • 15. app/Queries/SearchFilters/LeaseCarFilter.php:223
        • 16. app/Queries/SearchFilters/LeaseCarFilter.php:62
        • 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 `car_id` = '86170' and `term` in (6, 12, 18, 24, 36, 48, 60) and `deposit_type` in (1, 3, 6, 9, 12) and `mileage` in (5000, 6000, 8000, 10000, 12000, 15000, 20000, 25000, 30000, 35000, 40000) order by `mileage` asc
        3.31msbrampacLeaseCarFilter.php#238
        Bindings
        • 0: toyota
        • 1: rav4
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 86170
        • 6: 6
        • 7: 12
        • 8: 18
        • 9: 24
        • 10: 36
        • 11: 48
        • 12: 60
        • 13: 1
        • 14: 3
        • 15: 6
        • 16: 9
        • 17: 12
        • 18: 5000
        • 19: 6000
        • 20: 8000
        • 21: 10000
        • 22: 12000
        • 23: 15000
        • 24: 20000
        • 25: 25000
        • 26: 30000
        • 27: 35000
        • 28: 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
        140μ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')
        170μ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
        150μ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
      83CarSpec.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
          UsVpmVf6Bn8ZPN45VaZcEIZn739GxNnLyeLSuYoD
          views
          3
          uid
          c0beaa292ea25bcf9e9a0d2bdea56c87
          last_results_page
          /personal-car-leasing/toyota/rav4/2.5-vvt-i-hybrid-gr-sport-5dr-cvt_86170?fDerivative=2.5+Vvt+I+Hybr...
          _previous
          array:1 [ "url" => "https://laravel.cars2buy.co.uk/personal-car-leasing/toyota/rav4/2.5-vvt-i-hybr...
          _flash
          array:2 [ "old" => [] "new" => [] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /personal-car-leasing/toyota/rav4/2.5-vvt-i-hybrid-gr-sport-5dr-cvt_86170
          status_code
          200
          
          status_text
          OK
          format
          html
          content_type
          text/html; charset=UTF-8
          request_query
          0 of 0
          array:3 [ "fDerivative" => "2.5 Vvt I Hybrid Gr Sport 5dr Cvt" "page" => "14" "fCarID" => "86170" ]
          request_request
          []
          
          request_headers
          0 of 0
          array:19 [ "cookie" => array:1 [ 0 => "uid=eyJpdiI6ImFYUGJrb1pSMVVuaXlqbmtHcFNzbVE9PSIsInZhbHVlIjoiQ3lSUWlCWjdUTW1FY08vSzYyRUhNdlRmazRKYW9yYlU4dnErVmxRc01QOTlQQVNKS2dKRTRjTzgrL0p2K1ROekNHZjR5UDdDK0VTZU1kVnNuUmJEZjdCT0EwOFVLcTJSUWtrbmZzejAxdzg9IiwibWFjIjoiMmUxNTQwNjU1YzkxZTg4MjBiYmJlOTA0ZTEyYmU3MmFiMTdhZjJlMWRlNWE1OWVhZTYzMjM2NWE5NjA2YmVmYiIsInRhZyI6IiJ9; XSRF-TOKEN=eyJpdiI6Im9FdDdEN29uNytvTEFaVUtPaUw0Q0E9PSIsInZhbHVlIjoibGlpdUlnZmFSdms2QmtTeWF5SmpMdWlKZDJkTnhPT2JpUGw4ZEpxMk1vdklRRTZzSDI4dzRRbUlIcU5NLzZuMndBZEN5eWt2SU5zOFRtZGlROGkyYmg1Z3JNTThzMUNGcUhNNWFnR25PTzR1OHczdDhHRUlTVU9EaG53WWd2VXAiLCJtYWMiOiI1MWMyNmRlYjQxODViNWZmYzk2OWU5MjNiNDlkMmUyY2Q1N2Q2YWYwZTJjNmE1MjZlNTQ0NWNmMjk3MjVmMWJiIiwidGFnIjoiIn0%3D; laravel_session=eyJpdiI6ImYyY2J3bExUWi9zYlFJUmJ3cDU0bVE9PSIsInZhbHVlIjoiMkVxOEVVbjk5TGlDNWd6RXNRTUVXSFpESVRhSzJlVUwwaEppK29UMGM5VkhoZkZqa0FIZ0piQ2gxcWdOL3dCUHRBSE93RTFYSFBNVGw4M2Q2SkM0VU4wYm82bEJKUnlGaktvelZXRzZqWU5OY1lTWDdjUE9jRGN4b3lMbGJBVTMiLCJtYWMiOiIzNGUyMTVjNWM2YzljODk1MzYxM2JjOGYxZTUzZTdjNTljOGE3NThhMDIwMDc0MTMwZjU2ZTc4MzdlOTNhMDY1IiwidGFnIjoiIn0%3D; _ga_N9GLTHNRLQ=GS1.1.1736980856.1.0.1736980856.60.0.0; _ga=GA1.1.600993974.1736980857; _gcl_au=1.1.241546084.1736980857uid=eyJpdiI6ImFYUGJrb1pSMVVuaXlqbmtHcFNzbVE9PSIsInZhbHVlIjoiQ3lSUWlCWjdUTW1FY08vSzYyRUhNdlRmazRKYW9yYlU4dnErVmxRc01QOTlQQVNKS2dKRTRjTzgrL0p2K1ROekNHZjR5UDdDK0VT" ] "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.188.161.144" ] "host" => array:1 [ 0 => "laravel.cars2buy.co.uk" ] ]
          request_cookies
          0 of 0
          array:6 [ "uid" => "c0beaa292ea25bcf9e9a0d2bdea56c87" "XSRF-TOKEN" => "UsVpmVf6Bn8ZPN45VaZcEIZn739GxNnLyeLSuYoD" "laravel_session" => "MMwqIWMZj8b5NCdHOJlvCAI6Fj8mfK6PfJQ9HaAo" "_ga_N9GLTHNRLQ" => null "_ga" => null "_gcl_au" => null ]
          response_headers
          0 of 0
          array:7 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "private, must-revalidate" ] "date" => array:1 [ 0 => "Wed, 15 Jan 2025 22:40:57 GMT" ] "pragma" => array:1 [ 0 => "no-cache" ] "expires" => array:1 [ 0 => "-1" ] "set-cookie" => array:3 [ 0 => "uid=eyJpdiI6ImxBaG5vQnl6Slptc2pnc0dIa2ZDZUE9PSIsInZhbHVlIjoiMEM1S2lMZnBGcDE5THhmSFFwaG9RSWt1WXltV3BtZVE2MWVHdk14WFNYMng0UXU0Z2dvdFg3U25WNy9CcHV1TTRLOGVVTW9jb3NWZlV1d05MSE1zSjluU3Uvb0hsbEFkbkpsQTlBNWIyUFE9IiwibWFjIjoiYmY2NDdhZTA5YjQzY2U4OGI3NmFjZTMyNmQ3YTZlZDVmY2NhMzBjZjYxNmVjYjU4ZjUyNDhkZjcwOWY1MTcyMiIsInRhZyI6IiJ9; expires=Sat, 05 Mar 5357 15:37:57 GMT; Max-Age=105151971420; path=/; secure; httponly; samesite=laxuid=eyJpdiI6ImxBaG5vQnl6Slptc2pnc0dIa2ZDZUE9PSIsInZhbHVlIjoiMEM1S2lMZnBGcDE5THhmSFFwaG9RSWt1WXltV3BtZVE2MWVHdk14WFNYMng0UXU0Z2dvdFg3U25WNy9CcHV1TTRLOGVVTW9jb3NW" 1 => "XSRF-TOKEN=eyJpdiI6IkZHQTF5SmxZZ0JDMkJaNU94ektIaWc9PSIsInZhbHVlIjoieHd3Y2phRXorbHlSY3NiKzc2UnF3OW5kdy9WUlRZZmhGK1RvWmFDRjMwVk9TQm5TRSs1NFdBQ0hlUThmOUJNLy9KYXRtMjhJaDhtVk5oeHFWN2FXKzM1SmV2QWpZSjNuN1lUck01Tm1BSFNFYmlMNHJINkI2OE5wNWtIU2JsaWIiLCJtYWMiOiJiMzdiNGNmNTFhMjA3MWRkNmY3ZDA5ZThjZmFhYTBjMjBkYzc4MzY2ZTc2OWYyMjllNDliYzIxODdiOWIwN2ZlIiwidGFnIjoiIn0%3D; expires=Thu, 16 Jan 2025 00:40:57 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IkZHQTF5SmxZZ0JDMkJaNU94ektIaWc9PSIsInZhbHVlIjoieHd3Y2phRXorbHlSY3NiKzc2UnF3OW5kdy9WUlRZZmhGK1RvWmFDRjMwVk9TQm5TRSs1NFdBQ0hlUThmOUJNLy9KYXRtM" 2 => "laravel_session=eyJpdiI6IlNZclJwMDIzUXpMT091empxNmswNFE9PSIsInZhbHVlIjoiZEExS3U3eURZMGZ1OXMyY1QrSGxFT2dHaTZmb3A4YjA3QklPU0NKYlFPeHNudllyYmRIMEMydjFSRmZHdzN2Vzg1L2JlY0plc0cyTEhCQ29DTzBpWWt0MWIvaXc0U0g2NEltZ3ZQLzBJd0tUWWhWdXB4bVJKS2w1ZUtvbHhEKzYiLCJtYWMiOiI4MTg0MzkxZWVkYjNkNjg2MWUxYmI0OWU5ZTJiZjUzZTEyMzdlMTI0MjQwMDk2ZmEyOTlkYTQ4NmQ0YzViNWU1IiwidGFnIjoiIn0%3D; expires=Thu, 16 Jan 2025 00:40:57 GMT; Max-Age=7200; path=/; httponly; samesite=laxlaravel_session=eyJpdiI6IlNZclJwMDIzUXpMT091empxNmswNFE9PSIsInZhbHVlIjoiZEExS3U3eURZMGZ1OXMyY1QrSGxFT2dHaTZmb3A4YjA3QklPU0NKYlFPeHNudllyYmRIMEMydjFSRmZHdzN2Vzg1" ] "Set-Cookie" => array:3 [ 0 => "uid=eyJpdiI6ImxBaG5vQnl6Slptc2pnc0dIa2ZDZUE9PSIsInZhbHVlIjoiMEM1S2lMZnBGcDE5THhmSFFwaG9RSWt1WXltV3BtZVE2MWVHdk14WFNYMng0UXU0Z2dvdFg3U25WNy9CcHV1TTRLOGVVTW9jb3NWZlV1d05MSE1zSjluU3Uvb0hsbEFkbkpsQTlBNWIyUFE9IiwibWFjIjoiYmY2NDdhZTA5YjQzY2U4OGI3NmFjZTMyNmQ3YTZlZDVmY2NhMzBjZjYxNmVjYjU4ZjUyNDhkZjcwOWY1MTcyMiIsInRhZyI6IiJ9; expires=Sat, 05-Mar-5357 15:37:57 GMT; path=/; secure; httponlyuid=eyJpdiI6ImxBaG5vQnl6Slptc2pnc0dIa2ZDZUE9PSIsInZhbHVlIjoiMEM1S2lMZnBGcDE5THhmSFFwaG9RSWt1WXltV3BtZVE2MWVHdk14WFNYMng0UXU0Z2dvdFg3U25WNy9CcHV1TTRLOGVVTW9jb3NW" 1 => "XSRF-TOKEN=eyJpdiI6IkZHQTF5SmxZZ0JDMkJaNU94ektIaWc9PSIsInZhbHVlIjoieHd3Y2phRXorbHlSY3NiKzc2UnF3OW5kdy9WUlRZZmhGK1RvWmFDRjMwVk9TQm5TRSs1NFdBQ0hlUThmOUJNLy9KYXRtMjhJaDhtVk5oeHFWN2FXKzM1SmV2QWpZSjNuN1lUck01Tm1BSFNFYmlMNHJINkI2OE5wNWtIU2JsaWIiLCJtYWMiOiJiMzdiNGNmNTFhMjA3MWRkNmY3ZDA5ZThjZmFhYTBjMjBkYzc4MzY2ZTc2OWYyMjllNDliYzIxODdiOWIwN2ZlIiwidGFnIjoiIn0%3D; expires=Thu, 16-Jan-2025 00:40:57 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IkZHQTF5SmxZZ0JDMkJaNU94ektIaWc9PSIsInZhbHVlIjoieHd3Y2phRXorbHlSY3NiKzc2UnF3OW5kdy9WUlRZZmhGK1RvWmFDRjMwVk9TQm5TRSs1NFdBQ0hlUThmOUJNLy9KYXRtM" 2 => "laravel_session=eyJpdiI6IlNZclJwMDIzUXpMT091empxNmswNFE9PSIsInZhbHVlIjoiZEExS3U3eURZMGZ1OXMyY1QrSGxFT2dHaTZmb3A4YjA3QklPU0NKYlFPeHNudllyYmRIMEMydjFSRmZHdzN2Vzg1L2JlY0plc0cyTEhCQ29DTzBpWWt0MWIvaXc0U0g2NEltZ3ZQLzBJd0tUWWhWdXB4bVJKS2w1ZUtvbHhEKzYiLCJtYWMiOiI4MTg0MzkxZWVkYjNkNjg2MWUxYmI0OWU5ZTJiZjUzZTEyMzdlMTI0MjQwMDk2ZmEyOTlkYTQ4NmQ0YzViNWU1IiwidGFnIjoiIn0%3D; expires=Thu, 16-Jan-2025 00:40:57 GMT; path=/; httponlylaravel_session=eyJpdiI6IlNZclJwMDIzUXpMT091empxNmswNFE9PSIsInZhbHVlIjoiZEExS3U3eURZMGZ1OXMyY1QrSGxFT2dHaTZmb3A4YjA3QklPU0NKYlFPeHNudllyYmRIMEMydjFSRmZHdzN2Vzg1" ] ]
          session_attributes
          0 of 0
          array:7 [ "_token" => "UsVpmVf6Bn8ZPN45VaZcEIZn739GxNnLyeLSuYoD" "views" => 3 "uid" => "c0beaa292ea25bcf9e9a0d2bdea56c87" "last_results_page" => "/personal-car-leasing/toyota/rav4/2.5-vvt-i-hybrid-gr-sport-5dr-cvt_86170?fDerivative=2.5+Vvt+I+Hybrid+Gr+Sport+5dr+Cvt&page=14" "_previous" => array:1 [ "url" => "https://laravel.cars2buy.co.uk/personal-car-leasing/toyota/rav4/2.5-vvt-i-hybrid-gr-sport-5dr-cvt_86170?fDerivative=2.5%20Vvt%20I%20Hybrid%20Gr%20Sport%205dr%20Cvt&page=14https://laravel.cars2buy.co.uk/personal-car-leasing/toyota/rav4/2.5-vvt-i-hybrid-gr-sport-5dr-cvt_86170?fDerivative=2.5%20Vvt%20I%20Hybrid%20Gr%20Sport%205dr%20" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
          ClearShow all
          Date ↕MethodURLData
          #12025-01-15 22:40:57GET/personal-car-leasing/toyota/rav4/2.5-vvt-i-hybrid-gr-sport-5dr-cvt_86170?fDerivative=2.5+Vvt+I+Hybrid+Gr+Sport+5dr+Cvt&page=141358101