Leon

Redesigned and enhanced to become a standalone model.

Downloads

Leon Brochure

Available with e-HYBRID & up to 221kW (300HP) petrol engines.

Up to (200kW): 272 HP*
e-Range: > 119 km*

Pure Magnetism

Provocative Performance

Boundless power, infinite possibilities. A new age set in motion with future-centric e- HYBRID technology.

Audacious Design

A fierce and muscular body, an emotive interior. Dominant and dynamic, for exhilarating journeys.

Tech that Breaks Boundaries

Journey beyond the physical. Go against the grain with transgressive connectivity and high-tech performance.

CAR DESIGN FOR A NEW ERA

A progressive e-HYBRID vehicle that’s bold and ferocious – inside and out.

DARING AND DYNAMIC

From the emblematic grille to the captivating CUPRA Matrix LED headlamps – accentuating the CUPRA Leon’s dominant character.

EXHILARATING CORE

The seats offer superior support with race-inspired curvature, while the carbon fibre rear cover and cooling vents embody a sporty aesthetic that is subtle yet sublime.

AN ELECTRIFYING EVOLUTION

CUPRA LEON VZ e-HYBRID

Revel in boundless freedom with increased range and power that goes beyond the extra mile, amplifying emotional experiences.

FAST CHARGING

Delivering the quickest charge yet – ultra-rapid recharging for breathtaking journeys. Charging at home has never been easier.

ENHANCED CONNECTIVITY

CUPRA Connect

Experience seamless connectivity with CUPRA CONNECT via the 12.9" Infotainment System. Enjoy online maps, entertainment, voice recognition and more.

MY CUPRA APP

Unlock a world of convenience with the My CUPRA app. Easily control and access your new CUPRA Leon with the remote lock & unlock function.

Terms & Conditions:

*The accurate range for your vehicle will vary according to a number of different factors which include the route, weather conditions, vehicle load (occupants + luggage), battery age and condition, optional equipment (alloys, tyres, etc.), the use of peripheral energy consumption systems such as heating, air conditioning and heated seats, as well as your driving style. The indicated range has been calculated in compliance with the WLTP standards, which set out test conditions applicable to all car manufacturers to ensure the comparability of these tests for all vehicles.

Contact Details

Milltown Lane,
Rathnew, Co. Wicklow

Service Opening Hours

Mon - Fri:	8.30am - 5.00pm
Sat:	Closed
Sun:	Closed

Mercedes-benz Social Media

SEAT Social Media

Debug Bar(errors: 0, warnings: 82, notices: 43, queries: 13, includes: 1, time: 87.31ms)▲

No errors

Warning: Undefined array key "extension"

request.inc:31

Warning: Undefined variable $dealer_email

new-cars-modals.php:7

Warning: Undefined array key "post_type"

new-cars-modals.php:13

Warning: Undefined property: stdClass::$address1

mtd.inc:271

Warning: Undefined property: stdClass::$address2

mtd.inc:272

Warning: Undefined property: stdClass::$address3

mtd.inc:275

Warning: Undefined property: stdClass::$address4

mtd.inc:278

Warning: Undefined property: stdClass::$address5

mtd.inc:281

Warning: Undefined property: stdClass::$postcode

mtd.inc:292

Warning: Undefined array key 1

5cdf59faf7e307af9590b3f880c63627a9be50c4.php:13

Warning: Undefined property: stdClass::$address1

mtd.inc:271

Warning: Undefined property: stdClass::$address2

mtd.inc:272

Warning: Undefined property: stdClass::$address3

mtd.inc:275

Warning: Undefined property: stdClass::$address4

mtd.inc:278

Warning: Undefined property: stdClass::$address5

mtd.inc:281

Warning: Undefined property: stdClass::$postcode

mtd.inc:292

Warning: Undefined array key 1

nav-bar.php:12

Warning: Undefined array key 2

nav-bar.php:13

Warning: Undefined variable $is_new_cars_page

nav-bar.php:154

Warning: Undefined variable $filter

nav-bar.php:534

Warning: Undefined variable $filter

nav-bar.php:579

Warning: Undefined variable $filter

nav-bar.php:598

Warning: Undefined variable $filter

nav-bar.php:617

Warning: Undefined array key 1

c93092cbfa629bc73632e690058f2a27e6e6e238.php:11

Warning: Undefined array key 2

c93092cbfa629bc73632e690058f2a27e6e6e238.php:12

Warning: Undefined variable $whatsapp_phone

