SEAT Ateca 1.5 TSI EVO Xperience 5dr DSG Lease Deals:

SEAT Ateca
  • IN STOCK
    Leasing Options

    SEAT Ateca

    1.5 TSI EVO Xperience 5dr DSG

    Term: 36 months

    Annual Mileage: 5,000

    Initial Payment: £2,687.64

    Processing Fees: £299.99

    Total Cost of Lease: £10,827

    Average Monthly Cost: £300.74

    (All prices inc. VAT)

    35Monthly Payments:

    £223.97

    Deal Details
  • IN STOCK
    Leasing Options

    SEAT Ateca

    1.5 TSI EVO Xperience 5dr DSG

    Term: 36 months

    Annual Mileage: 8,000

    Initial Payment: £2,853.72

    Processing Fees: £299.99

    Total Cost of Lease: £11,477

    Average Monthly Cost: £318.81

    (All prices inc. VAT)

    35Monthly Payments:

    £237.81

    Deal Details
  • mail-icon Subscribe to our hottest deals

    Subscribe to get the hottest lease deals straight to your inbox each week
  • IN STOCK
    Leasing Options

    SEAT Ateca

    1.5 TSI EVO Xperience 5dr DSG

    Term: 36 months

    Annual Mileage: 5,000

    Initial Payment: £2,149.20

    Processing Fees: £299.99

    Total Cost of Lease: £10,807

    Average Monthly Cost: £300.20

    (All prices inc. VAT)

    35Monthly Payments:

    £238.80

    Deal Details
  • IN STOCK
    Leasing Options

    SEAT Ateca

    1.5 TSI EVO Xperience 5dr DSG

    Term: 48 months

    Annual Mileage: 5,000

    Initial Payment: £2,973.12

    Processing Fees: £299.99

    Total Cost of Lease: £14,918

    Average Monthly Cost: £310.79

    (All prices inc. VAT)

    47Monthly Payments:

    £247.76

    Deal Details
  • IN STOCK
    Leasing Options

    SEAT Ateca

    1.5 TSI EVO Xperience 5dr DSG

    Term: 36 months

    Annual Mileage: 10,000

    Initial Payment: £2,973.96

    Processing Fees: £299.99

    Total Cost of Lease: £11,948

    Average Monthly Cost: £331.89

    (All prices inc. VAT)

    35Monthly Payments:

    £247.83

    Deal Details
  • IN STOCK
    Leasing Options

    SEAT Ateca

    1.5 TSI EVO Xperience 5dr DSG

    Term: 24 months

    Annual Mileage: 5,000

    Initial Payment: £2,987.64

    Processing Fees: £299.99

    Total Cost of Lease: £9,014

    Average Monthly Cost: £375.58

    (All prices inc. VAT)

    23Monthly Payments:

    £248.97

    Deal Details
  • IN STOCK
    Leasing Options

    SEAT Ateca

    1.5 TSI EVO Xperience 5dr DSG

    Term: 36 months

    Annual Mileage: 8,000

    Initial Payment: £2,285.19

    Processing Fees: £299.99

    Total Cost of Lease: £11,472

    Average Monthly Cost: £318.67

    (All prices inc. VAT)

    35Monthly Payments:

    £253.91

    Deal Details
  • IN STOCK
    Leasing Options

    SEAT Ateca

    1.5 TSI EVO Xperience 5dr DSG

    Term: 36 months

    Annual Mileage: 5,000

    Initial Payment: £1,534.56

    Processing Fees: £299.99

    Total Cost of Lease: £10,786

    Average Monthly Cost: £299.62

    (All prices inc. VAT)

    35Monthly Payments:

    £255.76

    Deal Details
  • IN STOCK
    Leasing Options

    SEAT Ateca

    1.5 TSI EVO Xperience 5dr DSG

    Term: 48 months

    Annual Mileage: 8,000

    Initial Payment: £3,094.80

    Processing Fees: £299.99

    Total Cost of Lease: £15,516

    Average Monthly Cost: £323.25

    (All prices inc. VAT)

    47Monthly Payments:

    £257.90

    Deal Details
  • IN STOCK
    Leasing Options

    SEAT Ateca

    1.5 TSI EVO Xperience 5dr DSG

    Term: 36 months

    Annual Mileage: 12,000

    Initial Payment: £3,106.68

    Processing Fees: £299.99

    Total Cost of Lease: £12,468

    Average Monthly Cost: £346.33

    (All prices inc. VAT)

    35Monthly Payments:

    £258.89

    Deal Details

