Contact Us

Get in touch

SEND A MESSAGE

Send a Message

The enquiry has been sent successfully.

Contact Details

Milltown Lane,
Rathnew, Co. Wicklow

Service Opening Hours

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

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: 93, notices: 46, queries: 14, includes: 2, time: 57.33ms)▲

No errors

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 variable $whatsapp_phone

71523f01d46ee563c75dafce2830ceccf3e9f112.php:15

Warning: Undefined array key 1

71523f01d46ee563c75dafce2830ceccf3e9f112.php:23

Warning: Undefined array key 2

71523f01d46ee563c75dafce2830ceccf3e9f112.php:24

Warning: Undefined array key 3

71523f01d46ee563c75dafce2830ceccf3e9f112.php:167

Warning: Undefined array key 8

opening-hours.php:43

Warning: Undefined array key "enquiry-type"

71523f01d46ee563c75dafce2830ceccf3e9f112.php:245

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::$other_title_tag

05f98c96897194fb86a80207d584ddf4bd8af756.php:12

Warning: Undefined property: stdClass::$other_meta_desc

05f98c96897194fb86a80207d584ddf4bd8af756.php:21

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: str_replace(): Passing null to parameter #3 ($subject) of type array|string is deprecated

71523f01d46ee563c75dafce2830ceccf3e9f112.php:15

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

DealerForm.class.php:232

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

DealerForm.class.php:232

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

DealerForm.class.php:232

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

mtd.inc:3735

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: 14 queries in 27.03ms

#13.99ms


    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.9ms


   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.85ms


    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.74ms


    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]

#51.58ms


  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]

#61.69ms

select display_name, email from c_dealers where id = 544 [CACHED]

#72.11ms


  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]

#81.87ms


  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]

#91.65ms

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]

#101.98ms


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]

#111.62ms


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]

#121.73ms


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]

#131.69ms


  SELECT deposit FROM c_finance_deposits ORDER BY deposit
   [CACHED]

#141.63ms


    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: 5.99MBTime: 57.33ms