c93092cbfa629bc73632e690058f2a27e6e6e238.php:13

Warning: Undefined variable $search_criteria

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:19

Warning: Trying to access array offset on null

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:19

Warning: Undefined variable $search_criteria

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:19

Warning: Trying to access array offset on null

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:19

Warning: Undefined variable $search_criteria

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:19

Warning: Trying to access array offset on null

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:19

Warning: Undefined variable $search_criteria

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:19

Warning: Trying to access array offset on null

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:19

Warning: Undefined variable $search_criteria

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:19

Warning: Trying to access array offset on null

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:19

Warning: Undefined variable $search_criteria

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:19

Warning: Trying to access array offset on null

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:19

Warning: Undefined variable $search_criteria

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:19

Warning: Trying to access array offset on null

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:19

Warning: Undefined variable $search_criteria

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:19

Warning: Trying to access array offset on null

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:19

Warning: Undefined variable $search_criteria

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:19

Warning: Trying to access array offset on null

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:19

Warning: Undefined variable $search_criteria

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:19

Warning: Trying to access array offset on null

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:19

Warning: Undefined variable $search_criteria

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:19

Warning: Trying to access array offset on null

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:19

Warning: Undefined variable $search_criteria

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:19

Warning: Trying to access array offset on null

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:19

Warning: Undefined variable $search_criteria

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:19

Warning: Trying to access array offset on null

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:19

Warning: Undefined variable $search_criteria

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:19

Warning: Trying to access array offset on null

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:19

Warning: Undefined variable $search_criteria

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:19

Warning: Trying to access array offset on null

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:19

Warning: Undefined variable $search_criteria

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:19

Warning: Trying to access array offset on null

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:19

Warning: Undefined variable $search_criteria

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:19

Warning: Trying to access array offset on null

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:19

Warning: Undefined variable $search_criteria

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:19

Warning: Trying to access array offset on null

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:19

Warning: Undefined variable $search_criteria

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:19

Warning: Trying to access array offset on null

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:19

Warning: Undefined variable $search_criteria

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:19

Warning: Trying to access array offset on null

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:19

Warning: Undefined variable $search_criteria

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:19

Warning: Trying to access array offset on null

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:19

Warning: Undefined variable $search_criteria

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:29

Warning: Trying to access array offset on null

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:29

Warning: Undefined variable $search_criteria

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:36

Warning: Trying to access array offset on null

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:36

Warning: Undefined variable $search_criteria

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:38

Warning: Trying to access array offset on null

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:38

Warning: Undefined variable $search_criteria

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:40

Warning: Trying to access array offset on null

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:40

Warning: Undefined variable $search_criteria

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:42

Warning: Trying to access array offset on null

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:42

Warning: Undefined variable $search_criteria

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:44

Warning: Trying to access array offset on null

d16f190e9ac18d2058f81c96f8e2f6fc915908bb.php:44

Warning: Undefined array key 3

c93092cbfa629bc73632e690058f2a27e6e6e238.php:99

Warning: Undefined array key 8

opening-hours.php:43

Deprecated: Using ${var} in strings is deprecated, use {$var} instead

db.inc:310

Deprecated: Using ${var} in strings is deprecated, use {$var} instead

db.inc:310

Deprecated: mtd_makes(): Optional parameter $filter declared before required parameter $show_make_text is implicitly treated as a required parameter

mtd.inc:1036

Deprecated: mtd_makes(): Optional parameter $extra_filters declared before required parameter $show_make_text is implicitly treated as a required parameter

mtd.inc:1036

Deprecated: Jenssegers\Blade\Blade::__construct(): Implicitly marking parameter $container as nullable is deprecated, the explicit nullable type must be used instead

Blade.php:34

Deprecated: Illuminate\Container\Container::beforeResolving(): Implicitly marking parameter $callback as nullable is deprecated, the explicit nullable type must be used instead

Container.php:1114

Deprecated: Illuminate\Container\Container::resolving(): Implicitly marking parameter $callback as nullable is deprecated, the explicit nullable type must be used instead

Container.php:1134

Deprecated: Illuminate\Container\Container::afterResolving(): Implicitly marking parameter $callback as nullable is deprecated, the explicit nullable type must be used instead

Container.php:1154

Deprecated: Illuminate\Container\Container::setInstance(): Implicitly marking parameter $container as nullable is deprecated, the explicit nullable type must be used instead

Container.php:1393

