Send us a Message

The enquiry has been sent successfully.

Full Name *

Mobile *

Email *

Car Registration *

Enquiry *

I agree that MJ Motors may store the information submitted here in order to process my enquiry.

Get in Touch

Find us

Sales Opening Hours

Mon - Sun:

Closed

We are Closed on Bank Holidays.

Aftersales Opening Hours & Contact

Mon:	9:30am - 4:30pm
Tue - Thu:	9:30am - 5:30pm
Fri:	9:30am - 4:30pm
Sat - Sun:	Closed

Aftersales is Closed for Lunch from 1pm to 2pm.
Aftersales does not operate on any Bank Holidays.
To send us a message please select “Aftersales / Warranty” and complete the Contact Form.

Get directions

Enter your address or eircode and press ‘GO’.

Aftersales Opening Hours & Contact

Mon:	9:30am - 4:30pm
Tue - Thu:	9:30am - 5:30pm
Fri:	9:30am - 4:30pm
Sat - Sun:	Closed

Aftersales is Closed for Lunch from 1pm to 2pm.
Aftersales does not operate on any Bank Holidays.

Debug Bar(errors: 0, warnings: 73, notices: 42, queries: 20, includes: 2, time: 120.79ms)▲

No errors

Warning: Undefined array key 1

a932079e384ff49c566f93cf68c39143df352ec5.php:13

Warning: Undefined array key 2

a932079e384ff49c566f93cf68c39143df352ec5.php:14

Warning: Undefined array key 3

a932079e384ff49c566f93cf68c39143df352ec5.php:201

Warning: Undefined array key 4

a932079e384ff49c566f93cf68c39143df352ec5.php:201

Warning: Undefined array key 5

a932079e384ff49c566f93cf68c39143df352ec5.php:201

Warning: Undefined array key 8

opening-hours.php:57

Warning: Undefined array key "enquiry-type"

a932079e384ff49c566f93cf68c39143df352ec5.php:284

Warning: Undefined array key 1

130b35c85b854d0d8de6fc3f8ab0675bdbdb62c8.php:13

Warning: Undefined array key 2

nav-bar.php:13

Warning: Undefined variable $is_new_cars_page

nav-bar.php:119

Warning: Undefined array key 3

nav-bar.php:330

Warning: Undefined variable $filter

nav-bar.php:485

Warning: Undefined array key 1

e4cfe13bd6534488c23b7063f6632e9e51f28c1b.php:11

Warning: Undefined array key 2

e4cfe13bd6534488c23b7063f6632e9e51f28c1b.php:12

Warning: Undefined variable $whatsapp_phone

e4cfe13bd6534488c23b7063f6632e9e51f28c1b.php:13

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:9

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:20

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:20

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:27

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:27

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:29

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:29

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:31

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:31

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:33

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:33

Warning: Undefined variable $search_criteria

dffe420925950c5202516f8b496e35ef56fa87dc.php:42

Warning: Trying to access array offset on null

dffe420925950c5202516f8b496e35ef56fa87dc.php:42

Warning: Undefined array key 3

e4cfe13bd6534488c23b7063f6632e9e51f28c1b.php:115

Warning: Undefined array key 4

e4cfe13bd6534488c23b7063f6632e9e51f28c1b.php:115

Warning: Undefined array key 5

e4cfe13bd6534488c23b7063f6632e9e51f28c1b.php:115

Warning: Undefined array key 8

opening-hours.php:57

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

db.inc:327

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

db.inc:327

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

mtd.inc:1127

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

mtd.inc:1127

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

mtd.inc:3972

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

mtd.inc:1213

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

e4cfe13bd6534488c23b7063f6632e9e51f28c1b.php:13

Total: 20 queries in 91.3ms

#156.74ms

select text_key, value from c_dealer_site_texts where dealer_id = 544 [CACHED]

#21.25ms


    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]

#31.54ms


   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]

#41.18ms


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

#51.14ms


    select
    d.slug,
    d.name,
    h.dow,
    h.open,
    h.closed,
    h.optional_text
    from c_dealer_departments d
    left join c_dealer_hours h on h.department_id = d.id
    where d.dealer_id = 544
    order by d.sort_order, d.id, h.dow
   [CACHED]

#68.03ms


    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

#71.2ms


  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 = 'mjmotors'
  order by b.id
  limit 1 [CACHED]

#83.03ms

select display_name, email from c_dealers where id = 544

#92.9ms


  select distinct -- mtd_sales_multichoice 544
  dwc.id, dwc.name
  from c_dealer_website_contacts dwc
  where dwc.dealer_id = 544
  and dwc.enquiry_form_type = 'sales-multichoice'
  and dwc.hide_on_website = 0
  order by dwc.sort_key

#102.88ms


  select distinct -- mtd_sales_multichoice 544
  dwc.id, dwc.name,dwc.phone, dwc.email
  from c_dealer_website_contacts dwc
  where dwc.dealer_id = 544
  and dwc.enquiry_form_type = 'sales-multichoice'
  and dwc.hide_on_website = 0
  order by dwc.sort_key

#111.16ms


  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 = 'mjmotors'
  order by b.id
  limit 1 [CACHED]

#121.15ms


  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 = 'mjmotors'
  order by b.id
  limit 1 [CACHED]

#131.11ms

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]

#141.13ms


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]

#151.17ms


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]

#161.15ms


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]

#171.16ms


  SELECT deposit FROM c_finance_deposits ORDER BY deposit
   [CACHED]

#181.12ms


    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]

#191.15ms


    SELECT min(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]

#201.11ms

select show_legal_guarantee_notice from c_dealers where id = 544 [CACHED]

Project: Modular DealersMemory: 6.04MBTime: 120.79ms