Page 1 of 50 pages

Prev Next

Why use cars2buy?

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

SEAT Ateca Xperience derivatives:

About the Seat Ateca

The Seat Ateca was certainly not one of the earliest SUVs on the market, but it quickly caught up with its peers and has become one of the Spanish manufacturer’s most popular models. That’s hardly surprising – this ideal family car is spacious and comfortable, has very reasonable running costs, and is fun to handle. The Ateca comes with a wide option of engines, making it more of a ‘driver’s car’ than just a family run-around; and with stylish good looks inside and out, and enough sporty touches to add a bit of extra interest, it feels like a very good option for any family.

Why lease a Seat Ateca?

The Seat Ateca is a practical car and a personal lease is a practical way of acquiring one. Budgeting becomes so much simpler knowing you have fixed monthly payments for the length of your contract – and the length will be yours to choose, within limits. You’ll have no concerns about selling the car when it’s time to change – hand it back to the leasing company and they can worry about that! The car will come with a warranty and, usually, the option of a maintenance pack. Sounds like a good idea? Maybe it’s time to start your search.

Compare Seat Ateca leases

Having decided to explore the leasing option, you may be wondering where to start researching Seat Ateca leases. Here on cars2buy is the answer. We have gathered together a vast number of lease deals offered by some of the UK’s most respected lease providers, and our search engine can quickly filter through them to show you the best Seat Ateca leases for you. Just enter your details and press the search button – we will do the rest. Prices are updated on a daily basis so you can be confident that that what you are offered will be current and correct.

Seat Ateca no deposit lease deals

A number of providers are able to offer Seat Ateca no deposit lease deals, requiring only the first month’s rental in advance. If this is of interest adjust your search filters to include this option.

×

Filter your results:

Lease details:

Car details:

Request history8.2.27PHP Version346msRequest Duration2MBMemory UsageGET personal-car-leasing/{manufacturer}/{model}/{derivative}Route
    • Booting (37.75ms)time
    • Application (309ms)time
    • 1 x Application (89.1%)
      309ms
      1 x Booting (10.9%)
      37.75ms
      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
      48 statements were executed40.12ms
      • 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` = 'seat' and `model_slug` = 'ateca' and `car_id` = '75337' and `version_slug` = '1.5-tsi-evo-xperience-5dr-dsg') limit 1
        960μsbrampacController.php#327
        Bindings
        • 0: seat
        • 1: ateca
        • 2: 75337
        • 3: 1.5-tsi-evo-xperience-5dr-dsg
        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` = 'seat' and `model_slug` = 'ateca' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `car_id` = '75337'
        2.38msbrampacCarLeasingSearch.php#58
        Bindings
        • 0: seat
        • 1: ateca
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 75337
        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` = 'seat' and `model_slug` = 'ateca' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `car_id` = '75337' order by price_monthly, effective_cost limit 10 offset 0
        2.57msbrampacCarLeasingSearch.php#58
        Bindings
        • 0: seat
        • 1: ateca
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 75337
        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` = 'seat' and `model_slug` = 'ateca' and `car_id` = '75337' order by `car_specs`.`cap_id` desc limit 1
        320μsbrampacModel.php#154
        Bindings
        • 0: seat
        • 1: ateca
        • 2: 75337
        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` = 93982 and `ima_type` = 'CAR' and `path` != '' and `izmoAlias` != '' order by `ima_model_year` desc limit 1
        280μsbrampacImagesRepository.php#28
        Bindings
        • 0: 93982
        • 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` = 'SEAT' order by RAND() limit 1
        250μsbrampacCarLeasingSearch.php#117
        Bindings
        • 0: SEAT
        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` = 'SEAT' and `related_lease_models`.`model` = 'Ateca') group by `make_related`, `model_related` order by sort_order ASC limit 5
        420μsbrampacCarLeasingSearch.php#173
        Bindings
        • 0: SEAT
        • 1: Ateca
        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` = 'Qashqai' 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: Nissan
        • 1: Qashqai
        • 2: 
        • 3: 
        • 4: CAR
        Backtrace
        • 14. app/Queries/ImagesRepository.php:53
        • 15. app/Traits/VehicleImage.php:112
        • 16. app/Queries/CarLeasingSearch.php:176
        • 17. app/Http/Controllers/CarLeasingController.php:307
        • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select `path`, `izmoAlias` from `images_backfill` where `ima_make` = 'Nissan' and `ima_model` = 'Qashqai' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' limit 1
        180μsbrampacImagesRepository.php#97
        Bindings
        • 0: Nissan
        • 1: Qashqai
        • 2: 
        • 3: 
        • 4: CAR
        Backtrace
        • 16. app/Queries/ImagesRepository.php:97
        • 17. app/Traits/VehicleImage.php:121
        • 18. app/Queries/CarLeasingSearch.php:176
        • 19. app/Http/Controllers/CarLeasingController.php:307
        • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'Vauxhall' and `car_specs`.`model` = 'Grandland' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
        200μsbrampacImagesRepository.php#53
        Bindings
        • 0: Vauxhall
        • 1: Grandland
        • 2: 
        • 3: 
        • 4: CAR
        Backtrace
        • 14. app/Queries/ImagesRepository.php:53
        • 15. app/Traits/VehicleImage.php:112
        • 16. app/Queries/CarLeasingSearch.php:176
        • 17. app/Http/Controllers/CarLeasingController.php:307
        • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select `path`, `izmoAlias` from `images_izmo` inner join `car_specs` on `images_izmo`.`cap_id` = `car_specs`.`cap_id` where `car_specs`.`make` = 'Renault' and `car_specs`.`model` = 'Scenic E-Tech' 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: Renault
        • 1: Scenic E-Tech
        • 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` = 'Renault' and `ima_model` = 'Scenic E-Tech' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' limit 1
        170μsbrampacImagesRepository.php#97
        Bindings
        • 0: Renault
        • 1: Scenic E-Tech
        • 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` = 'Renault' and `car_specs`.`model` = 'Symbioz' 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: Renault
        • 1: Symbioz
        • 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` = 'Renault' and `ima_model` = 'Symbioz' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' limit 1
        120μsbrampacImagesRepository.php#97
        Bindings
        • 0: Renault
        • 1: Symbioz
        • 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 distinct `make`, `model`, `version`, `trim`, `make_slug`, `model_slug` from `car_specs` where (`make_slug` = 'seat' and `model_slug` = 'ateca') group by `trim` order by `trim` asc
        170μsbrampacModel.php#128
        Bindings
        • 0: seat
        • 1: ateca
        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` = '75337' limit 1
        200μsbrampacModel.php#173
        Bindings
        • 0: 75337
        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` = 'seat' and `model_slug` = 'ateca' and `trim` = 'Xperience') order by `version` asc
        160μsbrampacModel.php#187
        Bindings
        • 0: seat
        • 1: ateca
        • 2: Xperience
        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` = 'SEAT' and `review_model` = 'Ateca') order by `review_date` asc limit 1
        170μsbrampacVehicleReview.php#61
        Bindings
        • 0: SEAT
        • 1: Ateca
        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` = 'seat' and `model_slug` = 'ateca' and `amount` > 0 and `d_live` = 1 and `live` = 1 and `cap_id` > 1 and `otrprice` > 5000 and `pa_pid` = 5) and `car_id` = '75337' order by `otrprice` asc limit 2
        490μsbrampacNewCarSearch.php#227
        Bindings
        • 0: seat
        • 1: ateca
        • 2: 0
        • 3: 1
        • 4: 1
        • 5: 1
        • 6: 5000
        • 7: 5
        • 8: 75337
        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` = 'seat' and `model_slug` = 'ateca' 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
        950μsbrampacNewCarSearch.php#227
        Bindings
        • 0: seat
        • 1: ateca
        • 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` = 'seat' and `model_slug` = 'ateca' 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`
        1.29msbrampacNewCarSearch.php#260
        Bindings
        • 0: seat
        • 1: ateca
        • 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` = 'seat' group by `car_specs`.`model` order by `car_specs`.`model` asc
        1.26msbrampacModel.php#85
        Bindings
        • 0: seat
        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` = 'SEAT' and `car_specs`.`model` = 'Arona' 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: SEAT
        • 1: Arona
        • 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` = 'SEAT' and `ima_model` = 'Arona' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' limit 1
        170μsbrampacImagesRepository.php#97
        Bindings
        • 0: SEAT
        • 1: Arona
        • 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` = 'SEAT' and `car_specs`.`model` = 'Ateca' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' order by `images_izmo`.`cap_id` desc, `images_izmo`.`ima_model_year` desc limit 1
        180μsbrampacImagesRepository.php#53
        Bindings
        • 0: SEAT
        • 1: Ateca
        • 2: 
        • 3: 
        • 4: CAR
        Backtrace
        • 14. app/Queries/ImagesRepository.php:53
        • 15. app/Traits/VehicleImage.php:112
        • 16. app/Queries/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` = 'SEAT' and `car_specs`.`model` = 'Ibiza' 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: SEAT
        • 1: Ibiza
        • 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` = 'SEAT' and `car_specs`.`model` = 'Leon' 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: SEAT
        • 1: Leon
        • 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` = 'SEAT' and `ima_model` = 'Leon' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' limit 1
        170μsbrampacImagesRepository.php#97
        Bindings
        • 0: SEAT
        • 1: Leon
        • 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` = 'SEAT' and `car_specs`.`model` = 'Leon Estate' 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: SEAT
        • 1: Leon 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` = 'SEAT' and `ima_model` = 'Leon Estate' and `path` != '' and `izmoAlias` != '' and `ima_type` = 'CAR' limit 1
        170μsbrampacImagesRepository.php#97
        Bindings
        • 0: SEAT
        • 1: Leon 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` = 'SEAT' and `car_specs`.`model` = 'Tarraco' 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: SEAT
        • 1: Tarraco
        • 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` = 'seat' and `model_slug` = 'ateca' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `car_id` = '75337'
        2.24msbrampacLeaseCarFilter.php#254
        Bindings
        • 0: seat
        • 1: ateca
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 75337
        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` = 'seat' and `model_slug` = 'ateca' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `car_id` = '75337'
        2.14msbrampacLeaseCarFilter.php#278
        Bindings
        • 0: seat
        • 1: ateca
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 75337
        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` = 'seat' and `model_slug` = 'ateca' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `car_id` = '75337' order by `trim_slug` asc
        2.05msbrampacLeaseCarFilter.php#87
        Bindings
        • 0: seat
        • 1: ateca
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 75337
        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` = '75337'
        190μsbrampacLeaseCarFilter.php#118
        Bindings
        • 0: 75337
        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` = 'seat' and `model_slug` = 'ateca' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `car_id` = '75337' order by `fuel` asc
        1.95msbrampacLeaseCarFilter.php#133
        Bindings
        • 0: seat
        • 1: ateca
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 75337
        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` = 'seat' and `model_slug` = 'ateca' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `car_id` = '75337' order by `transmission` asc
        2.03msbrampacLeaseCarFilter.php#149
        Bindings
        • 0: seat
        • 1: ateca
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 75337
        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` = 'seat' and `model_slug` = 'ateca' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `car_id` = '75337' order by `engine` asc
        2.15msbrampacLeaseCarFilter.php#164
        Bindings
        • 0: seat
        • 1: ateca
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 75337
        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` = 'seat' and `model_slug` = 'ateca' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `car_id` = '75337' order by `bodytype` asc
        2.11msbrampacLeaseCarFilter.php#178
        Bindings
        • 0: seat
        • 1: ateca
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 75337
        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` = 'seat' and `model_slug` = 'ateca' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `car_id` = '75337' order by `doors` asc
        2.14msbrampacLeaseCarFilter.php#193
        Bindings
        • 0: seat
        • 1: ateca
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 75337
        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` = 'seat' and `model_slug` = 'ateca' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `car_id` = '75337' and `term` in (6, 12, 18, 24, 36, 48, 60) order by `term` asc
        2.34msbrampacLeaseCarFilter.php#208
        Bindings
        • 0: seat
        • 1: ateca
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 75337
        • 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` = 'seat' and `model_slug` = 'ateca' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `car_id` = '75337' 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.36msbrampacLeaseCarFilter.php#223
        Bindings
        • 0: seat
        • 1: ateca
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 75337
        • 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` = 'seat' and `model_slug` = 'ateca' and `lease_live` = 1 and `lease_active` = 1 and `live` = 1) and `lease_hash` is not null and `car_id` = '75337' 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
        2.54msbrampacLeaseCarFilter.php#238
        Bindings
        • 0: seat
        • 1: ateca
        • 2: 1
        • 3: 1
        • 4: 1
        • 5: 75337
        • 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
        150μ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` = 'SEAT' and `Model` = 'Ateca' and `Type` = 'Car - Personal Lease')
        410μsbrampacSearchOptimisation.php#19
        Bindings
        • 0: SEAT
        • 1: Ateca
        • 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` = 'SEAT' and `model` = 'Ateca' limit 1
        250μsbrampacCarLeasingSearch.php#629
        Bindings
        • 0: SEAT
        • 1: Ateca
        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
      80CarSpec.php#?
      App\Models\LeaseOfferPersonal
      10LeaseOfferPersonal.php#?
      App\Models\RelatedLeaseModel
      5RelatedLeaseModel.php#?
      App\Models\CusCar
      3CusCar.php#?
      App\Models\ImagesBackfill
      2ImagesBackfill.php#?
      App\Models\ImagesIzmo
      1ImagesIzmo.php#?
      App\Models\Seo
      1Seo.php#?
      App\Models\MinPricePersonalLease
      1MinPricePersonalLease.php#?
          _token
          Y7AtxG1Ms2AIACttxipsSbHMBVDedQG5rwjHHPGJ
          views
          11
          uid
          d1c7a299f0afaa8ec0898dec5fb5266a
          last_results_page
          /personal-car-leasing/seat/ateca/1.5-tsi-evo-xperience-5dr-dsg_75337?fDerivative=1.5+Tsi+Evo+Xperien...
          _previous
          array:1 [ "url" => "https://laravel.cars2buy.co.uk/personal-car-leasing/seat/ateca/1.5-tsi-evo-xpe...
          _flash
          array:2 [ "old" => [] "new" => [] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /personal-car-leasing/seat/ateca/1.5-tsi-evo-xperience-5dr-dsg_75337
          status_code
          200
          
          status_text
          OK
          format
          html
          content_type
          text/html; charset=UTF-8
          request_query
          0 of 0
          array:3 [ "fDerivative" => "1.5 Tsi Evo Xperience 5dr Dsg" "page" => "2page=2page=2page=2page=4page=3" "fCarID" => "75337" ]
          request_request
          []
          
          request_headers
          0 of 0
          array:19 [ "cookie" => array:1 [ 0 => "_ga=GA1.1.36365428.1737217991; _gcl_au=1.1.1894344749.1737217991; uid=eyJpdiI6ImRkSUNnSGxJWjZJN0xHNE9hTTNrS0E9PSIsInZhbHVlIjoiN3R4ZU9mYkswWFUzS2p5VEx3Q2JuSWhMRWtxbmcwNit4eDlpWE5yTUxYcGNDd25jYTdYODFBbmpHTU80R2xvK2dpYW9iNnc2cnBaS3dkUTRZODBaME5hRmQxM2hkZVBiRFVFWGxva0lIREk9IiwibWFjIjoiMTMwZDQ4ZmI4NDg0N2ZmOTMyYTlkMDE0NjEwYzJkNDUxYTRhNjIzMWU3ZTc3OGZjMzg2YmZiNTJmZWM2OWU1NSIsInRhZyI6IiJ9; XSRF-TOKEN=eyJpdiI6ImJvVHVvOUZRY0VWaDFOVFFReklFb0E9PSIsInZhbHVlIjoiRFBGSDRPZkdaVDZBcUhZS3dJQ21Uei9nc3h1dzl2aHFOby84alZrQU5SNWxWTUlibUFHMC9Vd2hoNjFnc1dxK2RrQjFOWGR0azdiMDhtNkZaVnlxbTNFZjRoc2ZYb0RWUVl3VHVKWkk0dnBtVXI4dzVSYXpGOFpJNDQwSWwvNWUiLCJtYWMiOiJlMWVlOGMxMWQxZGRjN2RkYzg2NzA5YTFjOWRiNmM0Y2FiZDlhOTVhZTlkZjczMWNjM2NhMWViYWIyOGNmY2ZhIiwidGFnIjoiIn0%3D; laravel_session=eyJpdiI6IllVT1h2Z2RBMUplRDNnWnQvekJ6YlE9PSIsInZhbHVlIjoiSXRhenFvaGVsV2tUS2FGeHQ4L1BJMUxYYmU0aTJFSEI4dGZTUjcvY2p2Y2VxTDFFMDE5NGhMVWdheEovcmVvM094bTVISUJwNURLY0d0SXAxdytiRjI2TXFuOUszc1pGUjFHOW1nWFZ2U3QyMDhZZmJJVWhIdFM0bXVnNndwK1YiLCJtYWMiOiI2N2I2YzBmZWFkMWEyZTE0NDg3NGI4ZmE3OTlkNzZiYmY5OTUxMDU2NzYzM2UzN2RiMTVkMDFmZmQ4MjRhNDk3IiwidGFnIjoiIn0%3D; _ga_N9GLTHNRLQ=GS1.1.1737217990.1.1.1737218011.39.0.0_ga=GA1.1.36365428.1737217991; _gcl_au=1.1.1894344749.1737217991; uid=eyJpdiI6ImRkSUNnSGxJWjZJN0xHNE9hTTNrS0E9PSIsInZhbHVlIjoiN3R4ZU9mYkswWFUzS2p5VEx3Q2JuSWhMRW" ] "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.219.192.118" ] "host" => array:1 [ 0 => "laravel.cars2buy.co.uk" ] ]
          request_cookies
          0 of 0
          array:6 [ "_ga" => null "_gcl_au" => null "uid" => "d1c7a299f0afaa8ec0898dec5fb5266a" "XSRF-TOKEN" => "Y7AtxG1Ms2AIACttxipsSbHMBVDedQG5rwjHHPGJ" "laravel_session" => "eLLoJTFsAg9DFxVxv0FoYkwBaj011GXxvJFp8kDC" "_ga_N9GLTHNRLQ" => null ]
          response_headers
          0 of 0
          array:7 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "private, must-revalidate" ] "date" => array:1 [ 0 => "Sat, 18 Jan 2025 16:33:32 GMT" ] "pragma" => array:1 [ 0 => "no-cache" ] "expires" => array:1 [ 0 => "-1" ] "set-cookie" => array:3 [ 0 => "uid=eyJpdiI6Im4za2VwQ1RwQ1UvV1hKMTFtYk1FM2c9PSIsInZhbHVlIjoidnNBdmFBMndvMW45Z0xaUnNvUk5kTzcwZTJJMno1d2YzcUxJQ2x5WFczY0tVSVJxVnJTSUlJdElxWVNvYnVHY01tWVV5M3dMN1ZSc1ZFVDE0ajNNbWFnZHNkK1JSZnhpMVYxWC95anNmYUE9IiwibWFjIjoiZjE5YzBlNjQ3ZjU5NzAyNjQyN2MzYzRlNDY3MGYwNTI1MDUzOTQzZDIwMzc4MWI3MTZiNzdmMjU4N2EzMWJmYyIsInRhZyI6IiJ9; expires=Sat, 20 Aug 5357 02:05:32 GMT; Max-Age=105166200720; path=/; secure; httponly; samesite=laxuid=eyJpdiI6Im4za2VwQ1RwQ1UvV1hKMTFtYk1FM2c9PSIsInZhbHVlIjoidnNBdmFBMndvMW45Z0xaUnNvUk5kTzcwZTJJMno1d2YzcUxJQ2x5WFczY0tVSVJxVnJTSUlJdElxWVNvYnVHY01tWVV5M3dMN1ZS" 1 => "XSRF-TOKEN=eyJpdiI6InI0NDhmVEFaV21aamhBeDhVZVUxeEE9PSIsInZhbHVlIjoiREU0VGhqUjNLZ2Q0S05nL2hmcW9sdk1SY1kvdWJhUGxuU09iK0IwaHBJbnh3RHdMWk1VSEY3RDlldXRnTnIzRnE5U2xTSGRrb1B0OXUwZy9KMkNWaDhDaDQzcUxMUHk0ejBEM2hONnNXR2pqemc5cFFYZmlXV092Sjk3Yk1TNS8iLCJtYWMiOiJlZmIwZjllNTJjNmEyYzY1MmUyYjAwZjQwYjQ2NWU0YmNjOGExNTBiMTdmNDcxZDMxZjUxNGYxOTkzM2JmMGJjIiwidGFnIjoiIn0%3D; expires=Sat, 18 Jan 2025 18:33:32 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6InI0NDhmVEFaV21aamhBeDhVZVUxeEE9PSIsInZhbHVlIjoiREU0VGhqUjNLZ2Q0S05nL2hmcW9sdk1SY1kvdWJhUGxuU09iK0IwaHBJbnh3RHdMWk1VSEY3RDlldXRnTnIzRnE5U2xTS" 2 => "laravel_session=eyJpdiI6Ik9zdU1jaW1FUjRqUjB0U1FqN09BWFE9PSIsInZhbHVlIjoib00za3BWSTZ2cm5naUM1R25BU3FtVXQ3VEt1YXk3MHVadjFqeFZIM05aVlppQ000VGJBTUdDOTZaVFUzUGpMWGVYSXJTUFViaXZrK1c2WkRrd3UyWC8zc2xKcEVmQllzc2JWZndKT2xYNmhEWEZobGlzblZoc2dOYXNlWVg0NWEiLCJtYWMiOiI3MzRhM2ZkYjQzNWExOTA4OWZmZmU4YTg2Mjg3NTQ4ZGVlMTQ0ZGNlMjQzMWY5YzEyNDgwMWY1MmNkYTgyYWY4IiwidGFnIjoiIn0%3D; expires=Sat, 18 Jan 2025 18:33:32 GMT; Max-Age=7200; path=/; httponly; samesite=laxlaravel_session=eyJpdiI6Ik9zdU1jaW1FUjRqUjB0U1FqN09BWFE9PSIsInZhbHVlIjoib00za3BWSTZ2cm5naUM1R25BU3FtVXQ3VEt1YXk3MHVadjFqeFZIM05aVlppQ000VGJBTUdDOTZaVFUzUGpMWGVY" ] "Set-Cookie" => array:3 [ 0 => "uid=eyJpdiI6Im4za2VwQ1RwQ1UvV1hKMTFtYk1FM2c9PSIsInZhbHVlIjoidnNBdmFBMndvMW45Z0xaUnNvUk5kTzcwZTJJMno1d2YzcUxJQ2x5WFczY0tVSVJxVnJTSUlJdElxWVNvYnVHY01tWVV5M3dMN1ZSc1ZFVDE0ajNNbWFnZHNkK1JSZnhpMVYxWC95anNmYUE9IiwibWFjIjoiZjE5YzBlNjQ3ZjU5NzAyNjQyN2MzYzRlNDY3MGYwNTI1MDUzOTQzZDIwMzc4MWI3MTZiNzdmMjU4N2EzMWJmYyIsInRhZyI6IiJ9; expires=Sat, 20-Aug-5357 02:05:32 GMT; path=/; secure; httponlyuid=eyJpdiI6Im4za2VwQ1RwQ1UvV1hKMTFtYk1FM2c9PSIsInZhbHVlIjoidnNBdmFBMndvMW45Z0xaUnNvUk5kTzcwZTJJMno1d2YzcUxJQ2x5WFczY0tVSVJxVnJTSUlJdElxWVNvYnVHY01tWVV5M3dMN1ZS" 1 => "XSRF-TOKEN=eyJpdiI6InI0NDhmVEFaV21aamhBeDhVZVUxeEE9PSIsInZhbHVlIjoiREU0VGhqUjNLZ2Q0S05nL2hmcW9sdk1SY1kvdWJhUGxuU09iK0IwaHBJbnh3RHdMWk1VSEY3RDlldXRnTnIzRnE5U2xTSGRrb1B0OXUwZy9KMkNWaDhDaDQzcUxMUHk0ejBEM2hONnNXR2pqemc5cFFYZmlXV092Sjk3Yk1TNS8iLCJtYWMiOiJlZmIwZjllNTJjNmEyYzY1MmUyYjAwZjQwYjQ2NWU0YmNjOGExNTBiMTdmNDcxZDMxZjUxNGYxOTkzM2JmMGJjIiwidGFnIjoiIn0%3D; expires=Sat, 18-Jan-2025 18:33:32 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6InI0NDhmVEFaV21aamhBeDhVZVUxeEE9PSIsInZhbHVlIjoiREU0VGhqUjNLZ2Q0S05nL2hmcW9sdk1SY1kvdWJhUGxuU09iK0IwaHBJbnh3RHdMWk1VSEY3RDlldXRnTnIzRnE5U2xTS" 2 => "laravel_session=eyJpdiI6Ik9zdU1jaW1FUjRqUjB0U1FqN09BWFE9PSIsInZhbHVlIjoib00za3BWSTZ2cm5naUM1R25BU3FtVXQ3VEt1YXk3MHVadjFqeFZIM05aVlppQ000VGJBTUdDOTZaVFUzUGpMWGVYSXJTUFViaXZrK1c2WkRrd3UyWC8zc2xKcEVmQllzc2JWZndKT2xYNmhEWEZobGlzblZoc2dOYXNlWVg0NWEiLCJtYWMiOiI3MzRhM2ZkYjQzNWExOTA4OWZmZmU4YTg2Mjg3NTQ4ZGVlMTQ0ZGNlMjQzMWY5YzEyNDgwMWY1MmNkYTgyYWY4IiwidGFnIjoiIn0%3D; expires=Sat, 18-Jan-2025 18:33:32 GMT; path=/; httponlylaravel_session=eyJpdiI6Ik9zdU1jaW1FUjRqUjB0U1FqN09BWFE9PSIsInZhbHVlIjoib00za3BWSTZ2cm5naUM1R25BU3FtVXQ3VEt1YXk3MHVadjFqeFZIM05aVlppQ000VGJBTUdDOTZaVFUzUGpMWGVY" ] ]
          session_attributes
          0 of 0
          array:7 [ "_token" => "Y7AtxG1Ms2AIACttxipsSbHMBVDedQG5rwjHHPGJ" "views" => 11 "uid" => "d1c7a299f0afaa8ec0898dec5fb5266a" "last_results_page" => "/personal-car-leasing/seat/ateca/1.5-tsi-evo-xperience-5dr-dsg_75337?fDerivative=1.5+Tsi+Evo+Xperience+5dr+Dsg&page=2page%3D2page%3D2page%3D2page%3D4page%3D3" "_previous" => array:1 [ "url" => "https://laravel.cars2buy.co.uk/personal-car-leasing/seat/ateca/1.5-tsi-evo-xperience-5dr-dsg_75337?fDerivative=1.5%20Tsi%20Evo%20Xperience%205dr%20Dsg&page=2page%3D2page%3D2page%3D2page%3D4page%3D3https://laravel.cars2buy.co.uk/personal-car-leasing/seat/ateca/1.5-tsi-evo-xperience-5dr-dsg_75337?fDerivative=1.5%20Tsi%20Evo%20Xperience%205dr%20Dsg&page=2pag" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
          ClearShow all
          Date ↕MethodURLData
          #12025-01-18 16:33:32GET/personal-car-leasing/seat/ateca/1.5-tsi-evo-xperience-5dr-dsg_75337?fDerivative=1.5+Tsi+Evo+Xperience+5dr+Dsg&page=2page%3D2page%3D2page%3D2page%3D4page%3D31348103