Deprecated: Illuminate\Contracts\Container\Container::resolving(): Implicitly marking parameter $callback as nullable is deprecated, the explicit nullable type must be used instead

Container.php:173

Deprecated: Illuminate\Contracts\Container\Container::afterResolving(): Implicitly marking parameter $callback as nullable is deprecated, the explicit nullable type must be used instead

Container.php:182

Deprecated: Illuminate\View\FileViewFinder::__construct(): Implicitly marking parameter $extensions as nullable is deprecated, the explicit nullable type must be used instead

FileViewFinder.php:53

Deprecated: Illuminate\Events\Dispatcher::__construct(): Implicitly marking parameter $container as nullable is deprecated, the explicit nullable type must be used instead

Dispatcher.php:65

Deprecated: Illuminate\Support\Str::createUuidsUsing(): Implicitly marking parameter $factory as nullable is deprecated, the explicit nullable type must be used instead

Str.php:1007

Deprecated: Illuminate\View\View::render(): Implicitly marking parameter $callback as nullable is deprecated, the explicit nullable type must be used instead

View.php:88

Deprecated: Illuminate\Support\Arr::first(): Implicitly marking parameter $callback as nullable is deprecated, the explicit nullable type must be used instead

Arr.php:183

Deprecated: Illuminate\Support\Arr::last(): Implicitly marking parameter $callback as nullable is deprecated, the explicit nullable type must be used instead

Arr.php:212

Deprecated: Illuminate\View\Engines\CompilerEngine::__construct(): Implicitly marking parameter $files as nullable is deprecated, the explicit nullable type must be used instead

CompilerEngine.php:33

Deprecated: Illuminate\Support\Collection::filter(): Implicitly marking parameter $callback as nullable is deprecated, the explicit nullable type must be used instead

Collection.php:355

Deprecated: Illuminate\Support\Collection::first(): Implicitly marking parameter $callback as nullable is deprecated, the explicit nullable type must be used instead

Collection.php:371

Deprecated: Illuminate\Support\Collection::last(): Implicitly marking parameter $callback as nullable is deprecated, the explicit nullable type must be used instead

Collection.php:668

Deprecated: Illuminate\Support\Traits\EnumeratesValues::times(): Implicitly marking parameter $callback as nullable is deprecated, the explicit nullable type must be used instead

EnumeratesValues.php:144

Deprecated: Illuminate\Support\Traits\EnumeratesValues::when(): Implicitly marking parameter $callback as nullable is deprecated, the explicit nullable type must be used instead

EnumeratesValues.php:475

Deprecated: Illuminate\Support\Traits\EnumeratesValues::when(): Implicitly marking parameter $default as nullable is deprecated, the explicit nullable type must be used instead

EnumeratesValues.php:475

Deprecated: Illuminate\Support\Traits\EnumeratesValues::whenEmpty(): Implicitly marking parameter $default as nullable is deprecated, the explicit nullable type must be used instead

EnumeratesValues.php:497

Deprecated: Illuminate\Support\Traits\EnumeratesValues::whenNotEmpty(): Implicitly marking parameter $default as nullable is deprecated, the explicit nullable type must be used instead

EnumeratesValues.php:509

Deprecated: Illuminate\Support\Traits\EnumeratesValues::unless(): Implicitly marking parameter $default as nullable is deprecated, the explicit nullable type must be used instead

EnumeratesValues.php:522

Deprecated: Illuminate\Support\Traits\EnumeratesValues::unlessEmpty(): Implicitly marking parameter $default as nullable is deprecated, the explicit nullable type must be used instead

EnumeratesValues.php:534

Deprecated: Illuminate\Support\Traits\EnumeratesValues::unlessNotEmpty(): Implicitly marking parameter $default as nullable is deprecated, the explicit nullable type must be used instead

EnumeratesValues.php:546

Deprecated: Illuminate\Support\Enumerable::times(): Implicitly marking parameter $callback as nullable is deprecated, the explicit nullable type must be used instead

Enumerable.php:28

Deprecated: Illuminate\Support\Enumerable::filter(): Implicitly marking parameter $callback as nullable is deprecated, the explicit nullable type must be used instead

Enumerable.php:268

Deprecated: Illuminate\Support\Enumerable::when(): Implicitly marking parameter $default as nullable is deprecated, the explicit nullable type must be used instead

Enumerable.php:278

Deprecated: Illuminate\Support\Enumerable::whenEmpty(): Implicitly marking parameter $default as nullable is deprecated, the explicit nullable type must be used instead

Enumerable.php:287

Deprecated: Illuminate\Support\Enumerable::whenNotEmpty(): Implicitly marking parameter $default as nullable is deprecated, the explicit nullable type must be used instead

Enumerable.php:296

Deprecated: Illuminate\Support\Enumerable::unless(): Implicitly marking parameter $default as nullable is deprecated, the explicit nullable type must be used instead

Enumerable.php:306

Deprecated: Illuminate\Support\Enumerable::unlessEmpty(): Implicitly marking parameter $default as nullable is deprecated, the explicit nullable type must be used instead

Enumerable.php:315

Deprecated: Illuminate\Support\Enumerable::unlessNotEmpty(): Implicitly marking parameter $default as nullable is deprecated, the explicit nullable type must be used instead

Enumerable.php:324

Deprecated: Illuminate\Support\Enumerable::first(): Implicitly marking parameter $callback as nullable is deprecated, the explicit nullable type must be used instead

Enumerable.php:432

Deprecated: Illuminate\Support\Enumerable::last(): Implicitly marking parameter $callback as nullable is deprecated, the explicit nullable type must be used instead

Enumerable.php:555

Deprecated: base64_decode(): Passing null to parameter #1 ($string) of type string is deprecated

Crypto.php:54

Deprecated: base64_decode(): Passing null to parameter #1 ($string) of type string is deprecated

Crypto.php:54

Deprecated: strpos(): Passing null to parameter #1 ($haystack) of type string is deprecated

mtd.inc:1122

Deprecated: str_replace(): Passing null to parameter #3 ($subject) of type array|string is deprecated

c93092cbfa629bc73632e690058f2a27e6e6e238.php:13

Total: 13 queries in 40.21ms

#113.91ms


    select
      d.display_name,
      d.id,
      d.use_display_name_for_consent,
      d.group_id,
      g.name as group_name,
      d.facebook_id,
      d.facebook_url,
      d.youtube_id,
      d.youtube_link,
      d.twitter_link,
      d.instagram_link,
      d.linkedin_link,
      d.tiktok_url,
      d.is_simi,
  	  d.use_km,
      d.email_enquiries,
      d.opening_hours_extra_text,
      d.reservation_days,
      d.reservation_option,
      d.finance_default_deposit_pct,
      d.use_google_reviews,
      d.google_reviews_link,
      d.google_reviews_avg_rating,
      d.google_reviews_total,
      d.finance_start_with_personal_details,
  	  d.principal,
  	  d.principal_title,
      d.slug,
      d.allow_html_description,
      d.finance_default_hp_rate,
      d.finance_default_pcp_rate,
      d.payment_provider,
      d.payment_secret_key_enc,
      d.square_access_token_enc,
      d.square_location_id,
      da.address1,
      da.address2,
      da.address3,
      da.address4,
      da.address5,
      da.postcode,
      da.map_lat,
      da.map_long,
      da.map_zoom,
      r.country_code,
      r.region,
      if (d.reservation_new_option = 0, null,  rp.cost_to_reserve) as cost_to_reserve_new
    from c_dealers d
    left join c_groups g on g.id = d.group_id
    left join c_dealer_addresses da on da.dealer_id = d.id
    left join c_country_regions r on da.region_id = r.id
    left join c_reservation_prices rp on d.reservation_new_price_id = rp.id
    where d.id = 544
   [CACHED]

#21.69ms


   select
     name,
     phone,
     email,
     is_primary_contact
   from c_dealer_website_contacts
   where dealer_id = 544
    and hide_on_website = 0
   order by sort_key
   [CACHED]

#31.65ms


    select
    h.dow,
    h.open,
    h.closed,
    h.optional_text
    from c_dealer_hours h
    where h.dealer_id = 544
    order by 1
   [CACHED]

#41.57ms


    select
    a.id,
    a.s3_image,
    a.main_image_id,
    ai.template_id,
    a.reg_year,
    a.price,
    a.mileage,
    mk.make,
    md.model
    from c_ads a
    inner join c_makes mk on a.make_id = mk.id
    inner join c_models md on a.model_id = md.id
    left join c_ad_images ai on a.main_image_id = ai.id
    where dealer_id = 544
      and a.status = 'live' AND a.expires_at > now() AND a.paused_at is null AND a.deleted_at is null AND a.web_sale_id IS NULL
      and is_dealer_special = 1
   [CACHED]

#56.58ms


      select
        d.payment_publishable_key_enc,
        d.payment_secret_key_enc
      from c_dealers d
      where d.id = 544

#61.71ms


  select
    b.home_title_tag,
    b.home_meta_desc,
    b.other_title_tag,
    b.other_meta_desc,
    b.about_us_short,
    b.map_key,
    ifnull(ifnull(b.map_company_name, b.display_name), d.display_name) as name_for_map,
    ba.country_code,
    ba.region_id,
    ba.address1,
    ba.address2,
    ba.address3,
    ba.address4,
    ba.address5,
    ba.postcode,
    ba.map_lat,
    ba.map_long,
    ba.map_zoom,
    ba.phone,
    r.country_code,
    r.region
    from c_dealer_site_briefs b
  inner join c_dealers d on b.dealer_id = d.id
  left join c_dealer_site_brief_addresses ba on b.id = ba.brief_id
  left join c_country_regions r on ba.region_id = r.id
  where d.id = 544
    and b.dealer_tag = 'boc2'
  order by b.id
  limit 1 [CACHED]

#71.7ms


  select
    b.home_title_tag,
    b.home_meta_desc,
    b.other_title_tag,
    b.other_meta_desc,
    b.about_us_short,
    b.map_key,
    ifnull(ifnull(b.map_company_name, b.display_name), d.display_name) as name_for_map,
    ba.country_code,
    ba.region_id,
    ba.address1,
    ba.address2,
    ba.address3,
    ba.address4,
    ba.address5,
    ba.postcode,
    ba.map_lat,
    ba.map_long,
    ba.map_zoom,
    ba.phone,
    r.country_code,
    r.region
    from c_dealer_site_briefs b
  inner join c_dealers d on b.dealer_id = d.id
  left join c_dealer_site_brief_addresses ba on b.id = ba.brief_id
  left join c_country_regions r on ba.region_id = r.id
  where d.id = 544
    and b.dealer_tag = 'boc2'
  order by b.id
  limit 1 [CACHED]

#82.06ms

select -- mtd_makes 544
    mk.id, mk.make 
    from c_makes mk
    inner join c_ads a on a.make_id = mk.id
    inner join c_dealers d on a.dealer_id = d.id
    where  a.dealer_id = 544
      and a.status = 'live' AND a.expires_at > now() AND a.paused_at is null AND a.deleted_at is null AND a.web_sale_id IS NULL
    
    GROUP BY mk.id, mk.make
    order by mk.make [CACHED]

#91.7ms


select -- mtd_body_types 544
t.id,t.body_type
from c_body_types t
inner join c_ads a on a.body_type_id = t.id 
inner join c_dealers d on a.dealer_id = d.id
 
  where  a.dealer_id = 544 
and a.status = 'live' AND a.expires_at > now() AND a.paused_at is null AND a.deleted_at is null AND a.web_sale_id IS NULL

group by t.id,t.body_type
order by t.body_type
   [CACHED]

#102.31ms


select -- mtd_fuel_types 544
t.id,t.fuel_type
from c_fuel_types t
inner join c_ads a on a.fuel_type_id = t.id
inner join c_dealers d on a.dealer_id = d.id
 where  a.dealer_id = 544
  
and a.status = 'live' AND a.expires_at > now() AND a.paused_at is null AND a.deleted_at is null AND a.web_sale_id IS NULL
group by t.id,t.fuel_type
order by t.sort_key
 [CACHED]

#111.79ms


select -- mtd_transmission_types 544
t.id,t.transmission_type
from c_transmission_types t
inner join c_ads a on a.transmission_type_id = t.id 
inner join c_dealers d on a.dealer_id = d.id 

  where  a.dealer_id = 544 
and a.status = 'live' AND a.expires_at > now() AND a.paused_at is null AND a.deleted_at is null AND a.web_sale_id IS NULL

group by t.id,t.transmission_type
order by t.transmission_type
   [CACHED]

#121.62ms


  SELECT deposit FROM c_finance_deposits ORDER BY deposit
   [CACHED]

#131.91ms


    SELECT max(price)
    FROM c_ads a
    INNER JOIN c_dealers d on a.dealer_id = d.id
    
    WHERE a.status = 'live' AND a.expires_at > now() AND a.paused_at is null AND a.deleted_at is null AND a.web_sale_id IS NULL
      AND  a.dealer_id = 544 [CACHED]

Memory: 6.29MBTime: 87.31ms